Where time goes: Track your time flow
  • Contents
  • Foreword
  • Chapter 1: Before we begin
    • My Time Log, my first teacher
    • Who can keep time records for 56 years
    • Three benefits of keeping track of time
    • What do you hope to gain from the time record?
    • What exactly is time recording?
    • Does it hurt when you waste your time?
    • Costs and disadvantages of time recording
    • Start quickly with pen and paper
    • The difference between time electronic ledger and manual ledger
    • I advise you for the last time before you start recording.
  • Chapter 2: software operation
    • An article makes it clear that TimeTrack
    • TimeTrack, use it first
    • Five core functions of TimeTrack
    • Three data views included with TimeTrack
    • Maintain only up to 30 activity classifications
    • 5 common ways to categorize time
    • How to time multiple activities simultaneously
    • Take 1 month to polish your categories and definitions
    • Tips for color, naming and layout of categories
    • Use these 2 automatic recording software to assist in recording
  • Chapter 3: Advanced skills
    • System function - time calibration, automatic correction of associated data
    • System function - location, with scene markers
    • System function - archive, put away the unused categories
    • System function - tomato clock, focus on goal achievement
    • System function - countdown to prevent time wastage
    • Remote operation - how to control the mobile phone operating software with a computer
  • Chapter 4: Data analysis
    • TimeTrack data export and mapping
    • What to do with weekly exported data reports
    • What to do with monthly exported data reports
    • Automated data processing, 30 seconds to completion
    • It's a time record and an important diary.
    • Is data security and privacy guaranteed?
    • Data analysis methodology to make time work for you
    • You can look at the data from these 6 angles
    • No clue,That's because you're not asking the right questions.
  • Chapter 5: Illustrative examples
    • Example 1: How is my sleep?
    • Example 2: Did I do the right thing after changing jobs?
    • Example 3: Should I buy this dishwasher?
    • Example 4: How effective is my writing?
    • Example 5: The cost of recording
    • Example 6: A future home where the water is big enough for the bath
    • Example 7: Save money with piracy? Not necessarily.
    • Example 8: Pricing based on hourly rates
    • Example 9: The flow of time brings out the clever
    • Example 10: What have I been doing in the New Year?
    • Example 11: Give yourself a point.
  • Chapter 6: More content
    • Frequently Asked Questions about aTimeLogger and TimeTrack
    • Let more Chinese enthusiasts start time keeping
    • Excellent articles related to timekeeping
    • Other time recording software
    • Everything is connected and the future of time recording is in our minds
    • 4 New Thoughts on Time
    • Bringing the timekeeping method to life
  • Postscript
  • Software payment
由 GitBook 提供支持
在本页

这有帮助吗?

  1. Chapter 4: Data analysis

Automated data processing, 30 seconds to completion

上一页What to do with monthly exported data reports下一页It's a time record and an important diary.

最后更新于5年前

这有帮助吗?

The monthly breakdown is the starting point for our data analysis, so this source data table we need to ensure that.

Data as error-free and accurate as possible

Easy to use, templated

The reason we correct the categorization and notes once a month is to maximize the accuracy of the data.

Secondly, I set up the "Week" and "Month" super tables, which will automatically update the pivot table just by pasting a data refresh. Then I set the "S*" identifier that needs to be parsed each month to VBA (batch replacement + disaggregation + deletion of the first entry at the beginning of the month) to speed up data processing.

These steps are all packaged in an Excel sheet with the macros turned on, guaranteeing no more than 5 minutes from adding new data to completing the visualization, preparing the data environment for subsequent analysis.

Finally, I set up a monthly public schedule (2019), refreshed the data and copied and pasted it into an image to send to my circle of friends to sync my time goal progress.

In other words, the complete event log data table contains "Week" data, "Month" data, "Week Insight" data, "Month Insight" data, as well as "Event Definition Table" and "Layout" memos, a data processing "VBA" table, and finally the "2019" goal progress table presented monthly.

It's not that we can make such data with a table, it's also necessary to bury the markup in TimeTrack.

For example, the "S*" tag and the "#, @," symbols in the comments column should be added to the activity when it is created.

With this specification source data table, we can process time data more quickly and easily.

The source data template was significantly updated in 2019, highlighting key indicators and improving visualization.

The illustration is as follows:

With this report, from exporting your data in TimeTrack to importing it into Excel to start analyzing it, it takes 2 minutes.

This set of templates took almost half a year from having ideas in prototype to actually implementing them on Excel.

From the template function processing to the VBA, layout to the color matching, to the red and green lights up and down arrow markers, and even row height column width, from large to small I can take into account the details are all added in one Excel!

monthly report
Motion Picture Presentation