tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 105912d1303193127-how-to-do-sumif-if-the-range-of-cells-are-formulated-for-ageing-days-excel-help
Sheet: Summary

 | Summary ageing by Invoice Date
 |  | <30 days | >30 days | >60 days | >90 days | > 120 days | Total $
 | A | 0 | 0 | 0 | 0 | 50000 | 50000
 | B | 0 | 0 | 0 | 0 | 50000 | 50000
 | C | 0 | 0 | 0 | 0 | 50000 | 50000
 |  | 0 | 0 | 0 | 0 | 150000 | 150000
 |  |  |  |  |  | check | -1515000
Spreadsheet: c1cd69d0-8352-49ac-85a2-260075d35247
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MMAP | Test | MMAP | Methylmalonic Acid (MMA), Quantitative, Plasma | Methylmalonic Acid, QN, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: NaHp |  |  | 1.5 | mL | Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA [NAME]: 1.5 mL | 0.8 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =0.40 nmol/mL | Monday through Friday; [NAME] until 12:00 p.m. | 3 days (not reported on Saturday or Sunday) | 5 days | 1 | 83921 |  |  |  |  | Rochester
MMAP | [NAME] | PLASMA | Plasma |  |  |  | Refrigerated | 48 days
MMAP | Result | 31927 | Methylmalonic Acid, QN, P | Methylmalonic Acid, QN, P | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 13964-2
Spreadsheet: 79a65fd1-0e41-4dee-885f-947c39d7c2c3
Sheet: CMC Rifle 28

 | RFQ 539-12 Mobile [NAME]
 | Due:  Monday, December 10, 2012 at 2:00 pm
Company Name:
Contact Person Name:
Address 1
Address 2:
Phone
Earliest guaranteed delivery date
 | Product Quoted:  [NAME]
 | Bid:  Equivalent to or greater than
 | Model/Link:  IC8524TA3
 | Trailer | Qty | Price
 |  |  |  |  |  | Notes:
1 | Mobile [NAME], Internal Floor Plan of 8'Wide x 8'High x 28'Long | 1
 | 5200# [NAME]
 | [NAME] with 2-5/16" Coupler and Electric Tongue Jack
 | 5000# [NAME]
 | Electric Brakes
 | 15" Radial Tires with Split Spoke Aluminum Wheels
 | [NAME]
 | Polished Cast Corners w/Stainless Steel Insert
 | .030 Aluminum Exterior/Interior
 | Black Aluminum Wheel Box Wrap
 | Clear Lens LED Exterior Lighting
 | Stainless Steel Front Corners
 | White Vinyl Ceiling
 | 3/8" Plywood Sidewalls
 | 3/4" Plywood Flooring
 | Extra Wide HD Rear Ramp Door and Flap
 | Spring Assist & Keyed Paddle Latches
 | Black Coin Floor and Ramp Door
 | Rubber Ramps Door Hinge Cover
 | 36" Side Door w/Flush Lock
 | 4 x Dome Lights
 | 2 Three Way Wall Switches
 | 28" [NAME]
 | Spare Tire
 | 45 Amp Converter w/Battery Charger
 | Electrical Bracket
 | Angle Mount Florescent Lights
 | Variable Items |  |  |  |  | Notes:
 | 12V Electric Tongue Jack | 1
 | 2 x 500W Recessed Quartz Lights Outside | 1
 | 42" Aluminum Slideout Step | 1
 | 50amp Panel Electrical Package w/110V Recepticals with Lifeline, [NAME] | 1
 | >12" Extra Height to give interior height of 1' Height Increments | 1
 | Recessed Floor E-Track @ 4 Rows of 22' long | 1
 | Recessed Wall E-Track @ 2 Rows of 22' long | 1
 | 15K BTU Air Conditioning Unit w/Heatstrip | 1
 | Analog A/C Thermostat | 1
 | Media Options
 | 24" x 12" Plate Projector Mount | 1
 | 1 x VGA Instructor Hook Up Connection | 1
 | CAT 5 Connection Bundle (Network Extra) | 1
 | Printer/Copier/Scanner Based on Dell Current Small Business Unit | 1
 | 24 Port /gigabit [NAME] on Dell Current Small Business Unit | 1
 | [NAME] 17" Laptop Win 7 Professional, Microsoft Office [NAME] and [NAME] | 1
 | Furniture
43 | Instructors [NAME]/Slide Out Tray for Keyboard and Drawer | 1
44 | Student Desk, 2 station desk 24" x 60" and Office type chairs | 1
 | Graphics
45 | Custom designed printed, mounted full wrap graphics | 1
 | Delivery
46 | Delivery | 1
47 | Other Costs
48 | Total Cost | TOTAL:
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 216409 | 214564 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 212420 | 214971 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 221572 | 222370 |  | 4477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 219273 | 222751 |  | 639 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 185522 | 181757 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | -2009
 | 2001-06-05 00:00:00
Spreadsheet: 807925d1670171173-average-with-frequency-and-year-formula-not-working-book1
Sheet: Sheet1

 |  | freq 2020: |  |  |  |  | 2020-03-25 00:00:00
 |  | freq 2021: |  |  |  |  | 2020-04-21 00:00:00
 |  | both |  |  |  |  | 2020-05-04 00:00:00
 |  | avg |  |  |  |  | 2020-05-14 00:00:00
 |  |  |  |  |  |  | 2020-06-15 00:00:00
 |  |  |  |  |  |  | 2020-06-24 00:00:00
 |  |  |  |  |  |  | 2020-07-14 00:00:00
 |  |  |  |  |  |  | 2020-07-24 00:00:00
 |  |  |  |  |  |  | 2020-09-04 00:00:00
 |  |  |  |  |  |  | 2020-09-24 00:00:00
 |  |  |  |  |  |  | 2020-10-28 00:00:00
 |  |  |  |  |  |  | 2020-12-14 00:00:00
 |  |  |  |  |  |  | 2020-12-21 00:00:00
 |  |  |  |  |  |  | 2021-01-05 00:00:00
 |  |  |  |  |  |  | 2021-01-29 00:00:00
 |  |  |  |  |  |  | 2021-02-25 00:00:00
 |  |  |  |  |  |  | 2021-03-04 00:00:00
 |  |  |  |  |  |  | 2021-05-12 00:00:00
 |  |  |  |  |  |  | 2021-05-19 00:00:00
 |  |  |  |  |  |  | 2021-06-18 00:00:00
 |  |  |  |  |  |  | 2021-07-08 00:00:00
 |  |  |  |  |  |  | 2021-07-19 00:00:00
 |  |  |  |  |  |  | 2021-08-03 00:00:00
 |  |  |  |  |  |  | 2021-08-19 00:00:00
 |  |  |  |  |  |  | 2021-09-02 00:00:00
 |  |  |  |  |  |  | 2021-12-03 00:00:00
 |  |  |  |  |  |  | 2022-01-24 00:00:00
 |  |  |  |  |  |  | 2022-02-11 00:00:00
Spreadsheet: benjamin_rogers__1173__Wilton_New - GE 7EA
Sheet: PPA Assumptions &Summary

PPA Assumptions and Pricing Summary
 |  | 1
Months of Operation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0
Months of Year Under PPA
Months of Year Merchant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
% of Capacity Under PPA
Capacity Payment Terms
Energy ($/MWH)
Capacity ($/kw-mo) - Fixed PPA
Capacity ($/kw-mo) - Merchant
Capacity Escalation Index |  | 1
Ancillary Services | 0.12 | 0
Fees |  | 0
r |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Ancillary Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Power Pricing Summary
All in Power Price $/MWH
Fuel $/MWH
Variable O&M $/MWH
Marginal cost of Generation $/MWh
Operations & Maintenance Costs
Annual Costs by Type: | Term Ave
Total Variable Operating Cost
Total Start Up Cost
Total Fixed (incl. G&A)
Property Taxes
Total Operating Taxes
Total Debt Service
Total Annual Expenses
Breakout of Total Fixed: | Term Ave
Fixed Operating Cost
Fixed G&A
$/kWmo Costs by Type: | Term Ave
Variable Operating Cost $/kWmo
Start Up Cost $/ KW mo
Fixed Operating Cost (incl G&A) $/kWmo
Total Operating Cost $/kWmo
Total O&M $/kWmo (excluding Debt Service)
Property Taxes
Operating Taxes $/Kwmo
Debt Service $/kWmo
Total Operating Cost $/kWmo
Fixed Operating Cost
Fixed G&A
$/MWh Costs by Type: | Term Ave
Variable O&M $/MWh
Start Up Cost $/MWh
Fixed O&M $/MWh
Total O&M $/MWh
Consultant's Capacity Curve | Term Ave
Kaiser Base
Kaiser Low
Kaiser Mid (Average of Base and Low)
Kaiser Percent (Percentage of Low and Mid)
Kaiser Comed Base $/kw-year (in 1998 real $) | REAL | 66 | 65 | 65 | 65 | 64 | 64 | 62 | 61 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | 53 | 52 | 51 | 50 | 48 | 47 | 36.99
Kaiser Comed Low $/kw-year (in 1998 real $) |  | 54 | 54 | 54 | 53 | 53 | 52 | 51 | 50 | 49 | 48 | 47 | 46 | 45 | 43 | 42 | 41 | 40 | 39 | 38 | 37 | 36
Consultant's Energy Curve
Kaiser Peak
Kaiser Off peak
ECT Peak Curve |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marginal Cost Curve
Kaiser Peak as of 1998 ( $ / MWh ) | REAL | 39.75 | 42.43 | 45.29 | 48.34 | 51.59 | 55.07 | 55.52 | 55.97 | 56.43 | 56.89 | 57.36 | 55.15 | 53.04 | 51 | 49.04 | 47.16 | 47.8 | 48.44 | 49.1 | 49.1
Kaiser Off Peak as of 1998 ( $ / MWh ) | REAL | 39.83 | 42.33 | 44.98 | 47.8 | 50.8 | 53.98 | 54.34 | 54.7 | 55.07 | 55.44 | 55.81 | 52.96 | 50.25 | 47.68 | 45.25 | 42.94 | 43.28 | 43.62 | 43.96 | 43.96
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 39085 | 35000
2 | 38663 | 35000
3 | 38140 | 35000
4 | 37433 | 35000
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
2002-02-28 00:00:00 |  |  | 100916
2002-03-04 00:00:00
CBS Volume
 |  |  | 93375
Spreadsheet: 179617d1347316327-value-error-dow
Sheet: 1

 |  |  |  |  |  |  |  |  |  | LOAD
 | 1 |  |  |  | 122882 |  |  | Full | %
 |  |  |  |  | INF |  | Cabin A | 12
 |  |  | 75 | 40 | 10 |  | Cabin B | 63
 |  |  | 202 | 8 | 2 |  | Cabin C | 162
 |  |  |  |  |  |  | Cabin D | 140
 | 2 | Total |  |  |  |  | Total
 |  |  | 125 | 20
 |  |  | 0 | 85
 | 3 | Total
 | 4
 | 5 |  |  |  | 0
 | 6
 |  |  |  | Total
Spreadsheet: 188400d1350874495-creating-a-pivot-table-out-of-data-in-a-cross-tab-tableau-ef_question_870075_21oct12_01
Sheet: Sheet1

ID | Country | Region | Q1 | Q2 | Q3 | Q4
1 | US | Amer | 4 | 1 | 5 | 1 | <<<<<<<< | This is from a flat file.
2 | UK | Emea | 4 | 4 | 4 | 2 |  | Each ID line is a respondent to a questionnaire that contains several questions.
3 | DE | Emea | 4 | 3 | 3 | 2 |  | Each question (Q1, Q2…) can be given one of 5 rating responses - 1,2,3,4,5.
4 | UK | Emea | 2 | 4 | 1 | 2 |  | This table's layout CANNOT be changed.
5 | DE | Emea | 2 | 3 | 3 | 3 |  | All questions are answered by all respondents.
6 | AU | Apac | 3 | 2 | 2 | 2
7 | US | Amer | 4 | 3 | 2 | 5
8 | AT | Emea | 2 | 4 | 5 | 1
9 | UK | Emea | 3 | 4 | 1 | 5
10 | US | Amer | 3 | 3 | 4 | 3
…
…
…
Country Dropdown
Region Dropdown
 |  |  |  |  |  |  | <<<<<<<< | Need a PIVOT TABLE that looks like this - is it possible?
Rating | 1 | 2 | 3 | 4 | 5 | Total |  | Need to aggregate COUNT of each RATING for each QUESTION.
Q1 | 7 | 8 | 8 | 6 | 9 | 38 |  | It is a given that TOTAL COUNT of all responses to QUESTIONS will be equal.
Q2 | 9 | 7 | 8 | 7 | 7 | 38 |  | The numbers are just given for effect; they do not correlate with the table above.
Q3 | 6 | 8 | 9 | 8 | 7 | 38
Q4 | 7 | 8 | 7 | 8 | 8 | 38
Total | 30 | 33 | 35 | 33 | 36
Country Dropdown
Region Dropdown
 |  |  |  |  |  |  | <<<<<<<< | Even this format of a PIVOT TABLE is acceptable.
Rating | Q1 | Q2 | Q3 | Q4 | Total
1 | 7 | 9 | 6 | 7 | 30
2 | 8 | 7 | 8 | 8 | 33
3 | 8 | 8 | 9 | 7 | 35
4 | 6 | 7 | 8 | 8 | 33
5 | 9 | 7 | 7 | 8 | 36
Total | 38 | 38 | 38 | 38
Spreadsheet: 860674d1708684071-three-way-match-with-in-direct-function-indirect-index-match
Sheet: UK SW (Bristol & Cardiff)

