tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115856d1311338083-index-match-where-one-look-up-value-is-a-date-sample-workbook
Sheet: Contracts Full Listing

Key | Price | Date
123 | 100 | 2011-01-31 00:00:00
456 | 200 | 31/04/2011
789 | 300 | 2011-08-31 00:00:00
1011 | 400 | 2011-12-31 00:00:00
123 | 10 | 2011-01-01 00:00:00
456 | 20 | 2011-04-01 00:00:00
789 | 30 | 2011-08-01 00:00:00
1011 | 40 | 2011-12-01 00:00:00
123 | 50 | 2010-01-31 00:00:00
456 | 60 | 31/04/2010
789 | 70 | 2010-08-31 00:00:00
1011 | 80 | 2010-12-31 00:00:00
Spreadsheet: 696754d1600961397-counting-three-columns-whilst-ignoring-duplicates-in-one-of-the-columns-book1
Sheet: Values

Division | Computername | Operating System | User |  | Division | Operating System | Sum1 | Sum2
Business Unit 1 | Workstation 1 | Microsoft Windows 10 Enterprise | User 1 |  | Business Unit 1 | Microsoft Windows 10 Enterprise
Business Unit 1 | Workstation 1 | Microsoft Windows 10 Enterprise | User 2 |  | Business Unit 1 | Microsoft Windows 10 Pro
Business Unit 1 | Workstation 1 | Microsoft Windows 10 Enterprise | User 3 |  | Business Unit 2 | Microsoft Windows 10 Enterprise
Business Unit 1 | Workstation 2 | Microsoft Windows 10 Pro | User 1 |  | Business Unit 2 | Microsoft Windows 10 Pro
Business Unit 1 | Workstation 2 | Microsoft Windows 10 Pro | User 2 |  | Business Unit 3 | Microsoft Windows 10 Enterprise
Business Unit 1 | Workstation 2 | Microsoft Windows 10 Pro | User 3 |  | Business Unit 3 | Microsoft Windows 10 Pro
Business Unit 1 | Workstation 2 | Microsoft Windows 10 Pro | User 4
Business Unit 1 | Workstation 3 | Microsoft Windows 10 Enterprise | User 1
Business Unit 1 | Workstation 3 | Microsoft Windows 10 Enterprise | User 2
Business Unit 1 | Workstation 4 | Microsoft Windows 10 Pro | User 1
Business Unit 1 | Workstation 4 | Microsoft Windows 10 Pro | User 2
Business Unit 1 | Workstation 4 | Microsoft Windows 10 Pro | User 3
Business Unit 1 | Workstation 5 | Microsoft Windows 10 Pro | User 1
Business Unit 2 | Workstation 1 | Microsoft Windows 10 Pro | User 1
Business Unit 2 | Workstation 1 | Microsoft Windows 10 Pro | User 2
Business Unit 2 | Workstation 1 | Microsoft Windows 10 Pro | User 3
Business Unit 2 | Workstation 2 | Microsoft Windows 10 Enterprise | User 1
Business Unit 2 | Workstation 2 | Microsoft Windows 10 Enterprise | User 2
Business Unit 2 | Workstation 2 | Microsoft Windows 10 Enterprise | User 3
Business Unit 2 | Workstation 2 | Microsoft Windows 10 Enterprise | User 4
Business Unit 2 | Workstation 3 | Microsoft Windows 10 Pro | User 1
Business Unit 2 | Workstation 3 | Microsoft Windows 10 Pro | User 2
Business Unit 2 | Workstation 4 | Microsoft Windows 10 Enterprise | User 1
Business Unit 2 | Workstation 4 | Microsoft Windows 10 Enterprise | User 2
Business Unit 2 | Workstation 4 | Microsoft Windows 10 Enterprise | User 3
Business Unit 3 | Workstation 1 | Microsoft Windows 10 Pro | User 1
Business Unit 3 | Workstation 1 | Microsoft Windows 10 Pro | User 2
Business Unit 3 | Workstation 1 | Microsoft Windows 10 Pro | User 3
Business Unit 3 | Workstation 2 | Microsoft Windows 10 Enterprise | User 1
Spreadsheet: 42892d1241532515-summarizing-data-test
Sheet: Required

