Spreadsheet v1.7

View previous topic View next topic Go down

Spreadsheet v1.7

Post by Cyborg360 on 13/5/2014, 4:20 am

Hello Guest!! Congratulation on finding a tool that will facilitate your life here in Epic. Before going to the main thing lets explain some basics.

What is a workbook/worksheet?

1. A workbook is basically a cyber log where you can record all types of info, from numbers to actual words.
2. A worksheet is a current page of the workbook.



   There are few programs that can manage workbooks. When I say manage I'm referring to edit or customize a workbook with tons of features like; Graphs, Tables, even importing data from online sources. Which this particular one we are going to be using Microsoft Excel.

How can a workbook help me here and in my daily profit making?

   Well a workbook can facilitate you some process like calculations and other stuffs. This particular one will help you calculate, manage and track item. This will also be useful for logs, as it will have records of the item profit, profit% and total profit. The current tool you about to look at has been designed to be flipping and investment friendly.

Lets get started!!


Worksheet


First of, we are going to start with the basic entries.



Item: Here you will put the items name. Its preferable to use the correct and full name as it will help the worksheet later on.
Quantity: Here you will put the quantity of the item to use.
Sale price: In the sale price tab you will put the selling price.
Buy Price: In this tab you will enter the buying price for the item.


Here is where you save time.

Profit: In the profit tab you will see the profit that the item is currently achieving.
Percent: There you will see the profit percentage.
Total Profit: In this tab you will see the total profit made from the flip/investment you made.
Total Log Profit: There you will see the total profit made on the log.

This part is just an extra for a more accurate wealth management. Its not needed in order to have a functional log. As stated before it is just an extra feature.



This part will be explained backward in order to achieve a complete understanding.
Starting Wealth: In this tab you will enter the current cash wealth you have/had. It's better if you put it before making any entire.
Earnings/Losses: On this two tabs you will add miscellaneous earnings/losses like boss drops, profit calculation expenses, etc..
Current Wealth: In here you will see a display of your current cash. Accuracy on the wealth displayed will depend on the accuracy and amount of info entered in the earnings, losses and starting wealth tab.

This section here is a tool that will come in handy when in game.



First Row: This row is to calculate the profit of the item. Even though computers have a calculator, some people don't feel comfortable with it.
Second Row: This row is to immediately calculate the total price to pay. Enter the quantity and price of the item and there you will have it.
Third Row: This third row is to help the profit to be more accurate. It is used when ever you get a buy/sell for a different total that you were expecting. This will give you the price per item sold/bought.


This is a display on how to use it properly when using the calculator.



Item Manager


This section is mostly to track the use of every item entered in the log. This can be use to get ideas for items and to see what item is getting you the most profit.


Item: This is the part where writing the complete and full name correctly takes part. Here enter the name of the item once. After that, the next features will update automatically.
Times Merched: This section will display how many times you have used the item in the log.
Total Item Profit: This column will display the total profit made with the item.



Investment Tracker



This part is self explanatory. But lets explain it anyways.

Item: Here goes the item name.
Current Price: In here you will enter the current price of the item. Update this price every time you check the item.
Target Price: In here you will enter the price you are waiting to invest.
Date Range: In here you will enter the dates range in which you think the item will reach the target price.
Graph Link: Enter the link of the item graph.

Link for download: https://drive.google.com/file/d/0ByMdV1wR4ZgZN3N2M19SQ2tTb2c/edit?usp=sharing[/color]


Last edited by Cyborg360 on 9/6/2014, 12:52 pm; edited 1 time in total
avatar
Cyborg360
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by gonecase on 20/5/2014, 2:43 am

interesting i will try this out
avatar
gonecase
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Ms. Santa on 20/5/2014, 3:59 am

