{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Auswertung","Vorauswertung","DatenPlan 2012","DatenIst2012","Listen","Planvorgabe2013"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":23,"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":"Auswertung","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[9,4,9,5],[9,8,9,9],[5,5,5,6]]}
[]
[null,"Vorschaurechnung:",null,"Kostenstelle","K2401"]
[]
[null,"Jahr:",2012,null,"Hochrechnung:"]
[null,"von Monat:",1,null,"HR.3",{"$f":"OFFSET(KnotenFormel,MATCH(E5,Formel,0),1)","v":"Ist kum + (restliche Planwerte*Faktor)"}]
[null,"bis Monat:",6,null,{"$f":"IF(E5=\"HR.3\",\"Faktor\",\"\")","v":"Faktor"},1.02]
[]
[]
[]
[null,"Kennziffer","Plan","Ist","Abweichung",null,"Plan","Vorschau","Abweichung"]
[null,null,{"$f":"$C$5&\" bis \"&$C$6","v":"1 bis 6"},{"$f":"$C$5&\" bis \"&$C$6","v":"1 bis 6"},"abs.","%",{"$f":"$C$5&\" bis 12\"","v":"1 bis 12"},"1 bis 12","abs.","%"]
[1,"Umsatz",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B12,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B12,Kennziffer,0),$C$6))","v":56400},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B12,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B12,Kennziffer,0),$C$6))","v":55680},{"$f":"D12-C12","v":-720},{"$f":"E12/C12*100","v":-1.2765957446808509},{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B12,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B12,Kennziffer,0),12))","v":112800},{"$f":"IF($C$6=12,$D12,IF($E$5=\"HR.1\",$D12/$C$6*12,IF($E$5=\"HR.2\",$D12+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A12,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A12,12)),IF($E$5=\"HR.3\",$D12+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A12,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A12,12))*$F$6),\"\"))))","v":113208},{"$f":"H12-G12","v":408},{"$f":"I12/G12*100","v":0.36170212765957449}]
[2,"Material",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B13,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B13,Kennziffer,0),$C$6))","v":13800},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B13,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B13,Kennziffer,0),$C$6))","v":14100},{"$f":"D13-C13","v":300},{"$f":"E13/C13*100","v":2.1739130434782608},{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B13,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B13,Kennziffer,0),12))","v":27600},{"$f":"IF($C$6=12,$D13,IF($E$5=\"HR.1\",$D13/$C$6*12,IF($E$5=\"HR.2\",$D13+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A13,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A13,12)),IF($E$5=\"HR.3\",$D13+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A13,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A13,12))*$F$6),\"\"))))","v":28176},{"$f":"H13-G13","v":576},{"$f":"I13/G13*100","v":2.0869565217391308}]
[3,"Fremdleistungen",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B14,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B14,Kennziffer,0),$C$6))","v":6600},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B14,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B14,Kennziffer,0),$C$6))","v":6420},-180,-2.7272727272727271,{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B14,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B14,Kennziffer,0),12))","v":13200},{"$f":"IF($C$6=12,$D14,IF($E$5=\"HR.1\",$D14/$C$6*12,IF($E$5=\"HR.2\",$D14+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A14,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A14,12)),IF($E$5=\"HR.3\",$D14+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A14,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A14,12))*$F$6),\"\"))))","v":13152},-48,-0.36363636363636365]
[4,"Personal",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B15,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B15,Kennziffer,0),$C$6))","v":14400},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B15,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B15,Kennziffer,0),$C$6))","v":13740},-660,-4.583333333333333,{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B15,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B15,Kennziffer,0),12))","v":28800},{"$f":"IF($C$6=12,$D15,IF($E$5=\"HR.1\",$D15/$C$6*12,IF($E$5=\"HR.2\",$D15+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A15,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A15,12)),IF($E$5=\"HR.3\",$D15+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A15,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A15,12))*$F$6),\"\"))))","v":28428},-372,-1.2916666666666667]
[5,"Abschreibungen",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B16,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B16,Kennziffer,0),$C$6))","v":10800},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B16,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B16,Kennziffer,0),$C$6))","v":10800},0,0,{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B16,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B16,Kennziffer,0),12))","v":21600},{"$f":"IF($C$6=12,$D16,IF($E$5=\"HR.1\",$D16/$C$6*12,IF($E$5=\"HR.2\",$D16+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A16,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A16,12)),IF($E$5=\"HR.3\",$D16+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A16,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A16,12))*$F$6),\"\"))))","v":21816},216,1]
[6,"Sonstiges",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B17,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B17,Kennziffer,0),$C$6))","v":4200},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B17,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B17,Kennziffer,0),$C$6))","v":3780},-420,-10,{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B17,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B17,Kennziffer,0),12))","v":8400},{"$f":"IF($C$6=12,$D17,IF($E$5=\"HR.1\",$D17/$C$6*12,IF($E$5=\"HR.2\",$D17+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A17,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A17,12)),IF($E$5=\"HR.3\",$D17+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A17,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A17,12))*$F$6),\"\"))))","v":8064},-336,-4]
[7,"Zinsen",{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B18,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B18,Kennziffer,0),$C$6))","v":1320},{"$f":"SUM(INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B18,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$D$10&$C$4),MATCH($B18,Kennziffer,0),$C$6))","v":1320},0,0,{"$f":"SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B18,Kennziffer,0),$C$5):INDEX(INDIRECT($E$2&$C$10&$C$4),MATCH($B18,Kennziffer,0),12))","v":2640},{"$f":"IF($C$6=12,$D18,IF($E$5=\"HR.1\",$D18/$C$6*12,IF($E$5=\"HR.2\",$D18+SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A18,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A18,12)),IF($E$5=\"HR.3\",$D18+(SUM(INDEX(INDIRECT($E$2&$C$10&$C$4),$A18,$C$6+1):INDEX(INDIRECT($E$2&$C$10&$C$4),$A18,12))*$F$6),\"\"))))","v":2666.4},26.400000000000091,1.0000000000000036]
[null,"Ergebnis",{"$f":"C12-C13-C14-C15-C16-C17-C18","v":5280},5520,240,4.5454545454545459,{"$f":"G12-G13-G14-G15-G16-G17-G18","v":10560},10905.6,345.60000000000036,3.2727272727272765]
[]
[]
[null,"Formeln:"]
[null,"C12"," =SUMME(INDEX(INDIREKT($E$2&$C$10&$C$4);VERGLEICH($B12;Kennziffer;0);$C$5):INDEX(INDIREKT($E$2&$C$10&$C$4);VERGLEICH($B12;Kennziffer;0);$C$6))"]
[null,"D12"," =SUMME(INDEX(INDIREKT($E$2&$D$10&$C$4);VERGLEICH($B12;Kennziffer;0);$C$5):INDEX(INDIREKT($E$2&$D$10&$C$4);VERGLEICH($B12;Kennziffer;0);$C$6))"]
[null,"E2","Gültigkeit:",null,"Liste KST"]
[null,"E12"," =D12-C12"]
[null,"F12"," =E12/C12*100"]
[null,"G12"," =SUMME(INDEX(INDIREKT($E$2&$C$10&$C$4);VERGLEICH($B12;Kennziffer;0);$C$5):INDEX(INDIREKT($E$2&$C$10&$C$4);VERGLEICH($B12;Kennziffer;0);12))"]
[null,"H12"," =WENN($C$6=12;$D12;WENN($E$5=\"HR.1\";$D12/$C$6*12;WENN($E$5=\"HR.2\";$D12+SUMME(INDEX(INDIREKT($E$2&$C$10&$C$4);$A12;$C$6+1):INDEX(INDIREKT($E$2&$C$10&$C$4);$A12;12));WENN($E$5=\"HR.3\";$D12+(SUMME(INDEX(INDIREKT($E$2&$C$10&$C$4);$A12;$C$6+1):INDEX(INDIREKT($E$2&$C$10&$C$4);$A12;12))*$F$6);\"\"))))"]
[null,"I12"," =H12-G12"]
[null,"J12"," =I12/G12*100"]
[null,"C4","Gültigkeit:",null,"Liste Jahr"]
[null,"C5","feste Eingabe",null,1]
[null,"C6","Gültigkeit:",null,"Liste Monat"]
[null,"E5","Gültigkeit:",null,"Liste Formel"]
[null,"F5"," =BEREICH.VERSCHIEBEN(KnotenFormel;VERGLEICH(E5;Formel;0);1)"]
[null,"E6"," =WENN(E5=\"HR.3\";\"Faktor\";\"\")"]
[null,"F6","Gültigkeit:",null,"Liste Faktor"]
[null,null,"bezieht sich auf:",null," =INDIREKT(E6)"]
[null,"F6","bedingte Formatierung",null," =E6=\"\"",null,null,"wie Untergrund grau einfärben"]
[null,"J12:J19","bedingte Formatierung",null,"Zellwert zwischen -1 und 1",null,null,"grün einfärben"]
[]
[]
[null," "]
[]
[]
[]
[]
[]
[null,"    "]
[null,"    "]

