{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Data","New Events","Change or Cancel Events","Sh1_DateSpecs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":52,"comments":4,"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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Event Request Form","Submission:"]
["Complete the tab titled \"New Events\" to report your new events to UnitedHealthcare (UHC).\nComplete the tab titled \"Change or Cancel Events\" to report any changes to or cancellations of events reported previously to UHC. ","After you have enterd your event information, this form may be submitted directly to UnitedHeatlhcare's event reporting application by double-clicking the Validate and Submit button on the New Events tab and/or on the Change or Cancel Events tab. \nOr you may save this form and send it on to the UHC local market for entry. \nPlease submit new events at least 21 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 8 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 UHC"]
["3. Select the Change or Cancel tab in this document to report updates to existing events to UHC"]
["4. Fill all fields labeled \"Required\""]
["5. Review all other instructions on this page."]
["6.Click Validate and Submit on each tab updated to send the form directly to UHC for processing OR save and send to the local market for entry"]
["Frequently Asked Questions (FAQ)"]

{"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":17,"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":" "},"<Validate and Submit>","<Save>"]
[]
["Count","(Required)","(Required)","(Required)","(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","Language ","Presenting Product","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #","Seating Capacity","Venue Type","Venue Phone"]
[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":"Change or Cancel Events","index":3,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,3],[3,0,4,0],[1,11,1,14]]}
[null,null,null,null,null,"Changes/Cancels Entries:"]
[null,null,"Change/Cancel Event Request Form",null,{"$f":"Alert2","v":" "},"<Validate and Submit>","<Save>",null,null,null,null,"Columns L-R: Only need to enter a value if this attribute is changing. Otherwise the field can be left blank."]
[]
["Count","(Required)","(Required for Cancel)","(Optional)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required)","(Required if changing)","(Required if changing)","(Required if changing)","(Required if changing)","(Required if changing)","(Required if changing)","(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","End Time","Language ","Presenting Product","Owning Agent Name","Owning Agent Writing #","Presenting Agent Name","Presenting Agent Writing #","Seating Capacity"]
[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":4,"n_rows":61,"n_cols":21,"rows_kept":61,"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 6/27/2017 and 9/30/2017"},null,null,null,null,null,null,null,null,null,null,null,"ERA Form Version:","ERA Form version 4.4J 2017/05/22 12:45 PM","ßMake Version changes here"]
[]
[null,"TestToday:",{"$f":"NOW()","v":"2017-06-12T15:25:17.090"},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":"2017-01-01"},{"$f":"TEXT(F5,\"MMMM-YYYY\")","v":"January-2017"},{"$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":"2017-06-27T15:25:17.090"},null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E6,E6)-1,E6,1)","v":"2017-02-01"},{"$f":"TEXT(F6,\"MMMM-YYYY\")","v":"February-2017"},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 skenne10 2017-05-22-150026.csv"]
[null,null,{"$f":"EOMONTH(TestDayPlus,-1)+1","v":"2017-06-01"},null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E7,E7)-1,E7,1)","v":"2017-03-01"},"March-2017",true,false,false,"00:00:00",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":"2017-04-01"},"April-2017",true,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"},"ßUse Drop-Down to select eMail recipient"]
[null,"ArrayLoad:",{"$f":"COUNTIF(J4:J25,TRUE)","v":4},null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E9,E9)-1,E9,1)","v":"2017-05-01"},"May-2017",true,false,false,"00:00:00",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":"2017-06-01"},"June-2017",true,true,true,"2017-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":"2017-07-01"},"July-2017",true,true,true,"2017-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":"2017-08-01"},"August-2017",true,true,true,"2017-08-01",null,null,null,null,null,"eMail Body3:",{"$f":"eMailFile","v":"EventRequestExport skenne10 2017-05-22-150026.csv"}]
[null,null,null,null,9,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E13,E13)-1,E13,1)","v":"2017-09-01"},"September-2017",true,true,true,"2017-09-01",null,null,null,null,null,"eMail Body4:",{"$f":"\"User ID: \" &vbaUserID","v":"User ID: skenne10"}]
[null,"MonthStartMax:",{"$f":"MAX(MonthsValid)","v":"2017-09-01"},null,10,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E14,E14)-1,E14,1)","v":"2017-10-01"},"October-2017",{"$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 4.4J 2017/05/22 12:45 PM"}]
[null,"MonthStartMaxEnd:",{"$f":"EOMONTH(MonthStartMax,0)","v":"2017-09-30"},null,11,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E15,E15)-1,E15,1)","v":"2017-11-01"},"November-2017",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":"2017-12-01"},"December-2017",false,true,false,"00:00:00"]
[null,null,null,null,1,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E17,E17)-1,E17,1)","v":"2018-01-01"},"January-2018",false,true,false,"00:00:00"]
[null,null,null,null,2,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E18,E18)-1,E18,1)","v":"2018-02-01"},"February-2018",false,true,false,"00:00:00",null,null,null,null,null,"PC Name:","LH7U0CNU323B9R8"]
[null,null,null,null,3,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E19,E19)-1,E19,1)","v":"2018-03-01"},"March-2018",false,true,false,"00:00:00",null,null,null,null,null,"UserID:","skenne10"]
[null,null,null,null,4,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E20,E20)-1,E20,1)","v":"2018-04-01"},"April-2018",false,true,false,"00:00:00"]
[null,null,null,null,5,{"$f":"DATE(YEAR(TestDay)+COUNTIF(E$4:E21,E21)-1,E21,1)","v":"2018-05-01"},"May-2018",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":"2018-06-01"},"June-2018",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":"2018-07-01"},"July-2018",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":"2018-08-01"},"August-2018",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":"2018-09-01"},"September-2018",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:",{"$f":"IF(eMailOptionProdDev=\"Production\",TRUE,FALSE)","v":true},"ßTRUE if Cell R51=Production"]
[]
[]
[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 skenne10 2017-05-22-150026.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: skenne10"}]
[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 4.4J 2017/05/22 12:45 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"},"kris_raisleger@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","alfonso.morales@optum.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 C51 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,null,null,null,null,"kris_raisleger@uhc.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alfonso.morales@optum.com"]