Naturally Aspirated
Posts: 78
Joined: Wed May 02, 2012 3:24 pm
Cars: 96 Jeep Grand Cherokee, 87 Chevy Suburban, and hopefully a 70 Plymouth Cuda one day.
Tue Apr 02, 2013 9:25 am
Building a Google Spreadsheet to Compare Our Engines
Hay everybody, I was thinking about developing a Google Spreadsheet and Form for anyone who wants to enter in their engines stats and compare it to the others. I've been wanting to see what everyone else has been building and generate an average for what the engines should be performing. I realized that why not just make a spreadsheet for everyone to see.
Before I actually make it I thought I would ask to see if there's anyone on here who could think of a good way to analyze all the data, or find errors in the idea that I currently have.
I. All Engine Comparison
This would be a sheet that shows all the engines that have been entered and where they rank. The rank would be decided by having an average for all the stats of the engines entered, then each engines stats would get a percent difference from average, add the percent differences up and the total would decide your rank.
II. Engine Type Comparison
This would allow you to just see where you rank for each of the engine types: I4, I6, Cross V8, Flat V8.
III. Category Comparison
I thought about it, and you might have the best overall engine but there are also people who are trying to design one for fuel efficiency or just pure performance. So I thought it would also be good to have different categories that the engines can be looked at under to see where you rank.
A. Performance: This would just compare the Power, Torque, Redline, Response, and Weight
B. Consumer Appeal: This would just compare Response, Loudness, Smoothness, Emission, and Economy
C. Consumer Cost: This would compare Lifespan, Man Hours, Material Cost, Service Cost, Economy, and Octane
D. Company Cost: This would compare Man Hours and Material Cost
Each category could still be looked at with all engines and with the engine types as well.
If you guys have any other ideas, let me know. I'm probably going to start working on it this comping weekend and add my engines on to see how well it works. The more ideas or fixes to how I'm currently thinking about it would be great though!
.:EDIT:. There would be one large negative to doing it this way, It would only be able to be in one set of measurement. I might be able to find a way to have it translate for each unit, but it would only be able to display in one type of measurement. So also post what unit you want for Power, Capacity, Weight, Octane, Economy, Torque, Length, Speed, and Speed(2).
Before I actually make it I thought I would ask to see if there's anyone on here who could think of a good way to analyze all the data, or find errors in the idea that I currently have.
I. All Engine Comparison
This would be a sheet that shows all the engines that have been entered and where they rank. The rank would be decided by having an average for all the stats of the engines entered, then each engines stats would get a percent difference from average, add the percent differences up and the total would decide your rank.
II. Engine Type Comparison
This would allow you to just see where you rank for each of the engine types: I4, I6, Cross V8, Flat V8.
III. Category Comparison
I thought about it, and you might have the best overall engine but there are also people who are trying to design one for fuel efficiency or just pure performance. So I thought it would also be good to have different categories that the engines can be looked at under to see where you rank.
A. Performance: This would just compare the Power, Torque, Redline, Response, and Weight
B. Consumer Appeal: This would just compare Response, Loudness, Smoothness, Emission, and Economy
C. Consumer Cost: This would compare Lifespan, Man Hours, Material Cost, Service Cost, Economy, and Octane
D. Company Cost: This would compare Man Hours and Material Cost
Each category could still be looked at with all engines and with the engine types as well.
If you guys have any other ideas, let me know. I'm probably going to start working on it this comping weekend and add my engines on to see how well it works. The more ideas or fixes to how I'm currently thinking about it would be great though!
.:EDIT:. There would be one large negative to doing it this way, It would only be able to be in one set of measurement. I might be able to find a way to have it translate for each unit, but it would only be able to display in one type of measurement. So also post what unit you want for Power, Capacity, Weight, Octane, Economy, Torque, Length, Speed, and Speed(2).
