tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82c66af3-c57d-4cbe-a29b-25cc2d885bf8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
FORM D:  Annual Fee Franchise Fee Report Form - City of Portland, Oregon
This form is for use by companies subject to franchise compensation that is an annual fee.                 This form is not for use for submitting Minimum Annual Fees.
LINE 1a | Name of Company:_______________________________________________________
LINE 1b | Address (city, state, zip):_______________________________________________________
LINE 2 | Reporting Period:  Year:___________
LINE 3 | Fee Paid Last Year |  |  |  | $________________
LINE 4 | CPI change from Dec 31 of prior year to Dec 31 of report year |  |  |  | %________________
 | ( CPI figure to be provided by the City )
LINE 5 | Fee Increase ( multiply LINE 3 by LINE 4 ) |  |  |  | $________________
LINE 6 | Subtotal of fee ( add LINE 3 and LINE 5 ) |  |  |  |  | $________________
LINE 7 | Other Credits / Adjustments ( list all by source and amount; attach additional pages if needed ):
 | 1. Minimum Annual Fees previously paid for this year |  |  | $________________
 | 2. Other (specify) |  |  | $________________
 | TOTAL |  |  |  |  | $________________
LINE 8 | TOTAL FEE ( Subtract LINE 7 from LINE 6 for net credits; add LINE 7 to LINE 6 for net debits ) |  |  |  |  | $________________
Signature: |  |  |  |  | Date
_____________________________________________________________________________
Print name, title, telephone number and email address
I hereby certify that all statements made in this report and any of its attachments are true, complete and accurate to the best of my knowledge.
Remit to: City of Portland, Office for Community Technology, P.O. Box 745, Portland, OR 97207-0745
Form issue date:  12/29/09
Spreadsheet: 694708d1599757217-pull-dates-from-spreadsheet-to-populate-calendar-ef89_scheduler
Sheet: Calendar

 | Sunday | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 9
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2020
3
4
5
6
7
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name
1
2
3
4
5
6
7
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name
1
2
3
4
5
6
7
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name
1
2
3
4
5
6
7
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name
1
2
3
4
5
6
7
 |  | Details | Name
1
2
3
4
5
6
7
Spreadsheet: 275315d1383443308-ranking-up-to-15-numbers-in-column-d-ranking-skips-7-with-a-tie-at-6-and-2-book2
Sheet: Sheet1

78 | 73
62 | 70
79 | 76
66 | 76
78 | 71
83 | 76
61 | 76
68 | 76
74 | 74
81 | 92
Spreadsheet: 1e0c09d4-6e33-41f7-8ad7-7a670a08f8b3
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (22 Entries):
 | 2 Analysis 2.1 Analysis equipment 2.1.21 Analysis equipment, miscellaneous
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Alliance Instruments - AMS France Unity Scientific | France | Frepillon | 95740 | A1.406
2 | Berliner [NAME] [NAME] | Germany | Berlin | 12347 | A3.450
3 | Büchi Labortechnik GmbH | Germany | Essen | 45127 | A2.405
4 | CEM GmbH | Germany | Kamp-Lintfort | 47475 | A1.210
5 | ELEMENTAR Analysensysteme GmbH | Germany | Hanau | 63452 | A2.315/414
6 | Erweka GmbH | Germany | Heusenstamm | 63150 | A1.303
7 | Helmut Fischer GmbH Institut für Elektronik und [NAME] | Germany | Sindelfingen | 71069 | A1.204
8 | FOSS GmbH | Germany | [NAME] | 25462 | A1.505
9 | J&M Analytik AG | Germany | [NAME] | 73457 | A2.550
10 | K-MAC | South Korea | Daejeon | 305500 | A3.560
11 | Labindia Analytical Instruments Pvt.Ltd. | India | Thane | 400602 | A1.540
12 | Laborgerätebörse GmbH | Germany | Burladingen | 72393 | A2.313/412
13 | LECO Instrumente GmbH | Germany | Mönchengladbach | 41199 | A1.324
14 | LRE Medical GmbH Esterline Corporation | Germany | München | 80807 | A3.411A
15 | Micromeritics GmbH | Germany | Aachen | 52072 | A1.118
16 | PHARMA TEST Apparatebau AG | Germany | Hainburg | 63512 | A1.506
17 | [NAME] | Germany | Waldbronn | 76337 | A2.217
18 | PMT Analytical GmbH & Co.[NAME] | Germany | Ulm | 89077 | A2.100
19 | [NAME] | Germany | Aachen | 52064 | A3.142
20 | Seiko Instruments GmbH | Germany | Neu-Isenburg | 63263 | A2.518
21 | SPECTRO Analytical Instruments GmbH | Germany | Kleve | 47533 | A2.201/302
22 | Teledyne Germany GmbH | Germany | Kreuztal | 57223 | A1.419
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q3FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 1053 |  | 0 |  | 357 |  | 0 |  | 0 |  | 0 |  | 1410
Cost of revenue | 586 |  | -3 |  | 0 |  | 0 |  | -1 |  | 0 |  | 582
Gross profit | 467 |  | 3 |  | 357 |  | 0 |  | 1 |  | 0 |  | 828
Operating expenses:
Marketing and sales | 253 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 247
General and administrative | 75 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 65
Research and development | 273 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 244
Acquisition-related contingent consideration | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 14 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 154 |  | 0 |  | 0 |  | -154 |  | 0 |  | 0 |  | 0
Total operating expenses | 770 |  | -15 |  | 0 |  | -154 |  | -45 |  | 0 |  | 556
Operating income (loss) | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Interest and other income, net | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for income taxes | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Provision for income taxes | 19 |  |  |  |  |  |  |  |  |  | 57 |  | 76
Net income (loss) | -322 |  | 18 |  | 357 |  | 154 |  | 46 |  | -57 |  | 196
Loss per share |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.97 |  |  |  |  |  |  |  | Basic |  |  |  | 0.59
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.59
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 332 |  |  |  |  |  |  |  | Basic |  |  |  | 332
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 335
Spreadsheet: 97859d1296969345-autofill-from-a-matrix-when-2-constants-are-know-indexmatch
Sheet: Worksheet

Item | Activity | Hazard / Threat | Pre-controlled |  |  | Controls | Controlled Risk Assessment |  |  | Remaining Action | Person who will ensure the controls are implemented
 | Break the job down into steps that involve any potential hazards | Identify the risks associated with each step. Examine each to find possibilities that could lead to an accident or adverse environmental impact | Risk Assessment |  |  | What actions are necessary to eliminate or minimise the hazards that could lead to an accident, injury or occupational illness. | (Only req’d where Pre-controlled Risk Class is H, V or E) |  |  | List any of the reactive control measures that will be implemented in the event of an accident / incident (i.e. Emergency response procedures,).
 |  |  | Pre-controlled Likelihood | Pre-controlled Consequence | Pre-controlled Risk Class |  | Controlled Likelihood | Controlled Consequence | Controlled Risk Class
1 | Job Setup | No Induction | Almost certain | Insignificant | MEDIUM | Before starting work onsite, all personnel must be Site Specific Inducted. | Possible | Insignificant | LOW | All Personnel
 |  | Sunburn & Dehydration | Unlikely | Moderate | MEDIUM | Always maintain a clean work area. Remove all obstacles and obstructions to prevent trips and falls. | Almost certain | Minor | MEDIUM | All Personnel
 |  | Slips, Trips and falls | Unlikely | Catastrophic | VERY HIGH |  | Rare | Moderate | LOW | All Personnel
 |  | Want this column to work on a list validation from the hazards and controls page. But want the [NAME] o come up when the hazard is selected |  |  |  | Want this column to autofill when the precontrolled likelihood and precontrolled consequence is completed. Risk class can be found on the matrix page
 |  |  |  |  | Insignificant
Spreadsheet: 858398d1707120699-options-in-filter-arent-alphabetical-examplenumeric
Sheet: Blad2

Artikelgroep | (Alle)
Rijlabels
46
125
0004
0005
0006
0007
0009
0014
0016
0019
0020
0021
0062
0063
0066
0072
0073
0089
0097
0098
0099
0100
0101
0105
0106
0108
(leeg)
Eindtotaal
Spreadsheet: 875565d1722178743-calculating-accounts-receivables-excel-forum-sample-jumanarimawi-
Sheet: Working capital

Working Capital
Sanad Credit Financial Model |  |  |  |  |  |  |  |  |  | Index!A1
Financial Model Currency: JOD
 |  |  | Financial Month End
 |  |  | Financial Year
 | Working capital
 |  |  | Change in Receivables
 |  |  | OPEX
 |  |  | Payables (30days)
 |  |  | Change in Payables
 |  |  | Total change in Working Capital
Spreadsheet: fletcher_sturm__10918__0521 Cash Sheet
Sheet: Sheet1

2001-05-21 00:00:00
Cinergy |  |  |  | Entergy
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-22 00:00:00 | 21 | 23.5 |  | 2001-05-22 00:00:00 | 21 | 24
May 23-31, 2001 | 32 | 34 |  | May 23-31, 2001 | 39 | 40
May 23-25, 2001 | 25 | 26 |  | May 23-25, 2001 | 0 | 0
May 28 - June1, 2001 | 40 | 41 |  | May 28 - June1, 2001 | 0 | 0
June, 2001 | 56.2 | 56.3 |  | June, 2001 | 63.5 | 64.5
July/August, 2001 | 84.5 | 88.5 |  | July/August, 2001 | 96 | 99
September, 2001 | 37.7 | 38 |  | September, 2001 | 44.25 | 44.75
Oct/Nov/Dec, 2001 | 36 | 36.5 |  | Oct/Nov/Dec, 2001 | 38.75 | 39.25
Jan/Feb 2002 | 39.75 | 40.25 |  | Jan/Feb 2002 | 41 | 42
Cal 2002 | 44.25 | 45 |  | Cal 2002 | 45.25 | 46.25 | 52.5
March/April , 2002 | 35.25 | 35.75 |  | March/April , 2002 | 36 | 37
May, 2002 | 41.5 | 42 |  | May, 2002 | 42.25 | 43.25
June, 2002 | 54 | 54.5 |  | June, 2002 | 55.5 | 56.5
July/August, 2002 | 73 | 74 |  | July/August, 2002 | 73 | 75
Sept, 2002 | 34.5 | 35 |  | Sept, 2002 | 35.75 | 36.75
Q4, 2002 | 33.75 | 34.25 |  | Q4, 2002 | 33.75 | 34.75
Cal 2003 | 40.25 | 41 |  | Cal 2003 | 0 | 0
Cal 2004 | 39 | 40.25
Cal 2005 | 38.5 | 39.75
Comed |  |  |  | TVA
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-22 00:00:00 | 21 | 23 |  | 2001-05-22 00:00:00 | 20 | 24
May 23-31, 2001 | 0 | 0 |  | May 23-31, 2001 | 33.5 | 34.5
May 23-25, 2001 | 23.5 | 24.25 |  | May 23-25, 2001 | 0 | 0
May 28 - June1, 2001 | 28 | 30 |  | May 28 - June1, 2001 | 30 | 32
May 28 - June1, 2001 | 36 | 39.5 |  | May 28 - June1, 2001 | 0 | 0
June, 2001 | 52 | 53 |  | June, 2001 | 57.25 | 58.25
July/August, 2001 | 79.5 | 84.5 |  | July/August, 2001 | 91.5 | 94.5
September, 2001 | 35.5 | 36 | 117 | September, 2001 | 40 | 40.5
Oct/Nov/Dec, 2001 | 34.5 | 35 |  | Oct/Nov/Dec, 2001 | 37.25 | 37.75
Jan/Feb 2002 | 37.25 | 37.75 |  | Jan/Feb 2002 | 44.25 | 45.25
Cal 2002 | 42.5 | 43.25 |  | Cal 2002 | 44.25 | 45.25
March/April , 2002 | 34.75 | 35.25 |  | March/April , 2002 | 34.75 | 35.75
May, 2002 | 39.75 | 40.25 |  | May, 2002 | 41 | 42
June, 2002 | 51.5 | 52 |  | June, 2002 | 54.25 | 55.25
July/August, 2002 | 69 | 71 |  | July/August, 2002 | 73 | 75
Sept, 2002 | 34.25 | 34.75 |  | Sept, 2002 | 34.75 | 35.75
Q4, 2002 | 33 | 33.5 |  | Q4, 2002 | 33.75 | 34.75
Cal 2003 | 39 | 40.25 |  | Cal 2003 | 39.75 | 40.75
PJM
 | bid | offer
 | 0 | 0
June, 2001 | 55.5 | 56
July/August, 2001 | 83 | 86
September, 2001 | 41 | 41.5
Oct/Nov/Dec, 2001 | 37.25 | 37.75
Jan/Feb 2002 | 43.25 | 44
Cal 2002 | 45.5 | 46.25
March/April , 2002 | 36.75 | 38.25
May, 2002 | 41.5 | 42.5
June, 2002 | 53.5 | 55.5
July/August, 2002 | 73.25 | 75.25 | 91
Sept, 2002 | 35 | 36
Q4, 2002 | 34.25 | 35.25
Cal 2003 | 0 | 0
Spreadsheet: 52991df6-8abf-40b0-aca3-5797d1d2e86d
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
40420128 | 2014-03-08 21:54:15 | AXIS | 0 | 4 | 6 | 208140 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
40420504 | 2014-03-08 22:17:06 | ALLIES | 1 | 6 | 4 | 208140 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
40436991 | 2014-03-09 21:52:35 | AXIS | 1 | 7 | 6 | 780263 | Danjou | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40437947 | 2014-03-09 22:30:26 | ALLIES | 0 | 5 | 7 | 780263 | Danjou | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 87722d1287587039-formula-for-only-calculating-specific-rows-book2
Sheet: Sheet1

 |  |  |  | Seconds (Change for 2)
 | 1 | 2010-10-19 12:00:00
 | 2 | 2010-10-19 12:14:24 | 2010-10-19 12:14:24
 | 1 | 2010-10-19 12:28:48 | 2010-10-19 12:14:24 | 0
 | 1 | 2010-10-19 12:43:12 | 2010-10-19 12:14:24 | 0
 | 2 | 2010-10-19 12:57:36 | 2010-10-19 12:57:36 | 43.200000008801
 | 1 | 2010-10-19 13:12:00 | 2010-10-19 12:57:36 | 0
 | 1 | 2010-10-19 13:26:24 | 2010-10-19 12:57:36 | 0
 | 2 | 2010-10-19 13:40:48 | 2010-10-19 13:40:48 | 43.200000008801
Spreadsheet: 129049d1321429224-how-to-extract-info-based-on-any-defined-category-creamecake-example-to-khamilton
Sheet: Sheet1

 |  | Opening Balance |  | 1000
Date | Name-of-Payee | Payment-Details | Received | Payment | Balance |  |  | Unique entries from column C
2011-01-11 00:00:00 | Cremo | Petrol |  | 100
2011-01-11 00:00:00 | Cremo | Mobile [NAME] |  | 300
2011-02-11 00:00:00 |  | Sale of Goods | 150
2011-02-11 00:00:00 | Cremo | [NAME] |  | 200
2011-03-11 00:00:00 |  | Sale of Goods | 100
2011-04-11 00:00:00 | Cremo | Petrol |  | 100
2011-05-11 00:00:00 | Cremo | Internet Bill |  | 200
2011-06-11 00:00:00 |  | Sale of Goods | 500
2011-07-11 00:00:00 | Cremo | Raw Materials |  | 350
2011-08-11 00:00:00 |  | Sale of Goods | 200
2011-09-11 00:00:00 | Cremo | Raw Materials |  | 200
2011-10-11 00:00:00 | Cremo | Petrol |  | 150
 | Then you would just have to combine your communications in the end.---->
PLEASE LOOK in to A65 to A88 | where I tried with your same entires, but still the result was failure. I saw only one diff in the formula which I edited from yours with your formula is, yours is having ( { } ) curly bracets but for me it is not… pls advice…
Few of my actual entries which I tried to automatically categorized; but failed
 |  |  |  |  | 8971
 |  | Bike Maintenance |  | 70
 |  | Transportation - Omni |  | 100
 |  | Transportation - Omni |  | 100
 |  | Transportation - Bike |  | 50
 |  | Food-Chaliyam |  | 118
 |  | Labour-Charge |  | 400
 |  | Transportation-Jankar |  | 30
 |  | Building-Infra-materials |  | 1650
 |  | Transportation - Bike |  | 50
 |  | Food-Chaliyam |  | 100
 |  | Transportation-Others |  | 100
 |  | Carpenter-Charge |  | 250
 |  | Transportation-Others |  | 90
 |  | Wood-Cutting |  | 100
 |  | Carpenter-Charge |  | 200
 |  | Food-Chaliyam |  | 95
 |  | Transportation - Bike |  | 50
 |  | Transportation-Jankar |  | 10
 |  | Transportation - Bike |  | 100
 |  | Off-Stationary |  | 45
 |  | Credit-frm-Rahmath | 3530
 |  | Transportation - Bike |  | 150
 |  | Bike Maintenance |  | 419
 |  | Transportation - Bike |  | 200
 |  | Food-Chaliyam |  | 111
 |  | Transportation - Omni |  | 900
 |  | Opening Balance |  | 1000
Date | Name-of-Payee | Payment-Details | Received | Payment | Balance |  |  | Unique entries from column C
2011-01-11 00:00:00 | Cremo | Petrol |  | 100
2011-01-11 00:00:00 | Cremo | Mobile [NAME] |  | 300
2011-02-11 00:00:00 |  | Sale of Goods | 150
2011-02-11 00:00:00 | Cremo | [NAME] |  | 200
2011-03-11 00:00:00 |  | Sale of Goods | 100
2011-04-11 00:00:00 | Cremo | Petrol |  | 100
2011-05-11 00:00:00 | Cremo | Internet Bill |  | 200
2011-06-11 00:00:00 |  | Sale of Goods | 500
2011-07-11 00:00:00 | Cremo | Raw Materials |  | 350
2011-08-11 00:00:00 |  | Sale of Goods | 200
2011-09-11 00:00:00 | Cremo | Raw Materials |  | 200
2011-10-11 00:00:00 | Cremo | Petrol |  | 150
 | Then you would just have to combine your communications in the end.---->
Spreadsheet: 686370d1594561696-matching-set-a-with-set-b-and-highlighting-common-variates-cf
Sheet: Sheet1

3L_21169 | 3L_106883
3L_21188 | 3L_106949
3L_21220 | 3L_107227
3L_21256 | 3L_107238
3L_103851 | 3L_107251
3L_103863 | 3L_107297
3L_103867 | 3L_107391
3L_103868 | 3L_107486
3L_103966 | 3L_107491
3L_104056 | 3L_107525
3L_104606 | 3L_107576
3L_104622 | 3L_107703
3L_106032 | 3L_107719
3L_106119 | 3L_107798
3L_106147 | 3L_107853
3L_106170 | 3L_107892
3L_106174 | 3L_107924
3L_106187 | 3L_107940
3L_106189 | 3L_107963
3L_106232 | 3L_108025
3L_106309 | 3L_108043
3L_106735 | 3L_108252
3L_106745 | 3L_108273
3L_106770 | 3L_108391
3L_106880
3L_106883
3L_106949
3L_106978
3L_107227
3L_107238
3L_107251
3L_107256
3L_107297
3L_107391
3L_107486
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2000-01

Table C
Graduate Student Numbers by Faculty and Year Group
2000-01
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Total
Arts and Humanities | 361 | 157 | 54 | 24 | 14
Built Environment | 518 | 74 | 37 | 20 | 35
Clinical Sciences | 360 | 388 | 229 | 115 | 27
Eastman Dental Institute | 93 | 101 | 78 | 40 | 8
Engineering | 324 | 197 | 96 | 63 | 21
Laws | 289 | 17 | 7 | 6 | 2
Life Sciences | 397 | 213 | 163 | 54 | 8
Mathematical and Physical Sciences | 227 | 112 | 87 | 28 | 7
Social and Historical Sciences | 567 | 143 | 104 | 56 | 32
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 172785d1344337457-need-help-please-on-timehseet-spreadsheet-timesheet-4-weekly
Sheet: Teams

TEAMS
DATE | INSERT MONTH | Day
[NAME]
CLIENT
HOURS | 17H50 | 18H00 | 19H00 | 20H00 | 17H23 | 17H45
 | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | TEAM 6 | OFFICE/STOOR
SUPERVISOR
WORKERS
Spreadsheet: 49712d1249038098-lookup-index-match-address-book1
Sheet: Sheet1

PO No | Date Started | Date Done | Priority | Quantity | Sign | Material
2869 | 2009-07-27 00:00:00 |  | Stock | 210 | 6815JJ | PV
2870 | 2009-07-27 00:00:00 |  | Stock | 70 | 6818JJ | PV
2870 | 2009-07-27 00:00:00 |  | Stock | 70 | 6020JJ | PV
2871 | 2009-07-27 00:00:00 |  | Stock | 60 | 8690GM | WV
2872 | 2009-07-27 00:00:00 |  | Stock | 80 | 6059JJ | PV
2873 | 2009-07-27 00:00:00 |  | Stock | 120 | 6815JJ | WV
2874 | 2009-07-27 00:00:00 |  | Stock | 60 | 6015JJ | PV
2875 | 2009-07-27 00:00:00 |  | Stock | 60 | 6005JJ | PV
2876 | 2009-07-27 00:00:00 |  | Stock | 80 | 6003JJ | PV
 | Stock Code: | 6815JJPV
 | PO No: | ??
Spreadsheet: 46685d1245617960-if-and-or-formula-copy-of-claim-form-2009-10-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00
First Name | Surname | Level | Band | Type | Joined | Value | Start Date | Planned End | Actual End | P1 - Aug | [NAME] | P3 - Oct | P4 - Nov | P5 - Dec | P6 - Jan | P7 - Feb | [NAME] | P9 - Apr | P10 - May | P11 - Jun | P12 - Jul | Total
[NAME] | Bloggs | L2 | Band A | Start | [NAME] A Start | 100 | 2009-08-01 00:00:00 | 2010-07-31 00:00:00 | 2009-10-01 00:00:00 | X | X | X |  |  |  |  |  |  |  |  |  | 3
Fred | Smith | L3 | Band B | OPP | [NAME] B OPP | 154 | 2009-08-01 00:00:00 | 2010-07-31 00:00:00 |  | X | X | X | X | X | X | X | X | X | X | X | X | 12
[NAME] | Jones | L3 co | Band C | Qual | L3 co Band C Qual | 208 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00 | 2010-04-01 00:00:00 |  |  | X | X | X | X | X | X | X |  |  |  | 7
Spreadsheet: 200915d1355809360-vlookup-different-sets-of-columns-help-sample1
Sheet: Sheet2

SCREWS |  |  | BOLTS |  |  | NAILS |  |  | WASHERS
ITEM # | Description | Price | ITEM # | Description | Price | ITEM # | Description | Price | ITEM # | Description | Price
FC1 | Screw 25 | 10 | FZ1 | [NAME] 50 | 20 | FG1 | Nail 30 | 43 | WA1 | Washer 10 | 4
FC2 | Screw 26 | 11 | FZ2 | [NAME] 51 | 21 | FG2 | Nail 31 | 44 | WA2 | Washer 11 | 5
FC3 | Screw 27 | 12 | FZ3 | [NAME] 52 | 22 | FG3 | Nail 32 | 45 | WA3 | Washer 12 | 6
FC4 | Screw 28 | 13 | FZ4 | [NAME] 53 | 23 | FG4 | Nail 33 | 46 | WA4 | Washer 13 | 7
FC5 | Screw 29 | 14 | FZ5 | [NAME] 54 | 24 | FG5 | Nail 34 | 47 | WA5 | Washer 14 | 8
FC6 | Screw 30 | 15 | FZ6 | [NAME] 55 | 25 | FG6 | Nail 35 | 48 | WA6 | Washer 15 | 9
FC7 | Screw 31 | 16 | FZ7 | [NAME] 56 | 26 | FG7 | Nail 36 | 49 | WA7 | Washer 16 | 10
FC8 | Screw 32 | 17 | FZ8 | [NAME] 57 | 27 | FG8 | Nail 37 | 50 | WA8 | Washer 17 | 11
FC9 | Screw 33 | 18 | FZ9 | [NAME] 58 | 28 | FG9 | Nail 38 | 51 | WA9 | Washer 18 | 12
FC10 | Screw 34 | 19 | FZ10 | Bolt 59 | 29 | FG10 | Nail 39 | 52 | WA10 | Washer 19 | 13
FC11 | Screw 35 | 20 | FZ11 | [NAME] 60 | 30 | FG11 | Nail 40 | 53 | WA11 | Washer 20 | 14
FC12 | Screw 36 | 21 | FZ12 | [NAME] 61 | 31 | FG12 | Nail 41 | 54 | WA12 | Washer 21 | 15
Spreadsheet: 682507d1592157992-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: BONOUS

CODE | NET LIVES | NET FP |  | DATE(YYYYMMDD) |  | EXPECTED |  |  |  | CHANGE DATE
 |  |  | Sum of 6 unique orders | Date that meeting 2 conditions | sum of orders meeting 2 criteria |  |  |  |  | AS REQUIRED
192 |  |  |  |  |  |  |  |  |  | 20190401 | 20200331
727 |  |  |  |  |  | 20200128
888 |  |  |  |  |  | 20200528
 |  |  |  |  |  |  |  |  |  | PROJECT : IF AN EMPLOYEE (SHOWN IN SHEET NBD COLUMN "EM-CODE) COMPLETES SIX UNIQUE ORDERS(UNIQUE ORDER MEANS: ' ORDER-NO' WITH UNIQUE' DOB')
 |  |  |  |  |  |  |  |  |  | AND SUM OF ALL ORDER PREM IS >=50000 IN GIVEN DATE RANGE .EMPLOYEE IS ELIGIBLW FOR BONUS FROM DATE ON WHICH HE SATISFIES TWO CONDITIONS.
 |  |  |  |  |  |  |  |  |  | SOLUTION REQUIRED : I WANT TO DISPLAY DATE IN COL. [NAME] YYYYMMDD FORMAT(AS SHOWN IN COL. 'C' OF 'NBD' SHEET) ON WHICH EMPLOYEE SATISFY ABOVE MENTIONED
 |  |  |  |  |  |  |  |  |  | TWO CONDITIONS. SO THAT I CAN CALCULATE BONOUS FROM THAT DATE.
 |  |  |  |  |  |  |  |  |  | EXPECTED RESULT IS GIVEN IN COL. E
 |  |  |  |  |  |  |  |  |  | WE HAVE TO FIND  DATE ON WHICH EMPLOYEE SATISFY BOTH CONDITIONS.
 |  |  |  |  |  |  | 20190629 |  |  | CONDITION  1)     6 ORDERS WITH UNIQUE DOB AND
 |  |  |  |  |  |  | 20201128 |  |  | CONDITION 2 )  SUM OF PREM. >=50000(INCLUDES DUPLICATE DOB RECORD)
 |  |  |  |  |  |  | 20190529