tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 700591d1603262036-return-a-filtered-unique-records-without-no-blanks-and-duplicates-return-a-unique-filtered-list-with-no-blanks
Sheet: Sheet1

 |  |  |  |  |  |  |  | Unique records without duplicates and blanks
Consumer | BS Cont | Activity | BS Code | Code | Liability | Certified |  | Consumer | BS Cont | Activity | BS Code | Code | Liability | Certified
ABC | RI15121 | 1212 | 1255000020 | 1505050110 | 650000
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100
ABC | RI15121 | 1212 | 1255000020 | 1505050110 | 650000
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000
GHF | RW129190 | 1563 | 55000050 | 12719050165 | 1777087
LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096
OPO | RW126569 | 1245 | 55000013 | 72319050149 | 4245286
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000
SDF | RWA23210 | 1000 | 57110055 | 78919010161 | 172443.13
QWE | RWA23652 | 1563 | 51100101 | 78919010161 | 185415.65
LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096
Spreadsheet: 820997d1678378969-countifs-with-one-parameter-covering-multiple-columns-qmc-datix-data
Sheet: Tray List Details

 |  |  |  |  |  |  | Checks / Details Entered |  |  |  |  |  | Faults
Date | Bar/Lot | Bar | [NAME] | Specialism | Items | Campus | Theatre | [NAME] | Post Check | User Details | Theatre Details | Patient Details | 1 on Sheet | 2  on Sheet | 3  on Sheet | 4  on Sheet | 5  on Sheet | File Name
2023-03-01 00:00:00 | 800450552250101615300026 | 8004505522501016153 |  |  |  |  | 25 | No | No | Yes | Yes | Yes
2023-03-02 00:00:00 | 8004505522501011521 |  |  |  |  |  | 2 | Yes | No | Yes | Yes | Yes
2023-03-02 00:00:00 | 8004505522501022022 |  |  |  |  |  | 20 | Yes | No | Yes | Yes | Yes
2023-03-03 00:00:00 | 8004505522501000798 |  |  |  |  |  | 26 | No | No | Yes | Yes | Yes
2023-03-03 00:00:00 | 8004505522501029454 |  |  |  |  |  | 4 | No | No | Yes | Yes | Yes
2023-03-03 00:00:00 | 8004505522501037077 |  |  |  |  |  | 20 | Yes | No | Yes | Yes | Yes
2023-03-06 00:00:00 | 8004505522500003620 |  |  |  |  |  | 5 | No | No | Yes | Yes | Yes
2023-03-06 00:00:00 | 8004505522501036868 |  |  |  |  |  | 2 | Yes | No | Yes | Yes | Yes
2023-03-06 00:00:00 | 8004505522501036111 |  |  |  |  |  | 3 | No | No | Yes | Yes | Yes
2023-03-07 00:00:00 | 8004505522501004181 |  |  |  |  |  | 20 | Yes | Yes | Yes | Yes | Yes
2023-03-07 00:00:00 | 8004505522501011525 |  |  |  |  |  |  | Yes | No | Yes | No | Yes
2023-03-07 00:00:00 | 8004505522501036979 |  |  |  |  |  | 7 | No | No | Yes | Yes | Yes
2023-03-07 00:00:00 | 8004505522501041184 |  |  |  |  |  | 18 | No | No | Yes | Yes | Yes
2023-03-07 00:00:00 | QMC000001218 |  |  |  |  |  | 1 | Yes | Yes | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501001453 |  |  |  |  |  | 9 | Yes | No | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501017594 |  |  |  |  |  | 7 | Yes | Yes | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501013263 |  |  |  |  |  | 24 | Yes | Yes | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501023173 |  |  |  |  |  | 6 | Yes | No | Yes | Yes | No
2023-03-08 00:00:00 | 8004505522501034878 |  |  |  |  |  | 4 | Yes | Yes | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501036324 |  |  |  |  |  | 11 | No | No | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501033881 |  |  |  |  |  | 7 | No | No | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501035847 |  |  |  |  |  | 15 | No | No | Yes | Yes | Yes
2023-03-08 00:00:00 | 8004505522501043163 |  |  |  |  |  | [NAME] | No | No | No | Yes | Yes
2023-03-08 00:00:00 | QMC000000726 |  |  |  |  |  | 2 | Yes | No | Yes | Yes | Yes
2023-03-08 00:00:00 | QMC000001393 |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes
2023-03-08 00:00:00 | [NAME] |  |  |  |  |  | 6 | Yes | No | Yes | Yes | Yes
2023-03-09 00:00:00 | 800450552250000391200001 |  |  |  |  |  | 5 | No | No | Yes | Yes | Yes
2023-03-09 00:00:00 | 8004505522501015305 |  |  |  |  |  | 7 | No | No | Yes | Yes | Yes
2023-03-09 00:00:00 | 8004505522500002422 |  |  |  |  |  | 19 | Yes | No | Yes | Yes | Yes
2023-03-09 00:00:00 | QMC000010059 |  |  |  |  |  | 5 | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 225922d1365177313-second-drop-down-dependent-list-in-b2-under-sheet-tab-c-2nd-drop-down-dependant-list
Sheet: Report

Supplier Code Search 1 | stocod | Description | Centres Supplier Code Search 2 | Centres Supplier Code Search 3 | Centres Supplier Code Search 4 | Ltd Supplier Code Search 1 | Ltd Supplier Code Search 2 | Ltd Supplier Code Search 3 | Ltd Supplier Code Search 4 | LB Supplier Code Search 1 | LB Supplier Code Search 2 | LB Supplier Code Search 3 | LB Supplier Code Search 4 | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4
AE006 | MA15920Y |  | AM001 | AM048
source from code drop down | source data column C
drop down list using pivot table | require drop down  based on change in cell A2????
Spreadsheet: 159904d1338898956-automatically-remove-contents-of-a-cell-cwcounttemplate
Sheet: CFL 5.14.12 - Table 1

Count Worksheet
Location:
Date:
Product Code | Gross Weight | Tare Weight | Net Weight |  | Count |  | Final Weight |  | Final Count
BT | 319 | 133 | 186 |  | 378 |  | 474
BT | 419 | 131 | 288 |  | 584 |  | 474 |  | 962
BB | 395 | 121 | 274 |  | 153 |  | 948
BB | 489 | 127 | 362 |  | 207 |  | 948
BB | 465 | 153 | 312 |  | 171 |  | 948 |  | 531
WC | 399 | 155 | 244 |  | 3453 |  | 407
WC | 295 | 132 | 163 |  | 2600 |  | 407 |  | 6053
HT | 369 | 139 | 230 |  | 1733 |  | 1818
HT | 323 | 113 | 210 |  | 1650 |  | 1818
HT | 455 | 138 | 317 |  | 2500 |  | 1818
HT | 409 | 130 | 279 |  | 2200 |  | 1818
HT | 375 | 124 | 251 |  | 2000 |  | 1818
HT | 439 | 127 | 312 |  | 2400 |  | 1818
HT | 371 | 152 | 219 |  | 1774 |  | 1818 |  | 14257
WKS | 393 | 129 | 264 |  | 203 |  | 264 |  | 203
TB | 232 | 131 | 101 |  | 33 |  | 101 |  | 33
WS | 178 | 132 | 46 |  | 46 |  | 46 |  | 46
PC | 147 | 130 | 17 |  | 97 |  | 17 |  | 97
FS | 139 | 126 | 13 |  | 16 |  | 13 |  | 16
PG | 181 | 146 | 35 |  | 29 |  | 35 |  | 29
BP | 161 | 129 | 32 |  | 41 |  | 32 |  | 41
BAB | 3 |  | 3 |  | 9 |  | 3 |  | 9
TR | 174 | 139 | 35 |  |  |  | 35
TO | 151 | 130 | 21 |  |  |  | 21
CH | 164 | 132 | 32 |  |  |  | 32
WET | 223 | 143 | 80 |  |  |  | 80
 | 7668 | 3342 | 4326 |  | 22277 |  | 18011 |  | 22277
 |  | 4326
Spreadsheet: tracy_geaccone__40421__enron corp infomation request
Sheet: EGS IS

 |  | September
Gross Margin by Business Unit |  | Year-to-Date
ETS |  | 500.4
EGAS
PGE
EOTT |  | 0
EREC
Azurix/Wessex
EEOS
Other
Total Gross Margin
Operating Expenses |  | -200.2
Depreciation and Amortization |  | -51
Taxes Other Than Income |  | -36.1
Other Income (Loss) |  | 82.2
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 725010d1616499871-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR2

Monthly Target | 2021-07-01 00:00:00 |  |  |  |  |  |  | Monthly Target | 2021-08-01 00:00:00 |  |  |  |  |  | 2021-09-01 00:00:00
31150 |  |  |  |  |  |  |  | 31150
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  | 2553
 |  | Target
 |  |  |  |  |  |  |  |  |  | Target |  |  |  |  |  | Target
TOTAL |  |  |  |  |  |  |  | TOTAL
Spreadsheet: dfb59171-7e2b-4083-8c48-595406418da3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 821943280126 | [NAME] | Life Journal | 2009-06-02 | Compact Disc | Pop | 13.99 | Y | While Supplies Last
Spreadsheet: 137156d1326982306-averaging-totals-in-excel-for-fuel-mileage-sheet-fuel-mileage-2-unit-6363-power-ecm
Sheet: Log

[42] |  |  |  |  |  |  | [42]
Gas Mileage Log |  |  |  |  |  |  | Gas Mileage Log
Remember to reset your trip odometer |  |  |  |  |  |  | Remember to reset your trip odometer
Date | Odometer | km or [NAME] | Liters or Gallons | $ | km/L or MPG |  | Date | Odometer | km or [NAME] | Liters or Gallons | $ | km/L or MPG
http://www.vertex42.com/ExcelTemplates/mileage-calculator.html |  |  |  |  |  |  |  |  |  |  |  | © 2007 Vertex42.com
[42] |  |  |  |  |  |  | [42]
Gas Mileage Log |  |  |  |  |  |  | Gas Mileage Log
Remember to reset your trip odometer |  |  |  |  |  |  | Remember to reset your trip odometer
Date | Odometer | km or [NAME] | Liters or Gallons | $ | km/L or MPG |  | Date | Odometer | km or [NAME] | Liters or Gallons | $ | km/L or MPG
http://www.vertex42.com/ExcelTemplates/mileage-calculator.html |  |  |  |  |  |  |  |  |  |  |  | © 2007 Vertex42.com
Spreadsheet: 6efda3ba-5430-4fdf-9ba8-a84fdc86b064
Sheet: Table S1

 | Supplemental Table 1.  Comparative Immunohistochemical Analysis of Secondary Syphilis Biopsies
 | ID | Punch biopsy site | Tp polA copies/µg total DNA | CD68 | CD14 | CD11c | CD4 | CD8 | CD56
 | 72 | Posterior lumbar | 1110 | ++ | +++ | ++ | + | ++ | +
 | 73 | Right iliac crest | 773 | ++ | +++ | + | + | ++ | +
 | 76 | Posterior neck | 628 | ++ | +++ | ++ | + | ++ | +
 | 77 | Right ankle | 1770000 | ++ | ++++ | ++ | ++ | ++ | +
 | *  For each marker 1+ = 0-25%,  2+ 25-50%,  3+ 50-75%,  4+ > 75% of total cells stained
Spreadsheet: vkaminski__40835__McK2
Sheet: Case 1

ENE Price |  | 48.55 | 49.55 | 50.55 | 51.55 | 52.55 | 52.63 | 54.55 | 55.55 | 56.55 | 57.55
Shares delivered |  |  |  |  |  |  | 0
Value
ENE Price | 58.55 | 59.55 | 60.55 | 61.55 | 62.55 | 63.55 | 64.55 | 65.55 | 66.55 | 67.55 | 68.55
Shares delivered
Value
ENE Price | 69.55 | 70.55 | 71.55 | 72.55 | 73.55 | 74.55 | 75.55 | 76.55 | 77.55 | 78.55 | 79.55
Shares delivered
Value
 | ENE Price | Shares | Value
 | 48.55 |  |  |  | Terminal Price |  | Value |  |  | Value |  | Shares
 |  |  |  |  | Bottom | Top | Bottom | Top | Slope | Delivered |  | Delivered
 |  |  |  |  | 50.55 |  |  |  |  |  | Top1
 |  |  |  |  | 0 | 50 | 0 |  |  |  | Bottom1
 |  |  |  |  | 50 |  |  |  |  |  | M1
 |  |  |  |  |  |  |  |  |  |  | T1
 |  |  |  |  |  |  |  |  |  |  | 0=put | Premium
 |  |  |  |  | Position |  |  |  |  |  | OptType | per unit | Total
 |  |  |  |  |  | Long Digital put @ |  | 0 | Cash | 0 | 0
 |  |  |  |  |  | Long Euro Put @ |  | 52.63 | Shares |  | 0
 |  |  |  |  |  | Short Digital Put @ |  |  | Cash | 0 | 0
 |  |  |  |  |  | Short Euro Put @ |  | 50.55 | Shares |  | 0
 |  |  |  |  |  | Long Euro Put @ |  |  | Shares |  | 0
 |  |  |  |  |  | Price | 61
 |  |  |  |  |  | IR | 0.06
 |  |  |  |  |  | Maturity
 |  |  |  |  |  | Volatility
 |  |  |  |  |  | Yield
Spreadsheet: bd471a98-62b9-45fd-9203-88637388e72a
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Home Video | 14764291727 | Various | [NAME], The | 2006-03-14 | DVD | Children | 9.98 | Y | Available
Warner Home Video | 85391200635 | Peanuts | It'S The Easter Beagle [NAME] | 2010-03-16 | DVD | Children | 19.98 | Y | Available
Big Idea | 820413129392 | Veggietales | Very Veggie Easter Collection, A (Srp $19.99) | 2013-01-19 | DVD | Children | 19.99 | Y | Available
Big Idea | 820413118990 | Veggietales | Twas The Night Before Easter | 2011-03-05 | DVD | Children | 14.99 | Y | Available
Spreadsheet: 694848d1599837758-not-the-same-but-the-next-one-livro1
Sheet: Folha1

 |  |  | WATER
 |  |  | DATE | REF | DESC | AMMOUNT |  | DATE | REF | TYPE | DESC | DEBIT | CREDIT
 |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | --- | BALANCE | --- | --- | 1000
 |  |  |  |  |  |  |  | 2020-02-01 00:00:00 | 001 | WATER | PAYMENT WATER February | 100.54
 |  |  |  |  |  |  |  | 2020-03-02 00:00:00 | 002 | WATER | PAYMENT WATER March | 54.74
 |  |  |  |  |  |  |  | 2020-04-02 00:00:00 | 003 | ELECTRICITY | PAYMENT ELECTRICITY APBRIL | 34.51
 |  |  |  |  |  |  |  | 2020-04-04 00:00:00 | 004 | GARDEN | PAYMENT GARDEN APBRIL | 450
 |  |  |  |  |  |  |  | 2020-06-04 00:00:00 | 005 | ELECTRICITY | PAYMENT ELECTRICITY JUNE | 211.45
 |  |  | ELECTRICITY
 |  |  | DATE | REF | DESC | AMMOUNT
 |  |  | GARDEN
 |  |  | DATE | REF | DESC | AMMOUNT
Spreadsheet: 102596d1300544256-vlookup-problem-for-employees-with-same-shift-example-of-pull-from-schedule
Sheet: schedule

7
 | 2011-01-02 00:00:00
[NAME] | OFF | 0 | 10-5 | 6 | 12-8 | 7 | 9-5 | 7 | OFF |  | 10-7 | 8 | 12-8 | 7
[NAME] | 1030-630 | 7 | OFF | 0 | 10-6 | 7 | 9-4 | 6 | 10-6 | 7 | 12-8 | 7 | OFF | 0
[NAME] | 11-7 | 7 | 12-8 | 7 | OFF | 0 | 9-11 | 2 | 12-8 | 7 | 10-6 | 7 | 12-8 | 7
Mark | OFF | 0 | 12-8 | 7 | 12-8 | 7 | 9-11/3-8 | 6.5 | 10-6 | 7 | OFF | 0 | 10-6 | 7
[NAME] | 1-7 | 5.5 | OFF |  | OFF |  | OFF |  | OFF |  | 3-8 | 4.5 | OFF | 0
robby | OFF | 0 | 3-8 | 4.5 | 3-8 | 4.5 | OFF |  | OFF |  | 2-8 | 5.5 | OFF | 0
angie | OFF | 0 | 10-3 | 4.5 | OFF |  | 12-5 | 4.5 | OFF |  | OFF |  | 10-3 | 4.5
becky | OFF | 0 | OFF |  | OFF |  | 2-8 | 5.5 | OFF |  | OFF |  | OFF | 0
micky | 1030-330 | 4.5 | OFF |  | OFF |  | OFF |  | OFF | 0 | 12-5 | 4.5 | 3-8 | 4.5
[NAME] | OFF | 0 | OFF | 0 | OFF | 0 | OFF |  | 3-8 | 4.5 | OFF |  | 12-5 | 4.5
 |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs |  | hrs
 |  |  | 1 | Sun
 |  |  | 2 | Mon
 |  |  | 3 | Tue
 |  |  | 4 | Wed
 |  |  | 5 | Thu
 |  |  | 6 | Fri
 |  |  | 7 | Sat
Spreadsheet: 124997d1318794225-pivottable-or-sumproduct-function-to-break-out-values-sample
Sheet: Sheet1

 |  |  |  | Food | Music | Gifts
 |  | Event 1 | [NAME] | y | y | n
 |  |  | [NAME] | n | n | y
 |  |  | [NAME] | y | n | y
 |  | Event 2 | [NAME] | n | n | y
 |  |  | [NAME] | n | n | n
 |  |  | [NAME] | n | y | y
 |  | Event 3 | [NAME] | n | n | y
 |  |  | [NAME] | y | y | n
 |  |  | [NAME] | y | n | y
 |  | Event 4 | [NAME] | y | n | n
 |  |  | [NAME] | y | n | n
 |  |  | [NAME] | y | y | n
 |  | Want dynamic result to look something like this
 |  |  | Food |  | Music |  | Gifts
 |  |  | Y | N | Y | N | Y | N
 |  | [NAME] | 2 | 2 | 1 | 3 | 0 | 4
 |  | [NAME] | 2 | 2 | 1 | 3 | 1 | 3
 |  | [NAME] | 3 | 1 | 3 | 1 | 2 | 2
Spreadsheet: 155283d1336750243-finding-consecutive-numbers-0c
Sheet: Sheet1

 |  |  |  |  | 13 | NO
 |  |  |  |  | 9 | NO
 |  |  |  |  | 11 | NO
 |  |  |  |  | 9 | NO
 |  |  |  |  | 15 | NO
 |  |  |  |  | 9 | NO
 |  |  |  |  | 13 | NO
 |  |  |  |  | 19 | NO
 |  |  |  |  | 26 | YES
 |  |  |  |  | 31 | YES
 |  |  |  |  | 28 | YES
 |  |  |  |  | 31 | YES
 |  |  |  |  | 33 | YES
 |  |  |  |  | 39 | YES
 |  |  |  |  | 30 | YES
 |  |  |  |  | 35 | YES
 |  |  |  |  | 35 | YES
 |  |  |  |  | 28 | YES
 |  |  |  |  | 30 | NO
 |  |  |  |  | 30 | NO
 |  |  |  |  | 26 | NO
 |  |  |  |  | 41 | NO
 |  |  |  |  | 22 | NO
 |  |  |  |  | 17 | NO
Spreadsheet: 125cb854-22b5-4d87-817a-136be22adfaf
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 4/12/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2010/11 | Jun |  | 71,457 |  | 2,131 |  | 2,000 |  | 2,042 |  | 73,546
 | Jul |  | 74,629 |  | 2,122 |  | 2,000 |  | 1,483 |  | 77,268
 | Aug |  | 81,564 |  | 2,278 |  | 2,000 |  | 1,892 |  | 83,951
 | Sep |  | 78,430 |  | 2,259 |  | 2,000 |  | 1,622 |  | 81,066
 | Oct |  | 79,447 |  | 2,357 |  | 2,000 |  | 2,133 |  | 81,670
 | Nov |  | 76,043 |  | 2,373 |  | 2,000 |  | 1,387 |  | 79,028
 | Dec |  | 71,378 |  | 2,474 |  | 2,000 |  | 1,775 |  | 74,076
 | Jan |  | 71,676 |  | 2,262 |  | 2,000 |  | 2,110 |  | 73,828
 | Feb |  | 71,107 |  | 1,967 |  | 2,000 |  | 2,083 |  | 72,991
 | Mar |  | 75,441 |  | 2,657 |  | 2,000 |  | 1,812 |  | 78,286
 | Apr |  | 72,123 |  | 2,435 |  | 2,000 |  | 2,518 |  | 74,041
 | May |  | 73,743 |  | 2,377 |  | 2,000 |  | 2,230 |  | 75,890
