• Aggressive
  • Alienated
  • Amazed
  • Amazed2
  • Amused2
  • Angelic
  • Angry2
  • Apelike
  • Artistic
  • Balanced
  • Bashful
  • Blah
  • Bookworm
  • Bored
  • Breezy
  • Brooding
  • Busy
  • Chatty
  • Cheeky
  • Cheerful
  • Cloud 9
  • Cold
  • Confused
  • Cool2
  • Creative
  • Curious
  • Cynical
  • Daring
  • Devilish
  • Disagree
  • Doh
  • Doubtful
  • Drama Queen
  • Dreaming
  • Elated
  • Energetic
  • Fiendish
  • Fine
  • Gloomy
  • Goofy
  • Grumpy2
  • Happy2
  • Hot
  • In Pain
  • Innocent2
  • Insomnious
  • Inspired
  • Lonely
  • Lucky
  • Lurking
  • Mellow
  • Mischievious
  • Monday Blues
  • Musical
  • Nerdy
  • No Mood
  • Not Amused
  • Notworthy
  • Paranoid
  • Pensive
  • Predatory
  • Procrastinating
  • Psychedelic
  • Relaxed
  • Sad2
  • Scared
  • Scurvy
  • Shocked
  • Sick
  • Sleeping
  • Sleepy
  • Sluggish
  • Sneaky2
  • Snobbish
  • Spooky
  • Sporty
  • Starving
  • Stressed
  • Sunshine
  • Sweet Tooth
  • Thinking
  • Torn
  • Twisted
  • Vegged Out
  • Volatile
  • Woot
  • Worried
  • Yee Haw
  • Amused
  • Angry
  • Annoyed
  • Arrg!
  • Awesome
  • Bemused
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Grumpy
  • Happy
  • Hungry
  • Innocent
  • Meh!
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • At Work
  • Eating
  • Editing
  • Lagging
  • Netflix
  • No Status
  • PC Gaming
  • PS Gaming
  • Raging
  • Sleeping2
  • Steam Gaming
  • Trolling
  • XBox Gaming
  • Youtuber
  • Zombies
  • Page 2 of 3 FirstFirst 123 LastLast
    Results 11 to 20 of 26
    1. #11
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Quote Originally Posted by Rayzer View Post
      What's single=true?

      "... spreadsheet/ccc?1SyFJrry0zEX2JtlL0zSeDtv2Zw9OZKYuNd6DCS6AgzY&a mp;hl=en&single=true& ..."
      Oh my gosh! That's the piece of code that's been giving me so much trouble! The "single" parameter was responsible for only allowing the spreadsheet's first sheet to be visible.

      So, in order to set that parameter to false, I had to append "&single=false" at the end of the spreadsheet's ID string inside the [GS] tags.

      Code:
      [GS]1SyFJrry0zEX2JtlL0zSeDtv2Zw9OZKYuNd6DCS6AgzY&single=false[ /GS]
      I'm shocked that it works like that, but okay, we're good to go!

      Once again, thank you so much !

    2. #12
      Rayzer's Avatar
        Rayzer is offline Exalted

      • Rayzer's Wizard Stats
        •  Wizard's Name:
        •  The Fairycaller Clan
        •  Wizard's Level:
        •  120
        •  World:
        •  Mirage
        •  Wizard's School:
        •  Life
        •  Pet's Name:
        •  Moose
        •  Pet's Type:
        •  Bloodbat
      Status: On the Rayzer's Edge!
       
      Mood:
      Awesome
       
      Join Date
      Sep 2011
      Posts
      10,641
      PvP Tournaments Won
      0
      Thanks (Given)
      1040
      Thanks (Received)
      7094
      Gold
      1,259.42
      Blog Entries
      1

      Re: Project O's Data

      Glad I could help. I guess code is code is code, as I've never seen that "language" before, aside from a little xml.
      Thanks to Ashley Frost for the Signature


    3. #13
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hello everyone,

      I just want to quickly let everyone know that we've updated our talent and derby ability order data. Additionally, simplified versions of our traditional databases are now being supported; they'll be replacing the old "Ordered List" sheets, may they rest in peace. You can find them by clicking on the "Simplified Data (Talents)" and "Simplified Data (Abilities)" tabs.

      Enjoy!
      -Milt
      Last edited by Milt; 9-15-18 at 8:12:23 PM.

    4. #14
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Good morning everyone,

      With 2018 drawing to a close, I went ahead and updated our databases to comply with our new format for 2019.

      We've made the following changes to our public databases:

      • The "Simplified Data" sheets now include links to the Wizard101 Central Wiki for each talent!
      • The "Unranked Table" sheets have been tentatively renamed to the "Full Data" sheets -- this name change will not be extended to our workbooks.
      • The "Full Data" sheets now contain a new column for wiki-named talents as well.
      • The rarity IDs for Unknown, Common, Uncommon, Rare, Ultra-Rare, and Epic are now zero (0), one (1), two (2), three (3), four (4), and five (5) respectively -- in other words, all rarity IDs used prior to 2019 were incremented by one.
      • All rankings are now formatted as ranges ("000-000!").
      • Unranked lists no longer use commas as their delimiters; they now use semicolons ( ; ) instead.
      • And finally, All instances of "Num Poss" have been shortened to "Poss" -- Project O has long since deemed the original term to be archaic, so we'll be formally adopting its shortened variant exclusively moving forward.


      Thanks for reading, and enjoy!
      -Milt
      Last edited by Milt; 12-16-18 at 11:46:18 AM.

    5. #15
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Updated the talents portion of the database; didn't bother checking the derby ability stuff though.

    6. #16
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hello everyone.

      I've recently finished migrating our old task board over to our databases on Google Sheets. You can access our new task board by clicking the "Task Board" tab on the embedded spreadsheet in this thread's OP.

      Not much was changed during the transition. The "Difficulty" section for each section was renamed to "Difficulty Rating", which will now range from 1 to 5 -- 1 being the simplest and 5 being the toughest. Tasks with a difficulty rating of 5 will generally require pet training. Difficulty mechanics will be subject to change whenever necessary.

      Oh, and I hope you all like the new color themes .

      Thanks for reading!

    7. #17
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hello again.

      Another important change to our databases has been carried out. Moving forward, the unranked list columns of our simplified data sheets and full data sheets will be following the Wizard101 Central Wiki's naming conventions. This means that "Spell Proof" will finally get its hyphen back, "No Pain No Gain" will finally get its comma back, and "Balanceblade (DrGr)" will earn its old "(Card)" badge back.

      The reason behind this change is to finally make good on our promise to follow the Wiki's naming conventions on our simplified data sheets exclusively. Truth be told, our simplified data sheets are actually full data sheets with three (3) columns ripped out; so up until now, their unranked lists were following our own naming conventions instead. This issue has certainly been bothering me for months, but I've never been able to find a satisfactory solution. I have considered making our database manager pump out two sets of unranked lists (each one for our full and simplified data sheets) but such a solution would've ballooned our workbooks' file sizes for little to no benefit -- and I don't like keeping dead weight around. I've also considered converting each talent within the unranked lists into numbers -- and I'm still tempted to experiment with it further -- but that's going to take some time. Applying the Wiki's naming conventions directly just so happened to be the easiest and the safest to reprogram.


      That said, there were reasons why I hesitated to adopt this particular solution for so long. Back in September 2016, when a second variation of the "Cycle of Life" talent was discovered, the Wiki was originally against letting it have its own page due to how nearly undetectable it was until a week or two later. Granted, the Cycle of Life situation was extremely bizarre for its time, and the Wiki has since introduced disambiguation pages in preparation for future situations like it -- but if the Wiki were to decide against recognizing future duplicate talents, then Project O would be forced to give them sort names (in order to prevent our tools from malfunctioning) and URLs to wikipages that don't exist.

      The Wiki does have very good relations with Project O, so I highly doubt they'll hesitate to create pages for future cycle-of-life-like talents, but a risk is still a risk, and I'm counting on it to pay off.

      Another reason why I was so hesitant was due to what I'll call the "Semicolon Question". If KingsIsle were to introduce a new talent with a semicolon ( ; ) in its name, then its page name on the Wiki would almost certainly contain it too. Such a scenario would be catastrophic for Project O, since our workbooks rely pretty heavily on semicolons as list separators; in fact, our workbooks treat them like an illegal character in all talent names. Our own naming conventions allowed us to avoid this issue entirely; but under the Wiki's naming conventions, we no longer have this luxury. I will say, if we ever had to replace our semicolons with any other character, it would have to be the humble pipe ( | ) -- which is coincidentally an illegal character under both conventions -- but I'll have to admit, I don't think it would make our unranked lists look pretty. Hopefully, we'll never have to address this "Semicolon Question".


      And for those wondering how this change will affect our workbooks: it's practically nonexistent. Talents get converted into numbers under the hood, they'll just be piped to the wiki-names column instead of the sort-names one. In fact, the current workbooks do this already... which is why they're actually not working properly. Sorry about that. At least that "mistake" will be fixed in version update 8.2.1.

      Thanks for reading!
      Last edited by Milt; 8-28-19 at 5:34:52 PM.

    8. #18
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hey everyone.

      Right now, we are, like, extremely close to reaching 100% completion on the derby ability order list: an impressive achievement that we've been trying to reclaim since July of 2012.

      As of writing, only four derby ability combos remain unranked:

      (1) Weaken vs. Ultra Exhaustion
      (2) Think Fast! vs. Dawdle
      (3) Stumble On vs. Dirt Post
      (4) Upset vs. Big Drain

      The Hatchmaking Kiosk has been absolutely instrumental in helping us reclaim our 100%, so we should continue to keep our eyes on it for future leads. As an incentive, I'm willing to reward any Central member who can solve or submit screenshots for any of these four unranked combos 250 forum gold each.

      Thanks for reading!

    9. #19
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hey all.

      I updated the databases for both talents and abilities this evening. No new data was added nor do I plan on adding any new data. The purpose of this data was to simplify and future-proof Project O's talent naming conventions.

      The new conventions are as follows:
      1. The very first letter and all letters immediately following a space are always capitalized. (e.g. Rage Of Winter vs. Rage of Winter)
      2. All remaining letters are always lower-case. (e.g. Snowborn vs. SnowBorn)
      3. All hyphens (-) are replaced with a single space. (e.g. Slick N Slide vs. Slick-N-Slide)
      4. All other punctuation marks except the apostrophe (') are always omitted. (e.g. Sword And Shield vs. Sword and Shield!)
      5. All duplicate talent names contain parentheticals enclosed by parentheses. (e.g. Cycle Of Life (Battle C) vs. Cycle of Life)
      6. All parentheticals are determined solely by the talent's pet of origin (e.g. Cycle Of Life (Battle C) first originated from the Battle Cherub)
      7. The first word in the pet of origin's name is always capitalized and spelled out in full.
      8. Each word thereafter in the pet of origin's name only require the first letter but may be fully spelled out if needed. (e.g. Cycle Of Life (Battle Cherub))
      9. If duplicate talent names share the same pet of origin, differentiate them with their slot number of origin. (e.g. Epic Shot (Ebon S 4))


      These conventions only apply to base names and sort names. Wiki names will continue to follow the Wiki's naming conventions with one notable exception: duplicate talents without any parentheticals on the Wiki will be marked with their Project O equivalents enclosed with curly brackets (e.g. Relentless 2 {Heckhound C}). This exception is necessary because Project O's calculation tools require all talents to have unique wiki names in order to calculate talent order properly. Parentheticals with curly brackets will remain in use until the Wiki declares their own parentheticals.

      And finally, base names are sort names with single-digit rarity IDs in front. The rarity IDs are as follows:

      Rarity ID Rarity Name Example
      0 Unknown 0Unknown |A1|
      1 Common 1Life Boon
      2 Uncommon 2Fairy Friend
      3 Rare 3Spritely
      4 Ultra-Rare 4Batusi
      5 Epic 5Unicorn


      Anyone who wants to take over Project O may do so. I'm pretty much done.

      Thanks for reading and enjoy the update.

    10. #20
        Milt is offline Archmage Wizard

      • Milt's Wizard Stats
        •  Wizard's Name:
        •  Justin Goldenbrand
        •  Wizard's Level:
        •  130
        •  World:
        •  Empyrea
        •  Wizard's School:
        •  Balance
        •  Pet's Name:
        •  Lady Hunter
        •  Pet's Type:
        •  Oppossum
      Status: Somewhat inactive
       
      Mood:
      ----
       
      Join Date
      Aug 2008
      Posts
      8,049
      PvP Tournaments Won
      0
      Thanks (Given)
      5896
      Thanks (Received)
      9463
      Gold
      34,851.36
      Blog Entries
      207

      Re: Project O's Data

      Hey everyone,

      I know I said my project-managing days were done - and I'd still like to hand the reins over to somebody else - but the introduction of a certain "quirk" in the talent system had forced me to come back and deal with it personally. Project O now has a standard formatting policy in place specifically for unlockable talents: locked talents are marked with a hash (#) between brackets and unlocked talents are marked with an underscore (_) between brackets.

      There's only one talent in our databases which bare this feature as of writing: Myth Finder.

      Talent Name Explanation
      Myth Finder {#} This is the locked version of Myth Finder.
      Myth Finder {_} This is the unlocked version of Myth Finder.

      If it helps, try visualizing the hash symbol as an upright fence and the underscore as a tipped-over fence. These symbols were deliberately chosen to make spotting a locked or unlocked talent in the database easier at a glance.

      I spent the past few hours collecting new talent-order data, making this the first update in a very long while for both databases. Who knows? If any of you out there are up to hit the kiosk for some more data, I just might update the databases again.

      Eh, one can hope. Enjoy the update regardless!
      Last edited by Milt; 6-26-20 at 9:48:52 PM.

    Page 2 of 3 FirstFirst 123 LastLast

    Tags for this Thread

    Bookmarks

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •