Helpful Spreadsheets

[ISX]

I figured I would make a sticky for these. They serve me well many times over so I want to make sure you guys can always get to them to help you out. I will be adding more and more to them all the time as I think of things to add.

The Excel file will convert over to anything else, and I have now made it work on any free program, let me know if it doesn't and I will reformulate it to keep it universal. I haven't decided whether or not to just add pages to one document and you guys just replace the new thing with your old one, or just keep adding new ones. Adding pages to one file that you guys can keep replacing and therefore "updating" it seems the most logical. Will also keep new people from having to download 10 files.

I am just going to update this #1 post over and over so you won't have to dig through this thread if it ends up getting long.

If you have any requests or ideas, PM me them or post on the thread.

This current file contains sheets for:

Power Calculations (Volts/Amps/Ohms/Watts)

kWh Costs (How much it will cost you to run something)

Conversions (Temp/Speed/Pressure/etc.)

Bolt Torque (Bolt Tightening Torques, where not provided by OEM)

MPH-RPM Calc (Figuring speed based on gear ratios)

Area and Geometry (Right triangle and circle stuff)

Engine Calculations (Bore x Stroke and some other neat things)

Mileage Statistics (More details than just MPG)

If you find any errors, let me know.

For those wanting to change some things, password on all of the sheets is "dodge".

This file will work with Excel and OpenOffice. If you are using Google Docs, use the GOOGLE file.

Note: Google Doc users will experience #DIV/0! errors due to it's limited capabilities (meaning I can't make it hide the errors). The spreadsheet will work the same but when things are blank, it will give the error, this is all how it is supposed to work and there are codes to make it blank instead of showing the error code but the IFERROR code does not work in google docs and I don't know what does so you will have to ignore the codes.

Helpful things.xls

Helpful things GOOGLE.xls

[ISX]

Updated Version 6/15/2010.Added some right triangle and circle stuff, also added bore and stroke stuff along with that power strokes thing I had up when comparing the big 3. I made the Speed/Calc a little easier to use and added some features to it. After playing around I noticed the U.S. gallon mpg to Canadian/British gallon mpg formula was backwards so I fixed that. I go over these formulas a million times so the rest should be right, I was just thinking a little backwards concerning that one :whistle:I updated post #1 files as I said I would be doing

[ISX]

Version 7/28/2010

Updated the files again. Made the conversions page 100x less busy, along with some other things to make it less confusing.

[guesswho512]

and how do i get the updated version?

[ISX]

I update the files on post #1. I didn't want to end up having them somewhere in the middle of the thread so I always delete and upload the new ones on the first.

[guesswho512]

google didn't like your equations...sent a email to you

[ISX]

google didn't like your equations...sent a email to you

I'll have to work on a google version too then. I'll try and get one up within 6 hours.

---------- Post added at 03:43 PM ---------- Previous post was at 03:02 PM ----------

Finally made the damn thing universal! I've been fighting openoffice and excel this whole time spending hours more to make it work on the other :banghead: Learned how to make it rudimentary enough to be universal

Also added another section to my list of random crap

[Mopar1973Man]

I went through you updates and I love it you did a awesome job on the sheets for gear ratio and information... Really handy ISX!

[ISX]

I went through you updates and I love it you did a awesome job on the sheets for gear ratio and information... Really handy ISX!

Well thanks. I'm actually looking for criticism Can't believe nobody told me they hated the way it was before It was daunting to think of making it better because of having to do it on excel and openoffice. I am not the greatest on openoffice and even the formula names are different and I don't know them. It converts xls to ods or something but half the time it doesn't know what to do and throws codes. I am pretty sure I have everything basic enough now that everything will work with that one file. That will make it so much easier. I just wish people would complain about it or tell me what else they wanted I have my own personal edition of this file that I had to delete several pages of stuff on since I do a lot of stuff just out of it being something neat that I don't think people care to have clutter up a spreadsheet that is supposed to be useful.

Like here is something I did and got rid of for use on this thread. Think you've seen it Mike.

[AH64ID]

Here is another one you can add to if you would like. [ATTACH]1417[/ATTACH]

Cummins Tranny.xls

[guesswho512]

Well thanks. I'm actually looking for criticism

wait no longer:lmao: sent you another email good work:thankyou:

[ISX]

I am going to call google docs and kick their ___!

AHID64, that is some good info. I have the basic parts of it but there are some things I like about yours that I don't have. Think I will integrate the things about yours into mine so it keeps it understandable. I had to stare at yours a while Very nice work though! I didn't even think of 4 lo.

---------- Post added at 06:35 AM ---------- Previous post was at 05:41 AM ----------

There you go Guesswho. Got it all fixed up in post #1.

[AH64ID]

Take what you want, and disregard the rest. I built that years ago when I was doing a lot of rock crawling, so 4LO was more important. Not so much now, but I left it. If I go to change a tire size i'll put the current tires on one side, and the proposed on the other, so I can see the effects it will have.

[Mopar1973Man]

I told ISX he needs to create a Excel sheet that does the fuel mileage log like what I got... then another one is to a maintenance log... The current software I got is really slow since my MySQL table has rather large now...http://www.lonewolf-software.com/automotivewolf.htm I'm sure ISX can build a better Excel sheet...

[ISX]

Your all determined to test my limits with excel I'll see what I can do. Problem is making it universal. It's easy to do some simple math and stuff that is universal but when you get into formulas that do a bunch of things automatically that are pretty "out there" like bringing information to your attention if it is a certain number.. gets pretty sketchy on if it will work with openoffice and probably won't work with google docs at all. But, it is a challenge. I will try and do something with fuel logs. I don't think it can have a graph since I can't get it to work on Mike's log the way he wanted it set up, I can't really do anything with graphs. I know it wouldn't be universal if I did graphs. Can you guys live without them? If you can't, I will have to go back to separate files and make it all work. Let me know which way you want it.

[ISX]

Added a few more things.

[guesswho512]

they were 33x12.5r16.5s

i'm putting them back on today so i can celebrate! i payed my 99 off today!

[ISX]

I just threw a number up there, I don't know any big tire sizes that dont use the standard way of doing it. You finally got it paid off? Now you are probably planning a trip to vegas

[bh115577]

Nice work on the spreadsheet. Lots of useful info in there. Thanks for sharing.