tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25631__30R
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  030R
COMPANY NAME   [NAME]
ANALYSIS OF LONG-TERM DEBT
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
EXTENSION: 39690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 204611d1357585715-need-help-with-current-date-information-so-close-50k-tracking-1-
Sheet: 50k Challenge

Date:
50K Challenge Tracker
Month | PushUPs | Left |  | SitUPs
January |  |  |  |  |  |  | 31
February |  |  |  |  |  |  | 28
March |  |  |  |  |  |  | 31
April |  |  |  |  |  |  | 30
May |  |  |  |  |  |  | 31
June |  |  |  |  |  |  | 30
July |  |  |  |  |  |  | 31
August |  |  |  |  |  |  | 31
September |  |  |  |  |  |  | 30
October |  |  |  |  |  |  | 31
November |  |  |  |  |  |  | 30
December |  |  |  |  |  |  | 31
YTD Total
Pushups left til Goal:
Situps left til Goal:
 |  | Curr. Avg. | +/- [NAME]. | # for Curr. Goal
 | Push ups
 | Sit ups
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: Neil Robinson

Date Invoiced | Invoice Number | Invoice Value | Payment Due | Net Amount | CIS Amount | Paid Employee | Paid CIS | Overdue |  | Amounts Match? |  | Yes/No Options
2011-05-06 00:00:00 | 072/G | 570 |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 136416d1326627959-excel-2008-how-to-count-and-or-sum-consecutive-values-on-a-range-with-blank-data-in-the-middle-gtichauer_sumranges
Sheet: Consecutive

 |  |  |  | 1
1 | 2007-01-01 00:00:00 | 100 | W
2 | 2007-01-02 00:00:00 | 100 | W
3 | 2007-01-03 00:00:00 | 100 | W
4 | 2007-01-04 00:00:00 |  | 0
5 | 2007-01-05 00:00:00 |  | 0
6 | 2007-01-06 00:00:00 |  | 0
7 | 2007-01-07 00:00:00 |  | 0
1 | 2007-01-08 00:00:00 |  | 0
2 | 2007-01-09 00:00:00 |  | 0
3 | 2007-01-10 00:00:00 | 100 | W
4 | 2007-01-11 00:00:00 | 100 | W
5 | 2007-01-12 00:00:00 | 100 | W | 13 | 600
6 | 2007-01-13 00:00:00 | -50 | L
7 | 2007-01-14 00:00:00 | -50 | L
1 | 2007-01-15 00:00:00 | -50 | L
2 | 2007-01-16 00:00:00 | -50 | L
3 | 2007-01-17 00:00:00 | -50 | L
4 | 2007-01-18 00:00:00 |  | 0
5 | 2007-01-19 00:00:00 |  | 0
6 | 2007-01-20 00:00:00 |  | 0
7 | 2007-01-21 00:00:00 | -50 | L | 22 | -300
1 | 2007-01-22 00:00:00 | 200 | W
2 | 2007-01-23 00:00:00 | 200 | W
3 | 2007-01-24 00:00:00 | 200 | W | 25 | 600
4 | 2007-01-25 00:00:00 | -100 | L
5 | 2007-01-26 00:00:00 | -100 | L
6 | 2007-01-27 00:00:00 | -100 | L | 28 | -300
Spreadsheet: 839402d1691938708-nested-if-else-with-nearest-match-sample
Sheet: Sheet2

Basic | DA | Gross |  | Standard DA | Conveyance | HRA%
15424 | 2837 | 18261 |  | 2837 | 1600 | 0.4
14022 | 2837 | 16859
12747 | 2837 | 15584
11588 | 2837 | 14425
16423 | 2837 | 19260
Spreadsheet: f420a546-f943-4439-8c5f-51bdb9cc5643
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
GDU | Test | GDU | Gadolinium, 24 Hour, [NAME] | Gadolinium, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	No Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-0.4 mcg/specimen Reference values apply to all ages. | Thursday; 11 a.m. | 1 day | 7 days | 1 | 83018 |  |  |  |  | Rochester
GDU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
GDU | Order Question | [NAME] | Collection Duration |  | Plain Text
GDU | Order Question | VL82 | [NAME] |  | Plain Text
GDU | Result | 29252 | Gadolinium, 24 Hr, U | Gadolinium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 8201-6 | Gadolinium:MRat:24H:[NAME]:Qn:
GDU | Result | [NAME] | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
GDU | Result | VL82 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
GDU | Result | 29248 | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 8200-8 | Gadolinium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 28937d1223520112-formula-question-ifs-standings
Sheet: Sheet1

 |  |  |  | Game | Game | Game | Totals
 |  |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  |  | Points for Totals (3pts)
 |  |  |  |  |  |  |  | Total Points
 |  |  |  | Game | Game | Game | Totals
 |  |  |  |  |  |  |  | Games Won-(*2pts/game)
 |  |  |  |  |  |  |  | Points for Totals (3pts)
 |  |  |  |  |  |  |  | Total Points
