Ukwenyuka kwezinga lokushisa kwama-winding kunqunywa indlela yokumelana
okujwayelekile sinikeze ifomula engezansi:
imfuneko eyinhloko inothi: Ukumelana nama-winding ekupheleni kokuhlolwa kunganqunywa ngokuthatha izilinganiso zokumelana ngokushesha ngangokunokwenzeka ngemva kokucisha bese kuthi ngezikhathi ezimfushane ukuze ijika lokumelana nesikhathi lihlelwe ukuze kutholwe ukumelana ngesikhathi sokucima.
Ukuze ngenze ukubala kube lula, ngenze ifayela lohlelo lokubala ngisebenzisa ishidi le-excel kanye ne-VBA. Ifomu lingakwazi ukudweba ngokuzenzakalelayo ijika elifakiwe ngokwenani lokumelana okokufaka kanye nephoyinti lesikhathi elihambisanayo (isikhawu sesikhathi), isibalo esimisiwe sekhevu efakiwe siyisibalo esiyi-quadratic, chofoza kabili ijika ukuze umiselele isibalo esifakiwe. Ukuxhumana kwefomu kukhonjiswe ngezansi:
Isihloko sethebula namaseli anengemuva eliphuzi amaseli okuqukethwe kwawo okungashintshwa. Ngemva kokufaka inani lokumelana, uhlelo lubala ngokuzenzakalelayo futhi lugcwalise inani lesikhathi ngokwenani lesikhathi esinikezwe ngaphambili. Kukhona futhi amaseli emenyu amaningi etafuleni, okwenza kube lula ukugcwalisa nokuphrinta.
Landa ifayela
imfuneko eyinhloko inothi: Ukumelana nama-winding ekupheleni kokuhlolwa kunganqunywa ngokuthatha izilinganiso zokumelana ngokushesha ngangokunokwenzeka ngemva kokucisha bese kuthi ngezikhathi ezimfushane ukuze ijika lokumelana nesikhathi lihlelwe ukuze kutholwe ukumelana ngesikhathi sokucima.
Ukuze ngenze ukubala kube lula, ngenze ifayela lohlelo lokubala ngisebenzisa ishidi le-excel kanye ne-VBA. Ifomu lingakwazi ukudweba ngokuzenzakalelayo ijika elifakiwe ngokwenani lokumelana okokufaka kanye nephoyinti lesikhathi elihambisanayo (isikhawu sesikhathi), isibalo esimisiwe sekhevu efakiwe siyisibalo esiyi-quadratic, chofoza kabili ijika ukuze umiselele isibalo esifakiwe. Ukuxhumana kwefomu kukhonjiswe ngezansi:
Isihloko sethebula namaseli anengemuva eliphuzi amaseli okuqukethwe kwawo okungashintshwa. Ngemva kokufaka inani lokumelana, uhlelo lubala ngokuzenzakalelayo futhi lugcwalise inani lesikhathi ngokwenani lesikhathi esinikezwe ngaphambili. Kukhona futhi amaseli emenyu amaningi etafuleni, okwenza kube lula ukugcwalisa nokuphrinta.
Landa ifayela