tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40431__C014107
Sheet: C014107

Display variant |  |  |  | [NAME]'S |  |  |  | Actuals with POs
Object |  |  |  | PRJ C.014107 |  |  |  | Agave WT I/C
Cost element |  |  |  | 52507500 |  | To | 82200001 | Outside Serv-Other...
Posting date |  |  |  | 2000-01-01 00:00:00 |  | To | 2001-11-30 00:00:00
 | CoCd |  | WBS element |  | Cost elem. |  |  | Cost element descr. |  | Value COCurr |  | Material |  | Quant |  | Material description |  | PostgDate
 | 60 |  | C.014107.01.04.02 |  | 52507500 |  |  | Outside Services - Other |  | 2508.68 |  | 9000042 |  |  |  | AP,ENGINEERING SERVICES,M |  | 2001-11-19 00:00:00
 | * |  | C.014107.01.04.02 |  | 52507500 |  |  |  |  | 2508.68
 | ** |  |  |  | 52507500 |  |  |  |  | 2508.68
 | 60 |  | C.014107.01.06.51 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 10427.55 |  |  |  |  |  |  |  | 2001-11-15 00:00:00
 | * |  | C.014107.01.06.51 |  | 53500500 |  |  |  |  | 10427.55
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 319.2 |  | 7969 |  |  |  | ELL,WLD,CS,12,.5,90,LR,A2 |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 463.18 |  | 13543 |  |  |  | FLNG,WN,12,.5,B,600,RF,A1 |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 1189.95 |  | 24175 |  |  |  | PIPE,STL,12-3/4,.5,SMLS,A |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 96.18 |  | 14340 |  |  |  | BOLT,STD,1-1/2,11-1/4,CT, |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 186.48 |  | 14248 |  |  |  | BOLT,STD,1-1/4,9,CT,A193, |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 38.18 |  | 15227 |  |  |  | GSKT,FLNG,12,600,SPW,1/8, |  | 2001-11-15 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 174.3 |  |  |  |  |  |  |  | 2001-11-13 00:00:00
 | 60 |  | C.014107.01.06.54 |  | 53500500 |  |  | Materials & Supplies - Non Stock |  | 1984.5 |  |  |  |  |  |  |  | 2001-11-13 00:00:00
 | * |  | C.014107.01.06.54 |  | 53500500 |  |  |  |  | 4451.97
 | ** |  |  |  | 53500500 |  |  |  |  | 14879.52
 | 60 |  | C.014107.01.03 |  | 82100106 |  |  | Analyst |  | 20.99 |  |  |  | 1 |  |  |  | 2001-11-30 00:00:00
 | * |  | C.014107.01.03 |  | 82100106 |  |  |  |  | 20.99 |  |  |  | 1
 | ** |  |  |  | 82100106 |  |  |  |  | 20.99 |  |  |  | 1
 | 60 |  | C.014107.01.04.02 |  | 82200001 |  |  | Contract Labor |  | 1 |  |  |  | 1 |  |  |  | 2001-11-30 00:00:00
 | 60 |  | C.014107.01.04.02 |  | 82200001 |  |  | Contract Labor |  | 3 |  |  |  | 3 |  |  |  | 2001-11-30 00:00:00
 | 60 |  | C.014107.01.04.02 |  | 82200001 |  |  | Contract Labor |  | 2 |  |  |  | 2 |  |  |  | 2001-11-30 00:00:00
 | * |  | C.014107.01.04.02 |  | 82200001 |  |  |  |  | 6 |  |  |  | 6
 | ** |  |  |  | 82200001 |  |  |  |  | 6 |  |  |  | 6
 | *** |  |  |  |  |  |  |  |  | 17415.19 |  |  |  | 7
Spreadsheet: 158780d1338392377-excel-2007-compare-sheets-and-view-removed-rows-book1
Sheet: Sheet1

User Name | UserID | Title | Telephone # | [NAME] | User Status | User Role
[NAME] | CD3056S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] C | DC7704S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | GJ9088S | Non-employee | 15685556664 | email | Active | Analyst
Irma E | IF6341S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JG28957 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JH15105 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JO12495 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JR91483 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | SL93417 | Non-employee | 15685556664 | email | Active | Analyst
Spreadsheet: 31477d1227305581-excel-2007-excel-counting-formula-formula
Sheet: Sheet1

