tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 240115d1370208663-scan-a-row-for-text-return-row-and-column-header-info-rooms2
Sheet: Sheet2

 | Original
 |  | 2013-05-01 00:00:00 | 2013-05-02 00:00:00 | 2013-05-03 00:00:00 | 2013-05-04 00:00:00 | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
 | [NAME] | Room A |  |  | Room B | Room D
 | [NAME] |  | Room C |  | Room A |  | Room E
 | George | Room B |  |  |  | Auditorm
 | New - What I need
 |  | Room A | [NAME] | 2013-05-01 00:00:00 |  |  | Transpose -- I found "MakeCrossTabsATable" in another thread in this forum.
 |  | Room B | [NAME] | 2013-05-04 00:00:00 |  |  |  | It does pretty well (see sheet 1 where I ran that macro)
 |  | Room D | [NAME] | 2013-05-05 00:00:00 |  |  |  | -- Though I'd like it more if it ignored null string cells
 |  | Room C | [NAME] | 2013-05-02 00:00:00
 |  | Room A | [NAME] | 2013-05-04 00:00:00
 |  | Room E | [NAME] | 2013-05-06 00:00:00
 |  | Room B | George | 2013-05-01 00:00:00
 |  | Auditorm | George | 2013-05-05 00:00:00
 | Ideal!!  -- Complete solution |  |  |  |  |  | Still looking for this…
 |  | Room A | [NAME] | 2013-05-01 00:00:00 | 2013-05-03 00:00:00 |  |  | Detect "end date" based on cell fill color change
 |  | Room B | [NAME] | 2013-05-04 00:00:00
 |  | Room D | [NAME] | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
 |  | Room C | [NAME] | 2013-05-02 00:00:00
 |  | Room A | [NAME] | 2013-05-04 00:00:00 | 2013-05-05 00:00:00
 |  | Room E | [NAME] | 2013-05-06 00:00:00
 |  | Room B | George | 2013-05-01 00:00:00 | 2013-05-03 00:00:00
 |  | Auditorm | George | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
Spreadsheet: phillip_allen__28928__MAPTTRA
Sheet: Mtg.

Subject - Eagle Sagewood Phase II
 |  |  | Bank's |  |  | Borrower's
Unit Type | Units | Unit [NAME] | Unit Rent | Rent | Rent/BR | Unit Rent | Rent | Rent/BR
2 BR/2.5 BA | 73 | 1016 | 950 |  |  | 1150
3 BR/3.5 BA | 61 | 1213 | 1250 |  |  | 1530
TOTAL
Existing Project
 |  |  | Bank's |  |  | Borrower's
Unit Type | Units | Unit [NAME] | Unit Rent | Rent | Rent/BR | Unit Rent | Rent | Rent/BR
3 BR/3.5 BA | 28 | 1310 | 1250 |  |  | 1250
TOTAL
Spreadsheet: 837785d1690440214-drop-down-chooses-defined-list-master-doctors
Sheet: Data

 | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | Task 6
Blank
Annual leave |  |  | Annual Leave
Doesn't Work | x | x | x | x | x | x
Early Access | Surgery 07:00 - 09:00 | Weekend Washup 09:00 - 10:00 | Visit Master 12:00 - 13:00 | Passed on List 13:00 - 13:30 | Telephone Surgery 15:00 - 15:20
Late Access | Surgery 10:00 - 12:00 | Surgery 15:00 - 16:00 | Telephone Surgery 16:00 - 16:20 | Surgery 18:00 - 18:30
Monday Duty | Surgery 09:00 - 11:30 | Partners Meeting 13:00 - 15:00 |  | Duty Surgery + E/Visits 15:00 - 18:30
Tuesday Duty | [NAME] | [NAME] 11:00 - 11:30 | Visit Master 12:00 - 13:00 | Telephone Surgery 14:30 - 14:50 | Duty Surgery + E/Visits 15:00 - 18:30
Castle Village with Duty | Castle Village 09:00 - 11:00 | VM to another GP | Telephone Surgery 14:30 - 14:50 | Duty Surgery + E/Visits 15:00 - 18:30
Duty | Surgery 09:00 - 11:30 | Visit master 12:00 - 13:00 | Telephone Surgery 14:30 - 14:50 | Duty Surgery + E/Visits 15:00 - 18:30
Saturday | Surgery 08:00 - 10:40
Castle Village | Castle Village 09:00 - 11:00 |  | Telephone Surgery 14:30 - 14:50 | Surgery 15:00 - 17:00
Castle Village with Duty | Castle Village 09:00 - 11:00 | VM to another GP | Telephone Surgery 14:30 - 14:50 | Duty Surgery + E/Visits 15:00 - 18:30
Normal Day | Surgery 09:00 - 11:30 |  | Telephone Surgery 14:30 - 14:50 | Surgery 15:00 - 17:00
Normal Monday | Surgery 09:00 - 11:30 | Partners Meeting 13:00 - 15:00 |  | Surgery 15:00 - 17:00
Normal Tuesday | [NAME] | [NAME] 11:00 - 11:30 | Telephone Surgery 14:30 - 14:50 | Surgery 15:00 - 17:00
RIW Tuesday | Surgery with Medical 08:30 - 10:40 |  | [NAME] 11:00 - 11:30 | Telephone Surgery 14:30 - 14:50 | Surgery 15:00 - 17:00
RIW Tuesday Duty | Medical 08:30 - 09:00 | Surgery 09:00 - 10:40 | [NAME] 11:00 - 11:30 | Telephone Surgery 14:30 - 14:50 | Duty Surgery + E/Visits 15:00 - 18:30
Hem Tuesday | Surgery With 2 Coils 08:30 - 10:40 | [NAME] 11:00 - 11:30 | Telephone Surgery 14:30 - 14:50 | Surgery 15:00 - 17:00
[NAME] Wednesday | Surgery 09:00 - 11:30 |  | CHS/GEN 14:00 - 16:00
SLB Tuesday | [NAME] | [NAME] 11:00 - 11:30 | PMA / Smears 14:30 - 14:50 | Surgery 15:00 - 17:00
SLB Wednesday | Castle Village |  | Surgery 14:00 - 16:30
SLB Wednesday Duty | Castle Village | VM | Surgery [NAME]
GMS | Surgery 09:00 - 11:30
Friday | Surgery 09:00 - 11:30 |  | Surgery 1400-1600
Hilary AM | Surgery 08:00 - 10:40
Hilary PM |  |  |  | Surgery 14:00 - 16:30
Hilary AM + PM | Surgery 08:00 - 10:40 |  |  | Surgery 14:00 - 16:30
Bank Holiday |  |  | Bank Holiday
Physio |  | Surgery 0900-1300
Study Leave |  |  | Study Leave
StandDown |  |  | StandDown
Session 42
Session 43
Session 44
Session 45
Session 46
Session 47
Manual Entry | Castle Village 09:00 - 11:00 | Visit Master 12:00 - 13:00 | LMC Meeting 13:00 - 17:00 | Surgery 17:10 - 17:20 | Evening Vists 18:00 - 18:30
Spreadsheet: 700702d1603296446-sort-a-range-of-data-by-date-and-hour-two-columns-if-there-are-duplicate-entries-sample-2-
Sheet: SEE HERE

DATE | HOUR | COURSES | R-1 | R-2 |  |  | DATE | HOUR | COURSES | R-1 | R-2
2020-10-26 00:00:00 | 13:30:00 | [NAME] | 9C | 10C
2020-11-02 00:00:00 | 13:30:00 | Fizik | 11C | 9C
2020-11-09 00:00:00 | 13:30:00 | [NAME] | 10C | 9C
2020-10-23 00:00:00 | 12:00:00 | Felsefe | 12A | 12A
2020-10-26 00:00:00 | 12:00:00 | [NAME] | 12A | 11A
2020-10-27 00:00:00 | 12:00:00 | İngilizce | 10B | 10B
2020-10-30 00:00:00 | 12:00:00 | Kimya |  | Yedek
2020-11-02 00:00:00 | 12:00:00 | Fizik |  | Yedek
2020-11-03 00:00:00 | 12:00:00 | Tarih | 10B | 10B
2020-11-05 00:00:00 | 12:00:00 | Almanca |  | Yedek
2020-11-06 00:00:00 | 12:00:00 | [NAME] |  | Yedek
2020-11-09 00:00:00 | 12:00:00 | [NAME] |  | Yedek
2020-10-22 00:00:00 | 10:30:00 | [NAME] | 11G | 12G
2020-10-28 00:00:00 | 09:00:00 | Seç. [NAME] | 11B | 12B
2020-11-03 00:00:00 | 12:00:00 | [NAME] | 12B | 11G
2020-11-05 00:00:00 | 10:30:00 | Almanca | 11G | 11G
2020-11-09 00:00:00 | 10:30:00 | [NAME] | 10A | 10A
Spreadsheet: 149311d1333834621-count-the-number-of-projects-completed-within-a-1-week-period-sample
Sheet: Sheet1

 | A |  |  |  | B |  | C
Project Log |  |  |  | Weekly Cumulative Projects Completed
Project | Baseline | Completion |  | Week Start Date | Week End Date | #[NAME] | [NAME]
1 | 2012-03-20 00:00:00 | 2012-04-10 00:00:00 |  | 2012-04-02 00:00:00 | 2012-04-06 00:00:00 | 1
2 | 2012-03-20 00:00:00 | 2012-04-03 00:00:00 |  | 2012-04-09 00:00:00 | 2012-04-13 00:00:00 | 2
3 | 2012-04-02 00:00:00 | 2012-04-11 00:00:00 |  | 2012-04-16 00:00:00 | 2012-04-20 00:00:00 | 0
4 | 2012-04-06 00:00:00 | 2012-04-24 00:00:00 |  | 2012-04-23 00:00:00 | 2012-04-27 00:00:00 | 2
5 | 2012-04-18 00:00:00 | 2012-04-26 00:00:00 |  | 2012-04-30 00:00:00 | 2012-05-04 00:00:00 | 0
6 | 2012-05-14 00:00:00 | 2012-05-18 00:00:00 |  | 2012-05-07 00:00:00 | 2012-05-11 00:00:00 | 1
7 | 2012-05-29 00:00:00 | 2012-06-07 00:00:00 |  | 2012-05-14 00:00:00 | 2012-05-18 00:00:00 | 2
8 | 2012-05-08 00:00:00 | 2012-05-15 00:00:00 |  | 2012-05-21 00:00:00 | 2012-05-25 00:00:00 | 0
9 | 2012-05-11 00:00:00 | 2012-05-11 00:00:00 |  | 2012-05-28 00:00:00 | 2012-06-01 00:00:00 | 0
10 | 2012-06-06 00:00:00 | 2012-06-08 00:00:00 |  | 2012-06-04 00:00:00 | 2012-06-08 00:00:00 | 2
Spreadsheet: lynn_blair__24318__Nov01pnr
Sheet: Astra 500622

 | [NAME]
 | INVOICE DETAIL - October, 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | Astra Power | 27502 | 2001-10-01 00:00:00 | 500622 | PnR |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
2 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
3 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
4 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
5 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
6 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
7 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
8 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
9 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
10 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
11 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
12 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
13 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
14 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  | SYSTEM GENERATED INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 119730d1314705221-checking-for-consecutive-values-book1
Sheet: Sheet1

 | meeting ID | Full name | presence | absence | תאריך ישיבה | quarter | year | company name
 | 1 | person 1 | 0 | 1 | 31/08/2011 | Q3 | 2011 | exsemple
 | 1 | person 2 | 1 | 0 | 31/08/2011 | Q3 | 2011 | exsemple
 | 1 | person 3 | 1 | 0 | 31/08/2011 | Q3 | 2011 | exsemple
 | 1 | person 4 | 1 | 0 | 31/08/2011 | Q3 | 2011 | exsemple
 | 2 | person 1 | 0 | 1 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple
 | 2 | person2 | 1 | 0 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple
 | 2 | person 3 | 1 | 0 | 01/09/2011 | Q3 | 2011 | exsemple
 | 3 | person 1 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple
 | 3 | person 2 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple
Spreadsheet: 798899d1664803769-amalgamating-and-deleting-rows-gk-special-assistance-final
Sheet: Interim

 |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments | Event Time
2
3
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
Spreadsheet: 688067d1595553633-having-something-happen-randomly-a-given-percentage-of-the-time-probability-sample
Sheet: Sheet1

 | 1 | 2
 | 0.4 | 0.6
1
Spreadsheet: 144602d1331054342-conditional-formatting-based-on-other-arrays-example
Sheet: Before

Irrelevant | Irrelevant | COPY | Irrelevant | Irrelevant | COPY | Irrelevant | Irrelevant | COPY | Irrelevant | COPY (K) | COPY (L) | Irrelevant | Irrelevant | COPY (O) | COPY (P)
1 | 10 | 10 | 1 | 8 | 7 | 3 | 1 | 3 | 10 | 4 | 10 | 10 | 8 | 7 | 7
1 | 10 | 7 | 3 | 5 | 10 | 7 | 9 | 7 | 1 | 8 | 8 | 6 | 6 | 4 | 9
5 | 8 | 1 | 5 | 7 | 7 | 2 | 10 | 1 | 7 | 10 | 7 | 4 | 9 | 9 | 8
8 | 9 | 6 | 7 | 7 | 3 | 6 | 2 | 9 | 4 | 4 | 8 | 6 | 8 | 4 | 1
2 | 8 | 1 | 10 | 8 | 8 | 6 | 3 | 4 | 3 | 6 | 7 | 6 | 2 | 1 | 6
6 | 10 | 8 | 2 | 6 | 8 | 5 | 4 | 1 | 5 | 2 | 5 | 2 | 7 | 5 | 4
Spreadsheet: 9938b260-854a-4208-8f2e-1805c332ff6a
Sheet: Sheet1

Table 3--Cash feed grain prices, 3/12/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn, No. 2 yellow,  Central IL (dollars per bushel) |  |  | Corn, No. 2 yellow,  Gulf ports, LA  (dollars per bushel) |  |  | Sorghum, No. 2 yellow,  Plainview to [NAME], TX  (dollars per cwt) | Sorghum, No. 2 yellow,  Gulf ports, LA  (dollars per cwt)
 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2011/12 | 2012/13 | 2013/14
Sep | 6.77 | 7.7 | 4.78 | 7.5 | 8.145 | 5.27 | 11.48 | 12.88 | 12.965 | 9.84
Oct | 6.23 | 7.48 | 4.2 | 6.975 | 8.155000000000001 | 5.125 | 10.73 | 12.08 | 13.2 | 9.31
Nov | 6.26 | 7.39 | 4.1 | 6.97 | 8.175 | 5.06 | 10.96 | 12.44 | 13.095 | 8.855
Dec | 5.96 | 7.23 | 4.13 | 6.57 | 7.845 | 5.06 | 10.5 | 11.82 | 13.14 | 9.34
Jan | 6.25 | 7.17 | 4.13 | 6.935 | 7.699999999999999 | 5.015000000000001 |  | 12.2 | 13.13 | 9.77
Feb | 6.41 | 7.15 | 4.33 | 7.1 | 7.695 | 5.32 |  | 12.09 | 13.115 | 10.16
Mar | 6.46 | 7.33 |  | 7.13 | 7.85 |  |  | 12.035 | 13.32
Apr | 6.34 | 6.57 |  | 6.96 | 7.11 |  |  | 11.94 | 12.175
May | 6.27 | 6.83 |  | 6.84 | 7.5025 |  |  |  | 12.415
Jun | 6.3 | 6.94 |  | 6.785 | 7.58
Jul | 7.85 | 6.61 |  | 8.455 | 7.1
Aug | 8.15 | 5.98 |  | 8.435 | 6.065 |  |  | 13.47 | 10.01
Mkt year | 6.604166666666665 | 7.031666666666666 |  | 7.22125 | 7.576874999999998 |  | 10.9175 | 12.32833333333333 | 12.6565
 | Barley, No. 2 feed,  Minneapolis, MN  (dollars per bushel) |  |  | Barley, No. 3 malting,  Minneapolis, MN  (dollars per bushel) |  |  | Oats, No. 2 white heavy,  Minneapolis, MN  (dollars per bushel)
 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14
Jun | 5.06 | 5.15 | 5.01 | 7.395 | 7.03 | 6.88 | 3.675 | 3.365 | 4.21
Jul | 5.18 | 5.52 | 4.66 | 7.72 | 6.89 | 6.79 | 3.68 | 3.95 | 3.835
Aug | 5.25 | 5.78 | 4.03 | 7.83 | 6.95 | 5.88 | 3.69 | 3.985 | 3.775
Sep | 5.14 | 5.58 | 3.48 | 7.76 | 6.99 | 5.41 | 3.72 | 3.885 | 3.4
Oct | 5.16 | 5.51 | 3.39 | 7.64 | 7.11 | 5.5 | 3.51 | 3.98 | 3.57
Nov | 5.29 | 5.49 | 3.46 | 7.6 | 7.23 | 5.46 | 3.36 | 3.85 | 3.79
Dec | 5.17 | 5.29 | 3.52 | 7.32 | 7.22 | 5.77 | 3.3 | 3.94 | 3.8
Jan | 5.24 | 5.08 | 3.65 | 7.2 | 7.09 | 5.72 | 3.16 | 3.79 | 4.3
Feb | 5.26 | 5.16 | 3.7 | 7.07 | 7.04 | 5.64 | 3.455 | 4.07 | 4.635
Mar | 5.37 | 5.22 |  | 7.05 | 6.87 |  | 3.475 | 4.26
Apr | 5.18 | 5 |  | 7.03 | 6.51 |  | 3.55 | 4.125
May | 5.21 | 5.04 |  | 7 | 6.7 |  | 3.475 | 3.99
Mkt year | 5.209166666666667 | 5.318333333333333 |  | 7.384583333333333 | 6.969166666666667 |  | 3.504166666666666 | 3.9325
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Simple average of monthly prices for the marketing year. Source: USDA, Agricultural Marketing Service, http://marketnews.usda.gov/portal/lg.
Data run: 3/11/2014
Spreadsheet: kate_symes__18256__DJ Index 4-1 Peak
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-02 00:00:00
Flow Date: | 4/1/01 - Sunday On Peak Only
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 235.3305785123967 | 1936
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
Spreadsheet: 841618d1693812304-index-and-match-function-across-multiple-array-230904-study-plan-grade-3
Sheet: Weekly Plan

ST. MARY’S CATHOLIC HIGH SCHOOL, FUJAIRAH
STUDY PLAN – WEEK No. |  |  | 2
CLASS: GRADE 3                                                                                                      SECTION: A, B, C, D, E
DATE |  | DAY |  | SUBJECT | PORTION
2023-09-03 00:00:00 | Plan | SATURDAY |  | ENGLISH
 |  | SUNDAY |  | ENGLISH
 |  | MONDAY |  | ENGLISH
 |  | TUESDAY |  | ENGLISH
 |  | WEDNESDAY |  | ENGLISH
 |  |  |  | MATH
 |  |  |  | SCIENCE
 |  |  |  | GEOGRAPHY
Spreadsheet: 269505d1381177292-dynamic-file-paths-help-collated-report-2262-vancouver-mall-dr-vancouver-wa-week-35-2013
Sheet: Master Voucher Produce

Master Voucher Produce
Week Ending Date: |  | 09/03/2013
Store Location: |  | 2262 - Vancouver Mall Dr, Vancouver, WA
Store #: |  | 2262
General Manager [NAME]:
Vendor #
Invoice # | 534343 (982795)
Invoice Date | 09/02/2013
Due Date |  | Account
[NAME] | Gatto & Sons Produce | Totals
Description
Produce 4315 | 126.41 | 126.41
[NAME] | 3 | 3
Discounts | 0 | 0
Delivery Charges | 0 | 0
Invoice Totals | 129.41 | 129.41
Spreadsheet: 484373d1476239779-regrouping-an-array-array-transformation2
Sheet: Sheet1

 | Array 1 | -----------> | [NAME] |  | Stdev1 | Stdev3
 | 1
 | 2 | ----------->
 | 4
 | 2
 | 5 | ----------->
 | 7
 | 1
 | 6 | ----------->
 | 1
 | 1
 | 3 | ----------->
 | 1
Spreadsheet: 683578d1592833875-a-result-given-two-cell-conditions-query
Sheet: drop down boxes

 |  | 25 | 37 | 49 | <WINDOW WIDTH>
<vent ht> | 12 | 1010 | 1020
 | 15 |  | 1320
 | 18 |  | 1620 | 1630
 | 20 |  | 1820
 | 23
 | 24
 | 29
EXAMPLE | VENT HEIGHT |  | 20
 | [NAME] |  | 36
 | RESULT |  |  | < would like this result to be "1820"
Spreadsheet: 94380d1294224338-sorting-dates-monthwise-and-getting-unique-values-multilookup-sort
Sheet: Rishi K

Sr.No | Age At Entry | UNIQUE DATES | Commencement Month No | POLICY NO | Date of  Comm | T-T | [NAME] | Premium | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED | NOMINEE | ACTUAL PREMIUM | ACTUAL SUM ASSURED | Current Pay-By Date | Payment Date | GRACE DATE | Policy Maturity Date | [NAME] | ChqDate | Desired Order
1 | 30 | 1 | 1 | 791787833 | 2003-01-14 00:00:00 | 48-25 |  |  | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000 |  |  |  | 2011-01-14 00:00:00 |  |  |  |  | 2011-01-01 00:00:00 | 2011-01-01 00:00:00
2 | 31 | 2 | 6 | 792383786 | 2004-06-28 00:00:00 | 14-30 |  |  | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  | 2011-06-01 00:00:00 | 2011-02-01 00:00:00
3 | 31 |  | 6 | 792383787 | 2004-06-28 00:00:00 | 14-31 |  |  | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  | 2011-02-01 00:00:00 | 2011-06-01 00:00:00
4 | 31 |  | 6 | 792383788 | 2004-06-28 00:00:00 | 14-32 |  |  | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  | 2011-07-01 00:00:00 | 2011-07-01 00:00:00
5 | 32 | 3 | 2 | 792997163 | 2005-02-15 00:00:00 | 169-22 |  |  | [NAME] | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000 |  |  |  | 2011-02-15 00:00:00
6 | 32 |  | 2 | 792969818 | 2005-02-15 00:00:00 | 173-70 |  |  | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000 |  |  |  | 2011-02-15 00:00:00
7 | 32 |  | 2 | 792969819 | 2005-02-15 00:00:00 | 172-21 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-02-15 00:00:00
8 | 32 |  | 2 | 792969820 | 2005-02-15 00:00:00 | 172-22 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-02-15 00:00:00
9 | 32 | 4 | 7 | 792969821 | 2005-07-20 00:00:00 | 172-23 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-07-20 00:00:00
10 | 32 |  | 7 | 792969822 | 2005-07-20 00:00:00 | 172-24 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-07-20 00:00:00
11 | 33 |  | 6 | 792969823 | 2006-06-21 00:00:00 | 172-25 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-06-21 00:00:00
12 | 33 |  | 6 | 792969824 | 2006-06-21 00:00:00 | 172-26 |  |  | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-06-21 00:00:00
13 | 33 |  |  | 792969825 | 2006-08-21 00:00:00 | 14-32 |  |  | SGL | ENBOWMENT  WITH BONUS | Insurance | 50000 |  |  |  | 2011-08-21 00:00:00
14 | 35 |  |  | 792969826 | 2008-06-27 00:00:00 | 14-32 |  |  | ECS | ENBOWMENT  WITH BONUS | Insurance | 50000 |  |  |  | 2011-06-27 00:00:00
Spreadsheet: 733612d1621660433-countif-help-count_sample
Sheet: Sheet1

Account # | Name | Snack Preference
275846 | [NAME] | Walnuts
536897 | [NAME] | Peanuts
3587941 | Pam | Cashews
23 | [NAME] | Peanuts
897432 | [NAME] | Macadamias
563478 | [NAME] | Peanuts
698743 | Hank | Pecans
689 | [NAME] | Walnuts
789356 | [NAME] | Filberts
4555879 | [NAME] | Macadamias
698123 | [NAME] | Cashews
Spreadsheet: 757376d1638219107-cell-value-from-multiple-sheets-to-be-presented-in-master-sheet-pt2-new-microsoft-excel-worksheet-2-
Sheet: E02122021

Country | A
Poland | Francesco
U.K. | [NAME]
Italy | [NAME]
France | [NAME]
Germany | [NAME]
Greece | Ire
Spain | Martin
Russia | [NAME]
Malta | [NAME]
Austria | [NAME]
Spreadsheet: 544415d1508888700-find-and-replace-first-non-zero-value-in-a-range-book_1_to_0
Sheet: Sheet1

1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999
1 | 0 | 0 | 0 | 1 | 1 | 1 | 1
1 | 0 | 0 | 1 | 1 | 0 | 1 | 0
0 | 0 | 1 | 0 | 0 | 1 | 1 | 0
0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
0 | 0 | 0 | 0 | 0 | 1 | 0 | 1
0 | 0 | 0 | 0 | 0 | 1 | 0 | 1
Spreadsheet: 159895d1338893269-vlookup-on-another-sheet-cerca-2-oeldere3-
Sheet: Foglio2

 |  |  | 2012-05-01 00:00:00 | 3
MATTINA=  MORNING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helpcollomn
ADDETTI | Cod. turno | Turno | Straordinario | FERIE | [NAME] |  |  |  |  | By changing the date in E1, must enter their data in the columns ABF from sheet1 automatically.  The column C, I set myself.  The column D and E do not need  Only formulas thanks for your help
MANUELA | 51 |  |  |  | LORENZO |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0
EVELINA | 34 |  |  |  | GIACOMO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0
SERENA | 35 | 08.00-16.00 |  |  | VALENTINA |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0
GIOVANNI | 30 | 05.30-13.30 |  |  | ANNA |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0
LORENZO | R | Riposo |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
GIACOMO | R | Riposo |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
FRANCESCO | 31 |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
PAOLA | 32 | 06.00-14.00 |  |  |  |  | 530 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
DALILA | 42 |  |  |  |  |  | 532 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
VALENTINA | R | Riposo |  |  |  |  | 539 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R3
ANNA | R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R4
MARIA | 56 | 05.00-13.00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R4
POMERIGGIO= AFTERNOON
ADDETTI | Cod. turno | Turno | Straordinario | MALATTIA
SERENA | 43 | 15.00-23.00 |  |  |  |  | P
GIOVANNI | 42 | 13.30-21.30
PAOLA | 31 | 22.00-06.00 |  |  |  |  | 43
VALENTINA | 51 | 15.30-23.30 |  |  |  |  | 34
ANNA | 34 | 14.00-22.00 |  |  |  |  | 51
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 551
 |  |  |  |  |  |  | 545
 |  |  |  |  |  |  | 544