Boss: Hey we got a new outsourcing project coming up, you know anything about python, sql server and php?

Me: Never worked with sql server nor python but i can learn

Boss: Good, next week you go to the client's place and you start

Me: aight

(week later me at the client)

Client: Ok, your job here will be to fill excel spreadsheets with those fancy functions

Me: :) wut :)

Client: Also our printer died yesterday, can ya fix it?

I think i need a new job..

Job opening tells us that they want someone who knows:
C, C++, C#, Java, VB, PHP, HTML, Javascript, MySql, Postgree, windows, Linux, Mac OS, a degree in computer science and a few years of experience.

What you'll actually do in most of those jobs: Deal with Excel spreadsheets.

About two years ago I get roped into a something when someone was requesting an $8000 laptop to run an "program" that they wrote in Excel to pull data from our mainframe.

In reality they are using our normal application that interacts with the mainframe and screen scrapping it to populate several Excel spreadsheets.

So this guy kept saying that he needed the expensive laptop because he needed the extra RAM and processing power for his application. At the time we only supported 32 bit Windows 7 so even though I told him ten times that the OS wouldn't recognize more than 3.5 GB of RAM he kept saying that increasing the RAM would fix his problem. I also explained that even if we installed the 64 bit OS we didn't have approval for the 64 bit applications.

So we looked at the code and we found that rather than reusing the same workbook he was opening a new instance of a workbook during each iteration of his loop and then not closing or disposing of them. So he was running out of memory due to never disposing of anything.

Even better than all of that, he wanted a faster processor to speed up the processing, but he had about 5 seconds of thread sleeps in each loop so that the place he was screen scrapping from would have time to load. So it wouldn't matter how fast the processor was, in the end there were sleeps and waits in there hard coded to slow down the app. And the guy didn't understand that a faster processor wouldn't have made a difference.

The worst thing is a "dev" that thinks they know what they are doing but they don't have a clue.

I took a one month intern position for a company doing data entry. They had thousands of rows in dozens of spreadsheets, and they needed the data entered, row by row, into two different sites, and then link the two entries together.

After the first day I was ready to lose my mind. But... I'm a developer. You know where this is going 😉

At noon the next day, I emailed my employer: "hey, I finished all three spreadsheets you gave me, and I'm ready for more." A few minutes later I received an absolutely astonished phone call.

Long story short, I had all the spreadsheets entered by the end of the day (unfortunately putting the rest of the interns out of a job!), got paid a decent sum for the thousands of $ I saved them, and received a permanent position, where I'm still working today :)

I have a friend that is a girl that loves to snapchat everything she does, the problem is that she now works (in apprenticeship) at a huge company and she snapchats her desktop who has a lots of post-it notes and her screen which is showing excel spreadsheets with customers data and stuff...
And she does this on a regular basis btw
Who can be possibly that dumb...

I've been fairly lucky with my bosses of late since I've progressed in my programming career. But my absolute worst boss was when I first started working in an office environment doing data entry. My boss at the time was terrible, and she was always against innovation or process improvement. She also always tried to make herself look good and taking credit for the accomplishments of others. If she screwed up it was your fault, and she was "always buried in email" so she could never respond to you for pto requests, or escalation of issues between departments. My whole family pretty much worked in various roles in the department and she fired my brother after my mother left the company for no reason, saying he was "sleeping", but I worked right next to him and he's tall and had to slouch just to comfortable see his computer screen since the same manager refused to approve work station improvements for him.

Our workflow was to receive daily spreadsheets of health care claims that we had to manually process and enter into the system. So being the lazy innovator that I am, and trying to find ways I can efficiently work, I delved into studying visual basic and programmed a few functions and tools in excel to analyze, highlight, and process some of the data since the claims on the spreadsheets always had a specific pattern. This was all before I had any formal education in computer science so the program was very basic and clunky but it tripled my efficiency. When I brought it up to my boss to spread it among the rest of our team so they could use it after a short 20 minute training, she struck it down saying any training or use of it would be a waste of resources since it was too technical and complex to be used and if I were to keep improving it or use it I would be fired. It was literally copy and paste from one spreadsheet to the other en masse and clicking a button to sort and fill in the blanks. Eventually I showed it to the director of the department when working on a large data entry project with her, and I was later offered a job as a technical analyst where I was responsible for the codebase that generated the reports for the department and specifically all the reports my old boss used where I would occasionally mess with her to get back at all the crap she gave me and my brother. Since all the reports were blind carbon copied to everyone, I would send out her reports on a delay while everyone else got them on time. It eventually got her in so much crap she had to step down as a manager. She still works in the same company that I started working at again earlier this year, and like the many careers she's ruined she eventually ruined her own within the company 😂

Boss: Hey you're great with excel right?
Me: Um... I ---
Boss: Great! Work on these spreadsheets for me
Me: ¯\_(ツ)_/¯

It's getting close to that time of year when we are all encouraged to think of others and spread joy around the world. I've decided to go against my usual snarky/anti-social nature, and do something to help others this year.

I'm announcing the practiseSafeHex charitable fund, to give back and help others.

This fund will invest in cutting edge medical research to detect the genetic abnormality in humans that results in project managers not being able to comprehend the simplest of concepts.

Together we can find the reason why the concept "more meetings = less work" is uncomprehendible.

Together we can discover why we can't use an automated bot to generate reports, instead of spending hours in excel spreadsheets.

And together we will find a reason why the answer to the question "can we please just try it?" is always "No".

We do this not for ourselves for short term gains, we do this for the greater good. Together we can find the cause and build a test to filter these people out. So that never again will stressed out developers have to deal with these petty ridiculous issues.

Together, we will solve this!

Thanks,
practiseSafeHex, CEO and managing director of the practiseSafeHex charitable fund for the betterment of developer sanity

After returning back from the company we were purchasing a new phone system (hardware+software, $100K+, kind of a big deal)
VP: “I need the new phone system software integration for our CRM by next week. I need to demo the system for the other VPs”
Me: “No problem. Were you able to get their API like I asked?”
VP: “Salesman didn’t know for sure what that was, but he said all the developer software documentation is on their site.”
Me: “Did he give you a URL? Their main site is all marketing mumbo-jumbo. I assume there is another one specific for developers.”
VP: “Yea, he might have said something, but I don’t understand why you need it. The salesman said the integration would be seamless. He showed me several demos.”
Me: “No, I mean I need to know, is the API a full client install? a simple dll? is this going to be a web service integration? How will I know what to program against?”
VP: “I think I heard him say something about COM? Does that sound like an API?”
Me: “It’s a start. Did he provide you anything, a disk, a flash drive, anything with the software?”
VP: “No, only thing he told me was our CRM integration would be seamless and our development team would have no problems.”
Me: “OK..OK…I get it…he’s a salesman. Is there an 1-800 number I can call? A technical support email address? Anyone technical I can reach out to?”
VP: “Probably, but I don’t understand what the problem is. I need the CRM integrated by next week. I gave the other VPs a promise we would get it done. I do not break promises.”
Me: “Wait…when are we installing the new system?”
VP: “Well, the purchase order will be cut at the end of the month’s billing cycle, the company has about a two month turnaround time to deliver and install the hardware, so maybe 3 months from now? Are you going to be able to have the integration ready for next week?”
Me: “If we won’t see any of the hardware for 3 months, what exactly am I integrating with?”
VP: “That API you wanted or whatever it is. COM…yea, it’s COM. I was told the integration would be seamless and our developers would have no problem. I don’t understand why you can’t simply write the code to make it work. Getting the hardware installed is going to be the hardest part.”
Me: “OK, so I have no documentation, we have no hardware, no software, and no idea what this ‘seamless integration’ means. I’m afraid there isn’t anything I can do right now. ”
VP: “Fine!...I’ll just have to tell the other VPs you were not able to execute the seamless integration with the CRM.”
Which he did. When the hardware+software was finally installed, they hired consultants (because I “failed”). I think the bill was in the $50K range to perform the ‘integration’ which consisted of Excel spreadsheets (no kidding). When approached with the primary CRM integration, the team needed our API documentation, a year’s development time and $300K. I was pissed off enough, and I had the API documentation, I was able to get the basic CRM integration within 3 days. When an agent receives a call, I look up the # in our database, auto-fill the form with the customer info, etc. Easy stuff when you have the documentation.
The basics worked and the VP was congratulated by ‘saving’ the company $300K. May or may not have been bonuses involved, rumors still out on that one, but I didn't see em'. Later my manager told me the VP was really ticked that I performed the integration ‘behind his back’, but because it was a success, he couldn’t fire me.

In the begining of time, when The Company was small and The Data could fit in some fucking excel sheets, Those Who Came Before implemented some java tool to issue invoices, notify customers and clear received payments.

Then came the Time Of The Great Expanse, when The Company grew to unthinkable levels. Headcount increased with each passing day, and The Data shows that everything was going great!

But when the future seemed bright, came The Stall-Out. The days when The Company could not expand as fast as it did before. And Those Who Came Before left, abandoning their Undocumented Java Tool to its own luck.

Those who came after knew nothing of the inner workings of the Undocumented Java Tool. They knew only that the magical Jar would take a couple fucking excel spreadsheets and spit out reports and send emails like magic.
And those were The Dark Days.

In the darkness, The Data grew to be a monster. Soon a fucking excel spreadsheet could not hold The Data contained any longer. Those Who Came After, fearing the wrath of The Undocumented Java Tool, dared not mess with its code. Instead, they fucking cut away the lowest volume transactions from the fucking input spreadsheet, and left the company to report the unbilled invoices as "surprise losses". Fucking script kiddies, were Those Who Came After.

Then, at The Darkest of Days (literally, Dec 21st), marched into the project The Six Witchers, who fear not the Demon of Refactoring.

This story is still unfolding. Will The Six Witchers manage to unravel the mysteries of The Undocumented Java Tool? Will they be able to reverse engineer the fucking black box, and scale it's magic into a modern application?
Will they decrease revenue forecasting error by at least 2% in a single strike?

Only the future will tell.

So day 2 of my python automations.

