tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: juan_hernandez__17720__SCHED2001
Sheet: FEB'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY
NAME | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED
 | 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
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
KELLER MAYEAUX | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
JUAN HERNANDEZ/ S.E. | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | H
RUDY ACEVEDO | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
MIGUEL GARCIA | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
DON BAUGHMAN/ M.W. | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
J.D.KINSER | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
RICHARD HRABAL/ N.E. | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
CHAD STARNES | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
[NAME] |  |  |  |  |  | N | N | N | N |  |  | N | N | N |  |  | D | D |  | ercot training |  |  | N | N
DEAN LAURENT | N | N |  |  |  |  | N | N | N |  |  |  | D |  |  | N | N | N |  |  |  | N |  | D | D |  | N | N
CYRIL PRICE | N |  | D | D |  |  |  |  | N | N | N |  |  |  |  |  |  | N | N | N | N |  |  |  |  | N | N | N
GREG TREFZ | N |  | N | N | N | N |  |  |  |  |  |  |  |  | N | N | N |  | N | N | N |  |  | D | D | D
[NAME] |  |  | D | D | D
[NAME] | N | N |  |  |  |  |  |  | D | D | D | D |  |  | N | N | N | N |  |  |  | N | N | N | N
CHRIS WATTS |  |  | D | D |  |  | N | N |  | D | D |  |  | N | N | N |  |  | N | N | N | N
[NAME] |  |  | N | N | N | N |  |  |  |  |  | S | S | S | S |  |  |  |  |  |  |  | N | N | N | N
[NAME] ROGERS |  |  |  |  | N | N | N |  |  | N | N | N | N |  |  | D | D | D | D | D |  |  | N | N | N | N
JUAN PADRON |  |  |  |  |  | N | N | N | N |  |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D
NIGHTS
DAYS
Spreadsheet: 107990d1305110742-excel-2007-sumifs-inside-of-a-vlookup-budchevy_sumifs
Sheet: Sheet2

Style ID | Size Code | Transaction Amount | Filtered Sub-total | 16
360413-01-1 | 1 | -2
360413-01-1 | 1 | 2
360413-01-1 | 1 | 2
360413-01-1 | 1 | 2
360413-01-1 | 1 | 2
360413-01-1 | 1 | -4
360413-01-1 | 2 | -2
360413-01-1 | 2 | 2
360413-01-1 | 2 | 2
360413-01-1 | 3 | 2
360413-01-1 | 3 | -4
360413-01-1 | 3 | 2
360413-01-1 | 3 | 4
360413-01-1 | 3 | 2
360413-01-1 | 3 | 2
360413-01-1 | 3 | 2
360413-01-1 | 3 | 2
Spreadsheet: john_griffith__16182__1_29_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | EXP |  |  | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 58 | 550 | 650 | 46.2 | 54.2 | 1.83 | 2002-01-29 11:06:00
 | [NAME] | 64 | 900 | 980 | 45.7 | 49.8 | 1.92 | 2002-01-29 11:06:00
 | [NAME] | 65 | 1120 | 1210 | 44.6 | 48.6 | 1.9 | 2002-01-29 11:06:00
 | [NAME] | 66 | 1250 | 1350 | 42.2 | 45.6 | 1.82 | 2002-01-29 11:06:00
 | HU N2 | 65 | 1340 | 1440 | 41.5 | 44.6 | 1.76 | 2002-01-29 11:06:00
 | [NAME] | 64 | 1380 | 1480 | 39.6 | 42.5 | 1.65 | 2002-01-29 11:06:00
 | HU U2 | 62 | 1400 | 1500 | 38.4 | 41.1 | 1.55 | 2002-01-29 11:06:00
 | [NAME] | 60 | 1410 | 1510 | 37.5 | 40.2 | 1.47 | 2002-01-29 11:06:00
 | [NAME] | 59 | 1380 | 1500 | 35.2 | 38.3 | 1.36 | 2002-01-29 11:06:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 698549d1602050503-complex-conditional-formatting-conditional-formatting-example
Sheet: Sheet1

