tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: CM

 | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing
 |  |  |  |  |  |  |  | Total
 | Car Maintenance |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Subcategory | Amount
 |  |  |  |  | 50
Spreadsheet: 232492d1367433360-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis-solution
Sheet: cold-roll

Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb) | Price per 100 weight (lbs) (cwt) | nominal wieght (esitimated pounds ordered)/amount purchased | amount shipped (lbs) | date paid | date invoiced | total estimated price | invoice amount | total price paid or cost | Invoice # | actual cost per sheet | cost per sqft | number of sheets on hand | lbs on hand | total area onhand (ftsq) | dollar amount on hand | total cost/lb on hand actual | cost/sqft on hand | Vendor
Cold-Roll | 26 | 8 | 4 | 0.75
Cold-Roll | 26 | 10 | 4 | 0.75
Cold-Roll | 24 | 8 | 4 | 1
Cold-Roll | 24 | 10 | 4 | 1
Cold-Roll | 22 | 8 | 4 | 1.25
Cold-Roll | 22 | 10 | 4 | 1.25
Cold-Roll | 20 | 8 | 4 | 1.5
Cold-Roll | 20 | 10 | 4 | 1.5
Cold-Roll | 18 | 8 | 4 | 2
Cold-Roll | 18 | 10 | 4 | 2
Cold-Roll | 16 | 8 | 4 | 2.5
Cold-Roll | 16 | 10 | 4 | 2.5
Cold-Roll | 14 | 8 | 4 | 3.125
Cold-Roll | 14 | 10 | 4 | 3.125
Cold-Roll | 12 | 8 | 4 | 4.375
Cold-Roll | 12 | 10 | 4 | 4.375
Spreadsheet: john_griffith__15878__11_12_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 58 | 400 | 500 | 42.7 | 53.4 | 1.75 | 2001-11-12 13:20:00
 | HU F2 | 59 | 725 | 825 | 44.6 | 50.7 | 1.77 | 2001-11-12 13:20:00
 | HU G2 | 60 | 1000 | 1100 | 45.9 | 50.5 | 1.82 | 2001-11-12 13:20:00
 | [NAME] | 61 | 1150 | 1275 | 44.7 | 49.5 | 1.81 | 2001-11-12 13:20:00
 | [NAME] | 68 | 1375 | 1500 | 42.7 | 46.6 | 1.91 | 2001-11-12 13:20:00
 | [NAME] | 68 | 1475 | 1600 | 41.4 | 45 | 1.85 | 2001-11-12 13:20:00
 | [NAME] | 68 | 1550 | 1700 | 39.9 | 43.8 | 1.79 | 2001-11-12 13:20:00
 | HU N2 | 68 | 1575 | 1725 | 38.1 | 41.7 | 1.71 | 2001-11-12 13:20:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 230868d1366895570-conditional-formatting-cell-colour-all-cells-not-just-one-2010-sample-workbook-g17-issue
Sheet:  Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 years
 | YEARS |  |  | 4 years
 |  | Please complete | Please complete | Please complete | Please Complete | [NAME]
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 835271d1688469824-creating-a-variable-location-and-shipping-kg-formula-example-postage
Sheet: Sheet1

 | Parcel Post | .25-.5[NAME] | .5-1kg | 1-1.5kg | 1.5-2kg | 2kg + 0.5kg extra to 20kg | 2kg + 1kg extra up to 20kg | Discount on standard +0.5kg prices
 | Mypost business band 5 Shipping cost perkg - NZ | 12.03 | 16.15 | 20.28 | 24.41 | 2.82 | 5.64 | 0.35
 | Mypost business band 5 Shipping cost perkg - UK/IRE | 24.99 | 35.07 | 45.14 | 55.22 | 6.27 | 12.54 | 0.225
 | Mypost business band 5 Shipping cost perkg - US/CAN | 21.12 | 30.81 | 40.53 | 50.26 | 5.65 | 11.3 | 0.225
 | Mypost business band 5 Shipping cost perkg - EU | 26.61 | 37.33 | 48.06 | 58.78 | 6.27 | 12.54 | 0.175
 | Mypost business band 5 Shipping cost perkg - Rest of world | 27.41 | 38.46 | 49.51 | 60.56 | 9.22 | 18.44 | 0.15
 | Aus Parcel Post | .5[NAME] | 1kg | 3kg | 5kg | savings on standard prices over 5kg
 | Zone 1 | 6.36 | 8.7 | 10.95 | 13.17 | 0.175
 | Zone 2 | 8.48 | 11.6 | 13.78 | 17.56 | 0.175
 | Zone 3 | 10.07 | 14.6 | 17.34 | 20.85 | 0.175
