Testifye's Istan Profit Model (v1.0.0) [PUBLIC]

	C	D	E	G	H	I	K	M	O	Q	S	U
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30		Welcome to Testifye's Istan Profit Model
31
32
33		I began this project by asking myself "how much profit am I actually making in Istan?" The challenge of solving that surprisingly complex question motivated me to build a working model for myself, and when it was clear it was still the fastest gold farming method in the game, I wanted to make my results available for everyone to use.
34
35
36
37		A lot of work went into this to make it as comprehensive and as simple to use as possible. I hope this helps you in any small way to more efficiently spend your time and resources farming Istan. I welcome any and all constructive feedback, so let me know if you find bugs or issues, or have suggestions or requests for the future. If you are willing to share any data sample you have to improve the drop rate research I've done for this model, please consider submitting that information via the appropriate Google Forms on the website. Thanks!
38
39
40
41
42
43
44
45	Table of Contents
46	Table of Contents
47
48
49	#	Worksheet Name			Description							Link
50	1	Table of Contents			Includes navigational quick-links to other sheets, document version history, and special thanks to others for their research and help.							Sheet Link
51	2	USER DASHBOARD			The main user interface for this model - answer 5 questions on your farming methods here, then review the model's output, calculations, and trended visualizations.							Sheet Link
52	3	UPDATE API TABLES			The second most important sheet for the user - follow instructions here to manually update API calls if they're not updating automatically roughly once per hour.							Sheet Link
53	4	Primary Calculations			Back-end calculations to formulate your gold per hour profit at current TP prices, considering your answers to questions on the User Dashboard.							Sheet Link
54	5	Trended_Calculations			Back-end trended calculations that formulates a historical trend of profitability for Istan using the same parameters you input on the User Dashboard.							Sheet Link
55	6	Data Validation			Back-end inputs for drop-down menus on the User Dashboard and elsewhere.							Sheet Link
56	7	API: Item Price Trend			API data sheet calls the gw2spidy API for historical item price data.							Sheet Link
57	8	API: Live Item Prices			API data sheet calls the official GW2 API for live item price data.							Sheet Link
58	9	API: Item IDs			Back-end lookup tables for item names and IDs.							Sheet Link
59	10	Salvage Rates			Salvage result data from Testifye's research, salvaging all non-exotic drops from 42,000 pieces of unidentified gear.							Sheet Link
60	11	GW2 Profits Salvage			Salvage result data taken from gw2profits.com, thanks to the work of Mystic.5934.							Sheet Link
61	12	Palawadan Event Drop Rate			Testifye's drop-rate research on rewards obtained from bouncy-boxes after completing events during Palawadan or Great Hall.							Sheet Link
62	13	Unidentified Gear Drop Rate			Testifye's drop-rate research on all pieces of unidentified gear. Add new sample to this page in the existing format for it to be included in the model.							Sheet Link
63	14	Blue Unid. Data			Calculates drop rate of Blue Unidentified Gear, including linear regression model.							Sheet Link
64	15	Green Unid. Data			Calculates drop rate of Green Unidentified Gear, including linear regression model.							Sheet Link
65	16	Yellow Unid. Data			Calculates drop rate of Yellow Unidentified Gear, including linear regression model.							Sheet Link
66	17	Exotic Sales Averages			Calculates average sale price of exotic items Testifye's research (n = 354). This data is static, meaning it does not pull from live TP prices, and will need to be updated manually in the future.							Sheet Link
67	18	Leather Shipment Drop Rate			Drop rate research from the Leather Shipment Drop Rate wiki page, includes Testifye's data too. Add new sample to this page in the existing format for it to be included in the model.							Sheet Link
68	19	Leather Shipment Unit Research			Back-end research to determine drop-rate rules for Leather Shipments.							Sheet Link
69	20	Trophy Shipment Drop Rate			Drop rate research from the Trophy Shipment Drop Rate wiki page, includes Testifye's data too. Add new sample to this page in the existing format for it to be included in the model.							Sheet Link
70	21	Trophy Shipment Unit Research			Back-end research to determine drop-rate rules for Trophy Shipments.							Sheet Link
71	22	Supply Stash Drop Rate			Testifye's drop-rate research on loot obtained from Supply Stashes. Add new sample to this page in the existing format for it to be included in the model.							Sheet Link
72	23	Supply Stash Unit Research			Back-end research to determine drop-rate rules for Supply Stashes.							Sheet Link
73	24	Palawan Phylactery Drop Rate			Testifye's drop-rate research on loot obtained from Palawan Phylacteries. Add new sample to this page in the existing format for it to be included in the model.							Sheet Link
74	25	Palawan Phylactery Unit Research			Back-end research to determine drop-rate rules for Palawan Phylacteries.							Sheet Link
75
76
77	Version History
78	Version History
79
80
81	Version		Release Date	Description
82	v0.1.0		01/06/2018	Initial Alpha release for personal publication testing only. All core systems active, including:
83					-- Drop rate calculations for Trophy and Leather Shipments, Palawan Phylacteries, Supply Stashes, map event rewards, and Unidentified Gear.
84					-- Average price of exotic gear drops.
85					-- Salvage rates for gear by rarity, including breakouts for CF-SoM and SF-SoM / Mystic Kits.
86					-- API calls and data ingestion from gw2spidy.com and the official GW2 API.
87					-- Core profit model calculations and trended profit model calculations, along with several other key metrics.
88					-- Primary user interface dashboard with data visualization, as well as user-accessible API refresh capabilities.
89
90
91	Special Thanks and Credits
92	Special Thanks and Credits
93
94
95	Contribution		Links	Description
96	Leather Shipment Drop Rates		Wiki Page	Thanks to the following Wiki users, YouTubers, and Redditors for contributing their research to the community:
97	Leather Shipment Drop Rates		Wiki Page	Karob		peetftw.7286	Kalix.1406	Hal42	Yoruu	Kulgin	MaxOS1104
98	Trophy Shipment Drop Rates		Wiki Page	Thanks to the following Wiki users, YouTubers, and Redditors for contributing their research to the community:
99	Trophy Shipment Drop Rates		Wiki Page	Monoreign		KasparMk5	Aikala	Trutichup	Khisanth
100	Salvage Rate Research		gw2profits.com	Thanks to Mystic.5934 (Toothless Biter) (/u/colbymg) for compiling and publishing a great set of salvaging data for the community!