EOYC 2016 Day 8 on AH.FM 26-12-2016

[tkkttony]

I need to sum some rows then another rows and then minus one from the other one then divide it by 100% and then get a result in percentages. I've summed it, but dividing doesn't work.

Start a new cell = that number you need to divide from and work from there?

 

[danmark_ori]

Simon Bostock - EOYC 2016 on AH.FM 26-12-2016

01. Simon Bostock - Marrakech (Intro Reconstruction) [Pure Trance]
02. Alex M.O.R.P.H & Paul van Dyk - We Are (Original Mix) [Vandit]
03. Simon Patterson feat. Lucy Pullin - Now I Can Breathe Again (Extended Mix) [Armind]
04. Solarstone & Marcella Woods - Falling (Peter Steele Mantra Mix) [Pure Trance]
05. Joint Operations Centre - Goodnight Irene (Original Mix) [Kearnage Recordings]
06. Simon Bostock - Doesn't have a name yet
07. Peter Steele - Ardor [Pure Trance]
08. Solarstone - Release (Simon Bostock Remix) [Armada]
09. The Thrillseekers pres. Hydra - Amber (Extended Mix) [FSOE]
10. Super8 and Tab - Into (Extended Mix) [A State Of Trance]
11. Sean Tyas - Reach Out (Giuseppe Ottaviani Remix) [Who's Afraid Of 138?!]
12. Giuseppe Ottaviani - Aurora (OnAir Mix) [Black Hole Recordings]
13. Armin van Buuren presents Rising Star - Clear Blue Moon (Will Rees Remix) [Who's Afraid Of 138?!]
14. Para X - Laguna (Original Mix) [Discover Records]
15. Amir Hussain - Time Lapse (Extended Mix) [Who's Afraid Of 138?!]

16. Robert Nickson - Touchdown [Pure Trance]

Robert Nickson
Robert Nickson Discography at Discogs
Images for Robert Nickson
Real Name: Robert D. Nickson


Aliases: Nick Robertson, RNX (3)
In Groups: Aeris, Henry Hill (8), Mind (3), Mitosis (2), True Form


Profile: Robert's background is a multi-national affair: father from England, mother from Norway, born in England and now living in The Netherlands. But it's The Netherlands that has given him his musical influences. The Netherlands is renowned for its Dance Music scene.

Current Location: Haarlem, Noord-Holland, The Netherlands
​

Robert Nickson The DJ List
Robert Nickson Facebook (Private)
Robert Nickson Facebook (Fan Page)
Robert Nickson Google +
Robert Nickson . com
Robert Nickson Beatport (Pro)
Robert Nickson Twitter
Robert Nickson MySpace

​

 

[ThePig]

and do the neighbours still like you ?

mine can g pretty hard to you know :icecream the volume knob is at about 25% and winamp is limited to 20% in de settings ... could go to 100% in windows and 25% on speakers i once did it during a luckily the apartment beneath me is uninhabitad atm

 

[LucasChasingDreams]

Give me column headers and I can write something for you.

=SUM(I6:I20) - SUM(G6:G20) - it works till this moment. How to divide it by 100% to make it worth (get a result in %)?

 

[Above1stBase]

Yeah . but I need to update my tracker for the last 2 days still.

Just don't be surprised if any of the 140+ DJs since your last update played Evoke and/or Smack (WAIO Remix). Either one of those two is pretty much expected of them by now.

 

[LucasChasingDreams]

Start a new cell = that number you need to divide from and work from there?

Yeah, that's what I actually did, but there's a smarter way to solve this, I think.

 

[danmark_ori]

Never had a complaint about DJ mixes seeping through the walls in the year I've lived here. LOL

cool ! I hope for your your neighbours do not move ever

 

[ThePig]

 

[MyStro023]

=SUM(I6:I20)-SUM(G6:G20) / 100 or =SUM(I6:I20)-SUM(G6:G20)/100 doesn't work.

Order of operations dude!

=(SUM(I6:I20)-SUM(G6:G20))/100

 

[tkkttony]

Yeah, that's what I actually did, but there's a smarter way to solve this, I think.

It's easier keeping things simple.

 

[ThePig]

 

[MyStro023]

Just don't be surprised if any of the 140+ DJs since your last update played Evoke and/or Smack (WAIO Remix). Either one of those two is pretty much expected of them by now.

Nothing has been super surprising yet really in my trends.

 

[danmark_ori]

​

https://en.wikipedia.org/wiki/Apollo
​

 

[C!C@]

Simon Bostock - EOYC 2016 on AH.FM 26-12-2016

01. Simon Bostock - Marrakech (Intro Reconstruction) [Pure Trance]
02. Alex M.O.R.P.H & Paul van Dyk - We Are (Original Mix) [Vandit]
03. Simon Patterson feat. Lucy Pullin - Now I Can Breathe Again (Extended Mix) [Armind]
04. Solarstone & Marcella Woods - Falling (Peter Steele Mantra Mix) [Pure Trance]
05. Joint Operations Centre - Goodnight Irene (Original Mix) [Kearnage Recordings]
06. Simon Bostock - Doesn't have a name yet
07. Peter Steele - Ardor [Pure Trance]
08. Solarstone - Release (Simon Bostock Remix) [Armada]
09. The Thrillseekers pres. Hydra - Amber (Extended Mix) [FSOE]
10. Super8 and Tab - Into (Extended Mix) [A State Of Trance]
11. Sean Tyas - Reach Out (Giuseppe Ottaviani Remix) [Who's Afraid Of 138?!]
12. Giuseppe Ottaviani - Aurora (OnAir Mix) [Black Hole Recordings]
13. Armin van Buuren presents Rising Star - Clear Blue Moon (Will Rees Remix) [Who's Afraid Of 138?!]
14. Para X - Laguna (Original Mix) [Discover Records]
15. Amir Hussain - Time Lapse (Extended Mix) [Who's Afraid Of 138?!]
16. Robert Nickson - Touchdown [Pure Trance]

17. F.G. Noise - Apollo (Extended Mix) [Monster Force]

 

[C!C@]

​

https://en.wikipedia.org/wiki/Apollo
​

 

[ThePig]

 

[C!C@]

 

[Above1stBase]

And the lasers return for the 2nd hour :grinning2:

​

 

[ThePig]

 

[Above1stBase]

​