{"text_format":"2","workbook":"xlsx","n_sheets":13,"sheets":["C&S","Sales","NW","GW","Aftersales","Service","ME","KA","LA","T&Z","MW","---","Planung_2017"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"C&S","index":0,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt",null,2016,"Differenz","in %"]
["Saison ","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-"]
["NW + GW Stk.",{"$f":"NW!B3+GW!B3","v":57.755546612191154},{"$f":"NW!C3+GW!C3","v":54.208785184135863},{"$f":"NW!D3+GW!D3","v":75.716895373164078},{"$f":"NW!E3+GW!E3","v":67.730447835265522},{"$f":"NW!F3+GW!F3","v":89.802754643035598},{"$f":"NW!G3+GW!G3","v":74.089763349111365},{"$f":"NW!H3+GW!H3","v":60.326605400113635},{"$f":"NW!I3+GW!I3","v":60.649804991253959},{"$f":"NW!J3+GW!J3","v":61.363656661379686},{"$f":"NW!K3+GW!K3","v":74.805333779343485},{"$f":"NW!L3+GW!L3","v":54.478843946303797},{"$f":"NW!M3+GW!M3","v":69.071562224701836},{"$f":"SUM(B3:M3)","v":800},null,769,{"$f":"N3-P3","v":31},{"$f":"Q3/P3","v":4.0312093628088429E-2}]
["Verk. Stunden",{"$f":"Aftersales!B3","v":1334.773574401657},{"$f":"Aftersales!C3","v":1178.5429400472806},{"$f":"Aftersales!D3","v":1621.4182891260891},{"$f":"Aftersales!E3","v":1727.4499261254145},{"$f":"Aftersales!F3","v":1446.2453018475712},{"$f":"Aftersales!G3","v":1585.7735511552473},{"$f":"Aftersales!H3","v":1408.1884047316739},{"$f":"Aftersales!I3","v":1464.7883786293762},{"$f":"Aftersales!J3","v":1336.8285454873289},{"$f":"Aftersales!K3","v":1897.178476073331},{"$f":"Aftersales!L3","v":1850.5745858727657},{"$f":"Aftersales!M3","v":1578.2380265022643},{"$f":"SUM(B4:M4)","v":18430.000000000004},null,17759,{"$f":"N4-P4","v":671.00000000000364},{"$f":"Q4/P4","v":3.7783658989808191E-2}]
["Umsatzerlöse",{"$f":"Sales!B4+Aftersales!B4","v":940886.33614692336},{"$f":"Sales!C4+Aftersales!C4","v":869061.68446016219},{"$f":"Sales!D4+Aftersales!D4","v":1209197.5459379819},{"$f":"Sales!E4+Aftersales!E4","v":1134052.4174387383},{"$f":"Sales!F4+Aftersales!F4","v":1343971.243894289},{"$f":"Sales!G4+Aftersales!G4","v":1183060.7899442054},{"$f":"Sales!H4+Aftersales!H4","v":985418.00094202161},{"$f":"Sales!I4+Aftersales!I4","v":999975.05967138207},{"$f":"Sales!J4+Aftersales!J4","v":984283.65613845759},{"$f":"Sales!K4+Aftersales!K4","v":1250485.1184572731},{"$f":"Sales!L4+Aftersales!L4","v":999379.35812284308},{"$f":"Sales!M4+Aftersales!M4","v":1121818.6698457222},{"$f":"SUM(B5:M5)","v":13021589.880999999},null,12536119,485470.88099999912,3.8725771588479584E-2]
["Einsatzwerte",{"$f":"Sales!B6+Aftersales!B6","v":742758.11364777165},{"$f":"Sales!C6+Aftersales!C6","v":690817.6073739127},{"$f":"Sales!D6+Aftersales!D6","v":962802.28375201637},{"$f":"Sales!E6+Aftersales!E6","v":884855.65019838838},{"$f":"Sales!F6+Aftersales!F6","v":1101286.971846899},{"$f":"Sales!G6+Aftersales!G6","v":942043.71842002333},{"$f":"Sales!H6+Aftersales!H6","v":777015.46281214699},{"$f":"Sales!I6+Aftersales!I6","v":785358.29769535048},{"$f":"Sales!J6+Aftersales!J6","v":782229.62922257825},{"$f":"Sales!K6+Aftersales!K6","v":976371.58012572501},{"$f":"Sales!L6+Aftersales!L6","v":751021.96659771516},{"$f":"Sales!M6+Aftersales!M6","v":886747.71835247229},{"$f":"SUM(B6:M6)","v":10283309.000045002},null,9820877,462432.00004500151,4.708662984425948E-2]
["Bruttoertrag",{"$f":"Sales!B7+Aftersales!B7","v":198128.22249915177},{"$f":"Sales!C7+Aftersales!C7","v":178244.07708624951},{"$f":"Sales!D7+Aftersales!D7","v":246395.26218596534},{"$f":"Sales!E7+Aftersales!E7","v":249196.76724035005},{"$f":"Sales!F7+Aftersales!F7","v":242684.27204738991},{"$f":"Sales!G7+Aftersales!G7","v":241017.0715241821},{"$f":"Sales!H7+Aftersales!H7","v":208402.53812987456},{"$f":"Sales!I7+Aftersales!I7","v":214616.76197603153},{"$f":"Sales!J7+Aftersales!J7","v":202054.02691587937},{"$f":"Sales!K7+Aftersales!K7","v":274113.5383315481},{"$f":"Sales!L7+Aftersales!L7","v":248357.39152512775},{"$f":"Sales!M7+Aftersales!M7","v":235070.95149324997},{"$f":"SUM(B7:M7)","v":2738280.8809550004},null,2715243,23037.880955000408,8.4846479504782479E-3]
[]
["Variable Kosten",{"$f":"Sales!B10+Aftersales!B10","v":22016.54401995676},{"$f":"Sales!C10+Aftersales!C10","v":20484.798147493002},{"$f":"Sales!D10+Aftersales!D10","v":28552.592615920141},{"$f":"Sales!E10+Aftersales!E10","v":26211.394002643308},{"$f":"Sales!F10+Aftersales!F10","v":32710.457563578064},{"$f":"Sales!G10+Aftersales!G10","v":27937.068141343352},{"$f":"Sales!H10+Aftersales!H10","v":23030.50666653187},{"$f":"Sales!I10+Aftersales!I10","v":23272.605507725479},{"$f":"Sales!J10+Aftersales!J10","v":23195.144979333039},{"$f":"Sales!K10+Aftersales!K10","v":28923.415093359759},{"$f":"Sales!L10+Aftersales!L10","v":22198.936215850754},{"$f":"Sales!M10+Aftersales!M10","v":26286.537046264471},{"$f":"SUM(B9:M9)","v":304820},null,293681,11139,3.7928909258685445E-2]
["Fixum/Prov./Soz.",{"$f":"Sales!B11+Aftersales!B11","v":16480.955578947425},{"$f":"Sales!C11+Aftersales!C11","v":15468.862005711902},{"$f":"Sales!D11+Aftersales!D11","v":21606.354063273997},{"$f":"Sales!E11+Aftersales!E11","v":19327.364514624885},{"$f":"Sales!F11+Aftersales!F11","v":25625.854085961946},{"$f":"Sales!G11+Aftersales!G11","v":21142.040379437527},{"$f":"Sales!H11+Aftersales!H11","v":17214.625471453794},{"$f":"Sales!I11+Aftersales!I11","v":17306.852771118782},{"$f":"Sales!J11+Aftersales!J11","v":17510.555417105272},{"$f":"Sales!K11+Aftersales!K11","v":21346.233485832166},{"$f":"Sales!L11+Aftersales!L11","v":15545.925192264029},{"$f":"Sales!M11+Aftersales!M11","v":19710.061034268278},228285.68400000001,null,217538,10747.684000000008,4.9406007226323718E-2]
["Provisionen",{"$f":"Sales!B12+Aftersales!B12","v":324.66486389277344},{"$f":"Sales!C12+Aftersales!C12","v":304.72723220465696},{"$f":"Sales!D12+Aftersales!D12","v":425.63211626712808},{"$f":"Sales!E12+Aftersales!E12","v":380.73739956936777},{"$f":"Sales!F12+Aftersales!F12","v":504.81383734706122},{"$f":"Sales!G12+Aftersales!G12","v":416.48541732456908},{"$f":"Sales!H12+Aftersales!H12","v":339.11771734849629},{"$f":"Sales!I12+Aftersales!I12","v":340.93453941014786},{"$f":"Sales!J12+Aftersales!J12","v":344.94735841915497},{"$f":"Sales!K12+Aftersales!K12","v":420.50789810718476},{"$f":"Sales!L12+Aftersales!L12","v":306.24533040310422},{"$f":"Sales!M12+Aftersales!M12","v":388.27628970635556},4497.0900000000011,null,4381,116.09000000000106,2.6498516320475018E-2]
["Fertigmachen",{"$f":"Sales!B13+Aftersales!B13","v":944.36902843246321},{"$f":"Sales!C13+Aftersales!C13","v":886.37543577573126},{"$f":"Sales!D13+Aftersales!D13","v":1238.057556611958},{"$f":"Sales!E13+Aftersales!E13","v":1107.4700348171232},{"$f":"Sales!F13+Aftersales!F13","v":1468.377413553925},{"$f":"Sales!G13+Aftersales!G13","v":1211.4520930881888},{"$f":"Sales!H13+Aftersales!H13","v":986.40877062201389},{"$f":"Sales!I13+Aftersales!I13","v":991.69345238469225},{"$f":"Sales!J13+Aftersales!J13","v":1003.3657409821517},{"$f":"Sales!K13+Aftersales!K13","v":1223.1524853727742},{"$f":"Sales!L13+Aftersales!L13","v":890.7912044041658},{"$f":"Sales!M13+Aftersales!M13","v":1129.3987839548113},13080.911999999998,null,13683,-602.08800000000156,-4.4002631001973366E-2]
["Kulanz",{"$f":"Sales!B14+Aftersales!B14","v":4266.5545486840992},{"$f":"Sales!C14+Aftersales!C14","v":3824.8334738007102},{"$f":"Sales!D14+Aftersales!D14","v":5282.5488797670569},{"$f":"Sales!E14+Aftersales!E14","v":5395.8220536319332},{"$f":"Sales!F14+Aftersales!F14","v":5111.4122267151306},{"$f":"Sales!G14+Aftersales!G14","v":5167.0902514930694},{"$f":"Sales!H14+Aftersales!H14","v":4490.3547071075691},{"$f":"Sales!I14+Aftersales!I14","v":4633.1247448118547},{"$f":"Sales!J14+Aftersales!J14","v":4336.2764628264586},{"$f":"Sales!K14+Aftersales!K14","v":5933.521224047634},{"$f":"Sales!L14+Aftersales!L14","v":5455.9744887794559},{"$f":"Sales!M14+Aftersales!M14","v":5058.8009383350263},58956.313999999998,null,58080,876.31399999999849,{"$f":"Q13/P13","v":1.5088050964187302E-2}]
["sonst. variable Kosten",{"$f":"Sales!B15+Aftersales!B15","v":0},{"$f":"Sales!C15+Aftersales!C15","v":0},{"$f":"Sales!D15+Aftersales!D15","v":0},{"$f":"Sales!E15+Aftersales!E15","v":0},{"$f":"Sales!F15+Aftersales!F15","v":0},{"$f":"Sales!G15+Aftersales!G15","v":0},{"$f":"Sales!H15+Aftersales!H15","v":0},{"$f":"Sales!I15+Aftersales!I15","v":0},{"$f":"Sales!J15+Aftersales!J15","v":0},{"$f":"Sales!K15+Aftersales!K15","v":0},{"$f":"Sales!L15+Aftersales!L15","v":0},{"$f":"Sales!M15+Aftersales!M15","v":0},0,null,0,0,{"$f":"Q14/P14","v":{"$error":"#DIV/0!"}}]
["Bruttoertrag II",{"$f":"Sales!B16+Aftersales!B16","v":176111.67847919499},{"$f":"Sales!C16+Aftersales!C16","v":157759.27893875653},{"$f":"Sales!D16+Aftersales!D16","v":217842.6695700452},{"$f":"Sales!E16+Aftersales!E16","v":222985.37323770672},{"$f":"Sales!F16+Aftersales!F16","v":209973.81448381182},{"$f":"Sales!G16+Aftersales!G16","v":213080.00338283871},{"$f":"Sales!H16+Aftersales!H16","v":185372.03146334272},{"$f":"Sales!I16+Aftersales!I16","v":191344.15646830606},{"$f":"Sales!J16+Aftersales!J16","v":178858.88193654633},{"$f":"Sales!K16+Aftersales!K16","v":245190.12323818833},{"$f":"Sales!L16+Aftersales!L16","v":226158.45530927699},{"$f":"Sales!M16+Aftersales!M16","v":208784.41444698549},2433460.8809549999,null,2421561,11899.880954999942,4.9141363587371705E-3]
["Direkte Kosten",{"$f":"Sales!B17+Aftersales!B17","v":96675},{"$f":"Sales!C17+Aftersales!C17","v":96675},{"$f":"Sales!D17+Aftersales!D17","v":96675},{"$f":"Sales!E17+Aftersales!E17","v":96675},{"$f":"Sales!F17+Aftersales!F17","v":96675},{"$f":"Sales!G17+Aftersales!G17","v":96675},{"$f":"Sales!H17+Aftersales!H17","v":96675},{"$f":"Sales!I17+Aftersales!I17","v":96675},{"$f":"Sales!J17+Aftersales!J17","v":96675},{"$f":"Sales!K17+Aftersales!K17","v":96675},{"$f":"Sales!L17+Aftersales!L17","v":96675},{"$f":"Sales!M17+Aftersales!M17","v":96675},1160100,null,1180123,-20023,-1.6966875486707743E-2]
["Personalkosten",{"$f":"Sales!B18+Aftersales!B18","v":67781.188333333339},{"$f":"Sales!C18+Aftersales!C18","v":67781.188333333339},{"$f":"Sales!D18+Aftersales!D18","v":67781.188333333339},{"$f":"Sales!E18+Aftersales!E18","v":67781.188333333339},{"$f":"Sales!F18+Aftersales!F18","v":67781.188333333339},{"$f":"Sales!G18+Aftersales!G18","v":67781.188333333339},{"$f":"Sales!H18+Aftersales!H18","v":67781.188333333339},{"$f":"Sales!I18+Aftersales!I18","v":67781.188333333339},{"$f":"Sales!J18+Aftersales!J18","v":67781.188333333339},{"$f":"Sales!K18+Aftersales!K18","v":67781.188333333339},{"$f":"Sales!L18+Aftersales!L18","v":67781.188333333339},{"$f":"Sales!M18+Aftersales!M18","v":67781.188333333339},813374.26000000013,null,811160,2214.2600000001257,2.7297450564625052E-3]
["Werbekosten",{"$f":"Sales!B19+Aftersales!B19","v":2664.6875},{"$f":"Sales!C19+Aftersales!C19","v":2664.6875},{"$f":"Sales!D19+Aftersales!D19","v":2664.6875},{"$f":"Sales!E19+Aftersales!E19","v":2664.6875},{"$f":"Sales!F19+Aftersales!F19","v":2664.6875},{"$f":"Sales!G19+Aftersales!G19","v":2664.6875},{"$f":"Sales!H19+Aftersales!H19","v":2664.6875},{"$f":"Sales!I19+Aftersales!I19","v":2664.6875},{"$f":"Sales!J19+Aftersales!J19","v":2664.6875},{"$f":"Sales!K19+Aftersales!K19","v":2664.6875},{"$f":"Sales!L19+Aftersales!L19","v":2664.6875},{"$f":"Sales!M19+Aftersales!M19","v":2664.6875},31976.25,null,36769,-4792.75,-0.13034757540319292]
["Fahrzeugkosten",{"$f":"Sales!B20+Aftersales!B20","v":8308.1825000000008},{"$f":"Sales!C20+Aftersales!C20","v":8308.1825000000008},{"$f":"Sales!D20+Aftersales!D20","v":8308.1825000000008},{"$f":"Sales!E20+Aftersales!E20","v":8308.1825000000008},{"$f":"Sales!F20+Aftersales!F20","v":8308.1825000000008},{"$f":"Sales!G20+Aftersales!G20","v":8308.1825000000008},{"$f":"Sales!H20+Aftersales!H20","v":8308.1825000000008},{"$f":"Sales!I20+Aftersales!I20","v":8308.1825000000008},{"$f":"Sales!J20+Aftersales!J20","v":8308.1825000000008},{"$f":"Sales!K20+Aftersales!K20","v":8308.1825000000008},{"$f":"Sales!L20+Aftersales!L20","v":8308.1825000000008},{"$f":"Sales!M20+Aftersales!M20","v":8308.1825000000008},99698.189999999988,null,95352,4346.1899999999878,4.5580480745028816E-2]
["Abschreibungen",{"$f":"Sales!B21+Aftersales!B21","v":13124.833333333334},{"$f":"Sales!C21+Aftersales!C21","v":13124.833333333334},{"$f":"Sales!D21+Aftersales!D21","v":13124.833333333334},{"$f":"Sales!E21+Aftersales!E21","v":13124.833333333334},{"$f":"Sales!F21+Aftersales!F21","v":13124.833333333334},{"$f":"Sales!G21+Aftersales!G21","v":13124.833333333334},{"$f":"Sales!H21+Aftersales!H21","v":13124.833333333334},{"$f":"Sales!I21+Aftersales!I21","v":13124.833333333334},{"$f":"Sales!J21+Aftersales!J21","v":13124.833333333334},{"$f":"Sales!K21+Aftersales!K21","v":13124.833333333334},{"$f":"Sales!L21+Aftersales!L21","v":13124.833333333334},{"$f":"Sales!M21+Aftersales!M21","v":13124.833333333334},157498,null,177508,-20010,-0.11272731369853753]
["Gemeinkosten",{"$f":"Sales!B22+Aftersales!B22","v":4796.1083333333336},{"$f":"Sales!C22+Aftersales!C22","v":4796.1083333333336},{"$f":"Sales!D22+Aftersales!D22","v":4796.1083333333336},{"$f":"Sales!E22+Aftersales!E22","v":4796.1083333333336},{"$f":"Sales!F22+Aftersales!F22","v":4796.1083333333336},{"$f":"Sales!G22+Aftersales!G22","v":4796.1083333333336},{"$f":"Sales!H22+Aftersales!H22","v":4796.1083333333336},{"$f":"Sales!I22+Aftersales!I22","v":4796.1083333333336},{"$f":"Sales!J22+Aftersales!J22","v":4796.1083333333336},{"$f":"Sales!K22+Aftersales!K22","v":4796.1083333333336},{"$f":"Sales!L22+Aftersales!L22","v":4796.1083333333336},{"$f":"Sales!M22+Aftersales!M22","v":4796.1083333333336},57553.300000000017,null,59335,-1781.6999999999825,-3.0027808207634323E-2]
["Deckungsbeitrag",{"$f":"Sales!B23+Aftersales!B23","v":79436.678479195005},{"$f":"Sales!C23+Aftersales!C23","v":61084.278938756528},{"$f":"Sales!D23+Aftersales!D23","v":121167.6695700452},{"$f":"Sales!E23+Aftersales!E23","v":126310.37323770672},{"$f":"Sales!F23+Aftersales!F23","v":113298.81448381182},{"$f":"Sales!G23+Aftersales!G23","v":116405.00338283872},{"$f":"Sales!H23+Aftersales!H23","v":88697.031463342704},{"$f":"Sales!I23+Aftersales!I23","v":94669.156468306057},{"$f":"Sales!J23+Aftersales!J23","v":82183.881936546342},{"$f":"Sales!K23+Aftersales!K23","v":148515.12323818836},{"$f":"Sales!L23+Aftersales!L23","v":129483.45530927698},{"$f":"Sales!M23+Aftersales!M23","v":112109.41444698551},1273360.8809549999,null,1241438,31922.880954999942,2.5714438381135379E-2]
[]
["indirekte Kosten",{"$f":"SUM(B25:B31)","v":103166.66666666667},{"$f":"SUM(C25:C31)","v":103166.66666666667},103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,103166.66666666667,{"$f":"SUM(B24:M24)","v":1238000},null,1317750,-79750,-6.0519825460064507E-2]
["Verwaltungspersonal",{"$f":"$N$25/12","v":31000},31000,31000,31000,31000,31000,31000,31000,31000,31000,31000,{"$f":"$N$25/12","v":31000},372000,null,452100,-80100,-0.17717319177173191]
["Imagewerbung",{"$f":"$N$26/12","v":1083.3333333333333},1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,1083.3333333333333,{"$f":"$N$26/12","v":1083.3333333333333},13000,null,12652,348,2.7505532722099272E-2]
["Fahrzeugkosten",{"$f":"$N$27/12","v":666.66666666666663},666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,{"$f":"$N$27/12","v":666.66666666666663},8000,null,8439,-439,-5.2020381561796419E-2]
["Abschreibungen",{"$f":"$N$28/12","v":8750},8750,8750,8750,8750,8750,8750,8750,8750,8750,8750,{"$f":"$N$28/12","v":8750},105000,null,104570,430,4.1120780338529212E-3]
["Gemeinkosten",{"$f":"$N$29/12","v":41833.333333333336},41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,41833.333333333336,{"$f":"$N$29/12","v":41833.333333333336},502000,null,501876,124,2.4707298217089478E-4]
["Raumkosten",{"$f":"$N$30/12","v":14333.333333333334},14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,14333.333333333334,{"$f":"$N$30/12","v":14333.333333333334},172000,null,172113,-113,-6.5654540912075206E-4]
["Kalk. Kosten",{"$f":"$N$31/12","v":5500},5500,5500,5500,5500,5500,5500,5500,5500,5500,5500,{"$f":"$N$31/12","v":5500},66000,null,66000,0,0]
[]
["Betriebsergebnis",{"$f":"B22-B24","v":-23729.988187471667},{"$f":"C22-C24","v":-42082.387727910143},18001.002903378525,23143.706571040049,10132.147817145145,13238.336716172053,-14469.635203323967,-8497.5101983606146,-20982.784730120329,45348.456571521689,26316.788642610307,8942.7477803188376,{"$f":"N22-N24","v":35360.880954999942},null,-76312,111672.88095499994]
["Neutrales Ergebnis",{"$f":"$N$34/12","v":-2500},-2500,-2500,-2500,-2500,-2500,-2500,-2500,-2500,-2500,-2500,{"$f":"$N$34/12","v":-2500},-30000,null,-20438,-9562]
["Untenehmensergebnis",{"$f":"SUM(B33:B34)","v":-26229.988187471667},{"$f":"SUM(C33:C34)","v":-44582.387727910143},15501.002903378525,20643.706571040049,7632.1478171451454,10738.336716172053,-16969.635203323967,-10997.510198360615,-23482.784730120329,42848.456571521689,23816.788642610307,6442.7477803188376,{"$f":"N33+N34","v":5360.8809549999423},null,-96751,102111.88095499994]
[]
[{"$nulls":12},"DB pro Tag",{"$f":"N22/251","v":5073.150920139442}]
[{"$nulls":12},"DB pro Monat",{"$f":"(N37*251)/12","v":106113.40674625}]
[]
[{"$nulls":12},"Umsatzrendite",{"$f":"N35/N5","v":4.1169173687631539E-4}]
[]
[{"$nulls":12},"Personal vs. BE",{"$f":"N10+N11+N17+N25","v":1418157.034}]
[{"$nulls":12},"Ziel < 50%",{"$f":"N42/N7","v":0.51790049876307975}]
[]
[{"$nulls":12},"AfA vs. BE",{"$f":"N20+N28","v":262498}]
[{"$nulls":12},"Ziel < 5%",{"$f":"N45/N7","v":9.5862335316182545E-2}]

{"sheet":"Sales","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[31,10,31,11],[32,11,32,12]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2194433265238944E-2,6.7760981480169832E-2,9.4646119216455105E-2,8.4663059794081896E-2,0.1122534433037945,9.2612204186389213E-2,7.5408256750142039E-2,7.5812256239067455E-2,7.6704570826724605E-2,9.3506667224179357E-2,6.8098554932879751E-2,8.6339452780877304E-2,{"$f":"SUM(B2:M2)","v":1}]
["NW + GW Stk.",{"$f":"$N$3*B2","v":57.755546612191154},{"$f":"$N$3*C2","v":54.208785184135863},75.716895373164078,67.730447835265522,89.802754643035598,74.089763349111365,60.326605400113628,60.649804991253966,61.363656661379686,74.805333779343485,54.478843946303797,69.07156222470185,{"$f":"NW!N3+GW!N3","v":800}]
["Umsatzerlöse",{"$f":"$N$4*B2","v":688446.11561731854},{"$f":"$N$4*C2","v":646168.71939489956},902545.39284811588,807346.93819636491,1070448.8353449844,883149.97912140749,719093.13636935444,722945.67549574724,731454.78740364581,891679.57864977431,649387.81983994134,823333.02171844593,{"$f":"NW!N4+GW!N4","v":9536000}]
["Umsatz / Stk.",{"$f":"$N$4/$N$3","v":11920},{"$f":"$N$4/$N$3","v":11920},11920,11920,11920,11920,11920,11920,11920,11920,11920,11920,{"$f":"N4/N3","v":11920}]
["Einsatzwerte",{"$f":"$N$6*B2","v":629023.45515216654},{"$f":"$N$6*C2","v":590395.19762642356},824642.92929000536,737661.45098433446,978053.92418917746,806921.61475322407,657025.20350436657,660545.21388342069,668319.86879273539,814714.98891089007,593336.44406312739,752267.70885012811,{"$f":"NW!N6+GW!N6","v":8712908}]
["Bruttoertrag",{"$f":"$N$7*B2","v":59422.660465152054},{"$f":"$N$7*C2","v":55773.521768475948},77902.463558110467,69685.48721203045,92394.911155806825,76228.364368183466,62067.93286498791,62400.461612326508,63134.918610910412,76964.589738884242,56051.37577681386,71065.312868317866,{"$f":"N4-N6","v":823092}]
["Bruttoertrag / Stk.",{"$f":"B7/B3","v":1028.865},{"$f":"C7/C3","v":1028.865},1028.865,1028.8649999999998,1028.865,1028.865,1028.865,1028.865,1028.865,1028.865,1028.865,1028.865,{"$f":"N7/N3","v":1028.865}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":18786.435424280477},{"$f":"$N$10*C2","v":17632.762600769795},24628.813142505947,22031.02141961599,29210.591016513405,24099.547773382201,19622.73657152196,19727.865318530134,19960.063420530278,24332.304945075954,17720.605964633967,22467.252402639893,{"$f":"NW!N10+GW!N10","v":260220}]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":16480.955578947425},{"$f":"$N$11*C2","v":15468.862005711902},21606.354063273997,19327.364514624885,25625.854085961946,21142.040379437527,17214.625471453794,17306.852771118782,17510.555417105272,21346.233485832166,15545.925192264029,19710.061034268278,{"$f":"NW!N11+GW!N11","v":228285.68400000001}]
["Provisionen",{"$f":"$N$12*B2","v":324.66486389277344},{"$f":"$N$12*C2","v":304.72723220465696},425.63211626712808,380.73739956936777,504.81383734706122,416.48541732456908,339.11771734849629,340.93453941014786,344.94735841915497,420.50789810718476,306.24533040310422,388.27628970635556,{"$f":"NW!N12+GW!N12","v":4497.09}]
["Fertigmachen",{"$f":"$N$13*B2","v":944.36902843246321},{"$f":"$N$13*C2","v":886.37543577573126},1238.057556611958,1107.4700348171232,1468.377413553925,1211.4520930881888,986.40877062201389,991.69345238469225,1003.3657409821517,1223.1524853727742,890.7912044041658,1129.3987839548113,{"$f":"NW!N13+GW!N13","v":13080.911999999998}]
["Kulanz",{"$f":"$N$14*B2","v":1036.4459530078154},{"$f":"$N$14*C2","v":972.79792707750278},1358.7694063528634,1215.4494706046148,1611.5456796504711,1329.5698835319179,1082.5846120976585,1088.3845556165113,1101.194904023698,1342.4110757638271,977.64423756267058,1239.5162947104477,{"$f":"NW!N14+GW!N14","v":14356.313999999998}]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"NW!N15+GW!N15","v":0}]
["Bruttoertrag II",{"$f":"$N$16*B2","v":40636.225040871577},{"$f":"$N$16*C2","v":38140.759167706157},53273.650415604519,47654.465792414463,63184.320139293413,52128.816594801268,42445.196293465953,42672.596293796378,43174.855190380134,52632.284793808285,38330.769812179889,48598.060465677969,{"$f":"N7-N10","v":562872}]
["Direkte Kosten",{"$f":"$N$17/12","v":25791.666666666668},{"$f":"$N$17/12","v":25791.666666666668},25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,25791.666666666668,{"$f":"N18+N19+N20+N21+N22","v":309500}]
["Personalkosten",{"$f":"$N$18/12","v":9416.6666666666661},{"$f":"$N$18/12","v":9416.6666666666661},9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,9416.6666666666661,{"$f":"NW!N18+GW!N18","v":113000}]
["Werbekosten",{"$f":"$N$19/12","v":1683.3333333333333},{"$f":"$N$19/12","v":1683.3333333333333},1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,1683.3333333333333,{"$f":"NW!N19+GW!N19","v":20200}]
["Fahrzeugkosten",{"$f":"$N$20/12","v":5125},{"$f":"$N$20/12","v":5125},5125,5125,5125,5125,5125,5125,5125,5125,5125,5125,{"$f":"NW!N20+GW!N20","v":61500}]
["Abschreibungen",{"$f":"$N$21/12","v":9500},{"$f":"$N$21/12","v":9500},9500,9500,9500,9500,9500,9500,9500,9500,9500,9500,{"$f":"NW!N21+GW!N21","v":114000}]
["Gemeinkosten",{"$f":"$N$22/12","v":66.666666666666671},{"$f":"$N$22/12","v":66.666666666666671},66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,{"$f":"NW!N22+GW!N22","v":800}]
["Deckungsbeitrag",{"$f":"B16-B17","v":14844.558374204909},{"$f":"C16-C17","v":12349.092501039489},27481.983748937851,21862.799125747795,37392.653472626742,26337.1499281346,16653.529626799285,16880.92962712971,17383.188523713467,26840.618127141617,12539.103145513222,22806.393799011301,{"$f":"N16-N17","v":253372}]
["Deckungsbeitrag / Stk.",{"$f":"B23/B3","v":257.02394393184551},{"$f":"C23/C3","v":227.80611037661544},362.95708657222809,322.79129733384684,416.38648637518855,355.47623231071486,276.05613669699238,278.33444195845368,283.28149705351387,358.80620767383436,230.16463341021313,330.18500037422234,{"$f":"N23/N3","v":316.71499999999997}]

{"sheet":"NW","index":2,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,0,8,13],[10,15,13,15],[22,15,22,16],[24,15,24,16],[23,15,23,16]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2194433265238944E-2,6.7760981480169832E-2,9.4646119216455105E-2,8.4663059794081896E-2,0.1122534433037945,9.2612204186389213E-2,7.5408256750142039E-2,7.5812256239067455E-2,7.6704570826724605E-2,9.3506667224179357E-2,6.8098554932879751E-2,8.6339452780877304E-2,{"$f":"SUM(B2:M2)","v":1}]
["Neuwagen Stk.",{"$f":"$N$3*B2","v":25.989995975486021},{"$f":"$N$3*C2","v":24.393953332861141},34.072602917923838,30.478701525869482,40.411239589366019,33.340393507100117,27.146972430051132,27.292412246064284,27.613645497620858,33.662400200704568,24.51547977583671,31.082203001115829,{"$f":"360","v":360}]
["Umsatzerlöse",{"$f":"$N$4*B2","v":418438.9352053249},{"$f":"$N$4*C2","v":392742.64865906438},548568.90697857377,490707.09456649865,650620.95738879289,536780.33546431188,437066.25612382323,439407.83716163499,444579.69251169579,541964.64323134359,394699.22439097107,500423.46831796487,{"$f":"N3*N5","v":5796000}]
["Umsatz / Stk.",{"$f":"$N$5","v":16100},{"$f":"$N$5","v":16100},16100,16100,16100,16100,16100,16100,16100,16100,16100,16100,16100]
["Einsatzwerte",{"$f":"$N$6*B2","v":384126.94251848827},{"$f":"$N$6*C2","v":360537.75146902108},503586.25660633075,450469.11281204579,597270.0388829119,492764.34795623831,401226.82312166976,403376.3945143809,408124.15772573673,497523.54248637339,362333.88799091143,459388.74391589174,{"$f":"(N4-N4*O6)","v":5320728},8.2000000000000003E-2,"(BE!!!)"]
["Bruttoertrag",{"$f":"$N$7*B2","v":34311.992686836646},{"$f":"$N$7*C2","v":32204.897190043277},44982.65037224305,40237.981754452892,53350.918505881018,44015.987508073573,35839.433002153506,36031.442647254065,36455.534785959055,44441.100744970172,32365.336400059627,41034.724402073116,{"$f":"N4-N6+R6","v":475272}]
["Bruttoertrag / Stk.",{"$f":"$N$8","v":1320.2},{"$f":"$N$8","v":1320.2},1320.2,1320.2,1320.2,1320.2,1320.2,1320.2,1320.2,1320.2,1320.2,1320.2,{"$f":"N7/N3","v":1320.2}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":10590.923360010553},{"$f":"$N$10*C2","v":9940.5359831409151},13884.585689053964,12420.070871791815,16467.580132666651,13586.210354143297,11062.391265245837,11121.657990271196,11252.560540280499,13717.428081787111,9990.0580086534592,12665.9977229547,{"$f":"N3*R10","v":146700},null,null,"pro Fzg. ",407.5]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":10275.313843882239},{"$f":"$N$11*C2","v":9644.3080108433151},13470.825035520156,12049.952759812419,15976.846244713186,13181.341285589828,10732.732005541511,10790.232582161114,10917.23423618014,13308.648724949855,9692.3542799955867,12288.550990810651,{"$f":"N10*O11","v":142328.34},0.97019999999999995,{"$f":"SUM(O11:O14)","v":0.99999999999999989}]
["Provisionen",{"$f":"$N$12*B2","v":185.3411588001847},{"$f":"$N$12*C2","v":173.95937970496604},242.9802495584444,217.35124025635679,288.18265232166647,237.75868119750774,193.59184714180219,194.62901482974596,196.91980945490877,240.05499143127449,174.82601515143557,221.65496015170729,{"$f":"N10*O12","v":2567.2500000000005},1.7500000000000002E-2]
["Fertigmachen",{"$f":"$N$13*B2","v":-343.14591686434193},{"$f":"$N$13*C2","v":-322.07336585376561},-449.8605763253484,-402.41029624605477,-533.54959629839959,-440.19321547424283,-358.42147699396514,-360.34171888478676,-364.58296150508818,-444.44466984990243,-323.6778794803721,-410.3783262237323,{"$f":"N10*O13","v":-4753.08},-3.2399999999999998E-2]
["Kulanz",{"$f":"$N$14*B2","v":473.41427419247168},{"$f":"$N$14*C2","v":444.34195844639885},620.64098030071216,555.17716796909406,736.10083193019932,607.30360283020536,494.48888955648891,497.13811216512244,502.98945615053833,613.16903525588384,446.55559298680964,566.17009821607508,{"$f":"N10*O14","v":6557.49},4.4699999999999997E-2]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Bruttoertrag II",{"$f":"$N$16*B2","v":23721.069326826091},{"$f":"$N$16*C2","v":22264.361206902362},31098.064683189088,27817.910882661075,36883.338373214363,30429.777153930278,24777.041736907671,24909.784656982873,25202.974245678557,30723.672663183061,22375.278391406166,28368.726679118419,{"$f":"N7-N10","v":328572}]
["Direkte Kosten",{"$f":"$N$17/12","v":21941.666666666668},{"$f":"$N$17/12","v":21941.666666666668},21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,21941.666666666668,{"$f":"N18+N19+N20+N21+N22","v":263300}]
["Personalkosten",{"$f":"$N$18/12","v":5875},{"$f":"$N$18/12","v":5875},5875,5875,5875,5875,5875,5875,5875,5875,5875,5875,70500]
["Werbekosten",{"$f":"$N$19/12","v":1625},{"$f":"$N$19/12","v":1625},1625,1625,1625,1625,1625,1625,1625,1625,1625,1625,19500]
["Fahrzeugkosten",{"$f":"$N$20/12","v":4875},4875,4875,4875,4875,4875,4875,4875,4875,4875,4875,{"$f":"$N$20/12","v":4875},58500]
["Abschreibungen",{"$f":"$N$21/12","v":9500},9500,9500,9500,9500,9500,9500,9500,9500,9500,9500,{"$f":"$N$21/12","v":9500},114000]
["Gemeinkosten",{"$f":"$N$22/12","v":66.666666666666671},{"$f":"$N$22/12","v":66.666666666666671},66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,66.666666666666671,800]
["Deckungsbeitrag",{"$f":"B16-B17","v":1779.4026601594232},{"$f":"C16-C17","v":322.69454023569415},9156.3980165224202,5876.2442159944076,14941.671706547695,8488.1104872636097,2835.3750702410034,2968.1179903162047,3261.3075790118892,8782.0059965163928,433.61172473949773,6427.0600124517514,{"$f":"N16-N17","v":65272},null,"DB in % vom Umsatz"]
["Deckungsbeitrag / Stk.",{"$f":"$N$24","v":181.3111111111111},{"$f":"$N$24","v":181.3111111111111},181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,181.3111111111111,{"$f":"N23/N3","v":181.3111111111111},null,{"$f":"N23/N4","v":1.1261559696342306E-2}]
[{"$nulls":15},"Ziel > 3%"]

