ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals

>> Home   >> Electrical-Photos   >> Classifieds   >> Subscribe to Newsletter   >> Store  
 

Photo of the Week:

The Fine Art of Grounding
Fine Art of Grounding

Advertisement:-Left
Recent Gallery Topics:
What in Tarnation?
What in Tarnation?
by timmp, September 10
Plumber meets Electrician
Plumber meets Electrician
by timmp, September 10
Who's Online Now
0 members (), 105 guests, and 27 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
Horizontal Ad
Joined: Oct 2000
Posts: 2,724
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
Advertisement:-Right


Tools for Electricians
Tools for Electricians
 

* * * * * * *
2023 National Electrical Code (NEC)
2023 NEC + Exam Prep Study Guides Now Available!
 

Member Spotlight
TOOL_5150
TOOL_5150
Bay Area
Posts: 61
Joined: August 2007
Top Posters(30 Days)
Popular Topics(Views)
344,608 Are you busy
269,855 Re: Forum
250,492 Need opinion
New Page 2
Powered by UBB.threads™ PHP Forum Software 7.7.5