Current Cost Support Forum

good spreadsheets to manioulate CSV data
Page 1 of 1

Author:  ajc [ Wed Aug 15, 2012 7:39 am ]
Post subject:  good spreadsheets to manioulate CSV data

Has anyone made some good excel spreadsheets to paste the csv data into?
Not really a whiz with excel but things I'm thinking about are being able to separate into peak, shoulder and offpeak, and plug in the 3 different cents/kWh tariffs
and also any quick pie charts etc that show total daily use overlayed with percentage breakdowns over peak, shoulder, offpeak.(or also even office hours/out of hours)

I know CC site and other websites that do this to an extent but would also be good to have a spreadsheet that you can paste multiple days/weeks data into and it references the different tabs to graph daily/weekly/monthly usage and show peak and baseline

Author:  clarisha [ Wed Oct 03, 2012 12:16 pm ]
Post subject:  Re: good spreadsheets to manioulate CSV data

How do i make my excel spreadsheet formulate a letter anytime that i put a number 60 and higher into a cell? I have an excel spreadsheet for our apartment community and anytime that I input onto the spreadsheet that someone is 60 or older I must put a capital 'Y' into a cell on the same spreadsheet three columns over that will indicate that that resident is a senior. Is there a formula or something that I need to use? Or can it even be done?

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group