tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153109d1335775810-returning-a-price-based-on-data-moulding-stocklist
Sheet: B 1-6 

Rack one |  | B | Rack Two |  | B | Rack Three |  | B | Rack Four |  | B | Rack five |  | B | Rack six |  | B
Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount
W938373 | 21ft |  | W938371 | 23ft |  | 958541 | 45ft |  | W972542 | 12ft |  | W946534 | 14ft |  | W946521 | 40ft
W938372 | 15ft |  | 5906-6548 | 60ft |  | 938543 | 18ft |  | W972222 | 28ft |  | W946523 | 21ft |  | 770-arg | 9 Ft
W938251 | 12 Ft |  | SG84 | 12ft |  | 5904.6541 big | 19ft |  | W972221 | 7ft |  | W926806 | 10ft |  | 736126 | 7 Ft
5904.7556 | 26ft |  | Pol4415 | 24ft |  |  |  |  | C2837 | 9 Ft |  | pol2004 | 26.50 Ft
5904.6541 | 4ft |  | 569 gold | 10 Ft |  |  |  |  | 472000109 | 12 Ft
W938373 | 12ft |  | 772-champ | 12 Ft |  |  |  |  | 234926 | 32 Ft
SG201 | 12 Ft |  | pol2101 | 23 Ft |  |  |  |  | 234928 | 18 Ft
SG203 | 7 Ft
SG9 | 4 Ft
574-06 | 15 Ft
574-013 | 14 Ft
342604 | 10 Ft
Spreadsheet: 108486d1305555905-index-match-issue-sample_sales_data
Sheet: Sheet2

 |  | SE Name |  | Year
 |  | Select SE |  | 2010
 |  | [NAME] |  | 2011
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Tawanda Mudzana
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 61811d1262728592-nested-ifs-sched-with-omm
Sheet: Thursday

 | One Minute Meeting
 | Date:
 | Yest.Goal | Yest Act. |  | $ +/- | TODAY'S GOAL | ASH | ADT Goal | UPT Goal
 | $ | $ |  | $ | 577 | $ | $
 | WTD Goal | WTD Act. |  | $ +/- |  |  | ADT WTD | UPT WTD
 | $ | $ |  | $ |  |  | $
 | MTD [NAME] | MTD Act. |  | $ +/- |  |  | ADT MTD | UPT MTD
 | $ | $ |  | $ |  |  | $
 | Merchandise Message
 | Today's Schedule
 | Employees Scheduled |  |  | 2
 | Name/Initals | Shift Start | Shift End | Sales Goal | Sales Actual | % to Goal | ADT | UPT | SOCKS
1 | [NAME] | 09:00:00 | 17:30:00 | $ | $ | % | $
2 | [NAME] | 09:30:00 | 17:30:00 | $ | $ | % | $
3 |  |  |  | $ | $ | % | $
4 |  |  |  | $ | $ | % | $
5 |  |  |  | $ | $ | % | $
6 |  |  |  | $ | $ | % | $
7 |  |  |  | $ | $ | % | $
8 |  |  |  | $ | $ | % | $
9 |  |  |  | $ | $ | % | $
10 |  |  |  | $ | $ | % | $
 | [NAME]
 | Hour | % By Hour |  | Target Sales | Actual Sales | UPT | ADT | ASH
 | 11:00:00 | 0.1 |  | 57.7 | $ |  | $ | $
 | 12:00:00 | 0.2 |  | 115.4 | $ |  | $ | $
 | 13:00:00 | 0.3 |  | 173.1 | $ |  | $ | $
 | 14:00:00 | 0.4 |  | 230.8 | $ |  | $ | $
 | 15:00:00 | 0.5 |  | 288.5 | $ |  | $ | $
 | 16:00:00 | 0.6 |  | 346.2 | $ |  | $ | $
 | 17:00:00 | 0.7 |  | 403.9 | $ |  | $ | $
 | 18:00:00 | 0.8 |  | 461.6 | $ |  | $ | $
 | 19:00:00 | 0.9 |  | 519.3000000000001 | $ |  | $ | $
 | 20:00:00 | 1 |  | 577 | $ |  | $ | $
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: DCCAT

