tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273525d1382736403-formula-to-operate-auto-filters-excel-2003-filter-1-
Sheet: new

Please pick the Day needed |  |  | MONDAY_B |  |  |  | LOWEST FILE IS__ |  | FILE 3
 |  |  |  | MONDAY_A | MONDAY_B | TUESDAY_A | TUESDAY_B | WEDNESDAY_A | WEDNESDAY_B
 |  |  | FILE 1 | 6 | 9 | 5 | 6 | 9 | 6
 |  |  | FILE 2 | 8 | 7 | 2 | 8 | 7 | 8
 |  |  | FILE 3 | 1 | 4 | 8 | 1 | 4 | 1
 |  |  | FILE 4 | 9 | 5 | 3 | 9 | 5 | 9
There is a drop down list in [NAME] linked to E7 to [NAME] is in J2 Ok the user picks a Day/AorB the formula returns the file on that day which holds the least items in it that’s working great What I need is somehow the 2 results from D2 and J2 to determin the auto filters J19 J20 and J21 and set them accordingly                                                                       So say user picks TUESDAY_B the missing formula will set AUTOFILTERS to  J19 TUESDAY K19 B and L19 3                         Thank you all for your help again .. I NEED FORMULA USING EXCEL 2003
 |  |  |  |  |  |  |  |  | DAY | A/B | FILE
 |  |  |  |  |  |  |  |  | MONDAY | A | 1
 |  |  |  |  |  |  |  |  | MONDAY | A | 1
 |  |  |  |  |  |  |  |  | MONDAY | A | 2
 |  |  |  |  |  |  |  |  | MONDAY | B | 2
 |  |  |  |  |  |  |  |  | MONDAY | B | 3
 |  |  |  |  |  |  |  |  | MONDAY | B | 3
 |  |  |  |  |  |  |  |  | TUESDAY | A | 1
 |  |  |  |  |  |  |  |  | TUESDAY | A | 1
 |  |  |  |  |  |  |  |  | TUESDAY | A | 2
 |  |  |  |  |  |  |  |  | TUESDAY | B | 2
 |  |  |  |  |  |  |  |  | TUESDAY | B | 3
 |  |  |  |  |  |  |  |  | TUESDAY | B | 3
 |  |  |  |  |  |  |  |  | WEDNESDAY | A | 1
 |  |  |  |  |  |  |  |  | WEDNESDAY | A | 1
 |  |  |  |  |  |  |  |  | WEDNESDAY | A | 2
 |  |  |  |  |  |  |  |  | WEDNESDAY | B | 2
 |  |  |  |  |  |  |  |  | WEDNESDAY | B | 3
 |  |  |  |  |  |  |  |  | WEDNESDAY | B | 3
Spreadsheet: 156799d1337469919-using-large-small-when-same-values-exist-drafttest
Sheet: Sheet

ID | Name | Rank |  |  |  | Picked? | Height | Height | Lbs | Age | Exp |  | Highest rank unpicked players? |  |  |  | Tallest unpicked players?
2 | [NAME] | 16 |  |  |  | yes | 5' 10' | 5.833333333333333 | 180 | 24.24657534246575 | 8 |  | ID | Name | Rank |  | ID | Name | Height
3 | [NAME] | 16 |  |  |  | yes | 6' 2' | 6.166666666666667 | 175 | 35.04657534246575 | 17
4 | [NAME] | 15 |  |  |  | NO | 6' 5' | 6.416666666666667 | 200 | 41.88219178082192 | 14
5 | [NAME] | 15 |  |  |  | NO | 5' 11' | 5.916666666666667 | 160 | 25.64109589041096 | 8
6 | [NAME] | 15 |  |  |  | NO | 5' 10' | 5.833333333333333 | 160 | 36.13424657534247 | 14
7 | [NAME] | 15 |  |  |  | NO | 5' 11' | 5.916666666666667 | 175 | 27.44931506849315 | 8 |  | Youngest unpicked players? |  |  |  | Most experienced unpicked players?
8 | Greg | 15 |  |  |  | NO | 6' 1' | 6.083333333333333 | 175 | 26.07123287671233 | 4 |  | ID | Name | Age |  | ID | Name | Exp
9 | Zack | 14 |  |  |  | NO | 6' 5' | 6.416666666666667 | 140 | 27.85753424657534 | 9
10 | [NAME] | 14 |  |  |  | NO | 6' 0' | 6 | 190 | 45.42465753424658 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Youngest is the only one that works because the values are actually different.
 |  |  |  |  |  |  |  |  |  |  |  |  | It works because the ages are not the same, they're rounded.
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] is really 25.6 and [NAME] is 26, which is why it works.
 |  |  |  |  |  |  |  |  |  |  |  |  | When the values are exactly the same, like Rank and Height and Experience, the ID formula grabs the 1st value then doesn't exclude it
 |  |  |  |  |  |  |  |  |  |  |  |  | If there are three players ranked 15 that haven't been picked, is there a way to exclude the same ID for appearing more than once?
Spreadsheet: 788955d1658822730-index-function-with-variable-columns-excel-forum
Sheet: Product A

T-Roc
Verlustart | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Anwesenheitszeiten |  |  |  |  |  |  |  |  | 494
Pausen |  |  |  |  |  |  |  |  | -69.88333333333333
Arbeitszeit |  |  |  |  |  |  |  |  | 424.1166666666667
[NAME] |  |  |  |  |  |  | 10 |  | 0
[NAME] |  |  |  |  |  |  | 5 |  | 0
Rüsten |  |  |  |  |  |  |  |  | -30
Nettoarbeitszeit |  |  |  |  |  |  |  |  | 394.1166666666667
[NAME] |  |  |  |  |  |  | 7 |  | 0
Logistikanlagenstörung |  |  |  |  |  |  | 25 |  | 0
Schulung / Einarbeitung |  |  |  |  |  |  | 8 |  | 5
Fehlteil |  |  |  |  |  |  | 0 |  | 20
[NAME] |  |  |  |  |  |  | 0 |  | 0
[NAME] |  |  |  |  |  |  | 0 |  | 0
Sonstige Mikrostillstände |  |  |  |  |  |  | 2 |  | 6
[NAME] |  |  |  |  |  |  |  |  | 394.1166666666667
Teilequalität |  |  |  |  |  |  | 5 |  | 0
Rotverschraubung |  |  |  |  |  |  | 4 |  | 4
Nacharbeit |  |  |  |  |  |  | 0 |  | 0
Effektive Arbeitszeit |  |  |  |  |  |  |  |  | 394.1166666666667
Undokumentiert |  |  |  |  |  |  | 55 |  | -65.03991666666661
Rückgemeldete Te-Zeiten |  |  |  |  |  |  |  |  | 329.0767500000001
Produktivität
Spreadsheet: 34410d1231674681-lookup-tables-conditonal-formatting-excel-2007-test1
Sheet: Sheet1

Surname | test1 | test2 | test3
davies | 34 | 21 | 56
jones | 36 | 34 | 34
[NAME] | 23 | 45 | 45 |  |  |  | mark | grade
 |  |  |  |  |  |  | 20 | d
 |  |  |  |  |  |  | 30 | c
 |  |  |  |  |  |  | 40 | b
 |  |  |  |  |  |  | 50 | a
Surname | test1 | test2 | test3
davies | c | d | a
jones | c | c | c
[NAME] | d | b | b
Spreadsheet: 878618d1725791474-cost-centre-account-division-reporting-excel-forum-1
Sheet: Sheet1

