d44d2e67-406f-4630-b64f-00bdbbbee76e 116 4 8 false false decimal
&[FILENAME] - &[PAGENUM] / &[COUNT]
1. Import Water Level Data (from EXCEL file)
]]> 748

Directory of Excel file to import

MyDirectory DocumentDirectory : C:\Users\Amarasekera\Desktop\Vlookup Delay\

Name of Excel File

MyFile MyDirectory 1.July WL&RT.xlsx concat : AX748

To import: Sheet Name, Start cell and End cell

WL MyFile WL C5 nn importData.XLSX :

WL imported as a Matrix to SMath(Only part shown)

WL 0.85 0.74 0.74 0.75 0.73 0.72 0.72 0.72 0.73 0.72 0.71 0.69 0.7 0.71 0.72 0.7 0.7 0.7 0.67 0.71 0.7 0.7 0.68 0.68 0.69 0.69 0.69 0.67 0.67 0.67 0.68 0.7 0.68 0.67 0.68 0.67 0.67 0.67 0.66 0.68 0.68 0.67 0.67 0.66 0.65 0.86 0.9 0.9 0.89 0.93 0.9 0.9 1.11 1.13 0.89 0.9 0.95 0.98 0.9 0.9 0.87 0.87 0.89 0.64 0.63 0.63 0.65 0.64 0.63 0.62 0.63 0.62 0.85 0.92 0.9 0.9 0.91 0.91 0.9 0.93 0.94 9 9 mat 35712 0.85000002 0.74000001 0.72000003 0.70999998 0.67000002 0.70999998 3 2 mat 48 744 35712 1

Similarly, Import Rating Table (RT)

RT MyFile RT B4 C404 importData.XLSX :

RT as a Matrix to SMath(Only part shown)

RT 0.5 4.3 0.51 4.57 0.52 4.84 0.53 5.11 0.54 5.38 0.55 5.65 0.56 5.92 0.57 6.19 0.58 6.46 0.59 6.73 0.6 7 11 2 mat 0.85 16.75 1 2 mat

wl rt Q j 1 wl rows range Convert water level (wl) to 2 decimals As Rating Table (rt) has 2 decimals wll j el wl j el 2 round : 'findrows()' suggested by Andey Ivashov to speed up execution q j el rt wll j el 1 findrows 2 el : 5 1 line for q 2 1 line : # 74.1 28.27 35712 0.85 0.74 0.74 0.75 0.73 0.72 0.72 0.72 0.73 0.75 0.73 1.04 1.27 1.22 1.14 1.14 1.16 1.22 1.19 1.22 1.27 1.29 1.36 1.26 1.2 1.2 0.99 0.98 0.93 0.92 0.91 0.9 0.91 0.92 0.94 0.91 0.93 0.95 1 1.19 40 1 mat 0.5 4.3 0.51 4.57 0.52 4.84 0.53 5.11 0.54 5.38 0.55 5.65 0.56 5.92 0.57 6.19 0.58 6.46 0.59 6.73 0.6 7 0.61 7.2 0.62 7.4 0.63 7.6 0.64 7.8 0.65 8 0.66 8.2 0.67 8.4 0.68 8.6 0.69 8.8 0.7 9 0.71 9.5 0.72 10 0.73 10.5 0.74 11 0.75 11.5 0.76 12 0.77 12.5 0.78 13 0.79 13.5 0.8 14 0.81 14.55 0.82 15.1 0.83 15.65 0.84 16.2 0.85 16.75 0.86 17.3 0.87 17.85 0.88 18.4 0.89 18.95 40 2 mat 0.85 iVBORw0KGgoAAAANSUhEUgAAAEsAAABRCAYAAACaA1sXAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAH/SURBVHhe7drBKwRhGMfx/fuc3J1cnPwBLhw4cXBwcHBxoBSHPclho0ibpC0JOWzSJqQQG22bXj3TvNvsmp2dH7f3/X7qzexLyrfH9LJT2TxoOr9QrDI2V3N+oRixBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQS9MXKPqsV8to+unWPr59pgvL6YsW0plbqaYLyKrMbjdxvFsNSVV4+Oq5av8sd1xDXv2KlH6NBLAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxBMQSEEtALAGxhphZP0ui2L/NvbxY9asnNz6/7yaXj137q5vu/hZsLPuhfRQL0XpuJ/uDsTrdbzexdNjbu269Jft5gp6s7DtXC1vnyZ5/bcus7d30XttkWbxhgo7VfHhPpsrHsF83f23Lpm3w80WCv8FnJ8feWPXXtmza/LVN4SjBx7J7V/aelLdsumwKRwk+ltk9beVG8sumr4woYpnp1ZPcUDZ1RceFrGhi2ZEgL1atcZ9+xWjRxDKLOxd9oWzaFFHFsodgskeFMjf1rKhiGf8kzXL1Mt0pL7pYdkK3k7pNmSq6WKboT5oiUcb6K2IJiCUgloBYAmIJiCUgloBYAmIJiCUgloBYpTn3Az0cHTNpHDS6AAAAAElFTkSuQmCC 16.75 0.8500000238 0.7400000095 0.7400000095 3 1 mat 0.8500000000 0.7400000000 0.7400000000 3 1 mat