I have spent 6 hours and a lot of stack overflow “research” to saved myself 45 minutes a day with file downloads (web & ftp and outlook emails), excel spreadsheets and data manipulation macros, all stored in a nice tidy zip file at the end.

Now to find a way to send to a web server for digestion 😎

And all of this in a poor 90 lines 😧

God damn why didn’t I look into this earlier?

Entire fucking world:
Shift + Enter == New Line

Spreadsheets:
Alt + Enter == New Line

Spreadsheets are America of digital world.

Thanks to Devrant I've learned about rubber duck debugging. Never heard of it before! It reminds me of a story many moons ago when I worked for a certain multinational company as a business analyst. The company brought in some consultants who basically stole the work my team was already doing on a big project (a horrendous series of spreadsheets linked to data coming from the core systems) and sold it back to the company for an insane amount of money as their idea.

When they launched the new product, the team I was in was asked to test and review it. It took my colleague ten seconds to bring the whole thing to its knees and trigger a corrupt data export back into the core systems. Bearing in mind this external company somehow managed to charge tens of thousands of pounds. So what did my colleague do? Hack the system? Some kind of complicated sabotage? Nope. He typed "FISH" into one of the spreadsheet cells! Thus the FISH test was born.

That day I learned several things: it's easy to break things with a fish; the importance of validating your input; and the satisfaction of showing up the smug bastards who stole your ideas and work.

Our team makes a software in Java and because of technical reasons we require 1GB of memory for the JVM (with the Xmx switch).
If you don't have enough free memory the app without any sign just exits because the JVM just couldn't bite big enough from the memory.
Many days later and you just stand there without a clue as to why the launcher does nothing.
Then you remember this constraint and start to close every memory heavy app you can think of. (I'm looking at you Chrome) No matter how important those spreadsheets or illustrator files. Congratulation you just freed up 4GB of memory, things should work now! WRONG!
But why you might ask. You see we are using 32-bit version of java because someone in upper management decided that it should run on any machine (even if we only test it on win 7 and high sierra) and 32 is smaller than 64 so it must be downwards compatible! we should use it! Yes, in 2019 we use 32-bit java because some lunatic might want to run our software on a Windows XP 32-bit OS. But why is this so much of a problem?
Well.. the 32-bit version of Java requires CONTIGUOUS FREE SPACE IN MEMORY TO EVEN START... AND WE ARE REQUESTING ONE GIGABYTE!!
So you can shove your swap and closed applications up your ass but I bet you that you won't get 1GB contiguous memory that way!
Now there will be a meeting about this issue and another related to the issues with 32-bit JVM tomorrow. The only problem is that this issue only occures if you used up most of your memory and then try to open our software. So upper management will probably deem this issue minor and won't allow us to upgrade to 64-bit... in 20fucking19

know what pisses me the fuck off? when the manager of another department jumps over me and goes straight to the head of my department for a request that they want from MY department.

Currently, there are 2 stupid bitches that insist on doing this fuckery. One of them keeps getting owned by our DBA since for whatever reason she sends her requests to me, just for the DBA to remind her that I ain't giving her access to shit and bla bla

The other is the head of the human resources department. It goes like this: sends wrong data, task gets delayed cuz we have to sort her shit, gets impatient, bitches at head of department and his boss about us taking long(bitch 3 hours ain't long and your shit ain't critical) just for me to reply back with images and LOOK FUCKTARD YOU MESS THIS UP red arrows showing how what she did was wrong and I had to fix it for her.

Sends a reply back only to me saying thanks, ah no pendeja, I will forward aaaaaaall of that shit to everyone else, tried throwing me under the bus? well now ima do it to you.

And fuck those 3 applications you requested, have fun adding shit manually through spreadsheets and then go eat shit and die.

900k+ deal with a huge customer.

All we need is a spreadsheet printed out

Two senior people could not figure this out for a solid hour

"hey you work with computers"

So I'm here printing spreadsheets...

The first program that was used at a company.

I wrote it on suggestion of my father to help with simplifying calculations for rental machines at his work and once finished it reduced time from start to finished report from 2-3 days down to 30 minutes, and corrections could be done in minutes instead of starting all over.

It also featured saving and loading old reports.

And for context, this was 1987 and excel did not exist and existing spreadsheets was not nearly as easy to use.

Fuck non-IT departments that use Microsoft Access and think database tables are like Excel spreadsheets.

Spent yesterday afternoon trying to extract the logic from a VBA macro written by civil engineers so that we can encode the same logic in the applications we're writing.

Sweet Jesus.

500 lines of meaningless variable names and loops reading values from various spreadsheets into a 3 dimensional array(!).

On top of that, now that I kind of understand what it's doing, I don't think it's ever worked properly.

Anyone else got some funny terms in their office like:

Rocketsurgeolist: Guy that knows everything about everything but hardly manages to pull anything off.

Maffamagician: A person that battles with math and spreadsheets

Marketard: Marketer

Fuck product managers.

Just the other day I was discussing our progress so far and this product manager shows us the timeline and his vision for the project.
Ngl, I haven’t seen such an ambitious fuck for so long. He doesn’t know how to do anything other than fucking spreadsheets. The only problem with his plan is that we don’t even have the team, just 2 pity devs carrying it.

I still don’t get it, why the fuck would a company with 2 devs need a product manager?

Longest I've worked without rest + why?

Over 24 hours. Why?

In our old system, the database had fields, for example, a customer like Total97, Total98, etc. to store values by year (or some date-specific value).

Every January 1, we had to add fields to accommodate the upcoming year and make the appropriate code changes to handle the new fields.

One year the UPS shipping rates changed and users didn't want to 'lose' the old rates, so they wanted new fields added (Rate98, Rate99, etc) so they could compare old vs. new. That required a complete re-write of most of the underlying applications because users wanted to see the difference on any/all applications that displayed a shipping rate. I'll throw in asking 'why?' was often answered with "because we pay you to do what we say". Luckily, we had already gotten to work on a lot of this before January 1st, so we were, for the most part, ready.

January 1st rolls around (we had to be in the office at 3:00AM), work thru changes, spend some time testing, and be done before noon. That didn't happen. The accounting system was a system that wasn't in (and had never been) in scope, and when we flipped the switch, one of the accountants comes into the office:
E: "Guys? None of our Excel spreadsheets are working. They are critical to integration with the accounting software"
Us: "What? Why would you be using Excel to integrate with the software instead of their portal?"
E: "We could never figure it out, so we had a consultant write VBA scripts to do the work."
Us: "OK, a lot of fields changed, but shouldn't be a big deal. How many spreadsheets are we talking about?"
E: "Hundreds. We have a separate spreadsheet for every integration point. The consulting company said it scalable, whatever that means."
Us: "What?! Why we just know hearing about this!?"
E: "Don't worry, the consultant said making changes would be easy, let me show you, just open the spreadsheet..click here..<click><click><click>...ignore that error, it always happens...click that <click><click><click>.."
Us: "Oh good lord, this is going to take hours"
E: "Ha! Probably. All this computer stuff is your job and I've got a family to get to. Later"
Us: "Hey 'VP of IS', can we go home and fix these spreadsheets as-needed this week?"
VP-IS: "Let me check with 'VP-FS'"
<few minutes later>
VP-IS: "No, he said Excel is critical to running their department. We stay until Excel is fixed."
Us: "No, no...its these spreadsheets. I doubt FS needs all of them tomorrow morning."
VP-IS: "That's what I said. Spreadsheets, Excel, same thing. I'll order the pizza. Who likes pepperoni!?"

At least he didn't cheap out on the pizza (only 4 of us and he ordered 6 large, extra pepperoni from one of the best pizza places in town)

One problem after another and we didn't get done until almost 6:00AM. Then...

VP-IS: "Great job guys. I've scheduled a meeting at 8:00AM to review what we did so we can document the process for next year. You've got a couple of hours. Feel free to get some breakfast and come back, or eat the left over pizza in the breakroom fridge. There is a lot left"
Us: "Um...sorry...we're going home."
VP-IS: "WHAT!!...OK...fine. I'll schedule the meeting for 12"
Us: "No...we're going home. We'll see you tomorrow."

Instead of asking how old people are, how about this:

Post the specs of the first computer you regularly used. I will start.

Tandy 1000 SX. Not one, but TWO 5 1/4" floppy drives. An 8088 CPU and 640K of RAM. The operating system was MS-DOS 3.2, which was always in the A: drive.

We used it to make papers for school in Wordstar, and my parents made spreadsheets in Lotus 1-2-3. We learned to type on it. We played Space Quest, King's Quest, Carmen Sandiego, and Lords of Conquest on it. We transcribed BASIC programs from the, "BASIC Training" column in 3-2-1 Contact magazine.

We LOVED that computer.

So my first dev job has ended up as fucking dat entry after one of the contractors got bored and left.

I’m an SQL Developer (at least that is my job title) and all I do is fuck around with exchange rates in spreadsheets.

The only “proper” development work they gave me hasn’t even been applied to the test server yet (should have been done over a month ago)

And the project they gave me to look into migrating from sourcesafe to GitLab has ground to a halt.

I’ve been here 4 months and I want to quit already, that must be a record (for me at least)

I was keen an full of energy, willing to do some work from home etc. But a little piece of me dies every time i open Excel

Corporate America wasting billions stuffing database projects into spreadsheets cause it's what they know. Quickly becomes an unmanageable mess. Low hanging fruit.

When you have notepad++ with 30+ files open, Excel spreadsheets on the taskbar, One Note annotations all over the screen, some email drafts pending in Outlook, but you can't remember where you Ctrl+v'd the fucking snippet.. alt + tab for ages to find it pasted in the browser's url bar lol

I love coding. I enjoy the clickety-click of my keyboard and the joy of creating code that does something, to help the world be a better place. So why does upper management feel the need to bog me down in process paperwork, tickets to count my widgets, and endless endless emails and spreadsheets to prove that I have work to do. What are the time savings, priorities, cost avoidance... Blah blah blah... #IdRatherBeCoding :)

FIRE DRILL!!!!!

Customer who decided to deploy our system in the middle of their busiest time ... and kinda ad hoc-ed their ... human processes (not sure what to call it). Just to get by, and then sort of let things rot.

So last week they contact us and say "OMG some poor soul at this company was spending hours making spreadsheets to track what they were doing... and they keep fucking it up because it's nigh impossible to get right".

Real story, big shake up at the company, and someone said "lets look at our process" and they discovered "holy fuck we have this software but we're doing shit like it's the damned civil war".

This naturally raised questions about the competence of the folks we work with ... who chose our software, and thus our software.

So now we're flushing out all the stuff we asked the customer to figure out months ago that is usually done via a months long implementation / integration ... in a few days. Also ... I'm making some new things for them.

WEEEEEEEE

Granted, we're billing them like mad for this so no big deal really.

I work for an investment wank. Worked for a few. The classic setup - it's like something out of a museum, and they HATE engineers. You are only of value if work on the trade floor close to the money.

They treat software engineering like it's data entry. For the local roles they demand x number of years experience, but almost all roles are outsourced, and they take literally ANYONE the agency offers. Most of them can't even write a for loop. They don't know what recursion is.

If you put in a tech test, the agency cries to a PMO, who calls you a bully, and hires the clueless intern. An intern or two is great, if they have passion, but you don't want a whole department staffed by interns, especially ones who make clear they only took this job for the money. Literally takes 100 people to change a lightbulb. More meetings and bullshit than development.

The Head of Engineering worked with Cobol, can't write code, has no idea what anyone does, hates Agile, hates JIRA. Clueless, bitter, insecure dinosaur. In no position to know who to hire or what developers should be doing. Randomly deletes tickets and epics from JIRA in spite, then screams about deadlines.

Testing is the same in all 3 environments - Dev, SIT, and UAT. They have literally deployment instructions they run in all 3 - that is their "testing". The Head of Engineering doesn't believe test automation is possible.

They literally don't have architects. Literally no form of technical leadership whatsoever. Just screaming PMOs and lots of intern devs.

PMO full of lots of BAs refuses to use JIRA. Doesn't think it is its job to talk to the clients. Does nothing really except demands 2 hour phone calls every day which ALL developers and testers must attend to get shouted at. No screenshare. Just pure chaos. No system. Not Agile. Not Waterfall. Just spam the shit out of you, literally 2,000 emails a day, then scream if one task was missed.

Developers, PMO, everyone spends ALL day in Zoom. Zoom call after call. Almost no code is ever written. Whatever code is written is so bad. No design patterns. Hardcoded to death. Then when a new feature comes in that should take the day, it takes these unskilled devs 6 months, with PMO screaming like a banshee, demanding literally 12 hours days and weekends.

Everything on spreadsheets. Every JIRA ticket is copy pasted to Excel and emailed around, though Excel can do this.

The DevOps team doesn't know how to use Jenkins or GitHub.

You are not allowed to use NoSQL database because it is high risk.

Google acquired two interesting products companies last week.
One is making customizable phone apps from spreadsheets the other is gathering sales data from local shops.

appsheet and pointy

At this point I think they’re still missing code editor. Microsoft have visual studio and amazon as always was first and acquired c9.io when vscode was one year old.

How the fuck they missed the code that would run remotely on multiple machines should have ability to connect to one node with debugger after they fucked docker with their k8s.

The Zen Of Ripping Off Airtable:
(patterned after The Zen Of Python. For all those shamelessly copying airtables basic functionality)

*Columns can be *reordered* for visual priority and ease of use.

* Rows are purely presentational, and mostly for grouping and formatting.

* Data cells are objects in their own right, so they can control their own rendering, and formatting.

* Columns (as objects) are where linkages and other column specific data are stored.

* Rows (as objects) are where row specific data (full-row formatting) are stored.

* Rows are views or references *into* columns which hold references to the actual data cells

* Tables are meant for managing and structuring *small* amounts of data (less than 10k rows) per table.

* Just as you might do "=A1:A5" to reference a cell range in google or excel, you might do "opt(table1:columnN)" in a column header to create a 'type' for the cells in that column.

* An enumeration is a table with a single column, useful for doing the equivalent of airtables options and tags. You will never be able to decide if it should be stored on a specific column, on a specific table for ease of reuse, or separately where it and its brothers will visually clutter your list of tables. Take a shot if you are here.

* Typing or linking a column should be accomplishable first through a command-driven type language, held in column headers and cells as text.

* Take a shot if you somehow ended up creating any of the following: an FSM, a custom regex parser, a new programming language.

* A good structuring system gives us options or tags (multiple select), selections (single select), and many other datatypes and should be first, programmatically available through a simple command-driven language like how commands are done in datacells in excel or google sheets.

* Columns are a means to organize data cells, and set constraints and formatting on an entire range.

* Row height, can be overridden by the settings of a cell. If a cell overrides the row and column render/graphics settings, then it must be drawn last--drawing over the default grid.

* The header of a column is itself a datacell.

* Columns have no order among themselves. Order is purely presentational, and stored on the table itself.

* The last statement is because this allows us to pluck individual columns out of tables for specialized views.

*Very* fast scrolling on large datasets, with row and cell height variability is complicated. Thinking about it makes me want to drink. You should drink too before you embark on implementing it.

* Wherever possible, don't use a database.
If you're thinking about using a database, see the previous koan.

* If you use a database, expect to pick and choose among column-oriented stores, and json, while factoring for platform support, api support, whether you want your front-end users to be forced to install and setup a full database,
and if not, what file-based .so or .dll database engine is out there that also supports video, audio, images, and custom types.

* For each time you ignore one of these nuggets of wisdom, take a shot, question your sanity, quit halfway, and then write another koan about what you learned.

* If you do not have liquor on hand, for each time you would take a shot, spank yourself on the ass. For those who think this is a reward, for each time you would spank yourself on the ass, instead *don't* spank yourself on the ass.

* Take a sip if you *definitely* wildly misused terms from OOP, MVP, and spreadsheets.

Reminder, include legal language in next project that says if we're using JIRA then we're using JIRA and not a thousand emails with requirements embedded in spreadsheets and PowerPoints.

So I created a little script for my mother because otherwise she had to combine 70 spreadsheets manually, I just couldnt sit there and do nothing. So I wrote a simple Python script in like 30 mins, decided that it needed a GUI because in the end it is for my mother. So wrote a GUI and partly learnt PyQt during that in an hour, which was all working fine.

Then I got to the point where I actually had to hand it over to my mother, preferably as an executable so that there is no hassle at all. So found this tool, Pyinstaller which seems to work great. Created an executable with all the dependencies and stuff in a single file, it worked on my win10 machine (because I developed on Linux of course). So I distributed it to her and she immediately gets an error. Of course there is no description and stuff because I made it a simple program, no log files and such. But fortunately she told me that it errorred when she wanted to run it, so I knew it had to be due to the executable.

Turns out she is still using windows 7 at work, which of course is different that windows 10 and here I am at 11pm, installing updates on a fresh windows 7 machine just to create a new build in that environment and make it work on her machine.

Fuck you, windows update. I swore to never see that ugly ass progress bar again, but yet here I am. Send halp.

I am almost just at the point where Im going to teach my mother how to run a python application from the command line because wheels are actually available for all python dependencies (instead of compiling them)!

Are there better python executable creators out there for wincrap?

Argh!!!! I'm too dumb to compare two spreadsheets. I want to know which of the 2000 employees left or joined the company since last year. But the employee spreadsheet db export is not in the same order as the last years. Is there any bash shell magic or something else than excel that could help me?

Guys, I think they are asking about Big Data Loss. People thought it's about Data Loss.

My Big Data Loss experience is when everyone in Hong Kong starts talking about big data using spreadsheets. So lost.

I've decided to, as an educational exercise, implement DEFLATE compression / decompression and zip file format, and eventually tackling Excel format (which is just a .zip) so I can generate true excel spreadsheets (instead of .csv files) client-side using JavaScript.

Are there already libraries that do this? Yes, but then I don't get to try to implement these interesting algorithms. Is it currently 1 AM? Yes. Do I have work tomorrow? Also yes.

If I don't just fall flat on my face, I'll post updates!

Well, that's it, folks. Got a job offer, one I might accept, after some tweaks.
I've been a bit more than sixty days unemployed. And in no hurry.
But there is one thing that uneases my mind, though.
I've been a dev, I've been a graduate researcher, I've been a TA and I've been a tech lead, but now the industry wants me in a primarily management position.
I like to code, even if that makes me miserable sometimes. I like to solve problems. Math problems, engineering problems.
But I OOH SOOOO MUCH HATE when I have to deal with leadership who can't tell heads or tails on a coin toss. Who can't make a decision and deal with the consequences. Who can't handle bad times, searching for someone to blame more than searching for a solution. Who can't listen to advice, who thinks a commanding viewpoint is always better than many compiled intelligence reports.
Who don't wanna even think about the possibility that they might not know something, much less that someone on their team might know some subject better than they do.
Frankly, I think might I hate bad leadership more than I like coding.

So if the offer is to have the patent to tell productivity thespians where to shove their stupid spreadsheets, even at the cost of hardly ever issuing a git command, then I think it might be the time.
I hope it is not a mistake, but I can always course-correct my career later. I'm in my late 30s, I still have, like, 40 years of labour ahead of me (assuming medical advancements in the meantime).

So, yeah, I'm joining the other side. But trying not to become them.
May sudo have mercy upon my uid.

I currently work on a legacy system for a company. The system is really old - and although I was hired as a programmer, my job is pretty much glorified data entry. To summarise, I get a bunch of requirements, which is literally just lots of data for each month on spreadsheets and I have to configure the system to make it work, which is basically just writing a whole bunch of SQL scripts.

It’s not quite as simple as that, because whoever wrote the system originally really wrote it backwards, and in fact, the analysts who create the spreadsheets actually spend a fair bit of time verifying my work because the process is so tedious that it’s easy to make a mistake.

As you can guess, it is pretty much the most boring job ever. However, it’s a full time job with decent pay, and I work remotely so I can stay home with my son.

So I’ve been doing it for about 18 months and in that time, I’ve basically figured out all the traps to the point where I’ve actually written a program which for the past 6 months has been just doing the whole thing for me. So what used to take the last guy like a month, now takes maybe 10 minutes to clean the spreadsheet and run it through the program.

Now the problem is, do I tell them? If I tell them, they will probably just take the program and get rid of me. This isn’t like a company with tons of IT work - they have a legacy system where they keep all their customer data since forever, and they just need someone to maintain it. At the same time, it doesn’t feel like I’m doing the right thing. I mean, right now, once I get the specs, I run it through my program - then every week or so, I tell them I’ve completed some part of it and get them to test it. I even insert a few bugs here and there to make it look like it’s been generated by a human.

There might be amendments to the spec and corresponding though email etc, but overall, I spend probably 1-2 hours per week on my job for which I am getting a full time wage.

I really enjoy the free time but would it be unethical to continue with this arrangement without mentioning anything? It’s not like I’m cheating the company. The company has never indicated they’re dissatisfied with my performance and in fact, are getting exactly what they want from employing me.

I think the most excited I've been about my code was when I wrote my first own library to communicate to Google spreadsheets via their rest API.
I didn't find any working modules in perl for that so I wrote my own. Still using it every now and again! 😁

Every time basically.

Coming up with complex Excel formulas.
Cooking products in a weekend.
Setting up and printing a shit ton of spreadsheets in a minute with a VBScript.

Yep, every time.

Genuine problem, not a rant

Started a new frontend developer/designer/graphic designer job recently. I feel technically capable, no problem there. Just noticing a pattern of repeatedly missing deadlines.

Its a very busy office, with various people all coming to me with things they need me to do. Never worked in an environment so busy before.

Doesn't help that they force me to manage my tasks by spreadsheets, communication by email, deployment by filezilla and no version control, but not convinced I'd still meet deadlines if I had a better setup.

My professor is currently promoting excel spreadsheets with add-ons as a front end for business intelligence.

Automate this!

I'm an aspiring coder working some chappy administrator job just to pay the bills for now. My boss found out that I may actually be more computer literate than I let on.

Boss: "I want you to make X happen automatically if I click here on this spreadsheet"

Me "X!? That means processing data from 4 different spreadsheets that aren't consistently named and scraping comparison info from the fronted of the Web cms we're using"

Boss: "if you say so.. Can you do it?"

Me: "maybe.. Can I install python?"

Boss: "No..."

Me: "what about node.js or ruby?"

Boss: "no.. I don't know what you're talking about but you're not installing anything, just get it done"

Me: "Errm Ok.."

So here I am now, way over my head loving the fact that I'm unofficially a Dev and coding my first something in Powershell and vb that will be used in business :)

Sucks that I still have to keep my regular work on target whilst doing this though!

google drive API for spreadsheets

Fuck python Excel libraries. Had to write a spreadsheet formatting/filtering script to automate content generation. Definition of too much work. On the plus side just auto formatted 5000 spreadsheets in seconds.

one day aliens will study the ruins of our civilization and fail to understand the purpose of spreadsheets. either that or they'll know more than we do now

Alternate job?
Assuming I didn't go to the university, probably some office job where I mostly had to organize data, I enjoy making and maintaining spreadsheets, even if at a basic level.

I started a new job in engineering at CenturyLink a few weeks ago - before this I was doing IT for dental offices in the greater Seattle area. Anyway, I wanted a registry tweak to make Excel open files in separate windows, instead of putting them in one. Today I was told by our IT that you need 16GB of RAM to open multiple Excel spreadsheets in separate windows. Suffice to say I told him he was insane and ended the chat.

And yes, I know there are ways to do it anyway, like opening new instances of Excel and then opening the file inside of Excel, but that's unnecessary clicks, dammit.

The analytics guy just sent me updated tracking specs for a web site.

There are two sheets in the file: "Custom Events LATEST" and "Custom Events updated". This is already confusing enough.
One of them has comments like "I'd like this to be amended", but the event specs described are the same as the ones implemented.

I asked him for clarification, turns out he wants the ones marked in black to be updated, the ones that don't have any label saying they don't need to be updated.

This is also a guy who for at least 2 years has been making columns in spreadsheets wider not by just widening them, or merging multiple cells, but by just letting text overflow into other cells.

I do wonder how some people manage to keep a job.

Have you guys had any trouble trying to get the BAs to use JIRA for issue reporting/management? The dev team just upgraded to new JIRA and we are getting hard pushback... they're wanting to stick with 1-4 excel spreadsheets on a share drive...

I was ten years old. At this point, despite being in my early 20's, I've officially been programming more than half of my life. From the first moment I knew that this was possible, that we, as software engineers, can do what we do... I've been quite literally obsessed with the idea.

I don't like to give other people credit for the events in my own life, but there is one thing that, more than anything else at the time that lead me down the path of computer science, directly lead me to where I'm at today. If you're at all interested in film and cinema (not to mention programming) then you've undoubtedly heard of The Social Network, directed by David Fincher. Amazing film, I'd recommend it to anyone based off of the film alone, but for me that movie holds a special place in my heart.

My mom took me to see it that movie in theaters when it came out, I would not stop bugging her to take me, there was just something about the founding of Facebook that... Sparked my young imagination. I swear to you that I didn't blink for the entire time I was in the theater watching it. It blew my mind, not only that you could do that kind of stuff with computers, but that you could actually make a lot of money working with computers as well... Ten year old me had different priorities in regards to programming 😂 Starting the moment I got home from the theater, I dedicated my life to learning everything I could about computers. Originally my goal was to, shock of all shocks, create a social networking site for me and my friends to use. I still like to brag about it to this day, but that project eventually became my groups final project in our computer class in Middle School. It was funny, middle school computer class, I had already been programming a few years by that point and was rather proficient in PHP. There were kids submitting literal spreadsheets in Excel as their final project, a few static HTML pages, that sorta jazz. My group and I submitted a full fledged twitter clone, with complete functionality. We got 100% on the project 😂😂

My reasons and interests have changed over the years. For example, I'm not particularly interested in creating a social media application these days, and I don't program because I think it'll make me rich one day (though the hopes always there) but the one thing that hasn't changed since that night I sat enraptured in the beautiful cinematography of David Fincher and facepaced dialogue of Aaron Sorkin, is the complete and total fascination with computers and technology. For that reason The Social Network will forever be my favorite movie.

Boom, my boss agrees that the work I’ve spent the last 3 months on cross checking spreadsheets, manually inputting 100s of records into the system, then closing them and inputting more records isn’t the best way to do this particular task.

As the process wasn’t designed for this.

So I’m getting to build a new program that will integrate with the existing software, but make the job easier.

It’s not going to be easy, the software only supports web services so no apis, and it is massively lacking in documentation, but hey, I actually get to do some development work.

And there is no deadline, but I’ll probably knock up proper requirement gathering docs etc, so it gets done properly

What is the best free Office software for general odds and sods (mostly using Word, sometimes simple spreadsheets)?
Libre Office, Open Office, Free Office?

I tried Office 365 online - it's great but I want to be able to click on a file anywhere on my computer, and not have to upload it to onedrive first.

Thanking you.

Spreadsheets will be added until effectivity improves

TL;DR how much do I charge?

I'm freelancing for the first time; regularly, I get paid a salary.

I'm freelancing as a donation: the hours I put into this work directly translate to deductions in my tax. I don't get paid any money directly.

I'm doing some web-based enterprise software for an organization. Handling the whole process from writing responsive front-end code to setting up the server and domain for them and even managing myself. So full stack plus dev ops.

My normal salary is $31 an hour and at work I do less. I largely do maintenance for existing applications plus some very minor new systems design. I don't do any server management (different team) and I damn well didn't buy the domain names for my company. So I think it's safe to say I'm taking on a drastically larger role in this freelance gig.

My moral dilemma is the organization will basically say yes to any price - because they don't pay it, the government will (up until the point I pay 0 taxes, I suppose)

I've done some minor research on what other freelancers charge for somewhat similar things and I get pretty wildly varying results. I've seen as low as $20/hr but I really doubt the quality of such a service at that price.

I'm thinking around $50 USD an hour would be a fair price. For even further reference besides my actual salary, I will say that I am in a urban / suburban part of Florida, where developers are very hard to find locally.

Is $50 too high? Too low? This is a very complicated system with (frankly excessive) security practices and features. Before this they had a handful of excel spreadsheets in a OneDrive folder.

The boss says: "Spreadsheet structure must be the same of this other app".
There is no documentation of the other software so:
• try some different input parameters;
• compare the spreadsheets;
• find a possible (and temporary) solution.
I do not like Excel.
😤😤😤😤😤😤

Anyone done much iterating through spreadsheets in node?

I haven't done it before, I don't expect it to be super hard, but at the same time I'm wondering if anyone here has gone down this path and found a route they liked, tips, etc.

So, some data need to be prepared during the summer and the diverse departments' elected data processors got shared in a Google spreadsheet they will need to fill with some basic data IT needs. Simple, straightforward data entry, with nothing private nor confidential. Just another divide-and-conquer-style large amount of data to enter & organise, that's all.

Today, I received a new comment notification as the owner of the spreadsheet. You can imagine my surprise when I saw that, for some f*cked up reasons, one of the guys just wrote the super-admin username & pw for one of the main data systems we use in a freaking comment in the spreadsheet... WTF...
Oh, and also, juuust in case, he also wrote the pin code that is normally required to pass through the device-check when you log-in as a super-admin from an unknown device and/or location.

Fortunately I could catch it on time, but this just ruined half of my day.
I am supposedly on freaking annual leave. Ha Ha. Ha.

Rather than using the project management software that the company has spent the past year getting set up and stuck into, the new ops manager seems to think that faffing around in Google Sheets and making pretty schedules is the way forward.
If you're doing some work that's in your actual job list, but not in the new pipeline, ohhhh boy.

Forced to do GangBang with Google Spreadsheets.

imagine you "manage" your applications firewall rules by writing them into spreadsheets and sending them to the fw-admins to implement them

imagine they don't implement exactly what you tell them / implement rules for you that you did not ask for

also imagine it is crucial that you have a reliable source of information about what firewall rules are and are not implemented for your application, because the firewall-guys cant simply check and tell you what rules are implemented for your application

:o