| Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
ezfit:target_algorithms_-_formula_v.2_2006 [2009/03/03 12:13]
smayr |
ezfit:target_algorithms_-_formula_v.2_2006 [2014/05/30 14:16] (current)
ajdavis [Soft Target] |
| |
| === Soft Target === | === Soft Target === |
| ^ Soft Target Freq (Hz) ^ Calculated Soft Target Level (dB) ^ Threshold Cell ^ Spreadsheet Formula ^ | ^ Soft Target Freq (Hz) ^ Hearing Loss ^ Calculated Soft Target Level (dB) ^ Threshold Cell ^ Spreadsheet Formula ^ |
| | 250 | 27.0 | B28 | ''=IF(B28<=20; 0; IF(B28=25; 2; IF(B28=30;4; IF(B28<60;(B28-25)/1.65; IF(B28<90; (B28-22.5-0.5*(B28-60))/1.65; IF(B28<120;31))))))'' | | | 250 | 75 | 27.0 | B28 | ''=IF(B28<=20; 0; IF(B28=25; 2; IF(B28=30;4; IF(B28<60;(B28-25)/1.65; IF(B28<90; (B28-22.5-0.5*(B28-60))/1.65; IF(B28<120;31))))))'' | |
| | 500 | 27.0 | C28 | ''=IF(C28<=20; 0; IF(C28=25; 2; IF(C28=30;4; IF(C28<60;(C28-25)/1.65; IF(C28<90; (C28-22.5-0.5*(C28-60))/1.65; IF(C28<120;31))))))'' | | | 500 | 75 | 27.0 | C28 | ''=IF(C28<=20; 0; IF(C28=25; 2; IF(C28=30;4; IF(C28<60;(C28-25)/1.65; IF(C28<90; (C28-22.5-0.5*(C28-60))/1.65; IF(C28<120;31))))))'' | |
| | 750 | 27.0 | D28 | ''=IF(D28<=20; 0; IF(D28=25; 2; IF(D28=30;4; IF(D28<60;(D28-25)/1.65; IF(D28<90; (D28-22.5-0.5*(D28-60))/1.65; IF(D28<120;31))))))'' | | | 750 | 75 | 27.0 | D28 | ''=IF(D28<=20; 0; IF(D28=25; 2; IF(D28=30;4; IF(D28<60;(D28-25)/1.65; IF(D28<90; (D28-22.5-0.5*(D28-60))/1.65; IF(D28<120;31))))))'' | |
| | 1000 | 29.0 | E28 | ''=IF(E28<=20; 0; IF(E28=25; 2; IF(E28=30;4; IF(E28<60;(E28-25)/1.65; IF(E28<90; (E28-22.5-0.5*(E28-60))/1.65; IF(E28<120;31))))))'' | | | 1000 | 80 | 29.0 | E28 | ''=IF(E28<=20; 0; IF(E28=25; 2; IF(E28=30;4; IF(E28<60;(E28-25)/1.65; IF(E28<90; (E28-22.5-0.5*(E28-60))/1.65; IF(E28<120;31))))))'' | |
| | 1500 | 30.0 | F28 | ''=IF(F28<=20; 0; IF(F28=25; 2; IF(F28=30;4; IF(F28<60;(F28-25)/1.65; IF(F28<90; (F28-22.5-0.5*(F28-60))/1.65; IF(F28<120;31))))))'' | | | 1500 | 85 | 30.0 | F28 | ''=IF(F28<=20; 0; IF(F28=25; 2; IF(F28=30;4; IF(F28<60;(F28-25)/1.65; IF(F28<90; (F28-22.5-0.5*(F28-60))/1.65; IF(F28<120;31))))))'' | |
| | 2000 | 31.0 | G28 | ''=IF(G28<=20; 0; IF(G28=25; 2; IF(G28=30;4; IF(G28<60;(G28-25)/1.65; IF(G28<90; (G28-22.5-0.5*(G28-60))/1.65; IF(G28<120;31))))))'' | | | 2000 | 95 | 31.0 | G28 | ''=IF(G28<=20; 0; IF(G28=25; 2; IF(G28=30;4; IF(G28<60;(G28-25)/1.65; IF(G28<90; (G28-22.5-0.5*(G28-60))/1.65; IF(G28<120;31))))))'' | |
| | 3000 | 31.0 | H28 | ''=IF(H28<=20; 0; IF(H28=25; 2; IF(H28=30;4; IF(H28<60;(H28-25)/1.65; IF(H28<90; (H28-22.5-0.5*(H28-60))/1.65; IF(H28<120;31))))))'' | | | 3000 | 90 | 31.0 | H28 | ''=IF(H28<=20; 0; IF(H28=25; 2; IF(H28=30;4; IF(H28<60;(H28-25)/1.65; IF(H28<90; (H28-22.5-0.5*(H28-60))/1.65; IF(H28<120;31))))))'' | |
| | 4000 | 21.0 | I28 | ''=IF(I28<=20; 0; IF(I28=25; 2; IF(I28=30;4; IF(I28<60;(I28-25)/1.65; IF(I28<90; (I28-22.5-0.5*(I28-60))/1.65; IF(I28<120;31)))))) - 10'' | | | 4000 | 95 | 21.0 | I28 | ''=IF(I28<=20; 0; IF(I28=25; 2; IF(I28=30;4; IF(I28<60;(I28-25)/1.65; IF(I28<90; (I28-22.5-0.5*(I28-60))/1.65; IF(I28<120;31)))))) - 10'' | |
| | 6000 | 18.0 | J28 | ''=IF(J28<=20; 0; IF(J28=25; 2; IF(J28=30;4; IF(J28<60;(J28-25)/1.65; IF(J28<90; (J28-22.5-0.5*(J28-60))/1.65; IF(J28<120;31)))))) - 13'' | | | 6000 | 90 | 18.0 | J28 | ''=IF(J28<=20; 0; IF(J28=25; 2; IF(J28=30;4; IF(J28<60;(J28-25)/1.65; IF(J28<90; (J28-22.5-0.5*(J28-60))/1.65; IF(J28<120;31)))))) - 13'' | |
| | 8000 | 13.0 | K28 | ''=IF(K28<=20; 0; IF(K28=25; 2; IF(K28=30;4; IF(K28<60;(K28-25)/1.65; IF(K28<90; (K28-22.5-0.5*(K28-60))/1.65; IF(K28<120;31)))))) - 18'' | | | 8000 | 90 | 13.0 | K28 | ''=IF(K28<=20; 0; IF(K28=25; 2; IF(K28=30;4; IF(K28<60;(K28-25)/1.65; IF(K28<90; (K28-22.5-0.5*(K28-60))/1.65; IF(K28<120;31)))))) - 18'' | |
| |
| At any Threshold frequency (e.g. Thresh Freq = 250Hz): | At any Threshold frequency (e.g. Thresh Freq = 250Hz): |