— VerifyYourBrain

frittro in #excel • 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.

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

3 years ago in #excel by frittro

0.00 VYB

Sort:

Trending

[-]

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