Building LBOs and my circularities keep breaking everytime I refresh or save the model. If I turn the circuit switch off and on then everything works again but it makes analysis really hard to run. Any fixes?

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

I can’t help, but have a question. Are you making LBOs for consulting work or for PE practice? Just wondering

That’s what I was wondering

Related Posts

Do any of you have Newcomers being thrown in mainstream classes? We have no Newcomer curriculum and it's setting them up to fail. Suggestions?

like

#Urgent and Active Openings

L&T Infotech is hiring Pan India for below roles: Interested people can drop their email id's and Names with respective Job Id's .

Post Photo
like

Anyone know anything about the apartment building downtown called “Diega”? How’s the building and neighborhood? My wife and I are out of state but planing to sign a lease there? Will you recommend or avoid?

Saw the posts on workout clothes and wanted to add-on a more specific question: What are your favorite gym shorts for boxing or muay thai or Brazilian jujitsu?

like

My current cost of bsn is close to $75K where as regular RN is $54K. I’m not entirely sure if I should continue or switch. Any advice

like

Any thoughts on finance in P&G or Unilever? Some people says they are mainly marketing / brand companies, so finance is less important (but the ceo is a finance person in P&G??). Also, many people say that the job is so boring and repetitive.. Actually, I'm planning to move from consulting, mostly because of work-life balance. I'm sure it's more boring, but I think it's not a bad opportunity. What are your thoughts?

like

What’s the appropriate response when you find, by chance, your best team member has her resume up on her work laptop, and is searching LinkedIn job postings? She displayed the wrong screen...

like

Desi fish, looking for some easy, no mess (preferably owen or single pan) healthy cooking recipes of chicken/ fish that I can include in my diet plan. M with kids and family here.

like

What differentiates PwC from the other Big4 in the MENA region?

like

Just found a typo on my resume after sending it out to lots of folks. Just shoot me & Indesign’s lack of automatic spell check. 😭😭

like

Consulting Cat Dads -- how did you handle cat litter during pregnancy while you are traveling? My wife is afraid of a toxoplasmosis infection from exposure. What worked for you?

Hi everyone, share your blindsided layoff stories below so I can feel a little bit better about mine.

Covered a managers meeting for her yesterday, was with some senior members of the marketing team. A director opens the call with “we are so sorry about the impacts the layoffs have had on your teams today…” then noticed I was in the call and said “we are still notifying others so best to keep it under the radar” …25% of my team was let go three hours later with no warning😬

likehelpful

2 YOE transactional associate at amlaw50 firm and I have been offered a role as compliance counsel at a public company. I would be doing basically all of the things a compliance officer would do except my title will still be “counsel”. Is this career suicide if I eventually want to transition to another type of in house counsel role?

like

32M
In Sydney, Australia
Nationality: Australian and Pakistani
Religion: Sunni
Profession: Strategy Manager
Hobbies: Hiking, Rock climbing, Travelling, Reading Fantasy fiction, Politics and Self-improvement

Looking for someone from 25-31. Don't care about ethnicity. Practising Muslim. HMU

Which would you pick:

Range Rover Classic (c. 1992)

OR

Hummer H1 (c. 2003)

like

our xmas party was lame. someone wants to smuggle me into theirs?

like

Please let me know if you are looking for job in any of these opportunities.

Post Photo
like

Anyone need a job in Denver

like

How is BigID ( data privacy) profile in Morgan Stanley? Is it worth to change profile from capital market to data privacy? Morgan Stanley Capco BigID

Hi Folks, how much max amount we can retain back after 80c tax claims on income taxable amount. Any idea? Is it varies based on package? What is the percentage ?

like

Additional Posts in Excel Genius

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Hey, tips for where to look for good excel cheat sheets online? :)

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal