The Shop Tool/Changelog

From YPPedia

Contents

This the changelog for The Shop Tool. It starts with the upgrade from version 2.0 to 3.0. Earlier logs are not available. Newest versions are listed on top. Contributing developers are listed in Red Italics next to features. If no one is listed, Belgarion was the developer. Beginning with the Version 5.0 release, Rakkii joined the development team as a regular contributor. Beginning with the Version 5.16 release, Biliter01 joined the development team as a regular contributor. Beginning with the Version 6.0 release, Megami joined the development team as a regular contributor.


[edit]

Version 6.1

Released: May 14th, 2008 (Megami1)

  • Bugfixes:
    • Furnisher: Fixed bug that was incorrectly calculating cost and tax for a few items that used cloth.
  • Added
    • Malachite Ocean and it's tax tables
[edit]

Version 6.0

Released: April 29th, 2008 (Megami1) Updated directly from Version 5.11

  • Added
    • Added query that searches for updated versions of the shop tool automatically and displays a message at the top of the title page, the commodities page and all the shop sheets which links to the shop tool website for download when a new version is released. This message will not display if the user has the latest version.
    • Commodities: All new enamels and cloths
    • Apothecary: 8 new enamel colors and starfish repellent
    • Distillery: Pricing section for premade mugs as reference tool
    • Distillery: Premade mug value (manual entry) in Estimated Net Worth
    • Iron Monger: Pricing section for premade swords as reference tool
    • Iron Monger: Premade sword value (manual entry) in Estimated Net Worth
    • Shipyard: Longship, Exbec
    • Shipyard: Pricing section for premade bludgeons as reference tool
    • Shipyard: Premade bludgeon value (manual entry) in Estimated Net Worth
    • Shipyard: Finished goods calculation for premade ships in Estimated Net Worth
    • Shipyard: Tan cloth
    • Weavery: Rose, Lavender and Mint cloth and fine cloths
    • Weavery: On Order column that is figured into net worth
    • Weavery: VIP customer pricing section to set and track prices for special customers
    • Tailor: All new cloth colors and items.
    • Tailor: Rack pricing table with instructions at the top of the table
    • Tailor: Rack profit margin section to be used as reference tool only with manual entry of price taken from the rack pricing table (manual color selection is also needed for accurate profit margin calculation)
    • Tailor: Rack value (Manual Entry) in Estimated Net Worth
    • Furnisher: All new items, enamel and cloth colors
    • Furnisher: Pricing section for premade furniture as reference tool
    • Furnisher: Premade furniture value (manual entry) in Estimated Net Worth
    • Furnisher: Premium dub delivery chart for purple and black cloth to the furnisher and updated items affected in the cost w/dubloon columns
    • Real Estate: Downgrades
    • Real Estate: Furnisher shoppe, upgrade and downgrade
    • Real Estate: Real Estate Agent shoppe and upgrade
    • Tax Pages: Updated manual values
    • Languages: All new enamel and cloth colors and items
  • Removed:
    • Shipyard: Yellow Paint
    • Furnisher: Flag Monument
  • Bugfixes:
    • Tax Pages: updated external data query that was causing an error in the Sage tax page and ultimately an error on the Real Estate Agent as well.
    • Formula corrections for Estimated Net Worth on all shoppe pages
    • Tax Pages: reformatted the tax per unit column to Number with 1 decimal place so that european users will be able to use the automatic refresh function for the tax tables without the sheet converting the values to dates.
    • Correctly linked buy prices for comms on shoppe sheets to the Commodities page.
    • Correctly linked the buy prices on the Commodities page to reference costs from the shoppe sheets NOTE: As always, the user can overwrite buy prices on individual shoppe sheets as they wish.
    • Tailor: Fixed Profit Margin formula in the rack section to accurately reflect the profit margin over the total cost with dub delivery fee.
  • Sheet Maintenance:
    • Aesthetic formatting changes for more continuity throughout the workbook
    • Analysis Page: updated formulas to compensate for changes on shop sheets (Charts page should be unaffected as it pulls from the analysis page)
    • Arranged White and Black cloth in their proper placement on all affected shoppe sheets and the commodities page according to it's order in the manage prices screen.
    • Arranged color selection buttons in alphabetical order on all shoppe sheets to match the game's color selection order.
