Important! Read before posting Personal Charts

[Matt4319]

Sunny (BlahBlahBlah) has devised a program for help in compiling Pulse 100 charts. Once the kinks are worked out, I expect this to decrease the time needed to make the Pulse 100 every week.

One thing you might have noticed is that charts that are posted directly from Microsoft Excel now show two spaces between every field instead of one. This is so the program will recognize a certain artist, title, or position number and input it into the spreadsheet.

The program isn't perfect, though, so I did some trial and error first. With a few guidelines for posting charts, I think it can work very well.

First, you can still either post from Excel or type it out manually.

If you are posting from Excel:

• (Recommended) It's better not to = post "2W" (two weeks ago) positions.
• Place any other data such as Weeks On Chart, Peak Position, etc. off to the right of the Title/Artist. That way the program doesn't try to recognize it as a position.

If you are typing out your chart manually:

• Place double spaces before the TW, Title, and Artist positions. You can post 2W ago positions as long as you don't put double spaces between that and the LW position.

A sample chart format that works perfectly when placed into the Pulse 100 compiler:

02 01 Slow Jamz Twista f/Kanye West & Jamie Foxx 10 01
01 02 You Don't Know My Name Alicia Keys 18 01
04 03 Toxic Britney Spears 10 03
03 04 Yeah! Usher f/Lil' Jon & Ludacris 08 03
06 05 f**k It (I Don't Want You Back) Eamon 12 05
05 06 The Way You Move OutKast f/Sleepy Brown 24 04
10 07 Through The Wire Kanye West 14 07
08 08 My Immortal Evanescence 15 06
07 09 Hey Ya! OutKast 25 01
09 10 Milkshake Kelis 23 01
11 11 Me, Myself And I Beyoncé 16 05
12 12 She Wants To Move N*E*R*D 05 12
13 13 Salt Shaker Ying Yang Twins f/Lil' Jon & The East Side Boyz 08 13
14 14 I'm Really Hot Missy Elliott 06 14
19 15 One Call Away Chingy f/J. Weav 05 15
21 16 Wanna Get To Know You G-Unit f/Joe 04 16
17 17 Megalomaniac Incubus 09 17
16 18 White Flag Dido 13 16
15 19 One Thing Finger Eleven 19 13
25 20 Hotel Cassidy f/R. Kelly 04 20
23 21 Still Frame Trapt 07 21
24 22 Dirt Off Your Shoulder Jay-Z 06 22
27 23 Splash Waterfalls Ludacris 06 23
26 24 Meant To Live Switchfoot 05 24
22 25 With You Jessica Simpson 09 21
34 26 Tipsy J-Kwon 02 26
18 27 God Is A DJ Pink 13 08
29 28 The First Cut Is The Deepest Sheryl Crow 07 28
-- 29 If I Ain't Got You Alicia Keys 01 29
32 30 Work It Nelly f/Justin Timberlake 02 30
31 31 Sorry 2004 Ruben Studdard 03 31
33 32 Just A Little While Janet Jackson 03 32
37 33 Not In Love Enrique Iglesias f/Kelis 02 33
35 34 No Better Love Young Gunz f/Rell 03 34
-- 35 Trick Me Kelis 01 35
28 36 Numb Linkin Park 15 19
39 37 Back In The Mudd Bubba Sparxxx 02 37
30 38 Hold On Good Charlotte 11 21
-- 39 Roses OutKast 01 39
-- 40 Hey Mama Black Eyed Peas 01 40
00 41 I Miss You Blink-182
00 42 This Love Maroon5
00 43 I Can't Wait Sleepy Brown f/OutKast
00 44 In My Life Juvenile f/Mannie Fresh
00 45 Dude Beenie Man f/Ms. Thing
00 46 One Day At A Time (Em's Version) Tupac w/Eminem f/The Outlawz
00 47 Fallen Sarah McLachlan
00 48 Sic Transit Gloria... Glory Fades Brand New
00 49 And? Dina Rae
00 50 Rubber Band Man T.I.

Hopefully this will make things go much more smoothly when making the weekly Pulse 100 charts. :)

[BlahBlahBlah]

To add on what Matt has said, the formatting can be very flexible, for exampe, I can do the following:

*02  01 01 10  Slow Jamz -  Twista f/Kanye West & Jamie Foxx
 01  02 01 18  You Don't Know My Name -  Alicia Keys
*04  03 03 10  Toxic -  Britney Spears
*03  04 03 08  Yeah! -  Usher f/Lil' Jon & Ludacris
*06  05 05 12  f**k It (I Don't Want You Back) -  Eamon
 05  06 02 24  The Way You Move -  OutKast f/Sleepy Brown
*10  07 07 14  Through The Wire -  Kanye West
 08  08 06 15  My Immortal -  Evanescence
 07  09 01 25  Hey Ya! -  OutKast
 09  10 01 23  Milkshake -  Kelis
 11  11 05 16  Me, Myself And I -  Beyoncé
*12  12 12 05  She Wants To Move -  N*E*R*D
*13  13 13 08  Salt Shaker -  Ying Yang Twins f/Lil' Jon & The East Side Boyz
*14  14 14 06  I'm Really Hot -  Missy Elliott
*19  15 15 05  One Call Away -  Chingy f/J. Weav
*21  16 16 04  Wanna Get To Know You -  G-Unit f/Joe
*17  17 17 09  Megalomaniac -  Incubus
 16  18 16 13  White Flag -  Dido
 15  19 13 19  One Thing -  Finger Eleven
*25  20 20 04  Hotel -  Cassidy f/R. Kelly
*23  21 21 07  Still Frame -  Trapt
*24  22 22 06  Dirt Off Your Shoulder -  Jay-Z
*27  23 23 06  Splash Waterfalls -  Ludscris
*26  24 24 05  Meant To Live -  Switchfoot
 22  25 21 09  With You -  Jessica Simpson
*34  26 26 02  Tipsy -  J-Kwon <<< Greatest Gainer >>.
 18  27 08 13  God Is A DJ -  Pink
*29  28 28 07  The First Cut Is The Deepest -  Sheryl Crow
*--  29 29 01  If I Ain't Got You -  Alicia Keys <<< Hot Shot Debut >>>
*32  30 30 02  Work It -  Nelly f/Justin Timberlake
*31  31 31 03  Sorry 2004 -  Ruben Studdard
*33  32 32 03  Just A Little While -  Janet Jackson
*37  33 33 02  Not In Love -  Enrique Iglesias f/Kelis
*35  34 34 03  No Better Love -  Young Gunz f/Rell
*--  35 35 01  Trick Me -  Kelis
 28  36 19 15  Numb -  Linkin Park
*39  37 37 02  Back In The Mudd -  Bubba Sparxxx
 30  38 21 11  Hold On -  Good Charlotte
*--  39 39 01  Roses -  OutKast
*--  40 40 01  Hey Mama -  Black Eyed Peas

Just make sure you follow the following rules:

• TW pos must come RIGHT after the first double spaces.
• Title must come RIGHT after the second double spaces
• Artist must come RIGHT after the third double spaces
• One line per entry

The artist/title names don't have to be exact, you can leave it the way it is and it should be able to pick it up.

Oh yes, charts can be in either ascending or descending order. So as long as you don't randomly place positions, it would work.

[FreakyFlyBry]

Test:

1 1 Toxic Britney Spears 10 1
2 2 Come Clean Hilary Duff 18 2
10 3 I Miss You Blink 182 12 3
5 4 Everything Fefe Dobson 9 4
6 5 Extraordinary Liz Phair 11 5
7 6 This Love Maroon 5 10 6
3 7 With You Jessica Simpson 23 3
12 8 Red Blooded Woman Kylie Minogue 7 8
4 9 Slow Kylie Minogue 21 4
8 10 My Immortal Evanescence 20 1
16 11 Just A Little While Janet Jackson 4 11
9 12 Me, Myself, and I Beyoncé 17 8
13 13 F**k It (I Don't Want You Back) Eamon 20 12
11 14 I Promise Stacie Orrico 18 7
35 15 Til I Get Over You Michelle Branch 4 15
25 16 Away From The Sun 3 Doors Down 10 16
26 17 I Believe In A Thing Called Love The Darkness 11 17
18 18 100 Years Five For Fighting 13 18
30 19 Not In Love Enrique Iglesias, Kelis 10 19
15 20 Figured You Out Nickelback 12 15
14 21 Milkshake Kelis 18 4
17 22 You Don't Know My Name Alicia Keys 22 8
0 23 Don't Tell Me Avril Lavigne 1 23
27 24 Yeah Usher, Ludacris 9 24
19 25 Life For Rent Dido 17 8
21 26 Numb Linkin Park 23 2
22 27 Behind Blue Eyes Limp Bizkit 19 7
20 28 God Is A DJ Pink 15 2
24 29 One Thing Finger Eleven 19 6
23 30 The Voice Within Christina Aguilera 19 1
34 31 Work It Nelly, Justin Timberlake 5 31
32 32 Meant To Live Switchfoot 16 32
33 33 8th World Wonder Kimberly Locke 13 33
37 34 Breathe Melissa Etheridge 4 34
28 35 Breathe Michelle Branch 30 1
29 36 Hey Ya Outkast 27 3
38 37 Don't Leave Home Dido 9 37
52 38 Clarity John Mayer 6 38
44 39 Try Nelly Furtado 4 39
36 40 The Way Clay Aiken 10 36
47 41 Bounce Sarah Connor 8 41
31 42 When I Look To The Sky Train 26 7
40 43 Catch Me While I'm Sleeping Pink 7 40
41 44 Fallen Sarah McLachlan 25 9
42 45 Star Of All The Planets Ryan Malcolm 8 31
43 46 I Won't Change You Sophie Ellis-Bextor 10 37
48 47 I'm Really Hot Missy Elliott 10 47
39 48 She Don't Want Nobody Near Counting Crows 6 36
50 49 Left Outside Alone Anastacia 4 49
49 50 Hey Mama Black Eyed Peas 12 49
51 51 Back In The Mudd Bubba Sparxxx 8 51
56 52 Love's Divine Seal 6 52
55 53 Ocean Avenue Yellowcard 7 53
53 54 Leave Right Now Will Young 8 53
54 55 Cold and Empty Kid Rock 7 54
58 56 Mexican Wine Fountains of Wayne 6 56
57 57 Everything Eventually Appleton 4 57
59 58 Everybody Wants You Josh Kelley 8 58
61 59 Come On Ben Jelen 6 59
63 60 Mad World Gary Jules 9 60
64 61 Megalomaniac Incubus 5 61
62 62 You Promised Me In-Grid 4 62
65 63 Boys Don't Cry Plumb 4 63
66 64 The Reason Hoobastank 5 64
67 65 One Call Away Chingy 7 65
68 66 Naughty Girl Beyoncé 7 66
69 67 Sunrise Norah Jones 5 67
70 68 Overdrive Katy Rose 5 68
74 69 The Way You Move Outkast 21 25
46 70 The Closest Thing To Crazy Katie Melua 10 42
75 71 She Wants To Move N.E.R.D. 4 71
76 72 Million Miles Fuel 5 72
86 73 I Don't Want To Be Gavin DeGraw 2 73
79 74 Stupid Sarah McLachlan 2 74
78 75 I'm Shakin' Rooney 6 75
77 76 You Make Me Feel Brand New Simply Red 4 76
81 77 No Way Out Phil Collins 2 77
82 78 Roses Outkast 2 78
85 79 Testing 1, 2, 3 Barenaked Ladies 3 79
83 80 Echo Trapt 3 80
0 81 Run Away Live 1 81
88 82 Teenage Drama Queen (That Girl) Lindsay Lohan 2 82
90 83 Everything Alanis Morissette 3 83
91 84 If I Ain't Got You Alicia Keys 2 84
71 85 Fell In Love With A Boy Joss Stone 2 71
0 86 Amazing George Michael 1 86
84 87 I Can't Wait Sleepy Brown, Outkast 6 84
95 88 Trick Me Kelis 3 88
93 89 Maybe Tomorrow Stereophonics 2 89
92 90 Gia Despina Vandi 2 90
96 91 Not Ready To Go The Trews 2 91
0 92 I Don't Wanna Know Mario Winans, P. Diddy, Enya 1 92
0 93 Penny and Me Hanson 1 93
87 94 All This Time Michelle McManus 2 87
100 95 Splash Waterfalls Ludacris 2 95
60 96 The Heart Of Every Girl Elton John 8 60
0 97 Don't Want To Think About You Simple Plan 1 97
0 98 Devils and Angels Toby Lightman 1 98
0 99 It Only Hurts When I'm Breathing Shania Twain 1 99
0 100 Downfall Matchbox Twenty 1 100

[j]

Can we leave more than a double space, and can we have a . after this week's positions?

I don't mind if we can't; I'm just glad we've now moved into the information age.

[Matt4319]

1 said:

Can we leave more than a double space

Why would you want/need to? lol... But I don't think you can.

1 said:

and can we have a . after this week's positions?

Yes.

[insect2]

So, what happens it we put the artist before the title? Would it mess up the program? Because all my chart are organized as artist before title, and I'd rather not reorganize all my charts just to fit the program. >:(

[Deleted]

insect2 said:

So, what happens it we put the artist before the title? Would it mess up the program? Because all my chart are organized as artist before title, and I'd rather not reorganize all my charts just to fit the program. >:(

I think this is going to be a big problem. I like to put the "TW" column before the "LW" column. Maybe we can have a thread for the R&R100 and one for just sharing personal charts.

[Matt4319]

For both of the above:

(As of September 11, 2004 -- actually a while before today -- it doesn't matter whether you put the "LW" or "TW" first or the title or artist first. There was something else here, but I deleted it.)

[ljaesch]

Just letting you folks know I'll be bowing out of The Pulse 100. It's not due to being upset with anyone or anything like that... it's simply due to time constraints. With The AeschTunes Top 40 radio station starting to take off, I have less time than I used to; I just don't have the time to put together a separate chart than the one I post on my website that would require a different format to fit the new guidelines for The Pulse 100.

I'll miss contributing to The Pulse 100, and I wish nothing but the best for the chart and for the members that contribute to it.

[Deleted]

Matt4319 said:

For both of the above: If you're pasting from Excel, all you need to do is make a new temporary file with just that chart's stuff on it, and switch the Title and Artist columns.

Oh, that's true.

[BlahBlahBlah]

Alright I just fixed up the code, you can now put Artist before Title as well as TW before LW if you want.

[mst3k]

I've got another question... is there really any limit to how much data we can put before "TW"? For instance, my old chart format had columns like so:

WC 2W LW TW Title - Artist
(20) 02 02 01 My Immortal – Evanescence
(09) 04 03 02 This Love – Maroon5
(20) 01 01 03 Innocent Eyes – Delta Goodrem

As long as there's double spaces before TW, title, and artist, is the rest of the data okay where it is? If not, I'll put the WC over to the far right side... but if it works as is with no extra work for you guys, I've kinda gotten used to having it where it's been. :)

[Matt4319]

mst3k1 said:

I've got another question... is there really any limit to how much data we can put before "TW"? For instance, my old chart format had columns like so:

WC 2W LW TW Title - Artist
(20) 02 02 01 My Immortal – Evanescence
(09) 04 03 02 This Love – Maroon5
(20) 01 01 03 Innocent Eyes – Delta Goodrem

As long as there's double spaces before TW, title, and artist, is the rest of the data okay where it is? If not, I'll put the WC over to the far right side... but if it works as is with no extra work for you guys, I've kinda gotten used to having it where it's been. :)

Hmm... I was going to say that you could only have two columns before title/artist, but I put those three lines into the compiler and it turned out fine. I think just as long as you don't have any double spaces between the 1st and 2nd columns or between the 2nd and 3rd columns, the compiler treats the entire three-column span

(20) 02 02

as one value, the "LW" (which can really be anything, because the compiler doesn't take that into account).

[Joe1240]

Where should we put the peak postions for songs on our chart under the new format?.. put it after the song name...

[Matt4319]

Joe1240 said:

Where should we put the peak postions for songs on our chart under the new format?.. put it after the song name...

Yes, that's fine.

[crash46]

Abbreviated Annoying List for 3-8-04

TW  LW  Wk  Artist--Title (peak)[/font][/color]
01  01  12  Jessica Simpson--With You (5 weeks at #1)
02  --  01  Frankee--F-U-R-B (2)
03  05  14  Sarah Connors--Bounce (2)
04  06  04  Janet Jackson--In A Little While (4)
05  02  06  Twista--Slow Jamz (2)
06  04  18  Fuel--Falls On Me (3)
07  03  22  Three Doors Down--Here Without You (1 week at #1)
08  07  11  Beyonce--Me, Myself, And I (3 weeks at #1)
09  --  01  Avril Lavigne--Don't Tell Me (9)
10  08  16  Chingy--Holidae In (4)[/color]

If this was a reported chart, is there anything else I would need to change? I'd probably have to take that "WK" column and move it after the song, and correct some typos...but I don't know how the program works so I'm not sure.

[Matt4319]

crash46 said:

Abbreviated Annoying List for 3-8-04

TW LW Wk Artist--Title (peak)

[/font][/color]
01 01 12 Jessica Simpson--With You (5 weeks at #1)
02 -- 01 Frankee--F-U-R-B (2)
03 05 14 Sarah Connors--Bounce (2)
04 06 04 Janet Jackson--In A Little While (4)
05 02 06 Twista--Slow Jamz (2)
06 04 18 Fuel--Falls On Me (3)
07 03 22 Three Doors Down--Here Without You (1 week at #1)
08 07 11 Beyonce--Me, Myself, And I (3 weeks at #1)
09 -- 01 Avril Lavigne--Don't Tell Me (9)
10 08 16 Chingy--Holidae In (4)[/color]

If this was a reported chart, is there anything else I would need to change? I'd probably have to take that "WK" column and move it after the song, and correct some typos...but I don't know how the program works so I'm not sure.[/quote]

Replace the "dash dash" between Artist and Title with "space space". Actually, you can keep the "WK" there as long as there's only a single space between "LW" and "WK". And typos actually are fairly covered, as long as they happen after the first 5 or 6 letters of either artist or title. So if you want to say "Sarah Connors" that's fine. ;)

I didn't know you had an annoying list. :o

[crash46]

Matt4319 said:

Replace the "dash dash" between Artist and Title with "space space". Actually, you can keep the "WK" there as long as there's only a single space between "LW" and "WK".  And typos actually are fairly covered, as long as they happen after the first 5 or 6 letters of either artist or title.  So if you want to say "Sarah Connors" that's fine. ;)

I didn't know you had an annoying list.  :o

Yeah, I thought the "dash dash" might have caused a problem too. I'll just do what BlahBlahBlah did, with "ArtistSpaceDashSpaceSpaceTitle", if that's still alright, because I don't like looking at charts where the artists and titles aren't separated by anything.

And the annoying list is something I just made up, for the purpose of having an example.

[thedualityofman]

How about album titles, do they manage to confuse things?

[Love Plastic Love]

1. 3 Dashboard Confessional-Vindicated (12)
2. 1 Maroon 5 She Will Be Loved (12)
3. 1 Vanessa Carlton-White Houses (6)
4. 4 Avril Lavigne-My Happy Ending (13)
5. 7 Switchfoot-Dare You To Move (5)


Here is an example of mine. Do I need to change anything? Sorry I got a little confused

[Matt4319]

The said:

How about album titles, do they manage to confuse things?

If you put just two spaces between the artist and title (or title and artist, however you put it), you can just leave the " - " between that and the album (I think you do it that way).

Poetry said:

1. 3 Dashboard Confessional-Vindicated (12)
2. 1 Maroon 5 She Will Be Loved (12)                             
3. 1 Vanessa Carlton-White Houses (6)
4. 4 Avril Lavigne-My Happy Ending (13)
5. 7 Switchfoot-Dare You To Move (5)

Here is an example of mine. Do I need to change anything? Sorry I got a little confused

You could do as little as this and it would be fine with me:

1. 3. Dashboard Confessional - Vindicated (12)
2. 1. Maroon 5 - She Will Be Loved (12)                             
3. 1. Vanessa Carlton - White Houses (6)
4. 4. Avril Lavigne - My Happy Ending (13)
5. 7. Switchfoot - Dare You To Move (5)

Because I can run a find and replace function to replace the ". " with "  " and " - " with "  ".

[Love Plastic Love]

Will do on my next chart :)