Spreadsheet Lovers Unite To Share

[Esixxx]

The video sales spreadsheet requires ALOT of data entry. I like the concept behind to track what are the best performing clips and categories

The Cash Flow template I use to track income vs expenses. I tweaked the template to better suit my needs- and switched up the drop down menus. I'll take a looksie at the video sales template- I think it's best suited for content focused models. I still have not entered the data for the video sales. I'm just mainly using it as a reference to build out the ideal excel template

[KortneyKay]

I'll just use it to track my daily goals and use it as a budget tracker. I just wanted something simple that I can type, save, and go. I edited the drop down sites and will just have to key in dates as I go.

[ggminx]

Code: Select all

=(small(B382:H382,2))+(IF(G374+H374>=10, (G382+H382)*0.25, 0))

this is the formula I added for the 6th day bonus from BM and the 10 hour req. for the 25% bonus.

Code: Select all

=(small(B382:H382,2))

This part of the formula is for the 2nd lowest day of the range of 7 cells

this formula still needs to take into account if 0 hours are worked on the 2nd lowest day, it needs to return a 0...because cammodel earnings!!! woot woot!

will update once I have time to figure it out

the formula I'm still working on is returning the 2nd lowest value above 0.
the 0 requirement is being applied before the 2nd lowest number is found.
I need to flip it around

Code: Select all

=ArrayFormula(SMALL(if(B9:H9>0,B17:H17),2))

b9:h9 are the range of cells that must be greater than 0 for the 2nd lowest number in range b17:h17 to be listed or return a 0

ETA:

Code: Select all

=IF(AND(B9:H9)>0, SMALL(B17:H17, 2), 0)

got the formula!!!!! chatGPT4 got me most of the way there when I listed the criteria and conditions. It gave me MIN instead of AND. I'm sure that's due to my wording

with this formula, if your 2nd lowest day of the week is a positive number, but there are 0 hours worked that day, it will return a 0 for the weekly bonus.
B9:H9 are the hours and B17:H17 are the earnings

ETA #2:

in case you want to add this week's contest to the same cell...I like all my bonuses in one cell on mine:

Code: Select all

=(IF(AND(B9:H9)>0, SMALL(B17:H17, 2), 0))+(IF(B392+C392>=10, (B400+C400).25, 0))

this one has the 10 hour requirement (from cells B392+C392) and the 25% bonus (from cells B400+C400) after the 2nd lowest day bonus

Code: Select all

=if(and(1000<=J400,sum(B400:H400)>=25),100,if(and(500<=J400,J400<1000,sum(B400:H400)>=25),50,if(and(250<=J400,J400<500,sum(B400:H400)>=25),25,0)))

this formula is for the 25 on 250, 50 on 500, and 100 on 1k+ bonuses. J400 is the income for the week on SM. B400:H400 is the cell range for the week's hours

if you want to put slap it on the back of the other formula above, it will look like this :

Code: Select all

=(IF(AND(B392:H392)>0, SMALL(B400:H400, 2), 0))+(IF(B392+C392>=10, (B400+C400)*0.25, 0))+(if(and(1000<=J400,sum(B400:H400)>=25),100,if(and(500<=J400,J400<1000,sum(B392:H392)>=25),50,if(and(250<=J400,J400<500,sum(B392:H392)>=25),25,0))))

since this week crosses over months, it's gonna make the formulas even more fun!!!

[Esixxx]

I finally completed the Video Analysis tab on the spreasheet that I mentioned earlier. It was a tedious process and I managed to record the July sales. It's really cool to see the data in visual form and complete a step in the process.

Now to do some tweaks to it