Mountain Bike Participant Database, incorpoarting race times and RFID data
$30-250 USD
완료함
게시됨 9년 이상 전
$30-250 USD
제출할때 지불됩니다
I require an excel participant database using data retrieved from an external registration system (excel format), containing unique ID data (to be supplied).
This data is to be easily searched on the excel 'homepage' to confirm riders when they arrive at the course on the day.
When a rider arrives and gives the marshal some criteria (name, number etc), the information can be typed in and shown on screen.
The marshal then scans a unique RFID bracelet using hardware that saves/appends the unique RFID code to a text file (notepad) that is imported into excel and saved to the rider for the days racing. This unique code will be used when collating the days results. The unique RFID code will change per rider per round.
When the rider returns their bracelet, the bracelet is scanned and we can check that it has been returned. We can then search after the race is anyone is unaccounted for (or havent handed in their bracelet).
There are 6 rounds in the 2015 season.
Not all riders will participate in all rounds. Points are allocated for the position where the rider finishes each round. These overall points determine the riders overall category position.
I will supply all rider data necessary. Its a case of preparing the database for use.
I will supply the formatting of the RFID scan.
Id prefer excel as I am an intermediate user, and cannot make modifications if required. It would also be great if it is easily transferable to google docs, as I would ultimately like to make a live version, where riders can search based on criteria.
I have a docket printer that i have used to print the individual rider results of the day.
Would be great if we can use the riders 'return scan' to automatically print out their results! (if time permits).
Happy to explain further using Skype (english). I am +8 GMT (Perth, Australia).
I am always available on email, but Skype after work (after 6pm).
Attached is a results table from a particular race last year. The associated excel document will be referenced when creating a user database for the 2015 season.
I hope this makes sense - could be some change in the project as we go through the steps in completion.
I require this urgently.
Cheers
Steve
I am an expert in Excel and Access database as well as sharepoint development and can create a database as per your requirements. If needed I wouldnt mind create some forms and macro functions to make it more user friendly and would make analyzing the data fairly easy. If needed I'll help you creating a web version for this.
PMP, MBA and professional data analyst here. Worked with large and complex data sets in Excel, Tableau, SPSS etc. to generate reports, analysis and presentation.
Hello sir...Would you can just click on discuss button and start chat with me.. Kindly if you want high quality work then as soon as possible contact me. Please give me chance to prove myself.
Thanks Regard’s
Junaid Software Engineer
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz is my Skype ID)
Tasleem Naz (Female)
Hi there Steve!
I'm Mo and I've had plenty of experience developing and building excel spreadsheets. Being an Engineer, I come from an infrastructure background and have built spreadsheets to satisfy the needs of various stakeholders, from high level management who require detailed analytic data to frontline field workers who need a way to keep track of project readiness and inspection completions.
I'm very versatile and open to discuss scoping with you over Skype. I'm also an English-Speaker (Aussie Born) and in your time zone too (roughly... I'm on the East Coast!)
Happy to design something that will be user friendly (or Marshal-Friendly), simple and easy to use, tested and ready to go.
Looking forward to hearing your response.
Regards
Mo