[Guide V2.0] Quickly Make and Use a Spreadsheet Market Calculator For Splinterlands.

avatar
(Edited)

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 10 minutes to make, unless you're stupid, then it will take you less than 20. 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 very 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.

Now copy the cells you see here into your table. No spaces after the = sign

-ABCDEFGHIJ
1$/BCXTotal BCXCustom %Custom TotalCustom $/BCX
21010101010
3Custom %Custom TotalCustom $/BCX
4OriginalBreak Even5% Profit10% Profit15% Profit20% Profit=C2*0.01=I7/B5=J7/B5
5List Price=A2*B2=B5/0.95=(((B5*0.05)+B5)/0.95)=(((B5*0.1)+B5)/0.95)=(((B5*0.15)+B5)/0.95)=(((B5*0.2)+B5)/0.95)=(((B5*H4)+B5)/0.95)=D2=E2*B2
6Market Fee=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05=(B5:J5)*.05
7Profit=(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))
8$ Per 1 BCX=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=(B5:I5)/B2=E2

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

On Row 4 Make sure when you do columns H I and J you hit the little percent button somewhere up top.

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.

That's it. Super fucking easy. I've been using this tool since I made it and its helped me a ton.

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



0
0
0.000
3 comments
avatar

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

You received more than 100 upvotes.
Your next target is to reach 200 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
0
0
0.000