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

magnacarta in #hive-167922 • 3 years ago

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)":

Post	Date	Topics Covered
	2022-02-23 @ 5:20pm	Behind the Scenes; Elements; Simple data values; Cosmetic features; Merged cells for data entry; Named Ranges
	2022-02-23 @ 8:54pm	Functions and Formulas
	2022-02-23 @ 9:59pm	Conditional Formatting and Potential Improvements

All Upvotes for this post will be Donated to the Hive Fund

This post is meant to be a navigation tool for anyone who comes here first via search instead of the normal methods.

Since I have to include a beneficiary when I post from LeoFinance, 99.999% of the earnings from any upvotes made for this post will be donated to the Hive Fund and 0.001% to to the @magnacarta account.

Whatever arrives for the @magnacarta account will be diverted to the Hive Fund; I have 7 days to figure out the name for that account.

Posted Using LeoFinance ^Beta

#excel #spreadsheets #leofinance #hive #pob #cent #archon #pal #bht #crypto #bitcoin

3 years ago in #hive-167922 by magnacarta

Sort:

gangstalking 3 years ago

The people doing V2K want me to believe it is this lady @battleaxe Investigate what she has been up to for 5 years. Its the next step to stopping this. Make her prove where she has been for 5 years or where she is now. She is involved deeply with @fystikken and his group. I cant say she is the one directly doing the v2k. Make her prove it. They have tried to kill me and are still trying to kill me. I bet nobody does anything at all. Make @battleaxe prove it. I bet she wont. They want me to believe the v2k in me is being broadcasted from her location. @battleaxe what is your location? https://ecency.com/fyrstikken/@fairandbalanced/i-am-the-only-motherfucker-on-the-internet-pointing-to-a-direct-source-for-voice-to-skull-electronic-terrorism

0.00 VYB

1 vote

[-]

frittro 3 years ago

Wow, this is very cool! I just came across what you've been doing here. I'm very keen on using spreadsheets to assist with my HIVE blogging as well. I mainly use Google Sheets at present, but I intend to move to using Collabora, self-hosted under Nextcloud, on a Raspberry Pi device running the YunoHost distro of Debian GNU/Linux. In fact, that is the main thrust of my own HIVE blog, is setting up my new Raspberry Pi #homelab.

Take a look at what I was doing with spreadsheets on the social blockchain back in 2018. I'm starting to experiment more in this area now that I have returned to the social blockchain this year. I'll definitely be looking through your posts on this subject, to see if there is anything that I can glean from your Micro$oft way of doing things. Thanks for sharing!

Upvoted, Commented & Reblogged.

0.00 VYB

[-]

magnacarta 3 years ago

I see much of your content is related to Steem Monsters. Are you involved with Splinterlands as well? I'm sure many Splinterlands players can benefit from your spreadsheet work and knowledge.

One thing I'd like to do is download blockchain data for my account to a spreadsheet file I can manipulate in various ways. I don't see any tools I can use to do that, and I haven't figured out how to connect to any systems which would allow me to do that. Until then, I'll write about spreadsheets as they relate to bloggers, writers, and the non-tech people out there.

LibreOffice Calc is what I prefer to use for personal use, but on my system it's too slow. That's why I use Excel 2003 instead; recent versions of Excel are overkill for me, and I prefer to stay off-cloud. Once Excel overthrew Lotus 1-2-3 as the King of Spreadsheets, most programs came to copy Excel.

I'm an intermediate spreadsheet user with a focus on alternate uses for spreadsheets: advanced text processing, basic graphics effects, dynamic sorts and lookups. Financial analysis isn't my thing, although I may be doing more of that going forward. I'll teach myself VBA at some point, but for now worksheet functions suit my needs.

The spreadsheet posts are meant to provide enough insight into spreadsheets that the content can be applied to whatever spreadsheet you use. Most people who use spreadsheets use Excel, and even most MS-phobes in their personal lives are required to use Excel professionally.

Most of my knowledge of spreadsheets comes from Excel, but I'm not married to it. I'm opento other spreadsheet programs, although I avoid Google products as much as I can out of principle; Android is as far as I want to go.

Posted Using LeoFinance ^Beta

0.00 VYB

2 votes

[-]

frittro 3 years ago

"Are you involved with Splinterlands as well?"

Kind of. I haven't actually started playing the game myself yet. I have delegated out all of my old Splinterlands cards, and they are being used by someone else, in their bot. I get a share of the Season Rewards for this, so I'm earning a passive income from my cards.

"One thing I'd like to do is download blockchain data for my account to a spreadsheet file I can manipulate in various ways. I don't see any tools I can use to do that, and I haven't figured out how to connect to any systems which would allow me to do that."

There are a couple of ways to achieve this. One is by leveraging the live HIVE API endpoints, as I have been doing up to now. The other is to use HiveSQL to connect from your spreadsheet using something like ODBC. I haven't tried this yet, but it is something that I am very interested in learning more about.

"although I avoid Google products as much as I can out of principle"

Haha, you and I seem to be polar opposites on this issue. I avoid Microsoft products, out of principle. However, I acknowledge that Google isn't much better ethically either. That is why I am moving to self-hosted cloud apps instead.

0.00 VYB

1 vote