item |  | Amari board price | [NAME] | length [NAME] | cost price | extra cost | price | inc vat |  | discount | sub total | qty | TOTAL | SUPPLY | INC VAT
FOAMEX | 3MM | 23 | 1220 | 2440 |  |  |  |  |  |  |  | 1
FOAMEX | 5MM | 28.27 | 600 | 900 |  |  |  |  |  |  |  | 1
FOAMEX | 10MM | 57 | 600 | 2440 |  |  |  |  |  |  |  | 0
FOAMEX | 19MM | 71 | 1220 | 2440 |  |  |  |  |  |  |  | 0
DIBOND | 3MM | 68 | 1220 | 2440 |  |  |  |  |  |  |  | 0
CORREX | 6MM | 1.5 | 1220 | 2440 |  |  |  |  |  |  |  | 1 |  |  |  | FOR 2 OR MORE
PERSPEX | 3mm | 68 | 1220 | 2440 |  |  |  |  |  |  |  | 1
digital print | vinyl | 24 | 1000 | 1000 |  |  |  |  |  |  |  | 1
REFLECTIVE VINYL | vinyl | 20 | 1000 | 1000 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 175
 | HEM & EYE | banner cost | [NAME] | length [NAME] | BANNER | TOTAL | PRICE | PRICE INC VAT
HD BANNER |  | 24 | 1800 | 1000 |  |  |  |  |  |  |  | 1
BANNER |  | 15 | 1800 | 1000 |  |  |  |  |  |  |  | 1
 |  |  | full cover | 2 sides | 2 sides + bk |  | 2 sides +fr | back | front | supply only | supply only |  | TOTAL | VAT
RECOVERY TRUCK |  | THE FOAMEX FORMULA ONLY WORKS WHEN RHE BOARD SIZE IS SMALL,THE PRICE GOES  TOO EXPENSIVE ON FULL SIZE
BOAT |  | BOARDS, I AM TRYING TO MAKE A FORMULA THAT DELIVERS A DIFFERENT FIGUE IF ANOTHER FIGURE IS REACHED WHICH
TRUCK |  | WILL BE THE NEW PRICE
TRAILER
LWB VAN
SWB VAN
TRANSIT
HORSE BOX
CONNECT SIZE
TAXI
CAR
bus/coach
Spreadsheet: 681455d1591579678-staff-scheduling-with-maximum-free-we-to-be-calculated-by-solver-solver-problem-a-possible-solution
Sheet: Solver Problem

The Company "X" works 7 days a week. The number of employees required daily is: 17 on Monday, 13 on Tuesday, 15 on Wednesday, 17 on Thursday, 9 on Friday, 9 on Saturday and 12 on Sunday. All members of the company work five consecutive days a week.
The company has 22 people and the goal is to plan the working days so that they have the maximum number of weekends that they will not work. How should people plan their work?
 |  |  | number of people per schedule |  |  |  |  |  |  | total working | total number of available employees
 |  |  | 10 | 0 | 5 | 2 | 5 | 0 | 0 |  | 22
 |  |  | working schedules |  |  |  |  |  |  | working | required
 |  | Mon | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | 17
 |  | Tue | 1 | 1 | 0 | 0 | 1 | 1 | 1 |  | 13
 |  | Wed | 1 | 1 | 1 | 0 | 0 | 1 | 1 |  | 15
 |  | Thu | 1 | 1 | 1 | 1 | 0 | 0 | 1 |  | 17
 |  | Fri | 1 | 1 | 1 | 1 | 1 | 0 | 0 |  | 9
 |  | Sat | 0 | 1 | 1 | 1 | 1 | 1 | 0 |  | 9
 |  | Sun | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  | 12
Spreadsheet: 202125d1356346073-solved-cf-format-two-rows-based-on-value-of-2-merged-cells-cf-blank-row-protonleah
Sheet: Sheet1

 |  | Name |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | abc | xyz |  |  |  |  |  |  |  | abc | xyz
 |  | text | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  | trxt | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
 |  |  | Text1
 |  |  | Text2
Spreadsheet: 763895d1642446827-vlookup-formula-with-match-for-4-worksheets-vlook-up-4-sheets
Sheet: Sheet4

