Results 1 to 3 of 3

Thread: Need help with mind bending calculations taken from values in multiple places

  1. #1

    Need help with mind bending calculations taken from values in multiple places



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I won't lie I was never too good at math. Kinda regret that now. I'm creating a project for work and need some serious help getting it done. If you're up for a challenge then read on:


    So I have two sheets in the same work book. One is for writing up an estimate to give to the customer, the other is a supply form to order materials.

    What I need done is for the cell on the supply form (Screenshot1) to add up the total quantity of each "Tear_Off" line item (Screenshot2). The hard part is, "Tear_Off", isn't going to always be in the same place for each estimate, so I need a formula that finds "Tear-Off" on the page then adds the quantity for each instance.

    After I have that number, I then need the cell to multiply that value times the waste factor on the supply page, then divide that by the coverage per bundle (screenshot3), then divide that number by the bundles per square.

    Finally, I need that number to be rounded up to the nearest bundle per square. In this instance it needs to be the next 3rd. For some shingles they come in 5 bundles per square, or 6, and so on. So I need it to be smart and figure that part out.

    Any takers?

    Work book attached
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ex1.jpg 
Views:	7 
Size:	102.6 KB 
ID:	3260   Click image for larger version. 

Name:	ex2.jpg 
Views:	3 
Size:	102.4 KB 
ID:	3261   Click image for larger version. 

Name:	ex3.jpg 
Views:	1 
Size:	106.4 KB 
ID:	3262  
    Attached Files Attached Files

  2. #2
    I might try it if you bring up your file to 2015 standards,
    otherwise it is too exacerbating.
    Here is a partial update:
    http://www.mediafire.com/view/s5cb1j...03_05_15b.xlsx

  3. #3
    Quote Originally Posted by Herbds7 View Post
    I might try it if you bring up your file to 2015 standards,
    otherwise it is too exacerbating.
    Here is a partial update:
    http://www.mediafire.com/view/s5cb1j...03_05_15b.xlsx
    Hey thanks for the response!

    What's the difference? I would need the file to work on as many versions of excel as possible. Also not sure what you did in that upload it doesn't look like you did the problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •