tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805701d1668848427-how-to-get-earliest-and-latest-date-from-column-based-on-test-earliest-and-latest-date
Sheet: Sheet1

Test | Dates | Number of days to complete Test | How can I get the earliest and latest dates of each Test and get the number of days it took to complete?
A | 2022-01-01 00:00:00 | 3
A | 2022-01-02 00:00:00 | 3
A | 2022-01-03 00:00:00 | 3
B | 2022-01-04 00:00:00 | 4
B | 2022-01-05 00:00:00 | 4
B | 2022-01-06 00:00:00 | 4
B | 2022-01-07 00:00:00 | 4
C | 2022-05-01 00:00:00 | 6
C | 2022-05-02 00:00:00 | 6
C | 2022-05-03 00:00:00 | 6
C | 2022-05-04 00:00:00 | 6
C | 2022-05-05 00:00:00 | 6
C | 2022-05-06 00:00:00 | 6
D | 2022-06-03 00:00:00 | 8
D | 2022-06-04 00:00:00 | 8
D | 2022-06-05 00:00:00 | 8
D | 2022-06-06 00:00:00 | 8
D | 2022-06-07 00:00:00 | 8
D | 2022-06-08 00:00:00 | 8
D | 2022-06-09 00:00:00 | 8
D | 2022-06-10 00:00:00 | 8
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1004

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: 220763d1363260351-calculations-with-text-calculation
Sheet: Sheet1

ADHERED PROCESS
-
- |  |  |  | YES
- |  |  |  | NO
- |  |  |  | -
-
-
-
-
-
-
-
-
-
-
-
-
-
NO
-
-
Spreadsheet: 736431d1623635001-evaluating-a-specified-array-for-2-or-more-criteria-and-returning-a-value-example-data-1-ans
Sheet: Sheet1

Svc_Date | Clinic ID | Patient ID | Provider ID | Procedure Code ID | Procedure Category ID | Test |  |  | Office Visit | [NAME] | Svc_Date | Clinic ID | Patient ID | Provider ID | Procedure Code ID | Procedure Category ID |  | Office Visit | Svc_Date | Clinic ID | Patient ID | Provider ID | Procedure Code ID | Procedure Category ID |  | [NAME] | Svc_Date | Clinic ID | Patient ID | Provider ID | Procedure Code ID | Procedure Category ID
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 26 | Non-Covid
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 27 | Non-Covid
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 28 | Non-Covid
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 02 | Office Visit
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 02 | Office Visit
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 29 | [NAME]
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 09 | [NAME]
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 30 | Office Visit
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 31 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 02 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 07 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 32 | Office Visit
2021-04-04 00:00:00 | Denver | 5545 | [NAME] | 49 | [NAME]
2021-04-04 00:00:00 | Denver | 5545 | [NAME] | 50 | Office Visit
2021-04-05 00:00:00 | Denver | 1234 | [NAME] | 40 | [NAME]
 |  |  |  |  | From my original table, I would need a new column that looks at the table itself and evaluates for an array of "Same Patient Visits", and making the determinations, "Office Visit Only", "Covid Test Visit", and "[NAME]".
 |  |  |  |  | I'm going to try to reframe the formulas you provided to fit that need, but would appreciate a solution in the meantime, if you arrive at one!
 |  |  |  |  | Evaluating a specified array for 2 (or more) criteria and returning a value
 |  |  |  |  | So, I feel like this is a bit different from your typical INDEX/MATCH array function, but maybe not.
 |  |  |  |  | Essentially, the data shows 4 Procedure Categories:
 |  |  |  |  | - Office Visit
 |  |  |  |  | - Covid Test
 |  |  |  |  | - Covid Vaccine
 |  |  |  |  | - Not Specified
 |  |  |  |  | A patient can have Office Visit with no Covid Test, or an Office Visit with [NAME]. The "Not Specified" category is negligible, but I'd still like to show it.
 |  |  |  |  | The request is to show patients with a combination of "Office Visit" and "Covid Test" by having the 2 occur in the same visit. Here is my sample data attached.
 |  |  |  |  | Ideally, I'd like to separate Office Visits Only, [NAME] Only, and Office Visits with a Covid Test. Any help is appreciated!
