Advanced Exam Seating Plan in excel | Fully automated seating plan for exam | exam seating plan
ฝัง
- เผยแพร่เมื่อ 5 พ.ย. 2024
- Advanced Exam Seating Plan in excel | Fully automated seating plan for exam | exam seating plan.
#examseatingplan #seatingplan #seatingplaninexcel #computergyanguruji
File download link: drive.google.c...
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Thank you so much for this video.
This is a very good and most helpful one that I found.
But, it doesn't meet my requirement as it work fully for a single series of roll No. that doesn't contain Alphanumeric. I planned to make a seating plan for Classes I-X for their exams where every classes roll No. starts with 1 and continues till the end for each classes. And, there has to be an indication on which roll No. belongs to which class. So, I made a roll No. series of alternating classes using alphanumeric and with some modifications as per my needs.
The complicated part is to show the range of roll Nos. allotted for each classes in a particular room.
Thank you so much.
watch this video here they have created this template with alphanumeric roll number
th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
Thank you for giving the file download link
Ok sir thanks for giving valuable
Sir plz sitting plan with A,B,C,D in every row
Bahut sundar tarika bataye aapne iske liye bahut bahut dhanyawad
Mixed condidate wala ka links vejiye sir
watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
this video is very useful to me thanks Manoj Sir ji
Sir,
Row mai 1 roll no. Ke baat 1 khaali rakh skte hai kya?
Very helpful, waiting for the next video on seating plan
HELLO SIR, if i want the seating to be in SNAKE ORDER, then what modification has to be done. Please assist. means the second row dont start from the front, but from the back, the third row starts from the front so on like a transverse wave
Sir
Ye seating plan mil jayega kya
1. 15 class room
2. 12 row ka
3. 12 line
Thank you this was very helpful. How can you transfer the series of number from a specific row of series of numbers? Because some learners who don't do certain subjects should not appear on the seating plan.
Thank you
Excellent, but I want to know how i will be able to make arrangement with two different roll no series?
For example one for boys roll no and another for girls roll no. and we have to make seat arrangement in zigzag way.
Please suggest.🙏
Great suggestion! i will upload soon
Good Question 👍🏼
watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
sir, u did a very good work, superb. Truely u are our inspirational
Thank u sir
Very very helpful
And very easy
Many to many things learn there 💞💞💞💞💞💞
First of all thanks. .
The way you described it all was very great and easy too. But here I have a question. And I hope that you will answer it in the same way.
Now I have two or three different papers in the same day that I have to set so when the roll numbers of one subject ends then how will the roll numbers of the other subject start.
Reply???????
???????
Reply??????
hlo sir your every video full of knowledge, i am waiting for your school class mix student seating plan video last 1 year. plz make a video on it.
I think he don't know how to do it. I need it too.
watch this video here they have created this template with alphanumeric roll number and class mix seating plan th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
@@mohitbansal5369 watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
I can provide you seating plan for mix students
Hi sir very nice but Yadi koi roll nuber continue n ho to kya karna chahiye
Bahut hi badiya tha sir
Dear Sir you Did a excellent job. I am facing a problem after last Rollno it shows 0 in the last room in remaining seats. Can you help that it will not retrieve blank cell values.
Regards
This is very good setting plan but i have a problem that we have regular and private roll no in our college. The regular roll no is bigger in size then the private roll no. The problem is that it does not give the max value in the excel. The regular roll no is end at the middle of the room .the max value shows the middle value
The problem is that when we left a room it gives a problem of the min and max value and another room will not show the roll no
Nice. Thank you so much. From bangladesh
Can we make seating plan alone with class for example VIIA 01 VIIA 02......
yes watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
Good morning sir thanks for giving advanced sitting plan
Plz if u give plan formula for for
Such column roll no 1,2,3,4,5,6
And in other column A,B,C,D,E,F
Pls 🙏
Thank you so much. That was really awesome.
Great job . Dear sir kindly create auto generated school timetable program in excel
Sir , mix (2,3,4 ya 5 school/type 1by 1) students ki seating plan kaise banaye
Sir RA motlab kay hain? what is the meaning of RA in Roll No. From logic?
Dear sir the best
Thx
Jitendra patel
Gujarat
Look Mind blowing sir
agar ek two seater bench me U pattern me bethe to kese bnaye?
Sir exam duty chart or planing ka bhi dalo plz
Sir Namaste when typing reference formula a window is open and saying there is a problem with this formula.
Hello sir thanks for this video post
Please make a video for seat plan of different class roll no. In mixed class in a room.
soon
@@ComputerGyanGuruji when to post mixed class seating plan
my college has seat number like this EC5041,CE5041,CO5041, and above formula in not working for the given seat number, please provide solution.
Min.if the formula you typed contains an error
Aa raha hai salution bataye.
Mix student ka seating plan per video nhi banai sir
Sir excel 2007 vs 2010 vs 2016 & 2019 mai kya anter hai
Sir pleass give the video for mixed class in a room. Thank you
mix seating plan के बारे मे बताये सर ।
सर मैं आपकी वीडियो हमेशा देखा करता हूं और बहुत कुछ सीख पाया हूं सादर धन्यवाद, सर इस सिटिंग प्लान में एक ही सीरीज के नंबर या एक ही क्लास के बारे में सोचा जा सकता है अगर बहुत सारे कोर्स के रोल नंबर को मिक्स कर सीटिंग प्लान बनाना हो तो कैसे बनाएं। और अगर रोल नंबर के स्थान पर आईडी नंबर अर्थात अल्फान्यूमैरिक नंबर हो तो यह कैसे बनेगा मैंने कोशिश की है और कुछ हद तक यह कर भी पाया हूं लेकिन अलग-अलग क्लास के रोल नंबर को अल्टरनेट बिठाने में असमर्थ हूं कृपया सहायता करें।
good work ji. keep it up. row1 is in ascending order it's ok next I want row 2 in descending order. what formula ( I want Every next row is in descending order, Thank you in advance )
SCHOOL KA WEEKLY TIMETABLE KAISE BANAYENGE?
Amazing.. thank you sirji
I can not apply such formulas for exam seat arrangement excell sheet. Ple reply me sir.
Thankyou Sir 🙏
Very Thanks
Aage wali mix class ki vidio kaha he sirji
Make a sitting plan for different class like 3rd to 12th
Reply soon sir
watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
@@gagandeepclasses7918 watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
Aweosome Video sir
What to do when there are odd number in roll number means not in serial number
Sir isme set A,B,C,D kaise dale automatic ispe bhi video bnaiye
What if my roll no start from character
Eske bad valaa plan agar banaya ho to link bataiye
Thank you sir.
agar 3 ki jagha 4 row chiye to ?
Sir any update on next video regarding sitting plan
Thank u 🙏
नमस्ते सर
ये व्हिडीओ बोहत अच्छी बनी है... मेरी एक प्रॉब्लेम इसमे यह है की, आप इसमे एक व्हिडिओ अशी लाए की अगर 1st row 10 और 2nd row भी 10 का है और मुझे दुसरे row मे 15 sr. no से दुसरे विषय के student का सिटिंग plan ऍड करवणं है तो कैसे करे..
RESPECTED SIR NAMSTE SIR
I WANT TO SUBJECTWIST EXAM SEATING ARRANGMENT FOR CLASS 9TH TO 12TH SUDENTS FACULTIIESWISE PLEASE SUGGESTED ME ..................THANKS SIR.
watch this video here they have created this template with alphanumeric roll number th-cam.com/video/OrwnPf00Tkk/w-d-xo.html
Great Sir
Mix series kab seating plan
Good sir
sir ek hi room/hall me mix class(roll no) ki sitting kese kare
Hello sirrre ....... I want your help .... My laptop consume to much internet without doing any thing .....
I am using window 10 ... Many setting i have changes in my laptop. ... Just like On Metred option , All back ground apps off, Auto updates off... I am doing all the
things that i learn in TH-cam
But can not sucessful 😞😞😞😞😞😞😞
Please help me
After turning off windows auto update, there should be no
Sir apne different class ke liye video nhi dala
Nice video of sir,
You can contact for that , I can help u out
Sir pura data select nahi ho raha hai???
Samadhan kare
Dear Sir, Thank you very much for your most useful “Advance Exam Seating plan”. It’s very nice. But I want some more modifications. If possible, please provide. I will mail to you.
For more advanced sheet mail to shinesexcel@gmail.com
Yes sir I can modify in this seating plan for three different series like three different classes
@@excellencemathsteacher1040 Pls. send demo
Column data sir not a row
Row is horizontal column in vertical
please share next video
दो सीरीज के बच्चे बैठे हुए हैं तो उन्हें मिनिमम और मैक्सिमम कैसे अलग-अलग सीरीज
Yehi question Mera b hey
आपके फाइल में मै कुकुछ बदलाव किया हु पर रूम न. १०३ में फंस गया हु , कृपया डाउनलोड करके सही कर दे | क्या आप अपना ईमेल देंगे जिससे मै उसे भेज सकूँ ?
hello sir
please make telegram group
thank you
When will release next part
SOON
Reference mai error ref. Aa raha hai
i want this file
सर वोटर लिस्ट की pdf को एक्सेल के कैसे कन्वर्ट करे
Need a sheet for school time table
Sir
My roll nos. Are mixed like 11A001 to 11A77
Tab kya karenge
exam seating plan ke hamne alag alag kai video banaye hain
@@ComputerGyanGuruji Sir, Link please!
Zigzag seat plan...video
I work in College where Roll Numbers are alpha numeric. Plz make a video for such cases. Also if possible please give your contact number so that I may correctly define my problem with you.
Regards
can we make it on same sheet????