{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Advance_curve","Example N°1","Example N°2","Formules","Feuil1"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":4,"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":"Advance_curve","index":0,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["07/06/2021",null,"TCI Version v10r1c0"]
[]
[null,null,"pickup Position",null,"Dwell duration"]
[null,null,50,null,3,"ms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"RPM","Advance degrees BTDC",null,null,null,null,null,null,null,null,null,null,500,0]
[null,500,8.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C7)=1,NA(),B7)","v":500},{"$f":"IF(COUNTBLANK(C7)=1,NA(),ROUND(C7,0))","v":9}]
[null,1200,10,null,null,null,null,null,null,null,null,null,null,1200,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C9)=1,NA(),B9)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTBLANK(C9)=1,NA(),ROUND(C9,0))","v":{"$error":"#N/A"}}]
[null,4250,30,null,null,null,null,null,null,null,null,null,null,4250,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6000,45,null,null,null,null,null,null,null,null,null,null,6000,45]
[null,8000,45,null,null,null,null,null,null,null,null,null,null,8000,45]
[null,9200,30,null,null,null,null,null,null,null,null,null,null,9200,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C23)=1,NA(),B23)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTBLANK(C23)=1,NA(),ROUND(C23,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"Clear data",null,"C",null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"Enter pickup Position:",null,"P",{"$f":"C4","v":50},null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"Enter pickup Type:",null,"T","0,1,2","(0: Auto, 1:PN, 2:NP)",null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,10000,5,null,"Enter Dwell:",null,"L",{"$f":"E4","v":3},null,null,null,null,null,{"$f":"IF(COUNTBLANK(C27)=1,NA(),B27)","v":10000},{"$f":"IF(COUNTBLANK(C27)=1,NA(),ROUND(C27,0))","v":5}]
[]
[]
[null,null,null,null,"Enter <rpm advance>",null,"S",{"$f":"IF(B7>0,B7,\"\")","v":500},{"$f":"IF(C7>0,C7,\"\")","v":8.5}]
[null,null,null,null,null,null,"S",1200,10]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S",4250,30]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S",6000,45]
[null,null,null,null,null,null,"S",8000,45]
[null,null,null,null,null,null,"S",9200,30]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S","",""]
[null,null,null,null,null,null,"S",10000,5]
[]
[null,null,null,null,"Save data",null,"W"]
[null,null,null,null,"Quit",null,"Q"]

{"sheet":"Example N°1","index":1,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"pickup position",null,null,"Example with 13 values of RPM"]
[null,null,30,null,null,"Maximum RPM is 10000 (no more spark above)"]
[null,null,null,null,null,"Advance values are INTEGER only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"RPM","Advance degrees BTDC",null,null,null,null,null,null,null,null,null,null,500,0]
[null,500,8.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C7)=1,NA(),B7)","v":500},{"$f":"IF(COUNTBLANK(C7)=1,NA(),C7)","v":8.5}]
[null,1500,10,null,null,null,null,null,null,null,null,null,null,1500,10]
[null,2500,22,null,null,null,null,null,null,null,null,null,null,2500,22]
[null,3400,23,null,null,null,null,null,null,null,null,null,null,3400,23]
[null,4400,18,null,null,null,null,null,null,null,null,null,null,4400,18]
[null,5000,19,null,null,null,null,null,null,null,null,null,null,5000,19]
[null,5400,23,null,null,null,null,null,null,null,null,null,null,5400,23]
[null,5900,22,null,null,null,null,null,null,null,null,null,null,5900,22]
[null,6100,30,null,null,null,null,null,null,null,null,null,null,6100,30]
[null,7200,34,null,null,null,null,null,null,null,null,null,null,7200,34]
[null,8500,28,null,null,null,null,null,null,null,null,null,null,8500,28]
[null,9300,29,null,null,null,null,null,null,null,null,null,null,9300,29]
[null,10000,25,null,null,null,null,null,null,null,null,null,null,10000,25]
[]
[null,null,null,null,"Enter pickup position:",null,"P",{"$f":"C3","v":30}]
[]
[null,null,null,null,"Enter <rpm advance>",null,"S",{"$f":"IF(B7>0,B7,\"\")","v":500},{"$f":"IF(C7>0,C7,\"\")","v":8.5}]
[null,null,null,null,null,null,"S",{"$f":"IF(B8>0,B8,\"\")","v":1500},{"$f":"IF(C8>0,C8,\"\")","v":10}]
[null,null,null,null,null,null,"S",2500,22]
[null,null,null,null,null,null,"S",3400,23]
[null,null,null,null,null,null,"S",4400,18]
[null,null,null,null,null,null,"S",5000,19]
[null,null,null,null,null,null,"S",5400,23]
[null,null,null,null,null,null,"S",5900,22]
[null,null,null,null,null,null,"S",6100,30]
[null,null,null,null,null,null,"S",7200,34]
[null,null,null,null,null,null,"S",8500,28]
[null,null,null,null,null,null,"S",9300,29]
[null,null,null,null,null,null,"S",10000,25]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]

