God bless you,you just helped my soul in an assignment
@pauletteclark89457 күн бұрын
Almost feel defeated. Great work! I am in awe
@fahmiaprilano43248 күн бұрын
Thanks so much.
@Travelbug060611 күн бұрын
So easy to follow!! Thank you!
@prissyboo27312 күн бұрын
I don’t understand anything
@fawazsanniri283013 күн бұрын
This kind of Gantt chart is very useful, what do I need to make some modifications on it to change the duration units in hours , to use it in the weekly production plan , how could this be done ?
@CodewithKython16 күн бұрын
Extremely helpful. Thanks a lot, I will finish the series.
@zeedee429617 күн бұрын
When i enter the overpayment, it just reduces the amount of future payments rather than reducing the term of the loan. What am i doing wrong?
@linkyla774119 күн бұрын
Amazing tutorial ~ now I just need to practice !
@jamiereife558120 күн бұрын
All I can say is wow! Great job. A pleasure to watch.
@Ang_Vieyra20 күн бұрын
Date of this vid is 4yo, this guy definitely has High Level skills to know how to make this Google Sheet so Responsive with no AI help
@dianethompson884120 күн бұрын
QUESTION. Do you change the DATE at the top of the worksheet on a monthly basis?
@vertex4219 күн бұрын
You only need to update the balances (and date) occasionally, when something has changed enough that the spreadsheet is no longer as accurately predicting the future (such as changes in interest rates, addition of a new debt).
@LauraVanHessche-vj7gr20 күн бұрын
When I want to add the bars, the formula give me a error. it adds a plus before the second part of the formula. Any advice ?
@coolbro423021 күн бұрын
Thank u❤
@daveshangar682023 күн бұрын
In the rate column, I take that this is APR divided by 12 since we are paying monthly??
@vertex4219 күн бұрын
Yes, this spreadsheet assumes monthly payments (and divides the APR by 12).
@daveshangar682018 күн бұрын
@@vertex42 Thank you
@sodiksemaulsolahudin624927 күн бұрын
I use this formula for fixing the problem in a process for making workdays as an input but excel doesn't take it as a formula, why its can be happen =AND(task_start<>'';H$5>=$D7;H$5<=$E7)
@mattyfranceschi923727 күн бұрын
Very helpfull, i need 14 rows, how can i add it? thanks
@leeannryder568528 күн бұрын
❤ wow I've been doing things the hard way this is so awesome I'm happy I came across this
@JemmyRizki28 күн бұрын
my progress colour started 2 days before the actual start days.. please help
@jaxustay28 күн бұрын
Anyone in 2024
@QitablanjadotcomАй бұрын
Straight to the point.... just learn it ... or leave it forever ... thank you sir
@jemmysatria5621Ай бұрын
Thank you very much, you helped many of us.
@elp2557Ай бұрын
Converting from boolean to 1's and 0's is where I got stuck. It kept returning FALSE and then 0 after adding 1* no matter what the progress is set to. I've tried other formulas for double negative formulas and I got the same results. I started that section over several times and followed the formula and steps exactly, afaik. Is there another way to set up conditional formatting for showing progress on the bar?
@crystennesseth3797Ай бұрын
Is there a way to exclude a day of the week or holidays from this?
@erika0626Ай бұрын
My question is, as you make payments do you change the balance and so on?
@vertex4219 күн бұрын
You can if you want to (as though starting from scratch each month), but if you are making the normally scheduled payments, you only need to update the balances occasionally when things deviate from the estimated values (like interest rate changes, rounding differences, or small differences in interest calculations).
@user-mj8ry9wc6wАй бұрын
This is awesome! I have a bunch of software already for my company and really didn't want to add on another subscription just for scheduling. This is invaluable and will help me a ton in future projects thank you for posting such a great, comprehensive guide on building it!
@unkownwalker8853Ай бұрын
How about ongoing, I want to make rhem ongoing
@vertex4219 күн бұрын
Set an end-date for 1/1/2300?
@praizeJCАй бұрын
Liked his skills and style to explain more than anything...
@amberjohnson6483Ай бұрын
Did not calculate correctly for me. I wish there was support.
@vertex4219 күн бұрын
Best method for support for this spreadsheet is to email me using the contact email listed on the website.
@raheelzamir2597Ай бұрын
I was just in seeking of how to draw gantt chart but, you have teach alot in this video, thanks
@angelpantojacazares6071Ай бұрын
Thank you so much! It is a great video.
@BreannaAttipoeАй бұрын
I’m here beginning my snowball debt payoff including my house 🏠…thank you for the calculator!!!
@vertex4219 күн бұрын
Good luck in your debt payoff journey!
@lesteradriatico5455Ай бұрын
Do you have a free format?
@ThuyVuongThiNgocАй бұрын
thank you for your wonderful tutorial. Excellent and I really love it!!! Just 1 question: when the duration is plus 0.5, how do you calculate the right end date?
@mwdasja1127Ай бұрын
what a useful. Thanks for the video
@vertex42Ай бұрын
Working on a Part 2 video to address the most common question: how to handle weekends and non-work days
@prophetsamboateng3610Ай бұрын
How do I add a picture to it
@MattArma2 ай бұрын
How to exclude saturday and sunday in the bar? For example, if the duration is 6 then the result is 1 week plus 1 day because it excludes the sat and sun.
@roulaal26172 ай бұрын
Excellent 👌!!! Thanks for sharing 🙏
@tonysong11062 ай бұрын
Instantly subscribed!
@oblj762 ай бұрын
Great work. However I cannot get the formula for progress bar to work. All I get displayed is "0". No "1". Not even changing the numbers in the progress bar does the trick.
@benkimsem12 ай бұрын
hello, I want to give colour type of task, For example , Design = "D" and I want to my code, check it "D" for all dates and bar color is black for all D types. How can I do it ?
@meldoyle14762 ай бұрын
There are not enough categories... I need all the categories from version 1 to be added to version 2. Please give me step by step instructions to "Unhide the hidden rows in the Budget and Report worksheets if you need more categories" I need to add the 50 hidden rows to do so, please help. Thanks
@subhashisdas62322 ай бұрын
how do u adding F4 at 2.00 ?
@tarekmahmud72062 ай бұрын
Your presentation is so good. You have ability to make complex subject easy to audience. Wish you a good health.
@kyse22 ай бұрын
we need an updated video on this because my excel does not look like this 6 year old one and makes it really hard for me to follow it