iCRC Secured & Pipeline Workload
Centre
Working For
[NAME]
Current Date
Forecast Month |  |  |  |  | 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
iCRC FTE |  |  |  |  | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33
iCRC FTE Progression through year |  |  |  |  | 31.111109 | 31.111109 | 31.111109 | 31.7777756 | 33.3333333 | 33.6666633 | 33.1111088 | 33.1111088 | 33.333331 | 33.333331 | 33.333331 | 33.333331
iCRC FTE Actual |  |  |  |  | 7.38335 | 13.7313335 | 13.13315 | 6.381165 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pipeline Secured Potential FTE (Taken from Sharepoint Resource Hub) |  |  |  |  | 0 | 1.1 | 8.3 | 7.3 | 6.6 | 6.5
iCRC Net Revenue Budget |  |  |  |  | 88197.9980301993 | 83333.9160378187 | 73859.3157630777 | 88853.7983378536 | 89389.3505610531 | 81668.3303763985 | 98339.1330539755 | 83309.1330333303 | 88335.9858631783 | 93093.9639860583 | 77059.0513985385 | 75179.5633375986
Forecast WIP NR in month |  |  |  |  | 39533 | 53883.93 | 56568.6 | 35933.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pipeline Secured Potential NR in month |  |  |  |  | 0 | 3300 | 33600 | 29200 | 26300 | 26000 | 0 | 0 | 0 | 0 | 0 | 0
WO | Project Ndme | Office | UK PM | iCRC [NAME]
60065062-202 | Designer GrouR dldgdte [NAME] 2 - CR2 | RORTH ScotldRd | Douglds Wdlldce | TdRvi dgdrwdl | 0 | 416 | 0 | 0 | 0 | 0
60120634-C40 | RMU EIH Stdge 5 | RORTH ScotldRd | dRdrew JohRstoR | MdhddevdR | 0 | 222 | 0 | 0 | 0 | 0
60116221-M32 | [NAME] Centre MER iCRC | RORTH ScotldRd | dRdrew JohRstoR | TdRvi dgdrwdl | 21090 | 18624 | 0 | 0 | 0 | 0
60066623-410 | iCRC MER drgyll Stdge 4 | RORTH MdRchester | [NAME] | MdhddevdR | 686 | 2321 | 0 | 0 | 0 | 0
60106322-202 | SE Victorid HR - Fit Out | RORTH Leeds | [NAME] | TdRvi dgdrwdl | 1594 | 1123 | 3318 | 3616 | 0 | 0
60114066-211 | TfGM Bus Electrificdtion - Building Services iCRC | RORTH Leeds | [NAME] | TdRvi dgdrwdl | 2983 | 6842 | 8064 | 0 | 0 | 0
60062464-231 | Sloy Substdtion | RORTH MdRchester | [NAME] | MdhddevdR | 0 | 188 | 0 | 0 | 0 | 0
60113506-403 | URRer Brook Street - RIBd 4i iCRC | RORTH Leeds | [NAME] | drviRd | 42 | 20760.93 | 45186.6 | 22308.66 | 0 | 0
60066666-R04 | Monkldnds HosRitdl | RORTH MdRchester | [NAME] willidms | MdhddevdR R | 3138 | 4388 | 0 | 0 | 0 | 0
Spreadsheet: 54404d1254391333-compare-text-between-cells-book1
Sheet: Sheet1

 |  | Mediterranean Sea.
 |  | Mediterranean Ses. | 0.9444444444444444
 |  | Atlantic Ocean. | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 685911d1594268925-if-condition-is-true-then-lock-copy-and-color-the-cells-book
Sheet: Sheet1

Date | Filling Density |  |  |  |  |  |  | Bulk And Discharge  Time |  |  | Temp Cycle |  |  |  | Number of Greens | Result
 | Weight of  Water | Weight of  Extinguishant | Density | Traffic  Light |  | Filling  Tolerance | Traffic  Light | Range ([NAME]) | Time ( Secs) | Traffic  Light | Cycle 1 (%) | Traffic  Light | Cycle 2 (%) | Traffic  Light
2020-01-28 00:00:00 | 2.5 | 2 |  |  | 1 | 0.02 |  | 2 | 13 |  | 85 |  | 85
2020-02-28 00:00:00 | 2.5 | 2 |  |  | 1 |  |  | 3 | 14
2020-04-26 00:00:00 |  |  |  |  | 1
 |  |  |  |  | 0
 |  |  |  |  | 1
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 704114d1605366933-redistribute-rebalance-percentages-rebalance-v2
Sheet: Sheet1

Token |  | Percentage | Check | New Balanced | Check | D=F?
Asset1 |  | 0.7554830037098831 |  | 0.2
Asset2 |  | 0.1350910343217953
Asset3 |  | 0.01314133138239288
Asset4 |  | 0.01306883481185067
Asset5 |  | 0.01043900546088098
Asset6 |  | 0.009879816653137608
Asset7 |  | 0.008637746277701995
Asset8 |  | 0.007995864021321188
Asset9 |  | 0.007719320307237786
Asset10 |  | 0.005513255791807297
Asset11 |  | 0.005012536477499633
Asset12 |  | 0.004463589555460924
Asset13 |  | 0.004174951195840994
Asset14 |  | 0.004038431065181004
Asset15 |  | 0.003456376425504
Asset16 |  | 0.003456376425504
Asset17 |  | 0.00294656855861491
Asset18 |  | 0.00286007418247807
Asset19 |  | 0.002621883375907665
Spreadsheet: 770708d1646231304-calculate-cumulative-value-from-3-tiered-lookup-2022-ans2
Sheet: Sheet1

 | IF LATE FROM | TO | CHARGE AMOUNT PER DAY | FORMULA
 | 1 | 8 | 60 |  |  | E is helper column
 | 9 | 23 | 120
 | 24 | 54 | 200
 | 55 | 90 | 300
 | TOTAL LATE DAYS |  | Required amount | Without helper column
 | 28
 | B16 changed for verification.
