ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
ShoutChat
Recent Posts
2023 CEU Course
by gfretwell - 07/17/24 01:08 AM
Is this really a thing
by dsk - 07/16/24 01:23 PM
90.5(C) Explanatory Material 2023
by gfretwell - 07/16/24 12:14 PM
Hello... again!
by Bill Addiss - 07/15/24 07:14 PM
Counterfeit Code Books?
by Comprehensiveedu - 07/12/24 12:16 PM
New in the Gallery:
This is a new one
This is a new one
by timmp, September 24
Few pics I found
Few pics I found
by timmp, August 15
Who's Online Now
0 members (), 162 guests, and 8 robots.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
#169075 09/24/07 09:15 PM
Joined: Apr 2002
Posts: 32
S
sudsy4 Offline OP
Member
Hi

I'm looking for a printable take-off list to do my material ordering so I don't miss stupid but important little things.
This use to be a normal part of doing a take-off before computers. All leads sre greatly appreciated....get my owner and myself of my butt!

Thanks
Bill


Bill
Joined: Oct 2000
Posts: 2,723
Likes: 1
Broom Pusher and
Member
You could compile your own Takeoff tally sheets in an application like MS Word, or better yet, MS Excel.

It may take a few days to get everything setup right + list everything, but the sheets will be "Tailor-Made" for your liking, and you have the added benefit of easilly revising areas in the future, to suit your needs.

To go the "Geek Route" (more like the "Less Amount Of Redundant Data Entry" Route), compile the Takeoff Tally pages as Spreadsheets with an application like Excel.

This method allows you to create custom tally pages, which you may print out for "Hard Copy Data Entry", but also allows you to automate the same pages for keying in data.

Example:
Say you have a Takeoff page for entering in a number of General Purpose Receptacle outlets, taken off of the Planset.

You could have a couple of "Cells" on one spreadsheet, where you enter the number of Receptacle Outlets.
This Cell's entry automatically tallies up the following items per each Receptacle Unit:
* Receptacle Device,
* Cover Plate,
* Outlet Box,
* Makeup (Wirenuts, ground screws, etc.),
* Plaster Ring,
* Mounting means,
* Connectors.

In addition, you could include an additional routine to tally up Branch Circuit Assemblies, for the number of Receptacle Outlets you enter in that same cell - be it a Cable Assembly, or Conduit Assembly.

Same can be applied to many other Takeoff listings, reducing the time + labor needed to compile the BOM, plus greatly reducing the chances of forgetting things to be included for given items (like Lamps for Fixtures and such).

The initial time investment is large, but it does payoff over time, plus it reduces your work load - while increasing accuracy.

For the ultimate extreme geekmanship ideas, have the spreadsheets insert text into the data entry fields of your estimation application!
Now all you need to do is key in takeoff items, then pass on the spreadsheet to the owner for final number crunching.

If this sounds far too advanced, and you would be happy with some printed database pages for takeoffs, just poke around Excel (or Access if you have it), and build your own to print.

Good luck and have fun! wink

Scott


Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Joined: Apr 2002
Posts: 32
S
sudsy4 Offline OP
Member
Thanks for the info, I'm already working on an excell spreadsheet, was hopping someone may have already had one started. Will post such when I complete mine.

Bill


Bill

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.5