Thank you so much for your kind words @DzmitryPetrushenka ! Glad you found the video useful. If you have any questions or need further clarification on anything, feel free to ask!
@kronen_bob2 ай бұрын
HUGE help! I searched other ways and none of the functions worked until I found your video! Thank you for your videos.
@LeanStrategiesInternationalLLCАй бұрын
Glad it helped @kronen_bob If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@johnjershoff47712 ай бұрын
What a great pneumonic!
@LeanStrategiesInternationalLLC2 ай бұрын
Thank you @johnjershoff4771. The one piece pneumonic is in our Pull Systems course. If you would like more information on it you can visit: www.leanstrategiesinternational.com/pullsystemscourse.html
@BH-gh6qm2 ай бұрын
some unique ears on this fella
@LeanStrategiesInternationalLLCАй бұрын
They sure are. Cellular layouts are also a powerful way to reduce noise in a plant as they provide a cell that encloses much of the sound. Do you use cellular layouts? Learn more about Cellular manufacturing here: www.leanstrategiesinternational.com/glossary/cell
@SephinAlexander2 ай бұрын
Thank you!
@LeanStrategiesInternationalLLC2 ай бұрын
You're welcome @SephinAlexander! If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@migueljaballas813 ай бұрын
Big help man!
@LeanStrategiesInternationalLLC2 ай бұрын
Awesome! Happy to help @migueljaballas81 we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@Ultimate-dude3743 ай бұрын
Yes but I didn’t have my phone so I couldn’t record😭
@LeanStrategiesInternationalLLC3 ай бұрын
Glad you got to see it! Sorry you didn't get a recording.... :( Maybe next time?
@Ultimate-dude3743 ай бұрын
I will do that but it will be a long time to wait
@LeanStrategiesInternationalLLC3 ай бұрын
Fun! Thanks for visiting the community @isaiahuribe8677
@user-sf3sn5qm1n3 ай бұрын
yes
@LeanStrategiesInternationalLLC3 ай бұрын
Awesome! Thanks for sharing.
@De_Doods3 ай бұрын
What did he share.??
@LeanStrategiesInternationalLLC3 ай бұрын
Excellent question! They shared that they got to see the solar eclipse. Did you see it @Dood281 ?
@user-cd6yn5ny7j3 ай бұрын
Wooow🎉great,brilliant solution! Without difficult scripts and soooo simple❤ thank you sooo much 😊
@LeanStrategiesInternationalLLC3 ай бұрын
You are very welcome @user-cd6yn5ny7j we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@shotgunheist65363 ай бұрын
big thanks
@LeanStrategiesInternationalLLC3 ай бұрын
You are very welcome @shotgunheist6536 we appreciate the #graditude of your comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@tetianahirun57653 ай бұрын
Great explanation
@LeanStrategiesInternationalLLC3 ай бұрын
Thank you @tetianahirun5765. You can find more #googleworkspace content here if you would like: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@WarmApplePye4 ай бұрын
My date keeps showing 30th December 1899?
@LeanStrategiesInternationalLLC3 ай бұрын
Hi @WarmApplePye, thank you for asking this. The default date in #googlesheets is December 30, 1899. With that in mind your date will default to this time. Try checking your box, unchecking it and then checking it again. If your sheet is setup and formatted the same way as the one in the video this will correct the date. Thank again for being a part of the community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@kennethparker60054 ай бұрын
Great video!!! I haven't used spark-line before but you have made it look relatively easy. Thanks.
@LeanStrategiesInternationalLLC4 ай бұрын
Glad it was helpful @kennethparker6005! If you would like more content on Google Workspace Checkout this playlist we have: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@karolpaz40904 ай бұрын
Perfect video, thanks so much!
@LeanStrategiesInternationalLLC4 ай бұрын
Thank you @karolpaz4090 we appreciate the #positive comments in the #community. If you would like more helpful videos on Google Sheets, please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@mas-daym4 ай бұрын
Woahhh thank u sir, I learn a lot from this :D
@LeanStrategiesInternationalLLC4 ай бұрын
Thank you for sharing that @mas-daym. If you would like more #youtube content on #googleworkspace please follow the link here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@soumiamoujane36955 ай бұрын
Can I do this worksheet in Microsoft Excel?
@LeanStrategiesInternationalLLC5 ай бұрын
Hi @soumiamoujane3695 and thank you for commenting in the community. There are many different ways to create "progress bars" in excel. Here is a link to some other videos on KZbin that may be helpful. Thanks again for commenting. kzbin.info?search_query=Creating+a+Progress+Bar+in+Excell
@user-sb8jj2in9i5 ай бұрын
What ?!
@LeanStrategiesInternationalLLC5 ай бұрын
Thanks for the question @user-sb8jj2in9i. Lot size and Lot sizing can be a difficult concept to understand. If you have a specific question please feel free to share it here or, for more information on Lot Size please visit: www.leanstrategiesinternational.com/glossary/lot-size
@unknown-zr6ef5 ай бұрын
Thank you friend
@LeanStrategiesInternationalLLC5 ай бұрын
You are very welcome. Please feel free to #share with others.
@ikatefx5 ай бұрын
Thank you!!
@LeanStrategiesInternationalLLC5 ай бұрын
You're Welcome! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@user-gg1ww1nf2j5 ай бұрын
Thank you sir. You've just saved my day!!
@LeanStrategiesInternationalLLC5 ай бұрын
Glad this helped! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
5 ай бұрын
Thanks! It was really helpful!
@LeanStrategiesInternationalLLC5 ай бұрын
Glad it helped @Aprenderinglesdlc. For More of our Workspace Wednesday Content Please Feel Free to Visit: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@bheinaudiobenson23935 ай бұрын
The inspector looks nice person And beautiful and the production area looks so good and neat.
@LeanStrategiesInternationalLLC5 ай бұрын
We agree @bheinaudiobenson2393! The area looks like its in great 5S Condition and in the background there is even an andon light. Way to go superstar inspector! For more information on 5S visit: www.leanstrategiesinternational.com/glossary/5s-system. And, for more information on Andons visit: www.leanstrategiesinternational.com/glossary/andon
@user-ne1sz8mk9r5 ай бұрын
And as part time, she's a black Jack dealer..
@LeanStrategiesInternationalLLC5 ай бұрын
Thanks for commenting Shamsol Hassan (@user-ne1sz8mk9r). She definitely would be a good one!
@prototype_0xD15 ай бұрын
So this is a visual and partial function test. I'd like to see an actual load/short test.
@LeanStrategiesInternationalLLC5 ай бұрын
Thank you for your contribution @prototype_0xD1. We'd love to see other forms of tests too. In the case of this example it may be placed in other portions of the process, as we only a small piece of it. None the less this employee is an allstar. Also, you can learn more about function checks here: www.leanstrategiesinternational.com/glossary/function-check8292825
@72FrostyOne5 ай бұрын
Function check of circuit breakers, she is quick!
@LeanStrategiesInternationalLLC5 ай бұрын
Thank you for sharing @youremadimeducated. You can learn more about Function Checks Here: www.leanstrategiesinternational.com/glossary/function-check8292825
@tsscapac72265 ай бұрын
thank you , i am using it
@LeanStrategiesInternationalLLC5 ай бұрын
Glad to hear it @tsscapac! If you want more Google workspace tips check out this playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW&si=94iq8-SjEg_o191G
@moisessouza28456 ай бұрын
Pelo jeito vai acabar a comida da mamãe e da vovó 😂😂😂
@LeanStrategiesInternationalLLC5 ай бұрын
Talvez? LOL
@brilliantbrainz64706 ай бұрын
Great video, my sparks are only showing 1 colour even afterI select a data set
@LeanStrategiesInternationalLLC6 ай бұрын
Thank you. There are several reasons this may happen: color code changes, formatting, etc. If you require further more specific assistance in resolving this, please consider sharing your formula and the relevant sheet. If we can't get to it right away, somebody in the community may also be able to assist. Thanks for commenting.
@sion94536 ай бұрын
Great explanation thank you!!
@LeanStrategiesInternationalLLC6 ай бұрын
Glad it was helpful @sion9453. Please feel free to #share it with your friends. Also, if you would like more #supplychain and #operations content please feel free to visit our website here: www.leanstrategiesinternational.com/
@user-zn7kr7ib5h6 ай бұрын
Doc brown would be proud
@Cola_mans6 ай бұрын
This is not stir fry this is spin fry
@LeanStrategiesInternationalLLC6 ай бұрын
😆
@Santorien6 ай бұрын
Lmfao what am I watching? and how is it not spilling?
@LeanStrategiesInternationalLLC6 ай бұрын
Automation in the Kitchen 😀. What do you think @Santorien? Taste Good?
@SandeepSharma-fd6zz6 ай бұрын
Fill Rate Percentage: 78.33%. Since the business is in medical segment, I will order from other supplier to meet the demands and this solution is possible of Fill rate concept only. Thank You sir.
@LeanStrategiesInternationalLLC6 ай бұрын
Great Job @SandeepSharma-fd6zz! If you are interested in more information on Fill Rate Please Feel Free to Visit: www.leanstrategiesinternational.com/glossary/fill-rate
@user-uf3ol7kc4v6 ай бұрын
I have follow this to use "=DAY(TODAY())" with time zone CST and iterations on in settings but all dates get updated ever day automatically, is there any way so that the past date stay same and dont get updated? any quick response would be appreciated .
@LeanStrategiesInternationalLLC6 ай бұрын
Thank you for asking @user-uf3ol7kc4v. It looks like your formula would update everyday. Try watching the video (kzbin.info/www/bejne/d6SqqqKhfJt8irssi=5snaA7c5SmbK3vKl) and adjusting your formula based on the video. Please note the cell references that you use may be different from the video.
@user-dq6gq2ng7s7 ай бұрын
Thank you!
@LeanStrategiesInternationalLLC7 ай бұрын
You're welcome! For more Tips on Google Sheets Visit the Link Here: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@user-ud8cq6tq6h7 ай бұрын
When i type , after false the word false change to black insted of stay in blue.
@LeanStrategiesInternationalLLC6 ай бұрын
Thanks for sharing this. You might want to re-check your formula.
@karthiksree15987 ай бұрын
Customer
@LeanStrategiesInternationalLLC7 ай бұрын
Very Good @karthiksree1598. For More Information on Pull Systems Visit: www.leanstrategiesinternational.com/glossary/pull-system
@goochnukem49507 ай бұрын
So have better equipment and higher double triple the people kind of the opposite of what lean does
@LeanStrategiesInternationalLLC7 ай бұрын
Thank you for sharing your thoughts @goochnukem4950. In this example we see two activities that occur. Internal Setup Activities (www.leanstrategiesinternational.com/glossary/internal-setup) and External Setup Activities (www.leanstrategiesinternational.com/glossary/external-setup-time). While improving tooling and resources is definitely noted in this example the biggest improvements actually occur during the external. For example: People are in position prior to the vehicle arriving, tools are positioned appropriately, materials are on site and in place and each resource has a standard procedure to follow. In addition to this you are correct, internal improvements occur as well. Resources are balanced, tools are improved and capacity is expanded. It is important to note that these improvements, while not nearly as large as the activities that are improved during external changeover time can contribute to improved changeover times as well and typically would be performed only after reductions in muda ( www.leanstrategiesinternational.com/glossary/muda) or other non-value adding (www.leanstrategiesinternational.com/glossary/non-value-added) activities have been performed.
@marylepage9607 ай бұрын
Thank you for making this video! I've wanted a function like this for a while
@LeanStrategiesInternationalLLC7 ай бұрын
No problem! Glad We could help. Thanks for being a part of the community. Also, If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@the_human_guide8 ай бұрын
Super helpful. Your branding is hilarious. It gives me Nepolean Dynamite vibes,
@LeanStrategiesInternationalLLC8 ай бұрын
Glad you liked it and thank you. Napoleon Dynamite is a great movie! ┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌█████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌███████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌███┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌████████████┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌ ┌┌████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌ ┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌█████████┌┌ ███┌┌┌┌█████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌█████┌ ██┌┌┌███████┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌███┌ ██┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ███┌┌┌┌┌┌┌┌┌┌┌█████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌┌┌┌┌┌┌████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌████████████┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌██████┌┌┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌┌┌┌┌┌┌┌┌┌┌██████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌████┌████┌██████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌┌████████████┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌███┌ ┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌███████┌┌┌┌┌┌┌███████┌┌ ┌┌┌┌████┌┌┌┌┌┌████████┌┌┌┌┌┌┌┌████████┌┌ ┌┌┌┌┌████████████┌┌┌███┌┌┌┌┌███┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌█┌█┌┌┌┌┌┌███┌┌┌███┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌┌┌█████┌┌█████┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██████████████████┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌██████████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌
@johnjershoff47718 ай бұрын
This video is very helpful! Thank you the function works perfectly. Do you have one that includes a percentage?
@LeanStrategiesInternationalLLC8 ай бұрын
Awesome! And, thank you. Yes we have a progress bar Chart with a Percentage. Try this out and let us know if you have any questions: kzbin.info/www/bejne/jpyveXmAmJ2cpLc
@HasanJaffrey8 ай бұрын
This is helpful, thank you! Is there a way to add % to the progress bar?
@LeanStrategiesInternationalLLC8 ай бұрын
You’re very welcome. And, great question @HasanJaffrey. Try this video and see if it helps. Please let us know if you have any other questions….. kzbin.info/www/bejne/jpyveXmAmJ2cpLcsi=qu2DZ4WfaKB1iO3r
@stefanomastropietro90408 ай бұрын
Work in Process or progress ?
@LeanStrategiesInternationalLLC8 ай бұрын
Hi @stefanomastropietro9040 Great question! WIP, is referred to as Work in progress and/or process. Both refer to one form of inventory. WIP is the work that is in process or production at a stage that falls between raw material and finished product. You can find more information Here: www.leanstrategiesinternational.com/glossary/work-in-progress-wip
@PBTophie8 ай бұрын
This works a treat! After writing a script that didn't work perfectly, this was all I needed. Hilarious. Thanks a million!
@LeanStrategiesInternationalLLC8 ай бұрын
We are happy to help. If you're interested in more Google Workspace Tips Please Visit the Link Here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@johnjershoff47718 ай бұрын
This is an awesome video! Works perfectly on this template. I’ve also used in other templates with only minor changes. Lean Strategies International LLC should make a Google Sheets series.
@LeanStrategiesInternationalLLC8 ай бұрын
Glad it was helpful, @johnjershoff4771! You can find more tips on Google Workspace Here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW&si=1x7QQP-yk5c0XOaI
@johnjershoff47718 ай бұрын
@@LeanStrategiesInternationalLLC love it!
@user-ib8bj3pm3e8 ай бұрын
Finally found an easy solution to this timestamp task. Thank you! Also, looks like the Fonz got into spreadsheets after Happy Days?
From all the videos I've watched this video is the easiest to understand most especially for students like!
@LeanStrategiesInternationalLLC8 ай бұрын
Thank you very much @jeraldbuniag2018. If you would like more information you can visit: www.leanstrategiesinternational.com/glossary/independent-demand. Or for dependent demand you can visit: www.leanstrategiesinternational.com/glossary/dependent-demand
@Vinceyu8428 ай бұрын
❤
@LeanStrategiesInternationalLLC8 ай бұрын
Thanks for showing the love @Vinceyu842. Independent and Dependent Demand Can Be Tricky. Do you have any other questions on Demand Management?
@andreibrahinets97999 ай бұрын
Thanks , how to do it vertical progress bar?
@LeanStrategiesInternationalLLC8 ай бұрын
Great Question! Thank you @andreibrahinets9799. Check out this video for a brief introduction to Vertical (column) progress charts. Please feel free to #share kzbin.info/www/bejne/jWjVhq2HjNtskLM
@dimitriosdaukopulos39419 ай бұрын
Cuss is a bad ass!!!!!
@LeanStrategiesInternationalLLC9 ай бұрын
Thanks for sharing @dimitriosdaukopulos3941. Cus was certainly one bad dude and so was Ali. Both legends.