Spreadsheet: 5ad6a2a8-6129-4adb-b0ea-d4d68ae82aa6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Potomac River for 2010
Indicator | 2010
Chlorophyll a | 25.797
Aquatic Grasses | 46.07
[NAME] | 76.17
[NAME] | 32
Water Clarity | 14.626
Phytoplankton Index | 8.6
Water Quality Index | 38.86433333
Biotic Index | 28.89
Bay Health Index | 33.87716667
Spreadsheet: 162678d1340030976-how-to-convert-number-with-text-into-new-number-doesnt-work
Sheet: 6D (3)

BET AMT | W/L
#N/A | -34.75
 | 0
 | 0
 | 0
 | 0
-5 | -5
 | 0
 | 0
5 | 4.75
 | 0
5 | 4.75
 | 0
 | 0
 | 0
-5 | -5
 | 0
-5 | -5
10 | 9.5
 | 0
5 | 4.75
 | 0
-5 | -5
 | 0
-5 | -5
 | 0
5t | 0
5 | 4.75
 | 0
-5 | -5
 | 0
-10 | -10
 | 0
20t | 0
 | 0
-5 | -5
5p | 5
-5 | -5
10 | 9.5
 | 0
-10 | -10
5p | 5
 | 0
-5 | -5
 | 0
10 | 9.5
 | 0
-10 | -10
-5 | -5
-10 | -10
20 | 19
-10 | -10
5p | 5
 | 0
-10 | -10
5 | 4.75
-10 | -10
20 | 19
 | 0
10t | 0
-10 | -10
-10 | -10
20t | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 874807d1721319720-add-column-formula-to-table-to-count-distinct-records-based-on-multiple-criteria-kwoltman-countdistinctexcelexample-aligw
Sheet: Sheet1

