{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DLTR Template","Random Testing Locations","Values"],"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":"DLTR Template","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,1,27,2],[13,1,13,2],[7,4,7,13],[8,4,8,13],[9,4,9,13],[12,0,12,13],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[25,1,25,2],[26,1,26,2],[0,0,0,13],[1,0,1,13],[2,2,11,3],[2,4,2,13],[3,4,3,13],[4,4,4,13],[5,4,5,13],[6,4,6,13],[10,4,10,13],[11,4,11,13],[33,0,33,13],[28,4,28,13],[29,10,30,10],[29,13,30,13],[29,1,29,3],[30,1,30,3],[28,1,28,2],[29,4,32,5],[31,0,32,0],[31,1,32,3],[31,10,32,13]]}
["Daily Long-Line Thermoplastic Report"]
["Contractor & District Information"]
["DISTRICT",null,"CONTRACTOR"]
["CONTACT"]
["PROJECT TYPE:"]
["FUNDING STRIP:"]
["CONTRACT ID:"]
["APPLICATION DATE:"]
["APPLICATION TYPE:"]
["FIRST DAY TO TEST:",{"$f":"IF(B8=\"\",\"\",B8+150)","v":""}]
["LAST DAY TO TEST:",{"$f":"IF(B8=\"\",\"\",B8+210)","v":""}]
["SECTION STATUS:"]
["Route Information"]
["County","Route",null,"Direction","Color","Width","Line Type","Starting Milepoint","Ending Milepoint","Striped Line Length (Miles)","Route Length (Miles)","Route Type","Mobile (KM 203)?","Corrective Restripe?"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H15=\"\",\"\",ABS(I15-H15))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H16=\"\",\"\",ABS(I16-H16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["Materials","Comments",null,null,"Totals Summary"]
["Yellow Thermoplastic",null,null,null,"Striped Line Length (Miles)",null,"MP 4\" W","MP 4\" Y","MP 6\" W","MP 6\" Y",null,"RS 4\" W","RS 4\" Y"]
["White Thermoplastic",null,null,null,null,null,{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"White\",$F$15:$F$28,4,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"Yellow\",$F$15:$F$28,4,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"White\",$F$15:$F$28,6,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"Yellow\",$F$15:$F$28,6,$L$15:$L$28,\"MP\")","v":0},null,{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"White\",$F$15:$F$28,4,$L$15:$L$28,\"RS\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"Yellow\",$F$15:$F$28,4,$L$15:$L$28,\"RS\")","v":0}]
["Beads",null,null,null,null,null,"MP 8\" W","MP 8\" Y","MP 12\" W","MP 12\" Y"]
[null,null,null,null,null,null,{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"White\",$F$15:$F$28,8,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"Yellow\",$F$15:$F$28,8,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"White\",$F$15:$F$28,12,$L$15:$L$28,\"MP\")","v":0},{"$f":"SUMIFS($J$15:$J$28,$E$15:$E$28,\"Yellow\",$F$15:$F$28,12,$L$15:$L$28,\"MP\")","v":0}]
["To request measurement of retroreflectivity in accordance with KM203, please email all correspondence to brandi.mitchell@ky.gov. Please notify Central Office at least two (2) weeks in advance of when mobile testing is needed."]

{"sheet":"Random Testing Locations","index":1,"n_rows":33,"n_cols":102,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,2],[31,1,31,2],[30,1,30,2],[31,37,31,38],[32,37,32,38],[32,18,32,19],[31,18,31,19],[30,18,30,19],[30,37,30,38],[29,1,29,2],[28,1,28,2],[27,1,27,2],[27,18,27,19],[26,37,26,44],[29,18,29,19],[28,18,28,19],[27,37,27,38],[28,37,28,38],[29,37,29,38],[24,19,24,23],[26,0,26,5],[26,18,26,25],[4,0,4,6],[4,83,4,101],[4,64,4,82],[4,45,4,63],[4,26,4,44],[4,7,4,25]]}
["Striped Line Length",{"$f":"SUM('DLTR Template'!J15:J28)","v":0}]
["Number of Segments",{"$f":"IF(B1<10,1,IF(B1<30,3,5))","v":1}]
["Segment Length (Striped)",{"$f":"B1/B2","v":0}]
[]
["Route Information",null,null,null,null,null,null,"Segment 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment 5"]
["Route","Route\nLength","Striped\nLength","Percent\nStriped","Begin\nMP","End\nMP","Dir","Length\n(Striped)","Length\n(Total)","Route1","R1 Name","Dir1","Route2","R2 Name","Dir2","Route3","R3 Name","Dir3","Begin MP","End MP","Zone 1\n(Striped)","Zone 1\n(Actual)","Zone 2\n(Striped)","Zone 2\n(Actual)","Zone 3\n(Striped)","Zone 3\n(Actual)","Length\n(Striped)","Length\n(Total)","Route1","R1 Name","Dir1","Route2","R2 Name","Dir2","Route3","R3 Name","Dir3","Begin MP","End MP","Zone 1\n(Striped)","Zone 1\n(Actual)","Zone 2\n(Striped)","Zone 2\n(Actual)","Zone 3\n(Striped)","Zone 3\n(Actual)","Length\n(Striped)","Length\n(Total)","Route1","R1 Name","Dir1","Route2","R2 Name","Dir2","Route3","R3 Name","Dir3","Begin MP","End MP","Zone 1\n(Striped)","Zone 1\n(Actual)","Zone 2\n(Striped)","Zone 2\n(Actual)","Zone 3\n(Striped)","Zone 3\n(Actual)","Length\n(Striped)","Length\n(Total)","Route1","R1 Name","Dir1","Route2","R2 Name","Dir2","Route3","R3 Name","Dir3","Begin MP","End MP","Zone 1\n(Striped)","Zone 1\n(Actual)","Zone 2\n(Striped)","Zone 2\n(Actual)","Zone 3\n(Striped)","Zone 3\n(Actual)","Length\n(Striped)","Length\n(Total)","Route1","R1 Name","Dir1","Route2","R2 Name","Dir2","Route3","R3 Name","Dir3","Begin MP","End MP","Zone 1\n(Striped)","Zone 1\n(Actual)","Zone 2\n(Striped)","Zone 2\n(Actual)","Zone 3\n(Striped)","Zone 3\n(Actual)"]
[{"$f":"IF('DLTR Template'!$B15=\"\",\"\",'DLTR Template'!$B15)","v":""},{"$f":"'DLTR Template'!$K15","v":""},{"$f":"'DLTR Template'!J15","v":0},{"$f":"C7/B7","v":{"$error":"#VALUE!"}},{"$f":"IF('DLTR Template'!H15=\"\",\"\",'DLTR Template'!H15)","v":""},{"$f":"IF('DLTR Template'!I15=\"\",\"\",'DLTR Template'!I15)","v":""},{"$f":"IF('DLTR Template'!D15=\"\",\"\",'DLTR Template'!D15)","v":""},{"$f":"IFERROR(IF(($B$3-$C7)>0,$C7,$B$3),\"\")","v":0},{"$f":"IFERROR(H7/$D7,\"\")","v":""},{"$f":"IF(U7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(U7=\"\",\"\",$A7)","v":""},{"$f":"IF(J7=\"\",\"\",$G7)","v":""},{"$f":"IF(W7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(W7=\"\",\"\",$A7)","v":""},{"$f":"IF(M7=\"\",\"\",$G7)","v":""},{"$f":"IF(Y7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(Y7=\"\",\"\",$A7)","v":""},{"$f":"IF(P7=\"\",\"\",$G7)","v":""},{"$f":"E7","v":""},{"$f":"IF(S7=\"\",\"\",IF($F7>$E7,S7+I7,S7-I7))","v":""},{"$f":"IF($B$23>SUM(H$7:H7),\"\",IF($F7>$E7,S7+$B$23,S7-$B$23))","v":""},{"$f":"IFERROR(((U7-$S7)*(1/$D7))+$S7,\"\")","v":""},{"$f":"IF($B$24>SUM(H$7:H7),\"\",IF($F7>$E7,S7+$B$24,S7-$B$24))","v":""},{"$f":"IFERROR(((W7-$S7)*(1/$D7))+$S7,\"\")","v":""},{"$f":"IF($B$25>SUM(H$7:H7),\"\",IF($F7>$E7,S7+$B$25,S7-$B$25))","v":""},{"$f":"IFERROR(((Y7-$S7)*(1/$D7))+$S7,\"\")","v":""},{"$f":"IFERROR(IF($C7=H7,0,IF(($B$3+H7)>$C7,$C7-H7,$B$3)),\"\")","v":0},{"$f":"IFERROR(AA7/$D7,\"\")","v":""},{"$f":"IF(AN7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(AN7=\"\",\"\",$A7)","v":""},{"$f":"IF(AC7=\"\",\"\",$G7)","v":""},{"$f":"IF(AP7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(AP7=\"\",\"\",$A7)","v":""},{"$f":"IF(AF7=\"\",\"\",$G7)","v":""},{"$f":"IF(AR7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(AR7=\"\",\"\",$A7)","v":""},{"$f":"IF(AI7=\"\",\"\",$G7)","v":""},{"$f":"IF(AA7=0,\"\",IF(T7=\"\",$E7,T7))","v":""},{"$f":"IF(AL7=\"\",\"\",IF($F7>$E7,AL7+AB7,AL7-AB7))","v":""},{"$f":"IF($B$23>SUM(AA$7:AA7),\"\",IF($F7>$E7,AL7+$B$23,AL7-$B$23))","v":""},{"$f":"IFERROR(((AN7-$AL7)*(1/$D7))+$AL7,\"\")","v":""},{"$f":"IF($B$24>SUM(AA$7:AA7),\"\",IF($F7>$E7,AL7+$B$24,AL7-$B$24))","v":""},{"$f":"IFERROR(((AP7-$AL7)*(1/$D7))+$AL7,\"\")","v":""},{"$f":"IF($B$25>SUM(AA$7:AA7),\"\",IF($F7>$E7,AL7+$B$25,AL7-$B$25))","v":""},{"$f":"IFERROR(((AR7-$AL7)*(1/$D7))+$AL7,\"\")","v":""},{"$f":"IFERROR(IF($C7=(H7+AA7),0,IF(($B$3+(H7+AA7))>$C7,$C7-(H7+AA7),$B$3)),\"\")","v":0},{"$f":"IFERROR(AT7/$D7,\"\")","v":""},{"$f":"IF(BG7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(BG7=\"\",\"\",$A7)","v":""},{"$f":"IF(AV7=\"\",\"\",$G7)","v":""},{"$f":"IF(BI7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(BI7=\"\",\"\",$A7)","v":""},{"$f":"IF(AY7=\"\",\"\",$G7)","v":""},{"$f":"IF(BK7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(BK7=\"\",\"\",$A7)","v":""},{"$f":"IF(BB7=\"\",\"\",$G7)","v":""},{"$f":"IF(AT7=0,\"\",IF(AM7=\"\",$E7,AM7))","v":""},{"$f":"IF(BE7=\"\",\"\",IF($F7>$E7,BE7+AU7,BE7-AU7))","v":""},{"$f":"IF($B$23>SUM(AT$7:AT7),\"\",IF($F7>$E7,BE7+$B$23,BE7-$B$23))","v":""},{"$f":"IFERROR(((BG7-$BE7)*(1/$D7))+$BE7,\"\")","v":""},{"$f":"IF($B$24>SUM(AT$7:AT7),\"\",IF($F7>$E7,BE7+$B$24,BE7-$B$24))","v":""},{"$f":"IFERROR(((BI7-$BE7)*(1/$D7))+$BE7,\"\")","v":""},{"$f":"IF($B$25>SUM(AT$7:AT7),\"\",IF($F7>$E7,BE7+$B$25,BE7-$B$25))","v":""},{"$f":"IFERROR(((BK7-$BE7)*(1/$D7))+$BE7,\"\")","v":""},{"$f":"IFERROR(IF($C7=(H7+AA7+AT7),0,IF(($B$3+(H7+AA7+AT7))>$C7,$C7-(H7+AA7+AT7),$B$3)),\"\")","v":0},{"$f":"IFERROR(BM7/$D7,\"\")","v":""},{"$f":"IF(BZ7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(BZ7=\"\",\"\",$A7)","v":""},{"$f":"IF(BO7=\"\",\"\",$G7)","v":""},{"$f":"IF(CB7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CB7=\"\",\"\",$A7)","v":""},{"$f":"IF(BR7=\"\",\"\",$G7)","v":""},{"$f":"IF(CD7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CD7=\"\",\"\",$A7)","v":""},{"$f":"IF(BU7=\"\",\"\",$G7)","v":""},{"$f":"IF(BM7=0,\"\",IF(BF7=\"\",$E7,BF7))","v":""},{"$f":"IF(BX7=\"\",\"\",IF($F7>$E7,BX7+BN7,BX7-BN7))","v":""},{"$f":"IF($B$23>SUM(BM$7:BM7),\"\",IF($F7>$E7,BX7+$B$23,BX7-$B$23))","v":""},{"$f":"IFERROR(((BZ7-$BX7)*(1/$D7))+$BX7,\"\")","v":""},{"$f":"IF($B$24>SUM(BM$7:BM7),\"\",IF($F7>$E7,BX7+$B$24,BX7-$B$24))","v":""},{"$f":"IFERROR(((CB7-$BX7)*(1/$D7))+$BX7,\"\")","v":""},{"$f":"IF($B$25>SUM(BM$7:BM7),\"\",IF($F7>$E7,BX7+$B$25,BX7-$B$25))","v":""},{"$f":"IFERROR(((CD7-$BX7)*(1/$D7))+$BX7,\"\")","v":""},{"$f":"IFERROR(IF($C7=(H7+AA7+AT7+BM7),0,IF(($B$3+(H7+AA7+AT7+BM7))>$C7,$C7-(H7+AA7+AT7+BM7),$B$3)),\"\")","v":0},{"$f":"IFERROR(CF7/$D7,\"\")","v":""},{"$f":"IF(CS7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CS7=\"\",\"\",$A7)","v":""},{"$f":"IF(CH7=\"\",\"\",$G7)","v":""},{"$f":"IF(CU7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CU7=\"\",\"\",$A7)","v":""},{"$f":"IF(CK7=\"\",\"\",$G7)","v":""},{"$f":"IF(CW7=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CW7=\"\",\"\",$A7)","v":""},{"$f":"IF(CN7=\"\",\"\",$G7)","v":""},{"$f":"IF(CF7=0,\"\",IF(BY7=\"\",$E7,BY7))","v":""},{"$f":"IF(CQ7=\"\",\"\",IF($F7>$E7,CQ7+CG7,CQ7-CG7))","v":""},{"$f":"IF($B$23>SUM(CF$7:CF7),\"\",IF($F7>$E7,CQ7+$B$23,CQ7-$B$23))","v":""},{"$f":"IFERROR(((CS7-$CQ7)*(1/$D7))+$CQ7,\"\")","v":""},{"$f":"IF($B$24>SUM(CF$7:CF7),\"\",IF($F7>$E7,CQ7+$B$24,CQ7-$B$24))","v":""},{"$f":"IFERROR(((CU7-$CQ7)*(1/$D7))+$CQ7,\"\")","v":""},{"$f":"IF($B$25>SUM(CF$7:CF7),\"\",IF($F7>$E7,CQ7+$B$25,CQ7-$B$25))","v":""},{"$f":"IFERROR(((CW7-$CQ7)*(1/$D7))+$CQ7,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B16=\"\",\"\",'DLTR Template'!$B16)","v":""},{"$f":"'DLTR Template'!$K16","v":""},{"$f":"'DLTR Template'!J16","v":0},{"$f":"C8/B8","v":{"$error":"#VALUE!"}},{"$f":"IF('DLTR Template'!H16=\"\",\"\",'DLTR Template'!H16)","v":""},{"$f":"IF('DLTR Template'!I16=\"\",\"\",'DLTR Template'!I16)","v":""},{"$f":"IF('DLTR Template'!D16=\"\",\"\",'DLTR Template'!D16)","v":""},{"$f":"IFERROR(IF(($B$3-$C8-SUM(H$7:H7))>0,$C8,$B$3-SUM(H$7:H7)),\"\")","v":0},{"$f":"IFERROR(H8/$D8,\"\")","v":""},{"$f":"IF(U8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(U8=\"\",\"\",$A8)","v":""},{"$f":"IF(J8=\"\",\"\",$G8)","v":""},{"$f":"IF(W8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(W8=\"\",\"\",$A8)","v":""},{"$f":"IF(M8=\"\",\"\",$G8)","v":""},{"$f":"IF(Y8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(Y8=\"\",\"\",$A8)","v":""},{"$f":"IF(P8=\"\",\"\",$G8)","v":""},{"$f":"IF(H8=0,\"\",$E8)","v":""},{"$f":"IF(S8=\"\",\"\",IF($F8>$E8,S8+I8,S8-I8))","v":""},{"$f":"IF(SUM(U$7:U7)>0,\"\",IF($B$23>SUM(H$7:H8),\"\",IF($F8>$E8,(S8+($B$23-SUM(H$7:H7))),(S8-($B$23-SUM(H$7:H7))))))","v":""},{"$f":"IFERROR(((U8-$S8)*(1/$D8))+$S8,\"\")","v":""},{"$f":"IF(SUM(W$7:W7)>0,\"\",IF($B$24>SUM(H$7:H8),\"\",IF($F8>$E8,(S8+($B$24-SUM(H$7:H7))),(S8-($B$24-SUM(H$7:H7))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y7)>0,\"\",IF($B$25>SUM(H$7:H8),\"\",IF($F8>$E8,(S8+($B$25-SUM(H$7:H7))),(S8-($B$25-SUM(H$7:H7))))))","v":""},{"$f":"IFERROR(((Y8-$S8)*(1/$D8))+$S8,\"\")","v":""},{"$f":"IFERROR(IF($C8=SUM($H8:H8),0,IF(($C8-SUM($H8:H8))>($B$3-SUM(AA$7:AA7)),($B$3-SUM(AA$7:AA7)),($C8-SUM($H8:H8)))),\"\")","v":0},{"$f":"IFERROR(AA8/$D8,\"\")","v":""},"","",{"$f":"IF(AC8=\"\",\"\",$G8)","v":""},{"$f":"IF(AP8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(AP8=\"\",\"\",$A8)","v":""},{"$f":"IF(AF8=\"\",\"\",$G8)","v":""},{"$f":"IF(AR8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(AR8=\"\",\"\",$A8)","v":""},{"$f":"IF(AI8=\"\",\"\",$G8)","v":""},{"$f":"IF(AA8=0,\"\",IF(T8=\"\",$E8,T8))","v":""},{"$f":"IF(AL8=\"\",\"\",IF($F8>$E8,AL8+AB8,AL8-AB8))","v":""},{"$f":"IF(SUM(AN$7:AN7)>0,\"\",IF($B$23>SUM(AA$7:AA8),\"\",IF($F8>$E8,(AL8+($B$23-SUM(AA$7:AA7))),(AL8-($B$23-SUM(AA$7:AA7))))))","v":""},{"$f":"IFERROR(((AN8-$AL8)*(1/$D8))+$AL8,\"\")","v":""},{"$f":"IF(SUM(AP$7:AP7)>0,\"\",IF($B$24>SUM(AA$7:AA8),\"\",IF($F8>$E8,(AL8+($B$24-SUM(AA$7:AA7))),(AL8-($B$24-SUM(AA$7:AA7))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR7)>0,\"\",IF($B$25>SUM(AA$7:AA8),\"\",IF($F8>$E8,(AL8+($B$25-SUM(AA$7:AA7))),(AL8-($B$25-SUM(AA$7:AA7))))))","v":""},{"$f":"IFERROR(((AR8-$AL8)*(1/$D8))+$AL8,\"\")","v":""},{"$f":"IFERROR(IF($C8=SUM($H8+AA8),0,IF(($C8-SUM($H8+AA8))>($B$3-SUM(AT$7:AT7)),($B$3-SUM(AT$7:AT7)),($C8-SUM($H8+AA8)))),\"\")","v":0},{"$f":"IFERROR(AT8/$D8,\"\")","v":""},"","",{"$f":"IF(AV8=\"\",\"\",$G8)","v":""},{"$f":"IF(BI8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(BI8=\"\",\"\",$A8)","v":""},{"$f":"IF(AY8=\"\",\"\",$G8)","v":""},{"$f":"IF(BK8=\"\",\"\",\"Yes\")","v":""},"",{"$f":"IF(BB8=\"\",\"\",$G8)","v":""},"",{"$f":"IF(BE8=\"\",\"\",IF($F8>$E8,BE8+AU8,BE8-AU8))","v":""},{"$f":"IF(SUM(BG$7:BG7)>0,\"\",IF($B$23>SUM(AT$7:AT8),\"\",IF($F8>$E8,(BE8+($B$23-SUM(AT$7:AT7))),(BE8-($B$23-SUM(AT$7:AT7))))))","v":""},{"$f":"IFERROR(((BG8-$BE8)*(1/$D8))+$BE8,\"\")","v":""},{"$f":"IF(SUM(BI$7:BI7)>0,\"\",IF($B$24>SUM(AT$7:AT8),\"\",IF($F8>$E8,(BE8+($B$24-SUM(AT$7:AT7))),(BE8-($B$24-SUM(AT$7:AT7))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK7)>0,\"\",IF($B$25>SUM(AT$7:AT8),\"\",IF($F8>$E8,(BE8+($B$25-SUM(AT$7:AT7))),(BE8-($B$25-SUM(AT$7:AT7))))))","v":""},{"$f":"IFERROR(((BK8-$BE8)*(1/$D8))+$BE8,\"\")","v":""},{"$f":"IFERROR(IF($C8=SUM($H8+AA8+AT8),0,IF(($C8-SUM($H8+AA8+AT8))>($B$3-SUM(BM$7:BM7)),($B$3-SUM(BM$7:BM7)),($C8-SUM($H8+AA8+AT8)))),\"\")","v":0},{"$f":"IFERROR(BM8/$D8,\"\")","v":""},"","",{"$f":"IF(BO8=\"\",\"\",$G8)","v":""},{"$f":"IF(CB8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CB8=\"\",\"\",$A8)","v":""},{"$f":"IF(BR8=\"\",\"\",$G8)","v":""},{"$f":"IF(CD8=\"\",\"\",\"Yes\")","v":""},"",{"$f":"IF(BU8=\"\",\"\",$G8)","v":""},"",{"$f":"IF(BX8=\"\",\"\",IF($F8>$E8,BX8+BN8,BX8-BN8))","v":""},{"$f":"IF(SUM(BZ$7:BZ7)>0,\"\",IF($B$23>SUM(BM$7:BM8),\"\",IF($F8>$E8,(BX8+($B$23-SUM(BM$7:BM7))),(BX8-($B$23-SUM(BM$7:BM7))))))","v":""},{"$f":"IFERROR(((BZ8-$BX8)*(1/$D8))+$BX8,\"\")","v":""},{"$f":"IF(SUM(CB$7:CB7)>0,\"\",IF($B$24>SUM(BM$7:BM8),\"\",IF($F8>$E8,(BX8+($B$24-SUM(BM$7:BM7))),(BX8-($B$24-SUM(BM$7:BM7))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD7)>0,\"\",IF($B$25>SUM(BM$7:BM8),\"\",IF($F8>$E8,(BX8+($B$25-SUM(BM$7:BM7))),(BX8-($B$25-SUM(BM$7:BM7))))))","v":""},{"$f":"IFERROR(((CD8-$BX8)*(1/$D8))+$BX8,\"\")","v":""},{"$f":"IFERROR(IF($C8=SUM($H8+AA8+AT8+BM8),0,IF(($C8-SUM($H8+AA8+AT8+BM8))>($B$3-SUM(CF$7:CF7)),($B$3-SUM(CF$7:CF7)),($C8-SUM($H8+AA8+AT8+BM8)))),\"\")","v":0},{"$f":"IFERROR(CF8/$D8,\"\")","v":""},"","",{"$f":"IF(CH8=\"\",\"\",$G8)","v":""},{"$f":"IF(CU8=\"\",\"\",\"Yes\")","v":""},{"$f":"IF(CU8=\"\",\"\",$A8)","v":""},{"$f":"IF(CK8=\"\",\"\",$G8)","v":""},{"$f":"IF(CW8=\"\",\"\",\"Yes\")","v":""},"",{"$f":"IF(CN8=\"\",\"\",$G8)","v":""},"",{"$f":"IF(CQ8=\"\",\"\",IF($F8>$E8,CQ8+CG8,CQ8-CG8))","v":""},{"$f":"IF(SUM(CS$7:CS7)>0,\"\",IF($B$23>SUM(CF$7:CF8),\"\",IF($F8>$E8,(CQ8+($B$23-SUM(CF$7:CF7))),(CQ8-($B$23-SUM(CF$7:CF7))))))","v":""},{"$f":"IFERROR(((CS8-$CQ8)*(1/$D8))+$CQ8,\"\")","v":""},{"$f":"IF(SUM(CU$7:CU7)>0,\"\",IF($B$24>SUM(CF$7:CF8),\"\",IF($F8>$E8,(CQ8+($B$24-SUM(CF$7:CF7))),(CQ8-($B$24-SUM(CF$7:CF7))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW7)>0,\"\",IF($B$25>SUM(CF$7:CF8),\"\",IF($F8>$E8,(CQ8+($B$25-SUM(CF$7:CF7))),(CQ8-($B$25-SUM(CF$7:CF7))))))","v":""},{"$f":"IFERROR(((CW8-$CQ8)*(1/$D8))+$CQ8,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B17=\"\",\"\",'DLTR Template'!$B17)","v":""},{"$f":"'DLTR Template'!$K17","v":""},{"$f":"'DLTR Template'!J17","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H17=\"\",\"\",'DLTR Template'!H17)","v":""},{"$f":"IF('DLTR Template'!I17=\"\",\"\",'DLTR Template'!I17)","v":""},{"$f":"IF('DLTR Template'!D17=\"\",\"\",'DLTR Template'!D17)","v":""},{"$f":"IFERROR(IF(($B$3-$C9-SUM(H$7:H8))>0,$C9,$B$3-SUM(H$7:H8)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U8)>0,\"\",IF($B$23>SUM(H$7:H9),\"\",IF($F9>$E9,(S9+($B$23-SUM(H$7:H8))),(S9-($B$23-SUM(H$7:H8))))))","v":""},"",{"$f":"IF(SUM(W$7:W8)>0,\"\",IF($B$24>SUM(H$7:H9),\"\",IF($F9>$E9,(S9+($B$24-SUM(H$7:H8))),(S9-($B$24-SUM(H$7:H8))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y8)>0,\"\",IF($B$25>SUM(H$7:H9),\"\",IF($F9>$E9,(S9+($B$25-SUM(H$7:H8))),(S9-($B$25-SUM(H$7:H8))))))","v":""},{"$f":"IFERROR(((Y9-$S9)*(1/$D9))+$S9,\"\")","v":""},{"$f":"IFERROR(IF($C9=SUM($H9:H9),0,IF(($C9-SUM($H9:H9))>($B$3-SUM(AA$7:AA8)),($B$3-SUM(AA$7:AA8)),($C9-SUM($H9:H9)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN8)>0,\"\",IF($B$23>SUM(AA$7:AA9),\"\",IF($F9>$E9,(AL9+($B$23-SUM(AA$7:AA8))),(AL9-($B$23-SUM(AA$7:AA8))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP8)>0,\"\",IF($B$24>SUM(AA$7:AA9),\"\",IF($F9>$E9,(AL9+($B$24-SUM(AA$7:AA8))),(AL9-($B$24-SUM(AA$7:AA8))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR8)>0,\"\",IF($B$25>SUM(AA$7:AA9),\"\",IF($F9>$E9,(AL9+($B$25-SUM(AA$7:AA8))),(AL9-($B$25-SUM(AA$7:AA8))))))","v":""},{"$f":"IFERROR(((AR9-$AL9)*(1/$D9))+$AL9,\"\")","v":""},{"$f":"IFERROR(IF($C9=SUM($H9+AA9),0,IF(($C9-SUM($H9+AA9))>($B$3-SUM(AT$7:AT8)),($B$3-SUM(AT$7:AT8)),($C9-SUM($H9+AA9)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG8)>0,\"\",IF($B$23>SUM(AT$7:AT9),\"\",IF($F9>$E9,(BE9+($B$23-SUM(AT$7:AT8))),(BE9-($B$23-SUM(AT$7:AT8))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI8)>0,\"\",IF($B$24>SUM(AT$7:AT9),\"\",IF($F9>$E9,(BE9+($B$24-SUM(AT$7:AT8))),(BE9-($B$24-SUM(AT$7:AT8))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK8)>0,\"\",IF($B$25>SUM(AT$7:AT9),\"\",IF($F9>$E9,(BE9+($B$25-SUM(AT$7:AT8))),(BE9-($B$25-SUM(AT$7:AT8))))))","v":""},{"$f":"IFERROR(((BK9-$BE9)*(1/$D9))+$BE9,\"\")","v":""},{"$f":"IFERROR(IF($C9=SUM($H9+AA9+AT9),0,IF(($C9-SUM($H9+AA9+AT9))>($B$3-SUM(BM$7:BM8)),($B$3-SUM(BM$7:BM8)),($C9-SUM($H9+AA9+AT9)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ8)>0,\"\",IF($B$23>SUM(BM$7:BM9),\"\",IF($F9>$E9,(BX9+($B$23-SUM(BM$7:BM8))),(BX9-($B$23-SUM(BM$7:BM8))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB8)>0,\"\",IF($B$24>SUM(BM$7:BM9),\"\",IF($F9>$E9,(BX9+($B$24-SUM(BM$7:BM8))),(BX9-($B$24-SUM(BM$7:BM8))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD8)>0,\"\",IF($B$25>SUM(BM$7:BM9),\"\",IF($F9>$E9,(BX9+($B$25-SUM(BM$7:BM8))),(BX9-($B$25-SUM(BM$7:BM8))))))","v":""},{"$f":"IFERROR(((CD9-$BX9)*(1/$D9))+$BX9,\"\")","v":""},{"$f":"IFERROR(IF($C9=SUM($H9+AA9+AT9+BM9),0,IF(($C9-SUM($H9+AA9+AT9+BM9))>($B$3-SUM(CF$7:CF8)),($B$3-SUM(CF$7:CF8)),($C9-SUM($H9+AA9+AT9+BM9)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS8)>0,\"\",IF($B$23>SUM(CF$7:CF9),\"\",IF($F9>$E9,(CQ9+($B$23-SUM(CF$7:CF8))),(CQ9-($B$23-SUM(CF$7:CF8))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU8)>0,\"\",IF($B$24>SUM(CF$7:CF9),\"\",IF($F9>$E9,(CQ9+($B$24-SUM(CF$7:CF8))),(CQ9-($B$24-SUM(CF$7:CF8))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW8)>0,\"\",IF($B$25>SUM(CF$7:CF9),\"\",IF($F9>$E9,(CQ9+($B$25-SUM(CF$7:CF8))),(CQ9-($B$25-SUM(CF$7:CF8))))))","v":""},{"$f":"IFERROR(((CW9-$CQ9)*(1/$D9))+$CQ9,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B18=\"\",\"\",'DLTR Template'!$B18)","v":""},{"$f":"'DLTR Template'!$K18","v":""},{"$f":"'DLTR Template'!J18","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H18=\"\",\"\",'DLTR Template'!H18)","v":""},{"$f":"IF('DLTR Template'!I18=\"\",\"\",'DLTR Template'!I18)","v":""},{"$f":"IF('DLTR Template'!D18=\"\",\"\",'DLTR Template'!D18)","v":""},{"$f":"IFERROR(IF(($B$3-$C10-SUM(H$7:H9))>0,$C10,$B$3-SUM(H$7:H9)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U9)>0,\"\",IF($B$23>SUM(H$7:H10),\"\",IF($F10>$E10,(S10+($B$23-SUM(H$7:H9))),(S10-($B$23-SUM(H$7:H9))))))","v":""},"",{"$f":"IF(SUM(W$7:W9)>0,\"\",IF($B$24>SUM(H$7:H10),\"\",IF($F10>$E10,(S10+($B$24-SUM(H$7:H9))),(S10-($B$24-SUM(H$7:H9))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y9)>0,\"\",IF($B$25>SUM(H$7:H10),\"\",IF($F10>$E10,(S10+($B$25-SUM(H$7:H9))),(S10-($B$25-SUM(H$7:H9))))))","v":""},{"$f":"IFERROR(((Y10-$S10)*(1/$D10))+$S10,\"\")","v":""},{"$f":"IFERROR(IF($C10=SUM($H10:H10),0,IF(($C10-SUM($H10:H10))>($B$3-SUM(AA$7:AA9)),($B$3-SUM(AA$7:AA9)),($C10-SUM($H10:H10)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN9)>0,\"\",IF($B$23>SUM(AA$7:AA10),\"\",IF($F10>$E10,(AL10+($B$23-SUM(AA$7:AA9))),(AL10-($B$23-SUM(AA$7:AA9))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP9)>0,\"\",IF($B$24>SUM(AA$7:AA10),\"\",IF($F10>$E10,(AL10+($B$24-SUM(AA$7:AA9))),(AL10-($B$24-SUM(AA$7:AA9))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR9)>0,\"\",IF($B$25>SUM(AA$7:AA10),\"\",IF($F10>$E10,(AL10+($B$25-SUM(AA$7:AA9))),(AL10-($B$25-SUM(AA$7:AA9))))))","v":""},{"$f":"IFERROR(((AR10-$AL10)*(1/$D10))+$AL10,\"\")","v":""},{"$f":"IFERROR(IF($C10=SUM($H10+AA10),0,IF(($C10-SUM($H10+AA10))>($B$3-SUM(AT$7:AT9)),($B$3-SUM(AT$7:AT9)),($C10-SUM($H10+AA10)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG9)>0,\"\",IF($B$23>SUM(AT$7:AT10),\"\",IF($F10>$E10,(BE10+($B$23-SUM(AT$7:AT9))),(BE10-($B$23-SUM(AT$7:AT9))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI9)>0,\"\",IF($B$24>SUM(AT$7:AT10),\"\",IF($F10>$E10,(BE10+($B$24-SUM(AT$7:AT9))),(BE10-($B$24-SUM(AT$7:AT9))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK9)>0,\"\",IF($B$25>SUM(AT$7:AT10),\"\",IF($F10>$E10,(BE10+($B$25-SUM(AT$7:AT9))),(BE10-($B$25-SUM(AT$7:AT9))))))","v":""},{"$f":"IFERROR(((BK10-$BE10)*(1/$D10))+$BE10,\"\")","v":""},{"$f":"IFERROR(IF($C10=SUM($H10+AA10+AT10),0,IF(($C10-SUM($H10+AA10+AT10))>($B$3-SUM(BM$7:BM9)),($B$3-SUM(BM$7:BM9)),($C10-SUM($H10+AA10+AT10)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ9)>0,\"\",IF($B$23>SUM(BM$7:BM10),\"\",IF($F10>$E10,(BX10+($B$23-SUM(BM$7:BM9))),(BX10-($B$23-SUM(BM$7:BM9))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB9)>0,\"\",IF($B$24>SUM(BM$7:BM10),\"\",IF($F10>$E10,(BX10+($B$24-SUM(BM$7:BM9))),(BX10-($B$24-SUM(BM$7:BM9))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD9)>0,\"\",IF($B$25>SUM(BM$7:BM10),\"\",IF($F10>$E10,(BX10+($B$25-SUM(BM$7:BM9))),(BX10-($B$25-SUM(BM$7:BM9))))))","v":""},{"$f":"IFERROR(((CD10-$BX10)*(1/$D10))+$BX10,\"\")","v":""},{"$f":"IFERROR(IF($C10=SUM($H10+AA10+AT10+BM10),0,IF(($C10-SUM($H10+AA10+AT10+BM10))>($B$3-SUM(CF$7:CF9)),($B$3-SUM(CF$7:CF9)),($C10-SUM($H10+AA10+AT10+BM10)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS9)>0,\"\",IF($B$23>SUM(CF$7:CF10),\"\",IF($F10>$E10,(CQ10+($B$23-SUM(CF$7:CF9))),(CQ10-($B$23-SUM(CF$7:CF9))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU9)>0,\"\",IF($B$24>SUM(CF$7:CF10),\"\",IF($F10>$E10,(CQ10+($B$24-SUM(CF$7:CF9))),(CQ10-($B$24-SUM(CF$7:CF9))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW9)>0,\"\",IF($B$25>SUM(CF$7:CF10),\"\",IF($F10>$E10,(CQ10+($B$25-SUM(CF$7:CF9))),(CQ10-($B$25-SUM(CF$7:CF9))))))","v":""},{"$f":"IFERROR(((CW10-$CQ10)*(1/$D10))+$CQ10,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B19=\"\",\"\",'DLTR Template'!$B19)","v":""},{"$f":"'DLTR Template'!$K19","v":""},{"$f":"'DLTR Template'!J19","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H19=\"\",\"\",'DLTR Template'!H19)","v":""},{"$f":"IF('DLTR Template'!I19=\"\",\"\",'DLTR Template'!I19)","v":""},{"$f":"IF('DLTR Template'!D19=\"\",\"\",'DLTR Template'!D19)","v":""},{"$f":"IFERROR(IF(($B$3-$C11-SUM(H$7:H10))>0,$C11,$B$3-SUM(H$7:H10)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U10)>0,\"\",IF($B$23>SUM(H$7:H11),\"\",IF($F11>$E11,(S11+($B$23-SUM(H$7:H10))),(S11-($B$23-SUM(H$7:H10))))))","v":""},"",{"$f":"IF(SUM(W$7:W10)>0,\"\",IF($B$24>SUM(H$7:H11),\"\",IF($F11>$E11,(S11+($B$24-SUM(H$7:H10))),(S11-($B$24-SUM(H$7:H10))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y10)>0,\"\",IF($B$25>SUM(H$7:H11),\"\",IF($F11>$E11,(S11+($B$25-SUM(H$7:H10))),(S11-($B$25-SUM(H$7:H10))))))","v":""},{"$f":"IFERROR(((Y11-$S11)*(1/$D11))+$S11,\"\")","v":""},{"$f":"IFERROR(IF($C11=SUM($H11:H11),0,IF(($C11-SUM($H11:H11))>($B$3-SUM(AA$7:AA10)),($B$3-SUM(AA$7:AA10)),($C11-SUM($H11:H11)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN10)>0,\"\",IF($B$23>SUM(AA$7:AA11),\"\",IF($F11>$E11,(AL11+($B$23-SUM(AA$7:AA10))),(AL11-($B$23-SUM(AA$7:AA10))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP10)>0,\"\",IF($B$24>SUM(AA$7:AA11),\"\",IF($F11>$E11,(AL11+($B$24-SUM(AA$7:AA10))),(AL11-($B$24-SUM(AA$7:AA10))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR10)>0,\"\",IF($B$25>SUM(AA$7:AA11),\"\",IF($F11>$E11,(AL11+($B$25-SUM(AA$7:AA10))),(AL11-($B$25-SUM(AA$7:AA10))))))","v":""},{"$f":"IFERROR(((AR11-$AL11)*(1/$D11))+$AL11,\"\")","v":""},{"$f":"IFERROR(IF($C11=SUM($H11+AA11),0,IF(($C11-SUM($H11+AA11))>($B$3-SUM(AT$7:AT10)),($B$3-SUM(AT$7:AT10)),($C11-SUM($H11+AA11)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG10)>0,\"\",IF($B$23>SUM(AT$7:AT11),\"\",IF($F11>$E11,(BE11+($B$23-SUM(AT$7:AT10))),(BE11-($B$23-SUM(AT$7:AT10))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI10)>0,\"\",IF($B$24>SUM(AT$7:AT11),\"\",IF($F11>$E11,(BE11+($B$24-SUM(AT$7:AT10))),(BE11-($B$24-SUM(AT$7:AT10))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK10)>0,\"\",IF($B$25>SUM(AT$7:AT11),\"\",IF($F11>$E11,(BE11+($B$25-SUM(AT$7:AT10))),(BE11-($B$25-SUM(AT$7:AT10))))))","v":""},{"$f":"IFERROR(((BK11-$BE11)*(1/$D11))+$BE11,\"\")","v":""},{"$f":"IFERROR(IF($C11=SUM($H11+AA11+AT11),0,IF(($C11-SUM($H11+AA11+AT11))>($B$3-SUM(BM$7:BM10)),($B$3-SUM(BM$7:BM10)),($C11-SUM($H11+AA11+AT11)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ10)>0,\"\",IF($B$23>SUM(BM$7:BM11),\"\",IF($F11>$E11,(BX11+($B$23-SUM(BM$7:BM10))),(BX11-($B$23-SUM(BM$7:BM10))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB10)>0,\"\",IF($B$24>SUM(BM$7:BM11),\"\",IF($F11>$E11,(BX11+($B$24-SUM(BM$7:BM10))),(BX11-($B$24-SUM(BM$7:BM10))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD10)>0,\"\",IF($B$25>SUM(BM$7:BM11),\"\",IF($F11>$E11,(BX11+($B$25-SUM(BM$7:BM10))),(BX11-($B$25-SUM(BM$7:BM10))))))","v":""},{"$f":"IFERROR(((CD11-$BX11)*(1/$D11))+$BX11,\"\")","v":""},{"$f":"IFERROR(IF($C11=SUM($H11+AA11+AT11+BM11),0,IF(($C11-SUM($H11+AA11+AT11+BM11))>($B$3-SUM(CF$7:CF10)),($B$3-SUM(CF$7:CF10)),($C11-SUM($H11+AA11+AT11+BM11)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS10)>0,\"\",IF($B$23>SUM(CF$7:CF11),\"\",IF($F11>$E11,(CQ11+($B$23-SUM(CF$7:CF10))),(CQ11-($B$23-SUM(CF$7:CF10))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU10)>0,\"\",IF($B$24>SUM(CF$7:CF11),\"\",IF($F11>$E11,(CQ11+($B$24-SUM(CF$7:CF10))),(CQ11-($B$24-SUM(CF$7:CF10))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW10)>0,\"\",IF($B$25>SUM(CF$7:CF11),\"\",IF($F11>$E11,(CQ11+($B$25-SUM(CF$7:CF10))),(CQ11-($B$25-SUM(CF$7:CF10))))))","v":""},{"$f":"IFERROR(((CW11-$CQ11)*(1/$D11))+$CQ11,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B20=\"\",\"\",'DLTR Template'!$B20)","v":""},{"$f":"'DLTR Template'!$K20","v":""},{"$f":"'DLTR Template'!J20","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H20=\"\",\"\",'DLTR Template'!H20)","v":""},{"$f":"IF('DLTR Template'!I20=\"\",\"\",'DLTR Template'!I20)","v":""},{"$f":"IF('DLTR Template'!D20=\"\",\"\",'DLTR Template'!D20)","v":""},{"$f":"IFERROR(IF(($B$3-$C12-SUM(H$7:H11))>0,$C12,$B$3-SUM(H$7:H11)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U11)>0,\"\",IF($B$23>SUM(H$7:H12),\"\",IF($F12>$E12,(S12+($B$23-SUM(H$7:H11))),(S12-($B$23-SUM(H$7:H11))))))","v":""},"",{"$f":"IF(SUM(W$7:W11)>0,\"\",IF($B$24>SUM(H$7:H12),\"\",IF($F12>$E12,(S12+($B$24-SUM(H$7:H11))),(S12-($B$24-SUM(H$7:H11))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y11)>0,\"\",IF($B$25>SUM(H$7:H12),\"\",IF($F12>$E12,(S12+($B$25-SUM(H$7:H11))),(S12-($B$25-SUM(H$7:H11))))))","v":""},{"$f":"IFERROR(((Y12-$S12)*(1/$D12))+$S12,\"\")","v":""},{"$f":"IFERROR(IF($C12=SUM($H12:H12),0,IF(($C12-SUM($H12:H12))>($B$3-SUM(AA$7:AA11)),($B$3-SUM(AA$7:AA11)),($C12-SUM($H12:H12)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN11)>0,\"\",IF($B$23>SUM(AA$7:AA12),\"\",IF($F12>$E12,(AL12+($B$23-SUM(AA$7:AA11))),(AL12-($B$23-SUM(AA$7:AA11))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP11)>0,\"\",IF($B$24>SUM(AA$7:AA12),\"\",IF($F12>$E12,(AL12+($B$24-SUM(AA$7:AA11))),(AL12-($B$24-SUM(AA$7:AA11))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR11)>0,\"\",IF($B$25>SUM(AA$7:AA12),\"\",IF($F12>$E12,(AL12+($B$25-SUM(AA$7:AA11))),(AL12-($B$25-SUM(AA$7:AA11))))))","v":""},{"$f":"IFERROR(((AR12-$AL12)*(1/$D12))+$AL12,\"\")","v":""},{"$f":"IFERROR(IF($C12=SUM($H12+AA12),0,IF(($C12-SUM($H12+AA12))>($B$3-SUM(AT$7:AT11)),($B$3-SUM(AT$7:AT11)),($C12-SUM($H12+AA12)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG11)>0,\"\",IF($B$23>SUM(AT$7:AT12),\"\",IF($F12>$E12,(BE12+($B$23-SUM(AT$7:AT11))),(BE12-($B$23-SUM(AT$7:AT11))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI11)>0,\"\",IF($B$24>SUM(AT$7:AT12),\"\",IF($F12>$E12,(BE12+($B$24-SUM(AT$7:AT11))),(BE12-($B$24-SUM(AT$7:AT11))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK11)>0,\"\",IF($B$25>SUM(AT$7:AT12),\"\",IF($F12>$E12,(BE12+($B$25-SUM(AT$7:AT11))),(BE12-($B$25-SUM(AT$7:AT11))))))","v":""},{"$f":"IFERROR(((BK12-$BE12)*(1/$D12))+$BE12,\"\")","v":""},{"$f":"IFERROR(IF($C12=SUM($H12+AA12+AT12),0,IF(($C12-SUM($H12+AA12+AT12))>($B$3-SUM(BM$7:BM11)),($B$3-SUM(BM$7:BM11)),($C12-SUM($H12+AA12+AT12)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ11)>0,\"\",IF($B$23>SUM(BM$7:BM12),\"\",IF($F12>$E12,(BX12+($B$23-SUM(BM$7:BM11))),(BX12-($B$23-SUM(BM$7:BM11))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB11)>0,\"\",IF($B$24>SUM(BM$7:BM12),\"\",IF($F12>$E12,(BX12+($B$24-SUM(BM$7:BM11))),(BX12-($B$24-SUM(BM$7:BM11))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD11)>0,\"\",IF($B$25>SUM(BM$7:BM12),\"\",IF($F12>$E12,(BX12+($B$25-SUM(BM$7:BM11))),(BX12-($B$25-SUM(BM$7:BM11))))))","v":""},{"$f":"IFERROR(((CD12-$BX12)*(1/$D12))+$BX12,\"\")","v":""},{"$f":"IFERROR(IF($C12=SUM($H12+AA12+AT12+BM12),0,IF(($C12-SUM($H12+AA12+AT12+BM12))>($B$3-SUM(CF$7:CF11)),($B$3-SUM(CF$7:CF11)),($C12-SUM($H12+AA12+AT12+BM12)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS11)>0,\"\",IF($B$23>SUM(CF$7:CF12),\"\",IF($F12>$E12,(CQ12+($B$23-SUM(CF$7:CF11))),(CQ12-($B$23-SUM(CF$7:CF11))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU11)>0,\"\",IF($B$24>SUM(CF$7:CF12),\"\",IF($F12>$E12,(CQ12+($B$24-SUM(CF$7:CF11))),(CQ12-($B$24-SUM(CF$7:CF11))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW11)>0,\"\",IF($B$25>SUM(CF$7:CF12),\"\",IF($F12>$E12,(CQ12+($B$25-SUM(CF$7:CF11))),(CQ12-($B$25-SUM(CF$7:CF11))))))","v":""},{"$f":"IFERROR(((CW12-$CQ12)*(1/$D12))+$CQ12,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B21=\"\",\"\",'DLTR Template'!$B21)","v":""},{"$f":"'DLTR Template'!$K21","v":""},{"$f":"'DLTR Template'!J21","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H21=\"\",\"\",'DLTR Template'!H21)","v":""},{"$f":"IF('DLTR Template'!I21=\"\",\"\",'DLTR Template'!I21)","v":""},{"$f":"IF('DLTR Template'!D21=\"\",\"\",'DLTR Template'!D21)","v":""},{"$f":"IFERROR(IF(($B$3-$C13-SUM(H$7:H12))>0,$C13,$B$3-SUM(H$7:H12)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U12)>0,\"\",IF($B$23>SUM(H$7:H13),\"\",IF($F13>$E13,(S13+($B$23-SUM(H$7:H12))),(S13-($B$23-SUM(H$7:H12))))))","v":""},"",{"$f":"IF(SUM(W$7:W12)>0,\"\",IF($B$24>SUM(H$7:H13),\"\",IF($F13>$E13,(S13+($B$24-SUM(H$7:H12))),(S13-($B$24-SUM(H$7:H12))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y12)>0,\"\",IF($B$25>SUM(H$7:H13),\"\",IF($F13>$E13,(S13+($B$25-SUM(H$7:H12))),(S13-($B$25-SUM(H$7:H12))))))","v":""},{"$f":"IFERROR(((Y13-$S13)*(1/$D13))+$S13,\"\")","v":""},{"$f":"IFERROR(IF($C13=SUM($H13:H13),0,IF(($C13-SUM($H13:H13))>($B$3-SUM(AA$7:AA12)),($B$3-SUM(AA$7:AA12)),($C13-SUM($H13:H13)))),\"\")","v":0},"","","","","","","","","","","","",null,"",{"$f":"IF(SUM(AP$7:AP12)>0,\"\",IF($B$24>SUM(AA$7:AA13),\"\",IF($F13>$E13,(AL13+($B$24-SUM(AA$7:AA12))),(AL13-($B$24-SUM(AA$7:AA12))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR12)>0,\"\",IF($B$25>SUM(AA$7:AA13),\"\",IF($F13>$E13,(AL13+($B$25-SUM(AA$7:AA12))),(AL13-($B$25-SUM(AA$7:AA12))))))","v":""},{"$f":"IFERROR(((AR13-$AL13)*(1/$D13))+$AL13,\"\")","v":""},{"$f":"IFERROR(IF($C13=SUM($H13+AA13),0,IF(($C13-SUM($H13+AA13))>($B$3-SUM(AT$7:AT12)),($B$3-SUM(AT$7:AT12)),($C13-SUM($H13+AA13)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG12)>0,\"\",IF($B$23>SUM(AT$7:AT13),\"\",IF($F13>$E13,(BE13+($B$23-SUM(AT$7:AT12))),(BE13-($B$23-SUM(AT$7:AT12))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI12)>0,\"\",IF($B$24>SUM(AT$7:AT13),\"\",IF($F13>$E13,(BE13+($B$24-SUM(AT$7:AT12))),(BE13-($B$24-SUM(AT$7:AT12))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK12)>0,\"\",IF($B$25>SUM(AT$7:AT13),\"\",IF($F13>$E13,(BE13+($B$25-SUM(AT$7:AT12))),(BE13-($B$25-SUM(AT$7:AT12))))))","v":""},{"$f":"IFERROR(((BK13-$BE13)*(1/$D13))+$BE13,\"\")","v":""},{"$f":"IFERROR(IF($C13=SUM($H13+AA13+AT13),0,IF(($C13-SUM($H13+AA13+AT13))>($B$3-SUM(BM$7:BM12)),($B$3-SUM(BM$7:BM12)),($C13-SUM($H13+AA13+AT13)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ12)>0,\"\",IF($B$23>SUM(BM$7:BM13),\"\",IF($F13>$E13,(BX13+($B$23-SUM(BM$7:BM12))),(BX13-($B$23-SUM(BM$7:BM12))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB12)>0,\"\",IF($B$24>SUM(BM$7:BM13),\"\",IF($F13>$E13,(BX13+($B$24-SUM(BM$7:BM12))),(BX13-($B$24-SUM(BM$7:BM12))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD12)>0,\"\",IF($B$25>SUM(BM$7:BM13),\"\",IF($F13>$E13,(BX13+($B$25-SUM(BM$7:BM12))),(BX13-($B$25-SUM(BM$7:BM12))))))","v":""},{"$f":"IFERROR(((CD13-$BX13)*(1/$D13))+$BX13,\"\")","v":""},{"$f":"IFERROR(IF($C13=SUM($H13+AA13+AT13+BM13),0,IF(($C13-SUM($H13+AA13+AT13+BM13))>($B$3-SUM(CF$7:CF12)),($B$3-SUM(CF$7:CF12)),($C13-SUM($H13+AA13+AT13+BM13)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS12)>0,\"\",IF($B$23>SUM(CF$7:CF13),\"\",IF($F13>$E13,(CQ13+($B$23-SUM(CF$7:CF12))),(CQ13-($B$23-SUM(CF$7:CF12))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU12)>0,\"\",IF($B$24>SUM(CF$7:CF13),\"\",IF($F13>$E13,(CQ13+($B$24-SUM(CF$7:CF12))),(CQ13-($B$24-SUM(CF$7:CF12))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW12)>0,\"\",IF($B$25>SUM(CF$7:CF13),\"\",IF($F13>$E13,(CQ13+($B$25-SUM(CF$7:CF12))),(CQ13-($B$25-SUM(CF$7:CF12))))))","v":""},{"$f":"IFERROR(((CW13-$CQ13)*(1/$D13))+$CQ13,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B22=\"\",\"\",'DLTR Template'!$B22)","v":""},{"$f":"'DLTR Template'!$K22","v":""},{"$f":"'DLTR Template'!J22","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H22=\"\",\"\",'DLTR Template'!H22)","v":""},{"$f":"IF('DLTR Template'!I22=\"\",\"\",'DLTR Template'!I22)","v":""},{"$f":"IF('DLTR Template'!D22=\"\",\"\",'DLTR Template'!D22)","v":""},{"$f":"IFERROR(IF(($B$3-$C14-SUM(H$7:H13))>0,$C14,$B$3-SUM(H$7:H13)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U13)>0,\"\",IF($B$23>SUM(H$7:H14),\"\",IF($F14>$E14,(S14+($B$23-SUM(H$7:H13))),(S14-($B$23-SUM(H$7:H13))))))","v":""},"",{"$f":"IF(SUM(W$7:W13)>0,\"\",IF($B$24>SUM(H$7:H14),\"\",IF($F14>$E14,(S14+($B$24-SUM(H$7:H13))),(S14-($B$24-SUM(H$7:H13))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y13)>0,\"\",IF($B$25>SUM(H$7:H14),\"\",IF($F14>$E14,(S14+($B$25-SUM(H$7:H13))),(S14-($B$25-SUM(H$7:H13))))))","v":""},{"$f":"IFERROR(((Y14-$S14)*(1/$D14))+$S14,\"\")","v":""},{"$f":"IFERROR(IF($C14=SUM($H14:H14),0,IF(($C14-SUM($H14:H14))>($B$3-SUM(AA$7:AA13)),($B$3-SUM(AA$7:AA13)),($C14-SUM($H14:H14)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN13)>0,\"\",IF($B$23>SUM(AA$7:AA14),\"\",IF($F14>$E14,(AL14+($B$23-SUM(AA$7:AA13))),(AL14-($B$23-SUM(AA$7:AA13))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP13)>0,\"\",IF($B$24>SUM(AA$7:AA14),\"\",IF($F14>$E14,(AL14+($B$24-SUM(AA$7:AA13))),(AL14-($B$24-SUM(AA$7:AA13))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR13)>0,\"\",IF($B$25>SUM(AA$7:AA14),\"\",IF($F14>$E14,(AL14+($B$25-SUM(AA$7:AA13))),(AL14-($B$25-SUM(AA$7:AA13))))))","v":""},{"$f":"IFERROR(((AR14-$AL14)*(1/$D14))+$AL14,\"\")","v":""},{"$f":"IFERROR(IF($C14=SUM($H14+AA14),0,IF(($C14-SUM($H14+AA14))>($B$3-SUM(AT$7:AT13)),($B$3-SUM(AT$7:AT13)),($C14-SUM($H14+AA14)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG13)>0,\"\",IF($B$23>SUM(AT$7:AT14),\"\",IF($F14>$E14,(BE14+($B$23-SUM(AT$7:AT13))),(BE14-($B$23-SUM(AT$7:AT13))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI13)>0,\"\",IF($B$24>SUM(AT$7:AT14),\"\",IF($F14>$E14,(BE14+($B$24-SUM(AT$7:AT13))),(BE14-($B$24-SUM(AT$7:AT13))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK13)>0,\"\",IF($B$25>SUM(AT$7:AT14),\"\",IF($F14>$E14,(BE14+($B$25-SUM(AT$7:AT13))),(BE14-($B$25-SUM(AT$7:AT13))))))","v":""},{"$f":"IFERROR(((BK14-$BE14)*(1/$D14))+$BE14,\"\")","v":""},{"$f":"IFERROR(IF($C14=SUM($H14+AA14+AT14),0,IF(($C14-SUM($H14+AA14+AT14))>($B$3-SUM(BM$7:BM13)),($B$3-SUM(BM$7:BM13)),($C14-SUM($H14+AA14+AT14)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ13)>0,\"\",IF($B$23>SUM(BM$7:BM14),\"\",IF($F14>$E14,(BX14+($B$23-SUM(BM$7:BM13))),(BX14-($B$23-SUM(BM$7:BM13))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB13)>0,\"\",IF($B$24>SUM(BM$7:BM14),\"\",IF($F14>$E14,(BX14+($B$24-SUM(BM$7:BM13))),(BX14-($B$24-SUM(BM$7:BM13))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD13)>0,\"\",IF($B$25>SUM(BM$7:BM14),\"\",IF($F14>$E14,(BX14+($B$25-SUM(BM$7:BM13))),(BX14-($B$25-SUM(BM$7:BM13))))))","v":""},{"$f":"IFERROR(((CD14-$BX14)*(1/$D14))+$BX14,\"\")","v":""},{"$f":"IFERROR(IF($C14=SUM($H14+AA14+AT14+BM14),0,IF(($C14-SUM($H14+AA14+AT14+BM14))>($B$3-SUM(CF$7:CF13)),($B$3-SUM(CF$7:CF13)),($C14-SUM($H14+AA14+AT14+BM14)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS13)>0,\"\",IF($B$23>SUM(CF$7:CF14),\"\",IF($F14>$E14,(CQ14+($B$23-SUM(CF$7:CF13))),(CQ14-($B$23-SUM(CF$7:CF13))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU13)>0,\"\",IF($B$24>SUM(CF$7:CF14),\"\",IF($F14>$E14,(CQ14+($B$24-SUM(CF$7:CF13))),(CQ14-($B$24-SUM(CF$7:CF13))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW13)>0,\"\",IF($B$25>SUM(CF$7:CF14),\"\",IF($F14>$E14,(CQ14+($B$25-SUM(CF$7:CF13))),(CQ14-($B$25-SUM(CF$7:CF13))))))","v":""},{"$f":"IFERROR(((CW14-$CQ14)*(1/$D14))+$CQ14,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B23=\"\",\"\",'DLTR Template'!$B23)","v":""},{"$f":"'DLTR Template'!$K23","v":""},{"$f":"'DLTR Template'!J23","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H23=\"\",\"\",'DLTR Template'!H23)","v":""},{"$f":"IF('DLTR Template'!I23=\"\",\"\",'DLTR Template'!I23)","v":""},{"$f":"IF('DLTR Template'!D23=\"\",\"\",'DLTR Template'!D23)","v":""},{"$f":"IFERROR(IF(($B$3-$C15-SUM(H$7:H14))>0,$C15,$B$3-SUM(H$7:H14)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U14)>0,\"\",IF($B$23>SUM(H$7:H15),\"\",IF($F15>$E15,(S15+($B$23-SUM(H$7:H14))),(S15-($B$23-SUM(H$7:H14))))))","v":""},"",{"$f":"IF(SUM(W$7:W14)>0,\"\",IF($B$24>SUM(H$7:H15),\"\",IF($F15>$E15,(S15+($B$24-SUM(H$7:H14))),(S15-($B$24-SUM(H$7:H14))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y14)>0,\"\",IF($B$25>SUM(H$7:H15),\"\",IF($F15>$E15,(S15+($B$25-SUM(H$7:H14))),(S15-($B$25-SUM(H$7:H14))))))","v":""},{"$f":"IFERROR(((Y15-$S15)*(1/$D15))+$S15,\"\")","v":""},{"$f":"IFERROR(IF($C15=SUM($H15:H15),0,IF(($C15-SUM($H15:H15))>($B$3-SUM(AA$7:AA14)),($B$3-SUM(AA$7:AA14)),($C15-SUM($H15:H15)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN14)>0,\"\",IF($B$23>SUM(AA$7:AA15),\"\",IF($F15>$E15,(AL15+($B$23-SUM(AA$7:AA14))),(AL15-($B$23-SUM(AA$7:AA14))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP14)>0,\"\",IF($B$24>SUM(AA$7:AA15),\"\",IF($F15>$E15,(AL15+($B$24-SUM(AA$7:AA14))),(AL15-($B$24-SUM(AA$7:AA14))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR14)>0,\"\",IF($B$25>SUM(AA$7:AA15),\"\",IF($F15>$E15,(AL15+($B$25-SUM(AA$7:AA14))),(AL15-($B$25-SUM(AA$7:AA14))))))","v":""},{"$f":"IFERROR(((AR15-$AL15)*(1/$D15))+$AL15,\"\")","v":""},{"$f":"IFERROR(IF($C15=SUM($H15+AA15),0,IF(($C15-SUM($H15+AA15))>($B$3-SUM(AT$7:AT14)),($B$3-SUM(AT$7:AT14)),($C15-SUM($H15+AA15)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG14)>0,\"\",IF($B$23>SUM(AT$7:AT15),\"\",IF($F15>$E15,(BE15+($B$23-SUM(AT$7:AT14))),(BE15-($B$23-SUM(AT$7:AT14))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI14)>0,\"\",IF($B$24>SUM(AT$7:AT15),\"\",IF($F15>$E15,(BE15+($B$24-SUM(AT$7:AT14))),(BE15-($B$24-SUM(AT$7:AT14))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK14)>0,\"\",IF($B$25>SUM(AT$7:AT15),\"\",IF($F15>$E15,(BE15+($B$25-SUM(AT$7:AT14))),(BE15-($B$25-SUM(AT$7:AT14))))))","v":""},{"$f":"IFERROR(((BK15-$BE15)*(1/$D15))+$BE15,\"\")","v":""},{"$f":"IFERROR(IF($C15=SUM($H15+AA15+AT15),0,IF(($C15-SUM($H15+AA15+AT15))>($B$3-SUM(BM$7:BM14)),($B$3-SUM(BM$7:BM14)),($C15-SUM($H15+AA15+AT15)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ14)>0,\"\",IF($B$23>SUM(BM$7:BM15),\"\",IF($F15>$E15,(BX15+($B$23-SUM(BM$7:BM14))),(BX15-($B$23-SUM(BM$7:BM14))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB14)>0,\"\",IF($B$24>SUM(BM$7:BM15),\"\",IF($F15>$E15,(BX15+($B$24-SUM(BM$7:BM14))),(BX15-($B$24-SUM(BM$7:BM14))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD14)>0,\"\",IF($B$25>SUM(BM$7:BM15),\"\",IF($F15>$E15,(BX15+($B$25-SUM(BM$7:BM14))),(BX15-($B$25-SUM(BM$7:BM14))))))","v":""},{"$f":"IFERROR(((CD15-$BX15)*(1/$D15))+$BX15,\"\")","v":""},{"$f":"IFERROR(IF($C15=SUM($H15+AA15+AT15+BM15),0,IF(($C15-SUM($H15+AA15+AT15+BM15))>($B$3-SUM(CF$7:CF14)),($B$3-SUM(CF$7:CF14)),($C15-SUM($H15+AA15+AT15+BM15)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS14)>0,\"\",IF($B$23>SUM(CF$7:CF15),\"\",IF($F15>$E15,(CQ15+($B$23-SUM(CF$7:CF14))),(CQ15-($B$23-SUM(CF$7:CF14))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU14)>0,\"\",IF($B$24>SUM(CF$7:CF15),\"\",IF($F15>$E15,(CQ15+($B$24-SUM(CF$7:CF14))),(CQ15-($B$24-SUM(CF$7:CF14))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW14)>0,\"\",IF($B$25>SUM(CF$7:CF15),\"\",IF($F15>$E15,(CQ15+($B$25-SUM(CF$7:CF14))),(CQ15-($B$25-SUM(CF$7:CF14))))))","v":""},{"$f":"IFERROR(((CW15-$CQ15)*(1/$D15))+$CQ15,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B24=\"\",\"\",'DLTR Template'!$B24)","v":""},{"$f":"'DLTR Template'!$K24","v":""},{"$f":"'DLTR Template'!J24","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H24=\"\",\"\",'DLTR Template'!H24)","v":""},{"$f":"IF('DLTR Template'!I24=\"\",\"\",'DLTR Template'!I24)","v":""},{"$f":"IF('DLTR Template'!D24=\"\",\"\",'DLTR Template'!D24)","v":""},{"$f":"IFERROR(IF(($B$3-$C16-SUM(H$7:H15))>0,$C16,$B$3-SUM(H$7:H15)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U15)>0,\"\",IF($B$23>SUM(H$7:H16),\"\",IF($F16>$E16,(S16+($B$23-SUM(H$7:H15))),(S16-($B$23-SUM(H$7:H15))))))","v":""},"",{"$f":"IF(SUM(W$7:W15)>0,\"\",IF($B$24>SUM(H$7:H16),\"\",IF($F16>$E16,(S16+($B$24-SUM(H$7:H15))),(S16-($B$24-SUM(H$7:H15))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y15)>0,\"\",IF($B$25>SUM(H$7:H16),\"\",IF($F16>$E16,(S16+($B$25-SUM(H$7:H15))),(S16-($B$25-SUM(H$7:H15))))))","v":""},{"$f":"IFERROR(((Y16-$S16)*(1/$D16))+$S16,\"\")","v":""},{"$f":"IFERROR(IF($C16=SUM($H16:H16),0,IF(($C16-SUM($H16:H16))>($B$3-SUM(AA$7:AA15)),($B$3-SUM(AA$7:AA15)),($C16-SUM($H16:H16)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN15)>0,\"\",IF($B$23>SUM(AA$7:AA16),\"\",IF($F16>$E16,(AL16+($B$23-SUM(AA$7:AA15))),(AL16-($B$23-SUM(AA$7:AA15))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP15)>0,\"\",IF($B$24>SUM(AA$7:AA16),\"\",IF($F16>$E16,(AL16+($B$24-SUM(AA$7:AA15))),(AL16-($B$24-SUM(AA$7:AA15))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR15)>0,\"\",IF($B$25>SUM(AA$7:AA16),\"\",IF($F16>$E16,(AL16+($B$25-SUM(AA$7:AA15))),(AL16-($B$25-SUM(AA$7:AA15))))))","v":""},{"$f":"IFERROR(((AR16-$AL16)*(1/$D16))+$AL16,\"\")","v":""},{"$f":"IFERROR(IF($C16=SUM($H16+AA16),0,IF(($C16-SUM($H16+AA16))>($B$3-SUM(AT$7:AT15)),($B$3-SUM(AT$7:AT15)),($C16-SUM($H16+AA16)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG15)>0,\"\",IF($B$23>SUM(AT$7:AT16),\"\",IF($F16>$E16,(BE16+($B$23-SUM(AT$7:AT15))),(BE16-($B$23-SUM(AT$7:AT15))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI15)>0,\"\",IF($B$24>SUM(AT$7:AT16),\"\",IF($F16>$E16,(BE16+($B$24-SUM(AT$7:AT15))),(BE16-($B$24-SUM(AT$7:AT15))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK15)>0,\"\",IF($B$25>SUM(AT$7:AT16),\"\",IF($F16>$E16,(BE16+($B$25-SUM(AT$7:AT15))),(BE16-($B$25-SUM(AT$7:AT15))))))","v":""},{"$f":"IFERROR(((BK16-$BE16)*(1/$D16))+$BE16,\"\")","v":""},{"$f":"IFERROR(IF($C16=SUM($H16+AA16+AT16),0,IF(($C16-SUM($H16+AA16+AT16))>($B$3-SUM(BM$7:BM15)),($B$3-SUM(BM$7:BM15)),($C16-SUM($H16+AA16+AT16)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ15)>0,\"\",IF($B$23>SUM(BM$7:BM16),\"\",IF($F16>$E16,(BX16+($B$23-SUM(BM$7:BM15))),(BX16-($B$23-SUM(BM$7:BM15))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB15)>0,\"\",IF($B$24>SUM(BM$7:BM16),\"\",IF($F16>$E16,(BX16+($B$24-SUM(BM$7:BM15))),(BX16-($B$24-SUM(BM$7:BM15))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD15)>0,\"\",IF($B$25>SUM(BM$7:BM16),\"\",IF($F16>$E16,(BX16+($B$25-SUM(BM$7:BM15))),(BX16-($B$25-SUM(BM$7:BM15))))))","v":""},{"$f":"IFERROR(((CD16-$BX16)*(1/$D16))+$BX16,\"\")","v":""},{"$f":"IFERROR(IF($C16=SUM($H16+AA16+AT16+BM16),0,IF(($C16-SUM($H16+AA16+AT16+BM16))>($B$3-SUM(CF$7:CF15)),($B$3-SUM(CF$7:CF15)),($C16-SUM($H16+AA16+AT16+BM16)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS15)>0,\"\",IF($B$23>SUM(CF$7:CF16),\"\",IF($F16>$E16,(CQ16+($B$23-SUM(CF$7:CF15))),(CQ16-($B$23-SUM(CF$7:CF15))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU15)>0,\"\",IF($B$24>SUM(CF$7:CF16),\"\",IF($F16>$E16,(CQ16+($B$24-SUM(CF$7:CF15))),(CQ16-($B$24-SUM(CF$7:CF15))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW15)>0,\"\",IF($B$25>SUM(CF$7:CF16),\"\",IF($F16>$E16,(CQ16+($B$25-SUM(CF$7:CF15))),(CQ16-($B$25-SUM(CF$7:CF15))))))","v":""},{"$f":"IFERROR(((CW16-$CQ16)*(1/$D16))+$CQ16,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B25=\"\",\"\",'DLTR Template'!$B25)","v":""},{"$f":"'DLTR Template'!$K25","v":""},{"$f":"'DLTR Template'!J25","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H25=\"\",\"\",'DLTR Template'!H25)","v":""},{"$f":"IF('DLTR Template'!I25=\"\",\"\",'DLTR Template'!I25)","v":""},{"$f":"IF('DLTR Template'!D25=\"\",\"\",'DLTR Template'!D25)","v":""},{"$f":"IFERROR(IF(($B$3-$C17-SUM(H$7:H16))>0,$C17,$B$3-SUM(H$7:H16)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U16)>0,\"\",IF($B$23>SUM(H$7:H17),\"\",IF($F17>$E17,(S17+($B$23-SUM(H$7:H16))),(S17-($B$23-SUM(H$7:H16))))))","v":""},"",{"$f":"IF(SUM(W$7:W16)>0,\"\",IF($B$24>SUM(H$7:H17),\"\",IF($F17>$E17,(S17+($B$24-SUM(H$7:H16))),(S17-($B$24-SUM(H$7:H16))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y16)>0,\"\",IF($B$25>SUM(H$7:H17),\"\",IF($F17>$E17,(S17+($B$25-SUM(H$7:H16))),(S17-($B$25-SUM(H$7:H16))))))","v":""},{"$f":"IFERROR(((Y17-$S17)*(1/$D17))+$S17,\"\")","v":""},{"$f":"IFERROR(IF($C17=SUM($H17:H17),0,IF(($C17-SUM($H17:H17))>($B$3-SUM(AA$7:AA16)),($B$3-SUM(AA$7:AA16)),($C17-SUM($H17:H17)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN16)>0,\"\",IF($B$23>SUM(AA$7:AA17),\"\",IF($F17>$E17,(AL17+($B$23-SUM(AA$7:AA16))),(AL17-($B$23-SUM(AA$7:AA16))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP16)>0,\"\",IF($B$24>SUM(AA$7:AA17),\"\",IF($F17>$E17,(AL17+($B$24-SUM(AA$7:AA16))),(AL17-($B$24-SUM(AA$7:AA16))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR16)>0,\"\",IF($B$25>SUM(AA$7:AA17),\"\",IF($F17>$E17,(AL17+($B$25-SUM(AA$7:AA16))),(AL17-($B$25-SUM(AA$7:AA16))))))","v":""},{"$f":"IFERROR(((AR17-$AL17)*(1/$D17))+$AL17,\"\")","v":""},{"$f":"IFERROR(IF($C17=SUM($H17+AA17),0,IF(($C17-SUM($H17+AA17))>($B$3-SUM(AT$7:AT16)),($B$3-SUM(AT$7:AT16)),($C17-SUM($H17+AA17)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG16)>0,\"\",IF($B$23>SUM(AT$7:AT17),\"\",IF($F17>$E17,(BE17+($B$23-SUM(AT$7:AT16))),(BE17-($B$23-SUM(AT$7:AT16))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI16)>0,\"\",IF($B$24>SUM(AT$7:AT17),\"\",IF($F17>$E17,(BE17+($B$24-SUM(AT$7:AT16))),(BE17-($B$24-SUM(AT$7:AT16))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK16)>0,\"\",IF($B$25>SUM(AT$7:AT17),\"\",IF($F17>$E17,(BE17+($B$25-SUM(AT$7:AT16))),(BE17-($B$25-SUM(AT$7:AT16))))))","v":""},{"$f":"IFERROR(((BK17-$BE17)*(1/$D17))+$BE17,\"\")","v":""},{"$f":"IFERROR(IF($C17=SUM($H17+AA17+AT17),0,IF(($C17-SUM($H17+AA17+AT17))>($B$3-SUM(BM$7:BM16)),($B$3-SUM(BM$7:BM16)),($C17-SUM($H17+AA17+AT17)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ16)>0,\"\",IF($B$23>SUM(BM$7:BM17),\"\",IF($F17>$E17,(BX17+($B$23-SUM(BM$7:BM16))),(BX17-($B$23-SUM(BM$7:BM16))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB16)>0,\"\",IF($B$24>SUM(BM$7:BM17),\"\",IF($F17>$E17,(BX17+($B$24-SUM(BM$7:BM16))),(BX17-($B$24-SUM(BM$7:BM16))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD16)>0,\"\",IF($B$25>SUM(BM$7:BM17),\"\",IF($F17>$E17,(BX17+($B$25-SUM(BM$7:BM16))),(BX17-($B$25-SUM(BM$7:BM16))))))","v":""},{"$f":"IFERROR(((CD17-$BX17)*(1/$D17))+$BX17,\"\")","v":""},{"$f":"IFERROR(IF($C17=SUM($H17+AA17+AT17+BM17),0,IF(($C17-SUM($H17+AA17+AT17+BM17))>($B$3-SUM(CF$7:CF16)),($B$3-SUM(CF$7:CF16)),($C17-SUM($H17+AA17+AT17+BM17)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS16)>0,\"\",IF($B$23>SUM(CF$7:CF17),\"\",IF($F17>$E17,(CQ17+($B$23-SUM(CF$7:CF16))),(CQ17-($B$23-SUM(CF$7:CF16))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU16)>0,\"\",IF($B$24>SUM(CF$7:CF17),\"\",IF($F17>$E17,(CQ17+($B$24-SUM(CF$7:CF16))),(CQ17-($B$24-SUM(CF$7:CF16))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW16)>0,\"\",IF($B$25>SUM(CF$7:CF17),\"\",IF($F17>$E17,(CQ17+($B$25-SUM(CF$7:CF16))),(CQ17-($B$25-SUM(CF$7:CF16))))))","v":""},{"$f":"IFERROR(((CW17-$CQ17)*(1/$D17))+$CQ17,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B26=\"\",\"\",'DLTR Template'!$B26)","v":""},{"$f":"'DLTR Template'!$K26","v":""},{"$f":"'DLTR Template'!J26","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H26=\"\",\"\",'DLTR Template'!H26)","v":""},{"$f":"IF('DLTR Template'!I26=\"\",\"\",'DLTR Template'!I26)","v":""},{"$f":"IF('DLTR Template'!D26=\"\",\"\",'DLTR Template'!D26)","v":""},{"$f":"IFERROR(IF(($B$3-$C18-SUM(H$7:H17))>0,$C18,$B$3-SUM(H$7:H17)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U17)>0,\"\",IF($B$23>SUM(H$7:H18),\"\",IF($F18>$E18,(S18+($B$23-SUM(H$7:H17))),(S18-($B$23-SUM(H$7:H17))))))","v":""},"",{"$f":"IF(SUM(W$7:W17)>0,\"\",IF($B$24>SUM(H$7:H18),\"\",IF($F18>$E18,(S18+($B$24-SUM(H$7:H17))),(S18-($B$24-SUM(H$7:H17))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y17)>0,\"\",IF($B$25>SUM(H$7:H18),\"\",IF($F18>$E18,(S18+($B$25-SUM(H$7:H17))),(S18-($B$25-SUM(H$7:H17))))))","v":""},{"$f":"IFERROR(((Y18-$S18)*(1/$D18))+$S18,\"\")","v":""},{"$f":"IFERROR(IF($C18=SUM($H18:H18),0,IF(($C18-SUM($H18:H18))>($B$3-SUM(AA$7:AA17)),($B$3-SUM(AA$7:AA17)),($C18-SUM($H18:H18)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN17)>0,\"\",IF($B$23>SUM(AA$7:AA18),\"\",IF($F18>$E18,(AL18+($B$23-SUM(AA$7:AA17))),(AL18-($B$23-SUM(AA$7:AA17))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP17)>0,\"\",IF($B$24>SUM(AA$7:AA18),\"\",IF($F18>$E18,(AL18+($B$24-SUM(AA$7:AA17))),(AL18-($B$24-SUM(AA$7:AA17))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR17)>0,\"\",IF($B$25>SUM(AA$7:AA18),\"\",IF($F18>$E18,(AL18+($B$25-SUM(AA$7:AA17))),(AL18-($B$25-SUM(AA$7:AA17))))))","v":""},{"$f":"IFERROR(((AR18-$AL18)*(1/$D18))+$AL18,\"\")","v":""},{"$f":"IFERROR(IF($C18=SUM($H18+AA18),0,IF(($C18-SUM($H18+AA18))>($B$3-SUM(AT$7:AT17)),($B$3-SUM(AT$7:AT17)),($C18-SUM($H18+AA18)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG17)>0,\"\",IF($B$23>SUM(AT$7:AT18),\"\",IF($F18>$E18,(BE18+($B$23-SUM(AT$7:AT17))),(BE18-($B$23-SUM(AT$7:AT17))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI17)>0,\"\",IF($B$24>SUM(AT$7:AT18),\"\",IF($F18>$E18,(BE18+($B$24-SUM(AT$7:AT17))),(BE18-($B$24-SUM(AT$7:AT17))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK17)>0,\"\",IF($B$25>SUM(AT$7:AT18),\"\",IF($F18>$E18,(BE18+($B$25-SUM(AT$7:AT17))),(BE18-($B$25-SUM(AT$7:AT17))))))","v":""},{"$f":"IFERROR(((BK18-$BE18)*(1/$D18))+$BE18,\"\")","v":""},{"$f":"IFERROR(IF($C18=SUM($H18+AA18+AT18),0,IF(($C18-SUM($H18+AA18+AT18))>($B$3-SUM(BM$7:BM17)),($B$3-SUM(BM$7:BM17)),($C18-SUM($H18+AA18+AT18)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ17)>0,\"\",IF($B$23>SUM(BM$7:BM18),\"\",IF($F18>$E18,(BX18+($B$23-SUM(BM$7:BM17))),(BX18-($B$23-SUM(BM$7:BM17))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB17)>0,\"\",IF($B$24>SUM(BM$7:BM18),\"\",IF($F18>$E18,(BX18+($B$24-SUM(BM$7:BM17))),(BX18-($B$24-SUM(BM$7:BM17))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD17)>0,\"\",IF($B$25>SUM(BM$7:BM18),\"\",IF($F18>$E18,(BX18+($B$25-SUM(BM$7:BM17))),(BX18-($B$25-SUM(BM$7:BM17))))))","v":""},{"$f":"IFERROR(((CD18-$BX18)*(1/$D18))+$BX18,\"\")","v":""},{"$f":"IFERROR(IF($C18=SUM($H18+AA18+AT18+BM18),0,IF(($C18-SUM($H18+AA18+AT18+BM18))>($B$3-SUM(CF$7:CF17)),($B$3-SUM(CF$7:CF17)),($C18-SUM($H18+AA18+AT18+BM18)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS17)>0,\"\",IF($B$23>SUM(CF$7:CF18),\"\",IF($F18>$E18,(CQ18+($B$23-SUM(CF$7:CF17))),(CQ18-($B$23-SUM(CF$7:CF17))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU17)>0,\"\",IF($B$24>SUM(CF$7:CF18),\"\",IF($F18>$E18,(CQ18+($B$24-SUM(CF$7:CF17))),(CQ18-($B$24-SUM(CF$7:CF17))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW17)>0,\"\",IF($B$25>SUM(CF$7:CF18),\"\",IF($F18>$E18,(CQ18+($B$25-SUM(CF$7:CF17))),(CQ18-($B$25-SUM(CF$7:CF17))))))","v":""},{"$f":"IFERROR(((CW18-$CQ18)*(1/$D18))+$CQ18,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B27=\"\",\"\",'DLTR Template'!$B27)","v":""},{"$f":"'DLTR Template'!$K27","v":""},{"$f":"'DLTR Template'!J27","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H27=\"\",\"\",'DLTR Template'!H27)","v":""},{"$f":"IF('DLTR Template'!I27=\"\",\"\",'DLTR Template'!I27)","v":""},{"$f":"IF('DLTR Template'!D27=\"\",\"\",'DLTR Template'!D27)","v":""},{"$f":"IFERROR(IF(($B$3-$C19-SUM(H$7:H18))>0,$C19,$B$3-SUM(H$7:H18)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U18)>0,\"\",IF($B$23>SUM(H$7:H19),\"\",IF($F19>$E19,(S19+($B$23-SUM(H$7:H18))),(S19-($B$23-SUM(H$7:H18))))))","v":""},"",{"$f":"IF(SUM(W$7:W18)>0,\"\",IF($B$24>SUM(H$7:H19),\"\",IF($F19>$E19,(S19+($B$24-SUM(H$7:H18))),(S19-($B$24-SUM(H$7:H18))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y18)>0,\"\",IF($B$25>SUM(H$7:H19),\"\",IF($F19>$E19,(S19+($B$25-SUM(H$7:H18))),(S19-($B$25-SUM(H$7:H18))))))","v":""},{"$f":"IFERROR(((Y19-$S19)*(1/$D19))+$S19,\"\")","v":""},{"$f":"IFERROR(IF($C19=SUM($H19:H19),0,IF(($C19-SUM($H19:H19))>($B$3-SUM(AA$7:AA18)),($B$3-SUM(AA$7:AA18)),($C19-SUM($H19:H19)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN18)>0,\"\",IF($B$23>SUM(AA$7:AA19),\"\",IF($F19>$E19,(AL19+($B$23-SUM(AA$7:AA18))),(AL19-($B$23-SUM(AA$7:AA18))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP18)>0,\"\",IF($B$24>SUM(AA$7:AA19),\"\",IF($F19>$E19,(AL19+($B$24-SUM(AA$7:AA18))),(AL19-($B$24-SUM(AA$7:AA18))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR18)>0,\"\",IF($B$25>SUM(AA$7:AA19),\"\",IF($F19>$E19,(AL19+($B$25-SUM(AA$7:AA18))),(AL19-($B$25-SUM(AA$7:AA18))))))","v":""},{"$f":"IFERROR(((AR19-$AL19)*(1/$D19))+$AL19,\"\")","v":""},{"$f":"IFERROR(IF($C19=SUM($H19+AA19),0,IF(($C19-SUM($H19+AA19))>($B$3-SUM(AT$7:AT18)),($B$3-SUM(AT$7:AT18)),($C19-SUM($H19+AA19)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG18)>0,\"\",IF($B$23>SUM(AT$7:AT19),\"\",IF($F19>$E19,(BE19+($B$23-SUM(AT$7:AT18))),(BE19-($B$23-SUM(AT$7:AT18))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI18)>0,\"\",IF($B$24>SUM(AT$7:AT19),\"\",IF($F19>$E19,(BE19+($B$24-SUM(AT$7:AT18))),(BE19-($B$24-SUM(AT$7:AT18))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK18)>0,\"\",IF($B$25>SUM(AT$7:AT19),\"\",IF($F19>$E19,(BE19+($B$25-SUM(AT$7:AT18))),(BE19-($B$25-SUM(AT$7:AT18))))))","v":""},{"$f":"IFERROR(((BK19-$BE19)*(1/$D19))+$BE19,\"\")","v":""},{"$f":"IFERROR(IF($C19=SUM($H19+AA19+AT19),0,IF(($C19-SUM($H19+AA19+AT19))>($B$3-SUM(BM$7:BM18)),($B$3-SUM(BM$7:BM18)),($C19-SUM($H19+AA19+AT19)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BZ$7:BZ18)>0,\"\",IF($B$23>SUM(BM$7:BM19),\"\",IF($F19>$E19,(BX19+($B$23-SUM(BM$7:BM18))),(BX19-($B$23-SUM(BM$7:BM18))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB18)>0,\"\",IF($B$24>SUM(BM$7:BM19),\"\",IF($F19>$E19,(BX19+($B$24-SUM(BM$7:BM18))),(BX19-($B$24-SUM(BM$7:BM18))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD18)>0,\"\",IF($B$25>SUM(BM$7:BM19),\"\",IF($F19>$E19,(BX19+($B$25-SUM(BM$7:BM18))),(BX19-($B$25-SUM(BM$7:BM18))))))","v":""},{"$f":"IFERROR(((CD19-$BX19)*(1/$D19))+$BX19,\"\")","v":""},{"$f":"IFERROR(IF($C19=SUM($H19+AA19+AT19+BM19),0,IF(($C19-SUM($H19+AA19+AT19+BM19))>($B$3-SUM(CF$7:CF18)),($B$3-SUM(CF$7:CF18)),($C19-SUM($H19+AA19+AT19+BM19)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS18)>0,\"\",IF($B$23>SUM(CF$7:CF19),\"\",IF($F19>$E19,(CQ19+($B$23-SUM(CF$7:CF18))),(CQ19-($B$23-SUM(CF$7:CF18))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU18)>0,\"\",IF($B$24>SUM(CF$7:CF19),\"\",IF($F19>$E19,(CQ19+($B$24-SUM(CF$7:CF18))),(CQ19-($B$24-SUM(CF$7:CF18))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW18)>0,\"\",IF($B$25>SUM(CF$7:CF19),\"\",IF($F19>$E19,(CQ19+($B$25-SUM(CF$7:CF18))),(CQ19-($B$25-SUM(CF$7:CF18))))))","v":""},{"$f":"IFERROR(((CW19-$CQ19)*(1/$D19))+$CQ19,\"\")","v":""}]
[{"$f":"IF('DLTR Template'!$B28=\"\",\"\",'DLTR Template'!$B28)","v":""},{"$f":"'DLTR Template'!$K28","v":""},{"$f":"'DLTR Template'!J28","v":0},{"$error":"#VALUE!"},{"$f":"IF('DLTR Template'!H28=\"\",\"\",'DLTR Template'!H28)","v":""},{"$f":"IF('DLTR Template'!I28=\"\",\"\",'DLTR Template'!I28)","v":""},{"$f":"IF('DLTR Template'!D28=\"\",\"\",'DLTR Template'!D28)","v":""},{"$f":"IFERROR(IF(($B$3-$C20-SUM(H$7:H19))>0,$C20,$B$3-SUM(H$7:H19)),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(U$7:U19)>0,\"\",IF($B$23>SUM(H$7:H20),\"\",IF($F20>$E20,(S20+($B$23-SUM(H$7:H19))),(S20-($B$23-SUM(H$7:H19))))))","v":""},"",{"$f":"IF(SUM(W$7:W19)>0,\"\",IF($B$24>SUM(H$7:H20),\"\",IF($F20>$E20,(S20+($B$24-SUM(H$7:H19))),(S20-($B$24-SUM(H$7:H19))))))","v":""},"",{"$f":"IF(SUM(Y$7:Y19)>0,\"\",IF($B$25>SUM(H$7:H20),\"\",IF($F20>$E20,(S20+($B$25-SUM(H$7:H19))),(S20-($B$25-SUM(H$7:H19))))))","v":""},{"$f":"IFERROR(((Y20-$S20)*(1/$D20))+$S20,\"\")","v":""},{"$f":"IFERROR(IF($C20=SUM($H20:H20),0,IF(($C20-SUM($H20:H20))>($B$3-SUM(AA$7:AA19)),($B$3-SUM(AA$7:AA19)),($C20-SUM($H20:H20)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(AN$7:AN19)>0,\"\",IF($B$23>SUM(AA$7:AA20),\"\",IF($F20>$E20,(AL20+($B$23-SUM(AA$7:AA19))),(AL20-($B$23-SUM(AA$7:AA19))))))","v":""},"",{"$f":"IF(SUM(AP$7:AP19)>0,\"\",IF($B$24>SUM(AA$7:AA20),\"\",IF($F20>$E20,(AL20+($B$24-SUM(AA$7:AA19))),(AL20-($B$24-SUM(AA$7:AA19))))))","v":""},"",{"$f":"IF(SUM(AR$7:AR19)>0,\"\",IF($B$25>SUM(AA$7:AA20),\"\",IF($F20>$E20,(AL20+($B$25-SUM(AA$7:AA19))),(AL20-($B$25-SUM(AA$7:AA19))))))","v":""},{"$f":"IFERROR(((AR20-$AL20)*(1/$D20))+$AL20,\"\")","v":""},{"$f":"IFERROR(IF($C20=SUM($H20+AA20),0,IF(($C20-SUM($H20+AA20))>($B$3-SUM(AT$7:AT19)),($B$3-SUM(AT$7:AT19)),($C20-SUM($H20+AA20)))),\"\")","v":0},"","","","","","","","","","","","",{"$f":"IF(SUM(BG$7:BG19)>0,\"\",IF($B$23>SUM(AT$7:AT20),\"\",IF($F20>$E20,(BE20+($B$23-SUM(AT$7:AT19))),(BE20-($B$23-SUM(AT$7:AT19))))))","v":""},"",{"$f":"IF(SUM(BI$7:BI19)>0,\"\",IF($B$24>SUM(AT$7:AT20),\"\",IF($F20>$E20,(BE20+($B$24-SUM(AT$7:AT19))),(BE20-($B$24-SUM(AT$7:AT19))))))","v":""},"",{"$f":"IF(SUM(BK$7:BK19)>0,\"\",IF($B$25>SUM(AT$7:AT20),\"\",IF($F20>$E20,(BE20+($B$25-SUM(AT$7:AT19))),(BE20-($B$25-SUM(AT$7:AT19))))))","v":""},{"$f":"IFERROR(((BK20-$BE20)*(1/$D20))+$BE20,\"\")","v":""},{"$f":"IFERROR(IF($C20=SUM($H20+AA20+AT20),0,IF(($C20-SUM($H20+AA20+AT20))>($B$3-SUM(BM$7:BM19)),($B$3-SUM(BM$7:BM19)),($C20-SUM($H20+AA20+AT20)))),\"\")","v":0},"","","","","","","","","","","",{"$f":"IF(BX20=\"\",\"\",IF($F20>$E20,BX20+BN20,BX20-BN20))","v":""},{"$f":"IF(SUM(BZ$7:BZ19)>0,\"\",IF($B$23>SUM(BM$7:BM20),\"\",IF($F20>$E20,(BX20+($B$23-SUM(BM$7:BM19))),(BX20-($B$23-SUM(BM$7:BM19))))))","v":""},"",{"$f":"IF(SUM(CB$7:CB19)>0,\"\",IF($B$24>SUM(BM$7:BM20),\"\",IF($F20>$E20,(BX20+($B$24-SUM(BM$7:BM19))),(BX20-($B$24-SUM(BM$7:BM19))))))","v":""},"",{"$f":"IF(SUM(CD$7:CD19)>0,\"\",IF($B$25>SUM(BM$7:BM20),\"\",IF($F20>$E20,(BX20+($B$25-SUM(BM$7:BM19))),(BX20-($B$25-SUM(BM$7:BM19))))))","v":""},{"$f":"IFERROR(((CD20-$BX20)*(1/$D20))+$BX20,\"\")","v":""},{"$f":"IFERROR(IF($B20=SUM($H20+AA20+AT20+BM20),0,IF(($B20-SUM($H20+AA20+AT20+BM20))>($B$3-SUM(CF$7:CF19)),($B$3-SUM(CF$7:CF19)),($B20-SUM($H20+AA20+AT20+BM20)))),\"\")","v":""},"","","","","","","","","","","","",{"$f":"IF(SUM(CS$7:CS19)>0,\"\",IF($B$23>SUM(CF$7:CF20),\"\",IF($F20>$E20,(CQ20+($B$23-SUM(CF$7:CF19))),(CQ20-($B$23-SUM(CF$7:CF19))))))","v":""},"",{"$f":"IF(SUM(CU$7:CU19)>0,\"\",IF($B$24>SUM(CF$7:CF20),\"\",IF($F20>$E20,(CQ20+($B$24-SUM(CF$7:CF19))),(CQ20-($B$24-SUM(CF$7:CF19))))))","v":""},"",{"$f":"IF(SUM(CW$7:CW19)>0,\"\",IF($B$25>SUM(CF$7:CF20),\"\",IF($F20>$E20,(CQ20+($B$25-SUM(CF$7:CF19))),(CQ20-($B$25-SUM(CF$7:CF19))))))","v":""},{"$f":"IFERROR(((CW20-$CQ20)*(1/$D20))+$CQ20,\"\")","v":""}]
[]
[]
["Random Zone #1",5.9494855908751498]
["Random Zone #2",5.4519406818151479]
["Random Zone #3",2.5762789612412456,null,null,null,"Date Selected =",null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-12T10:01:20"]
[]
["Zone #1 Locations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone #2 Locations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone #3 Locations"]
[null,"Route",null,null,"Direction","Milepoint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Route",null,"Direction",null,"Milepoint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Route",null,"Direction",null,"Milepoint"]
["Segment 1",{"$f":"IFERROR(INDEX($J$7:$U$20,MATCH(\"Yes\",$J$7:$J$20,0),2),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX($J$7:$U$20,MATCH(\"Yes\",$J$7:$J$20,0),3),\"\")","v":""},{"$f":"IFERROR(ROUND(IFERROR(INDEX($J$7:$V$20,MATCH(\"Yes\",$J$7:$J$20,0),13),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Segment 1",null,null,{"$f":"IFERROR(INDEX($M$7:$U$20,MATCH(\"Yes\",$M$7:$M$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($M$7:$U$20,MATCH(\"Yes\",$M$7:$M$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($M$7:$Z$20,MATCH(\"Yes\",$M$7:$M$20,0),12),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Segment 1",null,null,{"$f":"IFERROR(INDEX($P$7:$U$20,MATCH(\"Yes\",$P$7:$P$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($P$7:$U$20,MATCH(\"Yes\",$P$7:$P$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($P$7:$Z$20,MATCH(\"Yes\",$P$7:$P$20,0),11),\"\"),4),\"\")","v":""}]
["Segment 2",{"$f":"IFERROR(INDEX($AC$7:$AN$20,MATCH(\"Yes\",$AC$7:$AC$20,0),2),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX($AC$7:$AN$20,MATCH(\"Yes\",$AC$7:$AC$20,0),3),\"\")","v":""},{"$f":"IFERROR(ROUND(IFERROR(INDEX($AC$7:$AO$20,MATCH(\"Yes\",$AC$7:$AC$20,0),13),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Segment 2",null,null,{"$f":"IFERROR(INDEX($AF$7:$AN$20,MATCH(\"Yes\",$AF$7:$AF$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($AF$7:$AN$20,MATCH(\"Yes\",$AF$7:$AF$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($AF$7:$AS$20,MATCH(\"Yes\",$AF$7:$AF$20,0),12),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Segment 2",null,null,{"$f":"IFERROR(INDEX($AI$7:$AN$20,MATCH(\"Yes\",$AI$7:$AI$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($AI$7:$AN$20,MATCH(\"Yes\",$AI$7:$AI$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($AI$7:$AS$20,MATCH(\"Yes\",$AI$7:$AI$20,0),11),\"\"),4),\"\")","v":""}]
["Segment 3",{"$f":"IFERROR(INDEX($AV$7:$BG$20,MATCH(\"Yes\",$AV$7:$AV$20,0),2),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX($AV$7:$BG$20,MATCH(\"Yes\",$AV$7:$AV$20,0),3),\"\")","v":""},{"$f":"IFERROR(ROUND(IFERROR(INDEX($AV$7:$BH$20,MATCH(\"Yes\",$AV$7:$AV$20,0),13),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Segment 3",null,null,{"$f":"IFERROR(INDEX($AY$7:$BG$20,MATCH(\"Yes\",$AY$7:$AY$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($AY$7:$BG$20,MATCH(\"Yes\",$AY$7:$AY$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($AY$7:$BL$20,MATCH(\"Yes\",$AY$7:$AY$20,0),12),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Segment 3",null,null,{"$f":"IFERROR(INDEX($BB$7:$BG$20,MATCH(\"Yes\",$BB$7:$BB$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($BB$7:$BG$20,MATCH(\"Yes\",$BB$7:$BB$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($BB$7:$BL$20,MATCH(\"Yes\",$BB$7:$BB$20,0),11),\"\"),4),\"\")","v":""}]
["Segment 4",{"$f":"IFERROR(INDEX($BO$7:$BZ$20,MATCH(\"Yes\",$BO$7:$BO$20,0),2),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX($BO$7:$BZ$20,MATCH(\"Yes\",$BO$7:$BO$20,0),3),\"\")","v":""},{"$f":"IFERROR(ROUND(IFERROR(INDEX($BO$7:$CA$20,MATCH(\"Yes\",$BO$7:$BO$20,0),13),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Segment 4",null,null,{"$f":"IFERROR(INDEX($BR$7:$BZ$20,MATCH(\"Yes\",$BR$7:$BR$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($BR$7:$BZ$20,MATCH(\"Yes\",$BR$7:$BR$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($BR$7:$CE$20,MATCH(\"Yes\",$BR$7:$BR$20,0),12),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Segment 4",null,null,{"$f":"IFERROR(INDEX($BU$7:$BZ$20,MATCH(\"Yes\",$BU$7:$BU$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($BU$7:$BZ$20,MATCH(\"Yes\",$BU$7:$BU$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($BU$7:$CE$20,MATCH(\"Yes\",$BU$7:$BU$20,0),11),\"\"),4),\"\")","v":""}]
["Segment 5",{"$f":"IFERROR(INDEX($CH$7:$CS$20,MATCH(\"Yes\",$CH$7:$CH$20,0),2),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX($CH$7:$CS$20,MATCH(\"Yes\",$CH$7:$CH$20,0),3),\"\")","v":""},{"$f":"IFERROR(ROUND(IFERROR(INDEX($CH$7:$CT$20,MATCH(\"Yes\",$CH$7:$CH$20,0),13),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Segment 5",null,null,{"$f":"IFERROR(INDEX($CK$7:$CS$20,MATCH(\"Yes\",$CK$7:$CK$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($CK$7:$CS$20,MATCH(\"Yes\",$CK$7:$CK$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($CK$7:$CX$20,MATCH(\"Yes\",$CK$7:$CK$20,0),12),\"\"),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Segment 5",null,null,{"$f":"IFERROR(INDEX($CN$7:$CS$20,MATCH(\"Yes\",$CN$7:$CN$20,0),2),\"\")","v":""},null,{"$f":"IFERROR(INDEX($CN$7:$CS$20,MATCH(\"Yes\",$CN$7:$CN$20,0),3),\"\")","v":""},null,{"$f":"IFERROR(ROUND(IFERROR(INDEX($CN$7:$CX$20,MATCH(\"Yes\",$CN$7:$CN$20,0),11),\"\"),4),\"\")","v":""}]

{"sheet":"Values","index":2,"n_rows":121,"n_cols":11,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
["Color","Width","Route Type","Counties","Direction","Line Type","Mobile","Corrective Restripe","Project Type","Application Type","District"]
["White",4,"RS","Adair","N","CL","Yes","Yes","District Wide Striping","Temporary","KY-D01"]
["Yellow",6,"MP","Allen","S","EL","No","No","Rehabilitation/Resurfacing","Permanent","KY-D02"]
[null,8,null,"Anderson","E","LL",null,null,null,null,"KY-D03"]
[null,12,null,"Ballard","W","SK",null,null,null,null,"KY-D04"]
[null,null,null,"Barren",null,"GM",null,null,null,null,"KY-D05"]
[null,null,null,"Bath",null,"DTLE",null,null,null,null,"KY-D06"]
[null,null,null,"Bell",null,null,null,null,null,null,"KY-D07"]
[null,null,null,"Boone",null,null,null,null,null,null,"KY-D08"]
[null,null,null,"Bourbon",null,null,null,null,null,null,"KY-D09"]
[null,null,null,"Boyd",null,null,null,null,null,null,"KY-D10"]
[null,null,null,"Boyle",null,null,null,null,null,null,"KY-D11"]
[null,null,null,"Bracken",null,null,null,null,null,null,"KY-D12"]
[null,null,null,"Breathitt"]
[null,null,null,"Breckinridge"]
[null,null,null,"Bullitt"]
[null,null,null,"Butler"]
[null,null,null,"Caldwell"]
[null,null,null,"Calloway"]
[null,null,null,"Campbell"]
[null,null,null,"Carlisle"]
[null,null,null,"Carroll"]
[null,null,null,"Carter"]
[null,null,null,"Casey"]
[null,null,null,"Christian"]
[null,null,null,"Clark"]
[null,null,null,"Clay"]
[null,null,null,"Clinton"]
[null,null,null,"Crittenden"]
[null,null,null,"Cumberland"]
[null,null,null,"Daviess"]
[null,null,null,"Edmonson"]
[null,null,null,"Elliott"]
[null,null,null,"Estill"]
[null,null,null,"Fayette"]
[null,null,null,"Fleming"]
[null,null,null,"Floyd"]
[null,null,null,"Franklin"]
[null,null,null,"Fulton"]
[null,null,null,"Gallatin"]
[null,null,null,"Garrard"]
[null,null,null,"Grant"]
[null,null,null,"Graves"]
[null,null,null,"Grayson"]
[null,null,null,"Green"]
[null,null,null,"Greenup"]
[null,null,null,"Hancock"]
[null,null,null,"Hardin"]
[null,null,null,"Harlan"]
[null,null,null,"Harrison"]
[null,null,null,"Hart"]
[null,null,null,"Henderson"]
[null,null,null,"Henry"]
[null,null,null,"Hickman"]
[null,null,null,"Hopkins"]
[null,null,null,"Jackson"]
[null,null,null,"Jefferson"]
[null,null,null,"Jessamine"]
[null,null,null,"Johnson"]
[null,null,null,"Kenton"]
[null,null,null,"Knott"]
[null,null,null,"Knox"]
[null,null,null,"Larue"]
[null,null,null,"Laurel"]
[null,null,null,"Lawrence"]
[null,null,null,"Lee"]
[null,null,null,"Leslie"]
[null,null,null,"Letcher"]
[null,null,null,"Lewis"]
[null,null,null,"Lincoln"]
[null,null,null,"Livingston"]
[null,null,null,"Logan"]
[null,null,null,"Lyon"]
[null,null,null,"McCracken"]
[null,null,null,"McCreary"]
[null,null,null,"McLean"]
[null,null,null,"Madison"]
[null,null,null,"Magoffin"]
[null,null,null,"Marion"]
[null,null,null,"Marshall"]
[null,null,null,"Martin"]
[null,null,null,"Mason"]
[null,null,null,"Meade"]
[null,null,null,"Menifee"]
[null,null,null,"Mercer"]
[null,null,null,"Metcalfe"]
[null,null,null,"Monroe"]
[null,null,null,"Montgomery"]
[null,null,null,"Morgan"]
[null,null,null,"Muhlenberg"]
[null,null,null,"Nelson"]
[null,null,null,"Nicholas"]
[null,null,null,"Ohio"]
[null,null,null,"Oldham"]
[null,null,null,"Owen"]
[null,null,null,"Owsley"]
[null,null,null,"Pendleton"]
[null,null,null,"Perry"]
[null,null,null,"Pike"]
[null,null,null,"Powell"]
[null,null,null,"Pulaski"]
[null,null,null,"Robertson"]
[null,null,null,"Rockcastle"]
[null,null,null,"Rowan"]
[null,null,null,"Russell"]
[null,null,null,"Scott"]
[null,null,null,"Shelby"]
[null,null,null,"Simpson"]
[null,null,null,"Spencer"]
[null,null,null,"Taylor"]
[null,null,null,"Todd"]
[null,null,null,"Trigg"]
[null,null,null,"Trimble"]
[null,null,null,"Union"]
[null,null,null,"Warren"]
[null,null,null,"Washington"]
[null,null,null,"Wayne"]
[null,null,null,"Webster"]
[null,null,null,"Whitley"]
[null,null,null,"Wolfe"]
[null,null,null,"Woodford"]