+ Reply to Thread
Results 1 to 13 of 13

Using Excel as a racing Pigeon Timing system

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6

    Using Excel as a racing Pigeon Timing system

    Good day, Everyone

    Would you kindly assist me with formulas to populate the fields in my attached sheet.
    Please note the sheet will receive a code from an RFID chip on a pigeons foot, once the code s]is received from the e-ring excel needs to identify the pigeon and calculate the speed based on the release time and the arrival time with the distance shown on the sheet.

    I have attempted to enter the formulas but i am very bad with VB...

    The results I want to obtain is that excel recognize the
    Ering number and mstch it with the data in the pigeon data sheet..it must calculate speed based on the release time in the clocking sheet and display under km per hour and velocity is meter per minute.
    I assume that excel can populate the fields in the clocking sheet once the rfid is scaned

    I hope you can help or guide me

    Thank you
    Owen
    Attached Files Attached Files
    Last edited by OwenMaasdorp; 07-14-2021 at 11:56 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: Using Excel as a racing Pigeon Timing system

    Hi. You did not tell us your expected results, or where to look in which sheet. At a guess:

    =VLOOKUP(B8,ERing!A:B,2,FALSE)

    in Clocking sheet, C8
    Glenn



  3. #3
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6
    Hi Kennedy

    I updated my querry...basically the sheet must act as a timer..that display results in the clocking sheet..the pigeon data sheet will have the pigeon information..so once the rfid ring is scaned excel must use the current system time and calculate the speed based on the release time and distance entered in the clocking sheet.

    Thank you for replying and pointing out the short commings of my request..I am learning still.
    Last edited by AliGW; 07-15-2021 at 01:33 AM. Reason: Unnecessary quotation removed.

  4. #4
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,206

    Re: Using Excel as a racing Pigeon Timing system

    I have attached an adaption of a schools cross country logging/timing app that I produced some months ago.
    I am not familiar with the technicalities of pigeon racing so it may need further enhancement.
    It is all VBA/macro driven - there are no on sheet formula.
    First fill in the 'entrants' page - press 'transfer' - this loads the 'timing' page - at present it only caters for a 'mass' start.
    torachan.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: Using Excel as a racing Pigeon Timing system

    No, that doesn't help me one bit.

    1. Which sheet should I bee looking at?

    2. What do you want to see?

    3. Where do you want to see it?

    4. Where does the answer come from?

  6. #6
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6

    Thumbs up Re: Using Excel as a racing Pigeon Timing system

    Good day, Torachan
    Please see the attached second draft is how far, I came please note that I will try your sheet and see if it will work on the same concept as mine with the RFID ring or e-ring.
    Attached now is the sheet as far as I came, each sheet will have comments, I only have issues on the sheet named clocking sheet, I loved your sheet how it looked and hope that you can help me to make mine look so good...and yes I struggle VBA..perhaps you have an idea.
    Please see the comments on the sheet and please help me, I tried all but if you read the comments you would see where my problems is.

    Thank you for taking time to help me.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6

    Re: Using Excel as a racing Pigeon Timing system

    Good day, Kennedy

    Please see the attached the second draft, sheets, please see the comments on the sheet named clocking sheet, this is the sheet where I have problems, one is the speed does not update when I enter another e-ring number and also the issue is that each time I change or add another e-ring number it also update the arrival time of the previous pigeons.
    If you check each column now have a comment that explain it.
    The short of it is that I cannot get the speed correct and the time is updating previous arrivals as well
    I hope you can guide or help me.
    Attached Files Attached Files

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,651

    Re: Using Excel as a racing Pigeon Timing system

    @Owen - it's Glenn. Kennedy is his surname.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: Using Excel as a racing Pigeon Timing system

    I replaced the formula in th epruple cells to hide the errors, and to make the formula fully draggabale across and dnown:
    =IFERROR(VLOOKUP($B8,ERing!$A:$E,1+COLUMNS($C8:C8),FALSE),"")

    In G8, copied down, I used this. But first, you have to go to File/Options/Formulas/Enable Iterative calculations
    =IF(B8="","",IF(G8="",NOW(),G8))

    the formuale in the yellow-ish cells have been tidied up to enable them to be copied down the columns and hide error messages.

    So. Add an RFID number in B8, then wait a few seconds and then in B9, etc.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6

    Re: Using Excel as a racing Pigeon Timing system

    Thank you Ali,

    I will apologies to Glenn.

  11. #11
    Registered User
    Join Date
    07-13-2021
    Location
    Windhoek
    MS-Off Ver
    2010
    Posts
    6

    Re: Using Excel as a racing Pigeon Timing system

    Thank you, Glenn
    I apologies for using your surname, I meant no disrespect.
    I appreciate the assistance and have tested it as you advised, this is exactly what I wanted, now I can see why you have so much green bars, indeed you are an expert and once again, I appreciate your time you shared assisting me.
    I will now test it with the pigeons and do a few short flights.

    Regards,

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: Using Excel as a racing Pigeon Timing system

    No need to apolgise... my wife calls me much worse names than "Kennedy"!!

    Glad to help and thanks for the feedback.

  13. #13
    Registered User
    Join Date
    04-16-2022
    Location
    london
    MS-Off Ver
    2010
    Posts
    1

    Re: Using Excel as a racing Pigeon Timing system

    Hey is here anyone who know Germany system Excel for racing Pigeon, it's kind of best system have 14 races count 33 percent of the prizes, total distance, and total points,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help With Formula For Horse Racing Excel Sheet
    By racecapper in forum Excel General
    Replies: 7
    Last Post: 11-19-2014, 03:13 AM
  2. Excel 2007 : Excel Project, Horse Racing Anaysis
    By M.A.Tyler in forum Excel General
    Replies: 4
    Last Post: 12-18-2012, 02:20 PM
  3. Help With Formula For Horse Racing Excel Sheet
    By racecapper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2010, 06:38 AM
  4. Pigeon-holing rows of information
    By Iamtrying in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2009, 07:27 PM
  5. Horse Racing system
    By Nineteen80eight in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2007, 02:30 PM
  6. Daily Racing Form: Horse racing
    By mehtalmann in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-11-2006, 04:40 PM
  7. [SOLVED] How do I set up stopwatch racing times in Excel?
    By Armand in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2006, 08:55 PM
  8. horse racing excel program
    By tedbo in forum Excel General
    Replies: 0
    Last Post: 03-12-2006, 08:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1