- Видео 20
- Просмотров 1 530
John Agusta
США
Добавлен 7 авг 2012
Видео
2024 Agustaville daytime
Просмотров 3014 часов назад
Our Christmas Village 2024 daytime version, enjoy!
Google Sheets Lottery Number Generator Using Benford's Law
Просмотров 589Год назад
Lottery Number Generator Using Benford's Law Shared as viewer with anybody with the link, make your own copy to be able to run docs.google.com/spreadsheets/d/1yJTJ_l2o_qY372CSZ1RUzlfN_I2yhokzWuAggD92Na4/edit?usp=drive_link References What Is Benford’s Law and Why Is It Important? builtin.com/data-science/benfords-law en.wikipedia.org/wiki/Benford's_law math.stackexchange.com/questions/217869/be...
DND Calculator
Просмотров 23Год назад
Track your breaks (DND) using Google Sheets DND Calculator docs.google.com/spreadsheets/d/1f3GlQpl55C3ExTrmNQfPlV9mHqqydr3CnEij6DTeWsM/edit?usp=sharing
QueryByName
Просмотров 21Год назад
Use column names in your QUERY() Target Experience Level: Intermediate Topic Level: Intermediate to Advanced Benefits Makes using QUERY() more intuitive If columns change your function will continue to work References www.benlcollins.com/ A free site with plenty of free Google Sheets and app script tips and guides. Sign up and get weekly tips delivered to your inbox. Articles from Ben Collins f...
Google Sheets - Backtesting Stocks
Просмотров 392Год назад
This video introduces the Google sheet I developed to perform backtesting on publicly traded stocks. Find out if you invested $2,200 in AAPL stock when they went public in 1980 what it would be worth today and other stocks as well. Please like and comment. Backtesting Google Sheet docs.google.com/spreadsheets/d/1KYhtUTHpYcmJAr56bZSOU-ZKlj_xWwrIckz6F-8VjIM/edit?usp=sharing Symbols provided by ww...
Google Sheets Denormalize Data to Simulate SQL Joins
Просмотров 75Год назад
This video will show how to simulate the SQL JOIN clause in the Google Sheets QUERY() function using the custom function DENORMALIZE(). I am sharing the completed spreadsheet model so you can make a copy for yourself Please like and comment if you have any questions. Denormalize Google Sheet docs.google.com/spreadsheets/d/1vziuF8gQcsOxTLEtlcU2cgTAYL1eIaaMTAoIrAS7mnE/edit?usp=sharing Normalizing...
Google Sheets - Dynamically Combine Sheets
Просмотров 39Год назад
This tutorial shows a technique to dynamically combine multiple sheets that are contained in the same spreadsheet not using the QUERY() function. I am sharing the completed spreadsheet model so you can make a copy for yourself Please like and comment if you have any questions. Dynamically Combine Sheets Spreadsheet docs.google.com/spreadsheets/d/1xvW2OGhgP4RkCNdwqJO-5OfiuB3PNf3l8eryt0HmL2A/edit...
Introduction to Google Sheets Named Functions
Просмотров 17Год назад
Named Functions let you save and name your own custom formulas, built with regular Sheets functions. One of the main benefits is being able to simplify the usage of complex functions. The Named Functions can be used in other Google Sheet files. Outline and Reference List docs.google.com/document/d/1cqUtmAguK6KHK1KSi14djMGF4GjxA_3Bso57SRRLRR8/edit# Named Function Library Examples docs.google.com...
Agustaville 2022 Nighttime
Просмотров 22 года назад
This is the night time version of te same name day time version.
Our Tribute to our loved cat Hocus
Просмотров 342 года назад
Hocus was a rescue cat as are all of our animals. He was almost 12 years young and we had to say goodbye to him way too early. Hopefully he is with his big brother Buddy, our Golden Retriever who past in 2017, over the rainbow.
The Truth About Social Security
Просмотров 44 года назад
Social Security Which Political Party Drained it Dry
ANIPO Trilogy
Просмотров 64 года назад
This piece was recorded using no electronic instruments, synths or whatever - just one acoustic instrument and an Akai 4 track reel-to-reel. Can you guess the instrument? There are three sections to this piece; Celestrial Ambrosia, Synaptical Discourse, and Ecstatic Exhalation. This was one of the pieces performed at John Agusta's Senior Recital Concordia College, Bronxville, NY, in 1982
Explosions in the Sky - Your Hand in Mine
Просмотров 264 года назад
Piano cover as played with deep emotion by Jax, musician, writer, social worker and an all around compassionate human being.
Our cat Hocus is obsessed with running water
Просмотров 3411 лет назад
Our cat Hocus is obsessed with running water
Anamorph debut performance at The Pour House in Raleigh, NC on 11/24/2013
Просмотров 19311 лет назад
Anamorph debut performance at The Pour House in Raleigh, NC on 11/24/2013
Occasionally I get requests to share the google sheet. The sheet is shared as view only. Please feel free to make a copy using the File menu and you will have your own copy in your drive that you can modify.
Hi its good tool ....just wanted to how can i add Indian stock market symbol in this tool... help will be appriciated
Sure, if you can get the data. I got the symbols for the four exchanges from www.eoddata.com/symbols.aspx (see the disclaimer tab). I am not sure if they have the Indian exchanges. Then add them to the Symbols tab.
Thank you so much for developing this. It has been incredibly useful.
Thanks for taking a moment to comment, I appreciate that. You may also be interested in my video on using names with the QUERY() function. ruclips.net/video/zg_4SEUqvRg/видео.html
If any of you financial experts know why GOOG shows such a low return please comment.
Great info.
Absolutely beautiful!
Thank you so much!