{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Readme","DATA SHEET","TRA_Window","Window_Calcs","Profile","Profile_Calcs","Calcs","Tables","STATUS","Export General Data","Export Loads Data"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":92,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Readme","index":0,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[[24,1,24,9],[28,1,28,9],[26,1,26,9]]}
[null,"THE TIRE AND RIM ASSOCIATION, INC."]
[null,"HIGH FLOTATION RADIAL LIGHT TRUCK TIRE PROFILE PROGRAM "]
[]
[null,"IMPORTANT\nThe TRA High Flotation Radial Light Truck tire profile program was created to provide a convenient, electronic presentation of data resulting from applying formulae and guidelines for light truck tires shown in the TRA Engineering Design Information and the Year Book. All information provided in this program is advisory only and only tire sizes and load versions published in the TRA Year Book and Engineering Design Information are standardized by the Association. Any new tire sizes, load versions or other information must be approved be the approriate committees and published by TRA before they can be considered standardized.   This program only applies to light truck high flotation radial tires."]
[]
[null,"Because the program is still a work in progress, we would appreciate any feedback you can provide regarding errors, ommisions, problems or other suggestions to make it more usable and accurate. Please contact:"]
[]
[null," The Tire and Rim Association"]
[null," 4000 Embassy Parkway, Suite 390"]
[null," Akron, Ohio 44333"]
[null," ph - 330-666-8121"]
[null," email - rudyc@us-tra.org"]
[]
[null,"INSTRUCTIONS: "]
[null,"Enter data in the \"TRA Data\" worksheet as follows:"]
[null,"  Cell C6 = Tire nominal diameter"]
[null,"  Cell E6 = Tire nominal section width"]
[null,"  Cell G6 = Nominal rim diameter "]
[null,"  Cell J6 = Load Range"]
[null,"  Cell K31 = Intermediate pressure in kPa to calculate intermediate load"]
[null,"  Cell K32 = Intermediate pressure in psi to calculate intermediate load"]
[]
[null,"DATA WORKSHEETS"]
[]
[null,"DATA SHEET - provides basic tire load/pressure and dimension calculation and approved rim contours."]
[]
[null,"TRA Window - provides window of acceptable dimensions within tire maximum and minimum limits.  "]
[]
[null,"Profile - provides design new tire, maximum new tire and maximum grown tire envelope profile."]
[]
[null,"PROGRAM REVISIONS"]
[null,"The program will be revised after each Association meeting to add new approved tire sizes. The date will be changed. The version number will change only when there are significant revisions made to the program."]
[]
[null,"PROGRAM CORRECTION, REVISON AND UPDATE DETAILS"]
[null,"01-01-2015 - Update to include reference to tires in the 2015 Year Book."]
[]
[null,"01-01-2016 - Version 2.3 - Update to include reference to tires in the 2016 Year Book.  Additional section widths (16.5 to 18.5) and approved rim widths added."]
[]
[null,"01-27-2017 - Version 2.4 - Update to include reference to tires in the 2017 Year Book.  Half-inch rim widths above 10-inches added.  Additional section width (19.5) and approved rim widths added."]
[]
[null,"04-27-2017 - Version 2.5 - Correct formula in cell H22 (inflation pressure for load calculation)"]
[]
[null,"01-01-2018 - Version 2.6 - Update to include reference to tires in the 2018 Year Book."]
[]
[null,"01-24-2019 - Version 2.7 - Update to include reference to tires in the 2019 Year Book and revision to approved rim width range to match current guidelines."]
[]
[null,"08-12-2019 - Incorporated LT-Metric guidelines for low aspect ratio - Measuring Rim and Approved Rim Width range"]
[]
[null,"01-01-2020 - Version 2.8 - Update to include reference to tires in the 2020 Year Book."]
[]
[null,"01-01-2021 - Version 2.9 - Update to include reference to tires in the 2021 Year Book.  Load Index cap of 121 for 17 rim diameter code removed.  Radial design section width (cell J41) updated for calculation to include aspect ratio (cell AG10)."]
[]
[null,"01-01-2022 - Version 2.10 - Update to include reference to tires in the 2022 Year Book."]
[]
[null,"01-27-2023 - Version 2.11 - Update to include reference to tires in the 2023 Year Book."]
[]
[null,"06-02-23 - Version 3.0: New \"STATUS\" page, including exceptions to load calculations / Updated \"DATA SHEET\" page to work with new \"STATUS\" page, match YearBook look & intermediate pressures load calculation. Corrected Section Width minimum calculation for TRA_Window to follow SW maximum calculation (only affecting SWmin for 10.50 nominal width tires)"]
[]
[null,"01-05-24 - Version 3.1: Added LR input request in the desired size designation and associated messaging depending on the status of that LR;  Added for TRA purpose only the capability to upload new sizes or higher LR automatically from the spreadsheet to the Access database; Updated to include reference to tires in the 2024 Year Book."]
[]
[null,"01-01-25 - Version 3.2: Added control of size designation inputs (drop down menu like PMET and LTMET rather than typing manually, to avoid any typo); Eliminated erroneous data for sizes out of calculation range; Improved management of error display with messages; Added missing LRB for 33x9.50R15 in status page; Updated the Profile sheet with a correction of the max profile (C Max. value) and clarified drawing with line differentiation and legend; Included reference to tires in the 2025 Year Book."]
[]
[null,"11-14-25 - Version 3.3: Corrected Design OD calculation in \"TRA_Window\" and \"Calcs\" to match the proper calculation in \"DATA SHEET\". No impact to standardized sizes data in Year Book or Database"]
[]
[null,"01-01-2026 - Version 3.4 - Update to include reference to tires in the 2026 Year Book. For TRA purpose: added message in case upload to database fails to load the intended numbers of lines."]
[]
[null,"01-28-2026 - Version 3.5 - Update to increase load calculations up to 95psi / 650kPa (LR F) for Nominal Section Width <=11.5\""]

{"sheet":"DATA SHEET","index":1,"n_rows":32,"n_cols":34,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,8,15,33],[11,14,12,33],[13,14,13,33],[29,2,29,16],[16,31,16,33],[17,31,17,33],[18,33,19,33],[25,24,25,25],[26,24,26,25],[24,22,24,23],[25,14,25,16],[25,22,25,23],[23,17,23,18],[22,24,24,25],[22,17,22,23],[23,19,23,23],[24,19,24,21],[24,17,24,18],[25,5,26,5],[25,6,26,6],[25,10,25,11],[25,12,25,13],[24,14,24,16],[25,7,26,7],[25,8,26,9],[26,10,26,11],[26,12,26,13],[24,8,24,9],[24,10,24,11],[24,12,24,13],[22,2,24,7],[22,8,22,9],[23,8,23,9],[18,2,19,2],[18,3,19,3],[25,2,26,2],[25,3,26,3],[25,4,26,4],[9,2,9,30],[8,2,8,30],[11,10,11,13],[12,10,12,13],[13,10,13,13],[16,13,16,15],[26,22,26,23],[25,19,25,21],[26,19,26,21],[21,8,21,30],[18,30,19,30],[17,28,17,30],[16,28,16,30],[23,10,23,11],[23,12,23,16],[22,26,24,30],[26,14,26,16],[25,26,26,30],[26,17,26,18],[25,17,25,18],[22,10,22,16],[1,2,1,30],[2,2,2,30],[3,2,3,30],[5,11,5,15],[5,22,5,25],[16,18,16,20],[16,23,16,25],[17,18,17,20],[17,23,17,25],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,11,19,11],[18,15,19,15],[18,20,19,20],[18,25,19,25],[15,2,17,7],[16,9,16,11],[17,9,17,11],[17,13,17,15],[30,2,31,8],[30,9,31,9],[30,10,30,11],[31,10,31,11],[30,14,30,15],[31,14,31,15]]}
[]
[null,null,"This Version includes the Load Index cap of 128 which is effective January 1, 2009; contact TRA office for original calculations. Certain sizes with 17 rim diameter code designed from July 28, 1998 to October 23, 2020 were standardized with a Load Index cap of 121; contact TRA office for original calculations. Loads for the 33x9.50R15LT LR C, 33x12.50R22LT LR F, 35x13.50R24LT LR E, 37x14.50R24LT LR F, and 42x15.50R28LT LR E differ from the standard calculations; see current TRA Year Book for standardized loads."]
[null,null,"THE TIRE AND RIM ASSOCIATION, INC."]
[null,null,"LT_HIFLO_PROFILE PROGRAM"]
[]
[null,null,33,"x",11.5,{"$f":"IF(S14=\"RADIAL PLY\",\"R\",\"-\")","v":"R"},22,"LT","LR","F","←","TYPE IN SIZE DESIGNATION",null,null,null,null,null,null,null,null,null,null,"For TRA internal use only:",null,null,null,"Load DB"]
[]
[]
[null,null,"TRA DATA SHEET"]
[null,null,"LIGHT TRUCK HIGH FLOTATION RADIAL PLY TIRES MOUNTED ON 5 DEGREE DROP CENTER RIMS"]
[]
[null,null,null,null,null,null,null,null,null,"TRA STATUS =",{"$f":"STATUS!C3","v":"Not Standardized"},null,null,null,{"$f":"IF(Incorrect_Profile,\"Aspect ratio out of 30-70 range - Revise either tire OD, Section Width and / or Rim Diameter or contact TRA !\",IF(Out_of_LI_Range,\"Size out of LI range\",IF(AND(OR(K12=\"TRA Standard\",K12=\"Design Guide\"),STATUS!B4=\"yes\"),\"\",IF(AND(OR(K12=\"TRA Standard\",K12=\"Design Guide\"),STATUS!B4=\"no\"),\"Load Range must be confirmed by TRA\",\"Tire Size and Load Range must be confirmed by TRA\"))))","v":"Tire Size and Load Range must be confirmed by TRA"}]
[null,null,null,null,null,null,null,null,null,"APPROVED  LOAD RANGE(S) =",{"$f":"STATUS!B3","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,"LOCATION =",{"$f":"STATUS!D3","v":"N/A"},null,null,null,{"$f":"IF(AND(AA26<>\"N/A\",COUNTIF(J19:AB20,\"*n/a*\")<>0),\"Missing loads, LR and LIs at lower pressures are out of current scope\",\" \")","v":"Missing loads, LR and LIs at lower pressures are out of current scope"}]
[]
[null,null,"TIRE SIZE\nDESIGNATION",null,null,null,null,null,"TIRE LOAD LIMITS AT VARIOUS COLD INFLATION PRESSURES"]
[null,null,null,null,null,null,null,null,"kPa",170,null,null,210,250,null,null,280,310,350,null,null,380,410,450,null,null,480,520,550,null,null,650]
[null,null,null,null,null,null,null,null,"psi",25,null,null,30,35,null,null,40,45,50,null,null,55,60,65,null,null,70,75,80,null,null,95]
[null,null,{"$f":"C$6","v":33},"x",{"$f":"E6","v":11.5},{"$f":"IF(S14=\"RADIAL PLY\",\"R\",\"-\")","v":"R"},{"$f":"G6","v":22},"LT","kg",{"$f":"IFERROR(IF(OR(Out_of_Scope,J20=\"n/a\"),\"n/a\",IF(STATUS!F3<>0,STATUS!F3,IF($E$6<=11.5,ROUND(2*J20*0.4536,-1)/2,VLOOKUP(J20*0.4536,LI_Table,2)))),\"n/a\")","v":530},{"$f":"K20","v":"n/a"},{"$f":"IF(E6<=11.5,\"n/a\",IF(J20=\"n/a\",\"n/a\",VLOOKUP(J20,Tables!$H$5:$I$99,2)))","v":"n/a"},{"$f":"IFERROR(IF(OR(Out_of_Scope,M20=\"n/a\"),\"n/a\",IF(STATUS!H3<>0,STATUS!H3,ROUND(2*M20*0.4536,-1)/2)),\"n/a\")","v":605},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!J3<>0,STATUS!J3,VLOOKUP(N20*0.4536,LI_Table,2))),\"n/a\")","v":670},{"$f":"O20","v":"(B)"},{"$f":"IF(N20=\"n/a\",\"n/a\",VLOOKUP(N20,Tables!$H$5:$I$99,2))","v":94},{"$f":"IFERROR(IF(OR(Out_of_Scope,Q20=\"n/a\"),\"n/a\",IF(STATUS!L3<>0,STATUS!L3,ROUND(2*Q20*0.4536,-1)/2)),\"n/a\")","v":735},{"$f":"IFERROR(IF(OR(Out_of_Scope,R20=\"n/a\"),\"n/a\",IF(STATUS!N3<>0,STATUS!N3,ROUND(2*R20*0.4536,-1)/2)),\"n/a\")","v":795},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!P3<>0,STATUS!P3,VLOOKUP(S20*0.4536,LI_Table,2))),\"n/a\")","v":850},{"$f":"T20","v":"(C)"},{"$f":"IF(S20=\"n/a\",\"n/a\",VLOOKUP(S20,Tables!$H$5:$I$99,2))","v":102},{"$f":"IFERROR(IF(OR(Out_of_Scope,V20=\"n/a\"),\"n/a\",IF(STATUS!R3<>0,STATUS!R3,IF(STATUS!V3<>0,STATUS!V3,IF(STATUS!T3<>0,STATUS!T3,IF(STATUS!R3<>0,STATUS!R3,ROUND(2*V20*0.4536,-1)/2))))),\"n/a\")","v":905},{"$f":"IFERROR(IF(OR(Out_of_Scope,W20=\"n/a\"),\"n/a\",IF(STATUS!T3<>0,STATUS!T3,ROUND(2*W20*0.4536,-1)/2)),\"n/a\")","v":955},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!V3<>0,STATUS!V3,VLOOKUP(X20*0.4536,LI_Table,2))),\"n/a\")","v":1000},{"$f":"Y20","v":"(D)"},{"$f":"IF(X20=\"n/a\",\"n/a\",VLOOKUP(X20,Tables!$H$5:$I$99,2))","v":108},{"$f":"IFERROR(IF(OR(Out_of_Scope,AA20=\"n/a\"),\"n/a\",IF(STATUS!X3<>0,STATUS!X3,ROUND(2*AA20*0.4536,-1)/2)),\"n/a\")","v":1055},{"$f":"IFERROR(IF(OR(Out_of_Scope,AB20=\"n/a\"),\"n/a\",IF(STATUS!Z3<>0,STATUS!Z3,ROUND(2*AB20*0.4536,-1)/2)),\"n/a\")","v":1100},{"$f":"IF(Out_of_Scope,\"n/a\",IF(STATUS!AB3<>0,STATUS!AB3,VLOOKUP(AC20*0.4536,LI_Table,2)))","v":1150},{"$f":"AD20","v":"(E)"},{"$f":"IF(AC20=\"n/a\",\"n/a\",VLOOKUP(AC20,Tables!$H$5:$I$99,2))","v":113},{"$f":"IF(OR(Out_of_Scope,$E$6>11.5),\"n/a\",IF(STATUS!AD3<>0,STATUS!AD3,VLOOKUP(AF20*0.4536,LI_Table,2)))","v":1285},{"$f":"AG20","v":"(F)"},{"$f":"IF(AF20=\"n/a\",\"n/a\",VLOOKUP(AF20,Tables!$H$5:$I$99,2))","v":117}]
[null,null,null,null,null,{"$f":"IF(Q31=\"RADIAL PLY\",\"R\",\"-\")","v":"-"},null,null,"lb",{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!G3<>0,STATUS!G3,IF(E6<=11.5,(ROUND(2*(1.57*0.425*(20^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2,IF(VLOOKUP(1.57*0.425*(20^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(20^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5))))),\"n/a\")","v":1165},{"$f":"IF($E$6<=11.5,\"n/a\",\"(B)\")","v":"n/a"},null,{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!I3<>0,STATUS!I3,IF(VLOOKUP(1.57*0.425*(30^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(J20+(((N20-J20)/2))),-1)/2,(ROUND(2*(1.57*0.425*(25^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":1330},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!K3<>0,STATUS!K3,IF(VLOOKUP(1.57*0.425*(30^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(30^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)))),\"n/a\")","v":1475},{"$f":"IF(N20=\"n/a\",\"n/a\",IF($E$6<=11.5,\"(B)\",\"(C)\"))","v":"(B)"},null,{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!M3<>0,STATUS!M3,IF(VLOOKUP(1.57*0.425*(45^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(N20+(((S20-N20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(35^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":1620},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!O3<>0,STATUS!O3,IF(VLOOKUP(1.57*0.425*(45^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(N20+(2*((S20-N20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(40^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":1750},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!Q3<>0,STATUS!Q3,IF(VLOOKUP(1.57*0.425*(45^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(45^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)))),\"n/a\")","v":1875},{"$f":"IF(S20=\"n/a\",\"n/a\",IF($E$6<=11.5,\"(C)\",\"(D)\"))","v":"(C)"},null,{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!S3<>0,STATUS!S3,IF(VLOOKUP(1.57*0.425*(60^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(S20+(((X20-S20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(50^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":1995},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!U3<>0,STATUS!U3,IF(VLOOKUP(1.57*0.425*(60^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(S20+(2*((X20-S20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(55^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":2110},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!W3<>0,STATUS!W3,IF(VLOOKUP(1.57*0.425*(60^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(60^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)))),\"n/a\")","v":2205},{"$f":"IF(X20=\"n/a\",\"n/a\",IF($E$6<=11.5,\"(D)\",\"(E)\"))","v":"(D)"},null,{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!Y3<>0,STATUS!Y3,IF(VLOOKUP(1.57*0.425*(75^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(X20+(((AC20-X20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(65^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":2325},{"$f":"IFERROR(IF(Out_of_Scope,\"n/a\",IF(STATUS!AA3<>0,STATUS!AA3,IF(VLOOKUP(1.57*0.425*(75^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,ROUND(2*(X20+(2*((AC20-X20)/3))),-1)/2,(ROUND(2*(1.57*0.425*(70^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)),-1))/2))),\"n/a\")","v":2430},{"$f":"IF(Out_of_Scope,\"n/a\",IF(STATUS!AC3<>0,STATUS!AC3,IF(VLOOKUP(1.57*0.425*(75^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(75^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5))))","v":2535},{"$f":"IF(AC20=\"n/a\",\"n/a\",IF($E$6<=11.5,\"(E)\",\"(F)\"))","v":"(E)"},null,{"$f":"IF(OR(Out_of_Scope,$E$6>11.5),\"n/a\",IF(STATUS!AE3<>0,STATUS!AE3,IF(VLOOKUP(1.57*0.425*(90^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5)>3970,3970,VLOOKUP(1.57*0.425*(90^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5))))","v":2835},{"$f":"IF(AF20=\"n/a\",\"n/a\",IF($E$6<=11.5,\"(F)\",\"---\"))","v":"(F)"}]
[]
[null,null,"Millimeters / Inches",null,null,null,null,null,"GENERAL DATA "]
[null,null,"TIRE SIZE\nDESIGNATION",null,null,null,null,null,"MEASURING",null,"DESIGN NEW TIRE",null,null,null,null,null,null,"MAXIMUM GROWN TIRE",null,null,null,null,null,null,"*MINIMUM SIZE\nFACTOR",null,"APPROVED RIM CONTOURS"]
[null,null,null,null,null,null,null,null,"RIM",null,"SECTION",null,"OVERALL DIAMETER",null,null,null,null,"OVERALL",null,"OVERALL DIAMETER"]
[null,null,null,null,null,null,null,null,"WIDTH",null,"WIDTH",null,"HIGHWAY",null,"TRACTION",null,null,"WIDTH",null,"HIGHWAY",null,null,"TRACTION"]
[null,null,{"$f":"C6","v":33},"x",{"$f":"E6","v":11.5},{"$f":"IF(S14=\"RADIAL PLY\",\"R\",\"-\")","v":"R"},{"$f":"G6","v":22},"LT",{"$f":"IF(AR>0.45,VLOOKUP(E6,Tables!$AG$6:$AI$18,2),IF(AR>0.4,VLOOKUP(E6,Tables!$AG$23:$AI$35,2),VLOOKUP(E6,Tables!$AG$39:$AI$51,2)))","v":9},null,{"$f":"ROUND(K27*25.4,0)","v":290},null,{"$f":"ROUND(M27*25.4,0)","v":826},null,{"$f":"ROUND(O27*25.4,0)","v":832},null,null,{"$f":"ROUND(R27*25.4,0)","v":313},null,{"$f":"ROUND(T27*25.4,0)","v":837},null,null,{"$f":"ROUND(W27*25.4,0)","v":843},null,{"$f":"ROUND(Y27*25.4,0)","v":1102},null,{"$f":"IF(AR>=0.7,VLOOKUP($E$6,Tables!$AK$6:$AL$18,2),IF(AR>0.45,VLOOKUP($E$6,Tables!$AM$6:$AN$18,2),IF(AR>0.4,VLOOKUP($E$6,Tables!$AO$6:$AP$18,2),IF(AR>0.3,VLOOKUP($E$6,Tables!$AQ$6:$AR$18,2),VLOOKUP($E$6,Tables!$AS$6:$AT$18,2)))))","v":"8J, 8½J, 9J, 9½J, 10J, 10½J"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR<=0.4,VLOOKUP(E6,Tables!$AG$39:$AI$51,3),IF(AR<=0.45,VLOOKUP(E6,Tables!$AG$23:$AI$32,3),VLOOKUP(E6,Tables!$AG$6:$AI$18,3)))","v":11.42},null,{"$f":"Do","v":32.520000000000003},null,{"$f":"M27+0.24","v":32.760000000000005},null,null,{"$f":"ROUND(K27*1.08,2)","v":12.33},null,{"$f":"ROUND((2*(H*1.04))+G6,2)","v":32.94},null,null,{"$f":"ROUND((2*((H+0.12)*1.04))+G6,2)","v":33.19},null,{"$f":"ROUND((((2.02*H)+K27)*0.97)+G6,2)","v":43.38}]
[null,null,"* Minimum Size Factor dimensions are based on the Highway Tread and Measuring Rim Width"]
[]
[null,null,"CALCULATION OF LOAD LIMITS AT INFLATION PRESSURES BETWEEN STANDARDIZED INCREMENTS"]
[null,null,"TYPE IN DESIRED INTERMEDIATE PRESSURE(S)",null,null,null,null,null,null,"→",null,null,"kPa","→",{"$f":"IF(K31=\"\",\"\",IF(AND(E6>11.5,K31>550),\"n/a\",MROUND(MROUND(IF(Tables!Q85<=80,HLOOKUP(FLOOR(Tables!Q85,5),J18:AH20,3,FALSE)+(HLOOKUP(CEILING(Tables!Q85,5),J18:AH20,3,FALSE)-HLOOKUP(FLOOR(Tables!Q85,5),J18:AH20,3,FALSE))/5*(Tables!Q85-FLOOR(Tables!Q85,5)),AC20+((AF20-AC20)/15*(Tables!Q85-80))),5)*0.4536,5)))","v":""},null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"psi","→",{"$f":"IF(K32=\"\",\"\",IF(AND(E6>11.5,K32>80),\"n/a\",MROUND(IF(K32<=80,HLOOKUP(FLOOR(K32,5),J18:AH20,3,FALSE)+(HLOOKUP(CEILING(K32,5),J18:AH20,3,FALSE)-HLOOKUP(FLOOR(K32,5),J18:AH20,3,FALSE))/5*(K32-FLOOR(K32,5)),AC20+((AF20-AC20)/15*(K32-80))),5)))","v":""},null,"lb"]

{"sheet":"TRA_Window","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,5,32,6],[29,7,29,9],[30,7,30,9],[31,7,31,9],[32,7,32,9],[3,1,5,1],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[5,6,5,7]]}
[]
[]
[]
[null,"TRA",null,null,null,"Tread Depth Options: ","HWY / TRAC. Tread"]
[]
[null,null,"Rim Width Options: ","Meas.",null,"Approved Rim Contours: ",{"$f":"'DATA SHEET'!AA26","v":"8J, 8½J, 9J, 9½J, 10J, 10½J"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Optional Entries:","SW","OD","Label"]
[null,null,"Tire 1",null,null,null,null,"Value out of range!  Reselect.",null,null,{"$f":"IF(OR(D30=0,E30=0),\"YES\",IF(OR(D30<Window_Calcs!$C$57,D30>Window_Calcs!$C$58,E30<Window_Calcs!$D$57,E30>Window_Calcs!$E$58),\"NO\",\"YES\"))","v":"YES"}]
[null,null,"Tire 2",null,null,null,null,"Value out of range!  Reselect.",null,null,{"$f":"IF(OR(D31=0,E31=0),\"YES\",IF(OR(D31<Window_Calcs!$C$57,D31>Window_Calcs!$C$58,E31<Window_Calcs!$D$57,E31>Window_Calcs!$E$58),\"NO\",\"YES\"))","v":"YES"}]
[null,null,"Tire 3",null,null,null,null,"Value out of range!  Reselect.",null,null,{"$f":"IF(OR(D32=0,E32=0),\"YES\",IF(OR(D32<Window_Calcs!$C$57,D32>Window_Calcs!$C$58,E32<Window_Calcs!$D$57,E32>Window_Calcs!$E$58),\"NO\",\"YES\"))","v":"YES"}]
[null,null,"Tire 4",null,null,null,null,"Value out of range!  Reselect.",null,null,{"$f":"IF(OR(D33=0,E33=0),\"YES\",IF(OR(D33<Window_Calcs!$C$57,D33>Window_Calcs!$C$58,E33<Window_Calcs!$D$57,E33>Window_Calcs!$E$58),\"NO\",\"YES\"))","v":"YES"}]

{"sheet":"Window_Calcs","index":3,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["TRA"]
[null,{"$f":"\"TRA Window - \"&Dimen&\"  (\"&Rim&\")\"&IF(Flag1=TRUE,\" - HWY/Traction Tread - Radial Ply\",\" - DEEP Traction Tread - Radial Ply\")","v":"TRA Window - 33x11.50R22 LT  (22x9J) - HWY/Traction Tread - Radial Ply"}]
[]
[]
[null,"Design"]
[null,null,"SW","OD"]
[]
[null,"@ Min1 SW",{"$f":"MIN_SW1","v":276},{"$f":"MIN_OD1","v":826}]
[null,"@ Min2 SW",{"$f":"MIN_SW2","v":283},{"$f":"MIN_OD2","v":819}]
[null,"@ Max SW",{"$f":"ROUND('DATA SHEET'!K26*VLOOKUP(\"TRA Max\",Profile_Tbl,2)+(New_Rim_Width-M_Rim)*10,0)","v":310},{"$f":"MIN_OD2","v":819}]
[null,"@ Max SW",{"$f":"C10","v":310},{"$f":"ROUND(2*IF(Flag1=TRUE,ROUND(Calcs!I7*25.4*1.03,0),ROUND(Calcs!I7*25.4*1.03,0)+3)+Dr_mm,0)","v":835}]
[null,"@ Max OD",{"$f":"C10","v":310},{"$f":"D11","v":835}]
[null,"@ Max OD",{"$f":"MIN_SW1","v":276},{"$f":"D11","v":835}]
[null,"@ Min1 SW",{"$f":"MIN_SW1","v":276},{"$f":"MIN_OD1","v":826}]
[]
[]
[]
[null,"Max"]
[]
[null,"@ Min2 SW",{"$f":"C10","v":310},null,{"$f":"MIN_OD2","v":819}]
[null,"@ Max SW",{"$f":"MAX_SW","v":313},null,{"$f":"MIN_OD2","v":819}]
[null,"@ Max SW",{"$f":"MAX_SW","v":313},null,{"$f":"MAX_OD","v":837}]
[null,"@ Max OD",{"$f":"MAX_SW","v":313},null,{"$f":"MAX_OD","v":837}]
[null,"@ Max OD",{"$f":"MIN_SW1","v":276},null,{"$f":"MAX_OD","v":837}]
[null,"@ Min1 SW",{"$f":"MIN_SW1","v":276},null,{"$f":"D11","v":835}]
[]
[]
[null,"Design Points"]
[]
[null,"TRA Min SW",{"$f":"MIN_SW1","v":276},null,{"$f":"F30","v":826},{"$f":"MIN_OD1","v":826}]
[]
[]
[null,"TRA Min OD",{"$f":"MIN_SW2","v":283},null,{"$f":"F33","v":819},{"$f":"MIN_OD2","v":819}]
[]
[]
[]
[]
[]
[null,"TRA Design",{"$f":"'DATA SHEET'!K26+(New_Rim_Width-M_Rim)*10","v":290},null,{"$f":"F39","v":826},{"$f":"IF(TRA_Window!G4=\"HWY / TRAC. Tread\",'DATA SHEET'!M26,'DATA SHEET'!O26)","v":826}]
[]
[]
[]
[]
[]
[null,"TRA Max",{"$f":"C11","v":310},null,{"$f":"F45","v":835},{"$f":"D11","v":835}]
[]
[]
[null,{"$f":"IF(OR(TRA_Window!D30<C$57,TRA_Window!D30=0,TRA_Window!D30>C$58,TRA_Window!E30<D$57,TRA_Window!E30=0,TRA_Window!E30>E$58),\"\",IF(TRA_Window!F30=\"\",\"Tire 1\",TRA_Window!F30))","v":""},{"$f":"IF(OR(TRA_Window!D30<C$57,TRA_Window!D30=0,TRA_Window!D30>C$58,TRA_Window!E30<D$57,TRA_Window!E30=0,TRA_Window!E30>E$58),C$45,TRA_Window!D30)","v":310},null,null,{"$f":"IF(OR(TRA_Window!D30<C$57,TRA_Window!D30=0,TRA_Window!D30>C$58,TRA_Window!E30<D$57,TRA_Window!E30=0,TRA_Window!E30>E$58),F$45,TRA_Window!E30)","v":835}]
[]
[null,{"$f":"IF(OR(TRA_Window!D31<C$57,TRA_Window!D31=0,TRA_Window!D31>C$58,TRA_Window!E31<D$57,TRA_Window!E31=0,TRA_Window!E31>E$58),\"\",IF(TRA_Window!F31=\"\",\"Tire 1\",TRA_Window!F31))","v":""},{"$f":"IF(OR(TRA_Window!D31<C$57,TRA_Window!D31=0,TRA_Window!D31>C$58,TRA_Window!E31<D$57,TRA_Window!E31=0,TRA_Window!E31>E$58),C$45,TRA_Window!D31)","v":310},null,null,{"$f":"IF(OR(TRA_Window!D31<C$57,TRA_Window!D31=0,TRA_Window!D31>C$58,TRA_Window!E31<D$57,TRA_Window!E31=0,TRA_Window!E31>E$58),F$45,TRA_Window!E31)","v":835}]
[]
[null,{"$f":"IF(OR(TRA_Window!D32<C$57,TRA_Window!D32=0,TRA_Window!D32>C$58,TRA_Window!E32<D$57,TRA_Window!E32=0,TRA_Window!E32>E$58),\"\",IF(TRA_Window!F32=\"\",\"Tire 1\",TRA_Window!F32))","v":""},{"$f":"IF(OR(TRA_Window!D32<C$57,TRA_Window!D32=0,TRA_Window!D32>C$58,TRA_Window!E32<D$57,TRA_Window!E32=0,TRA_Window!E32>E$58),C$45,TRA_Window!D32)","v":310},null,null,{"$f":"IF(OR(TRA_Window!D32<C$57,TRA_Window!D32=0,TRA_Window!D32>C$58,TRA_Window!E32<D$57,TRA_Window!E32=0,TRA_Window!E32>E$58),F$45,TRA_Window!E32)","v":835}]
[]
[null,{"$f":"IF(OR(TRA_Window!D33<C$57,TRA_Window!D33=0,TRA_Window!D33>C$58,TRA_Window!E33<D$57,TRA_Window!E33=0,TRA_Window!E33>E$58),\"\",IF(TRA_Window!F33=\"\",\"Tire 1\",TRA_Window!F33))","v":""},{"$f":"IF(OR(TRA_Window!D33<C$57,TRA_Window!D33=0,TRA_Window!D33>C$58,TRA_Window!E33<D$57,TRA_Window!E33=0,TRA_Window!E33>E$58),C$45,TRA_Window!D33)","v":310},null,null,{"$f":"IF(OR(TRA_Window!D33<C$57,TRA_Window!D33=0,TRA_Window!D33>C$58,TRA_Window!E33<D$57,TRA_Window!E33=0,TRA_Window!E33>E$58),F$45,TRA_Window!E33)","v":835}]
[]
[null,null,{"$f":"MIN(C8:C54)-6","v":270},null,null,null,null,null,"Range Finder"]
[null,"Min",{"$f":"MIN(C8:C14)-8","v":268},{"$f":"MIN(D8:D14)-4","v":815}]
[null,"Max",{"$f":"MAX(C8:C14)+8","v":318},null,{"$f":"MAX(E19:E25)+4","v":841}]

{"sheet":"Profile","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,8,6,9],[5,6,5,8],[49,5,49,6],[50,5,50,6],[51,5,51,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[1,1,5,1],[5,4,5,5],[44,5,44,6],[34,3,35,3],[34,4,36,4],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6]]}
[null,null,null,null,null,null,null,null,null,{"$f":"Prof_Type","v":"TRA Design"}]
[null,"TRA","Tire Profile Sizing Options: ","TRA Design",null,"Tread Depth Options: ","HWY / TRAC. Tread"]
[]
[]
[]
[null,null,"Rim Width Options: ","Meas.","Approved Rim Contours: ",null,{"$f":"'DATA SHEET'!AA26","v":"8J, 8½J, 9J, 9½J, 10J, 10½J"}]
[null,null,null,null,null,null,null,null,"Enter Custom Values"]
[null,null,null,null,null,null,null,null,300,"SW (on Meas. Rim)"]
[null,null,null,null,null,null,null,null,925,"OD"]
[null,null,null,null,null,null,null,null,30,"Shoulder Radius"]
[null,null,null,null,null,null,null,null,1300,"Tread Arc Rad (R)"]
[null,null,null,null,null,null,null,null,250,"Tread Arc Width (C)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Profile Construction Information:"]
[]
[null,null,null,{"$f":"\"Tire - \"&Prof_Type","v":"Tire - TRA Design"},"Maximum Envelope Dimensions"]
[]
[null,null,null,"New"]
[null,null,"RIM WIDTH  (IN)",{"$f":"Profile_Calcs!C35","v":9},{"$f":"D38","v":9},"RIM WIDTH  (IN)"]
[null,null,"OVERALL DIAMETER (OD)",{"$f":"Profile_Calcs!C36","v":826},{"$f":"MAX_OD","v":837},"Maximum Overall Diameter"]
[null,null,"SECTION HEIGHT",{"$f":"Profile_Calcs!C37","v":133.60400000000004},{"$f":"MAX_SH","v":139},"Maximum Section Height"]
[null,null,"TREAD ARC WIDTH (C)",{"$f":"Profile_Calcs!C10","v":238},{"$f":"MAX_Envelope_RTW","v":307},"TREAD WIDTH (Cmax)"]
[null,null,"TREAD ARC LENGTH",{"$f":"Profile_Calcs!C38","v":238.14812403083789}]
[null,null,"TREAD ARC RADIUS (R)",{"$f":"Profile_Calcs!C39","v":1949},{"$f":"MAX_Envelope_TR","v":2629},"TREAD RADIUS (R)"]
[null,null,"SHOULDER RADIUS (SR)",{"$f":"Profile_Calcs!C40","v":20}]
[null,null,null,null,{"$f":"FIXED(0.3*MAX_SH,1)","v":"41.7"},"30% Max SH (A)"]
[null,null,null,null,{"$f":"FIXED(0.7*MAX_SH,1)","v":"97.3"},"70% Max SH (B)"]
[null,null,"D (Equator Height from Rim)",{"$f":"Profile_Calcs!C41","v":75.552000000000021}]
[null,null,"E (Upper Sidewall Arc Offset)",{"$f":"Profile_Calcs!C42","v":78.793169850747702}]
[null,null,"F (Upper Sidewall Arc Radius)",{"$f":"Profile_Calcs!C43","v":66.206830149252298}]
[null,null,"G (Lower Sidewall Arc Offset)",{"$f":"IF(Profile_Calcs!C46<=0,\"N/A\",Profile_Calcs!C45)","v":69.312481318474838}]
[null,null,"H (Lower Sidewall Arc Radius)",{"$f":"IF(Profile_Calcs!C46<=0,\"Straight Line\",Profile_Calcs!C46)","v":75.687518681525162}]
[null,null,"SECTION WIDTH (SW)",{"$f":"Profile_Calcs!C44","v":290},{"$f":"MAX_SW","v":313},"Maximum Overall Width"]

{"sheet":"Profile_Calcs","index":5,"n_rows":539,"n_cols":22,"rows_kept":539,"cut":false,"hidden":true,"merged":[]}
["TRA"]
[null,"ENVELOPE CALCULATIONS",null,null,null,null,null,null,"Real X","Tire profile","Rim Profile","Max profile","Table Data 1","Table Data 2","Table Data 3","Table Data 4","No arrow lines","Double arrow lines","Single arrow lines","Label lines","Real Y"]
[null,null,null,null,null,null,null,"TIRE PROFILE: TIRE CROWN"]
[null,null,"New",null,null,null,null,"Right side"]
[null,"TIRE SIZE",{"$f":"Dimen","v":"33x11.50R22 LT"},null,null,null,null,{"$f":"ACOS($I$5/(Tread_Rad))","v":1.5142602519988986},{"$f":"P1_X","v":110.13011923276309},{"$f":"U5+Center","v":235.98600818181978},null,null,null,null,null,null,null,null,null,null,{"$f":"P1_Y","v":409.88600818181976}]
[null,"RIM FLANGE TYPE","J","<--- Fixed",null,null,null,{"$f":"(H$15-H$5)/10+H5","v":1.5199138594784984},{"$f":"COS(H6)*Tread_Rad","v":99.127142093407201},236.57753896632278,null,null,null,null,null,null,null,null,null,null,{"$f":"SIN(H6)*Tread_Rad+OD/2-Tread_Rad","v":410.47753896632275}]
[null,null,null,null,null,null,null,1.5255674669580983,{"$f":"COS(H7)*Tread_Rad","v":88.120996534136907},237.1068541147539,null,null,null,null,null,null,null,null,null,null,411.00685411475388]
[null,"RIM WIDTH  (IN)",{"$f":"IF(O_Rim=0,M_Rim,O_Rim)","v":9},null,null,null,null,1.5312210744376982,77.11203434650028,237.57393670851036,null,null,null,null,null,null,null,null,null,null,411.47393670851034]
[null,null,null,null,null,null,null,1.536874681917298,66.100607412073785,237.97877181814249,null,null,null,null,null,null,null,null,null,null,411.87877181814247]
[null,"RTW",{"$f":"IF(Prof_Type=\"Custom\",Cust_C,ROUND(INDEX(RTW_Tbl_X,MATCH(A&\" - \"&Prof_Type,RTW_Tbl_AR,0))*'DATA SHEET'!K26,0))","v":238},null,null,null,null,1.5425282893968979,55.08706769121509,238.3213465038267,null,null,null,null,null,null,null,null,null,null,412.22134650382668]
[null,"SECTION WIDTH",{"$f":"DSW","v":290},null,null,null,null,1.5481818968764978,44.071767211813267,238.60164981578293,null,null,null,null,null,null,null,null,null,null,412.50164981578291]
[null,"SECTION HEIGHT",{"$f":"SH","v":133.60400000000004},null,null,null,null,1.5538355043560976,33.055058058036821,238.81967279462208,null,null,null,null,null,null,null,null,null,null,412.71967279462206]
[null,"OVERALL DIAM.  (mm)",{"$f":"OD","v":826},null,null,null,null,1.5594891118356975,22.037292359080006,238.97540847163475,null,null,null,null,null,null,null,null,null,null,412.87540847163473]
[null,"TREAD RADIUS  (mm)",{"$f":"ROUND(INDEX(RTW_Tbl_Trd_Rad__Y,MATCH(A&\" - \"&Prof_Type,RTW_Tbl_AR,0))*DSW_M,0)","v":1949},null,null,null,null,1.5651427193152974,11.018822277907637,239.06885186901002,null,null,null,null,null,null,null,null,null,null,412.96885186901]
[null,"SHOULDER RADIUS (mm)",{"$f":"VLOOKUP(Prof_Type,Profile_Tbl,4)","v":20},null,null,null,null,{"$f":"PI()/2","v":1.5707963267948966},0,239.10000000000002,null,null,null,null,null,null,null,null,null,null,413]
[null,"EQUATOR DIAM. AVG",{"$f":"Dr_mm+SH+F_Height","v":709.904},null,null,null,null,"Left side"]
[null,null,null,null,null,null,null,null,{"$f":"-I5","v":-110.13011923276309},{"$f":"J5","v":235.98600818181978}]
[null,"SHCX (Shldr Radius Center)",{"$f":"(RTW-SHDR_RAD)/2","v":109},null,null,null,null,null,-99.127142093407201,236.57753896632278]
[null,"SHCY(Shdr Radius Center)",{"$f":"SQRT((Tread_Rad-SHDR_RAD)^2-SHCX^2)+(OD/2-Tread_Rad)","v":389.91796294650089},null,null,null,null,null,-88.120996534136907,237.1068541147539]
[null,null,null,null,null,null,null,null,-77.11203434650028,237.57393670851036]
[null,"P1 X (Tread/Shldr intersection)",{"$f":"SHCX*(Tread_Rad/(Tread_Rad-SHDR_RAD))","v":110.13011923276309},null,null,null,null,null,-66.100607412073785,237.97877181814249]
[null,"P1 Y (Tread/Shldr intersection)",{"$f":"OD/2-Tread_Rad+SQRT(Tread_Rad^2-P1_X^2)","v":409.88600818181976},null,null,null,null,null,-55.08706769121509,238.3213465038267]
[null,null,null,null,null,null,null,null,-44.071767211813267,238.60164981578293]
[null,"P2 X (Shldr/Sidewall intersection)",{"$f":"(SHCX-C$42)*(C$43/(C$43-SHDR_RAD))+C$42","v":122.07461691342232},null,null,null,null,null,-33.055058058036821,238.81967279462208]
[null,"P2 Y (Shldr/Sidewall intersection)",{"$f":"(SHCY-EQD/2)*C$43/(C$43-SHDR_RAD)+EQD/2","v":405.05250597122586},null,null,null,null,null,-22.037292359080006,238.97540847163475]
[null,"1/2 SECT. WIDTH",{"$f":"DSW/2","v":145},null,null,null,null,null,-11.018822277907637,239.06885186901002]
[null,null,null,null,null,null,null,null,0,239.10000000000002]
[null,"Flange Height",{"$f":"IF(R_Flange=VLOOKUP(R_Flange,Rim_Tbl,1),VLOOKUP(R_Flange,Rim_Tbl,4),\"ERROR\")","v":17.5}]
[null,"Flange Top Radius",{"$f":"IF(R_Flange=VLOOKUP(R_Flange,Rim_Tbl,1),VLOOKUP(R_Flange,Rim_Tbl,5),\"ERROR\")","v":9.5},null,null,null,null,"TIRE PROFILE: SHOULDER ARC"]
[null,"Flange Bottom Radius",{"$f":"IF(R_Flange=VLOOKUP(R_Flange,Rim_Tbl,1),VLOOKUP(R_Flange,Rim_Tbl,6),\"ERROR\")","v":6.5},null,null,null,null,"Right side"]
[null,"Flange Width",{"$f":"IF(R_Flange=VLOOKUP(R_Flange,Rim_Tbl,1),VLOOKUP(R_Flange,Rim_Tbl,7),\"ERROR\")","v":15},null,null,null,null,{"$f":"ACOS(($I$31-SHCX)/SHDR_RAD)","v":1.5142602519988984},{"$f":"P1_X","v":110.13011923276309},{"$f":"U31+Center","v":235.98600818181978},null,null,null,null,null,null,null,null,null,null,{"$f":"P1_Y","v":409.88600818181976}]
[null,null,null,null,null,null,null,{"$f":"H31-(H$31-H$36)/5","v":1.3830666188563501},{"$f":"IF(SHDR_RAD=0,P1_X,COS(H32)*SHDR_RAD+SHCX)","v":112.73257947523722},235.6665723237835,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SHDR_RAD=0,P1_Y,SIN(H32)*SHDR_RAD+SHCY)","v":409.56657232378348}]
["  OUTPUTS:",null,null,null,null,null,null,{"$f":"H32-(H$31-H$36)/5","v":1.2518729857138018},{"$f":"IF(SHDR_RAD=0,P1_X,COS(H33)*SHDR_RAD+SHCX)","v":115.27088751425329},235.00943392121962,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SHDR_RAD=0,P1_Y,SIN(H33)*SHDR_RAD+SHCY)","v":408.9094339212196}]
[null,null,null,null,null,null,null,{"$f":"H33-(H$31-H$36)/5","v":1.1206793525712535},{"$f":"IF(SHDR_RAD=0,P1_X,COS(H34)*SHDR_RAD+SHCX)","v":117.70141720471818},234.02588727523562,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SHDR_RAD=0,P1_Y,SIN(H34)*SHDR_RAD+SHCY)","v":407.9258872752356}]
[null,"RIM WIDTH  (IN)",{"$f":"New_Rim_Width","v":9},null,null,null,null,{"$f":"H34-(H$31-H$36)/5","v":0.98948571942870511},{"$f":"IF(SHDR_RAD=0,P1_X,COS(H35)*SHDR_RAD+SHCX)","v":119.98239479841091},232.7328366969017,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SHDR_RAD=0,P1_Y,SIN(H35)*SHDR_RAD+SHCY)","v":406.63283669690168}]
[null,"OVERALL DIAMETER",{"$f":"OD","v":826},null,null,null,null,{"$f":"ACOS(($I$36-C$42)/C$43)","v":0.8582920862861565},{"$f":"P2_X","v":122.07461691342232},231.15250597122588,null,null,null,null,null,null,null,null,null,null,{"$f":"P2_Y","v":405.05250597122586}]
["*","SECTION HEIGHT (A)",{"$f":"SH","v":133.60400000000004},null,null,null,null,"Left side"]
["*","TRD ARC LENGTH (B)",{"$f":"ASIN(RTW/Tread_Rad/2)*Tread_Rad*2","v":238.14812403083789},null,null,null,null,null,{"$f":"-I31","v":-110.13011923276309},{"$f":"J31","v":235.98600818181978}]
["*","TREAD RADIUS (C)",{"$f":"Tread_Rad","v":1949},null,null,null,null,null,-112.73257947523722,235.6665723237835]
["*","SHOULDER RADIUS (SR)",{"$f":"SHDR_RAD","v":20},null,null,null,null,null,-115.27088751425329,235.00943392121962]
[null,"D (Equator Height from Rim)",{"$f":"(C$37+F_Height)/2","v":75.552000000000021},null,null,null,null,null,-117.70141720471818,234.02588727523562]
["*","E (Upper Sidewall Arc Offset)",{"$f":"DSW/2-C$43","v":78.793169850747702},null,null,null,null,null,-119.98239479841091,232.7328366969017]
["*","F (Upper Sidewall Arc)",{"$f":"SHDR_RAD+(((SHCY-EQD/2)/2)^2+((C$26-SHDR_RAD-SHCX)/2)^2)/((C$26-SHDR_RAD-SHCX)/2)","v":66.206830149252298},null,null,null,null,null,-122.07461691342232,231.15250597122588]
["*","SECTION WIDTH",{"$f":"DSW","v":290}]
["*","M (Lower Sidewall Arc Offset)",{"$f":"DSW/2-C$46","v":69.312481318474838},null,null,null,null,"TIRE PROFILE: UPPER SIDEWALL ARC"]
[null,"N (Lower Sidewall Arc)",{"$f":"((C48+Rs/2-EQD/2)^2+(DSW/2-(C$47+New_Rim_Width*12.7))^2)/(2*(DSW/2-(C$47+New_Rim_Width*12.7)))","v":75.687518681525162},null,null,null,null,"Right side"]
[null,"FLG X-20 DEG TAN",{"$f":"VLOOKUP(R_Flange,Rim_Tbl,2)","v":5.8496199999999998},null,null,null,null,{"$f":"ACOS(($I$47-C$42)/C$43)","v":0.8582920862861565},{"$f":"P2_X","v":122.07461691342232},{"$f":"U47+Center","v":231.15250597122588},null,null,null,null,null,null,null,null,null,null,{"$f":"P2_Y","v":405.05250597122586}]
[null,"FLG Y-20 DEG TAN",{"$f":"VLOOKUP(R_Flange,Rim_Tbl,3)","v":17.078959999999999},null,null,null,null,{"$f":"H47-(H$47-H$57)/10","v":0.77246287765754085},{"$f":"COS(H48)*C$43+C$42","v":126.21010423556383},227.25782963174652,null,null,null,null,null,null,null,null,null,null,{"$f":"SIN(H48)*C$43+EQD/2","v":401.15782963174649}]
[null,"FLANGE DIAMETER",{"$f":"2*C$48+Rs","v":597.75792000000001},null,null,null,null,0.6866336690289252,129.99650183408093,223.0229798815385,null,null,null,null,null,null,null,null,null,null,396.92297988153848]
[null,null,null,null,null,null,null,0.60080446040030955,133.40593375055607,218.47913424289561,null,null,null,null,null,null,null,null,null,null,392.37913424289559]
[null,null,null,null,null,null,null,0.5149752517716939,136.41329929763191,213.65974510658856,null,null,null,null,null,null,null,null,null,null,387.55974510658854]
[null,null,null,null,null,null,null,0.42914604314307825,138.99645785358149,208.60029345095256,null,null,null,null,null,null,null,null,null,null,382.50029345095254]
[null,null,null,null,null,null,null,0.3433168345144626,141.13639186448495,203.33802762624629,null,null,null,null,null,null,null,null,null,null,377.23802762624626]
[null,null,null,null,null,null,null,0.25748762588584695,142.81734685396947,197.91168912738533,null,null,null,null,null,null,null,null,null,null,371.81168912738531]
[null,null,null,null,null,null,null,0.1716584172572313,144.02694740974152,192.36122737394811,null,null,null,null,null,null,null,null,null,null,366.26122737394809]
[null,null,null,null,null,null,null,8.582920862861565E-2,144.75628829300433,186.72750559728087,null,null,null,null,null,null,null,null,null,null,360.62750559728084]
[null,null,null,null,null,null,null,0,145,181.05200000000002,null,null,null,null,null,null,null,null,null,null,354.952]
[null,null,null,null,null,null,null,"Left side"]
[null,null,null,null,null,null,null,null,{"$f":"-I47","v":-122.07461691342232},{"$f":"J47","v":231.15250597122588}]
[null,null,null,null,null,null,null,null,-126.21010423556383,227.25782963174652]
[null,null,null,null,null,null,null,null,-129.99650183408093,223.0229798815385]
[null,null,null,null,null,null,null,null,-133.40593375055607,218.47913424289561]
[null,null,null,null,null,null,null,null,-136.41329929763191,213.65974510658856]
[null,null,null,null,null,null,null,null,-138.99645785358149,208.60029345095256]
[null,null,null,null,null,null,null,null,-141.13639186448495,203.33802762624629]
[null,null,null,null,null,null,null,null,-142.81734685396947,197.91168912738533]
[null,null,null,null,null,null,null,null,-144.02694740974152,192.36122737394811]
[null,null,null,null,null,null,null,null,-144.75628829300433,186.72750559728087]
[null,null,null,null,null,null,null,null,-145,181.05200000000002]
[]
[null,null,null,null,null,null,null,"TIRE PROFILE: LOWER SIDEWALL ARC"]
[null,null,null,null,null,null,null,"Right side"]
[null,null,null,null,null,null,null,0,{"$f":"COS(H73)*C$46+C$45","v":145},{"$f":"U73+Center","v":181.05200000000002},null,null,null,null,null,null,null,null,null,null,{"$f":"SIN(H73)*C$46+C$41+Rim_Code*12.7","v":354.952}]
[null,null,null,null,null,null,null,{"$f":"H$83/10+H73","v":-8.3433383299470157E-2},{"$f":"IF(I$83<I$73,COS(H74)*C$46+C$45,(I$83-I$73)/10+I73)","v":144.73671747421804},174.74445812626658,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I$83<I$73,SIN(H74)*C$46+C$41+Rim_Code*12.7,(U$83-U$73)/10+U73)","v":348.64445812626656}]
[null,null,null,null,null,null,null,-0.16686676659894031,143.9487015776985,168.48079840337971,null,null,null,null,null,null,null,null,null,null,342.38079840337969]
[null,null,null,null,null,null,null,-0.25030014989841048,142.64143460974799,162.30459769001322,null,null,null,null,null,null,null,null,null,null,336.2045976900132]
[null,null,null,null,null,null,null,-0.33373353319788063,140.82401134729113,156.25882438444148,null,null,null,null,null,null,null,null,null,null,330.15882438444146]
[null,null,null,null,null,null,null,-0.41716691649735077,138.50907577166828,150.38553948942757,null,null,null,null,null,null,null,null,null,null,324.28553948942755]
[null,null,null,null,null,null,null,-0.50060029979682097,135.71273310329067,144.7256039899458,null,null,null,null,null,null,null,null,null,null,318.62560398994577]
[null,null,null,null,null,null,null,-0.58403368309629111,132.45443775613586,139.31839457953896,null,null,null,null,null,null,null,null,null,null,313.21839457953894]
[null,null,null,null,null,null,null,-0.66746706639576125,128.75685799159459,134.20152971302764,null,null,null,null,null,null,null,null,null,null,308.10152971302762]
[null,null,null,null,null,null,null,-0.7509004496952314,124.64571821328434,129.41060789144905,null,null,null,null,null,null,null,null,null,null,303.31060789144902]
[null,null,null,null,null,null,null,{"$f":"-ACOS(($I$83-C$45)/C$46)","v":-0.83433383299470154},{"$f":"New_Rim_Width*12.7+C$47","v":120.14962},124.97896000000003,null,null,null,null,null,null,null,null,null,null,{"$f":"C$49/2","v":298.87896000000001}]
[null,null,null,null,null,null,null,"Left side"]
[null,null,null,null,null,null,null,null,{"$f":"-I73","v":-145},{"$f":"J73","v":181.05200000000002}]
[null,null,null,null,null,null,null,null,-144.73671747421804,{"$f":"J74","v":174.74445812626658}]
[null,null,null,null,null,null,null,null,-143.9487015776985,168.48079840337971]
[null,null,null,null,null,null,null,null,-142.64143460974799,162.30459769001322]
[null,null,null,null,null,null,null,null,-140.82401134729113,156.25882438444148]
[null,null,null,null,null,null,null,null,-138.50907577166828,150.38553948942757]
[null,null,null,null,null,null,null,null,-135.71273310329067,144.7256039899458]
[null,null,null,null,null,null,null,null,-132.45443775613586,139.31839457953896]
[null,null,null,null,null,null,null,null,-128.75685799159459,134.20152971302764]
[null,null,null,null,null,null,null,null,-124.64571821328434,129.41060789144905]
[null,null,null,null,null,null,null,null,-120.14962,124.97896000000003]
[]
[]
[null,null,null,null,null,null,null,"RIM PROFILE: RIGHT FLANGE"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1.2566370614359172,{"$f":"New_Rim_Width*12.7+F_Top_Rad+COS(H105)*F_Top_Rad","v":126.73566144656199},null,{"$f":"U105+Center","v":124.93503690480401},null,null,null,null,null,null,null,null,null,{"$f":"Rs/2+F_Height-F_Top_Rad+SIN(H105)*F_Top_Rad","v":298.83503690480399}]
[null,null,null,null,null,null,null,1.5707963267948966,{"$f":"New_Rim_Width*12.7+F_Top_Rad+COS(H106)*F_Top_Rad","v":123.8},null,125.40000000000003,null,null,null,null,null,null,null,null,null,299.3]
[null,null,null,null,null,null,null,1.8849555921538759,120.864338553438,null,124.93503690480401,null,null,null,null,null,null,null,null,null,298.83503690480399]
[null,null,null,null,null,null,null,2.1991148575128552,118.2160401032215,null,123.58566144656203,null,null,null,null,null,null,null,null,null,297.48566144656201]
[null,null,null,null,null,null,null,2.5132741228718345,116.114338553438,null,121.48395989677852,null,null,null,null,null,null,null,null,null,295.38395989677849]
[null,null,null,null,null,null,null,2.8274333882308138,114.76496309519604,null,118.83566144656203,null,null,null,null,null,null,null,null,null,292.73566144656201]
[null,null,null,null,null,null,null,3.1415926535897931,114.3,null,115.90000000000003,null,null,null,null,null,null,null,null,null,289.8]
[null,null,null,null,null,null,null,{"$f":"PI()","v":3.1415926535897931},{"$f":"New_Rim_Width*12.7-(F_Bot_Rad+COS(H112)*F_Bot_Rad)","v":114.3},null,114.40000000000003,null,null,null,null,null,null,null,null,null,{"$f":"Rs/2+F_Bot_Rad+SIN(H112)*F_Bot_Rad","v":288.3}]
[null,null,null,null,null,null,null,{"$f":"(H$117-H$112)/5+H112","v":3.4529741411709947},113.98742297247124,null,112.40856911750996,null,null,null,null,null,null,null,null,null,286.30856911750993]
[null,null,null,null,null,null,null,{"$f":"(H$117-H$112)/5+H113","v":3.7643556287521962},113.07975478161994,null,110.60866917218226,null,null,null,null,null,null,null,null,null,284.50866917218224]
[null,null,null,null,null,null,null,{"$f":"(H$117-H$112)/5+H114","v":4.0757371163333973},111.66429272747033,null,109.1734101254815,null,null,null,null,null,null,null,null,null,283.07341012548147]
[null,null,null,null,null,null,null,{"$f":"(H$117-H$112)/5+H115","v":4.3871186039145984},109.87717247816573,null,108.24083167173114,null,null,null,null,null,null,null,null,null,282.14083167173112]
[null,null,null,null,null,null,null,{"$f":"3*PI()/2-5/360","v":4.6985000914958004},107.89027487535664,null,107.90062691893451,null,null,null,null,null,null,null,null,null,281.80062691893448]
[null,null,null,null,null,null,null,null,{"$f":"I117-12.7","v":95.190274875356636},null,106.75700000000006,null,null,null,null,null,null,null,null,null,{"$f":"Rs/2-1.143","v":280.65700000000004}]
[]
[]
[]
[null,null,null,null,null,null,null,"RIM PROFILE: LEFT FLANGE"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"-I105","v":-126.73566144656199},null,{"$f":"K105","v":124.93503690480401}]
[null,null,null,null,null,null,null,null,{"$f":"-I106","v":-123.8},null,125.40000000000003]
[null,null,null,null,null,null,null,null,-120.864338553438,null,124.93503690480401]
[null,null,null,null,null,null,null,null,-118.2160401032215,null,123.58566144656203]
[null,null,null,null,null,null,null,null,-116.114338553438,null,121.48395989677852]
[null,null,null,null,null,null,null,null,-114.76496309519604,null,118.83566144656203]
[null,null,null,null,null,null,null,null,-114.3,null,115.90000000000003]
[null,null,null,null,null,null,null,null,-114.3,null,114.40000000000003]
[null,null,null,null,null,null,null,null,-113.98742297247124,null,112.40856911750996]
[null,null,null,null,null,null,null,null,-113.07975478161994,null,110.60866917218226]
[null,null,null,null,null,null,null,null,-111.66429272747033,null,109.1734101254815]
[null,null,null,null,null,null,null,null,-109.87717247816573,null,108.24083167173114]
[null,null,null,null,null,null,null,null,-107.89027487535664,null,107.90062691893451]
[null,null,null,null,null,null,null,null,-95.190274875356636,null,106.75700000000006]
[]
[null,null,null,null,null,null,null,"TRA MAX BOX: TIRE CROWN"]
[null,null,null,null,null,null,null,"Right side"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ACOS($I$148/MAX_TR)","v":1.5123758819964876},{"$f":"MAX_Envelope_RTW/2","v":153.5},null,null,{"$f":"U148+Center","v":240.11495518695813},null,null,null,null,null,null,null,null,{"$f":"SIN(H148)*MAX_TR+MAX_OD/2-MAX_TR","v":414.0149551869581}]
[null,null,null,null,null,null,null,{"$f":"(H$158-H$148)/10+H148","v":1.5182179264763285},{"$f":"COS(H149)*MAX_TR","v":138.16493467845694},null,null,{"$f":"U149+Center","v":240.96691737084586},null,null,null,null,null,null,null,null,414.86691737084584]
[null,null,null,null,null,null,null,{"$f":"(H$158-H$148)/10+H149","v":1.5240599709561693},{"$f":"COS(H150)*MAX_TR","v":122.82515387243878},null,null,241.72927739214913,null,null,null,null,null,null,null,null,415.62927739214911]
[null,null,null,null,null,null,null,1.5299020154360101,107.48118111925542,null,null,242.40200923198802,null,null,null,null,null,null,null,null,416.302009231988]
[null,null,null,null,null,null,null,1.5357440599158509,92.133540099285554,null,null,242.98508993043754,null,null,null,null,null,null,null,null,416.88508993043752]
[null,null,null,null,null,null,null,1.5415861043956918,76.782754618103496,null,null,243.47849958731069,null,null,null,null,null,null,null,null,417.37849958731067]
[null,null,null,null,null,null,null,1.5474281488755326,61.429348588602082,null,null,243.88222136283878,null,null,null,null,null,null,null,null,417.78222136283875]
[null,null,null,null,null,null,null,1.5532701933553734,46.07384601311189,null,null,244.19624147824572,null,null,null,null,null,null,null,null,418.0962414782457]
[null,null,null,null,null,null,null,1.5591122378352142,30.716770965517309,null,null,244.42054921621695,null,null,null,null,null,null,null,null,418.32054921621693]
[null,null,null,null,null,null,null,1.5649542823150551,15.358647573370229,null,null,244.55513692126681,null,null,null,null,null,null,null,null,418.45513692126679]
[null,null,null,null,null,null,null,{"$f":"PI()/2","v":1.5707963267948966},0,null,null,244.60000000000002,null,null,null,null,null,null,null,null,418.5]
[null,null,null,null,null,null,null,"Left side"]
[null,null,null,null,null,null,null,null,{"$f":"-I148","v":-153.5},null,null,{"$f":"L148","v":240.11495518695813}]
[null,null,null,null,null,null,null,null,-138.16493467845694,null,null,240.96691737084586]
[null,null,null,null,null,null,null,null,-122.82515387243878,null,null,241.72927739214913]
[null,null,null,null,null,null,null,null,-107.48118111925542,null,null,242.40200923198802]
[null,null,null,null,null,null,null,null,-92.133540099285554,null,null,242.98508993043754]
[null,null,null,null,null,null,null,null,-76.782754618103496,null,null,243.47849958731069]
[null,null,null,null,null,null,null,null,-61.429348588602082,null,null,243.88222136283878]
[null,null,null,null,null,null,null,null,-46.07384601311189,null,null,244.19624147824572]
[null,null,null,null,null,null,null,null,-30.716770965517309,null,null,244.42054921621695]
[null,null,null,null,null,null,null,null,-15.358647573370229,null,null,244.55513692126681]
[null,null,null,null,null,null,null,null,0,null,null,244.60000000000002]
[]
[null,null,null,null,null,null,null,"TRA MAX BOX: LT-HF SIDES"]
[null,null,null,null,null,null,null,"Right side"]
[null,null,null,null,null,null,null,null,{"$f":"I148","v":153.5},null,null,{"$f":"U174+Center","v":240.11495518695813},null,null,null,null,null,null,null,null,{"$f":"U148","v":414.0149551869581}]
[null,null,null,null,null,null,null,null,{"$f":"MAX_SW/2","v":156.5},null,null,{"$f":"U175+Center","v":202.8},null,null,null,null,null,null,null,null,{"$f":"Rim_Code*12.7+0.7*MAX_SH","v":376.7}]
[null,null,null,null,null,null,null,null,{"$f":"MAX_SW/2","v":156.5},null,null,{"$f":"U176+Center","v":147.19999999999999},null,null,null,null,null,null,null,null,{"$f":"Rim_Code*12.7+0.3*MAX_SH","v":321.09999999999997}]
[null,null,null,null,null,null,null,null,{"$f":"New_Rim_Width*12.7","v":114.3},null,null,{"$f":"U177+Center","v":107.90000000000003},null,null,null,null,null,null,null,null,{"$f":"Rs/2","v":281.8}]
[null,null,null,null,null,null,null,"Left side"]
[null,null,null,null,null,null,null,null,{"$f":"-I174","v":-153.5},null,null,{"$f":"L174","v":240.11495518695813}]
[null,null,null,null,null,null,null,null,{"$f":"-I175","v":-156.5},null,null,{"$f":"L175","v":202.8}]
[null,null,null,null,null,null,null,null,{"$f":"-I176","v":-156.5},null,null,{"$f":"L176","v":147.19999999999999}]
[null,null,null,null,null,null,null,null,{"$f":"-I177","v":-114.3},null,null,{"$f":"L177","v":107.90000000000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"PLOT RANGE FINDER"]
[]
[null,null,null,null,null,null,null,"Left/Top",{"$f":"-VLOOKUP(MAX_SW,Scale_Tbl2,2)","v":-175},{"$f":"U239+Center","v":21.100000000000023},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(MAX_SW,Scale_Tbl2,3)>VLOOKUP(MAX_SH,Scale_Tbl,3),VLOOKUP(MAX_SW,Scale_Tbl2,3),VLOOKUP(MAX_SH,Scale_Tbl,3))","v":195}]
[]
[null,null,null,null,null,null,null,"Right/Top",{"$f":"VLOOKUP(MAX_SW,Scale_Tbl2,2)","v":175},{"$f":"U241+Center","v":21.100000000000023},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(MAX_SW,Scale_Tbl2,3)>VLOOKUP(MAX_SH,Scale_Tbl,3),VLOOKUP(MAX_SW,Scale_Tbl2,3),VLOOKUP(MAX_SH,Scale_Tbl,3))","v":195}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"LABELING"]
[null,null,null,null,null,null,null,"Scale"]
[null,null,null,null,null,null,null,null,{"$f":"I345+25","v":201.5},null,null,{"$f":"5+U341+Center","v":224.60000000000002},null,null,null,null,null,null,null,null,{"$f":"MAX_OD/2-25","v":393.5}]
[null,null,null,null,null,null,null,null,{"$f":"I341","v":201.5},null,null,{"$f":"55+U342+Center","v":274.60000000000002},null,null,null,null,null,null,null,null,{"$f":"U341","v":393.5},{"$f":"L342-L341&\"mm\"","v":"50mm"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I345+50","v":226.5},null,null,{"$f":"30+U344+Center","v":249.60000000000002},null,null,null,null,null,null,null,null,{"$f":"U341","v":393.5},{"$f":"(I344-I345)&\"mm\"","v":"50mm"}]
[null,null,null,null,null,null,null,null,{"$f":"I175+20","v":176.5},null,null,{"$f":"L344","v":249.60000000000002}]
[null,null,null,null,null,null,null,"Center Table Data"]
[null,null,null,null,null,null,null,null,{"$f":"-59*X_Ratio","v":-76.7},null,null,null,{"$f":"VLOOKUP(MAX_SW,Scale_Tbl2,4)-2*Y_Ratio","v":172.1}]
[null,null,null,null,null,null,null,{"$f":"(Do_nom-Rim_Code)/3+1.6","v":5.2666666666666666},{"$f":"I347+26*X_Ratio","v":-42.9},null,null,null,null,{"$f":"M347","v":172.1},null,null,null,null,null,null,null,{"$f":"\"\"&IF(Prof_Type=\"Custom\",\"    \",\"\")&Prof_Type","v":"TRA Design"}]
[null,null,null,null,null,null,null,null,{"$f":"I348+22*X_Ratio","v":-14.299999999999997},null,null,null,null,null,{"$f":"N348","v":172.1}]
[null,null,null,null,null,null,null,null,{"$f":"I349+19*X_Ratio","v":10.400000000000002},null,null,null,null,null,null,{"$f":"O349","v":172.1},null,null,null,null,null,"Max Envelope"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I347","v":-76.7},null,null,null,{"$f":"VLOOKUP(MAX_SW,Scale_Tbl2,4)-$H$348*Y_Ratio","v":167.36333333333334}]
[null,null,null,null,null,null,null,null,{"$f":"I348+12*X_Ratio","v":-27.299999999999997},null,null,null,null,{"$f":"M352","v":167.36333333333334},null,null,null,null,null,null,null,"New"]
[null,null,null,null,null,null,null,null,{"$f":"I349","v":-14.299999999999997},null,null,null,null,null,{"$f":"N353","v":167.36333333333334}]
[null,null,null,null,null,null,null,null,{"$f":"I350","v":10.400000000000002},null,null,null,null,null,null,{"$f":"O354","v":167.36333333333334},null,null,null,null,null,"Dimensions"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I352","v":-76.7},null,null,null,{"$f":"M352-$H$348*Y_Ratio","v":159.72666666666669},null,null,null,null,null,null,null,null,"OD"]
[null,null,null,null,null,null,null,null,{"$f":"I353-8*X_Ratio","v":-37.699999999999996},null,null,null,null,{"$f":"M357","v":159.72666666666669},null,null,null,null,null,null,null,{"$f":"\"\"&OD&\"mm\"","v":"826mm"}]
[null,null,null,null,null,null,null,null,{"$f":"I354","v":-14.299999999999997},null,null,null,null,null,{"$f":"N358","v":159.72666666666669}]
[null,null,null,null,null,null,null,null,{"$f":"I355+4*X_Ratio","v":15.600000000000001},null,null,null,null,null,null,{"$f":"O359","v":159.72666666666669},null,null,null,null,null,{"$f":"\"\"&MAX_OD&\"mm\"","v":"837mm"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I357","v":-76.7},null,null,null,{"$f":"M357-$H$348*Y_Ratio","v":152.09000000000003},null,null,null,null,null,null,null,null,"SW"]
[null,null,null,null,null,null,null,null,{"$f":"I358","v":-37.699999999999996},null,null,null,null,{"$f":"M362","v":152.09000000000003},null,null,null,null,null,null,null,{"$f":"\"\"&DSW&\"mm\"","v":"290mm"}]
[null,null,null,null,null,null,null,null,{"$f":"I359","v":-14.299999999999997},null,null,null,null,null,{"$f":"N363","v":152.09000000000003}]
[null,null,null,null,null,null,null,null,{"$f":"I360","v":15.600000000000001},null,null,null,null,null,null,{"$f":"O364","v":152.09000000000003},null,null,null,null,null,{"$f":"\"\"&MAX_SW&\"mm\"","v":"313mm"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I362","v":-76.7},null,null,null,{"$f":"M362-$H$348*Y_Ratio","v":144.45333333333338},null,null,null,null,null,null,null,null,"C/Cmax"]
[null,null,null,null,null,null,null,null,{"$f":"I363","v":-37.699999999999996},null,null,null,null,{"$f":"M367","v":144.45333333333338},null,null,null,null,null,null,null,{"$f":"\"\"&RTW&\"mm\"","v":"238mm"}]
[null,null,null,null,null,null,null,null,{"$f":"I364","v":-14.299999999999997},null,null,null,null,null,{"$f":"N368","v":144.45333333333338}]
[null,null,null,null,null,null,null,null,{"$f":"I365","v":15.600000000000001},null,null,null,null,null,null,{"$f":"O369","v":144.45333333333338},null,null,null,null,null,{"$f":"IF(Type=\"P\",\"\"&FIXED(MAX_Envelope_RTW,0)&\"mm\",\"\"&FIXED(MAX_Envelope_RTW,0)&\"mm\")","v":"307mm"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I367","v":-76.7},null,null,null,{"$f":"M367-$H$348*Y_Ratio","v":136.81666666666672},null,null,null,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,{"$f":"I368","v":-37.699999999999996},null,null,null,null,{"$f":"M372","v":136.81666666666672},null,null,null,null,null,null,null,{"$f":"\"\"&Tread_Rad&\"mm\"","v":"1949mm"}]
[null,null,null,null,null,null,null,null,{"$f":"I369","v":-14.299999999999997},null,null,null,null,null,{"$f":"N373","v":136.81666666666672}]
[null,null,null,null,null,null,null,null,{"$f":"I370","v":15.600000000000001},null,null,null,null,null,null,{"$f":"O374","v":136.81666666666672},null,null,null,null,null,{"$f":"\"\"&MAX_Envelope_TR&\"mm\"","v":"2629mm"}]
[]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"U377+Center-27*Y_Ratio","v":66.349999999999994},null,null,null,null,null,null,null,{"$f":"Rim_Code*12.7","v":279.39999999999998},{"$f":"\"Rim Width = \"&Rim","v":"Rim Width = 22x9J"}]
[]
[null,null,null,null,null,null,null,"Generic Dimensioning"]
[null,null,null,null,null,null,null,"MAXIMUM OVERALL WIDTH"]
[]
[null,null,null,null,null,null,null,"Dimension line right point",{"$f":"MAX_SW/2","v":156.5},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(MAX_SW,Scale_Tbl2,4)+8*Y_Ratio","v":186.6}]
[null,null,null,null,null,null,null,"Dimension line left point",{"$f":"-I382","v":-156.5},null,null,null,null,null,null,null,null,{"$f":"R382","v":186.6}]
[]
[null,null,null,null,null,null,null,"Data label positioning line left point",0,null,null,null,null,null,null,null,null,null,null,{"$f":"R383","v":186.6}]
[null,null,null,null,null,null,null,"Data label positioning line right point",0,null,null,null,null,null,null,null,null,null,null,{"$f":"T385","v":186.6}]
[]
[]
[null,null,null,null,null,null,null,"NOMINAL RIM DIAMETER"]
[null,null,null,null,null,null,null,"Right extension line right point",{"$f":"New_Rim_Width*12.7+5","v":119.3},null,null,null,null,null,null,null,{"$f":"U390+Center","v":105.5},null,null,null,{"$f":"Rim_Code*12.7","v":279.39999999999998}]
[null,null,null,null,null,null,null,"Right extension line left point",{"$f":"MAX_SW/2+24","v":180.5},null,null,null,null,null,null,null,{"$f":"U391+Center","v":105.5},null,null,null,{"$f":"U390","v":279.39999999999998}]
[]
[null,null,null,null,null,null,null,"Left extension line right point",{"$f":"-I390","v":-119.3},null,null,null,null,null,null,null,{"$f":"Q390","v":105.5}]
[null,null,null,null,null,null,null,"Left extension line left point",{"$f":"I468-4","v":-185.5},null,null,null,null,null,null,null,{"$f":"Q391","v":105.5}]
[]
[null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,"Upper extension line left point",{"$f":"MAX_SW/2+3","v":159.5},null,null,null,null,null,null,null,{"$f":"U397+Center","v":147.19999999999999},null,null,null,{"$f":"Rim_Code*12.7+0.3*MAX_SH","v":321.09999999999997}]
[null,null,null,null,null,null,null,"Upper extension line right point",{"$f":"I397+9","v":168.5},null,null,null,null,null,null,null,{"$f":"U398+Center","v":147.19999999999999},null,null,null,{"$f":"U397","v":321.09999999999997}]
[]
[null,null,null,null,null,null,null,"Dimension line lower point",{"$f":"I397+5","v":164.5},null,null,null,null,null,null,null,null,{"$f":"Q390","v":105.5}]
[null,null,null,null,null,null,null,"Dimension line upper point",{"$f":"I400","v":164.5},null,null,null,null,null,null,null,null,{"$f":"Q397","v":147.19999999999999}]
[]
[null,null,null,null,null,null,null,"Data label positioning line upper point",{"$f":"I400","v":164.5},null,null,null,null,null,null,null,null,null,null,{"$f":"R400+(R401-R400)/2","v":126.35}]
[null,null,null,null,null,null,null,"Data label positioning line lower point",{"$f":"I401","v":164.5},null,null,null,null,null,null,null,null,null,null,{"$f":"T403","v":126.35}]
[]
[]
[]
[null,null,null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,"Upper extension line left point",{"$f":"MAX_SW/2+3","v":159.5},null,null,null,null,null,null,null,{"$f":"U409+Center","v":202.8},null,null,null,{"$f":"Rim_Code*12.7+0.7*MAX_SH","v":376.7}]
[null,null,null,null,null,null,null,"Upper extension line right point",{"$f":"I409+19","v":178.5},null,null,null,null,null,null,null,{"$f":"U410+Center","v":202.8},null,null,null,{"$f":"U409","v":376.7}]
[]
[null,null,null,null,null,null,null,"Dimension line lower point",{"$f":"I409+15","v":174.5},null,null,null,null,null,null,null,null,{"$f":"R400","v":105.5}]
[null,null,null,null,null,null,null,"Dimension line upper point",{"$f":"I412","v":174.5},null,null,null,null,null,null,null,null,{"$f":"Q409","v":202.8}]
[]
[null,null,null,null,null,null,null,"Data label positioning line lower point",{"$f":"I412","v":174.5},null,null,null,null,null,null,null,null,null,null,{"$f":"R412+(R413-R412)/2","v":154.15}]
[null,null,null,null,null,null,null,"Data label positioning line upper point",{"$f":"I413","v":174.5},null,null,null,null,null,null,null,null,null,null,{"$f":"T415","v":154.15}]
[]
[]
[null,null,null,null,null,null,null,"MEASURING RIM WIDTH"]
[null,null,null,null,null,null,null,"Right extension line upper point",{"$f":"New_Rim_Width*12.7","v":114.3},null,null,null,null,null,null,null,{"$f":"U420+Center-4","v":101.5},null,null,null,{"$f":"Rim_Code*12.7","v":279.39999999999998}]
[null,null,null,null,null,null,null,"Right extension line lower point",{"$f":"I420","v":114.3},null,null,null,null,null,null,null,{"$f":"U420+Center-24*Y_Ratio+10","v":80.7},null,null,null,{"$f":"U420","v":279.39999999999998}]
[]
[null,null,null,null,null,null,null,"Left extension line upper point",{"$f":"-I420","v":-114.3},null,null,null,null,null,null,null,{"$f":"Q420","v":101.5}]
[null,null,null,null,null,null,null,"Left extension line lower point",{"$f":"-I421","v":-114.3},null,null,null,null,null,null,null,{"$f":"Q421","v":80.7}]
[]
[null,null,null,null,null,null,null,"Dimension line right point",{"$f":"I423","v":-114.3},null,null,null,null,null,null,null,null,{"$f":"U420+Center-20*Y_Ratio+10","v":86.5}]
[null,null,null,null,null,null,null,"Dimension line left point",{"$f":"-I426","v":114.3},null,null,null,null,null,null,null,null,{"$f":"R426","v":86.5}]
[]
[null,null,null,null,null,null,null,"Data label positioning line left point",0,null,null,null,null,null,null,null,null,null,null,{"$f":"R426","v":86.5}]
[null,null,null,null,null,null,null,"Data label positioning line right point",0,null,null,null,null,null,null,null,null,null,null,{"$f":"R427","v":86.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"MAXIMUM OVERALL DIAMETER"]
[null,null,null,null,null,null,null,"Upper extension line right point",0,null,null,null,null,null,null,null,{"$f":"U456+Center","v":244.60000000000002},null,null,null,{"$f":"MAX_OD/2","v":418.5}]
[null,null,null,null,null,null,null,"Upper extension line left point",{"$f":"-(MAX_SW/2+53)","v":-209.5},null,null,null,null,null,null,null,{"$f":"Q456","v":244.60000000000002}]
[]
[null,null,null,null,null,null,null,"Dimension line upper point",{"$f":"I457+3","v":-206.5},null,null,null,null,null,null,null,null,null,{"$f":"Q456","v":244.60000000000002}]
[null,null,null,null,null,null,null,"Dimension line lower point",{"$f":"I459","v":-206.5},null,null,null,null,null,null,null,null,null,{"$f":"Q456-16","v":228.60000000000002}]
[]
[null,null,null,null,null,null,null,"Data label positioning line lower point",{"$f":"I459","v":-206.5},null,null,null,null,null,null,null,null,null,null,{"$f":"S460","v":228.60000000000002}]
[null,null,null,null,null,null,null,"Data label positioning line upper point",{"$f":"I462","v":-206.5},null,null,null,null,null,null,null,null,null,null,{"$f":"S460","v":228.60000000000002}]
[]
[]
[]
[null,null,null,null,null,null,null,"MAXIMUM SECTION HEIGHT"]
[null,null,null,null,null,null,null,"Dimension line upper point",{"$f":"-(MAX_SW/2+25)","v":-181.5},null,null,null,null,null,null,null,null,{"$f":"Q456","v":244.60000000000002}]
[null,null,null,null,null,null,null,"Dimension line lower point",{"$f":"I468","v":-181.5},null,null,null,null,null,null,null,null,{"$f":"Rim_Code*12.7+Center","v":105.5}]
[]
[null,null,null,null,null,null,null,"Data label positioning line lower point",{"$f":"I468","v":-181.5},null,null,null,null,null,null,null,null,null,null,{"$f":"T472+MAX_SH/2","v":175}]
[null,null,null,null,null,null,null,"Data label positioning line upper point",{"$f":"I471","v":-181.5},null,null,null,null,null,null,null,null,null,null,{"$f":"R469","v":105.5}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"NOMINAL RIM DIAMETER"]
[null,null,null,null,null,null,null,"Dimension line upper point",{"$f":"MAX_SW/2","v":156.5},null,null,null,null,null,null,null,null,null,{"$f":"U480+Center","v":105.5},null,{"$f":"Rim_Code*12.7","v":279.39999999999998}]
[null,null,null,null,null,null,null,"Dimension line lower point",{"$f":"I480","v":156.5},null,null,null,null,null,null,null,null,null,{"$f":"S480-15","v":90.5}]
[]
[null,null,null,null,null,null,null,"Data label positioning line lower point",{"$f":"I480","v":156.5},null,null,null,null,null,null,null,null,null,null,{"$f":"S481","v":90.5}]
[null,null,null,null,null,null,null,"Data label positioning line upper point",{"$f":"I483","v":156.5},null,null,null,null,null,null,null,null,null,null,{"$f":"T483","v":90.5}]
[]
[]
[]
[null,null,null,null,null,null,null,"C MAX."]
[null,null,null,null,null,null,null,"Dimension line right point",{"$f":"MAX_Envelope_RTW/2","v":153.5},null,null,null,null,null,null,null,null,{"$f":"U489+Center+8","v":252.60000000000002},null,null,{"$f":"MAX_OD/2","v":418.5}]
[null,null,null,null,null,null,null,"Dimension line left point",{"$f":"-I489","v":-153.5},null,null,null,null,null,null,null,null,{"$f":"R489","v":252.60000000000002}]
[]
[null,null,null,null,null,null,null,"Right extension line lower point",{"$f":"I489","v":153.5},null,null,null,null,null,null,null,{"$f":"U492+Center+2","v":242.11495518695813},null,null,null,{"$f":"U148","v":414.0149551869581}]
[null,null,null,null,null,null,null,"Right extension line upper point",{"$f":"I492","v":153.5},null,null,null,null,null,null,null,{"$f":"R489+3","v":255.60000000000002}]
[]
[null,null,null,null,null,null,null,"Left extension line lower point",{"$f":"-I492","v":-153.5},null,null,null,null,null,null,null,{"$f":"Q492","v":242.11495518695813}]
[null,null,null,null,null,null,null,"Left extension line upper point",{"$f":"-I493","v":-153.5},null,null,null,null,null,null,null,{"$f":"Q493","v":255.60000000000002}]
[]
[]
[]
[null,null,null,null,null,null,null,"Data label positioning line left point",0,null,null,null,null,null,null,null,null,null,null,{"$f":"R489","v":252.60000000000002}]
[null,null,null,null,null,null,null,"Data label positioning line right point",{"$f":"I500","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"T500","v":252.60000000000002}]
[null,null,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,"Dimension line right point",{"$f":"I169","v":-15.358647573370229},null,null,null,null,null,null,null,null,null,{"$f":"L169","v":244.55513692126681}]
[null,null,null,null,null,null,null,"Dimension line left point",{"$f":"I503-15","v":-30.358647573370227},null,null,null,null,null,null,null,null,null,{"$f":"J15-16","v":223.10000000000002}]
[null,null,null,null,null,null,null,"Data label positioning line left point",{"$f":"I506-10","v":-40.358647573370227},null,null,null,null,null,null,null,null,null,null,{"$f":"S504","v":223.10000000000002}]
[null,null,null,null,null,null,null,"Data label positioning line right point",{"$f":"I504","v":-30.358647573370227},null,null,null,null,null,null,null,null,null,null,{"$f":"T505","v":223.10000000000002}]
[null,null,null,null,null,null,null,"Center Table Grid Lines"]
[null,null,null,null,null,null,null,null,{"$f":"I347+28*X_Ratio","v":-40.300000000000004},null,null,null,null,null,null,null,{"$f":"VLOOKUP(MAX_SW,Scale_Tbl2,4)+1.5*Y_Ratio","v":177.17500000000001}]
[null,null,null,null,null,null,null,null,{"$f":"I347+114*X_Ratio","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q508","v":177.17500000000001}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I508","v":-40.300000000000004}]
[null,null,null,null,null,null,null,null,{"$f":"I509","v":71.500000000000014}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I347+2*X_Ratio","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q508-2*($H$348-1)*Y_Ratio","v":164.80166666666668}]
[null,null,null,null,null,null,null,null,{"$f":"I512","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q514","v":164.80166666666668}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I514","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q514-$H$348*Y_Ratio","v":157.16500000000002}]
[null,null,null,null,null,null,null,null,{"$f":"I515","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q517","v":157.16500000000002}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I517","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q517-$H$348*Y_Ratio","v":149.52833333333336}]
[null,null,null,null,null,null,null,null,{"$f":"I518","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q520","v":149.52833333333336}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I520","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q520-$H$348*Y_Ratio","v":141.89166666666671}]
[null,null,null,null,null,null,null,null,{"$f":"I521","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q523","v":141.89166666666671}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I523","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q523-$H$348*Y_Ratio","v":134.25500000000005}]
[null,null,null,null,null,null,null,null,{"$f":"I524","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q526","v":134.25500000000005}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I514","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q514","v":164.80166666666668}]
[null,null,null,null,null,null,null,null,{"$f":"I529","v":-74.100000000000009},null,null,null,null,null,null,null,{"$f":"Q527","v":134.25500000000005}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I529+26*X_Ratio","v":-40.300000000000004},null,null,null,null,null,null,null,{"$f":"Q508","v":177.17500000000001}]
[null,null,null,null,null,null,null,null,{"$f":"I532","v":-40.300000000000004},null,null,null,null,null,null,null,{"$f":"Q530","v":134.25500000000005}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I532+42*X_Ratio","v":14.299999999999997},null,null,null,null,null,null,null,{"$f":"Q532","v":177.17500000000001}]
[null,null,null,null,null,null,null,null,{"$f":"I535","v":14.299999999999997},null,null,null,null,null,null,null,{"$f":"Q533","v":134.25500000000005}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I509","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q532","v":177.17500000000001}]
[null,null,null,null,null,null,null,null,{"$f":"I538","v":71.500000000000014},null,null,null,null,null,null,null,{"$f":"Q536","v":134.25500000000005}]

{"sheet":"Calcs","index":6,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["TRA"]
[]
[null,"Independent Variables"]
[]
[null,"Prof_Type",{"$f":"Profile!D2","v":"TRA Design"}]
[null,"Title",{"$f":"\"''\"&Prof_Type&\"'' Tire Profile\"&\" - \"&Dimen&IF(Flag1=TRUE,\" - HWY/Traction Tread - Radial Ply\",\" - DEEP Traction Tread - Radial Ply\")&\"                                                   Estimated Dimensions\"","v":"''TRA Design'' Tire Profile - 33x11.50R22 LT - HWY/Traction Tread - Radial Ply                                                   Estimated Dimensions"},null,"Dr","RIM","SW","Do","H","S.70","S.80","D","AR","Sd"]
[null,"Rim",{"$f":"FIXED(Dr,0)&\"x\"&IF(Contour=\"Meas.\",M_Contour,Contour)","v":"22x9J"},null,{"$f":"Rim_Code","v":22},{"$f":"IF(AR>0.45,VLOOKUP(SN,Tables!$AG$6:$AI$18,2),IF(AR>0.4,VLOOKUP(SN,Tables!$AG$23:$AI$35,2),VLOOKUP(SN,Tables!$AG$39:$AI$51,2)))","v":9},{"$f":"'DATA SHEET'!$K$27","v":11.42},{"$f":"Do_nom-0.48","v":32.520000000000003},{"$f":"(Do-Dr)/2","v":5.2600000000000016},{"$f":"ROUND(+G7*((180-((180*ASIN(F7/G7))/PI()))/135.6),2)","v":10.78},{"$f":"ROUND(+G7*((180-((180*ASIN(F7/G7))/PI()))/126.9),2)","v":11.52},{"$f":"(0.96*J7)-I7","v":5.0887999999999973},{"$f":"((Do-Dr)/2)/SN","v":0.45739130434782621},{"$f":"IF(L7<=0,K7,(K7-(0.7252-0.1297*(L7/K7)+1.0469*((L7/K7)^2))*L7))","v":7.0816033324547139}]
[]
[null,"PROFILE CENTER:",{"$f":"-Rim_Code*12.7+VLOOKUP(MAX_SW,Scale_Tbl2,4)-MAX_SH/2","v":-173.89999999999998}]
[null,"X Ratio:",{"$f":"(VLOOKUP(MAX_SW,Scale_Tbl2,2)+20)/150","v":1.3}]
[null,"Y Ratio:",{"$f":"(VLOOKUP(MAX_SW,Scale_Tbl,3)+20)/200","v":1.45}]
[null,"Tread depth selection",{"$f":"TRA_Window!G4","v":"HWY / TRAC. Tread"},null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"B\",STATUS!B3)),\"B\",\"\")","v":""}]
[null,"Flag1 (Hwy/Traction Tread)",{"$f":"IF(C12=Tables!R46,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"C\",STATUS!B3)),\"C\",\"\")","v":""}]
[null,"Flag2 (Deep Traction Tread)",{"$f":"IF(C12=Tables!R47,TRUE,FALSE)","v":false},null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"D\",STATUS!B3)),\"D\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"E\",STATUS!B3)),\"E\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"F\",STATUS!B3)),\"F\",\"\")","v":""}]
[null,"Linked & Named Variables",null,null,null,null,null,null,null,null,"Standardized LR",{"$f":"IF(ISNUMBER(SEARCH(\"G\",STATUS!B3)),\"G\",\"\")","v":""}]
[null,"Dimen",{"$f":"CONCATENATE(FIXED(Do_nom,0),\"x\"&FIXED(SN,2),\"R\"&FIXED(Rim_Code,0),\" \",,Type)","v":"33x11.50R22 LT"},null,null,null,null,null,null,null,"Highest standardized LR",{"$f":"LOOKUP(2,1/(COUNTIF(L12:L17,\">\"&L12:L17&\"*\")=0),L12:L17)","v":""}]
[null,"Type",{"$f":"'DATA SHEET'!H6","v":"LT"},null,null,null,null,null,null,null,"Requested LR > highest standardized LR",{"$f":"IF(AND(L18<>\"\",'DATA SHEET'!J6<>\"\"),(CODE(UPPER(L18))-64)<(CODE(UPPER('DATA SHEET'!J6))-64),FALSE())","v":false}]
[null,"SW",{"$f":"SN*25.4","v":292.09999999999997}]
[null,"AR",{"$f":"ROUND((Do_nom-Rim_Code)/2/SN*200,-1)/2","v":50}]
[null,"Rim_Code",{"$f":"Rim_Code","v":22}]
[null,"Load_Type"]
[null,"Dr",{"$f":"Rim_Code*25.4","v":558.79999999999995}]
[null,"Rs",{"$f":"VLOOKUP(Rim_Code,Rim_Diams,3)","v":563.6}]
[null,"T_Rim",{"$f":"SN*0.8*25.4","v":233.68}]
[null,"M_Rim",{"$f":"M_Rim","v":9}]
[null,"Min_SF",{"$f":"ROUND(('DATA SHEET'!Y27+0.4*(New_Rim_Width-M_Rim))*25.4,0)+IF(Flag1=TRUE,0,6)","v":1102}]
[null,"DSW (Meas. Rim)",{"$f":"IF(Prof_Type=\"TRA Min SW\",MIN_SW1,IF(Prof_Type=\"TRA MIN OD\",MIN_SW2,IF(Prof_Type=\"Custom\",ROUND(((M_Rim-T_Rim/25.4)*10+Cust_SW),0),ROUND(((M_Rim-T_Rim/25.4)*10+SW)*VLOOKUP(Prof_Type,Profile_Tbl,2),0))))","v":290}]
[null,"DSW (Opt. Rim)",{"$f":"IF(Prof_Type=\"TRA Min SW\",MIN_SW1,IF(Prof_Type=\"TRA MIN OD\",MIN_SW2,IF(Prof_Type=\"Custom\",(New_Rim_Width-M_Rim)*10+Cust_SW,(New_Rim_Width-M_Rim)*10+DSW_M)))","v":290}]
[null,"SH",{"$f":"IF(Prof_Type=\"TRA Min SW\",MIN_SH1,IF(Prof_Type=\"TRA MIN OD\",MIN_SH2,IF(Prof_Type=\"Custom\",(Cust_OD-Dr_mm)/2,Calcs!I7*25.4*VLOOKUP(Prof_Type,Profile_Tbl,3))))+IF(Flag1=TRUE,0,3)","v":133.60400000000004}]
[null," Design O.D.",{"$f":"IF(Prof_Type=\"TRA Min SW\",MIN_OD1,IF(Prof_Type=\"TRA MIN OD\",MIN_OD2,IF(TRA_Window!G4=\"HWY / TRAC. Tread\",'DATA SHEET'!M26,'DATA SHEET'!O26)))","v":826}]
[null,"MAX_SW",{"$f":"ROUND('DATA SHEET'!R27*25.4+(New_Rim_Width-M_Rim)*10,0)","v":313}]
[null,"MAX SH",{"$f":"IF(Flag1=TRUE,ROUND(('DATA SHEET'!T26-Dr_mm)/2,0),ROUND(('DATA SHEET'!T26-Dr_mm)/2,0))","v":139}]
[null,"MAX OD",{"$f":"IF(Flag1=TRUE,'DATA SHEET'!T26,'DATA SHEET'!W26)","v":837}]
[null,"MEAS RIM MAX SW",{"$f":"'DATA SHEET'!R26","v":313}]
[null,"MAX RTW",{"$f":"ROUND(INDEX(RTW_Tbl_X,MATCH(A&\" - TRA Max\",RTW_Tbl_AR,0))*MR_MAX_SW,0)","v":263}]
[null,"MAX Envelope RTW",{"$f":"ROUND(INDEX(RTW_Tbl_X,MATCH(A&\" - TRA Max Envelope\",RTW_Tbl_AR,0))*MR_MAX_SW,0)","v":307}]
[null,"MAX TR",{"$f":"ROUND(INDEX(RTW_Tbl_Trd_Rad__Y,MATCH(A&\" - TRA Max\",RTW_Tbl_AR,0))*MR_MAX_SW,0)","v":2629}]
[null,"MAX Envelope TR",{"$f":"ROUND(INDEX(RTW_Tbl_Trd_Rad__Y,MATCH(A&\" - TRA Max Envelope\",RTW_Tbl_AR,0))*MR_MAX_SW,0)","v":2629}]
[null,"MIN SW1 - SW Priority",{"$f":"(New_Rim_Width-M_Rim)*10+ROUND('DATA SHEET'!K26*0.95,0)","v":276}]
[null,"MIN SW2 - SH Priority",{"$f":"Min_SF-MIN_OD2","v":283}]
[null,"MIN SH1 - SW Priority",{"$f":"ROUND((Min_SF-MIN_SW1-Dr_mm)/2,0)","v":134}]
[null,"MIN SH2 - SH Priority",{"$f":"ROUND(Calcs!I7*0.97*25.4,0)+IF(Flag1=TRUE,0,3)","v":130}]
[null,"MIN OD1 - SW Priority",{"$f":"Min_SF-MIN_SW1","v":826}]
[null,"MIN OD2 - SH Priority",{"$f":"ROUND(2*MIN_SH2+Dr_mm,0)","v":819}]

{"sheet":"Tables","index":7,"n_rows":178,"n_cols":46,"rows_kept":178,"cut":false,"hidden":true,"merged":[[48,14,50,14],[36,32,36,34],[19,32,19,34],[1,32,1,34],[2,32,2,34],[48,15,50,16]]}
[null,null,null,null,null,null,null,null,null,null,"TRA"]
[null,"LI","AVG","LI","Load Index","LOAD\nkg","LOAD\nlb","AVG","Index",null,"Rim Flange Values",null,null,null,null,null,null,null,null,"RIM","mm","Rim Seat",null,null,null,null,null,null,null,null,null,null,"RIM WIDTH / SECTION WIDTH",null,null,null,"FOR ASPECT RATIO ≥ 70",null,"FOR ASPECT RATIO ˂ 70, > 45",null,"FOR ASPECT RATIO ≤ 45, > 40",null,"FOR ASPECT RATIO ≤ 40, > 30",null,"FOR ASPECT RATIO ≤ 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"FOR ASPECT RATIO > 45",null,null,null,"NOMINAL","APPROVED","NOMINAL","APPROVED","NOMINAL","APPROVED","NOMINAL","APPROVED","NOMINAL","APPROVED"]
[null,null,null,null,null,null,null,null,null,null,"Rim Profile ","DX","DY","Flange Height","Flange Rad","Heel Rad","Bmax",null,null,10,254,253.2,null,null,null,null,null,null,null,null,null,null,"NOMINAL","RIM","SECTION",null,"SECT. WIDTH ","RIMS","SECT. WIDTH ","RIMS","SECT. WIDTH ","RIMS","SECT. WIDTH ","RIMS","SECT. WIDTH ","RIMS"]
[null,335,335,335,70,335,740,740,70,null,null,null,null,null,null,null,null,null,null,11,{"$f":"279","v":279},{"$f":"278.6","v":278.60000000000002},null,null,null,null,null,null,null,null,null,null,"SECT. WIDTH","WIDTH","WIDTH"]
[null,345,340,345,71,345,760,{"$f":"AVERAGEA(G5:G6)","v":750},71,null,"B",5.0139599999999991,13.61186,14.4,7.5,4.5,13,null,null,12,305,304,null,null,null,null,null,null,null,null,null,null,7.5,{"$f":"MROUND(AG6*0.8,0.5)","v":6},{"$f":"AG6+(0.4*(AH6-(AG6*0.8)))","v":7.5},null,7.5,"5J, 5½J, 6J, 6½J",7.5,"5½J, 6J, 6½J, 7J",7.5,"6J, 6½J, 7J",7.5,"6½J, 7J, 7½J",7.5,"7J, 7½J"]
[null,355,350,355,72,355,785,772.5,72,null,"J",5.8496199999999998,17.078959999999999,17.5,9.5,6.5,15,null,null,13,330,329.4,null,null,null,null,null,null,null,null,null,null,8.5,7,8.58,null,8.5,"5½J, 6J, 6½J, 7J",8.5,"6J, 6½J, 7J, 7½J",8.5,"7J, 7½J, 8J",8.5,"7J, 7½J, 8J, 8½J",8.5,"7½J, 8J, 8½J"]
[null,365,360,365,73,365,805,795,73,null,"K",7.0205599999999997,18.86458,19.600000000000001,10.7,7.1,15,null,null,14,356,354.8,null,null,null,null,null,null,null,null,null,null,9.5,7.5,9.4599999999999991,null,9.5,"6J, 6½J, 7J, 7½J, 8J",9.5,"6½J, 7J, 7½J, 8J, 8½J",9.5,"7½J, 8J, 8½J, 9J",9.5,"8J, 8½J, 9J, 9½J",9.5,"8½J, 9J, 9½J"]
[null,375,370,375,74,375,825,815,74,null,"L",6.6547999999999998,20.764500000000002,21.6,11.9,7.1,15,null,null,15,381,380.2,null,null,null,null,null,null,null,null,null,null,10.5,8.5,10.54,null,10.5,"7J, 7½J, 8J, 8½J, 9J",10.5,"7½J, 8J, 8½J, 9J, 9½J",10.5,"8½J, 9J, 9½J, 10J",10.5,"9J, 9½J, 10J, 10½J",10.5,"9½J, 10J, 10½J"]
[null,387,381,387,75,387,855,840,75,null,"T",5.8496199999999998,17.078959999999999,18,8.9,6.35,15,null,null,16,406,405.6,null,null,null,null,null,null,null,null,null,null,11.5,9,11.42,null,11.5,"7½J, 8J, 8½J, 9J, 9½J, 10J",11.5,"8J, 8½J, 9J, 9½J, 10J, 10½J",11.5,"9J, 9½J, 10J, 10½J, 11J",11.5,"10J, 10½J, 11J, 11½J",11.5,"10½J, 11J, 11½J"]
[null,400,394,400,76,400,880,867.5,76,null,null,null,null,null,null,null,null,null,null,17,432,436.6,null,null,null,null,null,null,null,null,null,null,12.5,{"$f":"MROUND(AG11*0.8,0.5)","v":10},{"$f":"AG11+(0.4*(AH11-(AG11*0.8)))","v":12.5},null,12.5,"8J, 8½J, 9J, 9½J, 10J, 10½J",12.5,"8½J, 9J, 9½J, 10J, 10½J, 11J",12.5,"10J, 10½J, 11J, 11½J, 12J",12.5,"10½J, 11J, 11½J, 12J, 12½J",12.5,"11½J, 12J, 12½J"]
[null,412,406,412,77,412,910,895,77,null,null,null,null,null,null,null,null,null,null,18,457,462,null,null,null,null,null,null,null,null,null,null,13.5,11,13.58,null,13.5,"9J, 9½J, 10J, 10½J, 11J, 11½J",13.5,"9½J, 10J, 10½J, 11J, 11½J, 12J",13.5,"11J, 11½J, 12J, 12½J, 13J",13.5,"11½J, 12J, 12½J, 13J, 13½J",13.5,"12J, 12½J, 13J, 13½J"]
[null,425,419,425,78,425,935,922.5,78,null,"Profile Sizing Factors",null,null,null,null,null,null,null,null,19,483,487.4,null,null,null,null,null,null,null,null,null,null,14.5,11.5,14.459999999999999,null,14.5,"9½J, 10J, 10½J, 11J, 11½J, 12J, 12½J",14.5,"10J, 10½J, 11J, 11½J, 12J, 12½J, 13J",14.5,"11½J, 12J, 12½J, 13J, 13½J, 14J",14.5,"12½J, 13J, 13½J, 14J, 14½J",14.5,"13J, 13½J, 14J, 14½J"]
[null,437,431,437,79,437,965,950,79,null,null,null,null,"\"Custom\" Values",null,null,null,null,null,{"$f":"20","v":20},508,512.79999999999995,null,null,null,null,null,null,null,null,null,null,15.5,12.5,15.54,null,15.5,"10J, 10½J, 11J, 11½J, 12J, 12½J, 13J",15.5,"11J, 11½J, 12J, 12½J, 13J, 13½J, 14J",15.5,"12½J, 13J, 13½J, 14J, 14½J",15.5,"13J, 13½J, 14J, 14½J, 15J, 15½J",15.5,"14J, 14½J, 15J, 15½J"]
[null,450,444,450,80,450,990,{"$f":"AVERAGEA(G14:G15)","v":977.5},80,null,null,"Width %","SH %","Shldr Rad","Width","OD","RTW (X)","Trd Rad (Y)",null,{"$f":"21","v":21},533,538.20000000000005,null,null,null,null,null,null,null,null,null,null,16.5,13,16.419999999999998,null,16.5,"11J, 11½J. 12J, 12½J, 13J, 13½J, 14J",16.5,"11½J. 12J, 12½J, 13J, 13½J, 14J, 14½J, 15J",16.5,"13J, 13½J, 14J, 14½J, 15J, 15½J",16.5,"14J, 14½J, 15J, 15½J, 16J, 16½J",16.5,"15J, 15½J, 16J, 16½J"]
[null,462,456,462,81,462,1020,1005,81,null,"Custom",1,1,30,{"$f":"Cust_SW","v":300},{"$f":"Cust_OD","v":925},{"$f":"Cust_C","v":250},{"$f":"Cust_R","v":1300},null,22,559,563.6,null,null,null,null,null,null,null,null,null,null,17.5,14,17.5,null,17.5,"11½J. 12J, 12½J, 13J, 13½J, 14J, 14½J, 15J",17.5,"12½J, 13J, 13½J, 14J, 14½J, 15J, 15½J, 16J",17.5,"14J, 14½J, 15J, 15½J, 16J, 16½J",17.5,"15J, 15½J, 16J, 16½J, 17J, 17½J",17.5,"16J, 16½J, 17J, 17½J"]
[null,475,469,475,82,475,1045,1032.5,82,null,"TRA Design",1,1,{"$f":"20","v":20},null,null,null,null,null,{"$f":"23","v":23},584,589,null,null,null,null,null,null,null,null,null,null,18.5,15,18.579999999999998,null,18.5,"12J, 12½J, 13J, 13½J, 14J, 14½J, 15J, 15½J",18.5,"13J, 13½J, 14J, 14½J, 15J, 15½J, 16J, 16½J",18.5,"15J, 15½J, 16J, 16½J, 17J, 17½J",18.5,"15½J, 16J, 16½J, 17J, 17½J, 18J, 18½J",18.5,"16½J, 17J, 17½J, 18J, 18½J"]
[null,487,481,487,83,487,1075,1060,83,null,"TRA Max",1.07,1.03,{"$f":"20","v":20},null,null,null,null,null,{"$f":"24","v":24},610,614.4,null,null,null,null,null,null,null,null,null,null,19.5,15.5,19.46,null,19.5,"12½J, 13J, 13½J, 14J, 14½J, 15J, 15½J, 16J, 16½J",19.5,"13½J, 14J, 14½J, 15J, 15½J, 16J, 16½J, 17J, 17½J",19.5,"15½J, 16J, 16½J, 17J, 17½J, 18J, 18½J",19.5,"16½J, 17J, 17½J, 18J, 18½J, 19J, 19½J",19.5,"17½J, 18J, 18½J, 19J, 19½J"]
[null,500,494,500,84,500,1100,1087.5,84,null,"TRA Min OD",0.95,0.97,{"$f":"20","v":20},null,null,null,null,null,{"$f":"25","v":25},635,639.79999999999995]
[null,515,508,515,85,515,1135,1117.5,85,null,"TRA Min SW",0.95,0.97,{"$f":"20","v":20},null,null,null,null,null,{"$f":"26","v":26},660.4,665.2,{"$f":"T20*25.4+4.8","v":665.19999999999993},null,null,null,null,null,null,null,null,null,"FOR ASPECT RATIO ≤ 45, > 40"]
[null,530,523,530,86,530,1170,1152.5,86,null,null,null,null,null,null,null,null,null,null,27,685.8,690.6,{"$f":"T21*25.4+4.8","v":690.59999999999991},null,null,null,null,null,null,null,null,null,"NOMINAL","RIM","SECTION"]
[null,545,538,545,87,545,1200,1185,87,null,null,null,null,null,null,null,null,null,null,28,711.2,716,{"$f":"T22*25.4+4.8","v":715.99999999999989},null,null,null,null,null,null,null,null,null,"SECT. WIDTH","WIDTH","WIDTH"]
[null,560,553,560,88,560,1235,1217.5,88,null,"Profiles",null,null,null,"Graph Scaling",null,null,null,null,29,736.6,741.4,{"$f":"T23*25.4+4.8","v":741.39999999999986},null,null,null,null,null,null,null,null,null,7.5,{"$f":"MROUND(AG23*0.85,0.5)","v":6.5},{"$f":"AG23+(0.4*(AH23-(AG23*0.85)))","v":7.55}]
[null,580,570,580,89,580,1280,1257.5,89,null,null,null,null,null,null,null,null,null,null,30,762,766.8,{"$f":"T24*25.4+4.8","v":766.8},null,null,null,null,null,null,null,null,null,8.5,7,8.41]
[null,600,590,600,90,600,1325,1302.5,90,null,"AR","RTW (X)","Trd Rad (Y)",null,"MAX SH","X","Y","Height",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5,8,9.4700000000000006]
[null,615,608,615,91,615,1355,1340,91,null,"30 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,0,100,120,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5,9,10.530000000000001]
[null,630,623,630,92,630,1390,1372.5,92,null,"30 - TRA Design",0.9,{"$f":"M28*0.8","v":9.6000000000000014},null,75,100,120,100,null,"Optional Rim Widths",null,null,null,"Min Rim Determination",null,null,null,null,null,null,null,null,11.5,10,11.59]
[null,650,640,650,93,650,1435,1412.5,93,null,"30 - TRA Max",0.92,{"$f":"M29","v":12},null,100,125,145,125,null,null,null,null,null,{"$f":"'DATA SHEET'!AA26","v":"8J, 8½J, 9J, 9½J, 10J, 10½J"},null,null,null,null,null,null,null,null,12.5,10.5,12.45]
[null,670,660,670,94,670,1475,1455,94,null,"30 - TRA Max Envelope",0.98,12,null,125,150,170,150,null,null,"No","Meas.",null,{"$f":"MID(X$28,1,1)","v":"8"},{"$f":"IF(X29=\"½\",12,X29*1)","v":8},{"$f":"ISNUMBER(Y29)","v":true},{"$f":"IF(Z29=TRUE,Y29,\"\")&IF(Z30=TRUE,Y30,\"\")&IF(Z31=TRUE,Y31,\"\")&IF(Z32=TRUE,Y32,\"\")","v":"8"},{"$f":"IF(RIGHT(AA29,2)=\"15\",\".5\",\"\")","v":""},{"$f":"IF(LEFT(AA29)*1>1,LEFT(AA29,1)&AB29,LEFT(AA29,2))","v":"8"},{"$f":"AC29*1","v":8},{"$f":"IF(OR(RIGHT(AA29,2)=\"12\",RIGHT(AA29,2)=\"50\"),0.5,0)","v":0},null,13.5,11.5,13.51]
[null,690,680,690,95,690,1520,1497.5,95,null,"30 - TRA Min OD",0.86,{"$f":"M28*0.7","v":8.3999999999999986},null,150,175,195,175,null,null,{"$f":"MIN_RIM","v":8},{"$f":"IF(U30=\"\",\"\",IF(R_Flange=\"B\",FIXED(U30,2),TRUNC(U30,0)&IF(U30-TRUNC(U30,0)=0.5,\"½\",\"\"))&R_Flange)","v":"8J"},null,{"$f":"MID(X$28,2,1)","v":"J"},{"$f":"IF(X30=\"½\",12,X30*1)","v":{"$error":"#VALUE!"}},{"$f":"ISNUMBER(Y30)","v":false},null,null,null,null,null,null,14.5,12.5,14.57]
[null,710,700,710,96,710,1565,1542.5,96,null,"30 - TRA Min SW",0.86,{"$f":"M30","v":8.3999999999999986},null,175,200,220,200,null,null,{"$f":"IF(OR(U30=\"\",U30=MAX_RIM),\"\",U30+0.5)","v":8.5},"8½J",null,{"$f":"MID(X$28,3,1)","v":","},{"$error":"#VALUE!"},{"$f":"ISNUMBER(Y31)","v":false},null,null,null,null,null,null,15.5,13,15.43]
[null,730,720,730,97,730,1610,1587.5,97,null,"35 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,200,225,245,225,null,null,9,"9J",null,{"$f":"MID(X$28,4,1)","v":" "},{"$error":"#VALUE!"},{"$f":"ISNUMBER(Y32)","v":false},null,null,null,null,null,null,16.5,14,16.489999999999998]
[null,750,740,750,98,750,1655,1632.5,98,null,"35 - TRA Design",{"$f":"L27-0.02","v":0.88},{"$f":"M34*0.8","v":9.6000000000000014},null,225,250,270,250,null,null,9.5,"9½J",null,null,null,null,null,null,null,null,null,null,17.5,15,17.55]
[null,775,763,775,99,775,1710,1682.5,99,null,"35 - TRA Max",{"$f":"L28-0.02","v":0.9},{"$f":"M35","v":12},null,null,null,null,null,null,null,10,"10J",null,null,null,null,null,null,null,null,null,null,18.5,15.5,18.41]
[null,800,788,800,100,800,1765,1737.5,100,null,"35 - TRA Max Envelope",0.98,12,null,"MAX SW","X","Y","Height",null,null,10.5,"10½J",null,null,null,null,null,null,null,null,null,null,19.5,16.5,19.47]
[null,825,813,825,101,825,1820,1792.5,101,null,"35 - TRA Min OD",{"$f":"L30-0.02","v":0.84},{"$f":"M34*0.7","v":8.3999999999999986},null,0,100,120,100,null,null,"","",null,"Max Rim Determination"]
[null,850,838,850,102,850,1875,1847.5,102,null,"35 - TRA Min SW",{"$f":"L31-0.02","v":0.84},{"$f":"M36","v":8.3999999999999986},null,150,100,120,100,null,null,null,null,null,{"$f":"RIGHT(X$28,5)","v":" 10½J"},null,null,null,null,null,null,null,null,"FOR ASPECT RATIO ≤ 40"]
[null,875,863,875,103,875,1930,1902.5,103,null,"40 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,200,125,145,125,null,"Min_Rim",{"$f":"AD29+AE29","v":8},null,null,{"$f":"MID(X$37,1,1)","v":" "},{"$f":"IF(X38=\"½\",12,X38*1)","v":{"$error":"#VALUE!"}},{"$f":"ISNUMBER(Y38)","v":false},{"$f":"IF(Z38=TRUE,Y38,\"\")&IF(Z39=TRUE,Y39,\"\")&IF(Z40=TRUE,Y40,\"\")&IF(Z41=TRUE,Y41,\"\")&IF(Z42=TRUE,Y42,\"\")&IF(Z43=TRUE,Y43,\"\")","v":"1012"},{"$f":"IF(RIGHT(AA38,2)=\"15\",\".5\",\"\")","v":""},{"$f":"IF(LEFT(AA38)*1>1,LEFT(AA38,1)&AB38,LEFT(AA38,2))","v":"10"},{"$f":"AC38*1","v":10},{"$f":"IF(OR(MID(AA38,2,2)=\"12\",MID(AA38,3,2)=\"12\",RIGHT(AA38,2)=\"50\"),0.5,0)","v":0.5},null,"SECT. WIDTH","WIDTH","WIDTH"]
[null,900,888,900,104,900,1985,1957.5,104,null,"40 - TRA Design",{"$f":"L33-0.02","v":0.86},{"$f":"M40*0.8","v":8.4},null,250,150,170,150,null,"Max_Rim",{"$f":"AD38+AE38","v":10.5},null,null,{"$f":"MID(X$37,2,1)","v":"1"},{"$f":"IF(X39=\"½\",12,X39*1)","v":1},{"$f":"ISNUMBER(Y39)","v":true},null,null,null,null,null,null,7.5,{"$f":"MROUND(AG39*0.9,0.5)","v":7},{"$f":"AG39+(0.4*(AH39-(AG39*0.9)))","v":7.6}]
[null,925,913,925,105,925,2040,2012.5,105,null,"40 - TRA Max",{"$f":"L34-0.02","v":0.88},{"$f":"M41","v":10.5},null,300,175,195,175,null,"OPT Rim",{"$f":"IF(Contour=\"Meas.\",0,CONCATENATE(LEFT(Contour,1),IF(ISNUMBER(MID(Contour,2,1)*1),MID(Contour,2,1),IF(MID(Contour,2,1)=\"½\",\".5\",\"\")),IF(ISNUMBER(MID(Contour,3,1)*1),MID(Contour,3,1),IF(MID(Contour,3,1)=\"½\",\".5\",\"\")))*IF(R_Flange=\"B\",0.1,1))","v":0},{"$f":"IF(R_Flange=\"F\",FIXED(O_Rim,2),TRUNC(O_Rim,0)&IF(O_Rim-TRUNC(O_Rim,0)=0.5,\"½\",\"\"))&R_Flange","v":"0J"},{"$f":"TRA_Window!D6","v":"Meas."},{"$f":"MID(X$37,3,1)","v":"0"},{"$f":"IF(X40=\"½\",12,X40*1)","v":0},{"$f":"ISNUMBER(Y40)","v":true},null,null,null,null,null,null,8.5,7.5,8.44]
[null,950,938,950,106,950,2095,2067.5,106,null,"40 - TRA Max Envelope",0.98,10.5,null,350,200,220,200,null,"Meas. Rim",{"$f":"M_Rim","v":9},{"$f":"IF(R_Flange=\"B\",FIXED(U41,2),TRUNC(U41,0)&IF(U41-TRUNC(U41,0)=0.5,\"½\",\"\"))&R_Flange","v":"9J"},null,{"$f":"MID(X$37,4,1)","v":"½"},{"$f":"IF(X41=\"½\",12,X41*1)","v":12},{"$f":"ISNUMBER(Y41)","v":true},null,null,null,null,null,null,9.5,8.5,9.48]
[null,975,963,975,107,975,2150,2122.5,107,null,"40 - TRA Min OD",{"$f":"L36-0.02","v":0.82},{"$f":"M40*0.7","v":7.35},null,400,225,245,225,null,null,null,null,null,{"$f":"MID(X$37,5,1)","v":"J"},{"$f":"IF(X42=\"½\",12,X42*1)","v":{"$error":"#VALUE!"}},{"$f":"ISNUMBER(Y42)","v":false},null,null,null,null,null,null,10.5,9.5,10.52]
[null,1000,988,1000,108,1000,2205,2177.5,108,null,"40 - TRA Min SW",{"$f":"L37-0.02","v":0.82},{"$f":"M42","v":7.35},null,450,250,270,250,null,null,null,null,null,{"$f":"MID(X$37,6,1)","v":""},null,null,null,null,null,null,null,null,11.5,10.5,11.56]
[null,1030,1015,1030,109,1030,2270,2237.5,109,null,"45 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.5,11.5,12.6]
[null,1060,1045,1060,110,1060,2335,2302.5,110,null,"45 - TRA Design",{"$f":"L39-0.02","v":0.84},{"$f":"M46*0.8","v":7.4400000000000013},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.5,12,13.44]
[null,1090,1075,1090,111,1090,2405,2370,111,null,"45 - TRA Max",{"$f":"L40-0.02","v":0.86},{"$f":"M47","v":9.3000000000000007},null,null,null,null,"HWY / TRAC. Tread",null,"OD","SW","RIM","LR",null,"Flags",null,null,null,null,null,null,null,14.5,13,14.48]
[null,1120,1105,1120,112,1120,2470,{"$f":"AVERAGEA(G46:G47)","v":2437.5},112,null,"45 - TRA Max Envelope",0.98,9.3000000000000007,null,null,null,null,"DEEP TRAC. Tread",null,24,7.5,13,"B",null,"Incorrect profile",null,{"$f":"OR(A<30,A>105)","v":false},null,null,null,null,null,15.5,14,15.52]
[null,1150,1135,1150,113,1150,2535,2502.5,113,null,"45 - TRA Min OD",{"$f":"L42-0.02","v":0.79999999999999993},{"$f":"M46*0.7","v":6.51},null,null,null,null,null,null,25,8.5,14,"C",null,"Out of LI range",null,{"$f":"ISERROR(VLOOKUP(1.57*0.425*(75^0.585)*(S.80^1.28)*(Dr+Sd)*(H/S.80)*0.4536,LI_Table,5))","v":false},null,null,null,null,null,16.5,15,16.559999999999999]
[null,1180,1165,1180,114,1180,2600,2567.5,114,null,"45 - TRA Min SW",{"$f":"L43-0.02","v":0.79999999999999993},{"$f":"M48","v":6.51},null,"Intermediate psi","Intermediate kPa & corresponding psi per EDI 8-19",null,null,null,26,9.5,15,"D",null,"Out of scope",null,{"$f":"OR(Incorrect_Profile,Out_of_LI_Range)","v":false},null,null,null,null,null,17.5,16,17.600000000000001]
[null,1215,1198,1215,115,1215,2680,2640,115,null,"50 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,null,null,null,null,null,27,10.5,16,"E",null,null,null,null,null,null,null,null,null,18.5,16.5,18.439999999999998]
[null,1250,1233,1250,116,1250,2755,2717.5,116,null,"50 - TRA Design",{"$f":"L45-0.02","v":0.82},{"$f":"M52*0.8","v":6.7200000000000006},null,null,null,null,null,null,28,11.5,17,"F",null,null,null,null,null,null,null,null,null,19.5,17.5,19.48]
[null,1285,1268,1285,117,1285,2835,2795,117,null,"50 - TRA Max",{"$f":"L46-0.02","v":0.84},{"$f":"M53","v":8.4},null,26,180,26,null,null,29,12.5,18]
[null,1320,1303,1320,118,1320,2910,2872.5,118,null,"50 - TRA Max Envelope",0.98,8.4,null,27,190,28,null,null,30,13.5,20]
[null,1360,1340,1360,119,1360,3000,2955,119,null,"50 - TRA Min OD",{"$f":"L48-0.02","v":0.77999999999999992},{"$f":"M52*0.7","v":5.88},null,28,200,29,null,null,31,14.5,22]
[null,1400,1380,1400,120,1400,3085,3042.5,120,null,"50 - TRA Min SW",{"$f":"L49-0.02","v":0.77999999999999992},{"$f":"M54","v":5.88},null,29,220,32,null,null,32,15.5,24]
[null,1450,1425,1450,121,1450,3195,3140,121,null,"55 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,31,230,33,null,null,33,16.5,26]
[null,1500,1475,1500,122,1500,3305,3250,122,null,"55 - TRA Design",{"$f":"L51-0.02","v":0.79999999999999993},{"$f":"M58*0.8","v":6.120000000000001},null,32,240,35,null,null,34,17.5,28]
[null,1550,1525,1550,123,1550,3415,3360,123,null,"55 - TRA Max",{"$f":"L52-0.02","v":0.82},{"$f":"M59","v":7.65},null,33,260,38,null,null,35,18.5]
[null,1600,1575,1600,124,1600,3525,3470,124,null,"55 - TRA Max Envelope",0.98,7.65,null,34,270,39,null,null,36,19.5]
[null,1650,1625,1650,125,1650,3640,3582.5,125,null,"55 - TRA Min OD",{"$f":"L54-0.02","v":0.7599999999999999},{"$f":"M58*0.7","v":5.3549999999999995},null,36,290,42,null,null,37]
[null,1700,1675,1700,126,1700,3750,3695,126,null,"55 - TRA Min SW",{"$f":"L55-0.02","v":0.7599999999999999},{"$f":"M60","v":5.3549999999999995},null,37,300,44,null,null,38]
[null,1750,1725,1750,127,1750,3860,3805,127,null,"60 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,38,320,46,null,null,39]
[null,1800,1775,1800,128,1800,3970,3915,128,null,"60 - TRA Design",{"$f":"L57-0.02","v":0.77999999999999992},{"$f":"M64*0.8","v":5.04},null,39,330,48,null,null,40]
[null,1850,1825,1850,129,1850,4080,4025,129,null,"60 - TRA Max",{"$f":"L58-0.02","v":0.79999999999999993},{"$f":"M65","v":6.3},null,41,340,49,null,null,41]
[null,1900,1875,1900,130,1900,4190,4135,130,null,"60 - TRA Max Envelope",0.95,6.3,null,42,360,52,null,null,42]
[null,1950,1925,1950,131,1950,4300,4245,131,null,"60 - TRA Min OD",{"$f":"L60-0.02","v":0.73999999999999988},{"$f":"M64*0.7","v":4.4099999999999993},null,43,390,57,null,null,43]
[null,2000,1975,2000,132,2000,4410,4355,132,null,"60 - TRA Min SW",{"$f":"L61-0.02","v":0.73999999999999988},{"$f":"M66","v":4.4099999999999993},null,44,400,58,null,null,44]
[null,2060,2030,2060,133,2060,4540,4475,133,null,"65 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,46,420,61,null,null,45]
[null,2120,2090,2120,134,2120,4675,4607.5,134,null,"65 - TRA Design",{"$f":"L63-0.02","v":0.7599999999999999},{"$f":"M70*0.8","v":4.6399999999999997},null,47,440,64,null,null,46]
[null,2180,2150,2180,135,2180,4805,4740,135,null,"65 - TRA Max",{"$f":"L64-0.02","v":0.77999999999999992},{"$f":"M71","v":5.8},null,48,460,67,null,null,47]
[null,2240,2210,2240,136,2240,4940,4872.5,136,null,"65 - TRA Max Envelope",0.95,5.8,null,49,470,68,null,null,48]
[null,2300,2270,2300,137,2300,5070,5005,137,null,"65 - TRA Min OD",{"$f":"L66-0.02","v":0.71999999999999986},{"$f":"M70*0.7","v":4.0599999999999996},null,51,490,71]
[null,2360,2330,2360,138,2360,5205,5137.5,138,null,"65 - TRA Min SW",{"$f":"L67-0.02","v":0.71999999999999986},{"$f":"M72","v":4.0599999999999996},null,52,500,73]
[null,2430,2395,2430,139,2430,5355,5280,139,null,"70 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,53,510,74]
[null,2500,2465,2500,140,2500,5510,5432.5,140,null,"70 - TRA Design",{"$f":"L69-0.02","v":0.73999999999999988},{"$f":"M76*0.8","v":3.84},null,54,530,77]
[null,2575,2538,2575,141,2575,5675,5592.5,141,null,"70 - TRA Max",{"$f":"L70-0.02","v":0.7599999999999999},{"$f":"M77","v":4.8},null,56,540,78]
[null,2650,2613,2650,142,2650,5840,5757.5,142,null,"70 - TRA Max Envelope",0.93,4.8,null,57,{"$f":"IF(SN>11.5,\"\",560)","v":560},81]
[null,2725,2688,2725,143,2725,6005,5922.5,143,null,"70 - TRA Min OD",{"$f":"L72-0.02","v":0.69999999999999984},{"$f":"M76*0.7","v":3.36},null,58,{"$f":"IF(SN>11.5,\"\",580)","v":580},84]
[null,2800,2763,2800,144,2800,6175,{"$f":"AVERAGEA(G78:G79)","v":6090},144,null,"70 - TRA Min SW",{"$f":"L73-0.02","v":0.69999999999999984},{"$f":"M78","v":3.36},null,59,{"$f":"IF(SN>11.5,\"\",590)","v":590},86]
[null,2900,2850,2900,145,2900,6395,6285,145,null,"75 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,61,{"$f":"IF(SN>11.5,\"\",600)","v":600},87]
[null,3000,2950,3000,146,3000,6610,6502.5,146,null,"75 - TRA Design",{"$f":"L75-0.02","v":0.71999999999999986},{"$f":"M82*0.8","v":3.16},null,62,{"$f":"IF(SN>11.5,\"\",610)","v":610},88]
[null,3075,3038,3075,147,3075,6780,6695,147,null,"75 - TRA Max",{"$f":"L76-0.02","v":0.73999999999999988},{"$f":"M83","v":3.95},null,63,{"$f":"IF(SN>11.5,\"\",620)","v":620},90]
[null,3150,3113,3150,148,3150,6940,6860,148,null,"75 - TRA Max Envelope",0.9,3.95,null,64,{"$f":"IF(SN>11.5,\"\",640)","v":640},93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - Custom",0.8,4.333333333333333]
[null,3250,3200,3250,149,3250,7160,7050,149,null,"75 - TRA Min OD",{"$f":"L78-0.02","v":0.67999999999999983},{"$f":"M82*0.7","v":2.7650000000000001},null,66,"Current",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - TRA Design",0.9,9.6000000000000014]
[null,3350,3300,3350,150,3350,7390,7275,150,null,"75 - TRA Min SW",{"$f":"L79-0.02","v":0.67999999999999983},{"$f":"M84","v":2.7650000000000001},null,67,{"$f":"'DATA SHEET'!K31","v":0},{"$f":"VLOOKUP(P85,P52:Q83,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - TRA Max",0.92,12]
[null,3450,3400,3450,151,3450,7610,7500,151,null,"80 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - TRA Max Envelope",0.98,12]
[null,3550,3500,3550,152,3550,7830,7720,152,null,"80 - TRA Design",{"$f":"L81-0.02","v":0.69999999999999984},{"$f":"M88*0.8","v":3},null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - TRA Min OD",0.86,8.3999999999999986]
[null,3650,3600,3650,153,3650,8050,7940,153,null,"80 - TRA Max",{"$f":"L82-0.02","v":0.71999999999999986},{"$f":"M89","v":3.75},null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - TRA Min SW",0.86,8.3999999999999986]
[null,3750,3700,3750,154,3750,8270,8160,154,null,"80 - TRA Max Envelope",0.9,3.75,null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - Custom",0.8,4.333333333333333]
[null,3875,3813,3875,155,3875,8540,8405,155,null,"80 - TRA Min OD",{"$f":"L84-0.02","v":0.65999999999999981},{"$f":"M88*0.7","v":2.625},null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - TRA Design",0.88,9.6000000000000014]
[null,4000,3938,4000,156,4000,8820,8680,156,null,"80 - TRA Min SW",{"$f":"L85-0.02","v":0.65999999999999981},{"$f":"M90","v":2.625},null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - TRA Max",0.9,12]
[null,4125,4063,4125,157,4125,9090,8955,157,null,"85 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - TRA Max Envelope",0.98,12]
[null,4250,4188,4250,158,4250,9370,9230,158,null,"85 - TRA Design",{"$f":"L87-0.02","v":0.67999999999999983},{"$f":"M94*0.8","v":3},null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - TRA Min OD",0.84,8.3999999999999986]
[null,4375,4313,4375,159,4375,9650,9510,159,null,"85 - TRA Max",{"$f":"L88-0.02","v":0.69999999999999984},{"$f":"M95","v":3.75},null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 - TRA Min SW",0.84,8.3999999999999986]
[null,4500,4438,4500,160,4500,9920,9785,160,null,"85 - TRA Max Envelope",0.9,3.75,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - Custom",0.8,4.333333333333333]
[null,4625,4563,4625,161,4625,10200,10060,161,null,"85 - TRA Min OD",{"$f":"L90-0.02","v":0.63999999999999979},{"$f":"M94*0.7","v":2.625},null,{"$f":"IF(SN>11.5,\"\",81)","v":81},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - TRA Design",0.86,8.4]
[null,4750,4688,4750,162,4750,10500,10350,162,null,"85 - TRA Min SW",{"$f":"L91-0.02","v":0.63999999999999979},{"$f":"M96","v":2.625},null,{"$f":"IF(SN>11.5,\"\",82)","v":82},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - TRA Max",0.88,10.5]
[null,4875,4813,4875,163,4875,10700,10600,163,null,"90 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,{"$f":"IF(SN>11.5,\"\",83)","v":83},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - TRA Max Envelope",0.98,10.5]
[null,5000,4938,5000,164,5000,11000,10850,164,null,"90 - TRA Design",{"$f":"L93-0.02","v":0.65999999999999981},{"$f":"M100*0.8","v":3},null,{"$f":"IF(SN>11.5,\"\",84)","v":84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - TRA Min OD",0.82,7.35]
[null,5150,5075,5150,165,5150,11400,11200,165,null,"90 - TRA Max",{"$f":"L94-0.02","v":0.67999999999999983},{"$f":"M101","v":3.75},null,{"$f":"IF(SN>11.5,\"\",85)","v":85},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - TRA Min SW",0.82,7.35]
[null,5300,5225,5300,166,5300,11700,11550,166,null,"90 - TRA Max Envelope",0.9,3.75,null,{"$f":"IF(SN>11.5,\"\",86)","v":86},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - Custom",0.83333333333333337,4.333333333333333]
[null,5450,5375,5450,167,5450,12000,11850,167,null,"90 - TRA Min OD",{"$f":"L96-0.02","v":0.61999999999999977},{"$f":"M100*0.7","v":2.625},null,{"$f":"IF(SN>11.5,\"\",87)","v":87},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - TRA Design",0.84,7.4400000000000013]
[null,5600,5525,5600,168,5600,12300,12150,168,null,"90 - TRA Min SW",{"$f":"L97-0.02","v":0.61999999999999977},{"$f":"M102","v":2.625},null,{"$f":"IF(SN>11.5,\"\",88)","v":88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - TRA Max",0.86,9.3000000000000007]
[null,5800,5700,5800,169,5800,12800,12550,169,null,"95 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,{"$f":"IF(SN>11.5,\"\",89)","v":89},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - TRA Max Envelope",0.98,9.3000000000000007]
[null,6000,5900,6000,170,6000,13200,13000,170,null,"95 - TRA Design",{"$f":"L99-0.02","v":0.63999999999999979},{"$f":"M106*0.8","v":3},null,{"$f":"IF(SN>11.5,\"\",90)","v":90},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - TRA Min OD",0.79999999999999993,6.51]
[null,null,null,null,null,null,null,null,null,null,"95 - TRA Max",{"$f":"L100-0.02","v":0.65999999999999981},{"$f":"M107","v":3.75},null,{"$f":"IF(SN>11.5,\"\",91)","v":91},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - TRA Min SW",0.79999999999999993,6.51]
[null,null,null,null,null,null,null,null,null,null,"95 - TRA Max Envelope",0.9,3.75,null,{"$f":"IF(SN>11.5,\"\",92)","v":92},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,"95 - TRA Min OD",{"$f":"L102-0.02","v":0.59999999999999976},{"$f":"M107*0.7","v":2.625},null,{"$f":"IF(SN>11.5,\"\",93)","v":93},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - TRA Design",0.82,6.7200000000000006]
[null,null,null,null,null,null,null,null,null,null,"95 - TRA Min SW",{"$f":"L103-0.02","v":0.59999999999999976},{"$f":"M108","v":2.625},null,{"$f":"IF(SN>11.5,\"\",94)","v":94},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - TRA Max",0.84,8.4]
[null,null,null,null,null,null,null,null,null,null,"100 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - TRA Max Envelope",0.98,8.4]
[null,null,null,null,null,null,null,null,null,null,"100 - TRA Design",{"$f":"L105-0.02","v":0.61999999999999977},{"$f":"M112*0.8","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - TRA Min OD",0.77999999999999992,5.88]
[null,null,null,null,null,null,null,null,null,null,"100 - TRA Max",{"$f":"L106-0.02","v":0.63999999999999979},{"$f":"M113","v":3.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 - TRA Min SW",0.77999999999999992,5.88]
[null,null,null,null,null,null,null,null,null,null,"100 - TRA Max Envelope",0.9,3.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,"100 - TRA Min OD",{"$f":"L108-0.02","v":0.57999999999999974},{"$f":"M113*0.7","v":2.625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - TRA Design",0.79999999999999993,6.120000000000001]
[null,null,null,null,null,null,null,null,null,null,"100 - TRA Min SW",{"$f":"L109-0.02","v":0.57999999999999974},{"$f":"M114","v":2.625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - TRA Max",0.82,7.65]
[null,null,null,null,null,null,null,null,null,null,"105 - Custom",{"$f":"$Q$16/$O$16","v":0.83333333333333337},{"$f":"$R$16/$O$16","v":4.333333333333333},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - TRA Max Envelope",0.98,7.65]
[null,null,null,null,null,null,null,null,null,null,"105 - TRA Design",{"$f":"L111-0.02","v":0.59999999999999976},{"$f":"M118*0.8","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - TRA Min OD",0.7599999999999999,5.3549999999999995]
[null,null,null,null,null,null,null,null,null,null,"105 - TRA Max",{"$f":"L112-0.02","v":0.61999999999999977},{"$f":"M119","v":3.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - TRA Min SW",0.7599999999999999,5.3549999999999995]
[null,null,null,null,null,null,null,null,null,null,"105 - TRA Max Envelope",0.9,3.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,"105 - TRA Min OD",{"$f":"L114-0.02","v":0.55999999999999972},{"$f":"M119*0.7","v":2.625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - TRA Design",0.77999999999999992,5.04]
[null,null,null,null,null,null,null,null,null,null,"105 - TRA Min SW",{"$f":"L115-0.02","v":0.55999999999999972},{"$f":"M120","v":2.625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - TRA Max",0.79999999999999993,6.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - TRA Max Envelope",0.95,6.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - TRA Min OD",0.73999999999999988,4.4099999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - TRA Min SW",0.73999999999999988,4.4099999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - TRA Design",0.7599999999999999,4.6399999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - TRA Max",0.77999999999999992,5.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - TRA Max Envelope",0.95,5.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - TRA Min OD",0.71999999999999986,4.0599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65 - TRA Min SW",0.71999999999999986,4.0599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - TRA Design",0.73999999999999988,3.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - TRA Max",0.7599999999999999,4.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - TRA Max Envelope",0.93,4.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - TRA Min OD",0.69999999999999984,3.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - TRA Min SW",0.69999999999999984,3.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - TRA Design",0.71999999999999986,3.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - TRA Max",0.73999999999999988,3.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - TRA Max Envelope",0.9,3.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - TRA Min OD",0.67999999999999983,2.7650000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 - TRA Min SW",0.67999999999999983,2.7650000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - TRA Design",0.69999999999999984,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - TRA Max",0.71999999999999986,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - TRA Min OD",0.65999999999999981,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80 - TRA Min SW",0.65999999999999981,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - TRA Design",0.67999999999999983,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - TRA Max",0.69999999999999984,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - TRA Min OD",0.63999999999999979,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85 - TRA Min SW",0.63999999999999979,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - TRA Design",0.65999999999999981,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - TRA Max",0.67999999999999983,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - TRA Min OD",0.61999999999999977,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - TRA Min SW",0.61999999999999977,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - TRA Design",0.63999999999999979,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - TRA Max",0.65999999999999981,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - TRA Min OD",0.59999999999999976,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 - TRA Min SW",0.59999999999999976,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - TRA Design",0.61999999999999977,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - TRA Max",0.63999999999999979,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - TRA Min OD",0.57999999999999974,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - TRA Min SW",0.57999999999999974,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - Custom",0.83333333333333337,4.333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - TRA Design",0.59999999999999976,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - TRA Max",0.61999999999999977,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - TRA Max Envelope",0.9,3.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - TRA Min OD",0.55999999999999972,2.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - TRA Min SW",0.55999999999999972,2.625]

{"sheet":"STATUS","index":8,"n_rows":123,"n_cols":31,"rows_kept":123,"cut":false,"hidden":true,"merged":[[3,29,3,30],[1,5,1,30],[1,1,1,3],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
["YB DATE:",2026,"EDI DATE:","2025-10-29","Last row used:",{"$f":"MAX(IF(ISBLANK(A:A),0,ROW(A:A)))","v":123}]
["INPUT SIZE","STATUS",null,null,null,"EXCEPTIONS"]
[{"$f":"Do_nom&\"x\"&SN&\"0R\"&Rim_Code&\"LT\"","v":"33x11.50R22LT"},{"$f":"IF(ISNA(VLOOKUP(A3,A6:D2501,2,FALSE)),\"N/A\",VLOOKUP(A3,A6:D2501,2,FALSE))","v":"N/A"},{"$f":"IF(ISNA(VLOOKUP(A3,A6:D2501,3,FALSE)),\"Not Standardized\",VLOOKUP(A3,A6:D2501,3,FALSE))","v":"Not Standardized"},{"$f":"IF(ISNA(VLOOKUP(A3,A6:D2501,4,FALSE)),\"N/A\",IF(LEFT(VLOOKUP(A3,A6:D2501,4,FALSE),9)=\"YEAR BOOK\",B1&\" \"&VLOOKUP(A3,A6:D2501,4,FALSE),IF(VLOOKUP(A3,A6:D2501,4,FALSE)=\"EDI\",VLOOKUP(A3,A6:D2501,4,FALSE)&\" (\"&TEXT(D1,\"mm/dd/yy\")&\")\")))","v":"N/A"},null,{"$f":"IF(ISNA(VLOOKUP($A3,$A6:$AY2501,COLUMN(F2),FALSE)),\"\",VLOOKUP($A3,$A6:$AY2501,COLUMN(F2),FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"'DATA SHEET'!J6","v":"F"},{"$f":"IF(ISERROR(FIND(A4,B3)),\"no\", \"yes\")","v":"no"},"<-LR standard ? / line->",{"$f":"MATCH(A3,A6:A1000,0)+5","v":{"$error":"#N/A"}},"EXCEPTIONS /",170,null,210,null,250,null,280,null,310,null,350,null,380,null,410,null,450,null,480,null,520,null,550,null,650]
["TIRE SIZE","L R","STATUS","LOCATION","COMMENT","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb","kg","lb"]
["27x8.50R14LT","B, C","TRA STANDARD","YEAR BOOK"]
["29x9.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["30x9.50R14LT","B","TRA STANDARD","YEAR BOOK"]
["30x9.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["31x10.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["31x11.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["31x12.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["32x11.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["32x9.50R15LT","B","TRA STANDARD","YEAR BOOK"]
["33x10.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["33x10.50R17LT","D, E","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1365,3005,1405,3100,1450,3195,1450,3195]
["33x10.50R18LT","D, E","TRA STANDARD","YEAR BOOK"]
["33x11.50R17LT","D","TRA STANDARD","YEAR BOOK"]
["33x11.50R18LT","E","TRA STANDARD","YEAR BOOK"]
["33x11.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["33x12.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["33x12.50R17LT","C, D, E, F","TRA STANDARD","YEAR BOOK"]
["33x12.50R18LT","E, F","TRA STANDARD","YEAR BOOK"]
["33x12.50R20LT","E, F","TRA STANDARD","YEAR BOOK"]
["33x12.50R22LT","E, F","TRA STANDARD","YEAR BOOK","LRF different loads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1080,2385,1130,2490,1180,2600]
["33x12.50R24LT","E, F","TRA STANDARD","YEAR BOOK"]
["33x13.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["33x13.50R20LT","F","TRA STANDARD","YEAR BOOK"]
["33x15.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["33x9.50R15LT","B, C","TRA STANDARD","YEAR BOOK","LRC different loads",null,null,null,null,null,null,985,2170,1065,2345,1150,2535]
["34x10.50R17LT","D, E","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1415,3120,1435,3160,1450,3195,1450,3195]
["34x11.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["34x12.50R17LT","E","DESIGN GUIDE","EDI","Old 121 LI cap",null,null,null,null,null,null,null,null,null,null,null,null,1340,2955,1395,3075,1450,3195,1415,3120,1435,3160,1450,3195]
["34x12.50R18LT","E","TRA STANDARD","YEAR BOOK"]
["35x10.50R17LT","C, D, E","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,null,null,null,null,null,null,null,null,null,null,1340,2955,1395,3075,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195]
["35x11.50R16LT","D","TRA STANDARD","YEAR BOOK"]
["35x11.50R17LT","C, E","TRA STANDARD","YEAR BOOK"]
["35x11.50R18LT","C, E","TRA STANDARD","YEAR BOOK","LRC added in 2023 YB"]
["35x11.50R20LT","D, E","TRA STANDARD","YEAR BOOK"]
["35x12.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["35x12.50R17LT","C, D, E, F","TRA STANDARD","YEAR BOOK"]
["35x12.50R18LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["35x12.50R20LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["35x12.50R22LT","E, F","TRA STANDARD","YEAR BOOK"]
["35x12.50R24LT","E, F","TRA STANDARD","YEAR BOOK"]
["35x13.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["35x13.50R18LT","D","TRA STANDARD","YEAR BOOK"]
["35x13.50R20LT","E, F","TRA STANDARD","YEAR BOOK"]
["35x13.50R24LT","E, F","TRA STANDARD","YEAR BOOK","LRE different loads",null,null,null,null,null,null,null,null,null,null,null,null,995,2190,1050,2315,1120,2470]
["35x14.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["35x15.50R20LT","F","TRA STANDARD","YEAR BOOK"]
["35x15.50R22LT","F","TRA STANDARD","YEAR BOOK"]
["35x15.50R24LT","F","TRA STANDARD","YEAR BOOK"]
["35x9.50R15LT","B","TRA STANDARD","YEAR BOOK"]
["36x13.50R18LT","D","TRA STANDARD","YEAR BOOK"]
["36x14.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["36x14.50R17LT","D","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,null,null,null,null,1315,2900,1385,3050,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195]
["36x14.50R18LT","D","TRA STANDARD","YEAR BOOK"]
["36x15.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["36x15.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["37x11.50R17LT","C, D","TRA STANDARD","YEAR BOOK"]
["37x11.50R18LT","D, E","TRA STANDARD","YEAR BOOK"]
["37x11.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["37x12.50R15LT","B, C","TRA STANDARD","YEAR BOOK"]
["37x12.50R17LT","C, D, E, F","TRA STANDARD","YEAR BOOK"]
["37x12.50R18LT","C, D, E, F","TRA STANDARD","YEAR BOOK"]
["37x12.50R20LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["37x12.50R22LT","E, F","TRA STANDARD","YEAR BOOK"]
["37x13.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["37x13.50R17LT","D, E, F","TRA STANDARD","YEAR BOOK","LRF added to the 2024 YB"]
["37x13.50R18LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["37x13.50R20LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["37x13.50R22LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["37x13.50R24LT","E, F","TRA STANDARD","YEAR BOOK"]
["37x13.50R26LT","E","TRA STANDARD","YEAR BOOK"]
["37x14.50R15LT","B, C","TRA STANDARD","YEAR BOOK (B - EDI)"]
["37x14.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["37x14.50R24LT","F","TRA STANDARD","YEAR BOOK","LRF different loads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1495,3295,1560,3440,1650,3640]
["38x12.50R17LT","C, D","TRA STANDARD","YEAR BOOK","LRD added in 2025 YB"]
["38x13.50R17LT","C, D, E","TRA STANDARD","YEAR BOOK"]
["38x13.50R20LT","E","TRA STANDARD","YEAR BOOK"]
["38x13.50R22LT","E, F","TRA STANDARD","YEAR BOOK"]
["38x13.50R24LT","E, F","TRA STANDARD","YEAR BOOK"]
["38x14.50R17LT","D","TRA STANDARD","YEAR BOOK"]
["38x14.50R18LT","D","TRA STANDARD","YEAR BOOK"]
["38x14.50R20LT","D","TRA STANDARD","YEAR BOOK"]
["38x15.50R15LT","C","TRA STANDARD","YEAR BOOK"]
["38x15.50R17LT","C","TRA STANDARD","YEAR BOOK"]
["38x15.50R18LT","D","TRA STANDARD","YEAR BOOK"]
["38x15.50R20LT","D, E","TRA STANDARD","YEAR BOOK"]
["38x15.50R22LT","E","TRA STANDARD","YEAR BOOK"]
["38x15.50R24LT","F","TRA STANDARD","YEAR BOOK"]
["39x13.50R17LT","C, D","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,null,null,null,null,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195]
["40x13.50R17LT","B, C, D","TRA STANDARD","YEAR BOOK"]
["40x13.50R20LT","D, E, F","TRA STANDARD","YEAR BOOK","LRF added to the 2024 YB"]
["40x14.50R17LT","C","TRA STANDARD","YEAR BOOK","Old 121 LI cap",null,null,1350,2975,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195,1450,3195]
["40x14.50R18LT","C","TRA STANDARD","YEAR BOOK"]
["40x14.50R20LT","C, D","TRA STANDARD","YEAR BOOK"]
["40x15.50R20LT","D, F","TRA STANDARD","YEAR BOOK"]
["40x15.50R22LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["40x15.50R24LT","E, F","TRA STANDARD","YEAR BOOK"]
["40x15.50R26LT","E","TRA STANDARD","YEAR BOOK"]
["42x13.50R17LT","B, C, D, E, F","TRA STANDARD","YEAR BOOK","LRC added in 2023 YB; LRB added in 2025 YB"]
["42x13.50R20LT","C, D","TRA STANDARD","YEAR BOOK","LRD added to the 2024 YB"]
["42x14.50R17LT","C, D","TRA STANDARD","YEAR BOOK","Old 121 LI cap removed and LRD added in 2024 YB"]
["42x14.50R20LT","C","TRA STANDARD","YEAR BOOK"]
["42x15.50R20LT","D, E, F","TRA STANDARD","YEAR BOOK"]
["42x15.50R22LT","C","TRA STANDARD","YEAR BOOK"]
["42x15.50R24LT","C","TRA STANDARD","YEAR BOOK"]
["42x15.50R26LT","D","TRA STANDARD","YEAR BOOK"]
["42x15.50R28LT","E","TRA STANDARD","YEAR BOOK","LRE different loads",null,null,null,null,null,null,null,null,null,null,null,null,1615,3555,1705,3760,1800,3970]
["44x15.50R28LT","D","TRA STANDARD","YEAR BOOK"]
["33x11.50R16LT","E","TRA STANDARD","YEAR BOOK","LRE added in 2023 YB"]
["40x12.50R17LT","C","TRA STANDARD","YEAR BOOK","LRC added in 2023 YB"]
["40x13.50R18LT","C, F","TRA STANDARD","YEAR BOOK","LRC added in 2023 YB; LRF added to the 2024 YB"]
["38x11.50R17LT","D, E","TRA STANDARD","YEAR BOOK","LRD added in 2023 YB; LRE added in 2025 YB"]
["38x11.50R18LT","D, E","TRA STANDARD","YEAR BOOK","LRD added in 2023 YB; LRE added in 2025 YB"]
["38x11.50R20LT","D","TRA STANDARD","YEAR BOOK","LRD added in 2023 YB"]
["38x13.50R18LT","E","TRA STANDARD","YEAR BOOK","LRE added in 2023 YB"]
["44x13.50R20LT","C","TRA STANDARD","YEAR BOOK","LRC added in 2024 YB"]
["37x12.50R24LT","E, F","TRA STANDARD","YEAR BOOK","LRE and LRF added in 2025 YB"]
["39x13.50R18LT","C","TRA STANDARD","YEAR BOOK","LRC added in 2025 YB"]
["35x9.50R17LT","E","TRA STANDARD","YEAR BOOK","LRE added in 2025 YB"]

{"sheet":"Export General Data","index":9,"n_rows":1,"n_cols":24,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["SOURCE","ENTRY DATE","TYPE","TSD","CC","UM","SN","AR","DR","MRWIN","DSW","DODTD1","DODTD2","DODTD3","MOW","MOW1","MODTD1","MODTD2","MODTD3","MSF","MDS","MFW","TV","APPRIMS"]

{"sheet":"Export Loads Data","index":10,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["SOURCE","ENTRY DATE","TYPE","TSD","CC","SPDRTG","UM","SD","IP","SN","AR","DR","LD","LI","LID"]
[1,2025,"LT","34x11.50R20LT","R","*","CU","S",95,11.5,null,20,3525,124,"F"]
[1,2025,"LT","34x11.50R20LT","R","*","SI","S",650,11.5,null,20,1600,124,"F"]