tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720301d1614099428-remove-duplicate-and-place-on-one-row-book5
Sheet: Sheet1

F30A00100 | 37-54-93-13-54-41
F30A00100 | 37-54-93-13-54-42
F30A00100 | 37-54-93-13-54-43
F30A00100 | 37-54-93-13-54-44
F30A00100 | 37-54-93-13-54-45
F30A00100 | 37-54-93-13-54-46
F30A00101 | 37-54-93-13-54-47
F30A00101 | 37-54-93-13-54-48
F30A00101 | 37-54-93-13-54-49
F30A00101 | 37-54-93-13-54-4A
F30A00101 | 37-54-93-13-54-4B
F30A00101 | 37-54-93-13-54-4C
F30A00102 | 37-54-93-13-54-4D
F30A00102 | 37-54-93-13-54-4E
F30A00102 | 37-54-93-13-54-4F
F30A00102 | 37-54-93-13-54-50
F30A00102 | 37-54-93-13-54-51
F30A00102 | 37-54-93-13-54-52
Spreadsheet: 9ee9e884-1728-4f64-85c0-71c31f63c4f3
Sheet: Table 8.2

8.2 Consumer prices
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2013
Country | 2009 | 2010 | 2011 | 2012 |  | Sep | Oct | Nov | Dec
Australia (c) | 1.82 | 2.85 | 3.39 | 1.76 |  | 2.16
Canada | 0.3 | 1.78 | 2.91 | 1.52 |  | 1.07 | 0.65 | 0.9
China | -0.7000000000000001 | 3.31 | 5.41 | 2.65 |  | 3.1 | 3.2 | 3 | 2.5
France | 0.09 | 1.53 | 2.12 | 1.96 |  | 0.86 | 0.59 | 0.67 | 0.66
Germany | 0.31 | 1.1 | 2.08 | 2.01 |  | 1.43 | 1.24 | 1.34 | 1.43
Indonesia | 4.81 | 5.13 | 5.36 | 4.28 |  | 8.4 | 8.32 | 8.370000000000001 | 8.38
Italy | 0.75 | 1.54 | 2.74 | 3.04 |  | 0.9400000000000001 | 0.75 | 0.66 | 0.66
Japan | -1.35 | -0.72 | -0.28 | -0.03 |  | 1 | 1.1 | 1.61
Korea (South) | 2.76 | 2.96 | 4 | 2.19 |  | 1.07 | 0.85 | 1.22 | 1.12
Malaysia | 0.58 | 1.71 | 3.2 | 1.66 |  | 2.57 | 2.75 | 2.94
New Zealand (c) | 2.12 | 2.3 | 4.43 | 0.88 |  | 1.37
Philippines | 4.13 | 3.88 | 4.65 | 3.17 |  | 2.66 | 2.89 | 3.35 | 4.11
Singapore | 0.6 | 2.8 | 5.25 | 4.53 |  | 1.66 | 2.01 | 2.62
Thailand | -0.85 | 3.27 | 3.81 | 3.01 |  | 1.42 | 1.46 | 1.92 | 1.67
United Kingdom | 2.17 | 3.29 | 4.48 | 2.82 |  | 2.67 | 2.17 | 2.09 | 2
United States | -0.36 | 1.64 | 3.16 | 2.07 |  | 1.18 | 0.96 | 1.24 | 1.5
OECD average | 0.4912998976458587 | 1.853738032185774 | 2.870000000000005 | 2.245552639253429 |  | 1.493948562783665 | 1.293306900783531 | 1.485616956850855 | 1.637327276168854
G7 average | -0.1013068584743273 | 1.409593347530677 | 2.620000000000005 | 1.880725004872337 |  | 1.246076286502418 | 1.046025104602522 | 1.278381988170185 | 1.431980906921249
Euro-zone average | 0.2955865864845645 | 1.626016260162596 | 2.719999999999999 | 2.492211838006233 |  | 1.103877724313596 | 0.7341176470588184 | 0.848736325914734 | 0.855182783572972
(a) Percentage change in consumer price indexes over previous year.
(b) Years shown are calendar years.
(c) Data only available quarterly.
Source: Datastream
http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.stats.govt.nz/default.htm | http://www.stats.govt.nz/default.htm
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early March 2014
Spreadsheet: e3eb2c58-076d-4fb2-a610-1652b1396289
Sheet: Data Entry

Evaluation Business Model |  |  | Company: |  |  |  | Name model |  |  |  |  | Date
Strenght/Weakness |  |  |  |  | Opportunities |  |  |  |  | Threats
Nr. | Subject | Score | Result |  |  | Subject | Score | Result |  |  | Subject | Score | Threat
1 |  | 3 |  |  | 1 |  | 1 |  |  | 1 |  | 5
2 |  | -2 |  |  | 2 |  | 1 |  |  | 2 |  | 1
3 |  | 4 |  |  | 3 |  | 5 |  |  | 3 |  | 1
4 |  | 2 |  |  | 4 |  | 4 |  |  | 4 |  | 1
5 |  | 3 |  |  | 5 |  | 3 |  |  | 5 |  | 1
6 |  | -5 |  |  | 6 |  | 1 |  |  | 6 |  | 1
7 |  | -5 |  |  | 7 |  | 2 |  |  | 7 |  | 1
8 |  | 5 |  |  | 8 |  | 1 |  |  | 8 |  | 1
9 |  | 3 |  |  | 9 |  | 2 |  |  | 9 |  | 1
10 |  | -5 |  |  | 10 |  | 1 |  |  | 10 |  | 2
11 |  | 5 |  |  | 11 |  | 1 |  |  | 11 |  | 2
12 |  | 5 |  |  | 12 |  | 1 |  |  | 12 |  | 1
13 |  | 5 |  |  | 13 |  | 1 |  |  | 13 |  | 2
14 |  | 5 |  |  | 14 |  | 1 |  |  | 14 |  | 1
15 |  | 2 |  |  | 15 |  | 1 |  |  | 15 |  | 1
16 |  | -3 |  |  | 16 |  | 3 |  |  | 16 |  | 1
17 |  | 5 |  |  | 17 |  | 1 |  |  | 17 |  | 4
18 |  | 5 |  |  | 18 |  | 2 |  |  | 18 |  | 2
19 |  | 5 |  |  | 19 |  | 1 |  |  | 19 |  | 1
20 |  | 1 |  |  | 20 |  | 1 |  |  | 20 |  | 1
21 |  | 3 |  |  | 21 |  | 2 |  |  | 21 |  | 2
22 |  | 4 |  |  | 22 |  | 3
23 |  | 0 |  |  | 23 |  | 2
24 |  | 1 |  |  | 24 |  | 4
25 |  | 2 |  |  | 25 |  | 4
26 |  | 4 |  |  | 26 |  | 2
27 |  | 4 |  |  | 27 |  | 1
28 |  | 1 |  |  | 28 |  | 1
29 |  | 0 |  |  | 29 |  | 4
30 |  | 4 |  |  | 30 |  | 1
31 |  | -5 |  |  | 31 |  | 1
32 |  | -5 |  |  | 32 |  | 2
33 |  | 0 |  |  | 33 |  | 2
34 |  | 0 |  |  | 34 |  | 2
35 |  | 0 |  |  | 35 |  | 1
36 |  | 5 |  |  | 36 |  | 1
37 |  | 4 |  |  | 37 |  | 1
38 |  | 0
39 |  | 3
Spreadsheet: 46a1fed1-1b75-4d3e-8a93-b953da2d4478
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
[NAME] | Test | [NAME] | Salmonella Antibodies, EIA | Salmonella Antibodies, EIA | Enzyme Immunoassay (EIA) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | 1 mL of serum sent refrigerated. (Serum gel tube is acceptable) | 0.1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  Negative  Antibodies to Salmonella flagellar (H) and somatic (O) antigens typically peak 3-5 weeks after infection. A positive result in this assay is equivalent to a titer of >=1:160 by tube agglutination (Widal). Results should not be considered as diagnostic unless confirmed by culture.  Test Performed by: Focus Diagnostics, Inc.                                        5785 Corporate Avenue                                        Cypress, CA 90630-4750 | Monday through Friday | 1 day | 1 - 4 days | 5 | 86768 |  |  |  |  | Focus Diagnositics, Inc.
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | Z0566 | Salmonella H, Type a | Salmonella H, Type a | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | Z0567 | Salmonella H, Type b | Salmonella H, Type b | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | Z0568 | Salmonella H, Type d | Salmonella H, Type d | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | [NAME] | Salmonella O, Type Vi | Salmonella O, Type Vi | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | Z0570 | Salmonella O, Type D | Salmonella O, Type D | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 219335d1362721943-formula-to-calculate-working-hours-between-two-dates-not-working-correctly-solve
Sheet: Sheet1

