{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Einfaches Kostenmodell","Parameter"],"not_rendered":{"charts":1,"images":16,"macros":1,"external_links":0,"defined_names":17,"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":"Einfaches Kostenmodell","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Mengengerüst"]
["Verkehrsleistung",null,null,null,"Personaleinsatz"]
["Fahrplankilometer",200000,null,null,"sehr effizient",0.8]
["Fahrplanstunden",9000,null,null,"effizient",0.9]
["Fahrplangeschwindigkeit:",{"$f":"B3/B4","v":22.222222222222221},null,null,"normal",1]
["Fahrzeugflottenzusammensetzung",null,null,null,"ineffizient",1.1000000000000001]
["Anteil Standardbus",1,null,null,"sehr ineffizient",1.2]
["Anteil Midibus",0,null,null,"Auswahl",3,{"$f":"INDEX(E3:F7,F8,1)","v":"normal"},{"$f":"INDEX(E3:F7,F8,2)","v":1}]
["Anteil Gelenkbus",0]
["Fahrplanqualität (bzgl. Personalbedarf)",null,null,null,"sehr effizient",0.8]
[null,null,null,null,"effizient",0.9]
["Fahrplanqualität (bzgl. Fahrzeugbedarf)",null,null,null,"normal",1]
[null,null,null,null,"ineffizient",1.1000000000000001]
["Kosten",null,null,null,"sehr ineffizient",1.2]
[null,"Gesamt","je FahrplanKm",null,"Auswahl",3,{"$f":"INDEX(E10:F14,F15,1)","v":"normal"},{"$f":"INDEX(E10:F14,F15,2)","v":1}]
["Fahrdienstkosten",{"$f":"Fahrdienstkosten()","v":257142.85714285716},{"$f":"B16/$B$3","v":1.2857142857142858},{"$f":"C16/$C$23","v":0.4108470852924398}]
["Fahrzeugkosten",{"$f":"Fahrzeugkosten()","v":127902.14664504812},{"$f":"B17/$B$3","v":0.63951073322524066},{"$f":"C17/$C$23","v":0.20435420503463866}]
["Antriebskosten",{"$f":"Antriebskosten()","v":80511.111111111124},0.40255555555555561,0.1286357151864391]
["Instandhaltungskosten",{"$f":" Instandhaltungskosten()","v":18867.005873732815},9.4335029368664072E-2,3.0144544777738487E-2]
["Reifenkosten",{"$f":"Reifenkosten()","v":28666.666666666668},0.14333333333333334,4.5801841730749769E-2]
["Kosten für die tägliche Versorgung",{"$f":"KostenTaeglicheVersorgung()","v":18000},0.09,2.8759295970470784E-2]
["Overheadkosten",{"$f":"Overheadkosten()","v":94794.796747967484},0.4739739837398374,0.15145731200752324]
["Gesamt",{"$f":"SUM(B16:B22)","v":625884.58418738341},{"$f":"SUM(C16:C22)","v":3.1294229209369173}]
[]
[]
[]
["Universität Stuttgart"]
["Institut für Straßen- und Verkehrswesen"]
["Lehrstuhl Verkehrsplanung und Verkehrsleittechnik"]

{"sheet":"Parameter","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,2],[12,0,12,2]]}
["Größe","Einheit","Wert"]
["Kosten"]
["k_Fahrdienst","€/h",20]
["K_Anschaffung_Midibus","€/a",210000]
["K_Anschaffung_Standardbus","€/a",230000]
["K_Anschaffung_Gelenkbus","€/a",330000]
["K_Versicherung_Midibus","€/a",1800]
["K_Versicherung_Standardbus","€/a",2000]
["K_Versicherung_Gelenkbus","€/a",2200]
["k_Personal_Instandhaltung","€/a",40000]
["k_Antriebskosten","€/l",1]
["k_täglicheVersorgung","€/km",0.09]
["Sonstige Parameter"]
["Restwert R","[-]",0.05]
["Nutzungsdauer ND","a",12]
["Fahrzeugreserve r","[-]",7.0000000000000007E-2]
["Zinssatz p","[-]",0.05]
["Personalwirkungsgrad n_PW","[-]",0.7]
["Anteil der Leerfahrtkilometer an Fahrplankilometern n_Fahrplan","[-]",0.15]