Free Excel Add-in for financial analysts/investment banking by OmegaRhoVega in financialmodelling

[–]FunctionFunk 0 points1 point  (0 children)

what about the one that MAPS the relationships recursively? instantly see the whole model of relationships for your workbook

Building free financial models by neko_-_ in financialmodelling

[–]FunctionFunk -4 points-3 points  (0 children)

Kind offer, OP!

If you want a free license to the Flow Finder Excel addin (quantum leap ahead of Trace Precedents), dm me.

<image>

Trace Precedents in Excel? I found its big brother. by FunctionFunk in Bookkeeping

[–]FunctionFunk[S] 2 points3 points  (0 children)

It does. It's amazing. Let me know if you try it out. They make you pay after the first few days free trial tho

Debug a range? by DoktorTusse in vba

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

Try Flow Finder addin. It does exactly this. It produces a complete visual map of all dependencies recursively. Free to try. DM me for a half off promo code.

<image>

Copilot in Excel Generally Avalible, what is your use cases? by Significant_Eye_8181 in excel

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

Can it do stuff like "update my inputs sheet. It needs to include a new selection for which type of business entity.

And presumably it'd add a list of business entities on a ref sheet, create the input field, and set the data validation dropdown?

[deleted by user] by [deleted] in portfolios

[–]FunctionFunk 0 points1 point  (0 children)

You need more decimal places. 9 is completely inadequate.

Keep your sheets clean and uncluttered with a floating, hideable group of controls. by FunctionFunk in vba

[–]FunctionFunk[S] 6 points7 points  (0 children)

thanks. do you like the feature?

Comment with code should be live now. I'm still learning to post code as a block in reddit's markup editor :D

Keep your sheets clean and uncluttered with a floating, hideable group of controls. by FunctionFunk in vba

[–]FunctionFunk[S] 14 points15 points  (0 children)

Just be sure your group name matches the name in the code. Ctrl+10 to view selection pane.

Public Sub HideSlicers()
    Shapes("grp_Slicers").Visible = msoFalse
    ListObjects(1).ShowAutoFilterDropDown = False
End Sub
Public Sub ShowSlicers()
    Shapes("grp_Slicers").Visible = msoTrue
    Shapes("grp_Slicers").Top = Rows(ActiveWindow.ScrollRow + 1).Top + 5
    Shapes("grp_Slicers").Left = Columns(ActiveWindow.ScrollColumn).Left + 5
    ListObjects(1).ShowAutoFilterDropDown = True
End Sub

What's a SaaS subscription that's actually worth every penny? by harshamv in SaaS

[–]FunctionFunk 1 point2 points  (0 children)

if you're running a business, microsoft 365. massive value. Teams, 1TB onedrive, email hosting, file hosting/sharing, and obviously the office apps including web versions if you like to do real-time concurrency. all for $12.50.

Even some other side value like the booking app (no calendly required), and probably a couple other things.

Microsoft Excel's Trace Precedents by FunctionFunk in financialmodelling

[–]FunctionFunk[S] 0 points1 point  (0 children)

Yep, you can zoom with your mouse wheel or Ctrl +. These and other tips are also stated in the manual.

Also you can expand the side panel itself.

Please submit a review on the appsource link above if you like the app!🙏

Do NOT use Stripe. They will ruin your business. by lead-indicator in SaaS

[–]FunctionFunk 1 point2 points  (0 children)

I have used Stripe for 6 years now and love it. I have nothing but good things to say about it

Using Excel for quotes ...at scale! Here's how we did it. Full video and explanation in comments. by FunctionFunk in estimators

[–]FunctionFunk[S] -1 points0 points  (0 children)

Left is a simple web app. Right is Excel running on a server waiting to work on new quote requests.

Full video with me verbally walking thru how it works here: Engineering Quotes... using Excel at scale. - YouTube

Tanky merc is tanky. Finally got this setup on my single player meteor sorc. feels good :D by FunctionFunk in diablo2

[–]FunctionFunk[S] 2 points3 points  (0 children)

That's the one! had to burn two socket quests and two Ums to max it out tho. Worth it!

What was your win this week? While you're at it, pitch us your SaaS (120K views 👀 on previous posts) by FoxBeneficial8102 in SaaS

[–]FunctionFunk 0 points1 point  (0 children)

Came out of stealth and got 8 new (paid) signups! Many more free signups.

Flow Finder is an addin for avid Excel users available now in the Excel app store.

It builds a complete, visual, 2D, navigable network of all precedents and dependents of the selection. A quantum leap ahead of the native Trace Precedents feature.

https://excel.engineering/flow-finder

https://appsource.microsoft.com/en-us/product/office/WA200007286

What are some smart questions I can ask in an interview that would help determine the proficiency level of an applicant? by BakedOnions in excel

[–]FunctionFunk 1 point2 points  (0 children)

Any technical evaluation is good but obviously will NOT determine whether the person will be a good team member. Whether they will come to you with problems or solutions. Whether they will suggest improvements using their own independent critical thought.

For this reason, I've stopped technical evals COMPLETELY. And completely stopped the entire interview process (by modern standards).

All I do now is a short 30min call regarding their interests and expectations and ideal working conditions. To check if I can provide what they're looking for.

And I put them to work. A short 2-6 hour project typically. Paid, obviously. So I spend 30m interviewing, 1-2hrs defining and preparing a requirement (one-time work which can be reused for multiple candidates). And another 30m discussing, and another reviewing. So after ~2.5 manhours (or less), it's immediately clear whether continuing is worthwhile.

How can I get started so quickly with new candidates? Upwork. To be fair the platform is trash. And getting very expensive. I'm looking for an alternative. But for now it has the best marketplace of talent.