Greetings. I'm new to this forum but have already learned a few things about Excel.
Here is the challenge I have. We are a small company and don't have a lot of money to invest into an SPC (statistial process control) software that will collect, organize and give me some basic statistics on data we are collecting.
Some of our data is collected automatically into a *.csv file, but most of it is manual and would have to be entered into a spreadsheet or database.
What I'm looking for is some direction or help in beginning to build a method to collect data from multiple different files into a single spreadsheet. I know a fair amount about Excel but I don't know very much about writing code.
I've done a fair amount of work in Access, but it has been a while.
I don't know enough about Pivot tables to know if that is the direction I should go or do I just work with a single spreadsheet. Or can I link multiple spreadsheets or have a master spreadsheet or dashboard go out and import data from other files.
My ultimate goal would be to eventually have a dashboard where I could see a summary of all the processes I'm collecting data on. Then if there dashboard showed a warning, I could click on a link that would then show me either some detail charts or the raw data.
I would like to incorporate dynamic charts that I could look at the data based on each individual data point or group by daily chart, weekly chart, monthly chart, or quarterly charts.
I'm hoping that someone on this website has either seen something like this or can point me the right direction. I don't need to get this done all at one time, but maybe in logigal bulding block steps learning as I go.
I know this is potentially a long and complicated request, but at this point I'm mainly interested in direction and input on whether this would be possible in Excel without having to learn how to write a lot of complicated code...
Looking forward to your input and comments.
thenson
Here is the challenge I have. We are a small company and don't have a lot of money to invest into an SPC (statistial process control) software that will collect, organize and give me some basic statistics on data we are collecting.
Some of our data is collected automatically into a *.csv file, but most of it is manual and would have to be entered into a spreadsheet or database.
What I'm looking for is some direction or help in beginning to build a method to collect data from multiple different files into a single spreadsheet. I know a fair amount about Excel but I don't know very much about writing code.
I've done a fair amount of work in Access, but it has been a while.
I don't know enough about Pivot tables to know if that is the direction I should go or do I just work with a single spreadsheet. Or can I link multiple spreadsheets or have a master spreadsheet or dashboard go out and import data from other files.
My ultimate goal would be to eventually have a dashboard where I could see a summary of all the processes I'm collecting data on. Then if there dashboard showed a warning, I could click on a link that would then show me either some detail charts or the raw data.
I would like to incorporate dynamic charts that I could look at the data based on each individual data point or group by daily chart, weekly chart, monthly chart, or quarterly charts.
I'm hoping that someone on this website has either seen something like this or can point me the right direction. I don't need to get this done all at one time, but maybe in logigal bulding block steps learning as I go.
I know this is potentially a long and complicated request, but at this point I'm mainly interested in direction and input on whether this would be possible in Excel without having to learn how to write a lot of complicated code...
Looking forward to your input and comments.
thenson
