Excel: Allocating Streams to Students based on GPA and Choice Preference -

-

i have total of 64 students allocated 19 different streams on basis of gpa. students have indicated preference streams. 5 students can allocated first 3 streams (a-c), 4 students stream d , remaining fifteen streams 3 students each. have added data excel sheet have no idea how process achieve above results. the data organized this. i'm happy share original file couldn't find way upload that.

this solved automatically in vba macro faster version doing bit fast , dirty formulas. starts have already, ranking gpa.

insert 2 rows each student. in row calculate "filling" of streams. if have bazillion students, should write small macro copy paste every other line. shame excel not accept pasting empty values no-change-values.

either change rankings search/replace or create new sheet "desired allocation" value highest wanted stream. cell c2 should this:

 =20-'originalsheet'!c2

we working on new sheet

so have these rows: (student - allocation - availability - student - allocation - availability)

in allocation line, fill allocation of student above, in availability row fill current available spaces.

the first student gets allocated or hers choice.

the allocation row gets formula investigates if current cell has lowest possible value. so. row2: first student, row3: allocation, row4: new availability, row5: students wishes, row 6: use formula in cell c6

=if(sumproduct(max(($c5:$u5)*(($c4:$u4)>0)))=c6;1;0)

then next line, new availability simply

=c4-c6

copy paste formulas downwards. may trouble students on similar gpas ranking top bottom sets priority in scheme. don't have original file , don't have time build image looked worked tiny test-setup.

slightly easier doing hand, again; if have bazillion students , doing allocation - ask in vba section.

summary:

  1. rank gpa
  2. change highest wish highest number
  3. insert 2 rows each student
  4. calculate manually first student, should not difficult...
  5. use formulas , make cell references not bungled up.

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more