{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Definition","Compliance Template","Working Holidays","Capped Rates","Discount Structure"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":30,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Standard commercial framework compliance checklist"]
[null,"This compliance checklist verifies whether the proposal is compliant with the standard commercial framework. "]
[]
[null,"To use this checklist, please follow these steps:"]
[null,"Step 1. Use this tool only for engagement types in the \"Definition\" sheet"]
[null,"Step 2. Select the pricing model applicable."]
[null,"Step 3. Enter estimated engagement start and end dates in the following format DD/MM/YY."]
[null,"Step 4. Provide the list of proposed resouces specifying: resource type, daily rate, and estimated working days."]
[null,"Step 5. Provide additional discount rate as % if applicable."]
[null,"Step 6. Input estimated expenses."]
[]
[]
[null,"Tips: \n1. All manual inputs fields are highlighed in yellow.\n2. Ensure macros are enabled within this workbook.\n3. The form will not allow daily rates and estimated expenses exceeding the caps in the standard commercial framework.\n4. Engagement start and end dates are limited between 6/1/2020 - 31/12/2029."]
[]
[null,"For further assistance/enquiries with this form, please contact NSW Procurement Service Centre on:\n1800 679 289 or email nswbuy@finance.nsw.gov.au"]

{"sheet":"Definition","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,7],[2,1,18,7],[19,2,19,3],[19,4,19,7],[20,1,26,1],[20,2,20,3],[20,4,20,7],[21,2,21,3],[21,4,21,7],[25,2,25,3],[25,4,25,7],[26,2,26,3],[26,4,26,7],[22,2,22,3],[22,4,22,7],[23,2,23,3],[23,4,23,7],[24,2,24,3],[24,4,24,7]]}
["ICT CONSULTING"]
[null,"Inscope category and role definition"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Consulting Engagement Type","Consulting Service Type",null,"Description"]
[null,"ICT Consulting","ICT Strategy, Planning and Design",null,"Align technology with business goals; conduct internal capability and external benchmark analysis; identify gap and provide suggestions; develop strategic objectives and technology roadmaps; create integrated technology designs that support business needs.\n"]
[null,null,"ICT Risk Management, Compliance and Security",null,"Conduct assessments on ICT threats such as fraud, security and spam etc.; outline the risks, identify gaps and provide mitigation recommendations to reduce risks; develop long term roadmaps on improving ICT compliance / security.\n "]
[null,null,"ICT Policy",null,"Develop specific ICT policies and governance structures that are aligned with the overall ICT strategy & vision statement; improves efficiency and sustainability."]
[null,null,"ICT Audits",null,"Perform examination and evaluation of ICT infrastructure, policies and operations; determines whether IT controls protect corporate assets, ensures data integrity and are aligned with business' overall goals. (Including software compliance audit)."]
[null,null,"ICT Change Management",null,"Provide advice that standardised methods and procedures required for efficient and prompt handling of all changes to control IT infrastructure; ensure changes are managed and timely communicated with stakeholders to optimise risk exposure and minimise impact and disruption."]
[null,null,"ICT Project Management",null,"Provide service to plan, organise, lead and control the development / implementation / testing / optimisation of an IT solution and ensure project timely delivery, resources and budget."]
[null,null,"ICT Training and Development",null,"Organise and facilitate learning and development. Expedite acquisition of the knowledge, skills, and abilities required for effective job performance."]

{"sheet":"Compliance Template","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,1,28,4],[25,1,25,2],[5,1,5,4],[6,1,6,2],[6,3,6,4],[26,1,26,2],[26,3,26,4],[21,1,21,2],[1,2,1,4],[2,2,4,4],[0,3,0,4],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[7,1,8,2],[9,1,9,2]],"read":"row_number_cap"}
[null,null,null,"Definition"]
[null,null,"Supplier - engagement compliance checklist for standard commercial framework"]
[null,null,"Suppliers to complete and attach this checklist when submitting proposals for engagement types in the \"Definition\" sheet to ensure that the commercial framework requirements have been met."]
[]
[]
[null,"Capped Rate Description : ICT CONSULTING"]
[null,"Pricing model",null,"Timeframe"]
[null,null,null,"Start Date\n(DD/MM/YY)"]
[null,null,null,"End Date\n(DD/MM/YY)"]
[null,null,null,"Duration1 \n(working days)",{"$f":"IF(E8=\"\",\"\",IF(NETWORKDAYS(E8,E9)<0,0,NETWORKDAYS(E8,E9,'Working Holidays'!B2:M10)))","v":""}]
[null,"Resource Types","Daily rate (ex GST) ","Estimated days\n(1 day = 8 hrs)","Total costs \n(ex GST)"]
[]
[null,null,null,null,{"$f":"D13*C13","v":0}]
[null,null,null,null,{"$f":"D14*C14","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"$C$21*$D$21","v":0}]
[null,"Total estimated days2|Total costs:",null,{"$f":"SUM(INDIRECT(\"D13:D\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"E13:E\"&ROW()-1))","v":0}]
[]
[null,"Discount structure (%)",{"$f":"IF('Capped Rates'!$C$4=\"TRUE\",10%,VLOOKUP(E22,'Discount Structure'!A10:C14,2,TRUE))","v":0},"Additional discount (%)\n(If applicable)"]
[null,"Maximum expenses estimated**\n(ex GST)",null,"Total Discount $\n(ex GST)",{"$f":"IF(C24=\"\",(E22*(E24)),(E22*(C24+E24)))","v":0}]
[null,"**Expenses are capped at 7% of total engagement cost after discount",null,"Total engagement cost\nafter discount\n(ex GST)",{"$f":"E22-E25","v":0}]
[null,"Estimated engagement cost after discounts and expenses (ex GST)",null,{"$f":"E26+C25","v":0}]
[]
[null,"Internal (client) sign-off"]
[null,"Name",null,"Role"]
[null,"Signature",null,"Date"]

{"sheet":"Working Holidays","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Description",2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["New Years Day","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01"]
["Australia Day","2018-01-26","2019-01-28","2020-01-27","2021-01-26","2022-01-26","2023-01-26","2024-01-26","2025-01-27","2026-01-26","2027-01-26","2028-01-26","2029-01-26"]
["Good Friday","2018-03-30","2019-04-19","2020-04-10","2021-04-02","2022-04-15","2023-04-07","2024-03-29","2025-04-18","2026-04-03","2027-03-26","2028-04-14","2029-03-30"]
["Easter Monday","2018-04-02","2019-04-22","2020-04-13","2021-04-05","2022-04-18","2023-04-10","2024-04-01","2025-04-21","2026-04-06","2027-03-29","2028-04-17","2029-04-02"]
["Anzac Day","2018-04-25","2019-04-25","2020-04-25","2021-04-25","2022-04-25","2023-04-25","2024-04-25","2025-04-25","2026-04-25","2027-04-25","2028-04-25","2029-04-25"]
["Queens Birthday","2018-06-11","2019-06-10","2020-06-08","2021-06-13","2022-06-13","2023-06-12","2024-06-10","2025-06-09","2026-06-08","2027-06-14","2028-06-12","2029-06-11"]
["Labour Day","2018-10-01","2019-10-07","2020-10-05","2021-10-04","2022-10-03","2023-10-02","2024-10-07","2025-10-06","2026-10-05","2027-10-04","2028-10-02","2029-10-01"]
["Christmas Day","2018-12-25","2019-12-25","2020-12-25","2021-12-25","2022-12-25","2023-12-25","2024-12-25","2025-12-25","2026-12-25","2027-12-25","2028-12-25","2029-12-25"]
["Boxing Day","2018-12-26","2019-12-26","2020-12-26","2021-12-26","2022-12-26","2023-12-26","2024-12-26","2025-12-26","2026-12-26","2027-12-26","2028-12-26","2029-12-26"]

{"sheet":"Capped Rates","index":4,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,8,0,14]]}
[null,"Index","Value",null,null,null,null,null,"Standardised NSW Government Role Type1"]
["Engagement Type",0,"ICT Consulting",null,null,null,null,null,"Partner","Director","Senior Manager","Manager","Senior Consultant","Consultant","Analyst"]
["Pricing Model",0,{"$f":"IF('Capped Rates'!B3=1, \"Fixed Price\", IF('Capped Rates'!B3=2,\"Time and materials - capped\",IF('Capped Rates'!B3=3,\"Risk/reward - outcome based\", IF('Capped Rates'!B3=4, \"Time and  materials - uncapped\"))))","v":false},null,null,null,null,"ICT Consulting",3100,2700,2400,2000,1650,1250,950]
["Secondment",0,{"$f":"IF(B4=1, \"TRUE\", \"FALSE\")","v":"FALSE"}]

{"sheet":"Discount Structure","index":5,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,1,6],[2,6,6,6]]}
[null,null,null,null,null,null,"Secondment"]
[null,1,4.0000000000001004,10,20,50]
[0,0,0,0.01,0.03,0.04,0.1]
[4,0,0,0.03,0.04,0.05]
[12,0.01,0.03,0.04,0.05,7.0000000000000007E-2]
[24,0.03,0.04,0.05,0.08,0.08]
[40,0.04,0.05,7.0000000000000007E-2,0.08,0.1]
[]
[]
[0,0]
[250000.01,0.02]
[500000.01,0.05]
[1000000.01,7.0000000000000007E-2]
[]
["2020-01-05"]