tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275273d1383427884-vlookup-on-multiple-column-data-test
Sheet: Before

[NAME] |  |  | D&B # - AIMS (via SFDC) | D&B # | D&B # - SFDC
1234232 |  |  | 124213123 | 123123 | 156192481
243574188 |  |  | 1232321313 | 243574188 | 243574188
248175676 |  |  | 2142141 | 12321321 | 248175676
248134236 |  |  | 322132 | 23213123 | 248134236
42324124 |  |  | 213213 | 2321321 | 12123213
12314521421 |  |  | 12321311 | 243113938 | 123213
123213 |  |  | 113213 | 123213 | 1232131
124214 |  |  | 1232124 | 2321 | 1232132
12321 |  |  | 1223213 | 23213 | 252004577
123213 |  |  | 1213213 | 12321 | 200521102
257432823 |  |  | 142321 | 123221 | 257432823
123213 |  |  | 1213213 | 243967259 | 12321312
Spreadsheet: 192343d1352385575-filtering-help-sos-book1
Sheet: Summary (3)

Root Cause Analysis |  |  | Root Cause Analysis
Day | Reason | Root Cause | Corrective Action | Who | When | Impact by YE
 | Machines | Conveyance Equipment |  | [NAME] |  |  |  |  |  | Man | Materials | Methods | Machines | Management | Mother Nature
 | Materials | Lack of Drive Train Parts |  |  |  |  |  |  |  | Lack of People | Lack of Frames | Wrong Part Installed | Hand Tools | Plant Training | Bad Weather
 | Methods | Wrong Part Installed |  |  |  |  |  |  |  | Cross Training | Lack of Rear Suspention Parts | Part Installed Incorrectly | Station Tools | Schedule Change
 | Machines | Station Tools |  |  |  |  |  |  |  |  | Lack of Front Suspension Parts |  |  | Parts Mix
 | Management | Schedule Change |  |  |  |  |  |  |  |  | Lack of Drive Train Parts |  | Conveyance Equipment
 | Mother Nature | Bad Weather |  |  |  |  |  |  |  |  | Lack of Wheels or Tires
 | Man | Lack of People |  |  |  |  |  |  |  |  | Lack of Interier Plastic |  | Planed PM
 | Methods | Part Installed Incorrectly |  |  |  |  |  |  |  |  | Lack of Exterier Plastic
 | Management | Schedule Change |  |  |  |  |  |  |  |  | Lack of Cab Cage Components
 | Methods | Wrong Part Installed |  |  |  |  |  |  |  |  | Faulty Part
 | Management | Plant Training
 | Mother Nature | Bad Weather
 | Man | Lack of People
 | Machines | Conveyance Equipment
 | Management | Parts Mix
 | Methods | Wrong Part Installed
 | Materials | Lack of Wheels or Tires
 | Materials | Lack of Rear Suspention Parts
 | Management | Plant Training
 | Materials | Lack of Front Suspension Parts
 | Management | Plant Training
 | Man | Lack of People
 | Methods | Wrong Part Installed
 | Methods | Part Installed Incorrectly
 | Materials | Lack of Rear Suspention Parts
 | Machines | Lack of Frames
 | Machines | Conveyance Equipment
 | Man | Lack of People
 | Management | Schedule Change
 | Methods | Part Installed Incorrectly
 | Mother Nature | Bad Weather
 |  |  |  |  |  |  |  | [NAME]
1st Level Pareto |  | 2st Level Pareto |  |  |  |  |  | 1st Level Pareto |  | 2st Level Pareto
Reasons | Totals |  |  |  | Totals
Man |  |  |  |  |  | 1
Materials |  |  |  |  |  | 2
Management |  |  |  |  |  | 3
Machines |  |  |  |  |  | 4
Methods |  |  |  |  |  | 5
Mother Nature |  |  |  |  |  | 6
 |  |  |  |  |  | 7
 |  |  |  |  |  | 8
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  |  |  |  |  | 21
 |  |  |  |  |  | 22
 |  |  |  |  |  | 23
Spreadsheet: da5f8797-2640-40ec-8699-4b52e74241e5
Sheet: Sheet1

Unnamed: 0 | 第８表　（別表） [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | 市区町村名 | 登録者総数 |  |  | 市区町村名 | 登録者総数
1 | 大阪市生野区 | 32192 |  | 51 | 神戸市長田区 | 7580
2 | 新宿区 | 29986 |  | 52 | 大垣市 | 7539
3 | 江戸川区 | 22277 |  | 53 | 大阪市平野区 | 7533
4 | 足立区 | 21840 |  | 54 | 大阪市西成区 | 7397
5 | 港区 | 20957 |  | 55 | 可児市 | 7342
6 | 豊橋市 | 20445 |  | 56 | [NAME] | 7324
7 | 東大阪市 | 18462 |  | 57 | 八尾市 | 7125
8 | 川口市 | 17947 |  | 58 | つくば市 | 7088
9 | 江東区 | 17666 |  | 59 | 西宮市 | 6881
10 | 大田区 | 17380 |  | 60 | 文京区 | 6878
11 | 豊島区 | 16428 |  | 61 | 邑楽郡大泉町 | 6843
12 | 板橋区 | 16249 |  | 62 | 横浜市南区 | 6796
13 | 豊田市 | 16084 |  | 63 | [NAME] | 6691
14 | 世田谷区 | 15242 |  | 64 | 安城市 | 6601
15 | 横浜市中区 | 14417 |  | 65 | 福岡市東区 | 6550
16 | 浜松市中区 | 14211 |  | 66 | 大和市 | 6428
17 | 北区 | 14185 |  | 67 | 大阪市中央区 | 6422
18 | 荒川区 | 13958 |  | 68 | 福山市 | 6380
19 | 葛飾区 | 13086 |  | 69 | [NAME] | 6356
20 | 練馬区 | 13083 |  | 70 | 京都市南区 | 6254
21 | 尼崎市 | 12329 |  | 71 | 藤沢市 | 6146
22 | 市川市 | 12309 |  | 72 | 浜松市南区 | 5827
23 | 岡崎市 | 11989 |  | 73 | 美濃加茂市 | 5807
24 | 伊勢崎市 | 11987 |  | 74 | 京都市左京区 | 5785
25 | 神戸市中央区 | 11665 |  | 75 | 厚木市 | 5773
26 | 品川区 | 11310 |  | 76 | 西尾市 | 5743
27 | 渋谷区 | 11150 |  | 77 | 京都市右京区 | 5715
28 | [NAME] | 10865 |  | 78 | 豊川市 | 5695
29 | 川崎市川崎区 | 10710 |  | 79 | 甲府市 | 5616
30 | 台東区 | 10686 |  | 80 | 大阪市東淀川区 | 5591
31 | 相模原市 | 10589 |  | 81 | 一宮市 | 5585
32 | 杉並区 | 10584 |  | 82 | 倉敷市 | 5483
33 | 中野区 | 10539 |  | 83 | 掛川市 | 5466
34 | 船橋市 | 10287 |  | 84 | 柏市 | 5449
35 | 松戸市 | 10249 |  | 85 | 小山市 | 5436
36 | 鈴鹿市 | 10012 |  | 86 | 上田市 | 5417
37 | 磐田市 | 9907 |  | 87 | 富山市 | 5416
38 | 四日市市 | 9860 |  | 88 | 大阪市淀川区 | 5251
39 | [NAME] | 9714 |  | 89 | 名古屋市中川区 | 5223
40 | 岐阜市 | 9353 |  | 90 | 千葉市美浜区 | 5197
41 | 津市 | 9166 |  | 91 | 浜松市東区 | 5126
42 | 小牧市 | 9026 |  | 92 | 千葉市中央区 | 5125
43 | [NAME] | 8879 |  | 93 | 神戸市東灘区 | 5119
44 | 墨田区 | 8767 |  | 94 | 刈谷市 | 5069
45 | 太田市 | 8726 |  | 95 | 市原市 | 5057
46 | 八王子市 | 8356 |  | 96 | 横浜市港北区 | 5029
47 | 京都市伏見区 | 8312 |  | 97 | 仙台市青葉区 | 5013
48 | 目黒区 | 7875 |  | 98 | 大阪市浪速区 | 5009
49 | 大阪市東成区 | 7819 |  | 99 | [NAME] | 4942
50 | 宇都宮市 | 7798 |  | 100 | 伊賀市 | 4911
Spreadsheet: kate_symes__18967__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
Spreadsheet: 121010d1315765389-setting-up-a-project-point-sheet
Sheet: Suggest

Full | First | Last | Teacher | m/f | Date | Code | Behavior
[NAME] | [NAME] | Hall | 6-3 | m | 2011-09-01 00:00:00 | CZ2 | Dress Code
[NAME] | Jakob | Ertzbischoff | 6-2 | m | 2011-09-08 00:00:00 | CZ5 | Electronics Out
 |  |  |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  |  |  |  | Both Column A and G are both Validation entries from dropdowns
 |  |  |  |  |  |  |  |  |  | Column F can be typed in or [NAME]; (semicolon) to enter today's date
 |  |  |  |  |  |  |  |  |  | Look at all the formulas in the table to the left
 |  |  |  |  |  |  |  |  |  | Also note - Two named ranges in the formulas
 |  |  |  |  |  |  |  |  |  | The hope is that you only need to enter 3 things to build the tabel
 |  |  |  |  |  |  |  |  |  | Student Name
 |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  | Code
 |  |  |  |  |  |  |  |  |  | If you keep the data like suggested,
 |  |  |  |  |  |  |  |  |  | you won't need to break out dates as a Pivot will do it
 |  |  |  |  |  |  |  |  |  | You will be able to filter and sort by teacher, student dates.
 |  |  |  |  |  |  |  |  |  | You could include another column I to lookup points for each infraction
 |  |  |  |  |  |  |  |  |  | I didn't understand the 7 point thing.
Spreadsheet: 71047d1271789809-excel-2007-return-an-item-from-an-invoice-book2
Sheet: Invoice

INVOICE
 |  | DATE:
 |  | INVOICE # | 100
 |  | FOR: | Sale of Dogs
Owner ID
Owners Name
[NAME] | Dog Cost | Amt Dog | Total Price
Dog ID | 400 | 2
Dog Name
Breed ID
Breed Name
Dog Weight
Price
 |  | SUBTOTAL
 |  | TAX RATE | 0.065
 |  | SALES TAX
 |  | DELIVERY
 |  | TOTAL
Spreadsheet: 794890d1662384212-adding-cc-in-mailto-hyperlink-working-file
Sheet: Warehouse

Machine | [NAME] | Aanvraag
A | 12345
B | 123456
Spreadsheet: 46e9caab-f631-4ba5-93c9-a199b873070d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3194 | 15980 | Billy | [NAME] | PAN | 9 | 00:25:25 | 00:00:29 | 01:50:37 | 00:01:46 | 01:06:25 | 1 | 03:24:44
3194 | 15982 | [NAME] | Rodriguez | PAN | 10 | 00:34:09 | [NAME] | 01:52:40 | 00:00:49 | 01:19:54 | 2 | 03:48:26
Spreadsheet: theresa_staab__39631__Gas Avails Restricted flows - Oct 2001
Sheet: Sheet1

Gas Avails. - Powder River
2001-10-01 00:00:00
Preliminary
 | Mcf |  |  |  | Mmbtu | MMBtu |  |  | Allocated | Allocated | Allocated
 | Wellhead |  |  |  | Wellhead | Less fuel |  |  | mmBtu  at | mmBtu  at | mmcf  at
 | Nomination | Firm Capacity | IT | Btu Factor | Confirmation | to Glennrock |  |  | Glennrock | Wellhead | Wellhead
[NAME]/So. Kitty/Maverick
Kennedy #1 | 3000 |  |  | 0.958
Kennedy #2 | 3500 |  |  | 0.956
Kennedy #3 | 3000 |  |  | 0.953
Kennedy #4 | 4100 |  |  | 0.955
Kennedy Box Draw Total
S. Kitty #1 | 7000 |  |  | 0.96
S. Kitty #2 | 10200 |  |  | 0.959
S. Kitty #4 | 10500 |  |  | 0.949
S. Kitty #5 | 3600 |  |  | 0.954
Kennedy S. Kitty Total
Kennedy Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000
Wellstar #1 | 1100 |  |  | 0.93
Wellstar #2 | 1400 |  |  | 0.926
Wellstar Box Draw Total
Box Draw Total
[NAME]
Clydesdale
Clydesdale #1 | 5278 |  |  | 0.942
Clydesdale #2 | 2689 |  |  | 0.951
Clydesdale #3 | 2790 |  |  | 0.945
Phillips Clydesdale Total
Caballo
MTG | 800 |  |  | 0.945
[NAME] | 900 |  |  | 0.938 |  |  |  |  | 0 | 0 | 0
Palomino #1 | 1410 |  |  | 0.936
Palomino #2 | 2009 |  |  | 0.939
Geer #1 | 649 |  |  | 0.925
Phillips Palomino Total
Quantum | 800 |  |  | 0.967
Independent | 18000 |  |  | 0.937
Caballo Total
TOTAL ENA |  |  |  |  |  |  |  | Fixed Volume at Glennrock | 49053
Phillips Total Production
[NAME]
Wellstar
Independent Actual Flow | 15100
Spreadsheet: 810608d1671887580-filtering-data-book2test
Sheet: Sheet1

 |  |  | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 |  |  |  | Subject A | Subject B | Subject C |  | Result
 |  | Student 1 |  |  | 40 | 47 |  | 43 | 50 | 53 |  |  |  |  |  |  |  | student 1
 |  | Student 2 |  |  | 30 |  |  | 22 |  | 28 |  |  |  |  |  |  |  | student 2
 |  | Student 3 |  |  | 46 |  |  | 65 |  |  |  |  |  |  |  |  |  | student 12
 |  | Student 4 |  |  | 39 |  |  | 43 |  |  |  |  |  |  |  |  |  | student 14
 |  | Student 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | student 37
 |  | Student 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 46
 |  | Student 7 |  |  |  |  | 50 | 60
 |  | Student 8 |  |  |  |  |  |  |  |  |  |  | 66
 |  | Student 9
 |  | Student 10
 |  | Student 11 |  |  | 41 |  |  | 67 | 40 | 50
 |  | Student 12 |  |  | 17 |  | 22 | 25 |  | 28
 |  | Student 13 |  |  |  |  | 40
 |  | Student 14 | 13 | 20 | 10 | 19 | 0 | 15 | 21 | 25
 |  | Student 15 |  | 71 | 55 |  | 52 | 43
 |  | Student 16 |  |  | 50 |  |  |  |  | 41
 |  | Student 17
 |  | Student 18
 |  | Student 19
 |  | Student 20 |  |  |  |  |  | 70
 |  | Student 21 |  |  |  |  |  |  | 55 | 51
 |  | Student 22 |  |  | 51 |  |  | 39 |  | 51
 |  | Student 23
 |  | Student 24 |  |  |  |  |  | 50
 |  | Student 25
 |  | Student 26 |  |  | 50 |  |  | 59
 |  | Student 27
 |  | Student 28
 |  | Student 29
 |  | Student 30 |  |  | 40 |  |  | 50
 |  | Student 31
 |  | Student 32 |  |  |  |  |  | 50
 |  | Student 33 |  |  |  |  |  |  |  | 51
 |  | Student 34 |  |  |  |  |  | 21
 |  | Student 35 |  |  | 43 |  | 50 | 44
 |  | Student 36
 |  | Student 37 |  |  | 10 |  |  | 18 |  | 29
 |  | Student 38 |  |  |  |  |  | 79 |  | 67
 |  | Student 39
 |  | Student 40 |  |  | 43
 |  | Student 41
 |  | Student 42 |  |  | 33 |  | 50 | 53 | 48 | 50
 |  | Student 43 |  |  | 52 |  |  | 43 |  | 50
 |  | Student 44
 |  | Student 45 |  |  | 43 |  | 52 | 52 |  | 56
 |  | Student 46 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Student 47 |  |  | 40 |  |  | 52 |  | 50
 |  | Student 48
 |  | Student 49 |  |  |  |  |  | 64
 |  | Student 50 |  |  | 10 |  |  | 31
Spreadsheet: john_griffith__16020__2_4_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 142 | 152 | 53.8 | 57.6 | 0.7 | 2002-02-04 13:48:00
 | CL J2 | 20.5 | 255 | 265 | 47.9 | 49.8 | 0.63 | 2002-02-04 13:48:00
 | CL K2 | 20.5 | 335 | 345 | 46.5 | 47.9 | 0.61 | 2002-02-04 13:48:00
 | CL M2 | 20.5 | 380 | 395 | 44.7 | 46.5 | 0.59 | 2002-02-04 13:48:00
 | CL N2 | 20.5 | 425 | 440 | 43.8 | 45.3 | 0.57 | 2002-02-04 13:48:00
 | CL Q2 | 20.5 | 450 | 465 | 42 | 43.5 | 0.55 | 2002-02-04 13:48:00
 | CL U2 | 20.5 | 465 | 485 | 40.2 | 42 | 0.53 | 2002-02-04 13:48:00
 | [NAME] | 21 | 480 | 500 | 37.6 | 39.1 | 0.51 | 2002-02-04 13:48:00
 | CL X2 | 21 | 490 | 515 | 36.1 | 38 | 0.49 | 2002-02-04 13:48:00
 | [NAME] | 21 | 495 | 520 | 34.8 | 36.5 | 0.47 | 2002-02-04 13:48:00
 | CL F3 | 21 | 495 | 525 | 33.1 | 35.2 | 0.45 | 2002-02-04 13:48:00
 | CL G3 | 21 | 500 | 530 | 32.1 | 34.1 | 0.44 | 2002-02-04 13:48:00
 | CL M3 | 21 | 535 | 570 | 30.1 | 32.1 | 0.41 | 2002-02-04 13:48:00
 | CL Z3 | 21 | 545 | 575 | 26.7 | 28.2 | 0.36 | 2002-02-04 13:48:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 70809d1271503039-names-to-numbers-mileagelog-1-
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form |  |  |  |  |  |  |  | http://www.hypermiler.co.uk/mpg-calculator.html
 |  |  |  |  |  |  |  | http://www.hmrc.gov.uk/cars/advisory_fuel_current.htm
Employee Name | [NAME] |  |  |  |  | Rate Per Mile |  |  | 0.12 |  | per lit | 1.09
Employee ID |  |  |  |  |  | For Period |  |  | From 25/10/09 to 27/10/09 |  | per gal | 4.9595
Vehicle Description | fiat 500 |  |  |  |  | Total Mileage |  |  | 365 |  | per mile | 12p
Authorized By |  |  |  |  |  | Total Reimbursement |  |  | 43.8
Date |  | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | Hours | [NAME] | Odometer End | Mileage | Reimbursement
2009-10-25 00:00:00 |  | Shahima | [NAME] | Chenga | [NAME] |  |  |  |  |  | 170 | 20.4
2009-10-27 00:00:00 |  | [NAME] | Mario | Marcol |  |  |  |  |  |  | 185 | 22.2
 |  | Bethan |  |  |  |  |  |  |  |  | 10 | 1.2
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | Totals | 365 | 43.8
Spreadsheet: 691751d1597856473-countif-number-of-1s-between-2-dates-2020-08-19-oeldere-jm45t3r5-691728d1597846867-countif-number-of-1s-between-2-dates-countif-be
Sheet: Sheet1

 | Date Range |  |  |  | "1" is Breach
 | End | 2020-07-31 00:00:00 |  |  | "0" is no breach
 | Start | 2020-07-01 00:00:00
 |  |  |  |  |  | AAA | BBB | CCC | DDD
 |  | Person | Number of breaches (Number of "1s") |  | Dashboard / Liquidity Date | [NAME] | [NAME] | [NAME] | [NAME] | month
 | AAA | [NAME] |  |  | 2020-07-01 00:00:00 | 0 | 0 | 0 | 0
 | BBB | [NAME] |  |  | 2020-07-02 00:00:00 | 1 | 0 | 0 | 0
 | CCC | [NAME] |  |  | 2020-07-03 00:00:00 | 0 | 1 | 0 | 0
 | DDD | [NAME] |  |  | 2020-07-06 00:00:00 | 0 | 0 | 0 | 1
 |  |  |  |  | 2020-07-07 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-07-08 00:00:00 | 0 | 1 | 0 | 0
 |  |  |  |  | 2020-07-09 00:00:00 | 0 | 0 | 1 | 0
 |  |  |  |  | 2020-07-10 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-13 00:00:00 | 0 | 0 | 1 | 0
 |  |  |  |  | 2020-07-14 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-15 00:00:00 | 0 | 1 | 0 | 1
 |  |  |  |  | 2020-07-16 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-17 00:00:00 | 0 | 1 | 0 | 0
 |  |  |  |  | 2020-07-20 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-21 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-07-22 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-23 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-24 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-27 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-28 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-29 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-30 00:00:00 | 0 | 0 | 0 | 1
 |  |  |  |  | 2020-07-31 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-08-03 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-04 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-05 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-06 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-07 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-10 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-11 00:00:00 | 1 | 1 | 0 | 0
 |  |  |  |  | 2020-08-12 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-13 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-08-14 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-17 00:00:00 | 1 | 0 | 1 | 0
 |  |  |  |  | 2020-08-18 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-19 00:00:00 | 1 | 0 | 0 | 0
Spreadsheet: 677806d1589535241-countifs-help-manhole-table
Sheet: Surface Manhole Schedule

 |  |  |  |  | upto 1 | upto 1.25 | upto 1.5 | upto 1.75 | upto 2 | upto 2.25 | upto 2.5 | upto 2.75 | upto 3 | upto 3.25 | upto 3.5 | upto 3.75 | upto 4 | upto 4.25 | upto 4.5 | upto 4.75 | upto 5 | upto 5.25 | upto 5.5 | upto 5.75 | upto 6 | upto 6.25 | upto 6.5 | upto 6.75 | upto 7 | upto 7.25 | upto 7.5 | upto 7.75 | upto 8 | upto 8.25
 |  | 900
 |  | 1050
 |  | 1200
 |  | 1350
 |  | 1500
 |  | 1800
 |  | 2100
 |  | 2400
 |  | 2700
 |  | 3000
Spreadsheet: 845300d1696846058-populating-client-wise-sub-table-from-master-sales-table-daily-sales
Sheet: DailySale

 |  |  |  |  |  |  |  |  | Start Date | 2023-09-09 00:00:00
 |  |  |  |  |  |  |  |  | End Date | 2023-09-09 00:00:00
 |  |  |  |  |  |  |  |  | Customer Name | Item | Qty | Total
 |  |  |  |  |  |  |  |  | [NAME] | 5 KG Bags | 40 | 1000
 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 25 | 1250
Sr. No | Sale Date | Customer Name | City | Item | Qty | Rate | Total |  | [NAME] | 5 KG Bags | 20 | 500
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | 5 KG Bags | 40 | 25 |  |  | [NAME] | 01 KG Bags | 15 | 150
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | [NAME] | 25 | 50 |  |  | [NAME] | [NAME] | 500 | 5000
 | 2023-09-09 00:00:00 | [NAME] | Baroda | 5 KG Bags | 20 | 25 |  |  | [NAME] | [NAME] | 300 | 4500
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | 01 KG Bags | 15 | 10 |  |  | [NAME] | [NAME] | 100 | 2000
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | [NAME] | 500 | 10
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | [NAME] | 300 | 15
 | 2023-09-09 00:00:00 | [NAME] | [NAME] | [NAME] | 100 | 20
 | 2023-09-10 00:00:00 | [NAME] | Baroda | [NAME] | 300 | 10
 | 2023-09-10 00:00:00 | Vipul Prajapati | Amdavad | [NAME] | 5000 | 20
Spreadsheet: 864170d1711460315-list-of-customers-with-products-ordered-map1
Sheet: bike sales

Klant | customer a |  |  |  |  | customer b |  |  |  |  | customer c |  |  |  |  | [NAME]
 | bike A |  | Bike B |  |  | bike A |  | Bike B |  |  | bike A |  | Bike B |  |  | bike A |  | Bike B
week | big | small | big | small |  | Groot | Klein | Groot | Klein |  | Groot | Klein | Groot | Klein |  | Groot | Klein | Groot | Klein
1
2
3
4
5
6
7
8
9 |  |  |  | 6
10
11 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
12
13 |  | 1 | 15 | 8
14 |  | 2 | 5 | 4
15 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
16 |  | 1 |  | 1
17 |  | 1 | 15 | 8 |  |  | 1 | 4
18 |  | 2 | 5 | 4
19 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
20 |  | 1 |  | 1
21 |  | 1 | 15 | 8 |  |  | 1 | 4
22 |  | 2 | 5 | 4
23 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
24 |  | 1 |  | 1
25 |  | 1 | 15 | 8 |  |  | 1 | 4
26 |  | 2 | 5 | 4
27 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
28 |  | 1 |  | 1
29 |  | 1 | 15 | 8 |  |  | 1 | 4
30 |  | 2 | 5 | 4
31 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
32 |  | 1 |  | 1
33 |  | 1 | 15 | 8 |  |  | 1 | 4
34 |  | 2 | 5 | 4
35 |  | 2 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 3 | 4
36 |  | 1 |  | 1
37 |  | 1 | 15 | 8 |  |  | 1 | 4
38 |  | 2 | 5 | 4
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 17799026.15000001 | -15700839.48000002
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 17799026.15000001 | -15700839.48000002
 | Purchases:
6 |  | 3rd Party / Inter Enron | -17800278.15000001 | 15708339.54000002
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | -0.2000000001862645
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | -299.86
 | Total Purchases: |  | -17800278.15000001 | 15708039.48000002
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | -17259875.15 | 17259882
12 |  | Purchases | 17259875.15 | -17259882
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 1252 | 3591.227478850633
23 | Fuel: |  | 56 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH