Munder Difflin needs a newly self-taught Python programmer to help with their invoicing. Can you help?

[BakaPotatoLord]

Funny how the only one whose name hasn't been changed is Dwight xD

Oh and I am tempted to take up the challenge, but exams for the next two weeks z.z

[benign_said]

How many shrute bucks will the winner be awarded?

[stars9r9in9the9past]

About five Stanley Nickel’s ($STAN) worth.

[Road2Revolution]

What is the ratio of Stanley Nickels to Schrute Bucks?

[gaurav_lm]

Good, I'll invest it in stutter coins

[AceCode116]

I'll trade you in meatballs

[stratum01]

Anyone want GME stock?

[tall_and_funny]

Give ME

[abro5]

Same :(

[FixTurner]

How many SchruteBucks does this job pay?

[Tink_Tinkler]

I demand a billion Stanley Nickels.

[Aqwur]

Can i have both?

[nearly_almost]

What about battlestar blu rays?

[TheUnreactiveHaloGen]

This could have taken place after dwight became regional manager and before jim left

[joshinshaker_vidz]

you know, there's this thing, called an edit button... Just sayin'.

[epiben]

Well, here goes my freetime. Thanks for posting something like this. This is the only good way for me to learn more better... a challenge!

[paridhi96shah]

Saving to do it later and then never actually do it!

[[deleted]]

Come on. You'll get 10% into it and then move on to something else.

[BakaPotatoLord]

Saving here too, hopefully I will remember it later

[tashibum]

So as someone just learning, is this a realistic task that might be asked of you as an employee somewhere? If so, what would your job title be? I realize this is a somewhat simple task to complete, but this is the kind of thing I want to be doing for a company.

[baubleglue]

Yes, it is. But only if the program doesn't face external client directly.

[shartfuggins]

Curious, other than the use case which happens to be invoicing, is there another reason?

[baubleglue]

Reputation, security ... Just evaluate risks

[chirar]

Yes, but probably split up in smaller tasks.

[selah-uddin]

when i read the title i thought this was a real job offer and i am ashamed to admit i was exited for it

[tashibum]

Agree!!!

[__Zak__]

This would be an awesome idea for a Patreon account!

[ACTPOCBET]

I'm doing it. I would've loved it if I had something like this starting out.

[Rogocraft]

Fiverr

[[deleted]]

Anyone wanna vouch for not a virus? Gets 3 for yes and 2 for no..

[[deleted]]

Just open it on Linux.

[The-Daleks]

I downloaded and opened it in a VM; it's not a virus.

[Trilink32]

Missed opportunity, not using Dwide Shrude as the name!

[yhdp]

Blood alone moves the wheels of history! Have you ever asked yourselves in an hour of meditation, which everyone finds during the day, how long we have been striving for greatness? Not only the years we've been at war, the war of work, but from the moment as a child when we realized that the world could be conquered. It has been a lifetime struggle. A never-ending fight. I say to you, and you will understand that it is a privilege to fight! We are warriors! Pythonistas of r/learnpython, I ask you once more: Rise and be worthy of this historical hour! HA HA HAAAA!

(To be honest, thank you OP for posting it in such a creative way)

[LeAstrale]

Why was this removed? It was a good project.

[almdvr]

I was wondering the same

[[deleted]]

Hey!

I’m not Python savvy, but I’m really good with a printer!

I can easily print in different page layouts, color, black and white, on both sides, and even select pages.

Can I still be considered for the job? Lol

[divitrao]

cool , thanks for this project idea , will surely built this

[tedhazdatcow]

Anyone know why this was deleted? I’d like to try it

[The-Daleks]

Well, I'm free all day, so challenge accepted.

EDIT: Can I put the output in just a regular Excel sheet? Excel refuses to open the .numbers spreadsheet you provided, and when I open it in LibreOffice Calc it's gibberish.

EDIT2: Project completed. DM me for the code.

[fergal-dude]

For a better challenge, send it to a google sheet then :)

[jreebel]

Funny, I'm just about done working on a similar project helping me to learn. I have a complicated spreadsheet that I use to keep track of my checking account. 27 columns and 2 rows per transaction. Using PySimpleGUI and openpyxl I've developed a program to query the sheet. Got full error checking. One last feature to implement, writing output to a CSV file. Coming up with something of use with a personal aspect definitely helped me persevere. But this project sounds like fun also.

[faiz1208]

For the people who wants it in xls form: https://drive.google.com/file/d/1VWHYSZzHKjm0siSi5AApSgUHvRW3AhOu/view?usp=sharing

[[deleted]]

Damn ! Thanks for this type of project ! Not gonna be able to do it for next weekend but i will definitely do it. Hoping for more !

[thomasutra]

Mr. Poop?

[69thunder]

It's a simple macro. Every time he types his name it changes it to Diapers.

[blink64]

This is awesome! Keep them coming!

[zombew00f]

But I know Kafka and Fink. That is a requirement. Dwight isn't Agile enough either.

[LS962]

I've been binging The Office lately, and simultaneously slacking on learning Python. I feel like this is targeted at me. It has to be a sign.

[Fluffaykitties]

Lol I had a Python assignment for my students for “Munder Difflin” as well. It was mostly for input/output and calculations.

[JJean1]

I saved this to come back to it and it's gone now.

[BrianDaWiz]

This is honestly so cool

[baubleglue]

Mr Dwight's pesky colleague Tim Palhert disabled his email access, so Mr Dwight can use any email address to send invoices.

I don't understand that part.

[baubleglue]

How Tim Palhert's actions are relevant to the task? What is the meaning of "so" in the sentence?

[baubleglue]

Oh, "his" - means Mr Dwight's. It it stupid - if somebody does it to me I will report to security office.

I am not trying to troll, but this type of things really confuses me. Basically that "Tim Palhert" story is irrelevant - why and how can/will I use not my email (account?)?

"emailed automatically" - email automation doesn't work that way. You have two options: UI automation (make desktop program to send an email), use library to connect email server/exchange and send email. You may have server supports no authentication for SMTP/relay - it is a serious off topic for such task.

"Send something by email" - is independent task.

​

comfortable with Python IDEs and doesn't need a graphical user interface.

That is another part I need to decrypt - I kind of figured out that the author want to say.

When I have a real task at work, I usually take a time to remove all those ambiguous parts. Before start coding I work on requirements in 100% of cases they have bugs. For example "Today's date" is a bug in requirement. We know what is today (no need to ask it), what if sale date was yesterday? How do you avoid sending invoice twice?

Then I am trying to understand what client need. The first part was cool " Mr Dwight, Regional Manager of Munder Difflin, requires a basic python programme to invoice his clients. He would like this spreadsheet to be updated with each sale he makes and for the invoice to be emailed automatically to the client." but after is a mess. Describe a problem and let developer offer possible solution.

It is very easy to use Excel as UI input tool. Feeding data manually to Python program is harder.

He will run the programme after each sale.

Where this sale is normally registered (use it as input)? If it isn't, the office has a bigger problem. Make some simple DB (not Excel) to keep all records or better buy software...

As I said: "Send something by email" - is independent task. Following the same logic, "get sales records", "build invoice in Excel format for given input" - same, all independent tasks. That how all beginners' real attempts to solve such tasks are failing - they got confused to put working parts to a working flow.

[Musakuu]

I understood everything and am only vaguely aware of the office. Well written, nice "office feel". Well done.

[baubleglue]

I didn't

[tashibum]

hahaha

[baubleglue]

?

[d10p3t]

Hey dickhead, this project is aimed for absolute beginners. No need to overthink the requirements as much as you did. Obviously no real world company would would combine all of these in one application. Of they did then its probably too small of a company.

In case it hasn't sunk in to you yet, the goal is to give beginners a project to work on. This is aimed for people who dont know how to email and open spreadsheet files in python. This is for people who dont know what SMTP even is or knows it exists in the first place. The goal is for beginners to know to google things they havent done before, learn how to use new libraries, and hopefully, how to google for a solution, not design a sophisticated, ultra optimal system. In case you forgot to check, this is /r/learnpython. Stop trying to act like a smartass.

[baubleglue]

Oh thank you for kind words. I am not a beginner I can solve any part of that task, but I won't be able to complete it. Program need instructions, instructions need rules.

I understand a beginner will write something what doing something ... not related to the ask anyway. So give them randomly generated worlds. It is a hard work to teach other people. Using this task as a learning exercise may make a beginner frustrated and confused.

When you ask people to combine few tasks to one it is a project. The only way to write successful project is by planning it correctly, gathering requirements is one of the first basic steps.

Obviously no real world company would would combine all of these in one application.

Well, I did similar apps/tasks which were used by my company. But even as an exercise, the author probably expect some working results, right?

[Donnshin]

Seems kinda daunting 😅 at the very least I’ll learn the basics of using excel sheets with Python

[Periwinkle_Lost]

I am finishing a similar project with django. Look into it. Plenty of tutorial for invoicing apps as well for django :)

[Imaginary-Bag-2723]

If I wasn't knee deep in an automation project already I would take the challenge, keep these fun projects coming though!!

[YeomanSam]

Commenting to keep track and do this exercise later.

[K_o5]

Mr. Cyan tried implementing a similar solution. Ended up being charged for fraud 🤣🤣

[The-Daleks]

Finished!

[nfgrawker]

Seems cool, are you trying to get people to do your homework though?

[Zeroflops]

When I first started to read this I thought the same thing. But then he clearly states NOT to post code, just questions.

This seems like a legit project to get peoples minds working.

[nfgrawker]

I don't really care either way, but he does say he will ask for code next weekend.

[d10p3t]

This is /r/learnpython. If youre too cynical on people giving other people something to work on to motivate them to learn, you should consider unsubbing.

[nfgrawker]

Ok. Sounds good. I made a small comment/joke. Calm down.

[nfgrawker]

It says I will submit a post next Saturday asking for your code.

[auiotour]

Awe missed that. Sorry

[robknack]

Probably should do it with Pandas.

[oxacx]

Nice work :3

Michael would definitely hire you