As I re-read my post, I see more explanation is needed... When I say that I recommend this setup, I don't mean that you should necessarily use a table or a gantt chart. I just mean leave your raw export data as raw data. REFERENCE those cells in other sheets, the use those other sheets for your data analysis. A person might be tempted to convert their export directly into an Excel Table. If you do that though, you'd have to re-build the Table each time you did an export. The setup I have here allows you to have a "re-usable" template.
also note: The sheet "CulledRows" is merely a "helper sheet" that feeds into the gantt chart. It was intended to be hidden. On Sunday, February 28, 2021 at 8:59:11 AM UTC-8 Steve Kunkel wrote: > I haven't really been using this functionality, but to set up a re-usable > template, I'd recommend something like this one I made about 4 years ago. > If it works as I intended, you can export your outline as Excel XML. Then > open my MLOsheet here. Open the tab MLOraw, and do Select-All, Delete. > Now, open your fresh export and do Select All, Copy. Go immediately to > MLOraw, click on cell A1, then paste (Ctrl+v). > > The reason this works (hopefully it did). Is because the filter table > references this raw data. If you click in FilterTable, C3, you'll see > "=MLOraw!A12." MLOraw!A12 is Always where the MLO Excel export puts the > top/left most corner of the table. > > Hopefully that brief explanation made sense. I can expand, if needed. > IMPORTANT: This is a one-way process. You can't use Excel to update your > outline. Also, your tables, graphs, etc can only read, rearrange, > regurgitate the data from the raw sheet. You should never actually change > data this way--unless it's via dumping in a fresh export to the MLOraw > sheet. Update your data in MLO, then occasionally do a bulk export. > > note: I just realized the FilterTable is filtered by column G, "Start > time." You can unfilter, as needed. Also if I recall correctly, the > "Optional Label" for the GanttChartt doesn't work correctly... I got > frustrated with it back in 2017 and never finished it. > > On Saturday, February 27, 2021 at 2:49:55 PM UTC-8 [email protected] > wrote: > >> Does anybody export data for analysis in as spreadsheet and if so what is >> your process. I would love if i was able to visualize my productivity over >> time because bringing gamification to MLO, as in spreadsheet graphs, would >> be huge...for me. >> >> Cheers. >> > -- You received this message because you are subscribed to the Google Groups "MyLifeOrganized" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/b4083834-3d08-48df-8d5f-431fb34e47a0n%40googlegroups.com.
