Reply
 
Thread Tools Display Modes
 
Old 11-03-2012, 12:45 PM   #1
Bus Nut
 
bapos's Avatar
 
Join Date: Apr 2011
Location: Cleburne TX
Posts: 606
Cost/investment spreadsheet

I was wondering if someone knew or has done a spread sheet laying out the investment they have put in to their bus? I am wanting to keep track of it as it seems it will be taking a VERY long time to do this. In the event I end up selling it off I think its easier to justify the asking cost if its well documented with receipts?


Im sure some of you wont want to know what you have in yours but again it would be nice to keep track of such things.


Thanks in Advance.
__________________
Here is my school bus conversion thread http://www.skoolie.net/forum/viewtopic.php?f=9&t=10282

Pics of my conversion @ photobucket http://s18.photobucket.com/albums/b1.../School%20Bus/
bapos is offline   Reply With Quote
Old 11-03-2012, 01:33 PM   #2
Bus Geek
 
lornaschinske's Avatar
 
Join Date: Jun 2004
Location: Roswell, NM
Posts: 3,587
Year: 1986
Coachwork: BlueBird
Chassis: 40 ft All American FE
Engine: 8.2LTA Fuel Pincher DD V8
Rated Cap: 89
Re: Cost/investment spreadsheet

I'm not keeping tons of paper receipts. No room to save all that paper. I set mine up in an OpenOffice spreadsheet.

Sheet 1: I have columns for...
DATE
SOURCE (where bought)
DESCRIPTION (to keep track of what i bought)
COST (with tax) running total at bottom of page
MATERIALS (without taxes) running total at bottom of page
VEHICLE COST & REPAIRS (cost of the bus shell plus repairs made to the actual bus not related to conversion) running total at bottom of page
PAINT running total at bottom of page
PLUMBING running total at bottom of page
APPLIANCES running total at bottom of page
INSULATION running total at bottom of page
WOOD & MATERIALS running total at bottom of page
ELECTRICAL/BATTERY SYSTEM running total at bottom of page
TOOLS (wanted to keep track of what I bought to use on the bus) running total at bottom of page
LIGHTING running total at bottom of page
HEAT/AIR running total at bottom of page
MISCELLANEOUS running total at bottom of page

