tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T14

Boeing Tour - AM |  |  |  |  | 2009-05-21 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 059a7a2d-57c7-4ae4-825d-3da2ac143ade
Sheet: Sheet1

Bid #12-017 POLICE UNIFORMS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | GST PUBLIC SAFETY SUPPLY | CPR SAVERS & FIRST AID SUPPLY | TARRANT COUNTY PRICING
250 EACH  -  8436 Super shirts L/S – or equivalent | 76.95 | 106.39 | 63.72
400 EACH  -  8446 Super shirt – S/S – or equivalent | 66.95 | 89.59 | 60.48
500 EACH  -  8565 Side-Pocket Trouser – or equivalent | 82.95 | 111.99
50 EACH  -  8135 Knit Short Sleeve Zippered Shirt (Bike Patrol) | 51.95 | 72.79
160 EACH  -  8471 Streetshirt L/S – or equivalent | 50.95 | 72.79
400 EACH  -  8472 Streetshirt – S/S – or equivalent | 42.95 | 61.59
200 EACH  -  8470 ARMORSKIN Vest Carrier – or equivalent | 78.95 | 106.39
100 EACH  -  174 ARMORSKIN SUSPENSION SYSTEM | 34.95 | NO BID
TOTAL | 486.6 | 621.53
TOTAL WITH QUANTITIES | 134707 | 179628.1
NO BID: UNIFORMS, INC.
 |  |  | 36% OFF OF Blauer 2011 price list
Spreadsheet: 703692d1605115277-sum-combining-data-from-more-than-one-tables-book1
Sheet: Sheet1

POs
po id | date | customer |  | customer | item id | lookup | [NAME]
po1 | 2020-11-01 00:00:00 | cus-B |  | cus-A | it-1
po2 | 2020-11-02 00:00:00 | cus-A |  | cus-A | it-2
PO lines
po id | item id | quantity
po1 | it-1 | 2
po1 | it-2 | 5
po2 | it-1 | 20
Spreadsheet: 112700d1308742248-improve-this-sheet-examplehelp
Sheet: Sheet1

