tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53741d1253654593-general-ledger-template-general-ledger-wilverley
Sheet: Budget codes Legend

10 | [NAME]
11 | Freehold Property Depriciation
20 | Furniture & Equipment
21 | Furniture & Equipment Depriciation
1001 | Stock
1100 | Debtors Control Account
1103 | Prepayments
1200 | Bank Current Account
1210 | Bank Deposit Account
1230 | Petty Cash
2100 | Creditors Control Account
4004 | [NAME]
4005 | Guest Accommodation
4010 | Garage Rent
4015 | Newspapers
4020 | Laundry
4025 | Meals
4030 | TV Licence
4035 | Medical Supplies
4036 | Room Redecoration
4037 | Telephone Receipts
4039 | Donations
5009 | Discounts Taken
6102 | Provisions
6105 | Management Fee
6110 | Cleaning and Laundry
6111 | Waste Disposal
6120 | Medical Expenses
6121 | Scabies Prescriptions
6151 | ABM
6155 | Staff Training
7147 | Council Tax
7150 | Sewerage and Water
7155 | Insurance
7160 | Electricity
7161 | Gas
7162 | Utilities Monitoring
7165 | Telephone
7170 | Postage, Stationery & Advertising
7172 | Computer Expenses (IT)
7175 | Travelling Expenses
7180 | Accountancy
7185 | Audit Fees
7187 | Legal & Professional Fees
7190 | Sundry Expenses
7191 | CRB Checks
7193 | Newspapers
7195 | Keep Fit
7200 | Garden Expenses
7205 | Repairs & Renewals: Linen & Soft Furnishings
7210 | Repairs & Renewals: Plant & Equipment
7215 | Repairs & Renewals: Kitchenware Crockery & Cutlery
7220 | Repairs & Renewals: Property
7221 | Repairs & Renewals: Property Redecoration Reserve
7225 | Repairs & Renewals: General
7226 | Overalls & Uniforms
7227 | Hire of Equipment
7235 | Profit on Sale of Asset
7237 | Depreciation Buildings
7240 | Depreciation Furniture & Equipment
7252 | Registration Fees
7254 | Cashed Cheques Account
Spreadsheet: theresa_staab__39594__Kennedy e-mail without gathering
Sheet: Box Draw Detail

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
Box Draw Net Backs: |  | Index Discount/Premium | Crestone Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | BOX DRAW
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total Box Draw Allocated Fuel MMBtu | Box Draw Wellhead Production MMBtu | Total Purchased Production MMBtu | Total Box Draw Payments by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | (7% [NAME] to Maverick)
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 162917 | 1032740 | 657336 | 5634846 | 7487839
FRA | 16449598 | 3300802 | 19531 | 14857167 | 34627098
IRS- [NAME] | 47137825 | 8408036 | 15699069 | 32741838 | 103986768
OIS | 12930319 | 4064611 |  | 4393892 | 21388822
VNS | 1711 | <1,000 |  | 1414 | 3125
Zero Coupon | 109257 | 34348 | 35948 | 60660 | 240213
TOTAL | 76791626 | 16840537 | 16411883 | 57689816 | 167733863
Estimated gross notional amount outstanding, December 14 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. 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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***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: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Clearance

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Intake
Activity Name | Clearance
Activity Description / Purpose | When a client is registered the system automatically triggers an activity called a ‘clearance’ that searches for information about prior human services cases or applications, and seeks additional information provided outside of WMS, e.g. SSN or employment verification
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
 |  |  | Customer | Request for Services | New Application | Completed Application Packet | Pre-Screening |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case Closure |  |  | Accounting
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Searches for information about prior human services cases or applications in WMS
Seeks additional information provided outside of WMS, e.g. SSN or employment verification
Spreadsheet: 714577d1611298252-use-index-in-table-header-with-sumifs-book1
Sheet: PLAN_LAB

wk | date | apple | juice | candy
53 2020 | 2021-01-01 00:00:00 | 0 | 0 | 0
53 2020 | 2021-01-02 00:00:00 | 0 | 0 | 0
53 2020 | 2021-01-03 00:00:00 | 0 | 0 | 0
1 2021 | 2021-01-04 00:00:00 | 1050 | 400 | 0
1 2021 | 2021-01-05 00:00:00 | 525 | 800 | 0
1 2021 | 2021-01-06 00:00:00 | 1050 | 800 | 0
1 2021 | 2021-01-07 00:00:00 | 525 | 800 | 0
1 2021 | 2021-01-08 00:00:00 | 1050 | 400 | 0
1 2021 | 2021-01-09 00:00:00 | 0 | 0 | 0
1 2021 | 2021-01-10 00:00:00 | 0 | 0 | 0
2 2021 | 2021-01-11 00:00:00 | 1050 | 0 | 400
2 2021 | 2021-01-12 00:00:00 | 525 | 0 | 800
2 2021 | 2021-01-13 00:00:00 | 1050 | 0 | 800
2 2021 | 2021-01-14 00:00:00 | 525 | 0 | 800
2 2021 | 2021-01-15 00:00:00 | 1050 | 0 | 800
2 2021 | 2021-01-16 00:00:00 | 0 | 0 | 0
2 2021 | 2021-01-17 00:00:00 | 0 | 0 | 0
3 2021 | 2021-01-18 00:00:00 | 1050 | 400 | 0
3 2021 | 2021-01-19 00:00:00 | 525 | 800 | 0
3 2021 | 2021-01-20 00:00:00 | 1050 | 800 | 0
3 2021 | 2021-01-21 00:00:00 | 525 | 800 | 0
3 2021 | 2021-01-22 00:00:00 | 1050 | 400 | 0
3 2021 | 2021-01-23 00:00:00 | 0 | 0 | 0
3 2021 | 2021-01-24 00:00:00 | 0 | 0 | 0
4 2021 | 2021-01-25 00:00:00 | 1050 | 400 | 0
4 2021 | 2021-01-26 00:00:00 | 1560 | 800 | 0
4 2021 | 2021-01-27 00:00:00 | 1560 | 800 | 0
4 2021 | 2021-01-28 00:00:00 | 1560 | 800 | 0
4 2021 | 2021-01-29 00:00:00 | 1560 | 400 | 0
4 2021 | 2021-01-30 00:00:00 | 0 | 0 | 0
4 2021 | 2021-01-31 00:00:00 | 0 | 0 | 0
5 2021 | 2021-02-01 00:00:00 | 1050 | 400 | 0
5 2021 | 2021-02-02 00:00:00 | 1050 | 800 | 0
5 2021 | 2021-02-03 00:00:00 | 1050 | 800 | 0
5 2021 | 2021-02-04 00:00:00 | 1050 | 800 | 0
5 2021 | 2021-02-05 00:00:00 | 1050 | 400 | 0
5 2021 | 2021-02-06 00:00:00 | 0 | 0 | 0
5 2021 | 2021-02-07 00:00:00 | 0 | 0 | 0
6 2021 | 2021-02-08 00:00:00 | 1050 | 400 | 0
6 2021 | 2021-02-09 00:00:00 | 1050 | 800 | 0
6 2021 | 2021-02-10 00:00:00 | 1050 | 800 | 0
6 2021 | 2021-02-11 00:00:00 | 1050 | 800 | 0
6 2021 | 2021-02-12 00:00:00 | 1050 | 400 | 0
6 2021 | 2021-02-13 00:00:00 | 0 | 0 | 0
6 2021 | 2021-02-14 00:00:00 | 0 | 0 | 0
7 2021 | 2021-02-15 00:00:00 | 1050 | 400 | 0
7 2021 | 2021-02-16 00:00:00 | 1050 | 800 | 0
7 2021 | 2021-02-17 00:00:00 | 1050 | 800 | 0
7 2021 | 2021-02-18 00:00:00 | 1050 | 800 | 0
7 2021 | 2021-02-19 00:00:00 | 1050 | 400 | 0
7 2021 | 2021-02-20 00:00:00 | 0 | 0 | 0
7 2021 | 2021-02-21 00:00:00 | 0 | 0 | 0
Spreadsheet: 883304d1731899455-formula-to-find-the-total-of-stock-according-to-date-stock-control
Sheet: Cash Sales

