For the schedule data in particular, the HSDS schedule format has a "Weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (can be separated by commas). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".
Use the variable mapping information provided under the "HSDS Mapping" tab of this sheet (https://docs.google.com/spreadsheets/d/1OyxTJCF4-sxivjsWHzTOpuYidAetQSjWzVCEDU45GZc/edit#gid=1127300923) to transform the data to HSDS format.
For the schedule data in particular, the HSDS schedule format has a "Weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (can be separated by commas). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".