{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Data","New Events","Change or Cancel Events","Sh1_DateSpecs"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":136,"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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Event Request Form","Submission:"]
["Complete the tab titled \"New Events\" to report your new events to Memorial Hermann Health Plan.\nComplete the tab titled \"Change or Cancel Events\" to report any changes to or cancellations of events reported previously to Memorial Hermann. ","After you have enterd your event information, this form may be submitted directly to Memorial Hermann's sales email box MASales@memorialhermann.org \nYou may want to save this form for your records \nPlease submit new events at least 10 calendar days before the event date. This allows time to resolve any issues while ensuring  timely reporting to the Centers for Medicare & Medicaid Services (CMS).\nSubmit changes and cancellations at least 5 business days before the event date. Again to ensure timely reporting to CMS. "]
["Using this Form"]
["1. If Excel prompts, select \"Enable Content\" & \"Enable Editing\" "]
["2. Select the New Events tab in this document to report new events to Memorial Hermann Health Plan Medicare Sales email box (MASales@memorialhermann.org)"]
["3. Select the Change or Cancel tab in this document to report updates to existing events to Memorial Hermann"]
["4. Fill all fields labeled \"Required\""]
["5. Review all other instructions on this page."]
[" "]
[]
["Helpful Tips"]

{"sheet":"Data","index":1,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Time Options",null,"Event Categories",null,"Product Types:",null,"Language",null,"Venue Type",null,"Cancellation Reason"]
[null,"7:00 AM",null,"Sales Event (Informal): Resource Center",null,"MA",null,"English",null,"Assisted Living",null,"Venue/Date/Time Entry Error"]
[null,"7:30 AM",null,"Sales Event (Informal): Walk-In Location",null,"Dual",null,"Spanish",null,"Doctor's Office",null,"Venue Not Available"]
[null,"8:00 AM",null,"Sales Event (Formal): Sales Meeting",null,"Chronic",null,"Arabic",null,"Financial/Legal Services",null,"Inclement Weather"]
[null,"8:30 AM",null,"Sales Event (Formal): Online",null,"Med Supp",null,"Cantonese",null,"Food Bank",null,"Agent Ill"]
[null,"9:00 AM",null,"Educational Event: General Educational",null,"Med Supp/PDP",null,"Chinese",null,"Health Fair/State Fair/County Fair",null,"At Agent Request"]
[null,"9:30 AM",null,"Educational Event: Medicare Made Clear",null,"ISNP",null,"Filipino",null,"Health Plan/Insurance Business Office or Facility"]
[null,"10:00 AM",null,"Member Event: In Person",null,"MA (SCO)",null,"French",null,"Hospital Clinic/Conference Room/Business Office",null,"Change"]
[null,"10:30 AM",null,"Member Event: Online",null,"Stand-alone PDP",null,"German",null,"Hotel/Motel",null,"Cancel"]
[null,"11:00 AM",null,"Member Event: Telephonic",null,"Erickson",null,"Greek",null,"Internet"]
[null,"11:30 AM",null,null,null,null,null,"Italian",null,"Library"]
[null,"12:00 PM",null,null,null,null,null,"Japanese",null,"Mall Kiosk"]
[null,"12:30 PM",null,null,null,null,null,"Korean",null,"Nursing Home/Skilled Nursing Facility/Rehab Facility"]
[null,"1:00 PM",null,null,null,null,null,"Mandarin",null,"Recreational Vehicle/RV Park"]
[null,"1:30 PM",null,null,null,null,null,"Norwegian",null,"Recreational/Community Center"]
[null,"2:00 PM",null,null,null,null,null,"Other",null,"Religious Facility (Church/Temple/Mosque)"]
[null,"2:30 PM",null,null,null,null,null,"Polish",null,"Restaurant/Coffee Shop"]
[null,"3:00 PM",null,null,null,null,null,"Portuguese Brazilian",null,"Retail Store/Store Front/Grocery Store"]
[null,"3:30 PM",null,null,null,null,null,"Russian",null,"School"]
[null,"4:00 PM",null,null,null,null,null,"Swedish",null,"Senior Apartments/Senior Center"]
[null,"4:30 PM",null,null,null,null,null,"Tagalog",null,"UHC Store"]
[null,"5:00 PM",null,null,null,null,null,"Vietnamese",null,"Other"]
[null,"5:30 PM"]
[null,"6:00 PM"]
[null,"6:30 PM"]
[null,"7:00 PM"]
[null,"7:30 PM"]
[null,"8:00 PM"]
[null,"8:30 PM"]
[null,"9:00 PM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,null,null,1]
[null,null,null,null,null,"Connector Group Retiree Meeting"]
[null,"Educational Events",null,null,null,"Formal"]
[null,"Health Fair/Expo",null,null,null,"Informal"]
[null,"Kiosk"]
[null,"Member Meeting"]
[null,"Resource Center",null,null,null,"Connector Group Retiree Meeting"]
[null,"Sales Meeting",null,null,null,"Active - Public"]
[null,"UHC Store",null,null,null,"Active - Non Public"]
[null,"UHC/Agency Office"]

{"sheet":"New Events","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,3],[3,0,4,0]]}
[null,null,null,null,null,"New Entries:"]
[null,null,"New Event Request Form",null,{"$f":"Alert2","v":" "}]
[]
["Count","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)"]
[null,"Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","End Time","Event Category","Presenting Product","Presenting Agent Name","Presenting Agent Writing #","Seating Capacity","Venue Type","Venue Phone"]
[1,null," "," "," "," "," "," "," "," "," "," "," "," "]
[2]
[3]
[4]
[6]
[7]
[8]
[9]
[10]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Change or Cancel Events","index":3,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,3],[3,0,4,0]]}
[null,null,null,null,null,null,"Changes/Cancels Entries:"]
[null,null,"Change/Cancel Event Request Form",null,{"$f":"Alert2","v":" "}]
[]
["Count","(Required)","(Required for Cancel)","(Optional)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required if changing)","(Required if changing)"]
[null,"Change or Cancel?","Cancellation Reason","Meeting ID","Venue Name","Venue Street Address","Venue Zip","Event Date","Start Time","Event Category","Presenting Agent Name","Presenting Agent Writing #"]
[1]
[2]
[3]
[4]
[6]
[7]
[8]
[9]
[10]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Sh1_DateSpecs","index":4,"n_rows":56,"n_cols":21,"rows_kept":56,"cut":false,"hidden":true,"merged":[[48,19,48,20],[53,18,53,19]]}
["x","xxxxxxxxxxxxx","xxxxxxxxxx","x","xxxxx","xxxxxxxxxx","xxxxxxxxxxxxxxx","xxxxxxx","xxxxxxx","xxxxxxx","xxxxxxxxxx","x","xxxxxxxxxxxxx","xxxxxx"]
[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 3/28/2023 and 9/30/2023"},null,null,null,null,null,null,null,null,null,null,null,"ERA Form Version:","ERA Form version 3.0E 2017/04/14 10:24 PM"]
[]
[null,"TestToday:",{"$f":"NOW()","v":"2023-03-13T15:19:12.570"},null,"Month","Real Month","LOVs Month","Filter1","Filter2","Filter3","Dates",null,"Date Start/End","Value",null,null,"BasePipeName:","EventRequestExport"]
[null,"Days Buffer:",15,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":true},{"$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,"TestTodayPlus:",{"$f":"TestDay+TestDaysBuffer","v":"2023-03-28T15:19:12.570"},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"},true,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 2017-03-30-170801.csv"]
[null,null,{"$f":"EOMONTH(TestDayPlus,-1)+1","v":"2023-03-01"},null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E7,E7)-1,E7,1)","v":"2023-03-01"},"March-2023",true,true,true,"2023-03-01",null,"E_DeltaMin",-30]
[null,"MonthsLogic:",{"$f":"1*(MONTH(TestDay)>6)","v":0},null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E8,E8)-1,E8,1)","v":"2023-04-01"},"April-2023",true,true,true,"2023-04-01",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"},"ßUse Drop-Down to select eMail recipient"]
[null,"ArrayLoad:",{"$f":"COUNTIF(J4:J25,TRUE)","v":7},null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E9,E9)-1,E9,1)","v":"2023-05-01"},"May-2023",true,true,true,"2023-05-01",null,null,null,null,null,"eMail Subject:","ERA Event Pipe Delimited File for Processing"]
[null,null,null,null,6,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E10,E10)-1,E10,1)","v":"2023-06-01"},"June-2023",true,true,true,"2023-06-01",null,null,null,null,null,"eMail Body1:","Attention: Sales Team,"]
[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 Meeting Event Pipe Delimited file: "]
[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":"EventRequestExport amora20 2017-03-30-170801.csv"}]
[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,"MonthStartMax:",{"$f":"MAX(MonthsValid)","v":"2023-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":false},true,false,"00:00:00",null,null,null,null,null,"eMail Body5:",{"$f":"ERA_FormVersion","v":"ERA Form version 3.0E 2017/04/14 10:24 PM"}]
[null,"MonthStartMaxEnd:",{"$f":"EOMONTH(MonthStartMax,0)","v":"2023-09-30"},null,11,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E15,E15)-1,E15,1)","v":"2023-11-01"},"November-2023",false,true,false,"00:00:00",null,null,null,null,null,"eMail Body6:","Thanks"]
[null,null,null,null,12,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E16,E16)-1,E16,1)","v":"2023-12-01"},"December-2023",false,true,false,"00:00:00"]
[null,null,null,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E17,E17)-1,E17,1)","v":"2024-01-01"},"January-2024",false,true,false,"00:00:00"]
[null,null,null,null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E18,E18)-1,E18,1)","v":"2024-02-01"},"February-2024",false,true,false,"00:00:00",null,null,null,null,null,"PC Name:","LH7U05CG525120K"]
[null,null,null,null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E19,E19)-1,E19,1)","v":"2024-03-01"},"March-2024",false,true,false,"00:00:00",null,null,null,null,null,"UserID:","amora20"]
[null,null,null,null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E20,E20)-1,E20,1)","v":"2024-04-01"},"April-2024",false,true,false,"00:00:00"]
[null,null,null,null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E21,E21)-1,E21,1)","v":"2024-05-01"},"May-2024",false,true,false,"00:00:00",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",false,true,false,"00:00:00",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",false,true,false,"00:00:00",null,null,null,null,null,null,"alfonso.morales@optum.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",false,true,false,"00:00:00",null,null,null,null,null,null,"shannon.kennedy@optum.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",false,true,false,"00:00:00",null,null,null,null,null,null,"barbara_j_kasper@uhc.com",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Send:",true,"ßTRUE=Send, FALSE=Display, don't auto send"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ExcelSaveAsStatus:",true]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail TO:",{"$f":"INDEX(eMailMatrix,2,IF(MID(eMailOptionProdDev,1,3)=\"Pro\",1,2))","v":"phd@uhc.com"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Subject:","ERA Change/Cancel 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 Meeting Change/Cancel Event file: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change eMail Body3:",{"$f":"eMailFile","v":"EventRequestExport amora20 2017-03-30-170801.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 3.0E 2017/04/14 10:24 PM"}]
[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,"alfonso.morales@optum.com",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"shannon.kennedy@optum.com",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"barbara_j_kasper@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",{"$f":"INDEX(LOVsForEmailSend,1)","v":"sales_events@uhc.com"},{"$f":"INDEX(LOVsForEmailSend,1)","v":"sales_events@uhc.com"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change/Cancel","phd@uhc.com","barbara_j_kasper@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?","Yes; On-Open: Set C51 to Production",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":" "}]