{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Advance_curve","Example N°1","Example N°2","Feuil1"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":3,"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":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
["31/12/2021",null,"Version v11r0c0"]
[null,null,"1 ò"]
[null,null,"pickup Position"]
[null,null,50]
[null,"2 ò"]
[null,"RPM","Advance degrees BTDC",null,null,null,null,null,null,null,null,null,0,0]
[null,500,5,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":5}]
[null,1200,8,null,null,null,null,null,null,null,null,null,1200,8]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,4250,26,null,null,null,null,null,null,null,null,null,4250,26]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6000,45,null,null,null,null,null,null,null,null,null,6000,45]
[null,8000,40,null,null,null,null,null,null,null,null,null,8000,40]
[null,9200,30,null,null,null,null,null,null,null,null,null,9200,30]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"Enter pickup Position:",null,{"$f":"C4","v":50},null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,10000,5,null,null,null,null,null,null,null,null,null,10000,5]
[null,"13 couples max"]
[]
[null,null,null,null,"Enter <rpm advance>",null,{"$f":"IF(B7>0,B7,\"\")","v":500},5]
[null,null,null,null,null,null,1200,8]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(B9>0,B9,\"\")","v":""},{"$f":"IF(C9>0,C9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B11>0,B11,\"\")","v":""},{"$f":"IF(C11>0,C11,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B12>0,B12,\"\")","v":""},{"$f":"IF(C12>0,C12,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B10>0,B10,\"\")","v":4250},26]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,6000,45]
[null,null,null,null,null,null,{"$f":"IF(B14>0,B14,\"\")","v":8000},{"$f":"IF(C14>0,C14,\"\")","v":40}]
[null,null,null,null,null,null,9200,30]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,10000,5]
[null,null,null,null,null,null,{"$f":"IF(B17>0,B17,\"\")","v":""},{"$f":"IF(C17>0,C17,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B21>0,B21,\"\")","v":""},{"$f":"IF(C24>0,C24,\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(B18>0,B18,\"\")","v":""},{"$f":"IF(C18>0,C18,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B24>0,B24,\"\")","v":""},{"$f":"IF(C27>0,C27,\"\")","v":""}]

{"sheet":"Example N°1","index":1,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[null,null,"1 ò"]
[null,null,"pickup position",null,null,"Example with the maximal of 13 RPM values."]
[null,null,30,null,null,"Maximum RPM is 10000 (no more spark above)"]
[null,null,null,null,null,"Advance values are INTEGER only"]
[null,"2 ò",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,500,0]
[null,500,8.5,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,1500,10]
[null,2500,22,null,null,null,null,null,null,null,null,null,2500,22]
[null,3400,23,null,null,null,null,null,null,null,null,null,3400,23]
[null,4400,18,null,null,null,null,null,null,null,null,null,4400,18]
[null,5000,19,null,null,null,null,null,null,null,null,null,5000,19]
[null,5400,23,null,null,null,null,null,null,null,null,null,5400,23]
[null,5900,22,null,null,null,null,null,null,null,null,null,5900,22]
[null,6100,30,null,null,null,null,null,null,null,null,null,6100,30]
[null,7200,34,null,null,null,null,null,null,null,null,null,7200,34]
[null,8500,28,null,null,null,null,null,null,null,null,null,8500,28]
[null,9300,26,null,null,null,null,null,null,null,null,null,9300,26]
[null,10000,18,null,null,null,null,null,null,null,null,null,10000,18]
[]
[null,null,null,null,"Enter pickup position:",null,{"$f":"C3","v":30}]
[]
[null,null,null,null,"Enter <rpm advance>",null,{"$f":"IF(B7>0,B7,\"\")","v":500},{"$f":"IF(C7>0,C7,\"\")","v":8.5}]
[null,null,null,null,null,null,{"$f":"IF(B8>0,B8,\"\")","v":1500},{"$f":"IF(C8>0,C8,\"\")","v":10}]
[null,null,null,null,null,null,2500,22]
[null,null,null,null,null,null,3400,23]
[null,null,null,null,null,null,4400,18]
[null,null,null,null,null,null,5000,19]
[null,null,null,null,null,null,5400,23]
[null,null,null,null,null,null,5900,22]
[null,null,null,null,null,null,6100,30]
[null,null,null,null,null,null,7200,34]
[null,null,null,null,null,null,8500,28]
[null,null,null,null,null,null,9300,26]
[null,null,null,null,null,null,10000,18]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[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":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,"1 ò"]
[null,null,"pickup position",null,null,"Example with the minimum of 3 RPM values."]
[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,"2 ò",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,500,0]
[null,500,8.5,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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3000,22,null,null,null,null,null,null,null,null,null,3000,22]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6000,22,null,null,null,null,null,null,null,null,null,6000,22]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,{"$f":"C3","v":25}]
[]
[null,null,null,null,"Enter <rpm advance>",null,{"$f":"IF(B7>0,B7,\"\")","v":500},{"$f":"IF(C7>0,C7,\"\")","v":8.5}]
[null,null,null,null,null,null,{"$f":"IF(B11>0,B11,\"\")","v":3000},{"$f":"IF(C11>0,C11,\"\")","v":22}]
[null,null,null,null,null,null,{"$f":"IF(B16>0,B16,\"\")","v":6000},{"$f":"IF(C16>0,C16,\"\")","v":22}]
[null,null,null,null,null,null,{"$f":"IF(B10>0,B10,\"\")","v":""},{"$f":"IF(C10>0,C10,\"\")","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF(B12>0,B12,\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(B13>0,B13,\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(B14>0,B14,\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(B15>0,B15,\"\")","v":""},""]
[]
[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,"",{"$f":"IF(C23>0,C23,\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(C24>0,C24,\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(C25>0,C25,\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(C26>0,C26,\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(C27>0,C27,\"\")","v":""}]

{"sheet":"Feuil1","index":3,"n_rows":9,"n_cols":1,"rows_kept":9,"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())"]
[]
[]
["RPM=(60*FRQ*STROKE)/(2*CYL)"]
["PERIODE=(60*STROKE)/(2*CYL*RPM)"]
["FRQ=(2*CYL*RPM)/(60*STROKES)"]