tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 112401d1308564537-how-can-i-show-only-one-x-on-a-line-business-diagnostics-for-excel-forum
Sheet: Sheet1

 |  | Completely dissatisfied | Dissatisfied | Very Poor | Poor | Ok | Neutral | Fair | Good | Fairly Good | Very Good | Excellent | Please add any comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completely dissatisfied |  |  |  |  | Neutral |  |  |  |  | Very Good
 |  | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5
1 | Customer Service |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | Value for money |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | Marketing |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 | Support |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 | Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 | Availabilty |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 | Finance |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 | Banking |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 | Property |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: 741065d1626792184-help-with-brushing-up-formula-that-copies-row-data-automatically-from-another-sheet-gk-20-07-15-00
Sheet: Purchase Order

ORDER - PO | ORDER - STATUS: | STAFF - ORDER TAKEN BY: | DATE - INPUTTED DATA: | DATE - CUSTOMER INSTALLATION DATE: | CUSTOMER -  FULL NAME: | CUSTOMER - EMAIL: | CUSTOMER - PHONE: | CUSTOMER - ADDRESS (1ST LINE): | CUSTOMER - ADDRESS (CITY): | CUSTOMER - ADDRESS  (POST CODE): | CUSTOMER - DELIVERY ADDRESS (IF [NAME]): | PRODUCT CODE | PRODUCT SIZE (SQM) | PRODUCT COST PER UNIT (SQM) | PRODUCT QTY | PRODUCT - TOTAL COST | PAYMENT - TOTAL ORDER COST | PAYMENT - CUSTOMER PAID: | PAYMENT -OUTSTANDING | NOTES:
Spreadsheet: 59274d1259767506-vlook-up-from-across-several-worksheet-sample09
Sheet: September 09

Name | Ref. Date | Code | Ref. source | 1st Contact | Assmt. Date | CP Completed
G Test | 2009-09-02 00:00:00 | C274/09 | Home | 2009-09-03 00:00:00 | 2009-09-10 00:00:00 | 2009-09-10 00:00:00
H Test | 2009-09-02 00:00:00 | C275/09 | Work | 2009-09-11 00:00:00 | 2009-10-05 00:00:00 | 2009-10-05 00:00:00
I Test | 2009-09-03 00:00:00 | E0391/06 | Team Air | 2009-09-03 00:00:00 | 2009-09-07 00:00:00 | 2009-09-08 00:00:00
J Test | 2009-09-03 00:00:00 | C341/07 | Self | 2009-09-04 00:00:00 | 2009-09-22 00:00:00 | 2009-09-22 00:00:00
K Test | 2009-09-04 00:00:00 | C276/09 | Home | 2009-09-12 00:00:00 | 2009-09-18 00:00:00 | 2009-10-23 00:00:00
L Test | 2009-09-04 00:00:00 | C277/09 | Street | 2009-09-09 00:00:00 | 2009-09-17 00:00:00 | 2009-09-17 00:00:00
M Test | 2009-09-04 00:00:00 | C278/09 | Home | 2009-09-08 00:00:00 | 2009-09-10 00:00:00 | 2009-09-30 00:00:00
N Test | 2009-09-07 00:00:00 | C681/07 | Work | 2009-09-07 00:00:00 | 2009-09-14 00:00:00 | 2009-10-05 00:00:00
Spreadsheet: 795981d1663056738-automatic-number-of-row-is-table-table-test
Sheet: גיליון1

 |  |  |  | 3 | table size:
 |  |  | age | name | id
 |  |  | 22 | oren | 1
 |  |  | 23 | einav | 2
 |  |  | 25 | gal | 3
 |  |  |  | 5 | table size:
 |  |  | age | name | id
 |  |  | 22 | oren | 1
 |  |  | 23 | einav | 2
 |  |  | 25 | gal | 3
 |  |  | 32 | pol | 4
 |  |  | 52 | adi | 5
 |  |  |  | 2 | table size:
 |  |  | age | name | id
 |  |  | 22 | oren | 1
 |  |  | 23 | einav | 2
Spreadsheet: 703528d1605031629-vlookup-with-count-excel-file
Sheet: Detail

Location | Location Name | NOV Units | DEC Units | JAN Units
40606 | 2 PARK DRIVE | 4 | 3 | 3
40606 | 6 PARK DRIVE | 3 | 3 | 3
40606 | 7 PARK DRIVE | 5 | 4 | 5
40606 | 8 PARK DRIVE | 0 | 1 | 1
Spreadsheet: 300883d1393598817-expanding-a-data-set-in-one-column-by-inserting-a-data-set-from-another-column-help
Sheet: Sheet1

 |  |  |  |  |  |  | Data Set 1 |  |  |  |  | Data Set 2 |  |  |  |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | J | 9 |  |  |  | 123 | A | 1
 |  |  |  |  |  |  |  |  |  |  |  | J | 7 |  |  |  | 123 | A | 2
 |  |  |  |  |  |  |  |  |  |  |  | A | 1 |  |  |  | 123 | A | 3
 |  |  |  |  |  |  |  |  |  |  |  | A | 2 |  |  |  | 123 | B | 2
 |  |  |  |  |  |  | 123 | A |  |  |  | A | 3 |  |  |  | 123 | B | 7
 |  |  |  |  |  |  | 123 | B |  |  |  | B | 2 |  |  |  | 123 | B | 4
 |  |  |  |  |  |  | 124 | F |  |  |  | B | 7 |  |  |  | 123 | B | 5
 |  |  |  |  |  |  | 124 | J |  |  |  | B | 4 |  |  |  | 124 | F | 7
 |  |  |  |  |  |  |  |  |  |  |  | B | 5 |  |  |  | 124 | F | 4
 |  |  |  |  |  |  |  |  |  |  |  | F | 7 |  |  |  | 124 | F | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 4 |  |  |  | 124 | J | 9
 |  |  |  |  |  |  |  |  |  |  |  | F | 5 |  |  |  | 124 | J | 7
 |  |  |  |  |  |  |  |  |  |  |  | Help needed
Spreadsheet: kate_symes__18409__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
 | 2000-12-09 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 187.04 | 810 | 148.98 | 1225
 | 2000-12-08 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 287.06 | 1430 | 175 | 390
 | 2000-12-07 00:00:00 |  | 312.11 | 2080 | 205.86 | 2776 | 246.51 | 172 | 138.05 | 519
 | 2000-12-06 00:00:00 |  | 267.18 | 2128 | 177.11 | 1344 | 260.08 | 529 | 151.35 | 911
 | 2000-12-05 00:00:00 |  | 237.02 | 2848 | 119.16 | 904 | 274.6 | 1057 | 172.84 | 1728
 | 2000-12-04 00:00:00 |  | 200.19 | 2080 | 131 | 800 | 227.66 | 1683 | 126.49 | 1488
 | 2000-12-03 00:00:00 |  | 150 | 800 | 118.5 | 0 | 127.99 | 2955 | 109 | 2055
Spreadsheet: 690580d1597174253-textjoin-or-match-index-roster-test
Sheet: Day

 | Today
 | 2020-04-05 00:00:00
E
L | names | names | names | names
Skills
Data | names | names | names
Excel | names | names | names
Staffing | Names | Names | Names
Spreadsheet: mark_taylor__25055__Bowling teams
Sheet: Sheet1

EnronOnline Bowl-A-Thon
Team Name | Bowler #1 | Bowler #2 | Bowler #3 | Bowler #4 | Bowler #5 | Bowler #6
Team #1 | [NAME] | [NAME] | [NAME]
Team #2 | [NAME] | [NAME] | [NAME]
Team #3 | [NAME] | [NAME] | Zach Streight
Team #4 | [NAME] | Lydia Cannon | [NAME] | [NAME] | *Brandon
Team #5 | [NAME] | [NAME] | [NAME] | Cecil [NAME]
Team #6 | [NAME] | Fraisy George | [NAME]
Team #7 | [NAME] | *Nick's wife
Team #8 | [NAME] | Heather Alon | [NAME] | [NAME]
Team #9 | [NAME]
Team #10 | [NAME] | Teresa Mandola | [NAME] | [NAME] |  | *
 | Brad Richter
Spreadsheet: aedd864e-a3f4-4f07-bf8d-8fbe228e34d3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40849253 | 2014-04-05 08:21:26 | AXIS | 1 | 4 | 3 | 769828 | rvgrigri | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40849443 | 2014-04-05 08:56:54 | ALLIES | 0 | 2 | 4 | 769828 | rvgrigri | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40888408 | 2014-04-07 19:35:36 | AXIS | 0 | 3 | 7 | 385172 | Brode Warrior | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40888701 | 2014-04-07 19:58:30 | ALLIES | 1 | 7 | 3 | 385172 | Brode Warrior | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40953442 | 2014-04-12 11:16:36 | ALLIES | 0 | 3 | 6 | 292993 | Goron | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
40953651 | 2014-04-12 11:51:44 | AXIS | 1 | 6 | 3 | 292993 | Goron | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
40967580 | 2014-04-13 09:39:24 | AXIS | 0 | 2 | 6 | 1360620 | Factotem | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
40967722 | 2014-04-13 09:54:12 | ALLIES | 1 | 6 | 3 | 1360620 | Factotem | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
41017625 | 2014-04-16 17:21:05 | ALLIES | 0 | 4 | 6 | 681429 | Caverne | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
41017784 | 2014-04-16 17:35:54 | AXIS | 1 | 6 | 2 | 681429 | Caverne | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
41044363 | 2014-04-18 14:29:12 | ALLIES | 1 | 6 | 4 | 1521192 | mynotor | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
Spreadsheet: 216969d1361945740-cell-in-base-of-the-colour-and-value-to-paste-to-other-sheet-color-find-vba
Sheet: Non Payed

 | 2013-01-02 00:00:00 |  | 2013-02-03 00:00:00 |  | 2013-02-04 00:00:00 |  | 2013-02-05 00:00:00 |  | 2013-02-06 00:00:00 |  | 2013-02-07 00:00:00 |  | 2013-02-08 00:00:00 |  | 2013-02-09 00:00:00 |  | 2013-02-10 00:00:00 |  | 2013-02-11 00:00:00 |  | 2013-02-12 00:00:00 |  | 2013-02-13 00:00:00 |  | 2013-02-14 00:00:00 |  | 2013-02-15 00:00:00 |  | 2013-02-16 00:00:00 |  | 2013-02-17 00:00:00 |  | 2013-02-18 00:00:00 |  | 2013-02-19 00:00:00 |  | 2013-02-20 00:00:00 |  | 2013-02-21 00:00:00 |  | 2013-02-22 00:00:00 |  | 2013-02-23 00:00:00 |  | 2013-02-24 00:00:00 |  | 2013-02-25 00:00:00 |  | 2013-02-26 00:00:00 |  | 2013-02-27 00:00:00 |  | 2013-02-28 00:00:00 |  | 2/29/2013 |  | 2/30/2013 |  | 2/31/2013
 | kiran |  | ALIJA E
 |  |  | ALIJAHE
 |  |  | ALIVODJ
 |  |  | ARRSI S
 |  |  | [NAME]
 |  |  | BAJRAKT
 |  |  | BALA NE
 |  |  | BARAKU
 |  |  | BASHI M
 |  |  | BASHKU
 |  |  | BASHLI
 |  |  | BEKTESH
 |  |  | BEQIRI
 |  |  | BERDICA
 |  |  | FUSHAZI
 |  |  | GERMAJ
 |  |  | GJOKA D
 |  |  | GJOKA L
 |  |  | GJONI
 |  |  | GJONI K
 |  |  | GURI KE
 |  |  | HALILI
 |  |  | HALLA E
 |  |  | HASAJ S
 |  |  | HAVERI
 |  |  | HILA FE
 |  |  | HYLLI E
 |  |  | JAKU ER
 |  |  | KACAJ V
 |  |  | KAKINI
 |  |  | KATICA
 |  |  | KERRCI
 |  |  | KOLECI
 |  |  | KOPSHTA
 |  |  | KRAJA E
 |  |  | KROJ MA
 |  |  | KRONAJ
 |  |  | KUBAZI
 |  |  | KULLA K
 |  |  | LAKJA S
Spreadsheet: 876894d1723611088-formula-to-take-rows-and-put-data-into-columns-zorakzoran-group-titles-1-
Sheet: Group Titles

[NAME] | Title 1 | Project A |  |  | Title 1 | Project A | Project B | Project C
[NAME] | Title 1 | Project B |  | [NAME] | Title 2 | Project A | Project C
[NAME] | Title 1 | Project C |  | [NAME] | Title 3 | Project D
[NAME] | Title 2 | Project A |  | [NAME] | Title 4 | Project B | Project C
[NAME] | Title 2 | Project C
[NAME] | Title 3 | Project D
[NAME] | Title 4 | Project B
[NAME] | Title 4 | Project C
Spreadsheet: 1d4cbd05-3653-4d3c-8034-ddee087536d0
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
HYOX | Test | HYOX | Hyperoxaluria Panel, [NAME] | Hyperoxaluria Panel, U | Gas Chromatography-Mass Spectrometry (GC-MS) | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Fasting-overnight (12-14 hours). 2. Have patient void the first-morning specimen, then collect specimen within 2 hours of first-morning void while patient continues to fast. Fluids are allowed. 3. No preservative. 4. Immediately freeze specimen. Forms: 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1.1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | GLYCOLATE 0-31 days: 0-57 mg/g creatinine 1-5 months: 0-54 mg/g creatinine 6-12 months: 0-60 mg/g creatinine 1-5 years: 0-89 mg/g creatinine  > or =6 years: 0-78 mg/g creatinine  GLYCERATE 0-31 days: 0-38 mg/g creatinine 1-5 months: 0-71 mg/g creatinine  6-12 months: 0-56 mg/g creatinine 1-5 years: 0-17 mg/g creatinine  > or =6 years: 0-8 mg/g creatinine  OXALATE 0-31 days: 0-301 mg/g creatinine 1-5 months: 0-398 mg/g creatinine 6-12 months: 0-280 mg/g creatinine  1-5 years: 0-128 mg/g creatinine 6-10 years: 0-72 mg/g creatinine  > or =11 years: 0-56 mg/g creatinine  GLYOXYLATE 0-31 days: 0.0-7.9 mg/g creatinine 1-5 months: 0.0-11.4 mg/g creatinine 6-12 months: 0.0-5.5 mg/g creatinine 1-5 years: 0.0-3.9 mg/g creatinine > or =6 years: 0.0-2.9 mg/g creatinine | Varies; Batched 1 time per month; 8 a.m. | 14 days |  | 1 | 82544 |  |  |  |  | Rochester
HYOX | [NAME] | URINE | [NAME] |  |  |  | Frozen | 406 days
HYOX | Result | 50592 | Glycolate | Glycolate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13751-3
HYOX | Result | 50593 | Glycerate | Glycerate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13749-7
HYOX | Result | 50594 | Oxalate | Oxalate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13483-3
HYOX | Result | 50595 | Glyoxylate | Glyoxylate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13752-1
HYOX | Result | 29982 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
HYOX | Result | 29984 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 846488d1697657384-weighted-average-rent-per-square-foot-of-retail-plaza-after-a-certain-date-weighted-average-rent-per-square-foot-of-retail-plaza-after-a-certain-date
Sheet: Sheet1

[NAME] | Sq. Feet | Lease Start | Lease End | Current Annual | Current Monthly | Current Annual | Lease Type
 |  |  |  | Rent | Rent | Per Sq. Feet
Grocery | 53731.97 | 2015-03-01 00:00:00 | 2026-06-30 00:00:00 | 940309.47 |  |  | Net
Pharmacy | 17009.62 | 2021-08-01 00:00:00 | 2031-07-31 00:00:00 | 484774.17 |  |  | Net
Bank | 4500 | 2021-11-01 00:00:00 | 2026-10-31 00:00:00 | 171255 |  |  | Net
Bar | 4940 | 2022-04-01 00:00:00 | 2025-03-31 00:00:00 | 180000 |  |  | Gross
[NAME] | 1553 | 2021-02-15 00:00:00 | 2028-12-31 00:00:00 | 38825 |  |  | Net
Juice | 815 | 2018-10-01 00:00:00 | 2028-12-31 00:00:00 | 22800 |  |  | Net
Travel Agency | 1216 | 2022-10-01 00:00:00 | 2027-12-31 00:00:00 | 47100 |  |  | Gross
Dentist | 1811.98 | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 77962.56 |  |  | Net
Chinese | 1209.21 | 2021-12-17 00:00:00 | 2026-12-31 00:00:00 | 41653.89 |  |  | Net
Pita | 1012.62 | 2021-08-01 00:00:00 | 2026-07-31 00:00:00 | 28353.36 |  |  | Net
[NAME] | 1000 | 2021-10-01 00:00:00 | 2026-09-30 00:00:00 | 32000 |  |  | Net
Salon | 1030 | 2022-05-01 00:00:00 | 2027-03-31 00:00:00 | 29400 |  |  | Net
[NAME] | 1595 | 2022-11-01 00:00:00 | 2028-10-31 00:00:00 | 59425 |  |  | Net
Total
*Red means excluded from the weighted average rent
Spreadsheet: 170871d1343457894-output-date-from-changing-cell-range-sample
Sheet: Sheet1

Date |  | SO or PO | Status | Qty | Rec | Customer or [NAME] |  |  | ETA
 | Outstanding | SO1 | Open | 25 | 0 | Customer1
 | Outstanding | SO2 | Open | 30 | 0 | Customer2
 | Outstanding | SO3 | Open | 28 | 0 | Customer3
 | Outstanding | SO4 | Open | 18 | 0 | Customer4
2012-08-01 00:00:00 | Outstanding | PO1 | Open | 20 | 0 | Supplier
2012-08-09 00:00:00 | Outstanding | PO2 | Open | 20 | 0 | Supplier
2012-08-28 00:00:00 | Outstanding | PO3 | Open | 40 | 0 | Supplier
2012-09-05 00:00:00 | Outstanding | PO4 | Open | 80 | 0 | Supplier
Spreadsheet: 68980d1269514229-problem-finding-last-value-in-a-row-last-value
Sheet: Sheet1

 | Last Quantity | CODE | Order Quantities
 | 100 | [NAME] | 100 | 100 | 100 | 130 | 100 | 100
 | 150 | BAT2 | 150
 | 150 | BAT3 | 150 | 150 | 150 | 150 | 150
 | 250 | BAT4 | 250 | 250
 | #N/A | BAT5 | 500
 | #N/A | BAT6 | 1000 | 1500 | 1600 | 2500
 | 50 | BAT7 | 96 | 61 | 90 | 112 | 50
 | #N/A | BAT8 | 1000
 | 25 | BAT9 | 25
 | 60 | BAT10 | 60
 | 180 | BAT11 | 180 | 180 | 180 | 180 | 180 | 180
 | 60 | BAT12 | 60 | 60 | 60
 | 60 | BAT13 | 60 | 60 | 60
 | 100 | BAT14 | 75 | 80 | 100 | 60 | 30 | 100
 | 73 | BAT15 | 73
 | 48 | BAT16 | 30 | 48 | 478 | 100
 | #N/A | BAT17 | 5000 | 2407 | 1529 | 3466 | 4000 | 2000
Spreadsheet: 15ac05c2-8ffc-4d85-be08-bd885977e212
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
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 14C. Average Weekly Earnings, Private and Public Sectors, Queensland (Dollars) - Original - Persons
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
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Queensland ;  Private sector ; |  |  | Original | A2725548W | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Queensland ;  Private sector ; |  |  | Original | A2725551K | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Queensland ;  Private sector ; |  |  | Original | A2725557X | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Queensland ;  Public sector ; |  |  | Original | A2731698T | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Queensland ;  Public sector ; |  |  | Original | A2731701V | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Queensland ;  Public sector ; |  |  | Original | A2731707J | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Queensland ;  Private sector ; |  |  | Original | A3523503F | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Queensland ;  Private sector ; |  |  | Original | A3523506L | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Queensland ;  Private sector ; |  |  | Original | A3523509V | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Queensland ;  Public sector ; |  |  | Original | A3526743W | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Queensland ;  Public sector ; |  |  | Original | A3526746C | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Queensland ;  Public sector ; |  |  | Original | [NAME] | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 693061d1598726536-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-problems-2
Sheet: Septermber

 |  |  | A | A | B | B | A | A | B | B | Hrs | Beg | End
 | Last | First | 1 | 2 | 15 | 16 | 22 | 23 | 29 | 30 | Com. | Hrs | Hrs
1 | Adams | [NAME] |  | 10 |  |  |  |  |  | 12
2 | [NAME] | Daryl | 8 |  |  |  | 8
3 | [NAME] | [NAME]
4 | Credence | [NAME] |  |  |  | 4
5 | [NAME] | Daryl
6 | Edwards | [NAME] |  | 10 | 8 |  |  | 8
7 | [NAME] | Anne
8 | Gonzales | George | 8 | 10 |  |  | 8
9 | Hernandez | [NAME]
10 | Smith | [NAME] | 8 | 10 | 8 |  |  | 8 | 8 | 12
11 | [NAME] | George |  |  |  |  |  | 8 |  | 12 |  | 64
 |  | Total Workers
Spreadsheet: 114656d1310399861-different-results-depending-on-condition-recon-test
Sheet: Sheet1

NUMBER | STATUS |  |  |  | NUMBER | AMOUNT | DATE | STATUS
101 | REJECTED |  |  |  | 101 | 24 | 2011-07-05 00:00:00 | REJECTED
102 | PROCESSED |  |  |  | 102 | 25 | 2011-07-07 00:00:00 | PROCESSED
103 | PROCESSED |  |  |  | 103 | 28 | 2011-07-06 00:00:00 | PROCESSED
104 | PROCESSED |  |  |  | 104 | 29 | 2011-07-04 00:00:00 | PROCESSED
105 | REJECTED |  |  |  | 105 | 30 | 2011-07-08 00:00:00 | REJECTED
 |  |  |  |  | 106 | 31 | 2011-07-09 00:00:00 | #N/A | *Since this has an amount and date, I would like this to display "FAIL"
 |  |  |  |  | 107 |  |  | #N/A | *Since this has a blank amount or date, I would like it to be simply blank
 |  |  |  |  | 108 |  |  | #N/A
 |  |  |  |  | 109 |  |  | #N/A
 |  |  |  |  | 110 | 47 | 2011-06-24 00:00:00 | #N/A
 |  |  |  |  | 11 | 48 | 2011-06-27 00:00:00 | #N/A