[Guide] Quickly Make and Use a Spreadsheet Market Calculator and Begin to Profit.

in Splinterlands2 months ago

No matter how great you are at math, figuring out how to profit on the market can be a real chore. There's a good chance a lot of you have your calculator open while you browse peakmonsters. Are you sick of sliding the decimal and dividing by two over and over in your head to account for that 5% market cut? Are you sick of quadruple checking your mental math and constantly second guessing yourself? Is this you?

image.png

Well this is your lucky day! I'm going to show you how to quickly make a spreadsheet calculator and save yourself a lot of time and headache. Even better, I will include what you can paste in every row and each column, to save yourself a maths! It should take you less than an hour to make, unless you're stupid, then it will take you less than two. All you need is a program like Excel. I used a free one called LibreOffice, which is better than Microsoft Office because it does all the same shit for free. What a world!

But first let's talk about how it works.

Here's what the one I just built looks like (It took me two hours because I am stupid):
image.png

So how does it work? Very easily. You only need to worry about changing the values at the top and then BOOM, the bottom portion fills itself in! Wow!

Let's quickly break this crap down...

In this example 11 combined cards at 0.479$/BCX is for sale. We input only those two values.

$/BCX How much one card costs.

Total BCX How many cards there are.

Custom % If you wish to make a certain percentage of profit.*

Custom Total Useful when you wanna figure out your $/BCX on a total. This comes in handy when you wanna post below fireking.*

Custom $/BCX Useful for posting multiple cards, since you have to always math guru the total dollar amount for some dumb reason.*

*note that these are all nicely color coordinated for easy eye looking

This is what the results tell you:

List Price - The original total price, and all the prices you will need to list the cards for to make a certain profit.

Market Fee This is how much the market fucks you.

Profit This is the number you want to be big.

$ Per 1 BCX This is how much you'll make off 1 card.

Fucking amazing! Let's make your own!

  • Step 1 Open your excel like program. Once again, my excel like program is called LibreOffice and its free on Google. I'm assuming the commands are the same in excel.

  • Step 2 Note the lettered columns, and the numbered rows, let's get to editing. This is where your copy and paste skills come in handy. Mega advanced ultrapro trade secret, use Ctrl-c and Ctrl-v.

Lets go by Rows, just copy and paste left to right

  • Row 1, Columns A-E each line is a new box starting with column A and going right all the way to column E.

$/BCX
Total BCX
Custom %
Custom Total
Custom $/BCX

  • Row 2, Column A through E type any numbers into this, but you can paste these following numbers if it helps.

10
10
10
10
10

  • Row 3 Columns H, I, and J Leave A through G blank, they're for chumps.

Custom %
Custom Total
Custom $/BCX

  • Row 4 Columns B through J lol...bj...heh heh. Get it? Nevermind, just skip Column A. Make sure when you do columns H I and J you hit the little percent button somewhere up top.

Original
Break Even
5% Profit
10% Profit
15% Profit
20% Profit
=C2*0.01
=I7/B5
=J7/B5

  • Row 5 Columns A through J

List Price
=B5/0.95
=(((B50.05)+B5)/0.95)
=(((B5
0.1)+B5)/0.95)
=(((B50.15)+B5)/0.95)
=(((B5
0.2)+B5)/0.95)
=(((B5*H4)+B5)/0.95)
=I7/B5
=J7/B5

  • Row 6 Columns A through J that second command just write in all columns B through J...lol

Market Fee
=(B5:J5)*.05

  • Row 7 Columns A through J

Profit
=(B5-(B5+B6))
=(B5-(C5-C6))
=-(B5-(D5-D6))
=-(B5-(E5-E6))
=-(B5-(F5-F6))
=-(B5-(G5-G6))
=-(B5-(H5-H6))
=-(B5-(I5-I6))
=-(B5-(J5-J6))

  • Row 7 Columns A through J In columns a through I do the same command and in column I do the second line.

=(B5:I5)/B2
=E2

Now look at this picture and copy the bold and color scheme, or pick your own:
image.png

Make sure to use the +.00 button to add a decimal so it rounds to 3 like on peakmonsters, and that % symbol in those H4 I4 J4 percentages up top there so your numbers dont get pooped on. The symbol to the left of the % changes it to dollars, do that where its appropriate. Its nice cause it automatically makes negatives red.

Thats really all I got for you. I love you. You can message me on discord on wastoid#3049 or send DEC tips to godzillayolo420

Heres a drawing for the art contests I keep seeing, its from a cartoon I watched as a kid.

image.png

Have fun making money. This is my first guide, and my test to see if its worthwhile for me to post on splintertalk.

Love,
godzillayolo420

Sort:  

Hello, @godzillayolo420! This is @traciyork from the @ocd (Original Content Decentralized) curation team. We noticed you shared your first post here on Hive - congratulations and welcome! While I haven't started playing Splinterlands yet (so that first graphic pretty much was my face reading your post...lol), it looks like you've got some awesome information here.

It would also be awesome if you could do an introduction post, so our community can get to know you better. For an example of what an intro post is like, you can check out this one by my friend & curation team member -

Keeping Up With the Buzz - My Introduction to the Hive Community.

Speaking of community, we have many different ones here on the blockchain, devoted to all kinds of interests. Here's a link so you can check them all out - Hive Communities . I see you already found Splinterlands, and you might be interested in the Hive Gaming Community as well. Oh, and definitely check out OnChainArt if you post more of Spongebob and Patrick! 😀

Also, as Hive can sometimes be quite confusing, the newly launched Newbies Guide should be helpful to you, as it is a growing repository of useful and easy to understand posts about how the Hive ecosystem works.

Please be aware that Hive is a bit different from other social media platforms since you are monetizing your blog, so it is important not to include content that you don't own without sources (and it shouldn't exceed 50% of the post). For more information, check this post - Why and How People Abuse and Plagiarise by hivewatchers.

For now, @lovesniper will follow your account and we are looking forward to seeing your intro post. Also, please mention (also known as tagging) @traciyork & @lovesniper in your intro post in order for us to be notified, so we can consider your post for OCD curation. Lastly, feel free to hop into the OCD Discord server if you have any questions!

Congratulations @godzillayolo420! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You received more than 50 upvotes.
Your next target is to reach 100 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out the last post from @hivebuzz:

Feedback from the October 1st Hive Power Up Day
Hive Power Up Month Challenge - Winners List