Total Loyalty Point Offer Comparator (Trig offers!)

For questions about PVE, such as missions, anomalies and complexes.
Forum rules
This forum can be viewed by the public.
Post Reply
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Total Loyalty Point Offer Comparator (Trig offers!)

Post by Arin Mara »

Total Loyalty Point Offer Comparator
Image

The Total Loyalty Point Offer Comparator is a spreadsheet of Loyalty Point Offers enriched with Faction and Market Group information that computes the ISK per Loyalty Point for all Corporations in New Eden.

Features

  • Compare the ISK per Loyalty Point between all Offers
  • Filter by multiple complex conditions or values
  • Sort by any column (see Data dimensions)
  • Flexible data format
  • Save a snapshot, download it and do offline analysis
  • Extend with new columns or delete existing ones

Compared with other tools

  • Fuzzwork's LP Store: shows the best Loyalty Point to ISK Offer, but only for a single Corporation at a time and with no filters
  • Ellatha's LP Store: shows an exhaustive list of all Offers, but doesn't interface with the Market

Answer New Eden spanning questions

  • Which High Security Corporation pays the most ISK per Loyalty Point on Buy Order?
  • How will the Buy Order price of Amarrian Items change after the Fall of Niarja?
  • What's the most sought after Item?
  • What's the best ISK per Loyalty Point ratio if I only sell to Buy Orders?
  • Which Offer has the biggest spread between Buy and Sell Order value?
  • Which Faction Warfare Militia Corporation should I join?
  • How do I filter out Faction Warfare, low volume or implant Offers?
  • How many offers require more then four items?

The Database's secondary purpose

  • Create a downloadable machine and human readable Loyalty Point Offer table
  • Enable capsuleers that lack advanced information technology skills to better understand the Market
  • Reduce Market information asymmetry
  • Show the power of spreadsheets over websites
  • Excite the public imagination

Cons

  • Slow: evaluating the whole of New Eden for the first time can take up to 5 minutes
  • Blueprints aren't evaluated: omitted in favor of speed and simplicity
  • Sensitive to market manipulation: shows current price, not the moving average

If you see #N/A instead of numbers there will be a white-gray progress bar in the top right of Google Sheets. The Database is fetching Market data. The progress bar may appear multiple times. Give it 5 minutes.

How to start using the Database

  • Login and make an online copy or
  • Create a temporary filter or
  • Download it

Future plans

  • Create a website

I'm currently open for interviews and collaborations. Contact Arin Mara via EVE email or maraarin@gmail.com.
ISK tips and donations are more then welcome.

----- ----- ----- ----- Appendix ----- ----- ----- -----
Data dimensions

  • faction_name: like Thukker Tribe
  • corporation_name: like Garoun Investment Bank
  • type_name: like Federation Navy Iridium Charge M
  • market_group_name: like Implant
  • buy_value: Fuzzwork's Buy Order appraisal of Loyalty Point Offer
  • sell_value: Fuzzwork's Sell Order appraisal of Loyalty Point Offer
  • buy_volume: Item's Buy Order Volume
  • sell_volume: Item's Sell Order Volume
  • isk_cost
  • lp_cost
  • analysis_kredit_cost
  • required_items_X_item_name: Offers may require Faction Warfare or Ammo Items
  • total_isk_buy_cost: sum of isk_cost and all hidden required_items_X_item_buy_value columns
  • total_isk_sell_cost: sum of isk_cost and all hidden required_items_X_item_sell_value columns
  • profit_sell_to_buy_buy_from_sell: buy_value minus total_isk_sell_cost
  • profit_sell_to_sell_buy_from_sell: sell_value minus total_isk_sell_cost
  • isk_per_lp_profit_sell_to_buy_buy_from_sell: profit_sell_to_buy_buy_from_sell divided by lp_cost
  • isk_per_lp_profit_sell_to_sell_buy_from_sell: profit_sell_to_sell_buy_from_sell divided by lp_cost
  • ... and many hidden columns for intermediate computation

Prior work


Difference between an Offer and an Item

  • There are 1 943 unique Offers
  • There are 1 835 unique Items
  • Different Offers allow you to purchase the same Item

Database trivia

  • 30 831 rows
  • 44 columns
  • 1 340 944 data points
  • 1 943 unique Offers
  • 1 835 unique Items
  • 176 Corporations
  • 18 Factions
  • Many weeks in the making

Updates

  • Veles, Perune and Svarog Clade and The Convocation of Triglav Offers added

Arin's Guides


Feel free to contact Arin Mara via EVE email or maraarin@gmail.com.
Last edited by Arin Mara on 2021.07.16 09:36, edited 6 times in total.
User avatar
Hippla Tsero
Campus Manager
Campus Manager
Posts: 229
Joined: 2017.01.15 22:17

