tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780814d1652796658-vlookup-based-on-the-dropmenu-data-for-sheet-name-vlookup-based-on-sheet-name
Sheet: Mar'22

Student Code | Name | [NAME] | Mark2 | [NAME] | Total
M001 | [NAME] | 83 | 77 | 70 | 230
M002 | Ram | 56 | 1 | 22 | 79
M003 | Rahul | 50 | 98 | 33 | 181
M004 | [NAME] | 95 | 73 | 87 | 255
M005 | [NAME] | 54 | 24 | 42 | 120
M007 | [NAME] | 6 | 1 | 78 | 85
Spreadsheet: 114034d1309900044-vlookup-not-working-test-3
Sheet: Sheet1

234 |  |  |  | 3-000-011 | 545
545 |  |  |  | 2-001-001 | 65
4563456 |  |  |  | 2-001-002 | 3
65 |  |  |  | 11-000-001 | 231
45647978 |  |  |  | 3-000-012
423 |  |  |  | 2-000-008
213 |  |  |  | 1-000-004 | 213
9768 |  |  |  | 4-001-001 | 234
Spreadsheet: 54283d1254304068-transpose-particular-data-drom-sheet-1-to-sheet-2-example
Sheet: Log1

ODS Print Template
Source URN | 1347943
Area | otherdata
Event Timestamp | otherdata
Date Input | otherdata
From / To Date | otherdata
Classification | Example A
Department | otherdata
Source | otherdata
Score | A11
Text | otherdata
 | otherdata
 | otherdata
 | otherdata
Source URN | 1236692
Area | otherdata
Event Timestamp | otherdata
Date Input | otherdata
From / To Date | otherdata
Classification | Example B
Department | otherdata
Source | otherdata
Score | A11
Text | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
Source URN | 1295429
Area | otherdata
Event Timestamp | otherdata
Date Input | otherdata
From / To Date | otherdata
Classification | Example A
Department | otherdata
Source | otherdata
Score | B21
Text | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
 | otherdata
Source URN | 1305720
Area | otherdata
Event Timestamp | otherdata
Date Input | otherdata
From / To Date | otherdata
Classification | Example C
Department | otherdata
Source | otherdata
Score | E41
Text | otherdata
 | otherdata
 | otherdata
 | otherdata
Spreadsheet: 218906d1362603300-how-to-create-master-list-even-when-dependant-variable-moves-test-for-master
Sheet: Sheet2

 | Name | Color | Height | Year | Points C | Points H | Points Y | Total
 | Cat | Black | 1 | 2
 | Dog | White | 2 | ?
 | Bird | ? | ? | 3
Spreadsheet: 184542d1349289998-convert-a-portion-of-data-from-horizontal-to-vertical-but-not-all-cant-use-transpose-book1
Sheet: Sheet1

