Thank so much for this response. It was exactly what I was looking for. Also, thank you for the details of the process.
Cheers. On Sunday, February 28, 2021 at 12:30:54 PM UTC-5 [email protected] wrote: > Eh... Okay, so when I made this back then, I monitored my exports over > the course of a year or two, to make sure that the format never changed > (e.g. that cell A12 always the top of the table and the columns are always > in exactly the same locations.) That is a must for this type of re-usable > template. I just checked an export from today though, and some columns > have indeed changed. Cell A12 is still the top left, but "Text Tag" was > inserted as column 7. That pushes all the subsequent columns over one. > Sorry. I've run into this problem with other database export templates I > have. It is possible to adjust the spreadsheet, but it is probably easier > to just build a new one from scratch... :- / > > also note that "Places" is now "Contexts." > > 2017 Is completed 2021 Is completed > 2017 Task name 2021 Task name > 2017 Start time 2021 Start time > 2017 Due time 2021 Due time > 2017 Recurrence 2021 Recurrence > 2017 Contexts 2021 Places > 2017 Text tag 2021 Flag > 2017 Flag 2021 Starred > 2017 Starred 2021 Notes > 2017 Notes 2021 Outlined task name > 2017 Outlined task name 2021 Full path > 2017 Full path 2021 Created > 2017 Created 2021 Modified > 2017 Modified 2021 Completed > 2017 Completed 2021 Importance > 2017 Importance 2021 Urgency > 2017 Urgency 2021 Goal > 2017 Goal 2021 Project (immediate) > 2017 Project (immediate) 2021 Project (top level) > 2017 Project (top level) 2021 Is project > 2017 Is project 2021 Project Status > 2017 Project Status 2021 Project Completion % > 2017 Project Completion % 2021 Task Effort > 2017 Task Effort 2021 Min time required > 2017 Min time required 2021 Max time required > 2017 Max time required 2021 Hide in To-Do > 2017 Hide in To-Do 2021 Complete subtasks in order > 2017 Complete subtasks in order 2021 Has subtasks > 2017 Has subtasks 2021 Has uncompleted subtasks > 2017 Has uncompleted subtasks 2021 Priority By Importance > 2017 Priority By Importance 2021 Priority By Urgency > 2017 Priority By Urgency 2021 Priority By Both > 2017 Priority By Both > > > On Sunday, February 28, 2021 at 9:08:25 AM UTC-8 Steve Kunkel wrote: > >> 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/485cf481-86cf-4c46-9b4b-9ecf31ccce3fn%40googlegroups.com.
