{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Basic Instructions","Application Information","SNAP Counting Sheet","Recap","Parameters"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":34,"comments":1,"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":"Basic Instructions","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,1,10,15],[11,1,11,15],[12,1,12,15],[13,1,13,15],[7,1,7,15],[9,1,9,15],[25,1,25,8],[15,1,15,15],[18,1,18,15],[19,1,19,15],[20,2,20,15],[16,1,16,15],[17,1,17,15],[14,1,14,15],[21,2,21,15],[22,2,22,15],[23,1,23,15],[24,1,24,15]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BASIC INSTRUCTIONS FOR SNAP COUNTERS"]
[null,"Please scroll down this worksheet to read all basic instructions.\nYou can modify this tool by writing to NFSSC@IFPUG.COM: \nIFPUG/NFSSC will provide you with the password to unprotect the spreadsheets. You are welcome to send your changes to IFPUG / NFSSC so that other users may benefit from your improvements."]
[null,null,null,null,null,"Mail to:","nfssc@ifpug.com"]
[1,"Collect SNAP points at the application boundary level, and report the work effort to build those SNAP points corresponding to the same application boundary.  This is the application boundary as defined under function points."]
[null,"Do not enter data in any column or cell that has red font; the numbers in these columns are calculated automatically.  "]
[null,"NOTE:  notional (example) information is entered into the first row of data in the \"SNAP Counting Sheet.\"  This is for illustration purposes; delete this before starting."]
[null,"Only Insert / Add rows from the \"SNAP Counting Sheet\" using the buttons at the top left of the worksheet (make sure Excel macros are enabled)."]
[2,"Enter the work effort required to deliver the SNAP nonfunctionality.  Enter work effort in terms of \"person-hours.\"  If you have effort "]
[null,"collected in terms of other units, please first convert these into person-hours according to what is applicable in your organization."]
[3,"Enter the work effort for each category as indicated on the \"SNAP Counting Sheet.\"  For example, enter the work effort required for Category 1 in column W.  If you are not able to enter work effort by category, then enter the total work effort in the \"Application Metrics\" section of the \"Application Information\" worksheet."]
[4,"If the work effort you report either here, or on the \"SNAP Counting Sheet,\" is estimated rather than being exact numbers, then indicate this in the \"Application Metrics\" section of the \"Application Information\" worksheet. "]
[5,"If your work effort is estimated, provide an idea of the estimate's margin of error, in percentage points.  For example, if the work effort reported here is believed accurate to within approximately 15% of the actual man-hours expended, enter \"15%.\"  Enter this in the \"Application Metrics\" section of the \"Application Information\" worksheet."]
[6,"Enter as much other information into the \"Application Information\" worksheet.  Note that many of the data fields are drop down boxes; click to the right of each field to check."]
[null,"In the \"Application Information,\" use the following definitions for the type of project being counted."]
[null,null,"New Development -- building a new software product in a context where the  customer has no existing product meeting their requirements."]
[null,null,"Re-development -- creating a software product with new technology that  replaces or enhances a product that customers currently use."]
[null,null,"Enhancement -- changing or extending the functionality of an existing product."]
[7,"If you have function point data corresponding to your SNAP count application, then enter the function point count and the GSC total (if used) in the \"Application Information\" worksheet, \"Functional Size Information (Optional!)\" section.  Function point counts with GSC's are encouraged but are optional."]
[8,"Please use a separate spreadsheet file for each application boundary counted.  Please do not enter more than one application in each file."]
[null,"Make sure that all data relates only to the application boundary being considered"]

{"sheet":"Application Information","index":1,"n_rows":131,"n_cols":8,"rows_kept":131,"cut":false,"hidden":false,"merged":[[130,1,130,7],[83,1,83,2],[103,2,103,7],[109,2,109,5],[127,1,127,7],[37,4,37,6],[75,5,75,6],[80,1,80,2],[129,1,129,7],[43,1,44,1],[36,1,36,2],[12,1,12,7],[70,4,71,6],[47,2,47,4],[48,2,48,4],[56,1,56,7],[22,4,22,6],[28,4,28,6],[39,4,39,6],[62,1,62,7],[59,1,59,7],[32,4,32,6],[24,4,27,6],[29,7,31,7],[35,4,35,6],[36,4,36,6],[5,1,5,2],[72,1,72,2],[74,1,74,2],[74,5,74,6],[44,2,44,3],[23,1,23,2],[28,1,28,2],[41,4,41,6],[29,1,31,2],[32,1,32,2],[37,1,37,2],[33,1,33,2],[35,1,35,2],[33,4,33,6],[34,1,34,2],[34,4,34,6]]}
[]
[]
[]
[]
[null,"Name:"]
[]
[]
[]
[]
[]
[]
[null,"Application name:"]
[]
[]
[]
[]
[]
[]
[]
[null,"What type of project count is being conducted?",null,null,"Application implementation date:"]
[]
[]
[null,"Specify here if \"other\":",null,null,"Application development duration, months:"]
[]
[null,"What type of lifecycle is used?"]
[]
[]
[null,"Specify here if \"other\":"]
[]
[null,"What was the primary technology used to build/enhance the software; i.e.,  that used for most of the build effort?",null,null,null,null,null,"Was it used for the entire application?"]
[]
[null,null,null,null,"Specify here"]
[null,"Operating System "]
[null,"Programming Language"]
[null,"HTML/Web Server"]
[null,"Database"]
[null,"Environment"]
[]
[null,"Industry:",null,null,"Specify here if \"other\":"]
[]
[null,"Architecture:",null,null,"Specify here if \"other\":"]
[]
[]
[null,"What type of software application is being produced or enhanced?"]
[]
[null,null,null,null,null,null,{"$f":"NOT(OR(G48<0,G49<0,G48>100,G49>100,SUM(G48:G49)>100,NOT(OR(ISNUMBER(G48),ISBLANK(G48))),NOT(OR(ISNUMBER(G49),ISBLANK(G49)))))","v":true}]
[null,"Programming Languages",null,null,null,null,"% of software created/enhanced:"]
[null,"Primary",null,null,null,null,null,"%"]
[null,"Secondary",null,null,null,null,null,"%"]
[]
[]
[]
[]
[]
[]
[null,"Application description:"]
[]
[]
[null,"SNAP  scope:"]
[]
[]
[null,"SNAP  purpose:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FP counting standard: ",null,null,"Unadjusted function point:"]
[null,"Specify here if \"other\":"]
[null,null,null,null,"VAF"]
[null,"Specify if addendum to standard:",null,null,"Adjusted function point:"]
[]
[]
[null,"How much effort was devoted to developing the function points (in person-hours)?"]
[]
[]
[null,"After which of the following activities was this function point count performed?"]
[]
[]
[null,"What training had the function point counter under gone?"]
[]
[]
[]
[]
[]
[]
[null,"Data for the effort or people involved in the project: "]
[null,null,"Project personagement:",null,null,null,"Testing:"]
[]
[null,null,"Requirements elicitation:",null,null,null,"Quality Assurance:"]
[]
[null,null,"Software architect:",null,null,null,"End User Training:"]
[]
[null,null,"User Interface design:",null,null,null,"Database administration:"]
[]
[null,null,"Graphic Art / Design:"]
[]
[null,null,"Development/ Programming:",null,null,null,"IT System administration:"]
[]
[null,null,"Other: (Please specify below):"]
[]
[]
[null,"What procedure, if any, was used to record effort spent on in the project?"]
[]
[]
[null,null,"Other: (Please specify):"]
[]
[]
[null,"How much effort was devoted to developing the SNAP points (in person-hours) for the application (enter data here"]
[null,"only if SNAP work effort can not be provided by category on the \"SNAP Counting Sheet.\")"]
[]
[]
[null,"Is the SNAP work effort provided either here or on the \"SNAP Counting Sheet\" estimated?"]
[]
[]
[null,"If so, what is the approximate margin of error (in percentage terms) on the work effort?"]
[null,null,null,"%"]
[]
[]
[]
[]
[]
[]
[null,"Comments:"]
[]
[]
[null,"© 2017 IFPUG. All Rights Reserved. International Function Point Users Group, 2010. "]
[null,"This material is considered to be complementary to the IFPUG SNAP Assessment Practices personual and as such part of this personual."]

