Edit fiddle - JSFiddle - Code Playground

HTML

xxxxxxxxxx
 
<div>
<table id="zp">
   <thead>
       <tr>
           <th>Имя</th>
           <th>Фамилия</th>
           <th>Дата</th>
           <th>Премия</th>
           <th>Аванс</th>
           <th>Зарплата</th>
       </tr>
    </thead>
       
   <tr>
      <td>Сергей</td>
      <td>Петрович</td>
      <td>20.02.2017</td>
      <td>2600</td>
      <td>15000</td>
      <td>25000</td>
   </tr>
   <tr>
      <td>Иван</td>
      <td>Сидорович</td>
      <td>22.02.2017</td>
      <td>400</td>
      <td>7500</td>
      <td>3000</td>
   </tr>
   <tr>
      <td>Николай</td>
      <td>Иванович</td>
      <td>13.04.2017</td>
      <td>5000</td>
      <td>20000</td>
      <td>40000</td>
   </tr>
   <tr>
      <td>Сергей</td>
      <td>Петрович</td>
      <td>20.02.2018</td>
      <td>3000</td>
      <td>17000</td>
      <td>25000</td>
   </tr>
   <tr>
      <td>Иван</td>
      <td>Сидорович</td>
      <td>22.04.2018</td>
      <td>4100</td>
      <td>8500</td>
      <td>3100</td>
   </tr>
   <tr>
      <td>Николай</td>
      <td>Иванович</td>
      <td>23.05.2018</td>
      <td>5000</td>
      <td>20000</td>
      <td>40000</td>
   </tr>
   <tr>
      <td>Сергей</td>
      <td>Петрович</td>
      <td>20.07.2017</td>
      <td>200</td>
      <td>16000</td>
      <td>25000</td>
   </tr>
   <tr>
      <td>Иван</td>
      <td>Сидорович</td>
      <td>22.05.2017</td>
      <td>410</td>
      <td>7550</td>
      <td>3100</td>
   </tr>
   <tr>
      <td>Николай</td>
      <td>Иванович</td>
      <td>13.04.2017</td>
      <td>5300</td>
      <td>20400</td>
      <td>45000</td>
   </tr>
   <tr>
      <td>Сергей</td>
      <td>Петрович</td>
      <td>21.02.2018</td>
      <td>3000</td>
      <td>17000</td>
      <td>25000</td>
   </tr>
   <tr>
      <td>Иван</td>
      <td>Сидорович</td>
      <td>21.04.2018</td>
      <td>4100</td>
      <td>8300</td>
      <td>3200</td>
   </tr>
   <tr>
      <td>Николай</td>
      <td>Иванович</td>
      <td>21.05.2018</td>
      <td>5100</td>
      <td>21000</td>
      <td>41000</td>
   </tr>
</table>
</div>
<div id="result">
</div>

JavaScript

Module

xxxxxxxxxx
 
var rows = $('#zp tbody tr');
var registryByYears = {};
rows.each((index, row) => {
  //console.log(row);
  var name = $('td', row).eq(0).text();
  var surname = $('td', row).eq(1).text();
  var date = $('td', row).eq(2).text();
  var sum1 = $('td', row).eq(3).text(); // премия
  var year = date.substr(-4);
  var employeeKey = `${year}_${name}_${surname}`;
  if (!registryByYears[employeeKey]) {
    registryByYears[employeeKey] = {
      name: name,
      surname: surname,
      year: year,
      sum1: 0,
      sum2: 0,
      sum3: 0,
      count: 0,
      avg1: 0,
      avg2: 0,
      avg3: 0
    }
  }
  registryByYears[employeeKey].sum1 += parseInt(sum1, 10);
  registryByYears[employeeKey].count++;
  registryByYears[employeeKey].avg1 = registryByYears[employeeKey].sum1 / registryByYears[employeeKey].count;
});
console.log(registryByYears);
​
var result_text = "<table><thead><tr><th>Имя</th><th>Фамилия</th><th>Дата</th><th>Премия</th><th>Аванс</th><th>Зарплата</th></tr></thead>";
Object.values(registryByYears).forEach(item=>{
  result_text+="<tr><td>"+item.name+"</td><td>"+item.surname+"</td><td>"+item.year+"</td><td>"+item.sum1+"</td><td>"+item.sum2+"</td><td>"+item.sum3+"</td></tr>";
});
result_text+="</table>";
var result = document.getElementById("result");
result.innerHTML = result_text;
​
​

CSS

xxxxxxxxxx
 
#zp td, #zp th {border:1px solid #000; padding:5px 10px;}
#result td, #result th {border:1px solid #000; padding:5px 10px;}

942px

JSFiddle Console. Turn on/off in Editor settings.
☁️ "Running fiddle"
{ 2017_Иван_Сидорович: { avg1: 405, avg2: 0, avg3: 0, count: 2, name: "Иван", sum1: 810, sum2: 0, sum3: 0, surname: "Сидорович", year: "2017" }, 2017_Николай_Иванович: { avg1: 5150, avg2: 0, avg3: 0, count: 2, name: "Николай", sum1: 10300, sum2: 0, sum3: 0, surname: "Иванович", year: "2017" }, 2017_Сергей_Петрович: { avg1: 1400, avg2: 0, avg3: 0, count: 2, name: "Сергей", sum1: 2800, sum2: 0, sum3: 0, surname: "Петрович", year: "2017" }, 2018_Иван_Сидорович: { avg1: 4100, avg2: 0, avg3: 0, count: 2, name: "Иван", sum1: 8200, sum2: 0, sum3: 0, surname: "Сидорович", year: "2018" }, 2018_Николай_Иванович: { avg1: 5050, avg2: 0, avg3: 0, count: 2, name: "Николай", sum1: 10100, sum2: 0, sum3: 0, surname: "Иванович", year: "2018" }, 2018_Сергей_Петрович: { avg1: 3000, avg2: 0, avg3: 0, count: 2, name: "Сергей", sum1: 6000, sum2: 0, sum3: 0, surname: "Петрович", year: "2018" } }

New Automatically expiring fiddles

Add expiration date to your fiddle (time button next to Save), it can be: 1 day, 10 days, 1 month, 6 months, 1 year, and you can keep the fiddle forever. Right now the default is Keep forever but this will probably change.
Ability to download a fiddle

We've added the ability to download a specific fiddle version from the Editor's interface. I'll be downloaded as a Zipped single HTML file.
Your recent fiddles when logged out

Saving a fiddle, even when you're logged out, will put it under the Your recent fiddles modal in the sidebar. They will eventually disappear (since they're anonymous), but now you'll have time to save them under your user after logging in.
Tailwind CSS

Added Tailwind CSS to the list of precompilers - even though it's really HTML, you can activate it from the dropdown in the CSS panel. Tailwind CSS would be best used with HTML Hot-reload enabled.
Code linting and formatting

We've replaced the dated code linter and formatted with more modern ones: Stylelint and Prettier.
JSFiddle 3.0
The 3.0 updates brings a lot of changes, most notably a modern UI refresh.

There was an increadible amount of under-the-hood changes for the front-end, we've mostly moved away from pre-processors. The light/dark themes are using a modern light-dark() approach. The refactoring allows for more changes to be made in a spedier manner.
- In the new sidebar you can find our mini-apps (right now the Color Palette Generator)
- System theme follows your OS settings
- CSS Hot-reload - styles update immidietly as you type
- HTML Hot-reload (experimental) - update HTML immidietly as you type
- Results panel color follows the selected theme
- Title and description are now a single field
- Public Profile page is completelty redesigned and can be easily used as your code showcase
- Groups are now Collections and we have big plans for them
- Collections are completely redesigned
- Users can now add groups straight from the editor
Import fiddles as modules

Import fiddle code into other fiddles with Modules and Imports.

JS Modules: import [name] from '@jsfiddle/[username]/[fiddle].js'

CSS Import: @import url('@jsfiddle/[username]/[fiddle].css')

See how this works in this fiddle.
Fiddle listing shows latest version

The fiddle listings (Public, Private, Titled, etc) will now display latest versions instead of the ones saved as Base versions - this was causing more confusion than good, so we decided to change this long-standing behavior.
Evaluate code into the console

Custom Console beta is getting more stable and feature-rich. Just added the ability to evaluate code in the console.

Console

Ad-free

Use pre-released features

Fiddle collections

Private collections and fiddles

Console

Console

Language

Doctype

Language

Extensions

script attribute

Language

Reset CSS

Keep JSFiddle running.Whitelist us in your content blocker.

Join the 4+ million users, and keep the JSFiddle dream alive.

Ad-free

Use pre-released features

Fiddle collections

Private collections and fiddles

Console

Tabs:

Visual:

Embed snippet Prefer iframe?:

Behavior

General

Console

New Automatically expiring fiddles

Ability to download a fiddle

Your recent fiddles when logged out

Tailwind CSS

Code linting and formatting

JSFiddle 3.0

Import fiddles as modules

Fiddle listing shows latest version

Evaluate code into the console

`script` attribute

Keep JSFiddle running.
Whitelist us in your content blocker.