Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

like
Posting as :
works at
You are currently posting as works at

You probably are better off at building things with python only or use the Excel VBA

like

Also in my experience power query is not very stable or reliable maybe try power bi for data pulling and transformation and link that to excel for the final output into pivot

like

Can you be more specific about what you’re trying to achieve?

like

We currently use Excel to manually analyze our GL and find an overhead percentage. It takes our CPA 100 hours per quarter. There are 50 tabs of analysis and 5 schedules to be filled out. She needs to be able to understand and explain to an auditor. I'm afraid VBA will crash Excel because it does a lot in my experience.

I'm trying to automate this

like

Related Posts

I recently joined cognizant.. It's been 20 days still on bench?? Not getting any calls from project?? How to search for project?? What's the bench policy?

like

Gig alert: "AKQA San Francisco is looking for over 30 people (client services, project management, and creative) following a series of incredible new business wins..."

like

any senior Associate Rank 65 in CBS client technology CA can do

like

2 hour meetings every day this week and the client still can't get the nomenclature for a god damned document straight.

Post Photo
likefunny

I wish there was a system that took all your project experience and output what you’re actually qualified to do. What I’m interested in, I’m not qualified for/doesn’t pay; what I’m qualified for (1)

likefunny

Need some suggestions. I have a decent client with $150k maxing out and is 62 years old. Every 3-6 months I get an email saying the funds aren't working and changes are needed. Cont.

like

Hi everyone. I'll be joining IBM in Jan. Whats the process of getting a project and bench time? Any idea as to what to expect? Any new joinees willing to share the experience?

Tech stack - Java microservices
YOE- 6.5

like

Consultant forgot to replace all mentions of the previous client's name before sending the deliverable to the new client.

Post Photo
likefunny

When you go the extra mile to provide multiple workable solutions for the client:

Post Photo
likefunnyuplifting

Do consultants have the option to opt of traveling to client sites?? Like, can I work full remote??

I recently joined HCL. The project team raised the Laptop request for me and the IT team has allocated the Laptop for me but how do I raise the request to deliver it to my home. Someone please help as I cannot go and collect the laptop. When will they provide the ID for new joiners how to raise the request ?

Anyone has tableau position in their project then let me know please.

like

Hi friends,
Need Help
Is there anyone from Accenture who is working on Merck Sustainment project. Need to ask few question regarding the project.
Please respone and help.

like

Contemplating jumping from insurance defense to claims examiner for Sedgwick. I currently like most people I work with but there is one unbearable supervisor. I meet my billable rqmts(2000) but it’s never enough. I’m up for partner but have no clients and no idea how to get clients. Despite being perceived as a valuable attorney, I know the client development weakness will become a bigger problem over time. This position comes with a pay bump, vacation days and wlb promise. Is there a catch?

like
like

Howzz qatar onsite from lnt? If lnt is taking interview for project where after 2 months of joining need to travel qatar... For 6 . 7 months? Does this good idea to join.. Guyzz ur view?

like

Hi guys,
How is coforge in terms of wlb,job security
Got selected for one of banking project.
Could you please help with your reviews.

like

Is it acceptable to put the client name (high level) you're working on in your resume if the transaction hasn't been announced yet? Buyside/sellside

funny

More Posts

What is the rejection rate for canada wp this year?
I have been rejected for us visitors visa twice two years back.. so having doubts about canada wp.. would this cause any issues?

like

How much time EY takes to roll out the offer contract? The offer was shared in a formal discussion however contract is still pending.
Ps: More than a week since the discussion

like

Should gratuity be automatically added to a service?

like

What should be the average salary of a person with 6m internship exp and 1y work experience in software development?

like

White Mediocrity Strikes Again; Blake Shelton

like

Looking for a remote/hybrid/onsite (Calgary,Alberta) job for my boyfriend who got almost 5 years of experience in proposal writing, RFP, RFI and bid management for a civil engineering firm. He also got an MBA, non drinker, non smoker, clean driving abstract and very polite. He gave out tons of cv in indeed job posters for the past 5 months, ends up becoming the filler candidate, took a huge toll in his mental health and we are going through some very rough patches. Can anyone please kindly help?

like

When married men slide into my dm’s at 5:24a. It’s called fuck around and find out.

Post Photo
likefunny

2 hour meetings every day this week and the client still can't get the nomenclature for a god damned document straight.

Post Photo
likefunny

What must Conservatives tell themselves to see this stuff and pull the lever for Trump anyway?

Post Photo
like

Love our fuzzy girl.

Post Photo
like

How many days before Date of joining , Axtria sends mail regarding onboarding process ?

like

Hi,
I'm an immediate joiner. I have 3+ yrs experience in AWS, python, docker technologies. Please let me know if there are any open positions or any other leads for AWS Developer. (I haven't been getting any calls from naukri and other job portals.)

like

Junior biglaw tax associate here. Considering an internal transfer vs lateral to NYC from a smaller market. Any firms in the v20 I should avoid/look into? I have pretty reasonable hours at my current firm and trying to avoid going to a sweatshop. Interested in international tax and hoping to avoid m&a. Firms I’m considering: Latham, Gibson, Sidley, Goodwin, Milbank. Thank you all!

like

So I started my first remote tech job. Up until this point I’ve been a field tech. But I’m curious about my salary vs what other people are making in similar roles. Is 60K/year for a TSE decent to start?

like

Need to get an AE some social media and community management training. Any recommendations? Free is great, but $$ okay, too

like
like

Hi Frndz..

Monthly take home with new tax regime plz...

Post Photo
like

Where is the cheapest place in the city to replenish toiletries? I usually just do Duane’s on a rolling basis but I incidentally ran out of everything at the same time and it feels too expensive of a haul for Duane’s. Is Target cheaper? Any secrets locations?

like

How is Sutherland as a company? Kindly let me know what is the interview structure followed in this company

like

Is the Austin side of Chicago really that unsafe ?

like

Additional Posts in Excel Genius

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

What macros do y’all have set up?

like

Hey. Is there a situation where only an XOR function could be used? Or even generally where is the XOR function used?

like

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

like

Please do excuse how dumbed down the example is, I’ve had to replicate the problem on a much smaller scale with all sensitive data removed.

“Location” refers to a location of stored data and “User group” refers to the user that has access to the location.

I am attempting automate the finding of all instances of where the “U1” user group occurs but exclude it if another user group also has access.
Continued below….

Post Photo
like

Hello everyone .. what is the quickest way to learn the excel program inside and out

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

I use both excel and google sheets, and love them both for different reasons, but they don't agree on which direction decimal rounding goes and it makes me crazy

Post Photo
likefunny

Q. Is it possible to turn off track changes on a shared excel document ? I looked it up and it saying, “Press review” and I can disable from “Track Changes.” However on the document I’m using, I press review and I only have the option to “show changes.” Anyone know a way around this. Trying to at least remove the history due to a micromanaging manager

like

Workaround for a median ifs formula? I’m assuming an array but cant nail it

Excel geniuses, is there a template one can use to have numbers in excel output in ppt? Looking to build some basic daily operational dashboard? TIA

like

Hello! Is there any VBA coding to clear all column filters in a pivot table? I see how to remove all fields... But I want to keep all the fields and just clear all the filters. Thanks!

like

Any books to learn advanced excel?

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

New to Fishbowl, would love some likes! Or you can comment with your favorite IF statement in Excel. (Long formulas encouraged!) 😉

like

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Is there any big advantage of using gsheets over excel?

like