tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 74186d1274758196-is-it-practical-please-comment-dimensions
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
1
16
17 |  |  |  | 2328
18 |  |  |  |  |  |  |  |  | 3872
19
20
21
22
23
24
25
26
27
28
29
Spreadsheet: 812918d1673452291-12-month-rolling-12-month-rollng
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 12 month rolling total
[NAME] Spend £ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Previous Year Spend £ | 103304.92 | 117316.58 | 152204.99 | 61814.65 | 72545.88 | 73561.20999999999 | 89400.56999999999 | 78818.31 | 76765.70000000001 | 155500.87 | 148766.0600000001 | 122170.17
Spreadsheet: robert_badeer__33100__Calger Collected Graphs 23 June 2000
Sheet: WSCC Data

 | Load | YOY
1997-01-01 00:00:00 | 70.2
1997-02-01 00:00:00 | 68.6
1997-03-01 00:00:00 | 67.1
1997-04-01 00:00:00 | 66
1997-05-01 00:00:00 | 69.9
1997-06-01 00:00:00 | 71.7
1997-07-01 00:00:00 | 76.6
1997-08-01 00:00:00 | 77.5
1997-09-01 00:00:00 | 74.3
1997-10-01 00:00:00 | 67.9
1997-11-01 00:00:00 | 67.2
1997-12-01 00:00:00 | 71.8
1998-01-01 00:00:00 | 70.7
1998-02-01 00:00:00 | 69.7
1998-03-01 00:00:00 | 66.9
1998-04-01 00:00:00 | 66.7
1998-05-01 00:00:00 | 66.3
1998-06-01 00:00:00 | 71.3
1998-07-01 00:00:00 | 81.8
1998-08-01 00:00:00 | 83.3
1998-09-01 00:00:00 | 75.8
1998-10-01 00:00:00 | 68.9
1998-11-01 00:00:00 | 69.4
1998-12-01 00:00:00 | 75.8
1999-01-01 00:00:00 | 72.6
1999-02-01 00:00:00 | 72.8
1999-03-01 00:00:00 | 71
1999-04-01 00:00:00 | 69.2
1999-05-01 00:00:00 | 69.3
1999-06-01 00:00:00 | 74.2
1999-07-01 00:00:00 | 82.3
1999-08-01 00:00:00 | 82.1
1999-09-01 00:00:00 | 76.2
1999-10-01 00:00:00 | 73.9
1999-11-01 00:00:00 | 72.9
1999-12-01 00:00:00 | 77.9
2000-01-01 00:00:00 | 77.4
2000-02-01 00:00:00 | 76.4
2000-03-01 00:00:00 | 74.9
2000-04-01 00:00:00 | 72.3
2000-05-01 00:00:00 | 74.9
2000-06-01 00:00:00 | 79.4
Spreadsheet: 156052d1337164214-extracting-multiple-records-from-one-lookup-value-fz-reporting-16-may-2012
Sheet: Qatar

QATAR
 |  | as of today
Code | Product Description | Balance
EN/MID/M/100/EDT | ENTITY COLLECTIONS MIDNIGHT MEN 100ML EDT | 100
EN/TSK/M/100/EDT | ENTITY COLLECTIONSTUSK MEN 100ML EDT | 100
EN/FGT/M/100/EDT | ENTITY COLLECTIONS FIRE GATE MEN 100ML EDT | 0
EN/GAL/M/100/EDT | ENTITY COLLECTIONS GALLANT MEN 100ML EDT | 0
EN/DLB/M/100/EDT | ENTITY COLLECTIONS DEEPLY BLACK MEN 100ML EDT | 100
EN/EFC/M/100/EDT | ENTITY COLLECTIONS E'FRANCKLY MEN 100ML EDT | 500
EN/DBR/W/100/EDT | ENTITY COLLECTIONS DEBONAIRE WOMEN 100ML EDT | 0
 |  | 800
Spreadsheet: 803758d1667666893-learn-chess-with-excel-how-to-detect-checkmate-learn-chess-with-excel-pw2
Sheet: Moves

1
1 | 5254 | 7775 |  |  |  | e4 | g5
2 | 2133 | 6765 |  |  |  | Nc3 | f5
3 | 4185 |  |  |  |  | Qh5+
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: StriT

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 672802d1587018304-consolidated-absent-dates-absent-date-test
Sheet: Sheet1

File No | EMPLOYEE NAME | 1 | 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
E1 | EMPLOYEE NAME 1 |  |  | H |  |  |  |  |  |  | H |  | A |  |  |  |  | H |  |  |  |  |  | A | H |  |  |  |  |  | A
E2 | EMPLOYEE NAME 2 |  |  | H | A |  |  | A |  |  | H |  |  |  |  |  |  | H |  |  | A |  |  |  | H |  |  | A
Spreadsheet: 3d424564-ae65-4d4c-9f3a-e064e432ca1d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7137 | 9743 | Airi | Sawada | JPN | 0 | 00:39:11 | 00:00:00 | 01:15:23 | 00:00:00 | 00:20:31 | 1 | 02:15:06
7137 | 7915 | Long | Hoi | MAC | 0 | 00:40:00 | 00:00:00 | 01:14:34 | 00:00:00 | 00:22:16 | 2 | [NAME]
Spreadsheet: 196884d1354135219-randomizing-variables-in-lists-book2
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4
6 | 0.55 | I like dogs | 74
17 | 0.42 | I like turtles | 50
8 | 0.62 | I like snakes | 156
20 | 0.52 | I like cats | 127
17 | 0.21 | I like turtles | 58
13 | 0.75 | I like turtles | 45
5 | 0.34 | I like snakes | 125
10 | 0.79 | I like dogs | 73
14 | 0.22 | I like snakes | 141
18 | 0.75 | I like cats | 130
7 | 0.55 | I like cats | 133
18 | 0.57 | I like snakes | 115
20 | 0.55 | I like cats | 114
10 | 0.68 | I like dogs | 36
18 | 0.28 | I like snakes | 141
9 | 0.56 | I like snakes | 152
16 | 0.71 | I like dogs | 72
8 | 0.61 | I like turtles | 56
15 | 0.3 | I like snakes | 117
19 | 0.36 | I like snakes | 112
6 | 0.48 | I like dogs | 76
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: Mar99Notes

Current Month - March 1999
Black Marlin:
1466-011 |  | -8227
1460-011 |  | 1942
Net 0660 - CF
Service Cos:
JO 00001 |  | 2000
Teresa Quarterly Div |  | 3100
A/R from Co. 057 |  | 6300
Balance
Other, net - CF |  | 12338
NNG:
CAPEX - BM |  | -29350
NNG Capital Adds
Capex - CF |  | -36942
Co. 179 |  | 17513
Co. 53K (fair value) |  | 4929
Balance
Other Financing - CF |  | 23942
Spreadsheet: 116417d1311811116-selective-columns-handicapscorecards
Sheet: Course Data

The Courses |  | [NAME]
 |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | IN | OUT | TOTAL | SSS
 |  | [NAME] | Stroke Index | 9 | 5 | 7 | 15 | 3 | 11 | 1 | 17 | 13 | 12 | 6 | 16 | 4 | 10 | 2 | 14 | 18 | 8
 |  | [NAME] | White Yards | 373 | 409 | 347 | 166 | 528 | 355 | 429 | 143 | 305 | 352 | 365 | 309 | 214 | 477 | 420 | 198 | 335 | 362
 |  | Cambridgeshire | Par | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 5 | 4 | 3 | 4 | 4 |  |  |  |  | 72
 |  | [NAME] | [NAME] | 369 | 386 | 337 | 153 | 479 | 353 | 422 | 135 | 293 | 341 | 363 | 283 | 208 | 464 | 412 | 162 | 324 | 350
 |  |  | Par | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 5 | 4 | 3 | 4 | 4 |  |  |  |  | 70
 |  | Parkland | Ladies
 |  |  | Stroke Index | 7 | 11 | 5 | 13 | 1 | 3 | 15 | 17 | 9 | 6 | 4 | 14 | 12 | 2 | 16 | 18 | 10 | 8
 |  |  | Red Yards | 347 | 386 | 285 | 141 | 451 | 351 | 413 | 89 | 278 | 319 | 346 | 276 | 176 | 443 | 407 | 152 | 288 | 325
 |  |  | Par | 4 | 5 | 4 | 3 | 5 | 4 | 5 | 3 | 4 | 4 | 4 | 4 | 3 | 5 | 5 | 3 | 4 | 4 |  |  |  |  | 73
 |  | The Old Course, [NAME] |  | Burn | Dyke | Cartgate (Out) | Ginger Beer | [NAME] (Out) | Heathery (Out) | High (Out) | Short | End | [NAME] | High (In) | Heathery (In) | [NAME] (In) | Long | Cartgate (In) | Corner Of The Dyke | Road | [NAME]
 |  | St Andrews Links Trust | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | IN | OUT | TOTAL | SSS
 |  | Pilmour House | Stroke Index | 10 | 6 | 16 | 8 | 2 | 12 | 4 | 14 | 18 | 15 | 7 | 3 | 11 | 1 | 9 | 13 | 5 | 17
 |  | [NAME] | White Yards | 376 | 411 | 370 | 419 | 514 | 374 | 359 | 166 | 347 | 340 | 174 | 316 | 418 | 530 | 414 | 381 | 455 | 357
 |  | Fife | Par | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 4 |  |  |  |  | 72
 |  | KY16 9SF | [NAME] | 355 | 395 | 337 | 411 | 514 | 360 | 349 | 154 | 289 | 311 | 164 | 304 | 388 | 523 | 391 | 345 | 436 | 361
 |  | Scotland | Par | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 4 |  |  |  |  | 70
 |  |  | Ladies
 |  |  | Stroke Index | 10 | 6 | 16 | 8 | 2 | 12 | 4 | 14 | 18 | 15 | 7 | 3 | 11 | 1 | 9 | 13 | 5 | 17
 |  | Links | Red Yards | 339 | 375 | 321 | 401 | 454 | 325 | 335 | 145 | 261 | 296 | 150 | 304 | 377 | 487 | 369 | 325 | 426 | 342
 |  |  | Par | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 4
Spreadsheet: 00502f9e-c6f8-4ed3-a3e2-07bee7e198a5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2010-07-01 00:00:00 | 418 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: sally_beck__33746__Data Source and Timeline for Dave Delainey report
Sheet: Sheet2

 | Availability of ENA Operating Report
 | Prepared by Energy Operations
 | Dates Subject to Change due to Extensions of Monthly Close
 |  | Accounting Month | Information Received From Sources (6th workday) |  | ENA Operating Report Available (end of day)
 |  | July  (1) | 2000-08-10 00:00:00 |  | 2000-08-11 00:00:00
 |  | August | 2000-09-11 00:00:00 |  | 2000-09-12 00:00:00
 |  | September | 2000-10-06 00:00:00 |  | 2000-10-07 00:00:00
 |  | October | 2000-11-08 00:00:00 |  | 2000-11-09 00:00:00
 |  | November | 2000-12-08 00:00:00 |  | 2000-12-11 00:00:00
 |  | December | 2000-01-09 00:00:00 |  | 2000-01-10 00:00:00
 |  | (1)  July close has been extended two days due to the SAP conversion.
Spreadsheet: 181205d1347963978-the-row-number-of-the-first-occurence-of-any-item-in-a-table-forum
Sheet: Sheet1

Item | value | Item | value | Item | value |  | Required: The row number  of the first occurence of any item in the table. For example, 7 is the row no. of the first occurence of "m"'                          8 is the row no. Of the first occurence of "g",  and so on.
x | 50
 |  | y | 30 | y | 12
m | 65 | m | 45
g | 25 |  |  | x | 40
 |  | m | 50
 |  |  |  | g | 20 |  | x
y | 15 | x | 37 |  |  |  | y
 |  |  |  |  |  |  | m
 |  |  |  |  |  |  | g
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: ΕΨΑ ΙΣΟΤΟΝΙΚΑ

ΕΨΑ
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
ΦΙΑΛΗ 0,25ML |  |  | ΙΣΟΤΟΝΙΚΑ
[NAME] | ΚΙΒΩΤΙΑ |  | POWERADE ΠΟΡΤ. 0,25LT/12TEM | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΚΟΚΚΙΝΗ | ΚΙΒΩΤΙΑ |  | POWERADE MOUNΤΑΙΝ 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ | ΚΙΒΩΤΙΑ |  | POWERADE BL.ORANGE 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΓΚΑΖΟΖΑ | ΚΙΒΩΤΙΑ |  | POWERADE CITRUS 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΣΟΔΑ | ΚΙΒΩΤΙΑ |  | GATORADE ΠΟΡΤ. 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΜΕΤΑΛΛΙΚΟ 0,33LT |  |  | GATORADE COOL 0,5LT/12TEM | ΚΙΒΩΤΙΑ
[NAME] | ΚΙΒΩΤΙΑ |  | GATORADE LEM. 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΚΟΚΚΙΝΗ | ΚΙΒΩΤΙΑ |  | GATORADE TROPICAL 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΚΟΚΚΙΝΗ LIGHT | ΚΙΒΩΤΙΑ |  | REDBULL METΑΛΛΙΚΟ 24TEM | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ | ΚΙΒΩΤΙΑ |  | RED BULL ΦΙΑΛΗ 0,25LT/24TEM | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ LIGHT | ΚΙΒΩΤΙΑ |  | ΤΣΑΙ ARIZONA
ΓΚΑΖΟΖΑ | ΚΙΒΩΤΙΑ |  | [NAME] 12X473 | ΚΙΒΩΤΙΑ
ΣΟΔΑ | ΚΙΒΩΤΙΑ |  | ARIZONA GREEN TEA 12X473MLΓΥΑΛ | ΚΙΒΩΤΙΑ
ΦΙΑΛΗ 1,5LT |  |  | ARIZONA DIET GREEN TEA 12X473 | ΚΙΒΩΤΙΑ
[NAME] | ΤΕΜΑΧΙΑ |  | ARIZONA LEMON TEA 12X473 ΓΥΑΛ. | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΚΟΚΚΙΝΗ | ΤΕΜΑΧΙΑ |  | ARIZONA PEACH TEA 12X473 ΓΥΑΛ | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ | ΤΕΜΑΧΙΑ |  | ARIZONA POMEGR.TEA 12X473 ΓΥΑΛ | ΚΙΒΩΤΙΑ
ΓΚΑΖΟΖΑ | ΤΕΜΑΧΙΑ |  | ARIZONA GREEN TEA 12X500ML PET | ΚΙΒΩΤΙΑ
ΦΙΑΛΗ ΜΙΑΣ ΧΡΗΣΕΩΣ |  |  | ARIZONA LEMON TEA 12X500 PET | ΚΙΒΩΤΙΑ
[NAME] | ΚΙΒΩΤΙΑ |  | ARIZONA PEACH TEA 12X500ML PET | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΚΟΚΚΙΝΗ | ΚΙΒΩΤΙΑ |  | ARIZONA POMEGRAN.TEA12X500 PET | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ | ΚΙΒΩΤΙΑ |  | ARIZONA GR.& LEM.TEA 24X355ΜΕΤ | ΚΙΒΩΤΙΑ
ΓΚΑΖΟΖΑ | ΚΙΒΩΤΙΑ |  | ARIZONA GREEN TEA 24X355ML ΜΕΤ | ΚΙΒΩΤΙΑ
ΒΥΣΣΙΝΑΔΑ | ΚΙΒΩΤΙΑ |  | ARIZONA PEACH TEA 24X355 MET | ΚΙΒΩΤΙΑ
ΧΥΜΟΙ |  |  | ARIZONA POMEGRAN.TEA 24X355ΜΕΤ | ΚΙΒΩΤΙΑ
ΕΨΑ VITA 0,25LT | ΚΙΒΩΤΙΑ
ΕΨΑ VITA 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΕΨΑ Π.Μ.Β. 0,25LT | ΚΙΒΩΤΙΑ
ΕΨΑ Π.Μ.Β 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΕΨΑ ΡΟΔΑΚΙΝΟ 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
ΕΨΑ Φ.Χ.ΠΟΡΤ. 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
ΕΨΑ Φ.Χ.ΠΟΡΤ. 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΕΨΑ ΠΟΡΤΟΣ 100% 0,25LT | ΚΙΒΩΤΙΑ
ΕΨΑ ΜΗΛΟΣ 100% 0,25LT | ΚΙΒΩΤΙΑ
Spreadsheet: 875730d1722343130-power-query-multiple-header-book2-1-
Sheet: Sheet1

Removed Characters | Attribute | AREA 330 | AREA 061 | AREA 051 | AREA 101 | AREA 091 | AREA 211 | AREA 081 | AREA 041
EQUIPMENT STRUCTURE | 1 |  | 22.12 | 0.26 | 13.98 | 4.96 | 19.56 | 4.9 | 25.51
EQUIPMENT STRUCTURE | 2 |  | 66.36 | 0.79 | 41.94 | 14.87 | 58.67 | 14.7 | 76.52
EQUIPMENT STRUCTURE | 3 |  | 58.99 | 0.7 | 37.28 | 13.22 | 52.15 | 13.06 | 68.01
EQUIPMENT STRUCTURE | 4 |  | 25.53 | 0.3 | 15.05 | 8.36 | 12.69 | 15.35 | 37.06
EQUIPMENT STRUCTURE | 5 |  | 1.17 |  |  |  | 3.28 |  | 2.34
PIPE RACK & BRIDGE | 1 | 1210.18
PIPE RACK & BRIDGE | 2 | 3630.54
PIPE RACK & BRIDGE | 3 | 3227.15
PIPE RACK & BRIDGE | 4 | 694.26
PIPE RACK & BRIDGE | 5 | 15.46
PLATFORM | 1 |  |  |  |  |  | 0.71 |  | 1.28
PLATFORM | 2 |  |  |  |  |  | 2.14 |  | 3.85
PLATFORM | 3 |  |  |  |  |  | 1.91 |  | 3.42
PLATFORM | 4 |  |  |  |  |  | 3.05 |  | 11.19
PLATFORM | 5
WALKWAY | 1 |  |  |  |  |  | 0.35 |  | 3.85
WALKWAY | 2 |  |  |  |  |  | 1.05 |  | 11.54
WALKWAY | 3 |  |  |  |  |  | 0.93 |  | 10.26
WALKWAY | 4 |  |  |  |  |  | 0.56 |  | 8.68
WALKWAY | 5 |  |  |  |  |  | 0.94 |  | 3.76
Spreadsheet: 116484d1311863281-macro-to-change-sheet-name-within-a-formula-name1
Sheet: 08.05.11

Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
2011-08-01 00:00:00 |  |  | 2011-08-02 00:00:00 |  |  | 2011-08-03 00:00:00 |  |  | 2011-08-04 00:00:00 |  |  | 2011-08-05 00:00:00
Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours
Test | 3 |  | Test | 5 |  | Test | 7 |  | Test | 2 |  | Test | 9
Total | 3 |  | Total | 5 |  | Total | 7 |  | Total | 2 |  | Total | 9
Weekly Total | 26
Spreadsheet: 525221d1498610774-formula-that-moves-to-the-next-column-according-to-the-month-cop-status-report_urn-final
Sheet: Base

Gateway Review/Health Check Close-out Status Report
 | [NAME]:
 | Project:
 | Tier:
 | Sponsor Agency:
 | Review:
 | Review Finalised Date: | [dd/mm/yyyy]
 | Review Findings:
 | Review OVERALL level of confidence: | High
 |  |  | No. of Recommendations
 | Key Focus Area | Rating | Critical | Essential | Suggested | ALL
1 | Service Delivery | Strong
2 | Affordability and Value For Money | Satisfactory
3 | Sustainability | Strong
4 | Governance | Weak
5 | Risk Management | Strong
6 | Stakeholder Management | Strong
7 | Change Management | Strong
8 | Other Matters | Weak
 | TOTAL No. of Recommendations
 | Review Severity Index
 | Clearance of Gate
 | Close-Out Plan: |  |  |  |  | 2017-05-31 00:00:00 |  | What I need to do is when I select another date in column G, the formulas in the green cells below take the information from the sheet "Recommendations-COP" in the column that matches that date.
 | Close-out Plan (COP) endorsed by INSW
 | COP Status
 |  |  | COP Recommendations
 |  |  | Critical | Essential | Suggested | ALL
 |  | Not Started
 |  | In Progress
 |  | Open
 |  | Closed
 |  | TOTAL
 |  | On-Track
 |  | % On-Track
 |  | Review Progress
 | COP Rating
 | Rating Rationale
 | Comments | ED enter text here
Spreadsheet: da420749-174b-4133-9133-8ce045cd5142
Sheet: Sheet1

PROG ID | ATHLETE ID | TEAM FIRST | TEAM LAST | NATIONALITY | START NUMBER | LEG 1 | LEG 2 | LEG 3 | LEG 4 | POSITION | TOTAL TIME
4465 | 13989 | Team I | Denmark | DEN | 0 | 06:30:15 | 00:00:00 | 06:42:17 | 00:00:00 | 1 | 20:03:04
4465 | 14070 | Team I | Netherlands | NED | 0 | 06:31:56 | 00:00:00 | 06:40:33 | 00:00:00 | 2 | 20:04:13
4465 | 14169 | Team I | United States | USA | 0 | 06:54:52 | 00:00:00 | 07:08:37 | 00:00:00 | 3 | 21:14:52
4465 | 11830 | Team I | Italy | ITA | 0 | 06:49:00 | 00:00:00 | 07:10:46 | 00:00:00 | 4 | 21:17:16
Spreadsheet: 79581d1279809387-v-lookup-combined-lookup-values-2-dummy
Sheet: Current

Invoice Number | Customer | [NAME] |  | V-Lookup
1124 | Wal Mart | 111.58
81456 | Shoppers | 841.88
CD2233 | Zellers | 565.41
FD3356 | McDonalds | 111.11
1111 | Canadian Tire | 881.98
8125 | Rogers | 141.47
Spreadsheet: 147705d1332938591-maintaining-a-cell-value-by-date-test-file
Sheet: UK Films

 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Total
Lost Time Injuries (LTI) | 1 | 2 | 3 | 4 | 5 | 6
Restricted Work Cases (RWC)
Medical Treatment Cases (MTC)
First Aid Cases (FAC)
Total Incidents
Lost Days
Hazards/Near Miss Reported
Spreadsheet: 860509d1708593485-kepp-returning-a-error-when-doing-for-array-error-when-doing-blank-aligw
Sheet: Sheet1

Period | Project | Task | Amt |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00
2023-01-31 00:00:00 | #A | Coding | 50 |  |  |  |  | Coding | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-01-31 00:00:00 | #B | Coding | 100 |  |  |  | #A | Mapping | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-02-28 00:00:00 | #B | Mapping | 15 |  |  |  | #A | UAT | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | #A | Mapping | 80 |  |  |  | #B | Coding | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | #C | Souring | 35 |  |  |  | #B | Mapping | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | #A | UAT | 15 |  |  |  | #B | UAT | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | #B | UAT | 100 |  |  |  | #C | Souring | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Subtotal #A |  | 50 | 0 | 95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Subtotal #B |  | 100 | 15 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Subtotal #C |  | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | HSTACK("Subtotal "&z,"",SUMIFS(Table1[Amt],Table1[Project],z,Table1[Period],J1:W1))
 |  |  |  |  |  |  | The yellow part refer to the Red Font as per above. How do I remove the error?
Spreadsheet: 32096d1228222698-problem-with-a-top-10-list-topten
Sheet: Sheet1

a | 2 |  |  |  |  | Top Ten | 1st | j | 117
b | 3 |  |  |  |  |  | 2nd | l | 93
c | 22 |  |  |  |  |  | 3rd | c | 22
d | 1 |  |  |  |  |  | 4th | f | 22
e | 9 |  |  |  |  |  | 5th | s | 21
f | 22 |  |  |  |  |  | 6th | h | 17
g | 3 |  |  |  |  |  | 7th | k | 17
h | 17 |  |  |  |  |  | 8th | e | 9
j | 117 |  |  |  |  |  | 9th | r | 9
y | 0 |  |  |  |  |  | 10th | b | 3
k | 17
r | 9 |  |  |  |  |  |  |  | error, 3-way tie
s | 21
l | 93
Spreadsheet: 478201d1472670757-vlookup-of-adjacent-cells-vlookup-adjacent-help
Sheet: DATA

sink | "w" | "h" |  |  |  |  | display corresponding "w" | display corresponding "h"
111 | 22 | 44
222 | 23 | 45
333 | 24 | 46
444 | 25 | 47
555 | 26 | 48
666 | 27 | 49
Spreadsheet: 35470d1233076300-sum-product-formula-w-criteria-report-sample
Sheet: Data Sum

Day 1 | Day 2 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 |  | 14103 | 112
Wed | 2008-10-01 00:00:00 | 4 | 6 | 8 | 12 | 16 | 19 | 16 | 10 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 5 | 3
Thu | 2008-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fri | 2008-10-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sat | 2008-10-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sun | 2008-10-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mon | 2008-10-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tue | 2008-10-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 854004d1703959044-vlookup-hyperlinks-weekly-cooking_small
Sheet: DATABASE

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19
Oriental Beef Sir-fry | OBSF TAB | [NAME](1 lbs) | [NAME] | Red bell pepper | Yellow bell pepper | Broccoli | Spring Onions | Bok Choy | Water Chestnuts | Oyster sauce
[NAME] | BCD Pg 122 | Pork  Loin 1/2 lb | Green bell pepper | Red bell pepper | Yellow Onion | [NAME] | Chili Powder (1 Tbsp) | [NAME] (1 Tbsp) | All Purpose [NAME] (1 Tsp) | Salt (1/4 [NAME]) | [NAME] (1/4 tsp) | [NAME] (1/4 cup) | Semi-Sweet Chock Morsels (2 Tbsp) | [NAME] (4) | Chopped Tomato | Chopped Cilantro | Shredded Montery Jack Cheese | Other