↓
 
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: Excel data shaping fundamentals

Excel Data Shaping Fundamentals VLOOKUP() – What the Function

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

A traditional way of shaping data in Excel is by using the VLOOKUP() function.  After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →

Posted in analytics, economics, education, policy, science, What the Function | Tagged autofill dates, Bureau of Labor and Statistics (BLS), Consumer Price Index (CPI), data transpose, End-arrow keystroke, Excel data shaping fundamentals, HLOOKUP(), INDEX/MATCH(), manual drag and drop, month, numeric date, reshaping data, spot check new values with original, text dates, TEXT(), VLOOKUP(), what the function, XLOOKUP() | 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

Excel Data Shaping Fundamentals File Prep – What the Function

Biomass Rules Posted on May 22, 2025 by Mark JennerMay 26, 2025

The last few months have provided opportunity to flex my spreadsheet skillset.  Excel code and technique seemed to erupt through the keyboard.  In the last few months, diverse datasets have included: 2024 household food expenditures 2024 household power consumption and … Continue reading →

Posted in analytics, definition, economics, macro, policy, science, What the Function | Tagged Bureau of Labor and Statistics (BLS), clean data, Consumer Price Index (CPI), CPI-U, cut and pasting, download file, empowering data skills for skeptics, Excel data shaping fundamentals, file prep, INDEX/MATCH() function, US City Average not seasonally adjusted, VLOOKUP() function, what the function | Leave a reply

Recent Posts

  • Authentic Fun with Arrival of First Copies of My First Book
  • Our Community Loves to Support Our Junior Livestock Show – Secret Life of Rural Communities
  • It is Official. Mark Jenner is a Flaming Nerd.
  • The Legacy Textbook, Principles in Agribusiness Management, is at the Printers!
  • US Producer Age Differs by Farm Enterprise

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.

↑