Date/Time Received | Date/Time Resolved | [NAME] | work hour
2013-03-04 22:45:00 | 2013-03-05 15:34:00 |  |  | 08:30:00 | 17:30:00
2013-03-05 09:05:00 | 2013-03-05 09:15:00
2013-03-05 09:19:00 | 2013-03-05 10:23:00
2013-03-05 10:00:00 | 2013-03-05 10:20:00
2013-03-05 11:45:00 | 2013-03-05 12:15:00
2013-03-05 11:54:00 | 2013-03-05 13:00:00
2013-03-06 17:29:00 | 2013-03-07 09:30:00
Spreadsheet: 9f3f8969-00ee-4687-b748-2e356d920b04
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4438 | 14920 | [NAME] | Macmartin | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:57:50
4438 | 78435 | Mark | Bates | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:58:11
4438 | 26147 | Harold | [NAME] | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:58:53
4438 | 10349 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:59:32
4438 | 5706 | [NAME] | Galindez | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 00:00:00
Spreadsheet: jim_schwieger__14285__fuel percentage 2000
Sheet: OA Actual

Prod. Mo.  (MMBTU) | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | Total Y-T-D
 | Actual | Actual | Actual | Actual | Estimate | Estimate | Estimate | Estimate | Estimate | Estimate | Estimate | Estimate
Total Injections | 1242074.297823575 | 417174.649657947 | 8290577 | 4760229.346540523 | 2895475
Total Withdrawals | -7427518.29782358 | -6659276.64965795 | 0 | -5212.34654052239 | 0
Net Change
GIP End of Month | 105276483 | 99034381 | 107324958 | 112079975 | 114982145 | 115842375 | 114728617 | 114765373.1707317 | 115594131.3414634 | 115754047.6357199 | 120444146.8064516 | 120644146.8064516
Ship Channel Price | 2.34 | 2.58 | 2.6 | 2.9 | 3.08 | 4.38
[NAME]
Value
Gas In Place | Fuel %
BCF | Percentage
60  -  80 | 0.006
81  -  90 | 0.008
91  -  100 | 0.01
101  -  110 | 0.012
111  --  117.5 | 0.014
MMBTU
61 - 82 | 0.006
83 - 93 | 0.008
94 - 103 | 0.01
104 - 113 | 0.012
114 = 121 | 0.014
Spreadsheet: 80c909e7-a19e-4276-9c34-dbdf145f719c
Sheet: Sheet1

2012 General Election - OFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 426/426 - Total Ballots Cast: 325564
Downloaded at 4/24/2014 7:18:07 AM
 | Yes - | No -
Constitutional Measure No. 1: Elimination of Annual Poll Tax | 206178 | 82518
 | Yes - | No -
Constitutional Measure No. 2: Oaths of Office for Elected and Appointed Officials | 259541 | 32926
 | Yes - | No -
Initiated Constitutional Measure No. 3: Relating to the Practices of Farming and Ranching | 201948 | 99935
 | Yes - | No -
Initiated Statutory Measure No. 4: Relating to Prohibiting Smoking in Public Places and Worksites | 209488 | 104730
 | Yes - | No -
Initiated Statutory Measure No. 5: Relating to the Prevention of Animal Cruelty | 109401 | 206547
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 829620d1684335697-match-data-in-one-column-formula-to-locate-mismatch-data-in-another-column-mismatch-sample
Sheet: Sheet1

ACCOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  | DATA TO COMPARE IF MATCHED | formula here | Example of  wanted results
19850029616 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19890009390 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19910011318 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation |  | MISMATCH
19910011318 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment |  | MISMATCH
19910045015 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19192002185 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
11993001769 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation
19940002758 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19940002758 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19950002016 |  |  |  |  |  |  |  |  |  |  |  |  |  | Consent Judgment Filiation |  | MISMATCH
19950002016 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation |  | MISMATCH
Spreadsheet: 0f1f968d-a232-463e-92bd-136bd10dea72
Sheet: Sheet1

Name | Year | CFI |  | CIHR |  | NSERC |  | SSHRC |  | Other Major Granting Agencies |  | Other Grants & Contracts |  | Year Total | Individual  Total
 |  | # | Amount | # | Amount | # | Amount | # | Amount | # | Amount | # | Amount
[NAME] | 10/11 | 2 | 376 | 1 | 63 | 0 | 0 | 3 | 896 | 5 | 1228 | 12 | 1440
[NAME] | 11/12 | 1 | 500 | 1 | 400 | 0 | 0 | 2 | 500 | 6 | 1000 | 3 | 1200
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: February

Employee Absence Schedule
February | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | 302 | 31 | CL | T | NCNS | Total Points
Employee 1 |  |  | CI | CI | CI | CI |  |  |  |  |  |  | CI |  |  |  |  | T | T |  | NCNS | NCNS | NCNS
Employee 2 |  |  |  |  | T | T |  |  |  |  | NCNS |  |  |  |  |  |  |  |  | T |  |  |  |  | CI | CI | CI
Employee 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CI
Employee 4 |  |  | T |  |  |  |  |  |  |  |  |  |  | NCNS |  |  |  | NCNS |  |  |  |  |  |  |  |  |  | T
Employee 5 |  |  |  |  |  |  |  | CI | CI | CI | CI |  |  |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  | Cl | Call-in |  |  | T |  |  |  | NCNS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No show
Spreadsheet: 593708d1539283464-sumifs-formula-variation-help-vat-1-
Sheet: Transactions

Invoice Number | Date | Month | Quarter | Year | Customer Name | Purchase or Sale | Tax Code | Currency | Total Amount | Net Amount | [NAME]
1 | 2018-10-10 00:00:00 | October 2018 | Q12018 | 2018 | ABZ | Sales | BURC | € | 20
2 | 2018-10-10 00:00:00 | October 2018 | Q22018 | 2018 | RFD | Sales | SE-STD21 | € | 23
3 | 2018-11-10 00:00:00 | November 2018 | Q32018 | 2018 | ZVX | Sales | BURC | € | 13
Spreadsheet: 022176b4-d522-4d28-b6dd-d8001f7073a9
Sheet: Sheet1

India International Challenge Badminton Championship 2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Men's Singles - Main Draw
Badminton Tournament Planner - www.tournamentsoftware.com
No. | Name | Ranking | MemberID | Country | Seed
1 | ANAND, Chetan | 47 | 11691 | IND | 1
2 | RAFFEINER, Klaus | 106 | 7092 | ITA | 2
3 | CHONG, [NAME] | 108 | 52030 | MAS | 3
4 | PAWAR, Anand | 121 | 51598 | IND | 4
5 | P., [NAME] | 130 | 53944 | IND | 5
6 | KARUNARATNE, Dinuka | 133 | 52229 | SRI | 6
7 | KANETKAR, Nikhil | 163 | 12054 | IND | 7
8 | CHONG, [NAME] | 164 | 52865 | MAS | 8
9 | PEI, [NAME] | 187 | 3145 | MAS
10 | SMOLA, Clemens | 205 | 51510 | AUT
11 | JAYARAM, Ajay | 210 | 55351 | IND
12 | SINGH, [NAME] | 212 | 15342 | IND
13 | [NAME], Diluka | 224 | 52233 | SRI
14 | ALI, Wajid | 228 | 11107 | PAK
15 | WIJETILEKK, Ajit | 231 | 12572 | IND
16 | CASTELINO, Rohan | 250 | 14761 | IND
17 | MOHAMMAD, Attique | 308 | 53251 | PAK
18 | QAMAR, [NAME] | 317 | 52825 | PAK
19 | OMAR, Zeeshan | 357 | 50027 | PAK
20 | AZAM, Rizwan | 407 | 54214 | PAK
21 | HAZARIKA, Anshuman | 0 | 31082 | IND
22 | [NAME], Utsav | 0 | 15690 | IND
23 | NEOG, [NAME] | 0 |  | IND
24 | RATTI, Sachin | 0 | 10073 | IND
25 | S.D.S., Krishna | 0 | 51312 | IND
26 | SANYAL, [NAME] | 0 | 53943 | IND
27 | SARMA, Nikhilesh | 0 |  | IND
28 | V., [NAME] | 0 | 27296 | IND
29 | VERGHESE, Jibi | 0 | 15855 | IND
30 | SUKAMTA, [NAME] | 0 |  | INA
31 | RAZAHI, Murtaza | 0 | 57003 | AFG
32 | HABIB, [NAME] | 0 | 67240 | BAN
33 | HANNAN, [NAME] | 0 | 65494 | BAN
34 | CHAUDHARI, [NAME] | 0 | 54771 | NEP
35 | LAKHE, [NAME] | 0 | 15682 | NEP
36 | PANERU, Rajendra | 0 |  | NEP
37 | PRADHAN, Bishal | 0 |  | NEP
38 | SHRESTHA, Bikash | 0 |  | NEP
39 | UDDIN, Md. Rias | 0 | 53025 | BAN
40 | UDDIN, [NAME] | 0 | 80949 | BAN
41 | [NAME], [NAME] | 0 |  | INA
42 | RIEN, [NAME] | 0 |  | INA
43 | SAPUTRA, [NAME] | 0 |  | INA
44 | BASHIR, Hashir | 0 | 54210 | PAK
45 | CHOPDA, [NAME] | 0 | 53037 | IND
46 | [NAME], [NAME] | 0 | 10069 | IND
Spreadsheet: 713198d1610588399-filtering-with-duplicates-and-max-for-entire-row-output-book1
Sheet: Sheet1

200 | 219 | 2017 | M | 35
 | 219 | 2017 | M | 35
 | 219 | 2017 | M | 35
 | 219 | 2017 | M | 35
 | 219 | 2017 | M | 35
 | 219 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 220 | 2017 | M | 35
 | 221 | 2017 | M | 35
 | 221 | 2017 | M | 35
 | 221 | 2017 | M | 35
 | 221 | 2017 | M | 35
 | 221 | 2017 | M | 35
Spreadsheet: john_zufferli__16790__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 18  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 28.5 | 31
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 29 | 29.75
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 29 | 30
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 29 | 32
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 29 | 32
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 29 | 32
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 33.5 | 35
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 33.5 | 35
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 33.5 | 35
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 35.5 | 37
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 35.5 | 37
 |  | DEC | 33.3 |  |  |  | DEC | 35.5 | 37
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 685585d1594094573-vlookup-or-if-schedule-trial
Sheet: Sheet1

[NAME]
Site A |  | Week 1 | Week 2 | Week 3
Spot 1 |  | Smith | [NAME] | Smith
Spot 2 |  | [NAME] | [NAME] | [NAME]
Site B
Spot 1 |  | Doe | Smith | Doe
Spot 2 |  | [NAME] | [NAME]
Site C
Spot 1 |  | [NAME] | Doe
Spot 2
Person |  | Week 1 | Week 2 | Week 3
Smith
[NAME]
[NAME]
Doe
[NAME]
Lead
Tech
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: Maggie Timmons

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
 | Maggie & Lee |  | Timmons | Maggie & Lee Timmons |  |  |  |  |  | 500 | < 1000 | y | cheque will come later | [NAME]
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: TX-HPL-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPL
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 942514 | 2190441.040000021
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | -0.8999999999941792
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 942514 | 2190440.140000022
 | Purchases:
6 |  | 3rd Party / Inter Enron | -1123944 | -2561345.429999992
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0.1099999994039536
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -1123944 | -2561345.319999993
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 2
 | Total Intra CTS Sales / Purchases |  | 0 | 2
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 181430 | 899183.6649146893
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 181430 | 899183.6649146893
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | -0.6000000014901161
18 |  | W/D (Purchase from Stg) | 0 | -0.6799999999348074
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | -0.6799999999348074
 | Total Storage: |  | 0 | -1.280000001424924
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 25000
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 65991d1266604555-customer-loyalty-by-rep-customer-loyalty-example
Sheet: Sheet1