Data
Name | 2020-01-01 00:00:00 | 2020-01-08 00:00:00 | 2020-01-15 00:00:00 | 2020-01-22 00:00:00 | 2020-01-29 00:00:00 | 2020-02-05 00:00:00 | 2020-02-12 00:00:00 | 2020-02-19 00:00:00 | 2020-02-26 00:00:00 | 2020-03-04 00:00:00 | 2020-03-11 00:00:00
[NAME] | 212.46 | 160.29 | 298.28 | 480.33 | 632.36 |  |  | 107.84 | 128.02 | 259.89 | 401.78
[NAME] | 238.75 | 220.77 | 327.09 | 278.39 | 318.71 | 417.15 | 195.37 | 533.38 |  | 349.82 | 328.07
[NAME] | 224.93 | 371.77 | 272.31 | 179.68 | 401.06 | 446.7 | 296.55 | 335.99 | 196.47 | 344.75 | 415.66
[NAME] | 377.6 | 535.83 | 323 | 448.24 | 447.22 | 334.69 | 401.87 | 317.4 | 345.2 | 691.36 | 210.31
Event |  |  | How do I apply conditional formatting so that the event date is highlighted in the data spread. E.g. a red box wil surround the cell which corresponds to each event for John- either on the day or for the closest date following the event |  |  |  |  |  |  |  | Note: Conditional formatting applied to row seperately (each person has their own average)
Name | Date
[NAME] | 2020-02-03 00:00:00
[NAME] | 2020-01-15 00:00:00
[NAME] | 2020-03-11 00:00:00
Spreadsheet: 107653d1304782821-find-and-replace-by-row-for-multiple-rows-with-individual-values-book1
Sheet: Sheet1

 | example 1 | example 2 | example 3 | example 4
125JH | D300 - D3456000 | Includes D300 as part of another sentence | Other text and stuff | D300 | Using a find and replace all on individual rows allows me to do this on a row by row basis, but I would like to set the same principle across the whole sheet
VF454 | D300 - D3456000 | Includes D300 as part of another sentence | Other text and stuff | D300
51BFG51 | D300 - D3456000 | Includes D300 as part of another sentence | Other text and stuff | D300
1N51BN5 | D300 - D3456000 | Includes D300 as part of another sentence | Other text and stuff | D300
 |  | ^
 | These entries are all the same 'item' duplicated down the rows - want to create a quick way of each row replacing the text "D300" with the content of column [NAME]. All instances of 'D300' in row 2 replaced with '125JH', but in row 3 with "VF454"
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: Supplies

SUPPLIES
List any item with a unit value of under $5,000 or a life expectancy of one year or less is considered a supply.  Include paper
forms, office supplies, computer software, equipment such as desks, chairs, file cabinets, fax machines, computers, copiers.
Supply Item |  | Source or Company Name | Quanity of Purchase Units | Cost/Unit | Annual Cost of Supply | % Allocated to CACFP | Total Annual Cost to CACFP
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0 |  |  | 0
 |  |  |  | 0 |  |  | 0
 |  |  |  | 0 |  |  | 0
 |  |  |  | 0 |  |  | 0
 |  |  |  | 0 |  |  | 0
 |  |  |  |  | Total Supplies
Spreadsheet: 783752d1655122952-set-duplicate-value-to-zero-based-on-duplicate-value-in-another-cell-product-vs-cost-2
Sheet: Example - Expected Result

Product | Cost of Item
20631 | 24163.96
20631 | 0
20831 | 8684.73
22380 | 2114.68
22380 | 0
22380 | 0
23291 | 0
23657 | 0
23966 | 166209.98
23966 | 0
24410 | 6238.15
24410 | 0
24413 | 466627.51
24413 | 0
24413 | 466627.51
26256 | 0
26256 | 0
51445 | 0
53117 | 0
53117 | 0
53994 | 5970.64
Spreadsheet: 160239d1339014775-excel-2007-multiple-if-statements-in-one-cell-apt-load-calc-bldg-
Sheet: Sheet 1

Building Calculation
LIGHTING: | # | TOTAL S.F. X 3 VA/SF = |  |  |  |  |  | VA
[NAME]:
 | BATHROOM EXHAUST : # X 120VA = |  |  |  |  |  | #
 | DISPOSAL: # X 1176 = |  |  |  |  |  | 1176
 | TOTAL AIR HANDLING VA = |  |  |  |  |  | #
 | DISHWASHER: # X 1092 = |  |  |  |  |  | 1092
 | MICROWAVE/HOOD UNIT: # X 1704 = |  |  |  |  |  | 1704
 | CEILING FANS: # X 240 = |  |  |  |  |  | #
SMALL APPLIANCE/REFRIG CIRCUITS: # X 1500VA = |  |  |  |  |  |  | 3000 | VA
RANGE: # X 10300VA = |  |  |  |  |  |  | 10300 | VA
LAUNDRY CIRCUITS: # X 1500VA = |  |  |  |  |  |  | 1500 | VA
WASHER/DRYER UNITS: # X 6240VA = |  |  |  |  |  |  | 6240 | VA
WATER HEATERS: # X 9000VA = |  |  |  |  |  |  | 9000 | VA
The Larger of total COOLING or total ELECTRIC HEAT = |  |  |  |  |  |  | # | VA
 |  |  |  |  | SUBTOTAL= |  |  | VA
DEMAND FACTOR = |  |  |  | *** | % |  |  | VA
 |  |  |  |  |  | TOTAL = |  | VA
 |  |  |  |  |  | AMPS = |  | A
HOUSE LOAD = |  |  |  |  |  | AMP = | # | A
 |  |  |  |  | GRANDTOTAL= |  |  | A
Spreadsheet: 266818d1379762863-create-tab-update-leaderboards-automatically-calend-rio-e-tabelas
Sheet: Folha3

 |  | FC [NAME] | Ginásio | [NAME] | FC | Rayo Vallecano | [NAME] | Dream Team | LitoPorto
 |  | Baixa | Mafamude FC | Olá Gaia | Calangas | Pedroso | Domingos | FC | FC
 | FC [NAME] | ---
 | Baixa
 | Ginásio |  | ---
 | Mafamude FC
 | [NAME] |  |  | ---
 | Olá Gaia
 | FC |  |  |  | ---
 | Calangas
 | Rayo Vallecano |  |  |  |  | ---
 | Pedroso
 | [NAME] |  |  |  |  |  | ---
 | Domingos
 | Dream Team |  |  |  |  |  |  | ---
 | FC
 | LitoPorto |  |  |  |  |  |  |  | ---
 | FC
Spreadsheet: 111713d1308046212-count-multiple-criteria-multiple-sheets-and-date-range-report-template
Sheet: Type A

Initials | Priority | Date Received | Date Processed | Process Days
AA | 1 | 2011-04-04 00:00:00 | 2011-04-10 00:00:00 | 5
AA | 1 | 2011-04-05 00:00:00 | 2011-05-10 00:00:00 | 22
AA | 2 | 2011-04-05 00:00:00 | 2011-04-10 00:00:00 | 4
AA | 2 | 2011-04-11 00:00:00 | 2011-05-10 00:00:00 | 18
AA | 3 | 2011-04-12 00:00:00 | 2011-04-20 00:00:00 | 7
AA | 3 | 2011-04-13 00:00:00 |  | -29029
Spreadsheet: 182026d1348240915-requesting-critique-of-my-retirement-spreadsheet-retire-calc3-send
Sheet: investment post-inf

 |  | age | balance | Cumulative Contribution | Principle | Gain | Ex. Ratio | ending Balance
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 2182885 | 228059 | 2410944
FRA | 387763 | 59345 | 447109
OIS | 108215 | 88553 | 196768
OTHER* | 27685 | 330121 | 357806
TOTAL | 2706548 | 706078 | 3412627
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: f4cba571-f6a0-440a-9948-7be06cd8996b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7217 | 53571 | [NAME] | Meur | BEL | 0 | 0:43:31 | 0:02:14 | 5:07:38 | 0:01:58 | 2:52:04 | 1 | 8:47:27
7217 | 51135 | [NAME] | Vogt | GER | 0 | 0:42:16 | 0:01:53 | 5:35:10 | 0:02:12 | 2:56:13 | 2 | 9:17:46
7217 | 53572 | Kristina | Mandt | GER | 0 | 0:41:27 | 0:02:08 | 0:00:00 | 0:00:00 | 0:00:00 | DNF | 0:00:00
Spreadsheet: 678102d1589715832-index-match-for-auto-costings-calculations-bizcostings-sample
Sheet: LOANS & BIZ COSTS

CATEGORY | ITEM | AVERAGE BILL | PERIOD | DAY | WEEK | MONTH | QTR | BI-ANNUAL | YEAR | COMMENTS
BUSINESS COST | GAS | 36 | monthly
BUSINESS COST | ELECTRICITY | 100 | quarterly
BUSINESS COST | INTERNET | 90 | monthly
BUSINESS COST | RENT | 6035.7 | monthly
BUSINESS COST | [NAME] | 138 | 6 months
BUSINESS COST | PHONE | 85.85 | monthly
BUSINESS LOAN | MASTERCARD | 265 | monthly
BUSINESS LOAN | VISA | 225 | monthly
BUSINESS LOAN | VISA2 | 315 | monthly
BUSINESS LOAN | LOAN1 | 283.65 | monthly
BUSINESS LOAN | BANK OVERDRAFT | 185 | monthly
BUSINESS COST | CONDO | 3500 | yearly
BUSINESS COST | WAVERLEY COUNCIL | 277 | yearly
CHARITY | CHARITY1 | 10 | monthly
SUBSCRIPTIONS | MAGAZINE | 18.5 | monthly
BUSINESS COST | LAUNDRY | 36 | weekly
BUSINESS COST | CANDLES | 0.75 | daily
BUSINESS COST | LEGAL | 200 | yearly
BUSINESS COST | REPAIRS | 50 | weekly
BUSINESS COST | MANCHESTER | 100 | quarterly
BUSINESS COST | LICENSES | 200 | 6 months
BUSINESS COST | INSURANCE | 100 | yearly
BUSINESS COST | PUBLIC LIABILITY | 200 | 6 months
BUSINESS COST | PROFESSIONAL INDEMNITY | 500 | yearly
PERSONAL LOAN | TOM | 2000 | 2 years
PERSONAL LOAN | CARLIE | 5000 | 5 years
Spreadsheet: cd4968a2-3967-4bb9-9da7-8ea81cff1024
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
URAU | Test | URAU | Urea, [NAME] | Urea, U | Kinetic UV Assay | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 10 g of boric acid as preservative at start of collection. (If boric acid is not available, refrigerate specimen during collection.) 3. Mix well before taking aliquot. Additional Information: 1. 24-hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient:	No Refrigerated:	Yes Frozen:	Yes 6N HCl:	Yes 50% Acetic Acid:	Yes Na2CO3:	Yes Toluene:	Yes 6N HNO3:	Yes Boric Acid:	Preferred Thymol:	Yes | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | 10-35 g/specimen | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 84540 |  |  |  |  | Rochester
URAU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated
URAU | Order Question | TM33 | Collection Duration |  | Plain Text
URAU | Order Question | VL31 | [NAME] |  | Plain Text
URAU | Result | UREA | Urea, U | Urea, U | Numeric |  |  |  |  | g/spec |  |  |  |  |  |  |  |  |  | 48999-7 | Urea:MRat:24H:[NAME]:Qn:
URAU | Result | TM33 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
URAU | Result | VL31 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
URAU | Result | URECN | Urea Concentration | Urea Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 63481-6 | Urea:MCnc:24H:[NAME]:Qn:
Spreadsheet: 59264d1259761422-match-formula-copy-of-pick4matchformula09
Sheet: Sheet2

 |  |  | 8411
6413 | 1913 | 1463 | 1408 |  |  |  |  |  |  |  |  |  |  | 3733 | 8233 | 8783 | 8738
6414 | 1914 | 1464 | 1409 |  |  |  |  |  |  |  |  |  |  | 5533 | 33 | 583 | 538
6415 | 1915 | 1465 | 1410 |  |  |  |  |  |  |  |  |  |  | 5713 | 213 | 763 | 718
6415 | 1915 | 1465 | 1410 |  |  |  |  |  |  |  |  |  |  | 5731 | 231 | 781 | 736
6416 | 1916 | 1466 | 1411 |  |  |  |  |  |  |  |  |  |  | 3731 | 8231 | 8781 | 8736
6417 | 1917 | 1467 | 1412 |  |  |  |  |  |  |  |  |  |  | 5531 | 31 | 581 | 536
8213 | 3713 | 3263 | 3208 |  |  |  |  |  |  |  |  |  |  | 5711 | 211 | 761 | 716
8214 | 3714 | 3264 | 3209 |  |  |  |  |  |  |  |  |  |  | 5729 | 229 | 779 | 734
8215 | 3715 | 3265 | 3210 |  |  |  |  |  |  |  |  |  |  | 3734 | 8234 | 8784 | 8739
8215 | 3715 | 3265 | 3210 |  |  |  |  |  |  |  |  |  |  | 5534 | 34 | 584 | 539
8216 | 3716 | 3266 | 3211 |  |  |  |  |  |  |  |  |  |  | 5714 | 214 | 764 | 719
8217 | 3717 | 3267 | 3212 |  |  |  |  |  |  |  |  |  |  | 5732 | 232 | 782 | 737
8411 | 3911 | 3443 | 3416 |  |  |  |  |  |  |  |  |  |  | 3732 | 8232 | 8782 | 8737
8412 | 3912 | 3444 | 3417 |  |  |  |  |  |  |  |  |  |  | 5532 | 32 | 582 | 537
8413 | 3913 | 3445 | 3418 |  |  |  |  |  |  |  |  |  |  | 5712 | 212 | 762 | 717
8413 | 3913 | 3445 | 3418 |  |  |  |  |  |  |  |  |  |  | 5730 | 230 | 780 | 735
8414 | 3914 | 3446 | 3419 |  |  |  |  |  |  |  |  |  |  | 3735 | 8235 | 8785 | 8740
8415 | 3915 | 3447 | 3420 |  |  |  |  |  |  |  |  |  |  | 5535 | 35 | 585 | 540
8493 | 3993 | 3461 | 3488 |  |  |  |  |  |  |  |  |  |  | 5715 | 215 | 765 | 720
8494 | 3994 | 3462 | 3489 |  |  |  |  |  |  |  |  |  |  | 5733 | 233 | 783 | 738
8495 | 3995 | 3463 | 3490 |  |  |  |  |  |  |  |  |  |  | 3733 | 8233 | 8783 | 8738
8495 | 3995 | 3463 | 3490 |  |  |  |  |  |  |  |  |  |  | 5533 | 33 | 583 | 538
8496 | 3996 | 3464 | 3491 |  |  |  |  |  |  |  |  |  |  | 5713 | 213 | 763 | 718
8497 | 3997 | 3465 | 3492 |  |  |  |  |  |  |  |  |  |  | 5731 | 231 | 781 | 736
Spreadsheet: 37347d1235331625-remove-duplicates-based-while-keeping-other-rows-in-tact-example-23-
Sheet: Sheet2

KQ437AA#ABA | 1500 | 32 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
[NAME] | 345 | 70 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
KDL-32M4000 | 550 | 8 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
Spreadsheet: 1c8a2868-733f-46f2-aed6-75e9050b4f5d
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
 | 6345.0 Wage Price Index, Australia
 | Table 8b. Ordinary Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2635529C | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2644839C | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2636859L | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2646169R | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2643509V | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2638189X | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2642179W | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | A2640849K | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2639519W | 1997-09-01 00:00:00 | 2012-09-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 682569d1592208232-converting-numeric-value-1-2or3-to-text-sample-for-forum
Sheet: Sheet1

Row Labels | Client | 18/19 Engagement sent and returned | 18/19 Information Collected | 18/19 Invoice sent and paid | 18/19 Prepare for Calculations | 18/19 Calculations updated | 18/19 Report Generation | 18/19 Report Acknowledgement
18 | 2 |  |  |  | 3 | 3 |  | 2
67 | 2 |  |  | 3 | 1 |  |  | 3
75 |  |  |  |  |  |  |  | 3
91 | 2 |  |  | 3 |  |  |  | 3
98 | 2 |  |  | 3 |  |  |  | 3
107 | 3 |  | 3 |  | 3 | 3
159 | 2 | 2
207 | 2 |  | 3 | 3 | 3 | 3 |  | 3
231 | 3
275 | 2 |  |  | 3 | 3 | 3 |  | 2
281 | 2 |  |  | 3 |  |  |  | 3
338 |  |  |  | 3
388 | 3
389 | 2 |  |  | 2
418 | 2 |  |  | 3 | 3 | 3 |  | 3
426 | 2 |  |  | 3
432 | 2 |  |  | 3 |  |  |  | 2
450 | 2 |  |  | 3 | 3 | 2
455 | 2 |  |  | 3 |  |  |  | 3
Spreadsheet: 70205d1270939396-random-soccer-positions-teamrand
Sheet: Sheet1

name |  |  |  | q1 | q2 | q3 | q4
a | 0.5764377579430771 | 2 |  | f | d | d | c
b | 0.338581372559946 | 5 |  | a | c | c | a
c | 0.4189869112299169 | 3 |  | c | e | e | d
d | 0.08178218901423051 | 6 |  | e | b | a | b
e | 0.3942053087578465 | 4 |  | b | f | b | e
f | 0.7016643108103222 | 1
a | 0.2565234681744393 | 6
b | 0.5283079411681009 | 4
c | 0.7236172119186408 | 2
d | 0.8559652529714192 | 1
e | 0.6460764323082833 | 3
f | 0.327968699649956 | 5
a | 0.1919262622179556 | 4
b | 0.1191482425420669 | 5
c | 0.3662170056390905 | 2
d | 0.8285393815082189 | 1
e | 0.2965927922181173 | 3
f | 0.04913937412996394 | 6
a | 0.8091203303758738 | 2
b | 0.5820916214568919 | 4
c | 0.9331413281349685 | 1
d | 0.5923106135259184 | 3
e | 0.2938624380446626 | 5
f | 0.2343310366314981 | 6
Spreadsheet: 155815d1337063830-problem-with-vlookup-using-date-and-time-vlookupexample
Sheet: Sheet1

14.53 |  |  |  | 2002-08-29 00:00:00
18.58 |  |  |  | 2002-09-02 00:00:00
12.17 |  |  |  | 2002-09-03 00:00:00
16.06 |  |  |  | 2002-09-03 00:00:00
10.11 |  |  |  | 2002-09-04 00:00:00
Spreadsheet: 673995d1587625961-get-last-three-non-zero-values-of-a-row-test1
Sheet: Sheet1

 |  | Sales
Name | Last Date Sold | 27/03/2020 | 30/03/2020 | 31/03/2020 | 01/04/2020 | 02/04/2020 | 03/04/2020 | 04/06/2020 | 04/08/2020 | 04/09/2020 | 04/10/2020 | 04/15/2020 | 04/16/2020 | 04/17/2020
[NAME] |  | 0 | 0 | 0 | 0 | 31 | 0 | 0 | 0 | 0 | 12 | 0 | 35 | 0
Carlo |  | 0 | 0 | 24 | 0 | 29 | 40 | 0 | 0 | 0 | 0 | 34 | 0 | 38
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 39 | 0 | 24 | 0 | 110 | 150 | 0 | 102 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 39 | 99 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 48 | 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Taro |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sato |  | 0 | 0 | 0 | 0 | 19 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Piyal |  | 54 | 0 | 35 | 0 | 66 | 67 | 0 | 74 | 0 | 0 | 0 | 0 | 79
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 14 | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Eg. Result to be as follows
 |  | Name | Last Date Sold | 2nd Last Date Sold | 3rd Last Date Sold
 |  | [NAME]
 |  | Carlo
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 224348d1364544795-automatically-copy-a-row-of-sheet1-to-the-next-row-in-sheet2-if-a-cell-in-column-c-xyz-test-book2
Sheet: Master Sheet

DATE | NAME | CODE | JOB [NAME] | PREV BAL | ADVANCE | TOTAL COST | BALANCE
2013-03-09 00:00:00 | Smith | 405 | 5 men's Dress designs |  | 200 | 500
2013-03-10 00:00:00 | Micheal | 404 | 20 kids Garments |  | 600 | 1600
2013-03-15 00:00:00 | [NAME] | 401 | 12 Ladies Garments |  | 2000 | 2400
2013-03-15 00:00:00 | Smith | 405 | 4  men's Dress designs | 300 | 600 | 400
2013-03-18 00:00:00 | [NAME] | 401 | 10 Ladies Garments | 400 | 3000 | 2000
2013-03-21 00:00:00 | dora | 402 | 5 casual wearing |  | 500 | 500
2013-03-23 00:00:00 | [NAME] | 403 | 20 woolen Dresses |  | 5000 | 4000
2013-03-24 00:00:00 | Micheal | 404 | 12 Kids Garments | 1000 | 2000 | 1200
2013-03-29 00:00:00 | Smith | 405 | 9  men's Dress designs | 100 | 700 | 900