Alice,1und1,Vodafone,Vergleich Break Even mit Excel, incl. Grafik Schnittpunkt

14/11/2009 - 18:19 von Markus Fischer | Report spam
Hallo,

ich stehe vor einem Problem.
Break Even nennt sich das, meine ich zumindest.
Wie könnte man das machen?

3 unterschiedliche Tarife.
Wie lange muss ich bei einem Anbieter sein, bis der eine oder andere
günstiger ist.

Bis dato bin ich bei Alice, 29.99 Eur monatlich

http://www.fileuploadx.de/442402
http://www1.minpic.de/bild_anzeigen.php?id“977&key“91456&ende


Stückzahl Alice 1und1 Vodafone
1 29,99 € 19,95 €
2 59,98 € 39,90 €
3 89,97 € 59,85 €
4 119,96 € 79,80 €
5 149,95 € 99,75 €
6 179,94 € 119,70 €
7 209,93 € 139,65 €
8 239,92 € 159,60 € 29,99 €
9 269,91 € 179,55 € 59,98 €
10 299,90 € 199,50 € 89,97 €
11 329,89 € 219,45 € 119,96 €
12 359,88 € 239,40 € 149,95 €
13 389,87 € 259,35 € 179,94 €
14 419,86 € 279,30 € 209,93 €
15 449,85 € 299,25 € 239,92 €
16 479,84 € ++ 319,20 € ++ 269,91 € ++ 16 Monate Alice17
509,83 € 339,15 € 299,90 € 17 Monate Vodafone
18 539,82 € 359,10 € 329,89 €
19 569,81 € 379,05 € 359,88 €
20 599,80 € 399,00 € 389,87 €
21 629,79 € 418,95 € 419,86 €
22 659,78 € 438,90 € 449,85 €
23 689,77 € 458,85 € 479,84 €
24 719,76 € 478,80 € 509,83 €

Gehe ich zu 1und1 habe ich 24 Monate zum Preis, wo ich 16 Monate nur Alice
bekomme.


Grüße Markus

Anlage: XML Datei



<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>s</Author>
<LastAuthor>R</LastAuthor>
<LastPrinted>2005-05-02T06:19:15Z</LastPrinted>
<Created>2005-04-14T08:25:13Z</Created>
<LastSaved>2009-11-14T17:05:34Z</LastSaved>
<Company>G</Company>
<Version>11.979</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<SupBook>
<Path>J:\Dokumente und Einstellungenuss\Eigene
Dateien\BreakEven.xls</Path>
<SheetName>Break Even</SheetName>
<Xct>
<Count>4</Count>
<SheetIndex>0</SheetIndex>
<Crn>
<Row>2</Row>
<ColFirst>1</ColFirst>
<ColLast>1</ColLast>
<Number>0.64999999999999991</Number>
</Crn>
<Crn>
<Row>3</Row>
<ColFirst>1</ColFirst>
<ColLast>1</ColLast>
<Number>1.9</Number>
</Crn>
<Crn>
<Row>4</Row>
<ColFirst>1</ColFirst>
<ColLast>1</ColLast>
<Number>29</Number>
</Crn>
<Crn>
<Row>5</Row>
<ColFirst>1</ColFirst>
<ColLast>1</ColLast>
<Number>5</Number>
</Crn>
</Xct>
</SupBook>
<WindowHeight>11640</WindowHeight>
<WindowWidth>15480</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>60</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s22" ss:Name="Wàhrung">
<NumberFormat
ss:Format="_-* #,##0.00\ &quot;€&quot;_-;\-* #,##0.00\
&quot;€&quot;_-;_-* &quot;-&quot;??\ &quot;€&quot;_-;_-@_-"/>
</Style>
<Style ss:ID="s25">
<NumberFormat
ss:Format="_-* #,##0.00\ &quot;€&quot;_-;\-* #,##0.00\
&quot;€&quot;_-;_-* &quot;-&quot;??\ &quot;€&quot;_-;_-@_-"/>
</Style>
<Style ss:ID="s29">
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s34" ss:Parent="s22">
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s36" ss:Parent="s22">
<Font/>
</Style>
</Styles>
<Names>
<NamedRange ss:Name="Fixe_Kosten"
ss:RefersTo="='J:\Dokumente und Einstellungenuss\Eigene
Dateien\[BreakEven.xls]Break Even'!R5C2"/>
<NamedRange ss:Name="Preis_pro_Stück"
ss:RefersTo="='J:\Dokumente und Einstellungenuss\Eigene
Dateien\[BreakEven.xls]Break Even'!R4C2"/>
<NamedRange ss:Name="Schrittweite"
ss:RefersTo="='J:\Dokumente und Einstellungenuss\Eigene
Dateien\[BreakEven.xls]Break Even'!R6C2"/>
<NamedRange ss:Name="Variable_Stückkosten"
ss:RefersTo="='J:\Dokumente und Einstellungenuss\Eigene
Dateien\[BreakEven.xls]Break Even'!R3C2"/>
</Names>
<Worksheet ss:Name="Alice_1_und_1">
<Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="41"
x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60">
<Column ss:Width="67.5"/>
<Column ss:StyleID="s22" ss:AutoFitWidth="0"/>
<Column ss:Width="79.5" ss:Span="1"/>
<Column ss:Index="5" ss:Width="81"/>
<Row ss:Index="4">
<Cell><Data ss:Type="String">Preis Alice</Data></Cell>
<Cell><Data ss:Type="Number">29.99</Data></Cell>
<Cell ss:Index="5" ss:StyleID="s29"/>
</Row>
<Row>
<Cell ss:Index="7" ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="String">Preis 1und1</Data></Cell>
<Cell><Data ss:Type="Number">19.95</Data></Cell>
</Row>
<Row>
<Cell ss:Index="7" ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="String">Vodafone</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s36"><Data ss:Type="String">7 Monate
frei</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">29.99</Data></Cell>
</Row>
<Row ss:Index="17">
<Cell ss:StyleID="s29"><Data ss:Type="String">Stückzahl</Data></Cell>
<Cell ss:StyleID="s34"><Data ss:Type="String">Alice</Data></Cell>
<Cell ss:StyleID="s29"><Data ss:Type="String">1und1</Data></Cell>
<Cell ss:StyleID="s29"><Data ss:Type="String">Vodafone</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">1</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">29.99</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">19.95</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">2</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">59.98</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">39.9</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">3</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">89.97</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">59.849999999999994</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">4</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">119.96</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">79.8</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">5</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">149.95</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">99.75</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">6</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">179.94</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">119.69999999999999</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">7</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data
ss:Type="Number">209.92999999999998</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">139.65</Data></Cell>
<Cell ss:StyleID="s25"/>
</Row>
<Row>
<Cell><Data ss:Type="Number">8</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">239.92</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">159.6</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">29.99</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">9</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data
ss:Type="Number">269.90999999999997</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">179.54999999999998</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">59.98</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">10</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">299.9</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">199.5</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">89.97</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">11</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">329.89</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">219.45</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">119.96</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">12</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">359.88</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">239.39999999999998</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">149.95</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">13</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">389.87</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">259.34999999999997</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">179.94</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">14</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data
ss:Type="Number">419.85999999999996</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">279.3</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">209.92999999999998</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">15</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data
ss:Type="Number">449.84999999999997</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">299.25</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">239.92</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">16</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">479.84</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">319.2</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">269.90999999999997</Data></Cell>
<Cell ss:StyleID="s29"><Data ss:Type="String">16 Monate
Alice</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">17</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">509.83</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">339.15</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">299.9</Data></Cell>
<Cell ss:Index="6" ss:StyleID="s29"><Data ss:Type="String">17 Monate
Vodafone</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">18</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data
ss:Type="Number">539.81999999999994</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">359.09999999999997</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">329.89</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">19</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">569.81</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">379.05</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">359.88</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">20</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">599.8</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">399</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">389.87</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">21</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">629.79</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">418.95</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">419.85999999999996</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">22</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">659.78</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">438.9</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">449.84999999999997</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">23</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">689.77</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">458.84999999999997</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">479.84</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">24</Data></Cell>
<Cell ss:Formula="=RC1*R4C2"><Data ss:Type="Number">719.76</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=RC1*R6C2"><Data
ss:Type="Number">478.79999999999995</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(RC[-3]-7)*R10C2"><Data
ss:Type="Number">509.83</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Layout x:Orientation="Landscape"/>
<Header x:Margin="0.4921259845"/>
<Footer x:Margin="0.4921259845"/>
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/>
</PageSetup>
<FitToPage/>
<Print>
<ValidPrinterInfo/>
<PaperSizeIndex>9</PaperSizeIndex>
<Scale>49</Scale>
<HorizontalResolution>600</HorizontalResolution>
<VerticalResolution>600</VerticalResolution>
</Print>
<Selected/>
<TopRowVisible>24</TopRowVisible>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>20</ActiveRow>
<ActiveCol>4</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
<ConditionalFormatting xmlns="urn:schemas-microsoft-com:office:excel">
<Range>R19C5:R41C5</Range>
<Condition>
<Value1>AND(RC2&gt;=R[-1]C3,R[-1]C2&lt;=R[-1]C3)</Value1>
<Format Style='color:green'/>
</Condition>
</ConditionalFormatting>
<ConditionalFormatting xmlns="urn:schemas-microsoft-com:office:excel">
<Range>R18C1:R41C1</Range>
<Condition>
<Value1>MOD(ROW(),2)=0</Value1>
<Format Style='background:#CCFFFF'/>
</Condition>
</ConditionalFormatting>
</Worksheet>
</Workbook>
 

Lesen sie die antworten

#1 Eberhard Funke
14/11/2009 - 21:52 | Warnen spam
Am Sat, 14 Nov 2009 18:19:49 +0100 schrieb Markus Fischer:

Hallo Markus,

ich stehe vor einem Problem.
Break Even nennt sich das, meine ich zumindest.
Wie könnte man das machen?



genau so, wie Du es gemacht hast (Grafik)

3 unterschiedliche Tarife.
Wie lange muss ich bei einem Anbieter sein, bis der eine oder andere
günstiger ist.



Alice ist immer am teuersten.
Die Kurven von 1und1 und Vodafone schneiden sich bei 21.
Unter 21 ist Vodafone günstiger, darüber 1und1

Mit freundlichen Grüssen Eberhard
XP home XL 2000
Eberhard(punkt)W(punkt)Funke(at)t-online.de

Ähnliche fragen