Step 1: In Excel (save as a .csv file), list every week when there will be lessons, culling general conference and stake conference (we never know whether ward conference will have normal lessons or will be supplanted until the week of).
Step 2: Copy the lesson tables from each manual into an excel spreadsheet (delete pictures F5>Special>Objects then delete)
Step 3: Extract links for the description
Code: Select all
Sub Extract_link_text_to_the_neighboring_cell()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
HL.Range.Hyperlinks.Delete
Next
End Sub
Step 5: Line up lessons with weeks
Step 6: Add columns to work with conversion tool as below
(remember save as .csv)
Step 7: try an online tool or use the google calendar two-step to test and generate an iCal/ICS file
[Subject],[Start Date],[Start Time],[End Date],[End Time],[All Day (boolean)],[Description]
The gurus may add that it is more flexible, and you can play with it, but this works for me:
-watch out for special characters (like curly quotes)
-All day is specified True or False
-MM/DD/YYYY works
-AM/PM times work
I have not succeeded in specifying location in way that is compatible with the calendar
(a) As of November 2014, go to http://manas.tungare.name/software/csv-to-ical/ download his csv and use his converter if you feel that this is compatible with confidentiality requirements and passing information through the site of this helpful but unknown fellow.
(b) depending on how you feel about google, you can also use a google account (not google applications) to import the .csv to a new calendar then export the file (use private url). (I use this so I have a nice test run because it is easy to start over if I've done something horribly wrong.)
Step 8: import into LDS.org Calendar