Spreadsheet: 231772d1367223286-how-to-sort-information-based-on-date-in-a-header-row-excel-schedule
Sheet: Dec

 |  |  |  | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4
 | 2013-01-01 00:00:00 |  | D | e | c | e | m | b | e | r
No. | Activity | Start Date | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-04 00:00:00 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | 2010-12-15 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00 | 2010-12-19 00:00:00 | 2010-12-20 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2010-12-23 00:00:00 | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00
 |  | [NAME] | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-04 00:00:00 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | 2010-12-15 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00 | 2010-12-19 00:00:00 | 2010-12-20 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2010-12-23 00:00:00 | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00
1
2
2.1
2.2
2.3
2.4
2.5
3
3.1
3.2
4
4.1
4.2
4.3
5
5.1
5.2
5.3
6
6.1
6.2
6.3
6.4
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
8.3
8.4
8.5
8.6
Spreadsheet: 333d7f91-4ce1-4fd6-b4e1-4217aca94d0e
Sheet: Exhibit A - Transition

Section L - Attachment 7 - Price Schedule
DE-SOL-0003816
Transition (up to 30-days), To be determined
Total Contract
 | DPLH |  |  | Labor |  |  | Direct Labor Costs |  |  | Fringe Benefits |  |  | [NAME] |  |  | Onsite Overhead |  |  | Onsite | Total Costs
Cost Element |  |  |  | Straight | Over | Double | Straight | Over | Double |  |  |  |  |  |  |  |  |  | Overhead
 | Straight | Over | Double | Time | Time | Time | Time | Time | Time | Straight | Over | Double | Straight | Over | Double | Straight | Over | Double |  | Straight | Over | Double | Total
Cost Plus Fixed Fee (CPFF) Tasks
***Prime Contractor Labor
Bargaining Employee:
Mechanic Foreman |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mechanic Foreman
Mobile Crane Inspector
Crew Foreman (Operator)
Laborer
Heavy Equipment Operator
Truck Driver
(Itemize each additional position)
Non-Bargaining Employees:
Program Manager
Operations & Maintenance Manager
Administrative Support
Shop Manager
Supply Technician
Construction Technician
(Itemize each additional position)
Subtotal (Provide Subtotals for Each) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontractor Labor (If Applicable)
(Itemize for Each Position)
Subtotal (Provide Subtotals for Each) | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal  Labor Related Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Other Direct Costs:
Material
Construction
Subtotal Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
G&A (Identify G&A Rate)
Total Proposed Costs
Total Proposal | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
No fee applicable in the transition phase
Spreadsheet: 674678d1587987456-formula-error-in-if-statement-function-sales
Sheet: Store Sales

Lookup Table 1 |  |  | Order ID | Order Date | Order Priority | Order Quantity | Order Type | [NAME] | Sales | Discount
Order Quantity | Type |  | 51648 | 2012-01-01 00:00:00 | Low | 45 |  |  | 2354.8 | =IF(H2=''Large'',''0'',''1'')
1 | Mini |  | 51648 | 2012-01-01 00:00:00 | Low | 50 |  |  | 187.88
6 | Extra Small |  | 29030 | 2012-01-02 00:00:00 | Medium | 10 |  |  | 192.58
11 | Small |  | 54214 | 2012-01-02 00:00:00 | Medium | 38 |  |  | 7325.63
16 | Small-Medium |  | 47591 | 2012-01-02 00:00:00 | Critical | 27 |  |  | 279.4
21 | Medium |  | 43494 | 2012-01-03 00:00:00 | Medium | 2 |  |  | 3668.28
26 | Medium-Large |  | 10945 | 2012-01-03 00:00:00 | Medium | 14 |  |  | 1170.025
31 | Large |  | 35811 | 2012-01-03 00:00:00 | Critical | 6 |  |  | 10.39
36 | Extra Large |  | 16164 | 2012-01-03 00:00:00 | Low | 26 |  |  | 2354.15
41 | XX Large |  | 16164 | 2012-01-03 00:00:00 | Low | 26 |  |  | 69.38
46 | XXX Large |  | 50471 | 2012-01-03 00:00:00 | Low | 25 |  |  | 5859.25
 |  |  | 35811 | 2012-01-03 00:00:00 | Critical | 49 |  |  | 741.57
 |  |  | 16164 | 2012-01-03 00:00:00 | Low | 22 |  |  | 3353.54
 |  |  | 31555 | 2012-01-04 00:00:00 | Critical | 5 |  |  | 500.5
 |  |  | 55011 | 2012-01-04 00:00:00 | Critical | 48 |  |  | 452.28
 |  |  | 7107 | 2012-01-04 00:00:00 | Not Specified | 3 |  |  | 172.04
 |  |  | 44646 | 2012-01-04 00:00:00 | Low | 47 |  |  | 12723.95
 |  |  | 7107 | 2012-01-04 00:00:00 | Not Specified | 3 |  |  | 113.14
 |  |  | 31555 | 2012-01-04 00:00:00 | Critical | 38 |  |  | 3531.75
 |  |  | 39619 | 2012-01-04 00:00:00 | Low | 15 |  |  | 742.8
 |  |  | 55011 | 2012-01-04 00:00:00 | Critical | 18 |  |  | 55.82
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, February 15 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 6082a5b3-5231-4174-978e-6042113efb67
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Deutsche Post DHL - Interim Report H1 2010
January to June 2010
Basic earnings per share
 |  | H1 2009 | H1 2010
Consolidated net profit attributable to Deutsche Post AG shareholders | €m | 1010 | 1828
Weighted average number of shares outstanding | shares | 1209015874 | 1208887575
Basic earnings per share | € | 0.84 | 1.51
of which from continuing operations | € | 0.48 | 1.51
of which from discontinued operations | € | 0.36 | 0
Spreadsheet: larry_campbell__21327__AMP_COST_WORKSHEET
Sheet: Fuel Costs

[NAME] of Fuel Costs
 |  |  | Plant Running at the Upper Limit of Segment 1 |  | Plant Running at the Upper Limit of Segment 2 |  | Plant Running at the Upper Limit of Segment 3 |  | Plant Running at the Upper Limit of Segment 4 |  | Plant Running at the Upper Limit of Segment 5 |  | Plant Running at the Upper Limit of Segment 6
[NAME] | Description |  | Weighted average Cost $/MMBTU |  | Weighted average Cost $/MMBTU |  | Weighted average Cost $/MMBTU |  | Weighted average Cost $/MMBTU |  | Weighted average Cost $/MMBTU |  | Weighted average Cost $/MMBTU
Primary | Fuel 1
Secondary | Fuel 2
Other | Fuel 3
Combination | Fuel 4
Primary Fuel
 | Source |  | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting %
1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weighted Average Cost
Secondary Fuel
 | Source |  | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting %
1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weighted Average Cost
Other Fuel
 | Source |  | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting %
1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weighted Average Cost
Combination Fuel
 | Source |  | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting % | Cost $/MMBTU | Weighting %
1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weighted Average Cost
Spreadsheet: 00803b7c-161b-46d7-ab03-8fef700eac61
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  |  |  | Pre-Control
 | Average 2006 - 2008 |  |  |  |  | Uncontrolled |  |  | 2001 | 2002 | 2003 | 2004
Rawhide Unit 101 | 2006 | 2007 | 2008 | Average | (lb/MMBtu) | (tons/year) | (lb/MMBtu)
 | (tons/yr) |  |  |  |  |  |  | NOx (lb/MMBtu) | 0.33 | 0.33 | 0.34 | 0.32