Date | Day | Start | Finish | Hrs | Wage | Total Hrs | Total Wage |  | Hrly Rate
2011-06-06 00:00:00 | Monday | 17:00:00 | 02:00:00 |  |  |  |  |  | 1
2011-06-07 00:00:00 | Tuesday | 17:00:00 | 01:30:00
2011-06-08 00:00:00 | Wednesday | 17:00:00 | 22:30:00
2011-06-09 00:00:00 | Thursday | 17:00:00 | 00:30:00
2011-06-10 00:00:00 | Friday | 19:00:00 | 22:30:00
2011-06-11 00:00:00 | Saturday
2011-06-12 00:00:00 | Sunday
2011-06-13 00:00:00 | Monday | 17:00:00 | 02:00:00
2011-06-14 00:00:00 | Tuesday | 18:00:00 | 22:30:00
2011-06-15 00:00:00 | Wednesday | 18:30:00 | 22:30:00
2011-06-16 00:00:00 | Thursday | 17:00:00 | 02:00:00
2011-06-17 00:00:00 | Friday | 19:00:00 | 22:30:00
2011-06-18 00:00:00 | Saturday
2011-06-19 00:00:00 | Sunday | 08:00:00 | 18:00:00
2011-06-20 00:00:00 | Monday | 16:30:00 | 01:30:00
2011-06-21 00:00:00 | Tuesday | 18:00:00 | 22:30:00
2011-06-22 00:00:00 | Wednesday
2011-06-23 00:00:00 | Thursday
2011-06-24 00:00:00 | Friday
2011-06-25 00:00:00 | Saturday
2011-06-26 00:00:00 | Sunday
2011-06-27 00:00:00 | Monday
2011-06-28 00:00:00 | Tuesday
2011-06-29 00:00:00 | Wednesday
2011-06-30 00:00:00 | Thursday
2011-07-01 00:00:00 | Friday
2011-07-02 00:00:00 | Saturday
2011-07-03 00:00:00 | Sunday
2011-07-04 00:00:00 | Monday
2011-07-05 00:00:00 | Tuesday
2011-07-06 00:00:00 | Wednesday
2011-07-07 00:00:00 | Thursday
2011-07-08 00:00:00 | Friday
2011-07-09 00:00:00 | Saturday
2011-07-10 00:00:00 | Sunday
2011-07-11 00:00:00 | Monday
2011-07-12 00:00:00 | Tuesday
2011-07-13 00:00:00 | Wednesday
2011-07-14 00:00:00 | Thursday
2011-07-15 00:00:00 | Friday
2011-07-16 00:00:00 | Saturday
2011-07-17 00:00:00 | Sunday
2011-07-18 00:00:00 | Monday
2011-07-19 00:00:00 | Tuesday
2011-07-20 00:00:00 | Wednesday
2011-07-21 00:00:00 | Thursday
2011-07-22 00:00:00 | Friday
2011-07-23 00:00:00 | Saturday
2011-07-24 00:00:00 | Sunday
2011-07-25 00:00:00 | Monday
2011-07-26 00:00:00 | Tuesday
2011-07-27 00:00:00 | Wednesday
2011-07-28 00:00:00 | Thursday
2011-07-29 00:00:00 | Friday
2011-07-30 00:00:00 | Saturday
2011-07-31 00:00:00 | Sunday
2011-08-01 00:00:00 | Monday
2011-08-02 00:00:00 | Tuesday
2011-08-03 00:00:00 | Wednesday
2011-08-04 00:00:00 | Thursday
2011-08-05 00:00:00 | Friday
2011-08-06 00:00:00 | Saturday
2011-08-07 00:00:00 | Sunday
2011-08-08 00:00:00 | Monday
2011-08-09 00:00:00 | Tuesday
2011-08-10 00:00:00 | Wednesday
2011-08-11 00:00:00 | Thursday
2011-08-12 00:00:00 | Friday
2011-08-13 00:00:00 | Saturday
2011-08-14 00:00:00 | Sunday
2011-08-15 00:00:00 | Monday
2011-08-16 00:00:00 | Tuesday
2011-08-17 00:00:00 | Wednesday
2011-08-18 00:00:00 | Thursday
2011-08-19 00:00:00 | Friday
2011-08-20 00:00:00 | Saturday
2011-08-21 00:00:00 | Sunday
2011-08-22 00:00:00 | Monday
2011-08-23 00:00:00 | Tuesday
2011-08-24 00:00:00 | Wednesday
2011-08-25 00:00:00 | Thursday
2011-08-26 00:00:00 | Friday
2011-08-27 00:00:00 | Saturday
2011-08-28 00:00:00 | Sunday
Spreadsheet: 3293c68e-f304-4c32-8686-babdd9a8d6c6
Sheet: Model Group

 | Model Group
 | Media Streaming |  | Format
 | 0001
 | 0003
 | 0005
 | 0006
 | 0008
 | 0101
 | 0102 | USB | Mostly FAT32, does detect and work with some NTFS
 | 0103
 | 0104
 | 0105
 | 0111
 | 0114 | DLNA
 | 0121
 | 0122
 | 0123 | DLNA
 | 0124 | DLNA
 | 0125
 | 0126
 | 0201
 | DLNA | Can find DLNA servers
 | USB
 | FAT32 only supports up to 4GB
Spreadsheet: 702677d1604480044-tracing-continuity-in-data-chart-info
Sheet: Sheet1

 |  | Loads | Load (Amperes) | Start time (min) | End time (min)
 |  | L1 | 40 | 0 | 180
 |  | L2 | 280 | 0 | 1
 |  | L3 | 60 | 1 | 120
 |  | [NAME] | 100 | 30 | 120
 |  | L5 | 80 | 30 | 60
 |  | L | 80 | 179 | 180
 |  |  | Period | Total amperes per period (Amperes)
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 3

 | Nov 16 | Nov 23 | Nov 30 | Dec 7 | Dec 14
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2530602 | 2534908 | 2544943 | 2535376 | 2559859
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared 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: 798577d1664557627-sumproduct-arrays-different-size-match-new
Sheet: match-1array

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1) |  |  |  |  |  | case-unsensitive
 |  |  |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0)))) |  |  |  |  |  | case-sensitive
