tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18849__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
Spreadsheet: 790434d1659705624-using-lookup-to-find-the-1st-2nd-3rd-and-4th-value-test-how-to-return-nth-value-in-lookup
Sheet: Sheet1

School name | Subject 1 | Price | Subject 2 | Price | Subject 3 | Price | Subject 4 | Price
St Marys School |  | 50 | Science | 25 | English | 75
St Peters School |  | 50
London Free School |  | 15
St Pauls Academy |  | 100 | Maths | 25 | Science | 15 | English | 90 | History | 75
Spreadsheet: 69257d1269806591-excel-2007-link-students-based-on-home-room-practice-student-names
Sheet: Theme 10

[NAME] | LA.1.1.3.4 Manipulate phonemes to create words | LA.1.1.3.4 Manipulate phonemes to create words | LA.1.1.3.1 Identify individual phonemes. | LA.1.1.3.1 Identify individual phonemes. | LA.1.1.4.3 Decode words with r-controlled letter-sound associations. | LA.1.1.4.3 Decode words with r-controlled letter-sound associations. | LA.1.1.4.3 Decode words with r-controlled letter-sound associations. | LA.1.1.4.3 Decode words with r-controlled letter-sound associations. | LA.1.1.4.3 Decode words with r-controlled letter-sound associations. | [NAME] base words and inflectional endings. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | LA.1.1.4.5 Recognize high-frequency words. | [NAME] and sort common words | LA.1.1.6.4 Categorize key vocabulary | LA.1.1.6.4 Categorize key vocabulary | [NAME] and sort common words | LA.1.1.7.5 Distinguish fact/fiction, cause/effect. | LA.1.1.7.6 Arrange events in sequence. | [NAME] the correct meaning of words with multiple meanings. | LA.1.1.7.6 Arrange events in sequence. | LA.1.1.7.1 Identify a text's features. | LA.1.1.7.2 Use background knowledge and supporting details to verify information. | LA.1.1.7.6 Arrange events in sequence. | LA.1.2.2.3 Organize information through charting, listing, mapping, or summarizing. | LA.1.1.7.6 Arrange events in sequence. | LA1.1.7.2 Use background knowledge and supporting details from text to verify the accurancy of information. | LA.1.5.2.3 Listen to fiction and nonfiction and demostrate understanding | LA.1.5.2.3 Listen to fiction and nonfiction and demostrate understanding | [NAME] narratives.
57 | Phonemic Awareness |  |  |  | Phonic / Word Analysis |  |  |  |  |  | High-Frequency Words |  |  |  |  |  |  |  | Vocabulary Development |  |  |  | Reading Comprehension / Literary Analysis (Fiction) |  |  |  |  | Reading Comprehension / Literary Analysis (Non-Fiction) |  |  |  |  | Listening Comprehension |  | Writing
Item | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2
Value | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6
Spreadsheet: 96825d1296104983-to-check-the-hirerchy-value-in-the-column-b-with-column-a-sample-list
Sheet: Sheet1

user id | user type | RESULT SHOULD BE AS:
1333 | full user | FULL USER
1333 | employee user | -
1333 | restricted user | -
1333 | full user | -
1332 | employee user | EMPLOYEE USER
1332 | restricted user | -
1332 | employee user | -
1331 | employee user | EMPLOYEE USER
1331 | restricted user | -
1331 | employee user | -
1103 | restricted user | RESTRICTED USER
1103 | BLANK
1103 | BLANK
HIRERCHY AS FOLLOWS:
1. Full User
2. Employee User
3. Restricted User
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0110

 | Date: | 2013-01-10 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 17 | 72.57
 | 11:00:00 | 60 | 357.33
 | 12:00:00 | 77 | 383.21
 | 13:00:00 | 72 | 384.94
 | 14:00:00 | 42 | 235.22
 | 15:00:00 | 48 | 268.73
 | 16:00:00 | 40 | 215.04
 | 17:00:00 | 62 | 500.46
 | 18:00:00 | 56 | 496.36
 | 19:00:00 | 46 | 343.85
 | 20:00:00 | 40 | 245.99
 | 21:00:00 | 25 | 190.28
 | 22:00:00 | 22 | 196.49
 | 23:00:00 | 18 | 113.06
 | 1900-01-01 00:00:00 | 3 | 25.43
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 7666624d-a566-4992-b4d4-0c3a27b8a9c7
Sheet: General

GENERAL |  |  |  |  |  |  | 120171
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | [NAME]. |  |  |  | Requesting funding for the KCP&L Utilities.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  | Director of General Services
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  | General Services
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | General Services
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  |  |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections -- |  | Cost Projection
 |  |  |  |  | Including Indirect |  | 4500000
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: 49226d1248458022-excel-2007-invoice-numbering-new-invoice-for-editing2
Sheet: Nankang

 | 155/65/13 | 40
 | 155/70/13 | 34
 | 165/65/13 | 35
 | 165/70/13 | 35
 | 175/65/13 | 42
 | 14" (H)
 | 175/65/14 | 40
 | 185/60/14 | 43
 | 185/65/14 | 42
 | 185/70/14 | 40
 | 195/60/14 | 45
 | 195/65/14 | 45
 | 15" (V)
 | 185/55/15 | 55
 | 185/65/15 | 48
 | 195/45/15 | 50
 | 195/50/15 | 45
 | 195/55/15 | 52
 | 195/60/15 | 48
 | 195/65/15 | 48
 | 205/50/15 | 56
 | 205/55/15 | 54
 | 205/60/15 | 55
 | 205/65/15 | 52
 | 215/60/15 | 60
 | 215/65/15 | 55
 | 16" (V)
 | 195/45/16 | 58
 | 195/50/16 | 57
 | 195/55/16 | 55
 | 205/45/16 | 63
 | 205/50/16 | 60
 | 205/55/16 | 65
 | 205/60/16 | 60
 | 215/40/16 | 75
 | 215/55/16 | 70
 | 215/60/16 | 68
 | 215/65/16 | 82
 | 225/50/16 | 70
 | 225/55/16 | 70
 | 225/60/16 | 70
 | 17" (W,Z,ZR)
 |  | Nankang
 | 205/40/17 | 60
 | 205/45/17 | 65
 | 215/40/17 | 65
 | 215/45/17 | 70
 | 215/50/17 | 85
 | 225/45/17 | 70
 | 225/50/17 | 85
 | 235/40/17 | 82
 | 235/45/17 | 80
 | 18" (W,Z,ZR)
 | 215/35/18 | 85
 | 215/40/18 | 75
 | 215/45/18 | 90
 | 225/35/18 | 95
 | 225/40/18 | 85
 | 225/45/18 | 96
 | 235/40/18 | 95
 | 245/45/18 | 110
 | 19"
 | 225/35/19 | 125
 | 255/35/19 | 150
 | 20"
 | 225/30/20 | 190
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 072e835f-7f76-4f3d-aabc-960214bb4195
Sheet: Language

Language | Titles | Percent
French | 68
Spanish | 57
German | 56
Italian | 35
Japanese | 28
Swedish | 27
Arabic | 24
Russian | 20
Chinese | 16
Portuguese | 14
Norwegian | 11
Icelandic | 10
Polish | 10
Danish | 8
Turkish | 6
Catalan | 5
Dutch | 4
Finnish | 4
Greek | 4
Hebrew | 4
Hungarian | 4
Romanian | 4
Serbian | 4
Various | 4
Czech | 3
Korean | 3
Macedonian | 3
Estonian | 2
Persian | 2
Slovenian | 2
Ukrainian | 2
Vietnamese | 2
Afrikaans | 1
Basque | 1
Croatian | 1
Flemish | 1
Georgian | 1
Tigrinya | 1
Urdu | 1
Spreadsheet: 879708d1727268224-employee-tardiness-formula-requested-tardiness-formula-request-sample-3
Sheet: Sheet1

Agent ID | Logged On DateTime
Agent38757 | 8/2/24 8:13:27 AM
 | 8/5/24 8:21:35 AM
 | 8/5/24 3:31:24 PM
 | 8/6/24 8:24:21 AM
 | 8/7/24 8:13:55 AM
 | 8/8/24 10:56:22 AM
 | 8/9/24 8:17:54 AM
 | 8/12/24 8:03:35 AM
 | 8/13/24 8:17:37 AM
 | 8/14/24 8:13:07 AM
 | 8/15/24 8:19:18 AM
 | 8/16/24 7:59:05 AM
 | 8/19/24 7:33:44 AM
 | 8/19/24 9:55:00 AM
 | 8/20/24 8:14:05 AM
 | 8/21/24 8:08:57 AM
 | 8/22/24 7:43:24 AM
Agent38757
Agent4174 | 8/1/24 8:11:22 AM
 | 8/2/24 8:16:26 AM
 | 8/5/24 8:04:14 AM
 | 8/6/24 8:08:20 AM
 | 8/6/24 11:49:40 AM
 | 8/6/24 12:03:10 PM
 | 8/7/24 8:07:22 AM
 | 8/8/24 8:08:16 AM
 | 8/9/24 8:16:43 AM
 | 8/9/24 8:18:27 AM
 | 8/9/24 9:43:28 AM
 | 8/9/24 4:02:52 PM
 | 8/12/24 8:30:45 AM
 | 8/12/24 8:35:08 AM
 | 8/12/24 11:46:11 AM
 | 8/12/24 12:33:25 PM
 | 8/13/24 8:17:53 AM
 | 8/13/24 9:25:25 AM
 | 8/14/24 8:15:44 AM
 | 8/14/24 11:49:39 AM
 | 8/14/24 12:21:45 PM
 | 8/15/24 8:19:16 AM
 | 8/15/24 2:34:52 PM
 | 8/16/24 8:09:42 AM
 | 8/16/24 8:14:19 AM
 | 8/16/24 8:57:10 AM
 | 8/16/24 4:05:59 PM
 | 8/19/24 8:14:57 AM
 | 8/19/24 12:07:21 PM
 | 8/19/24 12:12:13 PM
 | 8/19/24 4:28:20 PM
 | 8/20/24 8:16:22 AM
 | 8/21/24 7:49:17 AM
 | 8/21/24 12:00:17 PM
 | 8/21/24 12:17:46 PM
 | 8/21/24 12:23:25 PM
 | 8/22/24 8:14:17 AM
 | 8/22/24 8:23:23 AM
 | 8/22/24 3:06:44 PM
 | 8/26/24 8:24:29 AM
 | 8/26/24 12:51:11 PM
 | 8/26/24 4:18:25 PM
 | 8/27/24 8:14:06 AM
 | 8/27/24 1:54:06 PM
 | 8/28/24 7:32:12 AM
 | 8/28/24 8:44:42 AM
 | 8/29/24 8:13:21 AM
 | 8/29/24 10:56:21 AM
 | 8/30/24 8:08:12 AM
 | 08/30/2024
Agent4174
Spreadsheet: 738684d1625171288-formula-to-extract-information-from-a-table-alternative-to-filter-formula
Sheet: Sheet1

User name and surname | Region | Job Function | Location | Training Title | Training Record Status
Spreadsheet: 792723d1661100526-get-row-header-relative-to-max-value-index-match-max-wont-work-example-sheet
Sheet: Sheet1

Match |  |  |  | Match 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 |  |  |  | 0 | 0.0938080023783221 | 0.1491507024666235 | 0.1185716116018052 | 0.06284125985928211 | 0.02497872733207648 | 0.007943021136462012 | 0.002104843851580829 | 0.0004780873563730692 | 9.501730027769515e-05
 |  |  |  | 1 | 0.07284641484019 | 0.1158226768519292 | 0.09207654558275735 | 0.04879925346163549 | 0.01939718027545298 | 0.006168137025853793 | 0.001634512243078243 | 0.000371257771290634 | 7.378549268226818e-05
 |  |  |  | 2 | 0.02828436818038108 | 0.04497093292654238 | 0.03575092778077969 | 0.0189474808728011 | 0.007531420589135844 | 0.002394927176704889 | 0.0006346385910684438 | 0.0001441497363466489 | 2.864898768147317e-05
 |  |  |  | 3 | 0.007321389667273728 | 0.01164069572126505 | 0.009254103594621045 | 0.00490454267170848 | 0.001949503150628584 | 0.0006199252878331036 | 0.0001642757721674891 | 3.731306223628604e-05 | 7.415771179731685e-06
 |  |  |  | 4 | 0.001421352590896207 | 0.002259889689687222 | 0.001796563865386289 | 0.000952153177251892 | 0.0003784706838501153 | 0.0001203504326456328 | 3.189200479731902e-05 | 7.243845785299563e-06 | 1.439675534129847e-06
 |  |  |  | 5 | 0.0002207496969246429 | 0.0003509825551216864 | 0.0002790236084487139 | 0.0001478785254626097 | 5.87801290755703e-05 | 1.869157709454877e-05 | 4.953134386513061e-06 | 1.125038763721156e-06 | 2.235954258391294e-07
 |  |  |  | 6 | 2.857045523892824e-05 | 4.542579908579426e-05 | 3.61125366278965e-05 | 1.913912839468345e-05 | 7.607598425221357e-06 | 2.419151075469345e-06 | 6.410577511713455e-07 | 1.456077634023979e-07 | 2.893876274605571e-08
 |  |  |  | 7 | 3.169475618500115e-06 | 5.039330365906718e-06 | 4.006159629138761e-06 | 2.123207358755689e-06 | 8.439521709554488e-07 | 2.683695547392353e-07 | 7.11160146170745e-08 | 1.615305923930199e-08 | 3.210333968645007e-09
 |  |  |  | 8 | 3.076562365116531e-07 | 4.891602275986071e-07 | 3.888718964019084e-07 | 2.06096548437165e-07 | 8.192116929262418e-08 | 2.605022948384552e-08 | 6.903124695166686e-09 | 1.567953192227169e-09 | 3.116222951751999e-10
Spreadsheet: vkaminski__40982__CapitalTemplate1
Sheet: pivot_table

Rating | Volume Scalar | Capital. Required
 |  |  |  |  | Sum of Capital. Required | Rating
 |  |  |  |  | Volume Scalar | A | A- | A+ | AA | AA- | AA+ | AAA | B | B- | [NAME] | BB | BB- | BB+ | BBB | BBB- | BBB+ | CC | CCC | D | Grand Total
 |  |  |  |  | 1 | 3810239.3575125 | 3890404.271459013 | 2158769.041301363 | 2136031.437572603 | 2157648.757781858 | 0 | 0 | 6719181.855139138 | 6872703.107512637 | 6739474.203273576 | 6290187.9077267 | 6549645.865032585 | 5665727.770711018 | 4638240.371082704 | 5044850.329762416 | 4612208.597915548 | 6231257.613763467 | 6615918.632875434 | 5511077.116654303 | 85643566.23707685
 |  |  |  |  | 2 | 7645912.584093005 | 7651358.933091331 | 4326797.332109032 | 4342519.197476639 | 4422440.257148647 | 0 | 0 | 13691239.81731353 | 14282527.58862593 | 13440939.28065639 | 12549472.18571232 | 13262712.70168116 | 11047561.67467843 | 9257457.6952045 | 10099761.06273818 | 9260603.205673043 | 11646762.50666676 | 13427246.15049547 | 10932909.78445202 | 171288221.9578164
 |  |  |  |  | 3 | 11626791.05196431 | 11743976.79351105 | 6590645.933273528 | 6614377.605883133 | 6527973.347133706 | 0 | 0 | 20184737.09438474 | 20760700.70483319 | 20147572.89608703 | 18877250.64270883 | 19792521.88063522 | 16800491.41967422 | 13902304.18048231 | 15091156.13361076 | 13285969.21954544 | 18191260.98944457 | 20046805.22529249 | 16565822.26396391 | 256750357.3824284
 |  |  |  |  | Grand Total | 23082942.99356982 | 23285739.99806139 | 13076212.30668392 | 13092928.24093238 | 13108062.36206421 | 0 | 0 | 40595158.76683742 | 41915931.40097176 | 40327986.380017 | 37716910.73614785 | 39604880.44734897 | 33513780.86506367 | 27798002.24676951 | 30235767.52611136 | 27158781.02313404 | 36069281.10987479 | 40089970.00866339 | 33009809.16507024 | 513682145.5773216
Spreadsheet: 702819d1604561591-to-bring-row-cell-data-in-column-data-bill-2-
Sheet: Data

 |  |  |  | Product Details |  | Selling Price
 |  |  | ProductId | Product | ProductId
 |  |  | DRF001 | [NAME] | DRF001 | 1700
 |  |  | DRF001 | [NAME] | DRF001 | 750
 |  |  | DRF003 | Anjeer Medium | DRF003 | 1500
 |  |  | DRF004 | Cardamom Green 8mm | DRF004 | 3200
 |  |  | DRF005 | Cashew  W 210 | DRF005 | 1275
 |  |  | DRF006 | [NAME] | DRF006 | 625
 |  |  | [NAME] | Cashew Tukda | [NAME] | 525
 |  |  | DRF008 | [NAME]) | DRF008 | 1600
 |  |  | DRF009 | Cashew W 240 | DRF009 | 1100
 |  |  | SPC002 | Clove | SPC002 | 575
 |  |  | GRC001 | [NAME] | GRC001 | 160
 |  |  | DRF010 | Jardalu Medium | DRF010 | 520
 |  |  | DRF011 | Kharik | DRF011 | 290
 |  |  | DRF012 | [NAME] | DRF012 | 300
 |  |  | GRC002 | [NAME] | GRC002 | 520
 |  |  | GRC003 | [NAME] [NAME] | GRC003 | 370
 |  |  | GRD004 | [NAME] | GRD004 | 370
 |  |  | GRC005 | Onion [NAME] | GRC005 | 400
 |  |  | DRF013 | Pista | DRF013 | 1350
 |  |  | DRF014 | Pista Salted | DRF014 | 1025
 |  |  | DRF015 | Raisins Afgan Black | DRF015 | 425
 |  |  | DRF016 | Raisins Afgan Green | DRF016 | 450
 |  |  | DRF017 | Raisins [NAME] | DRF017 | 400
 |  |  | DRF018 | Raisins [NAME] | DRF018 | 360
 |  |  | SPC001 | [NAME] | SPC001 | 240
 |  |  | WPI001 | Wooden Press Groundnut Oil | WPI001 | 280
