A little help with new spreadsheet please?

Voltimax · Feb 4, 2011

Hi all,

I'm working on a new estimating spreadsheet. I've got the nuts and bolts of it together, but I could do with a little help.
Part of the spreadsheet will have ready made tasks or points. What I mean by this is common tasks where all the materials and labour allowances are bunched together. For example a double socket (flush) point. 8-10 mtrs of 2.5mm 6242Y, 2 mtrs 25mm oval (or channel), 1 x 2gang flush metal box, 1 x double socket face plate. You get my point?
Obviously most of these are easy, a single socket point, TV point, switch fuse spur point, cooker point and outlet, 1gang switch point, recessed light point etc.

Other more involved tasks/point would be say an inline shower fan with light and timer. These will have more component parts etc. So since It's hard work sitting here trying to think up all the points already mentioned, could anyone suggest other common tasks I may not think of and list the items.

There will be a reward here. Anyone that helps me out will receive a copy of this. I'll have done all the hard work putting it together all you have to do is make a few suggestions.

Just so you don't think this is pie in the sky, here are some screen shots of what I already have. This is no one page estimate spreadsheet. This is going to be quite big by the time I've finished and even then I'll most likely try to improve it.
Anyway, some screen shots:

Voltimax · Feb 5, 2011

39 views, yet no suggestions.
This reminds me of the last time I offered to share something I was producing.

johnboy6083 · Feb 5, 2011

im just writing things down mate to see if i can help you out (and me too, if i get a copy).do you want ideas for commercial things too, ie tray and unistrut?

johnboy6083 · Feb 5, 2011

CU= grommets, sleeving, testing, blanks, labelling, CU itself, MCB's (if not included), tails and earth

new supply to garage/shed: 4way CU, 1x light fitting, 2/3sockets, 15m 1.0mm for light, 20m 2.5 for sockets, say 30m 6mm2 swa, 1x glandpack(if TTing shed allow 1xrod, 1x adaptable box to seperate earth, and say 5m of 6mm g/y for the connection to rod)

bonding= tenby clamps, say 15m 10mm g/y

tray= for every 3m = 3x brackets, gutterbolts, joiners
unistrut brackets = width of tray x3 for every 3m length (x 4 if light duty or heavy loading) also zebs and penny washers

per rewire add enough on price automatically to cover screws, plugs, sleeving, drill bits ect. another idea would be to add a percent or 2 to cover these things, that would mean the larger the job, the more youve allowed for consumables.

ill keep adding if i think of anything.

Voltimax · Feb 5, 2011

Thanks johnboy, that's the kind of thing I'm after. To answer your question about commercial, at the moment I'm covering only domestic, but no reason commercial stuff can't be added. I see this spreadsheet as something that will get added to over time.
With regard to sundry items, screws, grommets, wall plugs etc, personally I add a very small percentage of the overall material cost to cover this, rather than try to list every last little item, so we're on the same page I think

Festerfly · Feb 5, 2011

great start you've made on that, very impressed!

Have you preset a labour time per item/job on the S/Sheet? If so how would that be affected say if you were doing a job in either a New build with stud walling or a 30's semi with solid Brick etc?

ukpablo · Feb 5, 2011

i already have one that somebody gave me, if u PM me i can send u a copy, may be quite useful to u? has everything on it and u could use some of the stuff off it?????

Voltimax · Feb 5, 2011

Festerfly said:
great start you've made on that, very impressed!

Have you preset a labour time per item/job on the S/Sheet? If so how would that be affected say if you were doing a job in either a New build with stud walling or a 30's semi with solid Brick etc?

Glad you asked, because I thought of that myself last night.
There isn't a screen shot above to see, but one of the sheets calculates your hourly rate based on your overheads and that's what the spreadsheet uses. What I've added in last night is a difficulty factor based on a percentage of the labour time. So for instance say it takes 3 mins to clip 1 mtr of cable, you can set a percentage to add to that based on how difficult you think that task will be. I'm unsure as to whether to have that facility on all individual items, or just as a whole on the summary sheet. What are your thoughts on this? Any suggestions?

ukpablo · Feb 5, 2011

looks good by the way, i have sent the spreadsheet to u! good luck

Voltimax · Feb 6, 2011

I thought there was a strong possibility I already had that spreadsheet and I was right, but thanks for sending it to me pablo.
The spreadsheet I'm making is very similar, the one you have is a spons one that used to be for sale on ebay. Mine will include material prices, which that one doesn't, it's labour only. Must have took the person who made it a long time though, but mine will have even more. It won't be perfect, but it's a step in the right direction I'm sure. The spreadsheet is the amalgamation of many ideas taken from other spreadsheets, including construction and American electrical spreadsheets I've obtained.

ukpablo · Feb 6, 2011

cool, like i said if u need any more help just let me know. i did send off for electrika's free software, but was too complex for what i need. Instead of lets say breaking down each component part for a standard CU change, u would only need a column for the set price u charge as u know what bits u require
ie cu x1 set price £390..........hrs x 8 etc.............then any extra bonding could be added with length in metres, man hrs with installation method etc!
just a thought anyway.

chiplard · Feb 6, 2011

Funnily enough I have just started work on my own spreadsheet. Long way to go before it looks anything like yours i hasten to add!!!!

Have you thought about the cost of diesel getting to the jobs?

With regards to the sundries i have a column that automatically counts up the number of sockets, light switches fans etc etc and adds a price of 50p per accessory. A lighting circuit with wagos would obviously be a lot more than this but a socket/switch would be considerably less.

You have gone into more detail with regards to the labour charge than me. I have just used an hourly rate and guestimated the time it would take to do a certain job. Again, some jobs you will gain and some jobs you will lose but it does average itself out.

Good luck with yours, looking good already!

Voltimax · Feb 6, 2011

Well the sheet that is labeled 'points' will have set tasks. There is no reason why they have to draw from the other sheets. Like a consumer unit as per pablo's suggestion.
The points and Tasks sheet will be the biggest headache for me, that's why I've asked for hep.

Chiplard, that's a good idea for sundry items and can easily be added into what I already have.

Guys, keep the suggestions coming, it's amazing what I can miss in the wee hours *yawn*
I may not be able to do everything that is suggested (No VBA skills in Excel I'm afraid), but I'll try.
Like I said, anyone that contributes will get a copy.

Amp David · Feb 6, 2011

With the comment regards the costs for fuel and trravel, I tend to use 2 or 3 rates for jobs that are local, jobs that are upto 15 miles and then anything upto 30 miles.

So you could include different rates, be it hourly or daily.

Excel gives my brain a good hiding when I use it to do my books, never mind trying to create some as complexed as you're doing. Good luck and hope you manage to finish it.

shakerbess · Feb 6, 2011

hi i think its cool wish i had the brains to do something like that lol could i get a copy off somebody would be great thankyou wish i had an idea to put forward

A little help with new spreadsheet please?

Voltimax

-

Attachments

Voltimax

-

johnboy6083

-

johnboy6083

-

Voltimax

-

Festerfly

ukpablo

Voltimax

-

ukpablo

Voltimax

-

ukpablo

chiplard

Voltimax

-

Amp David

-

shakerbess

-

Similar threads

OFFICIAL SPONSORS

YOUR Unread Posts