{"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":31,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,11,4,20],[4,21,4,30]]}
[]
[null,null,null,null,null,null,null,null,"Sorter"]
[]
[]
[null,null,"Gul ledertrøye",null,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","Finale","Total","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"]
["Hanne Vassend","Porsgrunn O-lag",80,null,45,60,80,{"$f":"IF(COUNT(C7:G7)>2,LARGE(C7:G7,1)+LARGE(C7:G7,2)+LARGE(C7:G7,3),SUM(C7:G7))","v":220},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":3},200,{"$f":"H7+J7","v":420},100,null,45,35,40,{"$f":"IF(COUNT(L7:P7)>2,LARGE(L7:P7,1)+LARGE(L7:P7,2)+LARGE(L7:P7,3),SUM(L7:P7))","v":185},160,null,{"$f":"Q7+R7+S7","v":345},{"$f":"IF(T7=0,0,RANK(T7,$T$7:$T$39))","v":3},40,null,80,45,60,{"$f":"IF(COUNT(V7:Z7)>2,LARGE(V7:Z7,1)+LARGE(V7:Z7,2)+LARGE(V7:Z7,3),SUM(V7:Z7))","v":185},120,null,{"$f":"AA7+AB7+AC7","v":305},{"$f":"IF(AD7=0,0,RANK(AD7,$AD$7:$AD$39))","v":4}]
["Signe Bredholdt Jørgensen","Sandefjord OK",100,100,60,80,60,280,2,160,440,80,80,60,80,60,240,200,null,440,1,60,100,60,50,50,220,90,null,310,3]
["Camilla L. Rosenvold","Porsgrunn O-lag",60,null,null,45,40,145,5,120,265,35,null,null,50,35,120,120,null,240,6,40,null,null,26,40,106,70,null,176,8]
["Maria Prestbøen","Sandefjord OK",35,60,100,100,100,300,1,100,400,30,100,100,100,45,300,100,null,400,2,100,100,50,80,80,280,70,null,350,2]
["Hanna Nysæter","Skien OK",45,null,50,26,10,121,7,90,211,60,null,22,26,30,116,70,null,186,8,40,null,50,80,30,170,80,null,250,6]
["Ella Arentz Hagen","Sandefjord OK",50,80,80,null,50,210,4,80,290,40,60,80,null,100,240,90,null,330,4,45,50,40,null,35,135,100,null,235,7]
["Anna Meen","Porsgrunn O-lag",40,null,35,50,45,135,6,70,205,50,null,50,60,50,160,90,null,250,5,50,null,35,35,50,135,160,null,295,5]
["Therese Hamre Biseth","Notodden OL",26,50,30,35,35,120,8,60,180,26,50,40,45,80,175,60,null,235,7,100,60,100,100,100,300,200,null,500,1]
["Una Rebård","Sandefjord OK",null,null,null,30,null,30,12,null,30,null,null,null,30,null,30,null,null,30,11,null,null,null,35,null,35,null,null,35,11]
["Stine Berg","Porsgrunn O-lag",null,null,26,null,null,26,13,null,26,null,null,30,null,null,30,null,null,30,11,null,null,22,null,null,22,null,null,22,13]
["Katrine Gjestrum","Hedrum OL",null,null,null,40,null,40,10,null,40,null,null,null,22,null,22,null,null,22,14,null,null,null,22,null,22,null,null,22,13]
["Josefine Kirste","Skien OK",null,null,null,22,null,22,14,null,22,null,null,null,40,null,40,null,null,40,10,null,null,null,45,null,45,null,null,45,10]
["Ingrid G. Mehammer","Porsgrunn O-lag",30,null,22,null,null,52,9,null,52,45,null,35,null,null,80,null,null,80,9,26,null,26,null,null,52,null,null,52,9]
["Anne Omholt Berrefjord","Lardal OL",null,null,40,null,null,40,10,null,40,null,null,26,null,null,26,null,null,26,13,null,null,35,null,null,35,null,null,35,11]
[null,null,null,null,null,null,null,{"$f":"IF(COUNT(C21:G21)>2,LARGE(C21:G21,1)+LARGE(C21:G21,2)+LARGE(C21:G21,3),SUM(C21:G21))","v":0},{"$f":"IF(H21=0,0,RANK(H21,$H$7:$H$39))","v":0},null,null,null,null,null,null,null,{"$f":"IF(COUNT(L21:P21)>2,LARGE(L21:P21,1)+LARGE(L21:P21,2)+LARGE(L21:P21,3),SUM(L21:P21))","v":0},null,null,{"$f":"Q21+R21+S21","v":0},{"$f":"IF(T21=0,0,RANK(T21,$T$7:$T$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(V21:Z21)>2,LARGE(V21:Z21,1)+LARGE(V21:Z21,2)+LARGE(V21:Z21,3),SUM(V21:Z21))","v":0},null,null,{"$f":"AA21+AB21+AC21","v":0},{"$f":"IF(AD21=0,0,RANK(AD21,$AD$7:$AD$39))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:F22)=4,SUM(C22:F22)-MIN(C22:F22),SUM(C22:F22))","v":0},{"$f":"IF(H22=0,0,RANK(H22,$H$7:$H$39))","v":0},null,null,null,null,null,null,null,{"$f":"IF(COUNT(L22:O22)=4,SUM(L22:O22)-MIN(L22:O22),SUM(L22:O22))","v":0},null,null,{"$f":"Q22+R22+S22","v":0},{"$f":"IF(T22=0,0,RANK(T22,$T$7:$T$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(V22:Y22)=4,SUM(V22:Y22)-MIN(V22:Y22),SUM(V22:Y22))","v":0},null,null,{"$f":"AA22+AB22+AC22","v":0},{"$f":"IF(AD22=0,0,RANK(AD22,$AD$7:$AD$39))","v":0}]
[null,null,null,null,null,null,null,0,0,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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":31,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,11,4,20],[4,21,4,30]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,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 før finale","Finale","Total","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"]
["Skjalg Nysæter","Skien OK",80,60,60,60,80,{"$f":"IF(COUNT(C7:G7)>2,LARGE(C7:G7,1)+LARGE(C7:G7,2)+LARGE(C7:G7,3),SUM(C7:G7))","v":220},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":3},200,{"$f":"H7+J7","v":420},80,80,45,30,60,{"$f":"IF(COUNT(L7:P7)>2,LARGE(L7:P7,1)+LARGE(L7:P7,2)+LARGE(L7:P7,3),SUM(L7:P7))","v":220},100,null,{"$f":"Q7+R7+S7","v":320},{"$f":"IF(T7=0,0,RANK(T7,$T$7:$T$39))","v":3},30,45,45,45,60,{"$f":"IF(COUNT(V7:Z7)>2,LARGE(V7:Z7,1)+LARGE(V7:Z7,2)+LARGE(V7:Z7,3),SUM(V7:Z7))","v":150},100,null,{"$f":"AA7+AB7+AC7","v":250},{"$f":"IF(AD7=0,0,RANK(AD7,$AD$7:$AD$39))","v":5}]
["Håkon Kornmo","Porsgrunn O-lag",60,80,10,null,null,150,5,160,310,60,100,10,null,null,170,200,null,370,2,45,50,10,null,null,105,80,null,185,7]
["Sindre R. Holt","Hedrum O-lag",100,100,45,100,null,300,1,120,420,100,35,80,100,null,280,160,null,440,1,50,80,60,60,null,200,100,null,300,3]
["Olav Aamunstveit Hoff","OTO",null,10,null,45,60,115,9,100,215,null,10,null,60,100,170,80,null,250,5,null,22,null,45,45,112,120,null,232,6]
["Audun Melby Jacobsen","Lardal O-lag",50,null,100,null,null,150,5,90,240,50,null,100,null,null,150,90,null,240,6,100,null,100,null,null,200,160,null,360,2]
["Alexander Repstad Storemyr","IL Hauken",45,50,80,40,100,230,2,80,310,26,40,60,45,80,185,120,null,305,4,40,80,40,60,80,220,70,null,290,4]
["Even Andre Thorbjørnsen","Notodden OL",null,26,30,30,40,100,10,70,170,22,30,40,40,40,120,70,null,190,7,100,100,80,100,100,300,200,null,500,1]
["Elias Lindhjem Mathisen","Sandefjord OK",30,40,10,80,50,170,4,null,170,30,60,10,80,45,185,null,null,185,8,60,45,30,30,60,165,null,null,165,8]
["Trym B Island","OTO",null,45,35,null,45,125,8,null,125,null,50,35,null,50,135,null,null,135,9,null,26,26,null,40,92,null,null,92,11]
["Jørgen Slokvik","Notodden OL",null,null,50,35,null,85,11,null,85,null,null,50,60,null,110,null,null,110,10,null,null,50,80,null,130,null,null,130,9]
["Rasmus Mathisen","Porsgrunn O-lag",40,null,40,50,null,130,7,null,130,40,null,30,35,null,105,null,null,105,11,26,null,40,35,null,101,null,null,101,10]
["Henrik Bertelsen","Porsgrunn O-lag",35,30,null,null,null,65,12,null,65,45,26,null,null,null,71,null,null,71,12,35,30,null,null,null,65,null,null,65,12]
["Hermund Ulvsøen","OTO",null,35,null,null,null,35,13,null,35,null,45,null,null,null,45,null,null,45,13,null,45,null,null,null,45,null,null,45,13]
[null,null,null,null,null,null,null,{"$f":"IF(COUNT(C20:G20)>2,LARGE(C20:G20,1)+LARGE(C20:G20,2)+LARGE(C20:G20,3),SUM(C20:G20))","v":0},{"$f":"IF(H20=0,0,RANK(H20,$H$7:$H$39))","v":0},null,{"$f":"H20+J20","v":"00:00:00"},null,null,null,null,null,{"$f":"IF(COUNT(L20:P20)>2,LARGE(L20:P20,1)+LARGE(L20:P20,2)+LARGE(L20:P20,3),SUM(L20:P20))","v":0},null,null,{"$f":"Q20+R20+S20","v":0},{"$f":"IF(T20=0,0,RANK(T20,$T$7:$T$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(V20:Z20)>2,LARGE(V20:Z20,1)+LARGE(V20:Z20,2)+LARGE(V20:Z20,3),SUM(V20:Z20))","v":0},null,null,{"$f":"AA20+AB20+AC20","v":0},{"$f":"IF(AD20=0,0,RANK(AD20,$AD$7:$AD$39))","v":0}]
[null,null,null,null,null,null,null,0,0,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,{"$f":"IF(COUNT(C29:F29)=4,SUM(C29:F29)-MIN(C29:F29),SUM(C29:F29))","v":0},{"$f":"IF(H29=0,0,RANK(H29,$H$7:$H$39))","v":0},null,"00:00:00",null,null,null,null,null,{"$f":"IF(COUNT(L29:O29)=4,SUM(L29:O29)-MIN(L29:O29),SUM(L29:O29))","v":0},null,null,{"$f":"Q29+R29+S29","v":0},{"$f":"IF(T29=0,0,RANK(T29,$T$7:$T$39))","v":0},null,null,null,null,null,{"$f":"IF(COUNT(V29:Y29)=4,SUM(V29:Y29)-MIN(V29:Y29),SUM(V29:Y29))","v":0},null,null,{"$f":"AA29+AB29+AC29","v":0},{"$f":"IF(AD29=0,0,RANK(AD29,$AD$7:$AD$39))","v":0}]
[null,null,null,null,null,null,null,0,0,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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,null,"00:00: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":31,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,11,4,20],[4,21,4,30]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,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 før finale","Finale","Totalt","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"]
["Marit Melby Jacobsen","Lardal OL",null,null,50,100,null,{"$f":"IF(COUNT(C7:G7)>2,LARGE(C7:G7,1)+LARGE(C7:G7,2)+LARGE(C7:G7,3),SUM(C7:G7))","v":150},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":6},200,{"$f":"H7+J7","v":350},null,null,45,80,null,{"$f":"IF(COUNT(L7:P7)>2,LARGE(L7:P7,1)+LARGE(L7:P7,2)+LARGE(L7:P7,3),SUM(L7:P7))","v":125},200,null,{"$f":"Q7+R7+S7","v":325},{"$f":"IF(T7=0,0,RANK(T7,$T$7:$T$39))","v":2},null,null,100,100,null,{"$f":"IF(COUNT(V7:Z7)>2,LARGE(V7:Z7,1)+LARGE(V7:Z7,2)+LARGE(V7:Z7,3),SUM(V7:Z7))","v":200},90,null,{"$f":"AA7+AC7+AB7","v":290},{"$f":"IF(AD7=0,0,RANK(AD7,$AD$7:$AD$39))","v":4}]
["Martine Topstad","OTO",50,100,100,null,100,300,1,160,460,100,80,100,null,50,280,200,null,480,1,100,50,100,null,100,300,160,null,460,1]
["Astrid Styrvold","Porsgrunn O-lag",null,80,null,10,null,90,9,120,210,null,100,null,60,null,160,80,null,240,5,null,80,null,0,0,80,70,null,150,9]
["Beate Berg","Porsgrunn O-lag",100,null,80,null,null,180,4,100,280,60,null,80,null,null,140,90,null,230,6,80,null,40,null,null,120,120,null,240,6]
["Emilie Westin","Porsgrunn O-lag",45,null,60,60,80,200,3,90,290,80,null,60,100,45,240,60,null,300,4,45,null,50,40,45,140,52,null,192,7]
["Martine Gustavsen","Sandefjord OK",60,60,35,40,45,165,5,80,245,50,60,35,45,60,170,52,null,222,7,50,60,35,45,80,190,90,null,280,5]
["Elise Kaland Odden","Porsgrunn O-lag",null,null,10,45,50,105,7,70,175,null,null,10,50,80,140,70,null,210,8,null,null,10,100,60,170,200,null,370,3]
["Linn Hege Roso","Lardal OL",null,null,45,50,null,95,8,60,155,null,null,50,35,null,85,120,null,205,9,null,null,60,50,null,110,60,null,170,8]
["Sandra B. Robertsen","OTO",80,50,40,80,60,220,2,null,220,45,50,40,45,100,195,120,null,315,3,60,100,50,100,60,260,120,null,380,2]
[null,null,null,null,null,null,null,{"$f":"IF(COUNT(C16:F16)=4,SUM(C16:F16)-MIN(C16:F16),SUM(C16:F16))","v":0},{"$f":"IF(H16=0,0,RANK(H16,$H$7:$H$39))","v":0},null,null,null,null,null,null,null,{"$f":"IF(COUNT(L16:O16)=4,SUM(L16:O16)-MIN(L16:O16),SUM(L16:O16))","v":0},null,null,{"$f":"Q16+R16+S16","v":0},{"$f":"IF(T16=0,0,RANK(T16,$T$7:$T$39))","v":0},null,null,null,0,null,{"$f":"IF(COUNT(V16:Y16)=4,SUM(V16:Y16)-MIN(V16:Y16),SUM(V16:Y16))","v":0},null,null,{"$f":"AA16+AB16+AC16","v":0},{"$f":"IF(AD16=0,0,RANK(AD16,$AD$7:$AD$39))","v":0}]
[null,null,null,null,null,null,null,0,0,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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":31,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,11,4,20],[4,21,4,30]]}
[]
[]
[]
[]
[null,null,"Gul ledertrøye",null,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 før finale","Finale","Totalt","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"]
["Tobias Kristensen","Larvik OK",45,80,20,50,45,{"$f":"IF(COUNT(C7:G7)>2,LARGE(C7:G7,1)+LARGE(C7:G7,2)+LARGE(C7:G7,3),SUM(C7:G7))","v":175},{"$f":"IF(H7=0,0,RANK(H7,$H$7:$H$39))","v":4},200,{"$f":"H7+J7","v":375},80,50,50,40,35,{"$f":"IF(COUNT(L7:P7)>2,LARGE(L7:P7,1)+LARGE(L7:P7,2)+LARGE(L7:P7,3),SUM(L7:P7))","v":180},90,null,{"$f":"Q7+R7+S7","v":270},{"$f":"IF(T7=0,0,RANK(T7,$T$7:$T$39))","v":5},26,80,35,35,50,{"$f":"IF(COUNT(V7:Z7)>2,LARGE(V7:Z7,1)+LARGE(V7:Z7,2)+LARGE(V7:Z7,3),SUM(V7:Z7))","v":165},160,null,{"$f":"AA7+AB7+AC7","v":325},{"$f":"IF(AD7=0,0,RANK(AD7,$AD$7:$AD$39))","v":3}]
["Anders Krona Haflan","OTO",100,null,45,35,80,225,2,160,385,26,null,80,80,50,{"$f":"IF(COUNT(L8:P8)>2,LARGE(L8:P8,1)+LARGE(L8:P8,2)+LARGE(L8:P8,3),SUM(L8:P8))","v":210},70,null,280,3,100,null,100,80,100,{"$f":"IF(COUNT(V8:Z8)>2,LARGE(V8:Z8,1)+LARGE(V8:Z8,2)+LARGE(V8:Z8,3),SUM(V8:Z8))","v":300},120,null,420,2]
["Hallvard Arntzen Foss","Sandefjord OK",60,100,80,100,100,300,1,120,420,60,100,22,35,45,{"$f":"IF(COUNT(L9:P9)>2,LARGE(L9:P9,1)+LARGE(L9:P9,2)+LARGE(L9:P9,3),SUM(L9:P9))","v":205},80,null,285,2,60,45,40,22,40,{"$f":"IF(COUNT(V9:Z9)>2,LARGE(V9:Z9,1)+LARGE(V9:Z9,2)+LARGE(V9:Z9,3),SUM(V9:Z9))","v":145},60,null,205,6]
["Ole Jacob Olsrød","Stokke",null,60,20,30,26,116,10,100,216,null,40,20,100,60,{"$f":"IF(COUNT(L10:O10)=4,SUM(L10:O10)-MIN(L10:O10),SUM(L10:O10))","v":160},120,null,280,3,null,45,22,80,26,{"$f":"IF(COUNT(V10:Y10)=4,SUM(V10:Y10)-MIN(V10:Y10),SUM(V10:Y10))","v":147},70,null,217,5]
["Mathias Gløersen","OTO",null,null,60,80,40,180,3,90,270,null,null,20,20,30,{"$f":"IF(COUNT(L11:O11)=4,SUM(L11:O11)-MIN(L11:O11),SUM(L11:O11))","v":40},200,null,240,7,null,null,50,45,80,{"$f":"IF(COUNT(V11:Y11)=4,SUM(V11:Y11)-MIN(V11:Y11),SUM(V11:Y11))","v":95},100,null,195,7]
["Herman Kirste","Skien OK",null,null,30,20,60,110,11,80,190,null,null,40,20,80,{"$f":"IF(COUNT(L12:O12)=4,SUM(L12:O12)-MIN(L12:O12),SUM(L12:O12))","v":60},120,null,180,9,null,null,45,35,50,{"$f":"IF(COUNT(V12:Y12)=4,SUM(V12:Y12)-MIN(V12:Y12),SUM(V12:Y12))","v":80},90,null,170,9]
["Fredrik Moe","Sandefjord OK",50,45,10,40,30,135,7,70,205,50,80,100,20,100,{"$f":"IF(COUNT(L13:P13)>2,LARGE(L13:P13,1)+LARGE(L13:P13,2)+LARGE(L13:P13,3),SUM(L13:P13))","v":280},160,null,440,1,60,26,20,45,35,{"$f":"IF(COUNT(V13:Z13)>2,LARGE(V13:Z13,1)+LARGE(V13:Z13,2)+LARGE(V13:Z13,3),SUM(V13:Z13))","v":140},40,null,180,8]
["Ole Flaatten","OK Skeidi",80,null,50,45,35,175,4,60,235,100,null,35,60,26,195,52,null,247,6,45,null,20,22,30,97,44,null,141,10]
["Martin Sollie Nåtedal","OL Trollo",22,40,26,null,null,88,13,52,140,35,60,45,null,null,140,60,null,200,8,35,100,100,null,null,235,200,null,435,1]
["Simon Nysæter","Skien OK",20,null,35,null,null,55,17,44,99,22,null,20,null,null,42,40,null,82,14,20,null,20,null,null,40,52,null,92,15]
["Jarle Lysnes","Hedrum O-lag",26,30,100,20,null,156,6,null,156,30,26,60,45,null,135,null,null,135,10,80,80,60,80,null,240,null,null,240,4]
["Simen Åmodt Amundsen","Lardal O-lag",30,50,40,20,null,120,8,null,120,40,30,26,20,null,96,null,null,96,11,45,45,20,20,null,110,null,null,110,12]
["Øystein Fruseth Christiansen","OTO",40,null,20,60,null,120,8,null,120,45,null,20,30,null,95,null,null,95,12,20,null,20,20,null,60,null,null,60,18]
["Anders B Kristoffersen","Larvik OK",20,26,null,20,null,66,15,null,66,20,45,null,20,null,{"$f":"IF(COUNT(L20:O20)=4,SUM(L20:O20)-MIN(L20:O20),SUM(L20:O20))","v":85},null,null,85,13,22,80,null,35,null,{"$f":"IF(COUNT(V20:Y20)=4,SUM(V20:Y20)-MIN(V20:Y20),SUM(V20:Y20))","v":137},null,null,137,11]
["Jens Didrik Berg","Larvik OK",35,35,null,22,null,92,12,null,92,20,40,null,22,null,{"$f":"IF(COUNT(L21:P21)>2,LARGE(L21:P21,1)+LARGE(L21:P21,2)+LARGE(L21:P21,3),SUM(L21:P21))","v":82},null,null,82,14,35,45,null,20,null,{"$f":"IF(COUNT(V21:Z21)>2,LARGE(V21:Z21,1)+LARGE(V21:Z21,2)+LARGE(V21:Z21,3),SUM(V21:Z21))","v":100},null,null,100,13]
["Marius Lindvall","Larvik OK",20,null,20,20,null,60,16,null,60,20,null,20,20,null,{"$f":"IF(COUNT(L22:P22)>2,LARGE(L22:P22,1)+LARGE(L22:P22,2)+LARGE(L22:P22,3),SUM(L22:P22))","v":60},null,null,60,16,20,null,20,22,null,{"$f":"IF(COUNT(V22:Z22)>2,LARGE(V22:Z22,1)+LARGE(V22:Z22,2)+LARGE(V22:Z22,3),SUM(V22:Z22))","v":62},null,null,62,17]
["Bjørnar Brevik","Stokke",null,null,null,26,null,26,18,null,26,null,null,null,50,null,{"$f":"IF(COUNT(L23:O23)=4,SUM(L23:O23)-MIN(L23:O23),SUM(L23:O23))","v":50},null,null,50,17,null,null,null,100,null,{"$f":"IF(COUNT(V23:Y23)=4,SUM(V23:Y23)-MIN(V23:Y23),SUM(V23:Y23))","v":100},null,null,100,13]
["Vegard Landsverk","Skien OK",null,null,22,null,50,72,14,null,72,null,null,30,null,40,{"$f":"IF(COUNT(L24:O24)=4,SUM(L24:O24)-MIN(L24:O24),SUM(L24:O24))","v":30},null,null,30,19,null,null,35,null,60,{"$f":"IF(COUNT(V24:Y24)=4,SUM(V24:Y24)-MIN(V24:Y24),SUM(V24:Y24))","v":35},null,null,35,19]
["Petter Tobias Haugland Bettum","Stokke",null,null,null,20,null,20,19,null,20,null,null,null,26,null,{"$f":"IF(COUNT(L25:O25)=4,SUM(L25:O25)-MIN(L25:O25),SUM(L25:O25))","v":26},null,null,26,20,null,null,null,20,null,{"$f":"IF(COUNT(V25:Y25)=4,SUM(V25:Y25)-MIN(V25:Y25),SUM(V25:Y25))","v":20},null,null,20,21]
["Emil Brattbakk","OTO",null,null,20,null,null,20,19,null,20,null,null,20,null,null,{"$f":"IF(COUNT(L26:O26)=4,SUM(L26:O26)-MIN(L26:O26),SUM(L26:O26))","v":20},null,null,20,21,null,null,35,null,null,{"$f":"IF(COUNT(V26:Y26)=4,SUM(V26:Y26)-MIN(V26:Y26),SUM(V26:Y26))","v":35},null,null,35,19]
["Fredrik Polland","Skeidi",null,null,null,null,null,{"$f":"IF(COUNT(C27:F27)=4,SUM(C27:F27)-MIN(C27:F27),SUM(C27:F27))","v":0},{"$f":"IF(H27=0,0,RANK(H27,$H$7:$H$39))","v":0},40,40,null,null,null,null,null,{"$f":"IF(COUNT(L27:O27)=4,SUM(L27:O27)-MIN(L27:O27),SUM(L27:O27))","v":0},44,null,{"$f":"Q27+R27+S27","v":44},{"$f":"IF(T27=0,0,RANK(T27,$T$7:$T$39))","v":18},null,null,null,null,null,{"$f":"IF(COUNT(V27:Y27)=4,SUM(V27:Y27)-MIN(V27:Y27),SUM(V27:Y27))","v":0},90,null,{"$f":"AA27+AB27+AC27","v":90},{"$f":"IF(AD27=0,0,RANK(AD27,$AD$7:$AD$39))","v":16}]
[null,null,null,null,null,null,null,0,0,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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]