tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 825038d1681060892-formula-if-for-my-result-formula-pls
Sheet: Sheet1

 | In | Out | Indicator (A or B) | Indicator (C or D) | Date Indicator C | Result |  |  |  | A | C
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | A | C | 2023-04-07 00:00:00 |  |  |  |  | B | D
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | B | D
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | A | C | 2023-04-09 00:00:00
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | B | D
 |  |  |  |  |  | If Indicator A = Result (-1)
 |  |  |  |  |  | If Indicator B = Result (+1)
 |  |  |  |  |  | +
 |  |  |  |  |  | If Indicator C = Result (Date Indicator C - Out)
 |  |  |  |  |  | If Indicator D = Result (same result as 1st argument)
Spreadsheet: 827757d1683019439-average-timings-exercise-average-timings
Sheet: Snapshot

 |  | 2023
 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Average Timings |  |  |  |  |  |  |  |  |  |  |  |  | Yearly Average
 | External |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between F2 and G2 by month. It is important to ignore if there are blank cells on G2.
 | Cash Received |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between B2 and E2 by month. It is important to ignore if there are blank cells on E2.
 | Letter To Authorities |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between C2 and D2 by month. It is important to ignore if there are blank cells on D2.
 | Authorities Response
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between B2 and D2 by month and by category (Column A). It is important to ignore if there are blank cells on D2.
 | Lim |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I also want to calculate the total average timings for each category on a yearly basis.
 | Paf
 | Lar
 | Amm
Spreadsheet: 758378d1638835624-change-status-of-a-column-based-on-most-recent-record-and-date-variables-test-sheet-9000
Sheet: Device List

Device | OS | Included In
iPhone 13 Mini | iOS 15.0 | Roaming [NAME]
iPhone 12 | iOS 14.0 | Roaming [NAME]
Samsung Galaxy S21 | Android 11 | Roaming [NAME]
[NAME] | Android 11 | Roaming [NAME]
Google [NAME] 6 | Android 12 | Roaming [NAME]
iPad | iPad OS 15.0 | Roaming [NAME]
[NAME] | Android 10.0 | Roaming [NAME]
Chomrecast with Google Tv | Android TV 11 with Google TV Interface | Roaming [NAME]
NVIDIA Shield TV | Android 9.0 | Roaming [NAME]
Fire TV [NAME] | Fire OS 7 (Android 9) | Roaming [NAME]
Telstra TV 3 | Roku | Roaming [NAME]
Foxtel iQ4 | Proprietary OS | Roaming [NAME]
[NAME] | Proprietary OS | Roaming [NAME]
Apple TV 4K | tvOS 15 | Roaming [NAME]
iPhone 13 Mini | iOS 15.0 | Test Suite
iPhone 12 | iOS 14.0 | Test Suite
iPhone 13 Mini | iOS 15.0 | [NAME]
iPhone 12 | iOS 14.0 | [NAME]
Spreadsheet: 851918d1702041888-formula-to-change-text-color-if-2-criteria-are-met-ticket-tracking
Sheet: Blank

 |  |  |  |  |  | ../../../../../../../MIMS%20Tracking%20Comments.xlsx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority | Emergency
 | Ticket Number | Type of Ticket | Issue/Task Comment | Asset Category | Asset Names |  | Time Created | Ack By | Mobilization Time | Mobilization Time in days:hrs:min | Completion Time | Resolution Time in hrs:min:sec | Resolution Time in days:hrs:min | Completed Date | Solution | Avg. Priority [NAME] | Avg. Priority Resolution Time | Avg. Emergency Acknowledge Time | Avg. Emergency Resolution Time | Longest Priority Response Time | Longest Priority Resolution Time | Longest Emergency Response Time | Longest Emergency Resolution Time | "Priority" Over Allotted Acknowledge Time | Priority Over Allotted Resolution Time | "Emergency" Over Allotted Acknowledge Time | "Emergency" Over Allotted Resolution Time | Unresolved Priority Tickets | Unresolved Emergency Tickets
Spreadsheet: 746985d1631165320-calculating-accumulated-blocks-of-time-example2431
Sheet: Sheet1