Spreadsheet: 691118d1597488748-formular-to-take-data-from-another-sheet-both-sex
Sheet: Sheet1

 |  | NAMBA | JINA LA MWANAFUNZI | SEX | 01 - KISWAHILI | 02 - ENGLISH | 03 - MAARIFA | 04 - HISABATI | 05 - SAYANSI | JUMLA | DARAJA | NAFASI | SHULE ATOKAYO
 |  | 1 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 2 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 3 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 4 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 5 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 6 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 7 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 8 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 9 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 10 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 11 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 12 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 13 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 14 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  | 15 |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
 |  |  |  |  |  |  |  |  |  |  |  |  | KIBAYA
Spreadsheet: 78527d1278933138-classify-data-values-range_belonging-2-
Sheet: Foglio1

Year | value | Range belonging |  | range |  | range ID |  | Average
1420 | 5 | 1 | 1 | 1400 | 1500 | 1 |  | 4.4
1460 | 9 | 1 | 1 | 1500 | 1600 | 2 |  | 4.166666666666667
1500 | 4 | 1 and 2 | 2 | 1600 | 1700 | 3 |  | 5
1500 | 3 | 1 and 2 | 2
1500 | 1 | 1 and 2 | 2
1580 | 7 | 2 | 2
1600 | 2 | 2 and 3 | 3
1600 | 8 | 2 and 3 | 3
Spreadsheet: 467792d1466937751-need-an-if-formula-but-not-sure-where-it-goes-of-sample-1
Sheet: Sheet1

Day | Weather | Sales A | Sales B
 | 1 | 200 | 453 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Monday
 | 2 | 60 | 234 |  | if WeatherColumn(B2:b29)= 3, then I need all mondays(a5,a12,a26) Sales A (c5,c12,c26) Averages which = |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Tuesday
 | 2 | 400 | 123 |  | Day | Weather | Sales A Average |  |  |  |  |  |  |  |  |  |  |  | 3 | Wednesday
 | 3 | 654 | 234 |  | Tuesday | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday
 | 2 | 342 | 345 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 | 1 | 45 | 234 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
 | 1 | 456 | 124 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday
 | 2 | 654 | 324
 | 3 | 345 | 321
 | 2 | 453 | 423
 | 3 | 234 | 234
 | 1 | 234 | 423
 | 1 | 456 | 234 |  | Thanks
 | 2 | 321 | 453
 | 3 | 235 | 764 |  | if WeatherColumn(B2:b29)= 3, then I need all tuesdays(a6,a20) Sales A (c6,c20) Averages which =
 | 2 | 345 | 234
 | 1 | 654 | 224 |  | Day | Weather | Sales A Average
 | 2 | 123 | 334 |  | Friday | 1
 | 2 | 234 | 444
 | 3 | 345 | 213
 | 4 | 432 | 132
 | 5 | 321 | 80
 | 5 | 234 | 653
 | 4 | 345 | 666
 | 3 | 543 | 654
 | 3 | 234 | 345
 | 2 | 234 | 654
 | 1 | 231 | 453
Spreadsheet: 118478d1313710925-extracting-hour-from-m-d-y-hh-mm-date_test
Sheet: Sheet1

Date/Time | Hour | Speed 60 m A [m/s] | Speed 60 m B [m/s] | Speed 50 m [m/s] | Direction A [ｰ] | Direction B [ｰ]
2007-08-15 00:00:00 |  | 2.217 | 2.433 | 2.433 | 163.64 | 176.95
2007-08-15 01:00:00 |  | 1.617 | 1.833 | 1.65 | 84.72 | 79.38
2007-08-15 02:00:00 |  | 2.117 | 2.317 | 2.133 | 96.75 | 93.13
2007-08-15 03:00:00 |  | 3.483 | 3.667 | 3.283 | 120.72 | 118.76
2007-08-15 04:00:00 |  | 3.733 | 3.917 | 3.633 | 119.31 | 113.59
2007-08-15 05:00:00 |  | 4.35 | 4.517 | 4.317 | 117.46 | 113.68
2007-08-15 06:00:00 |  | 2.733 | 2.933 | 2.767 | 114.75 | 111.44
2007-08-15 07:00:00 |  | 3.1 | 3.3 | 3.25 | 109.26 | 107.73
2007-08-15 08:00:00 |  | 2.333 | 2.583 | 2.283 | 128.75 | 119.88
2007-08-15 09:00:00 |  | 1.667 | 1.917 | 1.817 | 110.13 | 111.7
2007-08-15 10:00:00 |  | 3.25 | 3.433 | 3.333 | 115.26 | 111.91
2007-08-15 11:00:00 |  | 3.383 | 3.583 | 3.333 | 120.45 | 116.74
2007-08-15 12:00:00 |  | 4.767 | 4.95 | 4.817 | 179.62 | 171.69
2007-08-15 13:00:00 |  | 4.667 | 4.917 | 4.517 | 137.09 | 135.17
2007-08-15 14:00:00 |  | 4.85 | 5.233 | 4.733 | 154.55 | 151.63
2007-08-15 15:00:00 |  | 3.417 | 3.7 | 3.433 | 162.1 | 152.75
2007-08-15 16:00:00 |  | 3.117 | 3.267 | 3.2 | 184.76 | 186.83
2007-08-15 17:00:00 |  | 7.017 | 6.95 | 6.95 | 217.78 | 222.37
2007-08-15 18:00:00 |  | 5.383 | 5.417 | 5.4 | 256.12 | 259.41
2007-08-15 19:00:00 |  | 6.267 | 6.283 | 6.25 | 245.2 | 248.4
2007-08-15 20:00:00 |  | 12.4 | 12.333 | 12.233 | 257.64 | 260.78
2007-08-15 21:00:00 |  | 11.867 | 11.817 | 11.8 | 256.67 | 259.62
Spreadsheet: 0a6d6846-2007-4a76-ac65-68928ef5e06e
Sheet: Summary Report

Course Number / Title | OTI Education Center Name | Training Location City | Training Location State | (Foreign) Country | Start Date | End Date | Total Students | Contact Hours | Course Chairperson | Instructional Staff | Number of Students Attempting Exam | Number of Students Taking Re-Test | Number of Students Passing Exam | Percent of Students Passing Exam | Average Test Score (mean) | Federal OSHA Personnel | Other Federal Agency Personnel | State OSHA Personnel | Other State Personnel | Private Sector Personnel | U.S. Students | Foreign Students | Summary Comments
 | OMB Control Number:  1218-0262                                   Expiration Date:  xx/xx/xxxx |  |  |  |  |  | Paperwork Reduction Act Statement  According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless such collection displays a valid OMB control number.  Public reporting burden for this collection of information is estimated to average 2 hours per response, including time for reviewing instructions, searching for existing data sources, gathering and maintaining the data need, and completing and reviewing the collection of information. The obligation to respond to this collection is required for OTI Education centers to maintain OSHA's approval. The information is used to track performance measures and targets. OSHA provides no assurance of confidentiality on data collected on the Course Summary Report. Send comments regarding the burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to the U.S. Department of Labor, Occupational Safety and Health Administration, Directorate of Standards and Guidance, 200 Constitution Avenue, NW, Room N3718, Washington, DC 20210 and reference the OMB Control Number. Note: Please do not return the completed OSHA Form to this address. |  |  |  |  |  |  |  |  |  |  |  |  |  | OMB Form 4-50.8 (March 2010)
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Nour Al solh

 |  |  | Achieved | Target
 |  | Total Revenue |  | 27000
 |  | Consumables | 0
 |  | In / direct Cost
 |  | Net
 |  | Dr. Percentage 5 %
