tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838885d1691495235-average-based-on-part-number-if-statement-ls-test
Sheet: Summary

 |  |  |  |  | % of Bid | % of Bid | % of Bid | [NAME] of All Bids |  |  |  | [NAME] of All PIDs
ADA
SS-999-0003 | SURVEY WORK - SANITARY SEWER | 3000 | 1 | LS | 0.004329004329004329 |  |  | 0.004329004329004329 |  | 005-0701 | SURVEY AND LAYOUT BY CONTRACTOR
999-0003 | SURVEY WORK. Per PC Std. Tech. Spec. 999-0003 | 52500 | 1 | LS | 0.002052688004716881 |  |  | 0.002052688004716881 |  | 005-0705 | SURVEY, Permitting As-built Requirements
PW-999-0003 | SURVEY WORK - WATER MAIN | 7100 | 1 | LS | 0.008495973387260826 |  |  | 0.008495973387260826 |  | 005-0800 | Survey, Quantity Measurements
RW-999-0003 | SURVEY WORK - RECLAIMED WATER | 5800 | 1 | LS | 0.009380180325880403 |  |  | 0.009380180325880403 |  | 101-0100 | MOBILIZATION | 0.1375219626012323
 |  |  |  |  |  |  |  |  |  | 102-1000 | [NAME] | 0.05246462873237014
002069A |  |  |  |  |  |  |  |  |  | 104-10 | PREVENTION, CONTROL AND ABATEMENT OF EROSION & WATER POLLUTION | 0.02750164208099444
005-0701 | SURVEY AND LAYOUT BY CONTRACTOR | 49995 | 1 | LS | 0.02750164208099444 |  |  | 0.02750164208099444 |  | 110-0100 | CLEARING AND GRUBBING | 0.06326010279656687
101-0100 | MOBILIZATION | 250000 | 1 | LS | 0.1375219626012323 |  |  | 0.1375219626012323 |  | 120-1100 | GRADING | 0.02530129067937472
102-1000 | [NAME] | 95375 | 1 | LS | 0.05246462873237014 |  |  | 0.05246462873237014
104-10 | PREVENTION, CONTROL AND ABATEMENT OF EROSION & WATER POLLUTION | 49995 | 1 | LS | 0.02750164208099444 |  |  | 0.02750164208099444
110-0100 | CLEARING AND GRUBBING | 115000 | 1 | LS | 0.06326010279656687 |  |  | 0.06326010279656687
120-1100 | GRADING | 45995 | 1 | LS | 0.02530129067937472 |  |  | 0.02530129067937472
120-1500 | Removal of 2 Signs & 2 Palm Trees at Southernaire Mobile Home Park | 4500 | 1 | LS | 0.002475395326822182 |  |  | 0.002475395326822182
800-1601 | RESTORATION OF PRIVATELY OWNED FETURES | 12000 | 1 | LS | 0.006601054204859152 |  |  | 0.006601054204859152
003894A
005-0701 | Survey and Layout | 98500 | 1 | LS | 0.05472761897353767 | 0.05861409932774397
Spreadsheet: 800170d1665511909-date-formula-to-show-on-time-and-late-with-exceptions-help-etaf-3
Sheet: Sheet1

TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG
2022-10-03 00:00:00 | 2022-09-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  | The date in in cell [NAME] has to be 5 days before the date in A2 to be considered "On Time", but if there are no dates in the B column then the D column should show "On Time".
2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-04 00:00:00
2022-10-11 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  | F2 = Late ( C2 is not 5 days before A2) F3 = On Time ([NAME] is at least 5 days before A3) F4 = On Time (B4 is blank meaning no documents required so it cant be late)  If C column is empty and still 5 days before the TAQFAR date then F column should still be on time as well.
Spreadsheet: 719731d1613768765-multi-search-with-aggregate-timmer
Sheet: Sheet1

[NAME] | Site | Primary Need |  | Colleague List
Colleague 1 | A | Transfer - No Need
Colleague 2 | A (existing) | ABC |  |  |  | Colleague 4
Colleague 3 | B | XYZ |  |  |  | Colleague 6
Colleague 4 | C | TEST |  |  |  | Colleague 7
Colleague 5 | C | Transfer - No Need |  |  |  | Colleague 9
Colleague 6 | B | ABC |  |  |  | Colleague 10
Colleague 7 | A | XYZ
Colleague 8 | B (existing) | TEST
Colleague 9 | C | TEST
Colleague 10 | A | XYZ
 | If colleague has a Site listed with the word "exisiting" and or a Primary Need with the word "Transfer", colleague should not appear on Colleague List. I was able to omit colleagues with site word existing but need it also for primary need transfer word.
Spreadsheet: 691398d1597677661-formula-to-pull-the-list-based-on-a-particular-value-test
Sheet: Data

 | Stock | Code
 | 25 mm Sheet | 00000000000060013880
 | 25 mm Sheet | 00000000000060014140
 | 25 mm Sheet | 00000000000060014141
 | 25 mm Sheet | 00000000000060014142
 | 25 mm Sheet | 00000000000060014144
 | 25 mm Sheet | 00000000000060014145
 | 25 mm Sheet | 00000000000060014146
 | 25 mm Sheet | 00000000000060014143
 | 30 mm Sheet | 00000000000060014151
 | 30 mm Sheet | 00000000000060014153
 | 30 mm Sheet | 00000000000060014147
 | 30 mm Sheet | 00000000000060014148
 | 30 mm Sheet | 00000000000060014149
 | 30 mm Sheet | 00000000000060014150
 | 30 mm Sheet | 00000000000060014152
 | 30 mm Sheet | 00000000000060014477
 | 30 mm Sheet | 00000000000060014478
 | 30 mm Sheet | 00000000000060014479
Spreadsheet: 1e240d80-fdf1-4080-97bf-16c9b307fd2e
Sheet: Sheet1

Symbol | Product Type | Cost/Unit | Units / Case | Cost/Case | Packaging | ORDER BY CASE ONLY | ORDER BY UNIT
 | Chocolate Lover's Collection Tin $55/ea                                                                                             White and Milk Chocolately Pretzels, White Chocolately Caramel Crunch, & Chocolately Caramel Crunch | 55 | 1 |  | Tin
 | Sweet & Savory Collection $40/ea-                                                                       Dark & White [NAME], White Cheddar Cheese Corn & Kettle Corn | 40 | 1 |  | Box
 | Cheese Lover’s Collection $30/ea-                                                                       White Cheddar Cheese, Cheddar Cheese  & Buffalo Cheddar Cheese | 30 | 1 |  | Box
 | [NAME] Caramel Crunch $25/ea | 25 | 12 |  | Bag
 | White Chocolate Pretzels $25/ea | 25 | 12 |  | Bag
 | 18-Pack Kettle Corn $25/ea | 25 | 6 |  | Box
 | 18-Pack Unbelievable Butter $20/ea | 20 | 6 |  | Box
 | 18-Pack Butter Light $20/ea | 20 | 6 |  | Box
 | Premium Caramel Corn w/Almonds, Cashews & Pecans $20/ea | 20 | 12 |  | Bag
 | Dark & White Chocolatey Drizzle $20/ea | 20 | 12 |  | Bag
 | Bacon Ranch Collectors Tin $20/ea | 20 | 6 |  | Tin
 | [NAME] Cheese $15/ea | 15 | 6 |  | Bag
 | White Cheddar Cheese Corn $15/ea | 15 | 6 |  | Bag
 | Caramel Corn $10/ea | 10 | 12 |  | Bag
 | Popping Corn $10/ea | 10 | 12 |  | Bag
 | TOTAL NUMBER OF CASES/UNITS
 | PLEASE SIGN DISCLAIMER BELOW
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West - Struct

 | West Power Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  | 120000 |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates |  |  |  |  | 97200
