ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Sims 3 Store Savings Tools
2
by SpiredMoth
3
The tools in this spreadsheet were made with the intention of helping The Sims 3 Store users save as many of their SimPoints (SP) as they can.
4
5
6
7
8
9
Make Me an Offer (MMaO) CheckerComplete Your Set (CYS) Calculator
10
This MMaO Checker compares the contents of a MMaO deal against buying the same items separately at their best prices according to the current Daily Deal and Weekly sale lists and including CYS (using set's cheapest item) where applicable.The CYS Calculator determines the CYS Price the Store will offer you for a set based on which items you own.Column and Cell Explanations
11
Column A, Rows 13+Sets that share at least 1 item with the set named in A2
12
13
B2 - C8Daily Deals for the set named in A2, sorted in ascending order of deal price
14
Setup for CYS calculation:
15
When you enter a set name into A2, the following will happen:
16
To check a MMaO deal:Column B, Rows 13+Total SP value of shared items. Cell is colored blue if it matches the value in Column E, meaning the set in Column A is entirely contained with the set in A2
17
1Enter the MMaO deal price in cell A71Available prices for the set will appear in the top-left. The first price will always be the non-Daily Deal price (whether that's the regular or the "weekly sale" price)
18
2Enter each item name (or product ID) into one of the cells A2 through A6
19
20
In cases where an item shares its name with another or contains accented letters (like í), the lookup function will return a #REF! error and you'll have to input the item's product ID insteadColumn C, Rows 13+Regular/Best price (configurable by B10) of set from Column A
21
2Items that contribute to the set's CYS will appear in the list to the right
22
Column ETotal SP value of items in the set in Column A. For Rows 4+ this is colored blue if it matches the value in Column B, meaning the Set in Column A is entirely contained within the set in A2
23
3Other sets whose CYS price is affected by one or more items from the list appear in the bottom-left
24
To find an item's product ID, open the item's Store page and check the URL for "OFB-SIM3:XXXXX" -- the product ID is the XXXXX portion. Just enter this 5-digit number and the lookup will work.
25
26
27
Usage TipsF2 - F8Total SP value of items marked as owned
28
When trying to find the best path to CYS, I'd recommend setting up the calculator as follows:
29
Column F, Rows 13+Total SP value of items from the set in Column A that are marked as owned. This gets colored green if it matches the value in Column E, meaning every shared item has been marked as owned
30
B10Set to "Best"
31
P2Set to "Savings"
32
S2Set to Descending
33
Column M, Rows 4+Make sure all these cells are empty, then enter the number 0 in each cell that's on the same row as an item in Column N that you already own
34
Column HTotal SP value still needed to make the CYS free for the associated price
35
36
Column IEstimated CYS for the associated price based on items marked as owned and price in Column C
37
38
Start trying items that have savings (green Column Q), copying the value in Column O into Column M
39
Column JTotal SP cost of set for associated price based on estimated CYS and Total Paid
40
41
Once yoiu've run out of items with savings you can stop trying items as you've found your best CYS for now. To open up new paths you'll need to acquire items that don't go on sale.Column KSavings of SP total from Column J based on the set's non-DD price (C2)
42
43
M2Sum of all numbers in Column M Rows 4+. This cell is colored green if 1 or more cell below and its counterpart in Column N are not blank
44
45
46
47
Column M, Rows 4+Each non-empty cell in this column is colored orange and marks the matching item from Column N as "owned" so that its value contributes to CYS calculations
48
49
50
51
N2Drop-down allowing a choice from the sets listed in Column A Rows 13+. If this cell is not blank, items in Column N Rows 4+ will be highlighted if they contribute to this set's CYS
52
53
54
55
Column N, Rows 4+Names of items that contribute to the CYS of the set named in A2
56
57
Column O, Rows 4+Best price for item in Column N. Cells colored green are lower than their counterpart value in Column P
58
59
60
P2Controls the sorting of the items in Column N Rows 4+. Available options:
- Product ID
- Item Name
- Item Value
- Savings
61
62
63
64
65
Column P, Rows 4+SP value of item from Column N. Cells are colored yellow/gold if their value is greater than or equal to the "Need for Free" value in H2 or H3
66
67
68
69
Column Q, Rows 4+Savings of Best Price (Column O) against Value (Column P), colored with a shade of green if greater than 0
70
71
72
Column R, Rows 4+Daily Deal number of item's Best Price. 1000 in this column represents the stuck "Weekly Sale" price
73
74
75
S2Controls the sorting direction
- Ascending (A-to-Z)
- Descending (Z-to-A)
76
77
78
Column S, Rows 4+The item from Column N contributes towards the CYS of each set listed here
79
80
Column T, Rows 4+Product ID of item from Column N
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100