+ Post New Thread
Page 25 of 26 FirstFirst ... 15212223242526 LastLast
Results 361 to 375 of 390
Our Advertisers Thread, Win a high spec personalised VeryPC Nano Sketch for our 10th birthday! in Purchasing and Trading; Originally Posted by sonofsanta Loving the Excel at the moment, aren't you? (it's ok, we're all geeks here, let it ...
  1. #361

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by sonofsanta View Post
    Loving the Excel at the moment, aren't you? (it's ok, we're all geeks here, let it aaaaall out)
    It's just so damn handy for lists and stuff!

    I used to own one of these, but I broke it *whimper*:



    Al
    Attached Images Attached Images
    Last edited by VeryPC; 24th February 2014 at 11:12 AM.

  2. #362

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by nephilim View Post
    wouldnt mind a copy of that spreadsheet
    For what nefarious purposes smiley face?

    Al

  3. #363

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by X-13 View Post
    You had a lot more invalid entries than I thought... I saw a 7xx entry on the video.
    You mis-saw I'm afraid. The numbers went nowhere near that high. Must have been a trick of the light.
    Quote Originally Posted by nephilim View Post
    yes but many were duplicated or invalid
    About 10% actually.

    Al

  4. #364

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,814
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426
    Quote Originally Posted by VeryPC View Post
    For what nefarious purposes smiley face?

    Al
    I like the formatting you have, and want to look at it. You can delete the usernames by all means

  5. #365
    Griff's Avatar
    Join Date
    Feb 2009
    Location
    Bedfordshire
    Posts
    514
    Thank Post
    199
    Thanked 95 Times in 77 Posts
    Rep Power
    38
    Quote Originally Posted by VeryPC View Post
    It's just so damn handy for list and stuff!

    I used to own one of these, but I broke it *whimper*:





    Al
    I dropped my VeryPC mug about 4 times so far..not broken once very happy with its bounceability

  6. #366

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by Griff View Post
    what on earth!! I have missed out on this thread..
    Ah shame.

    To be aware of all future VeryPC comps and promos, subscribe to the following thread:

    VeryPC competitions, events and announcements (never miss another chance to win!)

    Cheers,

    Al

  7. Thanks to VeryPC from:

    Griff (24th February 2014)

  8. #367

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by nephilim View Post
    I like the formatting you have, and want to look at it. You can delete the usernames by all means
    I seeee..... might we expect a reordered list to appear if I do by any chance? Sorry, just joshing - I know you guys like to, let's say "mislead" me about the results for comedy purposes sometimes. No matter, the official winner has been announced, so go for your life.

    The usernames are public anyway, so I've left them in - there's no confidential data involved.

    mini-comp-share.xlsx

    Al

  9. #368

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,736
    Thank Post
    1,272
    Thanked 1,645 Times in 1,101 Posts
    Blog Entries
    22
    Rep Power
    505
    I demand a recount, I am sure there are 7 entries you didn't count

  10. #369

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,814
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426
    alas no reordering, geniunely interetsed in your spreadsheet formatting.

  11. Thanks to nephilim from:

    VeryPC (24th February 2014)

  12. #370

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162
    I'm assuming it is the new Office colour scale conditional formatting at work. Nice use of it, most of the time it is thoroughly pointless!

  13. #371

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by TechMonkey View Post
    I'm assuming it is the new Office colour scale conditional formatting at work. Nice use of it, most of the time it is thoroughly pointless!
    Yup - with an over-priority additional condition to turn the smallest number black so it stands out. Obviously I re-ordered them into closest to furthest before publishing, rendering the colour scale a bit redundant, but it was useful when they were in entry time order to give me an idea of who was close and not.

    Also used a condition on columns A and B to highlight dupes in red so I could eliminate any double entrants or guesses of the same number (neither of which actually happened, but if it had.... oooh I'd have been on it like a flash!)

    Al

  14. #372

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by sparkeh View Post
    I demand a recount, I am sure there are 7 entries you didn't count
    Hah. I kept a keen eye on it actually, but you already knew that.

    @Driftingashore got his 1 away guess quite early in the process actually, but there was always room for someone to guess the other side of the correct answer for a draw at 1 away or even someone to nail it right on 293 so I kept it going. If someone had nailed it I'd have stopped the competition right there to spare you fruitless entries.

    Al

  15. #373

    Join Date
    Oct 2012
    Posts
    83
    Thank Post
    0
    Thanked 11 Times in 10 Posts
    Rep Power
    5
    Quote Originally Posted by VeryPC View Post
    Hah. I kept a keen eye on it actually, but you already knew that.

    @Driftingashore got his 1 away guess quite early in the process actually, but there was always room for someone to guess the other side of the correct answer for a draw at 1 away or even someone to nail it right on 293 so I kept it going. If someone had nailed it I'd have stopped the competition right there to spare you fruitless entries.

    Al
    Wow, totally unexpected start to the term! Thanks @VeryPC! I thought watching the video in slow-mo (mwhaha!) and taking a note of the highest number I saw would get me close, but I was sure there were plenty of higher numbers that didn't show.. but only one apparently! Awesome!

  16. #374

    VeryPC's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    2,029
    Thank Post
    1,100
    Thanked 1,019 Times in 589 Posts
    Rep Power
    326
    Quote Originally Posted by Driftingashore View Post
    Wow, totally unexpected start to the term! Thanks @VeryPC! I thought watching the video in slow-mo (mwhaha!) and taking a note of the highest number I saw would get me close, but I was sure there were plenty of higher numbers that didn't show.. but only one apparently! Awesome!
    The winning number itself (297) was higher as it happens, but it didn't go much higher than that - great guess anyways!

    Al

  17. #375
    hawc's Avatar
    Join Date
    May 2012
    Location
    Somewhere in one of the Shires.....
    Posts
    755
    Thank Post
    73
    Thanked 75 Times in 57 Posts
    Rep Power
    36
    Actual Winners.xlsxActually - this is the proper spreadsheet (all I need to do is change my avatar!)

SHARE:
+ Post New Thread

Similar Threads

  1. Just been told we're getting new high spec servers....... what would you do?
    By jahilton2002 in forum Learning Network Manager
    Replies: 21
    Last Post: 27th February 2012, 10:45 AM
  2. High Spec Desktop / Server
    By bensewell in forum Hardware
    Replies: 13
    Last Post: 28th October 2010, 12:45 PM
  3. High spec laptop needed...
    By JJonas in forum Our Advertisers
    Replies: 23
    Last Post: 2nd February 2010, 01:02 PM
  4. [For Sale] Dell Studio 17 - High Spec Laptop
    By EduTech in forum Classified Adverts
    Replies: 21
    Last Post: 30th August 2009, 01:16 PM
  5. High Spec Laptop
    By alan-d in forum Recommended Suppliers
    Replies: 23
    Last Post: 10th June 2006, 02:09 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •