tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 269528d1381188773-understanding-mod-function-excelforum
Sheet: Sheet1

Date | Time | Open | High | Low | Close | Volume
2009-01-01 00:00:00 | 1 | 90.66 | 90.7 | 90.66 | 90.7 | 375
2009-01-01 00:00:00 | 2 | 90.7 | 90.7 | 90.68 | 90.7 | 356
2009-01-01 00:00:00 | 3 | 90.7 | 90.7 | 90.68 | 90.7 | 340
2009-01-01 00:00:00 | 4 | 90.7 | 90.7 | 90.68 | 90.7 | 364
2009-01-01 00:00:00 | 5 | 90.65 | 90.66 | 90.64 | 90.64 | 359
2009-01-01 00:00:00 | 6 | 90.64 | 90.66 | 90.64 | 90.65 | 382
2009-01-01 00:00:00 | 7 | 90.65 | 90.66 | 90.64 | 90.65 | 364
2009-01-01 00:00:00 | 8 | 90.65 | 90.66 | 90.64 | 90.64 | 367
2009-01-01 00:00:00 | 9 | 90.66 | 90.94 | 90.65 | 90.92 | 530
2009-01-01 00:00:00 | 10 | 90.94 | 91.29 | 90.93 | 91.26 | 440
2009-01-01 00:00:00 | 11 | 91.27 | 91.27 | 90.93 | 91.21 | 333
2009-01-01 00:00:00 | 12 | 91.21 | 91.22 | 91.2 | 91.21 | 354
2009-01-01 00:00:00 | 13 | 91.21 | 91.22 | 91.2 | 91.2 | 339
2009-01-01 00:00:00 | 14 | 91.2 | 91.22 | 91.2 | 91.21 | 323
2009-01-01 00:00:00 | 15 | 91.21 | 91.22 | 91.2 | 91.2 | 323
2009-01-01 00:00:00 | 16 | 91.2 | 91.22 | 91.2 | 91.22 | 340
2009-01-01 00:00:00 | 17 | 91.21 | 91.22 | 91.2 | 91.2 | 362
2009-01-01 00:00:00 | 18 | 91.2 | 91.22 | 89.46 | 90.68 | 303
Spreadsheet: 149214d1333746470-i-need-help-salesdata
Sheet: Quarterly Sales By Country

