Go Back   DIY Chatroom Home Improvement Forum > Home Improvement > Building & Construction

CLICK HERE AND JOIN OUR COMMUNITY TODAY...IT'S FREE!

Reply
 
Thread Tools Search this Thread Display Modes
Old 05-24-2010, 09:36 AM   #1
Newbie
 
Join Date: Feb 2008
Posts: 25
Share |
Default

Cost Tracking Spreadsheet?


I am about to embark on finishing my basement, but wanted to track my costs.

Does anyone know of a decent spreadsheet for estimating costs and tracking them?

I don't know crap about excel!

wesley8808 is offline   Reply With Quote
Old 05-24-2010, 10:18 AM   #2
Civil Engineer
 
Join Date: Mar 2009
Location: Boston
Posts: 4,122
Default

Cost Tracking Spreadsheet?


If you don't know anything about Excel, chances are you aren't going to like commercial spreadsheets, which are often specific applications of Excel to estimating. But for finishing a basement, I can't imagine why you need a complicated spreadsheet, just track the costs by hand, I mean, what do you have, some lumber, drywall, paint, maybe some tile? People have been making budgets for 50,000 years without computers, the Egyptians built the pyramids, and so far as I know, they used papyrus to track their costs.

Daniel Holzman is online now   Reply With Quote
Old 05-24-2010, 10:38 AM   #3
Newbie
 
Join Date: Feb 2008
Posts: 25
Default

Cost Tracking Spreadsheet?


True, but in the modern world with iPhone Apps, iPads, Windows 7, etc I didn't know if someone might have had a basic spreadsheet they could recommend.

I am computer literate, just not proficient enough to put together a spreadsheet detailing cost where it adds up against a budget etc. Or if it was broken down by phase.
wesley8808 is offline   Reply With Quote
Old 05-24-2010, 11:34 AM   #4
Member
 
Join Date: Jul 2008
Location: NW of D.C.
Posts: 5,990
Default

Cost Tracking Spreadsheet?


What are your inputs and what are your desired outputs? We can fill in the cell formulas for you.
The '$' symbol comes in handy for this type of thing along with formatting and clicking and dragging cell contents.

It's very repetitive. Getting a format that looks pleasing on the screen is half the job. I had the 4 pound, $40 book on Excel but I learned more from a co-op student college kid than I did from the book.

Last edited by Yoyizit; 05-24-2010 at 11:37 AM.
Yoyizit is offline   Reply With Quote
Old 05-24-2010, 09:19 PM   #5
Member
 
Join Date: Mar 2010
Location: New York
Posts: 1,715
Default

Cost Tracking Spreadsheet?


Excel is the way to go. My excel experience is more focused on statistics but it is basically a big multitasking calculator that saves a lot of time and well worth learning.

Tried uploading a sample .xls file but wasn't able to do it.

Last edited by Jim F; 05-24-2010 at 09:42 PM.
Jim F is offline   Reply With Quote
Old 05-24-2010, 10:45 PM   #6
Member
 
Join Date: Jan 2009
Location: South of Boston, MA
Posts: 17,248
Default

Cost Tracking Spreadsheet?


I use excel & just list the items I need/buy
QTY of item
Then cost
Multiply out & then total
There's always more that I need, I just keep adding on
Or you can just track total purchases (each receipt) if you don't want it itemized

If you want a rough idea in advance:
HD, Lowes or a lumber store might have some software where you can input room size & it will give you an estimate

I make a zip file of excel to upload them here
Scuba_Dave is offline   Reply With Quote
The Following 2 Users Say Thank You to Scuba_Dave For This Useful Post:
Jim F (05-25-2010), wesley8808 (05-26-2010)
Old 05-25-2010, 09:15 AM   #7
Newbie
 
Join Date: Feb 2008
Posts: 25
Default

Cost Tracking Spreadsheet?


Yeah, that is really all I did. I made a running list of materials I need, went to Lowes and priced it out. Then have been doing some internet research for some better costs if they are out there.

I appreciate the advice!
wesley8808 is offline   Reply With Quote
Old 05-25-2010, 04:54 PM   #8
Member
 
Join Date: Mar 2010
Location: New York
Posts: 1,715
Default

Cost Tracking Spreadsheet?


Hey that zip file worked. This is something like I might do with excel. It is formulated so you can enter your item names in the first column, next price, then number of item. It is formulated to give you a line item total, an overall total then subtract from your budget, say it was 20000. You can enter any numbers you want in the cells it should total everything up.
Attached Files
File Type: zip Basement Budget.zip (2.8 KB, 967 views)
Jim F is offline   Reply With Quote
The Following User Says Thank You to Jim F For This Useful Post:
wesley8808 (05-26-2010)
Old 05-25-2010, 06:27 PM   #9
Member
 
Join Date: Jul 2008
Location: NJ
Posts: 240
Default

Cost Tracking Spreadsheet?


Quote:
Originally Posted by Jim F View Post
Excel is the way to go. My excel experience is more focused on statistics but it is basically a big multitasking calculator that saves a lot of time and well worth learning.

Tried uploading a sample .xls file but wasn't able to do it.
I hear you, Excel really is worth learning.
rustyjames is online now   Reply With Quote
Old 05-25-2010, 06:42 PM   #10
Member
 
Join Date: Jul 2008
Location: NW of D.C.
Posts: 5,990
Default

Cost Tracking Spreadsheet?


Quote:
Originally Posted by Jim F View Post
Hey that zip file worked.
Can you step me through how you loaded an executable file to this forum?
Yoyizit is offline   Reply With Quote
Old 05-25-2010, 06:59 PM   #11
Member
 
Join Date: Mar 2010
Location: New York
Posts: 1,715
Default

Cost Tracking Spreadsheet?


Like Dave said just put it in a zip file. After I saved it to my desktop, I right-clicked then selected send to, then compressed (zip) folder. Other ways, I'm sure but that's the way I know.
Jim F is offline   Reply With Quote
Old 05-26-2010, 08:39 AM   #12
Newbie
 
Join Date: Feb 2008
Posts: 25
Smile

Cost Tracking Spreadsheet?


Thank you for the help! That excel works perfect.

I just want to keep track of what I am spending so the whole thing doesn't get out of control.

wesley8808 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Furnace Installation Cost philstewart HVAC 32 04-13-2014 01:44 PM
Heatpump vs Natural Gas - Energy Cost Spreadsheet zootjeff HVAC 8 11-19-2011 10:45 PM
Can we get a cost estimate subforum going Will1987 Site Help and Suggestions 8 04-02-2009 07:57 AM
Hot Water Heater Installation Cost philstewart Plumbing 6 10-29-2008 05:05 PM




Top of Page | View New Posts

Copyright © 2003-2014 Escalate Media. All Rights Reserved.