Find the most productive time of the day tracking the energy levels

C.I.G. is partly supported by its readers. If you’re buying our connections, we can make a partnership commission …

When you do your best work?

If you’re a type that likes it.

Or maybe you’re a night owl, you find yourself in a fire at 1 in the morning, break into the project while everyone else is asleep …

And vice versa, when yours.

You may be able to lean on some basic answers to these questions from your memory. But what if you know.Armed with this kind of knowledge, you can start making intelligent changes in your schedule. You could plan your work.

Depending on what level of control you have over your obligations, you could start to shift meetings, hands, and other work in other periods of time, thus ensuring your work.

If you are a student, you can use this information to build a better time schedule for.

Knowledge of a typical ebb and stream of your energy levels would clearly be a bone for your productivity-but how to understand it.

I didn’ t want to wear a notebook in my pocket and write my energy levels by hand. And I certainly didn’ t want any system to make me perform manual calculations on my data later …

I wanted a system that was:

In this post I will show you how you can do the same; in fact, I have already taken care of the most difficult part for you …

If you want to start tracking your own energy levels and discover your own biological time, follow …

For this experiment to be easy to run, our goal here is to create a system that allows you to easily allow you to enter data-your energy level at this time-and then automatically process it. To achieve this, we are going to combine three different tools:

Here’s a quick look at the steps we take to install the system. Since I have already done 90% of the work on Google Sheet, this should not take you more than 5-10 minutes to do …

  • Make a copy of my Google Sheet that will process your data.
  • Create a Google Form to track energy levels.
  • Associate a form with a spreadsheet.
  • Make a couple of formula changes.
  • Add a link to your Smartphone home screen.
  • Set up an hour reminder so that you do not forget to enter data.
  • Go ahead.

    Step 1: Copy My Google Sheet.

    To get the average hourly energy from the data you enter into the Google Form, we need to associate this form with a spreadsheet that contains formulas for data processing ..

    Now you can build this spreadsheet yourself-but it would be easiest to just copy the one I built. So.

    Then click the “Duplicate File” button. Go ahead and call your copy that you want “Energy Tracker” or “Mr. Taco McSparkles Visits the Moon God”. It doesn’t matter …

    Your copy of the spreadsheet should now open on a new browser tab ..

  • Click File and select Spreadsheet Options.
  • Change the time zone …
  • Click Save settings ..
  • Now, if you look at the bottom of the screen, you’ll see that you have two different sheets:

    In my original version of Sheets, the answers (Sample) is a worksheet that records the answers from my Google Form. All the data is bogus, I let a bunch of Twitter people enter it. But it shows how the “Sheet” project works to see how to click on the “Results” (example) ..

    Here you will see that each cell in column A records the clock from the time stamp in the corresponding cell in the responses (example). Similarly, column B will have a numeric value for the energy level from the cell with your sister ..

    At this point, you can ask:

    ” Why can’t we just set up other cells in the responses (Sample) to see the cells that get data from the form? Why do we need another leaf? “.

    It was the first way I tried to build, and theoretically it would work. However, when you associate the Google Form with the Sheets project, the answers are

    As a result, we cannot simply do something simple to set the contents of cell C1 = HOUR (A1). The original A1 is never filled in-Google Forms creates a new A1 ..

    Fortunately, we can use a different set of sheets and use the ARRAYFORMULA command to watch the original sheet and port on all data …

    If you look at cells A2 and B2 of the responses (Sample), you will see how we use this command:.

    In order to run it quickly, VALUE converts the contents of a cell into a numeric data type (so we can perform math functions), HOUR only lasts an hour from the time stamp, and the LEFT takes the specified number of characters from the cell, which it looks from the beginning-you can see at the end of this formula that we only want 1 ..

    See why copying a sheet is a little easier than making it yourself? Yeah, yeah, yeah.In either case, click the arrow next to the results (Sample) and then click Duplicate. Rename your duplicate sheet

    We’ll be back here in a moment, but first we need to create a Google Form …

    Step 2: Create a Google Form.

    Setting up the Google Form will allow you to easily track the current level of energy by answering it.

  • Enter the name of the form, for example, “Energy Tracker”.
  • Add the question to the form: “What is your current energy level?”
  • Add the answers to the question. Enter as much as you want-I chose a scale of 1-4 to estimate energy level …
  • Remember this formula for B2 in our results sheet? The LEFT command captures the first character and the other to get the average numeric value. So your answers must start with a number, or it doesn’t work …

  • Then, specify the desired question.
  • Click the Responses tab and click the green list icon:.
  • Select an existing spreadsheet.
  • Select your copy of the electronic energy tracking table.
  • At this point, your spreadsheet should open again. Time to make a few minor modifications …

    Step 3: Change the spreadsheet.

    When you look at the “Šešec” project, you will notice that there is a new leaf in the bottom part. It’s probably gonna be called.Now get your head back to your outcome. Edit cells A2 and B2 so that they refer to this new response sheet, not the responses (example). This is what you should get:.

  • Contents A2: = ARRAYFORMULA (VALUE (HOUR (‘.
  • )Contents of B2: = ARRAYFORMULA (VALUE (LEFT (‘.
  • Luckily, it’s the only thing you need to do! You will notice that cells are referenced by

    In Excel and Google Sheets, the definition of such a range (without becoming a part of the second part) means that the range is not indefinite. He’ll be watching A2 and B2 to infinity, so you can type as many results as you like …

    Step 4: Add the form to your telephone home screen.

    We are at home stretch-all we have left to do now is set your phone so that you can easily enter data every hour ..

    Back to where you are editing the Google Form, and click the Send Up button in the upper right corner. Select the link tab, and then find a way to open the link on the Smartphone. You could:

  • He’s starting to be his own.
  • Select the Short Link option and simply type it in the phone browser.
  • Use syncing app like.
  • In any case, you just want to open it in a browser. Now add the form to your phone’s home screen so you can open it when you need it.

    Step 5: Configure Hourly Reminders.

    If you try to keep track of your energy every hour, it’s probably a good setup.

    As a user of the iPhone, I was a little shocked to discover that there is no app that would hit all the criteria I wanted:.

    In fact, the only application I could find would make the first two worth of $5-too cool for this experiment …

    As a result, I decided to go with the following applications as my recommendations here:

    As far as I know, this is not the most ideal solution: I would very much like the system that actually made me to take action on the notice. Or even better, the one who sent me a text message with a reference to my form every hour ..

    However, the date and time trigger “hour” will unfortunately not allow you to customize the user-time window. It just works every hour. The only way to work around this is to use the “Every day at X” trigger, and create a separate recipe for each hour …

    I wanted this system to be somewhat elegant, so I decided not to. Technically, you could do the same with your default alarm phone …

    ME? I’m just training to answer “Everybody beep” …

    Once your system is created, all you have to do is collect data. For the next 1 to 2 weeks, keep your system under control and enter your energy level carefully every hour for the time you want to monitor ..

    You can keep track of how the graph is changing. After you enter the appropriate amount of data, your schedule must accurately reflect how the energy levels typically move during the day ..

    After you do this, you’ll have a good deal of understanding when there’s a Biology time. Use this knowledge to begin tweeting your schedule ..

    For better performance,

    You want to make better grades?You found this article useful?

    I’ll join us, and I’ll send you one too.

    The best applications are 25 + in 2019.

    These applications will help you monitor the todos, manage your e-mail, back up your files, and stay in your organization, regardless of whether you are working at

    Watch and Learn: The 100 + Best Educational YouTube Channels in 2019.You can find out about anything on YouTube these days. There are 100 best channels for studying mathematics, science, learning, self-improvement, and more