name | id
[NAME] | 5555
Calvin | 6666
[NAME] | 5555
Calvin | 6666
[NAME] | 5555
Calvin | 6666
[NAME] | 5555
Calvin | 6666
[NAME] | 5555
Calvin | 6666
Spreadsheet: 100499d1298876395-vlookup-and-if-function-connor-phillips-cs111-project-2-1-1-
Sheet: Sheet1

 | NBA Regular Season Scoring 2010-2011 |  |  |  |  |  | Points | Description
 |  |  |  |  |  |  | 0 | ok
 |  |  |  |  |  |  | 5 | good
Player | Games | Points (Total) | Points (Per Game) | Avg. >22.00 Points (Per Game) |  |  | 10 | great
[NAME] | 47 | 1363 |  |  |  |  | 15 | excellent
[NAME] | 52 | 1322 |  |  |  |  | 20 | outstanding
[NAME] | 50 | 1320 |  |  |  |  | 25 | magnificant
Amar'e Stoudemire | 50 | 1314 |  |  |  |  | 30 | legend
Monta Ellis | 50 | 1260
[NAME] | 52 | 1224
[NAME] | 48 | 1211
[NAME] | 49 | 1206
Blake Griffin | 51 | 1154
[NAME] | 51 | 1147
[NAME] | 51 | 1142
LaMarcus Aldridge | 52 | 1122
[NAME] | 52 | 1111
[NAME] | 45 | 1106
[NAME] | 49 | 1070
[NAME] | 54 | 1049
[NAME] | 51 | 1021
[NAME] | 50 | 1011
[NAME] | 52 | 1007
[NAME] | 48 | 1001
[NAME] | 41 | 997
[NAME] | 52 | 977
[NAME] | 46 | 974
[NAME] | 52 | 973
[NAME] | 42 | 971
[NAME] | 51 | 969
[NAME] | 51 | 937
[NAME] | 47 | 934
[NAME] | 49 | 919
[NAME] | 53 | 905
[NAME] | 51 | 893
[NAME] | 51 | 890
[NAME] | 50 | 888
[NAME] | 52 | 887
[NAME] | 53 | 884
[NAME] | 48 | 875
[NAME] | 43 | 866
[NAME] | 52 | 853
[NAME] | 50 | 860
[NAME] | 49 | 852
Top 40:
Maximum
Minimum:
Spreadsheet: 774260d1648334802-sum-large-help-example-83-
Sheet: Points

Season Start Date
2022-01-07 00:00:00
Names | Best 20 Points | Total Season Points | 2022-01-07 00:00:00
My Sum No Error |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Error cus of not 20 values |  |  | 10 | 10 | 10
If [NAME] tried |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
If Error Shortened |  |  | 10 | 10 |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 476792d1472027268-sorting-addresses-book1
Sheet: Sheet1

835 north 200 west
840 north 200 west
845 north 200 west
850 north 200 west
855 north 200 west
860 north 200 west
865 north 200 west
835 north 300 west
840 north 300 west
845 north 300 west
850 north 300 west
855 north 300 west
860 north 300 west
865 north 300 west
Spreadsheet: 106205d1303389823-simultaneous-updating-worksheets-overdue-ageing-1-
Sheet: WH-4

NAME OF THE COMPANY |  |  | ABC & VO
 |  |  | WAREHOUSE-4
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  | 2011-04-15 00:00:00
Name of the Party | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
HANIF PAINTS | DIRECT PARTY | 2010-12-07 00:00:00 | 17 | 60 | 2011-02-05 00:00:00 | 69 | 21840 | 840 | 0 | 0 | 0 | 840 | 0 | 0 | 0 | 0
NATIONAL ART | DIRECT PARTY | 2011-03-24 00:00:00 | 85 | 60 | 2011-05-23 00:00:00 | -38 | 28083 | 28083 | 28083 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GOMEZ CHEMICALS | DIRECT PARTY | 2011-03-22 00:00:00 | 82 | 60 | 2011-05-21 00:00:00 | -36 | 119948 | 119948 | 119948 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  | 169871 | 148871 | 148031 | 0 | 0 | 840 | 0 | 0 | 0 | 0
Spreadsheet: 218754d1362568016-use-of-data-in-cell-as-a-name-of-file-or-sheet-in-the-formula-use-cell-reference-as-a-file-name-in-formula-2
Sheet: Sheet2

PO intelligence
 | PO#: | Submission Date: | Signature: | DG / Non DG: | Shipment mode: | Expected ETD:
 | 34633 | ='34633'!$D4 | ='34633'!$D5 | ='34633'!$D6 | ='34633'!$D7 | ='34633'!$D8 |  | How can I make the text in red link to B4. That when I change B4, all text in red change accordingly
 | Desire out come
 | PO#: | Submission Date: | Signature: | DG / Non DG: | Shipment mode: | Expected ETD:
 | 34633 | 2013-03-01 00:00:00 | kk | Non DG | SEA | ASAP
 | 34634 | 2013-03-01 00:00:00 | kk | DG | AIR | ASAP
Spreadsheet: 004b25a5-77c3-4e08-b8da-20bc4db4f615
Sheet: Query4

Query Date 07-06-14
Watch for consolidated districts
dat_yer | dst_num | dst_tye | gen_lgr_num | fun_num | end_bal_amt
12-13 | 1 | 1 | 2.14 | 4 | 0
12-13 | 108 | 1 | 2.14 | 4 | -7554
12-13 | 150 | 1 | 2.14 | 4 | 0.12
12-13 | 152 | 1 | 2.14 | 4 | -28387
12-13 | 173 | 1 | 2.14 | 4 | 0
12-13 | 192 | 1 | 2.14 | 4 | -28386.78
12-13 | 195 | 1 | 2.14 | 4 | 0
12-13 | 229 | 1 | 2.14 | 4 | -165.25
12-13 | 252 | 1 | 2.14 | 4 | 0
12-13 | 264 | 1 | 2.14 | 4 | 0
12-13 | 297 | 1 | 2.14 | 4 | -1911
12-13 | 432 | 1 | 2.14 | 4 | -236
12-13 | 477 | 1 | 2.14 | 4 | 0
12-13 | 514 | 1 | 2.14 | 4 | 0
12-13 | 544 | 1 | 2.14 | 4 | 0
12-13 | 545 | 1 | 2.14 | 4 | 0.32
12-13 | 547 | 1 | 2.14 | 4 | 0
12-13 | 548 | 1 | 2.14 | 4 | -0.45
12-13 | 561 | 1 | 2.14 | 4 | -1593.24
12-13 | 581 | 1 | 2.14 | 4 | -181.7
12-13 | 601 | 1 | 2.14 | 4 | -2629.33
12-13 | 630 | 1 | 2.14 | 4 | -280
12-13 | 676 | 1 | 2.14 | 4 | -442.19
12-13 | 709 | 1 | 2.14 | 4 | -9218.23
12-13 | 738 | 1 | 2.14 | 4 | 0
12-13 | 769 | 1 | 2.14 | 4 | -0.47
12-13 | 786 | 1 | 2.14 | 4 | -506.26
12-13 | 818 | 1 | 2.14 | 4 | -101.96
12-13 | 820 | 1 | 2.14 | 4 | 0
12-13 | 821 | 1 | 2.14 | 4 | 1
12-13 | 829 | 1 | 2.14 | 4 | 0
12-13 | 877 | 1 | 2.14 | 4 | 0
12-13 | 914 | 1 | 2.14 | 4 | -0.09
12-13 | 2159 | 1 | 2.14 | 4 | -360.69
12-13 | 2172 | 1 | 2.14 | 4 | -205.6
12-13 | 2310 | 1 | 2.14 | 4 | -121.53
12-13 | 2365 | 1 | 2.14 | 4 | -963.29
12-13 | 2687 | 1 | 2.14 | 4 | 0
12-13 | 2754 | 1 | 2.14 | 4 | -1008.35
12-13 | 2759 | 1 | 2.14 | 4 | -1741.64
12-13 | 2835 | 1 | 2.14 | 4 | -144
12-13 | 2854 | 1 | 2.14 | 4 | -738.43
12-13 | 2860 | 1 | 2.14 | 4 | -2296
12-13 | 2903 | 1 | 2.14 | 4 | -1964
12-13 | 2904 | 1 | 2.14 | 4 | -1623.73
11-12 | 2905 | 1 | 2.14 | 4 | 0
11-12 | 392 | 1 | 2.14 | 4 | 0
11-12 | 394 | 1 | 2.14 | 4 | 0
End of worksheet
Spreadsheet: d282c24e-3e0c-420c-b727-60aff60e83bf
Sheet: Sheet1