NOx | 1990.197999999998 | 1863.272 | 1744.648 | 1866.039333333333 | 0.1661833013435702 | 4264.35 | 0.33 |  | 4298.3 | 4007 | 4477.7 | 4274.4 | from CAMD
SO2 | 942.7549999999999 | 927.5230000000005 | 869.445999999999 | 913.241333333333 | 0.08135898315700947 | 965.2 |  |  | 953.4 | 898.2 | 996.9 | 1012.3 | from CAMD
PM | 118 | 123 | 109 | 116.6666666666667 | 0.023 | 116666.6666666666 | 189.9528509887723 | from APENs
PM10 | 109 | 113 | 101 | 107.6666666666667 | 0.023 | 21533.33333333331 | 35.05986906821339 | from APENs
Used data from CAMD query for Unit 101
[NAME] (MMBtu/year) | 2006 | 2007 | 2008 | Average
Rawhide Unit 101 | 1241051 | 1296252 | 1147822 | 1228375
Rawhide Unit 101
Uncontrolled AP-42 Emission Factors | NOx | SO2 | PM | PM10
 | (lb/ton) | (lb/ton) | (lb/ton) | (lb/ton)
 | 7.2 | 8.516666666666666 | 54.23333333333333 | 12.47366666666666 | PC, dry bottom, tangentially fired, sub-bituminous, NSPS
convert to lb/MMBtu | 0.4066571277957678 | 0.4810226673695308 | 3.063107161683862 | 0.7045146471872881
Controlled (%) | --- | 0.8308624755629075 | 0.9924912845728334 | 0.9673534111862323 | based on [NAME]
Controlled based on CAMD lb/MMBtu (%) | 0.4964142383528175
Controlled based on CAMD tons/yr (%) | 0.5624094332469585 | 0.05383202099737572
 |  | SO2 FGD upgrade | installed upon installation in 1984
 | 2006 | 2007 | 2008 | AVG
SO2 (lb/MMBtu) | 0.07778626292688068 | 0.08051604455838732 | 0.0861622305924227 | 0.08148817935923024
Nox (lb/MMBtu) | 0.1632760563380279 | 0.1624916666666667 | 0.1734036697247704 | 0.166390464243155
PM10 (lb/MMBtu) | 0.01756575676583799 | 0.01743488148909317 | 0.01759854750997977 | 0.01753306192163698
Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: Cashflow

 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Opening Balance | 100000
Income |  | 100000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 100000
Cost Of Sales | 0.8 | 187500
Fixed Expenses | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000
Closing Balance
Variables
Tax | 0.1
WIPAA | Use Calculator | 50000 | -100000 | -150000 | -250000 | -375000 | -375000 | -375000 | -375000 | -375000 | -375000 | -375000 | -150000
Forecast
Spreadsheet: 735050d1622666429-compare-lists-display-items-without-a-match-example
Sheet: From-Catalog

SPCO | PRTREF | CATREF | DETREF | RTEX OF DETR | MATX | XTEX OF MTXR
VALVE-20 | PART-1 | CATREF-1 | DETREF-1 | DESC-1 | MAT-1 | MAT-DESC-1
TEE-5 | PART-2 | CATREF-2 | DETREF-2 | DESC-2 | MAT-2 | MAT-DESC-2
ELBOW-3 | PART-3 | CATREF-3 | DETREF-3 | DESC-3 | MAT-3 | MAT-DESC-3
ELBOW-4 | PART-4 | CATREF-4 | DETREF-4 | DESC-4 | MAT-4 | MAT-DESC-4
ELBOW-5 | PART-5 | CATREF-5 | [NAME] | [NAME] | MAT-5 | MAT-DESC-5
VALVE-1 | PART-6 | CATREF-6 | DETREF-6 | DESC-6 | MAT-6 | MAT-DESC-6
VALVE-2 | PART-7 | CATREF-7 | DETREF-7 | DESC-7 | MAT-7 | MAT-DESC-7
VALVE-3 | PART-8 | CATREF-8 | [NAME] | DESC-8 | MAT-8 | MAT-DESC-8
VALVE-4 | PART-9 | CATREF-9 | DETREF-9 | DESC-9 | MAT-9 | MAT-DESC-9
VALVE-5 | PART-10 | CATREF-10 | DETREF-10 | DESC-10 | MAT-10 | MAT-DESC-10
VALVE-6 | PART-11 | CATREF-11 | DETREF-11 | DESC-11 | MAT-11 | MAT-DESC-11
VALVE-7 | PART-12 | CATREF-12 | DETREF-12 | DESC-12 | MAT-12 | MAT-DESC-12
VALVE-8 | PART-13 | CATREF-13 | DETREF-13 | DESC-13 | MAT-13 | MAT-DESC-13
TEE-6 | PART-14 | CATREF-14 | DETREF-14 | DESC-14 | MAT-14 | MAT-DESC-14
TEE-7 | PART-15 | CATREF-15 | DETREF-15 | DESC-15 | MAT-15 | MAT-DESC-15
[NAME] | PART-16 | CATREF-16 | DETREF-16 | [NAME] | MAT-16 | MAT-DESC-16
TEE-9 | PART-17 | CATREF-17 | DETREF-17 | DESC-17 | MAT-17 | MAT-DESC-17
Spreadsheet: 671108d1586263891-find-dates-and-names-from-one-sheet-and-match-with-another-book1
Sheet: Sheet2

