{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BFR GEB BW","Daten","BFR GEB BW "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"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":"BFR GEB BW","index":0,"n_rows":20,"n_cols":34,"rows_kept":20,"cut":false,"hidden":true,"merged":[[2,20,2,23],[2,24,2,25],[2,26,2,27],[2,29,2,31],[19,1,19,2],[19,3,19,31],[8,26,8,27],[8,29,8,31],[17,1,17,2],[17,3,17,27],[2,3,2,6],[2,8,2,11],[2,13,2,14],[2,15,2,16],[3,13,3,14],[3,15,3,16],[8,24,8,25],[5,3,5,11],[5,13,5,16],[5,18,6,18],[5,20,5,27],[8,3,8,6],[8,8,8,11],[8,13,8,14],[8,15,8,16],[8,20,8,23],[3,3,3,6],[3,8,3,11],[3,20,3,27],[3,29,3,31],[5,29,6,31],[6,3,6,6],[6,8,6,11],[6,13,6,14],[6,15,6,16],[6,20,6,27]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Daten!C15","v":"1.01 [03.05.2024]"}]
[null,"Angaben zum Plan",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"AND(D13,E13,F13,G13,LEN(D4)=4)","v":false},null,null,null,null,{"$f":"AND(I13,J13,K13,L13,LEN(I4=4))","v":false},null,null,null,null,{"$f":"AND(N13,O13)","v":false},null,{"$f":"AND(P13,Q13)","v":false},null,null,{"$f":"S13","v":false},null,{"$f":"AND(U13,V13,W13,X13)","v":false},null,null,null,{"$f":"AND(Y13,Z13)","v":false},null,{"$f":"AND(AA13,AB13)","v":false},null,null,{"$f":"AND(AD13,AE13,AF13)","v":false}]
[null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,"_",null,"_",null,null,null,null,null,null,null,null,"."]
[]
[null,null,null,"Gebäude-ID (siehe Abstimmungsprotokoll)",null,null,null,null,null,null,null,null,null,"Geschoss-ID",null,null,null,null,"Plan-\nstand",null,"Datum gem. Geschossplan",null,null,null,null,null,null,null,null,"Datei-\nendung"]
[null,null,null,"Liegenschaft /\n Wirtschaftseinheit",null,null,null,null,"Gebäude",null,null,null,null,"Geschoss\nArt",null,"Geschoss\nNummer",null,null,null,null,"Datum im Format JJJJMMTT\n(wird aus Datumsangabe berechnet)"]
[]
[null,null,null,{"$f":"IF(D3,\"OK\",\"4 Ziffern erwartet\")","v":"4 Ziffern erwartet"},null,null,null,null,{"$f":"IF(I3,\"OK\",\"4 Ziffern erwartet\")","v":"4 Ziffern erwartet"},null,null,null,null,{"$f":"IF(N3,\"OK\",\"UG, EG, OG, ZG, DG, \nDA (Dachaufsicht) erwartet\")","v":"UG, EG, OG, ZG, DG, \nDA (Dachaufsicht) erwartet"},null,{"$f":"IF(P3,\"OK\",\"2 Ziffern erwartet\nEG 00 sonst 01 bis 99\")","v":"2 Ziffern erwartet\nEG 00 sonst 01 bis 99"},null,null,{"$f":"IF(S13,\"OK\",\"B für Bestand erwartet\")","v":"B für Bestand erwartet"},null,{"$f":"IF(U3,\"OK\",\"4 Ziffern\nfür Jahr erwartet\")","v":"4 Ziffern\nfür Jahr erwartet"},null,null,null,{"$f":"IF(Y3,\"OK\",\"2 Ziffern\nfür Monat erwartet\")","v":"2 Ziffern\nfür Monat erwartet"},null,{"$f":"IF(AA3,\"OK\",\"2 Ziffern\nfür Tag erwartet\")","v":"2 Ziffern\nfür Tag erwartet"},null,null,{"$f":"IF(AD3,\"OK\",\"pdf oder dwg erwartet\")","v":"pdf oder dwg erwartet"}]
[]
[null,null,null,{"$f":"IF(D4=\"\",\"\",MID(TEXT(D4,\"0000\"),1,1))","v":""},{"$f":"IF(D4=\"\",\"\",MID(TEXT(D4,\"0000\"),2,1))","v":""},{"$f":"IF(D4=\"\",\"\",MID(TEXT(D4,\"0000\"),3,1))","v":""},{"$f":"IF(D4=\"\",\"\",MID(TEXT(D4,\"0000\"),4,1))","v":""},"-",{"$f":"IF(I4=\"\",\"\",MID(TEXT(I4,\"0000\"),1,1))","v":""},{"$f":"IF(I4=\"\",\"\",MID(TEXT(I4,\"0000\"),2,1))","v":""},{"$f":"IF(I4=\"\",\"\",MID(TEXT(I4,\"0000\"),3,1))","v":""},{"$f":"IF(I4=\"\",\"\",MID(TEXT(I4,\"0000\"),4,1))","v":""},"-",{"$f":"MID(N4,1,1)","v":""},{"$f":"MID(N4,2,1)","v":""},{"$f":"IF(N4=\"\",\"\",MID(TEXT(P4,\"00\"),1,1))","v":""},{"$f":"IF(N4=\"\",\"\",MID(TEXT(P4,\"00\"),2,1))","v":""},"_",{"$f":"T(S4)","v":""},"_",{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),1,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),2,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),3,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),4,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),5,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),6,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),7,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U4),MID(TEXT(U4,\"JJJJMMTT\"),8,1),\"\")","v":""},".",{"$f":"MID(AD4,1,1)","v":""},{"$f":"MID(AD4,2,1)","v":""},{"$f":"MID(AD4,3,1)","v":""}]
[]
[null,null,null,{"$f":"ISNUMBER(VALUE(D11))","v":false},{"$f":"ISNUMBER(VALUE(E11))","v":false},false,false,null,{"$f":"ISNUMBER(VALUE(I11))","v":false},false,false,false,null,{"$f":"OR(N11=\"D\",N11=\"O\",N11=\"Z\",N11=\"E\",N11=\"U\")","v":false},{"$f":"OR(O11=\"A\",O11=\"G\")","v":false},{"$f":"IFERROR(IF(N4=\"EG\",VALUE(P11)=0,ISNUMBER((VALUE(P11)))),FALSE)","v":false},{"$f":"IFERROR(IF(N4=\"EG\",VALUE(Q11)=0,VALUE(P11 & Q11)>0),FALSE)","v":false},null,{"$f":"S11=\"B\"","v":false},null,{"$f":"ISNUMBER(VALUE(U11))","v":false},{"$f":"ISNUMBER(VALUE(V11))","v":false},false,false,false,false,false,false,null,{"$f":"OR(AD11=\"d\",AD11=\"p\")","v":false},{"$f":"OR(AE11=\"w\",AE11=\"d\")","v":false},{"$f":"OR(AF11=\"g\",AF11=\"f\")","v":false}]
[]
[]
[null,"Dateiname gem. BFR-Gebäude"]
[]
[null,"Dateiname:",null,{"$f":"IF(D3+I3+N3+P3+S3+U3+Y3+AA3=8,CONCATENATE(D11,E11,F11,G11,H11,I11,J11,K11,L11,M11,N11,O11,P11,Q11,R11,S11,T11,U11,V11,W11,X11,Y11,Z11,AA11,AB11,),\"Angaben zum Plan bitte vollständig und richtig eingeben.\")","v":"Angaben zum Plan bitte vollständig und richtig eingeben."}]
[]
[null,null,null,{"$f":"IF(D3+I3+N3+P3+S3+U3+Y3+AA3+AD3=9,CONCATENATE(D18,\".\",AD11,AE11,AF11),\"\")","v":""}]

