+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Calculating %A*-C in Result Spreadsheets in Technical; Hi, I knocked up a quick and dirty set of macros in excel to automatically calculate %A*-C (or equivalent) in ...
  1. #1

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    36

    Calculating %A*-C in Result Spreadsheets

    Hi,

    I knocked up a quick and dirty set of macros in excel to automatically calculate %A*-C (or equivalent) in a Sims marksheet exported spreadsheet. The macros append a formula (that supports filtering of records) to blank cells at the top of the rows, will detect between GCSE/BTEC results etc, and should support similar spreadsheets from any source.

    If anyone is interested in seeing/using this then please let me know and I'll upload it.

    Matt

  2. #2

    featured_spectre's Avatar
    Join Date
    Nov 2008
    Posts
    12,503
    Thank Post
    1,684
    Thanked 2,054 Times in 1,491 Posts
    Blog Entries
    2
    Rep Power
    464
    I wouldn't mind having a look if thats ok

  3. #3

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    36
    I've uploaded the files here.

    Import the Add-In (grade macros.xmal) into excel with Excel Options -> Add-Ins then follow the notes in the sample spreadsheet.

    Let me know how you get on.

    Matt
    Attached Files Attached Files

  4. #4

    featured_spectre's Avatar
    Join Date
    Nov 2008
    Posts
    12,503
    Thank Post
    1,684
    Thanked 2,054 Times in 1,491 Posts
    Blog Entries
    2
    Rep Power
    464
    Is there of doing it without macros??

  5. #5

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    36
    Copy and paste formula...?



SHARE:
+ Post New Thread

Similar Threads

  1. Count the number of Girls and Boys in a spreadsheet
    By EaglesNerd in forum How do you do....it?
    Replies: 4
    Last Post: 22nd March 2011, 01:58 PM
  2. Non-EDI Results in SIMS
    By Sivadam in forum MIS Systems
    Replies: 4
    Last Post: 27th August 2009, 01:43 PM
  3. Replies: 19
    Last Post: 18th March 2008, 04:19 PM
  4. Replies: 2
    Last Post: 28th January 2008, 01:56 AM
  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)

Posting Permissions

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