Name | Type of Leave | Start Date | End Date
Jo | AL | 2020-01-02 00:00:00 | 2020-01-04 00:00:00
[NAME] | HRA | 2020-01-12 00:00:00 | 2020-01-12 00:00:00
[NAME] | PPL | 2020-01-01 00:00:00 | 2020-01-02 00:00:00
[NAME] | AL | 2020-01-04 00:00:00 | 2020-01-06 00:00:00
Alf | PPL | 2020-01-12 00:00:00 | 2020-01-12 00:00:00
Sandra | AL | 2020-01-09 00:00:00 | 2020-01-11 00:00:00
Jo | HRA | 2020-01-08 00:00:00 | 2020-01-08 00:00:00
[NAME] | SL | 2020-01-15 00:00:00 | 2020-01-16 00:00:00
Alf | AL | 2020-01-14 00:00:00 | 2020-01-15 00:00:00
Spreadsheet: 104583d1302125776-consolidate-duplicate-rows-into-one-cell-test1
Sheet: original

number | first | last | price 1 | price 2 | price 3 | price 4 | TOTAL
100001 | [NAME] | [NAME] | 25
100001 | [NAME] | [NAME] | 50
100001 | [NAME] | [NAME] | 45
100002 | [NAME] | [NAME] | 50
100003 | morgan | dames | 25
100004 | [NAME] | loss | 75
100005 | carol | reeves | 25
100006 | [NAME] | borne | 50
100007 | debra | minke | 15
100007 | debra | minke | 25
100007 | debra | minke | 150
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
Spreadsheet: 757756d1638448753-im-looking-for-help-on-how-link-a-master-sheet-to-populate-another-sheets-in-the-workbook-team-roster
Sheet: FGB

Washington Nationals
Team Owner
Team Salary
[NAME]
Available Salary
Roster
Minor League Players
Name | Salary | Years | Tm | Lg | W | L | W-L% | ERA | G | GS | GF | CG | SHO | SV | IP | H | R | ER | HR | BB | IBB | SO | HBP | BK | WP | BF | ERA+ | FIP | WHIP | BB9 | HR9 | H9 | SO9 | SO/W
Starling Marte
Spreadsheet: 76334d1276846549-countifs-function-sample
Sheet: Sheet1

Outputs |  |  |  |  |  |  |  | Inputs
I want the count for A and AA documents to show in period for their respective division |  |  |  |  |  |  |  | Division | Date | [NAME]
Mo start | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 |  | Marketing | 2010-05-01 00:00:00 | A
Mo end | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 |  | Finance | 2010-01-04 00:00:00 | B
Marketing |  |  |  |  |  |  |  | Comms | 2010-01-16 00:00:00 | A
Finance |  |  |  |  |  |  |  | Finance | 2010-03-06 00:00:00 | A
Comms |  |  |  |  |  |  |  | Comms | 2010-04-03 00:00:00 | AA
Sales |  |  |  |  |  |  |  | Sales | 2010-06-14 00:00:00 | B
 |  |  |  |  |  |  |  | Marketing | 2010-01-15 00:00:00 | A
