tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 213645d1360601887-simple-copy-of-named-range-to-another-sheet-testnamedrange
Sheet: CustomList2

Custom List 2
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
More products
>>Insert DiskTable (named range) here for reference on this page
Spreadsheet: 752762d1634930953-lookup-based-on-multiple-criteria-and-range-it-retainer-request_sample2
Sheet: Log

# | Date Submitted | Role | Start Date | End Date | Estimated Hours per Month (per resource) | Work Order Number | Resource Name | [NAME] | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
16 | 2021-10-18 14:25:00 | PMO Advisor | 2021-09-07 00:00:00 | 2022-03-31 00:00:00 | 40 | 3 | [NAME] | 162 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 2021-10-18 14:25:00 | Project Support | 2021-09-07 00:00:00 | 2022-03-31 00:00:00 | 40 | 3 | [NAME] | 135 | 0 | 0
13 | 2021-10-18 13:36:00 | Optime ID/PT | 2021-07-26 00:00:00 | 2022-01-28 00:00:00 | 173 | 2 | Lekan | 121.5
12 | 2021-10-18 13:28:00 | Project Support | 2021-07-12 00:00:00 | 2021-08-27 00:00:00 | 15 | 1 | [NAME] | 135
11 | 2021-10-18 13:28:00 | PMO Advisor | 2021-07-12 00:00:00 | 2021-08-27 00:00:00 | 40 | 1 | [NAME] | 162 |  |  | 0
Spreadsheet: b965acc4-bed5-4a9f-ac0a-45d675733e9d
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0004888 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Silk Hope Elementary School | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 2600
Daily Limit:
Sample Frequency: |  |  | Monthly
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: phillip_allen__28789__interview
Sheet: Exercises

Question 1:
Estimate the market price of power for each of three pricing periods and briefly justify your answer
using the facts below:
 | Supply:
 |  | Fuel Type | Capacity | Variable Cost
 |  | Wind | 500 MW | $2/MW
 |  | Coal | 500 MW | $8/MW
 |  | Gas | 500 MW | $25/MW
 |  | New Plant | Unlimited | $50/MW
 | Demand
 |  | Period | Usage(aMW)
 |  | 1 | 400
 |  | 2 | 750
 |  | 3 | 1250
Question 2:
Use the data on the three worksheets named Plant A,B,C to answer the questions below as fast as possible.
1.  What was the total amount of gas consumed in 1999 by Plants A,B, and C?
2.  How much gas did Plant A consume in 1999?
3.  How much gas did Plant B consume in June 1999?
4.  How much gas did Plant C consume in each quarter of 1999?
5.  What was the average daily consumption of Plants A, B, and C in 1999?
6.  What was the average daily consumption of Plant A in May 1999?
7.  What was the average daily consumption of Plant B in December 1999?
8.  What was the average daily consumption of Plant B in the 2nd quarter of 1999?
9.  What was the minimum consumption of Plant C in June 1999?
10.  What was the maximum consumption of Plant A in January 1999?
Spreadsheet: 751943d1634468163-index-match-return-nth-item-if-criteria-met-fifo-stock-valuation-pricing-inventory
Sheet: Sales

 | Date | Item | Qty | Cost | Balance Stock | Value of Balance Stock
 | 2021-08-28 00:00:00 | [NAME] 2.5kg | 17 |  | 18 | 4370
 | 2021-09-01 00:00:00 | [NAME] 2.5kg | 6 |  | 12
 | 2021-09-03 00:00:00 | [NAME] 2.5kg | 2
 | 2021-09-04 00:00:00 | [NAME] 400g | 8
 | 2021-09-05 00:00:00 | [NAME] 2.5kg | 1
 | 2021-09-07 00:00:00 | [NAME] 400g | 3
 | 2021-09-07 00:00:00 | [NAME] 400g | 4
 | 2021-09-09 00:00:00 | [NAME] 400g | 2
 | 2021-09-09 00:00:00 | [NAME] 400g | 1
 | 2021-09-11 00:00:00 | [NAME] 400g | 1
 | 2021-09-12 00:00:00 | [NAME] 400g | 1
 | 2021-09-13 00:00:00 | [NAME] 400g | 2
 | 2021-09-14 00:00:00 | [NAME] 2.5kg | 2
 | 2021-09-14 00:00:00 | [NAME] 400g | 2
 | 2021-09-17 00:00:00 | [NAME] 400g | 1
 | 2021-09-30 00:00:00 | [NAME] 2.5kg | 5
Spreadsheet: 796322d1663224605-calculate-receipe-bom-cost-receipe-bom-cost
Sheet: Sheet1

 |  |  | RECEIPE BOM
 |  |  | S.No | [NAME] | [NAME] | Receipe BOM Cost | formula description | Remark | Required with excel function
 |  |  | 1 | A | GT1 |  | a=sum(b:d) | gross value of receipe bom | calculate receipe cost by excel function using as key as "S.No & Receipe Name" column data
 |  |  | 1 | B | GT1 | 41.67 | b
 | serial no |  | 2 | C | GT1 | 1.25 | c
 | represents |  | 3 | D | GT1 |  | d=(e+h)
 | main receipe |  | 3.1 | E | GT1 |  | e=sum(f:g)
 | category |  | 3.1.1 | F | GT1 | 43.16 | f
 | and |  | 3.1.2 | G | GT1 | 44.64 | g
 | and their sub-category |  | 3.2 | H | GT1 | 8.14 | h
 |  |  | 2 | I | GT2 |  | a=sum(b:d) | gross value of receipe bom
 |  |  | 1 | J | GT2 | 30.76 | b
 |  |  | 2 | K | GT2 | 16.28 | c
 |  |  | 3 | L | GT2 |  | d=(e+g)
 |  |  | 3.1 | A | GT2 |  | e=sum(f:f)
 |  |  | 3.1.1 | B | GT2 | 53.76 | f
 |  |  | 3.2 | C | GT2 | 5.82 | g
 |  |  | 3 | H | GT3 |  | a=sum(b:f) | gross value of receipe bom
 |  |  | 1 | G | GT3 | 26.83 | b
 |  |  | 2 | M | GT3 | 53.81 | c
 |  |  | 3 | D | GT3 | 11.83 | d
 |  |  | 4 | E | GT3 | 0.31 | e
 |  |  | 5 | A | GT3 | 80.95 | f
Spreadsheet: daren_farmer__5363__EnronHaynes21071400
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  | Phone: | (713) 853-6357
From:  [NAME]([NAME]) |  |  |  |  | FAX: | (713) 646-2391
Date:  7/6/00 |  |  |  |  | E-Mail: | [EMAIL]
Subject:  Nomination Change Effective July 14th
Effective Date | CTP NAME | PIPELINE | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d)
2000-07-14 00:00:00 | HAYNES 21 | TEJAS | 1 | 0
Spreadsheet: 44672d1243442145-linking-drop-down-boxes-mock-up-1-
Sheet: SUBSTRUCTURE

MATERIAL |  |  |  |  | QUANTITY | UNIT | EE/UNIT (kgCO2) | EE (kgCO2) | Data Source
Concrete | TYPE | MIX | ADDITIONAL MATERIAL
 |  |  |  |  |  | [NAME] | 16.5 | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | 1 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
1 Cement: 2 Sand: 4 Aggregate |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 148315d1333353286-vlookup-return-multiple-values-into-separate-cells-example3
Sheet: Sheet2

products_id | categories_id
21527 | 57
21527 | 144
21528 | 144
21529 | 144
21530 | 57
21530 | 144
21531 | 144
21532 | 144
21533 | 57
21533 | 144
21534 | 144
21535 | 57
21535 | 144
21536 | 144
21537 | 57
21537 | 144
21538 | 144
21539 | 144
21540 | 144
21541 | 49
21541 | 207
21542 | 207
example of result we'd like to achieve:
those in yellow illustrate which product ids have multiple categories. We'd like each of the categories to be in separate cells on the same row.
it's unimportant where the results are located. Another sheet is fine or bottom of any sheet.
products_id | products_model | categories id | categories id | categories id | categories id | categories id
21527 | 5810 | 57 | 144
21528 | 144 | 5810
Spreadsheet: 162735d1340042083-help-with-formatting-to-calculate-irr-irr-calculation-sample
Sheet: Sheet1

Year | Outflow | Cash Value Cum
0 | -12525 | 3264
1 | -12525 | 6620 | I want this to calculate as CF at yr 0 -12,525, CF yr 1 is -12,525, inflow at yr 2 +6,620
2 | -12525 | 19068
3 | -12525 | 32110
4 | -12525 | 44745
5 | -12525 | 57971
6 | -12525 | 71790
7 | -12525 | 85201
8 | -12525 | 99209
9 | -12525 | 113815
10 | -12525 | 128514
11 | -12525 | 143303
12 | -12525 | 158175
13 | -12525 | 173125
14 | -12525 | 188653
15 | -12525 | 204225
16 | -12525 | 220388
17 | -12525 | 236647
18 | -12525 | 253000
19 | -12525 | 269452
20 | -12525 | 285992
21 | -12525 | 303115
22 | -12525 | 319793
23 | -12525 | 337025
24 | -12525 | 353815
25 | -12525 | 370659
26 | -12525 | 387054
27 | -12525 | 403984
28 | -12525 | 420429
29 | -12525 | 436369
30 | -12525 | 452295
31 | -12525 | 467688
32 | -12525 | 483054
33 | -12525 | 497392
34 | -12525 | 511690
Spreadsheet: 884567d1733802990-if-and-between-two-times-example
Sheet: Sheet1

Date | Start | Finish | Item | Qty of TCs | Qty of Vehicles | TGS | Notes / Location | Total Hours Worked | - 30min Meal Break
2024-10-07 00:00:00 | 18:00:00 | 05:30:00 |  | 2 |  |  |  |  |  | POST
2024-10-20 00:00:00 | 18:00:00 | 05:30:00 |  | 2 |  |  |  |  |  | POST
2024-10-20 00:00:00 | 18:00:00 | 05:00:00 |  | 6 | 6 |  |  |  |  | POST
2024-10-20 00:00:00 | 18:00:00 | 05:00:00 |  | 1 | 1 |  |  |  |  | POST
2024-10-21 00:00:00 | 06:00:00 | 17:30:00 |  | 1 | 4 |  |  |  |  | DAY
2024-10-21 00:00:00 | 04:30:00 | 17:30:00 |  | 2 |  |  |  |  |  | PRE
Spreadsheet: 744400d1629218522-spill-error-using-filter-function-test_file
Sheet: Sheet1

KeycodeImported | NAME1B | NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | NAME10 | NAME11 | NAME12 | NAME13 | COMPANY | [NAME] | ADD2 | CITY | PROV | PC | PROD_code | SKU | PIECE_NO | PROD_NAME | COUNTRY | UniqueCode | PrintSeqPS | PrintSeqInd | GiftNo | NAME1A | KEYCODE_NAME |  | [NAME] | NM1_G2 | [NAME] | [NAME] | NM1_G5 | [NAME] | NM2_G1 | NM2_G2 | NM2_G3 | NM2_G4 | NM2_G5 | NM2_G6 | NM3_G1 | NM3_G2 | [NAME] | NM3_G4 | NM3_G5 | NM3_G6 | NM4_G1 | NM4_G2 | NM4_G3 | NM4_G4 | NM4_G5 | NM4_G6 | NM5_G1 | NM5_G2 | NM5_G3 | NM5_G4 | NM5_G5 | NM5_G6 | NM6_G1 | NM6_G2 | NM6_G3 | NM6_G4 | NM6_G5 | NM6_G6
M23740-1-001 | CORMIER ANNIE | CORMIER ANNIE |  |  |  |  |  |  |  |  |  |  |  |  | SHOPPERS DRUG MART#0181 | 477 PAUL ST |  | DIEPPE | NB | E1A 4X5 | [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | 3606000513990 | P02 | ILLUMINATING BANANA LOOSE SETTING POWDER | CA | E1A 4X5SHOPPERS DRUG MART#0181477 PAUL ST | 001 | 1 | P02 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-1-001CORMIER ANNIE
M23740-1-002 | FORTIN [NAME] | FORTIN [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | PHCIE J.COUTU #116 | 10459 BOUL SAINTE-ANNE |  | SAINTE-ANNE-DE-BEAUPRE | QC | G0A 3C0 | [PHONE] • TOLERIANE ULTRA 8 | 3337875617758 | P08 | TOLERIANE ULTRA 8 | CA | G0A 3C0PHCIE J.COUTU #11610459 BOUL SAINTE-ANNE | 002 | 2 | P08 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-1-002FORTIN DAPHNEE
M23740-1-003 | BERUBE MELODIE | BERUBE MELODIE |  |  |  |  |  |  |  |  |  |  |  |  | FAMILIPRIX #1091 | 825 RUE COMMERCIALE N LOCAL 104 |  | TEMISCOUATA-SUR-LE-LAC | QC | G0L 1E0 | M9117000 • CICAPLAST BAUME B5 40ML | M9117000 | P13 | CICAPLAST BAUME B5 40ML | CA | G0L 1E0FAMILIPRIX #1091825 RUE COMMERCIALE N LOCAL 104 | 003 | 3 | P13 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-1-003BERUBE MELODIE
M23740-5-176 | [NAME] | [NAME] | INGRAM KAYLIE |  |  |  |  |  |  |  |  |  |  |  | LONDON DRUGS #36 | 2-650 TERMINAL AVE |  | NANAIMO | BC | V9R 5E2 | M9155001 • IDEAL SOLEIL SPF 60 SPORT | M9155001 | P04 | IDEAL SOLEIL SPF 60 SPORT | CA | V9R 5E2LONDON DRUGS #362-650 TERMINAL AVE | 176 | 331 | P04 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-5-176FLANNIGAN STEPHANIE |  |  |  |  |  |  |  |  | P07 | P15
Spreadsheet: 160942d1339330182-separating-home-and-away-results-from-an-overall-set-of-results-copy-of-09_10_results_epl_edit
Sheet: Sheet2

HomeTeam | Home Goals | Away Goals | Total Goals
Chelsea
Man United
Arsenal
Liverpool
Man City
Tottenham
Everton
Sunderland
West Ham
[NAME]
[NAME]
Fulham
[NAME]
Burnley
Portsmouth
Stoke
Hull
Birmingham
[NAME]
Wolves
Spreadsheet: 788591d1658564061-text-doesnt-wrap-up-as-intended-in-the-cells-containing-copied-formula-formula-formatting-problem-1-
Sheet: Sheet1

Age | Prescribed medicine | Theoretical dose | Prescribed dose | Correct dose | Under-dosed | Over-dosed
66 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
70 | Dabigatran 150mg cap
87 | Dabigatran 150mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
69 | Dabigatran 150mg cap
70 | Dabigatran 150mg cap
71 | Dabigatran 150mg cap
60
61
80
Spreadsheet: 33baf376-44c8-4f31-af39-1db46e8941f3
Sheet: Rankings - 2007

Player | Adjusted Rank | Adjusted Success rate (%) (90% CI) | Attempts
[NAME] | 1 | 80 (72-86) | 47
Lionel Beauxis | 2 | 78 (70-84) | 39
[NAME] | 3 | 77 (69-83) | 80
[NAME] | 4 | 76 (67-84) | 11
[NAME] | 5 | 76 (66-84) | 6
[NAME] | 6 | 76 (66-83) | 10
Felipe Contepomi | 7 | 75 (68-82) | 51
[NAME] | 8 | 75 (66-83) | 8
[NAME] | 9 | 75 (66-83) | 21
[NAME] | 10 | 75 (65-83) | 8
[NAME] | 11 | 75 (65-83) | 15
Stirling Mortlock | 12 | 75 (67-82) | 51
[NAME] | 13 | 74 (65-82) | 16
[NAME] | 14 | 74 (64-82) | 26
Pinto Cardoso Duarte | 15 | 73 (63-82) | 6
[NAME] | 16 | 73 (64-81) | 16
[NAME] | 17 | 73 (63-81) | 12
[NAME] | 18 | 73 (63-81) | 9
[NAME] | 19 | 73 (63-81) | 15
Nicky Little | 20 | 73 (63-81) | 23
[NAME] | 21 | 73 (62-81) | 13
[NAME] | 22 | 72 (64-80) | 63
Jean-Baptiste Elissalde | 23 | 72 (63-80) | 35
[NAME] | 24 | 72 (63-80) | 36
[NAME] | 25 | 72 (61-81) | 11
[NAME] | 26 | 72 (61-80) | 8
[NAME] | 27 | 72 (61-80) | 19
[NAME] | 28 | 71 (62-79) | 31
Toby Flood | 29 | 71 (60-80) | 9
[NAME] | 30 | 71 (61-79) | 16
[NAME] | 31 | 71 (62-78) | 51
[NAME] | 32 | 70 (61-78) | 34
[NAME] | 33 | 70 (60-78) | 15
[NAME] | 34 | 70 (59-79) | 17
[NAME] | 35 | 70 (61-78) | 62
Ionut Dimofte | 36 | 70 (58-79) | 5
[NAME] | 37 | 69 (58-78) | 5
[NAME] | 38 | 69 (58-77) | 22
[NAME] | 39 | 67 (56-76) | 14
[NAME] | 40 | 67 (56-76) | 15
Spreadsheet: 091ea983-6858-4e6c-b795-0ff88fbe695c
Sheet: Sheet1

[NAME] (2-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 119111d1314201984-prorated-payment-help-prorated-payment-help
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
 | Monthly Price | Price | Coverage Period From | Coverage Period To | Number of Months | 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 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | Total | Check to Match TCV
Scenario 1 | 29.5 |  | 2011-09-01 00:00:00 | 2014-07-31 00:00:00 |  | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5
Scenario 2 | 29.5 |  | 2012-10-15 00:00:00 | 2014-07-31 00:00:00 |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |  | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5
Scenario3 | 29.5 |  | 2011-09-01 00:00:00 | 2012-02-13 00:00:00 |  | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Scenario 2 | 29.5 |  | 2012-02-14 00:00:00 | 2014-07-31 00:00:00 |  | NA | NA | NA | NA | NA |  | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5
Scenario 4 | 29.5 |  | 2011-09-13 00:00:00 | 2012-07-19 00:00:00 |  |  | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 | 29.5 |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Scenario 1 | 45 |  | 2011-09-01 00:00:00 | 2014-07-31 00:00:00
Scenario 2 | 45 |  | 2012-10-15 00:00:00 | 2014-07-31 00:00:00
Scenario3 | 45 |  | 2011-09-01 00:00:00 | 2012-02-13 00:00:00
Scenario 2 | 45 |  | 2012-02-14 00:00:00 | 2014-07-31 00:00:00
Scenario 4 | 45 |  | 2011-09-13 00:00:00 | 2012-07-19 00:00:00
Spreadsheet: 145017d1331259256-bar-chart-one-data-element-not-in-line-with-the-others-sample
Sheet: February 2012 Chart

OCR Bed Loss February 2012 by Division, By Reason
[NAME] | Northeast | Mideast | Central | Southeast | West | Total
Closed | 21 | 0 | 283 | 14 | 49 | 367
Collections | 0 | 367 | 464 | 29 | 0 | 860
JV | 730 | 254 | 0 | 0 | 356 | 1340
Other | 120 | 6 | 0 | 214 | 293 | 633
Per Diem | 0 | 0 | 0 | 0 | 98 | 98
Pricing | 12764 | 0 | 0 | 0 | 6 | 12770
Service | 2167 | 563 | 75 | 50 | 130 | 2985
Sold/Under New Mgt. | 0 | 0 | 191 | 4 | 0 | 195
Total | 15802 | 1190 | 1013 | 311 | 932 | 19248
Spreadsheet: 3437d7f5-f5c4-48c1-9c6d-b2824544dee3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Palo Alto LEED  for Neighborhood Development (LEED-ND) Pilot Program
Projects covered by the PA LEED-ND Pilot Program: All projects seeking a planning entitlement with parcel size [NAME] [NAME] (except single family homes unless part of a planned community) and/or projects that include three or more dwelling units.
All covered projects must show how they could comply with the [NAME]-ND Pilot Program. The [NAME]-ND Rating System was developed by the U.S. Green Building Council and integrates the principles of smart growth, urbanism and green building into the first national system for neighborhood design. The Green Building Certification Institute offers independent, third-party verification of the rating system, however it is not required for Palo Alto applicants.
For questions about the pilot program or assistance completing the checklist, contact [NAME], Sustainability Planner [EMAIL] or [PHONE]
Step | Instructions
Step 1 | Download and become familiar with the 2009 LEED for Neighborhood Development Rating System.
 | http://www.usgbc.org/DisplayPage.aspx?CMSPageID=148
Step 2 | Complete the Palo Alto LEED-ND Checklist found in this workbook on the green "PA [NAME]-ND Checklist" tab at the bottom. Note that the PA LEED-ND Checklist differs from the one available from the U.S. Green Building Council. Only the first two sections have been included. The third section, Green Infrastructure and Buildings, was not included in the Pilot due to the overlap with the City's Green Building Program.
Step 3 | Every applicant is required to show how all the [NAME]-ND prerequisites and at least 30 points could be claimed under the Smart Location and Linkage (SLL) and Neighborhood Pattern and Design (NPD) sections of LEED-ND. Projects retaining and rehabilitating an existing historic building(s) shall receive a 5 point credit towards the minimum 30 points required.
Step 4 | Only the yellow cells need to be completed on the "PA [NAME]-ND Checklist". For each prerequisite or credit the applicant must select either Option 1, 2 or 3.
Step 5 | All applicants should review the workbook blue tab "PA [NAME]-ND Checklist Sample" for the type and level of responses expected and required.
Step 6 | This workbook must be submitted to the applicants project planner prior to any board, commission or Council meeting.
Spreadsheet: 731867d1620651040-sumifs-problem-merged-cells-claims-recap-marie-1
Sheet: RECAP

CLAIMS PER CIE
 | Received
COMPANY | in EUR | in USD | Total equivalent in EUR
AIG
ALLIANZ
Aquilano
AXA
[NAME]
HELVETIA
[NAME]
NHC
RSA
Satec
Siat
STARSTONE
Swiss Re
CLAIMS PER VSL
 | Received
VSL | in EUR | in USD | Total equivalent in EUR
AAAAAAAAAAA
BBBBBBBBBBB
[NAME]
dddd
Spreadsheet: 267994d1380339916-need-to-pull-data-from-multiple-columns-only-if-value-in-column-a-attempt2
Sheet: JE-Sales (2)

WEEKLY SALES - JOURNAL ENTRIES |  |  |  | GL9SL_
WEEK ENDING |  | 90113 | Format is number - not date
DATE | [NAME] | [NAME] | ACCOUNT | AMOUNT |  |  | click C5 once and see formula bar you will see reference like $A$1:$B$77 in formula bar which is the current data filled in your cells in sheet Audit if that data increase then change it accordingly
 | 5 |  |  |  |  |  | after changing the same hold control and shift then hit enter and drag down
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
Spreadsheet: 104342d1301997811-excel-2008-solved-sum-of-values-in-a-column-based-on-values-in-a-different-column-book1_divingdata
Sheet: Sheet1

A | B | C | D | E | F |  | The number of each GEAR TYPE |  |  | Helper Columns |  |  | Data Validation List
[NAME] | 2800 | 700 | 34 | 37 | Hookah |  | Surf Supply | 2 |  | HookahAlyce | 1 |  | Hookah
Brett | 3000 | 700 | 35 | 35 | Open Circ |  |  |  |  | Open CircBrett | 1 |  | Open Circ
[NAME] | 3200 | 650 | 37 | 36 | Open Circ |  | The sum of the DIVE TIME |  |  | Open CircMike | 1 |  | Rebreather
Suzie | 2900 | 650 | 41 | 31 | Rebreather |  | Hookah | 139 |  | RebreatherSuzie | 1 |  | Surf Supply
[NAME] | 3000 | 700 | 42 | 40 | Surf Supply |  |  |  |  | Surf SupplyLaura | 1
[NAME] | 3000 | 800 | 45 | 31 | Rebreather |  | The number of divers using each GEAR TYPE |  |  | RebreatherMike | 1
[NAME] | 2900 | 550 | 47 | 33 | Surf Supply |  | Hookah | 4 |  | Surf SupplyDean | 1
[NAME] | 2000 | 800 | 48 | 13 | Open Circ |  |  |  |  | Open CircMike
[NAME] | 3000 | 800 | 48 | 31 | Open Circ |  | Basic Formula (by [NAME]) |  |  | Open CircMike
Nathan | 3100 | 600 | 48 | 34 | Open Circ |  | Hookah | 1 |  | Open CircNathan | 1
Nathan | 3100 | 600 | 48 | 34 | Hookah |  | Use Two Dynamic Names |  |  | HookahNathan | 1
Brett | 3100 | 600 | 48 | 34 | Hookah |  | Open Circ | 3 |  | HookahBrett | 1
Suzie | 3100 | 600 | 48 | 34 | Hookah |  |  |  |  | HookahSuzie | 1
 |  |  |  |  |  |  | Checks
 |  |  |  |  |  |  | Last Row in "Names" | 14
 |  |  |  |  |  |  | Last Row in "Gear" | 14
 |  |  |  |  |  |  | Unique values in Names Column | 7
 |  |  |  |  |  |  | Unique values in Gear Column | 4
 |  |  |  |  |  |  | Unique values in Helper Column | 11