Dash P&L Spreadsheet

fible1

fible1

Well-known member
Dash Core Group
Masternode Owner/Operator
This is an interesting tool that I have been experimenting lately, and I'd really like to see progressing.

(...)

It is powerful, but sometimes I have problems with it, like when it refuses to update, etc...
 
Last edited by a moderator:
Here is mine, i adjusted it so it can easily be shared. It takes data from two masternodes i selected randomly
(change cel A1 and H1 with sheet tab ''MN data'' to have it reflect your own masternodes).
The colors of cells in column F and some other columns turn red or blue due to two conditionally formatting rules (text contain - is red, text not contain - is blue).
The colors of cells in colom G8-11 turn red or blue due to two conditionally formatting rules with custom formule (=G11<F3 for blue & =G11>F3 for red)

https://docs.google.com/spreadsheets/d/1sk5FG_co27XdaXX9a9t-UL7rAnZ6Itsx-8JKNlzDEEA/edit#gid=0
 
qwizzie said:
Here is mine, i adjusted it so it can easily be shared. It takes data from two masternodes i selected randomly
(change cel A1 and H1 with sheet tab ''MN data'' to have it reflect your own masternodes).
The colors of cells in column F and some other columns turn red or blue due to two conditionally formatting rules (text contain - is red, text not contain - is blue).
The colors of cells in colom G8-11 turn red or blue due to two conditionally formatting rules with custom formule (=G11<F3 for blue & =G11>F3 for red)

https://docs.google.com/spreadsheets/d/1sk5FG_co27XdaXX9a9t-UL7rAnZ6Itsx-8JKNlzDEEA/edit#gid=0
Click to expand...

That is an outstanding spreadsheet!

Could you make it so it can be copied and edited so I can modify it for myself?

:).

Pablo.
 
fible1 said:
That is an outstanding spreadsheet!
Could you make it so it can be copied and edited so I can modify it for myself?
:).
Pablo.
Click to expand...

Done, just make sure if you add any sensitive data it doesnt end up in this shareable spreadsheet but in your own private spreadsheet.
This shareable spreadsheet just has some example information and can be viewed (and now edited) by everyone.

edit : also make sure the formula's are left intact when trying to copy and adjust the formula's accordingly if you are adding more lines in the spreadsheet.
 
Last edited by a moderator:
qwizzie said:
Done, just make sure if you add any sensitive data it doesnt end up in this shareable spreadsheet but in your own private spreadsheet.
This shareable spreadsheet just has some example information and can be viewed by everyone.

edit : also make sure the formula's are left intact when trying to copy and adjust the formula's accordingly if you are adding more lines in the spreadsheet.
Click to expand...

Thank you!

Pablo.
 
qwizzie said:
Here is mine, i adjusted it so it can easily be shared. It takes data from two masternodes i selected randomly
(change cel A1 and H1 with sheet tab ''MN data'' to have it reflect your own masternodes).
The colors of cells in column F and some other columns turn red or blue due to two conditionally formatting rules (text contain - is red, text not contain - is blue).
The colors of cells in colom G8-11 turn red or blue due to two conditionally formatting rules with custom formule (=G11<F3 for blue & =G11>F3 for red)

https://docs.google.com/spreadsheets/d/1sk5FG_co27XdaXX9a9t-UL7rAnZ6Itsx-8JKNlzDEEA/edit#gid=0
Click to expand...
Like I wrote you in the comment in your spreadsheet... it`s a nice peace of work qwizzie
 
The formula for cell F2 was incorrect so i corrected it and i put conditional formatting on cell H2, i put this correction info also in the comments.

I also put in an extra sheet tab with update instructions, these could change with update 0.12 (some will have to go through dash-cli then)

edit : use file - spreadsheet settings to change your timezone if necessary.
 
Last edited by a moderator:
qwizzie said:
Here is mine, i adjusted it so it can easily be shared. It takes data from two masternodes i selected randomly
(change cel A1 and H1 with sheet tab ''MN data'' to have it reflect your own masternodes).
The colors of cells in column F and some other columns turn red or blue due to two conditionally formatting rules (text contain - is red, text not contain - is blue).
The colors of cells in colom G8-11 turn red or blue due to two conditionally formatting rules with custom formule (=G11<F3 for blue & =G11>F3 for red)

https://docs.google.com/spreadsheets/d/1sk5FG_co27XdaXX9a9t-UL7rAnZ6Itsx-8JKNlzDEEA/edit#gid=0
Click to expand...

Very cool, indeed! Thank you! Now I've got something to dissect and learn from... and turn my spreadsheets into something more useful! :wink:
 
I added a refresh button to my personal spreadsheet :

In cell A1 & N1 put following formula :

=IMPORTHTML(ʺhttps://bitcoinwisdom.com/?ʺ& year(now()) & month(now()) & day(now()) & hour(now()) & minute(now()) *10,ʺtableʺ,ʺ0ʺ)

Go to Tools / Script Editor / File / New / Scriptfile and put following code in there :

function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Refresh", functionName: "refresh"} ];
ss.addMenu("Refresh Sheet",menuEntries);// custom menu
};
function refresh() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Exchange Data");
var copyRange = sheet.getRange("N1:N1");
var deleteCell = sheet.getRange("B1:B1");
var deleteRange = sheet.getRange("A1:A1");
var l = sheet.getDataRange().getFormulas().length;
deleteRange.clear();
var pasteRange = sheet.getRange( "A1:A1" );
pasteRange.setFormulas(copyRange.getFormulas());
deleteCell.clear();
};

Save as Refresh.gs, run it and grant permission to use it and voila you have a refresh button located next to the help button
(its called Refresh Sheet)
 
You must log in or register to reply here.
Back
Top