+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Calculating Residuals in AM7 in Technical; Hi All, I am planning on setting up templates to calculate residuals when the results come out in August, I'm ...
  1. #1

    Join Date
    Jan 2011
    Thank Post
    Thanked 0 Times in 0 Posts
    Blog Entries
    Rep Power

    Calculating Residuals in AM7

    Hi All,

    I am planning on setting up templates to calculate residuals when the results come out in August, I'm using last year's data to have a play.

    I've done RESULT - APS in one review column then another to divide by 6 to get the residual. However, when the result of the review column is negative, dividing it by 6 then puts it back to positive which is obviously a problem. Same thing occurs for Value Added.

    Is there a way round this? I don't want to go back to Excel as we have done in previous years. Ideas/suggestions welcome!!


  2. #2

    Join Date
    Mar 2010
    Thank Post
    Thanked 21 Times in 19 Posts
    Rep Power
    How do you get a -ve value for APS?

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Saudi Arabia
    Thank Post
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    Quote Originally Posted by Banjo View Post
    How do you get a -ve value for APS?
    That's what i was wondering.

    Maybe the result is really a Value Added score or some measure of deviation from predictions...?
    Is APS best 6 or 8 or am i just thinking about something else?

    I just did a trial on a marks-integer aspect and dividing a negative number by a positive constant i.e. 6 doesn't make the answer positive, which is what i'd expect. The only way i'm thinking that could happen is if it's a grade aspect where the lower grades have negative scores associated with them.

+ Post New Thread

Similar Threads

  1. calculating cells without draging selection
    By tinmanjo in forum Office Software
    Replies: 3
    Last Post: 1st July 2010, 12:01 PM
  2. [SIMS] Good AM7 Data Structure
    By CAM in forum MIS Systems
    Replies: 9
    Last Post: 28th October 2009, 12:13 AM
  3. Calculating Server Energy Usage
    By wesleyw in forum Hardware
    Replies: 4
    Last Post: 21st January 2009, 01:56 PM
  4. Calculating days to next birthday?
    By My220x in forum General Chat
    Replies: 3
    Last Post: 28th July 2008, 12:12 PM
  5. Calculating a variety of % in SIMS
    By sixfootsy in forum MIS Systems
    Replies: 6
    Last Post: 15th January 2008, 05:47 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts