# Ore Buyback Spreadsheet

**URL:** <https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918>\
**Category:** Mining & Extraction\
**Created:** [November 10, 2017, 6:46pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918 "2017-11-10T18:46:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cloud\_Puffs](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/cloud_puffs/32/418099_2.png) [@Cloud\_Puffs](https://forums.eveonline.com/u/Cloud_Puffs)\
**Post date:** [November 10, 2017, 6:46pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/1 "2017-11-10T18:46:19Z")

</div>

Does anyone know how to create one. I don’t want one that is already made, would love some help on how to create my own in google docs.

Thanks,  
o/

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [November 11, 2017, 12:15pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/2 "2017-11-11T12:15:00Z")

</div>

Sure I may be able to help you out 😄

First of all you will need to think about what sort of information you will need for the spreadsheet, typing it in manually or make it collect the info with API or from other website.

The information (Columns) needed may be :

- List of a Ores, Compressed and maybe even uncompressed versions.
- Price for each type of Ore.
- Column for user input.
- Finally column with the calculated price (by formula)
  - number of Units of Ore \* price ( Cell1 \* Cell2 )

- Cell with the Grand Total (SUM) of prices (again formula).
  - =SUM(Range)

Finally you want to protect your spreadsheet from being edited, except the Cells that is for ‘User Input’

---

<div class="post-metadata">

**Author:** ![Cloud\_Puffs](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/cloud_puffs/32/418099_2.png) [@Cloud\_Puffs](https://forums.eveonline.com/u/Cloud_Puffs)\
**Post date:** [November 11, 2017, 12:28pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/3 "2017-11-11T12:28:02Z")

</div>

Awesome. That is what i want to do. I have plenty of experience in making spread sheets, but absolutely none in using API to pull data directly to a spreadsheet. That is what i need the most help with.

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [November 11, 2017, 3:52pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/4 "2017-11-11T15:52:28Z")

</div>

Unfortunately I only have experience with EVE-Central’s API, which is no-longer in service and no press-release of when it will be back up, If you can find another source for importing you data (preferably similar to eve-central) if I’m to help with that. As options there are the official:

- CREST (Documentation [here](http://eveonline-third-party-documentation.readthedocs.io/en/latest/crest/))
- ESI (Documentation [here](http://eveonline-third-party-documentation.readthedocs.io/en/latest/esi/index.html))

---

<div class="post-metadata">

**Author:** ![CowRocket\_Void](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/cowrocket_void/32/189525_2.png) [@CowRocket\_Void](https://forums.eveonline.com/u/CowRocket_Void)\
**Post date:** [November 11, 2017, 10:16pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/5 "2017-11-11T22:16:43Z")

</div>

I suggest you seek the wisdom of FuzzySteve ([https://github.com/fuzzysteve/eve-googledocs-script](https://github.com/fuzzysteve/eve-googledocs-script)), and have the data pulled into one sheet to be referenced by another.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [February 9, 2018, 10:16pm UTC](https://forums.eveonline.com/t/ore-buyback-spreadsheet/37918/6 "2018-02-09T22:16:45Z")

</div>

Closed on February 9, 2018, 10:16pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
