If you are doing business analysis or calculations in your Google Apps spreadsheets then you probably need some kind of currencies converter for doing all sorts of tasks…

• Convert your revenue from Dollars to Euros
• Currency Risk analysis
• Managing your expenses in one or multiple exchange rates
• ….

One might guess that Google supports Exchange rates in their spreadsheets “AS-IS” but this is not the case. Also, their labs service Google Finance is deprecated so we must get our hands dirty and take the JavaScript approach for populating our spreadsheet with REAL-TIME currency quotes.

The first thing is to find the source of our data and for this use-case we decided to give OpenSource Exchange rates JSON data a green light. This service returns JSON formatted date for all currencies and please note that the base currency is the US Dollar. If you click here you will see the example of JSON data…

Next we need to create a script for our spreadsheet and we can do this task if we click on “Tools” -> “Script Manager”. FYI, scripting in google spreadsheet is quite powerfull and you can scan through entire documentation on official Google apps help portal

Next, we need to set triggers on our new script to fire up when we open the spreadsheet! This step is performed through the user interface and the full documentation can also be found on Google help portal

When you’re done setting up triggers, navigate to script editor section and write up JavaScript that is exactly the same as this one… :))

function myFunction()
{
  var response = UrlFetchApp.fetch("http://openexchangerates.org/latest.json");

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SheetName");

  var object = Utilities.jsonParse(response.getContentText());

  var objRates = object["rates"];

  for (var i in objRates)
  {
    if(i="HRK")
    {
      sheet.getRange(2, 1).setValue(objRates[i]);
    }

    if(i="EUR")
    {
      sheet.getRange(2, 2).setValue(objRates[i]);
    }
  }
}

Just change the “SheetName” to the name of the sheet where you want your data to show. Note that this script takes two currencies (Euro and Croatian Kuna) and places them in given row/column layout. If you need some other currencies just add another IF statement and set some different range of the cell!

Happy coding

Udemy je sastavio interesantnu infografiku o usporedbi tri popularna programska jezika … PHP , Ruby i Python. Agregirani podaci se odnose na povijest, popularnost, lakoću korištenja te potražnjom za određenim jezikom.

Neki od zaključaka

• Python je jezik “o kojem se najviše priča” (izvor: IEEE Spectrum’s analysis of IRC discussions)
• Kod programerskih poslova, najviše se traži PHP … 21% (izvor: Craigslist & Monster.Com)
• PHP je također generalno najpopularniji sa 6% među svim programskim jezicima  (izvor: TIOBE Index)

Krajem 12. mjeseca smo odradili intervju za novogodišnji VIDI časopis, a teme su bile edukacija u Algebri, slijedni poslovni poduhvati te upotreba klasično stečenog znanja iz Algebra kod razvoja web i mobilnih aplikacija. Kupite svoj VIDI primjerak…još malo pa nestalo ;)

We’ve been using new DotNetNuke 6.0 since its release few weeks ago, testing it and building new website for our client. Here’s a new feature in DotNetNuke 6.0. Now you can easily add multiple pages at once, creating web site hierarchy in few clicks.

First you right click on portal name in left menu “Add page(s)” link appears.

Click on link “Add page(s)” and write website hierarchy in text box on the right side as shown on picture 2. One page per line. If inserting website hierarchy use “>” for nested pages.

Click on “create page(s)” button. Here how it looks if pages are created successfully.

This is navigation for our new DDN website. Good luck and read you later.