tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a0d6aff2-13b4-4a46-a5b7-0fa3616d05e4
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/12/2012 | Women's Swimming &amp; Diving | West Virginia State Games (Huntington, W.Va.) | 1st place
10/13/2012 | Women's Swimming &amp; Diving | West Virginia State Games (Huntington, W.Va.) | 1st place
10/19/2012 | Women's Swimming &amp; Diving | Penn State | L, 146-97
10/27/2012 | Women's Swimming &amp; Diving | at Villanova | W, 171-128
10/27/2012 | Women's Swimming &amp; Diving | vs. [NAME] (Villanova, Pa.) | W, 163-137
11/02/2012 | Women's Swimming &amp; Diving | at Cincinnati | W, 163-137
11/16/2012 | Women's Swimming &amp; Diving | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/17/2012 | Women's Swimming &amp; Diving | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/18/2012 | Women's Swimming &amp; Diving | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/29/2012 | Women's Swimming &amp; Diving | U.S. Winter Nationals (Austin, Texas) | 5th place
11/30/2012 | Women's Swimming &amp; Diving | U.S. Winter Nationals (Austin, Texas) | 7th place
11/30/2012 | Women's Swimming &amp; Diving | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Women's Swimming &amp; Diving | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Women's Swimming &amp; Diving | U.S. Winter Nationals (Austin, Texas) | 7th place
01/03/2013 | Women's Swimming &amp; Diving | Orange Bowl Classic (Key Largo, Fla.) | 3rd place
01/12/2013 | Women's Swimming &amp; Diving | at Pitt | L, 182-118
01/18/2013 | Women's Swimming &amp; Diving | TCU | L, 160-140
01/26/2013 | Women's Swimming &amp; Diving | Ohio | L, 165-135
02/09/2013 | Women's Swimming &amp; Diving | [NAME] (Diving) | Results
02/27/2013 | Women's Swimming &amp; Diving | Big 12 Championships (Austin, Texas) | 2nd place
02/28/2013 | Women's Swimming &amp; Diving | Big 12 Championships (Austin, Texas) | 2nd place
03/01/2013 | Women's Swimming &amp; Diving | Big 12 Championships (Austin, Texas) | 2nd place
03/02/2013 | Women's Swimming &amp; Diving | Big 12 Championships (Austin, Texas) | 2nd place
03/15/2013 | Women's Swimming &amp; Diving | NCAA Zone Diving (Blacksburg, Va.) | Results
03/16/2013 | Women's Swimming &amp; Diving | NCAA Zone Diving (Blacksburg, Va.) | Results
03/21/2013 | Women's Swimming &amp; Diving | NCAA Women's Championships (Indianapolis, Ind.) | 34th place
[NAME] | Women's Swimming &amp; Diving | NCAA Women's Championships (Indianapolis, Ind.) | 38th place
03/23/2013 | Women's Swimming &amp; Diving | NCAA Women's Championships (Indianapolis, Ind.) | 31st place
Spreadsheet: 070f5cc3-3ebf-4850-b52e-70cfbb1d9a7f
Sheet: 4.1

Table 4.1: Net enrolment rate in primary/basic education by nationality, country, sex and year (per cent)
Country | year | Nationals |  |  | Non-nationals |  |  | Total
 |  | Male | Female | Total | Male | Female | Total | Male | Female | Total
Iraq
 | 2000 | ... | ... | ... | ... | ... | ... | ... | ... | 80.3
 | 2005 | ... | ... | ... | ... | ... | ... | 92.66014687758411 | 79.37881814285328 | 86.16036843218593
 | 2010 | ... | ... | ... | ... | ... | ... | 96.2 | 89 | 92.7
 | 2011(1) | ... | ... | ... | … | ... | ... | 99.8 | 92.5 | 96.3
Kuwait
 | 2005 | 96 | 99 | 98 | 79 | 76 | 77 | 89 | 90 | 90
 | 2010 | 95 | 94 | 94 | 85 | 82 | 83 | 90 | 89 | 90
Lebanon
 | 2004 | ... | ... | ... | ... | ... | ... | 92.7 | 92.7 | 92.7
 | 2009 | ... | ... | ... | ... | ... | ... | 98.3 | 98.4 | 98.3
Oman
 | 2005 | 89 | 95 | 89.7 | ... | ... | ... | ... | ... | ...
 | 2010 | 95 | 95 | 95 | 17.4 | 8.5 | 15.5 | 12.7 | 7.7 | 97.8
 | 2011 | ... | ... | ... | ... | ... | ... | ... | ... | 98.1
Palestine
 | 2000 | … | … | … | … | … | … | 90.7 | 92.7 | 91.7
 | 2005 | … | … | … | … | … | … | 89.3 | 91.3 | 90.3
 | 2010 | … | … | … | … | … | … | 88.9 | 92.8 | 90.8
 | 2011 | … | … | … | … | … | … | 91.4 | 93 | 92.2
Qatar
 | 2000 | … | … | … | … | … | … | 75.5 | 93 | 83.1
 | 2005 | … | … | … | … | … | … | 88.2 | 94.6 | 91.2
 | 2010 | … | … | … | … | … | … | 91.2 | 94 | 92.6
 | 2011 | … | … | … | … | … | … | 91.3 | 92.1 | 91.7
Saudi Arabia
 | 2010 | … | … | … | … | … | … | 96.63 | 96.52 | 96.58
 | 2011 | … | … | … | … | … | … | 96.6 | 96.5 | 96.55
Syrian Arab Republic
 | 2000 | 97.4 | 95.5 | 96.5 | … | … | … | 97.4 | 95.5 | 96.5
 | 2005 | 96.2 | 96 | 96.1 | … | … | … | 96.2 | 96 | 96.1
 | 2009 | 96.3 | 96 | 96.1 | … | … | … | 96.3 | 96 | 96.1
Yemen
 | 2000 | … | … | … | … | … | … | 77.4 | 45.9 | …
 | 2005 | 75.1 | 57.6 | 66.7 | … | … | … | 75.1 | 57.6 | 66.7
 | 2010 | 87 | 70.1 | 79.3 | … | … | … | 87 | 70.1 | 79.3
 | 2011 | 90.3 | 72.8 | 81.8 | … | … | … | 90.3 | 72.8 | 81.8
(1) Includes government and private.
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: SLw-rtoLL

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 861576d1709462328-how-to-use-reverse-writing-of-numbers-from-top-to-bottom-pp1-1-aligw
Sheet: Sheet1

 | 1 | 10 |  |  |  | [NAME] | [NAME] | [NAME] | TMS | TMS | TMS |  | Wk |  | JT
 | 2 | 9
 | 3 | 8
 | 4 | 7
 | 5 | 6
 | 6 | 5
 | 7 | 4
 | 8 | 3
 | 9 | 2
 | 10 | 1
Spreadsheet: 101880d1299928145-a-sort-of-hlookup-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min
 | abc | [NAME] | [NAME] | abf | abg | abh | abi | abj | abk
 |  |  | 1 |  |  |  | 1 |  |  | $E$3 | 150 | 3 | 277 | #N/A | #N/A
 |  | 1 |  |  |  |  |  |  |  |  | 250
 |  |  |  |  |  | 2
 | 100 | 250 | 150 | 750 | 75 | 190 | 277 | 290 | 379
Spreadsheet: 798621d1664591391-most-recent-date-based-on-match-excelforum-recentdate
Sheet: Results

ID | data | Name | data2 | Date | HD
154284 |  | ABC123 |  | 2024-01-15 00:00:00
154284 |  | DEF456 |  | 2022-09-09 00:00:00
154284 |  | GHI789 |  | 2021-07-06 00:00:00
154284 |  | MNO345 |  | 2021-06-30 00:00:00
258431 |  | ABC123 |  | 2021-07-06 00:00:00
258431 |  | DEF456 |  | 2021-07-15 00:00:00
258431 |  | MNO345 |  | 2021-07-06 00:00:00
258431 |  | PQR678 |  | 2018-04-20 00:00:00
847782 |  | GHI789 |  | 2017-09-09 00:00:00
847782 |  | JKL012 |  | 2019-07-21 00:00:00
847782 |  | MNO345 |  | 2022-12-11 00:00:00
856695 |  | ABC123 |  | 2022-09-09 00:00:00
856695 |  | JKL012 |  | 2021-11-15 00:00:00
856695 |  | MNO345 |  | 2021-06-21 00:00:00
856695 |  | PQR678 |  | 2015-03-21 00:00:00
856895 |  | DEF456 |  | 2018-07-18 00:00:00
856895 |  | GHI789 |  | 2019-08-05 00:00:00
856895 |  | JKL012 |  | 2020-08-05 00:00:00
856895 |  | PQR678 |  | 2013-12-20 00:00:00
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 23550 | 23150
2 | 23965 | 23150
3 | 23996 | 23150
4 | 23484 | 23150
5 | 23000 | 23150
6 | 23146 | 23150
7 | 20037 | 23150
8 | 23762 | 23150
9 | 23829 | 23150
10 | 23318 | 23150
11 | 23655 | 23150
12 | 26348 | 23150
13 | 39174 | 43466
14 | 22742 | 23150
15 | 22935 | 23150
16 | 23156 | 23150
17 | 23636 | 23150
18 | 29873 | 23150
19 | 20100 | 32025
20 | 23626 | 23150
21 | 41512 | 41280
22 | 20533 | 23150
23 | 24002 | 23150
24 | 13702 | 23150
25 | 23371 | 23150
26 | 19824 | 23150
27 | 15794 | 23150
28 | 59255 | 58150
29 | 62518 | 73150
30 | 33862 | 33150
31 | 33666 | 33150
2000-11-30 00:00:00 |  |  | 95639.73
2000-12-31 00:00:00
Spreadsheet: 21eeb168-fea3-4292-8c83-ea8a744604d1
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
CHGL | Test | CHGL | Chaetomium globosum, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CHGL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CHGL | Result | CHGL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7200-9 | Chaetomium [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 754800d1636506930-searching-a-value-different-tabs-using-some-conditionals-planilha-de-transporte-2022-1-
Sheet: LISTAS

 | FILIAIS | DESTINOS | VEÍCULOS | Coluna: |  |  |  | Desnecessário
 | SP |  | IVECO | VAN | G | H |  |  | ARACAJÚ - SE
 | GO |  | VUK (4,8m) | J | K |  |  | ATIBAIA - SP
 | BA |  | TRUCK (10m) | M | N |  |  | BELÉM - MA
 | PR |  | CARRETA(14,5m) | P | Q |  |  | BELO HORIZONTE - MG
 |  |  |  |  |  |  |  | BRAGANÇA PAULISTA - SP
 |  |  |  |  |  |  |  | BRASÍLIA - DF
 |  |  |  |  |  |  |  | CAMPINAS - SP
 |  |  |  |  |  |  |  | CAMPO GRANDE - GO
 |  |  |  |  |  |  |  | CAMPOS DO JORDÃO - SP
 |  |  |  |  |  |  |  | CURITÍBA - PR
 |  |  |  |  |  |  |  | FLORIANÓPOLIS - SC
 |  |  |  |  |  |  |  | FORTALEZA - CE
 |  |  |  |  |  |  |  | FOZ DO IGUAÇU - PR
 |  |  |  |  |  |  |  | GOIÂNIA - GO
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | ILHA DE COMANDATUBA - BA
 |  |  |  |  |  |  |  | ITATIBA - SP
 |  |  |  |  |  |  |  | ITÚ - SP
 |  |  |  |  |  |  |  | JOÃO PESSOAS - PA
 |  |  |  |  |  |  |  | JUNDIAÍ - SP
 |  |  |  |  |  |  |  | MOGI DAS CRUZES - SP
 |  |  |  |  |  |  |  | PORTO ALEGRE - RS
 |  |  |  |  |  |  |  | [NAME] DO FORTE - BA
 |  |  |  |  |  |  |  | RECIFE - PE
 |  |  |  |  |  |  |  | RIBERÃO PRETO - SP
 |  |  |  |  |  |  |  | RIO DE JANEIRO - RJ
 |  |  |  |  |  |  |  | SALVADOR - BA
 |  |  |  |  |  |  |  | SÃO PAULO - SP
 |  |  |  |  |  |  |  | SOROCABA - SP
 |  |  |  |  |  |  |  | VALINHOS - SP
 |  |  |  |  |  |  |  | VINHEDO - SP
 |  |  |  |  |  |  |  | VITÓRIA - ES
Spreadsheet: 640850d1568118294-allocation-formula-to-allocate-excess-stocks-to-required-inter-trasnfer-file-test-1-1-
Sheet: Sheet1

Sku Code | To Store | Incoming Stock opening | Qty Needed | cumulative requested | From | Total incoming /sku/store | Total requested /sku/store | Allocated | Balance | Action |  | Allocated | Balance | Action
1000058 | HKP06 | 6 | 3 | 3 | hpp28 |  |  |  |  |  |  | 3 | 3 | Allocated
1000058 | HHP20 |  | 4 |  | hpp28 |  |  |  |  |  |  | 3 | 0 | Partial Allocation
1000058 | HHP30 |  | 4 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000058 | HHP28 |  | 7 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000060 | HHP27 | 9 | 2 |  | hpp28 |  |  |  |  |  |  | 2 | 7 | Allocated
1000060 | HKP22 |  | 5 |  | hpp28 |  |  |  |  |  |  | 5 | 2 | Allocated
1000061 | [NAME] |  | 1 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000061 | HKP25 |  | 1 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000061 | HKP06 |  | 2 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
 |  |  |  |  |  |  |  |  |  |  |  | Result should be
Spreadsheet: 728239d1618386715-index-match-formula-to-extract-specific-data-from-table-sample-file
Sheet: Sheet1

Initial table
Activity | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 |  |  | 2021-04-01 00:00:00
Activity 1 |  |  | 2 | 1 |  |  | 2021-04-02 00:00:00
Activity 2 |  | 2 |  | 3 |  |  | 2021-04-05 00:00:00
Activity 3 |  |  | 1 |  |  |  | 2021-04-06 00:00:00
Activity 4 |  | 2
Activity 5 |  |  | 1
Activity 6 | 5 |  |  | 2
Activity 7 |  |  |  | 1
Activity 8 |  | 2 | 3
Activity 9 |  | 2 |  | 1
Activity 10 | 3 |  | 1
Final table
Activity | 2021-04-01 00:00:00
Activity 6 | 5
Activity 10 | 3
Spreadsheet: 414363d1439958387-hire-date-and-annual-raise-labor-formula
Sheet: Labor

LABOR
NAME | TITLE | HIRE DATE | ALLOC | [NAME] | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 |  | Update dates for quarter and year end as needed
RESEARCH & DEV
Smith | Example 1 | 2016-06-01 00:00:00 | 1 | 100000
[NAME] | Example 2 | 2018-06-01 00:00:00 | 1 | 50000
 |  |  |  | TOTAL COMP:
 |  |  |  | TOTAL COMP:
 |  |  |  | TOTAL BURDENED LABOR :
Assumptions:
- Burdened labor rate |  | 0.3 | (includes workers comp, PTO, payroll taxes, health benefits)
- Annual raise (inflation) |  | 0.02
Spreadsheet: 2ad6c3c3-ef7b-496b-b726-216c528a5f3f
Sheet: Spreadsheet History

Date | Version | Author | Changes
2008-07-01 00:00:00 | 1 | [NAME] | Initial version
2008-07-17 00:00:00 | 2 | [NAME] | Remove the date picker form from the spreadsheet as this was causing compatability issues with external users.
2008-04-30 00:00:00 | 2.01 | [NAME] | Fixed issue with average calculations. Offset had col 1 not col 0.
2008-06-23 00:00:00 | 2.011 | [NAME] | Users found that they weren't able to print the instructions.
2008-07-03 00:00:00 | 2.012 | [NAME] | Change the instructions to reflect that there is no longer a form to fill out.
2008-07-03 00:00:00 | 2.013 | [NAME] | Change the instructions to inform the user that the sheet should be opened in Excel.
2008-07-15 00:00:00 | 2.014 | [NAME] | Allow copying of protected cells, also ensure that the cell is protected when LWP = Y.
2008-07-24 00:00:00 | 2.015 | [NAME] | Pay periods can only be for a max of 1 standard year (52 weeks, 26 fortnights, 13 4 weekly & 12 monthly).
2008-08-22 00:00:00 | 2.016 | [NAME] | Request 65493 - Remove line from Instructions worksheet
2009-01-16 00:00:00 | 2.017 | [NAME] | LWP column has been hidden and instructions have been modified.
2009-03-24 00:00:00 | 3 | [NAME] | Added text box for user comment, drop down to select who completed the form, and GST Input Tax Credit field
2009-11-27 00:00:00 | 3.01 | [NAME] | Added Date of Injury field. Also added some validation code to ensure that DOI could not be within the entered pay period.
2011-06-30 00:00:00 | 3.02 | Heidrun Richter | Protect Calculator tab and change description of Base wage section and Allowances section. CO8081 - Req106587 and Inc106651
2011-08-31 00:00:00 | 3.03 | Heidrun Richter | CO8255 - add overall total for the entered figures
2011-09-19 00:00:00 | 3.04 | Heidrun Richter | CO8255 - fix the logic getting the overall total for the entered figures
2013-04-22 00:00:00 | 3.05 | [NAME] | Req 119084 - Reorder data entry to reflect Curam
Spreadsheet: 543462d1508410366-moving-16-week-average-moving-average
Sheet: t

16
name | avg | comm
Adam
Black
[NAME]
Cannon
[NAME]
Carrie
Cars
[NAME]
[NAME]
[NAME]
Flores
Franklin
[NAME]
[NAME]
Madrid
Martin
Martinez
Orlando
[NAME]
[NAME]
Perkins
[NAME]
Raul
[NAME]
[NAME]
Shaw
Solo
[NAME]
Trinidad
Ward
Spreadsheet: 1deb9c92-bffe-4328-9793-45b9c2bd28c2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5838 | 13651 | Martin | Falch | AUT | 0 | 00:25:23 | 00:01:00 | 00:47:05 | 00:00:00 | 00:13:58 | 1 | 01:27:29
5838 | 39858 | Mikel | Garmendia | ESP | 0 | 00:27:01 | 00:01:06 | 00:53:11 | 00:00:00 | 00:16:09 | 2 | [NAME]
5838 | 41160 | Adrian | Howden | GBR | 0 | 00:28:06 | 00:00:49 | 00:54:39 | 00:00:00 | 00:16:32 | 3 | 01:40:09
Spreadsheet: 753002d1635178355-calculating-actual-and-budget-from-data-drop-test-mma
Sheet: MMA FP

FP
Period | 2
 |  | September - August
 |  | Actual | Budget
Code
510100
510130
510200
510201
510251
520153
510150
Spreadsheet: 72865d1273585679-event-calendar-conditional-formatting-with-if-function-across-worksheets-remediation-event-schedule
Sheet: May

2010-05-01 00:00:00 | 2010-05-02 00:00:00 | 2010-05-03 00:00:00 | 2010-05-04 00:00:00 | 2010-05-05 00:00:00
0 | 0 | 2 | 4 | 0
 |  | 0 | 0
 |  | Microbiology | 0
 |  |  | Pathology
 |  |  | 0
2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 2010-05-08 00:00:00 | 2010-05-09 00:00:00 | 2010-05-10 00:00:00
0 | 1 | 0 | 0 | 2
 | Genetics |  |  | 0
 |  |  |  | Anatomy
2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-13 00:00:00 | 2010-05-14 00:00:00 | 2010-05-15 00:00:00
0 | 0 | 0 | 0 | 0
2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00
0 | 1 | 0 | 0 | 0
 | Clinical Neuro Final Exam
2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00
0 | 0 | 0 | 0 | 0
2010-05-26 00:00:00 | 2010-05-27 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-05-30 00:00:00
0 | 0 | 0 | 0 | 0
2010-05-31 00:00:00
1
0
Spreadsheet: 863996d1711371572-hourly-daily-resource-counter-staffing
Sheet: Sheet1

Employee Name | Days Staffed | Shift Start | Shift End
Employee A | Thur-Mon | 12:00:00 | 21:00:00 |  |  |  |  |  | Sun | Mon | Tue | Wed | Thur | Fri | Sat
Employee B | Sat-Wed | 03:00:00 | 12:00:00 |  |  |  |  | 00:00:00
Employee C | Sun-Wed | 02:00:00 | 13:00:00 |  |  |  |  | 01:00:00
Employee D | Sun-Thur | 03:00:00 | 12:00:00 |  |  |  |  | 02:00:00
Employee E | Sun-Wed | 09:00:00 | 20:00:00 |  |  |  |  | 03:00:00
Employee F | Sun-Wed | 09:00:00 | 20:00:00 |  |  |  |  | 04:00:00
Employee G | Mon-Fri | 08:00:00 | 17:00:00 |  |  |  |  | 05:00:00
Employee H | Mon-Fri | 08:00:00 | 17:00:00 |  |  |  |  | 06:00:00
Employee I | Mon-Fri | 11:00:00 | 20:00:00 |  |  |  |  | 07:00:00
Employee J | Mon-Fri | 11:00:00 | 20:00:00 |  |  |  |  | 08:00:00
Employee K | Tue-Sat | 03:00:00 | 12:00:00 |  |  |  |  | 09:00:00
Employee L | Tue-Sat | 03:00:00 | 12:00:00 |  |  |  |  | 10:00:00
Employee M | Tue-Sat | 08:00:00 | 17:00:00 |  |  |  |  | 11:00:00
Employee N | Tue-Sat | 12:00:00 | 21:00:00 |  |  |  |  | 12:00:00
Employee O | Wed-Sat | 02:00:00 | 13:00:00 |  |  |  |  | 13:00:00
Employee P | Wed-Sat | 09:00:00 | 20:00:00 |  |  |  |  | 14:00:00
Employee Q | Wed-Sun | 21:00:00 | 06:00:00 |  |  |  |  | 15:00:00
Employee R | Wed-Sun | 21:00:00 | 06:00:00 |  |  |  |  | 16:00:00
Employee S | Wed-Sun | 21:00:00 | 06:00:00 |  |  |  |  | 17:00:00
Employee T | Wed-Sun | 21:00:00 | 06:00:00 |  |  |  |  | 18:00:00
Employee U | Wed-Sun | 21:00:00 | 06:00:00 |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  | 23:00:00
Spreadsheet: 480520d1473951220-consumption-data-import-into-template-worksheet-template-data
Sheet: Sheet1

DEM-0549 (DF88FRGP)
Date | Distance | Engine Hours | [NAME] | Total Consumed | KM/L | L/100km
DEM-0572 (FC57HBGP)
Date | Total Distance | Actual Engine Hours | [NAME] | Total Consumed | KM/L | L/100km
 | 67.75999999999476 | 4 | 84 km/h | 28.34999999999854
 | 1017.399999999994 | 14 | 106 km/h | 410.5500000000029
 | 900.2600000000093 | 16 | 108 km/h | 372.75
 | 568.2299999999959 | 9 | 106 km/h | 212.0999999999985
 | 608.8999999999942 | 11 | 105 km/h | 334.9499999999971
 | 0.3000000000029104 | 0 | 7 km/h | 0 | - | -
 | 330.0399999999936 | 5 | 100 km/h | 168
 | 3492.739999999991 | 59 | 108 km/h | 1526.699999999997
DMX-0377 (DR15GRGP)
Date | Total Distance | Total Engine Hours | [NAME] | Total Consumed | KM/L | L/100km
 | 254.7900000000081 | 11 | 95 km/h | 112.3499999999985
 | 159.6399999999994 | 4 | 98 km/h | 75.60000000000582
 | 161.0599999999977 | 8 | 87 km/h | 64.04999999999563
 | 197.9199999999983 | 8 | 87 km/h | 80.84999999999854
 | 529.1600000000035 | 11 | 91 km/h | 204.75
 | 794.6800000000076 | 15 | 93 km/h | 451.5
 | 911 | 15 | 94 km/h | 441
 | 3008.190000000002 | 72 | 98 km/h | 1430.099999999999
DMX-0733 (HXT359MP)
Date | Total Distance | Total Engine Hours | [NAME] | Total Consumed | KM/L | L/100km
 | 64.93000000000029 | 4 | 91 km/h | 43.04999999999927
 | 24.31999999999971 | 2 | 98 km/h | 22.04999999999927
 | 27.05999999999767 | 3 | 90 km/h | 13.65000000000146
 | 848.0300000000025 | 14 | 110 km/h | 452.5499999999993
 | 674.8899999999994 | 12 | 102 km/h | 217.3500000000004
 | 288.4399999999987 | 4 | 99 km/h | 84
 | - | - | - | - | - | -
 | 1927.649999999998 | 39 | 110 km/h | 832.6499999999996
DMX-0769 (FF20BJGP)
Date | Total Distance | Total Engine Hours | [NAME] | Total Consumed | KM/L | L/100km
 | 669.3199999999997 | 10 | 101 km/h | 313.9500000000007
 | 803.7799999999988 | 12 | 108 km/h | 369.5999999999985
 | 489.1800000000003 | 8 | 92 km/h | 220.5
 | 664.3199999999997 | 10 | 98 km/h | 308.7000000000007
 | 829.9000000000015 | 13 | 98 km/h | 360.1500000000015
 | - | - | - | - | - | -
 | 12.69999999999709 | 1 | 86 km/h | 6.299999999999272
 | 3469 | 54 | 108 km/h | 1579.200000000001
Spreadsheet: 0488b9a4-8a6c-490e-ba44-6de380bb920f
Sheet: AMH CMH Patients Served

 |  | Adult Mental Health |  |  | Children's Mental Health
 |  | Number of adults served this Month | Number of adults served [NAME] |  | Number of children served this Month | Number of children served [NAME]
Region 1 | Benewah | 323 |  |  | 68
 | [NAME]
 | Boundary
 | Kootenai
 | Shoshone
Region 2 | Clearwater | 219 |  |  | 67
 | Idaho
 | Latah
 | Lewis
 | Nez Perce
Region 3 | Adams | 438 |  |  | 70
 | Canyon
 | Gem
 | Owyhee
 | Payette
 | Washington
Region 4 | [NAME] | 599 |  |  | 125
 | Boise
 | Elmore
 | Valley
Region 5 | Blaine | 301 |  |  | 53
 | [NAME]
 | Cassia
 | Gooding
 | [NAME]
 | Lincoln
 | Minidoka
 | [NAME]
Region 6 | Bannock | 268 |  |  | 54
 | Bear Lake
 | [NAME]
 | Franklin
 | Oneida
 | Power
Region 7 | Bingham | 478 |  |  | 167
 | [NAME]
 | [NAME]
 | [NAME]
 | Custer
 | Fremont
 | [NAME]
 | Lemhi
 | [NAME]
 | Teton
Unknown |  | . | . |  | . | .
Statewide
 |  | July AMH Number Served | AMH FY 13 Clients Served |  | July CMH Number Served | CMH FY 13 Clients Served
 | Region 1 | 323 | 323 |  | 68 | 68
 | Region 2 | 219 | 219 |  | 67 | 67
 | Region 3 | 438 | 438 |  | 70 | 70
 | Region 4 | 599 | 599 |  | 125 | 125
 | Region 5 | 301 | 301 |  | 53 | 53
 | Region 6 | 268 | 268 |  | 54 | 54
 | Region 7 | 478 | 478 |  | 167 | 167
 | Statewide Total
Spreadsheet: 195556d1353552297-look-up-certain-values-and-then-combine-the-rest-in-to-one-cell-excel-query-v2
Sheet: Result

 |  |  | Product name | Product Name | JAN | FEB | MAR | APR
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | [NAME] | REVITALENS |  | #N/A | 345
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | Complete | [NAME] | [NAME] |  | 521
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | [NAME]. Tears | DROPS- B&C & BLINK |  |  | 2134
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | Other | Rest (total of other items for Adrian Piekarski) |  | #N/A | 12797
3580/99/01/PROF72002 | RICHARD PATMORE | [NAME] | REVITALENS
3580/99/01/PROF72002 | RICHARD PATMORE | Complete | [NAME] | [NAME] |  |  |  |  | This should be the total of the rest of the values for Adrian Piekarski
3580/99/01/PROF72002 | RICHARD PATMORE | [NAME]. Tears | DROPS- B&C & BLINK
3580/99/01/PROF72002 | RICHARD PATMORE | Other | Rest (total of other items for [NAME])
3580/99/01/PROF72003 | VACANT NSW | [NAME] | REVITALENS
3580/99/01/PROF72003 | VACANT NSW | Complete | [NAME] | [NAME]
3580/99/01/PROF72003 | VACANT NSW | [NAME]. Tears | DROPS- B&C & BLINK
3580/99/01/PROF72003 | VACANT NSW | Other | Rest (total of other items for Vacant NSW)
Spreadsheet: 792552d1660949124-return-the-row-and-column-of-a-search-result-sample
Sheet: Sheet1

 | Find This |  | Find Here |  |  |  | Result
 |  |  | A | B | C |  | B
 | 117010 |  | 106930 | 105762 | 108361
 |  |  | 113432 | 107710 | 108833
 |  |  | 116509 | 107008 | 109029
 |  |  | 116704 | 114681 | 109063
 |  |  | 117130 | 114748 | 109120
 |  |  |  | 116053 | 109618
 |  |  |  | 116109 | 110122
 |  |  |  | 116176 | 110173
 |  |  |  | 116696 | 101442
 |  |  |  | 117010 | 101563
 |  |  |  | 117416 | 102493
 |  |  |  | 117508 | 105893
 |  |  |  |  | 106147
 |  |  |  |  | 106479
 |  |  |  |  | 104841
 |  |  |  |  | 106455
 |  |  |  |  | 104672
 |  |  |  |  | 105799
 |  |  |  |  | 112799
 |  |  |  |  | 114122