|
|
View previous topic :: View next topic |
Author |
Message |
Icemage
Joined: 11 May 2008 Posts: 3200
|
Posted: Sat Aug 01, 2009 4:47 pm Post subject: |
|
|
Ok, version 1.00 of the squeeze tracking spreadsheet is done.
You can download it here:
http://rapidshare.com/files/262567633/VocalSqueezing_v1.00.xls.html
You'll need Microsoft Excel 2003 or later, and you'll need to Enable Macros when you open the spreadsheet.
There are three buttons on the top of the page.
Calculate sorts the list and provides all split scores (green columns). For more details about how this works, continue to the end of this post.
Forum creates a text file in the same location as the spreadsheet (whereever you place it on your computer) called VocalSqueezingBBCode.txt. Open that file in Notepad or WordPad or your favorite text editor, copy it, and paste it directly into a post.
Details will show or hide all of the scoring columns except the Final Score, Optimal Score, and Location. This makes it a little easier to enter scores since it lets you jump to the end of the columns without scrolling all the way over.
Data requirements:
- I've already input placeholders on all 84 on-disc songs.
- Paths must be in "#/<notes>" format, where you have a single digit in front of the slash. Anything may be placed after the slash (FRS, sk, AT, !, whatever). Ending commas are ignored, so you can choose to use them or not, your choice.
- You must provide either an overdrive split score or a percussion split score in each set of columns, and there must be the same number of overdrive split scores as there are overdrive activations in the path.
- An optimal final score must be provided for the given squeezes, as well as the highest known recorded score.
- The Location field currently does nothing. If this list does expand beyond RB2, I will expand the processing code to sort the songs accordingly.
Please send me a PM or post here with questions on how to use the spreadsheet.
---
This is what the spreadsheet currently produces:
A Jagged Gorgeous Winter: 2/ (+0), 3/sk1 (+368), 3/ (+0)
. [30000, 110368, 202368] => 214,368 (Vicroman20)
Ace of Spades '08: 2/ (+0), 2/ (+0), 2/BOD (+0)
. [30000, 58000, (T) 70250, 94250] => 98,250 (RipleyLV426)
Alabama Getaway:
Alex Chilten:
Alive:
Almost Easy:
American Woman:
Any Way You Want It:
Aqualung:
Bad Reputation:
Battery:
Bodhisattva: , 2/ (+0), 3/ (+100)
. [(T) 13250, 67250, (T) 82250, 154350] => 167,550 (Icemage)
Carry On Wayward Son:
Chop Suey!:
Colony of Birchmen: 3/sk1 (+0), 2/RS (+0), 4/ (+0)
. [86000, 126000, (T) 128875, 204875] => 210,000 (RipleyLV426)
Come Out and Play (Keep 'em Separated):
Conventional Lover:
Cool for Cats: 3/ (+3132), 4/AT (+1250)
. [61132, 162382] => 166,382 (RipleyLV426)
De-Luxe: 2/ (+224), 3/ (+2592)
. [54224, 124816] => 128,816(-4) (RipleyLV426 / Kruasa)
Down with the Sickness:
Drain You: 2/ (+1240), 2/BOD (+1340), 4/ (+1040)
. [39240, 88580, 153620] => 153,620(-72) (IndestructibleSD)
E-Pro:
Everlong:
Eye of the Tiger:
Feel the Pain:
Float On:
Get Clean:
Girl's Not Grey: 2/sk1 (+1750), 2/sk1 (+0), 3/sk1 (+0)
. [35750, 79750, 147750] => 155,750 (RipleyLV426)
Give It All:
Give It Away:
Go Your Own Way:
Hello There:
Hungry Like the Wolf:
I Was Wrong:
Kids in America:
Lazy Eye:
Let There Be Rock: 3/sk1 (+2380), 4/, 3 (+2500), 4/, 3 (+2706)
. [76380, 170880, 213586] => 234,711 (RipleyLV426)
Livin' on a Prayer:
Lump:
Man in the Box:
Master Exploder:
Mountain Song:
My Own Worst Enemy:
New Kid in School:
Night Lies:
Nine in the Afternoon: 3/ (+0), 3/ (+88), 3/ (+0)
. [74000, 142088, 214088] => 218,088 (RipleyLV426)
One Step Closer:
One Way or Another:
Our Truth:
Painkiller:
Panic Attack:
PDA:
Peace Sells: 2/ (+0), 2/ (+1068), 3/AT-sk1-EW (+100), 2/EW (+0)
. [34000, 75068, (T) 106068, 138168, 178168] => 210,168(+16) (IndestructibleSD / Brunaleskim)
Pinball Wizard:
Pretend We're Dead:
Psycho Killer: 4/ (+0), 2/BOD (+0), 2/! (+1828)
. [86000, 146000, 171828] => 197,328(-36) (WhYYZ)
Pump It Up:
Ramblin' Man: 3/ (+0), 2/ (+375), 2/! (+0)
. [66000, 122375, 150375] => 184,875 (RipleyLV426)
Rebel Girl:
Rob the Prez-O-Dent:
Rock'n Me:
Round and Round:
Shackler's Revenge:
Shooting Star:
Shoulder to the Plow: 3/ (+3340), 2/ (+0), 2/ (+0)
. [57340, 85340, 121340] => 137,590 (WhYYZ)
So What'cha Want:
Souls of Black:
Spirit in the Sky:
Spoonman:
Supreme Girl:
Tangled Up in Blue:
Teen Age Riot:
Testify:
That's What You Get:
The Middle:
The Trees (Vault Edition): 2/ (+400), 3/ (+3875), 3/ (+812)
. [42400, 78275, 115087] => 123,087(-64) (IndestructibleSD)
Today:
Uncontrollable Urge:
Visions:
We Got the Beat: 2/sk1-FRS (+0), 3/sk1 (+3996), 2/sk1 (+1016)
. [30000, (T) 45000, 116996, 154012] => 154,012(-12) (IndestructibleSD)
Welcome to the Neighborhood:
Where'd You Go?: 3/sk1FRS (+0), 4/AS (+0)
. [102000, 258000] => 274,000 (WhYYZ)
White Wedding (Pt. 1): 2/BOD (+284), 3/BOD (+0), 2/sk2 (+16)
. [62284, 118284, 154300] => 170,300 (RipleyLV426)
You Oughta Know: _________________
|
|
Back to top |
|
|
IndestructibleSD
Joined: 17 Jul 2008 Posts: 1382 Location: Boston, MA
|
Posted: Sat Aug 01, 2009 7:56 pm Post subject: |
|
|
The path for The Trees should be 2/ 3/ not 2/ 3/ 3/. Also, I got a higher score on the Trees, with last digits of 376 - 119. Not sure how this effects the total points in the final squeeze, but there's definitely more points there :] _________________
dbforthree, Expert Vocalist PS4 |
|
Back to top |
|
|
internetguy87
Joined: 27 Mar 2008 Posts: 3505 Location: Pittsburgh, PA
|
Posted: Sat Aug 01, 2009 8:20 pm Post subject: |
|
|
OP updated again (will get to yours shortly indestructible).
A lot of credit goes to Icemage for his help with excel and getting this set up.
Hope to see this continue well, and look forward to hearing from Vicromano.
Any questions can be asked here, or sent to me in a PM. I think Icemage is also happy to answer questions about the excel file in PM's.
Thanks guys =) _________________
|
|
Back to top |
|
|
Vicromano20
Joined: 02 Dec 2007 Posts: 156
|
Posted: Sat Aug 01, 2009 8:48 pm Post subject: |
|
|
internetguy87 wrote: | OP updated again (will get to yours shortly indestructible).
A lot of credit goes to Icemage for his help with excel and getting this set up.
Hope to see this continue well, and look forward to hearing from Vicromano.
Any questions can be asked here, or sent to me in a PM. I think Icemage is also happy to answer questions about the excel file in PM's.
Thanks guys =) |
EDIT: Ah, screw it, I'll just give them to you now.
Song: Pretend We're Dead Path: 3/sk3, 2/sk2, 3/, 2/sk1
[ 84,608 / 132,132 / 188,192 / 228,244 ] Final: 228,244
Song: Lump Path: 2/sk1, 4/sk1, 3/
[ 34,000 / 106,000 / 144,484 ] Final: 152,484
Song: Lazy Eye Path: 3/, 2/, 2/AT
[ 48,548 / 64,548 / (T) 112,548 / 128,548 ] Final: 128,548
Song: I Was Wrong Path: 2/, 6/AT
[ 50,404 / (T) 148,654 / 192,654 ] Final: 204,654
Song: Hungry Like the Wolf Path: 2/, 2/, 2/, 3/BOD, 2/
[ 40,240 / 81,188 / 119,408 / (T) 141,408 / 193,504 / 225,504 ] Final: 225,504
Song: Hello There Path: 2/, 3/
[ 54,068 / 122,068 / (T) 123,943 ] Final: 127,943
Song: My Own Worst Enemy Path: 3/sk2, 4/sk1
[ 71,712 / 135,712 ] Final: 135,712
Song: Cool for Cats Path: 3/, 4/AT
[ 62,132 / (T) 114,382 / 162,382 ] Final: 166,382
Song: Spirit in the Sky Path: 3/AT/sk1, 3/
[ (T) 34,875 / 64,875 / (T) 71,875 / 137,323 / (T) 153,823 ] Final: 153,823
Song: Man in the Box Path: 2/sk2, 2/, 3/
[ 42,464 / 74,256 / (T) 101,756 / 126,200 ] Final: 134,200
Song: Kids in America Path: 4/sk1, 4/
[ 98,000 / (T) 103,625 / 175,777 / (T) 193,652 ] Final: 193,652
Song: We Got the Beat Path: 2/sk1/FRS, 3/sk1, 2/sk1
[ 30,000 / (T) 45,000 / 117,000 / 154,024 ] Final: 154,024 |
|
Back to top |
|
|
Kruasa
Joined: 20 Dec 2008 Posts: 19 Location: Toronto, Canada
|
Posted: Sun Aug 02, 2009 3:28 am Post subject: |
|
|
@Icemage: The spreadsheet looks great, however the "Forum" button doesn't seem to be working for me. If it helps, Office 2007 on Vista 32-bit Home edition. Macros Enabled before testing (the other 2 buttons work fine).
To the rest of the community: If/When we start doing RB1 Imports, will data from Wii players running RB1 songs through the use of RawkSD be recorded? _________________
|
|
Back to top |
|
|
bclare
Joined: 21 Jun 2008 Posts: 6048 Location: Boston
|
Posted: Sun Aug 02, 2009 4:36 am Post subject: Re: Vocal Squeezing Thread - Now functioning, 18 songs compi |
|
|
internetguy87 wrote: | The final score lists the best end score with current listed squeezes. If the final score is blue, it is below the 360/ps3 optimal. If the final score is green, it is above the optimal. A black final score matches the optimal. |
You say blue, but the below optimal scores seem to be colored red in the actual list. _________________
I'm back I suppose |
|
Back to top |
|
|
Icemage
Joined: 11 May 2008 Posts: 3200
|
Posted: Sun Aug 02, 2009 4:39 am Post subject: |
|
|
Kruasa wrote: | @Icemage: The spreadsheet looks great, however the "Forum" button doesn't seem to be working for me. If it helps, Office 2007 on Vista 32-bit Home edition. Macros Enabled before testing (the other 2 buttons work fine). |
You don't get a text file called VocalsSqueezingBBCode.txt in the same location as the spreadsheet? It doesn't auto-open the file, as I don't like writing apps that call shell commands.
I don't use Vista so I can't test it. In any case, that functionality isn't of concern to anyone except internetguy, so I don't really think it's a big problem either way.
Quote: | To the rest of the community: If/When we start doing RB1 Imports, will data from Wii players running RB1 songs through the use of RawkSD be recorded? |
Personally, I don't think supporting hacked in songs is a very good idea, unofficially or otherwise. Best to let sleeping dogs lie as far as I'm concerned. _________________
|
|
Back to top |
|
|
internetguy87
Joined: 27 Mar 2008 Posts: 3505 Location: Pittsburgh, PA
|
Posted: Sun Aug 02, 2009 6:17 am Post subject: Re: Vocal Squeezing Thread - Now functioning, 18 songs compi |
|
|
bclare wrote: | internetguy87 wrote: | The final score lists the best end score with current listed squeezes. If the final score is blue, it is below the 360/ps3 optimal. If the final score is green, it is above the optimal. A black final score matches the optimal. |
You say blue, but the below optimal scores seem to be colored red in the actual list. |
Oops, I was playing around with the colors and must've not saved my final edit. Just replace blue with red and it makes sense =P, fixing now.
Edit: OP updated, thx Vicromano =). _________________
|
|
Back to top |
|
|
Kruasa
Joined: 20 Dec 2008 Posts: 19 Location: Toronto, Canada
|
Posted: Sun Aug 02, 2009 2:57 pm Post subject: |
|
|
Icemage wrote: | Kruasa wrote: | @Icemage: The spreadsheet looks great, however the "Forum" button doesn't seem to be working for me. If it helps, Office 2007 on Vista 32-bit Home edition. Macros Enabled before testing (the other 2 buttons work fine). |
You don't get a text file called VocalsSqueezingBBCode.txt in the same location as the spreadsheet? It doesn't auto-open the file, as I don't like writing apps that call shell commands.
I don't use Vista so I can't test it. In any case, that functionality isn't of concern to anyone except internetguy, so I don't really think it's a big problem either way. |
Nope, I don't get a text file, but I guess what you say is true; it doesn't really matter if it works for me anyways.
Icemage wrote: | Kruasa wrote: | To the rest of the community: If/When we start doing RB1 Imports, will data from Wii players running RB1 songs through the use of RawkSD be recorded? |
Personally, I don't think supporting hacked in songs is a very good idea, unofficially or otherwise. Best to let sleeping dogs lie as far as I'm concerned. |
Whether or not the community decides to let Wii players help out via RawkSD will probably not be a huge concern anyways. I'm one of few Wii players that would help out anyways. _________________
|
|
Back to top |
|
|
WhYYZ
Joined: 08 Oct 2007 Posts: 3150 Location: The netherlands, Amsterdam
|
Posted: Mon Aug 03, 2009 9:23 pm Post subject: |
|
|
Song: One Way Or Another. Path: 4/ 4/sk1
[98,000 /(T) 217875] => 233875
31 Taps = 3100+775=3875 points.
Song Welcome To the Neighborhood Path: 4/ 2/sk1 3/
[62,000 / 87160/ (T) 122160] => 130,160
24 Taps= 2400+600= 3000 points
Song Everlong Path 3/sk1EW 3/sk1EW 2/sk1EW
[66,000/ 122,000/ 148,300] => 148,300
Song Pump It Up Path: 4/AS-AT, 2/ 2/
[(T1)/89,000/ 129,000/ 157,180/(T2)] => 164,180
24 Taps(1) = 3000
56 Taps(2) = 7000
Song: Give it all Path: 3/ 2/ 4/BOD
[111,114/ 147,114/ 243,114] => 255,114 _________________
Last edited by WhYYZ on Wed Aug 05, 2009 1:24 am; edited 1 time in total |
|
Back to top |
|
|
BlazezRB
Joined: 20 Jul 2009 Posts: 28 Location: somewhere...
|
Posted: Tue Aug 04, 2009 10:31 pm Post subject: |
|
|
Nice Idea. Will there ever be RB1 Imports/DLC ever added to this list? _________________
Name - Blazez
FC - 0287 0880 0339
PM me if you are giving me your Wii Address code, I wanna see all the amazing Miis. (Not to mention GH5, lol) |
|
Back to top |
|
|
Vicromano20
Joined: 02 Dec 2007 Posts: 156
|
Posted: Tue Aug 04, 2009 11:53 pm Post subject: |
|
|
BlazezRB wrote: | Nice Idea. Will there ever be RB1 Imports/DLC ever added to this list? |
I will make sure that at least the Imports get up here.
Tier 2 will be posted tonight. |
|
Back to top |
|
|
WhYYZ
Joined: 08 Oct 2007 Posts: 3150 Location: The netherlands, Amsterdam
|
Posted: Wed Aug 05, 2009 1:25 am Post subject: |
|
|
We are already half way through _________________
|
|
Back to top |
|
|
BlazezRB
Joined: 20 Jul 2009 Posts: 28 Location: somewhere...
|
Posted: Wed Aug 05, 2009 3:36 am Post subject: |
|
|
Give It Away: 5/ (+3892), 4/ (+0)
[(T) 143625, 239517, (T) 256392, 452392] => 468392 (-184) _________________
Name - Blazez
FC - 0287 0880 0339
PM me if you are giving me your Wii Address code, I wanna see all the amazing Miis. (Not to mention GH5, lol) |
|
Back to top |
|
|
BlazezRB
Joined: 20 Jul 2009 Posts: 28 Location: somewhere...
|
Posted: Wed Aug 05, 2009 5:25 am Post subject: |
|
|
Panic Attack: 2/sk1 (+2,316), 3/AT (+4,000), 3/BOD (+3,400), 2/sk3 (+3,300)
[32316, (T) 54191, 78191, 133591, (T) 179216, 210516] => 210,516 (-664)
Down With The Sickness: 3/BOD (+2440), 2/BOD (+2,212) 3/BOD (+4000 (Ends With leftover OD))
[140440, 230652, (T) 269152, 341152] => 341,152 (-340)
That's What You Get: 2/ (+2412), 2/ (+504), 2/ (+0), 4/BOD (+288)
[44412, 112916, 140916, 253204] => 265,204 (-616)
.... I'm sorry to dissapoint with the fail squeezing _________________
Name - Blazez
FC - 0287 0880 0339
PM me if you are giving me your Wii Address code, I wanna see all the amazing Miis. (Not to mention GH5, lol) |
|
Back to top |
|
|
|
|
ScoreHero Forum Index
-> Technique, Style, and Gameplay
-> Vocals |
All times are GMT Goto page Previous 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Next
|
Page 5 of 10 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Copyright © 2006-2024 ScoreHero, LLC
|
Powered by phpBB
|