tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 83319d1283324487-excel-2007-reports-across-tabs-dynamic-field-ranges-water5
Sheet: Input

PURE WATER SALE RECORDS
2010-08-31 00:00:00 | CASH |  | MEMBERSHIP
Transaction # | C25 | C45 | M25 | M45
1 | 6 |  |  | 3
2 | 1
3 |  | 5 |  |  |  |  |  | Daily Statistics |  |  |  | [NAME]:
4 |  | 10
5 |  | 10 |  |  |  |  | # 25c Gallons sold: |  |  | 7
6 |  |  |  |  |  |  | # 45c Gallons sold: |  |  | 28
7
8 |  |  |  |  |  |  | Total Gallons sold: |  |  | 35
9
10 |  |  |  |  |  |  | # Cash transactions: |  |  | 5
11 |  |  |  |  |  |  | # Membership transactions: |  |  | 1
12
13 |  |  |  |  |  |  | Daily dollar total: |  |  | 14.35
14 |  |  |  |  |  |  | (Tie this to the cash register)
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Total: | 7 | 25 | 0 | 3
Spreadsheet: 166495d1341601872-verifiying-in-out-time-on-time-card-is-10hrs-time-card
Sheet: Time card

INPUT ONLY IN THE AREAS SHADED IN BLUE
EMPLOYEE NAME |  |  |  |  |  |  |  | DEPARTMENT/POSITION |  |  |  |  |  |  |  | WEEK ENDING  (MUST be a Saturday)
Doe, John- FT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-29 00:00:00
 |  |  |  |  |  | NON-CLOCK HOURS
 |  |  |  |  |  | HOL | VAC | PER | SCK
2012-12-22 00:00:00 | DATE | TIME IN | MEALS | TIME OUT | TOTAL HOURS  WORKED | HOLIDAY    HOURS | VACATION      HOURS | PERSONAL     HOURS | SICK                  HOURS | [NAME] | DIFF  PAY | OTHER          HOURS | OTHER          CODES | HOURS OVER 8 IN A DAY | TOTAL HOURS PAID | EXPLANTION OF OVERTIME, FEES
SUNDAY | 2012-12-23 00:00:00 | 09:00:00 | 0 | 17:00:00 | 8 | 0 | 0 | 0 | 0 | Penalty | 0 | 0 | 0 | 0 | 8 |  |  |  | 8
MONDAY | 2012-12-24 00:00:00 | 01:00:00 | 0 | 17:00:00 | 16 | 0 | 0 | 0 | 0 |  | 6 | 0 | 0 | 8 | 16 |  |  |  | 8
TUESDAY | 2012-12-25 00:00:00 | 09:00:00 | 0 | 17:00:00 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 8 |  |  |  | 8
WEDNESDAY | 2012-12-26 00:00:00 | 09:00:00 | 0 | 17:00:00 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 8 |  |  |  | 8
THURSDAY | 2012-12-27 00:00:00 | 05:00:00 | 0 | 17:00:00 | 12 | 0 | 0 | 0 | 0 |  | 2 | 0 | 0 | 4 | 12 |  |  |  | 8
FRIDAY | 2012-12-28 00:00:00 | 09:00:00 | 0 | 17:00:00 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 8 |  |  |  | 8
SATURDAY | 2012-12-29 00:00:00 | 09:00:00 | 0 | 17:00:00 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 8 |  |  |  | 8
TOTAL HOURS |  |  |  |  | 68 | 0 | 0 | 0 | 0 |  | 8 | 0 | 0 | 12 | 68 |  |  |  | 56
The following codes are to be used to indicate the 'nature' of all absences. |  |  |  |  |  |  |  |  | PAID HOURS DETAIL-
The codes below are to appear in the 'OTHER CODES' column of the day (s) applicable. |  |  |  |  |  |  |  |  | 68 |  |  | TOTAL HOURS WORKED
 | OTHER | [NAME] |  | OTHER | [NAME] |  |  |  | 40 |  |  | TOTAL REGULAR STRAIGHT TIME HOURS
 | CODES |  |  | CODES
 | BRV | DEATH IN FAMILY |  | DISB | SHORT TERM DISABILITY |  |  |  | 0 |  |  | TOTAL NON-CLOCK HOURS
 | SCK | SICK DAY |  | F75 | UNION SHIFT DIFF.
 | [NAME] | JURY DUTY |  | DNP | DO NOT PAY |  |  |  | 28 |  |  | TOTAL OT HOURS @ TIME & A HALF
 |  |  |  |  |  |  |  |  | 8 |  |  | NIGHT DIFFERENTIAL |  |  |  | 68 | TOTAL PAID HOURS
EMPLOYEE'S SIGNATURE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-06 00:00:00
SUPERVISOR'S APPROVAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
Spreadsheet: 824843d1680886533-data-flow-from-main-sheet-to-another-tab-data-flow-from-main-sheet-to-other-tab-according-to-the-name-of-the-tab
Sheet: Hold

SR NO | ORDER DATE | AGEING | ORDER STATUS | CLIENT NAME | COUNTRY | CATEGORY | QTY | TOTAL order received | BALANCE order TO SOURCE | DELHI | CHD | CHENNAI | DLC | MUM CNF | PSK | TOTAL order received | BALANCE order TO SOURCE
3 | 2023-03-03 00:00:00 |  | Hold | GHI Corporation | India | Fan | 35 | 3 |  |  |  |  |  | 3
Spreadsheet: 834332d1687683202-sumifs-formula-to-sum-data-based-on-specific-criteria-sum-data-here-first-4-digits-are-the-same
Sheet: Sheet1

 |  |  |  |  |  |  |  | 1000/000 |  | 0
 |  |  |  |  |  |  |  | 1100/000 |  | 0
 |  |  |  |  |  |  |  | 1200/000 |  | 0
 |  |  |  |  |  |  |  | 1300/000 |  | 0
 | 1000/000 | Bequests and Donations |  |  |  |  |  | 1500/000 |  | 0
 | 1100/000 | Burial Fees |  |  |  |  |  | 2750/000 |  | 0
 | 1200/000 | Grave Maintenance |  |  |  |  |  | 2750/001
 | 1300/000 | Reserve Grave |  |  |  |  |  | 2750/006
 | 1500/000 | Tombstone Levies |  |  |  |  |  | 2760/000 |  | 0
 | 2750/000 | Interest Received |  |  |  |  |  | 2770/000 |  | 0
 | 2750/001 | Interest received YOCO |  |  |  |  |  | 3000/000 |  | 0
 | 2750/006 | Investec [PHONE] |  |  |  |  |  | 3000/002
 | 2760/000 | Insurance Claim |  |  |  |  |  | 3010/000 |  | 5255.07
 | 2770/000 | Other Income |  |  |  |  |  | 3100/000
 | 3000/000 | Accounting Fees |  |  |  |  |  | 3200/000 |  | 568.84
 | 3000/002 | Provision |  |  |  |  |  | 3221/000 |  | 120
 | 3010/000 | Admin Fees | 5255.066666666667 |  |  |  |  | 3225/000 |  | 3510
 | 3100/000 | Administration Fees |  |  |  |  |  | 3250/000 |  | 230.76
 | 3200/000 | Bank Charges | 568.8413333333334 |  |  |  |  | 3600/000
 | 3221/000 | Bookkeeping Fees | 120 |  |  |  |  | 3650/000 |  | 331.09
 | 3225/000 | Burial Expenses | 3510 |  |  |  |  | 3800/000 |  | 345.55
 | 3250/000 | Cleaning | 230.7633333333333 |  |  |  |  | 3800/003
 | 3600/000 | Donations |  |  |  |  |  | 3800/010
 | 3650/000 | Electricity & Water | 331.0866666666667 |  |  |  |  | 3800/011
 | 3800/000 | General Expenses |  |  |  |  |  | 3900/000 |  | 116.95
 | 3800/003 | Compassion Packs | 288 |  |  |  |  | 4150/000 |  | 266.67
 | 3800/010 | Protective Clothing | 42.01666666666667 |  |  |  |  | 4350/000 |  | 3406.87
 | 3800/011 | Laundry | 15.538 |  |  |  |  | 4350/001
 | 3900/000 | Interest Paid | 116.9466666666667 |  |  |  |  | 4350/002
 | 4150/000 | Motor Vehicle Expenses | 266.6666666666667 |  |  |  |  | 4350/004
 | 4350/000 | Repairs & Maintenance |  |  |  |  |  | 4350/005
 | 4350/001 | Building Repairs | 1061.018666666667 |  |  |  |  | 4350/006
 | 4350/002 | Electrical |  |  |  |  |  | 4350/009
 | 4350/004 | Fire Extinguishers | 9.966666666666667 |  |  |  |  | 4350/014
 | 4350/005 | Hardware  Locks & Keys |  |  |  |  |  | 4350/015
 | 4350/006 | Plumbing | 65.28133333333334 |  |  |  |  | 4350/016
 | 4350/009 | Weedkilling | 915.2086666666667 |  |  |  |  | 4350/023
 | 4350/014 | Garden Service | 266.6666666666667 |  |  |  |  | 4350/027
 | 4350/015 | Burglar Proofing |  |  |  |  |  | 4350/029
 | 4350/016 | Security | 1016.732 |  |  |  |  | 4600/000 | 1.45 | 1.45
 | 4350/023 | Tombstone Repairs | 72 |  |  |  |  | 4610/000 |  | 0
 | 4350/027 | Gate Installation & Plastering
 | 4350/029 | Equipmen Loudspeaker & Amplifier
 | 4600/000 | Telephone & Fax | 1.45
 | 4610/000 | Tombstones Erected
Spreadsheet: 854816d1704568358-excel-formula-to-textsplit-from-filter-function-output-test-textsplit
Sheet: Sheet1

Node | IP address | IP address1
ABC | 192.168.10.11 | 192.168.11.11 |  |  | Node | IP address | expected output
XYZ | 192.168.12.12 | 192.168.13.13\192.168.14.14 |  |  | XYZ |  | 192.168.12.12
 |  |  |  |  |  | 192.168.13.13 | 192.168.13.13
 |  |  |  |  |  |  | 192.168.14.14
 |  |  |  |  |  | 192.168.13.13
 |  |  |  |  |  | 192.168.14.14
Spreadsheet: 83006d1283016192-two-values-in-drop-down-list-issue_1-dynamicrangesanddatavalidation
Sheet: Sheet3

Products | Prod No. | Price | Description
Ice Cream | sdfd-334 | 3.2 | IceCream Desc |  | column A now uses the Products2 list in the data validation
Bread | 43g-44 | 1 | I eat bread |  | column B now uses a dynamic data validation formula
Car | 23433-je | 333222 | I have better car |  | to list only the items in Prices that match the choice made in column A
Sugar | 1234-se2 | 23 | Don't eat sugar |  | column C and D now show answers based on the column B selection
Spreadsheet: 830146d1684750588-distinct-values-based-on-multiple-criteria-distinct-values-based-on-multiple-criteria
Sheet: Sheet1

[NAME] | Include In List | Include In Team A | Include In Team B | Include In Team C |  | List | Team A | Team B | Team C | Everyone
Everyone | Yes | No | No | No
Team A | Yes | No | No | No |  | Team A | [NAME] | Simone | Hugh | Hugh
Team B | Yes | No | No | No |  | Team B | Shane | [NAME] | [NAME] | [NAME]
Team C | Yes | No | No | No |  | Team C |  |  |  | [NAME]
Hugh | Yes | No | No | Yes |  | Dwight |  |  |  | Rachel
[NAME] | Yes | No | Yes | No |  | Hugh |  |  |  | [NAME]
Lilly | No | No | No | No |  | [NAME] |  |  |  | Shane
[NAME] | No | No | No | No |  | [NAME] |  |  |  | Simone
Shane | Yes | Yes | No | No |  | Rachel |  |  |  | [NAME]
Rachel | Yes | Yes | No | No |  | [NAME]
Dwight | Yes | No | No | Yes |  | Shane
[NAME] | No | No | No | No |  | Simone
Simone | Yes | No | Yes | No |  | [NAME]
[NAME] | Yes | No | No | Yes
[NAME] | Yes | No | Yes | No
[NAME] | Yes | Yes | No | No
Yes | January | 1
No | February | 2
 | March | 3
 | April | 4
 | May | 5
 | June | 6
 | July | 7
 | August | 8
 | September | 9
 | October | 10
 | November | 11
 | December | 12
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: BUG_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: BUG
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 10187550 | 26402745
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 14374462 | 42702094
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 24562012 | 69104839
 | Purchases:
