Search results

  1. B

    Finding value from one table closest to value from another table

    I have 2 tables, Table 1 and Table 2 (see attached images)….Although in the example tables (attached), only a few records are shown, they both have about 1000 GRID values: Table 1 contains anywhere from 1-20 records (i.e., rows) per GRID value containing unique “spc_ID” and “name” values, while...
  2. B

    Creating a cumulative running sum from input table, part II

    Hello, I have an input table like the following: ZONE DOY GDD 1 1 2.3 1 2 4 1 3 7 2 1 2.8 2...
  3. B

    Creating a cumulative running sum from input table

    Hello, My problem is this: I have an input table (called rin in the following code) with a field (GDD) that I am hoping to create a running, cumulative sum of (in the output table field called “cum_GDD”) and pass these values into an output table (rout). I realize that VBA doesn’t have any...
  4. B

    Results of functions in my code don’t appear in my output table

    Hi there, I've got a function and within it are embedded 2 other functions (CalcAsin2 and CalcGDD), which are called from within the main function. The code seems to run (i.e., no error messages, and the output table that I create is made and populated with most of the values I want) but...
  5. B

    Get length of text string inside parentheses

    Hello, I've got a bunch of cells which contain long, variable-length strings of data, and nested inside the string is a set of parentheses. e.g.: this+isAll&unnecessary" stuff">Idon'tneed>(but this part I need)<followed by&MORE unnecessarySTUFF So I ONLY want to count the number of...
  6. B

    Create multiple columns from data in one column

    Hello, I've got a rather large table (~650,000 rows) with 4 columns: latitude, longitude, month, and a column of data (where each value is a function of latitude, longitude, & month): lat lon month data 40 120 1 10.23 40 120 2 51.8 40 120 3...
Back
Top Bottom