{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["WalkListA","Instructions","OUTPUT","PRINT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"WalkListA","index":0,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Survey #","ROW_Number","Address","Count at Address","First","Middle","Last","House Number","Street","City","Birthdate","Reg Date","Status","Voted","Year of Birth","Note","Precinct Name","Postal Code","Opportunity Score","Hottest 33%"]

{"sheet":"Instructions","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Survey #",null,"Steps"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A2,\"0000\")","v":"STL-0000"},null,1,"Paste Values to Worksheet \"WalkList A\" from Source File"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A3,\"0000\")","v":"STL-0000"},null,2,"Enter Mask Code"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A4,\"0000\")","v":"STL-0000"},null,null,null,"Mask Code","STL"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A5,\"0000\")","v":"STL-0000"},null,3,"Drag formula (A2) on this sheet to duplicate #rows on \"WalkList A\""]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A6,\"0000\")","v":"STL-0000"},null,null,null,"Rows in \"Sheet2\"",null,{"$f":"COUNTA(A:A)","v":45}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A7,\"0000\")","v":"STL-0000"},null,null,null,"Rows in \"WalkList A\"",null,{"$f":"COUNTA(WalkListA!A:A)","v":1}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A8,\"0000\")","v":"STL-0000"},null,null,null,null,null,{"$f":"G6=G7","v":false}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A9,\"0000\")","v":"STL-0000"},null,4,"If not double mask on this sheet, then Copy and PasteValues from this sheet's col A to \"WalkList A\" col A"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A10,\"0000\")","v":"STL-0000"},null,5,"The following will now be true"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A11,\"0000\")","v":"STL-0000"},null,null,null,"Survey # on this sheet will have double mask"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A12,\"0000\")","v":"STL-0000"},null,null,null,"Survey # on \"WalkList A\" will now be text, not number"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A13,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A14,\"0000\")","v":"STL-0000"},null,6,"Set Start Count in Range of Start Page to End Page"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A15,\"0000\")","v":"STL-0000"},null,null,"Start Page",{"$f":"VALUE(RIGHT(WalkListA!A2,4))","v":{"$error":"#VALUE!"}},null,"End Page",{"$f":"VALUE(RIGHT(INDEX(A:B,MAX(WalkListA!B:B),1),4))","v":0},null,"row"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A16,\"0000\")","v":"STL-0000"},null,null,null,"Counter",8031,null,"Find",{"$f":"Instructions!F17","v":"STL-8031"},{"$f":"VLOOKUP(I16,WalkListA!A:N,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A17,\"0000\")","v":"STL-0000"},null,null,null,"Pointer",{"$f":"F4&\"-\"&TEXT(F16,\"0000\")","v":"STL-8031"},null,null,{"$f":"F4&\"-\"&TEXT(VALUE(RIGHT(I16,4))+1,\"0000\")","v":"STL-8032"},{"$f":"IF(ISNA(VLOOKUP(I17,WalkListA!A:N,2,FALSE)),MAX(WalkListA!B:B)+1,VLOOKUP(I17,WalkListA!A:N,2,FALSE))","v":1}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A18,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A19,\"0000\")","v":"STL-0000"},null,null,"Rename",{"$f":"PRINT!I2","v":""},"(Used by Macro, for each increment to rename worksheet"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A20,\"0000\")","v":"STL-0000"},null,7,"Enter the packet number on worksheet PRINT"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A21,\"0000\")","v":"STL-0000"},null,8,"Check and/or set printer in Excel by command FILE PRINT"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A22,\"0000\")","v":"STL-0000"},null,9,"Go to worksheet PRINT and click blue Macro Button to generate new workbook of Survey Sheets and printout to default printer"]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A23,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A24,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A25,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A26,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A27,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A28,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A29,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A30,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A31,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A32,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A33,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A34,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A35,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A36,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A37,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A38,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A39,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A40,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A41,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A42,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A43,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A44,\"0000\")","v":"STL-0000"}]
[{"$f":"$F$4&\"-\"&TEXT(WalkListA!A45,\"0000\")","v":"STL-0000"}]

{"sheet":"OUTPUT","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Index","SurveyValue","Address","Count at Address","First","Middle","Last","Birthdate","Reg Date","Status","Voted","Opportunity Score"]
[{"$f":"Instructions!J16","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:N,OUTPUT!$A2,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:O,OUTPUT!$A2,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:O,OUTPUT!$A2,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:O,OUTPUT!$A2,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:P,OUTPUT!$A2,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:P,OUTPUT!$A2,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:P,OUTPUT!$A2,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:P,OUTPUT!$A2,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:Q,OUTPUT!$A2,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:R,OUTPUT!$A2,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A2),INDEX(WalkListA!$A:S,OUTPUT!$A2,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A2<Instructions!$J$17-1,OUTPUT!A2+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:N,OUTPUT!$A3,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:O,OUTPUT!$A3,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:O,OUTPUT!$A3,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:O,OUTPUT!$A3,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:P,OUTPUT!$A3,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:P,OUTPUT!$A3,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:P,OUTPUT!$A3,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:P,OUTPUT!$A3,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:Q,OUTPUT!$A3,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:R,OUTPUT!$A3,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A3),INDEX(WalkListA!$A:S,OUTPUT!$A3,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A3<Instructions!$J$17-1,OUTPUT!A3+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:N,OUTPUT!$A4,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:O,OUTPUT!$A4,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:O,OUTPUT!$A4,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:O,OUTPUT!$A4,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:P,OUTPUT!$A4,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:P,OUTPUT!$A4,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:P,OUTPUT!$A4,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:P,OUTPUT!$A4,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:Q,OUTPUT!$A4,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:R,OUTPUT!$A4,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A4),INDEX(WalkListA!$A:S,OUTPUT!$A4,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A4<Instructions!$J$17-1,OUTPUT!A4+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:N,OUTPUT!$A5,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:O,OUTPUT!$A5,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:O,OUTPUT!$A5,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:O,OUTPUT!$A5,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:P,OUTPUT!$A5,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:P,OUTPUT!$A5,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:P,OUTPUT!$A5,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:P,OUTPUT!$A5,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:Q,OUTPUT!$A5,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:R,OUTPUT!$A5,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A5),INDEX(WalkListA!$A:S,OUTPUT!$A5,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A5<Instructions!$J$17-1,OUTPUT!A5+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:N,OUTPUT!$A6,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:O,OUTPUT!$A6,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:O,OUTPUT!$A6,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:O,OUTPUT!$A6,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:P,OUTPUT!$A6,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:P,OUTPUT!$A6,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:P,OUTPUT!$A6,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:P,OUTPUT!$A6,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:Q,OUTPUT!$A6,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:R,OUTPUT!$A6,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A6),INDEX(WalkListA!$A:S,OUTPUT!$A6,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A6<Instructions!$J$17-1,OUTPUT!A6+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:N,OUTPUT!$A7,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:O,OUTPUT!$A7,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:O,OUTPUT!$A7,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:O,OUTPUT!$A7,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:P,OUTPUT!$A7,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:P,OUTPUT!$A7,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:P,OUTPUT!$A7,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:P,OUTPUT!$A7,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:Q,OUTPUT!$A7,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:R,OUTPUT!$A7,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A7),INDEX(WalkListA!$A:S,OUTPUT!$A7,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A7<Instructions!$J$17-1,OUTPUT!A7+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:N,OUTPUT!$A8,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:O,OUTPUT!$A8,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:O,OUTPUT!$A8,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:O,OUTPUT!$A8,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:P,OUTPUT!$A8,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:P,OUTPUT!$A8,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:P,OUTPUT!$A8,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:P,OUTPUT!$A8,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:Q,OUTPUT!$A8,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:R,OUTPUT!$A8,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A8),INDEX(WalkListA!$A:S,OUTPUT!$A8,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A8<Instructions!$J$17-1,OUTPUT!A8+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:N,OUTPUT!$A9,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:O,OUTPUT!$A9,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:O,OUTPUT!$A9,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:O,OUTPUT!$A9,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:P,OUTPUT!$A9,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:P,OUTPUT!$A9,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:P,OUTPUT!$A9,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:P,OUTPUT!$A9,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:Q,OUTPUT!$A9,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:R,OUTPUT!$A9,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A9),INDEX(WalkListA!$A:S,OUTPUT!$A9,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A9<Instructions!$J$17-1,OUTPUT!A9+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:N,OUTPUT!$A10,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:O,OUTPUT!$A10,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:O,OUTPUT!$A10,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:O,OUTPUT!$A10,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:P,OUTPUT!$A10,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:P,OUTPUT!$A10,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:P,OUTPUT!$A10,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:P,OUTPUT!$A10,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:Q,OUTPUT!$A10,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:R,OUTPUT!$A10,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A10),INDEX(WalkListA!$A:S,OUTPUT!$A10,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A10<Instructions!$J$17-1,OUTPUT!A10+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:N,OUTPUT!$A11,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:O,OUTPUT!$A11,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:O,OUTPUT!$A11,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:O,OUTPUT!$A11,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:P,OUTPUT!$A11,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:P,OUTPUT!$A11,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:P,OUTPUT!$A11,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:P,OUTPUT!$A11,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:Q,OUTPUT!$A11,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:R,OUTPUT!$A11,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A11),INDEX(WalkListA!$A:S,OUTPUT!$A11,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A11<Instructions!$J$17-1,OUTPUT!A11+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:N,OUTPUT!$A12,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:O,OUTPUT!$A12,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:O,OUTPUT!$A12,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:O,OUTPUT!$A12,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:P,OUTPUT!$A12,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:P,OUTPUT!$A12,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:P,OUTPUT!$A12,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:P,OUTPUT!$A12,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:Q,OUTPUT!$A12,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:R,OUTPUT!$A12,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A12),INDEX(WalkListA!$A:S,OUTPUT!$A12,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A12<Instructions!$J$17-1,OUTPUT!A12+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:N,OUTPUT!$A13,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:O,OUTPUT!$A13,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:O,OUTPUT!$A13,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:O,OUTPUT!$A13,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:P,OUTPUT!$A13,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:P,OUTPUT!$A13,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:P,OUTPUT!$A13,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:P,OUTPUT!$A13,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:Q,OUTPUT!$A13,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:R,OUTPUT!$A13,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A13),INDEX(WalkListA!$A:S,OUTPUT!$A13,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A13<Instructions!$J$17-1,OUTPUT!A13+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:N,OUTPUT!$A14,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:O,OUTPUT!$A14,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:O,OUTPUT!$A14,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:O,OUTPUT!$A14,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:P,OUTPUT!$A14,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:P,OUTPUT!$A14,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:P,OUTPUT!$A14,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:P,OUTPUT!$A14,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:Q,OUTPUT!$A14,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:R,OUTPUT!$A14,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A14),INDEX(WalkListA!$A:S,OUTPUT!$A14,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A14<Instructions!$J$17-1,OUTPUT!A14+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:N,OUTPUT!$A15,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:O,OUTPUT!$A15,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:O,OUTPUT!$A15,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:O,OUTPUT!$A15,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:P,OUTPUT!$A15,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:P,OUTPUT!$A15,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:P,OUTPUT!$A15,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:P,OUTPUT!$A15,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:Q,OUTPUT!$A15,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:R,OUTPUT!$A15,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A15),INDEX(WalkListA!$A:S,OUTPUT!$A15,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A15<Instructions!$J$17-1,OUTPUT!A15+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:N,OUTPUT!$A16,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:O,OUTPUT!$A16,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:O,OUTPUT!$A16,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:O,OUTPUT!$A16,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:P,OUTPUT!$A16,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:P,OUTPUT!$A16,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:P,OUTPUT!$A16,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:P,OUTPUT!$A16,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:Q,OUTPUT!$A16,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:R,OUTPUT!$A16,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A16),INDEX(WalkListA!$A:S,OUTPUT!$A16,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A16<Instructions!$J$17-1,OUTPUT!A16+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:N,OUTPUT!$A17,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:O,OUTPUT!$A17,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:O,OUTPUT!$A17,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:O,OUTPUT!$A17,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:P,OUTPUT!$A17,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:P,OUTPUT!$A17,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:P,OUTPUT!$A17,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:P,OUTPUT!$A17,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:Q,OUTPUT!$A17,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:R,OUTPUT!$A17,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A17),INDEX(WalkListA!$A:S,OUTPUT!$A17,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A17<Instructions!$J$17-1,OUTPUT!A17+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:N,OUTPUT!$A18,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:O,OUTPUT!$A18,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:O,OUTPUT!$A18,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:O,OUTPUT!$A18,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:P,OUTPUT!$A18,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:P,OUTPUT!$A18,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:P,OUTPUT!$A18,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:P,OUTPUT!$A18,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:Q,OUTPUT!$A18,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:R,OUTPUT!$A18,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A18),INDEX(WalkListA!$A:S,OUTPUT!$A18,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A18<Instructions!$J$17-1,OUTPUT!A18+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:N,OUTPUT!$A19,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:O,OUTPUT!$A19,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:O,OUTPUT!$A19,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:O,OUTPUT!$A19,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:P,OUTPUT!$A19,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:P,OUTPUT!$A19,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:P,OUTPUT!$A19,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:P,OUTPUT!$A19,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:Q,OUTPUT!$A19,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:R,OUTPUT!$A19,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A19),INDEX(WalkListA!$A:S,OUTPUT!$A19,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A19<Instructions!$J$17-1,OUTPUT!A19+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:N,OUTPUT!$A20,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:O,OUTPUT!$A20,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:O,OUTPUT!$A20,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:O,OUTPUT!$A20,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:P,OUTPUT!$A20,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:P,OUTPUT!$A20,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:P,OUTPUT!$A20,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:P,OUTPUT!$A20,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:Q,OUTPUT!$A20,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:R,OUTPUT!$A20,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A20),INDEX(WalkListA!$A:S,OUTPUT!$A20,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A20<Instructions!$J$17-1,OUTPUT!A20+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:N,OUTPUT!$A21,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:O,OUTPUT!$A21,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:O,OUTPUT!$A21,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:O,OUTPUT!$A21,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:P,OUTPUT!$A21,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:P,OUTPUT!$A21,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:P,OUTPUT!$A21,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:P,OUTPUT!$A21,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:Q,OUTPUT!$A21,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:R,OUTPUT!$A21,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A21),INDEX(WalkListA!$A:S,OUTPUT!$A21,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[{"$f":"IF(A21<Instructions!$J$17-1,OUTPUT!A21+1,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:N,OUTPUT!$A22,COLUMN(WalkListA!$A$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:O,OUTPUT!$A22,COLUMN(WalkListA!$C$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:O,OUTPUT!$A22,COLUMN(WalkListA!$D$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:O,OUTPUT!$A22,COLUMN(WalkListA!$E$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:P,OUTPUT!$A22,COLUMN(WalkListA!$F$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:P,OUTPUT!$A22,COLUMN(WalkListA!$G$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:P,OUTPUT!$A22,COLUMN(WalkListA!$K$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:P,OUTPUT!$A22,COLUMN(WalkListA!$L$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:Q,OUTPUT!$A22,COLUMN(WalkListA!$M$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:R,OUTPUT!$A22,COLUMN(WalkListA!$N$1)),\"\")","v":""},{"$f":"IF(ISNUMBER(A22),INDEX(WalkListA!$A:S,OUTPUT!$A22,COLUMN(WalkListA!$S$1)),\"\")","v":""}]
[]
[]
[]
[null,{"$f":"B2","v":""}]
[null,null,{"$f":"C2","v":""}]
[null,null,{"$f":"E2","v":""}]

{"sheet":"PRINT","index":3,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[37,0,43,10],[0,1,0,2],[0,3,0,7],[0,8,0,10],[1,1,1,2],[1,8,1,10],[1,3,1,7],[2,0,2,2],[2,3,2,10],[3,0,3,2],[3,3,3,10],[5,3,5,10],[28,0,28,1],[28,2,28,10],[29,0,29,10],[36,0,36,10],[6,3,6,10],[7,0,7,2],[9,0,9,2],[27,0,27,1],[27,2,27,10]]}
["Packet Number","Canvassing Date",null,"County",null,null,null,null,"Survey Number"]
[80009,null,null,"ST LOUIS COUNTY",null,null,null,null,{"$f":"OUTPUT!B26","v":""}]
["Canvasser Name / Signature",null,null,"Canvasser Name / Signature"]
[]
["LOCATION INFO"]
[null,null,"Address: ",{"$f":"OUTPUT!C27","v":""}]
[null,null,"Household Members Count: ",{"$f":"OUTPUT!D2","v":""}]
["LOCATION INTERACTION"]
[]
["CONTACT INTERACTION"]
["FIRST","MIDDLE","LAST","Birthdate","OPPORTUNITY SCORE","Responded to Survey","Voted ","Deceased","Type of Ballot\n (M  E  DO)","Nov. 2020 Status\n(R  PA  NK  NU)","Voted per S.O.S."]
[{"$f":"IF(ISTEXT(OUTPUT!E2),OUTPUT!E2,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F2),OUTPUT!F2,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G2),OUTPUT!G2,\"\")","v":""},{"$f":"IF(OUTPUT!H2>0,OUTPUT!H2,\"\")","v":""},{"$f":"IF(OUTPUT!L2>=0,OUTPUT!L2,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K2),LEFT(OUTPUT!K2,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E3),OUTPUT!E3,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F3),OUTPUT!F3,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G3),OUTPUT!G3,\"\")","v":""},{"$f":"IF(OUTPUT!H3>0,OUTPUT!H3,\"\")","v":""},{"$f":"IF(OUTPUT!L3>=0,OUTPUT!L3,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K3),LEFT(OUTPUT!K3,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E4),OUTPUT!E4,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F4),OUTPUT!F4,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G4),OUTPUT!G4,\"\")","v":""},{"$f":"IF(OUTPUT!H4>0,OUTPUT!H4,\"\")","v":""},{"$f":"IF(OUTPUT!L4>=0,OUTPUT!L4,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K4),LEFT(OUTPUT!K4,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E5),OUTPUT!E5,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F5),OUTPUT!F5,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G5),OUTPUT!G5,\"\")","v":""},{"$f":"IF(OUTPUT!H5>0,OUTPUT!H5,\"\")","v":""},{"$f":"IF(OUTPUT!L5>=0,OUTPUT!L5,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K5),LEFT(OUTPUT!K5,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E6),OUTPUT!E6,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F6),OUTPUT!F6,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G6),OUTPUT!G6,\"\")","v":""},{"$f":"IF(OUTPUT!H6>0,OUTPUT!H6,\"\")","v":""},{"$f":"IF(OUTPUT!L6>=0,OUTPUT!L6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K6),LEFT(OUTPUT!K6,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E7),OUTPUT!E7,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F7),OUTPUT!F7,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G7),OUTPUT!G7,\"\")","v":""},{"$f":"IF(OUTPUT!H7>0,OUTPUT!H7,\"\")","v":""},{"$f":"IF(OUTPUT!L7>=0,OUTPUT!L7,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K7),LEFT(OUTPUT!K7,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E8),OUTPUT!E8,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F8),OUTPUT!F8,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G8),OUTPUT!G8,\"\")","v":""},{"$f":"IF(OUTPUT!H8>0,OUTPUT!H8,\"\")","v":""},{"$f":"IF(OUTPUT!L8>=0,OUTPUT!L8,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K8),LEFT(OUTPUT!K8,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E9),OUTPUT!E9,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F9),OUTPUT!F9,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G9),OUTPUT!G9,\"\")","v":""},{"$f":"IF(OUTPUT!H9>0,OUTPUT!H9,\"\")","v":""},{"$f":"IF(OUTPUT!L9>=0,OUTPUT!L9,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K9),LEFT(OUTPUT!K9,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E10),OUTPUT!E10,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F10),OUTPUT!F10,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G10),OUTPUT!G10,\"\")","v":""},{"$f":"IF(OUTPUT!H10>0,OUTPUT!H10,\"\")","v":""},{"$f":"IF(OUTPUT!L10>=0,OUTPUT!L10,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K10),LEFT(OUTPUT!K10,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E11),OUTPUT!E11,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F11),OUTPUT!F11,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G11),OUTPUT!G11,\"\")","v":""},{"$f":"IF(OUTPUT!H11>0,OUTPUT!H11,\"\")","v":""},{"$f":"IF(OUTPUT!L11>=0,OUTPUT!L11,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K11),LEFT(OUTPUT!K11,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E12),OUTPUT!E12,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F12),OUTPUT!F12,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G12),OUTPUT!G12,\"\")","v":""},{"$f":"IF(OUTPUT!H12>0,OUTPUT!H12,\"\")","v":""},{"$f":"IF(OUTPUT!L12>=0,OUTPUT!L12,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K12),LEFT(OUTPUT!K12,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E13),OUTPUT!E13,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F13),OUTPUT!F13,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G13),OUTPUT!G13,\"\")","v":""},{"$f":"IF(OUTPUT!H13>0,OUTPUT!H13,\"\")","v":""},{"$f":"IF(OUTPUT!L13>=0,OUTPUT!L13,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K13),LEFT(OUTPUT!K13,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E14),OUTPUT!E14,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F14),OUTPUT!F14,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G14),OUTPUT!G14,\"\")","v":""},{"$f":"IF(OUTPUT!H14>0,OUTPUT!H14,\"\")","v":""},{"$f":"IF(OUTPUT!L14>=0,OUTPUT!L14,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K14),LEFT(OUTPUT!K14,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E15),OUTPUT!E15,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F15),OUTPUT!F15,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G15),OUTPUT!G15,\"\")","v":""},{"$f":"IF(OUTPUT!H15>0,OUTPUT!H15,\"\")","v":""},{"$f":"IF(OUTPUT!L15>=0,OUTPUT!L15,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K15),LEFT(OUTPUT!K15,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E16),OUTPUT!E16,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F16),OUTPUT!F16,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G16),OUTPUT!G16,\"\")","v":""},{"$f":"IF(OUTPUT!H16>0,OUTPUT!H16,\"\")","v":""},{"$f":"IF(OUTPUT!L16>=0,OUTPUT!L16,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K16),LEFT(OUTPUT!K16,1),\"\")","v":""}]
[{"$f":"IF(ISTEXT(OUTPUT!E17),OUTPUT!E17,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!F17),OUTPUT!F17,\"\")","v":""},{"$f":"IF(ISTEXT(OUTPUT!G17),OUTPUT!G17,\"\")","v":""},{"$f":"IF(OUTPUT!H17>0,OUTPUT!H17,\"\")","v":""},{"$f":"IF(OUTPUT!L17>=0,OUTPUT!L17,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISTEXT(OUTPUT!K17),LEFT(OUTPUT!K17,1),\"\")","v":""}]
["Type of Ballot:",null,"Nov. 2020 Status:"]
["M = mail-in ballot\nE = early in-person\nDO = day of election",null,"R = Resident\nPA = Permanent Address\nNK = Not Known \nNU = Known to Resident but was not using this address"]
["SURVEY QUESTIONS"]
[null,null,null,null,null,null,"Number of registered voters at this address in Nov 2020: "]
[null,null,null,null,null,null,"Number of mail-in ballots received: "]
[null,null,null,null,null,null,"Number of main-in ballots requested: "]
[null,null,null,null,null,null,"Number of mail-in ballots received for people not at this address: "]
[]
[null,null,null,null,null,null,"Is it ok if someone contacts you in the future about the information you shared today?: "]
["CANVASSER NOTES"]