OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-2258) AMORDEGRC - frenchaccounting system? (also in AMORLINC)

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21389#action_21389 ] 

Andreas Guelzow  commented on OFFICE-2258:

If we look at current implementations and I try
then Gnumeric and OOo give the same answers for n=0,1,2,...,6 and according to a website on Excel, it gives the same answer at least in teh case n=1.
On the other hand, the values for 
=AMORDEGRC(20000;DATE(2008;1;5);DATE(2008;12;31);2000;n;0.2;1)    n=0,1,2,...,7
are completely different between Gnumeric and OOo so apparently they are using different coefficients in some ranges.

Moreover in both examples if one add all amortization amounts one get  results that exceed the expected value of 2100 and 18000 respectively.

> AMORDEGRC - french accounting system? (also in AMORLINC)
> --------------------------------------------------------
>                 Key: OFFICE-2258
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2258
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Patrick Durusau
>            Assignee: Robert Weir 
>             Fix For: ODF 1.2 CD 06
> Now reads: "Calculates the amortization value for the French accounting system using linear depreciation."
> I assume it should read: "Calculates the amortization value for an asset using linear depreciation."
> But that is just a guess on my part. (Same replacement in AMORLINC.)
> I don't know anything about French accounting systems so if someone will confirm my suggested correction I can enter it. 

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]