tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 082b7c2d-416d-48dd-a9f3-016d35bdbea5
Sheet: 8-Annual Financial Report

Annual Financial Report
FY 14-15
District:
School:
 |  | Due September 1, 2015
 |  |  | FY 14-15
 |  | PROGRAM CATEGORIES | Budget | Actual Expenditures
 | Instructional Program
 | 1 | Salaries (0100)
 | 2 | Employee Benefits (0200)
 | 3 | Purchased Professional & Technical Services (0300)
 | 4 | Other Purchased Services (0500)
 | 5 | Travel, Registration, and Entrance (0580)
 | 6 | Supplies (0600)
 | 7 | Other (0800)
 | 8 | Subtotal Instructional Program  (lines 1 through 6)
 | Support Program
 | 9 | Salaries (0100)
 | 10 | Employee Benefits (0200)
 | 11 | Purchased Professional & Technical Services (0300)
 | 12 | Other Purchased Services (0500)
 | 13 | Travel, Registration, and Entrance (0580)
 | 14 | Supplies (0600)
 | 15 | Other (0800)
 | 16 | Subtotal Support Program (lines 8 through 15)
 | 17 | Indirect Costs
 | 18 | Non-Capitalized Equipment (0735)
 | 19 | Capitalized Equipment (0730)
 | 20 | Total Budget (lines 7 and 16)
 |  | Typed Name of Person Preparing Report                 Date |  |  | Signature of School District Authorized Representative*
 |  | *Check with your school district budget office for the signature of the school district authorized representative.
Spreadsheet: 1006f4b2-346a-48d4-8964-466f3045604c
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.6 | -0.5 | 1.1 | 54 | -18 | 36
Coffee | 6.7 | -2 | 4.7 | 68 | -21 | 47
Copper | 10.6 | -2.8 | 7.8 | 98 | -26 | 72
Corn | 22 | -7.1 | 14.8 | 647 | -209 | 438
Cotton | 9.2 | -3.3 | 6 | 99 | -34 | 65
[NAME] | 0.9 | -0.2 | 0.7 | 13 | -3 | 10
Gold | 22.7 | -5.6 | 17.1 | 157 | -39 | 118
Heating Oil | 12.4 | -2.3 | 10.1 | 95 | -18 | 77
[NAME] | 5.7 | -1.7 | 4.1 | 141 | -40 | 100
Live Cattle | 9.8 | -2.9 | 6.9 | 203 | -60 | 142
Natural Gas | 21.8 | -4.9 | 16.9 | 484 | -109 | 375
Platinum | 0.7 | -0.2 | 0.5 | 8 | -2 | 6
RBOB Unleaded Gas | 12.8 | -2.3 | 10.4 | 100 | -18 | 81
Silver | 8.3 | -1.6 | 6.6 | 44 | -9 | 35
Soybean Meal | 1 | -0.3 | 0.8 | 28 | -7 | 21
Soybean Oil | 5.3 | -1.7 | 3.6 | 150 | -47 | 103
Soybeans | 19.6 | -6.2 | 13.4 | 280 | -88 | 191
Sugar | 10.8 | -3.5 | 7.3 | 370 | -117 | 253
Wheat (CBOT) | 14.3 | -5.8 | 8.5 | 366 | -151 | 214
Wheat (KCBT) | 2.2 | -0.8 | 1.4 | 49 | -18 | 31
WTI Crude Oil | 74.1 | -22.6 | 51.5 | 694 | -212 | 482
Subtotal (>0.5 billion US$) | 272.7 | -78.5 | 194.2
Subtotal (<0.5 billion US$) | 1.1 | -0.3 | 0.8
Total Notional US Mkts | 273.8 | -78.8 | 195
Total Not'l Non-US Mkts | 62.2 | -14.6 | 47.6
Total All Markets | 336 | -93.4 | 242.6
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with 0.5 billion US dollars or more in reported net index investment notional value on the report date.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: f35b3c1b-9462-458d-be74-00994820f35e
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-26 | 1 | Hershey | 5 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2013-04-28 | 2 | Hershey | 5 | Providence | 4 | Final OT | Dunkin' Donuts Center Providence, RI
2013-05-04 | 3 | Providence | 5 | Hershey | 1 | Final | Giant Center Hershey, PA
2013-05-05 | 4 | Providence | 5 | Hershey | 4 | Final | Giant Center Hershey, PA
2013-05-08 | 5 | Hershey | 2 | Providence | 3 | Final | Dunkin' Donuts Center Providence, RI
2013-05-10 | 1 | W-B/Scranton | 5 | Providence | 8 | Final | Dunkin' Donuts Center Providence, RI
2013-05-11 | 2 | W-B/Scranton | 2 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2013-05-15 | 3 | Providence | 2 | W-B/Scranton | 1 | Final OT | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-17 | 4 | Providence | 1 | W-B/Scranton | 3 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-18 | 5 | Providence | 0 | W-B/Scranton | 4 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-20 | 6 | W-B/Scranton | 2 | Providence | 1 | Final OT | Dunkin' Donuts Center Providence, RI
2013-05-22 | 7 | W-B/Scranton | 5 | Providence | 0 | Final | Dunkin' Donuts Center Providence, RI
Spreadsheet: 106426d1303683117-excel-2007-total-values-in-hierarchy-order-waterfall_results
Sheet: Results

Exclusion | First Exclusion | Unique Exclusion
MISSING C
MISSING A
MISSING B
MISSING F
MISSING D
MISSING E
Total
 | ^==This should equal my total number of accounts | ^==This should equal my total loans where they was only 1 exclusion
** I will end up re-ordering my Exclusions into different hierarchy and need the formula to update as well
** My First Exclusion should identify based on hierarchy where the acct is first excluded then no longer count that acct in any other exclusion total
**Unique Exclusions will total the accts where the determined exclusion is the only exclusion
Spreadsheet: 0b1e788d-fc48-4187-b32f-2e0b5aab6b2c
Sheet: Sheet1

Feature | eAssignment | Comments | BB eSubmission |  | TurnItIn | Comments
Submission
Multiple Files allowed per submission | Y |  | Y |  | N | Doesn't accept zip files either
Can specify which file types required | Y |  | N |  | Y | More accurately, Turnitin limits the filetypes that are allowed.
Anonymous submissions | Y |  | N |  | Y | Requires you to mark exlcusively grademark
Pre / post questions for students | Y |  | N |  | N
Auto convert to PDF option | N | Most applications allow save as PDF these days | N |  | Y
Marking
On screen marking | N | Office 2013 has options iSolutions are looking into | N |  | Y | Criteria on screen along with submission. Works for text based only.
Multiple report files allowed | Y |  | Y |  | Y | But allows voice recording on the screen. Can also use BB grade centre to upload multiple files
Graded criteria / descriptors | Y |  | N |  | Y
Marking groups | Y |  | Y | Create groups of random students | Y | Can use BB groups to setup groups, but then not quite anonymous
Grade auto added to gradebook | N | Coming End of September | Y |  | N | Links to grade centre in BB, but no plans yet to integrate GC with enhanced gradebook
Marking options e.g. single marker, averaged, agreed etc | Y |  | N |  | N
Access for external examiners | Y | In future we expect to add federated access to the system (this is a result of the SharePoint project) and this would enable you to add users from [NAME], Google, [NAME] etc. | Y |  | Y | Requires honouree contract, access to BB and enrolled on course. Same as usual
Batch download of work | Y |  | Y |  | Y | Can't batch download originality report
Batch upload of annotated work | N | This is possible and looking at things to do. Possible Office 2013 will be able to fix this issue as well | N |  | N | it IS possible to download BB grade centre as a spreadsheet, add makrs to this and then reupload, but can't batch upload feedback to Turnitin / Grademark
Peer Assessment
Allow students to assess other students work | Y | For large student numbers requires custom script to run. Not scalable currently | Y | BB has seperate tool for this | Y | Peer mark works very well, but has not been tested on a live course.
Allow students to rate each other on group work | Y | Requires a separate assignment | N |  | N
Other Features
Extensions for single students | Y |  | N |  | N | Can only set global allow late submission
Penalties for late submission etc.. | Y |  | N |  | N
Word Count | Y |  | N |  | Y
Duplicate Assignments | Y |  | N |  | N | Can create global rubrics for export /import
[NAME] | None |  | 10 meg recommended |  | 20 meg
Spreadsheet: 3380247f-e906-4dc2-9b35-6d6d31ea6247
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0002766 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Town of Gibson WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Scotland | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 7.2 |  | Area (acres): |  | 3 |  | Area (acres): |  | 4.2 |  | Area (acres): |  | 3.4
 |  |  |  |  |  | Cover Crop: |  | Sycamore |  | Cover Crop: |  | Sycamore |  | Cover Crop: |  | Sycamore |  | Cover Crop: |  | Sycamore
 |  |  |  |  |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25
 |  |  |  |  |  | Annual Rate (in): |  | 65 |  | Annual Rate (in): |  | 80.6 |  | Annual Rate (in): |  | 80.6 |  | Annual Rate (in): |  | 80.6
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 700880d1603382223-workingdays-working-hours-1-
Sheet: Data

Start date | End date | Dias | should be |  |  | Start Date | EndDate |  | Geral |  | Other format with formula
2020-09-14 09:00:00 | 2020-10-01 16:29:00 | 14
2020-09-25 10:44:00 | 2020-10-06 16:07:00
2020-09-30 11:39:00 | 2020-10-13 15:12:00
2020-09-30 15:47:00 | 2020-10-14 17:38:00
2020-09-28 13:34:00 | 2020-10-09 13:35:00
2020-09-29 18:34:00 | 2020-10-12 13:35:00 |  | 7 days, 4 hours and 35 minutes
2020-08-26 15:51:00 | 2020-10-01 10:08:00
2020-08-28 15:22:00 | 2020-10-13 13:20:00
2020-08-19 09:00:00 | 2020-10-06 09:45:00
2020-09-13 18:00:00 | 2020-09-15 01:00:00
Working hours
Start | 09:00:00 | <-- 9/24
End | 18:00:00 | <-- 18/24
Spreadsheet: 700124d1602970471-i-need-a-formula-for-an-inventory-workbook-for-to-calculate-sales-and-add-inventory-hearts-creating-art
Sheet: Master 

S No. | Product ID | Product Name | Product Category | Unit Price | Ideal Inventory | Available Stock
1 | Prd-001 | Bracelet 1 | Bracelets | 4 | 20 | =Sumif(Stock in'!D:D,'Master'!C2',Stock in'!D:D)-sumif(Sales!C:C,'Master'!C2,Sales!C:C)
2 | Prd-002 | Bracelet 2 | Bracelets | 5 | 20
3 | Prd-003 | Bracelet 3 | Bracelets | 3 | 20
4 | Prd-004 | Bracelet 4 | Bracelets | 4 | 20
5 | Prd-005 | Bracelet 5 | Bracelets | 6 | 20
6 | Prd-006 | Bracelet 6 | Bracelets | 18 | 15
7 | Prd-007 | Necklace 1 | Necklace | 5 | 15
8 | Prd-008 | Necklace 2 | Necklace | 5 | 15
9 | Prd-009 | Necklace 3 | Necklace | 6 | 15
10 | Prd-010 | Necklace 4 | Necklace | 6 | 10
11 | Prd-011 | Necklace 5 | Necklace | 8 | 10
12 | Prd-012 | Necklace 6 | Necklace | 8 | 10
13 | [NAME] | Necklace 7 | Necklace | 10 | 10
14 | Prd-014 | Bookmarks 1 | Bookmarks | 3 | 30
15 | Prd-015 | Bookmarks 2 | Bookmarks | 2 | 20
16 | Prd-016 | Bookmarks 3 | Bookmarks | 2 | 20
17 | Prd-017 | Bookmarks 4 | Bookmarks | 4 | 20
18 | Prd-018 | Bead 1 | Beadwork | 8 | 10
19 | Prd-019 | Bead 2 | Beadwork | 10 | 10
20 | Prd-020 | Bead 3 | Beadwork | 12 | 10
21 | Prd-021 | Bead 4 | Beadwork | 7 | 15
22 | Prd-022 | Bead 5 | Beadwork | 7 | 15
23 | Prd-023 | Bead 6 | Beadwork | 8 | 15
24 | Prd-024 | Bead 7 | Beadwork | 8 | 15
25 | Prd-025 | Bead 8 | Beadwork | 10 | 15
26 | Prd-026 | Paint 1 | Painting | 10 | 1
27 | Prd-027 | Paint 2 | Painting | 15 | 1
28 | Prd-028 | Paint 3 | Painting | 20 | 1
29 | Prd-029 | Paint 4 | Painting | 25 | 1
30 | Prd-030 | Paint 5 | Painting | 18 | 1
31 | Prd-031 | Paint 6 | Painting | 12 | 1
32 | Prd-032
33 | Prd-033
34 | Prd-034
35 | Prd-035
36 | Prd-036
37 | Prd-037
38 | Prd-038
39 | Prd-039
40 | Prd-040
41 | Prd-041
42 | Prd-042
43 | Prd-043
44 | Prd-044
45 | Prd-045
46 | Prd-046
47 | Prd-047
48 | Prd-048
49 | Prd-049
50 | Prd-050
51 | Prd-051
52 | Prd-052
53 | Prd-053
54 | Prd-054
55 | Prd-055
56 | Prd-056
57 | Prd-057
58 | Prd-058
59 | Prd-059
60 | Prd-060
61 | Prd-061
62 | Prd-062
63 | Prd-063
64 | Prd-064
65 | Prd-065
66 | Prd-066
67 | Prd-067
68 | Prd-068
69 | Prd-069
70 | Prd-070
71 | Prd-071
72 | Prd-072
73 | Prd-073
74 | Prd-074
75 | Prd-075
76 | Prd-076
77 | Prd-077
78 | Prd-078
79 | Prd-079
80 | [NAME]
81 | Prd-081
82 | Prd-082
83 | Prd-083
84 | Prd-084
85 | Prd-085
86 | Prd-086
87 | Prd-087
88 | Prd-088
89 | Prd-089
90 | Prd-090
91 | Prd-091
92 | Prd-092
93 | Prd-093
94 | Prd-094
95 | Prd-095
96 | Prd-096
97 | [NAME]
98 | Prd-098
99 | Prd-099
100 | Prd-100
Spreadsheet: 675968d1588592207-fix-a-cell-reference-in-multiple-already-created-formulas-sample
Sheet: Sheet1

 | 1. ROADWORKS
 |  | TENDER QTY | COMP. QTY | LABO | EQVB | EQRE | FLOT | PVCP | CONP | BEDS | SGRA | AGRA | BGRA | CGRA | RIPR | TOPS | MATE | PUMP | [NAME] | MISM | DUST | WATR | TRUC | TIPP | BOND | PORP | ENGI | SAFE | FINE | GPSS | TEST | ASPH | CURB | CORE | VACS | LDSP | TREE | SWEP | FENC | WALL | PULV | HDDS | JABO | MECH | ELEC | INSP | LINE | [NAME] | FUSE | ERTH
 | 1a) | 1 |  | 1786.51 | 3010
 | 1b) | 1 |  | 6121.66 | 3760.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14482.29
 | 1c) | 1 |  | 756.28 | 607.74
 | 2a) | 200 |  | 1460.32 | 857.58 |  |  |  |  |  |  |  |  |  |  |  | 600
 | 2b) | 3 |  | 1521.91 | 440.39 |  |  |  |  |  |  |  |  |  |  |  | 3000
 | 3 | 1200 |  | 2550.59 | 465.47 | 822.33 |  |  |  |  |  | 22800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4320
 | 4a) | 3230 |  | 3556.2 | 930.93 | 684.65 |  |  |  |  |  |  | 47642.5
 | 4b) | 1600 |  | 1971.09 | 465.47 | 342.33 |  |  |  |  |  |  | 23600
 | 5a) | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43180
 | 6 | 639 |  | 1481.67 | 270.39 | 198.86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19828.17
 | 7 | 16 |  | 86.13
TOTAL
 | 1. ROADWORKS
 |  | TENDER QTY | COMP. QTY | LABO | EQVB | EQRE | FLOT | PVCP | CONP | BEDS | SGRA | AGRA | BGRA | CGRA | RIPR | TOPS | MATE | PUMP | [NAME] | MISM | DUST | WATR | TRUC | TIPP | BOND | PORP | ENGI | SAFE | FINE | GPSS | TEST | ASPH | CURB | CORE | VACS | LDSP | TREE | SWEP | FENC | WALL | PULV | HDDS | JABO | MECH | ELEC | INSP | LINE | [NAME] | FUSE | ERTH
 | 1a) | 1 | 1
 | 1b) | 1 | 2
 | 1c) | 1 | 1
 | 2a) | 200 | 195
 | 2b) | 3 | 1.5
 | 3 | 1200 | 1150
 | 4a) | 3230 | 3000
 | 4b) | 1600 | 1520
 | 5a) | 400 | 410
 | 6 | 639 | 652
 | 7 | 16 | 19
TOTAL
Spreadsheet: 676048d1588621482-join-rows-and-columns-for-graphs-join
Sheet: Content1

 |  |  |  |  | Method3 |  |  |  |  | Method 5
 |  |  |  | Method1 | Method2 |  |  |  | N/A | Method 4
Block | Valve | Status | Type | Topic1 | Topic2 | Topic3 | Topic4 | Topic5 | Topic6 | Topic7 | Topic8
11 | Pressure | Open | A | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 3
11 | choke | Close | B | 2 | 1 | 4 | 2 | 1 | 1 | 1 | 3
12 | lift | Open | A | 1 | 1 | 4 | 1 | 2 | 4 | 2 | 1
12 | safety | Open | B | 2 | 4 | 2 | 1 | 2 | 4 | 2 | 2
12 | kill | Open | C | 1 | 2 | 1 | 1 | 2 | 3 | 2 | 1
13 | spike | Close | D | 2 | 3 | 2 | 1 | 1 | 3 | 3 | 1
Spreadsheet: 798592d1664562061-how-to-populate-names-from-2-matching-columns-of-numbers-populate-supv-names
Sheet: Sheet 1

Reports To Position Number | [NAME]
91101432 | Name 1 |  |  |  |  | Supv | PN
91101432 | Name 1 |  |  |  |  | Name 1 | 91101432
91223809 | Name 13 |  |  |  |  | Name 2 | 91246286
91185406 |  |  |  |  |  | Name 3 | 91420842
91242009 |  |  |  |  |  | Name 4 | 91185406
91209340 |  |  |  |  |  | Name 5 | 91337928
91251099 |  |  |  |  |  | Name 6 | 91339470
91246322 |  |  |  |  |  | Name 7 | 91264092
91223809 |  |  |  |  |  | Name 8 | 91350599
91248925 |  |  |  |  |  | Name 9 | 91244038
91244038 |  |  |  |  |  | Name 10 | 91209340
91382277 |  |  |  |  |  | Name 11 | 91247077
91246322 |  |  |  |  |  | Name 12 | 91226527
91223809 |  |  |  |  |  | Name 13 | 91223809
91330416 |  |  |  |  |  | Name 14 | 91242009
91187573 |  |  |  |  |  | Name 15 | 91251099
91224368 |  |  |  |  |  | Name 16 | 91246322
91184881 |  |  |  |  |  | Name 17 | 91248925
91228950 |  |  |  |  |  | Name 18 | 91382277
91223809 |  |  |  |  |  | Name 19 | 91330416
91223809 |  |  |  |  |  | Name 20 | 91187573
91613009 |  |  |  |  |  | Name 21 | 91224368
91246286 |  |  |  |  |  | Name 22 | 91184881
91420842 |  |  |  |  |  | Name 23 | 91228950
91185406 |  |  |  |  |  | Name 24 | 91613009
91337928 |  |  |  |  |  | Name 25 | 91158235
91339470 |  |  |  |  |  | Name 26 | 91318814
91264092 |  |  |  |  |  | Name 27 | 91232261
91350599 |  |  |  |  |  | Name 28 | 91144732
91244038 |  |  |  |  |  | Name 29 | 91183151
91209340 |  |  |  |  |  | Name 30 | 91097827
91247077 |  |  |  |  |  | Name 31 | 91386647
91226527 |  |  |  |  |  | Name 32 | 91246105
91223809
91185406
91242009
91209340
91251099
91246322
91223809
91248925
91244038
91382277
91246322
91223809
91330416
91187573
91224368
91184881
91228950
91223809
91223809
91613009
91158235
91318814
91247077
91247077
91232261
91248925
91247077
91228950
91330416
91247077
91144732
91144732
91246322
91382277
91246322
91228950
91183151
91097827
91264092
91386647
91330416
91228950
91228950
91246105
91224368
91101432
Spreadsheet: 57075d1257257942-count-data-in-cells-using-two-different-conditions-data-count-based-on-2-conditions
Sheet: Sheet2

State | Data |  | Data Count
California | 1 |  | 4 | I need to have a formula that can count how many data entries each state has.
California | 1
California
California | 1
California | 1
Florida | 1 |  | 3
Florida
Florida | 1
Florida | 1
Kansas |  |  | 3
Kansas | 1
Kansas | 1
Kansas | 1
Kansas
New York | 1 |  | 5
New York | 1
New York | 1
New York | 1
New York
New York | 1
Ohio |  |  | 3
Ohio | 1
Ohio | 1
Ohio | 1
Ohio
Vermont | 1 |  | 4
Vermont | 1
Vermont | 1
Vermont
Vermont | 1
Spreadsheet: geir_solberg__11286__12-22act
Sheet: EPEData

 | 37344.80416666667
 | NEWMAN 1 ,UNAV,  0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 55  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 93  ,100  , 35  ,103  ,  5  ,1
 | NEWMN/GT1,MANL, 30  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 25  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 205 ,  297,  105, 306 ,   5 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,605  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 91  , 91  , 91  ,104  ,  0  ,1
 | LAMBDA, 44.90,  671,  670,  108,   16,    0,13386,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: michelle_lokay__26708__Red Rock Contracts
Sheet: Sheet1

 |  | Red Rock Firm Transportation Service Contracts
 |  |  |  |  |  | (Dth/day) |  |  |  |  |  |  |  | Second Quarter 2002 Projected Revenues
 |  |  | No. | [NAME] | Contract No. | MMBtu/day |  | Effective Date | Rate/MMBtu | Term/Years |  | Contract-out Date |  | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00
 |  |  | 1 | [NAME] | 27604 | 5300 |  | 2002-06-01 00:00:00 | 2.2 | 1 |  | 2002-12-21 00:00:00
 |  |  |  | [NAME] | 27605 | 2700 |  | 2002-06-01 00:00:00 | 0.38 | 15 |  | 2002-12-21 00:00:00
 |  |  |  | OneOK | 27607 | 1700 |  | 2002-06-01 00:00:00 | 1.75 | 22 months |  | No contract out language.
 |  |  |  | Western Gas | 27608 | 10000 |  | 2002-06-01 00:00:00 | 0.385 | 15 |  | 2002-12-21 00:00:00
 |  |  |  | BP Energy | 27609 | 15000 |  | 2002-06-01 00:00:00 | 0.38 | 10 |  | No contract out language.
 |  |  |  | US Gypsum | 27622 | 4500 |  | 2002-06-01 00:00:00 | 0.42 | 12.25 |  | No contract out language.
 |  |  |  | PPL | 27641 | 20000 |  | 2002-06-01 00:00:00 | 0.38 | 30 plus 1 month |  | 2002-12-21 00:00:00
 |  |  |  | Calpine | 27642 | 40000 |  | 2002-07-01 00:00:00 | 0.38 | 15 |  | 2003-12-21 00:00:00
 |  |  |  | PPL | 27649 | 7500 |  | 2002-06-01 00:00:00 | 0.225 | 5 |  | 2002-12-21 00:00:00
 |  | These are all Red Rock Contracts and the current in-service date is assumed to be 6/1/2002.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Usage = | 0.05
 |  | The Service Agreement - Form M was available from the FERC RIMS web page.  Transwestern does not include the "priviledge and
 |  | confidential information " in the Form M, such as the discounted rate or contract out terms.  The contract information was supplied
 |  | by [NAME], responsible for the Red Rock contracts at [PHONE].
Spreadsheet: 727805d1618131888-difficult-formula-count-line-date-w-in-week-and-hours-charged-dummy-file
Sheet: Sheet3

 |  | Pay Type | (Multiple Items)
 |  | Row Labels | Sum of Hours
 |  | 54719 | 866.5
 |  | 2020-09-17 00:00:00 | 11
 |  | 2020-09-24 00:00:00 | 40
 |  | 2020-10-01 00:00:00 | 37
 |  | 2020-10-08 00:00:00 | 40
 |  | 2020-10-15 00:00:00 | 40
 |  | 2020-10-22 00:00:00 | 35.5
 |  | 2020-10-29 00:00:00 | 40
 |  | 2020-11-05 00:00:00 | 40
 |  | 2020-11-12 00:00:00 | 39
 |  | 2020-11-19 00:00:00 | 39.5
 |  | 2020-11-26 00:00:00 | 37
 |  | 2020-12-03 00:00:00 | 16
 |  | 2020-12-10 00:00:00 | 23.5
 |  | 2020-12-17 00:00:00 | 23.5
 |  | 2020-12-24 00:00:00 | 40
 |  | 2020-12-31 00:00:00 | 35.5
 |  | 2021-01-07 00:00:00 | 32
 |  | 2021-01-14 00:00:00 | 32
 |  | 2021-01-21 00:00:00 | 40
 |  | 2021-01-28 00:00:00 | 37.5
 |  | 2021-02-04 00:00:00 | 40
 |  | 2021-02-11 00:00:00 | 35.5
 |  | 2021-02-18 00:00:00 | 40
 |  | 2021-02-25 00:00:00 | 40
 |  | 2021-03-04 00:00:00 | 32
 |  | (blank)
 |  | (blank)
 |  | Grand Total | 866.5
Spreadsheet: 270327d1381437841-return-value-based-on-2-dependent-drop-down-lists-cost-estimation
Sheet: Reference

Size | Description | Price | Price | Price | Price | Price