1. New to Christmas lighting? Get started with the AusChristmasLighting 101 Manual:
    auschristmaslighting.com/wiki/AusChristmasLighting-101

Ray Wu - In spreadsheet form

Discussion in 'RGB Lights - Intelligent Pixels and 3-Channel RGB' started by caffeine, Jan 6, 2014.

  1. caffeine

    caffeine Full Time Elf

    Joined:
    Nov 25, 2010
    Messages:
    115
    Likes Received:
    0
    Location:
    Melbourne (Wantirna)
    All,


    I hope this helps people.


    I hate trying to find things in Ray's store. It's a horrendous experience..


    What I've tried to do, and it took a while, was to tabularise all the products I could find (well at least the main categories).


    Now I confess to not being able to tell the difference in some cases (there appear to be the exact same specced strings for different prices under different listings) but it's a start!


    The spreadsheet is editable, so if it is useful then it would be great for people to add/change it as required. If I'm missing a crucial column, add it. If you have comments about a specific product, note it.


    I'll try to keep it up to date!

    If you want to use/browse/read the spreadsheet please click here

    If you want to EDIT it (insert/update/delete) please click here



    Why is that important? If you filter items for your searching it will live update for everyone and save like that, which can be annoying of confusing...


    Cheers,


    Caff
     
  2. Bob in WV

    Bob in WV New Elf

    Joined:
    Dec 18, 2012
    Messages:
    1
    Likes Received:
    0
    GREAT work...sure saves a lot of digging!

    Bob
     
  3. greg58

    greg58 Full Time Elf

    Joined:
    Dec 19, 2012
    Messages:
    210
    Likes Received:
    0
    Location:
    Thornton
    Thanks Mate, this will save some time...............
     
  4. miw01

    miw01 New Elf

    Joined:
    Feb 7, 2012
    Messages:
    8
    Likes Received:
    0
    Location:
    Manchester
    Great idea


    Have added my preference and put my user id in spare column


    Mike

     
  5. fasteddy

    fasteddy I have C.L.A.P Global Moderator Generous Elf

    Joined:
    Apr 26, 2010
    Messages:
    6,491
    Likes Received:
    19
    Location:
    Albion Park NSW
    Find Me On:
    This will help a lot of users just starting out, thanks for sharing
     
  6. AussieDoug

    AussieDoug Full Time Elf

    Joined:
    Dec 1, 2012
    Messages:
    375
    Likes Received:
    0
    Just froze the top 3 rows & fixed up the 'module' tab headings as they were on the bottom.

    Great work on the spreadsheet though.
     
  7. AAH

    AAH I love blinky lights :) Community Project Designer

    Joined:
    Dec 27, 2010
    Messages:
    2,548
    Likes Received:
    14
    Location:
    Eaglehawk
    Find Me On:
    All the top text is in Spanish(???) for me. Is it possible for a noob like me to see it in English?
     
  8. fasteddy

    fasteddy I have C.L.A.P Global Moderator Generous Elf

    Joined:
    Apr 26, 2010
    Messages:
    6,491
    Likes Received:
    19
    Location:
    Albion Park NSW
    Find Me On:
    Put your glasses on Alan, Its in english :D
     
  9. AAH

    AAH I love blinky lights :) Community Project Designer

    Joined:
    Dec 27, 2010
    Messages:
    2,548
    Likes Received:
    14
    Location:
    Eaglehawk
    Find Me On:
    I know you've had spelling issues in the past Ed but surely even on your worst spelling day you should be able to see that the heading isn't in English.

    Strange English.jpg

     
  10. fasteddy

    fasteddy I have C.L.A.P Global Moderator Generous Elf

    Joined:
    Apr 26, 2010
    Messages:
    6,491
    Likes Received:
    19
    Location:
    Albion Park NSW
    Find Me On:
    Its in english here so looks like your being transported to Spain
     
  11. OP
    OP
    caffeine

    caffeine Full Time Elf

    Joined:
    Nov 25, 2010
    Messages:
    115
    Likes Received:
    0
    Location:
    Melbourne (Wantirna)
    Hmmm.. I'm going to have to have a play with how best to make this work.


    The community edits are useful, however google docs is very 'live'. That means that as people filter to find things (which is what it is for) it updates for all users viewing, and saves it.


    That's OK if everyone clears the filters when they're done and there is only 1 person in it at once but less than ideal otherwise...
     
  12. jimlights

    jimlights New Elf

    Joined:
    Jan 5, 2014
    Messages:
    1
    Likes Received:
    0
    Thanks Caffeine! This is extremely helpful for someone starting out like myself!
     
  13. DeeJai

    DeeJai Is that Magic Smoke?!?

    Joined:
    Oct 18, 2011
    Messages:
    1,007
    Likes Received:
    0
    Location:
    No longer in Radelaide
    very nice mate.


    Now, you need a front page with some Vlookups so people can just enter partial values. i.e. 2811, and it shows all 2811 items.


    I wonder if Ray Ray would provide his list... lol.


    Anyways, very nice
     
  14. OP
    OP
    caffeine

    caffeine Full Time Elf

    Joined:
    Nov 25, 2010
    Messages:
    115
    Likes Received:
    0
    Location:
    Melbourne (Wantirna)
    Looking like I might need to do my own wrapper around it anyway Matt to get around the editing issues so I could do exactly that, allow community access to add/delete/amend items but put display pages around the results that users can individually search/filter etc.
     
  15. Benschristmaslights

    Benschristmaslights Dedicated Elf Global Moderator Generous Elf

    Joined:
    May 2, 2010
    Messages:
    2,125
    Likes Received:
    7
    Location:
    Elderslie
    Find Me On:
    that is great caf could you add pics to it also???

    just a idea
     

Share This Page