Kriesel Diesel - All Things Automotive   

Automotive Spreadsheets

After a few years in college, I learned a little about using excel. In the process, I've made some pretty nice spreadsheets. Here I will post a few that I have worked on, for your general usage. Please contact me with and suggestions with any and all of these. Enjoy!

Some of the excel files may be uploaded to this website as a .zip file, in order to save you time when downloading them. If you have issues opening the file, use a program like WinZip or WinRar to extract them.

 

Fuel Mileage Tracking

Here is the fuel logger that I came up with. The file is already filled out with an example. Just delete/replace all the data with your own to see your results.

Download this version for American Standard measurements:

Download this version for Metric measurements:

Download this version for simple fuel and maintenance, with no extras; no graphs of anything fancy. This is in standard measurements; if there is enough popularity I will make on for metric:

 

Welding Cost

This spreadsheet does some calculations for the cost of running a welder. You need to know a few things about the welder and such, but its a good general thing to look at if you're curious about how much money you are wasting when using your welder:

Gear Changes

This spreadsheet was made for calculating gear ratios forwards and backwards. Given a set of gears, you can calculate the speed of a vehicle. Or given a speed, rpm, and transmission gear, you can find out the most efficient final drive gear ratio. You can even find what transmission gear you want based on speed, rpm, and final drive ratio. There is also a page for tire size conversions from metric to standard, and vice-versa. Enjoy:

Actual Salary Calculator

The following spreadsheet is used for figuring one's actual salary. With a set income, and set daily/monthly losses, one can see what they are really taking home from work:

 

Related resources

  • For help with spreadsheets please contact me.
  • For help with .zip files, please contact me.
  • Also contact me with any other suggestions or questions you may have.