Fill out details on each page, in the white boxes.
Then go to “Export” page press Ctrl-A, then Ctrl-C, paste into your TGM file, don't worry about any slight problems with formatting, tTool will take care of it!
Keep in mind this spreadsheet is still WIP, so things will change and hopefully improve.
Grey 'boxes' are generally either 'unimplemented' or it's recommended not to touch those values as they may contain formulas. See the “Keys” to the right side →
Only symmetrical tyres are fully supported, for now, though recent changes should make non-symmetrical tyres work it has not been thoroughly tested.
Cells are unprotected, so it's easily screw something up...
'General / Easy' sheet is incomplete and still under brain-storming phase. So it doesn’t fully influence the tyre in the way that you might expect.
Please ensure you are running the V5.4 branch of LibreOffice. (https://www.libreoffice.org/download/download/?type=win-x86_64&version=5.4.6&lang=en-US)
This spreadsheet is optimised for resolutions of 2560x1440 or greater (but should be OK for 1080p).
Basic Procedure:
1) Set your pTool Tyre Folder Path, below:
2) Shape and size your tyre, keeping in mind that it should resemble the real tyre mounted, but NOT inflated. This can be done in the “Geo” page, you can use the 'quick adjuster' on the right side, starting at cell C4. Enter realistic overall tyre dimensions hit
apply. This is a shortcut, so depending on the tyre you’re making, it may either be quite accurate, or very inaccurate. By default the quick adjust references cells in the “General” sheet, which define target dimensions.
Afterward, you can then manually tweak the shape in cells B14 to D64.
3) Once you're happy with the basic shape, set tread depths in Geo.M6, road tyres may have tread depths in inches, expressed as '3/8”' (which converts to 0.009m). Remember the depths will be much thinner in the sidewalls than the tread area for such tyres.
If you feel the need to be more precise, you can edit the thicknesses manually in M8:M40.
4) If your tyre has a tread pattern to it, then this must be accounted for. Do this in cells N8 to N40 in the Geo page. Preferably again, use the quick adjuster in N6. This is a land-to-sea type ratio, how much, as a fraction of the tread, is actually air.
The typical range should be 0.6 to 1.0 (1.0 for a slick, or maybe you want to use ~0.996, to account for tread depth indents).
5) Still staying on Geo page, scroll down to A120. Here you can fill in your ply thickness and spacings. Just below are the belt angles. It does not quite support some of the modern exquisite ply angling techniques, such as geodesic body plies, however you can customise your own shape should you need to do so.
6) Now it's time to move to the “TGM” page. On the top left, you'll be greeted immediately by the test conditions, just below are material properties for several textiles and rubbers. Fill in reasonable ranges for gauge pressures, temperatures and speeds.
Depending on your confidence, you need at least 2 of each. If you're confident with your tyres, add more to improve the detail, tTool will take longer with more tests, so only increase them once you’re satisfied with your tyre.
7) Now that you have specified valid boundaries for your tyres. Go below and specify reasonable materials for each part of the tyre, if you don't find anything reasonable in the list, you can add more to the “Materials” sheet. The cells for rubber materials and such begin @ TGM.C35.
8) Plies will only be active if you specify both a range of nodes and material name from the drop-list. Body plies typically span the entire tyre, from node 0 to node 64 (or however many you have), whereas belts should start somewhere around the tyre shoulder.
9) Go to export copy and paste the whole page into an appropriately named .TGM file, and load it up in tTool, and you should be ready to begin generating your first tyre. Note that if you haven't touched the real-time section in this spreadsheet, it's likely to be WAY off the mark.
TGM Gen V0.33 - GY F1 1975 Front.ods