2011/12 | Jun |  | 70,554 |  | 2,238 |  | 2,000 |  | 1,745 |  | 73,046
 | Jul |  | 72,573 |  | 2,096 |  | 2,000 |  | 1,339 |  | 75,330
 | Aug |  | 79,317 |  | 2,309 |  | 2,000 |  | 2,410 |  | 81,216
 | Sep |  | 76,269 |  | 2,237 |  | 2,000 |  | 1,637 |  | 78,870
 | Oct |  | 81,402 |  | 2,250 |  | 2,000 |  | 1,564 |  | 84,088
 | Nov |  | 77,915 |  | 2,571 |  | 2,000 |  | 1,704 |  | 80,782
 | Dec |  | 73,135 |  | 2,460 |  | 2,000 |  | 1,215 |  | 76,380
 | Jan |  |  |  | 2,583 |  |  |  | 1,280 |  | 1,303
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/Briefing/Wheat/wheatfooduse.htm for more information. Sources: Calculated using data from U.S. Department of Commerce, Bureau of the Census, Flour Milling Products (MQ311A) and Foreign Trade Statistics.
Date run: 4/10/2012
Spreadsheet: 713343d1610657115-merge-cells-downwards-until-next-next-value-reach-in-a-different-column-query
Sheet: Sheet1

Column A | Column B | Column C
02MAR20 | [NAME] | [NAME]
 | [NAME]
 | Sean
02MAR20 | Rachel | [NAME]
 | Shane
02MAR20 | Sinead | Sinead
03MAR20 | [NAME] | [NAME]
 | [NAME]
 | Michlle
Spreadsheet: 34728d1232041481-two-item-lookup-multiple-results-test_lookup
Sheet: Sheet1

 |  | Date | Name | City | Age
 |  | 2009-01-01 00:00:00 | [NAME] | LA | 43
 |  | 2009-01-02 00:00:00 | Carol | Boston | 42
 |  | 2009-01-02 00:00:00 | Al | Boston | 42
 |  | 2008-05-05 00:00:00 | Same | Detroit | 34
 |  |  | Boston
 |  |  | 2009-01-02 00:00:00
 |  | [NAME]
Spreadsheet: 349330d1412278961-count-the-number-of-visits-by-visit-types-levi_example-ndm
Sheet: DATA ENTRY

 |  |  | PATIENT |  |  | PROVIDER
