Advertisement
iyed

Untitled

Mar 21st, 2021
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. function myFunction() {
  2. var sheet = SpreadsheetApp.getActiveSheet();
  3. var data = sheet.getDataRange().getValues();
  4. var itemsTaken = {};
  5. var totalItems = 0;
  6. var totalUsers = 3;
  7. var currentUser = 0;
  8. var aCounter = 0;
  9. for (var i = 0; i < data.length; i++) {
  10. if(!Number.isNaN(Number.parseInt(data[i][1], 10)))
  11. {
  12. totalItems++;
  13. }
  14. }
  15.  
  16. for(var s = 0; s < totalItems; s++)
  17. {
  18.  
  19. var smallestNumIndex = -1;
  20. for (var i = 0; i < data.length; i++) {
  21. if(!itemsTaken.hasOwnProperty(i) && !Number.isNaN(Number.parseInt(data[i][currentUser+1], 10)))
  22. {
  23. if(smallestNumIndex == -1) smallestNumIndex = i;
  24. if(Number.parseInt(data[i][currentUser+1], 10) < Number.parseInt(data[smallestNumIndex][currentUser+1], 10)) smallestNumIndex = i;
  25. }
  26.  
  27. }
  28. itemsTaken[smallestNumIndex] = 1;
  29. sheet.getRange(smallestNumIndex+1,totalUsers+2).setValue(data[0][currentUser+1]);
  30. Logger.log('Setting: [' + smallestNumIndex + ',' + totalUsers+2 +'] :' + currentUser.toString());
  31. aCounter++;
  32. currentUser++;
  33. currentUser = currentUser%totalUsers;
  34. }
  35.  
  36. }
  37.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement