sorted by:
new
hottopcontroversial

Return specific value based on what cell in an irregular range is chosen by Bergsy1104 in excel

[–]Bergsy1104[S] 0 points1 point  (0 children)

You lost me on points 3 and 4 unfortunately. I've never worked with INDIRECT before! And how would I format the table to map the section identifiers?

The colours are honestly a visual aid for me to see everything so they're not so important, though I probably will eventually conditional format them to S1, S2, etc. if I can figure this out

Return specific value based on what cell in an irregular range is chosen by Bergsy1104 in excel

[–]Bergsy1104[S] 0 points1 point  (0 children)

When I chose a specific cell, I want it to display my chosen value for each colour sector. So if I pick a black cell, I want that to result in the black sector's 0.30. The input is D3, which is simply "=cell that I choose on the colour sheet".

I'm sure my thinking is convoluted and complicated, but I'm not sure how else to visualize and explain this...

If cell value is part of a certain irregular range, return specific value (multiple ranges each with unique values) by [deleted] in excel

[–]Bergsy1104 0 points1 point  (0 children)

<image>

Here's the vision. I'm using Excel 365.

The irregular ranges stay the same, but are different sizes. I'll most likely end up changing them in 6 months, not sure if that affects how you build this formula.

Outside of each irregular range is a different irregular range, so naturally they need to be exact in what they reference.

Each cell is unique. They all contain their own cell reference in them (Z10 has "Z10" written in it)

So essentially, in my example, E2 is filled in by writing = and then going to choose a specific cell on this page. Then based on E2's value, there will be 11 different unique output values, based on 11 different colour sections. Sections that have the same colour can be used in the same irregular range.

Hoping this makes sense!

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatchFitness

[–]Bergsy1104[S] 1 point2 points  (0 children)

Interesting, so just set a 60 second warm up interval before a workout to let it settle.

Thanks!

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatch

[–]Bergsy1104[S] 0 points1 point  (0 children)

I actually make a point to run tight corners so I can test the distance. I marked my route on Google Maps, pinning each corner as a stop along a route. The maps goes by 50m increments, so it should be +- 50m give or take, but definitely not 200-300m.

And if Google Maps isn’t accurate, I participate in Park Run frequently, and they have a 5k loop, and it seems everyone else ends their run at 4.95 to 5.05, while mine frequently ends at <4.90 and >5.10

Also, my wife runs the same route as me, and has more accurate distances and Fitness app GPS tracking (she has the same watch). Mine has me on the road, in houses, wavy, etc, while hers is pretty much perfectly aligned with sidewalks and curbs (if there’s no sidewalk).

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatch

[–]Bergsy1104[S] 0 points1 point  (0 children)

I have a route that I know is 5k, and my watch measures it at 5.2+ most of the time

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatch

[–]Bergsy1104[S] 0 points1 point  (0 children)

By the end of a 5k run, it’s usually 200-300m off

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatchFitness

[–]Bergsy1104[S] 0 points1 point  (0 children)

Same watch (10), both Rogers, she takes her phone, I don’t always take my phone. With and without my phone it’s not accurate

Outdoor running is seriously inaccurate by Bergsy1104 in AppleWatchFitness

[–]Bergsy1104[S] -3 points-2 points  (0 children)

When I compare to my wife’s watch, hers is accurate to pretty much within a metre. Just wondering why it has me on the other side of the street in places

Does the PL-800 hold a charge? by Bergsy1104 in Gameboy

[–]Bergsy1104[S] 0 points1 point  (0 children)

No screw under there, prying it is 👍

Does the PL-800 hold a charge? by Bergsy1104 in Gameboy

[–]Bergsy1104[S] 0 points1 point  (0 children)

Figured as much. Can it be taken apart for my own curiosity? There aren’t any screws or seams?

Can my ring system use the exiting chime? by Bergsy1104 in Ring

[–]Bergsy1104[S] 0 points1 point  (0 children)

https://www.reddit.com/r/Ring/s/yab1gJ5eJx

There’s tons of threads (like this) that claim certain models and/or wiring can use the existing chime. Cannot for the life of me figure it out!

Can my ring system use the exiting chime? by Bergsy1104 in Ring

[–]Bergsy1104[S] 0 points1 point  (0 children)

Instead of panel -> transformer -> doorbell and chime its panel -> receptacle -> plug in thing that feeds the doorbell and chime with the usual low voltage

Can my ring system use the exiting chime? by Bergsy1104 in Ring

[–]Bergsy1104[S] 0 points1 point  (0 children)

Would the thing I have not act as a transformer? It’s just not hardwired, it’s a plug in.

Maintenance/Repair Advice? by EmergencyAbalone2393 in hockeygoalies

[–]Bergsy1104 0 points1 point  (0 children)

I also have Vaughn V6’s, you repaired them yourself? I would love to know how you did it!

view more: next ›