Unnamed: 0 | [NAME] and [NAME] (2000) Molecular Evolution and Phylogenetics.  Oxford University Press. New York. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Information for 'Figure 1.4 (page 12)
 | Codon usage observed in RNA polymerase genes of Escherichia coli (Ikemura 1985)
 | Relative synonymouse codon usage is given next to the observed frequencies.
 |  |  |  | RSCU |  |  |  | RSCU |  |  |  | RSCU |  |  |  | RSCU
 | Phe | UUU | 15 | 0.5084745762711864 | Ser | UCU | 32 | 1.864077669902913 | Tyr | UAU | 18 | 0.6428571428571429 | [NAME] | UGU | 5 | 1
 |  | UUC | 44 | 1.491525423728814 |  | UCC | 38 | 2.213592233009709 |  | UAC | 38 | 1.357142857142857 |  | UGC | 5 | 1
 | Leu | UUA | 2 | 0.06629834254143646 |  | UCA | 2 | 0.116504854368932 | Ter | UAA |  |  | Ter | UGA
 |  | UUG | 8 | 0.2651933701657458 |  | UCG | 5 | 0.2912621359223301 | Ter | UAG |  |  | Trp | UGG | 8 | 1
 | Leu | CUU | 11 | 0.3646408839779006 | Pro | CCU | 9 | 0.48 | His | CAU | 5 | 0.3571428571428572 | Arg | CGU | 89 | 3.926470588235294
 |  | CUC | 18 | 0.5966850828729282 |  | CCC | 0 | 0 |  | CAC | 23 | 1.642857142857143 |  | CGC | 46 | 2.029411764705882
 |  | CUA | 1 | 0.03314917127071823 |  | CCA | 11 | 0.5866666666666667 | Gln | CAA | 15 | 0.3409090909090909 |  | CGA | 1 | 0.04411764705882353
 |  | CUG | 141 | 4.674033149171271 |  | CCG | 55 | 2.933333333333333 |  | CAG | 73 | 1.659090909090909 |  | CGG | 0 | 0
 | [NAME] | AUU | 29 | 0.6850393700787402 | [NAME] | ACU | 19 | 0.7755102040816326 | [NAME] | AAU | 4 | 0.1142857142857143 | Ser | AGU | 3 | 0.1747572815533981
 |  | AUC | 98 | 2.31496062992126 |  | ACC | 63 | 2.571428571428572 |  | AAC | 66 | 1.885714285714286 |  | AGC | 23 | 1.339805825242719
 |  | AUA | 0 | 0 |  | ACA | 3 | 0.1224489795918367 | Lys | AAA | 77 | 1.350877192982456 | Arg | AGA | 0 | 0
 | Met | AUG | 60 | 1 |  | ACG | 13 | 0.5306122448979592 |  | AAG | 37 | 0.6491228070175439 |  | AGG | 0 | 0
 | Val | GUU | 55 | 1.527777777777778 | Ala | GCU | 30 | 0.9375 | Asp | GAU | 60 | 0.8275862068965517 | Gly | GGU | 78 | 2.4
 |  | GUC | 21 | 0.5833333333333334 |  | GCC | 19 | 0.59375 |  | GAC | 85 | 1.172413793103448 |  | GGC | 47 | 1.446153846153846
 |  | GUA | 34 | 0.9444444444444444 |  | GCA | 30 | 0.9375 | [NAME] | GAA | 147 | 1.523316062176166 |  | GGA | 0 | 0
 |  | GUG | 34 | 0.9444444444444444 |  | GCG | 49 | 1.53125 |  | GAG | 46 | 0.4766839378238342 |  | GGG | 5 | 0.1538461538461539
Spreadsheet: 160348d1339061897-amalgamating-three-worksheets-into-one-sales-example
Sheet: Sheet1

