Google sheet for calculating payments on Tezos-Babylon using Baking Bad API

Tez Baker
4 min readOct 19, 2019

A number of bakers have been having issues generating their payments since TZ Scan no longer supports Tezos. We have updated our google sheet to use the awesome Baking Bad API who have stepped up to the plate. This spreadsheet will be ideal for smaller bakers who need a stop gap so they can continue to pay their delegates.

You can find the spreadsheet here and you will need to make a copy to run the rewards:

https://docs.google.com/spreadsheets/d/1scqNd9tM5iEkd2M-_pCTx5OGy1hNvvouDSXqDjdQn2s/edit#gid=0

The spreadsheet is driven by the following fields:

Start and End Cycle Rewards — Go and get rewards between for these cycles (_rewards sheet)

Start and End Cycle Payments — Go and get the rewards for each delegate and compute the payment amount (_cycle payments sheet)

Default Fee — If a fee has not been specified for an address then use this default fee

Baker Address — The baker address that rewards will be calculated

Payment Address — This address is used to create the Tezos command (k column on _cycle payments sheet). With the Babylon release this address must now be a tz account as kt addresses are now smart contracts.

--

--

Tez Baker

A Tezos Baker… We Stake, You Make. Earn interest on your Tezos crypto-currency. Offering a secure delegate service for Tezos, distributing rewards every cycle.