Edit in JSFiddle

document.addEventListener("DOMContentLoaded", function() {


  new FancyGrid({
    title: 'Hour Rate - Currencies',
    renderTo: 'container',
    width: 752,
    height: 500,
    data: data,
    selModel: 'row',
    trackOver: true,
    theme: 'extra-gray',
    defaults: {
      type: 'string',
      width: 100,
      resizable: true,
      sortable: true,
      menu: ['size', '-', 'sort', '-', 'columns', '-', 'lock']
    },
    columns: [{
      index: 'name',
      title: 'Name'
    }, {
      type: 'string',
      index: 'country',
      title: 'Country'
    }, {
      index: 'hour',
      type: 'currency',
      title: 'Hour rate',
      width: 70
    }, {
      index: '12*180*hour',
      type: 'currency',
      title: 'Dollar',
      currency: Fancy.currency.USD,
      cellAlign: 'right',
      width: 70
    }, {
      index: '0.91*12*180*hour',
      type: 'currency',
      title: 'Euro',
      currency: Fancy.currency.EUR,
      cellAlign: 'right',
      render: function(o) {
        o.value = Fancy.Number.format(o.value, ',', 0);

        return o;
      },
      width: 90
    }, {
      index: '0.80*12*180*hour',
      type: 'currency',
      title: 'Pound',
      currency: Fancy.currency.GBP,
      cellAlign: 'right',
      render: function(o) {
        o.value = Fancy.Number.format(o.value, ',', 0);

        return o;
      },
      width: 90
    }, {
      index: '108.36*12*180*hour',
      type: 'currency',
      title: 'Yen',
      currency: Fancy.currency.JPY,
      cellAlign: 'right',
      render: function(o) {
        o.value = Fancy.Number.format(o.value, ',', 0);

        return o;
      },
      width: 90
    }, {
      index: '72*12*180*hour',
      type: 'currency',
      title: 'Ruble',
      currency: Fancy.currency.RUB,
      cellAlign: 'right',
      render: function(o) {
        o.value = Fancy.Number.format(o.value, ',', 0);

        return o;
      },
      width: 90
    }]
  });

});


var data = [{
    id: 1,
    name: 'Ted Smith',
    position: 'Java Developer',
    birthday: '06/22/1953',
    country: 'USA',
    hour: 52
  },
  {
    id: 2,
    name: 'Ed Johnson',
    position: 'C/C++ Market Data Developer',
    birthday: '09/12/1971',
    country: 'England',
    hour: 16
  },
  {
    id: 3,
    name: 'Sam Williams',
    position: 'Technical Analyst',
    birthday: '09/02/1973',
    country: 'USA',
    hour: 40
  },
  {
    id: 4,
    name: 'Alexander Brown',
    position: 'Project Manager',
    country: 'USA',
    birthday: '09/25/1991',
    hour: 33
  },
  {
    id: 5,
    name: 'Nicholas Miller',
    position: 'Senior Software Engineer',
    country: 'Canada',
    birthday: '08/24/1959',
    hour: 50
  },
  {
    id: 6,
    name: 'Andrew Thompson',
    position: 'Agile Project Manager',
    country: 'Germany',
    birthday: '08/18/1978',
    hour: 27
  },
  {
    id: 7,
    name: 'Ryan Walker',
    position: 'Application Support Engineer',
    country: 'England',
    birthday: '04/02/1981',
    hour: 40
  },
  {
    id: 8,
    name: 'John Scott',
    position: 'Flex Developer',
    country: 'USA',
    birthday: '02/14/1960',
    hour: 71
  },
  {
    id: 9,
    name: 'James Phillips',
    position: 'Senior C++/C# Developer',
    country: 'USA',
    birthday: '10/18/1991',
    hour: 58
  },
  {
    id: 10,
    name: 'Brian Edwards',
    position: 'UNIX/C++ Developer',
    country: 'USA',
    birthday: '04/16/1963',
    hour: 64
  },
  {
    id: 11,
    name: 'Jack Richardson',
    position: 'Ruby Developer',
    country: 'Germany',
    birthday: '11/20/1982',
    hour: 58
  },
  {
    id: 12,
    name: 'Alex Howard',
    position: 'CSS3/HTML5 Developer',
    country: 'USA',
    birthday: '07/22/1987',
    hour: 66
  },
  {
    id: 13,
    name: 'Carlos Wood',
    position: 'Node.js Developer',
    country: 'USA',
    birthday: '08/08/1988',
    hour: 41
  },
  {
    id: 14,
    name: 'Adrian Russell',
    position: 'Frontend Developer',
    country: 'Canada',
    birthday: '06/19/1969',
    hour: 25
  },
  {
    id: 15,
    name: 'Jeremy Hamilton',
    position: 'Scala Developer',
    country: 'USA',
    birthday: '04/17/1950',
    hour: 69
  },
  {
    id: 16,
    name: 'Ivan Woods',
    position: 'Objective C Developer',
    country: 'USA',
    birthday: '03/25/1964',
    hour: 64
  },
  {
    id: 17,
    name: 'Peter West',
    position: 'PHP/HTML Developer',
    country: 'England',
    birthday: '09/06/1977',
    hour: 30
  },
  {
    id: 18,
    name: 'Lorenzo Tucker',
    position: 'Architect',
    country: 'USA',
    birthday: '10/25/1975',
    hour: 41
  },
  {
    id: 19,
    name: 'Randy Grant',
    position: 'Engineer',
    country: 'USA',
    birthday: '07/16/1969',
    hour: 50
  },
  {
    id: 20,
    name: 'Arthur Gardner',
    position: 'Analytic',
    country: 'USA',
    birthday: '09/26/1994',
    hour: 16
  },
  {
    id: 21,
    name: 'Orlando Ruiz',
    position: 'Unit Testing Developer',
    country: 'Germany',
    birthday: '11/02/1985',
    hour: 29
  },
  {
    id: 22,
    name: 'Ted Smith',
    position: 'Java Developer',
    country: 'Canada',
    birthday: '03/20/1976',
    hour: 56
  },
  {
    id: 23,
    name: 'Ed Johnson',
    position: 'C/C++ Market Data Developer',
    country: 'USA',
    birthday: '06/07/1985',
    hour: 56
  },
  {
    id: 24,
    name: 'Sam Williams',
    position: 'Technical Analyst',
    country: 'USA',
    birthday: '06/23/1981',
    hour: 42
  },
  {
    id: 25,
    name: 'Alexander Brown',
    position: 'Project Manager',
    country: 'England',
    birthday: '03/12/1989',
    hour: 71
  },
  {
    id: 26,
    name: 'Nicholas Miller',
    position: 'Senior Software Engineer',
    country: 'England',
    birthday: '08/03/1967',
    hour: 26
  },
  {
    id: 27,
    name: 'Andrew Thompson',
    position: 'Agile Project Manager',
    country: 'USA',
    birthday: '11/17/1993',
    hour: 30
  },
  {
    id: 28,
    name: 'Ryan Walker',
    position: 'Application Support Engineer',
    country: 'USA',
    birthday: '01/27/1963',
    hour: 27
  },
  {
    id: 29,
    name: 'John Scott',
    position: 'Flex Developer',
    country: 'USA',
    birthday: '01/06/1983',
    hour: 65
  },
  {
    id: 30,
    name: 'James Phillips',
    position: 'Senior C++/C# Developer',
    country: 'Germany',
    birthday: '01/06/1972',
    hour: 23
  },
  {
    id: 31,
    name: 'Brian Edwards',
    position: 'UNIX/C++ Developer',
    country: 'Canada',
    birthday: '10/07/1954',
    hour: 48
  },
  {
    id: 32,
    name: 'Jack Richardson',
    position: 'Ruby Developer',
    country: 'USA',
    birthday: '01/03/1987',
    hour: 72
  },
  {
    id: 33,
    name: 'Alex Howard',
    position: 'CSS3/HTML5 Developer',
    country: 'USA',
    birthday: '01/27/1984',
    hour: 42
  },
  {
    id: 34,
    name: 'Carlos Wood',
    position: 'Node.js Developer',
    country: 'England',
    birthday: '03/08/1966',
    hour: 66
  },
  {
    id: 35,
    name: 'Adrian Russell',
    position: 'Frontend Developer',
    country: 'USA',
    birthday: '01/26/1970',
    hour: 58
  },
  {
    id: 36,
    name: 'Jeremy Hamilton',
    position: 'Scala Developer',
    country: 'USA',
    birthday: '01/18/1981',
    hour: 18
  },
  {
    id: 37,
    name: 'Ivan Woods',
    position: 'Objective C Developer',
    country: 'Canada',
    birthday: '03/27/1982',
    hour: 73
  },
  {
    id: 38,
    name: 'Peter West',
    position: 'PHP/HTML Developer',
    country: 'Germany',
    birthday: '01/17/1986',
    hour: 56
  },
  {
    id: 39,
    name: 'Scott Simpson',
    position: 'Designer',
    country: 'USA',
    birthday: '09/13/1969',
    hour: 17
  },
  {
    id: 40,
    name: 'Lorenzo Tucker',
    position: 'Architect',
    country: 'USA',
    birthday: '05/04/1959',
    hour: 67
  },
  {
    id: 41,
    name: 'Randy Grant',
    position: 'Engineer',
    country: 'USA',
    birthday: '07/01/1976',
    hour: 41
  },
  {
    id: 42,
    name: 'Arthur Gardner',
    position: 'Analytic',
    country: 'England',
    birthday: '10/19/1970',
    hour: 73
  },
  {
    id: 43,
    name: 'Orlando Ruiz',
    position: 'Unit Testing Developer',
    country: 'USA',
    birthday: '05/17/1992',
    hour: 52
  },
  {
    id: 44,
    name: 'Ted Smith',
    position: 'Java Developer',
    country: 'USA',
    birthday: '08/19/1982',
    hour: 25
  },
  {
    id: 45,
    name: 'Ed Johnson',
    position: 'C/C++ Market Data Developer',
    country: 'Canada',
    birthday: '04/12/1970',
    hour: 35
  },
  {
    id: 46,
    name: 'Sam Williams',
    position: 'Technical Analyst',
    country: 'Germany',
    birthday: '04/23/1981',
    hour: 39
  },
  {
    id: 47,
    name: 'Alexander Brown',
    position: 'Project Manager',
    country: 'USA',
    birthday: '09/10/1970',
    hour: 30
  },
  {
    id: 48,
    name: 'Nicholas Miller',
    position: 'Senior Software Engineer',
    country: 'USA',
    birthday: '03/26/1964',
    hour: 29
  },
  {
    id: 49,
    name: 'Andrew Thompson',
    position: 'Agile Project Manager',
    country: 'USA',
    birthday: '02/18/1984',
    hour: 55
  },
  {
    id: 50,
    name: 'Ryan Walker',
    position: 'Application Support Engineer',
    country: 'England',
    birthday: '01/14/1989',
    hour: 17
  },
  {
    id: 51,
    name: 'John Scott',
    position: 'Flex Developer',
    country: 'USA',
    birthday: '02/13/1985',
    hour: 50
  },
  {
    id: 52,
    name: 'James Phillips',
    position: 'Senior C++/C# Developer',
    country: 'Canada',
    birthday: '06/22/1978',
    hour: 44
  },
  {
    id: 53,
    name: 'Brian Edwards',
    position: 'UNIX/C++ Developer',
    country: 'USA',
    birthday: '03/19/1991',
    hour: 72
  },
  {
    id: 54,
    name: 'Jack Richardson',
    position: 'Ruby Developer',
    country: 'USA',
    birthday: '09/01/1966',
    hour: 23
  },
  {
    id: 55,
    name: 'Alex Howard',
    position: 'CSS3/HTML5 Developer',
    country: 'USA',
    birthday: '06/19/1993',
    hour: 16
  },
  {
    id: 56,
    name: 'Carlos Wood',
    position: 'Node.js Developer',
    country: 'Germany',
    birthday: '05/18/1963',
    hour: 49
  },
  {
    id: 57,
    name: 'Adrian Russell',
    position: 'Frontend Developer',
    country: 'England',
    birthday: '01/15/1957',
    hour: 33
  },
  {
    id: 58,
    name: 'Jeremy Hamilton',
    position: 'Scala Developer',
    country: 'USA',
    birthday: '11/15/1975',
    hour: 16
  },
  {
    id: 59,
    name: 'Ivan Woods',
    position: 'Objective C Developer',
    country: 'USA',
    birthday: '11/01/1974',
    hour: 40
  },
  {
    id: 60,
    name: 'Peter West',
    position: 'PHP/HTML Developer',
    country: 'USA',
    birthday: '04/12/1954',
    hour: 30
  },
  {
    id: 61,
    name: 'Scott Simpson',
    position: 'Designer',
    country: 'USA',
    birthday: '05/05/1978',
    hour: 26
  },
  {
    id: 62,
    name: 'Lorenzo Tucker',
    position: 'Architect',
    country: 'Canada',
    birthday: '10/17/1990',
    hour: 42
  },
  {
    id: 63,
    name: 'Randy Grant',
    position: 'Engineer',
    country: 'USA',
    birthday: '05/01/1973',
    hour: 41
  },
  {
    id: 64,
    name: 'Arthur Gardner',
    position: 'Analytic',
    country: 'USA',
    birthday: '06/20/1961',
    hour: 53
  },
  {
    id: 65,
    name: 'Orlando Ruiz',
    position: 'Unit Testing Developer',
    country: 'USA',
    birthday: '09/10/1956',
    hour: 58
  },
  {
    id: 66,
    name: 'Ted Smith',
    position: 'Java Developer',
    country: 'Germany',
    birthday: '03/22/1959',
    hour: 41
  },
  {
    id: 67,
    name: 'Ed Johnson',
    position: 'C/C++ Market Data Developer',
    country: 'USA',
    birthday: '07/15/1958',
    hour: 28
  },
  {
    id: 68,
    name: 'Sam Williams',
    position: 'Technical Analyst',
    country: 'England',
    birthday: '01/12/1988',
    hour: 46
  },
  {
    id: 69,
    name: 'Alexander Brown',
    position: 'Project Manager',
    country: 'Canada',
    birthday: '09/23/1982',
    hour: 21
  },
  {
    id: 70,
    name: 'Nicholas Miller',
    position: 'Senior Software Engineer',
    country: 'USA',
    birthday: '05/02/1957',
    hour: 46
  },
  {
    id: 71,
    name: 'Andrew Thompson',
    position: 'Agile Project Manager',
    country: 'USA',
    birthday: '05/08/1954',
    hour: 18
  },
  {
    id: 72,
    name: 'Ryan Walker',
    position: 'Application Support Engineer',
    country: 'USA',
    birthday: '06/24/1983',
    hour: 72
  },
  {
    id: 73,
    name: 'John Scott',
    position: 'Flex Developer',
    country: 'Germany',
    birthday: '07/06/1963',
    hour: 18
  },
  {
    id: 74,
    name: 'James Phillips',
    position: 'Senior C++/C# Developer',
    country: 'USA',
    birthday: '01/13/1986',
    hour: 73
  },
  {
    id: 75,
    name: 'Brian Edwards',
    position: 'UNIX/C++ Developer',
    country: 'USA',
    birthday: '02/14/1988',
    hour: 66
  },
  {
    id: 76,
    name: 'Jack Richardson',
    position: 'Ruby Developer',
    country: 'England',
    birthday: '08/14/1963',
    hour: 27
  },
  {
    id: 77,
    name: 'Alex Howard',
    position: 'CSS3/HTML5 Developer',
    country: 'USA',
    birthday: '08/05/1950',
    hour: 61
  },
  {
    id: 78,
    name: 'Carlos Wood',
    position: 'Node.js Developer',
    country: 'Canada',
    birthday: '05/02/1973',
    hour: 20
  },
  {
    id: 79,
    name: 'Adrian Russell',
    position: 'Frontend Developer',
    country: 'USA',
    birthday: '08/21/1980',
    hour: 65
  },
  {
    id: 80,
    name: 'Jeremy Hamilton',
    position: 'Scala Developer',
    country: 'Germany',
    birthday: '11/23/1970',
    hour: 33
  },
  {
    id: 81,
    name: 'Ivan Woods',
    position: 'Objective C Developer',
    country: 'USA',
    birthday: '03/15/1971',
    hour: 30
  },
  {
    id: 82,
    name: 'Peter West',
    position: 'PHP/HTML Developer',
    country: 'USA',
    birthday: '11/15/1953',
    hour: 62
  },
  {
    id: 83,
    name: 'Scott Simpson',
    position: 'Designer',
    country: 'USA',
    birthday: '01/16/1990',
    hour: 20
  },
  {
    id: 84,
    name: 'Lorenzo Tucker',
    position: 'Architect',
    country: 'USA',
    birthday: '06/13/1992',
    hour: 33
  },
  {
    id: 85,
    name: 'Randy Grant',
    position: 'Engineer',
    country: 'England',
    birthday: '10/15/1986',
    hour: 27
  },
  {
    id: 86,
    name: 'Arthur Gardner',
    position: 'Analytic',
    country: 'Germany',
    birthday: '08/10/1969',
    hour: 21
  },
  {
    id: 87,
    name: 'Orlando Ruiz',
    position: 'Unit Testing Developer',
    country: 'Canada',
    birthday: '04/19/1992',
    hour: 30
  },
  {
    id: 88,
    name: 'Ted Smith',
    position: 'Java Developer',
    country: 'USA',
    birthday: '05/16/1981',
    hour: 37
  },
  {
    id: 89,
    name: 'Ed Johnson',
    position: 'C/C++ Market Data Developer',
    country: 'USA',
    birthday: '09/07/1954',
    hour: 35
  },
  {
    id: 90,
    name: 'Sam Williams',
    position: 'Technical Analyst',
    country: 'USA',
    birthday: '09/06/1968',
    hour: 19
  },
  {
    id: 91,
    name: 'Alexander Brown',
    position: 'Project Manager',
    country: 'USA',
    birthday: '03/15/1973',
    hour: 70
  },
  {
    id: 92,
    name: 'Nicholas Miller',
    position: 'Senior Software Engineer',
    country: 'Germany',
    birthday: '02/19/1968',
    hour: 47
  },
  {
    id: 93,
    name: 'Andrew Thompson',
    position: 'Agile Project Manager',
    country: 'Canada',
    birthday: '11/12/1987',
    hour: 24
  },
  {
    id: 94,
    name: 'Ryan Walker',
    position: 'Application Support Engineer',
    country: 'USA',
    birthday: '03/11/1992',
    hour: 19
  },
  {
    id: 95,
    name: 'John Scott',
    position: 'Flex Developer',
    country: 'England',
    birthday: '05/09/1960',
    hour: 57
  },
  {
    id: 96,
    name: 'James Phillips',
    position: 'Senior C++/C# Developer',
    country: 'USA',
    birthday: '05/25/1976',
    hour: 32
  },
  {
    id: 97,
    name: 'Brian Edwards',
    position: 'UNIX/C++ Developer',
    country: 'USA',
    birthday: '03/17/1967',
    hour: 59
  },
  {
    id: 98,
    name: 'Jack Richardson',
    position: 'Ruby Developer',
    country: 'USA',
    birthday: '02/20/1990',
    hour: 42
  },
  {
    id: 99,
    name: 'Alex Howard',
    position: 'CSS3/HTML5 Developer',
    country: 'Canada',
    birthday: '09/24/1991',
    hour: 25
  },
  {
    id: 100,
    name: 'Carlos Wood',
    position: 'Node.js Developer',
    country: 'USA',
    birthday: '02/10/1952',
    hour: 20
  },
  {
    id: 101,
    name: 'Adrian Russell',
    position: 'Frontend Developer',
    country: 'USA',
    birthday: '09/01/1962',
    hour: 56
  },
  {
    id: 102,
    name: 'Jeremy Hamilton',
    position: 'Scala Developer',
    country: 'England',
    birthday: '09/17/1961',
    hour: 51
  },
  {
    id: 103,
    name: 'Ivan Woods',
    position: 'Objective C Developer',
    country: 'Canada',
    birthday: '11/08/1967',
    hour: 23
  },
  {
    id: 104,
    name: 'Peter West',
    position: 'PHP/HTML Developer',
    country: 'Canada',
    birthday: '08/20/1956',
    hour: 66
  },
  {
    id: 105,
    name: 'Scott Simpson',
    position: 'Designer',
    country: 'USA',
    birthday: '01/15/1994',
    hour: 61
  },
  {
    id: 106,
    name: 'Lorenzo Tucker',
    position: 'Architect',
    country: 'Germany',
    birthday: '06/01/1993',
    hour: 44
  },
  {
    id: 107,
    name: 'Randy Grant',
    position: 'Engineer',
    country: 'England',
    birthday: '07/21/1966',
    hour: 58
  },
  {
    id: 108,
    name: 'Arthur Gardner',
    position: 'Analytic',
    country: 'USA',
    birthday: '03/24/1989',
    hour: 52
  }
];