This tool helps to get dyno curve translated to numbers bit easier, there are few steps, but after you get used to tool, it is quite bit faster and gives bit more accurate results than just guessing. Resulting table can be pasted to my other Spreadsheet that converts real world torque to Jbeam torque, which you can find from content creation section here https://www.beamng.com/threads/turbo-torque-curve-helper-alpha-testers-needed.52512/ just make sure you paste only values, not formatting, so things don't get messed up and paste only one column at the time. Some day I combine these two tools and make automation for that, but only when these are better. You will need macros enabled for this to work. Also you will need Excel for macros to work. Alternatively you can copy paste calculated values manually to list page, it is few clicks more that way though, but it still might be useful, but do not ODS version does not have macros and is provided without much of support because I don't know much about Libre Office. Disclaimer, if your computer gets messed up, blows up, or if your mother yells at you, I'm not responsible any of that, use at your own risk. There might be bugs, I try to fix them if you report them. Step1: -Cell B3 set maximum torque of your graph in units that are in graph -Cell C3 set maximum torque of your graph in Nm (this gives ratio that is used to calculate Nm values, no matter what units Tq curve originally has, if Torque curve is in Nm set both cells to same value) -Cell C6, G6, how many rpm and how much torque there is between bins (see image) -Cell D6, H10, in Irfan view select one whole square as shown, look up and see how many pixels is between rpm bin and Tq bin, fill cells accordingly -Cell C8, G8, rpm line below your desired point in the curve (desired point is beginning of curve at 1250rpm), same for Tq line. Step 2: -Cell C8, G8, same as step 1 on first round, but next round's point will be 1500rpm so base rpm is 1500 and next 2000rpm so base rpm will be 2000 and so on, you keep going through step 2 to step 6 numerous of times. -Cells D8, H8, select from base rpm and base torque to desired point in curve, look from top of Irfan view how many pixels to add to base rpm and base Tq, spreadsheet will calculate your RPM and Tq NOTE: Sometimes, desired point in curve is not matching perfectly to 1 pixel, you can see here I had to estimate 10.5 pixels for 1250rpm, you have to use your brain to fill missing data. Step3: (needed only if you did not do this in Step 6): -Select Sheet named Tq List (still old name in pic) -Select RPM cell you wish to paste your rpm to, usually first one without numbers -this tells spreadsheet where to copy value to Step 4: -Select sheet named 'Tq to table' (still old name in pic 'Sheet 1') -Click button add, next to Cell E8 Step 5: -Make sure you are in Sheet Tq List (you should be) -Select first free cell from Input Tq column (Column B) (you should see your rpm at column B) Step 6: -Select sheet 'Tq to table' (still old name in pic 'Sheet 1') -Click button add, next to Cell I8 -Select next free RPM cell, this saves from doing Step 3 on next round. -Select sheet 'Tq to table' (still old name in pic 'Sheet 1') return to Step 2
This kind of torque curve is bit hard to get converted to table form and is reason why I made this tool. As there are no vertical lines and as rpm is only at 500rpm resolution, it is bit hard to get good matching curve, lots of work, but it is much faster with the tool. With Irfan View it is handy to just pull selection rectangle from rpm numbers to torque curve, then scale to what you see image above to get how many pixels there is, you can get as good resolution as you want with this method: As a bonus, tool converts Lb-ft to Nm, you need to only make one conversion for maximum torque and input that to spreadsheet and rest of values gets converted automatically on listing page, so it saves little bit of work. For me this tool easily halves time it takes to get torque curve to table and improves accuracy greatly.
