Difference between revisions of "Monthly Review"
| Line 17: | Line 17: | ||
The result of running that program will be a file, 'tmp.csv'. | The result of running that program will be a file, 'tmp.csv'. | ||
| + | You should then open that file in Excel, as well as the template to be found here: | ||
| + | |||
| + | http://www.nikhef.nl/grid/ndpf/files/11-2011.xlsx | ||
| + | |||
| + | It should be relatively clear where to paste stuff from the tmp.csv file into this template. | ||
| + | Things to watch out for: | ||
| + | * You can't just paste the entire tmp.csv in one go due to the extra REF line (line 21) in the template. | ||
| + | * If a change in the farm capacity occurs during the period covered, you'll need to edit some stuff. This is shown in the example file above. "Old" pledge values have been added by hand in the box at cell D40. These have been used to adjust: | ||
| + | ** the numbers in column D in the first three blocks | ||
| + | ** the data in row 21 | ||
| + | ** the total capacity numbers in column F | ||
| + | |||
| + | The "new" pledge numbers at cell A38 are printed by the script, you'll need to edit this once a year to put in the new pledge numbers. | ||
| − | + | Scroll down a bit further, you can see the pie chart. The data for the chart can be generated by going to the following site: | |
| + | |||
| + | https://www3.egee.cesga.es/gridsite/accounting/CESGA/custom_view.html | ||
| − | + | In the menu at left, select | |
| + | * EGI | ||
| + | * Production | ||
| + | * NGI_NL | ||
| + | * NIKHEF-ELPROD | ||
| − | + | Choose at the top "Norm Sum Elapsed" (HS06-hours). Then choose the same period as above (warning : the dates on this site are inclusive, so choosing end month = 10 gets you data for all of october). Choose then under groupings show data for SITE and group as a function of VO, VO groups select "ALL". | |
| − | + | Finally click "Click here for a csv dump of this table" to get a CSV file; copy that data and paste it into the template sheet. It makes sense to delete a few columns of that csv as well as sorting the columns, in order to get a pretty pie chart. Now you've got the relevant computing plots. | |
| − | |||
| − | |||
| − | + | == Disk numbers == | |
== Remote Consoles and Switches == | == Remote Consoles and Switches == | ||
Revision as of 16:06, 4 November 2011
Background
This page documents how to do assemble the monthly review data for the Tier-1 meeting.
CPU numbers
There is a script which can be used to generate a csv file with the accounting numbers. The script is here: svn+ssh://svn@ndpfsvn.nikhef.nl/repos/pdpsoft/nl.nikhef.ndpf.3maand/
Example invocations:
./3maand.py -p <db passwd here> 2011-08-01 ./3maand.py -p <db passwd here> 2011-08-01 +6m ./3maand.py -p <db passwd here> 2011-08-01 2011-12-05
"2011-08-01" is the start date of the period over which the accounting will be summed. With no end date provided, the default is for a period of three months (the first example). An end date of "+6m" means, sum the accounting over 6 months. The last example shows an explicit end date provided. You can use any dates you like, but the results are only guaranteed if the start date is on the first of the month, as part of the program logic is based on that assumption.
The result of running that program will be a file, 'tmp.csv'. You should then open that file in Excel, as well as the template to be found here:
http://www.nikhef.nl/grid/ndpf/files/11-2011.xlsx
It should be relatively clear where to paste stuff from the tmp.csv file into this template. Things to watch out for:
- You can't just paste the entire tmp.csv in one go due to the extra REF line (line 21) in the template.
- If a change in the farm capacity occurs during the period covered, you'll need to edit some stuff. This is shown in the example file above. "Old" pledge values have been added by hand in the box at cell D40. These have been used to adjust:
- the numbers in column D in the first three blocks
- the data in row 21
- the total capacity numbers in column F
The "new" pledge numbers at cell A38 are printed by the script, you'll need to edit this once a year to put in the new pledge numbers.
Scroll down a bit further, you can see the pie chart. The data for the chart can be generated by going to the following site:
https://www3.egee.cesga.es/gridsite/accounting/CESGA/custom_view.html
In the menu at left, select
- EGI
- Production
- NGI_NL
- NIKHEF-ELPROD
Choose at the top "Norm Sum Elapsed" (HS06-hours). Then choose the same period as above (warning : the dates on this site are inclusive, so choosing end month = 10 gets you data for all of october). Choose then under groupings show data for SITE and group as a function of VO, VO groups select "ALL". Finally click "Click here for a csv dump of this table" to get a CSV file; copy that data and paste it into the template sheet. It makes sense to delete a few columns of that csv as well as sorting the columns, in order to get a pretty pie chart. Now you've got the relevant computing plots.
