tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41496d1239969570-formula-similar-to-vlookup-needed-program-1704
Sheet: Breakdown

Low Day
 |  | [NAME] | Weight (gm) Breakdown | Cal Per Meal (/6) | gm Per Meal
Carbs | 0.45 | 925.650576 | 231.412644 | 154.275096 | 38.568774
Protein | 0.35 | 719.9504479999999 | 179.987612 | 119.9917413333333 | 29.99793533333333
Fats | 0.2 | 411.400256 | 45.71113955555555 | 68.56670933333334 | 7.618523259259259
High Day
 |  | [NAME] | Weight (gm) Breakdown | Cal Per Meal (/6) | gm Per Meal
Carbs | 0.55 | 1414.18838 | 353.547095 | 235.6980633333334 | 58.92451583333334
Protein | 0.3 | 771.37548 | 192.84387 | 128.56258 | 32.140645
Fats | 0.15 | 385.68774 | 42.85419333333333 | 64.28129 | 7.142365555555555
Spreadsheet: 876147d1722834369-adding-grand-total-at-end-and-doing-sum-of-each-column-etax-hstack-with-grand-total-aligw
Sheet: RequiredOutput

 | Head 4 | Head 5 | Head 6 | Head 8
X | 725 | 188 | 583307.07 | 117
Y | 817165.55 | 294052 | 19538.3 | 484886.79
Grand Total | 817890.55 | 294240 | 602845.37 | 485003.79 | <This I require in formula
Spreadsheet: 744518d1629283626-highlight-date-range-on-calendar-399
Sheet: Hire

 |  |  |  |  |  |  |  | 399      HIRE
Hire_start |  |  |  | Hire_end |  |  |  |  |  | Cumulative Days
Hire Start Date | Machine Hours | Customer | Site | Hire End Date | Machine Hours | Hire Period Weeks | Total Hire Hours | Comments | Days | 0 |  | Hire_row | Hire_dates
2020-02-17 00:00:00 | 9712 | S | LL | 2020-04-18 00:00:00 | 10102
2020-05-08 00:00:00 | 10108 | S | LL | 2020-05-28 00:00:00
2020-05-01 00:00:00 |  | LN | LN |  | 10307
2020-06-10 00:00:00 | 10310 | LN | L | 2020-06-17 00:00:00 | 10326
2020-07-06 00:00:00 |  | LN | LN | 2020-07-10 00:00:00
2020-07-13 00:00:00 | 10331 | S | BR | 2020-08-07 00:00:00 | 10614
2020-09-21 00:00:00 | 10620 | HH | AY | 2020-09-23 00:00:00
2020-09-30 00:00:00 | 10630 | CS | WB | 2020-11-17 00:00:00 | 10817
2020-11-24 00:00:00 | 10817 | RL | PR | 2020-11-24 00:00:00 | 11085
2020-11-24 00:00:00 | 10820 | RL | PR | 2020-12-04 00:00:00
2020-12-08 00:00:00 | 10854 | TR | [NAME] | 2021-01-28 00:00:00
2021-03-25 00:00:00 | 11101 | TR | [NAME] | 2021-05-16 00:00:00
2021-05-17 00:00:00 | 11569 | S | LL | 2021-05-20 00:00:00
2021-05-21 00:00:00 | 11592 | S | KN | 2021-08-16 00:00:00
Spreadsheet: 162267d1339780024-excel-2007-sum-between-two-date-with-respect-to-specific-customer-example-book
Sheet: Sheet1

sales register
sr. no | date | invoice no | customer name | amount
1 | 2012-01-01 00:00:00 | INV-001 | abc ltd | 5540
2 | 2012-01-01 00:00:00 | INV-002 | xyz corp | 1245
3 | 2012-01-02 00:00:00 | INV-003 | QP Ltd | 25488
4 | 2012-01-03 00:00:00 | INV-004 | RSS Ltd | 6481
5 | 2012-01-05 00:00:00 | INV-005 | DOL Cunsultant | 12488
6 | 2012-01-10 00:00:00 | INV-006 | RJ Pharmacy | 12488
7 | 2012-01-15 00:00:00 | INV-007 | abc ltd | 1145
8 | 2012-01-16 00:00:00 | INV-008 | xyz corp | 1125
9 | 2012-01-20 00:00:00 | INV-009 | RSS Ltd | 2154
10 | 2012-01-25 00:00:00 | INV-010 | DOL Cunsultant | 11546
11 | 2012-02-01 00:00:00 | INV-011 | PAN home furniture | 1248
12 | 2012-02-02 00:00:00 | INV-012 | Royal restaurant | 2548
13 | 2012-02-05 00:00:00 | INV-013 | abc ltd | 2469
14 | 2012-02-08 00:00:00 | INV-014 | EliTe Group | 6985
15 | 2012-02-09 00:00:00 | INV-015 | PAN home furniture | 8794
16 | 2012-02-15 00:00:00 | INV-016 | xyz corp | 1541
17 | 2012-02-20 00:00:00 | INV-017 | RJ Pharmacy | 5481
18 | 2012-02-28 00:00:00 | INV-018 | DOL Cunsultant | 9521
19 | 2012-03-01 00:00:00 | INV-019 | xyz corp | 5849
20 | 2012-03-06 00:00:00 | INV-020 | PAN home furniture | 1245
21 | 2012-03-07 00:00:00 | INV-021 | Royal restaurant | 1258
22 | 2012-03-07 00:00:00 | INV-022 | RSS Ltd | 154
23 | 2012-03-15 00:00:00 | INV-023 | abc ltd | 5489
24 | 2012-03-18 00:00:00 | INV-024 | VK Group | 9568
25 | 2012-03-22 00:00:00 | INV-025 | PAN home furniture | 856
26 | 2012-03-23 00:00:00 | INV-026 | DOL Cunsultant | 785
27 | 2012-03-26 00:00:00 | INV-027 | Royal restaurant | 158
28 | 2012-04-04 00:00:00 | INV-028 | RK Readymade | 98
29 | 2012-04-04 00:00:00 | INV-029 | xyz corp | 6985
30 | 2012-04-08 00:00:00 | INV-030 | NAT Furnoture | 4589
31 | 2012-04-09 00:00:00 | INV-031 | VK Group | 448
32 | 2012-04-14 00:00:00 | INV-032 | DOL Cunsultant | 14588
33 | 2012-04-16 00:00:00 | INV-033 | VK Group | 5458
34 | 2012-04-19 00:00:00 | INV-034 | RK Readymade | 4656
35 | 2012-04-23 00:00:00 | INV-035 | RSS Ltd | 1546
36 | 2012-05-01 00:00:00 | INV-036 | NAT Furnoture | 15845
37 | 2012-05-06 00:00:00 | INV-037 | xyz corp | 125
38 | 2012-05-08 00:00:00 | INV-038 | DOL Cunsultant | 1249
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
Spreadsheet: 108673d1305689995-excel-2007-sumproduct-question-ptsumproduct
Sheet: JAN

Date | ID | Bought | Sold | % Sold
2011-01-01 00:00:00 | 8178541110001 | 90 | 48
2011-01-01 00:00:00 | 3531670110003 | 42 | 40
2011-01-01 00:00:00 | 7855760111824 | 75 | 32
2011-01-01 00:00:00 | 8262480013000 | 40 | 31
2011-01-01 00:00:00 | 8385850010003 | 39 | 25
2011-01-01 00:00:00 | 7199790210003 | 100 | 24
2011-01-01 00:00:00 | 7686200510003 | 101 | 24
2011-01-01 00:00:00 | 8263830010002 | 33 | 21
2011-01-01 00:00:00 | 8389450210000 | 31 | 17
Spreadsheet: 414f3413-e284-4747-994d-5eb861ad3e04
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Special Markets Product Rec | 80688739027 | [NAME] | Via Dolorosa: Anthems Of Redemption | 2008-02-12 | Compact Disc | Ac | 11.99 | Y | Available
Spreadsheet: 161029d1339372802-excel-2007-how-to-fix-sum-if-formula-mjc-registro-interactivo
Sheet: INFSR

 | [NAME] |  | SEGUNDO R |  |  |  | Masculino
 |  |  |  |  |  |  | Femenino
Asignatura: |  |  |  | Hora: |  |  | TOTAL
Número | 1er Apellido | 2do Apellido | Nombre | [NAME] | Género | [NAME] | Estatus |  | Masculino | Femenino
 |  |  |  |  | Masculino
 |  |  |  |  | Femenino
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
Spreadsheet: 1b60e0aa-7124-4fd7-b135-50ba6b03e1f4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 43. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (VIC), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413792J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413793K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413794L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413795R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413796T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413797V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413798W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413799X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413800W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413801X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413802A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 00b0044f-8179-4c0d-89ef-814341777076
Sheet: Feb 2013

Monthly Consolidated Revenues |  |  |  | (In NT$ million)
 | 2013 | 2012 | MoM Change | YoY Change
December | 21569.433 | 26362.776
January | 15536.282 | 16615.31
February | 11369.748 | 20294.435
March
April
May
June
July
August
September
October
November
December
Total
Spreadsheet: james_steffes__12814__Booking Transp
Sheet: Central ANR

 |  | ANR TRANSPORT
 |  | TERM-11/2001-10/2002
 |  | Delivery Location | LDC | SL | Winter Vol | Summer Vol | Reservation Rate | Variable | Total Rate | Fuel %
 | ML7 | Milwaukee | WGC | ANR-Milwaukee | 2025 | 1000 | 0.2984 | 0.0182 | 0.3166 | 0.0449
 | ML7 | New London | WGC | ANR-Milwaukee | 480 | 200 | 0.2984 | 0.0182 | 0.3166 | 0.0449
 | ML7 | [NAME] | WPS | FIRM | 235 | 100 | 0.2984 | 0.0182 | 0.3166 | 0.0449
 | ML6 | Burlington | IES | ANR | 1650 | 600 | 0.2448 | 0.0167 | 0.2615 | 0.0377
 | ML6 | Centerville | IES | ANR | 210 | 100 | 0.2448 | 0.0167 | 0.2615 | 0.0377
 |  |  |  |  | 4600 | 2000
 |  | [NAME]
 |  | All from ANR/SW Pool
Spreadsheet: 153052d1335731332-excel-2007-dropdown-list-test
Sheet: Do Not Delete or Ammend

Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday
MonMorning |  |  | MonAfternoon |  |  | MonLates | TueMorning |  |  | TueAfternoon |  |  | TuesLates | WedMorning |  |  | WedAfternoon |  |  | WedLates | ThurMorning |  |  | ThurAfternoon |  |  | ThurLates | FriMorning |  |  | FriAfternoon |  |  | FriLates
Spreadsheet: 267053d1379924028-using-hlookup-for-deriving-a-value-grid-sample
Sheet: Example1

Input Grid |  |  |  |  | Output Grid
Channel | Jul | Aug | Sep |  | Mth | Channel | Output
Channel A | 15 | 20 | 25 |  | Aug | Channel A |  | [NAME] needed for this output
Channel B | 30 | 35 | 40 |  | Sep | Channel A
 |  |  |  |  | Jul | Channel A
 |  |  |  |  | Aug | Channel B
 |  |  |  |  | Sep | Channel B
 |  |  |  |  | Jul | Channel B
Spreadsheet: 832460d1686339732-add-according-to-date-valores-x-datas
Sheet: Planilha1

 | Changing the date changes the values
 | 2023-06-01 00:00:00
 | 2023-06-02 00:00:00
 | 2023-06-05 00:00:00
 | 2023-06-06 00:00:00
 | 2023-06-07 00:00:00
 | 2023-06-08 00:00:00
 | 2023-06-09 00:00:00
 | 2023-06-12 00:00:00
 | 2023-06-13 00:00:00
 | 2023-06-14 00:00:00
 | 2023-06-15 00:00:00
 | 2023-06-16 00:00:00
 | 2023-06-19 00:00:00
 | 2023-06-20 00:00:00
 | 2023-06-21 00:00:00
 | 2023-06-22 00:00:00
 | 2023-06-23 00:00:00
 | 2023-06-26 00:00:00
 | 2023-06-27 00:00:00
 | 2023-06-28 00:00:00
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Alumicor 6mm)

233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
Size | 18 | 24 | 36 | 48 | 60 | 72 | 96 | 120
12 | 20 | 25 | 35 | 35 | 100 | 100 | 100 | 125
18 | 25 | 25 | 35 | 35 | 100 | 100 | 100 | 125
24 | 25 | 25 | 35 | 35 | 100 | 100 | 100 | 125
36 | 25 | 25 | 50 | 50 | 100 | 100 | 100 | 125
48 | 25 | 25 | 50 | 50 | 86 | 86 | 86 | 115
Spreadsheet: 869892d1716447717-find-the-time-period-a-customer-returns-find-the-time-period-a-customer-returns
Sheet: Sheet1

 |  |  |  | Customer |  | Date |  |  | formula | What it should be
 |  |  |  | 6 |  | 2024-03-20 00:00:00 |  | 0 - 1 month |  | 5
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  | 1- 3 month | 2 | 2
 |  |  |  | 11 |  | 2024-01-09 00:00:00 |  | 3 - 6 month | 0 | 0
 |  |  |  | 11 |  | 2024-01-23 00:00:00 |  | 6 - 12 month | 1 | 1
 |  |  |  | 11 |  | 2024-02-02 00:00:00 |  | 12 - 24 month | 0 | 0
 |  |  |  | 11 |  | 2024-04-03 00:00:00 |  | 24+ | 0 | 0
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 22 |  | 2024-03-03 00:00:00
 |  |  |  | 22 |  | 2024-05-11 00:00:00
 |  |  |  | 33 |  | 2024-06-22 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 55 |  | 2024-02-22 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 55 |  | 2024-10-09 00:00:00
Spreadsheet: cooper_richey__4314__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 24  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 30 | 30.5
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 27.5 | 28.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 28 | 29
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 27.5 | 28.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 27.5 | 28.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 27.5 | 28.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 32 | 33
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 32 | 33
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 32 | 33
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 35.25 | 36.25
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 35.25 | 36.25
 |  | DEC | 33.3 |  |  |  | DEC | 35.25 | 36.25
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 735468d1623001143-transpose-data-on-unique-values-in-multiple-columns-transpose-data-on-unique-values
Sheet: Original Data

Candidate No | Candidate Surname | Candidate Forename | Product Name | Level Description | Band
55689 | Smith | Test | English | Higher | 5
55689 | Smith | Test | Maths | Higher | 3
55689 | Smith | Test | Science | National 5 | 6
55689 | Smith | Test | History | National 5 | 5
55689 | Smith | Test | PE | Higher | 4
564312 | Make | Data | RE | Higher | 4
564312 | Make | Data | PE | National 4 | 3
564312 | Make | Data | MFL | National 5 | 2
6665989 | More | Data | Science | National 5 | 1
6665989 | More | Data | MFL | National 5 | 1
6665989 | More | Data | [NAME] | Higher | 4
6665989 | More | Data | English | Higher | 5
Spreadsheet: 197248d1354267553-progressive-tax-calculation-formula-in-reverse-880340-progressive-tax-calculation-formula-in-reverse
Sheet: Sheet1

 | CalculateNet from Gross
 | Ammount | 21456 |  | Tax Rates
 | Tax |  |  | From | TO | Rate | Base
 | Net |  |  | 0 | 6000 | 0 | 0 |  | $0 – $6,000 Nil 0%
 |  |  |  |  | 37000 | 0.15 | 0 |  | $6,001 – $37,000 15c for each $1 over $6,000 15%
 |  |  |  |  | 80000 | 0.3 |  |  | $37,001 – $80,000 $4,650 plus 30c for each $1 over $37,000 30%
 |  |  |  |  | 180000 | 0.37 |  |  | $80,001 – $180,000 $17,550 plus 37c for each $1 over $80,000 37%
 |  |  |  |  |  | 0.45 |  |  | Over $180,000 $54,550 plus 45c for each $1 over $180,000 45%
 | Calculate Gross from Net after Tax
 | Net |  |  | Net to Taxable
 | Tax |  |  | From | TO | Rate | Base
 | Gross
Spreadsheet: cb897f06-8d21-4f2a-9a0f-fc9966445f1e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43186650 | 2014-09-16 19:28:48 | AXIS | 0 | 4 | 5 | 1617365 | hailKingFrank | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43186852 | 2014-09-16 19:48:22 | ALLIES | 1 | 5 | 3 | 1617365 | hailKingFrank | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
Spreadsheet: 271965d1382119939-retrieving-matching-emails-file2
Sheet: Sheet1

[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 23592 | 24000
2 |  |  | 24358 | 24000
3 |  |  | 24506 | 24000
4 |  |  | 24638 | 24000
5 |  |  | 24617 | 24000
6 |  |  | 24627 | 24000
7 |  |  | 24565 | 24000
8 |  |  | 24616 | 24000
9 |  |  | 24624 | 24000
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183022 | -128597
2001-12-31 00:00:00 | Balance | -1033420.01 |  | -571850.34
2002-01-09 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1164285.8 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -152764
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 683517d1592805475-adding-indirect-function-to-an-existing-if-statement-no-need-for-indirct-aligw
Sheet: Injury Condensed

team | Rowname | Colname | colstatus | name | status
1 | 2 | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
Spreadsheet: 270463d1381494838-searching-across-both-rows-and-columns-example-of-multiple-find-row-and-column
Sheet: Example

 |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 2013-12-19 00:00:00 | 2013-12-25 00:00:00 | 1013 | 1032 | 600 | 12 | 1015 | 1013 | 1015 | 143 | 1032 | 143 | 143 | 143 | 143
 | 2013-12-26 00:00:00 | 2014-01-01 00:00:00 | 1015 | 123 | 1032 | 600 | 600 | 1015 | 600 | 1013 | 123 | 1013 | 1013 | 1013 | 1013
 | 2014-01-02 00:00:00 | 2014-01-08 00:00:00 | 254 | 1234 | 123 | 1032 | 80 | 254 | 80 | 1015 | 1013 | 1015 | 1015 | 1015 | 1015
 | 2014-01-09 00:00:00 | 2014-01-15 00:00:00 | 125 | 12 | 1234 | 123 | 1032 | 125 | 600 | 254 | 1015 | 254 | 254 | 254 | 254
 | 2014-01-16 00:00:00 | 2014-01-22 00:00:00 | 354 | 1015 | 12 | 1234 | 123 | 1032 | 80 | 125 | 254 | 125 | 125 | 125 | 1013
 | 2014-01-23 00:00:00 | 2014-01-29 00:00:00 | 1523 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 600 | 125 | 600 | 322 | 143 | 1015
 | 2014-01-30 00:00:00 | 2014-02-05 00:00:00 | 1232 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 125 | 600 | 143 | 1013 | 254
 | 2014-02-06 00:00:00 | 2014-02-12 00:00:00 | 1032 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 80 | 1013 | 1015 | 125
 | 2014-02-13 00:00:00 | 2014-02-19 00:00:00 | 123 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 1015 | 254 | 1015
 | 2014-02-20 00:00:00 | 2014-02-26 00:00:00 | 1234 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 125 | 600
 | 2014-02-27 00:00:00 | 2014-03-05 00:00:00 | 12 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032 | 80
 | 2014-03-06 00:00:00 | 2014-03-12 00:00:00 | 600 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123 | 1032
 | 2014-03-13 00:00:00 | 2014-03-19 00:00:00 | 80 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234 | 123
 | 2014-03-20 00:00:00 | 2014-03-26 00:00:00 | 90 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12 | 1234
 | 2014-03-27 00:00:00 | 2014-04-02 00:00:00 | 2000 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015 | 12
 | 2014-04-03 00:00:00 | 2014-04-09 00:00:00 | 3242 | 125 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600 | 1015
 | 2014-04-10 00:00:00 | 2014-04-16 00:00:00 | 322 | 354 | 125 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80 | 600
 | 2014-04-17 00:00:00 | 2014-04-23 00:00:00 | 143 | 1523 | 354 | 125 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90 | 80
 | 2014-04-24 00:00:00 | 2014-04-30 00:00:00 | 101 | 12 | 1523 | 354 | 125 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000 | 90
 | 2014-05-01 00:00:00 | 2014-05-07 00:00:00 | 121 | 600 | 12 | 1523 | 354 | 125 | 254 | 1015 | 1013 | 143 | 322 | 3242 | 2000
 | Enter variable | 2014-09-15 00:00:00 | (Value between Column B and C)
 | Enter variable | 4 | (Value from Row 3)
 |  | Then | This should return: |  | 2000
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: MobStaff

O&M Mobilization Staffing Plan
Mobilization Before CommercialOperation
 |  | Staff | Number | Salary & | Total Salary
 | No. | Area | of | Benefits | & Benefits
 | Personnel | A,O or M | Months | US$/Month | US $
PLANT MANAGER | 1 | A | 9
[NAME] MANAGER | 0 | O | 6
PURCHASING / WAREHOUSE | 0 | M | 5
CLERK | 0 | O,M | 7
PLANT SUPERVISOR | 0 | M | 6
TECHNICIAN III | 2 | O,M | 5
TECHNICIAN II | 0 | O,M | 5
TOTALS
Overtime (15%) for last 2 months of Mobilization added to [NAME] by way of increasing months by .33
ASSUMPTIONS FOR PRE-OPERATIONS STAFF MOBILIZATION
POSITIONS | ANNUAL* | Annual
 | [NAME] | Hours
 | IN US $ | 2080
Straight Time Domestic Rates
Employee Cost Breakdown
 | Base | Payroll | Workers |  | Group | General |  |  | Base
Position or | Hourly | Tax | Comp. | O/H | Ins. | Liability | Pension | Burdened | Annual
Employee Name | Rate | [NAME] | Ins. | Alloc. | [NAME]. | Ins. |  | Total | Salary
 |  | 0.1434 | 0.0778 | 0.12 | 440.66 | 0.01 | 0.05
Administration
 | 25
 | 12.25
Operations & Maint.
 | 16
Over Time Domestic Rates
Employee Cost Breakdown
 | Base | Payroll | Workers |  | Group | General
Position or | Hourly | Tax | Comp. | O/H | Ins. | Liability | Pension | Burdened
Employee Name | Rate | [NAME] | Ins. | Alloc. | [NAME]. | Ins. |  | Total
 |  |  |  |  | 0 |  | 0
Administration
Operations & Maint.
Spreadsheet: 158825d1338403113-sort-list-removing-certain-values-formula-excludelist
Sheet: Sheet1

No blanks mixed in with data:
Full List | Exclude List |  | Sorted List
Dog | Rat |  | Dog
Cow | Cow |  | Cat
Cat | Bear |  | Bird
Bird |  |  | Horse
Horse |  |  | Zebra
Zebra |  |  | Goat
Bear
Goat
Rat
Blanks mixed in with data:
Full List | Exclude List |  | Sorted List
Dog | Rat |  | Dog
 | Cow |  | Cat
Cow | Bear |  | Bird
Cat |  |  | Horse
Bird |  |  | Zebra
 |  |  | Goat
Horse
Zebra
Bear
Goat
Rat
Spreadsheet: 216626-how-to-get-value-from-cell-that-matches-2-criterias-copy-of-adh-harribonesolution
Sheet: Sheet2

Date | Login ID | Minutes
2013-01-01 00:00:00 | 100 | 410
2013-01-01 00:00:00 | 101 | 543
2013-01-01 00:00:00 | 102 | 677
2013-01-01 00:00:00 | 103 | 324
2013-01-01 00:00:00 | 104 | 563
2013-01-01 00:00:00 | 105 | 466
2013-01-01 00:00:00 | 106 | 234
2013-01-01 00:00:00 | 107 | 245
2013-01-01 00:00:00 | 108 | 678
2013-01-02 00:00:00 | 100 | 211
2013-01-02 00:00:00 | 101 | 435
2013-01-02 00:00:00 | 102 | 767
2013-01-02 00:00:00 | 103 | 223
2013-01-02 00:00:00 | 104 | 0
2013-01-02 00:00:00 | 105 | 0
2013-01-02 00:00:00 | 106 | 0
2013-01-02 00:00:00 | 107 | 422
2013-01-02 00:00:00 | 108 | 765
2013-01-03 00:00:00 | 100 | 900
2013-01-03 00:00:00 | 101 | 231
2013-01-03 00:00:00 | 102 | 345
2013-01-03 00:00:00 | 103 | 674
2013-01-03 00:00:00 | 104 | 709
2013-01-03 00:00:00 | 105 | 0
2013-01-03 00:00:00 | 106 | 0
2013-01-03 00:00:00 | 107 | 0
2013-01-03 00:00:00 | 108 | 0
2013-01-01 00:00:00 | 100 | 90 | <------ | This user has logged in for 90 minutes plus 410 minutes in row 2
Spreadsheet: 851541d1701757252-if-this-equals-this-then-fill-this-value-excel-post
Sheet: Amenity Block

column 1 | column 2 | row 3
GRADE | QTY
 |  | M10 | M15 | M20 | M25 | M30 | M35 | M40 | M45 | M50 | M55 | M55 SCC
M30 | 10 |  |  |  |  | 10 |  |  |  |  |  |  |  | look for value in column 1 = m30
M40 | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  | then seach for the same in column 1 =m30 in row 3
M30 | 17.5
M40 | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  | fill corresponding quantity
M30 | 25
M40 | 13.5
M40 | 9
M10 | 5 | 5
M40 | 2.5
M30 | 30.5
M30 | 24
M40 | 5
M40 | 10
M30 | 5
M10 | 28
M10 | 26
M10 | 14
M40 | 18
M30 | 21.5
M30 | 3
M40 | 9.5
M10 | 30
M30 | 23.5
M30 | 1
M40 | 7.5
M10 | 21
M10 | 63
M40 | 1.5
M10 | 38.5
M30 | 21
M10 | 24
M10 | 18
Spreadsheet: 215894d1361532222-merging-rows-via-vlookups-helpsheet_pivot-solution
Sheet: Pivot

Row Labels | Sum of Col 1 | Sum of Col 2 | Sum of Col 3 | Sum of Col 4
700 | 1 | 2 | 3
800 | 2 | 1 | 3
900 | 1 | 2 | 3
1000 | 1 | 2 | 3
1100 | 1 | 2 | 3
1200 | 1 | 2 | 3 | 4
1300 | 1 |  |  | 1
1400 | 1
Grand Total | 9 | 11 | 18 | 5