tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 084a827e-db3b-4212-b02f-49c4d9e8859c
Sheet: Bid Opening List

CITY OF GLENDORA
RFP REGISTER
The following sealed packets were received by the hour of 5:00 p.m. on Thursday, May 17, 2012, for the project shown below.
 | Please Note:  [NAME] received late will not be opened.
Project Name: |  | Country Club Reservoir 2B Improvements
Project Manager: |  | [NAME] |  | Project Manager [NAME]: (626) 914-8253
City Clerk's Office Representative certifying:
(Name, Title)
Enter other staff members attending (Name, Title)
# | [NAME] |  |  | Date & Time Packet Received |  | To Project Mgr. - Date/Time
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Packets Received Late:
# | [NAME] |  | Date & Time Bid Received | # | [NAME] |  | Date & Time Bid Received
1 |  |  |  | 2
Packets given to: __________________________ |  |  |  |  | Date: ______________________________
Received by:  __________________________________________
 | (Signature)
 |  |  |  |  | (RFQ Register Continued)
# | [NAME] |  |  | Date & Time Packet Received |  | To Project Mgr. - Date/Time
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Spreadsheet: 76272d1276793989-excel-2007-determine-total-sales-and-type-of-sales-per-salesperson-sample
Sheet: Sheet1

Salesperson | Book Month | Book Date
[NAME] | Jun
Betty |  | 2010-06-28 00:00:00
Fred | Jun
[NAME] |  | 2010-06-30 00:00:00
[NAME] |  | 2010-06-22 00:00:00
[NAME] | Jun
[NAME] | Jun
Betty | Jun
A2:A9= Sales for one day. [NAME] made 2 sales; 1 booked when sold and the other books at later date indicated.
*Book Month indicates there was a minimum of $250 in-house when deal was logged.
*Book Date refers to when we would have a minimum of $250 in-house if not on date logged.
I'm looking for a formula to return these values:
[NAME] | 1 | 1
Betty | 1 | 1
Fred | 1
[NAME] | 2 | 1
Spreadsheet: 6ccda76c-fe42-41d6-bc86-e95b79061628
Sheet: Tabor Spending Limitations

School District |  | District Code
CURRENT FISCAL YEAR PROJECTED TABOR SPENDING LIMITATION
1. Enter Current FY Fund Data as Listed below. |  |  | TOTAL EXPENDITURES | CHANGES IN BALANCE | TRANSFERS | TABOR EXPENDITURES
a | General Fund | a | 0 | 0 | 0
a1 | Charter School Fund | a1 | 0 | 0 | 0
a2 | Insurance Reserve Special Revenue Fund | a2 | 0 | 0 | 0
a3 | Pre-School Fund | a3 | 0 | 0 | 0
b | ARRA (Federal Stimulus Funding) Grants Fund | b | 0 | 0 | 0
c | Capital Reserve Special Revenue Fund | c | 0 | 0 | 0
d | [NAME] | d | 0 | 0 | 0
e | Pupil Activity Special Revenue Fund | e | 0 | 0 | 0
f | Full Day [NAME] | f | 0 | 0 | 0
g | Transportation Fund | g | 0 | 0 | 0
h | Other Special Revenue Funds | h | 0 | 0 | 0
i | Bond Redemption Fund | i | 0 | 0 | 0
i2 | Non-Voter Approved Debt Fund | i2 | 0 | 0 | 0
j | Building Fund (include Capital Reserve Capital Projects Fund) | j | 0 | 0 | 0
k | Special Building & Technology Fund | k | 0 | 0 | 0
l | Food Service Fund | l | 0 | 0 | 0
m | Other Enterprise Funds | m | 0 | 0 | 0
n | Risk-Related Activity Fund | n | 0 | 0 | 0
o | Internal Service Funds | o | 0 | 0 | 0
p | Fioundation Funds | p | 0 | 0 | 0
q | Component Unit Funds | q | 0 | 0 | 0
 | TOTAL CURRENT FY TABOR EXPENDITURES |  |  |  | 1
