Monday, April 27, 2015

Method to calculate interpolation

Interpolate
Interpolation is a method used to determine a present or future value factor when the exact factor does not appear in either a present or future value table. Interpolation assumes that the change between two values is linear and that the margin of error is insignificant.

ေမးခြန္း။
သုည (zero) ရက္ အတြက္ ၁၀၀%။
၁၄ ရက္ဆိုရင္ >၉၀%။
က်န္တဲ႕ ၁ရက္၊ ၂ရက္၊... ၁၃ ရက္အတြက္
% ဘယ္ေလာက္စီလဲ။
ေနာက္ ရက္ ၂၀ ဆိုရင္ ဘယ္ေလာက္ % က်န္မလဲ။
................
ဒီလိုမ်ိဳး linear တစ္ခုအတြက္ ၾကားမွာလိုတဲ႕ ဂဏန္းကိုျဖစ္ေစ
ေနာက္ထပ္ ခန္႕မွန္းဂဏန္းကိုျဖစ္ေစလိုအပ္တဲ႕အခါ တြက္ႏိုင္ဖို႕
Download Example: http://1drv.ms/1z8fZAD

Ref Source: https://support.microsoft.com/en-us/kb/214096

Tuesday, February 4, 2014

How to solve: Too many different cell formats in Excel

Excel မွာ Format လုပ္လို႕မရဘဲ
"Too many different cell formats" ဆိုတဲ႕ message
ဒါမွမဟုတ္ workbook တစ္ခုကေနတစ္ခု copy ကူး paste လုပ္တဲ႕အခါ
“Microsoft Excel can’t paste data” ဆိုတဲ႕ message
ဒီလိုၾကံဳလာရင္ သံုးဖို႕

http://cid-53e1d37f76f69444.office.live.com/self.aspx/.Public/XLCleaner/XLCleanerDotNET4.0.zip


Source: https://support.microsoft.com/kb/213904
Source:http://sergeig888.wordpress.com/2011/03/21/net4-0-version-of-the-xlstylestool-is-now-available/