|
1 members (Scott35),
459
guests, and
14
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
Anonymous
Unregistered
|
Wow! Virgil, you put a lot of work into that.
BTW I just chose to open the file in Excel and it opened fine.
I make my own bidding spread sheets as well. Wonder if you have considered using separate sheets for each of your rooms and then post the room info to a last page summary sheet.
You could also have a "general conditions" sheet for any oddball items ,say, temp power, travel etc.
Whatever, looks great, Kent
|
|
|
|
|
Joined: Aug 2004
Posts: 34
Member
|
Vigil. Great work. Thank you I downloaded all three. I do not do much redidential work so this should help. Again thank you very much
|
|
|
|
|
Joined: Nov 2000
Posts: 2,236 Likes: 1
OP
Member
|
kentvw, et al, Wonder if you have considered using separate sheets for each of your rooms and then post the room info to a last page summary sheet.
Well, I have... but I've don't know how to make spreadsheets "talk" to each other, or mine databases, etc. I'm sure there must be a way, because it would be way too useful to not be... The info on how would revolutionize my spreadsheet experimentation! Help me if any of you know how!!!
-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
|
|
|
|
|
Joined: Apr 2002
Posts: 156
Member
|
Not sure if this would work for you but I will take a stab at it. On the bottom of Excel you have a few tabs....default is sheet1, sheet2, etc. You can customize the tabs to read bedroom 1, bedroom 2, etc. Then make one sheet summary and reference the cells from the other sheets. Hope this helps. http://www.mvps.org/links.html#Excel Check here if you need some help with excel. Great stuff for anything M$ in fact. [This message has been edited by kinetic (edited 01-17-2005).]
|
|
|
|
|
|
Anonymous
Unregistered
|
sparky
It is easy as was posted by kinetic when you right click the page tab on the bottom you are given an option to add a sheet and also to rename the sheet as in bedRoom-1. The name will need to run together and not have any spaces. OK so say I have added a column of numbers and have my total for that column in D52 I can take that information and copy it to any sheet. Just go to ,Let's say, the summary sheet and type in -
='PageName'!D52
PageName will be what ever you decided to name that page.
Also, If you set up a template sheet on say page #1 You can right click in the very top right of the page and hit "copy" then go to the next page, click the top left corner right click and hit "paste.
You can create some really cool spread sheets this way. I usually send my proposals over a fax. So my first sheet is a fax cover and my second sheet is my proposal My estimate sheets are stacked up behind these and my summary is the last sheet. I only need to type in the recipients name,fax,job, etc and the info is copied to any cell I wish on any sheet.
What is great about a summary sheet is that you can set cells up to change say sales tax rates or labor rates or profit percentages one time and all the math is taken care of. Even your final price can be put on your proposal sheet automatically.
I tried to paste in the bottom part of my summary sheet but it did not show the cells in perspective. However, it might give you some ideas.
Total Material $1,445.00 Total Hours 8.00
General Conditions 1.50% $21.68 10.00% 0.8
Total Material $1,466.68 Total Hours 8.8
Tax Rate 7.20% Labor Rate $50.00
Tax Total $105.60 Labor $ $440.00
Material and Tax $1,572.28
Labor Amount $440.00
Material and Labor Total $2,012.28
Overhead and Profit Percentage 15%
Overhead and Profit Value $301.84
Sub Total Job Value $2,314.12
Permit
Fire Alarm Permit
Total Job Value $2,314
Overhead and Profit + Labor $741.84
|
|
|
|
|
Joined: Nov 2000
Posts: 2,236 Likes: 1
OP
Member
|
Hmmm...
Works don't have the tabs and I don't have Excell...
Guess I'll have to get it!
(I used to have it, but that was a lifetime ago...)
-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
|
|
|
|
|
Joined: Nov 2000
Posts: 2,236 Likes: 1
OP
Member
|
WARNING!!!
Re: Residential Bid Calculator v1.0 through 1.41
If you are in such a high competition area that you must use #14 on receptacle circuits to make a profit, this spreadsheet is woefully inaccurate for your needs!
-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
|
|
|
|
|
Joined: Apr 2002
Posts: 156
Member
|
Look for either the Small Business edition or Student Teachers editon. With Small Business you get the normal stuff plus publisher. Student and Teachers is cheap but you can't use it to upgrade in the future.
|
|
|
|
|
Joined: Jan 2005
Posts: 53
Member
|
im by far not a computer guru but i need to save the calc to a disc for use on another computer and it wont open on 2nd comp any ideas for you overly smart computer type fellas?
|
|
|
|
|
Joined: Jul 2002
Posts: 717
Member
|
I am by no means a computer expert, but this is the trick I used to open it. When I downloaded the program it would not open with my copy of Excel 2004 for the macintosh. By changing the three letters after the .(dot) in the name of the file toe xls it opens just fine. Maybe your version of Excel is looking for a different name after the dot also.
|
|
|
|
Posts: 70
Joined: January 2002
|
|
|
|