Job Number | Nominal Code | Description | Value
10001 | 100001 | Wages | 70
10001 | 100001 | Wages | 60
10001 | 100001 | Wages | 78.5
10001 | 100001 | Wages | 40
Spreadsheet: 774991d1648752901-range-h-h-transformed-into-h2-h63-formula-not-working-anymore-test
Sheet: SUBSCRIPTIONS

 | BILLED | BILLING YEAR |  |  | ONE-TIME | RECURRING | TOTAL HTVA | TOTAL TVAC | STATUS | *
 | Yes | 2022 |  |  | 2999 |  |  |  | à percevoir | website creation
 | Yes | 2022 |  |  |  |  |  |  | à percevoir | website maintenance
 | Yes | 2022 |  |  |  |  |  |  | à percevoir | domain name registration
 | No | 2023 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2023 |  |  |  |  |  |  | à percevoir | domain name renewals
 | No | 2024 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2024 |  |  |  |  |  |  | à percevoir | domain name renewals
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2025 |  |  |  |  |  |  | à percevoir | domain name renewals
 | Yes | 2022 |  |  | 2999 |  |  |  | perçu | website creation
 | Yes | 2022 |  |  |  |  |  |  | perçu | website maintenance
 | No | 2023 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2023 |  |  |  | 100 |  |  | à percevoir | automatic translations
 | No | 2024 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2024 |  |  |  | 100 |  |  | à percevoir | automatic translations
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2025 |  |  |  | 100 |  |  | à percevoir | automatic translations
 | Yes | 2022 |  |  | 8.46 |  |  |  | annulé | domain name registration
 | Yes | 2022 |  |  | 8.46 |  |  |  | perçu | domain name registration
 | Yes | 2022 |  |  | 8.46 |  |  |  | annulé | domain name registration
 | Yes | 2021 |  |  | 1599 |  |  |  | perçu | website creation
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
 | Yes | 2021 |  |  | 500 |  |  |  | perçu | website creation
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | No | 2023 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2024 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website creation
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | No | 2022 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2023 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2024 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
 | Yes | 2021 |  |  |  |  |  |  | perçu | website creation
 | Yes | 2021 |  |  |  |  |  |  | perçu | website maintenance
 | Yes | 2022 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2023 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2024 |  |  |  |  |  |  | à percevoir | website maintenance
 | No | 2025 |  |  |  |  |  |  | à percevoir | website maintenance
Spreadsheet: 9c7f20d6-05b0-44d5-b587-84c132058d2c
Sheet: Sheet1

Insurance Commissioner - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/19/2013 2:23:15 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 0401 | 0 | 0
Precinct 0402 | 65 | 65
Precinct 0403 | 69 | 69
Precinct 0411 | 13 | 13
Precinct 0415 | 0 | 0
Precinct 3608 | 89 | 89
Precinct 3609 | 28 | 28
Precinct 3610 | 21 | 21
Precinct 3612 | 45 | 45
Precinct 3614 | 28 | 28
Precinct 3616 | 26 | 26
TOTAL | 384 | 384
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 31107d1226865793-drop-down-boxes-eg
Sheet: Data

Data list |  | Cost |  | time
milk |  | 23 |  | 3
tea |  | 27 |  | 2
water |  | 31 |  | 1
beer |  | 35 |  | 2
coke |  | 39 |  | 3
lemonade |  | 43 |  | 6
Spreadsheet: 22534b16-e951-4e08-beae-be50640b19ff
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
MILK | Test | MILK | Milk, IgE | Milk, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
MILK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MILK | Result | MILK | Milk, IgE | Milk, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7258-7 | Cow milk Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 6

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 0 | 0 | 20 | 0 | 44 | 32 | 64
CONFLICTS | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ID'S | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ISA | 575 | 374 | 333 | 397 | 125 | 360.8 | 1804
Spreadsheet: 95435d1295023492-conditional-formating-testprod
Sheet: Sheet2

EndDate | 2011-01-15 00:00:00 | 2011-01-31 00:00:00 | 2011-02-15 00:00:00 | 2011-02-28 00:00:00 | 2011-03-15 00:00:00 | 2011-03-31 00:00:00
Student | GPA | GPA | GPA | GPA | GPA | GPA
[NAME] | 0.25 | 0.27 | 0.3 | 0.32 | 0.29 | 0.29
[NAME] | 0.11 | 0.25 | 0.29 | 0.3 | 0.3 | 0.29
[NAME] | 0.29 | 0.299 | 0.3 | 0.3 | 0.29 | 0.3
[NAME] | 0.3 | 0.28 | 0.31 | 0.29 | 0.29 | 0.3
TOTAL
Yellow=1 Action
Orange=2 Action
Red=3 Action
Spreadsheet: 748789d1632346619-sum-across-multiple-sheets-with-sheets-names-as-references-demo
Sheet: Denver

 | Showrooms
 | Round Up Floor
 | Actual
 | [NAME] Target
 | Lab
 | Shape |  |  | County by City | Count by City
 | type 1 |  |  | 65 | 0.4676258992805755
 | Type 2 |  |  | 42 | 0.302158273381295
 | type 3 |  |  | 9 | 0.06474820143884892
 | type 4 |  |  | 10 | 0.07194244604316546
 | type 5 |  |  | 4 | 0.02877697841726619
 | type 6 |  |  | 6 | 0.04316546762589928
 | type 7 |  |  | 2 | 0.01438848920863309
 | type 8 |  |  | 1 | 0.007194244604316547
 | type 9 |  |  | 0 | 0
 | type 10 |  |  | 0 | 0
 | Calc Total | 1 | 1 | 139 | 1
Spreadsheet: 63417d1264344341-date-and-count-number-of-items-mtd-testrecap
Sheet: Data

Name | Job Type | Date
[NAME] | Code 01 | 2010-01-19 00:00:00
[NAME] | Code 01 | 2010-01-20 00:00:00
[NAME] | Code 01 | 2009-11-12 00:00:00
[NAME] | Code 01 | 2009-11-13 00:00:00
[NAME] | Code 01 | 2009-11-14 00:00:00
[NAME] | Code 01 | 2009-12-24 00:00:00
[NAME] | Code 02 | 2009-12-25 00:00:00
[NAME] | Code 02 | 2009-10-06 00:00:00
[NAME] | Code 02 | 2009-10-07 00:00:00
[NAME] | Code 02 | 2009-10-08 00:00:00
[NAME] | Code 02 | 2009-10-09 00:00:00
[NAME] | Code 02 | 2009-10-10 00:00:00
[NAME] | Code 02 | 2009-10-11 00:00:00
[NAME] | Code 02 | 2010-01-01 00:00:00
[NAME] | Code 01 | 2010-01-02 00:00:00
[NAME] | Code 01 | 2010-01-03 00:00:00
[NAME] | Code01 | 2010-01-04 00:00:00
[NAME] | Code 02 | 2009-10-15 00:00:00
[NAME] | Code 01 | 2009-10-16 00:00:00
[NAME] | Code 01 | 2010-01-07 00:00:00
[NAME] | Code 02 | 2010-01-08 00:00:00
[NAME] | Code 01 | 2010-01-09 00:00:00
Spreadsheet: 821934d1678996728-what-is-relationship-between-my-numbers-atr
Sheet: Sheet1

EURUSD
 | APR | ATR |  | TP1 | TP2 | TP3 |  |  |  |  |  | 1 | 2 | 3
MN | 389 | 384 |  | 567 | 1216 | 2512
W1 | 188 | 189 |  | 284 | 608 | 1256
D1 | 71 | 98 |  | 139 | 297 | 614
H4 | 29 | 38 |  | 66 | 142 | 293
H1 | 14 | 21 |  | 30 | 65 | 134
M15 | 7 | 15 |  | 18 | 38 | 78
M5 | 4 | 9 |  | 13 | 27 | 57
M1 | 2 | 5 |  | 9 | 18 | 38
[NAME]
 | APR | ATR |  | TP1 | TP2 | TP3 |  |  |  |  |  | 1 | 2 | 3
MN | 444 | 564 |  | 815 | 1746 | 3609
W1 | 214 | 270 |  | 407 | 873 | 1804
D1 | 81 | 133 |  | 203 | 435 | 898
H4 | 33 | 46 |  | 88 | 189 | 390
H1 | 17 | 26 |  | 33 | 71 | 147
M15 | 8 | 15 |  | 20 | 44 | 91
M5 | 5 | 10 |  | 12 | 26 | 54
M1 | 2 | 5 |  | 8 | 17 | 36
Spreadsheet: 46f2f939-df65-4400-8736-0a68f1961d02
Sheet: Page 4

Permit No.: |  |  | WQ0003626 |  |  | Facility Name: |  | Campbell Soup Supply Company, LLC |  |  |  |  |  | County: | Robeson |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | [NAME] |  | Field Name: |  | J-6 |  | Field Name: |  | J-7 |  | Field Name: |  | J-8
 |  |  |  |  |  | Area (acres): |  | 6.26 |  | Area (acres): |  | 5.62 |  | Area (acres): |  | 5.37 |  | Area (acres): |  | 4.78
 |  |  |  |  |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME]
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  | Annual Rate (in): |  | 91 |  | Annual Rate (in): |  | 91 |  | Annual Rate (in): |  | 91 |  | Annual Rate (in): |  | 91
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | 3.87 MG Lagoon | 26.26 MG Lagoon | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 752328d1634720314-how-to-sum-data-between-two-dates-by-project-type-financial-model-extract
Sheet: Revenue (2)

 |  |  | -3 | 9
 | Project Name | Construction End date | Sales start | Target date to complete sales | 2022-12-31 00:00:00
 | Project 1 | 2023-03-01 00:00:00
 | Project 2 | 2023-04-01 00:00:00
 | Project 3 | 2023-09-01 00:00:00
 | Project 4 | 2023-09-01 00:00:00
 | Project 5 | 2023-10-21 00:00:00
 | Project 6 | 2023-11-21 00:00:00
 | Project 8 | 2023-11-01 00:00:00
 | Project 10 | 2023-12-01 00:00:00
 | Project 11 | 2023-12-02 00:00:00
 | Project 13 | 2024-10-21 00:00:00
 | Project 14 | 2024-12-05 00:00:00
 | Project 15 | 2024-12-06 00:00:00
 | Project 16 | 2025-10-01 00:00:00
 | Project 17 | 2025-10-01 00:00:00
 | Project 18 | 2025-12-01 00:00:00
 | Project 19 | 2025-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  |  |  |  |  |  |  | From | To | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Project 6 | Project 8 | Project 10 | Project 11 | Project 13 | Project 14 | Project 15 | Project 16 | Project 17 | Project 18 | Project 19
 |  |  |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00 | 2024-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2025-01-31 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2026-01-31 00:00:00 | 2026-12-31 00:00:00
Spreadsheet: 005de1f7-2f15-46f1-982d-19bbc5e8c867
Sheet: Sheet1

[NAME] for My Class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Students | Pre-assessment |  |  | Post-assessment |  |  | Gain
 | Score | Points Possible | % Score | Score | Points Possible | % Score
Girl 1 | 22 | 45 | 0.4888888888888889 | 45 | 50 | 0.9 | 0.8043478260869567
Girl 2 | 15 | 45 | 0.3333333333333333 | 36 | 50 | 0.72 | 0.58
Girl 3 | 28 | 45 | 0.6222222222222222 | 46 | 50 | 0.92 | 0.7882352941176471
Girl 4 | 37 | 45 | 0.8222222222222222 | 42 | 50 | 0.84 | 0.1
Girl 5 | 21 | 45 | 0.4666666666666667 | 39 | 50 | 0.78 | 0.5875
Girl 6 | 25 | 45 | 0.5555555555555556 | 36 | 50 | 0.72 | 0.3699999999999999
Girl 7 | 42 | 45 | 0.9333333333333333 | 48 | 50 | 0.96 | 0.3999999999999994
Girl 8 | 18 | 45 | 0.4 | 39 | 50 | 0.78 | 0.6333333333333334
Girl 9 | 26 | 45 | 0.5777777777777777 | 44 | 50 | 0.88 | 0.7157894736842105
Boy 1 | 19 | 45 | 0.4222222222222222 | 35 | 50 | 0.7 | 0.4807692307692307
Boy 2 | 11 | 45 | 0.2444444444444444 | 33 | 50 | 0.66 | 0.55
Boy 3 | 29 | 45 | 0.6444444444444445 | 42 | 50 | 0.84 | 0.5499999999999998
Boy 4 | 22 | 45 | 0.4888888888888889 | 45 | 50 | 0.9 | 0.8043478260869567
Boy 5 | 37 | 45 | 0.8222222222222222 | 39 | 50 | 0.78 | -0.2374999999999996
Boy 6 | 28 | 45 | 0.6222222222222222 | 41 | 50 | 0.82 | 0.5235294117647057
Boy 7 | 24 | 45 | 0.5333333333333333 | 44 | 50 | 0.88 | 0.7428571428571429
Boy 8 | 32 | 45 | 0.7111111111111111 | 40 | 50 | 0.8 | 0.3076923076923078
Boy 9 | 24 | 45 | 0.5333333333333333 | 48 | 50 | 0.96 | 0.9142857142857143
Boy 10 | 25 | 45 | 0.5555555555555556 | 41 | 50 | 0.82 | 0.5949999999999999
Boy 11 | 27 | 45 | 0.6 | 26 | 50 | 0.52 | -0.1999999999999999
Boy 12 | 24 | 45 | 0.5333333333333333 | 48 | 50 | 0.96 | 0.9142857142857143
 |  |  |  |  |  | Average Gain | 0.5202130130935201
Spreadsheet: 785140d1656185292-combine-ifsaverage-with-and-or-conditions-sample-wb-ifs-or
Sheet: Sheet2

[NAME] | Date Kitchen Ship to Site | PAR Margin |  | Order Month | Ship Month | Average Par Margin for Unshipped Orders
2022-01-01 00:00:00 | 2022-01-15 00:00:00 | 0.24 |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00
2022-01-05 00:00:00 | 2022-01-10 00:00:00 | 0.23
2022-01-09 00:00:00 | 2022-01-18 00:00:00 | 0.15
2022-02-05 00:00:00 | 2022-02-08 00:00:00 | 0.22
2022-02-08 00:00:00 | 2022-02-15 00:00:00 | 0.24
2022-02-10 00:00:00 | 2022-02-18 00:00:00 | 0.27
2022-02-12 00:00:00 |  | 0.23
2022-02-14 00:00:00 | 2022-02-16 00:00:00 | 0.22
2022-02-16 00:00:00 | 2022-02-20 00:00:00 | 0.2
2022-02-18 00:00:00 |  | 0.19
2022-02-22 00:00:00 | 2022-02-27 00:00:00 | 0.18
2022-02-24 00:00:00 |  | 0.23
2022-02-26 00:00:00 | 2022-02-27 00:00:00 | 0.24
2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 0.25
NOTE: Would like cell G2 to average the par margins in column C, for
All orders placed in January (Column A)
AND
All orders shipped after January (Column B)
OR
All orders not shipped, or Column B is blank
Spreadsheet: 871307d1717684405-excel-function-to-compare-2-columns-same-row-and-select-the-new-value-in-a-new-column-excel-example-2-aligw
Sheet: Tab #1

 |  |  |  | (Tab #2)
 |  | Current |  | Revised
Part # | Description | TP Cost |  | TP Cost
[NAME] | Widget 1 | 66
XYZ-2 | Widget 2 | 75 |  | 15
XYZ-3 | Widget 3 | 115 |  | 12
XYZ-4 | Widget 4 | 69 |  | 36
[NAME] | Widget 5 | 33 |  | 80
XYZ-6 | Widget 5 | 46 |  | 199
Spreadsheet: 696106d1600630172-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets-mohammad-munawar-
Sheet: 03.09.20

Ref | Description | Total | Total Consumed Hrs
Number | Under Section | Qty | Man Power | Machinery | Section
 | Section-A
1212 | Fiiling | 10 | 22 | 22
1315 | Excavation | 12 | 11 | 41
 | Section-B
2510 | Trimming | 15 | 25 | 20
2456 | Laying | 14 | 21 | 21
 | Section-C
2141 | Cutting | 12 | 14.5 | 41
1236 | Snags | 14 | 15 | 30
Spreadsheet: 454189d1459714218-problem-with-formula-when-opening-stock-is-greater-than-first-order-for-product-book1example-2-
Sheet: Sales

 |  |  |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  |  | Stock Left
 | Sale orders |  |  |  |  | Opening Cost |  |  | Running SOH | Running Total
Order Number | [NAME] | Total Sold | Cost of Order
1 | 200 |  | =40 x £1.12 plus 160 x £1 |  |  |  |  |  |  |  |  | Cost | Total Qty | Running Total
2 | 320 |  | =320 x £1 |  |  |  |  |  |  |  |  | 1.12 | 200
3 | 30 |  | =30 x £1 |  |  |  |  |  |  |  |  | 1 | 1000
4 | 400 |  | =400 x £1 |  |  |  |  |  |  |  |  | 2 | 1000
5 | 250 |  | =90 x £1 plus 160 x £2 |  |  |  |  |  |  |  |  | 2.2 | 1000
6 | 100 |  | =100 x £2 |  |  |  |  |  |  |  |  | 1 | 2000
7 | 400 |  | =400 x £2
8 | 240 |  | =240 x £2
9 | 240 |  | =100 x £2 plus 140 x £2.20
10 | 300 |  | =300 x £2.20
11 | 400 |  | =400 x £2.20
12 | 50 |  | =50 x £2.20
13 | 150 |  | =110 x £2.20 plus 40 x £1
14 | 200
Spreadsheet: 849731d1700138101-formula-to-count-personnel-rotations-schedule-test
Sheet: Sheet1

 | Base principle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expexted result
 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 5
Manually counted |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Nice to have
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expexted result
 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 4 | 4 | 3 | 3 | 0 | 0 | 1 | 0 | 0 | 11
Manually counted |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
Spreadsheet: 875682d1722295808-how-to-match-a-value-greater-than-withing-a-range-of-cells-sample
Sheet: Sheet1

A | B | C
115.059998 | 113.980003
114.910004 | 114.410004
114.57 | 114.370003
115.68 | 115.610001
115.839996 | 115.150002
118.2 | 115.169998
114.760002 | 112.790001
113.169998 | 112.129997
112.029999 | 110.849998
113.080002 | 112.260002
111.5 | 106.160004
117 | 105.910004
111.239998 | 109.57
109.480003 | 107.599998
111.410004 | 111
111.809998 | 110.709999
110.529999 | 108.5
110.860001 | 108.660004
110.540001 | 109.629997
108.970001 | 108.099998
Spreadsheet: 168310d1342394245-excel-2007-lookup-formula-not-seeing-some-numbers-until-they-are-re-entered-lookupcheckformfixed
Sheet: Sheet3

MY LIST |  |  |  | OFFICE LIST
 |  |  |  |  |  |  |  |  | 205 | Room Check
 |  |  |  |  |  |  |  |  | MY LIST |  |  | OFFICE LIST
ROOM | FIRST NAME | SURNAME |  | ROOM | NAME
223 | JON | SMITH |  | 201 | ANTHONY GREEN
201 | RODNEY | DANGERFIELD |  | 133 | [NAME]
201 | ANTHONY | GREEN |  | HOS | CHRIS TAYLER
205 | PHILIP | BAINES |  | 134 | [NAME]
205 | IAN | DILL |  | 135 | [NAME]
132 | GLEN | [NAME] |  | 124 | [NAME] DOUGALL
133 | [NAME] | NEWMAN |  | 132 | [NAME]
141 | JED | BERIDIA |  | 205 | [NAME]
141 | PHILIP | COX |  | 124 | IVAN KONTICEVIC
124 | IVAN | KONTICEVIC |  | 139 | [NAME]
124 | [NAME] | DOUGALL |  | 302 | [NAME]
134 | JERARD | GRAEME |  | 141 | JED BERIDIA
134 | JEREMY | SCHMIDBERGER |  | 134 | JERARD GRAEME
134 | CRAIG | [NAME] |  | 134 | JEZ SCHMIDBERGER
HOS | CHRISTOPHER | TAYLOR |  | 223 | JON SMITH
302 | JASON | [NAME] |  | 205 | PHIL BAINES
135 | [NAME] | COBB |  | 141 | PHIL COX
137 | VINNIE | [NAME] |  | 201 | RODNEY DANGERFIELD
139 | JASON | BEVILAQUA |  | 137 | [NAME]
Spreadsheet: 737258d1624301207-repeating-value-until-value-change-samplerepeatkeycode
Sheet: Sheet1

UniqueCode | [NAME]
A1A 0K6SHOPPERS DRUG MART#0119155 TORBAY RD. | CODE-001
A1A 0K6SHOPPERS DRUG MART#0119155 TORBAY RD. |  |  |  |  |  | UniqueCode | [NAME]
B3L 4P1SHOPPERS DRUG MART#20026960 MUMFORM ROAD UNIT #0115 | CODE-002 |  |  |  |  | A1A 0K6SHOPPERS DRUG MART#0119155 TORBAY RD. | CODE-001
B3L 4P1SHOPPERS DRUG MART#20026960 MUMFORM ROAD UNIT #0115 |  |  |  |  |  | A1A 0K6SHOPPERS DRUG MART#0119155 TORBAY RD. | CODE-001 |  | Repeat the code until change to populate all keycode.
B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003 |  |  |  |  | B3L 4P1SHOPPERS DRUG MART#20026960 MUMFORM ROAD UNIT #0115 | CODE-002
B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR |  |  |  |  |  | B3L 4P1SHOPPERS DRUG MART#20026960 MUMFORM ROAD UNIT #0115 | CODE-002
B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR |  |  |  |  |  | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003
B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR |  |  |  |  |  | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003
B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR |  |  |  |  |  | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003
B4A 4H5SHOPPERS DRUG MART#202320 DELLRIDGE [NAME] | CODE-004 |  |  |  |  | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003
B4A 4H5SHOPPERS DRUG MART#202320 DELLRIDGE [NAME] |  |  |  |  |  | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | CODE-003
B4V 3A2SHOPPERS DRUG MART#0139421 LAHAVE ST. UNIT 0300 | CODE-005
B4V 3A2SHOPPERS DRUG MART#0139421 LAHAVE ST. UNIT 0300
B5A 2T4SHOPPERS DRUG MART#015556 STARRS ROAD | CODE-006
B5A 2T4SHOPPERS DRUG MART#015556 STARRS ROAD
B5A 2T4SHOPPERS DRUG MART#015556 STARRS ROAD
B5A 2T4SHOPPERS DRUG MART#015556 STARRS ROAD
B5A 2T4SHOPPERS DRUG MART#015556 STARRS ROAD