{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","1. Introduction","2. Inputs","3. Dashboard","Pivot table","Data for Pivot"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":1},"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1. Introduction","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,2,30,10],[31,2,32,8]]}
[]
[]
[]
[null,null,"WELCOME TO THE TOTAL COST OF OWNERSHIP COMPARISON TOOL"]
[null,null,"This tool should be used to capture and calculate the total cost of ownership (TCO) for the conventional ownership business model and then compare it to the Product as a Service (PaaS) business model, both from the consumer perspective.\n\nWHY THIS TOOL? \nCustomers underestimate the total cost of ownership. B2C segments, in particular, have been found to significantly underestimate the total cost of product ownership (e.g., costs associated with maintenance and use). Lack of customer insight about the true TCO is challenging as the perception of financial savings is the main factor that affects the willingness of customers to purchase a product. This may cause the price of the PaaS offering, which includes a large share of ownership costs traditionally borne by the customer, to seem unreasonably high. \n\nReduced continuous cost is a compelling argument for customers. Providers should therefore calculate and understand the true difference of TCO for PaaS compared to competing traditional product/s. Clear and fact-based communication about costs and savings helps customers understand the value proposition of PaaS.\n\nBEFORE USING THIS TOOL\nMake sure to do some research about the cost of ownership for the product you are going to compare. \n\nThis tool can be used by one or more people.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Users can input values in all cells filled with green colour."]

