tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: Reviews

Monthly Salon Grade
GM enter in blue areas
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Review 1
Review 2
Review 3
Review 4
Review 5
Average
Spreadsheet: 119839d1314787993-random-calculation-problem-french-tour
Sheet: Sheet3

Player/Day | Th | Fri am | Fri pm | Sat |  |  |  |  |  |  | Player/Day | Th | Fri am | Fri pm | Sat
A | N | I | M | H |  |  | A | [NAME] | 13 |  | A
B | M | J | L | I |  |  | B | [NAME] | 21 |  | B
C | L | K | J | O |  |  | C | Alaistair Pinney | 28 |  | C
D | K | L | I | M |  |  | D | [NAME] | 25 |  | D
E | J | M | K | N |  |  | E | Morris Gwilt | 23 |  | E
F | I | N | H | K |  |  | F | [NAME] | 28 |  | F
G | H | O | E | P |  |  | G | [NAME] | 13 |  | G
H | G | P | F | Q |  |  | H | [NAME] | 12 |  | H
I | F | Q | G | L |  |  | I | [NAME] | 23 |  | I
J | E | A | D | B |  |  | J | [NAME] | 24 |  | J
K | D | C | O | A |  |  | K | [NAME] | 20 |  | K
L | C | B | A | D |  |  | L | [NAME] | 26 |  | L
M | B | D | Q | C |  |  | M | [NAME] | 15 |  | M
N | A | E | B | F |  |  | N | [NAME] | 31 |  | N
O | Q | F | P | E |  |  | O | [NAME] | 21 |  | O
P | O | G | Q | J |  |  | P | [NAME] | 20 |  | P
Q | P | H | C | G |  |  | Q | [NAME] | 11 |  | Q
Spreadsheet: 681696d1591703873-count-values-in-one-range-if-the-cells-in-a-corresponding-range-are-not-empty-forum-help-solution-2
Sheet: Sheet1

[0-10 yrs/oed] | [11-15 yrs/oed] | [16-24 yrs/oed] | [25-34 yrs/oed] | [35-44 yrs/oed] | [45-54 yrs/oed] | [55-64 yrs/oed] | [65-74 yrs/oed] | [75+]
 | 1 | 2 |  | 2 | 1 |  |  |  |  |  |  |  |  |  | In order to calculate the number of households with adults between 16 and 64 and dependents who are under 16, I would like to use a forumula that counts all the instances where there is a value in columns D to G (green in the attached), i.e. each household IF there is a value in the corresponding cells A to B (yellow in the attached).
2 |  | 3 | 1 |  | 2
 | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  |  | I'm pretty sure I should be able to do this but have tried all sorts, to no avail.
 |  | 3 |  |  | 2
 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Here are some of the forumals I've tried:
 |  |  |  |  | 2
 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  | =IF(D2:G875,"<>"),AND(B2:C875,"<>"),COUNT(D2:G875)
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | =IF(B2:C875,"<>"),counta(D2:G875)
 |  |  |  |  |  |  | 2
 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  | =countif(D2:G875,"<>"),(B2:C875,"<>")
 |  | 2 |  |  | 1 | 1
 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | These all return a 'There's a problem with this formula' errors.
 |  |  |  |  |  |  | 2
2 | 2 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | Can anyone help?
1 | 1 |  |  |  | 1 | 1
 |  | 2 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  | Thanks!
1 | 1 |  |  |  | 2
1 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | actually, it's not working properly.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So what I need is to count every household where there is at one or more child under 16 AND one or more adults 16-54 AND one or more adults over 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I also need to count hosueholds where there is one or more adults 16-54 AND one or more adults over 55 but NO children under 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | your help greately appreciated as always
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Alexander

