Need Help with Report Generation Toolkit (Excel)

[mark.eckhoff]

I don't know if I'm just blanking out here while programming or what but I'll explain my issue.

I'm trying to take multiple text data files (.csv) within a folder location and taking specific data information from those to then put into a spreadsheet (i.e. Excel). 

My problem is the task of indexing the elements using a smart sorting process. I have a sample number (row header) and a target value (column header) and I want the data that matches those values to be placed in the intersect of headers. 

I also would like to have these headers to programmatically add into the spreadsheet table (ie look and insert the header into the table).

Can anyone help me figure this through? It is greatly appreciated anyone willing to give me some pointers.

[mark.eckhoff]

Basically i need the data to move into something that looks similar to this.

[nyc_(is_out_of_here)]

---

@mark.eckhoff wrote:

My problem is the task of indexing the elements using a smart sorting process.

---

Not sure what this means.

---

@mark.eckhoff wrote:

. I have a sample number (row header) and a target value (column header) and I want the data that matches those values to be placed in the intersect of headers. 

I also would like to have these headers to programmatically add into the spreadsheet table (ie look and insert the header into the table).

---

Can you post what these data files look like? I still don't understand what you are wanting.

[mark.eckhoff]

The .csv file attached is a sample file that I would be using to do my data analysis. 

In regards to not understanding my previous statement - I have rows in reference to a specific test object (ie sample) and each of these samples is put through a series of tests (flow rates) which would be my column markers. I would like a specific measured value to be put in place within the line under the corresponding header. 

Each file contains 3 elements needed specificly for the table (the sample (row x), the target flow rate (column y), and the actual flow rate (x,y)) Does this help explain a little better nyc?

The kicker is that I would like the rows and columns to be populated automatically from the files. Then I can have something like this

Sample Number	Rotator Cavity	Connector Cavity	Head Height (cm)		350	300	250	200	150	100	60	40	30	20	15	10	7.5	5	2
31	5	5	59.0		340	292	233	183	139	101	61.6	50.5	39.8	27.4	18.9	12.8	8.569	5.16	2.78
32	5	5	55.0		325	276	223	179	135	95	61.4	46.9	37	26	17.8	12	6.596	5.99	2.36
33	5	5	55.0		329	275	222	171	128	95	60.2	47.9	36.3	25.9	18	12.6	8.499	4.57	2.79
34	5	5	55.0		325	273	224	172	127	100	61.3	47	37.5	22.8	18.4	12.6	8.247	4.65	2.36
35	5	5	53.0		318	267	219	164	129	91	59.7	45	34.4	23.7	16.9	11.7	7.196	4.56	2.18
36	5	5	53.0		321	271	218	167	130	91	59.7	45.8	35.6	25	16.9	11.9	7.72	4.49	1.72
37	5	5	53.0		322	268	208	167	128	94	59.7	46.6	35.3	24.6	17	11.9	7.545	4.65	1.61
38	5	5	53.0		255	224	193	156	122	91	59.9	46.8	35.6	25.8	17.7	11.6	7.898	3.56	1.68
39	5	5	55.0		303	259	213	172	130	95	61.1	45.6	37.1	24.9	17.7	11.4	8.029	4.63	2.36
40	5	5	54.0		325	271	219	167	129	93	60.5	44.5	35.6	25.2	17	11.9	7.943	4.65	2.2

[nyc_(is_out_of_here)]

You are showing the end result that you want.

I don't see the files that are being used to build the final file.

[mark.eckhoff]

the .csv file attached below was the file type I'm getting my data from.

[nyc_(is_out_of_here)]

---

@mark.eckhoff wrote:

the .csv file attached below was the file type I'm getting my data from.

---

Okay.

But I am not seeing which data from that August 27 file ends up where in the result file.

The Sample ID from the August 27 is #1.

[mark.eckhoff]

The files don't have much to do with the problem I'm having. I have the data elements I want - Sample ID, Expected, and the last value of the 2nd Half Average Column. I just need a way to organize it to the format I need to display it in. 

Big picture - take folder of all the .csv files -> For loop of N files -> take out needed data from each file  -> organize in table. 

[nyc_(is_out_of_here)]

---

@mark.eckhoff wrote:

The files don't have much to do with the problem I'm having. I have the data elements I want - Sample ID, Expected, and the last value of the 2nd Half Average Column. I just need a way to organize it to the format I need to display it in. 

Big picture - take folder of all the .csv files -> For loop of N files -> take out needed data from each file  -> organize in table. 

---

Huh?

I give up.

[mark.eckhoff]

My .csv file has 3 pieces that correspond to 1 cell on the spreadsheet. (The Sample = Row, The Flow Rate = Column, The last average value = VAL at (row,col))

Does this make any sense to anyone?