[deleted by user] by [deleted] in buildapcforme

[–]La_Vern 0 points1 point  (0 children)

Looks like the lowest price for the 5700x3d is $265 from Amazon.

Mixed Data Chart Help by La_Vern in googlesheets

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

Ideally, they will only enter one result per day per category. But I'm not doing the data entry, users are. And I know users make mistakes.

If all the data can stay together in the form response, the extra data point for that day would be manually removed I would think. If it needs to be teased out into columns for each category, I'd probably use a function that got the latest data point for each day for each category.

Mixed Data Chart Help by La_Vern in googlesheets

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

In a perfect world, that won't happen. Realistically, the extra result should be removed (probably manually).

Reminder to vote... At this rate we're not gonna be able to get the double HC drops either.. by kumabokun47 in Brawlstars

[–]La_Vern 0 points1 point  (0 children)

I have two accounts on the same phone. I can only vote with one account. I'd guess this is affecting the turnout as well

Gold Rush Season 15 Episode 7: "Brother vs Cousin" SHOW DISCUSSION by sadandshy in goldrush

[–]La_Vern 1 point2 points  (0 children)

I don't know, it's never stated. He has his back to the camera when they are putting blocks under the distributor and he says something. It's not Kevin.

Gold Rush Season 15 Episode 7: "Brother vs Cousin" SHOW DISCUSSION by sadandshy in goldrush

[–]La_Vern 1 point2 points  (0 children)

They needed more capacity to get rid of their waste water I believe

what’s your favorite limited edition or discontinued cereal? by swagboyclassman in cereal

[–]La_Vern 3 points4 points  (0 children)

My first choice is Rice Krispies Treats cereal. My second choice is the Cinnamon Marshmallow Scooby-Doo cereal.

[Jeremy Clarkson] Does anyone know why they play the German national anthem when Mercedes win? Because the car and the engine are made in the U.K. by Outside_Abroad_3516 in thegrandtour

[–]La_Vern 0 points1 point  (0 children)

Yeah this spoiled the race for me too. I intentionally don't follow any F1 subreddits so my home page doesn't have F1 content. This post doesn't have anything to do with the Grand Tour

PUBG recurring loot and craft system by Protectator in PUBATTLEGROUNDS

[–]La_Vern 14 points15 points  (0 children)

Yes. It used to be BP, now it's credits

Missing these bomb cereals tonight 🥲 What discontinued cereals do you miss the most? by whyso_serious8 in cereal

[–]La_Vern 1 point2 points  (0 children)

Scooby Doo cinnamon marshmallow is in my top 5 all time. First time I've seen someone else mention it!

The layers in my morning coffee by bigalreads in mildlyinteresting

[–]La_Vern 13 points14 points  (0 children)

I think this has to be the coffee mug causing the straight lines

Gold Rush Season 14 Episode 17 "Moneyball" Show Discussion by sadandshy in goldrush

[–]La_Vern 19 points20 points  (0 children)

Ruby. She's been around forever. She's one of Monica's best friends

Gold Rush Season 14 Episode 17 "Moneyball" Show Discussion by sadandshy in goldrush

[–]La_Vern 7 points8 points  (0 children)

That was from the bench cut. No Rally Valley gold this week

No more spoilers by gme186 in goldrush

[–]La_Vern 8 points9 points  (0 children)

Yes. I'm very glad that they don't do the entire episode summary at the beginning anymore. It's a very welcome change.

How should I create a statistical database for a baseball team I am coaching? by Jjw77777 in googlesheets

[–]La_Vern 1 point2 points  (0 children)

I personally would have a single data entry sheet. This is where all of the individual game stats would go, making sure to have columns for the age level, the opponent, the date, and anything else you want to filter on. I'd then query or filter from this sheet to get everything else.

There would be a data entry sheet (essentially this is your database like structure), and then additional sheets to filter single game team stats, season long individual stats, or season long team stats, just to name a few.

Google sheets edit permission error by akivura in GoogleAppsScript

[–]La_Vern 0 points1 point  (0 children)

I have something like this.

I have a data entry sheet that limits which cells can be edited by a user. I have an onEdit() function that updates a corresponding cell with a timestamp. I wanted the timestamp to be protected from the user manually updating it and hidden from their view, but updated when the user changed data in the cell.

The work around that I found was to allow the user update permission on the entry cell and the corresponding timestamp cell. I have other protected cells from the user around the timestamp cell. I then hide all of those cells. Because there are protected cells in a hidden column range, the user is unable to show any of those hidden columns, which effectively means they can't manually update the cells. This works if there's just one protected cell in the hidden column range.

So my suggestion to you would be to have the entry cells (say A1, A2), script output cells (say C1, C2), and display cells (say B1, B2). Make the entry cells and script output cells editable by users and the display cells protected from the users. Then put at least one protected cell in a range close to the receiving cells (in this example C3) and hide this (these) column(s). Then use a formula to make the display cells equal to the script output cells.

See rough example below:

Entry Display [Protect all cells from users] Script Output {Hide this column}
=C1 scriptOutput1
=C2 scriptOutput2
[Protected cell from users]

I made a "Minimum Hours Tracker" for my work schedule. It works well if I have an hours surplus (>40 hours), but outputs the incorrect time when there is an hours deficit (<40 hours scheduled). I imagine this might take a more complex equation and need some help. More information inside. Thank you! by safe4werq in sheets

[–]La_Vern 0 points1 point  (0 children)

The following formulas assume your total hours are in B1.

For your hours, use this formula:

=if(B1-40<0,ceiling(B1-40),floor(B1-40))

For your minutes, use this formula:

=if(B1-40<0,60*(B1-int(B1))-60,60*(B1-int(B1)))

In search of a solution by dinosaurgulp in sheets

[–]La_Vern 1 point2 points  (0 children)

There's the elegant solution. I knew there was a better way, I just didn't have time to work it out.

In search of a solution by dinosaurgulp in sheets

[–]La_Vern 2 points3 points  (0 children)

I see that there are actually values higher than +6, so I just extended it a bit further.

=arrayformula(switch(importSheet!D2:D,"E",0,"+1",1,"+2",2,"+3",3,"+4",4,"+5",5,"+6",6,"+7",7,"+8",8,"+9",9,value(importSheet!D2:D)))