School |  |  | Scholarship | Experiation Date
[NAME] |  |  | Future Foundation | March 9th
 |  |  | *Choose Appalachian Teaching (CAT) Scholarship Program: | March 1st/June12
 |  |  | Dr. [NAME] Norma Sprague Ohio University Scholarship | N/A
 |  |  | Ohio Black Caucus Scholarship | March 16th
 |  |  | *Time Warner Cable College Scholarship | N/A
 |  |  | *Printing Industries Education Funds, Inc. Scholarship | TBA
 |  |  | Kibble Foundation Scholarship | May 15th
 |  |  | [NAME] and [NAME] | April 13th
 |  |  | *The Foundation fpr Appalachian Ohio Scholarships | TBA
 |  |  | Ohio Association of Career Colleges & Schools Legislative | April 2nd
 |  |  | Scholarship Program
 |  |  | *Roger Pedigo Scholarship | March 29th
 |  |  | *Better Men Scholarship | April 15th
 |  |  | IAAP Scholarship: | TBA
 |  |  | *Bill Gates Scholarship | January 12th
 |  |  | Athens Soil & Water Conservation District Scholarship | March 29th
 |  |  | Ohio Association of Garden Clubs, Inc. Scholarships | March 15th
 |  |  | *Engineers Foundation of Ohio College Scholarship | Dec 14th
 |  |  | *United Producers Scholarship | April 1st
 |  |  | *KFC Colonel's Scholars Program | Feb. 8th
 |  |  | *"Aspiring Fashion Professional" Scholarship Program | N/A
 |  |  | *The American Legion: Education Student Aid for Education | N/A
 |  |  | Scholarships National Sources
 |  |  | *American Legion Auxiliary Past Presidents | TBA
 |  |  | Parley - Nurses' Scholarship
 |  |  | Alexander Hoops Scholarship | TBA
 |  |  | AFSCME Family Scholarship | N/A
 |  |  | Athens A.M. Rotary [NAME] Memorial Scholarship | March 31st
 |  |  | The William D. Squires Educational Foundation Scholarship | April 5th
 |  |  | [NAME] | March 1st
 |  |  | Shade Senior Citizens Association Scholarship | April 27th
 |  |  | Ohio Newspapers Foundation 2012 Minority Scholarship: | March 31st
 | TBA or N/A: Check with Guidance Counselors for Updated Dates
Spreadsheet: vladi_pimenov__41012__Pipeline Strg Activity02-02
Sheet: AGA INPUT

Storage Capacity |  |  |  |  |  |  |  |  |  | Weekly Change
Week | Month | 1999 | 2000 | 2001 | 2002 | 2003 |  |  |  |  |  | 2000 | 2001
1 | Jan | 2645 | 2437 | 1729 | 2856
 |  | 2412 | 2322 | 1562 | 2666
 |  | 2209 | 2212 | 1459 | 2529
 |  | 2117 | 2017 | 1369 | 2405
 |  | 2039 | 1775 | 1241 | 2294
 | Feb | 1946 | 1562 | 1136
 |  | 1887 | 1404 | 1041
 |  | 1790 | 1268 | 960
 |  | 1662 | 1194 | 859
 | Mar | 1593 | 1157 | 786
 | Mar | 1459 | 1126 | 711
 |  | 1372 | 1064 | 688
 |  | 1335 | 1036 | 676
 | Mar | 1337 | 1031 | 627
 | Apr | 1362 | 1033 | 641
 | Apr | 1369 | 1008
 |  | 1374
 |  | 1408 |  | 850
 | May | 1480 | 1117 | 958
 | May | 1559 |  | 1064
 | May | 1632 |  | 1182
 |  | 1703 |  | 1281
 | Jun | 1794 | 1352 | 1398
 |  | 1857 | 1430 | 1503
 | Jun | 1942 | 1494 | 1609
 | Jun | 2033 | 1567 | 1717
 | Jul | 2102 | 1636 | 1822
 |  | 2161 | 1733 | 1932
 |  | 2239 | 1803 | 2042
 | Jul | 2280 | 1857 | 2126
 | Aug | 2306 | 1920 | 2203
 |  | 2351 | 1985 | 2283
 |  | 2402 | 2037 | 2286
 |  | 2452 | 2092 | 2419
 |  | 2521 | 2144 | 2495
 | Sep | 2587 | 2186 | 2572
 |  | 2668 | 2258 | 2667
 |  | 2746 | 2325 | 2757
 |  | 2825 | 2402 | 2848
 | Oct | 2887 | 2480 | 2914
 |  | 2936 | 2542 | 2979
 |  | 2978 | 2571 | 3042
 |  | 2991 | 2642 | 3067
 | Nov | 2995 | 2712 | 3090
 |  | 3007 | 2748 | 3100
 |  | 3016 | 2742 | 3107
 |  | 2996 | 2648 | 3132
 | Dec | 3001 | 2502 | 3144
 |  | 2932 | 2429 | 3128
 |  | 2859 | 2271 | 3106
 |  | 2743 | 2113 | 3061
 |  | 2570 | 1938 | 2980
