Flipping Data in Microsoft Excel

Flipping Data
Summary: How to reverse the order of rows in a table. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Taken from : http://excel.tips.net/T002653_Flipping_Data.html
---------------------------------------------------------------------------

Many people use Excel as a simple database manager, entering information in different rows of a worksheet. As you are working with your data tables, you may come across a need to reverse the order of the rows in the table. Thus, if you have a table with ten rows, the rows would go from ten to one instead of one to ten.

There is no intrinsic function in Excel that allows you to flip data in this manner. However, you can use the sorting capabilities of Excel to accomplish the same thing by following these general steps:
1.Insert a new column immediately to the left of your data table.
2.In the cells of the new column, enter the numbers 1 through however many rows there are in your table.
3.Select the rows that make up your data table.
4.Choose Sort from the Data menu. Excel displays the Sort dialog box. (Click here to see a related figure.)
5.In the Sort By drop-down list, indicate you want to sort by your newly created column.
6.Click Descending as the type of sort.
7.Click on OK. Excel reorders your data in the reverse order of what it was.

How To: Edit Visual Studio Templates

Taken from : http://www.thecodinghumanist.com/Content/HowToEditVSTemplates.aspx
---------------------------------------------------------------------------

Every time you create a new item in a Visual Studio project you get some default text. For some it is exactly what you want. For others you find yourself consistently making the same additions/deletions. Thankfully, changing the default content in the templates is easy to do.

Steps

1.Locate the templates directory.
2.Change the template you want to change.
3.Rebuild the template cache.

Locate the templates directory.

If you installed Visual Studio in its default location, you will find all the files of interest in the following two places:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplates
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache

Under both of these directories will be separate directories for C#, VB.NET, J#, and Web. Since every language has different templates, they are separated in their own directories. Web templates are separated, and under the web folder there are folders for the individual languages. In these directories (and in the 1033 directory that all of them have) are the templates. All the files under the ItemTemplates folder are zip files. Under the ItemTemplatesCache directory are folders that correspond to the zip files in the ItemTemplates directory. For example, in the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplates\CSharp\1033 directory is a zip file named Class.zip. This is the template for the Class file option in the Visual Studio dialog Visual C# projects. Its twin in the cache is C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\CSharp\1033\Class.zip, which is the files that are contained in the Class.zip file.

Find the template you want and edit it.

So next find the item template that you would like to edit. Let us say you want to edit the normal class template, the one that you get when you pick "Class" in the new item dialog in a class library. That one is found in ItemTemplates\CSharp\1033\Class.zip. Find that file, back it up somewhere (just in case something goes wrong), and extract the contents. You will probably see the following:
using System;
using System.Collections.Generic;
using System.Text;

namespace $rootnamespace$
{
    class $safeitemrootname$
    {
    }
}

I will take you through the changes I make. First, since I take them out more than I keep them in, I remove the second two using statement. Second, I put "public " in front of the class declaration. After that, I am done.

Next, delete the Class.zip in the ItemTemplates\CSharp\1033\ directory. Put the files that are in the folder that was extracted earlier into a new zip file called Class.zip, and place that new zip file where the old zip file was. At that point the edits are done.

If you were to go into Visual Studio after that and create a new class file you would notice that the changes were not yet in effect. To make that happen, you have to rebuild the template cache.


Rebuild the template cache.

It appears that Visual Studio pulls from the ItemTemplatesCache folder for its template items, not from the ItemTemplates folder. To get those changes into the ItemTemplateCache you can manually make the changes or you can have Visual Studio rebuild the template cache. This is done by opening up the Visual Studio 2005 Command Prompt and executing "devenv /installvstemplates". This will recreate the cache.

What you do not want to do is to just make the change in the ItemTemplatesCache folder and not in the ItemTemplates folder. If there is any reason in the future that the cache needs to be regenerated, all of your changes would be lost. When the cache is recreated the ItemTemplatesCache folder is deleted, so any local modifications will be lost.

Also, I would recommend shutting down Visual Studio with the rebuilding is done. Visual Studio does not need to be restarted for the change to be noticed, but it did give me an error once (sorry, do not remember what it said) when I rebuilt with Visual Studio opened, but not after I closed the IDE and ran it again.

Sachin Tendulkar - All Centuries (Video Highlights)

TESTS

1) 14th August 1990 - 119* against England
    Old Trafford Cricket Ground, Manchester (England)

4) 28th November 1992 - 111 against South Africa
    Wanderers Stadium, Johannesburg (South Africa)

5) 12th February 1993 - 165 against England
    M.A. Chidambaram Stadium, Chennai (India)

9) 8th June 1996 - 122 against England
    Edgbaston Cricket Ground, Birmingham (England)

11) 4th January 1997 - 169 against South Africa
    Newlands Cricket Ground, Cape Town (South Africa)

22) 28th December 1999 - 116 against Australia
    Melbourne Cricket Ground, Melbourne (Australia)

38) 4th January 2008 - 169 against Australia
    Sydney Cricket Ground, Sydney (Australia)

49) 11th October 2010 - 214 against Australia
    M. Chinnaswamy Stadium, Bangalore (India)

ODIS

14) 22nd April 1998 - 143 against Australia
    Sharjah Cricket Association Stadium, Sharjah

15) 24th April 1998 - 134 against Australia
    Sharjah Cricket Association Stadium, Sharjah

19) 28th October 1998 - 134 against Australia
    Bangabandhu Stadium, Dhaka (Bangladesh)

21) 13th November 1998 - 124* against Zimbabwe
    Sharjah Cricket Association Stadium, Sharjah

37) 16th March 2004 - 141 against Pakistan
    Rawalpindi Cricket Stadium, Rawalpindi (Pakistan)

Movie Maker Hanging - Solution

Article taken from : http://www.acomputerportal.com/movie_maker_file_fix.html

---------------------------------------------------------------------------------------------------------

Movie Maker sometimes causes problems crashing or hanging when trying to save projects or files.

(This appears to be a Hardware acceleration issue)

This is how I solved this problem:

For Windows Vista

1) Click on the Start Button.
2) Right Click on "Computer", select "Properties".
3) Click on "Advanced System Settings" on the left.
4) Click on the Advanced Tab
5) In the Performance, Visual effects. processor scheduling, memory usage, and virtual memory section:-
6) Click on the Settings Button
7) Click on the Advanced Tab on this window.
8) Within the Process scheduling section click in the Radio Button Background services
9) Then Click the Apply button, bottom right.
10) Then click the OK Button.
11) Then click the next OK Button.
12) Close the windows.

For Windows XP

1) Click on the Start Button.
2) Select My Computer
3) Select View system information
4) Click on the Advanced Tab
5) In the Performance, Visual effects. processor scheduling, memory usage, and virtual memory section:-
6) Click on the Settings Button
7) Click on the Advanced Tab on this window.
8) Within the Process scheduling section click in the Radio Button Background services
9) Then Click the Apply button, bottom right.
10) Then click the OK Button.
11) Then click the next OK Button.
12) Close the windows.

Windows Movie Maker should now handle files and projects all right.

I noticed no degrade in computer speed after using this File Fix.

Good Luck.

Another Tip. Is having patience, and then have even more patience. Video, Picture and sound files may be very large and therefore take some time to import and process etc.