tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 732107d1620768747-formula-to-retrieve-vendor-based-on-description-description-and-vendors
Sheet: Sample

SAMPLE |  |  |  | REFERENCED DATA
Description | [NAME] |  |  | Description | [NAME]
24HourFlex Monthly FSA [NAME] 2021 Payroll |  |  |  | 24HourFlex Admin Fee - Nov 2020 Payroll | Payroll
Next PBX for Feb 2021 |  |  |  | 24HourFlex Admin Fee - Dec 2020 Payroll | Payroll
Next PBX for March 2021 |  |  |  | Ninja Number Next PBX for November 2020 | Verizon Wireless
Jungle Mail for Share Point Feb 2021 |  |  |  | Ninja Number - Next PBX for Dec 2020 | Verizon Wireless
Fax Software for Jeter Feb 2021 |  |  |  | Next PBX for Jan 2021 | Verizon Wireless
Jungle Mail for Share Point March 2021 |  |  |  | Jungle Mail for Share Point | JungleMail for Sharepoint
Fax Software for Jeter March 2021 |  |  |  | Jungle Mail for Share Point Dec 2020 | JungleMail for Sharepoint
Deferred Rent - Apr-2021 |  |  |  | Jungle Mail for Share Point Jan 2021 | JungleMail for Sharepoint
Tenant Incent. Amort. - Apr-2021 |  |  |  | eFax software for Jeter | Jeter
 |  |  |  | efax - Fax Software for Jeter for Dec 2020 | Jeter
 |  |  |  | EFax Software for Jeter for Jan 2021 | Jeter
 |  |  |  | Deferred Rent - Nov-2020 | Office
 |  |  |  | Deferred Rent - Dec-2020 | Office
 |  |  |  | Deferred Rent - Jan-2021 | Office
 |  |  |  | Deferred Rent - Feb-2021 | Office
 |  |  |  | Deferred Rent - Mar-2021 | Office
 |  |  |  | Tenant Incent. Amort. - Nov-2020 | Office
 |  |  |  | Tenant Incent. Amort. - Dec-2020 | Office
 |  |  |  | Tenant Incent. Amort. - Jan-2021 | Office
 |  |  |  | Tenant Incent. Amort. - Feb-2021 | Office
 |  |  |  | Tenant Incent. Amort. - Mar-2021 | Office
Spreadsheet: 162739d1340042555-replace-cells-and-create-dummy-variables-forum-file-slacknoise-oeldere-
Sheet: Sheet1

A | B | C | D | E | F | G
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
34401410 | 183307120 | 614603730 | 396895200 | 1 | 1 | 1 |  | 1 | 1 | 1
22708820 | 0 | 647605330 | 624896510 | 1 | 0 | 1 |  | 1 | 0 | 1
0 | 183803060 | 708102980 | 524299920 | 0 | 1 | 1 |  | 0 | 1 | 1
0 | 426902710 | 829709560 | 402806850 | 0 | 1 | 1 |  | 0 | 1 | 1
Once again i need help on an issue0
10 The cells containing a dot need to be replaced by [NAME] This seems to be a problem as other cells containing numbers also contain dots0
20 Cells in column E, F and G refer to column A,B and C0 Whenever there is no value in cells A,B and C i want to display a 0 for no value and a 1 for value in the respective Cells in column A,B and C respectivly0 In this case F would refer to B and so on0 (I did it manually to make my point clear in the file i uploaded)
If somebody could help me on this, that would be great0 Thank you very much in [NAME] Attached find the file
Spreadsheet: 02c8120e-7a90-4bd2-a3b3-8153a9b2022d
Sheet: Sheet1

Table 2 -- USDA estimate of sugar imports in FY 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 |  | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Metric tons, raw value | Short tons, raw value
Raw sugar TRQ | 1117195 | 1231496.61694375
Less shortfall attributable to Mexico 1/
Less other shortfall | -218000 | -240303.8525 |  | -65000 | -71650.23125000001 |  | -104390.837928035 | -115071.1950449997
Plus FY 2011 TRQ entries in Oct. and Nov. 2011 | 79906 | 88081.2827425
Less FY 2012 TRQ entries in September 2011 | -20062 | -22114.5682975
Plus April 2012 increase | 381017.6118587196 | 420000
Total raw sugar TRQ | 1340056.611858719 | 1477159.47888875
Refined sugar TRQ
Allocation to Canada | 12050 | 13282.8505625
FY 2011 Canada sugar to enter FY 2012 | 17535 | 19329.02776875
Allocation to Mexico
Less Mexican shortfall 1/
Global | 8294 | 9142.5695075
FY 2011 Global sugar to enter FY 2012 | 111078 | 122442.5290275
Specialty
Base | 1656 | 1825.42743
Additional | 90718.47901398086 | 100000
Total refined sugar TRQ | 241331.4790139809 | 266022.40429625
CAFTA/DR TRQ - calendar 2012 | 116820 | 128772.0013932
CAFTA/DR FY 2011, likely to enter in FY 2012 | 31543 | 34770.20407418
CAFTA/DR FY 2012, forecast to enter in FY 2013 | -20000 | -22046.2252
Other:
Singapore, Bahrain, Jordan | 22 | 24.250875
Peru | 2000 | 2204.625
Colombia | 50000 | 55116
Colombia CY 2011, entered Oct-Dec 2011 | 0 | 0
Colombia CY 2012, forecast to enter [NAME] | -25000 | -27557.8125
Total estimate TRQ entries | 1736773.0908727 | 1914464.92682738
Mexico | 979895.8 | 1080150.16416775
Re-export program imports | 589670.1135908755 | 650000
Sugar syrups, high-tier | 12700.71668329856 | 14000
Total projected imports | 3319039.721146874 | 3658615.09099513
1/ Total entries from Mexico, quota and non-quota, reflected below.
Source: USDA, FAS.
Spreadsheet: 86402d1286386294-currency-conversion-in-excel-sample_currency
Sheet: Sheet1

Date | Material | Part | Matl group | D | Plnt | SLoc | Quantity | BUn | Net price | Crcy
07.10.2008 | 12313 | Toe mount | 8000 |  | 3100 | 3110 | -50 | EA | 1.96 | USD
15.10.2008 | 654674 | Hell mount | 8000 |  | 3100 | 3110 | -50 | EA | 1.96 | GBP
03.11.2008 | 111111 | Brazed | 8000 |  | 3100 | 3110 | -12 | EA | 0 | USD
15.01.2009 | 233243 | Vilet | 8000 |  | 3100 |  | -70 | EA | 3.21 | GBP
15.01.2009 | 666666 | Hinge | 8000 | L | 3100 |  | -14 | EA | 226.42 | USD
16.01.2009 | 543234 | IP SN RD | 8000 |  | 3100 |  | -2 | EA | 190.53 | USD
23.01.2010 | 432432 | IP RD | 8000 | L | 3100 |  | -1 | EA | 159.67 | USD
12.02.2010 | 534223 | IP RD | 8000 | L | 3100 |  | -1 | EA | 159.67 | GBP
12.02.2010 | 776767 | AHEAD | 8000 | L | 3100 |  | -1 | EA | 609.34 | GBP
Spreadsheet: 102687d1300671929-index-match-fifthnpop
Sheet: Apr 10

 |  |  |  |  |  | Apr 10
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | 4010 · Fees |  | -234
 |  |  |  | 4050 · Sales |  | 234
 |  |  | Total Income
 |  |  | Cost of Goods Sold
 |  |  |  | 5050 · Shop Supplies |  | 435
 |  |  |  | 5070 · Member Services
 |  |  |  |  | Beer, Wine & Soda | 234
 |  |  |  | Total 5070 · Member Services
 |  |  | Total [NAME]
 |  | Gross Profit
 |  |  | Expense
 |  |  |  | 6135 · Credit Card Merchant Fees |  | 342345
 |  |  |  | 6230 · [NAME] and Permits |  | 342
 |  |  |  | 6290 · Rent |  | 56
 |  |  |  | 6335 · Salon Supply Expenses |  | 234
 |  |  |  | 6340 · Telephone |  | 76
 |  |  |  | 6341 · Website Services |  | 42
 |  |  |  | 6342 · Email & Internet Services |  | 35
 |  |  |  | 6390 · Utilities |  | 43
 |  |  |  | 6551 · Outsourced Services |  | 54
 |  |  |  | 6560 · Payroll Expenses |  | 324
 |  |  |  | 6862 · To be indentified |  | 235
 |  |  | Total Expense
 | Net Ordinary Income
Net Income
Spreadsheet: 737792d1624606511-sort-data-using-filter-or-sortby-function-excel-365-var-report-using-filter-function
Sheet: Sheet1

 |  |  | I'm kindly asking for a formula to produce VAT report using FILTER and or [NAME] function (excel 365)
 |  |  |  |  |  |  |  |  |  |  | Desired outcome
Date | Code | Invoice No. | Customer | [NAME]. No. | Description | Amount (excl vat) | Vat % | [NAME] | Amount (incl vat) |  | Customer | Date | Invoice No. | [NAME] | Amount (incl vat)
2021-06-01 00:00:00 | US001 | 2020-0001 | [NAME] | 102001 | Cash purchases | 10000 | 0.15 |  |  |  |  |  |  |  | 20000
2021-06-03 00:00:00 | US002 | 2020-0002 | CHIEDZA | 102002 | Cash purchases | 20000 | 0 |  |  |  | CHIEDZA | 2021-07-12 00:00:00 | 2020-0006 | 9000 | 69000
2021-06-04 00:00:00 | US003 | 2020-0003 | CRAIG | 102003 | Cash purchases | 30000 | 0 |  |  |  | CHIEDZA | 2021-06-07 00:00:00 | 2020-0009 | 150 | 1150
2021-06-07 00:00:00 | US009 | 2020-0009 | CHIEDZA | 102002 | Cash purchases | 1000 | 0.15 |  |  |  | CRAIG | 2021-06-04 00:00:00 | 2020-0003 | 0 | 30000
2021-05-02 00:00:00 | US004 | 2020-0004 | YOLANDA | 102004 | Cash purchases | 40000 | 0.15 |  |  |  | CRAIG | 2021-07-13 00:00:00 | 2020-0007 | 10500 | 80500
2021-07-11 00:00:00 | US001 | 2020-0005 | [NAME] | 102005 | Cash purchases | 50000 | 0.15 |  |  |  | [NAME] | 2021-06-01 00:00:00 | 2020-0001 | 1500 | 11500
2021-07-12 00:00:00 | US003 | 2020-0006 | CHIEDZA | 102006 | Cash purchases | 60000 | 0.15 |  |  |  | [NAME] | 2021-07-11 00:00:00 | 2020-0005 | 7500 | 57500
2021-07-13 00:00:00 | US007 | 2020-0007 | CRAIG | 102007 | Cash purchases | 70000 | 0.15 |  |  |  | YOLANDA | 2021-05-02 00:00:00 | 2020-0004 | 6000 | 46000
2021-07-14 00:00:00 | US008 | 2020-0008 | YOLANDA | 102008 | Cash purchases | 80000 | 0.15 |  |  |  | YOLANDA | 2021-07-14 00:00:00 | 2020-0008 | 12000 | 92000
Spreadsheet: mary_fischer__25622__87P
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE]
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 853693d1703653263-formula-to-calculate-provisional-tax-correct-tax-file
Sheet: Sheet1

 | Kindly asking for excel formula to calculate estimated quartly using information on the profit and loss account
 | Please not that the 4th quarter is actual not estimated.
 | Profit and loss ACCOUNT
 |  | Estimated |  |  | Actual
 | Details | 1st QPD | 2nd QPD | 3rd QPD | 4th QPD
 | Sales | 10216 | 15796 | 21380.7 | 63981.39999999998
 | Expenses | 12607 | 19379.04 | 44457.78 | 71461.39333333334
 | Profit / (Loss)
 | Tax rate | 0.2472 | 0.2472 | 0.2472 | 0.2472
 | Tax payable
 | Estimated Annual Tax |  |  |  | -1849.054352000007
 | Desired solution
 | QPD | Due (on or before) | Installment Due (as a % of the annual tax payable) | Amount
 | 1st QPD | 25th March | 0.1 | -236.42208
 | 2nd QPD | 25th June | 0.25 | -442.8637440000001
 |  | Shortfall or refund 1st Quarter |  | 59.27658239999997
 |  | Total Tax payable
 | 3rd QPD | 25th September | 0.3 | -2281.8616704
 |  | Shortfall or refund 2nd Quarter |  | -1281.5421504
 |  | Shortfall or refund 2nd Quarter
 | 4th QPD | 20th December | 0.35 | -647.1690232000024
 |  | Shortfall or refund 3rd Quarter |  | 2981.527733599996
 | Total Estimated Tax payable
 | Actual Tax for the year |  | 1
 | Check
