User Tag List

Reply
 
LinkBack Thread Tools
  #1  
Old 12-30-2011, 10:43 PM
shadowsknight's Avatar
Member
Thread Starter
Join Date: Apr 2006
Location: Austin, TX
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Thumbs up An Open Office Spreadsheet

Over the past several years my wife and I have been refining an Open Office spreadsheet to keep track of load pay, fuel, time on the road, and expenses. Everything has it's own tab. The tabs are at the bottom of the document. Lower left.

If you are not familiar with Open Office it is a free office suite like Microsoft office. You can read about it or download it here. OpenOffice.org - The Free and Open Productivity Suite
I will do not know if it will correctly convert into an MS Office Excel format. I'd rather use free software then paid.

As for my spreadsheet it is set up for me as an O/O that gets paid based on percentage of the load. (72%....you'll see it in the equations)
There is a summary page that my wife uses when she files taxes. Everything sorts by month and it is very easy to use. The expenses tab has drop downs that are sorted like the schedule C.
Don't ask me to make changes for you....I'm too busy...mostly tarping and strapping.

My favorite part is the fuel tab. In Column M Pd Total is what I actually paid when it shows up on my paycheck. This way I can track the difference between what the pump says and what I actually paid when it showed up on my paycheck. So far this year I have saved over $8000 dollars off of the pump price.

If you have any questions email me at [email protected]

The doc is hosted at google. https://docs.google.com/open?id=0B1B...ZlYmZkMGY2YmM5

Good luck in the new year.
Keith
__________________
TMC Texas Dedicated Owner Operator
http://www.flickr.com/photos/shadowsknight

You are a rumor, recognizable only as deja vu, and dismissed just as quickly. You don't exist. You were never even born. Anonymity is your name, silence is your native tongue. You are no longer part of the system. You are above the system, over it, beyond it. We are "them." We are "they." We are the Men in Black.

We either hang together or we will be hanged seperately. -Benjamin Franklin 1767

Last edited by shadowsknight; 12-30-2011 at 10:47 PM.
Reply With Quote
  #2  
Old 12-30-2011, 11:43 PM
Windwalker's Avatar
Board Icon
Join Date: Oct 2005
Location: Been there and gone...
Posts: 6,412
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Default

I'm quite familiar with "OpenOffice.Org". It's software that comes standard with Linux. I've been using it for aboput aq year now, and I like it better than Nicrosoft. Something I wish I had back when I was driving.
__________________
( R E T I R E D , and glad of it)
YES ! ! ! There is life after trucking.
a GOOD life

Reply With Quote
  #3  
Old 12-31-2011, 02:12 AM
GMAN's Avatar
Administrator
Site Admin
Board Icon
Join Date: Feb 2005
Location: Tennessee
Posts: 17,097
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

I believe you can download extentions that will allow you to use openoffice in microsoft office.
Reply With Quote
  #4  
Old 12-31-2011, 04:11 AM
Musicman's Avatar
Senior Board Member
Join Date: Dec 2005
Location: Southern IL
Posts: 790
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

Not a bad job at all, shadowsknight. It’s not something I will use, as I have my own set of spreadsheets I’ve developed over the years, but what you’ve created is quite functional and I’m sure many on here would be able to benefit from your hard work and willingness to share.

I downloaded and my Microsoft Excel 2010 opened the file by default. I saved as an xlsx file and it works fine. I don’t know if older versions of Excel will open the file, but if anybody wants a copy that is in an older version of Excel, PM me with an email address and I’ll send it to you.
__________________
"The Breakfast of Champions isn't cereal, it's the competition!" - "Success is how high you bounce when you hit bottom." - "An appeaser is one who feeds a crocodile, hoping it will eat him last."
Reply With Quote
  #5  
Old 12-31-2011, 04:18 AM
YerDaddy's Avatar
Board Regular
Join Date: Mar 2008
Location: @ my keyboard
Posts: 226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

Never used tabs. I just use rows and columns. 1 row per day, 1 column per item, 1 page per month and a yearly total page.

It still sucks entering in all the numbers.

Bookkeeping is the worst part about running a biz.
__________________
The reason I'm a narcissist is cause everyone else is so lame.
Reply With Quote
  #6  
Old 12-31-2011, 05:54 AM
Musicman's Avatar
Senior Board Member
Join Date: Dec 2005
Location: Southern IL
Posts: 790
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

The one thing I’ve changed over the years is to NOT put all my eggs (or in this case, worksheets) in one basket (or workbook). If the file is corrupted, even with backups, it is just that much more work to get all your data back up and running again. I used to have everything in one workbook and even have fuel data from years past all in that one file. A couple years ago after a scary incident where we almost lost that all-in-one data file I decided to split up each tab into its own workbook and store the resulting files on a cloud based network drive for safe keeping. The upside to this is that my files are accessible from any computer with internet access, meaning that I can make entries in a file from my truck and my wife (my office girl) can immediately read or modify the data from our home office. I have my network drive set to save the last ten versions of each file, so if I ever have a corruption in a file, I can easily retrieve everything up to the last saved version.
__________________
"The Breakfast of Champions isn't cereal, it's the competition!" - "Success is how high you bounce when you hit bottom." - "An appeaser is one who feeds a crocodile, hoping it will eat him last."
Reply With Quote
  #7  
Old 12-31-2011, 12:33 PM
Windwalker's Avatar
Board Icon
Join Date: Oct 2005
Location: Been there and gone...
Posts: 6,412
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Default

For my current use of spreadsheets, I store the data and templates on two flash drives. One, the original, the other a duplicate. I've had hard drives die and lost everything. Now, it's a simple matter of replacing the hard drive, reloading the operating system, plug in the flash drive, and everything is right back. The duplicate flash drive is because if one of them goes bad, I have a back up, and it's a simple matter to copy everything onto a third so that i maintain a back up.

I've also lost family pictures that i can not replace because they were taken with a digital camera and I trusted them to a hard drive. At least, with my operating system, I don't have to worry about virus anymore. That used to be a source of consternation before too. Coming up with a "blue screen" meant reloading the operating system into a formatted drive and all data was lost again. (And my luck with CD-R has been... Memorable...) Flash drives seem to work far better for data storage. The only thing I actually use the computer for is processing the data.
__________________
( R E T I R E D , and glad of it)
YES ! ! ! There is life after trucking.
a GOOD life

Reply With Quote
  #8  
Old 01-01-2012, 02:51 PM
YerDaddy's Avatar
Board Regular
Join Date: Mar 2008
Location: @ my keyboard
Posts: 226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

I always email my Income/Expense and Fuel mpg spreadsheets to myself at my Yahoo account when I enter anything new, besides backing them up on a USB stick and periodically on external drives.
__________________
The reason I'm a narcissist is cause everyone else is so lame.
Reply With Quote
  #9  
Old 01-01-2012, 03:34 PM
GMAN's Avatar
Administrator
Site Admin
Board Icon
Join Date: Feb 2005
Location: Tennessee
Posts: 17,097
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 1 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Default

[QUOTE=YerDaddy;506977]I always email my Income/Expense and Fuel mpg spreadsheets to myself at my Yahoo account when I enter anything new, besides backing them up on a USB stick and periodically on external drives.[/QUOTE


That is a good idea to email them to yourself. I wish that I had done that a couple of years ago before my system crashed.
Reply With Quote
Reply





Thread Tools

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 On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 10:05 AM.


User Alert System provided by Advanced User Tagging v3.3.0 (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.