• CIPWTTKT&GC V43 - WHERE IS MY THINKPAD?
    5,002 replies, posted
I thought Excel was supposed to be some sort of decent spreadsheet application, but I imported a simple CSV file with only a bit over 1300 rows and it freezes for like 30 seconds every time I try to do something. Edit: LibreOffice managed it. [t]http://i.imgur.com/a3LH88D.png[/t]
[QUOTE=nikomo;52286956]I thought Excel was supposed to be some sort of decent spreadsheet application, but I imported a simple CSV file with only a bit over 1300 rows and it freezes for like 30 seconds every time I try to do something. Edit: LibreOffice managed it. [t]http://i.imgur.com/a3LH88D.png[/t][/QUOTE] The time I dumped an entire Telegram chat's history into a .csv 206,447 rows, 13.2MB. And then I tried to run a recursive function on it Excel got to about 7gb of memory usage before I decided this is probably a job for SQL :v:
[QUOTE=nikomo;52286956]I thought Excel was supposed to be some sort of decent spreadsheet application, but I imported a simple CSV file with only a bit over 1300 rows and it freezes for like 30 seconds every time I try to do something. Edit: LibreOffice managed it. [t]http://i.imgur.com/a3LH88D.png[/t][/QUOTE] Office has lots of weird issues. So does LibreOffice, but they tend to be sane issues, like typical bugs or it getting stuck loading a document. MS Office has the weird issues like what you described, or entering a value in a certain spreadsheet in 2010 causes it to leak memory uncontrollably, but works fine in Libre or Office 2013. Literal insanity problems. And usually my answer is: "i dunno, remake the spreadsheet" or "somehow your office settings got corrupted, so it won't stop reconfiguring, time to wipe your Windows profile". Most drastic fix I've ever done in Libre is reinstall. Yet everyone at work insists to be upgraded to MS Office from Libre, because its "better". Also, over its entire lifespan, MS never fixed the issue in Office 2007 that the "title bar drag" while maximized was completely broken in 7 and newer. Still broken to this day.
Microsoft has and always will live off of selling themselves to businesses so all the employees and would-be employees have to learn it so most people figure​ they might as well just stick with it There's extremely few reasons to use Office over Libre other than the fact that everyone else uses Office
I use libre but when people ask me why, I don't even know lol
If anyone wants to play around with the CSV: [url]https://github.com/TheNikomo/battery_logger/blob/csv_logger/example_data/BAT0.csv[/url] There's some stuff that really doesn't need to be saved but I was lazy and wanted a PoC.
[QUOTE=Warship;52287095]I use libre but when people ask me why, I don't even know lol[/QUOTE] Free with no stipulations, quicker and easier to install since there are no aforementioned licensing stipulations, generally more stable, compatible with a wider variety of formats, better UI (imo), etc. I don't do office type shit often enough to even justify the extra half hour to an hour it takes to install MS Office instead of Libre, even if it's free for me as a student.
[QUOTE=nikomo;52286956]I thought Excel was supposed to be some sort of decent spreadsheet application, but I imported a simple CSV file with only a bit over 1300 rows and it freezes for like 30 seconds every time I try to do something. Edit: LibreOffice managed it. [t]http://i.imgur.com/a3LH88D.png[/t][/QUOTE] I'm not sure I understand what issue you're having here it works perfectly fine? [quote][vid]https://www.helifreak.club/files/20170529084243547.mp4[/vid][/quote] [editline]29th May 2017[/editline] Nice that Excel is showing my Windows credentials instead of the work account the license is from with my actual name on it.
[QUOTE=Warship;52287095]I use libre but when people ask me why, I don't even know lol[/QUOTE] Easy for me, good enough for basic work so in the few times I actually need to write something its available to me. Edit: Though I'm not sure it will be good enough for my computing course at uni.
Apparently Windows Server 2012 R2 just lets anyone logged in turn the server off and guess what happened to a client on the weekend.
[QUOTE=helifreak;52287180]Apparently Windows Server 2012 R2 just lets anyone logged in turn the server off and guess what happened to a client on the weekend.[/QUOTE] This is some dsp level shit
[QUOTE=helifreak;52287156]I'm not sure I understand what issue you're having here it works perfectly fine? [editline]29th May 2017[/editline] Nice that Excel is showing my Windows credentials instead of the work account the license is from with my actual name on it.[/QUOTE] Yeah, not sure what was up with it. Thankfully the LO graph was good enough to demonstrate what I reckon the issue is - I thought I had crappy cells in my battery pack, but if you look at the graph, the voltage drop on group0 is always in proportion to group1 and group2. Probably cheap low-accuracy resistors in the ADC circuitry on the cheap aftermarket battery, rather than crappy cells. I'm only missing like 3Wh of capacity (86.6Wh design capacity, 83.7Wh measured).
[QUOTE=Teddybeer;52287219]Office Open XML.[/QUOTE] I usually Install both MS Office and LibreOffice but only use MS Office when it comes to writing documents that I have to distribute as a docx or odf. If a document screws up that I created in LibreOffice, I get the blame for using LibeOffice in the first place. If a document screws up that I created in MS Office, I can blame MS Office for being shit. Thats considering .docx/odf files tho. If it's a pdf file, this isn't an issue and anything will pretty much work.
[QUOTE=helifreak;52287180]Apparently Windows Server 2012 R2 just lets anyone logged in turn the server off and guess what happened to a client on the weekend.[/QUOTE] Should have restricted access to shutting the server off in group policy.
I haven't been able to use bing since yesterday [media]https://twitter.com/Scrxtchy/status/869257420601606144[/media]
[QUOTE=Scratch.;52288522]I haven't been able to use bing since yesterday [media]https://twitter.com/Scrxtchy/status/869257420601606144[/media][/QUOTE] How...unfortunate
Oops my version of Enterprise is LTSB so the Windows Linux Subsystem isn't available to me. Guess I'll just do a VM.
[QUOTE=Scratch.;52288522]I haven't been able to use bing since yesterday [media]https://twitter.com/Scrxtchy/status/869257420601606144[/media][/QUOTE] Good thing all the good search engines aren't run by Microsoft.
[QUOTE=Dorkslayz;52288540]How...unfortunate[/QUOTE] oh yeah it also affects azure
Why the fuck would anyone wait until the last minute to update the certs?
I've been running into some problems with games lately. They start up fine, but as soon as I get into gameplay, framerates go from 60 to 1 and I cannot figure out why. It doesn't seem to be overheating, and it is not that game requirements are too high (it happens in Half Life). I tried the Windows 10 Fresh Start thing, didn't change anything. I tried fresh drivers and everything. It's a Dell Precision M6600 with a Quadro 3000M.
[QUOTE=kaze4159;52287028]The time I dumped an entire Telegram chat's history into a .csv 206,447 rows, 13.2MB. And then I tried to run a recursive function on it Excel got to about 7gb of memory usage before I decided this is probably a job for SQL :v:[/QUOTE] I got tired of trying to use the radio frequency license search tool on Industry Canada's website, because the queries would literally take five minutes to display and the layout of the results was very annoying to navigate. Thankfully, they provide a CSV dump of all 400k rows on their website. I loaded that into Excel and made a table, then used the filters to find the data I was looking for. It was still kind of a pain to browse around for transmitter sites, so I dumped the data into MySQL and threw together some mediocre PHP and Javascript to display markers using the GPS coordinates in the rows of data. My first query selected all of the unique GPS coordinates of transmitter sites and dumped them into a basic Google Map. Spoiler alert, Chrome doesn't like being asked to display 32,860 markers at once. [img]http://i.imgur.com/c2Q3jVh.png[/img] Eventually, I may try to turn it into a proper website and make it more interactive. In my head, I imagine it could be used to show the locations of transmitter sites, what they're used for and what companies own them. It may also show if the radio frequency range falls into what an RTL-SDR dongle can pick up. Boring as fuck, but I need a project.
I wish the FCC ULS wasn't a giant piece of shit and I could export data like that down here. Would make finding tower sites so much easier. Whenever I need to update my license I have to boot up Firefox 3.6 and install Java 1.6 before their webapp will even attempt to load.
Just picked up an XFX RX 570 to replace my aging HD6870. Should I be prepared for a pretty big difference? Any driver configuration oddities to be aware of in advance?
[QUOTE=Biotoxsin;52288973]Just picked up an XFX RX 570 to replace my aging HD6870. Should I be prepared for a pretty big difference? Any driver configuration oddities to be aware of in advance?[/QUOTE] Closest product from a close enough time line is a 290X. [url]http://www.anandtech.com/bench/product/1336?vs=1056[/url] Yes. Enjoy.
[QUOTE=Biotoxsin;52288973]Just picked up an XFX RX 570 to replace my aging HD6870. Should I be prepared for a pretty big difference? Any driver configuration oddities to be aware of in advance?[/QUOTE] Wait for Veg--...oh
[QUOTE=benjgvps;52288935]I got tired of trying to use the radio frequency license search tool on Industry Canada's website, because the queries would literally take five minutes to display and the layout of the results was very annoying to navigate. Thankfully, they provide a CSV dump of all 400k rows on their website. I loaded that into Excel and made a table, then used the filters to find the data I was looking for. It was still kind of a pain to browse around for transmitter sites, so I dumped the data into MySQL and threw together some mediocre PHP and Javascript to display markers using the GPS coordinates in the rows of data. My first query selected all of the unique GPS coordinates of transmitter sites and dumped them into a basic Google Map. Spoiler alert, Chrome doesn't like being asked to display 32,860 markers at once. [img]http://i.imgur.com/c2Q3jVh.png[/img] Eventually, I may try to turn it into a proper website and make it more interactive. In my head, I imagine it could be used to show the locations of transmitter sites, what they're used for and what companies own them. It may also show if the radio frequency range falls into what an RTL-SDR dongle can pick up. Boring as fuck, but I need a project.[/QUOTE] I've always wanted this for RTLSDR, because the FCC info lookup is such a POS stuck in 2005. EDIT: I got a server timeout message. The component has a build date of Dec 2006. Yikes.
[QUOTE=Forumaster;52288675]Why the fuck would anyone wait until the last minute to update the certs?[/QUOTE] Why the fuck would Google not enforce security standards.
RIP my water pump, 2013-2017. I guess 2 cross country trips in my back seat was too much for you to handle for long.
[QUOTE=helifreak;52289930]Why the fuck would Google not enforce security standards.[/QUOTE] Chrome lets you use it as an insecure connection [url]https://www.theregister.co.uk/2017/05/29/certificate_snafu_sees_azure_portal_reject_firefox/[/url] Maybe all these services just run on Azure, bing, outlook web, my image hosting "An invalid OCSP signing certificate that has been cached is causing failures for a subset of customers" -Msoft thanks cache
Sorry, you need to Log In to post a reply to this thread.