วีดีโอ

How To Change Internet explorer To Microsoft Edge

Hello! I know this video was posted a long time ago but by chance do you still have the excel file available? I tried the link you posted in the comments but it seems to not work. Could you potentially post a new link to the excel file or send it to my email.

This guy saved me hundreds of pounds. You are a genius ❤

Dear Dr Verschuuren. Thank you for such excelent and didactical tutorial. My issues are on a sinus voltage & current measuring series, but with only 20 values per cycle (voltage and current of the same phase), due to an low 1200 Sample/s rate, over a 90s @ 60 Hz measuring window. Now I need to determine an angular phase difference (phi) between a voltage senoid and its current senoid, to calculate [cos phi] of this angular difference (the result makes the power factor, either advanced or delayed). So with only 20 values recorded, a gross error in cos phi will be produced, where an accurate 2nd decimal cipher shall be produced. Given that a whole cycle is 360°, how can I interpolate within the sinus function to get four to ten times more values, in order to have better accuracy on each zero crossing point (voltage and current), to have the said difference (phi)? I guess this is a non-linear, function & amplitude-conditioned interpolation. Thank you in advance S. C. Kirschstein [sc.kirschstein@gmail.com]

Thank you so , so much, very helpful video Ich danke Ihnen

Great explanation of the filter string. Much appreciated.

Now I know how to show positive values on the left and right sides of the stacked bar chart.

Thank you!

Thank you!! I now know how to show positive percentage values on the right and left side of my stacked bar chart.

This did not work for me

thank you for the video!

I never dreamed of this. It takes me by surprise. I feel like you gave me a birthday present. Thank you.

Brilliant, I'm buying the full book!

THANK YOU A ZILLION!!!!!!

Nice explanation No doubt salute sir

The distributional parameters are not preserved. If X and Z are iid Normal (10,2), and Y=rX + SQRT(1-r^2)Z where r is the target correlation, then Y is effectively a weighted average of X and Z, each of which have a mean of 10. But the weights sum to more than 1, so the mean of Y will always be more than 10. For example, suppose that r=1/2. Then SQRT (1-r^2) is the square root of 1/2, which is SQRT(2)/2, which is about 0.707. Then the sum of the "weights" is 0.5+0.707 = 1.207, and Y will "overshoot" by 20.7%, on average. To make this work, all of the Y values would have to be multiplied by 1/(1+SQRT(1-r^2)).

Dr, you should make audiobooks of your work, with you as narrator. Keep up the good work. Cheers.

How do we create date range for crosstab query, using "Between [Forms]![frmQDate]![QDateFrom] And [Forms]![frmQDate]![QDateTo]". This code is not working for crosstab query MS Access engine does recognize it as valid field. Then How do we do that, how do we create date range for crosstab query ?

Thanks, was very helpful video

In the last part of the video, I believe the transpose on the Cholesky decomposition is not needed and would provide you with better results that more closely resemble the original correlation matrix. Can someone please check?

A warning to anyone who stumbles across this like I did: Lookup Fields in tables of your Access Database are evil. First, any query that tries to order the table data by that company name will not work, because the underlying value isn't the name, but instead a CompanyID number. Nor will any queries that use a company name in that field as a criteria. Second, if a filter is applied to the combobox as is created in this form, the persistent filter effect of Access may save that to the underlying query in the table and the next time the form is opened there will be a prompt for the value which cannot be provided, thus creating an error. And finally, any Access database that has Lookup Fields in tables cannot be upsized to, or queried by, any other database management engine without first removing all the lookup fields because no other engines use or understand them. Think very carefully before implementing any solution that uses Lookup Fields in tables in your Access database.

how to identify the actual real life data , why we are using here random number between 0-1 ?

What do the outsider values mean? The ones that landed outside of the confidence intervals?

Hi Dr. wish you well. I already subscribed your channel. Thumbs up for all your valuable tutorials. I have database that I splitted and put it in shared drive. Is there a way to protect the code? thanks a lot

Great video! Trying to figure out how to open an excel file and refresh all data sources and then close it with a script such as this. I'm not a programmer but looking to run this once daily to update this file. What would that script be? Any help would be much appreciated

Amazingly this 8 year old video is still one of the very few resources on TH-cam addressing crosstabs in reports. Thank you for this!

Where I can download or buy for it?

Hello DR. Verschuuren, this week I ordered your book 130 Simulations from Business to Science and Gambling and have a question about Chapter 88, specifically cells B20:E27. Why do some scenarios return zero?

How to make a parameter report where the form is a columnnar having multiple pages.

Very clean explanation, even 8 years later ;)

Hello That's a great tuto. However, it looks like Sunday is still the first day of the week. How to set Monday as the first day of the week ? I tried to set Monday as the first day of the using this line. I am correct ?? dDate = Date - Weekday((Date), vbMonday) + 1

The 🐐

CD isn't AVAILABLE....

Sorry, this item is temporarily out of stock Can't SELL if you don't HAVE

What do I do if the extrapolated value falls off the trendline

Too complicated for me

Fantastic template and excellent presentation Dr. Verschuuren! Is it possible to do the same (And Plot PIs and CIs) in Excel with quadratic, cubic or arbitrary curve-fit? I always have to go to Minitab when I need these estimates. I would like to do this totally in Excel with non-linear dependencies.

thanks for the video.. i learned a lot even if i'm not new to excel

Hey Gerard, very helpful information thank you, I'm guessing by your name & accent you're Dutch. My Dad is from Holland & we have the same name. Lol

What is the difference between confidence interval for the slope and the confidence interval for the mean?

What if I want to populate RaceGroup column when Country Column is typed the country or when imported or appended data. Does this method applies or I have to use Dlookup afterupdate? I have the list of Countries and related Race-Group or Nationality. I could make combo box which we have. But the goal is to avoid clicking to much on combos to select the country. We want to avoid typing. Example when I import or append many rows with patients and countries. So after the importation or appending I want to see the country column and nationality or Race-Group to be populated. When you have too many columns and hundreds of rows you don't want to keep clicking on combo to drop down, etc. It's a lot stress on the hand for unnecessary repetitive tasks.

how to encrypted Combine the alphanumeric?

👍

Thank you sir 🙏

Thank you sir 🙏

You are a God. In university and still using TH-cam tutorials

Even today in 2023 this is one of the best explanations for using VBA to convert dates to a calendar. I've tried using CHATGPT and failed. With this video, I got it to work!!

Dr.Gerard, best of the best, thank you!: th-cam.com/video/_9rfzYTMs1E/w-d-xo.html

How do I add record in the subform with another data?