ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Welcome to the Shop Manager Tool
3
Overview
4
The purpose of this tool is to allow shop keepers to plan out the growth of their shop space, energy and resources. The Shop Manager will provide data allowing you to configure your shop for a variety of events and play styles. No more lost efficiency due to laziness of not knowing how to tune your shop to your current goal.
5
Example: on better deals configure your shop for max energy to surcharge everything, while during caprice configure to focus on being able to craft certain items., or maybe max that new BP.
6
Thank you for using this tool, if you have questions, or other features you would like to see please message me on discord Gunnolf25#3434
7
Warnings
8
This tool is only designed to work in Google sheets and will not work properly in Excel
9
Do NOT cut and paste information in this file, you may overwrite formulas that will cause errors
10
11
Instructions
12
Make a copy of this in the upper left hand corner (File -> Make a copy), you will not be given editing access to the original.
13
Overview
14
The overview tab is a quick glance that shows the current shop set up and maximum potential for capacity, energy and resources. Do not input anything into the overview tab, all information is automatically calculated and shown here.
15
16
Shop Capacity
17
Go to the shop capacity entry and using the drop down menu (in the grey box) choose the number of shop expansions you have.
18
Rack Entry
19
Only enter information in the grey boxes
20
Enter the rack type, level of the racks and how many you have of that type. Do the same for your trunks.
21
"In use" means the item is in your shop or basement, "Total" includes items not currently being used. "Total" should always be equal to or greater than the number "in use."
22
Enter the level of guild perks in column J using the drop down menus for: Rack Energy & Storage Capacity
23
Resource Entry
24
Only enter information in the grey boxes
25
Enter the level of guild perks using the drop down menu for: Common, Uncommon and Rare Resource Capacity
26
Enter the bin type, level of the bin and how many you have of that type by common, uncommon and rare.
27
28
29
30
31
32
33
34
35
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