# Gdoc or Exсel ?!

**URL:** <https://forums.eveonline.com/t/gdoc-or-ex-el/298052>\
**Category:** Mining & Extraction\
**Created:** [March 1, 2021, 10:26am UTC](https://forums.eveonline.com/t/gdoc-or-ex-el/298052 "2021-03-01T10:26:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Optical\_lines](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/optical_lines/32/259094_2.png) [@Optical\_lines](https://forums.eveonline.com/u/Optical_lines)\
**Post date:** [March 1, 2021, 10:26am UTC](https://forums.eveonline.com/t/gdoc-or-ex-el/298052/1 "2021-03-01T10:26:51Z")

</div>

Hello everyone. I apologize for my English, I am writing through a translator. The question is, I want me to have information on ore, price, quantity of ore mined and prices in one table. Is it possible to do this? I visited a couple of similar topics on the Internet, but alas, all links and scripts do not work. Also in the future I plan to make a production counting page in the same table. Who has the latest information, I will be grateful!

---

<div class="post-metadata">

**Author:** ![Shipwreck\_Jones](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/shipwreck_jones/32/274382_2.png) [@Shipwreck\_Jones](https://forums.eveonline.com/u/Shipwreck_Jones)\
**Post date:** [March 2, 2021, 6:44am UTC](https://forums.eveonline.com/t/gdoc-or-ex-el/298052/2 "2021-03-02T06:44:05Z")

</div>

Googledocs is free, and makes sharing easy. However, I’m already used to excel, so that’s what I like using. I do remember finding that I couldn’t do something in google docs once because it lacked the functionality, but for the most part, they should both have everything you need.

**Here’s how to import prices for excel.**

> [@Microsoft Excel Question](https://forums.eveonline.com/t/microsoft-excel-question/289723/3):
>
> Ugh, this is easy to do and difficult to explain. But, I guess I’ll try. Anyway, here are instructions for excel. 
> 
> > **Screenshot**
> >
> > \<a class="lightbox" href="https://global.discourse-cdn.com/eveonline/original/3X/a/7/a7e98a9e7891820bb448383b4aef111c4a8835fb.png" data-download-href="/uploads/short-url/nXq64fqbBVNhCEjYyP5GBEnmK9l.png?dl=1" title="image" rel="noopener nofollow ugc"\>[image]\</a\>
> 
> To make life easier, you’ll want to import a typ…

Here are some additional things that helped me to make my industry spreadsheet. Perhaps you’ll find them useful as well:

**Dropdown boxes and Vlookup**  
You can create drop down boxes with the “Data Validation” tool, and the “vlookup” function will return data associated with another cell.

So, I have one excel tab set up to fetch prices. Then I have a tab that I use to calculate material requirements, total manufacturing cost, and time to build. Rather than manually typing in each raw material, I create an item template with drop down boxes. Then, I select the build materials from the drop down box, and the cell to the right automatically updates the price based upon the tab that fetches prices.

Drop down box in action:

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/3/8/c/38c3ba25eef00bbe7d3a9a3899feb934c7d80f39.png)

VLookUp function is used to fetch the corresponding price from my “Prices” tab, which fetches prices from Eve Marketeer.

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/1/c/e/1ce5bf77095b23ac8e30534a3733dcb8ca867092.png)

**Data Grouping**  
Oh, and I use Data (tab) → Group (button) to help keep things tidy.

**Conclusion**  
There are already plenty of tutorials on using data validation, vlookup, and data grouping, so do a google search if you want to know more. Unfortunately, I’m not sure how you’d get quantity of ore mined. You’d have to ask someone else about that.

---

<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:** [March 2, 2021, 7:35pm UTC](https://forums.eveonline.com/t/gdoc-or-ex-el/298052/3 "2021-03-02T19:35:54Z")

</div>

I have used google sheets for years, @Blacksmoke16 has a very good tool for importing ESI stuffs.  
Two of my many sheets.

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/b/c/e/bcecc0c1a77410553ba460fe3a235b6d20a0f2c5.png)

---

<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:** [May 31, 2021, 7:36pm UTC](https://forums.eveonline.com/t/gdoc-or-ex-el/298052/4 "2021-05-31T19:36:26Z")

</div>

Closed on May 31, 2021, 7:36pm UTC

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