Re: [Arin's Guide] Loyalty Point Offer Database

Post by Hippla Tsero »

Really good stuff :)
EVE University NSC Manager; Personnel Officer; Communications Officer

Social Media
https://twitter.com/EVEUniversity/
https://www.facebook.com/EveUniversity/

EVE University blog:
https://www.eveuniversity.org/
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: [Arin's Guide] Loyalty Point Offer Database

Post by Arin Mara »

Thanks Hippla :)

Would anyone find a CLASS about spreadsheets and how to use the Database useful? If so, tell me and I'll see if I can schedule an event. :)
User avatar
Adam Ironborn
Member
Member
Posts: 85
Joined: 2019.01.16 07:43

Re: [Arin's Guide] Loyalty Point Offer Database

Post by Adam Ironborn »

I just noticed this :) Due to time constratins (because of RL stuff) I did not look it in details yet but it seems a very good initiative. Web based tools are good but a spreadsheet like this has its own advantages over other web based tools.
My former EUNI character : Ersin Oghuz
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: [Arin's Guide] Loyalty Point Offer Database (Trig updated!)

Post by Arin Mara »

I've added the new Triglavian Loyalty Point Offers to the Database.

All Triglavian Offers cost zero Loyalty Points and only require items and ISK.

Enjoy! :)
User avatar
Iris Ayanami
Member
Member
Posts: 26
Joined: 2020.10.07 09:10

Re: [Arin's Guide] Loyalty Point Offer Database (Trig offers!)

Post by Iris Ayanami »

This is an impressive piece of work and quite a lot of effort and time must've gone into it. Thanks for sharing this for everyone's benefit! I'll definitely be referring to this a bunch in the future when I start doing more missions.
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: [Arin's Guide] Loyalty Point Offer Database (Trig offers!)

Post by Arin Mara »

My pleasure ;) As I've told Hippla in private, as long as one other person finds the LPDB useful I'll continue to work on it. :)
User avatar
Dr Jekyl l
Member
Member
Posts: 86
Joined: 2021.05.15 15:38

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Dr Jekyl l »

Ok, one sorta complex question about this tool. Once I have 'started' using it aka. I make an online copy, how do I actually use it? Is there a dropdown field or something that I am missing where I select the faction of LP I am interested in and it shows me the offers from best to worst? is there a way to select offers based off of Concord LP exchange rate?
Image
ImageImage
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Arin Mara »

Under How to start using the Database I tersely say that you can make a Create a temporary filter. Here's an image that might help explain what I meant:
Image
If this image answers your question, I'll put it into my original post :)

The Sheet has no column that compares the CONCORD Loyalty Point Exchange Rate. However, there is a Faction column where you can select all the Corporations belonging to the Empires and therefor have a list of all 10 to 8 exchange rate Corporations and their Offers.
User avatar
Dr Jekyl l
Member
Member
Posts: 86
Joined: 2021.05.15 15:38

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Dr Jekyl l »

when I try step 4 the colums from r -> go either blank or #REF!
Image
ImageImage
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Arin Mara »

It takes the Sheet several minutes to update because it has to compute millions of numbers. If you see a green bar in the top right corner of the Sheet, it means the Sheet is computing.
If the issue persists even after 5 minutes and there is no green progress bar, we can either meet on Discord and you can stream the problem or you can ask me the question you asked the Sheet and I'll try to answer it using the Sheet. :)
User avatar
Dr Jekyl l
Member
Member
Posts: 86
Joined: 2021.05.15 15:38

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Dr Jekyl l »

Yes that did help, thank you Arin! I still get the errors when I sort AU by value z->a. Am I doing that incorrectly, or should I just filter for the highest values?
Image
ImageImage
User avatar
Arin Mara
Member
Member
Posts: 320
Joined: 2020.07.10 13:53

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Arin Mara »

A "#DIV/0!" means that the Loyalty Point Offer costs 0 Loyalty Points. Think of it not like an error, but as the highest numerical value possible. I could set it to zero too, but then these Offers would be mixed in with the Loyalty Point Offers that do cost Loyalty Points, but sell for exactly the same value as the what you paid for them in the first place.

There should not be any other errors like "#REF". If there still is such an error, it means either that the Sheet hasn't computed all the values or I've inadvertently made an error and I need you to show it to me. :)
User avatar
Dr Jekyl l
Member
Member
Posts: 86
Joined: 2021.05.15 15:38

Re: Total Loyalty Point Offer Comparator (Trig offers!)

Post by Dr Jekyl l »

https://pasteboard.co/KbqudxS.png is what I get after selecting sort Z -> A on column AV in step 4 of above posted procedure. I highly doubt you have a bad reference in there, it is more likely that I am breaking things.
Image
ImageImage
Post Reply