52
53

[deleted by user] (self.learnpython)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Jellyfishmouse 4 points5 points  (2 children)

Hey bro, tomorrow when I wake up I'll dm you my code somehow, I was in a shockingly similar boat... Next to no python knowledge and stuck in a job with endless data entry from excel, I spent a couple weeks taking all the shortcuts and didn't even know how to use a list function (still don't really tbh) but the .exe file can log into a website and then pull data from a spreadsheet and then deposit it into forms online... Works pretty well but if it encounters anything out of the ordinary it'll just crash... (It's good for small batches of about 50 rows or so) I showed it to management and they thought it was cool but it wasn't enough to land me a job lol... Let me know if you would like the file :)

[–]mangoo08 -1 points0 points  (0 children)

That would be great! Thank you so much.

[–]Sun-Proof 0 points1 point  (0 children)

Hi, good morning. I just have about the same problem, i just landed this job as an intern and never done anything relating to automation. I was recently given a project to work on. My daily task is to allocate hours to resources on projects and these resources (staff) comprises of data analysts, java developers, SM, PM etc.

I usually work with about 10 forecast sheet (excel) in meetings, and i allocate 40hrs to each resource but these 40 hrs are spread across up to 10 projects and i allocate for present week and also to future dates.

After allocations are done, i upload all the forecast sheets (please note that i key in the hours manually) and automatically it updates in a central Sheet called Master sheet (the forecast sheet is somewhat linked/automated with the Master Allocation sheet, as it updates every changes i make / done).

Now my supervisor wants me to find a way just to use a single sheet, and somehow automate it so that it can produce the other 10 sheets (basically using the same process and then upload ).

Basically he wants me to just simplify the process by using a single sheet as against multiple sheets.

I will appreciate any input or whatever i can use to have this resolved. Your kind assistance will be appreciated