{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["1-Summary","2-Software OnPrem","2-Software SaaS","3-Services","4-Other","5-Milestone Payments"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"1-Summary","index":0,"n_rows":15,"n_cols":5,"rows_kept":15}
["Attachment 11 - Cost"]
["Vendor: "]
["City of Myrtle Beach"]
["NOTE TO PROPOSERS:  IF PROVIDING COST INFORMATION FOR ON PREMISE AND SAAS, PROVIDE ON TWO SEPARATE COST SPREADSHEETS"]
["Cost Categories","Total Cost","Scope Option #2","Total Costs","Explanation/Notes (if necessary)"]
["Project Costs"]
["Software Fees (Schedule 2) ",{"$f":"'2-Software OnPrem'!E29+'2-Software SaaS'!E28","v":0},{"$f":"'2-Software OnPrem'!E51","v":0},{"$f":"B7+C7","v":0}]
["Professional Services (Schedules 3):  ",{"$f":"'3-Services'!C40","v":0},{"$f":"'3-Services'!C79","v":0},{"$f":"B8+C8","v":0}]
["Other Fees (Schedule 4)",{"$f":"'4-Other'!B21","v":0},{"$f":"'4-Other'!C21","v":0},0]
["Maintenance (year 1) (Schedule 2)",{"$f":"SUM('2-Software OnPrem'!F29,'2-Software OnPrem'!H29,'2-Software SaaS'!F28)","v":0}]
["Total Cost During Project Period",{"$f":"SUM(B7:B10)","v":0},{"$f":"SUM(C7:C9)","v":0},0]
["Ongoing Costs"]
["2-4 Year Maintenance Costs",{"$f":"SUM('2-Software OnPrem'!G29,'2-Software OnPrem'!I29)","v":0},{"$f":"'2-Software OnPrem'!F51+'2-Software OnPrem'!G51","v":0},0]
["2-4 Year SaaS Costs",{"$f":"'2-Software SaaS'!G28","v":0},{"$f":"'2-Software OnPrem'!#REF!+'2-Software OnPrem'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Total 5 Year Costs",{"$f":"B11+B13+B14","v":0}]

{"sheet":"2-Software OnPrem","index":1,"n_rows":52,"n_cols":9,"rows_kept":52,"merged":[[3,5,3,6],[3,7,3,8]]}
["Schedule 2: Software Fees"]
[{"$f":"'1-Summary'!A2","v":"Vendor: "},{"$f":"'1-Summary'!B2","v":0}]
[]
[{"$nulls":5},"On Premise",null,"Hosted"]
["MODULE NAME","FUNCTION","ACCESS LIMITATIONS (CONCURRENT USERS, NAMED USERS, CPU, ENTERPRISE)","QUANTITY PROPOSED","INITIAL COST","MAINTENANCE YEAR 1 COST","MAINTENANCE YEAR 2-5 COST (provide total for 4 years)","MAINTENANCE YEAR 1 COST","MAINTENANCE YEAR 2-5 COST (provide total for remaining 4 yrs)"]
[]
["Financial"]
{"$rows_empty":21}
[{"$nulls":4},{"$f":"SUM(E7:E28)","v":0},{"$f":"SUM(F7:F28)","v":0},{"$f":"SUM(G7:G28)","v":0},{"$f":"SUM(H7:H28)","v":0},{"$f":"SUM(I7:I28)","v":0}]
["Total"]
[]
[]
["Scope Option #2","FUNCTION","ACCESS LIMITATIONS (CONCURRENT USERS, NAMED USERS, CPU, ENTERPRISE)","QUANTITY PROPOSED","INITIAL COST","MAINTENANCE YEAR 1 COST","MAINTENANCE YEAR 2-5 COST"]
["MODULE NAME"]
{"$rows_empty":16}
[{"$nulls":3},{"$f":"SUM(D35:D50)","v":0},{"$f":"SUM(E35:E50)","v":0},{"$f":"SUM(F35:F50)","v":0},{"$f":"SUM(G35:G50)","v":0}]
["Total"]

{"sheet":"2-Software SaaS","index":2,"n_rows":51,"n_cols":7,"rows_kept":51}
["Schedule 2: Software Fees"]
[{"$f":"'1-Summary'!A2","v":"Vendor: "},{"$f":"'1-Summary'!B2","v":0}]
[]
["MODULE NAME","FUNCTION","ACCESS LIMITATIONS (CONCURRENT USERS, NAMED USERS, CPU, ENTERPRISE)","QUANTITY PROPOSED","INITIAL COST                (if appropriate / different than SaaS cost)","SAAS / MANAGED SERVICES YEAR 1 COST","SAAS / MANAGED SERVICES YEAR 2-5 COST                    (provide total for remaining 4 yrs)"]
[]
["Finance","General Ledger"]
{"$rows_empty":21}
[{"$nulls":4},{"$f":"SUM(E6:E27)","v":0},{"$f":"SUM(F6:F27)","v":0},{"$f":"SUM(G6:G27)","v":0}]
["Total"]
[]
[]
["Scope Option #2","FUNCTION","ACCESS LIMITATIONS (CONCURRENT USERS, NAMED USERS, CPU, ENTERPRISE)","QUANTITY PROPOSED","INITIAL COST","HOSTING /SAAS / MANAGED SERVICES YEAR 1 COST","HOSTING /SAAS / MANAGED SERVICES YEAR 2-5 COST"]
["MODULE NAME"]
{"$rows_empty":16}
[{"$nulls":3},{"$f":"SUM(D34:D49)","v":0},{"$f":"SUM(E34:E49)","v":0},{"$f":"SUM(F34:F49)","v":0},{"$f":"SUM(G34:G49)","v":0}]
["Total"]

{"sheet":"3-Services","index":3,"n_rows":79,"n_cols":5,"rows_kept":79}
["Schedule 3: Professional Service Fees"]
[{"$f":"'1-Summary'!A2","v":"Vendor: "},{"$f":"'1-Summary'!B2","v":0}]
[]
["DELIVERABLE / TASK","PHASE","PAYMENT AMOUNT","RETAINAGE","COMMENTS"]
["PROJECT PLANNING",null,"$","%"]
["Project Management"]
[]
[]
[]
["INITIAL KNOWLEDGE TRANSFER"]
[]
[]
[]
[]
["PROCESS ANALYSIS / SYSTEM DESIGN"]
[]
[]
[]
[]
["SYSTEM BUILD  (INCLUDING CONVERSION/CONFIGURATION/ENHANCEMENTS)"]
[]
[]
[]
[]
["TESTING"]
[]
[]
[]
[]
["TRAINING"]
[]
[]
[]
[]
["CLOSURE"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C6:C39)","v":0}]
[]
["Scope Option #2"]
["DELIVERABLE / TASK #","PHASE","PAYMENT AMOUNT","RETAINAGE","COMMENTS"]
["PROJECT PLANNING",null,"$","%"]
[]
[]
[]
[]
["INITIAL KNOWLEDGE TRANSFER"]
[]
[]
[]
[]
["PROCESS ANALYSIS / SYSTEM DESIGN"]
[]
[]
[]
[]
["SYSTEM BUILD  (INCLUDING CONVERSION/CONFIGURATION/ENHANCEMENTS)"]
[]
[]
[]
[]
["TESTING"]
[]
[]
[]
[]
["TRAINING"]
[]
[]
[]
[]
["CLOSURE"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C45:C78)","v":0}]

{"sheet":"4-Other","index":4,"n_rows":21,"n_cols":3,"rows_kept":21}
["Schedule 4: Other Fees"]
[{"$f":"'1-Summary'!A2","v":"Vendor: "},{"$f":"'1-Summary'!B2","v":0}]
[]
["Description","Cost","Scope Option #2 Cost"]
{"$rows_empty":16}
["Total",{"$f":"SUM(B6:B20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C6:C20)","v":{"v":0,"d":"$0"}}]

{"sheet":"5-Milestone Payments","index":5,"n_rows":22,"n_cols":8,"rows_kept":22}
["Payment Schedule",{"$nulls":3},"Retainage %",0.1]
["LIST ALL REQUIRED PAYMENTS FOR 5 YEARS "]
["Payment Number","Type","Phase ","Milestone","Amount","Retainage","Remit to Vendor","Cumulative Retainage"]
[1,{"$nulls":4},{"$f":"E4*F$1","v":0},{"$f":"E4-F4","v":0},{"$f":"E4-G4","v":0}]
[2,{"$nulls":4},{"$f":"E5*F$1","v":0},{"$f":"E5-F5","v":0},{"$f":"H4+(E5-G5)","v":0}]
[3,{"$nulls":4},0,{"$f":"E6-F6","v":0},{"$f":"H5+(E6-G6)","v":0}]
[4,{"$nulls":4},0,0,0]
[5,{"$nulls":4},0,0,0]
[6,{"$nulls":4},0,0,0]
[7,{"$nulls":4},0,0,0]
[8,{"$nulls":4},0,0,0]
[9,{"$nulls":4},0,0,0]
[10,{"$nulls":4},0,0,0]
[11,{"$nulls":4},0,0,0]
[12,{"$nulls":4},0,0,0]
[13,{"$nulls":4},0,0,0]
[14,{"$nulls":4},0,0,0]
[15,{"$nulls":4},0,0,0]
[16,{"$nulls":4},0,0,0]
[17,{"$nulls":4},0,0,0]
["Add More if Necessary",{"$nulls":4},0,{"$f":"E21-F21","v":0},0]
["Final",null,null,"Project Close and Acceptance (Release)",null,0,null,0]