tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Taxes

CASH / BOOK TAXES
Current Year
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Months Of Operation
CASH TAXES
Taxable Income Calculation (Excluding Sudam)
Earnings Before Depr, Int, & Taxes
Plus: [NAME] To Cash Adjustment (US$ Based)
Plus: [NAME] To Cash Adjustment (R$ Based)
Less: Tax Depreciation
Less: Interest Expense - Senior Debt
Less: Interest Expense - Subordinated Debt
Less: IDC To Be Expensed
Less: INE Interest Expense
Taxable Income Before NOL Carryforward
NOL Used In Current Year | See Below
Net Income Subject To Income Taxes (w/o [NAME])
Net Operating Loss Calculation (Cash Taxes)
Beginning NOL Balance |  |  | 0
Prior Year's NOL
NOL Used In Current Year
Ending NOL Balance
Corporate Income Tax
Net Income Subject To Income Tax (w/o [NAME])
Times: Corporate Income Tax
Total Corporate Income Tax Payable
Additional Income Tax
Net Income Subject To Income Tax (w/o [NAME])
Less: Amount Not Subject To Add'l Tax
Income Subject To Additional Tax
Times: Additional Income Tax
Total Additional Income Tax
Subtotal Corporate Income Tax & Additional Income Tax
[NAME] Used (See Sudam Tax Credit Calculation)
Net Corporate Tax & Additional Tax Payable
Social Contribution Tax (Not Available For [NAME])
Net Income Subject To Income Tax (w/o [NAME])
Times: Social Contribution Tax Rate
Total Social Contribution Tax
Total Cash Taxes (Excluding [NAME])
Tax Savings Under [NAME] (Applied To Reserve)
Total Cash Taxes
BOOK TAXES
Earnings Before Taxes
NOL Used In Current Year | See Below
Net Income Subject To Income Taxes
Net Operating Loss Calculation (Book Taxes)
Beginning NOL Balance |  |  | 0
Prior Year's NOL
NOL Used In Current Year
Ending NOL Balance
Corporate Income Tax
Net Income Subject To Income Taxes
Times: Corporate Income Tax
Total Corporate Income Tax Payable
Additional Income Tax
Net Income Subject To Income Taxes
Less: Amount Not Subject To Add'l Tax
Income Subject To Additional Tax
Times: Additional Income Tax
Total Additional Income Tax
Social Contribution Tax (Not Available For [NAME])
Net Income Subject To Income Taxes
Times: Social Contribution Tax Rate
Total Social Contribution Tax
Book Provision For Income Tax
Deferred Tax Asset/Liability Calculation
Beginning Deferred Tax Asset / (Liability) |  |  | 0
Plus: Current Year Cash Taxes (Excluding Sudam Benefits)
Less: Current Year Book Taxes
Ending Deferred Tax Asset / (Liability)
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | 6271 |  |  | 5000
2 | 12463 |  |  | 10000
3 | 10327 |  |  | 10000
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | 28279
 | 2000-12-03 00:00:00
Spreadsheet: 02f141fd-315f-4bc9-a05a-024e1e2a6550
Sheet: Sheet1

INSTRUCTIONS: Enter the combined state and county tax rate in row 3; enter the city tax rate in row 4. (Enter these rates in decimal terms -- for instance, 6.3% would be .063)  Enter the gross amount of transactions in row 6. The worksheet will do the rest. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Contracting |  | Retail
Enter Information | Arizona State and County Rate | 0.063 |  | 0.063
Enter Information | City Rate | 0.018 |  | 0.018
Results | Combined tax rate | 0.081 |  | 0.081
Enter Information | Enter Gross Sale | 2998.12 |  | 137819.9
Results | State Tax Factor | 0.03890182 |  | 0.05827937
Results | City Tax Factor | 0.0111148 |  | 0.01665125
Results | Calculated Tax Factor | 0.05001662 |  | 0.07493062
 | Sum of Tax Factor | 0.05001662 |  | 0.07493062
Proof | Gross Sales | 2998.12 |  | 137819.9
Results | State Tax | 116.6323245784 |  | 8032.056945462999
Results | City Tax | 33.323504176 |  | 2294.873609875
Back of State TPT return | Factored Tax Deduction | 149.9558287544 |  | 10326.930555338
 | Sales amount without tax | 2848.1641712456 |  | 127492.969444662
Back of State TPT return | Contracting Factor  35% Deduction | 996.8574599359599
 | Taxable Sales | 1851.30671130964 |  | 127492.969444662
 | Tax Rate | 0.081 |  | 0.081
 | Tax | 149.9558436160808 |  | 10326.93052501762
 | Factored Tax Amount | 149.9558287544 |  | 10326.930555338
 | Actual Tax Amount | 149.9558436160808 |  | 10326.93052501762
Spreadsheet: 529704d1500971014-return-list-with-non-blank-values-from-a-range-with-multiple-columns-list-aligw
Sheet: Solution ExcelForum

 | sofie | [NAME] | [NAME] | 1 | 1 | 1 | 1
tom |  | george |  | 1 | 1 | 1 | 1 |  | piet
piet | eline | tine | elise | 1 | 1 | 1 | 1 |  | [NAME]
[NAME] | [NAME] |  | [NAME] | 1 | 1 | 1 | 1 |  | [NAME]
 | anne | joost | ann-sophie | 1 | 1 | 1 | 1 |  | tom
 | inge |  | ine | 1 | 1 | 1 | 1 |  | [NAME]
[NAME] |  | [NAME] |  | 1 | 1 | 1 | 1 |  | sofie
 |  | filip |  | 1 | 1 | 1 | 1 |  | eline
 | leen |  | lore | 1 | 1 | 1 | 1 |  | [NAME]
tom | hilke |  | hannelore | 1 | 1 | 1 | 1 |  | anne
 |  |  | lisabeth | 1 | 1 | 1 | 1 |  | inge
[NAME] | isabelle |  |  | 1 | 1 | 1 | 1 |  | leen
 |  |  |  | 1 | 1 | 1 | 1 |  | hilke
 |  |  |  | 1 | 1 | 1 | 1 |  | isabelle
 |  |  |  | 1 | 1 | 1 | 1 |  | [NAME]
 |  |  |  | 1 | 1 | 1 | 1 |  | george
 |  |  |  | 1 | 1 | 1 | 1 |  | tine
 |  |  |  | 1 | 1 | 1 | 1 |  | joost
 |  |  |  | 1 | 1 | 1 | 1 |  | [NAME]
 |  |  |  | 1 | 1 | 1 | 1 |  | filip
 |  |  |  | 1 | 1 | 1 | 1 |  | [NAME]
 |  |  |  | 1 | 1 | 1 | 1 |  | elise
 |  |  |  | 1 | 1 | 1 | 1 |  | [NAME]
 |  |  |  |  |  |  |  |  | ann-sophie
 |  |  |  |  |  |  |  |  | ine
 |  |  |  |  |  |  |  |  | lore
 |  |  |  |  |  |  |  |  | hannelore
 |  |  |  |  |  |  |  |  | lisabeth
Spreadsheet: 760287d1640119355-find-multiple-matches-test-match
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sleepers | Uniques | Repeaters
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Spin Ct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # of [NAME] | # of Max-1 | Max-2 | #Max-3
30 |  |  | 1 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 0 | 1
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
25
21
7
7
36
4
15
20
36
10
11
31
12
21
10
15
23
3
13
34
16
21
0
26
4
14
20
29
17
4
1
3
3
15
0
31
8
15
26
31
26
3
24
25
23
26
32
26
36
0
22
10
28
24
6
3
15
4
21
22
31
4
2
3
34
8
24
6
13
25
20
34
20
9
10
19
35
9
18
33
14
36
11
8
24
12
10
36
28
17
21
33
14
20
28
0
22
13
21
9
7
21
30
7
21
30
4
14
23
4
34
2
9
25
31
13
15
8
7
24
20
7
33
27
32
23
23
17
20
21
2
24
1
32
8
6
1
23
13
21
33
2
36
12
28
27
15
21
26
18
23
6
25
21
5
6
20
23
6
28
30
6
30
6
26
16
17
19
25
21
15
36
14
29
4
6
31
8
24
16
6
33
14
36
14
33
0
4
21
28
34
9
30
4
2
28
29
24
13
3
0
0
27
31
3
29
3
11
1
28
16
6
26
27
20
28
27
8
10
2
31
29
8
33
25
33
36
14
15
34
31
25
1
5
16
2
34
35
12
17
30
30
2
28
16
26
25
20
0
23
1
36
16
35
28
30
16
9
3
28
13
36
13
31
0
34
23
24
23
18
27
31
17
1
9
26
34
14
8
35
26
9
29
16
23
30
5
18
33
0
25
26
25
12
7
9
15
9
33
36
36
22
12
16
32
0
4
31
22
27
28
17
34
18
28
10
17
32
34
10
29
20
2
13
35
23
18
18
13
Spreadsheet: 797571d1663958140-auto-populating-cells-based-on-data-entry-auto-fill-test
Sheet: Sheet1

