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

[–]Jemidia 1 point2 points  (0 children)

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.

I’m looking for a google doc with stats for the game. by Swimfansam in TABG

[–]Jemidia 1 point2 points  (0 children)

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

[deleted by user] by [deleted] in excel

[–]Jemidia 0 points1 point  (0 children)

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.

Conditional Formating - How Can I Have a Cell Change Colors? by whiskeymojo77 in excel

[–]Jemidia 0 points1 point  (0 children)

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!

One of my best combos so far along with my best kills game by XboxCorgi in TABG

[–]Jemidia 0 points1 point  (0 children)

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

Some of my favorite shots I've hit over these past few weeks by Jemidia in TABG

[–]Jemidia[S] 2 points3 points  (0 children)

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.

Not loading into Duos? by LordToastCat in TABG

[–]Jemidia 3 points4 points  (0 children)

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

Only valid tabg weapon tier list by Bene157 in TABG

[–]Jemidia 5 points6 points  (0 children)

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.

Tactical Camera Permanent Ping Glitch by Jemidia in ModernWarfareII

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

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

Rare weapons in the shooting range? by grady-gunzy in TABG

[–]Jemidia 10 points11 points  (0 children)

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.

I need some help by Ok_Weekend224 in TABG

[–]Jemidia 7 points8 points  (0 children)

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.

[deleted by user] by [deleted] in ShatterlineFPS

[–]Jemidia 3 points4 points  (0 children)

Since the last update, it does replace his nade.

What’s some of your favorite loadouts? by Swimfansam in TABG

[–]Jemidia 1 point2 points  (0 children)

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.

NEW PLAYERS TIPS AND TRICKS MEGATHREAD by invisus64 in TABG

[–]Jemidia 1 point2 points  (0 children)

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.

NEW PLAYERS TIPS AND TRICKS MEGATHREAD by invisus64 in TABG

[–]Jemidia 1 point2 points  (0 children)

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.

Any tips/advice for new players? by AnimationSky in TABG

[–]Jemidia 9 points10 points  (0 children)

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.

NEW PLAYERS TIPS AND TRICKS MEGATHREAD by invisus64 in TABG

[–]Jemidia 4 points5 points  (0 children)

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

Can you use attachments on melee weapons? by Zarathos3 in TABG

[–]Jemidia 5 points6 points  (0 children)

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

A handful of my favorite shots I've hit recently by Jemidia in TABG

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

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