#Excel
Been busy working on updating our #ApacheSpark #Excel data source reader to support Spark 3.4
FileSourceOptions and SparkPath throwing up some changes needed, but prompted a rewrite of the options class which was needed anyway. Unit tests are all passing now for Spark 3.0.1 up to 3.4.0 which is good, now for some manual testing on #Databricks and #AzureSynapse
Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features. #Excel #Dummies #Free https://neow.in/M2tranNi
📢 Data Pros! 🚀 Exporting data to Excel in R? Don't forget file size output! 📊💡 It boosts efficiency, saves resources, and optimizes network transfer. Check my latest blog for details! #DataManagement #Excel #Optimization
Post: https://www.spsanderson.com/steveondata/posts/2023-05-26/
If you ever feel stupid, just remember that #excel and other spreadsheet programs localize functions. Aka "=ROW()" in english is "=ZEILE()" in German. And I hate everything about it.
Let me quickly google what function to use before having to fking translate it (I could change the language of the program ofc. OR NOT because my company will yell at me if I do. Amazing)
Dear Microsoft
If Excel knows that I'm missing a parentheses at the end of my formula, JUST ADD IT!!
Hoja de Calculo #excel Inventario de Finca ganadera Venezolana ➡️ https://bit.ly/3fkIhzT ⬅️ #economia #administracion #agronomia #inventario #Contabilidad #agricola #cienciasagrarias #fcagrarias pic.twitter.com/9e6tUT3EAr, #UDELAR #Uruguay #UDV #Guatemala
@niconiconi Shit like this is why I don't use #Excel... Basically everything in the #MicrosoftOffice package is Turing-Complete!
Ich suche (#FediHire) eine/n Mid-Level #Developer, der/die verschiedenste Aufgabenstellungen und Sprachen anfassen kann. Es gibt kleine Scripting- und Software-Projekte in #pyhton, #powershell, #bash, #php, #sql, #javascript, usw. Darüber hinaus brauchen wir häufig API-Connectoren zu Netzwerk- und Security-Produkten, die meist mit #xml (z.B. für SIEM-Themen) und #json (z.B. für Automatisierungen) als Austauschformat nutzen. Fokus-Hersteller sind #ExtremeNetworks und #Fortinet. Interne Tools gibt es u.a. mit #Excel #Macros (#vba / #dotNET). Also wirklich vielfältige größere und kleine Projekte...
Meine Kollegin/Mein Kollege sollte also strukturiert und mit Planung an Projekte herangehen können, anstatt, wie aktuell die Projekte laufen "jede/r, der/die ein bisschen Scripten kann, schreibt irgendwie irgendwas, was niemand anderes mehr brauchbar nutzen kann".
#Vollzeit oder #Teilzeit, #Deutschland (Hauptstandort #Pforzheim), zu großem Prozentsatz #remote möglich.
#Jobs #FediJobs #getFediHired
(Details zur Firma im übergeordneten Toot)
Huh, today I learned something new about #Excel. Apparently it only supports numbers up to 15 digits. Any digits you include over 15 will be changed to a 0. Only way to get it to show properly is to change it to be formatted as text.
5 different people at work looked at this spreadsheet before I did and couldn't figure it out.
I just googled "why is excel rounding big numbers when I don't want it to" and got the answer and solution within 2 minutes.
My current #coding nightmare :
Having to rewrite a legacy #VB 2010 function that's over 1300 lines long with over 1000 lines of calculations and chock full o' #random number generations in #python
Bonus : code was written over 25 years ago almost completely "lifted and shifted" from #Excel VBA to its current home
..and while this is the ugliest of the functions, there's about 20 overall...
This is gonna be some fuuuunnnn #code to rewrite and #audit.. 😬
📊 Did you know that PowerPoint can do more than just create slides? 🎉✨
📈 Today, I want to share a potentially game-changing tip with you! Have you ever considered creating your charts directly in PowerPoint instead of Excel and copying them over? 🤔💡
🔢 No need to switch between multiple software programs or use multiple files. By harnessing PowerPoint's charting capabilities, you can save time⏰ and streamline your workflow. Plus, it's an excellent way to keep all your presentation elements in one place and makes collaboration even easier! 🙌🌟
🎥 I've created a short video tutorial where I walk through these tips and tricks. 🎬
🔗 https://youtu.be/ycyySK5bdRg
Don't forget to #boost and share this post with your connections who want to level up their presentation game!
#VisualizeData #PresentationTips #DataVisualization #LinkedIn #PresentationSkills #DataAnalysis #PowerPointHacks #ProfessionalDevelopment #BusinessTips #PowerPoint #Excel
Multi-row dependent drop downs are not easy to create… or are they?
Here I use just 3 easy to understand formulas to deliver exactly what people need in the simplest to implement and understand solution I’ve seen.
Let me know what you think
At work, I use spreadsheets almost all of the time. Generally, Google Sheets is my go to and it is the one that I'm most comfortable with. It works well every time and I never have a complaint.
However I am working on a new project that requires me to dust off Excel and about 30 minutes into using, guess what happens? Yep, it crashes and I lose my work that I had been working on for the last hour.
Thank you Microsoft for the experience. :|
#microsoft #Google #GoogleSheets #Excel #IT #tech #spreadsheet
How could I miss out on #VisiData for so long? This might become my new favorite #CLI tool.
If you do _anything_ with data and enjoy working in the terminal, check it out. It can
• provide a #TUI for viewing and editing data in #CSV, #Excel, #SQLite, #JSON, #YAML & #XML files and quite a few more
• sort, filter, join and edit that data, across files and across formats
• convert between the formats (interactively or not)
• record & play macros
• be scripted in #Python
@emilynordmann https://depictdatastudio.com/category/data-visualization-in-excel/
https://stephanieevergreen.com/?s=excel (and https://stephanieevergreen.com/how-to/)
https://policyviz.com/?s=excel
https://www.storytellingwithdata.com/blog/what-clutter-can-we-eliminate (many others on this site; this is just one example)
There are more, but these are great resources to start with.
Another resource: me and the courses on exactly this (#Excel #DataViz) I teach 😁
If you hand me a #spreadsheet of 5000 rows, where every other row remains empty and truncated to 5 pixels "for padding", I am genuinely concerned over your well-being. #data #dataprocessing #excel
Why the heck is it so complicated to have cells with check boxes in them in Excel? Am I crazy? Are we really in 2023?
FevaWorks 三大免費 Excel 應用工作坊 善用全方位技能提升工作效率
Excel 對於不少普通人來說，可能只是用作紀錄數據的文書軟件，但大家又是否知道，如果善用運動 Excel 當 […]
The post FevaWorks 三大免費 Excel 應用工作坊 善用全方位技能提升工作效率 appeared first on 香港 unwire.hk 玩生活．樂科技.
#生活科技 #Excel #fevaworks
https://unwire.hk/2023/05/17/fevaworks-excel-workshop-may2023/life-tech/?utm_source=rss&utm_medium=rss&utm_campaign=fevaworks-excel-workshop-may2023
Nueva entrada en el blog:
Planes de #aceptación unilaterales por variables con #Julia, #R y hoja de cálculo (#excel y #libreoffice)
https://runjaj.quarto.pub/posts/muestreo_variables/
(Me hace ilusión poder hacer un toot como este 😃.)
Hoja de Calculo #Excel para calcular el Balance Hídrico ➡️https://goo.gl/Tbc6Pa⬅️ #Clima #agronomia #Climatologia #fao #agronomo #fagro #cienciasAgraria #fcagrarias #fca #fcagricolas #Inegieria pic.twitter.com/4WTsY60QfG , #Guatemala #Nicaragua #Paraguay
FsExcel now supports generating Excel tables! https://github.com/misterspeedy/FsExcel/blob/main/ExcelTableTutorial.md
Ich freue mich sehr, dass mein über 15 Jahre altes Excel noch so begeistern kann. Ich habe mich dazu mal mit ChatGPT unterhalten und wir sind einer Meinung: Excel als OPuLi ist soooo 90er ;o) - aber manchmal eben immer noch die einfachste Lösung. Lieber Excel, als gar keine OPuLi!
#Projektmanagement #Projektmanagementtools #Selbstorganisation #opuli #opl #lop #excel #chatgpt
https://www.linkedin.com/feed/update/urn%3Ali%3Aactivity%3A7063896261942251520/
"Another Classic of the classics.xlsx" 😂🤓
Converting an Excel spreadsheet into an org-table:
https://vivereverde.blogspot.com/2023/05/Sistemando-l-orto-controllo-della-semina-e-della-germinazione-con-tabella-Excel-da-scaricare.html?m=1
Sistemare e pianificare l'#orto, anche quando progettato in piccoli spazi vuol dire fare tantissime scelte, in ogni modo la verifica della bontà dei #semi e il loro sviluppo è un passo fondamentale. Come fare,cosa osservare e tabella #excel gratis da scaricare
#ortourbano #agricolturasostenibile #agricolturabiologica #alimentazione #autoproduzione #autosufficienza #autosuffisancealimentaire
#Microsoft how is it 2023 and we still don’t have a random sort option for table rows in #Office #Excel ? It would be so useful.
When I'm creating these thumbnails there's a dark-side saying "you look like a bloody idiot" and then the light-side says... ah well.. do it anyway🤣
Dirty Data Dojo: Cleaning Data (Excel & Python): Learn to Clean Your Dirty Data in Minutes, not Months http://leanpub.com/courses/leanpub/dirtydatadojo-excelpython by Lee Baker is the featured course on the Leanpub homepage! https://leanpub.com #courses #Excel #Python #DataScience
Es gibt #Excel #ESports??? :blobcatopenmouth:
https://www.fmworldcup.com/excel-esports/microsoft-excel-world-championship/
1990 #Microsoft #Excel commercial… https://youtu.be/kOO31qFmi9A
The first part of this #VBA #Excel project (to automatically populate a spreadsheet with details of vehicles staff use and confirm they have tax and MOT (inspection)) was more straightforward than I expected..
(I nicked the JSON parser from a web, rather than roll my own)
I now just need to parse the dictionary it generates to warn of errors and (if data is good) populate an array (bearing in mind name/value pairs from DVLA can arrive in any order and total amount of them can vary)
Du machst bei der Arbeit einen #Fehler in einer #Excel-Liste mit der die Kundin weiterarbeiten will. Sie bemerkt den Fehler und wirft dir vor, dass du nicht sorgfältig genug warst (stimmt) und dass du hättest sagen können, dass du keine Ahnung von E. hättest (stimmt nicht).
Wie oft entschuldigt man sich, bevor man sich nach dem dritten, unsachlichen Vorwurf, die Zusammenarbeit beendet?
I have a Google form we use to record raffle entries for a cat rescue. Supporters enter by adding a Facebook comment with how many entries they want then one of the rescue’s volunteers adds them to the form - name and number of entries.
Is there then a way to get Google Sheets to automatically duplicate each entry (name) for as many times as the number of entries given in the form?
@Jbat @miriamkp
Ethan #Mollick on oneusefulthing is positive about #GPT4 #Code #Interpreter for #Python. But it's often the case that experts can ask questions that are not answered in the training data.
I found that #Bing solved an easy #Excel lookup question but anything more complicated could not be done.
Rogue file in your SharePoint Folder?
How to consolidate multiple files from a SharePoint / OneDrive folder AND how to debug issues when it doesn’t work… including creating an output table listing the problem files…
YouTube: https://youtu.be/x2i0MRsE3RU
#microsoft #excel is such a piece of poop
in the descriptive statistics output, they don't include coefficient of variation (CV)
un believable
How can I apply the same conditional formatting rule to multiple rows separately ? For example, color scale for the first row, then a separate color scale for row 2, etc.
It's the same rule, I just don't want a value in row 2 to change the colors in row 1 which is what happens if range is comma separated, like A1:L1, D2:P2.
I could use separate rules, but it's 60 rows. If it matters, I'm using #GoogleSheets I just want a checkbox for "Apply to each column/row separately"
#microsoft #office #office365 #excel
at least in my older version of office, you can't do a search for text in a text box
there are macros on the web, but in my experience they don't work well
I've just released Applet Runner 2️⃣ NetBeans plugin.
What's new: PDF, Word, Excel, CSV, Powerpoint, JSON, XML and YAML Viewers.
Terminal, HTML Browser, MP3 Player and many more. The best is that you watch the video 🎞 below.
https://youtu.be/hcfG9kHHhA4
I currently have an M2 #MacbookAir but I've been considering switching back to Windows.
Mainly due to Office just works better (especially #Excel) but also I miss some of the "smaller" games that you can't get on MacOS
Part of me thinks it would be a foolish thing to do though so for now I'm holding off 😀
How to write better Multiple IF formulas in Power Query.
- parameter approach
- approximate match approach
YouTube:
lnkd.in/gccPvPhA
I have a meeting coming up next week or so. A vendor brought in a product that wowed the CISO, but I have no idea what problem they are solving. They are simply taking the data we have and formatting it differently, making a picture out of it. We can do that already. We are doing that already. We are doing more than that, already.
Does anyone have a vendor or product that can handle this particular use case?
A single app server or web server have components that are the responsibility of three different teams, at a minimum. Depending on how the servers are used, it can go up to a dozen or more teams.
Our vulnerability scanner ties everything to a specific device, generally by IP address and sometimes includes a port number. Rarely, it includes the path to the executable in the results.
How do we create a repeatable, automatic process for parsing those vulnerabilities out to the respective responsible parties?
Right now, we have someone who builds a giant IF THEN ELSE object in Alteryx to split things out before he pumps it into PowerBI.
He has to make adjustments to the logic every single week when we meet because there are always new vulnerabilities.
Brinqa? RiskSense? Kenna Security? Aristotle Insight? Vulcan? ServiceNow?
Please tell me your success stories or your cautionary tales.
#InfoSec #ThreatManagement #VulneraiblityManagement #VulnerabilityScanning #PowerBI #Alteryx #Excel
Blog article: Price breaks in a linear programming model
Price breaks, or volume discounts, are common when buying products in bulk. That is, the marginal cost of additional products falls as volume increases.
In this article, we describe an example of how to represent price breaks in a linear programming model.
https://www.solvermax.com/blog/price-breaks-in-a-linear-programming-model
I just realized I haven't done an #introduction toot, so here 'tis. I create online training courses independently and for LinkedIn Learning, mostly on #tableau and #microsoft #excel, and do a bit of writing and #keynote #speaking as well.
I also dabble in #boardgames and #wargames, especially as applied to business strategy, and have been a professional #improv performer since 1993. Other performing interests include #magic and #mentalism, especially as they intersect with #law and #rhetoric.
"Emotions are like spreadsheets a.k.a. #Excel, no one teach you to use them properly... and then, everyone asks you to know how to use them as expert everywhere for everything". － Anonymous
In meinem Leben findet viel in Excel-Tabellen statt und ständig brauche ich neue um Dinge zu ordnen und zu sortieren. Das ist ja erstmal nicht schlimm. Blöd finde ich nur, dass ich seit Jahren dafür Google Spreadsheets nutze und einfach nicht wechseln kann, weil es einfach die beste Software ist und nichts dagegen ankommt.
Habt ihr eine viable Alternative?
Here's a post on how to add #MachineLearning models to #Excel workbooks.
Read the post to find out how (and why) I bothered!
Slightly esoteric? maybe, maybe not. Whatever, I hope it's useful!
Comments welcome :-)
https://leo037.quarto.pub/leos-blog/posts/ML_in_excel/ML_in_excel.html
@kwf @b0rk I'd like to add more to it: Never use #Excel for anything - period!
#LibreOffice #Calc does the same but better...
Excel is a powerful tool for data analysis and visualization, but sometimes it can be limited in terms of formatting options. That's where the 'styledtable' package in R comes in!
#datavisualization #dataanalysis #excel #Rprogramming #collaboration #excel #tables #style #r #rstats #opensource #github #innovation #technology
Post: https://www.spsanderson.com/steveondata/posts/rtip-2023-04-11/
Been working with an almighty #Excel workbook that needs converting to #PowerQuery format and ultimately #PowerBI
It is so big it barely functions
There are multitudes of data redundancies, formulae with errors, circular references, and tens of thousands of columns with random bits of unnecessary data
Every sheet needs to be checked, validated and cleaned before going into Power Query for further work and transformation
When it comes to Excel: just because you can, doesn't mean you should
Looks like maybe XLWings is one option:
https://github.com/xlwings/xlwings/tree/main/tests
And they have a git plugin that allows you to diff VBA code embedded in spreadsheets:
Would you like to see what's going on in #London at the #StarWarsCelebration? Check out my news vlog in which I travel to the #ExCeL Centre and visit a cool #StarWars filming location: https://youtu.be/NUDgfZ_txWk
Oh now they've done it! 🧐
They made me "dnf install gnumeric", and slap @s3phy awake at 2 AM to boot up a corporate laptop to test with #Excel !
Both apps can open the file in less than 15 seconds, and this puts LibreOffice Calc's performance to shame in comparison.
If someone tries to dodge the cow, I shall taunt them a second time!
A nice comparison of descriptive #statistics methods in #Javascript, #Python, #SQL, R, and #Excel from https://vis.social/@Biff_Bruise/110113675417470663
I can't help but point out the syntactic consistency of the SQL implementations relative to the others.
And following up on yesterday's Data Wrangling comparisons across #Javascript, #Rstats, #Python, #SQL, and #Excel by @allison_horst, here is a dive into Descriptive Statistics across the same set of tools https://observablehq.com/@observablehq/descriptive-statistics-translations
Data wrangling essentials: comparisons in #JavaScript, #Python, #SQL, #Rstats, and #Excel by @allison_horst https://observablehq.com/@observablehq/data-wrangling-translations
Hier hat mal jemand eine schadhafte Excel-Datei auseinandergenommen. Es nutzt eine Schwachstelle im Formeleditor (CVE-2017-11882) aus und lädt schadhafte Inhalte nach.
https://isc.sans.edu/diary/Simple+Shellcode+Dissection/29642
#10yrsago Store wants $5 browsing fee to deter “#showrooming” by online shoppers https://consumerist.com/2013/03/25/store-combats-showrooming-with-5-just-looking-fee/
#10yrsago RPG inside an #Excel workbook https://carywalkin.ca/2013/03/17/arena-xlsm-released/
#10yrsago #Toronto Mayor #RobFord’s long history of public drunkenness and brawling https://www.thestar.com/news/city_hall/2013/03/26/rob_ford_intoxicated_toronto_mayor_asked_to_leave_military_ball.html
#10yrsago Summary of experimentally verified pricing heuristics https://cxl.com/blog/pricing-experiments-you-might-not-know-but-can-learn-from/
6/
Does anyone have a good solution for turning an #Excel worksheet into #MarkDown? The only thing I've found (https://tableconvert.com/excel-to-markdown) doesn't handle ALT-Enter newlines within cells gracefully...
This People Make Games video about Microsoft Excel eSports is brilliant:
https://www.youtube.com/watch?v=N2QC6VQXo8U&ab_channel=PeopleMakeGames
«Für das Schreiben von Texten oder das Erstellen von Tabellen braucht es weder #Word noch #Excel. Es gibt einige kostenlose Alternativen – zum Beispiel #LibreOffice.»
FsExcel now supports text rotation!
Want to be a surprise source of value for your company?
Go around to different departments and find out which ones are regularly updating spreadsheets to track the information they need. These are frequently a mess and difficult to maintain.
Those are prime candidates for building a new internal application that can significantly reduce costs.
One of our clients has a product with a large and growing market. That product started out as an #Excel document.
Too busy to keep track of a bracket during NCAA #MarchMadness but still want to play along?
Check out this #Excel mini-game:
https://techcommunity.microsoft.com/t5/excel-blog/college-basketball-random-bracket/ba-p/3765943
@eloquence What puzzles me is that although modern #capitalism is all about efficiency, people in charge ignores won't believe these study results.
It's like "but I want larger numbers on my #excel chart..."
So Excel’s find-replace is as you may now limited to say the least. Just tried using #Pandas to find-replace in a multi-sheet #excel file. Read in and reconstruct. Bonus: replacements clearly listed:
```
import pandas as pd
d = pd.read_excel('myExcel.xlsx', sheet_name=None)
for key in d.keys():
d[key].replace(regex={'foo':'bar', 'baz':'new'}, inplace=True)
with pd.ExcelWriter('myCleanedExcel.xlsx') as writer:
for key in d.keys():
d[key].to_excel(writer, sheet_name=key)
```
From Todd Wallach: "Here's my tipsheet for using Excel for stats at #NICAR23 today. I tried to pack a lot in an hour. The key takeaway is that Excel's Analsis ToolPak can generate a bunch of standard 'descriptive' stats on any column faster than typing in formulas and you can do more sophisticated functions, like correlation charts and multiple regression."
Presentation: https://docs.google.com/document/d/1MCA84ldnnMaGmg1UOydWVOIRW05Bm6kk/edit
Sample #data https://docs.google.com/spreadsheets/d/1AxiGXyYmlXQiNAsFvT3ofXV8DuwKUOUb/edit#gid=403145615
Essential Excel Skills For Researchers, Parts 1 & 2 https://measuringu.com/excel-1/ and https://measuringu.com/excel-2/ Not my thing, but very good stuff here! #excel #research #spreadsheet #data #tips
I'm in tears. This is hilarious. Poignant. And timely.
Please, take the profanity for what it is, a way to make you laugh, and remember, don't you dare use a spreadsheet.
#Engineering #Automation #Security #InfoSec #Spreadsheet #Excel
https://ludic.mataroa.blog/blog/i-will-fucking-dropkick-you-if-you-use-that-spreadsheet/
Google Sheets adds powerful new functions for advanced analysis https://workspaceupdates.googleblog.com/2023/01/google-sheets-powerful-functions-advanced-analysis.html #google #excel #analysis #marketing #sheets
Alright #spreadsheet nerds, here’s your next challenge. 😄
Anyone here an #Excel guru? I could use a hand.
I have a list of cards from multiple sets/expansions, and I need the ability to pull a random card.
That much I have already, using INDEX and RANDBETWEEN.
What I'd like to be able to do is tell Excel, "Only pull from expansions X, Y, and Z" instead of having it pull from the full roster of cards.
Currently, each card listing has its set as one of the columns on the data page. Each tab currently is a card type.
1/??
@neil Hah. Speaking of #Microsoft #L10n, there is also https://what.thedailywtf.com/topic/20319/wtf-bites/29451 (where the "update definitions" button was translated as a compound noun (i.e. "definitions of 'update'"), not a command ("update the definitions").
Or the Excel documentation where the list of #excel built-in functions was first sorted alphabetically, then translated, so entries like UND and ZÄHLENWENN appear very high up in the list (corresponding to their position in English, AND and COUNTIF).
Lots of tips for you to read in our In-Process blog this week! How to use Tables in #Excel, reporting table headers (in other apps too), Open Source month - #FOSSFeb, (with more links than we posted here!) and lots of info on RSS readers: https://www.nvaccess.org/post/in-process-10th-february-2022/
Hoping, although it's not a solution, I've found reason for Excel just hanging every so often. I believe it's related to conditional formatting! This has been happening for months, and it shortly unhangs, and I can save the file, but really frustrating. Finally, a search today suggested CF was the culprit. So now I will need to verify, but I hope it's the case (I can undo CF for now), and Microsoft makes a fix for it, or I figure out why soon. Grrrr. #Excel #Microsoft #O365
Useful resource for understanding how to make spreadsheets more machine readable and accessible to people with low vision, from the UK gov't, via @mattdray in his @NHSrCommunity webinar on the {a11ytables} R 📦
https://analysisfunction.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/
#Excel #spreadsheets
Womit und wie schreibe ich mein nächstes Buch?
In ein paar Wochen werde ich mein Buchprojekt über „Weinglücksorte“ in #Rheinhessen abgeben. Hier erfährst Du, wie ich mit #Excel, #Todoist, #BaseCamp, ON1 Photo Raw, #Scrivener, Microsoft #Word und Microsoft #Editor das #Buch schreibe:
https://derentspannen.de/womit-und-wie-schreibe-ich-mein-naechstes-buch/
#fotografie #schreiben #autor #wein
Oder Du kommst am nächsten Freitag, 12:30 Uhr, zu #VirtuellesKaffeetrinken: https://derentspannen.de/virtuelles-kaffeetrinken/
I work on the #Excel team at Microsoft and I play a *ton* of #sudoku, and I just created something that marries those two things.
Excel has soooo many awesome features, but navigating the menus to find out about & then use those features can be a challenge.
So here's an excel file with sudoku games in it, showing how cells can automatically change color based on what number you put in.
Save a copy and then use the (free) https://excel.office.com web app to try it out.
“Excel is pretty dang cool” https://buttondown.email/hillelwayne/archive/excel-is-pretty-dang-cool/
A programmer’s lens on modern-day #Excel affordances
I would hope an ability to query your #RSS and #OPML feeds directly using Text Search, #SQL, #GraphSQL, or #SPARQL would fit that bill re data flow and connectivity :)
Audience?
End-users, power-users, and developers who are happy to work with a #Hyperlink as a Data Source Name (#DSN).
App Examples?
1. Spreadsheets (#GoogleSpreadsheet, #Excel, #Airtable)
2. Various notebooks (#Jupyter, #Observablehq etc..)
3. Data Visualization Tools
4. Content Management
5. etc
/cc @judell