tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 600549d1543839870-adding-a-value-to-last-cell-in-a-column-rotas-1
Sheet: Week 3

Shift Information
Period 3 Wk 3 |  | 43443 |  | 43444 |  | 43445 |  | 43446 |  | 43447 |  | 43448 |  | 43449 |  | Contacted Hrs |  | KEY:
Area | Day | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  | Shift Request
 | Name | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM |  |  |  | Time off Request
MGMT | Rich | 8-4 |  | [NAME] |  | x |  | 9-6 |  | x |  | 12-10 |  | 8-6 |  | 48 |  |  | Unavailable
 | Kiran | 11-7 |  | x |  | x |  | DM? |  | 9-6 |  | 3-f |  | 12-10 |  | 48 |  |  | Training
 | [NAME] | 4-f |  | 12-10 |  | 12-10 |  | 9-6 (Report Training) |  | 3-f |  | x |  | x |  | 48 |  | WS | Wet Stock
 | Lesley |  |  | x |  | 9-6 |  | x |  | x |  | 8:30-10 |  | 12-f |  | 48 |  |  | Meeting
SS | [NAME] | 8-6 | x | x | 3-f | x | x | x | x | x | 3-f | 12-4 | 6-f | 12-3 | 5-f | 40 |  | FT | Full Timer
 | Meg | x | 6-f | x | 6-f | x | 3-f | x | x | x | x | 8-6 | x | x | 3-f | 40 |  | PT | Part Timer
 | [NAME] | x | x | x | x | 12-4 | x | x | 3-f | 12 | 10 | 12-3 | 5-f | 8-6 | x | 40
LM |  |  |  |  |  |  |  |  |  |  |  |  |  | LM 3-5 |  |  |  | SS | Shift Supervisor (Management Shifts where Required)
Set Shift | Kelly |  |  |  |  |  |  |  | 6-f |  | 6-f |  | 6-f |  |  | 16 |  | NS | New Starter Required
 | [NAME] |  |  | 10-6 |  | 10-6 |  | 10-6 |  |  |  |  |  |  |  | 24 |  | BD | [NAME] |  | 9am-1pm
 | [NAME] | 12 | 9 | x |  |  |  |  |  | x |  |  |  | x | 3-f | 16
 | Pennie |  |  | x | x | x | x | 12-4 | 6-f | x | 6-f |  | 6-f |  |  | 20
FT | [NAME] | x | 6-f | 12-4 | 6-f | x | 6-f | 12-3 | 5-f | 10-6 | x | x | x |  |  | 35
 | Zoe | 10-5 | x | BD | x | x | 6-f | x | 6-f |  |  |  |  | 12-3 | 6-f | 35
 | [NAME] | x | 5-f | x | x | x | x | 12-3 | 5-f | 10-6 | x | 12-4 | 6-f | x | 3-f | 35
 | George | x | 3-f | x | 6-f | x | x | x | x | 12-4 | x | 12-5 | 7-f | x | 3-f | 35
PT | Chloe | 12-6 | x | 12-3 | x | x | x | x | x | x | 6-f | 12-4 | 6-f |  | x | 20
>18yo | Erin | 12-6 | x | x | x |  | x |  | x |  | 7-f |  |  | x | 7-f | 15
 | [NAME] | 12 | 8 |  | x |  | x |  | x |  | 6-f |  | 6-f |  | x | 15
 | Lauren |  |  |  | x |  | x |  | 6-f |  | x |  | x | x | 3-f | 15
Seasonal | Eve |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Polly |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 10 | x
 | PAR | 8 | 6 | 4 | 5 | 4 | 5 | 4 | 6 | 4 | 8 | 7 | 10 | 7 | 10
Alfie Bookings:
Sales Forecast: |  | 7600 |  | 2600 |  | 2700 |  | 3300 |  | 5300 |  | 9000 |  | 9500
Additional Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs
Spreadsheet: 754956d1636591795-applying-data-validation-to-check-box-activity-or-alternative-solution-multi-run-length-calculator-11-07-21-b
Sheet: Matrix Array

Total Length
Total Cuts
 |  |  |  |  |  | Cell C4 Variations
 | Length | Pieces | Total Length |  |  | Sequence: | [NAME]))
Length 1
Length 2 |  |  |  |  |  | Let: | [NAME]))
Total
Difference
Below is just a visual to explain how the formula is calculating. Create a vertical array from 0 to Length. Create a horizonatal array from Length to 0.
Multiply these arrays by the respective [NAME], add them together, then multiple by the identify matrix (array with 1's running at a 45 degree
angle from left to right - to ensure the only values >0 are those where Length1 + Length2 = Total Length). Test results for =Total Length,
multiple by the Length1 array (0 to Length), take the maximum of the result and that is the answer for Length1.
> | >
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, December 21 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 9093f3ff-a87a-4558-a811-b4e499fc2580
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
FAIRP | Test | FAIRP | Airway Pepsin Assay | [NAME] | [NAME] with Immunofluoresence |  |  |  | 1 | mL | 1 mL Tracheal or [NAME] shipped frozen.  Required: Indicate source | 0.5 mL | Specimens other than	Tracheal or bronchial fluid Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Test Performed by: [NAME] for Children-Gastroenterology                              Gastroenterology Lab Research Bldg. Rm 250                              1600 Rockland Road                              Wilmington, DE 19803 | Monday through Friday | 3 days | 5 - 6 days | 1 | 82657 |  |  |  |  | [NAME] for Children-Gastroenterology
FAIRP | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen
FAIRP | Order Question | [NAME] | [NAME] |  | Plain Text
FAIRP | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
FAIRP | Result | Z2019 | pH | pH | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAIRP | Result | Z2020 | Total Protein | Total Protein | Alphanumeric |  |  |  |  | mg/mL |  |  |  |  |  |  |  |  |  | In Process
FAIRP | Result | Z2021 | Pepsin Activity | Pepsin Activity | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FAIRP | Result | Z2022 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 36258d1234124920-index-match-excel-index-match-problem
Sheet: Sheet2

cat number
9898989
9898989 |  |  |  | I have got the formula working but a small problem which have is.
10265
199966 |  |  |  | 1. HOW DO I STOP THE FORMULA RUNNING WITH LAST CAT NO FROM SHEET 1.
199966
199980 |  |  |  | example:
199980 |  |  |  | Sheet 1  ROW 30 has = |  |  | 1160509 | this is where the formula should stop running but insted it keep running down to 200 rows.
199980
199980 |  |  |  | Sheet 1 column A can have data going down 67 rows, 80 rows, 150 rows, 200 rows, etc.
200013
200013
200013
1190524
1610011
1160004
961314
961314
961314
961314
961321
961321
970147
970147
970147
970147
970147
970147
980474
980474
1630022
2408497
1160516
1190445
2779982
2779982
2779982
2779982
2830010
2830010
1610028
1610028
1621749
1621749
1621756
1621756
1630015
200020
1057722
2408507
2410193
2410193
2410193
2410193
2410193
2410193
2410193
2410193
2410193
2410193
2410382
2410382
981459
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
1160509
Spreadsheet: john_griffith__15721__AK Steel
Sheet: 3.00 lookback

 | Look Back Option - Fixed Strike
 | Valuation
 | Option Premium |  |  |  |  | Option Premium |  |  |  |  | Option Premium
 | Start Sampling Date |  | 2001-10-08 00:00:00 |  |  | Start Sampling Date |  | 2001-11-01 00:00:00 |  |  | Start Sampling Date |  | 2001-12-01 00:00:00
 | End Sampling Date (Maturity) |  | 2001-10-31 00:00:00 |  |  | End Sampling Date (Maturity) |  | 2001-11-30 00:00:00 |  |  | End Sampling Date (Maturity) |  | 2001-12-31 00:00:00
 |  | Forward Price |  |  |  |  | Forward Price |  |  |  |  | Forward Price
 |  | Strike Price | 3 |  |  |  | Strike Price |  |  |  |  | Strike Price
 |  | Realized MaxMin | 0 | Blended |  |  | Realized MaxMin | 0 | Blended |  |  | Realized MaxMin | 0 | Blended
 |  | Vol to Start Sampling | 0.4 |  |  |  | Vol to Start Sampling | 0.45 |  |  |  | Vol to Start Sampling | 0.5
 |  | Vol in Sampling | 0.6 |  |  |  | Vol in Sampling | 0.65 |  |  |  | Vol in Sampling | 0.7
 |  | Start Sampling Time |  |  |  |  | Start Sampling Time |  |  |  |  | Start Sampling Time
 |  | End Sampling Time |  |  |  |  | End Sampling Time |  |  |  |  | End Sampling Time
 |  | Interest Rate | 0.045 |  |  |  | Interest Rate | 0.045 |  |  |  | Interest Rate | 0.045
 |  | Call Falg (call=1, put=0) | 0 |  |  |  | Call Falg (call=1, put=0) | 0 |  |  |  | Call Falg (call=1, put=0) | 0
 |  | Return Type | 0 |  |  |  | Return Type | 0 |  |  |  | Return Type | 0
 |  | Pmt date | 2001-11-05 00:00:00 |  |  |  | Pmt date | 2001-12-05 00:00:00 |  |  |  | Pmt date | 2002-01-05 00:00:00
 |  | Volume |  |  |  |  | Volume |  |  |  |  | Volume
 |  | Total $'s upfront
Spreadsheet: 196198d1353913271-calculating-effort-and-applying-it-over-multiple-months-to-create-a-forecast-effort-forecast-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Effort Forecast By Month
 |  |  | Standard Project # | Region | Start Month |  |  |  | Standard Projects |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | 123 | WEST | Jan |  |  |  | WEST
 |  |  | 124 | EAST | Mar |  |  |  | EAST
 |  |  | 125 | NORTH | Jun |  |  |  | NORTH
 |  |  | 126 | SOUTH | Aug |  |  |  | SOUTH
 |  |  | 127 | SOUTH | Feb |  |  |  | Total
 |  |  | 128 | EAST | Feb
 |  |  | 129 | WEST | Feb
 |  |  | 130 | WEST | Apr
 |  |  |  |  |  |  |  |  | [NAME] |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  | WEST
 |  |  | Complex  Project # | Region | Start Month |  |  |  | EAST
 |  |  | 213 | WEST | Dec |  |  |  | NORTH
 |  |  | 214 | EAST | Jan |  |  |  | SOUTH
 |  |  | 215 | NORTH | Mar |  |  |  | Total
 |  |  | 216 | SOUTH | Apr
 |  |  | 217 | SOUTH | Apr
 |  |  | 218 | EAST | May
 |  |  | 219 | WEST | Feb
 |  |  | 220 | WEST | Jan
 |  |  |  |  |  | Effort Distribution
 |  |  |  | Total Days Effort |  | Start Month | Start Month +1 | Start Month +2 | Start Month +3 | Start Month +4
 |  |  | Standard Project |  |  | 3 | 6 | 3 | 12 | 6
 |  |  | Complex Project |  |  | 0 | 15 | 3.75 | 15 | 3.75
Spreadsheet: 860901d1708929836-formula-that-gives-different-results-according-to-the-selected-client-profile-formula-v2-aligw
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profile A
 |  | Type | Profile B |  |  |  |  |  |  |  |  |  |  |  |  | Profile B
 |  | Result
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.07 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.05 |  |  |  |  | 0.25 |  |  |  | 0 | to escalate to CAC
 |  |  |  | 0.1 |  |  |  |  | 0.25 |  |  |  | Low | to escalate to CAC
 |  |  |  | 0.05 |  |  |  |  | 0.25 |  |  |  | Low
 |  |  |  | 0.08 |  |  |  |  | 0.1
 |  |  |  | 0.05 |  |  |  |  | 0.25
 |  |  |  | 0.03 |  |  |  |  | 0
 |  |  |  | 0.03 |  |  |  |  | 0
 |  |  |  | 0.05 |  |  |  |  | 0.25
 |  |  |  | 0.07 |  |  |  |  | 1
 |  |  |  | 0.1 |  |  |  |  | 0.25
 |  |  |  | 0.11 |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  | Profile A
 |  |  |  |  |  |  |  | Total Score |  |  |  | Risk Score (Range) | LB (Parameter) | UB (Parameter) |  | Classification | score adjustment
 |  |  |  |  |  |  | Score: | 63 |  |  | Extreme | 80.01-100 | 80.01 | 100 |  | Prohibited | 2
 |  |  |  |  |  |  | Risk Rating : |  |  |  | High Risk | 60.01 - 80.00 | 60.01 | 80 |  | Very High | 2
 |  |  |  |  |  |  |  |  |  |  | Medium Risk | 45.01 - 60.00 | 45.01 | 60 |  | High | 1
 |  |  |  |  |  |  |  |  |  |  | Low Risk | 25.85 - 45.00 | 25.85 | 45 |  | Medium | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | -2
 |  |  |  |  |  |  | Action |  |  |  | Profile B |  |  |  |  | N/A | 0
 |  |  |  |  |  |  |  |  |  |  |  | Risk Score (Range) | LB (Parameter) | UB (Parameter)
 |  |  |  |  |  |  |  |  |  |  | Extreme | 80.01-100 | 80.01 | 100
 |  |  |  |  |  |  |  |  |  |  | High Risk | 65.01 - 80.00 | 65.01 | 80
 |  |  |  |  |  |  |  |  |  |  | Medium Risk | 50.01 - 65.00 | 50.01 | 65
 |  |  |  |  |  |  |  |  |  |  | Low Risk | 25.85 -50.00 | 25.85 | 50
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
 | Andorra
Spreadsheet: 49057d1248342127-keeping-track-of-payments-test
Sheet: 7

 |  |  |  | Job Name
 |  |  |  | Plot No./Type
 |  |  |  | Labour Times |  | Plot / Type | Labour price
 |  |  |  |  | hrs | Joists 1st floor
 |  |  |  |  | hrs | Joists 2nd floor
 |  |  |  |  | hrs | Roof
 |  |  |  |  | hrs | Low Level
 |  |  |  |  | hrs | Garage Roof
 |  |  |  |  | hrs | First Fix
 |  |  |  |  | hrs | External doors
 |  |  |  |  | hrs | Second Fix
 |  |  |  |  | hrs | Final fix
 |  |  |  |  | hrs | Snag
 |  |  |  |  | hrs | Total
 |  |  |  | Price Quote for plot/type | Total | Profit | Fixings
 |  |  |  | Joists 1st floor
 |  |  |  | Joists 2nd floor
 |  |  |  | Roof
 |  |  |  | Low Level
 |  |  |  | Garage Roof
 |  |  |  | First Fix
 |  |  |  | External doors
 |  |  |  | Second Fix
 |  |  |  | Final fix
 |  |  |  | Snag
 |  |  |  | Extra add on's (see notes)
 |  |  |  | Total
Notes
Job Name |  |  |  |  | Plot No.
Gr | 1st | 2nd | Qty | Item | labour total | my total | fixings | Time
 |  |  |  | Joist & Decking TJI psm 1st floor
 |  |  |  | Total Joist 1st floor
 |  |  |  | Joist & Decking TJI psm 2nd floor
 |  |  |  | Total Joist 2nd floor
 |  |  |  | Trusses psm
 |  |  |  | Pediment [NAME]
 |  |  |  | [NAME]made Timber
 |  |  |  | [NAME]made Fibreglass
 |  |  |  | Attic Trusses psm
 |  |  |  | Velux
 |  |  |  | Valley pr/m Trusses
 |  |  |  | Hip pr/m
 |  |  |  | Hand cut section
 |  |  |  | Total Roof
 |  |  |  | Low Levels
 |  |  |  | Garage Roof
 |  |  |  | Stairs -Straight Flight
 |  |  |  | Stairs -Kite over Garage wall
 |  |  |  | Stairs-Double kite
 |  |  |  | Stairs-Kite
 |  |  |  | Block casing
 |  |  |  | [NAME] casing
 |  |  |  | Plasterboard catch noggins(per floor)
 |  |  |  | Soil boxing
 |  |  |  | Metal Studding pm
 |  |  |  | Studding pm
 |  |  |  | Window board
 |  |  |  | Temp handrail
 |  |  |  | Protect Stairs
 |  |  |  | Total 1st Fix
 |  |  |  | Front/Back Door & Frame & Lock
 |  |  |  | Fire door
 |  |  |  | Standard door
 |  |  |  | Skirting
 |  |  |  | Pipe Boxings p/m
 |  |  |  | Furniture
 |  |  |  | Arcs
 |  |  |  | Drilling and cutting latches
 |  |  |  | Strings hand rails, spindles per flight
 |  |  |  | Total 2nd Fix
 |  |  |  | Bath/Shower Panel
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Door furniture
 |  |  |  | Intumescent strips
 |  |  |  | Re-hang doors
 |  |  |  | Total Final Fix
 |  |  |  | Snag price
Spreadsheet: drew_fossum__8667__Budget 2001 Consolidation - Legal
Sheet: Cmpy Rpt

 |  |  |  |  |  |  | Enter Company in Blue Box: | 436
GPG LEGAL
2000 BUDGET SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 060 - TW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 062 - FGT
 | 1999 |  | 1999 |  |  | 1999 |  | 2000 |  | 1999 |  | 1999 |  | 1999 |  |  |  | 111 | 1A1 - MONT BELVIEU
 | Approved |  | Restated |  |  | C.E. |  | Budget |  | Approved |  | Restated |  | C.E. |  | Outside |  | 179 | 179 - NNG
 | Budget |  | Budget |  |  |  |  |  |  | Budget |  | Budget |  | Budget |  | Counsel |  | 404 | 404 - METHANOL
 |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | 413 | 413 - ECT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 436 | 436 - EGP FUELS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 543 | 543 - HPL OPS
GPG Legal Department: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583 | 583 - LRCO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 584 | 584 - HPLP
0162 - Executive
0013 - FGT General
0014 - TW General
0026 - NNG Legal
0237 - OPs General & Clean Fuels
0238 - Overhead
0239 - Clean Fuels
Company 508 Total
Change Increase/(Decrease)
Spreadsheet: 775335d1649036437-calculate-pay-rate-depending-on-the-time-of-day-weekly-time-sheet-help
Sheet: Tax & NI

 | Income Tax |  |  |  | WEEKLY breakdown |  | National insurance Contribution
 | YEARLY BANDS | Start | End | % |  |  | BAND | Start | End | % | breakdown
 | Personal Allowance | 0 | 12570 | 0 | 0 |  | Personal Allowance | 120 | 184 | 0 | 0
 | Basic Rate | 12570.01 | 50000 | 0.2 |  |  | Basic Rate | 184.01 | 962 | 0.1325
 | Higher Rate | 50000.01 | 150000 | 0.4 |  |  | Additional Rate | 967 | OVER | 0.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday | Sunday
 | Additional Rate | 150000.01 | OVER | 0.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.038461538461539 | 13.5 | <13:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.076923076923077 | 14 | >13:00 | All Day
 |  |  |  |  | [NAME]
 | Employee Name | Basic Pay Rate | Basic Total Hours | OverTime Pay | OverTime Total Hours | Weekly Gross Pay | Income Tax | National insurance Contribution | Other Deductions | Total Tax Due | Net Pay
 |  | 13 | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 1 |  | 3.8461538461538
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
Spreadsheet: 719611d1613740079-calculating-project-end-times-to-the-minute-project-schedule
Sheet: Mornings

 | Project | Hours | Start | Stop | Begin Date | Begin Time | Days | Day one Time | Balance of Time | Test Days | Test Int Days | Test Partial Days | End Date | End Time |  | Master [NAME] | Daily Hours |  | Day Holidays | Night Holidays
Group 1 | AMT1070 |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  | 2021-08-18 00:00:00 | 5.25 |  | 2021-09-06 00:00:00 | 2021-09-06 00:00:00
 | AMT1090 |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-11 00:00:00 | 2021-10-11 00:00:00
 | AMT1001C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-11 00:00:00 | 2021-11-11 00:00:00
 | AMT1011C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-24 00:00:00 | 2021-11-24 00:00:00
 | AMT1050C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-25 00:00:00 | 2021-11-25 00:00:00
 | AMT1081C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-26 00:00:00 | 2021-11-26 00:00:00
 | AMT1041C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-27 00:00:00 | 2021-11-27 00:00:00
 | AMT1031C |  | 07:30:00 | 12:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-28 00:00:00 | 2021-11-28 00:00:00
 | AMT1021C |  | 07:30:00 | 12:45:00
 | AMT1060C |  | 07:30:00 | 12:45:00
Group 2 | AMT1131C |  | 07:30:00 | 12:45:00
 | AMT1116C |  | 07:30:00 | 12:45:00
 | [NAME] |  | 07:30:00 | 12:45:00
 | AMT1111C |  | 07:30:00 | 12:45:00
 | AMT1141C |  | 07:30:00 | 12:45:00
 | AMT1156C |  | 07:30:00 | 12:45:00
 | AMT1201C |  | 07:30:00 | 12:45:00
Group 3 | AMT1161C |  | 07:30:00 | 12:45:00
 | AMT1211C |  | 07:30:00 | 12:45:00
 | AMT1221C |  | 07:30:00 | 12:45:00
 | AMT1232C |  | 07:30:00 | 12:45:00
 | AMT1241C |  | 07:30:00 | 12:45:00
 | AMT1251C |  | 07:30:00 | 12:45:00
 | AMT1263C |  | 07:30:00 | 12:45:00
 | AMT1271C |  | 07:30:00 | 12:45:00
 | AMT1286C |  | 07:30:00 | 12:45:00
Group 4 | AMT2301C |  | 07:30:00 | 12:45:00
 | AMT2401C |  | 07:30:00 | 12:45:00
 | AMT1313C |  | 07:30:00 | 12:45:00
 | AMT2421C |  | 07:30:00 | 12:45:00
Group 5 | AMT1321C |  | 07:30:00 | 12:45:00 | 2021-08-18 00:00:00
 | AMT2452C |  | 07:30:00 | 12:45:00
 | AMT2453C |  | 07:30:00 | 12:45:00
 | AMT2441C |  | 07:30:00 | 12:45:00
 | AMT2461C |  | 07:30:00 | 12:45:00
 | AMT2436C |  | 07:30:00 | 12:45:00
 | AMT2471C |  | 07:30:00 | 12:45:00
 | AMT2411C |  | 07:30:00 | 12:45:00
 | AMT2491C |  | 07:30:00 | 12:45:00
Spreadsheet: 677087d1589190824-power-query-extraction-of-field-in-duplicated-record-leave-fte-example
Sheet: Sheet2

ID | Surname | Preferred | JobPositionsSeq | AwardCode | JobPositionCode | JobPositionDescription | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | ReportsToJobPositionsSeq | SchoolStaffCode | CurrentJobPositionFlag | FutureJobPositionFlag | JobLevel | JobLevelNextIncrementDate | StartDate | EndDate | FTE | JobLevelNextIncrementYears | NextReviewDate | MAX FTE
18092 | Hark | Emma | 17 | TEACHING | TEACHER | Teacher | PARENTAL | TEACHER | True | 18 | HarE | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-27 00:00:00 | 0 | 1 |  | 1
18144 | Liver | [NAME] | 28 | ES | COUNSELLORS | Counsellor | PARENTAL | COUNSELLOR | True | 18 | LivJ | True | False | 0 |  | 2019-02-23 00:00:00 |  | 0 | 1 |  | 0.8
18279 | Viccar | [NAME] | 17 | TEACHING | TEACHER | Teacher | LONG_TERM_CARER | TEACHER | True | 18 | VicM | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1 |  | 1
18443 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 | BonJ | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-06-23 00:00:00 | 0 | 1 |  | 1
26018 | Keen | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 | KeeN | True | False | 0 |  | 2020-02-26 00:00:00 | 2020-06-19 00:00:00 | 0 | 1 |  | 1