tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2ca449b2-e13f-42d2-8884-c7901d816d15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-08 09:44:00.040000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.625 | 101.067 | 100.942 | 100.817 | 100.442
4.5 | 100.596 | 100.471 | 100.346 | 99.971 |  | Note: | Refer To Price [NAME]
4.375 | 99.986 | 99.861 | 99.736 | 99.361 |  |  | For all Price Adjs
4.25 | 98.893 | 98.768 | 98.643
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.875 | 101.75 | 101.625 | 101.25
4 | 101.567 | 101.442 | 101.317 | 100.942
3.875 | 101.178 | 101.053 | 100.928 | 100.553
3.75 | 100.645 | 100.52 | 100.395 | 100.02
3.625 | 99.526 | 99.401 | 99.276
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-22 09:44:00.040000
30 DAY | 2011-07-07 09:44:00.040000
45 DAY | 2011-07-22 09:44:00.040000
60 DAY | 2011-08-06 09:44:00.040000
90 DAY | 2011-09-05 09:44:00.040000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 887837d1738168096-generating-list-of-people-in-groups-sixes
Sheet: Brownie - HS

Name: |  |  |  |  | Birthday: |  |  | [NAME] | Silver | Gold |  | Promise Date: |  |  |  |  | Anniversary Badges | 1YR | 2YR | 3YR |  | 4YR | 5YR
Membership Number: |  |  |  |  | Six: |  |  |  |  |  |  | Guiding Start Date:
Be Well |  |  |  |  |  |  |  |  |  |  |  | Know Myself
Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities |  |  |  |  |  |  | Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities
Skills Builder (Stage 3) |  |  |  |  |  |  |  |  |  |  |  | Skills Builder (Stage 3)
 |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed |  |  |  |  |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed
 |  |  |  |  |  |  |  |  | Interest Badge |  |  |  |  |  |  |  |  |  |  |  |  | Interest Badge
 |  |  |  |  |  |  |  |  | Skills Builder |  |  |  |  |  |  |  |  |  |  |  |  | Skills Builder
 |  |  |  |  |  |  |  |  | UMA hours |  |  |  |  |  |  |  |  |  |  |  |  | UMA hours
Express Myself |  |  |  |  |  |  |  |  |  |  |  | Skills for my Future
Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities |  |  |  |  |  |  | Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities
Skills Builder (Stage 3) |  |  |  |  |  |  |  |  |  |  |  | Skills Builder (Stage 3)
 |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed |  |  |  |  |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed
 |  |  |  |  |  |  |  |  | Interest Badge |  |  |  |  |  |  |  |  |  |  |  |  | Interest Badge
 |  |  |  |  |  |  |  |  | Skills Builder |  |  |  |  |  |  |  |  |  |  |  |  | Skills Builder
 |  |  |  |  |  |  |  |  | UMA hours |  |  |  |  |  |  |  |  |  |  |  |  | UMA hours
