tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 150014 | 149436
2 | 160216 | 158454
3 | 159349 | 165965
4 | 155848 | 155735
5 | 166911 | 168136
6 | 181580 | 183336
7 | 184934 | 184986
8 | 195682 | 194987
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2001-11-30 00:00:00 |  |  | -23010 |  |  |  | 530
2001-12-08 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -10969
Spreadsheet: john_griffith__15721__AK Steel
Sheet: 3.50 put

Nymex Daily Option
 |  |  |  | Nymex | Nymex | Interest |  |  | Option Premium/mmbtu
# of Days |  | Volume |  | Price | Vol | Rate | cof
 | 2001-10-01 00:00:00 | 2330323 | 2001-11-01 00:00:00 | 2.27 | 0.7 | 0.0276 | 0.015
 | 2001-11-01 00:00:00 | 3020000 | 2001-12-01 00:00:00 | 2.6525 | 0.6 | 0.0269 | 0.015 |  | Option Premium dollars
 | 2001-12-01 00:00:00 | 3020000 | 2002-01-01 00:00:00 | 2.865 | 0.57 | 0.0267 | 0.015
 | Total |  | 2002-02-01 00:00:00 | 2.8675 | 0.55
Option | Days to |  |  |  | Put/ | Option | Pmt | Interest | Discount | Daily | Discounted | Discounted
Expire Date | Expire | Strike | Volatility | Fwd Price | Call | Value | Date | Rate | Factor | Volume | Volume | Cash Flows
2001-10-08 00:00:00 |  | 3.5 |  |  | P |  | 2001-11-05 00:00:00
2001-10-09 00:00:00
2001-10-10 00:00:00
2001-10-11 00:00:00
2001-10-12 00:00:00
2001-10-15 00:00:00
2001-10-16 00:00:00
2001-10-17 00:00:00
2001-10-18 00:00:00
2001-10-19 00:00:00
2001-10-22 00:00:00
2001-10-23 00:00:00
2001-10-24 00:00:00
2001-10-25 00:00:00
2001-10-26 00:00:00
2001-10-29 00:00:00
2001-10-30 00:00:00
2001-10-31 00:00:00
2001-11-01 00:00:00 |  |  |  |  |  |  | 2001-12-05 00:00:00
2001-11-02 00:00:00
2001-11-05 00:00:00
2001-11-06 00:00:00
2001-11-07 00:00:00
2001-11-08 00:00:00
2001-11-09 00:00:00
2001-11-12 00:00:00
2001-11-13 00:00:00
2001-11-14 00:00:00
2001-11-15 00:00:00
2001-11-16 00:00:00
2001-11-19 00:00:00
2001-11-20 00:00:00
2001-11-21 00:00:00
2001-11-23 00:00:00
2001-11-26 00:00:00
2001-11-27 00:00:00
2001-11-28 00:00:00
2001-11-29 00:00:00
2001-11-30 00:00:00
2001-12-03 00:00:00 |  |  |  |  |  |  | 2002-01-05 00:00:00
2001-12-04 00:00:00
2001-12-05 00:00:00
2001-12-06 00:00:00
2001-12-07 00:00:00
2001-12-10 00:00:00
2001-12-11 00:00:00
2001-12-12 00:00:00
2001-12-13 00:00:00
2001-12-14 00:00:00
2001-12-17 00:00:00
2001-12-18 00:00:00
2001-12-19 00:00:00
2001-12-20 00:00:00
2001-12-21 00:00:00
2001-12-26 00:00:00
2001-12-27 00:00:00
2001-12-28 00:00:00
2001-12-31 00:00:00
Spreadsheet: 785684d1656542737-index-match-for-multiple-values-in-array-sampledata
Sheet: Desired Report Example

EmplID | Name | Effdt | EffSeq | Status | [NAME] | Position Title | Manager [NAME] | Manager [NAME] |  |  | Notes
10293 |  |  |  |  |  |  |  |  |  |  | Need to pull most current records from Job Data and Position tab.
10293 |  |  |  |  |  |  |  |  |  |  | Only the current records need to be pulled but it can have multiple EffSeq (column D).
10293 |  |  |  |  |  |  |  |  |  |  | Similarly pulling relevant [NAME], Position title and Manager title and Manager name for that record.
10293 |  |  |  |  |  |  |  |  |  |  | Position title (G) and Manager [NAME] (H) also need to be most current record from Position sheet.
11111
11111
11111
11111
11111
12345
12345
12345
12345
12345
12345
12345
12345
12345
28331
28331
28331
28331
29673
29673
29781
29781
29781
29781
29781
29781
29781
29781
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
46385
56209
56209
56209
56209
56209
56209
56209
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
63792
74536
74536
74536
74536
74536
74536
74536
74536
74536
74536
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
76933
78243
78243
78243
78243
78243
78243
78243
78243
84536
84536
84536
84536
84536
84536
84536
84536
94723
94723
94723
94723
94723
94723
94723
98125
98125
98125
98125
98765
98765
98765
98765
98765
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: E2. Admin Charges

Exhibit E2:  Administrative Charges
[NAME]:
Plan Type(s):
Market Segment:
Rate Effective Date:
 | A | B | C |  | D | E
 | Administrative Charge in effect 12 months Prior to Rate Effective Date | Administrative Charge from Most Recently Approved Rate Filing Prior to Rate Effective Date | Proposed Administrative Charge PMPM Rate for Rate Effective Date |  | Proposed Change Compared to Prior 12 months | Proposed Change Compared to Most Recently Approved Filing
Total Administrative Costs PMPM
Administrative Costs as a percent of Average Health Coverage Plan Rate:
Brief explanation of changes to the administrative charge by more than 3.6% for either time period:1
Notes:
1.  The 3.6% is based on the Northeast Medical CPI as of May 2012.  http://www.bls.gov/xg_shells/ro1xg01a.htm
Spreadsheet: e6466c17-3739-4c8c-a3a8-464c27c3799c
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=148
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-20 11:10 PM CDT
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits | 2007-11-28 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2007-11-28 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2007-11-28 00:00:00 | Current
Notes:
Table 2 - United States, Region, Division and State (Unadjusted Data) | 2007-11-28 00:00:00 | Current
Table 3 - Metropolitan Areas (Unadjusted Data)
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-11-28 00:00:00
2007-12-27 00:00:00
2008-01-28 00:00:00
2008-02-27 00:00:00
2008-03-26 00:00:00
2008-04-24 00:00:00
2008-05-27 00:00:00
2008-06-25 00:00:00
2008-07-25 00:00:00
2008-08-26 00:00:00
2008-09-25 00:00:00
2008-10-27 00:00:00
2008-11-26 00:00:00
2008-12-23 00:00:00
2009-01-29 00:00:00
2009-02-26 00:00:00
2009-03-25 00:00:00
2009-04-24 00:00:00
2009-05-27 00:00:00
2009-06-24 00:00:00
2009-07-27 00:00:00
2009-08-26 00:00:00
2009-09-25 00:00:00
2009-10-27 00:00:00
2009-11-25 00:00:00
2009-12-23 00:00:00
2010-01-28 00:00:00
2010-02-25 00:00:00
2010-03-24 00:00:00
2010-04-26 00:00:00
2010-05-26 00:00:00
2010-06-24 00:00:00
2010-07-27 00:00:00
2010-08-25 00:00:00
2010-09-27 00:00:00
2010-10-27 00:00:00
2010-11-24 00:00:00
2010-12-23 00:00:00
2011-01-27 00:00:00
2011-02-25 00:00:00
2011-03-24 00:00:00
2011-04-26 00:00:00
2011-05-25 00:00:00
2011-06-24 00:00:00
2011-07-27 00:00:00
2011-08-24 00:00:00
2011-09-27 00:00:00
2011-10-27 00:00:00
2011-11-28 00:00:00
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
Spreadsheet: 266151d1379512978-index-match-function-trainees-progress-report
Sheet: Performance Card

