To add or subtract elements you need to use
the insert matrix function. Set column to zero.
Use the first state ID that is part of this cycle
use datalog array to the right to look at the statelog
in order to decide stateID, staelogstartrow, and numberofruns
This portion of the worksheet allows you to look at the run increment alum
There is a bug though and so far even though there are 28 runs, only 27 are
counted and only 26 show up on anything.....
This is the list of row numbers from the state log that correspond to the state that you are collecting data from. Some of this data might be garbage. Set the "statelogstartrow" to the number that corresponds to the actual beginning of the experiment. Note that these numbers increment by a constant number once the program is running in automatic mode.
storing the data in a local variable so we don't have to recalculate this for drawing the graph
We are getting the data from the previous state 4 for flows and head loss measurements and from state 5 for effluent turbidity measurements
maxnumberofruns and runs doesn't work???
This portion allows you to look at the run increment alum part of the data
for datalog
0 is statelog
1 is datalog
2 is headers from statelog
3 is headers from datalog
Critical Settling Times
amount of time (in seconds) around CriticalSettlingTime to average
creates a matrix with the start and stop times of each run, the row numbers
correspond to the run number and the first column is the start row number and the second column is the stop row number. The third column is the average of the values between the start and stop rows based on chosen column from datalog
for this to calculate effluent, column must be effluent column
submatrix(A, ir, jr, ic, jc)
Returns the matrix consisting of rows ir through jr and columns ic through jc of array A.
Z Everything before this point is stuff that we worked on earlier......except I took out the part where we tried to add the function right above this text box. I also changed the function so that you could pick which sheet you wanted to be in. See to the right for finding the influent turbidity. Everything in orange after this is stuff that was already there before I played with it. Everything should have an explanation right beneath it. I hope you can follow it.
The above is the calculation for the influent
These two arrays were what I looked at it try to figure out what was wrong, with the Average Function for data4 (to the right) but I couldn't find it so I didn't use it. I just used an average over the whole time period. This needs to be adjusted, but I wanted to make sure I could graph and get the values I wanted.
The above function's values were found using the two arrays to the left of the function.
I picked 0 seconds here because I want to average over the whole time period
so the column 0 of AverageFunction() should always be 0. The second time period here
for some reason isn't working.....HMMMMM. (For now lets just assume that this works
all the way to the end....)
I picked 48 because when you looke at data4 it says there are 47 rows which means 48
runs. Then I picked column 5 because that is what datalog3 says the influent turbidity
column number is. Then I picked 4 because I want the influent turbidity from the Turbidity
sample state.
(I never did quite get to fixing this...I just used the overall influent turbidity)
This is the array of the start and stop times for data4
which has all the data at state 4 (Turbidity sample)
which has the influent turbidity
Z I created the function (above) returnstartstoparray just to have it. (I don't think i actually use it though) This way now you can pick which sheet you want. This function will not only find the start and stop times for data5 but now also for data4. You just have to change sheet to 4 or 5. This way I can get the start and stop times in data4 as well, without creating a new function. This may not be needed as it looks as though all the start and stop times are the same length but there's no harm in having the function just in case the lenght of time of state 4 (Turbidity sample changes).
infulent is
starting one resonence time before StartTime
This is something we already had I just got tired of scrolling up to see it so I made it closer to where I was working.
last row finds the row number of the last row
This function will find the average of an entire column for any sheet you choose
any column you choose and for all the runs. I'm sure there's a way to do this
in MathCAD but it took me two seconds to do and i'm sure it would have taken
me hours to figure it out.
This is supposedly the average influent turbidity for each run(over the whole time). Sheet 4 is the Turbidity sample state. Column 5 is the influent turbidity, and 48 is the max number of runs. According to this we have a crazy influent turbidity.
This is supposedly the alum dose for each run. Sheet 4 is the Turbidity sample state. Column 5 is the influent turbidity, and 48 is the max number of runs.
The function below, uses the above three arrays. I used variables, and defined them, but its basically the three arrays above graphed.
For the function CarolThreeDPlot() use the lowest maxruns, i'm not sure why the maxruns aren't the same but this could be something to do with the way the data is pulled and I just don't know how to get it to work out. The following are the parameters used in the function.
This is the sheet number where you are looking for the effluent turbidity,
which at this point is 5.
This is the sheet for the Alum dose and influent turbidity,
which should be found on the same sheet which is 4
This is the column that the Alum can be found in
This is the column for influent turbidity
This is the colum for effluent turbidity
These are defined above I just wanted to remember what they were here
x is alum dose, y is influent turbidity, and z is effluent turbidity
these are the three columns that got graphed. I overlapped them so they didn't take up too much space.
x is alum dose, y is influent turbidity, and z is effluent turbidity
..Also, I don't know how to fix the maxruns. Finally, just check everything over....it's late :)
Alumdose v settledturbidity at 65 NTU in
what we want- two d graph that just takes off one slice of influent turbidity so you have settled by alum