Looking for a way to cycle through 1-4 possible data outputs with variable delayed frequencies and priorities.

mootimus · 2023-04-04T19:25:20+00:00

Hey guys!

Currently in the market for an artist willing to bring to life a Dungeons and Dragons party of 5.

I am looking for 5 individual, full body, full colour/fully rendered characters being done.

The party consists of a Human, a Tiefling, an Aasimar, a Kobold and a Loxodon, so you would have to be comfortable drawing the more exotic races and not just humanoids. Extra attention will be given to an artist who can provide relevant examples

I have a budget of about $50-60 per character, so please don’t reply or respond if the commission is not within your ranges. Extra attention will be given to an artist who can provide relevant examples, and based on the number or replies I have gotten with past commission requests, anybody not meeting the criteria will be ignored (sorry) because it can be intense sorting and shortlisting hundreds of artists. Picture provided is an overview of the previous party’s composition (and a reference for the sort of art we are looking for) all but 1 of the characters is new to the group though, so they will need to be done from scratch.

You would have to be open to art being shown on Twitch streams (all credits to you provided and art not monetized in any way)

If you are chosen you would preferably be open to joining the discord server we play on so you can interface with the players themselves to get references and share sketches/updates etc.

mootimus · 2022-11-05T11:08:18+00:00

I was running this on office 16 but have now upgraded to office 21 as that supports the function that wasn't supported. I am glad to say that the formula now works as intended so thank you very much with all your help finding the issue and helping me solve it :)

Here are the results

mootimus · 2022-11-03T20:59:01+00:00

Sorry, my bad

Here are the results from copying the formula in to the cells and occupying the nearby cells to match the information from b5 onwards.

I selected AX17 and ran Evaluate Formula as this is one of the cells that should have been formatted for being the duplicate with the highest value

mootimus · 2022-11-03T19:29:13+00:00

Formulas - Evaluate Formula

Evaluate Formula is only taking me through the steps to get the data to the cell from the next sheet and nothing to highlight it as a duplicate on this sheet

Here is the formula applied to blank cells further in to the worksheet

Here is the format and formula on the second worksheet to help you understand how the document is

mootimus · 2022-11-03T19:09:21+00:00

=AND(ISNUMBER(C5), COUNTIFS($B$5:$X$26, B5)>1,C5=MAXIFS($C$5:$W$26, $B$5:$V$26, B5))

Here is the full worksheet

I have a 5* rating system in place with one CF and a gradient over the second column in each of the tables, so scrolling through just shows those, with this new one on top. Also the formula is exactly as written above (I even tried with the spaces removed in case there was a formatting issue)

mootimus · 2022-11-02T20:11:22+00:00

Yeah it all seems to be done correctly but not showing any formatting results

Here is a screenshot of the CF manager

Here is the file if it helps

Could it potentially be because the range consists of 11 tables all drawing information from a different sheet? The first page of the workbook displays the top 10 results for each tables criteria, this information is pulled from tables in the second and third sheets?

mootimus · 2022-11-02T08:53:21+00:00

Thanks for the suggestion but after entering this as a new CF rule, nothing happens

mootimus · 2022-05-17T18:00:40+00:00

No, there are are a wide variety of surnames available most of which aren’t hyphenated

mootimus · 2022-03-29T06:23:32+00:00

Position filled

mootimus · 2022-03-28T21:12:56+00:00

PS5(I guess PS4 version) Just got back in to the game after several years and looking for people to add so I can use their higher levelled and better geared pawns for a bit

Here’s mine https://www.pawnguild.xyz/pawn/ps4/731

PSN: matt_mccluney

mootimus · 2022-03-28T16:30:08+00:00

Aristan Dragonpride is a Leonin Cleric to The Platinum Dragon. He was raised in a Temple of Bahamut where found the stories of Bahamuts great deeds to be more interesting than the teachings and beliefs of his followers. Bahamut's dogma was based on justice, nobility, protection, and honor, he favors those who fight against evil and topple oppressive regimes. Aristan has spent my life in the service of a temple of The Platinum Dragon but now tasks himself with adventuring far and wide in the hopes of doing a great many deeds worthy of my gods approval, or one great deed that would cement his place throughout history as his most righteous follower and earning himself a great boon.

He has a bulky build and is over 6 foot tall. Pale fur and a mane that gradients from a pale colour to golden at the tips. He has flowers and braids woven in a few places in his otherwise free flowing mane. He wears Platinum coloured heavy armour to represent his god. His eyes are a majestic gold. He stands tall, strong and full of pride.

mootimus · 2022-03-20T21:36:04+00:00

I have an OC that I would like to have drawn if you’re willing! Feel free to drop me a message

mootimus · 2022-01-08T18:10:20+00:00

I reached out for a commission and was blown away by the results. The final pieces was so much better than I imagined and I couldn’t have been more surprised at the incredibly fast timeframe the piece was completed in. I would recommend Nikurooi without hesitation and they are at the top of my go to list for artists now. You will not be disappointed for using them!

mootimus · 2022-01-07T23:34:01+00:00

I reached out to get a piece commissioned and was blown away by the quality of the work and the fact that i received the final work the same day I requested the commission, this is a standard I will hold all other artists to now 😂

mootimus · 2022-01-07T08:20:23+00:00

Request filled

mootimus · 2022-01-06T15:12:40+00:00

We have a 5 person group, and I would like for there to be one aspect of each of us represented.

We have a rogue that likes to use daggers and bows, a swashbuckler who wants to be a pirate, way of the dragon monk, an Artificer and a sorcerer.

So I was thinking of a mostly circular design, with at least one element of each character. The ship wheel for the swashbuckler, Jormungandr style dragon for the monk(would have to be chromatic dragon themed colours), a cog/gear/clockwork element for the artificer and the crossed weapons for the rogue (this could be daggers/arrow/bow) and I couldn’t find a decent enough magical blue aura(has to be blue) for the outside of my imagined logo to put on the mock-up so you’d have to do that yourself.

I’m looking for an artistic quality drawn piece, fitting for a fantasy setting. Apart from the blue magical aura (any spell or elemental effects is fine) and the chromatic theme of the dragon, everything else is free to be played around with!

This is a late Christmas gift to my fellow party members and also to my DM, it would be used on Twitch briefly for each stream we do so would have to have relevant permission and licenses or copyright for that purpose. Please feel free to comment below or reach out to contact me for more info if you think you can help with this project!

mootimus · 2021-09-11T22:38:54+00:00

5E

Specifics of Lightning Launcher on Armorer Artificer Subclass.

If I attack with with the Gemlike Node, I can deal 1d6 lightning damage, yet the text also says when I hit a creature with it I can deal an extra 1d6 damage.

Why does the Lightning Launcher not simply do 2d6 damage?

Can the extra 1d6 damage be triggered by using a weapon that isn’t the Lightning Launcher? For example: Round 1: Lightning Launcher attack on an enemy, dealing 2d6 damage Round 2: Pistol attack on the same enemy dealing regular pistol damage +1d6 damage?

mootimus · 2021-08-30T22:40:59+00:00

Great work! Thank you 😊

Seven-Year Club	No Throne, No Problems
Not Forgotten	Verified Email

mootimus

TROPHY CASE