grade |  |  |  | grade
A |  |  |  | A
A |  |  |  | B
B |  |  |  | b
C |  |  |  | C
D
a
F
A
A
B
B
D
A
B
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Imbal
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141715.48
2002-02-28 00:00:00
CBS Volume
 |  |  | 61661
Spreadsheet: 691418d1597683702-golf-scoring-system_automatically-highlighting-cells-20200813-excel-help-file-golf_tragic-
Sheet: Calculations

 | Dirab Golf Society (DGS) Gross Scores
 | Name
 |  |  | Rounds (20 [NAME]) | Counting  Rounds | Total of lowest Counting Rounds | Adj Gross | H'cap Diff | Index |  | Playing H'cap
 | 1 |  |  |  |  |  |  |  |  |  | Dirab (17)
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | [NAME] (3)
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24 |  |  |  |  |  |  |  |  |  | Dirab (15)
Spreadsheet: 829537d1684302333-check-whether-the-childs-corresponding-parent-value-is-present-in-dataset-example
Sheet: Sheet1

MetaData |  |  |  | DATASET
Child | Parent |  |  | SKU | Trait | P/C
Fruit | Apple |  |  | Delmonte | [NAME] | P
Red | Apple |  |  | Delmonte | Soft | C | YES | [NAME] checks if the parent value for [NAME] (banana) is present in column F where the corresponding value is [NAME]
Crunchy | Apple
Fruit | Pear |  |  | [NAME] | Carrot | P
Green | Pear |  |  | [NAME] | Crunchy | C | YES | [NAME] checks if the parent value for crunchy (either apple,carrot,pear) is present in column F where the corresponding value is [NAME]
Crunchy | Pear
Fruit | [NAME]
Soft | [NAME]
Veg | Carrot |  |  | RedDelish | Red | C | NO | [NAME] returns NO because the parent value red is not in column F, where the corresponding value in column E is RedDelish. Adding the below values to column E and F will change the formula result to YES
Orange | Carrot |  |  | RedYummy | Apple | P
Crunchy | Carrot
 |  |  |  |  |  |  |  | SKU | Trait | P/C
 |  |  |  |  |  |  |  | RedDelish | Apple | P
Spreadsheet: 82885d1282891179-search-button-using-macro-rammohan
Sheet: VIJAY KUMAR

 | ←← | VIJAY KUMAR
 | NATURE OF WORK | 7.1 Home Theatre System |  |  |  |  |  | Cabling work & ceiling mount work completed
 | APP VALUE
 | SALES INCHARGE
 | CLIENTS REPRESENTATE | Veraih([PHONE])
 | ARCHITECT
 | PO DETAILS
 | SERVICE COORDINATES
 | SITE CONDITION
 | DELIVERY SCHEDULE
 | STATUS ON DAY TO DAY BASIS | Cabling work & ceiling mount completed
 | ROUGH ESTIMATE OF THE MATERIAL
 | 1. Ceiling Mount | 1No
 | 2.Monster HDMI Cable HD 700 35ft | 10mt
 | 3.Monster XP-500 Speaker cable | 42mt
 | 4.DAC Video cable ARR691C | 10mt
 | 5.Euro Audio cable | 7mt
 | ←←
Spreadsheet: 5cdf2564-6fae-4f01-827c-b1945b65b50c
Sheet: Lists

