ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Updated Version Available HERE
2
Title5th Edition Pricing Assistant ToolVersion HistoryVersionDateAuthorDescription
3
0.123.08.2022MJBInitial draft, added instructions and title page for use by others.
4
Instructions for UseUse the 'ShopGenerator' tab to create a randomly-generated shop inventory. You can select a shop type here, and also select a world event that will apply modifiers to the price of certain items.

The tab named 'Stores' will display a list of all potential items the selected shop type can have in its stores. This is based on the selections made in the ShopGenerator tab.		0.201.09.2022MJBSet absolute inventory sizes per shop type, 'Generic NPC' and 'Toll Booth' added, fixed some 'Item' type goods that were showing as 'Containers', tweaks to max discount on goods over 22gp, added global pricing modifiers.
5
0.306.09.2022MJBAdded Inn (Small), Inn (Large), Inn (Regal), Tavern, Tannery, Farm, Hospital, Black Market to shop types. Added multiplier for items purchased from the Black Market.
6
1.006.09.2022MJBVersion uplift for initial release to r/DnDBehindTheScreen
7
8
9
10
11
Column DescriptionsThe 'Shop Generator', 'Stores', and 'Pricebook' tabs have columns showing pricing information for each item type. The use of these columns are described below:
12
13
14
Base Buy PriceThe price a consumer-facing vendor will offer the item for as standard.
15
 - If a PC happens to run a shop, this is the price they can price their items at, less any taxes.
16
Min. Buy PriceThe lowest price a vendor can be talked into selling the item for.
17
Low Sell PriceThe initial price most NPC vendors will offer for the item.
18
Max. Sell PriceThe highest price most NPC vendors will offer for the item.
19
20
Instructions for ModificationAll of the item and pricing information is driven by the 'Pricebook' tab. If you wish to modify the pricing data, add notes to an item, or change column titles, do so here and the changes will flow down into the 'Stores' and 'StockRandomiser' tabs.

Adding more shop types is more complex, and requires more advanced Google Sheets knowledge. Step-by-step instructions on how to do so are shown below:
21
22
23
24
25
26
• Add a column to the right of the existing shop types on the 'Pricebook' tab, named for the shop type you're adding.
27
28
• Set all cells in this column (from row 2 to row 219) to read 'FALSE'.
29
• Scroll through each item type, and where the new shop type should stock a given item, change the value for that row in the new shop column to 'TRUE'.
30
31
• On the 'ReferenceTables' tab, add the new shop type's name to Column A.
32
• Add the new shop type to the nested IF statements in cells B2, B3, and C4 of 'ReferenceTables'.
33
 NB: Adding the shop type to C4 is optional, default is five sevenths of total store size.
34
35
To change the number of items that the 'ShopGenerator' tab provides for a given shop type, alter the formula in cell C4 of the 'ReferenceTables' tab.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100