AnsweredAssumed Answered

Import an Excel file-each cell in the file relate to a location specific tree

Question asked by SalmanAlsudairy on Jun 29, 2014
Latest reply on Jun 30, 2014 by SalmanAlsudairy

Title

Import an Excel file-each cell in the file relate to a location specific tree

Post

     I would like to import two excel sheets into FM.  The first sheet contain the type of tree while the second contains the year the tree was planted.  The link between the two sheets are the raw and column addresses, thus cell BW50 in sheet one specify the type while cell BW50 in the other specify the year.  I plan to develop a database so that I can streamline the budgeting process both in terms of outputs as well as inputs.  More specifically, the amount the tree produces depends on the variety as well as the age of the tree.  Also the cost of the inputs varies based on those variables.  There are other factors such as the soil composition and moisture which necessitate an ability to track location specific variables.  AT this time, however, my focus is to be able to import two excel sheets.  Appreciate any suggestions on how I can do this systematically.

Outcomes