tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766332d1643844883-risk-assessment-with-multiple-likelihood-and-consequence-inputs-risk-assessment-template
Sheet: Matrices Used

Likelihood |  | Consequence |  | Rating
Almost Certain |  | Catastrophic |  | Severe
Likely |  | Major |  | High
Possible |  | Moderate |  | Medium
[NAME] |  | Minor |  | Low
Remote |  | Insignificant |  | Low
Table: Likelihood
Numerical | % | Historical |  |  | Likelihood |  |  | Table: Risk Rating
>1 in 10 | >80% | Is expected to occur in most circumstances | Likelihood |  | 1 | Almost Certain |  | Likelihood |  | Consequence
 |  | Has occurred in the AAD or similar in the past year |  |  |  |  |  |  |  | 1 | 10 | 100 | 1000 | 10000
1 in 10 – 100 | 40 – 80% | Will probably occur |  |  | 0.1 | Likely |  |  |  | Insignificant | Minor | Moderate | Major | Catastrophic
 |  | Has occurred in the AAD or similar in the past two years |  |  |  |  |  | 1 | Almost Certain | Medium | Medium | High | Severe | Severe
1 in 100 – 1,000 | 20 – 40% | Might occur at some time in the future |  |  | 0.001 | Possible |  | 0.1 | Likely | Low | Medium | High | High | Severe
 |  | Has occurred in the AAD or similar in the past five years |  |  |  |  |  | 0.01 | Possible | Low | Low | Medium | High | High
1 in 1,000 – 10,0000 | 10 – 20% | Could occur but considered unlikely or doubtful |  |  | 0.001 | Unlikely |  | 0.001 | Unlikely | Low | Low | Medium | Medium | High
 |  | Has occurred in the AAD or similar in the past ten years |  |  |  |  |  | 0.0001 | Remote | Low | Low | Low | Medium | Medium
1 in 10,000 – 100,000 | <10% | May occur in exceptional circumstances. Has not occurred in the AAD or similar in the past ten years |  |  | 0.0001 | Remote
Spreadsheet: 689254d1596219223-if-index-match-formula-your-help-needed-2020-07-31-oeldere-mjboertien-689131d1596135976-if-index-match-formula-your-help-needed-book2
Sheet: Sheet1

Price | Single/double product | Output | helpcolumn |  |  | List | Price | Result
0.8 | Single
0.9 | Single
0.76 | Double
0.79 | Double
0.64 | Single
0.6 | Single
0.93 | Single
Hi all,
I need a formula that explains the following:
If text in Column B equals "single", then find the next cell in Column B that equals "single", and return the value in Column A of that particular row ONLY when the value is greater than the previous price.
In attached file it is basically: B2 is single, the formula looks for next single (which is B3), and if B3>B2 then return A3.
I cannot use VLOOKUP since my file is not organized. I expect it is something with INDEX/MATCH in combination with an IF function.
Spreadsheet: 781376d1653291376-change-in-lookup-to-different-sheet-not-working-northfields-review-test-etaf
Sheet: Value Output

Job Data |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Audit | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TM
Spreadsheet: 688898d1596013175-search-and-return-based-on-text-book1
Sheet: Sheet2

L405 Cover Demand Based on Poland Schedule's
 |  |  | 2020-07-28 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 |  |  |  | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00
 |  |  | 2020-07-31 00:00:00 | 2020-08-07 00:00:00 | 2020-08-14 00:00:00 | 2020-08-21 00:00:00 | 2020-08-28 00:00:00 | 2020-09-04 00:00:00 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00 | 2020-10-02 00:00:00 | 2020-10-09 00:00:00 | 2020-10-16 00:00:00 | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00 |  |  |  | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00
Part no. | Description 1 | Description 2 | WK 31 | WK 32 | WK 33 | WK 34 | WK 35 | WK 36 | WK 37 | WK 38 | WK 39 | WK 40 | WK 41 | WK 42 | WK 43 | WK 44 | WK 45 | WK 46 | WK 47 | Weekly  Avergae |  |  | WK 48
14469301 | 405 COV NARVIK BLACK | JLR HANDLE COVER NAR | 0 | 2000 | 0 | 1120 | 1160 | 1040 | 840 | 1000 | 1440 | 840 | 880
14469401 | 405 COV SHADOW ATLAS | JLR HANDLE COVER SHA | 0 | 880 | 0 | 560 | 480 | 720 | 520 | 640 | 1040 | 640 | 600
14538401 | 405 COV BRIGHT CHROME | JLR HANDLE COVER BRI | 0 | 0 | 0 | 80 | 120 | 80 | 80 | 80 | 200 | 80 | 80
14818301 | 405 COV BRIGHT ATLAS | JLR HANDLE COVER ATL | 0 | 0 | 0 | 0 | 0 | 440 | 560 | 960 | 1400 | 800 | 840
13015101 | 405 LHL NARVIK BLACK | JLR CAP NAR | 0 | 480 | 0 | 320 | 240 | 200 | 120 | 200 | 360 | 120 | 120
13015201 | 405 LHL SHADOW ATLAS | JLR CAP SHA | 120 | 280 | 0 | 160 | 120 | 120 | 120 | 40 | 320 | 120 | 40
14258501 | 405 LHL BRIGHT CHROME | JLR CAP BRI | 40 | 40 | 0 | 0 | 40 | 80 | 0 | 0 | 40 | 0 | 0
14818201 | 405 LHL BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 360 | 160 | 160
13015501 | 405 N/L NARVIK BLACK | JLR CAP NAR | 680 | 2000 | 0 | 800 | 960 | 720 | 680 | 760 | 1280 | 640 | 600
13015701 | 405 N/L SHADOW ATLAS | JLR CAP SHA | 400 | 1240 | 0 | 360 | 400 | 440 | 440 | 480 | 920 | 520 | 360
14818501 | 405 N/L BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1240 | 560 | 680
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA | 0 | 120 | 0 | 0 | 0 | 40 | 0 | 40 | 80 | 40 | 0
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14818401 | 405 RHL BRIGHT ATLAS | JLR CAP SHA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 171964d1343927701-formatting-so-that-excel-expands-from-the-middle-example
Sheet: comuunicaitons

Communications
Communications | phone |  | 28 |  |  | Would you like to have adjustable volume on your phone or a set volume.
Communications | radio |  | 27 |  |  | Rate how loud or quiet the radio interface is.
Communications |  |  | 27 |  |  | On a scale from one to five how far away is the phone/ radio?
Communications |  |  | 14 |  |  | How often do you have to repeat yourself due to clarity?
Communications |  |  | 27 |  |  | How many times is there miscommunication due to faulty equipment?
Communications |  |  | 27 |  |  | How many times is there a loss in communications between shifts ?
Spreadsheet: joe_parks__15002__BridgeDPR0528
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 3044.7818146 | 5047.781814599999 | 10338.7818146
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 3044.7818146 | 5047.781814599999 | 10338.7818146
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 779159d1651605560-formula-to-assist-in-populating-cells-between-2-worksheets-for-help
Sheet: 2022-2023-Applicants

HOME
Last Name | First Name | Name | CUID# | [NAME] | Degree Program | Field | Column1 | Column2 | Column3 | NEW? | ELIGIBLE? | FA Acceptance | SP Acceptance | AY Acceptance | Comments
Maine | [NAME] |  |  |  | PhD | Plant Pathology and Plant Molecular Biology |  |  |  |  | Yes
Doe | [NAME] |  |  |  | PhD | Genetics Genomics Development |  |  |  |  | Yes
Doe | [NAME] |  |  |  | PhD | Ecology and Evolutionary Biology |  |  |  |  | Yes
Subway | [NAME] |  |  |  | PhD | Ecology and Evolutionary Biology |  |  |  |  | Yes
Spaulding | Dotty |  |  |  | PhD | Natural Resources |  |  |  |  | Yes
Spreadsheet: 690821d1597310929-simple-warehouse-location-management-template-my-sample-wms
Sheet: Rack

Item Code | [NAME] | Quantity | [NAME]
CK1 | CK1 | 9 | A1
CK2 | CK2 | 12 | A1
CK3 | CK3 | 3 | A1
CK4 | CK4 | 54 | A1
CK5 | CK5 | 32 | A1
CA1 | CA1 | 4 | A2
CA2 | CA2 | 231 | A2
CA3 | CA3 | 47 | A2
CK3 | CK3 | 52 | A2
CA5 | CA5 | 121 | A2
DK1 | DK1 | 12 | B1
DK2 | DK2 | 45 | B1
DK3 | DK3 | 78 | B1
CK3 | CK3 | 44 | B1
DK5 | DK5 | 69 | B1
CK3 | CK3 | 32 | B2
DD2 | DD2 | 47 | B2
DD3 | DD3 | 66 | B2
DD4 | DD4 | 12 | B2
DD5 | DD5 | 79 | B2
CK3 | CK3 | 456 | C1
EK2 | EK2 | 1028 | C1
EK3 | EK3 | 4 | C1
EK4 | EK4 | 63 | C1
EK5 | EK5 | 99 | C1
ED1 | ED1 | 36 | C2
ED2 | ED2 | 62 | C2
ED3 | ED3 | 34 | C2
ED4 | ED4 | 51 | C2
CK3 | CK3 | 71 | C2
Spreadsheet: 849545d1699977566-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-example-for-forum-jean_sibelius-
Sheet: Labelling data