Spreadsheet: 125601d1319122864-pull-codes-from-list-based-on-number-of-orders-test-names
Sheet: Test - Names

Code | [NAME] | Customer | # Ordered
R2489624 Y530575 S734643 C3795657 | [EMAIL] | a | 4
P2938573 U1836608 | [EMAIL] | b | 2
 | [EMAIL] | c | 2
 | [EMAIL] | d | 1
 | [EMAIL] | e | 2
 | [EMAIL] | f | 1
 | [EMAIL] | g | 2
 | [EMAIL] | h | 2
 | [EMAIL] | i | 1
 | [EMAIL] | j | 1
 | [EMAIL] | k | 3
 | [EMAIL] | l | 1
 | [EMAIL] | m | 4
 | [EMAIL] | n | 2
 | [EMAIL] | o | 3
 | [EMAIL] | p | 3
 | [EMAIL] | q | 5
 | [EMAIL] | r | 5
 | [EMAIL] | s | 4
 | [EMAIL] | t | 2
 | [EMAIL] | u | 2
 | [EMAIL] | v | 3
 | [EMAIL] | w | 1
 | [EMAIL] | x | 3
 | [EMAIL] | y | 2
 | [EMAIL] | z | 3
Spreadsheet: 718286d1613069596-combine-two-columns-into-one-while-skipping-blanks-book-1
Sheet: Sheet1

Workers Name:
[NAME]
[NAME]
[NAME]
 |  |  | Want it to skip that header
Visitors / Sub Contractors
[NAME]
[NAME]
Stew
Spreadsheet: theresa_staab__39596__Producer Pricing Detail Nov01
Sheet: S Kitty Detail

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0.61 | 0.596
[NAME] |  |  |  | 0.47 | 0.456
S. Kitty Net Backs: |  | Index Discount/Premium | EMS Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total South Kitty Allocated [NAME] | Total South Kitty Production MMBtu | Total Purchased Production MMBtu | Total South Kitty Payments by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | (7% [NAME] to Maverick)
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 690171d1596909601-ref-when-using-index-match-match-with-tables-excel-query
Sheet: Debt Payoff

Company | Payoff Plan | Opening Bal | August Basic | Snowball | Balance | September Basic | Snowball | Balance | October | Snowball | Balance | November | Snowball | Balance | December | Snowball | Balance
Creation | 1 |  |  | 300
Overdraft | 2 | 1000 |  | 1000
HSBC CC | 3 |  |  |  |  |  | 600 |  |  | 400 |  |  |  |  |  | 244.21
Marbles | 4 | 1681.41 |  |  |  |  |  |  |  | 600 |  |  |  |  |  | 731.41
Very | 5 | 1319.96
Paypal | 6 | 3886.37
Barclaycard | 7
HSBC Loan | 8
Hitachi | 9
Spreadsheet: 41682bc7-b0c3-44d3-abbe-ecc4d05170d7
Sheet: Table S5 Primers

