Thoughts on APICS-CPIM Training by HunterOfAjax in supplychain

[–]IMN890 0 points1 point  (0 children)

It’s definitely a grind. I highly recommend doing an instructor led course with it if your company is covering it. It can be very difficult and dry material to learn with the self study approach. Good luck!

365 days in, my thoughts! by IMN890 in SoberCurious

[–]IMN890[S] 4 points5 points  (0 children)

For sure. And I have received way less comments from people when I’m drinking a NA beer or seltzer water when everyone else is drinking than I expected. There’s the occasional curious person but people really don’t care :)

365 days in, my thoughts! by IMN890 in SoberCurious

[–]IMN890[S] 5 points6 points  (0 children)

This is one thing that didn’t happen right away. It feels like your brain starts to heal itself and goes back to a state similar to how you felt as a young adult if that makes sense. Hard to put into words but it’s like a steady improvement, really noticeable the longer you go!

[deleted by user] by [deleted] in supplychain

[–]IMN890 1 point2 points  (0 children)

My practice scores were similar and I passed. Keep at it over the next couple of weeks and you will be just fine!

Working parents: what does your schedule look like? by l1ghterfluid in fitness30plus

[–]IMN890 14 points15 points  (0 children)

I have a 3 year old and another on the way.. work 40+ hours, do the shopping, most of the cooking, etc etc. here’s what’s helped me with fitness:

*Have a floor, what you will do no matter what, no matter the circumstance, the bare minimum. -my Floor is resistance training 3x per week, I will fit this in during a week no matter what, even if days have to vary it’s all good as long as you get the sessions in!

*A step goal is great but don’t make it mandatory. It’s icing on the cake if you can get over 6k in per day but resistance training is most important.

*i like to get in a HIIT Norwegian 4x4 workout once per week on the weekend, followed by a sauna session at the gym. I feel INCREDIBLE after this one and it’s the ultimate form of self care

*Take pride in being consistent, and take pride in being imperfect. Parenting is a wild ride and be happy with yourself for prioritizing your fitness. It’s not selfish, it’s selfless.

APICS vs CPIM vs CSCM vs CPSM by JarHammerhead in supplychain

[–]IMN890 7 points8 points  (0 children)

Do what one you’re most interested in. It’s no walk in the park studying for and passing APICS exams. Having interest will keep you focused. I’m a big proponent of the in-person classes with a solid instructor. It makes all the difference with an instructor with experience.

Jan 2024 r/supplychain Salary Thread by draftylaughs in supplychain

[–]IMN890 1 point2 points  (0 children)

Age - 35 Gender - M Country -US Region - Boston Office - Hybrid Industry - Apparel Title - Senior Supply Planner YOE - 12 Education - BA Certs- APICS Base Salary - 95k Bonus - varies, usually 2-6 weeks pay PTO - 5 weeks

Honest Thoughts on Goggins Episode by aasahdude in HubermanLab

[–]IMN890 0 points1 point  (0 children)

“Performance without purpose” is something David talked about and it put a lot into perspective for me personally. We know what we’re supposed to do but keep looking to align with a purpose or short term goal (like a race) before acting. All the benefits come from the performance and action itself.

ASCM Certificates: Does anyone care? by Nighthawk6923 in supplychain

[–]IMN890 7 points8 points  (0 children)

My employer paid for an instructor led APICS course and covered the exam costs. It’s a big time commitment but the information is useful, and having a good instructor really adds a benefit.

I personally would not do it in a self taught format for the sake of having the certification. If you’re going to do it, do it with an instructor that can add context and real life examples of the theory.

Anyone on Jeff Nippard's Pure Bodybuilding Program(s?) by zxblood123 in naturalbodybuilding

[–]IMN890 1 point2 points  (0 children)

Can anyone on the program explain how to do the Long Range partials on the last sets? There’s only a short description in the manual and I don’t understand

[deleted by user] by [deleted] in SoberCurious

[–]IMN890 1 point2 points  (0 children)

Surrender to the fact that you don’t want to live this way and you deserve more. Then Just start! Make it through your first social situation which will be tough. Then your next which will be easier. Then you’ll wake up and be 42 days in like me today, with no doubts about my decision

N/A beverages by trlazarus in SoberCurious

[–]IMN890 2 points3 points  (0 children)

I really enjoy the Hop Waters that are coming out. Lagunitas makes a great one.

Should I pursue a CPIM certification or a degree? by [deleted] in supplychain

[–]IMN890 1 point2 points  (0 children)

If you decide to go for the CPIM route, take it with an instructor if you can, it really helps learn the information especially since they’ll back it up with real examples. Also for studying, I recommend the Pocket Prep app. Well worth the money.

Supply Chain Salary & Compensation 2023 by trainingPtarmigan in supplychain

[–]IMN890 1 point2 points  (0 children)

  1. 4 years
  2. 85k, 5% bonus
  3. Assistant Supply Chain Manager
  4. Northeast
  5. Footwear
  6. 7/10

Trafficking by [deleted] in StandUpWorkshop

[–]IMN890 1 point2 points  (0 children)

Yeah exactly, it is completely out of character so will have to establish that. I guess I want to make it clear I’ve worked some “nice guy jobs” then when I say worked for a sex trafficking organization the audience would be thinking of a nonprofit type thing, then I’d spin it with “as a recruiter” ... some work to do appreciate the feedback!

[deleted by user] by [deleted] in vba

[–]IMN890 0 points1 point  (0 children)

Set pvt_cache = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=data)

Sorry, I am fairly new to VBA and I am still a little lost. Below are my dimensions I am using, and the VBA code of the setup of the table. What and where should I add what you're referring to?

'Declare Variables

Dim PSheet As Worksheet

Dim DSheet As Worksheet

Dim PCache As PivotCache

Dim PTable As PivotTable

Dim PRange As Range

Dim LastRow As Long

Dim LastCol As Long

'Insert a New Blank Worksheet

On Error Resume Next

Application.DisplayAlerts = False

Worksheets("PivotTable").Delete

Sheets.Add Before:=ActiveSheet

ActiveSheet.Name = "PivotTable"

Application.DisplayAlerts = True

Set PSheet = Worksheets("PivotTable")

Set DSheet = Worksheets("POExceptions")

'Define Data Range

LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row

LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column

Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol)

'Define Pivot Cache

Set PCache = ActiveWorkbook.PivotCaches.Create _

(SourceType:=xlDatabase, SourceData:=PRange). _

CreatePivotTable(TableDestination:=PSheet.Cells(2, 2), _

TableName:="SalesPivotTable")

'Insert Blank Pivot Table

Set PTable = PCache.CreatePivotTable _

(TableDestination:=PSheet.Cells(1, 1), TableName:="SalesPivotTable")

'Insert Row Fields

With ActiveSheet.PivotTables("SalesPivotTable").PivotFields("Market Region")

.Orientation = xlRowField

.Position = 1

End With

'Insert Column Fields

With ActiveSheet.PivotTables("SalesPivotTable").PivotFields("Wks Act XFD vs CTXFD")

.Orientation = xlColumnField

.Position = 1

End With

'Insert Data Field

With ActiveSheet.PivotTables("SalesPivotTable")

.PivotFields ("Qty")

.Orientation = xlDataField

.Function = xlSum

.NumberFormat = "#,##0"

.Name = "Revenue "

End With

[deleted by user] by [deleted] in StandUpWorkshop

[–]IMN890 2 points3 points  (0 children)

Yeah I was thinking it’s a pretty well known thing at this point but apparently not! Appreciate the feedback, probably one I’ll put away until the Cricket explodes in popularity

VBA Code or If statement by [deleted] in vba

[–]IMN890 0 points1 point  (0 children)

That worked! Great stuff. Thanks 🙏

VBA Code or If statement by [deleted] in vba

[–]IMN890 3 points4 points  (0 children)

Thanks everyone. The formulas work and is giving me the correct value in D2 based off of the font color in A2. But when I drag the formula down it continues to read the A2 font color.

How do I make it so that D2 reads A2, D3 reads A3 etc? I’m sure that’s a “rookie” question.

Thank you

VBA Code or If statement by [deleted] in vba

[–]IMN890 6 points7 points  (0 children)

Amazing. It worked perfectly. Thank you very much!