{"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,"Company ABC",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,250,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,1]
[null,null,"Workplace environment\n(choose the best option from the dropdown)",null,null,"Hybrid",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,"Existing Infrastructure",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,"Cloud Alternative"]
[null,null,null,"Option 3\n(if applicable)"]
[null,null,"Assessment Timeframe\n(in years)",null,null,5]
[null,null,"Goal of the Assessment\n(a brief description of what you are comparing or assessing, and why)",null,null,"Company ABC has on-prem infrastructure and is comparing the TCO of moving to the cloud vs. keeping their legacy infrastructure as-is over the course of 5 years. Company ABC has had its currrent legacy infrastructure for the past 10 years; as such, past costs will stretch as far back as 10 years."]
[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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!Q6","v":12485391},"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":35850},null,{"$f":"SUM(F$4:F$28)","v":220750},null,null,{"$f":"SUM($I4:$I28)","v":238350},null,null,{"$f":"SUM($L4:$L28)","v":24409},null,null,{"$f":"SUM($O4:$O28)","v":169483.02077989775},null,null,{"$f":"SUM($R4:$R28)","v":193892},{"$f":"SUM($S4:$S28)","v":432242}]
[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}]
["Servers","Servers","Will need update in 2027 (year 5)",5000,10,50000,null,5,50000,"No",null,0,10,5,55475.179324455014,null,null,55475,105475]
["Servers","Server software","Software + licensing",8750,1,8750,null,5,8750,"No",null,0,0,0,0,null,null,0,8750]
["Servers","Server rack ",null,1000,1,1000,null,5,1000,"No",null,0,0,0,0,null,null,0,1000]
["Networking Equipment","Switches",null,6000,12,72000,null,5,72000,"No",null,0,6,5,39942.129113607611,null,null,39942,111942]
["Networking Equipment","Access points",null,500,18,9000,null,5,9000,"No",null,0,12,3,6385.9935659999983,null,null,6386,15386]
["Networking Equipment","Firewalls","Next-generation firewall with VPN",2500,4,10000,null,5,10000,"No",null,0,0,0,0,null,null,0,10000]
["Networking Equipment","Firewall licensing","Yearly license",1000,4,4000,4400,5,21600,"Yes",4400,24409,0,0,0,null,null,24409,46009]
["Networking Equipment","WLAN controller",null,5000,1,5000,null,5,5000,"No",null,0,0,0,0,null,null,0,5000]
["Software and Licensing","On-site backup. To upgrade in 5 years","10 duplicate servers (and licenses)",6100,10,61000,null,5,61000,"No",null,0,10,5,67679.718775835121,null,null,67680,128680]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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:$D56)","v":73132},null,{"$f":"SUM($F30:$F54)","v":96880},null,null,{"$f":"SUM($I30:$I54)","v":587740},null,null,{"$f":"SUM($L30:$L54)","v":277597},null,null,{"$f":"SUM($O30:$O54)","v":0},null,null,{"$f":"SUM($R30:$R54)","v":277597},{"$f":"SUM($S30:$S54)","v":865337}]
[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}]
["Utilities","HVAC","$1100/mo; 13200 year (duplicated - one for offsite backup)",13200,2,26400,{"$f":"F31","v":26400},10,264000,"Yes",26400,146454,null,null,0,null,null,146454,410454]
["Rent/Mortgage","Real estate","$500/mo; $6000 per year (duplicated - one for offsite backup)",6000,2,12000,12000,10,120000,"Yes",12000,66570,null,null,0,null,null,66570,186570]
["Insurance","Insurance","$45/mo; $540/year",540,2,1080,540,10,5940,"Yes",540,2996,null,null,0,null,null,2996,8936]
["Utilities","Power","$500/mo/branch; 6000/year/branch",6000,2,12000,7200,10,76800,"Yes",7200,39942,null,null,0,null,null,39942,116742]
["Utilities","Generator","enterprise generator",40000,1,40000,6000,10,94000,"No",null,0,null,null,0,null,null,0,94000]
["Utilities","Internet","2,000/mo*12",2400,1,2400,2400,10,24000,"Yes",2400,13314,null,null,0,null,null,13314,37314]
["Security","Security ","door security/alarm system; cameras - $1500 per branch per year ",1500,2,3000,0,10,3000,"Yes",1500,8321,null,null,0,null,null,8321,11321]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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":3492},null,{"$f":"SUM($F56:$F80)","v":235080},null,null,{"$f":"SUM($I56:$I80)","v":1275480},null,null,{"$f":"SUM($L56:$L80)","v":1304111},null,null,{"$f":"SUM($O56:$O80)","v":0},null,null,{"$f":"SUM($R56:$R80)","v":1304111},{"$f":"SUM($S56:$S80)","v":2579591}]
[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}]
["IT Solutions","MFA ","$9/user/mo",108,250,27000,27000,3,81000,"Yes",27000,149783,null,null,0,null,null,149783,230783]
["Business Software","Office suite","$23/user/mo",276,250,69000,69000,10,690000,"Yes",69000,382779,null,null,0,null,null,382779,1072779]
["SaaS Solutions","Finance management","$90/mo; $1080/year",1080,1,1080,1080,6,6480,"Yes",1080,5991,null,null,0,null,null,5991,12471]
["Business Software","HR platform","$14/user/mo; 168/user/yr",168,250,42000,42000,5,210000,"Yes",42000,232996,null,null,0,null,null,232996,442996]
["Business Software","CRM","150/user/mo; 1800/user/yr. 45 licenses: sales + execs",1800,45,81000,81000,3,243000,"Yes",81000,449349,null,null,0,null,null,449349,692349]
["IT Solutions","MDM","$5/user/mo; 60/user/yr",60,250,15000,15000,3,45000,"Yes",15000,83213,null,null,0,null,null,83213,128213]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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":2220},null,{"$f":"SUM($F82:$F106)","v":335700},null,null,{"$f":"SUM($I82:$I106)","v":365100},null,null,{"$f":"SUM($L82:$L106)","v":81549},null,null,{"$f":"SUM($O82:$O106)","v":213930.78446099994},null,null,{"$f":"SUM(R$82:R$106)","v":295480},{"$f":"SUM($S82:$S106)","v":660580}]
[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}]
["Laptops","Laptops","Most laptops will need an upgrade in about 4 years - inflation calculator used",1200,250,300000,0,5,300000,"No",null,0,150,3,191579.80697999994,null,null,191580,491580]
["Smartphones","Smart phones","Android phones for sales and executives (35 employees)",600,35,21000,0,3,21000,"No",null,0,35,3,22350.977480999994,null,null,22351,43351]
["Data plans","Data plan for phones","Verizon: $35/line/mo; $420/line/year",420,35,14700,{"$f":"F85","v":14700},3,44100,"Yes",14700,81549,0,0,0,null,null,81549,125649]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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":492000},null,{"$f":"SUM($F108:$F132)","v":542000},null,null,{"$f":"SUM($I108:$I132)","v":5180000},null,null,{"$f":"SUM($L108:$L132)","v":2729379},null,null,{"$f":"SUM($O109:$O132)","v":0},null,null,{"$f":"SUM($R108:$R132)","v":2729379},{"$f":"SUM(S$108:S$132)","v":7909379}]
[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}]
["Salaries","Maintenance/configuration/support","About 1/2 of IT team's time attributed to maintenance/configuration/support.\nSalaries:\nIT Director: $180,000\nNetwork Security Officer: $160,000\n4 IT Admin: avg $130,000\nTotal per year: $860,000/yr\n*.5 = $430,000/yr",430000,1,430000,430000,10,4300000,"Yes",430000,2385433,0,0,0,null,null,2385433,6685433]
["Consulting Services","MSP fees","$4000/month",48000,1,48000,48000,5,240000,"Yes",48000,266281,0,0,0,null,null,266281,506281]
["Professional Development","Training/continuing education","Estimated yearly certification ",10000,6,60000,60000,10,600000,"Yes",10000,55475,0,0,0,null,null,55475,655475]
["Salaries","System downtime","The cost to rectify unplanned/emergency downtime is about $4,000 per incident. Company ABC experiences this about once a year with its current infrastructure. ",4000,1,4000,4000,10,40000,"Yes",4000,22190,0,0,0,null,null,22190,62190]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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":504},null,{"$f":"SUM($F134:$F158)","v":19215},null,null,{"$f":"SUM($I134:$I158)","v":19215},null,null,{"$f":"SUM($L134:$L158)","v":0},null,null,{"$f":"SUM($O134:$O158)","v":19046.771148901556},null,null,{"$f":"SUM($R134:$R158)","v":19047},{"$f":"SUM($S134:$S158)","v":38262}]
[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}]
["Installation & Setup","Installation - server upgrades, year 5","Time and labor for infrastructure upgrades - about 3h per server = $63/hr; about $189 in labor costs per server. 20 server upgrades projected in year 5. See \"Ad Hoc Additions\"",189,20,3780,null,null,3780,"No",null,0,20,5,4193.9235569287994,null,null,4194,7974]
["Installation & Setup","Installation - switch upgrades, year 5","Time and labor for infrastructure upgrades - about 2h per switch = $126 in labor costs per switch. 6 switch upgrades projected in year 5. See \"Ad Hoc Additions\"",126,12,1512,null,null,1512,"No",null,0,6,5,838.78471138575981,null,null,839,2351]
["Installation & Setup","Installation - access point upgrades, year 3","Time and labor for infrastructure upgrades - about 2h per access point = about $126 in labor costs per switch. 12 AP upgrades projected in year 3. See \"Ad Hoc Additions\"",126,18,2268,null,null,2268,"No",null,0,12,3,1609.2703786319994,null,null,1609,3877]
["Installation & Setup","Installation - set up new employee devices ","Projecting 150 new laptops in year 3; 35 new laptops in year 3. About 1h per device setup at $63 per hour.",63,185,11655,null,null,11655,"No",null,0,185,3,12404.792501954997,null,null,12405,24060]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,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":"Cloud Alternative"},{"$f":"'Reference Formulas'!Q7","v":5529438},"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":9000},null,{"$f":"SUM(F$4:F$28)","v":28000},null,null,{"$f":"SUM($I4:$I28)","v":45600},null,null,{"$f":"SUM($L4:$L28)","v":24409},null,null,{"$f":"SUM($O4:$O28)","v":3192.9967829999991},null,null,{"$f":"SUM($R4:$R28)","v":27602},{"$f":"SUM($S4:$S28)","v":73202}]
[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}]
["Servers","Servers","No longer needed",0,0,0,0,0,0,"No",null,0,0,0,0,null,null,0,0]
["Software and Licensing","Server software","No longer needed",0,0,0,0,0,0,"No",null,0,0,0,0,null,null,0,0]
["Servers","Server rack ","No longer needed",0,0,0,0,0,0,"No",null,0,0,0,0,null,null,0,0]
["Networking Equipment","Switches","No longer needed",0,0,0,0,0,0,"No",null,0,0,0,0,null,null,0,0]
["Networking Equipment","Access points",null,500,18,9000,0,5,9000,"No",null,0,6,3,3192.9967829999991,null,null,3193,12193]
["Networking Equipment","Firewalls","Next-generation firewall with VPN",2500,4,10000,0,5,10000,"No",null,0,0,0,0,null,null,0,10000]
["Networking Equipment","Firewall licensing","Yearly license",1000,4,4000,4400,5,21600,"Yes",4400,24409,0,0,0,null,null,24409,46009]
["Networking Equipment","WLAN controller",null,5000,1,5000,0,0,5000,"No",null,0,0,0,0,null,null,0,5000]
["Software and Licensing","On-site backup. To upgrade in 5 years","No longer needed",0,0,0,0,0,0,"No",null,0,0,0,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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:$D41)","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}]
["Utilities","HVAC","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Rent/Mortgage","Real estate","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Insurance","Insurance","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Utilities","Power","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Utilities","Generator","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Utilities","Internet","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
["Security","Security ","No longer needed",0,0,0,null,null,0,"No",null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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:$D67)","v":3372},null,{"$f":"SUM($F56:$F67)","v":205080},null,null,{"$f":"SUM($I56:$I67)","v":540480},null,null,{"$f":"SUM($L56:$L67)","v":688336},null,null,{"$f":"SUM($O56:$O67)","v":0},null,null,{"$f":"SUM($R56:$R67)","v":688336},{"$f":"SUM($S56:$S67)","v":1228816}]
[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}]
["IT Solutions","Directory platform ","$180/user/year",180,250,45000,0,0,45000,"No",null,0,null,null,0,null,null,0,45000]
["IT Solutions","MFA ","no longer needed (provided by directory)",0,0,0,0,0,0,"No",null,0,null,null,0,null,null,0,0]
["SaaS Solutions","Office suite","$144/user/yr",144,250,36000,0,0,36000,"No",null,0,null,null,0,null,null,0,36000]
["Business Software","Finance management","Keep existing: $1080/year",1080,1,1080,1080,6,6480,"Yes",1080,5991,null,null,0,null,null,5991,12471]
["Business Software","HR platform","Keep existing: $168/user/yr",168,250,42000,42000,5,210000,"Yes",42000,232996,null,null,0,null,null,232996,442996]
["SaaS Solutions","CRM","Keep existing: $1800/user/yr. 45 licenses: sales + execs",1800,45,81000,81000,3,243000,"Yes",81000,449349,null,null,0,null,null,449349,692349]
["IT Solutions","MDM","no longer needed (provided by directory)",0,0,0,0,0,0,"No",null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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":2220},null,{"$f":"SUM($F82:$F106)","v":335700},null,null,{"$f":"SUM($I82:$I106)","v":365100},null,null,{"$f":"SUM($L82:$L106)","v":81549},null,null,{"$f":"SUM($O82:$O106)","v":217953.9604075799},null,null,{"$f":"SUM(R$82:R$106)","v":299503},{"$f":"SUM($S82:$S106)","v":664603}]
[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}]
["Laptops","Laptops","Most laptops will need an upgrade in about 4 years - inflation calculator used",1200,250,300000,0,5,300000,"No",null,0,150,4,195602.98292657989,null,null,195603,495603]
["Smartphones","Smart phones","Android phones for sales and executives (35 employees)",600,35,21000,0,3,21000,"No",null,0,35,3,22350.977480999994,null,null,22351,43351]
["Data plans","Data plan for phones","Verizon: $35/line/mo; $420/line/year",420,35,14700,{"$f":"F85","v":14700},3,44100,"Yes",14700,81549,0,0,0,null,null,81549,125649]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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:$D119)","v":208000},null,{"$f":"SUM($F108:$F119)","v":268000},null,null,{"$f":"SUM($I108:$I119)","v":2128000},null,null,{"$f":"SUM($L108:$L119)","v":1386880},null,null,{"$f":"SUM($O108:$O119)","v":0},null,null,{"$f":"SUM($R108:$R119)","v":1386880},{"$f":"SUM(S$108:S$119)","v":3514880}]
[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}]
["Salaries","Maintenance/configuration/support","About 1/5 of IT team's time attributed to maintenance/configuration/support.\nSalaries:\nIT Director: $180,000\nNetwork Security Officer: $160,000\n4 IT Admins: $130,000\nTotal per year: $860,000/yr\n*.2 = $172,000/yr\n(Average past recurring accounts for inflation/raises)",172000,1,172000,172000,10,1720000,"Yes",172000,954173,null,null,0,null,null,954173,2674173]
["Consulting Services","MSP fees","Reduced: $2,000/month",24000,1,24000,48000,5,216000,"Yes",48000,266281,null,null,0,null,null,266281,482281]
["Professional Development","Training/continuing education","Reduced: fewer certifications needed. ",12000,6,72000,30000,5,192000,"Yes",30000,166426,null,null,0,null,null,166426,358426]
["Salaries","System downtime","With cloud-based infrastructure, Company ABC isn't responsible for rectifying downtime; their cloud service provider guarantees a 99.99% uptime SLA. ",0,0,0,0,0,0,"Yes",null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,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:$D146)","v":20189},null,{"$f":"SUM($F134:$F146)","v":13923},null,null,{"$f":"SUM($I134:$I146)","v":13923},null,null,{"$f":"SUM($L134:$L146)","v":0},null,null,{"$f":"SUM($O134:$O146)","v":34014.062880586993},null,null,{"$f":"SUM($R134:$R146)","v":34014},{"$f":"SUM($S134:$S146)","v":47937}]
[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}]
["Installation & Setup","Solution implementation","Company ABC doesn't need to implement cloud infrastructure.",0,0,0,0,0,0,null,null,0,0,0,0,null,null,0,0]
["Installation & Setup","Installation - access point upgrades, year 3","Time and labor for infrastructure upgrades - about 2h per access point = about $126 in labor costs per switch. 12 AP upgrades projected in year 3. See \"Ad Hoc Additions\"",126,18,2268,0,0,2268,null,null,0,12,3,1609.2703786319994,null,null,1609,3877]
["Installation & Setup","Installation - set up new employee devices ","Projecting 150 new laptops in year 3; 35 new laptops in year 3. About 1h per device setup at $63 per hour.",63,185,11655,0,0,11655,null,null,0,185,3,12404.792501954997,null,null,12405,24060]
["Training","New solution training","Company ABC will take advantage of a training package offered by the new vendor to get their people accustomed to the new technology",20000,0,0,0,0,0,"No",null,0,1,0,20000,null,null,20000,20000]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,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":3093103},"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:$D15)","v":0},null,{"$f":"SUM(F$4:F$15)","v":0},null,null,{"$f":"SUM($I4:$I15)","v":0},null,null,{"$f":"SUM($L4:$L15)","v":0},null,null,{"$f":"SUM($O4:$O15)","v":0},null,null,{"$f":"SUM($R4:$R15)","v":0},{"$f":"SUM($S4:$S15)","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: Existing Infrastructure vs Cloud Alternative"}]
[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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":115225},{"$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":358996},{"$f":"'Reference Formulas'!$AA15","v":45000},{"$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":6747623},{"$f":"'Reference Formulas'!$AA24","v":2674173},{"$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":188337},{"$f":"'Reference Formulas'!$AA7","v":73202},{"$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":12471},{"$f":"'Reference Formulas'!$AA16","v":728349},{"$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":506281},{"$f":"'Reference Formulas'!$AA25","v":482281},{"$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":128680},{"$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":2208124},{"$f":"'Reference Formulas'!$AA17","v":455467},{"$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":655475},{"$f":"'Reference Formulas'!$AA26","v":358426},{"$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":432242},{"$f":"'Reference Formulas'!F$6","v":73202},{"$f":"'Reference Formulas'!G$6","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$8","v":2579591},{"$f":"'Reference Formulas'!F$8","v":1228816},{"$f":"'Reference Formulas'!G$8","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!E$10","v":7909379},{"$f":"'Reference Formulas'!F$10","v":3514880},{"$f":"'Reference Formulas'!G$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":186570},{"$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":491580},{"$f":"'Reference Formulas'!$AA19","v":495603},{"$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":38262},{"$f":"'Reference Formulas'!$AA28","v":27937},{"$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":8936},{"$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":43351},{"$f":"'Reference Formulas'!$AA20","v":43351},{"$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":658510},{"$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":125649},{"$f":"'Reference Formulas'!$AA21","v":125649},{"$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":20000},{"$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":11321},{"$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":38262},{"$f":"'Reference Formulas'!F$11","v":47937},{"$f":"'Reference Formulas'!G$11","v":0}]
[null,null,null,{"$f":"'Reference Formulas'!$Q6","v":12485391},{"$f":"'Reference Formulas'!$Q7","v":5529438},{"$f":"'Reference Formulas'!$Q8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!E$7","v":865337},{"$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":660580},{"$f":"'Reference Formulas'!F$9","v":664603},{"$f":"'Reference Formulas'!G$9","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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: Existing Infrastructure vs Cloud Alternative"}]
[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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":55475},{"$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":232996},{"$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":2407623},{"$f":"'Reference Formulas'!$AD24","v":954173},{"$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":70737},{"$f":"'Reference Formulas'!$AD7","v":27602},{"$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":5991},{"$f":"'Reference Formulas'!$AD16","v":449349},{"$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":266281},{"$f":"'Reference Formulas'!$AD25","v":266281},{"$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":67680},{"$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":1065124},{"$f":"'Reference Formulas'!$AD17","v":238987},{"$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":55475},{"$f":"'Reference Formulas'!$AD26","v":166426},{"$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":193892},{"$f":"'Reference Formulas'!N$6","v":27602},{"$f":"'Reference Formulas'!O$6","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$8","v":1304111},{"$f":"'Reference Formulas'!N$8","v":688336},{"$f":"'Reference Formulas'!O$8","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$10","v":2729379},{"$f":"'Reference Formulas'!N$10","v":1386880},{"$f":"'Reference Formulas'!O$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},"Cost Compare",null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":66570},{"$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":191580},{"$f":"'Reference Formulas'!$AD19","v":195603},{"$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":19047},{"$f":"'Reference Formulas'!$AD28","v":14014},{"$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":2996},{"$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":22351},{"$f":"'Reference Formulas'!$AD20","v":22351},{"$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":199710},{"$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":81549},{"$f":"'Reference Formulas'!$AD21","v":81549},{"$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":20000},{"$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":8321},{"$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":4819506},{"$f":"'Reference Formulas'!$Q12","v":2436335},{"$f":"'Reference Formulas'!$Q13","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!M$7","v":277597},{"$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":295480},{"$f":"'Reference Formulas'!N$9","v":299503},{"$f":"'Reference Formulas'!O$9","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Formulas'!M$11","v":19047},{"$f":"'Reference Formulas'!N$11","v":34014},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$f":"'Reference Formulas'!$C$8","v":0},null,null,null,null,null,{"$f":"'Reference Formulas'!$C$6","v":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"'Reference Formulas'!$C$7","v":"Cloud Alternative"},{"$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: Existing Infrastructure"}]
[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: Existing Infrastructure"}]
[]
[null,null,{"$f":"'Reference Formulas'!Q9","v":7665885},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":238350},{"$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":587740},{"$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":1275480},{"$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":365100},{"$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":5180000},{"$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":19215},{"$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":"Existing Infrastructure"}]
[null,null,{"$f":"'Reference Formulas'!Q6","v":12485391}]
[]
[]
[]
[]
["© 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":"Existing Infrastructure"},{"$f":"$C$7","v":"Cloud Alternative"},{"$f":"$C$8","v":0},"Past/YTD TCO Totals:",{"$f":"$C$6","v":"Existing Infrastructure"},{"$f":"$C$7","v":"Cloud Alternative"},{"$f":"$C$8","v":0},"Future TCO Totals:",{"$f":"$C$6","v":"Existing Infrastructure"},{"$f":"$C$7","v":"Cloud Alternative"},{"$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":"Existing Infrastructure"},{"$f":"$C$7","v":"Cloud Alternative"},{"$f":"$C$8","v":0},{"$f":"$C$6","v":"Existing Infrastructure"},{"$f":"$C$7","v":"Cloud Alternative"},{"$f":"$C$8","v":0}]
["Infrastructure Equipment","Option 1",{"$f":"'Template Instructions'!$F$17","v":"Existing Infrastructure"},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$S$3","v":432242},{"$f":"'Option 2'!$S$3","v":73202},{"$f":"'Option 3'!$S$3","v":0},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$I$3","v":238350},{"$f":"'Option 2'!$I$3","v":45600},{"$f":"'Option 3'!$I$3","v":0},{"$f":"$A$6","v":"Infrastructure Equipment"},{"$f":"'Option 1'!$R$3","v":193892},{"$f":"'Option 2'!$R$3","v":27602},{"$f":"'Option 3'!$R$3","v":0},"Lifetime | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($E$6:$E$11)","v":12485391},"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":115225},{"$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":55475},{"$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":"Cloud Alternative"},{"$f":"$A$7","v":"Data Center and Hosting Costs"},{"$f":"'Option 1'!$S$29","v":865337},{"$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":587740},{"$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":277597},{"$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":5529438},"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":188337},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$7,'Option 2'!$S$4:$S$28)","v":73202},{"$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":70737},{"$f":"SUMIF('Option 2'!$A$4:$A$28,$Y$7,'Option 2'!$R$4:$R$28)","v":27602},{"$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":2579591},{"$f":"'Option 2'!$S$55","v":1228816},{"$f":"'Option 3'!$S$55","v":0},{"$f":"$A$8","v":"Software and Applications"},{"$f":"'Option 1'!$I$55","v":1275480},{"$f":"'Option 2'!$I$55","v":540480},{"$f":"'Option 3'!$I$55","v":0},{"$f":"$A$8","v":"Software and Applications"},{"$f":"'Option 1'!$R$55","v":1304111},{"$f":"'Option 2'!$R$55","v":688336},{"$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":128680},{"$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":67680},{"$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":660580},{"$f":"'Option 2'!$S$81","v":664603},{"$f":"'Option 3'!$S$81","v":0},{"$f":"$A$9","v":"Employee Devices and Hardware"},{"$f":"'Option 1'!$I$81","v":365100},{"$f":"'Option 2'!$I$81","v":365100},{"$f":"'Option 3'!$I$81","v":0},{"$f":"$A$9","v":"Employee Devices and Hardware"},{"$f":"'Option 1'!$R$81","v":295480},{"$f":"'Option 2'!$R$81","v":299503},{"$f":"'Option 3'!$R$81","v":0},"Past | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($I$6:$I$11)","v":7665885},"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":7909379},{"$f":"'Option 2'!$S$107","v":3514880},{"$f":"'Option 3'!$S$107","v":0},{"$f":"$A$10","v":"Personnel and Support"},{"$f":"'Option 1'!$I$107","v":5180000},{"$f":"'Option 2'!$I$107","v":2128000},{"$f":"'Option 3'!$I$107","v":0},{"$f":"$A$10","v":"Personnel and Support"},{"$f":"'Option 1'!$R$107","v":2729379},{"$f":"'Option 2'!$R$107","v":1386880},{"$f":"'Option 3'!$R$107","v":0},"Past | Total Cost Chart | Option 2 | Total Cost Summation",{"$f":"SUM($J$6:$J$11)","v":3093103},"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":186570},{"$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":66570},{"$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":38262},{"$f":"'Option 2'!$S$133","v":47937},{"$f":"'Option 3'!$S$133","v":0},{"$f":"$A$11","v":"Rollout"},{"$f":"'Option 1'!$I$133","v":19215},{"$f":"'Option 2'!$I$133","v":13923},{"$f":"'Option 3'!$I$133","v":0},{"$f":"$A$11","v":"Rollout"},{"$f":"'Option 1'!$R$133","v":19047},{"$f":"'Option 2'!$R$133","v":34014},{"$f":"'Option 3'!$R$133","v":0},"Future | Total Cost Chart | Option 1 | Total Cost Summation",{"$f":"SUM($M$6:$M$11)","v":4819506},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":8936},{"$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":2996},{"$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":2436335},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":658510},{"$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":199710},{"$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":11321},{"$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":8321},{"$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":358996},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$15,'Option 2'!$S$56:$S$67)","v":45000},{"$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":232996},{"$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":12471},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$16,'Option 2'!$S$56:$S$67)","v":728349},{"$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":5991},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$16,'Option 2'!$R$56:$R$67)","v":449349},{"$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":2208124},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$17,'Option 2'!$S$56:$S$67)","v":455467},{"$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":1065124},{"$f":"SUMIF('Option 2'!$A$56:$A$67,$Y$17,'Option 2'!$R$56:$R$67)","v":238987},{"$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":7665885},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":491580},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$19,'Option 2'!$S$82:$S$106)","v":495603},{"$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":191580},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$19,'Option 2'!$R$82:$R$106)","v":195603},{"$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":"(126% over 5 years)"},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":43351},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$20,'Option 2'!$S$82:$S$106)","v":43351},{"$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":22351},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$20,'Option 2'!$R$82:$R$106)","v":22351},{"$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":"(148% over 5 years)"},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":125649},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$21,'Option 2'!$S$82:$S$106)","v":125649},{"$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":81549},{"$f":"SUMIF('Option 2'!$A$82:$A$106,$Y$21,'Option 2'!$R$82:$R$106)","v":81549},{"$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":"(98% over 5 years)"},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: Existing Infrastructure"},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":6747623},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$24,'Option 2'!$S$108:$S$119)","v":2674173},{"$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":2407623},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$24,'Option 2'!$R$108:$R$119)","v":954173},{"$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":506281},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$25,'Option 2'!$S$108:$S$119)","v":482281},{"$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":266281},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$25,'Option 2'!$R$108:$R$119)","v":266281},{"$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: Existing Infrastructure vs Cloud Alternative"},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":655475},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$26,'Option 2'!$S$108:$S$119)","v":358426},{"$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":55475},{"$f":"SUMIF('Option 2'!$A$108:$A$119,$Y$26,'Option 2'!$R$108:$R$119)","v":166426},{"$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: Existing Infrastructure vs Cloud Alternative"},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":38262},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$28,'Option 2'!$S$134:$S$146)","v":27937},{"$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":19047},{"$f":"SUMIF('Option 2'!$A$134:$A$146,$Y$28,'Option 2'!$R$134:$R$146)","v":14014},{"$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":20000},{"$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":20000},{"$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}]