miercuri, 6 decembrie 2023
marți, 5 decembrie 2023
sâmbătă, 2 decembrie 2023
News : Fornite game come vith new experiences.
The Big Bang introduces new galaxies with the collapse of Fortnite OG. These new galaxies seen in the event are the introduction of new experiences found within Fortnite. Those experiences include:
LEGO Fortnite - Explore vast, open worlds where the magic of LEGO building and Fortnite collide in this new survival crafting game.
Rocket Racing - A new racing world where you reach supersonic speeds and face fierce competition for a top spot at the finish line.
Fortnite Festival - A new way to be enveloped in music both on and off the stage.
News : CAPTAIN LASERHAWK: A BLOOD DRAGON REMIX.
Play as a citizen of Eden and earn SAND through gameplay! Join Ubisoft's Web3 Community and participate in events, contests, and raffles for the opportunity to get branded products, games, and exclusive virtual meet-ups! Eden Icons holders will receive a unique Eden care package.
You can find more on this webpage.
News : Chart with sizes values from Google Drive.
Visual data representation in graphical format can solve many of today's issues.
Here is a tutorial with a Google Apps Script script that allows you to view the size of the files in Google Drive in Chart Pie format and modify it.
You can find more tutorials about Google Apps Script on my Google site.
Let's see the source code:
function generateDriveUsageReportPie() {
var drive = DriveApp.getRootFolder();
var files = drive.getFiles();
var data = [['Nume Fișier', 'Dimensiune (KB)']];
while (files.hasNext()) {
var file = files.next();
var fileSizeBytes = file.getSize();
var fileSizeKB = fileSizeBytes / 1024; // Convertim dimensiunea în KB
data.push([file.getName(), fileSizeKB]);
}
// open Google Sheet
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getSheetByName('Drive Usage Report');
if (!sheet) {
sheet = spreadsheet.insertSheet('Drive Usage Report');
}
// clean sheet
sheet.clear();
// write values
sheet.getRange(1, 1, data.length, data[0].length).setValues(data);
// clean charts from Google Sheets
var charts = sheet.getCharts();
for (var i = 0; i < charts.length; i++) {
sheet.removeChart(charts[i]);
}
// create and add the Pie Chart with all values
var chart = sheet.newChart()
.asPieChart()
.setTitle('Utilizare Google Drive')
.addRange(sheet.getRange(2, 1, data.length - 1, 2)) // Exclude header row
.setPosition(5, 1, 0, 0)
.setOption('title', 'Utilizare Google Drive')
.setOption('legend', {position: 'top'})
.build();
sheet.insertChart(chart);
Logger.log('Raport generat cu succes.');
}Here is the result obtained:
Abonați-vă la:
Postări (Atom)