ENABENTX | Benefits & Payroll Taxes |  |  |  |  | 43440 |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  | 14400
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  | 27800 |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  |  | 0.008629213474439769
ENASUPP | Supplies Expense |  |  |  |  | 5760
ENAMKTEX | Marketing |  |  |  |  | 0 |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  | 1800 |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  | 5603.429033707865 |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  | 4.176179775280899 |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  | 5000 |  |  |  | Analyst | 66000 | 1
ENATAXES | Taxes Other than Income |  |  |  |  | 2722.144719101123 |  |  |  | Associate | 97200 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  | 323729.7585617978 |  |  |  | Manager | 120000 | 1
 |  |  |  |  |  |  |  |  |  | Director | 156000
 | Headcount |  |  |  |  | 1 |  |  |  | Sr. Director | 180000 | 0 |  | 1
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  | 1 |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 01aba8ac-b876-4ff1-b27d-d4e28919c2e3
Sheet: CDS-A

A.  General Information
A0 | Respondent Information (Not for Publication)
A0 | Name: |  | [NAME]
A0 | Title: |  | Assistant Provost
A0 | Office: |  | Institutional Research and Assessment
A0 | Mailing Address: |  | 300 Washington Avenue
A0 | City/State/Zip/Country: |  | Chestertown MD 21620
A0 | Phone: |  | [PHONE]
A0 | Fax: |  | [PHONE]
A0 | E-mail Address: |  | [EMAIL]
A0 | Are your responses to the CDS posted for reference on your institution's Web site?     Yes
A0 | If yes, please provide the URL of the corresponding Web page:
 |  |  | http://ir.washcoll.edu/commondataset.php
A0A | We invite you to indicate if there are items on the CDS for which you cannot use the requested analytic convention, cannot provide data for the cohort requested, whose methodology is unclear, or about which you have questions or comments in general. This information will not be published but will help the publishers further refine CDS items.
A1 | Address Information
A1 | Name of College/University: | Washington College
A1 | Mailing Address: | 300 Washington Avenue
A1 | City/State/Zip/Country: | Chestertown MD 21620
A1 | Street Address (if different):
A1 | City/State/Zip/Country:
A1 | Main Phone Number: | [PHONE]
A1 | WWW Home Page Address: | www.washcoll.edu
A1 | Admissions Phone Number: | [PHONE]
A1 | Admissions Toll-Free Phone Number: | [PHONE]
A1 | Admissions Office Mailing Address:
A1 | City/State/Zip/Country:
A1 | Admissions Fax Number: | [PHONE]
A1 | Admissions E-mail Address: | [EMAIL]
A1 | If there is a separate URL for your school’s online application, please specify: ______________ | http://admissions.washcoll.edu/applytowashingtoncollege.php
A1 | If you have a mailing address other than the above to which applications should be sent, please provide:
A2 | Source of institutional control (Check only one):
A2 | Public
A2 | Private (nonprofit) | X
A2 | Proprietary
A3 | Classify your undergraduate institution:
A3 | Coeducational college | X
A3 | Men's college
A3 | Women's college
A4 | Academic year calendar:
A4 | Semester | X
A4 | Quarter
A4 | Trimester
A4 | 4-1-4
A4 | [NAME]
A4 | Differs by program (describe):
A4 | Other (describe):
A5 | Degrees offered by your institution:
A5 | Certificate
A5 | Diploma
A5 | Associate
A5 | Transfer Associate
A5 | Terminal Associate
A5 | Bachelor's | X
A5 | Postbachelor's certificate
A5 | Master's | X
A5 | Post-master's certificate
A5 | Doctoral degree research/scholarship
A5 | Doctoral degree – professional practice
A5 | Doctoral degree -- other
Spreadsheet: 215371d1361361492-matching-two-cells-staff-requirements
Sheet: Matrix

Week Commencing:
Today:
 |  | Mon | Tue | Wed | Thur | Fri
 | Shift | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00
1 - RV53B | Morning
 | Afternoon
 | Total
2 - RV74
3 - RV53
4 - RDKP72
5 - KIEFEL
6 - RDKP72
7 - RDKP54
Spreadsheet: 6a004cff-5311-458b-b55e-31212f2d9878
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PUSE | Test | PUSE | Pumpkin Seed, IgE | Pumpkin Seed, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PUSE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PUSE | Result | PUSE | Pumpkin Seed, IgE | Pumpkin Seed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11193-0
Spreadsheet: 1bd1ab7e-ea27-424e-bb5e-2fa6b2944073
Sheet: 2000-2010

GAVI Alliance
Cash received 2000-2010
as of 31 December 2010
millions US$
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | Total
Australia |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 8.6
Canada |  |  | 1.88035602 | 4.75542135 |  | 130.8686406 | 5.19031142
Denmark |  | 1.14740743 |  |  | 3.33887922 | 3.41610739 | 4.41126234 | 4.73754 |  |  | 1.807207
European Commission (EC) |  |  |  | 1.26 |  |  |  | 4.84964 | 23.129114 | 28.63013
France |  |  |  |  | 6.02911392 |  | 12.63
Germany |  |  |  |  |  |  | 5.2604 | 5.948
Ireland |  |  | 0.51075 | 0.62375 | 0.65 | 0.83146 | 7.902 | 8.3112 | 3.84132 |  | 3.630863
Luxembourg |  |  |  |  |  | 0.64515 | 1.318775 | 0.81184 | 1.4229 | 1.19124 | 1.10044
Netherlands |  | 24.06033462 | 13.37517187 | 16.49264195 | 17.32986645 | 15.85941435 |  | 33.547469 | 38.885301 | 31.20579 | 25.1113845
Norway |  | 17.89468975 | 21.32565609 | 21.79108674 | 40.92459264 | 39.53459411 |  | 86.156761 | 65.44948326 | 82.80032471 | 76.483608
Republic of Korea |  |  |  |  |  |  |  |  |  |  | 0.4
Spain |  |  |  |  |  |  |  |  | 40.5362
Sweden |  | 1.89213259 | 1.11479998 | 2.38518169 | 4.93142988 | 12.66340061 | 14.59397503 | 15.514976 | 19.151976 | 13.80099952 | 36.4874975
United Kingdom | 4.4634 |  | 15.04825 | 5.60595 | 18.491535 | 6.625149 | 23.214072 |  |  |  | 15.883044
United States |  | 48.092 | 53 | 58 | 59.64 | 64.48 | 69.3 | 69.3 | 71.913 | 75 | 78
Donor Governments and EC
Bill & Melinda Gates Foundation | 325 | 425 |  | 3.5 | 5 | 154.338 |  | 75 | 75 | 75 | 75
His Highness Sheikh [NAME]
"la Caixa" Foundation |  |  |  |  |  |  |  |  | 5.8 | 5.9 | 4
Other private | 0.02 |  | 1.630361 | 2.580847 | 1.805051 | 0.47348 | 1.904352 | 1.1 | 0.8 | 1 | 1
Private Contributions
Sub-total
IFFIm to GFA transfers |  |  |  |  |  |  | 524.749285 | 428.268866 | 272.638133 | 330.027 | 320
AMC funds |  |  |  |  |  |  |  |  |  |  | 42.87705
Total contributions
Donations recorded on a cash basis
Spreadsheet: 42d4028f-3f71-47d1-adb0-a9bb13ed4caa
Sheet: Partner

