Lost in Excel

Started by SolarMusher, February 24, 2013, 07:57:19 AM

Previous topic - Next topic

Westbranch

John, Erik, from memory prior issues had a little pop up window that asked you how the information was delimited (CSV = comma/character separated values) as it also could be a period or ?
you just had to click on whatever the file used and voila.. off it went, at the same time IIRC you could set the column width and a few other things...
cheers

sunny at 10, huge wet flakes now... darn
KID FW1811 560W >C&D 24V 900Ah AGM
CL150 29032 FW V.2126-NW2097-GP2133 175A E-Panel WBjr, 3Px4s 140W > 24V 900Ah AGM,
2 Cisco WRT54GL i/c DD-WRT Rtr, NetGr DS104Hub
Cotek ST1500 Inv  want a 24V  ROSIE Inverter
OmniCharge3024  Eu1/2/3000iGens
West Chilcotin 1680+W to come

SolarMusher

John & Eric,
You must be right, I've Office 2003 and obviously it's not up to date  :P
I had found Word Office expensive and was naively thinking that it would be equivalent to the latest version. Not sure, I will buy the new one, Bill is rich enough!  I still need to pay off my old 2003 version so I could live with it  ;D, at worst I've found a free CSV editor better than Excel: http://www.windows7download.com/win7-ron-s-editor/download-lcqefgxx.html.
Thanks guys!
Erik
Off Grid with 4kw PV | 2x Classic 200/WBjr | 2x Outback VFX3648 Epanel | 3x SPD300 + 1x Schneider HEPD80 | Hub + Mate + PSX-240 | Volthium 400Ah/51.2V LFP battery bank + Trimetric | 1500 watts AC water heater | Kubota 11kw GL diesel generator

TomW

Erik;

You might look and see if Libre Office is available for your Operating System. It is a fairly complete office system.

That is what I use. Free, current and just works.

Just a thought

Tom
Do NOT mistake me for any kind of "expert".

( ͡° ͜ʖ ͡°)


24 Trina 310 watt modules, SMA SunnyBoy 7.7 KW Grid Tie inverter.

I thought that they were angels, but much to my surprise, We climbed aboard their starship and headed for the skies

SolarMusher

QuoteErik;

You might look and see if Libre Office is available for your Operating System. It is a fairly complete office system.

That is what I use. Free, current and just works.

Just a thought

Tom

Yes, but a good thought, Tom. I think I'm going to look at Libre Office closer.
Thanks a lot!
Erik


Off Grid with 4kw PV | 2x Classic 200/WBjr | 2x Outback VFX3648 Epanel | 3x SPD300 + 1x Schneider HEPD80 | Hub + Mate + PSX-240 | Volthium 400Ah/51.2V LFP battery bank + Trimetric | 1500 watts AC water heater | Kubota 11kw GL diesel generator

niel

i'm a bit late chiming into this and didn't read the whole thread so if i'm misreading what's wanted wrongly then please forgive me. i have been using open office and is a free download for my pc using vista. not sure of your os, but take a look.

TomW

Quote from: niel on February 25, 2013, 08:41:07 PM
i'm a bit late chiming into this and didn't read the whole thread so if i'm misreading what's wanted wrongly then please forgive me. i have been using open office and is a free download for my pc using vista. not sure of your os, but take a look.

Niel;

I thought Open Office got rolled into Libre Office or something? I used O-O for years on Debian systems then when I started using Ubuntu it had Libre Office on it?

Either probably fine.

Tom
Do NOT mistake me for any kind of "expert".

( ͡° ͜ʖ ͡°)


24 Trina 310 watt modules, SMA SunnyBoy 7.7 KW Grid Tie inverter.

I thought that they were angels, but much to my surprise, We climbed aboard their starship and headed for the skies

Westbranch

they both are competition for Micro-bloat-ware (MS). I have used both over the years.  Here is a comparison of both, just minor differences.  http://office-suites.venturebeat.com/compare/3-16/OpenOffice-org-vs-LibreOffice
KID FW1811 560W >C&D 24V 900Ah AGM
CL150 29032 FW V.2126-NW2097-GP2133 175A E-Panel WBjr, 3Px4s 140W > 24V 900Ah AGM,
2 Cisco WRT54GL i/c DD-WRT Rtr, NetGr DS104Hub
Cotek ST1500 Inv  want a 24V  ROSIE Inverter
OmniCharge3024  Eu1/2/3000iGens
West Chilcotin 1680+W to come

Westbranch

Erik, is it working for you?
KID FW1811 560W >C&D 24V 900Ah AGM
CL150 29032 FW V.2126-NW2097-GP2133 175A E-Panel WBjr, 3Px4s 140W > 24V 900Ah AGM,
2 Cisco WRT54GL i/c DD-WRT Rtr, NetGr DS104Hub
Cotek ST1500 Inv  want a 24V  ROSIE Inverter
OmniCharge3024  Eu1/2/3000iGens
West Chilcotin 1680+W to come

SolarMusher

#23
Hey Eric,
Yes, no problem it's working fine now. Find these data sheet very interesting, especially when I can watch globally since november how few days I have had where my batteries have reached float stage. Waiting feverishly for a better production in March... and for a higher SG, still have a steady 1.250/55 after 4hrs EQ at 64V. I wonder if one day I could reach 1.275 in winter even with a 4kwhr PV array  ;D
Erik
Off Grid with 4kw PV | 2x Classic 200/WBjr | 2x Outback VFX3648 Epanel | 3x SPD300 + 1x Schneider HEPD80 | Hub + Mate + PSX-240 | Volthium 400Ah/51.2V LFP battery bank + Trimetric | 1500 watts AC water heater | Kubota 11kw GL diesel generator