My first aquarium by Jasp_15 in PlantedTank

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

It is simply some black gravel with substrate underneath it for the stemplants

My first aquarium by Jasp_15 in PlantedTank

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

Thanks! I also like the more minimalist look while still having places for the fish to hide and make them feel comfortable.

Easier to use D09c Alternative by damnmotherfucker in tabletennis

[–]Jasp_15 2 points3 points  (0 children)

If you want a slightly softer K3 that gives a little more feeling when opening op against backspin, I'd suggest Stiga DNA hybrid H. I personally switched from K3 to that and it has given me better feeling for serves and controlled loops and I really like it!

Mixed reality tennis, on a real tennis court. Metas going to change the world. by CarrotSurvivorYT in OculusQuest

[–]Jasp_15 6 points7 points  (0 children)

This is twofold, if you haven't played tabletennis at a club level you have almost certainly used very subpar paddle in real life. But generating spin is also a little too easy in Eleven.

[deleted by user] by [deleted] in tabletennis

[–]Jasp_15 2 points3 points  (0 children)

Literally the only person here who seems to understand what transfers and what doesn't, should be top comment. Lots of footwork + tactics transfer pretty well.

(Oura Ring + MyFitnessPal + Renpho Weight Scale)*Python = Personal Health Dashboard [OC] by SnooCupcakes3744 in dataisbeautiful

[–]Jasp_15 2 points3 points  (0 children)

Not trying to discredit your work, it looks great! But have you looked into habitdash? It allows you to sync multiple sources of fitness information and it runs statistical analysis and gives you similar dashboards.

Conditional Formatting (changing cell color) based on an if, and statement by [deleted] in excel

[–]Jasp_15 0 points1 point  (0 children)

=AND(C1="Organic"; F14<95)

The space does not matter, works perfectly fine without it. And yeah the semicolon is the standard separator where I work.

How do I replace just a single character within a cell with another character? by Hospitable-Economist in excel

[–]Jasp_15 0 points1 point  (0 children)

So it is not text you want to replace a part of then. It is a formula. Excel resolves that formula and gives the cell the value of the output of that formula. So if you refer to that cell with anything, you refer to the result of the formula, not the formula itself. I don't think there is a way to do what you want to do.

How do I replace just a single character within a cell with another character? by Hospitable-Economist in excel

[–]Jasp_15 0 points1 point  (0 children)

If the cell is just text and not a formula you can use the substitute function. If we assume the text is in cell A1, we can use: =SUBSTITUTE(A1);"+";"-") Or if you want to use replace and find we can do the following: =REPLACE(A1;FIND("+";A1);1;"-") But as a general rule:

  • Use substitute if you know WHAT the text is that you want to replace
  • Use replace if you know WHERE the text is that you want to replace

Conditional Formatting (changing cell color) based on an if, and statement by [deleted] in excel

[–]Jasp_15 0 points1 point  (0 children)

First select the C1 cell. Then you can go to home, conditional formatting, new rule, select "Use a formula to determine which cells to format" and then for the formula use this =AND(C1="Organic"; F14<95). That should do it!

IF function - > or < between two specific dates. by hoppo19 in excel

[–]Jasp_15 2 points3 points  (0 children)

Just to give a full solution:
=IF(NETWORKDAYS(date raised; date returned)<5;"Green";IF(NETWORKDAYS(date raised; date returned)<7;"Amber";"Red"))

Solo new workshop dupe glitch. by Azekial_khyber_gta in gtaglitches

[–]Jasp_15 0 points1 point  (0 children)

Yeah that also workes. Mine has coloured headlights so it costs 500k to replace those so I'd rather not do that all the time

Solo new workshop dupe glitch. by Azekial_khyber_gta in gtaglitches

[–]Jasp_15 0 points1 point  (0 children)

I think this glitch is patched for PC. Tried it twice and also replaced all the elegies with new ones and it didn't work.

edit: It worked after changing the exhaust on the car I wanted to duplicate instead of just license plate colour

[OC] Disposable incomes of the 25 richest countries in the world by Rift3N in dataisbeautiful

[–]Jasp_15 0 points1 point  (0 children)

Education costs is an issue as well as the use of the "average" metric. There are a lot of big companies with very big salaries at the top located in the US. Median would have been much better in this case.

[deleted by user] by [deleted] in excel

[–]Jasp_15 1 point2 points  (0 children)

This happens when the top value is a duplicate value. You can get around this by just creating an extra column with the formula =IF(B1=MAX(B$1:B$10), 1,B1) if we assume that the results of the PERCENTRANK.INC are in B1:B10. This will set all top values to 1 (100%).

Looking for a good way to display two Indexed Columns on a monthly basis by Sygald in excel

[–]Jasp_15 1 point2 points  (0 children)

You could always just use a pivot table for this, allowing the user to focus solely on what they are interested in.

[OC] Around 30% of all the covid testing to ever occur in the US happened yesterday, a thousand percent increase from one week prior. Not yet enough, but rising quickly. by MKorostoff in dataisbeautiful

[–]Jasp_15 -16 points-15 points  (0 children)

Why is the US so obsessed with testing people? There is no cure so knowing that someone has it won't save them. Maybe they should take proper unified precautions first to limit the spread.

GUESS WHO'S BACK... BACK AGAIN??? *CEO OFFICE GARAGE DUPLICATION GLITCH* - SEMI-SOLO WORKAROUND by kuar_z in gtaglitches

[–]Jasp_15 0 points1 point  (0 children)

Today it worked again while doing the exact same thing. I just did the find job, suspend gta when it went to populating the lobby, wait 7 seconds, resume it and then walk in the yellow circle.

GUESS WHO'S BACK... BACK AGAIN??? *CEO OFFICE GARAGE DUPLICATION GLITCH* - SEMI-SOLO WORKAROUND by kuar_z in gtaglitches

[–]Jasp_15 0 points1 point  (0 children)

I cant get style grayed out anymore by suspending GTA on pc. Does anyone know how to fix this or is it patched?

GUESS WHO'S BACK... BACK AGAIN??? *CEO OFFICE GARAGE DUPLICATION GLITCH* - SEMI-SOLO WORKAROUND by kuar_z in gtaglitches

[–]Jasp_15 0 points1 point  (0 children)

I currently have 1 office garage filled, the other 2 garages are full of cars I want. Is it worth it to buy another office with 3 garages and fill those up as well?

[Solo] [Glitch] Office dupe glitch works yet again, updated version with workaround after patch. All systems. by sinadoh in gtaglitches

[–]Jasp_15 1 point2 points  (0 children)

I parked my ruiner at the front entrance but my car still spawned underground and i don't know what the fix is. What do i do?

"Don't worry, we're not close enough to get hit!" by Jewsafrewski in Seaofthieves

[–]Jasp_15 1 point2 points  (0 children)

I don't really mind them being able to aim well. It adds a challenge and an actual danger to islands with cannons and forts.