recover forgotten excel password

how to recover forgotten excel password.

ITs never been so easy
you just have to write macro to do it

ill share macro here soon

doing some finishing touches

meanwhile you can contact info@19thfloor.com

as soon as i get 50 requires ill release the code

Transpose duplicate data from columns to rows in excel.

I was working for a project when I came across a difficulty there were more than 14000 rows but there were getting repeated with reference to column A. I had to write a macro to move duplicate columns to rows. Now i am sharing it with you people. dont forget to click ad and leave reviews




Sub rearrange()
Dim a, n As Long, i As Long, u()
Dim g, m As Integer, k As Integer
a = Range("A1").CurrentRegion
n = UBound(a, 1)
ReDim u(1 To n, 1 To 5)
For i = 1 To n
    If a(i, 1) <> g Then
        k = k + 1
        g = a(i, 1)
        m = 2
        u(k, 1) = a(i, 1)
        u(k, 2) = a(i, 2)
    Else
        m = m + 1
        If m > 5 Then ReDim Preserve u(1 To n, 1 To m)
        u(k, m) = a(i, 2)
    End If
Next i
u(1, 1) = "Macro output"
Range("E1").Resize(k, UBound(u, 2)) = u
End Sub 

Are online jobs real or scam. (Dedicated for Pakistani people)

Well every one mostly people around Pakistan trying to find a simple answer for “Is working from home possible to make living? “ You will come across tons of websites where you will be asked to pay xx amount and become member and start earning.  You can also search for sites which are free to join and start earning. Even now a days emails are being received which says 300$ / day earning possible.  Another online earning method we can find is writing blog. Captcha typing is another form of online earning.

Ill discusses all the above mentioned points one by one in details.  Ill list reference sites in the last.

Ø  Pay xx member ship fee and start earning

.

If we search for online jobs the most sites appear asks for membership fee to join.  Question here is should 1 pay to join it or not? Almost all of these sites are scam . These site have very low alexa ranking and also very low visitors they just want to trap members and then introduce the option to earn by referring. Yes it the only choice left for the member to try to get the registration fee back. Just be intelligent calculate what is the registration fee + monthly fee and what you earning.  Conclusion is nop you should not pay to these sites.

Ø  Free to join sites

Another type of sites appears in search which allows online earning with no member ship fee. I did a lot of research over these sites and couldn’t find a single site which is real and allows earning for Pakistan.  Most of these sites pay .001$-.005$ for a job or max .25$. If you calculate the time used to do the job you can sure find out that it’s not worth it. Also these types of sites gave few quick bucks after joining then no more option to make money. Even you are not provided with the option to at least take out your first amount. Conclusion is to avoid these sites as working on them is waste of time.

Ø  Captcha typing

Captcha typing jobs are available easy to find but difficult to perform. First they ask xx amount to download software. What that software do? That software connect you to their server and give you quick thing to type. Point here is they are also paying 1$ for 1000 entry minimum entry time is 20 sec. means in 1 mint you can do 3 jobs which is equal to  .015$ if we convert it to 1 hour that will be  180 Jobs.  Means atleast you need 6-8 hours to complete 1000 entries. Ask you self the question is enough for you?

Ø  Email Scam

Regularly you as well as I do receive many emails some says earn online some says I am xyz of xyz company and wan to transfer xxxxxxxxxxxx amount in your account. Or you won xxxxxxxxxxx amount give us the following details to proceed.  You actually think its real? These emails are all scam these are the methods to play with your mind to send them money. Try sending them and they will ask for more. The more you send the more they will ask its an infinite process. An advice stays away from these emails as they will make you psyco. Just ask a question from yourself “What’s so special in you that you are being selected for this email? Did u every visited the country from where it’s coming?

Conclusion

 According to the researches I made during past few months. I would simply say everything similar site I mentioned above for Pakistan is total scam. These survey and pols and other things are mostly for US as most of these sites give coupons and other options which are usually US based. US companies do local surveys to know there customers and improve according to results.

List of few sites doing scam for pakistan

http://www.swagbucks.com/

http://www.neobux.com

http://www.probux.com

http://www.dollarsincome.com

https://www.ipoll.com

http://onlycashsurveys.com

http://www.clixsense.com

http://captcha2cash.com

http://www.jobzcorner.com/

http://www.helponlinejobs.com/

http://www.onlinejobs.net.pk/

http://www.classiconlinejobs.com/

Keyboard shortcuts

Keyboard Shorcuts (Microsoft Windows)

1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)

Dialog Box - Keyboard Shortcuts

1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts

1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)

MMC Console Windows Shortcut keys

1. SHIFT+F10 (Display the Action shortcut menu for the selected item)
2. F1 key (Open the Help topic, if any, for the selected item)
3. F5 key (Update the content of all console windows)
4. CTRL+F10 (Maximize the active console window)
5. CTRL+F5 (Restore the active console window)
6. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
7. F2 key (Rename the selected item)
8. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote Desktop Connection Navigation

1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts

1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )

How to connect more than 5 computers on ptcl wingle?

A very common question going through pakistan. How to connect more than 5 computers on PTCL wingle.

Is it difficult? is it impossible?

well there is nothing impossible. For a regular computer user the easiest way is to download virtual router software which have capability to convert any thing into hotspot. just connect the wingle on usb. disable its wifi and run the application it will simply create a network for unlimited computers :)

how to calculate solar efficiency?

