tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12024__DEC00
Sheet: Table10

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 10
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
CALENDAR YEAR TO DATE
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION
 | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 |  | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 |  | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 |  | 1999-12-01 00:00:00 | 2000-12-01 00:00:00
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 26434.4 | 27082 | 2.4 | 3.26 | 4.94 | 51.5 | 933.2 | 956 | 2.4 | 2.36 | 3.56 | 51
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 42717.2 | 44506.9 | 4.2 | 2.97 | 5.36 | 80.4 | 1508 | 1571.1 | 4.2 | 2.15 | 3.84 | 79.1
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 26388.4 | 30211.6 | 14.5 | 2.91 | 5.76 | 98.1 | 931.5 | 1066.5 | 14.5 | 2.11 | 4.13 | 96.2
TOTAL - TERM/TERME | 95540.1 | 101800.5 | 6.6 | 3.03 | 5.37 | 76.9 | 3372.7 | 3593.7 | 6.6 | 2.19 | 3.85 | 75.7
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 19157.1 | 19049.8 | -0.6 | 2.83 | 5.11 | 80.8 | 676.3 | 672.5 | -0.6 | 2.04 | 3.67 | 79.6
MIDWEST/MIDWEST | 36908.4 | 38090.6 | 3.2 | 2.87 | 5.14 | 78.9 | 1302.9 | 1344.6 | 3.2 | 2.08 | 3.69 | 77.7
MOUNTAIN/ROCHEUSES | 1050.5 | 744.8 | -29.1 | 2.9 | 4.32 | 49.2 | 37.1 | 26.3 | -29.1 | 2.09 | 3.12 | 49.2
NORTHEAST/NORD-EST | 23644.2 | 29618.3 | 25.3 | 3.51 | 5.83 | 66.2 | 834.7 | 1045.6 | 25.3 | 2.54 | 4.19 | 65.1
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 14779.9 | 14297.2 | -3.3 | 2.97 | 5.43 | 83 | 521.7 | 504.7 | -3.3 | 2.14 | 3.89 | 81.6
TOTAL - REGION/RÉGION | 95540.1 | 101800.5 | 6.6 | 5.37 | 3.03 | 76.9 | 3372.7 | 3593.7 | 6.6 | 2.19 | 3.85 | 75.7
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 8007.2 | 7393.8 | -7.7 | 3.56 | 4.7 | 32.2 | 282.7 | 261 | -7.7 | 2.57 | 3.39 | 32
LDC/SDL | 26383.4 | 26362.8 | -0.1 | 3.14 | 5.25 | 67.3 | 931.4 | 930.6 | -0.1 | 2.27 | 3.77 | 66.4
MARKETING CO./DISTRIBUTEURS | 57841.3 | 63820.1 | 10.3 | 2.95 | 5.52 | 87.2 | 2041.9 | 2252.9 | 10.3 | 2.13 | 3.96 | 85.7
PIPELINE/PIPELINES | 3308.2 | 4223.8 | 27.7 | 2.43 | 4.99 | 105.2 | 116.8 | 149.1 | 27.7 | 1.76 | 3.56 | 102.3
TOTAL - CUSTOMER TYPE/CLIENT | 95540.1 | 101800.5 | 6.6 | 3.03 | 5.37 | 76.9 | 3372.7 | 3593.7 | 6.6 | 2.19 | 3.85 | 75.7
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED |  |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | AVERAGE PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 204878d1357671437-nested-if-example
Sheet: Sheet2

A1 | B1 | Start Date | End Date | Number Needed
TCAT001 | Example | 2012-06-04 00:00:00 | 2012-07-16 00:00:00 | 47
TCAT002 | Example | 2012-07-02 00:00:00 | 2012-08-13 00:00:00 | 0
TCAT003 | Example | 2012-08-06 00:00:00 | 2012-09-17 00:00:00 | 72
TCAT004 | Example | 2012-09-03 00:00:00 | 2012-10-15 00:00:00 | 46
TCAT005 | Example | 2012-10-01 00:00:00 | 2012-11-12 00:00:00 | 62
TCAT006 | Example | 2012-11-05 00:00:00 | 2012-12-17 00:00:00 | 81
TCAT007 | Example | 2012-11-05 00:00:00 | 2012-12-17 00:00:00 | 17
TCAT008 | Example | 2012-06-04 00:00:00 | 2012-07-16 00:00:00 | 41
TCAT009 | Example | 2012-07-02 00:00:00 | 2012-08-13 00:00:00 | 13
TCAT010 | Example | 2012-08-06 00:00:00 | 2012-09-17 00:00:00 | 42
TCAT011 | Example | 2012-09-03 00:00:00 | 2012-10-15 00:00:00 | 41
Spreadsheet: 854074d1704040501-lookup-and-return-the-dates-falls-between-from-and-to-date-return-dates-falls-between-from-end-to-date-dj-1-
Sheet: Sheet1

ID Number | From Date | To Date
30165 | 2021-07-31 00:00:00 | 2022-07-01 00:00:00
 | From Date | To Date | Nos. of Day |  |  |  | From Date | To Date | Nos. of Day
 |  |  |  |  |  |  | 2021-11-22 00:00:00 | 2021-11-30 00:00:00
 |  |  |  |  |  |  | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 |  |  |  |  |  |  | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
 |  |  |  |  |  |  | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
 |  |  |  |  |  |  | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
 |  |  |  |  |  |  | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
 |  |  |  |  |  |  | 2022-06-06 00:00:00 | 2022-06-16 00:00:00
Spreadsheet: 462208d1463954144-question-about-excel-columns-2
Sheet: List1

Column A | Column B
a | a
d | b
Column A | c
w | d
t | e
r | f
w | g
q | h
f | i
d | j
 | k
 | l
p | m
Spreadsheet: 101053d1299206027-auto-look-up-and-summation-book1
Sheet: Sheet4

Instructions: Fill up yellow cells with the desired month. The REPORT FOR THE MONTH will reflect the Rev, COR and Total for that same month alone. REPORT YEAR TO DATE will Sum the Revenue, COR and Total from month 1 until the encoded month.
REPORT FOR THE MONTH: | 3
REVENUE | 2.706472817392003
COR | 47.25321710093279
TOTAL | -44.54674428354078
REPORT YEAR TO DATE | 5
REVENUE | 234.4433263879605
COR | 254.6711190317485
TOTAL | -20.22779264378809
 | FINANCIAL REPORT
MONTH | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
REVENUE | 14.58093357767719 | 64.26861710919019 | 2.706472817392003 | 60.32922189740218 | 92.5580809862989 | 52.6075506157114 | 81.8552809290038 | 15.59910451807849 | 77.84937014629335 | 33.8622687686326 | 38.69377338366202 | 56.41528342399324
COR | 20.04483101252821 | 93.6439561149394 | 47.25321710093279 | 66.82440077234999 | 26.90471403099818 | 25.84563106254249 | 38.4931304499036 | 70.56486928192278 | 48.87455135328683 | 40.1904360252823 | 59.94252414087746 | 16.29572009662872
TOTAL | -5.463897434851015 | -29.37533900574921 | -44.54674428354078 | -6.495178874947804 | 65.65336695530073 | 26.7619195531689 | 43.36215047910019 | -54.96576476384429 | 28.97481879300652 | -6.328167256649706 | -21.24875075721544 | 40.11956332736452
Spreadsheet: 741248d1626934553-if-greater-than-or-less-than-return-value-untitled-spreadsheet
Sheet: Sheet1

Name | Salary | Grade |  | Grade | Min | [NAME]
[NAME] | 7490 |  |  | 1 | 1000 | 3000
[NAME] | 22000 |  |  | 2 | 3001 | 7500
[NAME] | 31000 |  |  | 3 | 7501 | 12500
[NAME] | 100000 |  |  | 4 | 12501 | 17500
 |  |  |  | 5 | 17501 | 22500
 |  |  |  | 6 | 22501 | 30000
 |  |  |  | 7 | 30001 | 40000
 |  |  |  | 8 | 40001 | 50000
 |  |  |  | 9 | 50001 | 65000
 |  |  |  | 10 | 65001 | 70000
 |  |  |  | 11 | 70001 | 90000
 |  |  |  | 12 | 90001
Spreadsheet: 784294d1655590502-paneldata-data-transpose-datenbereich1
Sheet: DATA LIST (2)

Unternehmen | Jahr | ESG Combined Score | Environmental Pillar Score | Social Pillar Score | Governance Pillar Score | ESG Controversies Score | CSR-Committee V1 | CSR-[NAME] | Industry | Board Independence | Non-Executive BM | Board [NAME] | CEO Chariman Duality | Full-time employees | Pre-tax ROA | Net debt to Total Equity | Market [NAME]
1 | 2020
1 | 2019
1 | 2018
1 | 2017
1 | 2016
1 | 2015
1 | 2014
1 | 2013
1 | 2012
1 | 2011
1 | 2010
2 | 2020
2 | 2019
2 | 2018
2 | 2017
2 | 2016
2 | 2015
2 | 2014
2 | 2013
2 | 2012
2 | 2011
2 | 2010
3 | 2020
3 | 2019
3 | 2018
3 | 2017
3 | 2016
3 | 2015
3 | 2014
3 | 2013
3 | 2012
3 | 2011
3 | 2010
4 | 2020
4 | 2019
4 | 2018
4 | 2017
4 | 2016
4 | 2015
4 | 2014
4 | 2013
4 | 2012
4 | 2011
4 | 2010
Spreadsheet: 121567d1316162678-populate-dates-with-number-of-days-test-didb
Sheet: Sheet2

 |  | Venue
 | 1 | Conference 1
 | 2 | Conference 2
 | 3 | Conference 3
 | 4 | Conference 4
 | 5 | Banquet 1 |  |  |  |  |  |  |  |  |  | Description | Status
 | 6 | Banquet 2 |  |  |  |  |  |  |  |  |  | Conf (Gov) FD | Preferred
 | 7 | Chapel |  |  |  |  |  |  |  |  |  | Conf (Corp) FD | Quotation
 | 8 | Chapel (15h00) |  |  |  |  |  |  |  |  |  | Conf (Gov) HD | Provisional
 | 9 | Chapel (17h00) |  |  |  |  |  |  |  |  |  | Conf (Corp) HD | Confirmed
 | 10 | Board Room |  |  |  |  |  |  |  |  |  | Wedding | Completed
 | 11 | Gazebo |  |  |  |  |  |  |  |  |  | Function
 | 12 | Transport |  |  |  |  |  |  |  |  |  | Birthday
Spreadsheet: 539403d1506095217-convert-repeated-data-in-a-column-into-headers-book2
Sheet: Sheet1

No | Position |  |  | Manager | Assistant
842 | Assistant
620 | Assistant
944 | Manager
836 | Assistant
297 | Manager
718 | Manager
119 | Manager
155 | Assistant
967 | Assistant
169 | Manager
928 | Manager
217 | Assistant
436 | Manager
841 | Assistant
282 | Manager
972 | Manager
277 | Manager
178 | Manager
859 | Manager
Spreadsheet: mary_fischer__25632__31N
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF A/R - OTHER
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 547211d1510405147-how-to-match-street-indexes-columns-in-yellow-highligted-to-streets-to-match-file-sample-to-houston-plan-and-develop
Sheet: STREETS TO MATCH

ADDRESS | STREET | KEY MAP | ZIP | LONG | LAT | HPD BEATS
2804 | CHAMPIONS RIDGE RD
28903 | HIDDEN LAKE CT
9324 | HIDDEN LAKE W
28855 | HIDDEN CT
28705 | ASCOT FARMS RD
16787 | BOBOLINK DR
51 | COUNTRY GATE CIR
100 | RESEARCH FOREST DR
1400 | PINECROFT DR
9511 | HIDDEN COVE DR
9203 | DEAD END
9203 | HIDDEN LAKE CT
214 | DEAD END
300 | [NAME]
Spreadsheet: 874555d1721142409-sequence-values-within-an-array-sample
Sheet: Sheet1

 | INPUT VALUES |  |  | RANGE OF POINTS TO TRANSFORM
 |  |  |  | START POINT | END POINT
PT # | Y Coordinates | X Coordinates |  | (or single pt) | (or empty) | Empty? |  | Range1 | Range2 | Range3 | Range4 | Range5
1 | 581735.12 | 1766282.86 |  | 1 | 6
2 | 581765.246 | 1768562.0903 |  | 11 |  |  |  | 2 |  | 114
4 | 581769.7225 | 1768902.7909 |  | 101 | 114 |  |  | 4 |  | 112
5 | 579130.8787 | 1768926.5763 |  |  |  |  |  | 5 |  | 113
6 | 579119.3138 | 1768358.6941 |  |  |  |  |  | 6
7 | 579078.1099 | 1766335.4236
8 | 576384.616 | 1764771.9017
11 | 576413.1213 | 1766388.145
14 | 576418.153 | 1767380.3851
15 | 576423.9439 | 1768514.1474
16 | 576426.3695 | 1768990.6213
101 | 575195.0631 | 1768719.7843
114 | 573895.7258 | 1768205.0101
112 | 573875.907 | 1767397.2831
113 | 573811.1526 | 1764758.1774
 |  |  |  |  |  |  |  | SHOULD BE DISPLAYED LIKE BELOW:
 |  |  |  |  |  |  |  | 1 | 11 | 101
 |  |  |  |  |  |  |  | 2 |  | 114
 |  |  |  |  |  |  |  | 4 |  | 112
 |  |  |  |  |  |  |  | 5 |  | 113
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | OR
 |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  | 112
 |  |  |  |  |  |  |  |  |  | 113
 |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  | (ORDER DOESN'T MATTER)
Spreadsheet: 553471d1514358870-how-to-convert-dollar-value-to-number-to-sum-up-example
Sheet: Sheet1

A | B | Total
$12.00
$12.00 | $36.00
$12.00
$12.00 | $6.00
$12.00 | $18.00
$12.00 | $6.00
$12.00
$12.00
$12.00 | $12.00
$12.00 | $12.00
$12.00 | $12.00
$12.00 | $6.00
$12.00 | $24.00
$12.00
$12.00
Spreadsheet: 179503d1347283650-need-drop-down-for-tables-book1
Sheet: Sheet1

2010 | Lab | Class
[NAME] | 89 | 72 |  | I need a drop down for the tables by year
[NAME] | 12 | 13
2011 | Lab | Class
[NAME] | 75 | 78
[NAME] | 14 | 17
2012 | Lab | Class
[NAME] | 75 | 90
[NAME] | 16 | 14
2013 | Lab | Class
[NAME] | 78 | 73
[NAME] | 13 | 7
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q10 TIMBER 

TIMBER |  |  |  | year | net worth | withdrawal |  |  | intrinsic
 |  |  |  | 0 | 2079130.119688861 | 150000
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 42563d1241103502-employee-schedule-help-schedule09d-bargraph
Sheet: Wednesday

 |  | Area |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 10:00:00 | 11:00:00 | Total Hours
 |  | Service Desk | IN | OUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
1 | 62 | [NAME] | 08:00:00 | 14:00:00 |  | X | X | X | X | X | X |  |  |  |  |  |  |  | X | X |  | 8
2 | 74 | Hayley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 | 9 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
4 | 26 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 | 43 | Ramsay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
20
21
22
Spreadsheet: john_griffith__15605__Mesa Model 1_19_01
Sheet: Index Quote

Trader |  | Originator |  | Structurer |  | Customer
[NAME] |  | [NAME] |  | [NAME] |  | City of Mesa
Start | Stop |  | Monthly |  |  |  |  | Index
Date | Date | Term | MMbtu |  | Delivery Points |  |  | Offer
 |  |  | see below |  | IF-ELPO/SJ
 | Month | Volume/month
 | 2001-08-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | 2002-01-01 00:00:00
 | Total
Spreadsheet: 60896d1261478620-vacation-gantt-conditional-formatting-vacation-gantt
Sheet: Sheet1

 | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days
[NAME] | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 7 | 6
[NAME] | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 1 | 2
[NAME] | 2010-01-10 00:00:00 | 2010-01-14 00:00:00 | 4 | 4
[NAME] | 2009-12-31 00:00:00 | 2010-01-10 00:00:00 | 10 | 7
[NAME] | 2010-01-15 00:00:00 | 2010-01-17 00:00:00 | 2 | 1
[NAME] | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 7 | 6
[NAME] | 2010-01-04 00:00:00 | 2010-01-09 00:00:00 | 5 | 5
[NAME] | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 4 | 3
[NAME] | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2
[NAME] | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2
[NAME] | 2010-01-10 00:00:00 | 2010-01-15 00:00:00 | 5 | 5
[NAME] | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2
Mario | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2
Spreadsheet: 165499d1341250339-vlookup-forumula-that-has-more-than-on-set-search-value-sample-v3
Sheet: Sheet A

 | Current Scores |  |  |  |  |  | Recommendation
 | Current |  |  |  |  |  | Recommended
Points | 0 | 7 | 10 | 12 | 15 |  | 0 | 7 | 10 | 12 | 15 |  | Score Range Change
Score Range | <21.00% | >=21.00% | >=24.00% | >=27.00% | >=30.00% |  | 0.21 | 0.21 | 0.24 | 0.27 | 0.3
# of Reps
Spreadsheet: 876694d1723433109-sumifs-formula-to-add-multiple-columns-based-on-same-criteria-sumifs
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | I need to use [NAME] formula without helper column
CAT | Name | Salary | OT | INCENTIVE | PF |  | CAT | Name | Total
Engineer | Raju | 10000 | 2000 | 1000 | 1000 |  | Engineer | Raju | 14000
Senior Engineer | Ramu | 20000 | 4000 | 2000 | 2000 |  | Engineer | Vijay | 11200
Senior Engineer | Ravi | 18000 | 3600 | 1800 | 1800 |  | Senior Engineer | Ramu | 28000
Engineer | Vijay | 8000 | 1600 | 800 | 800 |  | Senior Engineer | Ravi | 25200
Spreadsheet: 00c29aa8-b6b9-44e2-ab5f-e4d0f8f3238f
Sheet: Gujrath

Place | Address | Contact Person / NO | Mutt | Other Places near by
Dwaraka | [NAME] | Ph: [PHONE],[PHONE] | Udupi Sri Phalimar Mutt | Porbhandar ([NAME], [NAME] temple, [NAME] temple by the [NAME] family & of course [NAME]'s birth home
 | Goshaala Road, | Shri [NAME] 60749 |  | Go to Veraval & visit Somnath Temple & Prabhasa (Lord [NAME]'s Parandhama).
 | [NAME] | 94269 25393
 | Dwaraka.
Dwaraka | Dwarka [NAME] |  | [NAME] mutt
Baroda | [NAME] mutt |  | Trust
 | Reach Susan Circle on Baroda-Mumbai Road (5 Km from Bus stand)
 | Enquire for GIDC Road - (approx 50 mtrs from Circle)
 | Ask someone there, who will guide you to the mutt
[NAME] ([NAME]) | [NAME], | Phone No. : [PHONE] | Uttradi Math
 | [NAME],
 | Near Bindu Sarovar ,
 | SIDDHAPUR, MATRUGAYA,
 | Dist - Maheshana (GJ).
Ahemadabad |  | [NAME] [PHONE] | Uttaradhi Mutt | There is [NAME] in Ahemadabad & Sri Vyasarajachar is in chgarge of it.
 |  |  |  | His Ph. No. is [PHONE]. He is very nice gentleman and will help u get a taxi to go to Matrugaya and back.
 |  |  |  | The taxi will pick u up in the Stn. It takes about 2 and half hours to go Matrugaya.
 |  |  |  | If u leave [NAME] around 6.00 AM u can reach Matrugaya, have a bath at the Bindhusarovar and
 |  |  |  | complete ur [NAME], have lunch & return to [NAME] by around 7.00PM
Spreadsheet: 800295d1665583869-unique-values-with-multiple-criteria-between-two-dates-test-forum
Sheet: Calcs

Enter Start of Year | 2022-04-01 00:00:00
Select Individual Name | D1
Select period | 2022-09-30 00:00:00
Reason |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Total Deals with PQ Status
ALL |  |  |  | 40
Total Deals with PQ Status - FS Error
ALL
Spreadsheet: 196735d1354092625-autofilter-filter-containing-values-based-on-entries-of-table-list-in-a-sheet-sample_file
Sheet: Sheet2

 | contains list |  | RESULT
QUERY1 ==>> | grange | 4 | 16 the grange | ==>> RESULT OF QUERY1 STARTS AT THIS RANGE
QUERY2 ==>> | freemount | 4 | 17 the grange
QUERY3 ==>> | larches | 2 | 18 the grange
QUERY3 ==>> | AAA | 45 | 18 the grange close
" |  | 60
" |  | 60
 |  |  | freemount lane | ==>> RESULT OF QUERY2 STARTS AT THIS RANGE
 |  |  | freemount street
 |  |  | freemount lane 7
 |  |  | 18 freemount street
 |  |  | AAA1 | ==>> RESULT OF QUERY3 STARTS AT THIS RANGE AND LIMIT RESULT TO FIRST 3
 |  |  | AAA2
 |  |  | AAA3
 |  |  | the larches | ==>> RESULT OF QUERY3 STARTS AT THIS RANGE
 |  |  | the larches smith street
 |  |  | NOTE: | "RESULT" may have variable output range
 |  |  | OPTIONS: | CAN SPECIFY STARTING RANGE  WHERE TO PASTE RESULTS PER QUERY AND PASTE ALL RESULT
 |  |  |  | CAN SPECIFY STARTING RANGE  WHERE TO PASTE RESULTS PER QUERY
 |  |  |  | AND LIMIT TO CERTAIN NUMBER OF OUTPUT RESULTS
Spreadsheet: 98162c89-4b53-437c-a0c7-26108070d091
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (24 Entries):
 | 8 Passive components 8.8 Piezoelectric components
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AAC Acoustic Technologies Holdings Inc | China | Shenzhen | P.R. | B5.125
2 | AVX Corporation | United Kingdom | [NAME] | GU51 4BB | B6.219
3 | CeramTec AG Electronic Applications Division | Germany | [NAME] | 95615 | B1.206
4 | CODICO GmbH | Austria | Perchtoldsdorf | 2380 | A5.507
5 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
6 | EPCOS AG, A Group Company of TDK-EPC Corporation | Germany | München | 81669 | B5.506
7 | ESS GmbH | Germany | Norderstedt | 22846 | B6.346
8 | [NAME] (Germany) GmbH Piezoproducts | Germany | Redwitz | 96257 | B6.145
9 | [NAME] | Germany | Ostfildern | 73760 | B6.124
10 | Micro Crystal AG | Switzerland | Grenchen | 2540 | A4.206
11 | Morgan Technical Ceramics Electroceramics | United Kingdom | Ruabon | [NAME] 6HY | B5.509
12 | M+R Multitronik GmbH | Germany | [NAME] | 23564 | B2.260
13 | N&H Technology GmbH | Germany | Willich | 47877 | B5.279
14 | NINGBO BEST GROUP CO., LTD. | China | Ningbo | 315040 | B6.536/10
15 | Noliac Ceramics s.r.o. | Czech Republic | Librice | 503 44 | B5.133/3
16 | PI Ceramic GmbH Keramische Technologien und Bauelemente | Germany | Lederhose | 07589 | A2.420
17 | Sonitron N.V. | Belgium | Sint-Niklaas | 9100 | B2.260
18 | South China Electronics Co Ltd. | Hong Kong | Fo [NAME], N.T. |  | B6.463/5
19 | Sparkler Ceramics Pvt. Ltd. | India | Pune | 411026 | B5.530/1
20 | SUMIDA Components GmbH | Germany | Neumarkt | 92318 | B5.325
21 | TDK Electronics Europe GmbH | Germany | [NAME] | 40472 | B5.506
22 | TDK-EPC Corporation, A Group Company of TDK Corporation, c/o EPCOS AG | Germany | München | 81669 | B5.506
23 | Vectron International Hudson | USA | Hudson | NH 03051 | B5.237
24 | Vectron International Mt. Holly Springs | USA | Mt. Holly Springs | PA 17065 | B5.237
Spreadsheet: 830740d1685067289-equal-formula-equal-formula
Sheet: Sheet

NO | NAME | ID | RESULT
1 |  |  | BM
 |  |  | BI |  |  |  |  |  | NO | NAME | ID
 |  |  | MATH |  |  |  |  |  | 1 | [NAME] | CE40392
 |  |  | SCIENCE |  |  |  |  |  | 2 | [NAME] | BT91293
2 |  |  | BM |  |  |  |  |  | 3 | [NAME] | BQ66828
 |  |  | BI |  |  |  |  |  | 4 | [NAME] | CC13213
 |  |  | MATH |  |  |  |  |  | 5 | [NAME] | BN11901
 |  |  | SCIENCE |  |  |  |  |  | 6 | ADAM MUHAMMAD | BW92683
3 |  |  | BM |  |  |  |  |  | 7 | ADIB FAUZAN | BW92684
 |  |  | BI |  |  |  |  |  | 8 | ADIBAH NAJIHAH | BT88436
 |  |  | MATH |  |  |  |  |  | 9 | ADIFF DANISH | CG19881
 |  |  | SCIENCE |  |  |  |  |  | 10 | ADRIANA ATIQAH | CI08754
4 |  |  | BM |  |  |  |  |  | 11 | ADRIANA NUR IZAZI | CD73425
 |  |  | BI |  |  |  |  |  | 12 | AFIAH TASNIF | CE40393
 |  |  | MATH
 |  |  | SCIENCE
5 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
6 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
7 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
8 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
9 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
10 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
11 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
12 |  |  | BM
 |  |  | BI
 |  |  | MATH
 |  |  | SCIENCE
Spreadsheet: 877188d1723884966-map-filter-and-sumifs-of-two-different-ranges-sum-lookup1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Expected Result > Prefix>GO24 >
 |  |  | Lookup1 >Prefix >GO24 |  |  | [NAME] applied |  |  |  |  | Code | Name of Flower | Data | Diff.
 |  |  | 1 | 4600569 |  |  | Name of Flower | Data |  |  | 11 | Sunflower
 |  |  | 2 | 947505 |  | 11 | Sunflower | 1146798.66 |  |  | 36 | Jasmine | 947505
 |  |  | 3 | 219559 |  | 11 | Sunflower | 3453770.34 |  |  | 44 | Marigold | 219559
 |  |  | 4 | 758004 |  |  |  |  |  |  | 12 | Lily | 758004
 |  |  | 5 | 1134915.5 |  |  |  |  |  |  | 51 | Hibiscus
Spreadsheet: dd3d12bf-75e1-4697-b6c0-966cb7700cf1
Sheet: Sheet1

2012 March Quarter | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Table 3: Common housing types – comparison
 |  | Median $ per week | % Change Over quarter | % Change Over year | Lower quartile $ per week | Upper quartile $ per week
Metropolitan | 2 Bed Flat | 360 | 0.029 | 0.02 | 300 | 450
 | 3 Bed House | 340 | 0 | 0 | 300 | 400
 | Total | 350 | 0 | 0 | 300 | 430
SOURCE: RTBA, Office of Housing