I remembered Linda telling me that there were some errors in the formulas noted in Chapter 9 on spreadsheets. I was confused because I knew that I had verified that the formulas worked and had used copy/paste to copy them into the chapter manuscript. I obviously missed the errors when reviewing the chapter proofs (won't happen again!) What happened is that the parentheses for creating formulas were changed to brackets in nested formulas. That rule works for typed text, but not formulas!!
So.... if you are attempting to replicate the formulas on pages 158, be sure to use only parentheses, and not brackets. For example for Application & Competencies #2, the spreadsheet output (after you drag the formula to rows 3 though 5, should look like this (I shortened the field names):
| Prenatal Dt | Due Date | Gest Age at Visit |
| 1/1/2009 | 9/1/09 | 5.29 |
| 9/2/2009 | 2/20/10 | 15.57 |
| 4/1/2010 | 9/1/10 | 18.14 |
| 1/20/2011 | 2/20/11 | 35.57 |
Be sure to change the brackets in exercise 3 to parentheses, too!
No comments :
Post a Comment