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] Updated: (OFFICE-2221) SYD: add formula andcorrect method's name



     [ http://tools.oasis-open.org/issues/browse/OFFICE-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-2221:
--------------------------------

    Proposal: 
Change "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" that apparently is the correct name.

Add formula as given at  http://wiki.services.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SYD_function

To calculate depreciation, SYD adds the year numbers during the asset's life; the year numbers taken backward and divided by that sum give the proportion of the total loss of value to assign to depreciation that year.

SYD = (originalcost - salvagevalue) * (lifetime+1 - year) * 2 / ((lifetime+1) * lifetime)


  was:
Add formula as given at  http://wiki.services.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SYD_function

Change "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" that apparently is the correct name.



> SYD: add formula and correct method's name
> ------------------------------------------
>
>                 Key: OFFICE-2221
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2221
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Broken out from OFFICE-916
> SYD
> - "sum-of-years' digits method" This phrase appears to be copied from Excel.
>   - I'd suggest either "sum- of-years' digits method" or "sum of years'-digits
>     method".
> - Formula is at:
>   http://wiki.services.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SYD_function

-- 
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]