Baseline Wheel FFB Values - Google Sheet & FCM. Universal

[Lars Rosenquist]

So in your graph your ddr is around 16?

Yes, for mine it is. Values can vary per model and even per unit though. But you'll usually see roughly similar values per model. One of the exceptions there is the DFGT which varies wildy.

[poirqc]

Yes, for mine it is. Values can vary per model and even per unit though. But you'll usually see roughly similar values per model. One of the exceptions there is the DFGT which varies wildy.

I wonder if it varies from the min force test or from the linear force test. I would be good if people posted their results here.

[inthebagbud]

poirqc

Sorry for not understanding fully the process

in your sheet you have 4 tabs and the graph is based on the average of the 4 - are they just 4 separate tests

my initial screen looks like this



and gives the following results

force startX endX deltaX deltaXDeg
0 0 0 0 0
200 -37 -37 0 0
400 -37 -34 3 0.178531
600 -34 -24 10 0.425727
800 -25 -21 4 0.164797
1000 -22 -14 8 0.370794
1200 -17 268 285 12.840466
1400 68 471 403 18.127718
1600 42 660 618 27.782101
1800 -26 878 904 40.7187
2000 -34 1203 1237 55.742733
2200 -42 1359 1401 63.089951
2400 -76 1584 1660 74.763107
2600 -42 1905 1947 87.672234
2800 -21 2132 2153 96.955826
3000 -19 2230 2249 101.254295
3200 -18 2464 2482 111.760132
3400 -15 2833 2848 128.212402
3600 -16 2942 2958 133.12886
3800 4 3198 3194 143.730835
4000 -3 3326 3329 149.814606
4200 -2 3583 3585 161.377884
4400 -10 3665 3675 165.429153
4600 0 3761 3761 169.301895
4800 19 3971 3952 177.83017
5000 4 4025 4021 180.961319
5200 19 4082 4063 182.856491
5400 37 4114 4077 183.460739
5600 26 4234 4208 189.352249
5800 48 4259 4211 189.530792
6000 31 4250 4219 189.874115
6200 22 4317 4295 193.307388
6400 14 4361 4347 195.587097
6600 19 4360 4341 195.326157
6800 9 4341 4332 194.969101
7000 5 4352 4347 195.642029
7200 21 4368 4347 195.642029
7400 29 4451 4422 198.979172
7600 35 4511 4476 201.409927
7800 23 4530 4507 202.824448
8000 13 4472 4459 200.654617
8200 -1 4481 4482 201.766998
8400 9 4549 4540 204.280151
8600 14 4558 4544 204.458679
8800 13 4566 4553 204.884415
9000 13 4502 4489 202.014191
9200 24 4562 4538 204.211487
9400 -12 4535 4547 204.650955
9600 -10 4563 4573 205.818268
9800 12 4601 4589 206.49118
10000 9 4534 4525 203.607239

[poirqc]

inthebagbud, it would be easier for me to paste the data in the sheet if you attached the .CSV in the post instead. I have a hard time parsing the data when i copy paste it from some bare text.

[inthebagbud]

inthebagbud, it would be easier for me to paste the data in the sheet if you attached the .CSV in the post instead. I have a hard time parsing the data when i copy paste it from some bare text.

sorry for that - it didn't like upload of a csv so here is a zip with 4 output files log2 2015-07-26 15-22-30.zip

Thank you in advance for your time

[poirqc]

sorry for that - it didn't like upload of a csv so here is a zip with 4 output files log2 2015-07-26 15-22-30.zip

Thank you in advance for your time

There you go

TM TX FFB Output.zip

I attached the graph in 2 formats. You should be able to import them in google sheet, Excel or Open Office.

[inthebagbud]

poirqc

Thanks for the file, which gives me a graph like this



I would like to understand some of the information you have used from the table so I can interpret for myself what is being said


lineal step -this is derived from cell L51/45 - is this because cell L51 is where output = 100 and is divided by 45 because there are 5 steps before the mean value rises above the value of 1 (50 steps minus 5 = 45)

Scoop Knee- is the output figure of 48 derived by judging on the graph where the knee starts which equates to cell K26

Scoop Reduction with/without DDR - this is where I struggle as you use cells L21 and M21 in the formula, but should this not be row 26 to match that of the scoop knee row value?

Interpreting the required DDR I assume this will be somewhere between 0.1 and 0.12 as this is where the output rises above the value of 1



For anybody else using a TX wheel reading this please note my TM control panel settings are



poirqc thanks again for taking the time to go through this

[b_akerlite]

Thanks for this - its nice to have another tool to help dial in the wheel.
One question - The scoop knee calculation in the spreadsheet is based on formula "k21/100" - this seems weird as k21 is always going to be 38 no matter what data you input?? so whatever wheel gets tested it will always show 0.38 for scoop knee?

also what does DRR stand for?

edit - ahh ok - so you have to visually and look for the kink in your blue line in the graph?
This makes sense - (as i use compressors for audio so I should have copped the knee earlier!)

So in my graph my blue line kinks at input value of 28 so I have to look for 28 which is K16 and change all the scoop calculation formulas to reference line 16.... is that correct?!!!

[Lars Rosenquist]

Here's the output for my G27. Unsurprisingly, it's very similar to the G29 (minus wear and tear on my end I guess). I added the .ods in there as well as a zip file.

I screwed up the horizontal scale, but DRR is at 0.16 (16%)



G27 FFB Output.zip

[Schnizz58]

How do you run the test? I have selected Step Log 2 from the combobox but I don't see a button or anything to perform the test. I tried Refresh but that didn't seem to do anything.