{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vorblatt","ErmBg 01","datSQL"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":186,"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":"Vorblatt","index":0,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"david"]

{"sheet":"ErmBg 01","index":1,"n_rows":17,"n_cols":38,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,36,7,36],[4,30,7,30],[4,31,7,31],[4,32,7,32],[4,33,7,33],[4,34,7,34],[4,35,7,35],[4,29,7,29],[4,18,7,18],[4,19,7,19],[4,20,7,20],[4,21,7,21],[4,22,7,22],[4,23,7,23],[4,24,7,24],[4,25,7,25],[4,26,7,26],[4,27,7,27],[4,28,7,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"Ermittlungsbogen 01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinweis: ErmBg 02 ist der Muster-ErmBg"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"listcolumnname(S12)","v":{"$error":"#NAME?"}},{"$f":"listcolumnname(T12)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[]
[null,"Regelmäßige Hauptlauftransporte durchführen"]
[]
[]
[null,"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0104 - 02","H","G",34832.909710648149,34832.986111111109,110,null,null,null,136,74.181818181818002,"Mo/Di-Fr/Sa",5,100,0,0,110,{"$f":"Tabelle_Abfrage_von_Excel_Files2[[#This Row],[''AnzAbl'']]*Tabelle_Abfrage_von_Excel_Files2[[#This Row],[Bedienwahrscheinlichkeit (%)_Plan]]/100*ZS_PAblSt_bedienen*6/(1.02*1.009)","v":{"$error":"#REF!"}},{"$f":"Tabelle_Abfrage_von_Excel_Files2[[#This Row],[''AnzBfK'']]*ZS_BfK_leeren*6/(1.02*1.009)","v":{"$error":"#REF!"}}]
[]
[null,"1 Summe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(O11:O13),1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"übertragen in ErmBg 05, Z. 4"]
[]
[null,"übertragen in ErhBg, Sp. i unter OZ",null,null,null,null,null,null,null,null,null,null,null,null,1100]

{"sheet":"datSQL","index":2,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["SQL","Die Felder sind entweder hart kodiert, werden beim Datenimport oder KrGr-Wechsel gesetzt oder aus den vorhandenen berechnet."]
[]
["Excel-Name","Wert"]
[]
["Stammdaten","Die Stammdaten werden beim Datemimport gesetzt und beim Löschen der Datenanbindung gelöscht. (Gesamtbereich sqlStammdaten)"]
["sqlDatenTouren"]
["sqlTabelleTouren"]
["sqlDatumTransporte"]
["sqlDatenDienstkarten"]
["sqlTabelleDienstkarten"]
["sqlDatumDienstkarten"]
["sqlNLOZ"]
["sqlStand"]
["sqlZeilen"]
[]
["gdZSID",{"$f":"IF(ISBLANK(gdKrGr),0,VLOOKUP(gdKrGr,#REF!,2,FALSE))","v":{"$error":"#REF!"}}]
["gdKrGrFürSql",{"$f":"IF(ISBLANK(gdKrGr),\"#\",gdKrGr)","v":{"$error":"#REF!"}}]
[]
["ConnectionTouren",{"$f":"\"ODBC;DSN=Excel Files;DBQ=\"&sqlDatenTouren&\";DefaultDir=\"&sqlDatenTouren&\";DriverId=1046;MaxBufferSize=2048;PageTimeout=5;\"","v":"ODBC;DSN=Excel Files;DBQ=;DefaultDir=;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;"}]
["ConnectionDK",{"$f":"\"ODBC;DSN=Excel Files;DBQ=\"&sqlDatenDienstkarten&\";DefaultDir=\"&sqlDatenDienstkarten&\";DriverId=1046;MaxBufferSize=2048;PageTimeout=5;\"","v":"ODBC;DSN=Excel Files;DBQ=;DefaultDir=;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;"}]
[]
["sqlFromTouren",{"$f":"\"FROM `\"&B6&\"`.`\"&B7&\"$`\"","v":"FROM ``.`$`"}]
["sqlOrderByTouren","ORDER BY Transportnummer_Plan"]
[]
["sqlSelectKrGr"]
["sqlSelectFahren"]
["sqlSelectBfK"]
["sqlSelectPAblSt"]
["sqlSelectTanken"]
[]
["sqlWhereHauptlauf"]
["sqlWhereVorlauf"]
["sqlWhereNachlauf"]
["sqlWhereEln"]
["sqlWhereSonstige"]
["sqlWhereBfK"]
["sqlWherePAblSt"]
["sqlWhereTanken"]
[]
["sqlFromDK",{"$f":"\"FROM `\"&B9&\"`.`\"&B10&\"$`\"","v":"FROM ``.`$`"}]
["sqlOrderByDK","ORDER BY `DK (Text)`"]
[]
["sqlSelectHofverkehr"]
["sqlSelectVorbereiten"]
["sqlSelectFußwege"]
[]
["sqlWhereDK",{"$f":"\"WHERE (`AnfStBez (zentral)_Plan`='\"&B17&\"')\"","v":{"$error":"#REF!"}}]
[]
["sqlGroupByKrGr","GROUP BY `Fahrer_von Bezeichnung (zentral)`, `Fahrer_von ZS ID`"]
["sqlOrderByKrGr","ORDER BY `Fahrer_von Bezeichnung (zentral)`"]
[]
["sqlInHauptlauf"]
["sqlInVorlauf"]
["sqlInNachlauf"]
["sqlInELN"]
["sqlInSonstige"]
[]
["sqlInTanken"]
["sqlInBfK"]
["sqlInPAblSt"]