tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839795d1692223391-help-please-with-a-multiple-line-conditional-countif-formula-elog-example-solution-
Sheet: Sheet1

 | DATE | SALES PERSON | CUSTOMER | STOCK NUMBER | BONUS 1 | BONUS 2 | BONUS 3 | FINANCE / CASH | REVIEW?
1 | 2023-03-01 00:00:00 | VELEZ | [NAME] | 251345A | YES | NO | YES | FINANCE | Y
2 | 2023-03-03 00:00:00 | GRIFFIN | [NAME] | 516794A | YES | YES | YES | CASH | Y
3 | 2023-03-03 00:00:00 | GENTRY | BOB | B156872 | NO | YES | YES | CASH | Y
4 | 2023-03-03 00:00:00 | MACKEY | STEPHANIE | 649257A | NO | YES | NO | CASH | Y
5 | 2023-03-04 00:00:00 | PRIGNANO | STEPHANIE | 111548A | NO | YES | YES | FINANCE | Y
6 | 2023-03-04 00:00:00 | EVANS | [NAME] | B002316 | YES | NO | NO | FINANCE | N
7 | 2023-03-05 00:00:00 | CARLILE | JACKIE | B154234 | NO | YES | YES | FINANCE | N |  |  |  | PTS
8 | 2023-03-05 00:00:00 | HERNANDEZ | SAM | 115426A | NO | NO | NO | FINANCE | N
9 | 2023-03-07 00:00:00 | ELIAS | [NAME] | 894657A | YES | NO | NO | CASH | Y
10 | 2023-03-08 00:00:00 | WALKER | [NAME] | [NAME] | YES | NO | NO | CASH | N |  |  | [NAME]
11 | 2023-03-09 00:00:00 | S MENDOZA | SARAH | 875461A | YES | NO | YES | FINANCE | N |  |  | [NAME]
12 | 2023-03-09 00:00:00 | [NAME] | HARAM | 113256A | NO | NO | YES | FINANCE | Y |  |  | BOB
13 | 2023-03-09 00:00:00 | [NAME] | STEPHANIE | 544216A | NO | NO | NO | FINANCE | Y |  |  | STEPHANIE
14 | 2023-03-10 00:00:00 | RODRIGUEZ | BOB | 664455A | NO | NO | YES | CASH | N |  |  | SAM
15 | 2023-03-10 00:00:00 | GILES | [NAME] | 218977A | NO | NO | NO | CASH | N |  |  | [NAME]
16 | 2023-03-11 00:00:00 | RODRIGUEZ | [NAME] | 778466A | NO | NO | NO | FINANCE | Y |  |  | SARAH
17 | 2023-03-11 00:00:00 | THORNTON | [NAME] | 225467A | YES | YES | NO | CASH | Y |  |  | HARAM
18 | 2023-03-12 00:00:00 | ALLMON | ALEX | B854679 | NO | NO | NO | FINANCE | N |  |  | [NAME]
19 | 2023-03-13 00:00:00 | DOROTHY | CLAUDIA | B465831 | YES | YES | NO | FINANCE | N |  |  | [NAME]
20 | 2023-03-14 00:00:00 | RIVERA | MEGHAN | 005589A | YES | YES | NO | CASH | Y |  |  | ALEX
21 | 2023-03-15 00:00:00 | MAREK | CLAUDIA | 346182A | NO | YES | NO | CASH | N |  |  | CLAUDIA
22 | 2023-03-16 00:00:00 | DAVIS | [NAME] | 216778A | NO | NO | NO | FINANCE | N |  |  | [NAME]
23 | 2023-03-16 00:00:00 | [NAME] | AMBER | B115468 | NO | YES | YES | FINANCE | N |  |  | AMBER
24 | 2023-03-18 00:00:00 | WARFIELD | LYNN | 888167A | NO | NO | NO | CASH | N |  |  | LYNN
25 | 2023-03-20 00:00:00 | CLARK | STEPHANIE | 884567A | YES | NO | YES | CASH | N
26 | 2023-03-22 00:00:00 | CHRISTIANSEN | [NAME] | 222581A | NO | YES | NO | CASH | Y
27 | 2023-03-23 00:00:00 | VAN DUSEN | SAM | B124658 | YES | NO | YES | FINANCE | Y
28 | 2023-03-23 00:00:00 | REYES | [NAME] | 112233A | NO | YES | NO | CASH | N
29 | 2023-03-24 00:00:00 | [NAME] | CLAUDIA | 894521A | YES | YES | YES | CASH | N
30 | 2023-03-28 00:00:00 | WELLINGER | LYNN | 775511A | NO | YES | NO | FINANCE | N
Spreadsheet: kate_symes__18191__EESSales_dailyfeb
Sheet: 2-27

