Hmm... you may have highlighted a bug in my spreadsheet that affects manually adjusted totals.

 

I'll have to get back to you on this...

 

Very well spotted Jay - you are quite right!

 

I'd accidentally included one extra column in the formula that adds up total sales. :blush:

 

I've now corrected the error - fortunately it only affected one entry in each of the T40 singles & album, so the total figures in tomorrows YTD T40's should be as close as they can be, within the inherent limits of my estimatiion methods.

 

As for the original error, the corrected total figure of CC-3W is ~952.5k

Could I have the YTD and total sales (if possible) of Lungs by Florence + The Machine?

 

 

Could I have the YTD and total sales (if possible) of Lungs by Florence + The Machine?

 

See T40 update to come...

V2 :

 

Pos LW YTD Artist Title New Hst total

1 1 343675 Adele - 21 05/02/11 1 343675

2 3 195718 Bruno Mars - Doo-Wops & Hooligans 30/10/10 1 203300

3 2 187327 Rihanna - Loud 27/11/10 1 1026900

4 4 125100 Plan B - Defamation Of Strickland Banks 24/04/10 2 951500

5 7 100500 Adele - 19 09/02/08 4 830800

6 5 96000 Cee-Lo Green - Lady Killer 20/11/10 3 232200

7 6 89300 Ellie Goulding - Lights 13/03/10 5 476900

8 10 78400 Rumer - Seasons Of My Soul 13/11/10 4 378200

9 8 77900 Tinie Tempah - Disc-Overy 16/09/10 4 443900

10 9 76500 Mumford & Sons - Sigh No More 17/10/09 5 939400

11 11 75900 Take That - Progress 27/11/10 1 1917000

12 12 72400 Eliza Doolittle - Eliza Doolittle 24/07/10 8 344200

13 13 60700 Katy Perry - Teenage Dream 11/09/10 8 604900

14 14 60000 Alfie Boe - Bring Him Home 08/01/11 9 76100

15 15 54700 Lady Gaga - Fame 24/01/09 12 2495600

16 N 52224 Chase & Status - No More Idols 12/02/11 2 52224

17 23 51400 Imelda May - Mayhem 16/10/10 7 78400

18 16 51000 Kings Of Leon - Come Around Sundown 30/10/10 7 745200

19 17 50300 Wanted - Wanted 06/11/10 5 328800

20 18 49600 Michael Buble - Crazy Love 31/10/09 3 2474900

21 20 47900 Olly Murs - Olly Murs 11/12/10 4 491000

22 19 47500 Pink - Greatest Hits… So Far! 27/11/10 12 387400

23 21 44200 Script - Science & Faith 25/09/10 14 532600

24 22 43700 White Lies - Ritual 29/01/11 3 43700

25 25 39800 Overtones - Good Ol' Fashioned Love 13/11/10 16 111900

26 24 37800 JLS - Outta This World 04/12/10 6 531400

27 26 34200 Robbie Williams - In & Out Of Consciousness… 23/10/10 11 586000

28 27 33600 Florence & The Machine - Lungs 18/07/09 24 1301700

29 28 33300 Andre Rieu - Moonlight Serenade 27/11/10 18 377100

30 30 32800 James Blunt - Some Kind Of Trouble 20/11/10 26 236900

31 29 31100 Cheryl Cole - Messy Little Raindrops 13/11/10 19 457700

32 31 29500 Biffy Clyro - Only Revolutions 21/11/09 22 532400

33 33 28700 Black Eyed Peas - Begnning 11/12/10 8 291000

34 32 28600 Pixie Lott - Turn It Up 26/09/09 27 773400

35 34 26900 Kings Of Leon - Only By The Night 04/10/08 31 2627600

36 35 25800 Paolo Nutini - Sunny Side Up 13/06/09 32 1605500

37 36 24500 Justin Bieber - My World 30/01/10 31 593000

38 38 23900 Bon Jovi - Greatest Hits 13/11/10 9 551400

39 37 23800 N-Dubz - Love Live Life 11/12/10 17 231800

40 39 22500 Professor Green - Alive Till I'm Dead 31/07/10 36 159100

41 41 22200 Take That - Never Forget - Ultimate Collection 26/11/05 33 2074400

42 42 21800 Arcade Fire - Suburbs 14/08/10 36 234200

43 N 21778 Eva Cassidy - Simply Eva 12/02/11 6 21778

44 40 21700 JLS - JLS 21/11/09 23 1321900

45 43 21600 Eminem - Recovery 03/07/10 36 750000

46 44 20000 Michael Jackson - Number Ones 29/11/03 16 388700

47 46 19700 Rihanna - Rated R 05/12/09 40 622100

48 47 19400 XX - XX 29/08/09 42 362100

49 45 18700 Emma's Imagination - Stand Still 22/01/11 14 18700

50 52 18000 Nicki Minaj - Pink Friday 04/12/10 45 69000

 

Very well spotted Jay - you are quite right!

 

I'd accidentally included one extra column in the formula that adds up total sales. :blush:

 

I've now corrected the error - fortunately it only affected one entry in each of the T40 singles & album, so the total figures in tomorrows YTD T40's should be as close as they can be, within the inherent limits of my estimatiion methods.

 

As for the original error, the corrected total figure of CC-3W is ~952.5k

 

Thanks, Paul! Glad my Cheryl stanning helped you spot an error! :lol: :lol:

Have you got any updates on 3Words and Messy Little Raindrops?

ooops just realised you have already updated :P

C'mon Pixieee reach over 700k!

C'mon Pixieee reach over 700k!

 

If you look at #34 again, you'll see she's already well *over* 700k... ;)