{"sheet":"Vorauswertung","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Daten Plan 2012"]
[]
["Gesamt",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!B$1:B$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!C$1:C$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!D$1:D$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!E$1:E$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!F$1:F$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!G$1:G$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!H$1:H$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!I$1:I$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!J$1:J$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!K$1:K$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!L$1:L$38)","v":37300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Umsatz\",'DatenPlan 2012'!M$1:M$38)","v":37300}]
["Material",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!B$1:B$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!C$1:C$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!D$1:D$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!E$1:E$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!F$1:F$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!G$1:G$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!H$1:H$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!I$1:I$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!J$1:J$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!K$1:K$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!L$1:L$38)","v":8600},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Material\",'DatenPlan 2012'!M$1:M$38)","v":8600}]
["Fremdleistungen",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!B$1:B$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!C$1:C$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!D$1:D$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!E$1:E$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!F$1:F$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!G$1:G$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!H$1:H$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!I$1:I$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!J$1:J$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!K$1:K$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!L$1:L$38)","v":4700},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Fremdleistungen\",'DatenPlan 2012'!M$1:M$38)","v":4700}]
["Personal",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!B$1:B$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!C$1:C$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!D$1:D$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!E$1:E$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!F$1:F$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!G$1:G$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!H$1:H$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!I$1:I$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!J$1:J$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!K$1:K$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!L$1:L$38)","v":9900},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Personal\",'DatenPlan 2012'!M$1:M$38)","v":9900}]
["Abschreibungen",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!B$1:B$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!C$1:C$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!D$1:D$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!E$1:E$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!F$1:F$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!G$1:G$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!H$1:H$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!I$1:I$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!J$1:J$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!K$1:K$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!L$1:L$38)","v":7200},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Abschreibungen\",'DatenPlan 2012'!M$1:M$38)","v":7200}]
["Sonstiges",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!B$1:B$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!C$1:C$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!D$1:D$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!E$1:E$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!F$1:F$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!G$1:G$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!H$1:H$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!I$1:I$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!J$1:J$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!K$1:K$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!L$1:L$38)","v":4300},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Sonstiges\",'DatenPlan 2012'!M$1:M$38)","v":4300}]
["Zinsen",{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!B$1:B$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!C$1:C$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!D$1:D$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!E$1:E$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!F$1:F$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!G$1:G$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!H$1:H$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!I$1:I$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!J$1:J$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!K$1:K$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!L$1:L$38)","v":850},{"$f":"SUMIF('DatenPlan 2012'!$A$1:$A$38,\"Zinsen\",'DatenPlan 2012'!M$1:M$38)","v":850}]
[]
[]
["Daten Ist 2012"]
[]
["Gesamt",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!B$1:B$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!C$1:C$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!D$1:D$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!E$1:E$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!F$1:F$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!G$1:G$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!H$1:H$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!I$1:I$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!J$1:J$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!K$1:K$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!L$1:L$38)","v":37240},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Umsatz\",DatenIst2012!M$1:M$38)","v":37240}]
["Material",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!B$1:B$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!C$1:C$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!D$1:D$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!E$1:E$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!F$1:F$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!G$1:G$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!H$1:H$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!I$1:I$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!J$1:J$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!K$1:K$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!L$1:L$38)","v":9280},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Material\",DatenIst2012!M$1:M$38)","v":9280}]
["Fremdleistungen",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!B$1:B$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!C$1:C$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!D$1:D$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!E$1:E$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!F$1:F$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!G$1:G$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!H$1:H$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!I$1:I$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!J$1:J$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!K$1:K$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!L$1:L$38)","v":4380},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Fremdleistungen\",DatenIst2012!M$1:M$38)","v":4380}]
["Personal",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!B$1:B$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!C$1:C$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!D$1:D$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!E$1:E$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!F$1:F$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!G$1:G$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!H$1:H$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!I$1:I$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!J$1:J$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!K$1:K$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!L$1:L$38)","v":9220},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Personal\",DatenIst2012!M$1:M$38)","v":9220}]
["Abschreibungen",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!B$1:B$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!C$1:C$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!D$1:D$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!E$1:E$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!F$1:F$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!G$1:G$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!H$1:H$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!I$1:I$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!J$1:J$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!K$1:K$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!L$1:L$38)","v":7200},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Abschreibungen\",DatenIst2012!M$1:M$38)","v":7200}]
["Sonstiges",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!B$1:B$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!C$1:C$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!D$1:D$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!E$1:E$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!F$1:F$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!G$1:G$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!H$1:H$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!I$1:I$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!J$1:J$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!K$1:K$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!L$1:L$38)","v":3500},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Sonstiges\",DatenIst2012!M$1:M$38)","v":3500}]
["Zinsen",{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!B$1:B$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!C$1:C$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!D$1:D$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!E$1:E$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!F$1:F$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!G$1:G$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!H$1:H$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!I$1:I$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!J$1:J$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!K$1:K$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!L$1:L$38)","v":1100},{"$f":"SUMIF(DatenIst2012!$A$1:$A$38,\"Zinsen\",DatenIst2012!M$1:M$38)","v":1100}]
[]
[]
["Namen:","B5:M11","GesamtPlan2012"]
[null,"B17:M23","GesamtIst2012"]

{"sheet":"DatenPlan 2012","index":2,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["Daten Plan 2012"]
[]
["K2401",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9400,9400,9400,9400,9400,9400,9400,9400,9400,9400,9400,9400]
["Material",2300,2300,2300,2300,2300,2300,2300,2300,2300,2300,2300,2300]
["Fremdleistungen",1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100]
["Personal",2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",700,700,700,700,700,700,700,700,700,700,700,700]
["Zinsen",220,220,220,220,220,220,220,220,220,220,220,220]
[]
["K2402",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300]
["Material",2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100]
["Fremdleistungen",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Personal",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Zinsen",210,210,210,210,210,210,210,210,210,210,210,210]
[]
["K2403",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300]
["Material",2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100]
["Fremdleistungen",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Personal",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Zinsen",210,210,210,210,210,210,210,210,210,210,210,210]
[]
["K2404",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300,9300]
["Material",2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100]
["Fremdleistungen",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Personal",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
["Zinsen",210,210,210,210,210,210,210,210,210,210,210,210]
[]
[]
["Gesamt Umsatz 1-9"," =SUMME(INDEX(K2401Plan2012;1;1):INDEX(K2401Plan2012;1;9);INDEX(K2402Plan2012;1;1):INDEX(K2402Plan2012;1;9);INDEX(K2403Plan2012;1;1):INDEX(K2403Plan2012;1;9);INDEX(K2404Plan2012;1;1):INDEX(K2404Plan2012;1;9))"]
[null,{"$f":"SUM(INDEX(K2401Plan2012,1,1):INDEX(K2401Plan2012,1,9),INDEX(K2402Plan2012,1,1):INDEX(K2402Plan2012,1,9),INDEX(K2403Plan2012,1,1):INDEX(K2403Plan2012,1,9),INDEX(K2404Plan2012,1,1):INDEX(K2404Plan2012,1,9))","v":335700}]
[]
[null," =TEILERGEBNIS(9;INDEX(K2401Plan2012;1;1):INDEX(K2401Plan2012;1;9);INDEX(K2402Plan2012;1;1):INDEX(K2402Plan2012;1;9);INDEX(K2403Plan2012;1;1):INDEX(K2403Plan2012;1;9);INDEX(K2404Plan2012;1;1):INDEX(K2404Plan2012;1;9))"]
[null,{"$f":"SUBTOTAL(9,INDEX(K2401Plan2012,1,1):INDEX(K2401Plan2012,1,9),INDEX(K2402Plan2012,1,1):INDEX(K2402Plan2012,1,9),INDEX(K2403Plan2012,1,1):INDEX(K2403Plan2012,1,9),INDEX(K2404Plan2012,1,1):INDEX(K2404Plan2012,1,9))","v":335700}]
[]
[null," =SUMME(SUMMEWENN(A:A;\"Umsatz\";INDIREKT({\"B:B\".\"C:C\".\"D:D\".\"E:E\".\"F:F\".\"G:G\".\"H:H\".\"I:I\".\"J:J\"})))"]
[null,{"$f":"SUM(SUMIF(A:A,\"Umsatz\",INDIRECT({\"B:B\",\"C:C\",\"D:D\",\"E:E\",\"F:F\",\"G:G\",\"H:H\",\"I:I\",\"J:J\"})))","v":335700}]
[null," "]
[null," {=SUMME(($A1:$A44=\"Umsatz\")*B1:J44)}"]
[null,{"$f":"SUM(($A1:$A39=\"Umsatz\")*B1:J39)","v":335700}]
[]
[null," {=SUMMENPRODUKT((A1:A43=\"Umsatz\")*B1:J43)}"]
[null,{"$f":"SUMPRODUCT((A1:A38=\"Umsatz\")*B1:J38)","v":335700}]
[]
[null," =SUMME(BEREICH.VERSCHIEBEN(KnotenK2401;1;1;1;9);BEREICH.VERSCHIEBEN(KnotenK2402;1;1;1;9);BEREICH.VERSCHIEBEN(KnotenK2403;1;1;1;9);BEREICH.VERSCHIEBEN(KnotenK2404;1;1;1;9))"]
[null,{"$f":"SUM(OFFSET(KnotenK2401,1,1,1,9),OFFSET(KnotenK2402,1,1,1,9),OFFSET(KnotenK2403,1,1,1,9),OFFSET(KnotenK2404,1,1,1,9))","v":335700}]
[]
["Namen:","B5:M11","K2401Plan2012"]
[null,"B14:M21","K2402Plan2012"]
[null,"B28:M34","K2403Plan2012"]
[null,"B37:M43","K2404Plan2012"]

{"sheet":"DatenIst2012","index":3,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["Daten Ist 2012"]
[]
["K2401",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9280,9280,9280,9280,9280,9280,9280,9280,9280,9280,9280,9280]
["Material",2350,2350,2350,2350,2350,2350,2350,2350,2350,2350,2350,2350]
["Fremdleistungen",1070,1070,1070,1070,1070,1070,1070,1070,1070,1070,1070,1070]
["Personal",2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",630,630,630,630,630,630,630,630,630,630,630,630]
["Zinsen",220,220,220,220,220,220,220,220,220,220,220,220]
[]
["K2402",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9340,9340,9340,9340,9340,9340,9340,9340,9340,9340,9340,9340]
["Material",2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290]
["Fremdleistungen",1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120]
["Personal",2320,2320,2320,2320,2320,2320,2320,2320,2320,2320,2320,2320]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120]
["Zinsen",330,330,330,330,330,330,330,330,330,330,330,330]
[]
["K2403",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9280,9280,9280,9280,9280,9280,9280,9280,9280,9280,9280,9280]
["Material",2350,2350,2350,2350,2350,2350,2350,2350,2350,2350,2350,2350]
["Fremdleistungen",1070,1070,1070,1070,1070,1070,1070,1070,1070,1070,1070,1070]
["Personal",2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",630,630,630,630,630,630,630,630,630,630,630,630]
["Zinsen",220,220,220,220,220,220,220,220,220,220,220,220]
[]
["K2404",1,2,3,4,5,6,7,8,9,10,11,12]
["Umsatz",9340,9340,9340,9340,9340,9340,9340,9340,9340,9340,9340,9340]
["Material",2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290,2290]
["Fremdleistungen",1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120]
["Personal",2320,2320,2320,2320,2320,2320,2320,2320,2320,2320,2320,2320]
["Abschreibungen",1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800]
["Sonstiges",1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120,1120]
["Zinsen",330,330,330,330,330,330,330,330,330,330,330,330]
[]
[]
["Namen:","B5:M11","K2401Ist2012",null,"B23:M29","K2403Ist2012"]
[null,"B14:M20","K2402Ist2012",null,"B32:M38","K2404Ist2012"]

{"sheet":"Listen","index":4,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"COUNTA(A6:A33)","v":3},12,3,null,{"$f":"COUNTA(E6:E33)","v":5},8,17,null,{"$f":"COUNTA(I6:I33)","v":22}]
[]
["Jahr","Monat","Formel",null,"KST","Kennziffer","Faktor",null,"Namensliste"]
[2012,1,"HR.1","Ist kum / Ist Monate * 12","K2401","Umsatz",0.92,null,"Faktor","=Listen!$G$6:$G$22"]
[2013,2,"HR.2","Ist kum + restliche Planwerte","K2402","Material",0.93,null,"Formel","=Listen!$C$6:$C$8"]
[2014,3,"HR.3","Ist kum + (restliche Planwerte*Faktor)","K2403","Fremdleistungen",0.94,null,"Fremdleistungen","=AUSWERTEN(INDIREKT(Auswertung!$E$5&\"_\"&Auswertung!$B$14))"]
[null,4,null,null,"K2404","Personal",0.95,null,"GesamtIst2012","=Vorauswertung!$B$17:$M$23"]
[null,5,null,null,"Gesamt","Abschreibungen",0.96,null,"GesamtPlan2012","=Vorauswertung!$B$5:$M$11"]
[null,6,null,null,null,"Sonstiges",0.97,null,"Jahr","=Listen!$A$6:$A$8"]
[null,7,null,null,null,"Zinsen",0.98,null,"K2401Ist2012","=DatenIst2012!$B$5:$M$11"]
[null,8,null,null,null,"Ergebnis",0.99,null,"K2401Plan2012","='DatenPlan 2012'!$B$5:$M$11"]
[null,9,null,null,null,null,1,null,"K2402Ist2012","=DatenIst2012!$B$14:$M$20"]
[null,10,null,null,null,null,1.01,null,"K2402Plan2012","='DatenPlan 2012'!$B$14:$M$20"]
[null,11,null,null,null,null,1.02,null,"K2403Ist2012","=DatenIst2012!$B$23:$M$29"]
[null,12,null,null,null,null,1.03,null,"K2403Plan2012","='DatenPlan 2012'!$B$23:$M$29"]
[null,null,null,null,null,null,1.04,null,"K2404Ist2012","=DatenIst2012!$B$32:$M$38"]
[null,null,null,null,null,null,1.05,null,"K2404Plan2012","='DatenPlan 2012'!$B$32:$M$38"]
[null,null,null,null,null,null,1.06,null,"Kennziffer","=Listen!$F$6:$F$13"]
[null,null,null,null,null,null,1.07,null,"KnotenFormel","=Listen!$C$5"]
[null,null,null,null,null,null,1.08,null,"KnotenK2401","='DatenPlan 2012'!$A$4"]
[null,null,null,null,null,null,null,null,"KnotenK2402","='DatenPlan 2012'!$A$13"]
[null,null,null,null,null,null,null,null,"KnotenK2403","='DatenPlan 2012'!$A$22"]
[null,null,null,null,null,null,null,null,"KnotenK2404","='DatenPlan 2012'!$A$31"]
[null,null,null,null,null,null,null,null,"KST","=Listen!$E$6:$E$10"]
[null,null,null,null,null,null,null,null,"Monat","=Listen!$B$6:$B$17"]

{"sheet":"Planvorgabe2013","index":5,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[9,3,9,14]]}
[]
["Vorschaurechnung:",null,"Kostenstelle",{"$f":"Auswertung!E2","v":"K2401"}]
[]
["Jahr:",2013,null,"Variator:",1.01]
["von Monat:",1]
["bis Monat:",12]
[]
[]
[]
["Kennziffer","Vorschau","Plan-","Aufteilung Plan auf Monate",null,null,null,null,null,null,null,null,null,null,null,"Plan"]
[null,2012,"vorschlag",1,2,3,4,5,6,7,8,9,10,11,12,2013]
["Umsatz",{"$f":"Auswertung!H12","v":113208},{"$f":"$B12*$E$4","v":114340.08},{"$f":"ROUND($C12/12,0)","v":9528},{"$f":"ROUND($C12/12,0)","v":9528},9528,9528,9528,9528,9528,9528,9528,9528,9528,9528,{"$f":"SUM(D12:O12)","v":114336}]
["Material",{"$f":"Auswertung!H13","v":28176},{"$f":"$B13*$E$4","v":28457.760000000002},{"$f":"ROUND($C13/12,0)","v":2371},2371,2371,2371,2371,2371,2371,2371,2371,2371,2371,2371,28452]
["Fremdleistungen",{"$f":"Auswertung!H14","v":13152},13283.52,{"$f":"ROUND($C14/12,0)","v":1107},1107,1107,1107,1107,1107,1107,1107,1107,1107,1107,1107,13284]
["Personal",{"$f":"Auswertung!H15","v":28428},28712.28,{"$f":"ROUND($C15/12,0)","v":2393},2393,2393,2393,2393,2393,2393,2393,2393,2393,2393,2393,28716]
["Abschreibungen",{"$f":"Auswertung!H16","v":21816},22034.16,{"$f":"ROUND($C16/12,0)","v":1836},1836,1836,1836,1836,1836,1836,1836,1836,1836,1836,1836,22032]
["Sonstiges",{"$f":"Auswertung!H17","v":8064},8144.64,{"$f":"ROUND($C17/12,0)","v":679},679,679,679,679,679,679,679,679,679,679,679,8148]
["Zinsen",{"$f":"Auswertung!H18","v":2666.4},2693.0640000000003,{"$f":"ROUND($C18/12,0)","v":224},224,224,224,224,224,224,224,224,224,224,224,2688]
["Ergebnis",{"$f":"B12-B13-B14-B15-B16-B17-B18","v":10905.6},{"$f":"C12-C13-C14-C15-C16-C17-C18","v":11014.656000000004},918,918,918,918,918,918,918,918,918,918,918,918,11016]