Spreadsheet: 153158d1335788475-simple-vlookup-not-bringing-back-correct-results-vlookup
Sheet: Sheet1

 |  | Product | Value
 | 1 | DA50S | 1
 | 2 | DA55S | 2
 | 3 | DA70S | 3
 | 4 | DA75S | 4
 | 5 | DA80 | 5
 | 6 | DA90 | 6
 | 7 | DI200 Two Station | 7 |  | Product
 | 8 | DI200 Three Station | 8 |  | SH7A High Shredder
 | 9 | [NAME] | 9
 | 10 | DI380 Two Station | 10
 | 11 | DI380 Three Station | 11
 | 12 | W350 | 12
 | 13 | DF80 | 13
 | 14 | DF90 | 14 |  | Product 8 is returning 6
 | 15 | [NAME] | 15 |  | Product 10 is returning 14
 | 16 | SH5A [NAME] | 16 |  | Product 11 is returning 14
 | 17 | SH6A Office Shredder | 17 |  | Product 12 is returning 18
 | 18 | SH7A High Shredder | 18 |  | Product 13 is returning 6
 |  |  |  |  | Product 14 is returning 6
Spreadsheet: 81620d1281722203-matching-rows-in-excel-and-finding-out-duplicate-rows-my_contacts
Sheet: Sheet1

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-456-567 | www.bigdesign.com
Big Design | Stephen | Gills | Director | 12 NY, USA | 123-456-568 | www.bigdesign.com
Big Design | [NAME] | McKay | CEO | 13 NY, USA | 432-455-354 | www.bigdesign.com
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
ABC LLC | [NAME] | Fard | Technician | 415 M Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 453-989-877 | www.abc.com
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000 | www.futureltd.com
Future Ltd | [NAME] | Farris | CFO | 34, New Zeland | 103-340-009 | www.futureltd.com
Digital Torch | Jet | [NAME] | Technician | 12, Australia | 124-009-007 | www.digital.com
Digital Torch | Johny | Mac | Designer | 12, Australia | 124-009-008 | www.digital.com
Digital Torch | [NAME] | Rid | [NAME] | 12, Australia | 124-009-009 | www.digital.com
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-000-000
Green llc | Stephen | Gills | Director | 123, Texas, USA | 543-333-233 | www.bigdesign.com
Green llc | [NAME] | McKay | CEO | 34B, London, UK | 432-455-354 | www.bigdesign.com
Angry [NAME] | [NAME] | Tilds | Technician | 333, NYC , USA | 111-111-111 | www.angryfox.com
TP21 Company | [NAME] | Mott |  |  | 101-101-909
 | [NAME] | Mobile |  | 33, NY
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
 | Ramon | Hobbs | Secretary | 123, AB, USA | 123-101-100
ABC LLC | [NAME] | Fard | Technician | Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 456-678-876 | www.abc.com
 | [NAME] | Folder | Sales
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
 | [NAME] | [NAME] | Production |  | 345-345-444
 | [NAME] | Bond |  | VP | 165-827-272
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000
Future Ltd | [NAME] | Farris |  | 34, New Zeland | 103-340-009 | www.futureltd.com
 | [NAME] |  |  |  | 102-090-292
Spreadsheet: 845321d1696858862-find-duplicates-highlight-highest-value-duplicate-highlight
Sheet: Sheet1

Product # | Margin Rebate | Margin Rebate
12345 | 0.05 | 0.05
12345 | 0.08 | 0.08
901112 | 0.03 | 0.03
901112 | 0.03 | 0.03
4568 | 0.05 | 0.05
4568 | 0.08 | 0.08