{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ausgabenbudget"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Ausgabenbudget","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"Ausgabenbudget",{"$nulls":3},"CONTOSO 2013"]
[]
[]
[null," PERSONALBUDGET"]
{"$rows_empty":7}
[null,"STATUS","PERSONAL","BUDGET","IST","DIFFERENZ (€)","DIFFERENZ (%)"]
[null,{"$f":"IFERROR(tblPersonalkosten[[#This Row],[IST]]/tblPersonalkosten[[#This Row],[BUDGET]],\"\")","v":{"v":1.13,"d":"$1.13"}},"Büro",{"v":500,"d":"500.00 €"},{"v":565,"d":"565.00 €"},{"$f":"tblPersonalkosten[[#This Row],[BUDGET]]-tblPersonalkosten[[#This Row],[IST]]","v":{"v":-65,"d":"-65.00 €"}},{"$f":"IFERROR(tblPersonalkosten[DIFFERENZ (€)]/tblPersonalkosten[BUDGET],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblPersonalkosten[[#This Row],[IST]]/tblPersonalkosten[[#This Row],[BUDGET]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Ladengeschäft",{"v":125,"d":"125.00 €"},{"v":150,"d":"150.00 €"},{"$f":"tblPersonalkosten[[#This Row],[BUDGET]]-tblPersonalkosten[[#This Row],[IST]]","v":{"v":-25,"d":"-25.00 €"}},{"$f":"IFERROR(tblPersonalkosten[DIFFERENZ (€)]/tblPersonalkosten[BUDGET],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblPersonalkosten[[#This Row],[IST]]/tblPersonalkosten[[#This Row],[BUDGET]],\"\")","v":{"v":1,"d":"$1.00"}},"Verkaufspersonal",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"tblPersonalkosten[[#This Row],[BUDGET]]-tblPersonalkosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblPersonalkosten[DIFFERENZ (€)]/tblPersonalkosten[BUDGET],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblPersonalkosten[[#This Row],[IST]]/tblPersonalkosten[[#This Row],[BUDGET]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Sonstige",{"v":100,"d":"100.00 €"},{"v":90,"d":"90.00 €"},{"$f":"tblPersonalkosten[[#This Row],[BUDGET]]-tblPersonalkosten[[#This Row],[IST]]","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(tblPersonalkosten[DIFFERENZ (€)]/tblPersonalkosten[BUDGET],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," BETRIEBSBUDGET"]
{"$rows_empty":7}
[null,"STATUS","BETRIEB","BUDGET","IST","DIFFERENZ (€)","DIFFERENZ (%)"]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":0.98,"d":"$0.98"}},"Werbung",{"v":250,"d":"250.00 €"},{"v":245,"d":"245.00 €"},{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":5,"d":"5.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Schulden",{"v":125,"d":"125.00 €"},{"v":150,"d":"150.00 €"},{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":-25,"d":"-25.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":1,"d":"$1.00"}},"Zuschüsse",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Hilfsstoffe",{"v":100,"d":"100.00 €"},{"v":90,"d":"90.00 €"},{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Porto",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Miete oder Hypothek",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Vertriebsausgaben",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Steuern",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Nebenkosten",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Sonstige",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Versicherungen",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Zinsen",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Telefon",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Wartung und Reparaturen",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Rechtsanwaltskosten",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Abschreibung",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Versandkosten",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Lagerkosten",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblBetriebskosten[[#This Row],[IST]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""},"Sonstige",null,null,{"$f":"tblBetriebskosten[[#This Row],[BUDGET]]-tblBetriebskosten[[#This Row],[IST]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblBetriebskosten[[#This Row],[DIFFERENZ (€)]]/tblBetriebskosten[[#This Row],[BUDGET]],\"\")","v":""}]
[null,null,"Ausgaben gesamt",{"$f":"SUBTOTAL(109,tblBetriebskosten[BUDGET],tblPersonalkosten[BUDGET])","v":{"v":1400,"d":"1,400.00 €"}},{"$f":"SUBTOTAL(109,tblBetriebskosten[IST],tblPersonalkosten[IST])","v":{"v":1490,"d":"1,490.00 €"}},{"$f":"SUBTOTAL(109,tblBetriebskosten[DIFFERENZ (€)],tblPersonalkosten[DIFFERENZ (€)])","v":{"v":-90,"d":"-90.00 €"}},{"$f":"IFERROR(SUM(tblBetriebskosten[[#Totals],[DIFFERENZ (€)]]/tblBetriebskosten[[#Totals],[BUDGET]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]