{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Project Summary","TCP Extract","Assumptions","Microjourneys","Case Types","Supporting Features","Interfaces","Personas","Reports","Work Backlog","Project Attributes","Reference Sizing","Calculations","Staffing","ExportScrumSizing","Dropdowns","Tabs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":161,"comments":6,"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":"Project Summary","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,3,1,4],[1,6,1,9],[4,0,4,2],[3,0,3,9],[4,5,4,7],[4,3,4,4],[4,8,4,9],[1,0,1,1],[5,5,5,7],[9,0,9,1],[9,2,9,9],[8,0,8,9],[6,0,6,2],[6,3,6,4],[6,5,6,7],[6,8,6,9],[5,0,5,2],[5,8,5,9],[5,3,5,4]]}
["CASE TYPE BACKLOG TOOL"]
["Release Date:",null,"2019-10-24","Tool Version:",null,"v-36",{"$f":"\"© \" & YEAR($C2) &\" Pegasystems, Inc. All rights reserved.\"","v":"© 2019 Pegasystems, Inc. All rights reserved."}]
[]
["CLIENT / ENGAGEMENT DATA"]
["*Client Name:",null,null,null,null,"* Engagement Name:"]
["*Sizing Generated By:",null,null,null,null,"*Sizing Verified By:"]
["Created:",null,null,"2019-06-24T12:21:28",null,"Last Modified:",null,null,"2019-10-02T16:28:36"]
[]
["CHANGE LOG"]
[{"$f":"NOW()","v":"2019-10-24T11:07:49.190"},null,{"$f":"\"Updates were made to the following tabs: \" &Tabs!$C$9","v":"Updates were made to the following tabs: "}]

{"sheet":"TCP Extract","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Name","Value","Units"]
["No. of Case Types",{"$f":"Calculations!$B$4","v":0}]
["Average Complexity",{"$f":"Calculations!$B$5","v":0}]
["No. of Personas",{"$f":"Calculations!$B$6","v":0}]
["No. of New Interfaces",{"$f":"Calculations!$B$8","v":0}]
["No. of Existing Interfaces",{"$f":"Calculations!$B$9","v":0}]
["No. of Channels",{"$f":"Scope[[#This Row],[MLP Scope]]","v":0}]
["No. of Reports and Corr",{"$f":"Calculations!$B$11","v":0}]
["Co-Production",{"$f":"IF([0]!StaffMod=\"Co-Production\", \"Yes\", \"No\")","v":"Yes"}]
["MLP Duration Low",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,6,0),0)","v":0},"Weeks"]
["MLP Duration High",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,7,0),0)","v":0},"Weeks"]
["MLP Pega Effort Low",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,2,0),0)","v":0},"Hours"]
["MLP Pega Effort High",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,3,0),0)","v":0},"Hours"]
["Project Duration Low",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,6,0),0)","v":0},"Weeks"]
["Project Duration High",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,7,0),0)","v":0},"Weeks"]
["Project Pega Effort Low",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,2,0),0)","v":0},"Hours"]
["Project Pega Effort High",{"$f":"IFERROR(HLOOKUP(#REF!,#REF!,3,0),0)","v":0},"Hours"]

{"sheet":"Assumptions","index":2,"n_rows":51,"n_cols":1,"rows_kept":51,"cut":false,"hidden":false,"merged":[[28,1,28,9],[23,1,23,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[47,1,47,9],[48,1,48,9],[49,1,49,9],[30,1,30,9],[31,1,31,9],[32,1,32,9],[33,1,33,9],[34,1,34,9],[50,1,50,9],[4,1,4,9],[3,1,3,9],[41,1,41,9],[42,1,42,9],[43,1,43,9],[44,1,44,9],[45,1,45,9],[46,1,46,9],[35,1,35,9],[36,1,36,9],[37,1,37,9],[38,1,38,9],[39,1,39,9],[40,1,40,9],[29,1,29,9],[22,1,22,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[14,1,14,9],[15,1,15,9],[16,1,16,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[20,1,20,9],[21,1,21,9],[10,1,10,9],[0,0,0,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[2,1,2,9],[1,1,1,9]]}
["ASSUMPTIONS"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Microjourneys","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,2,8,3],[2,0,2,3],[3,2,3,3],[4,2,4,3],[6,2,6,3],[7,2,7,3],[5,2,5,3]]}
[]
[null,null,2]
["Microjourneys"]
["#","Microjourney","Description"]
[{"$f":"ROW()-5","v":0}]
[{"$f":"ROW()-5","v":1}]
[{"$f":"ROW()-5","v":2}]
[{"$f":"A7-1","v":1},{"$f":"COUNTA(JourneyList)","v":0}]
["tot",{"$f":"\"'\"&Tabs!E2&\"'!$B$\"&ROW(JourneyList)+1&\":$B$\"&ROW(JourneyList)+ROWS(JourneyList)-2","v":"'Microjourneys'!$B$6:$B$6"}]

{"sheet":"Case Types","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,8],[3,0,4,0],[3,1,4,1],[3,3,4,3],[3,4,3,7],[3,8,4,8],[3,2,4,2]]}
[]
[null,null,null,null,2]
["Case Types"]
["#","Case Type","Parent Microjourney(s)\n(Multi-Select)","Average Complexity","Channels",null,null,null,"Assumptions"]
[null,null,null,null,"Call Center / Desktop","Mobile App","Web Self Service","Other"]
[{"$f":"ROW()-6","v":0},null,null,"<Select>",1,0,0,0]
[{"$f":"ROW()-6","v":1},null,null,"<Select>",1,0,0,0]
[{"$f":"ROW()-6","v":2},null,null,"<Select>",1,0,0,0]
[{"$f":"A8+1","v":3},{"$f":"countunique(Cases)-1","v":0},null,{"$f":"IFERROR(MAX(SumOfVlookup(Effort,Dropdowns!$K$2:$L$7,\"\")/$A9,1),0)","v":1},{"$f":"IFERROR(AVERAGE(E4:E8),0)","v":1},{"$f":"IFERROR(AVERAGE(F4:F8),0)","v":0},{"$f":"IFERROR(AVERAGE(G4:G8),0)","v":0},{"$f":"IFERROR(AVERAGE(H4:H8),0)","v":0}]
["tot",{"$f":"\"'\"&Tabs!E3&\"'!$B$\"&ROW(Cases)&\":$B$\"&ROW(Cases)+ROWS(Cases)-2","v":"'Case Types'!$B$6:$B$7"},{"$f":"DeDupeString(_xlfn.TEXTJOIN(\", \",TRUE,AssociatedMicroJ),\", \")","v":""},"Average","Average Percent","Average Percent","Average Percent","Average Percent"]

{"sheet":"Supporting Features","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[12,3,12,8],[13,3,13,8],[14,3,14,8],[15,3,15,8],[2,0,2,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,7],[3,8,4,8]]}
[]
[null,null,null,null,2]
["Supporting Features"]
["#","Feature","Which Case Types is this Feature in support of? \n(Multi-Select)","Average Complexity","Channels",null,null,null,"Assumptions"]
[null,null,null,null,"Call Center / Desktop","Mobile App","Web Self Service","Other"]
[{"$f":"ROW()-6","v":0},null,null,"<Select>",1,0,0,0]
[{"$f":"ROW()-6","v":1},null,null,"<Select>",1,0,0,0]
[{"$f":"ROW()-6","v":2},null,null,"<Select>",1,0,0,0]
[{"$f":"A8+1","v":3},{"$f":"countunique(Features)-1","v":0},null,{"$f":"IFERROR(MAX(SumOfVlookup(Effort,Dropdowns!$K$2:$L$6,\"\")/$A9,1),0)","v":1},{"$f":"IFERROR(AVERAGE(E4:E8),0)","v":1},{"$f":"IFERROR(AVERAGE(F4:F8),0)","v":0},{"$f":"IFERROR(AVERAGE(G4:G8),0)","v":0},{"$f":"IFERROR(AVERAGE(H4:H8),0)","v":0}]
["tot","Number of Unique Features","Number of Unique","Average","Average Percent","Average Percent","Average Percent","Average Percent"]

{"sheet":"Interfaces","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,6],[12,4,12,6],[13,4,13,6],[14,4,14,6]]}
[]
[null,null,null,null,null,2]
["Interfaces"]
["#","Interface Name","Service  or Connector  ","Interface / Data Source Type","Complexity","Interface Data Source Exists?","Assumptions"]
[{"$f":"ROW()-5","v":0},null,"<Select>","<Select>","<Select>","<Select>"]
[{"$f":"ROW()-5","v":1},null,"<Select>","<Select>","<Select>","<Select>"]
[{"$f":"ROW()-5","v":2},null,"<Select>","<Select>","<Select>","<Select>"]
[{"$f":"A7-1","v":1},{"$f":"countunique(B5:B7)-1","v":0},null,null,{"$f":"IFERROR(MAX(SumOfVlookup(E5:E7,Dropdowns!$D$2:$E$5,\"\")/$A8,1),0)","v":1},{"$f":"MAX(COUNTIF(F5:F7, \"No\")+COUNTIF(F5:F7, \"Unknown\")+COUNTIF(F5:F7, \"?Select?\")-2,0)","v":1}]
["tot","Number of Unique interfaces",null,null,"Average Complexity","Number of New or unknown"]

{"sheet":"Personas","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[6,2,6,3],[2,0,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3]]}
[]
[null,null,2]
["Personas"]
["#","Personas","Assumptions"]
[{"$f":"ROW()-5","v":0}]
[{"$f":"ROW()-5","v":1}]
[{"$f":"ROW()-5","v":2}]
[{"$f":"A7-1","v":1},{"$f":"COUNTA(RoleList)","v":0}]
["tot","Number of non-blank"]

{"sheet":"Reports","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[11,2,11,4],[12,2,12,4],[13,2,13,6],[2,0,2,4],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,4,4,4],[3,3,4,3]]}
[]
[null,null,2]
["Reports & Correspondences"]
["#","Report or Correspondence","Average Complexity","MLP Release","Assumptions"]
[]
[{"$f":"ROW()-6","v":0},null,"<Select>","<Select>"]
[{"$f":"ROW()-6","v":1},null,"<Select>","<Select>"]
[{"$f":"ROW()-6","v":2},null,"<Select>","<Select>"]
[{"$f":"A8-1","v":1},{"$f":"COUNTA(ReportNames)","v":0},{"$f":"IFERROR(MAX(SumOfVlookup(Effort,Dropdowns!$K$2:$L$7,\"\")/$A9,1),0)","v":1}]
["tot","Number of non-blank","Average",{"$f":"COUNTIF(ReportsMLP,\"MLP1\")","v":0}]

{"sheet":"Work Backlog","index":9,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,8,1,9],[0,0,0,16],[1,0,1,5],[1,10,1,13]]}
["Case Type Backlog"]
["Work To Do",null,null,null,null,null,"Interfaces",null,"Personas",null,"Channels",null,null,null,"Biz Value","Release","Sizing Assumptions"]
["#","C or F","Microjourney","Case Type/ Feature","Which case types is this feature in support of?","Average Complexity",null,null,null,null,"Call Center / Desktop","Mobile App","Web Self Service","Other","L/M/H","MLP Release","Assumptions"]
[{"$f":"ROW()-4","v":0},null,{"$f":"IF(NumJourneys >0, IFERROR(_xlfn.IFS(B4=\"\", \"\", B4=\"C\", VLOOKUP(D4,'Case Types'!$B$6:$C$8,2,0), B4=\"F\",IF(E4 = \"All\", 'Case Types'!$C$10, SplitAndMatch(E4, \"CTMJ\", 2)) ), \"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D4,'Supporting Features'!$B$6:$C$8,2,0),\"\")","v":""},"<Select>",null,null,null,null,0,0,0,0,"<Select>","<Select>"]
[{"$f":"ROW()-4","v":1},"C",{"$f":"IF(NumJourneys >0, IFERROR(_xlfn.IFS(B5=\"\", \"\", B5=\"C\", VLOOKUP(D5,'Case Types'!$B$6:$C$8,2,0), B5=\"F\",IF(E5 = \"All\", 'Case Types'!$C$10, SplitAndMatch(E5, \"CTMJ\", 2)) ), \"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D5,'Supporting Features'!$B$6:$C$8,2,0),\"\")","v":""},"<Select>",null,null,null,null,1,0,0,0,"<Select>"]
[{"$f":"ROW()-4","v":2},"F",{"$f":"IF(NumJourneys >0, IFERROR(_xlfn.IFS(B6=\"\", \"\", B6=\"C\", VLOOKUP(D6,'Case Types'!$B$6:$C$8,2,0), B6=\"F\",IF(E6 = \"All\", 'Case Types'!$C$10, SplitAndMatch(E6, \"CTMJ\", 2)) ), \"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D6,'Supporting Features'!$B$6:$C$8,2,0),\"\")","v":""},"<Select>",null,null,null,null,1,0,0,0,"<Select>"]
[{"$f":"ROW()-4","v":3},"F",{"$f":"IF(NumJourneys >0, IFERROR(_xlfn.IFS(B7=\"\", \"\", B7=\"C\", VLOOKUP(D7,'Case Types'!$B$6:$C$8,2,0), B7=\"F\",IF(E7 = \"All\", 'Case Types'!$C$10, SplitAndMatch(E7, \"CTMJ\", 2)) ), \"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D7,'Supporting Features'!$B$6:$C$8,2,0),\"\")","v":""},"<Select>",null,null,null,null,0,0,0,0,"<Select>","<Select>"]
[{"$f":"A7-1","v":2},null,null,{"$f":"COUNTA(Case_Types)","v":0},null,{"$f":"\"$F$\"&ROW(AvgComplexity)+1&\":$F$\"&ROW(AvgComplexity)+ROWS(AvgComplexity)-2","v":"$F$5:$F$7"},null,null,null,null,{"$f":"ADDRESS(ROW(CallCenter)+1,COLUMN(CallCenter))&\":\"&ADDRESS(ROW(CallCenter)+ROWS(CallCenter)-2,COLUMN(CallCenter))","v":"$K$5:$K$7"},{"$f":"ADDRESS(ROW(MobileApp)+1,COLUMN(MobileApp))&\":\"&ADDRESS(ROW(MobileApp)+ROWS(MobileApp)-2,COLUMN(MobileApp))","v":"$L$5:$L$7"},{"$f":"ADDRESS(ROW(WebSelfServ)+1,COLUMN(WebSelfServ))&\":\"&ADDRESS(ROW(WebSelfServ)+ROWS(WebSelfServ)-2,COLUMN(WebSelfServ))","v":"$M$5:$M$7"},{"$f":"ADDRESS(ROW(Other)+1,COLUMN(Other))&\":\"&ADDRESS(ROW(Other)+ROWS(Other)-2,COLUMN(Other))","v":"$N$5:$N$7"}]
[6,null,null,null,null,{"$f":"IFERROR(MAX(SumOfVlookup(INDIRECT(F8),Dropdowns!$K$2:$L$7,\"\")/$A8,1),0)","v":1},null,null,null,null,{"$f":"IFERROR((SUM(INDIRECT(K8)))/(RowCount),0)","v":1},{"$f":"IFERROR((SUM(INDIRECT(L8)))/(RowCount),0)","v":0},{"$f":"IFERROR((SUM(INDIRECT(M8)))/(RowCount),0)","v":0},{"$f":"IFERROR((SUM(INDIRECT(N8)))/(RowCount),0)","v":0}]
[{"$f":"COUNTIFS(D4:D7,\"<>\"&\"\",$P4:$P7,\"MLP1\")","v":0},null,null,"MLP",null,{"$f":"IFERROR(MAX(SumOfVlookup(F4:F7,Dropdowns!$K$2:$L$7,\"MLP1\")/MLPCnt,1),0)","v":0},{"$f":"IF(MIN(COUNTIFS(G4:G7,\"<>\"&\"\",$P4:$P7,\"MLP1\"),1)=1, VLOOKUP(G3,Interfaces!$B5:$F7,5,0),0)","v":0},{"$f":"IF(MIN(COUNTIFS(H4:H7,\"<>\"&\"\",$P4:$P7,\"MLP1\"),1)=1, VLOOKUP(H3,Interfaces!$B5:$F7,5,0),0)","v":0},{"$f":"MIN(COUNTIFS(I4:I7,\"<>\"&\"\",$P4:$P7,\"MLP1\"),1)","v":0},{"$f":"MIN(COUNTIFS(J4:J7,\"<>\"&\"\",$P4:$P7,\"MLP1\"),1)","v":0},{"$f":"IFERROR(SUMIF($P4:$P7,\"MLP1\",K4:K7)/MLPCnt,0)","v":0},{"$f":"IFERROR(SUMIF($P4:$P7,\"MLP1\",L4:L7)/MLPCnt,0)","v":0},{"$f":"IFERROR(SUMIF($P4:$P7,\"MLP1\",M4:M7)/MLPCnt,0)","v":0},{"$f":"IFERROR(SUMIF($P4:$P7,\"MLP1\",N4:N7)/MLPCnt,0)","v":0},null,{"$f":"COUNTIF($P4:$P7,\"MLP1\")","v":0}]

{"sheet":"Project Attributes","index":10,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,3,1,4],[13,3,13,4],[8,3,8,4],[3,3,3,4],[7,3,7,4],[4,3,4,4],[6,3,6,4],[9,3,9,4],[2,3,2,4],[13,1,13,2],[6,0,7,0],[9,0,11,0],[13,0,16,0],[15,3,15,4],[17,3,17,4],[21,3,21,4],[5,3,5,4],[12,3,12,4],[10,3,10,4],[16,3,16,4],[14,3,14,4],[11,3,11,4],[20,3,20,4],[18,3,18,4],[19,3,19,4],[21,1,21,2],[1,1,1,2],[4,1,4,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[2,1,2,2],[3,1,3,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[18,0,19,0],[2,0,4,0],[18,1,18,2],[19,1,19,2],[20,1,20,2],[17,1,17,2]]}
["PROJECT ATTRIBUTES"]
["ATTRIBUTE TYPE","ATTRIBUTE NAME",null,"ATTRIBUTE VALUE",null,"PROJECT ASSUMPTIONS"]
["Platform / Application Info","Pega Version:",null,"8.3"]
[null,"Application Name:"]
[null,"Application Version:"]
[]
["Co-Production","Staffing Model:",null,"Co-Production"]
[null,"Engagement Lead:",null,"Pega Led / Client Co-Prod"]
[]
["Delivery","Delivery Methodology:",null,"Agile/Scrum"]
[null,"Scrum Maturity:",null,"High"]
[null,"Number of Scrum Teams",null,1]
[]
["Other Attributes","Pega Cloud or Existing On-Prem Instance:",null,"Yes"]
[null,"Data Import/Conversion Required:",null,"None"]
[null,"Localization (Enter # of additional languages):",null,0]
[null,"Highly Regulated or Complex Company:",null,"No"]
[]
["Special Packages in MLP1","Robotics (10-week package implementation):",null,"No",null,{"$f":"IFERROR(VLOOKUP(RobotFlag,Calculations!$Q$32:$V$43,2,0),\"\")","v":""}]
[null,"Mktg & Dec Quick Win Package:",null,"None",null,{"$f":"IFERROR(VLOOKUP(DSMpkg,Calculations!$Q$32:$V$43,2,0),\"\")","v":""}]
[]
["Risk","Other Contingencies (QA, Risk, etc.):",null,0]

{"sheet":"Reference Sizing","index":11,"n_rows":18,"n_cols":26,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,20,0],[19,2,19,17],[4,2,18,2],[4,17,18,17],[18,3,18,16],[6,14,7,14],[8,4,9,4],[8,8,9,8],[8,9,9,9],[9,14,9,15],[13,4,14,4],[13,8,14,8],[13,9,14,9],[14,14,14,15],[0,3,0,16],[13,3,15,3],[16,3,17,3],[16,4,17,4],[15,14,15,15],[5,14,5,15],[6,3,10,3],[6,13,7,13],[8,14,8,15],[8,13,12,13],[4,6,17,6],[11,3,12,3],[2,19,20,19],[3,18,19,18],[4,3,5,4],[4,8,4,9],[4,10,17,10],[4,11,17,11],[4,12,17,12],[4,13,4,16],[11,14,11,15],[12,14,12,15],[13,13,17,13],[13,14,13,15],[16,8,17,9],[17,14,17,15],[16,14,16,15],[10,14,10,15]]}
[null,null,null,"Reference Sizing Chart"]
[]
[]
[]
[null,null,null,"PARAMETERS FOR SIZING",null,null,null,null,"ENGAGEMENT SCOPE",null,null,null,null,"ESTIMATE RESULTS"]
[null,null,null,null,null,null,null,null,"MLP Scope","Full Program",null,null,null,"CATEGORY","SUB-CATEGORY",null,"DETAIL"]
[null,null,null,"Process Complexity","Case Types & Features",null,null,null,{"$f":"Calculations!B4","v":0},{"$f":"Calculations!C4","v":0},null,null,null,"Staffing Model",{"$f":"IF(CoProdFlag, \"\", \"Not \") & \"Co-Production\"","v":"Co-Production"},{"$f":"IFERROR(IF(SEARCH(\"Partner\", 'Project Attributes'!D8), \"Partner\", \"Pega\"), \"Pega\")","v":"Pega"},{"$f":"Table7[[#Totals],[Text]]& IF(OR(RobotFlag=\"Yes\", DSMFlag), CHAR(10)& IF(RobotFlag=\"Yes\", Table5[[#Totals],[text]] & \"  \", \"\") & IF(DSMFlag, Table53[[#Totals],[text]], \"\"),\"\")","v":"1 Scrum Team: 1 EL, 1 (L/S)BA, 1 LSA, 2 (S)SA, ½ UX/UI"}]
[null,null,null,null,"Average Complexity",null,null,null,{"$f":"IF(I7>0,Calculations!S4,\"\")","v":""},{"$f":"IF(J7>0,Calculations!V4,\"\")","v":""},null,null,null,null,null,"Client\n(full time)",{"$f":"Table8[[#Totals],[Text]]","v":"1 Product Owner, \n1 Test Lead, 2 Tester, 1 Pega Certified BA, 2 Pega Certified SA"}]
[null,null,null,null,"Personas",null,null,null,{"$f":"Calculations!B6","v":0},{"$f":"Calculations!C6","v":0},null,null,null,"MLP1 \nFirst Release","MLP Duration",null,{"$f":"Calculations!B39&\"-\"&Calculations!C39 & \" weeks\"","v":"2-3 weeks"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Based on staffing model above)",null,{"$f":"IF(Calculations!B18=\"No\", \"Timeline may be impacted if On-Prem env is not provisioned prior to kickoff \",\"\")","v":""}]
[null,null,null,null,"Channels",null,null,null,{"$f":"COUNTIF('Work Backlog'!$K$10:$N$10, \">\"&0)","v":0},{"$f":"IF(J7>0, COUNTIF('Work Backlog'!$K$9:$N$9, \">\"&0),0)","v":0},null,null,null,null,"MLP Total Hours",null,{"$f":"TEXT(Calculations!B42,LocNumFormat)&\"-\"&TEXT(Calculations!C42,LocNumFormat)","v":"1,000-1,240"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(#REF!>0,#REF!&\"-\"&#REF!&\" weeks\", \"MLP scope not defined\")","v":{"$error":"#REF!"}}]
[null,null,null,"Integration","New Interfaces",null,null,null,{"$f":"Calculations!B8","v":0},{"$f":"Calculations!C8","v":1},null,null,null,null,{"$f":"\"MLP \"&P7&\" Hours\"","v":"MLP Pega Hours"},null,{"$f":"TEXT(Calculations!B40,LocNumFormat)&\"-\"&TEXT(Calculations!C40,LocNumFormat)","v":"500-600"}]
[null,null,null,null,"Existing Interfaces",null,null,null,{"$f":"Calculations!B9","v":0},{"$f":"Calculations!C9","v":0},null,null,null,null,"MLP Client Hours",null,{"$f":"TEXT(Calculations!B41,LocNumFormat)&\"-\"&TEXT(Calculations!C41,LocNumFormat)","v":"500-640"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(#REF!>0,#REF!&\"-\"&#REF!, \"MLP scope not defined\")","v":{"$error":"#REF!"}}]
[null,null,null,"Reports","Reports & Correspondences",null,null,null,{"$f":"Calculations!B11","v":0},{"$f":"Calculations!C11","v":0},null,null,null,"Full Program\n(MLP1 & all future releases)","Full Program Duration",null,{"$f":"Calculations!D39&\"-\"&Calculations!E39 & \" weeks\"","v":"3-5 weeks"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!&\"-\"&#REF!& \" weeks\"","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Based on staffing model above)",null,{"$f":"IF(Calculations!B18=\"No\", \"Timeline may be impacted if On-Prem env is not provisioned prior to kickoff \",\"\")","v":""}]
[null,null,null,null,"Average Complexity",null,null,null,{"$f":"IF(I14>0,Calculations!S5,\"\")","v":""},{"$f":"IF(J14>0,Calculations!V5,\"\")","v":""},null,null,null,null,"Total Hours",null,{"$f":"TEXT(Calculations!D42,LocNumFormat)&\"-\"&TEXT(Calculations!E42,LocNumFormat)","v":"1,200-2,030"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!& \"-\" &#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Other Attributes","Special Project Attributes",null,null,null,{"$f":"IF(Calculations!Q18, Calculations!S18,\"\")","v":""},null,null,null,null,null,{"$f":"P7 & \" Hours\"","v":"Pega Hours"},null,{"$f":"TEXT(Calculations!D40,LocNumFormat)&\"-\"&TEXT(Calculations!E40,LocNumFormat)","v":"600-1,000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Client Hours",null,{"$f":"TEXT(Calculations!D41,LocNumFormat)&\"-\"&TEXT(Calculations!E41,LocNumFormat)","v":"600-1,030"}]

{"sheet":"Calculations","index":12,"n_rows":62,"n_cols":28,"rows_kept":62,"cut":false,"hidden":true,"merged":[[1,0,1,4],[1,15,1,21],[0,0,0,21],[1,8,1,11],[20,15,20,17],[22,8,22,11],[29,15,29,21],[40,16,42,16],[40,17,42,21],[34,15,42,15],[30,17,30,21],[34,16,36,16],[34,17,36,21],[37,16,39,16],[37,17,39,21],[52,15,52,18],[31,15,33,15],[31,16,33,16],[31,17,33,21],[45,15,45,27]]}
["CALCULATIONS, FACTORS, & OTHER DATA ELEMENTS"]
["Calculations",null,null,null,null,null,null,null,"Factors",null,null,null,null,null,null,"Other Data/Calc Elements"]
["Parameters","MLP Scope","Full Program","MLP Hours","Full Hours",null,null,null,"Parameter","Hours","Effort Factor","Minimum",null,null,null,"Complexity Type","MLP Low","MLP High","MLP","Full Low","Full High","Full"]
["Number of Case Types & Features",{"$f":"'Work Backlog'!$A$10","v":0},{"$f":"'Work Backlog'!D8","v":0},{"$f":"ROUND(Scope[[#This Row],[MLP Scope]]*$J4,0)","v":0},{"$f":"ROUND(Scope[[#This Row],[Full Program]]*$J4,0)","v":0},null,null,null,"Number of Case Types & Features",12,null,null,null,null,null,"Case/Features Complexity",{"$f":"IFERROR(VLOOKUP(ROUNDDOWN($B$5,0),Dropdowns!$J$3:$K$7,2,0), \"OOTB\")","v":"OOTB"},{"$f":"IFERROR(VLOOKUP(ROUNDUP($B$5,0),Dropdowns!$J$3:$K$7,2,0), \"OOTB\")","v":"OOTB"},{"$f":"IF(Q4<>R4,Q4&\"-\"&R4,Q4)","v":"OOTB"},{"$f":"VLOOKUP(ROUNDDOWN($C$5,0),Dropdowns!$J$3:$K$7,2,0)","v":"OOTB"},{"$f":"VLOOKUP(ROUNDUP($C$5,0),Dropdowns!$J$3:$K$7,2,0)","v":"OOTB"},{"$f":"IF(T4<>U4,T4&\"-\"&U4,T4)","v":"OOTB"}]
["Average Complexity (Case & Features)",{"$f":"'Work Backlog'!$F$10","v":0},{"$f":"'Work Backlog'!$F$9","v":1},{"$f":"MAX(ROUND((Scope[[#This Row],[MLP Scope]]-1)*$K5*$D4,0)-D4,0)","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[Full Program]]-1)*$K5*$E4,0)-E4,0)","v":0},null,null,null,"Average Complexity (Case & Features)",null,1.5,null,null,null,null,"Report Complexity",{"$f":"IFERROR(VLOOKUP(ROUNDDOWN($B$12,0),Dropdowns!$J$3:$K$7,2,0), \"OOTB\")","v":"OOTB"},{"$f":"IFERROR(VLOOKUP(ROUNDUP($B$12,0),Dropdowns!$J$3:$K$7,2,0), \"OOTB\")","v":"OOTB"},{"$f":"IF(Q5<>R5,Q5&\"-\"&R5,Q5)","v":"OOTB"},{"$f":"VLOOKUP(ROUNDDOWN($C$12,0),Dropdowns!$J$3:$K$7,2,0)","v":"OOTB"},{"$f":"VLOOKUP(ROUNDUP($C$12,0),Dropdowns!$J$3:$K$7,2,0)","v":"OOTB"},{"$f":"IF(T5<>U5,T5&\"-\"&U5,T5)","v":"OOTB"}]
["Number of Personas",{"$f":"SUM('Work Backlog'!$I$10:$J$10)","v":0},{"$f":"Personas!B8","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[MLP Scope]]-1)*$K6*SUM(D4,D5),0),0)","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[Full Program]]-1)*$K6*SUM(E4,E5),0),0)","v":0},null,null,null,"Number of Personas",null,0.02]
["Number of Channels",{"$f":"SUM('Work Backlog'!K10:N10)","v":0},{"$f":"IF(C4>0, SUM('Work Backlog'!K9:N9),0)","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[MLP Scope]]-1)*$K7*SUM(D4,D5),0),0)","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[Full Program]]-1)*$K7*SUM(E4,E5),0),0)","v":0},null,null,null,"Number of Channels",null,0.25]
["# of New Interface Data Sources",{"$f":"COUNTIF('Work Backlog'!G10:H10,\"No\")+COUNTIF('Work Backlog'!G10:H10,\"Unknown\")+COUNTIF('Work Backlog'!G10:H10,\"?Select?\")","v":0},{"$f":"Interfaces!F8","v":1},{"$f":"ROUND(Scope[[#This Row],[MLP Scope]]*$J8,0)","v":0},{"$f":"ROUND(Scope[[#This Row],[Full Program]]*$J8,0)","v":110},null,null,null,"# of New Interface Data Sources",110,null,null,null,null,null,"Flag","Value","Name","Bullet Item"]
["# of Existing Interface Data Sources",{"$f":"COUNTIF('Work Backlog'!G10:H10,\"Yes\")","v":0},{"$f":"COUNTIF(Interfaces!$F$5:$F$7, \"Yes\")","v":0},{"$f":"ROUND(Scope[[#This Row],[MLP Scope]]*$J9,0)","v":0},{"$f":"ROUND(Scope[[#This Row],[Full Program]]*$J9,0)","v":0},null,null,null,"# of Existing Interface Data Sources",75,null,null,null,null,null,"Meth",{"$f":"MethFlag<>\"Agile/Scrum\"","v":false},"Waterfall Methodology",{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Average Complexity (Interfaces)",{"$f":"Interfaces!$E$8","v":1},{"$f":"Interfaces!$E$8","v":1},{"$f":"MAX(ROUND((Scope[[#This Row],[MLP Scope]]-2)*$K10*SUM(D8:D9),0),0)","v":0},{"$f":"MAX(ROUND((Scope[[#This Row],[Full Program]]-2)*$K10*SUM(E8:E9),0),0)","v":0},null,null,null,"Average Complexity (Interfaces)",null,0.5,null,null,null,null,"Regulated",{"$f":" RegulatedFlag=\"Yes\"","v":false},"Highly Regulated/Complex Company",{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Reports & Correspondences",{"$f":"[0]!NumMLPReports","v":0},{"$f":"Reports!B9","v":0},{"$f":"ROUND(Scope[[#This Row],[MLP Scope]]*$J11,0)","v":0},{"$f":"ROUND(Scope[[#This Row],[Full Program]]*$J11,0)","v":0},null,null,null,"Reports & Correspondences",4,null,null,null,null,null,"Maturity",{"$f":"OR( MaturityFlag=\"Low\", MaturityFlag=\"Medium\")","v":false},{"$f":"[0]!MaturityFlag& \" Scrum Maturity\"","v":"High Scrum Maturity"},{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Average Complexity (Reports)",{"$f":"Reports!$C$9","v":1},{"$f":"Reports!$C$9","v":1},{"$f":"MAX(IF(Scope[[#This Row],[MLP Scope]]=1,0,ROUND((Scope[[#This Row],[MLP Scope]])*$K12*$D11,0)),0)","v":0},{"$f":"MAX(IF(Scope[[#This Row],[Full Program]]=1,0,ROUND((Scope[[#This Row],[Full Program]])*$K12*$E11,0)),0)","v":0},null,null,null,"Average Complexity (Reports)",null,2,null,null,null,null,"Cloud",{"$f":"CloudFlag=\"No\"","v":false},{"$f":"\"New On-Prem Instance\"","v":"New On-Prem Instance"},{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Dev Effort Subtotal",null,null,{"$f":"SUBTOTAL(109,Scope[MLP Hours])","v":0},{"$f":"SUBTOTAL(109,Scope[Full Hours])","v":110},null,null,null,"Staffing Model:",null,0.1,null,null,null,null,"DataConv",{"$f":" NOT(DataConversion=\"None\")","v":false},"Data Import/Conversion",{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&\" - \"&DataConversion&CHAR(10), \"\")","v":""}]
["Project Level Attributes","MLP Scope","Full Program","MLP Hours","Full Hours",null,null,null,"Delivery Methodology:",null,0.2,null,null,null,null,"Localization",{"$f":"Localization","v":0},{"$f":"Table818[[#This Row],[Value]]&\" Additional Language\" & IF(Table818[[#This Row],[Value]] <> 1, \"s\",\"\")","v":"0 Additional Languages"},{"$f":"IF(Table818[[#This Row],[Value]]>0,\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Staffing Model:",{"$f":"[0]!StaffMod","v":"Co-Production"},{"$f":"[0]!StaffMod","v":"Co-Production"},{"$f":"IF(Attributes[[#This Row],[MLP Scope]]<>\"Co-Production\",0,Scope[[#Totals],[MLP Hours]]*$K13)","v":0},{"$f":"Attributes[[#This Row],[MLP Hours]]","v":0},null,null,null,"Scrum Maturity:",null,7.4999999999999997E-2,null,null,null,null,"Robotics",{"$f":"RobotFlag=\"Yes\"","v":false},"Robotics 10-week package (MLP1)",{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Delivery Methodology:",{"$f":"[0]!MethFlag","v":"Agile/Scrum"},{"$f":"[0]!MethFlag","v":"Agile/Scrum"},{"$f":"IF(Attributes[[#This Row],[MLP Scope]]=\"Agile/Scrum\",0,Scope[[#Totals],[MLP Hours]]*$K14)","v":0},{"$f":"IF(Attributes[[#This Row],[Full Program]]=\"Agile/Scrum\",0,Scope[[#Totals],[Full Hours]]*$K14)","v":0},null,null,null,"Pega Cloud / Existing On-Prem Instance:",null,0.1,12,null,null,null,"Marketing & Decisioning",{"$f":"DSMFlag","v":false},"Mktg & Dec",{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&\" - \"&DSMpkg&CHAR(10), \"\")","v":""}]
["Scrum Maturity:",{"$f":"[0]!MaturityFlag","v":"High"},{"$f":"[0]!MaturityFlag","v":"High"},{"$f":"IF(Attributes[[#This Row],[MLP Scope]]=\"High\",0,IF(Attributes[[#This Row],[MLP Scope]]=\"Low\",2*Scope[[#Totals],[MLP Hours]]*$K15,Scope[[#Totals],[MLP Hours]]*$K15))","v":0},{"$f":"IF(Attributes[[#This Row],[Full Program]]=\"High\",0,IF(Attributes[[#This Row],[Full Program]]=\"Low\",2*Scope[[#Totals],[Full Hours]]*$K15,Scope[[#Totals],[Full Hours]]*$K15))","v":0},null,null,null,"Data Import/Conversion Required:",null,0.1,null,null,null,null,"FudgeFactor",{"$f":"FudgeFactor>0","v":false},{"$f":"IF(Table818[[#This Row],[Value]],C23*100& \"% Contingency Factor\",\"\")","v":""},{"$f":"IF(Table818[[#This Row],[Value]],\"• \"&Table818[[#This Row],[Name]]&CHAR(10), \"\")","v":""}]
["Pega Cloud / Existing On-Prem Instance:",{"$f":"'Project Attributes'!$D$14","v":"Yes"},{"$f":"'Project Attributes'!$D$14","v":"Yes"},{"$f":"IF(Attributes[[#This Row],[MLP Scope]]=\"Yes\",0,Scope[[#Totals],[MLP Hours]]*$K16)","v":0},{"$f":"IF(Attributes[[#This Row],[Full Program]]=\"Yes\",0,Scope[[#Totals],[Full Hours]]*$K16)","v":0},null,null,null,"Localization (Enter # of additional languages):",null,0.1,null,null,null,null,"Flag",{"$f":"OR(Table818[Value])","v":false},null,{"$f":"IFERROR(LEFT(S9&S10&S11&S12&S13&S14&S15&S16&S17, LEN(S9&S10&S11&S12&S13&S14&S15&S16&S17)-1),\"\")","v":""}]
["Data Import/Conversion Required:",{"$f":"'Project Attributes'!$D$15","v":"None"},{"$f":"'Project Attributes'!$D$15","v":"None"},{"$f":"VLOOKUP(Attributes[[#This Row],[MLP Scope]],Dropdowns!$D$19:$E$22,2,0)*Scope[[#Totals],[MLP Hours]]*$K17","v":0},{"$f":"VLOOKUP(Attributes[[#This Row],[Full Program]],Dropdowns!$D$19:$E$22,2,0)*Scope[[#Totals],[Full Hours]]*$K17","v":0},null,null,null,"Robotics",736,null,10]
["Localization (Enter # of additional languages):",{"$f":"'Project Attributes'!$D$16","v":0},{"$f":"'Project Attributes'!$D$16","v":0},{"$f":"Attributes[[#This Row],[MLP Scope]]*K18*Scope[[#Totals],[MLP Hours]]","v":0},{"$f":"Attributes[[#This Row],[Full Program]]*K18*Scope[[#Totals],[Full Hours]]","v":0},null,null,null,"Highly Regulated or Complex Company:",null,0.2]
["Highly Regulated or Complex Company:",{"$f":"'Project Attributes'!$D$17","v":"No"},{"$f":"'Project Attributes'!$D$17","v":"No"},{"$f":"IF(Attributes[[#This Row],[MLP Scope]]=\"No\",0,Scope[[#Totals],[MLP Hours]]*$K20)","v":0},{"$f":"IF(Attributes[[#This Row],[Full Program]]=\"No\",0,Scope[[#Totals],[Full Hours]]*$K20)","v":0},null,null,null,null,null,null,null,null,null,null,"Other Constants"]
["Mktg & Dec Quick Win",{"$f":"'Project Attributes'!D20","v":"None"},{"$f":"'Project Attributes'!D20","v":"None"},{"$f":"VLOOKUP(Attributes[[#This Row],[MLP Scope]],Table3[],2,0)","v":0},{"$f":"VLOOKUP(Attributes[[#This Row],[Full Program]],Table3[],2,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Name","Value","Description"]
["Other Contingencies (QA, Risk, etc.):",{"$f":"'Project Attributes'!$D$22","v":0},{"$f":"'Project Attributes'!$D$22","v":0},{"$f":"Attributes[[#This Row],[MLP Scope]]*(Scope[[#Totals],[MLP Hours]]+D22+D29)","v":0},{"$f":"Attributes[[#This Row],[Full Program]]*(Scope[[#Totals],[Full Hours]]+E22+E29)","v":0},null,null,null,"Marketing",null,null,null,null,null,null,"Localized Number format",{"$f":"\"#\"&GetThousandsSep()&\"##0\"","v":"#,##0"},"Localized number format based on pc settings"]
["Project Level Impact",null,null,{"$f":"SUBTOTAL(109,Attributes[MLP Hours])","v":0},{"$f":"SUBTOTAL(109,Attributes[Full Hours])","v":0},null,null,null,"DSM: Quick Win Pacakge","Hours",null,null,null,null,null,"Co-Production Flag",{"$f":"IF('Project Attributes'!D7=\"Co-Production\", TRUE,FALSE)","v":true}]
["Subtotal Including Attribute Adjustment",null,null,{"$f":"Attributes[[#Totals],[MLP Hours]]+Scope[[#Totals],[MLP Hours]]","v":0},{"$f":"Attributes[[#Totals],[Full Hours]]+Scope[[#Totals],[Full Hours]]","v":110},null,null,null,"None",0,null,null,null,null,null,"Overhead Max",2.25,"The max overhead allowed"]
["Subtotal Adjusted for overhead",{"$f":"MAX(MIN(Scope[[#Totals],[MLP Hours]]/$Q$27,$Q$25),$Q$26)","v":1},{"$f":"MAX(MIN(Scope[[#Totals],[Full Hours]]/$Q$27,$Q$25),$Q$26)","v":1},{"$f":"D25*Adjustments[[#This Row],[Column2]]","v":0},{"$f":"E25*Adjustments[[#This Row],[Column3]]","v":110},null,null,null,"Real-Time Cross-Sell Up Sell",1200,null,null,null,null,null,"Overhead Min",1,"The min overhead"]
["Man Weeks",null,null,{"$f":"D26/40","v":0},{"$f":"E26/40","v":2.75},null,null,null,"Real-Time Retention",1600,null,null,null,null,null,"Overhead sliding factor",200,"used to calculate overhead based on dev hours"]
["Actual Weeks based on resources + 2 for Sprint0",{"$f":"MAX(PegaDevCnt+ClientDevCnt,1)","v":10.5},{"$f":"MAX(PegaDevCnt+ClientDevCnt,1)","v":10.5},{"$f":"ROUNDUP(D27/B28,0)+2","v":2},{"$f":"ROUNDUP(E27/C28,0)+2","v":3},null,null,null,"Real Time Web Personalization",1400]
["Robotics:",{"$f":"'Project Attributes'!$D$19","v":"No"},{"$f":"'Project Attributes'!$D$19","v":"No"},{"$f":"IF(Adjustments[[#This Row],[Column2]]=\"Yes\",$J$19,0)","v":0},{"$f":"IF(Adjustments[[#This Row],[Column3]]=\"Yes\",$J$19,0)","v":0},null,null,null,"DSM Flag",{"$f":"NOT(DSMpkg = \"None\")","v":false}]
["Full Time PO",{"$f":"Staffing!$E$12","v":1},{"$f":"Staffing!$E$12","v":1},{"$f":"Adjustments[[#This Row],[Column2]]*$D$28*40","v":80},{"$f":"Adjustments[[#This Row],[Column3]]*$E$28*40","v":120},null,null,null,null,null,null,null,null,null,null,"Auto Assumptions"]
["Full Time EL",{"$f":"Staffing!$E$2","v":1},{"$f":"Staffing!$E$2","v":1},{"$f":"Adjustments[[#This Row],[Column2]]*$D$28*40","v":80},{"$f":"Adjustments[[#This Row],[Column3]]*$E$28*40","v":120},null,null,null,null,null,null,null,null,null,null,"Parameter","Option","Assumption"]
["10% PL (per EL)",{"$f":"B31","v":1},{"$f":"C31","v":1},{"$f":"D28*4*Adjustments[[#This Row],[Column2]]","v":8},{"$f":"E28*4*Adjustments[[#This Row],[Column3]]","v":12},null,null,null,null,null,null,null,null,null,null,"Robotics","Yes","Controlled enablement process which produces specific outcomes in a 10-12 week period.  The journey includes: Delivery of 1 - 3 high-value (medium complexity) automations, ability to support in real world environment, foundation to expand what was built, and “Bucket” of post go-live support hours"]
["Total",null,null,{"$f":"SUM(D29:D32)+D26","v":168},{"$f":"SUM(E29:E32)+E26","v":362}]
["Pega Hours",null,null,{"$f":"MAX(SUM(PegaDevCnt*40*D28,D31,D32,D29),0)","v":448},{"$f":"MAX(SUM(PegaDevCnt*40*E28,E31,E32,E29),0)","v":672}]
["Client Hours",null,null,{"$f":"SUM(ClientDevCnt*40*D28,D32)","v":488},{"$f":"SUM(ClientDevCnt*40*E28,E32)","v":732},null,null,null,null,null,null,null,null,null,null,"Marketing and Decisioning","Real-Time Cross-Sell Up Sell","In about 10 weeks your agents will be providing optimal upsell & cross-sell offers to your customers - with no disruption to your current business, and with minimal IT resource investment on your part. For more info go here: https://saleshub.pega.com/resources/pega-quick-win-packages"]
[]
["Range",0.9,1.3,{"$f":"IF(Adjustments[[#Totals],[Column4]]=Adjustments[[#Totals],[Column5]],B37,0.8)","v":0.8},{"$f":"IF(Adjustments[[#Totals],[Column4]]=Adjustments[[#Totals],[Column5]],C37,1.4)","v":1.4}]
["Project Estimate","MLP Low","MLP High","Full Low","Full High",null,null,null,null,null,null,null,null,null,null,null,"Real-Time Retention","In about 10 weeks your agents will be providing optimal retention offers to your customers - with no disruption to your current business, and with minimal IT resource investment on your part. For more info go here: https://saleshub.pega.com/resources/pega-quick-win-packages"]
["Duration in Weeks",{"$f":"MAX(ROUNDUP(D28*$B$37,0),1, IF(B29=\"Yes\",L19))","v":2},{"$f":"MAX(ROUNDUP(D28*$C$37,0),1+Table18[[#This Row],[MLP Low]], IF(B29=\"Yes\",L19))","v":3},{"$f":"MAX(ROUNDUP(E28*$D$37,0),1, IF(C29=\"Yes\",L19))","v":3},{"$f":"MAX(ROUNDUP(E28*$E$37,0),1+Table18[[#This Row],[Full Low]], IF(C29=\"Yes\",L19))","v":5}]
["Pega Hours",{"$f":"ROUNDUP(D34*$B$37,-2)","v":500},{"$f":"ROUNDUP(D34*$C$37,-2)","v":600},{"$f":"ROUNDUP(E34*$D$37,-2)","v":600},{"$f":"ROUNDUP(E34*$E$37,-2)","v":1000}]
["Client Hours",{"$f":"ROUNDUP(D35*$B$37,-2)","v":500},{"$f":"ROUNDUP(D35*$C$37,-1)","v":640},{"$f":"ROUNDUP(E35*$D$37,-2)","v":600},{"$f":"ROUNDUP(E35*$E$37,-1)","v":1030},null,null,null,null,null,null,null,null,null,null,null,"Real Time Web Personalization","In about 10 weeks you will implement 1-1 Next Best Action personalization on your webpages - with no disruption to your current business, and with minimal IT resource investment on your part. For more info go here: https://saleshub.pega.com/resources/pega-quick-win-packages"]
[null,{"$f":"SUM(B40:B41)","v":1000},{"$f":"SUM(C40:C41)","v":1240},{"$f":"SUM(D40:D41)","v":1200},{"$f":"SUM(E40:E41)","v":2030}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special QuickWin Pacakges"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flag","Name","Item Maturity","Type","Complexity","Release","Iteration","Web","Call Center","Mobile","Blank","Other ","Override"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table9[[#This Row],[Override]]>0","v":false},"Robotics","New","Epic","Low","R1",null,null,null,null,null,null,{"$f":"E29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table9[[#This Row],[Override]]>0","v":false},{"$f":"\"DSM - \" &DSMpkg","v":"DSM - None"},"New","Epic","Low","R1",null,null,null,null,null,null,{"$f":"E22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Table9[Flag],TRUE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Table9[Override],\">\"&0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Contingencies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flag","Name","Export Name","Percent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Delivery Methodology:","Non Scrum",{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Scrum Maturity:",{"$f":" \"Scrum maturity: \" & C17","v":"Scrum maturity: High"},{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Pega Cloud / Existing On-Prem Instance:","New On-Prem implementation",{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Data Import/Conversion Required:",{"$f":" \"Data Conversion: \"&C19","v":"Data Conversion: None"},{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]*VLOOKUP(B19,Dropdowns!$D$19:$E$22,2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Localization (Enter # of additional languages):",{"$f":"\"Additional languages: \"& C20","v":"Additional languages: 0"},{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Highly Regulated or Complex Company:","Highly Regulated or Complex Company",{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Table11[[Parameter]:[Effort Factor]],3,0)*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table4[[#This Row],[Name]],Attributes[],5,0)>0","v":false},"Other Contingencies (QA, Risk, etc.):","Other Contingencies (QA, Risk, etc.)",{"$f":"C23*Table4[[#This Row],[Flag]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Table4[Flag], TRUE)","v":0},null,null,{"$f":"SUBTOTAL(109,Table4[Percent])","v":0}]

{"sheet":"Staffing","index":13,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,7,0,14]]}
["Pega/Partner","Role","Amt","NumScrumTeams","Total","Text",null,"Export"]
["Pega","EL",0.5,{"$f":"NumScrumTeams","v":1},{"$f":"IF(RoboticsOnlyClient, Table7[[#This Row],[Amt]], MAX(ROUNDUP(D2*C2,0),1))","v":1},{"$f":"IF(E2>0,IF(E2<1, VLOOKUP(Table7[[#This Row],[Total]],Table6[],2,0),E2)& \" \"&B2&\", \",\"\")","v":"1 EL, "},null,"Cnt","CTB Name","Scrum Role","Source","Role","PT %","Productivity","Allocation to Dev"]
["Pega","(L/S)BA",1,{"$f":"IF(OR(RoboticsOnlyClient,DSM_OnlyClient),0,NumScrumTeams)","v":1},{"$f":"D3*C3","v":1},{"$f":"IF(E3>0,IF(E3<1, VLOOKUP(Table7[[#This Row],[Total]],Table6[],2,0),E3)& \" \"&B3&\", \",\"\")","v":"1 (L/S)BA, "},null,1,"PL","Other (non-Dev)",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Practice Leader",0.1,1,0]
["Pega","LSA",1,{"$f":"_xlfn.IFS(DSM_OnlyClient,1,RoboticsOnlyClient,0,NOT(AND(RoboticsOnlyClient,DSM_OnlyClient)), NumScrumTeams)","v":1},1,{"$f":"IF(E4>0,IF(E4<1, VLOOKUP(Table7[[#This Row],[Total]],Table6[],2,0),E4)& \" \"&B4&\", \",\"\")","v":"1 LSA, "},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0)","v":1},"EL","Scrum Master",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Engagement Leader",1,1,0]
["Pega","(S)SA",{"$f":"IF(CoProdFlag, 2, 3)","v":2},{"$f":"IF(OR(RoboticsOnlyClient,DSM_OnlyClient),0,NumScrumTeams)","v":1},2,{"$f":"IF(E5>0,IF(E5<1, VLOOKUP(Table7[[#This Row],[Total]],Table6[],2,0),E5)& \" \"&B5&\", \",\"\")","v":"2 (S)SA, "},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0)","v":1},"(L/S)BA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"(L/S) Business Architect",1,1,0.5]
["Pega","UX/UI",0.5,{"$f":"IF(OR(RoboticsOnlyClient,DSM_OnlyClient),0,NumScrumTeams)","v":1},0.5,{"$f":"IF(E6>0,IF(E6<1, VLOOKUP(Table7[[#This Row],[Total]],Table6[],2,0),E6)& \" \"&B6&\", \",\"\")","v":"½ UX/UI, "},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0)","v":1},"LSA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Lead System Architect",1,1,{"$f":"IF(CoProdFlag, 0.6, 1)","v":0.6}]
[null,null,null,"Total Dev Team",{"$f":"SUBTOTAL(109,Table7[Total])-E2","v":4.5},{"$f":"IF(RoboticsOnlyClient=FALSE,NumScrumTeams&\" Scrum Team\"&IF(NumScrumTeams>1,\"s\",\"\")&\": \",\"\")&IFERROR(LEFT(F2&F3&F4&F5&F6,LEN(F2&F3&F4&F5&F6)-2),\"\"\"\")","v":"1 Scrum Team: 1 EL, 1 (L/S)BA, 1 LSA, 2 (S)SA, ½ UX/UI"},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0)","v":2},"(S)SA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"(Sr) System Architect",1,1,1]
[null,null,null,"Total Dev incl. DSM",{"$f":"Table7[[#Totals],[Total]]+(DSM_OnlyClient*Table53[[#Totals],[Amt]])","v":4.5},null,null,{"$f":"ROUNDUP(VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0),0)","v":1},"UX/UI","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Experience Designer",{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table7[[Role]:[Total]],4,0)","v":0.5},1,1]
[null,null,null,null,null,null,null,{"$f":"IF(RobotFlag=\"Yes\", ROUNDUP(VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0),0),0)","v":0},"LRBA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Lead Robotics BA",{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0)","v":0.33},1,1]
[null,null,null,null,null,null,null,{"$f":"IF(RobotFlag=\"Yes\", ROUNDUP(VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0),0),0)","v":0},"LRSA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Lead Robotics SA",{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0)","v":0.5},1,1]
["Client","Role","Amt","NumScrumTeams","Total","Text",null,{"$f":"IF(RobotFlag=\"Yes\", ROUNDUP(VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0),0),0)","v":0},"(S)RSA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"(Sr) Robotics SA",{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table5[[Robot Resource]:[Amt]],2,0)","v":1},1,1]
["Client","Product Owner",0.5,{"$f":"NumScrumTeams","v":1},{"$f":"IF(RoboticsOnlyClient,Table8[[#This Row],[Amt]],MAX(ROUNDUP(D12*C12,0),1))","v":1},{"$f":"IF(E12>0,IF(E12<1, VLOOKUP(Table8[[#This Row],[Total]],Table6[],2,0),E12)& \" \"&B12&\", \",\"\")& CHAR(10)","v":"1 Product Owner, \n"},null,{"$f":"IF(DSMFlag, VLOOKUP(Table414[[#This Row],[CTB Name]],Table53[[DSM]:[Amt]],2,0),0)","v":0},"LDA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Lead Decisioning Architect",1,1,1]
["Client","Test Lead",1,{"$f":"IF(OR(RoboticsOnlyClient,DSM_OnlyClient),0,NumScrumTeams)","v":1},{"$f":"D13*C13","v":1},{"$f":"IF(E13>0,IF(E13<1, VLOOKUP(Table8[[#This Row],[Total]],Table6[],2,0),E13)& \" \"&B13&\", \",\"\")","v":"1 Test Lead, "},null,{"$f":"IF(DSMFlag, VLOOKUP(Table414[[#This Row],[CTB Name]],Table53[[DSM]:[Amt]],2,0),0)","v":0},"SDA","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Sr. Decisioning Architect",1,1,1]
["Client","Tester",2,{"$f":"_xlfn.IFS(DSM_OnlyClient,0.5,RoboticsOnlyClient,0,NOT(AND(RoboticsOnlyClient,DSM_OnlyClient)), NumScrumTeams)","v":1},{"$f":"MAX(D14*C14,1)","v":2},{"$f":"IF(E14>0,IF(E14<1, VLOOKUP(Table8[[#This Row],[Total]],Table6[],2,0),E14)& \" \"&B14&\", \",\"\")","v":"2 Tester, "},null,{"$f":"IF(DSMFlag, VLOOKUP(Table414[[#This Row],[CTB Name]],Table53[[DSM]:[Amt]],2,0),0)","v":0},"Mktg & Dec Bus Consultant","Team Member",{"$f":"'Reference Sizing'!$P$7","v":"Pega"},"Mktg & Dec Bus Consultant",1,1,1]
["Client","Pega Certified BA",1,{"$f":"IF(OR(RoboticsOnlyClient,DSM_OnlyClient),0,NumScrumTeams)","v":1},{"$f":"IF(CoProdFlag, ROUNDUP(D15*C15,0),0)","v":1},{"$f":"IF(E15>0,IF(E15<1, VLOOKUP(Table8[[#This Row],[Total]],Table6[],2,0),E15)& \" \"&B15&\", \",\"\")","v":"1 Pega Certified BA, "},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table8[[Role]:[Total]],4,0)","v":1},"Product Owner","Other (non-Dev)","Client","Product Owner",1,1,0]
["Client ","Pega Certified SA",2,{"$f":"_xlfn.IFS(DSM_OnlyClient,0.5,RoboticsOnlyClient,0,NOT(AND(RoboticsOnlyClient,DSM_OnlyClient)), NumScrumTeams)","v":1},{"$f":"IF(CoProdFlag, ROUNDUP(D16*C16,0),0)","v":2},{"$f":"IF(E16>0,IF(E16<1, VLOOKUP(Table8[[#This Row],[Total]],Table6[],2,0),E16)& \" \"&B16&\", \",\"\")","v":"2 Pega Certified SA, "},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table8[[Role]:[Total]],4,0)","v":1},"Test Lead","Team Member","Client","Test Lead",1,1,1]
[null,null,null,"Total Dev Team",{"$f":"SUBTOTAL(109,Table8[Total])-E12","v":6},{"$f":"IFERROR(LEFT(F12&F13&F14&F15&F16, LEN(F12&F13&F14&F15&F16)-2),\"\")","v":"1 Product Owner, \n1 Test Lead, 2 Tester, 1 Pega Certified BA, 2 Pega Certified SA"},null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table8[[Role]:[Total]],4,0)","v":2},"Tester","Team Member","Client","Tester",1,1,1]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table8[[Role]:[Total]],4,0)","v":1},"Pega Certified BA","Team Member","Client","Business Architect",1,0.4,1]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(Table414[[#This Row],[CTB Name]],Table8[[Role]:[Total]],4,0)","v":2},"Pega Certified SA","Team Member","Client","System Architect",1,0.4,1]
["AMT","Text",null,"Robot Resource","Amt","text",null,{"$f":"SUBTOTAL(109,Table414[Cnt])","v":14}]
[0.25,"¼",null,"LRBA",0.33,{"$f":"IF(Table5[[#This Row],[Amt]]<1,VLOOKUP(Table5[[#This Row],[Amt]],Table6[],2,0),Table5[[#This Row],[Amt]])&\" \"&Table5[[#This Row],[Robot Resource]]&\", \"","v":"⅓ LRBA, "}]
[0.33,"⅓",null,"LRSA",0.5,{"$f":"IF(Table5[[#This Row],[Amt]]<1,VLOOKUP(Table5[[#This Row],[Amt]],Table6[],2,0),Table5[[#This Row],[Amt]])&\" \"&Table5[[#This Row],[Robot Resource]]&\", \"","v":"½ LRSA, "}]
[0.5,"½",null,"(S)RSA",1,{"$f":"IF(Table5[[#This Row],[Amt]]<1,VLOOKUP(Table5[[#This Row],[Amt]],Table6[],2,0),Table5[[#This Row],[Amt]])&\" \"&Table5[[#This Row],[Robot Resource]]&\", \"","v":"1 (S)RSA, "}]
[0.67,"⅔",null,"Pega Partner",{"$f":"SUBTOTAL(109,Table5[Amt])","v":1.83},{"$f":"IFERROR(\"Robotics: \"& LEFT(F21&F22&F23, LEN(F21&F22&F23)-2),\"\")","v":"Robotics: ⅓ LRBA, ½ LRSA, 1 (S)RSA"}]
[0.75,"¾",null,"Robotics Only",null,{"$f":"AND(RobotFlag=\"Yes\", Calculations!E13=0)","v":false}]
[]
[]
[null,null,null,"DSM","Amt","text"]
[null,null,null,"LDA",1,{"$f":"IFERROR(IF(Table53[[#This Row],[Amt]]<1,VLOOKUP(Table53[[#This Row],[Amt]],Table6[],2,0),Table53[[#This Row],[Amt]])&\" \"&Table53[[#This Row],[DSM]]&\", \",\"\")","v":"1 LDA, "}]
[null,null,null,"SDA",1,{"$f":"IFERROR(IF(Table53[[#This Row],[Amt]]<1,VLOOKUP(Table53[[#This Row],[Amt]],Table6[],2,0),Table53[[#This Row],[Amt]])&\" \"&Table53[[#This Row],[DSM]]&\", \",\"\")","v":"1 SDA, "}]
[null,null,null,"Mktg & Dec Bus Consultant",0,{"$f":"IFERROR(IF(Table53[[#This Row],[Amt]]<1,VLOOKUP(Table53[[#This Row],[Amt]],Table6[],2,0),Table53[[#This Row],[Amt]])&\" \"&Table53[[#This Row],[DSM]]&\", \",\"\")","v":""}]
[null,null,null,"Pega Partner",{"$f":"SUBTOTAL(109,Table53[Amt])","v":2},{"$f":"IFERROR(\"DSM: \"& LEFT(F29&F30&F31, LEN(F29&F30&F31)-2),\"\")","v":"DSM: 1 LDA, 1 SDA"}]
[null,null,null,"Marketing Only",null,{"$f":"AND(DSMFlag, Calculations!E13=0)","v":false}]

{"sheet":"ExportScrumSizing","index":14,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Client/Organization",{"$f":"IF(ClientName<>\"\",ClientName,\"\")","v":""}]
["Project",{"$f":"IF('Project Summary'!I5<>\"\",'Project Summary'!I5,\"\")","v":""}]
[]
["Area","Grouping"]
["AP ID"]
["AP Mode"]
["AP Label"]
[]
["WT/UC Section",{"$f":"MAX(Calculations!C4,2)+Table9[[#Totals],[Flag]]","v":2},"Name","Item Maturity","Type","Complexity","Release","Iteration","Web","Call Center","Mobile","Blank","Other ","Override"]
["WT/UC Section",1]
["WT/UC Section",1]
["Interfaces Section",{"$f":"MAX(SUM(Calculations!C8:C9),2)","v":2},"Name","Type","Complexity","Data source Exists","# Interchanges","Hrs Per Interchange","Release","Iteration","Business Impact"]
["Interfaces Section",1,null,"<Select>","<Select>","<Select>",null,null,"R5"]
["Interfaces Section",1,null,"<Select>","<Select>","<Select>",null,null,"R5"]
["Reports/Corr Section",{"$f":"MAX(Calculations!C11,2)","v":2},"Name","Type","Business Impact","Complexity","Release","Business Impact","R5"]
["Reports/Corr Section",1]
["Reports/Corr Section",1]
["Staff Section",{"$f":"MAX(Table414[[#Totals],[Cnt]],2)","v":14},"Name","<Select>","<Select>","<Select>",null,null,"R5"]
["Staff Section",1,"Other (non-Dev)","Pega","Practice Leader",0.1,1,0]
["Staff Section",1,"Scrum Master","Pega","Engagement Leader",1,1,0]
["Staff Section",1,"Team Member","Pega","(L/S) Business Architect",1,1,0.5]
["Staff Section",1,"Team Member","Pega","Lead System Architect",1,1,0.6]
["Staff Section",1,"Team Member","Pega","(Sr) System Architect",1,1,1]
["Staff Section",1,"Team Member","Pega","(Sr) System Architect",1,1,1]
["Staff Section",1,"Team Member","Pega","Experience Designer",0.5,1,1]
["Staff Section",1,"Other (non-Dev)","Client","Product Owner",1,1,0]
["Staff Section",1,"Team Member","Client","Test Lead",1,1,1]
["Staff Section",1,"Team Member","Client","Tester",1,1,1]
["Staff Section",1,"Team Member","Client","Tester",1,1,1]
["Staff Section",1,"Team Member","Client","Business Architect",1,0.4,1]
["Staff Section",1,"Team Member","Client","System Architect",1,0.4,1]
["Staff Section",1,"Team Member","Client","System Architect",1,0.4,1]
["Other Section",{"$f":"MAX(OtherRowCnt,2)","v":2},"Parameter","Percent"]
["Other Section",1]
["Other Section",1]

{"sheet":"Dropdowns","index":15,"n_rows":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,30,0,31]]}
["Release",null,null,"LMH",null,null,"Priority",null,"Interfaces",null,"Complexity",null,null,"Interface Type",null,"Connector Type",null,"Service Type",null,"Select",null,"All",null,"App Maturity",null,null,"Methodology",null,"Channels",null,"Project Lead",null,null,"Pega Version",null,"Staffing Model",null,"Fibonacci"]
["<Select>",0,null,"<Select>",0,null,"<Select>",null,"<Select>",null,"<Select>",0,null,"<Select>",null,"<Select>",null,"<Select>",null,"<Select>",null,"All",null,"<Select>",0,null,"Agile/Scrum",null,0,null,"<Select>",null,null,"<Select>",null,"<Select>",null,1]
["MLP1",1,null,"Low",2,null,1,null,"Existing",1,"OOTB",1,null,"Connector",null,"Connect Adobe PDF",null,"Service Adobe PDF",null,null,null,null,null,"High Maturity Strategic App",1,null,"Waterfall/Other",null,0.25,null,"Co-Production","CoProdStaff",null,8.5,null,"Pega Led",null,2]
["MLP2",2,null,"Medium",3,null,2,null,"New",2,"Low",2,null,"Service",null,"Connect BPEL",null,"Service BPEL",null,null,null,null,null,"Medium Maturity Strategic App",2,null,null,null,0.5,null,"Non-Co-Production","PegaLedStaff",null,8.4,null,"Partner Led",null,{"$f":"AL3+AL2","v":3}]
["MLP3",3,null,"High",4,null,3,null,null,3,"Medium",3,null,null,null,"Connect CMIS",null,"Service COM",null,null,null,null,null,"Low Maturity Strategic App",3,null,null,null,0.75,null,null,null,null,"8.3",null,"<Select>",null,5]
["MLP4",4,null,null,null,null,4,null,null,4,"High",4,null,null,null,"Connect dotNet",null,"Service CORBA",null,null,null,null,null,"Mix of Strat App & Platform",4,null,null,null,1,null,null,null,null,"8.2",null,"Pega Led / Client Co-Prod",null,8]
["Future",5,null,null,null,null,5,null,null,5,"Complex",5,null,null,null,"Connect Directed Web Access",null,"Service dotNet",null,null,null,null,null,"100% Platform",5,null,null,null,null,null,null,null,null,"8.1",null,"Partner Led / Client Co-Prod",null,13]
[null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,"Connect EJB",null,"Service EJB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.x",null,null,null,21]
[null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,"Connect File",null,"Service Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff Aug",null,34]
[null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,"Connect FTP",null,"Service File",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pega Advisory Services"]
[null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,"Connect HTTP",null,"Service Http"]
[null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,"Connect Java",null,"Service Java"]
[null,null,1,"OOTB",null,null,null,null,null,null,null,null,null,null,null,"Connect JCA",null,"Service JMS"]
[null,null,2,"Low",null,null,null,null,null,null,null,null,null,null,null,"Connect JMS",null,"Service JSR94"]
[null,null,3,"Medium",null,null,null,null,null,null,null,null,null,null,null,"Connect MQ",null,"Service MQ"]
[null,null,4,"High",null,null,null,null,null,null,null,null,null,null,null,"Connect PegaDISTRIBUTION Manager",null,"Service Pegasystems SnapStart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connect PegaIMAGE Manager",null,"Service Portlet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connect REST",null,"Service REST"]
[null,null,null,"None",0,null,null,null,null,null,null,null,null,null,null,"Connect SAP",null,"Service SAP"]
[null,null,null,"Low",1,null,null,null,null,null,null,null,null,null,null,"Connect SAPJCo",null,"Service SAPJCo"]
[null,null,null,"Medium",2,null,null,null,null,null,null,null,null,null,null,"Connect SOAP",null,"Service SOAP"]
[null,null,null,"High",3,null,null,null,null,null,null,null,null,null,null,"Connect SQL",null,"PegaCALL for PegaRULES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",null,"Unknown"]

{"sheet":"Tabs","index":16,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Navigation Order","Modified","Tab Name",null,"Context Menu"]
[{"$f":"MID(CELL(\"filename\",'Project Summary'!$A$1),FIND(\"]\",CELL(\"filename\",'Project Summary'!$A$1))+1,25)","v":"Project Summary"},false,null,null,{"$f":"MID(CELL(\"filename\",Microjourneys!$A$1),FIND(\"]\",CELL(\"filename\",Microjourneys!$A$1))+1,25)","v":"Microjourneys"}]
[{"$f":"MID(CELL(\"filename\",Interfaces!$A$1),FIND(\"]\",CELL(\"filename\",Interfaces!$A$1))+1,25)","v":"Interfaces"},false,{"$f":"IF(B3, MID(A3,4,100) & \", \",\"\")","v":""},null,{"$f":"MID(CELL(\"filename\",'Case Types'!$A$1),FIND(\"]\",CELL(\"filename\",'Case Types'!$A$1))+1,25)","v":"Case Types"}]
[{"$f":"MID(CELL(\"filename\",Personas!$A$1),FIND(\"]\",CELL(\"filename\",Personas!$A$1))+1,25)","v":"Personas"},false,"",null,{"$f":"MID(CELL(\"filename\",'Supporting Features'!$A$1),FIND(\"]\",CELL(\"filename\",'Supporting Features'!$A$1))+1,25)","v":"Supporting Features"}]
[{"$f":"MID(CELL(\"filename\",'Case Types'!$A$1),FIND(\"]\",CELL(\"filename\",'Case Types'!$A$1))+1,25)","v":"Case Types"},false,"",null,{"$f":"MID(CELL(\"filename\",Interfaces!$A$1),FIND(\"]\",CELL(\"filename\",Interfaces!$A$1))+1,25)","v":"Interfaces"}]
[{"$f":"MID(CELL(\"filename\",'Supporting Features'!$A$1),FIND(\"]\",CELL(\"filename\",'Supporting Features'!$A$1))+1,25)","v":"Supporting Features"},false,"",null,{"$f":"MID(CELL(\"filename\",Personas!$A$1),FIND(\"]\",CELL(\"filename\",Personas!$A$1))+1,25)","v":"Personas"}]
[{"$f":"MID(CELL(\"filename\",Reports!$A$1),FIND(\"]\",CELL(\"filename\",Reports!$A$1))+1,25)","v":"Reports"},false,"",null,{"$f":"MID(CELL(\"filename\",Reports!$A$1),FIND(\"]\",CELL(\"filename\",Reports!$A$1))+1,25)","v":"Reports"}]
[{"$f":"MID(CELL(\"filename\",'Project Attributes'!$A$1),FIND(\"]\",CELL(\"filename\",'Project Attributes'!$A$1))+1,25)","v":"Project Attributes"},false,""]
[null,{"$f":"OR(B3:B8)","v":false},{"$f":"IFERROR(LEFT(C2&C3&C4&C5&C6&C7&C8, LEN(C2&C3&C4&C5&C6&C7&C8)-2),\"\")","v":""}]
["WorkFlag",true]