tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 808746d1670609532-need-formula-to-fill-multiple-fields-at-same-time-electrical-use-budget-tracker-sample
Sheet: Sheet1

USAGE & COST TRACKER FOR ELECTRIC |  | HOUSE or BLDG -1 |  | GARAGE or BLDG-2 |  |  |  |  |  |  |  | MONTH | YEAR | BLDG
 |  |  |  |  |  |  |  |  |  |  |  | SELECT MONTH | SELECT YEAR | SELECT BLDG
COMBINED COST BY YEAR: |  | 1983-12-01 00:00:00 |  | CURRENT (MONTH) COMBINED ELECTRICAL USAGE COST: |  | SELECT MONTH | <---BASED ON MONTH SELECTED IN COLUMN "M" |  |  |  |  | JAN | 1983-12-01 00:00:00 | HOUSE / BLDG-1
 |  |  |  |  |  |  |  |  |  |  |  | FEB |  | GARAGE / BLDG-2
 |  |  |  |  |  |  |  |  |  |  |  | MAR
COMBINED AVERAGE MONTHLY COST BY YEAR: |  | 0 | BASED ON YEAR SELECTED IN COLUMN "N" | COMBINED KWH USED FOR THE CURRENT MONTH: |  | 0 | <---BASED ON MONTH SELECTED |  |  |  |  | APR
 |  |  |  |  |  |  |  |  |  |  |  | MAY
 |  |  |  |  |  |  |  |  |  |  |  | JUN
AVERAGE KWH CURRENT MONTH USED BY THE (HOUSE): |  | 0 | BASED ON YEAR SELECTED IN $C$3 |  |  |  |  |  |  |  |  | JUL
 |  |  |  |  |  |  |  |  |  |  |  | AUG
 |  |  |  |  |  |  |  |  |  |  |  | SEP
AVERAGE KWH CURRENT MONTH USED BY THE (GARAGE): |  |  | BASED ON YEAR SELECTED IN $C$3 |  |  |  |  |  |  |  |  | OCT
 |  |  |  |  |  |  |  |  |  |  |  | NOV
 |  |  |  |  |  |  |  |  |  |  |  | DEC
TOTAL COMBINED KWH                               USED FOR THE YEAR: |  | 0 | BASED ON YEAR SELECTED IN $C$3
 | BILLING PERIOD | HOUSE / BLDG-1 | KWH USED (H) / (1) | GARAGE / BLDG-2 | KWH USED (G) / (2) | COMBINED TOTAL
 | 1983-01-30 00:00:00 |  |  |  |  |  | AVG KWH USED PER MONTH | AVG KWH USED PER MONTH
 | 1983-02-28 00:00:00 |  |  |  |  |  |  |  | TOTAL COST COMBINED FOR CURRENT YEAR
 | 1983-03-31 00:00:00 | 151.25
 | 1983-04-30 00:00:00 | 115.68
 | 1983-05-31 00:00:00 | 89.82 |  |  |  |  | AVG COST PER MONTH (HOUSE) | AVG COST PER MONTH (HOUSE)
 | 1983-06-30 00:00:00 | 64.14 |  | 55.57
 | 1983-07-31 00:00:00 | 57.38 |  | 85.27
 | 1983-08-31 00:00:00 | 76.48 |  | 94.47
 | 1983-09-30 00:00:00 | 59.39 |  | 78.65 |  |  | TOTAL COST FOR YEAR (HOUSE) | TOTAL COST FOR YEAR (HOUSE)
 | 1983-10-31 00:00:00 | 60.8 |  | 77.87
 | 1983-11-30 00:00:00 | 53.48 |  | 65.11
 | 1983-12-31 00:00:00 | 57.57 |  | 83.76
 |  | 96.32 |  |  |  |  | AVG KWH USED PER MONTH | AVG KWH USED PER MONTH
 |  | 0 |  |  |  |  |  |  | TOTAL COST COMBINED FOR CURRENT YEAR
 |  |  |  |  |  |  | AVG COST PER MONTH (HOUSE) | AVG COST PER MONTH (HOUSE)
 |  |  |  |  |  |  | TOTAL COST FOR YEAR (HOUSE) | TOTAL COST FOR YEAR (HOUSE)
 |  |  |  |  |  |  | AVG KWH USED PER MONTH | AVG KWH USED PER MONTH
 |  |  |  |  |  |  |  |  | TOTAL COST COMBINED FOR CURRENT YEAR
 |  |  |  |  |  |  | AVG COST PER MONTH (HOUSE) | AVG COST PER MONTH (HOUSE)