Have Adventures |  |  |  |  |  |  |  |  |  |  |  | Take Action
Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities |  |  |  |  |  |  | Skills Builder (Stage 2) |  |  |  |  | Unit Meeting Activities
Skills Builder (Stage 3) |  |  |  |  |  |  |  |  |  |  |  | Skills Builder (Stage 3)
 |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed |  |  |  |  |  |  |  |  | Interest Badge (1 req'd) |  |  |  | Theme Completed
 |  |  |  |  |  |  |  |  | Interest Badge |  |  |  |  |  |  |  |  |  |  |  |  | Interest Badge
 |  |  |  |  |  |  |  |  | Skills Builder |  |  |  |  |  |  |  |  |  |  |  |  | Skills Builder
 |  |  |  |  |  |  |  |  | UMA hours |  |  |  |  |  |  |  |  |  |  |  |  | UMA hours
Spreadsheet: 64456d1265301966-ignoring-blank-cell-w-conditional-formatting-format-sample
Sheet: Sheet1

Agency | Active Devices |  |  |  |  |  | Agency | Active
5 |  |  |  |  |  |  | 1 | 5
10 |  |  |  |  |  |  | 2 | 10
3 |  |  |  |  |  |  | 3 | 15
4 |  |  |  |  |  |  | 4 | 9
6 |  |  |  |  |  |  | 5 | 8
1 |  |  |  |  |  |  | 7 | 1
7 |  |  |  |  |  |  | 9 | 13
2 |  |  |  |  |  |  | 10 | 15
8
9
Spreadsheet: 694665d1599739571-matching-1-column-to-another-column-exactly-book1
Sheet: Sheet1

Material | Component
50000500001 | 201250
50000500001 | 201251
50000500001 | 201252
50000500001 | 201253
50000500002 | 201350
50000500002 | 201251
50000500002 | 201252
50000500003 | 201250
50000500003 | 201251
50000500003 | 201252
50000500003 | 201566
50000500003 | 201567
50000500004 | 201250
50000500004 | 201251
50000500004 | 201252
50000500004 | 201253
50000500005 | 201250
50000500005 | 201251
50000500005 | 201252
50000500005 | 201566
Spreadsheet: 206499d1358202336-dropdown-list-containing-dd-mm-yyyy-nova-planilha-rh_1-new
Sheet: Horas de Sobre Aviso (Standby)

Mês/Ano (das [NAME]): |  | 2013-01-01 00:00:00 |  | * Favor preencher estas informações na planilha de Horas Extras ao lado
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] preencher todos os campos necessários, salve este arquivo usando seu nome (Save As…) e envie [NAME]) supervisor(a).
Funcionário:
ATTUID:
Cargo:
Horário de Trabalho:
Supervisor:
Localidade:
 |  | Sobre Aviso |  |  |  |  |  |  |  |  |  | Para ser preenchido por RH
 |  | Início | [NAME] | Início | [NAME] | Motivo | Cliente | Servi�o | [NAME]o | Motivo: | Total de Horas | Total de Horas/ 50% | Total de Horas/ 100% | Total de Horas/ Adicional Noturno
[NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Total de Horas: | Total de Horas:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: | OT Codes: | Services: | Region:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCALIDADE | Holiday | AVPN | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americana - SP | Intrusive LMAC | CS | CALA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LAN Migration | EVPN | EMEA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | GMIS | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Curitiba - SC | Other - Customer | MLAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] – SP | Other - Internal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guarulhos – SP | PMACD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hortol�ndia - SP | Rack & Stack
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Joinville - SC | T&T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Time Zone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio de Janeiro - RJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S�o Paulo - SP
Spreadsheet: 1dd7acb4-4674-4363-9fc6-164d528bbd92
Sheet: Sheet1

BUDGET ADJUSTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Reestimating of Stormwater Loan |  |  |  |  | Reestimating appropriation of funds
funds for use in FY09
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | [NAME], Acting Director of Water Services
Reestimating the appropriation of $254,361.62 in
funds to the appropriate account; and re-designating
the Director of Water Services as requisitioning |  |  |  |  | From/Transferor(s) or Fund Title(s)
authority.
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | $254,361.62 to 09-8200-807771-B
 |  |  |  |  | 2007 Stormwater Loan
Discussion
The City Council passed Ordinance No. 070931 on |  |  |  |  | Policy / Program Impact
September 13, 2007 approving the receipt of a
$517,300.00 loan from the Missouri Department of |  |  |  |  | Policy or Program | X    No | Yes
Natural Resources to finance a portion of the costs |  |  |  |  | Emphasis Change
of stormwater projects of the City of Kansas City,
Missouri, and authorizing certain other actions related
thereto.
This ordinance is needed to appropriate a portion of
those funds in order to use them in Fiscal Year 2009. |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
This ordinance affects projects associated in all 6 |  |  |  |  | Do Pass |  | Hold
City Council Districts. |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
Is it good for the children?  Yes.
How will this contribute to a sustainable |  |  |  |  | Fact Sheet prepared by: |  | Date
Kansas City?  N/A to this ordinance. |  |  |  |  | [NAME] |  | 2008-08-27 00:00:00
 |  |  |  |  | Contract Administration Section
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | [NAME] |  | 2008-08-27 00:00:00
 |  |  |  |  | Asst. Director of Engineering
 |  |  |  |  | Reference Numbers