Team | Tournament | PPB
DCD A | DCCAT | 17.7
Novi A | DCCAT | 17.1
Tippecanoe | DCCAT | 13.26 |  |  | DCCAT
[NAME] A | DCCAT | 12.81
Churchill | DCCAT | 12.68
[NAME] A | DCCAT | 12.19
Novi B | DCCAT | 10.7
Kent City | DCCAT | 10.55
DCD B | DCCAT | 9.92
[NAME] | DCCAT | 9.08
[NAME] B | DCCAT | 8.11
Sand Creek A | DCCAT | 6.21
Spreadsheet: 3f9c0a1c-ac79-45f7-8327-6930afae930c
Sheet: US

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments |  | (-) = blanks, no data
US Total | this year | last year | this year | last year | this year | last year
Spreadsheet: 156421e9-0ced-470d-9b2c-33cd247bc5dc
Sheet: Table 1

TABLE 1
CURRENT FUNDS REVENUES BY SOURCE
FISCAL YEARS 2009-10 AND 2010-11
(amounts in thousands)
 | PROGRAM AND SOURCE OF FUNDS | 2010-11 |  | 2009-10
SYSTEMWIDE SUPPORT
 | Tuition and fees | 661 |  | 689
 | Federal appropriations | 98 |  | 0
 | State appropriations | 31104 |  | 31745
 | Federal grants/contracts | 51341 |  | 46370
 | State grants/contracts | 323 |  | 849
 | Private gifts, grants, and contracts | 1952 |  | 1561
 | Endowment income | 49 |  | -407
 | Sales and services of educational activities | 0 |  | 0
 | Auxiliary services | 2510 |  | 1424
 | Other sources | 3257 |  | 662
 |  | 91296 |  | 82893
MANOA-BASED ACTIVITIES
 | Tuition and fees | 203855 |  | 180400
 | Federal appropriations | 26175 |  | 20130
 | State appropriations | 192223 |  | 198214
 | Federal grants/contracts | 272993 |  | 255571
 | State grants/contracts | 12442 |  | 21016
 | Local grants/contracts | 1634 |  | 1826
 | Private gifts, grants, and contracts | 40064 |  | 39803
 | Endowment income | 1083 |  | 1483
 | Sales and services of educational activities | 7528 |  | 7507
 | Auxiliary services | 23543 |  | 20657
 | Other sources | 5239 |  | 8323
 |  | 786780 |  | 754930
UH AT HILO
 | Tuition and fees | 33595 |  | 28804
 | Federal appropriations | 300 |  | 300
 | State appropriations | 29370 |  | 30220
 | Federal grants/contracts | 26666 |  | 22148
 | State grants/contracts | 1306 |  | 1801
 | Local grants/contracts | 277 |  | 211
 | Private gifts, grants, and contracts | 1704 |  | 1295
 | Endowment income | 122 |  | 239
 | Sales and services of educational activities | 231 |  | 241
 | Auxiliary services | -2144 |  | -950
 | Other sources | 199 |  | 23
 |  | 91627 |  | 84332
COMMUNITY COLLEGE
SYSTEMWIDE SUPPORT (Including ETC)
 | Tuition and fees | 31 |  | 45
 | State appropriations | 3393 |  | 3112
 | Federal grants/contracts | 1268 |  | 956
 | State grants/contracts | 9 |  | 359
 | Private gifts, grants, and contracts | 3 |  | 32
 | Endowment income | 0 |  | 0
 | Sales and services of educational activities | 0 |  | 0
 | Other sources | 1 |  | 0
 |  | 4705 |  | 4503.6
COMMUNITY COLLEGES
 | Tuition and fees | 72756 |  | 65206
 | Federal appropriations | 7124 |  | 6960
 | State appropriations | 99068 |  | 102017
 | Federal grants/contracts | 60040 |  | 52396
 | State grants/contracts | 582 |  | 872
 | Local grants/contracts | 507 |  | 631
 | Private gifts, grants, and contracts | 822 |  | 1140
 | Endowment income | 12 |  | 14
 | Sales and services of educational activities | 6529 |  | 7076
 | Auxiliary services | -8317 |  | -2270
 | Other sources | 704 |  | 425
 |  | 239827 |  | 234467
UNIVERSITY OF HAWAII AT  WEST OAHU
 | Tuition and fees | 5192 |  | 4272
 | State appropriations | 5202 |  | 5322
 | Federal grants/contracts | 2771 |  | 2270
 | State grants/contracts | -2 |  | 64
 | Private gifts, grants, and contracts | 5 |  | 5
 | Endowment income | 4 |  | 4
 | Sales and services of educational activities | 16 |  | 15
 | Auxiliary services | -1716 |  | -1255
 | Other sources | 60 |  | 62
 |  | 11532 |  | 10759
INDEPENDENT OPERATIONS |  | 0 |  | 0
GRAND TOTAL |  | 1225766 |  | 1171885
Spreadsheet: 698100d1601743052-averageifs-for-ranges-with-multiple-columns-practice
Sheet: Sheet1

Utility | Date | Number | Number
BGE | 2020-01-01 00:00:00 | 2
BGE | 2020-01-02 00:00:00 | 4
BGE | 2020-01-03 00:00:00 | 6
BGE | 2020-01-04 00:00:00 | 8
BGE | 2020-01-05 00:00:00 | 10
BGE | 2020-01-06 00:00:00 | 12
BGE | 2020-01-07 00:00:00 | 14
BGE | 2020-01-08 00:00:00 | 16
BGE | 2020-01-09 00:00:00 | 18
BGE | 2020-01-10 00:00:00 | 20
BGE | 2020-01-11 00:00:00 | 22
BGE | 2020-01-12 00:00:00 | 24
PECO | 2020-01-13 00:00:00 | 26
BGE | 2020-01-14 00:00:00 | 28
PECO | 2020-01-15 00:00:00 | 30
BGE | 2020-01-16 00:00:00 | 32
PECO | 2020-01-17 00:00:00 | 34
BGE | 2020-01-18 00:00:00 | 36
PECO | 2020-01-19 00:00:00 | 38
BGE | 2020-01-20 00:00:00 | 40
PECO | 2020-01-21 00:00:00 | 42
BGE | 2020-01-22 00:00:00 | 44
BGE | 2020-01-23 00:00:00 | 46
BGE | 2020-01-24 00:00:00 | 48
PECO | 2020-01-25 00:00:00 | 50
BGE | 2020-01-26 00:00:00 | 52
BGE | 2020-01-27 00:00:00 | 54
BGE | 2020-01-28 00:00:00 | 56
BGE | 2020-01-29 00:00:00 | 58
BGE | 2020-01-30 00:00:00 | 60
BGE | 2020-01-31 00:00:00 | 62
BGE |  | 64
BGE |  | 66
BGE |  | 68
BGE |  | 70
BGE |  | 72
BGE |  | 74
BGE |  | 76
BGE |  | 78
BGE |  | 80
BGE |  | 82
BGE |  | 84
BGE |  | 86
PECO |  | 88
BGE |  | 90
PECO |  | 92
BGE |  | 94
PECO |  | 96
BGE |  | 98
PECO |  | 100
BGE |  | 102
PECO |  | 104
BGE |  | 106
BGE |  | 108
BGE |  | 110
PECO |  | 112
BGE |  | 114
BGE |  | 116
BGE |  | 118
BGE |  | 120
BGE |  | 122
BGE |  | 124
BGE |  | 126
BGE |  | 128
BGE |  | 130
BGE |  | 132
BGE |  | 134
BGE |  | 136
BGE |  | 138
BGE |  | 140
BGE |  | 142
BGE |  | 144
BGE |  | 146
BGE |  | 148
PECO |  | 150
BGE |  | 152
PECO |  | 154
BGE |  | 156
PECO |  | 158
BGE |  | 160
PECO |  | 162
BGE |  | 164
PECO |  | 166
BGE |  | 168
BGE |  | 170
BGE |  | 172
PECO |  | 174
BGE |  | 176
BGE |  | 178
BGE |  | 180
BGE |  | 182
BGE |  | 184
BGE |  | 186
Spreadsheet: 599824d1543324569-transposing-data-foi-data-nhs-trusts-roles
Sheet: Sheet2

 | [NAME]
 | Acute Trust
 | Community Healthcare Trust
 | Mental Health Trust
 | Ambulance Trust
 | Children's Trust
 |  |  |  |  |  | 12
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 60 | months
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 120 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 24 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | monthd
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 2017-05-01 00:00:00
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 60months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 36 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 24 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | National | NHS | System | - | Unknown
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 60 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | No | Contract
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | 24 | months
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N
 |  |  |  |  |  | N/A
 |  |  |  |  |  | No | Direct | Payment | - | NHS
 |  |  |  |  |  | N/A
 |  |  |  |  |  | 12 | months
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
 |  |  |  |  |  | N/A
Spreadsheet: 349088d1412196037-pivotchart-keeps-duplicating-w08-pqdc-metrics
Sheet: People Pivot

Year | 2014
Month | 9
 | Data
Date | Sum of Meeting Goal | Sum of Not Meeting Goal | Sum of Goal
2014-09-01 00:00:00 | 0 | 0 | 2
2014-09-02 00:00:00 | 0 | 0 | 2
2014-09-03 00:00:00 | 2 | 0 | 2
2014-09-04 00:00:00 | 0 | 1 | 2
2014-09-05 00:00:00 | 0 | 0 | 2
2014-09-06 00:00:00 | 0 | 0 | 2
2014-09-07 00:00:00 | 0 | 0 | 2
2014-09-08 00:00:00 | 0 | 0 | 2
2014-09-09 00:00:00 | 0 | 0 | 2
2014-09-10 00:00:00 | 0 | 0 | 2
2014-09-11 00:00:00 | 0 | 0 | 2
2014-09-12 00:00:00 | 0 | 0 | 2
2014-09-13 00:00:00 | 0 | 0 | 2
2014-09-14 00:00:00 | 0 | 0 | 2
2014-09-15 00:00:00 | 0 | 1 | 2
2014-09-16 00:00:00 | 0 | 0 | 2
2014-09-17 00:00:00 | 0 | 0 | 2
2014-09-18 00:00:00 | 0 | 1 | 2
2014-09-19 00:00:00 | 0 | 0 | 2
2014-09-20 00:00:00 | 0 | 0 | 2
2014-09-21 00:00:00 | 0 | 0 | 2
2014-09-22 00:00:00 | 2 | 0 | 2
2014-09-23 00:00:00 | 0 | 1 | 2
2014-09-24 00:00:00 | 0 | 1 | 2
2014-09-25 00:00:00 | 0 | 1 | 2
2014-09-26 00:00:00 | 3 | 0 | 2
2014-09-27 00:00:00 | 0 | 0 | 2
2014-09-28 00:00:00 | 0 | 0 | 2
2014-09-29 00:00:00 | 0 | 1 | 2
2014-09-30 00:00:00 | 3 | 0 | 2
Grand Total | 10 | 7 | 60
Spreadsheet: 536560d1504570688-excel-template-for-monthly-work-recording-pay-by-day
Sheet: Daily Run sheet

Date | Driver | Helper
2017-08-01 00:00:00 | [NAME] | [NAME]
2017-08-01 00:00:00 | [NAME] | [NAME]
2017-08-02 00:00:00 | [NAME] | [NAME]
2017-08-02 00:00:00 | [NAME] | [NAME]
2017-08-03 00:00:00 | [NAME] | [NAME]
2017-08-03 00:00:00 | [NAME] | [NAME]
2017-08-04 00:00:00 | [NAME] | [NAME]
2017-08-04 00:00:00 | [NAME] | [NAME]
2017-08-05 00:00:00
2017-08-05 00:00:00 | [NAME] | [NAME]
2017-08-05 00:00:00 | [NAME] | [NAME]
2017-08-06 00:00:00 |  | [NAME]
2017-08-06 00:00:00 | [NAME]
2017-08-06 00:00:00 | [NAME] | [NAME]
2017-08-07 00:00:00 | [NAME] | [NAME]
2017-08-07 00:00:00 | [NAME] | [NAME]
2017-08-08 00:00:00 | [NAME] | [NAME]
2017-08-08 00:00:00 | [NAME] | [NAME]
2017-08-09 00:00:00 | [NAME] | [NAME]
2017-08-09 00:00:00 | [NAME] | [NAME]
2017-08-10 00:00:00 | [NAME] | [NAME]
2017-08-10 00:00:00 | [NAME] | [NAME]
2017-08-11 00:00:00 | [NAME] | [NAME]
2017-08-11 00:00:00 | [NAME] | [NAME]
2017-08-12 00:00:00 | [NAME] | [NAME]
2017-08-12 00:00:00 | [NAME] | [NAME]
2017-08-13 00:00:00 | [NAME] | [NAME]
2017-08-13 00:00:00 | [NAME] | [NAME]
2017-08-14 00:00:00 | [NAME] | [NAME]
2017-08-14 00:00:00 | [NAME] | [NAME]
2017-08-15 00:00:00 | [NAME] | [NAME]
2017-08-15 00:00:00 | [NAME] | [NAME]
Spreadsheet: 763713d1642342972-dates-to-display-correctly-from-data-validation-dropdown-list-dates_data_validation_dropdown-aligw
Sheet: Sheet3

 |  |  |  |  | Find Match from Date | Find Match | Find Match with Helper Date
 |  | DATE | Helper Date | PIC | 2017-04-19 00:00:00 |  | 02-Feb-2021
 |  | 2021-02-02 00:00:00 |  | A
 |  | 2020-05-01 00:00:00 |  | B
 |  | 2019-07-29 00:00:00 |  | C
 |  | 2018-10-25 00:00:00 |  | D
 |  | 2018-01-21 00:00:00 |  | E
 |  | 2017-04-19 00:00:00 |  | F
 |  | 2016-07-16 00:00:00 |  | G
 |  | 2015-10-13 00:00:00 |  | H
 |  | 2022-01-01 00:00:00 |  | I
Spreadsheet: 234669d1368161041-stop-insert-row-from-changing-functions-new-register
Sheet: Transmittal All

PROJECT NUMBER:
PROJECT NAME:
 |  |  |  |  |  | A.B.N. 81 010 761 378
 |  |  |  |  | REVISION DATES
[NAME]
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
[NAME] | SOFTCOPY
# = Number of copies | D = AUTOCAD DRAWING FORMAT (.DWG)
 | E = EMAIL
 | P = PDF FORMAT |  |  |  | REVISION HISTORY
 | U = UPLOAD
DRAWING TITLE | NUMBER | CURRENT STATUS
SPECIFICATIONS / CERTIFICATE / OTHER | NUMBER | CURRENT STATUS
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: WIP Explained

 | Include all contracts, change orders, credits
 |  | This formula is based on what GP% you enter for the job
 |  |  | This is the GP% you expect to make on the job…it can be changed if preceding months
 |  |  |  | The amount in this column comes direcly form your job cost report for all expenses of each job
 |  |  |  |  | This formula is column 'D' divided by column 'C'. Over 100% complete is not possible.
 |  |  |  |  |  | This formula is column 'B' multiplied by column 'E'.
 |  |  |  |  |  |  | This column is the total amount you have actually invoiced the
 |  |  |  |  |  |  | customer for each project through the end of the reporting period.
 |  |  |  |  |  |  |  | This column tells you whether you have billed
 |  |  |  |  |  |  |  | more than you've earned or less than
 |  |  |  |  |  |  |  | than you've earned
A | B | C | D | E | F | G | H | I
Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
06Irvin4 | 45000 |  | 0.4 | 25631.16 |  |  | 27000
06McCarthy | 11573 |  | 0.35 | 5236.89 |  |  | 6343.8
06Powers | 5376 |  | 0.35 |  |  |  | 1800
06Strong-2 | 374900 |  | 0.35 | 287561.45 |  |  | 318665
Report Total
Your BALANCE SHEET is the "keeper" of you WIP report total.
1. If your period total is UNDER BILLED, the amount will be in your WIP ASSET ACCT
2. If your period total is OVER BILLED, the amount will be in your WIP LIABILITY ACCT
Your PROFIT AND LOSS will have an adjusting entry in the income account (it will NOT equal your WIP report total except the first year).
1. UNDER BIILLED will add income.
2. OVER BILLED will subtract income.
****Remember the BN Income entry will be adjusting and will NOT equal your total report.
Spreadsheet: 867326d1714145045-formula-to-move-data-depending-on-project-start-date-project-start-date
Sheet: Calculation needed

Start Date | PROJECTS | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
2024-04-01 00:00:00 | [NAME]
2024-09-01 00:00:00 | SLOT2
2024-06-01 00:00:00 | SLOT3
2024-04-01 00:00:00 | SLOT4
2024-04-01 00:00:00 | SLOT5
2024-04-01 00:00:00 | SLOT6
2024-04-01 00:00:00 | SLOT7
2024-04-01 00:00:00 | SLOT8
2024-04-01 00:00:00 | SLOT9
Spreadsheet: 106619d1303844593-possible-raw-graph-data-w-labels-master-analysis-test
Sheet: Summary-line graph

Week Ending |  | 2010-08-31 00:00:00 | 2010-09-07 00:00:00 | 2010-09-14 00:00:00 | 2010-09-21 00:00:00 | 2010-09-28 00:00:00 | 2010-10-05 00:00:00 | 2010-10-12 00:00:00 | 2010-10-19 00:00:00 | 2010-10-26 00:00:00 | 2010-11-02 00:00:00 | 2010-11-09 00:00:00 | 2010-11-16 00:00:00 | 2010-11-23 00:00:00 | 2010-11-30 00:00:00 | 2010-12-07 00:00:00 | 2010-12-14 00:00:00 | 2010-12-21 00:00:00 | 2010-12-28 00:00:00 | 2011-01-04 00:00:00 | 2011-01-11 00:00:00 | 2011-01-18 00:00:00 | 2011-01-25 00:00:00 | 2011-02-01 00:00:00 | 2011-02-08 00:00:00 | 2011-02-15 00:00:00 | 2011-02-22 00:00:00 | 2011-03-01 00:00:00 | 2011-03-08 00:00:00 | 2011-03-15 00:00:00
GRAPH DATA | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 | AC | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 1 | 2 | 0 | 1 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 2 | 1 | 1 | 4 | 2 | 3 | 2
 | CH | 37 | 42 | 36 | 21 | 37 | 31 | 33 | 30 | 48 | 67 | 43 | 62 | 69 | 40 | 54 | 51 | 46 | 36 | 35 | 63 | 57 | 61 | 52 | 65 | 57 | 77 | 56 | 64 | 75
 | CT |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | En | 0 | 5 | 0 | 0 | 1 | 0 | 2 | 0 | 7 | 2 | 1 | 2 | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 9 | 0 | 1 | 3 | 1 | 0 | 0 | 0 | 1 | 1
 | FA | 6 | 5 | 11 | 7 | 20 | 13 | 10 | 7 | 7 | 13 | 10 | 11 | 11 | 12 | 12 | 10 | 13 | 8 | 8 | 9 | 17 | 6 | 12 | 7 | 15 | 9 | 7 | 15 | 13
 | IM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1
 | IN | 41 | 29 | 28 | 29 | 37 | 50 | 21 | 29 | 35 | 37 | 17 | 27 | 21 | 11 | 25 | 31 | 37 | 31 | 25 | 39 | 25 | 19 | 29 | 39 | 58 | 59 | 35 | 31 | 43
 | EM | 49 | 53 | 42 | 30 | 36 | 77 | 51 | 61 | 61 | 65 | 58 | 59 | 50 | 25 | 54 | 38 | 27 | 33 | 35 | 47 | 34 | 31 | 44 | 34 | 54 | 54 | 55 | 66 | 58
 | KB | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 2 | 5 | 3 | 0 | 1 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 0 | 1 | 2 | 1 | 1 | 0
 | OP | 0 | 0 | 0 | 1 | 2 | 1 | 4 | 2 | 6 | 2 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 2 | 2 | 6 | 4 | 2 | 2 | 1 | 3 | 3 | 1
 | RT | 35 | 24 | 26 | 18 | 41 | 40 | 27 | 28 | 40 | 33 | 30 | 36 | 28 | 25 | 42 | 46 | 46 | 22 | 41 | 40 | 76 | 53 | 38 | 51 | 40 | 67 | 58 | 57 | 70
 | WE | 10 | 2 | 6 | 5 | 12 | 13 | 15 | 8 | 11 | 16 | 19 | 16 | 17 | 16 | 12 | 9 | 8 | 7 | 5 | 13 | 7 | 9 | 12 | 10 | 18 | 13 | 15 | 10 | 16
 | GRAND TOTAL
Spreadsheet: 776164d1649539112-formula-for-countif-across-columns-with-different-required-values-formula-trouble
Sheet: Sheet1

ASE OR ASO | ASO | ASE
 | True
 |  | True
 | True
 |  | True
 | True
 |  | True
 | True
 |  | True
 | True
 |  | True
 |  | True
 | True
 |  | True
 | True
 | True
 | True
 | True
 | True
 | True
 |  | True
 |  | True
 |  | True
 |  | True
 |  | True
 |  | True
 |  | True
 | True
 | True
 | True
 |  | True
 | True
 | True
 | True
 | True
 | True
 |  | True
 |  | True
 |  | True
 |  | True
 | True
 |  | True
Spreadsheet: 30443d1225956658-conditional-formatting-based-on-other-cells-properties-conditionalformatting
Sheet: Sheet1

Amount | Expected Date
3709 | 2008-11-14 00:00:00
33295 | 2008-11-11 00:00:00
35 | 2008-11-16 00:00:00
122935 | 2008-12-12 00:00:00
1914 | 2008-11-14 00:00:00
453 | 2008-11-26 00:00:00
960 | 2008-11-23 00:00:00
11481645 | 2008-11-08 00:00:00
21592 | 2008-11-09 00:00:00
45000 | 2008-11-05 00:00:00
Total of Red Cells
Spreadsheet: 8cb1e853-e1f7-4a31-bf3c-6da3f34f55c8
Sheet: 5c-Budget Summary-Year 3

 | CDE CHARTER SCHOOL GRANT PROGRAM
 | [NAME], YEAR 3
 | FY2014-15
 |  | Project 1 | Project 2 | Project 3 | Project 4 | Project 5
Line | [NAME] |  |  |  |  |  | Total
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 | Subtotal-Instructional Program
SUPPORT PROGRAM
8 | Salaries (0100)
9 | Employee Benefits (0200)
10 | Purchased Professional & Technical Services (0300)
11 | Other Purchased Services (0500)
12 | Travel, Registration, and Entrance (0580)
13 | Supplies (0600)
14 | Subtotal- Support Program
15 | Grand Total - Instructional and Support Programs
16 | Capitalized Equipment (0730)
17 | Non-Caplitalized Equipment (0735)
18 | Total - Lines 15, 16, & 17
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -939 | -1588
2 | -2025 | -1588
3 | -2053 | -1588
4 | -1629 | -1588
5 | -2098 | -1588
6 | -980 | -1588
7 | -556 | -1588
8 | -833 | -1588 |  |  |  |  |  |  |  |  | Avg
9 | -2039 | -1588 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -1966 | -1588
11 | -2018 | -1588 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 | -1575 | -1588 |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 | -303 | -1588 |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 | -24 | -1588 |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 | -8 | -530 |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 | -17 | -530 |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -345354
2001-12-16 00:00:00
CBS Volume
 |  |  | -39976