tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64594d1265395843-get-average-formula-sample
Sheet: Sheet1

February | 0
 | Hub Index/Bal. Mo. >> |  | 5.255 | 5.295 | 5.475 | 5.51 | 5.4651 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052 | 5.6052
 |  | Strike | 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 | Total Volume | PnL
 |  |  | vol
 |  | 5.274 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 |  |  |  | 560000 | 164953.9999999983
 |  | 5.29 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 |  |  |  | 280000 | 77996.99999999913
 |  | 5.345 | 0 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 | -5000 |  |  |  | -135000 | -31748.49999999972
Spreadsheet: 50077d1249477158-pull-data-from-one-sheet-to-pop-another-need-new-eyes-please-last-reply-for-info-footballbetting
Sheet: Sheet3

Week #1 Games
Betting Team | Vs or At | Opposing Team | Bet Line | Spread | Score | Result | Amount Rsk | Amount Won/Loss
at the bottom of all listed games put this for each week
TOTAL |  |  |  |  |  |  | XXXX | XXXX
Week #2 Games
Betting Team | Vs or At | Opposing Team | Bet Line | Spread | Score | Result | Amount Rsk | Amount Won/Loss
Spreadsheet: 288976d1389363005-how-do-i-create-a-summary-sheet-looking-up-multipule-values-how-do-i-create-a-summary-sheet-looking-up-multipule-values-summary
Sheet: New summary sheet

 | Sum of Device Code |  |  |  |  |  |  | Sum of Device Code
 | Business | Floor | Device Code | Asset number | Total |  |  | Business | Floor | Device Code | Asset number | Total
 | ARC | 1 | 520 | 1117466 | 520 |  |  | KNL | 1 | 760 | Not Recorded | 760
 |  |  |  | 1120174 | 520 |  |  |  |  | T610 | Not Recorded | 0
 |  |  | 755 | 1128696 | 755 |  |  |  |  | V30 | 1125291 | 0
 |  |  |  | 1128715 | 755 |  |  |  |  | V30LE | 1139511 | 0
 |  |  |  | 1132038 | 755 |  |  |  |  |  | 1151691 | 0
 |  |  | 790 | 1137801 | 790 |  |  |  |  |  | 1151852 | 0
 |  |  |  | 1138652 | 790 |  |  |  | 2 | 270 | 1139578 | 270
 |  |  | 780-NHS | 1133188 | 0 |  |  |  |  | 755 | 1133233 | 755
 |  |  | t643 | 1127053 | 0 |  |  |  |  | V30 | 1117513 | 0
 |  |  | V30 | 1122738 | 0 |  |  |  |  |  | 1118660 | 0
 |  |  | V30L | 1134276 | 0 |  |  |  |  |  | 1120556 | 0
 |  |  |  | 1134280 | 0 |  |  |  |  |  | 1120821 | 0
 |  |  |  | 1139446 | 0 |  |  |  |  |  | 1122141 | 0
 |  |  |  | 1151430 | 0 |  |  |  |  |  | 1125891 | 0
 |  |  | X90M7 | n/a | 0 |  |  |  |  |  | 1127680 | 0
 |  |  | Z90 | 1164865 | 0 |  |  |  |  |  | 1131687 | 0
 |  |  |  | 1164893 | 0 |  |  |  |  | V30L | 1139909 | 0
 |  |  |  | 1166223 | 0 |  |  |  |  | X90L | n/a | 0
 |  |  |  | 1166256 | 0 |  |  |  | G | 280 | 1112542 | 280
 |  |  |  | 1166272 | 0 |  |  |  |  |  | 1112544 | 280
 | ARC Total |  |  |  | 4885 |  |  |  |  |  | Not Recorded | 280
 | Grand Total |  |  |  | 4885 |  |  |  |  | HIPS Terminal | 1103265 | 0
 |  |  |  |  |  |  |  |  |  | V30 | 1120078 | 0
 |  |  |  |  |  |  |  |  |  |  | 1120835 | 0
 |  |  |  |  |  |  |  |  |  |  | 1121938 | 0
 |  |  |  |  |  |  |  |  |  |  | 1121970 | 0
 |  |  |  |  |  |  |  |  |  |  | 1122215 | 0
 |  |  |  |  |  |  |  |  |  |  | 1127682 | 0
 |  |  |  |  |  |  |  |  |  |  | 1127684 | 0
 |  |  |  |  |  |  |  |  |  | V30L | 1134345 | 0
 |  |  |  |  |  |  |  |  |  |  | 1160240 | 0
 |  |  |  |  |  |  |  | KNL Total |  |  |  | 2625
 |  |  |  |  |  |  |  | Grand Total |  |  |  | 2625
Spreadsheet: richard_sanders__31757__Claim Summary
Sheet: Work Summary

 |  | Property Damage Work Summary
 |  | Mechanical [NAME], June 14, 2000 - Unit #1
Item |  | Vendor/Description of Activity |  |  |  |  |  |  | Schedule | Claim | Adjustments | Estimate
1 | [NAME] |  |  |  |  |  |  |  | Schedule 1
 |  | Elliott on-site services for labor on disassembly,
 |  | re-assemble, final-alignment (Time & Material Contract)
2 | General Electric |  |  |  |  |  |  |  | Schedule 2
 |  | Full set of rotor & stator compressor blades, spacer kit
3 | Power Support |  |  |  |  |  |  |  | Schedule 2 | 92392
 |  | ([NAME]) - Provide compressor stub shaft
4 | Preco |  |  |  |  |  |  |  | Schedule 2
 |  | PRECO shop work on turbine rotor, compressor rotor, 2nd &
 |  | 3rd stage turbine nozzles, transition pieces, inner barrel, etc...
5 | Millwrights, Inc. |  |  |  |  |  |  |  | Schedule 2 | 18507.78
 |  | Consultant services - Waylon Beaty
6 | RTA |  |  |  |  |  |  |  | Schedule 2 | 31551.43
 |  | U1 bearing repair, miscellaneous machining, grinding
 |  | deburring, & quality verification of shim for U1 thrust bearing
 |  | re-conditioning of turning gear motor, & consultant services
7 | Wach's Co. |  |  |  |  |  |  |  | Schedule 2 | 35808.78
 |  | For on-site removal of old stationary vanes
8 | NEPCO |  |  |  |  |  |  |  | Schedule 3
 |  | Construction & startup support
9 | Power Spares |  |  |  |  |  |  |  | Schedule 2
 |  | Provide turning gear reducer and hydraulic planetary gears
10 | Power Systems Mfg. |  |  |  |  |  |  |  | Schedule 4
 |  | Personnel contracted: Metallurgical, failure analysis;
 |  | Re-assemble of LEC Combustor system & Consulting Services
 |  | Direction of [NAME] on-site
11 | Enron North America |  |  |  |  |  |  |  | Schedule 5
 |  | On-site expenses and/or extended support for Virgo, [NAME], etc.
12 | [NAME] |  |  |  |  |  |  |  | Schedule 5 | 1028
 |  | Technical guidance
13 | G.L.C. Consulting |  |  |  |  |  |  |  | Schedule 5
 |  | Technical guidance/Loss Summary
14 | [NAME] |  |  |  |  |  |  |  | Schedule 5
 |  | Technical guidance
15 | [NAME] |  |  |  |  |  |  |  | Schedule 5
 |  | [NAME] ([NAME])
16 | [NAME] (Gas [NAME]. Serv.) |  |  |  |  |  |  |  | Schedule 5
 |  | Consulting on casing leaks, failure analysis, technical guidance
17 | [NAME] |  |  |  |  |  |  |  | Schedule 5
 |  | EECC 3rd Party QA - Oilfield Materials Consultants - OMC
18 | Swame |  |  |  |  |  |  |  | Schedule 5
 |  | Southwest Research - Failure anaalysis
19 | [NAME] |  |  |  |  |  |  |  | Schedule 5
 |  | EECC QA - Contract Labor
20 | Shengli (Victor) [NAME] |  |  |  |  |  |  |  | Schedule 5 | 3817
 |  | EECC Performance Engineer
 |  |  | Total - Property Damage
 |  |  |  |  |  |  |  |  |  |  | Calculation Check
Spreadsheet: 46894d1245826083-hyperlink-or-formula-688738-pls-help-with-hyperlink-or-formula
Sheet:  Employees

