↓
 
Biomass Rules

Biomass Rules

Adding Clarity to All Things Bio!

Biomass Rules
  • Home
  • About Biomass Rules
  • Contact Biomass Rules
  • Biomass Links that Rule
  • Everything BIO
  • Bio-Blog

Tag Archives: RIGHT()

Solid Coding using ‘Natural’ Intelligence Suggests Always Start with FRED – What the Function

Biomass Rules Posted on June 5, 2025 by Mark JennerJune 5, 2025

This final lesson on shaping data in Excel is brought to you by the St. Louis Federal Reserve Bank, Federal Reserve Economic Data (FRED) website.  Reviewing the YouTube videos created for this data-shaping exercise, the 4 videos span 45 total … Continue reading →

Posted in analytics, economics, education, macro, policy, science, What the Function | Tagged $ sign anchors, be fierce, be passionate, be smart, Consumer Price Index (CPI), download data, Federal Reserve Economic Data (FRED), INDEX/MATCH(), LEFT(), month, rapid data download, ready-to-use time-series data, RIGHT(), solid coding 'natural' intelligence suggests always start with FRED, St. Louis Federal Reserve Bank, text vs numeric dates, TEXT(), VLOOKUP(), what the function | Leave a reply

Excel Data Shaping Fundamentals Index/Match – What the Function

Biomass Rules Posted on May 30, 2025 by Mark JennerMay 30, 2025

One of the most powerful Excel function tools is the INDEX/MATCH() combination.  It can be set to find specific character strings and deliver the cell contents at the intersection of the row and column string matches. This is the third … Continue reading →

Posted in analytics, economics, education, policy, science, What the Function | Tagged $ sign anchors, Bureau of Labor and Statistics (BLS), Consumer Price Index (CPI), cut and paste, date autofill, Excel data shaping fundamentals, index, INDEX/MATCH(), LEFT(), MATCH(), numeric dates, RIGHT(), shaping data, text dates, VLOOKUP(), what the function, YOUTUBE companion video | Leave a reply

Mining the 2022, Census of Agriculture – What the Function

Biomass Rules Posted on September 5, 2024 by Mark JennerSeptember 5, 2024

The first federal census of agriculture was conducted in 1840.  It has been conducted for 184 years.  The oldest hardcopy of the US Census of Agriculture in the Biomass Rules collection is from 1982.  We have been reading and analyzing … Continue reading →

Posted in analytics, economics, science, What the Function | Tagged 2022 Census of Agriculture, categories, data mining, Excel, IF(), IFNA(), ISBLANK(), LEN, mining the 2022 Census of Agriculture - what the function, nested functions, numeric values, RIGHT(), text string, TEXTBEFORE(), TRIM(), USDA, what the function | Leave a reply

Recent Posts

  • Growing Your Influence by Rob Clark is a Great Resource!
  • Solid Coding using ‘Natural’ Intelligence Suggests Always Start with FRED – What the Function
  • Excel Data Shaping Fundamentals VLOOKUP() – What the Function
  • Excel Data Shaping Fundamentals Index/Match – What the Function
  • Excel Data Shaping Fundamentals Cut and Paste – What the Function

Mark Jenner, PhD
Biomass Rules
Greenville, IL 62246
c. 618.223.9331
e. biomassrules@gmail.com

Linked In Logo for Mark Jenner's Profile including Biomass Rules.com!

Mission Statement:
Providing solutions through the strategic utilization of all kinds of biomass; the development of new markets for food, fiber, and fuels; and streamlining regulations.

bio·mass:
ˈbī-ō-ˌmas. noun. 1 : the unit area or volume of living matter, 2 : plant materials and animal waste used as renewable feedstocks into new processes.

rules:
'rül. 1: noun. 1 : regulations, bylaws or governing procedure, 2: verb. a : to exert control, direction, or influence on, b : to declare authoritatively.

Manure…
is not a four-letter word.

©2024—Biomass Rules—All Rights Reserved.

↑