Please follow below steps for summary generation.
In the block input sheet go to file—> download —>save as csv
copy the csv file to unix home directory and then copy it mercury area--> /project/mercury/WEEKLY_STATUS
Go to area /project/mercury/WEEKLY_STATUS and run below command
sh run_power_mbit_runtime.sh EN2.1_blocks_status_05022024.csv
It will generate the sheet and you will receive email EN2.1_block_status_05022024.csv.dump.xlsx
upload the .xlsx to the mercury drive
BLR:
\\mixed.inbinas09.ibn.broadcom.net\home\matumulu
\\mixed.inbinas09.ibn.broadcom.net\home\matumulu
LasVegas:
\\mixed.nvlinas83.lvn.broadcom.net\home\matumulu
\\mixed.nvlinas83.lvn.broadcom.net\home\matumulu
########### DEBUG
../weekly_status/blockSummary.pl -i 1.csv.dump -v
EXP:
cat 1.csv.dump
use Spreadsheet::WriteExcel;
use Excel::Writer::XLSX;
#%blockData = () ;
#{<blockName>}->{runDir} = "<absolute path of invs\|avo dir>" ;
#please dont touch the above lines
$blockData{hm_ul}->{runDir} = "/project/mercury/giant/giant-2024.4.1/user/sm067063/PN85.1.dft_iter0/impl/hm_ul/avo.fp2";
$blockData{hm_ul}->{runDir1} = "/project/mercury/giant/giant-2024.4.1/user/sm067063/PN85.1.dft_iter0/impl/hm_ul/invs.no_X1_cells_noulvt";
1;
##################
dos2unix /home/matumulu/mercury/PN85/PN85_block_INPUTS\ -\ Sheet1\ \(13\).csv
FROM MOHIT :
If you are going to create new path groups for your runs then please follow below instructions.
Please create new "Path Groups" in the following manner. So, this way extra path group timing numbers will be consolidated to their Main Path Group Names ( reg2reg, in2reg, reg2out, in2out ) in the generated spreadsheet.
reg2reg :
==> For the new "reg2reg" type of category, create a path group starting with name "r2r_".
==> For the new "reg2mem" type of category, create a path group starting with name "r2m_".
==> For the new "mem2reg" type of category, create a path group starting with name "m2r_".
in2reg :
==> For the new "in2reg" type of category, create a path group starting with the name "i2r_".
reg2out :
==> For the new "reg2out" type of category, create a path group starting with the name "r2o_".
in2out :
==> For the new "in2out" type of category, create a path group starting with the name "i2o_".