Date: | 2009-06-24 07:47:47
Western Employees
Sl # | Emp No. | Name | Driving licence | Vehicle No | Category | Remarks
1 | 366 | [NAME] | Yes | V- 0370 | Engineer
2 | 408 | Loreto Emriqez | No |  | Welder
3 | 435 | [NAME] | No |  | Plumber | Vacation from 5 June - 5 August09
4 | 393 | Joselito sombrero | Yes | V-0595 | Electrician | Vacation on 3-May-16-June-09
5 | 364 | [NAME] | Yes | V-451 | Mason
6 | 412 | [NAME] | No |  | [NAME]
7 | 416 | [NAME] | No |  | [NAME]
8 | 488 | [NAME] | No |  | Welder
9 | 969 | Odranoel Francisco | Yes | V-0474 | Plumber
10 | 1939 | Richrd [NAME] | Yes | [NAME] | Engineer
11 | 964 | [NAME] | Yes | [NAME] | Welder
12 | 966 | [NAME] | Yes | Rental | Engineer
13 | 442 | [NAME] | Yes | V- 0367 | Mason
14 | 480 | [NAME] | No |  | Electrician
15 | 955 | [NAME] | No |  | Mason
16 | 965 | [NAME] | No |  | Engineer
17 | 1030 | Almera Fabiosa | Yes | Rental | Mason
18 | 1050 | [NAME] | No |  | Mason
19 | 1513 | Leo D Vinarao | Yes | V-0259 | Mason
20 | 1536 | Maxima C Arizo | Yes | V-0260 | Engineer | Vacation from 3 July-3Sep-2009
21 | 1553 | Zaldy R Ebal | No |  | Engineer
22
23
24
25
26
27
28
29
30
Spreadsheet: 105279d1302693586-how-to-get-data-from-different-years-2011-to-start-the-same-year-year1-excel-sheet-to-be-used
Sheet: Sheet1

 | BEFORE: DATA RECEIVED
 |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
 | Region 1 | 0 | 0.4145849461518021 | 30.39013390725978 | 75.00900928865839 | 113.1405074663468 | 172.9771966216593 | 230.3938132072616 | 283.8866428710291
 | Region 2 | 0 | 0 | 3.110297923782003 | 23.7041091649121 | 41.88050716411529 | 67.11938472988471 | 97.17306626863957 | 130.8335721914627
 | Region 3 | 0 | 0 | 0 | 10.84493902737385 | 25.78174222778357 | 30.76532176620974 | 37.24676279914906 | 44.79693439055895
 | Region 4 | 0 | 0 | 0 | 0 | 0.2680391179983285 | 2.648810747597634 | 5.474582329064724 | 6.511555510234075
 | Region 5 | 0 | 0 | 0 | 2.880056067204125 | 30.25732832973582 | 96.99545960060571 | 157.1671836290331 | 210.9117734267376
 | Total | 0 | 0.4145849461518021 | 33.50043183104178 | 112.4381135481485 | 211.3281243059799 | 370.5061734659571 | 527.455408233148 | 676.9404783900223
 | AFTER: DESIRED RESULT BY FORMULA
 | should lookup in above table and take the first year it find data over 0 and set it to [NAME] and then the next year as Y2, etc.
 |  | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | [NAME]
 | Region 1 | 0.4145849461518021 | 30.39013390725978 | 75.00900928865839 | 113.1405074663468 | 172.9771966216593 | 230.3938132072616 | 283.8866428710291
 | Region 2 | 3.110297923782003 | 23.7041091649121 | 41.88050716411529 | 67.11938472988471 | 97.17306626863957 | 130.8335721914627
 | Region 3 | 10.84493902737385 | 25.78174222778357 | 30.76532176620974 | 37.24676279914906 | 44.79693439055895
 | Region 4 | 0.2680391179983285 | 2.648810747597634 | 5.474582329064724 | 6.511555510234075
 | Region 5 | 2.880056067204125 | 30.25732832973582 | 96.99545960060571 | 157.1671836290331 | 210.9117734267376
 | Total | 17.51791708251011 | 112.7821243772889 | 250.1248801486539 | 381.1853941346478 | 525.8589707075954 | 361.2273853987243 | 283.8866428710291 | 0
Spreadsheet: 146577d1332260575-excel-2007-3-way-lookup-example-sheet
Sheet: costing matrix

 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 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
1 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
2 |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
3 |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
4 |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
5 |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
6 |  |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
7 |  |  |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
8 |  |  |  |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
9 |  |  |  |  |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70 | 70
10 |  |  |  |  |  |  |  |  |  | 70 | 70 | 70 | 70 | 70 | 70
Spreadsheet: 887139d1737311404-assistance-with-comparing-and-identifying-differences-in-excel-match-copy_2
Sheet: old

TEST Name | Sex | Low range | High Range | Alert low | Alert High |  |  |  |  |  | Test Name | Sex | Low Range | High Range | Alert low | Alert High
ALB |  | 3.5 | 4.9 | 0 | 0 |  |  |  |  |  | ALB |  | 3.5 | 4.9
ALT |  | 1 | 45 | 0 | 0 |  |  |  |  |  | AST |  | 1 | 35
AST |  | 1 | 35 | 0 | 0 |  |  |  |  |  | BUN | F | 6 | 23
BUN | F | 6 | 23 | 0 | 0 |  |  |  |  |  | CL |  | 96 | 108
CA |  | 8.5 | 10.5 | 6.5 | 13 |  |  |  |  |  | CREA | M | 0.7 | 1.3
CL |  | 96 | 108 | 10 | 200 |  |  |  |  |  | GLUC |  | 60 | 100 | 50 | 500
CREA | M | 0.7 | 1.3 | 0 | 0 |  |  |  |  |  | K |  | 3.5 | 5.2 | 2.6 | 6.4
GLUC |  | 60 | 100 | 49 | 501 |  |  |  |  |  | NA |  | 135 | 145 | 120 | 155
K |  | 3.5 | 5.2 | 2.5 | 6.5 |  |  |  |  |  | PO4 |  | 2.4 | 4.7 | 1.7 | 10
NA |  | 135 | 145 | 119 | 156 |  |  |  |  |  | TBIL |  | 0.1 | 1.2 | 0 | 16
PO4 |  | 2.4 | 4.7 | 1.6 | 10.1 |  |  |  |  |  | TCO2 |  | 22 | 30 | 40 | 5
TBIL |  | 0.1 | 10 | 0 | 16 |  |  |  |  |  | CA |  | 8.5 | 10.5 | 6.6 | 12.9
TCO2 |  | 22 | 30 | 11.9 | 40.1
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -939 | -1588
2 | -2025 | -1588
3 | -2053 | -1588
4 | -1629 | -1588
5 | -2098 | -1588
6 | -980 | -1588
7 | -556 | -1588
8 | -833 | -1588 |  |  |  |  |  |  |  |  | Avg
9 | -2039 | -1588 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -1966 | -1588
11 | -2018 | -1588 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -345354
2001-12-11 00:00:00
CBS Volume
 |  |  | -39976
Spreadsheet: 328876d1404124521-count-duplicates-by-date-countifs_sample
Sheet: Sheet2

 | EO-HFJJMEB01 | EO-HFJPWYB01 | EO-HGGRCAB01 | EO-HGGRCA002 | EO-GLRMHCA07 | EO-GLRMHCA06 | EO-GLRMHCA01 | EO-GLRMHCC07 | EO-GLRMHCC06 | EO-GLRMHCC01 | EO-HV4JEL001 | EO-GMENFJ001 | EO-GTVMCVA03 | EO-GTVMCVA01 | EO-HW7HCUA01 | EO-HVW5DNA01 | EO-HVW2ADA01
2014-06-02 00:00:00
2014-06-03 00:00:00
2014-06-04 00:00:00
2014-06-05 00:00:00
2014-06-06 00:00:00
2014-06-09 00:00:00
2014-06-10 00:00:00
2014-06-11 00:00:00
2014-06-12 00:00:00
2014-06-13 00:00:00
2014-06-16 00:00:00
2014-06-17 00:00:00
2014-06-18 00:00:00
2014-06-19 00:00:00
2014-06-20 00:00:00
2014-06-23 00:00:00
2014-06-24 00:00:00
2014-06-25 00:00:00
2014-06-26 00:00:00
2014-06-27 00:00:00
2014-06-30 00:00:00
2014-05-01 00:00:00
2014-05-02 00:00:00
2014-05-05 00:00:00
2014-05-06 00:00:00
2014-05-07 00:00:00
2014-05-08 00:00:00
2014-05-09 00:00:00
2014-05-12 00:00:00
2014-05-13 00:00:00
2014-05-14 00:00:00
2014-05-15 00:00:00
2014-05-16 00:00:00
2014-05-19 00:00:00
2014-05-20 00:00:00
2014-05-21 00:00:00
2014-05-22 00:00:00
2014-05-23 00:00:00
2014-05-26 00:00:00
2014-05-27 00:00:00
2014-05-28 00:00:00
2014-05-29 00:00:00
2014-05-30 00:00:00
Spreadsheet: 771789d1646848308-displaying-info-from-multiple-sheets-on-one-cover-sheet-example-1-
Sheet: Tool Hire

[NAME]
Week Commencing | Date Booked | Job Number | Booked Through | Confirmation Number | Cost
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 8 | HSS | N/A | 15
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 98 | Tool Co | N/A | 25
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 15 | HSS | N/A | 95
2012-03-12 00:00:00 | 2022-02-01 00:00:00 | 6 | HSS | N/A | 77
2012-02-26 00:00:00 | 2022-02-01 00:00:00 | 8 | Tool Co | N/A | 1
Spreadsheet: 848588d1699292713-random-numbers-six-average-numbers-2
Sheet: Hoja1

 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | Aux
 |  |  |  |  | Average Value | 48.4
Spreadsheet: 816266d1675455968-help-with-formula-stock_03022023
Sheet: Blad1

artikel Topa | Artikel
60100005 | TOP100005.2
35999411 | TOP999411
**** | TOP999411
35899411 | TOP999411.1
31411001 | TOP999411-001
35811001 | TOP999411-001.1
33411002 | TOP999411-002
37999411 | TOP999411-004
37899411 | TOP999411-004.1
35411005 | TOP999411-005
35411006 | TOP999411-006
45002001 | TOP999411-007
33411100 | TOP999411-100
33411101 | TOP999411-101
44311102 | TOP999411-102
33411103 | TOP999411-103
44411104 | TOP999411-104
37411105 | TOP999411-105
44999412 | TOP999412
44899412 | TOP999412.1
36999413 | TOP999413
36899413 | TOP999413.1
36999414 | TOP999414
36899414 | TOP999414.1
21999415 | TOP999415
32999416 | TOP999416
35999427 | TOP999427
35999428 | TOP999428
36999429 | TOP999429
36999433 | TOP999433
44999439 | TOP999439
44999440 | TOP999440
32999442 | TOP999442
35999445 | TOP999445
36999446 | TOP999446
44999447 | TOP999447
35999448 | [NAME]
44999449 | TOP999449
36999456 | TOP999456
33999458 | TOP999458
37899460 | TOP999460
36999461 | TOP999461
36999462 | TOP999462.2
? | TOP999462.3
60994632 | TOP999463.2
60894632 | TOP999463.2-PSA
60799466 | TOP999466.3
33899470 | TOP999470.2
33999471 | TOP999471
50999472 | TOP999472
33999492 | [NAME]
18062937 | TOPM182308
18162937 | TOPM182309
18262937 | TOPM182309.1
33007076 | TOPM210547
36211028 | TOPM211028
totaal
Spreadsheet: 861535d1709406634-mark-up-percentage-reducing-as-price-increases-book1
Sheet: Sheet1

 |  | 0.01 | 0.0001
 |  | Net Cost | Mark Up | Net Sell
 |  | 120 | 2.5 |  |  | 250% is the [NAME] markup. What Im trying to do is when I type the net cost in, it automatically reduces the mark up.
 |  | 120.01 | 2.4999
 |  | 120.02
 |  | 120.03
 |  | 120.04
 |  | 120.05
 |  | 120.06
 |  | 120.07
 |  | 120.08
 |  | 120.09
 |  | 120.1
 |  | 120.11
 |  | 120.12
 |  | 120.13
 |  | 120.14
 |  | 120.15
 |  | 120.16
 |  | 120.17
Spreadsheet: 110794d1307395021-need-to-add-3-rows-to-a-cell-reference-book1
Sheet: Imported Data