Type | Account | Account Code(T) | Category | Cost Centre | Cost Centre(T) | Division | Period | Budget Value | Actual Value
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Apr | 39000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | May | 39000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Jun | 45000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Jul | 45000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Aug | 45000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Sep | 45000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Oct | 50000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Nov | 50000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Dec | 50000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Jan | 50000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Feb | 50000 | 10000
Budget | R1101 | Salaries |  | [NAME] | Cost Centre 1 | Division 2 | Mar | 50000 | 10000
Budget | R1203 | Agency Staff & Contractor Costs |  | [NAME] | Cost Centre 1 | Division 2 | Apr | 20000 | 10000
Budget | R1203 | Agency Staff & Contractor Costs |  | [NAME] | Cost Centre 1 | Division 2 | May | 20000 | 10000
Budget | R1203 | Agency Staff & Contractor Costs |  | [NAME] | Cost Centre 1 | Division 2 | Jun | 10000 | 10000
Budget | R1203 | Agency Staff & Contractor Costs |  | [NAME] | Cost Centre 1 | Division 2 | Jul | 10000 | 10000
Budget | R1203 | Agency Staff & Contractor Costs |  | [NAME] | Cost Centre 1 | Division 2 | Aug | 10000 | 10000
Spreadsheet: 9c85d599-0f19-41ce-ab31-44e13c0e1794
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
40225144 | 2014-02-25 00:45:49 | AXIS | 0 | 3 | 7 | 790502 | spiderQ | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40225410 | 2014-02-25 01:05:05 | ALLIES | 0 | 2 | 6 | 1009110 | HO-SA-KAI | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
40225623 | 2014-02-25 01:19:29 | AXIS | 0 | 2 | 6 | 1009110 | HO-SA-KAI | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
Spreadsheet: 177338d1346266830-index-match-with-row-information-offset-from-the-match-cell-sample-1
Sheet: How it should Look

 |  | Revenue
 |  | July Production |  | August Production
Clinical Affairs |  | 50 |  | 50
Community Health July 2012(07/01/2012 - 07/31/2012) |  | 200 |  | 200
Dental Hygiene July 2012(07/01/2012 - 07/31/2012) |  | 0 |  | 0
Diagnostic Science July 2012(07/01/2012 - 07/31/2012) |  | 125 |  | 125
Endodontics July 2012(07/01/2012 - 07/31/2012) |  | 920 |  | 920
Special Care July 2012(07/01/2012 - 07/31/2012) |  | -150 |  | -150
Implant July 2012(07/01/2012 - 07/31/2012) |  | 1300 |  | 1300
Oral Surgery July 2012(07/01/2012 - 07/31/2012) |  | 650 |  | 650
Pedo July 2012(07/01/2012 - 07/31/2012) |  | 1000 |  | 1000
Periodontics July 2012(07/01/2012 - 07/31/2012) |  | 800 |  | 800
Spreadsheet: 44b55885-7e8a-43b4-901f-0dc79dd05ce3
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 21. Output of the Transport, postal and warehousing industries, group and class index numbers
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
Index Numbers ;  461 Road freight transport ; |  |  | Original | [NAME] | 1997-03-01 00:00:00 | 2013-03-01 00:00:00 | 65 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  471 Rail freight transport ; |  |  | Original | A2314067L | 1996-03-01 00:00:00 | 2013-03-01 00:00:00 | 69 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  481 Water freight transport ; |  |  | Original | A2314076R | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5021 Pipeline transport ; |  |  | Original | A2314103K | 2000-09-01 00:00:00 | 2013-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  510 Postal and courier pick-up and delivery services ; |  |  | Original | A3344046F | 2001-09-01 00:00:00 | 2013-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  521 Water transport support services ; |  |  | Original | A2314115V | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5211 Stevedoring services ; |  |  | Original | A2314118A | 1996-03-01 00:00:00 | 2013-03-01 00:00:00 | 69 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5212 Port and water transport terminal operations ; |  |  | Original | A3343946V | 2001-09-01 00:00:00 | 2013-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5219 Other water transport support services ; |  |  | Original | [NAME] | 1998-03-01 00:00:00 | 2013-03-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  522 Airport operations and other air transport support services ; |  |  | Original | A2314130T | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5291 Customs agency services ; |  |  | Original | A2314139L | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  530 Warehousing and storage services ; |  |  | Original | A2314145J | 1996-09-01 00:00:00 | 2013-03-01 00:00:00 | 67 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5301 Grain storage services ; |  |  | Original | A2314148R | 1996-03-01 00:00:00 | 2013-03-01 00:00:00 | 69 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5309 Other warehousing and storage services ; |  |  | Original | A2314151C | 1996-09-01 00:00:00 | 2013-03-01 00:00:00 | 67 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 34f6d07a-a8b0-4599-9e31-884899346416
Sheet: BMT Fleet