{"sheet":"Example N°2","index":2,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"pickup position",null,null,"Example with 3 values of RPM"]
[null,null,25,null,null,"Maximum RPM is 6000 (no more spark above)"]
[null,null,null,null,null,"Advance values are INTEGER only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"RPM","Advance degrees BTDC",null,null,null,null,null,null,null,null,null,null,500,0]
[null,500,8.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C7)=1,NA(),B7)","v":500},{"$f":"IF(COUNTBLANK(C7)=1,NA(),C7)","v":8.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3000,22,null,null,null,null,null,null,null,null,null,null,3000,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6000,22,null,null,null,null,null,null,null,null,null,null,6000,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,null,"Enter pickup position:",null,"P",{"$f":"C3","v":25}]
[]
[null,null,null,null,"Enter <rpm advance>",null,"S",{"$f":"IF(B7>0,B7,\"\")","v":500},{"$f":"IF(C7>0,C7,\"\")","v":8.5}]
[null,null,null,null,null,null,"S",{"$f":"IF(B11>0,B11,\"\")","v":3000},{"$f":"IF(C11>0,C11,\"\")","v":22}]
[null,null,null,null,null,null,"S",{"$f":"IF(B16>0,B16,\"\")","v":6000},{"$f":"IF(C16>0,C16,\"\")","v":22}]
[null,null,null,null,null,null,null,{"$f":"IF(B10>0,B10,\"\")","v":""},{"$f":"IF(C10>0,C10,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(B12>0,B12,\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(B13>0,B13,\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(B14>0,B14,\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(B15>0,B15,\"\")","v":""},""]
[]
[null,null,null,null,null,null,null,{"$f":"IF(B17>0,B17,\"\")","v":""},""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",{"$f":"IF(C23>0,C23,\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(C24>0,C24,\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(C25>0,C25,\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(C26>0,C26,\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(C27>0,C27,\"\")","v":""}]

{"sheet":"Formules","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,10,0,11]]}
[null,null,null,"TEMPS","CYLINDRE",null,"RPM","FREQUENCE","PERIODE","PERIODE","1°"]
[null,null,null,"Nbr","Nbr",null,"tr/mn","Hz","ms","pour 2cyl 2tps","ms","us"]
[null,null,null,2,1,null,2000,{"$f":"(2*$E$3*$G$3)/(60*$D$3)","v":33.333333333333336},{"$f":"1000*(60*$D$3)/(2*$E$3*$G$3)","v":30},{"$f":"1000*60/$G$3","v":30},{"$f":"I3/360","v":8.3333333333333329E-2},{"$f":"I3/0.36","v":83.333333333333343}]
[]
[null,null,null,null,null,null,"Délai","=>","Délai","Avance"]
[null,null,null,null,null,null,"us",null,"°","°"]
[null,null,null,null,null,null,70,null,{"$f":"G7/L3","v":0.83999999999999986},-12.36]
[]
[]
[]
[null,null,null,null,null,null,"RPM=(60*FRQ*STROKE)/(2*CYL)"]
[null,null,null,null,null,null,"PERIODE=(60*STROKE)/(2*CYL*RPM)"]
[null,null,null,null,null,null,"FRQ=(2*CYL*RPM)/(60*STROKES)"]

{"sheet":"Feuil1","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Il faut taper =NA() dans la barre de formule et valider #N/A va alors apparaitre dans la cellule."]
["Quand vous tapez directement #N/A vous entrez un texte et non pas une valeur d'erreur."]
[]
["=SI(NBVAL(C3:O3)>0; NBVAL(C3:O3); NA())"]