{"sheet":"SNAP Counting Sheet","index":2,"n_rows":54,"n_cols":67,"rows_kept":54,"cut":false,"hidden":false,"merged":[[3,39,6,39],[3,61,6,61],[4,54,4,55],[5,35,6,35],[3,35,3,37],[4,12,4,13],[4,15,4,17],[4,28,4,29],[3,54,3,55],[3,56,6,56],[3,15,3,17],[5,1,6,1],[3,0,6,0],[3,3,3,5],[3,6,6,6],[4,3,4,5],[5,4,6,4],[5,8,6,8],[2,54,2,62],[3,12,3,13],[3,18,6,18],[3,22,6,22],[3,23,6,23],[3,38,6,38],[5,20,6,20],[5,36,6,36],[4,31,4,33],[4,35,4,37],[3,53,6,53],[5,50,6,50],[5,51,6,51],[3,52,6,52],[2,3,2,23],[3,27,6,27],[3,28,3,29],[5,2,6,2],[5,3,6,3],[5,5,6,5],[5,21,6,21],[3,31,3,33],[5,31,6,31],[5,32,6,32],[5,25,6,25],[3,11,6,11],[5,16,6,16],[3,7,3,10],[4,7,4,10],[5,10,6,10],[3,30,6,30],[5,7,6,7],[5,9,6,9],[3,19,3,21],[4,19,4,21],[5,19,6,19],[5,12,6,12],[5,13,6,13],[5,15,6,15],[5,17,6,17],[3,14,6,14],[2,24,2,37],[3,24,3,26],[4,24,4,26],[5,24,6,24],[5,33,6,33],[5,37,6,37],[5,29,6,29],[5,26,6,26],[5,28,6,28],[3,34,6,34],[2,40,2,53],[3,44,3,47],[4,44,4,47],[5,44,6,44],[5,45,6,45],[3,49,3,51],[4,49,4,51],[5,49,6,49],[3,43,6,43],[5,41,6,41],[3,48,6,48],[5,42,6,42],[5,46,6,46],[5,47,6,47],[3,40,3,42],[4,40,4,42],[5,40,6,40],[52,24,52,26],[53,24,53,26],[52,28,52,30],[53,28,53,30],[52,31,52,33],[53,31,53,33],[52,35,52,37],[53,35,53,37],[52,40,52,42],[53,40,53,42],[52,3,52,5],[53,3,53,5],[52,7,52,10],[53,7,53,10],[52,12,52,13],[53,12,53,13],[52,15,52,17],[53,15,53,17],[52,19,52,21],[53,19,53,21],[52,44,52,47],[53,44,53,47],[52,49,52,51],[53,49,53,51],[52,53,52,55],[53,53,53,55],[52,57,52,60],[53,57,53,60],[3,63,6,63],[5,54,6,54],[5,55,6,55],[5,58,6,58],[5,59,6,59],[3,57,3,60],[4,57,4,60],[5,57,6,57],[5,60,6,60],[3,62,6,62]]}
["SNAP COUNTING WORKSHEET"]
[null,null,null,{"$f":"COLUMN()-2","v":2},{"$f":"COLUMN()-2","v":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,51,52,53,54,55,56,57,58,59,60,61,62]
[null,null,null,"Category 1:  Data Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category 2:  Interface Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category 3:  Technical Environment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Category 4:  Architecture"]
["No.",null,"Sub-Category: ","1.1  Data Entry Validation",null,null,"Data Entry Validation SNAP Count","1.2  Logical and Mathematical\nOperations",null,null,null,"Logical and Mathematical\nOperations SNAP Count","1.3  Data Formatting",null,"Data Formatting SNAP Count","1.4  Internal Data Movements",null,null,"Internal Data Movements SNAP Count","1.5  Delivering Added Value to Users by Data Configuration",null,null,"Delivering Functionality by Data Configuration SNAP Count","Data Operations Effort in Person-Hours","2.1  UI Changes",null,null,"UI Changes SNAP Count","2.2  Help Methods",null,"Help Methods SNAP Count","2.3  Multiple Input Methods",null,null,"Multiple Input Methods SNAP Count","2.4  Multiple Output Methods",null,null,"Multiple Output Methods SNAP Points","Interface Design Effort in Person-Hours","3.1  Multiple Platforms",null,null,"Multiple Platforms SNAP Points","3.2  Database Technology",null,null,null,"Database Technology SNAP Points","3.3  Batch Processes",null,null,"Batch Processes SNAP Points","Technical Environment Effort in Person-Hours","4.1  Component Based Software",null,"Component-based Software SNAP Points","4.2  Multiple Input / Output Interfaces",null,null,null,"Multiple Input / Output Interfaces SNAP Count","Architecture Effort in Person-Hours","Comments"]
[null,null,"SCU Definition: ","SCU=The Functional Elementary Process",null,null,null,"SCU=The Functional Elementary Process",null,null,null,null,"SCU=The Functional Elementary Process",null,null,"SCU=The Functional Elementary Process",null,null,null,"SCU=The Functional Elementary Process",null,null,null,null,"SCU=Set of screens as defined by the functional elementary process ",null,null,null,"SCU=The assessed application ",null,null,"SCU=The Functional Elementary Process",null,null,null,"SCU=The Functional Elementary Process",null,null,null,null,"SCU=The Functional Elementary Process",null,null,null,"SCU=The Functional Elementary Process",null,null,null,null,"SCU=The batch job",null,null,null,null,"SCU=The Functional Elementary Process",null,null,"SCU=The assessed application"]
[null,"SCU Action (Add, Change, Delete)","\nSCU Description / ID     ","Number of nesting levels","Complexity Level","Number of DETs",null,"Elementary Process Type (Main Purpose)","Number of DETs","Number of FTR","Complexity Level",null,"Transformation Complexity Level (L, A, H)","Number of DETs",null,"Number of FTRs","Complexity Level","Number of DETs",null,"Number of Records","Complexity Level","Number of Attributes",null,null,"Number of Properties (the sum of the number of unique properties) added or configured","Complexity Level","Number of Unique UI Elements",null,"Screenshot(s)  added?","Number of Items Impacted",null,"Number of DETs","Complexity Level","Number of Input Methods",null,"Number of DETs","Complexity Level","Number of Output Methods",null,null,"Nature of Platforms (Software / Hardware)","Numbers of Platforms to Operate","Platform Type:  Same family, Different family, Real time,                Non-real time",null,"Number of DETs","Number of RETs","Complexity Level","Number of Changes",null,"Number of FTRs","Complexity Level (L, A, H)","Number of DETs",null,null,"Number of Unique In-house Components","Number of Unique Third Party Components",null,"Number of DETs","Complexity Level","Total # of Input Interfaces","Total # of Output Interfaces"]
[]
[{"$f":"ROW()-7","v":1},"ADD","Example (erase when starting the count)","3 to 5",{"$f":"IF(D8=\"\",\"\",(IF(D8=\"1 to 2\",\"Low\",IF(D8=\"3 to 5\",\"Average\",\"High\"))))","v":"Average"},4,{"$f":"IF(OR(E8=\"\",NOT(ISNUMBER(F8))),\"\",IF(E8=\"Low\",F8*2,IF(E8=\"Average\",F8*3,IF(E8=\"High\",F8*4))))","v":12},"Logical",3,"0 to 3",{"$f":"IF(J8=\"\",\"\",IF(J8=\"0 to 3\",\"Low\",IF(J8=\"4 to 9\",\"Average\",\"High\")))","v":"Low"},{"$f":"IF(OR(H8=\"\",K8=\"\",NOT(ISNUMBER(I8))),\"\",IF(H8=\"Logical\",IF(K8=\"Low\",4*I8,IF(K8=\"Average\",6*I8,IF(K8=\"High\",10*I8))),IF(H8=\"Mathematical\",IF(K8=\"Low\",3*I8,IF(K8=\"Average\",4*I8,IF(K8=\"High\",7*I8,\"Error\"))))))","v":12},"Low",4,{"$f":"IF(OR(M8=\"\",N8=\"\",NOT(ISNUMBER(N8))),\"\",IF(M8=\"Low\",N8*2,IF(M8=\"Average\",N8*3,IF(M8=\"High\",N8*5))))","v":8},"10+",{"$f":"IF(P8=\"\",\"\",IF(P8=\"1 to 3\",\"Low\",IF(P8=\"4 to 9\",\"Average\",\"High\")))","v":"High"},8,{"$f":"IF(OR(R8=\"\",NOT(ISNUMBER(R8))),\"\",IF(P8=\"\",\"\",IF(Q8=\"Low\",R8*4,IF(Q8=\"Average\",R8*6,IF(Q8=\"High\",R8*10)))))","v":80},"30+",{"$f":"IF(T8=\"\",\"\",IF(T8=\"1 to 10\",\"Low\",IF(T8=\"11 to 29\",\"Average\",\"High\")))","v":"High"},5,{"$f":"IF(OR(T8=\"\",V8=\"\",NOT(ISNUMBER(V8))),\"\",IF(U8=\"Low\",V8*6,IF(U8=\"Average\",V8*8,IF(U8=\"High\",V8*12))))","v":60},null,"10 to 15",{"$f":"IF(Y8=\"\",\"\",IF(Y8=\"1 to 9\",\"Low\",IF(Y8=\"10 to 15\",\"Average\",\"High\")))","v":"Average"},7,{"$f":"IF(OR(Z8=\"\",NOT(ISNUMBER(AA8))),\"\",IF(Z8=\"Low\",AA8*2,IF(Z8=\"Average\",AA8*3,IF(Z8=\"High\",AA8*4))))","v":21},"Yes",25,{"$f":"IFERROR(ROUND(IF(AC8=\"No\",AD8/16,IF(AC8=\"yes\",(2+(AD8/16)),\"\")),1),\"\")","v":3.6},"16+",{"$f":"IF(AF8=\"\",\"\",IF(AF8=\"1 to 4\",\"Low\",IF(AF8=\"5 to 15\",\"Average\",\"High\")))","v":"High"},6,{"$f":"IF(OR(AG8=\"\",NOT(ISNUMBER(AH8))),\"\",IF(AG8=\"Low\",AH8*3,IF(AG8=\"Average\",AH8*4,IF(AG8=\"High\",AH8*6))))","v":36},"6 to 19",{"$f":"IF(AJ8=\"\",\"\",IF(AJ8=\"1 to 5\",\"Low\",IF(AJ8=\"6 to 19\",\"Average\",\"High\")))","v":"Average"},2,{"$f":"IF(OR(AK8=\"\",NOT(ISNUMBER(AL8))),\"\",IF(AK8=\"Low\",AL8*3,IF(AK8=\"Average\",AL8*4,IF(AK8=\"High\",AL8*6))))","v":8},234,"Software Platform",3,"Different family",{"$f":"IF(BN8=\"\",\"\",IF(BN8=\"BA\",\"TBD\",IF(BN8=\"AA\",IF(AP8=2,20,IF(AP8=3,30,IF(AP8>3,40))),IF(BN8=\"AB\",IF(AP8=2,40,IF(AP8=3,60,IF(AP8>3,80))),IF(BN8=\"AC\",IF(AP8=2,10,IF(AP8=3,20,IF(AP8>3,30))))))))","v":60},"51+",1,{"$f":"IF(OR(AS8=\"\",AT8=\"\"),\"\",VLOOKUP(BO8,Parameters!$B$75:$C$83,2,FALSE))","v":"Average"},5,{"$f":"IF(AU8=\"\",\"\",IF(AU8=\"Low\",AV8*6,IF(AU8=\"Average\",AV8*9,IF(AU8=\"High\",AV8*12))))","v":45},"1 to 3",{"$f":"IF(AX8=\"\",\"\",IF(AX8=\"1 to 3\",\"Low\",IF(AX8=\"4 to 9\",\"Average\",\"High\")))","v":"Low"},1,{"$f":"IF(OR(AX8=\"\",NOT(ISNUMBER(AZ8))),\"\",IF(AY8=\"Low\",AZ8*4,IF(AY8=\"Average\",AZ8*6,IF(AY8=\"High\",AZ8*10))))","v":4},23,5,4,{"$f":"IF(AND(NOT(ISNUMBER(BD8)),NOT(ISNUMBER(BC8))),\"\",(BC8*3+BD8*4))","v":31},"6 to 19",{"$f":"IF(BF8=\"\",\"\",IF(BF8=\"1 to 5\",\"Low\",IF(BF8=\"6 to 19\",\"Average\",\"High\")))","v":"Average"},2,3,{"$f":"IF(OR(BF8=\"\",(BH8+BI8)=0,NOT(ISNUMBER(BI8)),NOT(ISNUMBER(BH8))),\"\",IF(BG8=\"Low\",(BH8+BI8)*3,IF(BG8=\"Average\",(BH8+BI8)*4,IF(BG8=\"High\",(BH8+BI8)*6))))","v":20},78,null,null,{"$f":"IF(AO8=\"\",\"\",IF(AO8=\"Software Platform\",IF(AQ8=\"Same family\",\"AA\",IF(AQ8=\"Different Family\",\"AB\",\"AC\")),IF(AO8=\"Hardware Platform\",\"BA\")))","v":"AB"},{"$f":"AT8&AS8","v":"151+"}]
[{"$f":"ROW()-7","v":2},"ADD",null,null,{"$f":"IF(D9=\"\",\"\",(IF(D9=\"1 to 2\",\"Low\",IF(D9=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E9=\"\",NOT(ISNUMBER(F9))),\"\",IF(E9=\"Low\",F9*2,IF(E9=\"Average\",F9*3,IF(E9=\"High\",F9*4))))","v":""},null,null,null,{"$f":"IF(J9=\"\",\"\",IF(J9=\"0 to 3\",\"Low\",IF(J9=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H9=\"\",K9=\"\",NOT(ISNUMBER(I9))),\"\",IF(H9=\"Logical\",IF(K9=\"Low\",4*I9,IF(K9=\"Average\",6*I9,IF(K9=\"High\",10*I9))),IF(H9=\"Mathematical\",IF(K9=\"Low\",3*I9,IF(K9=\"Average\",4*I9,IF(K9=\"High\",7*I9,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M9=\"\",N9=\"\",NOT(ISNUMBER(N9))),\"\",IF(M9=\"Low\",N9*2,IF(M9=\"Average\",N9*3,IF(M9=\"High\",N9*5))))","v":""},null,{"$f":"IF(P9=\"\",\"\",IF(P9=\"1 to 3\",\"Low\",IF(P9=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R9=\"\",NOT(ISNUMBER(R9))),\"\",IF(P9=\"\",\"\",IF(Q9=\"Low\",R9*4,IF(Q9=\"Average\",R9*6,IF(Q9=\"High\",R9*10)))))","v":""},null,{"$f":"IF(T9=\"\",\"\",IF(T9=\"1 to 10\",\"Low\",IF(T9=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T9=\"\",V9=\"\",NOT(ISNUMBER(V9))),\"\",IF(U9=\"Low\",V9*6,IF(U9=\"Average\",V9*8,IF(U9=\"High\",V9*12))))","v":""},null,null,{"$f":"IF(Y9=\"\",\"\",IF(Y9=\"1 to 9\",\"Low\",IF(Y9=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z9=\"\",NOT(ISNUMBER(AA9))),\"\",IF(Z9=\"Low\",AA9*2,IF(Z9=\"Average\",AA9*3,IF(Z9=\"High\",AA9*4))))","v":""},null,null,{"$f":"IFERROR(ROUND(IF(AC9=\"No\",AD9/16,IF(AC9=\"yes\",(2+(AD9/16)),\"\")),1),\"\")","v":""},null,{"$f":"IF(AF9=\"\",\"\",IF(AF9=\"1 to 4\",\"Low\",IF(AF9=\"5 to 15\",\"Average\",\"High\")))","v":""},6,{"$f":"IF(OR(AG9=\"\",NOT(ISNUMBER(AH9))),\"\",IF(AG9=\"Low\",AH9*3,IF(AG9=\"Average\",AH9*4,IF(AG9=\"High\",AH9*6))))","v":""},null,{"$f":"IF(AJ9=\"\",\"\",IF(AJ9=\"1 to 5\",\"Low\",IF(AJ9=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK9=\"\",NOT(ISNUMBER(AL9))),\"\",IF(AK9=\"Low\",AL9*3,IF(AK9=\"Average\",AL9*4,IF(AK9=\"High\",AL9*6))))","v":""},null,null,null,null,{"$f":"IF(BN9=\"\",\"\",IF(BN9=\"BA\",\"TBD\",IF(BN9=\"AA\",IF(AP9=2,20,IF(AP9=3,30,IF(AP9>3,40))),IF(BN9=\"AB\",IF(AP9=2,40,IF(AP9=3,60,IF(AP9>3,80))),IF(BN9=\"AC\",IF(AP9=2,10,IF(AP9=3,20,IF(AP9>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS9=\"\",AT9=\"\"),\"\",VLOOKUP(BO9,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU9=\"\",\"\",IF(AU9=\"Low\",AV9*6,IF(AU9=\"Average\",AV9*9,IF(AU9=\"High\",AV9*12))))","v":""},"4 to 9",{"$f":"IF(AX9=\"\",\"\",IF(AX9=\"1 to 3\",\"Low\",IF(AX9=\"4 to 9\",\"Average\",\"High\")))","v":"Average"},null,{"$f":"IF(OR(AX9=\"\",NOT(ISNUMBER(AZ9))),\"\",IF(AY9=\"Low\",AZ9*4,IF(AY9=\"Average\",AZ9*6,IF(AY9=\"High\",AZ9*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD9)),NOT(ISNUMBER(BC9))),\"\",(BC9*3+BD9*4))","v":""},"1 to 5",{"$f":"IF(BF9=\"\",\"\",IF(BF9=\"1 to 5\",\"Low\",IF(BF9=\"6 to 19\",\"Average\",\"High\")))","v":"Low"},null,null,{"$f":"IF(OR(BF9=\"\",(BH9+BI9)=0,NOT(ISNUMBER(BI9)),NOT(ISNUMBER(BH9))),\"\",IF(BG9=\"Low\",(BH9+BI9)*3,IF(BG9=\"Average\",(BH9+BI9)*4,IF(BG9=\"High\",(BH9+BI9)*6))))","v":""},null,null,null,{"$f":"IF(AO9=\"\",\"\",IF(AO9=\"Software Platform\",IF(AQ9=\"Same family\",\"AA\",IF(AQ9=\"Different Family\",\"AB\",\"AC\")),IF(AO9=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT9&AS9","v":""}]
[{"$f":"ROW()-7","v":3},"ADD",null,null,{"$f":"IF(D10=\"\",\"\",(IF(D10=\"1 to 2\",\"Low\",IF(D10=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E10=\"\",NOT(ISNUMBER(F10))),\"\",IF(E10=\"Low\",F10*2,IF(E10=\"Average\",F10*3,IF(E10=\"High\",F10*4))))","v":""},null,null,null,{"$f":"IF(J10=\"\",\"\",IF(J10=\"0 to 3\",\"Low\",IF(J10=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H10=\"\",K10=\"\",NOT(ISNUMBER(I10))),\"\",IF(H10=\"Logical\",IF(K10=\"Low\",4*I10,IF(K10=\"Average\",6*I10,IF(K10=\"High\",10*I10))),IF(H10=\"Mathematical\",IF(K10=\"Low\",3*I10,IF(K10=\"Average\",4*I10,IF(K10=\"High\",7*I10,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M10=\"\",N10=\"\",NOT(ISNUMBER(N10))),\"\",IF(M10=\"Low\",N10*2,IF(M10=\"Average\",N10*3,IF(M10=\"High\",N10*5))))","v":""},null,{"$f":"IF(P10=\"\",\"\",IF(P10=\"1 to 3\",\"Low\",IF(P10=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R10=\"\",NOT(ISNUMBER(R10))),\"\",IF(P10=\"\",\"\",IF(Q10=\"Low\",R10*4,IF(Q10=\"Average\",R10*6,IF(Q10=\"High\",R10*10)))))","v":""},null,"",null,{"$f":"IF(OR(T10=\"\",V10=\"\",NOT(ISNUMBER(V10))),\"\",IF(U10=\"Low\",V10*6,IF(U10=\"Average\",V10*8,IF(U10=\"High\",V10*12))))","v":""},null,null,{"$f":"IF(Y10=\"\",\"\",IF(Y10=\"1 to 9\",\"Low\",IF(Y10=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z10=\"\",NOT(ISNUMBER(AA10))),\"\",IF(Z10=\"Low\",AA10*2,IF(Z10=\"Average\",AA10*3,IF(Z10=\"High\",AA10*4))))","v":""},null,null,{"$f":"IFERROR(ROUND(IF(AC10=\"No\",AD10/16,IF(AC10=\"yes\",(2+(AD10/16)),\"\")),1),\"\")","v":""},null,{"$f":"IF(AF10=\"\",\"\",IF(AF10=\"1 to 4\",\"Low\",IF(AF10=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG10=\"\",NOT(ISNUMBER(AH10))),\"\",IF(AG10=\"Low\",AH10*3,IF(AG10=\"Average\",AH10*4,IF(AG10=\"High\",AH10*6))))","v":""},null,{"$f":"IF(AJ10=\"\",\"\",IF(AJ10=\"1 to 5\",\"Low\",IF(AJ10=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK10=\"\",NOT(ISNUMBER(AL10))),\"\",IF(AK10=\"Low\",AL10*3,IF(AK10=\"Average\",AL10*4,IF(AK10=\"High\",AL10*6))))","v":""},null,null,null,null,{"$f":"IF(BN10=\"\",\"\",IF(BN10=\"BA\",\"TBD\",IF(BN10=\"AA\",IF(AP10=2,20,IF(AP10=3,30,IF(AP10>3,40))),IF(BN10=\"AB\",IF(AP10=2,40,IF(AP10=3,60,IF(AP10>3,80))),IF(BN10=\"AC\",IF(AP10=2,10,IF(AP10=3,20,IF(AP10>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS10=\"\",AT10=\"\"),\"\",VLOOKUP(BO10,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU10=\"\",\"\",IF(AU10=\"Low\",AV10*6,IF(AU10=\"Average\",AV10*9,IF(AU10=\"High\",AV10*12))))","v":""},null,{"$f":"IF(AX10=\"\",\"\",IF(AX10=\"1 to 3\",\"Low\",IF(AX10=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AX10=\"\",NOT(ISNUMBER(AZ10))),\"\",IF(AY10=\"Low\",AZ10*4,IF(AY10=\"Average\",AZ10*6,IF(AY10=\"High\",AZ10*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD10)),NOT(ISNUMBER(BC10))),\"\",(BC10*3+BD10*4))","v":""},"20+",{"$f":"IF(BF10=\"\",\"\",IF(BF10=\"1 to 5\",\"Low\",IF(BF10=\"6 to 19\",\"Average\",\"High\")))","v":"High"},null,null,{"$f":"IF(OR(BF10=\"\",(BH10+BI10)=0,NOT(ISNUMBER(BI10)),NOT(ISNUMBER(BH10))),\"\",IF(BG10=\"Low\",(BH10+BI10)*3,IF(BG10=\"Average\",(BH10+BI10)*4,IF(BG10=\"High\",(BH10+BI10)*6))))","v":""},null,null,null,{"$f":"IF(AO10=\"\",\"\",IF(AO10=\"Software Platform\",IF(AQ10=\"Same family\",\"AA\",IF(AQ10=\"Different Family\",\"AB\",\"AC\")),IF(AO10=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT10&AS10","v":""}]
[{"$f":"ROW()-7","v":4},"ADD",null,null,"",null,"",null,null,null,{"$f":"IF(J11=\"\",\"\",IF(J11=\"0 to 3\",\"Low\",IF(J11=\"4 to 9\",\"Average\",\"High\")))","v":""},"",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,{"$f":"IFERROR(ROUND(IF(AC11=\"No\",AD11/16,IF(AC11=\"yes\",(2+(AD11/16)),\"\")),1),\"\")","v":""},null,"",null,"",null,{"$f":"IF(AJ11=\"\",\"\",IF(AJ11=\"1 to 5\",\"Low\",IF(AJ11=\"6 to 19\",\"Average\",\"High\")))","v":""},null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS11=\"\",AT11=\"\"),\"\",VLOOKUP(BO11,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,{"$f":"IF(AX11=\"\",\"\",IF(AX11=\"1 to 3\",\"Low\",IF(AX11=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AX11=\"\",NOT(ISNUMBER(AZ11))),\"\",IF(AY11=\"Low\",AZ11*4,IF(AY11=\"Average\",AZ11*6,IF(AY11=\"High\",AZ11*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD11)),NOT(ISNUMBER(BC11))),\"\",(BC11*3+BD11*4))","v":""},null,{"$f":"IF(BF11=\"\",\"\",IF(BF11=\"1 to 5\",\"Low\",IF(BF11=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,{"$f":"IF(OR(BF11=\"\",(BH11+BI11)=0,NOT(ISNUMBER(BI11)),NOT(ISNUMBER(BH11))),\"\",IF(BG11=\"Low\",(BH11+BI11)*3,IF(BG11=\"Average\",(BH11+BI11)*4,IF(BG11=\"High\",(BH11+BI11)*6))))","v":""},null,null,null,"",""]
[5,"ADD",null,null,{"$f":"IF(D12=\"\",\"\",(IF(D12=\"1 to 2\",\"Low\",IF(D12=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E12=\"\",NOT(ISNUMBER(F12))),\"\",IF(E12=\"Low\",F12*2,IF(E12=\"Average\",F12*3,IF(E12=\"High\",F12*4))))","v":""},null,null,null,{"$f":"IF(J12=\"\",\"\",IF(J12=\"0 to 3\",\"Low\",IF(J12=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H12=\"\",K12=\"\",NOT(ISNUMBER(I12))),\"\",IF(H12=\"Logical\",IF(K12=\"Low\",4*I12,IF(K12=\"Average\",6*I12,IF(K12=\"High\",10*I12))),IF(H12=\"Mathematical\",IF(K12=\"Low\",3*I12,IF(K12=\"Average\",4*I12,IF(K12=\"High\",7*I12,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M12=\"\",N12=\"\",NOT(ISNUMBER(N12))),\"\",IF(M12=\"Low\",N12*2,IF(M12=\"Average\",N12*3,IF(M12=\"High\",N12*5))))","v":""},null,{"$f":"IF(P12=\"\",\"\",IF(P12=\"1 to 3\",\"Low\",IF(P12=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R12=\"\",NOT(ISNUMBER(R12))),\"\",IF(P12=\"\",\"\",IF(Q12=\"Low\",R12*4,IF(Q12=\"Average\",R12*6,IF(Q12=\"High\",R12*10)))))","v":""},null,{"$f":"IF(T12=\"\",\"\",IF(T12=\"1 to 10\",\"Low\",IF(T12=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T12=\"\",V12=\"\",NOT(ISNUMBER(V12))),\"\",IF(U12=\"Low\",V12*6,IF(U12=\"Average\",V12*8,IF(U12=\"High\",V12*12))))","v":""},null,null,{"$f":"IF(Y12=\"\",\"\",IF(Y12=\"1 to 9\",\"Low\",IF(Y12=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z12=\"\",NOT(ISNUMBER(AA12))),\"\",IF(Z12=\"Low\",AA12*2,IF(Z12=\"Average\",AA12*3,IF(Z12=\"High\",AA12*4))))","v":""},null,null,"",null,{"$f":"IF(AF12=\"\",\"\",IF(AF12=\"1 to 4\",\"Low\",IF(AF12=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG12=\"\",NOT(ISNUMBER(AH12))),\"\",IF(AG12=\"Low\",AH12*3,IF(AG12=\"Average\",AH12*4,IF(AG12=\"High\",AH12*6))))","v":""},null,{"$f":"IF(AJ12=\"\",\"\",IF(AJ12=\"1 to 5\",\"Low\",IF(AJ12=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK12=\"\",NOT(ISNUMBER(AL12))),\"\",IF(AK12=\"Low\",AL12*3,IF(AK12=\"Average\",AL12*4,IF(AK12=\"High\",AL12*6))))","v":""},null,null,null,null,{"$f":"IF(BN12=\"\",\"\",IF(BN12=\"BA\",\"TBD\",IF(BN12=\"AA\",IF(AP12=2,20,IF(AP12=3,30,IF(AP12>3,40))),IF(BN12=\"AB\",IF(AP12=2,40,IF(AP12=3,60,IF(AP12>3,80))),IF(BN12=\"AC\",IF(AP12=2,10,IF(AP12=3,20,IF(AP12>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS12=\"\",AT12=\"\"),\"\",VLOOKUP(BO12,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU12=\"\",\"\",IF(AU12=\"Low\",AV12*6,IF(AU12=\"Average\",AV12*9,IF(AU12=\"High\",AV12*12))))","v":""},null,{"$f":"IF(AX12=\"\",\"\",IF(AX12=\"1 to 3\",\"Low\",IF(AX12=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AX12=\"\",NOT(ISNUMBER(AZ12))),\"\",IF(AY12=\"Low\",AZ12*4,IF(AY12=\"Average\",AZ12*6,IF(AY12=\"High\",AZ12*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD12)),NOT(ISNUMBER(BC12))),\"\",(BC12*3+BD12*4))","v":""},null,{"$f":"IF(BF12=\"\",\"\",IF(BF12=\"1 to 5\",\"Low\",IF(BF12=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,{"$f":"IF(OR(BF12=\"\",(BH12+BI12)=0,NOT(ISNUMBER(BI12)),NOT(ISNUMBER(BH12))),\"\",IF(BG12=\"Low\",(BH12+BI12)*3,IF(BG12=\"Average\",(BH12+BI12)*4,IF(BG12=\"High\",(BH12+BI12)*6))))","v":""},null,null,null,{"$f":"IF(AO12=\"\",\"\",IF(AO12=\"Software Platform\",IF(AQ12=\"Same family\",\"AA\",IF(AQ12=\"Different Family\",\"AB\",\"AC\")),IF(AO12=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT12&AS12","v":""}]
[6,"ADD",null,null,{"$f":"IF(D13=\"\",\"\",(IF(D13=\"1 to 2\",\"Low\",IF(D13=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E13=\"\",NOT(ISNUMBER(F13))),\"\",IF(E13=\"Low\",F13*2,IF(E13=\"Average\",F13*3,IF(E13=\"High\",F13*4))))","v":""},null,null,null,{"$f":"IF(J13=\"\",\"\",IF(J13=\"0 to 3\",\"Low\",IF(J13=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H13=\"\",K13=\"\",NOT(ISNUMBER(I13))),\"\",IF(H13=\"Logical\",IF(K13=\"Low\",4*I13,IF(K13=\"Average\",6*I13,IF(K13=\"High\",10*I13))),IF(H13=\"Mathematical\",IF(K13=\"Low\",3*I13,IF(K13=\"Average\",4*I13,IF(K13=\"High\",7*I13,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M13=\"\",N13=\"\",NOT(ISNUMBER(N13))),\"\",IF(M13=\"Low\",N13*2,IF(M13=\"Average\",N13*3,IF(M13=\"High\",N13*5))))","v":""},null,{"$f":"IF(P13=\"\",\"\",IF(P13=\"1 to 3\",\"Low\",IF(P13=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R13=\"\",NOT(ISNUMBER(R13))),\"\",IF(P13=\"\",\"\",IF(Q13=\"Low\",R13*4,IF(Q13=\"Average\",R13*6,IF(Q13=\"High\",R13*10)))))","v":""},null,{"$f":"IF(T13=\"\",\"\",IF(T13=\"1 to 10\",\"Low\",IF(T13=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T13=\"\",V13=\"\",NOT(ISNUMBER(V13))),\"\",IF(U13=\"Low\",V13*6,IF(U13=\"Average\",V13*8,IF(U13=\"High\",V13*12))))","v":""},null,null,{"$f":"IF(Y13=\"\",\"\",IF(Y13=\"1 to 9\",\"Low\",IF(Y13=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z13=\"\",NOT(ISNUMBER(AA13))),\"\",IF(Z13=\"Low\",AA13*2,IF(Z13=\"Average\",AA13*3,IF(Z13=\"High\",AA13*4))))","v":""},null,null,"",null,{"$f":"IF(AF13=\"\",\"\",IF(AF13=\"1 to 4\",\"Low\",IF(AF13=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG13=\"\",NOT(ISNUMBER(AH13))),\"\",IF(AG13=\"Low\",AH13*3,IF(AG13=\"Average\",AH13*4,IF(AG13=\"High\",AH13*6))))","v":""},null,{"$f":"IF(AJ13=\"\",\"\",IF(AJ13=\"1 to 5\",\"Low\",IF(AJ13=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK13=\"\",NOT(ISNUMBER(AL13))),\"\",IF(AK13=\"Low\",AL13*3,IF(AK13=\"Average\",AL13*4,IF(AK13=\"High\",AL13*6))))","v":""},null,null,null,null,{"$f":"IF(BN13=\"\",\"\",IF(BN13=\"BA\",\"TBD\",IF(BN13=\"AA\",IF(AP13=2,20,IF(AP13=3,30,IF(AP13>3,40))),IF(BN13=\"AB\",IF(AP13=2,40,IF(AP13=3,60,IF(AP13>3,80))),IF(BN13=\"AC\",IF(AP13=2,10,IF(AP13=3,20,IF(AP13>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS13=\"\",AT13=\"\"),\"\",VLOOKUP(BO13,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU13=\"\",\"\",IF(AU13=\"Low\",AV13*6,IF(AU13=\"Average\",AV13*9,IF(AU13=\"High\",AV13*12))))","v":""},null,{"$f":"IF(AX13=\"\",\"\",IF(AX13=\"1 to 3\",\"Low\",IF(AX13=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AX13=\"\",NOT(ISNUMBER(AZ13))),\"\",IF(AY13=\"Low\",AZ13*4,IF(AY13=\"Average\",AZ13*6,IF(AY13=\"High\",AZ13*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD13)),NOT(ISNUMBER(BC13))),\"\",(BC13*3+BD13*4))","v":""},null,{"$f":"IF(BF13=\"\",\"\",IF(BF13=\"1 to 5\",\"Low\",IF(BF13=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,{"$f":"IF(OR(BF13=\"\",(BH13+BI13)=0,NOT(ISNUMBER(BI13)),NOT(ISNUMBER(BH13))),\"\",IF(BG13=\"Low\",(BH13+BI13)*3,IF(BG13=\"Average\",(BH13+BI13)*4,IF(BG13=\"High\",(BH13+BI13)*6))))","v":""},null,null,null,{"$f":"IF(AO13=\"\",\"\",IF(AO13=\"Software Platform\",IF(AQ13=\"Same family\",\"AA\",IF(AQ13=\"Different Family\",\"AB\",\"AC\")),IF(AO13=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT13&AS13","v":""}]
[7,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS14=\"\",AT14=\"\"),\"\",VLOOKUP(BO14,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[8,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS15=\"\",AT15=\"\"),\"\",VLOOKUP(BO15,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[9,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS16=\"\",AT16=\"\"),\"\",VLOOKUP(BO16,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX16=\"\",NOT(ISNUMBER(AZ16))),\"\",IF(AY16=\"Low\",AZ16*4,IF(AY16=\"Average\",AZ16*6,IF(AY16=\"High\",AZ16*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF16=\"\",(BH16+BI16)=0,NOT(ISNUMBER(BI16)),NOT(ISNUMBER(BH16))),\"\",IF(BG16=\"Low\",(BH16+BI16)*3,IF(BG16=\"Average\",(BH16+BI16)*4,IF(BG16=\"High\",(BH16+BI16)*6))))","v":""},null,null,null,"",""]
[10,"ADD",null,null,{"$f":"IF(D17=\"\",\"\",(IF(D17=\"1 to 2\",\"Low\",IF(D17=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E17=\"\",NOT(ISNUMBER(F17))),\"\",IF(E17=\"Low\",F17*2,IF(E17=\"Average\",F17*3,IF(E17=\"High\",F17*4))))","v":""},null,null,null,{"$f":"IF(J17=\"\",\"\",IF(J17=\"0 to 3\",\"Low\",IF(J17=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H17=\"\",K17=\"\",NOT(ISNUMBER(I17))),\"\",IF(H17=\"Logical\",IF(K17=\"Low\",4*I17,IF(K17=\"Average\",6*I17,IF(K17=\"High\",10*I17))),IF(H17=\"Mathematical\",IF(K17=\"Low\",3*I17,IF(K17=\"Average\",4*I17,IF(K17=\"High\",7*I17,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M17=\"\",N17=\"\",NOT(ISNUMBER(N17))),\"\",IF(M17=\"Low\",N17*2,IF(M17=\"Average\",N17*3,IF(M17=\"High\",N17*5))))","v":""},null,{"$f":"IF(P17=\"\",\"\",IF(P17=\"1 to 3\",\"Low\",IF(P17=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R17=\"\",NOT(ISNUMBER(R17))),\"\",IF(P17=\"\",\"\",IF(Q17=\"Low\",R17*4,IF(Q17=\"Average\",R17*6,IF(Q17=\"High\",R17*10)))))","v":""},null,{"$f":"IF(T17=\"\",\"\",IF(T17=\"1 to 10\",\"Low\",IF(T17=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T17=\"\",V17=\"\",NOT(ISNUMBER(V17))),\"\",IF(U17=\"Low\",V17*6,IF(U17=\"Average\",V17*8,IF(U17=\"High\",V17*12))))","v":""},null,null,{"$f":"IF(Y17=\"\",\"\",IF(Y17=\"1 to 9\",\"Low\",IF(Y17=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z17=\"\",NOT(ISNUMBER(AA17))),\"\",IF(Z17=\"Low\",AA17*2,IF(Z17=\"Average\",AA17*3,IF(Z17=\"High\",AA17*4))))","v":""},null,null,{"$f":"IFERROR(ROUND(IF(AC17=\"No\",AD17/16,IF(AC17=\"yes\",(2+(AD17/16)),\"\")),1),\"\")","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(AF17=\"1 to 4\",\"Low\",IF(AF17=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG17=\"\",NOT(ISNUMBER(AH17))),\"\",IF(AG17=\"Low\",AH17*3,IF(AG17=\"Average\",AH17*4,IF(AG17=\"High\",AH17*6))))","v":""},null,{"$f":"IF(AJ17=\"\",\"\",IF(AJ17=\"1 to 5\",\"Low\",IF(AJ17=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK17=\"\",NOT(ISNUMBER(AL17))),\"\",IF(AK17=\"Low\",AL17*3,IF(AK17=\"Average\",AL17*4,IF(AK17=\"High\",AL17*6))))","v":""},null,null,null,null,{"$f":"IF(BN17=\"\",\"\",IF(BN17=\"BA\",\"TBD\",IF(BN17=\"AA\",IF(AP17=2,20,IF(AP17=3,30,IF(AP17>3,40))),IF(BN17=\"AB\",IF(AP17=2,40,IF(AP17=3,60,IF(AP17>3,80))),IF(BN17=\"AC\",IF(AP17=2,10,IF(AP17=3,20,IF(AP17>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS17=\"\",AT17=\"\"),\"\",VLOOKUP(BO17,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AU17=\"Low\",AV17*6,IF(AU17=\"Average\",AV17*9,IF(AU17=\"High\",AV17*12))))","v":""},null,{"$f":"IF(AX17=\"\",\"\",IF(AX17=\"1 to 3\",\"Low\",IF(AX17=\"4 to 9\",\"Average\",\"High\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD17)),NOT(ISNUMBER(BC17))),\"\",(BC17*3+BD17*4))","v":""},null,{"$f":"IF(BF17=\"\",\"\",IF(BF17=\"1 to 5\",\"Low\",IF(BF17=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,"",null,null,null,{"$f":"IF(AO17=\"\",\"\",IF(AO17=\"Software Platform\",IF(AQ17=\"Same family\",\"AA\",IF(AQ17=\"Different Family\",\"AB\",\"AC\")),IF(AO17=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT17&AS17","v":""}]
[11,"ADD",null,null,{"$f":"IF(D18=\"\",\"\",(IF(D18=\"1 to 2\",\"Low\",IF(D18=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E18=\"\",NOT(ISNUMBER(F18))),\"\",IF(E18=\"Low\",F18*2,IF(E18=\"Average\",F18*3,IF(E18=\"High\",F18*4))))","v":""},null,null,null,{"$f":"IF(J18=\"\",\"\",IF(J18=\"0 to 3\",\"Low\",IF(J18=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H18=\"\",K18=\"\",NOT(ISNUMBER(I18))),\"\",IF(H18=\"Logical\",IF(K18=\"Low\",4*I18,IF(K18=\"Average\",6*I18,IF(K18=\"High\",10*I18))),IF(H18=\"Mathematical\",IF(K18=\"Low\",3*I18,IF(K18=\"Average\",4*I18,IF(K18=\"High\",7*I18,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M18=\"\",N18=\"\",NOT(ISNUMBER(N18))),\"\",IF(M18=\"Low\",N18*2,IF(M18=\"Average\",N18*3,IF(M18=\"High\",N18*5))))","v":""},null,{"$f":"IF(P18=\"\",\"\",IF(P18=\"1 to 3\",\"Low\",IF(P18=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R18=\"\",NOT(ISNUMBER(R18))),\"\",IF(P18=\"\",\"\",IF(Q18=\"Low\",R18*4,IF(Q18=\"Average\",R18*6,IF(Q18=\"High\",R18*10)))))","v":""},null,{"$f":"IF(T18=\"\",\"\",IF(T18=\"1 to 10\",\"Low\",IF(T18=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T18=\"\",V18=\"\",NOT(ISNUMBER(V18))),\"\",IF(U18=\"Low\",V18*6,IF(U18=\"Average\",V18*8,IF(U18=\"High\",V18*12))))","v":""},null,null,{"$f":"IF(Y18=\"\",\"\",IF(Y18=\"1 to 9\",\"Low\",IF(Y18=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z18=\"\",NOT(ISNUMBER(AA18))),\"\",IF(Z18=\"Low\",AA18*2,IF(Z18=\"Average\",AA18*3,IF(Z18=\"High\",AA18*4))))","v":""},null,null,{"$f":"IFERROR(ROUND(IF(AC18=\"No\",AD18/16,IF(AC18=\"yes\",(2+(AD18/16)),\"\")),1),\"\")","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(AF18=\"1 to 4\",\"Low\",IF(AF18=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG18=\"\",NOT(ISNUMBER(AH18))),\"\",IF(AG18=\"Low\",AH18*3,IF(AG18=\"Average\",AH18*4,IF(AG18=\"High\",AH18*6))))","v":""},null,{"$f":"IF(AJ18=\"\",\"\",IF(AJ18=\"1 to 5\",\"Low\",IF(AJ18=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK18=\"\",NOT(ISNUMBER(AL18))),\"\",IF(AK18=\"Low\",AL18*3,IF(AK18=\"Average\",AL18*4,IF(AK18=\"High\",AL18*6))))","v":""},null,null,null,null,{"$f":"IF(BN18=\"\",\"\",IF(BN18=\"BA\",\"TBD\",IF(BN18=\"AA\",IF(AP18=2,20,IF(AP18=3,30,IF(AP18>3,40))),IF(BN18=\"AB\",IF(AP18=2,40,IF(AP18=3,60,IF(AP18>3,80))),IF(BN18=\"AC\",IF(AP18=2,10,IF(AP18=3,20,IF(AP18>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS18=\"\",AT18=\"\"),\"\",VLOOKUP(BO18,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AU18=\"Low\",AV18*6,IF(AU18=\"Average\",AV18*9,IF(AU18=\"High\",AV18*12))))","v":""},null,{"$f":"IF(AX18=\"\",\"\",IF(AX18=\"1 to 3\",\"Low\",IF(AX18=\"4 to 9\",\"Average\",\"High\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD18)),NOT(ISNUMBER(BC18))),\"\",(BC18*3+BD18*4))","v":""},null,{"$f":"IF(BF18=\"\",\"\",IF(BF18=\"1 to 5\",\"Low\",IF(BF18=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,"",null,null,null,{"$f":"IF(AO18=\"\",\"\",IF(AO18=\"Software Platform\",IF(AQ18=\"Same family\",\"AA\",IF(AQ18=\"Different Family\",\"AB\",\"AC\")),IF(AO18=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT18&AS18","v":""}]
[12,"ADD",null,null,{"$f":"IF(D19=\"\",\"\",(IF(D19=\"1 to 2\",\"Low\",IF(D19=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E19=\"\",NOT(ISNUMBER(F19))),\"\",IF(E19=\"Low\",F19*2,IF(E19=\"Average\",F19*3,IF(E19=\"High\",F19*4))))","v":""},null,null,null,"",{"$f":"IF(OR(H19=\"\",K19=\"\",NOT(ISNUMBER(I19))),\"\",IF(H19=\"Logical\",IF(K19=\"Low\",4*I19,IF(K19=\"Average\",6*I19,IF(K19=\"High\",10*I19))),IF(H19=\"Mathematical\",IF(K19=\"Low\",3*I19,IF(K19=\"Average\",4*I19,IF(K19=\"High\",7*I19,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M19=\"\",N19=\"\",NOT(ISNUMBER(N19))),\"\",IF(M19=\"Low\",N19*2,IF(M19=\"Average\",N19*3,IF(M19=\"High\",N19*5))))","v":""},null,{"$f":"IF(P19=\"\",\"\",IF(P19=\"1 to 3\",\"Low\",IF(P19=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R19=\"\",NOT(ISNUMBER(R19))),\"\",IF(P19=\"\",\"\",IF(Q19=\"Low\",R19*4,IF(Q19=\"Average\",R19*6,IF(Q19=\"High\",R19*10)))))","v":""},null,{"$f":"IF(T19=\"\",\"\",IF(T19=\"1 to 10\",\"Low\",IF(T19=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T19=\"\",V19=\"\",NOT(ISNUMBER(V19))),\"\",IF(U19=\"Low\",V19*6,IF(U19=\"Average\",V19*8,IF(U19=\"High\",V19*12))))","v":""},null,null,{"$f":"IF(Y19=\"\",\"\",IF(Y19=\"1 to 9\",\"Low\",IF(Y19=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z19=\"\",NOT(ISNUMBER(AA19))),\"\",IF(Z19=\"Low\",AA19*2,IF(Z19=\"Average\",AA19*3,IF(Z19=\"High\",AA19*4))))","v":""},null,null,"",null,{"$f":"IF(AF19=\"\",\"\",IF(AF19=\"1 to 4\",\"Low\",IF(AF19=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG19=\"\",NOT(ISNUMBER(AH19))),\"\",IF(AG19=\"Low\",AH19*3,IF(AG19=\"Average\",AH19*4,IF(AG19=\"High\",AH19*6))))","v":""},null,{"$f":"IF(AJ19=\"\",\"\",IF(AJ19=\"1 to 5\",\"Low\",IF(AJ19=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK19=\"\",NOT(ISNUMBER(AL19))),\"\",IF(AK19=\"Low\",AL19*3,IF(AK19=\"Average\",AL19*4,IF(AK19=\"High\",AL19*6))))","v":""},null,null,null,null,{"$f":"IF(BN19=\"\",\"\",IF(BN19=\"BA\",\"TBD\",IF(BN19=\"AA\",IF(AP19=2,20,IF(AP19=3,30,IF(AP19>3,40))),IF(BN19=\"AB\",IF(AP19=2,40,IF(AP19=3,60,IF(AP19>3,80))),IF(BN19=\"AC\",IF(AP19=2,10,IF(AP19=3,20,IF(AP19>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS19=\"\",AT19=\"\"),\"\",VLOOKUP(BO19,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU19=\"\",\"\",IF(AU19=\"Low\",AV19*6,IF(AU19=\"Average\",AV19*9,IF(AU19=\"High\",AV19*12))))","v":""},null,{"$f":"IF(AX19=\"\",\"\",IF(AX19=\"1 to 3\",\"Low\",IF(AX19=\"4 to 9\",\"Average\",\"High\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD19)),NOT(ISNUMBER(BC19))),\"\",(BC19*3+BD19*4))","v":""},null,"",null,null,"",null,null,null,{"$f":"IF(AO19=\"\",\"\",IF(AO19=\"Software Platform\",IF(AQ19=\"Same family\",\"AA\",IF(AQ19=\"Different Family\",\"AB\",\"AC\")),IF(AO19=\"Hardware Platform\",\"BA\")))","v":""},""]
[13,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS20=\"\",AT20=\"\"),\"\",VLOOKUP(BO20,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[14,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,{"$f":"IF(OR(AG21=\"\",NOT(ISNUMBER(AH21))),\"\",IF(AG21=\"Low\",AH21*3,IF(AG21=\"Average\",AH21*4,IF(AG21=\"High\",AH21*6))))","v":""},null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS21=\"\",AT21=\"\"),\"\",VLOOKUP(BO21,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[15,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,{"$f":"IF(OR(AG22=\"\",NOT(ISNUMBER(AH22))),\"\",IF(AG22=\"Low\",AH22*3,IF(AG22=\"Average\",AH22*4,IF(AG22=\"High\",AH22*6))))","v":""},null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS22=\"\",AT22=\"\"),\"\",VLOOKUP(BO22,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[16,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS23=\"\",AT23=\"\"),\"\",VLOOKUP(BO23,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[17,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS24=\"\",AT24=\"\"),\"\",VLOOKUP(BO24,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[18,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS25=\"\",AT25=\"\"),\"\",VLOOKUP(BO25,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[19,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS26=\"\",AT26=\"\"),\"\",VLOOKUP(BO26,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[20,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS27=\"\",AT27=\"\"),\"\",VLOOKUP(BO27,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[21,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS28=\"\",AT28=\"\"),\"\",VLOOKUP(BO28,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX28=\"\",NOT(ISNUMBER(AZ28))),\"\",IF(AY28=\"Low\",AZ28*4,IF(AY28=\"Average\",AZ28*6,IF(AY28=\"High\",AZ28*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF28=\"\",(BH28+BI28)=0,NOT(ISNUMBER(BI28)),NOT(ISNUMBER(BH28))),\"\",IF(BG28=\"Low\",(BH28+BI28)*3,IF(BG28=\"Average\",(BH28+BI28)*4,IF(BG28=\"High\",(BH28+BI28)*6))))","v":""},null,null,null,"",""]
[22,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS29=\"\",AT29=\"\"),\"\",VLOOKUP(BO29,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[23,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS30=\"\",AT30=\"\"),\"\",VLOOKUP(BO30,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[24,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS31=\"\",AT31=\"\"),\"\",VLOOKUP(BO31,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[25,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS32=\"\",AT32=\"\"),\"\",VLOOKUP(BO32,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[26,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS33=\"\",AT33=\"\"),\"\",VLOOKUP(BO33,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[27,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS34=\"\",AT34=\"\"),\"\",VLOOKUP(BO34,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[28,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS35=\"\",AT35=\"\"),\"\",VLOOKUP(BO35,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[29,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS36=\"\",AT36=\"\"),\"\",VLOOKUP(BO36,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[30,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS37=\"\",AT37=\"\"),\"\",VLOOKUP(BO37,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX37=\"\",NOT(ISNUMBER(AZ37))),\"\",IF(AY37=\"Low\",AZ37*4,IF(AY37=\"Average\",AZ37*6,IF(AY37=\"High\",AZ37*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF37=\"\",(BH37+BI37)=0,NOT(ISNUMBER(BI37)),NOT(ISNUMBER(BH37))),\"\",IF(BG37=\"Low\",(BH37+BI37)*3,IF(BG37=\"Average\",(BH37+BI37)*4,IF(BG37=\"High\",(BH37+BI37)*6))))","v":""},null,null,null,"",""]
[31,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS38=\"\",AT38=\"\"),\"\",VLOOKUP(BO38,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[32,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS39=\"\",AT39=\"\"),\"\",VLOOKUP(BO39,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[33,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS40=\"\",AT40=\"\"),\"\",VLOOKUP(BO40,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[34,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS41=\"\",AT41=\"\"),\"\",VLOOKUP(BO41,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[35,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS42=\"\",AT42=\"\"),\"\",VLOOKUP(BO42,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX42=\"\",NOT(ISNUMBER(AZ42))),\"\",IF(AY42=\"Low\",AZ42*4,IF(AY42=\"Average\",AZ42*6,IF(AY42=\"High\",AZ42*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF42=\"\",(BH42+BI42)=0,NOT(ISNUMBER(BI42)),NOT(ISNUMBER(BH42))),\"\",IF(BG42=\"Low\",(BH42+BI42)*3,IF(BG42=\"Average\",(BH42+BI42)*4,IF(BG42=\"High\",(BH42+BI42)*6))))","v":""},null,null,null,"",""]
[36,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS43=\"\",AT43=\"\"),\"\",VLOOKUP(BO43,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX43=\"\",NOT(ISNUMBER(AZ43))),\"\",IF(AY43=\"Low\",AZ43*4,IF(AY43=\"Average\",AZ43*6,IF(AY43=\"High\",AZ43*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF43=\"\",(BH43+BI43)=0,NOT(ISNUMBER(BI43)),NOT(ISNUMBER(BH43))),\"\",IF(BG43=\"Low\",(BH43+BI43)*3,IF(BG43=\"Average\",(BH43+BI43)*4,IF(BG43=\"High\",(BH43+BI43)*6))))","v":""},null,null,null,"",""]
[37,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS44=\"\",AT44=\"\"),\"\",VLOOKUP(BO44,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,{"$f":"IF(OR(AX44=\"\",NOT(ISNUMBER(AZ44))),\"\",IF(AY44=\"Low\",AZ44*4,IF(AY44=\"Average\",AZ44*6,IF(AY44=\"High\",AZ44*10))))","v":""},null,null,null,"",null,"",null,null,{"$f":"IF(OR(BF44=\"\",(BH44+BI44)=0,NOT(ISNUMBER(BI44)),NOT(ISNUMBER(BH44))),\"\",IF(BG44=\"Low\",(BH44+BI44)*3,IF(BG44=\"Average\",(BH44+BI44)*4,IF(BG44=\"High\",(BH44+BI44)*6))))","v":""},null,null,null,"",""]
[38,"ADD",null,null,{"$f":"IF(D45=\"\",\"\",(IF(D45=\"1 to 2\",\"Low\",IF(D45=\"3 to 5\",\"Average\",\"High\"))))","v":""},null,{"$f":"IF(OR(E45=\"\",NOT(ISNUMBER(F45))),\"\",IF(E45=\"Low\",F45*2,IF(E45=\"Average\",F45*3,IF(E45=\"High\",F45*4))))","v":""},null,null,null,{"$f":"IF(J45=\"\",\"\",IF(J45=\"0 to 3\",\"Low\",IF(J45=\"4 to 9\",\"Average\",\"High\")))","v":""},{"$f":"IF(OR(H45=\"\",K45=\"\",NOT(ISNUMBER(I45))),\"\",IF(H45=\"Logical\",IF(K45=\"Low\",4*I45,IF(K45=\"Average\",6*I45,IF(K45=\"High\",10*I45))),IF(H45=\"Mathematical\",IF(K45=\"Low\",3*I45,IF(K45=\"Average\",4*I45,IF(K45=\"High\",7*I45,\"Error\"))))))","v":""},null,null,{"$f":"IF(OR(M45=\"\",N45=\"\",NOT(ISNUMBER(N45))),\"\",IF(M45=\"Low\",N45*2,IF(M45=\"Average\",N45*3,IF(M45=\"High\",N45*5))))","v":""},null,{"$f":"IF(P45=\"\",\"\",IF(P45=\"1 to 3\",\"Low\",IF(P45=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(R45=\"\",NOT(ISNUMBER(R45))),\"\",IF(P45=\"\",\"\",IF(Q45=\"Low\",R45*4,IF(Q45=\"Average\",R45*6,IF(Q45=\"High\",R45*10)))))","v":""},null,{"$f":"IF(T45=\"\",\"\",IF(T45=\"1 to 10\",\"Low\",IF(T45=\"11 to 29\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(T45=\"\",V45=\"\",NOT(ISNUMBER(V45))),\"\",IF(U45=\"Low\",V45*6,IF(U45=\"Average\",V45*8,IF(U45=\"High\",V45*12))))","v":""},null,null,{"$f":"IF(Y45=\"\",\"\",IF(Y45=\"1 to 9\",\"Low\",IF(Y45=\"10 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(Z45=\"\",NOT(ISNUMBER(AA45))),\"\",IF(Z45=\"Low\",AA45*2,IF(Z45=\"Average\",AA45*3,IF(Z45=\"High\",AA45*4))))","v":""},null,null,{"$f":"IFERROR(ROUND(IF(AC45=\"No\",AD45/16,IF(AC45=\"yes\",(2+(AD45/16)),\"\")),1),\"\")","v":""},null,{"$f":"IF(AF45=\"\",\"\",IF(AF45=\"1 to 4\",\"Low\",IF(AF45=\"5 to 15\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AG45=\"\",NOT(ISNUMBER(AH45))),\"\",IF(AG45=\"Low\",AH45*3,IF(AG45=\"Average\",AH45*4,IF(AG45=\"High\",AH45*6))))","v":""},null,{"$f":"IF(AJ45=\"\",\"\",IF(AJ45=\"1 to 5\",\"Low\",IF(AJ45=\"6 to 19\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AK45=\"\",NOT(ISNUMBER(AL45))),\"\",IF(AK45=\"Low\",AL45*3,IF(AK45=\"Average\",AL45*4,IF(AK45=\"High\",AL45*6))))","v":""},null,null,null,null,{"$f":"IF(BN45=\"\",\"\",IF(BN45=\"BA\",\"TBD\",IF(BN45=\"AA\",IF(AP45=2,20,IF(AP45=3,30,IF(AP45>3,40))),IF(BN45=\"AB\",IF(AP45=2,40,IF(AP45=3,60,IF(AP45>3,80))),IF(BN45=\"AC\",IF(AP45=2,10,IF(AP45=3,20,IF(AP45>3,30))))))))","v":""},null,null,{"$f":"IF(OR(AS45=\"\",AT45=\"\"),\"\",VLOOKUP(BO45,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,{"$f":"IF(AU45=\"\",\"\",IF(AU45=\"Low\",AV45*6,IF(AU45=\"Average\",AV45*9,IF(AU45=\"High\",AV45*12))))","v":""},null,{"$f":"IF(AX45=\"\",\"\",IF(AX45=\"1 to 3\",\"Low\",IF(AX45=\"4 to 9\",\"Average\",\"High\")))","v":""},null,{"$f":"IF(OR(AX45=\"\",NOT(ISNUMBER(AZ45))),\"\",IF(AY45=\"Low\",AZ45*4,IF(AY45=\"Average\",AZ45*6,IF(AY45=\"High\",AZ45*10))))","v":""},null,null,null,{"$f":"IF(AND(NOT(ISNUMBER(BD45)),NOT(ISNUMBER(BC45))),\"\",(BC45*3+BD45*4))","v":""},null,{"$f":"IF(BF45=\"\",\"\",IF(BF45=\"1 to 5\",\"Low\",IF(BF45=\"6 to 19\",\"Average\",\"High\")))","v":""},null,null,{"$f":"IF(OR(BF45=\"\",(BH45+BI45)=0,NOT(ISNUMBER(BI45)),NOT(ISNUMBER(BH45))),\"\",IF(BG45=\"Low\",(BH45+BI45)*3,IF(BG45=\"Average\",(BH45+BI45)*4,IF(BG45=\"High\",(BH45+BI45)*6))))","v":""},null,null,null,{"$f":"IF(AO45=\"\",\"\",IF(AO45=\"Software Platform\",IF(AQ45=\"Same family\",\"AA\",IF(AQ45=\"Different Family\",\"AB\",\"AC\")),IF(AO45=\"Hardware Platform\",\"BA\")))","v":""},{"$f":"AT45&AS45","v":""}]
[39,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS46=\"\",AT46=\"\"),\"\",VLOOKUP(BO46,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[40,"ADD",null,null,"",null,"",null,null,null,"","",null,null,"",null,"",null,"",null,"",null,"",null,null,"",null,"",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"",null,null,{"$f":"IF(OR(AS47=\"\",AT47=\"\"),\"\",VLOOKUP(BO47,Parameters!$B$75:$C$83,2,FALSE))","v":""},null,"",null,"",null,"",null,null,null,"",null,"",null,null,"",null,null,null,"",""]
[]
[null,null,"Totals",null,null,null,{"$f":"+SUM(G8:G47)","v":12},null,null,null,null,{"$f":"+SUM(L8:L47)","v":12},null,null,{"$f":"+SUM(O8:O47)","v":8},null,null,null,{"$f":"+SUM(S8:S47)","v":80},null,null,null,{"$f":"+SUM(W8:W47)","v":60},{"$f":"+SUM(X8:X47)","v":0},null,null,null,{"$f":"+SUM(AB8:AB47)","v":21},null,null,{"$f":"+SUM(AE8:AE47)","v":3.6},null,null,null,{"$f":"+SUM(AI8:AI47)","v":36},null,null,null,{"$f":"+SUM(AM8:AM47)","v":8},{"$f":"+SUM(AN8:AN47)","v":234},null,null,null,{"$f":"+SUM(AR8:AR47)","v":60},null,null,null,null,{"$f":"+SUM(AW8:AW47)","v":45},null,null,null,{"$f":"+SUM(BA8:BA47)","v":4},{"$f":"+SUM(BB8:BB47)","v":23},null,null,{"$f":"+SUM(BE8:BE47)","v":31},null,null,null,null,{"$f":"+SUM(BJ8:BJ47)","v":20},{"$f":"+SUM(BK8:BK47)","v":78}]
[null,null,"Total for \"New\"",null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",G8:G47)","v":12},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",L8:L47)","v":12},null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",O8:O47)","v":8},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",S8:S47)","v":80},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",W8:W47)","v":60},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AB8:AB47)","v":21},null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AE8:AE47)","v":3.6},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AI8:AI47)","v":36},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AM8:AM47)","v":8},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AR8:AR47)","v":60},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",AW8:AW47)","v":45},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",BA8:BA47)","v":4},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",BE8:BE47)","v":31},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"ADD\",BJ8:BJ47)","v":20}]
[null,null,"Total for \"Change\"",null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",G8:G47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",L8:L47)","v":0},null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",O8:O47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",S8:S47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",W8:W47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AB8:AB47)","v":0},null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AE8:AE47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AI8:AI47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AM8:AM47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AR8:AR47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",AW8:AW47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",BA8:BA47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",BE8:BE47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"CHG\",BJ8:BJ47)","v":0}]
[null,null,"Total for \"Delete\"",null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",G8:G47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",L8:L47)","v":0},null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",O8:O47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",S8:S47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",W8:W47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AB8:AB47)","v":0},null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AE8:AE47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AI8:AI47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AM8:AM47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AR8:AR47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",AW8:AW47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",BA8:BA47)","v":0},null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",BE8:BE47)","v":0},null,null,null,null,{"$f":"SUMIF($B$8:$B$47,\"DEL\",BJ8:BJ47)","v":0}]
[]
[null,null,null,"Comments",null,null,null,"Comments",null,null,null,null,"Comments",null,null,"Comments",null,null,null,"Comments",null,null,null,null,"Comments",null,null,null,"Comments",null,null,"Comments",null,null,null,"Comments",null,null,null,null,"Comments",null,null,null,"Comments",null,null,null,null,"Comments",null,null,null,"Comments",null,null,null,"Comments"]

