Extracting data in a table to populate a graphic portrayal of battery cells

[Johnny K]

Hi, looking for a shove in the right direction. I would like to have a graphical representation of a battery (224 individual cells) and what I would like to do is map the readings that will be in a separate table onto the cells so you can see for example "If an area of the battery is hot (localized heating)" or if an area has a issue with specific gravity.

Some times it is useful to look at the data collected in a graphical representation instead of in the table format. This may be relevant if a cell cooling were to have an air blockage, the cooling water supply is not in a 1,2,3,... order and cools in legs. So if a air lock were present a localized area of readings that were visible on a graphic that represented the cooling water supply over top of the battery cells this would be.

The graphic would be nothing fancy just square boxes with the cells number, with a overlay of the cooling supply. To make it simple I would like to put cell temp in the box.

I am not sure that I am clear on what I am wondering about, just thought it might be a fun project.

John

 

[oldbrewer]

75.82	69.48	84.16	97.08	72.98	98.59	148.67	55.40	61.01	71.94	121.75	101.28	149.66	100.93
56.59	111.25	84.00	94.23	115.13	108.20	95.12	76.27	113.33	50.48	143.52	51.96	66.73	95.68
58.42	67.97	53.47	72.95	143.18	82.19	81.75	98.64	133.39	74.79	143.80	62.71	120.51	96.85
51.89	93.94	134.34	116.35	140.38	73.96	100.03	124.28	118.87	131.46	124.83	145.34	98.42	118.86
125.59	60.40	141.20	99.82	111.40	128.83	118.39	100.13	61.04	96.62	67.73	90.13	127.22	149.81
84.75	98.87	81.38	52.76	54.26	84.18	141.85	120.88	135.47	120.90	147.39	109.34	138.06	135.70
113.41	146.47	137.56	133.07	143.67	83.29	148.27	141.59	80.27	95.14	93.05	79.26	85.94	57.74
53.89	122.94	76.55	138.73	121.91	74.88	114.11	58.46	68.82	106.15	56.10	93.04	52.03	59.85
79.96	51.29	93.20	141.07	113.50	142.17	119.37	72.70	120.55	61.85	140.49	91.66	72.84	130.68
91.24	51.34	89.09	78.68	126.46	119.42	86.64	67.18	60.39	125.18	104.12	89.10	102.84	77.30
77.95	77.19	81.47	80.26	66.38	68.72	131.54	121.71	67.04	107.27	145.41	90.21	56.09	105.83
54.74	92.32	67.62	72.00	114.97	81.55	119.21	67.25	89.03	119.46	138.52	72.64	58.78	119.83
108.35	124.48	55.85	90.51	92.25	80.65	86.97	80.73	108.32	120.09	112.84	56.97	116.77	110.83
67.87	97.92	96.83	91.27	60.24	116.93	135.99	73.41	85.80	57.17	77.97	138.44	68.70	72.69
128.50	113.09	130.99	70.39	67.96	53.57	60.45	129.87	81.08	64.53	126.83	132.89	91.56	80.19
147.67	106.00	94.37	57.17	83.71	97.83	66.62	133.31	57.71	113.92	111.04	79.65	133.11	62.50
			this is a 16 x 16 grid of readings
			using conditional formatting you could make readings over 115 red and readings under 75 green etc

<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>