{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Template Instructions","Option 1","Option 2","Option 3","Executive Dashboard | Lifetime","Executive Dashboard | Projected","Executive Dashboard | Current","Formulas","Reference Formulas"],"not_rendered":{"charts":15,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Template Instructions","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,2,21,3],[21,5,21,6],[22,2,22,3],[24,2,24,6],[27,0,28,19],[13,2,13,3],[14,2,14,3],[18,5,18,6],[19,5,19,6],[20,2,20,3],[20,5,20,6],[15,2,15,3],[15,5,15,6],[16,2,16,3],[16,5,16,6],[17,2,17,3],[17,5,17,6],[19,2,19,3],[16,11,16,16],[17,11,17,16],[2,2,2,17],[4,2,4,17],[8,2,8,6],[8,11,8,17],[9,12,9,16],[10,5,10,6],[10,12,10,16],[13,5,13,6],[14,5,14,6],[10,2,10,3],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[9,10,9,11],[10,10,10,11],[11,10,11,11],[11,12,11,16],[13,11,14,16]]}
[]
[]
[null,null,"This Total Cost of Ownership (TCO) calculator is designed to help you understand, compare, and communicate the total cost (which includes both the direct and indirect costs) of up to three items. You might want to compare a new tool or solution to an existing one, compare multiple new technologies you are evaluating, or review and assess your various approaches to how you manage your IT environment. No matter what the scope of your assessment is, this calculator can help you look into the past and present, helping you compute and share future costs in a comprehensive, holistic way."]
[]
[null,null,"This calculator is best used within Microsoft Excel; the formulas and dashboards are most congruent with this platform. Should you decide to use alternative spreadsheet programs you may find certain graphs and charts do not render correctly."]
[]
[]
[]
[null,null,"To get started, fill in the cells below",null,null,null,null,null,null,null,null,"To use this calculator, follow these steps:"]
[null,null,null,null,null,null,null,null,null,null,1,null,"Go to the tab labeled OPTION 1: to begin your assessment of the first item."]
[null,null,"Organization Name",null,null,null,null,null,null,null,2,null,"List and categorize everything that may be related to the item you're evaluating, using the six categories as a guide to organize your inputs."]
[null,null,"Number of employees",null,null,null,null,null,null,null,3,null,"Fill out only the highlighted cells in each row. All other cells will auto populate or auto calculate."]
[null,null,"Number of locations \n(offices, storefronts, shared workspaces, etc)"]
[null,null,"Workplace environment\n(choose the best option from the dropdown)",null,null,null,null,null,null,null,null,"The information you add here will populate throughout the tool and influence certain calculations; you can change these figures at any time to see how they impact the final assessment. While we created three tabs so you can compare three different solutions, you can also use this calculator to assess the total cost of ownership of a single item. "]
[null,null,"Organization Growth Factor*",null,null,1]
[null,null,"US Inflation Rate\n(default value based on 10-year average)",null,null,2.1000000000000001E-2]
[null,null,"Option 1",null,null,null,null,null,null,null,null,"Use the buttons on this page to take you directly to the different tabs contained within the calculator."]
[null,null,"Option 2\n(if applicable)"]
[null,null,null,"Option 3\n(if applicable)"]
[null,null,"Assessment Timeframe\n(in years)"]
[null,null,"Goal of the Assessment\n(a brief description of what you are comparing or assessing, and why)"]
[null,null,"Your Name"]
[null,null,"Date(s) of Assessment",null,null,"Start Date","End Date"]
[]
[null,null,"*Growth factor is used to project organizational growth over the timeframe indicated above; if you aren't sure what this should be, use a value of 1 to represent slow to no growth. \n\nIf you wish to use a more complex calculation, see the Formulas tab for more information."]
[]
[]
["© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Option 1","index":1,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,8],[0,9,0,17],[158,2,159,18]]}
[{"$f":"'Template Instructions'!F17","v":0},{"$f":"'Reference Formulas'!Q6","v":0},"BE ADVISED\nInputs should be placed into shaded cells only; cells in white and hidden rows contain calculations and formulas. Tampering or adjusting these cells and rows can break functionality and usability throughout the calculator.",null,null,null,"For Past/YTD",null,null,"For Future Projections",null,null,null,null,null,null,null,null,"Lifetime"]
["Item Category","Item","Notes","Cost Per Unit","Quantity","Total Initial Cost","What is the Recurring Cost?","Years Owned / Recurred","YTD TCO","Is this a Future Recurring Cost?","Future Yearly Recurring Cost","Future Cost (Recurring)","Ad Hoc Additions","Year to Add","Future Cost (Ad Hoc)","EOL Cost","EOL Gain","Projected TCO","Item TCO"]
["Infrastructure Equipment",null,null,{"$f":"SUM($D4:$D28)","v":0},null,{"$f":"SUM(F$4:F$28)","v":0},null,null,{"$f":"SUM($I4:$I28)","v":0},null,null,{"$f":"SUM($L4:$L28)","v":0},null,null,{"$f":"SUM($O4:$O28)","v":0},null,null,{"$f":"SUM($R4:$R28)","v":0},{"$f":"SUM($S4:$S28)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D4:$D28*$E4:$E28,0)","v":0},null,null,{"$f":"ROUND(IF($G4:$G28>0,($G4:$G28*($H4:$H28-1)+$F4:$F28),$F4:$F28),0)","v":0},null,null,{"$f":"ROUND(IF($J4:$J28=\"no\",0,(($K4:$K28*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M4:$M28*$D4:$D28,0)*(1+'Template Instructions'!$F$16)^($N4:$N28)","v":0},null,null,{"$f":"ROUND($L4:$L28+$O4:$O28+$Q4:$Q28-$P4:$P28,0)","v":0},{"$f":"ROUND($I4:$I28+$R4:$R28,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Data Center / Hosting Costs",null,null,{"$f":"SUM($D30:$D53)","v":0},null,{"$f":"SUM($F30:$F54)","v":0},null,null,{"$f":"SUM($I30:$I54)","v":0},null,null,{"$f":"SUM($L30:$L54)","v":0},null,null,{"$f":"SUM($O30:$O54)","v":0},null,null,{"$f":"SUM($R30:$R54)","v":0},{"$f":"SUM($S30:$S54)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D30:$D54*$E30:$E54,0)","v":0},null,null,{"$f":"ROUND(IF($G30:$G54>0,($G30:$G54*($H30:$H54-1)+$F30:$F54), $F30:$F54),0)","v":0},null,null,{"$f":"ROUND(IF($J30:$J54=\"no\",0,(($K30:$K54*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M30:$M54*$D30:$D54,0)*(1+'Template Instructions'!$F$16)^($N30:$N54)","v":0},null,null,{"$f":"ROUND($L30:$L54+$O30:$O54+$Q30:$Q54-$P30:$P54,0)","v":0},{"$f":"ROUND($I30:$I54+$R30:$R54,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Software and Applications",null,null,{"$f":"SUM($D56:$D80)","v":0},null,{"$f":"SUM($F56:$F80)","v":0},null,null,{"$f":"SUM($I56:$I80)","v":0},null,null,{"$f":"SUM($L56:$L80)","v":0},null,null,{"$f":"SUM($O56:$O80)","v":0},null,null,{"$f":"SUM($R56:$R80)","v":0},{"$f":"SUM($S56:$S80)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D56:$D80*$E56:$E80,0)","v":0},null,null,{"$f":"ROUND(IF($G56:$G80>0,($G56:$G80*($H56:$H80-1)+$F56:$F80),$F56:$F80),0)","v":0},"Yes",null,{"$f":"ROUND(IF($J56:$J80=\"no\",0,(($K56:$K80*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},0,0,{"$f":"ROUND($M56:$M80*$D56:$D80,0)*(1+'Template Instructions'!$F$16)^($N56:$N80)","v":0},null,null,{"$f":"ROUND($L56:$L80 +$O56:$O80+$Q56:$Q80-$P56:$P80,0)","v":0},{"$f":"ROUND($I56:$I80+$R56:$R80,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Employee Devices and Hardware",null,null,{"$f":"SUM($D82:$D106)","v":0},null,{"$f":"SUM($F82:$F106)","v":0},null,null,{"$f":"SUM($I82:$I106)","v":0},null,null,{"$f":"SUM($L82:$L106)","v":0},null,null,{"$f":"SUM($O82:$O106)","v":0},null,null,{"$f":"SUM(R$82:R$106)","v":0},{"$f":"SUM($S82:$S106)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D$82:$D$106*$E$82:$E$106,0)","v":0},0,null,{"$f":"ROUND(IF($G$82:$G$106>0,($G$82:$G$106*($H$82:$H$106-1)+$F$82:$F$106), $F$82:$F$106),0)","v":0},"No",null,{"$f":"ROUND(IF($J$82:$J$106=\"no\",0,(($K$82:$K$106*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M$82:$M$106*$D$82:$D$106,0)*(1+'Template Instructions'!$F$16)^(N82:N106)","v":0},null,null,{"$f":"ROUND($L$82:$L$106 +$O$82:$O$106+$Q$82:$Q$106-$P$82:$P$106,0)","v":0},{"$f":"ROUND(I82:I106+R82:R106,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Personnel and Support",null,null,{"$f":"SUM($D108:$D132)","v":0},null,{"$f":"SUM($F108:$F132)","v":0},null,null,{"$f":"SUM($I108:$I132)","v":0},null,null,{"$f":"SUM($L108:$L132)","v":0},null,null,{"$f":"SUM($O109:$O132)","v":0},null,null,{"$f":"SUM($R108:$R132)","v":0},{"$f":"SUM(S$108:S$132)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D108:$D132*$E108:$E132,0)","v":0},null,null,{"$f":"ROUND(IF($G108:$G132>0,($G108:$G132*($H108:$H132-1)+$F108:$F132),$F108:$F132),0)","v":0},null,null,{"$f":"ROUND(IF(J$108:J$132=\"no\",0,((K$108:K$132*'Template Instructions'!F20)*(1+'Template Instructions'!F16)^'Template Instructions'!F20*'Template Instructions'!F15)),0)","v":0},null,null,{"$f":"ROUND($M108:$M132*$D108:$D132,0)*(1+'Template Instructions'!$F$16)^($N108:$N132)","v":0},null,null,{"$f":"ROUND($L108:$L132 +$O108:$O132+$Q108:$Q132-$P108:$P132,0)","v":0},{"$f":"ROUND($I108:$I132+$R108:$R132,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Rollout",null,null,{"$f":"SUM($D134:$D158)","v":0},null,{"$f":"SUM($F134:$F158)","v":0},null,null,{"$f":"SUM($I134:$I158)","v":0},null,null,{"$f":"SUM($L134:$L158)","v":0},null,null,{"$f":"SUM($O134:$O158)","v":0},null,null,{"$f":"SUM($R134:$R158)","v":0},{"$f":"SUM($S134:$S158)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D134:$D158*$E134:$E158,0)","v":0},null,null,{"$f":"ROUND(IF($G134:$G158>0,($G134:$G158*($H134:$H158-1)+$F134:$F158),$F134:$F158),0)","v":0},null,null,{"$f":"ROUND(IF($J134:$J158=\"no\",0,(($K134:$K158*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M134:$M158*$D134:$D158,0)*(1+'Template Instructions'!$F$16)^($N134:$N158)","v":0},null,null,{"$f":"ROUND($L134:$L158+$O134:$O158+$Q134:$Q158-$P134:$P158,0)","v":0},{"$f":"ROUND($I134:$I158+$R134:$R158,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,"© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Option 2","index":2,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,8],[0,9,0,17],[158,2,159,18]]}
[{"$f":"'Template Instructions'!F18","v":0},{"$f":"'Reference Formulas'!Q7","v":0},"BE ADVISED\nInputs should be placed into shaded cells only; cells in white and hidden rows contain calculations and formulas. Tampering or adjusting these cells and rows can break functionality and usability throughout the calculator.",null,null,null,"For Past/YTD",null,null,"For Future Projections",null,null,null,null,null,null,null,null,"Lifetime"]
["Item Category","Item","Notes","Cost Per Unit","Quantity","Total Initial Cost","What is the Recurring Cost?","Years Owned / Recurred","YTD TCO","Is this a Future Recurring Cost?","Future Yearly Recurring Cost","Future Cost (Recurring)","Ad Hoc Additions","Year to Add","Future Cost (Ad Hoc)","EOL Cost","EOL Gain","Projected TCO","Item TCO"]
["Infrastructure Equipment",null,null,{"$f":"SUM($D4:$D28)","v":0},null,{"$f":"SUM(F$4:F$28)","v":0},null,null,{"$f":"SUM($I4:$I28)","v":0},null,null,{"$f":"SUM($L4:$L28)","v":0},null,null,{"$f":"SUM($O4:$O28)","v":0},null,null,{"$f":"SUM($R4:$R28)","v":0},{"$f":"SUM($S4:$S28)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D4:$D28*$E4:$E28,0)","v":0},null,null,{"$f":"ROUND(IF($G4:$G28>0,($G4:$G28*($H4:$H28-1)+$F4:$F28),$F4:$F28),0)","v":0},null,null,{"$f":"ROUND(IF($J4:$J28=\"no\",0,(($K4:$K28*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M4:$M28*$D4:$D28,0)*(1+'Template Instructions'!$F$16)^($N4:$N28)","v":0},null,null,{"$f":"ROUND($L4:$L28+$O4:$O28+$Q4:$Q28-$P4:$P28,0)","v":0},{"$f":"ROUND($I4:$I28+$R4:$R28,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Data Center / Hosting Costs",null,null,{"$f":"SUM($D30:$D54)","v":0},null,{"$f":"SUM($F30:$F41)","v":0},null,null,{"$f":"SUM($I30:$I41)","v":0},null,null,{"$f":"SUM($L30:$L41)","v":0},null,null,{"$f":"SUM($O30:$O41)","v":0},null,null,{"$f":"SUM($R30:$R41)","v":0},{"$f":"SUM($S30:$S41)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D30:$D54*$E30:$E54,0)","v":0},null,null,{"$f":"ROUND(IF($G30:$G54>0,($G30:$G54*($H30:$H54-1)+$F30:$F54), $F30:$F54),0)","v":0},null,null,{"$f":"ROUND(IF($J30:$J54=\"no\",0,(($K30:$K54*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M30:$M54*$D30:$D54,0)*(1+'Template Instructions'!$F$16)^($N30:$N54)","v":0},null,null,{"$f":"ROUND($L30:$L54+$O30:$O54+$Q30:$Q54-$P30:$P54,0)","v":0},{"$f":"ROUND($I30:$I54+$R30:$R54,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Software and Applications",null,null,{"$f":"SUM($D56:$D80)","v":0},null,{"$f":"SUM($F56:$F67)","v":0},null,null,{"$f":"SUM($I56:$I67)","v":0},null,null,{"$f":"SUM($L56:$L67)","v":0},null,null,{"$f":"SUM($O56:$O67)","v":0},null,null,{"$f":"SUM($R56:$R67)","v":0},{"$f":"SUM($S56:$S67)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D56:$D80*$E56:$E80,0)","v":0},null,null,{"$f":"ROUND(IF($G56:$G80>0,($G56:$G80*($H56:$H80-1)+$F56:$F80),$F56:$F80),0)","v":0},"Yes",null,{"$f":"ROUND(IF($J56:$J80=\"no\",0,(($K56:$K80*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},0,0,{"$f":"ROUND($M56:$M80*$D56:$D80,0)*(1+'Template Instructions'!$F$16)^($N56:$N80)","v":0},null,null,{"$f":"ROUND($L56:$L80 +$O56:$O80+$Q56:$Q80-$P56:$P80,0)","v":0},{"$f":"ROUND($I56:$I80+$R56:$R80,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Employee Devices and Hardware",null,null,{"$f":"SUM($D82:$D106)","v":0},null,{"$f":"SUM($F82:$F106)","v":0},null,null,{"$f":"SUM($I82:$I106)","v":0},null,null,{"$f":"SUM($L82:$L106)","v":0},null,null,{"$f":"SUM($O82:$O106)","v":0},null,null,{"$f":"SUM(R$82:R$106)","v":0},{"$f":"SUM($S82:$S106)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D$82:$D$106*$E$82:$E$106,0)","v":0},0,null,{"$f":"ROUND(IF($G$82:$G$106>0,($G$82:$G$106*($H$82:$H$106-1)+$F$82:$F$106), $F$82:$F$106),0)","v":0},"No",null,{"$f":"ROUND(IF($J$82:$J$106=\"no\",0,(($K$82:$K$106*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M$82:$M$106*$D$82:$D$106,0)*(1+'Template Instructions'!$F$16)^(N82:N106)","v":0},null,null,{"$f":"ROUND($L$82:$L$106 +$O$82:$O$106+$Q$82:$Q$106-$P$82:$P$106,0)","v":0},{"$f":"ROUND(I82:I106+R82:R106,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Personnel and Support",null,null,{"$f":"SUM($D108:$D132)","v":0},null,{"$f":"SUM($F108:$F119)","v":0},null,null,{"$f":"SUM($I108:$I119)","v":0},null,null,{"$f":"SUM($L108:$L119)","v":0},null,null,{"$f":"SUM($O108:$O119)","v":0},null,null,{"$f":"SUM($R108:$R119)","v":0},{"$f":"SUM(S$108:S$119)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D108:$D132*$E108:$E132,0)","v":0},null,null,{"$f":"ROUND(IF($G108:$G132>0,($G108:$G132*($H108:$H132-1)+$F108:$F132),$F108:$F132),0)","v":0},null,null,{"$f":"ROUND(IF(J$108:J$132=\"no\",0,((K$108:K$132*'Template Instructions'!F20)*(1+'Template Instructions'!F16)^'Template Instructions'!F20*'Template Instructions'!F15)),0)","v":0},null,null,{"$f":"ROUND($M108:$M132*$D108:$D132,0)*(1+'Template Instructions'!$F$16)^($N108:$N132)","v":0},null,null,{"$f":"ROUND($L108:$L132 +$O108:$O132+$Q108:$Q132-$P108:$P132,0)","v":0},{"$f":"ROUND($I108:$I132+$R108:$R132,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Rollout",null,null,{"$f":"SUM($D134:$D158)","v":0},null,{"$f":"SUM($F134:$F146)","v":0},null,null,{"$f":"SUM($I134:$I146)","v":0},null,null,{"$f":"SUM($L134:$L146)","v":0},null,null,{"$f":"SUM($O134:$O146)","v":0},null,null,{"$f":"SUM($R134:$R146)","v":0},{"$f":"SUM($S134:$S146)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D134:$D158*$E134:$E158,0)","v":0},null,null,{"$f":"ROUND(IF($G134:$G158>0,($G134:$G158*($H134:$H158-1)+$F134:$F158),$F134:$F158),0)","v":0},null,null,{"$f":"ROUND(IF($J134:$J158=\"no\",0,(($K134:$K158*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M134:$M158*$D134:$D158,0)*(1+'Template Instructions'!$F$16)^($N134:$N158)","v":0},null,null,{"$f":"ROUND($L134:$L158+$O134:$O158+$Q134:$Q158-$P134:$P158,0)","v":0},{"$f":"ROUND($I134:$I158+$R134:$R158,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,"© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Option 3","index":3,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,8],[0,9,0,17],[158,2,159,18]]}
[{"$f":"'Template Instructions'!F19","v":0},{"$f":"'Reference Formulas'!Q10","v":0},"BE ADVISED\nShaded cells are meant for your direct input; cells in white contain predetermined calculations and formulas. Tampering or adjusting cells in white can break functionality and usability throughout the calculator.",null,null,null,"For Past/YTD",null,null,"For Future Projections",null,null,null,null,null,null,null,null,"Lifetime"]
["Item Category","Item","Notes","Cost Per Unit","Quantity","Total Initial Cost","What is the Recurring Cost?","Years Owned / Recurred","YTD TCO","Is this a Future Recurring Cost?","Future Yearly Recurring Cost","Future Cost (Recurring)","Ad Hoc Additions","Year to Add","Future Cost \n(Ad Hoc)","EOL Cost","EOL Gain","Projected TCO","Item TCO"]
["Infrastructure Equipment",null,null,{"$f":"SUM($D4:$D28)","v":0},null,{"$f":"SUM(F$4:F$28)","v":0},null,null,{"$f":"SUM($I4:$I28)","v":0},null,null,{"$f":"SUM($L4:$L28)","v":0},null,null,{"$f":"SUM($O4:$O28)","v":0},null,null,{"$f":"SUM($R4:$R28)","v":0},{"$f":"SUM($S4:$S28)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D4:$D27*$E4:$E27,0)","v":0},null,null,{"$f":"ROUND(IF($G4:$G28>0,($G4:$G28*($H4:$H28-1)+$F4:$F28),$F4:$F28),0)","v":0},null,null,{"$f":"ROUND(IF($J4:$J28=\"no\",0,(($K4:$K28*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M4:$M28*$D4:$D28,0)*(1+'Template Instructions'!$F$16)^($N4:$N28)","v":0},null,null,{"$f":"ROUND($L4:$L28+$O4:$O28+$Q4:$Q28-$P4:$P28,0)","v":0},{"$f":"ROUND($I4:$I28+$R4:$R28,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Data Center / Hosting Costs",null,null,{"$f":"SUM($D30:$D54)","v":0},null,{"$f":"SUM($F30:$F54)","v":0},null,null,{"$f":"SUM($I30:$I54)","v":0},null,null,{"$f":"SUM($L30:$L54)","v":0},null,null,{"$f":"SUM($O30:$O54)","v":0},null,null,{"$f":"SUM($R30:$R54)","v":0},{"$f":"SUM($S30:$S54)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D30:$D54*$E30:$E54,0)","v":0},null,null,{"$f":"ROUND(IF($G30:$G54>0,($G30:$G54*($H30:$H54-1)+$F30:$F54), $F30:$F54),0)","v":0},null,null,{"$f":"ROUND(IF($J30:$J54=\"no\",0,(($K30:$K54*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M30:$M54*$D30:$D54,0)*(1+'Template Instructions'!$F$16)^($N30:$N54)","v":0},null,null,{"$f":"ROUND($L30:$L54 +$O30:$O54+$Q30:$Q54-$P30:$P54,0)","v":0},{"$f":"ROUND($I30:$I54+$R30:$R54,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Data Center / Hosting Costs",null,null,{"$f":"SUM($D56:$D80)","v":0},null,{"$f":"SUM($F56:$F80)","v":0},null,null,{"$f":"SUM($I56:$I80)","v":0},null,null,{"$f":"SUM($L56:$L80)","v":0},null,null,{"$f":"SUM($O56:$O80)","v":0},null,null,{"$f":"SUM($R56:$R80)","v":0},{"$f":"SUM($S56:$S80)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D56:$D80*$E56:$E80,0)","v":0},{"$f":"F56","v":0},null,{"$f":"ROUND(IF($G56:$G80>0,($G56:$G80*($H56:$H80-1)+$F56:$F80), $F56:$F80),0)","v":0},"Yes",null,{"$f":"ROUND(IF($J56:$J80=\"no\",0,(($K56:$K80*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},0,0,{"$f":"ROUND($M56:$M80*$D56:$D80,0)*(1+'Template Instructions'!$F$16)^($N56:$N80)","v":0},null,null,{"$f":"ROUND($L56:$L80 +$O56:$O80+$Q56:$Q80-$P56:$P80,0)","v":0},{"$f":"ROUND($I56:$I80+$R56:$R80,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Employee Devices and Hardware",null,null,{"$f":"SUM($D82:$D106)","v":0},null,{"$f":"SUM($F82:$F106)","v":0},null,null,{"$f":"SUM($I82:$I106)","v":0},null,null,{"$f":"SUM($L82:$L106)","v":0},null,null,{"$f":"SUM($O82:$O106)","v":0},null,null,{"$f":"SUM(R$82:R$106)","v":0},{"$f":"SUM($S82:$S106)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D$82:$D$106*$E$82:$E$106,0)","v":0},null,null,{"$f":"ROUND(IF($G$82:$G$106>0,($G$82:$G$106*($H$82:$H$106-1)+$F$82:$F$106), $F$82:$F$106),0)","v":0},null,null,{"$f":"ROUND(IF($J82:$J106=\"no\",0,(($K82:$K106*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M$82:$M$106*$D$82:$D$106,0)*(1+'Template Instructions'!$F$16)^(N82:N106)","v":0},null,null,{"$f":"ROUND($L$82:$L$106 +$O$82:$O$106+$Q$82:$Q$106-$P$82:$P$106,0)","v":0},{"$f":"ROUND(I82:I106+R82:R106,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Personnel and Support",null,null,{"$f":"SUM($D108:$D132)","v":0},null,{"$f":"SUM($F108:$F132)","v":0},null,null,{"$f":"SUM($I108:$I132)","v":0},null,null,{"$f":"SUM($L108:$L132)","v":0},null,null,{"$f":"SUM($O108:$O132)","v":0},null,null,{"$f":"SUM($R108:$R132)","v":0},{"$f":"SUM(S$108:S$132)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D108:$D132*$E108:$E132,0)","v":0},null,null,{"$f":"ROUND(IF($G108:$G132>0,($G108:$G132*($H108:$H132-1)+$F108:$F132),$F108:$F132),0)","v":0},null,null,{"$f":"ROUND(IF($J108:$J132=\"no\",0,(($K108:$K132*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M108:$M132*$D108:$D132,0)*(1+'Template Instructions'!$F$16)^($N108:$N132)","v":0},null,null,{"$f":"ROUND($L108:$L132 +$O108:$O132+$Q108:$Q132-$P108:$P132,0)","v":0},{"$f":"ROUND($I108:$I132+$R108:$R132,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["Rollout",null,null,{"$f":"SUM($D134:$D158)","v":0},null,{"$f":"SUM($F134:$F158)","v":0},null,null,{"$f":"SUM($I134:$I158)","v":0},null,null,{"$f":"SUM($L134:$L158)","v":0},null,null,{"$f":"SUM($O134:$O158)","v":0},null,null,{"$f":"SUM($R134:$R158)","v":0},{"$f":"SUM($S134:$S158)","v":0}]
[null,null,null,null,null,{"$f":"ROUND($D134:$D158*$E134:$E158,0)","v":0},null,null,{"$f":"ROUND(IF($G134:$G158>0,($G134:$G158*($H134:$H158-1)+$F134:$F158),$F134:$F158),0)","v":0},null,null,{"$f":"ROUND(IF($J134:$J158=\"no\",0,(($K134:$K158*'Template Instructions'!$F$20)*(1+'Template Instructions'!$F$16)^'Template Instructions'!$F$20*'Template Instructions'!$F$15)),0)","v":0},null,null,{"$f":"ROUND($M134:$M158*$D134:$D158,0)*(1+'Template Instructions'!$F$16)^($N134:$N158)","v":0},null,null,{"$f":"ROUND($L134:$L158 +$O134:$O158+$Q134:$Q158-$P134:$P158,0)","v":0},{"$f":"ROUND($I134:$I158+$R134:$R158,0)","v":0}]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,"© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Executive Dashboard | Lifetime","index":4,"n_rows":34,"n_cols":45,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,11,14,11],[19,11,26,11],[19,12,26,12],[19,13,26,13],[8,3,26,3],[8,4,26,4],[8,5,26,5],[8,12,14,12],[8,13,14,13],[18,11,18,13],[16,40,17,44],[18,24,18,26],[18,37,18,39],[8,25,14,25],[8,26,14,26],[8,37,14,37],[8,38,14,38],[8,39,14,39],[9,27,9,31],[9,40,9,44],[8,24,14,24],[7,24,7,26],[7,37,7,39],[9,14,9,18],[16,14,17,18],[16,27,17,31],[2,1,2,20],[3,1,3,20],[6,3,6,4],[7,3,7,5],[7,11,7,13],[20,40,20,44],[27,40,28,44],[28,14,29,18],[28,27,29,31],[33,0,34,47],[19,24,26,24],[19,25,26,25],[19,26,26,26],[19,37,25,37],[19,38,25,38],[19,39,25,39],[20,27,20,31],[20,14,20,18]]}
[null,"Total Cost of Ownership Analysis | Executive Summary"]
[]
[null,{"$f":"'Reference Formulas'!Q26","v":"Lifetime Total Cost of Ownership Comparison: 0 vs 0"}]
[null,"Lifetime TCO includes both YTD and future costs. It reflects all the past and future expenses associated with a given solution over a period of time."]
[]
[]
[]
[null,null,null,"Overall Total Cost of Ownership",null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A6","v":"Infrastructure Equipment"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A8","v":"Software and Applications"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$A$10","v":"Personnel and Support"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$6","v":"Servers"},{"$f":"'Reference Formulas'!$Z6","v":0},{"$f":"'Reference Formulas'!$AA6","v":0},{"$f":"'Reference Formulas'!$AB6","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$15","v":"IT Solutions"},{"$f":"'Reference Formulas'!$Z15","v":0},{"$f":"'Reference Formulas'!$AA15","v":0},{"$f":"'Reference Formulas'!$AB6","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$24","v":"Salaries"},{"$f":"'Reference Formulas'!$Z24","v":0},{"$f":"'Reference Formulas'!$AA24","v":0},{"$f":"'Reference Formulas'!$AB24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$7","v":"Networking Equipment"},{"$f":"'Reference Formulas'!$Z7","v":0},{"$f":"'Reference Formulas'!$AA7","v":0},{"$f":"'Reference Formulas'!$AB7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$16","v":"SaaS Solutions"},{"$f":"'Reference Formulas'!$Z16","v":0},{"$f":"'Reference Formulas'!$AA16","v":0},{"$f":"'Reference Formulas'!$AB7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$25","v":"Consulting Services"},{"$f":"'Reference Formulas'!$Z25","v":0},{"$f":"'Reference Formulas'!$AA25","v":0},{"$f":"'Reference Formulas'!$AB25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$8","v":"Software and Licensing"},{"$f":"'Reference Formulas'!$Z8","v":0},{"$f":"'Reference Formulas'!$AA8","v":0},{"$f":"'Reference Formulas'!$AB8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$17","v":"Business Software"},{"$f":"'Reference Formulas'!$Z17","v":0},{"$f":"'Reference Formulas'!$AA17","v":0},{"$f":"'Reference Formulas'!$AB8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$26","v":"Professional Development"},{"$f":"'Reference Formulas'!$Z26","v":0},{"$f":"'Reference Formulas'!$AA26","v":0},{"$f":"'Reference Formulas'!$AB26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$9","v":"Misc. Infrastructure"},{"$f":"'Reference Formulas'!$Z9","v":0},{"$f":"'Reference Formulas'!$AA9","v":0},{"$f":"'Reference Formulas'!$AB9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$18","v":"Misc. Applications"},{"$f":"'Reference Formulas'!$Z18","v":0},{"$f":"'Reference Formulas'!$AA18","v":0},{"$f":"'Reference Formulas'!$AB9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$27","v":"Misc. Personnel"},{"$f":"'Reference Formulas'!$Z27","v":0},{"$f":"'Reference Formulas'!$AA27","v":0},{"$f":"'Reference Formulas'!$AB27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$6","v":0},{"$f":"'Reference Formulas'!F$6","v":0},{"$f":"'Reference Formulas'!G$6","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$8","v":0},{"$f":"'Reference Formulas'!F$8","v":0},{"$f":"'Reference Formulas'!G$8","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$10","v":0},{"$f":"'Reference Formulas'!F$10","v":0},{"$f":"'Reference Formulas'!G$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Aside from networking equipment, this category typically applies only if you have on-premise infrastructure, whether you host it at your location, in a colocation center, or in a data center.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"This category tends to be extensive, and it varies significantly from company to company. It is meant to address the variety of software solutions that IT uses for their work, as well as any software solutions IT manages and/or pays for.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Typically, these are the labor costs associated with configuring, supporting, and managing the item under assessment rather than the costs associated with more generalized day-to-day activities and job function."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$A$7","v":"Data Center and Hosting Costs"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$A$9","v":"Employee Devices and Hardware"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$A$11","v":"Rollout"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$10","v":"Rent/Mortgage"},{"$f":"'Reference Formulas'!$Z10","v":0},{"$f":"'Reference Formulas'!$AA10","v":0},{"$f":"'Reference Formulas'!$AB10","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$19","v":"Laptops"},{"$f":"'Reference Formulas'!$Z19","v":0},{"$f":"'Reference Formulas'!$AA19","v":0},{"$f":"'Reference Formulas'!$AB19","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$28","v":"Installation & Setup"},{"$f":"'Reference Formulas'!$Z28","v":0},{"$f":"'Reference Formulas'!$AA28","v":0},{"$f":"'Reference Formulas'!$AB28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$11","v":"Insurance"},{"$f":"'Reference Formulas'!$Z11","v":0},{"$f":"'Reference Formulas'!$AA11","v":0},{"$f":"'Reference Formulas'!$AB11","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$20","v":"Smartphones"},{"$f":"'Reference Formulas'!$Z20","v":0},{"$f":"'Reference Formulas'!$AA20","v":0},{"$f":"'Reference Formulas'!$AB20","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$29","v":"Professional Services"},{"$f":"'Reference Formulas'!$Z29","v":0},{"$f":"'Reference Formulas'!$AA29","v":0},{"$f":"'Reference Formulas'!$AB29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$12","v":"Utilities"},{"$f":"'Reference Formulas'!$Z12","v":0},{"$f":"'Reference Formulas'!$AA12","v":0},{"$f":"'Reference Formulas'!$AB12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$21","v":"Data plans"},{"$f":"'Reference Formulas'!$Z21","v":0},{"$f":"'Reference Formulas'!$AA21","v":0},{"$f":"'Reference Formulas'!$AB21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$30","v":"Training"},{"$f":"'Reference Formulas'!$Z30","v":0},{"$f":"'Reference Formulas'!$AA30","v":0},{"$f":"'Reference Formulas'!$AB30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$13","v":"Security"},{"$f":"'Reference Formulas'!$Z13","v":0},{"$f":"'Reference Formulas'!$AA13","v":0},{"$f":"'Reference Formulas'!$AB13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$22","v":"Peripherals"},{"$f":"'Reference Formulas'!$Z22","v":0},{"$f":"'Reference Formulas'!$AA22","v":0},{"$f":"'Reference Formulas'!$AB22","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$31","v":"Misc. Rollout"},{"$f":"'Reference Formulas'!$Z31","v":0},{"$f":"'Reference Formulas'!$AA31","v":0},{"$f":"'Reference Formulas'!$AB31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$14","v":"Misc. Data Center"},{"$f":"'Reference Formulas'!$Z14","v":0},{"$f":"'Reference Formulas'!$AA14","v":0},{"$f":"'Reference Formulas'!$AB14","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$23","v":"Misc. Hardware"},{"$f":"'Reference Formulas'!$Z23","v":0},{"$f":"'Reference Formulas'!$AA23","v":0},{"$f":"'Reference Formulas'!$AB23","v":0},null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$11","v":0},{"$f":"'Reference Formulas'!F$11","v":0},{"$f":"'Reference Formulas'!G$11","v":0}]
[null,null,null,{"$f":"'Reference Formulas'!$Q6","v":0},{"$f":"'Reference Formulas'!$Q7","v":0},{"$f":"'Reference Formulas'!$Q8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!E$7","v":0},{"$f":"'Reference Formulas'!F$7","v":0},{"$f":"'Reference Formulas'!G$7","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$9","v":0},{"$f":"'Reference Formulas'!F$9","v":0},{"$f":"'Reference Formulas'!G$9","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Introducing a new tool or stack requires time and money for implementation and configuration, as well as training for those who will use it on an ongoing basis."]
[null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Data center and hosting costs also mainly apply to companies with on-premise infrastructure. This category includes all the costs of housing, powering, and physically securing infrastructure equipment.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Any physical hardware and associated connectivity plans purchased by your company and issued to employees falls under this category."]
[]
[]
[]
[]
["© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Executive Dashboard | Projected","index":5,"n_rows":34,"n_cols":45,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,34,48],[9,3,26,3],[9,4,26,4],[9,5,26,5],[19,11,26,11],[19,12,26,12],[19,13,26,13],[19,24,26,24],[28,14,29,18],[8,26,14,26],[8,37,14,37],[19,25,26,25],[19,26,26,26],[20,27,20,31],[8,11,14,11],[8,12,14,12],[8,13,14,13],[8,24,14,24],[8,25,14,25],[27,40,28,44],[16,14,17,18],[16,27,17,31],[16,40,17,44],[18,11,18,13],[18,24,18,26],[18,37,18,39],[28,27,29,31],[7,37,7,39],[8,38,14,38],[8,39,14,39],[19,37,26,37],[19,38,26,38],[19,39,26,39],[2,1,2,21],[3,1,3,27],[6,4,6,5],[7,3,7,5],[7,11,7,13],[7,24,7,26]]}
[null,"Total Cost of Ownership Comparison | Executive Summary"]
[]
[null,{"$f":"'Reference Formulas'!Q27","v":"Projected Total Cost of Ownership Comparison: 0 vs 0"}]
[null,"Future projection costs estimate how much a solution will cost within a given time period that you've chosen. Future costs are ideal for proposed solutions, because they do not have associated past costs."]
[]
[]
[]
[null,null,null,"Overall Total Cost of Ownership",null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A6","v":"Infrastructure Equipment"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A8","v":"Software and Applications"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A10","v":"Personnel and Support"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$6","v":"Servers"},{"$f":"'Reference Formulas'!$AC6","v":0},{"$f":"'Reference Formulas'!$AD6","v":0},{"$f":"'Reference Formulas'!$AE6","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$15","v":"IT Solutions"},{"$f":"'Reference Formulas'!$AC15","v":0},{"$f":"'Reference Formulas'!$AD15","v":0},{"$f":"'Reference Formulas'!$AE15","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$24","v":"Salaries"},{"$f":"'Reference Formulas'!$AC24","v":0},{"$f":"'Reference Formulas'!$AD24","v":0},{"$f":"'Reference Formulas'!$AE24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$7","v":"Networking Equipment"},{"$f":"'Reference Formulas'!$AC7","v":0},{"$f":"'Reference Formulas'!$AD7","v":0},{"$f":"'Reference Formulas'!$AE7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$16","v":"SaaS Solutions"},{"$f":"'Reference Formulas'!$AC16","v":0},{"$f":"'Reference Formulas'!$AD16","v":0},{"$f":"'Reference Formulas'!$AE16","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$25","v":"Consulting Services"},{"$f":"'Reference Formulas'!$AC25","v":0},{"$f":"'Reference Formulas'!$AD25","v":0},{"$f":"'Reference Formulas'!$AE25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$8","v":"Software and Licensing"},{"$f":"'Reference Formulas'!$AC8","v":0},{"$f":"'Reference Formulas'!$AD8","v":0},{"$f":"'Reference Formulas'!$AE8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$17","v":"Business Software"},{"$f":"'Reference Formulas'!$AC17","v":0},{"$f":"'Reference Formulas'!$AD17","v":0},{"$f":"'Reference Formulas'!$AE17","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$26","v":"Professional Development"},{"$f":"'Reference Formulas'!$AC26","v":0},{"$f":"'Reference Formulas'!$AD26","v":0},{"$f":"'Reference Formulas'!$AE26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$9","v":"Misc. Infrastructure"},{"$f":"'Reference Formulas'!$AC9","v":0},{"$f":"'Reference Formulas'!$AD9","v":0},{"$f":"'Reference Formulas'!$AE9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$18","v":"Misc. Applications"},{"$f":"'Reference Formulas'!$AC18","v":0},{"$f":"'Reference Formulas'!$AD18","v":0},{"$f":"'Reference Formulas'!$AE18","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$27","v":"Misc. Personnel"},{"$f":"'Reference Formulas'!$AC27","v":0},{"$f":"'Reference Formulas'!$AD27","v":0},{"$f":"'Reference Formulas'!$AE27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$6","v":0},{"$f":"'Reference Formulas'!N$6","v":0},{"$f":"'Reference Formulas'!O$6","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$8","v":0},{"$f":"'Reference Formulas'!N$8","v":0},{"$f":"'Reference Formulas'!O$8","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$10","v":0},{"$f":"'Reference Formulas'!N$10","v":0},{"$f":"'Reference Formulas'!O$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Aside from networking equipment, this category typically applies only if you have on-premise infrastructure, whether you host it at your location, in a colocation center, or in a data center.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"This category tends to be extensive, and it varies significantly from company to company. It is meant to address the variety of software solutions that IT uses for their work, as well as any software solutions IT manages and/or pays for.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Typically, these are the labor costs associated with configuring, supporting, and managing the item under assessment rather than the costs associated with more generalized day-to-day activities and job function."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A7","v":"Data Center and Hosting Costs"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A9","v":"Employee Devices and Hardware"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A11","v":"Rollout"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$10","v":"Rent/Mortgage"},{"$f":"'Reference Formulas'!$AC10","v":0},{"$f":"'Reference Formulas'!$AD10","v":0},{"$f":"'Reference Formulas'!$AE10","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$19","v":"Laptops"},{"$f":"'Reference Formulas'!$AC19","v":0},{"$f":"'Reference Formulas'!$AD19","v":0},{"$f":"'Reference Formulas'!$AE19","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$28","v":"Installation & Setup"},{"$f":"'Reference Formulas'!$AC28","v":0},{"$f":"'Reference Formulas'!$AD28","v":0},{"$f":"'Reference Formulas'!$AE28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$11","v":"Insurance"},{"$f":"'Reference Formulas'!$AC11","v":0},{"$f":"'Reference Formulas'!$AD11","v":0},{"$f":"'Reference Formulas'!$AE11","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$20","v":"Smartphones"},{"$f":"'Reference Formulas'!$AC20","v":0},{"$f":"'Reference Formulas'!$AD20","v":0},{"$f":"'Reference Formulas'!$AE20","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$29","v":"Professional Services"},{"$f":"'Reference Formulas'!$AC29","v":0},{"$f":"'Reference Formulas'!$AD29","v":0},{"$f":"'Reference Formulas'!$AE29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$12","v":"Utilities"},{"$f":"'Reference Formulas'!$AC12","v":0},{"$f":"'Reference Formulas'!$AD12","v":0},{"$f":"'Reference Formulas'!$AE12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$21","v":"Data plans"},{"$f":"'Reference Formulas'!$AC21","v":0},{"$f":"'Reference Formulas'!$AD21","v":0},{"$f":"'Reference Formulas'!$AE21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$30","v":"Training"},{"$f":"'Reference Formulas'!$AC30","v":0},{"$f":"'Reference Formulas'!$AD30","v":0},{"$f":"'Reference Formulas'!$AE30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$13","v":"Security"},{"$f":"'Reference Formulas'!$AC13","v":0},{"$f":"'Reference Formulas'!$AD13","v":0},{"$f":"'Reference Formulas'!$AE13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$22","v":"Peripherals"},{"$f":"'Reference Formulas'!$AC22","v":0},{"$f":"'Reference Formulas'!$AD22","v":0},{"$f":"'Reference Formulas'!$AE22","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$31","v":"Misc. Rollout"},{"$f":"'Reference Formulas'!$AC31","v":0},{"$f":"'Reference Formulas'!$AD31","v":0},{"$f":"'Reference Formulas'!$AE31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$14","v":"Misc. Data Center"},{"$f":"'Reference Formulas'!$AC14","v":0},{"$f":"'Reference Formulas'!$AD14","v":0},{"$f":"'Reference Formulas'!$AE14","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$23","v":"Misc. Hardware"},{"$f":"'Reference Formulas'!$AC23","v":0},{"$f":"'Reference Formulas'!$AD23","v":0},{"$f":"'Reference Formulas'!$AE23","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$Y$32","v":0}]
[null,null,null,{"$f":"'Reference Formulas'!$Q11","v":0},{"$f":"'Reference Formulas'!$Q12","v":0},{"$f":"'Reference Formulas'!$Q13","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!M$7","v":0},{"$f":"'Reference Formulas'!N$7","v":0},{"$f":"'Reference Formulas'!O$7","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$9","v":0},{"$f":"'Reference Formulas'!N$9","v":0},{"$f":"'Reference Formulas'!O$9","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$11","v":0},{"$f":"'Reference Formulas'!N$11","v":0},{"$f":"'Reference Formulas'!O$11","v":0},"Introducing a new tool or stack requires time and money for implementation and configuration, as well as training for those who will use it on an ongoing basis."]
[null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Data center and hosting costs also mainly apply to companies with on-premise infrastructure. This category includes all the costs of housing, powering, and physically securing infrastructure equipment.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0},"Any physical hardware and associated connectivity plans purchased by your company and issued to employees falls under this category.",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":0},{"$f":"'Reference Formulas'!$C$7","v":0},{"$f":"'Reference Formulas'!$C$8","v":0}]
[]
[]
[]
[]
["© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Executive Dashboard | Current","index":6,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[10,2,29,3],[33,2,33,3],[36,0,37,12],[0,0,0,12],[2,1,2,11],[3,1,3,11],[6,2,6,3],[8,2,8,3],[8,8,8,9]]}
["Total Cost of Ownership Analysis | Executive Summary"]
[]
[null,{"$f":"CONCATENATE(\"Year-to-Date (YTD) Total Cost of Ownership Overview: \" & 'Reference Formulas'!$C$6)","v":"Year-to-Date (YTD) Total Cost of Ownership Overview: 0"}]
[null,"Year-to-date, or current, TCO reflects the costs you've already paid for an existing solution. This analysis is meant to organize and review the total cost of ownership of your existing solution to better understand where effciencies may be gained."]
[]
[]
[null,null,{"$f":"'Reference Formulas'!Q24","v":"Total Cost of Ownership: 0"}]
[]
[null,null,{"$f":"'Reference Formulas'!Q9","v":0},null,null,null,null,null,"Category Breakdown"]
[]
[null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE('Reference Formulas'!I6:I11,{\"\"charttype\"\",\"\"column\"\";\"\"ymin\"\", 0; \"\"ymax\"\",(SUM('Reference Formulas'!I6:I11)*0.05);\"\"firstcolor\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""},null,null,null,null,null,{"$f":"'Reference Formulas'!A6","v":"Infrastructure Equipment"},{"$f":"'Reference Formulas'!I6","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J11,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A7","v":"Data Center and Hosting Costs"},{"$f":"'Reference Formulas'!I7","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J12,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A8","v":"Software and Applications"},{"$f":"'Reference Formulas'!I8","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J13,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A9","v":"Employee Devices and Hardware"},{"$f":"'Reference Formulas'!I9","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J14,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A10","v":"Personnel and Support"},{"$f":"'Reference Formulas'!I10","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J15,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!A11","v":"Rollout"},{"$f":"'Reference Formulas'!I11","v":0},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(J16,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",(MAX(J11:J16)*1.05);\"\"color1\"\",\"\"#41C8C3\"\"})\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Reference Formulas'!$C$6","v":0}]
[null,null,{"$f":"'Reference Formulas'!Q6","v":0}]
[]
[]
[]
[]
["© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Formulas","index":7,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,34,7]]}
["Compound Inflation Calculator (In)"]
["Formula","FV = PV(1+r)^n"]
["# years (n)",5]
["rate of inflation (r)",2.1000000000000001E-2,"(The average inflation in the U.S. over the last 10 years was 2.1%, but is currently higher.)"]
["Present value (PV)",6000]
["Future Value (FV) =",{"$f":"B5*(1+B4)^B3","v":6657.0215189346018}]
[]
["To calculate compound raises, change the rate of inflation to the projected salary raise per year."]
[]
["Labor Costs per Worker (L)"]
["Formula","L = h*t"]
["Salary",130000]
["Hourly wage (h)",{"$f":"B12/2080","v":62.5}]
["Time spent on task per month",10]
["Time spent on task per year (t)",{"$f":"B14*12","v":120}]
["Labor costs for task (L) =",{"$f":"B15*B13","v":7500}]
[]
["Convert Time to Years (T)"]
["Original Unit:",null,"Available units per year:"]
["hours per day",2,{"$f":"B20*365","v":730},"Use for non-labor"]
["hours per working day (standard US)",2,{"$f":"B21*260","v":520},"Use for labor "]
["hours per week",null,{"$f":"B22*52","v":0},"Use for non-labor"]
["hours per working week (standard US)",null,{"$f":"B23*48","v":0},"Use for labor"]
["Hours per month",10,{"$f":"B24*12","v":120},"Use for non-labor"]
["Hours per working month",10,{"$f":"B25*11","v":110},"Use for labor"]
[]
["Growth (G)"]
["Final number",{"$f":"B29*(1+(B31*B32))","v":52}]
["Current number",40]
["Total growth rate",0.3]
["Growth rate per year",{"$f":"B30/B32","v":9.9999999999999992E-2}]
["# years ",3]
[]
["© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]

{"sheet":"Reference Formulas","index":8,"n_rows":31,"n_cols":31,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,17],[4,1,4,2]]}
["This is the master reference sheet, to be used by dashboards throughout the calculator. See color coding table to determine references and in-sheet calculations. \n\nDO NOT MOVE ANY PRE-EXISTING VALUES UNLESS YOU PLAN TO ADJUST THE REFERENCES. Other tabs will use absolute references to this sheet. As needed add values below (if adding to a list) or create a new list to the right.\n\n© 2022 JumpCloud Inc. All rights reserved.\n\nJUMPCLOUD EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING ANY AND ALL REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, ACCURACY, CONTINUOUS OR ERROR-FREE OPERATION FROM OR RELATING TO THIS CALCULATOR."]
["Yes","Color Codes:","Reference","In-sheet calculation"]
["No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lifetime",null,null,"Projected"]
[null,null,null,null,"Option 1","Option 2","Option 3",null,"Option 1","Option 2","Option 3",null,"Option 1","Option 2","Option 3",null,null,null,null,null,null,null,null,null,null,"Option 1","Option 2","Option 3"]
["Categories for master template and dashboard summaries","TCO Analysis | Names of things being compared",null,"Lifetime TCO Totals:",{"$f":"$C$6","v":0},{"$f":"$C$7","v":0},{"$f":"$C$8","v":0},"Past/YTD TCO Totals:",{"$f":"$C$6","v":0},{"$f":"$C$7","v":0},{"$f":"$C$8","v":0},"Future TCO Totals:",{"$f":"$C$6","v":0},{"$f":"$C$7","v":0},{"$f":"$C$8","v":0},"TCO Dashboard Calculations",null,"Data Validation for Template Instructions Workplace Environment","Infrastructure Equipment","Data Center and Hosting Costs","Software and Applications","Employee Devices and Hardware","Personnel and Support","Rollout","SUMIF formulas for subcategories | Lifetime TCO",{"$f":"$C$6","v":0},{"$f":"$C$7","v":0},{"$f":"$C$8","v":0},{"$f":"$C$6","v":0},{"$f":"$C$7","v":0},{"$f":"$C$8","v":0}]
["Infrastructure Equipment","Option 1",{"$f":"'Template Instructions'!$F$17","v":0},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$S$3","v":0},{"$f":"'Option 2'!$S$3","v":0},{"$f":"'Option 3'!$S$3","v":0},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$I$3","v":0},{"$f":"'Option 2'!$I$3","v":0},{"$f":"'Option 3'!$I$3","v":0},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$R$3","v":0},{"$f":"'Option 2'!$R$3","v":0},{"$f":"'Option 3'!$R$3","v":0},"Lifetime | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($E$6:$E$11)","v":0},"Fully Remote","Servers","Rent/Mortgage","IT Solutions","Laptops","Salaries","Installation & Setup","Servers",{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$6,'Option 1'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$6,'Option 2'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$6,'Option 3'!$S$4:$S$15)","v":0},{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$6,'Option 1'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$6,'Option 2'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$6,'Option 3'!$R$4:$R$15)","v":0}]
["Data Center and Hosting Costs","Option 2",{"$f":"'Template Instructions'!$F$18","v":0},{"$f":"$A$7","v":"Data Center and Hosting Costs"},{"$f":"'Option 1'!$S$29","v":0},{"$f":"'Option 2'!$S$29","v":0},{"$f":"'Option 3'!$S$29","v":0},{"$f":"$A$7","v":"Data Center and Hosting Costs"},{"$f":"'Option 1'!$I$29","v":0},{"$f":"'Option 2'!$I$29","v":0},{"$f":"'Option 3'!$I$29","v":0},{"$f":"$A$7","v":"Data Center and Hosting Costs"},{"$f":"'Option 1'!$R$29","v":0},{"$f":"'Option 2'!$R$29","v":0},{"$f":"'Option 3'!$R$29","v":0},"Lifetime | Total Cost Chart | Option 2 | Total Cost Summation",{"$f":"SUM($F$6:$F$11)","v":0},"Mostly Remote","Networking Equipment","Insurance","SaaS Solutions","Smartphones","Consulting Services","Professional Services","Networking Equipment",{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$7,'Option 1'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$7,'Option 2'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$7,'Option 3'!$S$4:$S$15)","v":0},{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$7,'Option 1'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$7,'Option 2'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$7,'Option 3'!$R$4:$R$15)","v":0}]
["Software and Applications","Option 3",{"$f":"'Template Instructions'!$F$19","v":0},{"$f":"$A$8","v":"Software and Applications"},{"$f":"'Option 1'!$S$55","v":0},{"$f":"'Option 2'!$S$55","v":0},{"$f":"'Option 3'!$S$55","v":0},{"$f":"$A$8","v":"Software and Applications"},{"$f":"'Option 1'!$I$55","v":0},{"$f":"'Option 2'!$I$55","v":0},{"$f":"'Option 3'!$I$55","v":0},{"$f":"$A$8","v":"Software and Applications"},{"$f":"'Option 1'!$R$55","v":0},{"$f":"'Option 2'!$R$55","v":0},{"$f":"'Option 3'!$R$55","v":0},"Lifetime | Total Cost Chart | Option 3 | Total Cost Summation",{"$f":"SUM($G$6:$G$11)","v":0},"Hybrid","Software and Licensing","Utilities","Business Software","Data plans","Professional Development","Training","Software and Licensing",{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$8,'Option 1'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$8,'Option 2'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$8,'Option 3'!$S$4:$S$15)","v":0},{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$8,'Option 1'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$8,'Option 2'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$8,'Option 3'!$R$4:$R$15)","v":0}]
["Employee Devices and Hardware",null,null,{"$f":"$A$9","v":"Employee Devices and Hardware"},{"$f":"'Option 1'!$S$81","v":0},{"$f":"'Option 2'!$S$81","v":0},{"$f":"'Option 3'!$S$81","v":0},{"$f":"$A$9","v":"Employee Devices and Hardware"},{"$f":"'Option 1'!$I$81","v":0},{"$f":"'Option 2'!$I$81","v":0},{"$f":"'Option 3'!$I$81","v":0},{"$f":"$A$9","v":"Employee Devices and Hardware"},{"$f":"'Option 1'!$R$81","v":0},{"$f":"'Option 2'!$R$81","v":0},{"$f":"'Option 3'!$R$81","v":0},"Past | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($I$6:$I$11)","v":0},"Mostly In Office","Misc. Infrastructure","Security","Misc. Applications","Peripherals","Misc. Personnel","Misc. Rollout","Misc. Infrastructure",{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$9,'Option 1'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$9,'Option 2'!$S$4:$S$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$9,'Option 3'!$S$4:$S$15)","v":0},{"$f":"SUMIF('Option 1'!$A$4:$A$28,$Y$9,'Option 1'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$9,'Option 2'!$R$4:$R$28)","v":0},{"$f":"SUMIF('Option 3'!$A$4:$A$15,$Y$9,'Option 3'!$R$4:$R$15)","v":0}]
["Personnel and Support",null,null,{"$f":"$A$10","v":"Personnel and Support"},{"$f":"'Option 1'!$S$107","v":0},{"$f":"'Option 2'!$S$107","v":0},{"$f":"'Option 3'!$S$107","v":0},{"$f":"$A$10","v":"Personnel and Support"},{"$f":"'Option 1'!$I$107","v":0},{"$f":"'Option 2'!$I$107","v":0},{"$f":"'Option 3'!$I$107","v":0},{"$f":"$A$10","v":"Personnel and Support"},{"$f":"'Option 1'!$R$107","v":0},{"$f":"'Option 2'!$R$107","v":0},{"$f":"'Option 3'!$R$107","v":0},"Past | Total Cost Chart | Option 2 | Total Cost Summation",{"$f":"SUM($J$6:$J$11)","v":0},"Fully In Office",null,"Misc. Data Center",null,"Misc. Hardware",null,null,"Rent/Mortgage",{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$10,'Option 1'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$10,'Option 2'!$S$30:$S$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$10,'Option 3'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$10,'Option 1'!$R$30:$R$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$10,'Option 2'!$R$30:$R$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$10,'Option 3'!$R$30:$R$54)","v":0}]
["Rollout",null,null,{"$f":"$A$11","v":"Rollout"},{"$f":"'Option 1'!$S$133","v":0},{"$f":"'Option 2'!$S$133","v":0},{"$f":"'Option 3'!$S$133","v":0},{"$f":"$A$11","v":"Rollout"},{"$f":"'Option 1'!$I$133","v":0},{"$f":"'Option 2'!$I$133","v":0},{"$f":"'Option 3'!$I$133","v":0},{"$f":"$A$11","v":"Rollout"},{"$f":"'Option 1'!$R$133","v":0},{"$f":"'Option 2'!$R$133","v":0},{"$f":"'Option 3'!$R$133","v":0},"Future | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($M$6:$M$11)","v":0},null,null,null,null,null,null,null,"Insurance",{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$11,'Option 1'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$11,'Option 2'!$S$30:$S$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$11,'Option 3'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$11,'Option 1'!$R$30:$R$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$11,'Option 2'!$R$30:$R$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$11,'Option 3'!$R$30:$R$54)","v":0}]
[null,null,null,{"$f":"$A12","v":0},null,null,null,{"$f":"$A12","v":0},null,null,null,{"$f":"$A12","v":0},null,null,null,"Future | Total Cost Chart | Option 2 | Total Cost Summation",{"$f":"SUM($N$6:$N$11)","v":0},null,null,null,null,null,null,null,"Utilities",{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$12,'Option 1'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$12,'Option 2'!$S$30:$S$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$12,'Option 3'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$12,'Option 1'!$R$30:$R$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$12,'Option 2'!$R$30:$R$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$12,'Option 3'!$R$30:$R$54)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Future | Total Cost Chart | Option 3 | Total Cost Summation",{"$f":"SUM($O$6:$O$11)","v":0},null,null,null,null,null,null,null,"Security",{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$13,'Option 1'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$13,'Option 2'!$S$30:$S$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$13,'Option 3'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$13,'Option 1'!$R$30:$R$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$13,'Option 2'!$R$30:$R$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$13,'Option 3'!$R$30:$R$54)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Lifetime | Total Cost Chart | Total Savings From BLANK | Shows name of winning option",{"$f":"_xludf.ifs($Q$6>$Q$7,$C$7, $Q$6=$Q$7, \"Both solutions are equal.\",$Q$6<$Q$7,$C$6)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"Misc. Data Center",{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$14,'Option 1'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$14,'Option 2'!$S$30:$S$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$14,'Option 3'!$S$30:$S$54)","v":0},{"$f":"SUMIF('Option 1'!$A$30:$A$54,$Y$14,'Option 1'!$R$30:$R$54)","v":0},{"$f":"SUMIF('Option 2'!$A$30:$A$41,$Y$14,'Option 2'!$R$30:$R$41)","v":0},{"$f":"SUMIF('Option 3'!$A$30:$A$54,$Y$14,'Option 3'!$R$30:$R$54)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Past | Total Cost Chart | Total Savings From BLANK | Shows name of winning option",{"$f":"_xludf.ifs($Q$9>$Q$10,$C$7, $Q$9=$Q$10, \"Both solutions are equal.\",$Q$9<$Q$10,$C$6)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"IT Solutions",{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$15,'Option 1'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$15,'Option 2'!$S$56:$S$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$15,'Option 3'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$15,'Option 1'!$R$56:$R$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$15,'Option 2'!$R$56:$R$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$15,'Option 3'!$R$56:$R$80)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Future | Total Cost Chart | Total Savings From BLANK | Shows name of winning option",{"$f":"_xludf.ifs($Q$11>$Q$12,$C$7, $Q$11=$Q$12, \"Both solutions are equal.\",$Q$11<$Q$12,$C$6)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"SaaS Solutions",{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$16,'Option 1'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$16,'Option 2'!$S$56:$S$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$16,'Option 3'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$16,'Option 1'!$R$56:$R$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$16,'Option 2'!$R$56:$R$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$16,'Option 3'!$R$56:$R$80)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Lifetime | Total Cost Chart | Total Savings from BLANK | Shows delta savings",{"$f":"_xludf.ifs($Q$14=$C$6,$Q$7-$Q$6,$Q$14=$C$7,$Q$6-$Q$7,$Q$14=\"Both solutions are equal.\",0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"Business Software",{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$17,'Option 1'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$17,'Option 2'!$S$56:$S$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$17,'Option 3'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$17,'Option 1'!$R$56:$R$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$17,'Option 2'!$R$56:$R$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$17,'Option 3'!$R$56:$R$80)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Past | Total Cost Chart | Total Savings from BLANK | Shows delta savings",{"$f":"$Q$9","v":0},null,null,null,null,null,null,null,"Misc. Applications",{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$18,'Option 1'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$18,'Option 2'!$S$56:$S$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$18,'Option 3'!$S$56:$S$80)","v":0},{"$f":"SUMIF('Option 1'!$A$56:$A$80,$Y$18,'Option 1'!$R$56:$R$80)","v":0},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$18,'Option 2'!$R$56:$R$67)","v":0},{"$f":"SUMIF('Option 3'!$A$56:$A$80,$Y$18,'Option 3'!$R$56:$R$80)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Future | Total Cost Chart | Total Savings from BLANK | Shows delta savings",{"$f":"_xludf.ifs($Q$16=$C$6,$Q$12-$Q$11,$Q$16=$C$7,$Q$11-$Q$12,$Q$16=\"Both solutions are equal.\",0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"Laptops",{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$19,'Option 1'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$19,'Option 2'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$19,'Option 3'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$19,'Option 1'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$19,'Option 2'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$19,'Option 3'!$R$82:$R$106)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Lifetime | Total Cost Chart | Total Savings from BLANK | Shows percent savings",{"$f":"CONCATENATE(\"(\" & ROUND((((MAX($Q$6:$Q$7)-MIN($Q$6:$Q$7))/MIN($Q$6:$Q$7))*100),0) & \"% over \" & 'Template Instructions'!$F$20 &\" years)\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Smartphones",{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$20,'Option 1'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$20,'Option 2'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$20,'Option 3'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$20,'Option 1'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$20,'Option 2'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$20,'Option 3'!$R$82:$R$106)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Past | Total Cost Chart | Total Savings from BLANK | Shows percent savings",{"$f":"CONCATENATE(\"(\" & ROUND((((MAX($Q$9:$Q$10)-MIN($Q$9:$Q$10))/MIN($Q$9:$Q$10))*100),0) & \"% over \" & 'Template Instructions'!$F$20 &\" years)\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Data plans",{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$21,'Option 1'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$21,'Option 2'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$21,'Option 3'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$21,'Option 1'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$21,'Option 2'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$21,'Option 3'!$R$82:$R$106)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Future | Total Cost Chart | Total Savings from BLANK | Shows percent savings",{"$f":"CONCATENATE(\"(\" & ROUND((((MAX($Q$11:$Q$12)-MIN($Q$11:$Q$12))/MIN($Q$11:$Q$12))*100),0) & \"% over \" & 'Template Instructions'!$F$20 &\" years)\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Peripherals",{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$22,'Option 1'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$22,'Option 2'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$22,'Option 3'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$22,'Option 1'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$22,'Option 2'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$22,'Option 3'!$R$82:$R$106)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Lifetime | Total Cost Chart | Total Savings from BLANK | Show message about total savings",{"$f":"CONCATENATE(\"Total savings from using \" & $Q$14)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"Misc. Hardware",{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$23,'Option 1'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$23,'Option 2'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$23,'Option 3'!$S$82:$S$106)","v":0},{"$f":"SUMIF('Option 1'!$A$82:$A$106,$Y$23,'Option 1'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$23,'Option 2'!$R$82:$R$106)","v":0},{"$f":"SUMIF('Option 3'!$A$82:$A$106,$Y$23,'Option 3'!$R$82:$R$106)","v":0}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Past | Total Cost Chart | Total Savings from BLANK | Show message about total savings",{"$f":"CONCATENATE(\"Total Cost of Ownership: \" & $C$6)","v":"Total Cost of Ownership: 0"},null,null,null,null,null,null,null,"Salaries",{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$24,'Option 1'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$24,'Option 2'!$S$108:$S$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$24,'Option 3'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$24,'Option 1'!$R$108:$R$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$24,'Option 2'!$R$108:$R$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$24,'Option 3'!$R$108:$R$132)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Future | Total Cost Chart | Total Savings from BLANK | Show message about total savings",{"$f":"CONCATENATE(\"Total savings from using \" & $Q$16)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"Consulting Services",{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$25,'Option 1'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$25,'Option 2'!$S$108:$S$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$25,'Option 3'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$25,'Option 1'!$R$108:$R$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$25,'Option 2'!$R$108:$R$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$25,'Option 3'!$R$108:$R$132)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lifetime | Dashboard Title",{"$f":"CONCATENATE(\"Lifetime Total Cost of Ownership Comparison: \" & 'Reference Formulas'!$C$6 & \" vs \" & 'Reference Formulas'!$C$7 & IF(ISTEXT(C8) = TRUE, \" vs \" & 'Reference Formulas'!$C$8,\"\"))","v":"Lifetime Total Cost of Ownership Comparison: 0 vs 0"},null,null,null,null,null,null,null,"Professional Development",{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$26,'Option 1'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$26,'Option 2'!$S$108:$S$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$26,'Option 3'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$26,'Option 1'!$R$108:$R$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$26,'Option 2'!$R$108:$R$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$26,'Option 3'!$R$108:$R$132)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Future | Dashboard Title",{"$f":"CONCATENATE(\"Projected Total Cost of Ownership Comparison: \" & 'Reference Formulas'!$C$6 & \" vs \" & 'Reference Formulas'!$C$7 & IF(ISTEXT(C8) = TRUE, \" vs \" & 'Reference Formulas'!$C$8,\"\"))","v":"Projected Total Cost of Ownership Comparison: 0 vs 0"},null,null,null,null,null,null,null,"Misc. Personnel",{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$27,'Option 1'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$27,'Option 2'!$S$108:$S$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$27,'Option 3'!$S$108:$S$132)","v":0},{"$f":"SUMIF('Option 1'!$A$108:$A$132,$Y$27,'Option 1'!$R$108:$R$132)","v":0},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$27,'Option 2'!$R$108:$R$119)","v":0},{"$f":"SUMIF('Option 3'!$A$108:$A$132,$Y$27,'Option 3'!$R$108:$R$132)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Installation & Setup",{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$28,'Option 1'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$28,'Option 2'!$S$134:$S$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$28,'Option 3'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$28,'Option 1'!$R$134:$R$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$28,'Option 2'!$R$134:$R$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$28,'Option 3'!$R$134:$R$158)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Professional Services",{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$29,'Option 1'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$29,'Option 2'!$S$134:$S$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$29,'Option 3'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$29,'Option 1'!$R$134:$R$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$29,'Option 2'!$R$134:$R$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$29,'Option 3'!$R$134:$R$158)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training",{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$30,'Option 1'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$30,'Option 2'!$S$134:$S$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$30,'Option 3'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$30,'Option 1'!$R$134:$R$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$30,'Option 2'!$R$134:$R$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$30,'Option 3'!$R$134:$R$158)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Rollout",{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$31,'Option 1'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$31,'Option 2'!$S$134:$S$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$31,'Option 3'!$S$134:$S$158)","v":0},{"$f":"SUMIF('Option 1'!$A$134:$A$158,$Y$31,'Option 1'!$R$134:$R$158)","v":0},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$31,'Option 2'!$R$134:$R$146)","v":0},{"$f":"SUMIF('Option 3'!$A$134:$A$158,$Y$31,'Option 3'!$R$134:$R$158)","v":0}]