{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["NA-Liste"],"not_rendered":{"charts":0,"images":0,"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":"NA-Liste","index":0,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,1,6],[6,3,6,9],[7,0,8,2],[7,3,7,9],[8,3,8,9],[2,0,4,2],[2,3,2,9],[3,3,3,9],[4,3,4,9],[5,0,6,2],[11,10,11,12],[5,3,5,9],[11,0,11,6],[11,7,11,9],[9,0,10,2],[9,3,9,6],[9,7,10,8],[10,3,10,6]]}
["Vergütungszuordnung und -berechnung   Nr.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stück",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Std",7.0000000000000007E-2]
["Baumaßnahme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg",0.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t",0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ltr"]
["Leistung ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m2"]
["Auftragnehmer \n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3"]
[]
["Auftragsnummer ",null,null,null,null,null,null,"Nachtragsvereinbarung vom"]
[]
["Forderungen des Auftragnehmers",null,null,null,null,null,null,"Prüfergebnis (Netto)",null,null,"Ergebnis (Brutto)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
["\nAuftrag; \nNachtrag Nr.","Pos. aus LV","Pos. des NA","Menge","Einheit","EP\n gefordert","GP\n gefordert","Menge \ngeprüft","EP geprüft","GP geprüft","MwSt","Nachlass","Betrag (Brutto)","Differenz\n gefordert /\n geprüft","Typ","  Begründung  "," "," "]
["Auftrag",null,null,null,null,null,{"$f":"D15*F15","v":0},null,null,null,-9.9999999999999994E-12,null,{"$f":"IF(OR(K15<0,K15=\" \",K15=\"\",K15=\"%\",L15=\"%\",J15=\"\"),0,(1+K15)*(1-L15)*J15)","v":0},{"$f":"IF(OR(G15=0,J15=0,J15=\"\"),0.00000000000000001,J15-G15)","v":1.0000000000000001E-17},null,"Auftrag vom …"]
["NA 01"," "," ",null,null,null,{"$f":"D16*F16","v":0},{"$f":"IF(OR(D16=0,F16=0),\"\",D16)","v":""},{"$f":"IF(F16=0,\"\",F16)","v":""},{"$f":"IF(OR(I16=\"\",H16=\"\"),\"\",H16*I16)","v":""},{"$f":"IF(J16=\"\",-0.000000000001,$K$15)","v":-9.9999999999999998E-13},{"$f":"IF(OR(J16=0,J16=\"\"),0,$L$15)","v":0},0,{"$f":"IF(OR(G16=0,J16=0,J16=\"\"),0.00000000000000001,J16-G16)","v":1.0000000000000001E-17},"",null,{"$f":"IF(A16=\"\",\"=\",IF(MID(A16,4,1)=\"\",Melde(A16),IF(MID(A16,4,1)=\" \",Melde(A16),IF(LEFT(A16,3)<>\"NA \",Melde(A16),IF(CODE(MID(A16,4,1))>60,Melde(A16),IF(VALUE(MID(A16,4,10))>0,\"=\",Melde(A16)))))))","v":"="}]
[null,null,null,null,null,null,0,{"$f":"IF(OR(D17=0,F17=0),\"\",D17)","v":""},{"$f":"IF(F17=0,\"\",F17)","v":""},{"$f":"IF(OR(I17=\"\",H17=\"\"),\"\",H17*I17)","v":""},{"$f":"IF(J17=\"\",-0.000000000001,$K$15)","v":-9.9999999999999998E-13},{"$f":"IF(OR(J17=0,J17=\"\"),0,$L$15)","v":0},0,{"$f":"IF(OR(G17=0,J17=0,J17=\"\"),0.00000000000000001,J17-G17)","v":1.0000000000000001E-17},null,null,{"$f":"IF(A17=\"\",\"=\",IF(MID(A17,4,1)=\"\",Melde(A17),IF(MID(A17,4,1)=\" \",Melde(A17),IF(LEFT(A17,3)<>\"NA \",Melde(A17),IF(CODE(MID(A17,4,1))>60,Melde(A17),IF(VALUE(MID(A17,4,10))>0,\"=\",Melde(A17)))))))","v":"="}]
[null,null,null,null,null,null,0,{"$f":"IF(OR(D18=0,F18=0),\"\",D18)","v":""},{"$f":"IF(F18=0,\"\",F18)","v":""},{"$f":"IF(OR(I18=\"\",H18=\"\"),\"\",H18*I18)","v":""},{"$f":"IF(J18=\"\",-0.000000000001,$K$15)","v":-9.9999999999999998E-13},{"$f":"IF(OR(J18=0,J18=\"\"),0,$L$15)","v":0},0,{"$f":"IF(OR(G18=0,J18=0,J18=\"\"),0.00000000000000001,J18-G18)","v":1.0000000000000001E-17},null,null,"="]
[null,null,null,null,null,null,{"$f":"D19*F19","v":0},"","","",-9.9999999999999998E-13,{"$f":"IF(OR(J19=0,J19=\"\"),0,$L$15)","v":0},0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,{"$f":"D21*F21","v":0},"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,"",null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,"",null,"="]
[null,null,null,null,null,null,{"$f":"D23*F23","v":0},"","","",-9.9999999999999998E-13,0,{"$f":"IF(OR(K23<0,K23=\" \",K23=\"\",K23=\"%\",L23=\"%\",J23=\"\"),0,(1+K23)*(1-L23)*J23)","v":0},1.0000000000000001E-17,"",null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,"",null,"="]
[null,null,null,null,null,null,{"$f":"D25*F25","v":0},"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,"","","",-9.9999999999999998E-13,0,0,1.0000000000000001E-17,null,null,"="]
[null,null,null,null,null,null,0,{"$f":"IF(OR(D30=0,F30=0),\"\",D30)","v":""},{"$f":"IF(F30=0,\"\",F30)","v":""},{"$f":"IF(OR(I30=\"\",H30=\"\"),\"\",H30*30)","v":""},{"$f":"IF(J30=\"\",-0.000000000001,$K$15)","v":-9.9999999999999998E-13},{"$f":"IF(OR(J30=0,J30=\"\"),0,$L$15)","v":0},{"$f":"IF(OR(K30<0,K30=\" \",K30=\"\",K30=\"%\",L30=\"%\",J30=\"\"),0,(1+K30)*(1-L30)*J30)","v":0},{"$f":"IF(OR(G30=0,J30=0,J30=\"\"),0.00000000000000001,J30-G30)","v":1.0000000000000001E-17},null,null,"="]
[null,null,null,"Gesamtänderungssumme:",null,null,{"$f":"SUBTOTAL(9,G16:G30)","v":0},null,null,{"$f":"SUBTOTAL(9,J16:J30)","v":0},null,null,{"$f":"SUBTOTAL(9,M16:M30)","v":0},{"$f":"SUBTOTAL(9,N16:N30)","v":1.4999999999999997E-16}]