2. Deduct the Following Expenditures Included in Totals above :
a | Refunds to Taxpayers |  |  | a | 0
b | Expenditures from Gifts/Foundations (Excluding Agency Funds) |  |  | b | 0
c | Expenditures from Federal Funds |  |  | c | 0
d | Collections for Another Government |  |  | d | 0
e | Pension Contributions by Employees |  |  | e | 0
f | Pension Fund Earnings |  |  | f | 0
g | Expenditures from the Proceeds of Damage Awards |  |  | i | 0
h | Expenditures from the Proceeds of the Sale of School Property |  |  | j | 0
 | TOTAL CURRENT FY TABOR DEDUCTIONS |  |  |  | 2
3. TOTAL TABOR SPENDING FOR CURRENT FY (Line 1 minus [NAME]) |  |  |  |  | 3
4. ADJUSTMENTS TO SPENDING FOR DETERMINING ALLOWABLE GROWTH
a | Debt Service Increase/(Decrease) since FY 1992-93 |  |  | a | 0
b | Voter-Approved Revenue Changes (line 4b) |  |  | b | 0
 | TOTAL ADJUSTMENTS TO SPENDING |  |  |  | 4
5. NET SPENDING ON WHICH GROWTH IS ALLOWED (line 3 minus line 4) |  |  |  |  | 5 |  | To Determine your TABOR 3% Reserve Amount use 3% of Line 5
 |  |  |  |  |  |  | 3% of Current Year Spending = TABOR Minimum
6. ALLOWABLE GROWTH
a | Percent Change in Denver-Boulder Consumer Price Index for prior CY |  | a | 0
b | Percent Change in Student Enrollment |  | b | 0
c | Total Percent Change (line a plus line b) |  | c
d | Net Spending on which Growth is Allowed (line 5) |  | d
e | Total Inflation and Enrollment Growth (line 6c times line 6d) |  |  | e
f | Debt Service Increase/(Decrease) since FY 1992-93 (line 4a) |  |  | f
g | Voter-Approved Revenue Changes (line 4b) |  |  | g
 | TOTAL ALLOWABLE GROWTH (line 6e plus line 6f plus line 6g) |  |  |  | 6
7. MAXIMUM ALLOWED TABOR SPENDING FOR CURRENT FY (line 3 plus line 6) |  |  |  |  | 7
Spreadsheet: 739815d1625975876-xlookup-more-than-3-results-from-data-set-tracker-for-sharing-2-1-
Sheet: Calendar

Month | July - P7 |  |  |  | August - P8 |  |  |  | September - P9 |  |  |  |  | October - P10 |  |  |  | November - P11 |  |  |  | December - P12
Week No | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 202127 | 202128 | 202129 | 202130 | 202131 | 202132 | 202133 | 202134 | 202135 | 202136 | 202137 | 202138 | 202139 | 202140 | 202141 | 202142 | 202143 | 202144 | 202145 | 202146 | 202147 | 202148 | 202149 | 202150 | 202151 | 202152
Trial
 |  |  | Project #36 | Project #63 | Project #27 |  | Project #68 |  | Project #10
 |  |  | Project #37 |  | Project #34 |  |  |  | Project #11
 |  |  |  |  |  |  |  |  | Project #48
 |  |  |  |  |  |  |  |  | Project #54
Rollout
 |  |  | Project #66 | Project #107 |  |  |  |  | Project #50 | Project #57 | Project #58 |  |  |  |  |  |  | Project #44
 |  |  | Project #77 |  |  |  |  |  | Project #51
 |  |  | Project #106 |  |  |  |  |  | Project #53
 |  |  | Project #111 |  |  |  |  |  | Project #59
 |  |  |  |  |  |  |  |  | Project #68
Spreadsheet: 188148d1350703472-summing-the-last-x-entries-in-a-column-example
Sheet: Sheet1

