url: pptxhandler/table: pattern: /$YAMLURL/output.pptx handler: PPTXHandler kwargs: version: 2 source: $YAMLPATH/template.pptx data: sales: url: $YAMLPATH/sales.csv transform: > data.insert(3, 'Bar 2018', data['FY2018']) or data.insert(5, 'Bar 2017', data['FY2017']) or data.insert(6, 'Growth', data['FY2018'] / data['FY2017'] - 1) or data rules: - Sales Table: table: data: sales vertical-align: f'middle' font-size: f'11 pt' header-row: - Name - Indication - '

FY2018

' - "" - '

FY2017

' - "" - '

Growth

' text: Name: cell.val Indication: cell.val FY2018: f'

{cell.val:,d}

' Bar 2018: f'' + ('█' * int(cell.val / 1000)) + '' FY2017: f'

{cell.val:,d}

' Bar 2017: f'' + ('█' * int(cell.val / 1000)) + '' Growth: f'

{cell.val:.1%} ' + ('' if cell.val < 0 else '') + '

' width: Name: 1 Indication: 2.5 FY2018: 1 Bar 2018: 1.5 FY2017: 1 Bar 2017: 1.5 Growth: 1