This is really interesting. Nice!
avatar
Ms. Santa
Grandmaster (2000 posts)
Grandmaster (2000 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by [ADMIN] Billious on 20/5/2014, 6:06 am

+Rep. A lot of work has been put into this and I'll definitely show mentees this. Hopefully they like it. Btw fixed a few typo's I noticed.

_____________________


H o m e   o f   t h e   R E A L   M e r c h a n t s
Jun 2014
Dec 2013Jul 2013
Dec 2012Jul 2012
avatar
[ADMIN] Billious
Administrator
Administrator


Back to top Go down

Re: Spreadsheet v1.7

Post by Cyborg360 on 20/5/2014, 12:03 pm

Billious wrote:+Rep. A lot of work has been put into this and I'll definitely show mentees this. Hopefully they like it. Btw fixed a few typo's I noticed.

Roger that!!!

Thanks you all, I'm currently working on another project evolving an actual program.
avatar
Cyborg360
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Spunq on 9/6/2014, 12:24 am

+Repped you earlier when speaking to rpguy about it, just downloaded it/using it now Very Happy

Also, for the Investment Tracker section you've called it the 'Item Tracker', and just above you put 'Total Item Profit: This column will display the total profit made whit the item.' (Should be with)
Sorry to be such a nazi Razz
avatar
Spunq
Forum Master (1500 posts)
Forum Master (1500 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Kelly on 9/6/2014, 1:15 am

A lot of hard work went into this, great utility! Thanks a ton Cyborg! +Repped

_____________________





MY iEMZ PC CEREMONY AWARDS (2014):
~*~ iEmz PC Awards Winter 2014 ~*~





MY SM CEREMONY AWARDS (2012 TO 2014):


avatar
Kelly
Grandmaster (2000 posts)
Grandmaster (2000 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by gonecase on 9/6/2014, 1:57 am

+ repped for this i am using it and its nice !!
avatar
gonecase
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Spunq on 9/6/2014, 11:39 am

gonecase wrote:+ repped for this i am using it and its nice !!
He cheats and doesn't add his loses, kb him!! Razz
avatar
Spunq
Forum Master (1500 posts)
Forum Master (1500 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Fatal on 9/6/2014, 4:37 pm

I also use this sheet, and I am loving it. +rep.

Spunq wrote:
gonecase wrote:+ repped for this i am using it and its nice !!
He cheats and doesn't add his loses, kb him!! Razz

Listing losses takes too much effort. My total is never right Very Happy
avatar
Fatal
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by gunmage8 on 9/6/2014, 9:53 pm

+rep, downloading this now to test it out thanks babe!
avatar
gunmage8
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Cyborg360 on 9/6/2014, 11:08 pm

gunmage8 wrote:+rep, downloading this now to test it out thanks babe!

hahah ^  Razz 

Thank you all for the support, will be working and learning new things to bring tool, tips and other stuffs to sm!!
avatar
Cyborg360
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Fatal on 10/6/2014, 2:54 am

Hey Cyborg,

Is there a way to make the item tracker automatically input new items?
avatar
Fatal
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Cyborg360 on 15/6/2014, 10:18 pm

Fatal wrote:Hey Cyborg,

Is there a way to make the item tracker automatically input new items?

Sorry for the late replay!! yes there is!! At the momment I'm learning to
avatar
Cyborg360
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by Fatal on 16/6/2014, 7:44 pm

You're fine on the reply Razz and awesome, hope to hear about it soon!!
avatar
Fatal
Forum Addict (750 posts)
Forum Addict (750 posts)


Back to top Go down

Re: Spreadsheet v1.7

Post by merkeysa on 5/8/2014, 9:47 pm

this is really good I cant wait to try the program any news on that and what it does??

+rep

merkeysa
Tier 1 (Registered)
Tier 1 (Registered)


Back to top Go down

Re: Spreadsheet v1.7

Post by Trollblod on 5/9/2014, 11:37 pm

How did you know my name?!!

Anyways, gj on a nice guide, will for sure use this next week.

Trollblod
Tier 1 (Registered)
Tier 1 (Registered)


Back to top Go down

Re: Spreadsheet v1.7

Post by Rizmor on 3/12/2014, 3:35 pm

Looks good! You can fix the #DIV/0 by doing =IFERROR(formule) Wink

Rizmor
Tier 1 (Registered)
Tier 1 (Registered)


Back to top Go down

Re: Spreadsheet v1.7

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum