{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rollup","Individual Report","Distances","Data_Dump"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Rollup","index":0,"n_rows":22,"n_cols":24,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,23],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,22],[1,23,2,23]]}
["SDN Attendance 2013 (Google Docs Data)"]
[null,null,null,"CY 2012 to Date",null,"1st Qtr\n(Jan - Mar)",null,"2nd Qtr\n(Apr - June)",null,"3rd Qtr\n(Jul - Sep)",null,"4th Qtr\n(Oct - Dec)",null,"2012 Total",null,"Type",null,null,null,null,null,null,null,"Notes"]
["#","Name","Membership Date","#","%","#","%","#","%","#","%","#","%","#","%","Training","Exercise","Meeting","Demo","Search","TF Training","Other","Total"]
[1,"Jeannette Bayer","2009-04-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B4 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D4/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B4&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":10},{"$f":"F4/F$22","v":0.41666666666666669},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B4&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":6},{"$f":"H4/H$22","v":0.4},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B4&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$f":"J4/J$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B4&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$f":"L4/L$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B4&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},{"$f":"N4/N$22","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":11},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":3},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B4 & \"*\")","v":1},{"$f":"SUM(P4:V4)","v":16}]
[2,"Katie Breland","Mrch 2001",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B5 & \"*\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B5&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":14},0.58333333333333337,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B5&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":5},0.33333333333333331,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B5&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B5&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B5&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":12},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":5},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B5 & \"*\")","v":0},19]
[3,"Bill Dozier","2009-05-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B6 & \"*\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B6&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":20},0.83333333333333337,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B6&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":12},0.8,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B6&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B6&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B6&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":24},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":3},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B6 & \"*\")","v":0},32]
[4,"Kelly Dozier","2009-11-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B7 & \"*\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B7&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":8},0.33333333333333331,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B7&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":4},0.26666666666666666,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B7&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B7&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B7&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":8},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":3},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B7 & \"*\")","v":0},12]
[5,"Cindy Grant","1999-09-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B8 & \"*\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B8&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":15},0.625,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B8&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":11},0.73333333333333328,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B8&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B8&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B8&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":17},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":6},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B8 & \"*\")","v":2},26]
[6,"Mary Haislet","2006-09-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B9 & \"*\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B9&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":19},0.79166666666666663,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B9&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":12},0.8,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B9&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B9&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B9&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":23},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B9 & \"*\")","v":3},31]
[7,"Joel Harms","2013-01-01",null,null,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B10&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":12},0.5,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B10&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":3},0.2,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B10&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B10&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B10&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":15},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B10 & \"*\")","v":0},{"$f":"SUM(P10:V10)","v":15},"In NM for the summer"]
[8,"D'Lynn Lehew","2009-10-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B11 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D11/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B11&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":5},0.20833333333333334,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B11&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":2},0.13333333333333333,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B11&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B11&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B11&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":3},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":3},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B11 & \"*\")","v":0},7]
[9,"Teresa Medearis","2012-07-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B12 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D12/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B12&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":15},0.625,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B12&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":10},0.66666666666666663,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B12&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B12&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B12&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":19},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B12 & \"*\")","v":2},25]
[10,"Ellen Mitchell","2011-06-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B13 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D13/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B13&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":8},0.33333333333333331,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B13&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":7},0.46666666666666667,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B13&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B13&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B13&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":12},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B13 & \"*\")","v":1},{"$f":"SUM(P13:V13)","v":15}]
[11,"Ronnie Perry","2006-04-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B14 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D14/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B14&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":8},0.33333333333333331,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B14&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":7},0.46666666666666667,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B14&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B14&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B14&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":7},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":5},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B14 & \"*\")","v":1},15]
[12,"Lois Pritchard","2012-07-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B15 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D15/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B15&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":13},0.54166666666666663,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B15&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":11},0.73333333333333328,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B15&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B15&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B15&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":17},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B15 & \"*\")","v":3},24]
[13,"Deb Randolph","??",null,null,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B16&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B16&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B16&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B16&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$error":"#REF!"},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B16&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B16 & \"*\")","v":0},{"$f":"SUM(P16:V16)","v":0},"Medical Leave"]
[14,"Tim Scott","2009-04-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B17 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D17/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B17&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":12},{"$f":"F17/F$22","v":0.5},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B17&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":6},{"$f":"H17/H$22","v":0.4},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B17&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$f":"J17/J$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B17&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$f":"L17/L$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B17&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":12},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":2},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B17 & \"*\")","v":1},18]
[15,"Blanton Smith","2012-03-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B18 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D18/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B18&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":13},{"$f":"F18/F$22","v":0.54166666666666663},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B18&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":5},{"$f":"H18/H$22","v":0.33333333333333331},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B18&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$f":"J18/J$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B18&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$f":"L18/L$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B18&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":16},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B18 & \"*\")","v":0},18]
[16,"Jim Yeager","1997-06-01",{"$f":"COUNTIF(Data_Dump!#REF!,\"*\" & Rollup!$B19 & \"*\")","v":{"$error":"#REF!"}},{"$f":"D19/$D$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B19&\"*\",Data_Dump!$B:$B,\">=\"&F$21,Data_Dump!$B:$B,\"<=\"&H$21)","v":14},{"$f":"F19/F$22","v":0.58333333333333337},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B19&\"*\",Data_Dump!$B:$B,\">=\"&H$21,Data_Dump!$B:$B,\"<=\"&I$21)","v":6},{"$f":"H19/H$22","v":0.4},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B19&\"*\",Data_Dump!$B:$B,\">=\"&J$21,Data_Dump!$B:$B,\"<=\"&L$21)","v":0},{"$f":"J19/J$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B19&\"*\",Data_Dump!$B:$B,\">=\"&L$21,Data_Dump!$B:$B,\"<=\"&M$21)","v":0},{"$f":"L19/L$22","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(Data_Dump!$E:$E,\"*\"&Rollup!$B19&\"*\",Data_Dump!$B:$B,\">=\"&N$21,Data_Dump!$B:$B,\"<=\"&O$21)","v":0},0,{"$f":"COUNTIFS(Data_Dump!$D:$D,P$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":16},{"$f":"COUNTIFS(Data_Dump!$D:$D,Q$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,R$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,S$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,T$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":0},{"$f":"COUNTIFS(Data_Dump!$D:$D,U$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":1},{"$f":"COUNTIFS(Data_Dump!$D:$D,V$3,Data_Dump!$E:$E,\"*\" & Rollup!$B19 & \"*\")","v":0},20]
[]
[null,null,"Qtr Begin / End",null,"Begin","2013-01-01","2013-03-31","2013-04-01","2013-06-30","2012-07-01","2012-09-30","2012-10-01","2012-12-31","2012-01-01","2012-12-31"]
[null,null,"# Opportunities",{"$f":"SUM(IF(FREQUENCY(Data_Dump!#REF!,Data_Dump!#REF!)>0,1))","v":{"$error":"#REF!"}},null,{"$f":"SUM(IF(FREQUENCY(Data_Dump!B2:B38,Data_Dump!B2:B38)>0,1))","v":24},null,{"$f":"SUM(IF(FREQUENCY(Data_Dump!B39:B99,Data_Dump!B39:B99)>0,1))","v":15},null,{"$f":"SUM(IF(FREQUENCY(Data_Dump!#REF!,Data_Dump!#REF!)>0,1))","v":{"$error":"#REF!"}},null,{"$f":"SUM(IF(FREQUENCY(Data_Dump!#REF!,Data_Dump!#REF!)>0,1))","v":{"$error":"#REF!"}},null,{"$f":"SUM(IF(FREQUENCY(Data_Dump!B2:B149,Data_Dump!B2:B149)>0,1))","v":39}]

