Your IP: 35.175.236.44

This site is mostly for my learning purposes

I program in javascript and google apps script mostly. If you have a question ask it on stackoverflow.com. I volunteer there. I don't do much consulting work any more.


Number of bones in a Tiger:

It has been erroneously reported as 432 but unfortunately that is incorrect. The actual number is much less.

Answer: 234

Multiple Dependent DropDowns

This version utilizes NamedRanges and DataValidations to accomplish multiple dependent dropdowns accross any tab/sheet. The gif below is a simple demonstration of how the script functions although the gif was taken for an earlier version of the code.

A Google Apps Script project.


Hot of the Presses

New dialog for Regex Searches on your Google Spreadsheets

Free Source for Google Sheets Regex Search Dialog

Just a little data for some snippets

COL1COL2COL3COL4COL5COL6COL7COL8COL9COL10COL11COL12COL13COL14COL15
123456789101112131415
2345678910111213141516
34567891011121314151617
456789101112131415161718
5678910111213141516171819
67891011121314151617181920
789101112131415161718192021
8910111213141516171819202122
91011121314151617181920212223
101112131415161718192021222324
111213141516171819202122232425
121314151617181920212223242526
131415161718192021222324252627
141516171819202122232425262728
151617181920212223242526272829
161718192021222324252627282930
171819202122232425262728293031
181920212223242526272829303132
192021222324252627282930313233
202122232425262728293031323334
212223242526272829303132333435
222324252627282930313233343536
232425262728293031323334353637
242526272829303132333435363738
252627282930313233343536373839
262728293031323334353637383940
272829303132333435363738394041
282930313233343536373839404142
293031323334353637383940414243
303132333435363738394041424344
313233343536373839404142434445
323334353637383940414243444546
333435363738394041424344454647
343536373839404142434445464748
353637383940414243444546474849