tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 204553d1357573771-replace-odl-data-with-new-data-sample-worksheet
Sheet: Sheet2

Barcode scanner input | Sequence |  | sales order # | WIRE | PREP | PIN | ASSEMBLE | TEST | LABEL | QA | KITTING | SHIPPING
10955-1 WIRE | 1 |  | 10955-1
10955-2 wire | 2 |  | 10955-2
10955-1 PREP | 3 |  | 10955-3
10957 prep | 4 |  | 10956
10957 wire | 5 |  | 10957
10955-3 TEST | 6
10956 KITTING | 7
10955-1 PREP | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 860370d1708498792-merge-help-sample-spreadsheet
Sheet: Additional Times

Incident Number | Alarm Date | Apparatus Name | [NAME] | At Destination
22020286 | 2022-10-01 00:00:00 | M101 | 07:10:00 | 07:20:57
22020314 | 2022-10-01 00:00:00 | M102 | 14:18:41 | 14:35:51
22020318 | 2022-10-01 00:00:00 | M101 | 14:58:37 | 15:09:22
22020365 | 2022-10-02 00:00:00 | M101 | 02:16:51 | 02:28:00
22020366 | 2022-10-02 00:00:00 | M102 | 02:29:28 | 02:40:10
22020378 | 2022-10-02 00:00:00 | M102 | 08:47:59 | 09:03:18
22020382 | 2022-10-02 00:00:00 | M102 | 09:41:38 | 09:55:28
22020387 | 2022-10-02 00:00:00 | M102 | 12:41:24 | 12:50:27
22020412 | 2022-10-02 00:00:00 | M101 | 19:14:44 | 19:26:30
22020414 | 2022-10-02 00:00:00 | M102 | 20:18:12 | 20:31:41
22020424 | 2022-10-02 00:00:00 | M102 | 22:31:15 | 22:43:31
22020441 | 2022-10-03 00:00:00 | M101 | 05:31:37 | 05:42:09
22020467 | 2022-10-03 00:00:00 | M102 | 13:24:42 | 13:41:06
22020499 | 2022-10-03 00:00:00 | M101 | 20:45:19 | 20:56:30
22020500 | 2022-10-03 00:00:00 | M102 | 21:01:59 | 21:10:49
Spreadsheet: 271327d1381913724-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: New Data Sheet Setup

TOTAL** | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | End of Year Totals
Complete
AMA
Other
Medical
Administrative
Relapse
Clinical
[NAME]
Partial
LOS**(IN DAYS) | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | End of Year Totals
Complete
AMA
Other
Medical
Administrative
Relapse
Clinical
[NAME]
Partial
Sample formula I used to count the total of each type of discharge:  =COUNTIF('January 2013'!L:L,A2)
I calculated the LOS for each type of discharge by using this formula ----> =IF(L3="Complete",P3,"") for each type of discharge on the respective month's sheet.
at the end of each month I would use a simple sum formula to add the total for each type of discharge for that month
and then I would special copy the sum to my data sheet in it's respective spot.  Unfortuntely not all clients discharge in the month they are admitted so it doesn’t work!
Spreadsheet: 813965d1674075565-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: GPS Track

GPS track 1 |  |  |  |  |  | Nearest weather station
Date | Time | Latitude | Longitude | Km from previous point |  | Station name | Date | Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
2020-06-05 00:00:00 | 06:00:04 | 36.19508 | -5.39771
2020-06-05 00:00:00 | 07:00:11 | 36.199 | -5.54932
2020-06-05 00:00:00 | 08:00:11 | 36.18139 | -5.76322
2020-06-05 00:00:00 | 09:00:11 | 36.23083 | -5.77862
2020-06-05 00:00:00 | 10:00:06 | 36.23338 | -5.82721
2020-06-05 00:00:00 | 11:00:07 | 36.37208 | -5.72032
2020-06-05 00:00:00 | 12:00:11 | 36.29772 | -5.63608
2020-06-05 00:00:00 | 13:00:11 | 36.28994 | -5.6325
2020-06-05 00:00:00 | 14:00:05 | 36.29634 | -5.71865
2020-06-05 00:00:00 | 15:00:09 | 36.28393 | -5.73187
Spreadsheet: 847513d1698403996-extract-data-only-if-the-date-is-equal-to-workday-1-excel1
Sheet: Sheet1

 |  |  |  |  | Sales Date | Sales
 | Amount |  |  |  | 2023-10-20 00:00:00 | 246.14
 |  |  |  |  | 2023-10-20 00:00:00 | 39.7
 |  |  |  |  | 2023-10-19 00:00:00 | 53.03
 |  |  |  |  | 2023-10-20 00:00:00 | 152.9
 |  |  |  |  | 2023-10-18 00:00:00 | -40.93
 |  |  |  |  | 2023-10-19 00:00:00 | -408.69
 |  |  |  |  | 2023-10-26 00:00:00 | -911.25
 |  |  |  |  | 2023-10-20 00:00:00 | -86.14
 |  |  |  |  | 2023-10-23 00:00:00 | -129.77
 |  |  |  |  | 2023-10-31 00:00:00 | -423.8
 |  |  |  |  | 2023-11-02 00:00:00 | 158
 |  |  |  |  | 2023-09-20 00:00:00 | 53.21
 |  |  |  |  | 2023-11-04 00:00:00 | 100
 |  |  |  |  | 2023-10-26 00:00:00 | 50
Spreadsheet: 768818d1645133585-counting-matches-with-previous-row-count-duplicate-on-previous-row
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Count total repeats in range? |  |  |  |  |  |  | Count repeats match previous row
17 | 2 | 3 | 4 | 5 | 6
12 | 13 | 17 | 4 | 16 | 7
10 | 18 | 19 | 12 | 23 | 24
10 | 2 | 28 | 6 | 23 | 30
1 | 4 | 12 | 28 | 43 | 12
Spreadsheet: 9afbaa78-1f31-46db-8b73-aa9d5c3dc347
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7461 | 57733 | Masaharu | [NAME] | JPN | 0 | 00:00:00 | 00:00:00 | 00:52:36 | 00:02:06 | 00:45:43 | 1 | 01:40:25
Spreadsheet: 35d6f8e9-8224-4333-829d-0fa85c4dbb97
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4385 | 25144 | [NAME] | Price | USA | 100 | [NAME] | 00:00:00 | 01:33:27 | 00:00:00 | 01:04:55 | 1 | 01:35:24
4385 | 14221 | [NAME] | Wedgerfield | CAN | 112 | 00:30:16 | 00:00:00 | 01:45:21 | 00:00:00 | 01:25:26 | 2 | 01:55:41
4385 | 19335 | [NAME] | Hatelt | CAN | 111 | 00:39:26 | 00:00:00 | 01:45:58 | 00:00:00 | 01:32:36 | 3 | 02:12:03
Spreadsheet: 357076d1415294315-average-of-averages-with-if-averages
Sheet: Team AVG

Date | Team RPE Avg | Team HR Avg | HRR (199) | TIME (MIN) |  |  | AVG RPE's | Correlating HR's | HRR (199) |  | RPE AVG | HR's AVG | HRR
 |  |  | 0.75 |  |  |  | > 6.6 | 136.5 | 0.69 |  | 4 |  | 0.68
 |  |  | 0.68 |  |  |  | < 6.6 | 148 | 0.73 |  | 5 |  | 0.72
 |  |  | 0.77 |  |  |  |  |  |  |  | 6 (6) |  | 0.69
 |  |  | 0.58 |  |  |  |  |  |  |  | 7 (3) |  | 0.75
 |  |  | 0.74 |  |  |  |  |  |  |  | 8 ( 3) |  | 0.73
 |  |  | 0.74
 |  |  | 0.7 |  |  |  | Time in PRCT (Min.); 10/21 Two-A-Day
 |  |  | 0.68 |  |  |  | 70 - 95 | 96 - 130 | > 131
 |  |  | 0.67 |  |  |  | 2014-10-07 00:00:00 | 2014-10-06 00:00:00 | 2014-10-03 00:00:00
 |  |  | 0.77 |  |  |  | 2014-10-10 00:00:00 | 2014-10-08 00:00:00 | 2014-10-04 00:00:00
 |  |  | 0.71 |  |  |  | 2014-10-23 00:00:00 | 2014-10-14 00:00:00 | 2014-10-11 00:00:00
 |  |  | 0.63 |  |  |  | 2014-10-27 00:00:00 | 2014-10-21 00:00:00 | 2014-10-13 00:00:00
 |  |  | 0.68 |  |  |  | 2014-10-28 00:00:00 | 2014-10-24 00:00:00 | 2014-10-22 00:00:00
 |  |  | 0.72
 |  |  | 0.72
Spreadsheet: 852524d1702534777-count-current-streak-of-wins-in-a-column-column-contains-blank-cells-test
Sheet: Sheet1

W
L
W
W
W
L
L
W
W
W
W
W
W
L
W
W
W
W
Spreadsheet: 795004d1662461700-right-forumla-in-vlookup-error-nir-piata-crihala
Sheet: Sheet1

Nr. Doc | NIR | Cod furnizor | Data factura | Data scadenta | Cod articol | Denumire articol | Cota TVA | UM | Denumire Tip Articol | Cantitate | Pret fara tva | Valoare fara tva | TVA | Cont | [NAME]
AV 601 | 396 | 00061 |  |  |  | [NAME] | 9 | Kg | Materii prime | 99 | 7.5
AV 615 | 396 | 00061 |  |  |  | Organe Porc | 9 | Kg | Marfa Piata | 5 | 7.5
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-3-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | Cup | Cheerios
 | Daily Total | 0.75 | Cup | Milk
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | Slice | [NAME]
 |  | 1 | Piece | Ham | 0
 |  | 0.5 | Slice | [NAME]
 |  | 2 | Sticks | Carrot
 |  | 1 | Bag | Honey and Oats | 0
 |  | 0.25 | Cup | Milk
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
 |  | 2 | Cups | [NAME] | 0 | 10
 |  | 0.5 | Cups | Newman's Own Pasta Sauce | 0 | 3
Spreadsheet: c1125fb5-b8d9-49f5-925c-80cfd56ea852
Sheet: พ.ย

 | ภาระงานพนักงานเปล
ลำดับ | รายการ | หน่วยนับ | ค่ากลาง | 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
 |  |  |  | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ | ด | ช1 | ช2 | บ
1 | ลงทะเบียนผู้ป่วยเก่า | ราย | 0.3
2 | ลงทะเบียนผู้ป่วยใหม่ | ราย | 0.5
3 | เปลนอน(จากรถ ER OPD  X-ray) | ครั้ง | 1
4 | เปลนั่ง(จากรถ ER  OPD  X-ray) | ครั้ง | 0.7
5 | เปลนอนจาก ER OPD ตึกผู้ป่วย กายภาพ | ครั้ง | 1.2
6 | เปลนั่งจาก ER OPD ตึกผู้ป่วย กายภาพ | ครั้ง | 1
7 | ส่ง Admit จาก OPD ER ไปตึกส่งเสริม | ครั้ง | 2
8 | ตรวจรับออกซิเจน | ครั้ง | 2
9 | เปลี่ยนถังออกซิเจนต่อถัง | ถัง | 1
10 | ตรวจความพร้อมใช้ออกซิเจน | ครั้ง | 0.5
11 | ให้บริการเบิก / ยืมออกซิเจน | ครั้ง | 1
12 | เปลี่ยนกระเปาะออกซิเจน | ครั้ง | 1
13 | วัด V/S | ราย | 0.7
14 | การทำ TONIGNE TEST | ราย | 0.3
15 | การเจาะ  [NAME] | ราย | 0.3
16 | การจับผู้ป่วย | ราย | 0.5
17 | ช่วย CPR | ครั้ง | 5
18 | ดูแลผู้ป่วยผูกยึด | ราย | 1
19 | ช่วยเตรียมเครื่องมือหัตถการ | ราย | 1
20 | ตัดเผือก | ครั้ง | 1
21 | ฉีดศพ | ครั้ง | 10
22 | ช่วยทำ ADMIT | ครั้ง | 0.5
23 | ทำความสะอาดเปลนั่ง – เปลนอน เปลี่ยนผ้าปู | ครั้ง | 1
24 | ทำความสะอาดโต๊ะอาหาร / โต๊ะหัวหน้า | ครั้ง | 1
25 | ทำความสะอาดโต๊ะ COM / อ่างล้างจาน | ครั้ง | 1
26 | ทำความสะอาดตู้ผ้า / ชั้นลอย ตู้เก็บเอกสาร ถ้วยชาม | ครั้ง | 2
27 | ส่งผ้าและตรวจรับผ้า | ครั้ง | 1
28 | เตรียมน้ำดื่ม | ครั้ง | 1
29 | ประชุมประจำเดือน | ชม. | 3.125
30 | เข้าร่วมกิจกรรม รพ. / ร่วมกิจกรรม 5 ส | ชม. | 3.125
31 | รับส่งเอกสารระหว่างหน่วยงาน | ครั้ง | 1
32 | รับการประเมิน 5 ส  HA  QA | ครั้ง | 8
33 | สำรวจส่งซ่อม | ครั้ง | 1
รวม
เจ้าหน้าที่ปฏิบัติงาน
คุณชำนาญ   ชนีวงศ์
Spreadsheet: 274722d1383206381-how-to-apply-the-function-for-match-and-index-lookup
Sheet: Freight Calculator

Freight Calculator |  |  |  | [NAME] | Freight
 |  |  |  | 0 | 0
 |  |  |  | 2 | 12
Order # | Total Weight ([NAME]) | Freight |  | 4 | 19
23541 | 3 |  |  | 6 | 23
1569A | 7 |  |  | 8 | 30
2146C | 1 |  |  | 12 | 130
98421C | 1 |  |  | 20 | 150
451627 | 15
Spreadsheet: 681288d1591452154-help-with-automatically-populating-cells-kindergarden
Sheet: Apr - Reg

 |  | Month | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM | 30
 |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day FT | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day PT | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 FD | 20.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 AM | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 PM | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 PT | 19.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol AM | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol PM | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol All Day FT | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol All Day PT | 41
Invoice Number | Child's Name | Parent's Name | Address
 |  |  |  | 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
0420/01 |  |  |  |  | PM |  |  |  | All Day PT |  | All Day PT | Hol 1/2 FD |  |  |  |  |  | PM
Spreadsheet: 3c6b8fa0-6290-45b7-84fb-ed11c18d1332
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Country | 2013/14 | 2012/13 | 2012/13 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market | market
region | April 2014 | April  2013 | year | year | year | year | year
 |  |  |  | 1,000 metric tons
ASIA | 458.564 | 470.232 | 624.791 | 541.502 | 529.833 | 563.944 | 536.401
China | 2.334 | 2.411 | 2.709 | 3.584 | 3.1 | 3.786815 | 3.951477
India | 101.764 | 92.739 | 129.252 | 110.541 | 96.454 | 94.81 | 74.05
Pakistan | 19.748 | 10.573 | 17.648 | 15.224 | 17.297 | 19.387 | 16.852
Thailand | 298.411 | 305.473 | 393.738 | 387.642 | 393.464 | 400.977 | 422.132
Vietnam | 33.254 | 56.635 | 77.895 | 21.664 | 15.901 | 41.554 | 17.478
Other | 3.053000000000019 | 2.401000000000003 | 3.549000000000078 | 2.84699999999998 | 3.616999999999962 | 3.429461 | 1.938601
EUROPE & FORMER SOVIET UNION | 8.923 | 9.489 | 11.137 | 14.256 | 12.51 | 9.411 | 7.566
Italy | 5.969 | 5.875 | 6.925 | 5.215 | 7.53 | 6.22 | 5.732
Spain | 0.884 | 2.066 | 2.217 | 4.669 | 3.753 | 1.55218 | 0.419
Russia | 0.022 | 0.031 | 0.039 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.252 | 0.112 | 0.112 | 0.039 | 0.009 | 0.126 | 0.43
Other | 1.796 | 1.405000000000001 | 1.844000000000001 | 4.309000000000001 | 1.183999999999999 | 1.480378 | 0.9205439999999996
WESTERN HEMISPHERE | 30.422 | 26.716 | 35.871 | 64.526 | 42.735 | 30.357 | 31.065
Argentina | 2.827 | 3.73 | 5.453 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 11.179 | 3.957 | 4.979 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 10.417 | 8.629 | 12.051 | 16.323 | 17.067 | 15.358 | 18.036
Mexico | 0.984 | 0.766 | 0.996 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 4.329 | 9.57 | 12.322 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.6859999999999973 | 0.06400000000000006 | 0.07000000000000384 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 32.80699999999999 | 1.400999999999993 | 2.807999999999915 | 0.9570000000000363 | 3.532636 | 5.470538 | 39.298261
Egypt | 0 | 0.591 | 0.639 | 0.001 | 0 | 0.645 | 36.591
United Arab Emirates | 0.187 | 0.249 | 0.269 | 0.522 | 3.03 | 4.441 | 2.225
Australia | 32.061 | 0.108 | 0 | 0.016 | 0 | 0 | 0
Other | 0.5589999999999904 | 0.4529999999999927 | 1.899999999999914 | 0.4180000000000362 | 0.5026360000000003 | 0.384538 | 0.4822609999999954
TOTAL | 530.716 | 507.838 | 674.607 | 621.241 | 588.611 | 609.182 | 614.331
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated June 12, 2014.
Spreadsheet: mary_fischer__25637__31T
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
COMPANY NAME    Limbach Investment Company
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: Sonya City
EXTENSION: 3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 238584d1369636513-pulling-data-from-one-spread-sheet-into-another-pull-data-
Sheet: Sheet1

Date | Price
2013-05-24 00:00:00 | 214.62
2013-05-23 00:00:00 | 216.32
2013-05-22 00:00:00 | 224.38
2013-05-21 00:00:00 | 224.41
2013-05-20 00:00:00 | 226.29
2013-05-17 00:00:00 | 229.5
2013-05-16 00:00:00 | 229.54
2013-05-15 00:00:00 | 228.77
2013-05-14 00:00:00 | 225.9
2013-05-13 00:00:00 | 223.4
2013-05-10 00:00:00 | 222
2013-05-09 00:00:00 | 221.37
2013-05-08 00:00:00 | 217.8
2013-05-07 00:00:00 | 214 |  |  |  |  |  | Price
2013-05-06 00:00:00 | 214.3 |  | Start Date | 2013-05-24 00:00:00 | 214.62 | 216.32 | 224.38 | 224.41 | 226.29 | 229.5 | 229.54 | 228.77 | 225.9 | 223.4 | 222 | 221.37 | 217.8
2013-05-03 00:00:00 | 217.1
2013-05-02 00:00:00 | 216.05
2013-05-01 00:00:00 | 214.75
2013-04-30 00:00:00 | 211.88
2013-04-29 00:00:00 | 213.24
2013-04-26 00:00:00 | 213.43
2013-04-25 00:00:00 | 209.71
2013-04-24 00:00:00 | 218.73
2013-04-23 00:00:00 | 214.11
2013-04-22 00:00:00 | 214.15
2013-04-19 00:00:00 | 209.08
2013-04-18 00:00:00 | 213.48
2013-04-17 00:00:00 | 212.22
2013-04-16 00:00:00 | 210.66
Spreadsheet: 45808d1244597813-time-sheets-payroll-team-baxter
Sheet: Carver

 |  |  |  |  |  |  |  |  |  |  | Pay | Commissioned EE's,
 |  |  |  |  |  |  |  |  | Pay Type |  | Code | (enter rate for light duty only)
 |  |  |  |  |  |  |  | Training |  |  | TR
 | Weekly Time Sheet - NO MILEAGE |  |  |  |  |  |  | QC |  |  | QC
 | DIRECTV Home Services (DTVHS) |  |  |  |  |  |  | Warehouse |  |  | WH
 |  |  |  |  |  |  |  | Light Duty |  |  | LD
 |  |  |  |  |  |  |  | Clerical |  |  | CL
Please use this timesheet effective May 7, 2009. |  |  |  |  |  |  |  | Service Call Tech |  |  | SCT
 |  |  |  |  |  |  |  | [NAME] |  |  | HT
 |  |  |  |  |  |  |  | Drive Time |  |  | [NAME]
 |  |  |  |  |  |  |  | Uptraining |  |  | UTR
 |  |  |  |  |  |  |  | Field Tech - Commission
 |  | Employee Name |  | [NAME] |  |  |  |  | Employee Number
 |  | Week ending |  | Friday June 12, 2009 |  |  |  |  | City and State |  | Cartersville, Ga
 |  | Ops ID |  | 5G04
 |  |  |  |  |  | All Employees |  |  | Commission [NAME] |  |  | Non-Work Hours
Day | Date | Start Time | Time out for meal | Time in after meal | End Time | Total Regular Hours | Total OT Hours* | Total DT Hours** | Total Commis-sion Hours | Total Non-Commis-sion Hours | Pay Code | Other Hours | Other Pay Code
Sat. | 2009-06-06 00:00:00 | 06:00:00 | 11:00:00 | 12:00:00 | 16:00:00
Sun. | 2009-06-07 00:00:00
Mon. | 2009-06-08 00:00:00
Tue. | 2009-06-09 00:00:00
Wed. | 2009-06-10 00:00:00
Thur. | 2009-06-11 00:00:00
Fri. | 2009-06-12 00:00:00
 |  |  |  | Weekly Totals |  |  |  | 0 | 0 | 0 |  | 0
 |  | Other pay:  V = Vacation    S = Sick    B = Bereavement    J = Jury Duty    H – Holiday |  |  |  |  |  |  |  | 8
 |  | *Record California, Colorado and Nevada overtime hours daily.  All other states, record overtime weekly
 |  | CA OT over 8 hours per day or on 7th working day in a row; CO OT over 12 hours per day; NV:  OT over 8 hours per day
 |  | **CA only:  Double time hours for any time over 12 hours per day
 | Employee Signature |  |  |  |  | Date
 | Manager/Supervisor Signature |  |  |  |  | Date
Spreadsheet: 801051d1666049165-generate-list-based-on-multiple-criteria-list-active-projects-by-engineer-list-active-projects-by-engineer-eamono
Sheet: Sheet1

 | Status |  |  |  | Internal Code | customer name | project name | engineers assigned |  | List of what projects [NAME] is working on
 | Design |  |  |  | PLS2209166 | customer a | project name a | [NAME], TJ, [NAME] |  | [NAME]
 | TBA |  |  |  | PLS2209167 | customer b | project name b | [NAME], [NAME]
 | Lost |  |  |  | PLS2209168 | customer c | project name c | [NAME]
 | Feasibility |  |  |  | [NAME] | [NAME] | project name d | [NAME]
 | Lost |  |  |  | PLS2209170 | customer e | project name e | [NAME]
 |  |  |  |  |  |  |  |  |  | Thank you in advance!
 |  | List of ACTIVE projects [NAME] is working on
 |  | [NAME]
 |  | CONCATENATE(Internal Code b, project name b)
 |  | CONCATENATE(Internal Code d, project name d) |  |  |  | End Goal: list of active projects [NAME] works on. From Column B (status), any of "Design","Quoting","Feasibility","Post Design" are considered active
 |  | etc… |  |  |  | I've figured out how to get a list of internal codes for projects [NAME] works on. However, AND() doesn't return an array like IF() does, so it doesn't fit in my formula
 |  |  |  |  |  | I want to say IF cell[X,I] contains "[NAME]" AND cell[X,B] is one of "Design","Quoting","Feasibility","Post Design" then return true, RETURN AN ARRAY
 |  |  |  |  |  | Where I'm at now:
 |  |  |  |  |  | Current: | Expected: | infuriating, because hardcoding it works as expected:
 |  |  |  |  |  |  | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | True | False
 |  |  |  |  |  | False | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | False | False
Spreadsheet: 187494d1350474412-referencing-the-first-15-names-in-a-list-a-list-that-is-manually-altered-bycopy-paste-etc-excel-help-forum2
Sheet: input

Rank |  |  |  |  |  |  |  | Category |  | Likelihood | Primary Impact Type | Most Likely Impact | Comments | Risk Treatment |  | Date of Initial Assessment | Date of Last Review | Risk Occurred?
 | name | Cause (IF) | Risk Event (THEN) | Consequence Affecting Objectives (RESULTING IN) |  |  |  | Category | Sub-category |  |  |  |  | Proactive | Reactive
 | sdf |  |  |  |  |  |  | 4. s | 1.6. | Certain or almost certain |  | Moderate
 | dsfa |  |  |  |  |  |  | 6 | 1.3. | Possible |  | Insignificant
 | gsda |  |  |  |  |  |  | 7 | 2.1. | Probable |  | Catastrophic
 | gads |  |  |  |  |  |  | 1 | 7.10. S | Unlikely |  | Major
 |  |  |  |  |  |  |  |  | 2.1. | Unlikely |  | Minor
Spreadsheet: 152218d1335289079-percent-of-dollars-per-account-per-issuer-copied-down-excelhelp
Sheet: Sheet12

[NAME] | Principal | Account | Concentration
[NAME] | 100 | 1 | % of principal per issuer, per account, copied all the way down.
[NAME] | 200 | 1
[NAME] | 400 | 1
[NAME] | 50 | 1
[NAME] | 200 | 2
[NAME] | 200 | 2
[NAME] | 500 | 2
[NAME] | 700 | 2
[NAME] | 100 | 2
[NAME] | 2000 | 2
[NAME] | 325 | 3
[NAME] | 100 | 3
[NAME] | 50 | 3
[NAME] | 775 | 4
[NAME] | 500 | 4
[NAME] | 700 | 4
[NAME] | 100 | 4
[NAME] | 500 | 4
Spreadsheet: 163996d1340595965-tabulate-data-counts-from-pivot-table-book1
Sheet: Sheet1

DATA |  |  |  |  |  |  |  | Desired Outcome: To Tabulate the no. of repeat stays (by count) from the pivot table.  ***The table below was tabulated manually, wondering if theres a function to this from pivot table data.
MEMBERSHIP_CARD_NO | MEMBERSHIP_LEVEL | RESORT | DEPARTURE_DATE | NUMBER_NIGHTS | MONTH | YEAR
9251 | GOLD | DPS | 2010-09-08 00:00:00 | 14
7061 | PLATINUM | CGK | 2012-08-01 00:00:00 | 5
2045 | BLACK | PVG | 2011-08-01 00:00:00 | 2
2761 | RED | CGK | 2010-08-02 00:00:00 | 3 |  |  |  |  | No. of Stay | Count
7061 | PLATINUM | DPS | 2012-06-01 00:00:00 | 4 |  |  |  |  |  | 2010 | 2011 | 2012
7061 | PLATINUM | MNL | 2012-06-01 00:00:00 | 4 |  |  |  |  | 1 | 2 | 4 | 1
9251 | GOLD | DPS | 2011-12-08 00:00:00 | 14 |  |  |  |  | 2
9251 | GOLD | DPS | 2012-11-08 00:00:00 | 14 |  |  |  |  | 3 |  |  | 1
2761 | RED | CGK | 2011-08-02 00:00:00 | 3 |  |  |  |  | 4
2733 | GOLD | MNL | 2011-08-10 00:00:00 | 3
Count of NUMBER_NIGHTS | Column Labels
Row Labels | 2010 | 2011 | 2012 | Grand Total
2045 |  | 1 |  | 1
2733 |  | 1 |  | 1
2761 | 1 | 1 |  | 2
7061 |  |  | 3 | 3
9251 | 1 | 1 | 1 | 3
Grand Total | 2 | 4 | 4 | 10