tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155038d1336658218-multiple-excel-sheets-into-one-with-different-cell-numbers-sampleworkbook2
Sheet: Sheet1

Vendor | Status | Sku | Note: ETA dates are based on the absolute best information that is available from our vendors. We work with our suppliers daily in an effort to improve these dates. Unfortunately in some cases, due to reasons beyond our control (customs delays, truck mechanical issues, port strikes, etc), product may not arrive as scheduled. | Dept | PO_Number | Location | [NAME] | Appt_Qty | Comments
MC Commercial Inc. | [NAME] | 10136653 | GE WSLP1500JWW | 50 | 634 | Langley | 2 | 0 | ETA 04/23/2012
MC Commercial Inc. | [NAME] | 10136653 | GE WSLP1500JWW | 50 | 235 | Brampton | 4 | 0 | ETA 04/23/2012
LG Electronics Ltd. | [NAME] | 10139690 | LG WM1355HW | 50 | 734 | Langley | 2 | 0 | ETA 04/23/2012
Samsung Electronics Canada Inc | IN STORE | 10142007 | SAMSUNG WF520ABP | 50 | 123 | Edmonton | 12 | 0 | ETA 05/07/2012
Samsung Electronics Canada Inc | IN STORE | 10142007 | SAMSUNG WF520ABP | 50 | 14 | Brampton | 24 | 0 | ETA 05/07/2012
Samsung Electronics Canada Inc | GWG/CLR | 10142013 | SAMSUNG WF350ANG | 50 | 653 | Langley | 18 | 18 | 3/30/2012 6:00:00 AM
Samsung Electronics Canada Inc | GWG/CLR | 10142013 | SAMSUNG WF350ANG | 50 | 346 | Edmonton | 12 | 0 | ETA 04/23/2012
Samsung Electronics Canada Inc | GWG/CLR | 10142013 | SAMSUNG WF350ANG | 50 | 673 | Brampton | 30 | 0 | ETA 04/16/2012
Samsung Electronics Canada Inc | GWG/CLR | 10142015 | SAMSUNG WF340ANG | 50 | 7357 | Langley | 6 | 6 | 3/30/2012 6:00:00 AM
Samsung Electronics Canada Inc | GWG/CLR | 10142015 | SAMSUNG WF340ANG | 50 | 836 | Edmonton | 6 | 0 | ETA 04/23/2012
Samsung Electronics Canada Inc | GWG/CLR | 10142015 | SAMSUNG WF340ANG | 50 | 646 | Brampton | 6 | 0 | ETA 04/16/2012
Samsung Electronics Canada Inc | GWG/CLR | 10142015 | SAMSUNG WF340ANG | 50 | 35637 | Brampton | 12 | 0 | ETA 05/07/2012
Whirlpool Canada LP | IN STORE | 10146619 | WHIRLPOOL WFW9050XW | 50 | 743 | Langley | 30 | 30 | 3/26/2012 6:00:00 AM
Whirlpool Canada LP | IN STORE | 10146619 | WHIRLPOOL WFW9050XW | 50 | 23524 | Langley | 20 | 0 | ETA 04/24/2012
Whirlpool Canada LP | IN STORE | 10146619 | WHIRLPOOL WFW9050XW | 50 | 56246 | Langley | 15 | 0 | ETA 04/18/2012
Whirlpool Canada LP | IN STORE | 10146619 | WHIRLPOOL WFW9050XW | 50 | 637 | Edmonton | 27 | 0 | ETA 04/24/2012
Whirlpool Canada LP | IN STORE | 10146619 | WHIRLPOOL WFW9050XW | 50 | 252 | Edmonton | 1 | 0 | ETA 04/06/2012
Spreadsheet: 152241d1335298823-appropriate-formula-if-match-doc-nr
Sheet: Sheet3

[NAME] | Item | Qty
Spreadsheet: 681807d1591764619-collor-2-or-3-cells-in-a-week-map1
Sheet: Printkalender

 | Ma | Di | Wo | Do | Vr | Za | Zo |  |  | Ma | Di | Wo | Do | Vr | Za | Zo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIODE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIODE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WERK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZIEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OP WERK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOCIALE PROMOTIE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GELEGENHEIDSVERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIENSTVRIJSTELLING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZENDING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WERKONGEVAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STAKING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF VORIG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAAR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4/5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEESTDAGEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZAT-EN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZONDAGEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SLUITING
 |  |  |  | © | Daelman G
Spreadsheet: 690641d1597218284-multiple-outputs-on-xlookup-test-001
Sheet: ISSUE

 | TRANSACTION TYPE | DATE & TIME | PRODUCT DESCRIPTION | QUANTITY PER UOM | COMPONENT | POSITION | REASON | TO - EQUIPMENT | FROM - LOCATION | TO - LOCATION
 | ISSUE - FROM LOCATION ON-SITE TO EQUIPMENT | 2020-08-01 11:00:00 | ENGEN TEKPROL - 200 LITRES | 100 | MACHINE | NOT APPLICABLE | CLEANING - CLEANING | B151 | MAIN STORE | MAIN STORE
 | ISSUE - FROM LOCATION ON-SITE TO EQUIPMENT | 2020-08-01 11:24:00 | ENGEN TEKPROL - 200 LITRES | 150 | MACHINE | NOT APPLICABLE | CLEANING - CLEANING | B151 | MAIN STORE | MAIN STORE
Spreadsheet: 685678d1594137794-find-time-difference-between-duplicate-entry-test
Sheet: Sheet2

Name | Details | Date | Days Difference
A | XYZ | 2020-07-07 06:51:14
A | ABC | 2020-07-07 06:47:20
B | ABC | 2020-07-07 06:22:13
C | KHS | 2020-07-06 22:34:26
D | JHD | 2020-07-07 06:43:26
E | KDI | 2020-07-06 15:48:10
B | ABC | 2020-07-06 06:20:40
A | XYZ | 2020-07-06 10:52:26
D | JRY | 2020-07-07 02:21:25
Spreadsheet: 40074d1238412507-excel-2007-changing-the-value-of-a-cell-via-a-formula-test-book
Sheet: Industrial

Industrial
 | Conserviative | Bottom 25% | Top 25% | Todays Extremes in Color |  |  | Current
Commodity | Target: Buy | Target: Buy | Target: Sell | Low | High | Range | Current Price | Current Low | Current High
Tanker | 5 | 5 | 7 | 5 | 8
Gold Mine | 19 | 28 | 65 | 10 | 84
Steel Plant | 23 | 25 | 33 | 21 | 38 |  | 24 | 24 | 27
Industrial Machinery | 66 | 71 | 90 | 62 | 100
Renewable Energy Wind Farm | 65 | 69 | 85 | 61 | 94
High Speed Rail Line |  |  |  | 120 | 165 |  | 150
Trucking Company | 328 | 340 | 387 | 317 | 411
Coal Mine |  |  |  |  |  |  | 874
Diamond Mine |  |  |  |  |  |  | 932
Medical Device Manufacturer | 3057 | 3307 | 4306 | 2808 | 4806
Oil Refinery | 2567 | 3118 | 5322 | 2016 | 6425
Solar Power Plant | 2407 | 2726 | 4000 | 2089 | 4638
Oil Exploration Team | 8047 | 8151 | 8567 | 7943 | 8775
Spreadsheet: d0563211-e6b9-4b8b-a37e-e66b312bbbff
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7554 | 56576 | Galina | Balagurova | RUS | 165 | 00:21:07 | 00:01:06 | 00:26:45 | 00:01:20 | [NAME] | 1 | 01:09:56
7554 | 55935 | Nataliya | Sila-Novitskaya | RUS | 166 | 00:19:53 | [NAME] | 00:29:40 | 00:01:16 | 00:19:21 | 2 | 01:10:52
Spreadsheet: 98120d1297172695-macro-creates-new-sheet-with-data-from-other-sheets-customer-order
Sheet: Bananas

 | BANANAS
Variety | Quantity | [NAME] | List Price 2010 | List Price 2011 | Customer Discount | Comments
Cavendish | 20 | 2011-04-30 00:00:00 | 0.2 | 0.21 | 0.05 | Costa Rica
Baby | 16 | 2011-04-30 00:00:00 | 0.41 | 0.45 | 0.05 | Costa Rica
Manzano | 400 | 2011-06-30 00:00:00 | 0.45 | 0.5 | 0.04 | Costa Rica
Burro | 150 | 2011-07-31 00:00:00 | 0.6 | 0.7 | 0.12 | Costa Rica
Plantain | 600 | 2011-05-31 00:00:00 | 0.45 | 0.5 | 0.06 | Costa Rica
Spreadsheet: 483525d1475696893-carton-of-250-help-copamzorder
Sheet: NOT USED SKUS

ASIN | sku # | UPC | OUR SKU
B000PTKEKM | 6000 | 613103001951 | 6000 Roosevelt Full Popper
B000PT0AYC | 6005 | 613103001968 | 6005 Lincoln Full Popper
B000QWE6S4 | 6010 | 613103001975 | 6010 Roosevelt Top
B000QWCAB4 | 6015 | 613103001982 | 6015 Lincoln Top
B000WETCO4 | 6030 | 613103003856 | 6030 GAP FULL PRINCETON
B000UDXQO4 | 6035 | 613103003863 | 6035 GAP FULL PADUCAH
B000WB32WK | 6045 | 613103003887 | 6045 [NAME]
B002Z9J488 | 6056 | 613103010243 | 6056 Snow Cone Machine
B0057XO99I | 6072 | 613103041070 | 6072 GNP Little Bambino Black
B002Y4ZG7W | 6073 | 613103041087 | 6073 GNP Little Bambino Red
B00815EQEC | 6074 | 610708143345 | 6074 Pop Pup
B003WK4APQ | 6084 | 613103010212 | 6084 [NAME]
B002Z9GDYG | 6091 | 613103010281 | 6091 [NAME] 8OZ Top Red
B002YOR1FW | 6097 | 613103010359 | 6097 8 OZ Foundation Red Full
B002YOZQVS | 6098 | 613103010366 | 6098 8 ounce Foundation Blue
B002YOVGR6 | 6099 | 613103010373 | 6099 8 OZ Foundation Black Top
B002YOVGJO | 6100 | 613103010380 | 6100 8 ounce Foundation Red
B002YOOAM4 | 6103 | 613103010410 | 6103 6 OZ Foundation Red Full
B002YOZR7G | 6106 | 613103010441 | 6106 6 OZ Foundation Top Red
B002YOR1IE | 6108 | 613103010465 | 6108 4 ounce Foundation Black
B002YOS5FC | 6109 | 613103010472 | 6109 4 ounce Foundation Red
B002YOQ860 | 6111 | 613103010274 | 6111 4 ounce Foundation Black
B002YOV4S2 | 6112 | 613103010328 | 6112 4 ounce Foundation Red
B002YOXXX6 | 6116 | 613103010403 | 6116 6 ounce Foundation Black
B004Q5LJ9Q | 6200 | 613103031651 | 6200 Skyline Popcorn Machine
B00550GDCY | 6208 | 613103040882 | 6208 TopStar Twelve OZ Machine
B006BCK91G | 6210 | 613103042640 | 6210 POPHEAVEN
[NAME] | 6251 | 859767002648 | 6251 SS Stove Twister Poppper
B005ZVJT8S | 6255 | 613103041131 | 6255 Pop Frenzy Stir Popper
B0055OR32Y | 6260 | 859767002662 | 6260 Gumball Machine 15 W ST
[NAME] | 6304 | 613103031644 | 6304 Vortex Machine with Cart
B004DO2Q9M | 6303 | 613103009995 | 6303 Vortex Candy Machine
B003XMH9AG | 6057 | 613103032016 | 6057 Ice Cub Shaver
B005FFGJFA | 6252 | 859767002655 | 6252 Pit Popper
Spreadsheet: 848346d1699057412-conditional-formatting-with-transposed-data-book2-fusionista-
Sheet: Sheet3

 | 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
 | dolor & consectetur | sed & tempor | labore & magna | enim & veniam, | exercitation & nisi | ex & consequat. |  | velit & dolore | nulla & sint | non & in | officia & anim | laborum. & perspiciatis | iste & sit | doloremque & rem | ipsa & illo | et & beatae | sunt & enim | quia & aspernatur | aut & quia | dolores & ratione | nesciunt. & quisquam | dolorem & dolor | consectetur, & sed | numquam & tempora | labore & magnam | voluptatem. & ad | quis & ullam | laboriosam, & aliquid | commodi & autem | iure & in | velit & nihil | vel & dolorem | quo & pariatur?
Yellow
Grey
Green
Red
Spreadsheet: 725383d1616663240-comparison-of-array-for-matching-and-non-matching-values-sample-excel-worksheet
Sheet: Sheet1

category | Matching | Non Matching |  |  | [NAME] | 9,11,19,20,21,22,23,29,37,41,127,267,347,388,427,447,467
11,11
29,29
29,29,997
21
11
11
9
11
11
11
9
11
21
9,11,9,9,9,181
9,11
101,111
9
11
Spreadsheet: 101604d1299696163-how-to-bring-a-weekly-total-into-a-monthly-total-example
Sheet: Sheet1

Daily Key Drivers
 | # Retail Referrals | # BBG Referrals | Total Referrals | Presentations | Kits in hand | Kits submitted
Mon | 1 | 1 | 2
[NAME] | 1 | 1 | 2
Weds | 1 | 1 | 2
Thurs | 1 | 1 | 2
Fri | 1 | 1 | 2
Week | 5 | 5 | 10 | 0 | 0 | 0
Month
Spreadsheet: 142751d1329999624-zero-instead-of-value-in-cells-operating-text-with-text-and-text-with-numbers-example
Sheet: TEST

 |  |  |  |  | CONTRACT AWARD VALUE |  |  |  |  |  |  |  | INTERIM PROGRESS PAYMENT APPLICATION VALUE |  |  |  | 00:00:00 | CERTIFIED VALUE |  |  |  |  |  |  | ESTIMATED FINAL VALUE
ITEM | [NAME] | Cores | Area (mm²) | COMMENT | UNIT | SUPPLY |  |  | INSTALLATION |  |  | TOTAL                         VALUE | QUANTITIES |  | SUPPLY TOTAL              TO DATE (A) | INSTALL TOTAL                   TO DATE (B) | TOTAL TO CERTIFICATE  DATE (A+B) | QUANTITIES |  | SUPPLY TOTAL              TO DATE (A) | INSTALL TOTAL                   TO DATE (B) | TOTAL TO CERTIFICATE  DATE (A+B) | DIFFERENCE | COMMENT | QUANTITIES |  | SUPPLY | INSTALL | TOTAL                                     VALUE
 |  |  |  |  |  | QTY | RATE | TOTAL | QTY | RATE | TOTAL |  | SUPPLY | INSTALL |  |  |  | SUPPLY | INSTALL |  |  |  |  |  | SUPPLY | INSTALL | VALUE | VALUE
1 | Cable Type
 | Instrumentation Cabling
 | [NAME] | 2Pr | 1.0 |  | m | F/Issue | 2.52 |  | 3800 | 2.47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 3800
 | PVC SWA | 3 | 1.5 |  | m | F/Issue | 2.04 |  | 6000 | 2.27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 6000
 | PVC SWA | 7 | 1.5 |  | m | F/Issue | 3.14 |  | 1500 | 2.57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 1500
 | PVC SWA | 12 | 1.5 |  | m | 100 | 5.54 |  | 100 | 2.43 |  |  | 100 |  |  |  |  | 100 |  |  |  |  |  |  | 100 | 100
2 | [NAME] and MCC Assistance
 | MCC's |  |  |  | ea | F/Issue |  |  | 3 | 489.26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 3
 | Install Airconditioners |  |  |  | ea | F/Issue |  |  | 8 | 63.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 8
 | Install Roofs |  |  |  | ea | F/Issue |  |  | 3 | 1169.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 3
 | Install Door Handles |  |  |  | ea | F/Issue |  |  | 6 | 177.26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 6
 | Transformers |  |  |  | ea | F/Issue |  |  | 3 | 582.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Issue | 3
 | Seal Penetrations (Substations) |  |  |  | ea | 5 | 319.23 |  | 5 | 348.19 |  |  | 5 |  |  |  |  | 5 |  |  |  |  |  |  | 5 | 5
 | Commissioning team (2 persons x 8 weeks) |  |  |  | Lot |  |  |  | 1 | 50835.04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Sundry Materials required to complete the works per BoQ defined scope |  |  |  | Lot | 1 | 171638.61 | 171638.61 |  |  |  |  | 1 |  |  |  |  | 0.85 |  |  |  |  |  |  | 1
 | Total, Excluding Taxes:
Spreadsheet: 148378d1333378317-multi-worksheet-2-dimensional-lookups-help-appreciated-sample
Sheet: May 2012

 |  |  |  |  | SLA's & Client Specific Notes
 | Month |  |  | May
 | Week |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | Week 5
 | Day |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Mailing Code | Date | Column1 | Column2 | 30/04/2012 | [NAME] | [NAME] | 03/05/2012 | 04/05/2012 | 05/05/2012 | [NAME] | [NAME] | 08/05/2012 | 09/05/2012 | [NAME] | 11/05/2012 | 12/05/2012 | 13/05/2012 | 14/05/2012 | 15/05/2012 | 16/05/2012 | 17/05/2012 | 18/05/2012 | 19/05/2012 | 20/05/2012 | 21/05/2012 | 22/05/2012 | 23/05/2012 | 24/05/2012 | 25/05/2012 | 26/05/2012 | 27/05/2012 | 28/05/2012 | 29/05/2012 | 30/05/2012 | 31/05/2012 | 01/06/2012
CH96 |  |  |  |  |  |  |  | Text
CH97 |  |  |  |  | Text | Text | Text |  |  |  |  |  |  | Text
HH81 |  |  |  |  |  |  | Text | Selections |  |  | Artwork Delivered | Data Cleanse | Data Code | Text |  |  |  |  |  |  | Text
BG37 |  |  |  |  | Text |  | [NAME] |  |  |  |  |  |  | Order Source Codes |  |  |  |  |  | Text | Text | Selections |  |  |  | Data Cleanse | Data Code | Text |  |  |  |  |  |  | Text
CH98 |  |  |  | Text | Text | Text | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Order Source Codes |  |  |  | Artwork Delivered | Text |  | Selections |  |  |  |  | Data Cleanse | Data Code | Text
CH99 |  |  |  |  |  | Text |  |  |  |  | [NAME] | Agree Contact Strategies |  | [NAME] |  |  |  | Text
HH82 |  |  |  |  |  |  |  |  |  |  | Internal Strategy Meeting |  |  |  |  |  |  | Text |  |  |  |  |  |  | [NAME] | Agree Contact Strategies |  | [NAME] |  |  |  | [NAME] (CLARIFY)
CH100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internal Strategy Meeting
Spreadsheet: 148c3456-74a0-426b-8719-0b3e05aff34d
Sheet: G

 | Appendix G: Crop Yields