Activity Log
Work Date: | 2011-04-01 00:00:00
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18188 | Work Type: | PM | Asset: | PS1TUNNEL | Procedure ID: | 408/113 | Start/Stop Time: | Hours: | 0.5
Comments: | BOXES DIMMED GOOD. CLEAR PICS.
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18160 | Work Type: | PM | Asset: | ACS-1 | Procedure ID: | 600/104 | Start/Stop Time: | Hours: | 4
Comments: | COMPLETELY CLEANED AIR COMPRESSOR SYSTEM. INSTALLED HOSES FOR ALL DRAINS AND AUTO PRESSURE SWITCHES.
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18189 | Work Type: | PM | Asset: | PS2 TUNNEL | Procedure ID: | 408/113 | Start/Stop Time: | Hours: | 0.5
Comments: | BOXES DIMMED GOOD. CLEAR PICS.
Total Hours for | 462/10 | on | 2011-04-01 00:00:00 | 5
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17561 | Work Type: | EM | Asset: | S1-1 | Procedure ID: | 003/101 | Start/Stop Time: | Hours: | 0.4
Comments: | [NAME] TAKE UP ROLLER ON SINGULATOR DRIVE
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18149 | Work Type: | PM | Asset: | 101-1 | Procedure ID: | 110/113 | Start/Stop Time: | Hours: | 2
Comments: | [NAME] UP ON SKATE WHEEL SECTIONS. TIGHTENED SET SCREWS AT COAL CHUTE CRANK HANDLE AT CHUTES 102-6 AND 103-6
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18148 | Work Type: | PM | Asset: | 101-5 | Procedure ID: | 106/113 | Start/Stop Time: | Hours: | 1.25
Comments: | [NAME] IN GOOD SHAPE, ALL LANE FULL LIGHT WORKING CORRECTLY.
Spreadsheet: 549955d1512000219-unique-points-column-table-example
Sheet: Sheet1

Example 1 |  |  |  |  |  |  |  |  |  |  |  | Example 2
Team | PL | W | D | L | GF | GA | [NAME] | PTS | Unique PTS | Rank |  | Team | PL | W | D | L | GF | GA | [NAME] | PTS | Unique PTS | Rank
Team A |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | A |  | 2 | 0 | 8 | 25 | 15
Team B |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | B |  | 2 | 0 | 8 | 25 | 15
Team C |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | C |  | 2 | 0 | 8 | 25 | 15
Team D |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | D |  | 2 | 0 | 8 | 25 | 15
Team E |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | E |  | 2 | 0 | 8 | 25 | 15
Team F |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | F |  | 2 | 0 | 8 | 25 | 15
Team G |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | G |  | 2 | 0 | 8 | 25 | 15
Team H |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | H |  | 2 | 0 | 8 | 25 | 15
Team I |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | I |  | 2 | 0 | 8 | 25 | 15
Team J |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | J |  | 2 | 0 | 8 | 25 | 15
Team K |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | K |  | 2 | 0 | 8 | 25 | 15
Team L |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | L |  | 2 | 0 | 8 | 25 | 15
Team M |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | M |  | 5 | 2 | 3 | 25 | 15
Team N |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | N |  | 2 | 0 | 8 | 25 | 15
Team O |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | O |  | 2 | 0 | 8 | 25 | 15
Team P |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | P |  | 2 | 0 | 8 | 25 | 15
Team Q |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | Q |  | 2 | 0 | 8 | 25 | 15
Team R |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | R |  | 2 | 0 | 8 | 25 | 15
Team S |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | S |  | 2 | 0 | 8 | 25 | 15
Team T |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | T |  | 2 | 0 | 8 | 25 | 15
Team U |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | U |  | 2 | 0 | 8 | 25 | 15
Team V |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | V |  | 2 | 0 | 8 | 25 | 15
Team W |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | W |  | 2 | 0 | 8 | 25 | 15
Team X |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | X |  | 2 | 0 | 8 | 25 | 15
Team Y |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | Y |  | 2 | 0 | 8 | 25 | 15
Team Z |  | 6 | 2 | 2 | 25 | 15 |  |  |  |  |  | Z |  | 2 | 0 | 8 | 25 | 15
Spreadsheet: 138130d1327521372-creating-multiple-rows-of-data-from-a-single-row-source-example
Sheet: Sourced Data

Order Number | Customer Number | Item Number | Unit Price | Quantity
000001 | 100001 | 1 | 100 | 1
000001 | 100001 | 2 | 100 | 1
000001 | 100001 | 3 | 150 | 1
000001 | 100001 | 4 | 150 | 1
000001 | 100001 | 6 | 50 | 1
000001 | 100001 | 7 | 10 | 1
000001 | 100001 | 8 | 25 | 1
000001 | 100001 | 9 | 100 | 1
000001 | 100001 | 10 | 100 | 1
000002 | 100002 | 2 | 100 | 1
000002 | 100002 | 6 | 50 | 1
000002 | 100002 | 7 | 10 | 2
000002 | 100002 | 8 | 25 | 1
000002 | 100002 | 9 | 100 | 1
000003 | 100003 | 1 | 100 | 1
000003 | 100003 | 2 | 100 | 1
000003 | 100003 | 3 | 150 | 1
000003 | 100003 | 4 | 150 | 1
000003 | 100003 | 5 | 200 | 1
000003 | 100003 | 6 | 50 | 1
000003 | 100003 | 7 | 10 | 1
000003 | 100003 | 8 | 25 | 1
000003 | 100003 | 9 | 100 | 1
000003 | 100003 | 10 | 100 | 1
000004 | 100001 | 1 | 100 | 3
000004 | 100001 | 3 | 150 | 2
000004 | 100001 | 4 | 150 | 1
000004 | 100001 | 9 | 100 | 1
000004 | 100001 | 10 | 100 | 2
Spreadsheet: kevin_ruscitti__20277__market briefs
Sheet: Sheet1

Market Brief | Wednesday, June 6
Stocks | Close | Change | % Change
DJIA | 11070.24 | -105.6 | -0.009448954172572296
DJ 15 Util. | 372.65 | -9.06 | -0.02373529642922638
NASDAQ | 2217.73 | -15.92999999999984 | -0.007131792663162629
S&P 500 | 1270.03 | -13.54 | -0.01054870400523537
Market Vols | Close | Change | % Change
AMEX (000) | 111256 | -7350 | -0.0619698834797565
NASDAQ (000) | 1772162 | -70677 | -0.03835223804141328
NYSE (000) | 1062316 | -53401 | -0.04786249559700175
Commodities | Close | Change | % Change
Crude Oil (Jul) | 27.72 | -0.52 | -0.01841359773371103
Heating Oil (Jul) | 0.7664 | -0.003099999999999992 | -0.004028589993502264
Nat. Gas (Henry) | 3.801 | -0.09099999999999975 | -0.02338129496402871
Palo Verde (Jul) | 173 | -49 | -0.2207207207207207
COB (Jul) | 160 | -45 | -0.2195121951219512
PJM (Jul) | 76.5 | -5.5 | -0.06707317073170732
Dollar US $ | Close | Change | % Change
Australia $ | 1.937 | -0.02600000000000002 | -0.01324503311258279
Canada $ | 1.525 | -0.005000000000000115 | -0.003267973856209226
Germany Dmark | 2.306 | 0.01100000000000012 | 0.00479302832244014
Euro | 0.8474 | -0.006599999999999939 | -0.007728337236533887
Japan ¥en | 120.4 | 0 | 0
Mexico NP | 9.12 | -0.02000000000000135 | -0.002188183807439972
[NAME] | 0.7184 | 0.01 | 0.01411631846414456
Foreign Indices | Close | Change | % Change
Arg MerVal | 439.19 | -3.70999999999998 | -0.008376608715285571
[NAME]. | 3355.2 | 0.6999999999998181 | 0.0002086749142941774
[NAME] | 15328.83 | -65.98999999999978 | -0.004286506760066034
Can TSE 300 | 8194.39 | -64.43000000000029 | -0.007801356610266394
Germany DAX | 6192.44 | -49.69000000000051 | -0.007960423765605733
[NAME] | 13253.39 | 0 | 0
Japan Nikkei 225 | 13174.84 | -16.17000000000007 | -0.001225834867838025
[NAME] | 6790.98 | 118.6299999999992 | 0.0177793431099986
UK FTSE 100 | 5901.5 | -21 | -0.003545799915576193
Source:  Yahoo! & TradingDay.com