Car Numbers | Type | Coupling | Builder | Year Built | Notes
Gate Cars
1-271 | Trailers |  |  | Built prior to 1900 | modified for electric service
600-683 | Motors
700-760 | Motors
800-859 | Motors
900-941 | Motors
1000-1119 | Motors
1200-1299 | Motors |  |  | 1903 | Osgood-Bradley, Brill, Laconia, and [NAME] car companies
1300-1399 | Motors |  |  | 1905-1906 | Laconia, Cincinatti, and [NAME] car companies
1400-1499 | Motors |  |  | 1907 | Osgood-Bradley, Brill, Laconia, and [NAME] car companies
BMT C-Type (Elevated Car Conversions)
1500ABC-1529ABC | C Type | Three-car sets | See above | 1922-1923 | Motor cars from 1200 and 1400 series and trailer cars from 146-190 series.
BMT Q-Type (Elevated Car Conversions)
1600ABC-1629ABC | Q Type | Three-car sets | See Above | 1938 | Q-Types arranged motor-trailer-motor
1630AB-1641AB | QX Type | Two-car sets | See Above | 1938 | QX-types A car was motorized, B car was unmotored cab car.
BMT "Standards" (aka "Steels")
2000-2599 | Motors | Originally single; see below | ACF | 1914-1919
2600-2699 | Motors | Originally single; see below | Pressed Steel | 1920
2700-2799 | Motors | Originally single; see below | Pressed Steel | 1921
2800-2899 | Motors | Originally single; see below | Pressed Steel | 1922
4000-4049 | Trailers | Originally single; see below | Pressed Steel | 1924
"A" Cars | Single motors; originally 2500, 2600-2699, 2700-2749
"B" Cars | Three-car sets; originally 2000-2499, 2501-2599, 2750-2899
"AX" Cars | Three car set with two "A" motors and a trailer, motor-trailer-motor; originally 2700-4040-2701 to 2718-4049-2719
"BX" Cars | B set with middle trailer car, motor-trailer-motor; originally 2400-4000-2401 to 2478-4039-2479
BMT D-Type "Triplex" Articulated
6000ABC-6121ABC | D Type | Three-car articulated sets | ACF | 1925-1928
Other BMT Rolling Stock
7003A-B-C-B1-A1 | [NAME] | 5 section articulated | Pullman | 1934 | Original numbers 7000A-8000B-9000C-8001B-7001A; scrapped 1943
7029A-B-C-B1-A1 | Zephyr | 5 section articulated | Budd | 1934 | Original numbers 7002A-8002B-9001C-8003B-7003A; scrapped 1960
7004-7013 A-B-C-B1-A1 | Multisection | 5 section articulated | St. Louis | 1936
7014-7028 A-B-C-B1-A1 | Multisection | 5 section articulated | Pullman | 1936
8000-8005 A-B-A1 | Bluebird | 3 section articulated | [NAME] | 1938
2900-2924 | SIRT Motors
Spreadsheet: 266706d1379701549-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: Jessica

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-13 00:00:00 | General Lending Group | [NAME] | [NAME] | [NAME] | 36869 | asset >45
2013-03-14 00:00:00 | A C G Funding | [NAME] | [NAME] | Wei | 36683 | paystub >30 & assets >45 | 2 | 86
2013-04-30 00:00:00 |  |  |  |  |  |  | 0 | 154
2013-05-09 00:00:00 | General Lending Group | Qing Cao | Qing Cao | [NAME] | 38623 | paystub >30
2013-05-10 00:00:00 | United General | [NAME] | [NAME] | [NAME] | 38432 | expired paystubs & assets | 2 | 101
2013-06-03 00:00:00 | Prudential Mortgage Corp | [NAME] | Marina Gallegos | [NAME] | 39342 | missing asset statements for purchase
2013-06-03 00:00:00 | Greenland Capital Corp | [NAME] | [NAME] | Byllesby | 39340 | assets >45
2013-06-04 00:00:00 | Greenland Capital Corp | [NAME] | [NAME] | [NAME] | 39362 | paystub >30
2013-06-05 00:00:00 | Home Loan 123 | [NAME] | [NAME] | Luong | 39393 | paystub >30
2013-06-10 00:00:00 | Royal Global Realty | [NAME] | [NAME] | [NAME] | 39490 | assets >45
2013-06-17 00:00:00 | Prudential Mortgage Corp | [NAME] | [NAME] | [NAME] | 39628 | paystub >30
2013-06-24 00:00:00 | California Consumer Lending | [NAME] | [NAME] | Duong | 39677 | credit >45
2013-06-28 00:00:00 | Emory Financial | [NAME] | [NAME] | Cheung | 39894 | missing asset statement for purchase | 8 | 51
2013-07-02 00:00:00 | Home Loan 123 | Te-Chuan Chu | [NAME] | Duh | 40005 | missing 2012 W2
2013-07-05 00:00:00 | California Consumer Lending | [NAME] | [NAME] | Nimitrapra | 40073 | asset >45 & missing pages
2013-07-05 00:00:00 | SPD Mortgage | [NAME] | [NAME] | Wang | 40078 | assets missing pages
2013-07-08 00:00:00 | Top Leading Financial | [NAME] | [NAME] | Zhang | 40086 | paystub >30
2013-07-08 00:00:00 | Home Loan 123 | [NAME] | [NAME] | [NAME] | 40094 | paystub >30 & asset >45
2013-07-08 00:00:00 | Emerald 2000 Financial | Dorcas [NAME] | [NAME] | Chung | 40083 | asset >45
2013-07-10 00:00:00 | Apple Direct Funding Corp. | [NAME] | [NAME] | Morales | 40102 | paystub >30
2013-07-23 00:00:00 | Home Loan 123 | [NAME] | [NAME] | Wetovick | 40305 | asset stmt >45 | 8 | 77
2013-08-02 00:00:00 | SPD Mortgage, Inc. | [NAME] | [NAME] | [NAME] | 40589 | expired asset stmt | 1 | 40
3013-09-03 00:00:00 | SPD Mortgage, Inc. | [NAME] | [NAME] | Tajima | 40979 | assets >45 & missing pages
2013-09-11 00:00:00 | SPD Mortgage, Inc. | [NAME] | [NAME] | [NAME] | 41238 | missing current YTD paystubs
Spreadsheet: darrell_schoolcraft__7523__0202 NNG Lamar Nomination
Sheet: 02-(23)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-02-23 00:00:00 | sat
 |  |  |  | Ending Gas Day: | 2002-02-25 00:00:00 | mon
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 600
 |  |  | 600
 |  | 1 | 600
 |  | 2 | 600
 |  |  | 600
 |  |  | 600
 |  |  | 600
 |  |  | 800
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
Spreadsheet: 14209260-2aa5-4bed-b19e-e970414463ab
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Cuadro 1.2-023
[NAME]
Total de árboles plantados por año, según grupo de especies, 2003-2010
[NAME]
 | Total |  | Maderables |  | Promisorias |  | Frutales |  | Ornamentales |  | Medicinales |  | Otros |  | Sombras
 | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas | Arboles | Tareas
2003 | 11041485 | 162181 | 10316040 | 155295 | 258052 | 3215 | 467393 | 3671 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2004 | 6644283 | 122649 | 6527612 | 120222 | 42300 | 1151 | 74371 | 1276 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2005 | 6461300 | 122852 | 6224925 | 118959 | 44505 | 1136 | 191870 | 2757 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2006 | 5990488 | 109195 | 5929728 | 107660 | 47570 | 1212 | 13190 | 323 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2007 | 4536110 | 84714 | 4459376 | 82400 | 70194 | 2154 | 6540 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008 | 6412541 | 115580 | 6377956 | 114540 | 28135 | 738 | 6450 | 302 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009 | 6710498 | 124291 | 6610808 | 121442 | 24595 | 758 | 75095 | 2091 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010 | 8278007 | 79875 | 7941045 | 77472 | 19533 | 220 | 318162 | 2183 | 4862 | 53 | 860 | 10 | 9120 | 61 | 425 | 6
Fuente: Ministerio de Medio Ambiente y [NAME] ([NAME]).
Spreadsheet: 28003d1221762146-vlookup-extract-all-row-data-from-master-for-the-clients-listed-in-newsheet-newsheet
Sheet: Desired Outcome

Year | FY | FQ | Month | Week | Week # | Score | Status | Code | Company Name | Case Number | Topic | Reason | Close Date | Return Date | Associate | Manager | Comments
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 0 | Resolved | 2NF-0040 | Alpha | CA680228 | Miscellaneous | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 1 | Manager 1
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 0.33 | Resolved | B4F-0069 | Beta | CA675317 | Leave Plans | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 2 | Manager 2
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | TJ9-0010 | [NAME] | CA679678 | Benefit Plans | Other | 2007-06-28 00:00:00 | 2007-07-02 00:00:00 | Rep 3 | Manager 4
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | BRT-0032 | Alpha | CA676206 | HR Import | Create Template | 2007-06-20 00:00:00 | 2007-07-02 00:00:00 | Rep 4 | Manager 1
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | 3PN-0060 | Beta | CA680260 | Query | Design | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 5 | Manager 3
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | Q38-0052 | Beta | CA680007 | Person | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 6 | Manager 1
Spreadsheet: 861342d1709224746-formula-to-calculate-stepped-charges-stepped-charges-problem
Sheet: Problem

STEPPED | Start | End | Percentage | Value £ | Platform charge £ | Platform charge %
 | 0 | 149999.99 | 0.003 | 25000
 | 150000 | 999999.99 | 0.0025 | 50000
 | 1000000 | 2499999.99 | 0.002 | 75000
 | 2500000 | 5000000 | 0.0015 | 100000
 | 5000000 | 10000000 | 0.001 | 125000
 |  |  |  | 150000
 |  |  |  | 175000
 |  |  |  | 200000
 |  |  |  | 225000
 |  |  |  | 250000
 |  |  |  | 275000
 |  |  |  | 300000
 |  |  |  | 325000
 |  |  |  | 350000
 |  |  |  | 375000
 |  |  |  | 400000
 |  |  |  | 425000
 |  |  |  | 450000
 |  |  |  | 475000
 |  |  |  | 500000
 |  |  |  | 525000
 |  |  |  | 550000
 |  |  |  | 575000
 |  |  |  | 600000
 |  |  |  | 625000
 |  |  |  | 650000
 |  |  |  | 675000
 |  |  |  | 700000
 |  |  |  | 725000
 |  |  |  | 750000
 |  |  |  | 775000
 |  |  |  | 800000
 |  |  |  | 825000
 |  |  |  | 850000
 |  |  |  | 875000
 |  |  |  | 900000
 |  |  |  | 925000
 |  |  |  | 950000
 |  |  |  | 975000
 |  |  |  | 1000000
Spreadsheet: 156287d1337254533-building-multiple-charts-in-one-file-new-wt-and-cg-chart
Sheet: 4X HF - NO SAR

WEIGHT AND [NAME]BLOCK 1 AIRCRAFT
70116 4X HF - NO SAR
DATE | CG | ACFT WT | NOSE WT | TEETER ANGLE (INCHES) | SAR System | Small KU ANT. | Large KU ANT. | EO/IR System | WING PYLONS | HEA | OTHER | BALLAST STATION & AMOUNT |  |  |  |  |  |  | COMMENTS | Completed By | AMR Reference number | Employee #
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7