{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calculator","Get_HR","Time Accounting","GHR_RecidRates","GHR_NS_RecidRates"],"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":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,15,2,18],[14,11,17,13],[14,16,14,18],[19,4,23,5],[26,0,26,1],[26,7,26,8],[26,3,26,6],[2,0,2,2],[2,7,2,9],[21,15,21,17]]}
["Hide Past"]
[]
[null,null,null,null,null,"Date of Release from Index Offense",null,"Independently Modelled Risk",null,null,null,{"$f":"IF($E$11=\"Yes\",\"Event #\",\"\")","v":""},{"$f":"IF($E$11=\"Yes\",\"Date Removed from Community\",\"\")","v":""},{"$f":"IF($E$11=\"Yes\",\"Duration (Days)\",\"\")","v":""},null,"Use calculators below to get duration in days "]
[null,null,null,null,null,null,null,"Years in Community Offense Free","Year End Date","Residual Lifetime Risk",null,{"$f":"IF(AND($E$13>=1,F$13=\"How many times?\"),\"1\",\"\")","v":""},null,null,null,"Start Date",null,"End Date","Duration (Days)"]
["Recidivism Risk?",null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(E3),\"\",E3)","v":""},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE2,\nIF($S$22=19,GHR_RecidRates!AF2,\nIF($S$22=18,GHR_RecidRates!AG2,\nIF($S$22=17,GHR_RecidRates!AH2,\nIF($S$22=16,GHR_RecidRates!AI2,\nIF($S$22=15,GHR_RecidRates!AJ2,\nIF($S$22=14,GHR_RecidRates!AK2,\nIF($S$22=13,GHR_RecidRates!AL2,\nIF($S$22=12,GHR_RecidRates!AM2,\nIF($S$22=11,GHR_RecidRates!AN2,\nIF($S$22=10,GHR_RecidRates!AO2,\nIF($S$22=9,GHR_RecidRates!AP2,\nIF($S$22=8,GHR_RecidRates!AQ2,\nIF($S$22=7,GHR_RecidRates!AR2,\nIF($S$22=6,GHR_RecidRates!AS2,\nIF($S$22=5,GHR_RecidRates!AT2,\nIF($S$22=4,GHR_RecidRates!AU2,\nIF($S$22=3,GHR_RecidRates!AV2,\nIF($S$22=2,GHR_RecidRates!AW2,\nIF($S$22=1,GHR_RecidRates!AX2,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_RecidRates!AE2,\nIF($S$22=19,GHR_NS_RecidRates!AF2,\nIF($S$22=18,GHR_NS_RecidRates!AG2,\nIF($S$22=17,GHR_NS_RecidRates!AH2,\nIF($S$22=16,GHR_NS_RecidRates!AI2,\nIF($S$22=15,GHR_NS_RecidRates!AJ2,\nIF($S$22=14,GHR_NS_RecidRates!AK2,\nIF($S$22=13,GHR_NS_RecidRates!AL2,\nIF($S$22=12,GHR_NS_RecidRates!AM2,\nIF($S$22=11,GHR_NS_RecidRates!AN2,\nIF($S$22=10,GHR_NS_RecidRates!AO2,\nIF($S$22=9,GHR_NS_RecidRates!AP2,\nIF($S$22=8,GHR_NS_RecidRates!AQ2,\nIF($S$22=7,GHR_NS_RecidRates!AR2,\nIF($S$22=6,GHR_NS_RecidRates!AS2,\nIF($S$22=5,GHR_NS_RecidRates!AT2,\nIF($S$22=4,GHR_NS_RecidRates!AU2,\nIF($S$22=3,GHR_NS_RecidRates!AV2,\nIF($S$22=2,GHR_NS_RecidRates!AW2,\nIF($S$22=1,GHR_NS_RecidRates!AX2,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=2,F$13=\"How many times?\"),\"2\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(P5),ISBLANK(R5)),\"\",DATEDIF(P5,R5,\"D\"))","v":""}]
["At what year?",null,null,null,null,null,null,1,{"$f":"IF(ISBLANK('Time Accounting'!$J$22),\"\",'Time Accounting'!$J$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE3,\nIF($S$22=19,GHR_RecidRates!AF3,\nIF($S$22=18,GHR_RecidRates!AG3,\nIF($S$22=17,GHR_RecidRates!AH3,\nIF($S$22=16,GHR_RecidRates!AI3,\nIF($S$22=15,GHR_RecidRates!AJ3,\nIF($S$22=14,GHR_RecidRates!AK3,\nIF($S$22=13,GHR_RecidRates!AL3,\nIF($S$22=12,GHR_RecidRates!AM3,\nIF($S$22=11,GHR_RecidRates!AN3,\nIF($S$22=10,GHR_RecidRates!AO3,\nIF($S$22=9,GHR_RecidRates!AP3,\nIF($S$22=8,GHR_RecidRates!AQ3,\nIF($S$22=7,GHR_RecidRates!AR3,\nIF($S$22=6,GHR_RecidRates!AS3,\nIF($S$22=5,GHR_RecidRates!AT3,\nIF($S$22=4,GHR_RecidRates!AU3,\nIF($S$22=3,GHR_RecidRates!AV3,\nIF($S$22=2,GHR_RecidRates!AW3,\nIF($S$22=1,GHR_RecidRates!AX3,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE3,\nIF($S$22=19,GHR_NS_RecidRates!AF3,\nIF($S$22=18,GHR_NS_RecidRates!AG3,\nIF($S$22=17,GHR_NS_RecidRates!AH3,\nIF($S$22=16,GHR_NS_RecidRates!AI3,\nIF($S$22=15,GHR_NS_RecidRates!AJ3,\nIF($S$22=14,GHR_NS_RecidRates!AK3,\nIF($S$22=13,GHR_NS_RecidRates!AL3,\nIF($S$22=12,GHR_NS_RecidRates!AM3,\nIF($S$22=11,GHR_NS_RecidRates!AN3,\nIF($S$22=10,GHR_NS_RecidRates!AO3,\nIF($S$22=9,GHR_NS_RecidRates!AP3,\nIF($S$22=8,GHR_NS_RecidRates!AQ3,\nIF($S$22=7,GHR_NS_RecidRates!AR3,\nIF($S$22=6,GHR_NS_RecidRates!AS3,\nIF($S$22=5,GHR_NS_RecidRates!AT3,\nIF($S$22=4,GHR_NS_RecidRates!AU3,\nIF($S$22=3,GHR_NS_RecidRates!AV3,\nIF($S$22=2,GHR_NS_RecidRates!AW3,\nIF($S$22=1,GHR_NS_RecidRates!AX3,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=3,F$13=\"How many times?\"),\"3\",\"\")","v":""}]
[null,null,null,null,null,"Any nonsexual offense convictions after index offense while in the community?",null,2,{"$f":"IF(ISBLANK('Time Accounting'!L$22),\"\",'Time Accounting'!L$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE4,\nIF($S$22=19,GHR_RecidRates!AF4,\nIF($S$22=18,GHR_RecidRates!AG4,\nIF($S$22=17,GHR_RecidRates!AH4,\nIF($S$22=16,GHR_RecidRates!AI4,\nIF($S$22=15,GHR_RecidRates!AJ4,\nIF($S$22=14,GHR_RecidRates!AK4,\nIF($S$22=13,GHR_RecidRates!AL4,\nIF($S$22=12,GHR_RecidRates!AM4,\nIF($S$22=11,GHR_RecidRates!AN4,\nIF($S$22=10,GHR_RecidRates!AO4,\nIF($S$22=9,GHR_RecidRates!AP4,\nIF($S$22=8,GHR_RecidRates!AQ4,\nIF($S$22=7,GHR_RecidRates!AR4,\nIF($S$22=6,GHR_RecidRates!AS4,\nIF($S$22=5,GHR_RecidRates!AT4,\nIF($S$22=4,GHR_RecidRates!AU4,\nIF($S$22=3,GHR_RecidRates!AV4,\nIF($S$22=2,GHR_RecidRates!AW4,\nIF($S$22=1,GHR_RecidRates!AX4,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE4,\nIF($S$22=19,GHR_NS_RecidRates!AF4,\nIF($S$22=18,GHR_NS_RecidRates!AG4,\nIF($S$22=17,GHR_NS_RecidRates!AH4,\nIF($S$22=16,GHR_NS_RecidRates!AI4,\nIF($S$22=15,GHR_NS_RecidRates!AJ4,\nIF($S$22=14,GHR_NS_RecidRates!AK4,\nIF($S$22=13,GHR_NS_RecidRates!AL4,\nIF($S$22=12,GHR_NS_RecidRates!AM4,\nIF($S$22=11,GHR_NS_RecidRates!AN4,\nIF($S$22=10,GHR_NS_RecidRates!AO4,\nIF($S$22=9,GHR_NS_RecidRates!AP4,\nIF($S$22=8,GHR_NS_RecidRates!AQ4,\nIF($S$22=7,GHR_NS_RecidRates!AR4,\nIF($S$22=6,GHR_NS_RecidRates!AS4,\nIF($S$22=5,GHR_NS_RecidRates!AT4,\nIF($S$22=4,GHR_NS_RecidRates!AU4,\nIF($S$22=3,GHR_NS_RecidRates!AV4,\nIF($S$22=2,GHR_NS_RecidRates!AW4,\nIF($S$22=1,GHR_NS_RecidRates!AX4,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=4,F$13=\"How many times?\"),\"4\",\"\")","v":""},null,null,null,"Years","Months","Weeks","Duration (Days)"]
[null,null,null,null,null,null,null,3,{"$f":"IF(ISBLANK('Time Accounting'!$N$22),\"\",'Time Accounting'!$N$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE5,\nIF($S$22=19,GHR_RecidRates!AF5,\nIF($S$22=18,GHR_RecidRates!AG5,\nIF($S$22=17,GHR_RecidRates!AH5,\nIF($S$22=16,GHR_RecidRates!AI5,\nIF($S$22=15,GHR_RecidRates!AJ5,\nIF($S$22=14,GHR_RecidRates!AK5,\nIF($S$22=13,GHR_RecidRates!AL5,\nIF($S$22=12,GHR_RecidRates!AM5,\nIF($S$22=11,GHR_RecidRates!AN5,\nIF($S$22=10,GHR_RecidRates!AO5,\nIF($S$22=9,GHR_RecidRates!AP5,\nIF($S$22=8,GHR_RecidRates!AQ5,\nIF($S$22=7,GHR_RecidRates!AR5,\nIF($S$22=6,GHR_RecidRates!AS5,\nIF($S$22=5,GHR_RecidRates!AT5,\nIF($S$22=4,GHR_RecidRates!AU5,\nIF($S$22=3,GHR_RecidRates!AV5,\nIF($S$22=2,GHR_RecidRates!AW5,\nIF($S$22=1,GHR_RecidRates!AX5,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE5,\nIF($S$22=19,GHR_NS_RecidRates!AF5,\nIF($S$22=18,GHR_NS_RecidRates!AG5,\nIF($S$22=17,GHR_NS_RecidRates!AH5,\nIF($S$22=16,GHR_NS_RecidRates!AI5,\nIF($S$22=15,GHR_NS_RecidRates!AJ5,\nIF($S$22=14,GHR_NS_RecidRates!AK5,\nIF($S$22=13,GHR_NS_RecidRates!AL5,\nIF($S$22=12,GHR_NS_RecidRates!AM5,\nIF($S$22=11,GHR_NS_RecidRates!AN5,\nIF($S$22=10,GHR_NS_RecidRates!AO5,\nIF($S$22=9,GHR_NS_RecidRates!AP5,\nIF($S$22=8,GHR_NS_RecidRates!AQ5,\nIF($S$22=7,GHR_NS_RecidRates!AR5,\nIF($S$22=6,GHR_NS_RecidRates!AS5,\nIF($S$22=5,GHR_NS_RecidRates!AT5,\nIF($S$22=4,GHR_NS_RecidRates!AU5,\nIF($S$22=3,GHR_NS_RecidRates!AV5,\nIF($S$22=2,GHR_NS_RecidRates!AW5,\nIF($S$22=1,GHR_NS_RecidRates!AX5,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=5,F$13=\"How many times?\"),\"5\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(P8),ISBLANK(Q8),ISBLANK(R8)),\"\",TRUNC(P8*365.25+Q8*(365.25/12)+R8*(365.25/52)))","v":""}]
[null,null,null,null,null,{"$f":"IF(E7=\"Yes\",\"Date of first one\",\"\")","v":""},null,4,{"$f":"IF(ISBLANK('Time Accounting'!$P$22),\"\",'Time Accounting'!$P$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE6,\nIF($S$22=19,GHR_RecidRates!AF6,\nIF($S$22=18,GHR_RecidRates!AG6,\nIF($S$22=17,GHR_RecidRates!AH6,\nIF($S$22=16,GHR_RecidRates!AI6,\nIF($S$22=15,GHR_RecidRates!AJ6,\nIF($S$22=14,GHR_RecidRates!AK6,\nIF($S$22=13,GHR_RecidRates!AL6,\nIF($S$22=12,GHR_RecidRates!AM6,\nIF($S$22=11,GHR_RecidRates!AN6,\nIF($S$22=10,GHR_RecidRates!AO6,\nIF($S$22=9,GHR_RecidRates!AP6,\nIF($S$22=8,GHR_RecidRates!AQ6,\nIF($S$22=7,GHR_RecidRates!AR6,\nIF($S$22=6,GHR_RecidRates!AS6,\nIF($S$22=5,GHR_RecidRates!AT6,\nIF($S$22=4,GHR_RecidRates!AU6,\nIF($S$22=3,GHR_RecidRates!AV6,\nIF($S$22=2,GHR_RecidRates!AW6,\nIF($S$22=1,GHR_RecidRates!AX6,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE6,\nIF($S$22=19,GHR_NS_RecidRates!AF6,\nIF($S$22=18,GHR_NS_RecidRates!AG6,\nIF($S$22=17,GHR_NS_RecidRates!AH6,\nIF($S$22=16,GHR_NS_RecidRates!AI6,\nIF($S$22=15,GHR_NS_RecidRates!AJ6,\nIF($S$22=14,GHR_NS_RecidRates!AK6,\nIF($S$22=13,GHR_NS_RecidRates!AL6,\nIF($S$22=12,GHR_NS_RecidRates!AM6,\nIF($S$22=11,GHR_NS_RecidRates!AN6,\nIF($S$22=10,GHR_NS_RecidRates!AO6,\nIF($S$22=9,GHR_NS_RecidRates!AP6,\nIF($S$22=8,GHR_NS_RecidRates!AQ6,\nIF($S$22=7,GHR_NS_RecidRates!AR6,\nIF($S$22=6,GHR_NS_RecidRates!AS6,\nIF($S$22=5,GHR_NS_RecidRates!AT6,\nIF($S$22=4,GHR_NS_RecidRates!AU6,\nIF($S$22=3,GHR_NS_RecidRates!AV6,\nIF($S$22=2,GHR_NS_RecidRates!AW6,\nIF($S$22=1,GHR_NS_RecidRates!AX6,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=6,F$13=\"How many times?\"),\"6\",\"\")","v":""}]
[null,null,null,null,null,null,null,5,{"$f":"IF(ISBLANK('Time Accounting'!$R$22),\"\",'Time Accounting'!$R$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE7,\nIF($S$22=19,GHR_RecidRates!AF7,\nIF($S$22=18,GHR_RecidRates!AG7,\nIF($S$22=17,GHR_RecidRates!AH7,\nIF($S$22=16,GHR_RecidRates!AI7,\nIF($S$22=15,GHR_RecidRates!AJ7,\nIF($S$22=14,GHR_RecidRates!AK7,\nIF($S$22=13,GHR_RecidRates!AL7,\nIF($S$22=12,GHR_RecidRates!AM7,\nIF($S$22=11,GHR_RecidRates!AN7,\nIF($S$22=10,GHR_RecidRates!AO7,\nIF($S$22=9,GHR_RecidRates!AP7,\nIF($S$22=8,GHR_RecidRates!AQ7,\nIF($S$22=7,GHR_RecidRates!AR7,\nIF($S$22=6,GHR_RecidRates!AS7,\nIF($S$22=5,GHR_RecidRates!AT7,\nIF($S$22=4,GHR_RecidRates!AU7,\nIF($S$22=3,GHR_RecidRates!AV7,\nIF($S$22=2,GHR_RecidRates!AW7,\nIF($S$22=1,GHR_RecidRates!AX7,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE7,\nIF($S$22=19,GHR_NS_RecidRates!AF7,\nIF($S$22=18,GHR_NS_RecidRates!AG7,\nIF($S$22=17,GHR_NS_RecidRates!AH7,\nIF($S$22=16,GHR_NS_RecidRates!AI7,\nIF($S$22=15,GHR_NS_RecidRates!AJ7,\nIF($S$22=14,GHR_NS_RecidRates!AK7,\nIF($S$22=13,GHR_NS_RecidRates!AL7,\nIF($S$22=12,GHR_NS_RecidRates!AM7,\nIF($S$22=11,GHR_NS_RecidRates!AN7,\nIF($S$22=10,GHR_NS_RecidRates!AO7,\nIF($S$22=9,GHR_NS_RecidRates!AP7,\nIF($S$22=8,GHR_NS_RecidRates!AQ7,\nIF($S$22=7,GHR_NS_RecidRates!AR7,\nIF($S$22=6,GHR_NS_RecidRates!AS7,\nIF($S$22=5,GHR_NS_RecidRates!AT7,\nIF($S$22=4,GHR_NS_RecidRates!AU7,\nIF($S$22=3,GHR_NS_RecidRates!AV7,\nIF($S$22=2,GHR_NS_RecidRates!AW7,\nIF($S$22=1,GHR_NS_RecidRates!AX7,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=7,F$13=\"How many times?\"),\"7\",\"\")","v":""}]
[null,null,null,null,null,"Offender removed from community for any reason after release from Index Offense?",null,6,{"$f":"IF(ISBLANK('Time Accounting'!$T$22),\"\",'Time Accounting'!$T$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE8,\nIF($S$22=19,GHR_RecidRates!AF8,\nIF($S$22=18,GHR_RecidRates!AG8,\nIF($S$22=17,GHR_RecidRates!AH8,\nIF($S$22=16,GHR_RecidRates!AI8,\nIF($S$22=15,GHR_RecidRates!AJ8,\nIF($S$22=14,GHR_RecidRates!AK8,\nIF($S$22=13,GHR_RecidRates!AL8,\nIF($S$22=12,GHR_RecidRates!AM8,\nIF($S$22=11,GHR_RecidRates!AN8,\nIF($S$22=10,GHR_RecidRates!AO8,\nIF($S$22=9,GHR_RecidRates!AP8,\nIF($S$22=8,GHR_RecidRates!AQ8,\nIF($S$22=7,GHR_RecidRates!AR8,\nIF($S$22=6,GHR_RecidRates!AS8,\nIF($S$22=5,GHR_RecidRates!AT8,\nIF($S$22=4,GHR_RecidRates!AU8,\nIF($S$22=3,GHR_RecidRates!AV8,\nIF($S$22=2,GHR_RecidRates!AW8,\nIF($S$22=1,GHR_RecidRates!AX8,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE8,\nIF($S$22=19,GHR_NS_RecidRates!AF8,\nIF($S$22=18,GHR_NS_RecidRates!AG8,\nIF($S$22=17,GHR_NS_RecidRates!AH8,\nIF($S$22=16,GHR_NS_RecidRates!AI8,\nIF($S$22=15,GHR_NS_RecidRates!AJ8,\nIF($S$22=14,GHR_NS_RecidRates!AK8,\nIF($S$22=13,GHR_NS_RecidRates!AL8,\nIF($S$22=12,GHR_NS_RecidRates!AM8,\nIF($S$22=11,GHR_NS_RecidRates!AN8,\nIF($S$22=10,GHR_NS_RecidRates!AO8,\nIF($S$22=9,GHR_NS_RecidRates!AP8,\nIF($S$22=8,GHR_NS_RecidRates!AQ8,\nIF($S$22=7,GHR_NS_RecidRates!AR8,\nIF($S$22=6,GHR_NS_RecidRates!AS8,\nIF($S$22=5,GHR_NS_RecidRates!AT8,\nIF($S$22=4,GHR_NS_RecidRates!AU8,\nIF($S$22=3,GHR_NS_RecidRates!AV8,\nIF($S$22=2,GHR_NS_RecidRates!AW8,\nIF($S$22=1,GHR_NS_RecidRates!AX8,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=8,F$13=\"How many times?\"),\"8\",\"\")","v":""}]
[null,null,null,null,null,null,null,7,{"$f":"IF(ISBLANK('Time Accounting'!$V$22),\"\",'Time Accounting'!$V$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE9,\nIF($S$22=19,GHR_RecidRates!AF9,\nIF($S$22=18,GHR_RecidRates!AG9,\nIF($S$22=17,GHR_RecidRates!AH9,\nIF($S$22=16,GHR_RecidRates!AI9,\nIF($S$22=15,GHR_RecidRates!AJ9,\nIF($S$22=14,GHR_RecidRates!AK9,\nIF($S$22=13,GHR_RecidRates!AL9,\nIF($S$22=12,GHR_RecidRates!AM9,\nIF($S$22=11,GHR_RecidRates!AN9,\nIF($S$22=10,GHR_RecidRates!AO9,\nIF($S$22=9,GHR_RecidRates!AP9,\nIF($S$22=8,GHR_RecidRates!AQ9,\nIF($S$22=7,GHR_RecidRates!AR9,\nIF($S$22=6,GHR_RecidRates!AS9,\nIF($S$22=5,GHR_RecidRates!AT9,\nIF($S$22=4,GHR_RecidRates!AU9,\nIF($S$22=3,GHR_RecidRates!AV9,\nIF($S$22=2,GHR_RecidRates!AW9,\nIF($S$22=1,GHR_RecidRates!AX9,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE9,\nIF($S$22=19,GHR_NS_RecidRates!AF9,\nIF($S$22=18,GHR_NS_RecidRates!AG9,\nIF($S$22=17,GHR_NS_RecidRates!AH9,\nIF($S$22=16,GHR_NS_RecidRates!AI9,\nIF($S$22=15,GHR_NS_RecidRates!AJ9,\nIF($S$22=14,GHR_NS_RecidRates!AK9,\nIF($S$22=13,GHR_NS_RecidRates!AL9,\nIF($S$22=12,GHR_NS_RecidRates!AM9,\nIF($S$22=11,GHR_NS_RecidRates!AN9,\nIF($S$22=10,GHR_NS_RecidRates!AO9,\nIF($S$22=9,GHR_NS_RecidRates!AP9,\nIF($S$22=8,GHR_NS_RecidRates!AQ9,\nIF($S$22=7,GHR_NS_RecidRates!AR9,\nIF($S$22=6,GHR_NS_RecidRates!AS9,\nIF($S$22=5,GHR_NS_RecidRates!AT9,\nIF($S$22=4,GHR_NS_RecidRates!AU9,\nIF($S$22=3,GHR_NS_RecidRates!AV9,\nIF($S$22=2,GHR_NS_RecidRates!AW9,\nIF($S$22=1,GHR_NS_RecidRates!AX9,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=9,F$13=\"How many times?\"),\"9\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(E11=\"Yes\",\"How many times?\",\"\")","v":""},null,8,{"$f":"IF(ISBLANK('Time Accounting'!$X$22),\"\",'Time Accounting'!$X$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE10,\nIF($S$22=19,GHR_RecidRates!AF10,\nIF($S$22=18,GHR_RecidRates!AG10,\nIF($S$22=17,GHR_RecidRates!AH10,\nIF($S$22=16,GHR_RecidRates!AI10,\nIF($S$22=15,GHR_RecidRates!AJ10,\nIF($S$22=14,GHR_RecidRates!AK10,\nIF($S$22=13,GHR_RecidRates!AL10,\nIF($S$22=12,GHR_RecidRates!AM10,\nIF($S$22=11,GHR_RecidRates!AN10,\nIF($S$22=10,GHR_RecidRates!AO10,\nIF($S$22=9,GHR_RecidRates!AP10,\nIF($S$22=8,GHR_RecidRates!AQ10,\nIF($S$22=7,GHR_RecidRates!AR10,\nIF($S$22=6,GHR_RecidRates!AS10,\nIF($S$22=5,GHR_RecidRates!AT10,\nIF($S$22=4,GHR_RecidRates!AU10,\nIF($S$22=3,GHR_RecidRates!AV10,\nIF($S$22=2,GHR_RecidRates!AW10,\nIF($S$22=1,GHR_RecidRates!AX10,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE10,\nIF($S$22=19,GHR_NS_RecidRates!AF10,\nIF($S$22=18,GHR_NS_RecidRates!AG10,\nIF($S$22=17,GHR_NS_RecidRates!AH10,\nIF($S$22=16,GHR_NS_RecidRates!AI10,\nIF($S$22=15,GHR_NS_RecidRates!AJ10,\nIF($S$22=14,GHR_NS_RecidRates!AK10,\nIF($S$22=13,GHR_NS_RecidRates!AL10,\nIF($S$22=12,GHR_NS_RecidRates!AM10,\nIF($S$22=11,GHR_NS_RecidRates!AN10,\nIF($S$22=10,GHR_NS_RecidRates!AO10,\nIF($S$22=9,GHR_NS_RecidRates!AP10,\nIF($S$22=8,GHR_NS_RecidRates!AQ10,\nIF($S$22=7,GHR_NS_RecidRates!AR10,\nIF($S$22=6,GHR_NS_RecidRates!AS10,\nIF($S$22=5,GHR_NS_RecidRates!AT10,\nIF($S$22=4,GHR_NS_RecidRates!AU10,\nIF($S$22=3,GHR_NS_RecidRates!AV10,\nIF($S$22=2,GHR_NS_RecidRates!AW10,\nIF($S$22=1,GHR_NS_RecidRates!AX10,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(AND($E$13>=10,F$13=\"How many times?\"),\"10\",\"\")","v":""}]
[null,null,null,null,null,null,null,9,{"$f":"IF(ISBLANK('Time Accounting'!$Z$22),\"\",'Time Accounting'!$Z$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE11,\nIF($S$22=19,GHR_RecidRates!AF11,\nIF($S$22=18,GHR_RecidRates!AG11,\nIF($S$22=17,GHR_RecidRates!AH11,\nIF($S$22=16,GHR_RecidRates!AI11,\nIF($S$22=15,GHR_RecidRates!AJ11,\nIF($S$22=14,GHR_RecidRates!AK11,\nIF($S$22=13,GHR_RecidRates!AL11,\nIF($S$22=12,GHR_RecidRates!AM11,\nIF($S$22=11,GHR_RecidRates!AN11,\nIF($S$22=10,GHR_RecidRates!AO11,\nIF($S$22=9,GHR_RecidRates!AP11,\nIF($S$22=8,GHR_RecidRates!AQ11,\nIF($S$22=7,GHR_RecidRates!AR11,\nIF($S$22=6,GHR_RecidRates!AS11,\nIF($S$22=5,GHR_RecidRates!AT11,\nIF($S$22=4,GHR_RecidRates!AU11,\nIF($S$22=3,GHR_RecidRates!AV11,\nIF($S$22=2,GHR_RecidRates!AW11,\nIF($S$22=1,GHR_RecidRates!AX11,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE11,\nIF($S$22=19,GHR_NS_RecidRates!AF11,\nIF($S$22=18,GHR_NS_RecidRates!AG11,\nIF($S$22=17,GHR_NS_RecidRates!AH11,\nIF($S$22=16,GHR_NS_RecidRates!AI11,\nIF($S$22=15,GHR_NS_RecidRates!AJ11,\nIF($S$22=14,GHR_NS_RecidRates!AK11,\nIF($S$22=13,GHR_NS_RecidRates!AL11,\nIF($S$22=12,GHR_NS_RecidRates!AM11,\nIF($S$22=11,GHR_NS_RecidRates!AN11,\nIF($S$22=10,GHR_NS_RecidRates!AO11,\nIF($S$22=9,GHR_NS_RecidRates!AP11,\nIF($S$22=8,GHR_NS_RecidRates!AQ11,\nIF($S$22=7,GHR_NS_RecidRates!AR11,\nIF($S$22=6,GHR_NS_RecidRates!AS11,\nIF($S$22=5,GHR_NS_RecidRates!AT11,\nIF($S$22=4,GHR_NS_RecidRates!AU11,\nIF($S$22=3,GHR_NS_RecidRates!AV11,\nIF($S$22=2,GHR_NS_RecidRates!AW11,\nIF($S$22=1,GHR_NS_RecidRates!AX11,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,null,null,null,10,{"$f":"IF(ISBLANK('Time Accounting'!$AB$22),\"\",'Time Accounting'!$AB$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE12,\nIF($S$22=19,GHR_RecidRates!AF12,\nIF($S$22=18,GHR_RecidRates!AG12,\nIF($S$22=17,GHR_RecidRates!AH12,\nIF($S$22=16,GHR_RecidRates!AI12,\nIF($S$22=15,GHR_RecidRates!AJ12,\nIF($S$22=14,GHR_RecidRates!AK12,\nIF($S$22=13,GHR_RecidRates!AL12,\nIF($S$22=12,GHR_RecidRates!AM12,\nIF($S$22=11,GHR_RecidRates!AN12,\nIF($S$22=10,GHR_RecidRates!AO12,\nIF($S$22=9,GHR_RecidRates!AP12,\nIF($S$22=8,GHR_RecidRates!AQ12,\nIF($S$22=7,GHR_RecidRates!AR12,\nIF($S$22=6,GHR_RecidRates!AS12,\nIF($S$22=5,GHR_RecidRates!AT12,\nIF($S$22=4,GHR_RecidRates!AU12,\nIF($S$22=3,GHR_RecidRates!AV12,\nIF($S$22=2,GHR_RecidRates!AW12,\nIF($S$22=1,GHR_RecidRates!AX12,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE12,\nIF($S$22=19,GHR_NS_RecidRates!AF12,\nIF($S$22=18,GHR_NS_RecidRates!AG12,\nIF($S$22=17,GHR_NS_RecidRates!AH12,\nIF($S$22=16,GHR_NS_RecidRates!AI12,\nIF($S$22=15,GHR_NS_RecidRates!AJ12,\nIF($S$22=14,GHR_NS_RecidRates!AK12,\nIF($S$22=13,GHR_NS_RecidRates!AL12,\nIF($S$22=12,GHR_NS_RecidRates!AM12,\nIF($S$22=11,GHR_NS_RecidRates!AN12,\nIF($S$22=10,GHR_NS_RecidRates!AO12,\nIF($S$22=9,GHR_NS_RecidRates!AP12,\nIF($S$22=8,GHR_NS_RecidRates!AQ12,\nIF($S$22=7,GHR_NS_RecidRates!AR12,\nIF($S$22=6,GHR_NS_RecidRates!AS12,\nIF($S$22=5,GHR_NS_RecidRates!AT12,\nIF($S$22=4,GHR_NS_RecidRates!AU12,\nIF($S$22=3,GHR_NS_RecidRates!AV12,\nIF($S$22=2,GHR_NS_RecidRates!AW12,\nIF($S$22=1,GHR_NS_RecidRates!AX12,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,{"$f":"IF(E13>10,\"If the offender was removed from the community more than 10 times, aggregate all time removed from the communty after then 10th time in with the 10th event duration.\",\"\")","v":""},null,null,null,"LN Units Change","    Model"]
[null,null,null,null,null,null,null,11,{"$f":"IF(ISBLANK('Time Accounting'!$AD$22),\"\",'Time Accounting'!$AD$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE13,\nIF($S$22=19,GHR_RecidRates!AF13,\nIF($S$22=18,GHR_RecidRates!AG13,\nIF($S$22=17,GHR_RecidRates!AH13,\nIF($S$22=16,GHR_RecidRates!AI13,\nIF($S$22=15,GHR_RecidRates!AJ13,\nIF($S$22=14,GHR_RecidRates!AK13,\nIF($S$22=13,GHR_RecidRates!AL13,\nIF($S$22=12,GHR_RecidRates!AM13,\nIF($S$22=11,GHR_RecidRates!AN13,\nIF($S$22=10,GHR_RecidRates!AO13,\nIF($S$22=9,GHR_RecidRates!AP13,\nIF($S$22=8,GHR_RecidRates!AQ13,\nIF($S$22=7,GHR_RecidRates!AR13,\nIF($S$22=6,GHR_RecidRates!AS13,\nIF($S$22=5,GHR_RecidRates!AT13,\nIF($S$22=4,GHR_RecidRates!AU13,\nIF($S$22=3,GHR_RecidRates!AV13,\nIF($S$22=2,GHR_RecidRates!AW13,\nIF($S$22=1,GHR_RecidRates!AX13,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE13,\nIF($S$22=19,GHR_NS_RecidRates!AF13,\nIF($S$22=18,GHR_NS_RecidRates!AG13,\nIF($S$22=17,GHR_NS_RecidRates!AH13,\nIF($S$22=16,GHR_NS_RecidRates!AI13,\nIF($S$22=15,GHR_NS_RecidRates!AJ13,\nIF($S$22=14,GHR_NS_RecidRates!AK13,\nIF($S$22=13,GHR_NS_RecidRates!AL13,\nIF($S$22=12,GHR_NS_RecidRates!AM13,\nIF($S$22=11,GHR_NS_RecidRates!AN13,\nIF($S$22=10,GHR_NS_RecidRates!AO13,\nIF($S$22=9,GHR_NS_RecidRates!AP13,\nIF($S$22=8,GHR_NS_RecidRates!AQ13,\nIF($S$22=7,GHR_NS_RecidRates!AR13,\nIF($S$22=6,GHR_NS_RecidRates!AS13,\nIF($S$22=5,GHR_NS_RecidRates!AT13,\nIF($S$22=4,GHR_NS_RecidRates!AU13,\nIF($S$22=3,GHR_NS_RecidRates!AV13,\nIF($S$22=2,GHR_NS_RecidRates!AW13,\nIF($S$22=1,GHR_NS_RecidRates!AX13,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,null,null,null,null,-0.13,"   Year offense free with no nonsexual reoffense"]
[null,null,null,null,null,null,null,12,{"$f":"IF(ISBLANK('Time Accounting'!$AF$22),\"\",'Time Accounting'!$AF$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE14,\nIF($S$22=19,GHR_RecidRates!AF14,\nIF($S$22=18,GHR_RecidRates!AG14,\nIF($S$22=17,GHR_RecidRates!AH14,\nIF($S$22=16,GHR_RecidRates!AI14,\nIF($S$22=15,GHR_RecidRates!AJ14,\nIF($S$22=14,GHR_RecidRates!AK14,\nIF($S$22=13,GHR_RecidRates!AL14,\nIF($S$22=12,GHR_RecidRates!AM14,\nIF($S$22=11,GHR_RecidRates!AN14,\nIF($S$22=10,GHR_RecidRates!AO14,\nIF($S$22=9,GHR_RecidRates!AP14,\nIF($S$22=8,GHR_RecidRates!AQ14,\nIF($S$22=7,GHR_RecidRates!AR14,\nIF($S$22=6,GHR_RecidRates!AS14,\nIF($S$22=5,GHR_RecidRates!AT14,\nIF($S$22=4,GHR_RecidRates!AU14,\nIF($S$22=3,GHR_RecidRates!AV14,\nIF($S$22=2,GHR_RecidRates!AW14,\nIF($S$22=1,GHR_RecidRates!AX14,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE14,\nIF($S$22=19,GHR_NS_RecidRates!AF14,\nIF($S$22=18,GHR_NS_RecidRates!AG14,\nIF($S$22=17,GHR_NS_RecidRates!AH14,\nIF($S$22=16,GHR_NS_RecidRates!AI14,\nIF($S$22=15,GHR_NS_RecidRates!AJ14,\nIF($S$22=14,GHR_NS_RecidRates!AK14,\nIF($S$22=13,GHR_NS_RecidRates!AL14,\nIF($S$22=12,GHR_NS_RecidRates!AM14,\nIF($S$22=11,GHR_NS_RecidRates!AN14,\nIF($S$22=10,GHR_NS_RecidRates!AO14,\nIF($S$22=9,GHR_NS_RecidRates!AP14,\nIF($S$22=8,GHR_NS_RecidRates!AQ14,\nIF($S$22=7,GHR_NS_RecidRates!AR14,\nIF($S$22=6,GHR_NS_RecidRates!AS14,\nIF($S$22=5,GHR_NS_RecidRates!AT14,\nIF($S$22=4,GHR_NS_RecidRates!AU14,\nIF($S$22=3,GHR_NS_RecidRates!AV14,\nIF($S$22=2,GHR_NS_RecidRates!AW14,\nIF($S$22=1,GHR_NS_RecidRates!AX14,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,null,null,null,null,-0.13500000000000001,"   Year offense free with nonsexual reoffense"]
[null,null,null,null,null,null,null,13,{"$f":"IF(ISBLANK('Time Accounting'!$AH$22),\"\",'Time Accounting'!$AH$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE15,\nIF($S$22=19,GHR_RecidRates!AF15,\nIF($S$22=18,GHR_RecidRates!AG15,\nIF($S$22=17,GHR_RecidRates!AH15,\nIF($S$22=16,GHR_RecidRates!AI15,\nIF($S$22=15,GHR_RecidRates!AJ15,\nIF($S$22=14,GHR_RecidRates!AK15,\nIF($S$22=13,GHR_RecidRates!AL15,\nIF($S$22=12,GHR_RecidRates!AM15,\nIF($S$22=11,GHR_RecidRates!AN15,\nIF($S$22=10,GHR_RecidRates!AO15,\nIF($S$22=9,GHR_RecidRates!AP15,\nIF($S$22=8,GHR_RecidRates!AQ15,\nIF($S$22=7,GHR_RecidRates!AR15,\nIF($S$22=6,GHR_RecidRates!AS15,\nIF($S$22=5,GHR_RecidRates!AT15,\nIF($S$22=4,GHR_RecidRates!AU15,\nIF($S$22=3,GHR_RecidRates!AV15,\nIF($S$22=2,GHR_RecidRates!AW15,\nIF($S$22=1,GHR_RecidRates!AX15,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE15,\nIF($S$22=19,GHR_NS_RecidRates!AF15,\nIF($S$22=18,GHR_NS_RecidRates!AG15,\nIF($S$22=17,GHR_NS_RecidRates!AH15,\nIF($S$22=16,GHR_NS_RecidRates!AI15,\nIF($S$22=15,GHR_NS_RecidRates!AJ15,\nIF($S$22=14,GHR_NS_RecidRates!AK15,\nIF($S$22=13,GHR_NS_RecidRates!AL15,\nIF($S$22=12,GHR_NS_RecidRates!AM15,\nIF($S$22=11,GHR_NS_RecidRates!AN15,\nIF($S$22=10,GHR_NS_RecidRates!AO15,\nIF($S$22=9,GHR_NS_RecidRates!AP15,\nIF($S$22=8,GHR_NS_RecidRates!AQ15,\nIF($S$22=7,GHR_NS_RecidRates!AR15,\nIF($S$22=6,GHR_NS_RecidRates!AS15,\nIF($S$22=5,GHR_NS_RecidRates!AT15,\nIF($S$22=4,GHR_NS_RecidRates!AU15,\nIF($S$22=3,GHR_NS_RecidRates!AV15,\nIF($S$22=2,GHR_NS_RecidRates!AW15,\nIF($S$22=1,GHR_NS_RecidRates!AX15,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,null,null,null,null,0.44,"   Year of first nonsexual reoffense"]
[null,null,null,null,null,null,null,14,{"$f":"IF(ISBLANK('Time Accounting'!$AJ$22),\"\",'Time Accounting'!$AJ$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE16,\nIF($S$22=19,GHR_RecidRates!AF16,\nIF($S$22=18,GHR_RecidRates!AG16,\nIF($S$22=17,GHR_RecidRates!AH16,\nIF($S$22=16,GHR_RecidRates!AI16,\nIF($S$22=15,GHR_RecidRates!AJ16,\nIF($S$22=14,GHR_RecidRates!AK16,\nIF($S$22=13,GHR_RecidRates!AL16,\nIF($S$22=12,GHR_RecidRates!AM16,\nIF($S$22=11,GHR_RecidRates!AN16,\nIF($S$22=10,GHR_RecidRates!AO16,\nIF($S$22=9,GHR_RecidRates!AP16,\nIF($S$22=8,GHR_RecidRates!AQ16,\nIF($S$22=7,GHR_RecidRates!AR16,\nIF($S$22=6,GHR_RecidRates!AS16,\nIF($S$22=5,GHR_RecidRates!AT16,\nIF($S$22=4,GHR_RecidRates!AU16,\nIF($S$22=3,GHR_RecidRates!AV16,\nIF($S$22=2,GHR_RecidRates!AW16,\nIF($S$22=1,GHR_RecidRates!AX16,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE16,\nIF($S$22=19,GHR_NS_RecidRates!AF16,\nIF($S$22=18,GHR_NS_RecidRates!AG16,\nIF($S$22=17,GHR_NS_RecidRates!AH16,\nIF($S$22=16,GHR_NS_RecidRates!AI16,\nIF($S$22=15,GHR_NS_RecidRates!AJ16,\nIF($S$22=14,GHR_NS_RecidRates!AK16,\nIF($S$22=13,GHR_NS_RecidRates!AL16,\nIF($S$22=12,GHR_NS_RecidRates!AM16,\nIF($S$22=11,GHR_NS_RecidRates!AN16,\nIF($S$22=10,GHR_NS_RecidRates!AO16,\nIF($S$22=9,GHR_NS_RecidRates!AP16,\nIF($S$22=8,GHR_NS_RecidRates!AQ16,\nIF($S$22=7,GHR_NS_RecidRates!AR16,\nIF($S$22=6,GHR_NS_RecidRates!AS16,\nIF($S$22=5,GHR_NS_RecidRates!AT16,\nIF($S$22=4,GHR_NS_RecidRates!AU16,\nIF($S$22=3,GHR_NS_RecidRates!AV16,\nIF($S$22=2,GHR_NS_RecidRates!AW16,\nIF($S$22=1,GHR_NS_RecidRates!AX16,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,"     Instructions\nAlways start by resetting the workbook.\nOnly enter data in yellow highlighted cells.\n",null,null,15,{"$f":"IF(ISBLANK('Time Accounting'!$AL$22),\"\",'Time Accounting'!$AL$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE17,\nIF($S$22=19,GHR_RecidRates!AF17,\nIF($S$22=18,GHR_RecidRates!AG17,\nIF($S$22=17,GHR_RecidRates!AH17,\nIF($S$22=16,GHR_RecidRates!AI17,\nIF($S$22=15,GHR_RecidRates!AJ17,\nIF($S$22=14,GHR_RecidRates!AK17,\nIF($S$22=13,GHR_RecidRates!AL17,\nIF($S$22=12,GHR_RecidRates!AM17,\nIF($S$22=11,GHR_RecidRates!AN17,\nIF($S$22=10,GHR_RecidRates!AO17,\nIF($S$22=9,GHR_RecidRates!AP17,\nIF($S$22=8,GHR_RecidRates!AQ17,\nIF($S$22=7,GHR_RecidRates!AR17,\nIF($S$22=6,GHR_RecidRates!AS17,\nIF($S$22=5,GHR_RecidRates!AT17,\nIF($S$22=4,GHR_RecidRates!AU17,\nIF($S$22=3,GHR_RecidRates!AV17,\nIF($S$22=2,GHR_RecidRates!AW17,\nIF($S$22=1,GHR_RecidRates!AX17,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE17,\nIF($S$22=19,GHR_NS_RecidRates!AF17,\nIF($S$22=18,GHR_NS_RecidRates!AG17,\nIF($S$22=17,GHR_NS_RecidRates!AH17,\nIF($S$22=16,GHR_NS_RecidRates!AI17,\nIF($S$22=15,GHR_NS_RecidRates!AJ17,\nIF($S$22=14,GHR_NS_RecidRates!AK17,\nIF($S$22=13,GHR_NS_RecidRates!AL17,\nIF($S$22=12,GHR_NS_RecidRates!AM17,\nIF($S$22=11,GHR_NS_RecidRates!AN17,\nIF($S$22=10,GHR_NS_RecidRates!AO17,\nIF($S$22=9,GHR_NS_RecidRates!AP17,\nIF($S$22=8,GHR_NS_RecidRates!AQ17,\nIF($S$22=7,GHR_NS_RecidRates!AR17,\nIF($S$22=6,GHR_NS_RecidRates!AS17,\nIF($S$22=5,GHR_NS_RecidRates!AT17,\nIF($S$22=4,GHR_NS_RecidRates!AU17,\nIF($S$22=3,GHR_NS_RecidRates!AV17,\nIF($S$22=2,GHR_NS_RecidRates!AW17,\nIF($S$22=1,GHR_NS_RecidRates!AX17,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,null,null,null,16,{"$f":"IF(ISBLANK('Time Accounting'!$AN$22),\"\",'Time Accounting'!$AN$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE18,\nIF($S$22=19,GHR_RecidRates!AF18,\nIF($S$22=18,GHR_RecidRates!AG18,\nIF($S$22=17,GHR_RecidRates!AH18,\nIF($S$22=16,GHR_RecidRates!AI18,\nIF($S$22=15,GHR_RecidRates!AJ18,\nIF($S$22=14,GHR_RecidRates!AK18,\nIF($S$22=13,GHR_RecidRates!AL18,\nIF($S$22=12,GHR_RecidRates!AM18,\nIF($S$22=11,GHR_RecidRates!AN18,\nIF($S$22=10,GHR_RecidRates!AO18,\nIF($S$22=9,GHR_RecidRates!AP18,\nIF($S$22=8,GHR_RecidRates!AQ18,\nIF($S$22=7,GHR_RecidRates!AR18,\nIF($S$22=6,GHR_RecidRates!AS18,\nIF($S$22=5,GHR_RecidRates!AT18,\nIF($S$22=4,GHR_RecidRates!AU18,\nIF($S$22=3,GHR_RecidRates!AV18,\nIF($S$22=2,GHR_RecidRates!AW18,\nIF($S$22=1,GHR_RecidRates!AX18,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE18,\nIF($S$22=19,GHR_NS_RecidRates!AF18,\nIF($S$22=18,GHR_NS_RecidRates!AG18,\nIF($S$22=17,GHR_NS_RecidRates!AH18,\nIF($S$22=16,GHR_NS_RecidRates!AI18,\nIF($S$22=15,GHR_NS_RecidRates!AJ18,\nIF($S$22=14,GHR_NS_RecidRates!AK18,\nIF($S$22=13,GHR_NS_RecidRates!AL18,\nIF($S$22=12,GHR_NS_RecidRates!AM18,\nIF($S$22=11,GHR_NS_RecidRates!AN18,\nIF($S$22=10,GHR_NS_RecidRates!AO18,\nIF($S$22=9,GHR_NS_RecidRates!AP18,\nIF($S$22=8,GHR_NS_RecidRates!AQ18,\nIF($S$22=7,GHR_NS_RecidRates!AR18,\nIF($S$22=6,GHR_NS_RecidRates!AS18,\nIF($S$22=5,GHR_NS_RecidRates!AT18,\nIF($S$22=4,GHR_NS_RecidRates!AU18,\nIF($S$22=3,GHR_NS_RecidRates!AV18,\nIF($S$22=2,GHR_NS_RecidRates!AW18,\nIF($S$22=1,GHR_NS_RecidRates!AX18,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,null,null,null,17,{"$f":"IF(ISBLANK('Time Accounting'!$AP$22),\"\",'Time Accounting'!$AP$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE19,\nIF($S$22=19,GHR_RecidRates!AF19,\nIF($S$22=18,GHR_RecidRates!AG19,\nIF($S$22=17,GHR_RecidRates!AH19,\nIF($S$22=16,GHR_RecidRates!AI19,\nIF($S$22=15,GHR_RecidRates!AJ19,\nIF($S$22=14,GHR_RecidRates!AK19,\nIF($S$22=13,GHR_RecidRates!AL19,\nIF($S$22=12,GHR_RecidRates!AM19,\nIF($S$22=11,GHR_RecidRates!AN19,\nIF($S$22=10,GHR_RecidRates!AO19,\nIF($S$22=9,GHR_RecidRates!AP19,\nIF($S$22=8,GHR_RecidRates!AQ19,\nIF($S$22=7,GHR_RecidRates!AR19,\nIF($S$22=6,GHR_RecidRates!AS19,\nIF($S$22=5,GHR_RecidRates!AT19,\nIF($S$22=4,GHR_RecidRates!AU19,\nIF($S$22=3,GHR_RecidRates!AV19,\nIF($S$22=2,GHR_RecidRates!AW19,\nIF($S$22=1,GHR_RecidRates!AX19,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE19,\nIF($S$22=19,GHR_NS_RecidRates!AF19,\nIF($S$22=18,GHR_NS_RecidRates!AG19,\nIF($S$22=17,GHR_NS_RecidRates!AH19,\nIF($S$22=16,GHR_NS_RecidRates!AI19,\nIF($S$22=15,GHR_NS_RecidRates!AJ19,\nIF($S$22=14,GHR_NS_RecidRates!AK19,\nIF($S$22=13,GHR_NS_RecidRates!AL19,\nIF($S$22=12,GHR_NS_RecidRates!AM19,\nIF($S$22=11,GHR_NS_RecidRates!AN19,\nIF($S$22=10,GHR_NS_RecidRates!AO19,\nIF($S$22=9,GHR_NS_RecidRates!AP19,\nIF($S$22=8,GHR_NS_RecidRates!AQ19,\nIF($S$22=7,GHR_NS_RecidRates!AR19,\nIF($S$22=6,GHR_NS_RecidRates!AS19,\nIF($S$22=5,GHR_NS_RecidRates!AT19,\nIF($S$22=4,GHR_NS_RecidRates!AU19,\nIF($S$22=3,GHR_NS_RecidRates!AV19,\nIF($S$22=2,GHR_NS_RecidRates!AW19,\nIF($S$22=1,GHR_NS_RecidRates!AX19,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""},null,null,null,null,null,"Extrapolation of Lifetime Risk: Years",null,null,20]
[null,null,null,null,null,null,null,18,{"$f":"IF(ISBLANK('Time Accounting'!$AR$22),\"\",'Time Accounting'!$AR$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE20,\nIF($S$22=19,GHR_RecidRates!AF20,\nIF($S$22=18,GHR_RecidRates!AG20,\nIF($S$22=17,GHR_RecidRates!AH20,\nIF($S$22=16,GHR_RecidRates!AI20,\nIF($S$22=15,GHR_RecidRates!AJ20,\nIF($S$22=14,GHR_RecidRates!AK20,\nIF($S$22=13,GHR_RecidRates!AL20,\nIF($S$22=12,GHR_RecidRates!AM20,\nIF($S$22=11,GHR_RecidRates!AN20,\nIF($S$22=10,GHR_RecidRates!AO20,\nIF($S$22=9,GHR_RecidRates!AP20,\nIF($S$22=8,GHR_RecidRates!AQ20,\nIF($S$22=7,GHR_RecidRates!AR20,\nIF($S$22=6,GHR_RecidRates!AS20,\nIF($S$22=5,GHR_RecidRates!AT20,\nIF($S$22=4,GHR_RecidRates!AU20,\nIF($S$22=3,GHR_RecidRates!AV20,\nIF($S$22=2,GHR_RecidRates!AW20,\nIF($S$22=1,GHR_RecidRates!AX20,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE20,\nIF($S$22=19,GHR_NS_RecidRates!AF20,\nIF($S$22=18,GHR_NS_RecidRates!AG20,\nIF($S$22=17,GHR_NS_RecidRates!AH20,\nIF($S$22=16,GHR_NS_RecidRates!AI20,\nIF($S$22=15,GHR_NS_RecidRates!AJ20,\nIF($S$22=14,GHR_NS_RecidRates!AK20,\nIF($S$22=13,GHR_NS_RecidRates!AL20,\nIF($S$22=12,GHR_NS_RecidRates!AM20,\nIF($S$22=11,GHR_NS_RecidRates!AN20,\nIF($S$22=10,GHR_NS_RecidRates!AO20,\nIF($S$22=9,GHR_NS_RecidRates!AP20,\nIF($S$22=8,GHR_NS_RecidRates!AQ20,\nIF($S$22=7,GHR_NS_RecidRates!AR20,\nIF($S$22=6,GHR_NS_RecidRates!AS20,\nIF($S$22=5,GHR_NS_RecidRates!AT20,\nIF($S$22=4,GHR_NS_RecidRates!AU20,\nIF($S$22=3,GHR_NS_RecidRates!AV20,\nIF($S$22=2,GHR_NS_RecidRates!AW20,\nIF($S$22=1,GHR_NS_RecidRates!AX20,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,null,null,null,19,{"$f":"IF(ISBLANK('Time Accounting'!$AT$22),\"\",'Time Accounting'!$AT$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE21,\nIF($S$22=19,GHR_RecidRates!AF21,\nIF($S$22=18,GHR_RecidRates!AG21,\nIF($S$22=17,GHR_RecidRates!AH21,\nIF($S$22=16,GHR_RecidRates!AI21,\nIF($S$22=15,GHR_RecidRates!AJ21,\nIF($S$22=14,GHR_RecidRates!AK21,\nIF($S$22=13,GHR_RecidRates!AL21,\nIF($S$22=12,GHR_RecidRates!AM21,\nIF($S$22=11,GHR_RecidRates!AN21,\nIF($S$22=10,GHR_RecidRates!AO21,\nIF($S$22=9,GHR_RecidRates!AP21,\nIF($S$22=8,GHR_RecidRates!AQ21,\nIF($S$22=7,GHR_RecidRates!AR21,\nIF($S$22=6,GHR_RecidRates!AS21,\nIF($S$22=5,GHR_RecidRates!AT21,\nIF($S$22=4,GHR_RecidRates!AU21,\nIF($S$22=3,GHR_RecidRates!AV21,\nIF($S$22=2,GHR_RecidRates!AW21,\nIF($S$22=1,GHR_RecidRates!AX21,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE21,\nIF($S$22=19,GHR_NS_RecidRates!AF21,\nIF($S$22=18,GHR_NS_RecidRates!AG21,\nIF($S$22=17,GHR_NS_RecidRates!AH21,\nIF($S$22=16,GHR_NS_RecidRates!AI21,\nIF($S$22=15,GHR_NS_RecidRates!AJ21,\nIF($S$22=14,GHR_NS_RecidRates!AK21,\nIF($S$22=13,GHR_NS_RecidRates!AL21,\nIF($S$22=12,GHR_NS_RecidRates!AM21,\nIF($S$22=11,GHR_NS_RecidRates!AN21,\nIF($S$22=10,GHR_NS_RecidRates!AO21,\nIF($S$22=9,GHR_NS_RecidRates!AP21,\nIF($S$22=8,GHR_NS_RecidRates!AQ21,\nIF($S$22=7,GHR_NS_RecidRates!AR21,\nIF($S$22=6,GHR_NS_RecidRates!AS21,\nIF($S$22=5,GHR_NS_RecidRates!AT21,\nIF($S$22=4,GHR_NS_RecidRates!AU21,\nIF($S$22=3,GHR_NS_RecidRates!AV21,\nIF($S$22=2,GHR_NS_RecidRates!AW21,\nIF($S$22=1,GHR_NS_RecidRates!AX21,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[null,null,null,null,null,null,null,20,{"$f":"IF(ISBLANK('Time Accounting'!$AV$22),\"\",'Time Accounting'!$AV$22)","v":{"$error":"#VALUE!"}},{"$f":"IF($E$7=\"No\",\n(IF($S$22>=20,GHR_RecidRates!AE22,\nIF($S$22=19,GHR_RecidRates!AF22,\nIF($S$22=18,GHR_RecidRates!AG22,\nIF($S$22=17,GHR_RecidRates!AH22,\nIF($S$22=16,GHR_RecidRates!AI22,\nIF($S$22=15,GHR_RecidRates!AJ22,\nIF($S$22=14,GHR_RecidRates!AK22,\nIF($S$22=13,GHR_RecidRates!AL22,\nIF($S$22=12,GHR_RecidRates!AM22,\nIF($S$22=11,GHR_RecidRates!AN22,\nIF($S$22=10,GHR_RecidRates!AO22,\nIF($S$22=9,GHR_RecidRates!AP22,\nIF($S$22=8,GHR_RecidRates!AQ22,\nIF($S$22=7,GHR_RecidRates!AR22,\nIF($S$22=6,GHR_RecidRates!AS22,\nIF($S$22=5,GHR_RecidRates!AT22,\nIF($S$22=4,GHR_RecidRates!AU22,\nIF($S$22=3,GHR_RecidRates!AV22,\nIF($S$22=2,GHR_RecidRates!AW22,\nIF($S$22=1,GHR_RecidRates!AX22,\n\"\"))))))))))))))))))))),\n\nIF(AND($E$7=\"Yes\",$E$9>=$E$3),\n(IF($S$22>=20,GHR_NS_RecidRates!AE22,\nIF($S$22=19,GHR_NS_RecidRates!AF22,\nIF($S$22=18,GHR_NS_RecidRates!AG22,\nIF($S$22=17,GHR_NS_RecidRates!AH22,\nIF($S$22=16,GHR_NS_RecidRates!AI22,\nIF($S$22=15,GHR_NS_RecidRates!AJ22,\nIF($S$22=14,GHR_NS_RecidRates!AK22,\nIF($S$22=13,GHR_NS_RecidRates!AL22,\nIF($S$22=12,GHR_NS_RecidRates!AM22,\nIF($S$22=11,GHR_NS_RecidRates!AN22,\nIF($S$22=10,GHR_NS_RecidRates!AO22,\nIF($S$22=9,GHR_NS_RecidRates!AP22,\nIF($S$22=8,GHR_NS_RecidRates!AQ22,\nIF($S$22=7,GHR_NS_RecidRates!AR22,\nIF($S$22=6,GHR_NS_RecidRates!AS22,\nIF($S$22=5,GHR_NS_RecidRates!AT22,\nIF($S$22=4,GHR_NS_RecidRates!AU22,\nIF($S$22=3,GHR_NS_RecidRates!AV22,\nIF($S$22=2,GHR_NS_RecidRates!AW22,\nIF($S$22=1,GHR_NS_RecidRates!AX22,\n\"\"))))))))))))))))))))),\n\n\"\"))","v":""}]
[]
[null,null,null,"Today",null,null,null,{"$f":"TODAY()","v":"2024-05-28"},null,{"$f":"IF($H$27>=I25,\n\"0\",\n\nIF(AND($H$27<I25,$H$27>=I24),\nJ24-((J24-J25)*((365.25-(I25-$H$27))/365.25)),\n\nIF(AND($H$27<I24,$H$27>=I23),\nJ23-((J23-J24)*((365.25-(I25-$H$27))/365.25)),\n\nIF(AND($H$27<I23,$H$27>=I22),\nJ22-((J22-J23)*((365.25-(I23-$H$27))/365.25)),\n\nIF(AND($H$27<I22,$H$27>=I21),\nJ21-((J21-J22)*((365.25-(I22-$H$27))/365.25)),\n\nIF(AND($H$27<I21,$H$27>=I20),\nJ20-((J20-J21)*((365.25-(I21-$H$27))/365.25)),\n\nIF(AND($H$27<I20,$H$27>=I19),\nJ19-((J19-J20)*((365.25-(I20-$H$27))/365.25)),\n\nIF(AND($H$27<I19,$H$27>=I18),\nJ18-((J18-J19)*((365.25-(I19-$H$27))/365.25)),\n\nIF(AND($H$27<I18,$H$27>=I17),\nJ17-((J17-J18)*((365.25-(I18-$H$27))/365.25)),\n\nIF(AND($H$27<I17,$H$27>=I16),\nJ16-((J16-J17)*((365.25-(I17-$H$27))/365.25)),\n\nIF(AND($H$27<I16,$H$27>=I15),\nJ15-((J15-J16)*((365.25-(I16-$H$27))/365.25)),\n\nIF(AND($H$27<I15,$H$27>=I14),\nJ14-((J14-J15)*((365.25-(I15-$H$27))/365.25)),\n\nIF(AND($H$27<I14,$H$27>=I13),\nJ13-((J13-J14)*((365.25-(I14-$H$27))/365.25)),\n\nIF(AND($H$27<I13,$H$27>=I12),\nJ12-((J12-J13)*((365.25-(I13-$H$27))/365.25)),\n\nIF(AND($H$27<I12,$H$27>=I11),\nJ11-((J11-J12)*((365.25-(I12-$H$27))/365.25)),\n\nIF(AND($H$27<I11,$H$27>=I10),\nJ10-((J10-J11)*((365.25-(I11-$H$27))/365.25)),\n\nIF(AND($H$27<I10,$H$27>=I9),\nJ9-((J9-J10)*((365.25-(I10-$H$27))/365.25)),\n\nIF(AND($H$27<I9,$H$27>=I8),\nJ8-((J8-J9)*((365.25-(I9-$H$27))/365.25)),\n\nIF(AND($H$27<I8,$H$27>=I7),\nJ7-((J7-J8)*((365.25-(I8-$H$27))/365.25)),\n\nIF(AND($H$27<I7,$H$27>=I6),\nJ6-((J6-J7)*((365.25-(I7-$H$27))/365.25)),\n\nIF(AND($H$27<I6,$H$27>=I5),\nIF($E$7=\"No\",\nJ5-((J5-J6)*((365.25-(I6-$H$27))/365.25)),\nGHR_NS_RecidRates!AE2-((GHR_NS_RecidRates!AE2-J6)*((365.25-(I6-$H$27))/365.25))\n\n),J5)))))))))))))))))))))","v":{"$error":"#VALUE!"}}]

{"sheet":"Get_HR","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Recidivism risk to model:",{"$f":"Calculator!B5","v":0}]
[null,"Follow-up year:",{"$f":"Calculator!B6","v":0}]
[]
[]
[null,"Hazard ratio:",{"$f":"IF(ISNUMBER(E8),E8,E6)","v":0.11747334692592511},null,0.01]
[]
[null,"Error (Desired - Model Prediction):",{"$f":"MAX(GHR_RecidRates!I2:I21)","v":0},"%",{"$f":"\nIF(ABS(C8)<0.0001,C6,\nIF(C8<=0.0001,C6*0.999,\nIF(C8>=-0.0001,C6*1.001,\n\"\")))","v":0.11747334692592511}]

{"sheet":"Time Accounting","index":2,"n_rows":22,"n_cols":49,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Enter Community","Leave Community","Days in Community","Cummulative Days in Community","Years accounted for","Cummulative Days Accounted for ","Remaining Days to account for",null,null,"EndYear01","Days  Remaining","EndYear02","Days  Remaining","EndYear03","Days  Remaining","EndYear04","Days  Remaining","EndYear05","Days  Remaining","EndYear06","Days  Remaining","EndYear07","Days  Remaining","EndYear08","Days  Remaining","EndYear09","Days  Remaining","EndYear10","Days  Remaining","EndYear11","Days  Remaining","EndYear12","Days  Remaining","EndYear13","Days  Remaining","EndYear14","Days  Remaining","EndYear15","Days  Remaining","EndYear16","Days  Remaining","EndYear17","Days  Remaining","EndYear18","Days  Remaining","EndYear19","Days  Remaining","EndYear20"]
[{"$f":"Calculator!E3","v":"00:00:00"},{"$f":"IF(A2>=TODAY(),A2+365.25*21,\nIF(Calculator!E11=\"No\",TODAY(),\nIF(Calculator!E13>=1,Calculator!M4,\"\")))","v":""},{"$f":"DATEDIF(A2,B2,\"D\")","v":{"$error":"#VALUE!"}},{"$f":"C2","v":{"$error":"#VALUE!"}},{"$f":"IF(A2=\"\",\"\",QUOTIENT(D2,365.25))","v":{"$error":"#VALUE!"}},{"$f":"IF(A2=\"\",\"\",\n365.25*E2)","v":{"$error":"#VALUE!"}},{"$f":"IF(A2=\"\",\"\",D2-F2)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(D2<$A$18,\"\",A2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(D2<$A$18,\"\",D2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(K2<$A$18,K2=\"\"),\"\",J2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(K2<$A$18,K2=\"\"),\"\",K2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(M2<$A$18,M2=\"\"),\"\",L2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(M2<$A$18,M2=\"\"),\"\",M2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(O2<$A$18,O2=\"\"),\"\",N2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(O2<$A$18,O2=\"\"),\"\",O2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(Q2<$A$18,Q2=\"\"),\"\",P2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(Q2<$A$18,Q2=\"\"),\"\",Q2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(S2<$A$18,S2=\"\"),\"\",R2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(S2<$A$18,S2=\"\"),\"\",S2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(U2<$A$18,U2=\"\"),\"\",T2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(U2<$A$18,U2=\"\"),\"\",U2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(W2<$A$18,W2=\"\"),\"\",V2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(W2<$A$18,W2=\"\"),\"\",W2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(Y2<$A$18,Y2=\"\"),\"\",X2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(Y2<$A$18,Y2=\"\"),\"\",Y2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AA2<$A$18,AA2=\"\"),\"\",Z2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AA2<$A$18,AA2=\"\"),\"\",AA2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AC2<$A$18,AC2=\"\"),\"\",AB2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AC2<$A$18,AC2=\"\"),\"\",AC2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AE2<$A$18,AE2=\"\"),\"\",AD2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AE2<$A$18,AE2=\"\"),\"\",AE2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AG2<$A$18,AG2=\"\"),\"\",AF2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AG2<$A$18,AG2=\"\"),\"\",AG2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AI2<$A$18,AI2=\"\"),\"\",AH2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AI2<$A$18,AI2=\"\"),\"\",AI2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AK2<$A$18,AK2=\"\"),\"\",AJ2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AK2<$A$18,AK2=\"\"),\"\",AK2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AM2<$A$18,AM2=\"\"),\"\",AL2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AM2<$A$18,AM2=\"\"),\"\",AM2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AO2<$A$18,AO2=\"\"),\"\",AN2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AO2<$A$18,AO2=\"\"),\"\",AO2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AQ2<$A$18,AQ2=\"\"),\"\",AP2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AQ2<$A$18,AQ2=\"\"),\"\",AQ2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AS2<$A$18,AS2=\"\"),\"\",AR2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AS2<$A$18,AS2=\"\"),\"\",AS2-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AU2<$A$18,AU2=\"\"),\"\",AT2+$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AU2<$A$18,AU2=\"\"),\"\",AU2-$A$18)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(Calculator!$E$13>=1,B2+Calculator!N4,\"\")","v":""},{"$f":"IF(B2>=TODAY(),\"\",IF(Calculator!$E$13>=2,Calculator!M5,IF(A3>TODAY(),A3+365.25*21,TODAY())))","v":""},{"$f":"IF(A3=\"\",\"\",DATEDIF(A3,B3,\"D\"))","v":""},{"$f":"IF(A3=\"\",\"\",SUM(C$2:C3))","v":""},{"$f":"IF(A3=\"\",E2,QUOTIENT(D3,365.25))","v":{"$error":"#VALUE!"}},{"$f":"IF(A3=\"\",\"\",\n365.25*E3)","v":""},{"$f":"IF(A3=\"\",\"\",D3-F3)","v":""},null,null,{"$f":"IF(OR(MAX(K$2:K2)>0,$E3<1),\"\",\nIF(D3>=$A$18,A3+$A$18-G2,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K2)>0,AND(K2>0,D3<$A$18)),\"\",D3-$A$18)","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<L$13,\"\",\nIF(MAX(M$2:M2)>0,\"\",\nIF(AND($D3>=(L$13*$A$18),K3=\"\"),$A3+$A$18-$G2,J3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(L3=\"\",\"\",\nIF($D3>=L$13*$A$18,$D3-L$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<N$13,\"\",\nIF(MAX(O$2:O2)>0,\"\",\nIF(AND($D3>=(N$13*$A$18),M3=\"\"),$A3+$A$18-$G2,L3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(N3=\"\",\"\",\nIF($D3>=N$13*$A$18,$D3-N$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<P$13,\"\",\nIF(MAX(Q$2:Q2)>0,\"\",\nIF(AND($D3>=(P$13*$A$18),O3=\"\"),$A3+$A$18-$G2,N3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(P3=\"\",\"\",\nIF($D3>=P$13*$A$18,$D3-P$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<R$13,\"\",\nIF(MAX(S$2:S2)>0,\"\",\nIF(AND($D3>=(R$13*$A$18),Q3=\"\"),$A3+$A$18-$G2,P3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(R3=\"\",\"\",\nIF($D3>=R$13*$A$18,$D3-R$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<T$13,\"\",\nIF(MAX(U$2:U2)>0,\"\",\nIF(AND($D3>=(T$13*$A$18),S3=\"\"),$A3+$A$18-$G2,R3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(T3=\"\",\"\",\nIF($D3>=T$13*$A$18,$D3-T$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<V$13,\"\",\nIF(MAX(W$2:W2)>0,\"\",\nIF(AND($D3>=(V$13*$A$18),U3=\"\"),$A3+$A$18-$G2,T3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(V3=\"\",\"\",\nIF($D3>=V$13*$A$18,$D3-V$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<X$13,\"\",\nIF(MAX(Y$2:Y2)>0,\"\",\nIF(AND($D3>=(X$13*$A$18),W3=\"\"),$A3+$A$18-$G2,V3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(X3=\"\",\"\",\nIF($D3>=X$13*$A$18,$D3-X$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<Z$13,\"\",\nIF(MAX(AA$2:AA2)>0,\"\",\nIF(AND($D3>=(Z$13*$A$18),Y3=\"\"),$A3+$A$18-$G2,X3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Z3=\"\",\"\",\nIF($D3>=Z$13*$A$18,$D3-Z$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AB$13,\"\",\nIF(MAX(AC$2:AC2)>0,\"\",\nIF(AND($D3>=(AB$13*$A$18),AA3=\"\"),$A3+$A$18-$G2,Z3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AB3=\"\",\"\",\nIF($D3>=AB$13*$A$18,$D3-AB$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AD$13,\"\",\nIF(MAX(AE$2:AE2)>0,\"\",\nIF(AND($D3>=(AD$13*$A$18),AC3=\"\"),$A3+$A$18-$G2,AB3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AD3=\"\",\"\",\nIF($D3>=AD$13*$A$18,$D3-AD$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AF$13,\"\",\nIF(MAX(AG$2:AG2)>0,\"\",\nIF(AND($D3>=(AF$13*$A$18),AE3=\"\"),$A3+$A$18-$G2,AD3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF3=\"\",\"\",\nIF($D3>=AF$13*$A$18,$D3-AF$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AH$13,\"\",\nIF(MAX(AI$2:AI2)>0,\"\",\nIF(AND($D3>=(AH$13*$A$18),AG3=\"\"),$A3+$A$18-$G2,AF3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH3=\"\",\"\",\nIF($D3>=AH$13*$A$18,$D3-AH$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AJ$13,\"\",\nIF(MAX(AK$2:AK2)>0,\"\",\nIF(AND($D3>=(AJ$13*$A$18),AI3=\"\"),$A3+$A$18-$G2,AH3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ3=\"\",\"\",\nIF($D3>=AJ$13*$A$18,$D3-AJ$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AL$13,\"\",\nIF(MAX(AM$2:AM2)>0,\"\",\nIF(AND($D3>=(AL$13*$A$18),AK3=\"\"),$A3+$A$18-$G2,AJ3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AL3=\"\",\"\",\nIF($D3>=AL$13*$A$18,$D3-AL$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AN$13,\"\",\nIF(MAX(AO$2:AO2)>0,\"\",\nIF(AND($D3>=(AN$13*$A$18),AM3=\"\"),$A3+$A$18-$G2,AL3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AN3=\"\",\"\",\nIF($D3>=AN$13*$A$18,$D3-AN$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AP$13,\"\",\nIF(MAX(AQ$2:AQ2)>0,\"\",\nIF(AND($D3>=(AP$13*$A$18),AO3=\"\"),$A3+$A$18-$G2,AN3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AP3=\"\",\"\",\nIF($D3>=AP$13*$A$18,$D3-AP$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AR$13,\"\",\nIF(MAX(AS$2:AS2)>0,\"\",\nIF(AND($D3>=(AR$13*$A$18),AQ3=\"\"),$A3+$A$18-$G2,AP3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AR3=\"\",\"\",\nIF($D3>=AR$13*$A$18,$D3-AR$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AT$13,\"\",\nIF(MAX(AU$2:AU2)>0,\"\",\nIF(AND($D3>=(AT$13*$A$18),AS3=\"\"),$A3+$A$18-$G2,AR3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AT3=\"\",\"\",\nIF($D3>=AT$13*$A$18,$D3-AT$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E3<AV$13,\"\",\nIF(MAX(AW$2:AW2)>0,\"\",\nIF(AND($D3>=(AV$13*$A$18),AU3=\"\"),$A3+$A$18-$G2,AT3+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AV3=\"\",\"\",\nIF($D3>=AV$13*$A$18,$D3-AV$13*$A$18,\"\"))","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(Calculator!$E$13>=2,B3+Calculator!N5,\"\")","v":""},{"$f":"IF(B3>=TODAY(),\"\",IF(Calculator!$E$13>=3,Calculator!M6,IF(A4>TODAY(),A4+365.25*21,TODAY())))","v":""},{"$f":"IF(A4=\"\",\"\",DATEDIF(A4,B4,\"D\"))","v":""},{"$f":"IF(A4=\"\",\"\",SUM(C$2:C4))","v":""},{"$f":"IF(A4=\"\",E3,QUOTIENT(D4,365.25))","v":{"$error":"#VALUE!"}},"","",null,null,{"$f":"IF(OR(MAX(K$2:K3)>0,E4<1),\"\",\nIF(D4>=$A$18,A4+$A$18-G3,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K3)>0,AND(K3>0,D4<$A$18)),\"\",IF(AND(K3>0,D4=\"\"),G$13,D4-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E4<L$13,\"\",\nIF(MAX(M$2:M3)>0,\"\",\nIF(AND($D4>=(L$13*$A$18),K4=\"\"),$A4+$A$18-$G3,J4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<N$13,\"\",\nIF(MAX(O$2:O3)>0,\"\",\nIF(AND($D4>=(N$13*$A$18),M4=\"\"),$A4+$A$18-$G3,L4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<P$13,\"\",\nIF(MAX(Q$2:Q3)>0,\"\",\nIF(AND($D4>=(P$13*$A$18),O4=\"\"),$A4+$A$18-$G3,N4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<R$13,\"\",\nIF(MAX(S$2:S3)>0,\"\",\nIF(AND($D4>=(R$13*$A$18),Q4=\"\"),$A4+$A$18-$G3,P4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<T$13,\"\",\nIF(MAX(U$2:U3)>0,\"\",\nIF(AND($D4>=(T$13*$A$18),S4=\"\"),$A4+$A$18-$G3,R4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<V$13,\"\",\nIF(MAX(W$2:W3)>0,\"\",\nIF(AND($D4>=(V$13*$A$18),U4=\"\"),$A4+$A$18-$G3,T4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<X$13,\"\",\nIF(MAX(Y$2:Y3)>0,\"\",\nIF(AND($D4>=(X$13*$A$18),W4=\"\"),$A4+$A$18-$G3,V4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<Z$13,\"\",\nIF(MAX(AA$2:AA3)>0,\"\",\nIF(AND($D4>=(Z$13*$A$18),Y4=\"\"),$A4+$A$18-$G3,X4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AB$13,\"\",\nIF(MAX(AC$2:AC3)>0,\"\",\nIF(AND($D4>=(AB$13*$A$18),AA4=\"\"),$A4+$A$18-$G3,Z4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AD$13,\"\",\nIF(MAX(AE$2:AE3)>0,\"\",\nIF(AND($D4>=(AD$13*$A$18),AC4=\"\"),$A4+$A$18-$G3,AB4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AF$13,\"\",\nIF(MAX(AG$2:AG3)>0,\"\",\nIF(AND($D4>=(AF$13*$A$18),AE4=\"\"),$A4+$A$18-$G3,AD4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AH$13,\"\",\nIF(MAX(AI$2:AI3)>0,\"\",\nIF(AND($D4>=(AH$13*$A$18),AG4=\"\"),$A4+$A$18-$G3,AF4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AJ$13,\"\",\nIF(MAX(AK$2:AK3)>0,\"\",\nIF(AND($D4>=(AJ$13*$A$18),AI4=\"\"),$A4+$A$18-$G3,AH4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AL$13,\"\",\nIF(MAX(AM$2:AM3)>0,\"\",\nIF(AND($D4>=(AL$13*$A$18),AK4=\"\"),$A4+$A$18-$G3,AJ4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AN$13,\"\",\nIF(MAX(AO$2:AO3)>0,\"\",\nIF(AND($D4>=(AN$13*$A$18),AM4=\"\"),$A4+$A$18-$G3,AL4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AP$13,\"\",\nIF(MAX(AQ$2:AQ3)>0,\"\",\nIF(AND($D4>=(AP$13*$A$18),AO4=\"\"),$A4+$A$18-$G3,AN4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AR$13,\"\",\nIF(MAX(AS$2:AS3)>0,\"\",\nIF(AND($D4>=(AR$13*$A$18),AQ4=\"\"),$A4+$A$18-$G3,AP4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AT$13,\"\",\nIF(MAX(AU$2:AU3)>0,\"\",\nIF(AND($D4>=(AT$13*$A$18),AS4=\"\"),$A4+$A$18-$G3,AR4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E4<AV$13,\"\",\nIF(MAX(AW$2:AW3)>0,\"\",\nIF(AND($D4>=(AV$13*$A$18),AU4=\"\"),$A4+$A$18-$G3,AT4+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=3,B4+Calculator!N6,\"\")","v":""},{"$f":"IF(B4>=TODAY(),\"\",IF(Calculator!$E$13>=4,Calculator!M7,IF(A5>TODAY(),A5+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A5=\"\",\"\",SUM(C$2:C5))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K4)>0,E5<1),\"\",\nIF(D5>=$A$18,A5+$A$18-G4,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K4)>0,AND(K4>0,D5<$A$18)),\"\",IF(AND(K4>0,D5=\"\"),G$13,D5-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E5<L$13,\"\",\nIF(MAX(M$2:M4)>0,\"\",\nIF(AND($D5>=(L$13*$A$18),K5=\"\"),$A5+$A$18-$G4,J5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<N$13,\"\",\nIF(MAX(O$2:O4)>0,\"\",\nIF(AND($D5>=(N$13*$A$18),M5=\"\"),$A5+$A$18-$G4,L5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<P$13,\"\",\nIF(MAX(Q$2:Q4)>0,\"\",\nIF(AND($D5>=(P$13*$A$18),O5=\"\"),$A5+$A$18-$G4,N5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<R$13,\"\",\nIF(MAX(S$2:S4)>0,\"\",\nIF(AND($D5>=(R$13*$A$18),Q5=\"\"),$A5+$A$18-$G4,P5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<T$13,\"\",\nIF(MAX(U$2:U4)>0,\"\",\nIF(AND($D5>=(T$13*$A$18),S5=\"\"),$A5+$A$18-$G4,R5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<V$13,\"\",\nIF(MAX(W$2:W4)>0,\"\",\nIF(AND($D5>=(V$13*$A$18),U5=\"\"),$A5+$A$18-$G4,T5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<X$13,\"\",\nIF(MAX(Y$2:Y4)>0,\"\",\nIF(AND($D5>=(X$13*$A$18),W5=\"\"),$A5+$A$18-$G4,V5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<Z$13,\"\",\nIF(MAX(AA$2:AA4)>0,\"\",\nIF(AND($D5>=(Z$13*$A$18),Y5=\"\"),$A5+$A$18-$G4,X5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AB$13,\"\",\nIF(MAX(AC$2:AC4)>0,\"\",\nIF(AND($D5>=(AB$13*$A$18),AA5=\"\"),$A5+$A$18-$G4,Z5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AD$13,\"\",\nIF(MAX(AE$2:AE4)>0,\"\",\nIF(AND($D5>=(AD$13*$A$18),AC5=\"\"),$A5+$A$18-$G4,AB5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AF$13,\"\",\nIF(MAX(AG$2:AG4)>0,\"\",\nIF(AND($D5>=(AF$13*$A$18),AE5=\"\"),$A5+$A$18-$G4,AD5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AH$13,\"\",\nIF(MAX(AI$2:AI4)>0,\"\",\nIF(AND($D5>=(AH$13*$A$18),AG5=\"\"),$A5+$A$18-$G4,AF5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AJ$13,\"\",\nIF(MAX(AK$2:AK4)>0,\"\",\nIF(AND($D5>=(AJ$13*$A$18),AI5=\"\"),$A5+$A$18-$G4,AH5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AL$13,\"\",\nIF(MAX(AM$2:AM4)>0,\"\",\nIF(AND($D5>=(AL$13*$A$18),AK5=\"\"),$A5+$A$18-$G4,AJ5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AN$13,\"\",\nIF(MAX(AO$2:AO4)>0,\"\",\nIF(AND($D5>=(AN$13*$A$18),AM5=\"\"),$A5+$A$18-$G4,AL5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AP$13,\"\",\nIF(MAX(AQ$2:AQ4)>0,\"\",\nIF(AND($D5>=(AP$13*$A$18),AO5=\"\"),$A5+$A$18-$G4,AN5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AR$13,\"\",\nIF(MAX(AS$2:AS4)>0,\"\",\nIF(AND($D5>=(AR$13*$A$18),AQ5=\"\"),$A5+$A$18-$G4,AP5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AT$13,\"\",\nIF(MAX(AU$2:AU4)>0,\"\",\nIF(AND($D5>=(AT$13*$A$18),AS5=\"\"),$A5+$A$18-$G4,AR5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E5<AV$13,\"\",\nIF(MAX(AW$2:AW4)>0,\"\",\nIF(AND($D5>=(AV$13*$A$18),AU5=\"\"),$A5+$A$18-$G4,AT5+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=4,B5+Calculator!N7,\"\")","v":""},{"$f":"IF(B5>=TODAY(),\"\",IF(Calculator!$E$13>=5,Calculator!M8,IF(A6>TODAY(),A6+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A6=\"\",\"\",SUM(C$2:C6))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K5)>0,E6<1),\"\",\nIF(D6>=$A$18,A6+$A$18-G5,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K5)>0,AND(K5>0,D6<$A$18)),\"\",IF(AND(K5>0,D6=\"\"),G$13,D6-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E6<L$13,\"\",\nIF(MAX(M$2:M5)>0,\"\",\nIF(AND($D6>=(L$13*$A$18),K6=\"\"),$A6+$A$18-$G5,J6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<N$13,\"\",\nIF(MAX(O$2:O5)>0,\"\",\nIF(AND($D6>=(N$13*$A$18),M6=\"\"),$A6+$A$18-$G5,L6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<P$13,\"\",\nIF(MAX(Q$2:Q5)>0,\"\",\nIF(AND($D6>=(P$13*$A$18),O6=\"\"),$A6+$A$18-$G5,N6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<R$13,\"\",\nIF(MAX(S$2:S5)>0,\"\",\nIF(AND($D6>=(R$13*$A$18),Q6=\"\"),$A6+$A$18-$G5,P6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<T$13,\"\",\nIF(MAX(U$2:U5)>0,\"\",\nIF(AND($D6>=(T$13*$A$18),S6=\"\"),$A6+$A$18-$G5,R6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<V$13,\"\",\nIF(MAX(W$2:W5)>0,\"\",\nIF(AND($D6>=(V$13*$A$18),U6=\"\"),$A6+$A$18-$G5,T6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<X$13,\"\",\nIF(MAX(Y$2:Y5)>0,\"\",\nIF(AND($D6>=(X$13*$A$18),W6=\"\"),$A6+$A$18-$G5,V6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<Z$13,\"\",\nIF(MAX(AA$2:AA5)>0,\"\",\nIF(AND($D6>=(Z$13*$A$18),Y6=\"\"),$A6+$A$18-$G5,X6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AB$13,\"\",\nIF(MAX(AC$2:AC5)>0,\"\",\nIF(AND($D6>=(AB$13*$A$18),AA6=\"\"),$A6+$A$18-$G5,Z6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AD$13,\"\",\nIF(MAX(AE$2:AE5)>0,\"\",\nIF(AND($D6>=(AD$13*$A$18),AC6=\"\"),$A6+$A$18-$G5,AB6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AF$13,\"\",\nIF(MAX(AG$2:AG5)>0,\"\",\nIF(AND($D6>=(AF$13*$A$18),AE6=\"\"),$A6+$A$18-$G5,AD6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AH$13,\"\",\nIF(MAX(AI$2:AI5)>0,\"\",\nIF(AND($D6>=(AH$13*$A$18),AG6=\"\"),$A6+$A$18-$G5,AF6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AJ$13,\"\",\nIF(MAX(AK$2:AK5)>0,\"\",\nIF(AND($D6>=(AJ$13*$A$18),AI6=\"\"),$A6+$A$18-$G5,AH6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AL$13,\"\",\nIF(MAX(AM$2:AM5)>0,\"\",\nIF(AND($D6>=(AL$13*$A$18),AK6=\"\"),$A6+$A$18-$G5,AJ6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AN$13,\"\",\nIF(MAX(AO$2:AO5)>0,\"\",\nIF(AND($D6>=(AN$13*$A$18),AM6=\"\"),$A6+$A$18-$G5,AL6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AP$13,\"\",\nIF(MAX(AQ$2:AQ5)>0,\"\",\nIF(AND($D6>=(AP$13*$A$18),AO6=\"\"),$A6+$A$18-$G5,AN6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AR$13,\"\",\nIF(MAX(AS$2:AS5)>0,\"\",\nIF(AND($D6>=(AR$13*$A$18),AQ6=\"\"),$A6+$A$18-$G5,AP6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AT$13,\"\",\nIF(MAX(AU$2:AU5)>0,\"\",\nIF(AND($D6>=(AT$13*$A$18),AS6=\"\"),$A6+$A$18-$G5,AR6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E6<AV$13,\"\",\nIF(MAX(AW$2:AW5)>0,\"\",\nIF(AND($D6>=(AV$13*$A$18),AU6=\"\"),$A6+$A$18-$G5,AT6+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=5,B6+Calculator!N8,\"\")","v":""},{"$f":"IF(B6>=TODAY(),\"\",IF(Calculator!$E$13>=6,Calculator!M9,IF(A7>TODAY(),A7+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A7=\"\",\"\",SUM(C$2:C7))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K6)>0,E7<1),\"\",\nIF(D7>=$A$18,A7+$A$18-G6,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K6)>0,AND(K6>0,D7<$A$18)),\"\",IF(AND(K6>0,D7=\"\"),G$13,D7-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E7<L$13,\"\",\nIF(MAX(M$2:M6)>0,\"\",\nIF(AND($D7>=(L$13*$A$18),K7=\"\"),$A7+$A$18-$G6,J7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<N$13,\"\",\nIF(MAX(O$2:O6)>0,\"\",\nIF(AND($D7>=(N$13*$A$18),M7=\"\"),$A7+$A$18-$G6,L7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<P$13,\"\",\nIF(MAX(Q$2:Q6)>0,\"\",\nIF(AND($D7>=(P$13*$A$18),O7=\"\"),$A7+$A$18-$G6,N7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<R$13,\"\",\nIF(MAX(S$2:S6)>0,\"\",\nIF(AND($D7>=(R$13*$A$18),Q7=\"\"),$A7+$A$18-$G6,P7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<T$13,\"\",\nIF(MAX(U$2:U6)>0,\"\",\nIF(AND($D7>=(T$13*$A$18),S7=\"\"),$A7+$A$18-$G6,R7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<V$13,\"\",\nIF(MAX(W$2:W6)>0,\"\",\nIF(AND($D7>=(V$13*$A$18),U7=\"\"),$A7+$A$18-$G6,T7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<X$13,\"\",\nIF(MAX(Y$2:Y6)>0,\"\",\nIF(AND($D7>=(X$13*$A$18),W7=\"\"),$A7+$A$18-$G6,V7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<Z$13,\"\",\nIF(MAX(AA$2:AA6)>0,\"\",\nIF(AND($D7>=(Z$13*$A$18),Y7=\"\"),$A7+$A$18-$G6,X7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AB$13,\"\",\nIF(MAX(AC$2:AC6)>0,\"\",\nIF(AND($D7>=(AB$13*$A$18),AA7=\"\"),$A7+$A$18-$G6,Z7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AD$13,\"\",\nIF(MAX(AE$2:AE6)>0,\"\",\nIF(AND($D7>=(AD$13*$A$18),AC7=\"\"),$A7+$A$18-$G6,AB7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AF$13,\"\",\nIF(MAX(AG$2:AG6)>0,\"\",\nIF(AND($D7>=(AF$13*$A$18),AE7=\"\"),$A7+$A$18-$G6,AD7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AH$13,\"\",\nIF(MAX(AI$2:AI6)>0,\"\",\nIF(AND($D7>=(AH$13*$A$18),AG7=\"\"),$A7+$A$18-$G6,AF7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AJ$13,\"\",\nIF(MAX(AK$2:AK6)>0,\"\",\nIF(AND($D7>=(AJ$13*$A$18),AI7=\"\"),$A7+$A$18-$G6,AH7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AL$13,\"\",\nIF(MAX(AM$2:AM6)>0,\"\",\nIF(AND($D7>=(AL$13*$A$18),AK7=\"\"),$A7+$A$18-$G6,AJ7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AN$13,\"\",\nIF(MAX(AO$2:AO6)>0,\"\",\nIF(AND($D7>=(AN$13*$A$18),AM7=\"\"),$A7+$A$18-$G6,AL7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AP$13,\"\",\nIF(MAX(AQ$2:AQ6)>0,\"\",\nIF(AND($D7>=(AP$13*$A$18),AO7=\"\"),$A7+$A$18-$G6,AN7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AR$13,\"\",\nIF(MAX(AS$2:AS6)>0,\"\",\nIF(AND($D7>=(AR$13*$A$18),AQ7=\"\"),$A7+$A$18-$G6,AP7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AT$13,\"\",\nIF(MAX(AU$2:AU6)>0,\"\",\nIF(AND($D7>=(AT$13*$A$18),AS7=\"\"),$A7+$A$18-$G6,AR7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E7<AV$13,\"\",\nIF(MAX(AW$2:AW6)>0,\"\",\nIF(AND($D7>=(AV$13*$A$18),AU7=\"\"),$A7+$A$18-$G6,AT7+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=6,B7+Calculator!N9,\"\")","v":""},{"$f":"IF(B7>=TODAY(),\"\",IF(Calculator!$E$13>=7,Calculator!M10,IF(A8>TODAY(),A8+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A8=\"\",\"\",SUM(C$2:C8))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K7)>0,E8<1),\"\",\nIF(D8>=$A$18,A8+$A$18-G7,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K7)>0,AND(K7>0,D8<$A$18)),\"\",IF(AND(K7>0,D8=\"\"),G$13,D8-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E8<L$13,\"\",\nIF(MAX(M$2:M7)>0,\"\",\nIF(AND($D8>=(L$13*$A$18),K8=\"\"),$A8+$A$18-$G7,J8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<N$13,\"\",\nIF(MAX(O$2:O7)>0,\"\",\nIF(AND($D8>=(N$13*$A$18),M8=\"\"),$A8+$A$18-$G7,L8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<P$13,\"\",\nIF(MAX(Q$2:Q7)>0,\"\",\nIF(AND($D8>=(P$13*$A$18),O8=\"\"),$A8+$A$18-$G7,N8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<R$13,\"\",\nIF(MAX(S$2:S7)>0,\"\",\nIF(AND($D8>=(R$13*$A$18),Q8=\"\"),$A8+$A$18-$G7,P8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<T$13,\"\",\nIF(MAX(U$2:U7)>0,\"\",\nIF(AND($D8>=(T$13*$A$18),S8=\"\"),$A8+$A$18-$G7,R8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<V$13,\"\",\nIF(MAX(W$2:W7)>0,\"\",\nIF(AND($D8>=(V$13*$A$18),U8=\"\"),$A8+$A$18-$G7,T8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<X$13,\"\",\nIF(MAX(Y$2:Y7)>0,\"\",\nIF(AND($D8>=(X$13*$A$18),W8=\"\"),$A8+$A$18-$G7,V8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<Z$13,\"\",\nIF(MAX(AA$2:AA7)>0,\"\",\nIF(AND($D8>=(Z$13*$A$18),Y8=\"\"),$A8+$A$18-$G7,X8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AB$13,\"\",\nIF(MAX(AC$2:AC7)>0,\"\",\nIF(AND($D8>=(AB$13*$A$18),AA8=\"\"),$A8+$A$18-$G7,Z8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AD$13,\"\",\nIF(MAX(AE$2:AE7)>0,\"\",\nIF(AND($D8>=(AD$13*$A$18),AC8=\"\"),$A8+$A$18-$G7,AB8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AF$13,\"\",\nIF(MAX(AG$2:AG7)>0,\"\",\nIF(AND($D8>=(AF$13*$A$18),AE8=\"\"),$A8+$A$18-$G7,AD8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AH$13,\"\",\nIF(MAX(AI$2:AI7)>0,\"\",\nIF(AND($D8>=(AH$13*$A$18),AG8=\"\"),$A8+$A$18-$G7,AF8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AJ$13,\"\",\nIF(MAX(AK$2:AK7)>0,\"\",\nIF(AND($D8>=(AJ$13*$A$18),AI8=\"\"),$A8+$A$18-$G7,AH8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AL$13,\"\",\nIF(MAX(AM$2:AM7)>0,\"\",\nIF(AND($D8>=(AL$13*$A$18),AK8=\"\"),$A8+$A$18-$G7,AJ8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AN$13,\"\",\nIF(MAX(AO$2:AO7)>0,\"\",\nIF(AND($D8>=(AN$13*$A$18),AM8=\"\"),$A8+$A$18-$G7,AL8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AP$13,\"\",\nIF(MAX(AQ$2:AQ7)>0,\"\",\nIF(AND($D8>=(AP$13*$A$18),AO8=\"\"),$A8+$A$18-$G7,AN8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AR$13,\"\",\nIF(MAX(AS$2:AS7)>0,\"\",\nIF(AND($D8>=(AR$13*$A$18),AQ8=\"\"),$A8+$A$18-$G7,AP8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AT$13,\"\",\nIF(MAX(AU$2:AU7)>0,\"\",\nIF(AND($D8>=(AT$13*$A$18),AS8=\"\"),$A8+$A$18-$G7,AR8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E8<AV$13,\"\",\nIF(MAX(AW$2:AW7)>0,\"\",\nIF(AND($D8>=(AV$13*$A$18),AU8=\"\"),$A8+$A$18-$G7,AT8+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=7,B8+Calculator!N10,\"\")","v":""},{"$f":"IF(B8>=TODAY(),\"\",IF(Calculator!$E$13>=8,Calculator!M11,IF(A9>TODAY(),A9+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A9=\"\",\"\",SUM(C$2:C9))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K8)>0,E9<1),\"\",\nIF(D9>=$A$18,A9+$A$18-G8,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K8)>0,AND(K8>0,D9<$A$18)),\"\",IF(AND(K8>0,D9=\"\"),G$13,D9-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E9<L$13,\"\",\nIF(MAX(M$2:M8)>0,\"\",\nIF(AND($D9>=(L$13*$A$18),K9=\"\"),$A9+$A$18-$G8,J9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<N$13,\"\",\nIF(MAX(O$2:O8)>0,\"\",\nIF(AND($D9>=(N$13*$A$18),M9=\"\"),$A9+$A$18-$G8,L9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<P$13,\"\",\nIF(MAX(Q$2:Q8)>0,\"\",\nIF(AND($D9>=(P$13*$A$18),O9=\"\"),$A9+$A$18-$G8,N9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<R$13,\"\",\nIF(MAX(S$2:S8)>0,\"\",\nIF(AND($D9>=(R$13*$A$18),Q9=\"\"),$A9+$A$18-$G8,P9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<T$13,\"\",\nIF(MAX(U$2:U8)>0,\"\",\nIF(AND($D9>=(T$13*$A$18),S9=\"\"),$A9+$A$18-$G8,R9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<V$13,\"\",\nIF(MAX(W$2:W8)>0,\"\",\nIF(AND($D9>=(V$13*$A$18),U9=\"\"),$A9+$A$18-$G8,T9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<X$13,\"\",\nIF(MAX(Y$2:Y8)>0,\"\",\nIF(AND($D9>=(X$13*$A$18),W9=\"\"),$A9+$A$18-$G8,V9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<Z$13,\"\",\nIF(MAX(AA$2:AA8)>0,\"\",\nIF(AND($D9>=(Z$13*$A$18),Y9=\"\"),$A9+$A$18-$G8,X9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AB$13,\"\",\nIF(MAX(AC$2:AC8)>0,\"\",\nIF(AND($D9>=(AB$13*$A$18),AA9=\"\"),$A9+$A$18-$G8,Z9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AD$13,\"\",\nIF(MAX(AE$2:AE8)>0,\"\",\nIF(AND($D9>=(AD$13*$A$18),AC9=\"\"),$A9+$A$18-$G8,AB9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AF$13,\"\",\nIF(MAX(AG$2:AG8)>0,\"\",\nIF(AND($D9>=(AF$13*$A$18),AE9=\"\"),$A9+$A$18-$G8,AD9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AH$13,\"\",\nIF(MAX(AI$2:AI8)>0,\"\",\nIF(AND($D9>=(AH$13*$A$18),AG9=\"\"),$A9+$A$18-$G8,AF9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AJ$13,\"\",\nIF(MAX(AK$2:AK8)>0,\"\",\nIF(AND($D9>=(AJ$13*$A$18),AI9=\"\"),$A9+$A$18-$G8,AH9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AL$13,\"\",\nIF(MAX(AM$2:AM8)>0,\"\",\nIF(AND($D9>=(AL$13*$A$18),AK9=\"\"),$A9+$A$18-$G8,AJ9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AN$13,\"\",\nIF(MAX(AO$2:AO8)>0,\"\",\nIF(AND($D9>=(AN$13*$A$18),AM9=\"\"),$A9+$A$18-$G8,AL9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AP$13,\"\",\nIF(MAX(AQ$2:AQ8)>0,\"\",\nIF(AND($D9>=(AP$13*$A$18),AO9=\"\"),$A9+$A$18-$G8,AN9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AR$13,\"\",\nIF(MAX(AS$2:AS8)>0,\"\",\nIF(AND($D9>=(AR$13*$A$18),AQ9=\"\"),$A9+$A$18-$G8,AP9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AT$13,\"\",\nIF(MAX(AU$2:AU8)>0,\"\",\nIF(AND($D9>=(AT$13*$A$18),AS9=\"\"),$A9+$A$18-$G8,AR9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E9<AV$13,\"\",\nIF(MAX(AW$2:AW8)>0,\"\",\nIF(AND($D9>=(AV$13*$A$18),AU9=\"\"),$A9+$A$18-$G8,AT9+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=8,B9+Calculator!N11,\"\")","v":""},{"$f":"IF(B9>=TODAY(),\"\",IF(Calculator!$E$13>=9,Calculator!M12,IF(A10>TODAY(),A10+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A10=\"\",\"\",SUM(C$2:C10))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K9)>0,E10<1),\"\",\nIF(D10>=$A$18,A10+$A$18-G9,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K9)>0,AND(K9>0,D10<$A$18)),\"\",IF(AND(K9>0,D10=\"\"),G$13,D10-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E10<L$13,\"\",\nIF(MAX(M$2:M9)>0,\"\",\nIF(AND($D10>=(L$13*$A$18),K10=\"\"),$A10+$A$18-$G9,J10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<N$13,\"\",\nIF(MAX(O$2:O9)>0,\"\",\nIF(AND($D10>=(N$13*$A$18),M10=\"\"),$A10+$A$18-$G9,L10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<P$13,\"\",\nIF(MAX(Q$2:Q9)>0,\"\",\nIF(AND($D10>=(P$13*$A$18),O10=\"\"),$A10+$A$18-$G9,N10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<R$13,\"\",\nIF(MAX(S$2:S9)>0,\"\",\nIF(AND($D10>=(R$13*$A$18),Q10=\"\"),$A10+$A$18-$G9,P10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<T$13,\"\",\nIF(MAX(U$2:U9)>0,\"\",\nIF(AND($D10>=(T$13*$A$18),S10=\"\"),$A10+$A$18-$G9,R10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<V$13,\"\",\nIF(MAX(W$2:W9)>0,\"\",\nIF(AND($D10>=(V$13*$A$18),U10=\"\"),$A10+$A$18-$G9,T10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<X$13,\"\",\nIF(MAX(Y$2:Y9)>0,\"\",\nIF(AND($D10>=(X$13*$A$18),W10=\"\"),$A10+$A$18-$G9,V10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<Z$13,\"\",\nIF(MAX(AA$2:AA9)>0,\"\",\nIF(AND($D10>=(Z$13*$A$18),Y10=\"\"),$A10+$A$18-$G9,X10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AB$13,\"\",\nIF(MAX(AC$2:AC9)>0,\"\",\nIF(AND($D10>=(AB$13*$A$18),AA10=\"\"),$A10+$A$18-$G9,Z10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AD$13,\"\",\nIF(MAX(AE$2:AE9)>0,\"\",\nIF(AND($D10>=(AD$13*$A$18),AC10=\"\"),$A10+$A$18-$G9,AB10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AF$13,\"\",\nIF(MAX(AG$2:AG9)>0,\"\",\nIF(AND($D10>=(AF$13*$A$18),AE10=\"\"),$A10+$A$18-$G9,AD10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AH$13,\"\",\nIF(MAX(AI$2:AI9)>0,\"\",\nIF(AND($D10>=(AH$13*$A$18),AG10=\"\"),$A10+$A$18-$G9,AF10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AJ$13,\"\",\nIF(MAX(AK$2:AK9)>0,\"\",\nIF(AND($D10>=(AJ$13*$A$18),AI10=\"\"),$A10+$A$18-$G9,AH10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AL$13,\"\",\nIF(MAX(AM$2:AM9)>0,\"\",\nIF(AND($D10>=(AL$13*$A$18),AK10=\"\"),$A10+$A$18-$G9,AJ10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AN$13,\"\",\nIF(MAX(AO$2:AO9)>0,\"\",\nIF(AND($D10>=(AN$13*$A$18),AM10=\"\"),$A10+$A$18-$G9,AL10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AP$13,\"\",\nIF(MAX(AQ$2:AQ9)>0,\"\",\nIF(AND($D10>=(AP$13*$A$18),AO10=\"\"),$A10+$A$18-$G9,AN10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AR$13,\"\",\nIF(MAX(AS$2:AS9)>0,\"\",\nIF(AND($D10>=(AR$13*$A$18),AQ10=\"\"),$A10+$A$18-$G9,AP10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AT$13,\"\",\nIF(MAX(AU$2:AU9)>0,\"\",\nIF(AND($D10>=(AT$13*$A$18),AS10=\"\"),$A10+$A$18-$G9,AR10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E10<AV$13,\"\",\nIF(MAX(AW$2:AW9)>0,\"\",\nIF(AND($D10>=(AV$13*$A$18),AU10=\"\"),$A10+$A$18-$G9,AT10+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(Calculator!$E$13>=9,B10+Calculator!N12,\"\")","v":""},{"$f":"IF(B10>=TODAY(),\"\",IF(Calculator!$E$13>=10,Calculator!M13,IF(A11>TODAY(),A11+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A11=\"\",\"\",SUM(C$2:C11))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K10)>0,E11<1),\"\",\nIF(D11>=$A$18,A11+$A$18-G10,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K10)>0,AND(K10>0,D11<$A$18)),\"\",IF(AND(K10>0,D11=\"\"),G$13,D11-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E11<L$13,\"\",\nIF(MAX(M$2:M10)>0,\"\",\nIF(AND($D11>=(L$13*$A$18),K11=\"\"),$A11+$A$18-$G10,J11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<N$13,\"\",\nIF(MAX(O$2:O10)>0,\"\",\nIF(AND($D11>=(N$13*$A$18),M11=\"\"),$A11+$A$18-$G10,L11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<P$13,\"\",\nIF(MAX(Q$2:Q10)>0,\"\",\nIF(AND($D11>=(P$13*$A$18),O11=\"\"),$A11+$A$18-$G10,N11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<R$13,\"\",\nIF(MAX(S$2:S10)>0,\"\",\nIF(AND($D11>=(R$13*$A$18),Q11=\"\"),$A11+$A$18-$G10,P11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<T$13,\"\",\nIF(MAX(U$2:U10)>0,\"\",\nIF(AND($D11>=(T$13*$A$18),S11=\"\"),$A11+$A$18-$G10,R11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<V$13,\"\",\nIF(MAX(W$2:W10)>0,\"\",\nIF(AND($D11>=(V$13*$A$18),U11=\"\"),$A11+$A$18-$G10,T11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<X$13,\"\",\nIF(MAX(Y$2:Y10)>0,\"\",\nIF(AND($D11>=(X$13*$A$18),W11=\"\"),$A11+$A$18-$G10,V11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<Z$13,\"\",\nIF(MAX(AA$2:AA10)>0,\"\",\nIF(AND($D11>=(Z$13*$A$18),Y11=\"\"),$A11+$A$18-$G10,X11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AB$13,\"\",\nIF(MAX(AC$2:AC10)>0,\"\",\nIF(AND($D11>=(AB$13*$A$18),AA11=\"\"),$A11+$A$18-$G10,Z11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AD$13,\"\",\nIF(MAX(AE$2:AE10)>0,\"\",\nIF(AND($D11>=(AD$13*$A$18),AC11=\"\"),$A11+$A$18-$G10,AB11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AF$13,\"\",\nIF(MAX(AG$2:AG10)>0,\"\",\nIF(AND($D11>=(AF$13*$A$18),AE11=\"\"),$A11+$A$18-$G10,AD11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AH$13,\"\",\nIF(MAX(AI$2:AI10)>0,\"\",\nIF(AND($D11>=(AH$13*$A$18),AG11=\"\"),$A11+$A$18-$G10,AF11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AJ$13,\"\",\nIF(MAX(AK$2:AK10)>0,\"\",\nIF(AND($D11>=(AJ$13*$A$18),AI11=\"\"),$A11+$A$18-$G10,AH11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AL$13,\"\",\nIF(MAX(AM$2:AM10)>0,\"\",\nIF(AND($D11>=(AL$13*$A$18),AK11=\"\"),$A11+$A$18-$G10,AJ11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AN$13,\"\",\nIF(MAX(AO$2:AO10)>0,\"\",\nIF(AND($D11>=(AN$13*$A$18),AM11=\"\"),$A11+$A$18-$G10,AL11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AP$13,\"\",\nIF(MAX(AQ$2:AQ10)>0,\"\",\nIF(AND($D11>=(AP$13*$A$18),AO11=\"\"),$A11+$A$18-$G10,AN11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AR$13,\"\",\nIF(MAX(AS$2:AS10)>0,\"\",\nIF(AND($D11>=(AR$13*$A$18),AQ11=\"\"),$A11+$A$18-$G10,AP11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AT$13,\"\",\nIF(MAX(AU$2:AU10)>0,\"\",\nIF(AND($D11>=(AT$13*$A$18),AS11=\"\"),$A11+$A$18-$G10,AR11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E11<AV$13,\"\",\nIF(MAX(AW$2:AW10)>0,\"\",\nIF(AND($D11>=(AV$13*$A$18),AU11=\"\"),$A11+$A$18-$G10,AT11+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(AND(Calculator!$E$13>=10,B11<TODAY()),B11+Calculator!N13,\"\")","v":""},{"$f":"IF(B11>=TODAY(),\"\",\nIF(AND(Calculator!$E$13>=10,A12<=TODAY()),TODAY(),\nIF(A12>TODAY(),A12+365.25*21,TODAY())))","v":""},"",{"$f":"IF(A12=\"\",\"\",SUM(C$2:C12))","v":""},{"$error":"#VALUE!"},"","",null,null,{"$f":"IF(OR(MAX(K$2:K11)>0,E12<1),\"\",\nIF(D12>=$A$18,A12+$A$18-G11,\"\"\n))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(MAX(K$2:K11)>0,AND(K11>0,D12<$A$18)),\"\",IF(AND(K11>0,D12=\"\"),G$13,D12-$A$18))","v":{"$error":"#VALUE!"}},{"$f":"IF($E12<L$13,\"\",\nIF(MAX(M$2:M11)>0,\"\",\nIF(AND($D12>=(L$13*$A$18),K12=\"\"),$A12+$A$18-$G11,J12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<N$13,\"\",\nIF(MAX(O$2:O11)>0,\"\",\nIF(AND($D12>=(N$13*$A$18),M12=\"\"),$A12+$A$18-$G11,L12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<P$13,\"\",\nIF(MAX(Q$2:Q11)>0,\"\",\nIF(AND($D12>=(P$13*$A$18),O12=\"\"),$A12+$A$18-$G11,N12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<R$13,\"\",\nIF(MAX(S$2:S11)>0,\"\",\nIF(AND($D12>=(R$13*$A$18),Q12=\"\"),$A12+$A$18-$G11,P12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<T$13,\"\",\nIF(MAX(U$2:U11)>0,\"\",\nIF(AND($D12>=(T$13*$A$18),S12=\"\"),$A12+$A$18-$G11,R12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<V$13,\"\",\nIF(MAX(W$2:W11)>0,\"\",\nIF(AND($D12>=(V$13*$A$18),U12=\"\"),$A12+$A$18-$G11,T12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<X$13,\"\",\nIF(MAX(Y$2:Y11)>0,\"\",\nIF(AND($D12>=(X$13*$A$18),W12=\"\"),$A12+$A$18-$G11,V12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<Z$13,\"\",\nIF(MAX(AA$2:AA11)>0,\"\",\nIF(AND($D12>=(Z$13*$A$18),Y12=\"\"),$A12+$A$18-$G11,X12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AB$13,\"\",\nIF(MAX(AC$2:AC11)>0,\"\",\nIF(AND($D12>=(AB$13*$A$18),AA12=\"\"),$A12+$A$18-$G11,Z12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AD$13,\"\",\nIF(MAX(AE$2:AE11)>0,\"\",\nIF(AND($D12>=(AD$13*$A$18),AC12=\"\"),$A12+$A$18-$G11,AB12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AF$13,\"\",\nIF(MAX(AG$2:AG11)>0,\"\",\nIF(AND($D12>=(AF$13*$A$18),AE12=\"\"),$A12+$A$18-$G11,AD12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AH$13,\"\",\nIF(MAX(AI$2:AI11)>0,\"\",\nIF(AND($D12>=(AH$13*$A$18),AG12=\"\"),$A12+$A$18-$G11,AF12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AJ$13,\"\",\nIF(MAX(AK$2:AK11)>0,\"\",\nIF(AND($D12>=(AJ$13*$A$18),AI12=\"\"),$A12+$A$18-$G11,AH12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AL$13,\"\",\nIF(MAX(AM$2:AM11)>0,\"\",\nIF(AND($D12>=(AL$13*$A$18),AK12=\"\"),$A12+$A$18-$G11,AJ12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AN$13,\"\",\nIF(MAX(AO$2:AO11)>0,\"\",\nIF(AND($D12>=(AN$13*$A$18),AM12=\"\"),$A12+$A$18-$G11,AL12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AP$13,\"\",\nIF(MAX(AQ$2:AQ11)>0,\"\",\nIF(AND($D12>=(AP$13*$A$18),AO12=\"\"),$A12+$A$18-$G11,AN12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AR$13,\"\",\nIF(MAX(AS$2:AS11)>0,\"\",\nIF(AND($D12>=(AR$13*$A$18),AQ12=\"\"),$A12+$A$18-$G11,AP12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AT$13,\"\",\nIF(MAX(AU$2:AU11)>0,\"\",\nIF(AND($D12>=(AT$13*$A$18),AS12=\"\"),$A12+$A$18-$G11,AR12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF($E12<AV$13,\"\",\nIF(MAX(AW$2:AW11)>0,\"\",\nIF(AND($D12>=(AV$13*$A$18),AU12=\"\"),$A12+$A$18-$G11,AT12+$A$18\n)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!E13=\"\",G2,\nIF(Calculator!E13=1,G3,\nIF(Calculator!E13=2,G4,\nIF(Calculator!E13=3,G5,\nIF(Calculator!E13=4,G6,\nIF(Calculator!E13=5,G7,\nIF(Calculator!E13=6,G8,\nIF(Calculator!E13=7,G9,\nIF(Calculator!E13=8,G10,\nIF(Calculator!E13=9,G11,\nIF(AND(Calculator!E13>=10,A12=\"\"),G11,\nG12)))))))))))","v":{"$error":"#VALUE!"}},null,null,null,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14," ",15,null,16,null,17,null,18,null,19,null,20]
[]
[]
[]
[]
[365.24990000000003]
[]
["PastTime",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Calculator!E13=\"\",'Time Accounting'!D2<$A$18),0,MAX(J2:J12))","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(L2:L12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(N2:N12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(P2:P12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(R2:R12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(T2:T12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(V2:V12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(X2:X12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(Z2:Z12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AB2:AB12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AD2:AD12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AF2:AF12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AH2:AH12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AJ2:AJ12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AL2:AL12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AN2:AN12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AP2:AP12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AR2:AR12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AT2:AT12)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AV2:AV12)","v":{"$error":"#VALUE!"}}]
["FutureTime",null,null,null,null,null,null,null,null,{"$f":"IF(J20=0,TODAY()+$A$18-$G$13,\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(L20=0,J20>0),TODAY()+$A$18-$G$13,\nIF(AND(L20=0,J20=0),J21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(N20=0,L20>0),TODAY()+$A$18-$G$13,\nIF(AND(N20=0,L20=0),L21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(P20=0,N20>0),TODAY()+$A$18-$G$13,\nIF(AND(P20=0,N20=0),N21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(R20=0,P20>0),TODAY()+$A$18-$G$13,\nIF(AND(R20=0,P20=0),P21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(T20=0,R20>0),TODAY()+$A$18-$G$13,\nIF(AND(T20=0,R20=0),R21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(V20=0,T20>0),TODAY()+$A$18-$G$13,\nIF(AND(V20=0,T20=0),T21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(X20=0,V20>0),TODAY()+$A$18-$G$13,\nIF(AND(X20=0,V20=0),V21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(Z20=0,X20>0),TODAY()+$A$18-$G$13,\nIF(AND(Z20=0,X20=0),X21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AB20=0,Z20>0),TODAY()+$A$18-$G$13,\nIF(AND(AB20=0,Z20=0),Z21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AD20=0,AB20>0),TODAY()+$A$18-$G$13,\nIF(AND(AD20=0,AB20=0),AB21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AF20=0,AD20>0),TODAY()+$A$18-$G$13,\nIF(AND(AF20=0,AD20=0),AD21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AH20=0,AF20>0),TODAY()+$A$18-$G$13,\nIF(AND(AH20=0,AF20=0),AF21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AJ20=0,AH20>0),TODAY()+$A$18-$G$13,\nIF(AND(AJ20=0,AH20=0),AH21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AL20=0,AJ20>0),TODAY()+$A$18-$G$13,\nIF(AND(AL20=0,AJ20=0),AJ21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AN20=0,AL20>0),TODAY()+$A$18-$G$13,\nIF(AND(AN20=0,AL20=0),AL21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AP20=0,AN20>0),TODAY()+$A$18-$G$13,\nIF(AND(AP20=0,AN20=0),AN21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AR20=0,AP20>0),TODAY()+$A$18-$G$13,\nIF(AND(AR20=0,AP20=0),AP21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AT20=0,AR20>0),TODAY()+$A$18-$G$13,\nIF(AND(AT20=0,AR20=0),AR21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(AV20=0,AT20>0),TODAY()+$A$18-$G$13,\nIF(AND(AV20=0,AT20=0),AT21+$A$18,\n\"\"))","v":{"$error":"#VALUE!"}}]
["Timeline",null,null,null,null,null,null,null,null,{"$f":"MAX(J20:J21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(L20:L21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(N20:N21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(P20:P21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(R20:R21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(T20:T21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(V20:V21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(X20:X21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(Z20:Z21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AB20:AB21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AD20:AD21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AF20:AF21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AH20:AH21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AJ20:AJ21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AL20:AL21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AN20:AN21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AP20:AP21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AR20:AR21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AT20:AT21)","v":{"$error":"#VALUE!"}},null,{"$f":"MAX(AV20:AV21)","v":{"$error":"#VALUE!"}}]

{"sheet":"GHR_RecidRates","index":3,"n_rows":25,"n_cols":51,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Year","p at risk","logit hazard","Hazard rate","p surviving","cumulative surv","recidivism rate",null,"err",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,null,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1]
[1,1,{"$f":"(LN(D2/(1-D2)))","v":-2.0165775169546811},{"$f":"Get_HR!C6","v":0.11747334692592511},{"$f":"1-D2","v":0.88252665307407485},{"$f":"B2*E2","v":0.88252665307407485},{"$f":"100*(1-F2)","v":11.747334692592515},{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A2=Get_HR!$C$3,(H2-G2),\"\")","v":""},{"$f":"E2","v":0.88252665307407485},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$J$21)","v":62.265485761078018},{"$f":"100*(1-$J$20)","v":61.840628636592363},{"$f":"100*(1-$J$19)","v":61.351341682882918},{"$f":"100*(1-$J$18)","v":60.786983106730155},{"$f":"100*(1-$J$17)","v":60.134890545252674},{"$f":"100*(1-$J$16)","v":59.379919608898192},{"$f":"100*(1-$J$15)","v":58.503854601729934},{"$f":"100*(1-$J$14)","v":57.484649487205353},{"$f":"100*(1-$J$13)","v":56.29544131718616},{"$f":"100*(1-$J$12)","v":54.903255701825884},{"$f":"100*(1-$J$11)","v":53.267291202220036},{"$f":"100*(1-$J$10)","v":51.336621757979337},{"$f":"100*(1-$J$9)","v":49.047085605760586},{"$f":"100*(1-$J$8)","v":46.317023271106841},{"$f":"100*(1-$J$7)","v":43.041366376787792},{"$f":"100*(1-$J$6)","v":39.0833310937345},{"$f":"100*(1-$J$5)","v":34.262581999290695},{"$f":"100*(1-$J$4)","v":28.338114706524166},{"$f":"100*(1-$J$3)","v":20.983106252751572},{"$f":"100*(1-$J$2)","v":11.747334692592515},0]
[2,{"$f":"F2","v":0.88252665307407485},{"$f":"C2-0.13","v":-2.146577516954681},{"$f":"1/(1+EXP(-C3))","v":0.1046514745814011},{"$f":"1-D3","v":0.89534852541859888},{"$f":"B3*E3","v":0.79016893747248429},{"$f":"100*(1-F3)","v":20.983106252751572},{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A3=Get_HR!$C$3,(H3-G3),\"\")","v":""},{"$f":"J2*E3","v":0.79016893747248429},{"$f":"E3","v":0.89534852541859888},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$K$21)","v":57.242634987303063},{"$f":"100*(1-$K$20)","v":56.761225023076179},{"$f":"100*(1-$K$19)","v":56.206808958694296},{"$f":"100*(1-$K$18)","v":55.567328469139724},{"$f":"100*(1-$K$17)","v":54.82843570119207},{"$f":"100*(1-$K$16)","v":53.972970391759524},{"$f":"100*(1-$K$15)","v":52.980292148992937},{"$f":"100*(1-$K$14)","v":51.825420382826536},{"$f":"100*(1-$K$13)","v":50.477916411272972},{"$f":"100*(1-$K$12)","v":48.90041661507879},{"$f":"100*(1-$K$11)","v":47.046688465444618},{"$f":"100*(1-$K$10)","v":44.859027121149055},{"$f":"100*(1-$K$9)","v":42.264730230235116},{"$f":"100*(1-$K$8)","v":39.171268604861851},{"$f":"100*(1-$K$7)","v":35.45958818942163},{"$f":"100*(1-$K$6)","v":30.974697824619156},{"$f":"100*(1-$K$5)","v":25.51225759388862},{"$f":"100*(1-$K$4)","v":18.799182955145376},{"$f":"100*(1-$K$3)","v":10.465147458140112},0]
[3,{"$f":"F3","v":0.79016893747248429},{"$f":"C3-0.13","v":-2.2765775169546809},{"$f":"1/(1+EXP(-C4))","v":9.3081467835208584E-2},{"$f":"1-D4","v":0.90691853216479146},{"$f":"B4*E4","v":0.71661885293475835},{"$f":"100*(1-F4)","v":28.338114706524166},{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A4=Get_HR!$C$3,(H4-G4),\"\")","v":""},{"$f":"J3*E4","v":0.71661885293475835},{"$f":"K3*E4","v":0.81200817044854623},{"$f":"E4","v":0.90691853216479146},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$L$21)","v":52.245004265007587},{"$f":"100*(1-$L$20)","v":51.707325416425356},{"$f":"100*(1-$L$19)","v":51.08810725875577},{"$f":"100*(1-$L$18)","v":50.373882047678777},{"$f":"100*(1-$L$17)","v":49.548624902588593},{"$f":"100*(1-$L$16)","v":48.593169808682454},{"$f":"100*(1-$L$15)","v":47.484463852750402},{"$f":"100*(1-$L$14)","v":46.194606625782306},{"$f":"100*(1-$L$13)","v":44.689601665927626},{"$f":"100*(1-$L$12)","v":42.927718163124453},{"$f":"100*(1-$L$11)","v":40.857319768524427},{"$f":"100*(1-$L$10)","v":38.413956896761412},{"$f":"100*(1-$L$9)","v":35.516429490100379},{"$f":"100*(1-$L$8)","v":32.061393224834866},{"$f":"100*(1-$L$7)","v":27.915878589955767},{"$f":"100*(1-$L$6)","v":22.906778516098303},{"$f":"100*(1-$L$5)","v":16.805869120869556},{"$f":"100*(1-$L$4)","v":9.3081467835208542},0]
[4,0.71661885293475835,-2.4065775169546808,8.2672501128098333E-2,{"$f":"1-D5","v":0.91732749887190168},0.65737418000709302,34.262581999290695,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A5=Get_HR!$C$3,(H5-G5),\"\")","v":""},0.65737418000709302,{"$f":"K4*E5","v":0.74487742406111379},{"$f":"L4*E5","v":0.83194130879130446},{"$f":"E5","v":0.91732749887190168},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$M$21)","v":47.343676370795443},{"$f":"100*(1-$M$20)","v":46.750812922191272},{"$f":"100*(1-$M$19)","v":46.068041387915173},{"$f":"100*(1-$M$18)","v":45.280511763427121},{"$f":"100*(1-$M$17)","v":44.370554456544973},{"$f":"100*(1-$M$16)","v":43.317036350982086},{"$f":"100*(1-$M$15)","v":42.094538500722479},{"$f":"100*(1-$M$14)","v":40.672296941837104},{"$f":"100*(1-$M$13)","v":39.012825989950969},{"$f":"100*(1-$M$12)","v":37.070111798635899},{"$f":"100*(1-$M$11)","v":34.787218328967754},{"$f":"100*(1-$M$10)","v":32.093081220609442},{"$f":"100*(1-$M$9)","v":28.898166458260597},{"$f":"100*(1-$M$8)","v":25.088522986736837},{"$f":"100*(1-$M$7)","v":20.517533986232174},{"$f":"100*(1-$M$6)","v":14.994325565404266},{"$f":"100*(1-$M$5)","v":8.2672501128098315},0]
[5,0.65737418000709302,-2.5365775169546807,7.3333411032234008E-2,0.92666658896776599,0.60916668906265503,39.0833310937345,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A6=Get_HR!$C$3,(H6-G6),\"\")","v":""},0.60916668906265503,0.69025302175380843,{"$f":"L5*E6","v":0.77093221483901697},{"$f":"M5*E6","v":0.85005674434595735},{"$f":"E6","v":0.92666658896776599},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$N$21)","v":42.598119326020921},{"$f":"100*(1-$N$20)","v":41.951825118844923},{"$f":"100*(1-$N$19)","v":41.207520020485013},{"$f":"100*(1-$N$18)","v":40.349015696286159},{"$f":"100*(1-$N$17)","v":39.3570501136549},{"$f":"100*(1-$N$16)","v":38.208585571974339},{"$f":"100*(1-$N$15)","v":36.875912288154765},{"$f":"100*(1-$N$14)","v":35.325493751008111},{"$f":"100*(1-$N$13)","v":33.516465945860119},{"$f":"100*(1-$N$12)","v":31.398668110622264},{"$f":"100*(1-$N$11)","v":28.910032947634591},{"$f":"100*(1-$N$10)","v":25.973091548111015},{"$f":"100*(1-$N$9)","v":22.490240803662775},{"$f":"100*(1-$N$8)","v":18.337260023942626},{"$f":"100*(1-$N$7)","v":13.354318810334719},{"$f":"100*(1-$N$6)","v":7.3333411032234004},0]
[6,0.60916668906265503,-2.6665775169546806,6.4974585021115486E-2,0.93502541497888447,0.56958633623212207,43.041366376787792,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A7=Get_HR!$C$3,(H7-G7),\"\")","v":""},0.56958633623212207,0.64540411810578369,0.72084121410044233,{"$f":"M6*E7","v":0.79482466013767827},{"$f":"N6*E7","v":0.8664568118966528},{"$f":"E7","v":0.93502541497888447},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$O$21)","v":38.055519258636195},{"$f":"100*(1-$O$20)","v":37.358079408240897},{"$f":"100*(1-$O$19)","v":36.55487240021764},{"$f":"100*(1-$O$18)","v":35.628428807214952},{"$f":"100*(1-$O$17)","v":34.557962261381846},{"$f":"100*(1-$O$16)","v":33.318611932629992},{"$f":"100*(1-$O$15)","v":31.880475174830114},{"$f":"100*(1-$O$14)","v":30.207361505248365},{"$f":"100*(1-$O$13)","v":28.255173062625104},{"$f":"100*(1-$O$12)","v":25.96977952362105},{"$f":"100*(1-$O$11)","v":23.284201784425974},{"$f":"100*(1-$O$10)","v":20.114840296174741},{"$f":"100*(1-$O$9)","v":16.356367954652363},{"$f":"100*(1-$O$8)","v":11.874733643927682},{"$f":"100*(1-$O$7)","v":6.4974585021115523},0]
[7,0.56958633623212207,-2.7965775169546805,5.7509400874815396E-2,0.94249059912518462,0.53682976728893161,46.317023271106841,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A8=Get_HR!$C$3,(H8-G8),\"\")","v":""},0.53682976728893161,0.60828731395138147,0.67938606775165133,0.74911477013263161,{"$f":"N7*E8","v":0.81662739976057375},{"$f":"O7*E8","v":0.88125266356072318},{"$f":"E8","v":0.94249059912518462},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$P$21)","v":33.75101922468847},{"$f":"100*(1-$P$20)","v":33.00511452603272},{"$f":"100*(1-$P$19)","v":32.146092947414573},{"$f":"100*(1-$P$18)","v":31.155271117161309},{"$f":"100*(1-$P$17)","v":30.010418230079871},{"$f":"100*(1-$P$16)","v":28.684945885801572},{"$f":"100*(1-$P$15)","v":27.146873513905291},{"$f":"100*(1-$P$14)","v":25.357495767826023},{"$f":"100*(1-$P$13)","v":23.269650441538992},{"$f":"100*(1-$P$12)","v":20.825445714702052},{"$f":"100*(1-$P$11)","v":17.953248129296597},{"$f":"100*(1-$P$10)","v":14.563648833407072},{"$f":"100*(1-$P$9)","v":10.544001579639906},{"$f":"100*(1-$P$8)","v":5.7509400874815375},0]
[8,0.53682976728893161,-2.9265775169546804,5.0855271093496954E-2,0.94914472890650303,0.50952914394239412,49.047085605760586,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A9=Get_HR!$C$3,(H9-G9),\"\")","v":""},0.50952914394239412,0.57735269769764885,0.64483570509899624,0.71101833541739401,0.77509759196337225,{"$f":"O8*E9","v":0.83643632045347638},{"$f":"P8*E9","v":0.89455998420360094},{"$f":"E9","v":0.94914472890650303},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$Q$21)","v":29.708603102456909},{"$f":"100*(1-$Q$20)","v":28.917184387672801},{"$f":"100*(1-$Q$19)","v":28.005746565995338},{"$f":"100*(1-$Q$18)","v":26.954466233679085},{"$f":"100*(1-$Q$17)","v":25.739756094242061},{"$f":"100*(1-$Q$16)","v":24.333405361928552},{"$f":"100*(1-$Q$15)","v":22.701482058583235},{"$f":"100*(1-$Q$14)","v":20.80291909388081},{"$f":"100*(1-$Q$13)","v":18.587676492814065},{"$f":"100*(1-$Q$12)","v":15.994329960651687},{"$f":"100*(1-$Q$11)","v":12.946875070309638},{"$f":"100*(1-$Q$10)","v":9.3504473722129884},{"$f":"100*(1-$Q$9)","v":5.0855271093496963},0]
[9,0.50952914394239412,-3.0565775169546803,4.4934351242479638E-2,0.95506564875752031,0.48663378242020661,51.336621757979337,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A10=Get_HR!$C$3,(H10-G10),\"\")","v":""},0.48663378242020661,0.55140972878850947,0.61586043103238586,0.67906918779390557,0.74026908451888984,0.79885159703825259,{"$f":"P9*E10","v":0.85436351166592928},{"$f":"Q9*E10","v":0.90649552627787011},{"$f":"E10","v":0.95506564875752031},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$R$21)","v":25.942382908742623},{"$f":"100*(1-$R$20)","v":25.108559898740879},{"$f":"100*(1-$R$19)","v":24.148287145893665},{"$f":"100*(1-$R$18)","v":23.040679106467042},{"$f":"100*(1-$R$17)","v":21.760884674234905},{"$f":"100*(1-$R$16)","v":20.279181526671998},{"$f":"100*(1-$R$15)","v":18.559819606782881},{"$f":"100*(1-$R$14)","v":16.559531445366527},{"$f":"100*(1-$R$13)","v":14.225595920466228},{"$f":"100*(1-$R$12)","v":11.49329761739275},{"$f":"100*(1-$R$11)","v":8.2825597841299725},{"$f":"100*(1-$R$10)","v":4.4934351242479682},0]
[10,0.48663378242020661,-3.1865775169546802,3.9673970735010881E-2,0.96032602926498911,0.46732708797779965,53.267291202220036,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A11=Get_HR!$C$3,(H11-G11),\"\")","v":""},0.46732708797779965,0.52953311534555381,0.59142680231475575,0.65212781671032249,0.7108996705236541,0.76715798215574027,0.82046751870703405,{"$f":"Q10*E11","v":0.87053124929690362},{"$f":"R10*E11","v":0.91717440215870027},{"$f":"E11","v":0.96032602926498911},null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$S$21)","v":22.458087370641355},{"$f":"100*(1-$S$20)","v":21.585034286713046},{"$f":"100*(1-$S$19)","v":20.57958219648609},{"$f":"100*(1-$S$18)","v":19.419862923923461},{"$f":"100*(1-$S$17)","v":18.079856156957153},{"$f":"100*(1-$S$16)","v":16.528441184080144},{"$f":"100*(1-$S$15)","v":14.728185963796713},{"$f":"100*(1-$S$14)","v":12.633787359869741},{"$f":"100*(1-$S$13)","v":10.190043803668559},{"$f":"100*(1-$S$12)","v":7.3291951210381789},{"$f":"100*(1-$S$11)","v":3.9673970735010888},0]
[11,0.46732708797779965,-3.3165775169546801,3.5006840854976434E-2,0.96499315914502359,0.45096744298174124,54.903255701825884,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A12=Get_HR!$C$3,(H12-G12),\"\")","v":""},0.45096744298174124,0.5109958338492121,0.57072281836875549,0.62929888201364104,0.68601331889377737,0.7403022047637895,0.79174554285297949,0.84005670039348312,{"$f":"R11*E12","v":0.8850670238260725},{"$f":"S11*E12","v":0.92670804878961821},{"$f":"E12","v":0.96499315914502359},null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$T$21)","v":19.254596599128536},{"$f":"100*(1-$T$20)","v":18.345475053608705},{"$f":"100*(1-$T$19)","v":17.298484698680493},{"$f":"100*(1-$T$18)","v":16.090853917860937},{"$f":"100*(1-$T$17)","v":14.69548742134733},{"$f":"100*(1-$T$16)","v":13.079978806981829},{"$f":"100*(1-$T$15)","v":11.205349602500814},{"$f":"100*(1-$T$14)","v":9.0244250621861255},{"$f":"100*(1-$T$13)","v":6.4797230737670741},{"$f":"100*(1-$T$12)","v":3.5006840854976407},0]
[12,0.45096744298174124,-3.44657751695468,3.087108918895181E-2,0.96912891081104824,0.43704558682813838,56.29544131718616,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A13=Get_HR!$C$3,(H13-G13),\"\")","v":""},0.43704558682813838,0.49522083588727028,0.55310398334072375,0.60987174010049028,0.66483534054139881,0.71744826937374895,0.76730349558461008,0.81412323507185935,0.85774404079533773,{"$f":"S12*E13","v":0.89809956196331442},{"$f":"T12*E13","v":0.93520276926232926},{"$f":"E13","v":0.96912891081104824},null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$U$21)","v":16.325413671936005},{"$f":"100*(1-$U$20)","v":15.383312127583814},{"$f":"100*(1-$U$19)","v":14.298340337881344},{"$f":"100*(1-$U$18)","v":13.046900605511102},{"$f":"100*(1-$U$17)","v":11.60091471090654},{"$f":"100*(1-$U$16)","v":9.9268006521117336},{"$f":"100*(1-$U$15)","v":7.9841659435487049},{"$f":"100*(1-$U$14)","v":5.7241244918072587},{"$f":"100*(1-$U$13)","v":3.0871089188951761},0]
[13,0.43704558682813838,-3.5765775169546798,2.7210163101059469E-2,0.9727898368989405,0.42515350512794647,57.484649487205353,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A14=Get_HR!$C$3,(H14-G14),\"\")","v":""},0.42515350512794647,0.48174579617173463,0.53805393374217692,0.59327703058162895,0.64674506248991892,0.69792638494751635,0.74642504232173978,0.79197080906119188,0.83440468554633473,0.87366212640130259,{"$f":"T13*E14","v":0.90975574937813874},{"$f":"U13*E14","v":0.94275875508192741},{"$f":"E14","v":0.9727898368989405},null,null,null,null,null,null,null,null,{"$f":"100*(1-$V$21)","v":13.660003953407918},{"$f":"100*(1-$V$20)","v":12.687892262339117},{"$f":"100*(1-$V$19)","v":11.568359269773175},{"$f":"100*(1-$V$18)","v":10.277055586217877},{"$f":"100*(1-$V$17)","v":8.7850085752640421},{"$f":"100*(1-$V$16)","v":7.0575664980343289},{"$f":"100*(1-$V$15)","v":5.0530501876734357},{"$f":"100*(1-$V$14)","v":2.7210163101059504},0]
[14,0.42515350512794647,-3.7065775169546797,2.3972638170250041E-2,0.97602736182974992,0.41496145398270062,58.503854601729934,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A15=Get_HR!$C$3,(H15-G15),\"\")","v":""},0.41496145398270062,0.47019707851007059,0.52515536147249597,0.57905461499277522,0.63124087711845234,0.68119524825169886,0.7285312648609471,0.77298517941416767,0.81440180393217121,0.85271814036203286,0.88794650397499186,{"$f":"U14*E15","v":0.92015834056451296},{"$f":"V14*E15","v":0.94946949812326564},{"$f":"E15","v":0.97602736182974992},null,null,null,null,null,null,null,{"$f":"100*(1-$W$21)","v":11.244964974318883},{"$f":"100*(1-$W$20)","v":10.245662088746299},{"$f":"100*(1-$W$19)","v":9.0948143412669538},{"$f":"100*(1-$W$18)","v":7.7673912591429524},{"$f":"100*(1-$W$17)","v":6.2336098046510191},{"$f":"100*(1-$W$16)","v":4.4578489859150245},{"$f":"100*(1-$W$15)","v":2.3972638170250082},0]
[15,0.41496145398270062,-3.8365775169546796,2.1111961093253105E-2,0.97888803890674692,0.40620080391101809,59.379919608898192,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A16=Get_HR!$C$3,(H16-G16),\"\")","v":""},0.40620080391101809,0.46027029608240472,0.51406830191317543,0.56682963649017915,0.61791414428025659,0.66681388067370007,0.71315054114198428,0.75666594638071449,0.79720818473328003,0.83471558815919855,0.86920021193018171,0.90073199347888266,{"$f":"V15*E16","v":0.92942433501965671},{"$f":"W15*E16","v":0.95542151014084975},{"$f":"E16","v":0.97888803890674692},null,null,null,null,null,null,{"$f":"100*(1-$X$21)","v":9.0650134446099813},{"$f":"100*(1-$X$20)","v":8.0411662404709432},{"$f":"100*(1-$X$19)","v":6.8620520142858688},{"$f":"100*(1-$X$18)","v":5.5020255088449765},{"$f":"100*(1-$X$17)","v":3.9305721721100584},{"$f":"100*(1-$X$16)","v":2.1111961093253084},0]
[16,0.40620080391101809,-3.9665775169546795,1.8586150718693885E-2,0.98141384928130615,0.39865109454747333,60.134890545252674,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A17=Get_HR!$C$3,(H17-G17),\"\")","v":""},0.39865109454747333,0.45171564298807931,0.50451375097411411,0.55629445543455025,0.60642949886345099,0.65442037738618153,0.69989581769920128,0.74260243905757939,0.78239115325765096,0.81920143843042847,0.85304512578652669,0.8839908528909346,0.91214991424735958,{"$f":"W16*E17","v":0.93766390195348981},{"$f":"X16*E17","v":0.96069427827889942},{"$f":"E17","v":0.98141384928130615},null,null,null,null,null,{"$f":"100*(1-$Y$21)","v":7.1037923224099302},{"$f":"100*(1-$Y$20)","v":6.0578635098743288},{"$f":"100*(1-$Y$19)","v":4.853318986578337},{"$f":"100*(1-$Y$18)","v":3.4639603966421406},{"$f":"100*(1-$Y$17)","v":1.858615071869385},0]
[17,0.39865109454747333,{"$f":"C17-0.13","v":-4.0965775169546799},1.6357475757534462E-2,0.98364252424246557,0.39213016893269848,60.786983106730155,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A18=Get_HR!$C$3,(H18-G18),\"\")","v":""},0.39213016893269848,0.44432671530860274,0.49626117952321225,0.54719488236572877,0.59650984303713839,0.64371571192785049,0.68844728882838691,0.73045533766320914,0.76959320893532956,0.80580137076076541,0.83909146082139063,0.86953099394488897,0.89722944413782124,0.92232608740857047,{"$f":"X17*E18","v":0.94497974491155023},{"$f":"Y17*E18","v":0.96536039603357859},{"$f":"E18","v":0.98364252424246557},null,null,null,null,{"$f":"100*(1-$Z$21)","v":5.3445111401083327},{"$f":"100*(1-$Z$20)","v":4.2787743835896226},{"$f":"100*(1-$Z$19)","v":3.0514180301225435},{"$f":"100*(1-$Z$18)","v":1.6357475757534434},0]
[18,0.39213016893269848,-4.2265775169546798,1.4392123352529507E-2,0.98560787664747052,0.38648658317117085,61.351341682882918,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A19=Get_HR!$C$3,(H19-G19),\"\")","v":""},0.38648658317117085,0.43793191041305707,0.48911892741244239,0.53931958612084829,0.58792479979514989,0.63445127599782358,0.67853907052585427,0.71994253434004662,0.75851712854106335,0.7942041780351391,0.82701515301319506,0.85701659662118657,0.88431640730226824,0.90905185658733045,0.93137947985714131,{"$f":"Y18*E19","v":0.95146681013421663},{"$f":"Z18*E19","v":0.96948581969877456},{"$f":"E19","v":0.98560787664747052},null,null,null,{"$f":"100*(1-$AA$21)","v":3.7704384193954277},{"$f":"100*(1-$AA$20)","v":2.6869790017177819},{"$f":"100*(1-$AA$19)","v":1.4392123352529484},0]
[19,0.38648658317117085,-4.3565775169546797,1.2659869061812849E-2,0.98734013093818718,0.3815937136340764,61.840628636592363,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A20=Get_HR!$C$3,(H20-G20),\"\")","v":""},0.3815937136340764,0.43238774976923822,0.48292674583574652,0.53249187077808724,0.58048174881155079,0.62641920591759104,0.66994885473967281,0.71082815612327199,0.74891440101259121,0.78414965713286955,0.81654524946391294,0.84616687872416185,0.87312107737660882,0.89754337911253701,0.91958833759529057,0.93942136490125672,{"$f":"Z19*E20","v":0.95721225616410377},{"$f":"AA19*E20","v":0.97313020998282218},{"$f":"E20","v":0.98734013093818718},null,null,{"$f":"100*(1-$AB$21)","v":2.3652673029279203},{"$f":"100*(1-$AB$20)","v":1.2659869061812823},0]
[20,0.3815937136340764,-4.4865775169546795,1.1133755858805008E-2,0.98886624414119495,0.37734514238921985,62.265485761078018,{"$f":"Get_HR!$C$2","v":0},{"$f":"IF(A21=Get_HR!$C$3,(H21-G21),\"\")","v":""},0.37734514238921985,0.42757365012696941,0.47754995734992411,0.5265632362920456,0.57401880673979078,0.61944480741363805,0.66248980775311528,0.7029139689754309,0.74057617091257377,0.77541912629358645,0.80745403400871463,0.83674586328063993,0.86339996046592082,0.88755035025681117,0.90934986555390018,0.9289620767759007,0.94655488859891668,{"$f":"AA20*E21","v":0.96229561580604572},{"$f":"AB20*E21","v":0.9763473269707208},{"$f":"E21","v":0.98886624414119495},null,{"$f":"100*(1-$AC$21)","v":1.113375585880505},0]
[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,0]
[null,null,null,null,null,null,null,null,null,{"$f":"1-J21","v":0.62265485761078021},{"$f":"1-K21","v":0.57242634987303065},0.52245004265007589,0.4734367637079544,0.42598119326020922,0.38055519258636195,0.33751019224688472,0.2970860310245691,0.25942382908742623,0.22458087370641355,0.19254596599128537,0.16325413671936007,0.13660003953407918,0.11244964974318883,9.0650134446099817E-2,7.1037923224099297E-2,5.3445111401083323E-2,3.7704384193954277E-2,2.3652673029279203E-2,1.113375585880505E-2]
[]
["*** Will have to do time free decrement separately for those without NS offense event"]

{"sheet":"GHR_NS_RecidRates","index":4,"n_rows":26,"n_cols":51,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Year","p at risk","logit hazard","Hazard rate","p surviving","cumulative surv","recidivism rate",null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,null,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1]
[{"$f":"Get_HR!C6","v":0.11747334692592511},1,{"$f":"IF(AND(Calculator!$E$9>=Calculator!I5,Calculator!$E$9<Calculator!I6),\n(LN(A2/(1 - A2)))+(0.44),\n(LN(A2/(1 - A2))-(0.135))   )","v":{"$error":"#VALUE!"}},{"$f":"(1/(1+EXP(-1*C2)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Calculator!$E$9>Calculator!I6,1,1-D2)","v":{"$error":"#VALUE!"}},{"$f":"B2*E2","v":{"$error":"#VALUE!"}},{"$f":"100*(1-F2)","v":{"$error":"#VALUE!"}},null,null,{"$f":"E2","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$J$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$7)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$6)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$5)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$4)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$3)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$J$2)","v":{"$error":"#VALUE!"}},0]
[2,{"$f":"F2","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I6,Calculator!$E$9<Calculator!I7),\n(C2+0.44),\n(C2-0.135))","v":{"$error":"#VALUE!"}},{"$f":"1/(1+EXP(-C3))","v":{"$error":"#VALUE!"}},{"$f":"IF(Calculator!$E$9>Calculator!I7,1,1-D3)","v":{"$error":"#VALUE!"}},{"$f":"B3*E3","v":{"$error":"#VALUE!"}},{"$f":"100*(1-F3)","v":{"$error":"#VALUE!"}},null,null,{"$f":"J2*E3","v":{"$error":"#VALUE!"}},{"$f":"E3","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$K$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$7)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$6)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$5)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$4)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$K$3)","v":{"$error":"#VALUE!"}},0]
[3,{"$f":"F3","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I7,Calculator!$E$9<Calculator!I8),\n(C3+0.44),\n(C3-0.135))","v":{"$error":"#VALUE!"}},{"$f":"1/(1+EXP(-C4))","v":{"$error":"#VALUE!"}},{"$f":"IF(Calculator!$E$9>Calculator!I8,1,1-D4)","v":{"$error":"#VALUE!"}},{"$f":"B4*E4","v":{"$error":"#VALUE!"}},{"$f":"100*(1-F4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"J3*E4","v":{"$error":"#VALUE!"}},{"$f":"K3*E4","v":{"$error":"#VALUE!"}},{"$f":"E4","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$L$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$7)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$6)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$5)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$L$4)","v":{"$error":"#VALUE!"}},0]
[4,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I8,Calculator!$E$9<Calculator!I9),\n(C4+0.44),\n(C4-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I9,1,1-D5)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$f":"K4*E5","v":{"$error":"#VALUE!"}},{"$f":"L4*E5","v":{"$error":"#VALUE!"}},{"$f":"E5","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$M$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$7)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$6)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$M$5)","v":{"$error":"#VALUE!"}},0]
[5,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I9,Calculator!$E$9<Calculator!I10),\n(C5+0.44),\n(C5-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I10,1,1-D6)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"L5*E6","v":{"$error":"#VALUE!"}},{"$f":"M5*E6","v":{"$error":"#VALUE!"}},{"$f":"E6","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$N$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$7)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$N$6)","v":{"$error":"#VALUE!"}},0]
[6,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I10,Calculator!$E$9<Calculator!I11),\n(C6+0.44),\n(C6-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I11,1,1-D7)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"M6*E7","v":{"$error":"#VALUE!"}},{"$f":"N6*E7","v":{"$error":"#VALUE!"}},{"$f":"E7","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$O$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$8)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$O$7)","v":{"$error":"#VALUE!"}},0]
[7,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I11,Calculator!$E$9<Calculator!I12),\n(C7+0.44),\n(C7-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I12,1,1-D8)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N7*E8","v":{"$error":"#VALUE!"}},{"$f":"O7*E8","v":{"$error":"#VALUE!"}},{"$f":"E8","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$P$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$9)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$P$8)","v":{"$error":"#VALUE!"}},0]
[8,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I12,Calculator!$E$9<Calculator!I13),\n(C8+0.44),\n(C8-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I13,1,1-D9)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"O8*E9","v":{"$error":"#VALUE!"}},{"$f":"P8*E9","v":{"$error":"#VALUE!"}},{"$f":"E9","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$Q$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$10)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Q$9)","v":{"$error":"#VALUE!"}},0]
[9,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I13,Calculator!$E$9<Calculator!I14),\n(C9+0.44),\n(C9-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I14,1,1-D10)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"P9*E10","v":{"$error":"#VALUE!"}},{"$f":"Q9*E10","v":{"$error":"#VALUE!"}},{"$f":"E10","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$R$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$11)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$R$10)","v":{"$error":"#VALUE!"}},0]
[10,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I14,Calculator!$E$9<Calculator!I15),\n(C10+0.44),\n(C10-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I15,1,1-D11)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Q10*E11","v":{"$error":"#VALUE!"}},{"$f":"R10*E11","v":{"$error":"#VALUE!"}},{"$f":"E11","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$S$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$12)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$S$11)","v":{"$error":"#VALUE!"}},0]
[11,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I15,Calculator!$E$9<Calculator!I16),\n(C11+0.44),\n(C11-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I16,1,1-D12)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R11*E12","v":{"$error":"#VALUE!"}},{"$f":"S11*E12","v":{"$error":"#VALUE!"}},{"$f":"E12","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$T$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$13)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$T$12)","v":{"$error":"#VALUE!"}},0]
[12,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I16,Calculator!$E$9<Calculator!I17),\n(C12+0.44),\n(C12-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I17,1,1-D13)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"S12*E13","v":{"$error":"#VALUE!"}},{"$f":"T12*E13","v":{"$error":"#VALUE!"}},{"$f":"E13","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,{"$f":"100*(1-$U$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$14)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$U$13)","v":{"$error":"#VALUE!"}},0]
[13,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I17,Calculator!$E$9<Calculator!I18),\n(C13+0.44),\n(C13-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I18,1,1-D14)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"T13*E14","v":{"$error":"#VALUE!"}},{"$f":"U13*E14","v":{"$error":"#VALUE!"}},{"$f":"E14","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"100*(1-$V$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$15)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$V$14)","v":{"$error":"#VALUE!"}},0]
[14,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I18,Calculator!$E$9<Calculator!I19),\n(C14+0.44),\n(C14-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I19,1,1-D15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"U14*E15","v":{"$error":"#VALUE!"}},{"$f":"V14*E15","v":{"$error":"#VALUE!"}},{"$f":"E15","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"100*(1-$W$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$16)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$W$15)","v":{"$error":"#VALUE!"}},0]
[15,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I19,Calculator!$E$9<Calculator!I20),\n(C15+0.44),\n(C15-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I20,1,1-D16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"V15*E16","v":{"$error":"#VALUE!"}},{"$f":"W15*E16","v":{"$error":"#VALUE!"}},{"$f":"E16","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"100*(1-$X$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$X$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$X$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$X$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$X$17)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$X$16)","v":{"$error":"#VALUE!"}},0]
[16,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I20,Calculator!$E$9<Calculator!I21),\n(C16+0.44),\n(C16-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I21,1,1-D17)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"W16*E17","v":{"$error":"#VALUE!"}},{"$f":"X16*E17","v":{"$error":"#VALUE!"}},{"$f":"E17","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"100*(1-$Y$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Y$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Y$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Y$18)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Y$17)","v":{"$error":"#VALUE!"}},0]
[17,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I21,Calculator!$E$9<Calculator!I22),\n(C17+0.44),\n(C17-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I22,1,1-D18)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"X17*E18","v":{"$error":"#VALUE!"}},{"$f":"Y17*E18","v":{"$error":"#VALUE!"}},{"$f":"E18","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"100*(1-$Z$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Z$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Z$19)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$Z$18)","v":{"$error":"#VALUE!"}},0]
[18,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I22,Calculator!$E$9<Calculator!I23),\n(C18+0.44),\n(C18-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I23,1,1-D19)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Y18*E19","v":{"$error":"#VALUE!"}},{"$f":"Z18*E19","v":{"$error":"#VALUE!"}},{"$f":"E19","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"100*(1-$AA$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$AA$20)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$AA$19)","v":{"$error":"#VALUE!"}},0]
[19,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I23,Calculator!$E$9<Calculator!I24),\n(C19+0.44),\n(C19-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I24,1,1-D20)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Z19*E20","v":{"$error":"#VALUE!"}},{"$f":"AA19*E20","v":{"$error":"#VALUE!"}},{"$f":"E20","v":{"$error":"#VALUE!"}},null,null,{"$f":"100*(1-$AB$21)","v":{"$error":"#VALUE!"}},{"$f":"100*(1-$AB$20)","v":{"$error":"#VALUE!"}},0]
[20,{"$error":"#VALUE!"},{"$f":"IF(AND(Calculator!$E$9>=Calculator!I24,Calculator!$E$9<Calculator!I25),\n(C20+0.44),\n(C20-0.135))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Calculator!$E$9>Calculator!I25,1,1-D21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AA20*E21","v":{"$error":"#VALUE!"}},{"$f":"AB20*E21","v":{"$error":"#VALUE!"}},{"$f":"E21","v":{"$error":"#VALUE!"}},null,{"$f":"100*(1-$AC$21)","v":{"$error":"#VALUE!"}},0]
[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,0]
[null,null,null,null,null,null,null,null,null,{"$f":"1-J21","v":{"$error":"#VALUE!"}},{"$f":"1-K21","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["*** NOT done yet, must do NS increments separate from time free increment"]