Day of Study | ROOM NUMBER | VISIT TYPE | TIME IN | Time OUT | Duration | TIME IN | Time OUT | Duration
1 | 2 | 1 | 12:08:00 | 12:32:00 |  | 12:23:00 | 12:32:00
1 | 2 | 8 | 13:20:00 | 13:53:00 |  | 13:42:00 | 13:53:00
1 | 2 | 8 | 13:45:00 | 14:47:00 |  | 14:40:00 | 14:47:00
1 | 2 | 4 | 14:45:00 | 15:15:00 |  | 15:05:00 | 15:15:00
1 | 2 | 4 | 16:50:00 | 17:23:00 |  | 17:00:00 | 17:23:00
1 | 2 | 4 | 18:30:00 | 19:15:00 |  | 18:46:00 | 19:15:00
1 | 4 | 3 | 11:47:00 | 12:10:00 |  | 11:58:00 | 12:10:00
1 | 4 | 8 | 12:50:00 | 13:41:00 |  | 13:14:00 | 13:41:00
1 | 4 | 4 | 13:30:00 | 14:17:00 |  | 14:05:00 | 14:17:00
1 | 4 | 3 | 14:45:00 | 15:10:00 |  | 14:52:00 | 15:10:00
1 | 4 | 8 | 16:36:00 | 17:10:00 |  | 16:50:00 | 17:10:00
1 | 4 | 6 | 18:00:00 | 18:38:00 |  | 18:20:00 | 18:38:00
2 | 4 | 3 | 09:00:00 | 10:35:00 |  | 10:01:00 | 10:35:00
2 | 4 | 8 | 10:45:00 | 11:10:00 |  | 10:53:00 | 11:10:00
2 | 4 | 6 | 10:54:00 | 11:44:00 |  | 11:25:00 | 11:44:00
2 | 4 | 8 | 14:15:00 | 14:45:00 |  | 14:34:00 | 14:45:00
2 | 4 | 2 | 14:58:00 | 15:35:00 |  | 15:06:00 | 15:35:00
2 | 4 | 4 | 16:00:00 | 16:45:00 |  | 16:20:00 | 16:45:00
2 | 2 | 6 | 09:20:00 | 09:49:00 |  | 09:37:00 | 09:49:00
2 | 2 | 2 | 10:20:00 | 11:30:00 |  | 10:40:00 | 11:30:00
2 | 2 | 6 | 13:15:00 | 14:18:00 |  | 13:45:00 | 14:18:00
2 | 2 | 6 | 15:30:00 | 16:23:00 |  | 16:00:00 | 16:23:00
3 | 4 | 6 | 10:34:00 | 11:20:00 |  | 11:00:00 | 11:15:00
3 | 4 | 6 | 13:45:00 | 14:25:00 |  | 14:05:00 | 14:25:00
3 | 4 | 8 | 14:25:00 | 15:24:00 |  | 14:35:00 | 15:24:00
3 | 4 | 3 | 17:45:00 | 18:30:00 |  | 18:05:00 | 18:30:00
3 | 2 | 3 | 09:51:00 | 11:00:00 |  | 10:00:00 | 10:45:00
3 | 2 | 3 | 11:08:00 | 11:50:00 |  | 11:36:00 | 11:50:00
3 | 2 | 7 | 13:10:00 | 14:00:00 |  | 13:20:00 | 14:00:00
3 | 2 | 5 | 14:05:00 | 14:35:00 |  | 14:15:00 | 14:35:00
3 | 2 | 8 | 14:35:00 | 14:50:00 |  | 14:35:00 | 14:50:00
3 | 2 | 4 | 17:25:00 | 17:55:00 |  | 17:30:00 | 17:55:00
3 | 2 | 8 | 18:05:00 | 18:50:00 |  | 18:20:00 | 18:50:00
Spreadsheet: 79299d1279570175-file-annual-leave-calculator-excel-forum-annual-leave-calculation
Sheet: Sheet1

Name | Start | End | Leave | Leave Date | Join date | Duration | Entitlement | Balance
[NAME] | 2010-01-01 00:00:00 | 2011-12-31 00:00:00 | 42 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 31 | 19.24279835390946 | 22.75720164609054
[NAME] | 2010-01-01 00:00:00 | 2011-12-31 00:00:00 | 42 | 2011-12-31 00:00:00 |  |  | 42 | 0
Annual Leave calculator - Excel Help Forum
Column A - Name eg. [NAME]
Column B - Contract Start Date eg. 01/01/2010
Column C - Contract End Date eg. 31/12/2011
Column D - Leave at the end of the Contract Period i.e. 42 days
Column E - Leave Date eg. [NAME]
Column F - Join Date eg. 01/01/2011
Column G - Duration of Leave in days (to be calculated automatically in days the diff. between leave date & join date)
Column H - Actual Leave balance (should be calculated as on [NAME] as for the whole contract period is 42 days)
Moreover if the person wish to go on leave again before the end of his contract period it should calculate the actual leave i.e. 42 days - 1st leave taken and the balance that is calculated as on the new leave date.
in H2 I need the Actual Leave that is due to him as on 01.12.2010 which shall enable me to check if he is liable for that much leave which he
is asking for. In two years contract time starting from 01.01.2010 to 31.12.2011 he is liable for 42 days then on
01.12.10 how much shall he get as per his contract leave and does his requested leave is more or less than what he has asked for. That is what I want to check.
Spreadsheet: d896a918-d78d-413b-a402-10e53f72168e
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
IMFXO | Test | IMFXO | Immunofixation Only, Serum | Immunofixation Only, S | Immunofixation | Serum, [NAME] |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions: Fasting | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | Negative (reported as positive or negative) | Monday through Friday; 2 p.m. | 2 days | 4 days | 1 | 86334 |  |  |  |  | Rochester
IMFXO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
IMFXO | Result | 32436 | Immunofixation | Immunofixation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process