{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Formula 1","Formula 2","Formula 3","Formula 4","Formula 5","Formula 6","Formula 7","VBA"],"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":"Formula 1","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"ROUND(B5,0)+CHOOSE(MOD(ROUND(B5,0),10)+1,-1,-2,3,2,1,0,-1,2,1,0)","v":15}]
[null,31,{"$f":"ROUND(B6,0)+CHOOSE(MOD(ROUND(B6,0),10)+1,-1,-2,3,2,1,0,-1,2,1,0)","v":29}]
[null,61,59]
[null,82,85]
[null,88,89]
[null,72,75]

{"sheet":"Formula 2","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"MROUND(B5,5)-((MOD(MROUND(B5,5),10))=0)","v":15}]
[null,31,{"$f":"MROUND(B6,5)-((MOD(MROUND(B6,5),10))=0)","v":29}]
[null,61,59]
[null,82,79]
[null,88,89]
[null,72,69]

{"sheet":"Formula 3","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"IF(B5>ROUND(B5,-1),IF(RIGHT(B5)=\"1\",ROUND(B5,-1)-1,ROUND(B5,-1)+5),IF(RIGHT(B5)=\"0\",ROUND(B5,-1)-1,IF(RIGHT(B5)<\"7\",ROUND(B5,-1)-5,ROUND(B5,-1)-1)))","v":15}]
[null,31,{"$f":"IF(B6>ROUND(B6,-1),IF(RIGHT(B6)=\"1\",ROUND(B6,-1)-1,ROUND(B6,-1)+5),IF(RIGHT(B6)=\"0\",ROUND(B6,-1)-1,IF(RIGHT(B6)<\"7\",ROUND(B6,-1)-5,ROUND(B6,-1)-1)))","v":29}]
[null,61,59]
[null,82,85]
[null,88,89]
[null,72,75]

{"sheet":"Formula 4","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"B5-MOD(B5,10)+4*(MOD(B5,10)>5)+5","v":15}]
[null,31,{"$f":"B6-MOD(B6,10)+4*(MOD(B6,10)>5)+5","v":35}]
[null,61,65]
[null,82,85]
[null,88,89]
[null,72,75]

{"sheet":"Formula 5","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"IF(OR(RIGHT(B5,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B5+1,5),0),MAX(CEILING(B5+1,10)-1,0))","v":15}]
[null,31,{"$f":"IF(OR(RIGHT(B6,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B6+1,5),0),MAX(CEILING(B6+1,10)-1,0))","v":35}]
[null,61,{"$f":"IF(OR(RIGHT(B7,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B7+1,5),0),MAX(CEILING(B7+1,10)-1,0))","v":65}]
[null,82,{"$f":"IF(OR(RIGHT(B8,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B8+1,5),0),MAX(CEILING(B8+1,10)-1,0))","v":85}]
[null,88,{"$f":"IF(OR(RIGHT(B9,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B9+1,5),0),MAX(CEILING(B9+1,10)-1,0))","v":89}]
[null,72,{"$f":"IF(OR(RIGHT(B10,1)={\"0\",\"1\",\"2\",\"3\",\"4\"}),MAX(CEILING(B10+1,5),0),MAX(CEILING(B10+1,10)-1,0))","v":75}]

{"sheet":"Formula 6","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"B5-RIGHT(B5,1)*1+IF(RIGHT(B5,1)*1<6,5,9)","v":15}]
[null,31,{"$f":"B6-RIGHT(B6,1)*1+IF(RIGHT(B6,1)*1<6,5,9)","v":35}]
[null,61,65]
[null,82,85]
[null,88,89]
[null,72,75]

{"sheet":"Formula 7","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"CEILING(B5+(MOD(B5,2)=0),5)-(MOD(CEILING(B5+(MOD(B5,2)=0),5),2)=0)","v":15}]
[null,31,{"$f":"CEILING(B6+(MOD(B6,2)=0),5)-(MOD(CEILING(B6+(MOD(B6,2)=0),5),2)=0)","v":35}]
[null,61,65]
[null,82,85]
[null,88,89]
[null,72,75]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Round to Nearest 5 or 9"]
[]
[null,"Numbers","Rounded"]
[null,13,{"$f":"Round59(B5)","v":15}]
[null,31,{"$f":"Round59(B6)","v":29}]
[null,61,{"$f":"Round59(B7)","v":59}]
[null,82,{"$f":"Round59(B8)","v":85}]
[null,88,{"$f":"Round59(B9)","v":89}]
[null,72,{"$f":"Round59(B10)","v":75}]