AdamDataNotes (@esProc_Desktop) header
AdamDataNotes (@esProc_Desktop) profile picture

AdamDataNotes

@esProc_Desktop

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine.

esproc.com/download-esproc/
Joined November 2017
  • Tweets654
  • Following739
  • Followers207
266Media
Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)Photo by AdamDataNotes (@esProc_Desktop)
Tech dive on calculating monthly account balances with missing dates. Compares SQL's complexity with SPL's approach. { author: @esProc_Desktop } #DEVCommunity #Database dev.to/judith677/calculate-m…
Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

Problem description & analysis: There is a transaction table for the asset accounts in...

dev.to
2
7
204
Excel Hack with SPL XLL #73 Remove duplicates and compute intersection Got duplicates in Excel? 🤔 SPL XLL formula cleans up your data and gives you the intersection of two columns, like magic! 🎩✨ #ExcelHacks #DataCleanup #Productivity #DataAnalysis #100DaysOfCode #VBA #Data
Image from AdamDataNotes (@esProc_Desktop)
1
2
53
Excel Hack with SPL XLL #71 Find The First Cell Value Meeting The Specified Condition Looking for a specific score in an Excel table? 📝 Use #SPLXLL to find the first value meeting your condition with ease! 📊 #ExcelTips #DataAnalysis #100DaysOfCOde #Productivity #Automation
Image from AdamDataNotes (@esProc_Desktop)
1
3
34
Excel Hack with SPL XLL #67: Combine two tables with different column headers in Excel effortlessly!🚀 Merge two tables with some common headers and display missing fields as empty. Try #SPLXLL now! Comment for free links! #Excel #DataAnalysis #VBA #Productivity #100DaysOfCode
Image from AdamDataNotes (@esProc_Desktop)
1
3
122
Excel Hack with SPL XLL #66: Group and summarize data every N rows in Excel? We've got you covered! Every two rows in our table form a range, storing client names and work hours. Let's summarize the hours for each client using #SPLXLL! 🔥 #ExcelHacks #DataAnalysis #Excel #VBA
Image from AdamDataNotes (@esProc_Desktop)
1
2
61
✍️ Explanation: This formula utilizes esProc's pivot function to transpose columns into rows, then groups the table by Fruitname, and concatenates the Fruitname value with the Name value. #100DaysOfCode #DataAnalysis #Excel
Image from AdamDataNotes (@esProc_Desktop)
1
1
2
35
19 Useful GitHub Repositories to Become a Better Developer 🔥 1. @esProc_SPL - A better alternative to SQL 🚀 ⭐ GitHub stars: 4K+ 💪 Data Processing Power 🧙 Rich Library Functions 💰 Cost Savings ⚡ Surpass SQL Try it: github.com/SPLWare/esProc #sponsored #ad More below 🧵👇
Image from Madza 👨‍💻⚡ (@madzadev)
12
11
3
59
6,830
Wow, my latest article was just published on @Medium 💖🥳 medium.com/stackademic/19-us…
9
4
1
41
3,474
So happy to share my first blog article in 2024! 🥳💖 madza.hashnode.dev/18-awesom…
4
5
1
38
3,895
AdamDataNotes retweeted
Seun (@CrownThirst) profile picture
Seun
@CrownThirst11 Dec 2023
@esProc_Desktop is also completely free to download and use Click here to download and get started: scudata.com/esproc-desktop/
2
6
185
AdamDataNotes retweeted
Seun (@CrownThirst) profile picture
Seun
@CrownThirst11 Dec 2023
• Perform complex calculations without writing VBA code • Avoid manual edits and perform complex calculations on grouped data
1
2
6
187
AdamDataNotes retweeted
Seun (@CrownThirst) profile picture
Seun
@CrownThirst11 Dec 2023
Where and When esProc Desktop can help: • Query SQL files without setting up a database • Save time merging and splitting lots of files • Automate repetitive tasks without having to learn python
1
2
7
134
AdamDataNotes retweeted
Seun (@CrownThirst) profile picture
Seun
@CrownThirst11 Dec 2023
Heard of the toolkit @esProc_Desktop? esProc Desktop is an Excel auxiliary tool that effectively manages desktop data files and makes data processing accessible to everyone.
1
2
7
126
AdamDataNotes retweeted
Seun (@CrownThirst) profile picture
Seun
@CrownThirst11 Dec 2023
“Data Analysis tools are merely a means to an end, not an end itself” Yes, creating stunning visuals is impressive no doubt, but if your analysis is not tilted towards solving business problems, you need to rethink.🧵 @esProc_Desktop in this article -> blog.scudata.com/a-laymens-r…
2
35
69
4,405
⭐1-step easiest using @esProc_Desktop Excel add-in (SPL XLL) specialised text splitting function. =spl("=?.split(""\n"")",C5) Hint: The add-in functions have the gentlest learning curve you have ever experienced. 🙌 Download it now📷 scudata.com/esproc-desktop/.
Image from CrispEXCEL Training & Consulting (@Crisp_EXCEL)
3
11
1,517
Hint: The Add-in functions have the most gentle learning curve you have ever experienced.🙌 Save Money! Save Time! Download it now👇 scudata.com/esproc-desktop/.
2
3
546
Read more about how esProc_Desktop will save you time and money.👇 blog.scudata.com/the-very-to…)

The very tool to liberate an Excelman from working overtime – SPL

Excel is currently the most widely used software tool in the workplace, with a large number of “Excelmen” in various industries using it to draw tables and perform calculations. It can be said that…

blog.esproc.com
1
2
3
560
Method 3: ⭐1-step easiest using @esProc_Desktop Excel add-in (SPL XLL) specialised text splitting function. =spl("=?.split(""\n"")",C5) NB: ? indicates the content to be split (i.e. C5)► split() is a string splitting function, and ”\n” represents a carriage return.
Image from CrispEXCEL Training & Consulting (@Crisp_EXCEL)
1
2
3
78
3 ways to split text based on carriage return without an #Office365 subscription. The last one is the easiest!😎 You only need to download @esProc_Desktop—a FREE #Excel auxiliary tool for analysing desktop data files. Download it now👇 scudata.com/esproc-desktop/. 🧵 #programming
Image from CrispEXCEL Training & Consulting (@Crisp_EXCEL)
1
3
5
989
So happy to publish a new blog article after a week 👍💯💖 19 GitHub Repositories Every Developer Should Bookmark 📚👍 { by @madzadev } from @hashnode madza.hashnode.dev/19-github…
9
3
30
2,865
Load more