---

This is a guide on how to connect an Excel sheet to a blockchain SQL Server , in this case sql.steemsql.com ,and create charts and pivot tables based on it

---

Accesing the Excel data objects it is possible to change the SQL query acording to input parameters from an cell in Excel, from this sheet below it is possible to filter by delegator and delegatee (sorry for heavi gif)

---

---

1 - Create a data source connected to the SQL server o works

We need to create a new data connection inside our Excel

---

We can see more info in this post :https://steemit.com/steemit/@arcange/steemsql-com-how-to-create-a-steem-analytic-report-with-microsoft-excel>

on works...

2-Create the user interface

Import the data as a tablle , chart , or pivot table

3-Set parameters to query database on works

In this workbook we can filter by delegator and delegatee , more options like date are posible

3-Change SQL from Excel macros

This is the code which updates sql to query de database ,its inputs are 2 excel cells

5- Get Excel sample and source code

Sample Excel available below , please allow Excel to Run Macros in order to use it

https://github.com/Devba/StemmDelegatingWorksheet

On works...

Thanks for interesting in this tool. I am working still on the guide below , and hope to have it before going to sleep :)

---

Waiting for your feedback using the Excel , Thanks!