{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Displacement","Fuel Consumption and Emission","Run"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Displacement","index":0,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,8,1,8],[0,9,1,9],[0,14,1,14],[0,15,1,15]]}
["Variable","Value","Units",null,null,null,null,null,"Distance (m)","Profile sample (mm)","Suspension Displacement","Suspension velocity","Axle Displacement","Axle velocity","Rectified slope (RS)\n(m/km)","IRI (m/km)"]
["M",0.15,"Unitless",null,null,null,null,null,null,null,"Zs (m/km)","Zs_dot \n(m/(sec km)","Zu (m/km)","Zu_dot \n(m/(sec km)"]
["K1",653,"1/sec_square"]
["K2",63.3,"1/sec_square"]
["C",6,"1/sec"]
["V",80,"km/h"]
["step size",2.5000000000000001E-2,"m (distance between two pts)"]
[]
[null,0,1,0,0]
["A=",{"$f":"-B4","v":-63.3},{"$f":"-B5","v":-6},{"$f":"B4","v":63.3},{"$f":"B5","v":6}]
[null,0,0,0,1]
[null,{"$f":"B4/B2","v":422},{"$f":"B5/B2","v":40},{"$f":"-(B3+B4)/B2","v":-4775.333333333333},{"$f":"-B5/B2","v":-40}]
[]
[]
["B=",0]
[null,0]
[null,0]
[null,{"$f":"B3/B2","v":4353.3333333333339}]
[]
["Spreadsheet manual"]
["1-",null,"these cells are your input. You have to input values on those cells"]
["2-","After yoou filled up the required cells, you have to click "]
[null,"on the \"Calculate Displacements\" to get the results in columns K through N"]
["3-",null,"these cells will be filled for you"]
["4-",null,"You have to input the formulas to calculate the correspondent"]
[null,null,"variable in these cells"]

{"sheet":"Fuel Consumption and Emission","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,0,32,0],[23,0,23,1],[0,0,0,1],[5,0,5,2],[21,0,21,2],[11,0,11,1],[12,0,12,1],[13,0,13,1],[18,0,18,1],[19,0,19,1],[22,0,22,1],[24,0,24,1],[25,0,26,0],[27,0,28,0],[6,0,6,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1]]}
["Inputs",null,null,null,null,null,"Speed (km/h)","FC (mL/km)","HC (g/km)","CO (g/km)","Nox (g/km)","SO2 (g/km)","Pb (g/km)"]
["Tdsp (mm)",5,null,null,null,null,70,{"$f":"($C$15*($C$16+$C$17*$B$2+$C$18*$B$3+$C$19*$C$20))*($C$12*$C$9+$C$7*($C$13*$C$8+$C$14*($G2*10^3/3600)^2))/$C$10","v":13.023931020968059},{"$f":"$C$26*H2*$C$24+$C$27*1000/(G2*1000/3600)","v":0.11721537918871253},{"$f":"$C$30*H2*$C$24","v":0.97679482657260452},{"$f":"MAX($C$28*(H2*$C$24-$C$29*1000/(G2*1000/3600)),0)","v":5.6380011757789533E-2},{"$f":"2*$C$31*H2*$C$24","v":9.7679482657260439E-3},{"$f":"$C$32*$C$33*H2*$C$24","v":3.9340411640211639E-3}]
["IRI (m/km)",2]
[]
[]
["FC Model Parameters"]
["CR1",null,1]
["M ","(kg)",1900]
["Nw",null,4]
["xi","(MJ/L)",10.5]
["WD","(m)",0.6]
["b11",null,{"$f":"37*C11","v":22.2}]
["b12",null,{"$f":"0.064/C11","v":0.10666666666666667}]
["b13",null,{"$f":"0.012*C9/C11^2","v":0.13333333333333333}]
["Kcr2",null,0.5]
["A0",null,0.5]
["A1",null,0.02]
["A2",null,0.1]
["A3",null,0]
["DEF (mm)",null,0]
[]
["Emission Model Parameters"]
["Vehicle",null,"Passenger car"]
["MassFuel (g/mL)",null,0.75]
["Fuel Type",null,"P"]
["HC","aHC",1.2E-2]
[null,"rHC",0]
["NOx","aNOx",5.5E-2]
[null,"FRNOx",0.17]
["CO","aCO",0.1]
["SO2","aSO2",5.0000000000000001E-4]
["Pb","Prop_Pb",0.75]
[null,"aPb",5.3700000000000004E-4]

{"sheet":"Run","index":2,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[{"$f":"_xlfn.MUNIT(4)","v":1},0,0,0,null,0,1,0,0,null,{"$f":"PowerMatrix(Run!F1:I4,15)","v":-1.6616180128653501E+25},-1.7618066844228057E+24,1.9612462695940722E+26,3.3646779916633643E+24]
[0,1,0,0,null,-63.3,-6,63.3,6,null,1.531416475605904E+27,1.2854177964441793E+26,-1.6178981332647088E+28,5.0966667186335796E+25]
[0,0,1,0,null,0,0,0,1,null,2.6334506272188884E+26,2.2431186611089097E+25,-2.800492634175391E+27,5.2754959546721151E+24]
[0,0,0,1,null,422,40,-4775.333333333333,-40,null,8.0636518038969155E+26,3.3977778124223855E+26,-2.3772357569728936E+28,-2.8769253526957406E+27]
[]
[null,null,null,null,null,0.99996062695001042,1.1212531287280523E-3,3.3237688232519986E-5,3.745142109842202E-6]
[null,null,null,null,null,-6.9394873078132316E-2,0.99338291386203592,5.3091021093285923E-2,6.6109507762071472E-3]
[null,null,null,null,null,2.623656707120449E-4,2.4967614065614685E-5,0.99702494631389793,1.0990111297098986E-3]
[null,null,null,null,null,0.46220224676722382,4.4073005174714304E-2,-5.2465640314376492,0.95321430680989561,null,null,null,null,null,null,null,6.1353617569065433E-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.630385198484639E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.712688015390069E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7843617846704261]