Region | Branch | Sales ID | [NAME] | Sales Code | Sales of product 2 | Company | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
North | 1 | 789t | J Smith | xx/xxxx | yes | smith & smith | 2600 | 3000 | 2600 | 3000 | 2600 | 3000 | 2600 | 3000 | 2600
Spreadsheet: 874523d1721122829-paste-a-text-file-in-excel-to-draw-totals-to-correct-place-and-category-lourika-work-sheet-pq-aligw
Sheet: Sheet1

 | NORTH |  |  | NORTH WEST |  |  | SOUTH |  |  | SOUTH WEST |  |  | SOUTH SOUTH WEST
 | CODE | TOTAL |  | CODE | TOTAL |  | CODE | TOTAL |  | CODE | TOTAL |  | CODE | TOTAL
 | FC1011 | 12 |  | FC1011 |  |  | FC1011 |  |  | FC1011 |  |  | FC1011
 | FC1021 | 50 |  | FC1021 |  |  | FC1021 |  |  | FC1021 |  |  | FC1021
 | FC1031 | 33 |  | FC1031 |  |  | FC1031 |  |  | FC1031 |  |  | FC1031
 | FC1041 | 0 |  | FC1041 |  |  | FC1041 |  |  | FC1041 |  |  | FC1041
 | NC1051 | 360 |  | NC1051 |  |  | NC1051 |  |  | NC1051 |  |  | NC1051
 | VC1061) | 4 |  | VC1061) |  |  | VC1061) |  |  | VC1061) |  |  | VC1061)
 | VC1071 | 39 |  | VC1071 |  |  | VC1071 |  |  | VC1071 |  |  | VC1071
 | 0001 | 220 |  | 0001 |  |  | 0001 |  |  | 0001 |  |  | 0001
 | 0002 | 99 |  | 0002 |  |  | 0002 |  |  | 0002 |  |  | 0002
 | 110003 | 72 |  | 110003 |  |  | 110003 |  |  | 110003 |  |  | 110003
 | 120004 | 54 |  | 120004 |  |  | 120004 |  |  | 120004 |  |  | 120004
 | I HAVE A PRINT REPORT IN TEXT FORMAT THAT I WANT TO PASTE INTO AN EXCEL SHEET.
 | CAN A FORMULA HELP TO DRAW THE TOTALS FOR EVERY CODE ACCORDING TO THE AREA INTO ITS OWN COLUMNS?
 |  | 12 |  |  | 109 |  |  | 126 |  |  | 91 |  |  | 14
 | FC1021 | 50 |  | FC1021 | 760 |  | FC1011 | 49 |  | FC1021 | 68 |  | FC1021 | 120
 | FC1031 | 33 |  | FC1031 | 20 |  | FC1021 | 58 |  | FC1031 | 125 |  | FC1031 | 63
 | FC1041 | 0 |  | FC1041 | 300 |  | FC1031 | 81 |  | FC1041 | 59 |  | FC1041 | 0
 | NC1051 | 360 |  | NC1051 | 129 |  | FC1041 | 98 |  | NC1051 | 44 |  | NC1051 | 190
 | VC1061 | 4 |  | VC1061 | 256 |  | NC1051 | 165 |  | VC1061 | 75 |  | VC1061 | 61
 | VC1071 | 39 |  | VC1071 | 56 |  | VC1061 | 40 |  | VC1071 | 45 |  | VC1071 | 90
 | 0001 | 220 |  | 0001 | 156 |  | VC1071 | 78 |  | 0001 | 63 |  | 0001 | 0
 | 0002 | 99 |  | 0002 | 61 |  | 0001 | 235 |  | 0002 | 90 |  | 0002 | 45
 | 110003 | 72 |  | 110003 | 79 |  | 0002 | 52 |  | 110003 | 100 |  | 110003 | 106
 | 120004 | 54 |  | 120004 | 90 |  | 110003 | 72 |  | 120004 | 120 |  | 120004 | 123
 |  |  |  |  |  |  | 120004 | 0
Spreadsheet: 852101d1702200149-use-lookup-to-get-2-values-from-2-cells-in-the-same-row-excelforum-14-aligw
Sheet: Sheet1

Arsenal
[NAME]
Bournemouth
Brentford
Brighton
Burnley
Chelsea
Crystal Palace
Everton
Fulham
Liverpool
Luton
Man City
Man Utd
Newcastle
[NAME]
Sheffield Utd
Spurs
West Ham
Wolves
Spreadsheet: 45125d1243897474-add-and-subtract-time-eot2
Sheet: Sheet2

Input
result
 |  | Mins | Secs |  |  |  | test |  |  |  |  | The town of Farmington is longitude 72 deg 49 min
Month | jun | 0 | -23 |  | 0 | 0 | 0 | slow |  |  |  | The standard Meridian of Farmington is 75 deg
Date | 16 |  |  |  |  |  |  |  |  |  |  | The angular difference is 2 deg 11 min
 |  | 23 |  |  |  |  |  |  |  |  |  | The time difference is 8 min 44 sec or 524 seconds
 |  | -1
 |  |  |  |  |  |  |  |  |  |  |  | on jun 16 the sun is slow by 23 seconds
 |  | -23 | sec | slow
 |  |  |  |  |  | Equation
 |  |  |  |  |  | of Time |  |  |  |  |  | S.T. = [NAME]8 min 44sec + 0 min 23 sec
 |  |  |  |  |  |  |  |  |  |  |  | S.T = 11:51:39
 | deg | min
Standard | 75 | 4500
Meridian
 |  |  |  |  | longitudinal difference
longitude | 72 | deg | 4320
 | 49 | min | 49
 | 4369 | min (deg)
 | -131
 | -8.733333333333333 | min (time)
 | -524 | seconds (time)
Spreadsheet: eric_saibi__9749__011602R
Sheet: Salem 02

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 02
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1,170 MW
Start Date |  | 2002-01-11 00:00:00
End Date |  | 2002-01-16 00:00:00
Prv. Start Date |  | 2002-01-11 00:00:00
Prv. End Date |  | 2002-01-18 00:00:00
Comments |  | Still having generator problem, but the plant decided to bring the unit back on-line to see if they could make it until the refuel in April.
SIC |  | 4931
Plant ID |  | 1018459
Unit ID |  | 1004470
Outage ID |  | 19447
Spreadsheet: 481449d1474470255-conditional-formatting-if-number-if-found-in-a-range-of-cells-sample
Sheet: Sheet1

 |  |  |  |  |  | supplier 1 | suppplier 2 | supplier 3 | supplier 4
 |  |  |  |  | Branch 1 | 100 | 500
2016-01-01 00:00:00 |  | 100 |  |  | Branch 2 |  | 200
2016-02-01 00:00:00 |  | 200 |  |  | Branch 3 | 1000 |  | 300 | 900
2016-03-01 00:00:00 |  | 300 |  |  | Branch 4 |  |  | 600 | 400
2016-04-01 00:00:00 |  | 400 |  |  | Branch 5 | 700
2016-05-01 00:00:00 |  | 500 |  |  | Branch 6 |  | 800
2016-06-01 00:00:00 |  | 600
2016-07-01 00:00:00 |  | 700
2016-08-01 00:00:00 |  | 800
2016-09-01 00:00:00 |  | 900
2016-10-01 00:00:00 |  | 1000
2016-11-01 00:00:00 |  | 1100
2016-12-01 00:00:00 |  | 1200
Spreadsheet: 165478d1341243768-auto-populate-data-in-excel-student-information-output-file-
Sheet: Sheet1

Field of Study | General Field | Sub-Field | Student  Name | Student Last Name
Forests And Nature Conservation | Forestry | Forestry | Andressa | Ford
Oceanography | Oceanography | Oceanography | Fernanda | Lima
Oceanography | Oceanography | Oceanography | Felipe | Smith
Game Art | Forestry | Forestry | [NAME] | Lyles
Agricultural Production | Communications | Digital Communication & Media/Multimedia | Gustavo | Mills
Design | Design | Design | Hellem | [NAME]
International Business | Business | International Business | [NAME] | Menino
Fashion Design | Fashion | Fashion/Apparel Design | Camila | [NAME]
Technology And Digital Media | Communications | Digital Communication & Media/Multimedia | Wagner | [NAME]
Techonology And Digital Media | Communications | Digital Communication & Media/Multimedia | Toshihiro | [NAME]
Spreadsheet: chris_germany__1968__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Fri |  | 22000 | 4/15/02 10:00 AM  verified payment with [NAME].
 | Fri | 2002-04-19 00:00:00 | 17000 | 4/23/02  9:15 AM verified payment with [NAME].
 | Thu |  | 0
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Current Cash Balance
Notes: | 4/9/02  2:30 PM - Per [NAME] at Reliant - purchase formula for the March 1st is using [NAME] instead of GD + $.06.  Fixed formula in spreadsheet, total impact to cash balance is ($120.00)