tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820403d1678093521-recurring-bill-payment-amounts-between-salary-dates-recurring-bill-payments
Sheet: Sheet1

 | [NAME]
 | Pay Period 1 | Pay Period 2 | Pay Period 3 | Pay Period 4 | Pay Period 5 | Pay Period 6
 | 2023-01-06 00:00:00
 | Total | Total | Total | Total | Total | Total
 | Bills (example) | Due Date | Payment Amt
 | [NAME] | 2023-01-09 00:00:00 | 50
 | [NAME] | 2023-01-19 00:00:00 | 25
 | [NAME] | 2023-01-25 00:00:00 | 100
 | [NAME] | 2023-02-01 00:00:00 | 200
 | Bill 5 | 2023-02-15 00:00:00 | 30
 | Bill 6 | 2023-02-22 00:00:00 | 20
 | [NAME] | 2023-02-28 00:00:00 | 10
 | [NAME] | 2023-03-01 00:00:00 | 40
 | Bill 9 | 2023-03-19 00:00:00 | 50
 | Bill 10 | 2023-03-22 00:00:00 | 90
 | I'm trying to find a way to calculat a reacurring bill by due dates for every pay period where the due date is after or equal to, lets say, Feb 17th bue before Mar 3
 | The trouble I'm having is finding the formula for performing the same bill sum for each month, regarldess of what year it is…as long as its recurring.
Spreadsheet: 824852d1680892251-how-do-you-copy-an-array-formula-down-a-column-while-changing-one-value-comparison_table
Sheet: Summary

Records | Name | SheetNames
 |  | Adam
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Lander
 |  | [NAME]
Spreadsheet: 700227d1603077897-formula-help-sumif-with-multiple-conditions-sumif-multiple-conditions-v2
Sheet: Sheet1

 |  |  |  |  |  |  | [NAME] in coloured cells |  |  |  | Desired Answers
Sumtotal of Column D values- only if  there are values > 0 assigned in Column E and only if "yes" in Column L |  |  |  |  |  |  |  |  |  |  | 8878
Sum of column  E values - only if  there are values assigned in Column D and only if "yes" in Column L
Sum of column Q values- only if "no" in Column R and "yes" in Column M |  |  |  |  |  |  |  |  |  |  | 3014.21
LOOK UP TABLE
 | Location Name | Lease Name  (if applicable) | Area (m²) | LMW Valuation ($) without adjustment | % Land Value Used For Tax Calculation | Valuation ($) after adjustment | Thr. 1  Charge ($) | Thr. 2  Charge ($) | Base  Charge ($) | Charge ($) | Liable ? | Recoverable? | Adjustment - % of Charge Applied (%) | Total payable | % of Charge Recoverable | Total Recoverable | Abated
 |  | Tenant A | 1069 | 73761 | 1 |  |  |  |  |  | 0 | 0 | 1 |  | 0 |  | 0
 |  | Tenant B | 4954 | 807502 | 1 |  |  |  |  |  | 0 | 0 | 1 |  | 0 |  | 0
 |  | Tenant C | 895.6 | 510492 | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 0
 |  |  | 450.1 | 256557 | 1 |  |  |  |  | 5000 | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 822.8 | 468996 | 1 |  |  |  |  |  | 1 | 0 | 1 |  | 0 |  | 0
 |  |  | 420.7 | - | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 0
 |  |  | 655.61 | 373697.7 | 1 |  |  |  |  | 2000 | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 1082.3 | 176414.9 | 1 |  |  |  |  |  | 0 | 0 | 1 |  | 0 |  | 0
 |  |  | 2975 | 755650 | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 0
 |  |  | 556.9 | 0 | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 1435 | 364490 | 1 |  |  |  |  |  | 0 | 0 | 1 |  | 0 |  | 0
 |  |  | 3497 |  | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 0
 |  |  | 2854 | 724916 | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 224.8 | 36642.4 | 1 |  |  |  |  |  | 1 | 0 | 1 |  | 1 |  | 0
Spreadsheet: 275129d1383334636-mutliple-tables-on-1-sheet-testcopyofqr-bvj-
Sheet: Sheet2

