{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Kostenkalkulation VR-Bildung4.0","Paket"," Einmalig Qualifiaktionsmgmt","Laufend Qualifikation","VR Bildung Zugang V1"," VR Bildung Plus Abrechnung","Haus LMS Perbility"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kostenkalkulation VR-Bildung4.0","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,5],[7,1,8,1],[12,1,13,1],[11,3,11,4],[6,3,6,4]]}
[]
[null,null,"Berechnung VR-Bildung Nutzungsentgelt"]
[]
[null,null,"Bilanzsumme","hier eintragen:",0]
[]
[null,null,"Kostenübersicht Laufende Kosten","Einzelpreis*","Gesamtpreis*"]
[null,"Basis","Basispaket VRB 4.0 Zugang + Qualifikationsmanagement (1)",{"$f":"Paket!H19","v":750},null,"  Modul 1"]
[null,"Optional","Ergänzungsmodul VR-Bildung Haus-LMS (2)",{"$f":"'Haus LMS Perbility'!H19","v":2800},{"$f":"D7+D8","v":3550},"  Modul 1 & 2"]
[]
[]
[null,null,"Kostenübersicht Einmalige Kosten ","Einzelpreis*","Gesamtpreis* "]
[null,"Basis","Einrichtungspreis Basispaket VRB 4.0 Zugang + Qualifikationsmanagement (1)",{"$f":"' Einmalig Qualifiaktionsmgmt'!H19","v":750},null,"  Modul 1 "]
[null,"Optional","Einrichtungspreis VR-Bildung Haus-LMS (2)",{"$f":"'Haus LMS Perbility'!L3","v":6750},{"$f":"D12+D13","v":7500},"  Modul 1 & 2"]
[]
[null,null,null,null,null,"*zzgl. Ust "]
[]
[null,null,"Anmerkung:"]
[null,null,"Diese Rechenhilfe dient als Orientierungshilfe für das Pricing. Trotz größter Sorgfalt bei der Erstellung des Tools, kann eine Haftung für den Inhalt nicht übernommen werden."]

{"sheet":"Paket","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Paket laufende Gebühr"]
[null,"laufende Gebühr"]
[null,"Input Parameter Berechnungsformel"]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,1000000000,4.25,1000000]
[null,3000000000,3.5]
[null,6000000000,2.25]
[null,null,0.5]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme",null,"zu zahlender Betrag","Anteil Quali","Ertrag ABG laufend"]
[null,null,null,null,null,400000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":1700},{"$f":"IF(G11<750,750,G11)","v":1700},{"$f":"'Laufend Qualifikation'!H11","v":600},{"$f":"H11-I11*2/3","v":1300}]
[null,null,null,null,null,750000000,3187.5,{"$f":"IF(G12<750,750,G12)","v":3187.5},{"$f":"'Laufend Qualifikation'!H12","v":1125},{"$f":"H12-I12*2/3","v":2437.5}]
[null,null,null,null,null,1500000000,6000,6000,{"$f":"'Laufend Qualifikation'!H13","v":1750},4833.333333333333]
[null,null,null,null,null,3000000000,11250,11250,{"$f":"'Laufend Qualifikation'!H14","v":2500},9583.3333333333339]
[null,null,null,null,null,4000000000,13500,13500,{"$f":"'Laufend Qualifikation'!H15","v":2750},11666.666666666666]
[null,null,null,null,null,6000000000,18000,18000,{"$f":"'Laufend Qualifikation'!H16","v":3250},15833.333333333334]
[null,null,null,null,null,10000000000,20000,20000,{"$f":"'Laufend Qualifikation'!H17","v":4250},17166.666666666668]
[null,null,null,null,null,0,0,750,{"$f":"'Laufend Qualifikation'!H18","v":500},416.66666666666669]
[null,null,null,null,"Eingabe Übersichtsmaske",{"$f":"'Kostenkalkulation VR-Bildung4.0'!E4","v":0},0,{"$f":"IF(G19<750,750,G19)","v":750},{"$f":"'Laufend Qualifikation'!H19","v":500},416.66666666666669]

{"sheet":" Einmalig Qualifiaktionsmgmt","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null," Qualifikationsmanagement"]
[null,"Einmalige Gebühr"]
[null,"Input Parameter Berechnungsformel"]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,1000000000,2.5,1000000]
[null,3000000000,1.5]
[null,6000000000,0.5]
[null,null,0.25]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme ",null,"zu zahlender Betrag"]
[null,null,null,null,null,400000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":1000},{"$f":"IF(G11<750,750,G11)","v":1000}]
[null,null,null,null,null,750000000,1875,{"$f":"IF(G12<750,750,G12)","v":1875}]
[null,null,null,null,null,1500000000,3250,3250]
[null,null,null,null,null,3000000000,5500,5500]
[null,null,null,null,null,4000000000,6000,6000]
[null,null,null,null,null,6000000000,7000,7000]
[null,null,null,null,null,10000000000,8000,8000]
[null,null,null,null,null,0,0,750]
[null,null,null,null,"Eingabe Übersichtsmaske",{"$f":"'Kostenkalkulation VR-Bildung4.0'!E4","v":0},0,750]

{"sheet":"Laufend Qualifikation","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Qualifikationsmanagement "]
[null,"laufende Gebühr"]
[null,"Input Parameter Berechnungsformel"]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,1000000000,1.5,1000000]
[null,3000000000,0.5]
[null,6000000000,0.25]
[null,null,0.25]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme ",null,"zu zahlender Betrag Bank","Ertrag ABG"]
[null,null,null,null,null,400000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":600},{"$f":"IF(G11<500,500,G11)","v":600},{"$f":"H11*1/3","v":200}]
[null,null,null,null,null,750000000,1125,{"$f":"IF(G12<500,500,G12)","v":1125},{"$f":"H12*1/3","v":375}]
[null,null,null,null,null,1500000000,1750,1750,583.33333333333337]
[null,null,null,null,null,3000000000,2500,2500,833.33333333333337]
[null,null,null,null,null,4000000000,2750,2750,916.66666666666663]
[null,null,null,null,null,6000000000,3250,3250,1083.3333333333333]
[null,null,null,null,null,10000000000,4250,4250,1416.6666666666667]
[null,null,null,null,null,0,0,500,166.66666666666666]
[null,null,null,null,null,{"$f":"'Kostenkalkulation VR-Bildung4.0'!E4","v":0},0,500,166.66666666666666]

{"sheet":"VR Bildung Zugang V1","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"VR-Bildung Zugang"]
[null,"Einmalige und laufende Gebühr"]
[null,"Input Parameter Berechnungsformel"]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,3000000000,3,1000000]
[null,5000000000,2.5]
[null,7000000000,1]
[null,null,0.25]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme"]
[null,null,null,null,null,400000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":1200}]
[null,null,null,null,null,750000000,{"$f":"IF(F12>$B$7,((F12-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F12>$B$6,((F12-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F12>$B$5,(F12-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F12*$C$5/$D$5)))","v":2250}]
[null,null,null,null,null,1500000000,4500]
[null,null,null,null,null,3000000000,9000]
[null,null,null,null,null,4000000000,11500]
[null,null,null,null,null,6000000000,15000]
[null,null,null,null,null,10000000000,16750]
[null,null,null,null,null,null,0]

{"sheet":" VR Bildung Plus Abrechnung","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"VR-Bildung Plus",null,null,null,"2020-03-02"]
[null,"Einmalige und laufende Gebühr"]
[null,"Input Parameter Berechnungsformel"]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,1000000000,0.75,1000000]
[null,3000000000,0.25]
[null,7000000000,0.1]
[null,null,0.05]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme ",null,"zu zahlender Betrag"]
[null,null,null,null,null,400000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":300},{"$f":"IF(G11<250,250,G11)","v":300}]
[null,null,null,null,null,750000000,562.5,{"$f":"IF(G12<250,250,G12)","v":562.5}]
[null,null,null,null,null,1500000000,875,875]
[null,null,null,null,null,3000000000,1250,1250]
[null,null,null,null,null,4000000000,1350,1350]
[null,null,null,null,null,6000000000,1550,1550]
[null,null,null,null,null,10000000000,1800,1800]
[null,null,null,null,null,null,{"$f":"IF(F18>$B$7,((F18-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F18>$B$6,((F18-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F18>$B$5,(F18-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F18*$C$5/$D$5)))","v":0}]
[null,null,null,null,"Eingabe Übersichtsmaske",{"$f":"'Kostenkalkulation VR-Bildung4.0'!E4","v":0},{"$f":"IF(F19>$B$7,((F19-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F19>$B$6,((F19-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F19>$B$5,(F19-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F19*$C$5/$D$5)))","v":0},250]

{"sheet":"Haus LMS Perbility","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Haus LMS Perbility "]
[null,"laufende Gebühr"]
[null,"Input Parameter Berechnungsformel",null,null,null,null,null,null,null,null,"Einmalbetrag ",6750]
[null,"Schwellenwerte","Multiplikator","Teiler"]
[null,1000000000,7,1000000]
[null,3000000000,1]
[null,6000000000,0.75]
[null,null,0.5]
[]
["Nr. ","Kontaktnr.","Name","Name 2","Straße","Bilanzsumme ",null,"zu zahlender Betrag","Ertrag RA"]
[null,null,null,null,null,500000000,{"$f":"IF(F11>$B$7,((F11-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$6,((F11-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F11>$B$5,(F11-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F11*$C$5/$D$5)))","v":3500},{"$f":"IF(G11<2800,2800,G11)","v":3500},{"$f":"H11*1/3","v":1166.6666666666667}]
[null,null,null,null,null,750000000,{"$f":"IF(F12>$B$7,((F12-$B$7)*$C$8/$D$5)+(($B$7-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F12>$B$6,((F12-$B$6)*$C$7/$D$5)+(($B$6-$B$5)*$C$6/$D$5)+($B$5*$C$5/$D$5),IF(F12>$B$5,(F12-$B$5)*$C$6/$D$5+($B$5*$C$5/$D$5),F12*$C$5/$D$5)))","v":5250},{"$f":"IF(G12<2800,2800,G12)","v":5250},{"$f":"H12*1/3","v":1750}]
[null,null,null,null,null,3500000000,9375,9375,3125]
[null,null,null,null,null,3000000000,9000,9000,3000]
[null,null,null,null,null,4000000000,9750,9750,3250]
[null,null,null,null,null,6000000000,11250,11250,3750]
[null,null,null,null,null,10000000000,13250,13250,4416.666666666667]
[null,null,null,null,null,0,0,2800,933.33333333333337]
[null,null,null,null,"Eingabe Übersichtsmaske",{"$f":"'Kostenkalkulation VR-Bildung4.0'!E4","v":0},0,2800,933.33333333333337]