% Life Left | Overall Condition | Description | Consequence | Description | Funding Source
0 | 0 | Deplorable | 0 | No Impact | Bonding
0.1 | 1 | Very bad | 1 |  | Chapt 90/ Alt Funds
0.2 | 2 | Bad | 2 | Small Impact | Bonding/MSBA
0.3 | 3 | Poor | 3 |  | CDBG Eligible
0.4 | 4 | Slightly below average | 4 |  | Alternate Funding
0.5 | 5 | Average | 5 | Moderate Impact | CPA Eligible
0.6 | 6 | Slightly above average | 6 |  | Energy Stab. Fund
0.7 | 7 | Fair | 7 |  | Enterprise Funds
0.8 | 8 | Good | 8 | High Impact | Grant
0.9 | 9 | Very good | 9 |  | Other
1 | 10 | Excellent | 10 | Very High Impact
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C7

Local 7
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-02-24 00:00:00
[NAME]: | 5
Réservé:
Prix: | 100
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 696507d1600865357-array-formula-needs-a-condition-added-to-it-pesky-array-ans
Sheet: Dashboard

Start date | End date | Number of items | Target
 |  |  | All
Results
Spreadsheet: 116346d1311772431-count-using-left-function-in-range-count
Sheet: Sheet1

Order no | Post code | Don't want to use this column for count |  |  |  | First 4 Digits of Postcode | Count
1609272 | HA0 1NR | HA0 |  |  |  | HA0 | 1
1610513 | HA8 5EQ | HA8 |  |  |  | HA8 | 6
1609327 | HA8 6LD | HA8 |  |  |  | HA9 | 1
1611007 | HA8 6LD | HA8 |  |  |  | NW10 | 14
1609432 | HA8 7BZ | HA8 |  |  |  | NW2 | 9
1609422 | HA8 7BZ | HA8 |  |  |  | NW27 | 1
1609419 | HA8 7BZ | HA8 |  |  |  | NW4 | 2
1610400 | HA9 9DR | HA9 |  |  |  | NW6 | 2
1610176 | NW101BY | NW10 |  |  |  | NW7 | 1
1608924 | NW101EJ | NW10 |  |  |  | NW9 | 9
1610133 | NW101EJ | NW10 |  |  |  | SW1W | 2
1609836 | NW102ED | NW10 |  |  |  | SW7 | 1
1608811 | NW102ED | NW10 |  |  |  | UB6 | 3
1608936 | NW102JD | NW10 |  |  |  | W106 | 1
1610164 | NW102PB | NW10 |  |  |  | W5 4 | 1
1609825 | NW102PB | NW10
1609837 | NW102PB | NW10
1608807 | NW102PB | NW10
1608730 | NW102PB | NW10
1610016 | NW102PB | NW10
1609828 | NW102QU | NW10
1608836 | NW106QU | NW10
1608805 | NW2 1BG | NW2
1609975 | NW2 1LX | NW2
1608916 | NW2 2DP | NW2
1610184 | NW2 3LS | NW2
1610043 | NW2 3LS | NW2
1608931 | NW2 5TG | NW2
1608920 | NW2 6AE | NW2
1609973 | NW2 6ND | NW2
1610146 | NW2 6RX | NW2
1609820 | NW27HJ | NW27
773680 | NW4 1PS | NW4
1610467 | NW4 1QD | NW4
1608802 | NW6 2DT | NW6
1610005 | NW6 2HG | NW6
1609047 | NW7 2HU | NW7
1610405 | NW9 0EQ | NW9
1610601 | NW9 0EW | NW9
775545 | NW9 5BE | NW9
1608928 | NW9 7AA | NW9
1608926 | NW9 7AA | NW9
1610590 | NW9 7EB | NW9
1610604 | NW9 7EB | NW9
1609030 | NW9 7EB | NW9
1609429 | NW9 8UP | NW9
1608840 | SW1W9ET | SW1W
1608610 | SW1W9ET | SW1W
1608803 | SW7 1LN | SW7
1609223 | UB6 7LA | UB6
1609277 | UB6 7PP | UB6
1609316 | UB6 7QB | UB6
1608798 | W106TP | W106
1609185 | W5 4HB | W5 4
Spreadsheet: 813189d1673606060-if-with-if-and-annual-leave-entitlement-for-excelforum
Sheet: Sheet1

