Thank you so much mam , I am here in Dubai, I am doing work as electrician, I have completed course of ms office, I want to become documents controller, this is my 4th video watching from Ur channel, thanks again
Nice video po. It's better to lock the excel range always whenever you're doing the counting (and just do it once). Avoid also hard-coding the criteria; it's better to refer to the cell and locking it where the criteria reside.
Tomorrow will be my first day of work as document controller and I have zero knowledge about it. Thank you for making this video. I gained some ideas about it. ^_^
Mam can you plz tell me how do i install edma software in my laptop..is this a software app or something..bcz i hv best knowledge about excel..powerpoint..ms word..with a good typing speed..is this enough for a doucment controller or i hv to do something more..plz explain me mam..waiting for ur reply..
Thank you mother , but when i tried it as a same table with same column is not working it, could you please write the formula what you used in your video, thank you mam
Hi Maam sa transmittal po . kunwari sa control#001 ibinalik dahil kailangan e revise ang control# ko is 001 pa rin ba pag magsusubmit ng transmittal for revision ? sana matulongan ako. salamat
madam , how about this like the document have same number but included 3sheets example : EXM-DD-SS-01 1of3 (Approved) EXM-DD-SS-01 2of3 (Revised and resubmit) EXM-DD-SS-01 3of3 (Approved) its one package document , but if we insert to your format, it will count as 3 documents right? but i want it count as 1 document only since it has a same number for 3 sheets, also 1of3 is approved but 2of3 is revised , how to solve my problem ? please help me ,im new as doc control. sorry for my super bad english, hope you can share your exprience.
Hi egi, if you are taliking about shop drawing your formula will ba counted per drawing even if it is 3 more documents in one submittal. Because each drawings sometimes have different code.
@@MariaMariaDocumentController so madam ,from your explanation, if the shop drawings has 3sheets with a same numbering , it will count as 3 ,not 1 right? So i have to input 1 by 1 per sheets? Thats what i get from your explanation mam.
@@egymoutley3371 Hi egy, yes it will be counted as 3 drawings, for all shop drawings submittal your counting will be per drawings because you will received different codes for each drawing, as per your example there are code that are revise and resubmit and other are approved, to make your report correct it is better to count it by drawings not per submittal Others you can count per submittal except for shop drawings and as built drawings. God Bless
Thank you ma'am
I just got hired as DC, napadaan ako sa mga video mo. Ngayung araw sana makatulong sa akin to lalu na aconex yung gamit namin dito sa neom
Very nice explanation. Thanks Mam.
Waiting here po tamsak done.
Appreciate ur support thanks
Tamsak at dikit na rin po waiting here ☺️
Salamat, maasahan garantisado
I like your contents dear Maria
Tamsak po waiting here
Salamat ng marami sa mabilis na ayuda
Thank you very much for your shared.
Thank you so much mam , I am here in Dubai, I am doing work as electrician, I have completed course of ms office, I want to become documents controller, this is my 4th video watching from Ur channel, thanks again
Tamsak done ihi muna ako
Salamat po
Nice
Waiting
Nice video po.
It's better to lock the excel range always whenever you're doing the counting (and just do it once). Avoid also hard-coding the criteria; it's better to refer to the cell and locking it where the criteria reside.
tamsak done
Salamat sa pag tamsak
This is good madam it helps me too much and I learned from ur channnel too much
Tomorrow will be my first day of work as document controller and I have zero knowledge about it. Thank you for making this video. I gained some ideas about it. ^_^
So how it goes?
Balita na po sa work niyo?
Thank you madam! A Big help
Tamsak te
Salamat
Hi Please make a video full tutorial for aconex?
🤘🤘🤘
Tamsak maam. Salamat po sa info
Salamat
This is very good I enjoy your videos, I've watched 3 of your videos in an hour... I'm a beginner thanks I'll subscribe to your TH-cam channel 😊🤓
Di bale ng single.. pogi naman😁
Good morning mam have a nice day
I like
Quiet Interesting, wld it be possible for you to explain the System No, (any Tutorial on ACONEX).
Good Day Ma'am pede po mag tutored sa inyo po.
Can you please add that Excel sheet here in description
Hi Maria, tell me please, can you give a online course about MS Office Document Controller?
i love you
MEP Document controller job roles, please
Mam can you plz tell me how do i install edma software in my laptop..is this a software app or something..bcz i hv best knowledge about excel..powerpoint..ms word..with a good typing speed..is this enough for a doucment controller or i hv to do something more..plz explain me mam..waiting for ur reply..
Thank you mother , but when i tried it as a same table with same column is not working it, could you please write the formula what you used in your
video, thank you mam
Hi Maam sa transmittal po . kunwari sa control#001 ibinalik dahil kailangan e revise ang control# ko is 001 pa rin ba pag magsusubmit ng transmittal for revision ? sana matulongan ako. salamat
Hi salamat sa commemt mo. Yes same ref ka parin oo1 pero lalagyan mo xa ng rev 01
@@MariaMariaDocumentController tapos pag binalik parin ang Rev.01,
Rev.02 na po ?
salamat ng marami Maam
@@Ren-tp9xw yes correct
Do you give me these templates
madam , how about this like the document have same number but included 3sheets
example : EXM-DD-SS-01 1of3 (Approved)
EXM-DD-SS-01 2of3 (Revised and resubmit)
EXM-DD-SS-01 3of3 (Approved)
its one package document , but if we insert to your format, it will count as 3 documents right? but i want it count as 1 document only since it has a same number for 3 sheets, also 1of3 is approved but 2of3 is revised , how to solve my problem ? please help me ,im new as doc control.
sorry for my super bad english, hope you can share your exprience.
Hi egi, if you are taliking about shop drawing your formula will ba counted per drawing even if it is 3 more documents in one submittal. Because each drawings sometimes have different code.
@@MariaMariaDocumentController so madam ,from your explanation, if the shop drawings has 3sheets with a same numbering , it will count as 3 ,not 1 right? So i have to input 1 by 1 per sheets? Thats what i get from your explanation mam.
@@egymoutley3371 Hi egy, yes it will be counted as 3 drawings, for all shop drawings submittal your counting will be per drawings because you will received different codes for each drawing, as per your example there are code that are revise and resubmit and other are approved, to make your report correct it is better to count it by drawings not per submittal Others you can count per submittal except for shop drawings and as built drawings. God Bless
It’s didn’t work. There is a problem in the formula
thank you for your comment just try it again maybe you miss something
No mam not working this@@MariaMariaDocumentController
How u get the total? U didt not me tion how u get the total in formula
during talking please do not add any background music because it distrube the voice of presentation
This formula is not working, what could be the reason? can you help pls?
Just check the rows started , the columns maybe its not all same, make it all same then it will work.
Waiting