{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Project Roles","Customer Effort Estimator","Chart Support","Parameters","Template Versions"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":2,"defined_names":90,"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":"Introduction","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,4,3],[5,2,5,3],[18,2,18,3],[14,2,14,3],[13,2,13,3],[6,2,6,3],[7,2,7,3]]}
[]
[]
[]
[]
[]
[null,null,"Completing an ERP project takes a dedicated team. What roles do you need? How much time do they need to free up? And in which phase of the project do you need them?\n\nWith this tool, you’ll get an estimation of the effort in days your team will need to dedicate to your ERP project. This is a high level estimation based on the Cegeka Sure Value implementation methodology to offer you a first impression of the effort your team will need to invest in the ERP project. We have also split the number of days over the three phases we typically see in a project.\n\nOur calculation is based upon the scope/size of your project and provides an estimated overview of the effort in days you'll need on your project. Below you get an explanation of the project scope you can choose from, as well as the project phases we define. In the next sheet we zoom in on the different roles that are typically involved in an implementation."]
[]
[null,null,"  Project types: Use the color codes below to identify which description best fits your situation"]
[null,null,"Orange","Small to midsized company, local implementation, limited amount of entities and limited scope"]
[null,null,"Yellow","Midsized company with either limited scope and multiple entities or single entity and average scope"]
[null,null,"Green","Midsized to large company, either local implementation with more complex scope or average scope and multiple entities"]
[null,null,"Blue","Large size companies with multiple entities, active in multiple countries"]
[null,null,"Purple","Enterprise company, full international scope"]
[]
[null,null,"  Project phases: The Cegeka SureValue methodology distinguishes the following phases:"]
[null,null,"Analysis","During the first phase of the project, the focus is on defining the processes and requirements as well as deciding on the solution blueprint"]
[null,null,"Design & Build","In the second phase, the solution will be designed and build. This includes parametrizing, key-user training, testing, validating and documenting of the solution."]
[null,null,"Release","Finally, the solution will be integration tested, user accepted and the end-users will be trained. Go-live, hypercare and the transition to the support organization are the final steps of your ERP project."]

{"sheet":"Project Roles","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,2,13,2],[12,4,13,4],[12,3,13,3],[9,2,9,4],[20,2,22,4],[10,2,11,2],[14,2,19,2],[5,2,5,4],[7,2,7,4],[0,2,4,4],[6,2,6,4],[8,2,8,4]]}
[]
[]
[]
[]
[]
[null,null,"It's important to note that not all of the roles and responsibilities that are described in this document need to be covered by your own internal people. Based on your own situation and the capabilities within the company, you could decide to outsoure some activities. Obviously, this will have an impact on the number of days that is calculated in this sheet; on the other hand your budget will increase with expenses to third parties.\nBusiness roles typically reflect the core of your business and are therefore hard to outsource. IT-related responsibilities for example, or change and test management could more easilty be done by your implementation partner of third party.\n\nAantal key users > vrij in te vullen door klant over hoeveel mensen dat gaat. Aantal mandagen te verdelen over aantal mensen. 1 key user per domein voor blauw/groen - of zelfs 1 KU meerdere domeinen."]
[]
[null,null,"In our calculation sheet, we've grouped different roles in the following domains:\n- Management: operational project management, change management\n- Business: business process owners, key users, business anayst, process architect\n- IT: security, release & deployments, IT operations, technical architect, data migration, test management"]
[]
[null,null,"  Project Roles"]
[null,null,"Management","Project Manager","Responsible for the successful implementation of the project, from start to finish. \nProject coordination and communication"]
[null,null,null,"Change Manager","Is responsible for planning, developing, delivering, and tracking change management deliverables including communications, training, stakeholder engagement, change impact assessment, organizational readiness analysis, coaching, resistance management and change reinforcement"]
[null,null,"Business","Business Process Owner / Key user","The process owner / key-user acts throughout the project as single point of contact (SPOC) for one or more processes or process areas. \nAlthough process owner and key-user can be one and the same person, typically the process owner is the SPOC for business process analysis and requirements gathering (the WHAT and WHY during the BPSA phase), whereas the key-user becomes the SPOC for the design, build and testing (the HOW during the SD&B and Release phase).\nIf these roles are split, key-users consult and collaborate with their process owners"]
[]
[null,null,"IT","Enterprise Architect","Participates in the architectural decision taking and monitors that architectural decisions regarding the solution to be implemented contributes to achieving the vision of the organization.  \nHas knowledge of and experience with all architectural aspects and monitors the consistency and connection between those aspects"]
[null,null,null,"IT responsible","The IT Team encompasses various IT-roles responsible for the maintenance, support and operations of legacy application and may be involved in various project activities like data extractions, legacy developments, analysis and design"]
[null,null,null,"Test Manager","The Test Manager oversees the day to day managing and follow up of all testing activities. He or she is responsible for the test strategy. This strategy will set boundaries and decisions for the whole project, regardless of business units, applications under test or technical frameworks. He/she will also supervise the test plan per test campaign in alignment with the test strategy."]
[null,null,null,"Security Responsible","Is responsible for user management and determining and assigning the necessary security privileges and roles, according to the organization’s security policy."]
[null,null,null,"Documents Responsible","Is responsible for the planning, organization and coordination of the activities related to design, development and testing of document and report lay-outs"]
[null,null,null,"Data Migration Responsible","Is responsible for the planning, organization, coordination and follow-up of the activities related to data migration (data quality, extraction, transformation/mapping, data load)."]

{"sheet":"Customer Effort Estimator","index":2,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[18,5,21,6],[18,7,21,8],[6,9,6,10],[42,1,42,10],[43,1,43,10],[40,1,40,10],[41,1,41,10],[1,3,2,8],[6,7,6,8],[6,5,6,6],[6,3,6,4],[16,1,16,2],[4,1,4,2],[4,9,4,10],[18,9,21,10],[5,1,5,2],[18,1,19,2],[20,1,21,2],[4,3,4,8],[18,3,21,4]]}
[]
[null,null,null,"CUSTOMER EFFORT ESTIMATOR\n for ERP Projects",null,null,null,null,null,"Version : ",{"$f":"LOOKUP(2,1/(TabTemplateVersions[Template Version]>\"\"),TabTemplateVersions[Template Version])","v":"1.0"}]
[null,null,null,null,null,null,null,null,null,"Date :",{"$f":"LOOKUP(2,1/(TabTemplateVersions[Date]>1),TabTemplateVersions[Date])","v":"2022-06-20"}]
[]
[null,"Schedule Unit",null,"Average Duration per Phase",null,null,null,null,null,"Total Duration"]
[null,"Weeks",null,{"$f":"IF(AND(ScheduleUnit<>\"\",ProjectType<>\"\"),INDEX(TabProjectTypes[Analysis Duration Weeks],MATCH(ProjectType,TabProjectTypes[Type],0))/INDEX(TabScheduleUnits[Weeks],MATCH(ScheduleUnit,TabScheduleUnits[Unit],0)),\"\")","v":8},{"$f":"IF(ScheduleUnit<>\"\",ScheduleUnit,\"\")","v":"Weeks"},{"$f":"IF(AND(ScheduleUnit<>\"\",ProjectType<>\"\"),INDEX(TabProjectTypes[Design & Build Duration Weeks],MATCH(ProjectType,TabProjectTypes[Type],0))/INDEX(TabScheduleUnits[Weeks],MATCH(ScheduleUnit,TabScheduleUnits[Unit],0)),\"\")","v":32},{"$f":"IF(ScheduleUnit<>\"\",ScheduleUnit,\"\")","v":"Weeks"},{"$f":"IF(AND(ScheduleUnit<>\"\",ProjectType<>\"\"),INDEX(TabProjectTypes[Release Duration Weeks],MATCH(ProjectType,TabProjectTypes[Type],0))/INDEX(TabScheduleUnits[Weeks],MATCH(ScheduleUnit,TabScheduleUnits[Unit],0)),\"\")","v":8},{"$f":"IF(ScheduleUnit<>\"\",ScheduleUnit,\"\")","v":"Weeks"},{"$f":"SUM(D6,F6,H6)","v":48},{"$f":"IF(ScheduleUnit<>\"\",ScheduleUnit,\"\")","v":"Weeks"}]
[null,null,null,"ANALYSIS",null,"DESIGN & BUILD",null,"RELEASE",null,"TOTAL PROJECT"]
[null,"Project Roles","Area","Total days",{"$f":"IF(ScheduleUnit<>\"\",\"d/\"&LEFT(ScheduleUnit,LEN(ScheduleUnit)-1),\"\")","v":"d/Week"},{"$f":"D8","v":"Total days"},{"$f":"IF(ScheduleUnit<>\"\",\"d/\"&LEFT(ScheduleUnit,LEN(ScheduleUnit)-1),\"\")","v":"d/Week"},{"$f":"D8","v":"Total days"},{"$f":"IF(ScheduleUnit<>\"\",\"d/\"&LEFT(ScheduleUnit,LEN(ScheduleUnit)-1),\"\")","v":"d/Week"},{"$f":"D8","v":"Total days"},{"$f":"IF(ScheduleUnit<>\"\",\"d/\"&LEFT(ScheduleUnit,LEN(ScheduleUnit)-1),\"\")","v":"d/Week"}]
[null,{"$f":"TabProjectRoles[Role]","v":"Project Manager"},{"$f":"INDEX(TabProjectRoles[Area],MATCH($B9,TabProjectRoles[Role],0))","v":"Management"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B9,TabProjectRoles[Role],0)),\"\")","v":18},{"$f":"IF(AND(ProjectType<>\"\",ScheduleUnit<>\"\"),D9/D$6,\"\")","v":2.25},{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B9,TabProjectRoles[Role],0)),\"\")","v":54},{"$f":"IF(AND(ProjectType<>\"\",ScheduleUnit<>\"\"),F9/F$6,\"\")","v":1.6875},{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B9,TabProjectRoles[Role],0)),\"\")","v":18},{"$f":"IF(AND(ProjectType<>\"\",ScheduleUnit<>\"\"),H9/H$6,\"\")","v":2.25},{"$f":"SUM(D9,F9,H9)","v":90},{"$f":"IF(AND(ProjectType<>\"\",ScheduleUnit<>\"\"),J9/J$6,\"\")","v":1.875}]
[null,"Change Manager",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B10,TabProjectRoles[Role],0))","v":"Management"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B10,TabProjectRoles[Role],0)),\"\")","v":6},0.75,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B10,TabProjectRoles[Role],0)),\"\")","v":18},0.5625,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B10,TabProjectRoles[Role],0)),\"\")","v":6},0.75,{"$f":"SUM(D10,F10,H10)","v":30},0.625]
[null,"Architect",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B11,TabProjectRoles[Role],0))","v":"IT"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B11,TabProjectRoles[Role],0)),\"\")","v":12},1.5,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B11,TabProjectRoles[Role],0)),\"\")","v":36},1.125,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B11,TabProjectRoles[Role],0)),\"\")","v":12},1.5,60,1.25]
[null,"Business Process Owners",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B12,TabProjectRoles[Role],0))","v":"Business"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B12,TabProjectRoles[Role],0)),\"\")","v":90},11.25,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B12,TabProjectRoles[Role],0)),\"\")","v":24.75},0.7734375,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B12,TabProjectRoles[Role],0)),\"\")","v":15},1.875,129.75,2.703125]
[null,"Key Users",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B13,TabProjectRoles[Role],0))","v":"Business"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B13,TabProjectRoles[Role],0)),\"\")","v":0},0,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B13,TabProjectRoles[Role],0)),\"\")","v":180},5.625,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B13,TabProjectRoles[Role],0)),\"\")","v":60},7.5,240,5]
[null,"Data Migration",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B14,TabProjectRoles[Role],0))","v":"IT"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B14,TabProjectRoles[Role],0)),\"\")","v":9},1.125,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B14,TabProjectRoles[Role],0)),\"\")","v":54},1.6875,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B14,TabProjectRoles[Role],0)),\"\")","v":12},1.5,75,1.5625]
[null,"IT Support",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B15,TabProjectRoles[Role],0))","v":"IT"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B15,TabProjectRoles[Role],0)),\"\")","v":15},1.875,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B15,TabProjectRoles[Role],0)),\"\")","v":45},1.40625,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B15,TabProjectRoles[Role],0)),\"\")","v":15},1.875,75,1.5625]
[null,"Test Manager",{"$f":"INDEX(TabProjectRoles[Area],MATCH($B16,TabProjectRoles[Role],0))","v":"IT"},{"$f":"IF(D$17<>\"\",D$17*INDEX(TabProjectRoles[Analysis],MATCH($B16,TabProjectRoles[Role],0)),\"\")","v":0},0,{"$f":"IF(F$17<>\"\",F$17*INDEX(TabProjectRoles[Design & Build],MATCH($B16,TabProjectRoles[Role],0)),\"\")","v":36},1.125,{"$f":"IF(H$17<>\"\",H$17*INDEX(TabProjectRoles[Release],MATCH($B16,TabProjectRoles[Role],0)),\"\")","v":12},1.5,48,1]
[null,"Total",null,{"$f":"IF(ProjectType<>\"\",INDEX(TabProjectTypes[Analysis Days],MATCH(ProjectType,TabProjectTypes[Type],0)),\"\")","v":150},{"$f":"SUM(E9:E16)","v":18.75},{"$f":"IF(ProjectType<>\"\",INDEX(TabProjectTypes[Design & Build Days],MATCH(ProjectType,TabProjectTypes[Type],0)),\"\")","v":450},13.9921875,{"$f":"IF(ProjectType<>\"\",INDEX(TabProjectTypes[Release Days],MATCH(ProjectType,TabProjectTypes[Type],0)),\"\")","v":150},18.75,750,15.578125]
[]
[null,"Project Type - SELECT YOUR OPTION",null,"Define requirements, process and solution blueprint.",null,"Incremental design, build, adoption and validation of the solution.",null,"Integration test, user acceptance, training, go-live and stabilization.",null,{"$f":"_xlfn.IFNA(INDEX(TabProjectTypes[Description],MATCH(ProjectType,TabProjectTypes[Type],0)),\"\")","v":"Midsized to large company, either local implementation with more complex scope or average scope and multiple entities."}]
[]
[null,"3. Green"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"• 1 process owner and 1 key-user per domain is assumed."]
[null,"• IT Support encompasses legacy system support, security administration, documents and reports lay-out."]
[null,"• Internal legacy development or interfaces are not included."]
[null,"• Calculations based on Cegeka Sure Value implementation methodology"]

{"sheet":"Chart Support","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Role",{"$f":"'Customer Effort Estimator'!D7","v":"ANALYSIS"},{"$f":"'Customer Effort Estimator'!F7","v":"DESIGN & BUILD"},{"$f":"'Customer Effort Estimator'!H7","v":"RELEASE"}]
[{"$f":"_xlfn.ANCHORARRAY('Customer Effort Estimator'!B9)","v":"Project Manager"},{"$f":"'Customer Effort Estimator'!D9","v":18},{"$f":"'Customer Effort Estimator'!F9","v":54},{"$f":"'Customer Effort Estimator'!H9","v":18}]
["Change Manager",{"$f":"'Customer Effort Estimator'!D10","v":6},{"$f":"'Customer Effort Estimator'!F10","v":18},{"$f":"'Customer Effort Estimator'!H10","v":6}]
["Architect",{"$f":"'Customer Effort Estimator'!D11","v":12},{"$f":"'Customer Effort Estimator'!F11","v":36},{"$f":"'Customer Effort Estimator'!H11","v":12}]
["Business Process Owners",{"$f":"'Customer Effort Estimator'!D12","v":90},{"$f":"'Customer Effort Estimator'!F12","v":24.75},{"$f":"'Customer Effort Estimator'!H12","v":15}]
["Key Users",{"$f":"'Customer Effort Estimator'!D13","v":0},{"$f":"'Customer Effort Estimator'!F13","v":180},{"$f":"'Customer Effort Estimator'!H13","v":60}]
["Data Migration",{"$f":"'Customer Effort Estimator'!D14","v":9},{"$f":"'Customer Effort Estimator'!F14","v":54},{"$f":"'Customer Effort Estimator'!H14","v":12}]
["IT Support",{"$f":"'Customer Effort Estimator'!D15","v":15},{"$f":"'Customer Effort Estimator'!F15","v":45},{"$f":"'Customer Effort Estimator'!H15","v":15}]
["Test Manager",{"$f":"'Customer Effort Estimator'!D16","v":0},{"$f":"'Customer Effort Estimator'!F16","v":36},{"$f":"'Customer Effort Estimator'!H16","v":12}]
[]
[]
[]
["Area","ANALYSIS","DESIGN & BUILD","RELEASE"]
[{"$f":"_xlfn.UNIQUE('Customer Effort Estimator'!C9:C16)","v":"Management"},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A14,'Customer Effort Estimator'!D9:D16)","v":24},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A14,'Customer Effort Estimator'!F9:F16)","v":72},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A14,'Customer Effort Estimator'!H9:H16)","v":24}]
["IT",{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A15,'Customer Effort Estimator'!D9:D16)","v":36},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A15,'Customer Effort Estimator'!F9:F16)","v":171},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A15,'Customer Effort Estimator'!H9:H16)","v":51}]
["Business",{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A16,'Customer Effort Estimator'!D9:D16)","v":90},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A16,'Customer Effort Estimator'!F9:F16)","v":204.75},{"$f":"SUMIF('Customer Effort Estimator'!C9:C16,'Chart Support'!A16,'Customer Effort Estimator'!H9:H16)","v":75}]

