Tidy up the dynamic process table

[shawnbot]

The dynamic process table in #1454 is a little funky, style-wise. I defer to @ericronne, but here are some of my observations, referencing @gemfarmer's screenshot below:

1. The text in the arrow headings should line up with the cells below: "Phase" with "All commodities" and "Oil and Gas"; "Securing a lease" with dollar figures and bars; et al.
2. I think that the vertical padding in the white cells is way too high, especially in the Oil & Gas row.
3. Should we change the color of the bars to be less heavy?
4. I agree that the row borders in each commodity "sub-table" could be improved, maybe with dashes?

[shawnbot]

Whoops, submitted too soon; editing...

[coreycaitlin]

Picking up conversation here (lots of updates in #1348, but it's getting looooong).

Eric's latest design is here

We talked today and determined that we needed to update the language in the chart to do a few things:

• Make the phases clearer and easier to understand by moving some of the explanation up to the phase header
• Add explanations of geothermal rates, per #1474

In the process of drafting content, I discovered some other needs:

• We didn't have explanations for solar, onshore wind, or offshore wind revenues
• Surface and subsurface coal rates only differ at the royalties stage, so we don't need to repeat the other stages

Here's my working draft, in messy visual form:

...I'll post a separate comment with this content in table form for ease of copy/pasting.

[coreycaitlin]

Commodity	Phases of production
	Securing rights Companies pay bonuses or other fees to secure rights to resources on federal land	Before production Companies pay rent on federal land while exploring for resources	During production Companies pay royalties after production begins
Oil and Gas
Onshore	Bonus: The amount offered by the highest bidder	$1.50 annual rent per acre for 5 years $2 annual rent per acre thereafter	12.5% of production value
Offshore	Bonus: The amount offered by the highest bidder	$7 or $11 annual rent per acre, increasing over time up to $44 per acre in some cases	12.5%, 16.67%, or 18.75% of production value
Coal
	Bonus: The amount offered by the highest bidder	$3 annual rent per acre	Surface mining: 12.5% of production value + $0.28 per ton in AML fees Subsurface mining: 8% of production value + $0.12 per ton in AML fees
Hardrock minerals*
Acquired lands	$6,500 prospecting permit fee	$37 annual rent per acre + $0.50 annual prospecting fee per acre	Royalty rates are determined by leasing officers on an individual case basis (no minimums apply)
Renewable energy
Geothermal energy: Competitive leasing	Nomination fees: $110 per nomination + $0.11 per acre Lease: Winning bid amount + $155 competitive lease processing fee	$2 per acre for one year $3 annual rent per acre for 2nd-10th years $5 annual rent per acre thereafter	?????
Geothermal energy: Noncompetitive leasing	Lease: $400 payment	$1 annual rent per acre for 10 years $5 annual rent per acre thereafter	?????
Solar energy	Bonus: The amount offered by the highest bidder	Rent determined by acreage and land value	Proposed: $6.21 per kilowatt in Megawatt Capacity fees
Onshore wind energy	Bonus: The amount offered by the highest bidder	Rent determined by acreage and land value	Proposed: $3.55-$5.32 per kilowatt in Megawatt Capacity fees
Offshore wind energy	Bonus (if competitive bid): The amount offered by the highest bidder Acquisition fee (if noncompetitive bid): $0.25 per acre	$3 annual rent per acre	2% of anticipated value in operating fees (unless otherwise specified or waived)

Other revenue streams:

• Corporate income tax: C-corporations pay income tax to the IRS, and rates can range from 15-35% depending on company revenue.
• * Hardrock mining that takes place on public domain lands, which are managed by the Bureau of Land Management, occurs through the claim-staking process. These fees are not included here, because that dataset does not have state-level data. [Learn more about the claim-staking process] or [see revenue by company, which includes those fees].

[coreycaitlin]

If possible, it'd be great to only show offshore rates on offshore area profile pages.

[coreycaitlin]

We also need to clarify which rents are only paid during the exploration phase and which continue being paid after production begins.

[meiqimichelle]

@coreycaitlin @ericronne what's the latest here? Is there a version of the mega-chart that's right for the MVP that we can have @gemfarmer implement before he leaves us for camping? ;)

[ericronne]

Let's see what the next hour or two yield, stay tuned ...

[gemfarmer]

👍

[coreycaitlin]

I changed the HTML version of the chart to fill in some of the gaps ^^

• Moved BLM hardrock to a footnote, because that data isn't in this chart
• Added a footnote about corp income tax

Still to-do:

• [x] Write explanations for "other" revenue
• [x] Incorporate notes from Herb once we get them

[meiqimichelle]

@ericronne ping :) What's yer latest?

[ericronne]

@meiqimichelle the latest design puts this as the third tab in the commodity revenues megachart (invision prototype here). And as we discussed yesterday with @coreycaitlin and @gemfarmer, perhaps we will kill the totals tab. Test it?

[ericronne]

@coreycaitlin's content is not reflected here (tab 3), but if she and @meiqimichelle give this the thumbs up, i think we can call it MVP-worthy...

Invision prototype

Remember to use the invision comments tool if you wish!

[meiqimichelle]

Next step: @gemfarmer @coreycaitlin and @meiqimichelle to pair and split tasks to implement.

[coreycaitlin]

Content with revisions from the experts at ONRR:

Commodity	Phases of production
	Securing rights Companies pay bonuses or other fees to secure rights to resources on federal land	Before production Companies pay rent on federal land while exploring for resources	During production Companies pay royalties after production begins	Other revenue Minimum or estimated royalties, settlements, and interest payments
Oil and Gas
Onshore	Bonus: The amount offered by the highest bidder	$1.50 annual rent per acre for 5 years $2 annual rent per acre thereafter	12.5% of production value
Offshore	Bonus: The amount offered by the highest bidder	$7 or $11 annual rent per acre, increasing over time up to $44 per acre in some cases	12.5%, 16.67%, or 18.75% of production value
Coal
	Bonus: The amount offered by the highest bidder	$3 annual rent per acre	Surface mining: 12.5% of production value + $0.28 per ton in AML fees Subsurface mining: 8% of production value + $0.12 per ton in AML fees
Hardrock minerals*
Acquired lands	$6,500 prospecting permit fee	$37 annual rent per acre + $0.50 annual prospecting fee per acre	Royalty rates are determined by leasing officers on an individual case basis (no minimums apply)
Renewable energy
Geothermal energy: Competitive leasing	Nomination fee: $110 per nomination + $0.11 per acre Bonus: The amount offered by the highest bidder $160 processing fee	$2 per acre for the first year $3 annual rent per acre for years 2-10 $5 annual rent per acre thereafter	If selling electricity: 1.75% of gross proceeds for the first 10 years of production, then 3.5% of gross proceeds If selling geothermal resources for third-party electricity generation: 10% of gross proceeds from sales contract multiplied by the lease royalty rate (usually 10%) ***
Geothermal energy: Noncompetitive leasing	Lease: $410 payment	$1 annual rent per acre for 10 years $5 annual rent per acre thereafter	If selling electricity: 1.75% of gross proceeds for the first 10 years of production, then 3.5% of gross proceeds If selling geothermal resources for third-party electricity generation: 10% of gross proceeds from sales contract multiplied by the lease royalty rate (usually 10%) ***
Solar energy	Bonus: The amount offered by the highest bidder	Rent determined by acreage and land value	Proposed: $6.21 per kilowatt in Megawatt Capacity fees
Onshore wind energy	Bonus: The amount offered by the highest bidder	Rent determined by acreage and land value	Proposed: $3.55-$5.32 per kilowatt in Megawatt Capacity fees
Offshore wind energy	Bonus (if competitive bid): The amount offered by the highest bidder Acquisition fee (if noncompetitive bid): $0.25 per acre	$3 annual rent per acre	2% of anticipated value in operating fees (unless otherwise specified or waived)

*\ For leases signed before the Energy Policy Act of 2005: The lessee’s reasonable actual transmission and generation costs are deducted from gross proceeds from electricity sales, and the resulting value is multiplied by the lease royalty rate (usually 10%); for direct use, the lessee pays the equivalent value of least expensive, reasonable alternative energy source. Thermal energy utilized must be measured by lessee at the inlet and outlet of facility. The resulting value is multiplied by the lease royalty rate of 10%.

Other revenue streams:

• Corporate income tax: C-corporations pay income tax to the IRS, and rates can range from 15-35% depending on company revenue.
• * Hardrock mining that takes place on public domain lands, which are managed by the Bureau of Land Management, occurs through the claim-staking process. These fees are not included here, because that dataset does not have state-level data. [Learn more about the claim-staking process] or [see revenue by company, which includes those fees].

[ericronne]

Invision prototype

[meiqimichelle]

Let's break this out into the remaining separate issues. Which are:

• [x] Solar and wind need to be incorporated -- mayeb need to address something in the data to make this happen. --> #1558
• [x] Further match table mock --> #1559

[meiqimichelle]

Remaining issues moved to separate homes. Closing!