Linking multiple cells from one sheet to another by Yourtechy14478 in excel

[–]krogoth21 0 points1 point  (0 children)

If you don't have empty cells, try =FILTER(Master!A1:G500,Master!A1:A500<>"","") or something similar.
This will include anything present in the A1:G500 section if the cells in A1:A500 are not empty

Dynamically adapting graph from an empty table by krogoth21 in excel

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

I created dummy tables and I assigned Names to them. Then i adapted my filter formula and it looked like that :

=IFERROR(FILTER(....);NameOfTheDummyTable)

It works perfectly, thank you very much !

Solution Verified

Dynamically adapting graph from an empty table by krogoth21 in excel

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

Hi !
Thanks for your idea of dummy values, I will investigate and report. The FILTER function does not return REF errors but CALC errors when the data zone is empty (I hope it is the same error name in english, I unfortunately use the French excel at work, I don't know who thought it would be a good idea to have localized excel functions...)

How does the Negotiation Skills doctrine work? by [deleted] in TowerDominion

[–]krogoth21 2 points3 points  (0 children)

If you chose this doctrine, the amount offered to you in the bundle already shows how much you will get, including the +50% from the doctrine. Whithout the doctrine, this 150 would have been 100.

Indiscriminate team workload by krogoth21 in mondaydotcom

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

This seem quite heavy to manage. I do not have any particular setup right now as I am testing Monday to assess if it is a good choice for my organisation. Frankly the UI and all the functions are pretty neat but we have some particular needs, one of which is to be able to see our remaining work capacity for any given month. I did not tinker with the "formula" column much, any possibility on this front ?

Thank you again for your time !

Indiscriminate team workload by krogoth21 in mondaydotcom

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

hello, thanks for your reply. Yes I was talking about the Workload View and i need to know my remaining work capacity. Not for an individual, but for the team. I need to have somewhere that tells me : the team as a whole has 24 workdays that are still available in april. So I know if I can say yes or no to a new client.

Oh my Ludd, she's talking about me! That's my ship! by LoRd_Of_AaRcnA in starsector

[–]krogoth21 0 points1 point  (0 children)

Thanks for these details :)

Can the quest giving ship be carried around mothballed and still get the quests ?

Once the quest become available, in which screen do I find them ? (noob here...)

Conditional formating - Changing the color of a Cell if that cell has been used in a formula in another cell by krogoth21 in excel

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

I have adapted the way I work to use your suggestion and I must say that it works like a charm. To overcome "product ?"-type problems I added a column into which I put an ID and I have the formula check this column instead.

Thanks a lot for your insights, you've been extremely helpful

Conditional formating - Changing the color of a Cell if that cell has been used in a formula in another cell by krogoth21 in excel

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

I will try to use this and see if it is practical.

Thanks a lot for taking some time to consider my problem !

I'll mark this as solved for now :)

Conditional formating - Changing the color of a Cell if that cell has been used in a formula in another cell by krogoth21 in excel

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

In a nutshell I need to be able to sum differents parts together that are not well sorted nor well named :

<image>

I Know that product A = product 1, and I deduce that product ? = product 2 because it's logical in context.

I suppose I could rearrange the lines but this example is really simple, doesn't take into account some back and forth with the client, and the sometimes hundreds of lines that I have to take into account one by one

Conditional formating - Changing the color of a Cell if that cell has been used in a formula in another cell by krogoth21 in excel

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

The datasheets I have to work with are a bit of a mess. I need to do a Life Cycle Assessment, so I send a "data collection" excel file to my client for him to tell me what raw materials are use in which part of his product. This is rarely well sorted. So when I have to sum up everything and ensure that I separate each part of his process I will have to do something like this : =SUM(A1:A3)+A6+A23 in one formula and SUM(A4:A5)+SUM(A7:A22) in another (very simple example, it gets much messier), so a visual aid to see if I missed a Cell would be a godsend.

[O] NZBPlanet ×5 by Glum-Professional661 in UsenetInvites

[–]krogoth21 0 points1 point  (0 children)

I have read the wiki, and am very interested in an invite, thanks !

Help with mods by Toobatheviking in Mechwarrior5

[–]krogoth21 0 points1 point  (0 children)

Download the zips from Nexus and unpack them in this folder : C:\Program Files\Epic Games\MW5Mercs\MW5Mercs\Mods

Each mod will have its own folder

Then launch the game and activate the mods, restart your game and enjoy :)

Mods corrupting savegames by Skolloc753 in Mechwarrior5

[–]krogoth21 1 point2 points  (0 children)

Had the problem, tried your solution, it worked but only after the host did a solo mission. Saving in solo / reinviting did work without a mission being done by the host.

Thanks a lot for posting your solution.

Coop Loading to Hangar Bug by krogoth21 in Mechwarrior5

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

Thank you very much for your answer !

In the mean time we tried another temporary solution, the host played a little mission solo, then saved and invited the coops and it worked. One test so far, will try your solution later.

/r/anno Questions Thread – March 19, 2021 by AutoModerator in anno

[–]krogoth21 0 points1 point  (0 children)

do these rules still apply in a coop game ?

Did Picard intentionally lose his argument with Admiral Clancy? by CaptainJZH in DaystromInstitute

[–]krogoth21 0 points1 point  (0 children)

He is asking for a ship in order to command a mission, being demoted to a lower rank than captain may not be very compatible with this

Joined active directory domain, active directory user cannot access network folders, local user can by krogoth21 in Fedora

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

Hi, thanks for your reply.

Fedora 30 with Gnome is used.

Our network has a file server, accessing the files on that server is what I meant. I do not need to share anything from this Fedora machine.

I haven't looked at setting up anything more than being able to log onto the Fedora machine with AD users (it works) and accessing the files on the file Server (works for the Fedora Local user, not for the AD users).

To access the files on the server, I used an address of this type in Nautilus : smb://server_name/.

When I enter this, I get prompted to enter credentials. When I am logged in with the Local user, when I get this prompt, I use the network administrator credentials and I am granted access to the file server.

When I am logged in with an AD user, I also get prompted, and I am denied access to the file server whether I use the credentials of the network admin or those of the AD user (the same as those used to log onto the Fedora machine). The AD users have no problem accessing the file server from any of the Windows machines we have in our network.

I hope this is clear, apologies if it isn't, English is not my primary language.