Table S5 Primers used for mutation analyses of FANCC and BLM
Gene | Forward primer (5'-3') | Reverse primer (5'-3') | Product size (bp) | Annealing temperature (°C)
FANCC_ex2 | GTGAAGGCACTGATAAAAGAGC | TGGTAGAGTCCCTGAAGTCAGAA | 356 | 60
FANCC_ex3 | GCATTCACGTTCCCTCAATC | GCCTCTGTGAAACAATGCAAAG | 239 | 64
FANCC_ex4 | TTCCACCCCACCCCAAAAT | TCAGGGATACTTGTTCTGTGAACT | 303 | 64
FANCC_ex5 | TGTAGGCATTGTACATAAAAGGCA | GCTGATGGCACATTCAGCATTA | 240 | 60
FANCC_ex6 | [NAME] | ACCATAACTGAACATCCATTTCC | 269 | 64
FANCC_ex7 | GTCCTTAATTATGCATGGCTCTTAG | CAACACACCACAGCCTTCTA | 289 | 60
FANCC_ex8 | TTCAGTGAGCCATTTCTGT | TGATTCCAAGCATCTCCTTC | 260 | 58
FANCC_ex9 | CAGTTCCCAGTAACTCCTTTGGCT | TCAGAGGAACAGGAGGGAATCAGA | 280 | 64
FANCC_ex10 | AGTGCAGGTTTTCATGTTTGCCG | [NAME] | 306 | 64
FANCC_ex11 | TCCTGACCCCGTTTCAATCT | GTTCTGTCTCCCTCATGCTGT | 242 | 64
FANCC_ex12 | GTGGTTCCTCATGGGCTTGACATT | ATGGTCCCAGACCAGTAATGCCTT | 255 | 64
FANCC_ex13a | GCGTTTGGACAGGCTTTCTGAATC | TAGAAGGCCAAGAGCCACAGCA | 297 | 64
FANCC_ex13b | TCCCTTTGAGAGCTGGTTCCTGTT | ATGCCTGCAGGTTGCCATGACATA | 310 | 64
FANCC_ex14 | TCCTAGAAGTATGTCTGTCCTGCC | CTCGGACAGGTAACCCACCTCT | 338 | 64
FANCC_ex15 | CAAAGGACAAATCTGTCTGGAAAG | CAGGTCATCACCTGTCCTGT | 278 | 64
BLM_ex2 | GCCTGTTTGAATCAAGTCC | TCCTCATCTGTACAATGGG | 296 | 60
BLM_ex3a | ACAATTAATGTAACCTGTGTGAATTAG | AGTCCTTGACCCTTTGCTGA | 272 | 60
[NAME] | TTCCTTCAGTGAACCTCTACCC | AACAAATGATTTTGAAGTCTCAGAAG | 298 | 62
BLM_ex3c | ACCATCAATGATTGGGATGA | GCAAATCACATCGCTGCTTA | 264 | 62
BLM_ex3d | TCCTCTGAAAGCGAGCAAAT | TCATGACTATTCCCAATGGCTA | 244 | 62
BLM_ex4 | CTTAATCGCTCATGCCCTGT | AAACAATTTAAAGTATCCCAGAAACAA | 293 | 64
BLM_ex5 | TTGTCTGATCAGTGGTAGAAA | CAATCTTTGTGTTACGTTGTTTTCA | 300 | 60
BLM_ex6 | CACCATGCCTAGCCAAGACTTT | CCTGAACATTTTGCCCTGTCCA | 288 | 60
BLM_ex7a | ATTTGCTTTTGTGGCCTACC | GGTGGCAGAGAATCCTGTCT | 294 | 64
[NAME] | TTCCCTCAAATTCTGTTTCTCC | AAATTATCAATATCATAGGAAGGTTGG | 295 | 64
BLM_ex7c | TCCCAGGAAATGTTCTCACA | CAGTCTGTCTTGGCTGAGGA | 262 | 64
BLM_ex7d | TCAACCCATCAAGGAAGGTC | [NAME] | 238 | 64
BLM_ex8 | GGGCAAGGGAAATGCTAAAG | TCATTTAACATCTGCCAATGGA | 321 | 62
BLM_ex9 | TTCATGCTCTGAAGACAGAACC | TGCAAATTTAACTGCTGTGCTT | 295 | 64
BLM_ex10 | ACAAATGTAATTTTGTCAGGTTAATG | TTCTGGATGAAAGTTGTACAAAAA | 298 | 64
BLM_ex11 | TGGAATTTGAAGACCACAGAA | CGTTCACTCAGTGTGGGTTTT | 267 | 64
BLM_ex12 | CATTGAGCAGTGTTGGCTTT | [NAME] | 286 | 64
BLM_ex13 | [NAME] | TTGTGGTACTAAAAAGACATTTGTTAC | 245 | 64
BLM_ex14 | TAAATTGTGTTTTTGTTTATGTTA | GCATGTTTGGTTATATGCTAT | 286 | 60
BLM_ex15 | AAAATGTTCCTTCAAGTCTGTGC | TACTATCATGAGGCTGAAGATGA | 308 | 64
BLM_ex16 | TGATATGCTCTATTTTTCCCCTA | GTATCTACATTTTTAAAGTAAGAG | 317 | 60
BLM_ex17 | AGGCATTGTTACCTTAATTA | TCTTTAGATGTTCAATTTCAA | 255 | 56
BLM_ex18 | TGATGATATACGTACATTTA | TTTGGTTCACTCATTGTGAG | 300 | 56
BLM_ex19 | GCCCCTGTATGGGTACAAGT | GCCTATTAATCTGTGCCACGTA | 300 | 64
BLM_ex20 | CAGTGGGTTTTCTATGGGTGA | GCATTCACACAACTGCATCC | 269 | 64
BLM_ex21a | CCTGCAGCGTGTCTCTTCAT | ATACCCCTTTGCCTTGGAAC | 290 | 64
BLM_ex21b | ACAGTTCCCCAGGGATAAGC | ATCCTTCAAAGCAAGGCAGA | 280 | 64
BLM_ex22 | CATTCATTTTTGGTTTCATTTAAC | TGGTCAGATGCTGACAAACA | 286 | 62
Spreadsheet: 113510d1309383913-excel-2007-find-rows-example
Sheet: Sheet1

1 |  | 61 |  |  |  | 20 |  | 2
2 |  | 20 |  |  |  | 5 |  | 18
3 |  | 27 |  |  |  | 94 |  | 11
4 |  | 29 |  |  |  | 10 |  | 7
5 |  | 41 |  |  |  | 61 |  | 1
6 |  | 45
7 |  | 10
8 |  | 42
9 |  | 90
10 |  | 34
11 |  | 94
12 |  | 32
13 |  | 85
14 |  | 93
15 |  | 40
16 |  | 21
17 |  | 70
18 |  | 5
Spreadsheet: 101834d1299865164-counting-names-snoopdilla2
Sheet: Sheet2

Day |  | 1st shift | 2ndshift | 3rd | 4th
2011-08-01 00:00:00 |  | bob | tiff | [NAME] | [NAME]
2011-08-02 00:00:00 |  | [NAME] | bob | liz | sara
2011-08-03 00:00:00 |  | [NAME] | [NAME] | tiff | bob
2011-08-04 00:00:00 |  | bob | [NAME] | ned | bill
2011-08-05 00:00:00 |  | ned | [NAME] | sara | liz
2011-08-06 00:00:00 |  | tiff | ned | bill | bob
2011-08-07 00:00:00 |  | bob | tiff | [NAME] | [NAME]
2011-08-08 00:00:00 |  | [NAME] | bob | liz | sara
2011-08-09 00:00:00 |  | [NAME] | [NAME] | tiff | bob
2011-08-10 00:00:00 |  | bob | [NAME] | ned | bill
2011-08-11 00:00:00 |  | ned | [NAME] | sara | liz
2011-08-12 00:00:00 |  | tiff | ned | bill | bob
2011-08-13 00:00:00 |  | bob | tiff | [NAME] | [NAME]
2011-08-14 00:00:00 |  | [NAME] | bob | liz | sara
2011-08-15 00:00:00 |  | [NAME] | [NAME] | tiff | bob
2011-08-16 00:00:00 |  | bob | [NAME] | ned | bill
Spreadsheet: 631589d1562738187-distance-between-coordinates-shown-in-a-sorted-list-pq-distances-aligw
Sheet: Desired Result

 |  |  | Location ID | x | y
 |  |  | NJ111
 |  |  | Location ID | Coordinate X | Coordinate Y | Distance
 |  |  | LK392 | 656622 | 232628 | 0
 |  |  | ES492 | 650560 | 236088 | 6979.9
 |  |  | PT940 | 643443 | 237911 | 14198.5
 |  |  | PY492 | 643443 | 237911 | 14198.5
 |  |  | RH392 | 653510 | 246900 | 14607.3
 |  |  | HF029 | 653510 | 246900 | 14607.3
 |  |  | UB482 | 655642 | 247923 | 15326.4
 |  |  | KH387 | 648322 | 246675 | 16315.9
 |  |  | [NAME] | 656260 | 249240 | 16615.9
 |  |  | DE902 | 668849 | 245006 | 17398.7
 |  |  | OR654 | 668855 | 245017 | 17410.7
 |  |  | PG343 | 646860 | 248249 | 18420.4
 |  |  | PL122 | 646860 | 248249 | 18420.4
 |  |  | LN392 | 671310 | 243990 | 18569.7
 |  |  | LR012 | 645850 | 249150 | 19723.4
 |  |  | [NAME] | 647150 | 249980 | 19768.9
 |  |  | KL329 | 635070 | 236500 | 21897.1
 |  |  | GF329 | 635070 | 236500 | 21897.1
 |  |  | OL942 | 656550 | 256150 | 23522.1
 |  |  | DF392 | 633251 | 239845 | 24459.9
 |  |  | HY675 | 655820 | 257720 | 25104.8
 |  |  | [NAME] | 665470 | 258450 | 27295.8
 |  |  | RH992 | 665580 | 258800 | 27662.6
 |  |  | [NAME] | 665580 | 258800 | 27662.6
 |  |  | KO420 | 665069 | 259111 | 27797.5
 |  |  | WE942 | 637023 | 261981 | 35294.8
 |  |  | SD932 | 637023 | 261981 | 35294.8
 |  |  | DR029 | 638611 | 263271 | 35544.2
Spreadsheet: 292755d1390773505-trying-to-create-a-functional-spreadsheet-overhead-map-for-trailer-yard-excelforumtrailerinventory-2014-01-26-16-57
Sheet: Log

Log file Opened on 1/26/2014 4:48:12 PM
Trailer Unit Number Exception Report
'List' Sheet Traversal:
Unit Number 123456
Unit Number 321098
Duplicates on Sheet 'List' cells: [NAME]
Unit Number 654321
Unit NOT FOUND on Sheet 'Map'
Unit Number 765432
Duplicates on Sheet 'List' cells: A5 A9 A11
Duplicates on Sheet '[NAME]' cells: A10 A13
Duplicates on Sheet 'Data' cells: [NAME]
Unit Number 987654
Duplicates on Sheet '[NAME]' cells: [NAME]
Unit Number 6543210
Unit NOT FOUND on Sheet 'Data'
Unit Number A11111
Unit Number 765432
Duplicates on Sheet 'List' cells: A5 A9 A11
Duplicates on Sheet '[NAME]' cells: A10 A13
Duplicates on Sheet 'Data' cells: [NAME]
Unit Number 321098
Duplicates on Sheet 'List' cells: [NAME]
Unit Number 765432
Duplicates on Sheet 'List' cells: A5 A9 A11
Duplicates on Sheet '[NAME]' cells: A10 A13
Duplicates on Sheet 'Data' cells: [NAME]
Unit Number 865432
Unit NOT FOUND on Sheet 'Map'
Unit NOT FOUND on Sheet 'Data'
'[NAME]' (Internal Report) Sheet Traversal:
Not Implemented Yet
'Data' (Internal Report) Sheet Traversal:
Unit Number 123456
Unit Number 321098
Unit Number 654321
Unit NOT FOUND on Sheet 'Map'
Unit Number 765432
Unit Number 987654
Unit Number A11111
Unit Number 765432
Unit Number 777777
Unit NOT FOUND on Sheet 'List'
Unit NOT FOUND on Sheet 'Map'
Log file Closed on 1/26/2014 4:48:12 PM
Spreadsheet: 858782d1707334333-automate-a-seating-plan-seat-plan
Sheet: Sheet1

 | Vessel | Amazon | [NAME] |  |  |  | Allocated
