tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 731547d1620401650-index-match-multiple-rows-test-index-match-workbook
Sheet: Sheet1

 |  |  |  |  | File Amount | Active/Cancelled |  | Total of Cancelled Files (only returns first value) |  |  | Keyword |  | Cell I4 should contain a total of all 'Cancelled' files but it only returns first value. The formula will need to search column G for the word 'Cancelled' and if found then add all the values directly to the left of it. I4 should be the total as in cell I11.   It should not care about blank cells as there will always be at least one blank cell under the 'cancelled' files. Also, all of the values will be changed multiple times. The file amount and how many active/cancelled files there are will change about 40 times without closing the workbook (we make changes to the amounts and such per the individual employee and send them their report... then move onto the next employee).
 |  |  |  |  | 197000 | Active |  |  |  |  | cancelled
 |  |  |  |  | 307500 | Active
 |  |  |  |  | 283500 | Active
 |  |  |  |  | 276235 | Active
 |  |  |  |  | 417000 | Active
 |  |  |  |  | 289750 | Active
 |  |  |  |  | 230000 | Active |  | Totals of Cancelled Files (what [NAME] should be)
 |  |  |  |  | 238000 | Active
 |  |  |  |  | 197000 | Active
 |  |  |  |  | 328000 | Active
 |  |  |  |  | 421200 | Active
 |  |  |  |  | 493500 | Active
 |  |  |  |  | 259500 | Active
 |  |  |  |  | 548250 | Active
 |  |  |  |  | 279850 | Active
 |  |  |  |  | 723500 | Active
 |  |  |  |  | 510400 | Active
 |  |  |  |  | 217550 | Active
 |  |  |  |  | 256800 | Active
 |  |  |  |  | 345000 | Active
 |  |  |  |  | 240000 | Active
 |  |  |  |  | 142000 | Active
 |  |  |  |  | 199000 | Active
 |  |  |  |  | 277000 | Active
 |  |  |  |  | 245000 | Active
 |  |  |  |  | 329000 | Active
 |  |  |  |  | 340200 | Active
 |  |  |  |  | 101000 | Active
 |  |  |  |  | 529000 | Active
 |  |  |  |  | 177000 | Cancelled
 |  |  |  |  | 425600 | Cancelled
 |  |  |  |  | 320512 | Cancelled
 |  |  |  |  | 269000 | Cancelled
 |  |  |  |  | 415600 | Cancelled
 |  |  |  |  | 548250 | Cancelled
 |  |  |  |  | 365000 | Cancelled
 |  |  |  |  | 190950 | Cancelled
Spreadsheet: 668610d1584930568-show-column-data-to-corresponded-columns-q1-1-
Sheet: Sheet1

 | Indent | Type | Part |  | Indent | Part | Part |  | 0 | 1 | 2 | 3 | 4 | 5 |  | In G, I have Column D, SortBy : B ascending and C descending
 | 0 | Y | 1234 |  |  |  |  |  |  |  |  |  |  |  |  | I want please : "0" not to appear in G and put G in corresponded column F to columns I2:N2
 | 1 |  | 2222 |  | 0 | 1119 |  |  | 1119 | 4499 | 9922
 | 1 | Y | 1254 |  | 1 | 1254 |  |  |  | 2222 | 9999
 | 2 |  | 9999 |  | 1 | 4499 |  |  |  | 4466 | 1765
 | 2 |  | 1765 |  | 1 | 2222 |  |  |  |  | 9991
 | 2 | Y | 2233 |  | 1 | 4466
 | 2 | Y | 9922 |  | 2 | 2233
 | 1 |  | 4466 |  | 2 | 9922
 | 1 | Y | 4499 |  | 2 | 9999
 | 0 | Y | 1119 |  | 2 | 1765
 | 2 |  | 9991 |  | 2 | 9991
Spreadsheet: 91bf5224-5005-4c67-9e45-c963170b20d5
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998417528 | Messenja | Take The City | 2009-01-27 | Compact Disc | [NAME] | 10.99 | Y | Available
Spreadsheet: 84841d1284929820-number-format-and-sum-function-what
Sheet: Sheet1

Home team | Away team | Results
A | B | 32
A | C | 21
A | D | 30
A | E | 24
A | F | 23
So,goal difference for the team A should be  12-10
But when I use Sum (B3:B7 ) I get
Spreadsheet: 691586d1597768373-excel-formula-to-capture-invoice-number-invoice-numbers
Sheet: SALES DATA

Date | Invoice | Customer Number | Name | VAT Number | Order Number | Product Number | Unit Price | Quantity | Gross Amount | VAT % | VAT | Amount Incl VAT |  |  |  |  | C001 | Centenary | 2000123
2020-08-01 00:00:00 | 100 | C001 |  |  | A23 | Maize | 200 | 10 |  | 0.15 |  |  |  |  |  |  | C002 | Dispatch | 2000130
2020-08-01 00:00:00 | 100 | C001 |  |  | A23 | Ground nuts | 100 | 8 |  | 0.15 |  |  |  |  |  |  | C003 | Global | 2000213
2020-08-02 00:00:00 | 101 | C003 |  |  | A24 | Maize | 300 | 10 |  | 0.15 |  |  |  |  |  |  | C004 | Achieve | 2000310
2020-08-03 00:00:00 | 102 | C004 |  |  | A25 | Maize | 150 | 10 |  | 0.15 |  |  |  |  |  |  | C005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C006
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C007
Spreadsheet: 485445d1476884399-sort-by-more-creteria-est
Sheet: Sheet1

Site | Dept | Date | Score |  |  |  |  | Helper (hide) | Site | Dept | Date | Score
Spain | Sales | 2016-05-04 00:00:00 | 3.1
Germany | Infra | 2016-08-01 00:00:00 | 2
Netherland | Sales | 2016-01-01 00:00:00 | 1.3
MA | Tech | 2016-03-03 00:00:00 | 4.5
TR | Tech | 2016-01-01 00:00:00 | 1
Spain | Tech | 2016-08-15 00:00:00 | 2.1
Spain | Sales | 2016-07-01 00:00:00 | 1.2
MA | Tech | 2016-07-08 00:00:00 | 1.2
Spreadsheet: 211011d1359638074-help-row-into-column-another-sheet-dee2
Sheet: MAT

Sl.No | Name | FA(a) | FA(b) | FA(a+b) | SA
1 | Raja | 13 | 15 | 28 | 45
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Spreadsheet: 479242d1473276797-average-values-between-peaks-within-a-data-range-average-values-between-peaks
Sheet: Sheet1

Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Forecast | 200 | 185 | 195 | 210 | 215 | 205 | 220 | 195 | 185 | 190 | 195 | 185
Peaks
Expected Result | 200 | 201.25 | 201.25 | 201.25 | 201.25 | 212.5 | 212.5 | 195 | 190 | 190 | 190 | 185
Explanation | after a peak, I want to sum all cells thereafter up to and including the next peak and then average
Spreadsheet: 675428d1588277917-this-formula-makes-my-workbook-chug-can-it-be-optimized-forumexample
Sheet: Sheet1

Card type | Name | Account | Swimlane | Start | End | Time Bad | Time Good | Carryover?
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-01-23 07:00:00 | 2020-01-23 08:00:00 | 1:00 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-01-27 10:00:00 | 2020-01-27 11:30:00 | 1:30 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-02-19 15:00:00 | 2020-02-19 15:45:00 | 45 min
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-03-23 02:00:00 | 2020-03-23 03:30:00 | 1:30 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-04-09 22:00:00 | 2020-04-09 23:30:00 | 1:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-03-11 22:00:00 | 2020-03-12 07:30:00 | 9:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-04-16 15:30:00 | 2020-04-16 19:00:00 | 3:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-04-16 19:30:00 | 2020-04-16 23:00:00 | 3:30 hrs
SubAssy OL | 1219875 - Landscape - Small | 8600 Project Management | Assembly | 2020-02-26 22:00:00 | 2020-02-27 04:00:00 | 6:00 hrs
SubAssy OL | 1219875 - Landscape - Small | TC-Planning | Assembly | 2020-04-01 22:30:00 | 2020-04-02 06:30:00 | 8:00 hrs
SubAssy OL | 1219875 - Landscape - Small | TC-Planning | Assembly | 2020-04-17 16:00:00 | 2020-04-17 22:15:00 | 6:15 hrs
Spreadsheet: 87a3b718-a1a6-46f1-aee4-218bb17a4251
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | Benefits of Leasing Analysis
 | Equipment cost: | 100000
 | Lease term (in months): | 60
 | Your internal rate of return on investment: | 0.15
 | Your tax rate: | 0.35
 | Lease residual %: | 0.1
 | Monthly payment: | 2248
 | Click here to estimate your monthly payment
 | Real cost of using after-tax dollars: | 135000
 | Opportunity cost of using cash: | 110718.1346951239
 | Total cost of leasing (pmts + residual): | 144880
 | Tax Benefit of Leasing vs. Cash | 100838.1346951239
 | Apply Now
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 1263603 | 913682 | 1290413 | 1660398 | 2636976 | 2586938 | 10352010
Cross-Currency Fixed-Fixed | 69456 | 10382 | 33496 | 39133 | 112925 | 179384 | 444776
Cross-Currency Fixed-Float | 161609 | 123845 | 178037 | 244655 | 381134 | 1630824 | 2720104
TOTAL | 1494668 | 1047909 | 1501946 | 1944186 | 3131035 | 4397146 | 13516890
Spreadsheet: 679813d1590646014-statistic-layout-with-drop-down-list-with-multi-selections-statistic-layout-petmak-
Sheet: Main

Store 1 | Ukrania
 | Bank 2
BIN # | A | A | D | D | P | P | E | E | SUM | SUM | % | %
Store 2
 | Bank 1
BIN # | A | A | D | D | P | P | E | E | SUM | SUM | %
 | 25500 | 2000 |  | 2500 | 15 | 700
 | 1700 | 800 | 1500 | 2040 | 2200 |  | 750 | 70
[NAME] | Recent Data
 | Historical Data
Approved | A
Pending | P
Error | E
Decline | D
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 4M

Name | Surname | P1 | P2 | P3 | P4 | P5 | P6 | P7 | M1 | M2 | M3 | D1 | D2 | Final Grade | Final Points Value
 |  | x | x | x | x |  |  |  |  |  |  |  | x
 |  | x | x | x | x
 |  | x | x | x | x
 |  | x | x | x | x
 |  |  |  |  | x
 |  | x |  | x
 |  | x | x | x | x |  |  |  | x
 |  | x | x | x | x
 |  | x | x | x | x
 |  | x | x | x | x
 |  | x
 |  | x | x | x | x
 |  | x | x | x | x
Spreadsheet: 418de071-1d68-4089-b685-b32243a47a83
Sheet: Lowest 5% PI Score

COUNTY | DISTRICT NAME | DISTRICT IRN | PI SCORE
Summit | Akron City | 043489 | 84.5404999673651
[NAME] | Canton City | 043711 | 84.0266937246332
Cuyahoga | Cleveland Heights-University Heights City | 043794 | 87.324681806838
Cuyahoga | Cleveland Municipal City | 043786 | 75.7423716082997
Franklin | Columbus City | 043802 | 81.7516766237872
Montgomery | Dayton City | 043844 | 75.8702821546354
Cuyahoga | East Cleveland City | 043901 | 74.3536036036036
[NAME] | East Liverpool City | 043919 | 86.3292433537832
Cuyahoga | Euclid City | 043950 | 80.4585649317837
Seneca | Fostoria City | 043992 | 89.4327990135635
Cuyahoga | [NAME] | 044040 | 84.5457855452394
Montgomery | Jefferson Township Local | 048686 | 77.1179883945841
[NAME] | Lima City | 044222 | 80.6318347509113
[NAME] | Lockland Local | 044230 | 93.2838038632987
Lorain | Lorain City | 044263 | 80.0336048879837
Richland | Mansfield City | 044297 | 82.6256722001403
Cuyahoga | Maple Heights City | 044305 | 82.3829623944743
Marion | Marion City | 044339 | 85.9343696027634
Butler | Middletown City | 044404 | 85.9170485254377
[NAME] | Mt Healthy City | 044412 | 81.8962510897995
Lake | Painesville City Local | 044628 | 84
Cuyahoga | Richmond Heights Local | 046599 | 88.561320754717
Erie | Sandusky City | 044743 | 87.8196721311475
[NAME] | Springfield City | 044818 | 81.5256615878107
Lucas | Toledo City | 044909 | 83.0601970865467
Montgomery | Trotwood-Madison City | 048694 | 84.0054794520548
Hardin | Upper Scioto Valley Local | 047522 | 92.2722159730034
Trumbull | Warren City | 044990 | 78.4753901560624
Cuyahoga | Warrensville Heights City | 045005 | 71.489898989899
Pike | Western Local | 049155 | 86.8173598553345
Mahoning | Youngstown City | 045161 | 73.7208393066597
Spreadsheet: 878485d1725563746-exactly-2-fridays-after-commission-tracker-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Incorrect Payout Dates
 |  |  |  |  |  |  |  |  |  | "=WORKDAY.INTL([@Date],2,"1111011")"
 |  |  |  |  | Date | First Name | Last Name | Sale Type | Notes | Payout
 |  |  |  |  | 2024-08-29 00:00:00 | [NAME] | Adkins | Live
 |  |  |  |  | 2024-08-30 00:00:00 | [NAME] | Corl | Post Date | Post Date Successful
 |  |  |  |  | 2024-09-02 00:00:00 | [NAME] | [NAME] | Post Date | Ask manager for $200 discount.
 |  |  |  |  | 2024-09-03 00:00:00 | [NAME] | [NAME] | Live
 |  |  |  |  | 2024-09-04 00:00:00 | Bessie | Loore | Live
 |  |  |  |  |  |  | Correct Payout Dates
 |  |  |  |  | Date | First Name | Last Name | Sale Type | Notes | Payout
 |  |  |  |  | 2024-08-29 00:00:00 | [NAME] | Adkins | Live |  | 2024-09-13 00:00:00
 |  |  |  |  | 2024-08-30 00:00:00 | [NAME] | Corl | Post Date | Post Date Successful | 2024-09-13 00:00:00
 |  |  |  |  | 2024-09-02 00:00:00 | [NAME] | [NAME] | Post Date | Ask manager for $200 discount. | 2024-09-20 00:00:00
 |  |  |  |  | 2024-09-03 00:00:00 | [NAME] | [NAME] | Live |  | 2024-09-20 00:00:00
 |  |  |  |  | 2024-09-04 00:00:00 | Bessie | Loore | Live |  | 2024-09-20 00:00:00
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 145

az145 | Aztec | 1
[NAME] | Bloomfield
cib145 | Cibola
cle145 | Cleveland
[NAME] | Farmington
gal145 | Gallup
grt145 | Grants | 8
kc145 | [NAME]
miy145 | Miyamura | 5
new145 | Newcomb
pv145 | Piedra Vista
rr145 | Rio Rancho
sf145 | Santa Fe
ship145 | Shiprock
vv145 | [NAME] | 4
win145 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 0429a8cd-175a-4c40-a694-720969816340
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 3/31/2010
(As of 5/3/2010)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 115
Ames, [NAME] | At-will staff for Mayor [NAME]
Birge, [NAME] | At-will staff for Mayor [NAME] |  | 1010
[NAME], [NAME] | At-will staff for Mayor [NAME]
Dillmann, [NAME] | At-will staff for Mayor [NAME] | 361.7 | 2500
[NAME], Todd | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner |  | 68500
Fritz, Amanda | Commissioner | 35
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
Lauer, [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner
[NAME], [NAME] | At-will staff for Mayor [NAME] | 34.95
Lord II, Reese | At-will staff for Mayor [NAME] | 100
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Ponder, [NAME] | At-will staff for Mayor [NAME]
Reece, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner | 50
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME] | 85 | Yes, No Values Provided
[NAME], [NAME] | Director of Bureau of Police | 120
[NAME], [NAME] | At-will staff for Mayor [NAME]
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Wark, [NAME] | Design Commission Member
Yocom, [NAME] | At-will staff for Mayor [NAME] | 67.5
Spreadsheet: 258792d1376854846-adult-baseball-league-schedule-2013spring-schedule-5-
Sheet: notes

 |  | notes/changes
 |  | 1. week #5 May 5th game location redwings Home to CCC
 |  | 2. week #6 May 12th game location CCC x 2 games sch.  to redwings/mudcats at LBU
 |  | 3. week #10 June 9th CCC x 2 games sch. To baysox/keys to RH
 |  | 4. week #1 April 7th mudcats/baysox to LBU
 |  | 5. No games May 12th Mothers day..dates changes
1-Red Wings | LBU
2-Mud Cats | CCC
3-Sea Dogs | GHS
[NAME] | CCC
5-Bay Sox | RH
6-Senators | DP
7-Rock Cats | GHS
Spreadsheet: 33446d1229807886-help-with-bingo-spreadsheet-665610-bingo
Sheet: Sheet1

 | Numbers Called
 | 0 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | (Push for next number)
 | 8
 | 9
 |  | 6 | 8 | 2 | 9 | 4 | 5 | 3 | 1 | 7
 |  | 9 | 4 | 2 | 7 | 5 | 6 | 8 | 3 | 1
 |  | 7 | 8 | 3 | 5 | 1 | 9 | 4 | 2 | 6
 |  | 4 | 19 | 26 | 38 | 43 | 53 | 62 | 71 | 87
 |  | 6 | 11 | 23 | 31 | 46 | 51 | 68 | 75 | 88
 |  | 1 | 18 | 21 | 32 | 42 | 52 | 67 | 76 | 81
 |  | 9 | 14 | 25 | 37 | 41 | 55 | 63 | 73 | 82
 |  | 8 | 17 | 22 | 33 | 48 | 56 | 61 | 77 | 84
 |  | 2 | 16 | 29 | 35 | 49 | 59 | 66 | 79 | 83
 |  | 3 | 15 | 28 | 34 | 47 | 54 | 65 | 74 | 89
 |  | 7 | 12 | 27 | 39 | 44 | 57 | 64 | 78 | 86
 |  | 5 | 13 | 24 | 36 | 45 | 58 | 69 | 72 | 85
 |  | My Housie
 |  |  |  | 21 |  | 42 | 51 | 62 | 71
 |  |  | 14 | 23 |  | 42 |  |  | 75 | 82
 |  |  |  | 25 | 37 | 48 |  | 67 | 77
 |  |  |  | 0 |  | 0 | 0 | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  | 0
Spreadsheet: 845136d1696662515-filter-by-column-and-by-row-competence-matrix-filter
Sheet: Sheet1

Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  |  |  |  |  | Marian
George |  | X |  |  |  |  | Tamplar | X
Alina | X |  |  | C |  |  | Macelar | C
Radu |  | X |  |  |  |  | [NAME]
Cristian |  | X | C |  |  |  | Mecanic
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  |  |  |  |  | Marian
George | C | X |  |  |  |  | Tamplar | X |  |  | George
Alina | X |  |  | C |  |  | Macelar | C |  |  | Alina
Radu | X | X |  |  |  |  | [NAME] |  |  |  | Radu
Cristian |  | X | C |  |  |  | Mecanic
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  |  |  |  |  | George
George | C | X | C |  |  |  | Tamplar | X |  |  | Radu
Alina | X |  |  | C |  |  | Macelar | C
Radu | X | X | X |  |  |  | [NAME]
Cristian |  | X | C |  |  |  | Mecanic
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  | Marian | X |  |  | Mecanic
George | C | X | C |  |  |  | George | C
Alina | X |  |  | C |  |  | Alina
Radu | X | X | X |  |  |  | Radu
Cristian |  | X | C |  |  |  | Cristian
Spreadsheet: 881285d1729304743-change-cell-colors-based-on-a-range-of-values-boss429cj-book1
Sheet: DATA

 |  |  | Is there a way to color code the numbers in Column B to turn colors based on what their value is in relation to Columns I, J, K, and L?
 |  |  |  |  |  |  |  | [NAME] (number is high end)
 |  |  | LOGIC
 | Number |  |  |  |  |  |  | RED | ORANGE | YELLOW | GREEN
 | 26.28070175438597 |  | If [NAME] is between 56 and 62, RED.  Between 63 and 69, ORANGE.  And so on |  |  |  |  | 56
 | 19.45454545454546 |  |  |  |  |  |  | 63
 | -31.31707317073171 |  |  |  |  |  |  | 63
 | 195.7738095238095 |  |  |  |  |  |  | 77
 | 397.0098870056497 |  |  |  |  |  |  | 77
 | 259.8378378378378 |  |  |  |  |  |  | 56
 | 140.3630136986301 |  |  |  |  |  |  | 77
 | 516.3972602739726 |  |  |  |  |  |  | 56
 | 229.5418994413408 |  |  |  |  |  |  | 77
 | 693.5185185185186 |  |  |  |  |  |  | 35
 | 253.8627450980392 |  |  |  |  |  |  | 77
 | 18960.4 |  |  |  |  |  |  | 77
 | 180.2105263157895 |  |  |  |  |  |  | 77
 | 689.5555555555555 |  |  |  |  |  |  | 77
 | 606.3333333333334 |  |  |  |  |  |  | 77
 | 2326.763636363637 |  |  |  |  |  |  | 56
 | 1972.690909090909 |  |  |  |  |  |  | 56
 | 56 |  |  |  |  |  |  | 56
 | 57 |  |  |  |  |  |  | 56
 | 63 |  |  |  |  |  |  | 56
 | 64 |  |  |  |  |  |  | 56
 | 70 |  |  |  |  |  |  | 56
 | 71 |  |  |  |  |  |  | 56
 | 72 |  |  |  |  |  |  | 56
Spreadsheet: 109110d1306025321-mirroring-a-single-table-across-worksheets-5-3-1
Sheet: Week 3

[NAME] 5/3/1 |  |  |  |  |  |  | Weight | Reps <12 | 1RM | 5RM | 90% 1RM
Linear Pre-Periodization |  |  |  |  |  | OHP | 100 | 5 | 112.5112511251125 | 100 | 100
 |  |  |  |  |  | Deadlift | 360 | 3 | 381.1944091486658 | 338.8055908513342 | 345
 |  |  |  |  |  | Bench | 95 | 3 | 100.5929690808979 | 89.40703091910207 | 90
 |  |  |  |  |  | Squat | 260 | 3 | 275.3070732740364 | 244.6929267259636 | 250
 |  |  |  |  |  | Set Interval | 0.125 | Generally 10-15%
Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight
Friday | Bench | 5 | 40 |  | Sunday | Squat | 5 | 110 |  | [NAME] | Overhead Press | 5 | 45
 |  | 5 | 50 |  |  |  | 5 | 130 |  |  |  | 5 | 55
 |  | 3 | 55 |  |  |  | 3 | 155 |  |  |  | 3 | 65
 |  | 3 | 65 |  |  |  | 3 | 175 |  |  |  | 5 | 75
 |  | 3 | 70 |  |  |  | 3 | 200 |  |  |  | 3 | 85
 |  | 3+ | 80 |  |  |  | 3+ | 225 |  |  |  | 1 | 95
 | Pullups | 15 | BW |  |  | [NAME] | 15 | 290 |  |  | Pullups | 15 | BW
 |  | 11 | BW |  |  |  | 15 | 290 |  |  |  | 12 | BW
 |  | 10 | BW |  |  |  | 15 | 290 |  |  |  | 11 | BW
 |  | 9 | BW |  |  |  | 15 | 290 |  |  |  | 9 | BW
 |  | 8 | BW |  |  |  | 15 | 290 |  |  |  | 8 | BW
 | Skulls | 12 | 0 |  |  | Hanging Leg Raise/Decline Situps | 10 | BW |  |  | [NAME] | 15 | BW
 |  | 12 | 0 |  |  |  | 10 | BW |  |  |  | 15 | BW
 |  | 12 | 0 |  |  |  | 10 | BW |  |  |  | 15 | BW
 |  | 12 | 0 |  |  |  | 10 | BW |  |  |  | 15 | BW
 |  | 12 | 0 |  |  |  | 10 | BW |  |  |  | 15 | BW
Tonnage:
Core Exercise Tonnage |  | Mon | 1020 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Wed | 24540 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Fri | 1420 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Weekly | 26980 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Tonnage w/[NAME] |  | Mon | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Wed | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Fri | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Weekly | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 25353d1216648817-linking-and-formating-with-macro-ver-banki-lur-eldh-s
Sheet: Reikningur

 |  |  | Ölur.ehf Verðbanki
 |  | Útboðsnúmer: | X |  |  | [NAME] nr. | 1
 |  | Verktaki: | Ölur |  |  | Dags. | Í Dag
 |  | Kennitala:
 | Innrétting | Heiti | Fjöldi | Samtals | Alls greitt | [NAME] greitt | Til greiðslu nú
 |  |  |  |  | 0.33
 |  | Samtals
 |  |  |  |  |  | Til greiðslu nú
Spreadsheet: daren_farmer__5911__hpl0607
Sheet: Sheet1

HPLN0607.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 07, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-07 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
Enron (FM) |  | HPL - Texoma |  | HPL | 20 | 20
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 0 | 5
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Delhi TOG #3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher