tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: danny_mccarty__4650__GaddMerit
Sheet: Sheet1

 |  |  | LastName | FirstName | Status | HIRE DATE |  | Supervisor | DEPARTMENT | Job Group Description | Pay Scale | Previous Salary | Date of last Salary Inc | Salary [NAME] % | Current Annual Salary |  | [NAME] (3.75%) | Proposed [NAME] (3.75%) | New Annual Salary | [NAME] | [NAME] Proposed Merit/Lump |  | MD Adjusted |  | Final
GISID | Personnel No | HR Rep |  |  |  |  | Division |  |  |  |  |  |  |  |  | Comp Plus Flag |  |  |  |  | Merit | [NAME] | Merit | [NAME] | Merit | [NAME]
90010379 | 505464 | Fagan | Hyatt | [NAME] | FRE | 1984-07-01 00:00:00 | ETSCOMMEREXE | Gadd, [NAME] | ETS COMM Asset Development | Director | ML03 | 103008 | 2001-01-31 00:00:00 | 3.49 | 106608 |  |  | 3997.8
90137748 | 564214 | Fagan | Millar | [NAME] | FRE | 1997-04-14 00:00:00 | ETSCOMMEREXE | Gadd, [NAME] | ETS COMM Asset Development | Director | ML03 | 101481 | 2001-01-31 00:00:00 | 3.75 | 105287 |  |  | 3948.2625
90007110 | 408511 | Fagan | Wadle | [NAME] | FRN | 1993-02-22 00:00:00 | ETSCOMMEREXE | Gadd, [NAME] | ETS COMM Asset Development | Senior Assistant | SAS3 | 56689 | 2001-05-17 00:00:00 | -20.62 | 45000 |  |  | 1687.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pool $s | 9633.5625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proposed Merit & Lump Sum
Spreadsheet: 871562d1718015244-filter-unique-value-and-sort-from-filtered-data-in-multiple-sheet-consolidated-ledger-report-2024-25
Sheet: New Data CR List

Sl. No. | Name | Amtt. DR | Amtt. CR | Balance | Ledger
 | M/s Apex Sanitary Ware
 | M/s Asian Granitoindia Ltd
 | M/s Competent Medical System (India)
 | M/s M.S.Product & Services
 | M/s Narmit Distributors Pvt. Ltd.
 | M/s Prabha Marbles
 | M/s R A Enterprises
 | M/s Redbeam Indutries India Pvt. Ltd
 | M/s Rosette Interior Designers ([NAME])
 | M/s SYFA Traders
Spreadsheet: 151408d1334900694-excel-2007-drop-down-list-problem-time-sheet
Sheet: 22.04

 | Job No: | Duties
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | X
 |  | -
 |  | -
 |  | -
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1002

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: 02f83615-f3e3-4daa-9869-484bb50bf82f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
OHIO DEPARTMENT  OF EDUCATION
PROJECT BUDGET
 |  |  |  |  |  |  |  |  | FOR ODE USE ONLY
1.  GENERAL INFORMATION |  |  |  |  |  |  |  |  | APPROVED
A.  SCHOOL DISTRICT/AGENCY: |  |  |  |  |  | [NAME]: |  |  | Date | By
C.  PROJECT NUMBER: |  |  |  |  |  | D.  C.F.D.A. NO.:
E.  U.S.A.S. No.: |  |  |  | [NAME] PROGRAM OFFICE:
[NAME] ONE:
[NAME] ONE:
I.  PROPOSED USE OF FUNDS (Complete for Carryover Budget purposes only):
2.  BUDGET
FUNCTION |  |  |  |  |  |  |  |  | FACILITITES/
 |  | SUPPORT | ADMINISTRATIVE | FISCAL/BUSINESS | OPERATIONS & | PUPIL | SUPPORT/FOOD | NONPUBLIC | CONSTRUCTION
 | INSTRUCTION | SERVICES | SERVICES | SERVICES | MAINTENANCE | TRANSPORTATION | SERVICES | SCHOOLS | SERVICES | TOTAL
 | 1000 | 2100-2200 | 2400 | 2500-2600 | 2700 | 2800 | 2900-3100 | 3200 | 5000
OBJECT | A | B | C | D | E | F | G | H | I | J
SALARIES |  |  |  |  |  |  |  |  |  | 0
100
[NAME] |  |  |  |  |  |  |  |  |  | 0
FRINGE
BENEFITS
200
PURCHASED |  |  |  |  |  |  |  |  |  | 0
SERVICES
400
SUPPLIES |  |  |  |  |  |  |  |  |  | 0
500
CAPITAL |  |  |  |  |  |  |  |  |  | 0
OUTLAY
600
CAPITAL |  |  |  |  |  |  |  |  |  | 0
OUTLAY
(REPLACEMENT)
700
OTHER |  |  |  |  |  |  |  |  |  | 0
800
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3.  PROGRAM APPROVAL: |  |  |  |  |  | 4.  FISCAL APPROVAL:
Signature of Superintendent/CEO |  |  |  | Date |  | Signature of Treasurer/CFO |  |  | Date
Name of Superintendent/CEO (Typed) |  |  |  |  |  | Name of Treasurer/CFO (Typed)
District/Agency Address: |  |  |  |  |  | Address (if different)
Telephone |  |  | Ext. |  |  | Telephone |  |  | Ext.
 |  |  |  |  |  | FAX Number
 |  |  |  |  |  | E-mail:
Spreadsheet: 752921d1635101323-compare-two-list-and-sum-values-based-on-all-matching-values-and-by-month-data
Sheet: Data

Month | Assignment | Surname | Element Name | Sum of NI
1 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 251.88
1 | 11099678 | Sara | Basic Pay | 1194.32
1 | 11099678 | Sara | Clinical Award | 65.09
1 | 11099678 | Sara | [NAME] | 23.33
1 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 11.94
2 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 251.88
2 | 11099678 | Sara | Basic Pay | 1194.32
2 | 11099678 | Sara | Clinical Award | 65.09
2 | 11099678 | Sara | [NAME] | 30
2 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 15
3 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 251.88
3 | 11099678 | Sara | Basic Pay | 1194.32
3 | 11099678 | Sara | Clinical Award | 65.09
3 | 11099678 | Sara | [NAME] | 90
3 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 11.94
4 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 251.88
4 | 11099678 | Sara | Basic Pay | 1194.32
4 | 11099678 | Sara | Clinical Award | 65.09
4 | 11099678 | Sara | [NAME] | 23.33
4 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 11.94
5 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 251.88
5 | 11099678 | Sara | Basic Pay | 1194.32
5 | 11099678 | Sara | Clinical Award | 65.09
5 | 11099678 | Sara | [NAME] | 23.33
5 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 11.94
6 | 11099678 | Sara | Add Prog Activity NP Additional Prog A NP | 261.5
6 | 11099678 | Sara | Add Prog Activity NP Arrs | 36.15
6 | 11099678 | Sara | Basic Pay | 1241.82
6 | 11099678 | Sara | Basic Pay Arrs | 180.8
6 | 11099678 | Sara | Clinical Award | 65.7
6 | 11099678 | Sara | [NAME] | 23.55
6 | 11099678 | Sara | On Call Availability Supp Arrs | 1.8
6 | 11099678 | Sara | On Call Availability Supp On Call Cat B Low Fr | 12.42
Spreadsheet: 818101d1676586463-if-first-letter-in-name-starts-with-a-then-put-an-abc-if-first-letter-in-name-starts-with-a-then-put-an-abc
Sheet: Sheet1

Alpha
Bravo
[NAME]
Delta
Echo
Foxtrot
Golf
Hotel
India
[NAME]
Kilo
Lima
[NAME]
November
[NAME]
Papa
Quebec
Romeo
Sierra
Tango
Uniform
Victor
Whiskey
Xray
Yankee
Zulu
Spreadsheet: darrell_schoolcraft__7236__saledoc01_10TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power LLC
Deal Date: |  |  | 2002-01-10 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/11/02 |  |  | FAX Number:
Total Quantity |  |  | 15199 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.07
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/11/02 | 2002-01-11 00:00:00 | 15199 |  | 15199 |  | 15199
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 15199 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 135707d1326198609-populate-a-formula-to-update-leave-days-attendance-tracker
Sheet: Attendance Tracker

 | Data |  |  |  |  | Desired Result
 | ID | [NAME] | Leave End | Leave |  | ID | 2012-01-01 00:00:00
 | 111 | 2012-01-01 00:00:00 | 2012-01-06 00:00:00 | VL |  | 111 | VL | VL | VL | VL | VL | VL |  |  |  | SL | SL | SL | SL
 | 121 | 2012-01-02 00:00:00 | 2012-01-10 00:00:00 | EL |  | 121 |  | EL | EL | EL | EL | EL | EL | EL | EL | EL
 | 111 | 2012-01-10 00:00:00 | 2012-01-13 00:00:00 | SL
 |  |  |  |  |  | Populate a formula in H5:AL6 with use of Data and result will come as appears in Desired Result area
Spreadsheet: 209662d1359151093-get-cell-contents-example
Sheet: Sheet1

MLU2 | 412 | 108
 |  | 1
STP2 | 101 | 10
STP2 | 101 | 16
MLU2 | 412 | 108
STP2 | 101 | 1
STP2 | 101 | 10
STP2 | 101 | 16
Spreadsheet: baad21e8-f8a9-4be3-80c8-52c1b01db9b1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Daywind Rec | 614187141922 | Stamps Quartet & Imperials | Gospel Side Of Elvis, The | 2004-10-26 | Compact Disc | [NAME] | 16.99 | N | To Be Retired
Spreadsheet: 5fd672bb-43f8-4368-b6e0-3308d0b14fc7
Sheet: Income Consumption Curve

a = |  | b = |  | Px = |  | Py =
increment | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Selected budget lines
Income (I) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y-intercept |  | x-intercept
0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Spreadsheet: daren_farmer__6011__EI337reveff061500
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/19/00
Subject:  Revised Availabilities Effective 6/15/00 - 6/16/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-15 00:00:00 | EI 337 | 67 | 0.152 |  |  | 0
1st of month DBQ = 0/d
Spreadsheet: 291431d1390293767-filling-down-formulas-simple-example
Sheet: Sheet1

Name | Hours worked | Hourly rate | Sum of Pay
[NAME] | 28 | 29 | 812
[NAME] | 19 | 20 | 380
[NAME] | 26 | 25 | 650
[NAME] | 22 | 20 | 440
Charlotte | 21 | 29 | 609
[NAME] | 24 | 25 | 600
Christine | 15 | 25 | 375
[NAME] | 29 | 25 | 725
[NAME] | 21 | 29 | 609
[NAME] | 30 | 20 | 600
[NAME] | 25 | 29 | 725
[NAME] | 30 | 25 | 750
[NAME] | 20 | 25 | 500
[NAME] | 27 | 20 | 540
Martin | 18 | 29 | 522
[NAME] | 18 | 20 | 360
[NAME] | 19 | 25 | 475
[NAME] | 27 | 25 | 675
Philomena | 18 | 25 | 450
Terrance | 29 | 20 | 580
Grand Total |  |  | 228340
Spreadsheet: 843167d1695113796-compare-lease-vs-buy-excvr
Sheet: Blad1

 |  | 45k-50k
annual interest |  | 0.0577
 |  | leaseoption 2 |  | buy option
 | month
 | 0 |  |  | -37623.72500000001
 | 1 | -762.94 |  | -278.3333333333334
 | 2 | -762.94 |  | -278.3333333333334
 | 3 | -762.94 |  | -278.3333333333334
 | 4 | -762.94 |  | -278.3333333333334
 | 5 | -762.94 |  | -278.3333333333334
 | 6 | -762.94 |  | -278.3333333333334
 | 7 | -762.94 |  | -278.3333333333334
 | 8 | -762.94 |  | -278.3333333333334
 | 9 | -762.94 |  | -278.3333333333334
 | 10 | -762.94 |  | -278.3333333333334
 | 11 | -762.94 |  | -278.3333333333334
 | 12 | -762.94 |  | -278.3333333333334
 | 13 | -762.94 |  | -335.6833333333333
 | 14 | -762.94 |  | -335.6833333333333
 | 15 | -762.94 |  | -335.6833333333333
 | 16 | -762.94 |  | -335.6833333333333
 | 17 | -762.94 |  | -335.6833333333333
 | 18 | -762.94 |  | -335.6833333333333
 | 19 | -762.94 |  | -335.6833333333333
 | 20 | -762.94 |  | -335.6833333333333
 | 21 | -762.94 |  | -335.6833333333333
 | 22 | -762.94 |  | -335.6833333333333
 | 23 | -762.94 |  | -335.6833333333333
 | 24 | -762.94 |  | -335.6833333333333
 | 25 | -762.94 |  | -418.2538333333333
 | 26 | -762.94 |  | -418.2538333333333
 | 27 | -762.94 |  | -418.2538333333333
 | 28 | -762.94 |  | -418.2538333333333
 | 29 | -762.94 |  | -418.2538333333333
 | 30 | -762.94 |  | -418.2538333333333
 | 31 | -762.94 |  | -418.2538333333333
 | 32 | -762.94 |  | -418.2538333333333
 | 33 | -762.94 |  | -418.2538333333333
 | 34 | -762.94 |  | -418.2538333333333
 | 35 | -762.94 |  | -418.2538333333333
 | 36 | -762.94 |  | -418.2538333333333
 | 37 | -762.94 |  | -430.8014483333334
 | 38 | -762.94 |  | -430.8014483333334
 | 39 | -762.94 |  | -430.8014483333334
 | 40 | -762.94 |  | -430.8014483333334
 | 41 | -762.94 |  | -430.8014483333334
 | 42 | -762.94 |  | -430.8014483333334
 | 43 | -762.94 |  | -430.8014483333334
 | 44 | -762.94 |  | -430.8014483333334
 | 45 | -762.94 |  | -430.8014483333334
 | 46 | -762.94 |  | -430.8014483333334
 | 47 | -762.94 |  | -430.8014483333334
 | 48 | -762.94 |  | -430.8014483333334
 | 49 | -762.94 |  | -443.7254917833332
 | 50 | -762.94 |  | -443.7254917833332
 | 51 | -762.94 |  | -443.7254917833332
 | 52 | -762.94 |  | -443.7254917833332
 | 53 | -762.94 |  | -443.7254917833332
 | 54 | -762.94 |  | -443.7254917833332
 | 55 | -762.94 |  | -443.7254917833332
 | 56 | -762.94 |  | -443.7254917833332
 | 57 | -762.94 |  | -443.7254917833332
 | 58 | -762.94 |  | -443.7254917833332
 | 59 | -762.94 |  | -443.7254917833332
 | 60 | -762.94 |  | -443.7254917833332
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF LONG-TERM DEBT
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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: 808390d1670437572-count-fields-based-on-month-ortho-ed-and-discharge-new
Sheet: Feb

Description | BMI > 40 | Total ASA 3 | Total ASA 4 | ALOS | Median | Totals
Total Knee - 1
Total Hip - 2
Total Shoulder - 3
Spine - 4
Bilat. Total Knee - 5
Bilat. Total Hip - 6
Spreadsheet: 884128d1733146604-distirbution-of-target-budget-as-per-the-existing-pattern-distribution-as-per-target-budget-1-
Sheet: Sheet1

CURRENT DISTRIBUTION |  |  |  |  |  |  |  |  |  |  |  |  | REQUIRED DISTRIBUTION CASE1 |  |  |  |  |  |  |  |  |  | REQUIRED DISTRIBUTION CASE2
GROUP | Start | Finish | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 |  | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 |  | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00
A | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
A | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1
A | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
B | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-01-01 00:00:00 | 2024-06-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
C | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-01-01 00:00:00 | 2024-06-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  | Current Total |  |  |  |  |  |  |  |  |  | Target |  |  |  |  |  |  |  |  |  | Target | AVERAGE/P
A |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  | 12
B |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  | 20
C |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  | 20
Spreadsheet: 160543d1339101732-repeating-sequential-pattern-codes_sizeclass
Sheet: Codes_SizeClass

Fish_Code | Size_class (cm)
1 | <5
1 | 5-10
1 | 10-15
1 | 10-15
1 | 15-20
1 | 15-20
1 | 20-25
1 | 25-30
1 | 25-30
1 | 30-35
1 | 35-40
1 | 40-45
1 | 45-50
1 | 50+
2 | <5
2 | 5-10
2 | 10-15
2 | 10-15
2 | 15-20
2 | 15-20
2 | 20-25
2 | 25-30
2 | 25-30
2 | 30-35
2 | 35-40
2 | 40-45
2 | 45-50
2 | 50+
Spreadsheet: 767637d1644567757-calculating-time-difference-of-warehouse-picking-rate-using-line-data-sample-data-7-ans
Sheet: Data

Csgno | Pick Start Date | Start Pick Time | Pack End Date | Pack End Time | Packer | Total Time Taken | Total per packer
4071990 | 2022-02-08 00:00:00 | 06:47:21 | 2022-02-08 00:00:00 | 08:04:35 | BBE
4071995 | 2022-02-08 00:00:00 | 06:47:23 | 2022-02-08 00:00:00 | 07:29:45 | BBE
4072040 | 2022-02-08 00:00:00 | 06:47:22 | 2022-02-08 00:00:00 | 07:40:25 | BBE
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072470 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:11:05 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072487 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:27:39 | CGR
4072499 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:29:02 | CGR
 |  | NOTE: For starting time and end time, ignore number of seconds in formulations and please just consider hours and minutes
 |  | BBE has packed 3 lines. He started packing at 6.47 and finished the last line at 8.04. Therefore he took 1 hour and 17 mins to complete all those lines
 |  | ACU packed 3 lines, started at 9 and finished at 10.45, so took 1 hr 45 minutes to pack all 3 lines, but he did this over 2 different days, so each day requires it’s own separate data
 |  | CGR packed 5 lines, but the first 2 were started at 19.47 and finished at 19.55, so took 8 minutes, but the other 5 started at 11.10 and finished at 11.29 and so took 19 minutes. Therefore he packed a total of 7 lines and took a total 27 minutes to pack them
 | Table Required to show answers, ideally placed into a separate tab. Could this be done in a Pivot table so it was automated??
 | Packer | Date | Number of Lines Picked | Total Time Taken
 | BBE | 2022-02-08 00:00:00 | 3 | 1:17:00
 | ACU | 2022-02-08 00:00:00 | 2 | 1:45:00
 | ACU | 2022-02-09 00:00:00 | 2 | 1:45:00
 | CGR | 2022-02-08 00:00:00 | 7 | 0:27:00
Spreadsheet: 1b6cd4a3-5ac2-4b9a-8aee-06d46488c4f0
Sheet: Table 5.4

Monthly Statistical Bulletin
5.4 Home loan affordability
Quarter | 2009-10 | 2010-11 | 2011-12 | 2012-13 | 2013-14
Average size of new home loan (a) – $
September | 292795 | 326733 | 323572 | 320496 | 321427
December | 308764 | 329159 | 317039 | 325792 | 337116
March | 316134 | 323183 | 311421 | 321700 | 337276
June | 325553 | 328979 | 321127 | 321383
Annual average | 309110.9720611516 | 327143.2771327381 | 318374.036728256 | 322368.654743657
Average monthly repayment on new home loans – $
September | 1746.653815210925 | 2205.178528061062 | 2258.474188097593 | 2176 | 1993
December | 1960.555475668386 | 2271.914192157253 | 2226.791504535607 | 2131 | 2092
March | 2019.69439471878 | 2239.838466872784 | 2196 | 2106 | 2092
June | 2174.679556442804 | 2290.488099812118 | 2155 | 2050
Annual average | 1975.395810510224 | 2251.854821725804 | 2209.0664231583 | 2115.75
Loan repayments as a proportion of family income – per cent
September | 29.5 | 35.5 | 34.4 | 33.3 | 29.8
December | 32.4 | 36 | 33.5 | 32.5 | 30.8
March | 33 | 35 | 32.7 | 29.9 | 30.6
June | 35.2 | 35.4 | 31.9 | 31
Annual average | 32.6 | 35.5 | 33.1 | 31.6
(a) Excludes alterations and additions and refinancing.
Sources: Real Estate Institute of Australia and Adelaide Bank | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/
ABS, Housing Finance, Cat. no. 5609.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 11 July 2014 for lending
 |  |  |  |  |  |  |  | Early September 2014 for affordability