6 |  | 3rd Party / Inter Enron | -8205022 | -19561994
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -18849654 | -54228520
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 478761 | 1304213
 | Total Purchases: |  | -26575915 | -72486301
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -2784 | -5239
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 600000 | 1628106
 | Total Imbalances: |  | 597216 | 1622867
 | Storage:
17 |  | Injection (Sales to Stg) | 1679791 | 4720380
18 |  | W/D (Purchase from Stg) | -202671 | -563215
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -202671 | -563215
 | Total Storage: |  | 1477120 | 4157165
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -60433 | -153499.82
23 | Fuel: |  | -478761 | -1304213
 | Transport Expense:
24 |  | Commodity | 0 | -544443
25 |  | Demand | 0 | 159396
 | Total Transport Expense: |  | 0 | -385047
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 8066078.145100795
31 |  | Prior Month Book Balance | 0 | -6989410
 |  | Total MTM Income | 0 | 1076668.145100795
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -1092870
34 |  | Originations | 0 | 25711
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 39257
 |  | TOTAL INTRA-MTH
Spreadsheet: 191812d1352222215-production-process-with-two-products-calculation-of-the-end-date-book1
Sheet: Sheet1

Quantity | Strength |  | Start Date | Stock Out
26 | 10 |  | 2012-05-15 00:00:00 | 2012-05-21 00:00:00 |  |  |  | Date 0|Time (6am) | Cycle 1
18 | 30 |  |  |  |  |  |  | Date 0|Time (2pm) | Cycle 2
 |  | Start With | Cycle 1 |  |  |  |  | Date +1 |Time (6am) | Cycle 1
 |  |  |  |  |  |  |  | Date +1 |Time (2pm) | Cycle 2
 | Remainder (chk) |  | Date/Time | Cycle | Notes |  |  | Date +2 |Time (6am) | Cycle 1
 | 24 | 17 | 5/15/2012 6AM | Cycle 1 |  |  |  | Date +2 |Time (2pm) | Cycle 2
 | 22 | 16 | 5/15/2012 2PM | Cycle 2 |  |  |  | Date +3 |Time (6am) | Cycle 1
 | 20 | 15 | 5/16/2012 6AM | Cycle 1 |  |  |  | Date +3 |Time (2pm) | Cycle 2
 | 18 | 14 | 5/16/2012 2PM | Cycle 2 |  |  |  | Date +4 |Time (6am) | Cycle 1
 | 16 | 13 | 5/17/2012 6AM | Cycle 1 |  |  |  | Date +4 |Time (2pm) | Cycle 2 only five supply for 5 cycles left, please reorder
 | 14 | 12 | 5/17/2012 2PM | Cycle 2 |  |  |  | Date +5 |Time (6am) | Cycle 1
 | 12 | 11 | 5/18/2012 6AM | Cycle 1 |  |  |  | Date +5 |Time (2pm) | Cycle 2
 | 10 | 10 | 5/18/2012 2PM | Cycle 2 | Please Reorder, Supply for 5 cycles left |  |  | Date +6 |Time (6am) | Cycle 1
 | 8 | 9 | 5/19/2012 6AM | Cycle 1 |  |  |  | Date +6 |Time (2pm) | Cycle 2
 | 6 | 8 | 5/19/2012 2PM | Cycle 2 |  |  |  | Date +X |Time (6am) | Cycle 1 out of stock after this cycle, please refill
 | 4 | 7 | 5/20/2012 6AM | Cycle 1 |  |  |  | (end of this list, process would start again)
 | 2 | 6 | 5/20/2012 2PM | Cycle 2
 | 0 | 5 | 5/21/2012 6AM | Cycle 1 | Out of Stock after this cycle, Please Refill
 | -2 | 4
 | -4 | 3
 | -6 | 2
 | -8 | 1
 | -10 | 0
 | -12 | -1
 | -14 | -2
 | -16 | -3
Spreadsheet: 103476d1301228737-how-do-i-rearrange-reorder-100s-of-fields-without-manual-drag-sortinglist123
Sheet: Sheet1

Name: | 1 | this is the order you want |  |  |  |  |  | Name: | 1
Phone: | 3 |  |  |  |  |  |  | Phone: | 3
[NAME]: | 5 |  |  |  |  |  |  | [NAME]: | 5
Address: | 2 |  |  |  |  |  |  | Address: | 2
Fax: | 4 |  |  |  |  |  |  | Fax: | 4 |  | if you have spaces number them as well
Website: | 6 |  |  |  |  |  |  | Website: | 6
Name: | 7 | <<formula =b1+6 goes here and dragged down |  |  |  |  |  |  | 7
Phone: | 9 |  |  |  |  |  |  | Name: | 8 | <<=j1+7
[NAME]: | 11 |  |  |  |  |  |  | Phone: | 10
Address: | 8 |  |  | now sort by col b |  |  |  | [NAME]: | 12
Fax: | 10 |  |  |  |  |  |  | Address: | 9
Website: | 12 |  |  |  |  |  |  | Fax: | 11
Name: | 13 |  |  |  |  |  |  | Website: | 13
Phone: | 15 |  |  |  |  |  |  |  | 14
[NAME]: | 17 |  |  |  |  |  |  | Name: | 15
Address: | 14 |  |  |  |  |  |  | Phone: | 17
Fax: | 16 |  |  |  |  |  |  | [NAME]: | 19
Website: | 18 |  |  |  |  |  |  | Address: | 16
 |  |  |  |  |  |  |  | Fax: | 18
 |  |  |  |  |  |  |  | Website: | 20
Spreadsheet: 51347d1250943152-teacher-needs-help-with-an-evaluation-form-evaluatie-2e-graad-nieuw
Sheet: Blad2

 |  |  |  | 5 |  | 5 | 5 | 5 |  | 5
 |  |  |  | 5
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | 5 |  |  |  | 5
 |  |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  | 5 |  | 5 | 5 | 5 |  | 5
 |  |  |  |  |  | 15
 |  |  |  | 50
 |  |  |  | 0
 |  |  |  | 50
 |  |  |  | 50
 |  |  |  | 50
 |  |  |  | 0
 |  |  |  | 50
Spreadsheet: 67405d1268053875-using-circular-calculation-selectively-arb-calculator
Sheet: Sheet1

 | Odds | Stake/Liability | Win | Profit | Running Profit/Loss
Bet 1 (Lay) | 1.5 | 20 | 40 | -8.629999999998816 | -53043.36142857454
Bet 2 (Back) | 1.2 | 57.14999999999902 | 11.4199999999998 | -8.580000000000199
Required win |  | 40
Profit loss |  | -8.629999999998816
New required win |  | 48.62999999999882
Spreadsheet: 181715d1348130196-sumif-and-subtotal-sample-customer-spreadsheet
Sheet: Order Form

 |  |  |  |  |  |  |  |  |  | *Enter manually |  | Calculated
No. of Boxes/Bags |  |  |  |  |  |  |  |  | No. of Portions before substitutions
[NAME] | Standard | Green | Dairy | Large | Extra Veg | Cheese | Eggs |  | [NAME] | Standard | Green | Dairy | Large | Extra Veg | Cheese | Eggs | TOTAL
0 | 13 | 5 | 2 | 2 | 2 | 1 | 17 |  | 0 | 13 | 5 | 2 | 4 |  |  |  | 24 | Potatoes
 |  |  |  |  |  |  |  |  | 0 | 13 | 5 | 2 | 4 |  |  |  | 24 | Onions/Carrots
