Convert Formula Results into Absolute Values: Mac Numbers '09

If you need to convert Formula results of a column into absolute values, there is no standard feature in Numbers '09 that will help you achieve this. 

You would need this hack to make it happen. 

  1. Select the entire column
  2. Press CMD+C and copy the content of the column
  3. Delete the content of the column by pressing the Delete key
  4. Go to Edit menu and Choose Paste Values (not PASTE or CMD+V)

The column would now have the absolute values instead of the Forumla.

Dual Mac Setup: Work + Home

It's been over a year since I switched to a Macbook Air. It is easily the best Mac laptop I have had till date. I loved the Pro but Air was great for two things: portability and temperature of the machine. The biggest compromise I had to make was the storage space. Having settled for a 128GB was way too ambitious given the fact I had a tons of music, pictures and videos. I thought external disks would make up but they were never as portable. 

I thought the next Air upgrade would actually have a 512GB factory build, but it didn't. I am expecting them to be available in the next release though. While, I had almost decided to wait - I thought about using 2 machines instead of one. Get the best of both the worlds. 

Macs-air-imac

I discussed the idea with KS Sreeram and then read Elliot Jay's blog post. My thought was soon a decision. 

The challenge with a dual machine setup is the data sync. When I get home, I would need everything required to be able to continue work. This could have been slightly daunting task a few years ago but sounds rather achieveable today. iCloud, Dropbox and CodebaseHQ can take care of majority of syncing. And quite effortlessly. Email over IMAP and HappyFox would take care of emailing. 

Music, Photos and Video would primarily be available on the iMac. With their backups (along with the entire system back up) would be available on 1 or 2 external hard drives. I still need the ultimate remote, disaster ready backup strategry. 

So, I would be switching to a 27" iMac on monday and use my Macbook Air as a secondary machine. I'm excited to try this setup and would share my experience in upcoming enteries on the blog. 

For my baby

i dreamt

of a beautiful morning

a bright new day

 

tasting tears

with a smiling face

 

a little angel

came my way

held my hand

and said

'papa, lets play'

 

her sparkling eyes

had so much to say 

 

I felt her love

and joy within me

 

7 may 2011

Shalin Jain

Inspired by people: Starting up, being focused & staying inspired

I have to admit this, whatever I have done in last 10 years for Tenmiles has been hugely inspired by people around me. I gave up on education soon after I joined College. I did enough to secure my degree and did everything to be surrounded by great minds.

Gautam Jain of Conceptworld was a huge inspiration to let me start a company at 18. Srinivas ramanathan of Eginnovations gave me early insights into building complex technology products. KS Sreeram, founder of Clay programming language, helped me turn my dreams into action plans and was largely instrumental in convincing me to stay-put with products.


And now, Swarna Rethas, who recently completed 7 years at Tenmiles makes me realize yet again in the power of people. Being backed by great people simply multiplies the strength of any company. There is no better metric that can excite you to remain in business and love the work you do everyday. It is an inspirational milestone and couldn't do without letting the world know about it.

Beautiful You

I wrote this little poem for my wife few weeks ago. We are extremely excited to become parents in a few months. 

 

Beautiful You

In your eyes

in your smile

I see the reflections

of our unborn child

 

I love everyday

that goes by

thinking of our little angel

and the beautiful you.

Posterous theme by Cory Watilo