Is there any way to save that chart intact or convert it to a CSV? I've tried copying and pasting it but the format gets all messed up.
If you're on a Windows machine (I'm using Chrome, MS Excel 2007), try the following:
1. Click the "Reply with Quote" at [lctorana] post above.
2. Click the "Go Advanced" button. You should see a preview follow by an edit window.
3. You should highlight the whole table in the edit window.
4. Copy (Ctrl-C).
5. Launch Excel, and Paste (Ctrl-V). You should have the table in Excel.
Or you can save the following to a csv file...
=============================== Exported CSV from Excel ===================================
Type,Voltage,Wattage,Current,Lumen,Average,Base,Fill,Efficiency,Cells
,Life,,Gas,,,,,,
Type,V,W,A,lm,hrs,Base,Gas,lm/W,Cells
GH88,2.2,4.18,1.9,38,,P13.5s,Halogen,9.1,2
HME52,2.8,2.38,0.85,34.6,10,E10,Halogen,14.5,2
HPR52,2.8,2.38,0.85,34.5,10,P13.5s,Halogen,14.5,2
KPR 801,2.4,2.88,1.2,29.5,10,P13.5s,Krypton,10.2,2
HPX 20,2.4,2.232,0.93,26,5,P13.5s,Xenon,11.6,2
KPR 805,2.8,2.66,0.95,25,50,P13.5s,Krypton,9.4,2
GH160,2.5,2,0.8,23,,E10,Halogen,11.5,2
SKPR 803,2.4,2.208,0.92,22.5,10,P13.5s,Krypton,10.2,2
HPX 21,2.4,1.92,0.8,21,15,P13.5s,Xenon,10.9,2
HPR66,2.4,1.992,0.83,21,30,P13.5s,Halogen,10.5,2
KPR K2,2.4,1.992,0.83,20.61,5,P13.5s,Krypton,10.3,2
KPR 131,2.4,2.004,0.835,18.5,15,P13.5s,Krypton,9.2,2
HPR01*,2.8,1.4,0.5,17,10,P13.5s,Halogen,12.1,2
HPR57,2.8,1.624,0.58,17,50,P13.5s,Halogen,10.5,2
PR 31,2.4,1.68,0.7,16.5,15,P13.5s,Vacuum,9.8,2
KPR 102,2.4,1.68,0.7,16.5,15,P13.5s,Krypton,9.8,2
HPR56,2.5,1.25,0.5,14,25,P13.5s,Halogen,11.2,2
KPR 807,2.4,1.716,0.715,14,50,P13.5s,Krypton,8.2,2
HPX 22,2.2,1.342,0.61,12.3,15,P13.5s,Xenon,9.2,2
PR 2,2.4,1.2,0.5,11.4,15,P13.5s,Vacuum,9.5,2
KPR K1,2.4,1.2,0.5,11,6,P13.5s,Krypton,9.2,2
KPR 101,2.4,1.248,0.52,11,10,P13.5s,Krypton,8.8,2
GH159,2.5,1.25,0.5,11,,G2.5,Halogen,8.8,2
GH181,2.5,1.25,0.5,11,,E10,Halogen,8.8,2
GH182,2.5,1.25,0.5,11,,P13.5s,Halogen,8.8,2
PR 527,2.7,1.134,0.42,9.8,20,P13.5s,Vacuum,8.6,2
KPR 104,2.2,1.034,0.47,7,15,P13.5s,Krypton,6.8,2
PR 6,2.5,0.75,0.3,6.1,30,P13.5s,Vacuum,8.1,2
PR 4,2.3,0.621,0.27,5.9,10,P13.5s,Vacuum,9.5,2
PR 900,2.5,0.5,0.2,4.25,15,P13.5s,Vacuum,8.5,2
HPR53,4,3.4,0.85,60,25,P13.5s,Halogen,17.647059,3
HME53,4,3.4,0.85,60,25,E10,Halogen,17.647059,3
HPR81,3.6,3.06,0.85,50,30,P13.5s,Halogen,16.339869,3
HPR61,4,4,1,48,600,P13.5s,Halogen,12,3
GH140,4,4,1,48,,E10,Halogen,12,3
KPR 5984,4,4,1,47,200,P13.5s,Krypton,11.75,3
HPR70,3.6,3.6,1,46,300,P13.5s,Halogen,12.777778,3
LMSA301,3.8,3.192,0.84,45.65,,P13.5s,Xenon,14.301378,3
HPX 30,3.6,2.952,0.82,45.5,10,P13.5s,Xenon,15.413279,3
LWSA301,3.7,2.59,0.7,38.7,,P13.5s,Krypton,14.942085,3
KPR 103,3.6,2.7,0.75,34,20,P13.5s,Krypton,12.592593,3
HPR63,4,3,0.75,33.4,600,P13.5s,Halogen,11.133333,3
HPR54,4,2,0.5,33,15,P13.5s,Halogen,16.5,3
HME54,4,2,0.5,33,15,E10,Halogen,16.5,3
GH143,4,3,0.75,33,,P13.5s,Halogen,11,3
GH53,4,2,0.5,33,,E10,Halogen,16.5,3
PR 3,3.6,1.8,0.5,21.06,15,P13.5s,Vacuum,11.7,3
PR 7,3.8,1.14,0.3,12,30,P13.5s,Vacuum,10.526316,3
KPR 106,3.6,1.08,0.3,11,10,P13.5s,Krypton,10.185185,3
PR 29,3.5,0.7,0.2,7.3,15,P13.5s,Vacuum,10.428571,3
HPR50,5.2,4.42,0.85,85,25,P13.5s,Halogen,19.230769,4
HME50,5.2,4.42,0.85,85,25,E10,Halogen,19.230769,4
GH164,5.2,4.42,0.85,85,,P13.5s,Halogen,19.230769,4
GH173,5.2,4.42,0.85,85,,E10,Halogen,19.230769,4
SKPR 823,4.8,5.28,1.1,84,10,P13.5s,Krypton,15.909091,4
LMSA401,5.3,4.187,0.79,80.5,,P13.5s,Xenon,19.226176,4
KPR 813,4.8,4.464,0.93,80,5,P13.5s,Krypton,17.921147,4
HPX 41,4.8,4.32,0.9,78,10,P13.5s,Xenon,18.055556,4
LWSA401,5.2,3.64,0.7,76,,P13.5s,Krypton,20.879121,4
HPR80,4.8,4.08,0.85,75,30,P13.5s,Halogen,18.382353,4
HPX 40,4.8,3.792,0.79,66.5,15,P13.5s,Xenon,17.53692,4
KPR 113,4.8,3.6,0.75,51,20,P13.5s,Krypton,14.166667,4
HPR55,5.2,2.6,0.5,48,15,P13.5s,Halogen,18.461538,4
HME55,5.2,2.6,0.5,48,15,E10,Halogen,18.461538,4
GH55,5.2,2.6,0.5,46,,E10,Halogen,17.692308,4
PR 32,4.8,3.36,0.7,42,20,P13.5s,Argon,12.5,4
HPR62,4.8,2.4,0.5,37,20,P13.5s,Halogen,15.416667,4
GH70,4.8,2.4,0.5,36,,G4,Halogen,15,4
GH157,4.8,2.4,0.5,36,,P13.5s,Halogen,15,4
KPR 1941,4.75,2.375,0.5,35,10,P13.5s,Krypton,14.736842,4
KPR 802,4.8,2.4,0.5,33,15,P13.5s,Krypton,13.75,4
GH158,4.8,2.4,0.5,33,,G2.5,Halogen,13.75,4
KPR 826,5.2,2.08,0.4,30,30,P13.5s,Krypton,14.423077,4
PR 15,4.8,2.4,0.5,28.8,30,P13.5s,Vacuum,12,4
PR 13,4.75,2.375,0.5,28.5,15,P13.5s,Vacuum,12,4
HPX 42,4.7,1.88,0.4,27.5,15,P13.5s,Xenon,14.62766,4
PR 35,4.6,1.61,0.35,18.5,15,P13.5s,Vacuum,11.490683,4
GH107,5,1.5,0.3,18,,E10,Halogen,12,4
KPR 825,5.2,1.3,0.25,12,20,P13.5s,Krypton,9.2307692,4
HM12,6,20,3.33333,450,100,G4,Halogen,22.5,5
GH102,6,19.8,3.3,450,,G4,Halogen,22.727273,5
HPR72,6,15,2.5,320,100,P13.5s,Halogen,21.333333,5
HM10,6,10,1.66667,220,100,G4,Halogen,22,5
6111,6,10,1.66667,220,150,G4,Halogen,22,5
HPR71,6,10,1.66667,210,100,P13.5s,Halogen,21,5
GH20,6,10,1.66667,201,,G4,Halogen,20.1,5
GH24,6,10,1.66667,201,,P13.5s,Halogen,20.1,5
GH44,6,10,1.66667,201,,E10,Halogen,20.1,5
HM08,6,8,1.33333,160,100,G4,Halogen,20,5
HPR73,6,6,1,110,100,P13.5s,Halogen,18.333333,5
HPR36,5.5,5.5,1,100,40,P13.5s,Halogen,18.181818,5
GH15,6,6,1,100,,P13.5s,Halogen,16.666667,5
GH17,6,6,1,100,,E10,Halogen,16.666667,5
LMSA501,6.3,4.851,0.77,98,,P13.5s,Xenon,20.20202,5
HPR51,6.5,4.55,0.7,90,25,P13.5s,Halogen,19.78022,5
HPR78*,6,5,0.83333,90,100,P13.5s,Halogen,18,5
GH95,6,5,0.83333,80,,G4,Halogen,16,5
KPR 112,6,4.5,0.75,75,20,P13.5s,Krypton,16.666667,5
LWSA501,6.3,4.41,0.7,65,,P13.5s,Krypton,14.739229,5
HPR58,6,3,0.5,55,20,P13.5s,Halogen,18.333333,5
HPR59,6,4,0.66667,54,300,P13.5s,Halogen,13.5,5
HPX 51,6,3.3,0.55,52,20,P13.5s,Xenon,15.757576,5
HPX 50,6,2.82,0.47,49,5,P13.5s,Xenon,17.375887,5
HPR64,6,3,0.5,46,100,P13.5s,Halogen,15.333333,5
HMB13,6,3,0.5,46,100,BA9s,Halogen,15.333333,5
GH103,6,3,0.5,46,,P13.5s,Halogen,15.333333,5
GH106,6,3,0.5,46,,E10,Halogen,15.333333,5
PR 12,6,3,0.5,38.1,15,P13.5s,Argon,12.7,5
HME60,6,2.4,0.4,36,100,E10,Halogen,15,5
GH90,6,2.4,0.4,35,,P13.5s,Halogen,14.583333,5
GH93,6,2.4,0.4,35,,E10,Halogen,14.583333,5
LMSA601,7.6,5.852,0.77,129,,P13.5s,Xenon,22.043746,6
HPX 60,7.2,6.12,0.85,115,15,P13.5s,Xenon,18.79085,6
HPR04,7.4,5.18,0.7,114,25,P13.5s,Halogen,22.007722,6
KPR 118,7.2,5.4,0.75,100,15,P13.5s,Krypton,18.518519,6
LWSA601,7.5,5.25,0.7,86,,P13.5s,Krypton,16.380952,6
KPR 6C,7.2,4.752,0.66,71,36,P13.5s,Krypton,14.941077,6
PR 18,7.2,3.96,0.55,61.4,3,P13.5s,Argon,15.505051,6
PR 518,7.2,3.888,0.54,55,15,P13.5s,Argon,14.146091,6
PR 20,8.63,4.315,0.5,62.8,15,P13.5s,Argon,14.553882,7
HMB21,12,20,1.66667,600,100,BA9s,Halogen,30,10
=============================== Exported CSV from Excel ===================================
