You should follow our advisory notes below:
We understand that we cannot be too prescriptive regarding how to set
out your calculations and that users often have good reason for not
following our advice. Please adopt our recommendations as far as
practical.
-
DON'T REPEAT - Search the repository before you propose a
calculation we do not want to repeat ourselves.
- USE XLC TEMPLATE - Use the XLC calculation template
this helps to keep a consistent approach to site calculations. It will help you manage the calculations units. The
layout is based upon a traditional pro forma calculation sheet. View
the video which explains how to set out a calculation
using the XLC template.
- SHOW EQUATIONS - Display cell formulae using the XLC
Add-in.
It is important to show how something is calculated as well as the
result of the calculation. XLC Ed or XLC Pro can be used to present
your cell formulae.
- IDENTIFY ADD-INS - Clearly identify any other Excel Addins
that are required.
- INCLUDE A SKETCH - Always include a sketch. View this video which explains how to make great
sketches with Excel.
- VALIDATE YOUR CALCULATION - You must validate your
calculation, say how you know it's correct. Does
the calculation reproduce a result in a publication or book? Has the
calculation been independently checked by another person?
- INCLUDE REFERENCES - Reference
relevant text books where ever
possible. Copyright prevents us from any physical
copying of text books but the calculation method can be encoded into
Excel worksheets. The text book reference adds credibility to your
calculation and directs users to the calculation theory.
- NO PLAGIARISM - Make sure that you own the calculation. We
never want to be accused of plagiarism so you must have the right to
give us your calculation.
- UNPROTECTED WORKSHEETS - Keep worksheets and macros
unprotected.
- ADVERTISE YOURSELF - We are happy for users to include links to their own websites and web pages.
We understand that we cannot be too perscriptive regarding how to set out your calculations and that users often have good reason for not following our advice. These notes are intended as a guide only.
In uploading a calculation to the site you the publishing rights and
ownership of the calculation is granted to ExcelCalcs. We will reward your contribution with a
free XLC Pro subscription.
Click here to upload
|
Calculation Repository 