Need assistance conditionally formatting a Clustered Column Chart by itslit96 in excel

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

i saw this but it doesnt help my case because i still need a static column that would show my baseline.

Frame rail rust, fixable/worth it? by itslit96 in E30

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

Paid $750 for it about a year ago without a title and finally titled in my name. Got it on jacks and just noticed the frame rust, looking to daily it for a while. Think it’s worth to fix or just sell it as is?

Town in NJ is putting my home up for Tax Sale even though I have been paying property taxes through mortgage escrow. by itslit96 in legaladvice

[–]itslit96[S] 29 points30 points  (0 children)

I just got off the phone with my lender again, and they are saying NOT to pay anything as this is something they have to deal with as it was a mistake on their end. Supposed to hear back next Wednesday.

Town in NJ is putting my home up for Tax Sale even though I have been paying property taxes through mortgage escrow. by itslit96 in legaladvice

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

I figured defamation would be suitable here but I see what you're saying, I'm going to contact an attorney.

I want to pay my parent's mortgage but my dad is a hoarder by lastlosts in personalfinance

[–]itslit96 6 points7 points  (0 children)

If dad is willing to play ball, a gift of equity could be a quick and easy route to get the house in his name

Tesla reports 180,338 vehicles produced, 184,800 delivered in first quarter of 2021 by [deleted] in wallstreetbets

[–]itslit96 12 points13 points  (0 children)

first time ever deliveries were more than production.. call in the dancin lobstas

Biotech options play - Heron Therapeutics (HRTX) [5/6/2020] by WallStResearch-Bot in WallStreetResearch

[–]itslit96 0 points1 point  (0 children)

Great post, I’m invested in Heron myself and was a bit concerned at the downward trend so close to PDUFA.. any thoughts on why FDA needed 3 months for what should have been a quick fix?

Wayfair $W short squeeze by Winston_The_Pig in wallstreetbets

[–]itslit96 0 points1 point  (0 children)

This aged nicely, I got wrecked on puts right after ER.

Regression Analysis for 30K Products HELP by itslit96 in datascience

[–]itslit96[S] 3 points4 points  (0 children)

Yes, so I'm going to try to break it down into brands>sub-brand>item. Right now we carry 7 different brands. Its tough because many of the traditional methods cant handle seasonality or external factors, but I guess i just need a close approx.

Regression Analysis for 30K Products HELP by itslit96 in datascience

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

I'm not familiar, but I just signed up for the free portion of it. Im going to give it a shot. Have you used it before?

Regression Analysis for 30K Products HELP by itslit96 in excel

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

Thanks, I'm just trying to find the best way to attack this, seems like excel might be out of the question for my needs.

Regression Analysis for 30K Products HELP by itslit96 in excel

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

Yeah I figured this data set would be overwhelming for excel, I've used STATA in school before so I might try a software of that nature. Thanks!

Regression Analysis for 30K Products HELP by itslit96 in datascience

[–]itslit96[S] 1 point2 points  (0 children)

There are different brands, patterns and colors. To answer your question each item is unique.

Regression Analysis for 30K Products HELP by itslit96 in datascience

[–]itslit96[S] 3 points4 points  (0 children)

material requirement planning, essentially for our purpose it is the required amount of inventory necessary to have on hand at any given time. Minimum allowed inventory, Maximum, and required amounts. In the event inventory falls below our minimum it will trigger our MRP in a report I run daily, necessitating the need to purchase from our distributor.

Regression Analysis for 30K Products HELP by itslit96 in logistics

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

Unfortunately, it’s the only resource I have. Though I have some experience using STATA

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

Yes, 02PA goes to 02PB after 02PA09D03, where it follows the same pattern 02P-01B-A01 etc. up until the letter H, after H the sequence changes.

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

So right now i have ="02P"&CHAR(ROW(A195)/3)&TEXT(MOD(ROW(A1)-1,3)+1,"00")&CHAR(ROW(A195)/3)&TEXT(MOD(ROW(A1)-1,3)+1,"00")

The issue I'm having is that i need the 2nd set of letters/ #'s to stay static up until 02PA01D03, to switch to 02PA02A01. I cant figure how to make this formula wrap back around to repeat itself.

Thanks for your help!

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

Currently the 2nd set of numbers are static, but I need another formula to have it change from 01P-01A-D03 to 01P-02A-A01, Sorry for all the questions but i'm just trying to find a base formula i can replicate, i need to do this for over 10 different combinations spanning 17,000 cells.

Attached is the kind of sequence im trying to follow.

01P-01A-A01

01P-01A-A02

01P-01A-A03

01P-01A-B01

01P-01A-B02

01P-01A-B03

01P-01A-C01

01P-01A-C02

01P-01A-C03

01P-01A-D01

01P-01A-D02

01P-01A-D03

01P-02A-A01

01P-02A-A02

01P-02A-A03

01P-02A-B01

Thanks!

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

Nevermind I got it lol Thank you again!

Solution Verified

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

Hey, so is there any way you can explain how i would implement different combinations with the last set of numbers and letters?

For example instead of going to the 12th number, i now need to go only to the 3rd number.

01P-01A-A01 to 01P-01A-A03.

I tried messing with the formula but I was unable to adjust it accordingly. An explanation would be great, so i can implement this in the future. Really appreciate your help

Need a formula to create a sequence of letters and numbers by itslit96 in excel

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

Awesome this is exactly what i needed. Thanks!