• Determine the surface area of the panel by multiplying the length by the width. For example a SolarWorld 245W Mono panel is 1675 mm long by 1001 mm wide or 1,676.67 square meters. The surface area is aperture area of the solar panel, therefore, this does include the frame. 
• Pull the name plate rating of the panel from the datasheet. For example if it is a 235 W panel, that is the name plate rating at STC (Standard Test Conditions) 
• At STC the watts per meter squred (W/m²) is 1,000 W/m² This is the standard used to determine how many watts of power are produced in a square meter on earth. (Note: Temperature is always a factor in the output of a panel so STC assumes less than 25 degrees C.)
•  Divide the name plate rating by the square meters at 1000 W/m² to get the solar panel efficiency. In our example for the SW 245 mono (245/1.676.67)=14.61% efficiency 
•  Remember to look at the power tolerance as although the name plate rating might be 245W, the power tolerance will tell you how many more or less Watts a the STC the panel produce. In this example the SW 245 Mono have a power tolerance of -3%/+3%.

Could Solar Roadways power our Future?

Innovative solar start-up awarded $100,000 grant by the Department of Transportation for a new road system that could power our future.

There is no question that the earth is blessed with some of the world’s best solar resources and the largest highway network.

Put two and two together and you may just have the solution to energy problem. At least that’s what Solar Roadways inventor Scott Brusaw believes.

Brusaw’s company was just awarded a $100,000 grant by the U.S. Dept. of Transportation (DOT) for one of the most visionary solar projects ever conceived — to convert America’s roadways into the world’s largest solar energy system.

According to Brusaw, the lower 48 states contain about 25,000 square miles of roadways. If these roadways collected solar energy at 15 percent efficiency, they would supply three times the annual energy consumption of the United States.

And perhaps even more exciting, the roadways themselves would become the “super grid” of the future, freely conducting energy to urban centers through a network of relays sheltered in the road’s base layer.

Now, that is not going to be an easy task. The Solar Roadways system could make use of current thin film technology (which has reached efficiencies of 10 percent) but the road layer also includes a grid of LED’s to allow digital striping of the roads, a feature which adds to the whopping price tag — $6900 for a 12′ x 12′ panel (producing 7.6 kWh’s of electricity per day).

In addition, the protective layer would have to be both translucent and durable enough to withstand the wear and tear of the nation’s trucking fleet. We’re talking a lot of high-strength plastic (probably polyvinyl) which would mean huge environmental impacts (and lots of petroleum).

Nevertheless it is one brilliant idea. It will be interesting if the DOT grant will result in a working prototype that may garner further research and funding.

The above interview is part of a new film called YERT (Your Environmental Road Trip) which documents some of the best out-of-the box solutions to our climate crisis.

.htaccess Basic

What is .htaccess ? 

htaccess is a configuration file for use on web servers running the Apache Web Server software.

abbreviation from hypertext access

When a .htaccess file is placed in a directory  of apache then the .htaccess file is detected and executed by the Apache Web Server software on prioirty. 

.htaccess files can be used to alter the configuration of the Apache Web Server software to enable/disable additional functionality and features that the Apache Web Server software has to offer. These facilities include basic redirect functionality, for instance if a 404 file not found error occurs, or for more advanced functions such as content password protection or image hot link prevention.

'.htaccess' is the filename in full, it is not a file extension. For instance, you would not create a file called, 'file.htaccess', it is simply called, '.htaccess'. This file will take effect when placed in any directory which is then in turn loaded via the Apache Web Server software. The file will take effect over the entire directory it is placed in and all files and subdirectories within the specified directory.

This file is inaccessible through web.

You can create a .htaccess file using any good text editor such as TextPad, UltraEdit, Microsoft WordPad and similar (you cannot use Microsoft NotePad). 

.htaccess is mainly used to rewrite urls 

.htaccess example #1




   RewriteEngine on
   RewriteRule    ^$ app/webroot/    [L]
   RewriteRule    (.*) app/webroot/$1 [L]

it redirects every request to app/webroot


this file can be used to allow/deny access from specific ip



.htaccess example #2




order allow deny
deny from all
allow from 192.126.12.199


How to test it?

you can test ur .htaccess file here

http://htaccess.madewithlove.be/

How TV Channels judge the number of viewers for a specific show?

Although different regions can use various methods, the traditional way to monitor television viewing habits has been a rating system. In many countries the Nielsen Company uses in-house devices that track the viewing habits of thousands of people. These numbers represent what average people of a certain age and gender watch, which then indicates the number of viewers who probably watch a particular show. Networks use this information to gauge how popular certain shows are, which determines how much they charge companies to advertise during those programs.

The Nielsen Company tracks what shows viewers watch on television networks through a representative sampling of about 25,000 households that let the company record what programs they watch.

Every time someone in a Nielsen household turns on a television, he or she indicates which person it is and the box tracks how long the person watches a show. Each member of a household has his or her viewing habits recorded individually, through indicating who is watching the television at any given time. If multiple people, including guests, view a program, each one enters information about his or her age and gender into the box so that the viewing habits of each person can be tracked. This viewer-specific data sets the information Nielsen records apart from data gathered by a regular cable television box.

The second way is tracking viewing habits of increased availability of shows on the Internet. Television networks can easily see how many people pay for and download a show through various websites, and many of them offer shows for free with limited advertising. The number of downloads can be recorded by television networks and might influence decisions about keeping certain programs airing. Many advertisers do not consider such viewing as valuable as regular TV watching, however, which has made Internet streams for shows less financially important than traditional broadcasting.