tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 484 |  | <100 |  |  |  | 484
 | Europe |  |  | 782675 |  |  | 84910 |  |  | 867585
 | North America | 104477 | 767119 | 16945 | 8722 | 23102 | 912 | 113199 | 790221 | 17857
Index | Asia | 3545 | 89632 | 188499 | 284 | 8050 | 35773 | 3829 | 97682 | 223065
 | Europe |  |  | 2670386 |  |  | 623536 |  |  | 3026190
 | North America | 268460 | 1380672 | 206054 | 120476 | 604828 | 34533 | 317100 | 1599392 | 240587
TOTAL |  | 376481 | 2237423 | 3865044 | 129482 | 635980 | 779664 | 434128 | 2487294 | 4375768
Estimated gross notional amount outstanding, December 21 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: tracy_geaccone__40232__enron corp infomation request
Sheet: ENW Burn

 |  |  |  | YTD |  | Forecast Cash Expenditures
 |  | Headcount Actual (9/30) |  | Cash Expenditures |  | October |  | November |  | December |  | January |  | February |  | March |  | Comments
Commodity Logic
DealBench
EOL
Mid/Backoffice Outsourcing
Enterprise Portal Development
Other
Analysts/Associates
Total
Depreciation & Amortization |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Taxes Other Than Income |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Expenses net of Capitalized Expense
Plus:  Capital Expenditures |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Cash Payments |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Less: DD&A
 |  |  |  |  |  | 0
Total Cash Burn Rate
Spreadsheet: 42510d1241055332-employee-schedule-help-schedual09b
Sheet: Week

 | Area |  | Sunday |  | Monday |  | Teusday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  | Total Hours
 | Service |  |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 105
62 | [NAME] | 1 | 07:00:00 | 01:00:00
74 | Hayley | 2
9 | [NAME] | 3
26 | [NAME] | 4 | 01:00:00 | 05:00:00
43 | Ramsay | 5
 | #N/A | 6
Spreadsheet: 703878d1605204762-how-to-reference-a-certain-sheet-in-an-dynamic-averageifs-function-sampleworkbook
Sheet: 1

Depth (ft) | Column A | Column B | Column C
0 | 1 | 26 | 51
5 | 2 | 27 | 52
10 | 3 | 28 | 53
15 | 4 | 29 | 54
20 | 5 | 30 | 55
25 | 6 | 31 | 56
30 | 7 | 32 | 57
35 | 8 | 33 | 58
40 | 9 | 34 | 59
45 | 10 | 35 | 60
50 | 11 | 36 | 61
55 | 12 | 37 | 62
60 | 13 | 38 | 63
65 | 14 | 39 | 64
70 | 15 | 40 | 65
75 | 16 | 41 | 66
80 | 17 | 42 | 67
85 | 18 | 43 | 68
90 | 19 | 44 | 69
95 | 20 | 45 | 70
100 | 21 | 46 | 71
105 | 22 | 47 | 72
110 | 23 | 48 | 73
115 | 24 | 49 | 74
120 | 25 | 50 | 75
Spreadsheet: 82304d1282309257-formula-or-macro-to-fill-the-other-table-by-search-copy-and-paste-vb
Sheet: Sheet1

As Of File Date | Work Type | 1 - Hispanic |  |  | 2 - White |  |  | 3 - Black |  |  | 4 - AIAN |  |  | 5 - Asian |  |  | 6 - NHOPI |  | 7 - TNH |  |  | 8 - Other |  | Total
 |  | 1- M | 2- F | Total | 1- M | 2- F | Total | 1- M | 2- F | Total | 1- M | 2- F | Total | 1- M | 2- F | Total | 2- F | Total | 1- M | 2- F | Total | 2- F | Total
 | Perm | 6 | 12 | 18 | 83 | 93 | 176 | 22 | 58 | 80 | 2 | 1 | 3 | 1 | 4 | 5 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 286
 | Temp |  |  |  | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 4
 | 1 - Hispanic |  | 2 - White |  | 3 - Black |  | 5 - Asian |  | 6 - NHOPI |  | 4 - AIAN |  | 7 - TNH |  | 8 - Other
 | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F | 1- M | 2- F
Perm
Temp
Spreadsheet: fb7b525a-2fea-44eb-afa1-868434f0cfa2
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
CORT | Test | CORT | Cortisol, Serum | Cortisol, S | Immunoenzymatic Assay | SST Gel Tube |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL Collection Instructions: Morning (8 a.m.) and afternoon (4 p.m.) specimens are preferred. Additional Information: 1. Include time of draw. 2. If multiple specimens are drawn, send separate order for each specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | a.m.: 7-25 mcg/dL p.m.: 2-14 mcg/dL | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 82533 |  |  |  |  | Rochester
CORT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CORT | Order Question | COLT4 | Collection Time in Military Time |  | Plain Text
CORT | Result | CORTP | Cortisol, S | Cortisol, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2143-6 | Cortisol:MCnc:Pt:Ser/Plas:Qn:
CORT | Result | CAM | AM Result | AM Result | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9813-7 | Cortisol^morning:MCnc:Pt:Ser/Plas:Qn:
CORT | Result | CPM | PM Result | PM Result | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9812-9 | Cortisol^evening specimen:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: eric_saibi__9912__102601R
Sheet: Montrose 01

Owner Name |  | Kansas City Power & Light
Station Name |  | Montrose Power Station
Unit Name |  | Montrose 01
NERC Region |  | SPP
State |  | MO
Fuel Type |  | Coal
Capacity |  | 187 MW
Start Date |  | 2001-09-21 00:00:00
End Date |  | 2001-11-03 00:00:00
Prv. Start Date |  | 2001-09-21 00:00:00
Prv. End Date |  | 2001-11-19 00:00:00
Comments |  | [NAME] work.
SIC |  | 4911
Plant ID |  | 1013992
Unit ID |  | 1005291
Outage ID |  | 14186
Spreadsheet: 179759d1347372895-vlookup-to-return-a-value-based-on-what-i-input-to-a-cell-vlookup
Sheet: Sheet1

Name | Product | Sales
ASDF | Class 4 widget 10 | 10
ASDFG | Class 4 widget with bells on 15 | 15
QWER | Elbow grease 100ml 20 | 20
[NAME] | Elbow grease [NAME] | 3
QWERTY | Elbow grease 500ml 5 | 5
ZXC | Left handed screwdriver 7 | 7
ZXCV | Right handed screwdriver 654 | 654
ZXCVB | Dual hand screwdriver 311 | 311
 | Lookup Value | Sales
 | ZXC |  | Result
Spreadsheet: 849430d1699912997-how-do-i-extract-data-from-a-table-where-it-meets-certain-criteria-test-quals-spreadsheet-eba
Sheet: Training Needs

 |  | TODAY |  |  | Required/Planned
 |  | 30 DAYS or EXPIRED
 |  | 60 DAYS
 | Employee Information |  |  | Role Specific Training EXPIRY Dates |  |  |  |  |  |  |  |  |  |  |  |  | Additional Training
 | Name | Band | Attends Construction Sites? | Qual 1 | Qual2 | Qual3 | Qual4 | Qual5 | Qual6 | Qual7 | Qual8 | [NAME] | Qual10 | Qual11 | Qual12 | Qual13 | Qual14 | Qual15
 | [NAME] | Assistant Manager | N | 2024-05-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | 2026-07-10 00:00:00 | N/A | 2024-08-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-05-15 00:00:00 | 2024-05-15 00:00:00 | N/A | 2024-08-05 00:00:00 | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2019-09-30 00:00:00 | N/A |  |  | 2023-02-28 00:00:00 |  |  | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | [NAME] | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2023-12-01 00:00:00 | N/A | 2028-01-31 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-17 00:00:00 | 2026-07-10 00:00:00 | N/A | 2023-12-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | Y | 2024-10-29 00:00:00 | N/A | 2027-12-28 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-16 00:00:00 | 2026-07-10 00:00:00 | N/A | 2024-08-24 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | Training Needs | [NAME]
 | Days to expiration | 60
Spreadsheet: 705982d1606400429-excel-solution-to-quickly-remove-duplicate-and-change-format-20201126-example-format-change
Sheet: Current format

Order Number | Salutation | Account Name | Service | Product name/ Order item | Price per orderrule
00288444 | Mrs. | Jaspers-Crasborn | Service A | [NAME] | 23.5
00288444 | Mrs. | Jaspers-Crasborn | Service A | Productline - Standard | 11
00288444 | Mrs. | Jaspers-Crasborn | Service A | Productline - Care | 10.71
00288809 | Mrs. | Keulards-Leenen | Service A | Product installation | 59.5
00288809 | Mrs. | Keulards-Leenen | Service A | Productline - Standard | 22.5
00288810 | Mrs. | Meijs | Service A | Product installation | 49.17
00288810 | Mrs. | Meijs | Service A | Productline - Standard | 22.5
00288987 | Mrs. | Verzijl | Service A | Product installation | 59.5
00288987 | Mrs. | Verzijl | Service A | Productline - Care | 10.71
00288987 | Mrs. | Verzijl | Service A | Productline - Standard | 22.5
00296803 | Mrs. | Feijen-Meuffels | Service A | Product installation | 59.5
00296803 | Mrs. | Feijen-Meuffels | Service A | Productline - Standard | 22.5
00296803 | Mrs. | Feijen-Meuffels | Service A | Productline - Care | 10.71
Etc..
Spreadsheet: 799650d1665173781-compare-payroll-sub-ledger-to-general-ledger-payroll-subsidary-and-gl-entries-
Sheet: General Ledger

Fund | Program | Account | Department | Cost Center | Amount | Jrnl Line Description
01000 | 534014 | 5011110 | 350 | 300 | 1827.38 | Employer Retire [NAME]
01000 | 534014 | 5011120 | 350 | 300 | 1050.62 | Salary Social Securty&Medicare
01000 | 534014 | 5011140 | 350 | 300 | 188.83 | Group Life Insurance
01000 | 534014 | 5011150 | 350 | 300 | 2672 | Employer Health Ins Premium
01000 | 534014 | 5011160 | 350 | 300 | 157.83 | Retiree Health Ins Cr Premium
01000 | 534014 | 5011170 | 350 | 300 | 85.96 | VSDB & Longterm Disability Ins
01000 | 534014 | 5011230 | 350 | 300 | 8336.93 | Salaries, Classified
01000 | 534014 | 5011250 | 350 | 300 | 272.97 | Salaries, Overtime
01000 | 534014 | 5011380 | 350 | 300 | 40 | Deferred Comp Match Payments
01000 | 534014 | 5011660 | 350 | 300 | 210.33 | DefContMatch-VRS HybridRetPlan
01000 | 534014 | 50112303 | 350 | 300 | 4425.36 | NonProductive Vac-Classified
01000 | 534014 | 50112304 | 350 | 300 | 194.59 | NonProductive Other-Classified
01000 | 534014 | 50112305 | 350 | 300 | 1181.12 | NonProductive Sick-Classified
Spreadsheet: 876804d1723532763-count-number-of-entries-with-duplicates-once-in-a-filtered-worksheet-count-duplicates-once
Sheet: Sheet1

 |  | Total Regd. Issued | Total Students applied
