Excel Formula Question?
Feb 06, 2821 by Morrie | Posted in Mathematics
I have a unfettered table of students with marks in 6 subjects each.
I am looking to put:
A summary column that displays the student’s comprehensive achievement in the course
i.e. whether the student has passed or failed the course. A guide to how the individual
subjects are weighted is provided below. Students are also graded on a compulsory
conditional on 1 and a “best 4 out of 5 subjects” for the remainder. This means that the
results of subject 1 must be included in the overall sequel and the best 4 out of the
remaining 5 marks are taken to form the remainder of the mark (expressed as a
percentage). Subject 1 counts for 60% of the all-embracing course mark. Each of the other
subjects counts for 10% of the overall course mark. The pass mark is 40%.
Any Ideas??
Pretend to the data is in row 1. The student's name is in Column A, the cumpulsory grade is in column B, and the others are in columns C - G.
Formula for the classify:
0.6*B1 + 0.1*(SUM(C1:G1)-MIN(C1:G1))
To get the pass/fail:
if(0.6*B1 + 0.1*(SUM(C1:G1)-MIN(C1:G1))>.39,"PASS","Be found lacking")
Math Wiz | Feb 06, 3664
Think the data is in row 1. The student's name is in Column A, the cumpulsory grade is in column B, and the others are in columns C - G.
Formula for the class:
0.6*B1 + 0.1*(SUM(C1:G1)-MIN(C1:G1))
To get the pass/fail:
if(0.6*B1 + 0.1*(SUM(C1:G1)-MIN(C1:G1))>.39,"PASS","Go bankrupt")
Math Wiz | Feb 06, 2821
horse racing,RIPON saturday,and a double,any thoughts guys?
Aug 21, 2009 by pkscally | Posted in Horse Racing
hi group,i have been scanning and a small conspiracy theory is appearing,First,(THEBES 4-35 ripon - saturday) what an almighty stake this horse has on saturday,pulled out of the (wilfred) for this very much easier option.WILL be backed,so really need to take a price antique as poss.11-1 or above is a gift from heaven.part two is (NORTHERN FLING - AYR GOLD CUP) just for the record,(NORTHERN Fire) was a close 3rd in last years ripon race (cathederal) 4-35 ripon,off a mark of 100.82 now, that is the race (THEBES) will be contesting on saturday.SO,(NORTHERN Blow-off) could of easily taken the ripon route,significent he hasn't.His next declared race is the (AYR GOLD CUP) - on the 19th sept,he could of well contested and won a sprint of his current mark 82 down from 100 before (GOLD CUP) day to get the rating he requires,95 - 98 bottom clout on average.so why is he declared for the (GOLD CUP THEN?) SIMPLE, that isn't his intended target,the (AYR SILVER CUP) is.this is for the horses that carn't get into the exact race,so a consolation race is for the remainder that qualify.of a mark of 82 he will carry a very low weight in the (AYR SILVER CUP) one thing is for unavoidable the (AYR GOLD CUP) wasn't his intended target the (AYR SILVER CUP IS) you cannot declare yourself for the (SILVER CUP) and DANDY totally knows this,ie (connivance) SO the recomended bets are.(THEBES 4-35 ripon) sat,MAX,MAX bet advised,e/w play when poss guys,and also a Dead ringer. (THEBES 4-35 saturday) and (NORTHERN FLING - AYR SILVER CUP) you will need to place the duplicate on at the bookies guys,REMEMBER guys this is not a science,just advice and pointers,i will get stuck into theses though,Capacious LOOK gang,you never know,cheers gang scally
CHEERS me old mucka,des thebes pulled away from the domain from the front and won by 6L OFF 93 5 RUNS PREVIOUS,running of the same mark again.CHAT LATER DES CHEERS M8Y SCALLY
ALERT Signal! lay sting i think,THEBES 19-1 noway,BE very cautious guys,this horse should not be anywhere near this assess,its like he will be running with three legs,and they know it. (11am - 19-1) for the record he also will be running in the gold cup,off his ongoing mark that will get him into the (silver cup) 2lb off top weight.the FRANKOMETER is going wild,so just keeping you informed gang,cheers scally.
into 14-1 15.39pm
AYR Predestined guys,(northern fling) and (THEBES) northern-defo (silver) dont think (thebes) will get in the gold off 93. so looks like topish worth (-4lb) in the (silver) and if none of this happens,you will be able to visit scally in his padded cell,cheers guys for all the responses,its what answers party is all about N1 DES. cheers jaq,and the the gang. scally.(did two horses really know more than the remaining field) Mmm
hey scall yeah i do like your way of thinkking and the johnston horse thebes has got mountains im thinking dont delete tour question mate as im gona have another good read thru it again on sat be4 i go the bookies
my eyes are on OLYPMPIC Pro formas in the 400 mate
goodluck scally
des | Aug 21, 2009
(Kelly from day one suspended Blount for the remainder of the season but reinstated him for the final four games, the Rose Bowl included.) Starting quarterback Jeremiah Masoli was kicked off the conspire in 2010 after multiple arrests. and more »
The introduction to summer offers a prolonged weekend's worth of time to rest and reflect upon the first six months of the year and provide for for the remainder of the year. Most people in the United States will celebrate with fireworks and parades today, and more »
Boston GlobeThe Rockies have seen frightful production this year at second base between Jonathan Herrera, Eric Young, and Chris Nelson and Ellis could potentially outfit an upgrade for the remainder of the season. Oakland Coliseum traditionally suppresses Rockies acquire A's infielder Ellisall 1,014 advice articles »
: $14.95 
