1. Hello!

    First of all, welcome to MapleLegends! You are currently viewing the forums as a guest, so you can only view the first post of every topic. We highly recommend registering so you can be part of our community.

    By registering to our forums you can introduce yourself and make your first friends, talk in the shoutbox, contribute, and much more!

    This process only takes a few minutes and you can always decide to lurk even after!

    - MapleLegends Administration-
  2. Experiencing crashes with 'Unknown Error'? Make sure you are on the latest MapleLegends version. The current latest version is found by clicking here.
    Dismiss Notice

(WIP) FM Price Google Spreadsheet

Discussion in 'Items & Mesos' started by Precel, Nov 28, 2018.

Thread Status:
You must be a logged-in, registered member of this site to view further posts in this thread.
  1. Precel
    Online

    Precel Game Moderator Staff Member Game Moderator

    269
    58
    246
    Nov 13, 2018
    Male
    8:30 AM
    Precel
    Priest
    90
    ThotzRUs
    LAST UPDATED: 04/06/19
    WARNING: Since the recent patch, the prices have changed significantly. I'm in process of adjusting values one by one, but please understand it's a tedious work. Please see the announcement below for certain measures I took to improve accuracy.


    LINK: https://docs.google.com/spreadsheets/d/1rPyS9Q00-9Zuum8RliAEPkUk3O3gkpydsB5ip_mJ7js/edit?usp=sharing

    Please read the README in the spreadsheet first if you have any questions.

    Summary:
    This is a spreadsheet of each item's prices in FM. I built this by manually entering prices of items being sold at the time in FM. The main purpose of the spreadsheet is to price check all items at one place. Pease expect some inaccuracy due to manual editing error, not enough data, out-of-date data, under/over-selling by store owners, duplicate data, and so on. I've noted cells that especially seems inaccurate.

    Obviously a lot of items are missing and it's a slow progress, so please be understanding.

    Announcement:

    3/14/19

    I'm back to editing the spreadsheet!

    You might notice a different color for some items. The color means that the old data have been purged for that item except the minimum, average, maximum price (if there are more than 3 prices) and new prices have been added.

    Also, old data have been grayed out a bit to distringuish between new and old data

    This is done to provide the most current price point. Current spreadsheet has prices from November of last year, so it's about time I stir the pot.

    EDIT: I made a copy before editing the main spreadsheet. You can see it here if you wish: https://drive.google.com/open?id=1_-3LuME9zpPKpcIKHX9j9kZGjJbdpRYxMuHu-h6EYxU

    EDIT 2: Format improvements incoming. Please give me some feedback of how you like the new formatting.

    I will be taking a break from maple due to personal reasons. So this guide will not be updated until I come back.

    I think I'll be back around April, but I'm not sure.

    If you put service/specialty store request, I'll probably process it at a delay.
    Similar to "Specialty Store" sheet, I am looking for anyone who would like to advertise their services (Fame, ZHelm, Horntail, SMega/Owl, Leech, etc.)

    Please reply on this thread with following details, if you would like to be advertised.
    Service: ZHelm 15m w/ Free reloot
    Provider: Precel
    Usual time for the service (server time): 6 PM - 9 PM
    Contact: Discord Precel #????, Whisper PrecelMule in-game
    Note:

    This will replace current "Service" sheet, in hopes of it being more useful.
    I just had an idea of how you can contribute without potentially inputting inaccurate/biased data into the spreadsheet!

    As of 12/27/18, I will start to accept screenshots of The Owl of Minerva of an item. if you'd like to help me build the spreadsheet, please upload the screenshots on this thread :)

    Please make sure all pages of The Owl of Minerva are included, so that we are not missing any prices. I won't be able to use it otherwise, due to possible bias and inaccuracy.
    If you have a specialty store, please leave a reply to be advertised on the spreadsheet!
    This will reduce players having to use The Owl of Minerva for cheap items.
    By specialty store, I mean stores that only sell certain types of items. For example, ETC shops, NLC potion shops, All Cure Potion shops, and so on. This does not include scroll shops.
    Please reply only if your shop does not move, does not change products often, and is open for a long time.

    Shop Title: All Cure Potion, Power Elixir CH5 FM10
    Shop Owner: Example
    Location: CH5 FM10
    Specialty Items: All Cure Potion, Power Elixir, Elixir
    Restocks daily

    Shop Title: Cheap stuff
    Shop Owner: Example2
    Location: Varies
    Specialty Items: Maple Shield, Bathrobe, 60% ATT for Claw

    More Information:
    I am not looking for anyone to edit with me, since we might put in same item from same shop and it'd mess up the average price.

    Though I'm looking for suggestions/helps with formatting of the spreadsheet!

    If you are interested in contributing, you can post screenshots of The Owl of Minerva you used.
    Please make sure all pages of The Owl of Minerva are included, so that we are not missing any prices. I won't be able to use it otherwise, due to possible bias and inaccuracy.


    ADD MOAR DATA
    Add scrolls sold by NPC

    Release monthly statistics
    Add a column for total number of data
    Glossary in README (terminologies like WATT, ACC, etc.)

    Link each item to dictionary (Not possible until lib is back)
     
    Last edited: Apr 8, 2019
    • Like Like x 6
Thread Status:
You must be a logged-in, registered member of this site to view further posts in this thread.

Share This Page