I don't actually have dates before anything than a few years back, I just assumed they have the same time count as Unix.
But it's an actual problem with historical data. And DNA scientists had the problem of DNA description strings (?) getting interpreted as dates but this has been solved now.
And it's on the cloud so M$ can harvest the day you work on and how you work on it.
1 month ago
Anonymous
*Data
Derp
1 month ago
Anonymous
meds
1 month ago
Anonymous
Wake up.
It's that shit and that shit alone that is the reason why I will never buy office ever again.
It's so annoying to have to sign up just to use help.
>It's that shit and that shit alone that is the reason why I will never buy office ever again.
Same. I have Office 2019 on a laptop that hardly sees any use.
She's clearly never used VBA.
Then again, I've been using librecalc and BASIC is ... oh frick it is way worse than I could imagine.
Luckily, python exists and I think you can just use that shit on libre. Don't think it was there for excel 2016.
>Then again, I've been using librecalc and BASIC is ... oh frick it is way worse than I could imagine.
LO BASIC isn't as bad as VBA is it?
1 month ago
Anonymous
I've used whatever basic libre used. I just went "NOPE". This was just recently. VBA I used at a firm like 5-6 yrs ago and it probably fricked me in the end for I was naive on it's capabilities or code in general.
This is, btw, coming from a dude trying to dabble with assembly nowadays.
VBA was my first code experience and I wanted to break every computer after it.
ASM is somehow nice.
I just don't get it. How is BASIC and VBA so painful?
No other languages are nearly as painful for me.
Assembly is hard and your not likely to get results. But at least you understand what's going on. With BASIC and VBA it always feels like "computer just said no" and that's it.
Python, Java, Javascript, C and C++ did not have nearly as big of an issue for me.
Neither did machine code.
I don't even.
Something is very wrong with the design of BASIC and VBA.
1 month ago
Anonymous
It's that shit and that shit alone that is the reason why I will never buy office ever again.
It's so annoying to have to sign up just to use help.
this tbqh
Most of my job consisted of sending out productivity reports pulled from a website because the managers are too lazy to go to the website. It was horrible and tedious and took ages of clicking and copying and pasting.
I made an unholy monstrosity of VBA (back when I didn't know how to code) that did all the reports automatically and then put that b***h in Windows Task Scheduler thereby automating 99% of my job.
The other 1% of the job is critical shit that requires someone on site 24/7 in case something actually breaks so they couldn't actually lay us off or anything, so thanks to VBA I get paid to do next to nothing.
My worst data engineering pipeline was connecting Looker to Salesforce using Google Sheets (the poor man's equivalent to excel) as a "staging database", because the startup was so cheapstake they didn't want to pay for the Salesforce-BigQuery connector. Just imagine how shitty it was to maintain, running fricking formulas to transform the data and grab the resulting cells for ingestion.
Btw I was laid off 6 months later and the same luck happened to the rest of the team in less than a year.
I don't know, but I'm pretty sure she probably considers anyone concatenating the text contents of three cells together as "coding."
That being said, I did not expect to hear this from her, in virtually conceivable context.
Wait, is Michaelsoft actually paying Hollywood celebs to shill their products?
I think they're shitting their pants now that everyone realizes MS Office is just a charade and can be replaced with LibreOffice 99% which is cost free, free of Microshart cancer and freely allows you to manage your own data instead of shoving it into the cloud, so Bill Gates can see your noodz (that you happen to embed in your Excels, for whatever reasons).
Sorry, I'm really high now, I seem to just be dropping words, thinking I've typed them down, but I haven't.
I can't be arsed to correct it, figure it out yourself, yolo.
The OP pic literally says "Not everybody is going to learn to code", obviously alluding to Excel. What the frick are you talking about? She's clearly saying Excel isn't coding.
>not everybody whom welds is going to learn how to use a blow torch or soldering iron and we need to respect that
foolish bawd whom has never touched a computer in her life
my ass is white enough to blind you. libreoffice sucks
fine for quick tasks, but unsuitable for large volumes of data or serious projects
1 month ago
Anonymous
>saar I'm white saar do the needful and use pajeetsoft office developed by my fellow saars >libreoffice is bloody b***h bastard garbage don't use it SAAAAAAAAAAAAAAAAAAAAAAAAAAAAAR
1 month ago
Anonymous
LibreOffice has a huge user base in India, sirbro. you're projecting
my ass is white enough to blind you. libreoffice sucks
fine for quick tasks, but unsuitable for large volumes of data or serious projects
>saar I'm white saar do the needful and use pajeetsoft office developed by my fellow saars >libreoffice is bloody b***h bastard garbage don't use it SAAAAAAAAAAAAAAAAAAAAAAAAAAAAAR
Not him but I totally see why.
But there's probably also security issues.
microsoft is stupid and artificially limits Excel's row capability
same as they did with MS Access and it's 2 GB file limit
Have you ever used a spreadsheet with about 15 sheets all with 10s of thousands of rows?
It is a nightmare.
I worked for a firm involved a case that dealt with a utilities corporation once.
They had their system on a fricking excel spreadsheet. I kid you not.
And it was a nightmare to just print a single page from or just to filter information from.
So 2GB is rather generous for that shitfest of a program. It's so bloated and slow.
Used to use Excel all the time for smaller analytics tasks. Our main DB held huge amounts of data but we only ever really needed to handle specific slices so we'd query the DB and export to CSV, then import into Excel and do what we needed. Pivot tables pulled most of the weight.
Excel has insanely unhelpful documentation and error messages. I feel crazy having to deduce what a function is doing by trying stuff. It's unreal this is a Microsoft product
so what are modern spreadsheet features that only excel has? I haven't used spreadsheet for a long time now but I thought it was a finished product and they mostly only add uix stuff or maybe some new stats functions. Am I wrong? Is there a overview of feature maybe a table that lists them in libre vs onlyoffice vs excel?
VBA to write custom software. Way worse than JS in google sheets but at least you can easy interact with files locally/on the network.
No idea what Basic or whatever it's called in LibreOffice calc can do, I never heard of anyone using it.
You can use PowerApps to interact with .xlsx these days and run a kind-of database from them with a simple http or Teams frontend. It's disgusting and a total hack and leaks your data all over Dataverse/Teams/AD but office slags just cannot into anything else.
Using Excel as a simple spreadsheet is also painfully slow, laggy and error-prone these days. O365 and endless integration with other MS services has ruined it. If all you need is a simple local spreadsheet, you really are better off using something else.
I WANT TO RAPE SYDNEY SWEENEY >I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY >I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY >I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY >I WANT TO RAPE SYDNEY SWEENEY
I think excel for data entry is okay (especially if using data validation features and locking the sheets to prevent idiots from fricking anything up).
But for any serious “data science” work, the data should be extracted, processed , and stored into a real database. I used to be a codelet who wrote extremely complicated excel functions (with like 6 levels of nested IF statements) that were borderline impossible to debug afterwards, and now I cringe knowing that I could do all that (and much more) with a few simple lines of Python.
NTA but I’ll bite. Everything in the no-code MS Power suite is stupid easy to use until you need to do something more complicated than dragging and dropping in the gui. Once you need to code something the docs are terrible and the form answers are garbage, usually just links to content creator’s Youtubes that don’t solve your problem.
Doing all your data processing in Python or Excel and then plugging in the results to BI for pretty graphs is chill. Trying to use the data model feature is a nightmare for anything more complicated than the gui can handle
Anyone tried using office js for custom solutions at their job? It’s supposed to be cross platform and work on both online and desktop excel. Seems neet but I’m wondering how powerful it is compared to VBA or COM add ins. Especially since it’s supposed to work on excel online that is pretty limited.
bitty
who the frick cares about what breasts mcdowney face says
my dick
I have dates from before 1970, excel chads, how do we cope with that?
She's the Joan of Arc of the culture war.
You mean before 1900? 1970 is a Unix problem.
I don't actually have dates before anything than a few years back, I just assumed they have the same time count as Unix.
But it's an actual problem with historical data. And DNA scientists had the problem of DNA description strings (?) getting interpreted as dates but this has been solved now.
How the frick do you "code" with Excel?
VBA?
my hairy ass
not anymore
VBA still works fine. C# as well, I'd wager.
holy based. what version?
And it's on the cloud so M$ can harvest the day you work on and how you work on it.
*Data
Derp
meds
Wake up.
>It's that shit and that shit alone that is the reason why I will never buy office ever again.
Same. I have Office 2019 on a laptop that hardly sees any use.
>Then again, I've been using librecalc and BASIC is ... oh frick it is way worse than I could imagine.
LO BASIC isn't as bad as VBA is it?
I've used whatever basic libre used. I just went "NOPE". This was just recently. VBA I used at a firm like 5-6 yrs ago and it probably fricked me in the end for I was naive on it's capabilities or code in general.
This is, btw, coming from a dude trying to dabble with assembly nowadays.
VBA was my first code experience and I wanted to break every computer after it.
ASM is somehow nice.
I just don't get it. How is BASIC and VBA so painful?
No other languages are nearly as painful for me.
Assembly is hard and your not likely to get results. But at least you understand what's going on. With BASIC and VBA it always feels like "computer just said no" and that's it.
Python, Java, Javascript, C and C++ did not have nearly as big of an issue for me.
Neither did machine code.
I don't even.
Something is very wrong with the design of BASIC and VBA.
It's that shit and that shit alone that is the reason why I will never buy office ever again.
It's so annoying to have to sign up just to use help.
You can use python in excel now?
Well then discard
I tried VBA and BASIC now and you should never do that. Never use VBA or BASIC. Unless you're a masochist.
soulless
this tbqh
Most of my job consisted of sending out productivity reports pulled from a website because the managers are too lazy to go to the website. It was horrible and tedious and took ages of clicking and copying and pasting.
I made an unholy monstrosity of VBA (back when I didn't know how to code) that did all the reports automatically and then put that b***h in Windows Task Scheduler thereby automating 99% of my job.
The other 1% of the job is critical shit that requires someone on site 24/7 in case something actually breaks so they couldn't actually lay us off or anything, so thanks to VBA I get paid to do next to nothing.
Thanks, VBA!
My worst data engineering pipeline was connecting Looker to Salesforce using Google Sheets (the poor man's equivalent to excel) as a "staging database", because the startup was so cheapstake they didn't want to pay for the Salesforce-BigQuery connector. Just imagine how shitty it was to maintain, running fricking formulas to transform the data and grab the resulting cells for ingestion.
Btw I was laid off 6 months later and the same luck happened to the rest of the team in less than a year.
I don't know, but I'm pretty sure she probably considers anyone concatenating the text contents of three cells together as "coding."
That being said, I did not expect to hear this from her, in virtually conceivable context.
Wait, is Michaelsoft actually paying Hollywood celebs to shill their products?
I think they're shitting their pants now that everyone realizes MS Office is just a charade and can be replaced with LibreOffice 99% which is cost free, free of Microshart cancer and freely allows you to manage your own data instead of shoving it into the cloud, so Bill Gates can see your noodz (that you happen to embed in your Excels, for whatever reasons).
Sorry, I'm really high now, I seem to just be dropping words, thinking I've typed them down, but I haven't.
I can't be arsed to correct it, figure it out yourself, yolo.
The OP pic literally says "Not everybody is going to learn to code", obviously alluding to Excel. What the frick are you talking about? She's clearly saying Excel isn't coding.
=IF()
how the frick do you "code" with AND, OR, IF, NOT, etc?
I shall endeavor to show u bitiful b***h lasagna
boob
>not everybody whom welds is going to learn how to use a blow torch or soldering iron and we need to respect that
foolish bawd whom has never touched a computer in her life
She is right
They hated her because she spoke the truth
A lot of people are too dumb to code but can still get a lot of use out of Excel
Doesn't look like she ever said that.
paizuri
>can't handle more than 1 millon rows of data
>literally not meant to be used as a databse
>VBA is literally banned in most companies
Sure... small, small, small business can survive on Excel and Quickbooks... but what if you actually want to make money?
microsoft is stupid and artificially limits Excel's row capability
same as they did with MS Access and it's 2 GB file limit
what about libreoffice albeit?
both libreoffice and Ms office have a database program too that's easy to use
libreoffice sucks and everybody knows it
it doesn't, Prakesh
my ass is white enough to blind you. libreoffice sucks
fine for quick tasks, but unsuitable for large volumes of data or serious projects
>saar I'm white saar do the needful and use pajeetsoft office developed by my fellow saars
>libreoffice is bloody b***h bastard garbage don't use it SAAAAAAAAAAAAAAAAAAAAAAAAAAAAAR
LibreOffice has a huge user base in India, sirbro. you're projecting
You two homosexuals gonna kiss?
yes :3
>>VBA is literally banned in most companies
Enlighten me
Not him but I totally see why.
But there's probably also security issues.
Have you ever used a spreadsheet with about 15 sheets all with 10s of thousands of rows?
It is a nightmare.
I worked for a firm involved a case that dealt with a utilities corporation once.
They had their system on a fricking excel spreadsheet. I kid you not.
And it was a nightmare to just print a single page from or just to filter information from.
So 2GB is rather generous for that shitfest of a program. It's so bloated and slow.
>>VBA is literally banned in most companies
what fantasy world do you live in and how do i move there as soon as possible
move from your excel db startup into any job that gives a shit about security
>can't handle more than 1 millon rows of data
Why do you need your data to be on a worksheet?
why are incels obsessed with her? she can't act and she isn't even hot
Wrong, she is hot, she isn't that pretty though.
Coding in excel is more difficult than in python.
I would like to perform some science on her data if you know what I mean
yeah
t. excel monke
She's clearly never used VBA.
Then again, I've been using librecalc and BASIC is ... oh frick it is way worse than I could imagine.
Luckily, python exists and I think you can just use that shit on libre. Don't think it was there for excel 2016.
>knows excel and data sci
>fixed her own cars
>attractive
Is she the giga Stacey of our time?
she's sexy so she must be correct
her breasts aren't even that big
https://fap.thefappeningnew.com/wp-content/uploads/2024/02/colleen-sheehan-colleensheehan3-nude-leaks-onlyfans-leaked-models-2daf9e8.jpg
Atleast hers done reach the floor
you think you are too good for those?
suckable
Used to use Excel all the time for smaller analytics tasks. Our main DB held huge amounts of data but we only ever really needed to handle specific slices so we'd query the DB and export to CSV, then import into Excel and do what we needed. Pivot tables pulled most of the weight.
Excel has insanely unhelpful documentation and error messages. I feel crazy having to deduce what a function is doing by trying stuff. It's unreal this is a Microsoft product
>It's unreal this is a Microsoft product
Huh? Its about par for the course for the past several decades.
Who is she and why is she on the news so often?
i can give you two guesses
who let this big titty b***h comment on data science
just show your breasts and shut your mouth
for me, it’s Numbers from the iWork Suite
>she doesn't use Gnumeric
so what are modern spreadsheet features that only excel has? I haven't used spreadsheet for a long time now but I thought it was a finished product and they mostly only add uix stuff or maybe some new stats functions. Am I wrong? Is there a overview of feature maybe a table that lists them in libre vs onlyoffice vs excel?
VBA to write custom software. Way worse than JS in google sheets but at least you can easy interact with files locally/on the network.
No idea what Basic or whatever it's called in LibreOffice calc can do, I never heard of anyone using it.
You can use PowerApps to interact with .xlsx these days and run a kind-of database from them with a simple http or Teams frontend. It's disgusting and a total hack and leaks your data all over Dataverse/Teams/AD but office slags just cannot into anything else.
Using Excel as a simple spreadsheet is also painfully slow, laggy and error-prone these days. O365 and endless integration with other MS services has ruined it. If all you need is a simple local spreadsheet, you really are better off using something else.
I WANT TO RAPE SYDNEY SWEENEY
>I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY
>I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY
>I WANT TO RAPE SYDNEY SWEENEY
I WANT TO RAPE SYDNEY SWEENEY
>I WANT TO RAPE SYDNEY SWEENEY
>Still single threaded in 2024
fricking joke frick microshit
i saw her in immaculate. Cant take my eyes of her breasts.
I think excel for data entry is okay (especially if using data validation features and locking the sheets to prevent idiots from fricking anything up).
But for any serious “data science” work, the data should be extracted, processed , and stored into a real database. I used to be a codelet who wrote extremely complicated excel functions (with like 6 levels of nested IF statements) that were borderline impossible to debug afterwards, and now I cringe knowing that I could do all that (and much more) with a few simple lines of Python.
Sydney Sweeney could say literally anything and I will agree with her
Power BI or bust, even though it's a pain to learn.
my company uses powerbi, has no training on it, and won't just let me use python
That software is a fricking war crime to learn, but very useful. I bought a course on udemy, free yt classes weren't doing the trick for me.
What's so hard about PowerBI? Only used it a couple of times to load data and produce some charts but seemed easy enough.
NTA but I’ll bite. Everything in the no-code MS Power suite is stupid easy to use until you need to do something more complicated than dragging and dropping in the gui. Once you need to code something the docs are terrible and the form answers are garbage, usually just links to content creator’s Youtubes that don’t solve your problem.
Doing all your data processing in Python or Excel and then plugging in the results to BI for pretty graphs is chill. Trying to use the data model feature is a nightmare for anything more complicated than the gui can handle
What about writing something in DAX? Seems like the intended solution for more complex data processing tasks.
If you're not smart enough to code, you shouldn't be doing anything that can be called "data science"
I've heard timothee chalamet uses python with numpy and pandas
Anyone tried using office js for custom solutions at their job? It’s supposed to be cross platform and work on both online and desktop excel. Seems neet but I’m wondering how powerful it is compared to VBA or COM add ins. Especially since it’s supposed to work on excel online that is pretty limited.