Sheet 2: this page shows what I still need to buy. I keep the date/prices updated monthly so I don't end up with a nasty surprise. Once bought, I delete the row. Everything is in subcategories (Electrical, Walls, Bay Boxes, Showerstall, Cabinets, Plumbing, LP, etc). Stuff is set up more in project groups that anything else.
DATE
DESCRIPTION
PRICE EACH
QTY
COST
SHIPPING OR TAX
TOTAL
NOTES (location of where I found the item. I usually have more than one source so each source for an item (like lights) will get it's own entry/price/source.

At the bottom of the page I have
SUBTOTAL (deleting out QTY results in the items I will most likely buy with out having duplicates including the ones I won't)
"ALREADY SPENT" (from sheet 1... requires an entry that looks like this... =Sheet1.E96)
TOTAL of subtotal & Already spent. As of right now, I'm looking at a potential TOTAL investment of $3315.20, not counting the cost of the bus shell or repairs made to the bus. This does include future purchases.)

Sheet 2 also includes notes I've made (Merge Cells to make one large cell).

Sheet 3 has a couple mini spreadsheets. A few have been set up for figuring power usage for various appliances. I have a running spreadsheet dedicated for the Hydronic system (both heat/air) since it is being put together piece by piece as we get the $$ to do it. I have the results for that on Sheet 2 (Heat/Air Chiller.... =Sheet3.C36). It simply lists the individual component, have/buy, cost, Notes (where to buy). If I have bought the component, the item bought is entered on sheet 1 (Heat/Air column), $0 is entered on Sheet 3 and the remaining estimated total shows up under "heat/air chiller" on Sheet 2.

Building the BlueBird Conversion Costs spreadsheet was much easier than putting together my Fulltiming Budget Non-Budget Spreadsheet. It's 14 sheets and 12 of the sheets link back to Sheet 1. It's a budget spreadsheet I set up because I wasn't sure of where to start with a budget so this one I just fill in monthly and it extrapolates a monthly budget for next year based on actual numbers. Helps to know what we spend $ on. It's also how I discovered how much $ we spent on groceries one month ($700+) because we were buying every few days.
__________________
This post is my opinion. It is not intended to influence anyone's judgment nor do I advocate anyone do what I propose.
Fulltime since 2006
The goal of life is living in agreement with nature. Zeno (335BC-264BC)
http://lorndavi.wordpress.com/blog/
http://i570.photobucket.com/albums/s...ps0340a6ff.jpg
lornaschinske is offline   Reply With Quote
Old 11-03-2012, 01:53 PM   #3
Bus Nut
 
bapos's Avatar
 
Join Date: Apr 2011
Location: Cleburne TX
Posts: 606
Re: Cost/investment spreadsheet

lornaschinske

Can you post up your sheet with out your info in it? I think yours has a lot of details I dont need but I would rather have it and not need it than the other way around.
__________________
Here is my school bus conversion thread http://www.skoolie.net/forum/viewtopic.php?f=9&t=10282

Pics of my conversion @ photobucket http://s18.photobucket.com/albums/b1.../School%20Bus/
bapos is offline   Reply With Quote
Old 11-03-2012, 03:31 PM   #4
Bus Nut
 
GreyEagle's Avatar
 
Join Date: Apr 2011
Posts: 801
Re: Cost/investment spreadsheet

Open Office 123 has spread sheets you can make em anyway you want.......... http://www.openoffice.org/download/

Kingsoft is another check em out and take your pick ..................... http://www.kingsoftstore.com/spreadsheets-free.html
__________________
GreyEagle
Roll - On...
GreyEagle is offline   Reply With Quote
Old 11-03-2012, 03:47 PM   #5
Bus Nut
 
bapos's Avatar
 
Join Date: Apr 2011
Location: Cleburne TX
Posts: 606
Re: Cost/investment spreadsheet

I have MS office 2010 but I suck at making spreadsheets. I leave that to the pros
__________________
Here is my school bus conversion thread http://www.skoolie.net/forum/viewtopic.php?f=9&t=10282

Pics of my conversion @ photobucket http://s18.photobucket.com/albums/b1.../School%20Bus/
bapos is offline   Reply With Quote
Old 11-03-2012, 04:48 PM   #6
Bus Geek
 
lornaschinske's Avatar
 
Join Date: Jun 2004
Location: Roswell, NM
Posts: 3,587
Year: 1986
Coachwork: BlueBird
Chassis: 40 ft All American FE
Engine: 8.2LTA Fuel Pincher DD V8
Rated Cap: 89
Re: Cost/investment spreadsheet

Quote:
Originally Posted by bapos
lornaschinske

Can you post up your sheet with out your info in it? I think yours has a lot of details I dont need but I would rather have it and not need it than the other way around.
I don't know. I've never uploaded a spreadsheet to any thing but my webpage. I'll try.
__________________
This post is my opinion. It is not intended to influence anyone's judgment nor do I advocate anyone do what I propose.
Fulltime since 2006
The goal of life is living in agreement with nature. Zeno (335BC-264BC)
http://lorndavi.wordpress.com/blog/
http://i570.photobucket.com/albums/s...ps0340a6ff.jpg
lornaschinske is offline   Reply With Quote
Old 11-03-2012, 06:20 PM   #7
Bus Geek
 
lornaschinske's Avatar
 
Join Date: Jun 2004
Location: Roswell, NM
Posts: 3,587
Year: 1986
Coachwork: BlueBird
Chassis: 40 ft All American FE
Engine: 8.2LTA Fuel Pincher DD V8
Rated Cap: 89
Re: Cost/investment spreadsheet

Conversion Costs Spreadsheet Scroll down to find it. Hope it works.
__________________
This post is my opinion. It is not intended to influence anyone's judgment nor do I advocate anyone do what I propose.
Fulltime since 2006
The goal of life is living in agreement with nature. Zeno (335BC-264BC)
http://lorndavi.wordpress.com/blog/
http://i570.photobucket.com/albums/s...ps0340a6ff.jpg
lornaschinske is offline   Reply With Quote
Old 11-03-2012, 06:54 PM   #8
Site Team
 
bansil's Avatar
 
Join Date: Nov 2011
Location: MNT CITY TN
Posts: 5,045
Re: Cost/investment spreadsheet

I started an excel spreadsheet for this project(we use them all the time at work)...then I said this is just like every project I want to keep track....so I did as I did on others "click-delete"
Its not worth it to me too worry about what I wat to build...if I have $ itgoes in,if not then I do something else...only thing we track is monthy bills...
__________________
Our build La Tortuga
Accept the challenges so that you can feel the exhilaration of victory.
George S. Patton
bansil is offline   Reply With Quote
Old 11-03-2012, 07:52 PM   #9
Bus Nut
 
bapos's Avatar
 
Join Date: Apr 2011
Location: Cleburne TX
Posts: 606
Re: Cost/investment spreadsheet

lornaschinske

I downloaded so it works nicely.... Thank you
__________________
Here is my school bus conversion thread http://www.skoolie.net/forum/viewtopic.php?f=9&t=10282

Pics of my conversion @ photobucket http://s18.photobucket.com/albums/b1.../School%20Bus/
bapos is offline   Reply With Quote
Old 11-03-2012, 07:54 PM   #10
Bus Geek
 
lornaschinske's Avatar
 
Join Date: Jun 2004
Location: Roswell, NM
Posts: 3,587
Year: 1986
Coachwork: BlueBird
Chassis: 40 ft All American FE
Engine: 8.2LTA Fuel Pincher DD V8
Rated Cap: 89
Re: Cost/investment spreadsheet

We wanted to know what we were going to end up spending on the bus conversion. I hear too many folks say things like " a conversion costs more than buying a new RV outright" that it just made me curious. And it's a bit of a game. We decided when we first started this to try to do it for $5K (not counting the shell cost). I think we will be pulling it off.

As for the monthly bills, that's why I set up the fulltiming budget spreadsheet.
__________________
This post is my opinion. It is not intended to influence anyone's judgment nor do I advocate anyone do what I propose.
Fulltime since 2006
The goal of life is living in agreement with nature. Zeno (335BC-264BC)
http://lorndavi.wordpress.com/blog/
http://i570.photobucket.com/albums/s...ps0340a6ff.jpg
lornaschinske is offline   Reply With Quote
Reply

Thread Tools
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
Cost of parts Diesel Dan Conversion General Discussions 11 03-11-2013 04:56 PM
But how much did that bus cost new? roach711 Skoolie Conversion Projects 2 02-16-2012 08:42 AM
Cost of owning a bus djDK Conversion General Discussions 8 05-04-2011 01:01 PM
Wind Power Investment RickKimberly Alternative Fuels | Electric, Propane, Wood Gasification, etc. 1 06-05-2009 03:09 PM
New Guy: Cost question on Bus we are looking at Joseph97297 Conversion General Discussions 5 10-10-2007 08:57 AM

» Virginia Campgrounds

Reviews provided by

Powered by vBadvanced CMPS v3.2.3

All times are GMT -5. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.