alright so my brother made this program for getting money totals at a business, its giving me error #62 "Input past end of file" i'll paste the code, and you may need to see the file its writing to also
[vba]
Sub SumMonth()
Dim Starting1() As Double
Dim Starting2() As Double
Dim Bank() As Double
Dim Side1Bank() As Double
Dim Side2Bank() As Double
Dim diff() As Double
Dim dates() As Date
Dim ccard() As Double
Dim cash() As Double
Dim totalSide1 As Double
Dim totalSide2 As Double
Dim totalBank As Double
Dim totaldiff As Double
Dim totalccard As Double
Dim totalcash As Double
Dim months As Date
totalSide1 = 0
totalSide2 = 0
totalBank = 0
totaldiff = 0
totalccard = 0
totalcash = 0
months = InputBox("enter the month, the 1st of the month, and then the year (ex. 07/01/2005)")
Open "C:\Documents and Settings\All Users\Documents\tills\Till_Data.txt" For Input As #1
Dim counter As Integer
counter = 0
Dim temp, temp1, temp2, temp3, temp4, temp5, temp7, temp8 As Double
Dim temp6 As String
Do While Not EOF(1)
counter = counter + 1
Input #1, temp, temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8
Loop
Close #1
ReDim Starting1(counter + 1) As Double
ReDim Starting2(counter + 1) As Double
ReDim Bank(counter + 1) As Double
ReDim Side1Bank(counter + 1) As Double
ReDim Side2Bank(counter + 1) As Double
ReDim diff(counter + 1) As Double
ReDim dates(counter + 1) As Date
ReDim ccard(counter + 1) As Double
ReDim cash(counter + 1) As Double
Dim i As Integer
Range("A1").Select
For i = 1 To counter + 5
ActiveCell = ""
ActiveCell.Offset(0, 1) = ""
ActiveCell.Offset(0, 2) = ""
ActiveCell.Offset(0, 3) = ""
ActiveCell.Offset(0, 4) = ""
ActiveCell.Offset(0, 5) = ""
ActiveCell.Offset(0, 6) = ""
ActiveCell.Offset(1, 0).Select
Next i
Open "C:\Documents and Settings\All Users\Documents\tills\Till_Data.txt" For Input As #1
For i = 1 To counter
Input #1, Starting1(i), Starting2(i), Bank(i), Side1Bank(i), Side2Bank(i), diff(i), dates(i), ccard(i), cash(i)
Next i
Close #1
Range("A1").Select
ActiveCell = "Date"
ActiveCell.Offset(0, 1).Select
ActiveCell = "Bank Side 1"
ActiveCell.Offset(0, 1).Select
ActiveCell = "Bank Side 2"
ActiveCell.Offset(0, 1).Select
ActiveCell = "Bank Total"
ActiveCell.Offset(0, 1).Select
ActiveCell = "difference"
ActiveCell.Offset(0, 1).Select
ActiveCell = "Credit Card"
ActiveCell.Offset(0, 1).Select
ActiveCell = "Cash Depositted"
ActiveCell.Offset(1, -6).Select
For i = 1 To counter
If (Month(dates(i)) = Month(months)) Then
If (Year(dates(i)) = Year(months)) Then
ActiveCell = dates(i)
ActiveCell.Offset(0, 1) = Side1Bank(i)
totalSide1 = totalSide1 + Side1Bank(i)
ActiveCell.Offset(0, 2) = Side2Bank(i)
totalSide2 = totalSide2 + Side2Bank(i)
ActiveCell.Offset(0, 3) = Bank(i)
totalBank = totalBank + Bank(i)
ActiveCell.Offset(0, 4) = diff(i)
totaldiff = totaldiff + diff(i)
ActiveCell.Offset(0, 5) = ccard(i)
totalccard = totalccard + ccard(i)
ActiveCell.Offset(0, 6) = cash(i)
totalcash = totalcash + cash(i)
ActiveCell.Offset(1, 0).Select
End If
End If
Next i
ActiveCell.Offset(1, 0).Select
ActiveCell.Offset(0, 1) = totalSide1
ActiveCell.Offset(0, 2) = totalSide2
ActiveCell.Offset(0, 3) = totalBank
ActiveCell.Offset(0, 4) = totaldiff
ActiveCell.Offset(0, 5) = totalccard
ActiveCell.Offset(0, 6) = totalcash
End Sub
[/vba] the highlighted area is what the debugger brings up as the problem, saying that temp= empty and temp1=empty...... even though both clearly have numbers in them on the excel sheet and the data sheetHELP!
here is the data file (obviously not in VBA, its in a .txt file so i can't attach it):
[vba] 421.56,70.54,1678.89,875.81,803.08,.48,#2005-07-01#,0,0
309.5,68.32,2230,1363.49,866.51,-12.57,#2005-07-02#,0,0
206.85,64.55,2475.39,1330.84,1144.55,-17.61,#2005-07-03#,0,0
246.02,67.91,2439.9,1211.28,1228.62,-1.87,#2005-07-04#,0,0
179.47,80.22,1594.82,939.13,655.69,7.47,#2005-07-05#,0,0
270.9,63.69,1361.18,810.8,550.38,-3.97,#2005-07-06#,0,0
335.93,71.23,1324.32,807.73,516.59,17.86,#2005-07-07#,0,0
374.65,67.15,1741.09,1015.4,725.69,-5.92,#2005-07-08#,0,0
295.81,70.12,1728.9,1025.02,703.88,2.47,#2005-07-09#,0,0
181.88,70.34,2612.66,1423.45,1189.21,-9.44,#2005-07-10#,0,0
286.49,66.41,1201.15,669.15,532,.57,#2005-07-11#,0,0
226.62,68.55,1623.93,1105.27,518.66,-2.44,#2005-07-12#,0,0
299.39,69.9,1519.33,905.64,613.69,-5.67,#2005-07-13#,0,0
229.2,66.3,1909.6,1183.28,726.32,7.14,#2005-07-14#,0,0
296.58,70.33,1910.18,1100.89,809.29,1.68,#2005-07-15#,0,0
228.75,53.3,2063.84,1228.51,835.33,-.31,#2005-07-16#,0,0
263.97,62.81,2205.99,1265.22,940.77,-26.11,#2005-07-17#,0,0
205.98,78.45,1282.15,884.66,397.49,3.4,#2005-07-18#,0,0
287.6,71.89,1682.52,1140.11,542.41,-.25,#2005-07-19#,0,0
224.42,67.3,1447.54,895.31,552.23,-.59,#2005-07-20#,0,0
302.88,76.96,1385.86,792.73,593.13,-1.13,#2005-07-21#,0,0
226.2,68.41,1922.49,1007.65,914.84,-2.32,#2005-07-22#,0,0
273.41,84.64,1597.71,894.87,702.84,5.18,#2005-07-23#,0,0
312.11,63.17,2264.38,1361.71,902.67,-4.27,#2005-07-24#,0,0
271.47,69.26,932.11,620.04,312.07,.27,#2005-07-25#,0,0
237.33,66.78,1074.79,662.32,412.47,-1.56,#2005-07-26#,0,0
313.31,62.99,1426.93,787.39,639.54,-10.8,#2005-07-28#,0,0
265.33,58.06,1382.94,854.2,528.74,-.6,#2005-07-28#,0,0
335.77,70.11,1566.51,951.19,615.32,.72,#2005-07-29#,0,0
260.76,62.7,1810.21,1087.89,722.32,-.54,#2005-07-30#,0,0
308.06,63.36,2332.71,1306.04,1026.67,.34,#2005-07-31#,0,0
234.63,64.2,1465.3,920.6,544.7,2.9,#2005-08-01#,0,0
324.02,71.97,1210.71,676.38,534.33,1.64,#2005-08-02#,0,0
285.36,62.4,1302.01,791.25,510.76,-3.38,#2005-08-03#,0,0
262.78,54,1235.71,762.69,473.02,29.38,#2005-08-04#,0,0
269.69,49.86,1704.74,1007.94,696.8,-42.18,#2005-08-05#,0,0
197.78,59.14,2107.4,1173.62,933.78,-11.57,#2005-08-06#,0,0
233.65,80.48,1971.66,1079.52,892.14,-2.14,#2005-08-07#,0,0
347,73.15,1245.72,781.88,463.84,-5.77,#2005-08-08#,0,0
306.56,69.45,1055.38,714.79,340.59,.07,#2005-08-09#,0,0
269.74,72.7,1196.08,797.32,398.76,5.45,#2005-08-10#,0,0
378.25,65.11,956.35,503.73,452.62,-10.42,#2005-08-11#,0,0
344.31,84.91,1522.38,917.65,604.73,1.65,#2005-08-12#,0,0
278.73,67.56,1297.53,830.58,466.95,-6.15,#2005-08-13#,0,0
190.55,75.79,2231.96,1235.95,996.01,9.1,#2005-08-14#,0,0
314.59,73.64,900.36,555.22,345.14,4.95,#2005-08-15#,0,0
274.7,63.73,1337.06,851.12,485.94,-1.7,#2005-08-16#,0,0
370.63,64.99,1029.23,645.6,383.63,4.21,#2005-08-17#,0,0
342.51,75,944.59,742.56,202.03,-.54,#2005-08-18#,0,0
429.08,52.83,1156.63,681.6,475.03,-.51,#2005-08-19#,0,0
292.98,63.97,1338.11,935.45,402.66,-10.16,#2005-08-20#,0,0
190.78,71.28,1938.59,1185.72,752.87,13.73,#2005-08-21#,0,0
308.71,61.01,794.18,425.17,369.01,-.14,#2005-08-22#,0,0
265.78,75.48,1088.27,713.27,375,-5.13,#2005-08-23#,0,0
374.32,70.32,791.7,491.12,300.58,-.19,#2005-08-24#,0,0
349.35,71.36,1031.96,697.86,334.1,-4.82,#2005-08-25#,0,0
402.82,71.59,1210.02,689.31,520.71,-1.87,#2005-08-26#,0,0
242.18,67.26,1368.2,865.05,503.15,-.71,#2005-08-27#,0,0
180.01,70.79,1885.7,993.78,891.92,-.24,#2005-08-28#,0,0
301.63,61.49,615.1,348.51,266.59,-9.98,#2005-08-29#,0,0
400.7,69.07,984.39,544.49,439.9,.39,#2005-08-30#,0,0
237.75,72.87,909.99,636.28,273.71,-4.92,#2005-08-31#,0,0
352.48,62.44,750.46,488.14,262.32,-7.84,#2005-09-01#,0,0
297.18,78.07,1464.17,950.48,513.69,.41,#2005-09-02#,0,0
269.52,68.25,707.85,536.55,171.3,-.71,#2005-09-03#,0,0
203.5,79.47,1836.57,1129.94,706.63,-6.24,#2005-09-04#,0,0
277.92,69.71,1688.51,848.72,839.79,-4.88,#2005-09-05#,0,0
285.94,64.5,680.69,501.21,179.48,1.99,#2005-09-06#,0,0
266.52,64.1,721.88,564.03,157.85,-5.03,#2005-09-07#,0,0
231.07,69.54,799.68,547.08,252.6,.16,#2005-09-08#,0,0
337.46,67.14,843.33,527.93,315.4,-.74,#2005-09-09#,0,0
192.46,76.15,1359.21,895.95,463.26,-4.83,#2005-09-10#,0,0
272.05,62.61,1240.43,763.73,476.7,-1.18,#2005-09-11#,0,0
235.15,70.09,537.41,405.84,131.57,2.08,#2005-09-12#,0,0
226.17,64.96,656.14,526.52,129.62,-.59,#2005-09-13#,0,0
212.37,68.96,753.38,573.38,180,2.78,#2005-09-14#,0,0
184.58,72.41,797.07,628.91,168.16,3.02,#2005-09-15#,0,0
207.46,58.58,947.49,608.22,339.27,1.81,#2005-09-16#,0,0
175.01,70.7,830.4,614.41,215.99,-1.62,#2005-09-17#,0,0
236.76,67.32,1334.95,708.35,626.6,-2.68,#2005-09-18#,0,0
231.85,57,603.38,488.91,114.47,1.1,#2005-09-19#,0,0
189.07,62.87,834.33,650.42,183.91,1.4,#2005-09-20#,0,0
160.69,68.71,722.07,581.63,140.44,2.45,#2005-09-21#,0,0
286.21,63.65,468.28,312.46,155.82,-.8,#2005-09-22#,0,0
248.59,71.05,746.5,581.41,165.09,.93,#2005-09-23#,0,0
211.24,61.91,921.73,771.55,150.18,-.04,#2005-09-24#,0,0
166.81,62.92,834.34,629.87,204.47,-1.64,#2005-09-25#,0,0
156.58,60.76,524.66,438.63,86.03,-.24,#2005-09-26#,0,0
270.98,59.96,484.55,335.16,149.39,.29,#2005-09-27#,0,0
249.58,52.94,517.76,453.65,64.11,-2.96,#2005-09-28#,0,0
235.36,33.29,766.15,635.53,130.62,-1.45,#2005-09-29#,0,0
214.06,61.09,1010.66,731.56,279.1,-.36,#2005-09-30#,0,0
160.95,63.48,1086.61,801.61,285,-.21,#2005-10-01#,0,0
241.89,64.7,1205.82,765.98,439.84,-.52,#2005-10-02#,0,0
219.04,61.84,839.07,738.69,100.38,-.87,#2005-10-03#,0,0
197.3,61.84,469.5,469.5,0,.41,#2005-10-04#,0,0
188.68,61.84,422.41,422.41,0,-.28,#2005-10-05#,0,0
173.66,61.84,480.39,480.39,0,.93,#2005-10-06#,0,0
293.28,48.15,436.68,391.91,44.77,-10.72,#2005-10-07#,0,0
260.06,44.95,964.59,884.37,80.22,-2.44,#2005-10-08#,0,0
216.4,75.25,1045.17,837.15,208.02,11.71,#2005-10-09#,0,0
222.45,49.09,815.82,702.56,113.26,.15,#2005-10-10#,0,0
210.57,67.07,788.25,710.44,77.81,-.14,#2005-10-11#,0,0
206.26,49.12,723.08,623.08,100,-.34,#2005-10-12#,0,0
179.29,44.72,975.95,935.95,40,0,#2005-10-13#,0,0
166.73,62.46,1151.14,1027.78,123.36,.75,#2005-10-14#,0,0
130.85,45.26,1307.26,997.98,309.28,-.07,#2005-10-15#,0,0
43.87,28.81,1682.64,1215.71,466.93,3.65,#2005-10-16#,0,0
152.64,28.81,536.06,536.06,0,.68,#2006-02-25#,0,0
244.47,28.81,704.25,704.25,0,-1.42,#2006-02-26#,0,0
216.62,43.97,643.2,548.2,95,1.57,#2006-02-27#,0,0
196.45,43.97,683.54,683.54,0,4.94,#2006-02-28#,0,0
164.32,60.13,529.96,462.74,67.22,-.62,#2006-03-01#,0,0
268.54,62.62,437.72,382.13,55.59,-8.49,#2006-03-02#,0,0
234.3,64.2,769.59,705.26,64.33,.05,#2006-03-03#,0,0
222.99,48.22,791.87,596.54,195.33,5.6,#2006-03-04#,0,0
168.47,65.43,1019.87,895.44,124.43,6.1,#2006-03-05#,0,0
150.02,45.15,604.76,471.5,133.26,.26,#2006-03-06#,0,0
239.55,59.72,347.68,297.68,50,-.49,#2006-03-07#,0,0
208.86,65.14,730.28,617.36,112.92,.87,#2006-03-08#,0,0
163.61,66.31,738.24,568.24,170,.8,#2006-03-09#,0,0
270.51,66.11,857.25,681.25,176,2.29,#2006-03-10#,0,0
217.76,69.51,959.85,764.92,194.93,.22,#2006-03-11#,0,0
187.33,59.46,880.91,688.2,192.71,2.12,#2006-03-12#,0,0
179.74,59.46,290.02,290.02,0,1.53,#2006-03-13#,0,0
154.9,53.96,517.27,397.39,119.88,.52,#2006-03-14#,0,0
272.28,43.31,477.76,427.76,50,.04,#2006-03-15#,0,0
278.99,51.03,447.75,347.8,99.95,.97,#2006-03-16#,0,0
229.73,70.27,712.97,596.31,116.66,-.29,#2006-03-17#,0,0
199.06,74.35,890.67,722.95,167.72,-12.12,#2006-03-18#,0,0
163.47,65.21,1153.45,844,309.45,-.93,#2006-03-19#,0,0
138.59,63.55,630.92,585.92,45,-.34,#2006-03-20#,0,0
243.18,60.96,543.77,393.69,150.08,5.66,#2006-03-21#,0,0
224.46,59.12,621.26,544.05,77.21,-1.9,#2006-03-22#,0,0
219.46,44.17,478.97,428.97,50,4.65,#2006-03-23#,0,0
210.9,55.52,751.17,587.83,163.34,-3.07,#2006-03-24#,0,0
168.4,53.87,902.35,686.88,215.47,-3.79,#2006-03-25#,0,0
131.95,55.67,1168.45,826.3,342.15,.31,#2006-03-26#,0,0
98.92,64.1,516,461,55,-.2,#2006-03-27#,0,0
218.65,63.93,538.56,384.95,153.61,.08,#2006-03-28#,0,0
193.71,61.53,819.42,699.82,119.6,-.4,#2006-03-29#,0,0
316.26,52.4,604.69,492.61,112.08,4.06,#2006-03-30#,0,0
302.85,61.43,634.04,568.63,65.41,-.23,#2006-03-31#,0,0
267.4,55.28,930.05,792.53,137.52,-2.68,#2006-04-01#,0,0
206.12,64.18,1147.35,911.46,235.89,-8.26,#2006-04-02#,0,0
142.21,45.07,728.26,604.08,124.18,1.29,#2006-04-03#,0,0
260.54,67.25,853.98,618.08,235.9,-.48,#2006-04-04#,0,0
223.15,70.22,1087.1,747.38,339.72,3.2,#2006-04-05#,0,0
199.9,53.97,764.71,605.88,158.83,-5.41,#2006-04-06#,0,0
287.95,64.49,861.91,577.35,284.56,-6.53,#2006-04-07#,0,0
216.58,63.88,1584.22,1213.93,370.29,-6.99,#2006-04-08#,0,0
197.87,67.58,1528.38,980.35,548.03,-17.46,#2006-04-09#,0,0
256.45,68.9,1236.95,746.43,490.52,24.8,#2006-04-10#,0,0
242.77,56.27,702.95,490.83,212.12,3.21,#2006-04-11#,0,0
184.65,70.51,1315.66,926.82,388.84,8.73,#2006-04-12#,0,0
254.71,69.77,1189.94,807.06,382.88,-2.36,#2006-04-13#,0,0
259.46,58.52,1600.91,934.7,666.21,-26.39,#2006-04-14#,0,0
165.36,37.36,1958.85,1237.03,721.82,13.49,#2006-04-15#,0,0
81.38,67.39,1638.76,991.54,647.22,-.25,#2006-04-16#,0,0
307.56,57.61,893.73,504.83,388.9,.98,#2006-04-17#,0,0
280.77,57.71,1010.86,818.85,192.01,-.58,#2006-04-18#,0,0
265.36,66.56,637.56,518.99,118.57,-.47,#2006-04-19#,0,0
222.82,61.8,728.22,592.23,135.99,-1.24,#2006-04-20#,0,0
355.09,66.22,762.1,544.28,217.82,-1.07,#2006-04-21#,0,0
275.46,70.51,1614.62,997.79,616.83,-9.95,#2006-04-22#,0,0
188.91,70.55,2088.82,1223.08,865.74,-4.33,#2006-04-23#,0,0
175.86,52.08,434.5,369.5,65,.36,#2006-04-24#,0,0
285.88,64.41,891.62,592.52,299.1,-.69,#2006-04-25#,0,0
233.87,70.36,1122.8,766.05,356.75,-5.19,#2006-04-26#,0,0
303.06,68.63,1313.88,851.17,462.71,-.73,#2006-04-27#,0,0
254.23,67.5,731.51,561.49,170.02,-.77,#2006-04-28#,0,0
228.46,62.78,830.96,595.37,235.59,1.16,#2006-04-29#,0,0
173.29,61.35,1092.61,821.67,270.94,-.65,#2006-04-30#,0,0
283.18,63.47,444,349.77,94.23,-1.38,#2006-05-01#,0,0
233.06,65.29,1088.19,745.12,343.07,-1.22,#2006-05-02#,0,0
195.17,73.61,727.61,541.58,186.03,-1.18,#2006-05-03#,0,0
183.6,73.25,648.6,501.38,147.22,-.5,#2006-05-04#,0,0
315.02,74.02,1014.36,629.95,384.41,-1.44,#2006-05-05#,0,0
215.1,69.68,1702.96,990.8,712.16,5.24,#2006-05-06#,0,0
273.52,69.32,1774.94,912.09,862.85,-15.49,#2006-05-07#,0,0
234.06,60.83,920.2,628.02,292.18,2.47,#2006-05-08#,0,0
198.95,53.16,984.53,724.01,260.52,-5.51,#2006-05-09#,0,0
293.93,68.16,632.11,430.14,201.97,.01,#2006-05-10#,0,0
262.73,62.31,820.17,670.17,150,-3.26,#2006-05-11#,0,0
226.55,70.79,823.5,688.04,135.46,-5.26,#2006-05-12#,0,0
183.45,69.85,1259.53,752.59,506.94,-19.28,#2006-05-13#,0,0
259.78,61.08,1750.06,939.99,810.07,-1.9,#2006-05-14#,0,0
194.62,71.66,1160.26,860.79,299.47,-5.1,#2006-05-15#,0,0
281.69,60.62,1094.83,711.59,383.24,2.67,#2006-05-16#,0,0
245.07,71.57,1156.5,804.63,351.87,-2.16,#2006-05-17#,0,0
323.36,61.44,1092.8,705.7,387.1,-4.32,#2006-05-18#,0,0
258.96,79.31,1704.56,1058.33,646.23,-5.15,#2006-05-19#,0,0
179.6,60.71,1751.22,1022.71,728.51,-14.84,#2006-05-20#,0,0
244.02,61.7,1805.33,1032.49,772.84,-20.98,#2006-05-21#,0,0
184.2,64.43,1183.07,732.38,450.69,-2.68,#2006-05-22#,0,0
272.79,58.21,1063.2,658.03,405.17,-9.92,#2006-05-23#,0,0
218.37,65.84,1057.07,660.77,396.3,-.09,#2006-05-24#,0,0
316.04,69,1313.73,801.14,512.59,1.06,#2006-05-25#,0,0
441.96,67.07,1801.83,1016,785.83,.05,#2006-05-26#,0,0
261.37,66.25,2481.11,1486.95,994.16,3.07,#2006-05-27#,0,0
145.13,67.15,2599.5,1445.2,1154.3,-39.14,#2006-05-28#,0,0
352.61,66.2,2829.92,1484.49,1345.43,3.01,#2006-05-29#,0,0
319.93,62.65,1481.31,873.96,607.35,-15.2,#2006-05-30#,0,0
271.54,70.49,1302.39,800.4,501.99,-1.79,#2006-05-31#,0,0
348.65,63.15,1221.78,680.25,541.53,-11.51,#2006-06-01#,0,0
268.41,64.75,1664.62,913.64,750.98,-19.44,#2006-06-02#,0,0
183.18,67.45,1878.53,1060.25,818.28,-14.73,#2006-06-03#,0,0
234.52,62.85,1974.76,965.35,1009.41,.74,#2006-06-04#,0,0
194.41,63.68,1034.18,664.94,369.24,-10.46,#2006-06-05#,0,0
281.55,69.5,1203.39,701.78,501.61,5.74,#2006-06-06#,0,0
238.63,65.64,1217.29,750.03,467.26,-8.77,#2006-06-07#,0,0
334.92,75.2,1239.12,732.24,506.88,-23.5,#2006-06-08#,0,0
287.96,73.48,929.15,618.09,311.06,-4.48,#2006-06-09#,0,0
259.5,58.73,1092.12,698.07,394.05,-.22,#2006-06-10#,0,0
293.06,56.27,1870.39,956.97,913.42,-1.08,#2006-06-11#,0,0
230.15,68.07,1206.63,792.31,414.32,-3.93,#2006-06-12#,0,0
304.31,66.54,1398.28,742.89,655.39,2.12,#2006-06-13#,0,0
272.15,75.12,1113.83,702.36,411.47,1.56,#2006-06-14#,0,0
350,63.14,1274.59,691.54,583.05,-22.67,#2006-06-15#,0,0
370.02,66.73,1549.91,928.84,621.07,-.11,#2006-06-16#,0,0
346.7,66.95,1323.96,764.15,559.81,-3.96,#2006-06-17#,0,0
231.55,60.22,2756.85,1548.14,1208.71,-4.31,#2006-06-18#,0,0
290.85,79.05,1224.62,706.77,517.85,-28.1,#2006-06-19#,0,0
245.81,70.27,1509.17,881.86,627.31,-8.07,#2006-06-20#,0,0
331.27,58.92,1349.04,735.13,613.91,-.75,#2006-06-21#,0,0
256.62,70.39,1561.29,940.47,620.82,3.36,#2006-06-22#,0,0
351.41,69.3,1380.97,689.76,691.21,-11.23,#2006-06-23#,0,0
280.9,68.65,1381.73,844.51,537.22,-4.54,#2006-06-24#,0,0
192.85,72.18,2329.85,1242.17,1087.68,-1.37,#2006-06-25#,0,0
293.9,65.69,982.2,605.44,376.76,-1.98,#2006-06-26#,0,0
218.15,55.15,1407.98,895.76,512.22,-2.71,#2006-06-27#,0,0
185.74,59.74,1149.96,727.41,422.55,-.33,#2006-06-28#,0,0
245.38,69.23,1321.02,661.86,659.16,0,#2006-06-29#,0,0
391.2,65.76,1912.91,844.36,1068.55,-16.66,#2006-06-30#,0,0
370.52,68.75,1673.38,842.23,831.15,-5.42,#2006-07-01#,0,0
429.57,74.7,2309.02,1147.45,1161.57,-4.71,#2006-07-02#,0,0
292.15,64.8,1979.37,1127.75,851.62,-7.68,#2006-07-03#,0,0
211.72,66.4,2021.69,1025.88,995.81,-1.55,#2006-07-04#,0,0
306.56,65.56,1178.73,726.72,452.01,.23,#2006-07-05#,0,0
223.45,73.58,1590.3,947.27,643.03,-3.35,#2006-07-06#,0,0
351.5,73.48,1449.05,797.93,651.12,-4.16,#2006-07-07#,0,0
265.61,76.94,1754.1,935.54,818.56,8.2,#2006-07-08#,0,0
290.62,63.84,2111.24,1022.94,1088.3,-11.87,#2006-07-09#,0,0
243.17,69.18,1193.01,698.27,494.74,-.96,#2006-07-10#,0,0
311.58,64.71,1316.84,753.25,563.59,-1.32,#2006-07-11#,0,0
237.41,72.76,1725.64,987.02,738.62,.37,#2006-07-12#,0,0
197.65,69.53,1019.48,638.3,381.18,-10.35,#2006-07-13#,0,0
289.28,73.98,1739.16,932.55,806.61,-.01,#2006-07-14#,0,0
215.74,60.27,2092.55,1075.12,1017.43,-13.37,#2006-07-15#,0,0
246.86,67.9,2087.52,1200.73,886.79,.35,#2006-07-16#,0,0
301.23,65.03,906.85,445.3,461.55,-13.09,#2006-07-17#,0,0
255.53,67.51,1134.41,725.9,408.51,14.48,#2006-07-18#,0,0
198.55,65.73,1254.87,791.59,463.28,-1.11,#2006-07-19#,0,0
281.83,64.87,1113.84,628.77,485.07,-2.82,#2006-07-20#,0,0
304.44,60.35,1426.38,822.37,604.01,-.74,#2006-07-21#,0,0
240.21,69.63,1548.1,908.67,639.43,-.13,#2006-07-22#,0,0
277.88,75.84,2180.26,1131.53,1048.73,11.37,#2006-07-23#,0,0
204.75,70.89,1246.82,668.29,578.53,-13.2,#2006-07-24#,0,0
280.74,62.33,1065.17,601.66,463.51,.41,#2006-07-25#,0,0
240.88,66.75,1697.78,976.44,721.34,13.26,#2006-07-26#,0,0
178.17,69.68,1490.91,845.54,645.37,-.91,#2006-07-27#,0,0
333.06,61.1,1691.56,907.29,784.27,-.76,#2006-07-28#,0,0
246.99,58.06,1902.74,1068.96,833.78,.91,#2006-07-29#,0,0
295.46,74.22,2198.44,1132.47,1065.97,5.15,#2006-07-30#,0,0
243.26,78.21,1289.53,751.52,538.01,-4.07,#2006-07-31#,0,0
218.61,62.7,862.65,493.99,368.66,-10.16,#2006-08-01#,0,0
343.78,70.65,995.31,563.04,432.27,-.6,#2006-08-02#,0,0
304.23,69.27,1278.17,773.07,505.1,-6.56,#2006-08-03#,0,0
250.35,76.48,1472.55,818.84,653.71,.19,#2006-08-04#,0,0
195.47,68.75,1745.74,1002,743.74,-1.04,#2006-08-05#,0,0
240.73,68.31,2045.32,1136.23,909.09,2.47,#2006-08-06#,0,0
190.75,66.38,1192,759.9,432.1,.49,#2006-08-07#,0,0
180.42,64.13,1011.71,596.9,414.81,-11.63,#2006-08-08#,0,0
268.9,73.03,887.74,499.2,388.54,.96,#2006-08-09#,0,0
337.8,58.66,1441.12,737.98,703.14,-3.06,#2006-08-10#,0,0
375.54,69.67,1239.59,676.14,563.45,-2.43,#2006-08-11#,0,0
266.73,50.71,1505.67,952.25,553.42,-1.29,#2006-08-12#,0,0
206.7,70.58,1433.11,868.8,564.31,-1.87,#2006-08-13#,0,0
289,75.02,787.1,422.28,364.82,-6.95,#2006-08-14#,0,0
263.96,71.33,1037.85,621.82,416.03,-.11,#2006-08-15#,0,0
237.26,67.01,943.65,573.13,370.52,.32,#2006-08-16#,0,0
205.87,72.32,844.23,603.84,240.39,.44,#2006-08-17#,0,0
297.03,71.52,795.29,451,344.29,-.79,#2006-08-18#,17.39,777.9
229.58,61.25,1326.58,810.42,516.16,1.23,#2006-08-19#,50.81,1275.77
283.83,60.92,1898.68,990.76,907.92,-6.01,#2006-08-20#,52.62,1846.06
233.99,72.5,949.27,577.16,372.11,-.97,#2006-08-21#,48.6,900.67
194.57,63.65,1013.29,628.14,385.15,-5.35,#2006-08-22#,20.76,992.53
288.81,73.84,689.66,395.01,294.65,-2.24,#2006-08-23#,12.62,677.04
270.05,57.96,723.65,376.41,347.24,1.44,#2006-08-24#,15.79,707.86
364.69,65.92,1067.47,606.57,460.9,1.85,#2006-08-25#,27.81,1039.66
299.81,62.45,1348.95,822.52,526.43,7.26,#2006-08-26#,70.88,1278.07
223.24,64.69,1777.99,1031.18,746.81,-12.88,#2006-08-27#,44.09,1733.9
191.75,80.01,618.48,476.87,141.61,-4.9,#2006-08-28#,40.64,577.84
169.7,63.36,953.51,623.96,329.55,-3.87,#2006-08-29#,47.7,905.81
278.47,69.3,660.56,375.85,284.71,-6,#2006-08-30#,9.34,651.22
238.61,49.47,1075.88,642.62,433.26,-.11,#2006-08-31#,6.05,1069.83
331.66,65.61,959.64,528.62,431.02,.24,#2006-09-01#,110.18,849.46
292.9,62.94,837.55,649.36,188.19,.58,#2006-09-02#,11.76,825.79
252.1,66.35,1125.26,676.18,449.08,-.1,#2006-09-03#,38.97,1086.29
184,66.45,1669.83,929.72,740.11,-7.7,#2006-09-04#,0,1669.83
179.91,70.07,712.35,418.22,294.13,-.96,#2006-09-05#,12.29,700.06
255.03,59.7,500.93,310.99,189.94,-7.05,#2006-09-06#,10.3,490.63
231.81,67.72,739.93,457.86,282.07,-7.1,#2006-09-07#,0,739.93
290.08,53.73,510.24,222.57,287.67,.08,#2006-09-08#,29.07,481.17
256.45,71.64,770.61,464.55,306.06,-4.57,#2006-09-09#,29.37,741.24
220.82,71.07,682.18,457.42,224.76,-1.37,#2006-09-10#,37.39,644.79
212.35,64.63,617.18,515.36,101.82,-.27,#2006-09-11#,0,617.18
179.95,70.13,787.12,572.12,215,-.87,#2006-09-12#,18.6,768.52
286.9,61.86,531.25,337.03,194.22,-.24,#2006-09-13#,24.76,506.49
247.93,55.69,867.8,583.8,284,-3.89,#2006-09-14#,12,855.8
215.06,60.22,823.44,651.99,171.45,.86,#2006-09-15#,3.5,819.94
185.74,73.81,779.92,490.86,289.06,.89,#2006-09-16#,67.83,712.09
151.56,71.82,799.25,486.93,312.32,-1.34,#2006-09-17#,20.59,778.66
282.16,64.94,267.76,202.76,65,.35,#2006-09-18#,26.6,241.16
260.9,64.94,330.75,330.75,0,.67,#2006-09-19#,23.7,307.05
251.08,66.38,522.04,438.43,83.61,-2.86,#2006-09-20#,29.98,492.06
232.05,38.07,385.2,305.2,80,-.84,#2006-09-21#,26.58,358.62
210.25,48.42,545.72,460.34,85.38,4.69,#2006-09-22#,10.19,535.53
183.95,70.16,574.27,374.67,199.6,-.88,#2006-09-23#,33.23,541.04
151.55,60.53,1159.05,731.02,428.03,-1.34,#2006-09-24#,38.47,1120.58
267.95,65.98,348.21,293.23,54.98,2.19,#2006-09-25#,17.92,330.29
243.09,70.13,659.23,532.65,126.58,-2.3,#2006-09-26#,9.02,650.21
240.01,64.75,660.09,477.22,182.87,-.21,#2006-09-27#,70.29,589.8
226.39,65.39,510.96,470.96,40,-.67,#2006-09-28#,24.04,486.92
207.7,64,666.18,471.34,194.84,-.45,#2006-09-29#,49.34,616.84
209.51,63.44,1089.12,702.16,386.96,-.76,#2006-09-30#,138.86,950.26
243.97,67.4,1686.72,1045.3,641.42,-3.1,#2006-10-01#,89.48,1597.24
218.56,67.4,746.64,746.64,0,-2.89,#2006-10-02#,11.33,735.31
189.64,67.4,629.32,629.32,0,-2.85,#2006-10-03#,9.77,619.55
189.8,53.27,924.81,614.65,310.16,.08,#2006-10-04#,27.4,897.41
178.06,54.8,835.04,609.55,225.49,-.77,#2006-10-05#,84.6,750.44
281.28,71.76,637.54,577.54,60,.26,#2006-10-06#,71.64,565.9
229.37,55.31,1210.45,900.45,310,.51,#2006-10-07#,42.77,1167.68
184.47,70.46,1143.59,751,392.59,-14.12,#2006-10-08#,39.64,1103.95
175.43,68.76,542.34,522.34,20,-1.99,#2006-10-09#,18,524.34
155.2,59.06,622,558.23,63.77,-1.55,#2006-10-10#,5.52,616.48
193.29,59.06,413.59,413.59,0,-4.75,#2006-10-11#,14.51,399.08
183.04,59.06,432.76,432.76,0,-.85,#2006-10-12#,63.47,369.29
152.2,51.15,535.1,482.35,52.75,.54,#2006-10-13#,40.05,495.05
135.76,76.12,845.3,737.22,108.08,-.67,#2006-10-14#,51.83,793.47
68.93,42.4,1852.57,1171.71,680.86,17.99,#2006-10-15#,141.24,1711.33
87.88,42.4,608.1,608.1,0,3.21,#2007-03-04#,0,608.1
200.71,42.4,292.78,292.78,0,-4.73,#2007-03-05#,0,292.78
181.78,42.4,414.19,414.19,0,-.75,#2007-03-06#,7.43,406.76
162.48,42.4,473.49,473.49,0,.9,#2007-03-07#,21.35,452.14
141.27,42.4,568.18,568.18,0,-3.13,#2007-03-08#,31.06,537.12
239.55,58.89,731.3,581.95,149.35,5.46,#2007-03-09#,28,703.3
208.41,60.1,945.73,631.5,314.23,-2.2,#2007-03-10#,28.23,917.5
172.18,64.84,1149.33,710.23,439.1,-2.87,#2007-03-11#,30.12,1119.21
213.45,61.88,766.32,696.32,70,-3.81,#2007-03-12#,26.63,739.69
195.18,61.77,770.62,586.68,183.94,-.13,#2007-03-13#,26.94,743.68
293.24,66.25,667.41,520.82,146.59,-.53,#2007-03-14#,66.03,601.38
257.75,59.53,705.64,526.67,178.97,.4,#2007-03-15#,55.08,650.56
327.5,53.22,822.64,506.53,316.11,1.55,#2007-03-16#,50.86,771.78
278.21,64.86,994.33,741.09,253.24,.06,#2007-03-17#,68.25,926.08
230.54,61.84,901.51,649.5,252.01,-.21,#2007-03-18#,33.06,868.45
198.77,61.15,612.85,464.98,147.87,.49,#2007-03-19#,22.98,589.87
174.97,62.9,534.99,469.9,65.09,-.86,#2007-03-20#,6.16,528.83
242.48,68.83,540,390.24,149.76,.46,#2007-03-21#,39.08,500.92
260.35,67.76,793.51,623.58,169.93,-.32,#2007-03-22#,36.45,757.06
324.39,64.01,1186.7,671.55,515.15,1.36,#2007-03-23#,59.81,1126.89
224.6,62.42,1361.84,866,495.84,-1.99,#2007-03-24#,43.5,1318.34
274.83,70.85,1677.62,1049.11,628.51,-1.07,#2007-03-25#,110.89,1566.73
204.05,75.01,1320.93,889.86,431.07,5.95,#2007-03-26#,69.99,1250.94
167.14,67.59,1015.25,660.22,355.03,-.31,#2007-03-27#,49.85,965.4
275.21,63.38,844.15,455.38,388.77,-1.08,#2007-03-28#,40.95,803.2
229.7,71.82,918.69,662.24,256.45,-2.53,#2007-03-29#,110.82,807.87
346.97,65.32,728.62,561.58,167.04,13.4,#2007-03-30#,85.37,643.25
320.15,57.68,804.91,629.34,175.57,-7.71,#2007-03-31#,58.03,746.88
260.1,69.64,955.24,700.52,254.72,.2,#2007-04-01#,24.61,930.63
251.09,64.04,669,499.92,169.08,-.15,#2007-04-02#,54.54,614.46
229.6,64.04,350.96,350.96,0,-1.15,#2007-04-03#,9.87,341.09
197.19,72.67,541.49,485.15,56.34,-.67,#2007-04-04#,13.16,528.33
321.29,60.08,524.19,323.82,200.37,-.3,#2007-04-05#,7.44,516.75
300.36,80.06,772.18,569.43,202.75,.33,#2007-04-06#,29.87,742.31
280.31,70.82,931.33,710.39,220.94,-.1,#2007-04-07#,78.85,852.48
190.83,66.1,931.26,717.12,214.14,-.9,#2007-04-08#,38.21,893.05
161.76,63.55,829.39,637.48,191.91,-.17,#2007-04-09#,36.96,792.43
142.27,49.44,574.03,507.12,66.91,-.61,#2007-04-10#,17.31,556.72
261.61,64.55,306.41,188.67,117.74,-.16,#2007-04-11#,3.72,302.69
235.19,73.63,729.41,509.43,219.98,-1.38,#2007-04-12#,41,688.41
324.64,68.62,962.66,638.85,323.81,-6.96,#2007-04-13#,116.01,846.65
273.92,74.64,1489.82,859.74,630.08,-3.44,#2007-04-14#,130.08,1359.74
317.39,62.44,1816.31,913.74,902.57,.16,#2007-04-15#,74.14,1742.17
267.48,68.81,1141.14,760.83,380.31,-3.26,#2007-04-16#,50.62,1090.52
214.28,71.9,1074.37,757.08,317.29,-.55,#2007-04-17#,51.36,1023.01
302.25,55.67,1031.62,677.94,353.68,1.49,#2007-04-18#,88.31,943.31
260.47,54.88,1224.9,871.89,353.01,.42,#2007-04-19#,73.6,1151.3
346.5,66.32,1097.43,709.15,388.28,-1.05,#2007-04-20#,57.33,1040.1
293.86,66.41,1323.77,875.83,447.94,-5.42,#2007-04-21#,119.81,1203.96
236.7,60.1,1173.23,764.6,408.63,-1.02,#2007-04-22#,59.34,1113.89
200.71,67.32,907.03,650.63,256.4,-1.83,#2007-04-23#,26.97,880.06
334.62,63.76,796.15,499.6,296.55,-2.1,#2007-04-24#,40.12,756.03
276.82,61.88,1053.73,753.45,300.28,-9.7,#2007-04-25#,55.8,997.93
211.28,68.34,1482.25,933.75,548.5,.23,#2007-04-26#,82.25,1400
282.5,74.28,1384.16,816.11,568.05,-7.45,#2007-04-27#,76.12,1308.04
167.48,76.68,1928.53,1187.5,741.03,-1.13,#2007-04-28#,80.88,1847.65
233.78,66.63,2091.47,1137.15,954.32,.69,#2007-04-29#,133.29,1958.18
189.56,53.57,975.33,684.25,291.08,8.27,#2007-04-30#,73.82,901.51
282.5,67.63,1020.96,681.5,339.46,-1.84,#2007-05-01#,72.78,948.18
250.1,57.42,1127.2,749.83,377.37,1.34,#2007-05-02#,48.02,1079.18
337.75,56.81,984.9,660.24,324.66,.76,#2007-05-03#,58.23,926.67
290.04,71.8,947.91,647.32,300.59,.43,#2007-05-04#,63.18,884.73
255.79,61.92,1277.11,878.68,398.43,-3.21,#2007-05-05#,48.78,1228.33
199.94,67.26,1612.57,931.84,680.73,.07,#2007-05-06#,74.07,1538.5
288.63,75.14,779.05,592.28,186.77,-5.51,#2007-05-07#,36.08,742.97
270.19,63.86,983.15,733.24,249.91,-.71,#2007-05-08#,68.92,914.23
207.86,71.28,1682.63,1110.79,571.84,-.28,#2007-05-09#,59.41,1623.22
271.32,63.48,1424.6,821.88,602.72,-1.29,#2007-05-10#,90.22,1334.38
387.51,67.68,1705.66,1033.79,671.87,-13.78,#2007-05-11#,135.65,1570.01
304.66,76.51,1878.78,1175.55,703.23,-5.8,#2007-05-12#,170.74,1708.04
185.02,74.53,2928.87,1564.39,1364.48,15.99,#2007-05-13#,104.17,2824.7
176.51,64.07,1008.85,647.05,361.8,-8.38,#2007-05-14#,83.36,925.49
284.75,70.8,826.92,541.32,285.6,13.95,#2007-05-15#,103.14,723.78
239.59,71.58,1254.89,930.87,324.02,.98,#2007-05-16#,335.82,919.07
205.52,69.82,1153.5,725.52,427.98,-.32,#2007-05-17#,60.65,1092.85
377.9,58.91,1280.23,775.4,504.83,3.08,#2007-05-18#,57.53,1222.7
236.77,67.47,2319.36,1403.32,916.04,-1.09,#2007-05-19#,138.82,2180.54
300.86,71.07,1452.14,806.15,645.99,-11.5,#2007-05-20#,104.69,1347.45
268.26,53.35,1085.11,680.48,404.63,.54,#2007-05-21#,139.18,945.93
216.8,58.1,1029.06,734.58,294.48,-5.8,#2007-05-22#,55.18,973.88
293.61,72.8,941.57,611.13,330.44,-9.25,#2007-05-23#,122.75,818.82
273.86,51.7,939.69,672.66,267.03,4.1,#2007-05-24#,72.2,867.49
405.32,62.11,1559.13,775.73,783.4,-4.24,#2007-05-25#,61.33,1497.8
347.54,77.91,1345.17,789.82,555.35,-.75,#2007-05-26#,129.77,1215.4
266.12,71.82,2216.29,1302.01,914.28,-.71,#2007-05-27#,178.42,2037.87
290.28,76.05,2523.11,1355.63,1167.48,-5.99,#2007-05-28#,195.93,2327.18
289.02,53.3,941.22,578.68,362.54,1.15,#2007-05-29#,57.11,884.11
259.17,68.65,1129.88,789.69,340.19,-15.14,#2007-05-30#,147.58,982.3
209.23,55.4,1444.7,972.22,472.48,.67,#2007-05-31#,131.72,1312.98
292.25,63.35,1212.93,813.41,399.52,1.35,#2007-06-01#,132.15,1080.78
223.32,60.23,1618.82,946.1,672.72,-9.17,#2007-06-02#,81.75,1537.07
270.97,61.96,1971.52,1114,857.52,-4.13,#2007-06-03#,81.26,1890.26
238.23,65.89,900.99,668.75,232.24,-4.61,#2007-06-04#,50.43,850.56
200.07,59.33,1159.2,710.72,448.48,-11.25,#2007-06-05#,47.85,1111.35
314.41,62.8,883.38,582.04,301.34,-34.6,#2007-06-06#,90.76,792.62
255.56,60.5,1139.51,800.67,338.84,-16.15,#2007-06-07#,64.82,1074.69
325.47,69.1,1310.44,840.23,470.21,-6.67,#2007-06-08#,140.80,1310.44
260.37,64.15,1652.4,1012.29,640.11,-.4,#2007-06-09#,148.76,1503.64
[/vba]
Reply With Quote
