More actions
→Submit the spreadsheet: Added additional step 2 text and inserted step 3, to provide methods to ensure the Finalize Buyback script has successfully completed. |
|||
| Line 85: | Line 85: | ||
Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below: | Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below: | ||
# Change to the '''Inventory''' tab. | # Change to the '''Inventory''' tab. | ||
# Select "Finalize Buyback" in the Buyback Menu. | # Select "Finalize Buyback" in the Buyback Menu. (Because this step uses a script, Google docs security settings may ask you to authorize the script to run. Click the “Advanced” link on the pop up to enable the option to run the script, if this occurs). | ||
# Ensure the Buyback script has finalized prices. On the Inventory tab, the cells in Column F will contain a formula “=Market!Fx” (as seen in the formula bar at the top when selecting a cell in column F), if the Finalize Buyback script has not been applied - run the script again. If the script has successfully completed, the formula bar will show a numeric value rather than a formula. | |||
# Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then "Get shareable link"). | # Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then "Get shareable link"). | ||
# Create a contract to <font color="white">'''Ivy League AMC Holdings'''</font> with the applicable ore, ice and gas. | # Create a contract to <font color="white">'''Ivy League AMC Holdings'''</font> with the applicable ore, ice and gas. | ||
# There is no 6. | |||
# Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet. | # Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet. | ||
# Paste the spreadsheet key in the '''Description''' field of the contract: | # Paste the spreadsheet key in the '''Description''' field of the contract: | ||
#: (The field located between ""/d/*****/edit#"". See the image below.) | #: (The field located between ""/d/*****/edit#"". See the image below.) | ||