{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Directions","Cook and Cool","Ambient"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Directions","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Directions: "]
["If the product is cooling after being cooked, choose the Cook and Cool calculator. "]
["If the product is cooling from ambient temperature (including warming during preparation), choose the Ambient Calculator."]
["Cook and Cool: First, determine which temperature zone to use (Zone 1 is 135°F-70°F; Zone 2 is 70°F-41°F).                                                              Next, enter your initial and your 2nd observed temperatures.                                                                                                                                                                                             Finally, enter your observed time change (final time - initial time), in minutes.                                                                                                                       The calculator will indicate a green cell if the appropriate temperature change was achieved or a red cell if it was not achieved."]
["Ambient: First, if observed, enter the temperature of food after preparation. This is the starting point to determine the appropriate cooling rate. If you were not present for the start of the cooling process and the PIC does not have accurate data, use 70°F.                                                                                                                                                                               Next, enter your initial and your 2nd observed temperatures. If your initial observed temperature was taken at the start of the cooling process, the inital observed temperature box will be automatically filled for you.                                                                                                                                                            Finally, enter your observed time change (final time - initial time), in minutes.                                                                                                                       The calculator will indicate a green cell if the appropriate temperature change was achieved or a red cell if it was not achieved."]
["Use:"]
["These calculators are tools designed to help you determine if a food product is being properly cooled using appropriate cooling methods. They should be used along with questioning and visual observation of the cooling process, but may not be used as the only factor in determining if the food is improperly cooling. If the cell is highlighted green, then the time/temperature parameters for cooling are being met. If the cell is highlighted red, additional information is needed. This may include taking more temperatures over an additional amount of time. "]

{"sheet":"Cook and Cool","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,0,18,1],[6,0,6,1]]}
["Zone 1 Cooling Parameters: 135°F-70F°"]
[]
["Step 1 - Enter your initial observed temp (°F) here: "]
[]
["Step 2 - Enter your 2nd  observed temp (°F) here: "]
[]
["Step 3 - Enter your observed time (in minutes) change here:                       *Initial time (minutes) observed - 2nd time (minutes) observed"]
[]
["Cooling rate observed:                                                                                    *Turns Green if achieved or Red if not achieved",null,{"$f":"((C3-C5)/C7)","v":{"$error":"#DIV/0!"}}]
[]
["Cooling rate needed: ",null,{"$f":" PRODUCT(65/120)","v":0.54}]
[]
["Zone 2 Cooling Parameters: 70F°-41F°"]
[]
["Step 1 - Enter your initial observed temp (°F) here: "]
[]
["Step 2 - Enter your 2nd  observed temp (°F) here: "]
[]
["Step 3 - Enter your observed time (in minutes) change here:                       *Initial time (minutes) observed - 2nd time (minutes) observed"]
[]
["Cooling rate observed:                                                                                    *Turns Green if achieved or Red if not achieved",null,{"$f":"((C15-C17)/C19)","v":{"$error":"#DIV/0!"}}]
[]
["Cooling rate needed: ",null,{"$f":" PRODUCT(29/240)","v":0.12}]

{"sheet":"Ambient","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,3,1],[5,1,6,2],[5,3,6,3],[12,0,13,2],[12,3,13,3],[4,0,6,0]]}
["Ambient Cooling Parameters"]
[]
["Step 1 - Establish the cooling rate.           "]
[null,null,null,200]
["*Enter temperature (°F) when preparation ended/cooling began. If you were not present for the start of the cooling process, use 70°F."]
[null,"Required Cooling Rate °F/minute:",null,{"$f":"IMSUB(D3,41)/240","v":-0.17}]
[]
[null,null,null,70]
["Step 2 - Enter your initial observed temp (°F) here: ",null,70,{"$f":"IF((NOT(D3=70)), D3, \"\")","v":0}]
[]
["Step 3 - Enter your 2nd observed temp (°F) here: "]
[]
["Step 4 - Enter your observed time (minutes) change here:                                          *Initial time (minutes) observed - 2nd time (minutes) observed"]
[]
[]
["Cooling rate observed:                                                                                    *Turns Green if achieved or Red if not achieved",null,null,{"$f":"IF(D3=D8,((C9-D11)/D13),((D9-D11)/D13))","v":{"$error":"#DIV/0!"}}]