{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["REQ INFO","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","SPLIT"],"not_rendered":{"images":1,"defined_names":53},"read":"whole","date_system":"1900"}

{"sheet":"REQ INFO","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[2,6,2,8],[5,5,5,7],[7,2,8,8],[11,3,15,9],[17,3,18,9],[21,4,22,7],[23,4,24,7],[25,4,26,7],[27,4,29,7],[30,4,31,7],[33,2,35,8],[37,1,37,9]]}
[]
[]
[null,null,"MS State Department of Health",null,null,"Water System Name"]
[null,null,"Bureau of Public Water Supply",null,null,"PWS ID",null,"Reporting Year"]
[null,null,"Monthly Fluoride Operating Report (MFOR)"]
[{"$nulls":5},"Number of Wells/Plants with Fluoride Equipment (enter numbers only in this blank, e.g. 1,2,3, etc.)"]
[]
[null,null,"THIS PAGE MUST BE COMPLETELY FILLED OUT BEFORE YOU ENTER FLUORIDE DATA.  THE RELEVANT INFORMATION  ENTERED HERE WILL AUTOMATICALLY FILL IN THROUGHOUT THE REST OF THE WORKBOOK.  REQUIRED INFORMATION IS OUTLINED IN RED."]
[]
[]
[]
[null,null,"How to find your TFID","PLEASE READ THE FOLLOWING INSTRUCTIONS CAREFULLY:  \nUsing your fluoride barcodes, locate the TFID in the upper left corner just below your PWS ID.  It is five digits and begins with the letters \"TF\" followed by three numbers.  It stands for Treatment Facility ID.  Each well or plant that has fluoride equipment installed on it is known as a treatment facility and has a unique ID.  This is how MSDH identifies/tracks your fluoride data.  We do not use the local name(s) like \"Murphy Street Well\" or \"ABC Water Plant\".  If you have five wells/plants with fluoride, you will enter five TFIDs below to the left.  "]
[]
[]
[]
[]
[]
[null,null,"Treatment Facility ID (TFID)","Enter your treatment facility IDs in the spaces provided to the left.  Enter one TFID in each box.  Follow the same format as the two example TFIDs entered as a guide for you.  You'll have between 1 and 12."]
[null,null,"EXAMPLE     TF080    EXAMPLE"]
[null,null,"EXAMPLE     TF107    EXAMPLE"]
[]
[{"$nulls":4},"The MFOR is due by the 10th of each month."]
[]
[{"$nulls":4},"Email completed report to water.fluoride@msdh.ms.gov."]
[]
[{"$nulls":4},"If well/plant is offline, put an \"X\" on the dates offline."]
[]
[{"$nulls":4},"Do not submit split samples when offline.  Instead, email water.fluoride@msdh.ms.gov with the date you have gone offline, the reason, and the estimated startup date.  Send another email when you are back online."]
[]
[]
[{"$nulls":4},"Do not send empty bottles to the lab when offline!"]
[]
[]
[null,null,"There are automatic calculations throughout this workbook.  In order to get a \"Yes\" on Sufficient Samples you need at least 13 samples.  In order to get a \"Yes\" on Sufficient Samples In-Range, your Percentage In-Range needs to be at least 90%.  The Number In-Range counts samples between 0.55 - 1.24 mg/L.  \n\n**At a minimum, you are required to sample at a frequency of 3-days a week, with at least 13 samples a month.  Daily sampllng is recommended.**"]

{"sheet":"JAN","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR JANUARY"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,1,1)","v":"1900-01-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-01-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-01-03"}]
["1900-01-04"]
["1900-01-05"]
["1900-01-06"]
["1900-01-07"]
["1900-01-08"]
["1900-01-09"]
["1900-01-10"]
["1900-01-11"]
["1900-01-12"]
["1900-01-13"]
["1900-01-14"]
["1900-01-15"]
["1900-01-16"]
["1900-01-17"]
["1900-01-18"]
["1900-01-19"]
["1900-01-20"]
["1900-01-21"]
["1900-01-22"]
["1900-01-23"]
["1900-01-24"]
["1900-01-25"]
["1900-01-26"]
["1900-01-27"]
["1900-01-28"]
["1900-01-29"]
["1900-01-30"]
["1900-01-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"FEB","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR FEBRUARY"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,2,1)","v":"1900-02-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-02-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-02-03"}]
["1900-02-04"]
["1900-02-05"]
["1900-02-06"]
["1900-02-07"]
["1900-02-08"]
["1900-02-09"]
["1900-02-10"]
["1900-02-11"]
["1900-02-12"]
["1900-02-13"]
["1900-02-14"]
["1900-02-15"]
["1900-02-16"]
["1900-02-17"]
["1900-02-18"]
["1900-02-19"]
["1900-02-20"]
["1900-02-21"]
["1900-02-22"]
["1900-02-23"]
["1900-02-24"]
["1900-02-25"]
["1900-02-26"]
["1900-02-27"]
["1900-02-28"]
[60]
[]
[]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"MAR","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR MARCH"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,3,1)","v":"1900-03-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-03-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-03-03"}]
["1900-03-04"]
["1900-03-05"]
["1900-03-06"]
["1900-03-07"]
["1900-03-08"]
["1900-03-09"]
["1900-03-10"]
["1900-03-11"]
["1900-03-12"]
["1900-03-13"]
["1900-03-14"]
["1900-03-15"]
["1900-03-16"]
["1900-03-17"]
["1900-03-18"]
["1900-03-19"]
["1900-03-20"]
["1900-03-21"]
["1900-03-22"]
["1900-03-23"]
["1900-03-24"]
["1900-03-25"]
["1900-03-26"]
["1900-03-27"]
["1900-03-28"]
["1900-03-29"]
["1900-03-30"]
["1900-03-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"APR","index":4,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR APRIL"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,4,1)","v":"1900-04-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-04-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-04-03"}]
["1900-04-04"]
["1900-04-05"]
["1900-04-06"]
["1900-04-07"]
["1900-04-08"]
["1900-04-09"]
["1900-04-10"]
["1900-04-11"]
["1900-04-12"]
["1900-04-13"]
["1900-04-14"]
["1900-04-15"]
["1900-04-16"]
["1900-04-17"]
["1900-04-18"]
["1900-04-19"]
["1900-04-20"]
["1900-04-21"]
["1900-04-22"]
["1900-04-23"]
["1900-04-24"]
["1900-04-25"]
["1900-04-26"]
["1900-04-27"]
["1900-04-28"]
["1900-04-29"]
["1900-04-30"]
[]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"MAY","index":5,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR MAY"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,5,1)","v":"1900-05-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-05-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-05-03"}]
["1900-05-04"]
["1900-05-05"]
["1900-05-06"]
["1900-05-07"]
["1900-05-08"]
["1900-05-09"]
["1900-05-10"]
["1900-05-11"]
["1900-05-12"]
["1900-05-13"]
["1900-05-14"]
["1900-05-15"]
["1900-05-16"]
["1900-05-17"]
["1900-05-18"]
["1900-05-19"]
["1900-05-20"]
["1900-05-21"]
["1900-05-22"]
["1900-05-23"]
["1900-05-24"]
["1900-05-25"]
["1900-05-26"]
["1900-05-27"]
["1900-05-28"]
["1900-05-29"]
["1900-05-30"]
["1900-05-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"JUN","index":6,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR JUNE"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,6,1)","v":"1900-06-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-06-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-06-03"}]
["1900-06-04"]
["1900-06-05"]
["1900-06-06"]
["1900-06-07"]
["1900-06-08"]
["1900-06-09"]
["1900-06-10"]
["1900-06-11"]
["1900-06-12"]
["1900-06-13"]
["1900-06-14"]
["1900-06-15"]
["1900-06-16"]
["1900-06-17"]
["1900-06-18"]
["1900-06-19"]
["1900-06-20"]
["1900-06-21"]
["1900-06-22"]
["1900-06-23"]
["1900-06-24"]
["1900-06-25"]
["1900-06-26"]
["1900-06-27"]
["1900-06-28"]
["1900-06-29"]
["1900-06-30"]
[]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"JUL","index":7,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR JULY"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,7,1)","v":"1900-07-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-07-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-07-03"}]
["1900-07-04"]
["1900-07-05"]
["1900-07-06"]
["1900-07-07"]
["1900-07-08"]
["1900-07-09"]
["1900-07-10"]
["1900-07-11"]
["1900-07-12"]
["1900-07-13"]
["1900-07-14"]
["1900-07-15"]
["1900-07-16"]
["1900-07-17"]
["1900-07-18"]
["1900-07-19"]
["1900-07-20"]
["1900-07-21"]
["1900-07-22"]
["1900-07-23"]
["1900-07-24"]
["1900-07-25"]
["1900-07-26"]
["1900-07-27"]
["1900-07-28"]
["1900-07-29"]
["1900-07-30"]
["1900-07-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"AUG","index":8,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR AUGUST"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,8,1)","v":"1900-08-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-08-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-08-03"}]
["1900-08-04"]
["1900-08-05"]
["1900-08-06"]
["1900-08-07"]
["1900-08-08"]
["1900-08-09"]
["1900-08-10"]
["1900-08-11"]
["1900-08-12"]
["1900-08-13"]
["1900-08-14"]
["1900-08-15"]
["1900-08-16"]
["1900-08-17"]
["1900-08-18"]
["1900-08-19"]
["1900-08-20"]
["1900-08-21"]
["1900-08-22"]
["1900-08-23"]
["1900-08-24"]
["1900-08-25"]
["1900-08-26"]
["1900-08-27"]
["1900-08-28"]
["1900-08-29"]
["1900-08-30"]
["1900-08-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"SEP","index":9,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR SEPTEMBER"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,9,1)","v":"1900-09-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-09-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-09-03"}]
["1900-09-04"]
["1900-09-05"]
["1900-09-06"]
["1900-09-07"]
["1900-09-08"]
["1900-09-09"]
["1900-09-10"]
["1900-09-11"]
["1900-09-12"]
["1900-09-13"]
["1900-09-14"]
["1900-09-15"]
["1900-09-16"]
["1900-09-17"]
["1900-09-18"]
["1900-09-19"]
["1900-09-20"]
["1900-09-21"]
["1900-09-22"]
["1900-09-23"]
["1900-09-24"]
["1900-09-25"]
["1900-09-26"]
["1900-09-27"]
["1900-09-28"]
["1900-09-29"]
["1900-09-30"]
[]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"OCT","index":10,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR OCTOBER"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,10,1)","v":"1900-10-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-10-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-10-03"}]
["1900-10-04"]
["1900-10-05"]
["1900-10-06"]
["1900-10-07"]
["1900-10-08"]
["1900-10-09"]
["1900-10-10"]
["1900-10-11"]
["1900-10-12"]
["1900-10-13"]
["1900-10-14"]
["1900-10-15"]
["1900-10-16"]
["1900-10-17"]
["1900-10-18"]
["1900-10-19"]
["1900-10-20"]
["1900-10-21"]
["1900-10-22"]
["1900-10-23"]
["1900-10-24"]
["1900-10-25"]
["1900-10-26"]
["1900-10-27"]
["1900-10-28"]
["1900-10-29"]
["1900-10-30"]
["1900-10-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"NOV","index":11,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR NOVEMBER"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,11,1)","v":"1900-11-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-11-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-11-03"}]
["1900-11-04"]
["1900-11-05"]
["1900-11-06"]
["1900-11-07"]
["1900-11-08"]
["1900-11-09"]
["1900-11-10"]
["1900-11-11"]
["1900-11-12"]
["1900-11-13"]
["1900-11-14"]
["1900-11-15"]
["1900-11-16"]
["1900-11-17"]
["1900-11-18"]
["1900-11-19"]
["1900-11-20"]
["1900-11-21"]
["1900-11-22"]
["1900-11-23"]
["1900-11-24"]
["1900-11-25"]
["1900-11-26"]
["1900-11-27"]
["1900-11-28"]
["1900-11-29"]
["1900-11-30"]
[]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"DEC","index":12,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[0,0,0,12],[1,0,1,12],[3,0,3,4],[3,5,3,12],[4,0,4,4],[4,5,4,8],[4,9,6,12],[5,0,5,4],[5,5,5,8],[6,0,6,4],[6,5,6,8],[7,0,8,12],[50,0,54,0],[50,1,50,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12]]}
["Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--DAILY SAMPLE ENTRY FOR DECEMBER"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"}]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":3},"Email to water.fluoride@msdh.ms.gov by the 10th of each month.  Reports are due every month, even if offline!"]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["DATE",{"$f":"IF('REQ INFO'!$C21=\"\",\"No Entry\",'REQ INFO'!$C21)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C22=\"\",\"No Entry\",'REQ INFO'!$C22)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C23=\"\",\"No Entry\",'REQ INFO'!$C23)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C24=\"\",\"No Entry\",'REQ INFO'!$C24)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C25=\"\",\"No Entry\",'REQ INFO'!$C25)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C26=\"\",\"No Entry\",'REQ INFO'!$C26)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C27=\"\",\"No Entry\",'REQ INFO'!$C27)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C28=\"\",\"No Entry\",'REQ INFO'!$C28)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C29=\"\",\"No Entry\",'REQ INFO'!$C29)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C30=\"\",\"No Entry\",'REQ INFO'!$C30)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C31=\"\",\"No Entry\",'REQ INFO'!$C31)","v":"No Entry"},{"$f":"IF('REQ INFO'!$C32=\"\",\"No Entry\",'REQ INFO'!$C32)","v":"No Entry"}]
[{"$f":"DATE('REQ INFO'!I4,12,1)","v":"1900-12-01"}]
[{"$f":"IF(MONTH(A11+1)=MONTH(A11),A11+1,\"\")","v":"1900-12-02"}]
[{"$f":"IF(MONTH(A12+1)=MONTH(A12),A12+1,\"\")","v":"1900-12-03"}]
["1900-12-04"]
["1900-12-05"]
["1900-12-06"]
["1900-12-07"]
["1900-12-08"]
["1900-12-09"]
["1900-12-10"]
["1900-12-11"]
["1900-12-12"]
["1900-12-13"]
["1900-12-14"]
["1900-12-15"]
["1900-12-16"]
["1900-12-17"]
["1900-12-18"]
["1900-12-19"]
["1900-12-20"]
["1900-12-21"]
["1900-12-22"]
["1900-12-23"]
["1900-12-24"]
["1900-12-25"]
["1900-12-26"]
["1900-12-27"]
["1900-12-28"]
["1900-12-29"]
["1900-12-30"]
["1900-12-31"]
["AVG",{"$f":"IFERROR(AVERAGE(B11:B41),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(AVERAGE(C11:C41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MAX",{"$f":"MAX(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MIN",{"$f":"MIN(B11:B41)","v":{"v":0,"d":"0.00"}},{"$f":"MIN(C11:C41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Count",{"$f":"COUNT(B11:B41)","v":0},{"$f":"COUNT(C11:C41)","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient Samples",{"$f":"IF(COUNT(B11:B41)>=13, \"YES\", \"NO\")","v":"NO"},{"$f":"IF(COUNT(C11:C41)>=13, \"YES\", \"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
["Number In-Range",{"$f":"COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")","v":0},{"$f":"COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Sufficient In-Range",{"$f":"IFERROR(IF(COUNTIFS(B11:B41, \">=0.55\", B11:B41, \"<=1.244\")/COUNT(B11:B41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},{"$f":"IFERROR(IF(COUNTIFS(C11:C41, \">=0.55\", C11:C41, \"<=1.244\")/COUNT(C11:C41)>=0.9, \"YES\", \"NO\"), \"NA\")","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Percent In-Range",{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(B11:B41)), --(B11:B41>=0.54), --(B11:B41<=1.24))/COUNT(B11:B41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(C11:C41)), --(C11:C41>=0.54), --(C11:C41<=1.24))/COUNT(C11:C41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(D11:D41)), --(D11:D41>=0.54), --(D11:D41<=1.24))/COUNT(D11:D41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(E11:E41)), --(E11:E41>=0.54), --(E11:E41<=1.24))/COUNT(E11:E41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(F11:F41)), --(F11:F41>=0.54), --(F11:F41<=1.24))/COUNT(F11:F41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(G11:G41)), --(G11:G41>=0.54), --(G11:G41<=1.24))/COUNT(G11:G41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(H11:H41)), --(H11:H41>=0.54), --(H11:H41<=1.24))/COUNT(H11:H41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(I11:I41)), --(I11:I41>=0.54), --(I11:I41<=1.24))/COUNT(I11:I41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(J11:J41)), --(J11:J41>=0.54), --(J11:J41<=1.24))/COUNT(J11:J41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(K11:K41)), --(K11:K41>=0.54), --(K11:K41<=1.24))/COUNT(K11:K41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(L11:L41)), --(L11:L41>=0.54), --(L11:L41<=1.24))/COUNT(L11:L41), \"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(--(ISNUMBER(M11:M41)), --(M11:M41>=0.54), --(M11:M41<=1.24))/COUNT(M11:M41), \"NA\")","v":"NA"}]
[]
["Operator Notes "]

