I am trying to automate the construction of a tridiagonal matrix in Excel. I have attached a picture to illustrate what I am trying to do. All the nonzero elements in the matrix would reference the array shown in the picture, which is constituted by 101 rows and 3 columns of numerical data. Assuming that this can be done in Excel at all, I am hoping that scripting will not be necessary because I am unfamiliar with VBA syntax but if scripting is necessary I would appreciate it if someone could provide a snippet of code to get me started.