Falagor
Stalker
- Joined
- Feb 13, 2008
- Posts
- 2,472
- Location
- Poland
- Society
- NBK Rangers
- Avatar Name
- Falagor Falagor Frostmaster
@edit:
when i will be adding some new information here - for some time it will have different color (green or blue - alternately) so people who subscribed can easily see new information added.
-------------------------
Introduction:
Hello - seeing how many people keep track of their returns here on PCF i have decided i will share my own log. I already have lots of data on my hard drive but i needed something fresh so i have decided to use google docs to share data - so this is going to be new log starting from today (but i already have experience in keeping track of returns so it will not be newbie log).
I am not sure what forum category this should go because i will keep 3 different types of logs (mayby 4):
-------------------------
Links:
Here is my TT overal returns log: <click>
Here is my Crafting log: <click>
Here is my Mining log: <click>
Here is my Huting log: <click>
-------------------------
Goals:
TT overal returns log:
I want to keep exact track of my TT spendings vs TT gains. I am really accurate at keeping this. I want to really convince myself that i am getting somewhere between 90-95% TT returns and also show/prove this to others. Later when more data is collected, log may evole a bit - i already have in mind something like "hof/global predicter" which would be based on what is the state of my personal lootpool (but thats future). Also probably summarise for each month will appear too.
What i will keep track of:
Added "Minimal profit after markup" column - this is to show my estimated minimal profit/loss i get on my activities. It is way lower than my actuall profit i make because it is rather underestimated and i do not include any extra actions i take to increase my pedcard (like trading, sweating or selling skills). This information is extra and not main focus of this log (but it is fun to watch minimal profit/loss i get).
Activities can overlap and the moment i put info in this log is when i end run. I.e. i can start 1k drops ore+enm run and after 400 drops make break. Then go on 2k peds hunting run that will be finsihed (at this moment info is put into the log). And later make last 600 drops (this will be moment when i put info on mining into the log).
Crafting log:
It will contain few chosen items (mainly components) that i might be crafting on regular basis espetially when market values are right. Log will be very accurate. It will contain nr of clicks, success rate, markup on materials and products, exact nr of items looted and many more.
Basicly this info may be interesting for advanced logers . Notice that this log will not contain ALL crafting runs - if i will craft something that i just want to try - it probably will not appear here (but definetly will appear in overal TT log).
Information on each item will be kept in different sheets (tabs at the top).
Info about yellow-orange colors of title on the column, in the log: yellow - something i type in before/after run, orange - something that is counted automatically (this form of colouring helps me out).
Sadly there is some sort of problem with borders in google sheets: when i add borders or "freeze line" i suddenly get lots of lags when editing and also published version gets really scrambled. I know that in this log borders would help a lot to make this log clear but for now it is not possible to use them (if you know how to solve this problem - please PM me or post here).
Mining log:
It will contain all my mining runs done. There will be four sheets (tabs at the top):
For personal reason i will not reveal what finder i am using. Also to "hide" this information but keep transparent my total TT cost i will have "Finder + Excavators + Enhancers cost" column. So clever and curious person will not be able to find out what finder i was using based on nr of drops. The reason why i hide this is becasue i want to keep some of my mining secrets. And obviously key to profit is: timing + finder + area. Since pro miners will easily see what area i was mining at then only info i can (and want to) hide is finder .
Hunting log:
It will contain all items looted with quantity and markup. Cost and returns. Also second tab will contain all items looted while filling this log and TT value of single items (so it will be easy to fill first tab quite fast). There will be also info if particular item is droped by certain mob.
-------------------------
Ending:
I hope that some people might be interested and will subscribe here .
Thank you for attention.
Falagor
when i will be adding some new information here - for some time it will have different color (green or blue - alternately) so people who subscribed can easily see new information added.
-------------------------
Introduction:
Hello - seeing how many people keep track of their returns here on PCF i have decided i will share my own log. I already have lots of data on my hard drive but i needed something fresh so i have decided to use google docs to share data - so this is going to be new log starting from today (but i already have experience in keeping track of returns so it will not be newbie log).
I am not sure what forum category this should go because i will keep 3 different types of logs (mayby 4):
- TT return only - overall on all activities (clear and simple log) (note: added expected minimum profit after markup here too)
- TT and markup returns on crafting choosen items (more complex log)
- TT and markup returns on mining (also more complex)
- mayby TT and markup retuns on hunting - but i doubt this. Hunting TT returns will be already included in first log and obtaining exact markup info on hunting loot is much harder than on crafting or mining. So i probably will not start this one. (note: i made the sheet for this too )
-------------------------
Links:
Here is my TT overal returns log: <click>
Here is my Crafting log: <click>
Here is my Mining log: <click>
Here is my Huting log: <click>
-------------------------
Goals:
TT overal returns log:
I want to keep exact track of my TT spendings vs TT gains. I am really accurate at keeping this. I want to really convince myself that i am getting somewhere between 90-95% TT returns and also show/prove this to others. Later when more data is collected, log may evole a bit - i already have in mind something like "hof/global predicter" which would be based on what is the state of my personal lootpool (but thats future). Also probably summarise for each month will appear too.
What i will keep track of:
- All hunting runs.
- All mining runs.
- All crafting runs.
- Significant form of wasting my armor or healing (i.e. just sweating and healing myself).
- Any tiering costs.
- Significant refiner cost.
- Auction fees (i would most likely forgot updating those anyway becasue i trade a lot).
- Any form of small tests or something wierd that may happen, that will cost less than 1ped (i.e. testing decay on items, random hits when i was wearing armor, very small refiner costs etc.) - this will not have much impact on my TT returns so it can be ignored.
- Any markup of course becasue this one is only TT log .
- Any rewards (i.e. winning on events).
- Any fuel costs.
Added "Minimal profit after markup" column - this is to show my estimated minimal profit/loss i get on my activities. It is way lower than my actuall profit i make because it is rather underestimated and i do not include any extra actions i take to increase my pedcard (like trading, sweating or selling skills). This information is extra and not main focus of this log (but it is fun to watch minimal profit/loss i get).
Activities can overlap and the moment i put info in this log is when i end run. I.e. i can start 1k drops ore+enm run and after 400 drops make break. Then go on 2k peds hunting run that will be finsihed (at this moment info is put into the log). And later make last 600 drops (this will be moment when i put info on mining into the log).
Crafting log:
It will contain few chosen items (mainly components) that i might be crafting on regular basis espetially when market values are right. Log will be very accurate. It will contain nr of clicks, success rate, markup on materials and products, exact nr of items looted and many more.
Basicly this info may be interesting for advanced logers . Notice that this log will not contain ALL crafting runs - if i will craft something that i just want to try - it probably will not appear here (but definetly will appear in overal TT log).
Information on each item will be kept in different sheets (tabs at the top).
Info about yellow-orange colors of title on the column, in the log: yellow - something i type in before/after run, orange - something that is counted automatically (this form of colouring helps me out).
Sadly there is some sort of problem with borders in google sheets: when i add borders or "freeze line" i suddenly get lots of lags when editing and also published version gets really scrambled. I know that in this log borders would help a lot to make this log clear but for now it is not possible to use them (if you know how to solve this problem - please PM me or post here).
Mining log:
It will contain all my mining runs done. There will be four sheets (tabs at the top):
- summary - will contain summary of all runs, TT cost and TT and markup returns.
- ore/enmatter/treasure sheets - all ores/enmatters/treasures that i got during each run and markup on them on that day (i take lowest BO on auction on Calypso as markup on that day).
For personal reason i will not reveal what finder i am using. Also to "hide" this information but keep transparent my total TT cost i will have "Finder + Excavators + Enhancers cost" column. So clever and curious person will not be able to find out what finder i was using based on nr of drops. The reason why i hide this is becasue i want to keep some of my mining secrets. And obviously key to profit is: timing + finder + area. Since pro miners will easily see what area i was mining at then only info i can (and want to) hide is finder .
Hunting log:
It will contain all items looted with quantity and markup. Cost and returns. Also second tab will contain all items looted while filling this log and TT value of single items (so it will be easy to fill first tab quite fast). There will be also info if particular item is droped by certain mob.
-------------------------
Ending:
I hope that some people might be interested and will subscribe here .
Thank you for attention.
Falagor
Last edited: