Please see attached for color-coded offer  update.   I made a few changes from the file Kari sent last night.  Will print out for binder as well.
 
Colors mean the following:
Red-No Offer, Reserve
Yellow-Declined
Blue-Signed
Green-Open
White-Verbal acceptance