Requirements
Source must = P
Error = 1
then count distinct ID within the same YearMonth
Doesn't matter if the first or the last record is the one that is "counted", but only 1 can be counted
The data is "generally" input in somewhat of a chronological order, but it's not always.  YearMonth dates are generally in order
The data is input into a table, has 1000's of rows, with new rows added every day.  When I input the "Desired Distinct Count" formula, I will need the table to automatically insert the new formula into the new ID row (Excel usually does this automatically)
A | B | E | S | (you can ignore the A-B-E-S values in this row, this is for my cross-reference back to my original spreadsheet)
ID | Source | Error | YearMonth | Desired Distinct Count | Comments
22 | A | 0 | 202404 |  | source isn't P
19 | B | 1 | 202404 |  | source isn't P
33 | C | 0 | 202404 |  | source isn't P
41 | P | 1 | 202404 |  | count of ID 41, where Source = P, Error = 1, for the YearMonth=202404
57 | A | 0 | 202405 |  | source isn't P
66 | P | 1 | 202405 |  | count of ID 66, where Source = P, Error = 1, for the YearMonth=202405
66 | P | 1 | 202405 |  | doesn't count since ID 66 above was already accounted for
17 | B | 0 | 202406 |  | source isn't P
41 | P | 1 | 202407 |  | even though this is the same ID (41) as above, it still counts as 1 since the YearMonth is different than the one above
88 | C | 0 | 202407 |  | source isn't P
19 | P | 0 | 202407 |  | doesn't count since Error=0
110 | A | 1 | 202407 |  | source isn't P
36 | P | 0 | 202407 |  | doesn't count since Error=0
120 | P | 1 | 202407 |  | count of ID 120, where Source = P, Error = 1, for the YearMonth=202407
73 | B | 1 | 202407 |  | source isn't P
120 | P | 1 | 202407 |  | doesn't count since ID 120 above was already accounted for
79 | P | 0 | 202407 |  | doesn't count since Error=0
52 | A | 1 | 202407 |  | source isn't P
66 | P | 1 | 202407 |  | even though this is the same ID (66) as above, it still counts as 1 since the YearMonth is different than the one above
58 | C | 0 | 202407 |  | source isn't P
33 | P | 1 | 202404 |  | count of ID 33, where Source = P, Error = 1, for the YearMonth=202404 (notice the ID=33 on Row 13 which is Source = C, but regardless, 33 here counts as 1 because Source=P, Error=1, and it's the only record for that month
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-075,078

 |  |  |  |  |  |  |  | 7-075   7-078
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 278063d1384531954-combining-data-from-multiple-excel-files-table-2
Sheet: Sheet1

First Name | Last Name | Address | City | State | Zip
Jon | Shafton | 75 Main Street | Dallas | TX | 56789
Jared | Jones | 87 North Street | Houston | TX | 56890
[NAME] | Ellis | 1 Iron Way | [NAME] | TX | 45678
Spreadsheet: 37334d1235322161-average-if-statement-based-on-matching-condition-and-date-ranges-copy-of-testtest
Sheet: Feedback Summary

Date | Course | Trainer | Dels | Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5 | Cat 6 | Comments | Total
2009-01-01 00:00:00 | Excel Intermediate | Test | 2 | 8 | 8 | 8 | 8 | 8 | 8 |  | 1
2009-02-01 00:00:00 | Adobe Photoshop CS3 Introduction | Test2 | 3 | 12 | 6 | 7 | 12 | 3 |  |  | 0.6666666666666666
11//01/09 | Management Skills (2 days) | [NAME] | 3 | 4 | 12 | 12 | 8 | 8 | 12 | Some topics not covered | 0.7777777777777778
21/01/2009 | Assertiveness at Work | [NAME] | 1 | 4 | 4 | 4 | 4 | 4 | 3 |  | 0.9583333333333334
Spreadsheet: 118036d1313390687-help-on-multiple-sheets-setup
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | TICKET SALES STATEMENT
 |  |  | Agency No : |  | k607 | Telephone No
 |  |  | Contact Name : |  | P.Clark
 |  |  | Agency Name : |  | Winchester
 |  |  | Post Code : |  |  | E MAIL ADDRESS
This statement covers sales made from:        /       /  2004   to:       /       /  2004 |  |  |  |  | TO |  |  | Day
Ticket No's | Tourist Trail Ticket | Domestic Coach Travel Add on Tours | Holiday Extras- Hotel Only | Holiday  [NAME] - packages | Octopus UK/Europe Hotel Only | Holiday / Exchange Vouchers | Eurolines Booking Fee | Eurolines Coach Travel | Short Breaks Insurance | Domestic Travel Insurance
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
(listed in sequence) | ü | £         p | £         p | £         p | £         p | £         p | £         p | £         p | No. | No.
B/fwd from sheet:
ZTBP6653 | 8.7
7451 | 23.2
7964 | 48.4
8309 | 5.5
8673 | 13.4
CSO39239 | 11.75
ZTBR0128 | 32.9
1115 | 23.2
1229 | 20.4
C/fwd to sheet:
Spreadsheet: fd0e61d3-b8c0-4516-bcae-53aab0d37c93
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42267260 | 2014-07-12 12:32:09 | AXIS | 0 | 2 | 6 | 1482326 | player1482326 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42267475 | 2014-07-12 13:05:48 | ALLIES | 0 | 3 | 6 | 1482326 | player1482326 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]