tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729620d1619200856-sumifs-with-criteria-1-as-range-rather-than-cell-sales-data-sum
Sheet: Sheet1

 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 |  |  | Criteria List
Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SP4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SP9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SP15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SP20
 |  |  | Sales Person ID | Date | Quantity
 |  |  | SP6 | 2021-08-02 00:00:00 | 18
 |  |  | SP19 | 2021-04-23 00:00:00 | 14
 |  |  | SP4 | 2021-07-01 00:00:00 | 6
 |  |  | SP9 | 2021-11-18 00:00:00 | 16
 |  |  | SP15 | 2021-07-23 00:00:00 | 7
 |  |  | SP20 | 2021-04-02 00:00:00 | 17
 |  |  | SP16 | 2021-10-17 00:00:00 | 16
 |  |  | SP3 | 2021-12-28 00:00:00 | 7
 |  |  | SP14 | 2021-12-17 00:00:00 | 9
 |  |  | SP19 | 2021-12-05 00:00:00 | 10
 |  |  | SP13 | 2021-09-17 00:00:00 | 19
 |  |  | SP11 | 2021-03-13 00:00:00 | 5
 |  |  | SP15 | 2021-11-10 00:00:00 | 6
 |  |  | SP20 | 2021-04-01 00:00:00 | 2
 |  |  | SP6 | 2021-02-12 00:00:00 | 14
 |  |  | SP5 | 2021-09-05 00:00:00 | 12
 |  |  | SP2 | 2021-12-08 00:00:00 | 14
 |  |  | SP2 | 2021-02-23 00:00:00 | 5
 |  |  | SP12 | 2021-12-19 00:00:00 | 12
 |  |  | SP16 | 2021-12-28 00:00:00 | 2
 |  |  | SP20 | 2021-02-13 00:00:00 | 19
 |  |  | SP11 | 2021-06-22 00:00:00 | 20
 |  |  | SP6 | 2021-12-06 00:00:00 | 18
 |  |  | SP3 | 2021-10-07 00:00:00 | 20
 |  |  | SP9 | 2021-04-13 00:00:00 | 13
 |  |  | SP1 | 2021-07-09 00:00:00 | 14
 |  |  | SP4 | 2021-08-06 00:00:00 | 8
 |  |  | SP18 | 2021-04-26 00:00:00 | 11
 |  |  | SP19 | 2021-06-10 00:00:00 | 11
 |  |  | SP10 | 2021-02-21 00:00:00 | 4
 |  |  | SP10 | 2021-08-08 00:00:00 | 18
 |  |  | SP6 | 2021-05-21 00:00:00 | 4
 |  |  | SP11 | 2021-03-08 00:00:00 | 1
 |  |  | SP5 | 2021-08-17 00:00:00 | 2
 |  |  | SP7 | 2021-04-10 00:00:00 | 2
 |  |  | SP19 | 2021-02-03 00:00:00 | 16
 |  |  | SP14 | 2021-05-19 00:00:00 | 16
 |  |  | SP10 | 2021-10-21 00:00:00 | 6
 |  |  | SP18 | 2021-10-27 00:00:00 | 12
 |  |  | SP20 | 2021-10-30 00:00:00 | 2
 |  |  | SP13 | 2021-08-29 00:00:00 | 12
 |  |  | SP18 | 2021-10-27 00:00:00 | 9
 |  |  | SP13 | 2021-05-29 00:00:00 | 6
 |  |  | SP4 | 2021-10-12 00:00:00 | 15
 |  |  | SP12 | 2021-04-14 00:00:00 | 11
 |  |  | SP1 | 2021-08-27 00:00:00 | 8
 |  |  | SP14 | 2021-01-31 00:00:00 | 13
 |  |  | SP7 | 2021-11-20 00:00:00 | 9
 |  |  | SP19 | 2021-08-15 00:00:00 | 9
 |  |  | SP12 | 2021-07-02 00:00:00 | 4
 |  |  | SP2 | 2021-05-22 00:00:00 | 10
 |  |  | SP19 | 2021-11-02 00:00:00 | 8
 |  |  | SP11 | 2021-08-07 00:00:00 | 1
 |  |  | SP18 | 2021-12-03 00:00:00 | 5
Spreadsheet: 749656d1632943187-multiply-cells-having-numbers-and-text-mixed-multiply-text
Sheet: Sheet1

effort type | effort duration | Yearly (52 weeks)
hrs to replace 1 machine | 30.0 hrs | non recurring
hrs to service 1 machine | 0.50 hrs / week | 104 hrs / year
hrs to service 30 machines | 15.0 hrs / week | 780 hrs / year
is there a formula that can multiply B3*A4 and output B4 as shown in blue cells.
if I simply try mulipying B3*A4 I will get a #[NAME]! Error.
I don’t want to phyiscally separate the text from numbers but would like to keep it exactly as shown.
is it possible to do this with [NAME] ?
30 | 0.5
Spreadsheet: 216914d1361919312-problem-with-functional-argument-testworkbook
Sheet: sheet 2

 |  | Data Source |  |  |  | Compliance Test |  |  |  |  | Contact
Number | DoC | abc | JS | CORD A | CORD B | A | CORD | WA | DS | Location | Name | Phone | [NAME] | seq
A56Q9Z27LL654 | A56Q9Z2 | Yes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | a | 0 | 0 | 0 |  | The value in cell O4 should be "-" and I cannot figure out why the function isn't working.  Any suggestions?
A56Q9Z27LL730 | [NAME] | 0 | Yes | 0 | 0 | 0 | 0 | 0 | 0 | b | Palmer, [NAME] | 123 | ([EMAIL])
Spreadsheet: f7a38705-09ab-4341-941a-79cad99b0b91
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
61777 | Test | 61777 | CD71, Immunostain | CD71, Immunostain | Immunohistochemistry |  |  |  |  |  | This test is not an orderable test. Order 70012 / Pathology Consultation. The consultant will determine the need for special stains.  [NAME]: Tissue: Paraffin-embedded tissue block  [NAME]: Unstained sections on charged slides |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA |  | Monday through Friday | 5 days |  | 1 | 88342 |  |  |  |  | Rochester
61777 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
61777 | Result | 61777 | CD71, Immunostain | CD71, Immunostain | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 836601d1689517178-merging-formulas-that-reference-sheets-indirect-formulas-test-file-3-copy-1-
Sheet: Sheet2

 |  | Cells | Cells
 | Solution: | H222 | I222
 | ZONE | TOTAL1 | TOTAL2
 |  |  |  |  | Last part would be adding the sum function to add at the end of the totals (1-2). This way when the list gets long, the sum would move with the formula in B1 and not have to be manually inputed like in cells C15 and D15
 |  |  |  |  | im thinking that the sum function would go in front of the unique function in the formula
 |  |  |  |  | IFERROR(LET(t,SORT(UNIQUE(FILTER(data!A10:A1000,ISNUMBER(SEARCH("alpha",data!A10:A1000)),"not found"))),HSTACK(t,MAP(t,[NAME],INDIRECT("'"&c&"'!H222"))),MAP(t,[NAME],INDIRECT("'"&c&"'!i222"))))),"")
 |  |  |  |  |  | ^
 |  |  |  |  |  | Sum here?
Spreadsheet: 846479d1697653387-populate-worksheet-based-on-checkboxes-example-workbook
Sheet: OUTPUT

Requested Courses
Internal Code | Product | Course type | Price (£)
P1-OP | P1 | Operation | 50
P1-DI | P1 | Diagnostics | 25
P3-AD | P3 | Administration | 30
Total Cost
No. Courses required |  |  | 3
Spreadsheet: 825442d1681316217-if-e4-y-copy-data-from-sheet-2-to-sheet-3-test-drawing-list-setup
Sheet: Sheet 2

Site Location Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000000
Existing Site Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000001
Site Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000002
Existing & Proposed Indicative Contours with Existing Trees | XXXX | [NAME] | ZZ | 00 | D | L | 000010
Boundary Treatment Strategy | XXXX | [NAME] | ZZ | 00 | D | L | 000020
Furniture Strategy | XXXX | [NAME] | ZZ | 00 | D | L | 000025
Circulation Strategy | XXXX | [NAME] | ZZ | 00 | D | L | 000030
Planting Strategy | XXXX | [NAME] | ZZ | 00 | D | L | 000040
Proposed Site Sections | XXXX | [NAME] | ZZ | 00 | D | L | 000050
Existing Site Sections | XXXX | [NAME] | ZZ | 00 | D | L | 000055
Public Open Space Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000060
Urban Greening Factor | XXXX | [NAME] | ZZ | 00 | D | L | 000070
Phasing Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000075
Sports Provision/Strategy | XXXX | [NAME] | ZZ | 00 | D | L | 000080
Area Calculations | XXXX | [NAME] | ZZ | 00 | D | L | 000085
Typical Details | XXXX | [NAME] | ZZ | 00 | D | L | 000090
Designer's Hazard Management Drawing | XXXX | [NAME] | ZZ | 00 | D | L | 620000
Designer's Hazard Management Schedule | XXXX | [NAME] | ZZ | 00 | D | L | 620005
Designer's Hazard Management Schedule | XXXX | [NAME] | ZZ | 00 | D | L | 620006
General Arrangement [NAME] | XXXX | [NAME] | ZZ | 00 | D | L | 000100
Kerbs/Edging Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000111
Fencing and Walls Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000121
Furniture Plan | XXXX | [NAME] | ZZ | 00 | D | L | 000131
Indicative Detailed Levels & Falls with Existing Trees | XXXX | [NAME] | ZZ | 00 | D | L | 000301
Detailed Planting Plans | XXXX | [NAME] | ZZ | 00 | D | L | 000400
Habitat Enhancement Drawing | XXXX | [NAME] | ZZ | 00 | D | L | 000450
Landscape Details Hard | XXXX | [NAME] | ZZ | 00 | D | L | 000501
Landscape Details Soft | XXXX | [NAME] | ZZ | 00 | D | L | 000511
Setting Out | XXXX | [NAME] | ZZ | 00 | D | L | 000601
Setting Out | XXXX | [NAME] | ZZ | 00 | D | L | 000602
Spreadsheet: 58373d1258635325-lookup-sample
Sheet: Sheet4

PartNumber | Date | Qty
Part1 | 2009-10-01 00:00:00 | 1
Part2 | 2009-10-21 00:00:00 | 1
Part2 | 2009-10-28 00:00:00 | 3
Part3 | 2009-10-04 00:00:00 | 1
Part3 | 2009-10-08 00:00:00 | 1
Part4 | 2009-10-10 00:00:00 | 1
Part4 | 2009-10-14 00:00:00 | 2
Part4 | 2009-10-15 00:00:00 | 8
Part4 | 2009-10-26 00:00:00 | 9
Part5 | 2009-10-07 00:00:00 | 1
Part5 | 2009-10-24 00:00:00 | 2
Part6 | 2009-10-12 00:00:00 | 8
Part6 | 2009-10-17 00:00:00 | 5
Part6 | 2009-10-20 00:00:00 | 3
Part6 | 2009-10-27 00:00:00 | 1
Part7 | 2009-10-02 00:00:00 | 1
Part7 | 2009-10-05 00:00:00 | 2
Part7 | 2009-10-08 00:00:00 | 1
Part7 | 2009-10-14 00:00:00 | 9
Part7 | 2009-10-18 00:00:00 | 1
Part7 | 2009-10-23 00:00:00 | 6
Part8 | 2009-10-06 00:00:00 | 2
Part8 | 2009-10-29 00:00:00 | 2
Part9 | 2009-10-21 00:00:00 | 1
Part9 | 2009-10-26 00:00:00 | 1
Part10 | 2009-10-05 00:00:00 | 4
Part10 | 2009-10-08 00:00:00 | 1
Part10 | 2009-10-15 00:00:00 | 1
Part10 | 2009-10-17 00:00:00 | 1
Part10 | 2009-10-23 00:00:00 | 5
Part10 | 2009-10-26 00:00:00 | 1
Part10 | 2009-10-27 00:00:00 | 1
Part11 | 2009-10-09 00:00:00 | 1
Part11 | 2009-10-13 00:00:00 | 4
Part11 | 2009-10-16 00:00:00 | 1
Part12 | 2009-10-05 00:00:00 | 1
Part12 | 2009-10-10 00:00:00 | 1
Part12 | 2009-10-24 00:00:00 | 1
Part12 | 2009-10-29 00:00:00 | 1
Part13 | 2009-10-11 00:00:00 | 1
Part13 | 2009-10-22 00:00:00 | 1
Part14 | 2009-10-04 00:00:00 | 2
Part14 | 2009-10-05 00:00:00 | 5
Part14 | 2009-10-12 00:00:00 | 1
Part14 | 2009-10-19 00:00:00 | 1
Part14 | 2009-10-29 00:00:00 | 1
Part15 | 2009-10-07 00:00:00 | 1
Part15 | 2009-10-13 00:00:00 | 1
Part15 | 2009-10-14 00:00:00 | 9
Part15 | 2009-10-19 00:00:00 | 1
Part15 | 2009-10-21 00:00:00 | 1
Part15 | 2009-10-27 00:00:00 | 1
Part16 | 2009-10-14 00:00:00 | 1
Part16 | 2009-10-21 00:00:00 | 1
Part17 | 2009-10-16 00:00:00 | 1
Part17 | 2009-10-25 00:00:00 | 1
Part17 | 2009-10-26 00:00:00 | 6
Part18 | 2009-10-24 00:00:00 | 1
Part19 | 2009-10-05 00:00:00 | 8
Part19 | 2009-10-13 00:00:00 | 3
Part19 | 2009-10-17 00:00:00 | 1
Part19 | 2009-10-22 00:00:00 | 1
Part20 | 2009-10-17 00:00:00 | 1
Part20 | 2009-10-19 00:00:00 | 1
Part21 | 2009-10-09 00:00:00 | 6
Part21 | 2009-10-16 00:00:00 | 1
Part21 | 2009-10-21 00:00:00 | 1
Part22 | 2009-10-20 00:00:00 | 1
Part23 | 2009-10-14 00:00:00 | 1
Part23 | 2009-10-28 00:00:00 | 6
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 147304 | 158363
2 | 162200 | 159898
3 | 156474 | 159849
4 | 156008 | 154229
5 | 152552 | 152972
6 | 156411 | 154640
7 | 159223 | 157936
8 | 154279 | 153799
9 | 154445 | 152757
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -5048
2002-02-09 00:00:00
CBS Dollars
 |  |  | 324667
Spreadsheet: 204378d1357488233-how-to-keep-values-from-repeating-copy-of-example1
Sheet: Sheet1

1 |  | 750 |  |  |  | First | 22.00000000552245 | 3.000000000412001 | 10.00000000251021
2 |  | 750 |  |  |  | Second | 16.99999998687326 | 1.000000000023647 | 11.99999999755528
3 |  | 790 |  |  |  | Third | 20.00000000502041 | 2.000000000047294 | 5.999999998777639
4 |  | 700 | 50 |  |  | Fourth | 23.00000000315868 | 3.999999999185093 | 7.000000002552952
5 | 10 | 660 |  |  |  | Fifth | 13.99999999396459 | 21.00000002437082 | 7.999999998370185
6 | 20 |  | 750 | 80
7 | 10 |  | 750
8 |  |  | 750 |  |  | First | 800 | 790 | 810
9 |  |  | 650 |  |  | Second | 750 | 750 | 810
10 |  |  | 810 |  |  | Third | 750 | 750 | 750
11 |  | 300 | 535 | 20 |  | Fourth | 750 | 700 | 750
12 | 30 |  | 810 |  |  | Fifth | 720 | 700 | 750
13 | 445 | 650 | 30 | 10
14 | 720 |  | 10 | 30
15 | 40 |  |  | 1200
16 |  | 30 |  | 1320
17 | 750 |  |  | 10
18 |  | 320 | 570 | 30
19 | 222 | 212 | 192
20 | 750 |  |  | 10
21 | 520 | 700
22 | 800 | 20 |  | 30
23 | 750
24 | 222 | 192 | 222 | 10
25 | 30 |  | 730
Spreadsheet: gerald_nemec__11488__Gallup
Sheet: Rate 19

Transwestern Pipeline Company
Gallup Electric Compressor
Coincidental Peak Demand Rebate Calculation
RATE 19 |  |  |  |  | 2nd Quarter
Service Month |  |  |  |  | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 |  | 2nd Quarter
Calendar Month |  |  |  | Rates | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 |  | Total
HP
Kw |  |  |  |  | 8275.2 | 9254
Demand Charges/10,000 Kw |  |  |  |  | 130721 | 130721
per Month
Transmission Rate |  |  |  | 3.11
Distribution Rate |  |  |  | 0.5
 | [NAME]
PUC Surcharge |  |  |  | 0.005
 | Subtotal before Gross Receipts Tax
[NAME] |  |  |  | 0.05875
 | Total Demand Charge
Demand Rebate
[NAME] |  |  |  |  | 4231512 | 5097423
Energy Charge Rate 19 |  |  |  | 0.033727
Energy Charge Rate 21 |  |  |  | 0.01762
 | Difference in Energy Charge
Passthrough ([NAME]) - Credit |  |  | May | June
 | Subtotal Energy Charge
PUC Surcharge |  |  |  | 0.005
 | Subtotal before Gross Receipts Tax
[NAME] |  |  |  | 0.05875
 | Total Energy Charge
Energy Payment
Total Rebate
Cumulative Total
Spreadsheet: 837587d1690276047-bringing-over-data-associated-with-max-values-example-data
Sheet: Sheet1

 |  |  |  |  |  |  |  | Values I'd expect to see
Shop name | Product | Sales
Shop 1 | Apples | 10 |  |  |  | Row Labels | [NAME] | Item with the [NAME] sales
Shop 1 | Oranges | 5 |  |  |  | Shop 1 | 10 | Apples
Shop 1 | Bananas | 3 |  |  |  | Shop 2 | 54 | Oranages
Shop 1 | Lemons | 5 |  |  |  | Shop 3 | 13 | Apples
Shop 1 | Pineapples | 7 |  |  |  | Shop 4 | 53 | Bananas
Shop 1 | Kiwis | 8 |  |  |  | Grand Total | 54
Shop 1 | Plums | 9
Shop 2 | Apples | 23
Shop 2 | Oranges | 54
Shop 2 | Bananas | 6
Shop 2 | Lemons | 7
Shop 2 | Pineapples | 3
Shop 2 | Kiwis | 8
Shop 2 | Plums | 9
Shop 3 | Apples | 13
Shop 3 | Oranges | 5
Shop 3 | Bananas | 3
Shop 3 | Lemons | 6
Shop 3 | Pineapples | 3
Shop 3 | Kiwis | 9
Shop 3 | Plums | 10
Shop 3 | Pears | 11
Shop 4 | Apples | 11
Shop 4 | Oranges | 34
Shop 4 | Bananas | 53
Shop 4 | Lemons | 23
Shop 4 | Pineapples | 6
Shop 4 | Kiwis | 3
Shop 4 | Plums | 4
Spreadsheet: 118398d1313660865-count-times-when-conditional-formatting-met-marks
Sheet: Sheet1

 |  | Pupil | Points | :) | : | :( | 2011-09-01 00:00:00 | 2011-09-02 00:00:00 | 2011-09-03 00:00:00 | 2011-09-04 00:00:00 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00
1c | 1.1 | [NAME] | 0 |  |  |  | 1c | 1b | 1c | 2a | 3b | 3c | 3c | 3b
1b | 1.2 | [NAME] | 0 |  |  |  | 1c | 1a | 2a | 3c | 2a | 3c
1a | 1.3 | [NAME] | 0 |  |  |  | 1c | 2c | 1a | 1b | 2a | 3c
2c | 2.1 | [NAME] | 0 |  |  |  | 1c | 1c | 2b
2b | 2.2 | [NAME] | 0 |  |  |  | 1b | 1b | 1a | 2c | 2c | 2b | 2b | 2a | 1c | 1b | 1a
2a | 2.3 | [NAME] | 0 |  |  |  | 1a | 2a
3c | 3.1 | [NAME] | 0 |  |  |  | 2c | 3b
3b | 3.2 | [NAME] | 0 |  |  |  | 2b | 1a | 1b | 1a | 2c | 2b | 2a
3a | 3.3
4c | 4.1
4b | 4.2
4a | 4.3
5c | 5.1
5b | 5.2
5a | 5.3
6c | 6.1
6b | 6.2
6a | 6.3
7c | 7.1
7b | 7.2
7a | 7.3
Spreadsheet: 755497d1636919974-help-me-with-formula-to-correctly-calculate-unsocial-hours-worked-sample-timesheet
Sheet: Sheet1

Date | Duty Periods |  |  |  | Total Hours | Details of Duties/Comments
 | From |  | To
Monday | 07:30:00 |  | 13:00:00
 | 21:30:00 |  | 22:30:00
Tuesday | 21:30:00 |  | 22:30:00
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  |  |  |  | Total Hours Worked
 |  |  |  |  |  | Carried  Forward |  |  | Basic Rate
 |  |  |  |  |  | Hours Taken |  |  | Unsocial
 |  |  |  |  |  | Hours Due |  |  | Initialed
Spreadsheet: 129126d1321461490-excel-2007-pivot-table-counting-unique-values-in-a-row-and-grouping-start-and-end-dates-example
Sheet: Sheet1

Customer | Project ID | Tech Name | Start Date | End Date | Total Months | Hours | Ave Hours a Month
Joes funhouse | PD01 -101 | [NAME] bloggs | 2010-11-01 00:00:00 | 2011-02-02 00:00:00 | 3 | 15 | 5
The Barbers | PD02 -102 | Chirs Wills | 2010-12-05 00:00:00 | 2011-12-05 00:00:00 | 12 | 24 | 2
The Bakers | PD02 -103 | [NAME] | 2011-01-03 00:00:00 | 2011-02-02 00:00:00 | 1 | 9 | 9
The Bakers | PD02 -103 | [NAME] | 2011-02-04 00:00:00 | 2011-05-05 00:00:00 | 3 | 20 | 6.666666666666667
The Barbers | PD02 -104 | [NAME] | 2011-03-04 00:00:00 | 2011-03-29 00:00:00 | 0 | 50 | 50
The Chemist | PD02 -105 | [NAME] | 2011-07-28 00:00:00 | 2011-09-09 00:00:00 | 2 | 3 | 1.5
The Chemist | PD02 -105 | [NAME] | 2011-08-23 00:00:00 | 2011-09-09 00:00:00 | 1 | 8 | 8
The Chemist | PD02 -105 | Chirs Wills | 2011-08-23 00:00:00 | 2011-09-09 00:00:00 | 1 | 16 | 16
The Bakers | PD02 - 106 | [NAME] | 2011-08-28 00:00:00 | 2011-08-29 00:00:00 | 0 | 2 | 2
The Butcher | PD03 - 101 | [NAME] | 2011-08-28 00:00:00 | 2011-10-10 00:00:00 | 2 | 5 | 2.5
Joes funhouse | PD01 -102 | [NAME] | 2011-09-05 00:00:00 | 2011-11-01 00:00:00 | 2 | 12 | 6
The Barbers | PD02 -107 | [NAME] | 2011-09-06 00:00:00 | 2011-10-01 00:00:00 | 1 | 12 | 12
The Barbers | PD02 -107 | [NAME] | 2011-09-06 00:00:00 | 2011-10-01 00:00:00 | 1 | 8 | 8
The Chemist | PD02 - 108 | [NAME] | 2011-09-18 00:00:00 | 2011-11-01 00:00:00 | 2 | 20 | 10
Spreadsheet: 788948d1658819494-index-function-with-variable-columns-excel-forum
Sheet: Range overview

Woche: | 28
 | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5
 |  |  |  | Delta Vorwoche |  |  |  | Delta Vorwoche |  |  |  | Delta Vorwoche |  |  |  | Delta Vorwoche |  |  |  | Delta Vorwoche
Produkt A
Produkt B
Gesamt
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Crude AA

 | Crude Analysts & Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | Crude | Hicks, [NAME] | DIRECTOR | US-GP LPG TRADING
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | Crude | [NAME], [NAME] | MANAGER | US-GP LPG TRADING
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | Crude | South, Chad E | ASSOCIATE | US-GP PETROCHEMICALS TRADING
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 158815d1338401279-compare-a-range-of-cells-to-a-specific-cell-if-match-compare-another-cell-on-same-row-12-13-budget
Sheet: Student Budget Balances

Accounts | Starting  Balance | Expended | Transfers | Adjusted Balance
Animal | 0
Anthropology | 0
Biology | 0
Chemistry | 0
Earth Sciences | 0
Horticulture | 0
Math | 0
NSD | 0
Physics Engineering | 0
RVT | 0
Wildlife | 0
Student-Budget Holding | 0
Spreadsheet: 749786d1633007912-auto-populate-a-duplicate-cell-duplicate-cell-updated-2
Sheet: Vlookup data

 | SEAT NUMBER | RESERVE_NUMBER
 | 56001 | V2
 | 56001 | V3
 | 56001 | V4
 | 56001 | M3
 | 12432 | J1
 | 12432 | J2
 | 89922 | L34
 | 12310 | M55
 | 12310 | M56
 | 77744 | F2
Spreadsheet: 94175d1294056935-establish-ramp-up-point-lookup
Sheet: Ark1

Week | Ramp Up | Surplus | Shortage |  |  | X
1 | #N/A
2 | #N/A | 200
3 | #N/A | 100
4 | #N/A | 50
5 | #N/A | 50
6 | #N/A | 100
7 | #N/A | 150
8 | #N/A | 200
9 |  | 500 | 1000
 | Wanted result
Week | Ramp Up | Surplus | Shortage
1
2 |  | 200
3 |  | 100
4 |  | 50
5 | X | 50
6 |  | 100
7 |  | 150
8 |  | 200
9 |  | 500 | 1000
Spreadsheet: 4584ee73-80da-4500-b764-06ba6186376d
Sheet: utah_all_sums

class | Size | ncnv | a_rate | o_rate | c_rate | co_pv | p_oa | sema_rate | semo_rate | semc_rate | a_totkb | o_totkb | c_totkb | p_totkb | sema_totkb | semo_totkb | semc_totkb
all | all | 3065 | 21.05714 | 20.77551 | 21.12903 | 0.95491 | 0.91784 | 0.75698 | 0.78964 | 0.69883 | 1912.21677 | 1624.8881 | 2148.73097 | 0.36565 | 162.90504 | 114.35544 | 225.33463
dels | all | 2571 | 17.65714 | 17.87755 | 17.37097 | 0.54964 | 0.55961 | 0.71119 | 0.7288 | 0.56105 | 1152.08737 | 1094.80147 | 1003.06058 | 0.30424 | 123.65414 | 93.00298 | 75.27992
dups | all | 494 | 3.4 | 2.89796 | 3.75806 | 0.10992 | 0.35733 | 0.29046 | 0.28459 | 0.372 | 760.1294 | 530.08663 | 1145.67039 | 0.11372 | 114.3344 | 68.28937 | 222.19374
x-all | all | 118 | 0.714 | 1.02 | 0.694 | 0.032 | 0.286 | 0.227 | 0.122 | 0.107 | 96.681 | 62.969 | 41.298 | 0.219 | 45.487 | 13.552 | 12.025
x-dels | all | 109 | 0.629 | 0.959 | 0.645 | 0.032 | 0.305 | 0.221 | 0.12 | 0.108 | 74.655 | 59.286 | 41.224 | 0.312 | 44.025 | 13.568 | 12.029
x-dups | all | 9 | 0.086 | 0.061 | 0.048 | 0.773 | 0.572 | 0.048 | 0.035 | 0.027 | 22.026 | 3.683 | 0.074 | 0.518 | 14.413 | 2.944 | 0.05
y-all | all | 82 | 0.4 | 0.551 | 0.661 | 0.763 | 0.662 | 0.149 | 0.16 | 0.156 | 231.095 | 221.936 | 276.197 | 0.743 | 95.201 | 67.546 | 65.645
y-dels | all | 81 | 0.4 | 0.551 | 0.645 | 0.89 | 0.807 | 0.149 | 0.16 | 0.156 | 231.095 | 221.936 | 272.515 | 0.89 | 95.201 | 67.546 | 65.793
y-dups | all | 1 | 0 | 0 | 0.016 | 0.384 | 0.25 | 0 | 0 | 0.016 | 0 | 0 | 3.682 | 0.25 | 0 | 0 | 3.682
auto-all | all | 2865 | 19.943 | 19.204 | 19.774 | 0.847 | 0.907 | 0.696 | 0.727 | 0.717 | 1584.441 | 1339.983 | 1831.236 | 0.744 | 126.349 | 84.544 | 226.318
auto-dels | all | 2381 | 16.62857 | 16.36735 | 16.08065 | 0.70316 | 0.53051 | 0.64049 | 0.65575 | 0.56249 | 846.33731 | 813.57894 | 689.32202 | 0.03933 | 61.71808 | 52.22676 | 32.12892
auto-dups | all | 484 | 3.314 | 2.837 | 3.694 | 0.118 | 0.349 | 0.301 | 0.279 | 0.369 | 738.103 | 526.404 | 1141.914 | 0.083 | 115.681 | 68.138 | 222.216
Spreadsheet: 144805d1331145185-address-parsing-sample
Sheet: Sheet2

• TX - Houston, Crossroads (#7R) 19720 [NAME],  Houston, Texas 77065 [PHONE] KTDC
• TX - Houston, [NAME] (#8) 13150 Breton Ridge,  Houston, Texas 77069 [PHONE] KTDC
• TX - Houston, Uvalde (#9) 13400 1-10 East,  Houston, Texas 77015 [PHONE] KTDC
• TX - Houston, [NAME] (#10R) 9734 [NAME],  Houston, Texas 77055 [PHONE] KTDC
Spreadsheet: 63459d1264382148-excel-2007-vlookup-book4
Sheet: Sheet2

ID | [NAME] | Supplier Address | Supplier City | Supplier  Postal Code | Supplier  Phone
1 | In-House
2 | Kitchen Suppliers Inc. | 1648 Edmonton Trail NE | Calgary | T2B 3L9 | (403) 278-5685
3 | Roast Experts | 1412 Meridian Road SE | Calgary | T3V 7K3 | (403) 277-3843
4 | Meltdown Chocolate Co. | 8842 Glenmore Trail SE | Calgary | T8K 3H2 | (403) 258-4565
5 | Jumping Beans Coffee Supply Ltd. | 18 Railroad Street NW | Calgary | T4C 1N1 | (403) 932-1545