Pvme Spreadsheet

Introduction

The PVMe Spreadsheet is a Google Sheet document that is used to store dynamic information for use in guides. This includes things like prices of items, values of invention components, calculating boss revenue, etc. which can change over time. This guide is a brief overview of the sheet, and how you can use data from it in your guides.

​

The spreadsheet can be found at the following link.

Note: Data in guides is only pulled from the master copy of the sheet. To modify existing data, or add new data, use Guide media upload and request (external Discord).

​

PvME Spreadsheet Layout

⬥ When you open the spreadsheet, you will see the following sheets at the bottom:

⬥ These tabs correspond to different categories of items/etc. within the game for data is present/calculated for use in the guides:

‎ ‎ ‎ ‎• Prices: sheet that contains and periodically fetches/updates GE prices of items.

‎ ‎ ‎ ‎• Bosses: used to calculate earnings for Boss Revenue.

‎ ‎ ‎ ‎• Slayer: used to calculate earnings for Slayer guides.

‎ ‎ ‎ ‎• Perks: used to calculate cost of Invention components and perks for Perks.

‎ ‎ ‎ ‎• Unlocks: prices of unlockable items found in Permanent Unlocks.

‎ ‎ ‎ ‎• Miscellaneous: some misc. prices and calculations.

‎ ‎ ‎ ‎• Consumables: prices of consumable items found in Consumables.

‎ ‎ ‎ ‎• Mastery: outdated sheet, kept for historic/reference purposes.

⬥ To access a specific piece of information, only two things are required: the sheet name and named range.

​

Using Spreadsheet Data In Guides

⬥ Using data from the spreadsheet in a guide is very straightforward.

⬥ Values from the sheet can be accessed using the following command: data_pvme:<sheet>_<namedrange>, replacing the contents of <sheet> ‎and <namedrange> ‎with the sheet name and named range respectively.

⬥ When posted (by the PvME Bot), the command text will get replaced by the value present in that cell.

​

⬥ For example, the following sentence might be in a guide:

Greater Chain <:gchain:1257440278512537740> is a very powerful ability, but is also quite expensive, costing <:coins:698816156961603654> $data_pvmе:unlock_gchain$.

⬥ When posted by the bot, it will look like the following:

Note: The command syntax can also be found in the Commands dropdown menu in the web guide editor tool.

​

Requesting Changes/Additions

⬥ Anyone can make a copy of the sheet for personal use, but only data from the master sheet will be referenced by the bot.

⬥ To request any changes or additions to the sheet, use the Guide media upload and request (external Discord) channel.

​