No. of Substitutions |  |  |  |  |  |  |  |  | 0 | 13 | 5 | 2 | 2 |  |  |  | 22 | Veg 1 | Spagetti squash
A | B | C | D | E | F | G |  |  | 0 | 13 | 5 | 2 | 2 |  |  |  | 22 | Veg 2 | Peppers
3 | 5 |  |  |  |  |  |  |  |  |  | 5 |  | 2 |  |  |  | 7 | Veg 3 | salad lvs
 |  |  |  |  |  |  |  |  |  |  | 5 |  | 2 |  |  |  | 7 | Veg 4 | cucumber
H | I | J | K | L | M |  |  |  |  |  |  |  |  | 1 |  |  | 1 | Veg 5 | celery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Veg 6 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Veg 7 | 0
A: Veg 3 for potatoes |  | E: Veg 4 for onions |  | I: Veg 4 for Veg 1 |  | M: Veg 5 for fruit/salad |  |  | 0 | 13 | 5 | 2 | 4 |  |  |  | 24 | Fruit/Salad - 0.5kg
B: Veg 3 for onions |  | F: Veg 4 for fruit/salad |  | J: Veg 4 for Veg 2 |  |  |  |  |  |  |  | 2 |  |  | 1 |  | 3 | Cheese - 0.25kg
C: Veg 3 for fruit/salad |  | G: Veg 3 for Veg 1 |  | K: Veg 5 for potatoes |  |  |  |  |  |  |  | 2 |  |  |  | 17 | 19 | Eggs - 1/2 dozen
D: Veg 4 for potatoes |  | H: Veg 3 for Veg 2 |  | L: Veg 5 for Veg 1 or 2
Order Weights/ Unit Equivalent & Prices |  |  |  |  |  |  |  |  |  |  |  | [NAME] (on a per box basis, assuming no substitutions)
Item |  |  | Supplier | Portion (Kg) | Weight OR No. of units |  | Leftovers | Cost (per) |  | Total Cost |  |  | [NAME] | Standard | Green | Dairy | Large | Xtra veg | Xtra eggs | TOTAL
Potatoes |  |  |  | 1 | 21 |  | 0 | 0 | Kg | 0 |  | Av box £ | #N/A | 5.45 | 7.821428571428571 | 9.375 | 10.375 | 1.25 | 1.375 | 35.64642857142857
Onions/Carrots |  |  |  | 0.5 | 12 |  | 0 | 0.5 | Kg | 6 |  | Costs | 0.125 | 0.25 | 0.25 | 3.09 | 0.5 | 0 | 0.68 | 4.895
Veg: |  |  |  |  |  |  |  |  |  |  |  | Gross | #N/A | 5.2 | 7.571428571428571 | 6.285 | 9.875 | 1.25 | 0.695 | 30.87642857142857
1 | Spagetti squash |  |  | 0.5 | 11 |  |  | 0 | Kg | 0 |  | % | #N/A | 0.9541284403669725 | 0.9680365296803652 | 0.6704 | 0.9518072289156626 | 1 | 0.5054545454545454 | 0.8661857529305681
2 | Peppers |  |  | 0.4 | 8.8 |  |  | 0 | Kg | 0
3 | salad lvs |  |  |  | 0 | 12 |  | 0 | Unit | 0
4 | cucumber |  |  | 0.2 | 1.4 | 6 |  | 0 | Unit | 0
5 | celery |  |  | 0.5 | 0.5 |  |  | 0 | Kg | 0
6 |  |  |  |  | 0 |  |  |  | Kg | 0
7 |  |  |  |  | 0 |  |  |  | Kg | 0
Fruit/Salad | tomatoes |  |  | 0.5 | 12 |  |  | 0 | Kg | 0
Cheese |  |  |  | 0.18 | 0.54 |  |  | 12 | Kg | 6.48
Eggs - box |  |  |  |  |  | 19 |  | 0.68 | Unit | 12.92
 |  |  |  |  |  |  |  |  | TOTAL | 25.4
 | Egg box calculations |  |  | Extra veg calculations
 | 18 | 1/2 dozen |  | 2 | 1 portion
 | 0 | 1/2 dozen |  | 0 | 2 portions
 | 2 | dozen |  | 0 | 3 portions
 | 0 | dozen
Spreadsheet: john_griffith__15649__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.2 | 0.37 | 0.4 | 0.534199999999995 | -0.005699999999999372
 | N | 4.25 | 0.64 | 0.67 | 0.5308999999999973 | -0.00689999999999924
 | Q | 4.35 | 0.85 | 0.89 | 0.5466999999999966 | 0.006299999999999306
 | U | 4.35 | 1.03 | 1.05 | 0.550599999999997 | 0.006299999999999306
 | V | 4.4 | 1.18 | 1.23 | 0.5675999999999957 | 0.01409999999999845
 | X | 4.6 | 1.365 | 1.39 | 0.5654999999999972 | 0.01139999999999874
 | Z | 4.75 | 1.56 | 1.61 | 0.5818999999999955 | 0.01499999999999835
 | F | 4.85 | 1.7 | 1.75 | 0.5818999999999966 | 0.01049999999999884
 | G | 4.7 | 1.75 | 1.79 | 0.581299999999997 | 0.01259999999999861
 | H | 4.55 | 1.59 | 1.66 | 0.524599999999997 | 0.01019999999999888
 | J | 4.2 | 1.2 | 1.28 | 0.4126999999999971 | 0.008699999999999042
 | K | 4.15 | 1.1 | 1.22 | 0.3796999999999986 | 0.01199999999999868
 |  |  | 2001-05-09 12:37:39.020000
Spreadsheet: 32579d1228765858-relative-formula-copied-across-worksheets-running-total
Sheet: 3

 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
Total to day |  | 50 | 55 |  |  | 60 | 65
Total to Date |  | 80 | 90 |  |  | 100 | 110
 |  | The   1   in this formula refers to sheet 1 I need it to change to sheet  2  when I copy it. I don't need it to be absolute, I need it relative.
Spreadsheet: 836120d1689102258-shortened-days-of-the-week-formula-to-follow-days-on-rota-template
Sheet: Staff Names

1 |  | D | 4
2 |  | N | 9
3 |  | D | 10
4 |  | D | 12
5 |  | D | 6
6 |  | N | 5
7 |  | D | 11
8 |  | D | 1
9 |  | D | 2
10 |  | D | 3
11 |  | D | 8
12 |  | D | 7
 |  | D | 1 | F
 |  | D | 2 | F
 |  | D | 4 | F
 |  | D | 3 | F
 |  | N | 5 | F
 |  | D | 6 | M
 |  | D/N | 7 | M
 |  | N | 8 | F
 |  | D | 9 | F
 |  | D/N | 10 | F
Spreadsheet: 33649d1230135432-grouping-question-list-name-example
Sheet: Sheet1