Date | Stock | Quantity | Price | Total
2024-11-07 00:00:00 | Milo | 2
2024-11-08 00:00:00 | Tea bag | 2
2024-11-09 00:00:00 | Sugar | 3
Spreadsheet: 544139d1508774453-problem-with-solver-cant-find-a-feasible-solution-kopia-solver-error
Sheet: Blad1

 | Probabilities |  |  | Total probability | Selected Probability |  |  | Binary
Game | HomeWin | Draw | AwayWin | Sum | HomeWin | Draw | AwayWin | Select HomeWin | Select Draw | Select AwayWin | Total Selected Outcomes
Game 1 | 44.599 | 22.881 | 32.52 |  |  |  |  |  |  |  | 3
Game 2 | 34.139 | 28.943 | 36.91799999999999 |  |  |  |  |  |  |  | 3
Game 3 | 6.474 | 21.003 | 72.523 |  |  |  |  |  |  |  | 2
Game 4 | 92.483 | 5.496 | 2.020999999999995 |  |  |  |  |  |  |  | 1 | System
Game 5 | 87.922 | 10.412 | 1.666000000000002 |  |  |  |  |  |  |  | 1 | 1^= | 2
Game 6 | 20.619 | 21.652 | 57.729 |  |  |  |  |  |  |  | 2 | 2^= | 6
Game 7 | 37.786 | 21.191 | 41.023 |  |  |  |  |  |  |  | 3 | 3^= | 5
Game 8 | 51.806 | 19.637 | 28.557 |  |  |  |  |  |  |  | 2
Game 9 | 59.603 | 30.786 | 9.610999999999997 |  |  |  |  |  |  |  | 2
Game 10 | 43.626 | 24 | 32.374 |  |  |  |  |  |  |  | 3
Game 11 | 62.876 | 24.141 | 12.983 |  |  |  |  |  |  |  | 2
Game 12 | 58.68 | 25.476 | 15.844 |  |  |  |  |  |  |  | 2
Game 13 | 48.792 | 23.404 | 27.804 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | Rows in system
 |  |  |  |  |  |  |  |  |  | Feasible number of rows
 |  |  | Solver:
 |  |  | Find max value of E15
 |  |  | I3:K15 has to be binary
 |  |  | L16 should be equal to L17<--- fails constraint, how?
Spreadsheet: 848769d1699401304-list-of-all-worksheet-names-in-same-workbook-cash_test1
Sheet: Total

 | No. | Sheet name | Total Cash
 | 1 |  |  |  | Need to arrange sheet from Old to New. Like "Total",  "Oct 16-Oct 21",  "Oct 22-Nov 04" & "Nov 5-Nov 18"
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 826165d1681835294-formula-to-determine-percentages-book1
Sheet: Sheet1

 |  |  |  | Last Month
 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | % to Multiply
 | Last Month | % to Multiply |  |  | Last Month w Expense | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 1 |  |  | 1 | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 |  |  |  | 2 |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0
 | 3 |  |  |  | 3 |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0 | 0 | 0 | 0
 | 4 |  |  |  | 4 |  |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0 | 0 | 0
 | 5 |  |  |  | 5 |  |  |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0 | 0
 | 6 |  |  |  | 6 |  |  |  |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05 | 0
 | 7 |  |  |  | 7 |  |  |  |  |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1 | 0.05
 | 8 |  |  |  | 8 |  |  |  |  |  |  |  | 1 | 0.9 | 0.66 | 0.3 | 0.1
 | 9 |  |  |  | 9 |  |  |  |  |  |  |  |  | 1 | 0.9 | 0.66 | 0.3
 | 10 |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 | 0.9 | 0.66
 | 11 |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  | 1 | 0.9
 | 12 |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Goal:  A Formula to populate the table
 |  | above with percentages based on the
 |  | month in cell E3
 |  | Preferable NOT a lookup formula.
Spreadsheet: 72863d1273585097-two-bar-charts-overlapping-each-other-example
Sheet: Executive Summary 1

 | Cost Bucket | Total £'000k | Cumulative |  | Cost Bucket | Total £'000k | Cumulative
 | [NAME] | 7736820.280274 | 0 |  | [NAME] | 7000 | 0
 | Mark | 7120999.153549999 | 7736820.280274 |  | Mark | 5000 | 7000
 | [NAME] | 4048922.479777777 | 14857819.433824 |  | [NAME] | 5000 | 12000
 | [NAME] | 685485.7 | 18906741.91360177 |  | [NAME] | 1000 | 17000
 | [NAME] | 1506646.2 | 19592227.61360177 |  | [NAME] | 1500 | 18000
 |  | 21098873.81360177 | 0 |  |  | 19500 | 0
 | [NAME] | 1547360.875 | 21098873.81360177 |  | [NAME] | 1500 | 19500
 | Rachel | 646950 | 22646234.68860177 |  | Rachel | 1000 | 21000
 |  | 2194310.875 | 21098873.81360177 |  |  | 2500 | 19500
 | Nick | 1580123.890599999 | 23293184.68860177 |  | Nick | 1000 | 22000
 | [NAME] | 388080 | 24873308.57920177 |  | [NAME] |  | 23000
 | Angie | 2428134 | 25261388.57920177 |  | Angie | 3500 | 23000
 | [NAME] | 2294592.1625 | 27689522.57920177 |  | [NAME] | 2000 | 26500
 |  | 6690930.053099999 | 23293184.68860177 |  |  | 6500 | 22000
 |  | 29984114.74170177 |  |  |  | 28500
 | Emma | 746571.6012500002 | 29984114.74170177 |  | Emma |  | 28500
 | Anna | 2000000 | 30730686.34295177 |  | Anna | 2100 | 28500
 | [NAME] | 1378667.859375 | 32730686.34295177 |  | [NAME] |  | 30600
 |  | 34109354.20232677 |  |  |  | 30600
Spreadsheet: 14f0c4b3-e257-418c-ab07-47e4592c20eb
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 6/30/2013
(As of 7/29/2013)
Name | Title | Personal Benefits Reported | City Benefits Reported
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | At-will staff for Mayor Hales
Marriott, [NAME] | Director of Environmental Services
Hockaday [NAME] | At-Will staff for Commissioner [NAME]
[NAME] | At-Will staff for Commissioner [NAME]
Reese, [NAME] | Director of Bureau of Police
Saltzman, [NAME] | Commissioner | 50
Warner, [NAME] | At-Will staff for Commissioner [NAME]
Griffin-Valade, [NAME] | Auditor
Shriver, [NAME] | At-Will staff for Commissioner [NAME]
Fish, [NAME] | Commissioner
Novick, [NAME] | Commissioner | 339
Pellegrino, [NAME] | Director of Government Relations
Fritz, Amanda | Commissioner | 100
[NAME] | Interim Director, Portland Bureau of Transportation
Hales, [NAME] | Mayor | 814
Spreadsheet: 849750d1700148004-similar-to-protection-of-cells-can-you-mark-them-for-bulk-editing-to-refresh-a-report-ms-office-example
Sheet: 5 AF (2)

NFPA 25  INSPECTION, TESTING, AND [NAME]
 |  |  |  |  |  |  |  |  | of Water Based Fire Protection Systems
