tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 727938d1618222628-creating-a-new-average-per-timeinterval-per-change-in-date-excelforum-average-per-date-per-time
Sheet: Ark1

Date | Time | Spread |  | (Manually calculated) | Average
2020-06-22 00:00:00 | 09:05:00 | 0.02
2020-06-22 00:00:00 | 09:10:00 | 0.04 |  | 22.06.2020 09:00-09:15
2020-06-22 00:00:00 | 09:20:00 | 0.02 |  | 22.06.2020 09:15-09:30
2020-06-22 00:00:00 | 09:25:00 | 0.04 |  | 23.06.2020 09:00-09:15
2020-06-23 00:00:00 | 09:05:00 | 0.03 |  | 23.06.2020 09:15-09:30
2020-06-23 00:00:00 | 09:10:00 | 0.06
2020-06-23 00:00:00 | 09:20:00 | 0.03
2020-06-23 00:00:00 | 09:25:00 | 0.06
Spreadsheet: 879413d1726903996-match-date-to-nearest-earlier-or-later-to-dates-in-row-albert_frank
Sheet: Albert_Frank

Fund Name | Fund ID | Currency | Price | Units held | Value | All holdings % | Wrapper % | Weighted ave cost (£) | Gain (£) | Yield % | Total fee % | Portfolio | Category | Sub-category | Action | blank | 13/09/22 | 14/09/22 | 16/09/22 | 17/09/22 | 25/09/22 | 27/09/22 | 29/09/22 | 01/10/22 | 04/10/22 | 14/01/23 | 17/01/23 | 18/01/23 | 19/01/23 | 20/01/23 | 23/01/23 | 24/01/23 | 25/01/23 | 26/01/23 | 27/01/23 | 28/01/23 | 30/01/23 | 31/01/23 | 02/02/23 | 03/02/23 | 04/02/23 | 06/02/23 | 07/02/23 | 20/05/23 | 23/05/23 | 24/05/23 | 25/05/23 | 26/05/23 | 27/05/23 | 30/05/23 | 31/05/23 | 01/06/23 | 02/06/23 | 06/06/23 | 07/06/23 | 08/06/23 | 12/06/23 | 01/09/23 | 04/09/23 | 05/09/23 | 06/09/23 | 07/09/23 | 08/09/23 | 11/09/23 | 12/09/23 | 13/09/23 | 14/09/23 | 15/09/23 | 18/09/23 | 19/09/23 | 20/09/23 | 21/09/23 | 22/09/23 | 25/09/23 | 26/09/23 | 27/09/23 | 28/09/23 | 29/09/23 | 02/10/23 | 03/10/23 | 04/10/23 | 05/10/23 | 06/10/23 | 09/10/23 | 10/10/23 | 11/10/23 | 13/10/23 | 16/10/23 | 17/10/23 | 18/10/23 | 19/10/23 | 23/10/23 | blank3
123 fund |  |  |  | 10412.751 | 86633.04704490001 |  |  |  |  |  |  |  | Global Equity |  |  |  | 39397.7032848 | 39761.46426 | 39155.4172338 | 39181.9691298 | 38754.4836042 | 38230.0836582 | 37922.745462 | 36923.730375 | 36632.3233164 | 44342.3301174 | 44304.49366560001 | 44082.785334 | 43848.4648518 | 43341.3236382 | 43482.04868699999 | 44105.35444560001 | 44546.7797166 | 44537.486553 | 44489.6931402 | 44908.5492996 | 44709.4100796 | 44447.87390400001 | 45102.3781404 | 45458.8373442 | 45642.0454266 | 45768.1669326 | 45939.4266618 | 45884.995275 | 45758.87376900001 | 45912.8747658 | 45342.0090018 | 45106.3609248 | 45059.8951068 | 45399.75937560001 | 45124.28345459999 | 44675.5564122 | 45031.3518186 | 45558.40695420001 | 45783.4342728 | 45620.1401124 | 45454.1907624 | 46782.4493598 | 46895.29491780001 | 46928.4847878 | 46779.1303728 | 46948.3987098 | 46525.559766 | 46782.4493598 | 47182.719192 | 46990.8817434 | 47270.3404488 | 47788.7662182 | 47418.367269 | 47582.9890242 | 47630.1186396 | 47455.5399234 | 47383.8498042 | 47288.926776 | 47399.7809418 | 47055.9338886 | 46792.4063208 | 46933.795167 | 46887.9931464 | 46916.5364346 | 46171.7557518 | 46292.5668786 | 46044.9704484 | 46670.9313966 | 46869.4068192 | 47168.77944660001 | 47444.2553676 | 47503.9971336 | 47702.4725562 | 47651.36015640001 | 47066.554647 | 46587.95672160001
TOTAL
Today |  |  |  | 2024-09-20 00:00:00 |  | Value on past date
Value 12 months ago |  |  |  | 2023-09-20 00:00:00
Value 24 months ago |  |  |  | 2022-09-20 00:00:00 |  | 39181.9691298
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: Brigade Perstat

[NAME]
PERSTAT REPORT AS OF: |  |  |  | The personnel status below is effective as of this date.
S1
 | RANK | LAST NAME | FIRST NAME | DUTY LOCATION | ARRIVAL | [NAME] | 30 / 60 /90 | STATUS | REMARKS
1
 |  | TDY
 |  | Leave
 |  | Emergency Leave
 |  | Medical Leave
 |  | Quarters/Sick Leave
 | Projected Losses
 |  | Within next 30 days |  | * Will be annotated in the 30 / 60 / 90 column ONLY.
 |  | Within 31 / 60 days
 |  | Within 61 / 90 days
Spreadsheet: 726379d1617202413-i-need-a-timesheet-formula-please-time-to-6mins-etaf
Sheet: Sheet1

13:47:00 | 17:25:00
13:47:00 | 17:26:00 |  |  |  | 1:47 PM & 5:25
13:47:00 | 17:27:00
13:47:00 | 17:28:00
13:47:00 | 17:29:00
13:47:00 | 17:30:00
13:47:00 | 17:31:00
13:47:00 | 17:32:00
13:47:00 | 17:33:00
13:47:00 | 17:34:00
13:47:00 | 17:35:00
13:47:00 | 17:36:00
13:47:00 | 17:37:00
13:47:00 | 17:38:00
13:47:00 | 17:39:00
13:47:00 | 17:40:00
13:47:00 | 17:41:00
13:47:00 | 17:42:00
13:47:00 | 17:43:00
13:47:00 | 17:44:00
13:47:00 | 17:45:00
13:47:00 | 17:46:00
Spreadsheet: 033bfb72-b2d4-467e-84ae-c9a4591bb648
Sheet: Sheet1

New York State Teacher Certification Examinations | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Annual Institution Report - Preliminary | Annual Institution Report - Preliminary | Annual Institution Report - Preliminary | Annual Institution Report - Preliminary | Annual Institution Report - Preliminary
Program Year: 2007-2008
Process date: | 12-01-08 09:56:07
Institution: | 750 - SUC Geneseo
Number of Program Completers: | 308
Test Field/Category | Institution |  |  | Statewide
 | Number Tested | Number Passed | Pass Rate | Pass Rate
Professional Knowledge/Pedagogy
090/091 ATS-W | 297 | 296 | 100%
Aggregate | 297 | 296 | 100%
Academic Content Areas
006 Biology CST | 4 | -- | --
007 Chemistry CST | 5 | -- | --
008 Earth Science CST | 4 | -- | --
003 English Language Arts CST | 17 | 17 | 100%
004 Math CST | 21 | 21 | 100%
002 Multi-Subject CST | 157 | 156 | 99%
009 Physics CST | 2 | -- | --
005 Social Studies CST | 23 | 23 | 100%
020 Spanish CST | 10 | 10 | 100%
Aggregate | 243 | 242 | 100%
Other Content Areas
001 LAST | 303 | 302 | 100%
Aggregate | 303 | 302 | 100%
Teaching Special Populations
060 Stu.W/Disab.CST | 102 | 100 | 98%
Aggregate | 102 | 100 | 98%
Summary Totals and Pass Rate | 303 | 300 | 99%
Spreadsheet: 9577b816-cb54-4bf3-b0b1-3ef8b4a99ff4
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
LKM | Test | LKM | Liver/Kidney Microsome Type 1 Antibodies, Serum | Liver/Kidney Microsome Type 1 Ab, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | < or =20.0 Units (negative) 20.1-24.9 Units (equivocal) > or =25.0 Units (positive) Reference values apply to all ages. | Monday, Wednesday, Friday | 1 day | 4 days | 1 | 86376 |  |  |  |  | Rochester
LKM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
LKM | Result | LKM | Liver/Kidney Microsome Type 1 Ab, S | Liver/Kidney Microsome Type 1 Ab, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 32220-6 | Liver kidney microsomal 1 Ab:ACnc:Pt:Ser:Qn:
Spreadsheet: 0b65ea84-105c-4f8a-b2ac-5d51708d3cd8
Sheet: Totals

 | Headcount Of Credit Graded Students
 | MSJC Online Total by Ethnic Groups
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Term Total
Academic Year | 6576 |  |  | 7552 |  |  | 7119 |  |  | 6510
% of Total | Credit Headcount % of Total
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Success Rate | Success Rate
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Term Average
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 728506d1618487738-look-up-two-references-over-multiple-pages-lookup-multiple-pages-2
Sheet: Entry sheet

 | ANO | Customer
 | PCABC | Staff |  |  | TO
 | SSANO | Customer Contact |  |  | FROM
 | ABC | Customer
 | SSANO | Customer Contact |  |  | TO
 | PCABC | Staff |  |  | FROM
 | ANO
 | ABC
 | SSANO |  |  |  | the revised formula in D13 has the formula in three times based on IF and ISNA,  looking at B11 first and if B11 = #[NAME], looking in B!2, But it still does not have the formula for the column - see below
 | PCABC |  |  |  | the revised formula in D13 has the formula in three times based on IF and ISNA,  looking at B12 first and if B12 = #[NAME], looking in B11, But it still does not have the formula for the column - see below
 |  |  |  |  | The IF/ISNA solves the problem of having to look up both entries - but is clunky
 |  |  |  |  | So, to actually get the formula to work, I just need to find a way o fgeting the formula below to work on a multi-page named range…
 | formula for column in single sheet |  |  |  | MAX(INDEX(COLUMN('Customer List'!$E$5:$CX$9)*('Customer List'!$B$5:$B$7=$L$5)*('Customer List'!$E$5:$CX$7=$L$8),))
 |  |  |  |  |  | in use - the formula returns column 5 which is the correct solumn for stephen sharp
Spreadsheet: 097135a4-f1d4-4c80-9908-44aaae4b1afd
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120618 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | [NAME]
 | 12th Amendment
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 | Reason For Legislation |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents |  | Tax Increment Financing Commission
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 | Discussion
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  |  |  |  |  | Not Applicable
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 | Recommendation: The staff recommends approval
 | of this ordinance.
Applicable Dates:
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: 818212d1676648789-expected-outcome-based-on-2-criteria-sample-workbook-3-
Sheet: Sheet2

Transaction Identified | Amount | Period | Days Overdue | Aging Bucket | Aging criteria | > Aged Criteria | Aging Minus 30 Days (31-60) | Aging Minus 60 Days (61-90) | Aging Minus 90 Days (91-120) | Aging Minus 90 Days (91-120) |  |  |  | Overdue | Bucket
2022-06-29 00:00:00 | 268.63 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0 | Not Due
2022-12-31 00:00:00 | 233.79 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1-30
2022-11-30 00:00:00 | 845600 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 31 | 31-60
2022-07-30 00:00:00 | 358251 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 61 | 61-90
2022-08-31 00:00:00 | 241600 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 91 | 91-120
2022-05-31 00:00:00 | 238504 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 121 | 121-180
2022-12-31 00:00:00 | 477008 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 181 | >180
 | 350 |  | 32 | 31-60 | 30 |  | 0
 | 250 |  | 65 | 61-90 | 60 |  | 0
 | 359 |  | 95 | 91-180 | 60 |  | 0
 | 1000 |  | 33 | 31-60 | 60
 | 500 |  | 28 | 0-30 | 60 |  | 0 | bcz its not falling under 31-60
 | 390 |  | 65 | 61-90 | 90 |  | 390
 | 540 |  | 58 | 31-60 | 90 | 0 | 0
 | 365 |  | 95 | 91-120 | 90 | 365 | 0
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: TGR View

ERF | Site [NAME] | Date (Estimate Complete) | Date  (Outage Start) | SORT ALL FROM HERE Status | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order
Spreadsheet: 94227d1294090104-net-price-div-error-help
Sheet: Sheet1 (2)

 | Name | Code | Size |  |  | Order | Free | $$$ | Net
 | Product 1 | 123 | 5ml | 14.8 |  | 1 |  | 14.8 | 14.8 | 14.8
 | Product 2 | 124 | 6ml | 80.99 |  | 1 |  | 80.99 | 80.99 | 80.99
 | Product 3 | 125 | 7ml | 13.5 |  | 2 | 2 | 27 | 6.75 | 6.75
 | Product 4 | 126 | 55ml | 26.5 |  | 0 |  | 0 | #N/A | 0
 | Product 5 | 127 | 10ml | 59.75 |  | 0 |  | 0 | #N/A | 0
 | Product 6 | 128 | 200ml | 93.75 |  | 0 |  | 0 | #N/A | 0
Spreadsheet: 05c2c318-832f-4a20-96a7-b857c167d7c5
Sheet: Dropdown selections

Select One (drop down)
1a - Promotion and Reallocation to a Higher-Level Class
1b - Employee applies for a job vacancy, is selected competitively, and employee changes jobs
2a - Adjustment related to an increase in job duties or responsibilities
2b - Temporary adjustment related to an increase in job duties or responsibilities; salary will revert when temporary duties cease
3 - Retention
4 - Career progression adjustments for demonstrated competencies
5 - University Cancer Research Fund
6 - Distinguished Professors Endowment Fund
7 - Faculty Recruiting and Retention Fund
8 - Non-State Funds Other (must explain in comments)
9 - State Funds Other (must explain in comments)
10 - Conversion in appointment period without other adjustments (i.e., 9 to 12 month conversion)
Select One (drop down)
Base
Stipend/Supplement
Lump Sum Payment
Temporary Assignment
Base and Stipend/Supplement
Base and [NAME]
Base and Temporary Assignment
Spreadsheet: 742253d1627626036-help-with-vlookup-across-different-sheets-based-on-criteria-sen-pon-help
Sheet: O

 | Name of children | Year group | Hours of Support | LSA to ffer support | Difficulties
Spreadsheet: 135503d1326103476-drop-down-lists-labour
Sheet: Data

Grade | Long Term | [NAME] | Short Term
Programme Director | 400 | 500 | 600
Solution Director | 385 | 485 | 585
Programme Manager | 370 | 470 | 570
Portfolio Manager | 355 | 455 | 555
Senior Project Manager | 340 | 440 | 540
Project Manager | 325 | 425 | 525
Senior Consultant | 310 | 410 | 510
Applications Consultant | 295 | 395 | 495
Technical Consultant | 280 | 380 | 480
Solutions Architect | 265 | 365 | 465
Enterprise Architect | 250 | 350 | 450
Technical Architect | 235 | 335 | 435
Network Technical Architect | 220 | 320 | 420
Network Engineer | 205 | 305 | 405
PMO | 190 | 290 | 390
Desktop Engineer | 175 | 275 | 375
SQL DBA | 160 | 260 | 360
Wintel Engineer | 145 | 245 | 345
Unix Engineer | 130 | 230 | 330
Security Consultant | 115 | 215 | 315
Spreadsheet: joe_parks__14766__Auction I and II curves
Sheet: Sheet1