Prouduct | Sales Type | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 |  |  |  | Prouduct | Sales Type | Week | Quantity
Product 1 | Commercial | 1 | 2 | 3 | 4 | 5
Product 2 | Commerical | 6 | 7 | 8 | 9 | 10
Product 3 | Consumer | 11 | 12 | 13 | 14 | 15
Spreadsheet: andy_zipper__167__DYNEGY-ICE VOL Apr11
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-11-01 thru Apr-11-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-11-01 | 212515731 |  | Bought | Firm-LD Peak | Cin | Next Day | Apr-12-01 | Apr-12-01 |  |  |  | Cinergy Services, Inc. | 60 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Apr-11-01 | 152950153 |  | Bought | Firm-LD Peak | Comed | Next Day | Apr-12-01 | Apr-12-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 58 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Apr-11-01 | 829910457 |  | Bought | Firm-LD Peak | Ent | Q4 01 | Oct-01-01 | Dec-31-01 |  |  |  | American Electric Power Service Corp. | 47.25 | USD / MWh | 50 | Hourly | 51200 | MWhs | [NAME], R
Apr-11-01 | 162170014 |  | Bought | Firm-LD Peak | Ent | 2001-09-01 00:00:00 | Sep-01-01 | Sep-30-01 |  |  |  | Duke Energy Trading and Marketing LLC | 53.4 | USD / MWh | 50 | Hourly | 15200 | MWhs | [NAME], R
Apr-11-01 | 199603016 |  | Bought | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | American Electric Power Service Corp. | 122.5 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-11-01 | 122250771 |  | Bought | Firm-LD Peak | Ent | Q4 01 | Oct-01-01 | Dec-31-01 |  |  |  | American Electric Power Service Corp. | 47.25 | USD / MWh | 50 | Hourly | 51200 | MWhs | [NAME], R
Apr-11-01 | 253423376 | 30066196239 | Bought | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | El Paso Merchant Energy L.P. | 124 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-11-01 | 117443192 |  | Bought | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | American Electric Power Service Corp. | 123.5 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-11-01 | 193486275 |  | Bought | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | Reliant Energy Services, Inc. | 124.5 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-11-01 | 359467544 |  | Sold | Firm-LD Peak | Cin | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | American Electric Power Service Corp. | 51.35 | USD / MWh | 50 | Hourly | 17600 | MWhs | Dorland , C
Apr-11-01 | 133478391 |  | Bought | Firm-LD Peak | Cin | Bal Week | Apr-13-01 | Apr-13-01 |  |  |  | Northern Indiana Public Service Company | 44.25 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Apr-11-01 | 177451887 |  | Bought | Firm-LD Peak | Cin | Bal Week | Apr-13-01 | Apr-13-01 |  |  |  | Northern Indiana Public Service Company | 44 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Apr-11-01 | 145933845 |  | Sold | Firm-LD Peak | Cin | Bal Month | Apr-13-01 | Apr-30-01 |  |  |  | Duke Energy Trading and Marketing LLC | 47.5 | USD / MWh | 50 | Hourly | 9600 | MWhs | Dorland , C
Apr-11-01  Deals
Spreadsheet: 0f83b65b-0124-4b0b-b53e-1ba33808de23
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | August 2012 to | August 2011 to | market | market | market | market
region | June 2013 | June 2012 | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 574.915 | 500.969 | 541.563 | 529.833 | 563.944 | 536.401
China | 2.645 | 3.216 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 115.778 | 102.422 | 110.541 | 96.454 | 94.81 | 74.05
Pakistan | 15.025 | 13.989 | 15.224 | 17.297 | 19.387 | 16.852
Thailand | 364.396 | 358.197 | 387.642 | 393.464 | 400.977 | 422.132
Vietnam | 73.949 | 20.504 | 21.664 | 15.901 | 41.554 | 17.478
Other | 3.121999999999971 | 2.641000000000037 | 2.921000000000049 | 3.616999999999962 | 3.429461 | 1.938601
EUROPE & FSU | 11.137 | 13.499 | 14.256 | 12.51 | 9.411 | 7.566
Italy | 6.925 | 7.553 | 5.215 | 7.53 | 6.22 | 5.732
Spain | 2.217 | 4.617 | 4.669 | 3.753 | 1.55218 | 0.419
Russia | 0.039 | 0.022 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.112 | 0.039 | 0.039 | 0.009 | 0.126 | 0.43
Other | 1.844000000000001 | 1.268000000000001 | 4.309000000000001 | 1.183999999999999 | 1.480378 | 0.9205439999999996
WESTERN HEMISPHERE | 32.554 | 60.356 | 64.526 | 42.735 | 30.357 | 31.065
Argentina | 4.734 | 2.897 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 4.384 | 29.626 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 9.921 | 13.766 | 16.323 | 17.067 | 15.358 | 18.036
Mexico | 0.916 | 1.006 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 11.541 | 11.844 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 1.058 | 1.217000000000002 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 1.594000000000079 | 0.8749999999999574 | 0.8960000000000008 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.639 | 0.001 | 0 | 0 | 0.645 | 36.591
United Arab Emirates | 0.269 | 0.5 | 0.522 | 3.03 | 4.441 | 2.225
Other | 0.6860000000000793 | 0.3739999999999574 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 620.2 | 575.699 | 621.241 | 588.611 | 609.182 | 614.331
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated August 12, 2013.
Spreadsheet: 201631d1356046284-trying-to-display-another-column-after-data-validation-list-example
Sheet: Sheet1

 |  | a | b
 |  | 1st | a
 |  | 2nd | b
 |  | 3rd | c
 |  | 4th | d
 |  | 5th | e |  | a | 1st | <== drop down box
 |  | 6th | f |  | b |  | <== want a function to display column B without nesting if functions
 |  | 7th | g
 |  | 8th | h
 |  | 9th | i
 |  | 10th | j
 |  | 11th | k
 |  | 12th | l
 |  | 13th | m
 |  | 14th | n
 |  | 15th | o
 |  | 16th | p
 |  | 17th | q
 |  | 18th | r
 |  | 19th | s
 |  | 20th | t
 |  | 21st | u
 |  | 22nd | v
 |  | 23rd | w
 |  | 24th | x
 |  | 25th | y
 |  | 26th | z
Spreadsheet: 126641d1319804494-ranking-with-3-way-tie-breaker-rank
Sheet: Sheet1

 |  | 1 | 15 | 1 | 15 | 1 | 20 | 1 | 10 | 0.5 | -50 | 20 | 0 | 0 | 10 | 0.99 | 10 | 90 | 1
 |  | 1 | 15 | 1 | 15 | 1 | 20 | 1 | 10 | 0.5 | -50 | 20 | 0 | 0 | 10 | 0.991 | 10 | 90 | 1
 |  | 0.927 | 9 | 0.955 | 3 | 0.928 | 12 | 0.7455 | 6 | 1.111 | -111.1 | 12 | 0.045 | -4.5 | 6 | 0.97 | 6 | 48 | 4
 |  | 0.914 | 9 | 0.995 | 15 | 1 | 20 | 0.8409 | 6 | 0.782 | -78.2 | 20 | 0.087 | -8.7 | 0 | 0.969 | 2 | 66 | 3
Spreadsheet: 876854d1723568640-sumifs-by-name-and-eomonth-array-formula-bydate
Sheet: Sheet1

Date | Staff Name | Amount |  |  | Staff Name | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-30 00:00:00 | 2024-06-29 00:00:00 | 2024-07-29 00:00:00 | 2024-08-28 00:00:00 | 2024-09-27 00:00:00 | 2024-10-27 00:00:00 | 2024-11-26 00:00:00 | 2024-12-26 00:00:00 | 2025-01-25 00:00:00 | 2025-02-24 00:00:00 | 2025-03-26 00:00:00 | 2025-04-25 00:00:00 | 2025-05-25 00:00:00 | 2025-06-24 00:00:00
2024-03-01 00:00:00 | [NAME] | 11 |  |  | [NAME] | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-03-02 00:00:00 | [NAME] | 23 |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-03-04 00:00:00 | [NAME] | 23 |  |  | [NAME] | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-04-04 00:00:00 | [NAME] | 100 |  |  | [NAME] | 0 | 123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-04-16 00:00:00 | [NAME] | 123
2024-05-01 00:00:00 | [NAME] | 122
2024-05-01 00:00:00 | [NAME] | 20 |  |  | Staff Name | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-30 00:00:00 | 2024-06-29 00:00:00 | 2024-07-29 00:00:00 | 2024-08-28 00:00:00 | 2024-09-27 00:00:00 | 2024-10-27 00:00:00 | 2024-11-26 00:00:00 | 2024-12-26 00:00:00 | 2025-01-25 00:00:00 | 2025-02-24 00:00:00 | 2025-03-26 00:00:00 | 2025-04-25 00:00:00 | 2025-05-25 00:00:00 | 2025-06-24 00:00:00
 |  |  |  |  | [NAME] | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 0 | 123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 122 | 0 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] | 20 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | *How to use a formula in G2 to produce the result in yellow?
 |  |  |  |  | *How to use a formula in G9 to produce the result in green?
Spreadsheet: 51694d1251315015-template-formula-input
Sheet: Input

 | JAN |  |  |  | FEB |  |  |  | MAR |  |  |  | APR |  |  |  | MAY |  |  |  | JUN |  |  |  | JUL |  |  |  | AUG |  |  |  | SEP |  |  |  | OCT |  |  |  | NOV |  |  |  | DEC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | M | M | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | Q | Q | Q
 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
Spreadsheet: 542660d1507988841-how-to-clean-up-excel-sheet-book2
Sheet: Sheet1

[NAME] of a Murderer.iso
Resting Place (1986).iso
Resting Place (1986).jpg
Resting Place (1986).nfo
RESTING PLACE-poster.jpg
[NAME]
...And Justice for All. (1979).iso
...And Justice for All. (1979).jpg
...And Justice for All. (1979).nfo
...And Justice for All. (1979).png
3 Godfathers (1948).nfo
88 Minutes (2008).iso
88 Minutes (2008).jpg
88 Minutes (2008).nfo
88 Minutes (2008).png
88 MINUTES-disc.png
88 MINUTES-fanart.jpg
88 MINUTES-fanart1.jpg
88 MINUTES-fanart2.jpg
88 MINUTES-landscape.jpg
88 MINUTES-logo.png
88 MINUTES-poster.jpg
AND JUSTICE FOR ALL-fanart1.jpg
AND JUSTICE FOR ALL-fanart2.jpg
AND JUSTICE FOR ALL-poster.jpg
Angels in America (2003).CD1.iso
Angels in America (2003).CD1.jpg
Angels in America (2003).CD2.iso
Angels in America (2003).nfo
ANGELS IN AMERICA PART 2-fanart1.jpg
ANGELS IN AMERICA PART 2-fanart2.jpg
ANGELS IN AMERICA PART 2-poster.jpg
Spreadsheet: d44aa866-e211-4212-a818-1c80d3d71227
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
COUNTRY |  | : | BAHRAIN
SEASON |  | : | 01JAN12 - 31DEC12
CURRENCY |  | : | BHD
TAX RATE |  | :
RATE CODE |  | : |  |  | DE | DE | DE | DE | DE | DE | DE | DE | DE | DE
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ADD | 1 | ADD
GRP | CODE | CAR TYPE (OR SIMILAR) |  |  | DAY | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | MONTH | KM
A | ECAR | TOYOTA ECHO 1.3 [A][AC] |  |  | 11 | 22 | 33 | 44 | 55 | 66 | 66 | 11 | 264 | 0
B | ICAR | NISSAN SUNNY 1.6 [A][AC] |  |  | 13 | 26 | 39 | 52 | 65 | 78 | 78 | 13 | 312 | 0
C | SCAR | MAZDA 6  2.0 [A][AC] |  |  | 15 | 30 | 45 | 60 | 75 | 90 | 90 | 15 | 360 | 0
D | FCAR | TOYOTA CAMRY 2.4 [A][AC] |  |  | 18 | 36 | 54 | 72 | 90 | 108 | 108 | 18 | 432 | 0
F | LDAR | CHEVROLET CAPRICE 3.5L [A][AC] |  |  | 27 | 54 | 81 | 108 | 135 | 162 | 162 | 27 | 648 | 0
L | XFAR | NISSAN PATHFINDER 3.0L [A][AC] |  |  | 31 | 62 | 93 | 124 | 155 | 186 | 186 | 31 | 744 | 0
N | LCAR | LEXUS ES300 [A][AC] |  |  | 41 | 82 | 123 | 164 | 205 | 246 | 246 | 41 | 984 | 0
 | BOOKING REQUIREMENTS |  |  |  |  |  | RATE SPECIFICATION
