tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742454d1627754673-duplicate-values-across-multiple-sheets-yard-check-digital
Sheet: Tuesday

Date: | Loaded  Trailers  - Outbound & Inbound: |  |  |  |  |  |  |  |  | CONTAINERS ON PROPERTY
Trailer #: | Location |  | Carrier |  | Inbound/Outbound |  | Date |  | Notes | Empties |  |  | Loaded
Date:7-27 | Loaded  Trailers  - Outbound & Inbound: |  |  |  |  |  |  |  |  | CONTAINERS ON PROPERTY
Trailer #: | Location |  | Carrier |  | Inbound/Outbound |  | Date |  | Notes | Empties |  |  | Loaded
660499 | MECHANICAL |  | ABF |  |  | Outbound |  |  |  | 636987 HHIU |  |  | 888640 UMXU
267 | GRAVEL |  | CRESCO |  |  | Outbound |  |  |  | 294652 [NAME] |  |  | 645081 HGIU
6888 |  | GRAVEL | TRINITY |  |  | Outbound |  |  |  |  | 510077 HGIU
1613 4129 | MECHANICAL |  | TRINITY |  |  | Outbound
256 | MECHANICAL |  | CRESCO |  |  | Outbound
844241 | MECHANICAL |  | GRANE |  |  | Outbound
36873 | MECHANICAL |  | CSX |  |  | Outbound
994 | ELECTRICAL |  | CRESCO |  |  | Outbound
1421 | ELECTRICAL |  | TRINITY |  |  | Outbound
94996 | CTI |  | JB |  |  | Outbound
400598 | MECHANICAL |  | ABF |  |  | Outbound
EMPTY DROP TRAILERS ON PROPERTY      -  WRITE  TRAILER #  IN  BOXES  BELOW |  |  |  |  |  |  |  |  |  |  |  |  | Red Tagged Trailers
BOYDS |  | 54019 53123 | 53414 | 53669 |  |  |  |  |  |  |  |  | WESTERN | 430404 | [NAME]
CRESCO FLAT |  | 612 566 265 294 | 263 609 | 614 | 253 249 | 273 270 240 |  |  |  |  |  |  | SMX | 54043 | [NAME]
TRINITY |  | 4128 9646 | 259 | 238 | CRESCO | 248 281 | 268 228 |  |  |  |  |  | JB | 94997 | ISSUE
CRESCO KANG |  | 735 997 995 | 992 | 998 993 |  | FLAT | 999 501 |  | 986 |  |  |  | JB | 94581 | ROLLER
CRESCO CONEST |  | 635 638 628 | 621
GRANE/CSX/ABF |  | 666077 | 556489 | 36879
EW WYLIE |  | 501522
JB HUNT |  | 92643 | 90288 | 90295
PRIME |  | 560016
RC MOTORS |  | 240 346
CFC |  | 4814
CENTRAL TRANS |  | 1800678
MELTON |  | 32229 | 34545
WESTERN
STEVENS PIPE |  | 270
DIAMOND STATE |  | 253F 249F
Spreadsheet: 735895d1623250840-hi-i-would-like-to-use-2-or-3-isnumber-search-functions-in-1-formula-test-isnumber-1-formula
Sheet: Sheet3

Volgnummer | Periode | Weeknr | Tdatum | Opleiding | [NAME] | Omschrijving | Van | Tot | Lokatie | E_Lokatie | Soort | Aantal deelnemers | Verdeling
Spreadsheet: 267647d1380129299-pulling-data-from-a-master-list-company-wide-employee-list
Sheet: Dallas

EMP ID | Dallas Org Chart
 | Seabolt, [NAME] |  | I want a formula that will have the employee name autopopulated.
 | Shakhmeyster, [NAME] |  | The Emp Id And Position will pull once the name is populated
 |  |  | I think the names should be pulled from "Location & Job Title".
Sales
000584
000595
000594
000260
Administrative
Operation
 | [NAME], [NAME]
Drivers
 | [NAME], Erasto
Yard Employees
 | [NAME], [NAME]
[NAME]
 | [NAME], [NAME]
Spreadsheet: mark_guzman__24563__MeadMktplace
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2000-10-31 00:00:00 |  | 76.29 | 560 | 37 | 400
 | 2000-10-30 00:00:00 |  | 78.41 | 1360 | 42.22 | 360 | 70 | 130 | 25.37 | 335
 | 2000-10-29 00:00:00 |  | 70 | 800 | 42.22 | 360 | 48.85 | 639 | 35.16 | 515
 | 2000-10-28 00:00:00 |  | 73.17 | 960 | 50 | 360 | 51.27 | 205 | 32.75 | 400
 | 2000-10-27 00:00:00 |  | 75.18 | 1360 | 50 | 360 | 75.57 | 221 | 31.45 | 865
 | 2000-10-26 00:00:00 |  | 80.57 | 1680 | 33.33 | 600 | 48.18 | 118 | 25.46 | 839
 | 2000-10-25 00:00:00 |  | 80.57 | 1680 | 33.33 | 600 | 73.89 | 90 | 23.64 | 640
 | 2000-10-24 00:00:00 |  | 80.57 | 1680 | 33.33 | 600 | 78.83 | 405 | 30.82 | 425
 | 2000-10-23 00:00:00 |  | 90 | 480 | 51.67 | 600 | 59.31 | 1395 | 39.12 | 510
 | 2000-10-22 00:00:00 |  | 78 | 0 | 50 | 400 | 38.18 | 2545 | 37.01 | 1470
 | 2000-10-21 00:00:00 |  | 80 | 800 | 42.5 | 960 | 61.96 | 740 | 43.74 | 1435
 | 2000-10-20 00:00:00 |  | 88.18 | 880 | 42.5 | 960 | 83.72 | 1370 | 42.35 | 1615
 | 2000-10-19 00:00:00 |  | 96.59 | 880 | 47 | 800 | 89.96 | 1985 | 44.81 | 775
 | 2000-10-18 00:00:00 |  | 95 | 480 | 57.76 | 1160 | 97.53 | 495 | 62 | 80
 | 2000-10-17 00:00:00 |  | 93.4 | 2000 | 59.27 | 1760 | 76.11 | 2025 | 43.1 | 710
 | 2000-10-16 00:00:00 |  | 73.93 | 3056 | 62.5 | 640 | 77.05 | 500 | 56.96 | 280
 | 2000-10-15 00:00:00 |  | 68.46 | 1456 | 45.27 | 440 | 51.73 | 1248 | 47.5 | 60
 | 2000-10-14 00:00:00 |  | 67 | 480 | 47.69 | 1040 | 75 | 0 | 58.5 | 100
 | 2000-10-13 00:00:00 |  | 69.67 | 720 | 47.69 | 1040 | 79 | 200 | 60.03 | 335
 | 2000-10-12 00:00:00 |  | 80 | 480 | 51.83 | 1440 | 69.75 | 160 | 60 | 20
 | 2000-10-11 00:00:00 |  | 85 | 480 | 58.2 | 1000 | 85 | 100 | 62.45 | 220
 | 2000-10-10 00:00:00 |  | 85 | 480 | 53 | 240 | 90 | 0 | 68 | 40
 | 2000-10-09 00:00:00 |  | 105 | 480 | 55 | 240 | 75.63 | 200 | 48.94 | 995
 | 2000-10-08 00:00:00 |  | 90 | 480 | 55 | 240 | 50 | 730 | 50 | 388
 | 2000-10-07 00:00:00 |  | 106.21 | 2240 | 57 | 600 | 64.7 | 720 | 56.8 | 100
 | 2000-10-06 00:00:00 |  | 106.21 | 2240 | 57 | 600 | 80.96 | 415 | 58.2 | 300
 | 2000-10-05 00:00:00 |  | 134.5 | 8080 | 62.74 | 1240 | 78.24 | 255 | 63 | 275
 | 2000-10-04 00:00:00 |  | 134.33 | 7200 | 58 | 800 | 75.12 | 1445 | 57.5 | 0
 | 2000-10-03 00:00:00 |  | 163.88 | 6400 | 57.5 | 200 | 109.85 | 3400 | 90 | 600
 | 2000-10-02 00:00:00 |  | 145 | 6400 | 97.5 | 800 | 89.91 | 1860 | 90 | 200
 | 2000-10-01 00:00:00 |  | 137.5 | 5200 | 85 | 400 | 58.98 | 3241 | 35.05 | 1165
Spreadsheet: 224585d1364642611-dropdown-returns-results-comma-separated-data-from-another-tab-or-should-i-use-access-scheduleharribone
Sheet: Data

 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00
 | 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 | Days | Code
[NAME] | m,t,f |  | m | t | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | m
[NAME] |  | t,th,w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | t
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m,t,th |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | w
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | th
Fred |  |  |  | t |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday | st
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday | sn
[NAME]
[NAME] |  |  | t |  |  |  | t,m
[NAME]
[NAME]
[NAME]
Spreadsheet: 818765d1677040394-trouble-with-significant-figures-significant-figure-challenges
Sheet: Sheet1

Here is an example of raw data of various magnitude
Entry 1 | 1.210215
Entry 2 | 5.023654
Entry 3 | 5
Entry 4 | 10258.60105
Entry 5 | 205.32154674
Entry 6 | 1025860105
Entry 7 | 21.0052
Entry 8 | 23.2101
Entry 9 | 500.0025
Entry 10 | 2140.261
I want to round to 3 significant figures (note: originally I had a problem with excel automatically dropping trailing zeros)
 | Rounded result | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  | This should  say 5.00 but excel has dropped the trailing zeros
Entry 4
Entry 5
Entry 6
Entry 7 |  | This should  say 21.0 but excel has dropped the trailing zeros
Entry 8
Entry 9
Entry 10
To get around this, I have added some conditional formattiong (shown on the right) to asess the magnatiude of the cell and specify the decimal points
 | Rounded result
Entry 1
Entry 2 |  |  |  |  |  |  |  |  |  |  |  | Note on conditional formatting: this is only required for cells <100 because above that, the formula will perform the rounding without dropping the trailing zeros
Entry 3
Entry 4
Entry 5
Entry 6
Entry 7
Entry 8
Entry 9
Entry 10
After this, I want the ability to manually remove some points and add a note (in this case it will say "a" with a footnote somewhere else explaining this.
I also want to generate statisical data for the original results, and the results without footnotes.
 | Rounded result | Manually remove
Entry 1
Entry 2
Entry 3 |  | yes
Entry 4
Entry 5
Entry 6 |  | yes
Entry 7
Entry 8
Entry 9
Entry 10
 | Rounded result (with footnote) | I have also tried keeping the Significant Figure formula to obtain the Rounded result (with footnote) | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  |  | I want this to say "5.00 a" but if my result is less than 100, and has a 0 as the third significant figure. I am not able to get it to work
Entry 4
Entry 5
Entry 6 |  |  | This entry (magnitude above 100) has worked properly.
Entry 7 |  |  | In this case (without a footnote) excel has not dropped the trailing zero. This is what I want.
Entry 8
Entry 9
Entry 10
 | [NAME] applied to all results | [NAME] applied to results without footnotes | Notes
Average |  |  | These are working fine but it is something to keep in mind if the formula to solve the above problem changes in a way such that they don't work
St. Dev.
Spreadsheet: 115196d1310790361-min-max-values-for-first-column-relative-to-second-columns-values-beforeafter
Sheet: After

Zip code | Number | Same ZIP? | Same Number? | Duplicate |  |  | Number | Min ZIP | [NAME] |  |  | Min ZIP | [NAME] | Number
1 | 0.4354 | 0 | 0 | No |  |  |  |  |  |  |  | 1 | 4 | 0.4354
2 | 0.4354 | 0 | 1 | No |  |  |  |  |  |  |  | 4 | 4 | 0.4827
3 | 0.4354 | 0 | 1 | No |  |  |  |  |  |  |  | 5 | 7 | 0.4354
4 | 0.4354 | 0 | 1 | No |  |  |  |  |  |  |  | 7 | 7 | 0.4827
4 | 0.4827 | 1 | 0 | No |  |  |  |  |  |  |  | 8 | 16 | 0.4354
5 | 0.4354 | 0 | 0 | No |  |  |  |  |  |  |  | 16 | 16 | -0.1991
6 | 0.4354 | 0 | 1 | No |  |  |  |  |  |  |  | 17 | 18 | 0.4354
6 | 0.4354 | 1 | 1 | No |  |  |  |  |  |  |  | 18 | 18 | -0.1991
7 | 0.4354 | 0 | 1 | No
7 | 0.4827 | 1 | 0 | No
9 | 0.4354 | 0 | 0 | No
10 | 0.4354 | 0 | 1 | No
11 | 0.4354 | 0 | 1 | No
12 | 0.4354 | 0 | 1 | No
14 | 0.4354 | 0 | 1 | No
15 | 0.4354 | 0 | 1 | No
16 | 0.4354 | 0 | 1 | No
16 | -0.1991 | 1 | 0 | No
17 | 0.4354 | 0 | 0 | No
17 | 0.4354 | 1 | 1 | No
18 | 0.4354 | 0 | 1 | No
18 | -0.1991 | 1 | 0 | No
Spreadsheet: 119990d1314903748-excel-2007-inserting-rows-after-subtotals-sample-of-subtotal
Sheet: subtotals without blank row

Customer Name | [NAME] # | PO # | Line # | Part # | Description | Original Commit | [NAME] | Backlog Qty | [NAME] | Total Order QTY | Unit Price | Order Amount | Back Log $
ABC Customer | 11111 | 12314521 | 5 | 271244124 | ASSY,RIDGE RUNNER | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 30 | 0 | 30 | 216.37 | 6491.1 | 6491.1
 | 11111 Total
[NAME] | 22222 | 44436 | 5 | [PHONE] | ASSY, HOT DOGS | 2012-01-05 00:00:00 | 2012-01-05 00:00:00 | 100 | 0 | 100 | 135 | 13500 | 13500
[NAME] | 22222 | 44436 | 10 | [PHONE] | ASSY, HOT DOGS | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 75 | 0 | 75 | 135 | 10125 | 10125
[NAME] | 22222 | 44436 | 15 | [PHONE] | ASSY, HOT DOGS | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 75 | 0 | 75 | 135 | 10125 | 10125
[NAME] | 22222 | 44436 | 20 | [PHONE] | ASSY, HOT DOGS | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 75 | 0 | 75 | 135 | 10125 | 10125
[NAME] | 22222 | 44436 | 25 | [PHONE] | ASSY, HOT DOGS | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 50 | 0 | 50 | 135 | 6750 | 6750
[NAME] | 22222 | 44436 | 30 | [PHONE] | ASSY, HOT DOGS | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 50 | 0 | 50 | 135 | 6750 | 6750
[NAME] | 22222 | 44436 | 35 | [PHONE] | ASSY, HOT DOGS | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 50 | 0 | 50 | 135 | 6750 | 6750
[NAME] | 22222 | 44436 | 40 | [PHONE] | ASSY, HOT DOGS | 2012-08-01 00:00:00 | 2012-08-01 00:00:00 | 25 | 0 | 25 | 135 | 3375 | 3375
 | 22222 Total
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 3090

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight One day
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
 | Intersight
Spreadsheet: 47e4f96d-1ac9-4955-819a-8aded3d32fdd
Sheet: Sheet1

Follow-up Survey - College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Fall 2012 | Sp. 2013 | Fall 2013 | Sp. 2014
[NAME] | Ave. score | Ave. score | Ave. score | Ave. score
PLANNING
Plan objectives and select supporting activities. | 4.4 | 4.4 | 4.5 | 4.2
Plan for individual differences, including cultural diversity and children with exceptionalities. | 4.3 | 4.6 | 4.5 | 4.4
Plan for short-term and long-term evaluation of student teaching (daily, weekly, yearly). | 4.4 | 4.4 | 4.4 | 4.5
Understand developmental characteristics of students a guide for planning. | 4.5 | 4.5 | 4.6 | 4.1
MANAGEMENT
Organize and maintain an effective classroom environment (space, materials, equipment, learning climate). | 4.4 | 4.2 | 4.4 | 4.2
Management of student behavior for effective learning. | 4.2 | 4.4 | 4.3 | 4.4
INSTRUCTION
Understand and convey knowledge of subject matter. | 4.4 | 4.5 | 4.5 | 4.2
Employ a variety of teaching strategies. | 4.3 | 4.3 | 4.2 | 4.1
Provide opportunities for student involvement in learning. | 4.4 | 4.5 | 4.6 | 4.2
Stimulate high-order thinking. | 4.5 | 4.4 | 4.7 | 4.3
Use materials, resources, and activities that are developmentally appropriate. | 4.4 | 4.5 | 4.3 | 4.4
Use technology to enhance learning. | 4.3 | 4.6 | 4.2 | 4.2
Provide effective on-going assessment, including performance-based assessment. | 4.2 | 4.2 | 4.2 | 4.5
TEACHER EDUCATION TRAINING
Rate the extent to which field experiences contributed to your teacher education training. | 4.4 | 4.3 | 4.3 | 4.2
Rate the extent to which student teaching contributed to your teacher education training. | 4.5 | 4.4 | 4.5 | 4.5
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Sewell

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 312dbce8-6185-4f34-b2c0-3c9da93095df
Sheet: Sheet1

GOVERNOR - DEMOCRATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Summary By Counties | Shaheen, d | Beaulieu,r | Bramante,r | Kroepel,r | Lucas,r | Rubens,r | [NAME]
Belknap County | 938 | 8 | 22 | 1 | 25 | 25 | 11
Carroll County | 952 | 0 | 2 | 0 | 6 | 3 | 2
Cheshire County | 1957 | 2 | 197 | 1 | 13 | 19 | 12
Coos County | 927 | 9 | 9 | 0 | 7 | 7 | 9
Grafton County | 2108 | 6 | 28 | 1 | 18 | 35 | 26
Hillsborough County | 9394 | 194 | 168 | 2 | 129 | 91 | 60
Merrimack County | 3395 | 14 | 161 | 0 | 23 | 22 | 67
Rockingham County | 5030 | 15 | 82 | 0 | 52 | 36 | 33
Strafford County | 2658 | 6 | 94 | 0 | 25 | 9 | 20
Sullivan County | 1269 | 1 | 33 | 0 | 30 | 20 | 12
Totals | 28628 | 255 | 796 | 5 | 328 | 267 | 252
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -1147634
3531 | -585831 | -203940
60667 | -191052 | -1758118
60749 | 40544 | 84117
61206
61334 | -11462
62960
INDEX
2002-02-28 00:00:00 |  |  | -209484.09
2002-03-18 00:00:00
CBS Volume
 |  |  | 90
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: September2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.24
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
304 | Customer B | 500044 | Insulight(TM) | 1 | 0.98 | 23.11 | 23.58 | 4.51 | 5.934210526315789 | 0 | 5.934210526315789 | 2.352
304 | Customer B | 500045 | Insulight(TM) | 3 | 0.97 | 26.68 | 27.51 | 9.7 | 12.76315789473684 | 0 | 12.76315789473684 | 2.328
304 | Customer B | 500144 | Insulight(TM) Protect | 5 | 5.41 | 177.57 | 32.82 | 21.79 | 28.67105263157895 | 0 | 28.67105263157895 | 12.984
304 | Customer B | 512084 | energiKare(TM) | 34 | 14.76 | 461.92 | 31.3 | 100.35 | 132.0394736842105 | 0 | 132.0394736842105 | 35.424
304 | Customer B | 512484 | energiKare(TM) | 57 | 39.83 | 1779.33 | 44.67 | 288.41 | 379.4868421052632 | 0 | 379.4868421052632 | 95.592
304 | Customer B | 530049 | Insulight(TM) [NAME] | 10 | 3.62 | 106.31 | 29.37 | 32.73 | 43.06578947368421 | 0 | 43.06578947368421 | 8.688
304 | Customer B | 530149 | Insulight(TM) [NAME] | 4 | 2.83 | 114.39 | 40.42 | 26.65 | 35.06578947368421 | 0 | 35.06578947368421 | 6.792
304 | Customer B | 530169 | Insulight(TM) Therm | 1 | 3.11 | 213.22 | 68.56 | 27.56 | 36.26315789473684 | 0 | 36.26315789473684 | 7.464
304 | Customer B | 99999999 | Energy Surcharge | 0 | 0 | 331.11 | 0 | 0 | 0 | 0 | 0 | 0
1054 | Customer A | 512147 | energiKare(TM) | 0 | 0 | -158.38 | 0 | 0 | 0 | 0 | 0 | 0
1054 | Customer A | 99999999 | Energy Surcharge | 0 | 0 | -14.28 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 200272d1355482466-adding-1-darts-2013new
Sheet: A_results

TEAM | PLAYED | WON | LOST | LEGS FOR | LEGS AGAINST | [NAME] | BONUS POINTS | TOTAL POINTS
Delfin | 5 | 4 | 1 | 28 | 17 | 2 | 8 | 36
Queimada | 5 | 4 | 1 | 36 | 9 | 4 | 8 | 44
Aloha A | 4 | 0 | 4 | 5 | 31 | 1 | 0 | 5 |  |  | A DIV
Scandals | 4 | 2 | 2 | 20 | 16 | 2 | 4 | 24
Aloha B | 4 | 0 | 4 | 8 | 28 | 1 | 0 | 8
Village | 4 | 1 | 3 | 15 | 21 | 2 | 2 | 17
Casino | 5 | 3 | 2 | 25 | 20 | 4 | 6 | 31
Anchor | 4 | 1 | 3 | 10 | 26 | 1 | 2 | 12
Bar 2 B | 5 | 5 | 0 | 33 | 12 | 3 | 10 | 43
 | Aloha A | Aloha A  mixed | Aloha B | Aloha B  mixed | Anchor | Anchor mixed | Bar 2 B | Bar 2 B mixed | Casino | Casino mixed | Delfin | Delfin mixed | Queimada | Queimada mixed | Scandals | Scandals mixed | Village | Village mixed
2012-11-13 00:00:00 | 0 | 1 | 2 | 0 | BYE | BYE | 6 | 0 | 7 | 1 | 9 | 0 | 8 | 1 | 3 | 1 | 1 | 0
2012-11-20 00:00:00 | 1 | 0 | BYE | BYE | 0 | 0 | 8 | 1 | 1 | 0 | 6 | 1 | 9 | 1 | 3 | 0 | 8 | 1
2012-11-27 00:00:00 | 4 | 0 | 4 | 1 | 5 | 1 | 5 | 0 | 6 | 1 | 5 | 0 | 4 | 1 | BYE | BYE | 3 | 0
2012-12-04 00:00:00 | 0 | 0 | 1 | 0 | 2 | 0 | 8 | 1 | 7 | 1 | 2 | 1 | 7 | 0 | 9 | 1 | BYE | BYE
2012-12-11 00:00:00 | BYE | BYE | 1 | 0 | 3 | 0 | 6 | 1 | 4 | 1 | 6 | 0 | 8 | 1 | 5 | 0 | 3 | 1
2012-12-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BYE | BYE | 0 | 0 | 0 | 0 | 0 | 0
2013-01-08 00:00:00
2013-01-15 00:00:00
2013-01-22 00:00:00
2013-01-29 00:00:00
2013-02-05 00:00:00
2013-02-12 00:00:00
2013-02-19 00:00:00
2013-02-26 00:00:00
2013-03-05 00:00:00
2013-03-12 00:00:00
2013-03-19 00:00:00
2013-03-26 00:00:00
 | 5 | 1 | 8 | 1 | 10 | 1 | 33 | 3 | 25 | 4 | 28 | 2 | 36 | 4 | 20 | 2 | 15 | 2
Spreadsheet: tracy_geaccone__40256__C0366-112458
Sheet: Dept_100192

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CAFETERIA - Dept. 100192
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-05-29 00:00:00 | CFT2001/05-0366/112458 |  | Work Place | Work Place Count | 1 | 14.08 | /MNTH | 14.08
 |  |  |  |  |  |  | Ticket Total |  | 14.08
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 14.08
 |  |  |  |  |  |  | Total for Dept_100192 |  | 14.08
Spreadsheet: 885582d1735313927-content-aware-dropdown-choice-accounts-follow-up-list-2025-v2-frm
Sheet: Service Tab

MD
LS
SS
FH
NJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  | PO
 |  |  |  |  |  |  |  |  |  |  |  | PCard |  |  | YES
 |  |  |  | ARFFS |  | ONE OFF |  |  |  |  |  | ONE OFF
 |  |  |  | ASOU |  | SPLIT |  |  |  |  |  | SPLIT
 |  |  |  | CAPEX
 |  |  |  | COO
 |  |  |  | ENVI
 |  |  |  | H&S
 |  |  |  | [NAME] |  |  |  |  |  |  |  | -
Spreadsheet: mike_carson__27594__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 17.8 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 18.05 |  | 1
 | Comed | -100 | 18.5 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 13.5 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  | Prepay Wire AMT |  | -27880 | <<< Payed due to MLK holiday on 1/18/02
 |  |  |  |  |  | Net AMT
Spreadsheet: 686811d1594821330-calculate-overlapping-leave-for-different-categories-test-formula
Sheet: Sheet1

 |  |  |  |  |  | LEAVE CATEGORY |  | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-18 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-25 00:00:00 | 2020-07-26 00:00:00 | 2020-07-27 00:00:00 | 2020-07-28 00:00:00 | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-08 00:00:00 | 2020-08-09 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00
 |  |  | Expected output on 1 July as example |  |  | TEACHER
 |  |  |  |  |  | STUDENT
 |  |  |  |  |  | PAINTER
STAFF NO | NAME | START DATE | END DATE | CATEGORY
1 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-07-20 00:00:00 | TEACHER |  |  |  | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
2 | Mr. [NAME] | 2020-07-04 00:00:00 | 2020-07-10 00:00:00 | TEACHER |  |  |  |  |  |  | L | L | L | L | L | L | L
3 | Mr. [NAME] | 2020-08-01 00:00:00 | 2020-08-10 00:00:00 | STUDENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | L | L | L | L | L | L | L | L | L
4 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-08-04 00:00:00 | PAINTER |  |  |  | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
5 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-07-05 00:00:00 | TEACHER |  |  |  | L | L | L | L | L