VOICE OF THE CUSTOMER
Date |  |  | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | Installer Total | ALL HVAC PROVIDERS IVOC
INSTALLER OVERALL |  |  | 9.45 | 9.6 | 8.9 | 10 | 5.6 | 9.45 | 9.57 | 9.54
INSTALLER ON TIME |  |  | 9.6 | 9.2 | 5.6 | 10 | 9.8 | 9.6 | 9.78 | 9.69
INSTALLER COURTESY |  |  | 9.2 | 8.9 | 9.8 | 5.2 | 5.2 | 9.2 | 9.8 | 9.72
INSTALLER CARE |  |  | 8.9 | 5.6 | 5.2 | 9.9 | 7.9 | 8.9 | 9.67 | 9.65
INSTALLER APPEARANCE |  |  | 5.6 | 9.8 | 7.9 | 9.7 | 10 | 5.6 | 9.75 | 9.7
INSTALLER CLEANUP |  |  | 9.8 | 5.2 | 10 | 9.6 | 10 | 9.8 | 9.63 | 9.68
INSTALLER REVIEW PROJECT |  |  | 5.2 | 7.9 | 10 | 9.9 | 5.2 | 5.2 | 9.62 | 9.64
INSTALLER COMPLETE ON TIME |  |  | 7.9 | 10 | 5.2 | 9.7 | 9.9 | 7.9 | 9.76 | 9.67
INSTALLER INFORMING |  |  | 10 | 10 | 9.9 | 9.6 | 9.7 | 10 | 9.64 | 9.61
WORKMANSHIP OVERALL |  |  | 10 | 5.2 | 9.7 | 10 | 9.6 | 10 | 9.57 | 9.51
COMMUNICATION OVERALL |  |  | 5.2 | 9.9 | 9.6 | 5.2 | 9.9 | 5.2 | 9.19 | 8.98
AFTER SALES SVC OVERALL |  |  | 9.9 | 9.7 | 9.9 | 9.9 | 9.7 | 9.9 | 9.4 | 9.27
ISSUE OCCURRED |  |  | 9.7 | 9.6 | 9.7 | 9.7 | 9.6 | 9.7 | 11 | 2640
SURVEY COUNT |  |  | 9.6 | 9.6 | 9.6 | 9.6 | 10 | 9.6 | 150 | 27055
Spreadsheet: 76123d1276693457-excel-2007-data-validation-temp
Sheet: LISTS

 | CAB
 | DAB
 | DAC
 | DAE
 | DAG
 | DAH
 | DAJ
 | DJB
 | DJE
 | DJG
 | DJJ
 | FAB
 | FAC
 | FAE
 | FAG
 | FBB
 | FBE
 | GAB
 | GAD
 | GAJ
 | HAB
 | HAD
 | HAF
 | HAG
 | HAH
 | HAJ
 | HAK
 | HAL
 | HBE
 | HBG
 | HBH
 | HBM
 | HCG
 | HCL
 | HDJ
 | HFE
 | HFG
 | HJE
 | HJG
 | HKE
 | HKG
 | HKH
 | HKM
 | HLB
 | HLD
 | HLG
 | HLH
 | HLJ
 | HLL
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 | 6188 | 6546 | 3125 | 2754
2 | 6334 | 6546 | 1812 | 2733
3 | 6939 | 6546 | 2006 | 2738
4 | 6807 | 6295 | 2497 | 3004
5 | 6573 | 7471 | 903 | 3647
6 | 6768 | 7471 | 4368 | 3647
7 | 6935 | 7471 | 4015 | 3647
8 | 5156 | 7471 | 2736 | 3647
9 | 6608 | 7437 | 4783 | 3647
10 | 7241 | 7403 | 3618 | 3647
11 | 6667 | 7389 | 2891 | 3647
12 | 12863 | 7471 | 2671 | 3647
13 | 8057 | 7457 | 2295 | 3647
14 | 5798 | 7471 | 2648 | 3647
15 | 6590 | 7471 | 3194 | 3647
16 | 6633 | 7471 | 3458 | 3647
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  | -282710.67
2000-12-16 00:00:00
Spreadsheet: darrell_schoolcraft__7575__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 8

WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  |  | [NAME] (PAGER)
 | S2 | [NAME] | S5 | HOLCOLM | S2 | [NAME] | S5 | S2, S4 & S5 | TOTAL
HOUR | MWH | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 |  | 0 | 0 | 6.75 | 0
10:00:00 |  | 0 | 0 | 6.75 | 0
11:00:00 |  | 0 | 0 | 6.75 | 0
12:00:00 |  | 0 | 0 | 6.75 | 30
13:00:00 |  | 0 | 0 | 6.75 | 30
14:00:00 |  | 0 | 0 | 6.75 | 30
15:00:00 |  | 0 | 0 | 6.75 | 325
16:00:00 |  | 0 | 0 | 6.75 | 325
17:00:00 |  | 0 | 0 | 6.75 | 325
18:00:00 |  | 0 | 0 | 6.75 | 325
19:00:00 |  | 0 | 0 | 6.75 | 325
20:00:00 |  | 0 | 0 | 6.75 | 325
21:00:00 |  | 0 | 0 | 6.75 | 325
22:00:00 |  | 0 | 0 | 6.75 | 325
23:00:00 |  | 0 | 0 | 6.75 | 325
1900-01-01 00:00:00 |  | 0 | 0 | 6.75 | 90
1900-01-01 01:00:00 |  | 0 | 0 | 6.75 | 30
1900-01-01 02:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 03:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 04:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 05:00:00 |  | 0 | 0 | 6.75 | 75
1900-01-01 06:00:00 |  | 0 | 0 | 6.75 | 100
1900-01-01 07:00:00 |  | 0 | 0 | 6.75 | 200
1900-01-01 08:00:00 |  | 0 | 0 | 6.75 | 325
DAILY
TOTAL
Spreadsheet: 759835d1639755422-formatting-multiple-cells-at-once-help
Sheet: Sheet1

Date | Time Frame |  | Dispatch | Arrive | Complete |  | Essentially, I need the cells in column E formatted to show red if they are greater than the cells in column B. Helping me highlight when our [NAME] time is greater than our 1st time frame number.
2021-12-01 00:00:00 | 14:00:00 |  | 16:17:00 | 14:57:00 | 15:12:00
2021-12-01 00:00:00 | 10:00:00 |  | 13:26:00 | 13:54:00 | 14:14:00
2021-12-01 00:00:00 | 08:00:00 |  | 08:59:00 | 09:32:00 | 10:00:00
2021-12-01 00:00:00 | 10:00:00 |  | 10:01:00 | 10:33:00 | 11:13:00
2021-12-01 00:00:00 | 08:00:00 |  | 08:42:00 | 09:06:00 | 09:57:00
2021-12-01 00:00:00 | 10:00:00 |  | 12:09:00 | 12:37:00 | 14:19:00
2021-12-01 00:00:00 | 16:00:00 |  | 16:15:00 | 16:25:00 | 18:10:00
2021-12-01 00:00:00 | 08:00:00 |  | 08:41:00 | 09:03:00 | 12:06:00
Spreadsheet: 873348d1719852458-calculate-the-month-using-last-working-day-of-the-year-test-last-working-day
Sheet: Sheet1

2024-12-31 00:00:00 |  | If cell (A1) date is last working day of the Year, then C2= A1 Month+3, Else C2= A1 Month+2
 | Date | Result
Example | 2024-12-31 00:00:00 | Mar 25 |  | 2025-01-01 00:00:00
 | 2024-12-30 00:00:00 | Feb 25
 | 2025-03-01 00:00:00 | Mar 25
 |  |  |  |  |  |  | WORKDAY(DATE(YEAR(NOW()),1,1),-1)
Spreadsheet: 60993d1261574891-excel-2007-count-between-two-time-ranges-shift
Sheet: Sheet1

Name | Start | End |  | Start | End | Count
[NAME] | 06:00:00 | 14:00:00 |  | 06:00:00 | 07:00:00 | 1
tom | 07:00:00 | 15:00:00 |  | 07:00:00 | 08:00:00 | 2
hary | 09:00:00 | 17:00:00 |  | 08:00:00 | 09:00:00 | 2
 |  |  |  | 09:00:00 | 10:00:00 | 3
Spreadsheet: acea2b3c-04d9-4a2d-8d5a-a1168f7aaf9f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Teenusekasutajatega tegelevad põhitöötajad erihoolekandeteenuseid osutavates asutustes, 2003-2010
([NAME])
 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
[NAME] | 969 | 993 | 1016 | 1078 | 1133 | 1218 | 1330 | 1358
Kasvataja | 21 | 8 | - | - | - | - | - | -
Hooldaja, abikasvataja, põetaja | 294 | 208 | 218 | 185 | 132 | 46 | 36 | 27
logopeed, eripedagoog | 1 | 2 | 1 | 5 | 13 | 10 | 11 | 15
Psühholoog, kutsenõustaja | 7 | 8 | 6 | 6 | 5 | 3 | 3 | 2
Füsioterapeut | 4 | 3 | 1 | 1 | 6 | 2 | 5 | 5
Tegevusterapeut või assistent | 14 | 10 | 9 | 9 | 6 | 3 | 8 | 5
[NAME] | 41 | 44 | 25 | 45 | 41 | 15 | 17 | 12
Tegevusjuhendaja | 435 | 521 | 540 | 612 | 736 | 970 | 1051 | 1111
Eriarst | 7 | 8 | 6 | 6 | 7 | 4 | 4 | 5
Õde | 116 | 112 | 100 | 98 | 95 | 82 | 86 | 85
Sotsiaaltöötaja | 22 | 21 | 21 | 25 | 27 | 26 | 34 | 20
Muud | 7 | 48 | 89 | 86 | 65 | 57 | 75 | 71
Märkide seletus
-     nähtust ei esinenud
Koostanud sotsiaalpoliitika [NAME]
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9904

April 1999 Transport Expense Flash
 |  |  | Commodity Expenses |  |  |  | Comments
Texas Co. 78 |  |  |  |  |  |  | Long term deal commodity expense
Texas Co. 16 |  |  | 6995.41 |  |  |  | payable to Black Marlin/NNGB - 96008034
Texas Co. 78 |  |  | 1200 |  |  |  | payable to Pan Grande Pipeline 96019628
Texas Co. 16 |  |  | 93547.201 |  |  |  | payable to Oasis Pipeline- 96015445
Texas Co. 16 |  |  |  |  |  |  | payable to PG&E/Valero 96006479/96006482/96009903/96011842/96016347
Texas Co. 16 |  |  | 6400 |  |  |  | payable to Channel Industries-96017837
Texas Co. 16 |  |  |  |  | 98300 |  | Centana Storage Demand Charge
 |  |  |  |  |  |  | ***booked as an annuity and is located in financial price
Totals
Spreadsheet: 816575d1675709978-using-countifs-to-count-how-many-values-below-a-n-value-in-range-with-blank-cells-countbook
Sheet: Sheet1

 |  | 2022-06-12 00:00:00 |  | 2022-06-23 00:00:00 |  | 5
 |  |  |  | COUNTIFS(A5:A22,">="&C$3,A5:A22,"<="&E$3,B$5:B$22,"<"&G3)
2022-06-12 00:00:00 | 4
2022-06-13 00:00:00 | 6
2022-06-14 00:00:00 | 10
2022-06-15 00:00:00 | 1
2022-06-16 00:00:00 | 19
2022-06-17 00:00:00
2022-06-18 00:00:00
2022-06-19 00:00:00 | 7
2022-06-20 00:00:00 | 1
2022-06-21 00:00:00 | 6
2022-06-22 00:00:00 | 2
2022-06-23 00:00:00 | 3
2022-06-24 00:00:00
2022-06-25 00:00:00
2022-06-26 00:00:00 | 11
2022-06-27 00:00:00 | 15
2022-06-28 00:00:00 | 10
2022-06-29 00:00:00 | 12
Spreadsheet: 864653d1711734928-excel-formula-dynamically-auto-fill-with-reference-column-filter
Sheet: Sheet1

Department | Country | Index
HR | Australia | 1
HR | Srilanka | 2 |  |  | Planning
Planning | India | 3
Planning | America | 4 |  |  | Country | Sum
Planning | UK | 5
Planning | Germany | 6 |  |  | America
Planning | Belguim | 7 |  |  | UK
Performance | Netherlands | 8 |  |  | Germany
Performance | France | 9 |  |  | Belguim
Performance | Poland | 10
Performance | Ireland | 11
Performance | Japan | 12
Performance | Austria | 13
Performance | Italy | 14
Performance | Swiss | 15
HR | Australia | 1
HR | Srilanka | 2
Planning | India | 3
Planning | America | 4
Planning | UK | 5
Planning | Germany | 6
Planning | Belguim | 7
Performance | Netherlands | 8
Performance | France | 9
Performance | Poland | 10
Performance | Ireland | 11
Performance | Japan | 12
Performance | Austria | 13
Performance | Italy | 14
Performance | Swiss | 15
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 9. SF by State 

FY 2013 Federal Real Property Charts
US Total Square Footage†
State | Owned SF** | Leased SF | Total SF
Alabama | 50143651.54 | 4896980
Alaska | 41452782.63 | 2518940.2
Arizona | 49991467.7 | 4298954.7
Arkansas | 21497511.76 | 1462187.43
California | 269024273.94 | 20605816.36
Colorado | 51591325.48 | 7447618.05
Connecticut | 12750007.6 | 972002
Delaware | 5829119.01 | 439164
District of Columbia | 69088751.26 | 26131708
Florida | 102053652.99 | 12935783.82
Georgia | 112928045.149 | 10595999.68
Hawaii | 46337262.69 | 1004703
Idaho | 16429329.99 | 1742853.49
Illinois | 62092941.76 | 5856472.26
Indiana | 26815350.846 | 2834557.76
Iowa | 14832227.08 | 1908880.83
Kansas | 30169079.03 | 3010292.47
Kentucky | 43811624.27 | 4825924.77
Louisiana | 39298097.46 | 4032276
Maine | 10604981.3 | 897150
Maryland | 109091147.85 | 23977315.26
Massachusetts | 31669407.112 | 3000942
Michigan | 22949367.88 | 5335208
Minnesota | 19440623.552 | 2466669
Mississippi | 39833972.31 | 2596078
Missouri | 45451527.13 | 11003729.01
Montana | 14765565.53 | 2294669.05
Nebraska | 13692461.24 | 1590995.16
Nevada | 25080996.05 | 2137527
New Hampshire | 4060043.07 | 633022
New Jersey | 41127687.58000001 | 4997627
New Mexico | 53779564.02 | 3808948.88
US Total Square Footage†- continued
State | Owned GSF** | Leased GSF | Total GSF
New York | 82071066.648 | 9128695
North Carolina | 86984171.85000001 | 5745913
North Dakota | 21783061.458 | 1103529.36
Ohio | 62278592.95 | 5576488.57
Oklahoma | 45455216.48 | 9309129.05
Oregon | 20391663.33 | 3103054
Pennsylvania | 71769891.51 | 9213628.23
Rhode Island | 13532868.59 | 599486
South Carolina | 48521081.398 | 2261494
South Dakota | 15924598.05 | 2075054.65
Tennessee | 53765306.34 | 3363067.32
Texas | 171099836.829 | 23821071.69
Utah | 27361399.63 | 2920332.36
Vermont | 3343961.49 | 1150124.78
Virginia | 149981710.43 | 29213187.15
Washington | 78928825.91 | 5731415.81
West Virginia | 20956853.38 | 2715888.49
Wisconsin | 20243492.26 | 2546407
Wyoming | 13219316.93 | 799049.67
Foreign and US Territory | 233769119.535 | 245351992.24
Total
† All real property data from the CFO Act agencies required to submit data to the FRPP
**includes federal government owned, museum trust, state government owned
Spreadsheet: benjamin_rogers__1036__Consolidated 6 Peaker- 051100-NewPrices
Sheet: New Albany

INCOME STATEMENT - NEW ALBANY
('000 $)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Revenue
Fixed Price Period:
Demand Payment
Energy Payment
Block Payment
Market Price & Price Extension Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Energy Margin | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes Liability | 487.9 | 486.5 | 484.5 | 476.4 | 467.3 | 451.3 | 427.8 | 402.5 | 362.4 | 878.3 | 695.3 | 494 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9
Admin Fees
Marketing Fee | 0 | 0 | 0
Debt Service Reserve [NAME]
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
New Albany Net Income
CASH FLOW - NEW ALBANY
Investor Interest
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -488.8
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
0
PV of EBITDA @
STATE TAXES - NEW ALBANY
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
[NAME]
Outstanding Debt
Shareholders Equity & Long Term Debt
State Fracnhise Tax Rate
State Franchise Tax Liability | 340.8706187257259 | 335.7125368317436 | 337.5172439491844 | 330.543993494631 | 332.3581773650407 | 333.6419616033877 | 334.6389632723628 | 336.1646137194323 | 337.0178458663954 | 336.7950286692232 | 332.3859324351092 | 325.1770519292617 | 316.5896372626627 | 306.7127634147973 | 295.7285674982093 | 287.5169928767356 | 277.5312340731299 | 261.6062168321918 | 243.7018007976637 | 223.6140271066298
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: EDF Energy

EDF Energy | (Gas & Electric)
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008 | 6
January | 2009 | 6
February | 2009
March | 2009 | 130
April | 2009 | 108
May | 2009 | 108
June | 2009 | 108
July | 2009 | 108
August | 2009 | 108
September | 2009 | 108
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 201468d1356005074-i-want-to-get-average-value-of-no-of-ro-s-raised-of-similar-part-number-book1
Sheet: Sheet1

PART | [NAME] | No of RO s raised | Average |  | PART | Unique Records | No of RO s raised
43 | DIRECTIONAL WATTMETER | 2 | 2 |  | 43 | DIRECTIONAL WATTMETER | 2
43 | DIRECTIONAL WATTMETER | 2 |  |  | 68 | THERMOMETER | 3
68 | THERMOMETER | 3 | 3 |  | 410 | X-RAY SURVEY MODEL METER | 8
68 | THERMOMETER | 3 |  |  | 714 | THERMOCOUPLE CALIBARATOR | 1
68 | THERMOMETER | 3 |  |  | 830 | [NAME] | 4
410 | X-RAY SURVEY MODEL METER | 8 | 8 |  | 878 | UNIVERSAL LCR METER | 3
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
410 | X-RAY SURVEY MODEL METER | 8
714 | THERMOCOUPLE CALIBARATOR | 1 | 1
830 | [NAME] | 4 | 4
830 | [NAME] | 4
830 | [NAME] | 4
830 | [NAME] | 4
878 | UNIVERSAL LCR METER | 3 | 3
878 | UNIVERSAL LCR METER | 3
Spreadsheet: 139551d1328295263-excel-2007-im-having-trouble-trying-to-get-an-alarm-to-show-30-days-prior-to-the-date-stuff
Sheet: Sheet1

UNIT | UIC | A/A | R/R | POC NUMBER
1 SFG | WH1DAA | 2012-03-21 00:00:00 | 2012-04-28 00:00:00 | 967-8676
HQ 1SFG | WDSLT0 |  | 2012-12-18 00:00:00 | 967-8869
GSC | WDSLA0 |  | 2012-12-18 00:00:00 | 967-8869
GSSC | WDSLB0 |  | 2012-12-18 00:00:00 | 967-8668
2-1 SFG | WH1FAA |  | 2012-07-26 00:00:00 | 967-8717
A Co 2-1 SFG | WH1FA0 |  | 2013-10-13 00:00:00 | 967-8772
C Co 2-1 SFG | WH1FC0 |  | 2012-10-10 00:00:00 | 9678772
3-1 SFG | WH56AA |  | 2012-02-28 00:00:00 | 967-8785
4-1 SFG | WJQ1AA |  | 2012-12-12 00:00:00 | 477-2569
A Co1-1 SFG | WH1EA0 |  | 2012-10-10 00:00:00 | 967-8744
4/160TH SOAR | WJMFAA | 2012-11-16 00:00:00 | 2012-10-30 00:00:00 | 966-8814
[NAME] | WH3MAA | 2012-02-14 00:00:00 | 2012-02-14 00:00:00 | 967-4608
MAMC | W0Q1AA | 2012-05-03 00:00:00 | 2012-10-25 00:00:00 | 968-4004
TRADOC/TASSD | W8FFAA | 2012-06-29 00:00:00 |  | (757) 788-2267
RTI-1021 | W8FFAA |  | 2012-08-09 00:00:00 | (253) 512-7822
RTI-249 | W8GQAA |  | 2012-09-30 00:00:00 | (503) 838-8585 ext 2
NCOA FT.LEWIS | W6QPAA |  | 2012-03-06 00:00:00 | 967-6581
[NAME] | W3ZBAA | 2012-03-10 00:00:00 | 2012-11-07 00:00:00 | 967-5040
UNIVERSITIES/ROTC
US ARMY CADET CMD | W0MTAA | 2012-09-30 00:00:00 |  | 967-9897
Warrior Forge, Cadet CMD | W0MTW7 |  | 2012-09-30 00:00:00 | 967-4976
Central Washington | W0MTNP |  | 2012-08-02 00:00:00 | (509) 963-3575
Eastern Washinton Univ | W0MTM1 |  |  | (509)359-6109
[NAME] | W0MTM2 |  | 2012-07-31 00:00:00 | (509) 313-6521
Washington State [NAME] | W0MTM3 |  | 2012-09-05 00:00:00 | (509) 335-6606
University of Washington | W0MTM4 |  | 2013-01-08 00:00:00 | (206) 543-9010
[NAME] | W0MTM5 |  | 2012-08-14 00:00:00 | (206) 296-5724
Pacific Lutheran Univ | W0MTU6 |  | 2012-10-16 00:00:00 | (253) 535-8459
University of Idaho | W0MTA8 |  | 2012-06-13 00:00:00 | (208) 885-6528
University of Portland | W0MTU3 |  | 2012-10-31 00:00:00 | (503) 943-8060
6th MP GROUP | WCTYAA | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 966-1391
22nd MP CID | WBZPAA | 2012-12-13 00:00:00 | 2012-12-13 00:00:00 | 967-7770
44th MP [NAME] | [NAME] |  | 2012-12-13 00:00:00 | 967-7839
393rd MP BN/315th MP | WQXDAA | 2012-04-25 00:00:00 | 2012-08-15 00:00:00 | 477-2382
191 INF | W1JZAA | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 967-8509
16TH CAB BDE | WGDPAA | 2012-12-14 00:00:00 | 2012-09-22 00:00:00 | 477-3373
4-6 Air Cavalry Sqdrn | WC12AA |  | 2012-12-14 00:00:00 | 966-6905
46TH ASB | WEW5AA |  | 2012-12-14 00:00:00 | 967-5826
2-158 AVB | WAX2AA |  | 2013-01-22 00:00:00 | 477-4774
CMTC | WAT399 | 2013-01-09 00:00:00 | 2013-01-09 00:00:00 | 966-6740
Spreadsheet: 153580d1335966574-excel-2007-need-a-chart-that-automatically-plots-new-data-when-it-is-entered-in-book1
Sheet: Daily Food

DAY | FOOD | UNITS | AMOUNT | CALORIES | TODAY | CALORIES SO FAR | CALORIES LEFT
2012-05-01 00:00:00 | Quaker Oat Squares |  | 1
2012-05-01 00:00:00 | [NAME] |  | 4
2012-05-01 00:00:00 | Tortilla Chips |  | 20
2012-05-01 00:00:00 | Apple sauce |  | 0.5
2012-05-01 00:00:00 | Hamburger Gravy |  | 1
2012-05-01 00:00:00 | Milk - 1% |  | 2.5
2012-05-01 00:00:00 | Nan's Cinnamon Cookie bites |  | 2
2012-05-01 00:00:00 | Calzone |  | 5
2012-05-02 00:00:00 | [NAME] |  | 1
2012-05-02 00:00:00 | Milk - 1% |  | 0.5
2012-05-02 00:00:00
2012-05-02 00:00:00
2012-05-02 00:00:00
2012-05-02 00:00:00
2012-05-02 00:00:00
Spreadsheet: 755022d1636641144-lookup-multiple-columns-to-return-value-example-list
Sheet: Sheet2

Acct No | Account | [NAME] | Dep | Value |  |  | Acct No | Account | [NAME] | Dep | Value
GW088036/1 | GW088036 | 1 | GHI | 0 |  |  | GW088244/1 | GW088244 | 1 | SP | 0
MW179521/1 | MW179521 | 1 | GHI | 0 |  |  | MW166153/1 | MW166153 | 1 | SP | -645.93
MW180044/1 | MW180044 | 1 | CUS | 0 |  |  | MW179529/1 | MW179529 | 1 | SP | 0
CC167234/1 | CC167234 | 1 | GHI | -1301.1 |  |  | MW177508/1 | MW177508 | 1 | SP | 0
CD325354/1 | CD325354 | 1 | GHI | 0 |  |  | CC169916/1 | CC169916 | 1 | SP | -70.56
CD325896/1 | CD325896 | 1 | CUS | 0 |  |  | CC172877/1 | CC172877 | 1 | SP | 458.81
TS067908/1 | TS067908 | 1 | GHI | 0 |  |  | CD317969/1 | CD317969 | 1 | SP | -420
TS067566/1 | TS067566 | 1 | CUS | 0 |  |  | CD325808/1 | CD325808 | 1 | SP | 0
BS302805/1 | BS302805 | 1 | GHI | -400 |  |  | CD321383/1 | CD321383 | 1 | SP | -460.64
OL553783/1 | OL553783 | 1 | CUS | 0 |  |  | CD325537/1 | CD325537 | 1 | SP | 0
Spreadsheet: 220571d1363195415-cell-to-assign-values-based-upon-goals-branch-points-copy
Sheet: 2nd Q

April |  | Points |  | Points |  | Points |  | Points |  | Points |  | Points |  | Points |  | Points |  | Points
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points
May
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points
June
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points