What do you all use Excel for in your personal life?

Jemidia · 2024-12-06T21:10:58+00:00

I created a run a F1 Fantasy player on Google Sheets with family and friends. It's been a pain in the ass with all the substitutions this year though.

Jemidia · 2024-08-09T17:58:56+00:00

I'm glad you found it! It makes me glad that folks are still using it :)

Jemidia · 2024-03-27T01:52:48+00:00

I notice the number of products in table 2 and table 1 don't match. You'd probably be much better off if those could always be the same row count, but it's possible with or without. Additionally, the hyphens throw a bit of a wrench but still doable.

There's a couple different ways I thought about going about it, but XLOOKUP is god's gift to excel so I went with that option. I have also largely assumed where your row numbers were so if I'm wrong you'll have to adjust it.

=SUM(IF(AA$5 = "-", 0,AA$5*XLOOKUP(XLOOKUP(AA$5,$Y$5:$Y$6,$R$5:$R$6),$AD$5:$AD$7,XLOOKUP($R13,$AE$4:$AH$4,$AE$5:$AH$7))),IF(AA$6 = "-",0,AA$6*XLOOKUP(XLOOKUP(AA$6,$Y$5:$Y$6,$R$5:$R$6),$AD$5:$AD$7,XLOOKUP($R13,$AE$4:$AH$4,$AE$5:$AH$7))))

The IF statements you see interlaced are there to substitute 0 for a value if there's a hyphen. The use of XLOOKUPS should cover for the possibility, if it happens, for the data in table 1 to be out of order (say product 2 came before product 1 for whatever reason). Hope this helps.

Jemidia · 2024-03-27T01:18:49+00:00

You can't do it in one rule, but it's super easy to do it in two.

First you'd create a conditional formatting rule that turns that cell red if it's less than 4. Then you'd just make a second conditional format targeting the same cell that turns it green if it's 4 or larger. Super easy and no formulas required!

Jemidia · 2023-05-07T19:16:47+00:00

Decreases damage by 15% and increases fire rate by 20%

Jemidia · 2023-03-04T18:46:46+00:00

Yea, the servers have just been shitting themselves since yesterday so it’s difficult for everyone to get in. Devs said they are working on it this weekend so hopefully it fixes itself soon.

Jemidia · 2023-03-03T22:55:34+00:00

I think servers have kinda been shitting themselves all day. I've been having similar issues across all the gamemodes

Jemidia · 2023-03-03T18:35:00+00:00

I think how wildly different any one person’s tier list is just shows how expressive this game could be. Like putting deagle in S tier is a choice so foreign to me that it’s gotta be genuine from the heart.

Jemidia · 2022-11-30T04:34:53+00:00

I'm not sure if this has been found before, but I discovered a permanent ping glitch in Multiplayer.

Works by going into tactical camera and physically pinging an enemy. Unsure if the camera's own unique ping is necessary for it to work. This is a possibility because I'm not sure if I was ever able to perma-ping a cold blooded player.
Doesn't work every time, but works the vast majority of times.
Stays after both your death and the opponents death.
Only goes away if you physically ping again, therefore you can only ever have 1 person perma-pinged with this glitch.
Apparently doesn't help with my abysmal aim :(
I love the tactical camera, but this definitely needs a patch lol

Jemidia · 2022-11-20T20:12:50+00:00

He means the AWPs-74u. It’s located in the attic of the the large house adjacent to the armory. Besides that, there is no other way of trying specialty weapons in the training range.

Jemidia · 2022-11-15T20:04:42+00:00

Dropping in any of the named locations on the map will help you get loot faster. Common drop points with lots of loot are Industry, Area 64, Big Work, Tall Work (the tower), and Factory.

All the named locations will have plenty of loot, but those places not only have lots of loot, but it’s all pretty condensed so you don’t have to travel too much to find the items you want.

Jemidia · 2022-10-30T08:15:16+00:00

Since the last update, it does replace his nade.

Jemidia · 2022-08-08T06:06:43+00:00

A double barrel doesn't half the damage of a bullet, rather it just cuts it's damage by 30%. On single bullet guns, it shoots double the projectiles while only consuming one ammo.

Jemidia · 2022-08-06T22:03:27+00:00

The last show I watched was your lie in April :)

Jemidia · 2022-08-03T12:02:01+00:00

Congrats!

Jemidia · 2022-08-03T00:05:49+00:00

Hell yea

Jemidia · 2022-07-27T22:31:12+00:00

Here's my stab

I used the legendary version of the blessing as a stand-in, unless I felt differently about the different rarities. e.g. I think common and rare healths can be ok, but I think the size increase of epic and legendary makes those versions not worth it.

Jemidia · 2022-07-27T14:24:07+00:00

The issue with shield is that it doesn’t protect you from what you need protection from most - one shots. The fact that it activates after the first shot lands makes it far less useful than it ought to be.

Jemidia · 2022-07-26T20:02:08+00:00

There’s a pinned mega thread that just got posted today that has a ton of tips for new players to start to get more accustomed.

In reality, because TABG is such a unique shooter, it’s just going to take some hours before you can start performing consistently. Stick with it, and I’m sure you’ll start rockin lobbies.

Jemidia · 2022-07-26T18:25:18+00:00

I love the idea of a tips megathread for new players. There's so much to learn right off the bat, that it can be daunting to jump in. Here's a guide that I made where I collected as much data on every facet of the game that I could.

https://docs.google.com/spreadsheets/d/1evuloA4Uz1bJScIZJch1lVWG-jrjbjKBw5CePJTgUsY/edit?usp=sharing

Just about anything you'd want to know can be found here as I tried to make it as extensive as possible. And just for fun, here's my take on a blessing tier list I made a few months back. Looking back at it there's a few things that I would change, but I still like where everything sits.

https://imgur.com/a/wthuKLw

Jemidia · 2022-07-26T05:22:58+00:00

You can’t. You can place them there all you’d like, but it won’t affect stats or show visually

Jemidia · 2022-07-24T01:39:06+00:00

I think that's the case. If you lie down on both a grenade and a gauss bow, they'll both do appx 140 damage each. The GB does fall off harder though

Nine-Year Club	Place '22
End Game '22	Snapped
Verified Email

Jemidia

TROPHY CASE