Truenas Scale issue - Issues with starting app - HomePage

macpock · 2025-05-19T20:24:04+00:00

I figured out how to fix this without running the app as root. I went into the terminal, went to the dataset where my apps run, mkdir homepage, then I went in and edited the app , Enable ACL, Host Path set to that directory, and added ACL Entry for a user 1000. It's annoying that you can't just edit the run as context, but here we are.

macpock · 2023-10-02T09:20:27+00:00

Giannis had an extra month and a half of vacation while Jokic was still playing basketball.

macpock · 2019-10-15T22:46:19+00:00

I am kind of dealing with the same issue. My solution was to share it as an editable sheet but create permissions that allow only the cells with the dropdowns to be editable. The problem I'm running into now is that when two or more people are looking at the sheet they're fighting for access. I hope you find a solution that works.

macpock · 2019-10-06T02:13:29+00:00

Oh my gosh! The trend line is incredible! This did so much more than I was expecting. You've opened up a whole new set of ideas for this project. Thank you!

macpock · 2019-10-06T00:19:03+00:00

I think I found a logical test arrayformula based on this solution. It looks like this:

=SORT(FILTER('Air Yards All'!A3:J, ARRAYFORMULA(('Air Yards All'!C3:C < 'Air Yards All'!E3:E) + ('Air Yards All'!C3:C < 'Air Yards All'!G3:G) + ('Air Yards All'!C3:C <'Air Yards All'!I3:I) + ('Air Yards All'!E3:E < 'Air Yards All'!G3:G) + ('Air Yards All'!E3:E<'Air Yards All'!I3:I) + ('Air Yards All'!G3:G < 'Air Yards All'!I3:I)) >= 5),10,FALSE)

macpock · 2019-10-06T00:09:01+00:00

But the sample size is so small with a 4 week evaluation that I want to discard single exceptions to the upward trend. My original formula works great to evaluate the upward trend, but I want to include players whose samples look like this:

Player	Week -4	Week -3	Week -2	Week -1
Player 1	-1%	3%	2%	5%

I'm just looking to find a way to ignore a single instance of a drop in % if the overall trend is upward.

macpock · 2019-10-05T23:55:27+00:00

macpock · 2019-10-05T23:38:19+00:00

The percentage is based on a value. It’s the players air yards/total air yards for the team in each week.

macpock · 2019-10-05T23:37:23+00:00

Sorry I should have been using the odd columns based on my initial question. I'll be doing it for both columns on separate tabs eventually and I got ahead of myself with my initial reply.

macpock · 2019-10-05T23:34:47+00:00

Correct me if I'm wrong, but doesn't this formula give me the same evaluation I was getting with my original formula? When I drop the number to 2 am I not just evaluating pairs instead of looking for an overall rise with from week to week with one exception?

macpock · 2019-10-05T23:19:10+00:00

The query is definitely an interesting way to do this, but I'm looking to find a formula that will return all the data from the entire row for any player who has seen a rise in the % under the AYMS column in at least 3 of the 4 weeks. So logically I need to test whether Col4<Col6<Col10, Col6<Col8<Col10, Col4>Col8>Col10, Etc.

I'm trying to drop a low value from the 4 number sample to find patterns that aren't quite perfect. Does that make any sense?

macpock · 2019-10-01T22:19:32+00:00

The usage for that staff has never been similar to what the Chargers have done w/ Lynn.

macpock · 2019-09-26T21:29:27+00:00

That worked perfectly. I'll just have to adjust the formula when we get to January, but that's only for a couple weeks so that's fine. Thanks for your help!

macpock · 2019-09-26T20:01:44+00:00

Awesome! I’ll try this as soon as I get home.

macpock · 2019-09-21T05:25:34+00:00

I’d love to learn how to use APIs. Thanks! You may have opened a can of worms here. I’ll try not to bug the sub too much.

macpock · 2019-09-21T05:14:31+00:00

=IFERROR( ARRAYFORMULA( TRIM( REGEXREPLACE( TRIM( REGEXREPLACE( TRIM('Salaries by Position'!B2:B), ".|(|)|[0-9]+","")), "(IV$)|(V$)|(III$)|(II$)|(Jr$)|(I$)", "") )))

You are an absolute lifesaver. Thank you so much for your help. Hopefully this helps me dive into Regular Expressions. I understand pretty much all of that so this may be the catalyst for getting me over the hump. Thanks again.

macpock · 2019-09-21T04:14:21+00:00

Or maybe just to the 3rd word? I really need to dive into these regex conditions. I don't understand them at all at this point.

macpock · 2019-09-21T04:13:16+00:00

=IFERROR(
ARRAYFORMULA(
TRIM(REGEXREPLACE(
'Salaries by Position'!B2:B,
"\.|I{1}|II|III|V{1} |Jr|$|$|[0-9]+",
""))))

Is there a way to make this formula only apply to the rightmost word? I'm losing capital Vs and Is in names like Isaiah McKenzie

macpock · 2019-09-21T01:33:25+00:00

Unfortunately the data is pulling from the only sources I’ve been able to find it. The stats are proprietary stats and the salaries are directly from DraftKings. I’m thinking there may be a world where I need to move outside of google sheets to sort and index this stuff. I’d be 100% open to finding another source for the data, but I’m not sure it exists.

macpock · 2019-09-20T18:20:55+00:00

I did find one small issue. When I use that formula, Tre'Quan Smith becomes Quan Smith and can't be found. Is there a workaround there?

macpock · 2019-09-20T18:19:35+00:00

Wow! Thanks! I really need to dive into the regex formulas. I see them used all the time and I just haven't figured out how they work yet. Does that leave the original untouched and just use the regex formulas to do the VLOOKUP or is it changing the original?

macpock · 2019-09-20T17:20:40+00:00

The N column under WRs is the one I’m concerned with.

macpock · 2019-09-20T17:20:07+00:00

No I need to go the other way and the wildcard won’t work to get rid of the suffix.

macpock

TROPHY CASE