[edit]

Version 5.20

Released: February 5, 2008 (Biliter01)

  • Added
    • Apothecary: Starfish Repellent
    • Tailor: Chainmail (male)
    • Tailor: Chainmail (female)
  • Removed
    • Tailor: Buggy Rack Pricer
[edit]

Version 5.16

Released: January 2, 2008 (Biliter01)

  • Added
    • Tailor: Curled Boots
    • Tailor: Viking Helmet (male)
    • Tailor: Overlord Helmet
    • Tailor: Viking Helmet (female)
    • Tailor: Valkyrie Helmet
    • Tailor: Veil
    • Tailor: Fixed formulas in the cost column to correctly adjust based on color(s) selection.
    • Furnisher: Frosty Fir
    • Furnisher: Exotic Canopy Bed
    • Furnisher: Drum
    • Furnisher: Exotic Carpet
    • Furnisher: Striped Pillow
    • Furnisher: Patterned Pillow
    • Furnisher: Pile of Pillows
    • Furnisher: Large Pile of Pillows
    • Furnisher: Small Pumpkin
    • Furnisher: Large Pumpkin
    • Furnisher: Carven Chair
    • Furnisher: Carven Bench
    • Furnisher: Carven Table
    • Furnisher: Tan Enamel
    • Furnisher: Grey Enamel
    • Furnisher: Pink Enamel
    • Furnisher: Violet Enamel
    • Furnisher: Navy Enamel
    • Furnisher: Lime Enamel
    • Furnisher: Aqua Enamel
    • Furnisher: Maroon Enamel
    • Furnisher: Brown Enamel
    • Furnisher: Gold Enamel
    • Apothecary: Aforementioned enamels placed in the finished goods table.
    • Distillery: Aforementioned enamels placed in enamels table.
    • Distillery: Aforementioned enamels are now selectable modifiers for mug calculations.
    • Shipyard: Longship
[edit]

Version 5.11

Released: June 2, 2007

[edit]

Version 5.1

Released: June 1, 2007

[edit]

Version 5.0

Released: February 6, 2007

  • Added
    • Multi-Language Support
    • Detailed Analysis Page (Rakkii)
    • Chart Sheet (Shows graphs based on data in $ Analysis Sheet) (Rakkii)
    • Commodities Sheet (Starting values for using the tool as a "Linked" version) (Rakkii)
    • Furnisher: Potted tropical plant
    • Furnisher: Skeleton Chair
    • Furnisher: Skeleton Table
    • Furnisher: Skeleton in Shackles
    • Furnisher: Pile of Bones
    • Furnisher: Gibbet
    • Furnisher: Tombstone
    • Furnisher: Fireplace
    • Ocean: Opal
    • Language: German (Partial)
  • Bug Fixes
    • Analysis page now uses correct numbers for Net Worth and Debts
[edit]

Version 4.53

Released: July 10, 2006

  • Bug Fixes
    • Furnisher: Changed Fancy Bed recipe to include 2 white enamel, not 2 black enamel.
[edit]

Version 4.52

Released: July 9, 2006

  • Added
    • Furnisher: Color Selection for Vase with plant
    • Furnisher: Color Selection for Potted palm
  • Bug Fixes
    • Furnisher: Changed "Apothecary Size" to "Furnisher Size"
    • Furnisher: Correctly Relabeled 2nd Globe Table entry to Harpsichord.
  • Removed:
    • Shop Log Parser (See Version 4.5 or 4.51 for this tool)
    • ShopTool: Linked Version (See Version 4.5 or 4.51 for this tool)
    • Investment Tracker (See Version 4.5 or 4.51 for this tool)
[edit]

Version 4.51

Released: July 2, 2006

  • Added
    • Furnisher: Sofa
    • Furnisher: Harpsichord
[edit]

Version 4.5

