I recently needed to convert the specs in my factory manual for use on the Megajolt. I created a simple spreadsheet to help me out, so I thought I'd post it here as it may help somebody else out.
The attachment is a zip file that contains two spreadsheets, both are the same, but one is in .odf format for us OpenOffice users and I've also saved a copy as .xls for those of you that use Microsoft Office. As it was created in OpenOffice, I can't vouch 100% on how it will look in Microsoft Office, especially the chart, but as the chart is simply eye candy, it doesn't effect the results, but the functionality should be the same in either.
All this does is take the centrifugal and vacuum advance specs from your factory manual, adds the static advance and creates a grid of values for the Megajolt. It has a simple inHG converter as in my experience (old cars) the specs are generally in inHG. This will take a inHG value and show its equivalent in kPa and Absolute pressure for the Megajolt. It can also be advanced, or retarded by a certain percentage. I guessed this would help if a small overall advance retard might be needed for say higher, or lower octane fuel. I know this a simplistic view, but that is what this sheet is for, to get a starter map sorted from the specs that can then be tweaked further.
----
First enter your factory static advance value, then find the centrifugal and vacuum advance specs in your factory manual and enter them.
Centrifugal advance:
Edit the RPM reference values to the same as the ones used in the manual, then enter the centrifugal advance values at those RPMs in the column to the right.
Vacuum advance:
Edit the kPa reference values to those used in your manual and in the column to the right, enter the values at those kPa's
The correct reference RPM and kPa values as well as the map values will be filled in in the lower map grid.
NOTE: You may need to convert inHG in your factory manual to kPa, then to absolute pressure for the Megajolt. I've included a converter in the spreadsheet an
d it is based on the following except it rounds to the nearest whole number.
1 inHG = 3.38638866667 kPa (lets round that down to 3.4 kPa)
If your spec lists a value as 14 degrees at 7 inHG...
7 (inHG) x 3.4 = 23.8 kPa. To convert that to absolute pressure, 102 (atmosphere) - 23.8 kPa = 78.2 (round up/down) 78 kPa megajolt reference value.
Final values to enter would be 14 degrees at 78 kPa.
The conversion 1 inHG = 3.38638866667 kPa was taken from: http://www.convertunits.com/from/inch+o ... kilopascal
The conversion to Megajolt values from kPa was taken from : http://www.autosportlabs.org/viewtopic. ... =inhg#6740
----
This helped me quickly build starter maps based on the high, mid and low areas of the range in the specifications of my Spitfire Mk1 (1963) before tweaking commenced.
![Smile :)](./images/smilies/icon_smile.gif)
Hope it is of some help to somebody and if the chart is broken in Microsofts Office, maybe somebody could fix it (surface chart best) and re-post it here. Sorry, I don't own Microsoft Office, so can't test it.
***UPDATED***
I've just uploaded the latest version of these sheets. The Microsoft office version has now been tested and updated for that platform.
I've added two 2D charts. One to graphically show the curve for the mechanical advance and another for the vacuum. This means that the layout is also slightly different. Update any value and watch your curve change.
![Cool 8)](./images/smilies/icon_cool.gif)
The values in the spreadsheet are the values that I'm currently playing around with for my mk1 spit.
***UPDATE-2*** (6 April 2010)
I've just uploaded the latest version of the sheets.
I've improved the converter to include a drop down selection of what you're converting from and added PSI to the list of what it can be converted from/to.
There are a few other cosmetic changes too. I've colour coded the inputs...
Blue = RPM and kPa reference values to be input
Yellow = Actual degree values at the above (Blue) reference values
Green = The converter input value
Red Text = Drop down unit list to select value to convert from
Red Background = Cells where referenced kPa is in boost territory (turbo)(greater than absolute 102kPa) will have red backgrounds
I've removed/moved a couple of headings and changed the vac-adv chart title to ABS kPa.
Apart from the improved conversions, the basic functionality is the same, but it's now easier to edit and navigate with these small cosmetic changes.
***UPDATE 3*** (18 April 2011)
Thanks to Spandit there is an update to the xls version of this spreadsheet. With his modification, you can paste the values directly into the Megajolt software, or create a new file.
For details of the changes and to download the file that he's attached, you should check out his post further down this thread. (for me it is the first post on page two of the thread).
Nige