| Zelle | Formel |
| I4 | =SUMMEWENN($F$2:$F$100;H4;$C$2:$C$100) |
| I5 | =SUMMEWENN($F$2:$F$100;H5;$C$2:$C$100) |
| C6 | =+C2*D6 |
| E6 | =+C3+30 |
| F6 | =KÜRZEN((E6-WOCHENTAG(E6;2)-DATUM(JAHR(E6+4-WOCHENTAG(E6;2)); 1;-10))/7)&". KW" |
| I6 | =SUMMEWENN($F$2:$F$100;H6;$C$2:$C$100) |
| C7 | =+C2*D7 |
| E7 | =+C3+60 |
| F7 | =KÜRZEN((E7-WOCHENTAG(E7;2)-DATUM(JAHR(E7+4-WOCHENTAG(E7;2)); 1;-10))/7)&". KW" |
| I7 | =SUMMEWENN($F$2:$F$100;H7;$C$2:$C$100) |
| C8 | =+C2*D8 |
| E8 | =+C3+90 |
| F8 | =KÜRZEN((E8-WOCHENTAG(E8;2)-DATUM(JAHR(E8+4-WOCHENTAG(E8;2)); 1;-10))/7)&". KW" |
| I8 | =SUMMEWENN($F$2:$F$100;H8;$C$2:$C$100) |
| C9 | =+C2*D9 |
| E9 | =+C3+180 |
| F9 | =KÜRZEN((E9-WOCHENTAG(E9;2)-DATUM(JAHR(E9+4-WOCHENTAG(E9;2)); 1;-10))/7)&". KW" |
| I9 | =SUMMEWENN($F$2:$F$100;H9;$C$2:$C$100) |
| I10 | =SUMMEWENN($F$2:$F$100;H10;$C$2:$C$100) |
| I11 | =SUMMEWENN($F$2:$F$100;H11;$C$2:$C$100) |
| I12 | =SUMMEWENN($F$2:$F$100;H12;$C$2:$C$100) |
| I13 | =SUMMEWENN($F$2:$F$100;H13;$C$2:$C$100) |
| I14 | =SUMMEWENN($F$2:$F$100;H14;$C$2:$C$100) |
| I15 | =SUMMEWENN($F$2:$F$100;H15;$C$2:$C$100) |
| C16 | =+C12*D16 |
| E16 | =+C13+30 |
| F16 | =KÜRZEN((E16-WOCHENTAG(E16;2)-DATUM(JAHR(E16+4-WOCHENTAG(E16;2)); 1;-10))/7)&". KW" |
| I16 | =SUMMEWENN($F$2:$F$100;H16;$C$2:$C$100) |
| C17 | =+C12*D17 |
| E17 | =+C13+60 |
| F17 | =KÜRZEN((E17-WOCHENTAG(E17;2)-DATUM(JAHR(E17+4-WOCHENTAG(E17;2)); 1;-10))/7)&". KW" |
| I17 | =SUMMEWENN($F$2:$F$100;H17;$C$2:$C$100) |
| C18 | =+C12*D18 |
| E18 | =+C13+90 |
| F18 | =KÜRZEN((E18-WOCHENTAG(E18;2)-DATUM(JAHR(E18+4-WOCHENTAG(E18;2)); 1;-10))/7)&". KW" |
| I18 | =SUMMEWENN($F$2:$F$100;H18;$C$2:$C$100) |
| C19 | =+C12*D19 |
| E19 | =+C13+180 |
| F19 | =KÜRZEN((E19-WOCHENTAG(E19;2)-DATUM(JAHR(E19+4-WOCHENTAG(E19;2)); 1;-10))/7)&". KW" |
| I19 | =SUMMEWENN($F$2:$F$100;H19;$C$2:$C$100) |
| I20 | =SUMMEWENN($F$2:$F$100;H20;$C$2:$C$100) |
| I21 | =SUMMEWENN($F$2:$F$100;H21;$C$2:$C$100) |
| I22 | =SUMMEWENN($F$2:$F$100;H22;$C$2:$C$100) |
| I23 | =SUMMEWENN($F$2:$F$100;H23;$C$2:$C$100) |
| I24 | =SUMMEWENN($F$2:$F$100;H24;$C$2:$C$100) |
| I25 | =SUMMEWENN($F$2:$F$100;H25;$C$2:$C$100) |
| C26 | =+C22*D26 |
| E26 | =+C23+30 |
| F26 | =KÜRZEN((E26-WOCHENTAG(E26;2)-DATUM(JAHR(E26+4-WOCHENTAG(E26;2)); 1;-10))/7)&". KW" |
| I26 | =SUMMEWENN($F$2:$F$100;H26;$C$2:$C$100) |
| C27 | =+C22*D27 |
| E27 | =+C23+60 |
| F27 | =KÜRZEN((E27-WOCHENTAG(E27;2)-DATUM(JAHR(E27+4-WOCHENTAG(E27;2)); 1;-10))/7)&". KW" |
| I27 | =SUMMEWENN($F$2:$F$100;H27;$C$2:$C$100) |
| C28 | =+C22*D28 |
| E28 | =+C23+90 |
| F28 | =KÜRZEN((E28-WOCHENTAG(E28;2)-DATUM(JAHR(E28+4-WOCHENTAG(E28;2)); 1;-10))/7)&". KW" |
| I28 | =SUMMEWENN($F$2:$F$100;H28;$C$2:$C$100) |
| C29 | =+C22*D29 |
| E29 | =+C23+180 |
| F29 | =KÜRZEN((E29-WOCHENTAG(E29;2)-DATUM(JAHR(E29+4-WOCHENTAG(E29;2)); 1;-10))/7)&". KW" |
| I29 | =SUMMEWENN($F$2:$F$100;H29;$C$2:$C$100) |
| I30 | =SUMMEWENN($F$2:$F$100;H30;$C$2:$C$100) |
| I31 | =SUMMEWENN($F$2:$F$100;H31;$C$2:$C$100) |
| I32 | =SUMMEWENN($F$2:$F$100;H32;$C$2:$C$100) |
| I33 | =SUMMEWENN($F$2:$F$100;H33;$C$2:$C$100) |
| I34 | =SUMMEWENN($F$2:$F$100;H34;$C$2:$C$100) |
| I35 | =SUMMEWENN($F$2:$F$100;H35;$C$2:$C$100) |
| I36 | =SUMMEWENN($F$2:$F$100;H36;$C$2:$C$100) |
| I37 | =SUMMEWENN($F$2:$F$100;H37;$C$2:$C$100) |
| I38 | =SUMMEWENN($F$2:$F$100;H38;$C$2:$C$100) |
| I39 | =SUMMEWENN($F$2:$F$100;H39;$C$2:$C$100) |
| I40 | =SUMMEWENN($F$2:$F$100;H40;$C$2:$C$100) |
| I41 | =SUMMEWENN($F$2:$F$100;H41;$C$2:$C$100) |
| I42 | =SUMMEWENN($F$2:$F$100;H42;$C$2:$C$100) |
| I43 | =SUMMEWENN($F$2:$F$100;H43;$C$2:$C$100) |
| I44 | =SUMMEWENN($F$2:$F$100;H44;$C$2:$C$100) |
| I45 | =SUMMEWENN($F$2:$F$100;H45;$C$2:$C$100) |