Maths Expert+Excel Expert Help

[ctpgamage]

මචන්ලා...ඉහත රූපයේ දෑක්වෙන ආකාරයට A ලක්ෂයේ ඛණ්ඩාoකය දන්නවනම් B හා C ලක්ෂ වල ඛණ්ඩාoක සොයාගෑනීමට Microsoft Excel වලින් Formula එකක් දාන විදිය දන්නකෙනෙක් කියල දෙන්නකො.......

 

[chirart1]

sarala rekawa

mathaka na ban A/L karapuwa

 

[ctpgamage]

sarala rekawa

mathaka na ban A/L karapuwa

Ow ABC point 3ma ekama sarala rekawaka tiyenne....

 

[නෙලුම් කුමාරි]

මට පෙන්නැනේ pic එක

 

[TDM]

..oya A wala kandanka ganna heti,,,ookata exel walin liyaaganda puluwanne neee..eeka oone neene...

 

[නෙලුම් කුමාරි]

C පෙන් නැහැනේ ....හරියට පැහැදිලි මදි....

 

[ctpgamage]

..oya A wala kandanka ganna heti,,,ookata exel walin liyaaganda puluwanne neee..eeka oone neene...

thanks machan.....machan mata ona A wala kandanka yodaganimin B saha C calculate karaganna kramayak......

 

[TDM]

ahhh,,,ehemada,,idapan,,mama excel install karalada danne nee,,install karala thibboth ekk liyala ewannn..

 

[TDM]

wait..

 

[TDM]

B wala X kandaankayata enne "=793.496-8.136*SIN(ATAN(793.496/648.871))"
B wala Y kandaankayata enne "=648.871+8.136*COS(ATAN(793.496/648.871)))"

C wala X => "=793.496+4.651*SIN(ATAN(793.496/648.871))"
C wala Y => "=648.871-4.651*COS(ATAN(793.496/648.871))"

ara photo ekee man A daala thiyena thenata B daaganin,,eekolla B eka C karaganin......weradila daala thiyenne..

 

[kandya]

B wala X kandaankayata enne "=793.496-8.136*SIN(ATAN(793.496/648.871))"
B wala Y kandaankayata enne "=648.871+8.136*COS(ATAN(793.496/648.871)))"

C wala X => "=793.496+4.651*SIN(ATAN(793.496/648.871))"
C wala Y => "=648.871-4.651*COS(ATAN(793.496/648.871))"

ara photo ekee man A daala thiyena thenata B daaganin,,eekolla B eka C karaganin......weradila daala thiyenne..

 

[ctpgamage]

B wala X kandaankayata enne "=793.496-8.136*SIN(ATAN(793.496/648.871))"
B wala Y kandaankayata enne "=648.871+8.136*COS(ATAN(793.496/648.871)))"

C wala X => "=793.496+4.651*SIN(ATAN(793.496/648.871))"
C wala Y => "=648.871-4.651*COS(ATAN(793.496/648.871))"

ara photo ekee man A daala thiyena thenata B daaganin,,eekolla B eka C karaganin......weradila daala thiyenne..

thanks machan mama balannam...

 

[TDM]

ei dooo,,,nikan dath pennannee,,,pereeethayaaa.. ,,,aruuge ara suvanior eka deela daapan...

thanks machan mama balannam...

ela ela.. (Y)

 

[kandya]

ei dooo,,,nikan dath pennannee,,,pereeethayaaa.. ,,,aruuge ara suvanior eka deela daapan...


ela ela.. (Y)

මන් ළඟ නෑ ඔයි එහම මගුලක්

 

[ctpgamage]

B wala X kandaankayata enne "=793.496-8.136*SIN(ATAN(793.496/648.871))"
B wala Y kandaankayata enne "=648.871+8.136*COS(ATAN(793.496/648.871)))"

C wala X => "=793.496+4.651*SIN(ATAN(793.496/648.871))"
C wala Y => "=648.871-4.651*COS(ATAN(793.496/648.871))"

ara photo ekee man A daala thiyena thenata B daaganin,,eekolla B eka C karaganin......weradila daala thiyenne..

මචන් මේ විදියට ගත්තහම Poin එක අර සරල රේඛාවට එන්නෙ නැ.....

 

[ctpgamage]

කවුරුවත් නෑද්දො....