ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
ShoutChat
Recent Posts
nec 110.3 (B)
by gfretwell - 09/22/21 11:11 PM
Grounding electrodes
by gfretwell - 09/07/21 03:41 PM
Looking For Electricians in the Midlands
by Alex247 - 09/06/21 05:26 AM
New in the Gallery:
Now you know.
Now you know.
by Tom_Horne, September 7
February, North East Indiana
February, North East Indiana
by timmp, July 25
Who's Online Now
1 members (HotLine1), 46 guests, and 16 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,721
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
Featured:

Tools for Electricians
Tools for Electricians
 

* * * * * * *

2020 Master Electrician Exam Preparation Combos
2020 NEC Electrician
Exam Prep Combos:
Master / Journeyman

 

Member Spotlight
HCE727
HCE727
Delaware County, PA, USA
Posts: 187
Joined: November 2005
Top Posters(30 Days)
timmp 3
FGBY 2
Popular Topics(Views)
283,041 Are you busy
216,770 Re: Forum
203,168 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.7.5