Agent | [NAME] |  | Total Training Weeks |  |  | Month |  |  |  |  |  |  |  |  |  |  |  |  |  | Activate Score Card
Evaluator |  |  |  |  |  |  |  | INDEX($C$2:$C$5,MATCH(D2&E2,$A$2:$A$5&$B$2:$B$5,0))
Agent ID
Criterion
Assessment |  | Week 1 | Week 2 | Week 3
Knowledge Check 1 |  |  | 98 | 25
Knowledge Check 2 |  | 96 | 80 | 75
Knowledge Check 3 |  | 60 | 50 | 45
Agent Score  Card |  |  | Comments
Attitude: Open to feedback and acts upon it, positively. |  | A | The agent was very attentive
Commitment to training and the job |  | B
Process and Application Knowledge |  | C
Computer Skills |  | D
Conduct or Overall Deportment |  | E
Class Participation |  | A
Attendance and Punctuality |  | B
 | RANK
 |  |  | Knowledge Check 1 |  |  |  |  |  |  | Knowledge Check 2
Agent | Agent ID | Criteria | Week 1 | Grade | Week 2 | Grade2 | Week 3 | Grade3 | Criteria | Week 1 | Grade | Week 2 | Grade2 | Week 3 | Grade3
[NAME] | 10056 | Knowledge Check 1 | 95 |  |  |  |  |  | Knowledge Check 2 |  |  |  |  |  |  | Overall Grade Bar
[NAME] | 12035 |  | 85
Al begalo | 14562 |  | 96
[NAME] | 14582 |  | 93
[NAME] | 19965 |  | 98
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Weather

Weather |  |  | ok
[NAME] |  | Weather | Vice President | 1 | R
[NAME] |  | Weather | Manager |  | R
[NAME] | Manager | Weather | Manager |  | R
[NAME] |  | Weather | Manager | 3
[NAME] |  | Weather | Sr. Spec | 1
 |  |  | TOTAL | 5
Spreadsheet: 185351d1349674355-2-references-to-match-and-return-an-exact-value-example
Sheet: Database

Customer Name |  | Kelly | [NAME] | Siva | Kelly
Place |  | California | Chicago | Tokyo | Tokyo
Hair Cut Long Hair |  | 30 | 20 | 50 | 20
Hair Cut Short Hair |  | 10 | 5 | 8 | 3
Hair Cut Skin Head |  | 20 | 15 | 7 | 4
Perm |  | 30 | 20 | 40 | 30
[NAME] |  | 110 | 100 | 300 | 80
Wash |  | 15 | 10 | 6 | 5
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Pipeline Co CF

 |  |  |  |  | Warning Flags:
