{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KPI","Tellere"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"KPI","index":0,"n_rows":50,"n_cols":24,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,3,4,18],[5,3,5,18],[0,16,0,19],[0,5,0,13],[0,14,0,15],[0,3,0,4],[48,1,48,6],[48,7,48,9],[46,7,46,9],[40,7,40,9],[41,7,41,9],[47,1,47,6],[47,7,47,9],[17,13,17,14],[17,11,17,12],[16,11,16,14],[17,6,17,7],[17,1,17,2],[17,3,17,4],[17,8,17,9],[16,6,16,9],[16,1,16,4],[43,7,43,9],[40,1,40,6],[41,1,41,6],[49,1,49,6],[49,7,49,9],[44,7,44,9],[45,7,45,9],[42,7,42,9],[45,1,45,6],[46,1,46,6],[42,1,42,6],[43,1,43,6],[44,1,44,6]]}
[null,null,null,"Navn:",null,null,null,null,null,null,null,null,null,null,"Profil:"]
[null,null,null,"Dato:______________________"]
[null,null,null,"KPI måling av prestasjon."]
[null,null,null,"Test gjøres foretrekksvis over 60 ruter men kan gjøres på kortre distanse. "]
[null,null,null,"Strikelomme for høyrehendte defineres som treff mellom kjegle 1 & 3 hvor kjegle 2 eller 6 ikke står kvar eller\n felles av en kjegle som spretter tilbake på kjeglebord.  "]
[null,null,null,"Strikelomme for venstrehendte defineres som treff mellom kjegle 1 & 2 hvor kjegle 3 eller 4 ikke står kvar eller felles av en kjegle som spretter tilbake på kjeglebord.  "]
[null,null,null,"Alle kast noteres i en av 2 kolonner, Strikelomme eller Øvrige kast."]
[null,null,null,"Resultat skrives inn på tradisjonell måte med kjeglefall på første og andrekast på riktig sted. Sparekast noteres selvfølgelig. "]
[null,null,null,"KPIer presenteres i % på følgende:"]
[null,null,null,null,"Strikelomme %"]
[null,null,null,null,"Strike % av kast i strikelomme."]
[null,null,null,null,"Fylte ruter %"]
[null,null,null,null,"% 9ere på kast som ikke er strike",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,"% spare på 9ere",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'''''''''''''''"]
[null,null,null,null,"% spare på øvrig kjeglefall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[]
[null,"Kast 1-20",null,null,null,null,"Kast 21-40",null,null,null,null,"Kast 41-60"]
[null,"Strikelomme",null,"Øvrig",null,null,"Strikelomme",null,"Øvrig",null,null,"Strikelomme",null,"Øvrig"]
[1,null,null,null,null,21,null,null,null,null,41]
[2,null,null,null,null,22,null,null,null,null,42]
[9,null,null,null,null,23,null,null,null,null,43]
["x",null,null,null,null,24,null,null,null,null,44]
["x",null,null,null,null,25,null,null,null,null,45]
[6,null,null,null,null,26,null,null,null,null,46]
[7,null,null,null,null,27,null,null,null,null,47]
[8,null,null,null,null,28,null,null,null,null,48]
[9,null,null,null,null,29,null,null,null,null,49]
[10,null,null,null,null,30,null,null,null,null,50]
[11,null,null,null,null,31,null,null,null,null,51]
[12,null,null,null,null,32,null,null,null,null,52]
[13,null,null,null,null,33,null,null,null,null,53]
[14,null,null,null,null,34,null,null,null,null,54]
[15,null,null,null,null,35,null,null,null,null,55]
[16,null,null,null,null,36,null,null,null,null,56]
[17,null,null,null,null,37,null,null,null,null,57]
[18,null,null,null,null,38,null,null,null,null,58]
[19,null,null,null,null,39,null,null,null,null,59]
[20,null,null,null,null,40,null,null,null,null,60]
[]
[null,"Resultat:"]
[null,"Strikelomme %: ",null,null,null,null,null,{"$f":"IFERROR(Tellere!B3/Tellere!B1,\"0\")","v":"0"}]
[null,"Strike % (lommetreff) :",null,null,null,null,null,{"$f":"IFERROR(Tellere!B4/Tellere!B3,\"0\")","v":"0"}]
[null,"Strike (Total) % :",null,null,null,null,null,{"$f":"IFERROR(Tellere!B10/Tellere!B1,\"0\")","v":"0"}]
[null,"Fylte Ruter % :",null,null,null,null,null,{"$f":"IFERROR(Tellere!B5/Tellere!B1,\"0\")","v":"0"}]
[null,"9ere % :",null,null,null,null,null,{"$f":"IFERROR(Tellere!B6/Tellere!B2,\"0\")","v":"0"}]
[null,"Spare på 9ere % :",null,null,null,null,null,{"$f":"IFERROR(Tellere!B7/Tellere!B6,\"0\")","v":"0"}]
[null,"Spare på øvrig %:",null,null,null,null,null,{"$f":"IFERROR(Tellere!B16/Tellere!B15,\"0\")","v":"0"}]
[null,"Spare% total",null,null,null,null,null,{"$f":"IFERROR(Tellere!B14/Tellere!B2,\"0\")","v":"0"}]
[null,"Gj.snitt kjeglefall 1.kast",null,null,null,null,null,{"$f":"IFERROR(Tellere!R22/Tellere!B1,0)","v":0}]
[null,"Antall 9'ere",null,null,null,null,null,{"$f":"Tellere!B6","v":0}]

{"sheet":"Tellere","index":1,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Antall kast",{"$f":"COUNTIF(I2:I21,\"<>0\")+COUNTIF(L2:L21,\"<>0\")+COUNTIF(O2:O21,\"<>0\")+B12","v":0},null,null,null,null,null,null,"1-20",null,null,"21-40",null,null,"41-20"]
["Antall kast som ikke er X",{"$f":"COUNTIFS(KPI!B19:B38,\">0\",KPI!B19:B38,\"<>X\")+COUNTIFS(KPI!D19:D38,\">0\",KPI!D19:D38,\"<>X\")+COUNTIFS(KPI!G19:G38,\">0\",KPI!G19:G38,\"<>X\")+COUNTIFS(KPI!I19:I38,\">0\",KPI!I19:I38,\"<>X\")+COUNTIFS(KPI!L19:L38,\">0\",KPI!L19:L38,\"<>X\")+COUNTIFS(KPI!N19:N38,\">0\",KPI!N19:N38,\"<>X\")","v":0},null,null,null,null,null,1,{"$f":"IF(OR(KPI!B19=\"X\",KPI!D19=\"X\"),10,MAX(KPI!B19:D19))","v":0},null,21,{"$f":"IF(OR(KPI!G19=\"X\",KPI!I19=\"X\"),10,MAX(KPI!G19:I19))","v":0},null,41,{"$f":"IF(OR(KPI!L19=\"X\",KPI!N19=\"X\"),10,MAX(KPI!L19:N19))","v":0}]
["Antall treff i lomma",{"$f":"COUNTIF(KPI!B19:B38,\">0\")+COUNTIF(KPI!B19:B38,\"X\")+COUNTIF(KPI!G19:G38,\">0\")+COUNTIF(KPI!G19:G38,\"X\")+COUNTIF(KPI!L19:L38,\">0\")+COUNTIF(KPI!L19:L38,\"X\")","v":0},null,null,null,null,null,2,{"$f":"IF(OR(KPI!B20=\"X\",KPI!D20=\"X\"),10,MAX(KPI!B20:D20))","v":0},null,22,{"$f":"IF(OR(KPI!G20=\"X\",KPI!I20=\"X\"),10,MAX(KPI!G20:I20))","v":0},null,42,{"$f":"IF(OR(KPI!L20=\"X\",KPI!N20=\"X\"),10,MAX(KPI!L20:N20))","v":0}]
["Antall strike i lomma",{"$f":"COUNTIF(KPI!B19:B38,\"X\")+COUNTIF(KPI!G19:G38,\"X\")+COUNTIF(KPI!L19:L38,\"X\")","v":0},null,null,null,null,null,3,{"$f":"IF(OR(KPI!B21=\"X\",KPI!D21=\"X\"),10,MAX(KPI!B21:D21))","v":0},null,23,{"$f":"IF(OR(KPI!G21=\"X\",KPI!I21=\"X\"),10,MAX(KPI!G21:I21))","v":0},null,43,{"$f":"IF(OR(KPI!L21=\"X\",KPI!N21=\"X\"),10,MAX(KPI!L21:N21))","v":0}]
["Antall fylte ruter",{"$f":"COUNTIF(KPI!B19:B38,\"X\")+COUNTIF(KPI!C19:C38,\"/\")+COUNTIF(KPI!D19:D38,\"X\")+COUNTIF(KPI!E19:E38,\"/\")+COUNTIF(KPI!G19:G38,\"X\")+COUNTIF(KPI!H19:H38,\"/\")+COUNTIF(KPI!I19:I38,\"X\")+COUNTIF(KPI!J19:J38,\"/\")+COUNTIF(KPI!L19:L38,\"X\")+COUNTIF(KPI!M19:M38,\"/\")+COUNTIF(KPI!N19:N38,\"X\")+COUNTIF(KPI!O19:O38,\"/\")","v":0},null,null,null,null,null,4,{"$f":"IF(OR(KPI!B22=\"X\",KPI!D22=\"X\"),10,MAX(KPI!B22:D22))","v":0},null,24,{"$f":"IF(OR(KPI!G22=\"X\",KPI!I22=\"X\"),10,MAX(KPI!G22:I22))","v":0},null,44,{"$f":"IF(OR(KPI!L22=\"X\",KPI!N22=\"X\"),10,MAX(KPI!L22:N22))","v":0}]
["Antall førstekast med 9",{"$f":"COUNTIF(KPI!B19:B38,\"9\")+COUNTIF(KPI!D19:D38,\"9\")+COUNTIF(KPI!G19:G38,\"9\")+COUNTIF(KPI!I19:I38,\"9\")+COUNTIF(KPI!L19:L38,\"9\")+COUNTIF(KPI!N19:N38,\"9\")","v":0},null,null,null,null,null,5,{"$f":"IF(OR(KPI!B23=\"X\",KPI!D23=\"X\"),10,MAX(KPI!B23:D23))","v":0},null,25,{"$f":"IF(OR(KPI!G23=\"X\",KPI!I23=\"X\"),10,MAX(KPI!G23:I23))","v":0},null,45,{"$f":"IF(OR(KPI!L23=\"X\",KPI!N23=\"X\"),10,MAX(KPI!L23:N23))","v":0}]
["Antall spare etter 9",{"$f":"COUNTIFS(KPI!B19:B38,\"9\",KPI!C19:C38,\"/\")+COUNTIFS(KPI!D19:D38,\"9\",KPI!E19:E38,\"/\")+COUNTIFS(KPI!G19:G38,\"9\",KPI!H19:H38,\"/\")+COUNTIFS(KPI!I19:I38,\"9\",KPI!J19:J38,\"/\")+COUNTIFS(KPI!L19:L38,\"9\",KPI!M19:M38,\"/\")+COUNTIFS(KPI!N19:N38,\"9\",KPI!O19:O38,\"/\")","v":0},null,null,null,null,null,6,{"$f":"IF(OR(KPI!B24=\"X\",KPI!D24=\"X\"),10,MAX(KPI!B24:D24))","v":0},null,26,{"$f":"IF(OR(KPI!G24=\"X\",KPI!I24=\"X\"),10,MAX(KPI!G24:I24))","v":0},null,46,{"$f":"IF(OR(KPI!L24=\"X\",KPI!N24=\"X\"),10,MAX(KPI!L24:N24))","v":0}]
["Antall øvrige",{"$f":"COUNTIF(KPI!D19:D38,\">0\")+COUNTIF(KPI!D19:D38,\"X\")+COUNTIF(KPI!I19:I38,\">0\")+COUNTIF(KPI!I19:I38,\"X\")+COUNTIF(KPI!N19:N38,\">0\")+COUNTIF(KPI!N19:N38,\"X\")","v":0},null,null,null,null,null,7,{"$f":"IF(OR(KPI!B25=\"X\",KPI!D25=\"X\"),10,MAX(KPI!B25:D25))","v":0},null,27,{"$f":"IF(OR(KPI!G25=\"X\",KPI!I25=\"X\"),10,MAX(KPI!G25:I25))","v":0},null,47,{"$f":"IF(OR(KPI!L25=\"X\",KPI!N25=\"X\"),10,MAX(KPI!L25:N25))","v":0}]
["Antall spare etter øvrig",{"$f":"COUNTIF(KPI!E19:E38,\"=/\")+COUNTIF(KPI!J19:J38,\"=/\")+COUNTIF(KPI!O19:O38,\"=/\")","v":0},null,null,null,null,null,8,{"$f":"IF(OR(KPI!B26=\"X\",KPI!D26=\"X\"),10,MAX(KPI!B26:D26))","v":0},null,28,{"$f":"IF(OR(KPI!G26=\"X\",KPI!I26=\"X\"),10,MAX(KPI!G26:I26))","v":0},null,48,{"$f":"IF(OR(KPI!L26=\"X\",KPI!N26=\"X\"),10,MAX(KPI!L26:N26))","v":0}]
["Totalt antall strike",{"$f":"COUNTIF(KPI!B19:B38,\"=X\")+COUNTIF(KPI!D19:D38,\"=X\")+COUNTIF(KPI!G19:G38,\"=X\")+COUNTIF(KPI!I19:I38,\"=X\")+COUNTIF(KPI!L19:L38,\"=X\")+COUNTIF(KPI!N19:N38,\"=X\")","v":0},null,null,null,null,null,9,{"$f":"IF(OR(KPI!B27=\"X\",KPI!D27=\"X\"),10,MAX(KPI!B27:D27))","v":0},null,29,{"$f":"IF(OR(KPI!G27=\"X\",KPI!I27=\"X\"),10,MAX(KPI!G27:I27))","v":0},null,49,{"$f":"IF(OR(KPI!L27=\"X\",KPI!N27=\"X\"),10,MAX(KPI!L27:N27))","v":0}]
["Antall øvrige ikke strike",{"$f":"COUNTIFS(KPI!D19:D38,\">0\",KPI!D19:D38,\"<>X\")+COUNTIFS(KPI!I19:I38,\">0\",KPI!I19:I38,\"<>X\")+COUNTIFS(KPI!N19:N38,\">0\",KPI!N19:N38,\"<>X\")+COUNTIF(KPI!D19:D38,\"=-\")+COUNTIF(KPI!I19:I38,\"=-\")+COUNTIF(KPI!N19:N38,\"=-\")","v":0},null,null,null,null,null,10,{"$f":"IF(OR(KPI!B28=\"X\",KPI!D28=\"X\"),10,MAX(KPI!B28:D28))","v":0},null,30,{"$f":"IF(OR(KPI!G28=\"X\",KPI!I28=\"X\"),10,MAX(KPI!G28:I28))","v":0},null,50,{"$f":"IF(OR(KPI!L28=\"X\",KPI!N28=\"X\"),10,MAX(KPI!L28:N28))","v":0}]
["Antall rennekast",{"$f":"COUNTIF(KPI!B19:B38,\"=-\")+COUNTIF(KPI!D19:D38,\"=-\")+COUNTIF(KPI!G19:G38,\"=-\")+COUNTIF(KPI!I19:I38,\"=-\")+COUNTIF(KPI!L19:L38,\"=-\")+COUNTIF(KPI!N19:N38,\"=-\")","v":0},null,null,null,null,null,11,{"$f":"IF(OR(KPI!B29=\"X\",KPI!D29=\"X\"),10,MAX(KPI!B29:D29))","v":0},null,31,{"$f":"IF(OR(KPI!G29=\"X\",KPI!I29=\"X\"),10,MAX(KPI!G29:I29))","v":0},null,51,{"$f":"IF(OR(KPI!L29=\"X\",KPI!N29=\"X\"),10,MAX(KPI!L29:N29))","v":0}]
["Antall øvrig under 9",{"$f":"COUNTIFS(KPI!D19:D38,\">0\",KPI!D19:D38,\"<9\")+COUNTIFS(KPI!I19:I38,\">0\",KPI!I19:I38,\"<9\")+COUNTIFS(KPI!N19:N38,\">0\",KPI!N19:N38,\"<9\")+COUNTIF(KPI!D19:D38,\"=-\")+COUNTIF(KPI!I19:I38,\"=-\")+COUNTIF(KPI!N19:N38,\"=-\")","v":0},null,null,null,null,null,12,{"$f":"IF(OR(KPI!B30=\"X\",KPI!D30=\"X\"),10,MAX(KPI!B30:D30))","v":0},null,32,{"$f":"IF(OR(KPI!G30=\"X\",KPI!I30=\"X\"),10,MAX(KPI!G30:I30))","v":0},null,52,{"$f":"IF(OR(KPI!L30=\"X\",KPI!N30=\"X\"),10,MAX(KPI!L30:N30))","v":0}]
["Antall spare",{"$f":"COUNTIF(KPI!C19:C38,\"=/\")+COUNTIF(KPI!E19:E38,\"=/\")+COUNTIF(KPI!H19:H38,\"=/\")+COUNTIF(KPI!J19:J38,\"=/\")+COUNTIF(KPI!M19:M38,\"=/\")+COUNTIF(KPI!O19:O38,\"=/\")","v":0},null,null,null,null,null,13,{"$f":"IF(OR(KPI!B31=\"X\",KPI!D31=\"X\"),10,MAX(KPI!B31:D31))","v":0},null,33,{"$f":"IF(OR(KPI!G31=\"X\",KPI!I31=\"X\"),10,MAX(KPI!G31:I31))","v":0},null,53,{"$f":"IF(OR(KPI!L31=\"X\",KPI!N31=\"X\"),10,MAX(KPI!L31:N31))","v":0}]
["Antall slag under 9",{"$f":"COUNTIF(KPI!B19:B38,\"<9\")+COUNTIF(KPI!D19:D38,\"<9\")+COUNTIF(KPI!G19:G38,\"<9\")+COUNTIF(KPI!I19:I38,\"<9\")+COUNTIF(KPI!L19:L38,\"<9\")+COUNTIF(KPI!N19:N38,\"<9\")","v":0},null,null,null,null,null,14,{"$f":"IF(OR(KPI!B32=\"X\",KPI!D32=\"X\"),10,MAX(KPI!B32:D32))","v":0},null,34,{"$f":"IF(OR(KPI!G32=\"X\",KPI!I32=\"X\"),10,MAX(KPI!G32:I32))","v":0},null,54,{"$f":"IF(OR(KPI!L32=\"X\",KPI!N32=\"X\"),10,MAX(KPI!L32:N32))","v":0}]
["Spare etter slag under 9",{"$f":"COUNTIFS(KPI!B19:B38,\"<9\",KPI!C19:C38,\"=/\")+COUNTIFS(KPI!D19:D38,\"<9\",KPI!E19:E38,\"=/\")+COUNTIFS(KPI!G19:G38,\"<9\",KPI!H19:H38,\"=/\")+COUNTIFS(KPI!I19:I38,\"<9\",KPI!J19:J38,\"=/\")+COUNTIFS(KPI!L19:L38,\"<9\",KPI!M19:M38,\"=/\")+COUNTIFS(KPI!N19:N38,\"<9\",KPI!O19:O38,\"=/\")","v":0},null,null,null,null,null,15,{"$f":"IF(OR(KPI!B33=\"X\",KPI!D33=\"X\"),10,MAX(KPI!B33:D33))","v":0},null,35,{"$f":"IF(OR(KPI!G33=\"X\",KPI!I33=\"X\"),10,MAX(KPI!G33:I33))","v":0},null,55,{"$f":"IF(OR(KPI!L33=\"X\",KPI!N33=\"X\"),10,MAX(KPI!L33:N33))","v":0}]
[null,null,null,null,null,null,null,16,{"$f":"IF(OR(KPI!B34=\"X\",KPI!D34=\"X\"),10,MAX(KPI!B34:D34))","v":0},null,36,{"$f":"IF(OR(KPI!G34=\"X\",KPI!I34=\"X\"),10,MAX(KPI!G34:I34))","v":0},null,56,{"$f":"IF(OR(KPI!L34=\"X\",KPI!N34=\"X\"),10,MAX(KPI!L34:N34))","v":0}]
[null,null,null,null,null,null,null,17,{"$f":"IF(OR(KPI!B35=\"X\",KPI!D35=\"X\"),10,MAX(KPI!B35:D35))","v":0},null,37,{"$f":"IF(OR(KPI!G35=\"X\",KPI!I35=\"X\"),10,MAX(KPI!G35:I35))","v":0},null,57,{"$f":"IF(OR(KPI!L35=\"X\",KPI!N35=\"X\"),10,MAX(KPI!L35:N35))","v":0}]
[null,null,null,null,null,null,null,18,{"$f":"IF(OR(KPI!B36=\"X\",KPI!D36=\"X\"),10,MAX(KPI!B36:D36))","v":0},null,38,{"$f":"IF(OR(KPI!G36=\"X\",KPI!I36=\"X\"),10,MAX(KPI!G36:I36))","v":0},null,58,{"$f":"IF(OR(KPI!L36=\"X\",KPI!N36=\"X\"),10,MAX(KPI!L36:N36))","v":0}]
[null,null,null,null,null,null,null,19,{"$f":"IF(OR(KPI!B37=\"X\",KPI!D37=\"X\"),10,MAX(KPI!B37:D37))","v":0},null,39,{"$f":"IF(OR(KPI!G37=\"X\",KPI!I37=\"X\"),10,MAX(KPI!G37:I37))","v":0},null,59,{"$f":"IF(OR(KPI!L37=\"X\",KPI!N37=\"X\"),10,MAX(KPI!L37:N37))","v":0}]
[null,null,null,null,null,null,null,20,{"$f":"IF(OR(KPI!B38=\"X\",KPI!D38=\"X\"),10,MAX(KPI!B38:D38))","v":0},null,40,{"$f":"IF(OR(KPI!G38=\"X\",KPI!I38=\"X\"),10,MAX(KPI!G38:I38))","v":0},null,60,{"$f":"IF(OR(KPI!L38=\"X\",KPI!N38=\"X\"),10,MAX(KPI!L38:N38))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I21)","v":0},null,null,{"$f":"SUM(L2:L21)","v":0},null,null,{"$f":"SUM(O2:O21)","v":0},null,"Total:",{"$f":"I22+L22+O22","v":0}]