NikK100

Thank you all for your continued help. I am experimenting with splitting the account codes and summarizing. My next question, having all the data in one table will I be able to do calculations based on the average of column 1 and the corresponding account code of column 5 in the current week?

Sorry for any confusion. The Data is RAW data, it has been sanitized for confidentiality. The word "Description" is just a sanitized version of the descriptive name given to the column or row name. eg Column - Description 1 = "Spend this Qtr" Row description might be "Engine Widgets" I appreciate the help as always.

Thank you both for your help. It is very much appreciated. I am attaching a spreadsheet with sample data as well as the beginnings of a report I’d like to generate. I realize the excel contains a lot of ideas to be implemented, but they are just there to help with understanding the design schema. SAMPLE DATA FOR PROJECT.xlsx

I am a novice. I have a File Maker project I want to develop, but am struggling with the initial schema design/setup. I have weekly cost reporting data in excel format. The weekly excel file is made up of 11 columns and between 500 to 3000 lines of data, the first two columns are 1) unique account code and 2) descriptive name. Four of the columns contain updated key numerical data each week, the other 5 columns can be derived from the data in the 4 key columns. I want to do various row calculations based on the average of the specific key column. I want to compare the average of the specific column/row (updated each week) to a matching columns/row budget number in the current week. I cannot work out if each weeks data should be appended to the previous weeks, with a new/identifying week number or if the weekly data should be kept in separate related tables. Any guidance gratefully appreciated.