{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Form A"],"not_rendered":{"external_links":1,"defined_names":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Form A","index":0,"n_rows":70,"n_cols":8,"rows_kept":70,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,4],[3,3,3,4],[4,0,20,0],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,0,24,0],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,0,28,0],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,0,31,0],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,0,40,0],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,0,44,0],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,0,47,0],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,0,50,0],[49,3,49,4],[50,3,50,4],[51,0,56,0],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,0,57,4],[58,0,58,4],[63,0,63,4],[64,0,64,4],[65,0,65,4],[66,0,66,4],[67,0,67,4],[68,3,68,4],[69,3,69,4]],"flags":["formulas_cached_only"]}
["Lab: ",{"$nulls":3},"Software Verification & Validation"]
["Software Description: ",{"$nulls":3},"Date: "]
[]
["Codes","Assessment","Pass/Fail","Result/Observations (Attach Evidence or Describe)"]
["A. Software Inspection","Spreadsheet is clear and makes sense"]
[null,"There are instructions for use"]
[null,"Instructions and data input appear on the visible portion of the first worksheet",{"$nulls":5},"Pass"]
[null,"Data-entry fields are labeled and color coded (it is recommended to avoid red and green)",{"$nulls":5},"Fail"]
[null,"The type/name of procedure used is clearly specified",{"$nulls":5},"N/A"]
[null,"The number of digits to be rounded to is specified*"]
[null,"The user is warned/notified whenever data-entry fields are left blank*"]
[null,"Data-entry fields are “blank” when opened, preventing loss of old data and ensuring that old data is not used with the current calculations"]
[null,"The software opens at the right location within the file"]
[null,"Unused fields/cells are locked"]
[null,"Rows/columns that the operator need not see are hidden"]
[null,"Unused worksheets are removed"]
[null,"Worksheets are named appropriately"]
[null,"Pass/Fail criteria are specified in instructions*"]
[null,"Pass/Fail cells are automated (Not data-entry)"]
[null,"Calculation fields are properly labeled"]
[null,"Units are expressed properly and correctly*"]
["B. Mathematical Specification","The appropriate procedure is used*"]
[null,"The formulae and methods chosen from that procedure are specified*"]
[null,"Sources and references for formulae are specified"]
[null,"The chosen procedure, its methods, and its formulae, are appropriate to the level of precision/uncertainty*"]
["C. Code Review","The formulae in the fields exactly match the procedure*"]
[null,"Repeated calculations appropriately reference the correct cells*"]
[null,"Calculations, when tested using standard data or reference test data, show appropriate accuracy*"]
[null,"Rounding is done at the appropriate locations in the file*"]
["D. Numerical Stability","Calculations are stable as determined by an evaluation that uses large numbers and small differences.*"]
[null,"Fields, therefore their content, are categorized as “Number” and not “General” when appropriate, and vice versa"]
[null,"“Number” cells are locked to a limited number of decimal places; this limit is appropriate to the values being used"]
["E. Component Testing","Conditional logic cells handle negative values properly"]
[null,"Conditional logic cells withstand a Boundary Value test"]
[null,"Each macro used is functional*"]
[null,"Each command/button is functional*"]
[null,"Combinations of interdependent macros are functional"]
[null,"Plotted graphs are accurate*"]
[null,"Plotted graphs and its axes are properly labeled"]
[null,"Worksheets/reports print properly, if needed to"]
[null,"Conditional (color and non-color) formatting is functional"]
["F. Numerical Reference Results","Look-up tables and lists match the latest calibration report.*"]
[null,"Uncertainties match the latest Scope*"]
[null,"Values that reference another workbook or spreadsheet are dated"]
[null,"When a master list’s date is updated, the file references (A) an old value, (B) a default value, (C) displays zero or (D) an error message, as desired by the user"]
["G. Embedded Data Evaluation","Embedded data (conversion factors, reference values, etc) is correct*"]
[null,"The evaluation of the embedded data is dated and documented"]
[null,"The instructions worksheet includes a list of all additional files and plug-ins needed for it to run properly"]
["H. Back-to-Back Testing","Newer spreadsheets and older spreadsheets agree down to the level of intermediate calculations; this evaluation is dated and documented*"]
["I. Analysis With Out Computer Assistance","Hand calculations agree with those generated by the spreadsheet, or if they disagree, the differences are significantly smaller than the reported uncertainty*"]
[null,"Conclusions and results are apparent (if appropriate)*"]
["J. Security","Equation and calculation cells are protected against inadvertent editing"]
[null,"Cells are locked in place; they cannot be moved/dragged"]
[null,"Confidentiality of passwords is appropriate"]
[null,"Files are backed up automatically"]
[null,"Additional back-up is available at alternate facilities"]
[null,"Files on network drives cannot be accidentally deleted"]
[]
["*Failing these tests could drastically change results of spreadsheet"]
[]
[null,"Number of Passes",0,{"v":0,"d":"0.00%"}]
[null,"Number of Fails",0,{"v":0,"d":"0.00%"}]
[null,"Number of N/A's",0,{"v":0,"d":"0.00%"}]
[]
["Additional Notes:"]
[]
[]
[]
[]
[null,"   Signed",null,"   Title"]