tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165fbd04-378a-44f4-a48d-7822080839d0
Sheet: EPR Rev Stats

Supplemental Data (Unaudited)
Revenue Metrics
First Quarters Ended December 31, | 2013 | 2012
In millions, unless otherwise noted
Gaming Operations
Revenues | 223 | 242.6
North America | 191.6 | 208.6
International | 31.4 | 34
Gross margin | 0.61 | 0.63
North America | 0.59 | 0.62
International | 0.72 | 0.69
Installed base (units '000) | 54.3 | 56.8
North America | 41.3 | 43
International | 13 | 13.8
Yield (average revenue per unit per day - $0.00) | 44.99 | 46.8
Product Sales
Revenues | 243.6 | 234.8
North America | 170 | 158.9
International | 73.6 | 75.9
Machines | 167 | 157.5
North America | 118 | 101.8
International | 49 | 55.7
Non-machine | 76.6 | 77.3
North America | 52 | 57.1
International | 24.6 | 20.2
Gross margin | 0.52 | 0.53
North America | 0.53 | 0.56
International | 0.5 | 0.48
Machine units recognized ('000) | 12.8 | 10.7
North America | 9.6 | 7.2
International | 3.2 | 3.5
Machine units shipped ('000) [includes units where revenues deferred] | 13 | 9.3
North America | 9.8 | 6.8
New | 3.7 | 1.7
Replacement | 6.1 | 5.1
International | 3.2 | 2.5
New | 0.7 | 0.8
Replacement | 2.5 | 1.7
Machine ASP ('000) | 13.2 | 14.8
North America | 12.3 | 14.1
International | 15.3 | 16.1
Interactive
Revenues | 74.6 | 52.9
North America | 65.8 | 41.9
International | 8.8 | 11
Social Gaming | 64.8 | 41.3
North America | 64.8 | 41.3
International | 0 | 0
IGTi | 9.8 | 11.6
North America | 1 | 0.6
International | 8.8 | 11
Gross margin | 0.63 | 0.58
North America | 0.62 | 0.6
International | 0.66 | 0.5
DoubleDown average user statistics*
DAU (Daily active users) ('000) | 1716 | 1462
MAU (Monthly active users) ('000) | 6198 | 4931
Bookings per DAU ($0.00) | 0.42 | 0.31
*as a single application with multiple games, active users equal unique users
Spreadsheet: 798422d1664468033-using-conditional-formatting-to-show-status-of-shipments-friday-shipment-status-tora-v1-
Sheet: Sheet1

 | Shipping  Status Report - A3PHA
row | Product | Manager | Scheduled | Required by | Status | Comment
 | Oranges | [NAME] | 2022-10-10 00:00:00 | 2022-10-30 00:00:00
 | Bananas | [NAME] | 2022-09-13 00:00:00 | 2022-09-30 00:00:00
 | Apples | JL Avery / S. Zacher | 2022-11-18 00:00:00 | 2022-12-07 00:00:00
 | Grapes | [NAME]  /  [NAME] | 2022-09-30 00:00:00 | 2022-10-30 00:00:00
 | Pears | C. Barnhill / V. Agarwal | 2022-12-31 00:00:00 | 2023-01-30 00:00:00
Spreadsheet: 22b66522-a0b1-4daf-809a-995da8f7ee28
Sheet: Sheet1

Financial Highlights - AmBev Consolidated | Unnamed: 1 | Unnamed: 2 | % As | %
R$ million | 1Q09 | 1Q10 | Reported | Organic
Total volumes | 37268.16655086616 | 40926.55474770147 | 0.09816388986676028 | 0.08995903225503304
Beer | 26314.87154198546 | 29399.28819813865 | 0.1172119214502716 | 0.1164379864543318
CSD and NANC | 10953.2950088807 | 11527.26654956282 | 0.05240172388461772 | 0.02634435943231427
Net sales | 5655.683 | 6121.422 | 0.08234885158874694 | 0.1645999446834917
Gross profit | 3758.548 | 4122.396999999999 | 0.09680573455493957 | 0.1727742441241658
Gross margin | 0.6645612917131317 | 0.6734378057908765 | 90 | 50
EBITDA | 2800.345 | 2773.95 | -0.009425624342714878 | 0.05049113197259865
EBITDA margin | 0.495138252974928 | 0.453154512137866 | -420 | -490
Normalized EBITDA | 2582.921 | 2806.538 | 0.08657523787990429 | 0.1531494352340793
Normalized EBITDA margin | 0.4566947970740227 | 0.4584781117851375 | 10 | -40
Net Income - AmBev holders | 1588.656 | 1650.195999999999 | 0.03873714636774661
Normalized Net Income - AmBev holders | 1371.232 | 1716.615 | 0.2518778733285096
No. of share outstanding (millions) | 613.88010662 | 616.43423662
EPS (R$/shares) | 2.58789294989062 | 2.67700251213863 | 0.03443324896873223
Normalized EPS | 2.233713041378634 | 2.784749609970485 | 0.2466908498916922
Spreadsheet: 127167d1320191928-time-formated-cells-stay-blank-if-zero-swimtimes
Sheet: Times

Venue of meet
Date of meet |  |  |  |  |  |  |  |  | Don't know | 2010-12-13 00:00:00 | 2011-06-19 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00
Event | Offical PB's | Training PB's | county accepted times | Difference from county accepted times | Difference from county accepted times in seconds |  | Difference from county concidered times | Difference from club record
25 free
50 free |  |  | 00:00:33.300000 |  |  | 00:00:36 |  |  | 00:00:40.120000 | 00:00:44.800000 | 00:00:38.850000 |  | 00:00:38.120000
100 free |  |  | 00:01:11.300000 |  |  | 00:01:17 |  |  | 00:01:51.030000
200 free |  |  | 00:02:33.500000 |  |  | 00:02:45.800000 |  |  | 00:03:48.670000
400 free |  |  | 00:05:19.200000 |  |  | 00:05:45.300000
800 free
25 back
50 back |  |  | 00:00:37.700000 |  |  | 00:00:40.700000 |  |  | 00:00:48.200000 | 00:00:52.800000 | 00:00:45.220000 | 00:00:43.420000
100 back |  |  | 00:01:19.400000 |  |  | 00:01:25.400000 |  |  | 00:01:56.560000
200 back |  |  | 00:02:49.200000 |  |  | 00:03:02.800000 |  |  | 00:04:17.290000
400 back
800 back
25 breast
50 breast |  |  | 00:00:42.200000 |  |  | 00:00:45.600000 |  |  | 00:00:52.340000 | 00:01:00.440000 | 00:00:51.930000
100 breast |  |  | 00:01:30.600000 |  |  | 00:01:37.900000 |  |  | 00:02:31.440000
200 breast |  |  | 00:03:14.300000 |  |  | 00:03:29.800000
400 breast
800 breast
25 fly
50 fly |  |  | 00:00:36.400000 |  |  | 00:00:39.300000 |  |  | 00:00:44.480000 | 00:00:50.580000 | 00:00:42.520000 |  | 00:00:41.380000
100 fly |  |  | 00:01:19.100000 |  |  | 00:01:25.400000
200 fly |  |  | 00:02:53.500000 |  |  | 00:03:07.300000
400 fly
800 fly
100 IM |  |  | 00:01:22.900000 |  |  | 00:01:39.600000 |  |  | 00:01:47.670000 | DQ
200 IM |  |  | 00:02:52.900000 |  |  | 00:03:06.700000 |  |  | 00:04:28.530000
400 IM |  |  | 00:06:04.700000 |  |  | 00:06:33.900000
Spreadsheet: 26269d1218251518-gathering-and-listing-data-from-another-sheet-master-file
Sheet: Loadout

MPLO  number |  |  | 558 |  |  |  |  |  |  |  | ED Numbers
Container  Number |  |  | MSKU 3402539
Contract Number |  |  | SM 1091
[NAME] Weight |  |  | 20221
Packaging Weight
Croft's Weight
[NAME]    From |  |  | 236-5 |  | To |  | 237-2
Production Start  Date |  |  | 2008-07-30 00:00:00 |  | Finish Date |  | 2008-08-06 00:00:00
[NAME]
Comments
Spreadsheet: bdde7a63-b62e-4a37-b789-eb304f7fd2ae
Sheet: Sheet1

 | Student Name:
1 | Chouinard, Kurt
2 | Moniz, [NAME]
3 | [NAME], [NAME]
4 | Botelho, [NAME]
5 | [NAME], [NAME]
6 | [NAME], [NAME]
7 | Dutra,[NAME]
8 | Rita, Jeffery
9 | Brol, [NAME]
10 | Allard, [NAME]
11 | St.Amand, Becky
12 | Spillane, [NAME]
13 | [NAME], [NAME]
14 | Lavigne, [NAME]
15 | Torres, [NAME]
16 | Daoust, [NAME]
17 | Staney, Pam
18 | [NAME], [NAME]
19 | Cimma, Todd
20 | Moniz, Serge
21 | [NAME], [NAME]
22 | Murphy, [NAME]
23 | Woods, [NAME]
24 | Rose, [NAME]
25 | Lussier, [NAME]
26 | Bohning, [NAME]
27 | [NAME], [NAME]
28 | Hennessey, [NAME]
29 | [NAME], George
30 | Sousa, Nuno
31 | Coutu, Bessie
Spreadsheet: mary_fischer__25635__31R
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031R
COMPANY NAME    Limbach Company Holding Company
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 44888d1243611665-printing-only-filled-cells-print-active-cells-only
Sheet: Four

 | To Print Active Cells Only
Member | Name | Age
1 | Fred | 62 |  | So once the previous is all done push "OK"; the system is now recording
2 | [NAME] | 35 |  | everything you do, so it's a good idea to now what you actually want before
3 | [NAME] | 31 |  | starting.
4 | [NAME] | 45 |  | With this case you should select the filter below "Name" -(NonBlanks)- then
5 |  |  |  | push the print button (will start to print) then select (All), bring the full list back.
6 | Betty | 67 |  | Go to Tools-Stop Recording.
7 | [NAME] | 87
8 | Toby | 34 |  | Now if you were to hold down the Ctrl and "z" it should go through all the
9 |  |  |  | steps you have recorded.
10
11 |  |  |  | Insert another row.
12 | [NAME] | 23
13 | [NAME] | 21 |  | Go to the "Tool Bar" drop down box at the top right hand side of your screen,
14 | [NAME] | 34 |  | Select Add Remove Buttons-Customize-Commands-Forms on the left and then
15 | [NAME] | 56 |  | button on the right.
16 |  |  |  | Drag and [NAME] the symbol to your Tool Bar.
17
18 |  |  |  | Now click on the symbol and then click again were you want the button.
19 |  |  |  | It doesn't matter if it is not exactly were you want it as you can resize and
20 |  |  |  | relocate it to were ever you want after.
21 |  |  |  | You will be asked to assign a macro, select "MacroPRINTACTIVECELLSONLY".
22
23
24
25
Spreadsheet: 767037d1644252402-sorting-by-a-column-with-formulas-converted-to-table-aligw
Sheet: Sheet1

 | DATA |  |  |  |  |  |  |  |  |  | Desired outcome
 | items | count 1 | count 2 |  |  | items | count 1 totals | count 2 totals |  |  | items | count 1 totals | count 2 totals
 | a | 1 | 0 |  |  | e |  |  |  |  | e | 8 | 7
 | b | 0 | 2 |  |  | b |  |  |  |  | b | 6 | 4
 | c | 1 | 4 |  |  | g |  |  |  |  | g | 5 | 2
 | d | 0 | 5 |  |  | f |  |  |  |  | f | 4 | 0
 | e | 2 | 1 |  |  | a |  |  |  |  | a | 2 | 5
 | f | 4 | 0 |  |  | c |  |  |  |  | c | 1 | 4
 | g | 5 | 1 |  |  | d |  |  |  |  | d | 0 | 6
 | a | 1 | 5
 | d | 0 | 1
 | e | 1 | 0
 | g | 0 | 1
 | b | 2 | 0
 | b | 4 | 2
 | e | 5 | 6
Spreadsheet: 274090d1383005589-why-does-simple-summation-give-value-scrathpad
Sheet: Sheet1

 |  |  | 0.01212719444896146
 |  |  | 0.00562732852773029
 |  | 0.008311000044263477
0.1338044855945915 | 0.07991111630773494 |  | 0.003403254664441718
 |  | -0.01243814225568888
 |  | 0.09074234288490456 | 0.02072164214836041
-0.1361073267063475 | -0.09494281634339993 | -0.02288832795848864 | 0.009592335219801797
 |  | -0.04643447254019437 | -0.06244612967457421
 |  | 0.004695574255502529 | 0.009904160389279338
 | 0.08980041528504519 | -0.02788352852958701 | 0.003637122076697691
 | 0.1650373855998102 | -0.02695506213862854
 |  | -0.005542120644952016
-0.1832524475187794 | -0.1448549255015284 |  | -0.09208435097433393
 |  | 0.007630429302096069
 |  | -0.02315132228128113 | 0.009929638263196462
 |  |  | -0.01146799281517113
Spreadsheet: larry_campbell__20990__PCB Graphs
Sheet: TOP A6

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Laboratory
PGE A6 |  |  | 1998-10-30 00:00:00 |  |  | None |  | Sherwood
Line 300 A Scrubber |  |  | 1999-01-08 00:00:00 |  |  | None |  | Sherwood
that [NAME] |  |  | 1999-05-27 00:00:00 |  |  | 27 |  | Sherwood
flows through |  |  | 1999-07-03 00:00:00 |  |  | 78 |  | Sherwood
 |  |  | 1999-07-04 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 1999-08-31 00:00:00 |  |  | 55 |  | Sherwood
 |  |  | 1999-09-02 00:00:00 |  |  | 69 |  | Sherwood
 |  |  | 1999-09-06 00:00:00 |  |  | 67 |  | Sherwood
 |  |  | 1999-09-12 00:00:00 |  |  | 71 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 779591d1651882890-textjoin-and-index-match-returning-multiple-rows-excel-helo-jjqq-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Textjoin & index match returning multiple rows (excelforum.com)
 |  |  |  |  | Legend
 |  |  |  |  | 1 | Occupying apartment
 |  |  |  |  | R | Not occupying apartment
TABLE 1: ASSIGNMENTS |  |  |  |  | TIMELINE
Tenant | Apartment | Earliest Date | Upcoming
[NAME] | Apt 1 |  |  |  | 1 | 1 | 1 | 1 | R | R | R
[NAME] | Apt 1 |  |  |  | R | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | Apt 2 |  |  |  | 1 | 1 | 1 | 1 | R | R | R
[NAME] | Apt 3 |  |  |  | R | R | 1 | 1 | 1 | 1 | 1
[NAME] | Apt 4 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | Apt 4 |  |  |  | R | R | R | R | R | R | 1
[NAME] | Apt 4 |  |  |  | R | R | R | 1 | 1 | 1 | 1
TABLE 2: SUMMARY
Apartment | Current tenants | Upcoming tenants
Apt 1
Apt 2
Apt 3
Apt 4
Spreadsheet: joe_parks__14572___2
Sheet: feb

Sold gas to TXU Energy Trading at the prices below
 | Date |  | Volume |  | Price |  | Total
 | 2002-02-01 00:00:00 |  | 13000 |  | 2.05
 | 2002-02-02 00:00:00 |  | 13000 |  | 2.11
 | 2002-02-03 00:00:00 |  | 13000 |  | 2.11
 | 2002-02-04 00:00:00 |  | 13000 |  | 2.11
 | 2002-02-05 00:00:00 |  | 13000 |  | 2.05
 | 2002-02-05 00:00:00 |  | 22000 |  | 2.03
 | 2002-02-06 00:00:00 |  | 45000 |  | 2.05
 | 2002-02-07 00:00:00 |  | 13000 |  | 2.01
 | 2002-02-08 00:00:00 |  | 45000 |  | 2.04
 | 2002-02-09 00:00:00 |  | 13715 |  | 2.07
 | 2002-02-09 00:00:00 |  | 31285 |  | 2.05
 | 2002-02-10 00:00:00 |  | 13715 |  | 2.07
 | 2002-02-10 00:00:00 |  | 31285 |  | 2.05
 | 2002-02-11 00:00:00 |  | 13715 |  | 2.07
 | 2002-02-11 00:00:00 |  | 31285 |  | 2.05
 | 2002-02-12 00:00:00 |  | 45000 |  | 2.08
 | 2002-02-13 00:00:00 |  | 45000 |  | 2.24
 | 2002-02-14 00:00:00 |  | 45000 |  | 2.21
 | 2002-02-15 00:00:00 |  | 45000 |  | 2.1
 | 2002-02-16 00:00:00 |  | 45000 |  | 2
 | 2002-02-17 00:00:00 |  | 45000 |  | 2
 | 2002-02-18 00:00:00 |  | 45000 |  | 2
 | 2002-02-19 00:00:00 |  | 45000 |  | 2
 | 2002-02-20 00:00:00 |  | 45000 |  | 2.08
 | 2002-02-21 00:00:00 |  | 45000 |  | 2.27
 | 2002-02-22 00:00:00 |  | 45000 |  | 2.19
 | 2002-02-23 00:00:00 |  | 45000 |  | 2.16
 | 2002-02-24 00:00:00 |  | 45000 |  | 2.16
 | 2002-02-25 00:00:00 |  | 45000 |  | 2.16
 | 2002-02-26 00:00:00 |  | 45000 |  | 2.32
 | 2002-02-27 00:00:00 |  | 45000 |  | 2.32
 | 2002-02-28 00:00:00 |  | 45000 |  | 2.3
 | Totals
Spreadsheet: 547918d1510809123-index-and-match-need-particular-given-text-to-arrive-from-a-range-index-match
Sheet: Dropdown

 | Status |  |  |  | State |  |  | Level |  |  | Accredited
 | FIN | Finished |  |  | AP | [NAME] |  | Full | Full NABH |  | FIN | Yes
 | HA | Held by Acme |  |  | BI | Bihar |  | EL | Entry Level |  | NY | No
 | HC | Held by client |  |  | GU | Gujarath |  | PL | Progress Level |  | UP | Under process
 | Inc | Incomplete |  |  | KA | Karnataka |  | AMC-Full
 | NA | Not applicable |  |  | KE | Kerala |  | AMC-EL
 | PEN | Pending |  |  | MH | Maharashtra |  | AMC-PL
 | PP | Pending for payment |  |  | MP | Madhya Pradesh |  | NABL
 | WIP | Work in progress |  |  | OR | Odisha |  | Ethics | Ethics Committee Stds
 | YTS | Yet to start |  |  | PU | Puduchery |  | Allo | Allopathic Clinic Stds
 |  |  |  |  | TE | Telangana |  | JCI
 |  |  |  |  | TN | Tamilnadu |  | PC | Polyclinic
 | Status_IV | Status_V |  |  |  |  | AMC
 | Imp-WIP | MA-WIP |  |  |  |  | Level
 | Imp-PEN | MA-PEN |  |  |  |  | AMC-Full
 | Imp-FIN | MA-FIN |  |  |  |  | AMC-EL
 | IA-WIP | FIN |  |  |  |  | AMC-PL
 | IA-PEN | HA
 | IA-FIN | HC
 | AF-WIP | PP
 | AF-PEN | NA
 | AF-FIN | YTS
 | NCC-WIP | NCC-WIP
 | NCC-FIN | NCC-FIN
 | FIN | AF-WIP
 | HA | AF-PEN
 | HC | AF-FIN
 | PP | CR-WIP | submission of Closure Report to NABH along with evidences of closing
 | NA | CR-FIN | submission of Closure Report to NABH along with evidences of closing
 | YTS
Spreadsheet: 859310d1707739412-formula-to-calculate-dependent-on-closest-two-variables-in-columns-test3-3-aligw
Sheet: Sheet1

Manually Calculated
 | Variable 1 |  |  |  | Variable 2 |  |  | Variable 3 | Total
Test 1 | 100 | 68 | 65 | 55 | 95 | 83 | 99 | 80 | 97.5
Test 2 | 100 | 94 | 54 | 100 | 96 | 90 | 98 | 95 | 96
Test 3 | 100 | 92 | 63 | 98 | 90 | 80 | 52 | 98.5 | 100
Test 4 | 100 | 55 | 81 | 92 | 95 | 59 | 60 |  | 97.5
Test 5 | 100 | 52 | 75 | 92 |  | 58 | 89 | 95 | 97.5
Test 6 |  | 85 | 98 | 84 | 90 | 74 | 53 | 100 | 95
Test 7 | 100 | 80 | 54 | 59 |  | 67 | 79 |  | 100
Current Formula
 | Variable 1 |  |  |  | Variable 2 |  |  | Variable 3 | Total
Test 1 | 100 | 68 | 65 | 55 | 95 | 83 | 99 | 80
Test 2 | 100 | 94 | 54 | 100 | 96 | 90 | 98 | 95
Test 3 | 100 | 92 | 63 | 98 | 90 | 80 | 52 | 98.5
Test 4 | 100 | 55 | 81 | 92 | 95 | 59 | 60
Test 5 | 100 | 52 | 75 | 92 |  | 58 | 89 | 95
Test 6 |  | 85 | 98 | 84 | 90 | 74 | 53 | 100
Test 7 | 100 | 80 | 54 | 59 |  | 67 | 79
Spreadsheet: 721741d1614849406-formula-amendment-replacement-to-show-duplicates-as-well-as-singularities-book1
Sheet: Sheet1

12
12
12
13
50
50
50
6
41
41
41
8
57
57
78
79
1
Spreadsheet: 139626d1328346850-how-can-i-insert-date-of-today-in-column-c-when-i-enter-data-in-column-b-insert-today-date
Sheet: Sheet1

SN | NameNep | Gender | DateofIssu | NepaliDate | EnglishDate | Signedby
1 | Deepak | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
2 | Sita | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
3 | [NAME] | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
4 | Hari | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
5 | Bina | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
6 | [NAME] | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
7 | [NAME] | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
8 | Ganesh | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
 | [NAME] |  | 2012-02-04 00:00:00 |  |  |  | I want to keep this date as a my record
 | Nitin |  | 2012-02-04 00:00:00
 | I want to enter only name but I don't enter date column. I would like to display automatically date when I enter in column B
 | [NAME] |  | 2012-02-04 00:00:00
 | Nitin |  | 2012-02-04 00:00:00
 | Hari |  | 2012-02-05 00:00:00 |  |  |  | [NAME] I would like to disply like this
 | Sita |  | 2012-02-05 00:00:00
Spreadsheet: 95e31f7f-8f15-4c0b-894e-67f2bd9c105b
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
PROLX | Test | PROLX | Fluphenazine (Prolixin), Serum | Fluphenazine (Prolixin) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 3 mL sodium heparin plasma refrigerated in a plastic vial.  Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 3 mL of serum refrigerated in a plastic vial. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 0.5-20 ng/mL  Expected range for low dose therapy:  0.5-2.25 ng/mL Expected range for high dose therapy:  5.0-20.0 ng/mL Some patients respond well to the lower range of therapy while other patients require the higher concentrations to achieve desired therapeutic effects.   Test Performed by: Medtox Laboratories, Inc.                               402 W. County Road D                               St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
PROLX | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
PROLX | Result | [NAME] | Fluphenazine | Fluphenazine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 491382d1480442221-months-since-last-purchase-and-reseller-count-copy-of-copy-of-months-since-purchase-and-reseller-count
Sheet: Months since purchase

Month | Reseller | Product | Qty |  |  | Reseller | Months since last purchase
2016-05-01 00:00:00 | Customer 1 | Product 2 | 10 |  |  | Customer 1 |  |  | =DATEDIF(LARGE(IF($B$2:$B$30=F2,$A$2:$A$30),1),TODAY(),"ym")
2016-05-01 00:00:00 | Customer 1 | Product 2 | 30 |  |  | Customer 2
2016-05-01 00:00:00 | Customer 2 | Product 1 | 2 |  |  | Customer 3
2016-05-01 00:00:00 | Customer 3 | Product 1 | 4 |  |  | Customer 4
2016-06-02 00:00:00 | Customer 2 | Product 1 | 54 |  |  | Customer 5
2016-06-02 00:00:00 | Customer 2 | Product 4 | 1 |  |  | Customer 6
2016-06-02 00:00:00 | Customer 4 | Product 3 | 23
2016-06-02 00:00:00 | Customer 5 | Product 1 | 15
2016-06-02 00:00:00 | Customer 5 | Product 2 | 3
2016-06-02 00:00:00 | Customer 5 | Product 6 | 3
2016-07-03 00:00:00 | Customer 1 | Product 1 | 20
2016-07-03 00:00:00 | Customer 4 | Product 1 | 10
2016-07-03 00:00:00 | Customer 4 | Product 3 | 5
2016-07-03 00:00:00 | Customer 6 | Product 1 | 7
2016-08-04 00:00:00 | Customer 2 | Product 1 | 81
2016-08-04 00:00:00 | Customer 3 | Product 5 | 10
2016-09-05 00:00:00 | Customer 1 | Product 3 | 20
2016-09-05 00:00:00 | Customer 1 | Product 6 | 3
2016-09-05 00:00:00 | Customer 1 | product 6 | 7
2016-09-05 00:00:00 | Customer 4 | Product 2 | 1
2016-09-05 00:00:00 | Customer 4 | Product 3 | 8
2016-09-05 00:00:00 | Customer 6 | Product 1 | 11
2016-09-05 00:00:00 | Customer 6 | Product 4 | 17
2016-09-05 00:00:00 | Customer 6 | Product 4 | 10
2016-10-06 00:00:00 | Customer 2 | Product 2 | 15
2016-10-06 00:00:00 | Customer 2 | Product 3 | 20
2016-10-06 00:00:00 | Customer 3 | Product 1 | 61
2016-10-06 00:00:00 | Customer 5 | Product 1 | 2
2016-10-06 00:00:00 | Customer 5 | Product 2 | 5
Spreadsheet: 772613d1647400719-compare-2-columns-and-return-missing-text-values-excel_book1-1-
Sheet: Sheet1

 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-05 00:00:00 | 2022-03-06 00:00:00 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00
MU | MU | B | A | B | C
F | B | B | C | B | A
RMIT | C | B | C | A | C
CASS | A | B | C | A | C
E | A | A | D | D | B
F | D | C | D | D | B
G | B | C | E | C | D
H | B | D | B | C | E
I | E | D | B | E | A
J | C | D | B | F | A
NEW
Top 10 Occurrence
Zero Occurrence
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet37

Count of Status | Column Labels
Row Labels | Didn't join after selection | Duplicate | Feedback Pending | No Show | Not Interested | Not Suitable | Not Yet Scheduled | Offer Accepted | [NAME] | Rejected (1st) | Rejected (2nd) | Rejected (Final) | Rejected-Online Test | Scheduled | Grand Total
2020 | 1 | 2 |  | 4 | 9 | 2 |  | 1 | 2 | 13 | 2 |  |  |  | 36
2021 |  | 16 | 1 | 32 | 27 | 67 | 13 | 9 | 4 | 67 | 8 | 4 | 25 | 2 | 275
Jan |  | 3 |  | 2 | 2 | 7 |  |  | 1 | 11 | 1 |  |  |  | 27
Feb |  | 1 |  | 5 | 2 | 3 |  |  |  | 8 | 2 |  |  |  | 21
Mar |  | 1 |  | 2 | 4 | 11 |  | 1 |  | 9 | 1 |  | 5 |  | 34
Apr |  | 6 |  | 4 | 7 | 18 |  | 4 |  | 12 | 1 | 3 | 8 |  | 63
May |  |  |  | 3 | 1 | 1 |  | 1 |  | 1 |  | 1 | 1 |  | 9
Jun |  | 1 |  | 2 | 2 | 1 |  |  | 1 | 4 | 1 |  | 3 |  | 15
Jul |  | 2 |  | 9 | 8 | 16 | 9 | 2 | 1 | 14 | 2 |  | 6 |  | 69
Aug |  | 2 | 1 | 5 | 1 | 10 | 4 | 1 | 1 | 8 |  |  | 2 | 2 | 37
Grand Total | 1 | 18 | 1 | 36 | 36 | 69 | 13 | 10 | 6 | 80 | 10 | 4 | 25 | 2 | 311