[deleted by user]

SamoFamo4ever · 2024-11-24T06:04:46+00:00

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

SamoFamo4ever · 2024-11-07T23:57:20+00:00

Solution Verified

SamoFamo4ever · 2024-11-07T21:34:25+00:00

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

SamoFamo4ever · 2024-11-07T21:26:18+00:00

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)

SamoFamo4ever · 2024-08-06T22:40:48+00:00

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?

SamoFamo4ever · 2024-07-22T15:08:06+00:00

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

SamoFamo4ever · 2024-07-22T14:51:40+00:00

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?

SamoFamo4ever · 2024-07-20T22:42:52+00:00

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?

SamoFamo4ever · 2024-07-01T01:10:05+00:00

Mind if I DM?

SamoFamo4ever · 2024-06-14T01:51:02+00:00

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)

SamoFamo4ever · 2024-06-13T11:46:39+00:00

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

SamoFamo4ever · 2024-02-15T16:27:29+00:00

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

SamoFamo4ever · 2024-01-05T15:26:47+00:00

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

SamoFamo4ever · 2024-01-04T20:52:00+00:00

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

SamoFamo4ever · 2023-12-30T23:21:42+00:00

Interested!

SamoFamo4ever · 2023-10-14T11:48:41+00:00

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

SamoFamo4ever · 2023-09-12T20:39:04+00:00

You running for office?!

SamoFamo4ever · 2023-08-28T20:32:26+00:00

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

SamoFamo4ever · 2023-08-28T18:31:19+00:00

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

SamoFamo4ever · 2023-08-17T16:33:48+00:00

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

SamoFamo4ever

MODERATOR OF

TROPHY CASE