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]

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