liskjp
Posts: 4
Joined: Wed Nov 30, 2016 10:58 am

liskjp - CheckLiskVote by Excel VBA

Thu Jan 05, 2017 10:44 pm

1. Please input NodeName to cell "B2" of Sheet“Vote”

2. "Alt + F8", Run macro "CheckLiskVote"

Image
Image
Image

*** you can complete Sheet"Data", then Run Macro ***
Image

3. If you want Renew data of nodeNameSheet, you can Run macro "RenewNodeSheet"

4. added new Function
1)Function Name: GetBalanceByAddress(), get balance by Address of LISK
Usage: "=GetBalanceByAddress(address)"

2)Function Name: GetForgedAmountByNodeName() , get ForgedAmount by NodeName of LISK
Usage: "=GetForgedAmountByNodeName(NodeName)"

3)Function Name: GetAddressByNodeName() , get Address by NodeName of LISK
Usage: "=GetAddressByNodeName(NodeName)"

4)Function Name: GetPublicKeyByNodeName() , get publicKey by NodeName of LISK
Usage: "=GetPublicKeyByNodeName(NodeName)"

5)Function Name: GetRankByNodeName() , get Rank by NodeName of LISK
Usage: "=GetRankByNodeName(NodeName)"

6)Function Name: GetApprovalByNodeName() , get Approval by NodeName of LISK
Usage: "=GetApprovalByNodeName(NodeName)"

7)Function Name: GetProductivityByNodeName() , get Productivity by NodeName of LISK
Usage: "=GetProductivityByNodeName(NodeName)"

8)Function Name: GetProducedblocksByNodeName() , get Producedblocks by NodeName of LISK
Usage: "=GetProducedblocksByNodeName(NodeName)"

9)Function Name: GetMissedblocksByNodeName() , get Missedblocks by NodeName of LISK
Usage: "=GetMissedblocksByNodeName(NodeName)"

Image

Download Address: http://lisk.jp/download/CheckLiskVote.xlsm

Provided by liskjp
Donation Address: 4402625644334434270L
Last edited by liskjp on Sun Jan 08, 2017 1:18 pm, edited 2 times in total.

User avatar
Forrest01
Lisker
Posts: 55
Joined: Mon Apr 04, 2016 7:52 pm

Re: liskjp - CheckLiskVote by Excel VBA

Fri Jan 06, 2017 7:59 am

Very useful tool, thanks liskjp :)
========================== Forrest node details : ==========================
Mainnet node |•| Delegate Proposal |•| Transparency Report |•| Testnet node

User avatar
LiskPro.com
Lisker
Posts: 37
Joined: Fri Jun 16, 2017 3:26 pm
Location: Beglium
Contact: Website

Re: liskjp - CheckLiskVote by Excel VBA

Tue Jul 04, 2017 11:02 am

Hi !

The dowload link seems to be down. Could you PM me the DL link ?

Thank you !
LiskPro.com - RobinHood pool - Support us !

Return to “Delegates”

Who is online

Users browsing this forum: No registered users and 1 guest