{"sheet":"Recap","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,5]]}
["RECAP"]
[]
[null,null,"SNAP Count"]
["SNAP Category and Subcategory Recap",null,"Total","Add","Change","Delete","Effort in Person-Hours"]
["Category 1.  Data Operations",null,null,null,null,null,{"$f":"'SNAP Counting Sheet'!X49","v":0}]
[1.1000000000000001,"Data Entry Validation",{"$f":"'SNAP Counting Sheet'!G49","v":12},{"$f":"'SNAP Counting Sheet'!G50","v":12},{"$f":"'SNAP Counting Sheet'!G51","v":0},{"$f":"'SNAP Counting Sheet'!G52","v":0}]
[1.2,"Logical and Mathematical Operations",{"$f":"'SNAP Counting Sheet'!L49","v":12},{"$f":"'SNAP Counting Sheet'!L50","v":12},{"$f":"'SNAP Counting Sheet'!L51","v":0},{"$f":"'SNAP Counting Sheet'!L52","v":0}]
[1.3,"Data Formatting",{"$f":"'SNAP Counting Sheet'!O49","v":8},{"$f":"'SNAP Counting Sheet'!O50","v":8},{"$f":"'SNAP Counting Sheet'!O51","v":0},{"$f":"'SNAP Counting Sheet'!O52","v":0}]
[1.4,"Internal Data Movements",{"$f":"'SNAP Counting Sheet'!S49","v":80},{"$f":"'SNAP Counting Sheet'!S50","v":80},{"$f":"'SNAP Counting Sheet'!S51","v":0},{"$f":"'SNAP Counting Sheet'!S52","v":0}]
[1.5,"Delivering Added Value to Users by Data Configuration",{"$f":"'SNAP Counting Sheet'!W49","v":60},{"$f":"'SNAP Counting Sheet'!W50","v":60},{"$f":"'SNAP Counting Sheet'!W51","v":0},{"$f":"'SNAP Counting Sheet'!W52","v":0}]
[]
["Category 2.  Interface Design",null,null,null,null,null,{"$f":"'SNAP Counting Sheet'!AN49","v":234}]
[2.1,"UI Changes",{"$f":"'SNAP Counting Sheet'!AB49","v":21},{"$f":"'SNAP Counting Sheet'!AB50","v":21},{"$f":"'SNAP Counting Sheet'!AB51","v":0},{"$f":"'SNAP Counting Sheet'!AB52","v":0}]
[2.2000000000000002,"Help Methods",{"$f":"'SNAP Counting Sheet'!AE49","v":3.6},{"$f":"'SNAP Counting Sheet'!AE50","v":3.6},{"$f":"'SNAP Counting Sheet'!AE51","v":0},{"$f":"'SNAP Counting Sheet'!AE52","v":0}]
[2.2999999999999998,"Multiple Input Methods",{"$f":"'SNAP Counting Sheet'!AI49","v":36},{"$f":"'SNAP Counting Sheet'!AI50","v":36},{"$f":"'SNAP Counting Sheet'!AI51","v":0},{"$f":"'SNAP Counting Sheet'!AI52","v":0}]
[2.4,"Multiple Output Methods",{"$f":"'SNAP Counting Sheet'!AM49","v":8},{"$f":"'SNAP Counting Sheet'!AM50","v":8},{"$f":"'SNAP Counting Sheet'!AM51","v":0},{"$f":"'SNAP Counting Sheet'!AM52","v":0}]
[]
["Category 3.  Technical Environment",null,null,null,null,null,{"$f":"'SNAP Counting Sheet'!BB49","v":23}]
[3.1,"Multiple Platforms",{"$f":"'SNAP Counting Sheet'!AR49","v":60},{"$f":"'SNAP Counting Sheet'!AR50","v":60},{"$f":"'SNAP Counting Sheet'!AR51","v":0},{"$f":"'SNAP Counting Sheet'!AR52","v":0}]
[3.2,"Database Technology",{"$f":"'SNAP Counting Sheet'!AW49","v":45},{"$f":"'SNAP Counting Sheet'!AW50","v":45},{"$f":"'SNAP Counting Sheet'!AW51","v":0},{"$f":"'SNAP Counting Sheet'!AW52","v":0}]
[3.3,"Batch Processes",{"$f":"'SNAP Counting Sheet'!BA49","v":4},{"$f":"'SNAP Counting Sheet'!BA50","v":4},{"$f":"'SNAP Counting Sheet'!BA51","v":0},{"$f":"'SNAP Counting Sheet'!BA52","v":0}]
[]
["Category 4.  Architecture",null,null,null,null,null,{"$f":"'SNAP Counting Sheet'!BK49","v":78}]
[4.2,"Component Based Software",{"$f":"'SNAP Counting Sheet'!BE49","v":31},{"$f":"'SNAP Counting Sheet'!BE50","v":31},{"$f":"'SNAP Counting Sheet'!BE51","v":0},{"$f":"'SNAP Counting Sheet'!BE52","v":0}]
[4.3,{"$f":"'SNAP Counting Sheet'!BF4","v":"4.2  Multiple Input / Output Interfaces"},{"$f":"'SNAP Counting Sheet'!BJ49","v":20},{"$f":"'SNAP Counting Sheet'!BJ50","v":20},{"$f":"'SNAP Counting Sheet'!BJ51","v":0},{"$f":"'SNAP Counting Sheet'!BJ52","v":0}]
[]
[null,"Total SNAP Points",{"$f":"SUM(C4:C25)","v":400.6},{"$f":"SUM(D4:D25)","v":400.6},{"$f":"SUM(E4:E25)","v":0},{"$f":"SUM(F4:F25)","v":0}]
[null,"Total SNAP Effort",null,null,null,null,{"$f":"SUM(G5:G25)","v":335}]

{"sheet":"Parameters","index":4,"n_rows":100,"n_cols":15,"rows_kept":100,"cut":false,"hidden":false,"merged":[[68,3,68,5],[70,1,72,1]]}
[]
[]
[null,null,"Hours",null,"Effort",null,"Help type",null,"Platform type",null,"Data Replication"]
[null,"man*hours",1,null,"Estimated",null,"Yes",null,"Software Platform",null,"1. No replication of data"]
[null,"man*days",{"$f":"C4*9","v":9},null,"Planned",null,"No",null,"Hardware Platform",null,"2. Replication of data should happen at runtime at the same time"]
[null,"man*weeks",{"$f":"C5*5","v":45},null,"Actual",null,null,null,null,null,"3. Replication of data can happen offline in batch mode"]
[null,"man*months",180,null,"ROM",null,null,null,null,null,"4. Replication of data will be handled automatically by the database"]
[]
[]
[null,null,null,null,null,null,null,null,"Architecture"]
[null,"Project Type",null,null,"Industry",null,null,null,"Stand Alone",null,"Time Record"]
[null,"New Development",null,null,"Aerospace / Automotive",null,null,null,"Client Server",null,"No timesheets were recorded by the development team"]
[null,"Re-Development",null,null,"Agriculture, Forestry, Fishing, Hunting",null,null,null,"Multi-tier",null,"Recorded only the total hours worked each day or week. "]
[null,"Maintenance",null,null,"Amusement/Game Center",null,null,null,"SOA",null,"Recorded hours worked on each project for each day/week. "]
[null,"Enhancement",null,null,"Banking; Financial services",null,null,null,"Cloud",null,"Recorded the work done on each project task for each day. "]
[null,"Other",null,null,"Billing",null,null,null,"Other",null,"Other (specify):  "]
[null,null,null,null,"Business Services"]
[null,null,null,null,"Chemicals; Energy",null,"Application Type"]
[null,null,null,null,"Commercial services",null,"Microcode",null,null,null,"database technology"]
[null,"Quality",null,null,"Communications",null,"RealTime",null,null,null,"V. Simple",1,"Code Data"]
[null,"Poor",null,null,"Computers & Software",null,"Avionic",null,null,null,"Simple",2,"Temporary Files only"]
[null,"Adequate",null,null,"Electronics",null,"System",null,null,null,"Medium",3,"Change in Queries"]
[null,"Good",null,null,"Community Services",null,"C&C",null,null,null,"Complex",4,"Change in Queries and Views"]
[null,"Excellent",null,null,"Human Resources",null,"Telecom",null,null,null,"V. Complex",5,"Alter table and other impacted queries"]
[null,null,null,null,"Construction",null,"Scientific"]
[null,null,null,null,"Consultancy",null,"Process Control",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Stage",null,null,"Consumer Goods",null,"Business",null,null,null,"1.2 Subcategory","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Planning",null,null,"Defence (aka Defense)",null,"Unknown",null,null,null,"Main intent:","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Specification",null,null,"Education Institution",null,null,null,null,null,"Logical","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Design",null,null,"Electricity, Gas, Water",null,null,null,null,null,"Mathematical","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Build",null,null,"Engineering",null,"3D modeling or animation",null,null,null,"1.3 Subcategory","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Test",null,null,"Government",null,"Catalogue or register of things or events",null,null,null,"Low","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Implementation",null,null,"Insurance",null,"Customer billing",null,null,null,"Average",null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,null,null,null,"Stocking",null,"Customer relationship management",null,null,null,"High",null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Counter",null,null,"Food Processing",null,"Distribution",null,null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Reading &/or mentoring",null,null,"Information Technology",null,"Document management",null,null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Course from in-house trainer",null,null,"Manufacturing",null,"Device or interface driver",null,null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Course from specialized function point trainer",null,null,"Media",null,"Electronic data interchange",null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Course certified by FSM method’s certification body",null,null,"Medical and Health Care",null,"Financial transaction processing & accounting",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Other (specify):",null,null,"Mining",null,"Geographic or spatial information systems",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,null,null,null,"Oil & Petroleum",null,"Graphics & publishing tools or system",null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Primary Technology",null,null,"Other (Specify)",null,"Image, video or sound processing ",null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Programming Language",null,null,"Publishing",null,"Software for machine control",null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Operating System ",null,null,"Professional Services",null,"Job, case, incident or project management",null,null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Integrated Development Environment   ",null,null,"Real Estate & Property",null,"Logistic or supply planning & control",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Environment",null,null,"Recreation & Personnel Services",null,"Management or performance reporting",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Debugging",null,null,"Sales",null,"Mathematical modeling (finance or engineering)",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Database",null,null,"Telecommunication",null,"Network management"]
[null,"Object/Component Server",null,null,"Transport & Storage",null,"Online analysis and reporting",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"HTML/Web Server",null,null,"Wholesale & Retail ",null,"Operating system or software utility",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"E-Mail or Message Server",null,null,null,null,"Personal productivity (e.g. word processor, spreadsheet)",null,null,null,"Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan","Talmon Ben-Cnaan"]
[null,"Other (specify):  ",null,null,null,null,"Process control ",null,null,null,"Talmon Ben-Cnaan"]
[null,null,null,null,null,null,"Software development tool",null,null,null,"Talmon Ben-Cnaan"]
[null,"Nesting",null,null,"Records_1.5",null,"Stock control & order processing",null,null,null,"Talmon Ben-Cnaan"]
[null,"1 to 2",null,null,"1 to 10",null,"Trading",null,null,null,"Talmon Ben-Cnaan"]
[null,"3 to 5",null,null,"11 to 29",null,"Workflow support & management"]
[null,"6+",null,null,"30+",null,"Other (specify):  "]
[]
[null,"FTR_Validation","FTR_1.4",null,"Properties_2.1",null,"DETs_2.3",null,"DETs_2.4",null,"DETs_3.2"]
[null,"0 to 3","1 to 3",null,"1 to 9",null,"1 to 4",null,"1 to 5",null,"1 to 19"]
[null,"4 to 9","4 to 9",null,"10 to 15",null,"5 to 15",null,"6 to 19",null,"20 to 50"]
[null,"10+","10+",null,"16+",null,"16+",null,"20+",null,"51+"]
[]
[null,"RETs_3.2",null,null,"FTRs_3.3",null,"DETs_4.2"]
[null,1,null,null,"1 to 3",null,"1 to 5"]
[null,"2 to 5",null,null,"4 to 9",null,"6 to 19"]
[null,"6+",null,null,"10+",null,"20+"]
[]
[null,null,null,"DETs"]
[null,null,null,null,"1 to 19",null,"20 to 50",null,"51+"]
[null,"RETs",1,null,"Low",null,"Low",null,"Average"]
[null,null,"2 to 5",null,"Low",null,"Average",null,"High"]
[null,null,"6+",null,"Average",null,"High",null,"High"]
[]
[null,{"$f":"C71&E70","v":"11 to 19"},"Low"]
[null,{"$f":"C72&E70","v":"2 to 51 to 19"},"Low"]
[null,{"$f":"C73&E70","v":"6+1 to 19"},{"$f":"E73","v":"Average"}]
[null,{"$f":"C71&G70","v":"120 to 50"},{"$f":"G71","v":"Low"}]
[null,{"$f":"C72&G70","v":"2 to 520 to 50"},{"$f":"G72","v":"Average"}]
[null,{"$f":"C73&G70","v":"6+20 to 50"},{"$f":"G73","v":"High"}]
[null,{"$f":"C71&I70","v":"151+"},{"$f":"I71","v":"Average"}]
[null,{"$f":"C72&I70","v":"2 to 551+"},{"$f":"I72","v":"High"}]
[null,{"$f":"C73&I70","v":"6+51+"},{"$f":"I73","v":"High"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Password:SNAPversion20"]