* | RATE IS AWD DEPENDENT |  |  |  |  | * | RATE INCLUDES   : |  |  | UNLIMITED MILEAGE, CDW, TAX
 |  |  |  |  |  | * | RATE EXCLUDES   : |  |  | ALL OTHER SERVICES NOT INCLUDED ABOVE
* | RESERVATION AND VOUCHER MUST STATE RATE |  |  |  |  | * | MINIMUM RENTAL  : |  |  | AS SHOWN
 | NAME AND RATE CODE
* | CONSULT AVIS RESERVATIONS FOR ONE WAY |  |  |  |  | * | NOTES           : |  |  | NON-WAIVABLE INSURANCE EXCESS CHARGES APPLY
 | RENTAL AVAILABILITY AND FEES |  |  |  |  |  |  |  |  | ADDITIONAL SERVICES THAT MAY APPLY ARE:
 |  |  |  |  |  |  |  |  |  | PETROL/REFUELLING CHARGE, ADDITIONAL INSURANCES/WAIVERS
 |  |  |  |  |  |  |  |  |  | GOVERNMENT SURCHARGES, AIRPORT/CITY SURCHARGES
 |  |  |  |  |  |  |  |  |  | [NAME],SPECIAL EQUIPMENT
 |  |  |  |  |  |  |  |  |  | OTHER (SEE REFERENCE RACK / CONTRACT)
Spreadsheet: 719272d1613581844-how-do-i-only-show-contracts-that-have-both-positive-and-negative-values-associated-book2
Sheet: Sheet1

