tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 748150d1631916468-trying-to-create-a-unique-identifier-based-on-column-and-running-into-duplicates-book1
Sheet: Sheet1

Category Number | NOI | OCF | Date1 | Date2 | [NAME]
7511 | 55555 | 22111 | 2000-12-01 00:00:00 | 2005-05-01 00:00:00
7511 | 55556 | 22112 | 2000-12-02 00:00:00 | 2005-05-02 00:00:00
7511 | 55557 | 22113 | 2000-12-03 00:00:00 | 2005-05-03 00:00:00
7511 | 55558 | 22114 | 2000-12-04 00:00:00 | 2005-05-04 00:00:00
7511 | 55559 | 22115 | 2000-12-05 00:00:00 | 2005-05-05 00:00:00
7511 | 55560 | 22116 | 2000-12-06 00:00:00 | 2005-05-06 00:00:00
7511 | 55561 | 22117 | 2000-12-07 00:00:00 | 2005-05-07 00:00:00
7511 | 55562 | 22118 | 2000-12-08 00:00:00 | 2005-05-08 00:00:00
7511 | 55563 | 22119 | 2000-12-09 00:00:00 | 2005-05-09 00:00:00
7511 | 55564 | 22120 | 2000-12-10 00:00:00 | 2005-05-10 00:00:00
7511 | 55565 | 22121 | 2000-12-11 00:00:00 | 2005-05-11 00:00:00
7512 | 55566 | 22122 | 2000-12-12 00:00:00 | 2005-05-12 00:00:00
7512 | 55567 | 22123 | 2000-12-13 00:00:00 | 2005-05-13 00:00:00
7512 | 55568 | 22124 | 2000-12-14 00:00:00 | 2005-05-14 00:00:00
7512 | 55569 | 22125 | 2000-12-15 00:00:00 | 2005-05-15 00:00:00
7512 | 55570 | 22126 | 2000-12-16 00:00:00 | 2005-05-16 00:00:00
7512 | 55571 | 22127 | 2000-12-17 00:00:00 | 2005-05-17 00:00:00
7512 | 55572 | 22128 | 2000-12-18 00:00:00 | 2005-05-18 00:00:00
7512 | 55573 | 22129 | 2000-12-19 00:00:00 | 2005-05-19 00:00:00
7512 | 55574 | 22130 | 2000-12-20 00:00:00 | 2005-05-20 00:00:00
7512 | 55575 | 22131 | 2000-12-21 00:00:00 | 2005-05-21 00:00:00
7513 | 55576 | 22132 | 2000-12-22 00:00:00 | 2005-05-22 00:00:00
7513 | 55577 | 22133 | 2000-12-23 00:00:00 | 2005-05-23 00:00:00
7513 | 55578 | 22134 | 2000-12-24 00:00:00 | 2005-05-24 00:00:00
7513 | 55579 | 22135 | 2000-12-25 00:00:00 | 2005-05-25 00:00:00
7514 | 55580 | 22136 | 2000-12-26 00:00:00 | 2005-05-26 00:00:00
Spreadsheet: 198613d1354827702-how-to-generate-a-random-samples-from-an-employee-data-without-repeat-3
Sheet: latest

 | Last Name | First Name | Address | City | State | Zip | Salary | Date Hired
1 | Smith | [NAME] | 334 Oak St. | Lakeland | FL | 33801 | 25000 | 1996-12-08 00:00:00
2 | Smith | Brittany | 915 Highland St | Bartow | FL | 33830 | 75000 | 1998-08-23 00:00:00
3 | Smith | [NAME] | 503 [NAME] Dr. | Auburndale | FL | 33823 | 25500 | 1997-11-04 00:00:00
4 | Smith | Gregory | 31 Imperial Dr. | [NAME] | FL | 33860 | 32500 | 1999-02-18 00:00:00
5 | [NAME] | Jarred | 136 High St. | Winter Haven | FL | 33810 | 39200 | 2000-05-29 00:00:00
6 | [NAME] | [NAME] | 2020 Main St. | Lakeland | FL | 33801 | 26500 | 1997-01-03 00:00:00
7 | [NAME] | sumo | 145 | bingo | ml | 2222 | 2020 | 1997-01-03 00:00:00
8 | [NAME] | Zachary | 2690 1st St. | Lakeland | FL | 33801 | 72300 | 1997-12-15 00:00:00
9 | [NAME] | [NAME] | 685 Park St. | Lakeland | FL | 33801 | 70000 | 1999-01-24 00:00:00
10 | [NAME] | gami | mami | crunch | tl | 3451685 | 650 | 1999-01-24 00:00:00
11 | [NAME] | [NAME] | 2055 Georgia St. | Lakeland | FL | 33801 | 49320 | 1996-11-27 00:00:00
12 | Henderson | [NAME] | 3815 [NAME] | [NAME] | FL | 33860 | 49500 | 2000-04-26 00:00:00
13 | Henderson | eiofn | 202020 | [NAME] | hl | 2220 | 510 | 2000-04-26 00:00:00
14 | Henderson | [NAME] | 956 Hankins St. | Bartow | FL | 33830 | 50000 | 1997-11-24 00:00:00
15 | Henderson | [NAME] | 990 Dudley St. | Bartow | FL | 33830 | 55000 | 2000-08-12 00:00:00
16 | Henderson | [NAME] | [NAME] | wbf | dl | gneo | 2050 | 2000-08-12 00:00:00
17 | [NAME] | [NAME] | 202 Griffin St. | Lakeland | FL | 33801 | 26500 | 1997-12-03 00:00:00
18 | [NAME] | Michelle | 510 Whitman St. | [NAME] | FL | 33860 | 70000 | 2000-03-30 00:00:00
19 | [NAME] | [NAME] | 265 Hooker St. | [NAME] | FL | 33860 | 69500 | 1996-10-15 00:00:00
Samples
4 | Smith | Gregory | 31 Imperial Dr. | [NAME] | FL | 33860 | 32500 | 1999-02-18 00:00:00
3 | Smith | [NAME] | 503 [NAME] Dr. | Auburndale | FL | 33823 | 25500 | 1997-11-04 00:00:00
8 | [NAME] | Zachary | 2690 1st St. | Lakeland | FL | 33801 | 72300 | 1997-12-15 00:00:00
10 | [NAME] | gami | mami | crunch | tl | 3451685 | 650 | 1999-01-24 00:00:00
13 | Henderson | eiofn | 202020 | [NAME] | hl | 2220 | 510 | 2000-04-26 00:00:00
16 | Henderson | [NAME] | [NAME] | wbf | dl | gneo | 2050 | 2000-08-12 00:00:00
18 | [NAME] | Michelle | 510 Whitman St. | [NAME] | FL | 33860 | 70000 | 2000-03-30 00:00:00
17 | [NAME] | [NAME] | 202 Griffin St. | Lakeland | FL | 33801 | 26500 | 1997-12-03 00:00:00
Spreadsheet: daren_farmer__5357__hpl0712
Sheet: Sheet1

HPLN0712.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective July 12, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-07-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Texoma |  | ENA | 15 | 15
Enron (S) |  | Oasis Sealy |  | ENA | 60 | 60
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 91572d1291280512-lookup-for-specific-values-in-multiple-cells-tooling
Sheet: Tooling

 | Area | Machine | Description | Equipment | Location | Notes
AM054F | PATT SHOP | [NAME] | CORESETTER | AM054.02 | Z3
AM054F | PATT SHOP | [NAME] | RAM PLATE | AM054.02 | A3
AM054F | PATT SHOP | [NAME] | SWING PLATE | AM054.02 | A3
AM054F | CORE SHOP | HANSBERG | UCB VANE INSERT | AM054B | A4
AM054F | CORE SHOP | HANSBERG | LCB VANE INSERT | AM054B | A5
AM054F | CORE SHOP | HANSBERG | BLOW TUBE | 3GB1 | A6
AM054F | PATT SHOP | [NAME] | SWING PL. INSERT | AM054B | A7 | NO INSERTS FOUND
AM054F | PATT SHOP | [NAME] | ADAPTOR SET  R/S | T305 | A8
AM054F | PATT SHOP | [NAME] | ADAPTOR CSETTER | T295 | A9
AM054F | FETT SHOP | AUTO FETT | AUTOFETT JIG | JIG 1 | A10
AM054F | FETT SHOP | AUTO FETT | AUTOFETT CLAMP | CLAMP 4 | A11
AM054F | FETT SHOP | AUTO FETT | AUTOFETT LOADER | LOADER 150 | A12
AM054F | FETT SHOP | AUTO FETT | AUTOFETT GAUGE | GAUGE 4 | A13
AM054F | CORE SHOP | HANSBERG 7 | BLOW TUBE | BT03 | A14
AM054F | CORE SHOP | HANSBERG | LCB CENT. INSERT | AM054B | A15
[NAME] | FETT SHOP | [NAME] | SWING PL. INSERT | AM054B | A16
[NAME] | FETT SHOP | [NAME] | ADAPTOR SET  R/S | T305 | A17
[NAME] | FETT SHOP | [NAME] | ADAPTOR CSETTER | T295 | A18
[NAME] | FETT SHOP | HANSBERG | BLOW TUBE | JIG 1 | A19
[NAME] | PATT SHOP | HANSBERG | UCB VANE INSERT | CLAMP 4 | A20
[NAME] | PATT SHOP | HANSBERG | LCB VANE INSERT | LOADER 150 | A21
[NAME] | PATT SHOP | AUTO FETT | AUTOFETT CLAMP | GAUGE 4 | A22
[NAME] | PATT SHOP | AUTO FETT | AUTOFETT LOADER | BT03 | A23
[NAME] | PATT SHOP | AUTO FETT | AUTOFETT GAUGE | AM054B | A24
[NAME] | PATT SHOP | AUTO FETT | SWING PL. INSERT | 3GB1 | A25
Spreadsheet: 51635d1251277486-linking-date-fields-to-show-as-available-or-not-vacation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 1
Check- in Date |  |  | Check-Out Date |  |  |  |  |  |  |  | 2009-02-01 00:00:00 | 2
2009-01-01 00:00:00 | 11 |  | 2009-03-01 00:00:00 | 3 |  |  |  |  |  |  | 2009-03-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00 | 5
 |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00 | 6
 |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00 | 7
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00 | 8
 |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00 | 9
 |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00 | 10
 |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00 | 11
 |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 12
 |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 13
 |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00 | 14
 |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00 | 16
 |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00 | 17
 |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00 | 18
 |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00 | 19
 |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00 | 21
 |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00 | 23
 |  |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 31
Spreadsheet: 168319d1342398267-a-complicated-look-up-table-with-multiple-conditions-complex-look-up
Sheet: LookUP Data

Month | XX | XX | XX | Brand Text | Product Text | XX | [NAME] | Net  Sales
2012-01-01 00:00:00 |  |  |  | Z9002 | XCVDG^ |  | TM72006 | 10 |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00
2012-01-01 00:00:00 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50 |  |  | 60
2012-01-01 00:00:00 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
2012-01-01 00:00:00 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
2012-01-01 00:00:00 |  |  |  | X&^% | [NAME] |  | TM72004 | 26
2012-01-01 00:00:00 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
2012-01-01 00:00:00 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 28
2012-01-01 00:00:00 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
2012-01-01 00:00:00 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
2012-01-01 00:00:00 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
2012-01-01 00:00:00 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 38
2012-01-01 00:00:00 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
2012-01-01 00:00:00 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
2012-01-01 00:00:00 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
2012-02-01 00:00:00 |  |  |  | Z9002 | XCVDG^ |  | TM72006 | 10
2012-02-01 00:00:00 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50
2012-02-01 00:00:00 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
2012-02-01 00:00:00 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
2012-02-01 00:00:00 |  |  |  | X&^% | [NAME] |  | TM72004 | 29
2012-02-01 00:00:00 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
2012-02-01 00:00:00 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 40
2012-02-01 00:00:00 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
2012-02-01 00:00:00 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
2012-02-01 00:00:00 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
2012-02-01 00:00:00 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 40
2012-02-01 00:00:00 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
2012-02-01 00:00:00 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
2012-02-01 00:00:00 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
Spreadsheet: 68905d1269440390-excel-2007-index-and-match-question-lookup-sample-data
Sheet: Hotel

Primary GuestID | Hotel Name | Check In Date | Check Out Date | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | 2010-06-04 00:00:00 | 2010-06-05 00:00:00 | 2010-06-06 00:00:00 | 2010-06-07 00:00:00 | 2010-06-08 00:00:00 | 2010-06-09 00:00:00 | 2010-06-10 00:00:00 | 2010-06-11 00:00:00 | 2010-06-12 00:00:00 | 2010-06-13 00:00:00 | 2010-06-14 00:00:00 | 2010-06-15 00:00:00 | 2010-06-16 00:00:00 | 2010-06-17 00:00:00 | 2010-06-18 00:00:00 | 2010-06-19 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 | 2010-06-22 00:00:00 | 2010-06-23 00:00:00 | 2010-06-24 00:00:00 | 2010-06-25 00:00:00 | 2010-06-26 00:00:00 | 2010-06-27 00:00:00 | 2010-06-28 00:00:00 | 2010-06-29 00:00:00 | 2010-06-30 00:00:00 | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 2010-07-14 00:00:00 | 2010-07-15 00:00:00 | 2010-07-16 00:00:00 | 2010-07-17 00:00:00 | 2010-07-18 00:00:00 | 2010-07-19 00:00:00 | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 2010-07-23 00:00:00 | 2010-07-24 00:00:00 | 2010-07-25 00:00:00 | 2010-07-26 00:00:00 | 2010-07-27 00:00:00 | 2010-07-28 00:00:00 | 2010-07-29 00:00:00 | 2010-07-30 00:00:00 | 2010-07-31 00:00:00
3579 | FWC2010 - Cape Grace - CPT | 2010-07-03 00:00:00 | 2010-07-07 00:00:00
3579 | FWC2010 - Sandton Lodge Rivonia - JBG | 2010-07-10 00:00:00 | 2010-07-12 00:00:00
3582 | [NAME] on the Ridge - DUR | 2010-07-05 00:00:00 | 2010-07-08 00:00:00
3582 | FWC2010 - Quatermain Hotel - JBG | 2010-07-08 00:00:00 | 2010-07-12 00:00:00
12814 | [NAME] on the Ridge - DUR | 2010-07-05 00:00:00 | 2010-07-08 00:00:00
12814 | FWC2010 - Quatermain Hotel - JBG | 2010-07-08 00:00:00 | 2010-07-12 00:00:00
12818 | FWC2010 - Cape Grace - CPT | 2010-07-03 00:00:00 | 2010-07-07 00:00:00
12818 | FWC2010 - Sandton Lodge Rivonia - JBG | 2010-07-10 00:00:00 | 2010-07-12 00:00:00
12888 | FWC2010 - Cape Grace - CPT | 2010-07-02 00:00:00 | 2010-07-05 00:00:00
12888 | [NAME] | 2010-07-05 00:00:00 | 2010-07-08 00:00:00
Spreadsheet: 115817d1311310504-parsing-a-data-table-parsingexample
Sheet: report

places | date
[NAME] | red | count
 | 2011-07-06 00:00:00 | 650
 | 2011-07-08 00:00:00 | 360
 | 2011-07-15 00:00:00 | 160
 |  |  |  | "places" and "color", (red or white) are hard coded into report table. Below values are retrieved from data table where matched  with  place and colorshowing "date" and "count".
[NAME] | white
 | 2011-07-06 00:00:00 | 14211
 | 2011-07-08 00:00:00 | 34
 | 2011-07-15 00:00:00 | 6754
 | 2011-07-23 00:00:00 | 54
Shepards Fork | red
Shepards Fork | white
Spreadsheet: 485221d1476789394-having-problems-with-a-graph-mtc-graphs-october
Sheet: 4 Oct 16

[NAME] | 436
Right Conveyor | 486
Total | 922
Left Double | 348
Right Double | 190
[NAME] | 6
Right Blocked | 23
 |  |  |  | Summary   3:37:56 to 11:53:32 pm
 |  |  |  | Left Conveyor Count | 436
 |  |  |  | Right Conveyor Count | 486
 |  |  |  | Total [NAME] | 922
 |  |  |  | Left Double | 348 | Bales taking longer than one second to pass the counter suspected 2 or more Bales in a row
 |  |  |  | Right Double | 190 | Bales taking longer than one second to pass the counter suspected 2 or more Bales in a row
 |  |  |  | [NAME] | 6 | Bales in front of the beams for 5 seconds or more
 |  |  |  | Right Blocked | 23 | Bales in front of the beams for 5 seconds or more
Spreadsheet: 109802d1306565678-sumproduct-problems-for-matching-two-items-account-manager-mutual-fund-sales-final
Sheet: Summary

 | Desired Result
Summary
 | [NAME] Mutual fund Others YTD ($) | Long term mutual fundMIP YTD (volume)
[NAME] | 10999 | 95
[NAME] | 9888 | 0
[NAME] | 14000 | 110
[NAME] | 0 | 0
[NAME] weatherhead | 11800 | 199
Calculation method:
As there is Long term mutual fund with MIP, Column C17 of this page is equal to Sheet"table" column K plus M
As there is Long term mutual fund with other, Column B17 of this page is equal to Sheet"table" column L plus N
 | [NAME] used, can’t get desired result
For example, using [NAME]
 | [NAME] Mutual fund Others YTD ($) | Long term mutual fundMIP YTD (volume)
[NAME] | 10999 | 95
[NAME] weatherhead | 26800 | 199
[NAME] | 15800 | 0
Spreadsheet: 107158d1304374100-conditional-formatting-syntax-sample
Sheet: Sheet1

 | S01 |  |  | S02 |  |  | S03 |  |  | Totals
 |  | Start | Finish |  | Start | Finish |  | Start | Finish
SAMPLE1 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00
 | Rev 1 |  |  | Rev 1 |  |  | Rev 1
 | Act |  |  | Act |  |  | Act
 | Comp | 1 |  | Comp | 1 |  | Comp | 0
SAMPLE2 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00
 | Rev 1 |  |  | Rev 1 |  |  | Rev 1
 | Act |  |  | Act |  |  | Act
 | Comp |  |  | Comp |  |  | Comp | 0
SAMPLE3 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | Plan | 2011-02-14 00:00:00 | 2011-03-09 00:00:00
 | Rev 1 |  |  | Rev 1 |  |  | Rev 1
 | Act |  |  | Act |  |  | Act
 | Comp |  |  | Comp |  |  | Comp
Spreadsheet: 857508d1706522852-formula-to-populate-row-with-days-of-the-month-date-sequence-aligw
Sheet: Sheet1

February
Spreadsheet: 794463d1662055946-calculating-attendance-times-from-shift-books-on-product-basis-2022-09-01-oeldere0-lena_mesta-excel-forum-attendances
Sheet: Mitarbeiter

177010 | [NAME],[NAME]
177110 | Richter,Christian
189510 | Galbiers,Adrian
101310 | Birincioglu,Erkan
175310 | Gorzny,Martin
177011 | Pufal,[NAME]
173512 | Neufeld,[NAME]
184112 | Ruehl,Arno
141100 | [NAME],[NAME]
172800 | Biche,[NAME]
183210 | Neufeld,[NAME]
176700 | Grening,Igor
188110 | [NAME]
171411 | Behnemann,[NAME]
190000 | [NAME],Bernd
157900 | Oelberg,[NAME]
172700 | Hiob,Andreas
161500 | Petig,Rüdiger
170100 | Wenke,Dirk
182411 | Barkei,[NAME]
170311 | [NAME],[NAME]
180812 | Gutsch,[NAME]
170411 | Zipperlin,[NAME]
171610 | Miske,Eugen
178811 | Besheimer,Sergej
5096 | Altenhof,Viktor
184310 | Ruhland,Dominik
173400 | Wilhelm,Wjatscheslaw
103901 | Penner,[NAME]
170511 | [NAME],[NAME]
172912 | [NAME],Olaf
173611 | Schilling,Nikolay
173600 | Schmitz,[NAME]
171211 | [NAME],Viktor
171210 | Opitz,Andreas
175800 | Schneider,[NAME]
175710 | Steiger,[NAME]
173411 | Richert,[NAME]
181400 | Meyer,[NAME]
176500 | Bank,[NAME]
175200 | Sperling,[NAME]
183900 | Distel,Felix
175212 | Lindheim,Stephan
184112 | [NAME],Arno
174212 | Bakic,Goran
176411 | Reitor,[NAME]
176212 | [NAME],[NAME]
174300 | Kühltau,Georg
178411 | Brunmayer,[NAME]
184311 | Arslan,Polat
13918 | Roche,[NAME]
184312 | Sahin,Mehmet
176211 | Harutyunyan,Samvel
2118 | Batt,[NAME]
184400 | [NAME], [NAME]
293358 | Lüdersen,Mario
293357 | Meier,[NAME]
293356 | Siemens,[NAME]
293383 | Miller,Enrico
184012 | Wegener,[NAME]
293382 | Richter,[NAME]
293372 | Barinov,Artem
3020 | Leicht,Dennis
3520 | Obenauer,Nick
293375 | Köppen,Pascal
3319 | [NAME],[NAME]
293373 | [NAME],[NAME]
293200 | Kuz,Onur
178410 | [NAME],Juri
Spreadsheet: 187975d1350647676-data-table-based-on-user-selection-and-index-match-graph-data-table
Sheet: Cost Summary

 | Branch | Branch1 | Total | Branch2 | Total | Branch3 | Total
 | Commercial | Month Actual | Month Budget | Month Actual | Month Budget | Month Actual | Month Budget
 | [NAME]
 | Sales to external Customers
 | IG Sales within Processing
 | Total Sales
 | Cost of Goods Sold - Variable
 | Cost of Goods Sold - Fixed
 | CERT Income
 | Standard Margin from Sales
 | Energy Surcharge Income
 | Energy Surcharge Cost
 | Energy Surcharge Margin
 | CTS - Distribution
 | CTS - Other prime
 | CTS - Overhead
 | CTS - Bad debt prv mvt
 | Total Cost to Serve
 | Margin from Sales
 | Manufacturing | Month Actual | Month Budget | Month Actual | Month Budget | Month Actual | Month Budget
 | m2 Produced
 | Direct Materials
 | Energy
 | Direct Labour
 | Variable Costs of Manufacture
 | BFC - Other prime
 | BFC - Overhead
 | BFC - Depreciation
 | BFC - Operating Leases
 | BFC - Others
 | Total Branch Fixed Costs
 | Total Branch Costs
 | Production Credit - Variable
 | Production Credit - Fixed
 | Total Credit from Production
 | Branch Performance
 | Branch Profit / (Loss)
 | Cost Per M2 - Monthly
 | Direct Materials | -11.83734871156211 | -13.98554411744873 | -20.53473756613757 | -18.64243386243386 | -10.17159026019327 | -11.81457136143271
 | Energy | -0.746933725909255 | -0.8309581945229786 | -1.759301587301587 | -1.80952380952381 | -0.6349965845758794 | -0.8676218926041364
 | Direct Labour | -5.991747637756189 | -5.915090647481727 | -8.524860317460316 | -8.971746031746031 | -8.00043884888179 | -8.268989317803912
 | BFC - Other prime | -0.3420579008997358 | -0.4381372593365022 | -0.3366687830687831 | -0.3943481481481482 | -0.2063141697037037 | -0.4625047550617205
 | BFC - Overhead | -1.61629178262313 | -2.371621374415449 | -4.158023280423281 | -4.905380952380951 | -2.797042791010371 | -2.574931586503713
 | BFC - Depreciation | -0.6903212256132695 | -0.719666539114322 | -0.8696804232804233 | -0.9304761904761905 | -0.6109637213323097 | -0.6293548490942441
 | BFC - Operating Leases | -0.7297088195264136 | -0.7190327177811537 | 0 | -0.1904761904761905 | -1.438211807322263 | -1.438199525515896
 | BFC - Others | -0.6058670922379288 | 0 | -0.1137259259259251 | 0 | -0.03971760724546019 | 0
 | Total Cost Per M2 | -22.56027689612804 | -24.98005085010086 | -36.29699788359788 | -35.84438518518518 | -23.89927579026505 | -26.05617328801632
Spreadsheet: ed52e47b-892f-47c6-aa0f-3d23e5e49097
Sheet: NON-RESIDENTIAL 

 |  |  |  |  |  |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  |  |  |  |  |  | OCTOBER 2013 NON-RESIDENTIAL DATA
APPLICATION TYPE |  | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT NUMBER |  |  | SQUARE FOOTAGE | VALUATION | CONTRACTOR | NOTES | STAFF USE ONLY
 | Street Number | Street Name | Suffix | [NAME] | Unit | Block | Lot | Permit Year | Permit number | STATUS | YMMDD
RCOM | 2240 | GRANDE |  | BLVD | SE | GS |  |  | 13 | 6462 | 131001 | 1137 | 30000 | OUT TO BID |  | TI
RCOM | 460 | NM HIGHWAY | 528 |  | NE | BERN |  | 209 | 13 | 6998 | 131025 | 217565 | 146000 | OUT TO BID |  | TI
RCOM | 1463 | NM HIGHWAY | 528 |  | SE | U16 |  |  | 13 | 7106 | 131031 | 7000 | 150000 | ROBERT TRUJILLO CONSTRUCTION L |  | TI
RCOM | 4311 | SARA |  | RD | SE | ROSE | 1 | 6 | 13 | 6684 | 131010 | 13500 | 62793 | NATIONAL ROOFING COMPANY, INC |  | TI
RCOM | 2310 | SOUTHERN |  | BLVD | SE | U16 | K | 5A | 13 | 6762 | 131015 | 2310 | 12000 | LOBATO CONSTRUCTION, INC. |  | TI
TCOM | 1530 | BARBARA |  | LP | SE | CS | F | 1A | 13 | 6980 | 131024 | 150 | 25000 | DATA CELL SYSTEM INC
TCOM | 301 | SOUTHERN |  | BLVD | SE | CEDH3 | 4 |  | 13 | 6636 | 131008 | 300 | 10000 | DATA CELL SYSTEM INC
TCOM | 1101 | VERANDA |  | RD | SE | U10 | 33 | 102A1 | 13 | 6983 | 131024 | 150 | 25000 | DATA CELL SYSTEM INC
Spreadsheet: 57748d1257960560-translate-string-to-use-with-validation-list-book5
Sheet: Sheet1

[NAME] | RT4 | Text String 1 | 1 | RT1 | empty
[NAME] 3 | RT3 | [NAME] | 2 | RT2
[NAME] | RT4 | [NAME] 3 | 3 | RT3
Text String 1 | RT1 | [NAME] | 4 | RT4
[NAME] | RT2 | [NAME] | 5 | RT5
Spreadsheet: 754778d1636494293-faster-alternative-to-sumifs-sumifs-alternatives-tms
Sheet: Sheet1 (v3) Table

Gas Day | Flow | Pipeline | Path | From | To
2021-09-11 00:00:00 | -526 | El Paso - NML | Dutch Flats | North Permian | Topock
2021-09-11 00:00:00 | -131 | El Paso - NML | Maricopa | North Permian | Topock
2021-09-11 00:00:00 | 1608 | El Paso - NML | NML Cap | Permian | Topock
2021-09-11 00:00:00 | 1608 | El Paso - NML | NML Cap | North Permian | Topock
2021-09-11 00:00:00 | -105 | El Paso - NML | NML Demand | North Permian | Topock