tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780716d1652712027-index-with-nested-year-function-not-working-sample-workbook-4-aligw
Sheet: Sheet1

Date | Year | Value | MatchYear | MatchDates |  | index(year(a2:a25),,) |  | sum(index(year(a2:a25),,) |  | SUMIF(E2#,C2,B2:[NAME]) |  | SUMIF(A2:A25,D2:D4,B2:B25) |  | SUMIF(INDEX(YEAR(A2:A25),,),C2:C4,B2:B25) |  |  | Sum of Value
1900-01-01 00:00:00 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1900
1900-01-01 00:00:00 |  | 1 | 1901 | 2 |  | 1900 |  |  |  |  |  | 0 |  | 10 |  | 1901 | 10
1900-01-03 00:00:00 |  | 1 | 1913 | 3 |  | 1900 |  |  |  |  |  | 1 |  | 10 |  | 1913 | 10
1900-01-04 00:00:00 |  | 1 |  |  |  | 1900
1901-02-03 00:00:00 |  | 1 |  |  |  | 1901
1901-02-04 00:00:00 |  | 1 |  |  |  | 1901
1901-02-05 00:00:00 |  | 1 |  |  |  | 1901
1901-02-06 00:00:00 |  | 1 |  |  |  | 1901
1901-02-07 00:00:00 |  | 1 |  |  |  | 1901
1901-02-08 00:00:00 |  | 1 |  |  |  | 1901
1901-02-09 00:00:00 |  | 1 |  |  |  | 1901
1901-02-10 00:00:00 |  | 1 |  |  |  | 1901
1901-02-11 00:00:00 |  | 1 |  |  |  | 1901
1901-02-12 00:00:00 |  | 1 |  |  |  | 1901
1913-09-08 00:00:00 |  | 1 |  |  |  | 1913
1913-09-09 00:00:00 |  | 1 |  |  |  | 1913
1913-09-10 00:00:00 |  | 1 |  |  |  | 1913
1913-09-11 00:00:00 |  | 1 |  |  |  | 1913
1913-09-12 00:00:00 |  | 1 |  |  |  | 1913
1913-09-13 00:00:00 |  | 1 |  |  |  | 1913
1913-09-14 00:00:00 |  | 1 |  |  |  | 1913
1913-09-15 00:00:00 |  | 1 |  |  |  | 1913
1913-09-16 00:00:00 |  | 1 |  |  |  | 1913
1913-09-17 00:00:00 |  | 1 |  |  |  | 1913
Spreadsheet: 866570d1713479853-do-not-know-how-to-perform-this-task-or-amento
Sheet: Check List

Instalação de Unidade de Produção de Auto Consumo (UPAC)
Nome Cliente
Contactos Cliente |  |  | [NAME] |  |  | email
[NAME]
[NAME]
[NAME] até a obra
[NAME]
[NAME] |  |  |  |  |  | Tipo UPAC
Instalação PV |  |  |  |  |  | 1º Local Instalação PV |  |  |  | [NAME] Util |  | m²
 |  |  |  |  |  | 2º Local Instalação PV |  |  |  | [NAME] Util |  | m²
 |  |  |  |  |  | 3º Local Instalação PV |  |  |  | [NAME] Util |  | m²
Instalação Eléctrica
CPE |  |  |  | NIP |  |  |  |  | Ramal nº
Entrada |  |  |  |  |  | Rede Distribuição
[NAME] |  |  |  |  |  |  | [NAME] |  | Não
[NAME]
Contactor no Muro |  |  |  | [NAME] |  | Não
Portinhola no Muro |  |  |  | [NAME] |  | Não
Colocação do Inversor |  |  |  | S/Constragimentos |  |  | C/Constragimentos
[NAME]
[NAME]
Tipo de Fornecimento da Rede |  |  |  |  |  | Rural | [NAME]
[NAME] |  |  |  |  |  | Isolada | Isolada
 |  |  |  |  |  | Bidireccional | Bidireccional
 |  |  |  |  |  | C/Baterias | C/Baterias
 |  |  |  |  |  | S/Baterias | S/Baterias
Baterias no [NAME] |  |  |  |  |  | [NAME] | Não
Upgrade de Potência no Futuro |  |  |  |  |  | [NAME] | Não
Tipologia do Telhado |  |  |  |  |  | Plano | Inclinado |  | [NAME] |  | Águas | No Solo
Existe Desenho/Foto Telhado |  |  |  |  |  | [NAME] | Não
Area Util do Telhado para Paineis
Necesidades Potência Actuais
Necessidade de Potência Futura |  |  |  |  |  | [NAME] | Não
Aparelhos de Aquecimento Existentes |  |  |  |  |  | Bomba Calor | Termo acumulador |  |  | Esquentador |  | [NAME] | [NAME]
 |  |  |  |  |  | C/Acumulador |  |  |  | Gás |  | Gás
 |  |  |  |  |  | S/Acumulador |  |  |  | Electrico |  | Electrico
 |  |  |  |  |  |  |  |  |  |  |  | C/Acumulador
 |  |  |  |  |  |  |  |  |  |  |  | S/Acumulador
Aparelhos de Climatização existentes |  |  |  |  |  | [NAME] | Condutas |  | Termoventilador |  | [NAME] |  | [NAME]
Aparelhos de Aquecimento a Instalar no Futuro |  |  |  |  |  |  | [NAME] |  | Não
Aparelhos de Climatização a Instalar no Futuro |  |  |  |  |  |  | [NAME] |  | Não
Carregamento Carros Electricos |  |  |  |  |  |  | [NAME] |  | Não
Spreadsheet: 683479d1592755786-count-and-lookup-help-for-a-leaderboard-scrabble-data
Sheet: Leaderboard

Name | Played | Points
[NAME] |  |  | Played Week 1 and scored 3
[NAME]
Bec
Cara
[NAME]
[NAME]
Debbie
Gemma P
Gemma S
G
Georgina
Heather
[NAME]
[NAME]
[NAME]
Jon
[NAME] |  |  | Didn’t play week 1 but has in week 2
[NAME]
Julie B & Louise |  |  | Didn’t play week 1 so should be zero, will play in week 2
[NAME]
[NAME]
L & D |  |  | Scored 2 in week 1
[NAME]
[NAME]
Mandi
Mandy
[NAME]
[NAME]
Nicki
[NAME]
Roberta
Sandra
Stephen |  |  | How do I add his points for week 2
Sue
[NAME]
[NAME]
Spreadsheet: 841115d1693361841-need-to-populate-a-cell-based-on-the-contents-of-a-dropdown-cell-excel-question-sample-1-
Sheet: DAR

Status | DAR Number | Submitter | Date | USER 1 | USER 2 | Department | Fund | Source Code | Function | Purpose | Project | Activity | Vendor | Amount | Form Type | PS ID | Description | Supporting Docs | Supporting Docs2 | Reconciliation Comments
 |  |  |  |  | ADOSP
 |  |  |  |  | DSPRO
 |  |  |  |  | AGSPE
 |  |  |  |  | PRS&S
 |  |  |  |  | AGML2
 |  |  |  |  | GES&S
 |  |  |  |  | DPIRS
 |  |  |  |  | XRPRO
 |  |  |  |  | AGDNR
Spreadsheet: 40560d1238916866-trying-to-retrieve-a-cell-from-table-in-sheet-2-to-sheet-1-management-and-billing
Sheet: rates

 | Rates
 |  | TOTAL PRICE
 | Num Hours | A - Body Massage |  | B - Foot Massage |  | C- Herbs Massage
 |  | A | A1 | B | B1 | C | C1
 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
 | 01:00:00 | 150 | 80 | 150 | 80 | 150 | 80
 | 02:00:00 | 240 | 160 | 240 | 160 | 240 | 160
 | 03:00:00 | 360 | 240 | 360 | 240 | 360 | 240
 | 04:00:00 | 480 | 320 | 480 | 320 | 480 | 320
 |  |  | TOTAL EMPLOYEE |  | TOTAL EMPLOYEE |  | TOTAL EMPLOYEE
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: sb Houston

TIME BUCKET/KEY: |  | REPORT REGION | RISK TYPE | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2005-02-01 00:00:00 |  | 2006-02-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2016-02-01 00:00:00 |  | 2016-02-01 00:00:00 |  | 2016-02-01 00:00:00 |  |  |  |  |  | Total ECT |  | Prior Day
To: |  |  |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2006-01-01 00:00:00 |  | 2011-01-01 00:00:00 |  | 2016-01-01 00:00:00 |  | 2016-01-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | Change
CANADA (INTRAMONTH)
Physical |  | IMCANADA | PHY |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Gas Daily |  | IMCANADA | G |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Notional |  | IMCANADA | D |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Equivalent |  | IMCANADA | D |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Price |  | IMCANADA | P |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
Spreadsheet: 833837d1687273575-calculator-with-inputs-and-outputs-in-same-cells-fermentation-salt-calculator
Sheet: Sheet3

Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 10 | <<my new input
MSG | 0.123 | -- | 10 | <<my new input
Soy sauce |  | 0.23 | # | <<newly calculated number
Fish sauce | 0.11 |  | # | <<newly calculated number
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Spreadsheet: 696153d1600675278-quick-help-required-with-an-avergae-if-fuction-tally-23
Sheet: sheet1

Vessel : |  |  | KEILA K121 |  |  |  | Total
Date: |  |  | 2020-09-11 00:00:00 |  | Boxes |  | [NAME]
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
 | HAD | GH | 3 | 6.75 | 40 | 122
 | HAD | GH | 4 | 3 | 40 | 122
 | HAD | GH | 5 | 3.75 | 40 | 66
 | HAD | GH | 6 | 5.25 | 40 | 24
 | WHG | WF | 4 | 5 | 40 | 25
 | LEZ | GH | 2 | 10.25 | 35 | 198
 | LEZ | GH | 3 | 8.5 | 35 | 106
 | LEZ | GH | 4 | 5 | 35 | 90
 | LEZ | GH | U | 1.25 | 35 | 35
 | LEM | GH | 1 | 1 | 40 | 275
 | LEM | GH | 1 | 4 | 40 | 250
 | LEM | GH | 2 | 1 | 40 | 105
 | LEM | GH | 2 | 1 | 10 | 26.25
 | LEM | GH | 2 | 2 | 40 | 105
 | LEM | GH | 3 | 2 | 40 | 72
 | LEM | GH | 3 | 2.25 | 40 | 60
 | PLE | GH | 3 | 1 | 40 | 72
 | PLE | GH | 4 | 2 | 40 | 30
 | ANF | GH | 1 | 1 | 40 | 162
 | ANF | GH | 2 | 2 | 45 | 200
 | ANF | GH | 2 | 1 | 45 | 200
 | ANF | GH | 3 | 2 | 45 | 176
 | ANF | GH | 3 | 16.75 | 45 | 171
 | ANF | GH | 4 | 10 | 45 | 158
 | ANF | GH | 5 | 5.5 | 45 | 153
 | ANF | GH | 6 | 2 | 45 | 134
 | ANF | GH | 6 | 1 | 22.5 | 67
 | HKE | GH | 5 | 1 | 14 | 20
 | LIN | GH | 2 | 1 | 17 | 30
 | POL | GH | 2 | 1 | 11 | 26
 | TBT | GH | U | 1 | 21 | 335
 | RJC | GH | 4 | 1 | 15 | 10
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
Merchant |  |  |  |  |  |  | Total (£) | [NAME] | Total (Kg)
Spreadsheet: a3c70c0e-5542-403d-81f1-46d4a8d8a2f8
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: |  |  | 2014-03-20 09:22:26.920000
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.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.496 | 102.371 | 102.246 | 101.871
4.625 | 101.736 | 101.611 | 101.486 | 101.111 |  | Note: | Refer To Price [NAME]
4.5 | 100.797 | 100.672 | 100.547 | 100.172 |  |  | For all Price Adjs
4.375 | 99.819 | 99.694 | 99.569 | 98.944
4.25 | 99.237 | 99.112 | 98.987 | 98.362
4.125 | 98.406 | 98.281 | 98.156 | 97.531
4 | 97.388 | 97.263 | 97.138 | 96.513
3.875 | 96.34 | 96.215 | 96.09 | 95.465
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.318 | 102.193 | 102.068 | 101.693
3.75 | 101.956 | 101.831 | 101.706 | 101.331
3.625 | 101.516 | 101.391 | 101.266 | 100.891
3.5 | 100.966 | 100.841 | 100.716 | 100.091
3.375 | 100.171 | 100.046 | 99.921 | 99.296
3.25 | 99.393 | 99.268 | 99.143 | 98.518 |  | 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 | 2014-04-03 09:22:26.920000
30 DAY | 2014-04-18 09:22:26.920000
45 DAY | 2014-05-03 09:22:26.920000
60 DAY | 2014-05-18 09:22:26.920000
90 DAY | 2014-06-17 09:22:26.920000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 116134d1311618247-vlookup-challenge-master-spread-example-modified-by-tigeravatar-
Sheet: LOB Summary

 |  | Revenue | FL Third Party Liability | XREV - Total Revenues
 |  | Direct Expenses | FL Third Party Liability | XDEXP - Direct Expenses
 |  | Gross Margin | FL Third Party Liability | XGM - Gross Margin
 |  | Selling, Admin, & General | FL Third Party Liability | XSAG - Selling, [NAME] and [NAME]
 |  | Operating Income | FL Third Party Liability | XOPINC - Operating Income
 |  | Profit Before Tax | FL Third Party Liability | XPBT - Profit Before Tax and Eq Inc
 |  | Gross Margin %
 |  | Operating Income %
 |  | FTE |  | Full-time Equivalent | 0
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-15

Jornada | 16
Arsenal | 2 | 0 | West Bromwich Albion
[NAME] | 0 | 0 | Stoke City
Southampton | 1 | 0 | Reading
Sunderland | 1 | 3 | Chelsea
Swansea City | 3 | 4 | Norwich City
Wigan Athletic | 2 | 2 | Queen Parks Rangers
Manchester City | 2 | 3 | [NAME]
Everton | 2 | 1 | [NAME]
West Ham United | 2 | 3 | Liverpool
Fulham | 2 | 1 | Newcastle United
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4 | 1
5
6 | 15
7
8
9
10
11
12
13 | 6056 |  |  | 5000
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-01-31 00:00:00 |  |  |  | 1867
 | 2001-02-14 00:00:00
Spreadsheet: 342307ed-5f57-4741-b9f3-693e8515136a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PINW | Test | PINW | Pinworm Exam, Perianal | Pinworm Exam, Perianal | Microscopic | SWUBE kit: SWUBE |  |  |  | Varies | [NAME]: SWUBE disposable paddle (Falcon) (Supply T300) or similar method of collection [NAME]: Entire specimen Collection Instructions: See Pinworm Collection Instructions in Special Instructions. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday through Friday; Varies | 1 day | 4 days | 1 | 87172 |  |  |  |  | Rochester
PINW | [NAME] | VARIES | Varies |  |  |  | Ambient | 7 days
PINW | Order Question | Q00M0048 | [NAME] |  | Plain Text
PINW | Result | PINW | Pinworm Exam, Perianal | Pinworm Exam, Perianal | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 286482d1388310779-allocation-of-data-to-staff-with-certain-criteria-vlookup_2_fields
Sheet: Staff and Criteria of allocatio

Bucket_Product | Name | Collection Dept. | Product | Bucket | Accounts to be assigned | Product
 | [NAME] | In House | STL | 1 | 166 | STL
 | [NAME] | In House | STL | 1 | 165 | STL
 | [NAME] [NAME] | In House | STL | 30+ | 110 | STL
 | [NAME] [NAME] | In House | STL | 30+ | 111 | STL
 | Hamod Fahad Aldosari | Field | STL W/O | 270 + | 68 | STL
 | [NAME] [NAME] | Field | STL W/O | 270 + | 68 | STL
 | [NAME] | Field | STL W/O | 270 + | 68 | STL
 | [NAME] | In House | NSTL | 1 | 145 | NSTL
 | [NAME] | In House | NSTL | 1 | 146 | NSTL
 | [NAME] | In House | NSTL | 1 | 146 | NSTL
 | [NAME] | In House | NSTL | 30 - 90 | 140 | NSTL
 | [NAME] | In House | NSTL | 30 - 90 | 140 | NSTL
 | [NAME] | In House | NSTL | 90 – 269 | 75 | NSTL
 | [NAME] | In House | NSTL | 90 – 269 | 76 | NSTL
 | [NAME] | In House | NSTL | 90 – 269 | 76 | NSTL
 | [NAME] A Sliman | Field | NSTL W/O | 270 + | 71 | NSTL
 | [NAME] | Field | NSTL W/O | 270 + | 71 | NSTL
 | [NAME] Alotaibi | Field | NSTL W/O | 270 + | 72 | NSTL
 | Fahad Easa Khamis Alanazi | Field | Self Employed | 150 - 179 | 81 | Self Employed
 | [NAME] | Field | Self Employed | 120 - 149 | 81 | Self Employed
 | [NAME] | Field | Self Employed | 180 - 209 | 82 | Self Employed
 | Abdulaziz Al Amary | In House | Self Employed | 1 - 60 | 87 | Self Employed
 | [NAME] | In House | Self Employed | 1 - 60 | 87 | Self Employed
 | [NAME] | In House | Vehicle | 1 | 167 | Auto
 | [NAME] | In House | Vehicle | 1 | 168 | Auto
 | [NAME] | In House | Vehicle | 30+ | 104 | Auto
Spreadsheet: 2f9c1735-b36e-4a05-a47b-d5d4848bca43
Sheet: Sheet1

Release: BEA Regions Employment and Unemployment | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=138
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-24 11:09 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Employment and Unemployment | 2007-07-20 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2007-07-20 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-07-20 00:00:00
2007-08-17 00:00:00
2007-09-25 00:00:00
2007-10-19 00:00:00
2007-11-28 00:00:00
2007-12-21 00:00:00
2008-01-18 00:00:00
2008-03-11 00:00:00
2008-03-28 00:00:00
2008-04-18 00:00:00
2008-05-16 00:00:00
2008-06-20 00:00:00
2008-07-18 00:00:00
2008-08-15 00:00:00
2008-09-19 00:00:00
2008-10-21 00:00:00
2008-11-21 00:00:00
2008-12-19 00:00:00
2009-01-27 00:00:00
2009-02-27 00:00:00
2009-03-11 00:00:00
2009-03-27 00:00:00
2009-04-17 00:00:00
2009-05-22 00:00:00
2009-06-19 00:00:00
2009-07-17 00:00:00
2009-08-21 00:00:00
2009-09-18 00:00:00
2009-10-21 00:00:00
2009-11-20 00:00:00
2009-12-18 00:00:00
2010-01-22 00:00:00
2010-03-10 00:00:00
2010-03-26 00:00:00
2010-04-16 00:00:00
2010-05-21 00:00:00
2010-06-18 00:00:00
2010-07-20 00:00:00
2010-08-20 00:00:00
2010-09-21 00:00:00
2010-10-22 00:00:00
2010-11-23 00:00:00
2010-12-17 00:00:00
2011-01-25 00:00:00
2011-03-10 00:00:00
2011-03-25 00:00:00
2011-04-19 00:00:00
2011-05-20 00:00:00
2011-06-17 00:00:00
2011-07-22 00:00:00
2011-08-19 00:00:00
2011-09-16 00:00:00
2011-10-21 00:00:00
2011-11-22 00:00:00
2011-12-20 00:00:00
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
2014-04-18 00:00:00
2014-05-16 00:00:00
2014-06-20 00:00:00
2014-07-18 00:00:00
2014-08-18 00:00:00
2014-09-19 00:00:00
2014-10-21 00:00:00
Spreadsheet: 752040d1634550097-formula-to-calculate-average-difference-between-dates-example
Sheet: Sheet1

CONF/11 | 2020.12.23 | 2021.01.26
CONF/12 | 2021.01.06 | 2021.03.04
CONF/13 | 2021.03.04 | 2021.03.25
CONF/14 | 2021.03.18 | 2021.03.31
CONF/15 | 2021.03.31 | 2021.05.10
CONF/16 | 2021.05.10 | 2021.06.09
CONF/17 | 2021.06.09 | 2021.08.05
CONF/18 | 2021.08.05 | 2021.09.07
CONF/19 | 2021.08.27 | 2021.10.06 |  | Average diff of dates:
CONF/20 | 2021.09.07
CONF/21
CONF/22
CONF/23
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -46799
3531 | -274395 | -169301
60667 |  | -56295
60749 |  | -729623
61206
61334 | -137538
62960
INDEX
2001-05-31 00:00:00 |  |  | 1177095.58
2001-06-24 00:00:00
Spreadsheet: 3173b4bf-57ba-4919-a519-dfd98d584be7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
CHƯƠNG TRÌNH DỰ KIẾN ĐOÀN XTTM TẠI MYANMAR DO Đ/C LÊ THANH HẢI - ỦY VIÊN BỘ CHÍNH TRỊ, BÍ THƯ THÀNH ỦY TP HCM DẪN ĐẦU 11-15/3/2012
Thời gian | Chương trình | [NAME] | Ghi chú
[NAME] 11/3/2012
11g40 | Rời sân bay Tân Sơn Nhất
13g25 | Đáp máy bay YGN
14g00 | Check in tại khách sạn Chatrium
15g00 | [NAME] quan bảo tàng quốc gia
16g00 | [NAME] quan [NAME]
18g30 | Ăn tối
Thứ hai 12/03/2012
8g30 | Làm việc với một số tập đoàn lớn tại Myanmar
13g30 | Khai mạc triển lãm, hội thảo [NAME], giao thương với DN Myanmar
18g30 | Gala dinner, [NAME] DN Việt Nam và DN Myanmar.
thứ ba 13/3/2012
8g30 | Trọn ngày khảo sát hệ thống kênh phân phối, bán sĩ, bán lẽ tại Yangon gồm: Mingalat market, [NAME], [NAME] center, Dragon center, Sein Gay Har Center, Gamonpwint Shopping Center ...
18g30 | Ăn tối
Thứ tư 14/3/2012
8g30 | Khảo sát [NAME] và KCN tại Yangon
12g00 | Ăn trưa
13g30 | Làm việc với đại sứ quán Việt Nam tại Myanmar
18g30 | Ăn tối
Thứ năm 15/3/2012
8h30 | Khảo sát chợ bán lẻ Bogyoke
12g30 | Đoàn [NAME] bay khởi hành về TP HCM
17g00 | đến TP HCM
Ghi chú: chương trình có thể thay đổi tuỳ theo điều [NAME] tại Myanmar mà không cần phải [NAME].
Spreadsheet: 84212d1284213853-using-if-and-or-together-book1
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  | Result
1 |  |  |  |  |  |  |  | if(a2=(1:28 or 58:117or145:174),"03X05", if(a2=(29:45 or 118:132,)"03X10")
2 |  |  |  |  |  |  |  | if(a3=(1:28 or 58:117or145:174),"03X05", if(a3=(29:45 or 118:132,)"03X10")
3 |  |  |  |  |  |  |  | if(a4=(1:28 or 58:117or145:174),"03X05", if(a4=(29:45 or 118:132,)"03X10")
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
58
59
60
61
62
63
64
65
66
67
68
69
70
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
Spreadsheet: 75537d1276098995-cell-reference-to-entire-list-example-2
Sheet: Sheet1

type item code here [NAME]
5AC-304100
Item Code | Description | Free | SO | PO | Active | OFS | DIS | BO Until
and have all the information associated to the item code pop up in line 6
Item Code | Description | Free | SO | PO | Active | OFS | DIS | BO Until
5AC-304100 | 10 Candle Imperial Candelabra | -1 | 1 | 1 | T | F | F
5AC-304115 | Chain Link Fireplace Candelabra | 3 | 1 | 0 | T | F | F
5AC-304130 | [NAME] | 4 | 0 | 0 | T | F | F
5AC-304135 | Gothic Style Fireplace Candelabra | -5 | 5 | 5 | T | F | F | 2010-06-30 00:00:00
5AC-670130 | Fireback Feet For Adams Fireback | 1 | 1 | 1 | T | F | F
5AC-670500 | American Eagle Fireback - 18" H x 24" W | 3 | 0 | 0 | T | F | F
5AC-670505 | American Flag Fireback - 18" H x 24" W | 0 | 0 | 0 | T | F | F
5AC-670510 | Sun Fireback - 18” H x 24” W | 0 | 0 | 0 | T | F | F
5AC-670515 | Pineapple Fireback - 18" H x 24" W | 1 | 0 | 0 | T | F | F
5AC-670520 | Fleur Des Lys Fireback - 16" H x 20" W | 0 | 0 | 0 | T | F | F
5AC-670525 | Plain Fireback - 16" H x 20" W | 1 | 0 | 0 | T | F | F
5AC-670530 | Lions Fireback - 19" H x 25" W | 0 | 0 | 0 | T | F | F
5AC-800505 | Gothic Style Andiron | -1 | 1 | 4 | T | F | F | 2010-06-30 00:00:00
5AC-800524 | Black Scroll Andirons | 0 | 0 | 0 | F | F | T
5AR-FLYBAG | Disposable Non-Toxic Fly Trap | 3 | 0 | 0 | T | T | F
5BC-BRPC-CRATE | Black Rock Powder Co Firestarter & Crate | 68 | 1 | 1 | T | F | F
5BC-BRPC-REFILL | Black Rock Powder Co Firestarter Refill | 94 | 7 | 7 | T | F | F
5BP-65575 | 7-Ton Electric Log Splitter | -5 | 5 | 5 | T | F | F | 2010-06-30 00:00:00
5BP-65575 | 7-Ton Electric Log Splitter | -5 | 5 | 5 | T | F | F | 2010-06-30 00:00:00
5CF-DF20 | 20" Deep Forest Lifetime Grate | 0 | 0 | 0 | T | F | F
5CF-DF24 | 24" Deep Forest Lifetime Grate | 0 | 0 | 0 | T | F | F
5CF-DF28 | 28" Deep Forest Lifetime Grate | -4 | 4 | 4 | T | F | F
Spreadsheet: 113299d1309261208-how-to-create-the-booking-meeting-by-time-table-book1
Sheet: Time Table

 |  | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00
2011-06-28 00:00:00 | R - 1 |  |  | 132 - tom |  |  |  |  |  |  |  | 111 - mary
 | R - 2 |  |  |  |  |  |  |  |  |  |  |  |  | 153 - john
 | R - 3
 | R - 4
 | R - 5
2011-06-29 00:00:00 | R - 1
 | R - 2
 | R - 3
 | R - 4
 | R - 5
2011-06-30 00:00:00 | R - 1
 | R - 2
 | R - 3
 | R - 4
 | R - 5
2011-07-01 00:00:00 | R - 1
 | R - 2
 | R - 3
 | R - 4 | 153 - john
 | R - 5
2011-07-02 00:00:00 | R - 1
 | R - 2
 | R - 3
 | R - 4
 | R - 5