User Tools
training:guides:industry_spreadsheets
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
training:guides:industry_spreadsheets [2019/04/27 19:08] Sidoen |
training:guides:industry_spreadsheets [2019/04/27 19:10] (current) Sidoen [Pulling data] |
||
|---|---|---|---|
| Line 25: | Line 25: | ||
| To pull the data as shown above I use a simple tool from evepraisal.com that I will link here. You simply install it and you can use it as an add on in your google sheets; you can turn this on by going to Add-ons at the top of the sheet and clicking manage add-ons, this will pull up a box and you should see the add-on there, click manage and then ‘use in this document’ as shown below. | To pull the data as shown above I use a simple tool from evepraisal.com that I will link here. You simply install it and you can use it as an add on in your google sheets; you can turn this on by going to Add-ons at the top of the sheet and clicking manage add-ons, this will pull up a box and you should see the add-on there, click manage and then ‘use in this document’ as shown below. | ||
| - | {{:training:guides:spreadsheets_online_003.png?nolink&600|}} | + | {{:training:guides:spreadsheets_online_003.png?nolink&800|}} |
| This adds a simple formula that will save you hours of frustration and hair pulling and allow you to pull data from evepraisal.com directly, checking the price of anything you want in your spreadsheet… given it’s spelt correctly, the formula is as shown =EVEPRAISAL_ITEM(A1), | This adds a simple formula that will save you hours of frustration and hair pulling and allow you to pull data from evepraisal.com directly, checking the price of anything you want in your spreadsheet… given it’s spelt correctly, the formula is as shown =EVEPRAISAL_ITEM(A1), | ||
training/guides/industry_spreadsheets.1556392133.txt.gz · Last modified: 2019/04/27 19:08 by Sidoen