{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Anleitung","80 m","2 m"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":"Anleitung","index":0,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Hallo Fuchsjagd-Freunde,"]
[]
[null,"Habt ihr bisher eure Abrechnung bei der Fuchsjagd mit Bleistift und Papier gemacht? Euch vielleicht sogar dabei verrechnet? Das Problem hatte ich auch, und deshalb habe ich eine kleine Excel-Tabelle angelegt, die das Auslosen der Startgruppen, das Rechnen und Sortieren erledigt. Leider reichen meine Excel-Kenntnisse nicht, um alles zu perfektionieren, aber es sollte auch so funktionieren."]
[null,"Es ist keine ausgereifte Software, und Fehleingaben werden somit nicht alle abgefangen. Die Formelfelder sind nur durch eine Gültigkeitsprüfung (niemand tippt freiwillig \"gnilpf\" in ein Feld ein, hi!) gegen versehentliche Eingaben geschützt. Normalerweise sollte es also nicht möglich sein, die Formeln zu überschreiben, aber: Man weiß ja nie ;-). \nHier eine kleine Anleitung, wie die Tabellen zu behandeln sind."]
[]
["1.","Klickt je nach Art der Fuchsjagd auf den Registerreiter 80 m oder 2 m."]
[]
["2.","Grundsätzlich: NICHT IN DIE GELBEN UND SCHWARZEN FELDER TIPPEN! \nGrund: Die Einträge darin werden durch Formeln ermittelt."]
[]
["3.","Die in den lachsfarbenen bzw. hellblauen Feldern eingetragenen Teilnehmerdaten aus einer anderen Fuchsjagd markieren und mit der Entf-Taste löschen."]
[]
["4.","Tragt Namen, Rufzeichen sowie den DOK und die Startzeit in die rosafarbenen bzw. hellblauen Felder ein. Die Startzeit wird im Format \"hh:mm\" erwartet, also mit Doppelpunkt nach der Stundenangabe.."]
[]
["5.","Oben rechts in der Tabelle tragt ihr die Limitzeit ein. Das sind zum Beispiel 120 Minuten. Die \"Minuten\" werden automatich hinzugefügt. Hier darf keine Uhrzeit stehen, denn die Starter gehen ja zeitversetzt los."]
[]
["6.","Auf Wunsch kann die Tabell automatisch für alle Starter Startgruppen auslosen. Die Zahl der Starter bekommt die Tabelle noch allein auf die Reihe, aber ihr müsst ins gelbe Feld \"Starter pro Gruppe\" eintragen, wie viele Läufer ihr zugleich losschicken wollt. Wenn alle angemeldet sind, startet ihr das Auslosen per Klick auf den Button \"Startgruppen auslosen\". Die Startgruppe wird automatisch daraufhin in die entsprechende Spalte kopiert. Das Losen könnt ihr beliebig wiederholen, bis das Ergebnis euch gefällt. Wenn ihr nur einzelne Läufer anders zuordnen wollt, dann überschreibt die ensprechenden Felder einfach."]
[]
["7.","Tragt nun die Startzeiten in das Feld \"Startzeit\" ein. Am besten, ihr tut das erst unmittelbar, bevor ihr die Läufer aufruft. Denn dann habt ihr auch den Überblick, wer noch am Start wartet. Am schnellsten geht es, wenn ihr nur eine Startzeit (also: \"10:00\") eintippt und diese dann mit STRG-C und STRG-V in die entsprechendenn Felder der gleichen Startgruppe kopiert."]
[]
["8.","Solange die Läufer noch unterwegs sind, wird im Feld \"Laufzeit\" eine Reihe von Lattenzäunen angezeigt: \"###########\". Sobald ein Läufer wieder im Ziel eingetrudelt ist, tragt ihr die Zahl der gefundenen Sender  ins zugehörige Feld \"Sender\" und die Ankunftszeit ins Feld \"Zielzeit\" ein. Daraufhin erscheint im gelb eingefärbten Bereich seine Laufzeit in Stunden, Minuten und Sekunden (hh:mm:ss).."]
[]
["9.","Die Liste lässt sich mit einem Klick auf \"Sortieren\" jederzeit sortieren, auch wenn noch nicht alle Läufer im Ziel sind."]
[]
["10.","Die Ergebnisliste berücksichtigt automatisch zwei gleiche Laufzeiten. Sie vergibt dann zwei gleiche Plätze und erhöht den nachfolgenden Platz um eine Platzziffer. Auf noch mehr gleiche Zeiten habe ich es noch nicht erweitert. Ergebnisse außer der Wertung werden zwar mit Platzziffer, aber rot hinterlegt angezeigt."]
[]
[null,"Für Anregungen und bitte auch Verbesserungsvorschläge von besseren Excel-Kennern wäre ich dankbar, viel Spaß bei eurer Fuchsjagd wünscht"]
[null,"Michael, DK7EO"]
[]
[null,"(ksmichel@web.de)"]
[null,"www.dk7eo.de"]
[]
[null,"Diese Excel-Mappe darf beliebig weitergegeben werden."]
[]
["Versionen"]
["Version 0.1","max. 100 Teilnehmer"]
["Version 0.2","Limitzeit nun in Minuten\nStartzeit wird ohne Sekundenangabe angezeigt\nStartgruppenauslosung auf Wunsch"]
["Version 0.21","Nach Startgruppenauslosung werden die Namen entsprechend sortiert"]

{"sheet":"80 m","index":1,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Platz","Name","Rufzeichen","DOK","Start-\ngruppe","Startzeit\n[10:00]","Zielzeit\n[10:00:00]","Sender\n[5]","Laufzeit\n[hh:mm:ss]","noch in \nWertung?","Limitzeit=\n[min]",120,"Kontrollfeld:",{"$f":"ADDRESS(L4+1,18)","v":"$R$1"},null,"Startnummer","Gruppe","Zufallszahl"]
[1,null,null,null,null,null,null,null,{"$f":"ROUND(G2-F2,6)","v":"00:00:00"},{"$f":"IF(OR(I2=0,G2=0),\"zz \",IF(60*60*ROUND(HOUR(G2-F2),2)+60*ROUND(MINUTE(G2-F2),2)+ROUND(SECOND(G2-F2),2)<=60*$L$1,IF(H2=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},"Anzahl der Startgruppen",{"$f":"IF(L3=\"\",\"EINGABE FEHLT!\",ROUNDUP((L4/L3),0))","v":0},null,null,null,{"$f":"RANK(R2,R$2:INDIRECT($N$1),-1)","v":1},{"$f":"IF(ISNA(P2),\"\",ROUNDUP((P2*(($L$2)/($L$4))),0))","v":{"$error":"#DIV/0!"}},{"$f":"RAND()","v":0.34296894545725998}]
[{"$f":"IF(ISBLANK(B3),\"\",IF(AND((I3=I2),(H3=H2)),A2,IF(A2=A1,A2+2,A2+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ","Starter pro Gruppe=",3,null,null,null,{"$f":"RANK(R3,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.3618938580832437]
["",null,null,null,"",null,null,null,"00:00:00","zz ","Anzahl der Starter",{"$f":"COUNTA(B2:B101)","v":0},null,null,null,{"$f":"RANK(R4,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.22655194474033058]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R5,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.23957811400108797]
["",null,null,null,"",null,null,null,"00:00:00","zz ","Vor dem Start:",null,null,null,null,{"$f":"RANK(R6,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.40605758023486216]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R7,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.14844092196085479]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R8,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.99784783084835327]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R9,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",9.2870108393219963E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R10,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.71130470335435836]
["",null,null,null,"",null,null,null,"00:00:00","zz ","Nach dem ersten Rückkehrer:",null,null,null,null,{"$f":"RANK(R11,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.1420611327611683E-3]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R12,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",9.4889126385751754E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R13,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.59463568002676359]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R14,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.62791433405877883]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R15,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.49255676456002795]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R16,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P16),\"\",ROUNDUP((P16*(($L$2)/($L$4))),0))","v":""},0.52388126549070235]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R17,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P17),\"\",ROUNDUP((P17*(($L$2)/($L$4))),0))","v":""},0.16686976431688083]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R18,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.4453312921257897E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R19,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.45689288965928587]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R20,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.42422376676790619]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R21,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.7956631280448847]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R22,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.23926036951605179]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R23,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.12359287895968762]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R24,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.22152596319083162]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R25,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.78516464594104673]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R26,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.81973494933013824]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R27,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.80611004848680623]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R28,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.66502307486048928]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R29,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.74989133966288801]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R30,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.43409513604612548]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R31,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.55167810722933974]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R32,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.97663113147225389]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R33,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.28652789801105127]
["",null,null,null,"",null,null,null,{"$f":"ROUND(G34-F34,6)","v":"00:00:00"},{"$f":"IF(OR(I34=0,G34=0),\"zz \",IF(60*60*ROUND(HOUR(G34-F34),2)+60*ROUND(MINUTE(G34-F34),2)+ROUND(SECOND(G34-F34),2)<=60*$L$1,IF(H34=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R34,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",{"$f":"RAND()","v":0.25794287240306313}]
[{"$f":"IF(ISBLANK(B35),\"\",IF(AND((I35=I34),(H35=H34)),A34,IF(A34=A33,A34+2,A34+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R35,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.31144052579701653]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R36,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",4.6334840221654905E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R37,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.81836333911297332]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R38,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.88012073472567931]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R39,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",6.680294946450871E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R40,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.73350827196851498]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R41,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.10826834466394564]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R42,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.58232197726842638]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R43,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.27122142852640585]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R44,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.54358732879219807]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R45,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.59604547132573515]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R46,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.68917393689059148]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R47,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.71299972423489599]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R48,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.15943553826179402]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R49,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.94363420408562504]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R50,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.48503322277176719]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R51,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.80773574920253111]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R52,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.97106457557123327]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R53,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.28611098610852603]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R54,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.77728146692182654]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R55,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.41137645511617549]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R56,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.63667173305682057]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R57,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.21929044548260468]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R58,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.69619599871514348]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R59,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.3408973874360125]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R60,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.29498885500476058]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R61,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.11092288290917429]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R62,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.26447936337840494]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R63,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.73526053970813976]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R64,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.32154122358644421]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R65,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.77113491446245996]
["",null,null,null,"",null,null,null,{"$f":"ROUND(G66-F66,6)","v":"00:00:00"},{"$f":"IF(OR(I66=0,G66=0),\"zz \",IF(60*60*ROUND(HOUR(G66-F66),2)+60*ROUND(MINUTE(G66-F66),2)+ROUND(SECOND(G66-F66),2)<=60*$L$1,IF(H66=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R66,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",{"$f":"RAND()","v":0.10601570077114608}]
[{"$f":"IF(ISBLANK(B67),\"\",IF(AND((I67=I66),(H67=H66)),A66,IF(A66=A65,A66+2,A66+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R67,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",8.196318295098115E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R68,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.13477999346543978]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R69,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.56442819588462934]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R70,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.5572743141319727]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R71,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.18610367196982258]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R72,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.5330641457217109]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R73,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.12366637558686444]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R74,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",1.4920975022615357E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R75,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",9.0162943740754842E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R76,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.51590276447942707]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R77,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.88023824044445009]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R78,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.46309494475684287]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R79,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.22896549132713762]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R80,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.24956397952019593]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R81,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P81),\"\",ROUNDUP((P81*(($L$2)/($L$4))),0))","v":""},0.19724009329915193]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R82,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.59686674788499416]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R83,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.18908007739550303]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R84,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.90618082676765521]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R85,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.42290817816139858]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R86,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.3697366604414245]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R87,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.39020235737878817]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R88,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",6.5615354119082703E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R89,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.48254856327205919]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R90,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.74248784572759141]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R91,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.56244270680737418]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R92,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.99773370161167152]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R93,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.11939379761700974]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R94,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.96056790916072099]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R95,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.45789876902694227]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R96,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.60570345297537476]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R97,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.8379868336307168E-2]
["",null,null,null,"",null,null,null,"00:00:00",{"$f":"IF(OR(I98=0,G98=0),\"zz \",IF(60*60*ROUND(HOUR(G98-F98),2)+60*ROUND(MINUTE(G98-F98),2)+ROUND(SECOND(G98-F98),2)<=60*$L$1,IF(H98=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R98,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.6574500084641395E-2]
[{"$f":"IF(ISBLANK(B99),\"\",IF(AND((I99=I98),(H99=H98)),A98,IF(A98=A97,A98+2,A98+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R99,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.45808562211814852]
[{"$f":"IF(ISBLANK(B100),\"\",IF(AND((I100=I99),(H100=H99)),A99,IF(A99=A98,A99+2,A99+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R100,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.97210085922183986]
[{"$f":"IF(ISBLANK(B101),\"\",IF(AND((I101=I100),(H101=H100)),A100,IF(A100=A99,A100+2,A100+1)))","v":""},null,null,null,"",null,null,null,null,"zz ",null,null,null,null,null,{"$f":"RANK(R101,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.69928746943552822]

{"sheet":"2 m","index":2,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Platz","Name","Rufzeichen","DOK","Start-\ngruppe","Startzeit\n[10:00]","Zielzeit\n[10:00:00]","Sender\n[5]","Laufzeit\n[hh:mm:ss]","noch in \nWertung?","Limitzeit=\n[min]",120,"Kontrollfeld:",{"$f":"ADDRESS(L4+1,18)","v":"$R$1"},null,"Startnummer","Gruppe","Zufallszahl"]
[1,null,null,null,null,null,null,null,{"$f":"ROUND(G2-F2,6)","v":"00:00:00"},{"$f":"IF(OR(I2=0,G2=0),\"zz \",IF(60*60*ROUND(HOUR(G2-F2),2)+60*ROUND(MINUTE(G2-F2),2)+ROUND(SECOND(G2-F2),2)<=60*$L$1,IF(H2=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},"Anzahl der Startgruppen",{"$f":"IF(L3=\"\",\"EINGABE FEHLT!\",ROUNDUP((L4/L3),0))","v":0},null,null,null,{"$f":"RANK(R2,R$2:INDIRECT($N$1),-1)","v":1},{"$f":"IF(ISNA(P2),\"\",ROUNDUP((P2*(($L$2)/($L$4))),0))","v":{"$error":"#DIV/0!"}},{"$f":"RAND()","v":0.5687567442952397}]
[{"$f":"IF(ISBLANK(B3),\"\",IF(AND((I3=I2),(H3=H2)),A2,IF(A2=A1,A2+2,A2+1)))","v":""},null,null,null,null,null,null,null,"00:00:00","zz ","Starter pro Gruppe=",3,null,null,null,{"$f":"RANK(R3,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.62459545311204523]
["",null,null,null,null,null,null,null,"00:00:00","zz ","Anzahl der Starter",{"$f":"COUNTA(B2:B101)","v":0},null,null,null,{"$f":"RANK(R4,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.26671353311847368]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R5,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.16502141107580126]
["",null,null,null,null,null,null,null,"00:00:00","zz ","Vor dem Start:",null,null,null,null,{"$f":"RANK(R6,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.60738495082449762]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R7,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.37975044603682284]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R8,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.10787023733679091]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R9,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.3337604307117632]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R10,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.9027850044020798E-2]
["",null,null,null,null,null,null,null,"00:00:00","zz ","Nach dem ersten Rückkehrer:",null,null,null,null,{"$f":"RANK(R11,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.6452837258030546]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R12,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.48486625234827319]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R13,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.71254914292007054]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R14,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.98843331353920305]
["",null,null,null,null,null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R15,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.76723706353736354]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R16,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.52136797747955999]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R17,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.90490362847589023]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R18,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.20044198767471699]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R19,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.67344536646760866]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R20,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.82963932361320036]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R21,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.57128254480131735]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R22,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.71581333043987028]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R23,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.84191980175477077]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R24,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.52740940360446975]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R25,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.20899475312582383]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R26,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",2.9999282636608227E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R27,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.18658961321664636]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R28,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.1764621492327757]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R29,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.77599145979264672]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R30,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.19319987958830498]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R31,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.55066538439273838]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R32,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.99214398310213625]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R33,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.90101302575594744]
["",null,null,null,"",null,null,null,{"$f":"ROUND(G34-F34,6)","v":"00:00:00"},{"$f":"IF(OR(I34=0,G34=0),\"zz \",IF(60*60*ROUND(HOUR(G34-F34),2)+60*ROUND(MINUTE(G34-F34),2)+ROUND(SECOND(G34-F34),2)<=60*$L$1,IF(H34=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R34,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P34),\"\",ROUNDUP((P34*(($L$2)/($L$4))),0))","v":""},{"$f":"RAND()","v":0.23397378358733412}]
[{"$f":"IF(ISBLANK(B35),\"\",IF(AND((I35=I34),(H35=H34)),A34,IF(A34=A33,A34+2,A34+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R35,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.53367878432559279]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R36,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.44373023390530819]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R37,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.41291773671963206]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R38,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.44963649155012353]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R39,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.29855759945354987]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R40,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.37955953309379187]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R41,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.67183098865602164]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R42,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",1.3959916470099643E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R43,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.90121599523313811]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R44,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.65834803758145555]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R45,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",7.0632157131992335E-3]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R46,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.60171145476306398]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R47,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",9.3953894040095798E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R48,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.7117577312934692]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R49,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.91695060014785945]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R50,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.84682306129149598]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R51,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.34847215904895168]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R52,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.24637925483667233]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R53,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.93797493499047691]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R54,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.44149378011735618]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R55,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.33766408711653639]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R56,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.98609603769486487]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R57,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.22402259189869167]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R58,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.81958749570614342]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R59,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.35460408764117368]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R60,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.39165573572483292]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R61,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.63685487053687118]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R62,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.98519201688224667]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R63,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.225318263929561]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R64,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.50258619638275193]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R65,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.47831660771237239]
["",null,null,null,"",null,null,null,{"$f":"ROUND(G66-F66,6)","v":"00:00:00"},{"$f":"IF(OR(I66=0,G66=0),\"zz \",IF(60*60*ROUND(HOUR(G66-F66),2)+60*ROUND(MINUTE(G66-F66),2)+ROUND(SECOND(G66-F66),2)<=60*$L$1,IF(H66=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R66,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P66),\"\",ROUNDUP((P66*(($L$2)/($L$4))),0))","v":""},{"$f":"RAND()","v":0.60116198193198989}]
[{"$f":"IF(ISBLANK(B67),\"\",IF(AND((I67=I66),(H67=H66)),A66,IF(A66=A65,A66+2,A66+1)))","v":""},null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R67,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.32997923139095209]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R68,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.74825449993903559]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R69,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.89263718365630573]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R70,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.19400139831215635]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R71,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.20153710298266792]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R72,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.99509143413932266]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R73,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.3040410854308806]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R74,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.24618538522916633]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R75,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.92539843234568431]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R76,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.88218587155025086]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R77,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.28277854550309045]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R78,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.76119193944168662]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R79,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.38193998492388492]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R80,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.96242524483125502]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R81,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.72657309617724242]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R82,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",8.3771825315080983E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R83,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.37073326969644071]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R84,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.55600940795578258]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R85,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.73053493354813515]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R86,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.88889876979657034]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R87,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.82698639093873139]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R88,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.5115545200620919]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R89,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",9.7720126498097581E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R90,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.8335424666982334]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R91,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.39027215234832602]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R92,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",4.2949223003675097E-2]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R93,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.62338828302616589]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R94,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.17509354589348713]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R95,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.44051313642185608]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R96,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.92193691952952606]
["",null,null,null,"",null,null,null,"00:00:00","zz ",null,null,null,null,null,{"$f":"RANK(R97,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},"",0.53075737140972268]
["",null,null,null,"",null,null,null,"00:00:00",{"$f":"IF(OR(I98=0,G98=0),\"zz \",IF(60*60*ROUND(HOUR(G98-F98),2)+60*ROUND(MINUTE(G98-F98),2)+ROUND(SECOND(G98-F98),2)<=60*$L$1,IF(H98=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R98,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P98),\"\",ROUNDUP((P98*(($L$2)/($L$4))),0))","v":""},0.22742170616471313]
[{"$f":"IF(ISBLANK(B99),\"\",IF(AND((I99=I98),(H99=H98)),A98,IF(A98=A97,A98+2,A98+1)))","v":""},null,null,null,"",null,null,null,"00:00:00",{"$f":"IF(OR(I99=0,G99=0),\"zz \",IF(60*60*ROUND(HOUR(G99-F99),2)+60*ROUND(MINUTE(G99-F99),2)+ROUND(SECOND(G99-F99),2)<=60*$L$1,IF(H99=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R99,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P99),\"\",ROUNDUP((P99*(($L$2)/($L$4))),0))","v":""},0.58914189482288259]
[{"$f":"IF(ISBLANK(B100),\"\",IF(AND((I100=I99),(H100=H99)),A99,IF(A99=A98,A99+2,A99+1)))","v":""},null,null,null,"",null,null,null,"00:00:00",{"$f":"IF(OR(I100=0,G100=0),\"zz \",IF(60*60*ROUND(HOUR(G100-F100),2)+60*ROUND(MINUTE(G100-F100),2)+ROUND(SECOND(G100-F100),2)<=60*$L$1,IF(H100=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R100,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P100),\"\",ROUNDUP((P100*(($L$2)/($L$4))),0))","v":""},0.16270635193351213]
[{"$f":"IF(ISBLANK(B101),\"\",IF(AND((I101=I100),(H101=H100)),A100,IF(A100=A99,A100+2,A100+1)))","v":""},null,null,null,"",null,null,null,null,{"$f":"IF(OR(I101=0,G101=0),\"zz \",IF(60*60*ROUND(HOUR(G101-F101),2)+60*ROUND(MINUTE(G101-F101),2)+ROUND(SECOND(G101-F101),2)<=60*$L$1,IF(H101=0,\"keine Sender\",\"\"),\"Zeitüberschreitung \"))","v":"zz "},null,null,null,null,null,{"$f":"RANK(R101,R$2:INDIRECT($N$1),-1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P101),\"\",ROUNDUP((P101*(($L$2)/($L$4))),0))","v":""},0.91555215306879645]