Contract | Amt | Result
ABC | 5 | Yes
ABC | -5 | Yes
ABC | 5 | Yes
DEF | 10 | No
DEF | 15 | No
GHI | -10 | No
GHI | -15 | No
Spreadsheet: 863404d1710900128-pull-only-jan-data-book6
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Annual | Jan Dividend | Last Dividend of year
c1 | c2 | c3 | c4 | c5 | c52 | c6 | c7 | c8 | c11 | c13 | c113 | c22 | c23
2022-05-16 00:00:00 | p | 154.998 | 8.2428 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.079966
2022-05-31 00:00:00 | d | 1.235 | 8.6478 |  |  |  |  |  |  |  |  |  |  |  | 2023
2022-06-30 00:00:00 | d | 1.386 | 7.7633 |  |  |  |  |  |  |  |  |  |  |  | 2024
2022-07-29 00:00:00 | d | 1.255 | 8.6534
2022-08-31 00:00:00 | d | 1.259 | 8.6894
2022-09-30 00:00:00 | d | 1.501 | 7.3418 |  |  |  |  |  |  |  |  |  |  |  |  | Correct results
2022-10-31 00:00:00 | d | 1.421 | 7.8396
2022-11-30 00:00:00 | d | 1.153 | 7.8231
2022-12-30 00:00:00 | d | 1.204 | 7.5415 |  |  |  |  |  |  |  |  |  |  |  | 2023
2023-01-31 00:00:00 | d | 1.159 | 7.8947 |  |  |  |  |  |  |  |  |  |  |  | 2024
2023-02-28 00:00:00 | d | 1.203 | 7.6559
2023-03-31 00:00:00 | d | 1.198 | 7.7462
2023-04-28 00:00:00 | d | 1.199 | 7.7998
2023-05-31 00:00:00 | d | 1.221 | 7.7068
2023-06-30 00:00:00 | d | 1.19 | 7.9664
2023-07-31 00:00:00 | d | 1.179 | 8.0916
2023-08-31 00:00:00 | d | 1.221 | 7.8706
2023-10-11 00:00:00 | d | 1.329 | 7.2837
2023-11-10 00:00:00 | d | 1.347 | 8.1931
2023-12-12 00:00:00 | d | 1.271 | 7.7262
2023-12-29 00:00:00 | d |  |  |  |  | 9.89
2024-02-14 00:00:00 | d | 1.259 | 7.8554
2024-02-29 00:00:00 | d |  |  |  |  | 9.96
Spreadsheet: 33414448-1cc7-4e35-b717-445c927eb5c1
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
FFTIB | Test | FFTIB | Tin, Blood | Tin, Blood | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Draw blood in a royal blue-top (metal free EDTA) tube. Send  2 mL metal free EDTA whole blood refrigerated. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	 NA | Reference Range: <5.0 ng/mL   Toxic range not established.   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc.
FFTIB | [NAME] | WBEDTAMF | [NAME] EDTA - Metal Free (ERB) |  |  |  | Refrigerated | 14 days
FFTIB | Result | Z1202 | Tin | Tin | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 47cd2429-c5d1-4b65-9e61-dc2835dfaf2e
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
BRUGM | Test | BRUGM | [NAME], IgG & IgM, Serum | [NAME], IgG and IgM, S | BRUGM/89476: Enzyme-Linked Immunosorbent Assay (ELISA) BRUTA/8112: Agglutination |  |  |  | 2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject, Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG SCREEN Negative (reported as positive, negative, or equivocal)  IgM SCREEN Negative (reported as positive, negative, or equivocal) | Monday, Wednesday, Friday; 9:00 a.m. | Same day/1 day Additional days for agglutination test result if reflex testing is required. | 3 days |  | Profile |  |  |  |  | Rochester
BRUGM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BRUGM | Result | 23685 | [NAME], IgG, S | [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24387-3 | [NAME].IgG:ACnc:Pt:Ser:Ord:EIA
BRUGM | Result | 23686 | [NAME], IgM, S | [NAME], IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24388-1 | [NAME].IgM:ACnc:Pt:Ser:Ord:EIA
BRUGM | Result | 23687 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59464-8
BRUGM | Billing Component | BRUGM |  | [NAME], IgM, S |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86622
BRUGM | Billing Component | BRUGM |  | [NAME], IgG, S |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86622
BRUGM | [NAME] | BRUTA | Brucella Total Antibody Confirmation, Agglutination, Serum | [NAME], Agglutination, S | Agglutination | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1:80 | Monday, Wednesday, Friday; 10 a.m. | 2 days | 5 days | 1 | 86622 |  |  | No | Yes
BRUTA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BRUTA | Result | 8112 | [NAME], Agglutination, S | [NAME], Agglutination, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40614-0 | [NAME]:ACnc:Pt:Ser:Ord:Aggl
Spreadsheet: 648916d1573293354-select-vehicle-code-last-date-in-the-month-oldest-time-on-that-date-return-amount-value-last-balance-amount-by-date-and-hour
Sheet: Sheet1

 | Card num. | Date | Hour | [NAME] |  | Card num. | Last BA
 | 56035 | 2019-10-31 00:00:00 | 08:12:11 | 267000 |  | 56035
 | 56035 | 2019-10-29 00:00:00 | 11:35:01 | 481800 |  | 78733
 | 56035 | 2019-10-24 00:00:00 | 18:50:42 | 705000
 | 56035 | 2019-10-22 00:00:00 | 17:45:57 | 928800
 | 56035 | 2019-10-18 00:00:00 | 09:04:00 | 1140600
 | 56035 | 2019-10-15 00:00:00 | 11:57:14 | 1358400
 | 56035 | 2019-10-10 00:00:00 | 11:37:36 | 1576200
 | 78733 | 2019-10-01 00:00:00 | 07:53:15 | 682831
 | 78733 | 2019-10-02 00:00:00 | 20:02:33 | 540543
 | 78733 | 2019-10-02 00:00:00 | 07:59:39 | 618598
 | 78733 | 2019-10-08 00:00:00 | 15:06:48 | 270601
 | 78733 | 2019-10-08 00:00:00 | 09:19:05 | 412351
 | 78733 | 2019-10-09 00:00:00 | 15:09:48 | 20601
 | 78733 | 2019-10-09 00:00:00 | 12:13:23 | 146601
 | 78733 | 2019-10-16 00:00:00 | 09:03:48 | 601
 | 78733 | 2019-10-17 00:00:00 | 08:30:52 | 1219976
 | 78733 | 2019-10-19 00:00:00 | 21:40:09 | 1079441
 | 78733 | 2019-10-23 00:00:00 | 11:24:28 | 937691
 | 78733 | 2019-10-26 00:00:00 | 09:32:16 | 819026
 | 78733 | 2019-10-28 00:00:00 | 18:13:19 | 678005
 | 78733 | 2019-10-31 00:00:00 | 18:28:24 | 398121
 | 78733 | 2019-10-31 00:00:00 | 18:25:13 | 528005
Spreadsheet: 672899d1587057238-formula-to-calculate-the-next-available-date-in-a-column-next-available-date-etaf
Sheet: Sheet1

START DATE | Product ID | Product Type |  |  | Model | Per Week | Next Availble Date
2020-08-10 00:00:00 | 14732 | SPECIAL |  |  | Frameless | 5 |  | <<<<<< Need a formula that looks at the "C" Column based on the F2 and returns the date in Column A that does NOT have a Product Slotted in Column B
2020-08-10 00:00:00 | 14646 | SPECIAL |  |  | Special | 5
2020-08-11 00:00:00 | 14647 | SPECIAL |  |  | Frame-Type | 1 |  | no later date
2020-08-11 00:00:00 | 14897 | FRAMELESS |  |  | WALKING FLOOR | 1 |  | changed dates
2020-08-12 00:00:00 | 14922 | FRAME-TYPE
2020-08-12 00:00:00 | 14767 | FRAMELESS
2020-08-12 00:00:00 | 14898 | FRAMELESS
2020-08-12 00:00:00 | 14932 | SPECIAL
2020-08-13 00:00:00 | 14768 | FRAMELESS
2020-08-13 00:00:00 | 14931 | FRAMELESS
2020-01-14 00:00:00 |  | WALKING FLOOR
2020-08-14 00:00:00 | 14900 | FRAMELESS
2020-08-17 00:00:00 | 14923 | FRAME-TYPE |  |  | Next available date should also scan the product ID to see where a product is not slotted.
2020-08-17 00:00:00 |  | SPECIAL
2020-08-17 00:00:00 |  | SPECIAL
2020-08-17 00:00:00 |  | SPECIAL
2020-08-17 00:00:00 |  | SPECIAL
2019-01-01 00:00:00 |  | WALKING FLOOR
2020-08-20 00:00:00 | 14899 | FRAMELESS
2020-08-21 00:00:00 | 14746 | FRAMELESS
2020-08-21 00:00:00 | 14747 | FRAMELESS
2020-08-21 00:00:00 | 14748 | FRAMELESS
2020-08-21 00:00:00 | 14749 | FRAMELESS
2020-08-21 00:00:00 | 14750 | FRAMELESS
2020-08-24 00:00:00 |  | SPECIAL
2020-08-24 00:00:00 |  | SPECIAL
2020-08-24 00:00:00 |  | SPECIAL
2020-08-25 00:00:00 |  | SPECIAL
2020-08-25 00:00:00 |  | SPECIAL
2020-08-26 00:00:00 |  | WALKING FLOOR
2018-01-01 00:00:00 |  | FRAME-TYPE
2018-01-02 00:00:00 |  | FRAMELESS
2018-01-03 00:00:00 |  | FRAMELESS
2018-01-04 00:00:00 |  | FRAMELESS
2020-08-28 00:00:00 |  | FRAMELESS
2020-08-28 00:00:00 |  | FRAMELESS
Spreadsheet: 220278d1363112306-sumif-sum-one-column-if-values-in-another-column-match-236-sumif
Sheet: Sheet1

VENDOR | COLUMN U | TOTALS |  | Data Validation | TOTAL
Costco | 1004 |  |  | Costco |  | <<SUMIF
Sams | 1785
Walmart | 608
Target | 1737
Snapon | 1155
CVS | 1614
Walgreens | 532
[NAME] | 1618
Costco | 936
BPS | 1347