tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 46290d1245189891-nested-if-functions-copy-of-drug-half-life-calc
Sheet: Sheet2

Day | Days | Dose | Concentration (formula) |  | Half life | 16
Monday | 1 |  |  |  | Desired dose: | 400
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Saturday | 6
Sunday | 7
Monday | 8
Tuesday | 9
Wednesday | 10
Thursday | 11
Friday | 12
Saturday | 13
Sunday | 14
Monday | 15
Tuesday | 16
Wednesday | 17
Thursday | 18
Friday | 19
Saturday | 20
Sunday | 21
Monday | 22
Tuesday | 23
Wednesday | 24
Thursday | 25
Friday | 26
Saturday | 27
Sunday | 28
Monday | 29
Tuesday | 30
Wednesday | 31
Thursday | 32
Friday | 33
Saturday | 34
Sunday | 35
Monday | 36
Tuesday | 37
Wednesday | 38
Thursday | 39
Friday | 40
Saturday | 41
Sunday | 42
Monday | 43
Tuesday | 44
Wednesday | 45
Thursday | 46
Friday | 47
Saturday | 48
Sunday | 49
Monday | 50
Tuesday | 51
Wednesday | 52
Thursday | 53
Friday | 54
Saturday | 55
Sunday | 56
Monday | 57
Tuesday | 58
Wednesday | 59
Thursday | 60
Friday | 61
Spreadsheet: 134590d1325499332-how-to-associate-cell-contents-with-other-cells-sample2
Sheet: Sheet1

ID | Group | Date | Species | Tank | Collected | N | P | SE | SL | Nu | Pu | SEu | SLu | Notes
SB1 | SB | 2011-06-12 00:00:00 | U | 1 | 2011-05-12 00:00:00 | 150 | 2 | 3 | 4
SB10 | SB | 2011-06-12 00:00:00 | U | 4 | 2011-05-12 00:00:00 | 210 |  | 3 | 4
SB11 | SB | 2011-06-12 00:00:00 | U | 2 | 2011-05-12 00:00:00 | 185 |  | 3 | 4
SB12 | SB | 2011-06-12 00:00:00 | U | 4 | 2011-05-12 00:00:00 | 140 |  | 1 | 1
[NAME] | SB | 2011-06-12 00:00:00 | U | 3 | 2011-05-12 00:00:00 | 130 |  | 4 | 5
[NAME] | SB | 2011-06-12 00:00:00 | U | 3 | 2011-05-12 00:00:00 | 230 |  | 1 | 2
SB15 | SB | 2011-06-12 00:00:00 | U | 3 | 2011-05-12 00:00:00 | 260 |  | 3 | 4
SB16 | SB | 2011-06-12 00:00:00 | U | 2 | 2011-05-12 00:00:00 | 120 |  | 7 | 7
SB17 | SB | 2011-06-12 00:00:00 | U | 2 | 2011-05-12 00:00:00 | 120 |  | 4 | 5
SB18 | SB | 2011-06-12 00:00:00 | U | 1 | 2011-05-12 00:00:00 | 160 |  | 7 | 7
SB19 | SB | 2011-06-12 00:00:00 | U | 5 | 2011-05-12 00:00:00 | 170 |  | 2 | 2
SB2 | SB | 2011-06-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 | 210 | 1 | 1 | 1
SB20 | SB | 2011-06-12 00:00:00 | U | 8 | 2011-05-12 00:00:00 | 85 |  | 1 | 2
SB21 | SB | 2011-06-12 00:00:00 | U | 7 | 2011-05-12 00:00:00 | 55 |  | 1 | 2
SB22 | SB | 2011-06-12 00:00:00 | U | 7 | 2011-05-12 00:00:00 | 120 |  | 3 | 4
SB23 | SB | 2011-06-12 00:00:00 | U | 8 | 2011-05-12 00:00:00 | 150 |  | 3 | 4
SB24 | SB | 2011-06-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 | 165 |  | 1 | 2
SB25 | SB | 2011-06-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 | 70 |  | 1 | 2
SB26 | SB | 2011-06-12 00:00:00 | U | 3 | 2011-05-12 00:00:00 | 120 |  | 3 | 4
SB27 | SB | 2011-06-12 00:00:00 | U | 1 | 2011-05-12 00:00:00 | 145 |  | 1 | 1
SB12 | SB | 2011-12-12 00:00:00 | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 4
[NAME] | SB | 2011-12-12 00:00:00 | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 30 | 4 | 4
SB19 | SB | 2011-12-12 00:00:00 | U | 7 | 2011-05-12 00:00:00 |  |  |  |  |  | 40 | 4 | 4
SB2 | SB | 2011-12-12 00:00:00 | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 40 | 4 | 4
SB20 | SB | 2011-12-12 00:00:00 | U | 7 | 2011-05-12 00:00:00 |  |  |  |  | 85 | 60 | 4 | 4
SB21 | SB | 2011-12-12 00:00:00 | U | 7 | 2011-05-12 00:00:00 |  |  |  |  |  | 55 | 4 | 5
SB24 | SB | 2011-12-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 5
SB25 | SB | 2011-12-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 5
SB27 | SB | 2011-12-12 00:00:00 | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 5 | 4 | 4
Spreadsheet: 31f759c9-ef56-4cc4-9648-514e7e384b51
Sheet: Sheet1

2010-2011  Data Validation Monitoring (DVM) System for Student Discipline Records Continuous Improvement Plan (CIP)/Corrective Action Plan (CAP) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
[NAME]: |  | CDN: |  | Submission Date: |  |  | Date Findings were Presented to the Board of Trustees in [NAME] with TEC §7.028(b):
Indicator Description | Area of Concern | Components | Corrective Actions/Improvement Activities  (See tab titled "Considerations for CIP_CAP") | Start Date | Projected Completion Date | Resources Required and Person(s) Responsible | Evidence of Implementation | Evidence of Impact
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
select | select | select
Spreadsheet: 183654d1348932047-find-max-number-of-current-month-test-book
Sheet: Φύλλο1

 |  | X | Μ.Ο. ΗΜΕΡΑΣ ΤΡΕΧΩΝ ΤΡΙΜΗΝΟΥ | january |  | febryary |  | march |  | april |  | may |  | june |  | jyly |  | august |  | september |  | ocktober |  | november |  | december
item | description |  |  |  | 23 |  | 20 |  | 21 |  | 22 |  | 23 |  | 20 |  | 23 |  | 22 |  | 21 |  | 23 |  | 21 |  | 22
 |  |  |  | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day | month sales | qty per day
 |  |  | 200 | 2000 |  | 2200 |  | 2100 |  | 3000 |  | 5000 |  | 6000 |  | 2500 |  | 2200 |  | 2300 |  | 3000 |  | 1500 |  | 2000
Spreadsheet: 70839d1271552071-excel-scheduler-car
Sheet: Sheet2

DATE | CAR REG | MAKE | MODEL | ENGINE | COLOR
2010-04-18 00:00:00 | abc | Honda | Civic | 1.5 Petrol | Red
2010-04-19 00:00:00 | def | Ford | Focus | 1.8 Diesel | Blue
2010-04-20 00:00:00 | ghi | VW | Polo | 2.0 Petrol | Green
2010-04-21 00:00:00 | jkl | BMW | X5 | 2.0 Petrol | Black
2010-04-22 00:00:00 | mno | Vauxhall | Corsa | 1.2 Petrol | Black
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 12c

Product | AUD* | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending October 25, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: lisa_gang__22228__EPE_MARCH_2002
Sheet: MARCH(22)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-21 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 3/21
 |  | 3/1/02-3/31/02
 |  | EPMI TAG#41593 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 00ff81ee-4b5a-4b05-95a0-feff3d4d857a
Sheet: Sheet1

Table 1 -- Summary of sugar outlook in major producing and trading countries for 2012/13-exporters | Unnamed: 1
Brazil
* | Sugarcane production up 4% to 565 million metric tons (mt)
* | Reduced investment in producing facilities - only 2 new units in 2012 and area expands only 1%
* | Dry weather in January-March 2012 affected stock development for 2012/13.
* | Lower than average plantings of new cane increase the age profile of 2012/13 crop, affecting yield potential.
* | Total Reducing Sugar (TRS) is forecast at 139.07 kilograms per mt of sugarcane, have  2.48 kg above last year.
* | TRS ratio for sugar is projected at 48.63% due to strong demand in international market.
* | Exports are projected at  25.25 million metric tons, raw value (MTRV), up 2.4%.
Thailand
* | Sugarcane in 2012/13 projected at 105 million tons (100.5 million in 2011/12, 95.7 million in 2010/11, 69.0 million in 2009/10).
* | Sugar production forecast at 10.85 million MTRV, 9.3 million MTRV
 | for exports (9.0 million MTRV in 2011/12 and 6.642 million MTRV in 2010/11).
* | [NAME] policy - higher support prices started in 2010/11and soft-loan programs finance increased mechanization.
* | Four new mills expected to start producing in 2012/13 - daily gringing capacity will increase to 1 million mt/day, up from 0.9 million mt/dat.
Australia
* | Industry continues its recovery from severe weather events of last few years.
* | 2012/13 season - more land is being returned to sugarcane production, forecast at 380,000 hectares.
* | Sugar production is forecast at 4.5 million MTRV, up 15% over 2011/12.
* | Exports forecast at 3.0 million MTRV, up 200,000 MTRV over 2011/12.
Guatemala
* | Sugarcane area up 2,000 hectares to 247,000 hectares, and yield is projected at 90 mt/hectares, better than in recent years.
* | Sugar production for 2012/13 projected at 2.474 million mt, a record if realized.
* | Exports forecast at 1.725 million mt, about 43% of which is expected to be refined sugar.
Colombia
* | Expansion of ethanol production affects sugar export potential - forecast at 890,000 MTRV in 2012/13.
* | Sugarcane area contained within Cauca River Valley -- 215,000 hectares. Production expansion
 | dependent on yield increases. About 18% of sugarcane crop is used for ethanol production.
South Africa
* | Seasonal rainfall has aided recovery from 2 years of drought in Kwa Zulu - Natal province, where 75% of cane is grown.
* | Sugar production projected at 2.2 million MTRV (up 15%) and exports at 600,000 MTRV (up 80%).
MTRV = [NAME], raw value.
Source: USDA, FAS, Global Agricultural Information Network, Sugar Annuals.
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T74

الجدول 74: أسباب الوفيات المسجلة في الإمارات العربية المتحدة
Table 74: Registered deaths by cause in United Arab Emirates
الإمارات العربية المتحدة | 2000 |  |  | 2005 |  |  | آخر سنة متوفرة
UNITED ARAB EMIRATES |  |  |  |  |  |  | latest available
سبب الوفاة (1) | مجموع | ذكور | اناث | مجموع | ذكور | اناث | مجموع | ذكور | اناث
Cause of death (1) | Total | Male | Female | Total | Male | Female | Total | Male | Female
1 | 41 | 25 | 16 | ... | ... | ... | ... | ... | ...
2 | 468 | 268 | 200 | ... | ... | ... | ... | ... | ...
3 | 158 | 86 | 72 | ... | ... | ... | ... | ... | ...
4 | 121 | 71 | 50 | ... | ... | ... | ... | ... | ...
5 | 4 | 3 | 1 | ... | ... | ... | ... | ... | ...
6 | 33 | 15 | 18 | ... | ... | ... | ... | ... | ...
7 | 1383 | 1000 | 383 | ... | ... | ... | ... | ... | ...
8 | 189 | 119 | 70 | ... | ... | ... | ... | ... | ...
9 | 111 | 85 | 26 | ... | ... | ... | ... | ... | ...
10 | 152 | 89 | 63 | ... | ... | ... | ... | ... | ...
11 | 1 | - | 1 | ... | ... | ... | ... | ... | ...
12 | - | - | - | ... | ... | ... | ... | ... | ...
13 | - | - | - | ... | ... | ... | ... | ... | ...
14 | 260 | 146 | 114 | ... | ... | ... | ... | ... | ...
15 | 133 | 76 | 57 | ... | ... | ... | ... | ... | ...
16 | 981 | 713 | 268 | ... | ... | ... | ... | ... | ...
17 | 809 | 709 | 100 | ... | ... | ... | ... | ... | ...
18 | 552 | 511 | 41 | ... | ... | ... | ... | ... | ...
المجموع                    Total | 7396 | 3916 | 1480 | … | … | … | … | … | …
(1) Causes of death given in annex 1 |  |  |  |  |  |  |  |  | (1) اسباب الوفيات في الملحق رقم 1
Spreadsheet: 149583d1334031115-how-to-match-data-by-dates-in-the-same-sheet-and-split-into-columns-test
Sheet: Current

 | Current data format:
 |  | Date | Company | Value
 |  | 1989-01-01 00:00:00 | x | 1.2
 |  | 1989-01-02 00:00:00 | x | 2.3
 |  | 1989-01-03 00:00:00 | x | 0
 |  | 1989-01-01 00:00:00 | y | 0.98
 |  | 1989-01-02 00:00:00 | y | 1.23
 |  | 1989-01-03 00:00:00 | y | 7
 |  | 1989-01-01 00:00:00 | z | n/a
 |  | 1989-01-02 00:00:00 | z | 22
 |  | 1989-01-03 00:00:00 | z | 2.0009
Spreadsheet: 550550d1512418149-very-basic-how-to-display-call-log-data-starting-with-time-of-calls-exportmessagesexample
Sheet: ExportMessages

Call Identifier | Date | Start Time | Ring Time | Hold Time | Total Call Minutes | Billing Code | Call Type (originated internal/external) | Originating Trunk | Originating Slot/Port | Calling Party Name | Calling Party Number | Destination Slot/Port | Destination Trunk | Answering Number | Call (finish) Indicator | Dialed Number | Call Status | SMDR Version | Message
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474948     12/01/2017 00:36:25 00:00 00:00:00 0:00:00:16 0    E T03 01/01 KING KONG       [PHONE]      00/01 T02             vm-1054         Y 1054            F  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474948     12/01/2017 00:36:26 00:24 00:00:00 0:00:00:00 0    E T03 01/01 KING KONG       [PHONE]      00/00 T02             1054            N 1054            N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474950     12/01/2017 06:57:37 00:00 00:00:00 0:00:00:24 0    E T03 01/01                 [PHONE]      00/01 T02             1330            Y 1330            N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474951     12/01/2017 07:05:35 00:02 00:00:00 0:00:10:00 0    I T02 00/01 Randomne, Noone 1063            01/01 T03             [PHONE]     Y [PHONE]     N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474952     12/01/2017 07:19:09 00:00 00:00:00 0:00:00:12 0    E T03 01/01                 [PHONE]      00/01 T02             1330            Y 1330            N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474953     12/01/2017 07:22:14 00:00 00:00:00 0:00:01:12 0    I T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             vm-1061         Y 1061            F  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474953     12/01/2017 07:22:15 00:24 00:00:00 0:00:00:00 0    I T03 01/01 WIRELESS CALLER [PHONE]      00/00 T02             1061            N 1061            F  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474953     12/01/2017 07:21:07 00:00 00:00:00 0:00:00:44 0    E T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             1330            N 1330            N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474956     12/01/2017 07:26:53 00:09 [NAME] 0:00:06:59 0    I T02 00/01 Names, Redacted 1083            01/01 T03             7719122         Y 7719122         N  v2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474957     12/01/2017 07:28:50 00:13 00:00:00 0:00:01:29 0    I T02 00/01 Callers, Name   1026            01/01 T03             [PHONE]     Y [PHONE]     N  v2
Spreadsheet: 99125d1297867446-sort-data-into-different-coloums-data999
Sheet: Sheet1

 |  |  |  |  |  |  |  | need coloums D,E,F,G to list as they are set her, listing only the numbers in order from top to bottom
Name | Score |  | [NAME] | Lindsey | Ian | [NAME]
Lindsey | 5 | 1Lindsey | 3 | 5 | 4 | 0
[NAME] | 3 | 1Chris | 4 | 2 | 4 | 3
[NAME] | 0 | 1Noel | 1 | 0 |  | 2
Ian | 4 | 1Ian | 5 |  |  | 4
Lindsey
[NAME] | 4 | 2Chris
[NAME] | 3 | 2Noel
Ian
Lindsey | 2 | 2Lindsey
[NAME] | 1 | 3Chris |  |  |  |  |  |  |  |  |  | 0
[NAME] | 2 | 3Noel |  |  |  |  |  |  |  |  | [NAME] | 1
Ian | 4 | 2Ian |  |  |  |  |  |  |  |  | Lindsey | 2
Lindsey | 0 | 3Lindsey |  |  |  |  |  |  |  |  | Ian | 3
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 5
Ian |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] | 4 | 4Noel |  |  |  |  |  |  |  |  |  | 7
Ian |  |  |  |  |  |  |  |  |  |  |  | 8
Lindsey |  |  |  |  |  |  |  |  |  |  |  | 9
[NAME] | 5 | 4Chris |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 841521d1693704388-using-dynamic-filter-for-top-x-values-and-sort-by-month-dynamic-array
Sheet: Sheet1