Spreadsheet: a98b608d-7138-4085-8006-49cac0709522
Sheet: non-GAAP Net Inc & Op Inc

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP Net Income, Diluted Earnings Per Share, Operating Income, Revenues and Operating Expenses
to Non-GAAP Net Income, Diluted Earnings Per Share, Operating Income, Revenues and Operating Expenses
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | June 30, |  | March 31, |  | June 30,
 |  | 2012 |  | 2012 |  | 2011
GAAP net income attributable to NASDAQ OMX: |  |  | 43
Non-GAAP adjustments:
Income from open positions relating to the operations of the Exchange |  | -11 |  | 0 |  | 0
Asset impairment charges |  | 28 |  | 12 |  | 0
Restructuring charges |  | 17 |  | 9 |  | 0
Merger and strategic initiatives |  | 1 |  | 2 |  | 29
Other |  | 2 |  | 0 |  | 0
Total non-GAAP adjustments
Adjustment to the income tax provision to reflect non-GAAP adjustments(1) |  | -13 |  | -3 |  | -9
Significant tax adjustments, net |  | -6 |  | 3 |  | 0
Total non-GAAP adjustments, net of tax
Non-GAAP net income attributable to NASDAQ OMX:
GAAP diluted earnings per common share:
Total adjustments from non-GAAP net income above |  | 0.11 |  | 0.13 |  | 0.11
Non-GAAP diluted earnings per common share:
 |  | Three Months Ended
 |  | June 30, |  | March 31, |  | June 30,
 |  | 2012 |  | 2012 |  | 2011
GAAP operating income:
Non-GAAP adjustments:
Income from open positions relating to the operations of the Exchange |  | -11 |  | 0 |  | 0
Restructuring charges |  | 17 |  | 9 |  | 0
Merger and strategic initiatives |  | 1 |  | 2 |  | 29
Other |  | 2 |  | 0 |  | 0
Total non-GAAP adjustments
Non-GAAP operating income:
Total revenues less transaction rebates, brokerage,
clearance and exchange fees
Non-GAAP operating margin (2)
(1) We determine the tax effect of each item based on the tax rules in the respective jurisdiction where the transaction
occurred.
(2) Non-GAAP operating margin equals non-GAAP operating income divided by total revenues less transaction rebates,
brokerage, clearance and exchange fees.
Spreadsheet: 158925d1338451804-excel-2007-pivot-table-with-dates-help-required-ptgroupbyday
Sheet: Sheet1

Date | Time | DateTime
 |  |  |  |  |  | You need to group the Dates by Days!!!
 |  |  |  |  |  | Row Labels | Count of DateTime
 |  |  |  |  |  | May
 |  |  |  |  |  | 31-May | 8
 |  |  |  |  |  | Jun
 |  |  |  |  |  | 1-Jun | 9
 |  |  |  |  |  | 2-Jun | 7
 |  |  |  |  |  | 3-Jun | 5
 |  |  |  |  |  | Grand Total | 29
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 16

Product* | November 1 | November 8 | November 15 | November 22 | November 29
Total Equity** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Gross notional amount outstanding, November 29 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 490401d1479843133-smart-lookup-ejoneslor-lookup-example
Sheet: Sheet1

 |  |  |  | Required Output
 | Document | Status | Revision | Previous Status
 | Drawing 1 | F | 4 | D
 | Drawing 1 | E | 4 | D
 | Drawing 1 | D | 3 | B
 | Drawing 1 | C | 3 | B
 | Drawing 1 | B | 2 | A
 | Drawing 1 | A | 1
 | Drawing 2 | D | 4 | C
 | Drawing 2 | C | 3 | B
 | Drawing 2 | B | 2 | A
 | Drawing 2 | A | 1
 | Drawing 3 | F | 4 | D
 | Drawing 3 | E | 4 | D
 | Drawing 3 | D | 3 | C
 | Drawing 3 | C | 2 | A
 | Drawing 3 | B | 2 | A
 | Drawing 3 | A | 1
Spreadsheet: 766294d1643829953-find-primary-supplier-for-each-product-max-supplier-question-example-jakepr26-
Sheet: Situation #2

Pizza Joint
 | Product Value |  |  |  | Supplier A | Supplier B | Supplier C
 | 4 Shop | 4 Supplier |  | Inv Percent | 0.414 | 0.28 | 0.306
Tomato | 5 | 4
Cheese | 4 | 5
Dough | 2 | 5
Green Peppers | 3 | 2
Spreadsheet: 582229d1531791820-multiple-lookup-results-multiple-look-ups_result-to-one-column
Sheet: Sheet1

Name | Country | [NAME]
[NAME] | DE
[NAME] | GB
Kerry | DE
Kerry | ES
Wilma | GB
Wilma | PL
Wilma | FR
Wilma | ES
[NAME] | GB
[NAME] | PL
Spreadsheet: 142052d1329604478-ranking-rankingissue
Sheet: Sheet1

Junior 1
[NAME]
Monthly | 1 | 0.1
Mid-Term | 1 | 0.35
Finals | 1 | 0.5
Overall | 0.95
[NAME]
Monthly | 2 | 0.2
Mid-Term | 2 | 0.7
Finals | 2 | 1
Overall | 1.9
[NAME]
Monthly | 3 | 0.3
Mid-Term | 3 | 1.05
Finals | 3
Overall | 2.85
[NAME]
Monthly | 3 | 0.3
Mid-Term | 3 | 1.05
Finals | 3
Overall | 2.4
Spreadsheet: 680102d1590779065-making-calculations-upon-multiple-conditions-without-using-many-ugly-ifs-strogg-making-calculations-upon-multiple-conditions-without-using-many-ugly-ifs
Sheet: Sheet1

CARTONS Q-TY | JUICES |  |  |  |  | PALLETE HEIGHT
24 | JUICE 1L
24 | JUICE 1L
24 | JUICE 1L
24 | JUICE 1L
24 | JUICE 1L
24 | JUICE 1L
29 | JUICE 1L
24 | JUICE 1L
30 | JUICE 1L
40 | JUICE 1L
40 | JUICE 1L
40 | JUICE 1L
40 | JUICE 1L
40 | JUICE 1L
40 | JUICE 1L
80 | JUICE 330 ML
40 | JUICE 1L
80 | JUICE 330 ML
80 | JUICE 330 ML
80 | JUICE 330 ML
80 | JUICE 330 ML
80 | JUICE 330 ML
70 | JUICE 330 ML
80 | JUICE 330 ML
70 | JUICE 1L - 12 CARTONS;  JUICE 330 ML - 46 CARTONS;  JUICE 330 ML - 12 CARTONS
70 | JUICE 330 ML-  46 CARTONS;  JUICE 330 ML - 14 CARTONS
70 | JUICE 330 ML
70 | JUICE 330 ML
70 | JUICE 330 ML
70 | JUICE 330 ML
70 | JUICE 330 ML
70 | JUICE 330 ML
70 | JUICE 330 ML
Spreadsheet: 855791d1705297255-return-o-or-1-if-cell-value-is-found-in-2nd-worksheet-match
Sheet: Main

Tract+Group | Target Market
531.15.2 |  | <----target market cells should return a "0" or "1".  If a tract+group # in column A is found in the "Target Groups" worksheet it should return a "1" and a "0" if it was not listed in the Target Groups worksheet.
535.07.2
529.05.2
536.20.1
541.16.2
541.13.1
545.02.1
534.21.2
521.02.2
541.19.1
531.09.2
527.07.2
540.11.2
531.10.2
542.22.3
529.03.2
537.29.2
541.21.1
544.04.1
528.10.3
Spreadsheet: 793645d1661605254-if-x-and-y-and-date-then-total-2022-08-27-oeldere-brandonla7-sample-20-
Sheet: Sheet1