CURVES FOR LIVE COUNTERS IN AUCTIONS I AND II |  |  |  |  | BASIS CURVES
AUCTION I | nx1 | if-cig/rkymtn | if-elpo/sj | if-elpo/permian | ngi-pge/cg | if-hpl/shpchan | ngi-socal | if-pan/tx/ok | if-cgt/appalac | if-transco/z6 | [NAME] | if-nwpl_rocky_m | if-tetco/[NAME] | ngi/chi. Gate
NEUMINPROCO | 2006-12-01 00:00:00
DEVXENEINC | 2003-12-01 00:00:00
NATIONALFUEMAR | 2002-10-02 00:00:00 | 2002-10-02 00:00:00 | 2002-10-02 00:00:00
WISEROILCOM | 2002-09-01 00:00:00
WILLIAMSPRORMT | 2003-10-01 00:00:00 | 2003-02-01 00:00:00 |  | 2002-10-02 00:00:00
MERCEDIRRDIS | 2003-02-01 00:00:00 |  |  |  | 2003-02-01 00:00:00
IMPERIALSUGCO |  |  |  |  | 2002-04-02 00:00:00 |  | 2002-09-02 00:00:00
LDNGCSER98TRU | 2002-12-01 00:00:00 |  |  |  |  | 2002-12-02 00:00:00
CABOTOILGASMARK | 2003-09-01 00:00:00 |  |  |  |  | 2003-09-01 00:00:00
WTGGASMAR | 2003-12-01 00:00:00 |  |  | 2002-11-02 00:00:00 |  | 2003-12-01 00:00:00 |  | 2002-08-01 00:00:00
COLUMBIA ENERGY | 2003-12-01 00:00:00 |  |  |  |  |  |  |  | 2002-06-01 00:00:00 | 2003-10-01 00:00:00
DTEENETRA | 2002-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2002-10-01 00:00:00
MARATHON |  |  |  |  |  |  |  |  |  |  |  | 2003-12-01 00:00:00 | 2002-10-01 00:00:00
ENTRADAENEVEN | 2007-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2007-12-01 00:00:00
GIANTREFCOM | 2002-04-01 00:00:00 |  | 2002-10-01 00:00:00
KAZTEXENEMAN |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002-10-01 00:00:00
STONEENECOR | 2003-12-01 00:00:00
FLORIDAPOWCOR | 2003-12-01 00:00:00
DOMINIONEXPCAN | 2004-12-01 00:00:00
HUNTPETCOR | 2002-12-01 00:00:00
[NAME] | 2002-10-01 00:00:00
AUCTION II
DUFERCOFCOR | 2004-12-01 00:00:00
GENERALMILOPE | 2003-05-01 00:00:00 |  |  |  | 2003-05-01 00:00:00
Spreadsheet: 109511d1306343965-if-then-formula-tracking
Sheet: Master

