{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["ROI Analysis 1","Fixed Labor Expenses ","Variable Labor Expenses","Office Rental-Depreciation","Marketing-Advertising","Hardware-Software","Developmental Tools","Training"],"not_rendered":{"external_links":1,"defined_names":1,"comments":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ROI Analysis 1","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[6,0,6,5],[19,0,19,5],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,4,31,4],[30,5,31,5]],"flags":["formulas_cached_only"]}
[null,"Template 2-2","Project Candidate ROI Analysis"]
[]
[null,"Candidate 1","Candidate 2","Candidate 3","Candidate 4","Candidate 5"]
[]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web"]
[]
["Forecasted Project Expenses"]
[]
["Fixed labor expenses (marketing, analysts, developers, etc.)",{"v":1130000,"d":"$1,130,000"},{"v":1150000,"d":"$1,150,000"},{"v":1250000,"d":"$1,250,000"}]
["Variable labor expenses (third-party consultants, clerical, etc.)",{"v":245000,"d":"$245,000"},{"v":275000,"d":"$275,000"},{"v":225000,"d":"$225,000"}]
["Office space rental/depreciation",{"v":35000,"d":"$35,000"},{"v":45000,"d":"$45,000"},{"v":55000,"d":"$55,000"}]
["Marketing and advertising costs",{"v":35000,"d":"$35,000"},{"v":45000,"d":"$45,000"},{"v":30000,"d":"$30,000"}]
["Hardware and third-party software expenses",{"v":70000,"d":"$70,000"},{"v":80000,"d":"$80,000"},{"v":75000,"d":"$75,000"}]
["Development tool expenses",{"v":100000,"d":"$100,000"},{"v":125000,"d":"$125,000"},{"v":350000,"d":"$350,000"}]
["Training",{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":250000,"d":"$250,000"}]
[]
["Total Forecasted Expenses",{"v":1565000,"d":"$1,565,000"},{"v":1650000,"d":"$1,650,000"},{"v":1885000,"d":"$1,885,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[]
["Forcasted Project Revenues"]
[]
["Software sales",{"v":1500000,"d":"$1,500,000"},{"v":1300000,"d":"$1,300,000"},{"v":1200000,"d":"$1,200,000"}]
["Consulting implementation and training engagements",{"v":50000,"d":"$50,000"},{"v":40000,"d":"$40,000"},{"v":37500,"d":"$37,500"}]
["Maintenance and technical support packages",{"v":150000,"d":"$150,000"},{"v":130000,"d":"$130,000"},{"v":120000,"d":"$120,000"}]
[]
["Total Forcasted Revenues",{"v":1700000,"d":"$1,700,000"},{"v":1470000,"d":"$1,470,000"},{"v":1357500,"d":"$1,357,500"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[]
["Forecasted Revenue - Forecasted Expenses",{"v":135000,"d":"$135,000"},{"v":-180000,"d":"-$180,000"},{"v":-527500,"d":"-$527,500"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Forecasted Expenses",{"v":1565000,"d":"$1,565,000"},{"v":1650000,"d":"$1,650,000"},{"v":1885000,"d":"$1,885,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["ROI (%) = (Revenue - Expenses) / Expenses",{"v":0.08626198083067092,"d":"8.63%"},{"v":-0.10909090909090909,"d":"-10.91%"},{"v":-0.27984084880636606,"d":"-27.98%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]

{"sheet":"Fixed Labor Expenses ","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Fixed Labor Expenses Details"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
[]
["Marketing"]
["Analysts"]
["Developers"]
{"$rows_empty":13}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Variable Labor Expenses","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Variable Labor Expenses"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
["Third party consultants"]
["Clerical"]
{"$rows_empty":15}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Office Rental-Depreciation","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Office Rental/Depreciation Worksheet"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
{"$rows_empty":17}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Marketing-Advertising","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Marketing/Advertising Cost Worksheet"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
{"$rows_empty":17}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Hardware-Software","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Hardware/3rd-Party Software Worksheet"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
{"$rows_empty":17}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Developmental Tools","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Developmental Tool Expenses"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
{"$rows_empty":17}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]

{"sheet":"Training","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Training Expenses"]
["Project name","Customer Self-Service Web","Calandar Self-Service Web","Project Management Self-Service Web",0,0]
{"$rows_empty":17}
["Totals",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]