# \[Service\] Dynamic Spreadsheets

**URL:** <https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014>\
**Category:** Services\
**Created:** [August 14, 2018, 12:14pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014 "2018-08-14T12:14:50Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 14, 2018, 12:14pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/1 "2018-08-14T12:14:51Z")

</div>

### WTS Custom spreadsheets: MS Excel sheet or Google Sheet with Market data

## ⚙ Services

* * *

I want to offer my services in the creation and update of all varieties of custom spreadsheets.  
I have experience with implementation of market data and making spreadsheets dynamically updating when things are changed.

## Type of Spreadsheet:

* * *

- Simple Market (Praisal)
- Trading
- Industrial Production
- Planetary Production
- and more…

### Price

* * *

Price depends on how extensive the requested job is and the time it takes to complete, on average the price starts at around 500m ISK and up, of course there is room for negotiation.  
Payment is divided over 2 times; first half is payed when the job request is initiated and last half is payed upon delivery.

### Samples

* * *

- [Upwell Structure(s) Production](https://docs.google.com/spreadsheets/d/1IXl_-9G7LB8UFb54FX--B9TAwRmDNOmWu50kcAlll_4/edit?usp=sharing)  
 ![de8bc299016de3459e2b5865d377b758](https://global.discourse-cdn.com/eveonline/original/3X/a/a/aa5d3413312e4a3711ff3c764359861d206c7d86.png)

- **Market Trading Spreadsheet**  
 ![7a0f7eeb2030b986dac40b55b75aca36](https://global.discourse-cdn.com/eveonline/original/3X/3/8/38821af397abd84ed0c55cdcd4147c3f9e9cec63.png)

- **Production Cost vs Market Trade Spreadsheet** - _🛠 work in progress_  
 ![0ee47282a1d83af179652f9181f120d0](https://global.discourse-cdn.com/eveonline/original/3X/2/3/2380953c68d45f34a17b17799491351328c20af1.png)

### ❕ Note(s)

* * *

- For security reasons above all else, I do not work with ESI, however much I would like to offer this. As ESI requires access to your, or giving access to my own, ClientID and SecretID for your app on [https://developers.eveonline.com](https://developers.eveonline.com), which should not be shared with anyone.

**If you are interested, please send me an eve mail or find me, Evaldia or Dyexz in the channel: _[Services] ALCII Spreadsheet_**

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 14, 2018, 12:39pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/2 "2018-08-14T12:39:10Z")

</div>

### Changes/Updates

* * *

23.08.2018:

- [Upwell Structure(s) Production](https://docs.google.com/spreadsheets/d/1IXl_-9G7LB8UFb54FX--B9TAwRmDNOmWu50kcAlll_4/edit?usp=sharing)
  - Added picture.
  - Added functionally of choosing Production Station Type, choosing between: NPC Station, Raitaru, Azbel or Sotiyo with or without T1/T2 Rigs.
  - Added funtionally of choosing type of Sec Space. Highsec, Lowsec, Nullsec or WH.
  - Updated all formulas to accommodate the above mentioned features.
  - Fixed some errors.

20.08.2018:

- Added 3 examples of spreadsheets:
  - Spreadsheet calculating and viewing the cost to produce an Upwell Structure; Astrahus, Fortizar, Keepstar, Raitaru, Azbel, Sotiyo, Athanor or Tatara.
  - Basic spreadsheet for praisal of Ships, Modules and or Item found or produced in New Eden
  - Production Cost vs Market price Spreadsheet

---

<div class="post-metadata">

**Author:** ![Reileen\_Kawahara](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/reileen_kawahara/32/399303_2.png) [@Reileen\_Kawahara](https://forums.eveonline.com/u/Reileen_Kawahara)\
**Post date:** [August 15, 2018, 6:08am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/3 "2018-08-15T06:08:04Z")

</div>

Do you have any sample sheets you could show us?

---

<div class="post-metadata">

**Author:** ![Qia\_Kare](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/qia_kare/32/279281_2.png) [@Qia\_Kare](https://forums.eveonline.com/u/Qia_Kare)\
**Post date:** [August 15, 2018, 6:14am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/4 "2018-08-15T06:14:11Z")

</div>

Forgive my ignorance, but is it not possible for the sheet to pull the client ID and secret ID from cells filled out by the user?

Such sheets would not be useful for multiple users because of the aforementioned security breach, but a user entering it manually for purely personal use should be OK.

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 15, 2018, 11:01am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/5 "2018-08-15T11:01:36Z")

</div>

> [@Qia\_Kare](#):
>
> Forgive my ignorance, but is it not possible for the sheet to pull the client ID and secret ID from cells filled out by the user?

No, well maybe, in order to use ESI you have to be using scripts. Any script used by a sheet will be fully visible (if they enter the Script Editor) to the ones with access to the sheet.

> [@Reileen\_Kawahara](#):
>
> Do you have any sample sheets you could show us?

Updated the OP with examples.

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 20, 2018, 6:53pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/7 "2018-08-20T18:53:39Z")

</div>

Still very much looking and open for business, if you have an idea and you think I may be able to help, 📨 send an evemail 📨

---

<div class="post-metadata">

**Author:** ![Reileen\_Kawahara](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/reileen_kawahara/32/399303_2.png) [@Reileen\_Kawahara](https://forums.eveonline.com/u/Reileen_Kawahara)\
**Post date:** [August 20, 2018, 7:16pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/8 "2018-08-20T19:16:26Z")

</div>

What does your Industrial Production have?

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 20, 2018, 10:51pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/9 "2018-08-20T22:51:54Z")

</div>

> [@Reileen\_Kawahara](#):
>
> What does your Industrial Production have?

Depends on what you want/need, can be simple information on what sort of materials you need to produce various items, like my _Upwell Structure - Production cost_ spreadsheet which is under Samples in my OP. Or more advanced if need be, hit me up with your idea of what you want/need and we can talk about it.

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 23, 2018, 8:19pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/10 "2018-08-23T20:19:02Z")

</div>

Updated my Upwell Structure(s) Production spreadsheet, for more details check [here](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/2).

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 26, 2018, 9:58pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/11 "2018-08-26T21:58:23Z")

</div>

Still very much open for business!

---

<div class="post-metadata">

**Author:** ![Krysenth](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/krysenth/32/58194_2.png) [@Krysenth](https://forums.eveonline.com/u/Krysenth)\
**Post date:** [August 27, 2018, 8:56am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/12 "2018-08-27T08:56:37Z")

</div>

> [@Elathy\_Maricadie](#):
>
> For security reasons above all else, I do not work with ESI, however much I would like to offer this. As ESI requires access to your, or giving access to my own, ClientID and SecretID for your app on [https://developers.eveonline.com](https://developers.eveonline.com), which should not be shared with anyone.

This is partially false. You only need such if you’re attempting to use authenticated calls. Such as a character’s personal orders. Getting market prices, market orders (as a whole), etc, you do not.

---

<div class="post-metadata">

**Author:** ![RocknRolla94](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/rocknrolla94/32/457947_2.png) [@RocknRolla94](https://forums.eveonline.com/u/RocknRolla94)\
**Post date:** [August 30, 2018, 10:46am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/13 "2018-08-30T10:46:09Z")

</div>

Great service I can’t recommend enough. +1 🙂

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [August 31, 2018, 12:56am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/14 "2018-08-31T00:56:16Z")

</div>

> [@Krysenth](#):
>
> You only need such if you’re attempting to use authenticated calls.

This is exactly what I will need it for, making calls to get data on assets, active industry jobs, skills and level etc., sure much of this can be entered manually but wouldn’t you much rather be able to do that by the push of a button, so to speak.

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [September 5, 2018, 1:06pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/15 "2018-09-05T13:06:06Z")

</div>

Still offering my services to anyone interested, all you need to do is send an evemail and we take it from there 😄

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [September 11, 2018, 6:41pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/16 "2018-09-11T18:41:58Z")

</div>

Recent activity:

- 2 Jobs completed (in last week)
- 1 more still being worked on.

Accepting project proposals; if you have an idea, I’ll gladly take a look at and give an estimated price.

---

<div class="post-metadata">

**Author:** ![Tzar\_Sinak](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tzar_sinak/32/39415_2.png) [@Tzar\_Sinak](https://forums.eveonline.com/u/Tzar_Sinak)\
**Post date:** [September 11, 2018, 7:51pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/17 "2018-09-11T19:51:09Z")

</div>

I’ve had a spreadsheet I needed updating. I am very pleased with the swift work Elathy Maricadie was able to do at a very reasonable price.

I recommend this service!

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [September 29, 2018, 12:31pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/18 "2018-09-29T12:31:01Z")

</div>

Still in business 😉

---

<div class="post-metadata">

**Author:** ![Stilgar\_Teg](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/stilgar_teg/32/210369_2.png) [@Stilgar\_Teg](https://forums.eveonline.com/u/Stilgar_Teg)\
**Post date:** [September 30, 2018, 12:47am UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/19 "2018-09-30T00:47:10Z")

</div>

Looking for a Capital/T2 Production Spreadsheet…anything else you got to offer me?.

Thx

---

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/516513_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [October 3, 2018, 2:05pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/20 "2018-10-03T14:05:08Z")

</div>

> [@Stilgar\_Teg](#):
>
> Looking for a Capital/T2 Production Spreadsheet

I can certainly do a Capital production spreadsheet for you. T2 production spreadsheet is much more complicated and it will take some time. Do you have specific T2’s in mind or are you looking at all of them?

---

<div class="post-metadata">

**Author:** ![Avallah](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/avallah/32/242792_2.png) [@Avallah](https://forums.eveonline.com/u/Avallah)\
**Post date:** [October 3, 2018, 5:00pm UTC](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014/21 "2018-10-03T17:00:28Z")

</div>

I have few Excel files and wonder how import stuff like prices from Jita. Can you share how to connect those files or where to find any details about it?

[Next page](https://forums.eveonline.com/t/service-dynamic-spreadsheets/98014.md?page=2)