Salary | AL | AT | [NAME] | Ins. | EOS prov. | Gosi
9000 |  |  |  | 0
 |  |  |  | Doctor [NAME] ……………
Spreadsheet: 729194d1618951353-re-arrange-table-data-example
Sheet: Sheet1

TABLE 1
CAREER RUNS | RUN | WINS | S/R% | TOTAL RUNNERS | RB | %RB² | RUNS =<2/1 | WINS =<2/1 | S/R% =< 2/1 | EXP WINS | WIV | WAX | TOTAL WIN SP | SP LSP | A/E
5 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
7 | 1 | 0 | 0 | 100 | 49 | 49 | 1 | 0 | 0 | 0.3333333333333333 | 0 | -0.3333333333333333 | 0 | -1 | 0
11 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
1 | 11 | 5 | 45.45454545454545 | 15376 | 10609 | 68.9971383975026 | 8 | 4 | 50 | 4.008658661517956 | 1.247300012844359 | 0.9913413384820435 | 21.08 | 10.08 | 1.247300012844359
2 | 6 | 2 | 33.33333333333333 | 3136 | 2025 | 64.57270408163265 | 2 | 1 | 50 | 1.750754147812971 | 1.142364850312298 | 0.2492458521870289 | 5.35 | -0.6500000000000004 | 1.142364850312298
12 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
4 | 1 | 0 | 0 | 100 | 64 | 64 | 1 | 0 | 0 | 0.6666666666666666 | 0 | -0.6666666666666666 | 0 | -1 | 0
3 | 2 | 1 | 50 | 324 | 289 | 89.19753086419753 | 1 | 1 | 100 | 0.6701680672268908 | 1.492163009404389 | 0.3298319327731092 | 2.38 | 0.3799999999999999 | 1.492163009404389
6 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
9 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
10 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
13 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
8 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
17 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
15 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
14 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
18 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
16 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 | 0
TABLE 2
CAREER RUNS | RUN | WINS | S/R% | TOTAL RUNNERS | RB | %RB² | RUNS =<2/1 | WINS =<2/1 | S/R% =< 2/1 | EXP WINS | WIV | WAX | TOTAL WIN SP | SP LSP | A/E
1 | 11 | 5 | 45.45454545454545 | 15376 | 10609 | 68.9971383975026 | 8 | 4 | 50 | 4.008658661517956 | 1.247300012844359 | 0.9913413384820435 | 21.08 | 10.08 | 1.247300012844359
2 | 6 | 2 | 33.33333333333333 | 3136 | 2025 | 64.57270408163265 | 2 | 1 | 50 | 1.750754147812971 | 1.142364850312298 | 0.2492458521870289 | 5.35 | -0.6500000000000004 | 1.142364850312298
3 | 2 | 1 | 50 | 324 | 289 | 89.19753086419753 | 1 | 1 | 100 | 0.6701680672268908 | 1.492163009404389 | 0.3298319327731092 | 2.38 | 0.3799999999999999 | 1.492163009404389
4 | 1 | 0 | 0 | 100 | 64 | 64 | 1 | 0 | 0 | 0.6666666666666666 | 0 | -0.6666666666666666 | 0 | -1 | 0
7 | 1 | 0 | 0 | 100 | 49 | 49 | 1 | 0 | 0 | 0.3333333333333333 | 0 | -0.3333333333333333 | 0 | -1 | 0
Spreadsheet: 762494d1641577433-dynamic-sort-function-for-data-entries-eh-ss-db_v3
Sheet: Lists

1 | 1 | 2 | 5 | 3 | 2 | 1
Employee | Task | SRM Lead | Month | Client list | Client list | Project |  |  | Clients (input names here) |  |  |  | High | On hold |  |  | [NAME] |  | Sheets
[NAME] | Client Call | [NAME] | January |  | High | Not started |  |  | 1 Client |  |  |  | Medium | In progress |  |  | Client Project |  | Team Samuel
[NAME] | Client Project | Kat | February | 10 Client | Medium | On hold |  |  | 2 Client |  |  |  | Low | Completed |  |  | Client Call |  | Team Kat
[NAME] | [NAME] | Martan | March | 11 Client | Low | In progress |  |  | 3 Client |  |  |  | N/A |  |  |  | Training |  | Team Smeg
[NAME] | Holiday | [NAME] | April | 2 Client | N/A | Completed |  |  | 4 Client |  |  |  |  |  |  |  | Holiday |  | Team [NAME]
[NAME] | Off The Job | [NAME] | May | 3 Client |  |  |  |  | 5 Client |  |  |  |  |  |  |  | Off The Job
[NAME] | Training |  | June | 4 Client |  |  |  |  | 6 Client
[NAME] | N/A |  | July | 5 Client |  |  |  |  | 7 Client
[NAME] |  |  | August | 6 Client |  |  |  |  | 8 Client
[NAME] |  |  | September | 7 Client |  | INDEX(List_Month,D1,1) |  |  | 9 Client
[NAME] |  |  | October | 8 Client |  |  |  |  | 10 Client
[NAME] |  |  | November | 9 Client |  |  |  |  | 11 Client
[NAME] |  |  | December | ABC |  |  |  |  | ABC
[NAME] |  |  |  | 0 |  |  |  |  |  |  |  | CHANGE 1 IN C1 OR C2 TO NAME? BECAUSE IT SHOWS 1, 2,3 AND 4 ON Lists
[NAME] |  |  |  |  |  |  |  |  |  |  |  | fix month not showing 12 months only stuck at 4?
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Need to add in TMOTM (team member N = nomination. W= winner)
Cristhian [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ernest Talia
[NAME]
[NAME]
Genevieve   Knapp
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Julia  Hegwood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Krisaundra Hightower
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Micah Chokeir
Micah Talia
Michelle  Greenwell
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Saif Perrine
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tiffany M Blake
[NAME]
[NAME]
[NAME]
Yvette Hurtado
Spreadsheet: darron_c_giron__8007__AGAVE
Sheet: Aug 99

 |  |  |  | 1999-08-01 00:00:00
 |  | Note: Insert the #'s in red to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 21.279 | 2.46 | 2.62 | 2.26 | 2.45
 |  |  |  | Spot price |  | Index Price
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 |  | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# |  | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 |  | E11400 | 2,500/day | 813367 | 1/92-12/2003
CPR# |  | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 |  | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# |  | TAGG # | Southern | Facility | Term | Calculated Price
105390 |  | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# |  | TAGG # | Agave/Yates | Facility | Term | Calculated Price | Differential
354827 | 56562 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 42142d1240699038-if-cell-x-0-then-copy-range-of-cells-book1-1a
Sheet: Sheet2

 |  | order form
 | products
Key | Ref | Qty | Description | Price | Order | Total
1 | 0 | 2.5 | wheat | 25 | 0 | 0
2 | 0 | 7.5 | flour | 63.92 | 0 | 0
3 | 0 | 10 | nuts | 64.16 | 0 | 0
4 | 0 | 25 | raisins | 127.9 | 0 | 0
5 | 0 | 25 | chocolate | 141.75 | 0 | 0
6
7
8
9
 |  |  |  |  | total | 0
Spreadsheet: eric_saibi__9917__102601R
Sheet: Rockport 02

Owner Name |  | American Electric Power
Station Name |  | Rockport Power Station
Unit Name |  | Rockport 02
NERC Region |  | ECAR
State |  | IN
Fuel Type |  | Coal
Capacity |  | 1300 MW
Start Date |  | 2001-10-24 00:00:00
End Date |  | 2001-10-26 00:00:00
Prv. Start Date |  | 2001-10-24 00:00:00
Prv. End Date |  | 2001-10-28 00:00:00
Comments |  | Tripped/ tube leak. Unit came back online early this morning
SIC |  | 4911
Plant ID |  | 1010400
Unit ID |  | 1004663
Outage ID |  | 18722
Spreadsheet: 265475d1379282683-trouble-pasting-data-in-excel-in-a-workable-format-mrvp-map-pasted-data-to-simpler-target-example-layout
Sheet: What I get when I paste

2013-06-09 02:30:00 | Denver - Baltimore |  |  |  | 0-7 | 14-10 | 21-0 | 14-10 | 49-27 |  | [NAME] as Text and Paste Special>Text
2013-08-09 19:00:00 | Buffalo - New England |  |  |  | 0-10 | 14-7 | 7-0 | 0-6 | 21-23 |  | Otherwise Excel tries to interpret some of them as dates
2013-08-09 19:00:00 | Jacksonville - Kansas City |  |  |  | 2-14 | 0-7 | 0-0 | 0-7 | 2-28
2013-08-09 19:00:00 | Pittsburgh - Tennessee |  |  |  | 2-0 | 0-7 | 0-3 | 7-6 | 9-16
2013-08-09 19:00:00 | Indianapolis - Oakland |  |  |  | 7-0 | 7-7 | 0-3 | 7-7 | 21-17
2013-08-09 19:00:00 | Cleveland - Miami |  |  |  | 0-3 | 7-3 | 3-7 | 0-10 | 10-23
2013-08-09 19:00:00 | Carolina - Seattle |  |  |  | 0-0 | 7-3 | 0-3 | 0-6 | 7-12
2013-08-09 19:00:00 | New Orleans - Atlanta |  |  |  | 0-10 | 13-0 | 7-7 | 3-0 | 23-17
2013-08-09 19:00:00 | NY Jets - Tampa Bay |  |  |  | 2-7 | 10-7 | 0-0 | 6-3 | 18-17
2013-08-09 19:00:00 | Detroit - Minnesota |  |  |  | 3-7 | 10-7 | 14-10 | 7-0 | 34-24
2013-08-09 19:00:00 | Chicago - Cincinnati |  |  |  | 7-7 | 3-7 | 7-7 | 7-0 | 24-21
2013-08-09 22:25:00 | San Francisco - Green Bay |  |  |  | 7-7 | 7-7 | 7-7 | 13-7 | 34-28
2013-08-09 22:25:00 | St. Louis - Arizona |  |  |  | 0-0 | 10-10 | 3-14 | 14-0 | 27-24
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: Staff & BI Scores 2009

2008 Absence (Periods and Days)
 |  | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 |  | J | F | M | A | M | J | J | A | S | O | N | D |  | Total
A.N.Other |  | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |  | 0 | 18 | 3 | 0 | 0 | 10 | 16 | 0 | 0 | 0 | 0 | 0 |  | 6 | 47 | 1692
Spreadsheet: 874886d1721396973-tracking-and-logging-the-number-of-specific-working-days-absent-within-a-date-range-dummy-sickpay-4-days-ans2
Sheet: Sheet1

 |  |  |  |  | Startdate | Year service
 |  |  |  |  | 2023-09-05 00:00:00
Name: | Employee |  |  | [NAME] entitlement
Number of working hours | 27.25
Normal Working days | 4
Shift pattern/Days staff member works | Monday/Tuesday/Thursday/Friday | YYNYYNN |  |  |  |  | Number of weeks Full Pay | Number of weeks half Pay
End Date of last sickness |  | 2024-02-05 00:00:00 |  |  |  | Less Than 6 months service | SSP | SSP | 0
No of Sick Days in  12 month Period |  |  |  |  |  | Less than 1 year servcie | 1 | 1 | 0.5
Number of sick [NAME] |  |  |  | Total Days Entitelment |  | One to two years' service: | 2 | 2 | 1
 |  |  |  |  |  | Two to three years’ service: | 4 | 4 | 2
 |  |  |  |  |  | Three years service and above | 6 | 6 | 3
First Day of Absence | Last Day of Absence | Number of Days off | Reason for Absence | Days of Week off
2023-09-20 00:00:00 | 2023-09-21 00:00:00
2023-10-09 00:00:00 | 2023-10-22 00:00:00 | 8
2023-11-27 00:00:00 | 2023-11-27 00:00:00 | 1
2023-11-28 00:00:00 | 2023-11-29 00:00:00 | 1
2024-01-18 00:00:00 | 2024-01-18 00:00:00 | 1 |  |  |  | Days Entitlement used
2024-01-22 00:00:00 | 2024-02-05 00:00:00 | 9