{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Macro Notice","Tables","VersionChanges","Settings","ShapeEnumeration","ShipPhase","CheckList Color","RiskData","RiskMatrix","AttrData","Sorter","DOIList","CARCount","001-Document Review ","003-TESTING","004-Hull Fairness"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":4,"defined_names":106,"comments":4,"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":"Macro Notice","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,11,33,11],[0,1,0,11],[33,0,33,10],[0,0,32,0],[1,1,4,10],[16,6,17,9],[7,1,7,4],[7,6,7,9],[15,6,15,9]]}
["Click Anywhere","If Macros are Running  Click Anywhere"]
[null,"The Risk Assessment Spreadsheet relies heavily on Macros and VBA coding.  In order to proceed further you are required to enable Macros. Please exit Excel and Enable Macros when you reopen.",null,null,null,null,null,null,null,null,null,"Click Anywhere"]
[]
[]
[]
[]
[]
[null,"Initial Options to Permit Macros",null,null,null,null,"When opening the Dashboard"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Editing Template\n"]
[null,null,null,null,null,null,"Programmatic access to Visual Basic Project is not trusted"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If Macros are Running  Click Anywhere"]

{"sheet":"Tables","index":1,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":true,"merged":[[9,1,9,2],[9,4,10,9],[25,1,25,2]]}
[null,null,"Personnel","Vessel","Milestone","Schedule","Cost","Operability","Occurrence",null,null,null,null,null,"Administrator (USERNAME)",null,"Failure"]
[1,"Personnel","SOLAS","Mission Degrade","Significant Impact","Significant Impact","Significant Impact","Significant Impact","Unlikely to occur [1.0]",1,null,null,null,null,"Kevin.Kilborn.CTR",null,"Unlikely to occur [1.0]"]
[2,"Vessel","Mission Degrade","Significant Impact","Moderate Impact","Moderate Impact","Moderate Impact","Moderate Impact","May occur in time [1.4]",1.4,null,null,null,null,"Lukasz.Tabor",null,"May occur in time [1.7]"]
[3,"Milestone","Significant Impact","Moderate Impact","Little Impact","Little Impact","Little Impact","Little Impact","Probably will occur in time [1.8]",1.8,null,"Operability",{"$f":"IF($L4=\"Death\",5,IF($L4=\"Injury\",4.8,IF($L4=\"SOLAS\",4.8,IF($L4=\"Mission Degrade\",4.8,IF($L4=\"Significant Impact\",3.5,IF($L4=\"Moderate Impact\",2.5,IF(L4=\"Operability\",3,IF($L4=\"Little Impact\",1))))))))","v":3},null,null,null,"Probably will occur in time [2.4]"]
[4,"Schedule","Moderate Impact","Little Impact",null,null,null,null,"Likely to occur within a short period of time [2.2]",2.2000000000000002,null,null,null,null,null,null,"Likely to occur within a short period of time [3.1]"]
[5,"Cost","Little Impact",null,null,null,null,null,"Likely to occur immediately [2.6]",2.6,null,null,null,null,null,null,"Likely to occur immediately [3.8]"]
[null,null,null,null,null,null,null,null,"Inevitable [3.0]",3]
[]
[]
[null,"OBSWeight",null,null,"Attribute Lookup (Used in Probability of Quality Failure Formula)\nReturn value is set (Up To) the Percent (Ctrl-Alt-F9) Forces calculations"]
[null,0,2]
[null,10,1.9,null,null,"CheckList","Percent","Vlookup","Return"]
[null,30,1.8,null,null,"005",0,{"$f":"F13 & TEXT(G13,\"0.000\")","v":"0050.000"},1]
[null,50,1.7,null,null,"005",1.7500000000000002E-2,"0050.018",2]
[null,100,1.6,null,null,"005",0.03,"0050.030",3.5]
[null,150,1.5,null,null,"005",1,"0051.000",5,"Prefix","Other"]
[null,200,1.4,null,null,"006A",0,"006A0.000",1,"Percent",0.32]
[null,350,1.3,null,null,"006A",1.7500000000000002E-2,"006A0.018",2,"Combined",{"$f":"K16&TEXT(K17,\"0.000\")","v":"Other0.320"}]
[null,500,1.2,null,null,"006A",2.5000000000000001E-2,"006A0.025",3.5,"Result",{"$f":"VLOOKUP(K18,Exceptions,2,TRUE)","v":1}]
[null,1000,1.1000000000000001,null,null,"006A",1,"006A1.000",5]
[null,10000,1,null,null,"016",0,"0160.000",1]
[null,null,null,null,null,"016",1.7500000000000002E-2,"0160.018",2]
[null,null,null,null,null,"016",2.5000000000000001E-2,"0160.025",3.5]
[null,null,null,null,null,"016",1,"0161.000",5]
[null,null,null,null,null,"018",0,"0180.000",1]
[null,"OBSCheckListWeight",null,null,null,"018",1.4999999999999999E-2,"0180.015",2,"*"]
[null,0,2,null,null,"018",0.02,"0180.020",3.5,"*"]
[null,10,1.9,null,null,"018",1,"0181.000",5,"*"]
[null,30,1.8,null,null,"018A",0,"018A0.000",1,"*"]
[null,50,1.7,null,null,"018A",1.4999999999999999E-2,"018A0.015",2]
[null,100,1.6,null,null,"018A",0.02,"018A0.020",3.5]
[null,150,1.5,null,null,"018A",1,"018A1.000",5]
[null,200,1.4,null,null,"018B",0,"018B0.000",1]
[null,350,1.3,null,null,"018B",1.4999999999999999E-2,"018B0.015",2]
[null,500,1.2,null,null,"018B",0.02,"018B0.020",3.5]
[null,1000,1.1000000000000001,null,null,"018B",1,"018B1.000",5]
[null,10000,1,null,null,"018C",0,"018C0.000",1]
[null,null,null,null,null,"018C",1.4999999999999999E-2,"018C0.015",2]
[null,null,null,null,null,"018C",0.02,"018C0.020",3.5]
[null,null,null,null,null,"018C",1,"018C1.000",5]
[null,null,null,null,null,"018D",0,"018D0.000",1]
[null,null,null,null,null,"018D",1.4999999999999999E-2,"018D0.015",2]
[null,null,null,null,null,"018D",0.02,"018D0.020",3.5]
[null,null,null,null,null,"018D",1,"018D1.000",5]
[null,null,null,null,null,"018E",0,"018E0.000",1]
[null,null,null,null,null,"018E",1.4999999999999999E-2,"018E0.015",2]
[null,null,null,null,null,"018E",0.02,"018E0.020",3.5]
[null,null,null,null,null,"018E",1,"018E1.000",5]
[null,null,null,null,null,"019B",0,"019B0.000",1]
[null,null,null,null,null,"019B",1.7500000000000002E-2,"019B0.018",2]
[null,null,null,null,null,"019B",2.5000000000000001E-2,"019B0.025",3.5]
[null,null,null,null,null,"019B",1,"019B1.000",5]
[null,null,null,null,null,"Other",0,"Other0.000",1]
[null,null,null,null,null,"Other",2.1000000000000001E-2,"Other0.021",2]
[null,null,null,null,null,"Other",0.05,"Other0.050",3.5,null,{"$f":"TEXT(G55,\"0.0000\")","v":"0.0500"}]
[null,null,null,null,null,"Other",1,"Other1.000",5]

{"sheet":"VersionChanges","index":2,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Current Version","2.01.25",{"$f":"LEN(B1)","v":7}]
["Version","Description Keep < 255 characters\n(Can't use the VBA Copy (Synchronize) Mechanism without causing 'Unable to Record' downstream problems",136]
["1.00.00","Beta release, including macro notice.",37]
["1.00.10","Rounding checklists so that they'll appear in the same object. ",63]
["1.00.20","1. Configurable X & Y coordinate change values that affect the grouping of checklists into the same shape.  \n2. Revised scatter so that if rounding the riskdata remains the same and the shapes are shifted.\n",206]
["1.00.20","3. Added Debug property that permits changing X & Y coordinates during Matrix creation.\n4. Added matrix legend.",111]
["1.00.25","1. Provide drill-down into Attributes for the Shape selected.\n2. Added Tile button as an additional way to 'scatter' shapes.\n3. Scatter and Tile may be used in conjunction with each other.",188]
["1.00.50","1. Provide colors corresponding to the Risk Matrix Legend\n2. Average X & Y coordinates between the DOI & the Checklist\n3. Was I & N now it's G & L\n4. Y < year * 1; > = 12 < 18 then *1.5; >= 18 months * 2\n",204]
["1.00.50","5. Add a date reviewed to each checklist which should influence both the X & Y\n6. Change the X & Y coordinates to Y - 20 & X - 7.5\n7. Drop column F 'Process Review and G 'Process Quality Modifier\n",196]
["1.00.50","8. Deletion of columns misaligned data.  Needed to provide a merge function.\n9. Mitigation comments were missing\n10.Average row needed to be incorporated in Populate Formula\n11. Total Row needed to be incorporated in Populate Formula\n",234]
["1.00.50","\n12. Changed X & Y Axis and along with functions that determine position of objects including placement, scatter, color and tile.\n13. Set Print Area to include the Average Line used in calculations",197]
["1.01.1","1. Mechanism that propagates code changes to all files beginning with SSBA tool *.xls in the current or subfolders. This will keep all ship programs sychnronized.",162]
["1.20.0","1. Function that determines the Probability of Failure.\n2. Automatically put function where it belongs with dynamic parameters.\n3. Factors need to use Exception list on the Settings Page\n4. Not on list use the default\n5. Produce Checklist Color",244]
["1.20.03","1.  Sort worksheets after VBA Code",34]
["1.21.00","1. Didn't count Import file if no Accepts but it would have Rejects\n2. Allow comma delimited Checklist and Attributes in columns AA & AB",136]
["1.21.10","1. Introduce Phase of Construction and Phase Factor\n2. ShipPhase worksheet and the automatic inclusion of new checklist\n3. Message validating checklist Phase Factor\n4. Minimum and Maximum RiskData values that keep the checklist on the matrix\n5. Revised formulas to account for additional 5 risk columns",302,"2013-04-12"]
["2.01.10","1. Additional Columns\n2. Changed Format\n3. Changed Import",57]
["2.01.15","Process DOI worksheet",21]
["2.01.20","Deprecate columns AA,AZ which contain a redundant checklist and attribute list.  New rule requires that only the Attribute exists in Column A while the checklist is inferred by the prefix of the worksheet.",205]
["2.01.21","Add Total to the DOIList",24]
["2.01.25","History List, Highlight DOI Months if > 18",42]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"Settings","index":3,"n_rows":114,"n_cols":45,"rows_kept":114,"cut":false,"hidden":true,"merged":[[4,17,4,18],[5,17,5,18],[3,19,3,20],[4,19,4,20],[0,17,1,20],[2,17,2,18],[2,19,2,20],[3,17,3,18],[5,19,5,20],[0,2,1,4],[13,7,13,16],[17,7,17,16],[16,7,16,16],[14,7,14,16],[15,7,15,16],[6,19,6,20],[6,17,6,18],[0,0,1,1],[5,7,5,16],[10,7,10,16],[2,7,2,16],[6,7,6,16],[4,7,4,16],[7,7,7,16],[8,7,8,16],[9,7,9,16],[0,7,1,16],[3,7,3,16],[3,2,26,4],[12,7,12,16],[21,7,21,16],[59,0,59,14],[22,7,22,16],[35,1,35,4],[32,1,33,4],[34,2,34,4],[38,16,38,20],[28,7,28,16],[29,0,31,0],[29,1,31,1],[29,2,31,4],[37,2,37,4],[28,2,28,4],[38,22,38,26],[24,7,24,16],[8,17,8,18],[8,19,8,20],[7,17,7,18],[7,19,7,20],[11,7,11,16],[20,7,20,16],[18,7,18,16],[19,7,19,16]]}
["Configuration Settings",null,"Options",null,null,null,null,"Import Instructions & Features",null,null,null,null,null,null,null,null,null,"Configuration Settings"]
[]
["Checklist Prefix","  ",null,null,null,null,null,"• Checklists for each ship program use a prefix designation for the ship class.  Please enter that prefix exactly as it is found in the TSM export file (example: DDG1000).",null,null,null,null,null,null,null,null,null,"Level Green\n(Up To)",null,190]
["Data File Directory:","\\Exported Data",null,null,null,null,null,"• Point to the default export directory.  You may use an absolute path by using a drive letter followed by a colon (:), or you may use a relative path beginning with just a backslash (\\).\n• Alternatively run the TSM export (See Import File Process).",null,null,null,null,null,null,null,null,null,"Yellow Level\n(Up To)",null,900]
["File to Process:","F:\\Projects\\Code 300\\Risk Assessmentx\\Exported Data\\20151214_Risk_Assess_data_wit.xlsx",null,null,null,null,null,"• Type the name of the file or press Select File.",null,null,null,null,null,null,null,null,null,"Red Level\n(Starting At)",null,800.1]
["Import:",null,null,null,null,null,null,"• Imports the data in the File to Process into the worksheets",null,null,null,null,null,null,null,null,null,"UI Version",null,"1.10.13; 02/10/2016; Corrected Combined and Phase Selection"]
["Add Rejects/Total Obs comments:",true,null,null,null,null,null,"• Adds Rejects/Total Observatios and (checklist/attribute) information to comment blocks.",null,null,null,null,null,null,null,null,null,"Ship Class",null,"DDG1000"]
["Displays the Comment Block:","No",null,null,null,null,null,"• Shows the comment block. If false comments are available by hovering over the cell.",null,null,null,null,null,null,null,null,null,"Hull No",null,1000]
["Set Print Areas:",false,null,null,null,null,null,"• Sets print area and headings for reports.",null,null,null,null,null,null,null,null,null,"Checklist Total Row",null,-1]
["View Mode:","Normal",null,null,null,null,null,"• Sets the view mode to Print Preview or Normal"]
["Hide:",false,null,null,null,null,null,"• Hides columns Q - AB (Columns AA & AB contain the Checklist and Attribute respectively."]
["Window Freeze:",true,null,null,null,null,null,"• Freezes all worksheets on C3"]
["Available Files (Used for History Import):",null,null,null,null,null,null,"• Indicates the files (monYY) files in the data directory.  Populate this cell by selecting the History radio button. Remove the files from the list will prevent those files from processing."]
["Protect:",false,null,null,null,null,null,"• All worksheets are protected after Import."]
["Zoom:",60,null,null,null,null,null,"• Sets the Zoom property on all worksheets."]
["Landscape:",true,null,null,null,null,null,"• Sets to landscape mode."]
["Load Matrix:",false,null,null,null,null,null,"• Re-loads the RA Matrix.  Automatically set to True after Import, false after re-load."]
["Matrix shows only checklists with Rejects for this period:",false,null,null,null,null,null,"• Removes clutter from Risk Assessment Matrix by skipping check lists without rejects for this time period. False shows all checklists."]
["Matrix Rounds X & Y Coordinates:",false,null,null,null,null,null,"• Variations is checklists are often quite small and can't be plotted.  Rounds checklist coordinants and displays rounded results in the same shape up to 255 characters per shape. "]
["X-Variance",0.5,null,null,null,null,null,"• If the difference between past and current checklist's X value is >= this value then a new shape is created."]
["Y-Variance",0.8,null,null,null,null,null,"• If the difference between past and current checklist's Y value is >= this value then a new shape is created."]
["Attribute DrillDown:",true,null,null,null,null,null,"• On RiskMatrix, clicking on checklist prompts for Attribute drilldown."]
["Debug:",false,null,null,null,null,null,"• True will stop the creation of Matrix shapes and permit changing X & Y cooridinates for testing purposes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V3*W1"]
["Risk Matrix Title:","Risk Matrix [FileName]"]
["Version:",{"$f":"Version","v":"2.01.25"},null,null,null,null,null,"• Version of this spreadsheet.  Click either cell to see the latest features and fixes."]
["Ship Phase","After Launch/Water",null,null,null,null,null,"The # of the current Ship Phase. Changing the phase requires that the Formulas be repopulated.  To set the Phase Factor use the Ship Phase worksheet."]
["Total Phases",6,null,null,null,null,null,"Total Number of Ship Phases. Is used to prepopulate the ShipPhase worksheet."]
["DOI DB Path","F:\\Projects\\Code 300\\Schedule\\BE\\Scheduling-IIData.accdb",null,null,null,null,null,"Path to the database containing the Procedure List"]
[null,null,null,null,null,null,null,"Apply Formats and Formulas"]
["Place Formulas and Formats in all the Checklist Worksheets:",false,null,null,null,null,null,"The title block, along with all its text and formatting is copied to each worksheets.  Aside from column 1 (A), all the columns widths are set here."]
[null,null,null,null,null,null,null,"The formula row represents each row of data in the DOI and Checklist Sections.  Control the cell attributes of each cell including the locked state, colors and fonts. \nChange the modifier formulas or insert static text by entering the pseudo formulas into"]
[]
[]
[null,null,null,null,null,null,null,"Aggregate Functions are applied immediately below the heading for DOI & Checklist.  Use (Average)…Other functions require programming support."]
["Update Underlying VBA Code",null,null,null,null,null,null,"To create a new ship program copy this workbook as the template for the next program.  Enter the DOI's, Checklists, Governed By, Oversight columns along with Checklist and Attributes in Columns (AA, AB). Then select Clear Contents checkbox.  Finally, pres"]
["Merge Data After Removing or Adding a Column:",null,null,null,null,null,null,"Copies all VBA & Macro code to any similarly named spreadsheets in the current folder.  The workbooks changed will begin with \"ssba tool\" (not case sensitive)."]
[null,null,null,null,null,null,null,"When columns are added or removed the data in each worksheet may fall under the wrong column.  Merging prompts for another workbook where the data and columns are aligned.  Merging gathers the data from the original file and maps it back to the correct co"]
["Checklist\nFormulas",null,"M - Mandatory / Statutory\nS - Specification driven\nP - Builder Process\nC - Crew/Customer request",null,null,null,null,null,null,null,null,null,"Reviewed:","2009-08-01",{"$f":"IF(NOW()-N38< 365,1,IF(NOW()-N38>545,2,1.5))","v":2},null,null,null,null,null,null,"Phase Factor","=VLOOKUP(ShipPhase,ShipPhase!A2:B1000,2,FALSE)"]
[null,"Process Details","Governed by","Oversight Requirements","Necessity Modifier","Total OBS","OBS Weight","Procedure Evaluation Reject Rate","Reject Probability","Method A Count","Method A Weight","Method B Count","Method B Weight","N/A","CAR Average","Probability of Quality Failure","Failure Affects",null,null,null,null,"Impact Modifier","Severity of Failure",null,null,null,null,"Severity Modifier","Severity Factor","Max Risk","Date",null,null,null,null,null,null,null,null,null,null,null,null,"CheckList","Percent"]
[null,null,null,null,"MAX",null,null,null,null,null,null,null,null,null,null,"MAX","Personnel","Vessel","Milestone","Schedule","Cost","MAX","SOLAS","Mission Degrade","Significant Impact","Moderate Impact","Little Impact","MAX","=V3*AB3*$W$1","MAX",null,null,null,"`"]
[null,null,null,null,"=IF($D[row]=\"M\",2,IF($D[row]=\"C\",1,IF($D[row]=\"P\",1.25,IF($D[row]=\"S\",1.5))))",null,"=VLOOKUP($F[row],OBSWeight,2,True)",null,"=GetRejectProbability(\"[Prefix]\", H[row])","=GetCARCountAttr(\"A\",\"[worksheet]\", A[row],I[row])","=GetCARWeight(\"A\",J[row])","=GetCARCountAttr(\"B\",\"[worksheet]\",A[row],K[row])","=GetCARWeight(\"B\",L[row])",null,"=(K[row]+M[row])/2","=(E[row]*G[row]*I[row])*O[row]",null,null,null,null,null,"=MAX($Q[row],$R[row],$S[row],$T[row],$U[row])",null,null,null,null,null,"=MAX($W[row],$X[row],$Y[row],$Z[row],$AA[row])","=$V[row]*$AB[row]*$W$1","=P[row]*AC[row] "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prob of Quality Failure","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]",null,"Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]"]
[]
[]
[null,null,null,null,null,null,null,null,null,"=(IF($F[row]>5%,5,(IF($F[row]>3.5%,3,(IF($F[row]>2%,2,1))))))*E[row]"]
[]
[]
[]
[]
["Total","003-TESTING",0,"=GetOversight(\"[worksheet]\",[maxrow])","=IF($D[row]=\"M\",2,IF($D[row]=\"C\",1,IF($D[row]=\"P\",1.25,IF($D[row]=\"S\",1.5))))",109,"=VLOOKUP($F[row],OBSCheckListWeight,2,True)",0,"=GetRejectProbability(\"[Prefix]\", H[row])","=GetCARCountCL(\"A\",\"[worksheet]\",I[row])","=GetCARWeight(\"A\",J[row])","=GetCARCountCL(\"B\",\"[worksheet]\",K[row])","=GetCARWeight(\"B\",L[row])",null,"=(K[row]+M[row])/2","=(E[row]*G[row]*I[row])*O[row]","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX($Q[row],$R[row],$S[row],$T[row],$U[row])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX([col]4:[col][maxrow])","=MAX($W[row],$X[row],$Y[row],$Z[row],$AA[row])","=$V[row]*$AB[row]*$W$1","=P[row]*AC[row] "]
[]
[]
[]
[]
[]
[]
[]
[]
["Import File Process"]
["The Risk Assessment data uses the same data that supplies the QDE with one notable exception.  It also requires the Document/Alias column."]
["We can change the QDE to accept this column too, but it does require a bit of work to maintain compatibility with previous export files not containing that field."]
["• Select the shared TSM query: Monthly Data for Process Charts/Drill Downs  and add Document/Alias to it's columns.  "]
["• Select the appropriate Document Date range."]
["• Export the file Saving it to the location specified in the QDE Data Files (monYY.xls) cell.  It must conform to the monYY.xls naming convention."]
[]
[]
[]
[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,null,null,null,null,null,{"$f":"Tables!K16","v":"Other"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sample Export File"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Settings"]
[]
["003-Testing"]
["Settings"]

{"sheet":"ShapeEnumeration","index":4,"n_rows":185,"n_cols":2,"rows_kept":185,"cut":false,"hidden":true,"merged":[]}
["Description"]
["msoShape10pointStar",149]
["msoShape12pointStar",150]
["msoShape16pointStar",94]
["msoShape24pointStar",95]
["msoShape32pointStar",96]
["msoShape4pointStar",91]
["msoShape5pointStar",92]
["msoShape6pointStar",147]
["msoShape7pointStar",148]
["msoShape8pointStar",93]
["msoShapeActionButtonBackorPrevious",129]
["msoShapeActionButtonBeginning",131]
["msoShapeActionButtonCustom",125]
["msoShapeActionButtonDocument",134]
["msoShapeActionButtonEnd",132]
["msoShapeActionButtonForwardorNext",130]
["msoShapeActionButtonHelp",127]
["msoShapeActionButtonHome",126]
["msoShapeActionButtonInformation",128]
["msoShapeActionButtonMovie",136]
["msoShapeActionButtonReturn",133]
["msoShapeActionButtonSound",135]
["msoShapeArc",25]
["msoShapeBalloon",137]
["msoShapeBentArrow",41]
["msoShapeBentUpArrow",44]
["msoShapeBevel",15]
["msoShapeBlockArc",20]
["msoShapeCan",13]
["msoShapeChartPlus",182]
["msoShapeChartStar",181]
["msoShapeChartX",180]
["msoShapeChevron",52]
["msoShapeChord",161]
["msoShapeCircularArrow",60]
["msoShapeCloud",179]
["msoShapeCloudCallout",108]
["msoShapeCorner",162]
["msoShapeCornerTabs",169]
["msoShapeCross",11]
["msoShapeCube",14]
["msoShapeCurvedDownArrow",48]
["msoShapeCurvedDownRibbon",100]
["msoShapeCurvedLeftArrow",46]
["msoShapeCurvedRightArrow",45]
["msoShapeCurvedUpArrow",47]
["msoShapeCurvedUpRibbon",99]
["msoShapeDecagon",144]
["msoShapeDiagonalStripe",141]
["msoShapeDiamond",4]
["msoShapeDodecagon",146]
["msoShapeDonut",18]
["msoShapeDoubleBrace",27]
["msoShapeDoubleBracket",26]
["msoShapeDoubleWave",104]
["msoShapeDownArrow",36]
["msoShapeDownArrowCallout",56]
["msoShapeDownRibbon",98]
["msoShapeExplosion1",89]
["msoShapeExplosion2",90]
["msoShapeFlowchartAlternateProcess",62]
["msoShapeFlowchartCard",75]
["msoShapeFlowchartCollate",79]
["msoShapeFlowchartConnector",73]
["msoShapeFlowchartData",64]
["msoShapeFlowchartDecision",63]
["msoShapeFlowchartDelay",84]
["msoShapeFlowchartDirectAccessStorage",87]
["msoShapeFlowchartDisplay",88]
["msoShapeFlowchartDocument",67]
["msoShapeFlowchartExtract",81]
["msoShapeFlowchartInternalStorage",66]
["msoShapeFlowchartMagneticDisk",86]
["msoShapeFlowchartManualInput",71]
["msoShapeFlowchartManualOperation",72]
["msoShapeFlowchartMerge",82]
["msoShapeFlowchartMultidocument",68]
["msoShapeFlowchartOfflineStorage",139]
["msoShapeFlowchartOffpageConnector",74]
["msoShapeFlowchartOr",78]
["msoShapeFlowchartPredefinedProcess",65]
["msoShapeFlowchartPreparation",70]
["msoShapeFlowchartProcess",61]
["msoShapeFlowchartPunchedTape",76]
["msoShapeFlowchartSequentialAccessStorage",85]
["msoShapeFlowchartSort",80]
["msoShapeFlowchartStoredData",83]
["msoShapeFlowchartSummingJunction",77]
["msoShapeFlowchartTerminator",69]
["msoShapeFoldedCorner",16]
["msoShapeFrame",158]
["msoShapeFunnel",174]
["msoShapeGear6",172]
["msoShapeGear9",173]
["msoShapeHalfFrame",159]
["msoShapeHeart",21]
["msoShapeHeptagon",145]
["msoShapeHexagon",10]
["msoShapeHorizontalScroll",102]
["msoShapeIsoscelesTriangle",7]
["msoShapeLeftArrow",34]
["msoShapeLeftArrowCallout",54]
["msoShapeLeftBrace",31]
["msoShapeLeftBracket",29]
["msoShapeLeftCircularArrow",176]
["msoShapeLeftRightArrow",37]
["msoShapeLeftRightArrowCallout",57]
["msoShapeLeftRightCircularArrow",177]
["msoShapeLeftRightRibbon",140]
["msoShapeLeftRightUpArrow",40]
["msoShapeLeftUpArrow",43]
["msoShapeLightningBolt",22]
["msoShapeLineCallout1",103]
["msoShapeLineCallout1AccentBar",113]
["msoShapeLineCallout1BorderandAccentBar",121]
["msoShapeLineCallout1NoBorder",117]
["msoShapeLineCallout2",110]
["msoShapeLineCallout2AccentBar",114]
["msoShapeLineCallout2BorderandAccentBar",122]
["msoShapeLineCallout2NoBorder",118]
["msoShapeLineCallout3",111]
["msoShapeLineCallout3AccentBar",115]
["msoShapeLineCallout3BorderandAccentBar",123]
["msoShapeLineCallout3NoBorder",119]
["msoShapeLineCallout4",112]
["msoShapeLineCallout4AccentBar",116]
["msoShapeLineCallout4BorderandAccentBar",124]
["msoShapeLineCallout4NoBorder",120]
["msoShapeLineInverse",183]
["msoShapeMathDivide",166]
["msoShapeMathEqual",167]
["msoShapeMathMinus",164]
["msoShapeMathMultiply",165]
["msoShapeMathNotEqual",168]
["msoShapeMathPlus",163]
["msoShapeMixed",-2]
["msoShapeMoon",24]
["msoShapeNonIsoscelesTrapezoid",143]
["msoShapeNoSymbol",19]
["msoShapeNotchedRightArrow",50]
["msoShapeNotPrimitive",138]
["msoShapeOctagon",6]
["msoShapeOval",9]
["msoShapeOvalCallout",107]
["msoShapeParallelogram",2]
["msoShapePentagon",51]
["msoShapePie",142]
["msoShapePieWedge",175]
["msoShapePlaque",28]
["msoShapePlaqueTabs",171]
["msoShapeQuadArrow",39]
["msoShapeQuadArrowCallout",59]
["msoShapeRectangle",1]
["msoShapeRectangularCallout",105]
["msoShapeRegularPentagon",12]
["msoShapeRightArrow",33]
["msoShapeRightArrowCallout",53]
["msoShapeRightBrace",32]
["msoShapeRightBracket",30]
["msoShapeRightTriangle",8]
["msoShapeRound1Rectangle",151]
["msoShapeRound2DiagRectangle",153]
["msoShapeRound2SameRectangle",152]
["msoShapeRoundedRectangle",5]
["msoShapeRoundedRectangularCallout",106]
["msoShapeSmileyFace",17]
["msoShapeSnip1Rectangle",155]
["msoShapeSnip2DiagRectangle",157]
["msoShapeSnip2SameRectangle",156]
["msoShapeSnipRoundRectangle",154]
["msoShapeSquareTabs",170]
["msoShapeStripedRightArrow",49]
["msoShapeSun",23]
["msoShapeSwooshArrow",178]
["msoShapeTear",160]
["msoShapeTrapezoid",3]
["msoShapeUpArrow",35]
["msoShapeUpArrowCallout",55]
["msoShapeUpDownArrow",38]
["msoShapeUpDownArrowCallout",58]
["msoShapeUpRibbon",97]
["msoShapeUTurnArrow",42]
["msoShapeVerticalScroll",101]
["msoShapeWave",103]

{"sheet":"ShipPhase","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Ship Phase\n(Derived Settings)","Factor"]
["Planning/Procurement",1.5]
["Fabrication",2]
["Assembly/Erection",3]
["Outfit",4]
["Landlevel/Ways",5]
["After Launch/Water",5.5]

{"sheet":"CheckList Color","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["CheckList","Color"]

{"sheet":"RiskData","index":7,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["CheckList","X-Axis\nPhase Factor","Y-Axis\nProp of Qual Failure","Value"]
["001",5.5,3,16.5]
["003",36.299999999999997,5.45,197.65]
["004",49.5,9,445.5]

{"sheet":"RiskMatrix","index":8,"n_rows":138,"n_cols":104,"rows_kept":138,"cut":false,"hidden":true,"merged":[[9,1,107,1],[5,4,6,102],[120,15,122,63],[123,15,125,63],[126,15,128,63],[119,15,119,63],[119,11,119,14],[120,11,122,14],[118,68,121,106],[123,11,125,14],[126,11,128,14],[127,68,127,105],[111,4,111,103],[23,2,25,2],[35,2,39,2],[57,2,60,2],[76,2,80,2],[101,2,105,2],[113,4,114,38],[7,9,7,13],[7,4,7,8],[7,34,7,38],[7,29,7,33],[7,24,7,28],[7,19,7,23],[7,14,7,18]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Risk Matrix — 1000"]
[]
[]
[null,null,null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16,16.5,17,17.5,18,18.5,19,19.5,20,20.5,21,21.5,22,22.5,23,23.5,24,24.5,25,25.5,26,26.5,27,27.5,28,28.5,29,29.5,30,30.5,31,31.5,32,32.5,33,33.5,34,34.5,35,35.5,36,36.5,37,37.5,38,38.5,39,39.5,40,40.5,41,41.5,42,42.5,43,43.5,44,44.5,45,45.5,46,46.5,47,47.5,48,48.5,49,49.5,50]
[null,"Probability",null,50]
[null,null,null,49.5]
[null,null,null,49]
[null,null,null,48.5]
[null,null,null,48]
[null,null,null,47.5]
[null,null,null,47]
[null,null,null,46.5]
[null,null,null,46]
[null,null,null,45.5]
[null,null,null,45]
[null,null,null,44.5]
[null,null,null,44]
[null,null,null,43.5]
[null,null,"Probable",43]
[null,null,null,42.5]
[null,null,null,42]
[null,null,null,41.5]
[null,null,null,41]
[null,null,null,40.5]
[null,null,null,40]
[null,null,null,39.5]
[null,null,null,39]
[null,null,null,38.5]
[null,null,null,38]
[null,null,null,37.5]
[null,null,"Likely",37]
[null,null,null,36.5]
[null,null,null,36]
[null,null,null,35.5]
[null,null,null,35]
[null,null,null,34.5]
[null,null,null,34]
[null,null,null,33.5]
[null,null,null,33]
[null,null,null,32.5]
[null,null,null,32]
[null,null,null,31.5]
[null,null,null,31]
[null,null,null,30.5]
[null,null,null,30]
[null,null,null,29.5]
[null,null,null,29]
[null,null,null,28.5]
[null,null,null,28]
[null,null,null,27.5]
[null,null,null,27]
[null,null,null,26.5]
[null,null,"Occasional",26]
[null,null,null,25.5]
[null,null,null,25]
[null,null,null,24.5]
[null,null,null,24]
[null,null,null,23.5]
[null,null,null,23]
[null,null,null,22.5]
[null,null,null,22]
[null,null,null,21.5]
[null,null,null,21]
[null,null,null,20.5]
[null,null,null,20]
[null,null,null,19.5]
[null,null,null,19]
[null,null,null,18.5]
[null,null,null,18]
[null,null,null,17.5]
[null,null,null,17]
[null,null,"Seldom",16.5]
[null,null,null,16]
[null,null,null,15.5]
[null,null,null,15]
[null,null,null,14.5]
[null,null,null,14]
[null,null,null,13.5]
[null,null,null,13]
[null,null,null,12.5]
[null,null,null,12]
[null,null,null,11.5]
[null,null,null,11]
[null,null,null,10.5]
[null,null,null,10]
[null,null,null,9.5]
[null,null,null,9]
[null,null,null,8.5]
[null,null,null,8]
[null,null,null,7.5]
[null,null,null,7]
[null,null,null,6.5]
[null,null,null,6]
[null,null,null,5.5]
[null,null,null,5]
[null,null,null,4.5]
[null,null,"Unlikely",4]
[null,null,null,3.5]
[null,null,null,3]
[null,null,null,2.5]
[null,null,null,2]
[null,null,null,1.5]
[null,null,null,1]
[]
[null,null,null,null,null,null,null,"Insignificant",null,null,null,null,null,null,"Marginal",null,null,null,null,null,null,"Moderate",null,null,null,null,null,null,"Critical",null,null,null,null,null,null,"Catastrophic"]
[]
[null,null,null,null,"Severity/Impact"]
[]
[null,null,null,null,"Vulnerabilities"]
[]
[]
[]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change the template to change the Resulting Text displayed."]
[null,null,null,null,null,null,null,null,null,null,null,"RISK RATING",null,null,null,"ESCALATION"]
[null,null,null,null,null,null,null,null,null,null,null,"HIGH RISK\r\n( >= 800.1 )",null,null,null,"- Immediate escalation of Risk to senior Management (QAO and QM) for prioritized Risk and treatment plan response \n-  Weekly reviews of progress by senior management (QAO and QM) to be undertaken      "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"MODERATE Risk\r\n( >= 190 < 900)",null,null,null,"-   Escalation of Risk to line Management (QAO and QM) for discussion on appropriate treatment plan response\n - Monthly monitoring of Risk and progress of Risk response or treatment plans to be undertaken as part of existing local program meetings"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"LOW RISK\r\n( 0 < 190 )",null,null,null,"-   Bi-monthly monitoring of risk and progress of risk response or treatment plans to be undertaken as part of existing local program meetings   \n-   No immediate need to develop future treatment plans or response strategies"]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"msoShapeRoundedRectangle"]
[]
[]
[]
[]
[]
[]
[]
[null,"Drilldown"]
[null,"Navigate"]
[null,"Select Shape to Move"]

{"sheet":"AttrData","index":9,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Attribute","X-Axis","Y-Axis","Value"]
["SIGN OFF - COMPARTMENT VERIFIED COMPLETE ",3.61,2.8499999999999996,10.288499999999999]
["CANCELLATION < AFTER 0700 ",3.61,14.249999999999998,51.442499999999988]
["CANCELLATION > BEFORE 0700",3.61,14.249999999999998,51.442499999999988]

{"sheet":"Sorter","index":10,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["oval-3",1610.2501220703125,1169.25,33,1232.25]
["oval-2",1625.2501220703125,1184.25,33,1316.25]
["oval-1",1640.2501220703125,1199.25,33,1320]

{"sheet":"DOIList","index":11,"n_rows":190,"n_cols":53,"rows_kept":190,"cut":false,"hidden":true,"merged":[[1,16,1,20],[0,2,0,4],[1,22,1,26]]}
["DOI Formulas",null,"M - Mandatory / Statutory\nS - Specification driven\nP - Builder Process\nC - Crew/Customer request",null,null,null,null,null,null,null,null,null,"Reviewed:","2009-08-01",{"$f":"IF(NOW()-N1< 365,1,IF(NOW()-N1>545,2,1.5))","v":2},null,null,null,null,null,null,"Phase Factor",{"$f":"VLOOKUP(ShipPhase,ShipPhase!A2:B1000,2,FALSE)","v":5.5}]
["DOI","Process Details","Click 'Gorverned by' to reset","Oversight Requirements","Necessity Modifier","Total OBS","OBS Weight","Procedure Evaluation Reject Rate","Reject Probability","Method A Count","Method A Weight","Method B Count","Method B Weight","N/A","CAR Average","Probability of Quality Failure","Failure Affects",null,null,null,null,"Impact Modifier","Severity of Failure",null,null,null,null,"Severity Modifier","Severity Factor","Max Risk","PE Date","Elapsed Months"]
[null,null,null,null,{"$f":"MAX(E4:E30)","v":1.25},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P4:P30)","v":2.5},"Personnel","Vessel","Milestone","Schedule","Cost",{"$f":"MAX(V4:V30)","v":1},"SOLAS","Mission Degrade","Significant Impact","Moderate Impact","Little Impact",{"$f":"MAX(AB4:AB30)","v":1},{"$f":"V3*AB3*$W$1","v":5.5},{"$f":"MAX(AD4:AD30)","v":13.75},null,{"$f":"IF(AE4>36500,(YEAR(TODAY())-YEAR(AE4))*12+(MONTH(TODAY())-MONTH(AE4)),\"\")","v":79}]
["BIW-NDT-WP","BIW-NDT-WRITTEN PRACTICE","Proc","P",{"$f":"IF($D4=\"M\",2,IF($D4=\"C\",1,IF($D4=\"P\",1.25,IF($D4=\"S\",1.5))))","v":1.25},0,{"$f":"VLOOKUP($F4,OBSWeight,2,TRUE)","v":2},0,{"$f":"GetRejectProbability(\"001-Document\", H4)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"001-Document Review \", A4,I4)","v":0},{"$f":"GetCARWeight(\"A\",J4)","v":1},{"$f":"GetCARCountAttr(\"B\",\"001-Document Review \",A4,K4)","v":0},{"$f":"GetCARWeight(\"B\",L4)","v":1},null,{"$f":"(K4+M4)/2","v":1},{"$f":"(E4*G4*I4)*O4","v":2.5},1,1,1,1,1,{"$f":"MAX($Q4,$R4,$S4,$T4,$U4)","v":1},1,1,1,1,1,{"$f":"MAX($W4,$X4,$Y4,$Z4,$AA4)","v":1},{"$f":"$V4*$AB4*$W$1","v":5.5},{"$f":"P4*AC4","v":13.75},"2011-10-20"]
["DOI 10-120","VENTILATION INSPECTION PRIOR TO COVERING AND TESTING","Proc","P",{"$f":"IF($D5=\"M\",2,IF($D5=\"C\",1,IF($D5=\"P\",1.25,IF($D5=\"S\",1.5))))","v":1.25},0,2,0,{"$f":"GetRejectProbability(\"001-Document\", H5)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"001-Document Review \", A5,I5)","v":0},{"$f":"GetCARWeight(\"A\",J5)","v":1},{"$f":"GetCARCountAttr(\"B\",\"001-Document Review \",A5,K5)","v":0},{"$f":"GetCARWeight(\"B\",L5)","v":1},null,{"$f":"(K5+M5)/2","v":1},{"$f":"(E5*G5*I5)*O5","v":2.5},1,1,1,1,1,{"$f":"MAX($Q5,$R5,$S5,$T5,$U5)","v":1},1,1,1,1,1,{"$f":"MAX($W5,$X5,$Y5,$Z5,$AA5)","v":1},{"$f":"$V5*$AB5*$W$1","v":5.5},{"$f":"P5*AC5","v":13.75}]
["DOI-06-101","Hull Structural Material Control","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-103","Issuing and Processing the Record of Quality Deficiency (RQD)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-09-15"]
["DOI-06-104","Quality Assurance Receipt Inspection","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2012-05-22","2012-01-27","2011-11-29","2011-10-26","2011-09-15","2010-10-01"]
["DOI-06-106","DOI 06-106, Non-Destructive Testing (NDT) of Hull Structure","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2012-02-29","2012-01-25"]
["DOI-06-106 MT","Non-Destructive Testing (NDT)  - MT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-106 PT","Non-Destructive Testing (NDT)  - PT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-106 RT","Non-Destructive Testing (NDT)  - RT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-106 UT","Non-Destructive Testing (NDT)  - UT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-106 VT","Non-Destructive Testing (NDT)  - VT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-107","Inspection and Documentation of Welded Pipe Joints in P-1 Piping","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2010-08-16","2010-04-07"]
["DOI-06-109","Compartment General Inspection","Proc","P",1.25,17,1.9,0,"1",0,1,0,1,null,1,2.375,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.0625,"2014-09-01"]
["DOI-06-113","Issuing and Processing the Record of Quality Observation(QO)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-116","Review of Supplier Furnished Radiographs","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2010-04-16"]
["DOI-06-119","Evaluation, Selection and Use of Suppliers","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-11-18","2013-07-09"]
["DOI-06-120","Supplier Quality System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-07-09"]
["DOI-06-123","Material Identification by Color Code","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-124","Procedure to be used in Receiving, Handling, Storing and Transporting Resiliently Mounted Equipment","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-03-01","2013-12-09","2012-01-19"]
["DOI-06-125","Procedure for Source Inspection","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-11-01"]
["DOI-06-128","Qualification of Nondestructive Test (NDT) Personnel","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-10-20"]
["DOI-06-129","Statistical Techniques","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-130","Unplanned Labor System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-133","Procedure for Approving shipment of Discrepant Supplier Equipment/Material","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-134","PREVENTIVE MAINTENANCE OF SHIP MATERIAL FROM STORAGE THROUGH DELIVERY","Proc","P",1.25,204,1.4,0,"1",0,1,0,1,null,1,1.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,9.625,"2014-08-01","2014-07-01","2014-06-01","2014-02-01","2014-01-01","2013-12-27","2013-12-26","2013-12-09","2013-09-27","2013-02-25","2012-11-29","2012-09-14","2012-08-23","2012-05-30","2012-05-23","2012-04-27","2011-11-29","2011-04-28"]
["DOI-06-135","D/91 Receipt Inspection and Storage of Contractor Furnished Material","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-11-18"]
["DOI-06-136","Identification of Bolting Materials","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-03-26"]
["DOI-06-138","Procedure for Layout of Hull Markings","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-10-29","2013-10-21","2013-10-10"]
["DOI-06-140","Quality Problem Log","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-03-01","2014-02-01"]
["DOI-06-142","Instruction for Completing the F-2506","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-144","Material Discrepancy Reporting (MDR) System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-147","Corrective Action Requests (CARs)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-148","Initial Quality Planning","Proc","P",1.25,0,{"$f":"VLOOKUP($F36,OBSWeight,2,TRUE)","v":2},0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-149","Quality Program Organization","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-06-152","Inspection Plan for Random or Partial RT and UT Inspections","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-07-101","Relief Valve Calibration Test","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-07-01","2013-12-26","2013-03-26","2013-02-28"]
["DOI-07-102","BIW MANUFACTURED BOLTS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-09-109","Installation and Alignment of Machinery and Equipment","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-08-01","2014-07-01","2014-01-01","2013-11-21"]
["DOI-09-110","Process for Verifying Weight of Fire Fighting and Actuation Cylinders","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-09-117","Special Care & Protection of DDG 1000 Gas Turbine Generators (ATG's)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-07-01","2014-01-01","2013-08-16","2013-07-17","2013-04-05","2012-08-29"]
["DOI-09-125","INSTALLATION OF FIXED PITCH PROPELLERS AND RUDDERS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-09-06","2013-08-15"]
["DOI-10-104","Flushing and Cleaning Hydraulic Power Transmission System Piping","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-11-01","2014-01-01","2013-02-08","2013-01-04"]
["DOI-10-105","Procedure to Control hot Work on Structure Supporting Ordnance and Other Alignment Critical Foundations","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-04-10"]
["DOI-10-106","PROCEDURE FOR FLUSHING AND CLEANING LOW PRESSURE VITAL, ELECTRONIC DRY AND COMPRESSED BREATHING AIR PIPING SYSTEMS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-110","FLUSHING AND CLEANING POTABLE/ FRESH WATER SYSTEM PIPING","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-111","Procedure for Flushing and Cleaning the A/C Chilled Water System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-09-20"]
["DOI-10-113","PROCEDURE FOR FLUSHING AND CLEANING DESALINATED WATER SYSTEMS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-114","Flushing and Cleaning Fuel Oil System Piping","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-07-01"]
["DOI-10-116","VT Of Hull Structure, Record of Accomplishment (Fabrication)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2010-06-03","2010-02-09","2010-02-08","2009-08-26","2009-04-17"]
["DOI-10-118","Use of Red Danger Tags","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2010-05-25"]
["DOI-10-119","WATERTIGHT DOORS, HATCHES, AND SCUTTLES INSTALLATION, INSPECTION AND PRE-OPERATIONAL TEST","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-12-21"]
["DOI-10-120","VENTILATION INSPECTION PRIOR TO COVERING AND TESTING","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-09-01"]
["DOI-10-123","Readying Ship for Sea Trials","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-124","DDG 1000 DOI 10-124 INSTALLATION AND CLEANLINESS INSPECTION FOR GAS TURBINE COMBUSTION AIR INTAKES AND EXHAUST SYSTEMS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-06-01","2014-05-01","2014-01-03","2014-01-02","2013-12-17","2013-12-16","2013-12-12","2013-12-02","2013-11-13","2013-11-12","2013-10-30","2013-10-18"]
["DOI-10-126","Fabrication Inspection of Structure Requiring Static Load Test","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-129","VISUAL INSPECTION (VT) OF HULL STRUCTURE","Proc","P",1.25,27,1.9,0,"1",0,1,0,1,null,1,2.375,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.0625,"2014-05-22","2010-04-15","2010-02-05","2010-02-04","2009-08-26"]
["DOI-10-130","VISUAL INSPECTION OF BIW MANUFACTURED GAS TURBINE UPTAKE/INTAKE COMPONENTS AT FABRICATION","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-131","Strength, Tightness and Flushing Testing of Piping Systems","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-04-19","2012-06-29","2011-08-30","2011-07-29"]
["DOI-10-132","Reporting Discrepancies and Repairs using the 2644 Form","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-133","PROCEDURE FOR FLUSHING AND CLEANING THE NITROGEN PIPING SYSTEM ABOARD SHIP","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-135","Final Inspection of Cascade Orificial Restrictive Devices (CORDS)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-03-01","2012-12-28"]
["DOI-10-136","Underwater Hull Inspections","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-138","Gas Turbine Water Wash","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-141","INSTALLATION INSPECTION OF STRUCTURE AND EQUIPMENT REQUIRING STATIC LOAD TEST","Proc","P",1.25,2,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-10-142","Procedure for Care and Protection of Ships and Equipment during Construction","Proc","P",1.25,342,{"$f":"VLOOKUP($F68,OBSWeight,2,TRUE)","v":1.4},2.3952095808383235E-2,"3.5",0,1,0,1,null,1,6.125,1,1,1,1,1,1,1,1,1,1,1,1,5.5,33.6875,"2014-10-01","2014-08-01","2014-06-01","2014-04-01","2014-03-01","2014-02-01","2013-12-09","2013-04-18","2012-12-27","2012-12-07","2012-11-29","2012-09-27","2012-06-12","2012-05-30","2012-03-30","2011-11-23","2011-10-27","2011-08-31","2011-07-29","2011-06-27","2011-04-28","2011-04-27","2011-01-27"]
["DOI-10-144","Unit/Product Turn Over","Proc","P",{"$f":"IF($D69=\"M\",2,IF($D69=\"C\",1,IF($D69=\"P\",1.25,IF($D69=\"S\",1.5))))","v":1.25},0,2,2.3952095808383235E-2,{"$f":"GetRejectProbability(\"001-Document\", H69)","v":"3.5"},{"$f":"GetCARCountAttr(\"A\",\"001-Document Review \", A69,I69)","v":0},{"$f":"GetCARWeight(\"A\",J69)","v":1},{"$f":"GetCARCountAttr(\"B\",\"001-Document Review \",A69,K69)","v":0},{"$f":"GetCARWeight(\"B\",L69)","v":1},null,{"$f":"(K69+M69)/2","v":1},{"$f":"(E69*G69*I69)*O69","v":8.75},1,1,1,1,1,{"$f":"MAX($Q69,$R69,$S69,$T69,$U69)","v":1},1,1,1,1,1,{"$f":"MAX($W69,$X69,$Y69,$Z69,$AA69)","v":1},{"$f":"$V69*$AB69*$W$1","v":5.5},{"$f":"P69*AC69","v":48.125}]
["DOI-10-145","Procedure for Flushing and Cleaning JP-5 Systems","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-146","Use of Yellow Caution Tags","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2013-12-09","2013-04-25","2011-10-21","2010-05-25"]
["DOI-10-148","Flushing and Cleaning PolyAlphaOlefin (PAO)","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-150","Procedure for Ship Transfer","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-151","Sampling Techniques","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2010-04-08"]
["DOI-10-152","Customer Notification for Tests/Inspections","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-153","Measuring and Test Equipment Calibration Program","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2014-05-01","2013-08-30","2012-01-13"]
["DOI-10-154","Quality Alert Procedure","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-155","Fabrication and Inspection of MAFO of MAFO Doors at Hardings Plant","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2011-06-22"]
["DOI-10-157","Procedure for Sign-Off and Completing Status Of Manufacturing Work Orders","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-158","Procedure for Auditing Work Orders","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125]
["DOI-10-161","MAFO DOOR INSTALLATION PROCEDURE","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2011-05-25","2011-05-24"]
["DOI-10-162","Procedure for Protection of the MK57 Vertical Launch System (PVLS Compartments & MK57 Modules)","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2014-11-01","2014-10-01","2014-09-01","2014-08-01","2014-07-01","2014-06-01","2014-05-21","2014-04-08","2014-04-01","2014-03-12","2014-03-01","2014-02-01","2014-01-01","2013-06-14","2013-05-28","2013-04-29","2013-03-04","2013-02-26","2013-01-25","2013-01-02","2012-05-08"]
["DOI-10-163","Inspection of Mil-Spec Manufactured Power and Lighting Panels","Proc","P",1.25,0,2,2.3952095808383235E-2,"3.5",0,1,0,1,null,1,8.75,1,1,1,1,1,1,1,1,1,1,1,1,5.5,48.125,"2012-05-24"]
["DOI-10-164","Temporary / Final Closure of Tanks, Voids, Cofferdams, Etc.","Proc","P",1.25,12,1.9,0,"1",0,1,0,1,null,1,2.375,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.0625,"2013-06-21"]
["DOI-10-165","PROCEDURE FOR CRITICAL COATED AREA","Proc","P",1.25,10,1.9,0.1111111111111111,"5",0,1,0,1,null,1,11.875,1,1,1,1,1,1,1,1,1,1,1,1,5.5,65.3125,"2014-02-01","2013-10-29","2013-09-04","2013-05-09","2013-04-30","2010-07-20"]
["DOI-10-166","GALLEY DRIP PAN AND COAMING INSTALLATION AND TIGHTNESS TEST PROCEDURE","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2010-06-30"]
["DOI-10-168","Compartment Trade Work Inspection Prior to Paint","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2013-04-29","2012-12-06","2012-03-28","2011-10-27"]
["DOI-10-169","Resistance Testing of Grounded Piping in Hazarous Spaces","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2014-09-03","2014-07-01"]
["DOI-10-176","Watertight Door, Hatches, Scuttles and manholdes Pressure Test (Shop Test)","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2011-09-20","2010-09-17"]
["DOI-10-178","INSPECTION FOR PROPER HULL PROTECTION PRIOR TO BLAST AND PAINT OF THE UNDERWATER HULL","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-179","ADVANCED INDUCTION MOTOR (AIM) RECEIPT INSTRUCTIONS AND PREVENTATIVE MAINTENANCE","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2014-09-01","2014-03-01","2014-02-01","2013-11-22","2010-10-19"]
["DOI-10-180","PROCEDURE FOR FLUSHING AND CLEANING THE PROPULSION FRESH WATER SYSTEM","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2013-01-17"]
["DOI-10-181","Protection of Electronic Modular Enclosures (EME)","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2014-06-01","2012-04-24"]
["DOI-10-184","Procedure for Flushing and Cleaning Common Array Cooling System","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-186","Procedure for Flushing and Cleaning High Pressure Water Mist Fire Extinguishing System","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-188","Procedure for Material Substitutions","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-189","Pre-Load Out Inspection of EME Compartments","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-190","Storage & Transportation Requirements For Propulsion Shafting","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-192","Care and Protection of the Composite Superstructure and Helicopter Hanger","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2013-06-14"]
["DOI-10-193","Care and Protection of Passive Countermeasures System (PCMS) Material","Proc","P",1.25,0,{"$f":"VLOOKUP($F100,OBSWeight,2,TRUE)","v":2},0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2013-06-14"]
["DOI-10-195","Post Blast & Paint Hot Work Care & Protection","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-196","Flooding Control Procedure","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-197","Flushing Procedure for Gas Turbine Water Wash Systems Ã¢?? Supply Side","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-198","Preventing Pre-Loading of Ship Stanchions","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-199","Procedure for Marking and Handling of Government Property Removed from Ships and Units","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-10-200","Care and Protection of Main Turbine Generator Termination Box","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-11-102","Installation Procedure for PCMS Tile","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-15-102","Cleaning Requirements for Pipe during Shop Fabrication and Post Installation","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-15-105","PROCEDURE FOR VISUAL INSPECTION OF CLASS \"P-2\" PIPE JOINT (VT)","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-15-106","PROCEDURE FOR MANUAL TORCH BRAZED PIPING SYSTEMS","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75]
["DOI-15-107","Procedure for Bending and Inspection of Pipe and Tubing","Proc","P",1.25,0,2,0.1111111111111111,"5",0,1,0,1,null,1,12.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,68.75,"2011-03-03"]
["DOI-15-110","SHOP TEST OF HOSE ASSEMBLIES FOR RESILIENTLY MOUNTED EQUIPMENT","Proc","P",1.25,4,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-06-01","2013-06-28","2012-12-13","2012-09-14","2012-08-17","2012-07-26","2012-06-15","2012-03-16","2011-09-30"]
["DOI-15-113","Installation Inspection of Degaussing & Catholic Protection Cable Conduits","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-005","INSP OF CLASS A-3 & A-4 NON-STRUCTUAL TANKS & CLASS P2 MANIFOLDS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-100","Quality Inspection Process","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2009-12-30"]
["DOI-16-101","Dimensional Control of Ship Hull Structure Shipyard Areas 20 Through 65","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-102","DIMENTIONAL CONTROL OF HULL STRUCTURE AT FABRICATION","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-103","Final Closure of Tanks, Voids, Cofferdams, Etc.","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-105","INSPECTION AND TEST OF SHOP FABRICATED TANKS AND COMPONENTS","Proc","P",1.25,2,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-106","Inspection of Piping Systems Installation","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-16-107","In-Process and Final Inspection of Hatches, Scuttles and Manholes during Fabrication","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-11-22","2010-11-23"]
["DOI-16-111","DIMENSIONAL CONTROL OF HULL STRUCTURE AT UNIT ERECTION","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-10-28"]
["DOI-16-112","INSPECTION OF KEEL CONDITION DURING ERECTION AND PRIOR TO LAUNCH","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-07-21"]
["DOI-19-104","Procedure for Cables Splicing/Repair","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-01-08","2014-01-06","2013-04-23","2013-04-09","2012-08-06","2012-08-03"]
["DOI-19-106","Examination of Electrical Equipment Prior to Activation","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-19-108","Bonding, Grounding and Installation of Electronic TEMPEST Equipment","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-19-113","MONITORING THE OPERATION OF AUTOMATIC IMPRESSED CURRENT CATHODIC PROTECTION SYSTEMS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-19-116","Procedure for Handling, Protection and Transportation of Electronics Equipment from Arrival until Installation","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-05-01"]
["DOI-19-118","INSPECTION AND TESTING OF FIBER OPTIC CABLE IN STROAGE","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-05-01","2014-01-07","2013-12-05","2013-11-19","2013-09-20","2012-05-25"]
["DOI-19-122","Battery Maintenance","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-19-140","IPS Equipment Inspection","Proc","P",1.25,21,1.9,0,"1",0,1,0,1,null,1,2.375,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.0625,"2013-03-25","2013-02-01"]
["DOI-19-141","Electrical Safety Approach for Shipboard System Activation","Proc","P",1.25,0,{"$f":"VLOOKUP($F132,OBSWeight,2,TRUE)","v":2},0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-24-001","PURCHASING","Proc","P",{"$f":"IF($D133=\"M\",2,IF($D133=\"C\",1,IF($D133=\"P\",1.25,IF($D133=\"S\",1.5))))","v":1.25},1195,1.1000000000000001,0,{"$f":"GetRejectProbability(\"001-Document\", H133)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"001-Document Review \", A133,I133)","v":0},{"$f":"GetCARWeight(\"A\",J133)","v":1},{"$f":"GetCARCountAttr(\"B\",\"001-Document Review \",A133,K133)","v":0},{"$f":"GetCARWeight(\"B\",L133)","v":1},null,{"$f":"(K133+M133)/2","v":1},{"$f":"(E133*G133*I133)*O133","v":1.375},1,1,1,1,1,{"$f":"MAX($Q133,$R133,$S133,$T133,$U133)","v":1},1,1,1,1,1,{"$f":"MAX($W133,$X133,$Y133,$Z133,$AA133)","v":1},{"$f":"$V133*$AB133*$W$1","v":5.5},{"$f":"P133*AC133","v":7.5625}]
["DOI-26-101","Procedure for Assuring Virus Free Delivery of DDG 1000 Class Ships","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-27-109","Inspection Plan for the Application of Pre-Construction Primer (PCP)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-40-102","Foundation Machining and Alignment Procedure for Weapons Systems","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-05-01","2013-07-05","2013-06-05","2013-05-23"]
["DOI-40-103","Procedure for Combat Systems Mechanical Alignment","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-09-26"]
["DOI-40-104","Flatness Critical Foundation Fabrication and Installation Procedure","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-40-105","Procedure for Establishing Reference Lines for Combat Systems Alignment","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-413-01","Control of Nonconforming Product","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-11-15"]
["DOI-414-01","Corrective/Preventive Action Program","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-416-01","Control of Quality Records","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-417-01","Quality Assurance Audit Program Plan","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-101","WELDING AND BRAZING PROCEDURE QUALIFICATION","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-102","VT Inspection Acceptance Criteria","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-103","Structural Workmanship Inspection Acceptance Criteria","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2010-08-20"]
["DOI-42-104","Training and Qualification Requirements for Visual Weld Inspections (VT)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-105","Welding Practices","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-106","Inspection of Stud Welding","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-107","Welder and Welding Operator Qualification","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-42-108","Fabrication Requirements for Titanium (S-51 Material)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-422-01","Inspection System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-50-101","UNIT ERECTION","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-07-21"]
["DOI-50-103","FAIRNESS AND SMOOTHNESS INSPECTION OF CRITICAL UNDERWATER HULL STRUCTURE","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-50-107","Compartment/Tank Air Testing","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-07-10"]
["DOI-50-109","EXTERIOR HULL FAIRNESS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-50-110","PROCEDURE FOR COMPLETION TESTING OF SEACHESTS AND OVERBOARD DISCHARGES","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2013-05-09"]
["DOI-83-102","CALIBRATION OF SUPPORT AND TEST EQUIPMENT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-05-01"]
["DOI-91-010","Material Control (Handling & Storage)","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-101","BIW Trial Card System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-102","RECEIPT INSPECTION OF PAINT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2014-11-01","2013-05-06"]
["DOI-91-103","Material Control in Stockrooms and Storage Areas","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-104","Direct Put-a-way for Material","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-106","REMAKE WORK ORDER SYSTEM","Proc","P",1.25,0,{"$f":"VLOOKUP($F164,OBSWeight,2,TRUE)","v":2},0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-109","PIER MANAGEMENT","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["DOI-91-122","MATERIAL REASSIGNMENT AFTER ISSUE","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["OP 6.2.2.1 (SUPSHIP)","(SUPSHIP) Personnel Training and Certification of Nondestructive Personnel rev 4","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QA MANUAL","QA MANUAL","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2012-10-03"]
["QP 405-01","CONTROL OF DOCUMENTS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QP 413-01","Control of Nonconforming Product","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QP 414-01","Corrective/Preventive Action Program","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QP 416-01","Control of Quality Records","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QP-417-01","Quality Assurance Audit Program Plan","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["QP-422-01","Inspection System","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["SPM-EL-11","Gas Freeing and Hot Work Control on Vessels and Vessel Sections and Landside Spaces","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["SPM-EL-19","TEST & INSPECTION FOR THE FABRICATION AND INSTALLATION OF RE-USABLE LIFTING PADS","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["SPM-S-21","Lockout/Tags-Plus Requirements For Shipboard And Landside Applications","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["WE-20","Procedure for Welding and VT Inspection \r\nSurface Ship Hull Structure","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75,"2011-03-02"]
["WE-21","Procedure for Welding and VT Inspection \r\nPipe and Pressure Vessels","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
["WE-VT-01","Written Practice for Control and Administration of VT Personnel, Training Examination and Certification","Proc","P",1.25,0,2,0,"1",0,1,0,1,null,1,2.5,1,1,1,1,1,1,1,1,1,1,1,1,5.5,13.75]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prob of Quality Failure","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]",null,"Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]"]
[]
[]
[]
[]
[]
[]
[]
["Total","DOI List",0,{"$f":"GetOversight(\"DOIList\",180)","v":"P"},{"$f":"IF($D190=\"M\",2,IF($D190=\"C\",1,IF($D190=\"P\",1.25,IF($D190=\"S\",1.5))))","v":1.25},109,{"$f":"VLOOKUP($F190,OBSCheckListWeight,2,TRUE)","v":1.6},0,{"$f":"GetRejectProbability(\"[Prefix]\", H190)","v":"1"},{"$f":"GetCARCountCL(\"A\",\"DOIList\",I190)","v":0},{"$f":"GetCARWeight(\"A\",J190)","v":1},{"$f":"GetCARCountCL(\"B\",\"DOIList\",K190)","v":0},{"$f":"GetCARWeight(\"B\",L190)","v":1},null,{"$f":"(K190+M190)/2","v":1},{"$f":"(E190*G190*I190)*O190","v":2},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX($Q190,$R190,$S190,$T190,$U190)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX(AF4:AF180)","v":41913},{"$f":"MAX($W190,$X190,$Y190,$Z190,$AA190)","v":41913},{"$f":"$V190*$AB190*$W$1","v":9661847629.5},{"$f":"P190*AC190","v":19323695259}]

{"sheet":"CARCount","index":12,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["CheckList","AttributeNo","CARType","Key","CLKey","Count","CLCount"]
["003","003-A3-PE-0025","B","003-003-A3-PE-0025-B","003-B",1,1]
["003","003-PE-0036","A","003-003-PE-0036-A","003-A",1,1]
["005","005-PE-0070","A","005-005-PE-0070-A","005-A",1,7]
["005","005-PE-0067","A","005-005-PE-0067-A","005-A",1]
["005","005-PE-0065","A","005-005-PE-0065-A","005-A",3]
["005","005-PE-0066","A","005-005-PE-0066-A","005-A",1]
["005","005-PE-0071","A","005-005-PE-0071-A","005-A",1]
["005A","005A-PE-0076","B","005A-005A-PE-0076-B","005A-B",1,1]
["014","014-PVI-0128","A","014-014-PVI-0128-A","014-A",1,1]
["019","019-PVI-0198","A","019-019-PVI-0198-A","019-A",1,1]

{"sheet":"001-Document Review ","index":13,"n_rows":28,"n_cols":31,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,2,0,4],[1,16,1,20],[1,22,1,26]]}
["Checklist\nFormulas",null,"M - Mandatory / Statutory\nS - Specification driven\nP - Builder Process\nC - Crew/Customer request",null,null,null,null,null,null,null,null,null,"Reviewed:","2009-08-01",{"$f":"IF(NOW()-N1< 365,1,IF(NOW()-N1>545,2,1.5))","v":2},null,null,null,null,null,null,"Phase Factor",{"$f":"VLOOKUP(ShipPhase,ShipPhase!A2:B1000,2,FALSE)","v":5.5}]
[null,"Process Details","Governed by","Oversight Requirements","Necessity Modifier","Total OBS","OBS Weight","Procedure Evaluation Reject Rate","Reject Probability","Method A Count","Method A Weight","Method B Count","Method B Weight","N/A","CAR Average","Probability of Quality Failure","Failure Affects",null,null,null,null,"Impact Modifier","Severity of Failure",null,null,null,null,"Severity Modifier","Severity Factor","Max Risk","Date"]
[null,null,null,null,{"$f":"MAX(E4:E18)","v":1.5},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P4:P18)","v":3},"Personnel","Vessel","Milestone","Schedule","Cost",{"$f":"MAX(V4:V18)","v":1},"SOLAS","Mission Degrade","Significant Impact","Moderate Impact","Little Impact",{"$f":"MAX(AB4:AB18)","v":1},{"$f":"V3*AB3*$W$1","v":5.5},{"$f":"MAX(AD4:AD18)","v":16.5}]
["001-DR-0001","Purpose Adequate","Spec","S",{"$f":"IF($D4=\"M\",2,IF($D4=\"C\",1,IF($D4=\"P\",1.25,IF($D4=\"S\",1.5))))","v":1.5},0,{"$f":"VLOOKUP($F4,OBSWeight,2,TRUE)","v":2},0,{"$f":"GetRejectProbability(\"001-Document\", H4)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"001-Document Review \", A4,I4)","v":0},{"$f":"GetCARWeight(\"A\",J4)","v":1},{"$f":"GetCARCountAttr(\"B\",\"001-Document Review \",A4,K4)","v":0},{"$f":"GetCARWeight(\"B\",L4)","v":1},null,{"$f":"(K4+M4)/2","v":1},{"$f":"(E4*G4*I4)*O4","v":3},1,1,1,1,1,{"$f":"MAX($Q4,$R4,$S4,$T4,$U4)","v":1},1,1,1,1,1,{"$f":"MAX($W4,$X4,$Y4,$Z4,$AA4)","v":1},{"$f":"$V4*$AB4*$W$1","v":5.5},{"$f":"P4*AC4","v":16.5}]
["001-DR-0002","Scope Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0003","References Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0004","Definitions Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0005","Procedure Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0006","Records Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0007","Responsibilities Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0008","Notification of inspection and /or Test Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0009","Special Equipment or Process Required Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0010","Special Personnel Qualifications Adequate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0011","Acceptance Standards","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0012","Complies with source document/ contract tech requirement","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0013","Provides for Corrective Action where Appropriate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0014","Safety Precautions Adequate where Appropriate","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
["001-DR-0015","DOI Cancelled","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1,1,1,1,1,1,1,1,1,1,1,1,5.5,16.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prob of Quality Failure","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]",null,"Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]"]
[]
[]
[]
[]
[]
[]
[null,null,"Reject"]
["Total","001-Document Review ",0,{"$f":"GetOversight(\"001-Document Review \",18)","v":"S"},{"$f":"IF($D28=\"M\",2,IF($D28=\"C\",1,IF($D28=\"P\",1.25,IF($D28=\"S\",1.5))))","v":1.5},0,{"$f":"VLOOKUP($F28,OBSCheckListWeight,2,TRUE)","v":2},{"$f":"IF(F28>0,C28/F28,0)","v":0},{"$f":"GetRejectProbability(\"001-Document\", H28)","v":"1"},{"$f":"GetCARCountCL(\"A\",\"001-Document Review \",I28)","v":0},{"$f":"GetCARWeight(\"A\",J28)","v":1},{"$f":"GetCARCountCL(\"B\",\"001-Document Review \",K28)","v":0},{"$f":"GetCARWeight(\"B\",L28)","v":1},null,{"$f":"(K28+M28)/2","v":1},{"$f":"(E28*G28*I28)*O28","v":3},{"$f":"MAX(Q4:Q18)","v":1},{"$f":"MAX(R4:R18)","v":1},{"$f":"MAX(S4:S18)","v":1},{"$f":"MAX(T4:T18)","v":1},{"$f":"MAX(U4:U18)","v":1},{"$f":"MAX($Q28,$R28,$S28,$T28,$U28)","v":1},{"$f":"MAX(W4:W18)","v":1},{"$f":"MAX(X4:X18)","v":1},{"$f":"MAX(Y4:Y18)","v":1},{"$f":"MAX(Z4:Z18)","v":1},{"$f":"MAX(AA4:AA18)","v":1},{"$f":"MAX($W28,$X28,$Y28,$Z28,$AA28)","v":1},{"$f":"$V28*$AB28*$W$1","v":5.5},{"$f":"P28*AC28","v":16.5}]

{"sheet":"003-TESTING","index":14,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,2,0,4],[1,16,1,20],[1,22,1,26]]}
["Checklist\nFormulas",null,"M - Mandatory / Statutory\nS - Specification driven\nP - Builder Process\nC - Crew/Customer request",null,null,null,null,null,null,null,null,null,"Reviewed:","2009-08-01",{"$f":"IF(NOW()-N1< 365,1,IF(NOW()-N1>545,2,1.5))","v":2},null,null,null,null,null,null,"Phase Factor",{"$f":"VLOOKUP(ShipPhase,ShipPhase!A2:B1000,2,FALSE)","v":5.5}]
[null,"Process Details","Governed by","Oversight Requirements","Necessity Modifier","Total OBS","OBS Weight","Procedure Evaluation Reject Rate","Reject Probability","Method A Count","Method A Weight","Method B Count","Method B Weight","N/A","CAR Average","Probability of Quality Failure","Failure Affects",null,null,null,null,"Impact Modifier","Severity of Failure",null,null,null,null,"Severity Modifier","Severity Factor","Max Risk","Date"]
[null,null,null,null,{"$f":"MAX(E4:E30)","v":1.5},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P4:P30)","v":21},"Personnel","Vessel","Milestone","Schedule","Cost",{"$f":"MAX(V4:V30)","v":2.2000000000000002},"SOLAS","Mission Degrade","Significant Impact","Moderate Impact","Little Impact",{"$f":"MAX(AB4:AB30)","v":3},{"$f":"V3*AB3*$W$1","v":36.300000000000004},{"$f":"MAX(AD4:AD30)","v":762.30000000000007}]
["003-A0-PE-0022","Notification of Release of Compartment/Doors/Hatches/ Scuttles","Spec","S",{"$f":"IF($D4=\"M\",2,IF($D4=\"C\",1,IF($D4=\"P\",1.25,IF($D4=\"S\",1.5))))","v":1.5},0,{"$f":"VLOOKUP($F4,OBSWeight,2,TRUE)","v":2},0,{"$f":"GetRejectProbability(\"003\", H4)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"003-TESTING\", A4,I4)","v":0},{"$f":"GetCARWeight(\"A\",J4)","v":1},{"$f":"GetCARCountAttr(\"B\",\"003-TESTING\",A4,K4)","v":0},{"$f":"GetCARWeight(\"B\",L4)","v":1},null,{"$f":"(K4+M4)/2","v":1},{"$f":"(E4*G4*I4)*O4","v":3},2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,{"$f":"MAX($Q4,$R4,$S4,$T4,$U4)","v":2.2000000000000002},1.8,1.4,1.8,1.4,1.4,{"$f":"MAX($W4,$X4,$Y4,$Z4,$AA4)","v":1.8},{"$f":"$V4*$AB4*$W$1","v":21.78},{"$f":"P4*AC4","v":65.34}]
["003-A1-PE-0023","Notification of Previously Released Test That was Cancelled, Corrected or Duplicate","Spec","S",1.5,22,1.9,0,"1",0,1,0,1,null,1,2.8499999999999996,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,62.072999999999993,"2015-12-02"]
["003-A2-PE-0024","Release Cancelled/Not Ready for Inspection","Spec","S",1.5,10,1.9,0,"1",0,1,0,1,null,1,2.8499999999999996,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,62.072999999999993,"2015-12-01"]
["003-A3-PE-0025","Notification of Late Release","Spec","S",1.5,8,2,0.125,"5",0,1,1,1.8,null,1.4,21,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,3,1.4,1.4,3,36.300000000000004,762.30000000000007,"2015-12-03"]
["003-A4-PE-0026","Ongoing Test","Spec","S",1.5,126,1.6,0,"1",0,1,0,1,null,1,2.4000000000000004,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,52.272000000000013,"2015-12-03"]
["003-A5-PE-0027","Test Correction","Spec","S",1.5,5,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-17"]
["003-A6-PE-0028","Test/Inspection Outside Normal Working Hours","Spec","S",1.5,5,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-12-04"]
["003-A7-PE-0029","Test/Inspection Not Witnessed Outside Normal Working Hours","Spec","S",1.5,7,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-13"]
["003-A8-PE-0030","Notification for Release or Previously Rejected Release","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34]
["003-A9-PE-0031","Not Witnessed with Remarks","Spec","S",1.5,14,1.9,0,"1",0,1,0,1,null,1,2.8499999999999996,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,62.072999999999993,"2015-11-30"]
["003-PE-0033","Procedure/ Instruction","Spec","S",1.5,71,1.7,0,"1",0,1,0,1,null,1,2.5499999999999998,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,55.539000000000001,"2015-12-04"]
["003-PE-0034","Prerequisites","Spec","S",1.5,75,1.7,0,"1",0,1,0,1,null,1,2.5499999999999998,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,55.539000000000001,"2015-12-03"]
["003-PE-0035","Calibration","Spec","S",1.5,39,1.8,0,"1",0,1,0,1,null,1,2.7,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,58.806000000000004,"2015-12-02"]
["003-PE-0036","Tolerance","Spec","S",1.5,1185,1.1000000000000001,8.438818565400844E-4,"2",1,1.5,0,1,null,1.25,4.125,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,89.842500000000001,"2015-12-04"]
["003-PE-0037","Inspection (Recorded)","Spec","S",1.5,64,1.7,0,"1",0,1,0,1,null,1,2.5499999999999998,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,55.539000000000001,"2015-12-04"]
["003-PE-0038","Safety","Spec","S",1.5,45,1.8,0,"1",0,1,0,1,null,1,2.7,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,58.806000000000004,"2015-12-04"]
["003-PE-0039","Q.A.","Spec","S",1.5,28,1.9,0,"1",0,1,0,1,null,1,2.8499999999999996,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,62.072999999999993,"2015-12-02"]
["003-PE-0040","Equipment (Test)","Spec","S",1.5,46,1.8,0,"1",0,1,0,1,null,1,2.7,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,58.806000000000004,"2015-12-02"]
["003-PE-0041","Missed I & I Items","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34]
["003-PE-0042","Compartment Tightness Testing","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34]
["003-PE-0043","Test Change Proposal: Primary Reviewer CDRL Test Review","Spec","S",1.5,1,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-10"]
["003-PE-0044","Test Change Proposal: Secondary Reviewer CDRL Test Review","Spec","S",1.5,1,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-13"]
["003-PE-0045","New Test Procedure: Primary Reviewer for CDRL Review","Spec","S",1.5,1,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-20"]
["003-PE-0046","New Test Procedure: Secondary Reviewer for CDRL Review","Spec","S",1.5,4,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-20"]
["003-PE-0047","Completed Test: Primary Reviewer for CDRL Review","Spec","S",1.5,2,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-12-01"]
["003-PE-0048","Completed Test: Secondary Reviewer for CDRL Review","Spec","S",1.5,1,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34,"2015-11-10"]
["003-Z-Z-0032","Quick OBS","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,2.2000000000000002,1.8,1.8,1.8,2.2000000000000002,2.2000000000000002,1.8,1.4,1.8,1.4,1.4,1.8,21.78,65.34]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prob of Quality Failure","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]",null,"Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]","Unlikely to occur [1.0]"]
[]
[]
[]
[]
[]
[]
[null,null,"Reject"]
["Total","003-TESTING",2,{"$f":"GetOversight(\"003-TESTING\",30)","v":"S"},{"$f":"IF($D40=\"M\",2,IF($D40=\"C\",1,IF($D40=\"P\",1.25,IF($D40=\"S\",1.5))))","v":1.5},1760,{"$f":"VLOOKUP($F40,OBSCheckListWeight,2,TRUE)","v":1.1000000000000001},{"$f":"IF(F40>0,C40/F40,0)","v":1.1363636363636363E-3},{"$f":"GetRejectProbability(\"003\", H40)","v":"2"},{"$f":"GetCARCountCL(\"A\",\"003-TESTING\",I40)","v":1},{"$f":"GetCARWeight(\"A\",J40)","v":1.5},{"$f":"GetCARCountCL(\"B\",\"003-TESTING\",K40)","v":1},{"$f":"GetCARWeight(\"B\",L40)","v":1.8},null,{"$f":"(K40+M40)/2","v":1.65},{"$f":"(E40*G40*I40)*O40","v":5.4450000000000003},{"$f":"MAX(Q4:Q30)","v":2.2000000000000002},{"$f":"MAX(R4:R30)","v":1.8},{"$f":"MAX(S4:S30)","v":1.8},{"$f":"MAX(T4:T30)","v":1.8},{"$f":"MAX(U4:U30)","v":2.2000000000000002},{"$f":"MAX($Q40,$R40,$S40,$T40,$U40)","v":2.2000000000000002},{"$f":"MAX(W4:W30)","v":1.8},{"$f":"MAX(X4:X30)","v":1.4},{"$f":"MAX(Y4:Y30)","v":3},{"$f":"MAX(Z4:Z30)","v":1.4},{"$f":"MAX(AA4:AA30)","v":1.4},{"$f":"MAX($W40,$X40,$Y40,$Z40,$AA40)","v":3},{"$f":"$V40*$AB40*$W$1","v":36.300000000000004},{"$f":"P40*AC40","v":197.65350000000004}]

{"sheet":"004-Hull Fairness","index":15,"n_rows":29,"n_cols":31,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,2,0,4],[1,16,1,20],[1,22,1,26]]}
["Checklist\nFormulas",null,"M - Mandatory / Statutory\nS - Specification driven\nP - Builder Process\nC - Crew/Customer request",null,null,null,null,null,null,null,null,null,"Reviewed:","2009-08-01",{"$f":"IF(NOW()-N1< 365,1,IF(NOW()-N1>545,2,1.5))","v":2},null,null,null,null,null,null,"Phase Factor",{"$f":"VLOOKUP(ShipPhase,ShipPhase!A2:B1000,2,FALSE)","v":5.5}]
[null,"Process Details","Governed by","Oversight Requirements","Necessity Modifier","Total OBS","OBS Weight","Procedure Evaluation Reject Rate","Reject Probability","Method A Count","Method A Weight","Method B Count","Method B Weight","N/A","CAR Average","Probability of Quality Failure","Failure Affects",null,null,null,null,"Impact Modifier","Severity of Failure",null,null,null,null,"Severity Modifier","Severity Factor","Max Risk","Date"]
[null,null,null,null,{"$f":"MAX(E4:E19)","v":1.5},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P4:P19)","v":10.499999999999998},"Personnel","Vessel","Milestone","Schedule","Cost",{"$f":"MAX(V4:V19)","v":3},"SOLAS","Mission Degrade","Significant Impact","Moderate Impact","Little Impact",{"$f":"MAX(AB4:AB19)","v":3},{"$f":"V3*AB3*$W$1","v":49.5},{"$f":"MAX(AD4:AD19)","v":519.74999999999989}]
["003-Z-Z-0032","Quick OBS","Spec","S",{"$f":"IF($D4=\"M\",2,IF($D4=\"C\",1,IF($D4=\"P\",1.25,IF($D4=\"S\",1.5))))","v":1.5},0,{"$f":"VLOOKUP($F4,OBSWeight,2,TRUE)","v":2},0,{"$f":"GetRejectProbability(\"004-Hull\", H4)","v":"1"},{"$f":"GetCARCountAttr(\"A\",\"004-Hull Fairness\", A4,I4)","v":0},{"$f":"GetCARWeight(\"A\",J4)","v":1},{"$f":"GetCARCountAttr(\"B\",\"004-Hull Fairness\",A4,K4)","v":0},{"$f":"GetCARWeight(\"B\",L4)","v":1},null,{"$f":"(K4+M4)/2","v":1},{"$f":"(E4*G4*I4)*O4","v":3},1.8,2.2000000000000002,3,1,2.2000000000000002,{"$f":"MAX($Q4,$R4,$S4,$T4,$U4)","v":3},2.6,1.4,2.6,2.6,3,{"$f":"MAX($W4,$X4,$Y4,$Z4,$AA4)","v":3},{"$f":"$V4*$AB4*$W$1","v":49.5},{"$f":"P4*AC4","v":148.5}]
["004-PVI-0049","Local Flatness Below 01 Level","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0050","Weld Fariness","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0051","Local Flatness Above 01 Level","Spec","S",1.5,200,1.4,{"$f":"87/200","v":0.435},"5",0,1,0,1,null,1,10.499999999999998,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,519.74999999999989]
["004-PVI-0052","Vertical Weld Fairness","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0053","Horizontal Weld Fariness","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0054","Verify Radii to Design","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0055","Radii Contour","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0056","Global Alignment of Facets and Primary Ship Edges","Spec","S",1.5,200,1.4,{"$f":"110/200","v":0.55000000000000004},"5",0,1,0,1,null,1,10.499999999999998,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,519.74999999999989]
["004-PVI-0057","Butted Shell Plate Offset","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0058","Butted Shell Plate Fairing","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0059","PCMS","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0060","Shaping","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0061","Edge Straightness 0.2 meter","Spec","S",1.5,400,1.3,{"$f":"320/400","v":0.8},"5",0,1,0,1,null,1,9.75,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,482.625]
["004-PVI-0062","Edge Straightness 1.0 meter","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
["004-PVI-0063","Edge Straightness 10 meter","Spec","S",1.5,0,2,0,"1",0,1,0,1,null,1,3,1.8,2.2000000000000002,3,1,2.2000000000000002,3,2.6,1.4,2.6,2.6,3,3,49.5,148.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prob of Quality Failure","Probably will occur in time [1.8]","Likely to occur within a short period of time [2.2]","Inevitable [3.0]","Unlikely to occur [1.0]","Likely to occur within a short period of time [2.2]",null,"Likely to occur immediately [2.6]","May occur in time [1.4]","Likely to occur immediately [2.6]","Likely to occur immediately [2.6]","Inevitable [3.0]"]
[]
[]
[]
[]
[]
[]
[null,null,"Reject"]
["Total","004-Hull Fairness",0,{"$f":"GetOversight(\"004-Hull Fairness\",19)","v":"S"},{"$f":"IF($D29=\"M\",2,IF($D29=\"C\",1,IF($D29=\"P\",1.25,IF($D29=\"S\",1.5))))","v":1.5},800,{"$f":"VLOOKUP($F29,OBSCheckListWeight,2,TRUE)","v":1.2},{"$f":"410/800","v":0.51249999999999996},{"$f":"GetRejectProbability(\"004-Hull\", H29)","v":"5"},{"$f":"GetCARCountCL(\"A\",\"004-Hull Fairness\",I29)","v":0},{"$f":"GetCARWeight(\"A\",J29)","v":1},{"$f":"GetCARCountCL(\"B\",\"004-Hull Fairness\",K29)","v":0},{"$f":"GetCARWeight(\"B\",L29)","v":1},null,{"$f":"(K29+M29)/2","v":1},{"$f":"(E29*G29*I29)*O29","v":9},{"$f":"MAX(Q4:Q19)","v":1.8},{"$f":"MAX(R4:R19)","v":2.2000000000000002},{"$f":"MAX(S4:S19)","v":3},{"$f":"MAX(T4:T19)","v":1},{"$f":"MAX(U4:U19)","v":2.2000000000000002},{"$f":"MAX($Q29,$R29,$S29,$T29,$U29)","v":3},{"$f":"MAX(W4:W19)","v":2.6},{"$f":"MAX(X4:X19)","v":1.4},{"$f":"MAX(Y4:Y19)","v":2.6},{"$f":"MAX(Z4:Z19)","v":2.6},{"$f":"MAX(AA4:AA19)","v":3},{"$f":"MAX($W29,$X29,$Y29,$Z29,$AA29)","v":3},{"$f":"$V29*$AB29*$W$1","v":49.5},{"$f":"P29*AC29","v":445.5}]