5 Anti-Freeze Test Results | Anti-Freeze Systems |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note Comment
 | System 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 | Location of valve: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gauge pressure: |  |  |  |  |  |  |  |  | PSI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 | Location of protected area: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
 | Location of valve for testing anti-freeze solution: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEE NOTE
 | Refractometer results: |  |  |  |  |  |  |  |  |  | ºC | Is the freeze protection acceptable for the intended purpose? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPLACE
 | Location of 2nd valve if more than 150 gal (586 L): |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIR
 | Refractometer results: |  |  |  |  |  |  |  |  |  | ºC | Is the freeze protection acceptable for the intended purpose? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORRECT
 | Is there a backflow prevention device on the anti-freeze system?
 | Make: |  |  |  |  |  |  |  |  |  |  |  |  |  | Model: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/N:
 | System 2
 | Location of valve: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gauge pressure: |  |  |  |  |  |  |  |  | PSI
 | Location of protected area:
 | Location of valve for testing anti-freeze solution:
 | Refractometer results: |  |  |  |  |  |  |  |  |  | ºC | Is the freeze protection acceptable for the intended purpose?
 | Location of 2nd valve if more than 150 gal (586 L):
 | Refractometer results: |  |  |  |  |  |  |  |  |  | ºC | Is the freeze protection acceptable for the intended purpose?
 | Is there a backflow prevention device on the anti-freeze system?
 | Make: |  |  |  |  |  |  |  |  |  |  |  |  |  | Model: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/N:
 | Notes - LP Drains and Test Connections
Spreadsheet: 732553d1621010416-calculate-and-return-decimal-value-between-range-calculate-and-return-decimal-value-between-range
Sheet: Joseph

 |  |  |  | Enter Load
 |  |  |  | Hours [NAME]. |  |  |  | Hours | 1 | 2 | 3 | 4 | 6 | 8 | 10 | 15 | 30
 |  |  |  |  |  |  |  | Mod calcs
 |  |  |  | Enter Total mods | 64
 |  |  |  |  |  |  |  | VPC | 5.7 | 4 | 2.95 | 2.33 | 1.58 | 1.19 | 0.94 | 0.6 | 0.25
 |  |  |  | Helper Cells
 |  |  |  |  | Range |  | Diff | [NAME]
 |  |  |  | Hours
 |  |  |  | Mod calcs
 |  |  |  | Count | Mod calcs | Hours | Increment | Decimal Value
 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | This table not in used in calculations,
 |  |  |  |  |  |  |  |  |  | for illustration purpose only
Spreadsheet: 884363d1733474635-using-2-formulas-in-one-cell-sample-rota-new-v1
Sheet: SKILL MATRIX

Barnstaple DO | Bideford DO | Bude DO | [NAME] | Ilfracombe DO
DAY OFF UNCOVERED | DAY OFF UNCOVERED | DAY OFF UNCOVERED | DAY OFF UNCOVERED | DAY OFF UNCOVERED
DAY OFF - JW | DAY OFF - JW | DAY OFF - JW | DAY OFF - JW | DAY OFF - JW
DAY OFF - DM | DAY OFF - DM | DAY OFF - DM | DAY OFF - DM | DAY OFF - DM
DAY OFF - MB | DAY OFF - MB | DAY OFF - MB | DAY OFF - MB | DAY OFF - MB
DAY OFF - DS | DAY OFF - DS | DAY OFF - DS | DAY OFF - DS | DAY OFF - DS
JW | JW | JW | JW | JW
DM | DM | DM | DM | DM
MB | MB | MB | MB | MB
DS | DS | DS | DS | DS
Spreadsheet: 89011d1288801866-calculating-overtime-on-variable-rates-over-the-weekend-weekly-hours
Sheet: Sheet1

January | week 1 |  | Overtime |  | week 2 |  |  | Overtime |  | week 3 |  |  | Overtime |  | week 4 |  |  | Overtime |  | week 5 |  |  | Overtime
 | In | Out | TH | DT | In | Out |  | TH | DT | In | Out |  | TH | DT | In | Out |  | TH | DT | In | Out |  | TH | DT
Monday | 06:30:00 | 17:30:00 |  |  | 06:30:00 | 17:30:00
Tuesday | 06:15:00 | 17:30:00 |  |  | 06:15:00 | 17:30:00
Wednesday | 06:30:00 | 18:00:00 |  |  | 06:30:00 | 18:00:00
Thursday | 06:30:00 | 17:30:00 |  |  | 06:30:00 | 17:30:00
Friday | 06:30:00 | 16:00:00 |  |  | 06:30:00 | 16:00:00
Saturday | 06:30:00 | 14:00:00 | 6 | 2
Sunday | 06:30:00 | 12:30:00 |  | 6 | 06:30:00 | 12:30:00 |  | 6 | 2
Total: weekly hours OT
Spreadsheet: 759324d1639494244-automatically-copy-data-into-summary-summary-example
Sheet: Sheet1

 |  | [NAME] range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  | Name |  | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored |  |  |  |  |  |  |  |  | [NAME] |  | 2021-01-04 00:00:00 | 73 | 2614.75
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  | Data is entered daily into the detail |  |  |  | [NAME] |  | 2021-01-12 00:00:00 | 74 | 1899.18
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 73 | range, left. |  |  |  | etc.
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  |  |  |  |  |  | How to automatically add new cell
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  | content from the detail range (left)
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  | into the summary (right)?
 |  | 2021-01-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 74
 |  | etc. |  | etc.
Here is the detail with date, name, score and chit number, to be copied into the summary.
Every time there is new data filled into the detail range, it gets the next chit number, and once that is entered, the chit number, plus
the date, name and score should be automatically added to the summary.
Doing this manually now, but would like to automate... except, that's beyond my formula knowledge. Looking for a working formula.
And to make it a little more complicated...
This is the summary of the B league, with Chits 001-1500.
The A league has Chit numbers 1501 up. Each summary can only contain the data that is applicable to it.
Possibly, there will be a C league in the future.
Spreadsheet: 35943d1233671392-cell-value-based-on-another-cell-value-example
Sheet: FH

xx | UP | Interval | 2nd UP/Int | M/Hrs | Skill |  | xx | xx | xx | xx | xx | xx | xx
258400-00001-01M | FH | 300 | 12 | 1 | AF |  | 6 | 3 | 9 | 9 | 6 | 6 | 3
252700-00001-01M | FH | 500 | 12 | 1 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
252700-00005-01M | FH | 500 | 12 | 1 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
252700-00009-01M | FH | 500 | 12 | 0.5 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
252700-00011-01M | FH | 500 | 12 | 1.5 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6 |  |  | Months
255200-00001-01M | FH | 500 | 12 | 1 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6 |  |  |  | E.g. 500FH converted into months = 6,3,9 etc depending on the user
255700-00001-01M | FH | 500 | 12 | 1 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
262300-00001-01M | FH | 500 | 12 | 0.1 | AV |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
262400-00001-01M | FH | 500 |  | 0.3 | AV |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
281400-00004-01M | FH | 500 |  | 0.2 | AF |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
9940-00002-01M | FH | 500 | 8 | 0.05 | TEC |  | 9 | 9 | 15 | 15 | 9 | 9 | 6
212100-00002-01M | FH | 750 |  | 0.2 | [NAME] |  | 15 | 12 | 24 | 21 | 15 | 15 | 9
 |  |  |  |  |  |  |  | So, if J3 is more than C3 then [NAME] should become the value of J3 and so on.
 |  |  |  |  |  |  |  | I cannot use conditional formatting as when there is no value in D:D then the figures to the right will always be more.
 |  |  |  | New Interval
Spreadsheet: 119479d1314443773-how-to-automatize-a-changing-range-q2
Sheet: Sheet1

a | 1
a | 0
a | 1
a | 1
a | 0
a | 1
b | 0
b | 1
b | 1
c | 0
c | 1
c | 1
c | 0