Spreadsheet: 865128d1712187795-too-many-if-and-statements-production_cost_calculator_test
Sheet: Production costs

Description | Qty | Rate | UoM | Amount
Records Processing | 207541 | 5 | 1000
Append DPID | 207541 | 5 | 1000
[NAME] | 207541 | 37.8 | 1000 |  |  | Per Sheet | 2 images
Mail Machine Set up DLX | 1 | 20 | Unit |  |  | Per Run
Mail Processing - DLX | 207541 | 23 | 1000
Mail Machine Set up C5 | 0 | 20 | Unit |  |  | Per run
Mail processing - C5 | 0 | 50 | 1000
Mail Machine Set up C4 | 0 | 20 | Unit |  |  | Per Run | Includes [NAME] setup
Mail Processing - C4 | 0 | 80 | 1000
Lodgement with Australia Post | 1 | 20 | Unit |  |  | Per Run
Total ex GST and Postage
Spreadsheet: 6eb9291f-5d01-4150-bc69-14c3a60d232e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
BK 5, JD 3, JV 2, JL, LP , JS, SM | 5A1 | 28.22 | Klenová bučina bažanková na balvanitých svazích
BK 6, JD 4, JV, LP, JS | 5B1 | 10.34 | [NAME] jedlová [NAME] na svazích a plošinách
BK 5, JD 4 (SM, JV) 1, LP | 5F1 | 4.42 | Kamenitá svěží svahová jedlová bučina kapradinová
BK 4, JD 3, JV 2, JL 1, (JS, SM, LP) 1 | 5J3 | 4.28 | [NAME] na suťových svazích
[NAME], BK 5, SM 0,5, JV | 5S1 | 4.42 | Svěží jedlová bučina šťavelová na svazích a plošinách
 |  | 51.68000000000001
 | BK | 26.446 | 51.18646692215385
 | [NAME] | 17.643 | 34.1481825571943
 | KL | 6.5 | 12.58080749429025
 | JL | 0.428 | 0.8283977857778813
 | LP | 0.428 | 0.8283977857778813
 | SM | 0.221 | 0.4277474548058685
 |  | 51.66599999999999 | 100
5A1 | 28.22 | 54.60526315789473
5B1 | 10.34 | 20.0077399380805
5F1 | 4.42 | 8.552631578947368
5J3 | 4.28 | 8.281733746130032
5S1 | 4.42 | 8.552631578947368
 | 51.68000000000001 | 100
Spreadsheet: 197809d1354565542-problems-with-sumproduct-need-help-badly-sumproduct-example_v2
Sheet: Sheet1

 |  |  |  |  |  | Critical |  | 1
 |  | Test Name | Launch Priority | Status |  | High |  | 2 |  |  | Total Cases
 |  |  |  |  |  | Medium |  | 3 |  |  | Passed
 |  |  |  |  |  | Low |  | 4 |  |  | Quality Issues
 |  |  |  |  |  |  |  | 5 |  |  | Failed
 |  | A | Medium | Pending |  |  |  | Pending |  |  | Pending
 |  | B | Medium | 2
 |  |  |  |  |  |  |  |  |  | Priority | Critical | High | Medium | Low
 |  |  |  |  |  |  |  |  |  | Passed
 |  | C | High | 3 |  |  |  |  |  | [NAME]
 |  | D | Critical | 1 |  |  |  |  |  | Failed
 |  | E | High | Pending |  |  |  |  |  | Pending
 |  | F | High | 4
 |  | G | Critical | 3
 |  | H | High | Pending
 |  | I | Critical | Pending
 |  | J | High | 3
 |  | K | High | Pending
 |  | L | High | Pending
Spreadsheet: 92099d1291758553-function-to-show-if-a-new-error-record-exists-second-sheet
Sheet: D1

Material Number | Plant | Plant Sp Matl Status | Plant Sp Valid From | Purch. Grp. |  | New Error?
123 | 1 | Active | UNK | UNK
124 | 1 | Active | UNK | UNK
125 | 1 | Active | UNK | UNK
125 | 2 | Active | UNK | UNK
1261 | 1 | Active | UNK | UNK
125 | 3 | Active | UNK | UNK
Spreadsheet: 021b9b9f-c171-4f9a-98e9-d4ebee547988
Sheet: Sheet1

Council | Athletics - Able Bodied | Unnamed: 2 | Athletics - Disability | Unnamed: 4 | Basketball | Unnamed: 6 | Badminton | Unnamed: 8 | Girls Hockey | Unnamed: 10 | Boys Hockey | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Position | Points | Position | Points | Position | Points | Position | Points | Position | Points | Position | Points
Babergh | 5 | 3 |  | 0 |  | 0 | 7 | 1 | 4 | 4 | 5 | 3
Forest Heath | 7 | 1 |  | 0 | 1 | 7 | 6 | 2 | 5 | 3 | 2 | 6
Ipswich | 6 | 2 | 1 | 7 | 3 | 5 | 2 | 6 |  | 0 | 5 | 3
Mid Suffolk | 3 | 5 |  | 0 |  | 0 | 4 | 4 | 2 | 6 | 1 | 7
St Edmundsbury | 2 | 6 | 3 | 5 | 2 | 6 | 5 | 3 | 3 | 5 | 3 | 5
[NAME] | 4 | 4 | 4 | 4 |  | 0 | 3 | 5 |  | 0 |  | 0
Waveney | 1 | 7 | 2 | 6 | 4 | 4 | 1 | 7 | 1 | 7 | 3 | 5
Total |  | 28 |  | 22 |  | 22 |  | 28 |  | 25 |  | 29
 |  |  |  | 6 |  | 6 |  |  |  | 3 |  | -1
Council | Mixed Tag Rugby |  | Table Tennis |  | Tennis |  | Late Declarations |  |  |  | Total | Position
 | Position | Points | Position | Points | Position | Points
Babergh | 5 | 3 | 3 | 5 | 2 | 6 |  | 0 |  |  | 25 | 5th
Forest Heath | 2 | 6 | 5 | 3 |  | 0 |  | 0 |  |  | 28 | 4th
Ipswich |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 23 | 6th
Mid Suffolk | 1 | 7 | 2 | 6 | 4 | 4 |  | 0 |  |  | 39 | 3rd
St Edmundsbury | 3 | 5 | 1 | 7 | 3 | 5 |  | 0 |  |  | 47 | 2nd
[NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 13 | 7th
Waveney | 4 | 4 | 4 | 4 | 1 | 7 |  | 0 |  |  | 51 | 1st
Total |  | 25 |  | 25 |  | 22 |  | 0 |  |  | 226
 |  | 3 |  | 3 |  | 6 |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  | Check Total |  | 226
 |  |  |  |  |  |  |  |  |  |  |  |  | 252 | 252
Fair Play | Babergh
Spreadsheet: 471800d1469196683-shading-cell-based-on-number-of-other-cells-with-values-example-1
Sheet: Individual Intakes

GROUP 1
[NAME]:  22%
Number | Day 1 | 2016-07-11 00:00:00 | Day 2 |  | Day 3 |  | Day 4 |  | Day 5 |  | Day 6 |  | Day 7 |  | Day 8 |  | Day 9 |  | Day 10 |  | Day 11 |  | Day 12 |  | Day 13 |  | Day 14 |  | Day 15 |  | Day 16 |  | Day 17 |  | Day 18
 | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg)
 | 0.1 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.09 | 0.1 | 0.1
 |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
GROUP 2
[NAME]: 22%
Number | Day 1 | 2016-07-14 00:00:00 | Day 2 |  | Day 3 |  | Day 4 |  | Day 5 |  | Day 6 |  | Day 7 |  | Day 8 |  | Day 9 |  | Day 10 |  | Day 11 |  | Day 12 |  | Day 13 |  | Day 14 |  | Day 15 |  | Day 16 |  | Day 17 |  | Day 18
 | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Refused(kg) | Offered(kg) | Refused(kg) | Offered(kg) | Refused(kg)
 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
Spreadsheet: 883632d1732278165-calculate-average-times-something-is-entered-per-date-urgent-case-tracking-2024
Sheet: Sheet1

Case Number | Date Entered | 2024-11-13 00:00:00 | 2024-11-18 00:00:00
68498 | 2024-11-13 00:00:00
68554 | 2024-11-14 00:00:00
68581 | 2024-11-15 00:00:00
68550 | 2024-11-15 00:00:00
68612 | 2024-11-18 00:00:00
68618 | 2024-11-18 00:00:00
68629 | 2024-11-18 00:00:00
68641 | 2024-11-19 00:00:00
68647 | 2024-11-19 00:00:00
68651 | 2024-11-19 00:00:00
68652 | 2024-11-19 00:00:00
68695 | 2024-11-20 00:00:00
68710 | 2024-11-20 00:00:00
68711 | 2024-11-20 00:00:00
68725 | 2024-11-21 00:00:00
Spreadsheet: 672536d1586899636-subtract-until-0-then-move-to-next-cell-to-subtract-until-0-sample-excel
Sheet: Sheet1

 | Units |  | Each product has 41 units
Person 1 | 25 |  | Product 1
Person 2 | 10 |  | Product 2
Person 3 | 12 |  | Product 3
Person 4 | 15 |  | Product 4
Person 5 | 20 |  | Product 5
Person 6 | 21
Person 7 | 18
Person 8 | 17
Person 9 | 22
Person 10 | 16
Example of Output
Person 1 | Product 1 | 25
Person 2 | Product 1 | 10
Person 3 | Product 1 | 6
 | Product 2 | 6
Spreadsheet: 2585d31f-cb75-4ebd-8111-59624db35525
Sheet: Manufacturing

 | MINING
 | Name of Co-Operative | File no. | Product Classification
1 | Nceduluntu Brickmaking co-op | 1 | P1001
2 | Hlanganani Bricks & Fence Multipurpose | 2 | P1001
3 | Old Payne Community Co-op | 3 | P1001
4 | Young Lion's Co-operative | 4 | P1001
5 | Bright Idea Brickmaking Co-op | 10 | P1001
6 | Gogozayo Brickmaking Co-op | 30 | P1001
7 | Centuli Brickmaking Co-op | 61 | P1001
8 | Masincedane Brickmaking | 74 | P1001
9 | [NAME] | 78 | P1001
10 | New Generation Women in Brickmaking &Mining | 87 | P1001
11 | [NAME] | 89 | P1001
12 | Nombembe Women's Agricultural & Manufacturing | 121 | P1001
13 | Qhubeka Concrete Making Co-operative | 126 | P1001
14 | Masilakhe Lelelthu | 133 | P1001
 | SEWING
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] and Weaving Project | 54 | P1090
2 | Masithembane Sewing & Multipurpose | 64 | P1090
3 | Makukhanye Sewing Project | 72 | P1090
4 | Sondelelanani Sewing Co-operative | 118 | P1090
5 | Vukasizwe Sewing Co-operative | 149 | P1090
6 | Zalu Hill Sewing Co-operative | 155 | P1090
7 | Masilakhe Sewing & Weaving Co-operative | 189 | P1090
8 | Nqwathi Sewing Co-operative | 195 | P1090
9 | At Last  Sewing Co-operative | 200 | P1090
 | WEAVING
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] | 161 | P1090
 | BEADING
 | Name of Co-Operative | File no. | Product Classification
1 | Ndukudeni Sewing & Beading | 159 | P2120
 | CRAFTS
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] | 99 | P1130
 | WATER BOTTLING
 | Name of Co-Operative | File no. | Product Classification
1 | Singamanzimande Water Bottling Project | 60 | P2000
 | FURNITURE
 | Name of Co-Operative | File no. | Product Classification
1 | Busy Bees Furniture Manufactures | 100 | P2020
 | UPHOLSTERY
 | Name of Co-Operative | File no. | Product Classification
2 | Fast Move Upholstery | 153 | P2100
 | LANDSCAPING
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] Landscaping | 65 | P1110
 | MILLING
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] | 127 | P2060
 | METAL WORKS
 | Name of Co-Operative | File no. | Product Classification
1 | Masilinge Welding Primary Co-operative | 144 | P2090
 | CONSTRUCTION
 | Name of Co-Operative | File no. | Product Classification
1 | Vulikhaya Youth Construction Co-op | 19 | P2110
2 | Nojwentu Construction Co-operative | 157 | P2110
3 | Bomi Building Co-operative | 198 | P2110
Spreadsheet: 794355d1662004474-two-column-list-descending-dates-and-ids-find-next-date-in-list-matching-row-id-difference-next-data-row-by-id-rows-sorted-by-date-desc-
Sheet: Transform Step

Employee ID | Date/Time Opened | YOUR MAGIC FORMULA |  | Employee ID | Date/Time Opened | YOUR MAGIC FORMULA
18 | 2022-08-27 12:14:00 | 2022-08-29 00:00:00 |  | 18 | 2022-08-27 12:14:00
21 | 2022-08-27 12:14:00 | NA |  | 21 | 2022-08-27 12:14:00 |  |  |  |  |  | Employee ID | Date/Time Opened
4 | 2022-08-27 12:13:00 | NA |  | 4 | 2022-08-27 12:13:00 |  |  |  |  |  | 1 | 44800.50972222222
5 | 2022-08-27 12:13:00 | NA |  | 5 | 2022-08-27 12:13:00 |  |  |  |  |  | 3 | 44800.50972222222
6 | 2022-08-27 12:13:00 | NA |  | 6 | 2022-08-27 12:13:00 |  |  |  |  |  | 4 | 44800.50902777778
7 | 2022-08-27 12:13:00 | NA |  | 7 | 2022-08-27 12:13:00 |  |  |  |  |  | 5 | 44800.50902777778
9 | 2022-08-27 12:13:00 | 2022-08-28 00:00:00 |  | 9 | 2022-08-27 12:13:00 |  |  |  |  |  | 6 | 44800.50902777778
9 | 2022-08-28 00:00:00 | NA |  | 9 | 2022-08-28 00:00:00 |  |  |  |  |  | 7 | 44800.50902777778
11 | 2022-08-28 00:00:00 | NA |  | 11 | 2022-08-28 00:00:00 |  |  |  |  |  | 9 | 44800.50902777778
12 | 2022-08-28 00:00:00 | NA |  | 12 | 2022-08-28 00:00:00 |  |  |  |  |  | 9 | 44801
13 | 2022-08-28 00:00:00 | NA |  | 13 | 2022-08-28 00:00:00 |  |  |  |  |  | 11 | 44801
14 | 2022-08-27 12:13:00 | 2022-08-28 00:00:00 |  | 14 | 2022-08-27 12:13:00 |  |  |  |  |  | 12 | 44801
14 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 |  | 14 | 2022-08-28 00:00:00 |  |  |  |  |  | 13 | 44801
14 | 2022-08-29 00:00:00 | NA |  | 14 | 2022-08-29 00:00:00 |  |  |  |  |  | 14 | 44800.50902777778
16 | 2022-08-29 00:00:00 | NA |  | 16 | 2022-08-29 00:00:00 |  |  |  |  |  | 14 | 44801
17 | 2022-08-29 00:00:00 | NA |  | 17 | 2022-08-29 00:00:00 |  |  |  |  |  | 14 | 44802
19 | 2022-08-29 00:00:00 | NA |  | 19 | 2022-08-29 00:00:00 |  |  |  |  |  | 16 | 44802
18 | 2022-08-29 00:00:00 | NA |  | 18 | 2022-08-29 00:00:00 |  |  |  |  |  | 17 | 44802
 |  |  |  |  |  |  |  |  |  |  | 19 | 44802
 |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 117693d1312971656-finding-a-ratio-by-shift-variation_calc
Sheet: Variation Calc

3 Shifts
Start of Week | Test Time | Time Diffs | Total Week | Shifts | % Done | % To Go | [NAME]
 |  |  | 5
2 shifts
Start of Week | Test Time | Time Diffs | Total Week | Shifts | % Done | % To Go | [NAME]
 |  |  | 5
