tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: de35c9a8-0fad-4713-9f09-6148c06830cf
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
MYH | Test | MYH | [NAME] for Multiple Adenoma, Y165C and G382D | MYH Gene Analysis | Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant  [NAME]: 3 mL  Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. [NAME] (Supply T519) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 5 days | 10 days | 1 | 81401 |  |  |  |  | Rochester
MYH | [NAME] | VARIES | Varies |  |  |  | Ambient
MYH | Result | 22440 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
MYH | Result | 22441 | [NAME] | [NAME] | Alphanumeric
MYH | Result | 22442 | Source | Source | Alphanumeric
MYH | Result | 22443 | Order Date | Order Date | Alphanumeric
MYH | Result | 22444 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
MYH | Result | 22445 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MYH | Result | 22446 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40959-9
MYH | Result | 22447 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
MYH | Result | 22448 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MYH | Result | 22449 | Reviewed By: | Reviewed By: | Alphanumeric
MYH | Result | 22450 | Release Date | Release Date | Alphanumeric
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 256SS

256SS
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-10-13 00:00:00 |  |  | MF | 2010-02-03 00:00:00 |  |  | mf | 2010-12-01 00:00:00 | 2010-01-28 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
Feeney |  | 2010-12-01 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 2ca940c8-0202-4388-8c6c-27c6ef95f963
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | 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
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October | 12.72 | 12.97 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November | 12.92 | 13.17 |  | 14.93 | 15.28 |  | 13.4 | 13.58
December | 12.62 | 12.86 |  | 13.9 | 14.21 |  | 14.5 | 14.67
January | 12.35 | 12.59 |  | 12.61 | 12.88 |  | 13.98 | 14.15
February | 11.77 | 12.43 |  | 11.81 | 12.2 |  | 12.68 | 13.35
March | 12.16 | 12.84 |  | 11.52 | 11.92 |  | 12.13 | 12.76
April 2/ | 12.2 | 12.88 |  | 11.15 | 11.54 |  | 11.76 | 12.36
May |  |  |  | 11.42 | 11.82 |  | 11.58 | 12.17
June |  |  |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.35777777777778 | 12.74222222222222 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated April 11, 2013.
Spreadsheet: 05bebf33-80a6-4d60-9106-6a3c0c2efbd0
Sheet: Sheet1

Unnamed: 0 | Expression of flanking genes in | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | transcriptional |  |  | non-transcriptional
Focal gene | germline | soma |  | germline | soma
germline-expressed gene | 0.734 | 0.585 |  | 0.702 | 0.674
soma-expressed gene | 0.515 | 0.771 |  | 0.603 | 0.728
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 732 |  | 732
 | FRA | 10200 |  | 10200
 | Exotic
 | Inflation
 | IRS- [NAME] | 35123 |  | 35123
 | OIS | 1138 |  | 1138
 | VNS | <100 |  | <100
 | Zero Coupon | <100 |  | <100
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 47193 | N/A*** | 47193
Estimated swap transaction volumes, week ending May 24, by product type and tenor (number of trades), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 210138d1359388138-data-validation-fromn-two-different-named-range-alternatives-data-for-help
Sheet: Claims in

 | 2010 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  | Bishops Stortford
 |  | Bedford
 |  | Boston
 |  | Bourne
 |  | Bury St Edmunds
 |  | Cambridge
 |  | [NAME]
 |  | Colchester
 |  | Diss
 |  | [NAME]
 |  | [NAME]
 |  | Halesworth
 |  | Hethersett (Hingham)
 |  | Holt
 |  | Huntingdon
 |  | Ipswich
 |  | [NAME]
 |  | March
 |  | [NAME]
 |  | [NAME]
 |  | Northampton
 |  | Peterborough
 |  | Royston
 |  | [NAME]
 |  | Essex South
 |  | Spalding
 |  | Swaffham
 |  | Ware
 |  | Whittlesey
 |  | Wisbech
 |  | TBC (Cornish)
 |  | *Pwllheli*
 |  | *Yorks*
 |  | Total
 | 2011 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  | Beaminster
 |  | Bedford
 |  | Bishops Stortford
 |  | Boston
 |  | Bourne
 |  | Bury St Edmunds
 |  | Cambridge
 |  | [NAME]
 |  | Colchester
 |  | Diss
 |  | [NAME]
 |  | [NAME]
 |  | Halesworth
 |  | Hethersett (Hingham)
 |  | Holt
 |  | Hungerford
 |  | Huntingdon
 |  | Ipswich
 |  | [NAME]
 |  | Louth
 |  | March
 |  | Newton
 |  | [NAME]
 |  | [NAME]
 |  | Peterborough
 |  | Royston
 |  | [NAME]
 |  | Essex South
 |  | Spalding
 |  | [NAME]
 |  | Stamford
 |  | [NAME]
 |  | Swaffham
 |  | Ware
 |  | Whittlesey
 |  | Wisbech
 |  | *Yorks*
 |  | Total
 | 2012 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  | Bedford
 |  | Bishops Stortford
 |  | Boston
 |  | Bourne
 |  | Bury St Edmunds
 |  | Cambridge
 |  | [NAME]
 |  | Chester
 |  | Chesterfield
 |  | Colchester
 |  | Diss
 |  | [NAME]
 |  | [NAME]
 |  | Halesworth
 |  | Hethersett (Hingham)
 |  | Holt
 |  | Huntingdon
 |  | Ipswich
 |  | [NAME]
 |  | Lincoln
 |  | March
 |  | Middlewich
 |  | [NAME]
 |  | [NAME]
 |  | Peterborough
 |  | Royston
 |  | [NAME]
 |  | Essex South
 |  | Spalding
 |  | [NAME]
 |  | Swaffham
 |  | Totnes
 |  | Ware
 |  | Whittlesey
 |  | Wimborne
 |  | Winchester
 |  | Wisbech
 |  | Witby
 |  | Total
 | 2013 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  | [NAME]
 |  | Bedford
 |  | Boston
 |  | Bourne
 |  | Bury St Edmunds
 |  | Cambridge
 |  | [NAME]
 |  | Colchester
 |  | Diss
 |  | [NAME]
 |  | [NAME]
 |  | Halesworth
 |  | Hethersett (Hingham)
 |  | Holt
 |  | Huntingdon
 |  | Ipswich
 |  | [NAME]
 |  | March
 |  | [NAME]
 |  | [NAME]
 |  | Peterborough
 |  | Royston
 |  | [NAME]
 |  | Essex South
 |  | Spalding
 |  | Swaffham
 |  | Ware
 |  | Whittlesey
 |  | Wisbech
 |  | Total
Spreadsheet: 146342d1332126219-trying-to-rank-a-win-loss-record-based-on-three-different-criteria-teamrankedlist
Sheet: Sheet2

School | Wins | Losses | Key | Rank |  | Rank | School | Wins | Losses
Boston College | 6 | 6 | 0.0606 | 5 |  | 1 | Clemson | 8 | 4
Clemson | 8 | 4 | 0.0804 | 1 |  | 2 | Wake Forest | 7 | 5
Florida State | 7 | 4 | 0.0704 | 3 |  | 3 | Florida State | 7 | 4
Maryland | 6 | 5 | 0.0605 | 6 |  | 4 | NC State | 7 | 4
NC State | 7 | 4 | 0.0704 | 4 |  | 5 | Boston College | 6 | 6
Wake Forest | 7 | 5 | 0.07050000000000001 | 2 |  | 6 | Maryland | 6 | 5
Spreadsheet: fb3c4184-2ec1-4399-b240-1be70fbfb500
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | CAPITAL IMPROVEMENTS MANAGEMENT OFFICE
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 898971 |  | B |  | 89060081 |  | 513829 |  | INC
 |  | 3090 |  | 898971 |  | B |  | 89060081 |  | 200000 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 713829
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 898971 |  | 611060 |  | 89060081 |  | 513829 |  | INC
 |  | 3090 |  | 898971 |  | 611060 |  | 89060081 |  | 200000 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 713829
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 713829
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 97040d1296240367-reference-within-another-worksheet-reference-team-stats-sheet
Sheet: Transfers

 | Transfers
 | Name |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week
 | First | Surname | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | A | Doe
 | B | Doe
 | C | Doe
 | D | Doe
 | E | Doe
 | F | Doe
 | G | Doe
 | H | Doe
 | I | Doe
 | J | Doe
 | K | Doe
 | L | Doe
 | M | Doe
 | N | Doe
 | O | Doe
 | P | Doe
 | Q | Doe
 | R | Doe
 | S | Doe
 | Target | 0.2
Spreadsheet: 717405d1612633979-combine-table-with-dsum-function-and-data-table-tool-color
Sheet: Sheet1

Product | Color | Sell |  | Product | Color | Sell
A | Blue | 100 |  |  |  |  |  |  | Please, without VBA & helper colomns
B | Green | 200 |  |  |  |  |  |  | I mean you can use range(E2:G2)
A | Blue | 300 |  |  | A | B | C
A | Blue | 400 |  | Blue
B | Green | 500 |  | Green
A | Green | 600
C | Blue | 100
A | Green | 800 |  | Colored rang(F5:H6) is My Result
 |  |  |  | Tbl | =Sheet1!$A$1:$C$9
 |  |  |  | Sum of Sell | Column Labels
 |  |  |  | Row Labels | A | B | C
 |  |  |  | Blue | 800 |  | 100
 |  |  |  | Green | 1400 | 700
Spreadsheet: 738530d1625090449-process-text-as-numbers-layouts
Sheet: Discounts & Adders

 | Paste your INTNOTE below: | Paste to Oasis INTNOTE | Copy to [CURRENCY] | Paste below:
 | [Text] | [Text] | [Text] | [Currency]
Line# | Text input | Show your work | Do some math | Obase result
0 | (81+19)*0.5*7
 | 26*3*0.5
 | (14.85+2.5)*3*0.5
 | 26*2*0.5
 | (14.85+2.5)*2*0.5
 | 26*6*0.5
 | (14.85+2.5)*5*0.5
 | 26*7*0.5
 | (14.85+2.5)*7*0.5
 | 26*12*0.5
 | (14.85+2.5)*12*0.5
 | 26*13*0.5
 | (14.85+2.5)*13*0.5
 | 26*23*0.5
 | (14.85+2.5)*23*0.5
 | 26*26*0.5
 | (14.85+2.5)*26*0.5
 | 589*0.5
Spreadsheet: 012c98d9-3553-4131-a2a5-7691e7f8f173
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 4/12/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Aug | Sep | Oct | Nov | Dec | Jan
 |  | 2011 | 2011 | 2011 | 2011 | 2011 | 2012
Exports | All wheat grain | 100293.5561977797 | 99522.92675633491 | 71072.68318192981 | 61287.0674509317 | 72638.94776939221 | 71446.9193831526
 | All wheat flour 1/ | 1774.176737995498 | 1101.235755082565 | 1001.548852084698 | 1182.22789550215 | 724.6641874465105 | 766.4467702242576
 | All wheat products 2/ | 638.1393125004184 | 549.3296270756846 | 578.0833548463472 | 590.3890889710959 | 516.2017512977295 | 564.9332796612778
 | Total all wheat | 102705.8722482756 | 101173.4921384932 | 72652.31538886085 | 63059.68443540495 | 73879.81370813644 | 72778.29943303815
Imports | All wheat grain | 4787.497059250498 | 6953.494081810501 | 10418.0207743668 | 7778.758318684501 | 8059.447301072999 | 7600.247650260301
 | All wheat flour 1/ | 910.9385033574675 | 966.4286300206705 | 981.0052582431053 | 894.7257383932828 | 828.4103513404834 | 1015.848956093801
 | All wheat products 2/ | 1414.443611985581 | 1291.319770104883 | 1287.648362690623 | 1697.331749228987 | 1642.153293160664 | 1588.438507200813
 | Total all wheat | 7112.879174593548 | 9211.242481936055 | 12686.67439530053 | 10370.81580630677 | 10530.01094557415 | 10204.53511355492
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 4/10/2012
Spreadsheet: 231997d1367296604-using-lists-to-sort-data-its-probably-simple-work
Sheet: company

accounts | bob | [NAME] | [NAME] | [NAME]
2 | yes | no | yes | no
3 | yes | no | no | yes
4 | no | no | no | no
5 | yes | no | no | no
6 | no | no | yes | yes
7 | yes | no | no | yes
 |  | drop down of bank numbers | list of any form of names
 |  | Drop down of names | list of bank numbers
 |  | example |  |  | other way
 |  | [NAME] | - |  | 2 | bob,[NAME]
 |  | [NAME] | 2, 6 |  | 3 | bob,[NAME]
 |  | [NAME] | 3,6,7
 |  | not really concerned on how it looks ill figure out those details
Spreadsheet: 125164d1318914483-excel-2007-common-finder-ex55
Sheet: Sheet1

 |  |  |  |  |  | IDEAL
POSSIBILITIES |  |  | 48 | 60 |  | 59
0 |  | 1 | 47 |  | 1 | 59
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
2
Spreadsheet: 742221d1627592326-get-calculations-to-spill-along-with-the-filtered-or-uniqued-data-samplez-tms-v2
Sheet: Main Sheet (Table)

PLATE | SIT. |  | Check | CURRENT | Balance |  |  |  |  |  | FLEET | Code | LOC
 |  |  |  |  |  |  |  |  |  |  | BHF321 | 21
ADB153 |  |  | SOLD | CLD589 | 0 |  |  |  |  |  | CLD589 | 84
ACF458 |  |  | SOLD | CFY414 | 0 |  |  |  |  |  | CFY414 | 95
BND225 |  |  | KEEP | EFS309 | 10 |  |  |  |  |  | EFS309 | 11
BHF321 |  |  | KEEP | TMS | -20 |  |  |  |  |  | TMS | 21
BGH854
CLD589 |  |  |  |  |  |  | Table
CFY414
DDE220
EFS309
TMS
Spreadsheet: 811700d1672754763-sumproduct-with-date-criteria-and-blanks-in-array-example-sheet2
Sheet: Sheet1

Month Number | Month | Year | formula | formula V2
7 | 2022-07-01 00:00:00 | 2022
8 | 2022-08-01 00:00:00 | 2022
9 | 2022-09-01 00:00:00 | 2022
10 | 2022-10-01 00:00:00 | 2022
11 | 2022-11-01 00:00:00 | 2022
12 | 2022-12-01 00:00:00 | 2022
1 | 2023-01-01 00:00:00 | 2023
Spreadsheet: 60064d1260572808-use-lookups-to-change-a-value-in-the-lookup-table-example-lookup
Sheet: Stock Table

Barcode | Item Discription | Price | Stock QTY
1 | Skins Top Mens | 40 | 4
2 | Runners Bag | 20 | 2
3 | Nike Tank Top Wmns | 35 | 1
4 | Asics 2140 Shoe | 80 | 0
5 | 12mm Spikes | 3.5 | 9
6 | 500ml Water Bottle | 1.5 | 15
Barcode | Item Discription | Price |  | Qty | Amount
1 |  |  |  | 1
4 |  |  |  | 3
3 |  |  |  | 1
6 |  |  |  | 1
 |  |  | Total
Spreadsheet: 58037d1258358239-formula-to-copy-to-values-to-specific-rows-sales-report-example
Sheet: Sheet1

Account Code |  | Effective Date | Doc. Type | Reference | Billing Name | Claim ID | Net Value | Tax |  | Total
 |  |  |  | 4000 | Post |  | 5 | 0.75 |  |  | 4
A |  | 2009-11-13 00:00:00 | Invoice | 720100 | Mr [NAME] | 12000 | 5 | 0.75 |  | 5.75 | 9
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 4001 | Assessment Charge |  | 7.5 | 1.125 |  |  | 4
 |  |  |  | 4002 | Inherited Charges |  | 8 | 1.2 |  |  | 4
 |  |  |  | 4003 | Storage |  | 10 | 1.5 |  |  | 4
 |  |  |  | 4004 | Recovery |  | 15 | 2.25 |  |  | 4
B |  | 2009-11-13 00:00:00 | Invoice | 720101 | Salvage Plc | 12001 | 40.5 | 6.075 |  | 46.575 | 9
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 4001 | Assessment Charge |  | 7.5 | 1.125 |  |  | 4
 |  |  |  | 4002 | Inherited Charges |  | 12 | 1.8 |  |  | 4
 |  |  |  | 4003 | Storage |  | 10 | 1.5 |  |  | 4
 |  |  |  | 4004 | Recovery |  | 15 | 2.25 |  |  | 4
 |  |  |  | 4005 | Paint & Materials |  | 3.5 | 0.525 |  |  | 4
C |  | 2009-11-13 00:00:00 | Invoice | 720102 | Insurance Ltd | 12002 | 48 | 7.199999999999999 |  | 55.2 | 9
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 4006 | Excess |  | 50 | 7.5 |  |  | 4
A |  | 2009-11-13 00:00:00 | Invoice | 720103 | Broker Corp. | 12003 | 50 | 7.5 |  | 57.5 | 9
Spreadsheet: 110010d1306821805-how-to-sum-categeory-wise-test_budget
Sheet: Summary

Categeory | JAN Amount | FEB Amount | MAR Amount | APR Amount | MAY Amount | JUN Amount | JUL Amount | AUG Amount | SEP Amount | OCT Amount | NOV Amount | DEC Amount
Transportation | 1500 | 0
Education | 500 | 0
Home | 300 | 4500
Spreadsheet: 702513d1604398668-formulas-with-live-time-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | This cell contains the live time using =now()
 |  |  |  | These are the delivery times, might need to change for after the live time |  |  |  |  |  | 11:00:00 | ebay
 |  |  |  |  |  |  |  |  |  | 11:30:00 | amazon
 |  |  |  |  |  |  |  |  |  | 11:40:00 | pc world
 |  |  |  |  |  |  |  |  |  |  |  |  | Would like these to tell me if they are outstanding or delivered based on the live time
Spreadsheet: 843400d1695247313-get-data-transfered-between-sheets-based-on-matching-critera-and-dates-over-45-days-test2
Sheet: Sheet2

A |  | 2023-08-23 00:00:00 | 160623WG415 | 12 CTNS (11@200PC, 1@170PC) | PALLET # JDW3008 | 200PC |  | STOCK | WB90222
B |  | 2023-08-13 00:00:00 | 070723WGR225 | 44 CTNS(50 CTNS (49@400PC/1@200PC) LESS 6 CTNS 12/09/23) | PALLET # [NAME] | 400PC |  |  | WB90223
C |  | 2023-07-19 00:00:00 | 070723WGR250 | 41 CTNS(51 CTNS (47@600PC/2@550PC, 1@450PC,1@200PC) LESS 4 CTNS 22/08/23, 6 CTNS 12/09/23) | PALLET # [NAME] | 600PC |  |  | WB90211
D |  | 2023-06-30 00:00:00 | 060623WGR350 | 18 CTNS (17@400PC, 1@300PC) | PALLET # JDW3035 | 400PC |  |  | WB90215
E |  | 2023-09-06 00:00:00 | 290623WGR350 | 18 (17@400PC, 1@260PC) | PALLET # [NAME] | 400PC |  |  | WB90216
F
G |  | 2023-04-17 00:00:00 | 130423WGR400 | 18ctns (41 CTNS (31@400PC/7@350PC/3@300PC) less 2 ctns 24/5/23-7 ctns 01/06/23, 6 CTNS 22/08/23, 8 CTNS 30/08/23) | PALLET # [NAME] | 400PC |  |  | WB90218
H |  | 2023-08-30 00:00:00 | 200623WGR400 | 13 CTNS | PALLET # [NAME] | 400PC |  |  | WB90226
I |  | 2023-07-17 00:00:00 | 200623WGR400 | 32 CTNS (31@400PC/1@50PC) | PALLET # [NAME] | 400PC |  |  | WB90226
J
K |  | 2023-03-20 00:00:00 | 090323WG430 | 13 CTNS(15 CTNS (14@350PC/1@80PC) LESS 2 CTNS 30/08/23) | PALLET # JDW2695 | 350PC |  |  | WB90227
L
M |  | 2023-07-05 00:00:00 | 300623WGR350 | 10 CTNS (12 CTNS LESS 2 CTNS 12/09/23) | PALLET #JDW3047 | [NAME] |  |  | WB90228
N |  | 2022-11-14 00:00:00 | 101122WG350 | 10 CTNS(25 CTNS (24@300PC/1@135PC) LESS 8 CTNS 27/06/23, 6 ctns 02/08/23, 2 CTNS 30/08/23) | PALLET # JDW2356 | 300PC |  |  | WB90229
O |  | 2023-05-29 00:00:00 | 230523WGR415 | 19 CTNS(18@200PC, 1@110) | PALLET # JDW2923 | 200PC |  |  | WB90230
Spreadsheet: 07b08a64-ec8d-4266-b15a-fbb1516e8a0a
Sheet: Sheet1

Line # | MAKE/MODEL | VENDOR NAME: | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Crown Victoria | Part # / Unit Cost
 | Part Name | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
 |  | 2003 | 2004 | 2005 | 2006 | 2008 | 2009
 | F250 Truck 4x4
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
 | F350 Truck 4x4
 |  | 2004 | 2005 | 2007 | 2011
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
Spreadsheet: 734455d1622177244-vlookup-sum-ifsum-im-in-too-deep-test-schedule-ans
Sheet: Sheet1

Employee list | SUN |  | MON |  | TUE |  | WED |  | THURS |  | FRI |  | SAT |  | Total Hours | SUN |  | MON |  | TUE |  | WED |  | THURS |  | FRI |  | SAT |  | Total Hours
May | 30 | HIDE | 31 | HIDE | 1 | HIDE | 2 | HIDE | 3 | HIDE | 4 | HIDE | 5 | HIDE |  | 6 | HIDE | 7 | HIDE | 8 | HIDE | 9 | HIDE | 10 | HIDE | 11 | HIDE | 12 | HIDE
 | 3:30p-MN |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | 8a-8:30p |  | 3:30p-MN |  | 1:30p-10p |  | - |  | 3:30p-MN |  | 3:30p-MN |  | - |  |  | - |  | 3:30p-MN |  | 3:30p-MN |  | - |  | - |  | 1:30p-10p |  | 8a-8:30p
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Manhours
6a-8a
8a-10a
10a-12p
12p-4p
4p-8p
8p-10p
10p-12a
12a-4a
4a-6a