Home arrow CARE Forum
FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
Re:QAQC charts and Bias calculations (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:QAQC charts and Bias calculations
#98
Nikki (Admin)
NWFSC-PSMFC
Admin
Posts: 26
graph
User Online Now Click here to see the profile of this user
Location: Oregon
Re:QAQC charts and Bias calculations 8 Years, 7 Months ago Karma: 0  
Oh, a quick note - these charts have a HUGE number of calculations. If you type in each data point and hit "enter" the sheet will make all those calculations each time, and each calculation can take 10-15 seconds (longer on an older machine. Trust me, i know.)

The way i've gotten around this headache is to go to File>Options>Formulas and click the "Manual" button under "calculation options". Now, when i paste in chunks of data or type in individual ages, it doesn't chug through all the calculations until i either save or hit F9. Then it takes about 10-15 seconds for it to make all the calculations combined and update all the cells and graphs.

 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
QAQC charts and Bias calculations
Nikki 2013/04/16 09:34
    thread link
thread linkthread link Re:QAQC charts and Bias calculations
Nikki 2013/04/22 14:09
    thread link
thread linkthread link Re:QAQC charts and Bias calculations
Nikki 2013/07/19 10:57
    thread link
thread linkthread link Re:QAQC charts and Bias calculations
Nikki 2013/08/13 09:54
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

© 2021 Committee of Age Reading Experts (CARE)
Disclaimer & Citation Info
Webmastera