Presentation Slides

Writeup

Three Programs

Max of column 2

This puts the max of column 2 of the output file into the bottom of column 2.

load(file.out, " ", A1)
vv(C2) = max(C2:v(C2))
print vv(C2)

GPA Calculator

GradesUnits.out is a file with the grades in the first column, and the units for the class in the second column. This program, takes the two collumns, and calculates a GPA, which it stores in E4.

load(GradesUnits.out, " ", A1)
C = A * B
D = B * 4
E1 = sum(C)
E2 = sum(D)
E3 = E1 / E1
E4 = E3 * 4
print E4

Holiday Spending Net Profits

SpendingReceiving.out is a file with one column of approximate untaxed costs of presents, and the second column of approximate untaxed costs of gifts received. The third and fourth columns contain the taxed value. All the sums are stored, and finally, you get your net profits for this holidays gift exchange stored in E1.

load(SpendingReceiving.out, " ", A1)
vv(A) = sum(B:v(A))
vv(B) = sum(B:v(B))
C = B * 1.1
vv(C) = sum(C:v(C))
D = B * 1.1
vv(D) = sum(D:v(D))
E1 = vv(C) - vv(D)

HW3 Submission

Submission Document