SURNAME | FIRST NAME | Base A/L | Bank Holiday | Extra Bank Holiday | Continual Service Annual Leave | Total Annual Leave | Work Time Equivalent | Annual Leave (Hours) | NHS continuous service date | 2023-03-31 00:00:00
Staff | Member | 27 | 8 | 2 |  |  | 0.4 |  | 2014-04-07 00:00:00
Total Staff on [NAME]
Spreadsheet: 753212d1635302588-need-help-with-formula-that-will-divide-one-cell-to-another-cell-based-on-an-exact-match-test1
Sheet: Sheet1

Player | Team | Pos | GMs | EP | %Team |  | Team | EP
AJ Brown | TEN | WR | 6 | 69.3 |  |  | TEN
AJ Dillon | GB | RB | 7 | 42.9 |  |  | GB
AJ Green | ARI | WR | 7 | 64.8 |  |  | ARI
[NAME] | GB | RB | 7 | 97.8 |  |  | WAS
[NAME] | GB | QB | 7 | 140.4 |  |  | MIA
[NAME] | WAS | WR | 7 | 46.1 |  |  | MIN
[NAME] | MIA | TE | 5 | 17.5 |  |  | NO
[NAME] | MIN | WR | 6 | 95.6 |  |  | DEN
[NAME] | NO | TE | 5 | 17.4
[NAME] | DEN | TE | 4 | 20.9
Spreadsheet: 86111d1286131335-calculation-of-percentage-book1
Sheet: Sheet1

 |  |  |  |  | 0.25
 |  |  |  |  | 0.5
 |  |  |  |  | 0.75
 |  |  | Description and size of the goods | original retail price | Reduced retail price | Diffrences | quantity | Reduction Value
 |  |  |  | 10 |  | 10 | 11 | 110
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total | 110
Spreadsheet: 822326d1679266282-shopping-list-generator-find-recipe-in-table-return-ingredients-and-amounts-shopping-list-demo
Sheet: Table Ingredients

Meal | Item | Quantity |  |  | Sum of Quantity | Column Labels
Sausage and [NAME] | Sausage | 2 |  |  | Row Labels | Fish | Mushroom (g) | Pasta (g) | Potatoes | Sausage | Grand Total
Sausage and [NAME] | Potatoes | 3 |  |  | Fish and Chips | 1 |  |  | 3 |  | 4
Fish and Chips | Fish | 1 |  |  | [NAME] |  | 240 | 150 |  |  | 390
Fish and Chips | Potatoes | 3 |  |  | Sausage and [NAME] |  |  |  | 3 | 2 | 5
[NAME] | Mushroom (g) | 240 |  |  | Grand Total | 1 | 240 | 150 | 6 | 2 | 399
[NAME] | Pasta (g) | 150
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: Inactive

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
2 | 2023-03-02 00:00:00 |  | Inactive | DEF Corporation | India | Tubelights | 25 | 2 |  |  |  | 1 | 1
Spreadsheet: 840870d1693081218-calculate-of-months-each-year-in-a-date-range-forum-solution-
Sheet: Sheet1

Start | End | # of Months | # of Months Each Year
Date | Date | to Forecast | 2023
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
Spreadsheet: 767041d1644253252-what-would-cause-excel-to-pause-its-calcs-when-it-is-set-to-automatic-livecards
Sheet: Diamondbacks

Hitters |  |  | Pitchers
UIG | NAME |  | UIG | NAME
Spreadsheet: 859770d1708017687-productif-formula-with-multiple-criteria-productif-formula-with-multiple-criteria
Sheet: Sheet1

 |  |  |  |  |  |  | Classes for scores
 |  | Return | Score |  |  |  | Bottom limit | Upper limit |  | Wrong answer |  |  | Asnwer should be (calculated "by hand")
 |  | 0.05 | -0.35 |  |  |  | -0.34 | -0.29
 |  | -0.02 | -0.34 |  |  |  | -0.29 | -0.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return in % if criteria are dropped
 |  | 0.03 | -0.33 |  |  |  | -0.24 | -0.1900000000000001 |  |  |  | 1 |  | Class is outside of range. Instead, the wrong formula calulates the result as if no restriction applied
 |  | -0.0025 | -0.32
 |  | 0.02 | -0.31
 |  | 0.01 |  |  |  |  | The aim is to calulate the return if the score falls into the range given by the class boundaries
 |  | 0.0057
 |  | -0.02
 |  | 0.0072
 |  | -0.0092
Spreadsheet: 87224d1287070297-if-and-and-or-maybe-if-and-or-example-workbook
Sheet: Sales log

Name | Event | Full Price | No. | Concession | No. | Total cost | Payment method
 | Elif Shafak and [NAME]
 | Book Festival Launch Party |  |  |  | 2
Spreadsheet: 482070d1474888687-new-empty-table-for-each-element-of-dropdown-list-new-city-example
Sheet: Sheet1

City | Criteria/Date | Oct-15 | Nov-15 | Dec-15 | Jan-16 | Feb-16 | [NAME] | Apr-16 | [NAME] | Jun-16 | [NAME] | Aug-16 | Sep-16
Cairo | Electricity | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Usage | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | invoice | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Water | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Usage | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Disposal Amount | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Water Service Charge | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Waste | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Paper and Cardboard | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | General Waste | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
Hurghada | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
aaa | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
bbb | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
[NAME] | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
ddd | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
[NAME] | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
ggg | Electricity
 | Usage
 | invoice
 | Water
 | Usage
 | Disposal Amount
 | Water Service Charge
 | Waste
 | Paper and Cardboard
 | General Waste
Spreadsheet: 724590d1616251146-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Pemba - Afungy

 |  | CENTROS DE CUSTOS
 |  | PEMBA ( Afungy )
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-08-31 00:00:00 | Grafica | 27 / 2933 | 3150 | Auto Colantes TAG
 |  | 2020-08-20 00:00:00 | Combustivel |  | 32562 | Camiao Grua Leasing
 |  | 2020-08-20 00:00:00 | Despesas de Viagem / Combustivel |  | 36348 | Camiao Grua Leasing
 |  | 2020-08-11 00:00:00 | HST | 1054 | 61276.88 | Extintores
 |  | 2020-07-24 00:00:00 | Combustivel |  | 15756.47 | Low Bad 10 Ton
 |  | 2020-07-24 00:00:00 | Despesas de Viagem / Combustivel |  | 55000 | Low Bad 10 Ton
 |  | 2020-08-20 00:00:00 | [NAME] |  | 33397.37 | Logistica
 |  | 2020-07-28 00:00:00 | Revisao |  | 49611.79 | TLB 315 SK
 |  | 2020-07-28 00:00:00 | [NAME] |  | 18645.52 | TLB 315 SK
Spreadsheet: 716243d1612117588-help-with-formula-calculating-spherical-equivalent-spherical-equivalent-example-1-
Sheet: Sheet1

 |  |  |  |  | Sphere | Cylinder | Spherical Equivalent
 |  |  |  |  | 2 | -1 | 1.5
 |  |  |  |  | -2 | -1 | -2.5
 |  |  |  |  | 8 | 4 | 6
 |  |  |  |  | 3 | -2 | 2
 |  |  |  |  | -2 | -1 | -2.5
Spreadsheet: 154905d1336594532-match-two-category-matching
Sheet: Sheet1

 |  | Schedule-1
 |  | ID# | Name
 |  | 1 | A
 |  | 2 | B
 |  | 3 | C
 |  | 4 | D
 |  | 5 | E
 |  | Schedule-2
 |  | ID# | Name | Answe
 |  | 1 | A | YES
 |  | 4 | D | YES
 |  | 3 | Z | NO
 |  | 5 | F | No
 |  | 9 | R | NO
 |  | 5 | E | YES