Spreadsheet: 105660d1302956503-button-that-insert-new-cells-in-new-sheet-book1
Sheet: Sheet1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | [NAME] |  | xcv | xg | sfg | grthr | df | ty |  | h
2 |  | [NAME] | xcv |  |  | df | ty | u | r | dsf
3 |  | xcv | xcv | xcvx |  | s | g | n | s | fs
4 |  | ad | wer |  | r | h | s | fsd | sf | s
5 |  | xvxc | ads | f | e | s | fsd | fsd |  | fs
6 |  | abc | hg |  |  |  | fsd | s | f
7 |  | n |  | xpto |  | ze | z | fsd | f | sd
8 |  | tg | i |  | ai |  |  | 2 | f | s
9 |  |  | i | uy | u |  |  |  |  | f
10 |  |  | u | g
11 |  |  | fy | n
12
13
14
15
16
17
18
19
20
21
22
23
24
When i click i want to write here a new line with all my selected cells above (example the yellow ones) with some information: Cell, collum , the cell.
 | example to the yellow ones
 | [NAME] | 2 | 2
 | sfg | 5 | 1
 | grthr | 6 | 1
Spreadsheet: ce8f1d0b-7916-4cb5-8ee3-ee405e406472
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
39356193 | 2014-01-05 22:30:39 | ALLIES | 0 | 4 | 6 | 1351059 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
39356572 | 2014-01-05 22:44:09 | AXIS | 1 | 6 | 5 | 1351059 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
39356892 | 2014-01-05 22:58:57 | AXIS | 1 | 7 | 4 | 1451547 | Gruumshie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40833583 | 2014-04-04 07:06:09 | ALLIES | 1 | 5 | 2 | 508770 | StriderII | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40833782 | 2014-04-04 07:33:47 | AXIS | 0 | 3 | 5 | 508770 | StriderII | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40834048 | 2014-04-04 08:07:36 | AXIS | 0 | 5 | 6 | 508770 | StriderII | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40834262 | 2014-04-04 08:30:12 | ALLIES | 1 | 6 | 1 | 508770 | StriderII | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 |  |  | -218
2 |  |  | -105
3 |  |  | -155
4 |  |  | -323
5 |  |  | -385
6 |  |  | -239
7 |  |  | -142
8 |  |  | -161
9 |  |  | -402
10 |  |  | -1692
11 |  |  | -1051
12 |  |  | -241
13 |  |  | -348
14 |  |  | -240
15 |  |  | -441
16 |  |  | -421
17 |  |  | -363
18 |  |  | -462
19 |  |  | -357
20 |  |  | -310
21 |  |  | -2008
22 |  |  | -151
23 |  |  | -44
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 152234.63
2002-02-23 00:00:00
CBS Volume
 |  |  | -368359
Spreadsheet: lisa_gang__22396__Hanson Scheduling Model_4_18
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-04-18 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 29.196 | 29.136 | 28.932 | 28.932 | 26.628 | 25.788 | 23.436 | 23.964 | 26.304 | 29.424 | 29.448 | 29.16 | 26.316 | 28.5 | 29.892 | 30.12 | 31.224 | 31.008 | 31.068 | 31.416 | 31.416 | 31.164 | 31.02 | 30.696 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 32.36023590669259 | 32.36023590669259 | 32.56023590669258 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 30.61523590669259 | 30.61523590669259 | 31.36523590669259 | 30.48523590669259 | 30.90523590669259 | 30.90523590669259 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 466380d1466162870-search-for-multiple-words-or-values-simultaneously-sample-sheet-emails_v2
Sheet: Sheet2

