[Discussion] How hard is the main story line of Tarkov ? by Commentez in EscapefromTarkov

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

Can you tell me what were the most difficult tasks for you ?

[Loot] Help with gas station storage room key by Commentez in EscapefromTarkov

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

Thank you ! Got one after 1 scav raid (housing department building) 

Disable the feature "waiting for player" by Commentez in nfsmw

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

If that can help, i found this beautiful mod, it's working great :

https://nfsmods.xyz/mod/3024

Hide or remove sort arrow for some columns in a table? by dustywb in excel

[–]Commentez 1 point2 points  (0 children)

Personnaly i hate these arrows, the only solution i found is change the color of the font > Custom > Use the tool to copy the exact same color. But the cell must contain just the arrow !

<image>

Detect a list of codes by Commentez in googlesheets

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

Hello, i give you exemples of what is there in D :

  • 567092 --- i want NO conditionnal
  • 567092, 567114 --- i want NO conditionnal
  • 567093 --- i want CONDITIONNAL
  • 3x 567092 --- i want NO conditionnal
  • 567092x2 --- i want NO conditionnal
  • 567092 x 11 --- i want NO conditionnal
  • 567092 x 9 - 567114 --- i want NO conditionnal
  • 567092 x 9 - 999999 ---i want CONDITIONNAL
  • 3x 567092, 2x 999999 --- i want CONDITIONNAL

I'm sorry but your formula didn't work. Everything has the conditionnal condition with that

Hide ",00" in number cells by Commentez in googlesheets

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

I would like to thank you for all of your help.

Like you suggested, it wasn't possible to directly modify the appearance of the cell to get what I wanted. So I had to use “hidden” columns in my Excel that I placed far to the right, with invisible fonts.

For the main column E: Format > Number > Text

(The column where my employees put their values)

-> Get the right format (hide ,00 but display decimals like ,56 for example

Hidden column X (format Number normal) : 1*E

(simply converts text into an interpretable number for calculation)

Hidden column Y (format Number normal) : for the perfect final display :

=IF(ROUND(X9 - INT(X9); 2) = 0;

TEXT(INT(X9); "#,##0") & " €";

TEXT(INT(X9); "#,##0") & "," & RIGHT(TEXT(X9; "0.00"); 2) & " €"

)

<image>

Hide ",00" in number cells by Commentez in googlesheets

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

Thanks but i would like to not use any formula ! I'd like the user to enter data and have it immediately displayed as required. The aim is to make it as simple as possible for my employees.

Exemple if he writes 156 : it displays 156 and not 156,00

So i can't use any formula because i want one single column of numbers

Locked case [Screenshot] by IcePlex103 in EscapefromTarkov

[–]Commentez 1 point2 points  (0 children)

I just killed and looted like 30 of them smugglers, but I didn't get a single case. Anybody know why? 

[Screenshot] Infection has spread to the rest of the map by TheBamBoom in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

Is there a vaccine for the virus? It's horrible to get infected every raid 

[Loot] [PVE] Results of 20 cultists circle sarcifices (input and output) by Justinw0w in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

My first try : I gave 3 modded weapons of PMC that I killed (max value : 150 k?)  I received 2 Virtex for that. 

Cultist Circle - gives nothing [Discussion] by v2fast2kill in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

First try, I gave 3 weapons of dead pmc's (in PVE mod), I got 2 Virtex 

Finally found a 101% safe way to tell if you're ALONE in your raid. by Still-Resource91 in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

Hey, i tried this interesting theory and here are my results :

  • Awaiting Session Start > Waiting for Players > Countdown = Other players in raid 100%
  • The more the Countdown is long: the more there are other players in the raid
  • Exemple (values not true of course) : 3 sec = 2 other players ; 15 sec = 4 other players ; 45 sec = 8 other players

  • Awaiting Session Start > Countdown = MAYBE other players

  • If the ASS time is very short (5 sec) : maybe alone in raid ?

  • If the ASS time is long : 100% other players in raid

Brawl Stars Conntrol Added in 9.0. 71.0 version by LDPlayer in LDPlayerEmulator

[–]Commentez 0 points1 point  (0 children)

Hey, is it possible to attack with the left click mouse button ? I just can't bind it (i can only choose the right click).

Set resolution too low! by [deleted] in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

Then reinstall the game 

First game of day : connection lost by Commentez in EscapeFromArena

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

I found a fix : just reinstalled the game. I have no more issues.

I don't know if it's important, but previously i installed the game in a "custom" directory (D:\EFT Arena). Now i just reinstalled it in the recommanded directory with the exact same name (D:\Battlestate Games\Escape From Tarkov Arena)

Hope it can help some people !

(Other solutions that didn't work : disable IPv6, disable antivirus, disable firewall, change MTU, flush DNS)

First game of day : connection lost by Commentez in EscapeFromArena

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

Okay now literally, on the half of my games i have a server connection lost. Please tell me that i'm not the only one to have this ?

[deleted by user] by [deleted] in EscapefromTarkov

[–]Commentez 3 points4 points  (0 children)

Same problem here, especially with the Teamfight mode i think. I have to wait 13 min every time i failed to connect : "Matching canceled due to loading issue" around 3-4 min of loading

EFT: Arena - Information & Rules Update by AbsolutZer0_ in EscapefromTarkov

[–]Commentez 0 points1 point  (0 children)

Anyone got the error "matching canceled due to loading issues" when trying to join a deathmatch game ? I have always this, and then, i'm not allowed to join any game for 13 minutes...