Line Item Budget Template
Lead Agency: | Enter here
Preschool Specialist: | Enter here
Date of Submission: | Enter here
Total Budget Amount | 0
Instructions: Spreadsheet is formula-driven; enter only is shaded blue areas
Budget Expenditures | Budget Amount | Percentage of Budget | Allowable Range | Justification
1 Enter all Program related Child Health and Development salaries | 0 |  | 35%-45%
1a Enter all Program related Child Health and Development benefits | 0 |  | 10%-15%
2 Enter all Program related Program Design and Management salaries | 0 |  | 5%-10%
2a Enter all Program related Program Design and Management benefits | 0 |  | 1%-5%
3 Enter all Program related Family and Community Partnership salaries | 0 |  | 0%-8%
3a Enter all Program related Family and Community Partnership benefits | 0 |  | 0%-2%
4 Enter all Other Program related salaries | 0 |  | 0%-5%
4a Enter all Other Program related benefits | 0 |  | 0%-4%
5 Enter all Program related supplies used for Program Purposes | 0 |  | 2%-6%
5a Enter all Program related supplies used for Management Purposes | 0 |  | 1%-4%
6 Enter all equipment amounts related to Program | 0 |  | 0%-4%
7 Enter amount related to Nutritional Services | 0 |  | 0%-8%
7a Enter amount related to Parent Services | 0 |  | 0%-2%
7b Enter any Program Child Services Consultants | 0 |  | 0%-5%
7c Enter Space Related costs for Program | 0 |  | 3%-10%
7d Enter Building Maintenance/Repair and Other Occupancy costs | 0 |  | 0%-3%
7e Enter Utilities and Telephone costs | 0 |  | 1%-3%
7f Enter Building/Child Liability Insurance costs | 0 |  | 1%-3%
7g Enter costs associated to Accounting and Legal Services | 0 |  | 0%-3%
7h Enter Publication/Advertising/Printing costs | 0 |  | 0%-2%
7i [NAME] (if not paid benefits) | 0 |  | 0%-2%
7j Enter Non-Student Travel costs | 0 |  | 0%-4%
8 Enter any Program Contracted Services | 0 |  | 0%-4%
9 Enter all Program related Training and Staff Development costs | 0 |  | 2%-6%
91 Enter Student Transportation amounts for Program | 0 |  | 0%-4%
92 Enter construction costs related to renovations for new classroom start-up | 0 |  | 0%-4%
Total
Preschool Specialist comments and approval: Enter here
[NAME] Approval: Date & Initials
Final Approval: Date & Initials
Spreadsheet: 377607d1424092092-bar-chart-of-numbers-by-date-book1
Sheet: Sheet1

2015-01-01 00:00:00 | a
2015-01-01 00:00:00 | b
2015-01-02 00:00:00 | c
2015-01-03 00:00:00 | d
2015-01-03 00:00:00 | e
2015-01-04 00:00:00 | f
2015-01-07 00:00:00 | g
Spreadsheet: 148141d1333151537-if-text-in-cell-equals-text-in-another-cell-highlight-both-same-color-example-roster-comparison-1-
Sheet: Sheet1

EMPLOYEE ROSTER |  |  |  |  | Company Training
Full Name | Last Name | First Name |  |  | Last Name | First Name
[NAME], [NAME] |  |  |  |  | [NAME] | [NAME]
[NAME], [NAME] |  |  |  |  | [NAME] | [NAME]
Jones, Amanda |  |  |  |  | Jones | Amanda
Sanders, [NAME] |  |  |  |  | Saunders | [NAME]
Smith, [NAME] |  |  |  |  | Smith | Fred
[NAME], [NAME] |  |  |  |  | Smith | Zach
Spreadsheet: 882012d1730272168-transform-data-from-one-sheet-to-other-book2-1-
Sheet: formula