Possible Emails |  | Names | Emails
gmail |  | Shelia [NAME] | Shelia Sylvestre@yahoo
hotmail |  | Curtis Barreto | Curtis Barreto@hotmail
aol |  | Danae Cagney | [NAME] Cagney@bing
yahoo |  | Karon [NAME] | Karon Hansel@yahoo
bing |  | [NAME] Mize | [NAME] Mize@aol
 |  | [NAME] Arceneaux | Kasie Arceneaux@yahoo
Blacklist |  | [NAME] Winchenbach | [NAME] Winchenbach@gmail
yahoo |  | [NAME] Browne | [NAME] Browne@gmail
hotmail |  | Bessie Moeckel | [NAME]
aol |  | [NAME] Caplan | [NAME] Caplan@hotmail
 |  | [NAME] | [NAME] Gagliardo@gmail
 |  | Zenaida Rosse | Zenaida Rosse@gmail
 |  | [NAME] | [NAME]
 |  | Mitzi Lehman | Mitzi Lehman@hotmail
 |  | Keli Petti | Keli Petti@gmail
 |  | Soo Easterly | Soo Easterly@bing
 |  | Deloras [NAME] | [NAME] Rodger@yahoo
 |  | [NAME] Ramirez | [NAME] Ramirez@aol
 |  | Aura Sterrett | Aura Sterrett@gmail
 |  | [NAME] Yoder | [NAME] Yoder@yahoo
 |  | [NAME] [NAME] | [NAME] Eicher@bing
 |  | Tana Garfinkel | Tana Garfinkel@yahoo
 |  | Charmain Biggers | Charmain Biggers@gmail
 |  | Todd Starks | Todd Starks@yahoo
 |  | Sharolyn Winfield | Sharolyn Winfield@gmail
 |  | Orlando Ontiveros | Orlando Ontiveros@yahoo
 |  | Savannah Pearsall | Savannah Pearsall@gmail
 |  | Maurine [NAME] | Maurine Axford@bing
 |  | [NAME] Baum | [NAME] Baum@bing
 |  | Lauryn Cusumano | [NAME]
 |  | Roseanna Rollins | Roseanna Rollins@gmail
 |  | Theresa Lauer | Theresa Lauer@aol
 |  | Catina Lake | Catina Lake@gmail
 |  | [NAME] Roby | [NAME] Roby@hotmail
 |  | Deann Barcenas | Deann Barcenas@hotmail
 |  | [NAME] | Sharri Suzuki@gmail
 |  | Rogelio [NAME] | Rogelio Cheatham@aol
 |  | Emilee [NAME] | Emilee Jacko@bing
 |  | [NAME] Kadlec | Giovanna Kadlec@aol
 |  | Ione Alley | Ione Alley@bing
 |  | Anitra Riva | Anitra Riva@aol
 |  | [NAME] [NAME] | [NAME] Zehnder@gmail
 |  | [NAME] Iles | [NAME] Iles@bing
 |  | [NAME] | [NAME] Leonard@hotmail
 |  | Salvador Costin | Salvador Costin@yahoo
 |  | [NAME] Mccrimmon | [NAME] Mccrimmon@yahoo
 |  | [NAME] | [NAME]
 |  | [NAME] [NAME] | [NAME] Matsunaga@hotmail
 |  | Lonnie Domina | Lonnie Domina@yahoo
 |  | Era Sherrell | Era Sherrell@yahoo
Spreadsheet: 887661d1737961336-insert-date-time-cell-was-updated-collection
Sheet: Sheet1

