{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Kundendaten","Termin","Rechnung","Preisliste","Admin"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Kundendaten","index":0,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["KD-Nr.","Name","Vorname","Adresse","PLZ","Wohnort","Tel","E-Mail","Telefon","Mail"]
[null,"Inhaber","Hans","Musterstrasse 1",1234,"Mustern","(+41) 81 468 01 01","muster@gmx.ch"]
[1,"Muster","Erika","Mustergasse3",1234,"Mustern","(+41) 78 134 56 78","erika@gmx.ch","X"]
[2,"Meier","Frieda","Meierstrasse 5",1234,"Mustern","(+41) 15 645 45 45","frieda56@gmx.ch","X","X"]

{"sheet":"Termin","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Rechnung","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,5,1,7],[2,5,2,7],[3,5,3,7],[23,0,23,3],[24,0,24,3],[14,0,14,1],[15,0,15,1],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[12,0,12,1],[22,5,22,6],[23,5,23,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[25,0,25,3],[26,0,26,3],[29,5,29,6],[31,5,31,6],[24,5,24,6],[25,5,25,6],[26,5,26,6]]}
[]
[null,null,null,null,null,"Seli Nail Hand & Fusspflege"]
[null,null,null,null,null,"Fahrackerstrasse 1"]
[null,null,null,null,null,"4854 Murgenthal"]
[]
[{"$f":"IFERROR(VLOOKUP($C$15,Kundendaten!$A:$F,2,0),\"\")","v":"Muster"},{"$f":"IFERROR(VLOOKUP($C$15,Kundendaten!$A:$F,3,0),\"\")","v":"Erika"}]
[{"$f":"IFERROR(VLOOKUP($C$15,Kundendaten!$A:$F,4,0),\"\")","v":"Mustergasse3"}]
[{"$f":"IFERROR(VLOOKUP($C$15,Kundendaten!$A:$F,5,0),\"\")","v":1234},{"$f":"IFERROR(VLOOKUP($C$15,Kundendaten!$A:$F,6,0),\"\")","v":"Mustern"}]
[]
[]
[]
[]
["Rechnung"]
[]
["Kundennummer:",null,1]
["Rechnungsnummer:",null,12,null,null,"Rechnungsdatum:",null,{"$f":"TODAY()","v":"2025-01-23"}]
[]
["Bezeichnung",null,null,null,"Menge","Stückpreis",null,"Gesamtpreis"]
["Shellack mit Maniküre",null,null,null,{"$f":"IFERROR(VLOOKUP(A19,Tabelle2[],2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A19,Tabelle2[],3,0),\"\")","v":""},null,{"$f":"E19*F19","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Summe",null,{"$f":"SUM(H19:H28)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"MwSt",8.1000000000000003E-2,{"$f":"H30*G31","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Gesamt",null,{"$f":"ROUND(SUM(H30,H31)/0.05,0)*0.05","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,"Betrag dankend erhalten"]
[]
[]
[]
["Seli's Nail Hand & Fusspflege",null,null,null,null,"Datum & Unterschrift"]
["Rüegg Selime"]
["Fahrackerstrasse 1"]
["4854 Murgenthal"]
["Tel: +41 79 350 67 16"]
["E-Mail: selime@gmx.ch"]

{"sheet":"Preisliste","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Pos.ID","Arbeit","Menge","Stückpreis","Position 1","Menge 1","Preis 1","Position 2","Menge 2","Preis 2"]
[1,"Klassische Maniküre",1,10]
[2,"Shellack mit Maniküre",null,55,"Shellack ohne Maniküre",1,55,"Klassische Maniküre",1,10]
[3,"Shellack ohne Maniküre",1,55]
[4,"Shellack French ohne Maniküre",1,55]
[5,"Shellack French mit Maniküre",null,55,"Shellack French ohne Maniküre",1,55,"Klassische Maniküre",1,10]
[6,"UV-Gel ohne Tip (Naturnagelverstärkung)",1,80]
[7,"UV-Gel mit Tip",1,80]
[8,"Auffüllen mit UV-Gel",1,75]
[9,"Maniküre & Auffüllen",null,75,"Auffüllen mit UV-Gel",1,75,"Klassische Maniküre",1,10]
[10,"Klassische Pediküre mit Fussbad",1,15]
[11,"Shellack mit Pediküre & Fussbad",1,85,"Shellack ohne Pediküre",1,85,"Klassische Pediküre mit Fussbad",1,15]
[12,"Shellack ohne Pediküre",1,85]
[13,"Shellack French ohne Pediküre",1,85]
[14,"Shellack French mit Pediküre",1,85,"Shellack French ohne Pediküre",1,85,"Klassische Pediküre mit Fussbad",1,15]
[15,"Nageldesign (pro Finger)",null,5]
[16,"Nagelreperatur (pro Finger)",null,5]
[17,"Nagelreperatur (pro Zeh)",null,7]
[18,"French/ Glitzer/ Farbe",null,0.2]
[19,"Strassstein",null,0.5]
[20,"Sticker",null,0.2]

{"sheet":"Admin","index":4,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]