1.61
16.32
7.6
13.92
15
33.6
6
4.421250000000001
6.6
8.879999999999999
8.5
16.8
1.12
6.0775
3.208571428571429
14.88
100
5.2
0.63
13.68
1.5
13.78666666666667
16
32.4
15.6
15.29333333333333
38
6.44
34.8
9.36
45.6
50
31.2
3.35
29
3
5.355
Spreadsheet: 86876d1286833093-summing-up-data-in-an-adjacent-cell-based-on-date-into-a-calendar-workbook-sample
Sheet: Calendar

 | october |  |  |  |  | 2010
 | monday |  | tuesday |  |  | wednesday |  |  | thursday |  |  | friday |  |  | saturday |  |  | sunday
Spreadsheet: 61428d1262276119-locate-and-delete-objects-sample
Sheet: Sheet1

PRODNUM | [NAME] | DESC2 | PLINE | PSEC | PSN | SSN2 | USFAMILY | WEIGHT | OSIZE | USHTSNUM | HTSDESCRIPTION | OEM CODE | INS CODE | INS CODE # | INS EXT | RISK | BASENUM | AASM | NDESC1 | NDESC2 | HOLLANDER | USOEM | REMAN | VALUE | CAPA | [NAME] | [NAME] | NWIDE | FARM | GRANGE | AVIVA | USAA | UNIV | NWCPP | GEICO | DSTD | SOW | B2C | INSEXT | INCPD | C2C | WEBDESC | FRENCH1 | FRENCH2 | PRODNUM2 | W051 | NEW | W601 | W605 | W034 | W379 | OELIST | PRODNUM3 | USVEND | PRIM | VNDLN | VENDNUM | BOX | MIN | WEIGHT2 | CUBES | USCOST | VENDNUM2 | [NAME] | MIN2 | [NAME] | CUBE2 | PP | NW | GR | FM | AV2 | US2 | UN2 | PRODNUM4 | W000 | 97000 | PRODNUM5 | W051x | SM051 | W081 | SM081 | W021 | SM021 | W041 | SM041 | W012 | SM012 | W051a | 91001 | W081a | 91002 | W021a | 91003 | W041a | 91004 | W012a | 91005 | STOCK.CD | ACTION.CD
Spreadsheet: benjamin_rogers__1239__Simple Cycle Florida model
Sheet: Taxes

TAXES
('000 $)
STATE TAXES
Adjusted Pretax Book Income
Plus Book Depreciation & Amortization
Less State Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (8 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
FEDERAL TAXES
State Taxable Income
Less: State Taxes
Federal Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (15 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
Deferred Tax Liability
Total Cash Taxes
Total Book Taxes
Total Deferred Tax Liability
Cumulative DTL
Spreadsheet: 795442d1662700121-how-to-get-match-to-return-the-location-of-an-n-a-value-in-an-array-match_na_sample
Sheet: EE

EEID | last name | first name | work state |  | [NAME] |  | Match(NA() | ifna(Match... | [NAME] | ifna | Filter | Index | Transposed list of names
A023 | GALLUZZO | [NAME] | CA |  |  |  |  |  |  |  |  |  |  | GOODWIN | BAILEY
A046 | HAMBLIN | LISA | MA |  | 24 |  | #N/A | 24 | #N/A | 0 | 6 | GOODWIN
A140 | LECCESE | CHRISTINE | NV |  | 31 |  | #N/A | 31 | #N/A | 0 | 10 | BAILEY
A213 | COTTERELL | SANDRA |  |  | #N/A |  | #N/A | 105 | 4 | 4
A586 | STANKIE | ANTHONY | AZ |  | 3 |  | #N/A | 3 | #N/A | 0
A587 | GOODWIN | DANIEL |  |  | #N/A |  | #N/A | 107 | 6 | 6
A865 | PONGNON | SHARON | MA |  | 24 |  | #N/A | 24 | #N/A | 0
A058 | MCDONAG | PATRICK | MA |  | 24 |  | #N/A | 24 | #N/A | 0
A068 | HUO | ZHENGH | MA |  | 24 |  | #N/A | 24 | #N/A | 0
A193 | BAILEY | SHEILA |  |  | #N/A |  | #N/A | 111 | 10 | 10
 | I expected H14 to return "4":
 | So I tried [NAME] as an experiment:
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
Spreadsheet: john_griffith__16026__2_5_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG H2 | 215 | 26.5 | 27.5 | 66.2 | 68.7 | 9.12 | 2002-02-05 10:33:00
 | NG J2 | 220 | 36 | 37 | 56.9 | 58.5 | 7.98 | 2002-02-05 10:33:00
 | NG K2 | 225 | 41.5 | 43.5 | 50.2 | 52.6 | 7.27 | 2002-02-05 10:33:00
 | NG M2 | 230 | 46 | 48 | 45.9 | 47.9 | 6.78 | 2002-02-05 10:33:00
 | NG N2 | 235 | 52.5 | 54.5 | 46.1 | 47.8 | 6.94 | 2002-02-05 10:33:00
 | NG Q2 | 245 | 60 | 62 | 45.9 | 47.4 | 7.19 | 2002-02-05 10:33:00
 | NG U2 | 245 | 65.5 | 67.5 | 46.2 | 47.7 | 7.23 | 2002-02-05 10:33:00
 | NG V2 | 245 | 70.5 | 72.5 | 46.7 | 48.1 | 7.3 | 2002-02-05 10:33:00
 | NG X2 | 270 | 82.5 | 84 | 46.6 | 47.5 | 7.99 | 2002-02-05 10:33:00
 | [NAME] | 290 | 93 | 96 | 46.8 | 48.3 | 8.67 | 2002-02-05 10:33:00
 | NG F3 | 300 | 102 | 105 | 47.5 | 49 | 9.1 | 2002-02-05 10:33:00
 | NG G3 | 295 | 101 | 105 | 45.7 | 47.5 | 8.64 | 2002-02-05 10:33:00
 | NG H3 |  |  |  |  |  |  | 2002-02-01 15:01:00
 | NG M3 |  |  |  |  |  |  | 2002-01-25 14:56:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 89297d1289064149-extend-data-format-and-formulas-not-all-columns-extend-formulas
Sheet: Sheet3

261 | 233 | 4 | 4 | 0 | 0 | 8 | 1
365 | 217 | 4 | 6 | 0 | 0 | 10 | 2
302 | 223 | 4 | 5 | 0 | 0 | 9 | 3
394 | 252 | 4 | 6 | 0 | 0 | 10 | 4
421 | 181 | 4 | 6 | 0 | 0 | 10 | 5
200 | 300 | 0 | 3 | 0 | 0 | 3 | 0
100 | 102 | 0 | 2 | 1 | 1 | 4 | 0
120 | 130 | 0 | 2 | 1 | 0 | 3 | 0
133 | 123 | 4 | 2 | 0 | 0 | 6 | 1
334 | 444 | 0 | 6 | 0 | 0 | 6 | 0
222 | 223 | 0 | 3 | 1 | 1 | 5 | 0
233 | 222 | 4 |  | 0 | 0
432 | 123 | 4 |  | 0 | 0
Spreadsheet: 835156d1688375954-unique-values-and-consolidating-other-columns-book1
Sheet: Sheet1

ID 1 | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME]
ID 1 |  | [NAME] |  |  | ID 2 | [NAME] | [NAME] | [NAME] | [NAME]
ID 1 |  |  | [NAME]
ID 2 | [NAME]
ID 2 |  | [NAME]
ID 2 |  |  | [NAME]
ID 2 | [NAME]
Spreadsheet: 165161d1341063613-same-value-but-shows-false-formulae-to-clean-and-modify-worksheet
Sheet: Before

Exh. Number | Foreign Language | Date | Description | [NAME] | End Bates | Purpose | Reports
 | French; German; English |  | Certified US Patent No. x,xxx,xxx | NEA-LIMP0000002 | NEA-LIMP000230 |  | Sleepy Rebuttal  24 April 13, 2009  _x000D_ Bashful C-2 June 18, 2011
 | French |  | Certified US Patent No. x,yyy,yyy | NEA-LIMP000231 | NEA-LIMP001400 |  | Sleepy 24 April 13, 2009 Bopeep C-1 June 18, 2012
 |  |  | Certified US Patent No. x,xxx,zzz | NEA-LIMP002548 | NEA-LIMP002551 |  | Grumpy 17 April 13, 1999
 | Klingon, Unicorn |  | Certified US Patent No. a,[NAME],zzz | NEA-LIMP0003011 | NEA-LIMP003012
 | English |  | Certified File History of US Patent No. x,yzp,[NAME] | NEA-LIMP003013 |  |  | Sleepy Rebuttal 14 May 4, 2009
 | English |  | Certified File History of US Patent No. y,ued,wor | NEA-LIMP003333 | NEA-LIMP003355
 | German |  | Certified File History of US Patent No. d,swi,th | NEA-LIMP010001 | NEA-LIMP010141 |  | Bopeep 9, Jan. 20, 2005
Spreadsheet: 759843d1639757778-including-two-conditions-in-a-nested-if-if-false-sample
Sheet: Summary

Part | Group | Std Cost | LPP | Delta | On Hand | 2022 Req | Excess | On Order | Last Purchase Date | Month and Year | Suggested Std Cost
101 | Group A | 2 | 1 |  | 10 | 20 |  | 0 | 2021-12-02 00:00:00
102 | Group A | 3 | 6 |  | 5 | 4 |  | 2 | 2021-01-01 00:00:00
103 | Group B | 4 | 7 |  | 4 | 2 |  | 2 | 2021-06-25 00:00:00
104 | Group B | 5 | 8 |  | 6 | 10 |  | 10 | 2021-02-04 00:00:00
105 | Group C | 12 | 15 |  | 80 | 100 |  | 50 | 2021-03-15 00:00:00
106 | Group C | 15 | 15 |  | 100 | 50 |  | 0 | 2021-08-05 00:00:00
107 | Group D | 4 | 6 |  | 20 | 30 |  | 0 | 2021-09-21 00:00:00
108 | Group D | 8 | 10 |  | 15 | 20 |  | 10 | 2021-02-02 00:00:00
109 | Group E | 7 | 9 |  | 200 | 250 |  | 100 | 2021-07-08 00:00:00
110 | Group E | 50 | 65 |  | 10 | 8 |  | 0 | 2021-11-21 00:00:00
 |  |  | List of criteria:
- If LPP<[NAME] cost and (2022 Req = 0,On Order=0), return LPP
- if LPP>Std cost and (2022 Req=0, On Order=0), return [NAME] cost
- if LPP>Std and (2022 Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (2022Req<>0, On Order<>0, group = Group B), return [NAME], if group<>Group B but everything else is TRUE, return LPP)
- If LPP>Std and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return the LPP or [NAME] (which ever is the highest)
Spreadsheet: 7893e6a4-6992-4559-87b3-e29915006b6f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5038 | 5390 | [NAME] | [NAME] | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:13:47
5038 | 5428 | Agnes | Eppers | BOL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:17:04
5038 | 28296 | Soledad | Marmaria | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:17:45
5038 | 5471 | [NAME] | Geijo | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:21:34
5038 | 14929 | [NAME] | Calcagno | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:23:51
5038 | 15116 | Julieta | Solanas | ARG | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 02:24:27
5038 | 6152 | Virginia | Lopez | URU | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | [NAME]
Spreadsheet: 84560d1284602762-sumif-excluding-hidden-rows-book1
Sheet: Sheet1

Total Oustanding |  | 50 | 40 | 30 | 20
Amount Paid |  |  | 50 | 70 | 70
Name | Payable each year | Year 1 | Year 2 | Year 3 | Year 4
[NAME] | 10 | 50 | 40 | 30 | 20
Clare | 10 | 0 | 80 | 70 | 60
Garth | 10 | 30 | 20 | 10 | 0
Leanne | 10 | 0 | 0 | 70 | 60
Justin | 10 | 10 | 0 | 0 | 0
[NAME] | 10 | 20 | 10 | 0 | 0
[NAME] | 10 | 0 | 60 | 50 | 40
[NAME] | 10 | 40 | 30 | 20 | 10
[NAME] | 10 | 0 | 30 | 20 | 10
Spreadsheet: 875692d1722311156-using-formula-to-calculate-weighted-average-by-getting-numbers-from-multiple-sheets-weighted-average-eba
Sheet: Consolidated

 |  | Month |  | 2024-06-01 00:00:00 | 30 | days |  |  |  |  | Month |  | 2024-06-01 00:00:00 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  |  | Division A |  |  |  |  |  | DIV A | DIV B | DIV C | Consolidated
 |  | Clients (Funded) |  |  |  |  |  | Division B |  |  | Clients (Funded) |  |  | 24 | 27 | 28
 |  | Weekly Avg Fees Achieved (Funded) |  |  |  | Weighted Average |  | Division C |  |  | Weekly Avg Fees Achieved (Funded) |  |  | 450 | 375 | 550
 |  | Clients non Funded |  |  |  |  |  |  |  |  | Clients non Funded |  |  | 17 | 15 | 22
 |  | Weekly Avg Fees Achieved (Private) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Private) |  |  | 900 | 850 | 750
 |  | Total Clients |  |  |  |  |  |  |  |  | Total Clients |  |  | 41
 |  | Fee Billed - Funded |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  | Fee Billed - non Funded |  |  |  |  |  |  |  |  | Fee Billed - non Funded
 |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - non Funded
Spreadsheet: 742857d1628081993-need-help-with-comparison-of-data-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | External Reference |  |  |  |  |  |  |  |  |  |  |  |  |  | Case ID
2021-07-08 00:00:00 | 14:25:00 | 2021-07-08 00:00:00 | 16:00 - 17:00 |  |  | 2021-07-08 00:00:00 | Test1 | Test 1 | 21804 | Test1 | Adult |  | 533 | 0 | 533 | 2 | 2 | 1066 | 0 | 0 | 304 | 0 | 762 | 381 | 5 | 5441032, | My Company 1 |  |  | Customer 1 | Ticket | Reservation | agent 1 | Customer 1 | [EMAIL] | No |  | Pending | Completed | 162573978223259 |  |  |  |  |  | 0 | No | Completed | 85694 |  | 162573978223259
2021-07-08 00:00:00 | 14:25:00 | 2021-07-08 00:00:00 | 16:00 - 17:00 |  |  | 2021-07-08 00:00:00 | Test2 | Test2 | 21804 | Test2 | Child |  | 533 | 0 | 533 | 3 | 3 | 1599 | 0 | 0 | 456 | 0 | 1143 | 381 | 5 | 5441032, | Company 2 |  |  | Customer 2 | Ticket | Reservation | agent 2 | Customer 2 | [EMAIL] | No |  | Pending | Completed | 162573978223259 |  |  |  |  |  | 0 | No | Completed | 85694 |  | 162573978223259
2021-07-05 00:00:00 | 11:07:00 | 2021-07-06 00:00:00 | 18:00 - 18:30 |  |  | 2021-07-05 00:00:00 | Test 3 | Test 3 | 21765 | Test 3 | Adult |  | 224 | 0 | 224 | 3 | 3 | 672 | 0 | 0 | 135 | 0 | 537 | 179 | 5 | 5439801, | Company 3 |  |  | Customer 3 | Ticket | Reservation | agent 3 | Customer 3 | [EMAIL] | No |  | Pending | Completed | 162546872575641 |  |  |  |  |  | 0 | No | Completed | 190902/03224D/190706 |  | 162546872575641
Spreadsheet: c2d7d932-2dc7-4c4e-ae84-0a65c5ff363c
Sheet: Area 5

Location | Title | Name | Mobile | Address | CRCs | CRC Mobile
Area 5 | Area Manager | [NAME] | 07740 565 059 | [NAME]
 |  |  |  | Lightfoot Green
 |  |  |  | Fulwood
 |  |  |  | Preston
 |  |  |  | Lancashire PR4 0AP
Cheshire | RDO | [NAME] | 07958 631 236 | University of Chester | [NAME] | 07921 283192
 |  |  |  | [NAME] | [NAME] | 07921 283193
 |  |  |  | [NAME]
 |  |  |  | Warrington WA2 0DB
Staffordshire | RDO | [NAME] | 07912 541 471 | 1 Ullswater Crescent | [NAME] | 07894 489754
 |  |  |  | Ashby | [NAME] | 07718 706576
 |  |  |  | Leicestershire
 |  |  |  | LE65 1FH
Birmingham | RDO | [NAME] | 07889 601 017 | Rugby Development Office | [NAME] | 07894 489419
 |  |  |  | The University of Birmingham | [NAME] | 07841 156808
 |  |  |  | Munrow Sports Centre | [NAME] | 07718 706578
 |  |  |  | Edgbaston | [NAME] | 07590 890816
 |  |  |  | [NAME] 2TT
Shropshire | RDO | [NAME] | 07810 050970 | c/o Community Dept | [NAME] | 07718 706579
 |  |  |  | Worcester Warriors | [NAME] | 07711 385897
 |  |  |  | Sixways Stadium
 |  |  |  | Warriors Way
 |  |  |  | Hindlip
 |  |  |  | Worcester WR3 8ZE
[NAME] | RDO | [NAME] | 07730 814 156 | c/o Community Dept | [NAME] | 07894 489416
 |  |  |  | Worcester Warriors | [NAME] | 07590 890759
 |  |  |  | Sixways Stadium
 |  |  |  | Warriors Way
 |  |  |  | Hindlip
 |  |  |  | Worcester WR3 8ZE
Greater Manchester | RDO | [NAME] | 07736 517 730 | [NAME] | [NAME] | 07718 706569
 | RDO | [NAME] | 07730 814 162 | Hough End Crescent | [NAME] | 07718 706557
 |  |  |  | (off Mauldeth Road West) | [NAME] | 07718 706570
 |  |  |  | Chorlton | [NAME] | 07590 890802
 |  |  |  | [NAME] | [NAME] | 07985 767598
 |  |  |  |  | Stephanie Veal | 07872 827154
Merseyside | RDO | [NAME] | 07764 960 410 | Litherland Sports Park | [NAME] | 07921 283194
 |  |  |  | Boundary Lane | [NAME] | 07894 489418
 |  |  |  | Litherland L21 7LA | [NAME] | 07715 856703
 |  |  |  |  | [NAME] | 07738 648 944
Lancashire | RDO | [NAME] | 07740 565 060 | Lancashire County Council | [NAME] | 07894 489730
 |  |  |  | Joint Divisional Offices | [NAME] | 07894 489731
 |  |  |  | PE & Sports Development Unit
 |  |  |  | East Cliff
 |  |  |  | Preston
 |  |  |  | Lancashire PR1 3JT
Isle of Man | RDO | [NAME] | 01624 686808 | [NAME] Recreation
 |  |  |  | Sports Development Unit
 |  |  |  | NSC
 |  |  |  | Groves Road
 |  |  |  | [NAME]
 |  |  |  | Isle of Man
 |  |  |  | IM2 1RB
Area 5 | URDO | [NAME] | 07809 511739 | University of Chester
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Warrington WA2 0DB
Area 5 | WRDO | [NAME] | 07841 367447 | c/o RFU
 |  |  |  | Rugby House
 |  |  |  | 200 Whitton Road
 |  |  |  | Twickenham TW2 7BA
Spreadsheet: 836467d1689382337-proforma-calculation-based-of-month-and-years-book1-shruder-
Sheet: Data

 |  |  |  |  |  |  |  |  | 1 | 31
 |  |  |  |  |  |  |  |  | 2 | 28
 |  |  |  |  |  |  |  |  | 3 | 31
 |  |  |  |  |  |  |  |  | 4 | 30
 |  |  |  |  |  |  |  |  | 5 | 31
 |  |  |  |  |  |  |  |  | 6 | 30
 |  |  |  |  |  |  |  |  | 7 | 31
 |  |  |  |  |  |  |  |  | 8 | 31
 |  |  |  |  |  |  |  |  | 9 | 30
 |  |  |  |  |  |  |  |  | 10 | 31
 |  |  |  |  |  |  |  |  | 11 | 30
 |  |  |  |  |  |  |  |  | 12 | 31
Spreadsheet: 779458d1651789759-sumproduct-with-named-ranges-indirect-and-multiple-criteria-sales-2022-phone-stats-to-get-formula
Sheet: January

2022 | Inbound Sales
Date | Handled ACD Calls | [NAME] | Total Calls Rcd | [NAME] | [NAME] (sec) | [NAME] (sec) | Max Wait Time (sec) | Avg Wrap Time | Avg Call Time (sec) | Connect And Sell OB Calls | Outbound Calls
2022-01-02 00:00:00
 | 301 | 39 |  |  | 208 | 195 | 850 |  | 207 | 466 | 403
 | 267 | 18 |  |  | 166 | 165 | 683 |  | 312 | 464 | 268
 | 267 | 101 |  |  | 415 | 260 | 980 |  | 280 | 331 | 282
 | 271 | 91 |  |  | 432 | 266 | 2003 |  | 373 | 537 | 278
 | 225 | 36 |  |  | 266 | 156 | 985 |  | 343 | 464 | 250
Week TTL
 | 361 | 76 |  |  | 282 | 214 | 914 |  | 305 | 424 | 317
 | 316 | 52 |  |  | 197 | 194 | 840 |  | 293 | 424 | 332
 | 354 | 67 |  |  | 265 | 237 | 997 |  | 310 | 478 | 326
 | 362 | 78 |  |  | 292 | 254 | 755 |  | 254 | 474 | 365
 | 325 | 62 |  |  | 178 | 207 | 934 |  | 271 | 577 | 314
Week TTL
 | 262 | 22 |  |  | 125 | 79 | 525 |  | 212 | 274 | 340
 | 295 | 36 |  |  | 174 | 132 | 823 |  | 283 | 330 | 299
 | 292 | 35 |  |  | 142 | 149 | 959 |  | 282 | 647 | 372
 | 253 | 24 |  |  | 109 | 87 | 528 |  | 284 | 657 | 413
 | 271 | 29 |  |  | 135 | 120 | 656 |  | 286 | 470 | 350
Week TTL
 | 313 | 64 |  |  | 236 | 178 | 900 |  | 251 | 654 | 393
 | 355 | 67 |  |  | 220 | 253 | 1240 |  | 290 | 635 | 407
 | 276 | 22 |  |  | 234 | 130 | 964 |  | 252 | 845 | 440
 | 304 | 65 |  |  | 341 | 226 | 1040 |  | 294 | 694 | 329
 | 261 | 43 |  |  | 155 | 174 | 712 |  | 312 | 669 | 341
Week TTL
 | 363 | 52 |  |  | 206 | 204 | 1153 |  | 345 | 616 | 249
Week TTL |  |  |  |  |  |  |  | 261
Month TTL
Spreadsheet: 880800d1728649953-remove-filtered-data-from-the-sheet-with-the-help-of-formula-code
Sheet: Sheet2

ID | Code
0001 | PAG |  | ACCORHG
0001 | PAG
0050 | Jinjiang
0050 | Jinjiang
0001 | UBR
0015 | Jinjiang
0002 | UBR
0001 | UBR
0015 | Jinjiang
0002 | UBR
0002 | UBR
0001 | UBR
0002 | SELSDON
6515 | ACCORHG
6515 | ACCORHG
6515 | ACCORHG
5371 | ACCORHG
0015 | Jinjiang
0015 | Jinjiang
0001 | Jinjiang
0002 | UBR
0006 | DMGM
0015 | Jinjiang
0001 | Jinjiang
0001 | Jinjiang
0001 | Jinjiang
0001 | Jinjiang
0001 | Jinjiang