TitleName | ReleaseDate | CD/Vinyl | Cost | Publisher | Value | [NAME] | Last Update
The Carpenters | 1967-09-01 00:00:00 | CD | 2 | EMI | 50
The Ramones | 1973-06-01 00:00:00 | V | 5 | Vertigo | 55
The [NAME] | 1965-12-01 00:00:00 | CD | 6 | CBS | 66
The Knack | 1993-01-01 00:00:00 | V | 7 | Casablanca | 27
The The | 1993-02-01 00:00:00 | V | 8 | Atlantic | 33
The Travelling Hillbillies | 1993-06-01 00:00:00 | V | 9 | Atlantic | 46 | Not who you think!
Spreadsheet: 94318d1294164888-highlight-and-count-tasks-past-due-date-example
Sheet: Tasks

 |  |  |  |  |  |  | Today's date | 2011-01-04 00:00:00
 |  | This is a boiled down version of what I have at the moment |  |  |  |  | This what I want to achive
 |  | Task | Target Date | Status |  |  | Task | Target Date | Status
 |  | A | 2011-02-01 00:00:00 | In Progress |  |  | A | 2011-02-01 00:00:00 | In Progress
 |  | B | 2011-01-20 00:00:00 | Completed |  |  | B | 2011-01-20 00:00:00 | Completed
 |  | C | 2011-01-02 00:00:00 | Not Started |  |  | C | 2011-01-02 00:00:00 | Not Started
 |  | D | 2011-01-03 00:00:00 | In Progress |  |  | D | 2011-01-03 00:00:00 | In Progress
 |  | E | 2011-02-15 00:00:00 | Not Started |  |  | E | 2011-02-15 00:00:00 | Not Started
 |  | I know that I can add a cell somewhere on the sheet to insert today's date. Then do a conditional format to look for any dates that are less than today's date.  However, this sheet will be used by people with limited computer skills so I am trying to get to a point that by opening the sheet it should update with todays date.  Finally I cannot seem to figure out how to get the metrics sheet to be able to count how many of the cells are passed the target date. Importantly I would like it to be able to discount any tasks that are completed.
Spreadsheet: 818824d1677070615-a-sum-product-with-multiple-criteria-urgent-problem-test-34-
Sheet: Exercise 3