Copy column K (Selection of DATA) | Manually label each item in column A | Value | Label | Source1 | Source2 |  |  | [NAME] (via Data Validation / Allow List / ...)
 |  | An apparatus | System | publ2022
An apparatus | System | An apparatus | System | publ2022 |  |  |  | System
A reticle stage | Module | A metrology tool | System | publ2022 |  |  |  | Module
A method for improving a nuisance rate | Method | A lithographic apparatus | System | publ2022 |  |  |  | Component
A height measurement sensor | Component | A litho cell | System | publ2022 |  |  |  | Method
A method for cleaning | Method | A reticle stage | Module | publ2022
A membrane | Component | A lithographic system | System | publ2022 |  |  |  | Labelling of all the items in column A takes quite some time
A charge regulator | Component | A method of operating an EUV lithographic apparatus | Method | publ2022 |  |  |  | If I start with a new dataset (having partly overlap with this dataset, how I can make sure that)
A charged particle-optical device | Module | A method for improving a nuisance rate | Method | publ2022 |  |  |  | 1) I can (re)use the labelling as much as possible?
An apparatus | System | A system | System | publ2022 |  |  |  | 2) Add the new items at the bottom of column A (i.e. not to disrupt the linking between column A and B) <as I want to use VLOOKUP, see [NAME])
A lithographic apparatus | System | A non-transitory computer readable medium storing … | Component | publ2022
A system | System | A height measurement sensor | Component | publ2022
A metrology tool | System | An assessment system | Module | publ2022
A lithographic system | System | A metrology system | System | publ2022
A non-transitory computer readable medium storing … | Component | A method for determining a focus plane | Method | publ2022
An assessment system | Module | A method for cleaning | Method | publ2022
A pellicle | Component | A membrane | Component | publ2022
A method of operating an EUV lithographic apparatus | Method | A pellicle | Component | publ2022
A metrology system | System | A patterning device and pellicle assembly | System | publ2022
A patterning device and pellicle assembly | Module | A lithographic apparatus | System | publ2022
A litho cell | System | An optical component | Module |  | New2022
A method for determining a focus plane | Method | A broadband light source device | System |  | New2022
A lithographic apparatus | System | A metrology device | Method |  | New2022
 |  | A method for configuring an optical component | Module |  | New2022
 |  | A broadband radiation source device | Component |  | New2022
 |  | A source device | Module |  | New2022
 |  | A method for configuring a source arrangement | Method |  | New2022
 |  | A radiation source | Module |  | New2022
 |  | A method | Module |  | New2022
 |  | A charged-particle multi-beam column | Module |  | New2022
 |  | A charged-particle multi-beam column array | Method |  | New2022
 |  | An inspection method | Module |  | New2022
Spreadsheet: 848335d1699044510-sumifs-index-match-two-criteria-indirect-formula-help-budgets
Sheet: Summary

 | 2023
 | B | C | D
3 | Department | GL Code
4 | 604 | 535110
5 | 605 | 535110
6 | 611 | 535110
 | 604 | 535130
 | 605 | 535130
 | 611 | 535130
 | 604 | 535210
 | 605 | 535210
 | 611 | 535210
 | 604 | 535220
 | 605 | 535220
 | 611 | 535220
 | 604 | 536010
 | 605 | 536010
 | 611 | 536010
 | 604 | 536020
 | 605 | 536020
 | 611 | 536020
 | 604 | 536030
 | 605 | 536030
 | 611 | 536030