3x7
month | units | cost/unit | repai cost |  | total cost | repair cost |  | we have 6 rows, therefore 6 rows worth of calculations will populate withou dragging.
june | 2 | 10 | 2
july | 4 | 20 | 4
august | 6 | 30 | 5
sep | 8 | 40 | 2
oct | 10 | 50 | 1
nov | 12 | 60 | 5
Spreadsheet: benjamin_rogers__1138__unit performance data version1
Sheet: Wheatland

 |  | Unit 1 | Unit 2 | Unit 3 | Unit 4
Life-to-Date Run Hours |  | 97.8 | 116.9 | 132 | 60.5
Life-to-Date Starts |  | 46 | 44 | 34 | 24
Performance Test Data
Output (MW) | Corrected to 90 F | 119.4 | 120.2 | 116.1 | 119.2
Heat Rate (LHV) | Corrected to 90 F | 10540 | 10451 | 10465 | 10433
[NAME] (ppm) | Corrected to 90 F | 23 | 24.3 | 22.3 | 23.7
Spreadsheet: 848892d1699507391-formulation-to-get-summary-sample
Sheet: Sheet1

 | Weight |  |  |  |  |  | Summary |  |  |  |  | Price |  |  |  |  |  | Quantity
 | a | b | c | d | e | f | D | E | F | G |  |  | D | E | F | G |  | D | E | F | G
 | 0.15 | 0.34 | 0.65 | 0.234 | 0.78 | 0.23 |  |  |  |  |  | a | 3 | 6 | 7 | 7 |  | 120 | 140 | 180 | 111
 | 0.54 | 0.78 | 0.575 | 0.969 | 0.876 | 0.787 |  |  |  |  |  | b | 5 | 6 | 6 | 6 |  | 435 | 235 | 23 | 123
 | 0.786 | 0.098 | 0.546 | 0.273 | 0.433 | 0.12 |  |  |  |  |  | c | 1 | 3 | 4 | 4 |  | 67 | 457 | 36 | 36
 | 0.453 | 0.986 | 0.222 | 0.246 | 0.278 | 0.274 |  |  |  |  |  | d | 1 | 10 | 9 | 9 |  | 235 | 45 | 34 | 436
 |  |  |  |  |  |  |  |  |  |  |  | e | 1 | 4 | 7 | 7 |  | 67 | 457 | 36 | 36
 |  |  |  |  |  |  |  |  |  |  |  | f | 6 | 3 | 2 | 2 |  | 235 | 45 | 34 | 436
 | Result Required in Blue Cells with following combination
 | a(Weight)*a(Price)*Quanity |  |  |  |  | As per D,E,F & G column.
Spreadsheet: 490515d1479905887-sheet-auto-populate-based-on-input-values-example
Sheet: Sheet1

Cost type | 2016-01-01 00:00:00 |  |  | 2016-02-01 00:00:00 |  |  | 2016-03-01 00:00:00 |  |  | 2016-04-01 00:00:00
 | Budget | Forecast | Actual | Budget | Forecast | Actual | Budget | Forecast | Actual | Budget | Forecast | Actual
Maintenance
Start date | 2016-01-01 00:00:00
End date | 2016-04-01 00:00:00
Spreadsheet: 816988d1675936978-formula-to-generate-average-price-sample-code
Sheet: Sheet2

Product | A | B | C | D
Volume % | 0.05 | 0.5 | 0.4 | 0.05 |  |  | Total Volume | 100000 | units
Volume units
Avg. Price |  | 0 |  | 0.1 |  |  | The average Price of all Producs is £1.00
 |  |  |  |  |  |  | Price of Product A, is Product B plus £0.05
Sales |  |  |  |  |  |  | Price of Product C, is Product B less £0.10
 |  |  |  |  |  |  | Total Sales
We know the correct price for Product B is approx £1.09. |  |  |  |  |  |  | Avg. Price
Just need a formula that will work this out automatically.
Spreadsheet: 72474d1273157525-if-and-then-statements-test
Sheet: Sheet1