Sl. No. | Year | Registration No. | Student Name | Father's Name
1 | 2022 | 1001-070204 | RAHUL ROY | ROHIT ROY
2 | 2022 | 1001-070205 | ISHAN MALLICK | PRABIR MALLICK
3 | 2022 | 1001-070206 | ROHIT BAL | RATAN BAL
4 | 2022 | 1001-070207 | SANJEEV KAPOOR | JITENDRA KAPOOR
5 | 2022 | 1001-070208 | NAYAN ARORA | SUNIL ARORA
6 | 2022 | 1001-070209 | SAYAN GHOSH | JIBAN GHOSH
7 | 2022 | NOT REGISTERED | NAVEEN DAS | TAPAN DAS
8 | 2023 | 1001-070210 | [NAME] | KABIR CHHETRI
9 | 2022 | 1001-070207 | SANJEEV KAPOOR | JITENDRA KAPOOR
10 | 2023 | 1001-070212 | JHUMA PAL | SOHAN PAL
11 | 2023 | 1001-070213 | RAHUL ROY | ROHIT ROY
12 | 2023 | 1001-070214 | KARAN KAPOOR | ARJUN KAPOOR
13 | 2023 | 1001-070215 | [NAME] | [NAME]
14 | 2023 | NOT REGISTERED | GOPAL GHOSH | KUNTAL GHOSH
15 | 2023 | 1001-070216 | PRIYA SANYAL | KAMAL SANYAL
16 | 2023 | 1001-070210 | [NAME] | KABIR CHHETRI
17 | 2023 | 1001-070218 | RAJEEV KUMAR | KIRAN KUMAR
18 | 2023 | 1001-070219 | SAYAN GHOSH | SUKUMAR GHOSH
19 | 2023 | 1001-070220 | PRIYANKA SINGH | MANJEET SINGH
20 | 2023 | 1001-070221 | SUNIL KUMAR | KAPIL KUMAR
21 | 2024 | NOT REGISTERED | RAJEEV KUMAR | KIRAN KUMAR
22 | 2024 | 1001-070222 | RONIT DAS | RATUL DAS
23 | 2024 | 1001-070223 | PUJA BANERJEE | DIBAKAR BANERJEE
24 | 2023 | 1001-070215 | [NAME] | [NAME]
25 | 2024 | 1001-070225 | ANUJ AGARWAL | BISHAL AGARWAL
In column C I have registration numbers. Some are not registered and some with same registration number. I want to have the total count of registration numbers issued with duplicates once and excluding those not registered in C2.  [NAME] should work.
In column D I have student names. Some names have the same father's name. That is the same person. Some names are same but father's name is different, that means different person. some names have same father's name but have different registration number, that means different person. Now, I want to have the total count of students to whom unique registration numbers were issued with duplicates once and including those not registered in C3. Filter should work.
Please help. Thank you so much.
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L |  | (Please print)  PREPARED BY: | LAYNIE EAST
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
E-SCHEDULES CHECK LIST
For the period ending: 09/30/2000 |  | REVIEWED BY:
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | COMPLETED
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | COMPLETED
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 | VARIOUS ACCOUNTS | Reconciliation of Stockholders' Equity and | N/A
 |  | Investment in Subs
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: sh

Sweeney. Eddie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: NB-Cheque NEW

 | Posting Acct | 1-001
 | Date | Acct | Description | Debit | Credit | Net
 | 2008-12-01 00:00:00 | 3-001 | Retained earnings | 0 | 967.17 | -967.17
 | 2008-12-08 00:00:00 | 2-001 | National Bank - Visa | 0 | 10 | -10
 | 2008-12-08 00:00:00 | 3-501 | Income - StudyLink | 184.17 | 0 | 184.17
 | 2008-12-08 00:00:00 | 4-001 | Grocery | 0 | 30.26 | -30.26
 | 2008-12-10 00:00:00 | 4-002 | Genesis - Power | 0 | 35 | -35
 | 2008-12-12 00:00:00 | 4-001 | Grocery | 0 | 22.45 | -22.45
 | 2008-12-15 00:00:00 | 4-001 | Grocery | 0 | 13.23 | -13.23
 | 2008-12-16 00:00:00 | 2-001 | National Bank - Visa | 0 | 10 | -10
 | 2008-12-16 00:00:00 | 3-501 | Income - StudyLink | 0 | 184.17 | -184.17
 | 2008-12-17 00:00:00 | 4-001 | Grocery | 0 | 13.8 | -13.8
 | 2008-12-17 00:00:00 | 4-002 | Genesis - Power | 0 | 35 | -35
 | 2008-12-18 00:00:00 | 2-501 | Loan - J Mugot | 0 | 50 | -50
 | 2008-12-19 00:00:00 | 4-001 | Grocery | 0 | 13.43 | -13.43
 | 2008-12-22 00:00:00 | 4-001 | Grocery | 0 | 25.7 | -25.7
 | 2008-12-23 00:00:00 | 2-001 | National Bank - Visa | 0 | 10 | -10
 | 2008-12-23 00:00:00 | 3-501 | Income - StudyLink | 184.17 | 0 | 184.17
 | 2008-12-23 00:00:00 | 4-001 | Grocery | 0 | 12.49 | -12.49
 | 2008-12-24 00:00:00 | 4-002 | Genesis - Power | 0 | 35 | -35
 | 2008-12-24 00:00:00 | 4-003 | Petrol | 0 | 20 | -20
 | 2008-12-25 00:00:00 | 2-501 | Loan - J Mugot | 0 | 50 | -50
 | 2008-12-27 00:00:00 | 4-001 | Grocery | 0 | 6.89 | -6.89
 | Total |  |  | 368.34 | 1544.59 | -1176.25
