{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Input","Costs","Results","Figures"],"not_rendered":{"charts":4,"macros":1,"defined_names":92},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":5,"rows_kept":23}
[]
[{"$nulls":4},"Costing tool to calculate costs of a conventional OR and a hybrid OR"]
[]
[{"$nulls":4},"This costing tool is a supplement of the article \"Understanding the costs of surgery: a bottom-up cost analysis of both a hybrid and conventional operating room\"."]
[{"$nulls":4},"This study aimed to perform a comprehensive bottom-up cost-analysis to inform clinicians and policy makers on the costs and cost drivers of an (hybrid) OR "]
[{"$nulls":4},"as a first step in evaluating the added value of the hybrid OR. This costing tool enables usage and adjustment of the input parameters to a specific hospital or "]
[null,"Instructions",null,null,"country setting It is developed to provide insight in the costs and cost drivers of the conventional and hybrid OR. "]
[]
[{"$nulls":4},"The menu on the left side can be used to navigate trough the costing tool."]
[{"$nulls":4},"* In the sheet 'input parameters' and 'cost parameters' all input variables are provided. All cells highlighted in blue can be adapted to country or site specific values."]
[null,"Input parameters",null,null,"* The 'results' sheet provides the total annual and per minute costs for the different cost categories (construction, inventory, personnel and overhead) and the total "]
[{"$nulls":4},"   per minute costs for both the conventional and hybrid OR."]
[{"$nulls":4},"* The sheet 'figures' shows (1) the annual fixed costs of the conventional and hybrid OR; (2) the total costs per minute for the conventional and hybrid OR; "]
[{"$nulls":4},"   (3) the costs per minute for the conventional and hybrid OR for different utilization rates of the OR; (4) the costs per minute for the hybrid OR for different utilization "]
[null,"Cost parameters",null,null,"   rate of the fixed C-arm. "]
[]
[]
[]
[null,"Results"]
[]
[]
[]
[null,"Figures"]