Raw Data:
Expense Category | January | February | March | April | May | June | July | August | September | October | November | December | Total
Academic | 0 | 71.93 | 52.3 | 28.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 152.44
Automobile | 0 | 0 | 36.51 | 69.15 | 132.02 | 0 | 178.14 | 86.75 | 0 | 0 | 0 | 0 | 502.57
Cellphone | 0 | 0 | 0 | 0 | 79.55 | 0 | 0 | 40.87 | 0 | 0 | 0 | 0 | 120.42
Clothing | 0 | 0 | 0 | 86.89000000000001 | 70.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 157.04
Fitness | 32.77 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 32.77 | 11.3 | 0 | 0 | 0 | 0 | 133.34
Groceries | 135.01 | 31.56 | 28.22 | 51.48 | 32.36 | 0 | 0 | 8.48 | 0 | 0 | 0 | 0 | 287.11
Health and dental | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Miscellaneous | 0 | 5.64 | 37.83 | 33.75 | 67.72 | 18.48 | 83.5 | 210.12 | 0 | 0 | 0 | 0 | 457.04
Personal care | 47.23 | 30 | 30 | 33.9 | 0 | 62 | 0 | 65 | 0 | 0 | 0 | 0 | 268.13
Public transit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Restaurant | 102.35 | 100.98 | 109.13 | 261.93 | 248.36 | 165.41 | 529.28 | 289.92 | 0 | 0 | 0 | 0 | 1807.36
Technology | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travel | 466.2799999999999 | 60 | 44.98 | 0 | 0 | 2993.090000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 3564.35
Total | 783.6399999999999 | 339.41 | 350.27 | 576.61 | 641.46 | 3250.280000000001 | 823.6899999999999 | 712.4399999999999 | 0 | 0 | 0 | 0 | 7477.800000000001
Month
August
Desired Result:
Expense Category
Restaurant | 289.92 |  |  |  |  |  | 289.92
Miscellaneous | 210.12 |  |  |  |  | Miscellaneous | 210.12
Automobile | 86.75 |  |  |  |  | Automobile | 86.75
Spreadsheet: 40252d1238563566-populate-asyncronous-data-sample
Sheet: Sheet1

Problem: | Populate the appropriate cell in the range below with the course number (matching date/name) from the data on sheet 2
 | e.g. as per cell H5
 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00 | 2009-05-04 00:00:00 | 2009-05-05 00:00:00 | 2009-05-06 00:00:00 | 2009-05-07 00:00:00 | 2009-05-08 00:00:00 | 2009-05-09 00:00:00 | 2009-05-10 00:00:00 | 2009-05-11 00:00:00 | 2009-05-12 00:00:00 | 2009-05-13 00:00:00 | 2009-05-14 00:00:00 | 2009-05-15 00:00:00 | 2009-05-16 00:00:00 | 2009-05-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00 | 2009-05-25 00:00:00 | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-29 00:00:00 | 2009-05-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-03 00:00:00 | 2009-06-04 00:00:00 | 2009-06-05 00:00:00 | 2009-06-06 00:00:00 | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00 | 2009-06-14 00:00:00 | 2009-06-15 00:00:00 | 2009-06-16 00:00:00 | 2009-06-17 00:00:00 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 2009-06-20 00:00:00 | 2009-06-21 00:00:00 | 2009-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-24 00:00:00 | 2009-06-25 00:00:00 | 2009-06-26 00:00:00 | 2009-06-27 00:00:00 | 2009-06-28 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 2009-07-03 00:00:00 | 2009-07-04 00:00:00 | 2009-07-05 00:00:00 | 2009-07-06 00:00:00 | 2009-07-07 00:00:00 | 2009-07-08 00:00:00 | 2009-07-09 00:00:00 | 2009-07-10 00:00:00 | 2009-07-11 00:00:00 | 2009-07-12 00:00:00 | 2009-07-13 00:00:00 | 2009-07-14 00:00:00 | 2009-07-15 00:00:00 | 2009-07-16 00:00:00 | 2009-07-17 00:00:00 | 2009-07-18 00:00:00 | 2009-07-19 00:00:00 | 2009-07-20 00:00:00 | 2009-07-21 00:00:00 | 2009-07-22 00:00:00 | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 2009-07-25 00:00:00 | 2009-07-26 00:00:00 | 2009-07-27 00:00:00 | 2009-07-28 00:00:00 | 2009-07-29 00:00:00 | 2009-07-30 00:00:00
