Office Software Thread, Excel formula for Capped Point Score/Best 8 per pupil in Technical; Has anyone got a solution for calculating capped point score per pupil in Excel? So far I've got
22nd November 2012, 01:16 PM #1
- Rep Power
Excel formula for Capped Point Score/Best 8 per pupil
Has anyone got a solution for calculating capped point score per pupil in Excel? So far I've got
but this doesn't take into account the GCSE weighting for equivalencies e.g. if a BTEC subject is in the eighth highest add this twice.
I already have a row with GCSE weighting per subject on it so I almost need to combine the above formula with SUMPRODUCT...somehow?
23rd November 2012, 12:06 PM #2
I think your formula could be rewritten as:
Then you could simply add in the weighting as follows:
where $BG2:$DA2 contain your weightings for each subject column (except this might need to be an absolute range reference depending upon how you've set up your spreadsheet).
23rd November 2012, 01:14 PM #3
- Rep Power
Thanks for the reply but I can't get this to work, using the formula above gives me a value error. I tried using , instead of * to seperate the arrays in the formula but this just gives a total SUMPRODUCT, not a largest 8 SumProduct?
23rd November 2012, 02:22 PM #4
Make sure that all your arrays are the same size. That's the most likely source of the value error.
Any chance you could paste the formula that was generating the error or a mock up of what your spreadsheet looks like?
Last edited by Pico; 23rd November 2012 at 02:23 PM.
Reason: Corrected myself.
By sqdge in forum Office Software
Last Post: 10th February 2013, 06:18 AM
By park_bench in forum MIS Systems
Last Post: 5th December 2012, 02:30 PM
By russdev in forum Office Software
Last Post: 9th May 2008, 11:51 AM
By DSapseid in forum Windows
Last Post: 7th November 2007, 04:56 PM
By timbo343 in forum How do you do....it?
Last Post: 1st October 2007, 05:55 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)