Author

Topic: My spreadsheet for the bounty (Read 264 times)

newbie
Activity: 31
Merit: 0
May 12, 2018, 04:14:40 PM
#3
Thanks!
newbie
Activity: 108
Merit: 0
April 30, 2018, 01:23:31 AM
#2
Thanks for sharing, this is very useful.
Anyway for the bounty date, is it the bounty manager  will recognize the date based on GMT+0 ?
Currently I live in GMT+7 so do I need to follow my timezone or GMT+0 ?

Thanks in advance...
copper member
Activity: 168
Merit: 34
March 21, 2018, 12:49:56 AM
#1
My spreadsheet for bounty campaign if a help you.   Grin Grin
In the spreadsheet there is a script
script code
Code:
function CopyTwitter ()
{
 var sourceSheet  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bounty");
 var destSheet  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Report");
 var rangesToClear = ['A19:J22'];
  for (var i=0; i  {
      destSheet.getRange(rangesToClear[i]).clearContent();
  }
      sourceSheet.getActiveRange().copyTo(destSheet.getRange("A20"), {contentsOnly:true});
 var range = sourceSheet.getActiveRange();
      range.clear({ contentsOnly: true });
}

function CopyTwitterDate ()
{
 var sourceSheet  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bounty");
 var destSheet  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Report");
 var rangesToClear = ['A19:J22'];
  for (var i=0; i  {
      destSheet.getRange(rangesToClear[i]).clearContent();
  }
      sourceSheet.getActiveRange().copyTo(destSheet.getRange("A19"), {contentsOnly:true});

 var range = sourceSheet.getActiveRange();
      range.clear({ contentsOnly: true });
}

link on spreadsheet (https://docs.google.com/spreadsheets/d/1HL_5cj2suUxfgHSQbgBR8uxIiunem6e526d55Dw8WV4/edit?usp=sharing)


General view of spreadsheet




1. Today's date (automatically changed). time zone GMT + 00:00
2. Day of the week (automatically changed).
3. The name of the bounty campaign (link to bitcointalk description about bounty)
4. Where to submit a report (on bitcointalk, in the form of google, a report in one message on bitcointalk, on a third-party site (URL link)).
5. Shows information about today's work (Work changes automatically).
6. Information about the number of the week in bounty campaign.
7. When the date of the report appears, the Report information means you need to submit the report today (Report changes automatically).
8. Comments about bounty campaign, a summary of how many retweets or tweets you need, whether hashtag, etc.
9. In these cells, we specify the date when the first week ends, the second, the third, depending on how much the bounty campaign is and on what week we entered (Fill required!!!!! when adding a new campaign bounty, if no information is added, the report reminder will not work) (filled in manually).
10. Creates a report of the tweets and retweets
11. Creates a report with Date, tweets and retweets (Date if need Is filled manually, depends on the form of the campaign bounty report)
12. In this line reTwitter, we specify how much and when we need to make retweets. String Twitter by analogy with reTwitter.
13. Twitter URL, reTwit URL to save links for report generation. Link to or retweet a tweet you want to insert in your cell when you made a retweet or a tweet.

More information on video, as working my spreadsheet



https://youtu.be/HY4B4Spg3_I
link on spreadsheet (https://docs.google.com/spreadsheets/d/1HL_5cj2suUxfgHSQbgBR8uxIiunem6e526d55Dw8WV4/edit?usp=sharing)
 
Avatar
 
Jump to: