Asjad Aamir
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsHi, the jquery script you advised to put under script tags in html worked perfectly when I click on preview the form. But as soon as I inserted in blog post and published it, it isnt working.
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsHi, I checked in console. it is saying that adval is not a function.
Forum: Plugins
In reply to: [Calculated Fields Form] If else condition help neededHi, I made modifications in code but now it isn’t working. The calculator doesn’t stuck but the code doesn’t work.
(function(){ var options = ['Ger?te > Computer, Tablets & Netzwerk','Ger?te > Drucker','Ger?te > PC- und Videospiele > Ersatzteile & Werkzeuge','Ger?te > Foto & Camcorder','Ger?te > Foto- und Camcorder > Speicherkarten','Ger?te > Foto- und Camcorder > Objektive','Ger?te > Mobiltelefone & Kommunikation','Ger?te > Mobiltelefone & Kommunikation > Speicherkarten','Ger?te > Haushaltsger?te','Ger?te > PC- und Videospiele > Konsolen','Ger?te > Scanner','Ger?te > PC- und Videospiele > Speicherkarten','Ger?te > TV, Video & Audio','Ger?te > Elektrische Ger?te für Enthaarung und Rasur','Ger?te > Elektrische Mund- und Zahnpflege','Ger?te > Elektrische Haarstylingger?te','Zubeh?r > Drucker, Scanner & Zubeh?r','Zubeh?r > Ersatzteile & Werkzeuge > TV, Video & Audio','Zubeh?r > Zubeh?r für Mobiltelefone','Zubeh?r > Batterien & Strom für den Haushalt','Zubeh?r > Kabel & Stecker','Zubeh?r > Kameras, Drohnen & Fotozubeh?r','Zubeh?r > Notebook- & Desktop-Zubeh?r','Zubeh?r > Objektive & Filter','Zubeh?r > Stative & Zubeh?r','Zubeh?r > Tablet- & eBook-Zubeh?r','Zubeh?r > Tastaturen, M?use & Zeigeger?te','Zubeh?r > TV- & Home-Audio-Zubeh?r','Zubeh?r > PC- und Videospiele > Zubeh?r','Zubeh?r > Zubeh?r für tragbare Audioger?te','Auto & Motorrad > Teile','Auto & Motorrad > Autoentertainment','Auto & Motorrad > Dashcams','Auto & Motorrad > Elektronik-Zubeh?r','Auto & Motorrad > Einparkhilfen','Auto & Motorrad > GPS & Navigationsger?te','Auto & Motorrad > Zubeh?r für Ladestationen & Ladeger?te','Auto & Motorrad > Ladestationen & -ger?te','Auto & Motorrad > Felgen','Auto & Motorrad > Komplettr?der','Auto & Motorrad > Reifen','Auto & Motorrad > Bekleidung, Schutzausrüstung & Handelswaren','Auto & Motorrad > Transportsysteme','Auto & Motorrad > Motor?l','Gewerbe & Industrie','Garten & Terrasse','HEIMWERKEN','Kleidung & Accessoires','Sneaker ( Unterkategorie von Herrenschuhen )','Sneaker ( Unterkategorie von Damenschuhen )','Uhren & Schmuck','Uhren & Schmuck > Armbanduhren & Taschenuhren','Uhren & Schmuck > Armbanduhren & Taschenuhren > Sammleruhren','Uhren & Schmuck > Weitere Uhren','Uhren & Schmuck > Zubeh?r','Medien > Filme und Serien (au?er Film NFTs #262053)','Medien > Musik (au?er Musik NFTs #262054)','Medien > Eintrittskarten','Medien > PC- und Videospiele','Musikinstrumente','NFTs > Film-NFTs','NFTs > Musik NFTs','NFTs > NFT-Kunst','NFTs > TCG NFTs','NFTs > Nicht-Sport Sammelkarten NFTs','NFTs > Sport-Trading-Card-NFTs','NFTs > Aufstrebende NFTs','Antiquit?ten & Kunst ( Au?er NFT Kunst # 262051 )','Baby','Handwerk & Künstlerbedarf','Sch?nheit & Gesundheit ( Ausnahmen sind: Elektrische Ger?te für Enthaarung und Rasur # 260783 Elektrische Mund- und Zahnpflegeger?te # 260774 Elektrische Haarstylingger?te # 260773 )','Briefmarken','Bücher und Zeitschriften','Büro- und Schreibwaren','Feinschmecker','Haustierbedarf','M?bel & Wohnen','Modellbau','Münzen','Reisen','Sammeln & Seltenes ( Ausnahmen sind: Aufstrebende NFTs # 262050 TCG NFTs # 262056 Nicht-Sport Sammelkarten NFTs # 262052 Sport Trading Card NFTs # 262055 )','Spielzeug','Sport','Verschiedene']; var del = ['Eurozone und Schweden','Europa','USA & KANADA','UK','Alle anderen L?nder']; var perd = [0,0.016,0.016,0.012,0.033]; var adops = ['Keine','Bis zu 24 Fotos hinzufügen','Galerie Plus','Preisvorschlag (bei Angeboten im Festpreisformat)','Sofort-Kaufen-Preis (bei Auktionsangeboten)','Mindestpreis (bei Auktionsangeboten)','Untertitel','Startzeitplanung','Angebot mit nicht ?ffentlicher Bieter-/K?uferliste']; var adval = [0,0,2.75,0,0,MIN(fieldname33*0.03,150),1.5,0,0.35]; for (var i = 0; i < 16; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.05,0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } })();Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsHi, BASED ON requirements, the code lines have reached up to 63000. Now when I hit calculate button, it is stuck. What should I do? Here is the link:
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsThanks it works. Now, if I want code up ti 16th element in the erray, what will I write?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsHere it is: https://www.mein-gebuehrenrechner.de/?cff-form=12
There are some extra fields, ignore them. Only look at the fields I used in the code.
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsAre you there?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsI have deleted that single line comment. Now how can I use for loop for fieldnane45?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsI have everything setup just this confusion is left. How then I use for loop for this dropdown field fieldname45?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsI actually want to use for loop for the below example. I have a drop down fieldname45 with too many options to select from. These are basically product categories and each category shows same result due to which I want to use for loop. So how to use this for the code below?
(function(){ var options = ['Ger?te > Computer, Tablets & Netzwerk', Car accessories’]; for (var i = 0; i < options.length; i++) { // Set the value of fieldname45 to the current option in the loop fieldname45 = options[i]; if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname17 == 'Keine', fieldname26 == 'Eurozone und Schweden')) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.1,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.1,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(0.35,fieldname31*0.065,0,0); } else { return SUM(0.35,fieldname31*0.02,0,0); } } } } })();Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsDid you understand what I’m asking?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsMy basic question is how to use for loop in your plugin? I have fieldname45 with tons of dropdown options. So instead of using if else statement one by one for each option in dropdown, I want for loop to perform this task? Is there any way to do that?
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsI am using it but not working.
Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsIs this correct?
(function(){ var options = ['Ger?te > Computer, Tablets & Netzwerk', 'Option 2', 'Option 3', ...]; // Loop through the options array for (var i = 0; i < options.length; i++) { // Set the value of fieldname45 to the current option in the loop fieldname45 = options[i]; // Your code block goes here if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname17 == 'Keine', fieldname26 == 'Eurozone und Schweden')) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.1,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.1,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(fieldname30*0.05,fieldname31*0.065,0,0); } else { return SUM(fieldname30*0.05,fieldname31*0.02,0,0); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(0.35,fieldname31*0.065,0,0); } else { return SUM(0.35,fieldname31*0.02,0,0); } } } } })();Forum: Plugins
In reply to: [Calculated Fields Form] Hide and Show fieldsI did it. leave it. Can you please tell how to use for loop with if condition if one field has too many dropdowns?