{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["18-Perioden-Budget"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"18-Perioden-Budget","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"merged":[[0,1,1,4],[1,8,1,9],[12,1,12,20],[26,1,26,21]]}
[null,"Unternehmensbudget"]
[{"$nulls":6},"STARTDATUM","2011-01-01","PERIODENLÄNGE (IN TAGEN)",null,14,"ENDDATUM",{"$f":"TEXT(T5,\"TT.MM.JJJJ\")","v":"26.08.2012"}]
[]
[]
[null,null,{"$f":"UPPER(TEXT(H2,\"TT-MMM\"))","v":"01-JAN"},{"$f":"UPPER(TEXT(C5+Tagesintervall,\"TT-MMM\"))","v":"15-JAN"},"29-JAN","12-FEB","26-FEB","11-MRZ","25-MRZ","08-APR","22-APR","06-MAI","20-MAI","03-JUN","17-JUN","01-JUL","15-JUL","29-JUL","12-AUG","26-AUG","SUMME","TREND"]
[null,"NETTOEINNAHMEN",{"$f":"Einnahmentabelle[[#Totals],[Week 1]]-Ausgabentabelle[[#Totals],[Week 1]]","v":{"v":1750,"d":"1,750.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 2]]-Ausgabentabelle[[#Totals],[Week 2]]","v":{"v":2236,"d":"2,236.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 3]]-Ausgabentabelle[[#Totals],[Week 3]]","v":{"v":1442,"d":"1,442.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 4]]-Ausgabentabelle[[#Totals],[Week 4]]","v":{"v":2253,"d":"2,253.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 5]]-Ausgabentabelle[[#Totals],[Week 5]]","v":{"v":1533,"d":"1,533.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 6]]-Ausgabentabelle[[#Totals],[Week 6]]","v":{"v":1086,"d":"1,086.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 7]]-Ausgabentabelle[[#Totals],[Week 7]]","v":{"v":1594,"d":"1,594.00 €"}},{"$f":"Einnahmentabelle[[#Totals],[Week 8]]-Ausgabentabelle[[#Totals],[Week 8]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 9]]-Ausgabentabelle[[#Totals],[Week 9]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 10]]-Ausgabentabelle[[#Totals],[Week 10]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 11]]-Ausgabentabelle[[#Totals],[Week 11]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 12]]-Ausgabentabelle[[#Totals],[Week 12]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 13]]-Ausgabentabelle[[#Totals],[Week 13]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 14]]-Ausgabentabelle[[#Totals],[Week 14]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 15]]-Ausgabentabelle[[#Totals],[Week 15]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 16]]-Ausgabentabelle[[#Totals],[Week 16]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 17]]-Ausgabentabelle[[#Totals],[Week 17]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Week 18]]-Ausgabentabelle[[#Totals],[Week 18]]","v":0},{"$f":"Einnahmentabelle[[#Totals],[Total]]-Ausgabentabelle[[#Totals],[Total]]","v":{"v":11894,"d":"11,894.00 €"}}]
[]
["Einnahmen"]
[null,"EINNAHMEN ELEMENT 1",{"v":3000,"d":"3,000.00 €"},{"v":3500,"d":"3,500.00 €"},{"v":2978,"d":"2,978.00 €"},{"v":3384,"d":"3,384.00 €"},{"v":2858,"d":"2,858.00 €"},{"v":2809,"d":"2,809.00 €"},{"v":3220,"d":"3,220.00 €"},{"$nulls":11},{"$f":"SUM(Einnahmentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":21749,"d":"21,749.00 €"}}]
[null,"EINNAHMEN ELEMENT 2",{"v":1150,"d":"1150.00"},{"v":1200,"d":"1200.00"},{"v":1144,"d":"1144.00"},{"v":1400,"d":"1400.00"},{"v":1358,"d":"1358.00"},{"v":1154,"d":"1154.00"},{"v":1245,"d":"1245.00"},{"$nulls":11},{"$f":"SUM(Einnahmentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":8651,"d":"8651.00"}}]
[null,"EINNAHMEN ELEMENT 3",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"v":392,"d":"392.00"},{"v":326,"d":"326.00"},{"v":381,"d":"381.00"},{"v":364,"d":"364.00"},{"v":315,"d":"315.00"},{"$nulls":11},{"$f":"SUM(Einnahmentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":2428,"d":"2428.00"}}]
[null,"SUMME EINNAHMEN",{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 1])","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 2])","v":{"v":5050,"d":"5,050.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 3])","v":{"v":4514,"d":"4,514.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 4])","v":{"v":5110,"d":"5,110.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 5])","v":{"v":4597,"d":"4,597.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 6])","v":{"v":4327,"d":"4,327.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 7])","v":{"v":4780,"d":"4,780.00 €"}},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 8])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 9])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 10])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 11])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 12])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 13])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 14])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 15])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 16])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 17])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Week 18])","v":0},{"$f":"SUBTOTAL(109,Einnahmentabelle[Total])","v":{"v":32828,"d":"32,828.00 €"}}]
[]
["Ausgaben"]
[null,"LÖHNE",{"v":1500,"d":"1,500.00 €"},{"v":1577,"d":"1,577.00 €"},{"v":1823,"d":"1,823.00 €"},{"v":1529,"d":"1,529.00 €"},{"v":1759,"d":"1,759.00 €"},{"v":1947,"d":"1,947.00 €"},{"v":1875,"d":"1,875.00 €"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":12010,"d":"12,010.00 €"}}]
[null,"MIETE",{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":7000,"d":"7000.00"}}]
[null,"STROM",{"v":40,"d":"40.00"},{"v":43,"d":"43.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"v":45,"d":"45.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":292,"d":"292.00"}}]
[null,"TELEFON",{"v":12,"d":"12.00"},{"v":11,"d":"11.00"},{"v":13,"d":"13.00"},{"v":14,"d":"14.00"},{"v":11,"d":"11.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":91,"d":"91.00"}}]
[null,"INTERNET",{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":105,"d":"105.00"}}]
[null,"WASSER",{"v":11,"d":"11.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":12,"d":"12.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":79,"d":"79.00"}}]
[null,"GAS",{"v":23,"d":"23.00"},{"v":27,"d":"27.00"},{"v":26,"d":"26.00"},{"v":27,"d":"27.00"},{"v":22,"d":"22.00"},{"v":29,"d":"29.00"},{"v":21,"d":"21.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":175,"d":"175.00"}}]
[null,"MÜLLABFUHR",{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":28,"d":"28.00"}}]
[null,"KABELFERNSEHEN",{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":70,"d":"70.00"}}]
[null,"BÜROMATERIAL",{"v":25,"d":"25.00"},{"v":57,"d":"57.00"},{"v":68,"d":"68.00"},{"v":146,"d":"146.00"},{"v":125,"d":"125.00"},{"v":111,"d":"111.00"},{"v":132,"d":"132.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":664,"d":"664.00"}}]
[null,"VERSICHERUNGEN",{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"$nulls":11},{"$f":"SUM(Ausgabentabelle[[#This Row],[Week 1]:[Week 18]])","v":{"v":420,"d":"420.00"}}]
[null,"GESAMTAUSGABEN",{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 1])","v":{"v":2700,"d":"2,700.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 2])","v":{"v":2814,"d":"2,814.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 3])","v":{"v":3072,"d":"3,072.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 4])","v":{"v":2857,"d":"2,857.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 5])","v":{"v":3064,"d":"3,064.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 6])","v":{"v":3241,"d":"3,241.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 7])","v":{"v":3186,"d":"3,186.00 €"}},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 8])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 9])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 10])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 11])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 12])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 13])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 14])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 15])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 16])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 17])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Week 18])","v":0},{"$f":"SUBTOTAL(109,Ausgabentabelle[Total])","v":{"v":20934,"d":"20,934.00 €"}}]