T | P | A |  | P | A | T
06:00:00 | P1 | t1 |  | p1 | t1
 |  |  |  | p1 | t2
 | p2 | t3 |  | p2 | t3
 |  |  |  | M | c1
 | p1 | t1 |  | M | c2
 |  |  |  | L
 | p1 | t2
 | M | C1
 | p2 | t3
 | p1 | t2
 | p1 | t1
 | M | c2
 | L
 | p2 | t3
Spreadsheet: 815863d1675239453-if-formula-issue-if-formula-query
Sheet: Sheet1

Grade | Accuracy of Work (25) | Appearance (10) | Flexibility / Reliability (15) | Responsiveness to Queries / Emails (15) | Attitude (10) | [NAME] (25) | Total (100)
B | 20 | 8 | 12 | 11 | 9 | 22
Shouldn't be working for us | 15 | 10 | 5 | 4 | 4 | 15
A | 23 | 9 | 13 | 13 | 10 | 24
C | 20 | 7 | 10 | 10 | 7 | 20
A | score is greater than 90
B | score is 80-89
C | score is 70-79
D | score is 60-69
Shouldn't be working for us | If score is less than 60
N/A | If score is 0
Spreadsheet: 884317d1733406796-support-required-for-wallfall-formula-simplification-new-file
Sheet: working one

 |  |  | M0 | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11
 | Value |  |  | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1 | 1 | 1
 | Month | Plan | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD
 | APR | 1
 | MAY | 2
 | JUN | 2
 | JUL | 3
 | AUG | 3.5
 | SEP | 4.1
 | OCT | 4.7
 | NOV | 5.3
 | DEC | 5.9
 | JAN | 6.5
 | FEB | 7.1
 | MAR | 7.7
 | TOTAL
Spreadsheet: sara_shackleton__36470__ISDA Master Swap Agreement Sheet
Sheet: Threshold

Western Resources |  | S&P/Moody's |  |  | Enron Corp.
 |  | (higher of)
10000000 |  | BBB+/Baa1 |  |  | 15000000
10000000 |  | BBB/Baa2 |  |  | 10000000
5000000 |  | BBB-/Baa3 |  |  | 10000000
2000000 |  | BB+/Ba1 |  |  | 4000000
500000 |  | BB/Ba2 |  |  | 1000000
500000 |  | BB-/Ba3 |  |  | 1000000
0 |  | B+/B1 or lower |  |  | 0
Spreadsheet: 739677d1625852335-running-numerous-countifs-for-formulas-stuck-on-best-way-to-setup-apply-filters-2-recalc-example
Sheet: Scores

 |  | Q5a | Q200a | Q200b | Q201 | QBanker_Polite | QBanker_Listen | QBanker_Appreciated | QBanker_Understand | QBanker_Asked | QBanker_Knowledgeable
 | Count of Top Box/Yes
 | Count of Valid Answers
 | Sum of Top Box/Yes
 | Sum of Valid Answers
Total | Index Score
Problem is I need to do this calculation for a number of filters and capture the "Index Score" from C9 for each of the 23 logic filters below (variables are from the datasheet): I wish there was an easy way to filter the datasheet to just show each logic item below and have it calculate the final "Index Score/C9" but it counts hidden rows from the filter.
# | Filter to use
1 | All Records (the total above)
2 | Only Market_Num=M0007
3 | Only Market_Num=M0006
4 | Only Market_Num=M0010
5 | Only Market_Num=M0011
6 | Only Market_Num=M0004
7 | Only Market_Num=M0008
8 | Only Market_Num=M0005
9 | Only Market_Num=M0009
10 | Only Ret=1
11 | Only Bus=2
12 | Only Q14=1-3
13 | Only Q14=1
14 | Only Q14=2
15 | Only Q14=3
16 | Only Q56=1-3
17 | Only Q56=1
18 | Only Q56=2
19 | Only Q56=3
20 | Only Q5=1-3
21 | Only Q5=1
22 | Only Q5=2
23 | Only Q5=3
Spreadsheet: joe_parks__14507__CHECK_SHEET
Sheet: Sheet1

Date
Technicals |  |  |  |  |  | Fundamentals:
Daily |  | Intra-Day |  |  |  | Weather
8sma |  | 30min |  | 5min |  | SE
14sma |  | 50sma |  | 50sma |  | SW
20sma |  | 70sma |  | 70sma |  | TEXAS
40sma |  | Stoch |  | Stoch |  | NE
Stoch |  |  |  |  |  | MIDWEST
 |  |  |  |  |  | OHIO VALLEY
 |  |  |  |  |  | WEST
 |  |  |  |  |  | DEMAND MODEL
Spreadsheet: 233144d1367633903-lookup-across-multiple-sheets-multiple-sheet-lookup
Sheet: Main 2

UNID
A123473
A123474
A123475
A123476
A123477
A123478
A123479
A123480
A123481
[NAME]
A123483
A123484
A123485
A123486
[NAME]
[NAME]
A123489
A123490
A123491
A123492
Spreadsheet: mary_fischer__25637__31T
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 96530d1295912229-excel-2007-copying-entire-rows-of-data-if-a-cell-meets-certain-criteria-banking_report
Sheet: Banking Report

Banking Report
Date | Check # | Amount | Budget
2011-01-01 00:00:00 | 100 | 50 | President
2011-01-02 00:00:00 | 101 | 75 | Vice President
2011-01-03 00:00:00 | 102 | 100 | Treasurer
2011-01-04 00:00:00 | 103 | 125 | President
2011-01-05 00:00:00 | 104 | 150 | Vice President
2011-01-06 00:00:00 | 105 | 175 | Treasurer
2011-01-07 00:00:00 | 106 | 200 | President
2011-01-08 00:00:00 | 107 | 225 | Vice President
2011-01-09 00:00:00 | 108 | 250 | Treasurer
2011-01-10 00:00:00 | 109 | 275 | President
2011-01-11 00:00:00 | 110 | 300 | Vice President
2011-01-12 00:00:00 | 111 | 325 | Treasurer
2011-01-13 00:00:00 | 112 | 350 | President
2011-01-14 00:00:00 | 113 | 375 | Vice President
Spreadsheet: 29349d1224262950-vlookup-to-exclude-results-condense-report-list
Sheet: Sheet1

Employee ID | Report ID
1 | 101 | 102
3 | 103
4 | 104 | 105 | 106
5 | 107
6 | 108
7 | 109 | 110
8 | 111
9 | 112
10 | 113
11 | 114
12 | 115 | 116 | 117
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 13809 | 13500 | 8589 | 8766
2 | 13692 | 13500 | 8745 | 8766 |  |  | 914
3 | 13249 | 13500 | 8554 | 8766 |  |  | 372
4 | 13315 | 13500 | 8655 | 8766 |  |  | 32
5 | 13166 | 13500 | 8645 | 8766
6 | 12882 | 13500 | 8784 | 8266 | 4 |  | 72
7 | 12665 | 12936 | 8648 | 8226 | 40
8 | 12571 | 13000 | 8780 | 8266
9 | 12456 | 13000 | 8879 | 8266
10 | 12406 | 13000 | 9352 | 8266
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | -38486.04
2001-12-10 00:00:00
CBS Volume
 |  |  | -144659
Spreadsheet: 727559d1617964056-use-match-to-find-last-occurence-in-column-matchexample
Sheet: Sheet1

list | LookupValue | MatchToFindFirst | MatchToFindLast
HANA-CA Central-BWoH-Dev-Host Auto-Failover | HANA-CA Central-SoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-HSR
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA Central-BWoH-Dev-VM-Restart
HANA-CA East-BWoH-Dev-Host Auto-Failover
HANA-CA East-BWoH-Dev-HSR
HANA-CA East-BWoH-Dev-HSR
HANA-CA East-BWoH-Dev-HSR
HANA-CA East-BWoH-Dev-HSR
HANA-CA Central-SoH-Dev-VM-Restart
HANA-CA Central-SoH-Dev-VM-Restart
HANA-CA Central-SoH-Dev-VM-Restart
HANA-CA Central-SoH-Dev-VM-Restart
HANA-CA Central-SoH-Dev-VM-Restart
Spreadsheet: 5ccfaec8-a9c5-483c-83a9-051f55948379
Sheet: Sheet1

ÑAÏI HOÏC QUOÁC GIA TPHCM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | COÄNG HOØA XAÕ HOÄI CHUÛ NGHÓA VIEÄT NAM | Unnamed: 5 | Unnamed: 6 | COÄNG HOØA XAÕ HOÄI CHUÛ NGHÓA VIEÄT NAM.1
TRÖÔØNG ÑAÏI HOÏC KHOA HOÏC TÖÏ NHIEÂN |  |  |  | ÑOÄC LAÄP - TÖÏ DO - HAÏNH PHUÙC |  |  | ÑOÄC LAÄP - TÖÏ DO - HAÏNH PHUÙC
[NAME] 11HT - HỌC KỲ 1  NAÊM HOÏC 2011-2012
[NAME] 11HT(HK1) :
STT | [NAME] |  | Thứ | [NAME] | NGAØY THI | ÑÒA ÑIEÅM | CB GIAÛNG DAÏY
1 | Nhập moân coâng nghệ phần mềm |  | 4 | 17g50 | 2012-05-23 00:00:00 | C42
2 | [NAME] thuyeát ñoà thò |  | CN | 13g00 | 2012-05-27 00:00:00 | C43
3 | [NAME] cô sôû döõ lieäu |  | 4 | 17g50 | 2012-05-30 00:00:00 | C42
4 | Anh vaên 3 |  | CN | 9g | 2012-06-03 00:00:00 | F205B
 |  |  |  |  | TPHCM, ngaøy 8  thaùng  5 naêm 2012
 |  |  |  |  | Tröôûng phoøng Ñaøo taïo
Spreadsheet: 809842d1671370944-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01
Sheet: SOA MO 2

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 72317d1273004771-vlookup-numeric-only-looup-test-for-alphanumeric_copy
Sheet: Sheet1

Item No | Item Description | Item Group | Correct Info/2 |  |  |  |  |  |  |  | item No Ref | [NAME] return
1 |  |  | return test info15 |  |  |  |  |  |  |  | 7 | return test info1
2 |  |  | return test info11 |  |  |  |  |  |  |  | 14 | return test info2
3 |  |  | return test info13 |  |  |  |  |  |  |  | 13 | return test [NAME]
4 |  |  | return test info14 |  |  |  |  |  |  |  | 12 | return test [NAME]
5 |  |  | return test [NAME] |  |  |  |  |  |  |  | 11 | return test info5
6 |  |  | return test info10 |  |  |  |  |  |  |  | 10 | return test [NAME]
7 |  |  | return test info1 |  |  |  |  |  |  |  | 5 | return test [NAME]
8 |  |  | return test info8 |  |  |  |  |  |  |  | 8 | return test info8
9 |  |  | return test info9 |  |  |  |  |  |  |  | 9 | return test info9
10 |  |  | return test [NAME] |  |  |  |  |  |  |  | 6 | return test info10
11 |  |  | return test info5 |  |  |  |  |  |  |  | 2 | return test info11
12 |  |  | return test [NAME] |  |  |  |  |  |  |  | 15 | return test info12
13 |  |  | return test [NAME] |  |  |  |  |  |  |  | 3 | return test info13
14 |  |  | return test info2 |  |  |  |  |  |  |  | 4 | return test info14
15 |  |  | return test info12 |  |  |  |  |  |  |  | 1 | return test info15
a78 |  |  | not found |  |  |  |  |  |  |  | a16 | bbbb
b17 |  |  | mmm |  |  |  |  |  |  |  | b17 | mmm
c18 |  |  | mmmm |  |  |  |  |  |  |  | c18 | mmmm
Spreadsheet: f7e4b931-3e65-46f9-9996-79d05af4fe14
Sheet: Cashflow Supplemental

 | [NAME], INC. AND SUBSIDIARIES
 | SUPPLEMENTAL FINANCIAL INFORMATION
 | (Amounts in millions)
 |  |  | For the twelve months ended December 31,
 |  |  | 2011 |  | 2010 |  | 2009
 | Cash Flow Data
 | Operating Cash Flow |  | 952 |  | 1376 |  | 1183
 | Capital Expenditures |  | 72 |  | 97 |  | 69
 | Non-GAAP Free Cash Flow
 | Non-GAAP free cash flow represents operating cash flow minus capital expenditures.
Spreadsheet: louise_kitchen__23837__2QYTD Orig w notes
Sheet: West Gas

West Gas
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
Tycholiz |  | Gas |  | West |  | 19943780
Whitt |  | Gas |  | West |  | 10556290
Lucci |  | Gas |  | West |  | 6422228.75
[NAME] |  | Gas |  | West |  | 2009000
Ward |  | Gas |  | West
Fuller |  | Gas |  | West |  | 145827.96
[NAME] |  | Gas |  | West |  | 142000
Total
Spreadsheet: 220195d1363095103-excel-2013-templates-forum-graph
Sheet: Sheet1

QUARTERLY SALES REPORT |  |  |  |  |  |  |  |  | SHOW TOP | 5 | PRODUCTS
 |  |  |  |  |  |  |  |  | SHOW ALL OTHER | NO | PRODUCTS
 |  |  |  |  |  |  |  | CUSTOMER SALES
 |  |  |  |  |  |  |  | CUSTOMER
 |  |  |  |  |  |  |  | JB04
 |  |  |  |  |  |  |  | Q1 TOTAL | Q2 TOTAL | Q3 TOTAL | Q4 TOTAL
 |  |  |  |  |  |  |  | 3502.369999999999 | 4612.730000000003 | 3149.48 | 78
 |  |  |  |  |  |  |  | YEARLY TOTAL
 |  |  |  |  |  |  |  | 11342.58
 | PRODUCT | QUARTER 1 | QUARTER 2 | QUARTER 3 | QUARTER 4 | TOTAL | CUSTOMER SALES TOTAL | Column1 |  | PRODUCT | [NAME] | CUST Q2 SALES | CUST Q3 SALES | CUST Q4 SALES
 | 187 | 12899.01 | 32438.25999999999 | 26655.13 | 5485.780000000001 | 77478.18 | 41 | 0 |  | 187 | 0 | 0 | 41 | 0
 | 2HP | 62.5 | 330 | 50 | 90 | 532.5 | 0 | 0 |  | 2HP | 0 | 0 | 0 | 0
 | 4X4 | 794.0999999999997 | 0 | 0 | 2 | 796.0999999999997 | 0 | 0 |  | 4X4 | 0 | 0 | 0 | 0
 | 608 | 183.5 | 75.13 | 56 | 0 | 314.63 | 0 | 0 |  | 608 | 0 | 0 | 0 | 0
 | ABL | 267.85 | 159.84 | 15 | 0 | 442.6899999999999 | 0 | 0 |  | ABL | 0 | 0 | 0 | 0
 | ACS | 1553.53 | 1728.06 | 2663.640000000002 | 154.4 | 6099.630000000002 | 0 | 0 |  | ACS | 0 | 0 | 0 | 0
 | AER | 50 | 0 | 0 | 0 | 50 | 0 | 0 |  | AER | 0 | 0 | 0 | 0
 | ALB | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | ALB | 0 | 0 | 0 | 0
 | ALL | 150 | 50 | 0 | 0 | 200 | 0 | 0 |  | ALL | 0 | 0 | 0 | 0
 | ALN | 455 | 0 | 0 | 0 | 455 | 0 | 0 |  | ALN | 0 | 0 | 0 | 0
 | ALV | 1187.2 | 840 | 840.96 | 0 | 2868.16 | 0 | 0 |  | ALV | 0 | 0 | 0 | 0
 | ANT | 20596.48000000001 | 16372.96999999999 | 15543.25000000003 | 2526.670000000001 | 55039.37000000002 | 160.25 | 27.5 |  | ANT | 27.5 | 50.5 | 66.25 | 16
 | ANX | 97.5 | 0 | 0 | 0 | 97.5 | 0 | 0 |  | ANX | 0 | 0 | 0 | 0
 | ASA | 62.8 | 0 | 0 | 0 | 62.8 | 0 | 0 |  | ASA | 0 | 0 | 0 | 0
 | AST | 0 | 5 | 49.35 | 0 | 54.35 | 0 | 0 |  | AST | 0 | 0 | 0 | 0
 | ATI | 17 | 15 | 5 | 0 | 37 | 0 | 0 |  | ATI | 0 | 0 | 0 | 0
 | ATK | 991 | 8211.08 | 13295.14 | 1239.18 | 23736.4 | 0 | 0 |  | ATK | 0 | 0 | 0 | 0
 | AUT | 2276.97 | 3404.240000000001 | 2101.3 | 549.5 | 8332.010000000002 | 44 | 33 |  | AUT | 33 | 11 | 0 | 0
 | AWS | 11502.69000000001 | 40285.68000000004 | 21908.39000000002 | 3337.19 | 77033.95000000007 | 138.25 | 0 |  | AWS | 0 | 124.25 | 14 | 0
 | AXX | 0 | 75 | 0 | 0 | 75 | 0 | 0 |  | AXX | 0 | 0 | 0 | 0
 | BAK | 62.53999999999999 | 2.8 | 0 | 0 | 65.33999999999999 | 0 | 0 |  | BAK | 0 | 0 | 0 | 0
 | BEA | 1218 | 1823.93 | 2039.86 | 84 | 5165.79 | 28 | 28 |  | BEA | 28 | 0 | 0 | 0
 | BEL | 4248 | 2664 | 4703.2 | 580 | 12195.2 | 0 | 0 |  | BEL | 0 | 0 | 0 | 0
 | BIR | 3062.01 | 10175.51999999999 | 5996.610000000002 | 723.73 | 19957.87 | 80 | 0 |  | BIR | 0 | 80 | 0 | 0
Spreadsheet: 762438d1641560471-count-number-of-entries-if-month-and-year-correspond-to-specific-month-and-year-ef1560_summaries
Sheet: SR All

SR Name | SR Create Date | SR Closing Date | Initial Response (mins) | Time to close (days)
A | 2020-01-09 11:06:19 | 2020-02-02 07:27:48 | 9
B | 2020-01-24 08:23:04 | 2020-02-16 10:45:32 | 15
C | 2020-01-27 10:48:31 | 2020-01-29 06:41:24 | 11
D | 2020-01-28 13:43:01 |  | 8
E | 2020-02-12 02:04:23 | 2020-02-13 08:20:55 | 7
F | 2020-02-13 01:13:15 | 2020-02-26 07:35:34 | 5
G | 2020-02-25 04:23:20 | 2020-02-26 03:27:24 | 14
H | 2020-03-15 20:43:47 | 2020-03-19 10:37:19 | 25
I | 2021-01-09 11:06:19 | 2021-02-02 07:27:48 | 9
J | 2021-01-24 08:23:04 | 2021-02-16 10:45:32 | 15
K | 2021-01-27 10:48:31 | 2021-01-29 06:41:24 | 11
L | 2021-01-28 13:43:01 |  | 8
M | 2021-02-12 02:04:23 | 2021-02-13 08:20:55 | 7
N | 2021-02-13 01:13:15 | 2021-02-26 07:35:34 | 5
O | 2021-02-25 04:23:20 | 2021-02-26 03:27:24 | 14
P | 2021-03-15 20:43:47 | 2021-03-19 10:37:19 | 25
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Table of Contents

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Land Value Creation Assumptions
 | Workbook Table of Contents
 | Project Summary
 |  | Project Matrix
 |  | Detailed Annual Model
 |  | Benefits Summary
 |  | Cost and Funding Summary
 |  | BCA Ratio
 |  | Benefits and Costs Summary
 |  | Job Creation
 | Costs Summary
 |  | Construction Costs Summary
 |  | Maintenance Costs Summary
 | Benefits Summary
 |  | Lifecycle Cost Savings Summary
 |  | Existing Parcel Value Increase Summary
 |  | Newly Created Parcels Value Summary
 |  | Prevented Injuries & Accidents Summary
 | Detailed Project and Maintenance Costs
 |  | Project Costs
 |  | Project Costs by Quarter
 |  | Maintenance and Repair Costs
 |  | No Build Maintenance
 | Assumptions
 |  | Land Value Assumptions
 |  | Safety Assumptions
 |  | CPI Data
 |  | Safety Benefits Calculation
 | Land Value Increases Detail
 |  | Calculation of Increase in Value of Existing Parcels
 |  | Development Assumptions & Summary
 |  | Development Costs
 |  | Development Program Option 1
 |  | Scenario 1 Pro Forma
 |  | Development Program Option 2
 |  | Scenario 2 Pro Forma
Spreadsheet: 115479d1311085131-compiling-complex-text-data-in-a-table-test
Sheet: TEST2

Commissioning - TEST 2
Information |  |  | Client Information |  |  |  |  | Fund Information |  |  |  |  |  | Finance Information |  |  | Work Log
District | Date of Request | Worker | Surname | Name | D.O.B. | Ethnicity | Postcode | Reason for request | Service Provider | Service Description | Agreed/Refused | Date Agreed/Refused | Reason: | Amount Request | Amount Agreed | Budget Balance | Letter sent | LOA (out) | LOA (in) | Invoice (in) | Follow-up Date | Outcomes that were Improved
London North | 2011-07-04 00:00:00 | [NAME] | Anstey | Jo | 2003-08-01 00:00:00 | White British | AB10 | Childcare | Goodwell ASC | 2 hours 3x per week | Agreed | 2011-07-04 00:00:00 | example | 330 | 330 | 7670 |  |  |  |  | 2012-01-04 00:00:00
London South | 2011-07-04 00:00:00 | [NAME] | Smith | [NAME] | 2000-11-09 00:00:00 | White British | AB2 | Counselling | [NAME] | 6 x weekly sessions | Agreed | 2011-07-06 00:00:00 | example | 460 | 460 | 7210 |  |  |  |  | 2012-01-06 00:00:00
London South | 2011-07-07 00:00:00 | [NAME] | Barker | [NAME] | 2001-02-26 00:00:00 | White British | AB2 | Counselling | Bevereavement Services | 8 x weekly sessions | Agreed | 2011-07-11 00:00:00 | example | 597 | 597 | 6613 |  |  |  |  | 2012-01-11 00:00:00
London South | 2011-07-11 00:00:00 | [NAME] | [NAME] | [NAME] | 2005-05-05 00:00:00 | White British | AB2 | Counselling | [NAME] | 6 x weekly sessions | Agreed | 2011-07-12 00:00:00 | example | 550 | 550 | 6063 |  |  |  |  | 2012-01-12 00:00:00
London North | 2011-07-12 00:00:00 | [NAME] | House | Mark | 2008-06-13 00:00:00 | White British | AB10 | Counselling | [NAME] | 6 x weekly sessions | Agreed | 2011-07-12 00:00:00 | example | 460 | 460 | 5603 |  |  |  |  | 2012-01-12 00:00:00
London North | 2011-07-13 00:00:00 | [NAME] | Cole | [NAME] | 1999-01-19 00:00:00 | White Irish | AB10 | Childcare | Nursery | 2x 2 hour sessions per week | Agreed | 2011-07-15 00:00:00 | example | 567.5 | 567.5 | 5035.5
London North | 2011-07-18 00:00:00 | [NAME] | Edwards | Evie | 2004-12-28 00:00:00 | White British | AB10 | Resources | Uniform | For school | Refused | 2011-07-19 00:00:00 | example | 95 | 0 | 5035.5 |  |  |  |  | 2012-01-19 00:00:00
London North | 2011-07-18 00:00:00 | [NAME] | [NAME] | [NAME] | 2006-02-12 00:00:00 | White British | AB11 | Activity | Football Club | After School Football club - once per week | Agreed | 2011-07-19 00:00:00 | example | 60 | 60 | 4975.5 |  |  |  |  | 2012-01-19 00:00:00
London South | 2011-07-19 00:00:00 | [NAME] | Wells | Greg | 2009-10-22 00:00:00 | White/African | AB2 | Resources | Puppet | Purchase of puppet | Agreed | 2011-07-19 00:00:00 | example | 29.99 | 29.99 | 4945.51 |  |  |  |  | 2012-01-19 00:00:00
London South | 2011-07-19 00:00:00 | [NAME] | Turner | Samantha | 1998-03-07 00:00:00 | White British | AB2 | Resources | Car Safety Centre | Purchase of car seat | Agreed | 2011-07-19 00:00:00 | example | 120 | 120 | 4825.51 |  |  |  |  | 2012-01-19 00:00:00