Statement of Cash Flows
STATEMENT OF CASH FLOW ($000)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | Cash Flow | 2001PF | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | Adjustments | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
CASH FLOWS FROM OPERATING ACTIVITIES
Net Income |  |  | 91000 | 74000 | 64000 |  | 0
Depreciation and Amortization |  |  | 61000 | 58000 | 65000 |  | 0
Increase in Deferred Income Taxes |  |  | 17000 | 34000 | 87000 | 0 | 0
Other, net |  |  | 1000 | 12000 | -7000 | 0
Other Operating CF 5
Other Operating CF 6
Other Operating CF 7
Other Operating CF 8
Other Operating CF 9
Other Operating CF 10
Changes in Net Working Capital
(Inc.) Dec. in Acct. Rec.
(Inc.) Dec. in Gas Imbalances Receivable
(Inc.) Dec. in Inventory
(Inc.) Dec. in Other Current Assets
Inc. (Dec.) in Acct. Pay.
Inc. (Dec) in Gas Imbalances Payable
Inc. (Dec.) in Other Current Liab.
(Inc.) Dec. in Net Working Capital |  |  | 4000 | 22000 | -35000 | 0 | 0
NET CASH FROM OPERATING ACTIVITIES
CASH FLOWS FROM INVESTING ACTIVITIES
Acquisition of Panhandle |  |  | 0 | -1900000 | 0 | 0 | 0
Capital and Investment Expenditures |  |  |  |  |  |  | 0
Net Increase in Advances Receivable |  |  | -106000 | -17000 | 0 | 0 | 0
Retirements and Other |  |  | 17000 | -1000 | -1000 | 0 | 0
Other Investing CF 5
Other Investing CF 6
Other Investing CF 7
Other Investing CF 8
Other Investing CF 9
Other Investing CF 10
NET CASH FROM INVESTING ACTIVITIES
CASH FLOWS FROM FINANCING ACTIVITIES
Contribution from Parent |  |  | 0 | 1116000 | 0 | 105000 | 0
Proceeds (Retirement) of Senior Notes |  |  | 0 | 785000 | 99000 | -1000 | 0
Net Increase in Note Receivable |  |  | 0 | -85000 | -77000 | -148000 | 310000
Dividends Paid |  |  | 0 | -41000 | -66000 | -66000 | 0
Other Financing CF 5
Other Financing CF 6
Other Financing CF 7
Other Financing CF 8
Other Financing CF 9
Other Financing CF 10
NET CASH FROM FINANCING ACTIVITIES
NET INCREASE (DECREASE) IN CASH
CASH BEGINNING OF PERIOD |  |  | 0
CASH END OF PERIOD
CAPEX AND OTHER INVESTMENT PROJECTIONS ($000'S)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 |  | 2001PF | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
CAPITAL EXPENDITURES |  |  | -85000 | -57000 | -129000
GROWTH RATES
Other Net Income |  |  |  |  |  |  |  |  | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01
Spreadsheet: 772010d1646958492-vlookup-xlookup-idk-pls-help-help
Sheet: Sheet1

Product Title | List of Makes | List of Models | Make if product title (A) contains make in B | Model if product title (A) contains model in C
audi r8 lights | audi | r8
chevy camaro lights | chevy | camaro
audi r8 bumper |  | bumper
chevy camaro bumper
 |  |  |  | r8
 |  |  |  | camaro
 |  |  |  | bumper
 |  |  |  | 0
Spreadsheet: 195297d1353480332-printing-problem-cut-list-sdsds
Sheet: TROUGH ROLLER

 | Customer | Purchase Order # |  | Freight Company | Freight Acct #
 |  |  |  |  |  |  |  |  | INPUT |  |  |  |  |  | Hidden Values
 |  |  |  |  |  |  |  |  | Roller Type |  |  |  |  |  | Shaft Diameter | Shell Material | Shell Diameter | Roller Type | Special features |  | [NAME] | Housing
 |  |  |  |  |  |  |  |  | Inner Circlip Gauge |  |  |  |  |  | 20 mm | Steel | 89 mm | [NAME] | None |  | Steel
 |  |  |  |  |  |  |  |  | Shaft Diameter |  |  |  |  |  | 25 mm | Aluminium | 102 mm | [NAME] GS | Open Ending |  | Aluminium
 |  |  |  |  |  |  |  |  | Machined to (Blank if not): |  |  |  |  |  | 30 [NAME] | Yeloroll | 114 mm | [NAME] | [NAME] Screw |  | Yeloroll
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 40 mm |  | 127 mm | Flat Return | Stainless Steel
 |  |  |  |  |  |  |  |  | Across Flats |  |  |  |  |  | 50 mm |  | 130 mm | V-Return | Suspended
 |  |  |  |  |  |  |  |  | Shell Material |  |  |  |  |  |  |  | 152 mm | Guide Roller | D Shackle
 |  |  |  |  |  |  |  |  | Shell Diameter |  |  |  |  |  |  |  | 178 mm
 |  |  |  |  |  |  |  |  | Special Feature 1
 |  |  |  |  |  |  |  |  | Special Feature 2 |  |  |  |  |  | Shaft Picture
 |  |  |  |  |  |  |  |  | Weight |  |  |  |  |  |  | Standard Shaft | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Machined 1 | 2
 |  |  |  |  |  |  |  |  | Customer |  |  |  |  |  |  | Standard Machined 2 | 3
 |  |  |  |  |  |  |  |  | Freight Company |  |  |  |  |  |  | Standard Suspended | 4
 |  |  |  |  |  |  |  |  | Freight Account # |  |  |  |  |  |  | Weigh Roller Machined Shaft | 5
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 102 Standard Shaft | 6
 |  |  |  |  |  |  |  |  | Job Number |  |  |  |  |  |  | 102 Open Ended | 7
 |  |  |  |  |  |  |  |  | Number Required |  |  |  |  |  |  | Open Ended | 8
 |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  | Weigh Roller Not Machined | 9
 |  |  |  |  |  |  |  |  | Job #
 |  |  |  |  |  |  |  |  | Out of
 | MACHINE DETAILS  - |  |  | Materials needed | Materials used
 | A – Shaft Length |  |  |  |  |  |  |  | Standard Shaft | 1
 | B – Gauge Length |  |  | Flinger |  |  |  |  | Standard Machined 1 | 2
 | C – Inner Circlip Gauge |  |  | Housing |  |  |  |  | Standard Machined 2 | 3
 | D – Shaft Diameter |  |  |  |  |  |  |  | Standard Suspended | 4
 | E – Flat Width |  |  |  |  |  |  |  | Weigh Roller Machined Shaft | 5
 | F – Across Flats |  |  | Bearings |  |  |  |  | 102 Standard Shaft | 6
 | Shell Length |  |  |  |  |  |  |  | 102 Open Ended | 7
 |  |  |  |  |  |  |  |  | Open Ended | 8
 | JOB DETAILS |  |  |  |  |  |  |  | Weigh Roller Not Machined | 9
 | Job Number
 | Part Number
 | Number Required
 | Date Required |  |  | Weight
Spreadsheet: 161957d1339681666-need-a-formula-to-calculate-overtime-work-schedule-and-salary-calculation-extreme
Sheet: CPF Contribution Table

Employee Age | Contribution By Employer | Contribution By Employee | Total Contribution | Credited Into
(years) | (% of wage) | (% of wage) | (% of wage) | Ordinary Account | Special Account | [NAME]
 |  |  |  | (Ratio of Con) | (Ratio of Con) | (Ratio of Con)
35 & below | 16 | 20 | 36 | 0.6667 | 0.1449 | 0.1884
Above | 16 | 20 | 36 | 0.6088 | 0.1739 | 0.2173
35 - 45
Above | 16 | 20 | 36 | 0.5509 | 0.2028 | 0.2463
45 - 50
Above | 14 | 18.5 | 32.5 | 0.4562 | 0.2456 | 0.2982
50 - 55
Above | 10.5 | 13 | 23.5 | 0.575 | 0 | 0.425
55 - 60
Above | 7 | 7.5 | 14.5 | 0.28 | 0 | 0.72
60 - 65
Above 65 | 6.5 | 5 | 11.5 | 0.1 | 0 | 0.9
Spreadsheet: 070b88db-b3f4-4ea3-95f2-25ec757c6dd8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: [NAME] for 2011
Estuary | 2011
Upper Western Shore | 98.858
[NAME] | 92.061
Lower Eastern Shore (Tangier) | 87
[NAME] | 84.3
Lower Bay | 78.5
Choptank River | 77.4
Overall Bay | 76.8
Rappahannock River | 75.7
Upper Eastern Shore | 75.6
Potomac River | 74.2
Mid Bay | 67.7
York River | 67.4
[NAME] | 63.7
Patuxent River | 52.9
Lower Western Shore (MD) | 50.4
Patapsco and Back Rivers | 45.9
Spreadsheet: 808555d1670515609-pair-2-people-based-on-tiered-criteria-example
Sheet: Sheet1

Initials | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5
NA | Y | N | N | Y | N
SA | N | N | N | Y | Y
AB | N | N | N | Y | Y
[NAME] | Y | N | N | Y | Y
ED | N | N | N | Y | Y
TDe | N | N | N | Y | N
RD | Y | N | N | Y | N
[NAME] | N | Y | N | Y | N
TD | N | Y | N | Y | Y
JG | N | N | Y | N | N
NH | N | Y | Y | N | N
GM | Y | N | N | Y | Y
EM | N | N | Y | N | N
RM | N | N | Y | N | N
IN | N | N | Y | N | N
VN | N | N | Y | N | N
SN | N | N | N | Y | N
RP | N | N | N | Y | Y
DP | N | N | N | Y | Y
LP | N | Y | N | Y | Y
PP | N | N | N | Y | Y
ER | Y | N | Y | N | N
DR | Y | Y | N | Y | N
JR | N | N | N | Y | N
TS | Y | N | N | Y | N
JS | N | N | N | Y | Y
BS | Y | N | N | Y | Y
AW | N | N | N | Y | N
CW | N | N | N | Y | Y
WW | N | N | N | Y | N
Spreadsheet: 854365d1704275932-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W4

IDs (Week 4 data (week 13 since letter)) |  |  |  |  |  |  |  |  | IDs (Week 2 data week 15 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date SMS Scheduled | SMS Status | Opted out? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 6729481500 | 2024-07-13 00:00:00 |  |  |  |  |  |  |  | 4296269604 | 2024-07-15 00:00:00
Spreadsheet: 680358d1590979186-reformat-form-responses-client-detail-form-responses
Sheet: Form responses 1

DATA RECEIVED FROM ONLINE FORM [RAW]
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 2 |  | [NAME] | Cooper
DESIRED OUTPUT
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B.
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | Parent
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message |  | Child
[EMAIL] | Ava | Smith | [PHONE] | Text Message |  | Child
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | Parent
[EMAIL] | Scarlet | King | [PHONE] | Text Message |  | Child
[EMAIL] | [NAME] | King | [PHONE] | Text Message |  | Child
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | Parent
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message |  | Child
[EMAIL] | Tyler | Smith | [PHONE] | [NAME] and Text Message |  | Child
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | Parent
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message |  | Child
[EMAIL] | Cooper | Deanes | [PHONE] | Text Message |  | Child
Spreadsheet: 45743d1244558337-urgent-help-needed-for-work-help
Sheet: Drawing Bill of Material

8.9
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 306 | 0 | 306 | 306 | 0
 | 306 | 0 | 306 | 306 | 0 | 0
6.1
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 40 | 0 | 40 | 40 | 0
 | 12 | 0 | 10 | 10 | 2
 | 52 | 0 | 50 | 50 | 2
0.62
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 93 | 0 | 93 | 93 | 0
 | 93 | 0 | 93 | 93 | 0
0.66
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 8 | 0 | 8 | 8 | 0
 | 224 | 0 | 224 | 224 | 0
 | 48 | 0 | 32 | 32 | 16
 | 280 | 0 | 264 | 264 | 16
0.67
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 8 | 0 | 8 | 8 | 0
 | 8 | 0 | 8 | 8 | 0
 | 16 | 0 | 16 | 16 | 0
 | 8 | 0 | 8 | 8 | 0
 | 40 | 0 | 40 | 40 | 0
0.78
 | Qty | [NAME] | RqsQty | TIssQty | Balance
 | 24 | 0 |  | 0 | 24
 | 16 | 0 | 8 | 8 | 8
 | 40 | 0 | 8 | 8 | 32
Spreadsheet: 680038d1590757672-count-number-of-rows-where-the-month-is-the-same-in-col-a-and-the-integer-in-col-c-is-0-callregister
Sheet: Stats

Call Register Stats:
GAVA rep on duty |  | Type of the call |  | Gender |  | Age group |  | Product
Gerencsér Gábor |  | Warranty issue |  | female |  | under 30 |  | Folder
[NAME] |  | Product feedback |  | male |  | 30-50 |  | Cross/trekking
[NAME] |  | Sales feedback |  |  |  | over 50 |  | Electric
 |  | Technical question |  |  |  | not sure |  | Road
 |  | Financing question |  |  |  |  |  | MTB
 |  | Appointment req. |  |  |  |  |  | multiple
 |  | Promotion
 |  | Other
 |  | No-call day
I need help here below: The formulas in B14:Q14 should count the items in the tab CallRegister that have the date (in col.A) within the month of the corresponding cell above AND the "Duration" (col.C) is not nill or not empty:
 | 2020-03-01 00:00:00
Number of calls
Calls per day