I referenced the "cost" because there is always something in there. The BIN column doesn't actually need to be filled out - that's only for people overly analytical like me.
I need to know how much liquidity I have at all times. . .LOL.
@Vinny1979 Have you figured out how to use it? I forgot to message you, I did see your post the other day! I tried to make it so that non-excel minded folks can use it with out much assistance.
Any feedback from you would be great; you had mentioned you're not too familiar!
@Absting159 Yeah I figured it. You just need to be methodical. Everytime you buy fill in all the prices etc, everytime you sell straight to it.
Easy to see liquiduty aswell, just takes a while first time, took me say 90 mins this morning to fill it with all my players and include all buy prices etc.
Im sure I should be cooking or something else, the mrs is in bed mind
Great work. Its easy to forget who is your best seller. With this its easy. Just keep on top of it is my tip
@Vinny1979 I know man. . .lol. I spend too much time playing in this thing to make it cooler, hahaha.
Half the formulas I learned for this. . . I ended up being 'the man' at work because we needed to create this custom report that we send out to the whole organization every day. . . I knew how to get the data we needed from making this darn thing, LOL.
It's nice when random hobby/interests pay off at work
Tagged anyone whose posted - as I update or find something cool, I'll tag anyone. I'll just keep that list growing, haha.
I think the Total Club Value on the 'Profit & Cost' tab needs updated - I moved some things around and didn't double check that.
It should be: ='Trade Tracker'!F2+'Trade Tracker'!I2+'Current Squads'!G3
In other words: Your Total Liquidity in TP + Coins + Squad Value = Total Club Value.
aka. if I sold everything I had this is what I'd have in coins.
Comments
If column G has a value >0 and column L has a value which = "N", count
If column G has a value >0 and column L has a value which = "Y", don't count
=COUNTIFS(L:L,"N", G:G,">0")
In my case, I would have to use the following formula:
=COUNTIFS(L:L,"N", F:F,">0")
https://docs.google.com/spreadsheets/d/1D3BGG1TsWHep2mUeyvy-olItPTsjPcEoLoLBBn09vSk/edit?usp=sharing
Review and update you formulas to match
Thanks for the morning brainstorm - NOW I'm off to work, lol.
Enjoy dude! Great work on this
I need to know how much liquidity I have at all times. . .LOL.
In the 'Profits & Cost' tab, what does column E 'Leaderboard' refer to?
I was watching the leaderboard Transfer Profit (in game) to try and figure out what it was. Hahah
Let me know if that works.
ok I am a excel noob
Any feedback from you would be great; you had mentioned you're not too familiar!
Easy to see liquiduty aswell, just takes a while first time, took me say 90 mins this morning to fill it with all my players and include all buy prices etc.
Im sure I should be cooking or something else, the mrs is in bed mind
Great work. Its easy to forget who is your best seller. With this its easy. Just keep on top of it is my tip
Half the formulas I learned for this. . . I ended up being 'the man' at work because we needed to create this custom report that we send out to the whole organization every day. . . I knew how to get the data we needed from making this darn thing, LOL.
It's nice when random hobby/interests pay off at work
Tagged anyone whose posted - as I update or find something cool, I'll tag anyone. I'll just keep that list growing, haha.
I think the Total Club Value on the 'Profit & Cost' tab needs updated - I moved some things around and didn't double check that.
It should be: ='Trade Tracker'!F2+'Trade Tracker'!I2+'Current Squads'!G3
In other words: Your Total Liquidity in TP + Coins + Squad Value = Total Club Value.
aka. if I sold everything I had this is what I'd have in coins.
mine now says 27k. It did say 207k
I hate formulas
='Trade Tracker'!F2+'Trade Tracker'!I2+'Current Squads'!G3
I had an extra cell in mine (testing something out before i put it in the pub one).
Have to enter it the yankee way
What
Murican way. Month comes first.
Tried it. Still error
Or: MM/DD/YYYY