Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Tuesday, July 23, 2024

yogi_Calendar For Specified School Year Starting With Specified Month And Specified Day Of Week

 Oh Yes ... with the new school year coming up, there will be need to create and print a a calendar starting with a specified month and specified day of week

In the following I present a calendar that has been created with formulas and the calendar with automatically update as 

You input the Year, Starting Month, and Starting Day Of Week 

So 

you can create the calendar for yourself my making a copy of the spreadsheet for yourself 

Or

If there is interest, I can set up a Google Form for you to specify the Year, Starting Month and Starting Day of week and the calendar will update itself to suit your need


Friday, October 21, 2011

yogi_Search For An Item In A Column And Return Information From Specified Fields

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Tret said:
Name search that returns that rows information.
A Couple things:
I am trying to figure out how to add a search function to my spreadsheet. I want to be able to type someones name into a search box and have it return all the information on that person. For example I have hundreds of names in Column B, I want to search for a name and have it show not only the name from column B but the rest of the information about them from columns C,D,E, etc. Here is a sample spreadsheet of what the information looks like.
https://docs.google.com/spreadsheet/ccc?key=0Ao3KZ5KFVC26dHpxSkhhU2R3V2lydGNhX284WFdWZFE&hl=en_US
Also, is there any way to use the spreadsheet like a database and have a gadget populate the information searched. Similar to the Form that you can input information to but display it like a table. For example I search for someones name on the gadget and it references the spreadsheets information and then populates just that users results on the gadget/form. It would be really nice if this part was able to be published to a website like the input form can be.
Sorry if these questions were answered before, I tried searching for this but had no luck.
Update:
edit: I have tried the filter option, it kinda works. I get this error below when I try to filter an entire column. With my spreadsheet the amount of information is constantly growing and information grows past the filter and is then unsearchable. Also, that searching isn't what I'm looking for having to check and uncheck to see information is annoying.
Trying to apply filter to a region that conflicts with one or more tables. Please select a table or select a region that doesn't overlap any tables.
-----------------------------
In the following I am going to deal with Google spreadsheet solution:

Tuesday, September 27, 2011

Look Ma ... There Are No Columns In The Basement!

for viewing pleasure of my Cloud Computing -- Google Docs Way readers I present here a short video clip that I accidentally took when I was at the energy efficient healthy house we are building in southeastern Michigan. By the way I use primarily spreadsheet for design, documentation, reports, and  invoicing work for all of my projects

construction noise ... so please turn down the speaker volume

for more details on this energy efficient building project click on the following link:
http://energyefficientbuild.blogspot.com/2011/09/look-ma-there-are-no-columns-in.html

Enjoy!
Yogi