Spreadsheet: 877189d1723887453-map-filter-and-sumifs-of-two-different-ranges-sum-lookup2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Expected Result > Prefix>GO24 >
 |  |  | Lookup1 >Prefix >GO24 |  |  |  |  |  |  |  | Code | Name of Flower | Data | Diff. |  | Name of Flower | Data | Diff.
 |  |  | 1 | 4600569 |  |  |  |  |  |  | 11 | Sunflower |  |  | 36 | Jasmine | 947505 | 3653064
 |  |  | 2 | 947505 |  |  |  |  |  |  | 36 | Jasmine | 947505 |  | 44 | Marigold | 219559 | 727946
 |  |  | 3 | 219559 |  |  |  |  |  |  | 44 | Marigold | 219559 |  | 12 | Lily | 758004 | -538445
 |  |  | 4 | 758004 |  |  |  |  |  |  | 12 | Lily | 758004 |  | 51 | Hibiscus | 1134916 | -376912
 |  |  | 5 | 1134915.5 |  |  |  |  |  |  | 51 | Hibiscus |  |  | 11 | Sunflower | 4600569 | -3465653.5
Spreadsheet: 773350d1647805036-extracting-predecessor-as-a-list-textjoin-from-the-top
Sheet: Sheet1

Task ID | Task Name | Predecessor ID | Predecessor List (this is the example of what I need)
1 | Task 1
2 | Task 2
3 | Task 3
4 | Task 4
5 | Task 5
6 | Task 6
7 | Task 7
8 | Task 8
9 | Task 9
Spreadsheet: 474249d1470686483-count-unique-values-per-month-copy-of-sample-14
Sheet: DATA

Order # | Date | Type | Helper |  |  |  |  | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00
157438 | 2016-04-06 00:00:00 | ACC |  |  |  |  | Count Unique HNA
157438 | 2016-04-06 00:00:00 | ACC |  |  |  |  | Count Unique ACC
161851 | 2016-05-25 00:00:00 | ACC |  |  |  |  | Count Unique OoC
161851 | 2016-05-25 00:00:00 | ACC
162419 | 2016-06-02 00:00:00 | ACC
161544 | 2016-05-31 00:00:00 | ACC
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
162629 | 2016-06-08 00:00:00 | OoC
163271 | 2016-06-13 00:00:00 | ACC
163886 | 2016-06-22 00:00:00 | HNA MNIT
163886 | 2016-06-22 00:00:00 | HNA MNIT
Spreadsheet: 0f2fc6b7-f22b-40e3-ade1-b8c468ea0c46
Sheet: Sheet1

2015-2016 Class Schedule | 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 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
Chinese
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 212584d1360170392-group-by-a-description-and-sum-its-values-book1
Sheet: Sheet1

 | Code | Desc. | Qty. |  |  | Code | Desc. | Qty.
 | 201 | Eggs | 1 |  |  | 200 | Pineapples | 6
 | 200 | Pineapples | 6 |  | >>>> | 201 | Eggs | 3
 | 205 | Potatoes | 5 |  |  | 202 | Carrots | 12
 | 202 | Carrots | 3 |  |  | 205 | Potatoes | 5
 | 210 | Oranges | 8 |  |  | 210 | Oranges | 8
 | 202 | Carrots | 9
 | 201 | Eggs | 2
Spreadsheet: 29014d1223638341-lookup-multiple-same-value-and-return-multiple-corresponding-value-in-ascending-order-sample
Sheet: Sheet1

Rank | Occurrence |  | Rank | Occurrence
0 | 8 |  | 6 | 1
1 | 4 |  | 6 | 1
2 | 6 |  | 3 | 2
3 | 2 |  | 3 | 2
4 | 2 |  | 3 | 2
5 | 5 |  | 1 | 4
6 | 1 |  | 1 | 4
7 | 1 |  | 5 | 5
8 | 4 |  | 2 | 6
9 | 2 |  | 0 | 8
Spreadsheet: 122848d1317205915-choose-data-to-populate-main-worksheet-populate_worksheet
Sheet: Dados AV1

Código | Idade_1 | Sexo | Sexo_VAR | IMC_1 | Categoria
CT1 | 11 | 1 | 11.1 | 20.54 | N
CT2 | 11 | 2 | 11 | 26.09 | O |  |  |  | BP | N | EP | O
CT3 | 11 | 2 | 11 | 24.89 | EP |  |  | nº | 0 | 2 | 1 | 2 | 5
CT4 | 11 | 2 | 11 | 27.98 | O |  |  | % | 0 | 0.4 | 0.2 | 0.4 | 1
CT5 | 11 | 2 | 11 | 16.42 | N
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
0 | 0 | 0 | 0 | 0 | #N/A
Spreadsheet: 813430d1673750250-help-with-countif-and-today-function-blank-worksheet
Sheet: Control

 |  | 2021 | 2022 | 2023 | 2024 | 2025
