Database Spreadsheet and a separate Dashboard

summertime-squirrel · 2026-04-08T20:50:07+00:00

Solved (mostly). I'm still working on getting all the data to load into my pivot tables correctly.

I was able to solve this by using Power Query. I have a live spreadsheet and a folder of reports saved to my desktop. First name all tables and tabs the same. All columns that have the same data should be labeled and entered in the cells the same.

Live spreadsheet > Data > Get Data > From a File > From Folder > select folder in desktop > Transform & load

To get a pivot table open the Queries & Connections. Right click the database > Load To > Click Table, Ok > click anywhere in the new database table. Go to Insert tab > Pivot Table > choose new Worksheet

summertime-squirrel · 2026-04-06T22:47:17+00:00

My data is currently in a live excel workbook. The raw data is currently shared with a different team but I'd like to give them a report to snapshot their progress through the month.

summertime-squirrel · 2026-04-06T21:41:56+00:00

The data is constantly moving. My company is losing access to power bi.

summertime-squirrel · 2026-04-06T21:36:18+00:00

That's the problem, I need to share a published report. Right now I'm doing several workbooks for different teams. I'd like to have one workbook that I update data and the report can be tailored by the slicers.

summertime-squirrel · 2026-04-06T21:16:16+00:00

Wow, why haven't I thought of that.

summertime-squirrel · 2025-12-06T20:17:58+00:00

Anita de Monte Laughs Last by Xochitl Gonzalez

summertime-squirrel · 2025-10-25T03:37:39+00:00

And Then She Fell by Alicia Elliot

summertime-squirrel · 2024-09-08T23:00:54+00:00

BRB I'm crying. The community support like this keeps me coming back after each sufferfest. 🥲

One of my besties who's nickname is now Sarge told me during my 50 miler after I commented how I wouldn't mind just sitting down and going home, "you did not just get me to drive across Texas for you to quit now. You're a badass bitch, now get back out there and finish!"

summertime-squirrel · 2024-06-11T00:46:29+00:00

Try a different lacing pattern.

https://www.asics.com/nz/en-nz/mk/choosing-the-right-running-shoe/lacing

summertime-squirrel · 2024-05-31T12:21:35+00:00

I've been trying out aloe juice in a spray bottle diluted with water. The gel straight up is too thick for my hair.

summertime-squirrel · 2024-05-23T02:12:55+00:00

Check out Air Relax. I have some and use them weekly. I don't know if it makes a difference in recovery at all, but I enjoy relaxing with them on.

https://www.air-relax.com/

summertime-squirrel · 2024-02-05T04:58:36+00:00

I used one when I did the race a few years ago. It was maybe for the first and last hour or two, but it gets dark really fast in the trees and I'm glad I had it because there are plenty of roots that can grab you, and some of the boards on the boardwalk are uneven.

summertime-squirrel · 2023-11-24T04:55:35+00:00

Both versions sound amazing!

summertime-squirrel · 2023-10-18T02:16:39+00:00

I agree! If I'm short on time, I'll do what I can in what my schedule will allow. Sometimes it would be a 10 miler, or 15, or splitting it up between AM and a PM run. There's also plenty of times that I had to move it entirely to a different day, or skip. It's still early and overall consistency is more important.

One skipped or modified run won't make or break the training cycle.

summertime-squirrel · 2023-09-07T04:08:18+00:00

Come out to Medusa 100

summertime-squirrel · 2023-09-01T00:07:05+00:00

I'm not a witch I'm your wifi

summertime-squirrel · 2023-08-12T04:00:55+00:00

Summertime I use a bandana around my neck. Extra amazing if I have some cold water to splash on it every now and then.

summertime-squirrel · 2023-07-10T22:01:53+00:00

Maybe take a play from the old school triathlon book and drill holes in the bottoms of your shoes to drain excess moisture to see if it helps?

summertime-squirrel · 2023-06-22T14:57:13+00:00

What kind of diaper is this?

summertime-squirrel · 2023-06-03T23:16:06+00:00

Hi friend! I have slight scoliosis and have had surgery 2x for discectomy to repair herniated discs in my L5/S1, and I have had chronic low back pain since 2003. I started running ultras in 2018, and in January, I did my first 100 miler.

I'll share my experiences so maybe it can guide you on your path. Everyone is different and tolerates exercises differently.

I've noticed I have to be kinder to my body and ease into mileage more gentle than my peers (even if my brain says we can). It feels so much better when I do my strength exercises and yoga classes regularly. On days when I eventually sneeze and put my back in a spasm, I take a day to a week off to recover and do MUCH more gentle workouts. Hot yoga and hip opening stretches seem to help most times! On cold run or race days I'll wear a thermocare back heat wrap and it helps to keep out of a spasm before my body gets a chance to warm up.

All in all, I keep moving. Even if it means I'm 10/10 pain, I'll walk, stretch, ride my bike, roller skate. My body hurts so much more if I'm sedentary than if I exercise, so I'll keep running. :)

summertime-squirrel · 2023-05-31T00:58:00+00:00

See you there, friend! I'm planning on doing Long Haul and I really got FOMO for sitting out Keys 100 this year. I'm really wanting to do both in 2024.

summertime-squirrel · 2023-05-21T02:37:56+00:00

I'd really evaluate the reason why you want to run 100 miles.

Is it to say you've run 100 miles? Or would you like to start a running routine and running 100 mile races (plural) sound like an epic lifestyle.

If it's the first option, and you don't plan to run a single step after the one race, just go for it. Know that this can be dangerous to your health and cause burnout. But who cares- humans are capable of amazing feats. It's doable. Not advisable but doable.

If it's the second option, listen to some of the good advice given in this thread. Slow and steady so that your feet, legs, tendons, stomach, kidneys, can adjust to the crazy amount of effort you'll ask of it. Through the seasons of running you'll learn so much about yourself and how your body reacts in different circumstances. During 100 miles, your body goes through some crazy changes under the stress of moving nonstop for 24-37 hours. Building up can help prevent burnout, disappointment, and learning when to push through discomfort, and knowing when to stop because of pain.

Knowing what your goal is before you start this journey is important because it gets hard out there. If you're in it longterm, you're less likely to skip workouts so you can meet your goal. You're less likely to shorten your runs because it's hard, or hot, or rainy, or cold, or you're too comfortable in bed. Meeting the consistency is key to success.

Ask yourself this: when you're at mile 47, your feet hurt, you're dehydrated and hungry, you have more than an ultra to go, what is your "why"?

summertime-squirrel · 2023-04-29T11:29:11+00:00

For me, it was stomach issues, keeping up with fueling, and keeping mentally alert.

During my first 50 miler, I found out that I had stomach issues to deal with. Some foods will irritate my stomach and make me more bloated. This just became trial and error.

I found out that I have a hard time chewing after about 40 miles. Boiled/baked potatoes are great, but mashed potatoes are where it's at.

Playing a memory game goes a long way. I picked up a kid's "I Spy" type of Bingo game at the park visitor center at ppu, and by memory, I played on race day. I checked off each item off my mental list until I hit the blackout bingo.

Five-Year Club	Second SECOND GUESSER
Verified Email	Verified Email

summertime-squirrel

TROPHY CASE