tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 190032d1351510189-merge-same-records-to-one-row-sample1-with-code_
Sheet: Sheet2

Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage |  | 1) 2pcs have sand-hole in thread, 2) one the M10 thread forms a through hole. | Ravi | 2012-10-01 00:00:00
122 | abnormal Noise | a b | [NAME] Part sent to Customer | Raj Srinivasan | 10-Oct-12 13-Oct-12
123 | Oil Leakage | a b | Oil Changed Oil Seal Replaced | Ravi | 2012-10-01 00:00:00
124 | Oil Leakage | c | Repared Part sent to Customer | Suresh | 2012-10-05 00:00:00
[NAME]
Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage | a b c | Oil Changed Oil Seal Replaced Repared Part sent to Customer | Ravi  Suresh | 01-Oct-12  05-Oct-12
122 | abnormal Noise | a b | [NAME] Part sent to Customer | Raj Srinivasan | 10-Oct-12 13-Oct-12
Macro Requirement :
a) select the ROWS with same PROBLEM No.
b) [NAME] values in each Column
c) For Each Column,   merge data from the rows in selection and puts each cell value on a new line.
d) Repeat for Next Problem No.
Note :The database is sorted based on Complaint No.
Spreadsheet: 864504d1711644644-find-another-row-in-a-table-whose-first-two-columns-match-and-determine-value-of-third-sampleboltnail
Sheet: IO

Program 1 output |  |  |  |  |  | Program 2 input
Date | Empl# | Name | Code | Hours |  | Calculated | Required Entry | MAX
2024-03-18 00:00:00 | 2 | [NAME] | S | 10 |  |  | B
2024-03-18 00:00:00 | 12 | [NAME] | S | 1 |  |  | 1B
2024-03-18 00:00:00 | 14 | [NAME] | S | 1 |  |  | 1B
2024-03-18 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-19 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-20 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-21 00:00:00 | 23 | [NAME] | S | 0.2 |  |  | 1B
2024-03-21 00:00:00 | 35 | [NAME] | M | 10 |  |  | H
2024-03-21 00:00:00 | 39 | Mac | S | 1.8
2024-03-21 00:00:00 | 39 | Mac | V | 8.2 |  |  | 8E
2024-03-21 00:00:00 | 51 | Fred | M | 1 |  |  | 1H
2024-03-21 00:00:00 | 58 | Derek | V | 1 |  |  | 1E
2024-03-21 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-22 00:00:00 | 36 | Brenden | V | 8 |  |  | E
2024-03-22 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10 |  | 1259
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 16328
2002-01-17 00:00:00
CBS Dollars
 |  |  | 383278
Spreadsheet: 269056d1380925692-dropdownl-list-scoresheet2007
Sheet: Results

 | Players [NAME] |  |  | Best Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ladonnia Hollingsworth
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 805879d1668976929-looking-for-a-function-that-do-a-sum-look-up-across-multiple-sheets-excel-workbook-1-
Sheet: Master

 | Date | Total deposits |  | Moses | [NAME] | [NAME] | [NAME] | [NAME]
 | 2022-11-06 00:00:00 |  |  |  |  |  |  |  | This file contains multiple sheets which belong to paricular individuals that made deposits on various dates
 | 2022-11-07 00:00:00 |  |  |  |  |  |  |  | The task needed is to look up the total deposits that were made on 11/6/2022 by all the individuals
 | 2022-11-08 00:00:00
 | 2022-11-03 00:00:00
 | 2022-11-10 00:00:00
Spreadsheet: 761558d1641031521-enter-the-date-and-get-the-whole-list-20220101
Sheet: Sheet1

Name | 2021.09.01 | 2021.10.01 | 2021.11.01 | 2021.12.01 | 2022.01.01 | 2022.02.01 | 2022.03.01 | 2022.04.01 | 2022.05.01 | 2022.06.01 | 2022.07.01 | 2022.08.01 | 2022.09.01 | 2022.10.01 | 2022.11.01 | 2022.12.01
zucca | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80
hellen | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
dee | 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27 | 29 | 31
[NAME] | 1 | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 | 28 | 31 | 34 | 37 | 40 | 43 | 46
cheves | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48
 | Column1 | Column2
 | Date | 2022.04.01
Name
Name | Value
zucca | 40
hellen | 16
dee | 15
[NAME] | 22
cheves | 24
Spreadsheet: 44047d1242724532-copy-filtered-data-and-paste-into-adjecent-column-with-filter-applied-in-excel-2007-copy-filtered-data-and-paste-into-adjecent-column-with-filter-applied-in
Sheet: Sheet1

Grade | Number | Copy Number |  | TYPE
A | 25 | 23 |  | A
B | 26 | 23
B | 30 | 25
A | 25 | 25
A | 23 | 25
B | 25 | 34
B | 26
A | 23
A | 34
C | 25
C | 25
A | 25
Spreadsheet: kate_symes__18279__DJ Index 4-8 Peak
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-09 00:00:00
Flow Date: | 4/8/01 - On Peak Hours Only
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 277.5 | 800
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
Spreadsheet: 322d1d24-2b27-436d-8642-022f573575a2
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
TSTGP | Test | TSTGP | Tissue Transglutaminase (tTG) Antibodies, IgA and IgG Profile, Serum | Tissue Transglutaminase Ab, IgA/IgG | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | tTG ANTIBODY, IgA <4.0 U/mL (negative) 4.0-10.0 U/mL (weak positive) >10.0 U/mL (positive) Reference values apply to all ages.   tTG ANTIBODY, IgG <6.0 U/mL (negative) 6.0-9.0 U/mL (weak positive) >9.0 U/mL (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 4 days |  | Profile |  |  |  |  | Rochester
TSTGP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TSTGP | Component | TTGA | Tissue Transglutaminase (tTG) Antibody, IgA, Serum | Tissue Transglutaminase Ab, IgA, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <4.0 U/mL (negative) 4.0-10.0  U/mL (weak positive) >10.0 U/mL (positive) Reference values apply to all ages. | Monday through Saturday; 7 a.m.-9 p.m. | Same day/1 day | 4 days | 1 | 83516 |  |  | Yes | Yes
TTGA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TTGA | Result | TTGA | Tissue Transglutaminase Ab, IgA, S | Tissue Transglutaminase Ab, IgA, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 46128-5
TSTGP | Component | TTGG | Tissue Transglutaminase (tTG) Antibody, IgG, Serum | Tissue Transglutaminase Ab, IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <6.0 U/mL (negative) 6.0-9.0 U/mL (weak positive) >9.0 U/mL (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 4 days | 1 | 83516 |  |  | Yes | Yes
TTGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TTGG | Result | TTGG | Tissue Transglutaminase Ab, IgG, S | Tissue Transglutaminase Ab, IgG, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 56537-4
Spreadsheet: 166941d1341849763-change-code-based-on-last-day-of-year-and-change-date-based-on-code-practice-date-change
Sheet: Sheet1

 | VA1-12 |  |  | SS1-12 |  |  | R1-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  | New Year's Day
 | [NAME] |  |  | SS2-12 |  |  | R2-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | VA3-12 |  |  | SS3-12 |  |  | R3-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Presidents' Day
 | VA4-12 |  |  | SS4-12 |  |  | R4-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day
 | VA5-12 |  |  | SS5-12 |  |  | R5-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day
 | VA6-12 |  |  | SS6-12 |  |  | R6-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day
 | VA7-12 |  |  | SS7-12 |  |  | R7-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veterans Day
 | VA8-12 |  |  | SS8-12 |  |  | R8-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day
 | VA9-12 |  |  | SS9-12 |  |  | R9-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day
 | [NAME] |  |  | SS10-12 |  |  | R10-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Holiday
 | VA11-12 |  |  | SS11-12 |  |  | R11-12
 | VA12-12 |  |  | SS12-12 |  |  | R12-12
2013-01-01 00:00:00
VA1-12 | 2011-12-30 00:00:00
SS1-12 | 2012-01-11 00:00:00
R1-12 | 2012-01-31 00:00:00
[NAME] | 2012-02-01 00:00:00
SS2-12 | 2012-02-08 00:00:00
R2-12 | 2012-02-29 00:00:00
VA3-12 | 2012-03-01 00:00:00
SS3-12 | 2012-03-14 00:00:00
R3-12 | 2012-03-30 00:00:00
VA4-12 | 2012-04-02 00:00:00
SS4-12 | 2012-04-11 00:00:00
R4-12 | 2012-05-01 00:00:00
VA5-12 | 2012-05-02 00:00:00
SS5-12 | 2012-05-09 00:00:00
R5-12 | 2012-05-31 00:00:00
VA6-12 | 2012-06-01 00:00:00
SS6-12 | 2012-06-13 00:00:00
R6-12 | 2012-06-29 00:00:00
VA7-12 | 2012-07-02 00:00:00
SS7-12 | 2012-07-11 00:00:00
R7-12 | 2012-07-31 00:00:00
VA8-12 | 2012-08-01 00:00:00
SS8-12 | 2012-08-08 00:00:00
R8-12 | 2012-08-31 00:00:00
VA9-12 | 2012-09-03 00:00:00
SS9-12 | 2012-09-12 00:00:00
R9-12 | 2012-09-28 00:00:00
[NAME] | 2012-10-01 00:00:00
SS10-12 | 2012-10-03 00:00:00
R10-12 | 2012-10-31 00:00:00
VA11-12 | 2012-11-01 00:00:00
SS11-12 | 2012-11-14 00:00:00
R11-12 | 2012-11-30 00:00:00
VA12-12 | 2012-12-03 00:00:00
SS12-12 | 2012-12-12 00:00:00
R12-12 | 2012-12-31 00:00:00
VA1-13 |  |  |  |  |  | 2013-01-01 00:00:00
SS1-13
R1-13
[NAME]
SS2-13
R2-13
VA3-13
SS3-13
R3-13
VA4-13
SS4-13
R4-13
VA5-13
SS5-13
R5-13
VA6-13
SS6-13
R6-13
VA7-13
SS7-13
R7-13
VA8-13
SS8-13
R8-13
VA9-13
SS9-13
R9-13
VA10-13
SS10-13
R10-13
VA11-13
SS11-13
R11-13
VA12-13
SS12-13
R12-13
VA1-14
SS1-14
R1-14
[NAME]
SS2-14
R2-14
VA3-14
SS3-14
R3-14
VA4-14
SS4-14
R4-14
VA5-14
SS5-14
R5-14
VA6-14
SS6-14
R6-14
VA7-14
SS7-14
R7-14
VA8-14
SS8-14
R8-14
VA9-14
SS9-14
R9-14
[NAME]
SS10-14
R10-14
VA11-14
SS11-14
R11-14
VA12-14
SS12-14
R12-14
VA1-15
SS1-15
R1-15
[NAME]
SS2-15
R2-15
VA3-15
SS3-15
R3-15
VA4-15
SS4-15
R4-15
VA5-15
SS5-15
R5-15
Spreadsheet: 220573d1363195747-vlookup-or-other-tools-to-retun-more-than-1-match-from-2-criteria-sample2
Sheet: Sheet2

Name | Session |  | Name | Session | Price | Validation List
Viking | 4 |  | Viking | 12 | 24
[NAME] | 6 |  | Viking | 4 | 12
[NAME] | 8 |  | Viking | 6 | 12
[NAME] | 12 |  | Viking | 8 | 24
Sain |  |  | Viking | 8 | 48
 |  |  | [NAME] | 4 | 12
 |  |  | [NAME] | 8 | 24
 |  |  | [NAME] | 8 | 48
 |  |  | [NAME] | 4 | 12
 |  |  | [NAME] | 8 | 24
 |  |  | [NAME] | 8 | 48
 |  |  | [NAME] | 4 | 12
 |  |  | [NAME] | 8 | 24
 |  |  | [NAME] | 8 | 48
 |  |  | Sain | 12 | 24
 |  |  | Sain | 4 | 12
 |  |  | Sain | 6 | 12
 |  |  | Sain | 8 | 24
 |  |  | Sain | 8 | 48
Spreadsheet: 689997d1596800475-how-to-arrive-the-bonus-which-is-at-column-c-from-the-performance-at-column-a-and-b-bonus-
Sheet: Sheet1

Measurement Table |  |  |  | Required Result Area (Manually Created for Understanding)
Performance % From | Performance % To | Bonus % |  | Employee | Performance % | Bonus %
0 | 0.19 | 0.2 |  | A | 0.75 | 0.7
 | 0.39 | 0.3 |  | B | 0.43 | 0.5
 | 0.59 | 0.5 |  | C | 0.19 | 0.2
 | 0.79 | 0.7 |  | D | 0.75 | 0.7
 | 1 | 0.9 |  | E | 0.99 | 0.9
 |  |  |  | F | 0.4 | 0.5
Require Result:
If I enter the performance % manually at column F (Performance %) then the formula has to calculate the bonus % for that performance % given at the column A & B has to come at column G (Bonus %).
Kindly suggest a formula for this problem
Spreadsheet: 860168d1708368487-remove-ap-team-rank-from-college-basketball-team-name-ncaab-college-basketball-scores-and-game-results
Sheet: Only logo

Logo | Team
 | UConn
 | Purdue
 | Houston
 | Marquette
 | Arizona
 | Kansas
 | North Carolina
 | Tennessee
 | Duke
 | Iowa State
 | South Carolina
 | Baylor
 | Auburn
 | Illinois
 | Alabama
 | Dayton
 | Creighton
 | [NAME]
 | BYU
 | Wisconsin
 | Virginia
 | Kentucky
 | Indiana State
 | Florida Atlantic
 | Oklahoma
Spreadsheet: 40074d1238412507-excel-2007-changing-the-value-of-a-cell-via-a-formula-test-book
Sheet: Financial 

Financial
 | 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
Bank | 18 | 22 | 39 | 14 | 48 |  | 16 | 16 | 23
Credit Card Company | 969 | 1047 | 1361 | 891 | 1518
Mortgage Lender | 389 | 583 | 1357 | 196 | 1744
Electronic Stock Exchange |  |  |  |  |  |  | 45176
New Currency |  |  |  |  |  |  | 1230024
Spreadsheet: errol_mclaughlin_jr__10001__DKR_400bp_11-19-01
Sheet: Nymex

 |  |  |  |  |  |  |  |  |  | Libor + |  |  | Disc | Notional | 400 bp
Counterparty | Deal Date | [NAME] | Pub Code | Price Code | Fin / Phy | Period | Notional | Delta | Disc. Rate | 400 bp | Fixed | Mid | MtM Value | MtM Value | MtM Value
DKR Sells 100 Dec
AIGCOMARB | 2001-09-20 00:00:00 | Y46459.1 | NX1 | NG | F | 2001-12-01 00:00:00 | 770000 | 769024.7022 |  |  | 2.79 |  | 103818.3348
AARB | 2001-09-20 00:00:00 | Y46459.2 | NX1 | NG | F | 2001-12-01 00:00:00 | 230000 | 229708.6773 |  |  | 2.79 |  | 31010.6714
DKR Sells 100 Jan Nymex NG
AIGCOMARB | 2001-09-28 00:00:00 | Y68116.1 | NX1 | NG | F | 2002-01-01 00:00:00 | 770000 | 767656.0345 |  |  | 2.87 |  | 180399.1681
AARB | 2001-09-28 00:00:00 | Y68118.1 | NX1 | NG | F | 2002-01-01 00:00:00 | 230000 | 229299.8545 |  |  | 2.87 |  | 53885.4658
DKR Buys 100 Dec Nymex NG/Sells 100 Jan Nymex NG
AIGCOMARB | 2001-10-02 00:00:00 | Y73882.1 | NX1 | NG | F | 2001-12-01 00:00:00 | -770000 | -769024.7022 |  |  | 2.66 |  | -203791.5461
AARB | 2001-10-02 00:00:00 | Y73882.2 | NX1 | NG | F | 2001-12-01 00:00:00 | -230000 | -229708.6773 |  |  | 2.66 |  | -60872.7995
AIGCOMARB | 2001-10-02 00:00:00 | Y73883.1 | NX1 | NG | F | 2002-01-01 00:00:00 | 770000 | 767656.0345 |  |  | 2.88 |  | 172722.6078
AARB | 2001-10-02 00:00:00 | Y73883.2 | NX1 | NG | F | 2002-01-01 00:00:00 | 230000 | 229299.8545 |  |  | 2.88 |  | 51592.4673
DKR Buys 100 Dec Nymex/Sells 100 Jan Nymex
AIGCOMARB | 2001-10-17 00:00:00 | YB1706.1 | NX1 | NG | F | 2001-12-01 00:00:00 | -770000 | -769024.7022 |  |  | 2.93 |  | 3845.1235
AARB | 2001-10-17 00:00:00 | YB1706.2 | NX1 | NG | F | 2001-12-01 00:00:00 | -230000 | -229708.6773 |  |  | 2.93 |  | 1148.5434
AIGCOMARB | 2001-10-17 00:00:00 | YB1709.1 | NX1 | NG | F | 2002-01-01 00:00:00 | 770000 | 767656.0345 |  |  | 3.11 |  | -3838.2802
AARB | 2001-10-17 00:00:00 | [NAME] | NX1 | NG | F | 2002-01-01 00:00:00 | 230000 | 229299.8545 |  |  | 3.11 |  | -1146.4993
DKR Buys 200 Dec Nymex NG
AIGCOMARB | 2001-10-24 00:00:00 | YD7372.1 | NX1 | NG | F | 2001-12-01 00:00:00 | -1540000 | -1538049.4043 |  |  | 2.8925 |  | -49986.6056
AARB | 2001-10-24 00:00:00 | YD7372.2 | NX1 | NG | F | 2001-12-01 00:00:00 | -460000 | -459417.3545 |  |  | 2.8925 |  | -14931.064
DKR Sells 300 Dec Nymex NG/Buys 300 Jan Nymex NG
AIGCOMARB | 2001-10-25 00:00:00 | YE3052.1 | NX1 | NG | F | 2001-12-01 00:00:00 | 2310000 | 2307074.1065 |  |  | 3.1 |  | -403737.9686
AARB | 2001-10-25 00:00:00 | YE3052.2 | NX1 | NG | F | 2001-12-01 00:00:00 | 690000 | 689126.0318 |  |  | 3.1 |  | -120597.0556
AIGCOMARB | 2001-10-25 00:00:00 | YE3054.1 | NX1 | NG | F | 2002-01-01 00:00:00 | -2310000 | -2302968.1034 |  |  | 3.2525 |  | 339687.7953
AARB | 2001-10-25 00:00:00 | YE3054.2 | NX1 | NG | F | 2002-01-01 00:00:00 | -690000 | -687899.5634 |  |  | 3.2525 |  | 101465.1856
AIGCOMARB Dec
AARB Dec
AIGCOMARB Jan
AARB Jan
Total Dec/Jan
Spreadsheet: 758291d1638800323-productivity-for-individual-book1
Sheet: Sheet1

Name | Tenure Year | Tenure Month | Workout | Core Time | Productivity | Productivity Quartile 2 | Productivity Quartile 3 | Workout Quartile 2 | Workout Quartile 3 |  | CD | Productivity % tenure wise |  | Average Productivity % Tenure Wise
Ovi | 4 | 3 | 1018.07 | 845.87 | 1.2036 | 1.2036 | 1.2036 | 1018.07 | 1018.07 |  | 2yr | 1.038425 |  |  | 0 | < 6m
[NAME] | 2 | 10 | 1064.99 | 893.65 | 1.1917 | 1.1917 | 1.1938 | 1064.99 | 1066.87 |  | 2yr | 1.038425 |  |  | 6 | 6m - < 1yr | 1.038425
Him | 5 | 9 | 502.15 | 421.47 | 1.1914 | 1.1914 | 1.1938 | 502.15 | 503.16 |  | 2yr | 1.038425 |  |  | 12 | 1yr - < 2yr | 1.08818
Piy | 2 | 7 | 825.15 | 697.75 | 1.1834 | 1.1834 | 1.1938 | 825.75 | 833.01 |  | 2yr | 1.038425 |  |  | 24 | 2yr | 1.143593333333333
Ape | 3 | 2 | 820.11 | 699.82 | 1.1719 | 1.1719 | 1.1938 | 820.11 | 835.44 |  | 2yr | 1.038425
San | 1 | 11 | 971.23 | 835.68 | 1.1622 | 1.1622 | 1.1938 | 971.23 | 997.64 |  | 1yr - < 2yr | 1.038425
Uth | 5 | 0 | 1000.58 | 862.92 | 1.1595 | 1.1595 | 1.1938 | 1000.58 | 1030.18 |  | 2yr | 1.038425
Sak | 2 | 4 | 939.56 | 811.97 | 1.1571 | 1.1571 | 1.1938 | 939.56 | 969.36 |  | 2yr | 1.038425
Sug | 0 | 10 | 807.97 | 705.25 | 1.1457 | 1.1457 | 1.1938 | 807.97 | 841.89 |  | 6m - < 1yr | 1.038425
Rav | 8 | 8 | 917.66 | 803.18 | 1.1425 | 1.1425 | 1.1938 | 917.66 | 958.86 |  | 2yr | 1.038425
[NAME] | 2 | 9 | 861.31 | 754.28 | 1.1419 | 1.1419 | 1.1938 | 861.31 | 900.46 |  | 2yr | 1.038425
Var | 2 | 1 | 971.28 | 850.97 | 1.1414 | 1.1414 | 1.1938 | 971.28 | 1015.87 |  | 2yr | 1.038425
[NAME] | 1 | 6 | 472.4 | 415.18 | 1.1378 | 1.1378 | 1.1938 | 472.4 | 495.65 |  | 1yr - < 2yr | 1.038425
Niv | 2 | 11 | 1108.23 | 978.27 | 1.1328 | 1.1328 | 1.1938 | 1108.23 | 1167.91 |  | 2yr | 1.038425
Smi | 6 | 2 | 907.71 | 807.12 | 1.1246 | 1.1246 | 1.1938 | 907.71 | 963.56 |  | 2yr | 1.038425
Om | 9 | 0 | 892.36 | 797.5 | 1.1189 | 1.1238 | 1.1938 | 896.23 | 952.1 |  | 2yr | 1.038425
Yas | 1 | 1 | 902.51 | 830.92 | 1.0862 | 1.1238 | 1.1938 | 933.71 | 991.91 |  | 1yr - < 2yr | 1.038425
Log | 5 | 8 | 834.71 | 788.82 | 1.0582 | 1.1238 | 1.1938 | 886.42 | 941.67 |  | 2yr | 1.038425
Shi | 1 | 1 | 845.05 | 807.77 | 1.0462 | 1.1238 | 1.1938 | 907.69 | 964.27 |  | 1yr - < 2yr | 1.038425
Pra | 0 | 10 | 649.51 | 621 | 1.0459 | 1.1238 | 1.1938 | 697.86 | 741.36 |  | 6m - < 1yr | 1.038425
Ana | 4 | 11 | 852.18 | 823.4 | 1.035 | 1.1238 | 1.1938 | 925.25 | 982.93 |  | 2yr | 1.2036
Sur | 1 | 1 | 884.27 | 876.8 | 1.0085 | 1.1238 | 1.1938 | 985.32 | 1046.74 |  | 1yr - < 2yr | 1.2036
Rag | 0 | 8 | 797.79 | 810.08 | 0.9848 | 1.1238 | 1.1938 | 910.35 | 967.1 |  | 6m - < 1yr | 1.2036
Swa | 0 | 11 | 848.19 | 867.9 | 0.9773000000000001 | 1.1238 | 1.1938 | 975.29 | 1036.09 |  | 6m - < 1yr | 1.2036
Spreadsheet: 93258d1292865909-var-difference-on-pivot-table-book1
Sheet: Sheet4

 |  | Month
Report Date | Data | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | Grand Total
2010-12-15 00:00:00 | Sum of Sold | 9542 | 4870 | 8870 | 13177 | 3915 | 3131 | 3575 | 2354 | 1370 | 474 | 51278
 | Sum of Capacity | 15903 | 14016 | 30180 | 36966 | 17292 | 16866 | 17223 | 17280 | 17223 | 17643 | 200592
2010-12-20 00:00:00 | Sum of Sold | 9843 | 5005 | 4555 | 6719 | 4009 | 3207 | 3734 | 2403 | 1463 | 940 | 41878
 | Sum of Capacity | 15903 | 14016 | 15090 | 18483 | 17292 | 16866 | 17793 | 17280 | 17223 | 17643 | 167589
Total Sum of Sold |  | 19385 | 9875 | 13425 | 19896 | 7924 | 6338 | 7309 | 4757 | 2833 | 1414 | 93156
Total Sum of Capacity |  | 31806 | 28032 | 45270 | 55449 | 34584 | 33732 | 35016 | 34560 | 34446 | 35286 | 368181
Spreadsheet: 788023d1658228903-auto-populate-a-cell-based-on-exact-adjacent-value-when-having-same-names-book-sample1
Sheet: Sheet1

Number | Name | Serial |  |  |  | Serial | Name | Number
10 | [NAME] | 66666 |  |  |  |  |  | 10
10 | [NAME] | 55555 |  |  |  |  |  | 10
10 | [NAME] | 23335 |  |  |  |  |  | 11
11 | Mac | 77777 |  |  |  |  |  | 11
11 | [NAME] | 42224
12 | [NAME] | 55224 |  |  |  | These 2 columns don´t show the correct data from the right of the 2nd, or 3rd ¨10¨. When I press the 2nd or 3rd ¨10¨ in the I column I need the adjancet data coresponding to the right A cell.
12 | Doe | 12122
13 | [NAME] | 83838
14 | [NAME] | 21212
 |  |  |  |  | Example: | Should return 55555 | Should return [NAME] | 2nd 10
 |  |  |  |  |  | Should return 23335 | Should return [NAME] | 3rd 10
Spreadsheet: 105562d1302876214-excel-2007-newbie-formatting-help-requested-book1_duckhunter
Sheet: Sheet2

2010-01-01 00:00:00 | 1123000 | < format this column Format Cells….
2010-01-02 00:00:00 | 2123000 |  | Number Format > Number
2010-01-03 00:00:00 | 3123000 |  | Decimal points = 0
2010-01-04 00:00:00 | 4123000 |  | Check "Use thousands separator"
2010-01-05 00:00:00 | 5123000
2010-01-06 00:00:00 | 6123000 |  | Remember that this is now a million times that of the original number
2010-01-07 00:00:00 | 7123000
2010-01-08 00:00:00 | 8122999.999999999 |  | You can now Copy Columns A & B
2010-01-09 00:00:00 | 9123000 |  | and [NAME] special > Values if you don't need the formulae.
2010-01-10 00:00:00 | 10123000
2010-01-11 00:00:00 | 11123000
2010-01-12 00:00:00 | 12123000
2010-01-13 00:00:00 | 13123000
2010-01-14 00:00:00 | 14123000
2010-01-15 00:00:00 | 15123000
2010-01-16 00:00:00 | 16123000
2010-01-17 00:00:00 | 17123000
2010-01-18 00:00:00 | 18123000
2010-01-19 00:00:00 | 19123000
2010-01-20 00:00:00 | 20123000
2010-01-21 00:00:00 | 21123000
2010-01-22 00:00:00 | 22123000
2010-01-23 00:00:00 | 23123000
2010-01-24 00:00:00 | 24123000
2010-01-25 00:00:00 | 25123000
2010-01-26 00:00:00 | 26123000
2010-01-27 00:00:00 | 27123000
2010-01-28 00:00:00 | 28123000
2010-01-29 00:00:00 | 29123000
2010-01-30 00:00:00 | 30123000
2010-01-31 00:00:00 | 31123000
2010-02-01 00:00:00 | 32123000
2010-02-02 00:00:00 | 33123000
2010-02-03 00:00:00 | 34123000
2010-02-04 00:00:00 | 35123000
2010-02-05 00:00:00 | 36123000