{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","CANCEL Events","Sh1_DateSpecs","LOVs","Updates","Test data","Update Copy","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":70,"comments":3,"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":"Instructions","index":0,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"\"Cancel Event Request Form (\"&AlertFormEffectiveDate&\")\"","v":"Cancel Event Request Form (form effective date: 6/1/2024)"}]
["Complete the tab titled CANCEL Events to report your event updates to UnitedHealthcare."]
[]
["After you have entered your event information:"]
["You may save this form and send it to your local UnitedHealthcare market for entry. Contact your UnitedHealthcare Agent Manager to see if this is the preferred submission method for your market. "]
["Event cancellations using this submission method must be processed by the local market more than 1 business day before the event date. "]
["OR"]
["This form may be submitted directly to UnitedHealthcare by double-clicking the Validate and Submit button on the CANCEL Events tab."]
["Event cancellations using this submission method must be submitted at least 6 business days before the event date. "]
[]
[]
["Using this Form"]
["Note: Due to malware avoidence steps you may be required to unblock the document in order to modify it.  You can do so by right clicking the file, open the properties then click the unblock option shown in the screen shot (right)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions/Guidance"]
["   Advertised events cancelled less than 7 calendar days before the event date must send a UnitedHealthcare representative at the originally scheduled event date and time. "]
["   The representative must remain at the venue for at least 30 minutes after the scheduled start time for a formal marketing/sales event and for the entire scheduled time for an informal event."]
["   This requirement does not apply in cases of cancellation due to inclement weather or public safety risk; however, the agent must attempt to notify the venue and request signage be posted as appropriate. "]
[]
["   Venue Name - Enter the venue name provided when the event was reported, maximum allowed length 40 characters"]
[]
["   Venue Street Address - Enter the venue street address provided when the event was reported, do no include city or state. Maximum 40 characters."]
[]
["   Venue Zip - Enter the zip code provided when the event was reported; include leading zeroes, if applicable."]
[]
["   Event Date - Enter the event date provided when the event was reported in M/D/YYYY format. "]
[]
["   Start Time - Enter the start time provided when the event was reported, select from the drop down list."]
[]
["   End Time - Enter the end time provided when the event was reported, select from the drop down list."]
[]
["   Event Category - Enter the event category provided when the event was reported, select from the drop down list."]
[]
["   Owning Agent -  Provide the owning agent's name and writing id. "]
[]
["   Presenting Agent -  Provide the presenting agent's name and writing id. "]
[]
[]
["For more information on policy & compliance, see section 5 of the Agent Guide located on Jarvis. Compliance questions may also be sent to Compliance_Questions@uhc.com."]
["For other event reporting related questions, please contact your UnitedHealthcare Market Sales Manager or the Producer Help Desk at opsesc@uhc.com."]

{"sheet":"CANCEL Events","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,2,2,3],[1,2,1,3],[2,7,2,8]]}
[null,null,null,null,null,{"$f":"CancelEventsTitleRow1","v":"Cancels sent using Validate and Submit, at least 6 business days before event"}]
[null,null,{"$f":"AlertFormEffectiveDate2","v":"Form effective date: 6/1/2024"},null,null,{"$f":"CancelEventsTitleRow2","v":"Cancels sent using Save, more than 1 business day before event"}]
[null,null,{"$f":"TitleForForm","v":"Cancel Event Request Form"},null,{"$f":"Alert2","v":" "},"<Validate and Submit>","<Save>",{"$f":"CancelEventsEmailAlert","v":"Be sure your email program is up \nbefore using Validate and Submit"}]
[]
[null,"(Optional)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)"]
["Count","Event ID","Cancellation Reason","Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","End Time","Event Category","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]

{"sheet":"Sh1_DateSpecs","index":2,"n_rows":58,"n_cols":45,"rows_kept":58,"cut":false,"hidden":true,"merged":[[49,19,49,20],[54,18,54,19],[3,22,25,28],[34,7,35,13]]}
["x","xxxxxxxxxxxxx","xxxxxxxxxx","x","xxxxx","xxxxxxxxxx","xxxxxxxxxxxxxxxxxxxxxxxxxxxx","xxxxxxx","xxxxxxx","xxxxxxx","xxxxxxxxxx","xxx","xxxxxxxxxxxxxxxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","CANCEL Event Fields","Width","Letter",null,"x","CHANGE Event Fields","Width","Letter",null,"x","NEW Event Fields","Width","Letter"]
[null,null,null,null,{"$f":"\"Valid Meeting Event Date Ranges are between \" & TEXT(TestDayPlus,\"M/DD/YYYY\") &\" and \" & TEXT(MonthStartMaxEnd,\"M/DD/YYYY\")","v":"Valid Meeting Event Date Ranges are between 11/04/2024 and 9/30/2025"},null,null,null,null,null,null,null,null,null,null,null,"ERA Form Version:","ERA Cancel Form version 6.2 2024/01/01 040000PM","ßMake Version changes here",null,null,"eMail Fail Override:",false,null,null,null,null,null,null,null,null,1,"Count",5,"A",null,1,"Count",5,"A",null,1,"Count",5,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Event ID",15,"B",null,2,"Event ID",16,"B",null,2,"Venue Name",25,"B"]
[null,"TestToday:",{"$f":"NOW()","v":"2024-10-28T07:07:28.810"},null,"Month","Real Month","LOVs Month","Filter1","Filter2","Filter3","Dates",null,"Date Start/End","Value",null,null,"BasePipeName:","EventRequestExport",null,null,null,"Actual eMail:","Good Submission",null,null,null,null,null,null,null,null,3,"Cancellation Reason",24,"C",null,3,"Venue Name",25,"C",null,3,"Venue Street Address",25,"C"]
[null,"Days Buffer:",7,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E5,E5)-1,E5,1)","v":"2024-01-01"},{"$f":"TEXT(F5,\"MMMM-YYYY\")","v":"January-2024"},{"$f":"IF(MonthsIndex=0,TRUE,FALSE)","v":false},{"$f":"(VALUE(F5)-VALUE(TestDayMinMonth))>=0","v":false},{"$f":"AND(H5,I5)","v":false},{"$f":"IF(J5,F5,0)","v":"00:00:00"},null,"S_DeltaMin",-30,null,null,"File Extension:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Venue Name",25,"D",null,4,"Venue Street Address",25,"D",null,4,"Venue Zip",15,"D"]
[null,"TestTodayPlus:",{"$f":"TestDay+TestDaysBuffer","v":"2024-11-04T07:07:28.810"},null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E6,E6)-1,E6,1)","v":"2024-02-01"},{"$f":"TEXT(F6,\"MMMM-YYYY\")","v":"February-2024"},false,false,{"$f":"AND(H6,I6)","v":false},{"$f":"IF(J6,F6,0)","v":"00:00:00"},null,"S_DeltaMax",20,null,null,"eMailFile:","EventRequestExport_amora20_2018-05-08_135203.xls",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Venue Street Address",25,"E",null,5,"Venue Zip",18,"E",null,5,"Event Date",22,"E"]
[null,null,{"$f":"EOMONTH(TestDayPlus,-1)+1","v":"2024-11-01"},null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E7,E7)-1,E7,1)","v":"2024-03-01"},"March-2024",false,false,false,"00:00:00",null,"E_DeltaMin",-30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Venue Zip",18,"F",null,6,"Event Date",22,"F",null,6,"Start Time",22,"F"]
[null,"MonthsLogic:",{"$f":"1*(MONTH(TestDay)>6)","v":1},null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E8,E8)-1,E8,1)","v":"2024-04-01"},"April-2024",false,false,false,"00:00:00",null,"E_DeltaMax",20,null,null,"eMail TO:",{"$f":"INDEX(eMailMatrix,1,IF(MID(eMailOptionProdDev,1,3)=\"Pro\",1,2))","v":"opsesc@uhc.com"},null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Event Date",15,"G",null,7,"Start Time",22,"G",null,7,"End Time",22,"G"]
[null,"ArrayLoad:",{"$f":"COUNTIF(J4:J25,TRUE)","v":11},null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E9,E9)-1,E9,1)","v":"2024-05-01"},"May-2024",false,false,false,"00:00:00",null,null,null,null,null,"eMail Subject:","ERA Cancel Event Excel File for Processing","ßSee cell U51 to control eMail recipient",null,null,null,null,null,null,null,null,null,null,null,null,8,"Start Time",15,"H",null,8,"End Time",22,"H",null,8,"Event Category",32,"H"]
[null,null,null,null,6,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E10,E10)-1,E10,1)","v":"2024-06-01"},"June-2024",false,false,false,"00:00:00",null,null,null,null,null,"eMail Body1:","Attention: Sales Team,",null,null,null,null,null,null,null,null,null,null,null,null,null,9,"End Time",15,"I",null,9,"Event Category",32,"I",null,9,"Language",20,"I"]
[null,"vbaDateStart1:","2017-02-01",null,7,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E11,E11)-1,E11,1)","v":"2024-07-01"},"July-2024",true,false,false,"00:00:00",null,null,null,null,null,"eMail Body2:","Please process the attached Cancel Meeting Event Excel file: ",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Event Category",32,"J",null,10,"Language",20,"J",null,10,"Presenting Product",20,"J"]
[null,"vbaDateEnd1:","2017-02-28",null,8,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E12,E12)-1,E12,1)","v":"2024-08-01"},"August-2024",true,false,false,"00:00:00",null,null,null,null,null,"eMail Body3:",{"$f":"eMailFile","v":"EventRequestExport_amora20_2018-05-08_135203.xls"},null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Owning Agent Name",25,"K",null,11,"Presenting Product",20,"K",null,11,"Owning Agent Name",25,"K"]
[null,null,null,null,9,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E13,E13)-1,E13,1)","v":"2024-09-01"},"September-2024",true,false,false,"00:00:00",null,null,null,null,null,"eMail Body4:",{"$f":"\"User ID: \" &vbaUserID","v":"User ID: amora20"},null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Owning Agent Writing #",14,"L",null,12,"Owning Agent Name",25,"L",null,12,"Owning Agent Writing #",25,"L"]
[null,"MonthStartMax:",{"$f":"MAX(MonthsValid)","v":"2025-09-01"},null,10,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E14,E14)-1,E14,1)","v":"2024-10-01"},"October-2024",{"$f":"IF(MonthsIndex=1,TRUE,FALSE)","v":true},false,false,"00:00:00",null,null,null,null,null,"eMail Body5:",{"$f":"ERA_FormVersion","v":"ERA Cancel Form version 6.2 2024/01/01 040000PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Presenting Agent Name",25,"M",null,13,"Owning Agent Writing #",25,"M",null,13,"Presenting Agent Name",25,"M"]
[null,"MonthStartMaxEnd:",{"$f":"EOMONTH(MonthStartMax,0)","v":"2025-09-30"},null,11,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E15,E15)-1,E15,1)","v":"2024-11-01"},"November-2024",true,true,true,"2024-11-01",null,null,null,null,null,"eMail Body6:","Thanks",null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Presenting Agent Writing #",14,"N",null,14,"Presenting Agent Name",25,"N",null,14,"Presenting Agent Writing #",25,"N"]
[null,null,null,null,12,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E16,E16)-1,E16,1)","v":"2024-12-01"},"December-2024",true,true,true,"2024-12-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Presenting Agent Writing #",25,"O",null,15,"Seating Capacity",15,"O"]
[null,"Delete PipeFile:",true,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E17,E17)-1,E17,1)","v":"2025-01-01"},"January-2025",true,true,true,"2025-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Seating Capacity",15,"P",null,16,"Venue Type",25,"P"]
[null,null,null,null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E18,E18)-1,E18,1)","v":"2025-02-01"},"February-2025",true,true,true,"2025-02-01",null,null,null,null,null,"PC Name:","LH7U05CG709370Z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Collect RSVP",15,"Q",null,17,"Venue Phone",15,"Q"]
[null,"Last Form Column:","N",null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E19,E19)-1,E19,1)","v":"2025-03-01"},"March-2025",true,true,true,"2025-03-01",null,null,null,null,null,"UserID:","amora20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"UHC Advertising",15,"R",null,18,"Collect RSVP",15,"R"]
[null,null,null,null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E20,E20)-1,E20,1)","v":"2025-04-01"},"April-2025",true,true,true,"2025-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"UHC Advertising",15,"S"]
[null,"Error Cell Color:","Cell Color",null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E21,E21)-1,E21,1)","v":"2025-05-01"},"May-2025",true,true,true,"2025-05-01"]
[null,null,null,null,6,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E22,E22)-1,E22,1)","v":"2025-06-01"},"June-2025",true,true,true,"2025-06-01",null,null,null,null,null,"Email Addresses:","sales_events@uhc.com","eMail list index:"]
[null,"Allow Paste Action:",false,null,7,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E23,E23)-1,E23,1)","v":"2025-07-01"},"July-2025",true,true,true,"2025-07-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",1]
[null,null,null,null,8,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E24,E24)-1,E24,1)","v":"2025-08-01"},"August-2025",true,true,true,"2025-08-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",2]
[null,null,null,null,9,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E25,E25)-1,E25,1)","v":"2025-09-01"},"September-2025",true,true,true,"2025-09-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Send:",false]
[null,null,null,null,null,"2024-06-01",":Form Effective Date",null,null,null,null,null,null,null,null,null,null,null,"ßTRUE if Cell R51=Production"]
[null,null,null,null,null,null,"Instructions Tab:",{"$f":"\"form effective date: \" &TEXT(F28,\"M/D/YYYY\")","v":"form effective date: 6/1/2024"}]
[null,null,null,null,null,null,"New Events Tab:",{"$f":"\"Form effective date: \" &TEXT(F28,\"M/D/YYYY\")","v":"Form effective date: 6/1/2024"},null,null,null,null,null,null,null,null,"ExcelSaveAsStatus:",false]
[]
[null,null,null,null,null,{"$f":"TestDaysBuffer","v":7},":Days B4 Event"]
[null,null,null,null,null,null,"CancelEventsTitleRow1:","Cancels sent using Validate and Submit, at least 6 business days before event",null,null,null,null,null,null,null,null,"Change eMail TO:",{"$f":"INDEX(eMailMatrix,2,IF(MID(eMailOptionProdDev,1,3)=\"Pro\",1,2))","v":"opsesc@uhc.com"}]
[null,null,null,null,null,null,"CancelEventsTitleRow2:","Cancels sent using Save, more than 1 business day before event",null,null,null,null,null,null,null,null,"Change eMail Subject:","ERA <SubmitType> Event File for Processing"]
[null,null,null,null,null,null,"CancelEventsEmailAlert:","Be sure your email program is up \nbefore using Validate and Submit",null,null,null,null,null,null,null,null,"Change eMail Body1:","Attention: phd,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Body2:","Please process the attached <SubmitType> Meeting Event file: "]
[null,null,null,null,null,null,null,"Row 1: “Cancels sent using Validate and Submit, at least 6 business days before event”",null,null,null,null,null,null,null,null,"Change eMail Body3:",{"$f":"eMailFile","v":"EventRequestExport_amora20_2018-05-08_135203.xls"}]
[null,null,null,null,null,null,null,"Row 2: “Cancels sent using Save, more than 1 business day before event” ",null,null,null,null,null,null,null,null,"Change eMail Body4:",{"$f":"\"User ID: \" &vbaUserID","v":"User ID: amora20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Body5:",{"$f":"ERA_FormVersion","v":"ERA Cancel Form version 6.2 2024/01/01 040000PM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Body6:","Thanks"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Email Addresses:","opsesc@uhc.com","eMail list index:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andrea_harrell@uhc.com",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andrea_harrell@uhc.com",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andrea_harrell@uhc.com",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You can Change Cell R51 from Production or Development",null,"eMail Contact options for If Development only:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Production","email to:","if Production use eMail:","if Development use email:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Events","opsesc@uhc.com","andrea_harrell@uhc.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You can Change Cell S54 to set File 'On-Open' option…","Change/Cancel","opsesc@uhc.com","andrea_harrell@uhc.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On file open, Set eMail status to Development?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No; On-Open Keep R51 as-is",null,"<--On-Open Control"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alert2:",{"$f":"IF(eMailOptionProdDev=\"Development\",\"Dev Testing\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form Title:","Cancel Event Request Form"]

{"sheet":"LOVs","index":3,"n_rows":293,"n_cols":15,"rows_kept":293,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Time Options",null,"Event Categories",null,"Presenting Product",null,"Language",null,"Venue Type",null,"Cancellation Reason",null,"Time LookUp","Time Replace"]
[null,"6:00 AM",null,"Sales Event (Informal):Resource Center",null,"MA",null,"English",null,"Assisted Living",null,"Venue/Date/Time Entry Error",null,"'0:0 AM","'12:00 AM"]
[null,"6:30 AM",null,"Sales Event (Informal):Walk-In Location",null,"Dual",null,"Spanish",null,"Doctor's Office",null,"Venue Not Available",null,"'0:00 AM","'12:00 AM"]
[null,"7:00 AM",null,"Sales Event (Formal):Sales Meeting",null,"Chronic",null,"Arabic",null,"Financial/Legal Services",null,"Inclement Weather",null,"'0:00:00 AM","'12:00 AM"]
[null,"7:30 AM",null,null,null,"Med Supp",null,"Cantonese",null,"Food Bank",null,"Agent ill",null,"'12:00:00 AM",{"$f":"SUBSTITUTE(N6,\":00 AM\",\" AM\")","v":"'12:00 AM"}]
[null,"8:00 AM",null,null,null,"Med Supp/PDP",null,"Chinese",null,"Health Fair/State Fair/County Fair",null,"At Agent Request",null,"'12:30:00 AM",{"$f":"SUBSTITUTE(N7,\":00 AM\",\" AM\")","v":"'12:30 AM"}]
[null,"8:30 AM",null,null,null,"ISNP",null,"Filipino",null,"Health Plan/Insurance Business Office or Facility",null,null,null,"'1:00:00 AM","'1:00 AM"]
[null,"9:00 AM",null,null,null,"MA (SCO)",null,"French",null,"Hospital Clinic/Conference Room/Business Office",null,null,null,"'1:30:00 AM","'1:30 AM"]
[null,"9:30 AM",null,null,null,"Stand-alone PDP",null,"German",null,"Hotel/Motel",null,null,null,"'2:00:00 AM","'2:00 AM"]
[null,"10:00 AM",null,null,null,"Erickson",null,"Greek",null,"Library",null,null,null,"'2:30:00 AM","'2:30 AM"]
[null,"10:30 AM",null,null,null,null,null,"Italian",null,"Mall Kiosk",null,null,null,"'3:00:00 AM","'3:00 AM"]
[null,"11:00 AM",null,null,null,null,null,"Japanese",null,"Nursing Home/Skilled Nursing Facility/Rehab Facility",null,null,null,"'3:30:00 AM","'3:30 AM"]
[null,"11:30 AM",null,null,null,null,null,"Korean",null,"Recreational Vehicle/RV Park",null,null,null,"'4:00:00 AM","'4:00 AM"]
[null,"12:00 PM",null,null,null,null,null,"Mandarin",null,"Recreational/Community Center",null,null,null,"'4:30:00 AM","'4:30 AM"]
[null,"12:30 PM",null,null,null,null,null,"Norwegian",null,"Religious Facility (Church/Temple/Mosque)",null,null,null,"'5:00:00 AM","'5:00 AM"]
[null,"1:00 PM",null,null,null,null,null,"Other",null,"Restaurant/Coffee Shop",null,null,null,"'5:30:00 AM","'5:30 AM"]
[null,"1:30 PM",null,null,null,null,null,"Polish",null,"Retail Store/Store Front/Grocery Store",null,null,null,"'6:00:00 AM","'6:00 AM"]
[null,"2:00 PM",null,null,null,null,null,"Portuguese Brazilian",null,"School",null,null,null,"'6:30:00 AM","'6:30 AM"]
[null,"2:30 PM",null,null,null,null,null,"Russian",null,"Senior Apartments/Senior Center",null,null,null,"'7:00:00 AM","'7:00 AM"]
[null,"3:00 PM",null,null,null,null,null,"Swedish",null,"UHC Store",null,null,null,"'7:30:00 AM","'7:30 AM"]
[null,"3:30 PM",null,null,null,null,null,"Tagalog",null,"Other",null,null,null,"'8:00:00 AM","'8:00 AM"]
[null,"4:00 PM",null,null,null,null,null,"Vietnamese",null,null,null,null,null,"'8:30:00 AM","'8:30 AM"]
[null,"4:30 PM",null,null,null,null,null,null,null,null,null,null,null,"'9:00:00 AM","'9:00 AM"]
[null,"5:00 PM",null,null,null,null,null,null,null,null,null,null,null,"'9:30:00 AM","'9:30 AM"]
[null,"5:30 PM",null,null,null,null,null,null,null,null,null,null,null,"'10:00:00 AM","'10:00 AM"]
[null,"6:00 PM",null,null,null,null,null,null,null,null,null,null,null,"'10:30:00 AM","'10:30 AM"]
[null,"6:30 PM",null,null,null,null,null,null,null,null,null,null,null,"'11:00:00 AM","'11:00 AM"]
[null,"7:00 PM",null,null,null,null,null,null,null,null,null,null,null,"'11:30:00 AM","'11:30 AM"]
[null,"7:30 PM",null,null,null,null,null,null,null,null,null,null,null,"'12:00:00 PM",{"$f":"SUBSTITUTE(N30,\":00 PM\",\" PM\")","v":"'12:00 PM"}]
[null,"8:00 PM",null,null,null,null,null,null,null,null,null,null,null,"'12:30:00 PM","'12:30 PM"]
[null,"8:30 PM",null,null,null,null,null,null,null,null,null,null,null,"'1:00:00 PM","'1:00 PM"]
[null,"9:00 PM",null,null,null,null,null,null,null,null,null,null,null,"'1:30:00 PM","'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'2:00:00 PM","'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'2:30:00 PM","'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'3:00:00 PM","'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'3:30:00 PM","'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'4:00:00 PM","'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'4:30:00 PM","'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:00:00 PM","'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:30:00 PM","'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:00:00 PM","'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:30:00 PM","'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'7:00:00 PM","'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'7:30:00 PM","'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'8:00:00 PM","'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'8:30:00 PM","'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'9:00:00 PM","'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'9:30:00 PM","'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'10:00:00 PM","'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'10:30:00 PM","'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'11:00:00 PM","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'11:30:00 PM","'11:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'12:00 AM","'12:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'12:30 AM","'12:30 AM"]
[null,null,null,2,null,null,null,null,null,null,null,null,null,"'1:00 AM","'1:00 AM"]
[null,null,null,3,null,null,null,null,null,null,null,null,null,"'1:30 AM","'1:30 AM"]
[null,null,null,4,null,null,null,null,null,null,null,null,null,"'2:00 AM","'2:00 AM"]
[null,null,null,5,null,null,null,null,null,null,null,null,null,"'2:30 AM","'2:30 AM"]
[null,null,null,6,null,null,null,null,null,null,null,null,null,"'3:00 AM","'3:00 AM"]
[null,null,null,7,null,null,null,null,null,null,null,null,null,"'3:30 AM","'3:30 AM"]
[null,null,null,8,null,null,null,null,null,null,null,null,null,"'4:00 AM","'4:00 AM"]
[null,null,null,9,null,null,null,null,null,null,null,null,null,"'4:30 AM","'4:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:00 AM","'5:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:30 AM","'5:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:00 AM","'6:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:30 AM","'6:30 AM"]
[null,null,null,null,null,1,null,null,null,null,null,null,null,"'7:00 AM","'7:00 AM"]
[null,null,null,null,null,"Connector Group Retiree Meeting",null,null,null,null,null,null,null,"'7:30 AM","'7:30 AM"]
[null,null,null,null,null,"Formal",null,null,null,null,null,null,null,"'8:00 AM","'8:00 AM"]
[null,null,null,null,null,"Informal",null,null,null,null,null,null,null,"'8:30 AM","'8:30 AM"]
[null,"Educational Events",null,null,null,null,null,null,null,null,null,null,null,"'9:00 AM","'9:00 AM"]
[null,"Health Fair/Expo",null,null,null,null,null,null,null,null,null,null,null,"'9:30 AM","'9:30 AM"]
[null,"Kiosk",null,null,null,"Connector Group Retiree Meeting",null,null,null,null,null,null,null,"'10:00 AM","'10:00 AM"]
[null,"Member Meeting",null,null,null,"Active - Public",null,null,null,null,null,null,null,"'10:30 AM","'10:30 AM"]
[null,"Resource Center",null,null,null,"Active - Non Public",null,null,null,null,null,null,null,"'11:00 AM","'11:00 AM"]
[null,"Sales Meeting",null,null,null,null,null,null,null,null,null,null,null,"'11:30 AM","'11:30 AM"]
[null,"UHC Store",null,null,null,null,null,null,null,null,null,null,null,"'12:00:00 PM","'12:00 PM"]
[null,"UHC/Agency Office",null,null,null,null,null,null,null,null,null,null,null,"'12:30:00 PM","'12:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'1:00:00 PM","'1:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'1:30:00 PM","'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'2:00:00 PM","'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'2:30:00 PM","'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'3:00:00 PM","'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'3:30:00 PM","'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'4:00:00 PM","'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'4:30:00 PM","'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:00:00 PM","'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'5:30:00 PM","'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:00:00 PM","'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'6:30:00 PM","'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'7:00:00 PM","'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'7:30:00 PM","'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'8:00:00 PM","'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'8:30:00 PM","'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'9:00:00 PM","'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'9:30:00 PM","'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'10:00:00 PM","'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'10:30:00 PM","'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'11:00:00 PM","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'11:30:00 PM","'11:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:0 AM","'12:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:021 AM","'12:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:042 AM","'1:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:063 AM","'1:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:083 AM","'2:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:104 AM","'2:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:125 AM","'3:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:146 AM","'3:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:167 AM","'4:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:188 AM","'4:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:208 AM","'5:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:229 AM","'5:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:25 AM","'6:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:271 AM","'6:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:292 AM","'7:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:313 AM","'7:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:333 AM","'8:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:354 AM","'8:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:375 AM","'9:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:396 AM","'9:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:417 AM","'10:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:438 AM","'10:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:458 AM","'11:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:479 AM","'11:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0:5 PM","'12:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:521 PM","'12:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:542 PM","'1:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:563 PM","'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:583 PM","'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:604 PM","'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:625 PM","'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:646 PM","'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:667 PM","'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:688 PM","'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:708 PM","'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:729 PM","'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0:75 PM","'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:771 PM","'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:792 PM","'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:813 PM","'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:833 PM","'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:854 PM","'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:875 PM","'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:896 PM","'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:917 PM","'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:938 PM","'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:958 PM","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0:979 PM","'11:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.0 AM","'12:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.021 AM","'12:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.042 AM","'1:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.063 AM","'1:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.083 AM","'2:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.104 AM","'2:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.125 AM","'3:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.146 AM","'3:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.167 AM","'4:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.188 AM","'4:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.208 AM","'5:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.229 AM","'5:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.25 AM","'6:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.271 AM","'6:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.292 AM","'7:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.313 AM","'7:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.333 AM","'8:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.354 AM","'8:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.375 AM","'9:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.396 AM","'9:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.417 AM","'10:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.438 AM","'10:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.458 AM","'11:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.479 AM","'11:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.5 PM","'12:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.521 PM","'12:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.542 PM","'1:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.563 PM","'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.583 PM","'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.604 PM","'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.625 PM","'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.646 PM","'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.667 PM","'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.688 PM","'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.708 PM","'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.729 PM","'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.75 PM","'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.771 PM","'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.792 PM","'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.813 PM","'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.833 PM","'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.854 PM","'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.875 PM","'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.896 PM","'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.917 PM","'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.938 PM","'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.958 PM","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.979 PM","'11:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.0","'12:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.021","'12:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.042","'1:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.063","'1:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.083","'2:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.104","'2:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.125","'3:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.146","'3:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.167","'4:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.188","'4:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.208","'5:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.229","'5:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.25","'6:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.271","'6:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.292","'7:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.313","'7:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.333","'8:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.354","'8:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.375","'9:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.396","'9:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.417","'10:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.438","'10:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.458","'11:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.479","'11:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.5","'12:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.521","'12:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.542","'1:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.563","'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.583","'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.604","'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.625","'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.646","'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.667","'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.688","'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.708","'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.729","'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.75","'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.771","'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.792","'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.813","'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.833","'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.854","'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.875","'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.896","'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.917","'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.938","'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.958","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"'0.979","'11:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.0","'12:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.021","'12:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.042","'1:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0.063","'1:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000004E-2,"'2:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.104,"'2:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.125,"'3:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.14599999999999999,"'3:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.16700000000000001,"'4:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.188,"'4:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.20799999999999999,"'5:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.22900000000000001,"'5:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,"'6:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.27100000000000002,"'6:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.29199999999999998,"'7:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.313,"'7:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.33300000000000002,"'8:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35399999999999998,"'8:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.375,"'9:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.39600000000000002,"'9:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.41699999999999998,"'10:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.438,"'10:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45800000000000002,"'11:00 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.47899999999999998,"'11:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"'12:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.52100000000000002,"'12:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.54200000000000004,"'1:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.56299999999999994,"'1:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.58299999999999996,"'2:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.60399999999999998,"'2:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.625,"'3:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.64600000000000002,"'3:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.66700000000000004,"'4:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.68799999999999994,"'4:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.70799999999999996,"'5:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.72899999999999998,"'5:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,"'6:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.77100000000000002,"'6:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.79200000000000004,"'7:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.81299999999999994,"'7:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.83299999999999996,"'8:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85399999999999998,"'8:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.875,"'9:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.89600000000000002,"'9:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.91700000000000004,"'10:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.93799999999999994,"'10:30 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95799999999999996,"'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.97899999999999998,"'11:30 PM"]

{"sheet":"Updates","index":4,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Date","Update","Description"]
["2017-12-22","Preliminary Time Decode","Added Time variation entry validation in 30 minute increments in 24 hours: \nVariation #1; 12:30 PM entered as 12:30:00 PM \nVariation #2; 12:00 PM entry resulting in excel value 0.5 PM, \nVariation #3; 12:00 PM entry resulting in excel value 0:5 PM \nVariation #4; 12:00 PM entry resulting in excel value 0.5"]
["2018-01-15","Date string update","Added Date variation entry validation for paste entry: \nNew handler logic for string entry as '20180129' \nupdate logic corrects entry as 01/29/2018 "]
["2018-02-23","Prelim Time Code Corrections","Added additional logic to handle copy/paste for Start & End Time"]
["2018-02-23","End Time - StartTime > 1 hour logic","Added additional logic to handle 1 hour min between Start & End Time"]
["2018-02-23","Prelim Zip Code Corrections","Added additional logic to correct less than 5 char entry"]
["2018-02-24","Added char removal for '…' char","Added additional logic to correct 'triple' period char (133) "]
["2018-03-09","Removed Change and Cancel Tabs","Removed Change and Cancel Tabs"]
["2018-03-23","Split New Events into new file","New Events is in it's own file"]
["2018-03-23","Added new field: Collect RSVP","New Field Collect RSVP added to the New Events in column: R"]
["2018-03-23","Added new field: UHC Advertising","New Field UHC Advertising added to the New Events in column: S"]
["2018-03-23","Added new logic to validate Collect RSVP","Collect RSVP values can only be 'Yes' or 'No'; If anything else then Collect RSVP='No'"]
["2018-03-23","Added new logic to validate UHC Advertising","UHC Advertising values follow the Collect RSVP value: \nif Collect RSVP='Yes' then UHC Advertising can be 'Yes' or 'No' \nif Collect RSVP='No' then UHC Advertising='No'"]
["2018-04-12","Updated Instructions tab","Updated Instructions tab to 'NEW' instructions"]
["2018-04-12","Updated Pipe logic","Added logic to test for last pipe char, remove it if it exists"]
["2018-04-12","Reinstalled LOV list references for Drop-downs","All the LOV lists were pointing to an external last saved file name location! \nRemapped all LOV references to THIS file!"]
["2018-04-12","Updated Header Row alerts","Updated Header Row alerts and verbiage as specified"]
["2018-04-12","Hover over update","Update all Hover overs as specified"]
["2018-04-12","Fixed Language field header name","The Field had a trailing 'Space' character that impacted the field validation "]
["2018-04-12","Added Error Color Control","Hidden sheet [Sh1_DateSpecs] cell C20 contains a control cell for Error Hi-Lighting. \nSimply set the cell color to whatever color needed. \nThe VBA side will auto pick up the color"]
["2018-04-12","Request Form Engine name updated","Hidden sheet [Sh1_DateSpecs] cell R2 contains the version control cell. \nUpdated to: ERA Form version 5.0K 2018/04/12 04:15 PM \nThis reference is tagged in the email submission after validation."]
["2018-04-12","Validation error dialog updated","Validation error dialog updated to specification"]
["2018-04-12","Fixed Owning Agent Name error","Fixed Owning Agent Name error when field is blank"]
["2018-04-16","Directions tab update","Updated the Directions tab as specified on email dated 4/13/2018"]
["2018-04-16","New Events Tab update","Updated the Directions tab as specified on email dated 4/13/2018"]
["2018-04-16","Data after Column 'S' removed","New logic removes all data after column 'S' "]
["2018-04-16","Replace Field Names on New Events Tab","During Validation process, the form fields are re-written in case they were cleared"]
["2018-04-17","Bug Correction for test case #10","Fixed VBA error in End Date field for test case #10"]
["2018-04-17","Venue Name Field Clean & Trim","Added Logic to Clean and Trim the field for non-printing chars and leading/trailing spaces"]
["2018-04-17","Venue Street Address field Clean & Trim","Added Logic to Clean and Trim the field for non-printing chars and leading/trailing spaces"]
["2018-04-17","Venue Name Length >40 Chars","Added Logic to test length, if 40 chars, the cell is hilited as an error"]
["2018-04-17","Venue Street Address Length >40 Chars","Added Logic to test length, if 40 chars, the cell is hilited as an error"]
["2018-04-18","Change Form copied from latest NEW Form","Change Form copied from latest NEW Form"]
["2018-04-18","Change fields Added/Removed per specification","Base Change Form fields updated for Change Event processing"]
["2018-04-18","Added Field validation bypass logic","Added Field Validation ByPass logic for all Fields not included in the Change Processing. \nExample: The [Venue Type] field\nThis field is not in the Change processing so the validation is bypassed or skipped"]
["2018-04-18","Added Event ID Field Validation","Added Event ID Field Validation"]
["2018-04-19","Updated Event ID Field Validation","A bug in the Event ID Field Validation was corrected"]
["2018-04-19","Cell Validation update: Collect RSVP","Cosmetic update for the Collect RSVP cell validation error entry"]
["2018-04-19","Cell Validation update: UHC Advertising","Cosmetic update for the UHC Advertising cell validation error entry"]
["2018-04-24","Updated Field Validation Messages","Updated Field Validation Messages per email document rec'd on 4/20/2018"]
["2018-04-24","Updated Change Events cell E1 alert","Alert: Change events must be submitted at least 1 calendar day before the event date"]
["2018-04-24","Updated vba logic for Change days > today","Code update for Event Date to be 1 calendar day greater than today"]
["2018-04-24","Updated Instructions cell A2 alert","Alert: updated to 'Cancel Event Request Form…'"]
["2018-05-02","Copied Latest 'Change' Form as 'Cancel'","Copied Latest 'Change' Form file as 'Cancel' file"]
["2018-05-03","Updated Venue Name Cell validation","Updated validation to Field length between 0 and 40 characters"]
["2018-05-03","Updated Instructions tab","Updated Instructions tab to 'Cancel' instructions"]
["2018-05-03","Updated Error validation cells for 'Cancel'","Updated Error validation cells for 'Cancel'"]
["2018-05-03","Updated cell validation Entry messages for 'Cancel'","Updated cell validation Entry messages for all 'Cancel' fields"]
["2018-05-03","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-04 111545W"]
["2018-05-03","Updated Validation double-click action","Inserting a new row 1 moved the validation/submission button to row from 2 to 3"]
["2018-05-03","Updated vba side 'MeetingTOP' reference","Inserting a new row 1 moved the 'Meeting TOP' reference from A5 to A6"]
["2018-05-03","Cell validation: Venue Name","Updated Entry validation to text length between 0 and 40 characters"]
["2018-05-03","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-04 163600X"]
["2018-05-03","eMail attachment updated to XLS file","eMail attachment updated to XLS file"]
["2018-05-03","Meeting ID (optional) cell color updated to Lt.Blue","Meeting ID (optional) cell color updated to Lt.Blue"]
["2018-05-03","Inserted Change Reason (Required) field","Inserted Change Reason (Required) field with appropriate LOVs for drop-down"]
["2018-05-03","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-04 170000Y"]
["2018-05-08","Display Columns Control Update","Updated Columns to Display to Column 'N'"]
["2018-05-08","update on LOV for field: Cancellation Reason","Updated LOV value: “Agent Ill” to “Agent ill”."]
["2018-05-08","Tested Zip Code field","Ran test cases for Zip Code field performance; all is well."]
["2018-05-08","Updated Zip Code field","Updated Zip Code field for Alpha characters: Hi-Lite as error if ant char is non numeric"]
["2018-05-08","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-08 140000Z"]
["2018-05-08","Updated eMail Alert title line","Updated eMail alert line break between 'up' and 'before'"]
["2018-05-08","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-08 154030Z"]
["2018-05-02"," Directions tab Updates","Spelling updates on Directions tab"]
["2018-05-02","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-11 122215Z"]
["2018-05-14"," Directions tab Updates","updated to '…more than 1 business day..."]
["2018-05-14","Updated Field Headers","Field Headers updated with word wrap and widths adjusted"]
["2018-05-14","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-14 151530Z"]
["2019-05-28","Removed member and educational events"]

{"sheet":"Test data","index":5,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"\"Col: \"&CHAR(COLUMN()+64)","v":"Col: B"},{"$f":"\"Col: \"&CHAR(COLUMN()+64)","v":"Col: C"},"Col: D","Col: E","Col: F","Col: G","Col: H","Col: I","Col: J","Col: K","Col: L","Col: M","Col: N","Col: O","Col: P","Col: Q","Col: R","Col: S","Col: T"]
["Count","Event ID",null,"(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)"]
[null,null,"Cancellation Reason","Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","End Time","Event Category","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #"]
[1,12345678,"Venue/Date/Time Entry Error","Jamestown Place","1533 Pike Lane SE","24014","2018-07-20","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[2,123456789,"Venue Not Available","Test after Column Q","2034 Indian Village Lane SE","24013","2018-05-21","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686","Kiosk","Active - Non Public","MA Dual"]
[3,1234567,"Inclement Weather","Test 1 date format","123 Main St ","24013",20180531,"1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[4,"wwwwww","Agent ill","Test 2 time format","123 Main St ","24013","2018-05-22","130pm","2:30pm","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[5,null,"At Agent Request","Test 3 time format","123 Main St ","24013","2018-05-23","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[6,null,null,"Test 6, commas and periods.","123 Main St. S., Suite 100",24013,"2018-05-31","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[7,null,"kkkkkkkkkk","Test 7 zip code 4 digit","123 Main St ",2413,"2018-05-25","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[8,null,99999999999,"Test 8 seating capacity not numeric","123 Main St ",24013,"2018-07-26","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[9,null,"At Agent Request","venue name length……………………………………..       ","venue address length…………………………………………….",24013,"2018-07-26","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[10,null,"At Agent Request","Venue name with extra spaces                                                      ","Venue address with extra spaces                                                      ","24014","2018-07-20","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]
[11,null,99999999999,"Test 8 seating capacity not numeric","123 Main St ","444u6","2018-07-26","01:00:00","2:99 PM","Sales Event (Informal): Resource Center","Leslie Payne","2175686","Leslie Payne","2175686"]

{"sheet":"Update Copy","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["MMMMMM","MMMMMMMMMMMMMMMMMMMMMMMMMM","MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM"]
["Date","Update","Description"]
["2018-05-14"," Directions tab Updates","updated to '…more than 1 business day..."]
["2018-05-14","Updated Field Headers","Field Headers updated with word wrap and widths adjusted"]
["2018-05-14","Saved Events Request Engine as new File Name","New File Name: Event CANCEL Request Form 2018-05-14 151530Z"]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}