{"sheet":"Parameters","index":4,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,18,0,22],[0,24,0,25],[0,1,0,16]]}
[null,"PROJECT TYPES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT ROLES",null,null,null,null,null,"SCHEDULE UNITS"]
[null,"Type","Description","Supplier Days","Analysis Duration Weeks","Design & Build Duration Weeks","Release Duration Weeks","Total Project Weeks","Avg Days / Week","Analysis Weight %","Design & Build Weight %","Release Weight %","Total Project Weight %","Analysis Days","Design & Build Days","Release Days","Total Project Days",null,"Role","Area","Analysis","Design & Build","Release",null,"Unit","Weeks"]
[null,"1. Orange","Small to midsized company, local implementation, limited amount of entities and limited scope.",150,3,10,3,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Duration Weeks]:[Release Duration Weeks]])","v":16},{"$f":"TabProjectTypes[[#This Row],[Supplier Days]]/TabProjectTypes[[#This Row],[Total Project Weeks]]","v":9.375},0.2,0.6,0.2,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Weight %]:[Release Weight %]])","v":1},{"$f":"TabProjectTypes[[#This Row],[Analysis Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":30},{"$f":"TabProjectTypes[[#This Row],[Design & Build Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":90},{"$f":"TabProjectTypes[[#This Row],[Release Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":30},{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Days]:[Release Days]])","v":150},null,"Project Manager","Management",0.12,0.12,0.12,null,"Weeks",1]
[null,"2. Yellow","Midsized company with either limited scope and multiple entities or single entity and average scope.",350,5,18,5,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Duration Weeks]:[Release Duration Weeks]])","v":28},{"$f":"TabProjectTypes[[#This Row],[Supplier Days]]/TabProjectTypes[[#This Row],[Total Project Weeks]]","v":12.5},0.2,0.6,0.2,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Weight %]:[Release Weight %]])","v":1},{"$f":"TabProjectTypes[[#This Row],[Analysis Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":70},{"$f":"TabProjectTypes[[#This Row],[Design & Build Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":210},{"$f":"TabProjectTypes[[#This Row],[Release Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":70},{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Days]:[Release Days]])","v":350},null,"Change Manager","Management",0.04,0.04,0.04,null,"Months",4]
[null,"3. Green","Midsized to large company, either local implementation with more complex scope or average scope and multiple entities.",750,8,32,8,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Duration Weeks]:[Release Duration Weeks]])","v":48},{"$f":"TabProjectTypes[[#This Row],[Supplier Days]]/TabProjectTypes[[#This Row],[Total Project Weeks]]","v":15.625},0.2,0.6,0.2,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Weight %]:[Release Weight %]])","v":1},{"$f":"TabProjectTypes[[#This Row],[Analysis Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":150},{"$f":"TabProjectTypes[[#This Row],[Design & Build Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":450},{"$f":"TabProjectTypes[[#This Row],[Release Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":150},{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Days]:[Release Days]])","v":750},null,"Architect","IT",0.08,0.08,0.08]
[null,"4. Blue","Large size companies with multiple entities, active in multiple countries.",1250,12,48,12,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Duration Weeks]:[Release Duration Weeks]])","v":72},{"$f":"TabProjectTypes[[#This Row],[Supplier Days]]/TabProjectTypes[[#This Row],[Total Project Weeks]]","v":17.361111111111111},0.2,0.6,0.2,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Weight %]:[Release Weight %]])","v":1},{"$f":"TabProjectTypes[[#This Row],[Analysis Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":250},{"$f":"TabProjectTypes[[#This Row],[Design & Build Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":750},{"$f":"TabProjectTypes[[#This Row],[Release Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":250},{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Days]:[Release Days]])","v":1250},null,"Business Process Owners","Business",0.6,5.5E-2,0.1,null,null,null,null,null,{"$f":"52/12","v":4.333333333333333}]
[null,"5. Purple","Enterprise company, full international scope.",2000,16,64,20,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Duration Weeks]:[Release Duration Weeks]])","v":100},{"$f":"TabProjectTypes[[#This Row],[Supplier Days]]/TabProjectTypes[[#This Row],[Total Project Weeks]]","v":20},0.2,0.6,0.2,{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Weight %]:[Release Weight %]])","v":1},{"$f":"TabProjectTypes[[#This Row],[Analysis Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":400},{"$f":"TabProjectTypes[[#This Row],[Design & Build Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":1200},{"$f":"TabProjectTypes[[#This Row],[Release Weight %]]*TabProjectTypes[[#This Row],[Supplier Days]]","v":400},{"$f":"SUM(TabProjectTypes[[#This Row],[Analysis Days]:[Release Days]])","v":2000},null,"Key Users","Business",0,0.4,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Migration","IT",0.06,0.12,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT Support","IT",0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Manager","IT",0,0.08,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUBTOTAL(109,TabProjectRoles[Analysis])","v":0.99999999999999989},{"$f":"SUBTOTAL(109,TabProjectRoles[Design & Build])","v":0.995},{"$f":"SUBTOTAL(109,TabProjectRoles[Release])","v":0.99999999999999989}]

{"sheet":"Template Versions","index":5,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Person","Template Version","Change Description"]
["2022-06-20","Cegeka","1.0","Initial version of the Customer Effort Estimator."]