{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculator for Web"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Calculator for Web","index":0,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,0,30,1],[28,0,28,1],[31,0,31,1],[27,0,27,1],[26,0,26,2],[29,0,29,1],[9,0,9,1],[17,0,17,1],[20,0,20,1],[21,0,21,1],[19,0,19,1]]}
[]
[null,null,null,null,null,null,"Under/Overweight Disp Adjustment",null,null,null,null,"CLASSING BREAKDOWN","E1","E2","E3","E4"]
["What is the displacement of your car (Liters)?",null,0,null,null,null,"Liter","Per 100 lbs","Divisor",null,null,"Displacement Max Limit (liters)",6.2,4.5,2.9,1.9]
["Target Car Weight (full fuel tank, no driver)",null,0,null,null,null,0.2,100,{"$f":"+H4/G4","v":500},null,null,"Displ/Weight Ratio","1 lb./cc","1 lb./cc","1 lb./cc","1 lb./cc"]
[null,null,null,null,null,null,null,null,null,null,null,"Fuel Capacity (Gallons)",20,17,15,14]
["Drivetrain Modifications (A)","Multiplier",null,null,null,null,null,null,null,null,null,"Tire Width Limit (MM)",295,255,245,225]
[null,2,null,false,{"$f":"IF(D7=TRUE,B7*$C$3-$C$3,0)","v":0}]
[null,1.25,null,false,{"$f":"IF(D8=TRUE,B8*$C$3-$C$3,0)","v":0}]
[null,1.1499999999999999,null,false,{"$f":"IF(D9=TRUE,B9*$C$3-$C$3,0)","v":0}]
[" DISPLACEMENT After Drivetrain Modifications\n(Base Displacement + A)",null,{"$f":"(C3+SUM(E7:E9))","v":0},{"$f":"MIN(3300,MAX(2000,(C10*1000)))","v":2000},null,null,null,null,"1. A car with OE gas tank may run over fuel capacity"]
[null,null,null,null,null,null,null,null,"2. Such cars in E2-E3-E4 would bump up 1 class"]
["Suspension (B)","Addition",null,null,null,null,null,null,"3. Cars in E1 will receive a displ adjustment of .1L/gal over capacity"]
[null,0.5,null,false,{"$f":"IF(D13=TRUE,B13,0)","v":0},null,null,null,"4. No cap on capacity"]
[null,1,null,false,{"$f":"IF(D14=TRUE,B14,0)","v":0},null,null,null,"5. Any fuel capacity adjustments are the final adjustment"]
["Aero (C)","Addition"]
[null,0.25,null,false,{"$f":"IF(D16=TRUE,B16,0)","v":0},"Class","Displ Max Limit (Liters)","Displ/Weight Ratio","Fuel Capacity (Gal)","Tire Width Limit (MM)"]
[null,0.25,null,false,{"$f":"IF(D17=TRUE,B17,0)","v":0},"E1",6.2,"1 lb./cc",20,295]
["DISPLACEMENT After All Modifcations & Additions\n(Base + A + B + C)",null,{"$f":"SUM(C10,E13:E14,E16,E17)","v":0},{"$f":"IF($C$18<=P3,P2,IF(AND($C$18<=O3,$C$18>P3),O2,IF(AND($C$18<=N3,$C$18>O3),N2,IF(AND($C$18<=M3,$C$18>N3),M2))))","v":"E4"},null,"E2",4.5,"1 lb./cc",17,255]
[null,null,null,null,null,"E3",2.9,"1 lb./cc",15,245]
["Displacement Adjustment for Weight Difference\n(Min. -0.5L/Max. 0.5L)",null,{"$f":"MIN(0.5,MAX(-0.5,((D10-C4)/$I$4)))","v":0.5},{"$f":"IF((C18+C20)<=6.2,(C18+C20), \"Ineligible -Max Displacement Exceeded\")","v":0.5},{"$f":"IF($D$20<=P3,P2,IF(AND($D$20<=O3,$D$20>P3),O2,IF(AND($D$20<=N3,$D$20>O3),N2,IF(AND($D$20<=M3,$D$20>N3),M2))))","v":"E4"},"E4",1.9,"1 lb./cc",14,225]
["Displacement Used for Classing ",null,{"$f":"IF((C18+C20)<=6.2,(C18+C20),\"Ineligible-Max Displacement Exceeded\")","v":0.5}]
["YOUR RECOMMENDED CLASS\n(With Weight Adj):\nYou may class up to a higher displacement class.",null,{"$f":"IF(D22=C32,D22,\"See box below\")","v":"E4"},{"$f":"IF(C21<=P3,P2,IF(AND(C21<=O3,C21>P3),O2,IF(AND(C21<=N3,C21>O3),N2,IF(AND(C21<=M3,C21>N3),M2,\"Ineligible\"))))","v":"E4"}]
[null,"Minimum race weight with all adjustments:",{"$f":"D10-(C20*I4)","v":1750},null,null,{"$f":"MIN(3300,MAX(2000,(D10-(C20*I4))))","v":2000}]
[null,"Your Max Tire Width (MM) is:",{"$f":"IF($D$20<=P3,P6,IF(AND($D$20<=O3,$D$20>P3),O6,IF(AND($D$20<=N3,$D$20>O3),N6,IF(AND($D$20<=M3,$D$20>N3),M6))))","v":225}]
[null,"Your Fuel Capacity (Gal) is:",{"$f":"IF($D$20<=P3,P5,IF(AND($D$20<=O3,$D$20>P3),O5,IF(AND($D$20<=N3,$D$20>O3),N5,IF(AND($D$20<=M3,$D$20>N3),M5))))","v":14}]
[]
["WAIT! Let's check your fuel tank capacity."]
["Is your OE/Stock fuel tank larger than the allowed capacity for your class?",null,null,2]
["If Yes, what is your capacity? If no, you may quit this form.",null,0,{"$f":"IF(D28<>2,ROUNDUP(C29,0))","v":false},null,null,null,null,null,0]
["Displacement Adjustment for Fuel Capacity\n(E1 class only - 0.1L/gal)",null,{"$f":"IF(AND(D28<>2,D22=\"E1\",D29-M5>0),((D29-M5)*0.1),0)","v":0}]
["Revised displacement Used for Classing\n(With oversize OE fuel tank adjustment) ",null,{"$f":"IF((C21+C30)<=6.2,C21+C30, C21+C30)","v":0.5},{"$f":"IF(C31<=P3,P2,IF(AND(C31<=O3,C31>P3),O2,IF(AND(C31<=N3,C31>O3),N2,IF(AND(C31<=M3,C31>N3),M2,\"Ineligible - Max Displacement Exceeded\"))))","v":"E4"},{"$f":"IF(D29-(VLOOKUP(D31,F16:J20,4,0))<=0,D31)","v":"E4"},"If this pushes up a class or out of E1, change cell C26 to say \"see box below\""]
["Recommended class (w/Fuel Capacity and Weight Adj)\nCars in classes E2, E3, E4 with oversized fuel tanks will be moved up a class. ",null,{"$f":"IF(AND(D28=1,D31=P2,D29>P5),O2,IF(AND(D28=1,D31=O2,D29>O5),N2,IF(AND(D28=1,D31=N2,D29>N5),M2,IF(AND(D28=1,D31=M2,D29>M5),M2,D31))))","v":"E4"}]