{"sheet":"2. Inputs","index":2,"n_rows":65,"n_cols":25,"rows_kept":65,"cut":false,"hidden":false,"merged":[[43,1,62,1],[64,1,65,1],[64,3,65,10],[2,1,3,1],[5,3,7,10],[5,1,7,1],[9,1,37,1],[39,1,41,1],[39,3,41,10]]}
[]
[]
[null,"STEP 1:",null,"General assumptions","Inputs"]
[null,null,null,"Comparison period (years)"]
[]
[null,"STEP 2:",null,"Estimate product ownership costs by filling in the Inputs cells by left-clicking the cell once, this will show valid input and input method. If a cost can not be associated with a cost category, manually fill in the blank rows in the blue Costs table. Use the optional Ownership settings to fine-tune the calculations and to make sure the comparison stays relevant."]
[]
[]
[]
[null,"PRODUCT OWNERSHIP",null,"Product ownership","Inputs"]
[null,null,null,"Acquisition costs (one-time)"]
[null,null,null,"Purchase costs"]
[null,null,null,"Maintenance costs (annual)"]
[null,null,null,"Operational costs (annual)"]
[null,null,null,"Error cost (annual)"]
[null,null,null,"End-of-life costs (one time)"]
[null,null,null,"Other costs (annual)"]
[]
[null,null,null,"Ownership settings (optional)","Inputs"]
[null,null,null,"Divide payment"]
[null,null,null,"Payment period"]
[null,null,null,"Interest rate (%)"]
[null,null,null,"Periodisation of product renewal"]
[null,null,null,"Maintenance scaling"]
[null,null,null,"Error cost scaling"]
[]
[null,null,null,"Costs",2023,{"$f":"E27+1","v":2024},{"$f":"F27+1","v":2025},{"$f":"G27+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,"Total Cost"]
[null,null,null,"Acquisition costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, ISNUMBER('2. Inputs'!$E11)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>1, ISNUMBER('2. Inputs'!$E11),OR($E$23=1)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>2, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>3, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=3)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>4, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=4)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>5, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=5)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>6, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=3, $E$23=6)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>7, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=7)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>8, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=4, $E$23=8)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>9, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=3, $E$23=9)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>10, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=5, $E$23=10)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>11, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=11)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>12, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=3, $E$23=4, $E$23=6, $E$23=12)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>13, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=13)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>14, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=7, $E$23=14)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>15, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=3, $E$23=5, $E$23=15)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>16, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=4, $E$23=8, $E$23=16)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>17, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=17)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>18, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=2, $E$23=3, $E$23=6, $E$23=18)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>19, ISNUMBER('2. Inputs'!$E11),OR($E$23=1, $E$23=19)), '2. Inputs'!$E11,\"\")","v":""},{"$f":"IF(SUM(E28:X28)=0,\"\",SUM(E28:X28))","v":""}]
[null,null,null,"Purchase costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, ISNUMBER('2. Inputs'!$E12), OR(E20=\"No\",E20=\"\",E20=\"Yes\") ), IF(AND(E20=\"Yes\",ISNUMBER(E21)), ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=2), AND(ISNUMBER(E23), ISNUMBER(F28)), AND(ISNUMBER('2. Inputs'!$E29),E21>=2))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=3), AND(ISNUMBER(E23), ISNUMBER(G28)), AND(ISNUMBER('2. Inputs'!$F29),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=4), AND(ISNUMBER(E23), ISNUMBER(H28)), AND(ISNUMBER('2. Inputs'!$G29),E21>=2, ISNUMBER(G28)))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=5), AND(ISNUMBER(E23), ISNUMBER(I28)), AND(ISNUMBER('2. Inputs'!$H29), E21>=2, ISNUMBER(H28)), AND(ISNUMBER(H28),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\",E21>=6), AND(ISNUMBER(E23), ISNUMBER(J28)), AND(ISNUMBER('2. Inputs'!$I29), E21>=2, ISNUMBER(I28)), AND(ISNUMBER(H28),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=7), AND(ISNUMBER(E23), ISNUMBER(K28)), AND(ISNUMBER('2. Inputs'!$J29), E21>=2, ISNUMBER(J28)), AND(ISNUMBER(I28),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=8), AND(ISNUMBER(E23), ISNUMBER(L28)), AND(ISNUMBER('2. Inputs'!$K29),E21>=2, ISNUMBER(K28)), AND(ISNUMBER(J28),E21>=3), AND(ISNUMBER(I28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=9), AND(ISNUMBER(E23),ISNUMBER(M28)), AND(ISNUMBER('2. Inputs'!$L29),E21>=2, ISNUMBER(L28)), AND(ISNUMBER(K28),E21>=3), AND(ISNUMBER(J28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=10), AND(ISNUMBER(E23),ISNUMBER(N28)), AND(ISNUMBER('2. Inputs'!$M29),E21>=2, ISNUMBER(M28)), AND(ISNUMBER(L28),E21>=3), AND(ISNUMBER(J28),E21>=5))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=11), AND(ISNUMBER(E23),ISNUMBER(O28)), AND(ISNUMBER('2. Inputs'!$N29), E21>=2, ISNUMBER(N28)), AND(ISNUMBER(M28),E21>=3), AND(ISNUMBER(L28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=12), AND(ISNUMBER(E23),ISNUMBER(P28)), AND(ISNUMBER('2. Inputs'!$O29), E21>=2, ISNUMBER(O28)), AND(ISNUMBER(N28),E21>=3), AND(ISNUMBER(M28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=13), AND(ISNUMBER(E23),ISNUMBER(Q28)), AND(ISNUMBER('2. Inputs'!$P29), E21>=2, ISNUMBER(P28)), AND(ISNUMBER(O28),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=14), AND(ISNUMBER(E23),ISNUMBER(R28)), AND(ISNUMBER('2. Inputs'!$Q29), E21>=2, ISNUMBER(Q28)), AND(ISNUMBER(P28),E21>=3), AND(ISNUMBER(O28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=15), AND(ISNUMBER(E23),ISNUMBER(S28)), AND(ISNUMBER('2. Inputs'!$R29),E21>=2, ISNUMBER(R28)), AND(ISNUMBER(Q28),E21>=3), AND(ISNUMBER(O28),E21>=5))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=16), AND(ISNUMBER(E23),ISNUMBER(T28)), AND(ISNUMBER('2. Inputs'!$S29), E21>=2, ISNUMBER(S28)), AND(ISNUMBER(R28),E21>=3), AND(ISNUMBER(Q28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=17), AND(ISNUMBER(E23),ISNUMBER(U28)), AND(ISNUMBER('2. Inputs'!$T29), E21>=2, ISNUMBER(T28)), AND(ISNUMBER(S28),E21>=3), AND(ISNUMBER(R28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=18), AND(ISNUMBER(E23),ISNUMBER(V28)), AND(ISNUMBER('2. Inputs'!$U29), E21>=2, ISNUMBER(U28)), AND(ISNUMBER(T28),E21>=3))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19,ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=19), AND(ISNUMBER(E23),ISNUMBER(W28)), AND(ISNUMBER('2. Inputs'!$V29), E21>=2, ISNUMBER(V28)), AND(ISNUMBER(U28),E21>=3), AND(ISNUMBER(T28),E21>=4))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, ISNUMBER('2. Inputs'!$E12), OR(AND(E20=\"Yes\", E21>=20), AND(ISNUMBER(E23),ISNUMBER(X28)), AND(ISNUMBER('2. Inputs'!$W29),E21>=2, ISNUMBER(W28)), AND(ISNUMBER(V28),E21>=3), AND(ISNUMBER(U28),E21>=4), AND(ISNUMBER(T28),E21>=5))), IF(E20=\"Yes\", ABS(PMT(E22,E21,'2. Inputs'!$E12,,0)), '2. Inputs'!$E12),\"\")","v":""},""]
[null,null,null,"Maintenance costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*0),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*1),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*2),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*3),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*4),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*5),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*6),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*7),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*8),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*9),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*10),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*11),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*13),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*14),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*15),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*16),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*17),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*18),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E13<>0), '2. Inputs'!$E13*EXP(E24/100*19),\"\")","v":""},""]
[null,null,null,"Operational costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E14<>0), '2. Inputs'!$E14,\"\")","v":""},""]
[null,null,null,"Error cost",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*0),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*1),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*2),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*3),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*4),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*5),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*6),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*7),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*8),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*9),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*10),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*11),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*13),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*14),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*15),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*16),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*17),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*18),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E15<>0), '2. Inputs'!$E15*EXP(E25/100*19),\"\")","v":""},""]
[null,null,null,"End-of-life costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=1, ISNUMBER($E$16), OR('2. Inputs'!$E$4:$E$4=1, E23=1)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, ISNUMBER($E$16), OR(ISNUMBER(G28), $E$4=2)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, ISNUMBER($E$16), OR(ISNUMBER(H28), $E$4=3)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, ISNUMBER($E$16), OR(ISNUMBER(I28), $E$4=4)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, ISNUMBER($E$16), OR(ISNUMBER(J28), $E$4=5)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, ISNUMBER($E$16), OR(ISNUMBER(K28), $E$4=6)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, ISNUMBER($E$16), OR(ISNUMBER(L28), $E$4=7)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, ISNUMBER($E$16), OR(ISNUMBER(M28), $E$4=8)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, ISNUMBER($E$16), OR(ISNUMBER(N28), $E$4=9)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, ISNUMBER($E$16), OR(ISNUMBER(O28), $E$4=10)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, ISNUMBER($E$16), OR(ISNUMBER(P28), $E$4=11)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, ISNUMBER($E$16), OR(ISNUMBER(Q28), $E$4=12)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, ISNUMBER($E$16), OR(ISNUMBER(R28), $E$4=13)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, ISNUMBER($E$16), OR(ISNUMBER(S28), $E$4=14)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, ISNUMBER($E$16), OR(ISNUMBER(T28), $E$4=15)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, ISNUMBER($E$16), OR(ISNUMBER(U28), $E$4=16)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, ISNUMBER($E$16), OR(ISNUMBER(V28), $E$4=17)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, ISNUMBER($E$16), OR(ISNUMBER(W28), $E$4=18)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, ISNUMBER($E$16), OR(ISNUMBER(X28), $E$4=19)), '2. Inputs'!$E16,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4=20, '2. Inputs'!$E16<>0), '2. Inputs'!$E16,\"\")","v":""},""]
[null,null,null,"Other costs",{"$f":"IF(AND(ISNUMBER('2. Inputs'!$E$4:$E$4), ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4,  ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11,  ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, ISNUMBER('2. Inputs'!$E17)), '2. Inputs'!$E17,\"\")","v":""},""]
[null,null,null,"blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Product Ownership Costs",{"$f":"IF(SUM(E28:E36)=0,\"\",SUM(E28:E36))","v":""},"","","","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(E37:X37)=0,\"\",SUM(E37:X37)/'2. Inputs'!$E$4:$E$4)","v":""}]
[null,null,null,"Accumulated Costs",{"$f":"IF(SUM(E28:E33)=0,\"\",E37)","v":""},{"$f":"IF(SUM(F28:F33)=0,\"\",'2. Inputs'!$E38+F37)","v":""},{"$f":"IF(SUM(G28:G33)=0,\"\",'2. Inputs'!$F38+G37)","v":""},{"$f":"IF(SUM(H28:H33)=0,\"\",'2. Inputs'!$G38+H37)","v":""},{"$f":"IF(SUM(I28:I37)=0,\"\",'2. Inputs'!$H38+I37)","v":""},{"$f":"IF(SUM(J29:J37)=0,\"\",'2. Inputs'!$I38+J37)","v":""},{"$f":"IF(SUM(K29:K37)=0,\"\",'2. Inputs'!$J38+K37)","v":""},{"$f":"IF(SUM(L29:L37)=0,\"\",'2. Inputs'!$K38+L37)","v":""},{"$f":"IF(SUM(M29:M37)=0,\"\",'2. Inputs'!$L38+M37)","v":""},{"$f":"IF(SUM(N29:N37)=0,\"\",'2. Inputs'!$M38+N37)","v":""},{"$f":"IF(SUM(O29:O37)=0,\"\",'2. Inputs'!$N38+O37)","v":""},{"$f":"IF(SUM(P29:P37)=0,\"\",'2. Inputs'!$O38+P37)","v":""},{"$f":"IF(SUM(Q29:Q37)=0,\"\",'2. Inputs'!$P38+Q37)","v":""},{"$f":"IF(SUM(R29:R37)=0,\"\",'2. Inputs'!$Q38+R37)","v":""},{"$f":"IF(SUM(S29:S37)=0,\"\",'2. Inputs'!$R38+S37)","v":""},{"$f":"IF(SUM(T29:T37)=0,\"\",'2. Inputs'!$S38+T37)","v":""},{"$f":"IF(SUM(U29:U37)=0,\"\",'2. Inputs'!$T38+U37)","v":""},{"$f":"IF(SUM(V29:V37)=0,\"\",'2. Inputs'!$U38+V37)","v":""},{"$f":"IF(SUM(W29:W37)=0,\"\",'2. Inputs'!$V38+W37)","v":""},{"$f":"IF(SUM(X29:X37)=0,\"\",'2. Inputs'!$W38+X37)","v":""},{"$f":"IF(SUM(E37:X37)=0,\"\",SUM(E37:X37))","v":""}]
[]
[null,"STEP 3:",null,"Estimate the PaaS offering costs and compare them to product ownership by filling in the Inputs cells in the table below using the specified entry method. If there are any Maintenance costs for the customers, they will have to be filled in manually. Use the optional PaaS settings to fine-tune the calculations and to make sure the comparison stays relevant."]
[]
[]
[]
[null,"PAAS",null,"Product-as-a-Service","Inputs"]
[null,null,null,"Acquisition costs (one time)"]
[null,null,null,"Subscription/Use cost (annual)"]
[null,null,null,"Maintenance costs (annual)"]
[null,null,null,"Operational costs (annual)"]
[null,null,null,"Other costs and fees (annual)"]
[]
[null,null,null,"PaaS settings (optional)","Inputs"]
[null,null,null,"Subscription cost scaling"]
[]
[null,null,null,"Costs",{"$f":"E27","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,"Total Cost"]
[null,null,null,"Acquisition costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E45<>0), '2. Inputs'!$E45,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E55:X55)=0,\"\",SUM(E55:X55))","v":""}]
[null,null,null,"Subscription/Use costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*0),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*1),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*2),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*3),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*4),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*5),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*6),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*7),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*8),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*9),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*10),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*11),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*12),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*13),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*14),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*15),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*16),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*17),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*18),\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E46<>0), '2. Inputs'!$E46*EXP(E52/100*19),\"\")","v":""},{"$f":"IF(SUM(E56:X56)=0,\"\",SUM(E56:X56))","v":""}]
[null,null,null,"Maintenance costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E57:X57)=0,\"\",SUM(E57:X57))","v":""}]
[null,null,null,"Operational costs",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>0, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E48<>0), '2. Inputs'!$E48,\"\")","v":""},{"$f":"IF(SUM(E58:X58)=0,\"\",SUM(E58:X58))","v":""}]
[null,null,null,"Other costs and fees",{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=1, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=2, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=3, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=4, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=5, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=6, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=7, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=8, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=9, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=10, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=11, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=12, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=13, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=14, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=15, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=16, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=17, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=18, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=19, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},{"$f":"IF(AND('2. Inputs'!$E$4:$E$4>=20, '2. Inputs'!$E49<>0), '2. Inputs'!$E49,\"\")","v":""},""]
[null,null,null,"blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"PaaS Costs",{"$f":"IF(SUM(E55:E61)=0,\"\",SUM(E55:E61))","v":""},{"$f":"IF(SUM(F55:F61)=0,\"\",SUM(F55:F61))","v":""},{"$f":"IF(SUM(G55:G61)=0,\"\",SUM(G55:G61))","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(E62:X62)=0,\"\",SUM(E62:X62)/'2. Inputs'!$E$4:$E$4)","v":""}]
[null,null,null,"Accumulated Costs",{"$f":"IF(SUM(E55:E61)=0,\"\",E62)","v":""},{"$f":"IF(SUM(F55:F61)=0,\"\",F62+'2. Inputs'!$E63)","v":""},{"$f":"IF(SUM(G55:G61)=0,\"\",G62+'2. Inputs'!$F63)","v":""},{"$f":"IF(SUM(H55:H61)=0,\"\",H62+'2. Inputs'!$G63)","v":""},{"$f":"IF(SUM(I55:I61)=0,\"\",I62+'2. Inputs'!$H63)","v":""},{"$f":"IF(SUM(J55:J61)=0,\"\",J62+'2. Inputs'!$I63)","v":""},{"$f":"IF(SUM(K55:K61)=0,\"\",K62+'2. Inputs'!$J63)","v":""},{"$f":"IF(SUM(L55:L61)=0,\"\",L62+'2. Inputs'!$K63)","v":""},{"$f":"IF(SUM(M55:M61)=0,\"\",M62+'2. Inputs'!$L63)","v":""},{"$f":"IF(SUM(N55:N61)=0,\"\",N62+'2. Inputs'!$M63)","v":""},{"$f":"IF(SUM(O55:O61)=0,\"\",O62+'2. Inputs'!$N63)","v":""},{"$f":"IF(SUM(P55:P61)=0,\"\",P62+'2. Inputs'!$O63)","v":""},{"$f":"IF(SUM(Q55:Q61)=0,\"\",Q62+'2. Inputs'!$P63)","v":""},{"$f":"IF(SUM(R55:R61)=0,\"\",R62+'2. Inputs'!$Q63)","v":""},{"$f":"IF(SUM(S55:S61)=0,\"\",S62+'2. Inputs'!$R63)","v":""},{"$f":"IF(SUM(T55:T61)=0,\"\",T62+'2. Inputs'!$S63)","v":""},{"$f":"IF(SUM(U55:U61)=0,\"\",U62+'2. Inputs'!$T63)","v":""},{"$f":"IF(SUM(V55:V61)=0,\"\",V62+'2. Inputs'!$U63)","v":""},{"$f":"IF(SUM(W55:W61)=0,\"\",W62+'2. Inputs'!$V63)","v":""},{"$f":"IF(SUM(X55:X61)=0,\"\",X62+'2. Inputs'!$W63)","v":""},{"$f":"IF(SUM(E62:X62)=0,\"\",SUM(E62:X62))","v":""}]
[]
[null,"STEP 4:",null,"Compare Product ownership and PaaS costs on the 3. Dashboard sheet, use the slicer to select the correct period. Press the \"Refresh all tables\" button below the chart to refresh all tables and charts."]