Column1 | Column2 | Salesman-01 | Salesman-03 | [NAME] | Salesman-07 | Salesman-08 | Salesman-12 | Salesman-17 | Salesman-20 | Salesman-21 | Salesman-25 |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
Product 1 | Area 1 | 4 | 5 | 4 | 2 | 1 | 2 | 3 | 4 | 3 | 4 |  | Salesman-01
Product 1 | Area 2 | 1 | 0 | 5 | 5 | 3 | 0 | 5 | 5 | 3 | 3 |  | Salesman-02
Product 1 | Area 3 | 4 | 5 | 3 | 2 | 5 | 1 | 3 | 2 | 1 | 3 |  | Salesman-03
Product 1 | Area 4 | 3 | 3 | 4 | 1 | 0 | 5 | 4 | 4 | 0 | 3 |  | [NAME]
Product 1 | Area 5 | 2 | 5 | 2 | 5 | 2 | 1 | 1 | 5 | 3 | 3 |  | [NAME]
Product 2 | Area 1 | 5 | 1 | 0 | 1 | 1 | 1 | 2 | 1 | 2 | 1 |  | Salesman-06
Product 2 | Area 2 | 3 | 2 | 2 | 3 | 2 | 2 | 4 | 5 | 2 | 3 |  | Salesman-07
Product 2 | Area 3 | 2 | 0 | 2 | 5 | 2 | 4 | 4 | 1 | 0 | 3 |  | Salesman-08
Product 2 | Area 4 | 2 | 3 | 0 | 3 | 3 | 0 | 5 | 3 | 4 | 1 |  | Salesman-09
Product 2 | Area 5 | 1 | 1 | 1 | 1 | 5 | 3 | 1 | 1 | 0 | 3 |  | Salesman-10
Product 2 | Area 6 | 4 | 4 | 3 | 0 | 2 | 4 | 0 | 0 | 2 | 3 |  | Salesman-11
Product 2 | Area 7 | 2 | 4 | 4 | 3 | 4 | 2 | 4 | 5 | 1 | 1 |  | Salesman-12
Product 2 | Area 8 | 4 | 1 | 0 | 4 | 5 | 5 | 5 | 0 | 2 | 0 |  | Salesman-13
Product 2 | Area 9 | 0 | 1 | 5 | 2 | 2 | 1 | 0 | 1 | 0 | 4 |  | Salesman-14
Product 2 | Area 10 | 4 | 3 | 3 | 4 | 0 | 5 | 0 | 4 | 2 | 4 |  | Salesman-15
Product 2 | Area 11 | 4 | 0 | 0 | 5 | 5 | 0 | 3 | 1 | 4 | 3 |  | Salesman-16
Product 2 | Area 12 | 3 | 5 | 4 | 5 | 4 | 4 | 3 | 5 | 0 | 1 |  | Salesman-17
Product 2 | Area 13 | 1 | 3 | 4 | 5 | 2 | 4 | 5 | 5 | 4 | 5 |  | Salesman-18
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-19
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-20
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-21
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-22
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-23
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-24
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-25
 |  |  |  |  |  |  |  |  |  |  |  |  | Salesman-26
Spreadsheet: 10d29788-97e0-4517-a006-2bde2bf078bb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5582 | 30373 | [NAME] | Cuvillier | FRA | 493 | 00:44:07 | [NAME] | 01:03:56 | 00:00:33 | 00:23:33 | 1 | 02:12:58
Spreadsheet: 5de7dd70-a2b1-4588-aaa7-75106b0cf299
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259542 | 55762 | Oxana | Grot | KAZ | 33 | [NAME] | 00:00:44 | 01:03:05 | 00:00:27 | 00:39:16 | 1 | 02:04:22
259542 | 41842 | Karolina | Solovyova | KAZ | 32 | 00:20:52 | 00:00:50 | 01:02:55 | 00:00:28 | 00:40:02 | 2 | [NAME]
259542 | 28114 | [NAME] | [NAME] | HKG | 34 | 00:20:53 | 00:00:44 | 01:02:59 | 00:00:34 | 00:40:50 | 3 | 02:06:00
259542 | 6801 | [NAME] | [NAME] | HKG | 31 | [NAME] | 00:00:47 | 01:03:02 | [NAME] | 00:42:01 | 4 | 02:07:07
259542 | 55761 | Kristina | Nesterenko | KAZ | 35 | 00:20:54 | 00:00:46 | 01:02:58 | 00:00:29 | 00:47:00 | 5 | 02:12:07
Spreadsheet: 780140d1652298284-return-blank-when-the-dates-from-to-are-not-within-those-dates-range-source
Sheet: Sheet1

