Stage II of munging

[achafetz]

for each Partner's Google Sheet:

• read in each sheet
• reshape
• adjust date
• add variable name
• append to other indicator sheets

then need to append each file to other partner files

[jaliasd]

@achafetz Each partners' sheet is structured slightly differently. I have a macro that'll pull the sheet names from any individual sheet, but would rather that it pull from all the sheets to one place.

Sub GetSheets()
    Dim w As Worksheet
    Dim iRow As Integer
    Dim iCol As Integer

    iRow = Selection.Row
    iCol = Selection.Column
    For Each w In Worksheets
        Cells(iRow, iCol) = w.Name
        iRow = iRow + 1
    Next w
End Sub

[jaliasd]

Another issue: The tab names are not consistant across partners. This screen shot is a pivot off of the weekend_special_mapping.xlsx

Compared to this list of indicators reported on in the "Collated weekend reports - DCM -merged.xlsx" sent by Mavis on 4/19.

So how do we get to that list from the worksheets available? Do we try and reverse engineer or ask the team?

[achafetz]

Good inspection! (You should save the VBA code and put in in a VBA folder. Copy the VBA to sublime/atom and save it as a a .bas file.)

We can do this on the backend with our scripts BUT since we're dealing with Google Sheets, this should be really easy to fix. It would be ideal if every template has the exact same structure and I don't see any reason why they shouldn't be.

We should discuss template uniformity with Mavis et al this week.

[achafetz]

closing but @jaliasd issues relate to #12