e-351/janice

Your friendly neighborhood space junk worth evaluator.

Janice

Your friendly neighborhood space junk worth evaluator.

This repository serves only as issue tracker for https://janice.e-351.com

API

APIs require an api key, you can get one by sending me PM (kukki#3914). Reason for having own api key is so that I can contact/block people with excessive traffic. If you use api key not bound to your name (like the one below) you might find yourself blocked at some point without warning.

Swagger UI: https://janice.e-351.com/api/rest/docs/index.html
Sample api key: G9KwKq3465588VPd6747t95Zh94q3W2E

Google sheets script v2

1. Copy script in janice-v2.gs
2. Paste it into your sheet => tools => script editor
3. Use JANICE_PRICER function in your sheet

Sample sheet: https://docs.google.com/spreadsheets/d/1TPRhmsw77-vIO7QD-XlvCu9w0xzyk73iuGtto0SrQZE/edit?usp=sharing

Google sheets script (v1 - legacy)

1. Copy script in janice.gs
2. Paste it into your sheet => tools => script editor
3. Use JANICE_PRICER function in your sheet

Sample sheet: https://docs.google.com/spreadsheets/d/1kv0b627HD6qNjr3nLw-codRY8W-3vBAvpclYFpzqnWM/edit?usp=sharing

Excel

Sample powerquery:

let
    ItemList  = "Compressed Spodumain#(cr)#(lf)Carbon#(cr)#(lf)Tritanium",
    RawData = Table.FromRecords(Json.Document(Web.Contents("https://janice.e-351.com/api/rest/v1/pricer?key=G9KwKq3465588VPd6747t95Zh94q3W2E", [Headers = [#"Content-Type"="text/plain"], Content = Text.ToBinary(ItemList)]))),
    ExpandedMarket = Table.ExpandRecordColumn(RawData, "market", { "id", "name" }, { "marketId", "marketName" }),
    ExpandedItemType = Table.ExpandRecordColumn(ExpandedMarket, "itemType", { "eid", "name", "volume", "packagedVolume" }, { "itemTypeEid", "itemTypeName", "itemTypeVolume", "itemTypePackagedVolume" })
in
    ExpandedItemType

janice's Issues

Add 5, 30 day average pricing

Add

5 day average buy/sell
30 day average buy/sell

Format: PP quantity with dot in amount 🙄

From discord:

Hello there 🙂 Discovered an issue with decimals: 10.0 on the quantity (not sure why one would have decimals in the quantity though) is turned into 100. Example: https://janice.e-351.com/a/u63upa
Those numbers come from the PI launchpad inventory:

Use refined information for meta title and description

Hi,

One small improvement that would be nice to see is to have html meta tags when on a /reprocess affixed route display the jita split from the reprocess instead of the input items.

My main use case for this is when linked in discord, the "preview card" grabs that meta information, it can be confusing when skimming over a link of moon ore for instance (Example: https://janice.e-351.com/a/HZPkfD/reprocess) and seeing the split on the ore not the reprocess.

Feature Request - Moon Value Calculator

Eve-Mogul had a great tool where you could input a moon scan and it would estimate the value of the moon. Since it died I haven't seen anything similar made.

[Bug] blueprint copies in chinese interface

When using chinese interface with english keyword name, the copied contract detail for bp copies will be as follows:

Harbinger Blueprint*	1	Battlecruiser Blueprint*	Blueprint*	蓝图拷贝 - 流程：1 - 材料效率：10 - 时间效率：20

However this will be treated as original bp

Expose compactize in API

Adjusted pricing

Magicalize reasonable price guesses

• capitals, roughly based on ore cost + relatively high index for a supercap system
• manipulated items.. allow price changes in smaller increments between snapshots? use 5% percentile?

Fact that the given price needs to be shown as a warning and maybe assign a color scheme to it so it is obvious.

Feature Request: Option to prune leftover ores from reprocess output

Request in title. Ore prices are often wildly out of sync with actual value (15% versions, uncompressed ore, and new ores especially) and can incorrectly inflate the Buy/Split/Sell prices of the reprocessed output. Is it possible to add a checkbox to the reprocess section of Janice that will prune leftover ore from the reprocessed results to get clean values?

Dark mode

People playing eve stare into the darkness whole day, then they receive a link and die of sudden illumination.

Note: difficult with current stack, planned for Q1 2020

Add copy industry materials format

Tritanium (14000 Units)
Pyerite (9000 Units)
Mexallon (3000 Units)
Isogen (300 Units)
Nocxium (60 Units)
Zydrine (25 Units)
Megacyte (5 Units)

Use market slug or provide dynamic market hub list in api

Can't parse backtick and tick for number grouping

A user whose system language apparently is set to German Swiss German has reported that the parser is not able to handle accent grave and accent acute. Ingame their client shows number grouping with an accent, for example "Jasped 14`000".

Example: https://janice.e-351.com/a/YqwXr6 and https://janice.e-351.com/a/WvNkyZ

Expectation: Same as "Janice 14,000"

Clear button?

I couldn't find where to clear the text area.
Is it possible to add a "Clear All" or "Reset" button?

Great project by the way.
Keep going! ☺

Allow compress functionality to compress ore as well

Numeric value with m3 suffix may be mistaken for amount

Sample

federation navy ogre     25 m3 3,000,000.00 ISK

https://janice.e-351.com/a/xQbA72

Doesn't handle ship quantities too well

Avoid overwriting pricing info when esi is being weird

Skip staging => live dataset migration when things are looking weird

bad price calculations

https://janice.e-351.com/a/mcKbNv ... is buggy?

for example, first row Contaminated Lorentz Fluid
~182k buy per piece
190pieces
~363k total buy (?)

Outdated dataset warning

I just tried to appraise the contents of a storage container, and it did return an appraisal, but it also returned a warning: This appraisal was created against outdated dataset from 4/21/2024, 19:13:05. Please try again later and if the problem persist [contact us](https://janice.e-351.com/about).

Calculate Jita Split per Item between Buy and Sell

It would be nice to have Jita Split for each line item.

Feature Idea: Advanced Options: Add a Multiplier

Feature Idea

Add the ability to multiply the items in the appraisal.

This could come in useful when wanting to buy things like ships with fittings or industry inputs. Allowing the user to quickly change the items by a factor value.

Before

Optical Compact Tracking Computer	1	5.00	1220.00	7894.00
Dual Modulated Light Energy Beam I	4	5.00	356000.00	579800.00
Small Capacitor Control Circuit I	3	5.00	85000.00	97210.00
Microwave S	                        4	1.00	2133.00	7993.00
Tracking Speed Script	                1	1.00	7906.00	39480.00

Multiplied by 8

Optical Compact Tracking Computer	8	5.00	1220.00	7894.00
Dual Modulated Light Energy Beam I	32	5.00	356000.00	579800.00
Small Capacitor Control Circuit I	24	5.00	85000.00	97210.00
Microwave S	                        32	1.00	2133.00	7993.00
Tracking Speed Script	                8	1.00	7906.00	39480.00

In my specific case I am looking to buy a bunch of ships with fittings. Ending up multipling the quantities by hand.

Feature Request: URL parameters for direct links specifying regions/price percentages/other settings

For example: A corp buyback could be sent to everyone asking where to appraise their stuff by simply having a static URL in a bulletin or pasted message.

Something like:
https://janice.e-351.com?region=jita&mode=buy&ratio=90

And people could copy/paste their items and have them automatically appraised with the specified settings.

Display difference of current price against 30 day average as icon with %

Rounding error when using custom percentage

I entered an appraisal with 110% Jita sell.

When I see the resulting appraisal result, the following lines are shown:
"WTB @ 110.00000000000001% Jita sell
This appraisal is valued at 110.00000000000001% of market value."

Just a minor issue, but it looks just wrong.

Adding a less popular but still major trade hub like Dodixie

Hello,
First, let me say that Janice from an appearance standpoint looks great. However, one thing Janice is lacking is the lesser known but still major trade hubs like Dodixie for example, maybe even add some comparisons of the prices between different major trade hubs shown at the bottom. This way users aren't bombarded with so much information and still keep a rather minimalistic clean look. I have some programming experience not sure how difficult it would be to add those trade hubs but I'm also willing to help out if you point out where to start and submit some PRs.

Other trade hubs mentioned in the https://wiki.eveuniversity.org/Trade_hubs seem to be not included yet in Janice. I know most people trade at Jita and it's unreasonable to add all lesser-known trade hubs but Dodixie is still a big trade hub and so are some of the others listed in the wiki.

Also noticed this seems like someone already made a request so here is me making another request for Dodixie (Dodixie IX - Moon 20 - Federation Navy Assembly Plant) #10

Multipricer doesn't return items if the pricing information isn't present in the db

Feature Request: Advanced Option, Exclusion List

It would be nice put a list of items in like normal, but then go into the advanced options to give a secondary list of items to exclude from the final result.

ie..

First list

Name Quantity
ItemA 10
ItemB 15
ItemC 15

Second list

Name Quantity
ItemB 5
ItemC 10

Resulting list

Name Quantity
ItemA 10
ItemB 10
ItemC 5

I know it would be such a great value add, for an already incredible tool, to allow me to take 10 fits for a ship, then paste in what i have in my giant inventory on my alt, so that i only buy what i'm missing without having to do the work of scouring through and cross referencing.

Pull adjusted_price

Pull adjusted_price from esi

API:

• adjusted_price for specific item
• sum of adjusted_price materials at ME0 (base job cost)

Inputs with decimal values are not truncated

Inputting values with decimal values (20.0 as an example) do not properly truncate the decimal value and simply ignore it and counts the numbers after the decimal as additional numbers (20.0 = 200 as the example). Which can cause very inaccurate price values for some copy+paste inputs from EVE.

Feat req: pasting from production

矿物				
Item	Required	Available	Est. Unit price	typeID
<localized hint="三钛合金">Tritanium</localized>	896	0	4.19	34
<localized hint="类晶体胶矿">Pyerite</localized>	3	0	9.73	35
<localized hint="类银超金属">Mexallon</localized>	112	0	55.2	36
<localized hint="同位聚合体">Isogen</localized>	1	0	440.44	37

材料				
Item	Required	Available	Est. Unit price	typeID
<localized hint="殷郡纳米纤维">Yan Jung Nano Fabric</localized>	1	0	7366.1	23142
<localized hint="殷郡空壳">Yan Jung Null Shell</localized>	1	0	1162551.97	23138
<localized hint="殷郡玻璃秤">Yan Jung Glass Scale</localized>	1	0	331095.67	23139
<localized hint="殷郡全裹电线">Yan Jung Plenary Wire</localized>	1	0	49114.42	23140
<localized hint="殷郡的雷雨风筝">Yan Jung Thunder Kite</localized>	3	0	1202708.56	23130
<localized hint="殷郡的光子听诊器">Yan Jung Tachyon Stetoscope</localized>	1	0	121933231.71	23132
<localized hint="殷郡丝质装甲">Yan Jung Silk Armor</localized>	1	0	8800.95	23141

物品				
Item	Required	Available	Est. Unit price	typeID
<localized hint="殷郡异常数据分析报告">Yan Jung Singularity Fact Sheet</localized>	1	0	45287226.89	23172

Use a localized client, open the production page and select a blueprint, right click on the arrow and use "copy material info"

Add ISK/m3

From discord:

since evepraisal went down totaly few months ago - may i ask if there is a hope for janice getting an extra output ISK/m3 ?
would be really usefull in some cases

Add percentage in addition to buy/split/sell

Remebering Setting

Love the Site and all its Features in it. One addition would be nice to set or remember Settings that had been made on the Reprocessing Value. Standard is already MAx Null Sec Refine rate at 90% and it will always reset to that when you paste in a new Ore Paste.

Feature Request: Parsing Mining Ledger

Been looking at parsing the corp moon mining ledger in some way.
The old evepraisal had a feature for that where it would gather up the names of who mined what and sum it all up.
Is this possible with E-351 Janice?

Use string names in swagger enums

Investigate high performance scenarios

Lots of parallel requests die due to sql connection pool exhaustion. Investigate possible mitigation or introduce limits.

Re-fetch structure names periodically

Add more market hubs

Amarr, dodixie, hek, rens?

Cannot Make New Appraisals

I am unable to create any new appraisals, this started today. Check from all my devices.

Using Copy function only copies Single item prices no matter what option you have selected.

As title said, if you use the copy function button it only copies the Single Item price even if you have the Total option selected.

Copy button should include volume and optionally totals

Probably will be dropdown menu:

• current behavior (for people who depend on it)
• id | name | amount | volume 1 | buy 1 | sell 1
• id | name | amount | volume 1 | buy 1 | sell 1 | volume all | buy all | sell all

Expose Reprocess API

We are currently using Janice to appraisal loot based on its reprocessed value.
Having this api exposed would be amazing.

[Enhancement] EFT Conversion Tool

Add a feature where it will recognize EFT format.

I filed a ticket that I found afterward was actually an error due to not recognizing the EFT format.

#41

Then I checked out Eve Tycoon and realized it was a formatting error, because their site will interpret the items in EFT format and then make an appraisal.