Setting up Spreadsheets, Part 1 - Buying Cars using Google Sheets and AI

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 ก.พ. 2025

ความคิดเห็น • 61

  • @kentonnur
    @kentonnur 4 หลายเดือนก่อน +7

    Harry Enfields ‘Tim Nice But Dim ‘ would describe Sam as a ‘bloody nice chap !’

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Bloody good fellow!

  • @markdockerill
    @markdockerill 4 หลายเดือนก่อน +3

    A good starting point for many Sam.... It's the next steps with AI that I think many will find very useful!

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +1

      Yes, it will get interesting in the next few episodes!

  • @markwilliams7034
    @markwilliams7034 4 หลายเดือนก่อน +2

    I have never nor probably will be able to wrap my head around creating spreadsheets, but a fascinating watch Sam.

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Oh there's always time!

  • @pdcoupland
    @pdcoupland 4 หลายเดือนก่อน +1

    Thanks Sam that was really interesting, looking forward to Part 2

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Thanks, the starter before the main I think!

  • @naderhassan5704
    @naderhassan5704 4 หลายเดือนก่อน +1

    Another great insight Sam, thanks for sharing 👍🏼👍🏼👊🏼

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      My absolute pleasure old chap

  • @wayne2socialmedia
    @wayne2socialmedia 4 หลายเดือนก่อน +1

    Great start to this new series Sam, can wait for it to get geeky and in depth with AI, thanks Wayne

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Thanks Wayne, this is the starter before the main course!

    • @iangrundy957
      @iangrundy957 4 หลายเดือนก่อน +1

      Great introduction to the use of a spreadsheet, pitched perfectly. Looking forward to the next one.

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Ah thank you!

  • @billionbear
    @billionbear 3 หลายเดือนก่อน

    Loving your content, Sam.

    • @WattsOnCourt
      @WattsOnCourt  3 หลายเดือนก่อน

      Thanks so much !

  • @zzhughesd
    @zzhughesd 4 หลายเดือนก่อน +1

    Sam the Man. Thanks. I used to be techy for the trade back in 05!!! No more. Another Dinasour. Need get into this

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Absolutely! Useful for not only cars either. keep watching, we may just bring you back!

  • @recruitmentwebsites
    @recruitmentwebsites 4 หลายเดือนก่อน +1

    Thank you

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Absolute pleasure

  • @michaelwilson3844
    @michaelwilson3844 4 หลายเดือนก่อน +1

    Hi Sam that was jolly interesting , like how easy it was to whittle down what was right for you , good luck look forward to the next one , hope Dad is ok

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      It’s great to be able to weed out the cars that don’t match your criteria! Ramping it up on the next one

  • @joealex1700
    @joealex1700 2 หลายเดือนก่อน +1

    Thanks a bunch for the awesome video! I've been using it ever since and it's made my life so much easier.
    Can you share all the paperwork in a video you need to have and handle to customers from warranty to invoice? And how you organise your paperwork please

    • @WattsOnCourt
      @WattsOnCourt  2 หลายเดือนก่อน

      @@joealex1700 brilliant! So glad you found it useful! I’ll be doing some more vids soon when I’m not so snowed under! Stay tuned!

  • @andypalin3287
    @andypalin3287 4 หลายเดือนก่อน +3

    Cheers Sam. It gave me a chance to get 40 winks! 😜

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      I'm so glad you managed to have a well-earned snooze! Would you like me to make the next one a little longer? !!

    • @andypalin3287
      @andypalin3287 4 หลายเดือนก่อน +2

      @@WattsOnCourt that would be great ... cheers Sam! 😂

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +1

      @@andypalin3287 think nothing of it!

    • @andypalin3287
      @andypalin3287 4 หลายเดือนก่อน +2

      @@WattsOnCourt I hope you're Dad's doing better Sam 🙂

  • @peterharris1682
    @peterharris1682 4 หลายเดือนก่อน +1

    Well explained thanks Sam

  • @phantom9138
    @phantom9138 4 หลายเดือนก่อน +1

    Awesome been waiting for this 🙏👍

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      hope you liked it. stay tuned for the next episode!

  • @Dan-78
    @Dan-78 4 หลายเดือนก่อน +4

    Let’s get Sam up to 10k

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +3

      Oh gosh, that would be quite something! Perhaps to celebrate I’ll invite everyone to the Tally for a free knees up?

    • @Damoburch
      @Damoburch 4 หลายเดือนก่อน +1

      @@WattsOnCourt Ha ha. Actually think this is the first video you haven't made reference to going for "a pint"!

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +1

      Shit! I need to do something about that!

  • @ammo4184
    @ammo4184 6 วันที่ผ่านมา +1

    Like google sheets, use it a lot. Did think you could do another column with your own car score. 1= Best 10 = worst, then score each car in your shortlist. Highest margin = 1, lowest margin = 10 (based on 10 cars obvs) then same score for AT Retail rating, highest % = 1, lowest = 10. Add the 2 scores together then divide by 2 to score your potential auction beauties from 1 to 10. Or don't. Laters 👋

    • @WattsOnCourt
      @WattsOnCourt  2 วันที่ผ่านมา +1

      Oh yes, there are plenty of columns to add but just have t got round to the second video yet!

  • @zzhughesd
    @zzhughesd 4 หลายเดือนก่อน +1

    The Fly !!!! I can here it in Cheshire.

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Never mind the fly, is it sunny today in Cheshire?

  • @rjdavies1982
    @rjdavies1982 4 หลายเดือนก่อน +1

    Hi Sam, thanks for another fascinating vid! My interest is in classic cars so I’m wondering if a similar or modified approach could be applied to the classics world!

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +1

      OOh, im not sure. possibly but mainstream data may not cover these cars for obvious reasons. AI may be able to help but it will need some very specific prompts!

  • @greyhorse1211
    @greyhorse1211 4 หลายเดือนก่อน +1

    Do you do the same process when choosing what beer to drink 🤔

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      I'm never fussy when it comes to a cold beer!

  • @re-cyclewight
    @re-cyclewight 3 หลายเดือนก่อน +1

    Any more videos in this series Sam?

    • @WattsOnCourt
      @WattsOnCourt  2 หลายเดือนก่อน

      They will come but I just haven’t had a second to breathe recently.

  • @mikepalmer7687
    @mikepalmer7687 4 หลายเดือนก่อน +1

    100K he’s brilliant

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Wowzers! 100K god knows when / if thats going to be!

  • @MarcAMM2024
    @MarcAMM2024 4 หลายเดือนก่อน +1

    Thanks so much Sam! I'm used to using spreadsheets and excel so I'm really keen to use this when I get started. One question...do you take the Auto Trader retail estimate as gospel or do you adjust based on any live data? I say this as I looked at that first car on the AB auction list (BMW 3 series Touring 2021, 30k miles) and found cars on Autotrader that were newer with only 6k miles at £37k. That's the bit that worries me most - the margin may not be as it seems and that's a key criteria for bidding on cars and making a margin. PS. Hope your Dad is doing okay. Cheers, Marc

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน +1

      Hi Marc, It's an interesting one. If that car was specked up to the hills it would fetch a higher retail price from Autotrader. I didn't look at that car in detail so I couldn't really say. I never use Auto traders retail valuation as gospel, just as a guide. Its a good starting point and we must also consider that cars will fetch alot less in some cases. For people starting out and dipping their toe in the boiling water, data can really help and Autotrader is a good starting point. I went to try and buy a Mokka yesterday and the bloody thing went 1.5K above cap. I always try and have about 5 or 6 cars studied in detail when I physically go to an auction as you will get the odd car that does cartwheels in price either way! With time and knowledge in the industry and within ones niche, one will be able to see if the cars are over or under priced. BMW's are not really my bag but the mummy trucks are and I'm slowly getting a good understanding of where the market really is for those cars. Dad is doing much better thank you!

  • @midnightrider287
    @midnightrider287 4 หลายเดือนก่อน

    Give Sam a year and he'll be 'considerably richer than ...YOW!'

  • @davidvale8968
    @davidvale8968 4 หลายเดือนก่อน +1

    Must have clicked on Open University 😊😊

    • @WattsOnCourt
      @WattsOnCourt  3 หลายเดือนก่อน

      I’ll be handing out certificates!

  • @joannelomas-xv9nz
    @joannelomas-xv9nz 4 หลายเดือนก่อน +1

    Is there a price max purchase or retail car price applied to your trade insurance? Many thanks £1100 per annum sounds really cheap?

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      Yes, trade price at 11k, I may need to increase this slightly soon and will let you know the premium

  • @iang4817
    @iang4817 4 หลายเดือนก่อน +2

    Stop calling it AI😂

    • @WattsOnCourt
      @WattsOnCourt  4 หลายเดือนก่อน

      I'd love to call it something else!