1096 | 1 | ALIMANESTIANU
1096 | 3 | ALIMANESTIANU
1096 | 4 | ALIMANESTIANU
1096 | 5 | ALIMANESTIANU
5723 | 2 | [NAME]
6282 | 1 | ALVAREZ
1019 | 2 | ANGNEY
5534 | 1 | ANNESE
5534 | 2 | ANNESE
5534 | 3 | ANNESE
5534 | 4 | ANNESE
9607 | 2 | ANTLER
9607 | 3 | ANTLER
2383 | 2 | [NAME]
5867 | 1 | ARAUZ
5867 | 2 | ARAUZ
4152 | 1 | ARENA
4152 | 3 | ARENA
5723 | 1 | ARGUETA
5723 | 3 | [NAME]
1096 | 2 | MACA
1019 | 3 | MATSUMOTO
9607 | 1 | NEWELL ANTLER
2383 | 1 | [NAME]
Spreadsheet: 274552d1383147979-finding-value-using-formulas-functions-or-macros-in-intersection-of-2-data-series-in-graph-example_book_reattachted
Sheet: EXAMPLE3

 | DATA SERIE1
 | DATA FOR BLACK  LINE
 | Y AXE | X AXE
 | 76.19999999999999 | 100
 | 63.5 | 58.88586645340663
 | 50.8 | 55.66594015577746
 | 38.09999999999999 | 49.9469665823764
 | 25.4 | 45.23722363957552
 | 19.05 | 36.89905628675968
 | 12.5 | 29.49905628675968
 | 9.5 | 25.09905628675968
 | 4.75 | 17.69905628675969
 | 2 | 12.99905628675969
 | 0.42 | 7.999056286759686
 | 0.075 | 2.699056286759686
 |  |  |  |  | data for red vertical line
 |  |  | NUMBER THAT I WANT  TO FIND  AUTOMATICALLY USING FUNCTIONS  FORMULAS OR [NAME] |  | 65 |  | 0 | 60 | DATA SERIE 2
 |  |  |  |  | THIS NUMBER  IS THE X VALUE FOR WHICH THE Y VALUE FOR THE SERIE1 IS 60 |  |  | NOTE:VALUES IN X AXE IS IN INVERSE ORDER THE SCALE OF X AXE IS IN LOG BASE 10
Spreadsheet: 760207d1640070548-how-to-find-a-date-if-it-falls-between-a-range-of-date-dummy
Sheet: Sheet2

SUBJID | V3 | V5 | V7 | V9 | V12 | V21 | V801 | V802 | V997
1001 | 2019-12-17 00:00:00 | 2020-02-10 00:00:00 |  | 2020-06-04 00:00:00 | 2020-08-25 00:00:00 | 2021-05-04 00:00:00 | 2021-06-01 00:00:00 |  | 2020-02-10 00:00:00
1004 | 2019-12-17 00:00:00 | 2020-02-11 00:00:00 | 2020-04-07 00:00:00 | 2020-06-03 00:00:00 | 2020-08-25 00:00:00 | 2021-05-06 00:00:00 | 2021-07-06 00:00:00
1005 | 2019-12-19 00:00:00 | 2020-02-13 00:00:00 | 2020-04-09 00:00:00 | 2020-06-04 00:00:00 | 2020-08-27 00:00:00 | 2021-05-05 00:00:00 | 2021-06-28 00:00:00
1006 | 2019-12-19 00:00:00 | 2020-02-11 00:00:00 |  | 2020-06-02 00:00:00 | 2020-08-25 00:00:00 | 2021-05-04 00:00:00 | 2021-06-03 00:00:00 |  | 2020-02-11 00:00:00
1007 | 2019-12-20 00:00:00 | 2020-02-18 00:00:00 | 2020-04-10 00:00:00 | 2020-06-08 00:00:00 | 2020-09-04 00:00:00 | 2021-05-07 00:00:00 | 2021-06-04 00:00:00
1008 | 2019-12-19 00:00:00 | 2020-02-10 00:00:00 |  | 2020-06-01 00:00:00 | 2020-08-25 00:00:00 | 2021-05-19 00:00:00 | 2021-06-14 00:00:00 |  | 2020-02-10 00:00:00
1009 | 2019-12-24 00:00:00 | 2020-02-18 00:00:00 | 2020-04-14 00:00:00 | 2020-06-09 00:00:00 | 2020-09-01 00:00:00 | 2021-05-18 00:00:00
1010 | 2019-12-20 00:00:00 | 2020-02-14 00:00:00 | 2020-04-08 00:00:00 | 2020-06-03 00:00:00 | 2020-08-26 00:00:00 | 2021-05-05 00:00:00
 |  |  |  |  | If V3 date falls between V3 and V5 of the sheet1 then NAR. If it falls on or after V5 of sheet1 then issue. If V5 date falls between V5 and V7 of the sheet1 then NAR. If it falls on or after V7 of sheet1 then issue. If any V is blank then should show a msg that this V is missing. (Like 1001 V7 missing so when we check V7 date, then msg should come V7 missing in sheet2)