{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Rechnung","QR","Kunden","Positionen","Modul1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":4,"reason":"part_missing"}],"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":"Rechnung","index":0,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Rechnung!$A$2=\"\",\"\",VLOOKUP(Rechnung!$A$2,[0]!Index,3,FALSE))","v":"Herr"}]
[null,null,{"$f":"IF(Rechnung!$A$2=\"\",\"\",VLOOKUP(Rechnung!$A$2,[0]!Index,4,FALSE))","v":"Max Muster"}]
[null,null,{"$f":"IF(Rechnung!$A$2=\"\",\"\",VLOOKUP(Rechnung!$A$2,[0]!Index,5,FALSE))","v":"Musterweg"}]
[null,null,{"$f":"IF(Rechnung!$A$2=\"\",\"\",VLOOKUP(Rechnung!$A$2,[0]!Index,6,FALSE)&\" \"&VLOOKUP(Rechnung!$A$2,[0]!Index,7,FALSE))","v":"77777 Musterlingen"}]
[]
[]
[]
[]
[]
["RECHNUNG Nr. 2022.24_10",null,null,null,{"$f":" TODAY()","v":"2022-10-24"}]
[]
["Pos","Bezeichnung","Menge","Preis","Betrag"]
[null,null,null,null,{"$f":"IF(C23=\"\",\"\",C23*D23)","v":""}]
[200,"Wetterstation Brandson 5-in-1 WLAN",null,null,{"$f":"IF(C24=\"\",\"\",C24*D24)","v":""}]
[null,null,null,null,{"$f":"IF(C25=\"\",\"\",C25*D25)","v":""}]
[null,"(Occasion)",null,null,""]
[null,"Garantie: 3 Monate (bis 08.01.2023)",null,null,""]
[null,"Aussenstation, Basis-Display, Netzteil, ",null,null,""]
[null,"Bedienungsanleitung, Batterien",null,null,""]
[null,"pauschal",1,50,50]
[]
[null,null,null,null,{"$f":"IF(C29=\"\",\"\",C29*D32)","v":""}]
[]
[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":"IF(C40=\"\",\"\",C40*D40)","v":""}]
[null,null,null,null,{"$f":"IF(C41=\"\",\"\",C41*D41)","v":""}]
[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,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,"Nutzen Sie bei Fragen unsere E-Mailhilfe: kostenlos!",null,null,""]
[]
[null,null,"Zwischentotal",null,{"$f":"SUM(E23:E53)","v":50}]
[false,{"$f":"IF(A57=TRUE,E56/100*8,\"0\")","v":"0"},"MwSt.   8%",null,{"$f":"MROUND(B57,0.05)","v":0}]
[1,{"$f":"INDEX(Positionen!E10:F12,A58,2)","v":"Vorauszahlung"},"Ihre Zahlung CHF",null,{"$f":"SUM(E56:E57)","v":50}]
[]
[null,"Bankverbindung: GKB, IBAN CH09 0077 4110 2044 2260 0 | Peter Luck, Birkaweg 15, 7203 Trimmis"]

{"sheet":"QR","index":1,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Rechnung!C11","v":"Herr"}]
[null,{"$f":"Rechnung!C12","v":"Max Muster"}]
[null,{"$f":"Rechnung!C13","v":"Musterweg"},null,null,null,null,{"$f":"B50","v":"Herr"}]
[null,{"$f":"Rechnung!C14","v":"77777 Musterlingen"},null,null,null,null,{"$f":"B51","v":"Max Muster"}]
[null,null,null,null,null,null,{"$f":"B52","v":"Musterweg"}]
[null,null,null,null,null,null,{"$f":"B53","v":"77777 Musterlingen"}]
[]
[null,null,{"$f":"Rechnung!E58","v":50}]
[null,null,null,null,{"$f":"Rechnung!E58","v":50}]

{"sheet":"Kunden","index":2,"n_rows":345,"n_cols":7,"rows_kept":345,"cut":false,"hidden":false,"merged":[]}
[null,"Kundendatenbank",null,null,"Datensätze:",{"$f":"ROWS(_xlnm.Database)-1","v":14}]
["index","KdNr","Anrede","Name","Strasse","PLZ","Ort"]
[1,990,"Herr","Max Muster","Musterweg",77777,"Musterlingen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]

{"sheet":"Positionen","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[100,"Komplett-PC, neu oder Occasion"]
[200,"Peripheriegeräte"]
[300,"Interne Komponenten"]
[400,"Verbrauchsmaterial"]
[500,"Netzwerkkomponenten"]
[600,"Software"]
[700,"Schulungen, pauschal"]
[800,"Arbeit nach Aufwand"]
[900,"Rabatte, Spesen"]
[null,null,null,null,1,"Vorauszahlung"]
[null,null,null,null,2,"Besten Dank für Ihre Zahlung innert 10 Tagen."]
[null,null,null,null,3,"Besten Dank für Ihre Zahlung innert 30 Tagen."]
[]
[null,null,null,null,90,"Arbeit intern"]
[null,null,null,null,120,"Arbeit extern (Dorf)"]
[null,null,null,null,180,"Arbeit extern (Region)"]