Row Labels | Sum of  Unit Purchase Price | Sum of Quantity | Count of Product
Qtr1 | 17169.46 | 15756 | 630
Argentina | 566.9000000000001 | 132 | 14
Austria | 986.35 | 2119 | 44
Belgium | 497.7 | 487 | 20
Brazil | 2148.75 | 1696 | 77
Canada | 673.1999999999999 | 700 | 25
Denmark | 601.3399999999999 | 512 | 18
Finland | 400.7 | 350 | 20
France | 1523.94 | 1156 | 65
Germany | 2375.74 | 2263 | 74
Ireland | 456.47 | 495 | 12
Italy | 368.9499999999999 | 353 | 18
Mexico | 176.45 | 142 | 9
Norway | 494.9999999999999 | 107 | 11
Poland | 159.05 | 93 | 8
Portugal | 80.8 | 56 | 3
Spain | 554.7800000000001 | 239 | 17
Sweden | 749.7099999999999 | 706 | 36
Switzerland | 56 | 80 | 2
UK | 1055.7 | 853 | 45
USA | 2519.9 | 2343 | 76
Venezuela | 722.03 | 874 | 36
Qtr2 | 17610.87 | 15301 | 659
Argentina | 422.4 | 185 | 17
Austria | 1047.65 | 1554 | 37
Belgium | 461.58 | 603 | 25
Brazil | 1406.3 | 880 | 44
Canada | 565.3 | 454 | 22
Denmark | 258.85 | 240 | 10
Finland | 248.95 | 179 | 12
France | 1417.37 | 682 | 42
Germany | 2713.69 | 2984 | 104
Ireland | 284.4499999999999 | 394 | 11
Italy | 334.6 | 207 | 14
Mexico | 793.8 | 360 | 25
Norway | 76.19 | 46 | 4
Poland | 100.05 | 81 | 5
Portugal | 441.39 | 303 | 16
Spain | 331.95 | 216 | 18
Sweden | 644.8299999999999 | 634 | 23
Switzerland | 652.8499999999999 | 567 | 25
UK | 1285.27 | 1088 | 51
USA | 3182.719999999999 | 2478 | 107
Venezuela | 940.68 | 1166 | 47
Qtr3 | 9003.079999999998 | 8337 | 370
Austria | 393.33 | 790 | 19
Belgium | 174.4 | 140 | 5
Brazil | 1139.16 | 1086 | 50
Canada | 373.7 | 530 | 17
Denmark | 133.75 | 153 | 7
Finland | 335.44 | 147 | 9
France | 631.05 | 467 | 27
Germany | 1621.07 | 1638 | 68
Ireland | 204 | 201 | 7
Italy | 186.65 | 130 | 10
Mexico | 360.3 | 221 | 17
Norway | 62.5 | 8 | 1
Poland | 71 | 31 | 3
Portugal | 30.75 | 16 | 2
Spain | 249.64 | 53 | 8
Sweden | 442.3 | 423 | 21
Switzerland | 119.1 | 167 | 7
UK | 293.4 | 221 | 14
USA | 1742.64 | 1425 | 60
Venezuela | 438.9 | 490 | 18
Qtr4 | 12717.49999999999 | 11923 | 496
Argentina | 91.5 | 22 | 3
Austria | 1042.62 | 704 | 25
Belgium | 208.3 | 162 | 6
Brazil | 630.43 | 585 | 32
Canada | 295.3 | 300 | 11
Denmark | 218.3 | 265 | 11
Finland | 308.7 | 209 | 13
France | 1267.1 | 949 | 50
Germany | 1834.34 | 2328 | 82
Ireland | 774.9399999999998 | 594 | 25
Italy | 221.85 | 132 | 11
Mexico | 488.43 | 302 | 21
Portugal | 187.95 | 158 | 9
Spain | 160.9 | 210 | 11
Sweden | 649.6500000000001 | 472 | 17
Switzerland | 503.7400000000001 | 461 | 18
UK | 482.5 | 580 | 25
USA | 3017.650000000001 | 3084 | 109
Venezuela | 333.3 | 406 | 17
Grand Total | 56500.91000000004 | 51317 | 2155
Spreadsheet: eric_saibi__9983__112101R
Sheet: Sequoyah 01

Owner Name |  | TVA
Station Name |  | Sequoyah Nuclear Power Station
Unit Name |  | Sequoyah 01
NERC Region |  | SERC
State |  | TN
Fuel Type |  | Nuclear
Capacity |  | 1,221 MW
Start Date |  | 2001-10-22 00:00:00
End Date |  | 2001-11-22 00:00:00
Prv. Start Date |  | 2001-10-22 00:00:00
Prv. End Date |  | 2001-11-25 00:00:00
Comments |  | Refueling.  Plan to connect to the grid tomorrow, full power by the end of the week.
SIC |  | 4911
Plant ID |  | 1012648
Unit ID |  | 1003693
Outage ID |  | 11685
Spreadsheet: 0210acf3-9a70-46e3-a2b4-46ce8a5db10b
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1240.169 | 33.02 | 49.115 | 0 | 1579.949
 | [NAME] | 116.275 | 59.718 | 62.534 | 1257.314 | 34.588 | 48.575 | 0 | 1579.004
 | [NAME] | 138.897 | 70.856 | 64.409 | 1259.428 | 36.164 | 49.655 | 20.24 | 1639.649
 | [NAME] | 139.635 | 76.694 | 64.697 | 1264.303 | 31.228 | 49.655 | 2.76 | 1628.972
 | MY Sep-Aug | 521.055 | 272.379 | 257.926 | 5021.214 | 135 | 197 | 23 | 6427.574
2011/12 | Q1 Sep-Nov | 119.607 | 77.97 | 64.635 | 1268.06 | 33.02 | 50.1 | 0 | 1613.392
 | [NAME] | 114.999 | 71.005 | 62.018 | 1304.873 | 34.588 | 50.1 | 0 | 1637.583
 | [NAME] | 135.734 | 73.136 | 62.214 | 1246.99 | 36.164 | 49.899 | 23.401 | 1627.538
 | MY Sep-Aug | 495 | 285 | 250 | 5000 | 135 | 200.7 | 24.3 | 6390
2012/13 | MY Sep-Aug | 465 | 285 | 235 | 4500 | 135 | 205 | 25 | 5850
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 9/12/2012
Spreadsheet: 275356d1383482794-match-2-criteria-2-criteria-match-index
Sheet: Sheet1

[NAME] :
 | Company | Code |  |  |  | Name | Sector |  | helper column | Company | Code | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] |  |  |  | A | 1001 | [NAME] | Finance
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard |  |  |  | A | 1001 | Bernard | Finance
3 | A | 1002 | Member | 2010 | 11680 | Jong |  |  |  | A | 1002 | Jong | Finance
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME] |  |  |  | B | 1003 | [NAME] | Property
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME] |  |  |  | C | 1003 | [NAME] | Industries
 |  |  |  |  |  |  | =INDEX($N$5:$N$9;MATCH(1;($K$5:$K$9=B9)*($M$5:$M$9=G9);0))
OR Non Array Formula Below :
 | Company | Code |  |  |  | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] |  | =INDEX($N$5:$N$9;SUMPRODUCT(($K$5:$K$9=B27)*($M$5:$M$9=G27)*(ROW($1:$5))))
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard
3 | A | 1002 | Member | 2010 | 11680 | Jong
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME]
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME]
 | Company | Code |  |  |  | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] |  | =VLOOKUP(B35&"-"&G35;$J$5:$N$9;5;0)
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard
3 | A | 1002 | Member | 2010 | 11680 | Jong
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME]
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME]
 | Company | Code |  |  |  | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] |  | =LOOKUP(1;1/(B42&G42=K5:K9&M5:M9);N5:N9)
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard
3 | A | 1002 | Member | 2010 | 11680 | Jong
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME]
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME]
 | Company | Code |  |  |  | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] |  | =LOOKUP(2;1/($K$5:$K$9=B48)/($M$5:$M$9=G48);($N$5:$N$9))
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard
3 | A | 1002 | Member | 2010 | 11680 | Jong
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME]
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME]
Spreadsheet: 674900d1588073189-count-unique-values-from-one-column-based-on-value-in-other-column-example
Sheet: Tab 2

ID | Colour
28 | Red
28 | Red
28 | Red
28 | Blue
28 | Yellow
28 | Grey
28 | Grey
28 | Green
28 | Green
28 | Green
28 | Green
15 | Blue
15 | Yellow
15 | Yellow
15 | Yellow
Spreadsheet: 823679d1680088354-group-4-data-sets-into-one-boooook-4-
Sheet: Sheet2

ID | Surname | First Name | CODE | Value 1 | ID | Surname | First Name | CODE | Value 2 | ID | Surname | First Name | CODE | Value 3 | ID | Surname | First Name | CODE | Value 4 |  |  | Surname | First Name | CODE | Value 1 | Value 2 | Value 3 | Value 4
111 | aaa | aaa | xxx | 70 | 111 | aaa | aaa | xxx | 1 | 555 | eee | eee | xxx | 5 | 555 | eee | eee | yyy | 5 |  | 111 | aaa | aaa | xxx | 70 | 1 | 0 | 70
222 | bbb | bbb | ooo | 48 | 222 | bbb | bbb | xxx | 2 |  |  |  |  |  | 111 | aaa | aaa | xxx | 70 |  | 222 | bbb | bbb | ooo | 48 | 0 | 0 | 0
333 | [NAME] | [NAME] | yyy | 59 | 333 | [NAME] | [NAME] | yyy | 3 |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | xxx | 0 | 2 | 0 | 0
444 | ddd | eee | ggg | 84 | 444 | ddd | ddd | yyy | 4 |  |  |  |  |  |  |  |  |  |  |  | 333 | [NAME] | [NAME] | yyy | 59 | 3 | 0 | 0
555 | eee | eee | hhh | 86 | 555 | eee | eee | abc | 5 |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | eee | ggg | 84 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | yyy | 0 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | hhh | 86 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | abc | 0 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx | 0 | 0 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy | 0 | 0 | 0 | 5
Spreadsheet: 770051d1645794350-dropdown-list-from-multiple-sheets-example-3-
Sheet: Example

[NAME] |  | 2021 | 2021 | 2021 | 2021 |  | 2022 |  |  |  |  | 2023
Quarterly Financials Summary File
Company 1
Updated per: | 31/12/2021 | Q1 | Q2 | Q3 | Q4 | Comments | Q1 | Q2 | Q3 | Q4 | Comments | Q1 | Q2 | Q3 | Q4 | Comments
Company 1 | Revenues | 123 | 123 | 123 | 123 |  | 111 | 222 | 333 | 444
Company 1 | Gross Income | 345 | 345 | 345 | 345 |  | 777
Company 1 | EBITDA | 456 | 456 | 456 | 456 |  | 555
Company 1 | Cash & Cash Equivalents | 567 | 569 | 567 | 567 |  | 666
Company 2 | Revenues | 987
Company 2 | Gross Income
Company 2 | EBITDA
Company 2 | Cash & Cash Equivalents
Spreadsheet: 0615467e-4487-4600-acd8-0ce9900a3e7d
Sheet: Table 5.4

Monthly Statistical Bulletin
5.4 Home loan affordability
Quarter | 2009-10 | 2010-11 | 2011-12 | 2012-13 | 2013-14
Average size of new home loan (a) – $
September | 292795 | 326733 | 323572 | 320495 | 321427
December | 308764 | 329159 | 317044 | 325792 | 337296
March | 316134 | 323183 | 311420 | 321700
June | 325553 | 328979 | 321127 | 321383
Annual average | 309110.9720611516 | 327143.2771327381 | 318375.3964364378 | 322368.2748395301
Average monthly repayment on new home loans – $
September | 1746.653815210925 | 2205.178528061062 | 2258.474188097593 | 2176 | 1993
December | 1960.555475668386 | 2271.914192157253 | 2226.791504535607 | 2131 | 2092
March | 2019.69439471878 | 2239.838466872784 | 2196 | 2106
June | 2174.679556442804 | 2290.488099812118 | 2155 | 2050
Annual average | 1975.395810510224 | 2251.854821725804 | 2209.0664231583 | 2115.75
Loan repayments as a proportion of family income – per cent
September | 29.5 | 35.5 | 34.4 | 33.3 | 29.8
December | 32.4 | 36 | 33.5 | 32.5 | 30.8
March | 33 | 35 | 32.7 | 29.9
June | 35.2 | 35.4 | 31.9 | 31
Annual average | 32.6 | 35.5 | 33.1 | 31.6
(a) Excludes alterations and additions and refinancing.
Sources: Real Estate Institute of Australia and Adelaide Bank | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/
ABS, Housing Finance, Cat. no. 5609.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 9 April 2014 for lending
Spreadsheet: louise_kitchen__23859__TRProjects1
Sheet: Project Listing

Project Name | Enron Business Unit | Project Type I | Project Type/Description | Originator(s) | Responsible Tech Services | Technical Support | Location | $$ Exposure | Assessment of Risk | Updated | Update/Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBU | PT1
AMPS | North America - Principal Investing |  | Generation Technology - mobile power units | [NAME] | [NAME] | [NAME] | Various |  |  | 2001-03-13 00:00:00 | Waiting in AMPS to finalize Marketing Director hire.  Will do a turnover at that time.
[NAME] | North America - East |  | Development/Construction - Simple Cycle Project (~180 MW) | [NAME] | [NAME] | [NAME] | [NAME], TX |  |  | 2001-05-15 00:00:00 | Construction nearly complete.  Estimated completion = May 31, 2001.
Electrobolt | South America | [NAME] | Development/Construction - Simple Cycle Project (386 MW) | [NAME] | [NAME] | EEOS | Rio de Janeiro |  |  | 2001-05-15 00:00:00 | Site is under development - initial foundations and temporary facilities.  2 of 6 gas turbines to be shipped today to site.  EEOS/NEPCO are primary parties in construction.  Target Operation date = November 1, 2001.
Fort Pierce | North America - East |  | Repower Steam Plant using MHI 501D turbine | [NAME] | [NAME] | Darrell Stovall | Ft. Pierce, FL |  |  | 2001-04-30 00:00:00 | Team working last revision on FPUA agreements.  Engineering on hold waiting on DASH.  Looking for final negotiation.
Las Vegas Cogen | North America - West |  | Development/Construction - 4 @2x1 LM6000's combined cycle plant | [NAME] | [NAME] | [NAME], [NAME], [NAME] Dannhaus | Las Vegas, NV |  |  | 2001-05-15 00:00:00 | DASH executed.  EPC contractor has been selected (Modern Continental). NTP early next week
Columbia (Longview) | North America - West |  | Development/Construction 2 7FAs combined cycle.  Permitting underway | [NAME] | [NAME] | [NAME], [NAME], [NAME] | Port of Longview, WA |  |  | 2001-05-15 00:00:00 | Currently reviewing EPC contractor financial risk and execution risk.  Scott is current contractor being considered
Roseville | North America - West |  | Site acquisition underway.  Seeking to secure emission credits | [NAME] | [NAME] | [NAME] | No. California - near Sacramento |  |  | 2001-05-15 00:00:00 | I-DASH for early development work and purchase of emission credits
TexMex | North America - East |  | Development/Construction - Installation of AC/DC tie, power export to Mexico | Ozzie Pagan | [NAME] | [NAME], [NAME] | Brownsville, TX |  |  | 2001-04-23 00:00:00 | Interface with Brownsville public utility and ABB Engineering.  Currently on hold
Vitro | Mexico | [NAME] | Development/Construction - Combined Cycle Cogen Project (245 MW) | [NAME], [NAME], [NAME] | [NAME] | [NAME] | Monterrey, Mexico |  |  | 2001-05-15 00:00:00 | Engaged EPC Contractor (Mitsui).  Now in the early stage of construction.
EPC Negotiaion Team | Enron Americas | [NAME] | Lead EPC and turbine purchase contract discussions. | [NAME], [NAME], [NAME] | [NAME] | [NAME] | ENA |  |  | 2001-05-15 00:00:00 | Now focused on Ft. Pierce
Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: Hull_MA_

Symbol | Long/Short | Signal Date | Entry Date | Entry Price | Signal Exit | % Profit | Bars to | ATR Entry | Bar High | Bar Low
 |  |  |  |  |  | signal exit | signal exit
BCR | Long | 2011-11-04 00:00:00 | 2011-11-07 00:00:00 | 87.31
FIS | Long | 2011-11-04 00:00:00 | 2011-11-07 00:00:00 | 25.22 | 23.3 |  | 2
GS | Long | 2011-11-04 00:00:00 | 2011-11-07 00:00:00 | 104.95 | 92.36 |  | 3
RF | Long | 2011-11-04 00:00:00 | 2011-11-07 00:00:00 | 4.01
SEE | Long | 2011-11-04 00:00:00 | 2011-11-07 00:00:00 | 17.73
AA | Long | 2011-11-11 00:00:00 | 2011-11-14 00:00:00 | 10.53 | 9.38 |  | 2
WDC | Long | 2011-11-11 00:00:00 | 2011-11-14 00:00:00 | 26.45 | 25.77 |  | 2
MASI | Long | 2011-11-11 00:00:00 | 2011-11-14 00:00:00 | 22.24 | 19.1 |  | 1
GTIV | Long | 2011-11-11 00:00:00 | 2011-11-14 00:00:00 | 5.36
KID | Long | 2011-11-11 00:00:00 | 2011-11-14 00:00:00 | 3.17
Spreadsheet: 1dfef7e3-2548-4b6f-8d0c-a4b4aedcc284
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 821976d1679030561-auto-determine-percentage-of-increase-over-14-year-period-compounded-markup-calculator_mod
Sheet: Solver_setup

Year | Old Price | New Price |  | [NAME] need each year | Percent of Increase |  |  |  |  |  | Formula for Solver |  | Constraint
13 | 40.25 | 58 |  | 1.02850114053533 |  | 1.0285 = | 0.000285 |  |  |  |  | =
Year 1 |  | 2010
Year 2 |  | 2011
Year 3 |  | 2012
Year 4 |  | 2013
Year 5 |  | 2014
Year 6 |  | 2015
Year 7 |  | 2016
Year 8 |  | 2017
Year 9 |  | 2018
Year 10 |  | 2019
Year 11 |  | 2020
Year 12 |  | 2021
Year 13 |  | 2022
Year 14 |  | 2023
Spreadsheet: 774637d1648578091-why-does-the-trend-line-in-excel-show-me-a-wrong-r-2-trendline-r2-exp-regression
Sheet: Sheet1

X | Y | ln(Y) | est Y |  |  | ln(est Y)
9.3905 | 0.338413743 |  |  | Pearson
9.4055 | 0.051130936 |  |  | Pearson II
9.409 | 0.116011672
9.433 | 0.121103582 |  |  | LINEST with Ln Y
9.448 | 0.084803205 |  |  |  | 40.52865100455814
9.49 | 0.06854196 |  |  | 1.016806592535629 | 9.712881582236893
9.5055 | 0.040290114 |  |  | 0.5885847481947372 | 0.453858587655687
9.5205 | 0.032241627 |  |  | 20.02887943159357 | 14
9.578 | 0.035526723 |  |  | 4.125701157087579 | 2.88382664624341
9.5935 | 0.047681584
9.637 | 0.030270569 |  |  | LINEST with Y transformed
9.649 | 0.03404843 |  |  |  | 40.52865100455814
9.6635 | 0.027642492 |  |  | 1.016806592535629 | 9.712881582236893
9.678 | 0.03946884 |  |  | 0.5885847481947372 | 0.453858587655687
9.7065 | 0.038976075 |  |  | 20.02887943159357 | 14
9.7195 | 0.028628021 |  |  | 4.125701157087579 | 2.88382664624341
 |  |  |  | RSQ(y, estY) |  |  | RSQ(ln(y),ln(estY))
Spreadsheet: 809728d1671269632-apply-conditional-formatting-based-on-conditions-of-whole-column-excel-forum-17_v2
Sheet: Sheet1

 |  |  |  | formatting cell
Unit | weight per unit |  |  |  |  | if all weights in column B have a unit of KG than highlight cell E1 in green color
Kg | 13 |  |  |  |  | if there is any weight in column A that is not [NAME] than highlight cell E1 in red
Kg | 23 |  |  |  |  | if any unit is available in column A but with a zero weight value in column B than highlight cell E1 in red color
Kg | 3
Kg | 323
Kg | 23
Kg | 3
Kg | 213
Kg | 213
Kg | 43
Kg | 34
Kg | 13
Kg | 24
Kg | 3
Kg | 23
Kg | 3
Kg | 23
Kg | 34
Kg | 45
Kg | 65
Kg | 56
Kg | 76
Kg | 87
Kg | 4
Kg | 34
Kg | 234
Kg | 21
Kg | 12
Kg | 123
Spreadsheet: 91210d1290968861-excel-2007-identify-unique-employees-and-employees-with-a-change-in-hours-mcmugs-sample-data
Sheet: CARLA MCIVOR_CM - General Assig

Employee | HRS
[NAME] (10114) | 16.75
Employee XYZ(10114) | 16.75
Employee ABC (20457) | 40
Employee ABC (20457) | 40
Employee BCD (31358) | 0
Employee BCD (31358) | 17.5
Employee RST(31284) | 22
Employee RST(31284) | 32.5
Employee BXX (41823) | 26.5
Employee BXX (41823) | 10
Employee BMD (41231) | 24.5
Employee EJE (41281) | 20
Employee FDE (20282) | 40
Employee FEJ (20200) | 40
Employee FEJ (20200) | 40
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 15 Feb 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-02-15 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | Absent | Absent | [NAME] | Absent, Called not answer, checked with Al Majlis Team informed not reported
[NAME] | 1897 | Manager | Annual | Annual | EFS | Annual
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 824844d1680886557-data-flow-from-main-sheet-to-another-tab-main
Sheet: Main

Active | SR NO | ORDER DATE | AGEING | ORDER STATUS | CLIENT NAME | COUNTRY | CATEGORY | QTY | TOTAL order received | BALANCE order TO SOURCE | DELHI | CHD | CHENNAI | DLC | MUM CNF | PSK | TOTAL order received | BALANCE order TO SOURCE
Active | 1 | 44986 | 37 | Active | ABC Corporation | India | Bulb | 50 | 1 | 49 |  | 1 |  |  |  |  | 1
Inactive | 2 | 44987 | 36 | Inactive | DEF Corporation | India | Tubelights | 25 | 2 | 23 |  |  | 1 | 1 |  |  | 2
Hold | 3 | 44988 | 35 | Hold | GHI Corporation | India | Fan | 35 | 3 | 32 |  |  |  |  | 3 |  | 3
Closed | 4 | 44989 | 34 | Closed | JKL Corporation | India | Geyser | 20 | 4 | 16 |  | 1 |  | 1 | 1 | 1 | 4
Spreadsheet: 90228d1289990238-merge-full-text-with-correct-abbreviation-example
Sheet: Finish

Full name (list 1) | Result Abbreviation | Result ISSN | abbreviation + ISSN (List 2)
TEACHING IN HIGHER EDUCATION | TEACH HIGH EDUC | 1356-2517 | TEACH HIGH EDUC | 1356-2517
TEACHING OF PSYCHOLOGY | TEACH PSYCHOL | 0098-6283 | TEACH PSYCHOL | 0098-6283
TEACHING PHILOSOPHY |  |  | TEACH SOCIOL | 0092-055X
TEACHING SOCIOLOGY | TEACH SOCIOL | 0092-055X | TEACH TEACH EDUC | 0742-051X
TECHNICAL COMMUNICATION | TECH [NAME] | 0049-3155 | TECTONICS | 0278-7407
TECHNICAL PHYSICS | TECH PHYS+ | 1063-7842 | TECTONOPHYSICS | 0040-1951
TECHNICAL PHYSICS LETTERS | TECH PHYS LETT+ | 1063-7850 | TECH [NAME] | 0049-3155
 |  |  | TECH PHYS LETT+ | 1063-7850
 |  |  | TECH PHYS+ | 1063-7842