Bens Blog

During my former internships in a consulting company I had to work A LOT with Microsoft Excel and often had to use dynamic cell references over multiple worksheets. Recently I started using the spreadsheets of Google Docs to track my bank account balance and to figure out where all my money goes. I decided to have one sheet for every month + one sheet of the month I want to analyze. But how do I dynamically change the reference to the sheet (the monthly sheet) I want to analyze without editing every single formula? Here is my solution : Create the target sheets and your overview sheet - I gave my sheets the names Month + Year (July 09) In the overview choose one cell that you want to contain the reference sheet and enter the sheet name - cell D24 in the example - Using the month names you might have to write 'July 09 , otherwise Google will think it's a date. In the overview you can now dynamically reference to a detail sheet using the following formula: =INDIRECT("'...

Yesterday I tried to figure out how to post my blog posts on my Facebook profile. First I tried different application but all they could do was adding a box on your profile. After searching for on google for a couple minutes I found one video on youtube that lead me the way: Import Blog/RSS in Facebook profile . You can do it even easier as in the video. When you are on your profile in Facebook, you just have to click on Import (as shown in the picture) and you can import not only a RSS feed from your blog, but also integrate lots of different websites like Youtube, Google Reader and most important for me: Picasa. Finally you can use all the different great tools from Google and integrate them all into one Profile. UPDATE: Finally there is also a blog post in the offical blog from blogger about the topic: Blogger Buzz: Facebook Your Blog

Gerade habe ich mir die Formulare von Google Text & Tabellen angeschaut und bin richtig beeindruckt! Innerhalb von 2 Minuten konnte ich meine eigene Umfrage erstellen, die ich nun in E-Mails, Webseiten verwenden kann oder direkt über Google ausfüllen kann. Das Ergebnis wird in einer Tabelle gespeichert. Ein kleines Beispiel gibt es direkt hier: Mit Sicherheit werde ich in Zukunft mehr damit arbeiten. Google Chrome habe ich mir diese Woche zum ausprobieren installiert, von der Geschwindigkeit bin ich richtig erschrocken, so schnell hat sich Google Mail noch nie bei mir geöffnet. Natürlich fehlen dem Broswer noch ein paar Features aber in einigen Monaten wird er bei mir wohl Firefox ablösen.