{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Overview and Comments","Tracking"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Overview and Comments","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
["Purpose","In lieu of changing notification periods, we compromised to see if eMail notifications would allow us the extra time needed to advise NA members and to respond."]
[null,"Therefore, we need a way to track the impact of email notifications on the process. "]
[" "]
["Questions to Resolve:","1. How/when would this be reported, and to whom?"]
[" "]
[" ","2. Does this serve a function for NA reporting by Land Use Chairs, i.e. a summary of activity? Does this complicate the process?"]
[" "]
[" ","3. How would this be maintained? How do we ensure accuracy by each NA Land Use Chair?"]
[]
[null,"4. Is there a way to automate? What about Survey Planet? Google Forms?"]
[" "]
[null,"5. What expectations would we have around changing policy resulting from this data?"]
[" ","i.e. if we set goals for certain standards, and those goals are not met, what is the process for change?"]
[" "]
[" ","6. We are asking for code updates where notices would be required by email - is there a burden on the city to track this data?"]
[" "]
[" ","7. CityView does not appear to have date fields where this information could be tracked - we need to verify this with the CityView experts."]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Tracking","index":1,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Neighborhood Association - Land Use Notice Tracking"]
["4Q - Oct-Dec 2020",{"$nulls":11}," "]
[]
[{"$nulls":10},"Reporting Data:"]
[null,"Goal","Actual",{"$nulls":7},"(This section would not be shown on the report.)"]
[null,1.0,{"$f":"100%-((counta(E16:E208)-(count(E16:E208))))/counta(E16:E208)","v":1},"% of time eMail Received:",{"$nulls":6}," "," "," "]
[null,3.0,{"$f":"AVERAGEIF(K16:K208,\"<>\")","v":5.8},"Average Days between (A) Date of Notice and (C) Received by Mail",{"$nulls":6}," "," "," "]
[null,1.0,{"$f":"AVERAGEIF(L17:L209,\"<>\")","v":1.333333333},"Average Days between (A) Date of Notice and (B) Received by Email",{"$nulls":6}," "," "," "]
[null,10.0,{"$f":"AVERAGEIF(M16:M208,\"<>\")","v":9.4},"Average Days between (C) Received by Mail (D) Date Comments Due",{"$nulls":6}," "," "," "]
[null,14.0,{"$f":"AVERAGEIF(N17:N209,\"<>\")","v":14.66666667},"Average Days between (B) Received by eMail (D) Date Comments Due",{"$nulls":6}," "," "," "]
[null,2.0,{"$f":"AVERAGEIF(O16:O209,\"<>\")","v":4},"Average Days between (C) Received by Mail and (E) Sent to NA",{"$nulls":6}," "," "," ",null,null," "]
[null,2.0,{"$f":"AVERAGEIF(P16:P210,\"<>\")","v":9.5},"Average Days between (B) Received by eMail and (E) Sent to NA",{"$nulls":6}," "," "," "]
[{"$nulls":10},"We track this in order to understand if Mail is being received in timely fashion.  If not, we need to revisit timelines for notifications and comment periods.","Measuring to ensure NA's have improved notice periods in lieu of regular mail.","This is tracked in order to determine actual number of days recipients have for comments.",null,"Tracking to see if NA forwards this info to members.","Tracking to see if there is benefit to getting info to members earlier resulting from email."]
[{"$nulls":4},"Date can not be before (A)","Date can not be before (A)","Date can not be before (A)","Date can not be before (A)","Date can not be before (A) or (B)",null,"F16,D16","E16,D16","G16,F16","G16,E16","I16,F16","I16,E16"]
["NA","Project ID","Description:  PH-Public Hearing, NM-Neighborhood Meeting NA-New Application","(A)  Date of Notice?","(B) Date Received by Email? (leave blank if not received.)","(C) Date Received by mail?","(D) Date Comments Due?","Date of Hearing","(E) Date Sent to NA?",null,"# Days between (A) date of notice and (C) receipt in mail?","# Days between (A) date of notice and (B) date received by eMail","# Days between (C) receipt of mail via USPS and (D) date comments due?","# Days between (B) receipt of eMail via USPS and (D) date comments due?","# Days between (C) date received by mail (E) date sent to NA members, if applicable?","# Days between (B) date received by eMail (E) date NA sent to their members, if applicable?"]
["CWNA","2020-test 1","PH","2020-11-25","2020-11-25","2020-12-01","2020-12-09","2020-12-09","2020-12-05",null,{"$f":"IF(DAYS(F16,D16)<=0,,IF(DAYS(F16,D16)>365,,IF(DAYS(F16,D16)<365,DAYS(F16,D16),)))","v":6},{"$f":"IF(DAYS(E16,D16)<0,,IF(DAYS(E16,D16)>365,,IF(DAYS(E16,D16)<365,DAYS(E16,D16),)))","v":0},{"$f":"IF(DAYS(G16,F16)<=0,,IF(DAYS(G16,F16)>365,,IF(DAYS(G16,F16)<365,DAYS(G16,F16),)))","v":8},{"$f":"IF(DAYS(G16,E16)<=0,,IF(DAYS(G16,E16)>365,,IF(DAYS(G16,E16)<365,DAYS(G16,E16),)))","v":14},{"$f":"IF(DAYS(I16,F16)<=0,,IF(DAYS(I16,F16)>365,,IF(DAYS(I16,F16)<365,DAYS(I16,F16),)))","v":4},{"$f":"IF(DAYS(I16,E16)<=0,,IF(DAYS(I16,E16)>365,,IF(DAYS(I16,E16)<365,DAYS(I16,E16),)))","v":10}]
["CWNA","2020-test 2","NA","2020-01-02",null,"2020-01-08","2020-01-16"," ","2020-01-12",null,6,"",8,"",4,""]
["CWNA","2020-test 3","NA","2020-12-01","2020-12-03","2020-12-06","2020-12-17"," ","2020-01-12",null,5,2,11,14,"",""]
["CWNA","2020-test 4","PH","2020-01-02","2020-01-03","2020-01-08","2020-01-18","2020-01-18","2020-01-12",null,6,1,10,15,4,9]
["CWNA","2020-test 5","NM","2020-12-02","2020-12-03","2020-12-08","2020-12-18",null,"2020-01-12",null,6,1,10,15,"",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",null,"","","",""]
[{"$nulls":10},"",{"$f":"IF(DAYS(E27,D27)<=0,,IF(DAYS(E27,D27)>365,,IF(DAYS(E27,D27)<365,DAYS(E27,D27),)))","v":""},"","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":10},"","","","","",""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]