Specie | Grade |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T
Cod | 1 | 4 | 26 |  |  |  |  |  |  |  | 1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Cod | 2 | 3 | 13
Cod | 3 | 6 |  |  |  |  |  |  |  |  | 2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Cod | 4 | 20 |  |  |  |  |  |  |  |  | 3 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Cod | 5
Cod | 6 |  |  |  |  |  |  |  |  |  | 4
Haddock | 1 | 5 |  |  |  |  |  |  |  |  | 5
Haddock | 2 | 3 | 2
Haddock | 3 | 9 | 8 |  |  |  |  |  |  |  | 6
Haddock | 4 | 25 | 12 |  |  |  |  |  |  |  | 7
Haddock | 5 | 64 | 24
Haddock | 6 | 20 | 80 |  |  |  |  |  |  |  | 8
Plaice | 1 |  | 1 |  |  |  |  |  |  |  | 9
Plaice | 2 |  | 2
Plaice | 3 |  | 3 |  |  |  |  |  |  |  | 10
Plaice | 4 | 12 | 4 |  |  |  |  |  |  |  | 11
Plaice | 5 |  | 1
Totals |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  | 20
Spreadsheet: 112825d1308820932-overall-rating-based-on-an-alphabetical-score-ratings
Sheet: Sheet1

 | Total Sales Achieved | [NAME] | Adherence | Adherence Rating | QA | QA Rating | Overall Rating |  |  |  |  |  |  | Sales |  |  | QA
 | 259 |  | 0.85 |  | 0.95 |  |  |  |  |  |  |  |  | 0 | D |  | 0 | D
 | 288 |  | 0.86 |  | 0.87 |  |  |  |  |  |  |  |  | 768 | C |  | 0.8 | C
 | 775 |  | 0.92 |  | 1 |  |  |  |  |  |  |  |  | 864 | B |  | 0.85 | B
 | 800 |  | 0.92 |  | 0.87 |  |  |  |  |  |  |  |  | 960 | [NAME] |  | 0.9 | [NAME]
 | 765 |  | 0.9 |  | 0.82 |  |  |  |  |  |  |  |  | 1056 | A |  | 0.95 | A
 | 661 |  | 0.9 |  | 0.68
 | 845 |  | 0.93 |  | 0.96
 | 774 |  | 0.9 |  | 1 |  |  |  |  |  |  |  |  | Adherence
 | 969 |  | 0.9 |  | 0.68 |  |  |  |  |  |  |  |  | 0 | D
 | 775 |  | 0.92 |  | 0.57 |  |  |  |  |  |  |  |  | 0.7 | C
 | 830 |  | 0.9 |  | 0.8 |  |  |  |  |  |  |  |  | 0.75 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.76 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85 | A
Spreadsheet: tracy_geaccone__40311__EREC IC 0907
Sheet: Invoice

 | Enron Net Works
 | 1400 Smith Street
 | Houston, Texas 77002
 | Preliminary Intercompany billing for 2002
To: EREC
 | Accounting Contact: | ?
 | Other Contact: | ?
