14 күн бұрын
3 ай бұрын
Пікірлер
@iMeIanchoIy 6 күн бұрын
Thank you bro! This is really useful 🙏🏻
@sholihnugrohohadisholih2729 6 күн бұрын
@@iMeIanchoIy thanks for subscription and comment
@mainkegresik9958 16 күн бұрын
Greeting Mr Sholih, how do you install DEA add ins in excel which provide the feature that can solve cost, revenue, and profit in DEA? thanks
@sholihnugrohohadisholih2729 16 күн бұрын
@@mainkegresik9958 you can use solver. Click file, option, add in, go, check list solver, ok. Than you click data, solver
@mainkegresik9958 15 күн бұрын
@sholihnugrohohadisholih2729 thx a lot, anyway would you make tutorial video about installing DEA solver in excel next time?
@sholihnugrohohadisholih2729 15 күн бұрын
@@mainkegresik9958 yes sure. When I have spare time, I will make the video for you
@sabilfajarfath6780 15 күн бұрын
@@sholihnugrohohadisholih2729 thx mr sholih
@sholihnugrohohadisholih2729 14 күн бұрын
I have provided tutorial how to install solver in excel. please find my video in following link kzbin.info/www/bejne/fmK7l4WkhMyEoKc
@samiranadjafnia 23 күн бұрын
Dear Sholih, May I ask for the SBM-DEA output-oriented calculations on excel? I tried to make it, but faced error, I'm not sure where did I make the mistake :(
@sholihnugrohohadisholih2729 23 күн бұрын
@@samiranadjafnia yes sure you can
@samiranadjafnia 23 күн бұрын
@@sholihnugrohohadisholih2729 Thank you so much. Will you send something on email? or is there any online video for that?
@sholihnugrohohadisholih2729 23 күн бұрын
@@samiranadjafnia you should try first. Then the results send to my email
@samiranadjafnia 24 күн бұрын
Hello dear Sholih, a question: I weighted DEA applicable on Supper Efficiency model as well?
@sholihnugrohohadisholih2729 24 күн бұрын
@@samiranadjafnia yes you can do it in excel
@samiranadjafnia 24 күн бұрын
@@sholihnugrohohadisholih2729 Thanks, I applied it and was correct.
@bouchac01 24 күн бұрын
Hello, thank you such for the video but at 11:55 you dont show what you put after * in the index. Can you tell us what number it was?
@sholihnugrohohadisholih2729 23 күн бұрын
Input in DMU under evaluation multiple by efficiency score. In this case, efficiency score is in cell e9
@samiranadjafnia 26 күн бұрын
Hello dear Sholih, Hope you are fine. May I ask for the presentation file, presented in this video? I want to apply output-oriented slack calculations and need the programming formula for that. Thank you so much
@sholihnugrohohadisholih2729 26 күн бұрын
@@samiranadjafnia sure, you can get it. Tomorrow when I open my laptop 💻 I will send my excel sheet to your email
@samiranadjafnia 26 күн бұрын
@@sholihnugrohohadisholih2729 Thank you so much. Do you mean the excel sheet with the formula for output-oriented slack approach? Because if you don't have it, it's totally fine. Just to have the powerpoint slides would work then as the formulas are mentioned there. Really appreciate your support, thanks.
@samiranadjafnia 28 күн бұрын
Thank you so much for the thorough explanations that you provided through the whole DEA video series. Really useful and comprehensive. I have some difficulties on my excel DEAFrontier. It seems it doesn't work properly. Is there any way I can contact you online to explain and ask for your guidance?
@sholihnugrohohadisholih2729 28 күн бұрын
@@samiranadjafnia I guess your macro setting is disabled. Please check. If your macro is disabled, you can change to enable
@samiranadjafnia 28 күн бұрын
@@sholihnugrohohadisholih2729 May I ask for an online session on MS Teams for example so that I can share my screen and show you what happens to my file? I am doing my thesis analysis and am really stuck here :(
@sholihnugrohohadisholih2729 28 күн бұрын
@@samiranadjafnia you can screen shoot your problem. Then, you send the picture to my email: [email protected]
@samiranadjafnia 28 күн бұрын
@@sholihnugrohohadisholih2729 Thanks, will do it right now and will share my file with you as well.
@mango3915 2 ай бұрын
Hi~~ I have question when running the data with this DEA model . Can you help me to see where is the problem with my data. Really appreciate this😭🙏🙏Thank you so much
@sholihnugrohohadisholih2729 2 ай бұрын
@@mango3915 you can see this video step by step
@halizarosita 3 ай бұрын
Kenapa sum lambda = 1 tidak dimasukan pada constraint ya? Dan mau tanya apakah model sbm dengan undesirable output tidak memerlukan asumsi crs atau vrs?
@sholihnugrohohadisholih2729 3 ай бұрын
@@halizarosita sbm with undesirable output (tone 2004 model) menggunakan asumsi crs. Oleh karena itu tidak menggunakan constraint sum lamda = 1
@nerwynjaywales3271 3 ай бұрын
Sir can you share your excel to us for research porpuses
@sholihnugrohohadisholih2729 3 ай бұрын
Find the excel file by click following link docs.google.com/spreadsheets/d/1D31s5GZRT48ouwiTE8k4KHnyQ1wb281g/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@antoniomonzon0616 3 ай бұрын
could you upload the excel file? I have several doubts with a couple of cells
@sholihnugrohohadisholih2729 3 ай бұрын
please download by using link bellow docs.google.com/spreadsheets/d/1ob_EuYhUmruhlRQ_o8LQKlsuZoRWDGat/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@lemuelpreciados3323 6 ай бұрын
May I know your basis for the reference set in your example? I would greatly appreciate your providing the sample spreadsheet in the video. Thanks.
@sholihnugrohohadisholih2729 6 ай бұрын
@@lemuelpreciados3323 thanks very much for your comment. Yes, sure. I would like provide link for dataset later
@sholihnugrohohadisholih2729 6 ай бұрын
please find my link that I share to you. Hopefully it bring benefit for you docs.google.com/spreadsheets/d/1isa76SZGkcgB8U3hyOtKkMxBNpnwSSp1/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@ribkhyaminoo6137 6 ай бұрын
videonya bagus mas jadi membuka pemahaman saya, penjelasannya bagus tapi ada beberapa part yang suaranya kurang jelas. saya request jika berkenan, mungkin bisa bikin penjelasan dengan bahasa indonesia mengenai dea ini mas. kebetulan saya lagi penelitian skripsi tentang data envelopment analysis
@sholihnugrohohadisholih2729 6 ай бұрын
@@ribkhyaminoo6137 terimakasih mas sarannya. Kl ada pertanyaan silahkan saja mas disampaikan, semoga saya dapat membantu
@039ekosaputro3 6 ай бұрын
Buka kursus gk kak
@sholihnugrohohadisholih2729 6 ай бұрын
@@039ekosaputro3 belum buka pak. Terimakasih atensinya
@Amadeus13 7 ай бұрын
Where i can download that DEA Solver? Is it free to download?
@sholihnugrohohadisholih2729 7 ай бұрын
@@Amadeus13 saitech.capoo.jp/en/profile-of-dea-solverpro/
@sholihnugrohohadisholih2729 7 ай бұрын
It's not free
@Amadeus13 7 ай бұрын
@@sholihnugrohohadisholih2729 do you have any sugestion of another software that free to use for calculating tge DEA Method? I need to calculate DEA 27 DMU with 7 Outputs and 4 Inputs
@Amadeus13 7 ай бұрын
*Free software
@sholihnugrohohadisholih2729 7 ай бұрын
@@Amadeus13 DEAP is free. Deafrontier also have free version
@allaboutwomen2023 8 ай бұрын
it says that "Objective Cell contents must be a formula", can we have this excel file?
@sholihnugrohohadisholih2729 8 ай бұрын
docs.google.com/spreadsheets/d/16zFQUIuOPdc0xQ5V4R7xo9x7XQpVuMQX/edit?usp=drivesdk&ouid=105464613257783263082&rtpof=true&sd=true
@googalemeet 8 ай бұрын
Mine is error whenever i add asterisk on the index formula
@sholihnugrohohadisholih2729 8 ай бұрын
You can follow step by step in next video
@nurulcantikaprameswarihabi4579 8 ай бұрын
Hello sir. Thank you for your video. I just followed the steps with 10 DMUs, 2 inputs, and 5 output. However all DMUs efficiency is 0. is it something normal? if all the efficiency is 0, how do we choose the reference, sir? thank you
@sholihnugrohohadisholih2729 8 ай бұрын
Rule of thumb for minimum number of sample are three times total variable (input and output). In your case, you have 2 input and 5 output. It mean totally is 7 variable. You should have minimum 21 DMU
@LeThiThuNgan-fl7pe 9 ай бұрын
I would undertake same way but I don’t know why CCR method alway equal 0😢
@LeThiThuNgan-fl7pe 9 ай бұрын
I would undertake same way but I don’t know why CCR method alway equal 0😢
@sholihnugrohohadisholih2729 9 ай бұрын
I don't know what happen in your sheet. I suggest you to make sure the formula is correct. The goal also correct, minimize or maximize. If you can't solve it, please tell me. I will send you my Excel sheet
@sholihnugrohohadisholih2729 8 ай бұрын
docs.google.com/spreadsheets/d/16zFQUIuOPdc0xQ5V4R7xo9x7XQpVuMQX/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@LeThiThuNgan-fl7pe 9 ай бұрын
I would undertake same way but I don’t know why CCR method alway equal 0😢
@LeThiThuNgan-fl7pe 9 ай бұрын
I would undertake same way but I don’t know why CCR method alway equal 0😢
@adebiyibolaji 10 ай бұрын
Hi there, I followed your DEA model for my data and the Excel solver replied that the objective cell must contain a formula. The efficiency cell is empty
@sholihnugrohohadisholih2729 10 ай бұрын
The objective sell is our objective. In the restrictions for dmu under evaluation, index (input, dmu under evaluation) * objective. Alongside, the lambda, the objective also the cell in the change variable. Hopefully you can practice well. When you still get trouble, let me know
@adebiyibolaji 10 ай бұрын
@@sholihnugrohohadisholih2729 Thanks
@allaboutwomen2023 8 ай бұрын
@@sholihnugrohohadisholih2729 how did you get the objective, we have the same case but 1 input and 2 ouput only.
@sholihnugrohohadisholih2729 8 ай бұрын
You can see in next videos
@adebiyibolaji 10 ай бұрын
Hi there, I followed yours DEA model for my data and the silver replied that objective cell must contain a formula. The efficiency cell in empty
@sholihnugrohohadisholih2729 10 ай бұрын
Thanks for your comment. The efficiency cell is our objective. For restrictions in dmu under evaluation, index(input, dmu under evaluation) * objective. You can try again, hopefully you get success. When you still fail, you can inform me again. I will send you my Excel sheet.
@googalemeet 8 ай бұрын
Hello how did you get the objective
@sholihnugrohohadisholih2729 8 ай бұрын
@@googalemeet which one Dea model do you want? I will upload the excel sheet. Therefore, you can check and learn from that
@googalemeet 8 ай бұрын
I mean the figure under efficiency. Where can i access the file thanks in advance
@sholihnugrohohadisholih2729 8 ай бұрын
@@googalemeet docs.google.com/spreadsheets/d/16zFQUIuOPdc0xQ5V4R7xo9x7XQpVuMQX/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@انتةونتهنااة 11 ай бұрын
Can you help me find super efficiency
@sholihnugrohohadisholih2729 11 ай бұрын
Yes sure. You can watch my video about super efficiency. I have already uploaded it
@sholihnugrohohadisholih2729 11 ай бұрын
kzbin.info/www/bejne/mV6VaIN5qJymatEsi=Lo9jGouWdTh21f-b
@انتةونتهنااة 11 ай бұрын
@@sholihnugrohohadisholih2729 If I send you the data, can you find superior efficiency?
@mustainnaufal8867 Жыл бұрын
kenapa baru muncul mas huhuh, aku skripsi pake sbm-dea tapi susah mahami sendiri. besok udah sidang, makasih mas udah mencerahkan
@sholihnugrohohadisholih2729 Жыл бұрын
Maaf mas baru sempat buat. Teman2 saya mendorong saya untuk buat tutorial tentang statistik dan sebagainya. Semoga sukses mas ujiannya dan mendapatkan hasil yang memuaskan, amin
@astrianto6076 Жыл бұрын
What an amazing video brader....
@sholihnugrohohadisholih2729 Жыл бұрын
Thanks very much my brother
@nicoswart2002 Жыл бұрын
Thanks, providing the code, and maybe the excel sheet somehwere would be usefull.
@sholihnugrohohadisholih2729 Жыл бұрын
thanks very much for your comments. I have provided the link for downloading the excel sheet example
@sholihnugrohohadisholih2729 Жыл бұрын
docs.google.com/spreadsheets/d/1bG-PWwEQMvJ4HyO49hI2ep4pNxV5_54x/edit?usp=sharing&ouid=105464613257783263082&rtpof=true&sd=true
@nicoswart2002 Жыл бұрын
Greatly appreciated, keep up the work@@sholihnugrohohadisholih2729
@adebiyibolaji 10 ай бұрын
@@sholihnugrohohadisholih2729 Hi thanks for the Excel link. Please can you explain how you get the efficient input and output target
@sholihnugrohohadisholih2729 10 ай бұрын
@@adebiyibolaji Dea slack calculation is second stage calculation. First stage we calculate the score of efficiency. Score of efficiency results in the first stage, we take it to the second stage to get the slack value
@davamdw Жыл бұрын
Keren kali pak 😁👏
@sholihnugrohohadisholih2729 Жыл бұрын
Semoga bermanfaat untuk penelitian mas dava
@choirulnikmah-irul2508 Жыл бұрын
MasyaAllah bermanfaat sekali... lanjutkan!!!!!!!!
@sholihnugrohohadisholih2729 Жыл бұрын
Terimakasih supportnya untuk Chanel ini
@juna9996 4 жыл бұрын
Endapan nya bisa dipakek apa nggak mas
@sholihnugrohohadisholih2729 3 жыл бұрын
bisa mas. di usapkan dibatang pohon
@dilliyuda9974 4 жыл бұрын
😍😍