Missing Comp Plan Query | 2022-04-27 00:00:00 | 2022-05-06 00:00:00 | [NAME]
Payroll Wed through Maint Friday |  |  | [NAME] |  | 5/9 and 5/10 should be blank or n/a since its missing from this line
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
Spreadsheet: 120407d1315260969-conditional-formatting-values-0-classeur1
Sheet: Feuil1

 | ref 1 | prix 1 | ref 2 | prix 2 | ref 3 | prix 3 | ref 4 | prix 4
ESSUIE TOUT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GAINE STERILISATION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 4222.446 | 0.72 | 224.407 | 0.7933333333333333
HYGIENE DES MAINS | 0 | 0 | 0 | 0 | 4222.298 | 0.04337231968810916 | 0 | 0
 | ECUNSR050 | 0.301691 | 900.3634 | 0.0875 | 4062.122 | 0.084 | 224.055 | 0.0895
LINGETTE | ECUNSR100 | 0.503217 | 900.3636 | 0.16 | 4064.122 | 0.1585 | 224.057 | 0.1675
 | 0 | 0 | 900.6118 | 14 | 0 | 0 | 224.432 | 15.9
 | 0 | 0 | 0 | 0 | 0 | 0 | 224.433 | 10.44
 | 0 | 0 | 900.6116 | 0.039 | 4929.122 | 0.0375 | 224.565 | 0.05520000000000001
LUBRIFIANT CONTRE-ANGLE | 0 | 0 | 900.6117 | 0.03 | 4920.122 | 0.0335 | 224.566 | 0.0476
LUBRIFIANT PINCES | 0 | 0 | 0 | 0 | 0 | 0 | 224.683 | 0.044
PAILLE DE FER | 0 | 0 | 0 | 0 | 0 | 0 | 224.276 | 0.038
SAC A DECHET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SOUDEUSE | 0 | 0 | 0 | 0 | 8718.002 | 93.22033898305085 | 0 | 0
SURCHAUSSURE | 0 | 0 | 0 | 0 | 3306.172 | 2.38 | 226.023 | 2.8
SURFACE FAUTEUIL | 0 | 0 | 0 | 0 | 89 | 0.002 | 0 | 0
SURFACE FAUTEIL ET MATERIEL | ECUNSOUDEUSE | 705.5802000000001 | 900.2954 | 575 | 4176.555 | 499 | 224.031 | 499
 | 0 | 0 | 886.9469 | 0.1004 | 0 | 0 | 2222.329 | 0.15
SURFACES ET SOLS | 0 | 0 | 0 | 0 | 5244.003 | 62.3 | 224.052 | 70.4
 | 0 | 0 | 877.1839 | 13.6 | 3051.099 | 12.06666666666667 | 0 | 0
 | 0 | 0 | 877.1840 | 12.12 | 3062.099 | 10.84 | 0 | 0
 | 0 | 0 | 882.0172 | 14.4 | 2394.004 | 12.6 | 224.065 | 16.7
SYSTÈME ASPIRATION | 0 | 0 | 877.1768 | 9.82 | 3980.099 | 8.73 | 224.066 | 11.7
TETIERE FAUTEUIL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 684887d1593600611-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table
Sheet: Sheet1

 | Table 1 - Data |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - Selling Price Summary
 | Item | 1
 |  | Product A |  |  |  | Product B |  |  |  | Product C |  |  |  |  |  |  | Our selling price over different sales channels
 | Sales to | [NAME] |  | MT |  | MT |  | FR |  | OT |  | FS |  |  | Item | Product Name | [NAME] | FR | FS | GT | MT | OT
 | Our Cost Price |  | 15 |  |  |  | 20 |  |  |  | 38 |  |  |  | 1
 | Desired Margin |  |  | 0.11 |  |  |  | 0.15 |  | 0.2 |  | 0.18 |  |  | 2
 | Our Selling Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Sales to | GT |  | FS |  | OT |  |  |  |  |  |  |  |  | 4
 | Our Cost Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Desired Margin | 0.12 |  | 0.13 |  | 0.12 |  |  |  |  |  |  |  |  | 6
 | Our Selling Price