{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Bruk av regnearket","D1314","H1314","D1516","H1516"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Bruk av regnearket","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["BRUKSANVISNING"]
[]
[]
[1,"Finn frem resultatlister for løpet som skal legges inn, totalresultater og strekktider som viser strekktiden på beste klatrer og beste spurter."]
[2,"Ranger løperne på spurt og klatring"]
[3,"Klikk på arkfane for riktig klasse og legg inn løpere (hvis de har løpt tidligere løp trenger man ikke registrere disse på nytt)."]
[4,"Legg inn riktig poengsum etter rangering ihht MOT.TV reglene på vinner (Gul), Klatrer (Blå) og Sprinter (Grønn)."]
[null,"Poengsummer som skal brukers rangert fra nr 1 og utover er: 100, 80, 60, 50, 45, 40, 35, 30, 26, 22, 20, 20, 20, 20 osv"]
[5,"Trykk på Sorterknappen"]
[6,"Gå til neste klasse og gjenta pkt 1-5 osv"]
[7,"Det er lagt opp til 2 sprint- og 2 klatrestrekk i finalen, dvs at det deles ut dobbelt opp med poeng."]
[8,"Arket markerer beste løper i kategoriene men tar ikke hensyn til løperens alder (hvis løpere står helt likt)."]
[9,"Arket regner fortløpende ut starttider for jaktstarten i finalen"]
[10,"Hvis verdiene i starttidkolonnen blir merkelige under utfylling, trykk \"Sorter\" knappen"]

{"sheet":"D1314","index":1,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,10,4,19],[4,20,4,29]]}
[]
[null,null,null,null,null,null,null,null,"Sorter"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,161]
[null,null,"Gul ledertrøye",null,null,null,null,null,null,null,"Blå klatretrøye",null,null,null,null,null,null,null,null,null,"Grønn spurttrøye"]
["Navn","Klubb","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGul","Rangering","Starttid Finale","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nBlå","Finale (1)","Finale (2)","Sluttsum","Rangering","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGrønn","Finale (1)","Finale (M)","Sluttsum","Rangering"]
["Elise Ausen","Porsgrunn OL",100,100,null,80,160,{"$f":"SUM(C7:G7)","v":440},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":2},{"$f":"IF(COUNTA(C7:G7)>=2,((H$7-H7)*2/(24*3600)),(600/(24*3600)))","v":"00:00:00"},80,100,null,60,null,{"$f":"IF(COUNT(K7:O7)>2,LARGE(K7:O7,1)+LARGE(K7:O7,2)+LARGE(K7:O7,3),SUM(K7:O7))","v":240},120,null,{"$f":"P7+Q7+R7","v":360},{"$f":"IF(S7=0,0,RANK(S7,$S$7:$S$39))","v":2},60,80,null,50,null,{"$f":"IF(COUNT(U7:Y7)>2,LARGE(U7:Y7,1)+LARGE(U7:Y7,2)+LARGE(U7:Y7,3),SUM(U7:Y7))","v":190},120,null,{"$f":"Z7+AA7+AB7","v":310},{"$f":"IF(AC7=0,0,RANK(AC7,$AC$7:$AC$39))","v":3}]
["Hanna Johansson","Hedrum OL",80,80,null,100,200,{"$f":"SUM(C8:G8)","v":460},1,-4.6296296296296298E-4,100,60,null,100,null,260,160,null,420,1,100,45,null,45,null,190,100,null,290,4]
["Maria G. Mehammer","Porsgrunn OL",60,null,null,null,null,60,8,"00:10:00",50,null,null,null,null,50,null,null,50,8,40,null,null,null,null,40,null,null,40,9]
["Mina Schjerven","Lardal OK",50,null,null,null,null,50,9,"00:10:00",40,null,null,null,null,40,null,null,40,10,45,null,null,null,null,45,null,null,45,8]
["Ida Sofie Hjortland","Larvik OK",45,50,60,null,120,275,3,"00:05:30",60,50,100,null,null,210,100,null,310,4,100,50,80,null,null,230,160,null,390,2]
["Elise Støren","Bø OL",40,null,null,45,null,85,6,"00:11:50",45,null,null,50,null,95,null,null,95,6,50,null,null,35,null,85,null,null,85,7]
["Malene Nysæter","Skien OK",null,60,100,50,null,210,4,"00:07:40",null,80,60,80,null,220,null,null,220,5,null,60,60,60,null,180,null,null,180,5]
["Bethina Staulen Fredin","Skien OK",null,45,80,60,null,185,5,"00:08:30",null,45,80,35,null,160,200,null,360,2,null,100,100,100,null,300,200,null,500,1]
["Ragnhild Marie Kristensen","Stokke IL",null,40,null,35,null,75,7,"00:12:10",null,40,null,40,null,80,null,null,80,7,null,40,null,80,null,120,null,null,120,6]
["Frida Daler","Stokke IL",null,null,null,40,null,40,10,"00:10:00",null,null,null,45,null,45,null,null,45,9,null,null,null,30,null,30,null,null,30,11]
["Ylva Aasestad","Hedrum OL",null,null,null,30,null,30,11,"00:10:00",null,null,null,30,null,30,null,null,30,11,null,null,null,40,null,40,null,null,40,9]
[null,null,null,null,null,null,null,0,{"$f":"IF(H18=0,0,RANK(H18,$H$7:$H$39))","v":0},{"$f":"IF(COUNTA(C18:G18)>=2,((H$7-H18)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,null,null,null,{"$f":"IF(COUNT(K18:O18)>2,LARGE(K18:O18,1)+LARGE(K18:O18,2)+LARGE(K18:O18,3),SUM(K18:O18))","v":0},null,null,{"$f":"P18+Q18+R18","v":0},{"$f":"IF(S18=0,0,RANK(S18,$S$7:$S$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(U18:Y18)>2,LARGE(U18:Y18,1)+LARGE(U18:Y18,2)+LARGE(U18:Y18,3),SUM(U18:Y18))","v":0},null,null,{"$f":"Z18+AA18+AB18","v":0},{"$f":"IF(AC18=0,0,RANK(AC18,$AC$7:$AC$39))","v":0}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H22=0,0,RANK(H22,$H$7:$H$39))","v":0},{"$f":"IF(COUNTA(C22:F22)>=2,((H$7-H22)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,null,null,null,{"$f":"IF(COUNT(K22:N22)=4,SUM(K22:N22)-MIN(K22:N22),SUM(K22:N22))","v":0},null,null,{"$f":"P22+Q22+R22","v":0},{"$f":"IF(S22=0,0,RANK(S22,$S$7:$S$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(U22:X22)=4,SUM(U22:X22)-MIN(U22:X22),SUM(U22:X22))","v":0},null,null,{"$f":"Z22+AA22+AB22","v":0},{"$f":"IF(AC22=0,0,RANK(AC22,$AC$7:$AC$39))","v":0}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H40=0,0,RANK(H40,$H$7:$H$20))","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]

{"sheet":"H1314","index":2,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,10,4,19],[4,20,4,29]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,null,null,null,null,null,null,"Blå klatretrøye",null,null,null,null,null,null,null,null,null,"Grønn spurttrøye"]
["Navn","Klubb","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGul","Rangering","Starttid Finale","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nBlå","Finale (1)","Finale (2)","Sluttsum","Rangering","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGrønn","Finale (1)","Finale (M)","Sluttsum","Rangering"]
["Cornelius Bjørk","Sandefjord OK",100,100,100,null,160,{"$f":"SUM(C7:G7)","v":460},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":1},{"$f":"IF(COUNTA(C7:G7)>=2,((H$7-H7)*2/(24*3600)),(600/(24*3600)))","v":"00:00:00"},50,null,80,100,null,{"$f":"IF(COUNT(K7:O7)>2,LARGE(K7:O7,1)+LARGE(K7:O7,2)+LARGE(K7:O7,3),SUM(K7:O7))","v":230},160,null,{"$f":"P7+Q7+R7","v":390},{"$f":"IF(S7=0,0,RANK(S7,$S$7:$S$39))","v":2},45,null,60,30,null,{"$f":"IF(COUNT(U7:Y7)>2,LARGE(U7:Y7,1)+LARGE(U7:Y7,2)+LARGE(U7:Y7,3),SUM(U7:Y7))","v":135},160,null,{"$f":"Z7+AA7+AB7","v":295},{"$f":"IF(AC7=0,0,RANK(AC7,$AC$7:$AC$39))","v":4}]
["Viljan van Raaij","Hedrum OL",80,80,null,100,90,{"$f":"SUM(C8:G8)","v":350},2,"00:03:40",35,null,40,60,null,135,80,null,215,4,30,null,60,50,null,140,80,null,220,6]
["Even Gravningen","Stokke IL",60,50,10,null,200,320,3,"00:04:40",100,20,null,null,null,120,160,null,280,3,50,60,null,null,null,110,200,null,310,2]
["Jakob Hjelseth","OTO",50,60,50,null,null,160,7,"00:10:00",60,50,35,null,null,145,null,null,145,7,45,50,60,null,null,155,null,null,155,9]
["Audun Brevik","Stokke IL",45,null,null,null,null,45,14,"00:10:00",45,null,null,null,null,45,null,null,45,15,45,null,null,null,null,45,null,null,45,15]
["Åsmund Slokvik","Notodden OL",40,null,80,50,120,290,4,"00:05:40",null,80,100,80,null,260,200,null,460,1,80,null,80,80,null,240,120,null,360,1]
["Morten Krona Haflan","OTO",35,10,null,null,null,45,14,"00:13:50",80,45,null,null,null,125,null,null,125,10,100,80,null,null,null,180,null,null,180,8]
["Henrik R Holt","Hedrum OL",30,22,null,80,80,212,5,"00:08:16",null,100,45,50,null,26,70,null,96,12,80,45,null,50,null,175,90,null,265,5]
["Håvard Skriubakken","Porsgrunn OL",26,26,null,null,null,52,13,"00:13:36",26,26,null,null,null,{"$f":"IF(COUNT(K15:O15)>2,LARGE(K15:O15,1)+LARGE(K15:O15,2)+LARGE(K15:O15,3),SUM(K15:O15))","v":52},null,null,52,14,30,20,null,null,null,50,null,null,50,14]
["Per Anders Eckdahl","OK Horten",22,null,35,10,20,87,11,"00:12:26",30,null,26,45,null,101,60,null,161,6,22,null,30,50,null,102,20,null,122,12]
["Iver Ringheim","Larvik OK",null,45,60,40,null,145,8,"00:10:30",null,30,80,35,null,145,null,null,145,7,null,35,26,80,null,141,null,null,141,10]
["Halvard Kornmo","Porsgrunn OL",null,40,10,null,70,120,9,"00:11:20",null,40,null,null,null,40,90,null,130,9,null,20,10,null,null,30,60,null,90,13]
["Jonas Eikås","Sandefjord OK",null,30,40,null,100,170,6,"00:09:40",null,20,50,null,null,70,100,null,170,5,null,22,40,null,null,62,70,null,132,11]
["Snorre Slokvik","Notodden OL",null,20,10,45,null,75,12,"00:12:50",null,60,30,null,null,90,null,null,90,13,null,100,100,100,null,300,null,null,300,3]
["Kristoffer Fjære","Hedrum OL",null,20,null,35,60,115,10,"00:11:30",null,22,null,40,null,62,52,null,114,11,null,40,null,35,null,75,120,null,195,7]
["Jakob Schia Løe","Notodden OL",null,null,10,null,null,10,{"$f":"IF(H22=0,0,RANK(H22,$H$7:$H$39))","v":16},{"$f":"IF(COUNTA(C22:G22)>=2,((H$7-H22)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,null,null,null,{"$f":"IF(COUNT(K22:O22)>2,LARGE(K22:O22,1)+LARGE(K22:O22,2)+LARGE(K22:O22,3),SUM(K22:O22))","v":0},null,null,{"$f":"P22+Q22+R22","v":0},{"$f":"IF(S22=0,0,RANK(S22,$S$7:$S$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(U22:Y22)>2,LARGE(U22:Y22,1)+LARGE(U22:Y22,2)+LARGE(U22:Y22,3),SUM(U22:Y22))","v":0},null,null,{"$f":"Z22+AA22+AB22","v":0},{"$f":"IF(AC22=0,0,RANK(AC22,$AC$7:$AC$39))","v":0}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H29=0,0,RANK(H29,$H$7:$H$39))","v":0},{"$f":"IF(COUNTA(C29:F29)>=2,((H$7-H29)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,null,null,null,{"$f":"IF(COUNT(K29:N29)=4,SUM(K29:N29)-MIN(K29:N29),SUM(K29:N29))","v":0},null,null,{"$f":"P29+Q29+R29","v":0},{"$f":"IF(S29=0,0,RANK(S29,$S$7:$S$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(U29:X29)=4,SUM(U29:X29)-MIN(U29:X29),SUM(U29:X29))","v":0},null,null,{"$f":"Z29+AA29+AB29","v":0},{"$f":"IF(AC29=0,0,RANK(AC29,$AC$7:$AC$39))","v":0}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H40=0,0,RANK(H40,$H$7:$H$20))","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]

{"sheet":"D1516","index":3,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,10,4,19],[4,20,4,29]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,null,null,null,null,null,null,"Blå klatretrøye",null,null,null,null,null,null,null,null,null,"Grønn spurttrøye"]
["Navn","Klubb","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGul","Rangering","Starttid Finale","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nBlå","Finale (1)","Finale (2)","Sluttsum","Rangering","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGrønn","Finale (1)","Finale (M)","Sluttsum","Rangering"]
["Signe Bredholt Jørgensen","Sandefjord OK",100,60,80,null,200,{"$f":"SUM(C7:G7)","v":440},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":1},{"$f":"IF(COUNTA(C7:G7)>=2,((H$7-H7)*2/(24*3600)),(600/(24*3600)))","v":"00:00:00"},100,60,100,null,null,{"$f":"IF(COUNT(K7:O7)>2,LARGE(K7:O7,1)+LARGE(K7:O7,2)+LARGE(K7:O7,3),SUM(K7:O7))","v":260},200,null,{"$f":"P7+Q7+R7","v":460},{"$f":"IF(S7=0,0,RANK(S7,$S$7:$S$39))","v":1},80,80,50,null,null,{"$f":"IF(COUNT(U7:Y7)>2,LARGE(U7:Y7,1)+LARGE(U7:Y7,2)+LARGE(U7:Y7,3),SUM(U7:Y7))","v":210},90,null,{"$f":"Z7+AB7+AA7","v":300},{"$f":"IF(AC7=0,0,RANK(AC7,$AC$7:$AC$39))","v":4}]
["Maria Prestbøen","Sandefjord OK",80,null,60,null,160,{"$f":"SUM(C8:G8)","v":300},3,"00:04:40",60,null,80,null,null,140,160,null,300,3,100,null,80,null,null,180,70,null,250,5]
["Hanne Vassend","Porsgrunn OL",null,80,100,100,120,400,2,"00:01:20",80,80,null,100,null,260,120,null,380,2,60,100,null,80,null,240,120,null,360,2]
["Hanna Nysæter","Skien OK",50,50,null,80,80,260,4,"00:06:00",50,50,null,80,null,180,100,null,280,4,30,45,null,100,null,175,160,null,335,3]
["Ella Arentz Hagen","Sandefjord OK",45,100,null,null,100,245,5,"00:06:30",45,100,null,null,null,145,90,null,235,5,60,50,null,null,null,110,80,null,190,6]
["Anna Meen","Porsgrunn OL",40,null,50,60,70,220,6,"00:07:20",null,45,50,60,null,155,80,null,235,5,40,null,100,80,null,220,200,null,420,1]
["Camilla L. Rosenvold","Porsgrunn OL",35,45,null,null,null,80,8,"00:12:00",35,40,null,null,null,75,null,null,75,8,60,60,null,null,null,120,null,null,120,7]
["Ingrid G. Mehammer","Porsgrunn OL",30,null,null,null,null,30,10,"00:10:00",30,null,null,null,null,30,null,null,30,10,35,null,null,null,null,35,null,null,35,9]
["Mona E. S. Kierulf","Larvik OK",26,null,null,10,null,36,9,"00:13:28",26,null,null,50,null,76,null,null,76,7,26,null,null,null,null,26,null,null,26,10]
["Andrine Harriet Fremstad","Larvik OK",null,null,null,null,90,90,{"$f":"IF(H16=0,0,RANK(H16,$H$7:$H$39))","v":7},{"$f":"IF(COUNTA(C16:F16)>=2,((H$7-H16)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,null,null,null,{"$f":"IF(COUNT(K16:N16)=4,SUM(K16:N16)-MIN(K16:N16),SUM(K16:N16))","v":0},70,null,{"$f":"P16+Q16+R16","v":70},{"$f":"IF(S16=0,0,RANK(S16,$S$7:$S$39))","v":9},null,null,null,null,null,{"$f":"IF(COUNT(U16:X16)=4,SUM(U16:X16)-MIN(U16:X16),SUM(U16:X16))","v":0},100,null,{"$f":"Z16+AA16+AB16","v":100},{"$f":"IF(AC16=0,0,RANK(AC16,$AC$7:$AC$39))","v":8}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H40=0,0,RANK(H40,$H$7:$H$20))","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]

{"sheet":"H1516","index":4,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,10,4,19],[4,20,4,29]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,null,null,null,null,null,null,"Blå klatretrøye",null,null,null,null,null,null,null,null,null,"Grønn spurttrøye"]
["Navn","Klubb","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGul","Rangering","Starttid Finale","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nBlå","Finale (1)","Finale (2)","Sluttsum","Rangering","Løp 1","Løp 2","Løp 3","Løp 4","Løp 5","Sammenlagt \nGrønn","Finale (1)","Finale (M)","Sluttsum","Rangering"]
["Sindre R Holt","Hedrum OK",100,100,100,null,200,{"$f":"SUM(C7:G7)","v":500},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":1},{"$f":"IF(COUNTA(C7:F7)>=2,((H$7-H7)*2/(24*3600)),(600/(24*3600)))","v":"00:00:00"},100,100,100,null,null,{"$f":"IF(COUNT(K7:O7)>2,LARGE(K7:O7,1)+LARGE(K7:O7,2)+LARGE(K7:O7,3),SUM(K7:O7))","v":300},200,null,{"$f":"P7+Q7+R7","v":500},{"$f":"IF(S7=0,0,RANK(S7,$S$7:$S$39))","v":1},50,30,50,null,null,26,90,null,{"$f":"Z7+AA7+AB7","v":116},{"$f":"IF(AC7=0,0,RANK(AC7,$AC$7:$AC$39))","v":7}]
["Audun Melby Jacobsen","Lardal OK",80,45,null,35,null,{"$f":"SUM(C8:G8)","v":160},7,"00:11:20",80,26,null,50,null,156,null,null,156,8,80,80,null,80,null,{"$f":"IF(COUNT(U8:Y8)>2,LARGE(U8:Y8,1)+LARGE(U8:Y8,2)+LARGE(U8:Y8,3),SUM(U8:Y8))","v":240},null,null,240,6]
["Håkon Kornmo","Porsgrunn OL",60,35,60,null,160,315,3,"00:06:10",35,50,50,null,null,135,100,null,235,4,40,60,40,null,null,{"$f":"IF(COUNT(U9:Y9)>2,LARGE(U9:Y9,1)+LARGE(U9:Y9,2)+LARGE(U9:Y9,3),SUM(U9:Y9))","v":140},120,null,260,5]
["Alexander Repstad Stormyr","IL Hauken",50,50,null,60,80,240,4,"00:08:40",30,45,null,80,null,155,70,null,225,5,80,40,null,80,null,{"$f":"IF(COUNT(U10:Y10)>2,LARGE(U10:Y10,1)+LARGE(U10:Y10,2)+LARGE(U10:Y10,3),SUM(U10:Y10))","v":200},200,null,400,2]
["Skjalg Nysæter","Skien OK",null,80,80,100,120,380,2,"00:04:00",null,60,60,60,null,180,120,null,300,3,null,50,60,45,null,{"$f":"IF(COUNT(U11:Y11)>2,LARGE(U11:Y11,1)+LARGE(U11:Y11,2)+LARGE(U11:Y11,3),SUM(U11:Y11))","v":155},120,null,275,4]
["Rasmus Mathiesen","Porsgrunn OL",40,null,50,50,100,240,4,"00:08:40",null,80,80,100,null,260,200,null,460,2,null,45,45,30,null,22,80,null,102,8]
["Hermund Ulvensøen","OTO",35,null,null,null,null,35,11,"00:10:00",45,null,null,null,null,45,null,null,45,10,30,null,null,null,null,{"$f":"IF(COUNT(U13:Y13)>2,LARGE(U13:Y13,1)+LARGE(U13:Y13,2)+LARGE(U13:Y13,3),SUM(U13:Y13))","v":30},null,null,30,11]
["Even Andre Thorbjørnsen","Notodden OL",30,null,40,45,20,135,8,"00:12:10",60,null,40,40,null,140,80,null,220,6,100,100,80,null,null,{"$f":"IF(COUNT(U14:Y14)>2,LARGE(U14:Y14,1)+LARGE(U14:Y14,2)+LARGE(U14:Y14,3),SUM(U14:Y14))","v":280},200,null,480,1]
["Trym B Island","OTO",null,60,45,40,20,165,6,"00:11:10",null,40,45,45,null,130,90,null,220,6,null,40,100,100,null,{"$f":"IF(COUNT(U15:Y15)>2,LARGE(U15:Y15,1)+LARGE(U15:Y15,2)+LARGE(U15:Y15,3),SUM(U15:Y15))","v":240},70,null,310,3]
["Georg  Andresen","Skien OK",null,26,null,30,null,56,10,"00:14:48",null,30,null,30,null,60,null,null,60,9,null,26,null,35,null,35,null,null,35,10]
["Vegard Haugen","Porsgrunn OL",null,10,null,null,null,10,{"$f":"IF(H17=0,0,RANK(H17,$H$7:$H$39))","v":12},{"$f":"IF(COUNTA(C17:F17)>=2,((H$7-H17)*2/(24*3600)),(600/(24*3600)))","v":"00:10:00"},null,null,10,null,null,{"$f":"IF(COUNT(K17:O17)>2,LARGE(K17:O17,1)+LARGE(K17:O17,2)+LARGE(K17:O17,3),SUM(K17:O17))","v":10},null,null,{"$f":"P17+Q17+R17","v":10},{"$f":"IF(S17=0,0,RANK(S17,$S$7:$S$39))","v":12},null,null,10,null,null,{"$f":"IF(COUNT(U17:Y17)>2,LARGE(U17:Y17,1)+LARGE(U17:Y17,2)+LARGE(U17:Y17,3),SUM(U17:Y17))","v":10},null,null,{"$f":"Z17+AA17+AB17","v":10},{"$f":"IF(AC17=0,0,RANK(AC17,$AC$7:$AC$39))","v":12}]
["Olav Aasmundstveit Hoff","OTO",null,null,null,80,null,80,9,"00:10:00",null,null,null,35,null,35,null,null,35,11,null,null,null,40,null,40,null,null,40,9]
[null,null,null,null,null,null,null,0,{"$f":"IF(H19=0,0,RANK(H19,$H$7:$H$39))","v":0},"00:10:00",null,null,null,null,null,{"$f":"IF(COUNT(K19:N19)=4,SUM(K19:N19)-MIN(K19:N19),SUM(K19:N19))","v":0},null,null,{"$f":"P19+Q19+R19","v":0},{"$f":"IF(S19=0,0,RANK(S19,$S$7:$S$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(U19:X19)=4,SUM(U19:X19)-MIN(U19:X19),SUM(U19:X19))","v":0},null,null,{"$f":"Z19+AA19+AB19","v":0},{"$f":"IF(AC19=0,0,RANK(AC19,$AC$7:$AC$39))","v":0}]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,"00:10:00",null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(H40=0,0,RANK(H40,$H$7:$H$20))","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]