Copy InvoiceTemplate to Personal Gsheet

[lapin7]

Goal: RAM can create an invoice by changing the month of payment
Action: get invoice data from Bounty App to Personal Gsheet.
Budget: $1000
Deadline: 4/1/2018
Restriction: trustable person because of access to private data

Repeated action for 75 collaborators with RAMmain registration

• copy mail address from TAB Form Responses 2 to cell c7
• duplicate TAB "Temp", rename "Copy of Temp" to "T"
• in TAB "T" copy rows 2 to 18 and paste as values
• copy cel c15 TempInvoice
• TAB "Copy to" and paste it in "Or paste a web address here"
• Press OK and go to next email address
• Can this be programmed in a Macro, Script ??

[dckc]

Is there any reason for Operations to do all this make-work for the RAMs at all? Why not just say to RAMs: "grab the InvoiceTemplate and make a copy; fill in the green parts: name, ETH and postal address; when you fill in your github name, watch your rewards flow in from rewards.rchain.coop automatically; save as PDF and submit it."

[lapin7]

Because these fields have also to be on the invoice:

Pers Folder
TempInvoice
Tax form
SoW

And an already filled out form with name, postal address, ETH-address gives less errors.
Probably you don't know how bad people are by filling out forms on their own. Wrong cells, Forgotten cells, Wrong input, etc. That gives me much more work.

So I've chosen to do it like this.

p.s. I didn't mean to close this issue at all. Who is the genius who put the "close and comment" button right next to "comment" with no way to undo?

[lapin7]

But let's try your suggestion as well.

• Go to your personal temporary invoice
• Copy the url link to your personal temporary invoice
• Go to InvoiceTemplate
• Click on the TAB Temp and select "Copy to" and paste the url in "Or paste a web address here"
• in your own spreadsheet rename the copied sheet from "Copy Temp" to "Temp"
• fill out the green parts
• enter: your Name, Postal Address, Country, GithubName, Email-address, ETH-address
• copy from previous invoices the cells below and paste them in:
• url link to personal folder
• url link to temporary invoice
• url link to tax form
• url link to statement of work
• now you can see your rewards flow in from rewards.rchain.coop automatically
• download as PDF
• mail it to ops@rchain.coop for verification

[dckc]

I can't figure out why you're doing anything related to the monster Pub Bounties at all any more. I guess I don't know why Pers Folder nor TempInvoice belongs on the invoice.

Part of me says: it doesn't bother me if you want to do a bunch of extra work. But it does bother me. It means I get paid slower. (We all do.) But I guess I'll let it go, for now.

[lapin7]

You’re right I’m in a kind of tunnel view. We’ve to rethink the payment process. The biggest bottleneck is elsewhere.

[lapin7]

The links don’t point to pub bounty anymore BTW

[makys]

Hi @lapin7 , I just requested access so I can help with this.

[dckc]

In #260 @lapin7 writes:

But how and when can Ops manager set the next pay period?

Just say the word and I'll issue the sql update ... statement. (As I said in #477, IOU a web page so you can do it.) My current understanding is that you want to switch on April 8.

[jasoncruzzy]

Hello @lapin7 i would like to be a collaborator on RChain

[Ojimadu]

@jasoncruzzy Send a request to join rchain@googlegroups.com, afterwards you will receive an invitation to collaborate on github.

[lapin7]

@dckc please freeze March now. And begin new period April

[ChloeCoul]

Je dois faire quelque chose ? Le vendredi 30 mars 2018, HJ Hilbolling <notifications@github.com> a écrit :

…

Assigned #563 <#563> to @ChloeCoul <https://github.com/ChloeCoul>. — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub <#563 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Ahx7B7akrEXQtZWdQo7lzAu9Rp5xwCCWks5tjjhOgaJpZM4TBtqp> .

[dckc]

@dckc please freeze March now.

OK; I updated the current pay period.

I haven't finished with the bug where you can still edit votes from pay periods that are not current.

[dckc]

oops... that didn't work well... now the budget and reward views are empty... let me roll back until I fix those views.

[dckc]

ok... "Current pay period: 2018-04-01" but the reward and budget tabs still show March as well.

• bdd8a60 issue_budget: don't constrain to current pay period

[dckc]

OK, March is really locked:

• ca19b85 dbr_triggers: only current vote changes allowed

[Ojimadu]

Send me message on discord or Telegram @OjimaduChidindu

[lapin7]

@michaelizer

• I've created template invoice "Temp" in your spreadsheet https://docs.google.com/spreadsheets/d/1UoiyExSW7V4tAFwvIAsml1hWfz_fXZEiWvwNr3ZN1hw/edit#gid=393433963&range=D1
• a TempPD is meant for updates of the template
  https://docs.google.com/spreadsheets/d/1UoiyExSW7V4tAFwvIAsml1hWfz_fXZEiWvwNr3ZN1hw/edit#gid=820941464&range=A1:G17
• and a PD is As Value-copy/paste of your TempPD for personal data https://docs.google.com/spreadsheets/d/1UoiyExSW7V4tAFwvIAsml1hWfz_fXZEiWvwNr3ZN1hw/edit#gid=241191986&range=A1
• the Temp copies data from PD
• each month the invoice is automatically filled out through a connection with our bounty app https://rewards.rchain.coop/
• the current month is frozen and a new month starts at the 7th of the month
• after the 8 of the month you can transmit the invoice through form Declaration
• For your invoice of Feb, please send your ETH address, invoice PDF, discord name to ops@rchain.coop.
• Read about our decentralized bounty system.
• Watch RChain's collaboration and bounty app animated explainer video
• fill out a w8
  • w8 instructions
• or w9
  • w9 instructions

[lapin7]

@dckc
If possible, I would like a query that delivers this result (in a temporary table):

• Period
• Worker
• Issues (all issues that the worker worked on)
• USD (total of the rewards of issues)
• RHOC (USD converted to RHOC, default is 1:1)

A table that contains the rhoc_price of the month

pay_period	month	rate
20170801	August	$ 0.100
20170901	September	$ 0.200
20171001	October	$ 0.200
20171101	November	$ 0.200
20171201	December	$ 0.200
20180101	January	$ 0.200
20180201	February	$ 1.170
20180301	March	$ 1.250
20180401	April	$ 1.138
20180501	May	$ - .0
20180601	June	$ - .0
20180701	July	$ - .0
20180801	August	$ - .0
20180901	September	$ - .0
20181001	October	$ - .0
20181101	November	$ - .0
20181201	December	$ - .0

[dckc]

like this?

• invoice_summary tab
  • CSV export

[lapin7]

Exactly :-)
That replaces my tedious spreadsheet for a part.
What's the query?
I know some sql but have to get it up to date again.

[dckc]

I haven't checked this in yet, but the code is:

create or replace view invoice_summary as
  select pay_period, worker
, group_concat(issue_num separator ', ') as issues
, sum(reward_usd) USD
, sum(reward_usd) * rate RHOC
from reward r
join pay_period pp on pp.start_date = r.pay_period
where r.reward_usd > 0
group by r.pay_period, r.worker;

[dckc]

I fixed the computation of RHOC to use usd / rate rather than usd * rate and checked it in:

• d731413 invoice_summary - reward by worker, pay period

[dckc]

reward was paid in 201804

[allancto]

@dckc thanks for your work/ contribution on this. I've had the pleasure of working with your tools and you did an awesome job. -@allancto