|Daily Deal Tracker|
(Central Time Zone)
|Explanation of the various tabs on this spreadsheet|
|Current & Next Rotations|
This sheet is the Daily Deal rotation for the list beginning October 12, 2018 and ending March 25, 2019.
Which is the current deal? Use Edit - Find command or CTRL + F and enter "current" to quickly jump to the current deal
You will have to manually delete deals that have expired. The times of the deals are not generated by a formula so deleting the top rows will not affect the other rows. Other than deleting past deals, you should not alter any information on this sheet especially not columns A, D, E, F or G.
Columns D, E, F and G take information from other sheets to indicate whether you own the deal, your CYS, CYS for set to be "free" and the indicator that the set will be free. ("Ownership Info" is based on the contents of Column B of Items_Owned. "Your CYS" cell will display the CYS you entered on Set_Tracking. "Estimated CYS to be free" cell will be blank if you have entered "Owned" in the comments field in Set_Tracking or if the set is not eligible for CYS. Column G will display the message "Should be free" if your CYS is equal to or less than the CYS needed for the green download button to be triggered. Since the amount in Column F is an estimate, you may need to spend a few more simpoints to get the green download button.
The item names of the deals appear in the colour of their category; sets are shown in blue font, premium items in green font, venues in brown font, worlds in purple font and single items in black.
The deal numbers on various sheets are colour coded to indicate repeat deals.
|Green fill are the lowest priced of the group of the repeated item|
|Yellow fill indicates that the item has repeated 3 or more times and the deal is neither the highest nor the lowest.|
|Red fill is used for the most expensive deal of the repeat (sometimes in can be only a few points more; sometimes hundreds more.)|
|White fill indicates the deal is only offered once in this rotation|
|This sheet is not a guarantee of when or if the deals will be offered. I do not work for the Sims 3 store and do not have any insider information as to when deals will be offered.|
|Set_Tracking - This is where you enter information|
You will only be entering in Column C, Your CYS; in Column D, Comments and Column G, Group Number.
This is an alphabetical listing of the sets available in the Sims 3 store, both those sets on the DD and those not appearing on the DD. (Note sets beginning with "The" are sorted under "T")
Column A - Set name and hyperlink to the set's product page on the store website. Following the hyperlink to the product page, will give quick access to your CYS.
Column B - Indicates whether the set is on the DD or not appearing on the DD
Column C - This is where you enter your CYS. For those sets not eligible for the CYS discount, the cell contents will be "Not CYS". You may enter a zero to mean that you do did not own any piece of the set, yet.
Column D - Enter comments such as Owned, CYS to be Confirmed, Waiting on deal 123, etc.
Column E - Lists the set(s) or compilation(s) in which the set is included
Column F - Lists the subsets, if applicable, for the set
Column G - The group number is used to filter the data on the sheet to only show the sets of a compilation or combination set for easier tracking of the CYS. Group 1 has been entered as a sample. You can use the filter function to show only the sets of a selected group number. For example, Group 1 is:
Morocco Mystique + Cante Captivating
To zoom in and out use the controls of your web browser hold down CTRL and use the + or -.
Green Rows - Once you enter in column D that the set is "Owned", the row turns green. (Note, the row will not turn green automatically if you enter any extra characters.) You will be able to see at a glance the sets you own and how much of the store you own.
Yellow Rows - If you enter "waiting" plus option extra text in column D, the D cell turns yellow. If you want the entire row to be colored, click at the beginning of the row, and select the paint can on the tool bar.
Deleting "Owned" or Waiting from the cells will remove the color fill.
|This sheet is an extension of the Set_Tracking sheet. This sheet automatically duplicates ownership information for sets based on what you have entered on the Set_Tracking page. You then manually update ownership of other items by typing "Owned" in Column B. (Careful not to delete the formula in a row related to a set. If you do, simply copy and paste the formula from cell in Column B.|
Listing of the items included in the Featured Looks sets and which other sets the items are included in.
|Dates to Remember|
You add the information on this sheet to track the date and time for the upcoming deals where you should have a green download button or a very low CYS.
|Sorted by Item Name|
|Sort of all items on the DD by item name to easily see all the deals for a particular item. This sheet sorts the deals alphabetically and then by price from lowest to highest.|
|Sorted by "Part of Set"|
|Want to know how may items from April 2012 Compilation Set, or any other set or compilation, are included on the DD list? This sheet is sorted by the column that lists the sets or compilations that the deal is included in. You can view all the items from a particular set or compilation that are offered on this DD list.|
|Sets on DD or Not on the DD|
|This sheet is a filtered Master List of sets and compilations. It includes a listing of sets and compilations not included on the DD list.|
|This sheet is a listing of all the venues and premium content items and indicates whether the item has been included on the DD, if it has not been included or if it is not available for sale|
|Tips and Goals|
|A sheet to enter notes|
|This is a listing of the entire rotation beginning with deal 1. The deals from the Master List are used to rebuild the current cycle sheet to add new cycles. |
If you notice any errors, please post a message on the DD thread.
Hyperlinks to help with your stalking
Two sheets used to update the new rotation, Blue Rotation and White Rotation, are hidden. To unhide them, select View from the Menu Commands and then Hidden Sheets. When the rotation that is ending ends with a deal with white background color, copy rows 2 - 978 from the Blue Rotation sheet to paste deals 1 - 978 of the next rotation. When the rotation that is ending ends with a deal with blue background color, copy rows 2 - 978 from the White Rotation sheet to paste deals 1 - 978 of the next rotation.
|The start time of the deals need to be updated.|
- Change the start time of deal 1 to the formula of "cell address of deal 977 of previous rotation" + cell address of duration of deal 977 divided by 24 (hours)". For example if deal 977 is row 4 and the next rotation begins on row 5, the formula to be entered in L5 is "L4 + K4/24"
- Copy the formula for deal 1
- Go down to start time of deal 2
- Select Edit - Paste Special - Paste Forumla only
- The deal start times are now updated, but need to be changed to values so when rows of past deals are deleted the start times will not show an #REF error
- Select the whole column L
- Select Edit - Paste Special - Paste Values only
|* If necessary change the start time of the deal affected by change from/to standard time to/from daylight savings time. Find the deal where the time change occurs, for all the deals that follow, use the method shown above to recalculate the start time of the deals that follow.|