• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Break my workbook

TomT

TomT

New Member
I've been staring at this for long enough now, and I need some real-world people to give it a crack. :)

To get pricing to appear on the Takeoff sheet, you'll need to go into the Tables to get some of the codes. I've left my test data in so that anyone who wishes to take a look can see how it's working. To unprotect the sheet, the password is 1111.

There's a small VBA code in there as well, to keep the Code column capitalized on the Takeoff sheet.

Happy smashing :)

Any feedback is appreciated.
 

Attachments

  • estimate_takeoff.xlsm
    65.8 KB · Views: 13
TomT

What is actually wrong or not working ?

can you please describe in more detail
 
There's nothing wrong with it (I hope). I was looking for people who could put it through the ringers and see if there's anything out of whack that I might have not noticed because I've been looking at it for days on end now.
 
Hi Tom. I'm afraid I don't know how to test it...what is the workbook doing? I'm sure someone from your field/company knows the numbers, but for a complete outside, it's a little intimidating. :)
 
Didn't mean to scare you Luke. :) The workbook is supposed to look up prices, then build an estimate based on how many of each item I enter. It calculates my taxes and labor burden automatically. Different areas can be turned On or Off, and the total will be recalculated based on what's selected.

Functionally, it appears that it's working, from all the testing I've done to it.

I'm hoping someone might look at the formulas, and possibly find a more elegant/easier way to get to the same end result.
 
You must log in or register to reply here.
Back
Top