{"sheet":"Individual Report","index":1,"n_rows":155,"n_cols":8,"rows_kept":155,"cut":false,"hidden":false,"merged":[[0,0,0,1],[147,3,147,4]]}
[{"$f":"\"SDN Individual Attendance Report 2012 as of \" & TEXT(TODAY(),\"DD MMM YYYY\")","v":"SDN Individual Attendance Report 2012 as of 16 May 2013"},null,"Total Events",{"$f":"COUNTIF(D3:D147,\"X\")","v":15}]
["Date","Location / Event","Type","Joel Harms","Distance"]
[{"$f":"Data_Dump!B2","v":"2013-01-05"},{"$f":"Data_Dump!C2","v":"Lake Bryan"},{"$f":"Data_Dump!D2","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E2,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B3,Distances!$A$5:$A$83,0)),0)","v":20},null,null,"Jeannette Bayer"]
[{"$f":"Data_Dump!B3","v":"2013-01-08"},{"$f":"Data_Dump!C3","v":"CTOMA"},{"$f":"Data_Dump!D3","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E3,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B4,Distances!$A$5:$A$83,0)),0)","v":808},null,null,"Katie Breland"]
[{"$f":"Data_Dump!B4","v":"2013-01-12"},{"$f":"Data_Dump!C4","v":"Cotton Ranch"},{"$f":"Data_Dump!D4","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E4,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B5,Distances!$A$5:$A$83,0)),0)","v":34.799999999999997},null,null,"Bill Dozier"]
[{"$f":"Data_Dump!B5","v":"2013-01-12"},{"$f":"Data_Dump!C5","v":"Canyon Lake"},{"$f":"Data_Dump!D5","v":"Other"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E5,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B6,Distances!$A$5:$A$83,0)),0)","v":308},null,null,"Kelly Dozier"]
[{"$f":"Data_Dump!B6","v":"2013-01-15"},{"$f":"Data_Dump!C6","v":"Veteran's Park"},{"$f":"Data_Dump!D6","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E6,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B7,Distances!$A$5:$A$83,0)),0)","v":7.2},null,null,"Cindy Grant"]
[{"$f":"Data_Dump!B7","v":"2013-01-19"},{"$f":"Data_Dump!C7","v":"Cotton Ranch south"},{"$f":"Data_Dump!D7","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E7,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B8,Distances!$A$5:$A$83,0)),0)","v":30.6},null,null,"Mary Haislet"]
[{"$f":"Data_Dump!B8","v":"2013-01-22"},{"$f":"Data_Dump!C8","v":"Mary's house"},{"$f":"Data_Dump!D8","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E8,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B9,Distances!$A$5:$A$83,0)),0)","v":19},null,null,"Joel Harms"]
[{"$f":"Data_Dump!B9","v":"2013-01-26"},{"$f":"Data_Dump!C9","v":"Jones ranch"},{"$f":"Data_Dump!D9","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E9,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B10,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}},null,null,"D'Lynn Lehew"]
[{"$f":"Data_Dump!B10","v":"2013-01-26"},{"$f":"Data_Dump!C10","v":"Disaster City"},{"$f":"Data_Dump!D10","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E10,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B11,Distances!$A$5:$A$83,0)),0)","v":14.4},null,null,"Teresa Medearis"]
[{"$f":"Data_Dump!B11","v":"2013-01-26"},{"$f":"Data_Dump!C11","v":"Jones Forest"},{"$f":"Data_Dump!D11","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E11,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B12,Distances!$A$5:$A$83,0)),0)","v":136.19999999999999},null,null,"Ellen Mitchell"]
[{"$f":"Data_Dump!B12","v":"2013-01-29"},{"$f":"Data_Dump!C12","v":"Veteran's Park"},{"$f":"Data_Dump!D12","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E12,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B13,Distances!$A$5:$A$83,0)),0)","v":7.2},null,null,"Ronnie Perry"]
[{"$f":"Data_Dump!B13","v":"2013-01-29"},{"$f":"Data_Dump!C13","v":"Jim's house"},{"$f":"Data_Dump!D13","v":"Other"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E13,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B14,Distances!$A$5:$A$83,0)),0)","v":7.6},null,null,"Lois Pritchard"]
[{"$f":"Data_Dump!B14","v":"2013-02-02"},{"$f":"Data_Dump!C14","v":"Lake Bryan"},{"$f":"Data_Dump!D14","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E14,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B15,Distances!$A$5:$A$83,0)),0)","v":20},null,null,"Deb Randolph"]
[{"$f":"Data_Dump!B15","v":"2013-02-09"},{"$f":"Data_Dump!C15","v":"Rooney Ranch"},{"$f":"Data_Dump!D15","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E15,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B16,Distances!$A$5:$A$83,0)),0)","v":27},null,null,"Tim Scott"]
[{"$f":"Data_Dump!B16","v":"2013-02-12"},{"$f":"Data_Dump!C16","v":"Riverside"},{"$f":"Data_Dump!D16","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E16,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B17,Distances!$A$5:$A$83,0)),0)","v":23},null,null,"Blanton Smith"]
[{"$f":"Data_Dump!B17","v":"2013-02-16"},{"$f":"Data_Dump!C17","v":"Lake Bryan"},{"$f":"Data_Dump!D17","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E17,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B18,Distances!$A$5:$A$83,0)),0)","v":20},null,null,"Jim Yeager"]
[{"$f":"Data_Dump!B18","v":"2013-02-16"},{"$f":"Data_Dump!C18","v":"Disaster City"},{"$f":"Data_Dump!D18","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E18,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B19,Distances!$A$5:$A$83,0)),0)","v":14.4}]
[{"$f":"Data_Dump!B19","v":"2013-02-19"},{"$f":"Data_Dump!C19","v":"Veteran's Park"},{"$f":"Data_Dump!D19","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E19,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B20,Distances!$A$5:$A$83,0)),0)","v":7.2}]
[{"$f":"Data_Dump!B20","v":"2013-02-19"},{"$f":"Data_Dump!C20","v":"Katie's House"},{"$f":"Data_Dump!D20","v":"Meeting"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E20,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B21,Distances!$A$5:$A$83,0)),0)","v":21.6}]
[{"$f":"Data_Dump!B21","v":"2013-02-19"},{"$f":"Data_Dump!C21","v":"Reed arena"},{"$f":"Data_Dump!D21","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E21,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B22,Distances!$A$5:$A$83,0)),0)","v":6.8}]
[{"$f":"Data_Dump!B22","v":"2013-02-23"},{"$f":"Data_Dump!C22","v":"Cotton Ranch"},{"$f":"Data_Dump!D22","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E22,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B23,Distances!$A$5:$A$83,0)),0)","v":34.799999999999997}]
[{"$f":"Data_Dump!B23","v":"2013-02-26"},{"$f":"Data_Dump!C23","v":"Austin's colony"},{"$f":"Data_Dump!D23","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E23,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B24,Distances!$A$5:$A$83,0)),0)","v":6.2}]
[{"$f":"Data_Dump!B24","v":"2013-02-26"},{"$f":"Data_Dump!C24","v":"Austin's Colony"},{"$f":"Data_Dump!D24","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E24,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B25,Distances!$A$5:$A$83,0)),0)","v":6.2}]
[{"$f":"Data_Dump!B25","v":"2013-03-02"},{"$f":"Data_Dump!C25","v":"Lake Bryan"},{"$f":"Data_Dump!D25","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E25,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B26,Distances!$A$5:$A$83,0)),0)","v":20}]
[{"$f":"Data_Dump!B26","v":"2013-03-02"},{"$f":"Data_Dump!C26","v":"Disaster City"},{"$f":"Data_Dump!D26","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E26,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B27,Distances!$A$5:$A$83,0)),0)","v":14.4}]
[{"$f":"Data_Dump!B27","v":"2013-03-05"},{"$f":"Data_Dump!C27","v":"Cotton Ranch"},{"$f":"Data_Dump!D27","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E27,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B28,Distances!$A$5:$A$83,0)),0)","v":34.799999999999997}]
[{"$f":"Data_Dump!B28","v":"2013-03-05"},{"$f":"Data_Dump!C28","v":"California"},{"$f":"Data_Dump!D28","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E28,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B29,Distances!$A$5:$A$83,0)),0)","v":0}]
[{"$f":"Data_Dump!B29","v":"2013-03-05"},{"$f":"Data_Dump!C29","v":"TAMU"},{"$f":"Data_Dump!D29","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E29,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B30,Distances!$A$5:$A$83,0)),0)","v":5.4}]
[{"$f":"Data_Dump!B30","v":"2013-03-08"},{"$f":"Data_Dump!C30","v":"Disaster City"},{"$f":"Data_Dump!D30","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E30,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B31,Distances!$A$5:$A$83,0)),0)","v":14.4}]
[{"$f":"Data_Dump!B31","v":"2013-03-09"},{"$f":"Data_Dump!C31","v":"Masser Ranch"},{"$f":"Data_Dump!D31","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E31,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B32,Distances!$A$5:$A$83,0)),0)","v":57}]
[{"$f":"Data_Dump!B32","v":"2013-03-12"},{"$f":"Data_Dump!C32","v":"Cotton Ranch"},{"$f":"Data_Dump!D32","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E32,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B33,Distances!$A$5:$A$83,0)),0)","v":34.799999999999997}]
[{"$f":"Data_Dump!B33","v":"2013-03-12"},{"$f":"Data_Dump!C33","v":"Tonkaway Ranch"},{"$f":"Data_Dump!D33","v":"Other"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E33,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B34,Distances!$A$5:$A$83,0)),0)","v":24.8}]
[{"$f":"Data_Dump!B34","v":"2013-03-16"},{"$f":"Data_Dump!C34","v":"Cotton Ranch South"},{"$f":"Data_Dump!D34","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E34,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B35,Distances!$A$5:$A$83,0)),0)","v":30.6}]
[{"$f":"Data_Dump!B35","v":"2013-03-19"},{"$f":"Data_Dump!C35","v":"Hensel Park"},{"$f":"Data_Dump!D35","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E35,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B36,Distances!$A$5:$A$83,0)),0)","v":4.8}]
[{"$f":"Data_Dump!B36","v":"2013-03-19"},{"$f":"Data_Dump!C36","v":"CEOC"},{"$f":"Data_Dump!D36","v":"Meeting"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E36,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B37,Distances!$A$5:$A$83,0)),0)","v":7.2}]
[{"$f":"Data_Dump!B37","v":"2013-03-20"},{"$f":"Data_Dump!C37","v":"TAMU"},{"$f":"Data_Dump!D37","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E37,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B38,Distances!$A$5:$A$83,0)),0)","v":5.4}]
[{"$f":"Data_Dump!B38","v":"2013-03-26"},{"$f":"Data_Dump!C38","v":"Austin's Colony"},{"$f":"Data_Dump!D38","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E38,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B39,Distances!$A$5:$A$83,0)),0)","v":6.2}]
[{"$f":"Data_Dump!B39","v":"2013-03-30"},{"$f":"Data_Dump!C39","v":"Lick Creek"},{"$f":"Data_Dump!D39","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E39,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B40,Distances!$A$5:$A$83,0)),0)","v":20.399999999999999}]
[{"$f":"Data_Dump!B40","v":"2013-04-04"},{"$f":"Data_Dump!C40","v":"Wellborn"},{"$f":"Data_Dump!D40","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E40,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B41,Distances!$A$5:$A$83,0)),0)","v":20}]
[{"$f":"Data_Dump!B41","v":"2013-04-04"},{"$f":"Data_Dump!C41","v":"TAMU"},{"$f":"Data_Dump!D41","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E41,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B42,Distances!$A$5:$A$83,0)),0)","v":5.4}]
[{"$f":"Data_Dump!B42","v":"2013-04-06"},{"$f":"Data_Dump!C42","v":"Lake Bryan"},{"$f":"Data_Dump!D42","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E42,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B43,Distances!$A$5:$A$83,0)),0)","v":20}]
[{"$f":"Data_Dump!B43","v":"2013-04-06"},{"$f":"Data_Dump!C43","v":"Jones Forest"},{"$f":"Data_Dump!D43","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E43,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B44,Distances!$A$5:$A$83,0)),0)","v":136.19999999999999}]
[{"$f":"Data_Dump!B44","v":"2013-04-09"},{"$f":"Data_Dump!C44","v":"CSFD Station 5"},{"$f":"Data_Dump!D44","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E44,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B45,Distances!$A$5:$A$83,0)),0)","v":20}]
[{"$f":"Data_Dump!B45","v":"2013-04-09"},{"$f":"Data_Dump!C45","v":"Other"},{"$f":"Data_Dump!D45","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E45,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B46,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B46","v":"2013-04-13"},{"$f":"Data_Dump!C46","v":"Lake Bryan"},{"$f":"Data_Dump!D46","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E46,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B47,Distances!$A$5:$A$83,0)),0)","v":20}]
[{"$f":"Data_Dump!B47","v":"2013-04-16"},{"$f":"Data_Dump!C47","v":"Hensel park"},{"$f":"Data_Dump!D47","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E47,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B48,Distances!$A$5:$A$83,0)),0)","v":4.8}]
[{"$f":"Data_Dump!B48","v":"2013-04-18"},{"$f":"Data_Dump!C48","v":"Kroger"},{"$f":"Data_Dump!D48","v":"Meeting"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E48,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B49,Distances!$A$5:$A$83,0)),0)","v":5.2}]
[{"$f":"Data_Dump!B49","v":"2013-04-20"},{"$f":"Data_Dump!C49","v":"Vet School"},{"$f":"Data_Dump!D49","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E49,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B50,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B50","v":"2013-04-23"},{"$f":"Data_Dump!C50","v":"Austin's Colony"},{"$f":"Data_Dump!D50","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E50,0)>0),\"X\",\"N\")","v":"X"},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B51,Distances!$A$5:$A$83,0)),0)","v":6.2}]
[{"$f":"Data_Dump!B51","v":"2013-04-27"},{"$f":"Data_Dump!C51","v":"Black Jack Ranch"},{"$f":"Data_Dump!D51","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E51,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B52,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B52","v":"2013-04-27"},{"$f":"Data_Dump!C52","v":"Boat work day"},{"$f":"Data_Dump!D52","v":"Other"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E52,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B53,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B53","v":"2013-04-30"},{"$f":"Data_Dump!C53","v":"cotton ranch"},{"$f":"Data_Dump!D53","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E53,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B54,Distances!$A$5:$A$83,0)),0)","v":34.799999999999997}]
[{"$f":"Data_Dump!B54","v":"2013-05-04"},{"$f":"Data_Dump!C54","v":"Aggieland humane society"},{"$f":"Data_Dump!D54","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E54,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B55,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B55","v":"2013-05-04"},{"$f":"Data_Dump!C55","v":"Gateway"},{"$f":"Data_Dump!D55","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E55,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B56,Distances!$A$5:$A$83,0)),0)","v":0}]
[{"$f":"Data_Dump!B56","v":"2013-05-04"},{"$f":"Data_Dump!C56","v":"Disaster City"},{"$f":"Data_Dump!D56","v":"TF Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E56,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B57,Distances!$A$5:$A$83,0)),0)","v":14.4}]
[{"$f":"Data_Dump!B57","v":"2013-05-04"},{"$f":"Data_Dump!C57","v":"Washington co. EMS"},{"$f":"Data_Dump!D57","v":"Other"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E57,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B58,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B58","v":"2013-05-07"},{"$f":"Data_Dump!C58","v":"Veteran's Park"},{"$f":"Data_Dump!D58","v":"Training"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E58,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B59,Distances!$A$5:$A$83,0)),0)","v":7.2}]
[{"$f":"Data_Dump!B59","v":"2013-05-11"},{"$f":"Data_Dump!C59","v":"Lake Somerville"},{"$f":"Data_Dump!D59","v":"Exercise"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E59,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B60,Distances!$A$5:$A$83,0)),0)","v":74}]
[{"$f":"Data_Dump!B60","v":"2013-05-14"},{"$f":"Data_Dump!C60","v":"Vet School"},{"$f":"Data_Dump!D60","v":"Demo"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E60,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B61,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B61","v":"00:00:00"},{"$f":"Data_Dump!C61","v":"00:00:00"},{"$f":"Data_Dump!D61","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E61,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B62,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B62","v":"00:00:00"},{"$f":"Data_Dump!C62","v":"00:00:00"},{"$f":"Data_Dump!D62","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E62,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B63,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B63","v":"00:00:00"},{"$f":"Data_Dump!C63","v":"00:00:00"},{"$f":"Data_Dump!D63","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E63,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B64,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B64","v":"00:00:00"},{"$f":"Data_Dump!C64","v":"00:00:00"},{"$f":"Data_Dump!D64","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E64,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B65,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B65","v":"00:00:00"},{"$f":"Data_Dump!C65","v":"00:00:00"},{"$f":"Data_Dump!D65","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E65,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B66,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B66","v":"00:00:00"},{"$f":"Data_Dump!C66","v":"00:00:00"},{"$f":"Data_Dump!D66","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E66,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B67,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B67","v":"00:00:00"},{"$f":"Data_Dump!C67","v":"00:00:00"},{"$f":"Data_Dump!D67","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E67,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B68,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B68","v":"00:00:00"},{"$f":"Data_Dump!C68","v":"00:00:00"},{"$f":"Data_Dump!D68","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E68,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B69,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B69","v":"00:00:00"},{"$f":"Data_Dump!C69","v":"00:00:00"},{"$f":"Data_Dump!D69","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E69,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B70,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B70","v":"00:00:00"},{"$f":"Data_Dump!C70","v":"00:00:00"},{"$f":"Data_Dump!D70","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E70,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B71,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B71","v":"00:00:00"},{"$f":"Data_Dump!C71","v":"00:00:00"},{"$f":"Data_Dump!D71","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E71,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B72,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B72","v":"00:00:00"},{"$f":"Data_Dump!C72","v":"00:00:00"},{"$f":"Data_Dump!D72","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E72,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B73,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B73","v":"00:00:00"},{"$f":"Data_Dump!C73","v":"00:00:00"},{"$f":"Data_Dump!D73","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E73,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B74,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B74","v":"00:00:00"},{"$f":"Data_Dump!C74","v":"00:00:00"},{"$f":"Data_Dump!D74","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E74,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B75,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B75","v":"00:00:00"},{"$f":"Data_Dump!C75","v":"00:00:00"},{"$f":"Data_Dump!D75","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E75,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B76,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B76","v":"00:00:00"},{"$f":"Data_Dump!C76","v":"00:00:00"},{"$f":"Data_Dump!D76","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E76,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B77,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B77","v":"00:00:00"},{"$f":"Data_Dump!C77","v":"00:00:00"},{"$f":"Data_Dump!D77","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E77,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B78,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B78","v":"00:00:00"},{"$f":"Data_Dump!C78","v":"00:00:00"},{"$f":"Data_Dump!D78","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E78,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B79,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B79","v":"00:00:00"},{"$f":"Data_Dump!C79","v":"00:00:00"},{"$f":"Data_Dump!D79","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E79,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B80,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B80","v":"00:00:00"},{"$f":"Data_Dump!C80","v":"00:00:00"},{"$f":"Data_Dump!D80","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E80,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B81,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B81","v":"00:00:00"},{"$f":"Data_Dump!C81","v":"00:00:00"},{"$f":"Data_Dump!D81","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E81,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B82,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B82","v":"00:00:00"},{"$f":"Data_Dump!C82","v":"00:00:00"},{"$f":"Data_Dump!D82","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E82,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B83,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B83","v":"00:00:00"},{"$f":"Data_Dump!C83","v":"00:00:00"},{"$f":"Data_Dump!D83","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E83,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B84,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B84","v":"00:00:00"},{"$f":"Data_Dump!C84","v":"00:00:00"},{"$f":"Data_Dump!D84","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E84,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B85,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B85","v":"00:00:00"},{"$f":"Data_Dump!C85","v":"00:00:00"},{"$f":"Data_Dump!D85","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E85,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B86,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B86","v":"00:00:00"},{"$f":"Data_Dump!C86","v":"00:00:00"},{"$f":"Data_Dump!D86","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E86,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B87,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B87","v":"00:00:00"},{"$f":"Data_Dump!C87","v":"00:00:00"},{"$f":"Data_Dump!D87","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E87,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B88,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B88","v":"00:00:00"},{"$f":"Data_Dump!C88","v":"00:00:00"},{"$f":"Data_Dump!D88","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E88,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B89,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B89","v":"00:00:00"},{"$f":"Data_Dump!C89","v":"00:00:00"},{"$f":"Data_Dump!D89","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E89,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B90,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B90","v":"00:00:00"},{"$f":"Data_Dump!C90","v":"00:00:00"},{"$f":"Data_Dump!D90","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E90,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B91,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B91","v":"00:00:00"},{"$f":"Data_Dump!C91","v":"00:00:00"},{"$f":"Data_Dump!D91","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E91,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B92,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B92","v":"00:00:00"},{"$f":"Data_Dump!C92","v":"00:00:00"},{"$f":"Data_Dump!D92","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E92,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B93,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B93","v":"00:00:00"},{"$f":"Data_Dump!C93","v":"00:00:00"},{"$f":"Data_Dump!D93","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E93,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B94,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B94","v":"00:00:00"},{"$f":"Data_Dump!C94","v":"00:00:00"},{"$f":"Data_Dump!D94","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E94,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B95,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B95","v":"00:00:00"},{"$f":"Data_Dump!C95","v":"00:00:00"},{"$f":"Data_Dump!D95","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E95,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B96,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B96","v":"00:00:00"},{"$f":"Data_Dump!C96","v":"00:00:00"},{"$f":"Data_Dump!D96","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E96,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B97,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B97","v":"00:00:00"},{"$f":"Data_Dump!C97","v":"00:00:00"},{"$f":"Data_Dump!D97","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E97,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B98,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B98","v":"00:00:00"},{"$f":"Data_Dump!C98","v":"00:00:00"},{"$f":"Data_Dump!D98","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E98,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B99,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B99","v":"00:00:00"},{"$f":"Data_Dump!C99","v":"00:00:00"},{"$f":"Data_Dump!D99","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E99,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B100,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B100","v":"00:00:00"},{"$f":"Data_Dump!C100","v":"00:00:00"},{"$f":"Data_Dump!D100","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E100,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B101,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B101","v":"00:00:00"},{"$f":"Data_Dump!C101","v":"00:00:00"},{"$f":"Data_Dump!D101","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E101,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B102,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B102","v":"00:00:00"},{"$f":"Data_Dump!C102","v":"00:00:00"},{"$f":"Data_Dump!D102","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E102,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B103,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B103","v":"00:00:00"},{"$f":"Data_Dump!C103","v":"00:00:00"},{"$f":"Data_Dump!D103","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E103,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B104,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B104","v":"00:00:00"},{"$f":"Data_Dump!C104","v":"00:00:00"},{"$f":"Data_Dump!D104","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E104,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B105,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B105","v":"00:00:00"},{"$f":"Data_Dump!C105","v":"00:00:00"},{"$f":"Data_Dump!D105","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E105,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B106,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B106","v":"00:00:00"},{"$f":"Data_Dump!C106","v":"00:00:00"},{"$f":"Data_Dump!D106","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E106,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B107,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B107","v":"00:00:00"},{"$f":"Data_Dump!C107","v":"00:00:00"},{"$f":"Data_Dump!D107","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E107,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B108,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B108","v":"00:00:00"},{"$f":"Data_Dump!C108","v":"00:00:00"},{"$f":"Data_Dump!D108","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E108,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B109,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B109","v":"00:00:00"},{"$f":"Data_Dump!C109","v":"00:00:00"},{"$f":"Data_Dump!D109","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E109,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B110,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B110","v":"00:00:00"},{"$f":"Data_Dump!C110","v":"00:00:00"},{"$f":"Data_Dump!D110","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E110,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B111,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B111","v":"00:00:00"},{"$f":"Data_Dump!C111","v":"00:00:00"},{"$f":"Data_Dump!D111","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E111,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B112,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B112","v":"00:00:00"},{"$f":"Data_Dump!C112","v":"00:00:00"},{"$f":"Data_Dump!D112","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E112,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B113,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B113","v":"00:00:00"},{"$f":"Data_Dump!C113","v":"00:00:00"},{"$f":"Data_Dump!D113","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E113,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B114,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B114","v":"00:00:00"},{"$f":"Data_Dump!C114","v":"00:00:00"},{"$f":"Data_Dump!D114","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E114,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B115,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B115","v":"00:00:00"},{"$f":"Data_Dump!C115","v":"00:00:00"},{"$f":"Data_Dump!D115","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E115,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B116,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B116","v":"00:00:00"},{"$f":"Data_Dump!C116","v":"00:00:00"},{"$f":"Data_Dump!D116","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E116,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B117,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B117","v":"00:00:00"},{"$f":"Data_Dump!C117","v":"00:00:00"},{"$f":"Data_Dump!D117","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E117,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B118,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B118","v":"00:00:00"},{"$f":"Data_Dump!C118","v":"00:00:00"},{"$f":"Data_Dump!D118","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E118,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B119,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B119","v":"00:00:00"},{"$f":"Data_Dump!C119","v":"00:00:00"},{"$f":"Data_Dump!D119","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E119,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B120,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B120","v":"00:00:00"},{"$f":"Data_Dump!C120","v":"00:00:00"},{"$f":"Data_Dump!D120","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E120,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B121,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B121","v":"00:00:00"},{"$f":"Data_Dump!C121","v":"00:00:00"},{"$f":"Data_Dump!D121","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E121,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B122,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B122","v":"00:00:00"},{"$f":"Data_Dump!C122","v":"00:00:00"},{"$f":"Data_Dump!D122","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E122,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B123,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B123","v":"00:00:00"},{"$f":"Data_Dump!C123","v":"00:00:00"},{"$f":"Data_Dump!D123","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E123,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B124,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B124","v":"00:00:00"},{"$f":"Data_Dump!C124","v":"00:00:00"},{"$f":"Data_Dump!D124","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E124,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B125,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B125","v":"00:00:00"},{"$f":"Data_Dump!C125","v":"00:00:00"},{"$f":"Data_Dump!D125","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E125,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B126,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B126","v":"00:00:00"},{"$f":"Data_Dump!C126","v":"00:00:00"},{"$f":"Data_Dump!D126","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E126,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B127,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B127","v":"00:00:00"},{"$f":"Data_Dump!C127","v":"00:00:00"},{"$f":"Data_Dump!D127","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E127,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B128,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B128","v":"00:00:00"},{"$f":"Data_Dump!C128","v":"00:00:00"},{"$f":"Data_Dump!D128","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E128,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B129,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B129","v":"00:00:00"},{"$f":"Data_Dump!C129","v":"00:00:00"},{"$f":"Data_Dump!D129","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E129,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B130,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B130","v":"00:00:00"},{"$f":"Data_Dump!C130","v":"00:00:00"},{"$f":"Data_Dump!D130","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E130,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B131,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B131","v":"00:00:00"},{"$f":"Data_Dump!C131","v":"00:00:00"},{"$f":"Data_Dump!D131","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E131,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B132,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B132","v":"00:00:00"},{"$f":"Data_Dump!C132","v":"00:00:00"},{"$f":"Data_Dump!D132","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E132,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B133,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B133","v":"00:00:00"},{"$f":"Data_Dump!C133","v":"00:00:00"},{"$f":"Data_Dump!D133","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E133,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B134,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B134","v":"00:00:00"},{"$f":"Data_Dump!C134","v":"00:00:00"},{"$f":"Data_Dump!D134","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E134,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B135,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B135","v":"00:00:00"},{"$f":"Data_Dump!C135","v":"00:00:00"},{"$f":"Data_Dump!D135","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E135,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B136,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B136","v":"00:00:00"},{"$f":"Data_Dump!C136","v":"00:00:00"},{"$f":"Data_Dump!D136","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E136,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B137,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B137","v":"00:00:00"},{"$f":"Data_Dump!C137","v":"00:00:00"},{"$f":"Data_Dump!D137","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E137,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B138,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B138","v":"00:00:00"},{"$f":"Data_Dump!C138","v":"00:00:00"},{"$f":"Data_Dump!D138","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E138,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B139,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B139","v":"00:00:00"},{"$f":"Data_Dump!C139","v":"00:00:00"},{"$f":"Data_Dump!D139","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E139,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B140,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B140","v":"00:00:00"},{"$f":"Data_Dump!C140","v":"00:00:00"},{"$f":"Data_Dump!D140","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E140,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B141,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B141","v":"00:00:00"},{"$f":"Data_Dump!C141","v":"00:00:00"},{"$f":"Data_Dump!D141","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E141,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B142,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B142","v":"00:00:00"},{"$f":"Data_Dump!C142","v":"00:00:00"},{"$f":"Data_Dump!D142","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E142,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B143,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B143","v":"00:00:00"},{"$f":"Data_Dump!C143","v":"00:00:00"},{"$f":"Data_Dump!D143","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E143,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B144,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B144","v":"00:00:00"},{"$f":"Data_Dump!C144","v":"00:00:00"},{"$f":"Data_Dump!D144","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E144,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B145,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B145","v":"00:00:00"},{"$f":"Data_Dump!C145","v":"00:00:00"},{"$f":"Data_Dump!D145","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E145,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B146,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[{"$f":"Data_Dump!B146","v":"00:00:00"},{"$f":"Data_Dump!C146","v":"00:00:00"},{"$f":"Data_Dump!D146","v":"00:00:00"},{"$f":"IF((MATCH(\"*\"&D$2&\"*\",Data_Dump!E146,0)>0),\"X\",\"N\")","v":{"$error":"#N/A"}},{"$f":"2*OFFSET(Distances!$G$4,(MATCH($B147,Distances!$A$5:$A$83,0)),0)","v":{"$error":"#N/A"}}]
[null,null,null,"Mileage Report"]
[null,null,null,"Demo",{"$f":"SUMIFS($E$3:$E$147,$D$3:$D$147,\"X\",$C$3:$C$147,$D149)","v":0}]
[null,null,null,"Meeting",0]
[null,null,null,"Other",0]
[null,null,null,"Search",0]
[null,null,null,"TF Training",0]
[null,null,null,"Training",1071]
[null,null,null,"Total Miles",{"$f":"SUBTOTAL(9,E149:E154)","v":1071}]

{"sheet":"Distances","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Training Site Distances (one-way)"]
["Location","Street Address","City","State","Zip Code"]
["Home","3902 E 29th St","Bryan","TX"]
["Training Site","Street Address","City","State","Zip Code","Driving","Distance"]
["Austin's Colony","2400 Austin's Colony Parkway","Bryan","TX",null,{"$f":"IF($B$3=B5,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B5,C5,D5,E5))","v":"3.1 mi, 9 mins"},3.1]
["CEOC","110 N Main","Bryan","TX",null,{"$f":"IF($B$3=B6,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B6,C6,D6,E6))","v":"3.6 mi, 9 mins"},3.6]
["Brazos River Ranch","County Rd 216","Caldwell","TX",null,{"$f":"IF($B$3=B7,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B7,C7,D7,E7))","v":"19.6 mi, 28 mins"},19.600000000000001]
["Canyon Lake",null,"Canyon Lake","TX",null,{"$f":"IF($B$3=B8,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B8,C8,D8,E8))","v":"154 mi, 3 hours 2 mins"},154]
["Cotton Ranch","3300 Sand Creek Rd","Bryan","TX",null,{"$f":"IF($B$3=B9,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B9,C9,D9,E9))","v":"17.4 mi, 27 mins"},17.399999999999999]
["Cotton Ranch South","1900 Fickey Rd","Bryan","TX",null,{"$f":"IF($B$3=B10,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B10,C10,D10,E10))","v":"15.3 mi, 22 mins"},15.3]
["CSFD Station 5","1601 William D. Fitch Parkway","College Station","TX",null,{"$f":"IF($B$3=B11,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B11,C11,D11,E11))","v":"10.0 mi, 16 mins"},10]
["CTOMA","4100 E 29th St","Bryan","TX",null,{"$f":"IF($B$3=B12,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B12,C12,D12,E12))","v":"404 ft, 8 secs"},404]
["Disaster City","11000 Stillwater","College Station","TX",null,{"$f":"IF($B$3=B13,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B13,C13,D13,E13))","v":"7.2 mi, 16 mins"},7.2]
["Gateway","101 Gateway Blvd","College Station","TX",null,{"$f":"IF($B$3=B14,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B14,C14,D14,E14))","v":"9.5 mi, 15 mins"}]
["Hensel Park","502 College Ave","College Station","TX",null,{"$f":"IF($B$3=B15,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B15,C15,D15,E15))","v":"2.4 mi, 6 mins"},2.4]
["Jim's House","5475 FM 1179","Bryan","TX",null,{"$f":"IF($B$3=B16,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B16,C16,D16,E16))","v":"3.8 mi, 8 mins"},3.8]
["Jones Forest","2826 Farm to Market Road 1488","Conroe","TX",null,{"$f":"IF($B$3=B17,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B17,C17,D17,E17))","v":"68.1 mi, 1 hour 17 mins"},68.099999999999994]
["Jones Ranch North","12000 Clear Lake Rd","Bryan","TX",null,{"$f":"IF($B$3=B18,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B18,C18,D18,E18))","v":"12.0 mi, 22 mins"},12]
["Jones Ranch South","9747 Farm to Market 1179","Bryan","TX",null,{"$f":"IF($B$3=B19,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B19,C19,D19,E19))","v":"8.2 mi, 13 mins"},8.1999999999999993]
["Katie's House","7400 Wixon Rd","Bryan","TX",null,{"$f":"IF($B$3=B20,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B20,C20,D20,E20))","v":"10.8 mi, 17 mins"},10.8]
["Kroger","2303 Boonville Rd","Bryan","TX",null,{"$f":"IF($B$3=B21,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B21,C21,D21,E21))","v":"2.6 mi, 7 mins"},2.6]
["Lake Bryan","8099 Sandy Point Rd","Bryan","TX",null,{"$f":"IF($B$3=B22,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B22,C22,D22,E22))","v":"10.0 mi, 19 mins"},10]
["Lake Somerville","10550 Rocky Creek Park Road","Burton","TX",null,{"$f":"IF($B$3=B23,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B23,C23,D23,E23))","v":"37.0 mi, 50 mins"},37]
["Lick Creek","13600 Rock Prairie Rd","College Station","TX",null,{"$f":"IF($B$3=B24,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B24,C24,D24,E24))","v":"10.2 mi, 16 mins"},10.199999999999999]
["Mary's House","5660 Falling Water","Bryan","TX",null,{"$f":"IF($B$3=B25,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B25,C25,D25,E25))","v":"9.5 mi, 17 mins"},9.5]
["Masser Ranch","4251 Farm to Market 2000","Caldwell","TX",null,{"$f":"IF($B$3=B26,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B26,C26,D26,E26))","v":"28.5 mi, 38 mins"},28.5]
["Reed Arena","730 Olsen Blvd","College Station","TX",null,{"$f":"IF($B$3=B27,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B27,C27,D27,E27))","v":"3.4 mi, 10 mins"},3.4]
["Riverside","3100 State Highway 47","Bryan","TX",null,{"$f":"IF($B$3=B28,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B28,C28,D28,E28))","v":"11.5 mi, 22 mins"},11.5]
["Rooney Ranch","12313 Long Trussel Rd","Bryan","TX",null,{"$f":"IF($B$3=B29,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B29,C29,D29,E29))","v":"13.5 mi, 22 mins"},13.5]
["Sam Rayburn","1048 N Earl Rudder Fwy","Bryan","TX",null,{"$f":"IF($B$3=B30,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B30,C30,D30,E30))","v":"3.2 mi, 8 mins"},3.2]
["TAMU","Lamar St","College Station","TX",null,{"$f":"IF($B$3=B31,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B31,C31,D31,E31))","v":"2.7 mi, 8 mins"},2.7]
["Tonkaway Ranch","16373 Tonkaway Lake Rd","College Station","TX",null,{"$f":"IF($B$3=B32,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B32,C32,D32,E32))","v":"12.4 mi, 22 mins"},12.4]
["Veteran's Park","3101 Harvey Rd","College Station","TX",null,{"$f":"IF($B$3=B33,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B33,C33,D33,E33))","v":"3.6 mi, 8 mins"},3.6]
["Wellborn",null,"Wellborn","TX",null,{"$f":"IF($B$3=B34,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B34,C34,D34,E34))","v":"10.0 mi, 16 mins"},10]
["Zweifel Ranch","7300 Bickham Cemetery Rd","Bryan","TX",null,{"$f":"IF($B$3=B35,\"0\",getGoogDistanceTime($B$3,$C$3,$D$3,$E$3,B35,C35,D35,E35))","v":"21.3 mi, 28 mins"},21.3]
["California",null,"Redwood City","CA",null,0,0]
["Unknown",null,null,null,null,0,0]

{"sheet":"Data_Dump","index":3,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Timestamp","Date","Location","Type","Attendance","Notes"]
["2013-01-05T08:50:40","2013-01-05","Lake Bryan","Training","Bill Dozier, Cindy Grant, Tim Scott, Blanton Smith, Jim Yeager, Joel Harms"]
["2013-01-08T19:29:52","2013-01-08","CTOMA","Training","Bill Dozier, Kelly Dozier, Cindy Grant, Mary Haislet, Tim Scott, Teresa Medearis, Lois Pritchard, Joel Harms, Megan and Vonda Bob"]
["2013-01-12T09:57:40","2013-01-12","Cotton Ranch","Training","Katie Breland, Joel Harms"]
["2013-01-15T06:17:00","2013-01-12","Canyon Lake","Other","Cindy Grant, Mary Haislet","Water Certification test"]
["2013-01-15T19:44:53","2013-01-15","Veteran's Park","Training","Cindy Grant, Teresa Medearis, Lois Pritchard, Joel harms Kailee Surratt .","First visit for Matt"]
["2013-01-19T11:38:50","2013-01-19","Cotton Ranch south","Training","Katie Breland, Bill Dozier, Mary Haislet, D'Lynn Lehew, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel"]
["2013-01-22T18:57:41","2013-01-22","Mary's house","Training","Jeannette Bayer, Katie Breland, Bill Dozier, Kelly Dozier, Mary Haislet, Teresa Medearis, Lois Pritchard","Worked on website and trained Kiba and aziva."]
["2013-01-26T09:54:38","2013-01-26","Jones ranch","Training","Bill Dozier, Kelly Dozier, Cindy Grant, Mary Haislet, Tim Scott, Blanton Smith","Kailee Surrett\nMatt young"]
["2013-01-26T09:55:46","2013-01-26","Disaster City","TF Training","Katie Breland, Ronnie Perry","FEMA"]
["2013-01-26T09:56:33","2013-01-26","Jones Forest","Training","Teresa Medearis, Lois Pritchard","FUNSAR"]
["2013-01-29T21:29:00","2013-01-29","Veteran's Park","Training","Ellen Mitchell, Blanton Smith, Jim Yeager, Joel Harms","Matt Young\nKailee Surratt"]
["2013-01-29T21:30:19","2013-01-29","Jim's house","Other","Mary Haislet, Ronnie Perry, Tim Scott, Teresa Medearis, Lois Pritchard","Worked on boat rack"]
["2013-02-02T10:11:45","2013-02-02","Lake Bryan","Training","Katie Breland, Bill Dozier, Mary Haislet, D'Lynn Lehew, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel Harms, Matt"]
["2013-02-10T17:09:32","2013-02-09","Rooney Ranch","Training","Katie Breland, Bill Dozier, Kelly Dozier, Cindy Grant, Mary Haislet, Tim Scott, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel Harms","Megan and Vonda Bob\nKailee Surratt"]
["2013-02-13T09:52:36","2013-02-12","Riverside","Training","Jeannette Bayer, Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Jim Yeager, Teresa Medearis, Lois Pritchard","Pre-plan and Google Earth classes"]
["2013-02-17T15:32:26","2013-02-16","Lake Bryan","Training","Bill Dozier, Cindy Grant, Mary Haislet, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel Harms","Megan and Vonda Bob\nMatt Young"]
["2013-02-17T15:50:56","2013-02-16","Disaster City","TF Training","Katie Breland, D'Lynn Lehew, Ronnie Perry"]
["2013-02-19T20:47:42","2013-02-19","Veteran's Park","Training","Jeannette Bayer, Bill Dozier, Kelly Dozier, Cindy Grant, Ellen Mitchell, Blanton Smith, Jim Yeager","Completed pack test at Reed before moving to Veteran's"]
["2013-02-19T21:06:51","2013-02-19","Katie's House","Meeting","Katie Breland, Mary Haislet, Tim Scott","Mary & Katie worked on test standards\nTim worked on trailer project"]
["2013-02-20T08:46:46","2013-02-19","Reed arena","Training","Jeannette Bayer, Bill Dozier, Kelly Dozier, Cindy Grant, Ellen Mitchell, Blanton Smith, Matt young"]
["2013-02-23T09:53:03","2013-02-23","Cotton Ranch","Training","Katie Breland, Mary Haislet, D'Lynn Lehew, Kailee Surratt"]
["2013-02-26T19:43:06","2013-02-26","Austin's colony","Training","Jeannette Bayer, Bill Dozier, Mary Haislet, Ellen Mitchell, Ronnie Perry, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis"]
["2013-02-26T19:47:58","2013-02-26","Austin's Colony","Training","Jeannette Bayer, Ellen Mitchell, Ronnie Perry, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis, Joel Harms","Kaylee"]
["2013-03-02T14:33:45","2013-03-02","Lake Bryan","Training","Bill Dozier, Cindy Grant, Mary Haislet, Tim Scott, Joel Harms","Deb and Amanda from AASAR\nMatt Young"]
["2013-03-02T14:35:00","2013-03-02","Disaster City","TF Training","Katie Breland, D'Lynn Lehew, Ronnie Perry"]
["2013-03-06T08:06:04","2013-03-05","Cotton Ranch","Training","Katie Breland, Joel Harms","Maegan K\nKailee S"]
["2013-03-06T08:08:24","2013-03-05","California","TF Training","Bill Dozier, Jim Yeager","Plans Class"]
["2013-03-06T10:09:20","2013-03-05","TAMU","Demo","Cindy Grant","Forensics Demo"]
["2013-03-09T09:51:44","2013-03-08","Disaster City","TF Training","Katie Breland, Ronnie Perry"]
["2013-03-09T09:50:47","2013-03-09","Masser Ranch","Training","Mary Haislet, Blanton Smith, Teresa Medearis, Lois Pritchard","Kailee Surratt"]
["2013-03-12T18:16:24","2013-03-12","Cotton Ranch","Training","Katie Breland, Bill Dozier, Mary Haislet, Ellen Mitchell, Tim Scott, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel Harms, Kelly Dozier","Meagan K"]
["2013-03-12T18:18:30","2013-03-12","Tonkaway Ranch","Other","Jeannette Bayer, Cindy Grant","Trailing Seminar"]
["2013-03-16T10:32:07","2013-03-16","Cotton Ranch South","Training","Katie Breland, Bill Dozier, Mary Haislet, Jim Yeager, Teresa Medearis, Lois Pritchard","Kathy Bunker\nTeresa's grand kids \nAERIES -2"]
["2013-03-19T18:37:58","2013-03-19","Hensel Park","Training","Jeannette Bayer, Cindy Grant, Mary Haislet, Ellen Mitchell, Blanton Smith, Kailee"]
["2013-03-20T06:09:21","2013-03-19","CEOC","Meeting","Bill Dozier, Ronnie Perry, Kelly Dozier","BVSAR"]
["2013-04-15T17:36:30","2013-03-20","TAMU","Demo","Cindy Grant, Bill Dozier, Jeannette Bayer","Aggie Guide Dogs"]
["2013-03-26T18:42:36","2013-03-26","Austin's Colony","Training","Jeannette Bayer, Bill Dozier, Mary Haislet, Tim Scott","Matt"]
["2013-04-01T07:03:27","2013-03-30","Lick Creek","Training","Bill Dozier, Blanton Smith, Jim Yeager","Matt Young, Maegan"]
["2013-04-14T21:31:10","2013-04-04","Wellborn","Demo","Cindy Grant","Southwood 4-H demo"]
["2013-04-14T21:32:49","2013-04-04","TAMU","Demo","Cindy Grant","Aggie Foresic Investigation group"]
["2013-04-06T15:35:17","2013-04-06","Lake Bryan","Training","Katie Breland, Bill Dozier, Cindy Grant, Mary Haislet, Ronnie Perry, Jim Yeager, Joel Harms","Matt\nMaegan K"]
["2013-05-16T11:47:30","2013-04-06","Jones Forest","Training","Teresa Medearis, Lois Pritchard","SARTECH II Test"]
["2013-04-09T19:17:54","2013-04-09","CSFD Station 5","Training","Bill Dozier, Cindy Grant, Mary Haislet, Ronnie Perry, Tim Scott, Jim Yeager, Teresa Medearis, Lois Pritchard, Kelly Dozier","SONAR Class, Kailee Surratt\nJeannette training with TC"]
["2013-04-15T17:36:30","2013-04-09","Other","Training","Jeannette Bayer","Training with TC"]
["2013-04-13T13:26:34","2013-04-13","Lake Bryan","Training","Bill Dozier, Mary Haislet, Ronnie Perry","Matt Young, Kailee Surratt, mark/radio"]
["2013-04-16T19:20:15","2013-04-16","Hensel park","Training","Jeannette Bayer, Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Blanton Smith, Teresa Medearis, Lois Pritchard, Joel Harms","Matt young, Kailee Surratt"]
["2013-05-16T11:51:14","2013-04-18","Kroger","Meeting","Jeannette Bayer, Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard","Team meeting"]
["2013-05-16T11:52:32","2013-04-20","Vet School","Demo","Bill Dozier, Cindy Grant, Mary Haislet, Jim Yeager, Teresa Medearis, Lois Pritchard, Kelly Dozier","Vet school open house"]
["2013-04-23T18:26:45","2013-04-23","Austin's Colony","Training","Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard, Joel Harms"]
["2013-04-27T13:48:08","2013-04-27","Black Jack Ranch","Training","Cindy Grant, Mary Haislet","Bill Dotson seminar"]
["2013-04-27T14:47:24","2013-04-27","Boat work day","Other","Teresa Medearis, Lois Pritchard"]
["2013-04-30T19:50:41","2013-04-30","cotton ranch","Training","Katie Breland, Bill Dozier, Ellen Mitchell, Ronnie Perry, Teresa Medearis, Lois Pritchard"]
["2013-05-04T09:38:14","2013-05-04","Aggieland humane society","Demo","Jeannette Bayer, Tim Scott, Kelly Dozier","Kailee, Matt young"]
["2013-05-06T09:35:03","2013-05-04","Gateway","TF Training","Katie Breland, Bill Dozier","Plans Skills Set"]
["2013-05-06T12:02:45","2013-05-04","Disaster City","TF Training","D'Lynn Lehew, Ronnie Perry"]
["2013-05-04T13:32:12","2013-05-04","Washington co. EMS","Other","Mary Haislet, Ellen Mitchell, Lois Pritchard","CPR First Aid cert."]
["2013-05-07T19:40:19","2013-05-07","Veteran's Park","Training","Jeannette Bayer, Katie Breland, Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Ronnie Perry, Blanton Smith","Matt, Maegan, TC, Kailee, Greg"]
["2013-05-16T11:55:00","2013-05-11","Lake Somerville","Exercise","Katie Breland, Bill Dozier, Mary Haislet, D'Lynn Lehew, Ronnie Perry, Tim Scott, Blanton Smith, Jim Yeager, Teresa Medearis, Lois Pritchard","WashCo Exercise"]
["2013-05-15T16:42:24","2013-05-14","Vet School","Demo","Jeannette Bayer, Bill Dozier, Cindy Grant, Mary Haislet, Ellen Mitchell, Tim Scott, Teresa Medearis, Lois Pritchard, Kelly Dozier","BV Kennel Club demo"]