Question: Data collection

What data do you collect and why?

I spend all day working with excel at work for trending and starting planning a spread sheet for EU. However I am not to sure at this point what data is actually valuable to collect for mining. Things seem ridiculously random so I am not sure if the data collected would really mean much.

On one hand I could setup a complex spreadsheet coving every detail of mining, on the other hand I could create a simple one just coving how much PED I spent and how much is on the PED card at the end of the day.

hit rate per run which gets put into an average over all my runs(total hits/claims found)
total drops which gets put into an average over all my runs standard
total decay which gets put into an average over all my runs standard
mini rate per run as well as a average mini rate over all my runs (aka rare finds and multipliers)
mark up after the run which i use to make another spreadsheet that calculates the average mark up of the area
*i used to calculate ore % of the area till i found out about lbml*
i also keep a hypothetical mark up of each area in eu based on the find rates according to lbml and their current mu

Thanks for the reply. The drops and hit rate I was not going to track because it seems to random to get any conclusive result from the data. I will rethink that. Every thing else is in the design. I was thinking about putting in location of the drop spot when it hits and going back to the same spot at set intervals and see if I can find spots that get hits more often than others and concentrate on those spots.

I guess the basic ones are hitrate ,return and resource types.
But in the end data collection takes time and should serve a purpose so i guess resource type is the most usefull as the other ones are sort of out of your control or lets say distributed evenly around the magical 90% ( although I have this hunch that fertilized land areas give better hitrate ).
That being said if i had time and money i would consider testing my favorite areas with a few different finders with different depths to get the distribution of ores vs finder as with the rapidly fluctuating resource prices a f211 might well give you more markup than a tk120, e.g. when belkar becomes more valuable than duru or vice versa something like that, it could be cool to have this data, you'd start your day with updating your excell file with the daily markup for resources and see in which area with which finder you have the highest supposed markup

For the last 1357 days I have only been collecting:

Inv Value
Ped Value
MU Value - Based on another worksheet I update maybe 4 times a year
Deposit Value
Total Skills
ESI needed - skills (all based on entropedia)
ESI Cost - Skills
Chipsized - Skills
Market Value - Skills
Net Value - Skills

Second worksheet for 1258 days I keep all my skills

I spend 80 % of my working day manipulating data in excel spreadsheets. When I get home and have fun I have no desire to spend that time recording the data from my "fun" on an Excel Spreadsheet, however whatever floats your boat

moondog said:

I spend 80 % of my working day manipulating data in excel spreadsheets. When I get home and have fun I have no desire to spend that time recording the data from my "fun" on an Excel Spreadsheet, however whatever floats your boat

Click to expand...

I hear ya. I am a documentation specialist at work. All day reviewing cGMP documentaion, creating and updating spread sheets for trending. It is definatly not motivating me to do a complex spread sheet. I can hardly stay awake mining as it is. Keep falling asleep ans waking up at a revival terminal. Definarly the least exciting game I ever played and a play a lot of them.

I did not think about tracking skills. I keep forgetting you can sell them. I don't plan on chipping out though.

Right know I think I am just going to keep track of PED in and PED out and try not to fall asleep between dropping probes.

Nissa said:

I hear ya. I am a documentation specialist at work. All day reviewing cGMP documentaion, creating and updating spread sheets for trending. It is definatly not motivating me to do a complex spread sheet. I can hardly stay awake mining as it is. Keep falling asleep ans waking up at a revival terminal. Definarly the least exciting game I ever played and a play a lot of them.

I did not think about tracking skills. I keep forgetting you can sell them. I don't plan on chipping out though.

Right know I think I am just going to keep track of PED in and PED out and try not to fall asleep between dropping probes.

Click to expand...

1. Get a vehicle
2. Track resources
3. Ped in/ped out

Should be enough.