Spreadsheet: holden_salisbury__12286__IPC
Sheet: Sheet1

Standard Daily Transactions:
Counterparties: |  | PAC
 |  | SRP
 |  | LDWP
Activities:
Buy and Sell standard products at Palo Verde, Four Corners, Mead, Pinnacle Peak, West Wing, [NAME], [NAME]
Buy and Sell shaped products at Palo Verde, Four Corners, Mead, Pinnacle Peak, West Wing, [NAME], [NAME]
Buy/Resales in and out of the above mentioned locations, standard and shaped products
Examples of shaped products would be:
Sell to SRP 20mw HE 23-24 at Palo Verde
Buy from Pacificorp 35mw HE 17-19 at Craig
Sell to Pacificorp 3mw HE 1-6 at Four Corners
Examples of standard and shaped product buy/resales would be:
Sell to Pacificorp 25mw HLH at Mona
Buy from Pacificorp 25mw HLH at Mead
Sell to SRP 55mw HE 1-6 at Palo Verde
Buy from SRP 55mw HE 1-6 at Mead
Sell 20mw HLH to Pacificorp at Pinnacle Peak
Buy 20mw HLH from Pacificorp at Four Corners
Spreadsheet: 136257d1326493003-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration2
Sheet: Schedule

Site 1 |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site 2 |  | 2012-01-01 00:00:00
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals |  | Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals
1 | Employee 1 | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Employee 6 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
1 | Employee 1 |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Employee 7 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Employee 8 |  |  |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
3 | Employee 3 | 13:00:00 | 19:00:00 | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
4 | Employee 4 | 00:01:00 | 13:00:00
5 | Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
Spreadsheet: 727360d1617865429-formula-to-get-employees-attendance-depending-on-3-conditions-labor
Sheet: Sheet1

Data
Epmolyee Name | Shift Name | Group | * | We have 4 shifts:Shift a,Shift b,Shift c,Shift d
[NAME] | Shift a | Group A | * | Every Employee belong to specific shift
ahmed | Shift b | Group A
hashim | Shift b | Group B
[NAME] | Shift a | Group A
mohamed | Shift b | Group B
[NAME] | Shift d | Group B
[NAME] | Shift c | Group B
 | This is Actual Attendance
Date | Shift a | Shift b | Shift c | Shift d
2021-03-31 00:00:00 | 1 | 1 | 2 | 3 |  | 1 refers to 1st shift
2021-04-01 00:00:00 | 1 | 2 | 3 | 3 |  | 2 refers to 2nd shift
2021-04-02 00:00:00 | 2 | 1 | 1 | 3 |  | 3 refers to 3rd shift
2021-04-03 00:00:00
2021-04-04 00:00:00
2021-04-05 00:00:00
2021-04-06 00:00:00
 | Report |  |  | Question
Condition 1 | 2021-03-31 00:00:00 |  |  |  | I need a formula to get employees attendance depending on 3 conditions
Condition 2 | 1
Condition 3 | Group A
Helper Formula |  | Shift b
Result
 | [NAME]
 | ahmed
 | [NAME]
Spreadsheet: 110223d1306948268-excel-2007-lookup-column-data-based-upon-row-column-matches-ec-usage-help3
Sheet: 2011 EC

2011 EC Usage
Set Name | Description | Account Number | Rep Name | Q1 | Q2 | Q3 | Q4 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 704178 | Office
 |  | 702244 | BG
 |  | 703105 | JH
 |  | 704188 | JM
 |  |  | JM Team
 |  | 707254 | BR
 |  | 702994 | JW
 |  | 702415 | TH
 |  |  | TH Team
 |  | 706168 | NK
 |  | 703967 | EH
 |  |  | EH Team
 |  | 702732 | PM
 |  | 704737 | RT
 |  |  | RT Team
 |  | 703521 | JB
 |  | 704734 | NC
 |  | 703850 | JL
 |  | 704560 | BZ
 |  | 704190 | JR
 |  |  | JR Team
112A | CCLS
 |  | 704178 | Office
 |  | 702244 | BG
 |  | 703105 | JH
 |  | 704188 | JM
 |  |  | JM Team
 |  | 707254 | BR
 |  | 702994 | JW
 |  | 702415 | TH
 |  |  | TH Team
 |  | 706168 | NK
 |  | 703967 | EH
 |  |  | EH Team
 |  | 702732 | PM
 |  | 704737 | RT
 |  |  | RT Team
 |  | 703521 | JB
 |  | 704734 | NC
 |  | 703850 | JL
 |  | 704560 | BZ
 |  | 704190 | JR
 |  |  | JR Team
113A | CCLD
Spreadsheet: 819357d1677449656-formula-to-calculate-downtime-loadout-log-template
Sheet: Sunday

Date | Division | Route | Hauler | Trailer Number | Scheduled Depart Time (Route Sheet) | NEW Estimated Load Completed Time | Actual Load Completion Time | Time Load Departed Dairy | Shift | Load Start Time | Load Finish Time | Load Duration | Case Count | Pallet Count | Trailer Temp | Reason For Downtime | Comments
 |  |  |  |  |  |  |  |  |  | 05:47:00 | 06:00:00
 |  |  |  |  |  |  |  |  |  | 06:00:00 | 06:15:00
 |  |  |  |  |  |  |  |  |  | 15:45:00 | 16:10:00
 |  |  |  |  |  |  |  |  |  | 16:15:00 | 16:30:00
Spreadsheet: 714397d1611212907-formula-to-calculate-available-stock-items-stock-control
Sheet: STOCK CONTROL

ITEM NO | ITEM NAME | MAKE | [NAME] | STOCK LOCATION | 2021 OPENING STOCK | STOCK BOOKED OUT | STOCK RETURNED | TOTAL STOCK ORDERED | TOTAL ORDERED STOCK RETURNED | AVAILABLE STOCK | 2021 TOTAL STOCK UTILISED
1 | Z320 HYDRAULIC FILTER | GUD | HYDRAULIC FILTER | STORE ROOM | 6
2 | P550148 HYDRAULIC FILTER | DONALDSON | HYDRAULIC FILTER | STORE ROOM | 4
3 | Z319 HYDRAULIC FILTER | GUD | HYDRAULIC FILTER | STORE ROOM | 2
4 | P552850 HYDRAULIC FILTER | DONALDSON | HYDRAULIC FILTER | STORE ROOM | 2
5 | P164378 HYDRAULIC FILTER | DONALDSON | HYDRAULIC FILTER | STORE ROOM | 2
6 | P165569 HYDRAULIC FILTER | DONALDSON | HYDRAULIC FILTER | STORE ROOM | 4
7 | Z247 DIESEL FILTER | GUD | DIESEL FILTER | STORE ROOM | 5
8 | Z288 DIESEL FILTER | GUD | DIESEL FILTER | STORE ROOM | 2
9 | G1034 DIESEL FILTER | GUD | DIESEL FILTER | STORE ROOM | 2
10 | Z431 DIESEL FILTER | GUD | DIESEL FILTER | STORE ROOM | 3
Spreadsheet: 835010d1688225601-intersperse-blank-cells-within-a-list-sample-48-
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9 |  | Works
Q | 1 | 1 |  |  |  |  |  |  |  |  | W
W | 1 | 1 | 1 | 1 | 1 | 1
E
R | 1 | 1 |  |  |  |  |  |  |  |  | R
Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9 |  | Fails
Q | 1 | 1
W |  |  |  |  | 1 | 1 |  |  |  |  | R
E
R | 1 | 1
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -20818 | -20000
2 | -19999 | -20000
3 | -21734 | -20609
4 | -20009 | -20000
5 | -20393 | -20000
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
2001-07-31 00:00:00 |  |  | 135803
2001-08-05 00:00:00
CBS Dollars
 |  |  | 82140
Spreadsheet: 876814d1723539342-function-similiar-to-sumproduct-an06-task-copy-tms
Sheet: needed function

Group 1
Group 2
Group 3
Group 4