Important PJD Progress Spreadsheet!

[format=h1]SPREADSHEET LINK[/format]
(UPDATED 8/19/2016: ALL GAMES INCLUDED, formula simplified)

​

[format=h2]TO USE:[/format]

- Go to File > Make a Copy and edit in any DLC you want (see TO EXPAND).​

- Copy and paste a golden crown into any tile you achieve a perfect on.​

- Click on any cell in the song list and use the background color changer to track clears, greats, and excellents.​

​

[format=h2]TO EXPAND:[/format]

All you have to do is add the titles to the bottom of the game you want to add them to, and then change the formula in the overall Perfect Count cell.​

​

Example:​

- Project Diva F 2nd has 40 songs without DLC, 45 with DLC.​

- Multiply 40 by 4 (4 difficulties), which is 160.​

- Multiply 45 by 4, which is 212.​

- Click on the cell containing the crown-counting formula, and find 160 in the formula.​

- Replace 160 with 212.​

​

If you need help making an alteration to the sheet and can't figure it out, post about it and I'll try to help you! Or maybe someone else can.​

​

[format=h2]NOTES:[/format]

NONE OF THE GAMES HAVE THEIR DLC! You are free to add it at your own leisure.​

​

Miracle Girls Festival is on the sheet, but if you don't have it you can always delete it with the process above. Delete all the information and the formatting, and then find the corresponding ROW/COLUMN part of the formula in the Perfect Count cell and erase it. Alternatively, simply remove it from the formula in case you plan on getting it later.​

​

I do not know how many Extremes and Extra Extremes there are in Project Diva Future Tone. If someone could provide me with a list I will update the sheet, but currently the spreadsheet is set to count every tile in Extreme and Extra Extreme if you put a crown there. However, Extra Extreme is not accounted for in the "2107" songs, so it is possible to have more than 2107 perfects right now, if you perfect every song on the spreadsheet.​

​

Don't put crowns in non-song squares. The sheet will count them in your perfect total, the only way to fix this is to hand select every song section of every game which will take forever and probably be extremely slow to process.​

​

[format=h2]PICTURES:[/format]

[format=cust2]

Spoiler: PERFECTS

Spoiler: INCOMPLETE DISCO

[/format]​

 

It wasn't too bad to make! I haven't had a lot of time to play Project Diva for awhile now, but back when I made the list I went really hard to try and finish the first game and almost did, but a couple of those last songs eluded me and I moved on to 2, but I didn't get very far (didn't even perfect all of easy mode). But have faith in yourself! You can get those perfects, just keep on tryin'.

I haven't added Project Diva Future Tone yet, although that is an absolutely amazing entry to the series and I was thrilled by it. I was waiting until I even got anywhere near it (never?) to add it to the perfect list, though. If anyone is actually using this or wants an update though, drop a line, I'll add it in a jiffy.

Look how pretty it looks when you start getting those perfects... that's motivation enough!

Spoiler: Big honkin' picture

 

Had some free time this morning and decided to go ahead and add Project Diva Future Tone, Project Diva X, and spiff the thread up all pretty for ease of future users.

Drop a comment and let me know how it goes if you use it, everybody!

 

Oh my goodness gracious! That's wonderful, I'm so happy you've been using it! I was wondering if anyone had been at all; I don't know of anyway that I can know how many copies have been made or anything. That looks very nice! I'm glad you gave it your personal touch and everything, that really makes me feel great! I'm glad I could make something that people could find use in.

Hopefully with the thread updates and the easier to read formula people can edit it and use it more easily.

Eeeeee, I'm really happy

P.S. - You're missing a leftmost border on one of those PDF2nd songs. Heheh. (Drives me crazy when the spreadsheet won't cooperate and leave them how they're supposed to be.)

P.P.S. - Is it just me or are easy songs like 5x harder to perfect than hard songs?