tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774315d1648389050-lookup-rates-in-excelsheet-based-on-binning-buckets-instead-of-full-data-modification-invuloefening-2022-rates
Sheet: Rates

 | OLD
 | Interest rate
 | Period/ rates | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.4 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.5 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.6 | 0.61 | 0.62 | 0.63 | 0.64 | 0.65 | 0.66 | 0.67 | 0.68 | 0.69 | 0.7 | 0.71 | 0.72 | 0.73 | 0.74 | 0.75 | 0.76 | 0.77 | 0.78 | 0.79 | 0.8 | 0.81 | 0.82 | 0.83 | 0.84 | 0.85 | 0.86 | 0.87 | 0.88 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93 | 0.94 | 0.95 | 0.96 | 0.97 | 0.98 | 0.99 | 1
 | 10 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016
 | Old
 | Input
 | LTV | 0.6437
 | LTV (rounded
 | Rate
 | NEW
 | 0 | 0.600011 | 0.70001 | 0.90001
 | 0.0115 | 0.012 | 0.014 | 0.016
 | New
 | LTV
 | Rate
Spreadsheet: 812387d1673113647-need-a-formula-function-to-reverse-order-html-to-xls-formatting-1-
Sheet: Sheet1

2022-12-12 17:05:27 |  | 201.39
5703005768 |  | reference ID [PHONE] |  |  |  |  | reference ID [PHONE]
Company 1601 |  | Arrive |  |  |  |  | Arrive
Sent |  | Sent |  |  |  |  | Sent
Arrive |  | Company 1601 |  |  |  |  | Company 1601
reference ID [PHONE] |  | 5666495816 |  |  |  |  | 5666495816
184.34 |  | 2022-11-12 11:10:39 |  |  |  |  | 44877.46572916667
2022-11-14 08:00:25 |  | 99.39 |  |  |  |  | 99.39
5670105872 |  | reference ID [PHONE] |  |  |  |  | reference ID [PHONE]
Company 1601 | > | Arrive |  |  |  |  | Arrive
Sent |  | Sent |  |  |  |  | Sent
Arrive |  | Company 1601 |  |  |  |  | Company 1601
reference ID [PHONE] |  | 5670105872 |  |  |  |  | 5670105872
99.39 |  | 2022-11-14 08:00:25 |  |  |  |  | 44879.33362268518
2022-11-12 11:10:39 |  | 184.34 |  |  |  |  | 184.34
5666495816 |  | reference ID [PHONE] |  |  |  |  | reference ID [PHONE]
Company 1601 |  | Arrive |  |  |  |  | Arrive
Sent |  | Sent |  |  |  |  | Sent
Arrive |  | Company 1601 |  |  |  |  | Company 1601
reference ID [PHONE] |  | 5703005768 |  |  |  |  | 5703005768
201.39 |  | 2022-12-12 17:05:27 |  |  |  |  | 44907.71211805556
Spreadsheet: 691501d1597731632-golf-stableford-countback-formula-stableford-scores
Sheet: Sheet1

 |  |  |  |  |  |  | [NAME]
# | Name | HCP | Hole 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
1 | Scott |  | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 0 | 1 | 0 | 2 | 2 | 3 | 2 | 1 | 2 | 3
2 | [NAME] |  | 2 | 4 | 0 | 3 | 1 | 2 | 2 | 2 | 2 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | [NAME] |  | 0 | 3 | 0 | 1 | 2 | 4 | 1 | 3 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 0 | 1 | 2
4 | [NAME] |  | 2 | 3 | 2 | 2 | 1 | 2 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 874441d1721040718-excel-formula-age-calculation-display-in-yyyy-mmm-dd-nsw-public-and-school-holidays
Sheet: Birthdays

[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Val
Year of Birth | Day | Age |  |  | Year of Birth | Day | Age |  |  | Year of Birth | Day | Age |  |  |  |  |  |  |  |  | Years | Years | Years
1931-01-11 00:00:00 |  |  |  |  | 1946-06-06 00:00:00 |  |  |  |  | 1943-09-09 00:00:00
1932-01-11 00:00:00
1933-01-11 00:00:00
1934-01-11 00:00:00
1935-01-11 00:00:00
1936-01-11 00:00:00
1937-01-11 00:00:00
1938-01-11 00:00:00
1939-01-11 00:00:00
1940-01-11 00:00:00
1941-01-11 00:00:00
1942-01-11 00:00:00
1943-01-11 00:00:00
1944-01-11 00:00:00
1945-01-11 00:00:00
1946-01-11 00:00:00
1947-01-11 00:00:00
1948-01-11 00:00:00
1949-01-11 00:00:00
1950-01-11 00:00:00
1951-01-11 00:00:00
1952-01-11 00:00:00
1953-01-11 00:00:00
1954-01-11 00:00:00
1955-01-11 00:00:00
1956-01-11 00:00:00
1957-01-11 00:00:00
1958-01-11 00:00:00
1959-01-11 00:00:00
1960-01-11 00:00:00
1961-01-11 00:00:00
1962-01-11 00:00:00
1963-01-11 00:00:00
1964-01-11 00:00:00
1965-01-11 00:00:00
1966-01-11 00:00:00
1967-01-11 00:00:00
1968-01-11 00:00:00
1969-01-11 00:00:00
1970-01-11 00:00:00
1971-01-11 00:00:00
1972-01-11 00:00:00
1973-01-11 00:00:00
1974-01-11 00:00:00
1975-01-11 00:00:00
1976-01-11 00:00:00
1977-01-11 00:00:00
1978-01-11 00:00:00
1979-01-11 00:00:00
1980-01-11 00:00:00
1981-01-11 00:00:00
1982-01-11 00:00:00
1983-01-11 00:00:00
1984-01-11 00:00:00
1985-01-11 00:00:00
1986-01-11 00:00:00
1987-01-11 00:00:00
1988-01-11 00:00:00
1989-01-11 00:00:00
1990-01-11 00:00:00
1991-01-11 00:00:00
1992-01-11 00:00:00
1993-01-11 00:00:00
1994-01-11 00:00:00
1995-01-11 00:00:00
1996-01-11 00:00:00
1997-01-11 00:00:00
1998-01-11 00:00:00
1999-01-11 00:00:00
2000-01-11 00:00:00
2001-01-11 00:00:00
2002-01-11 00:00:00
2003-01-11 00:00:00
2004-01-11 00:00:00
2005-01-11 00:00:00
2006-01-11 00:00:00
2007-01-11 00:00:00
2008-01-11 00:00:00
2009-01-11 00:00:00
2010-01-11 00:00:00
2011-01-11 00:00:00
2012-01-11 00:00:00
Spreadsheet: 125421d1319026254-value-added-prototype-value-added-ks3-v2-1-
Sheet: Sheet3

1 | 7a
2 | 7b
3 | 7c
4 | 6a
5 | 6b
6 | 6c
7 | 5a
8 | 5b
9 | 5c
10 | 4a
11 | 4b
12 | 4c
13 | 3a
14 | 3b
15 | 3c
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Worx

Kit # | 7 | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
WG918 | WRX-AMB-WG918 |  | 53 | 165 | 165 |  |  |  | X
 | WRX-BAT-WA3520 | 2 |  | 50 | 50 |  |  |  | X
 | WRX-TRM-WG155 | 1 |  | 65 | 65 |  |  |  | X
 | WRX-BLW-WG545 | 1 |  | 55 | 55 |  |  |  | X
 | WRX-CHG-WA3732 | 1 |  | 15 | 15 |  |  |  | X
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: andy_zipper__142__ICE - Mar15 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-15-01 thru Mar-15-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - CG-ONSH - Apr01-Oct01 | Apr01-Oct01 | -0.01 | -0.01 | -0.01 | -0.01 | Mar-15-01 15:32 GMT | 4280000 | MMBtus
 | NG Fin BS, LD1 for IF - HSC - Apr01 | Apr01 | 0.025 | 0.025 | 0.025 | 0.025 | Mar-15-01 20:33 GMT | 600000 | MMBtus
 | NG Fin BS, LD1 for IF - Tran 65 - Apr01 | Apr01 | 0.025 | 0.028 | 0.026 | 0.025 | Mar-15-01 20:26 GMT | 600000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Socal - Nov01-Mar02 | Nov01-Mar02 | 2.85 | 2.85 | 2.85 | 2.85 | Mar-15-01 19:13 GMT | 755000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 4.89 | 4.935 | 4.906 | 4.91 | Mar-15-01 19:13 GMT | 870000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 4.89 | 4.96 | 4.935 | 4.945 | Mar-15-01 21:44 GMT | 8250000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 4.973 | 4.983 | 4.978 | 4.983 | Mar-15-01 22:08 GMT | 310000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5 | 5.01 | 5.005 | 5.01 | Mar-15-01 19:14 GMT | 2140000 | MMBtus
Spreadsheet: richard_shapiro__32241__washingtonheadcount
Sheet: STAFFING BY LOCATION

2001 - 2003 Operating and Strategic Plan
Staffing Summary
By Location
 |  | Company No.: |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Portland
 |  | California
 |  | Dublin
 |  | Washington |  |  |  | 11 |  | 14 |  | 14 |  | 13
 |  | Other (please list)
 | Expatriates
 | International
 |  | London
 |  | Canada
 |  | South America
 |  | Other (please list)
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Portland
 |  | California
 |  | Dublin
 |  | Washington
 |  | Other (please list)
 | Expatriates
 | International
 |  | London
 |  | India
 |  | South America
 |  | Other (please list)
 | Total
Total Employees by Location *
* Totals should tie.
Spreadsheet: 841776d1693934121-smoothly-create-an-exponential-graph-in-which-the-relation-between-the-accuracy-and-evasio-accuracyevasionanalysismrshorty-copy
Sheet: accuracyevasioncontour

f1 | 1.165 |  |  | -0.5 | 0 | 0.3 | 0.7 | 1
 |  |  |  | evasion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | target points given throughout the thread
row# | [NAME] | Evasion | Chance to Hit | a(18) | a(18) | a(18) | a(18) | a(18)
1 | 3 | -0.5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | row# | x | y | a
2 | 2.9 | -0.4 | 4.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0.1 | -0.4 | 0.25
3 | 2.8 | -0.3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 0 | -0.5 | 0.375
4 | 2.7 | -0.2 | 3.38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | -0.1 | -0.4 | >0
5 | 2.6 | -0.1 | 2.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 0 | -0.5 | 0.25
6 | 2.5 | 0 | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | -0.5 | 0.35
7 | 2.4 | 0.1 | 2.18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 0.6 | 0.1 | 0.55
8 | 2.3 | 0.2 | 1.92
9 | 2.2 | 0.3 | 1.69
10 | 2.1 | 0.4 | 1.5
11 | 2 | 0.5 | 1.33
12 | 1.9 | 0.6 | 1.19
13 | 1.8 | 0.7 | 1.06
14 | 1.7 | 0.8 | 0.94
15 | 1.6 | 0.9 | 0.84
16 | 1.5 | 1 | 0.75
17 | 1.4 | 0.9 | 0.74
18 | 1.3 | 0.8 | 0.72
19 | 1.2 | 0.7 | 0.71
20 | 1.1 | 0.6 | 0.69
21 | 1 | 0.5 | 0.67
22 | 0.9 | 0.4 | 0.64
23 | 0.8 | 0.3 | 0.62
24 | 0.7 | 0.2 | 0.58
25 | 0.6 | 0.1 | 0.55
26 | 0.5 | 0 | 0.5
27 | 0.4 | -0.1 | 0.44
28 | 0.3 | -0.2 | 0.38
29 | 0.2 | -0.3 | 0.29
30 | 0.1 | -0.4 | 0.17
31 | 0 | -0.5 | 0
32 | -0.1 | -0.4 | -0.06
33 | -0.2 | -0.3 | -0.14
34 | -0.3 | -0.2 | -0.24
35 | -0.4 | -0.1 | -0.36
36 | -0.5 | 0 | -0.5
37 | -0.6 | 0.1 | -0.66
38 | -0.7 | 0.2 | -0.84
39 | -0.8 | 0.3 | -1.04
40 | -0.9 | 0.4 | -1.26
41 | -1 | 0.5 | -1.5
42 | -1.1 | 0.6 | -1.76
43 | -1.2 | 0.7 | -2.04
44 | -1.3 | 0.8 | -2.34
45 | -1.4 | 0.9 | -2.66
46 | -1.5 | 1 | -3
47 | -1.6 | 0.9 | -3.04
48 | -1.7 | 0.8 | -3.06
49 | -1.8 | 0.7 | -3.06
50 | -1.9 | 0.6 | -3.04
51 | -2 | 0.5 | -3
52 | -2.1 | 0.4 | -2.94
53 | -2.2 | 0.3 | -2.86
54 | -2.3 | 0.2 | -2.76
55 | -2.4 | 0.1 | -2.64
56 | -2.5 | 0 | -2.5
57 | -2.6 | -0.1 | -2.34
58 | -2.7 | -0.2 | -2.16
59 | -2.8 | -0.3 | -1.96
60 | -2.9 | -0.4 | -1.74
61 | -3 | -0.5 | -1.5
Spreadsheet: 819704d1677658612-calculate-next-start-date-with-weekends-and-partial-days-dig-schedule-sample-2-ans
Sheet: Sheet1

Gate # | Est TPA | Acres | [NAME] | Days2dig | [NAME] | Dig Start Day | Correct Start |  | FORMULA
Field 1 | 30 | 32 | 960 | 0.84 | 2023-04-06 00:00:00 | OK | 2023-04-06 00:00:00
Field 2 | 32 | 52 | 1664 | 1.45 |  | OK | 2023-04-06 00:00:00
Field 3 | 33 | 140 | 4620 | 4.04 |  | OK | 2023-04-08 00:00:00
Field 4 | 36 | 88 | 3168 | 2.77 |  | OK
Field 5 | 43 | 70 | 3010 | 2.63 |  | Monday
Field 6 | 40 | 34 | 1360 | 1.19 |  | OK
Field 7 | 40 | 35 | 1400 | 1.22 |  | OK
Field 8 | 42 | 42 | 1764 | 1.54 |  | OK
Field 9 | 40 | 70 | 2800 | 2.45 |  | OK
Field 10 | 40 | 68 | 2720 | 2.38 |  | OK
Field 11 | 40 | 129 | 5160 | 4.51 |  | OK
Field 12 | 45 | 120 | 5400 | 4.72 |  | Monday
Field 13 | 47 | 118 | 5546 | 4.85 |  | OK
Field 14 | 47 | 110 | 5170 | 4.52 |  | OK
Field 15 | 47 | 128 | 6016 | 5.26 |  | OK
Field 16 | 60 | 144 | 8640 | 7.55 |  | OK
Field 17 | 65 | 140 | 9100 | 7.95 |  | OK
Field 18 | 55 | 106 | 5830 | 5.1 |  | OK
Field 19 | 65 | 140 | 9100 | 7.95 |  | OK
Field 20 | 70 | 66 | 4620 | 4.04 |  | OK
Field 21 | 70 | 68 | 4760 | 4.16 |  | OK
DAILY QUOTA TONS= | 1144
DAILY QUOTA LOADS= | 44
DAYS OFF= MONDAY/TUESDAY
Spreadsheet: 267384d1380059810-need-a-function-s-to-search-data-with-two-criteria-data-example-jacc
Sheet: Sheet1

[NAME] | Pipe Length
1 | 2
1 | 4 |  |  |  | A Known Pipe Size |  | Length must be the next one larger than this |  |  |  |  | Length Necessary:
1 | 6 |  |  |  | 1 |  | 4.3
1 | 8 |  |  |  | 2 |  | 2.3
1 | 10 |  |  |  | 2 |  | 3.7
2 | 1 |  |  |  | 3 |  | 4.9
2 | 3 |  |  |  | 3 |  | 7.2
2 | 4 |  |  |  | 3 |  | 7.2
2 | 5 |  |  |  | 3 |  | 8.8
3 | 7 |  |  |  | 4 |  | 0.34
3 | 8 |  |  |  | 4 |  | 0.53
3 | 9 |  |  |  | 4 |  | 1.7
3 | 10
4 | 0.5
4 | 1
4 | 1.5
4 | 2
4 | 5 |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/957315-need-a-function-s-to-search-data-with-two-criteria.html
5 | etc
5 | etc
5 | etc
5 | etc |  |  |  | Column A is a standard list of pipe sizes, with Column B reflecting an available length said pipe is availble in.
6 | etc
6 | etc
6 | etc |  |  |  | For a Known Pipe Size, (Column F), and a Minimum Length (Column H), I need to determine the shortest available length for the given pipe size.
6 | etc
6 | etc
Spreadsheet: 848802d1699445441-given-a-daily-schedule-output-percentage-doing-a-type-of-task-schedule-metrics-ans
Sheet: Sheet1

 |  |  |  |  | Daily Employee Schedule |  |  |  |  |  |  |  |  |  |  | Categories
 |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 |  | Commuting |  | Working
 |  |  |  | Me | biking | biking | typing | typing | printing | printing | driving | driving | printing | printing |  | biking |  | typing
 |  |  |  | you | swimming | swimming | swimming | swimming | writing | swimming | swimming | swimming | swimming | writing |  | swimming |  | printing
 |  |  |  | her | driving | driving | driving | driving | driving | swimming | swimming | swimming | swimming | swimming |  | driving
 |  |  |  | him | biking | biking | biking | printing | printing | biking | biking | biking | printing | printing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra space in Q6 is removed
 |  |  |  |  | Ideal Results |  |  |  |  |  |  |  |  |  |  | "writing" is not included in catagories
 |  |  |  | % commuting | 1 | 1 | 0.75 | 0.5 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.25
 |  |  |  | % working | 0 | 0 | 0.25 | 0.5 | 0.25 | 0.25 | 0 | 0 | 0.5 | 0.75
 |  |  |  | % commuting
 |  |  |  | % working
Spreadsheet: 704189d1605421824-2-fields-checker-request-for-alternative-option-in-power-query-or-power-pivot-test
Sheet: Master Data

Agent | HGH | Revenue | Helper Column | 1BS & 1S Checker
Agent1 | 1B | 119
Agent1 | 1W | 254 |  |  |  | Looking for agents only handles 1B & 1S (HGH column)
Agent10 | 1S | 179 |  |  |  | As the data is huge around 350K rows and 10 columns, it takes a lot of time to run the file.
Agent10 | 1B | 148 |  |  |  | Avoid using helper column and please suggest an option in power query or power pivot,
Agent100 | 1W | 157
Agent100 | 1S | 117
Agent101 | 1K | 206 |  |  |  |  |  |  |  | 327
Agent101 | 1X | 123 |  |  |  | Agent106 | 129 |  | Agent106 | 129
Agent102 | 1S | 289 |  |  |  | Agent109 | 137 |  | Agent109 | 137
Agent102 | 1W | 289 |  |  |  | Agent111 | 445 |  | Agent111 | 445
Agent111 | 1B | 232 |  |  |  | Agent199 | 153 |  | Agent199 | 153
Agent103 | 1e | 204
Agent104 | 1V | 124
Agent104 | 1V | 283
Agent105 | 1T | 258
Agent105 | 1U | 265
Agent106 | 1S | 129
Agent111 | 1b | 213
Agent107 | 1W | 162
Agent107 | 1N | 189
Agent108 | 1I | 119
Agent108 | 1T | 192
Agent109 | 1B | 137
Agent199 | 1S | 153
Agent700 | 1S | 162
Agent700 | QQ | 189
Agent700 | 1S | 119
Spreadsheet: 670369d1585843982-extracting-data-match-3-
Sheet: Sheet1

 |  |  | Data 1 | Result |  |  |  | Data 2
 |  |  | 8 |  |  |  | ADF | A75/7 | 1000
 |  |  | 2 |  |  |  |  | A75/10 | 634
 |  |  | 3 |  |  |  | RAM | A75/8 | 653
 |  |  | 10 |  |  |  | ABC | A75/7 | 2000
 |  |  | 7 |  | MULTIPLE |  | SHYAM | A75/461 | 653
 |  |  | 461 |  |  |  | [NAME] | A75/360 | 65
 |  |  | 256 |  |  |  |  | A75/12 | 46
 |  |  | 360 |  | [NAME] |  | [NAME] | A75/360 | 35
Spreadsheet: 77425d1277905968-duplicates-based-on-multiple-columns-dummy-file
Sheet: Banana

[NAME]
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Ridgid

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
R9601 | RGD-AMB-R9601 |  | 179 | 135 | 260 |  |  |  | X
 | RGD-DRL-R86008 | 1 |  | 34 | 54 |  |  |  | X
 | RGD-IMP-R86034 | 1 |  | 35 | 54 |  |  |  | X
 | RGD-RAD-R84084 | 1 |  | 28 | 40 |  |  |  | X
 | RGD-CHG-R86091 | 1 |  | 33 | 40 |  |  |  | X
 | RGD-BAT-R840085 | 2 |  | 108 | 120 |  |  |  | X
 | RGD-TOT-R9601 | 1 |  | 0 | 0
R86008K | RGD-AMB-R86008K |  | 153 | 80 | 130
 | RGD-HDR-R86008 | 1 |  | 36 | 58
 | RGD-BAT-R840085 | 2 |  | 98 | 118 | 132
 | RGD-CHG-R840093 | 1 |  | 32 | 45
 | - | 1 |  | 0 | 0
R86034K | RGD-AMB-R86034K |  | 144 | 100 | 124
 | RGD-BAT-R840085 | 1 |  | 98 | 118
 | RGD-CHG-R840093 | 1 |  | 32 | 45
 | RGD-IMP-R86034 | 1 |  | 42 | 62
 | - | 1 |  | 0 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: 715687d1611835315-issues-with-sumifs-sum-with-criteria
Sheet: Sheet1

CalendarWeek | Year | Value
1 | 2020 | 18695.92 |  |  | CRITERIA
2 | 2020 | 25778.31 |  |  | CW
3 | 2020 | 10174.06 |  |  | YEAR
4 | 2020 | 13163.79
5 | 2020 | 13402.45
6 | 2020 | 17256.78 |  |  | SUM
7 | 2020 | 15241.13
8 | 2020 | 23650.76
9 | 2020 | 7774.820000000001
10 | 2020 | 12469.86
11 | 2020 | 15347.92
12 | 2020 | 10576.4
13 | 2020 | 14839.47
14 | 2020 | 20338.5
15 | 2020 | 20647.78
16 | 2020 | 7136.88
17 | 2020 | 20551.89
18 | 2020 | 8803.33
19 | 2020 | 16665
20 | 2020 | 9539.5
21 | 2020 | 26539.34
22 | 2020 | 30439.33
23 | 2020 | 31021.46
24 | 2020 | 11590.66
25 | 2020 | 17167.82
26 | 2020 | 14020.98
27 | 2020 | 34754.38
28 | 2020 | 19736.92
29 | 2020 | 19069.58
30 | 2020 | 9606.36
31 | 2020 | 26037.5
32 | 2020 | 30417.69
33 | 2020 | 19399.86
34 | 2020 | 12063.99
35 | 2020 | 23507.9
36 | 2020 | 24940.7
37 | 2020 | 16071.47
38 | 2020 | 24550.17
39 | 2020 | 17508.69
40 | 2020 | 18167.2
41 | 2020 | 7369.59
42 | 2020 | 13055.22
43 | 2020 | 16689.03
44 | 2020 | 11733.18
45 | 2020 | 18712.8
46 | 2020 | 14536.38
47 | 2020 | 14229.84
48 | 2020 | 14075.66
49 | 2020 | 32626.99
50 | 2020 | 34174.36
51 | 2020 | 11078.88
52 | 2020 | 21485.36
2 | 2021 | 9374.880000000001
3 | 2021 | 10807.27
4 | 2021 | 19113.33
5 | 2021 | 9645.42
Spreadsheet: 782693d1654186138-when-i-put-an-id-on-a-cell-it-will-return-me-the-value-in-another-cell-book1
Sheet: Sheet2

 |  |  |  | lookup | Unique ID
 |  |  |  | column to bring | Values
 |  |  | Values |  | sign | input | key | adjustment | adjustment
 | Taxes |  |  |  | 1 |  | A11300_QA100_
 | Income |  |  |  | -1 |  | A11320_QA100_io=n-0202
 | Expenses |  |  |  | 1
 | Investment |  |  |  | -1
Spreadsheet: 744069d1628905446-countifs-with-index-match-test3
Sheet: Data

PROGRAM_TYPE | Customer Name | Date | Quantity
Promo | A | 2020-06-06 00:00:00 | 5
Promo | B | 2020-06-20 00:00:00
Promo | BB | 2020-06-13 00:00:00 | 0
Promo | jj | 2020-06-06 00:00:00 | 66
Promo | sdks | 2020-06-20 00:00:00 | 4
Promo | 2 ksk | 2020-06-06 00:00:00
Promo B | A | 2020-06-20 00:00:00 | 4
Promo B | B | 2020-06-13 00:00:00 | 7
Promo B | BB | 2020-06-06 00:00:00
Promo B | k | 2020-06-13 00:00:00 | 9
Promo Y | 2 ksk | 2020-06-06 00:00:00 | 0
Promo Y | A | 2020-06-20 00:00:00 | 4
Promo Y | B | 2020-06-20 00:00:00 | 888
Spreadsheet: 882624d1730996878-input-1-to-maybe-7-sku-numbers-to-return-groups-of-rows-robodan79-find-groups-with-components-spill-365-aligw-rev-2
Sheet: Sheet1

Case SKU | Material description | Component | Material description | Ratio |  | Component
9800001245 | ASTMNTS CRL SHPR X48 | [PHONE] | ASTMNTS CRL 8.56OZX12 | 48 |  | 9800006353
123456789 | ASTMNTS 240CT | 9800006353 | Red | 80 |  | 9800006357
 |  | 9800006357 | Blue | 80
 |  | 9800006356 | Yellow | 40
 |  | 9800008635 | Green | 40
9800033873 | ASTMNTS X276 | 9800015503 | Purple | 276
9800056677 | ASTMNTS X216 | 9800030528 | teal | 216
9800028774 | ASTMNTS X288 | 9800015535 | orange | 288
9800078993 | ASTMNTS X36 | 9800019446 | beige | 36
9800063993 | ASTMNTS  X144 | 9800023584 | white | 144
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
 |  | 9800006357 | Blue | 320
 |  | 9800006356 | Yellow | 160
 |  | 9800008635 | Green | 160
986271658 | ASTMNTS X33 | 9862540320 | crunch | 15
 |  | 9862775537 | space | 18
9862710566 | ASTMNTS X36 | 9864121325 | nature | 18
 |  | 9862710138 | butter | 18
9862781065 | ASTMNTS RX33 | 9867770325 | grass | 18
 |  | 9801126984 | fiber | 32
9800028932 | ASTMNTS X156 | 9804423144 | flake | 72
 |  | 9804427010 | giant | 84
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
 |  | 9800006357 | Blue | 40
 |  | 9800006356 | Yellow | 20
 |  | 9800008635 | Green | 20
9800024446 | ASTMNTS X36 | 9805523856 | snack | 18
 |  | 9800445403 | snacks | 18
 | ASTMNTS 240CT | 9800006353 | Red | 80
123456789 | ASTMNTS 240CT | 9800006357 | Blue | 80
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
987654321 | ASTMNTS 960ct | 9800006357 | Blue | 320
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
654321987 | ASTMNTS CRL 120CT | 9800006357 | Blue | 40
Mocked up results below
123456789 | ASTMNTS 240CT | 9800006353 | Red | 80
 |  | 9800006357 | Blue | 80
 |  | 9800006356 | Yellow | 40
 |  | 9800008635 | Green | 40
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
 |  | 9800006357 | Blue | 320
 |  | 9800006356 | Yellow | 160
 |  | 9800008635 | Green | 160
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
654321987 |  | 9800006357 | Blue | 40
654321987 |  | 9800006356 | Yellow | 20
654321987 |  | 9800008635 | Green | 20
Spreadsheet: 39543d1237823665-excel-graphing-676896
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 16$KGA | 24$KGA
 |  |  |  |  |  |  |  |  | FY10 | 2000 | 400
 |  |  |  |  |  |  |  |  | FY11
 |  |  |  |  |  |  |  |  | FY12
 |  |  |  |  |  |  |  |  | FY13 | 1333.333333333333 | 2000
 |  |  |  |  |  |  |  |  |  | 16 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Primary | Secondary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YMIN | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YMAX | 2500 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Factor = | 0.012
Spreadsheet: 146951d1332435880-if-vlookup-test-spreadsheet
Sheet: Summary

Site Number | Investigator Name | Subject Number | Baseline Date | WEEK 36 Expected Visit Date | WEEK 36 Actual Visit Date | END OF TREATMENT Expected Visit Date | END OF TREATMENT Actual Visit Date | FOLLOW UP Expected Visit Date | FOLLOW UP Actual Visit Date
9999 | Test Site | 9999753001 | 2011-01-15 00:00:00 | 2011-09-24 00:00:00 |  | 2011-12-17 00:00:00 |  | 2012-01-14 00:00:00
9999 | Test Site | 9999753002 | 2011-02-01 00:00:00 | 2011-10-11 00:00:00 |  | 2012-01-03 00:00:00 | 2011-06-15 00:00:00 | 2012-01-31 00:00:00
9999 | Test Site | 9999753003 | 2011-03-15 00:00:00 | 2011-11-22 00:00:00 |  | 2012-02-14 00:00:00 |  | 2012-03-13 00:00:00