![]() If you believe you have accidentally edited a cell, and aren't sure how to fix it, simply delete the sheet and make a new copy from the original. Wait a few minutes for GW2Spidy to resolve the error. If your spreadsheet returns "#ERROR!", it's usually because the sheet can't pull the price of one or more items from GW2Spidy. Since you cannot equip more than one glyph per tool, if you have multiple glyphs selected in the same tool, the sheet will display "!!" in a red cell below the tool that has multiple glyphs. Cells in which you have selected any nonzero value are green. Cells in which you have selected 0 are yellow. Cells in which you have not selected a value are colored red. This is listed in gold, so a decimal such as "0.1234" means "0 gold, 12 silver, 34 copper."įor easy identification, the input cells are colored based on the data you have chosen. The sheet will then return the total average value of your glyph combination from your home instance each day. For the Candy Corn node, select 2 if you have the Greater version of the node otherwise, select 1 for the normal version, and 0 if you don't have either version. For the Black Lion Garden Plot, select the number of plots you own. ![]() Select 1 if you have the option, and select 0 if you do not. The input cells have a dropdown menu with a set of numbers, most commonly 0 and 1. In order to interact with the spreadsheet, first go to "File" and select "Make a copy." This will save a version of this spreadsheet on your personal Google Sheets account, and give you permission to change the values in the cells. The new gathering glyphs have me interested in which combination I should use to get the most out of my home instance nodes, which is the majority of the nodes I encounter on a daily basis.īut instead of making the spreadsheet calculate it for my home instance (or exclusive to anyone with a complete home instance), I decided to make this version more adaptable to any combination of nodes, so other people can use it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |