tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870275d1716814033-suitable-formula-for-matching-the-work-counter-code-for-each-name-for-each-date-roster-trial
Sheet: Roster-May

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
Counter | Staff no. | Name | Tel no. | 2024-05-01 00:00:00
1 | PWHK124 | [NAME] | 1111111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | OW A | GAP-A | OWA | GAP-A | GAP-A | OFF | OFF | GAP-A | BT | BT | BT | BT | OFF
2 | PWHK152 | Dennis | 2222222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | GAP-A | CCP-A | OFF | SL | OFF | GAP-A | GAP-A | CCP-A | GAP-A | OFF | GAP-A | GAP-A | GAP-A
3 | PWHK153 | Carol | 333333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | GAP-A | SL | OFF | GAP-A | OFF | GAP-B | GAP-B | GAP-B | GAP-B | OFF | GAP-A | GAP-A | GAP-A
4 | PWHK154 | Emma | 444444 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH | SH | SH | OFF | SH | SH | SH | SH | OFF | CCP-B | OFF | CCP-A | CCP-A | CCP-A
5 | PWHK147 | [NAME] | 5555555 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCP-A | SH | OWHK-A | OFF | PAP-B | SH | PAP-B | PAP-B | PAP-B | SMP-B | OFF | OWHK-A | PAP-B | PAP-B
6 | PWHK148 | [NAME] | 6666666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH | AL | AL | OWHK-A | OWHK-A | OWHK-A | OFF | OWHK-C | OWHK-C | OWHK-A | OWHK-A | OFF | OWHK-A | OWHK-C
7 | PWHK149 | [NAME] | 7777777 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SMP-B | SMP-B | SMP-B | OFF | SMP-B | SMP-B | SMP-B | SMP-B | SH | SH | OFF | SMP-B | SMP-B | SMP-B
 | 1299 | [NAME] | 9999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A |  |  |  |  |  | GAP-A | GAP-A
 | 1370 | Tsely | 8888888 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OWHK-C |  |  |  |  |  |  |  | OWHK-C |  | OWHK-A | OWHK-A | OWHK-C
 | 1274 | [NAME] | 12121212 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A
Spreadsheet: 889020d1739685099-how-to-find-the-time-slot-when-all-hospitals-are-busy-aht61-emergency-room-spill-365-aligw-take2
Sheet: BusySlot

Hospital Unit | Busy StartTime | Busy StopTime | Duration (min)
A | 2024-05-13 09:05:00 | 2024-05-14 00:00:00 |  |  |  |  |  |  |  |  | 2024-05-13 09:50:00
C | 2024-05-13 09:05:00 | 2024-05-13 10:03:00 |  |  |  |  |  |  |  | 2025-01-25 20:34:59.995000 | 2025-01-26 01:19:59.995000
B | 2024-05-13 09:05:00 | 2024-05-14 12:35:00 |  |  |  |  |  |  |  | 2025-02-09 01:04:59.995000 | 2025-02-09 02:19:59.995000
C | 2024-05-23 14:50:00 | 2024-05-23 14:50:00
A | 2024-05-24 12:00:00 | 2024-05-24 12:15:00
A | 2025-02-09 00:57:01 | 2025-02-09 02:21:00
B | 2025-02-09 00:57:01 | 2025-02-09 06:21:00
C | 2025-02-09 00:57:01 | 2025-02-09 05:21:00
A | 2024-05-31 20:55:00 | 2024-06-01 06:30:00
C | 2024-05-31 11:54:00 | 2024-06-01 00:00:00
A | 2024-05-31 01:38:00 | 2024-05-31 05:04:00
A | 2024-06-03 17:39:00 | 2024-06-03 21:01:00
C | 2024-06-04 10:12:00 | 2024-06-05 00:00:00
A | 2024-06-05 23:16:00 | 2024-06-06 06:53:00
A | 2024-06-04 19:48:00 | 2024-06-04 20:56:00
C | 2024-06-04 16:41:00 | 2024-06-04 19:03:00
A | 2024-06-06 21:01:00 | 2024-06-07 04:34:00
B | 2024-06-05 08:16:00 | 2024-06-05 10:00:00
B | 2024-06-05 09:11:00 | 2024-06-05 21:21:00
A | 2025-01-25 05:21:00 | 2025-01-25 18:49:00
B | 2025-01-25 11:21:00 | 2025-01-25 19:44:00
C | 2025-01-25 20:00:00 | 2025-01-26 05:33:00
B | 2025-01-25 20:31:00 | 2025-01-26 01:33:00
A | 2025-01-25 22:23:00 | 2025-01-26 07:56:00
A | 2025-01-25 10:52:00 | 2025-01-25 23:50:00
Spreadsheet: 134391d1325263106-formula-to-pull-cell-info-from-workbook-excel-sample
Sheet: 6451

[NAME] Record |  |  | RO NUMBER | 6433
 | TOTAL PARTS/SERVICE |  | VEHICLE MAKE: | Scion
 | TOTAL RECIVABLE | 0 | MODEL: | Xa | OWNER NAME:
 | DEDUCTABLE |  | YEAR: | 2005 | VIN NO:
 | CUSTOMER PAY |  | LICENSE NO: |  | INSURANCE:
 | BALANCE DUE
 | [NAME] | CLOSED |  | IN | OUT | DATE
 |  | OPEN | MILEAGE |  |  | DROPPED OFF | PICKED UP
 |  | CLOSED |  |  |  | 2011-11-20 00:00:00 | 2011-12-28 00:00:00
DATE | INVOICE No. | SUPPLIER | PART DESCRIPTION | USED/NEW/SVC | CHECK NO. | AMOUNT PAID | CUST PAY | DEDUCT | PYMNT RCVD
2011-11-23 00:00:00 | 994966 | import auto glass | ati door glass | a/m new |  | 47.39
2011-11-23 00:00:00 | 103943-1 | cabe scion | fr door glass | new | 21661 | 68.26
2011-11-23 00:00:00 | 103943 | cabe scion | mirror assy, fr door glass | new | 21661 | 135.06
2011-11-23 00:00:00 | 21673 | cabe scion | outer mirror coverm weatherstrip blackout tape | new | 21673 | 57.05
2011-12-28 00:00:00 |  |  | deductable |  |  |  |  | 250
2011-12-28 00:00:00 |  |  | vehicle pu
Spreadsheet: 02a73165-9435-493e-8f6c-300ae36db188
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
4586 | 28041 | [NAME] | [NAME] | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:25:02
Spreadsheet: 544420d1508891437-power-query-question-sample-1
Sheet: DATA

ITEM # | [NAME] | col1 | [NAME] | col3 | col4 | col5 | col6 | col7 | [NAME]
01 | sample 1 | 10 | 5 | 25 | 4 | 40 | 22.4
02 | sample 2 | 10 | 5 | 25 | 4 | 50 | 3
03 | sample 3
04 | sample 4 | 6 | 5 | 15 | 4 | 25 | 3
05 | sample 5
06 | sample 6
07 | sample 7 | 20 | 5 | 40 | 4
08 | sample 8
09 | sample 9
10 | sample 10
11 | sample 11 | 15 | 5
12 | sample 12 | 15 | 5 | 25 | 4 | 50 | 3
13 | sample 13 | 10 | 5 | 25 | 4
14 | sample 14
15 | sample 15
16 | sample 16
17 | sample 17
18 | sample 18 | 6 | 5 | 12 | 4
Spreadsheet: a10a35ee-7487-4794-923b-cf1f154fc5f0
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
FLCA | Test | FLCA | [NAME], ALK (2p23) Rearrangement, FISH, Tissue | [NAME], ALK (2p23), FISH, Ts | Fluorescence In Situ Hybridization (FISH) |  |  |  |  | Varies | Provide a pathology report with each specimen. The laboratory will not reject specimens that arrive without this information but will hold the specimen until a pathology report is received.   [NAME] Type: Formalin-fixed, paraffin-embedded unknown primary tumor cancer tissue block Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretative report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 7 days | 9 days |  | Profile |  |  |  |  | Rochester
FLCA | [NAME] | TISSUE | Tissue |  |  |  | Ambient
FLCA | Order Question | CG583 | Reason For Referral |  | Plain Text
FLCA | Result | 51141 | [NAME] | [NAME] | Alphanumeric
FLCA | Result | 51142 | [NAME] | [NAME] | Alphanumeric
FLCA | Result | 51143 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
FLCA | Result | 51144 | Order Date | Order Date | Alphanumeric
FLCA | Result | CG583 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FLCA | Result | 51146 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
FLCA | Result | 51147 | Result | Result | Alphanumeric
FLCA | Result | 51148 | Interpretation | Interpretation | Alphanumeric
FLCA | Result | 51149 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FLCA | Result | 51150 | Reviewed By | Reviewed By | Alphanumeric
FLCA | Result | 51151 | Release Date | Release Date | Alphanumeric
Spreadsheet: 99179d1297898056-dynamically-select-non-zero-rows-labels-and-corresponding-values-book2
Sheet: Data

Item | 2011 | 2012 | 2013 | 2014 | 2015
Alpha | 100 | 0 | 100 | 0 | 200
Beta | 0 | 100 | 0 | 50 | 0
[NAME] | 0 | 150 | 150 | 0 | 150
Delta | 200 | 250 | 0 | 250 | 0
Epsilon | 0 | 0 | 500 | 0 | 500
[NAME] | 0 | 0 | 500 | 100 | 500
Gamma | 300 | 0 | 0 | 0 | 0
Hotel | 400 | 0 | 100 | 0 | 100
Indigo | 0 | 100 | 0 | 100 | 0
Total
Spreadsheet: 267458d1380082850-capturing-and-saving-updated-data-from-fields-driven-by-selections-from-drop-down-menu-20130924-1230-mockup-mr-excel
Sheet: Data-updated

EmployeeID | Name | Overall message | Strengths | Skills that have improved | Development objectives | Skill 1 | Skill 2 | Skill 3
1 | Venkman, [NAME]
2 | Spengler, Egon
3 | Zeddmore, Winston
4 | Stanz, [NAME]
5 | [NAME], [NAME]
6 | Bourne, [NAME]
7 | Golightly, Holly
8 | Peck, [NAME]
9 | Jones, Indiana
Spreadsheet: 742633d1627923984-attempted-to-set-up-formula-for-ifs-statement-using-or-but-excel-is-saying-invalid-dan-easy-lookup-aligw
Sheet: JAN

 |  | PH 1 | PH 2 | UH 1 | UH 2 | ILL 1 | ILL 2 | APP |  |  | PH | Paid Holiday
2021-06-25 00:00:00 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | UH | Unpaid Holiday
 |  |  |  |  |  |  |  |  |  |  | ILL | Ill
 |  | If 1 Here, Show Paid Holiday |  | If 1 Here, Show Unpaid Holiday |  | If 1 Here, Show Ill |  | If 1 Here, Show Appointment |  |  | APP | Appointment
Spreadsheet: 768562d1645025993-currency-data-from-web-to-excel-number-format-mbclarke-exchange-rates
Sheet: Top three

Column1 | Currency | Code | Bank Selling | Bank Buying | Adjusted Selling | Adjusted Buying
 | EURO | EUR | 17.4852 														0.0572 | 16.8422 														0.0594
 | BRITISH POUND | GBP | 20.9082 														0.0478 | 20.0961 														0.0498
 | UNITED STATES DOLLAR | USD | 15.3657 														0.0651 | 14.8764 														0.0672
 |  |  |  | Would like the USD Buying rate to be 14.8786, just to 4 decimals and to remain that way each time I refresh the rates. I have set it to refresh every 10 minutes, but not sure if that is working either.
Spreadsheet: 1718994d-1d4c-47e1-84f4-dfcec1395637
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | [NAME] | [NAME] | 27 | 1 | 8 | 6 | 3 | 2 | 4 | 0 | 0 | 2 | 2 | 0 | 3 | 2 | 2 | 4 | 3 | 17 | 18
5 | [NAME] | Pavlína | 15 | 25 | 7 | 1 | 1 | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 1 | 1 | 2 | 0 | 3 | -5 | 2
6 | Bělohoubková | [NAME] | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | -2 | 0
9 | Petrásková | [NAME] | 28 | 32 | 5 | 2 | 4 | 2 | 0 | 0 | 2 | 3 | 5 | 0 | 2 | 1 | 3 | 1 | 2 | 9 | 10
13 | Habětínková | [NAME] | 8 | 43 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | -7 | 0
14 | Dvořáková | [NAME] | 16 | 12 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 1 | 2 | 0 | 3 | 0 | 2
15 | Kramperová | Hana | 32 | 8 | 8 | 5 | 2 | 0 | 2 | 2 | 1 | 2 | 3 | 0 | 0 | 2 | 2 | 1 | 2 | 9 | 12
22 | Jedličková | Markéta | 27 | 9 | 6 | 0 | 1 | 1 | 0 | 0 | 1 | 4 | 5 | 0 | 3 | 0 | 1 | 3 | 3 | 4 | 3
23 | De La Quintana | Catalina | 17 | 53 | 3 | 3 | 5 | 3 | 3 | 3 | 2 | 1 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 19 | 18
31 | Březinová | Renáta | 23 | 55 | 11 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 1 | 0 | 2 | 2 | 3 | 8 | 10
 |  |  | 40 | 0 | 54 | 23 | 16 | 8 | 9 | 5 | 7 | 21 | 28 | 0 | 13 | 8 | 18 | 14 | 25 | 52 | 75
 |  |  |  |  | 43% |  | 50% |  | 56%
Spreadsheet: 64712d1265525947-summarize-weekly-inventory-help
Sheet: Sheet1

Inventory
2010-01-02 00:00:00 | Stock box |  | 2010-01-03 00:00:00 | Stock box |  | 2010-01-04 00:00:00 | Stock box |  | 2010-01-05 00:00:00 | Stock box
Chicken | 12 |  | RoastBeef | 30 |  | ChickenStrips | 10 |  | ChickenStrips | 10
ChickenGarlic | 10 |  | Steak/Beef | 10 |  | Chicken/bacon | 25 |  | Chicken/bacon | 25
ChickenRoasted | 20 |  | Chicken | 12 |  | HAM | 20 |  | HAM | 20
ChickenStrips | 10 |  | ChickenGarlic | 10 |  | HAM&Beef | 25 |  | HAM&Beef | 25
Chicken/bacon | 25 |  | ChickenRoasted | 20 |  | Chicken | 12 |  | Chicken | 12
HAM | 20 |  | ChickenStrips | 10 |  | ChickenGarlic | 10 |  | ChickenGarlic | 10
HAM&Beef | 25 |  | Chicken/bacon | 25 |  | ChickenRoasted | 20 |  | ChickenRoasted | 20
RoastBeef | 30 |  | HAM | 20 |  | RoastBeef | 30 |  | RoastBeef | 30
Steak/Beef | 10 |  | HAM&Beef | 25 |  | Steak/Beef | 10 |  | Steak/Beef | 10
Total Weekly Inventory Stock
RoastBeef
Steak/Beef
Chicken
ChickenGarlic
ChickenRoasted
ChickenStrips
Chicken/bacon
HAM
HAM&Beef
Spreadsheet: 796837d1663589046-function-or-and-date-compare
Sheet: Sheet1

contact date | opp create date | have two column since 2020 onward
2020-05-26 00:00:00 | -
- | -
- | -
2020-07-27 00:00:00 | -
- | -
- | -
2018-09-10 00:00:00 | -
2020-02-03 00:00:00 | -
2022-01-12 00:00:00 | 2022-02-16 00:00:00
2020-01-15 00:00:00 | -
- | -
2019-08-13 00:00:00 | 2018-08-13 00:00:00
- | 2021-08-24 00:00:00
- | 2018-09-10 00:00:00
Spreadsheet: 7e85b0ed-5993-4cf6-9fc2-e6cce192a1f5
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoretjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
4sea Energy Holding AS | [NAME] 6 | 4050 | Sola | 417 67 665
7ocean AS |  | 6010 | Ålesund | 957 45 517
AGR Subsea AS | Smålonane 14 | 5353 | [NAME] | 56 15 40 00
Abyss AS | Daleg. 71 | 6516 | Kristiansund | 71 58 06 00
Accpron AS | Karmsundgata 72 | 5529 | Haugesund | 51 21 72 00
Add Energy Group AS | Forusbeen 10 | 4031 | Stavanger | 51 87 44 80 | 51 87 44 51
Aeron AS | [NAME] 8 | 4400 | Flekkefjord | 38 32 78 00
Aggreko Norway AS | Dragonv. 44 | 2013 | [NAME] | 810 00 333
Agr Subsea AS | Smålonane 14 | 5353 | [NAME] | 56 15 40 00
[NAME] | Dalegata 71 | 6516 | Kristiansund | 852 70 000 | 852 70 001
[NAME] | Brenneriveien 19-21 | 9600 | Hammerfest | 852 70 000
[NAME] | Storåkeren 11 | 9411 | Harstad | 852 70 000
[NAME] avd Haugesund | [NAME] gate 72 | 5527 | Haugesund | 852 70 000
Aker MH AS | Nedre vei 8 | 3183 | Horten | 38 05 70 00
Aker Solutions Mmo AS avd Kristiansund | Omagata 124 | 6517 | Kristiansund | 67 51 30 00
Albatross Electro & HVAC AS | Skvadronvegen 22 | 4050 | Sola | 51 71 69 00 | 51 71 69 01
Alfa Nordic Service A/S | Tangen 2B | 4070 | Randaberg | 51 41 05 21 | 51 41 05 51
Align AS | Magnus Poulssons v 7 | 1366 | Lysaker | 51 71 93 00
Amflow Norge AS | Stokkabrautene 23 | 4023 | Stavanger | 922 19 656
Amundsen Carl J AS | Smedasundet 97B | 5525 | Haugesund | 52 70 22 00 | 52 71 16 89
Apply LQ Partner AS (tidl. [NAME]) | Årabrotsvegen 21 | 5515 | Haugesund | 52 70 87 00
Aqua Supply AS |  | 6919 | Tansøy | 950 51 935
[NAME] | Maskinveien 26 | 4033 | Stavanger | 51 50 43 00
[NAME] | Travbaneveien 3 | 4031 | Stavanger | 51 30 80 00
[NAME] | Damsgårdsveien 135 | 5160 | Laksevåg | 55 51 80 10
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 824039d1680260249-list-match-based-on-2-partial-strings-test
Sheet: Sheet1

Ref | First 7 characters & PO###### of Col A contained in Col B? | Expected Result
2 Of Brazil's M…KO062276.txt   4 MB |  | Yes
You_Don't_Have…KO062276.txt   3.7 MB
You Don't Have …KO062217.txt   5.2 MB
Untitled (D-Andr…KO062217.txt   3.9 MB |  | Yes
Walking_On_B_O…KO775527.txt   5 MB |  | Yes
Who_Do_You_B…KO775527.txt   5 MB |  | Yes
Thru_My_Rear_V…KO775527.txt   4.2 MB |  | Yes
Spreadsheet: 178194d1346695044-removing-unwanted-numbers-after-decimal-point-gbcalc-tom-hatten-oeldere-
Sheet: Sheet1

Stake | S | P | WON | LOST
10000 | 1 | 4 | WON 12500
10000 | 13 | 8 | WON 26250 | 0 |  |  | 19.12 | 19
10000 | 10 | 11 | WON 19091
10000 | 4 | 7 | WON 15714.[PHONE]
10000 | 10 | 11 | WON 19090.[PHONE]
10000 | 6 | 5 | WON 22000
10000 | 1 | 4 | WON 12500
10000 | 1 | 4 | WON 12500
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
 |  |  | 0
 |  |  | Total | 0
Spreadsheet: 116184d1311657277-excel-claim-sorting-claims-sorting-tracker-cst-1-
Sheet: Summery

Renewal Date Period |  | Starting Year | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount
2011-08-01 00:00:00 | 2012-08-01 00:00:00 | 2011 | 2011-08-01 00:00:00 | 2012 | To | 2012-07-31 00:00:00 | 2011 | 1 | 1 | 15 | 353 | 2 | 368 |  |  |  |  | 2011-08-01 00:00:00 | 2012-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2010 | 1 | 1 | 5100 | 353 | 2 | 5453 |  |  |  |  | 2010-08-01 00:00:00 | 2011-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2009 | 1 | 1 | 15 | 156 | 2 | 171 |  |  |  |  | 2009-08-01 00:00:00 | 2010-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2008 | 1 | 1 | 65 | 45 | 2 | 110 |  |  |  |  | 2008-08-01 00:00:00 | 2009-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2007 | 1 | 1 | 150 | 65 | 2 | 215 |  |  |  |  | 2007-08-01 00:00:00 | 2008-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2006 | 2 | 2 | 150 | 150 | 2 | 300 |  |  |  |  | 2006-08-01 00:00:00 | 2007-07-31 00:00:00
 |  |  | Total Summary |  |  |  |  | 7 | 7 | 5495 | 1122 | 12 | 6617
 |  |  |  |  |  |  |  | Note: column D&E have similar formula
 |  |  |  |  |  |  |  | Note: column F&G have similar formula
 |  |  |  |  |  |  |  | Note: Range can be changed by replacing 43 in the formula with 100 or onward
Spreadsheet: 713616d1610826728-extract-values-in-column-c-and-column-e-into-column-g-based-on-values-in-column-f-extract-values_sample3_index_pull
Sheet: Sheet1

# | Names - I | Code | Names - II | Code - II | Names | Desired Outcome
1 | [NAME], Sahaeer | 30 | Aadigan, [NAME] | 80 | [NAME], Sahaeer | 30
2 | [NAME], Cadmus | 80 | Cadle, Tbra | 65 | Aadigan, [NAME] | 80
3 | Abrahamo, [NAME] | 56 | Cadmus, [NAME] | 80 | [NAME], Aadigan | 80
4 | [NAME], Cadorette | 12 | [NAME], Tbrahame Jr. | 85 | Sharper-Averyer Jr., [NAME] | 105
5 | Abrahim, Cadwallader | 25 | Cadoret, Abrahamo | 56 | [NAME], Sharper-Averyer Jr. | 105
6 | Abrahon, Cady | 45 | Cadorette, [NAME] | 12
7 | Sharper-Averyer Jr., [NAME] | 105 | Cadwalader, Tbrahem | 50
8 | Sharper-Averyer, Jr., [NAME] | 20 | Cadwallader, Abrahim | 25
9 | Sharper-Averyer, [NAME] | 40 | Cady, Abrahon | 45
10 | [NAME], Aadigan | 80 | Sahaeer, [NAME] | 30
11 | Tbra, [NAME] | 65 | [NAME], Sharper-Averyer | 40
12 | Tbrahame Jr., [NAME] | 85 | [NAME], Sharper-Averyer Jr. | 105
13 | Tbrahem, [NAME] | 50 | [NAME], Sharper-Averyer Jr. | 20
Spreadsheet: 146679d1332305564-drop-down-list-help-dropdownlist
Sheet: HaNoi

 | Product and Code | Price
 | Bike
 | HaNoiB01 | 2000
 | HaNoiB02 | 4000
 | HaNoiB03 | 7000
 | Car
 | HaNoiC01 | 30000
 | HaNoiC02 | 50000
 | HaNoiC03 | 70000
 | House
 | HaNoiH01 | 400000
 | HaNoiH02 | 3000000
 | HaNoiH03 | 9000000
Spreadsheet: 678204d1589775623-auto-filling-from-a-column-to-rows-with-changes-in-column-data-excel-forum-column-help
Sheet: Sheet1

Category | Customer ID
Category A
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
Category B
 | 7300
 | 114836
 | 34917
Category C
 | 181
Category D
 | 86291
 | 38623
 | 181
 | 17908
 | 86291
 | 105484
 | 10026
 | 34572
 | 8415
 | 110251
 | 22118
 | 79616
 | 41922
 | 86300
Spreadsheet: 150783d1334678992-combining-table-tab-information-startup-prl
Sheet: Ceiling Grid

Project Name:
Project Team:
Project Manager:
Mechancial Engineer:
Controls Engineer:
Field Technician (TAB):
 |  |  |  |  | Problem-Resolution Log (PRL) - General Contactor
Issue No. | Date Entered | Entered By: | Equipment or System | Description of Issue | Action By | Progress | Date Corrected | Corrected By: | Date Approved | Resolved by | [NAME] | Approved By:
1 | 2012-04-10 00:00:00 | EM | RF-242 | Ceiling grid wire is restricting Fan compartment access door mounted on Inlet duct. | Ceiling Grid Contractor
 | 2012-04-11 00:00:00 | EM | RF-231,232,233 & 234 | Ceiling wire is restricting access to motor access door installed in the inlet duct work. | Ceiling Grid Contractor
 | 2012-04-11 00:00:00 | EM | 23rd [NAME] | The ceiling grid has been mounted to the relief fans.  This will cause vibration and noise when the unit is running. | Ceiling Grid Contractor
 | 2012-04-11 00:00:00 | EM | RF-243 | Ceiling grid wire is restricting access to motor access door installed int the inlet ductwork. | Ceiling Grid Contractor
 | 2012-04-11 00:00:00 | EM | FCU-2303 | Ceiling wire is restricting access to electrical access door on the unit. | Ceiling Grid Contractor
Spreadsheet: 43561d1242209483-viewing-multiple-worksheets-on-one-main-worksheet-2009-10-calendar
Sheet: Oct Child

CYPD TRAINING OCTOBER  2009
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  | 2009-10-01 00:00:00 |  | 2009-10-02 00:00:00 |  | 2009-10-03 00:00:00
2009-10-04 00:00:00 |  | 2009-10-05 00:00:00 |  | 2009-10-06 00:00:00 |  | 2009-10-07 00:00:00 |  | 2009-10-08 00:00:00 |  | 2009-10-09 00:00:00 |  | 2009-10-10 00:00:00
2009-10-11 00:00:00 |  | 2009-10-12 00:00:00 |  | 2009-10-13 00:00:00 |  | 2009-10-14 00:00:00 |  | 2009-10-15 00:00:00 |  | 2009-10-16 00:00:00 |  | 2009-10-17 00:00:00
2009-10-18 00:00:00 |  | 2009-10-19 00:00:00 |  | 2009-10-20 00:00:00 |  | 2009-10-21 00:00:00 |  | 2009-10-22 00:00:00 |  | 2009-10-23 00:00:00 |  | 2009-10-24 00:00:00
2009-10-25 00:00:00 |  | 2009-10-26 00:00:00 |  | 2009-10-27 00:00:00 |  | 2009-10-28 00:00:00 |  | 2009-10-29 00:00:00 |  | 2009-10-30 00:00:00 |  | 2009-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  | Notes:
Spreadsheet: 180590d1347648091-macro-for-copy-and-pasting-duplicates-sample
Sheet: Sheet1

1 | rey | I don’t know
2 | rey | yes you know
3 | rey | no I don’t
4 | rey | maybe I do
5 | rey | im not sure
6 | rey | yes im sure
7 | rey | maybe im sure
8 | rey | maybe im not sure
9 | rey | im ok
10 | rey | im not ok
11 | rey | maybe im ok
12 | rey | maybe im not ok
13 | rey | im good
14 | rey | im not good
15 | rey | maybe im good
16 | rey | maybe im not good
17 | rey | im cold
18 | rey | im not cold
19 | rey | maybe im cold
20 | rey | maybe im not cold
21 | [NAME] | im beautiful
22 | [NAME] | im not beautiful
23 | [NAME] | maybe im beautiful
24 | [NAME] | maybe im not beautiful
25 | [NAME] | im fat
26 | [NAME] | im not fat
27 | [NAME] | maybe im fat
28 | [NAME] | maybe im not fat
29 | [NAME] | im thin
30 | [NAME] | im not thin
31 | [NAME] | maybe im thin
32 | [NAME] | maybe im not thin
33 | [NAME] | Green
34 | [NAME] | Green
35 | [NAME] | Green
36 | [NAME] | Green
37 | [NAME] | Green
38 | [NAME] | Green
39 | [NAME] | Green
40 | [NAME] | Green
41 | [NAME] | Green
42 | [NAME] | Green
43 | [NAME] | Green
44 | [NAME] | Green
45 | [NAME] | Green
46 | [NAME] | Green
47 | [NAME] | Green
48 | [NAME] | Green
49 | [NAME] | Green
50 | [NAME] | Green
51 | [NAME] | Steen
52 | [NAME] | Steen
53 | [NAME] | Steen
54 | [NAME] | Steen
55 | [NAME] | Steen
56 | [NAME] | Steen
57 | [NAME] | Steen
58 | [NAME] | Steen
59 | [NAME] | Steen
60 | [NAME] | Steen
61 | [NAME] | Steen
62 | [NAME] | Steen
63 | [NAME] | Steen
64 | [NAME] | Steen
65 | [NAME] | Steen
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: MASSACHUSSETS-20

 | COUNTY | CODE
 | Barnstable | 1
 | Berkshire | 3
 | Bristol | 5
 | Dukes | 7
 | Essex | 9
 | Franklin | 11
 | Hampden | 13
 | Hampshire | 15
 | Middlesex | 17
 | Nantucket | 19
 | Norfolk | 21
 | Plymouth | 23
 | Suffolk | 25
 | Worcester | 27