Spreadsheet: 269718d1381255073-median-with-if-not-working-median
Sheet: Sheet1

Sold Price | Type | Single Family | #N/A
265000 | Condo
250000 | Condo
219000 | Condo
200000 | Condo
160000 | Condo
160000 | Condo
155000 | Condo
39900 | Multi-Family
1150000 | Multi-Family
515000 | Single Family
320000 | Single Family
165000 | Single Family
144000 | Single Family
110000 | Single Family
60000 | Single Family
Spreadsheet: 109228d1306159129-excel-2007-counting-with-multiple-criteria-including-date-range-sample-analysis
Sheet: Sheet2

 | 2010-01-10 00:00:00 | 2010-02-01 00:00:00 | 2010-02-23 00:00:00 | 2010-03-17 00:00:00 | 2010-04-08 00:00:00 | 2010-04-30 00:00:00 | 2010-05-22 00:00:00 | 2010-06-13 00:00:00 | 2010-07-05 00:00:00 | 2010-07-27 00:00:00 | 2010-08-18 00:00:00 | 2010-09-09 00:00:00 | 2010-10-01 00:00:00 | 2010-10-23 00:00:00 | 2010-11-14 00:00:00 | 2010-12-06 00:00:00 | 2010-12-28 00:00:00 | 2011-01-19 00:00:00 | 2011-02-10 00:00:00
Silver Cancel
Gold (Promo)
Gold
Spreadsheet: 872124d1718485355-how-to-combine-relative-position-into-formula-stock-comparison-32
Sheet: Sheet1

 | ?? | 3e | -2-1a | 4? | ?? |  | ??? | 0? | [NAME] | ??? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
ref table
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 2 | 2 | 4 | 6
all | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 2 | 2 | 4 | 6
[NAME]) | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 5 | 5 | 3 | 4 | 6 | 9
all(s/fexp) | 1 | 1 | 0 | 0 | 2 | 0 | 3 | 2 | 2 | 7 | 7 | 5 | 6 | 8 | 12
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
 | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 3 | 9 | 9 | 8 | 10 | 12 | 16
 |  |  | convert table row 6 to below
 |  |  | retain numbers above
 |  | t5e3 | 1 extt2-2-1a | t8?4? |  |  |  | t8?0? | t7a-2a
FORMULA |  | t5e | 1 extt2a | t8? | ?? |  | ??? | t8? | t7a | ??? | ?? | ??? | ???
 | ?? | t5e | 1extt2 | t8? | ?? |  | ?? | t8? | t7a | ?? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 2-7T

 | Section 2: Inventory
 | Table 2-7Trend: Passenger Vehicles (Law Enforcement) by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Low-Speed Electric Vehicle | 0 | 9 | 49 | 42 | 30
 | Subcompact | 268 | 399 | 216 | 1061 | 1197
 | Compact | 6082 | 6849 | 7230 | 8240 | 7720
 | Midsize | 24447 | 22846 | 19708 | 18666 | 19095
 | Large | 9308 | 9029 | 7786 | 7367 | 5476
 | Limousines | 264 | 288 | 157 | 123 | 108
 | Light Duty Passenger Vans | 4690 | 4827 | 3638 | 4327 | 3835
 | Medium Duty Passenger Vans | 2148 | 2240 | 2346 | 2223 | 2180
 | Light Duty SUVs | 29888 | 30511 | 29470 | 33568 | 31520
 | Medium Duty SUVs | 3141 | 6600 | 6923 | 5142 | 5559
 | Grand Total | 80236 | 83598 | 77523 | 80759 | 76720
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Products1

Date | Product | Region | Amount
2007-04-09 00:00:00 | Dairy | Denmark | 1148
2007-05-26 00:00:00 | Produce | Denmark | 1530
2007-12-07 00:00:00 | Produce | Denmark | 1423.5
 |  | Denmark Total
2007-11-05 00:00:00 | Dairy | Finland | 192.1
2007-07-12 00:00:00 | Dairy | Finland | 351
2007-06-02 00:00:00 | Grain | Finland | 560.4
 |  | Finland Total
2007-08-30 00:00:00 | Dairy | Germany | 470
2007-07-26 00:00:00 | Dairy | Germany | 17.4
2007-09-24 00:00:00 | Grain | Germany | 1405
2007-10-30 00:00:00 | Grain | Germany | 470
2007-08-26 00:00:00 | Grain | Germany | 17.4
2007-07-07 00:00:00 | Grain | Germany | 747
2007-06-26 00:00:00 | Produce | Germany | 17.4
2007-07-07 00:00:00 | Produce | Germany | 747
 |  | Germany Total
2007-01-18 00:00:00 | Dairy | Italy | 3194.2
2007-02-13 00:00:00 | Dairy | Italy | 438.43
2007-12-18 00:00:00 | Produce | Italy | 3194.2
2007-03-13 00:00:00 | Produce | Italy | 438.43
 |  | Italy Total
Spreadsheet: daren_farmer__6584__HL&PMTD
Sheet: Feb 00

HL&P MONTH TO DATE
 | NOMS |  |  |  |  |  |  |  |  |  |  |  |  |  | BAV FLOW
 |  |  |  |  |  |  |  |  |  |  |  |  | NOM |  |  |  |  |  |  |  |  |  | BAV
 | 7268 |  |  |  |  |  | 1554 |  | 1554 |  | 1554 |  | TOTAL |  | 1393 | 1396 | 1401 | 1412 | 1480 |  | 1554 |  | TOTAL |  | DIFF.
DAY | 3 rd Party |  | HPL Spot |  |  |  | HPL |  | HPL SPOT |  | 3rd Party
2000-02-01 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 12038 |  |  |  | 24472
2000-02-02 00:00:00 |  |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 27480 |  | 14642 |  | 12991
2000-02-03 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 22948 |  |  |  | 11988
2000-02-04 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 23692 |  |  |  | 12325
2000-02-05 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 24964 |  |  |  | 11452
2000-02-06 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 21939 |  |  |  | 14067
2000-02-07 00:00:00
2000-02-08 00:00:00
2000-02-09 00:00:00
2000-02-10 00:00:00
2000-02-11 00:00:00
2000-02-12 00:00:00
2000-02-13 00:00:00
2000-02-14 00:00:00
2000-02-15 00:00:00
2000-02-16 00:00:00
2000-02-17 00:00:00
2000-02-18 00:00:00
2000-02-19 00:00:00
2000-02-20 00:00:00
2000-02-21 00:00:00
2000-02-22 00:00:00
2000-02-23 00:00:00
2000-02-24 00:00:00
2000-02-25 00:00:00
2000-02-26 00:00:00
2000-02-27 00:00:00
2000-02-28 00:00:00
2000-02-29 00:00:00
 | 3rd Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All 3rd Party is kept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | whole.
Spreadsheet: 627a70aa-54c4-4af1-8748-d0dadc02d0e6
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
GDOM | Test | GDOM | Glycyphagus domesticus, IgE | Glycyphagus Domesticus, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GDOM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GDOM | Result | GDOM | Glycyphagus Domesticus, IgE | Glycyphagus Domesticus, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6126-7
Spreadsheet: 866236d1713199380-filter-with-time-window-array-function-example
Sheet: Sheet1

 |  |  | Original: |  |  |  |  | Expected result of 5 day window:
 |  |  | Product | Date | Amount |  |  | Product | Date | Amount
 |  |  | Shoes | 2024-02-15 00:00:00 | 210 |  |  | Shoes |  | 210
 |  |  | Jackets | 2024-02-15 00:00:00 | 807 |  |  | Jackets |  | 807
 |  |  | Pants | 2024-02-15 00:00:00 | 413 |  |  | Jackets |  | 807
 |  |  | Underwear | 2024-02-15 00:00:00 | 655 |  |  | Pants |  | 413
 |  |  | Hat | 2024-02-15 00:00:00 | 760 |  |  | Underwear |  | 655
 |  |  | Hat | 2024-02-17 00:00:00 | 681 |  |  | Hat
 |  |  | Jackets | 2024-02-25 00:00:00 | 418 |  |  | Jackets
 |  |  | Shoes | 2024-02-25 00:00:00 | 661 |  |  | Shoes
 |  |  | Pants | 2024-02-18 00:00:00 | 85 |  |  | Pants |  | 85
 |  |  | Shoes | 2024-02-27 00:00:00 | 177 |  |  | Jackets |  | 72
 |  |  | Shoes | 2024-02-29 00:00:00 | 726
 |  |  | Jackets | 2024-03-01 00:00:00 | 72
Spreadsheet: 169655d1343009484-excel-2007-list-differences-between-tables-table-difference
Sheet: Table 2

 | BA | BB | BC | BD | BE
AA | 233 | 235 | 466 | 235 | 234
AB | 345 | 3 | 457 | 344 | 534
AC | 234 | 534 | 44 | 26 | 235
AD | 2 | 454 | 7 | 236 | 26
AE | 637 | 57 | 462 | 235 | 23
AF | 35 | 869 | 346 | 345 | 632
AG | 523 | 96 | 365 | 236 | 626
Spreadsheet: 125570d1319108890-excel-2007-moving-values-between-sheets-by-using-number-commands-weight-and-buildup
Sheet: Load Information

 |  |  |  | [NAME]: |  | Hjörtur Pálmi
Date | Flight Number | A/C Registration |  | Departure Time |  | Routing
2011-10-20 00:00:00 |  |  |  | 19:55z |  | KEF-CGN
# | ULD Number | ULD WT | Payload | Total Wt. | Dest | Contents | Remarks
 |  | (KG) | (KG) | (KG)
1 | Pallur 1 | 120
2 | pallur 2 | 120
3 | pallur 3 | 120
4 | pallur 4 | 120
5 | pallur 5 | 120
6 | pallur 6 | 120
7 | pallur 7 | 120
8 | pallur 8 | 120
9 | pallur 9 | 120
10 | palur 10 | 120
Hold 1
Hold 2
Hold 3
Hold 4
 | Total Weight :
 | POS | [NAME] |  | [NAME]
 | 1 | 2540 |  | 2540
 | Hold 1 | 1150 |  | 1245
 | 2 | 2540 |  | 2540
 | Hold 2 | 1118 |  | 2540
 | 3 | 2540 |  | 2059
 | 4 | 4082 |  | 2540
 | 5 | 3288 |  | 4082
 | 6 | 2268 |  | 3310
 | 7 | 2268 |  | 2268
 | Hold 3 | 2336 |  | 3062
 | 8 | 2132 |  | 2268
 | Hold 4 | 1132 |  | 1125
 | 9 | 907 |  | 2132
 | 10 | N/A |  | 1360
Spreadsheet: 842598d1694621867-conditional-formating-to-fill-colour-on-rows-based-on-value-input-in-cell-forum-vujuv-
Sheet: Sheet1

 |  |  | Search Criteria : |  | 9921
Phone # | Box Serial # | Name
801110022 | 10090075663800fdf | [NAME]
869927738 | 10090075663800fje | [NAME]
766771818 | 10090075663800faa | [NAME]
766299921 | 10090075663800fac | [NAME]
802227733 | 10090075663800fdb | [NAME]
902238877 | 10090075663800fjc | [NAME]
102220001 | 10090075663800fad | [NAME]
203330222 | 10090075663800ffj | [NAME]
Spreadsheet: 52721d1252555160-subtracting-hours-in-a-work-schedule-schedule-for-3-and-15_1
Sheet: Lists for Stores

DARCELL
CLINTON |  |  | 08:15:00 | 09:00:00 | 09:15:00 | 10:00:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00
LAURA
CATHERINE
TERENCE
TROY
BILL
NICK
LYNN
HELP
 |  |  | AM |  | PM
 |  |  | 08:15:00 |  | 12:00:00
 |  |  | 09:00:00 |  | 13:00:00
 |  |  | 09:15:00 |  | 13:30:00
 |  |  | 10:00:00 |  | 14:00:00
 |  |  | 11:00:00 |  | 14:15:00
 |  |  | 11:15:00 |  | 14:30:00
 |  |  | 11:30:00 |  | 15:00:00
 |  |  | 11:45:00 |  | 15:15:00
 |  |  |  |  | 15:30:00
 |  |  |  |  | 15:45:00
 |  |  |  |  | 16:00:00
 |  |  |  |  | 16:15:00
 |  |  |  |  | 16:30:00
 |  |  |  |  | 16:45:00
 |  |  |  |  | 17:00:00