These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Sell Orders

 
  • Topic is locked indefinitely.
 

[Service] EVE CorpShop / CorporationShop - incl. FREE Hosting
Author
Previous Topic Next Topic
Harry Sullivan
Caldari Provisions
Caldari State
#1 - 2014-04-10 14:30:26 UTC  |  Edited by: Harry Sullivan
EVE CorpShop / Corporation Shop


Decided to slim down my production line and sell this Character as preparation for the Industry changes in the Summer Expansion.

Offer no longer available.
Harry Sullivan
Caldari Provisions
Caldari State
#2 - 2014-04-10 14:30:39 UTC  |  Edited by: Harry Sullivan
Updates:

v0.2
- Added remote price check so you can check if you have to update your prices via Web-Interface / CorpShop.
Especially useful if you stock a station or have your Corp HQ some jumps away from next trade hub.

v0.1
-Changed Last Update description and Formula to cachedUntil API value so you can see when the next update is taking place (Thx Wafflehead for the idea)
Wafflehead
Garoun Investment Bank
Gallente Federation
#3 - 2014-04-10 15:03:50 UTC  |  Edited by: Wafflehead
I don't see how this spreadsheet is live when there is no formulas or XML imports?.

Thrasher 26 1,205,363.00 ISK
The numbers have been entered manually.

Last update is just using the now() function...

P.S - Spreadsheets are NEVER the solution to anything. They are simply made by people who cannot code a real system.
Regnar Avastum
#4 - 2014-04-10 15:15:57 UTC  |  Edited by: Regnar Avastum
Wafflehead wrote:
I don't see how this spreadsheet is live when there is no formulas or XML imports?.

Thrasher 26 1,205,363.00 ISK
The numbers have been entered manually.

Last update is just using the now() function...

P.S - Spreadsheets are NEVER the solution to anything. They are simply made by people who cannot code a real system.


That value is not typed in manually, there is a formula in E7 that brings the data. I agree that "last update" is not as useful as he may have intended, it only shows the current time not the last time of the api import. Spreadsheets most of the time are the solutions for anything, as coding a real system is not so easily done.

This tool seems interesting and spreadsheets are amazing :)

♔ ℜegnar's High-End Spreadsheets ♔™
Harry Sullivan
Caldari Provisions
Caldari State
#5 - 2014-04-10 15:42:41 UTC
Wafflehead wrote:
I don't see how this spreadsheet is live when there is no formulas or XML imports?.

Thrasher 26 1,205,363.00 ISK
The numbers have been entered manually.

Last update is just using the now() function...

P.S - Spreadsheets are NEVER the solution to anything. They are simply made by people who cannot code a real system.



Thanks for your reply Wafflehead.
I`ll keep my reply as neutral as possible as you seem to have even less experience with how spreadsheets work than I have and that is totally fine. Let me explain to you how it works.

The numbers are fetched automatically via imports and formulas in a hidden spreadsheet.
If you click on Data -> Protected Sheets you will see that there are hidden sheets in the demo where most of the heavy lifting is done. You might not have known about that feature.

Also you might see that Column A-C are hidden as well, now if you figure out yourself why that could be you might have learned something new today.

Last update is more for the customer so that you know when you refreshed the Sheet the last time, it doesn`t show you when the last API Pull was you are right. But I didn`t advertise that anywhere. It is a valid point tho I might be able to include the last API pull instead and update the description.

Thanks for your feedback.
About your spreadsheet comment, nobody forces you to use my solution if you are able to code your own and in fact feel free to do so if you think you can do it better.

I just created a solution that works for me and the most people I talked to about it and is free and doesn`t need any coding experience or spending money on hosting or your own server.

Have a great day.
Harry
Harry Sullivan
Caldari Provisions
Caldari State
#6 - 2014-04-11 19:19:24 UTC
Always looking for feedback. New features coming this weekend.
Harry Sullivan
Caldari Provisions
Caldari State
#7 - 2014-04-12 22:32:20 UTC
Updated to v 0.2, added remote price check to see if you are undercut/lowest selling party from the shop interface.