{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Aufwand","Daten"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"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":"Tabelle1","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,1,3,9],[36,7,36,9],[38,7,38,9],[40,7,40,9],[43,6,43,7],[7,1,7,9],[8,1,8,9],[9,1,9,9]]}
[null,null,null,null,null,null,null,null,"VEMAGS:",null,{"$f":"IF(Daten!B11>0,Daten!B11,\"\")","v":""}]
[]
[]
[null,"Rechtsgrundlage:  Nummer 263.1.1 bzw. Nummer 263.1.2 der GebOSt"]
[]
[null,"Berechnungsformel:"]
[]
[null,"Gesamtgebühr = 40,00 Euro + Erhöhungsbetrag"]
[null,"Erhöhungsbetrag = 40,00 Euro · Gesamtfaktor"]
[null,"Gesamtfaktor = f(z) +  f(M) + f(B) + f(Str) + f(F) + f(MÜ) + f(A)"]
[]
[]
[null,"Einzelnenfaktoren:"]
[]
[null,"Faktor f(Z):",null,null,"Monate x:",{"$f":"IF(Daten!B1>0,Daten!B1,\"\")","v":""},null,null,null,"f(Z)=",{"$f":"IF(Daten!B1>0,IF(Daten!B1>3,IF(Daten!B1>12,IF(AND(Daten!B1<=36,Daten!B14=FALSE),ROUND((1/24)*Daten!B1+1.5,2),ROUND((1/24)*(Daten!B1-36)+4.5,2)),ROUND((1/9)*Daten!B1+(2/3),2)),ROUND(0.5*Daten!B1-0.5,2)),\"\")","v":""}]
[null,{"$f":"IF(Daten!B1>0,IF(Daten!B1>3,IF(Daten!B1>12,Daten!I1,Daten!G1),Daten!E1),\"\")","v":""},null,null,{"$f":"IF(Daten!B14=TRUE,\"LoF-Vorgang\",\"\")","v":""}]
[]
[null,"Faktor f(M):",null,null,"Masse x:",{"$f":"IF(Daten!B2>0,Daten!B2,\"\")","v":""},null,null,null,"f(M)=",{"$f":"IF(Daten!B2>0,IF(Daten!B2>200,ROUND((0.01)*Daten!B2+4,2),IF(Daten!B2<41.8,0,ROUND(0.037926675*Daten!B2-1.58533502,2))),\"\")","v":""}]
[null,{"$f":"IF(Daten!B2>0,IF(Daten!B2>200,Daten!G2,Daten!E2),\"\")","v":""}]
[]
[null,"Faktor f(B):",null,null,"Behörden x:",{"$f":"IF(Daten!B3>0,Daten!B3,\"\")","v":""},null,null,null,"f(B)=",{"$f":"IF(Daten!B3>0,ROUND((4/9)*Daten!B3-(4/9),2),\"\")","v":""}]
[null,{"$f":"IF(Daten!B3>0,\"f(B) = \" & TEXT(4/9,\"#/#\") & \" · x - \" & TEXT(4/9,\"#/#\"),\"\")","v":""}]
[]
[null,"Faktor f(Str):",null,null,"Strecken x:",{"$f":"IF(Daten!B4>0,Daten!B4,\"\")","v":""},null,null,null,"f(Str)=",{"$f":"IF(Daten!B4>0,(Daten!B4-1)/2,\"\")","v":""}]
[null,{"$f":"IF(Daten!B4>0,\"f(Str) = (x - 1) / 2\",\"\")","v":""}]
[]
[null,"Faktor f(F):",null,null,"Fahrzeuge x:",{"$f":"IF(Daten!B5>0,Daten!B5,\"\")","v":""},null,null,null,"f(F)=",{"$f":"IF(Daten!B5>0,ROUND((2/9)*Daten!B5-(2/9),2),\"\")","v":""}]
[null,{"$f":"IF(Daten!B5>0,\"f(F) = \" & TEXT(2/9,\"#/#\") & \" · x - \" & TEXT(2/9,\"#/#\"),\"\")","v":""}]
[]
[null,"Faktor f(MÜ):",null,null,"Übermaße:",{"$f":"IF(Daten!E7>0,Daten!E7,\"\")","v":""},null,null,null,"f(MÜ)=",{"$f":"IF(AND(Daten!E7=0,SUM(Daten!B7:B9)>0),0,IF(Daten!E7=1,2,IF(Daten!E7=2,4,IF(Daten!E7=3,6,\"\"))))","v":""}]
[null,{"$f":"IF(OR(Daten!B7=\"\",Daten!B8=\"\",Daten!B9=\"\"),\"\",IF(AND(Daten!B7>50,Daten!B8>4,Daten!B9>4.35),\"f(MÜ) = 6\",IF(OR(AND(Daten!B7>50,Daten!B8>4),AND(Daten!B7>50,Daten!B9>4.35),AND(Daten!B8>4,Daten!B9)),\"f(MÜ) = 4\",IF(OR(Daten!B7>50,Daten!B8>4,Daten!B9>4.35),\"f(MÜ) = 2\",\"\"))))","v":""}]
[]
[null,"Faktor f(A):",null,null,"Aufwand:",{"$f":"IF(Daten!B10>0,Daten!B10,\"\")","v":""},null,null,null,"f(A)=",{"$f":"IF(Daten!B10>0,IF(Daten!B10=\"Normal\",0,IF(Daten!B10=\"Erhöht\",1,IF(Daten!B10=\"Hoch\", 2,IF(Daten!B10=\"Sehr hoch\",3,IF(Daten!B10=\"Außergewöhnlich hoch\",4,\"\"))))),\"\")","v":""}]
[null,{"$f":"IF(Daten!B10>0,IF(Tabelle1!B10=\"Normal\",\"f(A) = 0\",IF(Daten!B10=\"Erhöht\",\"f(A) = 1\",IF(Daten!B10=\"Hoch\",\"f(A) = 2\",IF(Daten!B10=\"Sehr hoch\",\"f(A) = 3\",IF(Daten!B10=\"\",\"\",\"f(A) = 4\"))))),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,"Gesamtfaktor =",null,null,{"$f":"IF(OR(K15=\"\",K18=\"\",K21=\"\",K24=\"\",K27=\"\",K30=\"\",K33=\"\"),\"\",ROUND(SUM(K15:K33),2))","v":""}]
[]
[null,null,null,null,null,null,null,"Erhöhungsbetrag = ",null,null,{"$f":"IF(K37=\"\",\"\",40*K37)","v":""}]
[]
[null,null,null,null,null,null,null,"Gesamtgebühr =",null,null,{"$f":"IF(K39=\"\",\"\",IF(AND(Daten!B12=FALSE,Daten!B13=FALSE),IF(K39+40>1300,1300,K39+40),IF((K39+40)*0.75>1300,1300,(K39+40)*0.75)))","v":""},{"$f":"IF(K41>1,IF(K41=1300,\"*\",\"\"),\"\")","v":""}]
[]
[]
[null,"Datum:",{"$f":"TODAY()","v":"2020-12-15"},null,"Vorgangsnummer:",null,{"$f":"IF(Daten!B11>0,Daten!B11,\"\")","v":""}]
[null,"Uhrzeit:",{"$f":"NOW()","v":44180.626003240737},null,{"$f":"IF(K41>1,IF(K41=1300,\"*Gebühr überschreitet max. Gebühr, daher auf max. Gebühr angepasst\",\"\"),\"\")","v":""}]

{"sheet":"Aufwand","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,1,17,6],[1,1,1,6],[14,1,15,6]]}
[]
[null,{"$f":"IF(Daten!B11>0,\"VEMAGS-Vorgangsnummer:\" & Daten!B11,\"VEMAGS-Vorgang\")","v":"VEMAGS-Vorgang"}]
[null,"Aufwand","normal","erhöht","hoch","sehr hoch","außergewöhnlich hoch"]
[null,"aa)"]
[null,"bb)",{"$f":"IF(COUNTIF(C6:C8,\"ja\")=3,\"x\",\"\")","v":""},null,{"$f":"IF(AND(COUNTIF(E6:E8,\"ja\")=1,COUNTIF(F6:G8,\"ja\")=0,COUNTIF(E6:E8,\"ja\")<>3),\"x\",\"\")","v":""},{"$f":"IF(AND(COUNTIF(G6:G8,\"ja\")=0,OR(COUNTIF(F6:F8,\"ja\")=1,COUNTIF(E6:E8,\"ja\")>=2)),\"x\",\"\")","v":""},{"$f":"IF(OR(COUNTIF(F6:F8,\"ja\")>=2,COUNTIF(G6:G8,\"ja\")>1),\"x\",\"\")","v":""}]
[]
[]
[]
[null,"cc)"]
[null,"dd)"]
[null,"ee)"]
[null,null,null,null,null,"Ergebnis:",{"$f":"IF(COUNTIF(G4:G11,\"x\")>0,\"außergewöhnlich hoch\",IF(AND(COUNTIF(G4:G11,\"x\")=0,COUNTIF(F4:F11,\"x\")>0),\"sehr hoch\",IF(AND(COUNTIF(F4:G11,\"x\")=0,COUNTIF(E4:E11,\"x\")>0),\"hoch\",IF(AND(COUNTIF(E4:G11,\"x\")=0,COUNTIF(D4:D11,\"x\")>0),\"erhöht\",IF(AND(COUNTIF(D4:G11,\"x\")=0,COUNTIF(C4:C11,\"x\")>0),\"normal\",\"\")))))","v":""}]
[]
[null,null,null,null,null,"Abweichung:"]
[]
[]
[]
[null,"Legende gem. Anhang der GebOSt"]
[null,"Aufwand","normal","erhöht","hoch","sehr hoch","außergewöhnlich hoch"]
[null,"aa)","VEMAGS-Antrag","-","Nicht-VEMAGS Antrag","-","-"]
[null,"bb)","keine Rückfragen","-","1-2 Rückfragen","3-4 Rückfragen","5-6 Rückfragen"]
[null,null,"keine Änderung","-","1-2 Änderungen","3-4 Änderungen","5-6 Änderungen"]
[null,null,"keine Ergänzungen","-","1-2 Ergänzungen","3-4 Ergänzungen","5-6 Ergänzungen"]
[null,"cc)","Präzise","-","Streckenpräzisierung","Fahrwegsänderung","Streckenprotokoll"]
[null,"dd)","anhörfrei","Anhörverfahren ohne neue Anhörung","1-2 neue Anhörung durch Änderungen erforderlich","3-4 neue Anhörungen durch Änderungen erforderlich","-"]
[null,"ee)","anhörfrei","Anhörverfahren ohne neue Anhörung","Bescheid hat eine Fahrwegsänderung","einarbeiten von Rückfragen und mehreren Fahrwegsänderungen","zusätzlich zum Einarbeiten kommen noch weitere VAO dazu"]

{"sheet":"Daten","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Anzahl der Monate",null,null,"bei 1-3 Monaten","f(Z) = 0,5 · x - 0,5","bei 3-12 Monaten",{"$f":"\"f(Z) = \" & TEXT((1/9),\"#/#\") & \" · x + \" & TEXT((2/3),\"#/#\")","v":"f(Z) = 1/9 · x + 2/3"},"bei 12-36 Monaten",{"$f":"\"f(Z) = \" & TEXT((1/24),\"#/##\") & \" · x + 1,5\"","v":"f(Z) = 1/24 · x + 1,5"}]
["Gesamtmasse",null,null,"bei 41,8 t - 200 t","f(M) = 0,037926675 · x - 1,58533502","bei mehr als 200 t","f(M) = 0,01 · x + 4"]
["Anzahl der beteiligten Stellen"]
["Anzahl der Strecken"]
["Anzahl Fahrzeuge/Fahrzeugkombinationen"]
["Anzahl Maßüberschreitungen"]
["Gesamtlänge",null,null,{"$f":"IF(B7>50,1,\"\")","v":""},{"$f":"IF(D7:D9<1,0,SUM(D7:D9))","v":0}]
["Gesamtbreite",null,null,{"$f":"IF(B8>4,1,\"\")","v":""}]
["Gesamthöhe",null,null,{"$f":"IF(B9>4.35,1,\"\")","v":""}]
["Zusätzlicher Arbeitsaufwand",{"$f":"IF(Aufwand!G14=\"\",Aufwand!G12,Aufwand!G14)","v":""}]
["VEMAGS-Nummer"]
["wesentliche Änderung",null,null,{"$f":"IF(B12=TRUE,\"Änderung\",\"\")","v":""}]
["Ablehnung",null,null,{"$f":"IF(B13=TRUE,\"Ablehnung\",\"\")","v":""}]
["LoF"]