tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266439d1379613535-importing-data-from-the-web-data-table
Sheet: database_dump

srno | sfin | fund_name | nav_date | nav_unit
1 | ULIF01203/09/10ACCELERATE0138 | ACCELERATOR FUND | 2013-09-18 00:00:00 | 9.5568
2 | [NAME] | BALANCED FUND | 2013-09-18 00:00:00 | 13.9248
3 | [NAME] | CONSERVATIVE FUND | 2013-09-18 00:00:00 | 13.9822
4 | [NAME] | DEBT FUND | 2013-09-18 00:00:00 | 16.2422
5 | ULIF00105/07/08EEF0138 | ENHANCED EQUITY FUND | 2013-09-18 00:00:00 | 13.7117
6 | [NAME] | GROUP DEBT FUND | 2013-09-18 00:00:00 | 10
7 | ULGF00228/03/11GEQUITY0138 | GROUP EQUITY FUND | 2013-09-18 00:00:00 | 10.6115
8 | [NAME] | DISCONTINUANCE POLICY FUND | 2013-09-18 00:00:00 | 12.2664
9 | [NAME] | NAV PROTECTOR FUND | 2013-09-18 00:00:00 | 11.7286
10 | ULIF00705/01/09PBALANCE0138 | PENSION BALANCED FUND | 2013-09-18 00:00:00 | 15.1075
11 | ULIF00805/01/09PDEBT0138 | PENSION DEBT FUND | 2013-09-18 00:00:00 | 13.1938
12 | ULIF00605/01/09PEEQUITY0138 | PENSION ENHANCED EQUITY FUND | 2013-09-18 00:00:00 | 21.8588
13 | [NAME] | PENSION INDEX FUND | 2013-09-18 00:00:00 | 21.6498
14 | ULIF00905/01/09PSECURE0138 | PENSION SECURE FUND | 2013-09-18 00:00:00 | 14.3482
15 | ULIF00505/07/08SF0138 | SECURE FUND | 2013-09-18 00:00:00 | 14.7631
16 | ULIF01303/09/10STABLE0138 | STABLE FUND | 2013-09-18 00:00:00 | 10.4379
Spreadsheet: 27051d1219853306-option-buttons-and-drop-down-list-form-control-dependentoptionbuttons
Sheet: Sheet1

 |  |  |  |  | City Dropdown Box
 | USA
 |  | USA | Canada
 |  | City 1 | City A
 |  | City 2 | City B
 |  | City 3 | City C
 |  | City 4 | City D
 |  | City 5 | City E
 |  | City 6 | City F
 |  | City 7 | City G
 |  | City 8
 |  | City 9
 |  | City 10
 |  |  |  |  |  | OptionButton1.Value
Spreadsheet: 881234d1729187744-ytd-and-rolling-12-month-calculations-across-multiple-worksheets-login-logout-test-copy
Sheet: YTD

 |  |  |  |  |  | Expected Result
Employee Name | YTD LATE | YTD LOGOUT | Rolling Late | Rolling Logout |  | Employee Name | YTD LATE | YTD LOGOUT | Rolling Late | Rolling Logout
 |  |  |  |  |  | N, Nelsor | 1 | 4
 |  |  |  |  |  | B, [NAME] | 73 | 1 | In this sample, rolling would be same due to only 4 months data.
 |  |  |  |  |  | C, [NAME] | 59 | 1
 |  |  |  |  |  | K, [NAME] | 37 | 1
 |  |  |  |  |  | M, Kayla | 8 | 8
 |  |  |  |  |  | N, Nelsor | 10 | 0
 |  |  |  |  |  | O, [NAME] | 7 | 14
 |  |  |  |  |  | S, [NAME] | 5 | 1
 |  |  |  |  |  | X, [NAME] | 5 | 0
 |  |  |  |  |  | Z, [NAME] | 4 | 2
Spreadsheet: 220867d1363285734-making-fully-automated-spreadsheet-big-excel-for-forum-help-updated
Sheet: Site Progress

 | TS = Trouble Shoot
 |  |  | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00 | 2013-04-12 00:00:00 | 2013-04-19 00:00:00 | 2013-04-26 00:00:00 | 2013-05-03 00:00:00
Site ID | PO | SOW | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete
 |  |  | 100
 |  |  | 90
 |  |  | 100
Spreadsheet: 876761d1723489211-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Sheet1

ASSEMBLY MARK NUMBER | SL.NO | BUILDING REF. | PRIORITY | LEVEL | ASSEMBLY NAME | QTY | GROSS WEIGHT | DELIVERY | ELECTION | REMARKS | Delivery Weight | Erection Weight
QLGF-C2001 | 1 | A | PRIORITY-1A | GF | COLUMN | 1 | 200.1 |  |  |  |  |  |  |  | Row Labels | Sum of QTY | Sum of GROSS WEIGHT | Count of Delivery Weight | Count of Erection Weight
QLGF-C2002 | 2 | A | PRIORITY-1A | GF | COLUMN | 2 | 512.6 |  |  |  |  |  |  |  | A
QLGF-C2002 | 3 | A | PRIORITY-1B | GF | COLUMN |  |  |  |  | Part assembly |  |  |  |  | PRIORITY-1A
QLGF-C2003 | 4 | A | PRIORITY-1B | GF | COLUMN | 1 | 205.6 |  |  |  |  |  |  |  | GF
QLGF-BM2003 | 5 | A | PRIORITY-1B | GF | FLOOR_BEAM | 1 | 181 |  |  |  |  |  |  |  | COLUMN | 3 | 712.7 | 2 | 2
QLGF-BM2004 | 6 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly |  |  |  |  | PRIORITY-1B
QLGF-BM2004 | 7 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly |  |  |  |  | GF
QLGF-BM2004 | 8 | A | PRIORITY-2A | GF | FLOOR_BEAM | 1 | 205.7 |  |  |  |  |  |  |  | COLUMN | 1 | 205.6 | 2 | 2
QLGF-HB2005 | 9 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 203.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 1 | 181 | 1 | 1
QLGF-HB2009 | 10 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 200.1 |  |  |  |  |  |  |  | PRIORITY-2A
QL-1-VB2001 | 11 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 906.1 |  |  |  |  |  |  |  | GF
QL-1-VB2002 | 12 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 1137.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 1 | 205.7 | 3 | 3
QL-1-BM2002 | 13 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM |  |  |  |  | Part assembly |  |  |  |  | HORIZONTAL BRACING | 2 | 403.7 | 2 | 2
QL-1-BM2002 | 14 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 673.6 |  |  |  |  |  |  |  | PRIORITY-2B
QL-1-BM2003 | 15 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 525 |  |  |  |  |  |  |  | LEVEL-1
QL-1-BM2004 | 16 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 483.6 |  |  |  |  |  |  |  | VERTICAL BRACING | 2 | 2043.7 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIORITY-2C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVEL-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR_BEAM | 3 | 1682.2 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 13 | 5434.6 | 16 | 16
Spreadsheet: 704368d1605525422-formula-to-find-the-non-zero-values-with-conditions-example1
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3 |  | [NAME] | Count
X | PL | 20 |  | PL | 5
X | PL | 0
X | MT | 20
X | MT | 30
Y | PL | 0
Y | MT | 0
Z | PL | 5
Z | MT | 5
B | PL | 2
B | MT | 2
A | PL | 20
A | MT | 20
Z | PL | 0
Z | MT | 0
Z | PL | 2
Z | MT | 2
D | PL | 0
D | MT | 0
D | PL | 30
D | MT | 30
Requirement is |  | [NAME] which is not equal to zero
 |  | [NAME] which is equal to PL
 |  | Criteria eliminate the duplicaes if the above two coniditions matched
Spreadsheet: 235678d1368564208-4-columns-two-are-dates-and-two-are-values-can-i-combine-these-4-into-2-example
Sheet: Sheet1

hamburger sales | Profit | hotdog sales | Profit |  | total sales | total profit
2013-01-01 00:00:00 | 1 | 2013-01-02 00:00:00 | 6 |  | 2013-01-01 00:00:00 | 1
2013-01-05 00:00:00 | 4 | 2013-01-05 00:00:00 | 3 |  | 2013-01-02 00:00:00 | 6
2013-01-06 00:00:00 | 2 | 2013-01-07 00:00:00 | 5 |  | 2013-01-05 00:00:00 | 4
 |  |  |  |  | 2013-01-05 00:00:00 | 3
 |  |  |  |  | 2013-01-06 00:00:00 | 2
 |  |  |  |  | 2013-01-07 00:00:00 | 5
Spreadsheet: 123582d1317741813-formula-for-small-theatre-seating-plan-copy-of-seating-plan-sample-1
Sheet: MONDAY

SEATING PLAN  MONDAY
 |  |  | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12
 |  | A |  |  |  |  |  |  | [NAME] |  |  |  |  |  | A
 |  |  | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8 | B9 | B10 | B11 | B12
 |  | B |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | B
 |  |  |  |  |  |  |  | AISLE
 | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 |  |  | C8 | C9 | C10 | C11 | C12 | C13 | C14 | C15
C | Mr [NAME] | [NAME] | Mr [NAME] | [NAME] | Mr [NAME] | [NAME] | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | C
 | D1 | D2 | D3 | D4 | D5 | D6 | D7 |  |  | D8 | D9 | D10 | D11 | D12 | D13 | D14 | D15
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 | E1 | E2 | E3 | E4 | E5 | E6 | E7 |  |  | E8 | E9 | E10 | E11 | E12 | [NAME] | E14 | E15
E |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 | F1 | F2 | F3 | F4 | F5 | F6 | F7 |  |  | F8 | F9 | [NAME] | F11 | F12 | F13 | F14 | F15
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | F
 | [NAME] | G2 | G3 | G4 | G5 | G6 | G7 |  |  | G8 | G9 | G10 | G11 | G12 | G13 | G14 | [NAME]
G |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | G
 | H1 | H2 | H3 | H4 | H5 | H6 | H7 |  |  | H8 | H9 | H10 | H11 | H12 | [NAME] | H14 | H15
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | J1 | J2 | J3 | J4 | J5 | J6 | J7 |  |  | J8 | J9 | J10 | J11 | J12 | J13 | J14 | J15
J |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | J
 | K1 | K2 | K3 | K4 | K5 | K6 | K7 |  |  | K8 | K9 | K10 | K11 | K12 | K13 | K14 | K15
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 |  |  | L8 | L9 | L10 | L11 | L12 | [NAME] | [NAME] | L15
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
Spreadsheet: a4db2e76-9f63-4ba0-9b8c-6da324b5a602
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 12/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.32 | 6.55 | 7.18 | 8.31 | 8.26 | 7.78 | 7.72
July | 7.89 | 6.93 | 7.76 | 6.85 | 8.67 | 8.17 | 8.39 | 7.29
August | 8.04 | 6.87 | 7.92 | 6.81 | 7.76 | 7.76 | 8.27 | 6.97
September | 8.27 | 6.8 | 8.25 | 6.79 | 7.77 | 7.9 | 8.38 | 6.71
October | 8.38 | 7 | 8.33 | 7.07 | 7.61 | 7.12 | 8.56 | 6.84
November | 8.47 | 6.8 | 8.38 | 6.73 | 8.11 | 7.3 | 8.65 | 6.84
December | 8.3 |  | 8.15 |  | 8.31 |  | 8.48
January | 8.12 |  | 8.01 |  | 8.24 |  | 8.34
February | 7.97 |  | 7.85 |  | 8.19 |  | 8.11
March | 7.79 |  | 7.63 |  | 8.12 |  | 7.95
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: [NAME]
Spreadsheet: 842246d1694364079-random-pick-a-cell-content-in-a-range-ignoring-all-blank-empty-cells-in-that-range-random-202309_wvw
Sheet: Trekken

Trek | N | O | Z | W |  | N | O | Z | W |  | Trek | N | O | Z | W |  | N | O | Z | W
1 | 52 | 51 | 50 | 49 |  |  |  |  |  |  | 1 | 52 | 51 | 50 | 49
2 | 48 | 47 | 46 | 45 |  |  |  |  |  |  | 2 | 45 | 48 | 47 | 46
3 | 44 | 43 | 42 | 41 |  |  |  |  |  |  | 3 | 42 | 41 | 44 | 43
4 | 40 | 39 | 38 | 37 |  |  |  |  |  |  | 4 | 39 | 38 | 37 | 40
5 | 36 | 35 | 34 | 33 |  |  |  |  |  |  | 5 | 36 | 35 | 34 | 33
6 | 32 | 31 | 30 | 29 |  |  |  |  |  |  | 6 | 29 | 32 | 31 | 30
7 | 28 | 27 | 26 | 25 |  |  |  |  |  |  | 7 | 26 | 25 | 28 | 27
8 | 24 | 23 | 22 | 21 |  |  |  |  |  |  | 8 | 23 | 22 | 21 | 24
9 | 20 | 19 | 18 | 17 |  |  |  |  |  |  | 9 | 20 | 19 | 18 | 17
10 | 16 | 15 | 14 | 13 |  |  |  |  |  |  | 10 | 13 | 16 | 15 | 14
11 | 12 | 11 | 10 | 9 |  |  |  |  |  |  | 11 | 10 | 9 | 12 | 11
12 | 8 | 7 | 6 | 5 |  |  |  |  |  |  | 12 | 7 | 6 | 5 | 8
13 | 4 | 3 | 2 | 1 |  |  |  |  |  |  | 13 | 4 | 3 | 1 | 2
 |  |  |  |  |  | N+Z: |  | O+W: |  |  |  |  |  |  |  |  | N+Z: |  | O+W:
Spreadsheet: 674101d1587660074-total-cost-based-on-a-value-that-falls-within-specific-value-updated-permit-costs-3-19-20-test
Sheet: Sheet1

Location
City 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Valuation: | 40000
 | Vaulation Range |  | Base Permit $ |  | Amount Each Additional $1000 | Additional $1000 | Additional $ | Base Permit Fee | Plan Review | State Surcharge | Permit Total w/o documents | Add additon Document charges $1/page | Permit Total
 | 1 | 25000 | 75 |  | 11.1 | 0
 | 25001 | 50000 | 330 |  | 8.45 | 0 | 0 |  |  |  |  | 0
 | 50001 | 100000 | 540 |  | 6.45 | 0 |  |  |  |  |  | 0
 | 100000 | 100000000 | 863 |  | 4.8 | 0 | 0 |  |  |  |  | 0
 |  |  |  | 15 | 8.45 |  |  | 330 | 115 | 39.6 |  | 10 |  |  | 456.75
City 2
 | Vaulation Range |  | Base Permit $ |  | Amount Each Additional $100 | Additional $100 | Additional $ | Base Permit Fee | Plan Review | State Surcharge | Permit Total
 | 1 | 2000 | 30 | (1st $2,000) | 0 | 0
 | 2001 | 5000 | 72.5 | (1st $2,000) | 2.3 | 0
 | 5001 | 10000 | 141.5 | (1st $5,000) | 1.8 | 0
 | 10001 | 50000 | 231.5 | (1st $10,000) | 1.35 | 0
 | 50001 | 100000 | 771.5 | (1st $50,000) | 1.25 | 0
 | 100001 | AND UP | 1396.5 | (1st $100,000) | 1.1 | 0 | 0
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: QUA

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
Spreadsheet: 219176d1362677792-make-a-list-from-items-not-checked-off-isolation-blinds-tracker
Sheet: 2900

BLIND List
February 2013 Refinery Shutdown
 |  | Total Blinds |  | 2900 Isolation Blinds
Common To | Date | Blind/ LOTO # | Tag # | Size | Rating | Service | Location | [NAME] | [NAME] | [NAME] | Needs Insulation Removed | Ready to Blind | Blinded
700 (#34) |  | 1 |  | 4” | spec | C4s | MTBE feed |  | Y | Y | N |  |  |  | % Hung
 |  | 2 |  | 2” | spec | Steam | Steam out line to T-2902 |  | N |  | N |  |  |  | % Needing Scaffold
 |  | 3 |  | 3” | spec | C4s | T2902 bottoms product to storage |  | Y | Y | N |  |  |  | % Scaffold Built
 |  | 4 |  | 1½” | 300# | Fuel gas | Fuel gas to D-2905 |  | N |  | N |  |  |  | % Needs Insulation Removed
700 (#35) |  | 5 |  | 4” | spec | C4s | Alky feed |  | Y | Y | N |  |  |  | % Ready to Blind
 |  | 6 |  | 2” | 300# | Fuel gas | Fuel gas to D-2907 flare line (29PV192B block valve) |  | N |  | N |  |  |  | % Blinded
 |  | 7 |  | 1½” | 300# | Fuel gas | Fuel gas to D-2907 flare line (29PV192B bypass valve) |  | N |  | N
Spreadsheet: 117399d1312784603-duplicate-generation-on-the-basis-of-date-datewise-duplicate-generation
Sheet: Sheet1

 | Date | Month | Company | Unique company
 | 2011-08-01 00:00:00 | August | AA | AA |  |  | I am entering unique company name by filtering date and company  one by one and. So, I have to do manuall work munch
 | 2011-08-01 00:00:00 | August | AA |  |  |  | I am in need of formula which can generate unique company name in column No "E"
 | 2011-08-01 00:00:00 | August | AA |  |  |  | Eg
 | 2011-08-01 00:00:00 | August | AA |  |  |  | date | month | company | qnique company
 | 2011-08-01 00:00:00 | August | BB | BB |  | 1st-aug | 2011-08-01 00:00:00 | Aug | AA | AA | uniquness should be on datewise.
 | 2011-08-01 00:00:00 | August | BB |  |  |  | 2011-08-01 00:00:00 | Aug | AA
 | 2011-08-01 00:00:00 | August | BB |  |  |  | 2011-08-01 00:00:00 | Aug | BB | BB
 | 2011-08-01 00:00:00 | August | BB |  |  | 2nd-aug | 2011-08-02 00:00:00 | Aug | BB
 | 2011-08-01 00:00:00 | August | CC | CC |  |  | 2011-08-02 00:00:00 | Aug | CC | CC
 | 2011-08-01 00:00:00 | August | CC |  |  |  | 2011-08-02 00:00:00 | Aug | BB | BB
 | 2011-08-01 00:00:00 | August | CC |  |  |  | 2011-08-02 00:00:00 | Aug | AA | AA
 | 2011-08-01 00:00:00 | August | DD | DD |  | 3rd-aug | 2011-08-03 00:00:00 | Aug | AA | AA
 | 2011-08-01 00:00:00 | August | DD |  |  |  | 2011-08-03 00:00:00 | Aug | BB | BB
 | 2011-08-01 00:00:00 | August | DD |  |  |  | 2011-08-03 00:00:00 | Aug | BB
 | 2011-08-01 00:00:00 | August | DD |  |  | 4th aug | 2011-08-04 00:00:00 | Aug | CC | CC
 | 2011-08-01 00:00:00 | August | DD |  |  |  | 2011-08-04 00:00:00 | Aug | CC
 | 2011-08-01 00:00:00 | August | DD |  |  |  | 2011-08-04 00:00:00 | Aug | BB | BB
 | 2011-08-02 00:00:00 | August | XX | XX
 | 2011-08-02 00:00:00 | August | XX
 | 2011-08-02 00:00:00 | August | XX
 | 2011-08-02 00:00:00 | August | XX
 | 2011-08-02 00:00:00 | August | XX
 | 2011-08-02 00:00:00 | August | YY | YY
 | 2011-08-03 00:00:00 | August | AA | AA
 | 2011-08-03 00:00:00 | August | AA
 | 2011-08-03 00:00:00 | August | AA
 | 2011-08-03 00:00:00 | August | BB | BB
 | 2011-08-03 00:00:00 | August | BB
 | 2011-08-03 00:00:00 | August | BB
Spreadsheet: 787847d1658086931-formula-to-sum-values-of-variables-based-on-similarity-t
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  | Names 1 | 35 |  |  | Names 1 | 50 | 1
 | Names 1 |  |  |  |  |  |  |  |  | Names 2 | 40 |  |  | Names 2 | 0
 | Names 2 |  |  |  |  |  |  |  |  | Names 3 | 60 |  |  | Names 3 | 0
 | Names 3 |  |  |  |  |  |  |  |  | Names 4 | 76 |  |  | Names 4 | 50 | 1
 | Names 4
 | Names 5
 | Names 6 |  |  |  |  |  |  |  |  |  |  |  | I Have two ranges, K5:L8, Range 2, O5:Q8. I need to distribute the values of Both ranges on the Rang 3, B6:B15 based on the value od C (Q4) such that if the value of Q4 is 1, the name has the value 50 otherwis it takes its value from L5:L8
 | Names 7
 | Names 8
 | Names 9
 | Names 10
Spreadsheet: 153405d1335894127-vlookup-after-the-occurence-of-a-separate-lookup-value-test
Sheet: Sheet1

East Region |  |  | TRUCKS | 2
Cars | 9 |  | NORTH REGION
Trucks | 10
Boats | 9
West Region
Cars | 9
Trucks | 10
Boats | 8
NORTH REGION
Cars | 1
Trucks | 2
Boats | 3
Spreadsheet: 101149d1299274086-create-empty-cell-if-a-table-has-blank-cell-sample-sheet-emty-cell-prob
Sheet: Principal Worksheet

[NAME]
Table as I would like it:
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2005
2006
2007
2008
2009
2010
2011
Table When Using Simple   =Sheet2!B2 type formula
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2005
2006
2007
2008
2009
2010
2011
Spreadsheet: 96098d1295548511-formula-to-find-decreasing-value-in-column-b-scratch
Sheet: Sheet1

2 | 15
2 | 16
2 | 17
2 | 13 | Error
2 | 14 | Error
2 | 18
3 | 2
3 | 2
3 | 3
3 | 1 | Error
4 | 20
4 | 21
Spreadsheet: 176813d1346114822-averaging-results-of-sumif-average-occupancy
Sheet: Temp Team

29/7 - 4/8 |  |  | 5/8 - 11/8 |  |  |  | 12/8/ - 18/8 |  |  |  | 19/8 - 25/8
DA Name | Occupancy | Hours | DA Name | Occupancy | Hours | 2wk [NAME] | DA Name | Occupancy | Hours | 3wk [NAME] | DA Name | Occupancy | Hours | [NAME] | DA Name | Occupancy | Hours | [NAME] | DA Name | Occupancy | Hours | [NAME]
Agent 1 | 82 | 20:47:02 | Agent 1 | 71 | 1 day, 2:37:00 |  | Agent 7 | 72 | 21:29:07 |  | Agent 5 | 76 | 3:59:28
Agent 2 | 83 | 20:30:20 | Agent 5 | 72 | 09:26:38 |  | Agent 13 | 74 | 11:29:09 |  | Agent 7 | 79 | 15:59:55
Agent 3 | 85 | 1 day, 0:31:26 | Agent 9 | 79 | 22:08:47 |  | Agent 3 | 75 | 20:29:48 |  | Agent 3 | 79 | 08:12:45
Agent 4 | 88 | 08:28:37 | Agent 7 | 81 | 22:55:45 |  | Agent 9 | 77 | 20:30:26 |  | Agent 1 | 79 | 7:44:11
Agent 5 | 90 | 14:58:08 | Agent 3 | 82 | 14:56:13 |  | Agent 4 | 78 | 09:47:48 |  | Agent 2 | 79 | 12:12:52
Agent 6 | 90 | 20:08:30 | Agent 10 | 83 | 05:44:07 |  | Agent 1 | 80 | 11:39:53 |  | Agent 4 | 80 | 8:06:46
Agent 7 | 90 | 21:41:45 | Agent 6 | 83 | 08:10:25 |  | Agent 2 | 81 | 17:34:35 |  | Agent 8 | 80 | 16:02:50
Agent 8 | 91 | 16:38:07 | Agent 2 | 83 | 12:42:03 |  | Agent 8 | 83 | 15:33:48 |  | Agent 10 | 80 | 15:26:39
Agent 9 | 91 | 23:58:45 | Agent 11 | 84 | 05:18:08 |  | Agent 6 | 85 | 12:01:05 |  | Agent 11 | 81 | 12:07:10
Agent 10 | 91 | 1 day, 0:02:22 | Agent 8 | 84 | 09:53:09 |  | Agent 12 | 87 | 1 day, 9:41:25 |  | Agent 9 | 82 | 16:09:37
Agent 11 | 95 | 12:01:24 | Agent 4 | 90 | 10:30:10 |  | Agent 10 | 88 | 23:59:00 |  | Agent 13 | 84 | 08:03:48
Agent 12 | 97 | 1 day, 4:42:41 | Agent 12 | 93 | 17:29:31 |  | Agent 11 | 90 | 16:54:41 |  | Agent 12 | 87 | 12:12:41
 |  |  | Agent 13 | 97 | 04:31:21 |  |  |  |  |  | Agent 6 | 89 | 8:02:17
Spreadsheet: 205686d1357863964-rota-amalgamation-rota-test
Sheet: rota 1

 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] | 200 | 300 | 100 | 100 | 100 | 100 | 100
[NAME] | 201 | 301 | 101 | 101 | 101 | 101 | 101
[NAME] | 202 | 302 | 102 | 102 | 102 | 102 | 102
 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] | 210 | 310 | 110 | 110 | 110 | 110 | 110
[NAME] | 211 | 311 | 111 | 111 | 111 | 111 | 111
[NAME] | 212 | 312 | 112 | 112 | 112 | 112 | 112
Spreadsheet: 0dc20218-10d0-4859-bbb9-6278121cb5b9
Sheet: ST13

Supplementary Table 13 ([NAME] et al.) List of 32 peaks, including the number of human-specific sequence alterations
case_32_peaks
chr | start | stop | number of HSAs | region length | HSAs per 1kb | comments
1 | 145037805 | 145040692 | 14
1 | 147717686 | 147719570 | 0 |  |  | unclear alignment in database for this region
2 | 115419154 | 115420608 | 49
2 | 115917966 | 115921773 | 130
2 | 132794730 | 132796576 | 35
2 | 133013736 | 133016150 | 167
3 | 237096 | 242136 | 99
3 | 2139183 | 2142802 | 103
3 | 87137689 | 87139305 | 12
5 | 146762174 | 146763181 | 10
6 | 151814532 | 151816287 | 11
7 | 51538749 | 51540078 | 10
7 | 152621857 | 152623442 | 20
10 | 830317 | 831468 | 25
10 | 81741181 | 81742583 | 11
10 | 103328875 | 103331401 | 10
10 | 109673386 | 109675834 | 43
11 | 857725 | 860732 | 60
13 | 31626585 | 31631064 | 80
15 | 98195676 | 98196486 | 16
17 | 21475992 | 21477731 | 23
18 | 903447 | 909852 | 184
18 | 73627719 | 73628912 | 12
18 | 74798659 | 74800451 | 14
19 | 17558366 | 17559781 | 82
19 | 51016137 | 51018764 | 35
20 | 326779 | 329498 | 60
20 | 361305 | 363330 | 79
20 | 1782609 | 1784925 | 44
20 | 5484589 | 5485659 | 34
22 | 27040778 | 27045045 | 29
22 | 47549900 | 47551490 | 18
control_32_peaks
chr | start | stop | number of HSAs | region length | HSAs per 1kb
1 | 208411298 | 208419261 | 41 | 7963 | 5.148813261333668
1 | 220959355 | 220961158 | 12 | 1803 | 6.655574043261232
2 | 187558104 | 187561829 | 20 | 3725 | 5.369127516778524
2 | 241373608 | 241378678 | 27 | 5070 | 5.325443786982248
2 | 241755710 | 241761052 | 175 | 5342 | 32.75926619243729
3 | 32020502 | 32023746 | 24 | 3244 | 7.398273736128237
3 | 44625637 | 44627264 | 7 | 1627 | 4.30239704978488
5 | 31192968 | 31196073 | 15 | 3105 | 4.830917874396135
6 | 80654317 | 80657936 | 23 | 3619 | 6.355346780878696
6 | 124123287 | 124127760 | 22 | 4473 | 4.918399284596468
7 | 73497136 | 73499865 | 83 | 2729 | 30.41407108831074
7 | 145812246 | 145815852 | 18 | 3606 | 4.991680532445923
8 | 81784332 | 81787337 | 26 | 3005 | 8.6522462562396
8 | 120219832 | 120222373 | 18 | 2541 | 7.083825265643448
9 | 99379887 | 99382600 | 16 | 2713 | 5.897530409141172
9 | 129088281 | 129090814 | 22 | 2533 | 8.685353335965258
9 | 139919508 | 139924102 | 28 | 4594 | 6.09490639965172
10 | 118029902 | 118034459 | 40 | 4557 | 8.777704630239192
11 | 65814880 | 65817287 | 13 | 2407 | 5.40091400083091
12 | 121077435 | 121081338 | 17 | 3903 | 4.355623879067384
12 | 122791566 | 122794647 | 10 | 3081 | 3.245699448231094
13 | 51415999 | 51418615 | 5 | 2616 | 1.91131498470948
16 | 22824236 | 22829735 | 23 | 5499 | 4.182578650663757
16 | 62065313 | 62072007 | 40 | 6694 | 5.975500448162534
17 | 11143068 | 11149080 | 42 | 6012 | 6.986027944111776
17 | 79136301 | 79141078 | 54 | 4777 | 11.30416579443165
19 | 17796357 | 17799997 | 51 | 3640 | 14.01098901098901
19 | 19004066 | 19008094 | 37 | 4028 | 9.185700099304865
19 | 45753366 | 45756343 | 37 | 2977 | 12.42861941551898
20 | 44649941 | 44652083 | 32 | 2142 | 14.93930905695612
22 | 29871405 | 29878035 | 30 | 6630 | 4.524886877828054
X | 10126165 | 10129584 | 19 | 3419 | 5.557180462123428
Spreadsheet: joe_parks__14933__BridgeDPR0415
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1154.079510700002 | 1154.079510700002 | 6445.079510700001
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1154.079510700002 | 1154.079510700002 | 6445.079510700001
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778