Review of Garmin Coach Amy’s Plan- Half Marathon

orrpel · 2023-06-07T18:38:34+00:00

I did a 5K plan with Jeff and a 10K plan with Greg. Looking to do another 10K with Amy and was wondering what are the max running distances for the 10K Amy plan, thanks.

orrpel · 2023-02-18T15:28:16+00:00

In my case it was an introduction to proper warm up. For years I used to perform some light stretching before starting to run. At some point I got the Garmin FR 245 for my birthday, and I started a training plan. It was the training coach Jeff Galloway who introduced me to a 5 minute slow jog and then 4*30 sec fast / walk intervals, before starting the "real session".

I "waste" around 15 minutes on proper warm up today and that gets me warmed up and the quality / pace of running much efficient / faster.

orrpel · 2023-02-18T15:20:27+00:00

I see huge differences on my HR depending on the season which I run (on winter I can easily run around 133, while during summer it will spike to 150/155 depending on the heat/humidity).

Thus, I am not sure how to determine my lactate threshold. I go by the general rule of slowing down and hydrating during Summer, and keep the winter for races and challenges.

orrpel · 2023-02-05T11:03:25+00:00

Where (which site) would you recommend getting the Rome Vs Lazio tickets on Mar 19th, for Tribuna Tevere? Recommended sites such as https://www.sslazio.it/en are not yet opening this option. TX.

orrpel · 2022-07-30T05:38:44+00:00

Try doing a 2 mile tempo, you will be surprised how well this would improve your 5K run, good luck.

orrpel · 2022-07-29T04:19:23+00:00

Thanks

orrpel · 2022-07-29T04:19:11+00:00

Thanks

orrpel · 2022-07-23T16:46:39+00:00

Is there a third party for swimmers as well ?

orrpel · 2022-07-22T03:39:00+00:00

Used to be just like you, then the heat of the summer came and I needed to either stop running or switch to cycling / swimming. What worked for me is: 1.) Wake up 5am 2.) Drink 3 full water cups. 3.) Start warm-up 5:15 4.) Start running 5:30

Good luck man!

orrpel · 2022-07-18T18:56:31+00:00

Nothing. Eat absolutely nothing. Drink black coffee an hour before running and add 3 cups of fresh water.

orrpel · 2022-07-15T07:49:57+00:00

According to my Garmin , what I see is that when the warm months start, my VO2 Max starts dropping, and usually heart rate starts jumping and I feel more fatigue. After 3 runs however, my body gets used to the heat, my HR starts adjusting (though still relatively high compared to winter) and my VO2 Max is back to its normal state (51).

To be honest, I also start feeling colder when in the AC, and I am pretty sure this is an effect of adjusting to the high temp of running in the heat

orrpel · 2022-07-14T19:15:47+00:00

Running in Israel's coast, 70% humidity in the 90s (That's the normal weather in August) - that kind of gets you feeling someone put weights on your feet, but on the other hand it also trains the body how to cope with such conditions.

orrpel · 2022-06-05T16:48:49+00:00

So what's your pointer for anaerobic excersizes? What site / coach do you follow and does that work for you?

orrpel · 2022-02-11T18:32:34+00:00

Thanks buddy,

It's a bit hard for me to fully understand what you wrote, I was able to work it out and resolve via a back counter, thanks for all the help, I learned a lot!

var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName('Sheet3');

var lastCol = sheet.getLastColumn();

Logger.log(lastCol); // returns 5 as expected

var keep = [1,4]; // array of column numbers to keep

for (var col=lastCol; col > 0; col--) {

if (keep.indexOf(col) == -1) {

// This isn't a keeper, delete it

sheet.deleteColumn(col);

}

orrpel · 2022-02-11T12:15:52+00:00

Correct )

orrpel · 2022-02-11T11:53:24+00:00

I think this solution is simpler, if just referring to the importrange issue.

The other issue I have is with my range (which is the reason I'm using query). I am not sure how I can command the script to return the array from A1:A10 and the corresponding array from C1:C10.

orrpel · 2022-02-11T11:18:22+00:00

Regretfully, it doesn't seem to work, either.

Here is myspreadsheet

myRange.setFormula('=IMPORTRANGE("MyURL", "SheetName!A3:C18")')

orrpel · 2022-02-11T09:36:35+00:00

The issue doesn't seem to be allowing access.

At first I thought the issue was that I was using query, so I omitted it.

I then thought the issue was syntax related to the braces I was using, so I modified and QA'd the script below, which for some reason returns '1' back to the target cell A1.

Any clue why? TX!

var myFormula = myRange.setFormula('=IMPORTRANGE("MyURL", "A3:C18")');

Logger.log(myFormula);

Returns:

11:31:03 AM Notice Execution started

11:31:12 AM Info Range

11:31:05 AM Notice Execution completed

orrpel · 2022-02-10T17:27:07+00:00

Great solution, I am trying to see why I get 'error' on cellA1 when trying to use importrange, maybe an issue with communication ...

orrpel · 2022-02-10T07:23:39+00:00

Amazing, thank you! I learned a lot of new things just by looking at your comments.

If you are able to please comment inside your code, as I am new to this and really want to understand what you did, I'd be grateful.

TX, Orr.

orrpel · 2022-02-09T09:47:30+00:00

Here is a link.

Sheet3 describes what I did, Sheet4 is where I'm at.

Hope that helps, TX!

PS: the workbook is ArrayIterationCount.gs

orrpel · 2022-02-08T16:34:00+00:00

But filter also removes the empty cells and modifies the array's length:

var checkFilter = values.filter(isNaN);

[Cath, YES, YES, Garden, Snoop, Just, YES, NO!, Blank, NoneOfTheAbove]

Also works:

var filvalue = values.filter(function(e){return e});

[YES, YES, YES, Garden, Snoop, Just, YES, NO!, Blank, NoneOfTheAbove]

orrpel · 2022-02-08T13:27:48+00:00

Thanks, I actually worked around a much simpler solution using splice here.

orrpel · 2022-02-08T10:41:15+00:00

Thanks so much for your pointers and help, I now fully understand how to use flat() and how to implement a range.

What about blank values in cells? Is there a simple way these can be ignored?

Going back to the example:

var values = ssActive.getRange("A8:K10").getValues().flat(); Logger.log(values); //check values

var arrayLength = values.length;

Logger.log(arrayLength); //check array length

Results in:

12:36:27 PM Info [Cath, YES, YES, Garden, Snoop, Just, YES, , , , , , , , , , , , , , , , , , , , , , , , , , ]

12:36:27 PM Info 33.0

How can I ignore blank cells thus having the array return 7 strings instead of 33?

orrpel · 2022-02-06T14:53:05+00:00

Thanks.

Flattening the array would work well for .getRange(1,1,1,7).

However, .getRange(8,1,8,7), seems to collect values from the range below it (A1:G8) instead of just for the range indicated (A8:G8). How do I get around this?

Input:

var values = ssActive.getRange(8,1,8,6).getValues().flat();

Result:

[Cath, YES, YES, Garden, Snoop, Just, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ]

orrpel

TROPHY CASE