{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","New Events","Sh1_DateSpecs","LOVs","Updates","Test data","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":63,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"\"New Event Request Form (\"&AlertFormEffectiveDate&\")\"","v":"New Event Request Form (form effective date: 6/1/2023)"}]
[]
["Complete the tab titled New Events to report your new events 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."]
[" Or "]
["This form may be submitted directly to UnitedHealthcare's event reporting application by double-clicking the Validate and Submit button on the New Events tab. "]
[]
["New events must be submitted at least 7 calendar 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)"]
["1. If Excel prompts, click the Enable Content and/or Enable Editing buttons"]
["2. Go to the New Events tab of this workbook to report new events to UnitedHealthcare"]
["3. All fields are required"]
["4. Review other instructions/guidance on this tab"]
["5.Click Save and then send this form to your local UnitedHealthcare market for entry \n    OR\n    Double click the Validate and Submit button at the top of the New Events tab  to send the form directly to UnitedHealthcare for processing. Forms submitted before 9:45pm CST will be processed same\n    day. "]
["Instructions/Guidance"]
["Venue Name - Recommend using the same name as the signage at the location. When possible limit to 24 characters for advertising purposes, maximum allowed is 40 characters"]
[]
["Venue Address - Recommend using United States Postal Service standard address for the location with standard abbreviations; e.g. preferred 1234 Main St S, not 1234 Main. Maximum characters allowed is 40 characters."]
[]
["Which Event Category should I use?"]
["Sales Event: event designed to perform marketing activities including plan benefits , lead generation and/or obtaining Scope of Appointment forms."]
["- Formal Sales Event: Structured plan presentation conducted by an agent to an audience."]
["> Sales Meeting - In person formal sales event\n"]
["- Informal Sales Event: 1:1 interaction between the agent and consumer in more casual setting. \n"]
["> Resource Center - Informal sales event; venue type varies. Often conducted at hotels, agency offices or UnitedHealthcare offices. Often manned by multiple agents.\n"]
["> Walk-in Location - Informal sales event; venue type varies. Often conducted at retail locations  or provider offices where the consumer is coming to this location for another purpose. Often manned by a single agent."]
[]
["What should I enter for Seating Capacity?"]
["Research the venue's capacity.  Seating capacity must be between 1 and 999."]
[]
["What is the difference between Owning and Presenting Agent? "]
["Owning Agent: Receives all event RSVPs in Mira (if applicable).  If RSVPs may be collected, the owning agent must have an active Mira account."]
[]
["Presenting Agent: Conducts the event (i.e., delivers the presentation or has the 1:1 interaction with the consumer). Only one presenting agent can be entered for an event. The owning and presenting agent can be the same "]
["agent or different agents.  Both the owning and presenting agent must successfully complete the Event Basics module for the applicable plan year, must be product certified, and must be licensed and appointed in the state in "]
["order to report the event.  Please ensure that an active Writing ID is used when entering the event and include  leading zero,  if applicable . "]
[]
["Other agents may be present at the event. "]
[]
["What Product should I list?"]
["Select the product type the agent is leading with at the event. The agent can talk about other product types, dependent upon consumer needs and assuming they are appropriately product certified.  "]
["Do NOT pick a product type that is NOT available in the service area where the venue is located. "]
[]
["How do I enter a request for a sign language interpreter (ASL)?"]
["Fill out the ASL Interpreter request form located on Jarvis.  Then an interpreter from ASL Services Inc. will call to coordinate.  If you have questions, contact ASL@UHC.com.  "]
[]
[]
["For more information on policy & compliance, see section 5 of the Agent Guide located on Jarvis.  Compliance questions may also be submitted to Compliance_Questions@uhc.com ."]
["For other event reporting related questions, please contact your UnitedHealthcare Market Sales Manager or the Producer Help Desk at phd@uhc.com"]

{"sheet":"New Events","index":1,"n_rows":220,"n_cols":19,"rows_kept":220,"cut":false,"hidden":false,"merged":[[0,7,1,7],[1,2,1,3],[0,1,0,6]]}
[null,{"$f":"AlertFormEffectiveDate2 &\"       \" & AlertNewEventsSubmit","v":"Form effective date: 6/1/2023       New events must be submitted at least 7 calendar days before the event date"},null,null,null,null,null,"Be sure your email program is up before \nusing Validate and Submit and submit \nbefore 9:45pm CST for same day processing"]
[null,null,"New Event Request Form",null,{"$f":"Alert2","v":" "},"<Validate and Submit>","<Save>"]
[]
[null,"(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)",{"$f":"R4","v":"(Required)"}]
["Count","Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","End Time","Event Category","Language","Presenting Product","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #","Seating Capacity","Venue Type","Venue Phone","Collect RSVP","UHC Advertising"]
[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]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]

{"sheet":"Sh1_DateSpecs","index":2,"n_rows":56,"n_cols":34,"rows_kept":56,"cut":false,"hidden":true,"merged":[[48,19,48,20],[53,18,53,19],[3,22,25,28]]}
["x","xxxxxxxxxxxxx","xxxxxxxxxx","x","xxxxx","xxxxxxxxxx","xxxxxxxxxxxxxxx","xxxxxxx","xxxxxxx","xxxxxxx","xxxxxxxxxx","x","xxxxxxxxxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Event Fields","Width"]
[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 6/08/2023 and 9/30/2024"},null,null,null,null,null,null,null,null,null,null,null,"ERA Form Version:","ERA Form version 6.5W 2022/01/01 0400PM","ßMake Version changes here",null,null,"eMail Fail Override:",false,null,null,null,null,null,null,null,null,1,"Count",5]
[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,"Venue Name",25]
[null,"TestToday:",{"$f":"NOW()","v":"2023-06-01T13:11:00.070"},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,"Venue Street Address",25]
[null,"Days Buffer:",7,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E5,E5)-1,E5,1)","v":"2023-01-01"},{"$f":"TEXT(F5,\"MMMM-YYYY\")","v":"January-2023"},{"$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,"Pipe Extension:",".csv",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Venue Zip",9]
[null,"TestTodayPlus:",{"$f":"TestDay+TestDaysBuffer","v":"2023-06-08T13:11:00.070"},null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E6,E6)-1,E6,1)","v":"2023-02-01"},{"$f":"TEXT(F6,\"MMMM-YYYY\")","v":"February-2023"},false,false,{"$f":"AND(H6,I6)","v":false},{"$f":"IF(J6,F6,0)","v":"00:00:00"},null,"S_DeltaMax",20,null,null,"eMailFile:","NewEventRequestExport amora20 2021-09-14-142145.csv",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Event Date",12]
[null,null,{"$f":"EOMONTH(TestDayPlus,-1)+1","v":"2023-06-01"},null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E7,E7)-1,E7,1)","v":"2023-03-01"},"March-2023",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,"Start Time",18]
[null,"MonthsLogic:",{"$f":"1*(MONTH(TestDay)>5)","v":1},null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E8,E8)-1,E8,1)","v":"2023-04-01"},"April-2023",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":"sales_events@uhc.com"},"ßSee cell U51 to control eMail recipient",null,null,null,null,null,null,null,null,null,null,null,null,7,"End Time",12]
[null,"ArrayLoad:",{"$f":"COUNTIF(J4:J25,TRUE)","v":15},null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E9,E9)-1,E9,1)","v":"2023-05-01"},"May-2023",false,false,false,"00:00:00",null,null,null,null,null,"eMail Subject:","ERA New Event Pipe Delimited File for Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Event Category",31]
[null,null,null,null,6,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E10,E10)-1,E10,1)","v":"2023-06-01"},"June-2023",false,true,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,"Language",13]
[null,"vbaDateStart1:","2017-02-01",null,7,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E11,E11)-1,E11,1)","v":"2023-07-01"},"July-2023",true,true,true,"2023-07-01",null,null,null,null,null,"eMail Body2:","Please process the attached New Meeting Event Pipe Delimited file: ",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Presenting Product",11]
[null,"vbaDateEnd1:","2017-02-28",null,8,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E12,E12)-1,E12,1)","v":"2023-08-01"},"August-2023",true,true,true,"2023-08-01",null,null,null,null,null,"eMail Body3:",{"$f":"eMailFile","v":"NewEventRequestExport amora20 2021-09-14-142145.csv"},null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Owning Agent Name",24]
[null,null,null,null,9,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E13,E13)-1,E13,1)","v":"2023-09-01"},"September-2023",true,true,true,"2023-09-01",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 #",15]
[null,"MonthStartMax:",{"$f":"MAX(MonthsValid)","v":"2024-09-01"},null,10,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E14,E14)-1,E14,1)","v":"2023-10-01"},"October-2023",{"$f":"IF(MonthsIndex=1,TRUE,FALSE)","v":true},true,true,"2023-10-01",null,null,null,null,null,"eMail Body5:",{"$f":"ERA_FormVersion","v":"ERA Form version 6.5W 2022/01/01 0400PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Presenting Agent Name",25]
[null,"MonthStartMaxEnd:",{"$f":"EOMONTH(MonthStartMax,0)","v":"2024-09-30"},null,11,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E15,E15)-1,E15,1)","v":"2023-11-01"},"November-2023",{"$f":"IF(MonthsIndex=1,TRUE,FALSE)","v":true},true,true,"2023-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 #",15]
[null,null,null,null,12,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E16,E16)-1,E16,1)","v":"2023-12-01"},"December-2023",true,true,true,"2023-12-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Seating Capacity",9]
[null,"Delete PipeFile:",true,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E17,E17)-1,E17,1)","v":"2024-01-01"},"January-2024",true,true,true,"2024-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Venue Type",25]
[null,null,null,null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E18,E18)-1,E18,1)","v":"2024-02-01"},"February-2024",true,true,true,"2024-02-01",null,null,null,null,null,"PC Name:","LH7U05CG709370Z",null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Venue Phone",12]
[null,null,null,null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E19,E19)-1,E19,1)","v":"2024-03-01"},"March-2024",true,true,true,"2024-03-01",null,null,null,null,null,"UserID:","amora20",null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Collect RSVP",8]
[null,"Error Cell Color:","Cell Color",null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E20,E20)-1,E20,1)","v":"2024-04-01"},"April-2024",true,true,true,"2024-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"UHC Advertising",10]
[null,null,null,null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E21,E21)-1,E21,1)","v":"2024-05-01"},"May-2024",true,true,true,"2024-05-01",null,null,null,null,null,null,null,"eMail list index:"]
[null,null,null,null,6,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E22,E22)-1,E22,1)","v":"2024-06-01"},"June-2024",true,true,true,"2024-06-01",null,null,null,null,null,"Email Addresses:","sales_events@uhc.com",1]
[null,null,null,null,7,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E23,E23)-1,E23,1)","v":"2024-07-01"},"July-2024",true,true,true,"2024-07-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",2]
[null,null,null,null,8,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E24,E24)-1,E24,1)","v":"2024-08-01"},"August-2024",true,true,true,"2024-08-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",3]
[null,null,null,null,9,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E25,E25)-1,E25,1)","v":"2024-09-01"},"September-2024",true,true,true,"2024-09-01",null,null,null,null,null,null,"andrea_harrell@uhc.com",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Send:",false,"ßTRUE if Cell R51=Production"]
[null,null,null,null,null,"2023-06-01",":Form Effective Date"]
[null,null,null,null,null,null,"Instructions Tab:",{"$f":"\"form effective date: \" &TEXT(F28,\"M/D/YYYY\")","v":"form effective date: 6/1/2023"}]
[null,null,null,null,null,null,"New Events Tab:",{"$f":"\"Form effective date: \" &TEXT(F28,\"M/D/YYYY\")","v":"Form effective date: 6/1/2023"},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,"Form Submitted B4:",{"$f":"\"New events must be submitted at least \" &F32 &\" calendar days before the event date\"","v":"New events must be submitted at least 7 calendar days before the event date"},null,null,null,null,null,null,null,null,"Change eMail TO:",{"$f":"INDEX(eMailMatrix,2,IF(MID(eMailOptionProdDev,1,3)=\"Pro\",1,2))","v":"sales_events@uhc.com"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Subject:","ERA <SubmitType> Event File for Processing"]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,"Change eMail Body3:",{"$f":"eMailFile","v":"NewEventRequestExport amora20 2021-09-14-142145.csv"}]
[null,null,null,null,null,null,null,null,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 Form version 6.5W 2022/01/01 0400PM"}]
[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,null,null,"eMail list index:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Email Addresses:","phd@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,"andrea_harrell@uhc.com",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"You can Change Cell R51 from Production or Development","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,"Production","New Events","sales_events@uhc.com","andrea_harrell@uhc.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change/Cancel","sales_events@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…"]
[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?","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\",\" \")","v":" "}]

{"sheet":"LOVs","index":3,"n_rows":293,"n_cols":17,"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,"Yes/No",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,"No",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,"Yes",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,null,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,null,null,"'12:00:00 AM",{"$f":"SUBSTITUTE(P6,\":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,null,null,"'12:30:00 AM",{"$f":"SUBSTITUTE(P7,\":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,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,"Change",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,"Cancel",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,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,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,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,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,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,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,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,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,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,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,null,null,"'7:30:00 AM","'7:30 AM"]
[null,"3:30 PM",null,null,null,null,null,"Tagalog",null,"Other",null,null,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,null,null,"'8:30:00 AM","'8:30 AM"]
[null,"4:30 PM",null,null,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,null,null,"'9:30:00 AM","'9:30 AM"]
[null,"5:30 PM",null,null,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,null,null,"'10:30:00 AM","'10:30 AM"]
[null,"6:30 PM",null,null,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,null,null,"'11:30:00 AM","'11:30 AM"]
[null,"7:30 PM",null,null,null,null,null,null,null,null,null,null,null,null,null,"'12:00:00 PM",{"$f":"SUBSTITUTE(P30,\":00 PM\",\" PM\")","v":"'12:00 PM"}]
[null,"8:00 PM",null,null,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,null,null,"'1:00:00 PM","'1:00 PM"]
[null,"9: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,null,null,"'2:00:00 PM","'2:00 PM"]
[null,null,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,null,null,"'3:00:00 PM","'3:00 PM"]
[null,null,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,null,null,"'4:00:00 PM","'4:00 PM"]
[null,null,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,null,null,"'5:00:00 PM","'5:00 PM"]
[null,null,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,null,null,"'6:00:00 PM","'6:00 PM"]
[null,null,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,null,null,"'7:00:00 PM","'7:00 PM"]
[null,null,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,null,null,"'8:00:00 PM","'8:00 PM"]
[null,null,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,null,null,"'9:00:00 PM","'9:00 PM"]
[null,null,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,null,null,"'10:00:00 PM","'10:00 PM"]
[null,null,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,null,null,"'11:00:00 PM","'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'11:30:00 PM","'11:30 PM"]
[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"'12:00 AM","'12:00 AM"]
[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,"'12:30 AM","'12:30 AM"]
[null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,"'1:00 AM","'1:00 AM"]
[null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,"'1:30 AM","'1:30 AM"]
[null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,"'2:00 AM","'2:00 AM"]
[null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,"'2:30 AM","'2:30 AM"]
[null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,"'3:00 AM","'3:00 AM"]
[null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,"'3:30 AM","'3:30 AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'4:00 AM","'4:00 AM"]
[null,null,null,null,null,null,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,null,null,"'5:00 AM","'5:00 AM"]
[null,null,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,null,null,"'6:00 AM","'6:00 AM"]
[null,null,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,null,null,"'7:00 AM","'7:00 AM"]
[null,null,null,null,null,"Connector Group Retiree Meeting",null,null,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,null,null,"'8:00 AM","'8:00 AM"]
[null,null,null,null,null,"Informal",null,null,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,null,null,"'9:00 AM","'9:00 AM"]
[null,"Health Fair/Expo",null,null,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,null,null,"'10:00 AM","'10:00 AM"]
[null,"Member Meeting",null,null,null,"Active - Public",null,null,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,null,null,"'11:00 AM","'11:00 AM"]
[null,"Sales Meeting",null,null,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,null,null,"'12:00:00 PM","'12:00 PM"]
[null,"UHC/Agency Office",null,null,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,null,null,"'1:00:00 PM","'1:00 PM"]
[null,null,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,null,null,"'2:00:00 PM","'2:00 PM"]
[null,null,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,null,null,"'3:00:00 PM","'3:00 PM"]
[null,null,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,null,null,"'4:00:00 PM","'4:00 PM"]
[null,null,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,null,null,"'5:00:00 PM","'5:00 PM"]
[null,null,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,null,null,"'6:00:00 PM","'6:00 PM"]
[null,null,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,null,null,"'7:00:00 PM","'7:00 PM"]
[null,null,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,null,null,"'8:00:00 PM","'8:00 PM"]
[null,null,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,null,null,"'9:00:00 PM","'9:00 PM"]
[null,null,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,null,null,"'10:00:00 PM","'10:00 PM"]
[null,null,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,null,null,"'11:00:00 PM","'11:00 PM"]
[null,null,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,null,null,"'0:0 AM","'12:00 AM"]
[null,null,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,null,null,"'0:042 AM","'1:00 AM"]
[null,null,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,null,null,"'0:083 AM","'2:00 AM"]
[null,null,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,null,null,"'0:125 AM","'3:00 AM"]
[null,null,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,null,null,"'0:167 AM","'4:00 AM"]
[null,null,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,null,null,"'0:208 AM","'5:00 AM"]
[null,null,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,null,null,"'0:25 AM","'6:00 AM"]
[null,null,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,null,null,"'0:292 AM","'7:00 AM"]
[null,null,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,null,null,"'0:333 AM","'8:00 AM"]
[null,null,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,null,null,"'0:375 AM","'9:00 AM"]
[null,null,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,null,null,"'0:417 AM","'10:00 AM"]
[null,null,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,null,null,"'0:458 AM","'11:00 AM"]
[null,null,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,null,null,"0:5 PM","'12:00 PM"]
[null,null,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,null,null,"'0:542 PM","'1:00 PM"]
[null,null,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,null,null,"'0:583 PM","'2:00 PM"]
[null,null,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,null,null,"'0:625 PM","'3:00 PM"]
[null,null,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,null,null,"'0:667 PM","'4:00 PM"]
[null,null,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,null,null,"'0:708 PM","'5:00 PM"]
[null,null,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,null,null,"0:75 PM","'6:00 PM"]
[null,null,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,null,null,"'0:792 PM","'7:00 PM"]
[null,null,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,null,null,"'0:833 PM","'8:00 PM"]
[null,null,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,null,null,"'0:875 PM","'9:00 PM"]
[null,null,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,null,null,"'0:917 PM","'10:00 PM"]
[null,null,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,null,null,"'0:958 PM","'11:00 PM"]
[null,null,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,null,null,"0.0 AM","'12:00 AM"]
[null,null,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,null,null,"'0.042 AM","'1:00 AM"]
[null,null,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,null,null,"'0.083 AM","'2:00 AM"]
[null,null,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,null,null,"'0.125 AM","'3:00 AM"]
[null,null,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,null,null,"'0.167 AM","'4:00 AM"]
[null,null,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,null,null,"'0.208 AM","'5:00 AM"]
[null,null,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,null,null,"0.25 AM","'6:00 AM"]
[null,null,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,null,null,"'0.292 AM","'7:00 AM"]
[null,null,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,null,null,"'0.333 AM","'8:00 AM"]
[null,null,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,null,null,"'0.375 AM","'9:00 AM"]
[null,null,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,null,null,"'0.417 AM","'10:00 AM"]
[null,null,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,null,null,"'0.458 AM","'11:00 AM"]
[null,null,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,null,null,"0.5 PM","'12:00 PM"]
[null,null,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,null,null,"'0.542 PM","'1:00 PM"]
[null,null,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,null,null,"'0.583 PM","'2:00 PM"]
[null,null,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,null,null,"'0.625 PM","'3:00 PM"]
[null,null,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,null,null,"'0.667 PM","'4:00 PM"]
[null,null,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,null,null,"'0.708 PM","'5:00 PM"]
[null,null,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,null,null,"0.75 PM","'6:00 PM"]
[null,null,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,null,null,"'0.792 PM","'7:00 PM"]
[null,null,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,null,null,"'0.833 PM","'8:00 PM"]
[null,null,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,null,null,"'0.875 PM","'9:00 PM"]
[null,null,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,null,null,"'0.917 PM","'10:00 PM"]
[null,null,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,null,null,"'0.958 PM","'11:00 PM"]
[null,null,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,null,null,"0.0","'12:00 AM"]
[null,null,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,null,null,"'0.042","'1:00 AM"]
[null,null,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,null,null,"'0.083","'2:00 AM"]
[null,null,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,null,null,"'0.125","'3:00 AM"]
[null,null,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,null,null,"'0.167","'4:00 AM"]
[null,null,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,null,null,"'0.208","'5:00 AM"]
[null,null,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,null,null,"0.25","'6:00 AM"]
[null,null,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,null,null,"'0.292","'7:00 AM"]
[null,null,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,null,null,"'0.333","'8:00 AM"]
[null,null,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,null,null,"'0.375","'9:00 AM"]
[null,null,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,null,null,"'0.417","'10:00 AM"]
[null,null,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,null,null,"'0.458","'11:00 AM"]
[null,null,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,null,null,"0.5","'12:00 PM"]
[null,null,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,null,null,"'0.542","'1:00 PM"]
[null,null,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,null,null,"'0.583","'2:00 PM"]
[null,null,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,null,null,"'0.625","'3:00 PM"]
[null,null,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,null,null,"'0.667","'4:00 PM"]
[null,null,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,null,null,"'0.708","'5:00 PM"]
[null,null,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,null,null,"0.75","'6:00 PM"]
[null,null,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,null,null,"'0.792","'7:00 PM"]
[null,null,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,null,null,"'0.833","'8:00 PM"]
[null,null,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,null,null,"'0.875","'9:00 PM"]
[null,null,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,null,null,"'0.917","'10:00 PM"]
[null,null,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,null,null,"'0.958","'11:00 PM"]
[null,null,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,null,null,"0.0","'12:00 AM"]
[null,null,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,null,null,"0.042","'1:00 AM"]
[null,null,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,null,null,8.3000000000000004E-2,"'2:00 AM"]
[null,null,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,null,null,0.125,"'3:00 AM"]
[null,null,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,null,null,0.16700000000000001,"'4:00 AM"]
[null,null,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,null,null,0.20799999999999999,"'5:00 AM"]
[null,null,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,null,null,0.25,"'6:00 AM"]
[null,null,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,null,null,0.29199999999999998,"'7:00 AM"]
[null,null,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,null,null,0.33300000000000002,"'8:00 AM"]
[null,null,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,null,null,0.375,"'9:00 AM"]
[null,null,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,null,null,0.41699999999999998,"'10:00 AM"]
[null,null,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,null,null,0.45800000000000002,"'11:00 AM"]
[null,null,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,null,null,0.5,"'12:00 PM"]
[null,null,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,null,null,0.54200000000000004,"'1:00 PM"]
[null,null,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,null,null,0.58299999999999996,"'2:00 PM"]
[null,null,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,null,null,0.625,"'3:00 PM"]
[null,null,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,null,null,0.66700000000000004,"'4:00 PM"]
[null,null,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,null,null,0.70799999999999996,"'5:00 PM"]
[null,null,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,null,null,0.75,"'6:00 PM"]
[null,null,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,null,null,0.79200000000000004,"'7:00 PM"]
[null,null,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,null,null,0.83299999999999996,"'8:00 PM"]
[null,null,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,null,null,0.875,"'9:00 PM"]
[null,null,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,null,null,0.91700000000000004,"'10:00 PM"]
[null,null,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,null,null,0.95799999999999996,"'11:00 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97899999999999998,"'11:30 PM"]

{"sheet":"Updates","index":4,"n_rows":58,"n_cols":3,"rows_kept":58,"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-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-05-10","Zip code validation update","Updated Zip Code validation to look for Alpha Chars in the field, error condition if found"]
["2018-05-10","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-10 095530U"]
["2018-05-11","Cosmetic, verbiage and spelling updates","Cosmetic, verbiage and spelling updates"]
["2018-05-11","Updated Hover-over to <Validate and Submit>","Added Hover-over text to <Validate and Submit>; removed comment"]
["2018-05-11","Updated Hover-over to <Save>","Added Hover-over text to <Save>; removed comment"]
["2018-05-11","Updated validation entry text: Collect RSVP","Updated validation entry text: Collect RSVP"]
["2018-05-11","Updated validation entry text: UHC Advertising","Updated validation entry text: UHC Advertising"]
["2018-05-11","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-111 114100V"]
["2018-05-14","Directions Tab update","Directions Tab update"]
["2018-05-14","Validation update: Venue Address","Venue Address has cell entry and vba logic to address chars >40 "]
["2018-05-14","Validation update: Venue Phone","Venue Address has cell entry and vba logic to address numeric entry =10 chars"]
["2018-05-14","Validation update: Seating Capacity","Updated error alert to 'must be a number between 1 and 999!'"]
["2018-05-14","Validation update: Collect RSVP","Collect RSVP values can be values: Yes, YES, yes, No, No, no"]
["2018-05-14","Validation update: UHC Advertising","UHC Advertising  entry value can be: Yes, YES, yes, No, No, no"]
["2018-05-14","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-14 092630V"]
["2018-05-14","Cell Validation update: Event Day","Event Date error message updated  from '…15 days…' to '...7 days…'"]
["2018-05-14","Updated Field header row","Updated Field Header row for with and line wrap"]
["2018-05-14","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-14 142745V"]
["2018-05-14","Validation update: Seating Capacity","Updated error alert to 'must be a number between 3 and 999!'"]
["2018-05-14","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-14 160000V"]
["2018-05-15","Updated Validation List for Yes,No","Updated Validation List for Yes,No"]
["2018-05-15","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-15 145030V"]
["2018-09-21","Removed Member Events"]
["2018-05-28","Removed Educational Events"]

{"sheet":"Test data","index":5,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Test#","Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","End Time","Event Category","Language ","Presenting Product","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #","Seating Capacity","Venue Type","Venue Phone","Collect RSVP","UHC Advertising"]
[1,"azdfhzdfhzdfh","2562456 sgfhsfgh","55379","2018-04-29","8:30 AM","2:30 PM","Sales Event (Formal): Sales Meeting","Arabic","Chronic","sfgsgfhsf","245672672676","xfgfgsfjsfgj","897808606",30,"Financial/Legal Services",1234567890,"maybe","SoSo"]
[2,"Jamestown Place","1533 Pike Lane SE….","24014",20180429,"1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5404271286]
[3,"Jamestown Place","2034 Indian Village Lane SE","24013","2018-05-21","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5409839275,"Kiosk","Active - Non Public","MA Dual"]
[4,"Jamestown Place","123 Main St ","24013","2018-05-31","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5409839275]
[5,"Jamestown Place","2562456 sgfhsfgh","55379","2018-04-29","8:30 AM",0.60416666666666663,"Sales Event (Formal): Sales Meeting","Arabic","Chronic","sfgsgfhsf","245672672676","xfgfgsfjsfgj","897808606",30,"Financial/Legal Services",1234567890]
[6,"Jamestown Place","1533 Pike Lane SE….","24014","2018-05-20","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5404271286]
[7,"Jamestown Place","2034 Indian Village Lane SE","24013","2018-05-21","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5409839275]
[8,"Jamestown Place","123 Main St ","24013","2018-05-31","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5409839275]
[9,"Jamestown Place","123 Main St ","24013","2018-05-22","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne","2175686","Leslie Payne","2175686",20,"Recreational/Community Center",5409839275]
[10,"Jamestown Place","123 ….Main St ",24013,"2018-05-23","4:16666666666667E-02 AM","2:99 PM","Sales Event (Informal): Resource Center","hello","Dual","Leslie Payne",2175686,"Leslie Payne",2175686,20,"Recreational/Community Center",5409839275]
[11,"Jamestown Place","123 Main St. S., Suite 100",24013,"2018-05-24",4.1666666666666664E-2,"2:99 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne",2175686,"Leslie Payne",2175686,20,"Recreational/Community Center",5409839275]
[12,"Jamestown Place","123 Main St ",2413,"2018-05-25",4.1666666666666664E-2,"2:99 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne",2175686,"Leslie Payne",2175686,20,"Recreational/Community Center","540983927L"]
[13,"Jamestown Place","123 Main St ",24013,"2018-05-26",4.1666666666666664E-2,"2:99 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne",2175686,"Leslie Payne",2175686,30,"Recreational/Community Center",5409839275]
[14,"   Test   Venue Name > 40 Chars     ABCDEFGHIJKLMNOPQRSTUVWXYZ","124 Main St ",24014,"2018-05-27","1:30 PM","2:30 PM","Sales Event (Informal): Resource Center","English","Dual","Leslie Payne",2175687,"Leslie Payne",2175687,30,"Recreational/Community Center",5409839276,"blank","blank"]
[15,"Test Venue Street Address","   Test  Venue Name >40     Chars     abcdefghijklmnopqrstuvwxyz","55379","2018-04-29","8:30 AM","1:30 PM","Sales Event (Formal): Sales Meeting","Arabic","Chronic","sfgsgfhsf","245672672676","xfgfgsfjsfgj","897808606",30,"Financial/Legal Services",1234567890]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes","yes"]

{"sheet":"Sheet1","index":6,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Date","Update","Description"]
["2018-05-15","Updated Validation List for Yes,No","Updated Validation List for Yes,No"]
["2018-05-15","New File Name version","Latest File Name version: Event NEW Request Form update 2018-05-15 145030V"]

{"sheet":"Sheet2","index":7,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["x","CHANGE Event Fields","Width","Letter",null,"x","Event Fields","Width"]
[1,"Count",5,"A",null,1,"Count",5,5]
[2,"Event ID",15,"B",null,2,"Venue Name",25,25]
[3,"Venue Name",25,"C",null,3,"Venue Street Address",25,25]
[4,"Venue Street Address",25,"D",null,4,"Venue Zip",15,10]
[5,"Venue Zip",10,"E",null,5,"Event Date",22,22]
[6,"Event Date",22,"F",null,6,"Start Time",22,14]
[7,"Start Time",14,"G",null,7,"End Time",22,15]
[8,"End Time",15,"H",null,8,"Event Category",32,32]
[9,"Event Category",32,"I",null,9,"Language",20,15]
[10,"Language",15,"J",null,10,"Presenting Product",20,15]
[11,"Presenting Product",15,"K",null,11,"Owning Agent Name",25,24]
[12,"Owning Agent Name",24,"L",null,12,"Owning Agent Writing #",25,15]
[13,"Owning Agent Writing #",15,"M",null,13,"Presenting Agent Name",25,25]
[14,"Presenting Agent Name",25,"N",null,14,"Presenting Agent Writing #",25,15]
[15,"Presenting Agent Writing #",15,"O",null,15,"Seating Capacity",15,9]
[16,"Seating Capacity",9,"P",null,16,"Venue Type",25,25]
[17,"Collect RSVP",8,"Q",null,17,"Venue Phone",15,15]
[18,"UHC Advertising",10,"R",null,18,"Collect RSVP",15,8]
[null,null,null,null,null,19,"UHC Advertising",15,10]