{"sheet":"GW","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,0,8,13],[31,11,31,12],[30,10,30,11],[10,15,14,15],[22,15,22,16],[23,15,23,16],[24,15,24,16],[21,15,21,20]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2194433265238944E-2,6.7760981480169832E-2,9.4646119216455105E-2,8.4663059794081896E-2,0.1122534433037945,9.2612204186389213E-2,7.5408256750142039E-2,7.5812256239067455E-2,7.6704570826724605E-2,9.3506667224179357E-2,6.8098554932879751E-2,8.6339452780877304E-2,{"$f":"SUM(B2:M2)","v":1}]
["GW Stk.",{"$f":"$N$3*B2","v":31.765550636705136},{"$f":"$N$3*C2","v":29.814831851274725},41.644292455240247,37.251746309396033,49.391515053669579,40.749369842011255,33.179632970062499,33.357392745189678,33.750011163758828,41.142933578638917,29.963364170467091,37.989359223586014,440,null,null,"GW pro NW",{"$f":"N3/NW!N3","v":1.2222222222222223}]
["Umsatzerlöse",{"$f":"$N$4*B2","v":270007.18041199364},{"$f":"$N$4*C2","v":253426.07073583518},353976.48586954211,316639.84362986631,419827.87795619143,346369.64365709567,282026.88024553121,283537.83833411225,286875.09489195002,349714.93541843077,254688.59544897027,322909.55340048112,{"$f":"N3*N5","v":3740000},null,null,"inkl. Export!!!"]
["Umsatz / Stk.",{"$f":"$N$5","v":8500},{"$f":"$N$5","v":8500},8500,8500,8500,8500,8500,8500,8500,8500,8500,8500,8500]
["Einsatzwerte",{"$f":"$N$6*B2","v":244896.51263367824},{"$f":"$N$6*C2","v":229857.4461574025},321056.67268367467,287192.33817228873,380783.88530626561,314157.26679698576,255798.38038269681,257168.81936903985,260195.71106699866,317191.44642451673,231002.55607221604,292878.96493423637,{"$f":"(N4-N4*O6)","v":3392180},9.2999999999999999E-2,"(BE!!!)"]
["Bruttoertrag",{"$f":"$N$7*B2","v":25110.667778315408},{"$f":"$N$7*C2","v":23568.624578432671},32919.813185867417,29447.505457577565,39043.9926499258,32212.376860109896,26228.499862834404,26369.018965072442,26679.383824951354,32523.488993914063,23686.039376754234,30030.588466244742,{"$f":"N4-N6","v":347820}]
["Bruttoertrag / Stk.",{"$f":"$N$8","v":790.5},{"$f":"$N$8","v":790.5},790.5,790.5,790.5,790.5,790.5,790.5,790.5,790.5,790.5,790.5,{"$f":"N7/N3","v":790.5}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":8195.5120642699258},{"$f":"$N$10*C2","v":7692.2266176288795},10744.227453451984,9610.9505478241772,12743.010883846751,10513.337419238904,8560.3453062761237,8606.2073282589372,8707.5028802497764,10614.87686328884,7730.547955980509,9801.2546796851911,{"$f":"N3*R10","v":113520},null,null,"pro Fzg.",258]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":6205.6417350651873},{"$f":"$N$11*C2","v":5824.5539948685873},8135.5290277538415,7277.4117548124668,9649.0078412487601,7960.6990938476974,6481.8934659122815,6516.6201889576669,6593.3211809251306,8037.5847608823096,5853.5709122684411,7421.510043457627,{"$f":"(N10*O11)","v":85957.343999999997},0.75719999999999998,{"$f":"SUM(O11:O15)","v":1}]
["Provisionen",{"$f":"$N$12*B2","v":139.32370509258874},{"$f":"$N$12*C2","v":130.76785249969095},182.65186670868374,163.38615931301101,216.63118502539479,178.72673612706137,145.52587020669412,146.30552458040194,148.02754896424622,180.4529066759103,131.41931525166868,166.62132955464827,{"$f":"N10*O12","v":1929.8400000000001},1.7000000000000001E-2]
["Fertigmachen",{"$f":"$N$13*B2","v":1287.5149452968051},{"$f":"$N$13*C2","v":1208.4488016294968},1687.9181329373064,1509.8803310631781,2001.9270098523245,1651.6453085624316,1344.830247615979,1352.035171269479,1367.9487024872399,1667.5971552226767,1214.4690838845379,1539.7771101785434,{"$f":"N10*O13","v":17833.991999999998},0.15709999999999999]
["Kulanz",{"$f":"$N$14*B2","v":563.03167881534387},{"$f":"$N$14*C2","v":528.45596863110404},738.12842605215121,660.27230263552087,875.44484772027181,722.26628070171262,588.09572254116972,591.24644345138893,598.20544787315964,729.24204050794333,531.08864457586094,673.34619649437263,{"$f":"N10*O14","v":7798.8239999999996},6.8699999999999997E-2]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O15","v":0},0]
["Bruttoertrag II",{"$f":"$N$16*B2","v":16915.155714045486},{"$f":"$N$16*C2","v":15876.397960803792},22175.585732415431,19836.554909753388,26300.98176607905,21699.039440870994,17668.154556558278,17762.811636813505,17971.880944701574,21908.612130625224,15955.491420773726,20229.333786559553,{"$f":"N7-N10","v":234300}]
["Direkte Kosten",{"$f":"$N$17/12","v":3850},{"$f":"$N$17/12","v":3850},3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,{"$f":"SUM(N18:N22)","v":46200}]
["Personalkosten",{"$f":"$N$18/12","v":3541.6666666666665},3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,3541.6666666666665,{"$f":"$N$18/12","v":3541.6666666666665},42500,{"$nulls":4},43000]
["Werbekosten",{"$f":"$N$19/12","v":58.333333333333336},{"$f":"$N$19/12","v":58.333333333333336},58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,58.333333333333336,700,{"$nulls":4},3000]
["Fahrzeugkosten",{"$f":"$N$20/12","v":250},250,250,250,250,250,250,250,250,250,250,{"$f":"$N$20/12","v":250},3000,{"$nulls":4},500]
["Abschreibungen",{"$f":"$N$21/12","v":0},{"$f":"$N$21/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"(S21/10)*12","v":0}]
["Gemeinkosten",{"$f":"$N$22/12","v":0},{"$f":"$N$22/12","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Gebrauchtwagen KPIs"]
["Deckungsbeitrag",{"$f":"B16-B17","v":13065.155714045486},{"$f":"C16-C17","v":12026.397960803792},18325.585732415431,15986.554909753388,22450.98176607905,17849.039440870994,13818.154556558278,13912.811636813505,14121.880944701574,18058.612130625224,12105.491420773726,16379.333786559553,{"$f":"N16-N17","v":188100},null,"DB in % vom Umsatz",null,null,"Umschlag GW",null,"Lagerdauer"]
["Deckungsbeitrag / Stk.",{"$f":"B23/B3","v":411.29951951623599},{"$f":"C23/C3","v":403.36963900366948},440.0503562910086,429.14914047186795,454.55138887081046,438.02001135411973,416.46496117139685,417.08330573347371,418.42596365911197,438.92378495832662,404.00975510971858,431.15583208864194,{"$f":"N23/N3","v":427.5},null,{"$f":"N23/N4","v":5.0294117647058822E-2},null,null,{"$f":"(N4/S26)","v":5.0884353741496602},null,{"$f":"360/S24","v":70.748663101604279}]
[{"$nulls":15},"Ziel > 3%",null,null,"Ziel: 6 - 8",null,"Ziel: 45 Tage"]
[{"$nulls":18},735000]
[{"$nulls":18},"VK vs. VK (!!!)"]

{"sheet":"Aftersales","index":4,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[29,11,29,12],[32,11,32,12]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2","v":1334.773574401657},{"$f":"$N$3*C2","v":1178.5429400472806},1621.4182891260891,1727.4499261254145,1446.2453018475712,1585.7735511552473,1408.1884047316739,1464.7883786293762,1336.8285454873289,1897.178476073331,1850.5745858727657,1578.2380265022643,{"$f":"ME!N3+KA!N3+LA!N3+'T&Z'!N3","v":18430}]
["Umsatzerlöse",{"$f":"$N$4*B2","v":252440.22052960479},{"$f":"$N$4*C2","v":222892.96506526269},306652.15308986593,326705.47924237343,273522.40854930464,299910.81082279794,266324.86457266711,277029.38417563483,252828.86873481184,358805.5398074988,349991.53828290169,298485.64812727628,{"$f":"ME!N4+KA!N4+LA!N4+'T&Z'!N4+MW!N3","v":3485589.8810000001}]
["Umsatz / Stk.",{"$f":"B4/B3","v":189.12587525773196},{"$f":"C4/C3","v":189.12587525773199},189.12587525773196,189.12587525773196,189.12587525773193,189.12587525773196,189.12587525773193,189.12587525773193,189.12587525773196,189.12587525773196,189.12587525773196,189.12587525773193,189.12587525773196]
["Einsatzwerte",{"$f":"$N$6*B2","v":113734.65849560508},{"$f":"$N$6*C2","v":100422.4097474891},138159.35446201105,147194.19921405386,123233.04765772159,135122.10366679932,119990.25930778046,124813.08381192981,113909.76042984288,161656.59121483495,157685.52253458783,134480.00950234418,{"$f":"ME!N6+KA!N6+LA!N6+'T&Z'!N5+MW!N4","v":1570401.0000450001}]
["Bruttoertrag",{"$f":"$N$7*B2","v":138705.56203399971},{"$f":"$N$7*C2","v":122470.55531777357},168492.79862785488,179511.2800283196,150289.36089158308,164788.70715599862,146334.60526488666,152216.30036370503,138919.10830496895,197148.94859266386,192306.01574831389,164005.63862493212,{"$f":"N4-N6","v":1915188.8809549999}]
["Bruttoertrag / Stk.",{"$f":"B7/B3","v":103.91692246093325},{"$f":"C7/C3","v":103.91692246093326},103.91692246093326,103.91692246093326,103.91692246093326,103.91692246093326,103.91692246093326,103.91692246093325,103.91692246093325,103.91692246093325,103.91692246093326,103.91692246093325,{"$f":"N7/N3","v":103.91692246093326}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":3230.1085956762836},{"$f":"$N$10*C2","v":2852.0355467232075},3923.779473414193,4180.3725830273188,3499.8665470646597,3837.5203679611518,3407.7700950099106,3544.7401891953432,3235.0815588027604,4591.1101482838067,4478.3302512167857,3819.2846436245786,{"$f":"SUM(N11:N15)","v":44600}]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":0},{"$f":"$N$11*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N11+KA!N11+LA!N11+'T&Z'!N9+MW!N8","v":0}]
["Provisionen",{"$f":"$N$12*B2","v":0},{"$f":"$N$12*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N12+KA!N12+LA!N12+'T&Z'!N10+MW!N9","v":0}]
["Fertigmachen",{"$f":"$N$13*B2","v":0},{"$f":"$N$13*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N13+KA!N13+LA!N13+'T&Z'!N11+MW!N10","v":0}]
["Kulanz",{"$f":"$N$14*B2","v":3230.1085956762836},{"$f":"$N$14*C2","v":2852.0355467232075},3923.779473414193,4180.3725830273188,3499.8665470646597,3837.5203679611518,3407.7700950099106,3544.7401891953432,3235.0815588027604,4591.1101482838067,4478.3302512167857,3819.2846436245786,{"$f":"ME!N14+KA!N14+LA!N14+'T&Z'!N12+MW!N11","v":44600}]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N15+KA!N15+LA!N15+'T&Z'!N13+MW!N12","v":0}]
["Bruttoertrag II",{"$f":"$N$16*B2","v":135475.45343832343},{"$f":"$N$16*C2","v":119618.51977105037},164569.01915444067,175330.90744529225,146789.4943445184,160951.18678803745,142926.83516987675,148671.56017450968,135684.0267461662,192557.83844438006,187827.68549709709,160186.35398130753,{"$f":"N7-N10","v":1870588.8809549999}]
["Direkte Kosten",{"$f":"$N$17/12","v":70883.333333333328},{"$f":"$N$17/12","v":70883.333333333328},70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,70883.333333333328,{"$f":"SUM(N18:N22)","v":850600}]
["Personalkosten",{"$f":"$N$18/12","v":58364.521666666667},{"$f":"$N$18/12","v":58364.521666666667},58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,58364.521666666667,{"$f":"ME!N18+KA!N18+LA!N18+'T&Z'!N16+MW!N15","v":700374.26}]
["Werbekosten",{"$f":"$N$19/12","v":981.35416666666663},{"$f":"$N$19/12","v":981.35416666666663},981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,981.35416666666663,{"$f":"ME!N19+KA!N19+LA!N19+'T&Z'!N17+MW!N16","v":11776.25}]
["Fahrzeugkosten",{"$f":"$N$20/12","v":3183.1825000000003},{"$f":"$N$20/12","v":3183.1825000000003},3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,3183.1825000000003,{"$f":"ME!N20+KA!N20+LA!N20+'T&Z'!N18+MW!N17","v":38198.19}]
["Abschreibungen",{"$f":"$N$21/12","v":3624.8333333333335},{"$f":"$N$21/12","v":3624.8333333333335},3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,{"$f":"ME!N21+KA!N21+LA!N21+'T&Z'!N19+MW!N18","v":43498}]
["Gemeinkosten",{"$f":"$N$22/12","v":4729.4416666666666},{"$f":"$N$22/12","v":4729.4416666666666},4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,4729.4416666666666,{"$f":"ME!N22+KA!N22+LA!N22+'T&Z'!N20+MW!N19","v":56753.299999999996}]
["Deckungsbeitrag",{"$f":"B16-B17","v":64592.120104990099},{"$f":"C16-C17","v":48735.186437717042},93685.685821107341,104447.57411195892,75906.161011185075,90067.85345470412,72043.501836543423,77788.226841176351,64800.693412832872,121674.50511104673,116944.35216376376,89303.020647974205,{"$f":"N16-N17","v":1019988.8809549999}]
["Deckungsbeitrag / Stk.",{"$f":"B23/B3","v":48.39181816582262},{"$f":"C23/C3","v":41.352066846000447},57.780084540431567,60.463445297213163,52.484983642965219,56.797424442530932,51.160414042942712,53.105436919129524,48.473451312494497,64.13445368771076,63.193536243561134,56.584000099078892,{"$f":"N23/N3","v":55.343943622083557}]

{"sheet":"Service","index":5,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[29,11,29,12],[32,11,32,12]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2","v":1334.773574401657},{"$f":"$N$3*C2","v":1178.5429400472806},1621.4182891260891,1727.4499261254145,1446.2453018475712,1585.7735511552473,1408.1884047316739,1464.7883786293762,1336.8285454873289,1897.178476073331,1850.5745858727657,1578.2380265022643,{"$f":"ME!N3+KA!N3+LA!N3","v":18430}]
["Umsatzerlöse",{"$f":"$N$4*B2","v":118313.10567004659},{"$f":"$N$4*C2","v":104464.96550173851},143721.03033483832,153119.5774092309,128193.85737315335,140561.51344672806,124820.52891033473,129837.49869540303,118495.25642270663,168164.16043838882,164033.23434599413,139893.57145143699,{"$f":"ME!N4+KA!N4+LA!N4","v":1633618.3}]
["Umsatz / Stk.",{"$f":"B4/B3","v":88.639083016820408},{"$f":"C4/C3","v":88.639083016820422},88.639083016820408,88.639083016820408,88.639083016820408,88.639083016820393,88.639083016820408,88.639083016820408,88.639083016820408,88.639083016820408,88.639083016820408,88.639083016820393,88.639083016820408]
["Einsatzwerte",{"$f":"$N$6*B2","v":32080.868617422424},{"$f":"$N$6*C2","v":28325.913806464272},38970.285376422369,41518.722865073149,34760.056991639802,38113.575161539942,33845.371280312953,35205.734087297416,32130.259209711905,45598.095888280921,44477.985850699959,37932.461165134926,{"$f":"ME!N6+KA!N6+LA!N6","v":442959.33030000003}]
["Bruttoertrag",{"$f":"$N$7*B2","v":86232.237052624158},{"$f":"$N$7*C2","v":76139.051695274233},104750.74495841595,111600.85454415774,93433.800381513545,102447.93828518812,90975.157630021786,94631.764608105615,86364.997212994727,122566.06455010788,119555.24849529417,101961.11028630208,{"$f":"N4-N6","v":1190658.9697},{"$f":"N7/N4","v":0.72884771779307322}]
["Bruttoertrag / Stk.",{"$f":"B7/B3","v":64.604393364080309},{"$f":"C7/C3","v":64.604393364080309},64.604393364080295,64.604393364080309,64.604393364080309,64.604393364080309,64.604393364080309,64.604393364080295,64.604393364080309,64.604393364080295,64.604393364080309,64.604393364080309,{"$f":"N7/N3","v":64.604393364080309}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":1817.8413845622133},{"$f":"$N$10*C2","v":1605.069332348711},2208.2256677734586,2352.6312070400381,1969.6558370251785,2159.680745197868,1917.8257709584925,1994.9098374171101,1820.640070088549,2583.7862045274342,2520.3159037116889,2149.4180393492584,{"$f":"SUM(N11:N15)","v":25100}]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":0},{"$f":"$N$11*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N11+KA!N11+LA!N11","v":0}]
["Provisionen",{"$f":"$N$12*B2","v":0},{"$f":"$N$12*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N12+KA!N12+LA!N12","v":0}]
["Fertigmachen",{"$f":"$N$13*B2","v":0},{"$f":"$N$13*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N13+KA!N13+LA!N13","v":0}]
["Kulanz",{"$f":"$N$14*B2","v":1817.8413845622133},{"$f":"$N$14*C2","v":1605.069332348711},2208.2256677734586,2352.6312070400381,1969.6558370251785,2159.680745197868,1917.8257709584925,1994.9098374171101,1820.640070088549,2583.7862045274342,2520.3159037116889,2149.4180393492584,{"$f":"ME!N14+KA!N14+LA!N14","v":25100}]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N15+KA!N15+LA!N15","v":0}]
["Bruttoertrag II",{"$f":"$N$16*B2","v":84414.395668061945},{"$f":"$N$16*C2","v":74533.982362925526},102542.51929064249,109248.2233371177,91464.144544488372,100288.25753999026,89057.331859063299,92636.8547706885,84544.35714290617,119982.27834558046,117034.93259158249,99811.692246952822,{"$f":"N7-N10","v":1165558.9697}]
["Direkte Kosten",{"$f":"$N$17/12","v":43633.333333333336},{"$f":"$N$17/12","v":43633.333333333336},43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,43633.333333333336,{"$f":"SUM(N18:N22)","v":523600.00000000006}]
["Personalkosten",{"$f":"$N$18/12","v":37230.555},{"$f":"$N$18/12","v":37230.555},37230.555,37230.555,37230.555,37230.555,37230.555,37230.555,37230.555,37230.555,37230.555,37230.555,{"$f":"ME!N18+KA!N18+LA!N18","v":446766.66000000003}]
["Werbekosten",{"$f":"$N$19/12","v":1106.8958333333333},{"$f":"$N$19/12","v":1106.8958333333333},1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,{"$f":"ME!N19+KA!N19+LA!N19","v":13282.75}]
["Fahrzeugkosten",{"$f":"$N$20/12","v":690.65749999999991},{"$f":"$N$20/12","v":690.65749999999991},690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,690.65749999999991,{"$f":"ME!N20+KA!N20+LA!N20","v":8287.89}]
["Abschreibungen",{"$f":"$N$21/12","v":0},{"$f":"$N$21/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ME!N21+KA!N21+LA!N21","v":0}]
["Gemeinkosten",{"$f":"$N$22/12","v":4605.2249999999995},{"$f":"$N$22/12","v":4605.2249999999995},4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,4605.2249999999995,{"$f":"ME!N22+KA!N22+LA!N22","v":55262.7}]
["Deckungsbeitrag",{"$f":"B16-B17","v":40781.062334728609},{"$f":"C16-C17","v":30900.64902959219},58909.185957309157,65614.890003784356,47830.811211155036,56654.92420665692,45423.998525729963,49003.521437355164,40911.023809572835,76348.945012247132,73401.59925824916,56178.358913619486,{"$f":"N16-N17","v":641958.96970000002}]
["Deckungsbeitrag / Stk.",{"$f":"B23/B3","v":30.552794209317231},{"$f":"C23/C3","v":26.219366286605155},36.331886936504205,37.983671197321094,33.072405594024339,35.726995298530113,32.257046268169894,33.454335214762196,30.60304475669248,40.243417251006193,39.664220949857899,35.595618639428899,{"$f":"N23/N3","v":34.832282674986438}]

{"sheet":"ME","index":6,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[10,15,14,15],[17,15,21,15]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2","v":995.82944373428018},{"$f":"$N$3*C2","v":879.27104859740143},1209.6853757723129,1288.7919958884672,1078.9947314380956,1183.0920416920592,1050.6017669593334,1092.8290942026001,997.36258819591831,1415.4207295718015,1380.6511424715427,1177.4700414761874,13750]
["Umsatzerlöse",{"$f":"$N$4*B2","v":65027.6626758485},{"$f":"$N$4*C2","v":57416.399473410318},78992.455037932028,84158.1173315169,70458.355962907648,77255.910322491458,68604.29538244447,71361.739851429797,65127.777009193465,92426.973641038639,90156.519603391731,76888.793708395038,{"$f":"N3*N5","v":897875}]
["Umsatz / Stk.",{"$f":"$N$5","v":65.3},{"$f":"$N$5","v":65.3},65.3,65.3,65.3,65.3,65.3,65.3,65.3,65.3,65.3,65.3,65.3]
["Einsatzwerte",{"$f":"$N$6*B2","v":15606.639042203638},{"$f":"$N$6*C2","v":13779.935873618475},18958.189209103686,20197.948159564057,16910.005431097838,18541.41847739795,16465.030891786675,17126.81756434315,15630.66648220643,22182.473673849272,21637.564704814016,18453.31049001481,{"$f":"(N4*O6)","v":215490},0.24,"(EW!!)"]
["Bruttoertrag",{"$f":"$N$7*B2","v":49421.023633644858},{"$f":"$N$7*C2","v":43636.463599791838},60034.265828828342,63960.169171952846,53548.350531809818,58714.491845093515,52139.264490657799,54234.922287086643,49497.110526987031,70244.49996718936,68518.954898577722,58435.483218380228,{"$f":"N4-N6","v":682385}]
["Bruttoertrag / Stk.",{"$f":"$N$8","v":49.628},{"$f":"$N$8","v":49.628},49.628,49.628,49.628,49.628,49.628,49.628,49.628,49.628,49.628,49.628,{"$f":"N7/N3","v":49.628}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":1774.3870088356266},{"$f":"$N$10*C2","v":1566.701141137188},2155.4393968306663,2296.3930108558143,1922.5724305624251,2108.0549106513054,1871.9813302184489,1947.2227496700878,1777.1187935127271,2522.0223908733919,2460.0693084038394,2098.0375284484794,24500]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":0},{"$f":"$N$11*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O11","v":0},0,{"$f":"SUM(O11:O15)","v":1}]
["Provisionen",{"$f":"$N$12*B2","v":0},{"$f":"$N$12*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O12","v":0},0]
["Fertigmachen",{"$f":"$N$13*B2","v":0},{"$f":"$N$13*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O13","v":0},0]
["Kulanz",{"$f":"$N$14*B2","v":1774.3870088356266},{"$f":"$N$14*C2","v":1566.701141137188},2155.4393968306663,2296.3930108558143,1922.5724305624251,2108.0549106513054,1871.9813302184489,1947.2227496700878,1777.1187935127271,2522.0223908733919,2460.0693084038394,2098.0375284484794,{"$f":"N10*O14","v":24500},1]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O15","v":0},0]
["Bruttoertrag II",{"$f":"$N$16*B2","v":47646.636624809231},{"$f":"$N$16*C2","v":42069.762458654652},57878.826431997673,61663.776161097034,51625.778101247393,56606.436934442208,50267.28316043935,52287.699537416556,47719.991733474308,67722.477576315971,66058.885590173872,56337.445689931752,{"$f":"N7-N10","v":657885},{"$f":"N16/N4","v":0.73271335096756229},"Ziel > 65%"]
["Direkte Kosten",{"$f":"$N$17/12","v":33041.666666666664},33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,33041.666666666664,{"$f":"$N$17/12","v":33041.666666666664},396500]
["Personalkosten",{"$f":"$N$18/12","v":29294.741666666669},29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,29294.741666666669,{"$f":"$N$18/12","v":29294.741666666669},{"$f":"$N$17*O18","v":351536.9},0.88660000000000005,{"$f":"SUM(O18:O22)","v":1}]
["Werbekosten",{"$f":"$N$19/12","v":1106.8958333333333},1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,1106.8958333333333,{"$f":"$N$19/12","v":1106.8958333333333},{"$f":"$N$17*O19","v":13282.75},3.3500000000000002E-2]
["Fahrzeugkosten",{"$f":"$N$20/12","v":571.62083333333328},571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,571.62083333333328,{"$f":"$N$20/12","v":571.62083333333328},6859.45,1.7299999999999999E-2]
["Abschreibungen",{"$f":"$N$21/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"$N$21/12","v":0},0,0]
["Gemeinkosten",{"$f":"$N$22/12","v":2068.4083333333333},2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,2068.4083333333333,{"$f":"$N$22/12","v":2068.4083333333333},24820.9,6.2600000000000003E-2]
["Deckungsbeitrag",{"$f":"B16-B17","v":14604.969958142567},{"$f":"C16-C17","v":9028.0957919879875},24837.159765331009,28622.10949443037,18584.111434580729,23564.770267775544,17225.616493772686,19246.032870749892,14678.325066807643,34680.810909649306,33017.218923507207,23295.779023265088,{"$f":"N16-N17","v":261385}]
["Deckungsbeitrag / Stk.",{"$f":"$N$24","v":19.009818181818183},{"$f":"$N$24","v":19.009818181818183},19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,19.009818181818183,{"$f":"N23/N3","v":19.009818181818183}]

{"sheet":"KA","index":7,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[10,15,14,15],[17,15,21,15]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2","v":177.43870088356266},{"$f":"$N$3*C2","v":156.6701141137188},215.54393968306664,229.63930108558142,192.25724305624252,210.80549106513055,187.19813302184488,194.72227496700876,177.7118793512727,252.20223908733917,246.00693084038394,209.80375284484793,2450]
["Umsatzerlöse",{"$f":"$N$4*B2","v":19819.902888693949},{"$f":"$N$4*C2","v":17500.051746502391},24076.258062598547,25650.709931259444,21475.13404938229,23546.973351975081,20910.031458540074,21750.478113814879,19850.416923537163,28170.990106055786,27478.974174870888,23435.079192769514,{"$f":"N3*N5","v":273665}]
["Umsatz / Stk.",{"$f":"$N$5","v":111.7},{"$f":"$N$5","v":111.7},111.7,111.7,111.7,111.7,111.7,111.7,111.7,111.7,111.7,111.7,111.7]
["Einsatzwerte",{"$f":"$N$6*B2","v":3389.2033939666653},{"$f":"$N$6*C2","v":2992.5088486519089},4117.0401287043514,4386.2713982453652,3672.2479224443719,4026.5324431877393,3575.6153794103529,3719.3317574623447,3394.421293924855,4817.2393081355394,4698.9045839029222,4007.3985419635874,{"$f":"N4*O6","v":46796.715000000004},0.17100000000000001,"(EW!!!)"]
["Bruttoertrag",{"$f":"$N$7*B2","v":16430.699494727283},{"$f":"$N$7*C2","v":14507.542897850482},19959.217933894193,21264.438533014079,17802.886126937919,19520.440908787343,17334.416079129722,18031.146356352536,16455.995629612305,23353.750797920246,22780.069590967967,19427.680650805927,{"$f":"N4-N6","v":226868.285}]
["Bruttoertrag / Stk.",{"$f":"$N$8","v":92.599299999999999},{"$f":"$N$8","v":92.599299999999999},92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,92.599299999999999,{"$f":"N7/N3","v":92.599299999999999}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":43.454375726586775},{"$f":"$N$10*C2","v":38.368191211522969},52.78627094279183,56.238196184224023,47.083406462753267,51.625834546562579,45.844440740043645,47.687087747022552,43.521276575821886,61.763813654042245,60.246595307849134,51.380510900779086,600]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":0},{"$f":"$N$11*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O11","v":0},0,{"$f":"SUM(O11:O15)","v":1}]
["Provisionen",{"$f":"$N$12*B2","v":0},{"$f":"$N$12*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O12","v":0},0]
["Fertigmachen",{"$f":"$N$13*B2","v":0},{"$f":"$N$13*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O13","v":0},0]
["Kulanz",{"$f":"$N$14*B2","v":43.454375726586775},{"$f":"$N$14*C2","v":38.368191211522969},52.78627094279183,56.238196184224023,47.083406462753267,51.625834546562579,45.844440740043645,47.687087747022552,43.521276575821886,61.763813654042245,60.246595307849134,51.380510900779086,{"$f":"N10*O14","v":600},1]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O15","v":0},0]
["Bruttoertrag II",{"$f":"$N$16*B2","v":16387.245119000698},{"$f":"$N$16*C2","v":14469.17470663896},19906.431662951403,21208.200336829857,17755.802720475163,19468.815074240782,17288.571638389676,17983.459268605511,16412.474353036487,23291.986984266205,22719.822995660117,19376.30013990515,{"$f":"N7-N10","v":226268.285}]
["Direkte Kosten",{"$f":"$N$17/12","v":3333.3333333333335},{"$f":"$N$17/12","v":3333.3333333333335},3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,40000]
["Personalkosten",{"$f":"$N$18/12","v":2524},{"$f":"$N$18/12","v":2524},2524,2524,2524,2524,2524,2524,2524,2524,2524,2524,{"$f":"$N$17*O18","v":30288},0.75719999999999998,{"$f":"SUM(O18:O22)","v":1}]
["Werbekosten",{"$f":"$N$19/12","v":0},{"$f":"$N$19/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"$N$17*O19","v":0},0]
["Fahrzeugkosten",{"$f":"$N$20/12","v":0},{"$f":"$N$20/12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Abschreibungen",{"$f":"$N$21/12","v":0},{"$f":"$N$21/12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Gemeinkosten",{"$f":"$N$22/12","v":809.33333333333337},{"$f":"$N$22/12","v":809.33333333333337},809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,809.33333333333337,9712,0.24279999999999999]
["Deckungsbeitrag",{"$f":"B16-B17","v":13053.911785667364},{"$f":"C16-C17","v":11135.841373305626},16573.098329618071,17874.867003496525,14422.469387141829,16135.481740907448,13955.238305056342,14650.125935272177,13079.141019703153,19958.653650932873,19386.489662326785,16042.966806571816,{"$f":"N16-N17","v":186268.285}]
["Deckungsbeitrag / Stk.",{"$f":"$N$24","v":76.02787142857143},{"$f":"$N$24","v":76.02787142857143},76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,76.02787142857143,{"$f":"N23/N3","v":76.02787142857143}]

{"sheet":"LA","index":8,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,13],[10,15,14,15],[17,15,21,15]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2","v":161.50542978381418},{"$f":"$N$3*C2","v":142.60177733616038},196.18897367070966,209.01862915136596,174.99332735323298,191.8760183980576,170.38850475049554,177.23700945976717,161.75407794013802,229.55550741419034,223.91651256083927,190.96423218122894,2230]
["Umsatzerlöse",{"$f":"$N$4*B2","v":33465.540105504137},{"$f":"$N$4*C2","v":29548.514281825795},40652.317234307753,43310.750146454542,36260.367360863413,39758.62977226152,35306.202069350184,36725.28073015836,33517.062489976001,47566.19669129439,46397.740567731511,39569.698550272449,{"$f":"N3*N5","v":462078.30000000005}]
["Umsatz / Stk.",{"$f":"$N$5","v":207.21},{"$f":"$N$5","v":207.21},207.21,207.21,207.21,207.21,207.21,207.21,207.21,207.21,207.21,{"$f":"$N$5","v":207.21},207.21]
["Einsatzwerte",{"$f":"$N$6*B2","v":13085.026181252118},{"$f":"$N$6*C2","v":11553.469084193886},15895.056038614332,16934.503307263727,14177.803638097594,15545.624240954256,13804.725009115924,14359.58476549192,13105.171433580617,18598.382906296109,18141.516561983022,15471.752133156529,{"$f":"N4*O6","v":180672.61530000003},0.39100000000000001,"(EW!!!)"]
["Bruttoertrag",{"$f":"$N$7*B2","v":20380.513924252016},{"$f":"$N$7*C2","v":17995.045197631905},24757.261195693416,26376.246839190811,22082.563722765812,24213.005531307263,21501.477060234258,22365.695964666436,20411.891056395383,28967.813784998278,28256.224005748485,24097.94641711592,{"$f":"N4-N6","v":281405.68469999998}]
["Bruttoertrag / Stk.",{"$f":"B7/B3","v":126.19088999999998},126.19088999999998,126.19088999999998,126.19088999999998,126.19088999999998,126.19089,126.19088999999998,126.19089,126.19089,126.19089,126.19089,126.19089,{"$f":"N7/N3","v":126.19089}]
[]
["Variable Kosten",{"$f":"$N$10*B2","v":0},{"$f":"$N$10*C2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Fixum/Prov./Soz.",{"$f":"$N$11*B2","v":0},{"$f":"$N$11*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O11","v":0},0,{"$f":"SUM(O11:O15)","v":1}]
["Provisionen",{"$f":"$N$12*B2","v":0},{"$f":"$N$12*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O12","v":0},0]
["Fertigmachen",{"$f":"$N$13*B2","v":0},{"$f":"$N$13*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O13","v":0},0]
["Kulanz",{"$f":"$N$14*B2","v":0},{"$f":"$N$14*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O14","v":0},1]
["sonst. variable Kosten",{"$f":"$N$15*B2","v":0},{"$f":"$N$15*C2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N10*O15","v":0},0]
["Bruttoertrag II",{"$f":"$N$16*B2","v":20380.513924252016},{"$f":"$N$16*C2","v":17995.045197631905},24757.261195693416,26376.246839190811,22082.563722765812,24213.005531307263,21501.477060234258,22365.695964666436,20411.891056395383,28967.813784998278,28256.224005748485,24097.94641711592,{"$f":"N7-N10","v":281405.68469999998}]
["Direkte Kosten",{"$f":"$N$17/12","v":7258.333333333333},{"$f":"$N$17/12","v":7258.333333333333},7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,7258.333333333333,87100]
["Personalkosten",{"$f":"$N$18/12","v":5411.8133333333335},{"$f":"$N$18/12","v":5411.8133333333335},5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,5411.8133333333335,{"$f":"$N$17*O18","v":64941.760000000002},0.74560000000000004,{"$f":"SUM(O18:O22)","v":1}]
["Werbekosten",{"$f":"$N$19/12","v":0},{"$f":"$N$19/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"$N$17*O19","v":0},0]
["Fahrzeugkosten",{"$f":"$N$20/12","v":119.03666666666668},{"$f":"$N$20/12","v":119.03666666666668},119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,119.03666666666668,1428.44,1.6400000000000001E-2]
["Abschreibungen",{"$f":"$N$21/12","v":0},{"$f":"$N$21/12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Gemeinkosten",{"$f":"$N$22/12","v":1727.4833333333333},{"$f":"$N$22/12","v":1727.4833333333333},1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,1727.4833333333333,20729.8,0.23799999999999999]
["Deckungsbeitrag",{"$f":"B16-B17","v":13122.180590918684},{"$f":"C16-C17","v":10736.711864298573},17498.927862360084,19117.913505857479,14824.23038943248,16954.67219797393,14243.143726900926,15107.362631333104,13153.557723062051,21709.480451664946,20997.890672415153,16839.613083782588,{"$f":"N16-N17","v":194305.68469999998}]
["Deckungsbeitrag / Stk.",{"$f":"B23/B3","v":81.249160529671357},75.291571149134626,89.194247438853964,91.465117647541234,84.713118000831031,88.362643437808416,83.592163378377805,85.23819419759775,81.318244897231722,94.571812701031021,93.775534605604037,88.182027029027367,{"$f":"N23/N3","v":87.132594035874433}]

{"sheet":"T&Z","index":9,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,0,6,13],[8,15,12,15],[15,15,19,15]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["verk. Stunden",{"$f":"$N$3*B2*$O$3","v":0},{"$f":"$N$3*C2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Umsatzerlöse",{"$f":"$N$4*B2","v":126595.02306694986},{"$f":"$N$4*C2","v":111777.51308686021},153781.50245827701,163837.94782787707,137167.42738927409,150400.81938799904,133557.96593405819,138926.12360408125,126789.9243722961,179935.65166907603,175515.56075021374,149686.1214530376,{"$f":"(ME!N4+KA!N4+LA!N4)*S4","v":1747971.5810000002},null,null,null,"Faktor Umsatz ME+KA+LA",1.07]
["Einsatzwerte",{"$f":"$N$5*B2","v":81653.789878182652},72096.495941024827,99189.069085588679,105675.47634898071,88472.990666081794,97008.528505259383,86144.888027467518,89607.349724632411,81779.501220130987,116058.49532655404,113207.53668388785,96547.548337209257,{"$f":"N4*(O5)","v":1127441.6697450001},0.64500000000000002,"(EW!!!)"]
["Bruttoertrag",{"$f":"$N$6*B2","v":44941.233188767204},39681.01714583538,54592.433372688349,58162.471478896368,48694.43672319231,53392.290882739668,47413.077906590661,49318.773879448854,45010.423152165124,63877.156342522001,62308.024066325888,53138.57311582836,{"$f":"N4-N5","v":620529.91125500016}]
[]
["Variable Kosten",{"$f":"$N$8*B2","v":1412.2672111140701},1246.9662143744965,1715.5538056407345,1827.7413759872807,1530.2107100394812,1677.8396227632838,1489.9443240514183,1549.8303517782331,1414.4414887142113,2007.323943756373,1958.0143475050968,1669.8666042753202,19500]
["Fixum/Prov./Soz.",{"$f":"$N$9*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N8*O9","v":0},0,{"$f":"SUM(O9:O13)","v":1}]
["Provisionen",{"$f":"$N$10*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N8*O10","v":0},0]
["Fertigmachen",{"$f":"$N$11*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N8*O11","v":0},0]
["Kulanz",{"$f":"$N$12*B2","v":1412.2672111140701},1246.9662143744965,1715.5538056407345,1827.7413759872807,1530.2107100394812,1677.8396227632838,1489.9443240514183,1549.8303517782331,1414.4414887142113,2007.323943756373,1958.0143475050968,1669.8666042753202,{"$f":"N8*O12","v":19500},1]
["sonst. variable Kosten",{"$f":"$N$13*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N8*O13","v":0},0]
["Bruttoertrag II",{"$f":"$N$14*B2","v":43528.965977653133},38434.050931460879,52876.879567047617,56334.730102909089,47164.226013152831,51714.451259976384,45923.133582539238,47768.943527670621,43595.981663450912,61869.832398765633,60350.009718820787,51468.706511553035,{"$f":"N6-N8","v":601029.91125500016}]
["Direkte Kosten",{"$f":"$N$15/12","v":21416.666666666668},{"$f":"$N$15/12","v":21416.666666666668},21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,21416.666666666668,257000]
["Personalkosten",{"$f":"$N$16/12","v":21133.966666666667},{"$f":"$N$16/12","v":21133.966666666667},21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,21133.966666666667,{"$f":"$N$15*O16","v":253607.6},0.98680000000000001,{"$f":"SUM(O16:O20)","v":1}]
["Werbekosten",{"$f":"$N$17/12","v":53.541666666666664},{"$f":"$N$17/12","v":53.541666666666664},53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,53.541666666666664,{"$f":"$N$15*O17","v":642.5},2.5000000000000001E-3]
["Fahrzeugkosten",{"$f":"$N$18/12","v":104.94166666666666},{"$f":"$N$18/12","v":104.94166666666666},104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,104.94166666666666,1259.3,4.8999999999999998E-3]
["Abschreibungen",{"$f":"$N$19/12","v":0},{"$f":"$N$19/12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Gemeinkosten",{"$f":"$N$20/12","v":124.21666666666665},{"$f":"$N$20/12","v":124.21666666666665},124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,124.21666666666665,1490.6,5.7999999999999996E-3]
["Deckungsbeitrag",{"$f":"B14-B15","v":22112.299310986466},{"$f":"C14-C15","v":17017.384264794211},31460.21290038095,34918.063436242417,25747.559346486163,30297.784593309716,24506.46691587257,26352.276861003953,22179.314996784244,40453.165732098962,38933.343052154116,30052.039844886367,{"$f":"N14-N15","v":344029.91125500016}]

{"sheet":"MW","index":10,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,0,5,13],[7,15,11,15],[14,15,18,15]]}
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Gesamt"]
["Saison ",7.2423959544311287E-2,6.3946985352538288E-2,8.7977118237986388E-2,9.3730326973706701E-2,7.8472344104588782E-2,8.6043057577604304E-2,7.6407401233406072E-2,7.9478479578370925E-2,7.2535460959703146E-2,0.10293968942340374,0.10041099217974855,8.563418483463181E-2,{"$f":"SUM(B2:M2)","v":1}]
["Umsatzerlöse",{"$f":"$N$3*B2","v":7532.0917926083739},6650.4864766639821,9149.6202967505851,9747.9540052654975,8161.1237868772332,8948.4779880708484,7946.3697282742314,8265.7618761505764,7543.6879398091269,10705.727700033989,10442.74318669385,8905.9552228017092,104000]
["Einsatzwerte",{"$f":"$N$4*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"N4/N3","v":0}]
["Bruttoertrag",{"$f":"$N$5*B2","v":7532.0917926083739},6650.4864766639821,9149.6202967505851,9747.9540052654975,8161.1237868772332,8948.4779880708484,7946.3697282742314,8265.7618761505764,7543.6879398091269,10705.727700033989,10442.74318669385,8905.9552228017092,{"$f":"N3-N4","v":104000}]
[]
["Variable Kosten",{"$f":"$N$7*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fixum/Prov./Soz.",{"$f":"$N$8*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N7*O8","v":0},0,{"$f":"SUM(O8:O12)","v":1}]
["Provisionen",{"$f":"$N$9*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N7*O9","v":0},0]
["Fertigmachen",{"$f":"$N$10*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N7*O10","v":0},0]
["Kulanz",{"$f":"$N$11*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N7*O11","v":0},1]
["sonst. variable Kosten",{"$f":"$N$12*B2","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N7*O12","v":0},0]
["Bruttoertrag II",{"$f":"$N$13*B2","v":7532.0917926083739},6650.4864766639821,9149.6202967505851,9747.9540052654975,8161.1237868772332,8948.4779880708484,7946.3697282742314,8265.7618761505764,7543.6879398091269,10705.727700033989,10442.74318669385,8905.9552228017092,{"$f":"N5-N7","v":104000}]
["Direkte Kosten",{"$f":"$N$14/12","v":5833.333333333333},{"$f":"$N$14/12","v":5833.333333333333},5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,70000]
["Personalkosten",{"$f":"$N$15/12","v":0},{"$f":"$N$15/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"$N$14*O15","v":0},0,{"$f":"SUM(O15:O19)","v":1}]
["Werbekosten",{"$f":"$N$16/12","v":-179.08333333333334},{"$f":"$N$16/12","v":-179.08333333333334},-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,-179.08333333333334,{"$f":"$N$14*O16","v":-2149},-3.0700000000000002E-2]
["Fahrzeugkosten",{"$f":"$N$17/12","v":2387.5833333333335},{"$f":"$N$17/12","v":2387.5833333333335},2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,2387.5833333333335,28651,0.4093]
["Abschreibungen",{"$f":"$N$18/12","v":3624.8333333333335},{"$f":"$N$18/12","v":3624.8333333333335},3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,3624.8333333333335,43498,0.62139999999999995]
["Gemeinkosten",{"$f":"$N$19/12","v":0},{"$f":"$N$19/12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Deckungsbeitrag",{"$f":"B13-B14","v":1698.7584592750409},{"$f":"C13-C14","v":817.15314333064907},3316.2869634172521,3914.6206719321644,2327.7904535439002,3115.1446547375153,2113.0363949408984,2432.4285428172434,1710.3546064757938,4872.3943667006561,4609.4098533605165,3072.6218894683761,{"$f":"N13-N14","v":34000}]

{"sheet":"---","index":11,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[" ",2015]
["Neuwagen Stk.",306]
["Gebrauchtwagen Stk.",606]
["Service AW gesamt",11325]
["Umsatzerlöse",11519122]
["Einsatzwerte",9474183]
["Bruttoertrag",2044939]
["Variable Kosten",285820]
["Fixum/Prov./Soz.",179615]
["Provisionen",13635]
["Fertigmachen",6546]
["Kulanz",45336]
["sonst. variable Kosten",40689]
["Bruttoertrag II",1759119]
["Direkte Kosten",959551]
["Personalkosten",633343]
["Werbekosten",99873]
["Fahrzeugkosten",96610]
["Abschreibungen",112436]
["Gemeinkosten",17289]
["Deckungsbeitrag",799568]
["Indirekte Kosten",989126]
["Personalkosten",301363]
["Werbekosten",79480]
["Fahrzeugkosten",13295]
["Abschreibungen",15165]
["Gemeinkosten",269217]
["Raumkosten",195634]
["Kalk. Kosten",114972]
["Betriebsergebnis",-189558]
["Neutrales Ergebnis",12107]
["Unternehmenserg.",-177451]

{"sheet":"Planung_2017","index":12,"n_rows":98,"n_cols":20,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Rechtseinheit","Betrieb","Bookkeep Date","Kostenstelle","Ebene1","Ebene2","Ebene3","Marke","Wert1","Wert2","Wert3","Wert4","Wert5","Wert6","Wert7","Wert8","Wert9","Wert10","Wert11","Wert12"]
[1,"01","2017","1","verkaufte Stückzahlen","VE Neuwagen",null,1,{"$f":"NW!B3","v":25.989995975486021},{"$f":"NW!C3","v":24.393953332861141},{"$f":"NW!D3","v":34.072602917923838},{"$f":"NW!E3","v":30.478701525869482},{"$f":"NW!F3","v":40.411239589366019},{"$f":"NW!G3","v":33.340393507100117},{"$f":"NW!H3","v":27.146972430051132},{"$f":"NW!I3","v":27.292412246064284},{"$f":"NW!J3","v":27.613645497620858},{"$f":"NW!K3","v":33.662400200704568},{"$f":"NW!L3","v":24.51547977583671},{"$f":"NW!M3","v":31.082203001115829}]
[1,"01","2017","1","Umsatzerlöse","VE Neuwagen",null,1,{"$f":"NW!B4*-1","v":-418438.9352053249},{"$f":"NW!C4*-1","v":-392742.64865906438},{"$f":"NW!D4*-1","v":-548568.90697857377},{"$f":"NW!E4*-1","v":-490707.09456649865},{"$f":"NW!F4*-1","v":-650620.95738879289},{"$f":"NW!G4*-1","v":-536780.33546431188},{"$f":"NW!H4*-1","v":-437066.25612382323},{"$f":"NW!I4*-1","v":-439407.83716163499},{"$f":"NW!J4*-1","v":-444579.69251169579},{"$f":"NW!K4*-1","v":-541964.64323134359},{"$f":"NW!L4*-1","v":-394699.22439097107},{"$f":"NW!M4*-1","v":-500423.46831796487}]
[1,"01","2017","1","Einsatzwerte","EW Neuwagen",null,1,{"$f":"NW!B6","v":384126.94251848827},{"$f":"NW!C6","v":360537.75146902108},{"$f":"NW!D6","v":503586.25660633075},{"$f":"NW!E6","v":450469.11281204579},{"$f":"NW!F6","v":597270.0388829119},{"$f":"NW!G6","v":492764.34795623831},{"$f":"NW!H6","v":401226.82312166976},{"$f":"NW!I6","v":403376.3945143809},{"$f":"NW!J6","v":408124.15772573673},{"$f":"NW!K6","v":497523.54248637339},{"$f":"NW!L6","v":362333.88799091143},{"$f":"NW!M6","v":459388.74391589174}]
[1,"01","2017","1","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"NW!B11","v":10275.313843882239},{"$f":"NW!C11","v":9644.3080108433151},{"$f":"NW!D11","v":13470.825035520156},{"$f":"NW!E11","v":12049.952759812419},{"$f":"NW!F11","v":15976.846244713186},{"$f":"NW!G11","v":13181.341285589828},{"$f":"NW!H11","v":10732.732005541511},{"$f":"NW!I11","v":10790.232582161114},{"$f":"NW!J11","v":10917.23423618014},{"$f":"NW!K11","v":13308.648724949855},{"$f":"NW!L11","v":9692.3542799955867},{"$f":"NW!M11","v":12288.550990810651}]
[1,"01","2017","1","Kosten","Variable Kosten","Provisionen",1,{"$f":"NW!B12","v":185.3411588001847},{"$f":"NW!C12","v":173.95937970496604},{"$f":"NW!D12","v":242.9802495584444},{"$f":"NW!E12","v":217.35124025635679},{"$f":"NW!F12","v":288.18265232166647},{"$f":"NW!G12","v":237.75868119750774},{"$f":"NW!H12","v":193.59184714180219},{"$f":"NW!I12","v":194.62901482974596},{"$f":"NW!J12","v":196.91980945490877},{"$f":"NW!K12","v":240.05499143127449},{"$f":"NW!L12","v":174.82601515143557},{"$f":"NW!M12","v":221.65496015170729}]
[1,"01","2017","1","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"NW!B13","v":-343.14591686434193},{"$f":"NW!C13","v":-322.07336585376561},{"$f":"NW!D13","v":-449.8605763253484},{"$f":"NW!E13","v":-402.41029624605477},{"$f":"NW!F13","v":-533.54959629839959},{"$f":"NW!G13","v":-440.19321547424283},{"$f":"NW!H13","v":-358.42147699396514},{"$f":"NW!I13","v":-360.34171888478676},{"$f":"NW!J13","v":-364.58296150508818},{"$f":"NW!K13","v":-444.44466984990243},{"$f":"NW!L13","v":-323.6778794803721},{"$f":"NW!M13","v":-410.3783262237323}]
[1,"01","2017","1","Kosten","Variable Kosten","Kulanz",1,{"$f":"NW!B14","v":473.41427419247168},{"$f":"NW!C14","v":444.34195844639885},{"$f":"NW!D14","v":620.64098030071216},{"$f":"NW!E14","v":555.17716796909406},{"$f":"NW!F14","v":736.10083193019932},{"$f":"NW!G14","v":607.30360283020536},{"$f":"NW!H14","v":494.48888955648891},{"$f":"NW!I14","v":497.13811216512244},{"$f":"NW!J14","v":502.98945615053833},{"$f":"NW!K14","v":613.16903525588384},{"$f":"NW!L14","v":446.55559298680964},{"$f":"NW!M14","v":566.17009821607508}]
[1,"01","2017","1","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"NW!B15","v":0},{"$f":"NW!C15","v":0},{"$f":"NW!D15","v":0},{"$f":"NW!E15","v":0},{"$f":"NW!F15","v":0},{"$f":"NW!G15","v":0},{"$f":"NW!H15","v":0},{"$f":"NW!I15","v":0},{"$f":"NW!J15","v":0},{"$f":"NW!K15","v":0},{"$f":"NW!L15","v":0},{"$f":"NW!M15","v":0}]
[1,"01","2017","1","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"NW!B18","v":5875},{"$f":"NW!C18","v":5875},{"$f":"NW!D18","v":5875},{"$f":"NW!E18","v":5875},{"$f":"NW!F18","v":5875},{"$f":"NW!G18","v":5875},{"$f":"NW!H18","v":5875},{"$f":"NW!I18","v":5875},{"$f":"NW!J18","v":5875},{"$f":"NW!K18","v":5875},{"$f":"NW!L18","v":5875},{"$f":"NW!M18","v":5875}]
[1,"01","2017","1","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"NW!B19","v":1625},{"$f":"NW!C19","v":1625},{"$f":"NW!D19","v":1625},{"$f":"NW!E19","v":1625},{"$f":"NW!F19","v":1625},{"$f":"NW!G19","v":1625},{"$f":"NW!H19","v":1625},{"$f":"NW!I19","v":1625},{"$f":"NW!J19","v":1625},{"$f":"NW!K19","v":1625},{"$f":"NW!L19","v":1625},{"$f":"NW!M19","v":1625}]
[1,"01","2017","1","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"NW!B20","v":4875},{"$f":"NW!C20","v":4875},{"$f":"NW!D20","v":4875},{"$f":"NW!E20","v":4875},{"$f":"NW!F20","v":4875},{"$f":"NW!G20","v":4875},{"$f":"NW!H20","v":4875},{"$f":"NW!I20","v":4875},{"$f":"NW!J20","v":4875},{"$f":"NW!K20","v":4875},{"$f":"NW!L20","v":4875},{"$f":"NW!M20","v":4875}]
[1,"01","2017","1","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"NW!B21","v":9500},{"$f":"NW!C21","v":9500},{"$f":"NW!D21","v":9500},{"$f":"NW!E21","v":9500},{"$f":"NW!F21","v":9500},{"$f":"NW!G21","v":9500},{"$f":"NW!H21","v":9500},{"$f":"NW!I21","v":9500},{"$f":"NW!J21","v":9500},{"$f":"NW!K21","v":9500},{"$f":"NW!L21","v":9500},{"$f":"NW!M21","v":9500}]
[1,"01","2017","1","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"NW!B22","v":66.666666666666671},{"$f":"NW!C22","v":66.666666666666671},{"$f":"NW!D22","v":66.666666666666671},{"$f":"NW!E22","v":66.666666666666671},{"$f":"NW!F22","v":66.666666666666671},{"$f":"NW!G22","v":66.666666666666671},{"$f":"NW!H22","v":66.666666666666671},{"$f":"NW!I22","v":66.666666666666671},{"$f":"NW!J22","v":66.666666666666671},{"$f":"NW!K22","v":66.666666666666671},{"$f":"NW!L22","v":66.666666666666671},{"$f":"NW!M22","v":66.666666666666671}]
[1,"01","2017","2","verkaufte Stückzahlen","VE Gebrauchtwagen",null,1,{"$f":"GW!B3","v":31.765550636705136},{"$f":"GW!C3","v":29.814831851274725},{"$f":"GW!D3","v":41.644292455240247},{"$f":"GW!E3","v":37.251746309396033},{"$f":"GW!F3","v":49.391515053669579},{"$f":"GW!G3","v":40.749369842011255},{"$f":"GW!H3","v":33.179632970062499},{"$f":"GW!I3","v":33.357392745189678},{"$f":"GW!J3","v":33.750011163758828},{"$f":"GW!K3","v":41.142933578638917},{"$f":"GW!L3","v":29.963364170467091},{"$f":"GW!M3","v":37.989359223586014}]
[1,"01","2017","2","Umsatzerlöse","VE Gebrauchtwagen",null,1,{"$f":"GW!B4*-1","v":-270007.18041199364},{"$f":"GW!C4*-1","v":-253426.07073583518},{"$f":"GW!D4*-1","v":-353976.48586954211},{"$f":"GW!E4*-1","v":-316639.84362986631},{"$f":"GW!F4*-1","v":-419827.87795619143},{"$f":"GW!G4*-1","v":-346369.64365709567},{"$f":"GW!H4*-1","v":-282026.88024553121},{"$f":"GW!I4*-1","v":-283537.83833411225},{"$f":"GW!J4*-1","v":-286875.09489195002},{"$f":"GW!K4*-1","v":-349714.93541843077},{"$f":"GW!L4*-1","v":-254688.59544897027},{"$f":"GW!M4*-1","v":-322909.55340048112}]
[1,"01","2017","2","Einsatzwerte","EW Gebrauchtwagen",null,1,{"$f":"GW!B6","v":244896.51263367824},{"$f":"GW!C6","v":229857.4461574025},{"$f":"GW!D6","v":321056.67268367467},{"$f":"GW!E6","v":287192.33817228873},{"$f":"GW!F6","v":380783.88530626561},{"$f":"GW!G6","v":314157.26679698576},{"$f":"GW!H6","v":255798.38038269681},{"$f":"GW!I6","v":257168.81936903985},{"$f":"GW!J6","v":260195.71106699866},{"$f":"GW!K6","v":317191.44642451673},{"$f":"GW!L6","v":231002.55607221604},{"$f":"GW!M6","v":292878.96493423637}]
[1,"01","2017","2","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"GW!B11","v":6205.6417350651873},{"$f":"GW!C11","v":5824.5539948685873},{"$f":"GW!D11","v":8135.5290277538415},{"$f":"GW!E11","v":7277.4117548124668},{"$f":"GW!F11","v":9649.0078412487601},{"$f":"GW!G11","v":7960.6990938476974},{"$f":"GW!H11","v":6481.8934659122815},{"$f":"GW!I11","v":6516.6201889576669},{"$f":"GW!J11","v":6593.3211809251306},{"$f":"GW!K11","v":8037.5847608823096},{"$f":"GW!L11","v":5853.5709122684411},{"$f":"GW!M11","v":7421.510043457627}]
[1,"01","2017","2","Kosten","Variable Kosten","Provisionen",1,{"$f":"GW!B12","v":139.32370509258874},{"$f":"GW!C12","v":130.76785249969095},{"$f":"GW!D12","v":182.65186670868374},{"$f":"GW!E12","v":163.38615931301101},{"$f":"GW!F12","v":216.63118502539479},{"$f":"GW!G12","v":178.72673612706137},{"$f":"GW!H12","v":145.52587020669412},{"$f":"GW!I12","v":146.30552458040194},{"$f":"GW!J12","v":148.02754896424622},{"$f":"GW!K12","v":180.4529066759103},{"$f":"GW!L12","v":131.41931525166868},{"$f":"GW!M12","v":166.62132955464827}]
[1,"01","2017","2","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"GW!B13","v":1287.5149452968051},{"$f":"GW!C13","v":1208.4488016294968},{"$f":"GW!D13","v":1687.9181329373064},{"$f":"GW!E13","v":1509.8803310631781},{"$f":"GW!F13","v":2001.9270098523245},{"$f":"GW!G13","v":1651.6453085624316},{"$f":"GW!H13","v":1344.830247615979},{"$f":"GW!I13","v":1352.035171269479},{"$f":"GW!J13","v":1367.9487024872399},{"$f":"GW!K13","v":1667.5971552226767},{"$f":"GW!L13","v":1214.4690838845379},{"$f":"GW!M13","v":1539.7771101785434}]
[1,"01","2017","2","Kosten","Variable Kosten","Kulanz",1,{"$f":"GW!B14","v":563.03167881534387},{"$f":"GW!C14","v":528.45596863110404},{"$f":"GW!D14","v":738.12842605215121},{"$f":"GW!E14","v":660.27230263552087},{"$f":"GW!F14","v":875.44484772027181},{"$f":"GW!G14","v":722.26628070171262},{"$f":"GW!H14","v":588.09572254116972},{"$f":"GW!I14","v":591.24644345138893},{"$f":"GW!J14","v":598.20544787315964},{"$f":"GW!K14","v":729.24204050794333},{"$f":"GW!L14","v":531.08864457586094},{"$f":"GW!M14","v":673.34619649437263}]
[1,"01","2017","2","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"GW!B15","v":0},{"$f":"GW!C15","v":0},{"$f":"GW!D15","v":0},{"$f":"GW!E15","v":0},{"$f":"GW!F15","v":0},{"$f":"GW!G15","v":0},{"$f":"GW!H15","v":0},{"$f":"GW!I15","v":0},{"$f":"GW!J15","v":0},{"$f":"GW!K15","v":0},{"$f":"GW!L15","v":0},{"$f":"GW!M15","v":0}]
[1,"01","2017","2","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"GW!B18","v":3541.6666666666665},{"$f":"GW!C18","v":3541.6666666666665},{"$f":"GW!D18","v":3541.6666666666665},{"$f":"GW!E18","v":3541.6666666666665},{"$f":"GW!F18","v":3541.6666666666665},{"$f":"GW!G18","v":3541.6666666666665},{"$f":"GW!H18","v":3541.6666666666665},{"$f":"GW!I18","v":3541.6666666666665},{"$f":"GW!J18","v":3541.6666666666665},{"$f":"GW!K18","v":3541.6666666666665},{"$f":"GW!L18","v":3541.6666666666665},{"$f":"GW!M18","v":3541.6666666666665}]
[1,"01","2017","2","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"GW!B19","v":58.333333333333336},{"$f":"GW!C19","v":58.333333333333336},{"$f":"GW!D19","v":58.333333333333336},{"$f":"GW!E19","v":58.333333333333336},{"$f":"GW!F19","v":58.333333333333336},{"$f":"GW!G19","v":58.333333333333336},{"$f":"GW!H19","v":58.333333333333336},{"$f":"GW!I19","v":58.333333333333336},{"$f":"GW!J19","v":58.333333333333336},{"$f":"GW!K19","v":58.333333333333336},{"$f":"GW!L19","v":58.333333333333336},{"$f":"GW!M19","v":58.333333333333336}]
[1,"01","2017","2","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"GW!B20","v":250},{"$f":"GW!C20","v":250},{"$f":"GW!D20","v":250},{"$f":"GW!E20","v":250},{"$f":"GW!F20","v":250},{"$f":"GW!G20","v":250},{"$f":"GW!H20","v":250},{"$f":"GW!I20","v":250},{"$f":"GW!J20","v":250},{"$f":"GW!K20","v":250},{"$f":"GW!L20","v":250},{"$f":"GW!M20","v":250}]
[1,"01","2017","2","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"GW!B21","v":0},{"$f":"GW!C21","v":0},{"$f":"GW!D21","v":0},{"$f":"GW!E21","v":0},{"$f":"GW!F21","v":0},{"$f":"GW!G21","v":0},{"$f":"GW!H21","v":0},{"$f":"GW!I21","v":0},{"$f":"GW!J21","v":0},{"$f":"GW!K21","v":0},{"$f":"GW!L21","v":0},{"$f":"GW!M21","v":0}]
[1,"01","2017","2","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"GW!B22","v":0},{"$f":"GW!C22","v":0},{"$f":"GW!D22","v":0},{"$f":"GW!E22","v":0},{"$f":"GW!F22","v":0},{"$f":"GW!G22","v":0},{"$f":"GW!H22","v":0},{"$f":"GW!I22","v":0},{"$f":"GW!J22","v":0},{"$f":"GW!K22","v":0},{"$f":"GW!L22","v":0},{"$f":"GW!M22","v":0}]
[1,"01","2017","3","verkaufte Stückzahlen","VE Service","VE Mechanik",1,{"$f":"ME!B3","v":995.82944373428018},{"$f":"ME!C3","v":879.27104859740143},{"$f":"ME!D3","v":1209.6853757723129},{"$f":"ME!E3","v":1288.7919958884672},{"$f":"ME!F3","v":1078.9947314380956},{"$f":"ME!G3","v":1183.0920416920592},{"$f":"ME!H3","v":1050.6017669593334},{"$f":"ME!I3","v":1092.8290942026001},{"$f":"ME!J3","v":997.36258819591831},{"$f":"ME!K3","v":1415.4207295718015},{"$f":"ME!L3","v":1380.6511424715427},{"$f":"ME!M3","v":1177.4700414761874}]
[1,"01","2017","3","Umsatzerlöse","VE Service","VE Mechanik",1,{"$f":"ME!B4*-1","v":-65027.6626758485},{"$f":"ME!C4*-1","v":-57416.399473410318},{"$f":"ME!D4*-1","v":-78992.455037932028},{"$f":"ME!E4*-1","v":-84158.1173315169},{"$f":"ME!F4*-1","v":-70458.355962907648},{"$f":"ME!G4*-1","v":-77255.910322491458},{"$f":"ME!H4*-1","v":-68604.29538244447},{"$f":"ME!I4*-1","v":-71361.739851429797},{"$f":"ME!J4*-1","v":-65127.777009193465},{"$f":"ME!K4*-1","v":-92426.973641038639},{"$f":"ME!L4*-1","v":-90156.519603391731},{"$f":"ME!M4*-1","v":-76888.793708395038}]
[1,"01","2017","3","Einsatzwerte","EW Service","EW Mechanik",1,{"$f":"ME!B6","v":15606.639042203638},{"$f":"ME!C6","v":13779.935873618475},{"$f":"ME!D6","v":18958.189209103686},{"$f":"ME!E6","v":20197.948159564057},{"$f":"ME!F6","v":16910.005431097838},{"$f":"ME!G6","v":18541.41847739795},{"$f":"ME!H6","v":16465.030891786675},{"$f":"ME!I6","v":17126.81756434315},{"$f":"ME!J6","v":15630.66648220643},{"$f":"ME!K6","v":22182.473673849272},{"$f":"ME!L6","v":21637.564704814016},{"$f":"ME!M6","v":18453.31049001481}]
[1,"01","2017","3","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"ME!B11","v":0},{"$f":"ME!C11","v":0},{"$f":"ME!D11","v":0},{"$f":"ME!E11","v":0},{"$f":"ME!F11","v":0},{"$f":"ME!G11","v":0},{"$f":"ME!H11","v":0},{"$f":"ME!I11","v":0},{"$f":"ME!J11","v":0},{"$f":"ME!K11","v":0},{"$f":"ME!L11","v":0},{"$f":"ME!M11","v":0}]
[1,"01","2017","3","Kosten","Variable Kosten","Provisionen",1,{"$f":"ME!B12","v":0},{"$f":"ME!C12","v":0},{"$f":"ME!D12","v":0},{"$f":"ME!E12","v":0},{"$f":"ME!F12","v":0},{"$f":"ME!G12","v":0},{"$f":"ME!H12","v":0},{"$f":"ME!I12","v":0},{"$f":"ME!J12","v":0},{"$f":"ME!K12","v":0},{"$f":"ME!L12","v":0},{"$f":"ME!M12","v":0}]
[1,"01","2017","3","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"ME!B13","v":0},{"$f":"ME!C13","v":0},{"$f":"ME!D13","v":0},{"$f":"ME!E13","v":0},{"$f":"ME!F13","v":0},{"$f":"ME!G13","v":0},{"$f":"ME!H13","v":0},{"$f":"ME!I13","v":0},{"$f":"ME!J13","v":0},{"$f":"ME!K13","v":0},{"$f":"ME!L13","v":0},{"$f":"ME!M13","v":0}]
[1,"01","2017","3","Kosten","Variable Kosten","Kulanz",1,{"$f":"ME!B14","v":1774.3870088356266},{"$f":"ME!C14","v":1566.701141137188},{"$f":"ME!D14","v":2155.4393968306663},{"$f":"ME!E14","v":2296.3930108558143},{"$f":"ME!F14","v":1922.5724305624251},{"$f":"ME!G14","v":2108.0549106513054},{"$f":"ME!H14","v":1871.9813302184489},{"$f":"ME!I14","v":1947.2227496700878},{"$f":"ME!J14","v":1777.1187935127271},{"$f":"ME!K14","v":2522.0223908733919},{"$f":"ME!L14","v":2460.0693084038394},{"$f":"ME!M14","v":2098.0375284484794}]
[1,"01","2017","3","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"ME!B15","v":0},{"$f":"ME!C15","v":0},{"$f":"ME!D15","v":0},{"$f":"ME!E15","v":0},{"$f":"ME!F15","v":0},{"$f":"ME!G15","v":0},{"$f":"ME!H15","v":0},{"$f":"ME!I15","v":0},{"$f":"ME!J15","v":0},{"$f":"ME!K15","v":0},{"$f":"ME!L15","v":0},{"$f":"ME!M15","v":0}]
[1,"01","2017","3","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"ME!B18","v":29294.741666666669},{"$f":"ME!C18","v":29294.741666666669},{"$f":"ME!D18","v":29294.741666666669},{"$f":"ME!E18","v":29294.741666666669},{"$f":"ME!F18","v":29294.741666666669},{"$f":"ME!G18","v":29294.741666666669},{"$f":"ME!H18","v":29294.741666666669},{"$f":"ME!I18","v":29294.741666666669},{"$f":"ME!J18","v":29294.741666666669},{"$f":"ME!K18","v":29294.741666666669},{"$f":"ME!L18","v":29294.741666666669},{"$f":"ME!M18","v":29294.741666666669}]
[1,"01","2017","3","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"ME!B19","v":1106.8958333333333},{"$f":"ME!C19","v":1106.8958333333333},{"$f":"ME!D19","v":1106.8958333333333},{"$f":"ME!E19","v":1106.8958333333333},{"$f":"ME!F19","v":1106.8958333333333},{"$f":"ME!G19","v":1106.8958333333333},{"$f":"ME!H19","v":1106.8958333333333},{"$f":"ME!I19","v":1106.8958333333333},{"$f":"ME!J19","v":1106.8958333333333},{"$f":"ME!K19","v":1106.8958333333333},{"$f":"ME!L19","v":1106.8958333333333},{"$f":"ME!M19","v":1106.8958333333333}]
[1,"01","2017","3","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"ME!B20","v":571.62083333333328},{"$f":"ME!C20","v":571.62083333333328},{"$f":"ME!D20","v":571.62083333333328},{"$f":"ME!E20","v":571.62083333333328},{"$f":"ME!F20","v":571.62083333333328},{"$f":"ME!G20","v":571.62083333333328},{"$f":"ME!H20","v":571.62083333333328},{"$f":"ME!I20","v":571.62083333333328},{"$f":"ME!J20","v":571.62083333333328},{"$f":"ME!K20","v":571.62083333333328},{"$f":"ME!L20","v":571.62083333333328},{"$f":"ME!M20","v":571.62083333333328}]
[1,"01","2017","3","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"ME!B21","v":0},{"$f":"ME!C21","v":0},{"$f":"ME!D21","v":0},{"$f":"ME!E21","v":0},{"$f":"ME!F21","v":0},{"$f":"ME!G21","v":0},{"$f":"ME!H21","v":0},{"$f":"ME!I21","v":0},{"$f":"ME!J21","v":0},{"$f":"ME!K21","v":0},{"$f":"ME!L21","v":0},{"$f":"ME!M21","v":0}]
[1,"01","2017","3","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"ME!B22","v":2068.4083333333333},{"$f":"ME!C22","v":2068.4083333333333},{"$f":"ME!D22","v":2068.4083333333333},{"$f":"ME!E22","v":2068.4083333333333},{"$f":"ME!F22","v":2068.4083333333333},{"$f":"ME!G22","v":2068.4083333333333},{"$f":"ME!H22","v":2068.4083333333333},{"$f":"ME!I22","v":2068.4083333333333},{"$f":"ME!J22","v":2068.4083333333333},{"$f":"ME!K22","v":2068.4083333333333},{"$f":"ME!L22","v":2068.4083333333333},{"$f":"ME!M22","v":2068.4083333333333}]
[1,"01","2017","4","verkaufte Stückzahlen","VE Service","VE Karosserie",1,{"$f":"KA!B3","v":177.43870088356266},{"$f":"KA!C3","v":156.6701141137188},{"$f":"KA!D3","v":215.54393968306664},{"$f":"KA!E3","v":229.63930108558142},{"$f":"KA!F3","v":192.25724305624252},{"$f":"KA!G3","v":210.80549106513055},{"$f":"KA!H3","v":187.19813302184488},{"$f":"KA!I3","v":194.72227496700876},{"$f":"KA!J3","v":177.7118793512727},{"$f":"KA!K3","v":252.20223908733917},{"$f":"KA!L3","v":246.00693084038394},{"$f":"KA!M3","v":209.80375284484793}]
[1,"01","2017","4","Umsatzerlöse","VE Service","VE Karosserie",1,{"$f":"KA!B4*-1","v":-19819.902888693949},{"$f":"KA!C4*-1","v":-17500.051746502391},{"$f":"KA!D4*-1","v":-24076.258062598547},{"$f":"KA!E4*-1","v":-25650.709931259444},{"$f":"KA!F4*-1","v":-21475.13404938229},{"$f":"KA!G4*-1","v":-23546.973351975081},{"$f":"KA!H4*-1","v":-20910.031458540074},{"$f":"KA!I4*-1","v":-21750.478113814879},{"$f":"KA!J4*-1","v":-19850.416923537163},{"$f":"KA!K4*-1","v":-28170.990106055786},{"$f":"KA!L4*-1","v":-27478.974174870888},{"$f":"KA!M4*-1","v":-23435.079192769514}]
[1,"01","2017","4","Einsatzwerte","EW Service","EW Karosserie",1,{"$f":"KA!B6","v":3389.2033939666653},{"$f":"KA!C6","v":2992.5088486519089},{"$f":"KA!D6","v":4117.0401287043514},{"$f":"KA!E6","v":4386.2713982453652},{"$f":"KA!F6","v":3672.2479224443719},{"$f":"KA!G6","v":4026.5324431877393},{"$f":"KA!H6","v":3575.6153794103529},{"$f":"KA!I6","v":3719.3317574623447},{"$f":"KA!J6","v":3394.421293924855},{"$f":"KA!K6","v":4817.2393081355394},{"$f":"KA!L6","v":4698.9045839029222},{"$f":"KA!M6","v":4007.3985419635874}]
[1,"01","2017","4","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"KA!B11","v":0},{"$f":"KA!C11","v":0},{"$f":"KA!D11","v":0},{"$f":"KA!E11","v":0},{"$f":"KA!F11","v":0},{"$f":"KA!G11","v":0},{"$f":"KA!H11","v":0},{"$f":"KA!I11","v":0},{"$f":"KA!J11","v":0},{"$f":"KA!K11","v":0},{"$f":"KA!L11","v":0},{"$f":"KA!M11","v":0}]
[1,"01","2017","4","Kosten","Variable Kosten","Provisionen",1,{"$f":"KA!B12","v":0},{"$f":"KA!C12","v":0},{"$f":"KA!D12","v":0},{"$f":"KA!E12","v":0},{"$f":"KA!F12","v":0},{"$f":"KA!G12","v":0},{"$f":"KA!H12","v":0},{"$f":"KA!I12","v":0},{"$f":"KA!J12","v":0},{"$f":"KA!K12","v":0},{"$f":"KA!L12","v":0},{"$f":"KA!M12","v":0}]
[1,"01","2017","4","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"KA!B13","v":0},{"$f":"KA!C13","v":0},{"$f":"KA!D13","v":0},{"$f":"KA!E13","v":0},{"$f":"KA!F13","v":0},{"$f":"KA!G13","v":0},{"$f":"KA!H13","v":0},{"$f":"KA!I13","v":0},{"$f":"KA!J13","v":0},{"$f":"KA!K13","v":0},{"$f":"KA!L13","v":0},{"$f":"KA!M13","v":0}]
[1,"01","2017","4","Kosten","Variable Kosten","Kulanz",1,{"$f":"KA!B14","v":43.454375726586775},{"$f":"KA!C14","v":38.368191211522969},{"$f":"KA!D14","v":52.78627094279183},{"$f":"KA!E14","v":56.238196184224023},{"$f":"KA!F14","v":47.083406462753267},{"$f":"KA!G14","v":51.625834546562579},{"$f":"KA!H14","v":45.844440740043645},{"$f":"KA!I14","v":47.687087747022552},{"$f":"KA!J14","v":43.521276575821886},{"$f":"KA!K14","v":61.763813654042245},{"$f":"KA!L14","v":60.246595307849134},{"$f":"KA!M14","v":51.380510900779086}]
[1,"01","2017","4","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"KA!B15","v":0},{"$f":"KA!C15","v":0},{"$f":"KA!D15","v":0},{"$f":"KA!E15","v":0},{"$f":"KA!F15","v":0},{"$f":"KA!G15","v":0},{"$f":"KA!H15","v":0},{"$f":"KA!I15","v":0},{"$f":"KA!J15","v":0},{"$f":"KA!K15","v":0},{"$f":"KA!L15","v":0},{"$f":"KA!M15","v":0}]
[1,"01","2017","4","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"KA!B18","v":2524},{"$f":"KA!C18","v":2524},{"$f":"KA!D18","v":2524},{"$f":"KA!E18","v":2524},{"$f":"KA!F18","v":2524},{"$f":"KA!G18","v":2524},{"$f":"KA!H18","v":2524},{"$f":"KA!I18","v":2524},{"$f":"KA!J18","v":2524},{"$f":"KA!K18","v":2524},{"$f":"KA!L18","v":2524},{"$f":"KA!M18","v":2524}]
[1,"01","2017","4","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"KA!B19","v":0},{"$f":"KA!C19","v":0},{"$f":"KA!D19","v":0},{"$f":"KA!E19","v":0},{"$f":"KA!F19","v":0},{"$f":"KA!G19","v":0},{"$f":"KA!H19","v":0},{"$f":"KA!I19","v":0},{"$f":"KA!J19","v":0},{"$f":"KA!K19","v":0},{"$f":"KA!L19","v":0},{"$f":"KA!M19","v":0}]
[1,"01","2017","4","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"KA!B20","v":0},{"$f":"KA!C20","v":0},{"$f":"KA!D20","v":0},{"$f":"KA!E20","v":0},{"$f":"KA!F20","v":0},{"$f":"KA!G20","v":0},{"$f":"KA!H20","v":0},{"$f":"KA!I20","v":0},{"$f":"KA!J20","v":0},{"$f":"KA!K20","v":0},{"$f":"KA!L20","v":0},{"$f":"KA!M20","v":0}]
[1,"01","2017","4","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"KA!B21","v":0},{"$f":"KA!C21","v":0},{"$f":"KA!D21","v":0},{"$f":"KA!E21","v":0},{"$f":"KA!F21","v":0},{"$f":"KA!G21","v":0},{"$f":"KA!H21","v":0},{"$f":"KA!I21","v":0},{"$f":"KA!J21","v":0},{"$f":"KA!K21","v":0},{"$f":"KA!L21","v":0},{"$f":"KA!M21","v":0}]
[1,"01","2017","4","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"KA!B22","v":809.33333333333337},{"$f":"KA!C22","v":809.33333333333337},{"$f":"KA!D22","v":809.33333333333337},{"$f":"KA!E22","v":809.33333333333337},{"$f":"KA!F22","v":809.33333333333337},{"$f":"KA!G22","v":809.33333333333337},{"$f":"KA!H22","v":809.33333333333337},{"$f":"KA!I22","v":809.33333333333337},{"$f":"KA!J22","v":809.33333333333337},{"$f":"KA!K22","v":809.33333333333337},{"$f":"KA!L22","v":809.33333333333337},{"$f":"KA!M22","v":809.33333333333337}]
[1,"01","2017","5","verkaufte Stückzahlen","VE Service","VE Lackiererei",1,{"$f":"LA!B3","v":161.50542978381418},{"$f":"LA!C3","v":142.60177733616038},{"$f":"LA!D3","v":196.18897367070966},{"$f":"LA!E3","v":209.01862915136596},{"$f":"LA!F3","v":174.99332735323298},{"$f":"LA!G3","v":191.8760183980576},{"$f":"LA!H3","v":170.38850475049554},{"$f":"LA!I3","v":177.23700945976717},{"$f":"LA!J3","v":161.75407794013802},{"$f":"LA!K3","v":229.55550741419034},{"$f":"LA!L3","v":223.91651256083927},{"$f":"LA!M3","v":190.96423218122894}]
[1,"01","2017","5","Umsatzerlöse","VE Service","VE Lackiererei",1,{"$f":"LA!B4*-1","v":-33465.540105504137},{"$f":"LA!C4*-1","v":-29548.514281825795},{"$f":"LA!D4*-1","v":-40652.317234307753},{"$f":"LA!E4*-1","v":-43310.750146454542},{"$f":"LA!F4*-1","v":-36260.367360863413},{"$f":"LA!G4*-1","v":-39758.62977226152},{"$f":"LA!H4*-1","v":-35306.202069350184},{"$f":"LA!I4*-1","v":-36725.28073015836},{"$f":"LA!J4*-1","v":-33517.062489976001},{"$f":"LA!K4*-1","v":-47566.19669129439},{"$f":"LA!L4*-1","v":-46397.740567731511},{"$f":"LA!M4*-1","v":-39569.698550272449}]
[1,"01","2017","5","Einsatzwerte","EW Service","EW Lackiererei",1,{"$f":"LA!B6","v":13085.026181252118},{"$f":"LA!C6","v":11553.469084193886},{"$f":"LA!D6","v":15895.056038614332},{"$f":"LA!E6","v":16934.503307263727},{"$f":"LA!F6","v":14177.803638097594},{"$f":"LA!G6","v":15545.624240954256},{"$f":"LA!H6","v":13804.725009115924},{"$f":"LA!I6","v":14359.58476549192},{"$f":"LA!J6","v":13105.171433580617},{"$f":"LA!K6","v":18598.382906296109},{"$f":"LA!L6","v":18141.516561983022},{"$f":"LA!M6","v":15471.752133156529}]
[1,"01","2017","5","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"LA!B11","v":0},{"$f":"LA!C11","v":0},{"$f":"LA!D11","v":0},{"$f":"LA!E11","v":0},{"$f":"LA!F11","v":0},{"$f":"LA!G11","v":0},{"$f":"LA!H11","v":0},{"$f":"LA!I11","v":0},{"$f":"LA!J11","v":0},{"$f":"LA!K11","v":0},{"$f":"LA!L11","v":0},{"$f":"LA!M11","v":0}]
[1,"01","2017","5","Kosten","Variable Kosten","Provisionen",1,{"$f":"LA!B12","v":0},{"$f":"LA!C12","v":0},{"$f":"LA!D12","v":0},{"$f":"LA!E12","v":0},{"$f":"LA!F12","v":0},{"$f":"LA!G12","v":0},{"$f":"LA!H12","v":0},{"$f":"LA!I12","v":0},{"$f":"LA!J12","v":0},{"$f":"LA!K12","v":0},{"$f":"LA!L12","v":0},{"$f":"LA!M12","v":0}]
[1,"01","2017","5","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"LA!B13","v":0},{"$f":"LA!C13","v":0},{"$f":"LA!D13","v":0},{"$f":"LA!E13","v":0},{"$f":"LA!F13","v":0},{"$f":"LA!G13","v":0},{"$f":"LA!H13","v":0},{"$f":"LA!I13","v":0},{"$f":"LA!J13","v":0},{"$f":"LA!K13","v":0},{"$f":"LA!L13","v":0},{"$f":"LA!M13","v":0}]
[1,"01","2017","5","Kosten","Variable Kosten","Kulanz",1,{"$f":"LA!B14","v":0},{"$f":"LA!C14","v":0},{"$f":"LA!D14","v":0},{"$f":"LA!E14","v":0},{"$f":"LA!F14","v":0},{"$f":"LA!G14","v":0},{"$f":"LA!H14","v":0},{"$f":"LA!I14","v":0},{"$f":"LA!J14","v":0},{"$f":"LA!K14","v":0},{"$f":"LA!L14","v":0},{"$f":"LA!M14","v":0}]
[1,"01","2017","5","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"LA!B15","v":0},{"$f":"LA!C15","v":0},{"$f":"LA!D15","v":0},{"$f":"LA!E15","v":0},{"$f":"LA!F15","v":0},{"$f":"LA!G15","v":0},{"$f":"LA!H15","v":0},{"$f":"LA!I15","v":0},{"$f":"LA!J15","v":0},{"$f":"LA!K15","v":0},{"$f":"LA!L15","v":0},{"$f":"LA!M15","v":0}]
[1,"01","2017","5","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"LA!B18","v":5411.8133333333335},{"$f":"LA!C18","v":5411.8133333333335},{"$f":"LA!D18","v":5411.8133333333335},{"$f":"LA!E18","v":5411.8133333333335},{"$f":"LA!F18","v":5411.8133333333335},{"$f":"LA!G18","v":5411.8133333333335},{"$f":"LA!H18","v":5411.8133333333335},{"$f":"LA!I18","v":5411.8133333333335},{"$f":"LA!J18","v":5411.8133333333335},{"$f":"LA!K18","v":5411.8133333333335},{"$f":"LA!L18","v":5411.8133333333335},{"$f":"LA!M18","v":5411.8133333333335}]
[1,"01","2017","5","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"LA!B19","v":0},{"$f":"LA!C19","v":0},{"$f":"LA!D19","v":0},{"$f":"LA!E19","v":0},{"$f":"LA!F19","v":0},{"$f":"LA!G19","v":0},{"$f":"LA!H19","v":0},{"$f":"LA!I19","v":0},{"$f":"LA!J19","v":0},{"$f":"LA!K19","v":0},{"$f":"LA!L19","v":0},{"$f":"LA!M19","v":0}]
[1,"01","2017","5","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"LA!B20","v":119.03666666666668},{"$f":"LA!C20","v":119.03666666666668},{"$f":"LA!D20","v":119.03666666666668},{"$f":"LA!E20","v":119.03666666666668},{"$f":"LA!F20","v":119.03666666666668},{"$f":"LA!G20","v":119.03666666666668},{"$f":"LA!H20","v":119.03666666666668},{"$f":"LA!I20","v":119.03666666666668},{"$f":"LA!J20","v":119.03666666666668},{"$f":"LA!K20","v":119.03666666666668},{"$f":"LA!L20","v":119.03666666666668},{"$f":"LA!M20","v":119.03666666666668}]
[1,"01","2017","5","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"LA!B21","v":0},{"$f":"LA!C21","v":0},{"$f":"LA!D21","v":0},{"$f":"LA!E21","v":0},{"$f":"LA!F21","v":0},{"$f":"LA!G21","v":0},{"$f":"LA!H21","v":0},{"$f":"LA!I21","v":0},{"$f":"LA!J21","v":0},{"$f":"LA!K21","v":0},{"$f":"LA!L21","v":0},{"$f":"LA!M21","v":0}]
[1,"01","2017","5","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"LA!B22","v":1727.4833333333333},{"$f":"LA!C22","v":1727.4833333333333},{"$f":"LA!D22","v":1727.4833333333333},{"$f":"LA!E22","v":1727.4833333333333},{"$f":"LA!F22","v":1727.4833333333333},{"$f":"LA!G22","v":1727.4833333333333},{"$f":"LA!H22","v":1727.4833333333333},{"$f":"LA!I22","v":1727.4833333333333},{"$f":"LA!J22","v":1727.4833333333333},{"$f":"LA!K22","v":1727.4833333333333},{"$f":"LA!L22","v":1727.4833333333333},{"$f":"LA!M22","v":1727.4833333333333}]
[1,"01","2017","6","Umsatzerlöse","VE Teile",null,1,{"$f":"'T&Z'!B4*-1","v":-126595.02306694986},{"$f":"'T&Z'!C4*-1","v":-111777.51308686021},{"$f":"'T&Z'!D4*-1","v":-153781.50245827701},{"$f":"'T&Z'!E4*-1","v":-163837.94782787707},{"$f":"'T&Z'!F4*-1","v":-137167.42738927409},{"$f":"'T&Z'!G4*-1","v":-150400.81938799904},{"$f":"'T&Z'!H4*-1","v":-133557.96593405819},{"$f":"'T&Z'!I4*-1","v":-138926.12360408125},{"$f":"'T&Z'!J4*-1","v":-126789.9243722961},{"$f":"'T&Z'!K4*-1","v":-179935.65166907603},{"$f":"'T&Z'!L4*-1","v":-175515.56075021374},{"$f":"'T&Z'!M4*-1","v":-149686.1214530376}]
[1,"01","2017","6","Einsatzwerte","EW Service",null,1,{"$f":"'T&Z'!B5","v":81653.789878182652},{"$f":"'T&Z'!C5","v":72096.495941024827},{"$f":"'T&Z'!D5","v":99189.069085588679},{"$f":"'T&Z'!E5","v":105675.47634898071},{"$f":"'T&Z'!F5","v":88472.990666081794},{"$f":"'T&Z'!G5","v":97008.528505259383},{"$f":"'T&Z'!H5","v":86144.888027467518},{"$f":"'T&Z'!I5","v":89607.349724632411},{"$f":"'T&Z'!J5","v":81779.501220130987},{"$f":"'T&Z'!K5","v":116058.49532655404},{"$f":"'T&Z'!L5","v":113207.53668388785},{"$f":"'T&Z'!M5","v":96547.548337209257}]
[1,"01","2017","6","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"'T&Z'!B9","v":0},{"$f":"'T&Z'!C9","v":0},{"$f":"'T&Z'!D9","v":0},{"$f":"'T&Z'!E9","v":0},{"$f":"'T&Z'!F9","v":0},{"$f":"'T&Z'!G9","v":0},{"$f":"'T&Z'!H9","v":0},{"$f":"'T&Z'!I9","v":0},{"$f":"'T&Z'!J9","v":0},{"$f":"'T&Z'!K9","v":0},{"$f":"'T&Z'!L9","v":0},{"$f":"'T&Z'!M9","v":0}]
[1,"01","2017","6","Kosten","Variable Kosten","Provisionen",1,{"$f":"'T&Z'!B10","v":0},{"$f":"'T&Z'!C10","v":0},{"$f":"'T&Z'!D10","v":0},{"$f":"'T&Z'!E10","v":0},{"$f":"'T&Z'!F10","v":0},{"$f":"'T&Z'!G10","v":0},{"$f":"'T&Z'!H10","v":0},{"$f":"'T&Z'!I10","v":0},{"$f":"'T&Z'!J10","v":0},{"$f":"'T&Z'!K10","v":0},{"$f":"'T&Z'!L10","v":0},{"$f":"'T&Z'!M10","v":0}]
[1,"01","2017","6","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"'T&Z'!B11","v":0},{"$f":"'T&Z'!C11","v":0},{"$f":"'T&Z'!D11","v":0},{"$f":"'T&Z'!E11","v":0},{"$f":"'T&Z'!F11","v":0},{"$f":"'T&Z'!G11","v":0},{"$f":"'T&Z'!H11","v":0},{"$f":"'T&Z'!I11","v":0},{"$f":"'T&Z'!J11","v":0},{"$f":"'T&Z'!K11","v":0},{"$f":"'T&Z'!L11","v":0},{"$f":"'T&Z'!M11","v":0}]
[1,"01","2017","6","Kosten","Variable Kosten","Kulanz",1,{"$f":"'T&Z'!B12","v":1412.2672111140701},{"$f":"'T&Z'!C12","v":1246.9662143744965},{"$f":"'T&Z'!D12","v":1715.5538056407345},{"$f":"'T&Z'!E12","v":1827.7413759872807},{"$f":"'T&Z'!F12","v":1530.2107100394812},{"$f":"'T&Z'!G12","v":1677.8396227632838},{"$f":"'T&Z'!H12","v":1489.9443240514183},{"$f":"'T&Z'!I12","v":1549.8303517782331},{"$f":"'T&Z'!J12","v":1414.4414887142113},{"$f":"'T&Z'!K12","v":2007.323943756373},{"$f":"'T&Z'!L12","v":1958.0143475050968},{"$f":"'T&Z'!M12","v":1669.8666042753202}]
[1,"01","2017","6","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"'T&Z'!B13","v":0},{"$f":"'T&Z'!C13","v":0},{"$f":"'T&Z'!D13","v":0},{"$f":"'T&Z'!E13","v":0},{"$f":"'T&Z'!F13","v":0},{"$f":"'T&Z'!G13","v":0},{"$f":"'T&Z'!H13","v":0},{"$f":"'T&Z'!I13","v":0},{"$f":"'T&Z'!J13","v":0},{"$f":"'T&Z'!K13","v":0},{"$f":"'T&Z'!L13","v":0},{"$f":"'T&Z'!M13","v":0}]
[1,"01","2017","6","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"'T&Z'!B16","v":21133.966666666667},{"$f":"'T&Z'!C16","v":21133.966666666667},{"$f":"'T&Z'!D16","v":21133.966666666667},{"$f":"'T&Z'!E16","v":21133.966666666667},{"$f":"'T&Z'!F16","v":21133.966666666667},{"$f":"'T&Z'!G16","v":21133.966666666667},{"$f":"'T&Z'!H16","v":21133.966666666667},{"$f":"'T&Z'!I16","v":21133.966666666667},{"$f":"'T&Z'!J16","v":21133.966666666667},{"$f":"'T&Z'!K16","v":21133.966666666667},{"$f":"'T&Z'!L16","v":21133.966666666667},{"$f":"'T&Z'!M16","v":21133.966666666667}]
[1,"01","2017","6","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"'T&Z'!B17","v":53.541666666666664},{"$f":"'T&Z'!C17","v":53.541666666666664},{"$f":"'T&Z'!D17","v":53.541666666666664},{"$f":"'T&Z'!E17","v":53.541666666666664},{"$f":"'T&Z'!F17","v":53.541666666666664},{"$f":"'T&Z'!G17","v":53.541666666666664},{"$f":"'T&Z'!H17","v":53.541666666666664},{"$f":"'T&Z'!I17","v":53.541666666666664},{"$f":"'T&Z'!J17","v":53.541666666666664},{"$f":"'T&Z'!K17","v":53.541666666666664},{"$f":"'T&Z'!L17","v":53.541666666666664},{"$f":"'T&Z'!M17","v":53.541666666666664}]
[1,"01","2017","6","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"'T&Z'!B18","v":104.94166666666666},{"$f":"'T&Z'!C18","v":104.94166666666666},{"$f":"'T&Z'!D18","v":104.94166666666666},{"$f":"'T&Z'!E18","v":104.94166666666666},{"$f":"'T&Z'!F18","v":104.94166666666666},{"$f":"'T&Z'!G18","v":104.94166666666666},{"$f":"'T&Z'!H18","v":104.94166666666666},{"$f":"'T&Z'!I18","v":104.94166666666666},{"$f":"'T&Z'!J18","v":104.94166666666666},{"$f":"'T&Z'!K18","v":104.94166666666666},{"$f":"'T&Z'!L18","v":104.94166666666666},{"$f":"'T&Z'!M18","v":104.94166666666666}]
[1,"01","2017","6","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"'T&Z'!B19","v":0},{"$f":"'T&Z'!C19","v":0},{"$f":"'T&Z'!D19","v":0},{"$f":"'T&Z'!E19","v":0},{"$f":"'T&Z'!F19","v":0},{"$f":"'T&Z'!G19","v":0},{"$f":"'T&Z'!H19","v":0},{"$f":"'T&Z'!I19","v":0},{"$f":"'T&Z'!J19","v":0},{"$f":"'T&Z'!K19","v":0},{"$f":"'T&Z'!L19","v":0},{"$f":"'T&Z'!M19","v":0}]
[1,"01","2017","6","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"'T&Z'!B20","v":124.21666666666665},{"$f":"'T&Z'!C20","v":124.21666666666665},{"$f":"'T&Z'!D20","v":124.21666666666665},{"$f":"'T&Z'!E20","v":124.21666666666665},{"$f":"'T&Z'!F20","v":124.21666666666665},{"$f":"'T&Z'!G20","v":124.21666666666665},{"$f":"'T&Z'!H20","v":124.21666666666665},{"$f":"'T&Z'!I20","v":124.21666666666665},{"$f":"'T&Z'!J20","v":124.21666666666665},{"$f":"'T&Z'!K20","v":124.21666666666665},{"$f":"'T&Z'!L20","v":124.21666666666665},{"$f":"'T&Z'!M20","v":124.21666666666665}]
[1,"01","2017","7","Umsatzerlöse","VE Mietwagen",null,1,{"$f":"MW!B3*-1","v":-7532.0917926083739},{"$f":"MW!C3*-1","v":-6650.4864766639821},{"$f":"MW!D3*-1","v":-9149.6202967505851},{"$f":"MW!E3*-1","v":-9747.9540052654975},{"$f":"MW!F3*-1","v":-8161.1237868772332},{"$f":"MW!G3*-1","v":-8948.4779880708484},{"$f":"MW!H3*-1","v":-7946.3697282742314},{"$f":"MW!I3*-1","v":-8265.7618761505764},{"$f":"MW!J3*-1","v":-7543.6879398091269},{"$f":"MW!K3*-1","v":-10705.727700033989},{"$f":"MW!L3*-1","v":-10442.74318669385},{"$f":"MW!M3*-1","v":-8905.9552228017092}]
[1,"01","2017","7","Einsatzwerte","EW Service",null,1,{"$f":"MW!B4","v":0},{"$f":"MW!C4","v":0},{"$f":"MW!D4","v":0},{"$f":"MW!E4","v":0},{"$f":"MW!F4","v":0},{"$f":"MW!G4","v":0},{"$f":"MW!H4","v":0},{"$f":"MW!I4","v":0},{"$f":"MW!J4","v":0},{"$f":"MW!K4","v":0},{"$f":"MW!L4","v":0},{"$f":"MW!M4","v":0}]
[1,"01","2017","7","Kosten","Variable Kosten","Fixum/Prov./Soz.",1,{"$f":"MW!B8","v":0},{"$f":"MW!C8","v":0},{"$f":"MW!D8","v":0},{"$f":"MW!E8","v":0},{"$f":"MW!F8","v":0},{"$f":"MW!G8","v":0},{"$f":"MW!H8","v":0},{"$f":"MW!I8","v":0},{"$f":"MW!J8","v":0},{"$f":"MW!K8","v":0},{"$f":"MW!L8","v":0},{"$f":"MW!M8","v":0}]
[1,"01","2017","7","Kosten","Variable Kosten","Provisionen",1,{"$f":"MW!B9","v":0},{"$f":"MW!C9","v":0},{"$f":"MW!D9","v":0},{"$f":"MW!E9","v":0},{"$f":"MW!F9","v":0},{"$f":"MW!G9","v":0},{"$f":"MW!H9","v":0},{"$f":"MW!I9","v":0},{"$f":"MW!J9","v":0},{"$f":"MW!K9","v":0},{"$f":"MW!L9","v":0},{"$f":"MW!M9","v":0}]
[1,"01","2017","7","Kosten","Variable Kosten","Fertigmachen",1,{"$f":"MW!B10","v":0},{"$f":"MW!C10","v":0},{"$f":"MW!D10","v":0},{"$f":"MW!E10","v":0},{"$f":"MW!F10","v":0},{"$f":"MW!G10","v":0},{"$f":"MW!H10","v":0},{"$f":"MW!I10","v":0},{"$f":"MW!J10","v":0},{"$f":"MW!K10","v":0},{"$f":"MW!L10","v":0},{"$f":"MW!M10","v":0}]
[1,"01","2017","7","Kosten","Variable Kosten","Kulanz",1,{"$f":"MW!B11","v":0},{"$f":"MW!C11","v":0},{"$f":"MW!D11","v":0},{"$f":"MW!E11","v":0},{"$f":"MW!F11","v":0},{"$f":"MW!G11","v":0},{"$f":"MW!H11","v":0},{"$f":"MW!I11","v":0},{"$f":"MW!J11","v":0},{"$f":"MW!K11","v":0},{"$f":"MW!L11","v":0},{"$f":"MW!M11","v":0}]
[1,"01","2017","7","Kosten","Variable Kosten","sonst. variable Kosten",1,{"$f":"MW!B12","v":0},{"$f":"MW!C12","v":0},{"$f":"MW!D12","v":0},{"$f":"MW!E12","v":0},{"$f":"MW!F12","v":0},{"$f":"MW!G12","v":0},{"$f":"MW!H12","v":0},{"$f":"MW!I12","v":0},{"$f":"MW!J12","v":0},{"$f":"MW!K12","v":0},{"$f":"MW!L12","v":0},{"$f":"MW!M12","v":0}]
[1,"01","2017","7","Kosten","Direkte Kosten","Personalkosten",1,{"$f":"MW!B15","v":0},{"$f":"MW!C15","v":0},{"$f":"MW!D15","v":0},{"$f":"MW!E15","v":0},{"$f":"MW!F15","v":0},{"$f":"MW!G15","v":0},{"$f":"MW!H15","v":0},{"$f":"MW!I15","v":0},{"$f":"MW!J15","v":0},{"$f":"MW!K15","v":0},{"$f":"MW!L15","v":0},{"$f":"MW!M15","v":0}]
[1,"01","2017","7","Kosten","Direkte Kosten","Werbekosten",1,{"$f":"MW!B16","v":-179.08333333333334},{"$f":"MW!C16","v":-179.08333333333334},{"$f":"MW!D16","v":-179.08333333333334},{"$f":"MW!E16","v":-179.08333333333334},{"$f":"MW!F16","v":-179.08333333333334},{"$f":"MW!G16","v":-179.08333333333334},{"$f":"MW!H16","v":-179.08333333333334},{"$f":"MW!I16","v":-179.08333333333334},{"$f":"MW!J16","v":-179.08333333333334},{"$f":"MW!K16","v":-179.08333333333334},{"$f":"MW!L16","v":-179.08333333333334},{"$f":"MW!M16","v":-179.08333333333334}]
[1,"01","2017","7","Kosten","Direkte Kosten","Fahrzeugkosten",1,{"$f":"MW!B17","v":2387.5833333333335},{"$f":"MW!C17","v":2387.5833333333335},{"$f":"MW!D17","v":2387.5833333333335},{"$f":"MW!E17","v":2387.5833333333335},{"$f":"MW!F17","v":2387.5833333333335},{"$f":"MW!G17","v":2387.5833333333335},{"$f":"MW!H17","v":2387.5833333333335},{"$f":"MW!I17","v":2387.5833333333335},{"$f":"MW!J17","v":2387.5833333333335},{"$f":"MW!K17","v":2387.5833333333335},{"$f":"MW!L17","v":2387.5833333333335},{"$f":"MW!M17","v":2387.5833333333335}]
[1,"01","2017","7","Kosten","Direkte Kosten","Abschreibungen",1,{"$f":"MW!B18","v":3624.8333333333335},{"$f":"MW!C18","v":3624.8333333333335},{"$f":"MW!D18","v":3624.8333333333335},{"$f":"MW!E18","v":3624.8333333333335},{"$f":"MW!F18","v":3624.8333333333335},{"$f":"MW!G18","v":3624.8333333333335},{"$f":"MW!H18","v":3624.8333333333335},{"$f":"MW!I18","v":3624.8333333333335},{"$f":"MW!J18","v":3624.8333333333335},{"$f":"MW!K18","v":3624.8333333333335},{"$f":"MW!L18","v":3624.8333333333335},{"$f":"MW!M18","v":3624.8333333333335}]
[1,"01","2017","7","Kosten","Direkte Kosten","Gemeinkosten",1,{"$f":"MW!B19","v":0},{"$f":"MW!C19","v":0},{"$f":"MW!D19","v":0},{"$f":"MW!E19","v":0},{"$f":"MW!F19","v":0},{"$f":"MW!G19","v":0},{"$f":"MW!H19","v":0},{"$f":"MW!I19","v":0},{"$f":"MW!J19","v":0},{"$f":"MW!K19","v":0},{"$f":"MW!L19","v":0},{"$f":"MW!M19","v":0}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Personalkosten",1,{"$f":"'C&S'!B25","v":31000},{"$f":"'C&S'!C25","v":31000},{"$f":"'C&S'!D25","v":31000},{"$f":"'C&S'!E25","v":31000},{"$f":"'C&S'!F25","v":31000},{"$f":"'C&S'!G25","v":31000},{"$f":"'C&S'!H25","v":31000},{"$f":"'C&S'!I25","v":31000},{"$f":"'C&S'!J25","v":31000},{"$f":"'C&S'!K25","v":31000},{"$f":"'C&S'!L25","v":31000},{"$f":"'C&S'!M25","v":31000}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Werbekosten",1,{"$f":"'C&S'!B26","v":1083.3333333333333},{"$f":"'C&S'!C26","v":1083.3333333333333},{"$f":"'C&S'!D26","v":1083.3333333333333},{"$f":"'C&S'!E26","v":1083.3333333333333},{"$f":"'C&S'!F26","v":1083.3333333333333},{"$f":"'C&S'!G26","v":1083.3333333333333},{"$f":"'C&S'!H26","v":1083.3333333333333},{"$f":"'C&S'!I26","v":1083.3333333333333},{"$f":"'C&S'!J26","v":1083.3333333333333},{"$f":"'C&S'!K26","v":1083.3333333333333},{"$f":"'C&S'!L26","v":1083.3333333333333},{"$f":"'C&S'!M26","v":1083.3333333333333}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Fahrzeugkosten",1,{"$f":"'C&S'!B27","v":666.66666666666663},{"$f":"'C&S'!C27","v":666.66666666666663},{"$f":"'C&S'!D27","v":666.66666666666663},{"$f":"'C&S'!E27","v":666.66666666666663},{"$f":"'C&S'!F27","v":666.66666666666663},{"$f":"'C&S'!G27","v":666.66666666666663},{"$f":"'C&S'!H27","v":666.66666666666663},{"$f":"'C&S'!I27","v":666.66666666666663},{"$f":"'C&S'!J27","v":666.66666666666663},{"$f":"'C&S'!K27","v":666.66666666666663},{"$f":"'C&S'!L27","v":666.66666666666663},{"$f":"'C&S'!M27","v":666.66666666666663}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Abschreibungen",1,{"$f":"'C&S'!B28","v":8750},{"$f":"'C&S'!C28","v":8750},{"$f":"'C&S'!D28","v":8750},{"$f":"'C&S'!E28","v":8750},{"$f":"'C&S'!F28","v":8750},{"$f":"'C&S'!G28","v":8750},{"$f":"'C&S'!H28","v":8750},{"$f":"'C&S'!I28","v":8750},{"$f":"'C&S'!J28","v":8750},{"$f":"'C&S'!K28","v":8750},{"$f":"'C&S'!L28","v":8750},{"$f":"'C&S'!M28","v":8750}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Gemeinkosten",1,{"$f":"'C&S'!B29","v":41833.333333333336},{"$f":"'C&S'!C29","v":41833.333333333336},{"$f":"'C&S'!D29","v":41833.333333333336},{"$f":"'C&S'!E29","v":41833.333333333336},{"$f":"'C&S'!F29","v":41833.333333333336},{"$f":"'C&S'!G29","v":41833.333333333336},{"$f":"'C&S'!H29","v":41833.333333333336},{"$f":"'C&S'!I29","v":41833.333333333336},{"$f":"'C&S'!J29","v":41833.333333333336},{"$f":"'C&S'!K29","v":41833.333333333336},{"$f":"'C&S'!L29","v":41833.333333333336},{"$f":"'C&S'!M29","v":41833.333333333336}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Raumkosten",1,{"$f":"'C&S'!B30","v":14333.333333333334},{"$f":"'C&S'!C30","v":14333.333333333334},{"$f":"'C&S'!D30","v":14333.333333333334},{"$f":"'C&S'!E30","v":14333.333333333334},{"$f":"'C&S'!F30","v":14333.333333333334},{"$f":"'C&S'!G30","v":14333.333333333334},{"$f":"'C&S'!H30","v":14333.333333333334},{"$f":"'C&S'!I30","v":14333.333333333334},{"$f":"'C&S'!J30","v":14333.333333333334},{"$f":"'C&S'!K30","v":14333.333333333334},{"$f":"'C&S'!L30","v":14333.333333333334},{"$f":"'C&S'!M30","v":14333.333333333334}]
[1,"01","2017","0","Kosten","Indirekte Kosten","Kalk. Kosten",1,{"$f":"'C&S'!B31","v":5500},{"$f":"'C&S'!C31","v":5500},{"$f":"'C&S'!D31","v":5500},{"$f":"'C&S'!E31","v":5500},{"$f":"'C&S'!F31","v":5500},{"$f":"'C&S'!G31","v":5500},{"$f":"'C&S'!H31","v":5500},{"$f":"'C&S'!I31","v":5500},{"$f":"'C&S'!J31","v":5500},{"$f":"'C&S'!K31","v":5500},{"$f":"'C&S'!L31","v":5500},{"$f":"'C&S'!M31","v":5500}]
[1,"01","2017","0","Neutrales Ergebnis","Neutraler Ertrag",null,1,{"$f":"'C&S'!B34*-1","v":2500},{"$f":"'C&S'!C34*-1","v":2500},{"$f":"'C&S'!D34*-1","v":2500},{"$f":"'C&S'!E34*-1","v":2500},{"$f":"'C&S'!F34*-1","v":2500},{"$f":"'C&S'!G34*-1","v":2500},{"$f":"'C&S'!H34*-1","v":2500},{"$f":"'C&S'!I34*-1","v":2500},{"$f":"'C&S'!J34*-1","v":2500},{"$f":"'C&S'!K34*-1","v":2500},{"$f":"'C&S'!L34*-1","v":2500},{"$f":"'C&S'!M34*-1","v":2500}]