Monday, May 25, 2015

Basic Statistics on Excel

I am always fascinated with Excel and its power. You think of something, you will find it in excel when it comes to analysis. Ofcourse it might be necessary to get some online help as well.

I always use excel to plot  graphs with  trend lines along with line equation and R.Squares. Today, I just wanted to get excel to give me the results in a table with basic statics and not on a graph.

The "Linest" formula does that magic pretty much easily with some twigs.

I found an online help that was very good.
http://burro.cwru.edu/academics/Astr222/UsingLINEST.pdf

Monday, May 11, 2015

Changing your Name on MS Word 2007

I just realized that all my edits on documents and my own documents are worked on by someone called "user." This is the default name used during installation.
I was just able to change the settings and my own name "Chhimi Dorji" shows up.

I googled and found the following most useful= with pictures! It might help you!

How do I change my initials in Word 2007?

Access Word Options by clicking the Office button at top left, then Word Options at the bottom:
1 word options 2007
Your Word Options box will open on the Popular tab and you can now change your name and initials:
1 2007

How do I change my initials in Office 2010?

Click on the File tab and select Options:
2 word options 2010
Click on Options, and you can change your name and initials:
2 2010

How do I change my initials in Word 2013?

First click on the File tab:
3a word options 2013
Select Options at the bottom of the list (use the arrow in a circle at the top left to get back to your document):
3b word options 2013
Click on Options and change your initials and name:
3 2013
Source:
http://libroediting.com/2013/11/13/how-do-i-change-my-initials-in-word-2007-2010-and-2013/

Tuesday, May 5, 2015

Electric Car Comparison Flawed by Kuensel!

There was this piece in Kuensel that really disturbed me saying that Electric Cars in Bhutan are not even Evnrionmentally Friendly, forget being economical. I believe it is totally flawed on wrong asusumptions. Bhutan is one of the first places on earth that have the most advantage of using electric cars.
This is the article.. followed by my say.
http://www.kuenselonline.com/are-e-cars-really-environment-friendly/#.VUmwt_mqqko


Electric Car Comparison Flawed by Kuensel!
On the Kuensel issue of May 6, 2015 there was a report suspecting that the Electric Cars are environmentally worse and economically not comparable to, Maruti Altos. I beg to differ, and provide following justifications. By the way, I am only an electric car user and an Environmental professional and Engineer.

1.       CDM benefits are easier said than done and are not applicable for all of our projects;
Yes, in theory the Dagachhu power generation could be sold on the CDM market and enable Bhutan to receive Carbon credits and subsequent payment. However, the Koyoto Protocol and CDM modalities itself are under major reviews and there is no guarantee that the credits will be paid up without proper buyers and validation. Also, currently Bhutan’s total power consumption is only to the tune of only about 15% of our total generation and the rest are exported to India. This excludes Dagachhu and future hydropower projects that are potential for CDM benefits. Therefore, what we will be using for charging our electric cars will not be from the new and upcoming projects which could be used on the CDM market. The power from our existing Chukhha or Tala or Kurichhu are way more than we can ever use for chagrining our cars. CDM certification of new hydropower projects and use of electricity for electric cars are NOT one or other scenario in Bhutan’s case.
On the other hand, if we are strategic, we can even sell the idea of CDM certification of  our electric cars. By the theoretical CDM criteria it will qualify and easier to monitor and verify.

2.       Comparison of Maruti Alto’s mileage and its impact on CO2 emission to that of Nissan Leaf is comparing Apples and Oranges;
I like the maths in the Maruti Alto Vs Nissan Leaf. But one of the basic assumption is wrong in the calculation. Maruti Alto at Nu 500,000 is an economical car with basic functionality. Nissan Leaf at Nu 1.48M is a compact car with state-of-the-art functions such as 6 Air Bags, Seat-heating systems, Automatic Transmissions, rear camera, bluetbooth compatibility, intelligent key with push start, full leather seats, rear wiper and heater among other things. A fair comparison on that front will be use the capital cost of Mahindra Reva  (costing about 500,000) to that of  Maruti Alto  and  Nissan Leaf to a sedan such as a  Hyundai Accent/Sonata (1.4M+).
Based on these revised comparisons, my maths tells me that if one wants to drive a slightly more expensive car such as a Accent/Sontana or for that matter  the recent hot cakes Ford EcoSport  or Nissan Terrano or Duster, Nissan Leaf will take the trophy for Life cycle cost analysis and emissions.  For the entry level, we will need to compare Maruti Alto with smaller, simpler electric cars such as Reva.
As far as I know, Bhutan is only one of the few countries in the world, wherein all of the fossil fuels (diesel, petrol etc) are imported and almost all of our electricity is hydro-renewable energy. We thus have the most urgent and crucial need to substitute the import of fossil fuels by all means possible. This will not only make the country economically better off but also energy less dependent. I actually believe that the government should further incentivize the purchase and use of electric cars. In other countries, besides the no-tax, further rebates also provided.
In many countries, the use and promotion of electric cars are hindered by the big rich oil companies due to their vested interest in having a perpetual market for themselves. We do not have that in Bhutan. It seems our oil importers and business fraternity is in full support of national security and environmental justice. In Bhutan’s case, we can perhaps look into lower registration costs for electric cars; better loan interests by the banks through a collaboration with BOIC; special savings account for electric car owners, specially taxi owners from their savings; setting up of fast-charging stations at important nodes; and also helping diversify the fleet in the country from other manufacturers to avoid any monopoly and criticism of favoring one or two suppliers alone.