NP15 | 2001-02-27 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 208.73 | Fixed Off Peak | 143.67 |  |  |  | Fixed Peak | 191 |  | Fixed Off Peak | 126 |  |  | Fixed Peak | 191 |  | Fixed Off Peak | 126
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -9.18 | -9.18 |  |  | 1 | -66.88 | 0 | -54 | -76.88 |  |  | 1 | -1.99 | 0 | 0 | -1.99
2 | 0 | 0 | -8.4 | -8.4 |  |  | 2 | -68.38 | 0 | -54 | -71.39 |  |  | 2 | -1.96 | 0 | 0 | -1.96
3 | 0 | 0 | -7.98 | -7.98 | 0 |  | 3 | -68.97 | 0 | -44 | -68.97 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | 0 | 0 | -7.97 | -7.97 |  |  | 4 | -68.68 | 0 | -44 | -69.68 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | 0 | 0 | -8.13 | -8.13 |  |  | 5 | -68.51 | 0 | -44 | -75.51 |  |  | 5 | -1.94 | 0 | 0 | -1.94
6 | 0 | 0 | -10.36 | -10.36 |  |  | 6 | -65.75 | 0 | -54 | -91.75 |  |  | 6 | -2.04 | 0 | 0 | -2.04
7 | 0 | 0 | -14.22 | -14.22 |  |  | 7 | -53.66 | 0 | -54 | -87.66 |  |  | 7 | -2.2 | 0 | 0 | -2.2
8 | 0 | 0 | -16.59 | -16.59 |  |  | 8 | -101.43 | 0 | -54 | -102.42 |  |  | 8 | -2.3 | 0 | 0 | -2.3
9 | 0 | 0 | -16.88 | -16.88 |  |  | 9 | -100.85 | 0 | -54 | -115.85 |  |  | 9 | -2.31 | 0 | 0 | -2.31
10 | 0 | 0 | -15.85 | -15.85 |  |  | 10 | -102.31 | 0 | -54 | -125.31 |  |  | 10 | -2.27 | 0 | 0 | -2.27
11 | 0 | 0 | -15.69 | -15.69 |  |  | 11 | -102.5 | 0 | -54 | -130.5 |  |  | 11 | -2.26 | 0 | 0 | -2.26
12 | 0 | 0 | -16.98 | -16.98 |  |  | 12 | -101.43 | 0 | -54 | -132.42 |  |  | 12 | -2.31 | 0 | 0 | -2.31
13 | 0 | 0 | -16.91 | -16.91 |  |  | 13 | -101.41 | 0 | -54 | -134.41 |  |  | 13 | -2.31 | 0 | 0 | -2.31
14 | 0 | 0 | -16.77 | -16.77 |  |  | 14 | -101.25 | 0 | -54 | -135.24 |  |  | 14 | -2.3 | 0 | 0 | -2.3
15 | 0 | 0 | -16.35 | -16.35 |  |  | 15 | -101.74 | 0 | -54 | -134.75 |  |  | 15 | -2.29 | 0 | 0 | -2.29
16 | 0 | 0 | -16.47 | -16.47 |  |  | 16 | -101.72 | 0 | -54 | -129.73 |  |  | 16 | -2.29 | 0 | 0 | -2.29
17 | 0 | 0 | -16.77 | -16.77 |  |  | 17 | -101.08 | 0 | -54 | -124.08 |  |  | 17 | -2.3 | 0 | 0 | -2.3
18 | 0 | 0 | -18.44 | -18.44 |  |  | 18 | -99.57999999999993 | 0 | -54 | -124.58 |  |  | 18 | -2.37 | 0 | 0 | -2.37
19 | -0.58 | 0 | -20 | -20.58 |  |  | 19 | -97.17 | 0 | -54 | -121.16 |  |  | 19 | -2.47 | 0 | 0 | -2.47
20 | 0 | 0 | -19.1 | -19.1 |  |  | 20 | -98.65 | 0 | -54 | -115.65 |  |  | 20 | -2.41 | 0 | 0 | -2.41
21 | 0 | 0 | -17.61 | -17.61 |  |  | 21 | -100.18 | 0 | -54 | -108.19 |  |  | 21 | -2.34 | 0 | 0 | -2.34
22 | 0 | 0 | -16.01 | -16.01 |  |  | 22 | -102.07 | 0 | -54 | -97.07 |  |  | 22 | -2.28 | 0 | 0 | -2.28
23 | 0 | 0 | -13.61 | -13.61 |  |  | 23 | -62.88 | 0 | -54 | -105.89 |  |  | 23 | -2.17 | 0 | 0 | -2.17
24 | 0 | 0 | -11.08 | -11.08 |  |  | 24 | -65.29 | 0 | -54 | -89.29 |  |  | 24 | -2.06 | 0 | 0 | -2.06
Spreadsheet: 874452d1721051562-how-to-extract-the-year-and-month-month-etaf
Sheet: ag-grid

Number | Name | Description | Project Manager | Site Manager | Client | Order Number | Order Value | Status | Created On | Created By | Month | year
PR-00023 | [NAME] | refit | [NAME] | [NAME] | [NAME] | hello | 1081405.29 | Open | 05/07/2024 | [NAME]
PR-00014 | Players bar - AVFC | ac units |  |  | [NAME] |  | 4531.3 | Open | 03/07/2024 | [NAME]
PR-00008 | Solihull arts centre | set AC unites and Add pipe work | [NAME]  Hancock | [NAME] | [NAME] | SOLArtix | 3585.71 | Open | 2024-04-02 00:00:00 | [NAME]
PR-00006 | Testco | testing |  |  | [NAME] |  | 3585.71 | Open | 02/07/2024 | [NAME]
PR-00001 | Redditch Police station | refit AC units | [NAME] | [NAME] | [NAME] | [NAME] | 1305031.19 | Open | 02/07/2024 | [NAME]
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Indovision (Indonesia)

Indovision (Indonesia)
Date | Channel | Start (GMT) | End (GMT) | Notes
2010-11-21 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | Vision 1 Sports | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | Vision 1 Sports | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | Vision 1 Sports | 14:00:00 | 16:30:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | Vision 1 Sports | 20:00:00 | 22:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | Vision 1 Sports | 17:30:00 | 20:30:00 | Singles Final - Live
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DN53 SBZ

 |  |  |  |  | [NAME]
Registration number : | [NAME] |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | Volkswagen |  | 2007-11-30 00:00:00 | 12 Months | 2008-12-01 00:00:00 | 115
Specification : | Diesel
Type : | Golf
1st Registered : | n/a
Engine : | n/a
[NAME] : | n/a
Back To Index
Spreadsheet: 0cde8c14-05a5-4c22-bf64-682b49c6fcaa
Sheet: Sheet1

 |  |  |  | IMPERIAL VALLEY COLLEGE
 |  |  |  | WOMEN'S BASKETBALL
 |  |  |  | 2013-2014
 | Name | # | YR | POS | HT |  | High School |  | DEPARTURE TIME
 | [NAME] | 1 | F | G | 5' 2" |  | Brawley Union HS
 |  |  |  |  |  |  |  |  | 07:00:00
 | April Dorame | 3 | S | G/F | 5' 5" |  | Calexico HS |  | 07:00:00
 | [NAME] | 4 | F | F/C | 5' 11" |  | Central Union HS |  | 07:00:00
 | [NAME] | 5 | S | F/C | 5' 8" |  | Imperial HS
 |  |  |  |  |  |  |  |  | 1:00PM
 | [NAME] | 11 | F | G | 5' 5" |  | Southwest HS
 | [NAME] | 20 | F | F | 5' 8" |  | Southwest HS
 |  |  |  |  |  |  |  |  | 1:00PM
 | [NAME] | 22 | F | F | 5' 9" |  | Imperial HS
 |  |  |  |  |  |  |  |  | 1:00PM
 | Ana Rodriguez | 23 | F | G | 5' 5" |  | Calexico HS
 |  |  |  |  |  |  |  |  | 15:00:00
* Denotes Conference Games |  |  |  |  |  |  |  |  | 13:00:00
# Denotes doubleheaders
 |  |  |  |  |  |  |  |  | 1:00PM
 | Head Coach: | [NAME] |  | (760) 355 - 6165 |  | President:  Dr. [NAME]
 | Asst. Coach: | [NAME] |  | (760) 355 - 6325 |  | Dean of Student Affairs: Serio Lopez
 | Student Mgt. | [NAME]
 | Student Mgt. | [NAME]
 | Student Mgt. | [NAME]
 | Athletic Director: | [NAME] |  | (760) 355 - 6341
 | Secretary: | [NAME] |  | (760) 355 - 6325 |  | [NAME]: |  | Arabs
 | Athletic Trainer: | [NAME] Mays |  | (760) 355 - 6329 |  | School Colors: |  | Scarlet, Black & White
 |  | Athletic Fax |  | (760) 355 - 6514 |  | Conference: |  | Pacific Coast Athletic Conference
 |  |  |  | Athletic Department 380 East Aten Rd. Imperial, CA 92251
 |  |  |  |  |  |  |  | 10/19/2013 DR
Spreadsheet: 873481d1719968658-how-to-combine-daily-sales-remaining-stock-into-one-table-combine-akir4-
Sheet: Sheet2

Date | Order Number | Name | Orange | [NAME] | Mango
2024-07-01 00:00:00 | 33-1525 | [NAME] | 9 | 9
2024-07-01 00:00:00 | 33-1526 | [NAME] | 3 | 3 | 3
2024-07-01 00:00:00 | 33-1527 | [NAME] | 6 | 6 | 6
2024-07-01 00:00:00 | 33-1528 | Amazon | 9 | 9
2024-07-01 00:00:00 | 33-1529 | Alibaba | 3 | 3 | 3
2024-07-02 00:00:00 | 33-1530 | [NAME] | 3 | 3 | 3
2024-07-02 00:00:00 | 33-1531 | veronia |  | 6
2024-07-02 00:00:00 | 33-1532 | olivia | 12 |  | 12
2024-07-02 00:00:00 | 33-1533 | Amazon | 3 | 3
2024-07-02 00:00:00 | 33-1534 | Alibaba |  |  | 9
2024-07-03 00:00:00 | 33-1535 | [NAME] | 3 | 3 | 3
2024-07-03 00:00:00 | 33-1536 | phei |  | 6 | 6
2024-07-03 00:00:00 | 33-1537 | [NAME] |  | 10 | 9
2024-07-03 00:00:00 | 33-1538 | Amazon | 9
2024-07-04 00:00:00 | 33-1540 | [NAME] | 6
2024-07-04 00:00:00 | 33-1541 | [NAME] |  | 3
2024-07-04 00:00:00 | 33-1542 | [NAME] |  | 3
2024-07-04 00:00:00 | 33-1543 | Amazon |  | 6
2024-07-04 00:00:00 | 33-1544 | Alibaba | 3
2024-07-05 00:00:00 | 33-1545 | [NAME] | 6
2024-07-05 00:00:00 | 33-1546 | phei | 3 | 3 | 9
2024-07-05 00:00:00 | 33-1547 | [NAME] | 6
2024-07-05 00:00:00 | 33-1548 | Amazon |  | 3
2024-07-05 00:00:00 | 33-1549 | Alibaba | 24 | 12 | 12
Spreadsheet: 669558d1585462511-using-another-sheet-like-function-almost-curcular-function-from-other-sheet
Sheet: Sheet 1

a | b | c | d | e | f | g | Result
89 | 66 | 11 | 494 | 6 | 4 | 4 | ? | See sheet 2
16 | 8 | 1535 | 615 | 6 | 65 | 684 | ?
1 | 79 | 654 | 61 | 5146 | 6 | 548 | ?
1 | 798 | 651 | 494 | 56 | 15 | 108 | ?
51 | 598 | 14 | 44 | 4 | 9 | 552 | ?
10 | 514 | 984 | 8 | 649 | 49 | 173 | ?
4 | 5166 | 984 | 646 | 489 | 4 | 651 | ?
4 | 91 | 984 | 511 | 4 | 516 | 88 | ?
89 | 89 | 98 | 6 | 1 | 19 | 44 | ?
4984 | 897 | 11 | 98 | 9 | 849 | 251 | ?
981 | 978 | 984 | 41 | 6 | 49 | 528 | ?
998 | 789 | 87 | 6 | 94 | 4 | 508 | ?
1 | 98 | 45 | 51 | 9 | 149 | 779 | ?
9 | 489 | 65 | 98 | 94 | 4 | 730 | ?
1 | 98 | 9874 | 4 | 2 | 984 | 898 | ?
Test Area | Row Num>>> | 7 | << Change this number to row above in Yellow
Change the row number in cell C20 from 2 to 16
That will copy that row down to row 21
The cells in Sheet 2 get values from Row 21!!!
Then cell H21 is what is in Sheet 2 Result.
Copy and paste that value up to correct row using Values Only…
Spreadsheet: 475833d1471473685-fil-an-excel-sheet-automatically-ef958_subsid_sheets_to_master
Sheet: Program 3

FULL Program | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Program 3 - Projet AAA | 0 | 0 | 0 | 2.86 | 5.72 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78
Program 3 - Projet BBB | 0 | 0 | 0 | 0 | 0.5
Program 3 - Projet CCC | 0 | 0 | 0 | 1.1 | 2.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 5.35 | 5.51 | 5.68 | 5.85 | 6.025 | 6.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 1
 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: 706006d1606406386-if-function-based-on-the-calculations-of-another-cell-uploadtoforum
Sheet: Sheet1

[NAME] | name | list_price | standard_dealer_price | brand | vendor_number | status | upc | length | width | height | weight | has_map_policy |  |  |  | product_name | R BLANK | MYCOST | Brand Discount | MSRP | UPLOAD? | MAP$ | MAP% | SELLING1 | ROUNDED | Brand | Desc. | SHIP$ | MY% |  |  | PSS# | UPLOAD |  | [NAME] per brand |  | [NAME] | actual_dealer_price
59-5389 | HOOD VENTS POL PRO | 139.95 | 19.99 | 2 COOL | PO-125 | NLA |  | 28 | 8 | 1 | 1.25 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5389 | 7
59-5395 | SIDE MIDDLE VENTS | 74.95 | 52.99 | 2 COOL | AC-301 | STK |  | 26 | 8 | 0.01 | 0.2 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5395 | 9
59-5387 | INTAKE VENT | 139.95 | 19.99 | 2 COOL | AC-203-BK | NLA |  | 24 | 8 | 1 | 0.75 | false |  |  |  | Air Vent Intake Kit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5387 | 11
59-5394 | SIDE TOP VENTS | 74.95 | 52.99 | 2 COOL | AC-300 | STK |  | 20 | 8 | 0.01 | 0.35 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5394 | 19
59-5368 | LARGE TOP VENTS A/C PROCLIMB / YAM VIPER | 139.95 | 19.99 | 2 COOL | AC-222 | NLA |  | 18 | 12 | 0.5 | 1.25 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5368 | 21
59-5367 | SIDE BOTTOM VENTS | 85.95 | 60.99 | 2 COOL | AC-302 | STK |  | 17.5 | 12 | 0.01 | 0.2 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5367 | 29
59-5378 | BOTTOM FRONT VENTS A/C PROCLIMB / YAM VIPER | 69.95 | 29.39 | 2 COOL | AC-220 | NLA |  | 14 | 8 | 0.5 | 0.5 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5378 | 31
59-5345 | SIDE KNEE VENTS POL [NAME] | 69.95 | 48.99 | 2 COOL | PO-155 | STK |  | 13.6 | 8.05 | 0.9 | 0.48 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5345 | 18
59-5343 | BOTTOM FRONT VENTS AXYS POL POL | 69.95 | 48.99 | 2 COOL | PO-153 | STK |  | 13.5 | 15 | 0.65 | 0.4 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5343 | 49
59-5362 | NOSE VENT S-D XM | 39.95 | 29.99 | 2 COOL | SK-436 | STK |  | 13.3 | 8.05 | 1.15 | 0.21 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5362 | 51
59-5361 | SIDE FRONT VENTS XP | 74.95 | 19.99 | 2 COOL | SK-401-BK | CLO |  | 12.15 | 8 | 1.55 | 0.45 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5361 | 99
59-5366 | SHOCK TOWER VENTS | 45.95 | 32.99 | 2 COOL | AC-303 | STK |  | 11.6 | 11.05 | 0.6 | 0.28 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5366 | 101
59-5358 | KNEE VENTS XP | 79.95 | 16.8 | 2 COOL | SK-403-BK | CLO |  | 10.75 | 8.1 | 1.15 | 0.52 | false |  |  |  | Air Vents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59-5358 | 200
Spreadsheet: 6461d826-231e-4c78-8a94-3f7995813cdd
Sheet: Sheet1

N.C. Department of Environment and Natural Resources | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31
Office of the Controller
CONTRACT EXPENDITURE REPORT
 |  |  |  | (DO NOT USE the Cash Disbursements Code Sheet for Contract Payments.)
 |  |  |  | ***PLEASE USE YOUR TAB KEY TO ACCESS AVAILABLE FIELDS***
Reporting Period (Date) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchase Order Number (Required)
Division/Section/Prog |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO Line Number (Required)
Contract Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal Year (Required)
Contractor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Current Expenditures (Required) |  |  |  |  |  |  |  |  |  | 0
Purpose
Invoice Number |  |  |  | Invoice Date |  | Company |  | Account          (Account must match account on P.O.) |  |  |  |  |  |  | 1099 code |  | Center |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Center must match Center on P.O.)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  |  |  | 0
[NAME].
FED ID No.
BID ID No.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Administrator (Mandatory Signature) |  |  |  |  |  |  |  |  |  |  |  | Date
Contract Recap for Line |  |  |  |  |  | 0
Beginning Balance for Line
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Division/Section Head (Mandatory Signature) |  |  |  |  |  |  |  |  |  |  |  | Date
Total YTD Payments
Ending Balance Available |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contractor Fiscal Officer (Mandatory Signature) |  |  |  |  |  |  |  |  |  |  |  | Date
Mail to: |  | [NAME]
 |  | Office of the Controller
 |  | 1606 Mail Service Center |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLEASE USE BLUE PAPER
 |  | Raleigh, NC 27699-1606
DENR 2481 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rev 03-01-13
Spreadsheet: 57446d1257591911-sum-of-week-to-date-if-meeting-criteria-706347_bob_mccusker
Sheet: Transactions

NUMBER | DATE | Entity | sub-acct #1a | Account | sub-acct #1b | sub-acct #2 | TRANS | WK | 2009-11-06 00:00:00
0008 | 2009-11-06 00:00:00 | XYZ | taxi | expenses | car | repairs | -75 | 1
0007 | 2009-11-05 00:00:00 | XYZ | [NAME] | expenses | car | gas | -50 | 1
0006 | 2009-11-04 00:00:00 | XYZ | taxi | expenses | car | gas | -40 | 1
0005 | 2009-11-03 00:00:00 | XYZ | taxi | expenses | advertising | online | -20 | 1
0004 | 2009-11-02 00:00:00 | XYZ | [NAME] | expenses | car | gas | -30 | 1
0003 | 2009-11-01 00:00:00 | XYZ | [NAME] | expenses | car | repairs | -250 | 1
0002 | 2009-10-31 00:00:00 | XYZ | taxi | expenses | advertising | print | -100 | 1
0001 | 2009-10-30 00:00:00 | XYZ | [NAME] | expenses | car | gas | -50 | 2
Spreadsheet: gerald_nemec__11336__AUGUST 2001 GTC DEAL CLEARING COUNT
Sheet: Sheet1

Counterparty | CP ID# | Credit Watch Rating | Total # Firm GTCs | Total # "Spot" GTCs | Total # Online GTCs | TOTAL DEALS CLEARING ON GTCs | BILATERAL MASTER FIRM CONTRACT | BILATERAL MASTER "SPOT" CONTRACT | OTHER MASTER CONTRACTS | NOTES / COMMENTS
Ashland Specialty Chemicals Company | 71223 | N/A | 0 | 0 |  |  | N/A | N/A | N/A
Colonial Energy Inc. | 49410 | N/A | 0 | 0 |  |  | N/A | N/A | N/A
Constellation Power Source, Inc. | 55134 | N/A | 0 |  |  |  | N/A | N/A | N/A
Duke Energy Marketing Limited Partnership | 54980 | N/A | 0 |  |  |  | N/A | N/A | N/A
Dynegy Canada Inc. | 65292 | N/A |  |  |  |  | N/A | N/A | N/A
Engage Energy Canada L.P. | 53341 | N/A |  | 0 |  |  | N/A | N/A | N/A
Hess Energy Services Company, LLC | 63597 | N/A | 0 |  |  |  | N/A | N/A | N/A | MPSF terminated effective 10/1/99 per Counterparty letter dated 8/31/1999.
Highland Energy Company | 1709 | 11 |  |  |  |  | N/A | N/A | N/A | GISB Assigned to HPL/AEP/Lodisco.
Nexen Marketing | 57251 | N/A |  | 0 |  |  | N/A | N/A | N/A
Nicor Gas Company | 61057 | N/A | 0 | 0 |  |  | N/A | N/A | N/A
Noble Gas Marketing Inc. | 155 | N/A | 0 | 0 |  |  | 96001113 MPSFI 08/01/94 | N/A | N/A | MPSFI rejected for EOL per Credit 10/12/99.
Pepco Gas Services, Inc. | 72441 | N/A | 0 | 0 |  |  | N/A | N/A | N/A
Prior Energy Corporation | 2630 | N/A |  | 0 |  |  | N/A | 96001224 MPSS 09/01/94 | N/A | MPSS rejected for EOL per Credit 10/12/99.
Tenaska Gas Storage, LLC | 77252 | N/A | 0 |  |  |  | N/A | N/A | N/A
Torch Energy TM, Inc. | 79508 | 11 |  |  |  |  | N/A | N/A | N/A | GISB Assigned to HPL/AEP/Lodisco.
USGT/Aquila, L.P. | 76789 | N/A | 0 |  |  |  | N/A | N/A | N/A
Spreadsheet: 137534d1327196269-excel-2008-number-cells-using-a-condition-in-another-cell-test-sheet
Sheet: Sheet1

 |  | [NAME] OF QUANTITIES
 |  | Project:
 |  | Date:
 |  | Client:
No. | Item | Unit | Qty | Rate | Total
 | SECTIONS-
 | CEILINGS - PARTITIONS - EXTERNAL WORKS - CARPENTRY - ADDENDUMS
 | *NOTE - Green star requirements for timber, adhesives and insulation. No
 | requirements for plasterboard.
 | CEILINGS
 | CLG1 - Exposed grid 1200 x 600 [NAME] SE tile with Peakform 24mm
 | exposed Tee grid
1 | Levels 1 - 11 height 2.7m | m2 | 16443.2
 | GLG2 - Suspended flush set 13mm pb ceiling
2 | GF height 8.0m | m2 | 43.1
3 | Levels 1 - 11 height 2.7m | m2 | 387.9
 | Total Excluding GST:
Spreadsheet: 91410d1291148236-dynamic-list-2010-11-30-dynamic-list-example
Sheet: Employees

ServiceCenter | Emp# | EmpGUID | Employee |  | ServiceCenter |  | #Emp | EmpGUID | Employee |  |  |  |  |  |  |  |  |  |  |  | -
1 | 1 |  | emp1 |  |  |  | 1
1 | 2 |  | emp2 |  |  |  | 2
1 | 3 |  | emp3 |  |  |  | 3
1 | 4 |  | emp4 |  |  |  | 4
1 | 5 |  | emp5 |  |  |  | 5
2 | 1 |  | emp6 |  |  |  | 6
2 | 2 |  | emp7 |  |  |  | 7
3 | 1 |  | [NAME] |  |  |  | 8
3 | 2 |  | emp9 |  |  |  | 9
3 | 3 |  | emp10
3 | 4 |  | emp11
3 | 5 |  | emp12
3 | 6 |  | emp13
3 | 7 |  | emp14
3 | 8 |  | emp15
3 | 9 |  | emp16
4 | 1 |  | emp17
5 | 1 |  | emp18
5 | 2 |  | emp19
6 | 1 |  | emp20
6 | 2 |  | emp21
6 | 3 |  | emp22
6 | 4 |  | emp23
Spreadsheet: 718604d1613233163-count-function-for-dates-month-and-year-and-text-count-dates-eg2
Sheet: Sheet1

Example
[NAME] |  |  |  | [NAME]
 |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Date Raised | Status |  | No of Events Raised
2021-01-01 00:00:00 | Open |  | Events Open | 1 | 0 | 0 | 1 | 0 | 1
2021-01-05 00:00:00 | Closed |  | Events Closed
2021-02-10 00:00:00 | In-Progress
2021-04-15 00:00:00 | Open
2020-01-21 00:00:00 | Open |  | To count the number of times an event is in OPEN status (column b) for each month and year.  [NAME] required in E5.
2021-01-31 00:00:00 | Closed
2021-07-14 00:00:00 | Open