Released: July 1, 2006

  • Added
    • Tailor: Boots with Gaiters
    • Tailor: Fez
    • Tailor: Wig (Male and Female)
    • Tailor: Diving Helmet (Male and Female)
    • Tailor: Loose Pants with Sash
    • Tailor: Kilt
    • Tailor: Belt and Bracers
    • Tailor: Curled Slippers
    • Tailor: Ornate Headdress
    • Tailor: Bloomers
    • Tailor: Midriff Blouse with Scarf
    • Tailor: Tabard
    • Tailor: Enamels (Orange, Yellow)
    • Tailor: Premium Doubloon Delivery Fees for Black and Purple
    • Linked Version of the Shop Tool
  • Removed
    • Shipyard: Unused paints for Bludgeons (Yellow and Violet)
  • Bug Fixes
    • Shipyard: Fixed errors in tax calcuations for Bludgeons that could cause the tax number to be off by a few poe
    • Furnisher: Fixed bug where some enamels weren't added into the costs for some items
    • Added some more manual tax values for items not yet listed in the tax tables
  • Sheet Maintenence
    • Added comments to formulas for easier editing in the future
    • Replaced single addition functions with MMULT to be consistent with rest of formula where applicable
    • Apothecary: Added "Unit Count" column to eliminate future bugs resulting from copy/pasting formulas in Dock-Side sales section
    • Weavery: Added "Unit Count" column to eliminate future bugs resulting from copy/pasting formulas in Dock-Side sales section
[edit]

Version 4.41

Released: May 8, 2006

  • Bug Fixes
    • Shipyard: Aligned labor calculator.
    • Distillery: Mug Enamel counts are now correct
  • Added
    • Furnisher: Clawfoot Tub
    • Furnisher: Globe Table
    • Furnisher: Globe
    • Furnisher: Bench with Back
    • Furnisher: Fancy Bar Segments (5 Total)
    • Furnisher: Bar Segments (5 Total)
    • Furnisher: Vase with Plant
    • Furnisher: Potted Palm
    • Ocean: Hunter
  • Removed
    • Ocean: Indigo
[edit]

Version 4.40

Released: March 30, 2006

  • Bug Fixes
    • Apothecary: Networth for finished products no longer adds some items twice
    • Furnisher: Recipe for Fancy Bed updated (now 2 colors)
    • Furnisher: Recipe for Fancy Chair updated
    • Furnisher: Prices for items using cloth now computes correctly
    • Monger: Recipe for Falchion
    • Monger: Cannonballs now include rent costs when applicable
    • Tailor: Prices for items using cloth now computes correctly
  • Added
    • Furnisher: Rumble Pits
    • Furnisher: Bludgeon Trunks
    • Shipyard: Bludgeons
[edit]

Version 4.32

Released: January 16, 2006

  • Bug Fixes
    • Re-colored Weaver sheet, reducing file size by 2 MB.
[edit]

Version 4.31

Released: January 14, 2006

  • Added
    • Financial Analysis Tab
  • User Interface Changes
    • Moved Varnish/Lacquer to Misc product category
  • Bug Fixes
    • Fixed Varnish/Lacquer dockside cost formulas (was dividing by 7 units instead of 10)
    • Fixed Furnisher recipes: Little Chest, Spades Table
[edit]

Version 4.3

Released: January 9, 2006

  • Added
    • Doubloons to all applicable recipes
    • Doubloon delivery costs to all products available for dock-side or rack sales and pre-made ships.
    • Accounting records to all shops
    • ActiveX buttons to show/hide financial records/weekly labor features on each sheet
    • weekly labor records for more accurate estimates on labor used/day.
    • Shop Doubloons to the estimated net worth section
    • Upper Limit of commods used in all recipes.
    • Minimum Suggested Stock to bottom of recipes.
  • User Interface Changes
    • Removed graphics from individual shop sheets
    • Minor design tweaks/cleanups

Apothecary

  • Added
    • Item: Skin Tone Elixir
    • Item: Universal Hair Dye
    • Item: Hair Control Tonic
    • Item: Beard Control Wax
    • Item: Leg Regeneration Draught
    • Item: Hand Regrowth Salve
    • Item: Patch-Eye Remedy

