DC hub based bike dyno, arduino code help needed

[bzhwindtalker]

Hi all,
We're trying to developp a simple chassis dyno to test and optimise our bikes.
I have a EVT4000 3000w rated DC hub motor I want to use as a roller and brake, mated with a variable resistor or coil with DC controller to make a variable electrical load.
There are some cheap load cells on aliexpress I want to try out.
I could probably get mesurements from the load cell and make the rotational speed measurement work on my own based on libraries, but I cant' code for shit

What I want to do is pretty simple :
-Read data from the lad cell at max frequency
-Compute rotational speed from interrupt based counter
-Write data in a exel sheet

So far I found some limiting things in the hardware I would want to use :
HX711 max sampling speed is about 80hZ
Serial connection for arduino is quite limiting to transfer data to Exel sheet

I may also have access to NI USB 6009 cards that may be more suitable, at least for the data transfer to the PC. I've used those cards quite a lot in the past with NI signal express soft, but the full licence is 1K€ :/

What would be the best route in your opinion?

thanks! Adam

 

[bzhwindtalker]

here's what I have so far :

 

[querlenker]

You can use processing to exchange data from the arduino to you computer. Than it is pretty simple to make a ui and write data to a file. I exported data in csv file to import in excel.