Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Archive:Mining operations worksheet: Difference between revisions

From EVE University Wiki
Removed broken spreadsheet link. Redirected capsuleers to campus management.
m Minor spelling correction
Line 40: Line 40:
Here we'll explain what you'll want to do during the operation.   
Here we'll explain what you'll want to do during the operation.   


Transparency is good in [[Mining_Op|shared-can mining operations]] as it lets people verify that they were clocked in/out correctly and that they are receiving the proper share.  Therefore, if you are using Google Docs, sharing the operation worksheet in read-only mode to the rest of the fleet is recommended.  This can be done by clicking on the "Share" button in the upper right, choosing "Get link to share".  The link should be set so that everyone can view the spreadsheet without needing to sign into Google.  The URL should be copy/pasted into fleet-chat so that others can monitor the spreadsheet for that operation.  
Transparency is good in [[Mining_Op|shared-can mining operations]] as it lets people verify that they were clocked in/out correctly and that they are receiving the proper share.  Therefore, if you are using Google Docs, sharing the operation worksheet in read-only mode to the rest of the fleet is recommended.  This can be done by clicking on the "Share" button in the upper right, choosing "Get link to share".  The link should be set so that everyone can view the spreadsheet without needing to sign in to Google.  The URL should be copy/pasted into fleet-chat so that others can monitor the spreadsheet for that operation.  


If you have a second person in the fleet that you trust, who also has a Google account, you may wish to give them edit rights.  That will provide a second set of hands to keep track of things in larger operations.
If you have a second person in the fleet that you trust, who also has a Google account, you may wish to give them edit rights.  That will provide a second set of hands to keep track of things in larger operations.
Line 51: Line 51:
'''Before adjusting weights''', you must get everyone in the fleet to agree with the system and say so in fleet chat.  The vast majority of IVY fleets are run on a "time served, equal shares per person" basis with no variation based on ship type (see also [[Mining_Op|Running a Mining Op]]).  EVE University is first and foremost a teaching organization and shared-can ops are a good way to give younger pilots a helping hand.
'''Before adjusting weights''', you must get everyone in the fleet to agree with the system and say so in fleet chat.  The vast majority of IVY fleets are run on a "time served, equal shares per person" basis with no variation based on ship type (see also [[Mining_Op|Running a Mining Op]]).  EVE University is first and foremost a teaching organization and shared-can ops are a good way to give younger pilots a helping hand.


The "Time Clock" columns allow you to clock a single person in/out up to two times.  So if someone needs to leave for 30 minutes, you can clock them out, then clock them back in for a second session.  Alternatively, you can enter time in the "Dock" column which will be subtracted from the person's total participation time.  The "Hours Worked" will reflect wall clock time that the person spent mining / hauling, while the "Weight Time" will reflect their weighted time share.
The "Time Clock" columns allow you to clock a single person in/out up to two times.  So if someone needs to leave for 30 minutes, you can clock them out, then clock them back in for a second session.  Alternatively, you can enter time in the "Dock" column which will be subtracted from the person's total participation time.  The "Hours Worked" will reflect wall clock time that the person spent mining / hauling, while the "Weight Time" will reflect their weighted timeshare.


Fleet members should announce in fleet chat when they start/stop actively participating in the mining operation.  This will help you reconstruct who joined/left and when if there are questions about things after the operation has finished.  It is also strongly suggested that you take periodic (every 10-20 minutes) screenshots of the Local or Overview window to keep track of who was around at a particular time.
Fleet members should announce in fleet chat when they start/stop actively participating in the mining operation.  This will help you reconstruct who joined/left and when if there are questions about things after the operation has finished.  It is also strongly suggested that you take periodic (every 10-20 minutes) screenshots of the Local or Overview window to keep track of who was around at a particular time.


In order to get accurate estimates, you should periodically update the "Estimated End Time" value in the top row to reflect when you think the operation will end.  If it is a long running operation, just keep pushing the estimated end time out by 30-60 minutes at a time.
In order to get accurate estimates, you should periodically update the "Estimated End Time" value in the top row to reflect when you think the operation will end.  If it is a long-running operation, just keep pushing the estimated end time out by 30-60 minutes at a time.


Note: The "Estimated Payout (ISK)" column is only accurate if you have updated the estimated end-time for the operation and have also been updating the "Inventory" sheet as ore is hauled to the station.
Note: The "Estimated Payout (ISK)" column is only accurate if you have updated the estimated end-time for the operation and have also been updating the "Inventory" sheet as ore is hauled to the station.
Line 69: Line 69:


===Other Tasks===
===Other Tasks===
From a paperwork standpoint, there's not much else to do other then tracking members, tracking ore, and updating market values.  Towards the end of the operation, you might wish to solicit requests for mineral or storyline ore payouts which get entered on the "Participant" sheet.
From a paperwork standpoint, there's not much else to do other than tracking members, tracking ore, and updating market values.  Towards the end of the operation, you might wish to solicit requests for mineral or storyline ore payouts which get entered on the "Participant" sheet.


==Post-Operation==
==Post-Operation==
Line 100: Line 100:
* Always copy/paste amounts from the spreadsheet to the EVE client
* Always copy/paste amounts from the spreadsheet to the EVE client


Start by distributing storyline ore and mineral payouts.  You can do this either via trade in stations, or by creating an "item exchange" contract.  Never type names or amounts, always copy/paste from the appropriate cell in the mining op spreadsheet.  Mineral/Ore payout totals are on the "Participation" sheet.  As you pay people, enter "o" or "m" in the "Paid?" column to keep track of who you have paid.
Start by distributing storyline ore and mineral payouts.  You can do this either via trade in stations, or by creating an "item exchange" contract.  Never type names or amounts, always copy/paste from the appropriate cell in the mining op spreadsheet.  Mineral/Ore payout totals are on the "Participation" sheet.  As you pay people, enter "o" or "m" in the "Paid?" column to keep track of whom you have paid.


Then repeat the process for the ISK payouts.  Copy the person's name into the clipboard, open up People & Places and search for "Character (exact)".  Paste the member's name into the search box.  When the name shows up, right-click and "Show Info" to double-check the member, then right-click and use "Give Money".  For the amount, go to the "Participation" sheet and copy the amount from the "Participation ISK Payout" column.  Paste this value into the amount field and enter "(systemname) mining op" in the comment field.
Then repeat the process for the ISK payouts.  Copy the person's name into the clipboard, open up People & Places and search for "Character (exact)".  Paste the member's name into the search box.  When the name shows up, right-click and "Show Info" to double-check the member, then right-click and use "Give Money".  For the amount, go to the "Participation" sheet and copy the amount from the "Participation ISK Payout" column.  Paste this value into the amount field and enter "(systemname) mining op" in the comment field.