Description |  | Amount
EnronOnline |  | 0
Energy Operations |  | 0
IT eCommerce |  | 0
IT Development
IT Infrastructure
IT Enterprise Portal Solutions
 | TOTAL
Footnotes:
Does not include infrastructure pass-through billing (long distance, market data, WAN, etc.) which should be
budgeted for by  the business unit.
Spreadsheet: 80689d1280909773-copy-data-to-individual-columns-automatically-arr-dep
Sheet: Sheet1

 |  |  |  |  | MON |  |  | TUE |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT |  |  | SUN
DAY | DATE | DEP | ARR | TARGET | DATE | DEP | ARR | DATE | DEP | ARR | DATE | DEP | ARR | DATE | DEP | ARR | DATE | DEP | ARR | DATE | DEP | ARR | DATE | DEP | ARR
TUE | 2010-07-06 00:00:00 | 72.29 | 66.2 | 80
WED | 2010-07-07 00:00:00 | 83.53 | 77.6 | 80
THU | 2010-07-08 00:00:00 | 72.97 | 64.6 | 80
FRI | 2010-07-09 00:00:00 | 55.95 | 53.95 | 80
SAT | 2010-07-10 00:00:00 | 75 | 62.5 | 80
SUN | 2010-07-11 00:00:00 | 84 | 57.9 | 80
MON | 2010-07-12 00:00:00 | 81.94 | 73.85 | 80
TUE | 2010-07-13 00:00:00 | 68.83 | 68.6 | 80
WED | 2010-07-14 00:00:00 | 66.23 | 66.2 | 80
THU | 2010-07-15 00:00:00 | 71.9 | 66 | 80
FRI | 2010-07-16 00:00:00 | 75.95 | 64.38 | 80
SAT | 2010-07-17 00:00:00 | 81.08 | 83.33 | 80
SUN | 2010-07-18 00:00:00 | 82.76 | 80 | 80
MON | 2010-07-19 00:00:00 | 71.59 | 67.9 | 80
TUE | 2010-07-20 00:00:00 | 89.19 | 80.56 | 80
WED | 2010-07-21 00:00:00 | 84.15 | 74.65 | 80
THU | 2010-07-22 00:00:00 | 85.53 | 73.13 | 80
FRI | 2010-07-23 00:00:00 | 80.81 | 80.65 | 80
SAT | 2010-07-24 00:00:00 | 76.32 | 63.64 | 80
SUN | 2010-07-25 00:00:00 | 72.73 | 57.14 | 80
MON | 2010-07-26 00:00:00 | 79.01 | 78.38 | 80
TUE | 2010-07-27 00:00:00 | 77.38 | 77.5 | 80
WED | 2010-07-28 00:00:00 | 70.37 | 70.93 | 80
THU | 2010-07-29 00:00:00 | 80.46 | 75 | 80
FRI | 2010-07-30 00:00:00 | 74.03 | 81.82 | 80
SAT | 2010-07-31 00:00:00 | 75 | 90.32 | 80
SUN | 2010-08-01 00:00:00 | 67.86 | 66.67 | 80
MON | 2010-08-02 00:00:00 |  |  | 80
TUE | 2010-08-03 00:00:00 |  |  | 80
WED | 2010-08-04 00:00:00 |  |  | 80
THU | 2010-08-05 00:00:00 |  |  | 80
FRI | 2010-08-06 00:00:00 |  |  | 80
SAT | 2010-08-07 00:00:00 |  |  | 80
SUN | 2010-08-08 00:00:00 |  |  | 80
MON | 2010-08-09 00:00:00 |  |  | 80
TUE | 2010-08-10 00:00:00 |  |  | 80
WED | 2010-08-11 00:00:00 |  |  | 80
THU | 2010-08-12 00:00:00 |  |  | 80
FRI | 2010-08-13 00:00:00 |  |  | 80
SAT | 2010-08-14 00:00:00 |  |  | 80
SUN | 2010-08-15 00:00:00 |  |  | 80