spreadsheets Tag Posts Index

Obscure Life Hack: Filtering Large Excel Spreadsheets By Colour

This is a weird thing I just discovered, so I thought I'd post it just in case it helps someone else. If you use Microsoft Excel, it's possible to filter rows by

Looping Through Cells And Prototyping Ideas In Google Sheets

Post number 11 of “The Practical Google Sheets Guide” These blog posts are part of research I’m doing for a potential new book, hopefully allowing me to further

Getting Started With Forms And Dashboards - Part 2

Post number 10 of “The Practical Google Sheets Guide” These blog posts are part of research I’m doing for a potential new book, hopefully allowing me to further

GHAWG Behind the Scenes: Determining the Proper URL To Use in Posts

Determining the proper URL to use in posts is usually easy, until it isn't. Here's one way I handled it when it wasn't. Cover image is an edited screen capture I

Use Python and Spreadsheets to Determine the best production values for your land

WEN LAND? Wen Land, the players of Splinterlands cried for an eternity. With the advent of the White Paper; a whole bunch of people started to realise that they

Tonight I discovered something sneaky about the SUM() in Excel

It may be this way in programs which are compatible with Excel as well. The thing is that this was done deliberately. For a function as widely known as SUM(), who

Hot off the press at LeoFinance

An XLSref Investigation: Testing Excel's VAR()

Hot off the press at LeoFinance

An XLSref Investigation: Testing Excel's DB()

An XLSref Investigation: Testing Excel's DB()

Did Excel 2003's DB() function have a bug? Who knows? That's why I investigated this for XLSRef (powered by LeoThreads). Images are edited screen captures from either

Showing the math on how many RShares you might get in a season

You've probably seen the news that next season (june) Splinterlands rewards will change. There's a lot of variables at play but i put them in the spreadsheet and

Short Post: Let's Make the First 140 Characters Count!

Unless we're like @taskmaster4450, @edicted, or @bitcoinflood, we only have the 1st 140 characters to get a reader's attention. Let's make the first 140 charactercount!

Navigation Menu for "Spreadsheets for Blogging: The Spreadsheet Behind the D.Buzz Character Count Post Form for Buzzes (and Tweets)"

Below is a table with links to the 3 parts of the post "The Spreadsheet Behind thD.Buzz Character Count Post Form for Buzzes (and Tweets)": PostDateTopics

Spreadsheets for Blogging: The Spreadsheet Behind the D.Buzz Character Count Post Form for Buzzes (and Tweets)-- Part 3

The previous post covered functions and formulas. Normally they are used in the grid that's on screen. However, functions an formulas can be used in a number of

Spreadsheets for Blogging: The Spreadsheet Behind the D.Buzz Character Count Post Form for Buzzes (and Tweets)-- Part 2

The previous post briefly covered simple data values, cosmetic features, and merged cells for data entry; It also went into somedetail on named ranges. So Part 2

Spreadsheets for Blogging: The Spreadsheet Behind the D.Buzz Character Count Post Form for Buzzes (and Tweets)-- Part 1

The previous post in this series introduced the D.Buzz Character Count Post Form. It explained how the spreadsheet-based form works from the point of view of someone

Spreadsheets for Blogging: Introducing the D.Buzz Character Count Post Form for Buzzes (and Tweets)

D.Buzz is Hive's version* of Twitter. Posts on D.Buzz are called buzzes. Both apps impose a character limit on posts; D.Buzz allows 280 characters in the body. At

Spreadsheets for Blogging: How Are Named Ranges Like Nicknames?

Bitcoin's nickname is "The King of Cryptocurrency." Pelé is the alias for Edson Arantes do Nascimento. How are named ranges like nicknames? Just as people

Spreadsheets for Blogging: How Are Some Special Characters Like a Solar Eclipse?

A few years ago there was a solar eclipse. Those are rare events, so when the occur people want to see it. However, it's one of those things we're told never to

## *Hot off the press at LeoFinance:* #### *[Spreadsheets for Blogging ...

Hot off the press at LeoFinance: Spreadsheets for Blogging: How Are Cell References Like Chess Pieces? #dbuzz #excel #spreadsheets #leofinance #hive #pob #cent #crypto

Spreadsheets for Blogging: How Are Cell References Like Chess Pieces?

In Chess, each piece has its own rules for moving on the board. Pawns can move just one square forward at a time. Rooks can move any number of squares in either