{"sheet":"3. Dashboard","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Pivot table","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Radetiketter","Product Ownership Costs","Product Ownership Accumulated Costs","PaaS Accumulated Costs ","PaaS Costs "]
[null,2023,0,0,0,0]
[null,2024,0,0,0,0]
[null,2025,0,0,0,0]
[null,2026,0,0,0,0]
[null,2027,0,0,0,0]
[null,2028,0,0,0,0]
[null,2029,0,0,0,0]
[null,2030,0,0,0,0]
[null,2031,0,0,0,0]
[null,2032,0,0,0,0]
[null,2033,0,0,0,0]
[null,2034,0,0,0,0]
[null,2035,0,0,0,0]
[null,2036,0,0,0,0]
[null,2037,0,0,0,0]
[null,2038,0,0,0,0]
[null,2039,0,0,0,0]
[null,2040,0,0,0,0]
[null,2041,0,0,0,0]
[null,2042,0,0,0,0]
[null,"Totalsumma",0,0,0,0]

{"sheet":"Data for Pivot","index":5,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Year","Ownership Annual Costs","Ownership Accumulated Costs","PaaS Annual Costs","PaaS Accumulated Costs"]
[{"$f":"'2. Inputs'!E$27","v":2023},{"$f":"'2. Inputs'!E37","v":""},{"$f":"'2. Inputs'!E38","v":""},{"$f":"'2. Inputs'!E62","v":""},{"$f":"'2. Inputs'!E63","v":""}]
[{"$f":"'2. Inputs'!F$27","v":2024},{"$f":"'2. Inputs'!F37","v":""},{"$f":"'2. Inputs'!F38","v":""},{"$f":"'2. Inputs'!F62","v":""},{"$f":"'2. Inputs'!F63","v":""}]
[{"$f":"'2. Inputs'!G$27","v":2025},{"$f":"'2. Inputs'!G37","v":""},{"$f":"'2. Inputs'!G38","v":""},{"$f":"'2. Inputs'!G62","v":""},{"$f":"'2. Inputs'!G63","v":""}]
[{"$f":"'2. Inputs'!H$27","v":2026},{"$f":"'2. Inputs'!H37","v":""},{"$f":"'2. Inputs'!H38","v":""},{"$f":"'2. Inputs'!H62","v":""},{"$f":"'2. Inputs'!H63","v":""}]
[{"$f":"'2. Inputs'!I$27","v":2027},{"$f":"'2. Inputs'!I37","v":""},{"$f":"'2. Inputs'!I38","v":""},{"$f":"'2. Inputs'!I62","v":""},{"$f":"'2. Inputs'!I63","v":""}]
[{"$f":"'2. Inputs'!J$27","v":2028},{"$f":"'2. Inputs'!J37","v":""},{"$f":"'2. Inputs'!J38","v":""},{"$f":"'2. Inputs'!J62","v":""},{"$f":"'2. Inputs'!J63","v":""}]
[{"$f":"'2. Inputs'!K$27","v":2029},{"$f":"'2. Inputs'!K37","v":""},{"$f":"'2. Inputs'!K38","v":""},{"$f":"'2. Inputs'!K62","v":""},{"$f":"'2. Inputs'!K63","v":""}]
[{"$f":"'2. Inputs'!L$27","v":2030},{"$f":"'2. Inputs'!L37","v":""},{"$f":"'2. Inputs'!L38","v":""},{"$f":"'2. Inputs'!L62","v":""},{"$f":"'2. Inputs'!L63","v":""}]
[{"$f":"'2. Inputs'!M$27","v":2031},{"$f":"'2. Inputs'!M37","v":""},{"$f":"'2. Inputs'!M38","v":""},{"$f":"'2. Inputs'!M62","v":""},{"$f":"'2. Inputs'!M63","v":""}]
[{"$f":"'2. Inputs'!N$27","v":2032},{"$f":"'2. Inputs'!N37","v":""},{"$f":"'2. Inputs'!N38","v":""},{"$f":"'2. Inputs'!N62","v":""},{"$f":"'2. Inputs'!N63","v":""}]
[{"$f":"'2. Inputs'!O$27","v":2033},{"$f":"'2. Inputs'!O37","v":""},{"$f":"'2. Inputs'!O38","v":""},{"$f":"'2. Inputs'!O62","v":""},{"$f":"'2. Inputs'!O63","v":""}]
[{"$f":"'2. Inputs'!P$27","v":2034},{"$f":"'2. Inputs'!P37","v":""},{"$f":"'2. Inputs'!P38","v":""},{"$f":"'2. Inputs'!P62","v":""},{"$f":"'2. Inputs'!P63","v":""}]
[{"$f":"'2. Inputs'!Q$27","v":2035},{"$f":"'2. Inputs'!Q37","v":""},{"$f":"'2. Inputs'!Q38","v":""},{"$f":"'2. Inputs'!Q62","v":""},{"$f":"'2. Inputs'!Q63","v":""}]
[{"$f":"'2. Inputs'!R$27","v":2036},{"$f":"'2. Inputs'!R37","v":""},{"$f":"'2. Inputs'!R38","v":""},{"$f":"'2. Inputs'!R62","v":""},{"$f":"'2. Inputs'!R63","v":""}]
[{"$f":"'2. Inputs'!S$27","v":2037},{"$f":"'2. Inputs'!S37","v":""},{"$f":"'2. Inputs'!S38","v":""},{"$f":"'2. Inputs'!S62","v":""},{"$f":"'2. Inputs'!S63","v":""}]
[{"$f":"'2. Inputs'!T$27","v":2038},{"$f":"'2. Inputs'!T37","v":""},{"$f":"'2. Inputs'!T38","v":""},{"$f":"'2. Inputs'!T62","v":""},{"$f":"'2. Inputs'!T63","v":""}]
[{"$f":"'2. Inputs'!U$27","v":2039},{"$f":"'2. Inputs'!U37","v":""},{"$f":"'2. Inputs'!U38","v":""},{"$f":"'2. Inputs'!U62","v":""},{"$f":"'2. Inputs'!U63","v":""}]
[{"$f":"'2. Inputs'!V$27","v":2040},{"$f":"'2. Inputs'!V37","v":""},{"$f":"'2. Inputs'!V38","v":""},{"$f":"'2. Inputs'!V62","v":""},{"$f":"'2. Inputs'!V63","v":""}]
[{"$f":"'2. Inputs'!W$27","v":2041},{"$f":"'2. Inputs'!W37","v":""},{"$f":"'2. Inputs'!W38","v":""},{"$f":"'2. Inputs'!W62","v":""},{"$f":"'2. Inputs'!W63","v":""}]
[{"$f":"'2. Inputs'!X$27","v":2042},{"$f":"'2. Inputs'!X37","v":""},{"$f":"'2. Inputs'!X38","v":""},{"$f":"'2. Inputs'!X62","v":""},{"$f":"'2. Inputs'!X63","v":""}]