{"sheet":"Input","index":1,"n_rows":54,"n_cols":11,"rows_kept":54}
[]
[{"$nulls":4},"Input parameters"]
[]
[{"$nulls":4},"1. Construction",null,null,"Original value in model","Source original value","Min","Max"]
[{"$nulls":5},"Surface conventional OR (m2)",{"v":48.52,"d":"48.5"},{"v":48.52,"d":"48.5"},null,40.6,{"v":57,"d":"57.0"}]
[{"$nulls":5},"Surface hybrid OR (m2)",{"v":85.36,"d":"85.4"},{"v":85.36,"d":"85.4"},null,52.3,106.2]
[null,"Instructions"]
[{"$nulls":5},"Lifespan of buildings (year)",25,25,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"Annual interest rate (%)",{"v":0.042,"d":"4.2%"},0.042,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"Maintenance costs (%)",{"v":0.05,"d":"5%"},0.05,"Manual for cost research in the Netherlands"]
[null,"Input parameters",{"$nulls":3},"Annuity",{"$f":"(1/Annual_interest_rate_buildings)*(1-1/((1+Annual_interest_rate_buildings)^Lifespan_of_buildings))","v":{"v":15.297011841419167,"d":"15.30"}}]
[]
[]
[{"$nulls":4},"2. Inventory"]
[null,"Cost parameters",{"$nulls":3},"Depreciation period of inventory (year)",10,10,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"Annual interest rate (%)",{"v":0.042,"d":"4.20%"},0.042,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"Maintenance costs (%)",{"v":0.05,"d":"5%"},0.05,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"Maintenance costs for advanced imaging technologies (%)",{"v":0.08,"d":"8%"},0.08,"Manual for cost research in the Netherlands"]
[null,"Results",{"$nulls":3},"Annuity",{"$f":"(1/Annual_interest_rate_inventory)*(1-1/((1+Annual_interest_rate_inventory)^Depreciation_period_of_inventory))","v":{"v":8.030740211762815,"d":"8.03"}}]
[]
[]
[{"$nulls":4},"3. Personnel"]
[null,"Figures",{"$nulls":3},"Conventional OR"]
[{"$nulls":5},"Surgeon",1,1,"Based on participating hospitals"]
[{"$nulls":5},"OR assistant",3,3,"Based on participating hospitals"]
[{"$nulls":5},"Anesthesist",0.5,0.5,"Based on participating hospitals"]
[{"$nulls":5},"Anesthetic assistant",1,1,"Based on participating hospitals"]
[]
[{"$nulls":5},"Hybrid OR"]
[{"$nulls":5},"Surgeon",1,1,"Based on participating hospitals"]
[{"$nulls":5},"OR assistant",3,3,"Based on participating hospitals"]
[{"$nulls":5},"Anesthesist",0.5,0.5,"Based on participating hospitals"]
[{"$nulls":5},"Anesthetic assistant",1,1,"Based on participating hospitals"]
[{"$nulls":5},"Technician",1,1,"Based on participating hospitals"]
[]
[]
[{"$nulls":4},"4. Overhead"]
[{"$nulls":5},"Overhead over direct costs*",{"v":0.38,"d":"38%"},0.38,"Manual for cost research in the Netherlands"]
[{"$nulls":5},"* personnel and construction costs"]
[]
[]
[{"$nulls":4},"5. Utilization of ORs",{"$nulls":4},"Min","Max"]
[{"$nulls":5},"Available hours of OR per year",{"$f":"51*5*8","v":{"v":2040,"d":"2,040"}},{"v":2040,"d":"2,040"},"Assumption"]
[{"$nulls":5},"Utilization rate conventional OR",{"v":0.915,"d":"92%"},{"v":0.915,"d":"0.92"},"Based on participating hospitals",0.87,0.96]
[{"$nulls":5},"Utilization rate hybrid OR",{"v":0.4328,"d":"43%"},{"v":0.4328,"d":"0.43"},"Based on participating hospitals",{"v":0.1437,"d":"0.14"},{"v":0.549,"d":"0.55"}]
{"$rows_empty":8}
[{"$nulls":8},0.2]

{"sheet":"Costs","index":2,"n_rows":38,"n_cols":13,"rows_kept":38}
[]
[{"$nulls":4},"Cost parameters"]
[]
[{"$nulls":4},"1. Construction",null,null,"Original value in model","Source original value","Min","Max","Original value in model"]
[{"$nulls":5},"Cost for a m2 of OR",{"v":12803.6,"d":"€ 12,804"},{"v":12803.6,"d":"12,804"},"Based on participating hospitals",{"v":10064,"d":"€ 10,064"},{"v":14768,"d":"€ 14,768"},{"v":10064,"d":"10,064"},{"v":14768,"d":"14,768"}]
[{"$nulls":5},"Total costs conventional OR",{"$f":"Costs_m2OR*Surface_conventional_OR","v":{"v":621230.672,"d":"€ 621,231"}},null,null,{"$f":"min_Csurface*min_surface_conventional","v":{"v":408598.4,"d":"€ 408,598"}},{"$f":"max_Csurface*max_surface_conventional","v":{"v":841776,"d":"€ 841,776"}}]
[null,"Instructions",{"$nulls":3},"Total costs hybrid OR",{"$f":"Costs_m2OR*Surface_hybrid_OR","v":{"v":1092915.296,"d":"€ 1,092,915"}},null,null,{"$f":"min_Csurface*min_surface_hybrid","v":{"v":526347.2,"d":"€ 526,347"}},{"$f":"max_Csurface*max_surface_hybrid","v":{"v":1568361.6,"d":"€ 1,568,362"}}]
[]
[]
[{"$nulls":4},"2. Inventory",null,null,"Original value in model",null,"Min","Max","Original value in model"]
[null,"Input parameters",{"$nulls":3},"Conventional OR"]
[{"$nulls":5},"General inventory",{"v":230420.72,"d":"€ 230,421"},{"v":230420.72,"d":"230,421"},"Based on participating hospitals","x","x",{"v":190027,"d":"190,027"},{"v":255000,"d":"255,000"}]
[{"$nulls":5},"Anesthesia",{"v":128308.24622088384,"d":"€ 128,308"},{"v":128308.24622088384,"d":"128,308"},"Based on participating hospitals","x","x",{"v":65000,"d":"65,000"},{"v":177052.28,"d":"177,052"}]
[{"$nulls":5},"OR lights",{"v":38591.7989443316,"d":"€ 38,592"},{"v":38591.798944331575,"d":"38,592"},"Based on participating hospitals","x","x",{"v":20030.26,"d":"20,030"},{"v":73133.58472165785,"d":"73,134"}]
[null,"Cost parameters",{"$nulls":3},"Arm pendants",{"v":69262.042,"d":"€ 69,262"},{"v":69262.042,"d":"69,262"},"Based on participating hospitals","x","x",{"v":40000,"d":"40,000"},{"v":96450,"d":"96,450"}]
[{"$nulls":5},"OR table",{"v":105980.598,"d":"€ 105,981"},{"v":105980.598,"d":"105,981"},"Based on participating hospitals","x","x",{"v":50000,"d":"50,000"},{"v":155160,"d":"155,160"}]
[{"$nulls":5},"Image routing system",{"v":76811.84,"d":"€ 76,812"},{"v":76811.84,"d":"76,812"},"Based on participating hospitals","x","x",0,{"v":122059.2,"d":"122,059"}]
[]
[null,"Results",{"$nulls":3},"Hybrid OR"]
[{"$nulls":5},"General inventory",{"v":244420.72,"d":"€ 244,421"},{"v":244420.72,"d":"244,421"},"Based on participating hospitals","x","x",{"v":190027,"d":"190,027"},{"v":296500,"d":"296,500"}]
[{"$nulls":5},"Anesthesia",{"v":128308.246220884,"d":"€ 128,308"},{"v":128308.24622088384,"d":"128,308"},"Based on participating hospitals","x","x",{"v":65000,"d":"65,000"},{"v":177052.28,"d":"177,052"}]
[{"$nulls":5},"OR lights",{"v":42597.8489443316,"d":"€ 42,598"},{"v":42597.84894433157,"d":"42,598"},"Based on participating hospitals","x","x",{"v":32000,"d":"32,000"},{"v":73133.58472165785,"d":"73,134"}]
[null,"Figures",{"$nulls":3},"Arm pendants",{"v":94789.298,"d":"€ 94,789"},{"v":94789.298,"d":"94,789"},"Based on participating hospitals","x","x",{"v":56000,"d":"56,000"},{"v":135333.1,"d":"135,333"}]
[{"$nulls":5},"OR table",{"v":265222.04,"d":"€ 265,222"},{"v":265222.04000000004,"d":"265,222"},"Based on participating hospitals","x","x",{"v":215000,"d":"215,000"},{"v":307130.61,"d":"307,131"}]
[{"$nulls":5},"Image routing system",{"v":93125.922,"d":"€ 93,126"},{"v":93125.92199999999,"d":"93,126"},"Based on participating hospitals","x","x",0,{"v":150000,"d":"150,000"}]
[{"$nulls":5},"X-ray radiation protection aprons",{"v":18383.8775,"d":"€ 18,384"},{"v":18383.8775,"d":"18,384"},"Based on participating hospitals","x","x",{"v":13353.5,"d":"13,354"},{"v":23682.01,"d":"23,682"}]
[{"$nulls":5},"C-arm cone-beam CT",{"v":1361554.31356522,"d":"€ 1,361,554"},{"v":1361554.313565218,"d":"1,361,554"},"Based on participating hospitals","x","x",{"v":1125648.93,"d":"1,125,649"},{"v":1550000,"d":"1,550,000"}]
[]
[]
[{"$nulls":4},"3. Personnel",{"$nulls":4},"Min","Max","Original value in model"]
[{"$nulls":5},"Surgeon",{"v":119.15372233400402,"d":"119.15"},{"v":119.15372233400402,"d":"119.15"},"Manual for cost research in the Netherlands",{"v":117.5927565392354,"d":"117.59"},{"v":120.71468812877262,"d":"120.71"},{"v":117.5927565392354,"d":"117.59"},120.7]
[{"$nulls":5},"OR assistant",37.45,37.45,"Collective Labor Agreements academic and general hospitals",36.84,38.06,36.84,38.06]
[{"$nulls":5},"Anesthesist",{"v":119.15372233400402,"d":"119.15"},{"v":119.15372233400402,"d":"119.15"},"Manual for cost research in the Netherlands",{"v":117.5927565392354,"d":"117.59"},{"v":120.71468812877262,"d":"120.71"},{"v":117.5927565392354,"d":"117.59"},120.7]
[{"$nulls":5},"Anesthetic assistant",37.45,37.45,"Collective Labor Agreements academic and general hospitals",36.84,38.06,36.84,38.06]
[{"$nulls":5},"Technician",37.45,37.45,"Collective Labor Agreements academic and general hospitals",36.84,38.06,36.84,38.06]
[]
[{"$nulls":5},"Total costs conventional OR",{"$f":"(nr_Surgeon_conventional*cSurgeon+nr_ORassisstant_conventional*cOR_assistant+cAnesthesist*nr_anesthesist_conventional+nr_anesth.assistant_conventional*cAnesthetic_assistant)","v":{"v":328.530583501006,"d":"328.53"}},null,null,{"$f":"nr_Surgeon_conventional*min_cSurgeon+nr_ORassisstant_conventional*min_cORassistant+nr_anesthesist_conventional*min_cAnesthesist+nr_anesth.assistant_conventional*min_cAnesth_assistant","v":{"v":323.7491348088531,"d":"323.75"}},{"$f":"nr_Surgeon_conventional*max_cSurgeon+nr_ORassisstant_conventional*max_cOR_assistant+nr_anesthesist_conventional*max_cAnesthesist+nr_anesth.assistant_conventional*max_cAnesth_assistant","v":{"v":333.3120321931589,"d":"333.31"}}]
[{"$nulls":5},"Total costs hybrid OR",{"$f":"(nr_surgeon_hybrid*cSurgeon+nr_ORassistant_hybrid*cOR_assistant+nr_anesthesist_hybrid*cAnesthesist+nr_anesth.assistant_hybrid*cAnesthetic_assistant+nr_technician_hybrid*cTechnician)","v":{"v":365.980583501006,"d":"365.98"}},null,null,{"$f":"nr_surgeon_hybrid*min_cSurgeon+nr_ORassistant_hybrid*min_cORassistant+nr_anesth.assistant_hybrid*min_cAnesth_assistant+nr_anesthesist_hybrid*min_cAnesthesist+nr_technician_hybrid*min_cTechnician","v":{"v":360.58913480885315,"d":"360.59"}},{"$f":"nr_surgeon_hybrid*max_cSurgeon+nr_ORassistant_hybrid*max_cOR_assistant+nr_anesth.assistant_hybrid*max_cAnesth_assistant+nr_anesthesist_hybrid*max_cAnesthesist+nr_technician_hybrid*max_cTechnician","v":{"v":371.372032193159,"d":"371.37"}}]

{"sheet":"Results","index":3,"n_rows":24,"n_cols":12,"rows_kept":24}
[]
[{"$nulls":4},"Results"]
[]
[{"$nulls":6},"Conventional OR","Min","Max","Hybrid OR","Min","Max"]
[{"$nulls":4},"1. Construction"]
[{"$nulls":5},"Annual",{"$f":"cTotal_construction_conventional/Annuity_construction+Maintenance_costs_buildings*cTotal_construction_conventional","v":{"v":71672.7770533074,"d":"€ 71,673"}},{"$f":"min_Ctotal_construction_conventional/Annuity_construction+min_Ctotal_construction_conventional*Maintenance_costs_buildings","v":{"v":47140.91455474388,"d":"€ 47,141"}},{"$f":"max_Ctotal_construction_conventional/Annuity_construction+max_Ctotal_construction_conventional*Maintenance_costs_buildings","v":{"v":97117.58658436764,"d":"€ 97,118"}},{"$f":"cTotal_construction_hybrid/Annuity_construction+Maintenance_costs_buildings*cTotal_construction_hybrid","v":{"v":126092.09087531576,"d":"€ 126,092"}},{"$f":"min_Ctotal_construction_hybrid/Annuity_construction+min_Ctotal_construction_hybrid*Maintenance_costs_buildings","v":{"v":60725.85791165283,"d":"€ 60,726"}},{"$f":"max_Ctotal_construction_hybrid/Annuity_construction+max_Ctotal_construction_hybrid*Maintenance_costs_buildings","v":{"v":180945.3981624534,"d":"€ 180,945"}}]
[null,"Instructions",{"$nulls":3},"Per minute",{"$f":"cAnnualConstructionConventional/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":0.6399583650604255,"d":"€ 0.64"}},{"$f":"min_cAnnual_construction_conventional/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":0.42091605552648204,"d":"€ 0.42"}},{"$f":"max_cAnnual_construction_conventional/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":0.8671522785132294,"d":"€ 0.87"}},{"$f":"cAnnualConstructionHybrid/(Available_OR_hours*60*utilizationrate_hybrid)","v":{"v":2.3802313797093357,"d":"€ 2.38"}},{"$f":"min_cAnnual_construction_hybrid/(Available_OR_hours*60*utilizationrate_hybrid)","v":{"v":1.1463176758962166,"d":"€ 1.15"}},{"$f":"max_cAnnual_construction_hybrid/(Available_OR_hours*60*utilizationrate_hybrid)","v":{"v":3.4156933375476717,"d":"€ 3.42"}}]
[]
[{"$nulls":4},"2. Inventory"]
[{"$nulls":5},"Annual",{"$f":"(SUM(Costs!G12:G17)/Annuity_inventory+(SUM(Costs!G12:G17)*Maintenance_costs_inventory))","v":{"v":113329.95662413756,"d":"€ 113,330"}},{"$f":"(SUM(Costs!L12:L17)/Annuity_inventory+(SUM(Costs!L12:L17)*Maintenance_costs_inventory))","v":{"v":63710.348907126216,"d":"€ 63,710"}},{"$f":"(SUM(Costs!M12:M17)/Annuity_inventory+(SUM(Costs!M12:M17)*Maintenance_costs_inventory))","v":{"v":153379.1241741414,"d":"€ 153,379"}},{"$f":"(SUM(Costs!G20:G26)/Annuity_inventory+(SUM(Costs!G20:G26)*Maintenance_costs_inventory))+(Costs!G27/Annuity_inventory+(Costs!G27*Maintenance_costs_for_advancedtechnology))","v":{"v":433241.21667010087,"d":"€ 433,241"}},{"$f":"(SUM(Costs!L20:L26)/Annuity_inventory+(SUM(Costs!L20:L26)*Maintenance_costs_inventory))+(Costs!L27/Annuity_inventory+(Costs!L27*Maintenance_costs_for_advancedtechnology))","v":{"v":329937.6281797367,"d":"€ 329,938"}},{"$f":"(SUM(Costs!M20:M26)/Annuity_inventory+(SUM(Costs!M20:M26)*Maintenance_costs_inventory))+(Costs!M27/Annuity_inventory+(Costs!M27*Maintenance_costs_for_advancedtechnology))","v":{"v":519947.4991372284,"d":"€ 519,947"}}]
[null,"Input parameters",{"$nulls":3},"Per minute",{"$f":"cAnnualInventoryConventional/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":1.011910752385242,"d":"€ 1.01"}},{"$f":"H10/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":0.5688627174821085,"d":"€ 0.57"}},{"$f":"I10/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":1.3695053767468608,"d":"€ 1.37"}},{"$f":"((SUM(Costs!G20:G26)/Annuity_inventory+(SUM(Costs!G20:G26)*Maintenance_costs_inventory))/(Available_OR_hours*60*utilizationrate_hybrid))+((Costs!G27/Annuity_inventory+(Costs!G27*Maintenance_costs_for_advancedtechnology))/(Available_OR_hours*60*(utilizationrate_hybrid*utilizationrate_carm/100)))","v":{"v":8.178263456042824,"d":"€ 8.18"}},{"$f":"K10/(Available_OR_hours*60*utilizationrate_hybrid)","v":{"v":6.228209005724556,"d":"€ 6.23"}},{"$f":"L10/(Available_OR_hours*60*utilizationrate_hybrid)","v":{"v":9.815011747815342,"d":"€ 9.82"}}]
[]
[{"$nulls":4},"3. Personnel"]
[{"$nulls":5},"Per minute",{"$f":"cTotal_personnel_conventional/60","v":{"v":5.475509725016766,"d":"€ 5.48"}},{"$f":"min_hourpersonnel_conventional/60","v":{"v":5.395818913480885,"d":"€ 5.40"}},{"$f":"max_hourpersonnel_conventional/60","v":{"v":5.555200536552649,"d":"€ 5.56"}},{"$f":"cTotal_personnel_hybrid/60","v":{"v":6.099676391683433,"d":"€ 6.10"}},{"$f":"min_hourpersonnel_hybrid/60","v":{"v":6.009818913480886,"d":"€ 6.01"}},{"$f":"max_hourpersonnel_hybrid/60","v":{"v":6.189533869885983,"d":"€ 6.19"}}]
[null,"Cost parameters"]
[{"$nulls":4},"4. Overhead"]
[{"$nulls":5},"4.1 overhead construction (annual)",{"$f":"cAnnualConstructionConventional*Overhead","v":{"v":27235.655280256815,"d":"€ 27,236"}},{"$f":"min_cAnnual_construction_conventional*Overhead","v":{"v":17913.547530802676,"d":"€ 17,914"}},{"$f":"max_cAnnual_construction_conventional*Overhead","v":{"v":36904.68290205971,"d":"€ 36,905"}},{"$f":"cAnnualConstructionHybrid*Overhead","v":{"v":47914.99453261999,"d":"€ 47,915"}},{"$f":"min_cAnnual_construction_hybrid*Overhead","v":{"v":23075.826006428073,"d":"€ 23,076"}},{"$f":"max_cAnnual_construction_hybrid*Overhead","v":{"v":68759.25130173229,"d":"€ 68,759"}}]
[{"$nulls":5},"4.1 overhead construction (per minute)",{"$f":"(cAnnual_overhead_construction_conventional/(Available_OR_hours*utilizationrate_conventional))/60","v":{"v":0.24318417872296164,"d":"€ 0.24"}},{"$f":"H17/(Available_OR_hours*60*utilizationrate_conventional)","v":{"v":0.1599481011000632,"d":"€ 0.16"}},{"$f":"(I17/(Available_OR_hours*60*utilizationrate_conventional))","v":{"v":0.3295178658350272,"d":"€ 0.33"}},{"$f":"(cAnnual_overhead_construction_hybrid/(Available_OR_hours*utilizationrate_hybrid))/60","v":{"v":0.9044879242895477,"d":"€ 0.90"}},{"$f":"(K17/(Available_OR_hours*utilizationrate_hybrid))/60","v":{"v":0.4356007168405623,"d":"€ 0.44"}},{"$f":"(L17/(Available_OR_hours*utilizationrate_hybrid))/60","v":{"v":1.2979634682681152,"d":"€ 1.30"}}]
[null,"Results",{"$nulls":3},"4.2 overhead personnel (per minute)",{"$f":"Overhead*cMinutePersonnelConventional","v":{"v":2.0806936955063713,"d":"€ 2.08"}},{"$f":"H14*Overhead","v":{"v":2.0504111871227364,"d":"€ 2.05"}},{"$f":"I14*Overhead","v":{"v":2.1109762038900066,"d":"€ 2.11"}},{"$f":"cMinutePersonnelHybrid*Overhead","v":{"v":2.3178770288397046,"d":"€ 2.32"}},{"$f":"K14*Overhead","v":{"v":2.2837311871227364,"d":"€ 2.28"}},{"$f":"L14*Overhead","v":{"v":2.3520228705566737,"d":"€ 2.35"}}]
[{"$nulls":5},"Total (per minute)",{"$f":"(G19+G18)","v":{"v":2.323877874229333,"d":"€ 2.32"}},{"$f":"H19+H18","v":{"v":2.2103592882228,"d":"€ 2.21"}},{"v":2.440494069725034,"d":"€ 2.44"},{"$f":"J19+J18","v":{"v":3.222364953129252,"d":"€ 3.22"}},{"v":2.719331903963299,"d":"€ 2.72"},{"v":3.649986338824789,"d":"€ 3.65"}]
[]
[{"$nulls":4},"Total annual",null,{"$f":"cAnnualConstructionConventional+cAnnualInventoryConventional+cAnnual_overhead_construction_conventional","v":{"v":212238.3889577018,"d":"€ 212,238.39"}},{"$f":"min_cAnnual_construction_conventional+H10+H17","v":{"v":128764.81099267278,"d":"€ 128,764.81"}},{"$f":"max_cAnnual_construction_conventional+I10+I17","v":{"v":287401.39366056875,"d":"€ 287,401.39"}},{"$f":"cAnnual_overhead_construction_hybrid+cAnnualInventoryHybrid+cAnnualConstructionHybrid","v":{"v":607248.3020780366,"d":"€ 607,248.30"}},{"$f":"min_cAnnual_construction_hybrid+K10+K17","v":{"v":413739.3120978176,"d":"€ 413,739.31"}},{"$f":"max_cAnnual_construction_hybrid+L10+L17","v":{"v":769652.148601414,"d":"€ 769,652.15"}}]
[null,"Figures"]
[{"$nulls":4},"Total per minute",null,{"$f":"G7+cMinuteInventoryConventional+cMinutePersonnelConventional+cOverheadTotalConventional","v":{"v":9.451256716691766,"d":"€ 9.45"}},{"$f":"H7+H11+H14+H20","v":{"v":8.595956974712276,"d":"€ 8.60"}},{"$f":"I7+I11+I14+I20","v":{"v":10.232352261537773,"d":"€ 10.23"}},{"$f":"J7+cMinuteInventoryHybrid+cMinutePersonnelHybrid+cOverheadTotalHybrid","v":{"v":19.880536180564846,"d":"€ 19.88"}},{"$f":"K7+K11+K14+K20","v":{"v":16.103677499064954,"d":"€ 16.10"}},{"$f":"L7+L11+L14+L20","v":{"v":23.070225294073786,"d":"€ 23.07"}}]

{"sheet":"Figures","index":4,"n_rows":55,"n_cols":18,"rows_kept":55}
[]
[{"$nulls":4},"Figures"]
[]
[]
[{"$nulls":4},"Annual fixed costs",{"$nulls":8},"Costs per minute"]
[]
[null,"Instructions"]
[]
[]
[]
[null,"Input parameters"]
[]
[]
[]
[null,"Cost parameters"]
[]
[]
[{"$nulls":4},"The inner circle shows the distribution of the costs for the conventional OR",{"$nulls":8},"The per minute costs per OR "]
[null,"Results",null,null,"where the outer circle shows the distribution of the costs for the hybrid OR"]
[]
[{"$nulls":4},"Costs of the conventional and hybrid OR by utilization rate of the OR",{"$nulls":8},"Costs of the hybrid OR by utilization rate C-arm"]
[]
[null,"Figures"]
{"$rows_empty":12}
[{"$nulls":4},"Assuming the utilization rate of the C-arm is 100%, meaning the fixed C-arm",{"$nulls":8},"Assuming the utilization rate of the hybrid OR is ",{"$nulls":3},{"$f":" utilizationrate_hybrid","v":{"v":0.4328,"d":"43%"}}]
[{"$nulls":4},"is used during every procedure performed in the hybrid OR.",{"$nulls":8},"You can change the utilization rate of the hybrid OR in the input tab."]
[]
[]
[]
[]
[{"$nulls":6},"Costs per minute","Costs per minute"]
[{"$nulls":5},"Utilization rate","conventional OR","hybrid OR"]
[{"$nulls":3},"Basecase values",null,{"$f":"utilizationrate_conventional","v":{"v":0.915,"d":"92%"}},null,{"$f":"Results!J24","v":{"v":19.880536180564846,"d":"€ 19.88"}}]
[{"$nulls":12},"utilization rate c-arm",{"$nulls":3},"utilization rate c-arm","costs per minute hybrid OR"]
[{"$nulls":3},"Scenario values",null,{"v":0.1,"d":"10%"},{"v":24.89594108046609,"d":"€ 24.90"},{"v":58.029342805983646,"d":"€ 58.03"},{"$nulls":4},100,{"$nulls":3},10,{"v":135.6010810253336,"d":"€ 135.60"}]
[{"$nulls":5},{"v":0.2,"d":"20%"},{"v":16.226072250494617,"d":"€ 16.23"},{"v":33.2234481132534,"d":"€ 33.22"},{"$nulls":8},20,{"v":78.72461829640014,"d":"€ 78.72"}]
[{"$nulls":5},{"v":0.3,"d":"30%"},{"v":13.336115973837458,"d":"€ 13.34"},{"v":24.954816549009976,"d":"€ 24.95"},{"$nulls":4},"default",{"$nulls":3},30,{"v":59.765797386755665,"d":"€ 59.77"}]
[{"$nulls":5},{"v":0.4,"d":"40%"},{"v":11.891137835508877,"d":"€ 11.89"},{"v":20.820500766888266,"d":"€ 20.82"},{"$nulls":4},100,{"$nulls":3},40,{"v":50.28638693193342,"d":"€ 50.29"}]
[{"$nulls":5},{"v":0.5,"d":"50%"},{"v":11.024150952511729,"d":"€ 11.02"},{"v":18.339911297615238,"d":"€ 18.34"},{"$nulls":8},50,{"v":44.59874065904008,"d":"€ 44.60"}]
[{"$nulls":5},{"v":0.6,"d":"60%"},{"v":10.446159697180297,"d":"€ 10.45"},{"v":16.686184984766555,"d":"€ 16.69"},{"$nulls":8},60,{"v":40.806976477111185,"d":"€ 40.81"}]
[{"$nulls":5},{"v":0.7,"d":"70%"},{"v":10.03330880051499,"d":"€ 10.03"},{"v":15.504951904160354,"d":"€ 15.50"},{"$nulls":8},70,{"v":38.09857349001912,"d":"€ 38.10"}]
[{"$nulls":5},{"v":0.8,"d":"80%"},{"v":9.723670628016007,"d":"€ 9.72"},{"v":14.619027093705702,"d":"€ 14.62"},{"$nulls":8},80,{"v":36.06727124970006,"d":"€ 36.07"}]
[{"$nulls":5},{"v":0.9,"d":"90%"},{"v":9.482840938294578,"d":"€ 9.48"},{"v":13.929974463352083,"d":"€ 13.93"},{"$nulls":8},90,{"v":34.487369507229694,"d":"€ 34.49"}]
[{"$nulls":5},{"v":1,"d":"100%"},{"v":9.290177186517433,"d":"€ 9.29"},{"v":13.378732359069188,"d":"€ 13.38"},{"$nulls":8},100,{"v":33.2234481132534,"d":"€ 33.22"}]