Y | 0.1 | 1 |  | N | 0
Y | 0.05 | 1 |  | Y | 0.25 |  |  |  |  |  |  | Y | 0.05 |  | Y | 0.75
Y | 0.2 | 1 |  | Y | 0.25 |  |  |  |  |  |  | N | 0 |  | N | 0
Y | 0.15 | 1 |  | Y | 0.25 |  |  |  |  |  |  | N/A | 0.05 |  | N/A | 0.75
Y | 0.35 | 1
Y | 0.1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Y | 1
Y | 0.2 | 1 |  |  |  |  |  |  |  |  |  | Y | 0.1 |  | N | 0
Y | 0.2 | 1 |  |  |  |  |  |  |  |  |  | N | 0 |  | N/A | 1
Y | 0.25 | 1 |  |  |  |  |  |  |  |  |  | N/A | 0.1
 |  |  | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Y | 0
 | 1.6 |  |  |  |  |  |  |  |  |  |  | Y | 0.15 |  | N | 0.35
 |  | 9 |  |  |  |  |  |  |  |  |  | N | 0 |  | N/A | 0
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.15
Y | 0.1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Y | 0.35
Y | 0.1 | 1 |  |  |  |  |  |  |  |  |  | Y | 0.2 |  | N | 0
Y | 0.5 | 1 |  |  |  |  |  |  |  |  |  | N | 0 |  | N/A | 0.35
Y | 0.2 | 1 |  |  |  |  |  |  |  |  |  | N/A | 0.2
Y | 0.15 | 1 | 1 | 0.25 | 1 | 1.05
 | 1.05 | 5 |  |  |  |  |  |  |  |  |  | Y | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | N | 0
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.25
Y | 0.1 | 1
N | 0.05 | 1 |  |  |  |  |  |  |  |  |  | Y | 0.3
Y | 0.05 | 1 |  |  |  |  |  |  |  |  |  | N | 0
Y | 0.1 | 1 |  |  |  |  |  |  |  |  |  | N/A | 0.3
Y | 0.1 | 1
N | 0.15 | 1 |  |  |  |  |  |  |  |  |  | Y | 0.55
N | 0.1 | 1 |  |  |  |  |  |  |  |  |  | N | 0
N | 0.05 | 1 |  |  |  |  |  |  |  |  |  | N/A | 0.55
N | 0.05 | 1
N | 0.35 | 1 |  |  |  |  |  |  |  |  |  | Y | 0.5
Y | 0.15 | 1 | 1 | 0.25 | 1 | 1.25 |  |  |  |  |  | N | 0
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.5
 | 1.25 | 11
 |  |  |  |  |  |  |  |  |  |  |  | Y | 0
 |  |  |  |  |  |  |  |  |  |  |  | N | 0.1
Y | 0.35 | 1 |  |  |  |  |  |  |  |  |  | N/A | 0.1
Y | 0.75 | 1 | 1 | 0.25 | 1 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  | Y | 0
 | 1.1 | 2 |  |  |  |  |  |  |  |  |  | N | 0.15
 | 5 |  |  | 0.75 |  |  |  |  |  |  |  | N/A | 0.15
 | 1
 | 0.9999999999999998 |  |  |  |  |  |  |  |  |  |  | Y | 0
 |  |  |  | 3.4 |  |  |  |  |  |  |  | N | 0.2
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.2
N |  |  |  | 3.4
 |  |  |  |  |  |  |  |  |  |  |  | Y | 0
 |  |  |  |  |  |  |  |  |  |  |  | N | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | Y | 0
 |  |  |  |  |  |  |  |  |  |  |  | N | 0.05
 |  |  |  |  |  |  |  |  |  |  |  | N/A | 0.05
 | 0.02
Spreadsheet: 768660d1645069794-find-the-average-based-on-color-filled-cell-betatest
Sheet: Sheet1

 |  |  |  | Date: | date
Last Name | First Name | SPED | Non-English Speaking | TELPAS | (Standard) Skill
 | [NAME] | Y | N |  | No
 | Abijoy | N | N |  | Y
 | Ana | N | N |  | 0
 | Andres | N | Y | Adv | Y
 | Aqeel | N | N |  | Y
 | Arielle | N | N |  | 0
 | [NAME] | N | N |  | No
 | [NAME] | N | N |  | No
 | [NAME] | N | Y | AdH | Y
 | Camila | N | N |  | Y
 | Daleyza | N | Y | Adv | No
 | Damian | N | Y | NA | Y
 | [NAME] | N | N |  | Y
 | [NAME] | N | N |  | Y
 | [NAME] | N | N |  | Y
 | [NAME] | N | Y | NA | Y
 | Emily | N | Y | Adv | Y
 | [NAME] | N | Y | Adv | No
 | Josue | N | N |  | Y
 | Jovian | N | N |  | Y
 | Katarina | N | N |  | Y
 | [NAME] | N | N |  | Y
 | Lucas | N | N |  | Y
 | Makayla | N | N |  | Y
 | Maxine | N | N |  | Y
 | Natali | N | N |  | Y
 | Natasha | N | Y | Int | Y
 | [NAME] | N | N |  | Y
 | Rebecca | N | Y | Adv | Y
 | Sofia | N | Y | Adv | Y
 | Yezmin | N | Y | Int | Y
Spreadsheet: michael_maggi__26457__NYMEXWEEKLY
Sheet: hu

Week Ending: | 2001-11-09 00:00:00
 | Futures Settlement Prices
 | UNLEADED GASOLINE |  |  |  |  | Contract Symbol:  [NAME]
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 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 | Interest
 | 2001-12-01 00:00:00 | 0.5757 | 0.5801 | 0.5337 | 0.4884 | 0.5022 | 30665
 | 2002-01-01 00:00:00 | 0.5843 | 0.5888 | 0.5436 | 0.4975 | 0.511 | 20199
 | 2002-02-01 00:00:00 | 0.5938 | 0.5983 | 0.5541 | 0.509 | 0.5213 | 8319
 | 2002-03-01 00:00:00 | 0.6038 | 0.6088 | 0.5656 | 0.5213 | 0.5338 | 10804
 | 2002-04-01 00:00:00 | 0.6618 | 0.6668 | 0.6251 | 0.5823 | 0.5948 | 11897
 | 2002-05-01 00:00:00 | 0.6658 | 0.671 | 0.6296 | 0.5883 | 0.6008 | 12762
 | 2002-06-01 00:00:00 | 0.6648 | 0.67 | 0.6301 | 0.5898 | 0.6023 | 7979
 | 2002-07-01 00:00:00 | 0.6613 | 0.6657 | 0.6266 | 0.5878 | 0.6003 | 5984
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 116837
 |  |  |  | Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Unleaded Gas
 | 5 Day Hist. Vol. |  |  | 0.9758
 | 20 Day Hist. Vol. |  |  | 0.6175
 | Implied Volatility-Options |  |  | Unleaded Gas
 | At the Money Call & Put |  |  | 0.4794
 | MON | TUE | WED | THUR | FRI | Total
Volume | 24240 | 33696 | 36598 | 36549 | 29350
Spreadsheet: 748960d1632426949-selective-lookup-help-example
Sheet: Sheet1

REPORT: | D4MJ00-01H | A | C | E | H | A | R | D | W | A | R | E | C
RSC: | H | EMPLOYEE | DOCUMENT | PERFORMANCE | REPORT | PAGE: | 1
 | DATE | FILLED: | 2021-09-22 00:00:00
 | SHIFT: | 1
 | FILLER | LOGON-ID: | ALAN
 | FILLER | NAME: | ALAN | DOE
 | ACTUAL | REQUESTED | APPROVED | APPROVED | DOCUMENT
 | AREA | DOCUMENT | DOCUMENT | DOCUMENT | STANDARD | TIME | ON | NON-STANDARD | NON-STANDARD | TIME | ON | STANDARD
 | NUMBER | NUMBER | START | TIME | FINISH | TIME | MINUTES | STANDARD | TIME | TIME | STANDARD | PERCENTAGE
 | ------ | -------- | ------------- | -------------- | -------- | -------- | ------------ | ------------ | -------- | ----------
 | 54 | 715 | 06:29:09 | A.M. | 06:48:32 | A.M. | 37.7 | 19.4 | 0 | 0 | 19.4 | 194.4 | %
 | 54 | 716 | 06:48:32 | A.M. | 07:09:41 | A.M. | 27 | 21.2 | 0 | 0 | 21.2 | 127.6 | %
 | 54 | 791 | 07:09:41 | A.M. | 07:31:13 | A.M. | 23.9 | 21.5 | 0 | 0 | 21.5 | 110.9 | %
 | 54 | 790 | 07:31:13 | A.M. | 07:42:08 | A.M. | 16.5 | 10.9 | 0 | 0 | 10.9 | 150.9 | %
 | 54 | 7005 | 07:42:08 | A.M. | 07:55:22 | A.M. | 17.1 | 13.2 | 0 | 0 | 13.2 | 128.9 | %
 | 54 | 717 | 07:55:22 | A.M. | 08:14:49 | A.M. | 30.4 | 19.5 | 0 | 0 | 19.5 | 156.5 | %
 | 54 | 792 | 08:14:49 | A.M. | 08:35:24 | A.M. | 23.9 | 20.6 | 0 | 0 | 20.6 | 116.3 | %
 | 54 | 766 | 08:35:24 | A.M. | 09:15:18 | A.M. | 20.8 | 39.9 | 18.4 | 18 | 21.9 | 94.9 | %
 | 54 | 763 | 09:15:18 | A.M. | 09:18:58 | A.M. | 5.1 | 3.7 | 0 | 0 | 3.7 | 138.2 | %
 | 54 | 765 | 09:18:58 | A.M. | 09:35:21 | A.M. | 23.5 | 16.4 | 0 | 0 | 16.4 | 143.6 | %
 | 54 | 767 | 09:35:21 | A.M. | 10:08:34 | A.M. | 35.1 | 33.2 | 0 | 0 | 33.2 | 105.6 | %
 | 54 | 786 | 10:08:34 | A.M. | 10:22:15 | A.M. | 15.4 | 13.7 | 0 | 0 | 13.7 | 112.7 | %
 | 54 | 787 | 10:22:15 | A.M. | 10:36:50 | A.M. | 22.2 | 14.6 | 0 | 0 | 14.6 | 152.5 | %
 | 54 | 788 | 10:36:50 | A.M. | 11:01:31 | A.M. | 33 | 24.7 | 0 | 0 | 24.7 | 133.7 | %
 | 54 | 827 | 11:01:31 | A.M. | 11:20:04 | A.M. | 22.3 | 18.6 | 0 | 0 | 18.6 | 120.3 | %
 | 54 | 722 | 11:20:04 | A.M. | 11:25:18 | A.M. | 10.8 | 5.2 | 0 | 0 | 5.2 | 205.8 | %
 | 54 | 828 | 11:25:18 | A.M. | 11:39:11 | A.M. | 18.8 | 13.9 | 0 | 0 | 13.9 | 135.7 | %
 | 54 | 825 | 11:39:11 | A.M. | 11:59:36 | A.M. | 25.2 | 20.4 | 0 | 0 | 20.4 | 123.3 | %
 | 54 | 7022 | 11:59:36 | A.M. | 12:03:40 | P.M. | 4.4 | 4.1 | 0 | 0 | 4.1 | 108 | %
 | 50 | 648 | 12:03:40 | P.M. | 01:18:12 | P.M. | 43.2 | 74.5 | 0 | 0 | 74.5 | 58 | %
 | 50 | 697 | 01:18:12 | P.M. | 02:00:24 | P.M. | 44.9 | 42.2 | 0 | 0 | 42.2 | 106.5 | %
 | TOTALS: | 21 | 501.3 | 451.2 | 18.4 | 18 | 433.2 | 115.7 | %
GRAND | TOTALS: | 21 | 501.3 | 451.2 | 18.4 | 18 | 433.2 | 115.7 | %
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 57

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
57 | 2007-02-19 00:00:00 | 8 | 0.46 | 2.5 | 1 | 1.7 | 2 |  |  |  | 1.5 |  | 1.817376445004486 | 1.3 | 0 | 4 |  |  |  |  | 0.3
Well #57 | 2013-10-11 00:00:00 | 7.6 | 0.93 | 4.61 | 1.86 | 2 | 2.5 |  |  | 0.3 | 5.6 |  | 1.1 | 2.3 | 0.05 | 1.7 |  | <0.10 | <0.02 |  | 0.3
Well - 57 | 2014-01-28 00:00:00 | 8.3 | 1.12 | 5.73 | 2.33 | 2.3 | 2.3 |  |  | 0.3 | 8 |  | 1.2 | 2.4 | 0.03 | 1.8 |  | <0.10 | <0.02 |  | 0.6
Well 57 | 2015-03-24 00:00:00 | 7.6 | 1.03 | 5.03 | 2.07 | 1.9 | 2.5 |  |  | 0.4 | 7.1 |  | 1 | 2.1 | <0.05 | 1.6 |  | <0.10 | <0.02 |  | 0.3
Well 57 | 2016-04-01 00:00:00 | 7.91 | 1.202 | 6.31 | 2.61 | 2.33 | 2.427863480137479 | 2.427863480137479 | 0 | 0.493 | 8.6699 | 768 | 1.1 | 2.2 | 0 | 2.1278 | 0.018 | 0.017 | 0.006 | 0.044
W57 | 2018-05-30 00:00:00 | 7.57 | 1.06 | 5.81 | 2.45 | 2.62 |  | 2.108144832547358 | 0 | 0.536 | 7.151 | 678 |  |  | 0.052 | 1.668 | 0.032 | 0.381 | 0.028 | 0.01
Spreadsheet: 613451ab-348a-4932-b143-2c3e10964aed
Sheet: TIG Cohort 4 Yr 1

Grant: |  | Tiered Intervention Grant Cohort 4
CFDA # |  | 84.377
GRANT NUMBER: |  | 737
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724 or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - Septebmer 15, 2014
Code | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
0022-S | [NAME] | 498181 |  |  |  |  |  |  | 60090 | 44762 | 40692 | 42377
1458-S | [NAME] | 1070778 |  |  |  |  |  |  | 130588 | 66436 |  | 170887
5388-S | [NAME] | 836022 |  |  |  |  |  | 18935 | 71641 | 154800 | 68211 | 33887
6350-S | [NAME] | 508200 |  |  |  |  |  |  |  |  |  | 109523
9085-S | [NAME] | 20995
Spreadsheet: 790185d1659583601-10-day-rolling-values-on-chart-book1-12-ans-2
Sheet: Sheet1

2022-01-01 00:00:00 | 45 |  | Enter date | 2022-01-14 00:00:00
 | 66
 | 36
 | 27
 | 11 |  | =OFFSET(INDEX(Sheet1!$A$1:$A$35,MATCH(Sheet1!$E$1,Sheet1!$A$1:$A$35,0)),0,0,-10)
 | 63 |  | =OFFSET(INDEX(Sheet1!$B$1:$B$35,MATCH(Sheet1!$E$1,Sheet1!$A$1:$A$35,0)),0,0,-10)
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
Spreadsheet: 54471d1254449555-how-do-you-lookup-the-correct-cell-with-3-of-the-same-name-in-1-worksheet-depttotalmod
Sheet: Sheet1

 |  | A |  | B | C | D |  |  | Fruit |  | Sales | Refunds | Total
1 | 0 | Chocolate |  | Sales | Refunds | Total |  |  |  | Dept Total: | 2 | 0 | 2
2 | 0 | Snickers |  | 1 | 0 | 1
3 | 0 | Mars |  | 1 | 0 | 1
4 | 0 | [NAME] |  | 1 | 0 | 1
5 | 0 | Crunchie |  | 1 | 0 | 1
6 | 0 | Beuno |  | 1 | 1 | 0
7 | 0 | Dept Total: |  | 5 | 1 | 4
8 | 0
9 | 1 | Fruit |  | Sales | Refunds | Total
10 | 1 | Apple |  | 1 | 0 | 1
11 | 1 | Pears |  | 1 | 0 | 1
12 | 1 | Dept Total: |  | 2 | 0 | 2
13 | 2
14 | 2 | Drinks |  | Sales | Refunds | Total
15 | 2 | Coke |  | 2 | 1 | 1
16 | 2 | Pepsi |  | 1 | 0 | 1
17 | 2 | Dept Total: |  | 3 | 1 | 2
 | 2
Spreadsheet: 58312d1258578393-multiple-date-based-sumproduct-failing-example
Sheet: SHEET 2

Week End | Circuit | Completed
2009-11-01 00:00:00 | 20 | 0.2
2009-11-02 00:00:00 | 20 | 0.2
2009-11-03 00:00:00 | 20 | 2.7
2009-03-07 00:00:00 | 333 | 10
2009-03-07 00:00:00 | 468 | 6.9
2009-03-07 00:00:00 | 549 | 0.2
2009-03-14 00:00:00 | 304 | 3.1
2009-03-14 00:00:00 | 305 | 2
Spreadsheet: 586965d1534772459-how-to-remove-cell-if-it-contains-certain-text-book6-3-
Sheet: Sheet1

Today | I | Is
Null | need | this
is | Null | what
Null | more | Null
Null | Null | you
Monday | coffee | want?