examples for test

ch 6: date and time
give a bunch of times in and out
get me the sum of the time for the person
multiply by hourly rate
how much does he earn

Bill worked from 4/1/1903 to 5/4/1905. He had off on Sundays and Saturdays, as well as the holidays listed in C5:C30
He got $60 a day. How much did he earn?

Bill came in at 5:30 AM. He worked for 5 hours, 12 minutes and 2 seconds. Generate the time he leaves.

summing over a range using simple functions
and using array formulas

some simple array manipulations

chapters for second midterm

formula: ch 6, 7, 14, 15
grauer: 5, 6, 7

note to self. midway on midlevel exercise 3 on ch 6, assigned mid 4 for hw

my email address

is joshwaxman at gmail dot com.

contact me if you need to know your grade

in chapter 6, we finished up to NETWORKDAYS

cs88 test 1 planned

next wednesday
1) some group of tasks from ch1 (grauer)
2) some group of tasks from ch2 (grauer)
3) some group of tasks from ch3 (grauer)
4) some group of tasks from ch4 (grauer)
5) 2 or 3 formula oriented tasks from formula book, ch 1-5

walkenbach
ch 3) making names of different types
ch 4) writing simple formulas, making use of simple functions we have seen (Cs12 type material, maybe slightly harder/)
ch 5) formula to solve something
a) give me a *plan* for extracting the third word from The rain in Spain falls....
b) i'll tell you what we want accomplished, and give you a general plan. write the formula

=FIND(" ", A38)    =FIND(" ", A38, A54+1)    =SUBSTITUTE(A38, " ", "@", 2)    =FIND("@", C54)    =MID(A38, A54+1, D54-A54-1)

things to do with nested if

leapyear problem