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
Bookmarks