Distillery

  • Added
    • Cost/Proof column to dock-side sales area
    • Pre-Made Mugs field to net worth. The total value of pre-made mugs must be entered manually at this time
  • Bug Fixes
    • Updated Mug recipes
    • Swapped Pitcher and Horn to match in-game order of mugs

Iron Monger

  • Moved shot above swords to be consistent with Distillery page

Tailor

  • Added
    • Item: Musketeer Hat
    • Item: Jerkin
    • Item: Muffin Hat
    • Item: Buccaneer Jacket
  • Bug Fixes
    • Updated all recipes

Furnisher

  • Added
    • Item: Festive Fir
    • Item: Holiday Wreath
    • Item: Display Case
[edit]

Version 4.2

Released: September 16, 2005

  • Bug Fixes
    • Furnishing Shop Recipes (Thanks: Crazyluigi)
    • Other recipe bugs
[edit]

Version 4.11

Released: August 22, 2005

  • Added
    • Sage Ocean Support
  • Bug Fixes
    • Various recipes
[edit]

Version 4.1

Released: August 11, 2005

  • Added
    • Pre-Made Ship inventory (Author: Clinton)
    • Varnish/Lacquer to Apothecary
    • Title Sheet
  • Removed
    • Unused minerals from Tailor Shop
[edit]

Version 4.0

Released: May 24, 2005

  • Added
    • Gold Ore/Cloth/Paint to the tool
    • Mugs to the Distillery
    • Support for all oceans (currently: Midnight, Cobalt, Viridian, Ice)
    • Approximate net worth information
    • Brief documentation in MS Word .doc file
    • Stock column for finished goods
  • User Interface Changes
    • Overhauled Distillery page to look similar to other shop pages
    • Minor UI Tweaks
  • Bug Fixes
    • Recipe for crowns in the Tailor sheet
    • Various calculation errors
    • Max labor numbers on the Tailor and Apothecary pages
[edit]

Version 3.61

  • Bug Fixes
    • Calculation error in Iron Monger that caused all swords to use Leushite buy prices instead of charged prices
    • Bug in Apothecary sheet that caused pink paint to incorrectly use Tellurium instead of Serandite.
[edit]

Version 3.6

  • Backend
    • Modified tax system to avoid tweaks with each new game patch
  • Bug Fixes
    • Bug in Tailor sheet that ignored Fine Cloth for all calculations
    • Bug in Iron Monger where only 1 unit of enamel was factored in despite swords taking multiple units
    • Column width bugs relating to all things black
    • Calculation errors in Weavery for sail cloth.
[edit]

Version 3.5

  • Added
    • Web query for tax values
    • New graphical interface
  • Backend
    • Overhauled tax system to account for new tax listings
    • Reduced file size from 3.11 by roughly 25% (600k)
  • Bug Fixes
    • Errors in Apothecary Dock-Side sales formulas for Enamel and Paint
    • Minor typos
  • Removed
    • Inventory sheet
    • Dynamic tax calculations
[edit]

Version 3.11

  • Fixed calculation error in Rent/Labor_Unit equations.
[edit]

Version 3.1

  • Added
    • Dynamic Tax Calculator (Author: Quizzical)
  • Bug Fixes
    • Corrected minor typos
[edit]

Version 3.0

  • Added
    • New Apothecary items (Paint, Enamel, Paint Brush)
    • Hyperlinked shop pictures for easier navigation
    • Rent equations to figure rent/unit of labor into costs for each item
    • Current stock numbers for each commod across all shops. (Currently this does nothing)
    • Shoppe-Side sales and Dock/Rack-side sales to better show actual costs
    • Profit margin to all items
    • Cost/proof to distillery sheet
  • User Interface Changes
    • Changed to new universal interface design for all shoppes (except Distillery)
    • Reorganized all commodities in recipes, tax table and inventory into groups defined in-game after the Apothecary patch
  • Removed
    • Broke the master inventory sheet
    • Weighted labor calculator
Retrieved from "http://yppedia.puzzlepirates.com/The_Shop_Tool/Changelog"
Views
Personal tools
navigation
MediaWiki
Attribution