How do we call that just for example configurations.
And now we need every configuration which is possible one time without this and without this we are
talking about this dependency here.
Id REM sleep few because we had that here already.
Let's copy that.
Cause it's just this configuration.
I copy it.
Into our integration sheet.
So this is now for this exercise in the real life situation you should know every configuration every
combination which is possible because I just copied it from the several states maybe there are also
duplicates here.
So I remove the duplicates as a way to remove because no duplicate is found.
OK.
Even better.
So this is our master database.
People call it master data.
So this is the Mostel data of this know how to connect this massive data table which need to maintain
it.
Maybe you have it on sharepoint something like that.
This should be something like your treasure chest you have here the math that they tell with every country.
Grayson one time and this is the thing with her inconsistency which we had.
You can really delete that because my approaches to calculate them all of this and then you will have
hundred percent certainty that you have never an error here or if here is the arrow at least you have
consistent error.
You know what I'm talking about because you say so much time and so much energy if you have that calculator
and you will never have to think about that before.
So again we take on a nice index formula.
I copy it and I go here to my stuff inconsistency file I paste that a search
this time it's not the combination here a bad idea month.
This is really important to understand though the whole thing the whole line is Subodh items sold.
So this is the key.
And the rest is spending from the key right in that context.
So I D-plus month and the result is the Roman you they depend on the D and the items sold depend on
that.
So this is the context and the meaning of this whole line and this Kremen spew is actually kind of auxiliary
information.
It's not even necessary for the whole thing because if you have the ID you don't need nothing more because
the ID qualifies.
The whole system this remans super You don't depend on and month they paint only on ID.
So here then we always go from eye to all input output.
I go into these this other sheet here.
And again it's important that you go with the Kurds are into this.
I I.
Range before you switch the sheet.
Now I go here.
This is where I search a and I go with the cursor into this.
Oh it's just a placeholder again I deleted and then ran.
So I go from A to B I go from server to RAM and to did it directly from your laydown.
Same thing here.
But it was not from A to B.
It was from A to C.
So what I really like to do I go here and copy the whole formula.
I don't copy the cell from here to here because now everything is moving from A to B.
Now B to C which is nonsense.
I copied the formula here.
And this editor part.
Then I go here and I paste the whole formula.
Usually I hit Enter So I see I really have half the same thing.
Exactly.
And you remember I wasn't going from A to B I was going from A to C No.
So it's really easy for me to replace the B by C C.
And now you have a consistent thing because it's calculated out of your master data and you can impart
this math today.
You can actually ask a colleague to maintain this math data.
And this is your look up table for this information and this information is automatically calculate.
It's really nice.
What I sometimes do so that I can decide which is the information I have to maintain and which is ultimately
calculated.
I give them different colors for example this Blue Note.
This is too dark blue
and again.
So this is information I have to maintain and this is information that calculated automatically of course
when you export this file and you have later copy paste values.
You know that because of the formula.
When you export only that stuff to somebody else.
But usually you exported the whole file with everything together and the people will like to see how
you you know make that possible.
That the consistency is always there and know that you learned that you learned already.
I guess 80 percent of what you have to know about relational databases because that's that is what they
call relational databases.
It's always the relation.
Here you have a relation from here to here from here to here or the whole line is a relation they relate
to each other and how you see how they relate to each other.
These three this is the definition of the relation of them.
And here you have another relation.
It's these three.
And this is only an auxiliary information.
So this information is derived out of this.
And if you have this scheme if you have nothing Dabur you have every information only one time.
And if you need to add another time then you do the right fit by formulas.
So you have your information somehow spread out over different tables and then put them together where
you need it.
That's what they call relational database and access and all the other databases do exactly the same.
I can highly encourage you to think that way and you will have really good data in your work.