Year | DL Corn (BPA) | DL Wheat (BPA)
1910 | 14.4
1911 | 5
1912 | 29.9
1913 | 9.1
1914 | 24.1
1915 | 21.3
1916 | 20.6
1917 | 23
1918 | 21.3
1919 | 21.3
1920 | 22.6
1921 | 11.6
1922 | 22
1923 | 33
1924 | 17.8
1925 | 19.2
1926 | 5.8
1927 | 23.1
1928 | 24
1929 | 20.1
1930 | 26.4
1931 | 14
1932 | 16.6
1933 | 11.6
1934 | 4.9
1935 | 9.9
1936 | 9.3
1937 | 6.5
1938 | 11
1939 | 10.1
1940 | 14.3
1941 | 21.1
1942 | 24.7
1943 | 12.7
1944 | 18.6
1945 | 21.4
1946 | 16.7
1947 | 17
1948 | 18.9
1949 | 15.9
1950 | 20
1951 | 13
1952 | 12.8
1953 | 11
1954 | 14.3
1955 | 5
1956 | 9 | 16.7
1957 | 19 | 24.7
1958 | 18.7 | 32.3
1959 | 12.6 | 22.5
1960 | 11 | 29.6
1961 | 18 | 24.9
1962 | 18 | 23
1963 | 23 | 16.9
1964 | 16 | 16
1965 | 24 | 23
1966 | 33 | 33.9
1967 | 29 | 24.6
1968 | 13 | 26.8
1969 | 23 | 31
1970 | 25 | 32
1971 | 32 | 37
1972 | 41 | 37.9
1973 | 40 | 35.9
1974 | 30.1 | 31.6
1975 | 30 | 33.6
1976 | 18 | 26.8
1977 | 34 | 36.8
1978 | 27 | 31.8
1979 | 42 | 31
1980 | 34 | 38.8
1981 | 65 | 45.7
1982 | 60 | 43.7
1983 | 35 | 46.6
1984 | 38 | 39.9
1985 | 55 | 41.7
1986 | 65 | 37.5
1987 | 60 | 46.8
1988 | 60 | 36.9
1989 | 62 | 25
1990 | 59 | 38
1991 | 59 | 35
1992 | 83 | 22
1993 | 64 | 40.8
1994 | 57 | 31.1
1995 | 46 | 45.6
1996 | 76 | 39
1997 | 59 | 43.9
1998 | 73 | 43
1999 | 79 | 49
2000 | 33 | 30
2001 | 54 | 39
2002 | 21 | 27
2003 | 23 | 35
2004 | 62 | 22
2005 | 51 | 36
2006 | 61 | 21
2007 | 80 | 50
2008 | 82
2009 | 91 | 57
Spreadsheet: 79285d1279563956-excel-2007-subtract-if-a-cell-meets-criteria-new-idea
Sheet: salidas

solicitante | Descripciòn | [NAME] | Fecha | Almacenista
 | [NAME] |  | 19/07/2010 11:47:18
da | Bandas |  | 19/07/2010 11:47:40
da | Bandas |  | 19/07/2010 11:47:40
da | Bandas |  | 19/07/2010 11:47:40
da | Bandas |  | 19/07/2010 11:47:40
da | Bandas |  | 19/07/2010 11:47:40
da | Bandas |  | 19/07/2010 11:47:40
 | Bandas |  | 19/07/2010 11:49:03
 | [NAME] | 1 | 19/07/2010 12:27:14
 | [NAME] | 1 | 19/07/2010 12:27:14
 | Baleros | 1 | 19/07/2010 12:27:14
 | Bandas | 1 | 19/07/2010 12:27:14
 | Barras | 1 | 19/07/2010 12:27:14
pedro | [NAME] | 1 |  |  |  | pedro
pedro | Baleros | 1 |  |  |  | pedro
pedro | Baleros | 3 |  |  |  | pedro
pedro | Barras | 4 |  |  |  | pedro
pedro | Baleros | 3 |  |  |  | pedro
 |  | 1
 | Baleros | 1
 | Baleros | 1
Spreadsheet: 67471d1268088041-vba-autofilter-results-copied-to-array-choosemetercode_ver02
Sheet: first

MeterCode | Values | ExportCode
ABM_G1 | 2324 | 1
AAB_G1 | 234 | 1
[NAME] | 557 | 1
WWE_W1 | 78 | 2
JHY_G1 | 2324 | 2
KJH_G2 | 24 | 2
HEU_E1 | 2324 | 1
BNN_S1 | 199 | 2
REG_G1 | 2324 | 2
REG_G2 | 2277 | 2
REG_G3 | 2324 | 1
[NAME] | 441 | 2
HTR_E1 | 337 | 2
HTC_G1 | 258 | 2
PYL_G1 | 147 | 2
NMB_E1 | 1188 | 2
MKL_E1 | 2177 | 2
SXD_E1 | 84 | 2
ZSD_E1 | 87 | 1
[NAME] | 32 | 1
Spreadsheet: 884729d1733985972-find-data-within-a-dynamic-range-calendar-feed-2-
Sheet: data (2)

 | Date | ID | Project | Review
 | 2025-03-21 00:00:00 | P0404 | Project AAA | R5
 | 2025-03-21 00:00:00 | P0562 | Project AAB | R7
 | 2025-03-21 00:00:00 | P0578 | Project CGA | R7
 | 2025-03-07 00:00:00 | P0702 | Project MRG | R7
 | 2025-03-07 00:00:00 | P0573 | Project RSA | R6
 | 2025-02-04 00:00:00 | P0509 | Project HRD | R7
 | 2025-02-04 00:00:00 | P0573 | Project RSA | R5
 | 2024-12-18 00:00:00 | P0404 | Project AAA | R4
 | 2024-12-18 00:00:00 | P0573 | Project RSA | R4
 | 2024-12-18 00:00:00 | P0206 | Project MES | R5 |  |  | First, convert your data into an Excel Table and include the dates as part of the table.
 | 2024-12-18 00:00:00 | P0702 | Project MRG | R6 |  |  | The benefit of an Excel Table is that it automatically expands when new data is added to the row beneath the last one, and any formulas linked to the table will adjust accordingly.
 |  |  |  |  |  |  | In cell D4 in calendar, copy across and down:
Spreadsheet: 477443d1472290438-program-for-stitching-unit-book2
Sheet: Sheet1

CLIENT NAME |  |  | ORDER |  |  |  |  |  | DELIVERY |  |  |  |  |  |  | LABOR CHARGE
 |  |  | DATE | QTY | SIZE | TOTAL |  |  |  |  | DATE | QTY | SIZE | TOTAL
poulco |  |  | 2016-08-27 00:00:00 | 500 | SMALL | 1000 |  |  | poulco |  | 2016-08-27 00:00:00 | 300 | SMALL | 600 s |  | UMMU |  | DATE | QTY | SIZE | PRICE | TOTAL CASH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-08-27 00:00:00 | 100 | MEDIUM | 200 | 800
poulco |  |  |  |  | SMALL |  |  |  | poulco |  |  |  | SMALL |  |  | UMMU |  |  |  | SMALL | SMALL * 1.5 * qty
saidacon |  |  |  |  | MEDIUM |  |  |  | saidacon |  |  |  | MEDIUM |  |  | RAMA |  |  |  | MEDIUM | MEDIUM * 2 * qty
pmnatra |  |  |  |  | LARGE |  |  |  | pmnatra |  |  |  | LARGE |  |  | HASNA |  |  |  | LARGE | LARGE *2.5 * qty
pandicod |  |  |  |  | X LARGE |  |  |  | pandicod |  |  |  | X LARGE |  |  | SINDHU |  |  |  | X LARGE | X LARGE * 3 * qty
NAME 5 |  |  |  |  |  |  |  |  | NAME 5 |  |  |  |  |  |  | NAME 5
NAME 6 |  |  |  |  |  |  |  |  | NAME 6 |  |  |  |  |  |  | NAME 6
NAME 7 |  |  |  |  |  |  |  |  | NAME 7 |  |  |  |  |  |  | NAME 7
[NAME] 8 |  |  |  |  |  |  |  |  | [NAME] 8 |  |  |  |  |  |  | [NAME] 8
NAME 9 |  |  |  |  |  |  |  |  | NAME 9 |  |  |  |  |  |  | NAME 9
NAME 10 |  |  |  |  |  |  |  |  | NAME 10 |  |  |  |  |  |  | NAME 10
NAME 11 |  |  |  |  |  |  |  |  | NAME 11 |  |  |  |  |  |  | NAME 11
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - 1E4 PAIN CLINIC

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
1E4 PAIN CLINIC (BAG ORDER)
FACILITY: | UNIVERISITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-HUCK TOWELS |  |  |  | BP0009 |  | 4
5-GOWN STD XL |  |  |  | BP0021 |  | 3
UPDATED:
June 17th 2009