Today I had one of thoose lovely "Ah! Never considered that before!". I got a question from a colleague that had a formula that looked like this:
Note that this is no hardcore crazy hackaway thing. Just a common "simple when you think of it". I'm not claiming to be giving away awesome wisdom here. :)
Apart from not beeing very easy understandable it required a lot of handy work to stay up to date since columns where added periodically.
What it was supposed to do was check if all the cells between G3 and AK3 were empty, write "Missing" if they were and "Present" if they weren't. If you have the energy to check you will notice that not all cells between G3 and AK3 was included. Some were lost when new columns were added.
Easy! I thougt, and entered: =IF(G3:AK3="";"Missing";"Present")
Unexpected trouble. As far as I can remember I never tried using a range with the IF function that way before, lucky for me since it doesn't work (neither do named areas).
I figured that I have to calculate a value from these cells so I asked what would be in the cells if present? Unfortunately the answer wasn't digits. If it were numbers a simple: =IF(SUM(G3:AK3)=0;"Missing";"Present") would work.
Still, this should not be too tricky...and it wasn't. As soon as I stoped thinking on how to identify the cell content at least (yes, that took me some beard scratching minutes).
Instead I count them. This is what I came up with:
=COUNTA simply counts the number of cells with values. Since I specify a range Excel will also update the formula to includedcells created within that range.
As with most questions about Excel, the solution was easy, you just have to think about it first :-)
Time to change that Samsung Galaxy a bit? Time for the Galaxo how to. Just remember that unlocking your bootloader will void your warranty. The risks are very slim but they do exist and neither I or anyone else will take any responsibility for any problem that could occur. However you will always loose all your data on the phone! Any external SD card will be left untouched.
That was the disclaimer on to more fun stuff! This guide will flash (install) Galaxo by Drakaz on your phone. We will use Galaxo 1.6.2 which is built on the XEJC6 firmware. It's not as hard as it look, I just wrote a quite extensive guide divided in many steps. My goal is that you should be able to achieve this without any pre-knowledge at all. more straight forward instructions are always published with the ROM. Note that this guide focus on how to do this on a Windows computer, it’s possible on Mac and Linux but since I don’t have any experience on that I’ll let you look for that answer somewhere else.
Phase 0: Preparations
0.1 First of all you need to follow this guide to install the correct firmware and get all the files needed.
0.2 Back-up anything you want to save from your phone and make sure your battery is charged to minimum 60%. Enable USB Debugging in Settings->Applications->Development
0.3 Make sure you have the files needed, ie. Recovery 4.6.2, Galaxo 1.6.2 and the XEJC6 firmware as linked in the Odin guide. You should still have the SDK installed and ADB up and running. Just like last time I will assume you installed the SDK in C:\Android so if you didn't just change the paths accordingly.
Phase 1: Install the Recovery
1.1 Extract the Recovery 4.6.2 zip. You should now have 2 files, recovery.img and RECTOOLS.tar.gz
1.2 Copy the extracted "recovery.img" to "C:\android\tools\"
1.3 Change the name on "Galaxo_V1.6.2.zip" to "update.zip"
1.4 Extract the firmware zip and rename "I7500XEJC6-PDA-CL209906.tar" to "SAMSUNG.tar" (in caps!)
1.5 Connect your phone and mount your SD card, now copy "SAMSUNG.tar", "update.zip" and "RECTOOLS.tar.gz" to the root of the card. This can be done with the ADB Push command if you prefer it but in my opinion that doesn't exactly make it simpler
1.6 If you followed the above steps correctly you should now have "recovery.img" (from the Recovery 4.6.2 zip file) in C:\android\tools and in the root of your SD card "SAMSUNG.tar" (renamed from the firmware zip), "update.zip" (renamed Galaxo 1.6.2 zip) and "RECTOOLS.tar.gz" (from the Recovery zip)
1.7 Shut down your phone and connect it to your computer via USB
1.8 Press "windows-button + R" and type in cmd, Enter
1.9 In your cmd window type "cd c:\android\tools" and press enter
1.10 Type "fastboot flash recovery recovery.img" (without the "") and press enter. The response should be "Waiting for device" like shown in this picture
1.11 Start your phone in fastboot mode by pressing "Call + Power/End call"
1.12 Your phone should show you a terminal-like black screen with white text that say FASTBOOT in the top. The cmd window on your computer should find your device and after a short while say "OKAY" as will your phone. If it stays on waiting for device try typing in the "fastboot flash recovery recovery.img" again but this time don't hit enter until you've started your phone in fastboot. You will have something like 10-15 seconds before the phone restarts so be quick on that Enter key. If you get the same result again, go back to the Odin guide and make sure that you have ADB live and kicking.
1.13 Your phone reboots and the cmd window will go back to showing c:\android\tools and accept input. Just shut your phone down again.
Phase 2: Flash Galaxo ROM
2.1 Boot your phone in recovery mode by pressing "Volume down + Call + Power/End call". It should now look similar to this picture (older version, picture borrowed from Drakaz)
2.2 Just in case you Galaxo update doesn't work as planned or you decide to switch back, make a Nandroid back-up. Do this by selecting "Nandroid backup" with your navigation pad and pressing "OK". This will take a while and when done return to the previous screen. Make sure it says "backup complete!" in the bottom of the screen. Now you can always return to this "clean state".
2.3 Before we update it with Galaxo we perform a wipe, select the entry "Wipe data/factory reset" press "OK" and then confirm. get a cup of coffee while you wait and then we'll sprint through the last part.
2.4 Time for the actual Galaxo update! Select the entry "Apply sdcard:update.zip", confirm and start to get exited
2.5 When the update is done you only have one step left, and that is to restore Google applications. Drakaz are not allowed to put these in the ROM so instead we pull them from the firmware (this is why we have the SAMSUNG.tar file). Select "Restore G.Apps" and confirm. When it's done select "Reboot system now" and enjoy your new Samsung Galaxy, powered by Galaxo rom.
2.6 Phone doesn't start, stays on the blue Samsung logo? Most likely Restore G.Apps failed. This can happen, select "Mount SD(s) on PC" and on your computer look for the recovery.log. Open it in notepad, at the bottom you will find why it didn't work. Most of the times it's one of these 2:
File not found - Did you forget to copy SAMSUNG.tar? Did you name it properly (remember CAPS)? Did you copy it to the root and not some folder?
Checksum failed - Did you remember to perform the wipe before applying the update.zip? Do you have the correct file (I7500XEJC6-PDA-CL209906.tar renamed as SAMSUNG.tar)?
When you feel that you have checked the above, delete the SAMSUNG.tar and copy it again (don't overwrite! Shouldn't make a difference but I've seen it). Unmount the SD and start over from 2.3 performing the wipe.
Optional Phase 3: Personalize your Galaxy
Some small steps I have taken to get the most out of my phone:
The Galaxy stock keyboard is in my opinion junk. To get a mod of the Desire keyboard have a look here: http://einartysen.se/change-to-htc-keyboard-on-your-non-htc-android-device/
I got tired of the vanilla Android look and got myself a theme, there are many more out there. Just Google on Galaxo themes, note that there are a couple of different ways to install them. This is the one I use http://www.frandroid.com/forum/viewtopic.php?id=8640 with instruction (Google Translate does the trick if you don't speak french).
If anything is unclear, let me know in the comments and I'll work trough that part again!
This guide could not have been written without Drakaz hard work for the community and everyone else dedicating time to trouble shoot and explain in forums like: www.frandroid.com www.phandroid.com www.hdblog.it and last but definitely not least www.swedroid.se and their Wiki.
Tired of your Galaxy? Getting tired of Samsungs unwillingness to update your phone? Then it might be time to consider rooting it. Before you look any closer you should remember that unlocking your bootloader will void your warranty. The risks are slim but they do exist and neither I or anyone else will take any responsibility for any problem that could occur. However you will always loose all your data on the phone! The external SD card will be left untouched.
That was the disclaimer on to more fun stuff! This guide will upgrade your phone firmware and baseband to I7500XEJC6 which is a leaked official (almost) firmware from Samsung. Tool for this is Odin Multi Downloader and this guide should work fine with later versions as well. It's not as hard as it look, I just wrote a quite extensive guide divided in many steps. My goal is that you should be able to achieve this without any pre-knowledge at all. After that you can choose to continue and install Galaxo 1.6.2 ROM and Recovery 4.6.2 by Drakaz. The recovery image contains a set of tools that can be accessed by booting the phone in recovery mode whilst the ROM is a modification of the actual phone OS that you will boot every day. Read my next post for that here. This is not very hard and you should be good to go in about an hour if the drivers doesn’t give you a very hard time. Note that this guide focus on how to do this on a Windows computer, it’s possible on Mac and Linux but since I don’t have any experience on that I’ll let you look for that answer somewhere else.
Phase 0: Preparations
0.1 Time to get your phone ready, and get the necessary files.
If you already have ADB (Android DeBugging) up and running just skip the driver steps, otherwise keep reading.
0.2 Get the Android SDK from here: http://developer.android.com/sdk/ then unzip it wherever you like. This guide will assume that you unzipped it to c:\android\ to keep it simple.
0.3 Download this very small zipfile and extract the file android_winusb.inf to c:\android\usb_driver\i386 (or if you use a 64-bit windows c:\android\usb_driver\amd64)
0.4 Install Samsung PC studio from the CD that came with your phone (or get it here from Samsung)
0.5 Activate USB debugging on your phone, Settings->Applications->Development->Enable USB debugging
0.6 Connect your phone to your computer, Windows will start to install your drivers but will fail on one device
0.7 Open the Device Manager. Right click on the unknown device and select “Update driver” then “Browse my computer for driver software”
0.8 Choose to search the location c:\android\usb_driver\i386 (or \amd64). Choose to install the driver even though it isn’t signed.
0.9 Time to see how it went, you should now have “ADB Interface->Samsung Galaxy Composite ADB Interface” in your Device Manager. To make it more exiting this isn’t always the case. I used to have it, but not any more. ADB still works though…to be sure Press “Win-button + R” and type in “cmd” then press “Enter”
0.10 In the terminal window that opens type (without the “”) “cd c:\android\tools” and press enter. Then use your very first ADB command by typing “adb devices”. Now you should get a reply that looks something like this:
0.11 If you did get I7500xxxxx, congratulations. ADB is up and running! If you didn’t we have something of a problem on our hands. Could be of several reasons but start with de-select debugging, connect to your computer and mount your SD card. Unplug and redo from step 0.XX. I also added some alternative drivers from Samsung here. Post in comments if you can’t get it to work! There are so many alternative drivers and ways to install them floating around that posting everything here would be impossible. With the first device I tried only the first driver was needed, with the second I installed the second zip as well to get it to work.
Just found a new driver...once again. Amazing how hard it can be but several people says that this is it :) Here's the link
Phase 1: Update your Firmware with Odin Multi Downloader
1.1 Unzip both the Odin and Firmware zip files at any location
1.2 Right-click Odin.exe and choose “Run as administrator”, it's absolutely necessary that you do it as an admin!
1.3 Start with pointing out the .ops file included in the Odin zip file. If you downloaded the I7500XEJC6 firmware above it should hold 4 different files ending with .tar. Other versions can hold only 1 and is then called a “one package” (note on that below). Point out your corresponding files to BOOT, PHONE and PDA (the CSC file included can be used, some people claimed different benefits from this I tried both without noticing any difference. However that is the localized file for the carrier. This leak is from Russia so before using it you should write down your APN settings and the menu positions to get to the change language options unless you speak Russian :) ) like showed in the picture below.
(If you only got one .tar file just tick the box next to “One Package” and point that file out on the right, ignore the rest.)
1.4 Time to back-up anything you want to save from your phone, search the market for backup and you’ll find many options.
1.5 Shut down you phone and connect it to your computer via USB
1.6 Start your phone in “Download mode” by pressing and holding “Volume down + OK + Power” buttons
1.7 You phone should now say “Downloading…” and show a SD card like icon
1.8 In Odin, look at the white frame on the left, it should say “<1> Added!!!”, “<1> Detected!!!” just like the picture above
1.9 Time to hit that switch! Press Start in Odin and go have a cup of coffee while Odin does it Magic. When finished it will reboot, this could take a couple of minutes
1.10 If it got stuck on the Samsung logo, have no fear. A wipe should get you going. Shut down your phone (pull the battery if you have to) and boot in recovery mode by pressing and holding “Volume down + Answer + Hang up/Power” buttons. When you see the triangle with a ! all you have to do is press the “Menu” button. The phone will perform a Wipe and then restart. Still not working? Start over from step 1.XX – Download mode.
1.11 Perform a wipe as instructed in 1.10 and you’re all done! In Settings->About phone you should now see that Firmware version says something like Galaxy 1.6 and Baseband version says I7500XEJC6. The picture below shows that screen after Galaxo installation.
Optional next step…Flash Recovery and Flash Galaxo Rom
This guide could not have been written without Drakaz hard work for the community and everyone else dedicating time to trouble shoot and explain in forums like: www.frandroid.com www.phandroid.com www.hdblog.it and last but definitely not least www.swedroid.se
When I updated my Galaxy to Android 1.6 I lost my HTC keyboard. Luckily I’ve found the simplest solution so far, and yes it does support other languages than English. Right now my phone has HTC softkeyboard with Swedish letters but one of the best things is that it allows me to change that to English in a whim just like if it was the stock one!
So how is this done?
For starters, it’s all made possible by jonasl at xda-developers.com who extracted this from a HTC Desire ROM. I had absolutely nothing to do with the creation of this method I’m just sharing what I’ve learned. The files needed (and instructions, full feature list and more details) can be found in this thread: http://forum.xda-developers.com/showthread.php?p=5475701. I’m just gonna make it a bit clearer and not use the ADB method which in my opinion require a bit more technical knowledge.
Update 20100531, just like Albin stated in the comments this has gotten a lot easier now. Get the files at the link above, add to your sd-card and install with any app manager. Just make sure you enabled "Unknown sources" in Settings->Application. Done! Updated version works with the pre-FroYo release as well.
- First, get the files. There are one version for low resolution phones (Samsung Galaxy, HTC G1 etcetera) and one for high resolution (Nexus One, Motorola Droid/Milestone etcetera). Note that the later version of low-res only works on Android 1.6 and up, if you have an older version of Android use an older version (available further down)
- Unpack the zipfile at any location.
- Connect your phone and mount your SD Card (Notification bar->Mount) and copy HTC_IME.apk and .htcime to the root of your SD card (if you want to be able to recalibrate your touch input you also need to copy Clicker.apk)
- From your computer double-click .htcime and choose to open it with Notepad (can be found in C:\Windows) or other text editor.
- Put a # in front of every language you DON’T intend to use, the rest will be available in the same order as in the list. DON’T change the number in front of each line (Language ID)! Then it should look something like this (with more languages further down):
- Dismount your SD card (reverse mount procedure) and unplug your phone
- If you don’t have a file manager on your phone, get one from the market (Astro file manager, Linda etcetera) anyone should do
- On your phone, go to: Settings -> Applications. Tick the box next to “Unknown sources” (otherwise you can only install applications from the market, remove it when you’re done if nervous)
- Open the file manager you’ve chosen. Find the files you copied and select HTC_IME.apk and chose to install
- Then go to: Settings -> Locale & text. Tick the box next to Touch Input
- Start to write a text message (any text field will do really)
- Touch and hold the text field until you get a pop-up and then select “Input method”
- Mark “Touch Input”. Re-select the text field and the keyboard that shows up should be the HTC one.
- To chose between your languages and the different versions of the keyboard (QWERTY, Compact QWERTY or Dial pad) tap the settings button as shown here
On Android phones you can activate a feature called pattern lock. This feature can be compared to a Windows computer asking for password after the screen saver kicked in, only instead of a password you use a pattern. You get a screen with 9 dots and you draw a pattern of your choice with 4 of them. If you forget your pattern (or have kids that likes to play with phones) you will after 3 faulty attempts be unable to use the pattern to unlock it. Instead you are asked for your Google account and password (that is setup with the phone of course). This is where the problem starts.
For many, many users providing the username and password won’t change a thing. For some people changing the password via a computer has worked but that is uncommon. Most people ends up with a very expensive paperweight. Have no fear, there are solutions to almost everything!
This is your 3 step solution
- Factory reset your phone (links to Android device manuals can be found below, it differs between devices)
- Setup your phone just like you did the first time you unpacked it (use the same Google Account if you want your old contacts back!)
- Restore any manual back-ups and install your previous applications from the My Downloads list.
How do I factory reset? HTC leads the way and put this information in their manuals, other manufacturers should learn from this!
Dear readers, as much as I would love to keep a directory on how to factory reset every single Android device out there, it's just not possible. Use your rights as a customer, go back to the store and ask them to help you factory reset your device!
HTC Magic (a.k.a. My Touch) manual:
- With the phone turned off, PRESS and HOLD Volume down and Send buttons CALL buttons (the manual says SEND and with that they obviously mean Call)
- Press the END/POWER button. You will see a screen with three Androids at the bottom of your screen
- Follow on screen instructions
Samsung Galaxy (note old Galaxy i7500, Galaxy S further down):
1. Turn off your Galaxy.
2. Hold volume_down+call+power button.
3. After boot, press menu button to start recovering.
Motorola Droid (a.k.a. Milestone): 1. Turn the Droid off. If it won’t turn off, take the battery out then place it back in.
2. Open the keyboard and press the X key while pressing and holding Power. The device will power on. Keep holding the buttons down until a yellow triangle appers.
3. Press the Camera and Volume Up buttons at the same time to get to the menu.
4. Use the direction pad to the right of the keyboard to select the Format option.
1. Turn the phone off. If it’s frozen in the on state, pull the battery.
2. Press and hold both the Home and Back buttons simultaneously.
3. While continuing to hold the buttons, press the Power button.
4. Release Home and Back.
5. Follow the instructions on the screen to complete the hard reset.
If you want to do a Hard Reset but can't do it through the menu, please use the update from T-Mobile UK website: T-Mobile - Help & Support
But use the file from the "Android updates" section and the following piece:
November 2009: T-Mobile Pulse software
This software update should be used ONLY when your T-Mobile Pulse has been security locked and you do not have a valid password.
- If you right-click on your mouse here and select the "Save target as.." option - it should take about 2 minutes to download depending on your internet connection speed.
PLEASE NOTE: Installing this update will remove all existing data on your T-Mobile Pulse.
- Then in your pc format the SD card. then copy the folder dload to your new formatted SD card. So the folder with the two files will be on there.
- Insert your SD card in the phone
- Then when your phone is off, do the following:
Vol + key & "hang up button" - keep them both together pushed and then turn on the phone. Then the update will start automatically. Once the update is finished it might hang to long in the "phone will restart automatically". If so, take out the battery again and turn the phone on normally. then it all will go as normal.
- Once the update is done, you will have to configure your phone again, which also means you can choose the language again.
T-Mobile Pulse instructions from "inge75" in the Android forums.
Sony Ericsson X10 -mini, pro etcetera
- Go to: www.sonyericsson.com
- Click the support tab and then Download Software
- Download the Update Service application
- Run the application as administrator, choose your model and follow the instructions.
Sprint (Samsung) Epic 4G and Samsung Galaxy S
- With your phone turned off. Pull the battery out and reinsert it if needed.
- Press and Hold "Volume Down" button
- Press and Release the "Power" button (while still holding "Volume Down"
- Your phone should now boot to a menu where you can choose Fastboot, Recovery, Clear Storage, or Simlock
- Select Clear Storage by pressing the "Volume Down" button
- Press the "Power" button
- Confirm your decision with "Volume up" (Cancel with "Volume down")
Motorola (Nextel) i1 - Now confirmed, working!
- Make sure your device is turned off, pull the battery if needed
- Push and hold: "Volume Up" + "Volume Down" + "Call" + "Center button", press "Power"
Micromax A25, A57 and A89 (confirmed)
- Press and hold volume up + home button and power on/off shows the android logo
- press home button one time
- Entering android system recovery mode… use volume key to select wipe data/factory reset
LG Nexus 4
- Make sure your device is turned off, pull the battery if needed
- Push and hold: "Volume Down" + "Power"
- Push "Volume Down" twice and then select with "Power" taking you to the Recovery menu.
- Follow the instructions in the recovery menu and make your way to Wipe data/Factory reset
This is information I gathered from both here and there, manuals and end users. The usual suspects: Swedroid, Android forums, xda-developers and knowyourcell