Downloads

These files ship with the site. Save them and adapt the names to your model. The shared sample data comes first. After that, each group links to the note its files belong to, and the same buttons appear in that note.

Sample data

The shared sample tables and their Snowflake load script, used in Plan vs actuals, Snowflake to Jedox load, Relational extracts and Automated value emails.

Download dim_account.csv Download dim_cost_center.csv

Download fact_actuals.csv

(610 rows)

Download fact_budget.csv Download load_snowflake.sql

Month-end actuals

Download gl_actuals_pnl.sql

Plan vs actuals

Download plan_vs_actual.sql

Management report export

Download mgmt_report_export_sample.csv

Relational extracts

Download v_fact_actuals.sql Download relational_extract_actuals.sql

Download v_jedox_actuals_by_group.sql

(optional view)

Download query_history_lookup.sql

Automated value emails

Download send_value_emails.groovy Download email-template.html Download recipients.csv

Month-close checks

Download FPNA_MonthCloseChecks.bas

New Outlook email macros

Download SendOrSave.bas

Larger workbooks and Jedox exports are added as they are ready. Downloads are counted per file with GoatCounter, which doesn't use cookies.