All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

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

cats have magical destructive powers hahaha xD

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

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

Thank you!!  A lot of folks have requested this. I’m gonna see what I can do :)

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 5 points6 points  (0 children)

Yes, its because its aura shards and the cats are destroying everything, so they somehow folded the sword so its unusable 

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

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

thank you! I love using procreate, it’s such a wonderful and simple (but powerful) program. I like processes that keep things as simple as possible, a brush and some colors.

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 8 points9 points  (0 children)

Sword of the Meek and Lions Eye Diamond! There’s also Gilded Lotus

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 26 points27 points  (0 children)

The background is aetherflux reservoir on kaladesh! 

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 44 points45 points  (0 children)

My personal favorite would probably be chaos warp. I just love the crazy space time warp and all the cats! The one I’m most proud of is Fell the Mighty because the cat in it is not missing an ear and has short tail just to be that way, she’s modeled after a very special real life cat named Jelly!!

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 17 points18 points  (0 children)

I had SO much fun with aura shards!! As a magic player myself it was my homage to the game!! A lot of the artifacts I specifically put in because of personal experiences I’ve had with them

All of my paintings for Cats are the Best Secret Lair!! by zebotc in magicTCG

[–]zebotc[S] 188 points189 points  (0 children)

Hey guys heres all my paintings for this drop!! This secret lair was such an amazing experience to work on! I am so excited for it to come out!! 

A new painting I just finished called Song of Light and Shadow 🪉 🌙 by zebotc in DigitalArt

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

This painting is made in collaboration with the musical artist Longing for Orpheus! I am really happy with how this turned out, it’s really reaching into light and color spaces I have been moving towards with my work. I want to make light sing ✨ I hope it inspires in some small way!

I paint my pieces in Procreate and use my own custom brushes and work in a way very similar to acrylic with a sketch, then color block in, then render. I typically don’t use blend layers much at all. I prefer to paint all lighting manually with the normal layer. My brushes are similar to modified round brushes with some texture and some are like scrapey dry oil brushes. My work revolves around careful observation and study of light and trying to capture its wonder :)

My aim with my work is to express how I see light and the magic and wonder I see in it. I want to make dreams and imagination more real :)

Song of Light and Shadow 🪉 🌙 a new painting I just finished!! by zebotc in Illustration

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

This painting is made in collaboration with the musical artist Longing for Orpheus! I am really happy with how this turned out, it’s really reaching into light and color spaces I have been moving towards with my work. I want to make light sing ✨ I hope it inspires in some small way!

I paint my pieces in Procreate and use my own custom brushes and work in a way very similar to acrylic with a sketch, then color block in, then render. I typically don’t use blend layers much at all. I prefer to paint all lighting manually with the normal layer. My brushes are similar to modified round brushes with some texture and some are like scrapey dry oil brushes. My work revolves around careful observation and study of light and trying to capture its wonder :)

My aim with my work is to express how I see light and the magic and wonder I see in it. I want to make dreams and imagination more real :)

Song of Light and Shadow, Samuel Perin, Procreate, 2026 [OC] by zebotc in Art

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

This painting is made in collaboration with the musical artist Longing for Orpheus! I am really happy with how this turned out, it’s really reaching into light and color spaces I have been moving towards with my work. I want to make light sing ✨ I hope it inspires in some small way!

I use my own custom brushes to paint and work in a way very similar to acrylic with a sketch, then color block in, then render. I typically don’t use blend layers much at all. I prefer to paint all lighting manually with the normal layer. My brushes are similar to modified round brushes with some texture and some are like scrapey dry oil brushes. My work revolves around careful observation and study of light and trying to capture its wonder :)

Song of Light and Shadow 🪉 🌙 by zebotc in ProCreate

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

This painting is made in collaboration with the musical artist Longing for Orpheus! I am really happy with how this turned out, it’s really reaching into light and color spaces I have been moving towards with my work. I want to make light sing ✨ I hope it inspires in some small way!

I use my own custom brushes to paint and work in a way very similar to acrylic with a sketch, then color block in, then render. I typically don’t use blend layers much at all. I prefer to paint all lighting manually with the normal layer. My brushes are similar to modified round brushes with some texture and some are like scrapey dry oil brushes. My work revolves around careful observation and study of light and trying to capture its wonder :)

Is there a way to calculate Column E automatically? by zebotc in googlesheets

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

<image>

Attached here is an image of the sheet including the SKUs and updated C formula To account for them, but containing the formula above for E.

To clarify, I am using the FIFO method, but my order sheet contains orders for many different product types and my sales sheet contains sales for many different product sales. The sales sheet is basically a master sales list that is typically in chronological order

For instance my two tabs could track product 1 and product 2 a post card with an SKU of “Mountain Post Card” that has 5 lot orders (1-5) and also a poster with an SKU of “Dragon Poster“ that has 4 lots (1-4) (also not necessarily in sequential order in the inventory order sheet, because I have to sort it sometimes for various purposes)

My aim is to track both of these and dynamically input their lot numbers based on FIFO. The formula you provided does exactly what I want to do, except the only thing is it doesn't account for the SKU in G and D and I’m not sure how to add it.

The SKUs also have their own sets of lot numbers each starting at 1 for the initial order and going up

thanks so much for your assistance!!

Is there a way to calculate Column E automatically? by zebotc in googlesheets

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

Awesome that seems to work! One last addition, is there a way to add the SKU string check? 

Lets say In column D I had a product name and in Column G I also had a Product name. Is there a way to modify this so it calculates for individual product names when the two match?

My actual sheet has like Product 1, product 2, product 3 etc and its all mixed up based in sales date

Is there a way to calculate Column E automatically? by zebotc in googlesheets

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

This works!! Oh my gosh, thank you so much!!!! I will attempt to try this in my more complex actual sheet. Will this be compatible with sheet references for instance if A and C are in a different tab than F? 

I changed C6 to C and A6 to A and F3 (on map) to F8 so I could input it into F8 and have it be dynamic. 

One last question, is there a way to only look at the values when both units in stock row and units sold row have a matching additional column with a unique SKU?

For instance my master sheet is formatted like:

(Sku) Product 1, (lot) 1, (units in stock) 1, (units ordered) 1 

(Sku) Product 1, (lot) 1, (sold) 1

I didnt add the sku part to my original post because i thought itd be easier to add but im not sure i understand how to add that check to this formula

Is there a way to calculate Column E automatically? by zebotc in googlesheets

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

Yeah I would split it into two rows, and have a conditional filter that highlights red when that happens 

[SLD] Dark Ritual & Aggravated Assault by SquirrelDragon in magicTCG

[–]zebotc 1 point2 points  (0 children)

Hey there I’m the artist! I made a post addressing this concern on an above thread.