2001-01-21 00:00:00 | New Year's Day
2018-01-21 00:00:00 | [NAME] Birthday
 | Inauguration Day
2015-02-21 00:00:00 | Presidents' Day
1931-05-21 00:00:00 | Memorial Day
2019-06-21 00:00:00 | Juneteenth National Independence Day
2004-07-21 00:00:00 | Independence Day
2006-09-21 00:00:00 | Labor Day
2011-10-21 00:00:00 | Columbus Day
2011-11-21 00:00:00 | Veterans Day
2025-11-21 00:00:00 | Thanksgiving Day
2025-12-21 00:00:00 | Christmas Day
2001-01-22 00:00:00 | New Year's Day
2017-01-22 00:00:00 | [NAME] Birthday
 | Inauguration Day
2021-02-22 00:00:00 | Presidents' Day
1930-05-22 00:00:00 | Memorial Day
2019-06-22 00:00:00 | Juneteenth National Independence Day
2004-07-22 00:00:00 | Independence Day
2005-09-22 00:00:00 | Labor Day
2010-10-22 00:00:00 | Columbus Day
2011-11-22 00:00:00 | Veterans Day
2024-11-22 00:00:00 | Thanksgiving Day
2025-12-22 00:00:00 | Christmas Day
2001-01-23 00:00:00 | New Year's Day
2016-01-23 00:00:00 | [NAME] Birthday
 | Inauguration Day
2020-02-23 00:00:00 | Presidents' Day
2029-05-23 00:00:00 | Memorial Day
2019-06-23 00:00:00 | Juneteenth National Independence Day
2004-07-23 00:00:00 | Independence Day
2004-09-23 00:00:00 | Labor Day
2009-10-23 00:00:00 | Columbus Day
2011-11-23 00:00:00 | Veterans Day
2023-11-23 00:00:00 | Thanksgiving Day
2025-12-23 00:00:00 | Christmas Day
2001-01-24 00:00:00 | New Year's Day
2015-01-24 00:00:00 | [NAME] Birthday
2020-01-25 00:00:00 | Inauguration Day
2019-02-24 00:00:00 | Presidents' Day
2027-05-24 00:00:00 | Memorial Day
2019-06-24 00:00:00 | Juneteenth National Independence Day
2004-07-24 00:00:00 | Independence Day
2002-09-24 00:00:00 | Labor Day
2014-10-24 00:00:00 | Columbus Day
2011-11-24 00:00:00 | Veterans Day
2028-11-24 00:00:00 | Thanksgiving Day
2025-12-24 00:00:00 | Christmas Day
2001-01-25 00:00:00 | New Year's Day
2020-01-25 00:00:00 | [NAME] Birthday
 | Inauguration Day
2017-02-25 00:00:00 | Presidents' Day
2026-05-25 00:00:00 | Memorial Day
2019-06-25 00:00:00 | Juneteenth National Independence Day
2004-07-25 00:00:00 | Independence Day
2001-09-25 00:00:00 | Labor Day
2013-10-25 00:00:00 | Columbus Day
2011-11-25 00:00:00 | Veterans Day
2027-11-25 00:00:00 | Thanksgiving Day
2025-12-25 00:00:00 | Christmas Day
Spreadsheet: 474094d1470642676-vlookup-and-sum-based-on-a-criteria-test2
Sheet: oP&L Detailed

Merging data |  |  | Entity Reporting |  | J |  |  | Report Month: | 2015-12-01 00:00:00
C2&D2 |  |  |  |  |  |  |  | Currency: | AUD
 |  |  |  |  |  |  |  | Average FX rate YTD: | 1
 |  |  | Account |  | Actual  Month | Last Year |  | Year to Date Actual | Year to DateLast Year
 |  |  | Number | Name
 |  |  | 4-0000_x000D_ | Income
 |  |  | 4-1010 | alpha
 |  |  | 4-1011 | black label
 |  |  | 4-1012 | gamma
 |  |  | 4-1013 | mercury
 |  |  | 4-1014 | beta
 |  |  | 4-1015 | fate
 |  |  | 4-1016 | gate
Spreadsheet: 78a19a32-0bb7-4b7c-a8c5-3ab26a902995
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | REQUEST FOR SUPPLEMENTAL REVENUE | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | HEALTH
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | REVENUE
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT
 |  | 2480 |  | 500001 |  | 478095 |  | G50501609 |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 10000
[NAME]:
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-14 00:00:00