[NAME] |  |  |  |  |  |  | 1
[NAME]
[NAME]
[NAME]
Rolf
[NAME]
[NAME]
Spreadsheet: 045b7b5f-288c-44a9-97ee-c6aa9b709e21
Sheet: Sheet1

[NAME] | Shenzhen Riitek Technology Co.,LTD | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | 4/F, Block A1, Area A, Baoyunda Logistic Center, Baoan District, Shenzhen, China
 | Tel: 86-755-61191688，Fax: 0755-61586009-601
 | Web: www.riitek.com
Model NO. |  | RT-MWK24 /i 24(RT-MWK24T / i24A with audio features)
Brand |  | Rii
Product details（参数描述）
Receiver(dongle) |  | [NAME] style
Connect port |  | With USB2.0 above
Processor(MCU) |  | Sonix
Transmit mode |  | RF 2.4GHz wireless, up to 10 meters
Transmit Power |  | Less than +5db
Power  supply |  | Rechargeable 450mAh polymer Lithium-ion battery
Charging voltage |  | 4.4V ~ 5.25V
Charging current |  | 300mA
Sleeping Current class1 |  | 50uA
Operation Voltage |  | 3.7V
Operating Current |  | <70mA
Product weight |  | 100g
Product Size |  | 200mm*58mm*19mm
Color |  | Black,white
Accessories（配件清单）
USB cable for charging |  | 1pcs |  |  | Yes
Nano dongle |  | 1pcs |  |  | Yes
User manual |  | 1pcs |  |  | Yes
Packing（装箱资料）
Unit packing Size |  | 210mm*90mm*25mm |  |  | Yes
Unit packing Weight |  | 150g |  |  | Yes
Unit/Carton |  | 50pcs |  |  | Yes
Unit [NAME] |  | xxxxxx |  |  | Yes
Weight/Carton |  | xxxKG
Product descriptor(特色功能)
Wireless keyboard with 83 keys
Air mouse function with 6-axis
Windows multimedia control keys (GOOGLE TV hotkey)
Wireless audio and online voice dialogue（Optional）
Product Picture（产品图片）
Giftbox（包装图片）
MOQ, Price, Delivery（起订量，价格，交期）
MOQ |  | 1000PCS
Prices |  | 12.3USD
Lowest Retail Price:
Delivery |  | 20 working days after receipt of 30% deposit
Remark
Spreadsheet: 47206d1246135235-hope-someone-can-help-tryexcel
Sheet: Sheet1

Code | Cle.Room | [NAME] | Landry | LG Tub | Shower | Sm tub | SW 1 | SW2 | Sweep hall | Toilet
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Code | Garabe | Mop hall | Sink
3 | 1 | 2 | 3
 | name | code | Job  they get
 | [NAME] | 2
 | JF | 3
 | [NAME] | 2
 | Scott | 3
 | [NAME] | 2
 | [NAME] | 2
 | Mickayla | 2
 | [NAME] | 2
 | Seva | 2
 | Curtis | 1
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 3
Spreadsheet: 839834d1692261600-count-how-many-times-a-number-appears-example-sheet
Sheet: Sheet2

Ref Number | Cust Name | [NAME] | Total Calls | Total Duration
9807801 | Customer A | 441902531231
9807802 | Customer B | 441902531232
9807803 | Customer C | 441902531233
9807804 | Customer D | 441902531234
9807805 | Customer E | 441902531235
9807806 | Customer F | 441902531236
9807807 | Customer G | 441902531237
9807808 | Customer H | 441902531238