{"sheet":"Daten","index":1,"n_rows":102,"n_cols":13,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Verzeichnis","",null,null,"bitte auswählen",null,null,null,null,"bitte auswählen"]
[null,null,null,null,"DA","Dachaufsicht",null,{"$f":"IFERROR(IF(inGID=\"EG\",\"00\",TEXT(VALUE(H3)+1,\"00\")),\"\")","v":"01"},null,"B","Bestand",null,"dwg"]
[null,"Dateierweiterung","",null,"DG","Dachgeschoss",null,"02",null,"V","Vorablieferung",null,"pdf"]
[null,null,null,null,"OG","Obergeschoss",null,"03"]
[null,"Makro?",true,null,"ZG","Zwischengeschoss",null,"04"]
[null,null,null,null,"EG","Erdgeschoss",null,"05"]
[null,"gewähle Etage","",null,"UG","Untergeschoss",null,"06"]
[null,null,null,null,null,null,null,"07"]
[null,"gewählte Nr","",null,null,null,null,"08"]
[null,null,null,null,null,null,null,"09"]
[null,"gewählter Stand","",null,null,null,null,"10"]
[null,null,null,null,null,null,null,"11"]
[null,"Version","1.01 [03.05.2024]",null,null,null,null,"12"]
[null,null,null,null,null,null,null,"13"]
[null,"Dateiname in","",null,null,null,null,"14"]
[null,null,null,null,null,null,null,"15"]
[null,null,null,null,null,null,null,"16"]
[null,null,null,null,null,null,null,"17"]
[null,null,null,null,null,null,null,"18"]
[null,null,null,null,null,null,null,"19"]
[null,null,null,null,null,null,null,"20"]
[null,null,null,null,null,null,null,"21"]
[null,null,null,null,null,null,null,"22"]
[null,null,null,null,null,null,null,"23"]
[null,null,null,null,null,null,null,"24"]
[null,null,null,null,null,null,null,"25"]
[null,null,null,null,null,null,null,"26"]
[null,null,null,null,null,null,null,"27"]
[null,null,null,null,null,null,null,"28"]
[null,null,null,null,null,null,null,"29"]
[null,null,null,null,null,null,null,"30"]
[null,null,null,null,null,null,null,"31"]
[null,null,null,null,null,null,null,"32"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(inGID=\"EG\",\"00\",TEXT(VALUE(H35)+1,\"00\")),\"\")","v":"33"}]
[null,null,null,null,null,null,null,"34"]
[null,null,null,null,null,null,null,"35"]
[null,null,null,null,null,null,null,"36"]
[null,null,null,null,null,null,null,"37"]
[null,null,null,null,null,null,null,"38"]
[null,null,null,null,null,null,null,"39"]
[null,null,null,null,null,null,null,"40"]
[null,null,null,null,null,null,null,"41"]
[null,null,null,null,null,null,null,"42"]
[null,null,null,null,null,null,null,"43"]
[null,null,null,null,null,null,null,"44"]
[null,null,null,null,null,null,null,"45"]
[null,null,null,null,null,null,null,"46"]
[null,null,null,null,null,null,null,"47"]
[null,null,null,null,null,null,null,"48"]
[null,null,null,null,null,null,null,"49"]
[null,null,null,null,null,null,null,"50"]
[null,null,null,null,null,null,null,"51"]
[null,null,null,null,null,null,null,"52"]
[null,null,null,null,null,null,null,"53"]
[null,null,null,null,null,null,null,"54"]
[null,null,null,null,null,null,null,"55"]
[null,null,null,null,null,null,null,"56"]
[null,null,null,null,null,null,null,"57"]
[null,null,null,null,null,null,null,"58"]
[null,null,null,null,null,null,null,"59"]
[null,null,null,null,null,null,null,"60"]
[null,null,null,null,null,null,null,"61"]
[null,null,null,null,null,null,null,"62"]
[null,null,null,null,null,null,null,"63"]
[null,null,null,null,null,null,null,"64"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(inGID=\"EG\",\"00\",TEXT(VALUE(H67)+1,\"00\")),\"\")","v":"65"}]
[null,null,null,null,null,null,null,"66"]
[null,null,null,null,null,null,null,"67"]
[null,null,null,null,null,null,null,"68"]
[null,null,null,null,null,null,null,"69"]
[null,null,null,null,null,null,null,"70"]
[null,null,null,null,null,null,null,"71"]
[null,null,null,null,null,null,null,"72"]
[null,null,null,null,null,null,null,"73"]
[null,null,null,null,null,null,null,"74"]
[null,null,null,null,null,null,null,"75"]
[null,null,null,null,null,null,null,"76"]
[null,null,null,null,null,null,null,"77"]
[null,null,null,null,null,null,null,"78"]
[null,null,null,null,null,null,null,"79"]
[null,null,null,null,null,null,null,"80"]
[null,null,null,null,null,null,null,"81"]
[null,null,null,null,null,null,null,"82"]
[null,null,null,null,null,null,null,"83"]
[null,null,null,null,null,null,null,"84"]
[null,null,null,null,null,null,null,"85"]
[null,null,null,null,null,null,null,"86"]
[null,null,null,null,null,null,null,"87"]
[null,null,null,null,null,null,null,"88"]
[null,null,null,null,null,null,null,"89"]
[null,null,null,null,null,null,null,"90"]
[null,null,null,null,null,null,null,"91"]
[null,null,null,null,null,null,null,"92"]
[null,null,null,null,null,null,null,"93"]
[null,null,null,null,null,null,null,"94"]
[null,null,null,null,null,null,null,"95"]
[null,null,null,null,null,null,null,"96"]
[null,null,null,null,null,null,null,"97"]
[null,null,null,null,null,null,null,"98"]
[null,null,null,null,null,null,null,"99"]

{"sheet":"BFR GEB BW ","index":2,"n_rows":25,"n_cols":33,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,27],[5,3,5,31],[15,26,15,27],[15,29,15,31],[12,3,12,11],[12,13,12,16],[12,18,13,18],[12,20,12,27],[12,29,13,31],[13,3,13,6],[13,8,13,11],[13,13,13,14],[13,15,13,16],[13,20,13,27],[9,26,9,27],[23,1,23,2],[23,3,23,27],[25,3,25,31],[15,3,15,6],[15,8,15,11],[15,13,15,14],[15,15,15,16],[15,20,15,23],[15,24,15,25],[9,29,9,31],[10,3,10,6],[10,8,10,11],[10,13,10,14],[10,15,10,16],[10,20,10,27],[10,29,10,31],[9,3,9,6],[9,8,9,11],[9,13,9,14],[9,15,9,16],[9,20,9,23],[9,24,9,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Daten!C15","v":"1.01 [03.05.2024]"}]
[null,"1. Bitte wählen Sie die zu prüfende Datei aus"]
[]
[null,"Dateiname:",null,{"$f":"T(inName)","v":""}]
[]
[null,null,null,{"$f":"IF(D4=\"\",\"Bitte wählen Sie eine Datei aus.\",IF(inName=newFileName,\"Der Dateiname ist formell in Ordnung.\",\"Bitte Angaben zum Plan ausfüllen und Datei umbenennen.\"))","v":"Bitte wählen Sie eine Datei aus."}]
[]
[]
[null,"2. Angaben zum Plan",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"AND(D20,E20,F20,G20,LEN(D11)=4)","v":false},null,null,null,null,{"$f":"AND(I20,J20,K20,L20,LEN(I11=4))","v":false},null,null,null,null,{"$f":"AND(N20,O20)","v":false},null,{"$f":"AND(P20,Q20)","v":false},null,null,{"$f":"S20","v":false},null,{"$f":"AND(U20,V20,W20,X20)","v":false},null,null,null,{"$f":"AND(Y20,Z20)","v":false},null,{"$f":"AND(AA20,AB20)","v":false},null,null,{"$f":"AND(AD20,AE20,AF20)","v":false}]
[null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,"_",null,"_",null,null,null,null,null,null,null,null,".",{"$f":"inExtension","v":""}]
[]
[null,null,null,"Gebäude-ID (siehe Abstimmungsprotokoll)",null,null,null,null,null,null,null,null,null,"Geschoss-ID",null,null,null,null,"Plan-\nstand",null,"Datum gem. Geschossplan",null,null,null,null,null,null,null,null,"Datei-\nendung"]
[null,null,null,"Liegenschaft /\n Wirtschaftseinheit",null,null,null,null,"Gebäude",null,null,null,null,"Geschoss\nArt",null,"Geschoss\nNummer",null,null,null,null,"Datum im Format JJJJMMTT\n(wird aus Datumsangabe berechnet)"]
[]
[null,null,null,{"$f":"IF(D10,\"OK\",\"4 Ziffern erwartet\")","v":"4 Ziffern erwartet"},null,null,null,null,{"$f":"IF(I10,\"OK\",\"4 Ziffern erwartet\")","v":"4 Ziffern erwartet"},null,null,null,null,{"$f":"IF(N10,\"OK\",\"UG, EG, OG, ZG, DG, \nDA (Dachaufsicht) erwartet\")","v":"UG, EG, OG, ZG, DG, \nDA (Dachaufsicht) erwartet"},null,{"$f":"IF(P10,\"OK\",\"2 Ziffern erwartet\nEG 00 sonst 01 bis 99\")","v":"2 Ziffern erwartet\nEG 00 sonst 01 bis 99"},null,null,{"$f":"IF(S20,\"OK\",\"B für Bestand erwartet\")","v":"B für Bestand erwartet"},null,{"$f":"IF(U10,\"OK\",\"4 Ziffern\nfür Jahr erwartet\")","v":"4 Ziffern\nfür Jahr erwartet"},null,null,null,{"$f":"IF(Y10,\"OK\",\"2 Ziffern\nfür Monat erwartet\")","v":"2 Ziffern\nfür Monat erwartet"},null,{"$f":"IF(AA10,\"OK\",\"2 Ziffern\nfür Tag erwartet\")","v":"2 Ziffern\nfür Tag erwartet"},null,null,{"$f":"IF(AD10,\"OK\",\"pdf oder dwg erwartet\")","v":"pdf oder dwg erwartet"}]
[]
[null,null,null,{"$f":"IF(D11=\"\",\"\",MID(TEXT(D11,\"0000\"),1,1))","v":""},{"$f":"IF(D11=\"\",\"\",MID(TEXT(D11,\"0000\"),2,1))","v":""},{"$f":"IF(D11=\"\",\"\",MID(TEXT(D11,\"0000\"),3,1))","v":""},{"$f":"IF(D11=\"\",\"\",MID(TEXT(D11,\"0000\"),4,1))","v":""},"-",{"$f":"IF(I11=\"\",\"\",MID(TEXT(I11,\"0000\"),1,1))","v":""},{"$f":"IF(I11=\"\",\"\",MID(TEXT(I11,\"0000\"),2,1))","v":""},{"$f":"IF(I11=\"\",\"\",MID(TEXT(I11,\"0000\"),3,1))","v":""},{"$f":"IF(I11=\"\",\"\",MID(TEXT(I11,\"0000\"),4,1))","v":""},"-",{"$f":"MID(Daten!C9,1,1)","v":""},{"$f":"MID(Daten!C9,2,1)","v":""},{"$f":"IF(inGNr=\"\",\"\",MID(TEXT(inGNr,\"00\"),1,1))","v":""},{"$f":"IF(inGNr=\"\",\"\",MID(TEXT(inGNr,\"00\"),2,1))","v":""},"_",{"$f":"Daten!C13","v":""},"_",{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),1,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),2,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),3,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),4,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),5,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),6,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),7,1),\"\")","v":""},{"$f":"IF(ISNUMBER(U11),MID(TEXT(U11,\"JJJJMMTT\"),8,1),\"\")","v":""},".",{"$f":"MID(inExtension,1,1)","v":""},{"$f":"MID(inExtension,2,1)","v":""},{"$f":"MID(inExtension,3,1)","v":""}]
[]
[null,null,null,{"$f":"ISNUMBER(VALUE(D18))","v":false},{"$f":"ISNUMBER(VALUE(E18))","v":false},false,false,null,{"$f":"ISNUMBER(VALUE(I18))","v":false},false,false,false,null,{"$f":"OR(N18=\"D\",N18=\"O\",N18=\"Z\",N18=\"E\",N18=\"U\")","v":false},{"$f":"OR(O18=\"A\",O18=\"G\")","v":false},{"$f":"ISNUMBER(VALUE(P18))","v":false},{"$f":"ISNUMBER(VALUE(Q18))","v":false},null,{"$f":"S18=\"B\"","v":false},null,{"$f":"ISNUMBER(VALUE(U18))","v":false},{"$f":"ISNUMBER(VALUE(V18))","v":false},false,false,false,false,false,false,null,{"$f":"OR(AD18=\"d\",AD18=\"p\")","v":false},{"$f":"OR(AE18=\"w\",AE18=\"d\")","v":false},{"$f":"OR(AF18=\"g\",AF18=\"f\")","v":false}]
[]
[null,"3. Dateiname gem. BFR-Gebäude"]
[]
[null,"Dateiname:",null,{"$f":"IF(D25,CONCATENATE(D18,E18,F18,G18,H18,I18,J18,K18,L18,M18,N18,O18,P18,Q18,R18,S18,T18,U18,V18,W18,X18,Y18,Z18,AA18,AB18,AC18,AD18,AE18,AF18),\"Angaben zum Plan bitte vollständig und richtig eingeben.\")","v":"Angaben zum Plan bitte vollständig und richtig eingeben."}]
[null,null,null,{"$f":"(D10+I10+N10+P10+S10+U10+Y10+AA10+AD10=9)","v":false}]