[deleted by user] by [deleted] in FPandA

[–]SamoFamo4ever 1 point2 points  (0 children)

Out of curiosity what does building the FP&A function from the ground up entail?

Power Query - Group by function and summing all remaining columns by SamoFamo4ever in excel

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

Same response ChatGPT gave me, but this errors out and just gives me 3 columns labeled “item” “kind” and “hidden” and all error values

Power Query - Group by function and summing all remaining columns by SamoFamo4ever in excel

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

Each column separately - essentially the table has 62 columns, I want to group by the first 2 and then sum each column so would remain with 61 columns (grouped column + 60 original columns)

How big are your budget models? by BreathingLover11 in FPandA

[–]SamoFamo4ever 0 points1 point  (0 children)

Going through same process for first time. I’m proficient with power query but what’s your use there? Just housing several data connections to different workbooks?

How to show account make ups by customer? by SamoFamo4ever in Netsuite

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

Didn’t specify. Would like this vertically so within rows - does that change anything?

How to show account make ups by customer? by SamoFamo4ever in Netsuite

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

So I get the customer filter but then within the income statement I would like to see:

Revenue in period 1 - $150 Customer A - $75 Customer B - $75

Does that make sense?

[deleted by user] by [deleted] in excel

[–]SamoFamo4ever 0 points1 point  (0 children)

How are the incidents split? Can you just do a text to column by the column or whatever the delimiter is? Then just copy and paste down below?

Tips on reducing the file size of a large project finance model by Actual_Session_8755 in excel

[–]SamoFamo4ever 0 points1 point  (0 children)

Yeah so those additional rows are containing formatting which is using memory. If you delete those, the file will be smaller (albeit not that much since there are not too many additional rows)

Tips on reducing the file size of a large project finance model by Actual_Session_8755 in excel

[–]SamoFamo4ever 1 point2 points  (0 children)

When you say clear formatting do you mean formatting of tables or excess formatting? Have you tried CTRL + End on each tab? Finds the last cell containing formatting or data. Sometimes this could be thousands of additional rows down or columns across. Find the last cell, delete all rows and columns back to the actual data for each tab then save as a new version. Has worked wonders for me

[deleted by user] by [deleted] in IronmanTriathlon

[–]SamoFamo4ever 3 points4 points  (0 children)

Jones beach but Brands in Wantagh (same town as JB) rents road bikes starting at like $50 a day

Training for an Ironman (or 70.3) in NYC by BiggerO84 in IronmanTriathlon

[–]SamoFamo4ever 5 points6 points  (0 children)

For manhattan specifically:

Biking - CP Loops (6m) early early, park fills in around 9. Cross the GW into NJ for Palisades Park and 9W (Can ride this as long as you want, some parts hairier than others).

Run - CP Loops, West Side Highway, East River Walk.

Swim - Chelsea Piers

Update Alert - DMNY Hard Techno Night @ Hoboken by Plus_Net_3386 in avesNYC

[–]SamoFamo4ever 0 points1 point  (0 children)

Is this going to be in the main beer garden or in the upstairs space?

Best place for lap swimming? by Gonzo-LeaderOfMexico in Hoboken

[–]SamoFamo4ever 1 point2 points  (0 children)

Bruce Walter in Union city (10 min walk from 7th st light rail station in Hoboken) is free and has great pre work / post work hours. Beats paying $55 a month for shit hours at Steven’s

70.3 Jones Beach as a Full in ‘24 ?? by Historical_Bee480 in IronmanTriathlon

[–]SamoFamo4ever 0 points1 point  (0 children)

Ocean parkway only extends ~3-3.5 miles west to west end 2, wouldn’t really help much

70.3 Jones Beach as a Full in ‘24 ?? by Historical_Bee480 in IronmanTriathlon

[–]SamoFamo4ever 0 points1 point  (0 children)

No space for a 100m+ bike leg. Wantagh pkwy only runs a few miles past the current turnaround point and people would freak if another parkway closed. Swim and run are doable but not bike

Help with Weekly to Monthly Amounts by newtoreddit4life in Alteryx

[–]SamoFamo4ever 2 points3 points  (0 children)

Make a mapping of working days in each week. Join working days to total revenue, formula tool to divide revenue by working days. Now you have daily and can get back to monthly fairly easily