{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COURSE","CYCLISME","NATATION","INFOS"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"COURSE","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Entrainement","Distance (km)","Temps (min)","Dénivelé (m)","vitesse moyenne (km/h)","Calories(kcal)"]
[null,1,null,null,null,{"$f":"IF(D4<>\"\",(C4/D4)*60,\"\")","v":""},{"$f":"IF(C4<>\"\",D4*poid*IF(F4<24,0.1227,VLOOKUP(F4,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E4/1000))/4.18),\"\")","v":""}]
[null,2,null,null,null,{"$f":"IF(D5<>\"\",(C5/D5)*60,\"\")","v":""},{"$f":"IF(C5<>\"\",D5*poid*IF(F5<24,0.1227,VLOOKUP(F5,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E5/1000))/4.18),\"\")","v":""}]
[null,3,null,null,null,"",{"$f":"IF(C6<>\"\",D6*poid*IF(F6<24,0.1227,VLOOKUP(F6,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E6/1000))/4.18),\"\")","v":""}]
[null,4,null,null,null,"",{"$f":"IF(C7<>\"\",D7*poid*IF(F7<24,0.1227,VLOOKUP(F7,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E7/1000))/4.18),\"\")","v":""}]
[null,5,null,null,null,"",{"$f":"IF(C8<>\"\",D8*poid*IF(F8<24,0.1227,VLOOKUP(F8,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E8/1000))/4.18),\"\")","v":""}]
[null,6,null,null,null,"",{"$f":"IF(C9<>\"\",D9*poid*IF(F9<24,0.1227,VLOOKUP(F9,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E9/1000))/4.18),\"\")","v":""}]
[null,7,null,null,null,"",{"$f":"IF(C10<>\"\",D10*poid*IF(F10<24,0.1227,VLOOKUP(F10,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E10/1000))/4.18),\"\")","v":""}]
[null,8,null,null,null,"",{"$f":"IF(C11<>\"\",D11*poid*IF(F11<24,0.1227,VLOOKUP(F11,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E11/1000))/4.18),\"\")","v":""}]
[null,9,null,null,null,"",{"$f":"IF(C12<>\"\",D12*poid*IF(F12<24,0.1227,VLOOKUP(F12,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E12/1000))/4.18),\"\")","v":""}]
[null,10,null,null,null,"",{"$f":"IF(C13<>\"\",D13*poid*IF(F13<24,0.1227,VLOOKUP(F13,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E13/1000))/4.18),\"\")","v":""}]
[null,"Total:",null,null,null,{"$f":"IF(D14<>\"\",(C14/D14)*60,\"\")","v":""},{"$f":"IF(G4<>\"\",SUM(G4:G13),\"\")","v":""}]

{"sheet":"CYCLISME","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Entrainement","Distance (km)","Temps (min)","Dénivelé (m)","Vitesse moyenne (km/h)","Calories (kcal)"]
[null,1,null,null,null,{"$f":"IF(D4<>\"\",(C4/D4)*60,\"\")","v":""},{"$f":"IF(C4<>\"\",D4*poid*IF(F4<24,0.1227,VLOOKUP(F4,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E4/1000))/4.18),\"\")","v":""}]
[null,2,null,null,null,{"$f":"IF(D5<>\"\",(C5/D5)*60,\"\")","v":""},{"$f":"IF(C5<>\"\",D5*poid*IF(F5<24,0.1227,VLOOKUP(F5,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E5/1000))/4.18),\"\")","v":""}]
[null,3,null,null,null,"",{"$f":"IF(C6<>\"\",D6*poid*IF(F6<24,0.1227,VLOOKUP(F6,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E6/1000))/4.18),\"\")","v":""}]
[null,4,null,null,null,"",{"$f":"IF(C7<>\"\",D7*poid*IF(F7<24,0.1227,VLOOKUP(F7,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E7/1000))/4.18),\"\")","v":""}]
[null,5,null,null,null,"",{"$f":"IF(C8<>\"\",D8*poid*IF(F8<24,0.1227,VLOOKUP(F8,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E8/1000))/4.18),\"\")","v":""}]
[null,6,null,null,null,"",{"$f":"IF(C9<>\"\",D9*poid*IF(F9<24,0.1227,VLOOKUP(F9,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E9/1000))/4.18),\"\")","v":""}]
[null,7,null,null,null,"",{"$f":"IF(C10<>\"\",D10*poid*IF(F10<24,0.1227,VLOOKUP(F10,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E10/1000))/4.18),\"\")","v":""}]
[null,8,null,null,null,"",{"$f":"IF(C11<>\"\",D11*poid*IF(F11<24,0.1227,VLOOKUP(F11,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E11/1000))/4.18),\"\")","v":""}]
[null,9,null,null,null,"",{"$f":"IF(C12<>\"\",D12*poid*IF(F12<24,0.1227,VLOOKUP(F12,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E12/1000))/4.18),\"\")","v":""}]
[null,10,null,null,null,"",{"$f":"IF(C13<>\"\",D13*poid*IF(F13<24,0.1227,VLOOKUP(F13,INFOS!F$4:G$14,2,TRUE))+((poid*9.18*(E13/1000))/4.18),\"\")","v":""}]
[null,"Total :",{"$f":"IF(C4<>\"\",SUM(distancep),\"\")","v":""},{"$f":"IF(D4<>\"\",SUM(tempsp),\"\")","v":""},{"$f":"IF(E4<>\"\",SUM(denivelep),\"\")","v":""},{"$f":"IF(F4<>\"\",AVERAGE(F4:F13),\"\")","v":""},{"$f":"IF(G4<>\"\",SUM(G4:G13),\"\")","v":""}]

{"sheet":"NATATION","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Enrtainement","Nb de longueurs","Bassin","Distance","Temps","Calories"]
[null,1,null,null,{"$f":"IF(C4<>\"\",IF(D4=\"G\",C4*50,C4*25),\"\")","v":""}]
[null,2,null,null,{"$f":"IF(C5<>\"\",IF(D5=\"G\",C5*50,C5*25),\"\")","v":""}]
[null,3,null,null,""]
[null,4,null,null,""]
[null,5,null,null,""]
[null,6,null,null,""]
[null,7,null,null,""]
[null,8,null,null,""]
[null,9,null,null,""]
[null,10,null,null,""]
[null,"Total :",{"$f":"IF(C4<>\"\",SUM(longueursp),\"\")","v":""},null,{"$f":"IF(E4<>\"\",SUM(E4:E13),\"\")","v":""},{"$f":"IF(F4<>\"\",SUM(tempsnp),\"\")","v":""},{"$f":"IF(G4<>\"\",SUM(longueursp),\"\")","v":""}]

{"sheet":"INFOS","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Poids ( kg ) :",80,null,null,"Vitesse","Coefficiant K"]
[null,"H/F :","H",null,null,24,"0.1229"]
[null,null,null,null,null,25,"0.1301"]
[null,"L cyclisme =",1,null,null,26,"0.1344"]
[null,"Nb objets cyclisme",3,null,null,27,"0.1377"]
[null,null,null,null,null,28,"0.1459"]
[null,"Nb objet total :","utile ???",null,null,29,"0.1635"]
[null,null,null,null,null,30,"0.1731"]
[null,null,null,null,null,31,"0.1833"]
[null,"L Course",1,null,null,32,"0.1941"]
[null,"Nb objets course",3,null,null,33,"0.2056"]
[null,null,null,null,null,34,"0.2177"]
[null,null,null,null,null,0,"0.1227"]
[]
[]
[null,"L natation",1]
[null,"Nb objets natation",2]