Excel Macro Snow Algo
Revision as of 10:39, 17 July 2019 by 172.18.0.1 (talk) (Created page with "<pre> Option Explicit Private Sub snowtest() ' column A = Date ' column C = Raw Data ' column D = Dim columnDate As Integer Dim columnSDC As Integer D...")
Option Explicit Private Sub snowtest() ' column A = Date ' column C = Raw Data ' column D = Dim columnDate As Integer Dim columnSDC As Integer Dim columnINFIL As Integer Dim columnADD As Integer Dim columnDEL As Integer Dim currow As Long Dim futureoffset As Long Dim curinfilval As Double Dim nextinfilval As Double Dim curSDCval As Double Dim futureSDCval As Double columnDate = 1 columnDEL = 4 columnADD = 5 columnSDC = 6 columnINFIL = 8 currow = 5436 futureoffset = 18 * 12 ' (12 measurements per hour, offset is +18 hours) Do While Worksheets(1).Cells(currow, columnADD).Value <> "end of season" curinfilval = Worksheets(1).Cells(currow, columnINFIL).Value nextinfilval = Worksheets(1).Cells(currow + 1, columnINFIL).Value curSDCval = Worksheets(1).Cells(currow, columnSDC).Value futureSDCval = Worksheets(1).Cells(currow + futureoffset, columnSDC).Value Loop End Sub