Column | Total |  | year | 2022
String
 |  |  | Som van Total | Kolomlabels
 |  |  | Rijlabels | 1 | 12 | Eindtotaal
 |  |  | String | 5 | 15 | 20
 |  |  | Brand | 5 | 10 | 15
 |  |  | Company |  | 5 | 5
 |  |  | Word | 10 | 10 | 20
 |  |  | Brand | 5 | 5 | 10
 |  |  | Company | 5 | 5 | 10
 |  |  | Eindtotaal | 15 | 25 | 40
Spreadsheet: 757936d1638543684-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 1 (John)

[NAME] |  |  |  |  |  |  |  |  |  |  | (Please put an x to show all learning has been completed or an E if there is a valid exception)
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date PJ Commenced | TUD Date | Cohort | Expected Week in Stage 1 Learning | Week 1 | Week 2 | Race Equality Workshop | Week 3 | [NAME] | Case Study 1 | Case Study 2 | Week 4 | Case Study 3 | Week 5 | Case Study 4 | Case Study 5 | Week 6 | Case Study 6 | Case Study 7 | Week 7 | Case Study 8 | Case Study 9 | Week 8 | Exceptions
 | 123 | Manager A | 5 | Wales | #N/A | A1 | 44424 | 44424 | A1.1 | #N/A | x | x | x | x | x | 0 | 0 | x | 0 | x | 0 | 0 | x | 0 | 0 | x | 0 | 0 | x | #N/A
Learner 2 | 234 | Manager A | 5 | Wales | #N/A | A1 | 44421 | 44417 | A1.1 | #N/A | x | X | X | x | x | 0 | 0 | x | 0 | x | 0 | 0 | x | 0 | 0 | 0 | 0 | 0 | x | #N/A
Learner 5 | 567 | Manager C | 5 | England | #N/A | A3 | 44466 | 44452 | A3.3 | #N/A | x | x | x | x | x | x | x | x | x | x | 0 | x | x | x | x | x | x | x | x | #N/A
Spreadsheet: louise_kitchen__22632__Corp_2002_Alloc_3
Sheet: Summary

Corporate Staff Functions
Total Corporate Staff & Services Groups Charges
2002 Plan
(In thousands)
 |  |  |  |  |  |  |  | Northern |  | ETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Retained
 |  |  |  |  | TW | FGT | Citrus | Plains | NNG | HQ | EOTT | EEOS | NEPCO | ENA | Europe | EGM | EIM | EES | EBS | ENW | EGAS | EGF | EPI | PGG | Azurix | EPSC | Other | Allocated | At Corp
EXECUTIVE
LEGAL
RISK ASSESSMENT & CONTROL
ACCOUNTING & COMPLIANCE
CORPORATE TAX
INVESTOR RELATIONS
CORPORATE DEVELOPMENT
RISK MANAGEMENT
SAP ISC
STRATEGIC SOURCING
HUMAN RESOURCES & COMPENSATION
BENEFIT PLANS
PUBLIC AFFAIRS & ADMINISTRATION
COMMUNITY RELATIONS
EPSC |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | GRAND TOTAL
Spreadsheet: 0620f6e9-2bca-470d-8099-a6124fb2cc97
Sheet: Sheet1

Idaho School-Based Medicaid Reimburseable IEP Services
Student Name: |  | Date of Birth: |  | Age | Grade | Sex
School District |  | School: |  | Case Manager: |  | Date:
Current IEP: |  | Projected Annual: |  | Current Evaluation: | Projected Triennial:
If the student is or becomes eligible for Medicaid and if they meet the requirements to receive specific evaluations or interventions, the following services and hours may be billed with parental consent:
These services are effective as of the date of the physician's signature and services will not exceed 365 days.  The below services are deemed medically necessary as recommended.
Physician's Signature: |  |  |  |  | Date:
IEP School-Based Medicaid Services
IEP Services | Start Date | End Date | Description |  | Medicaid Code # | Frequency and Duration
 |  |  | Psychotherapy-30 minutes |  | 90832
 |  |  | Psychotherapy-45 minutes |  | 90834
 |  |  | Psychotherapy-60 minutes |  | 90837
 |  |  | Group Psychotherapy |  | 90853
 |  |  | [NAME] w/o patient present |  | 90846
 |  |  | Family [NAME]/patient present |  | 90847
 |  |  | SLP Tech Individual Therapy |  | 92507:HM
 |  |  | SLP Tech Group Therapy |  | 92508
 |  |  | SLP Professional Individual Therapy |  | 92507:HO
 |  |  | SLP Professional Group Therapy |  | 92508:HO
 |  |  | PT  Professional Individual Therapy |  | 97110:HO
 |  |  | PT Professional Group Therapy |  | 97150:HO
 |  |  | OT Tech Individual Therapy |  | 97530
 |  |  | OT Tech Group Therapy |  | 97530:HM
 |  |  | OT Professional Individual Therapy |  | 97530:HO
 |  |  | OT Professional Group Therapy |  | 97530:HQ
 |  |  | Behavioral Intervention - Professional |  | 96152
 |  |  | Behavioral Intervention - Professional Group |  | 96153
 |  |  | Behavioral Intervention - Para Individual |  | 96152:HM
 |  |  | Behavioral Intervention - Para Group |  | 96153:HM
 |  |  | Behavioral Consultation |  | H2019
 |  |  | Individual [NAME] (PSR) |  | H2017
 |  |  | Group [NAME] (PSR) |  | H2017:HQ
 |  |  | Community Reintegration (PSR) |  | H0036
 |  |  | Personal Care Service-Supervising RN Visit |  | T1001
 |  |  | Nursing Services RN Oversight of LPN |  | T1002
 |  |  | Nursing Services - RN, Skilled |  | T1002:TD
 |  |  | Nursing Services - LPN, Skilled |  | T1003
 |  |  | Personal Care Services by qualified paraprofessional |  | T1019
 |  |  | PCS-Supervising QIDP visit |  | H2020
 |  |  | Interpretive Services Oral |  | T1013
 |  |  | Interpretive Services Sign Language |  | T1013:CG
 |  |  | Non-Emergency Transportation: Attendant/Escort |  | T2001
 |  |  | Medical Equipment and Supplies |  | E1399
 |  |  | Transportation |  | A0080
Case Manager Signature: |  |  | Title: |  | Date:
Other: |  |  | Title: |  | Date:
Spreadsheet: 330756d1404844769-formula-for-teacher-and-class-timetable-timetable
Sheet: Class

VI A |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Mon | Eng | [NAME] | Mat | Sci | Soc | Eng | Mat | Sci
 | Tue | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME]
 | Wed | Eng | [NAME] | Mat | Sci | Soc | Eng | Mat | Sci
 | Thu | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME] |  | Here we enter periods for classes
 | Fri | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME]
VI B |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Sat | Eng | [NAME] | Mat | Sci | Soc | Eng | Mat | Sci
 | Sun | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME]
 | Mon | Eng | [NAME] | Mat | Sci | Soc | Eng | Mat | Sci
 | Tue | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME]
 | Wed | Eng | [NAME] | Mat | Sci | Soc | Mat | Sci | [NAME]
VI C |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Thu | Eng | [NAME] | Mat | Soc | Sci | Eng | Mat | Sci
 | Fri | Eng | [NAME] | Mat | Soc | Sci | Mat | Sci | [NAME]
 | Sat | Eng | [NAME] | Mat | Soc | Sci | Eng | Mat | Sci
 | Sun | Eng | [NAME] | Mat | Soc | Sci | Mat | Sci | [NAME]
 | Mon | Eng | [NAME] | Mat | Soc | Sci | Mat | Sci | [NAME]
Spreadsheet: 579055d1529665404-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1st-column-_generate-a-list-from-master-list_v1
Sheet: Region

 |  | Region
 |  | East | << example: If we select "West" then all the cells from D9:F9 onwards should auto-populate based
 | S.No. | Product | Region | Sales |  | Cross-Check 1: |  | Cross-Check 2:
 | 1 |  |  |  |  |  |  | Row Labels | Count of Product
 | 2 |  |  |  |  |  |  | East | 8
 | 3 |  |  |  |  |  |  | North | 9
 | 4 |  |  |  |  |  |  | South | 7
 | 5 |  |  |  |  |  |  | West | 11
 | 6 |  |  |  |  |  |  | Grand Total | 35
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 01a57e51-fc64-4fcb-b3cb-1ce90f3eece4
Sheet: Calculator

