RE: Gridcoin weekly project update - 05/Mar/18

You are viewing a single comment's thread from:

Gridcoin weekly project update - 05/Mar/18

in gridcoin •  7 years ago  (edited)

Do you create all those plots in Excel by hand, or do you have a VBA script to generate them for you?

gridcoin
7 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    3
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!
    Sort Order:  
  • Trending
    • [-]
      ·  7 years ago (edited)

    Thank you for asking @jarric, I have setup the Excel file charts as standard templates and re-use them every week. Since I don’t use https://www.gridcoinstats.eu/ anymore to extract GRC information, I now add new data-points using this semi-automatic approach:

    1. Using Autoit and wget extract data points from https://boincstats.com for the RAC information (team RAC and overall project RAC)
    2. Manually extract USD/GRC value from https://coinmarketcap.com/currencies/gridcoin/
    3. Manually transfer data points to Excel to generate the week charts info per project
    4. Use a Pivot table to align the output to make it usable for the Excel file charts
    5. Use a macro in Excel (VBA) to extent the time-line with one week

    I won't say this it is an easy way but it does the trick without too much effort. :)

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      2 votes
      [-]
        ·  7 years ago (edited)

      Thank you for response.

      Why not use their API to extract JSON with Gridcoin data? It might prove easier and faster, as you can write a simple script in any programming language.

      ///EDIT: It might be also reuseable!

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.02
      • Past Payouts $0.02
      • - Author $0.02
      • - Curators $0.00
      1 vote
      [-]
        ·  7 years ago 

      Thanks for the suggestion and probably you're right. One more thing to add to the list. :)

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.00
        1 vote