{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["test with fish","Instructions","Test with bags"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"test with fish","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"merged":[[2,0,2,8],[3,0,3,1]],"flags":["formulas_cached_only"]}
["Revised: 2/23/06",{"$nulls":7},"OMB No. 0648-0330"]
[{"$nulls":8},"Expiration Date: 2/28/2009"]
["RECORD OF DAILY FLOW SCALE TEST"]
["Vessel Name"]
["Time Test Started"]
["Date",null,null,"2007-08-28"]
[]
["Step 1.  Weigh at least 400 kg of fish on flow scale and divert into baskets."]
[]
["Flow scale display at start of test:"]
["Flow scale display at end of test:"]
[]
["Flow scale weight of Fish",{"$nulls":3},0]
[]
[]
["Step 2.  Weigh the fish in baskets on observer platform scale"]
[]
[null,"Wt. Fish+ baskets",null,"Wt. Fish+ baskets",null,"Wt. Fish+ baskets"]
[1,null,2,null,3]
[4,null,5,null,6]
[7,null,8,null,9]
[10,null,11,null,12]
[13,null,14,null,15]
[16,null,17,null,18]
[19,null,20,null,21]
[22,null,23,null,24]
[25,null,26,null,27]
[]
["Total weight of fish and baskets:",{"$nulls":5},0]
[]
["Step 3.  Weigh the baskets without the fish (enter 0 if tared)"]
[]
["Sea Conditions at time of test (Beaufort Scale--between 1 and 12):"]
[]
["The platform scale weight of the fish is:",{"$nulls":5},0]
["The flow scale error is:",{"$nulls":5},0]
["The percent error is:",{"$nulls":5},{"$error":"#DIV/0!"}]
["     If the percent error is between  -3.0 % and +3.0% the scale passes"]
["     If the percent error is not between -3% and +3% the scale fails.  You may retest at any time"]
[]
["Step 4.  Print form, sign it and have the observer sign it"]
[]
["Signature of vessel operator or factory manager:"]
[]
[]
[]
["I observed this test "]
[]
["Signature of observer"]

{"sheet":"Instructions","index":1,"n_rows":65,"n_cols":9,"rows_kept":65,"merged":[[2,0,2,8],[35,0,35,8],[36,0,36,8],[37,0,37,8],[38,0,38,8]],"flags":["formulas_cached_only"]}
["Revised: 2/23/06",{"$nulls":7},"OMB No. 0648-0330"]
[{"$nulls":8},"Expiration Date: 2/28/2009"]
["INSTRUCTIONS"]
[]
[null,"FOR USERS OF EXCEL 97 or OFFICE 97"]
["This file should be stored as Daily.xlt.  It should "]
["be in a folder named \"templates\" in the same folder as Excel."]
[]
["To use, go to FILE--NEW and choose  \"daily.xlt\""]
["       when finished, "]
["          you may save the file under a new name (*.xls), or just print out and close without saving"]
[]
["To alter the original template:"]
[null,"choose FILE OPEN"]
[null,"go to the directory in which EXCEL is stored (often C:\\Program files\\Microsoft office\\"]
[null,"open the folder templates"]
[null,"open the file daily.xlt"]
[null,"save again as daily.xlt"]
[]
[]
[null,"FOR USERS OF EXCEL 95"]
[]
["This file can be stored wherever you wish"]
["To use, open the file and enter the test information."]
["If you choose to save under the same name, it will overwrite the original file."]
[]
[]
[null,"FOR ALL USERS"]
[]
["the cells that do not need information entered in them are locked.  If you need to override this,"]
["Go to TOOLS--PROTECTION--PROTECT SHEET… and deselect the  \"contents\" box"]
[]
["the test may be conducted with fish or with bags of sand.  If you use bags of sand, go to the \"test "]
["with bags of sand\" tab.   If you test with fish go to the \"test with fish\" tab"]
[]
["This test must be conducted at least once every 24 hours when use of the scale is required.  If the scale test fails the daily test, it can be retested at any time but you can't use it to weigh fish till it"]
["passes.  Once you have completed the daily test, print the form out, sign it and have the observer sign it.  You must keep the signed form on board until the end of the fishing year.  After the end of "]
["the fishing year, it must be retained by the vessel owner for three years.  If you have questions"]
["concerning the daily test, or concerning any aspect of the at-sea scales program contact:"]
[]
[null,"Alan Kinsolving"]
[null,"Scales Program coordinator"]
[null,"National Marine Fisheries Service"]
[null,"2245 CO Bar Trail"]
[null,"Flagstaff AZ, 86001"]
[]
[null,"Phone:   (928) 774-4362"]
[null,"Fax:       (928) 774-4362"]
[null,"Email:    alan.kinsolving@noaa.gov"]
[]
[]
["PUBLIC REPORTING BURDEN STATEMENT "]
["Public reporting burden for this collection of information is estimated to average 45 minutes per response, "]
["including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, "]
["and completing and reviewing the collection of information.  Send comments regarding this burden estimate or any other "]
["aspect of this collection of information, including suggestions for reducing the burden, to Sue Salveson, "]
["Assistant Regional Administrator, Sustainable Fisheries Division, Alaska Region, NMFS, P.O. Box 21668,"]
[" Juneau, AK 99802 (Attn: Records Officer). "]
[]
["ADDITIONAL INFORMATION:  Before completing this form please note the following:  1) NMFS cannot conduct or "]
["sponsor this information request, and you are not required to respond to this information request, unless the form displays "]
["a currently valid OMB control number; 2) this information is being used to manage the At-Sea Scales Program; 3) Federal"]
[" law and regulations require and authorize NMFS to manage commercial fishing effort; 4) Submission of this information "]
["is required for scales approved by NMFS to weigh catch at sea; 5) Responses to this information request "]
["are not confidential except as required under the Privacy Act.    "]

{"sheet":"Test with bags","index":2,"n_rows":54,"n_cols":9,"rows_kept":54,"merged":[[2,0,2,8],[3,0,3,1]],"flags":["formulas_cached_only"]}
["Revised: 08/22/07",{"$nulls":7},"OMB Control No. 0648-0330"]
[{"$nulls":8},"Expiration Date: 08/31/2010"]
["RECORD OF DAILY FLOW SCALE TEST"]
["Vessel Name"]
["Time Test Started"]
["Date",null,null,"2007-08-28"]
[]
["Step 1.  Weigh sandbags on Platform scale.  Weigh no more than 50 kg of bags per load"]
[]
["load #","Weight"]
[1]
[2]
[3]
[4]
[5]
[]
["The total weight of sandbags is:",null,null,0]
[]
["Step 2.  Record the scale indicator weight and send the sandbags across the scale"]
["you will have to pass each bag across the scale",{"$nulls":4},{"$error":"#DIV/0!"},"times"]
["If you wish, simply enter the start and stop weights for the entire test in the first row"]
["run #","indicator start","indicator stop","weight"]
[1,null,null,0]
[2,0,null,0]
[3,0,null,0]
[4,0,null,0]
[5,0,null,0]
[6,0,null,0]
[7,0,null,0]
[8,0,null,0]
[9,0,null,0]
[10,0,null,0]
[11,0,null,0]
[12,0,null,0]
[]
["How many times did you pass each bag across the scale?",{"$nulls":5},{"$error":"#DIV/0!"}]
["Total weight of sandbags from flow scale:",{"$nulls":4},0]
["Total weight of sandbags from platform scale:",{"$nulls":4},{"$error":"#DIV/0!"}]
["The error of the flow scale is:",{"$nulls":4},{"$error":"#DIV/0!"},"%"]
["The percent error of the flow scale is:",{"$nulls":4},{"$error":"#DIV/0!"}]
["     If the percent error is between  -3.0 % and +3.0% the scale passes"]
["     If the percent error is not between -3% and +3% the scale fails.  You may retest at any time"]
[]
["Step 3.  ","Sea Conditions at time of test (Beaufort Scale--between 1 and 12):"]
[]
["Step 4.  Print form, sign it and have the observer sign it"]
[]
["Signature of vessel operator or factory manager:"]
[]
[]
[]
["I observed this test "]
[]
["Signature of observer"]