References |  |  |  |  |  |  |  | Finance | 2010-01-18 00:00:00 | AA
A |  |  |  |  |  |  |  | Comms | 2010-01-01 00:00:00 | AA
AA |  |  |  |  |  |  |  | Finance | 2010-05-31 00:00:00 | A
B |  |  |  |  |  |  |  | Sales | 2010-05-01 00:00:00 | B
C |  |  |  |  |  |  |  | Marketing | 2010-01-04 00:00:00 | C
 |  |  |  |  |  |  |  | Finance | 2010-01-16 00:00:00 | C
 |  |  |  |  |  |  |  | Comms | 2010-03-06 00:00:00 | AA
 |  |  |  |  |  |  |  | Finance | 2010-04-03 00:00:00 | A
 |  |  |  |  |  |  |  | Marketing | 2010-06-14 00:00:00
 |  |  |  |  |  |  |  | Finance | 2010-01-15 00:00:00 | A
 |  |  |  |  |  |  |  | Comms | 2010-01-18 00:00:00 | B
 |  |  |  |  |  |  |  | Finance | 2010-01-01 00:00:00 | C
 |  |  |  |  |  |  |  | Comms | 2010-05-31 00:00:00 | AA
Spreadsheet: 106272d1303432118-lookup-function-that-produces-a-image-hyperlinkvlookup
Sheet: LookupTable

Lookup Value | Return
LOUR1-P | http://iwanllc.com/medium/4_11_11_80.JPG
PE84-P | http://iwanllc.com/medium/4_11_11_13.JPG
INC37-P | http://iwanllc.com/medium/4_11_11_19.JPG
CK83-P | http://iwanllc.com/medium/4_11_11_37.JPG
POLO233-P | http://iwanllc.com/medium/4_11_11_51.JPG
POLO232-P | http://iwanllc.com/medium/4_11_11_56.JPG
CLA40-P | http://iwanllc.com/medium/4_11_11_76.JPG
POLO231-P | http://iwanllc.com/medium/4_11_11_07.JPG
POLO234-P | http://iwanllc.com/medium/4_18_11_0040.JPG
TH54-P | http://iwanllc.com/medium/4_11_11_86.JPG
TB19-P | http://iwanllc.com/medium/4_11_11_46.JPG
TB22-P | http://iwanllc.com/medium/4_18_11_0077.JPG
KC36-P | http://iwanllc.com/medium/4_11_11_91.JPG
KC37-P | http://iwanllc.com/medium/4_11_11_67.JPG
ALF159-P | http://iwanllc.com/medium/4_18_11_0010.JPG
KC38-P | http://iwanllc.com/medium/4_11_11_71.JPG
PE85-P | http://iwanllc.com/medium/4_18_11_0054.JPG
PE86-P | http://iwanllc.com/medium/4_18_11_0019.JPG
PE87-P | http://iwanllc.com/medium/4_18_11_0060.JPG
TB20-P | http://iwanllc.com/medium/4_11_11_32.JPG
TB21-P | http://iwanllc.com/medium/4_18_11_0015.JPG
PE88-P | http://iwanllc.com/medium/4_18_11_0035.JPG
TH55-P | http://iwanllc.com/medium/4_18_11_0001.JPG
ALF160-P | http://iwanllc.com/medium/4_18_11_0025.JPG
ET4-P | http://iwanllc.com/medium/4_11_11_96.JPG
CK84-P | http://iwanllc.com/medium/4_18_11_0005.JPG
CK82-P | http://iwanllc.com/medium/4_11_11_01.JPG
ED188-P | http://iwanllc.com/medium/4_11_11_62.JPG
[NAME] | http://iwanllc.com/medium/4_18_11_0073.JPG