Account | Rep | 2008 | 2009 | loyalty | desired result
A Corp | [NAME] | 1 |  | _ | not loyal
B Corp | [NAME] | 1 | 1 | loyal | account claimed, this rep gets credit
B Corp | [NAME] |  | 1 | _ | account claimed, this rep does not get credit
B Corp | [NAME] | 1 |  | _ | account claimed, this rep does not get credit
C Corp | [NAME] | 1 | 1 | loyal | account claimed, this rep gets credit
C Corp | [NAME] |  | 1 | _ | account claimed, this rep does not get credit
D Corp | [NAME] | 1 | 1 | loyal | account claimed, this rep gets credit
E Corp | [NAME] | 1 |  | _ | not loyal
F Corp | [NAME] | 1 |  | _ | loyal, but with different rep
F Corp | [NAME] |  | 1 | _ | loyal, but with different rep - this rep gets credit for keeping account
G Corp | [NAME] | 1 |  | _ | not loyal
H Corp | Snarv Whbdfjkbdf |  | 1 | _ | not loyal
I'm trying to find customer loyalty by rep.  So I need to find all the accounts that have a loyal relationship with a rep and separate them.  All the other reps that sold to those companies are removed.  Then I need to find the accounts that still did business with us from year to year, but not with the same rep.  Any not loyal accounts are also removed.
The ultimate goal is a pivot table that shows reps on the vertical axis, years on the horizontal axis, with the data being total number of accounts per rep per year.  All of the 2008 accounts will be counted, and of the 2009 accounts, only those that were loyal - retained either by the same or a different rep - will be totaled.  For this purpose there is no difference between accounts retained either by the same or a different rep, they will be added together.  So a rep may have had 10 accounts they sold to in 2008, and of those 10, 5 bought again in 2009, and the rep also picked up 1 account that bought from another rep in 2008.  So the rep's totals would be 10 for 2008, and 6 for 2009.
A "1" in the 2008 or 2009 column indicates the account bought something that year.
Spreadsheet: 94115d1293973095-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-2-
Sheet: Summary

Name | ID | Hire Date
[NAME] | 906.2394028637782 | 2001-05-13 00:00:00
Roxie Sarles | 973.4626260948285 | 2006-05-30 00:00:00
[NAME] | 321.8163963434762 | 1997-07-18 00:00:00
[NAME] | 58.88855863405411 | 2001-05-13 00:00:00
[NAME] | 732.5559100162666 | 2006-05-30 00:00:00
[NAME] | 943.6884675896359 | 1997-07-18 00:00:00
[NAME] | 780.6069371775324 | 2001-05-13 00:00:00
[NAME] | 155.4330631863325 | 2006-05-30 00:00:00
[NAME] | 335.5980033769903 | 1997-07-18 00:00:00
Spreadsheet: 489980d1479511874-sumifs-or-other-formula-needed-copy-of-seattle-consols-week-47-2016-code
Sheet: Graph

Week # | Weekly cost per CBM | Weekly Total CBM | Weekly O/F Total | Weekly Dray Total |  | Average Cost per CBM
22 |  | 431.34 | 6811 | 4400
23 | 31.05 | 276.59 | 5288 | 3300
24 |  | 293.21 | 6229 | 3300
25 |  | 409.84 | 6190 | 3800
26 | 34.38 | 283.58 | 5950 | 3800
27 |  | 386.08 | 5900 | 3800
28 |  | 356.25 | 7652.5 | 3850
29 |  | 340.97 | 8620 | 3850
30 | 50.92 | 263.31 | 9558 | 3850
31 | 39.51 | 299.84 | 8548 | 3300
32 |  | 348.15 | 8720 | 3850
33 |  | 342.14 | 8761 | 3850
34 |  | 301.28 | 7544.5 | 3300
35 |  | 365.89 | 8580 | 3850
36 |  | 330.29 | 8566.5 | 3850
37 |  | 342.36 | 9733 | 3300
38 |  | 302.03 | 10549 | 3300
39 |  | 223.29 | 7335.79 | 2200
40 |  | 189.62 | 10638 | 3300
41 |  | 329.86 | 10088 | 3300
42 |  | 150.89 | 4847 | 1650
43 |  | 197.74 | 6680.5 | 2200
44 |  | 345.88 | 13099
45 |  | 260.74 | 10558 | 3300
46 |  | 268.46 | 10293.5 | 2950
47
48
49
50
51
52