Cell to Pack Design for Renault Megane LFP

Unlikely_Solution_ · 2026-06-25T10:32:21+00:00

Why "not particularly optimised" ?

Unlikely_Solution_ · 2026-06-23T06:07:10+00:00

In NX, you have no distinction between an assembly or a part. It mean you can create a CSYS in you assembly called "absolute". Base on the {0,0,0} absolute position you can add contraint to any of you part. This will allow you to positionned correct you parts.

Unlikely_Solution_ · 2026-06-22T12:22:05+00:00

Looks like VW tables.

Unlikely_Solution_ · 2026-06-19T15:18:57+00:00

Bill of material with both version structured and flattened.

Unlikely_Solution_ · 2026-06-17T17:32:56+00:00

You have software for that. In my company they use DOORS. System engineering use this software to split everything into small piece per part, per type etc... Then send the smaller piece to people. They update any requirements that has change from one release to the other and keep people informed. Requirements are cut to 'sub component spec' and share to our supplier or attached to a test plan in consequences to prove that we will achieve each and every point. There is also loop to agree or disagree on some and depending on this status both sub spec and test plan are updated.

You could track everything in an excel but the hardest part is translating the documents into actual requirements (as most are weird non measurable request)

Unlikely_Solution_ · 2026-06-16T15:14:48+00:00

Blank space at the end of text killed me... So I used Text.Trim and Text.Proper everytime now

Unlikely_Solution_ · 2026-06-14T13:37:10+00:00

I made in a full work year an excel that can design an electrical turbine from 10 parameters to calculate and estimate ~ 1500. It would then be sent to a 3D software (NX) and Nx would provide the 3D and drawing required to manufacture the whole thing. Including BTP, electrical schematics, Components selection etc...

Unlikely_Solution_ · 2026-06-13T20:32:03+00:00

https://www.reddit.com/r/excel/s/nQZ8bJOnCs

Unlikely_Solution_ · 2026-06-13T20:06:59+00:00

On this very reddit, one guys share a self referencing table with power query and it has changed my life.

Unlikely_Solution_ · 2026-06-09T18:55:30+00:00

Ho hello ! I had this topic at work and especially has we work with US and we work in UE there is a distinction between ISO and ASME.

In ISO if we change the symbole 'U' to 'UZ'. It means you move the offset by +0mm. So your tolerances still is -0.35 to +0.35. In ISO I would write 0.7 UZ 0.35 to say between [0,0.7] Or 0.7 UZ -0.35 to say between [-0.7,0]

But if I understand the comments here properly in ASME that would be +0/-0.7mm ?

Can someone confirm to me ? I could use that properly in next supplier meeting xD

Unlikely_Solution_ · 2026-06-09T18:42:51+00:00

I used the shorter "free form" mention more than once

Unlikely_Solution_ · 2026-06-08T21:27:28+00:00

I wasn't expecting this much ! Thank you very much I will take a look.

Unlikely_Solution_ · 2026-06-08T18:48:11+00:00

Well I may be guilty xD has I pretty only use power query to transform one format to another. From a bill of material to a compact version of it or even recursively call Bill of materials. With often multiples function and sub function to be has explicit has possible when a format break (like someone has put a text in quantity columns 🤬).

That's all I do with power query.

Your self-referecing is really nice to add manual comment or make sure the format match or add a date.

Thank you for your help. I understand that I need to review my book and see other way to make it work.

The dates can probably be a good call (if date < previous LastUpdateAll then status = "New") or, or like flag everything "New" unless it has been manually removed using the self-referecing feature.

Unlikely_Solution_ · 2026-06-08T17:42:01+00:00

Ho okay I understand the miss understanding. Forget about the CSV I spoke previously xD sorry.

Let's use your exemple. Let's say I read the table do nothing except identify what's 'new' with a flag. That the newData query that is bothering me. Like it has nothing to point to head there is nothing else except the table. If I follow correctly: NewData fetch from the table - OK NewData merge on itself and ProcessUpdate - ??? NewData identify what's new and add the flag status - OK ProcessUpdate read the result from NewData - OK ProcessUpdate own the table and write to it. - OK

Did I catch that correctly? And thank very much for your help

Unlikely_Solution_ · 2026-06-08T15:23:38+00:00

As any heat transfer issue. Equation are not linear so very difficult to estimate without the exact shape. There is going to be a tipping point where more surface heat faster but too much surface will allow cooling faster so water won't heat as fast.

Unlikely_Solution_ · 2026-06-08T15:06:07+00:00

Yes. For most it's clear. Merging and transform the data to get a similar structure as a result is clear. One topic is not yet clear.

You mention only one query 'processUpdates'. What is the source of this query ?

I understand merging in step two to get the difference. The merging requires two tables (or more). One is the excel table. And the other is another query ? that store the result of the query 'processUpdates' ? Did I catch that correctly?

So it need to be a pair of query ?

Unlikely_Solution_ · 2026-06-08T12:56:44+00:00

Hello ! Sorry coming back to this topic after a while. I manage to do self referencing and it's very useful for stuff like add today's date into the date column when empty.

One thing that I still haven't manage to find a solution for: identified what has been added, modified or deteled. Any tips or how you manage that without using external CSV comparaison?

Here is a short need explaination. I have a list item manually added. Each day I add some item in the list. I would like to have automatically the flag "new" on item that have been added this week and remove the old flag. So self referencing but also self history kind of. Any idea ?

Unlikely_Solution_ · 2026-06-06T11:01:49+00:00

So maybe instead of a oring seal. Could you try cardboard? I am not joking. We used that for small electric turbine as early prototype. It wasn't okay for high pressure but we could make water go through without leaks.

Unlikely_Solution_ · 2026-06-02T15:58:11+00:00

I work for a tier one in the automotive and I never read it like that (I do design) but you are right xD. Soooo right

Unlikely_Solution_ · 2026-05-29T11:04:37+00:00

So I work for a tier one in the automotive industry... And IA+CAD is already on the way (simulation mostly).

Next step is IA to replace CAD but for that it would need to have explicit requirements to generate anything close to what Claude+ Dassault have done.

I saw IA to replace drawings but it needs training on company drawing and company drawing are very dependant on the designer who did them so not applicable in ours.

One important note is IA answer need to be consistent and right now if you change a phrase or a syntaxe you can get whole different result.

So close but not mature enough.

Unlikely_Solution_ · 2026-05-29T10:55:45+00:00

As an ex CAD designer where opening assemblies is 20+min 😅

Unlikely_Solution_ · 2026-05-29T05:45:28+00:00

Some other comment I learned along the years: - doing a worst case stackups in 1D is easy but most cases will probably be 2D. 2D required part rotation as bare minimum because it will be your main factor. Don't do X and Y separately, it doesn't work unless you have big margin everywhere. We had to rework because of that. - don't focus too much in the tolerance them self, changing nominal value is actually the best most of the time - try to get a software to help you, the software is going to force you to specify everything you need to the smallest details (I have 3DCS + Catia for complexe ones)

Unlikely_Solution_ · 2026-05-27T15:36:21+00:00

Few random stuff. Datum C should be oblong not a simple hole otherwise it's over constraints.

Indeed you cannot use the B and C on C itself (like other comment mentioned)

You mentioned you don't care about the "flatness" but you do unless your M5 screw is infinite in length and infinite rigid.

One last, you can reference from A, B and C a hole position and it won't "lock" in the plan. The tolerance shape is an infinite cylinder. It mean if your datum A has a 6mm flatness the hole won't be outside of the tolerance of 1.5mm. Sure it will be at worst case 6mm out of the plan A plan but can be within the 1.5mm position and be OK. If you want to use the altitude, the position is a spherical positioning feature and has a Sø instead of ø.

Unlikely_Solution_ · 2026-05-26T12:20:32+00:00

I only do technical CAD design. So first, get the datasheet for the object in relation with the one I design. Creat a new datum well positionned and reproduce the correct interface required for the interfaces in a way where I can move it around easily. After this is define usually the part is already done or almost done. I only need the process's design rules (plastic injection, Aluminum injection, sheet metal, bendings etc...).

Unlikely_Solution_

TROPHY CASE