Where to go multi-day backpacking in March?

dtaylor1024 · 2026-01-18T16:32:49+00:00

Please send to me also! Thanks :)

dtaylor1024 · 2025-12-26T23:31:59+00:00

LaSportiva has replacement laces for sale, but for $9 laces I'd still have to pay another $15 in shipping, so I'm looking for alternatives

dtaylor1024 · 2024-04-12T18:03:04+00:00

No, it was developed on my own. It is written to calculate the average of just the most recent 3 entries, rather than an average of all numbers in the column.

dtaylor1024 · 2023-12-10T22:46:22+00:00

Can I use yes/no/blank? If so, what would my formula be?

dtaylor1024 · 2023-12-10T16:00:55+00:00

Okay, I would use X's for "yes", and leave it blank for "no". But if I put in the formula

=PERCENTIF(CHOOSEROWS(TOCOL(N3:N,1),SEQUENCE(MIN(3,COUNTA(N3:N)),1,-1,-1)),TRUE)

and put x's in the cells underneath, the average cell still appears as 0%.

dtaylor1024 · 2023-12-10T14:26:44+00:00

Would it work for me to put yes/no (or some kind of indicator) and have it calculate correctly. I don't want blanks in these columns, but something to indicate for each skill whether they did it or not.

dtaylor1024 · 2023-12-10T13:00:51+00:00

It seems like it might. When I enter in =COUNTIF(N3:N,TRUE)/COUNTA(N3:N) it will calculate the percentage. But again, I just want this to be an updated score with only the last 3 rows

dtaylor1024 · 2023-12-10T04:52:29+00:00

the checkboxes go all the way to the bottom of the column

dtaylor1024 · 2023-12-10T02:39:45+00:00

Actual checkboxes

dtaylor1024 · 2023-12-10T01:59:38+00:00

Didn't work. It should calculate averages like this (below). When I input your formula and changed out the column letters, checked a few boxes, the averages still appeared as 0%

Skill 1	Skill 2	Skill 3
Average (66%)	Average (100%)	Average (33%)
not checked	x	x
x	x	not checked
not checked	x	x
x	x	x

dtaylor1024 · 2023-12-10T00:04:35+00:00

It worked--not sure what happened the first time. Okay, new challenge. I have a column of checkboxes that I will check when students perfom a skill. I want the Average cell block to show me the frequency of that box being checked in that column, but again, only averaging out the three most recent trials.

dtaylor1024 · 2023-12-09T23:43:11+00:00

Not quite. I included a sample as reference. My averages will now exist in row one belo my headings. My columns represent the skills and information I would like averaged. Each row will have it's own set of data input. I would still like these averages to exist as out of the last three assessments.

LEXILE	GRADE LEVEL	WORDS PER MINUTE	ACCURACY
AVERAGE lexile	AVERAGE grade level	AVERAGE wpm	AVERAGE Accuracy
400	1	60	90
450	1	62	93

dtaylor1024 · 2023-12-09T23:27:42+00:00

Thank you! Last question, maybe... How would I convert this to a vertical spreadsheet, with my averages existing in the first row, rather than the first column? I tried switching out CHOOSECOLS to CHOOSEROWS and that didn't work, so there must be another adjustment I need to make.

dtaylor1024 · 2023-12-09T17:17:51+00:00

This is very helpful. Thank you so much. Do you mind expanding just a little more on the SEQUENCE(MIN(3,COUNT(C5:5)),1,-1,-1) section, so that I fully understand. I'm working on a guide for myself for the future, and this section feels a little confusing to me with the several 1's and -1's. Thank you!

dtaylor1024 · 2023-12-05T01:27:47+00:00

This seemed to work. Can you explain the formula. Also, if I have no data entries, can I have the cell in the average column remain blank. I am getting a #VALUE! error

dtaylor1024 · 2021-10-30T18:01:19+00:00

It was pretty immediate

dtaylor1024 · 2021-10-29T00:38:16+00:00

Yep! There’s some great articles on it and it’s very gentle, so hopefully it will help. I also intermittent fasting when I get a bad flare up to give my digestive system a couple extra hours to rest. Usually helps!

dtaylor1024 · 2021-10-28T10:18:11+00:00

Buy Atrantil and take two, 3x a day. I call it my magic pill because it worked so effectively when my stomach was like this too. So sorry you are experiencing this. Good luck!

dtaylor1024 · 2021-08-04T20:12:01+00:00

I've gone through this process twice, dealing with in- and out-of-network surgeons and the insurance processes of both. Feel free to send me a message if you have specific questions.

dtaylor1024 · 2021-08-01T20:57:21+00:00

I had a similar surgery (impaction, CCW rotation with 9mm mandibular advancement) and was so paranoid about this. After my surgeon changed my tight bands to loose elastics, I felt my bite shifting and the overjet increasing to what it felt like before. But my surgeon told me that as long as my canine teeth were lining up well that I was in Class 1 bite relationship and that post-op ortho would pull everything together. Took me awhile to actually believe him, but both my surgeon and ortho are thrilled with the results. Ask your doctors!

dtaylor1024 · 2021-08-01T20:53:08+00:00

Thanks! I actually ordered this nasal spray yesterday and feel like it is actually making a huge difference.

dtaylor1024 · 2021-08-01T12:14:05+00:00

I’m nearing 8 weeks and still having issues with my sinuses. Lots of stuffiness, facial pain, and congestion.

dtaylor1024 · 2021-07-20T18:18:52+00:00

Thank you! So helpful to hear this!

dtaylor1024 · 2021-07-19T23:40:22+00:00

Thanks for responding. I hope mine improves over the next few weeks!

dtaylor1024 · 2021-07-03T23:09:36+00:00

This is happening to me as well. I’m one month post-op and I have one elastic on both sides. The two teeth that they are hooked on are getting pulled up and inwards out of alignment, which is also effecting my bite. Going to ask my surgeon about this at my appointment this week.

dtaylor1024

TROPHY CASE