{"sheet":"SPLIT","index":13,"n_rows":44,"n_cols":38,"rows_kept":44,"merged":[[0,0,0,17],[0,19,0,37],[1,0,1,17],[1,19,1,37],[3,0,3,4],[3,5,3,12],[3,13,6,18],[3,19,3,23],[3,24,3,31],[3,32,6,37],[4,0,4,4],[4,5,4,12],[4,19,4,23],[4,24,4,31],[5,0,5,4],[5,5,5,12],[5,19,5,23],[5,24,5,31],[6,0,6,4],[6,5,6,12],[6,19,6,23],[6,24,6,31],[7,0,8,18],[7,19,8,37],[9,0,12,0],[9,1,10,3],[9,4,10,6],[9,7,10,9],[9,10,10,12],[9,13,10,15],[9,16,10,18],[9,19,12,19],[9,20,10,22],[9,23,10,25],[9,26,10,28],[9,29,10,31],[9,32,10,34],[9,35,10,37]]}
["Mississippi State Department of Health-Bureau of Public Water Supply",{"$nulls":18},"Mississippi State Department of Health-Bureau of Public Water Supply"]
["Monthly Fluoride Operating Report (MFOR)--Split Sample Results Page 1",{"$nulls":18},"Monthly Fluoride Operating Report (MFOR)--Split Sample Results Page 2"]
[]
["Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!G3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!G3)","v":"Please enter PWS Name on REQ INFO Tab"},{"$nulls":7},"You are not required to submit split samples on this report.  Split sample entry is voluntary on the MFOR.  MFOR due by 10th of each month--email to water.fluoride@msdh.ms.gov",{"$nulls":5},"Water System Name:",{"$nulls":4},{"$f":"IF('REQ INFO'!Z3=\"\",\"Please enter PWS Name on REQ INFO Tab\",'REQ INFO'!Z3)","v":"Please enter PWS Name on REQ INFO Tab"},{"$nulls":7},"You are not required to submit split samples on this report.  Split sample entry is voluntary on the MFOR.  MFOR due by 10th of each month--email to water.fluoride@msdh.ms.gov"]
["PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!G4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!G4)","v":"Please enter PWS ID on REQ INFO Tab"},{"$nulls":13},"PWS ID:",{"$nulls":4},{"$f":"IF('REQ INFO'!Z4=\"\",\"Please enter PWS ID on REQ INFO Tab\",'REQ INFO'!Z4)","v":"Please enter PWS ID on REQ INFO Tab"}]
["Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!I6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!I6)","v":"Please enter # of TF's on REQ INFO Tab"},{"$nulls":13},"Number of Treatment Facilities:",{"$nulls":4},{"$f":"IF('REQ INFO'!AB6=\"\",\"Please enter # of TF's on REQ INFO Tab\",'REQ INFO'!AB6)","v":"Please enter # of TF's on REQ INFO Tab"}]
["Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!I4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!I4)","v":"Please enter year on REQ INFO Tab"},{"$nulls":13},"Reporting Year:",{"$nulls":4},{"$f":"IF('REQ INFO'!AB4=\"\",\"Please enter year on REQ INFO Tab\",'REQ INFO'!AB4)","v":"Please enter year on REQ INFO Tab"}]
["YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  ",{"$nulls":18},"YOU MUST ENTER THE REQUIRED INFORMATION ON THE \"REQ INFO\" TAB BEFORE YOU CAN ENTER ANY DATA IN THIS SPREADSHEET.  "]
[]
["Date","Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Date","Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results",null,null,"Split Sample Results"]
[]
[null,{"$f":"'REQ INFO'!$C21","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C21","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C21","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C22","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C22","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C22","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C23","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C23","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!$C23","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C24","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C24","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C24","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C25","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C25","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C25","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C26","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C26","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C26","v":{"v":0,"d":"TF000"}},null,{"$f":"'REQ INFO'!C27","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C27","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C27","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C28","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C28","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C28","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C29","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C29","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C29","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C30","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C30","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C30","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C31","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C31","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C31","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C32","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C32","v":{"v":0,"d":"TF000"}},{"$f":"'REQ INFO'!C32","v":{"v":0,"d":"TF000"}}]
[null,"PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.",null,"PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF.","PWS","MSDH","DIFF."]
[{"$nulls":3},{"$f":"ABS(B14-C14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(E14-F14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(H14-I14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(K14-L14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(N14-O14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(Q14-R14)","v":{"v":0,"d":"0.00"}},{"$f":"IF(A14=\"\",\"\",A14)","v":""},null,null,{"$f":"ABS(U14-V14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(X14-Y14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(AA14-AB14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(AD14-AE14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(AG14-AH14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"ABS(AJ14-AK14)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$f":"IF(A15=\"\",\"\",A15)","v":""},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
["Average",{"$f":"IFERROR(AVERAGE(B14:B41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Average",{"$f":"IFERROR(AVERAGE(U14:U41),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Maximum",{"$f":"MAX(B14:B41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Maximum",{"$f":"MAX(U14:U41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Minimum",{"$f":"MIN(B14:B41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Minimum",{"$f":"MIN(U14:U41)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]