{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CALCULATOR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CALCULATOR","index":0,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[20,2,22,2],[20,3,22,3],[5,1,6,1],[7,1,9,1],[10,1,13,1]]}
[null,"Agricultural Health and Safety Mobile Application Evaluation Rubric Calculator"]
[null,"Check the boxes to rate each category from 1 (poor) to 4 (excellent). ",null,null,null,null,null,null,null,null,null,null,null,null,null,"For NFMC use only"]
[null,"Please check only one box per category. Scores are automatically calculated."]
[null,null,null,"Poor","Fair","Good","Excellent"]
[null,"CRITERIA","CATEGORY",1,2,3,4,null,null,null,null,null,null,null,null,1,2,3,4]
[null,"RELEVANCE","Content",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Advances Agricultural Health & Safety",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,"FUNCTION","Technical Performance",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Usability",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Information Delivery",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,"VALUE & PRIVACY","Value",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Advertisement",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Privacy Disclosure",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,"Confidentiality",null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[]
[null,null,"Raw Score",{"$f":"(COUNTIF(P6:P14,\"true\")*1)+(COUNTIF(Q6:Q14,\"true\")*2)+(COUNTIF(R6:R14,\"true\")*3)+(COUNTIF(S6:S14, \"true\")*4)","v":0}]
[null,null,"Ave Relevance Score",{"$f":"(SUM(COUNTIF(P6:P7,\"true\")*1)+(COUNTIF(Q6:Q7,\"true\")*2)+(COUNTIF(R6:R7,\"true\")*3)+(COUNTIF(S6:S7,\"true\")*4))/2","v":0}]
[null,null,"Ave Function Score",{"$f":"(SUM(COUNTIF(P8:P10,\"true\")*1)+(COUNTIF(Q8:Q10,\"true\")*2)+(COUNTIF(R8:R10,\"true\")*3)+(COUNTIF(S8:S10,\"true\")*4))/3","v":0}]
[null,null,"Ave Value & Privacy Score",{"$f":"(SUM(COUNTIF(P11:P14,\"true\")*1)+(COUNTIF(Q11:Q14,\"true\")*2)+(COUNTIF(R11:R14,\"true\")*3)+(COUNTIF(S11:S14,\"true\")*4))/4","v":0}]
[null,null,"OverallScore",{"$f":"(((SUM(COUNTIF(P6:P7,\"true\")*1)+(COUNTIF(Q6:Q7,\"true\")*2)+(COUNTIF(R6:R7,\"true\")*3)+(COUNTIF(S6:S7,\"true\")*4))/2)+((SUM(COUNTIF(P8:P10,\"true\")*1)+(COUNTIF(Q8:Q10,\"true\")*2)+(COUNTIF(R8:R10,\"true\")*3)+(COUNTIF(S8:S10,\"true\")*4))/3)+((SUM(COUNTIF(P11:P14,\"true\")*1)+(COUNTIF(Q11:Q14,\"true\")*2)+(COUNTIF(R11:R14,\"true\")*3)+(COUNTIF(S11:S14,\"true\")*4))/4))/3","v":0}]
[null,null,"Mobile App 5-star Scale Rating",{"$f":"D20*1.25","v":0}]