Hi guys, what's the point of a circuit breaker when we already have iterative calculations on? Doesn't this just add an extra input, making a formula more volatile?

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

Just delete one cell and enjoy the #REF! You also won’t be able to CTRL Z that disaster

likefunny

The circuit breaker gives you the ability to break the circularity and trouble shoot errors in the model, you can also just simply “jumpstart” the model by cutting the circular reference and then pasting it back in.

The circuit breaker is the more user friendly version and won’t make the model more volatile when built correctly.

like

Yes, that is exactly it

When you accidentally type a letter instead of a number, you'll thank the circuit breaker

like

That’s a good question… I just know by experience that the sheet will break without it - tbh that’s something excel should have fixed at this point the same issue existed since I was an analyst many years ago

I actually prefer iferror to a circ.

Don’t need to build in anything up front if you set up a macro that inputs iferror(formula,1000) in your cell with a binding.

I like 1000 because it tells you that you haven’t fixed the problem yet, and can keep following the circular logic until you get the key blocking pieces set

Related Posts

Purchased a new home. Keeping my current for a rental property Long term rental vs Short term rental, thoughts?

like

Hello all, anyone interested in starting a tech training business or side business. We are very well established in B2C and recently started to offer platform as service where a tech mentor or training providers can use our LMS, courses and hands-on IT labs to open a full online business.
This is next level from Udemy or teachable.

Who is for?
Tech educators with passion to teach but also want to turn skills into business.
You must have ability to bring students for your business

like

Have a big interview tomorrow. The question I dread the most is about why you’re looking for a new job. The honest answer is that there isn’t enough work to go around at my agency and I want to get ahead of the inevitable layoffs. What’s the best way to tell them this? Do I just make something else up entirely?

like

Can anyone recommend resources to learn private equity investment valuations and fund accounting? I.e. how to value 2 companies that were acquired and merged by a PE firm for reporting to an LP?

like

Greenhouse recs? Would love glass but not sure on cost.

like

How is Deloitte Cyber? Are you all hiring atm?

like

Hi Guys,
I am in a very bad state and need your suggestions.
I have 9.5YOE.First 7.5yoe were in IP Networks(R&S) then I joined a company which keeps aligning me to different roles/profiles every 6-7
months.Now I am at crossroads, haven't been able to learn anything worthwhile in current company which can give me new job neither I can go back to Network profile since what I was working is legacy.
Want to change my profile.What course can I take ?Any Upcoming Network technology or should I switch to Data science/Analyst or any other?

like

Hi everyone, I am an ios developer with 7 years of experience. I have exposure in both Objective-C and Swift. I am looking out for a job change. Please see if you can refer me. I can join immediately.

Preferred Location: Bangalore

Raise your hand if you’re more excited for This Is Us than the Super Bowl?

like

Deloitte has a number of roles for Advisory Manager Financial services Risk management, one of which I've applied to. It has been 3 weeks and haven’t heard anything, is this normal or have they passed on my application? I believe I've met all their requirements in a candidate for the role.

likehelpful

Hi All,
I am looking out for a job as an entry level Data Analyst role in Toronto,ON , with 1 year of relevant experience…what do yo think should be my ask ??

like

What are the best investment vehicles right now? My 401k is well funded and have about a year salary in savings. Need to really start investing now. What are the best mechanisms for greatest return?

like
like

What do you consider a comfortable salary?

like
like

I miss the times (circa 2006 - 2010)where it was quite normal to go out and meet girls and have them take you back home for the night. Such a great time to be alive. Now, everyone is so caught up with that digital app dating life and no one goes out anymore to meet people. So sad.

like

About to pull up a creative brief on my screen, put my hands on either side my head in a “serious concentration “ pose, close my eyes, and take a 7 min nap. 😴

likefunny

Contract flow downs question. We are selling equipment to Company X so that they can sell to Company Y. Company Y is trying to push some owner flow down provisions to us. Our initial contract with Company X doesn’t include those flow downs. Would you push back? Is that standard/necessary for flow downs to go that far? Any insight is helpful.

Does anyone personally know someone who was fired due to inappropriate use of time caught by company tracking software? I’m not asking for a specific reason, just curious, because I feel like it’s this phantom thing that companies are “spying” on employees, but I don’t know anyone who’s been directly impacted.

like

How is ServiceBerry Company ? has anyone worked in this company and can share the experience?

like

Additional Posts in Investment Banking - IBD

What do we think is going to happen with student loan deferral? Any recent new grads thinking they’re going to pay back any time soon? Some argue Biden is going to keep pushing interest pause til next election then forgive 10k as a strategy to help get re-elected? I only have 15k to pay and can pay it anytime, but no incentive to when that money can be earning more elsewhere in the meantime, thoughts on what is really going to happen?

like

Anyone know if Shelby Jennings is legit as recruiters?

like

What side business or gigs do you guys do to complement your salary if any? I’m looking to maximize my income and use my skills somehow to make money on the side.

like

Corp Dev total comp and title

like

Has anyone used the coaching platform Office Hours for laterals and buyside recruiting training? They connected with me on LinkedIn and I hadn’t heard much about them so curious if their service is worth the price tag

like

Anyone have a blank modern CIM template they can share? Just joined a no name boutique and have never done one.

like

How important is submitting a cover letter, when you’ve already been in IB for a few years?

like

S79TO studying is going good I have pretty much everything down except the formula parts and I’m starting to get nervous this will cause me to fail for those who have taken the exam we’re there alot of formula required questions? I’m hoping I get hit with 4-5 formula questions. HELP

like

I dont understand the concept of DCF at all. I get that were discounting the future expected cashflows but wtf is a haircut? How do you just pull that number out of thin air? Is this all fugayze?

funnylike

What’s the point of providing OID on a loan? Why not just increase the interest rate instead?

like

Anyone working at a MM IB firm in Washington DC? Looking for some insight. Thanks!

like

How many of you are working this weekend?

like

What’s the perception of Lincoln in the IBD space? Are the exit opportunities on par with other MM programs into HF or PE?

like

I am taking series 79 soon, wondering how important is it I know all the dates? I know the major ones but I’m going through knopman and there are so many “xx must do xx within 10 days, 30 days, 40 days, 6 months” etc.

And names of every single rule (I can recognize all rules and explain them but… I had a question on knopman ask me if the answer was section 338(h)10 or 338(h)11. Could really use some insight if anyone has anything

like

Has anyone made the switch from MM to BB/EB ? What was the motive for the switch? What is worth it? How was the lateral process?

like

What should the signing bonus for a first year analyst be around?

like

Does your bank use Presbuilder or any other automated PPT add-in?

I just moved to another place that doesn’t use these and I wonder why not.

like

Hi all,

I am looking for a job as I was made redundant by my employer last week. I have 9 years of Investment Banking / Corporate Development (buyside) experience.

Looking for opportunities in Greater Toronto Area or remote position. I am also open for contractual / project based work.

Appreciate your support

like

What do you say when people act impressed that you're a young VP, not realizing that there are a ton of VPs at a bank?

like

What you bank’s common M&A advisory fee check?

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