NAME | UNIT | DOR | UNIVERSITY | RRNCO | PMOS | GRAD DATE | MS LEVEL | COMPONENT | LOA | PACKET SUBMITTED | BONUS ELIGIBLE | NOTES | PACKET SUBMISSION DATE | CLASS II PHYSICAL DATE
Spreadsheet: 847901d1698745044-bulk-substitute-in-a-spilling-array-cannot-split-aligw
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
 |  |  |  |  |  |  | split (range O2#, row 1) |  | split (array, row 1) ([NAME]) |  |  | split (array, row 1) (glenn formula) |  |  | AliGW
Spreadsheet: 111937d1308164675-help-with-formula-for-gain-or-loss-with-variables-help
Sheet: Sheet1

 | Purchase Price | Past Income | Current income | Price A | Price B | % Gain / Loss
 | 27.71 | 0 | 1.25 | 28 | 26.54 | ????
 | 13.25 | 0 | 0.61 | 13 | 13.29 | ????
 | 12.92 | 0 | 1.15 | 12.5 | 12.39 | ????
Spreadsheet: benjamin_rogers__1159__Base
Sheet: IS

EGC INCOME STATEMENT
('000 $) |  |  | 1999
Revenue
PPA Period:
Demand Payment
Energy Payment
Block Payment
Market Period:
Demand Payment
Variable Revenue
Energy Margin
Enron's Undertaking For LOC Fee |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Income from Enron
Total Revenue
Expense
Fuel
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Power
Property, Other Tax (1)
Debt Service Reserve [NAME] |  |  | 0
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense (2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
(1) This line item includes property tax, franchise tax and gross receipts tax.
(2) Interest Expense for 1999 and 2000 is shown net of capitalized interest associated with the 2000 facilities.
Spreadsheet: 463324d1464439294-lookup-data-in-a-table-from-another-workbook-untitled-spreadsheet-v1
Sheet: Sheet1

 | characteristic 1 | characteristic 2 | characteristic 3 | characteristic 4 | characteristic 5
person 1
person 2 | description B3
person 3 |  |  |  |  | description F4
person 4 |  |  |  | description E5
person 5
person 6 |  |  | description D7
person 7
person 8 |  | description C9
person 9
person 10 |  |  |  |  | description F11
person 11 |  |  | description D12
person 12
Spreadsheet: 126254d1319588965-match-function-only-returns-1st-match-sched-formula
Sheet: master

part Number |  | [NAME] |  | lath due |  | swiss due
90-4523
90-6544
33-778
34-5432
90-3344
90-7754
54-7886
12-3456
Spreadsheet: 727126d1617723973-match-revisions-to-matching-parts-drawings-need-matching-revs
Sheet: 1 Assy Dwgs

SolidWorks
Item ID | Item ID |  | Migrate with Revision
[PHONE].SLDDRW | 10000030000 | SLDDRW | A
[PHONE].SLDDRW | 10000031000 | SLDDRW | A
[PHONE].SLDDRW | 10000031001 | SLDDRW | A
[PHONE].sldasm | 10130027400 | sldasm | A
[PHONE].SLDDRW | 10130027400 | SLDDRW | A
[PHONE].SLDDRW | 10130028402 | SLDDRW | B
[PHONE].SLDDRW | 10130029402 | SLDDRW | A
[PHONE].SLDASM | 10130030000 | SLDASM |  | Since assembly and drawing are same number, then revisions should match. There may even be case where there is a part, drawing and assembly with same number that will need matching revisions.
[PHONE].SLDDRW | 10130030000 | SLDDRW | A
[PHONE].SLDASM | 10130030202 | SLDASM
[PHONE].SLDDRW | 10130030202 | SLDDRW | B
Spreadsheet: 819152d1677248058-generate-table-from-table-with-random-in-mind-test
Sheet: Sheet1

Article | Amount |  | Document | A | B | C | D | E
A | 20 |  | 1 | 10 | 5 | 10 |  | 5
B | 30 |  | 2 |  | 5
C | 25 |  | 3 | 5 | 15 |  | 10
D | 15 |  | 4 | 5 |  | 10 |  | 5
E | 10 |  | 5 |  | 5 | 5 | 5
Spreadsheet: 832149d1686145374-how-can-i-sum-the-recurring-income-for-each-month-using-start-date-of-the-recurring-income-example-requirement
Sheet: Sheet1

 | Expense | STATUS | PAYMENT DATE | ceased date | PRICE PER MONTH
 | test1 | LIVE | Mon 02 Jan 23 |  | 200
 | test2 | CEASED | Thu 15 Feb 23 | Sun 15 Apr 23 | 125
 | test3 | LIVE | Mon 15 May 23 |  | 50
 | test 4 | LIVE | Mon 22 May 23 |  | 25
Month | Start | End | Income (Mnaual) | Income Formula
2023-01-01 00:00:00 | 2023-01-01 00:00:00 |  | 200
2023-02-01 00:00:00 | 2023-02-01 00:00:00 |  | 325
2023-03-01 00:00:00 | 2023-03-01 00:00:00 |  | 325
2023-04-01 00:00:00 | 2023-04-01 00:00:00 |  | 325
2023-05-01 00:00:00 | 2023-05-01 00:00:00 |  | 275
2023-06-01 00:00:00 | 2023-06-01 00:00:00 |  | 275
2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 275
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 219 | 150
2 | 22 | 150
3 | 305 | 150
4 | 287 | 150
5 | 214 | 150
6 | 211 | 150
7 | 236 | 150
8 | 226 | 150
9 | 249 | 150
10 | 205 | 150
11 | 276 | 150
12 | 238 | 150
13 | 257 | 150
14 | 221 | 150
15 | 315 | 150
16 | 253 | 150
17 | 223 | 150
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 180048.98
2002-01-17 00:00:00
CBS Volume
 |  |  | 79013