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 ...
12th December 2011, 02:42 PM #1
Calculating %A*-C in Result Spreadsheets
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.
12th December 2011, 02:52 PM #2
I wouldn't mind having a look if thats ok
12th December 2011, 03:31 PM #3
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.
12th December 2011, 03:32 PM #4
Is there of doing it without macros??
12th December 2011, 03:45 PM #5
Copy and paste formula...?
By EaglesNerd in forum How do you do....it?
Last Post: 22nd March 2011, 12:58 PM
By Sivadam in forum MIS Systems
Last Post: 27th August 2009, 12:43 PM
By Andie in forum Wireless Networks
Last Post: 18th March 2008, 03:19 PM
By vikpaw in forum MIS Systems
Last Post: 28th January 2008, 12:56 AM
By sixfootsy in forum MIS Systems
Last Post: 15th January 2008, 04:47 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)