COST |  |  | Currency |  |  | Exchange |  |  |  | TOTAL COST
Part | Cost |  | Part | Currency |  | From | To | Rate |  | Part | Description | Volume | Total Cost USD
0102025 | 1.07 |  | 0121022 | EUR |  | EUR | EUR | 1 |  | 48274 | S4080 11-13MM 7/16-1/2" | 23
0103541 | 32.54 |  | 0168972 | EUR |  | EUR | GBP | 0.84 |  | 0102016 | 404 3"BB 5/16-3/8" 2T | 335
0108038 | 49.24 |  | 0169374 | EUR |  | EUR | USD | 1.16 |  | 0102025 | 404 4-1/2"BB 3/8-1/2" 4T | 670
0108065 | 352.47 |  | 0120096 | EUR |  | GBP | EUR | 1.19 |  | 0103541 | 407 8"RB 1-1-1/8" 20T | 285
0108127 | 99.63 |  | 0109643 | EUR |  | GBP | GBP | 1 |  | 0108038 | 418   3"BB SBL 5/16-3/8" | 285
0108225 | 125.05 |  | 0109064 | EUR |  | GBP | USD | 1.38 |  | 0108065 | 418 4-1/2"BB  3/8-1/2 4T | 35
0108308 | 177.16 |  | 0121095 | EUR |  | USD | EUR | 0.86 |  | 0108127 | 418   6"BB SN BL 5/8-3/4" | 168
0108371 | 207.11 |  | 0121255 | EUR |  | USD | GBP | 0.73 |  | 0108225 | 418   8"BB SN BL 5/8-3/4" | 11
0108390 | 394.99 |  | 0108390 | EUR |  | USD | USD | 1 |  | 0108308 | 421 8"BB 3/4-7/8" 15T | 47
0109037 | 334.33 |  | 0130655 | EUR |  |  |  |  |  | 0108371 | 420   10"BB SN BL 3/4-7/8 | 23
0109064 | 436.81 |  | 0109607 | EUR |  |  |  |  |  | 0108390 | 421 10"BB 3/4-7/8" 15T | 23
0109091 | 59.19 |  | 0108065 | GBP |  |  |  |  |  | 0109037 | 419 3"BB 5/16-3/8" 2T | 35
0109126 | 108.5 |  | 0109420 | GBP |  |  |  |  |  | 0109064 | 419 4-1/2"BB 3/8-1/2" 4T | 11
0109153 | 69.14 |  | 0297020 | GBP |  |  |  |  |  | 0109091 | 419 3"BB 5/16-3/8" 2T | 11
0109224 | 271.83 |  | 0109037 | GBP |  |  |  |  |  | 0109126 | 419 6"BB 5/8-3/4" 8T | 47
0109251 | 285.53 |  | 0109322 | GBP |  |  |  |  |  | 0109153 | 419 6"RB 5/8-3/4" 8T | 35
0109322 | 318.88 |  | 0109527 | GBP |  |  |  |  |  | 0109224 | 419 8"BB 5/8-3/4" 8T | 11
0109420 | 349.49 |  | 0297011 | GBP |  |  |  |  |  | 0109251 | 419 8"RB 5/8-3/4" 8T | 0
0109527 | 293.36 |  | 0109251 | GBP |  |  |  |  |  | 0109322 | 419 10"BB 5/8-3/4" 8T | 70
0109607 | 373.93 |  | 0109224 | GBP |  |  |  |  |  | 0109420 | 419 12"BB 3/4" 8T | 0
0109643 | 613.08 |  | 0108371 | GBP |  |  |  |  |  | 0109527 | 419 14"BB 5/8-3/4" 8T | 11
0120096 | 758.56 |  | 0108308 | GBP |  |  |  |  |  | 0109607 | 419 16"BB 3/4-7/8" 15T | 23
0121022 | 979.72 |  | 0108225 | GBP |  |  |  |  |  | 0109643 | 419 18"BB 1" 15T | 0
0121095 | 397.58 |  | 0109126 | USD |  |  |  |  |  | 0120096 | 430   10"BB SN BL 1-1.1/8 | 0
0121255 | 397.24 |  | 0108127 | USD |  |  |  |  |  | 0121022 | 431 8"BB 1-1-1/8" 20T | 35
0130655 | 391.68 |  | 0109153 | USD |  |  |  |  |  | 0121095 | 431 10"BB 1-1-1/8" 20T | 23
0168972 | 863.06 |  | 0109091 | USD |  |  |  |  |  | 0121255 | 431 14"BB 1-1/8" 20T | 59
0169374 | 833.95 |  | 0108038 | USD |  |  |  |  |  | 0130655 | [NAME]" 9T | 47
0297011 | 289.76 |  | 0103541 | USD |  |  |  |  |  | 0168972 | 417 6"BB 3/4-7/8" 12T | 35
0297020 | 342.71 |  | 0102025 | USD |  |  |  |  |  | 0169374 | 420   6" BB SN BL 3/4-7/8 | 298
Spreadsheet: 76418d1276920707-transpose-and-indent-transpose
Sheet: Sheet3

 |  |  | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Up to 20 Items
 | Table 1 | Fridge 1 | Floor | walls | door
 |  | Fridge 2 | walls | door | ceiling | windows | door jamb
 |  | Corridor 1 | Floor | windows
 |  | Test Kitchen | ceiling | floor
 |  | Fridge 1
 | Table 2 |  | floor
 |  |  | walls
 |  |  | door
 |  | Fridge 2
 |  |  | walls
 |  |  | door
 |  |  | ceiling
 |  |  | windows
 |  |  | door jamb
 |  | Corridor 1
 |  |  | floor
 |  |  | windows
 |  | Test Kitchen
 |  |  | ceiling
 |  |  | floor