Select a target group from a dropdown box and add the projected wage and hours worked to calculate an estimate of your tax credit.
 | Work Opportunity Tax Credit Calculator
 |  |  |  |  | Veterans |  | Other Target Groups
 |  |  | Select the individual's target group
 |  |  | Enter projected hourly wage for     first year of employment |  | 7.5
 |  |  | Enter projected # of hours worked in first year of employment |  | 0
 |  |  | Tax credit for hiring the individual
 |  | Please note: |  |  |  |  |  |  |  |  |  | VETERANS
 |  | + | Employers earn a tax credit only if employees  work at least 120 hrs in the first year of employment. |  |  |  |  |  |  |  |  | Receives SNAP benefits (food stamps)
 |  | + | If an employee works at least 120 hrs in the first year of employment, the employer earns a tax credit equal to 25% of the employee's earnings, up to the maximum for the target group. |  |  |  |  |  |  |  |  | Entitled to comp. for service-connected disability, hired 1 year from leaving service
 |  | + | If an employee works at least 400 hrs in the first year of employment, the employer earns a tax credit equal to 40% of the employee's earnings, up to the maximum for the target group. |  |  |  |  |  |  |  |  | Entitled to comp. for service-connected disability, unemployed at least 6 months
 |  |  |  |  |  |  |  |  |  |  |  | Unemployed at least 4 weeks
 |  | The tax credit for the Long-Term TANF target group is calculated differently than other groups: |  |  |  |  |  |  |  |  |  | Unemployed at least 6 months
 |  | + | Employees only have to work at least 120 hrs in the first year of employment for employers to earn a tax credit of 40% of the employee's earnings up to the maximum ($4,000).
 |  | + | If an employee works at least 400 hours in the second year, employers  may claim a tax credit of 50% of second year wages, up to the maximum tax credit ($9,000 over two years). |  |  |  |  |  |  |  |  | OTHER TARGET GROUP MEMBERS
 |  |  |  |  |  |  |  |  |  |  |  | Short-Term TANF recipient
 |  |  |  |  |  |  |  |  |  |  |  | Long-Term TANF recipient
 |  |  |  |  |  |  |  |  |  |  |  | SNAP (food stamp) recipient
 |  |  |  |  |  |  |  |  |  |  |  | Designated Community Resident
 |  |  |  |  |  |  |  |  |  |  |  | Vocational Rehabilitation referral
 |  |  |  |  |  |  |  |  |  |  |  | Ex-Offender
 |  |  |  |  |  |  |  |  |  |  |  | SSI recipient
 |  |  |  |  |  |  |  |  |  |  |  | Summer Youth
Spreadsheet: ACS_Worksheet
Sheet: POI Calc

 | Customer Name:
 |  |  | Pay Periods: | Bi-Weekly |  | Garnishment 1 | 112.14
 |  |  |  |  |  | Garnishment 2
 |  |  | Payroll Start Date: | 2011-01-01 00:00:00 |  | Garnishment 3
 |  |  |  |  |  | Garnishment 4
 |  |  | Pay Period End Date: | 2011-10-31 00:00:00 |  | Garnishment 5
 |  |  | YTD Gross: | 21722.34
 |  |  |  |  |  | Monthly
 |  |  | Current Pay Period Gross: | 478.12
 |  |  | Social Security Withholding: |  | Amount must verify.
 | True
 |  |  | Projected Annual |  |  | YTD Monthly
 | Customer Name:
 |  |  | Pay Periods: |  |  | Garnishment 1
 |  |  |  |  |  | Garnishment 2
 |  |  | Payroll Start Date: |  |  | Garnishment 3
 |  |  |  |  |  | Garnishment 4
 |  |  | Pay Period End Date: |  |  | Garnishment 5
 |  |  | YTD Gross:
 |  |  |  |  |  | Monthly
 |  |  | Current Pay Period Gross:
 |  |  | Social Security Withholding: |  | Amount must verify.
 | True
 |  |  | Projected Annual |  |  | YTD Monthly
 |  | Combined Annual |  |  | Combined Monthly
Spreadsheet: 271141d1381842275-need-help-summing-two-columns-of-data-if-data-is-present-in-a-third-column-test-1-
Sheet: PALL90x55-P250 (Domestic)

BASE: | PALL90x55-P250 (Domestic) |  |  | OUTBOUND INFORMATION |  |  |  | TOTAL PIECES ON HAND |  |  | <<<< Sum formula Entered with Control,Shift and Enter
PO | QUANTITY | DATE AVAILABLE |  | WEBSHIPPER | QUANTITY | DATE OUT |  |  |  |  | <<< Sumproduct formula
FIRST COUNT | 8 | 2013-10-13 00:00:00 |  | 12345 | 5 | 2013-10-14 00:00:00
9999 | 8 | 2013-10-14 00:00:00
9991 | 2
Spreadsheet: 718116d1612989596-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 20

 |  |  | Date | 2021-01-20 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 1 day, 0:00:00 | 1 day, 0:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: mary_fischer__25623__31Y
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -100
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -4761453
RE - Beg Bal |  | 0920 |  | -3323448
RE - Net Income |  | 0930 |  |  |  |  |  | 63
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 748089d1631884624-return-based-on-a-set-criterias-calc-table
Sheet: Sheet1

PRICING CALCULATION AND SIGNOFF
 |  |  |  |  |  |  |  |  | Table of approval
 | Cost |  | Sales Customer Price |  |  |  |  |  | Customer price levels |  |  |  | PROFIT |  | APPROVERS |  |  |  |  |  |  |  | Titel | Names | Deputy
 | Material | Other cost | Margin Material | Material | Margin Other cost | Other Cost | Total Customer Price |  | FROM |  | TO |  |  | Profit % | CEO | CFO | MKTNG | PM | SALESM | FINC |  | CEO | Chief Operating Officer | Name 1 | Name 2
Vehicle 1 | 1000 | 100 | 0.2 |  | 0.2 |  |  |  | > | 0 | < | 1000 | > | 0.15 |  |  |  |  | x | x |  | CFO | Chief Financial Officer | Name 2 | Name 6
Vehicle 2 |  |  |  |  |  |  |  |  | > | 0 | < | 1000 | < | 0.15 |  | x |  |  | x | x |  | MKTNG | Marketing Manager | Name 3 | Name 5
Vehicle 3 |  |  |  |  |  |  |  |  | > | 1000 | =< | 10000 | > | 0.15 |  | x |  | x | x | x |  | PM | Project Manager | Name 4 | Name 3
Vehicle 4 |  |  |  |  |  |  |  |  | > | 1000 | =< | 10000 | < | 0.15 |  | x | x | x | x |  |  | SALESM | Sales manager | Name 5 | Name 4
Vehicle 5 |  |  |  |  |  |  |  |  | > | 10000 | < | 30000 | > | 0.15 | x |  | x | x |  |  |  | FINC | Finance Controller | Name 6 | Name 2
 |  |  |  |  |  |  |  |  | > | 10000 | < | 30000 | < | 0.15 | x | x | x | x
 |  |  |  |  |  | Customer Price
 |  |  |  |  |  | Cost
 |  |  |  |  |  | Profit
 | IN THIS EXAMPLE SINCE CUSTOMER PRICE IS |  |  |  |  | Profit %
 | AND PROFIT % |  | THEN I SHOULD SEE BELOW
 | Name |  | Titel |  | Signature | Date
 | DROP DOWN LIST WITH ELIGIBLE NAMES
 | Name |  | Titel |  | Signature | Date
 | DROP DOWN LIST WITH ELIGIBLE NAMES
 | Name |  | Titel |  | Signature | Date
 | DROP DOWN LIST WITH ELIGIBLE NAMES
 | Name |  | Titel |  | Signature | Date
 | DROP DOWN LIST WITH ELIGIBLE NAMES