Line | 109-1 | 109-2 | 109-3 | 109-4 |  | 110-1 | 110-2 | 110-3 | 110-4
2 Week Avg.
[NAME]
 | 8745 | 7517 | 6477 | 4570 |  | 7597 | 10615 | 8870 | 10406
Friday 10PM - Unmet
1 OT Shift
2 OT Shifts
3 OT Shifts
Spreadsheet: 56222d1256310290-using-if-and-round-in-same-calculation-example
Sheet: Sheet1

Cost | 10% | Customer Cost Each | Qty | Total Cost
800 | 80 | 880 | 1 | 880
10 | 1 | 11 | 2 | 22
0.05 | 0.005000000000000001 | 0.05500000000000001 | 10 | 0.55
Spreadsheet: a8b5f1fc-dfa5-4ee1-bbee-659a94e2d288
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
[NAME] |  | 2014 | 740 | 4977 | 1656 | 1854 | 3501 | 1473 | 339 | 6805 | 1114 | 1337 | 1393 | 27203
Micra C+C |  | 93 | 21 | 428 | 431 | 458 | 310 | 236 | 79 | 648 | 132 | 95 | 86 | 3017
NOTE |  | 0 | 271 | 2182 | 1198 | 1126 | 1221 | 1337 | 447 | 4210 | 1329 | 1237 | 1057 | 15615
Almera |  | 852 | 317 | 1646 | 271 | 230 | 475 | 190 | 65 | 69 | 2 | 6 | 3 | 4126
[NAME] |  | 87 | 26 | 83 | 10 | 9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 218
Primera |  | 318 | 117 | 910 | 248 | 369 | 468 | 395 | 42 | 578 | 190 | 196 | 65 | 3896
X-Trail |  | 628 | 154 | 2045 | 897 | 787 | 918 | 501 | 202 | 2476 | 377 | 391 | 338 | 9714
Terrano |  | 4 | 8 | 9 | 6 | 4 | 9 | 13 | 5 | 1 | 4 | 2 | 2 | 67
Patrol |  | 26 | 8 | 32 | 7 | 10 | 13 | 7 | 7 | 25 | 10 | 12 | 5 | 162
Pathfinder |  | 130 | 58 | 490 | 306 | 182 | 223 | 224 | 113 | 602 | 188 | 255 | 201 | 2972
[NAME] |  | 95 | 15 | 188 | 46 | 73 | 74 | 36 | 11 | 160 | 26 | 42 | 25 | 791
350Z Coupe |  | 77 | 5 | 120 | 109 | 98 | 93 | 48 | 21 | 249 | 75 | 54 | 58 | 1007
350Z Roadster |  | 17 | 2 | 74 | 19 | 35 | 29 | 33 | 12 | 57 | 24 | 7 | 6 | 315
NMGB Total Car |  | 4341 | 1743 | 13191 | 5204 | 5235 | 7337 | 4493 | 1343 | 15880 | 3471 | 3654 | 3239 | 69103
Cabstar |  | 92 | 25 | 190 | 48 | 105 | 93 | 79 | 44 | 152 | 61 | 64 | 62 | 1018
[NAME] |  | 23 | 9 | 59 | 18 | 26 | 27 | 15 | 5 | 50 | 35 | 37 | 16 | 320
Pick Up |  | 21 | 16 | 23 | 29 | 28 | 18 | 8 | 5 | 31 | 15 | 16 | 9 | 219
[NAME] |  | 682 | 170 | 2377 | 956 | 1098 | 1227 | 991 | 396 | 2005 | 868 | 866 | 750 | 12386
Primastar |  | 216 | 131 | 482 | 182 | 209 | 270 | 206 | 140 | 453 | 149 | 237 | 147 | 2828
Interstar |  | 126 | 8 | 55 | 26 | 14 | 17 | 19 | 14 | 35 | 15 | 17 | 16 | 364
Kubistar |  | 32 | 32 | 77 | 52 | 47 | 40 | 58 | 20 | 75 | 67 | 47 | 33 | 580
NMGB Total LCV |  | 1192 | 390 | 3263 | 1311 | 1527 | 1692 | 1376 | 624 | 2801 | 1210 | 1284 | 1033 | 17715
NMGB Total All |  | 5533 | 2133 | 13191 | 6515 | 6762 | 9029 | 5869 | 1967 | 18681 | 4681 | 4918 | 3239 | 86818