tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26098d1218006173-price-conversion-from-usd-gbp-eur-yuan-yen-to-pkr-formula-help
Sheet: Books Price

 |  |  |  |  |  |  | Dollar | Pond | Euro | Yen | Yuan
PKR |  |  |  |  |  |  | 72.2028 | 141.0376 | 111.821 | 0.6693 | 10.5319
S/No. | Title | Author | Currency | Price | Pak Rupees | Subject
1 | Focus on Grammar, level 2A , Latest Edition. | Longman | $ | 500 |  | ENGLISH (|Wr. Nasir)
2 | Side by Side Level 1, Latest Edition. | Longman | $ | 200 |  | ENGLISH (|Wr. Nasir)
5 | Anchor in English-II (Lessons 1-5), A SPELT Publication, Latest Edition. |  | $ | 25 |  | COMMUNICATION SKILLS
6 | Summary Writing (Book-I), , Latest Edition. | [NAME] (OUP) | € | 20 |  | COMMUNICATION SKILLS
7 | Speaking Clearly, Latest Edition. | Pamela Rogerson & Judy B Gilbert | € | 22 |  | COMMUNICATION SKILLS
8 | Basic Technical Writing, Latest Edition. | [NAME] | € | 10 |  | COMMUNICATION SKILLS
10 | Longman/Merriam-Webster/Oxford Dictionary, Latest Edition. [NAME], |  | £ | 20 |  | COMMUNICATION SKILLS
11 | As approved by the University/Institution. |  | £ | 15 |  | ISLAMIC STUDIES
12 | As approved by HEC/University/Institution. |  | £ | 25 |  | ETHICS
15 | Ethics in Engineering Practice and Research, Cambridge University Press, (Latest Edition) | [NAME] | £ | 70 |  | ENGINEERING ETHICS
16 | Engineering Ethics: Concepts and Cases, , [NAME] and [NAME], Wadsworth Publishing, (Latest Edition) | [NAME] | ¥ | 150 |  | ENGINEERING ETHICS
17 | As approved by the University/Institution. |  | ¥ | 200 |  | SOCIAL SCIENCES
18 | Engineering Economy, (Latest Edition) | A. Tarquin | ¥ | 250 |  | ENGINEERING ECONOMICS
Spreadsheet: 025acb2f-e83c-4c56-a5d2-11a5048d1ef7
Sheet: SubjectAreas

MCCC Subject Areas K-12
Subject Area Number | Subject Area Title
1 | English Language Arts and Literature 9-12
2 | Mathematics 9-12
3 | Life and Physical Science 9-12
4 | Social Sciences and History 9-12
5 | Visual and Performing Arts 9-12
6 | World Languages and Literature 9-12
7 | Religious Education and Theology 9-12
8 | Physical,  Health and Safety Education 9-12
9 | Military Science 9-12
10 | Computer Information Sciences 9-12
11 | Communication and Audio/Visual Technology 9-12
12 | Business and Marketing 9-12
13 | Manufacturing 9-12
14 | Health Care Sciences 9-12
15 | Public, Protective and Government Services 9-12
16 | Hospitality and Tourism 9-12
17 | Architecture and Construction 9-12
18 | Agriculture, Food and Natural Resources 9-12
19 | Human Services 9-12
20 | Transportation, Distribution and Logistics 9-12
21 | Engineering and Technology 9-12
22 | Family and Consumer Science 9-12
23 | Academic and Career Development 9-12 (Use "23" for reporting elective credit on Multiple Subject Area courses 9-12.)
51 | English Language Arts and [NAME]
52 | Mathematics K-8
73 | Academic and Career Development K-8
74 | Non-Subject Specific Grade Levels K-8
Spreadsheet: sara_shackleton__36407__PHONE_LIST
Sheet: Visitors-SP office

[NAME] do [NAME].
SÃO PAULO OFFICE
Av. das [NAME], 11.541 - 6º andar - 04578-000 - São Paulo - SP - Brasil                                  Tel. 55 11 5503 -1399    Fax. 55 11 5507-3090
VISITORS
NAME | DEPARTMENT | EXTENSION | FLOOR
[NAME] | Legal | 1269 | 7th
[NAME] | Communication | 1287 | 5th
[NAME] | Origination | 1281 | 5th
[NAME] | Origination | 1279 | 5th
[NAME] | Origination | 1275 | 5th
[NAME] | Communication | 1332 | 5th
[NAME] | Executive Staff | 1307 | 6th
[NAME] | Finance & Energy | 1258 | 5th
[NAME] | Commercial Development | 1176 | 5th
[NAME] | Executive Staff | 1306 | 6th
[NAME] | Origination | 1200 | 5th
MOBILES
[NAME] | 9233-7482
[NAME] | (065) 9972-1990
[NAME] | 9233-7463
[NAME] | 9233-7445
[NAME] | 9233-7480
[NAME] | (065) 9972-3052
[NAME] | 9233-7460
[NAME] | 9198-9700
[NAME] | 9606-0938
[NAME] | 9233-7437
[NAME] | 9969-2675
[NAME] | 9233-7426
[NAME] | (065) 9971-8115
[NAME] | (065) 9981-6071
[NAME] | 9233-7412
[NAME] | (071) 942-7310
[NAME] | 9233-7444
[NAME] | 9901-7431
Nassin Khan | 9233-7437
[NAME] | 9233-7470
[NAME] | 9233-7474
[NAME] | 9617-0860
[NAME] | 9233-7450
[NAME] | (065) 9972-1980
Spreadsheet: 154142d1336243820-excel-2007-combining-data-from-several-years-atropos-rank-for-chart
Sheet: Sheet1

GridRef | Easting | Northing | Site | Day | Month | Year | Date | Month | Rank |  | Row Number | B2 value
NU04I | 4020 | 6460 | site 1 | 2 | 7 | 2008 | 2008-07-02 00:00:00 |  |  | 1
NU2326 | 4230 | 6260 | site 1 | 2 | 7 | 2008 | 2012-02-09 00:00:00 |  |  | 2
NZ0543 | 4050 | 5430 | site 2 | 4 | 7 | 2008 | 2008-07-04 00:00:00 |  |  | 3
NU100435 | 4100 | 6435 | site 3 | 4 | 7 | 2008 | 2012-01-01 00:00:00 |  |  | 4
NU0943 | 4090 | 6430 | site 1 | 5 | 7 | 2008 | 2008-07-05 00:00:00 |  |  | 5
NU13NW | 4100 | 6350 | site 2 | 5 | 7 | 2008 | 2012-02-02 00:00:00 |  |  | 6
 |  |  |  | 3 | 7 | 2009 | 2009-07-03 00:00:00 |  |  | 7
 |  |  |  |  |  |  | 2012-08-06 00:00:00 |  |  | 8
 |  |  |  |  |  |  | 2012-09-06 00:00:00 |  |  | 9
 |  |  |  |  |  |  | 2012-10-01 00:00:00 |  |  | 10
 |  |  |  |  |  |  | 2012-11-05 00:00:00 |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: 215849d1361515165-searching-for-a-value-in-multiple-sheets-fame1
Sheet: KSRF-7(040912-17)

3.06 | 3.017 | 3.11 | TIC | 62282 | 0.22 | 32857 | 0.41 | 1.9 |  | (trans)-2-nonadecene
3.13 | 3.11 | 3.183 | TIC | 6265 | 0.02 | 3177 | 0.04 | 1.97 |  | Benzene, (2-decyldodecyl)- (CAS) 11-BENZYLHENEICOSANE
3.193 | 3.183 | 3.23 | TIC | 5302 | 0.02 | 3144 | 0.04 | 1.69 |  | 2-OCTADECYLOXY-1-O-HEXADECANOYL-1,1,2,2-TETRADEUTERO-ETHANOL
3.237 | 3.23 | 3.257 | TIC | 1802 | 0.01 | 1752 | 0.02 | 1.03 | V | METHYL 3-ACETYLPOLYPORENATE A.
3.637 | 3.63 | 3.643 | TIC | 1384 | 0 | 2160 | 0.03 | 0.64 |  | 14-Methyl-14-(3-oxobutyryloxy)-hexadec-15-enoic acid, methyl ester
3.647 | 3.643 | 3.677 | TIC | 4657 | 0.02 | 3092 | 0.04 | 1.51 | V | unknown quince ether
3.71 | 3.677 | 3.75 | TIC | 25813 | 0.09 | 10960 | 0.14 | 2.36 | V | Eicosanoic acid, methyl ester (CAS) ARACHIDIC ACID METHYL ESTER
3.77 | 3.75 | 3.773 | TIC | 4445 | 0.02 | 3611 | 0.04 | 1.23 | V | 2-Cyclohexen-1-ol, 2-methyl-5-(1-methylethenyl)-, propanoate
3.78 | 3.773 | 3.787 | TIC | 2271 | 0.01 | 4036 | 0.05 | 0.56 | V | 2H-Pyran-2-one, 5-ethylidenetetrahydro-4-(2-hydroxyethyl)-
3.819 | 3.787 | 3.853 | TIC | 13045 | 0.05 | 5362 | 0.07 | 2.43 | V | Methyl cis-secopimarate
3.86 | 3.853 | 3.883 | TIC | 5674 | 0.02 | 4616 | 0.06 | 1.23 | V | (-)-Isopulegol
3.89 | 3.883 | 3.907 | TIC | 3532 | 0.01 | 4657 | 0.06 | 0.76 | V | 2-Methyl-3-[(1S,2S)-2-ethyl-1,3,3-trimethylcyclohexyl]tetrahydrofuran
3.93 | 3.91 | 3.987 | TIC | 8879 | 0.03 | 2557 | 0.03 | 3.47 |  | E-2-decenal
4.005 | 3.987 | 4.023 | TIC | 5273 | 0.02 | 3586 | 0.04 | 1.47 | V | Bicyclopentyl-1'-en-1-ol
4.033 | 4.023 | 4.04 | TIC | 2193 | 0.01 | 3359 | 0.04 | 0.65 | V | Isocaucalol
4.06 | 4.04 | 4.077 | TIC | 3223 | 0.01 | 2689 | 0.03 | 1.2 | V | 1,2-Dimethyl-3,5,5-tri(2-cyanoethyl)pyperidone-4
4.127 | 4.077 | 4.133 | TIC | 5027 | 0.02 | 2755 | 0.03 | 1.82 | V | 5-Nitro-4-oxo-4,5,6,7-tetrahydrobenzofurazan
4.177 | 4.133 | 4.243 | TIC | 62014 | 0.22 | 25780 | 0.32 | 2.41 | V | 1-Nonadecene
4.273 | 4.243 | 4.34 | TIC | 9633 | 0.03 | 3267 | 0.04 | 2.95 |  | 2H-Pyran-2-one, 5-ethylidenetetrahydro-4-(2-hydroxyethyl)-
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 2005-06

Table F
Student Numbers by [NAME] and Method of Study
2005-06
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 5629 | 6265 |  | 103 | 87
%
Graduate | 2236 | 2501 |  | 1263 | 1215
%
Total
Spreadsheet: a3d58ced-e77f-46f0-b361-7f07630c4762
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | [NAME]
LA FABRIQUE
 | de la desserte de
RAPPORT ANNUEL
ÉTATS FINANCIERS
[NAME] 31 décembre 20___
Composition du conseil |  |  |  |  |  | Expiration
 |  |  |  |  |  | du mandat
Le pasteur : |  |  |  |  |  |  | 20
Le président ou la présidente : |  |  |  |  |  |  | 20
Le vice-président ou la vice-présidente: |  |  |  |  |  |  | 20
Les marguilliers et marguillières : |  |  |  |  |  | Expiration |  |  | Rééligible
 |  |  |  |  |  | du mandat |  |  | oui | non
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 20
Ces prévisions budgétaires ont été adoptées à l'assemblée de fabrique
[NAME] :
 |  |  | président ou présidente
 |  |  | secrétaire
Faire adopter les états financiers lorsqu'ils vous sont retournés par le vérificateur du diocèse
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index/Index Tranche | 27700 | 86195 | 120838 | 234733
OTHER* | 0 | 0 | 8810 | 8810
TOTAL | 27700 | 86195 | 129648 | 243543
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 883013d1731492292-adjust-requirement-so-that-total-order-volume-isnt-exceeded-fruit3
Sheet: Used

 | Split | Order Quantity | Sent | In | In2 | Stock incoming | Oustanding | Outstanding New
Fruit |  | 36 | 25 | 1 | 2 | 0 | 8 | 8
Apple | 0.22 | 8 | 11
Pear | 0.44 | 16 | 11
Orange | 0.12 | 4 | 1 |  | 2
[NAME] | 0.22 | 8 | 2 | 1
Spreadsheet: 780290d1652373984-return-multiple-values-across-many-rows-and-columns-20210302-projects-1-
Sheet: Dickson S72 Driveway

 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Design Review (including presentation meeting) | 11200 |  |  | 0 | 6800
 | Stage 2 | Technical Memo | 2240 |  |  | 0 | 2240
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
 |  | 2020-03-26 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Design Review (including presentation meeting) | 11200 |  |  | 6800
 | Stage 2 | Technical Memo | 2240 |  |  | 2240
 |  | Project Total |  |  |  | 9040
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 748896d1632404959-filter-an-array-apply-a-line-by-line-formula-and-sum-total-revenue_calc-ans
Sheet: Feuil1

 |  |  |  |  | 2021-01-01 00:00:00
 |  |  |  |  | 2021-06-30 00:00:00
Country | First day of service | Last day of service | Amount |  | USA
USA | 2021-01-05 00:00:00 | 2022-04-30 00:00:00 | 10000
France | 2019-12-01 00:00:00 | 2022-11-30 00:00:00 | 11000
USA | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 13000
France | 2020-10-01 00:00:00 | 2022-09-30 00:00:00 | 7000
France | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 13000
USA | 2020-10-01 00:00:00 | 2022-09-30 00:00:00 | 7000
 |  |  |  |  |  | How to calculate 5 415 € in a single formula?
 |  |  |  |  |  | [NAME]
Spreadsheet: 468297d1467218955-how-to-find-the-status-of-whether-its-rejected-or-in-process-icloud
Sheet: Sheet1

iCloud Source: Sunni Kumar
NO. | IMEI | SUBMITTED ON | REPLIED ON | STATUS | NO. OF DAYS |  | CLIENT | COST
1 | 355409070322593 | 2016-06-06 00:00:00 | 2016-06-28 00:00:00 | Rejected |  |  | Arsim | 80
2 | 358363067170423 | 2016-06-22 00:00:00 |  | In process |  |  | Chouchane | 80
3 | 354442060877152 | 2016-06-22 00:00:00 |  | In process |  |  | Chouchane | 80
4 | 352030074483786 | 2016-06-23 00:00:00 |  | In process |  |  | Chouchane | 80
5 | 353270072104419 | 2016-06-23 00:00:00 |  | In process |  |  | Chouchane | 80
Spreadsheet: 825238d1681207317-using-absolute-reference-with-structured-table-references-book1
Sheet: Sheet1

Q | W | E | R
1 | 2 | 3 | 4
5 | 6 | 7 | 8
 |  |  |  |  |  | 5 | 5 | 5
Spreadsheet: 40580d1238955284-median-with-date-range-sample_median_1
Sheet: Sheet1

740514 | 2990 | CLERMONT | A | 1199000 | 2006-09-18 00:00:00
755471 | 3390 | BELLAIRE | A | 1250000 | 2005-09-01 00:00:00
734627 | 3322 | CHERRY | S | 729000 | 2009-01-15 00:00:00 | 707000 | 2009-03-23 00:00:00 | 0 | N | 0 | BANK
730580 | 3034 | COLORADO | S | 325000 | 2009-01-01 00:00:00 | 315000 | 2009-03-05 00:00:00 | 6500 | CC | 0 | CORP
717435 | 3315 | BIRCH | S | 684900 | 2008-10-31 00:00:00 | 642000 | 2008-12-26 00:00:00 | 22335 | PP | 0 | BANK
714686 | 3200 | DAHLIA | S | 247900 | 2008-10-20 00:00:00 | 219000 | 2009-01-30 00:00:00 | 6570 | CC | 0 | INDIV
712029 | 3039 | CLERMONT | S | 324900 | 2008-10-14 00:00:00 | 320000 | 2008-12-24 00:00:00 | 0 | N | 0 | INDIV
711053 | 2848 | GRAPE | S | 199900 | 2008-10-10 00:00:00 | 200000 | 2008-11-03 00:00:00 | 5600 | CC | 0 | INDIV
708172 | 3070 | DAHLIA | S | 132900 | 2008-10-02 00:00:00 | 135600 | 2008-11-26 00:00:00 | 0 | N | 0 | BANK
708290 | 3051 | BELLAIRE | S | 640500 | 2008-10-02 00:00:00 | 535000 | 2009-03-04 00:00:00 | 0 | N | 0 | BANK
703374 | 3034 | COLORADO | S | 145900 | 2008-09-16 00:00:00 | 140000 | 2008-10-13 00:00:00 | 0 | N | 0 | BANK
709236 | 3357 | FLAMINGO | S | 220000 | 2008-09-16 00:00:00 | 176000 | 2009-01-16 00:00:00 | 0 | N | 0 | INDIV
729382 | 3024 | BIRCH | S | 845000 | 2008-08-29 00:00:00 | 712300 | 2009-02-04 00:00:00 | 6700 | CC | 0 | INDIV
695041 | 3021 | DEXTER | S | 236900 | 2008-08-22 00:00:00 | 185000 | 2009-03-12 00:00:00 | 0 | N | 0 | CORP
706328 | 2932 | FAIRFAX | S | 199900 | 2008-08-22 00:00:00 | 206000 | 2008-11-19 00:00:00 | 6000 | CC | 0 | INDIV
708269 | 4891 | CORNELL | S | 149900 | 2008-08-21 00:00:00 | 153000 | 2008-11-13 00:00:00 | 2000 | CC | 0 | BANK
691024 | 2806 | DAHLIA | S | 189900 | 2008-08-13 00:00:00 | 160000 | 2008-09-19 00:00:00 | 0 | N | 0 | INDIV
Spreadsheet: 31a8b43a-3414-4188-98bc-998e76d3e946
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
CDOM | Test | CDOM | Cadmium for Occupational Monitoring, [NAME] | Cadmium Occupational Monitor, U | CDUOM/7244: Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <3.0 mcg/g | Monday through Friday; 3 p.m. - 9 p.m.; Saturday, 8 a.m. - 3 p.m./Continuously | 1 day | 3 days |  | Profile |  |  |  |  | Rochester
CDOM | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CDOM | Component | CDUOM | Cadmium Concentration | [NAME] |  |  |  |  | 2 | mL | Only orderable as part of a profile. For further information see # 82385 Heavy Metals Screen Occupational Exposure, [NAME] and #80595 Cadmium Occupational Monitor, [NAME]. |  |  | Only orderable as part of a profile. For further information see #82385 Heavy Metals Screen Occupational Exposure, [NAME] and #80595 Cadmium Occupational Monitor, [NAME]. |  |  |  | 1 | 82300 |  |  | Yes | No
CDUOM | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CDUOM | Result | 860 | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5611-9
CDUOM | Result | 7242 | Cd/Creatinine Ratio | Cd/Creatinine Ratio | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | 13471-8
CDOM | Component | CDCR | [NAME] | [NAME] | For further information see #8513 "Creatinine, U." |  |  |  | 5 | mL | Only orderable as part of a profile. For further information  see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1
Spreadsheet: 1180dad4-42bf-4910-a0b1-76d0787f9822
Sheet: County

FIPS Code | County | POP2010 | WHITE | BLACK | AMERI_ES | ASIAN | HAWN_PI | OTHER | MULT_RACE | HISPANIC | [NAME] | FEMALES | AGE_UNDER5 | AGE_5_17 | AGE_18_21 | AGE_22_29 | AGE_30_39 | AGE_40_49 | AGE_50_64 | AGE_65_UP | MED_AGE | MED_AGE_M | MED_AGE_F | POP_HH | POP_GQ_INS | POP_GQ_NON | HOUSEHOLDS | AVE_HH_SZ | HSEHLD_1_M | HSEHLD_1_F | MARHH_CHD | MARHH_NO_C | MHH_CHILD | FHH_CHILD | FAMILIES | AVE_FAM_SZ | HSE_UNITS | VACANT | OWNER_OCC | RENTER_OCC
17031 | [NAME] | 5194675 | 2877212 | 1287767 | 21559 | 322672 | 1724 | 551971 | 131770 | 1244762 | 2514314 | 2680361 | 342493 | 889787 | 280442 | 669387 | 758468 | 704936 | 928833 | 620329 | 35.3 | 34 | 36.6 | 5104393 | 45749 | 44533 | 1966356 | 2.6 | 267067 | 342515 | 361549 | 442393 | 39181 | 149162 | 1211420 | 3.34 | 2180359 | 214003 | 1143857 | 822499
17043 | DuPage | 916924 | 714140 | 42346 | 2415 | 92304 | 217 | 45106 | 20396 | 121506 | 449351 | 467573 | 56940 | 170490 | 43211 | 94700 | 116620 | 141117 | 187448 | 106398 | 38.2 | 36.6 | 39.5 | 904784 | 6052 | 6088 | 337132 | 2.68 | 34246 | 47517 | 90672 | 102560 | 5306 | 16505 | 238014 | 3.24 | 356179 | 19047 | 251835 | 85297
17089 | [NAME] | 515269 | 384548 | 29422 | 2887 | 17895 | 193 | 66818 | 13506 | 158390 | 256815 | 258454 | 39870 | 109320 | 25011 | 51542 | 73285 | 77296 | 89255 | 49690 | 34.5 | 33.5 | 35.4 | 508482 | 3378 | 3409 | 170479 | 2.98 | 14849 | 18978 | 51061 | 49947 | 4187 | 10898 | 128323 | 3.45 | 182047 | 11568 | 130570 | 39909
17093 | Kendall | 114736 | 95891 | 6585 | 316 | 3467 | 33 | 5768 | 2676 | 17898 | 56821 | 57915 | 10092 | 25974 | 4564 | 11099 | 20231 | 17811 | 16583 | 8382 | 32.9 | 32.3 | 33.5 | 114528 | 173 | 35 | 38022 | 3.01 | 2829 | 3397 | 14119 | 10893 | 877 | 2149 | 30067 | 3.41 | 40321 | 2299 | 32554 | 5468
17097 | Lake | 703462 | 528204 | 49033 | 3279 | 44358 | 294 | 60008 | 18286 | 139987 | 351119 | 352343 | 47115 | 145557 | 37868 | 65111 | 88236 | 111286 | 135196 | 73093 | 36.7 | 35.1 | 38.1 | 682753 | 4872 | 15837 | 241712 | 2.82 | 22476 | 29434 | 72375 | 71690 | 5157 | 14920 | 179428 | 3.31 | 260310 | 18598 | 185213 | 56499
17111 | McHenry | 308760 | 278257 | 3283 | 939 | 7807 | 80 | 13194 | 5200 | 35249 | 153936 | 154824 | 19896 | 64279 | 14119 | 25899 | 39780 | 53454 | 60013 | 31320 | 38 | 37 | 38.8 | 307113 | 1337 | 310 | 109199 | 2.81 | 9980 | 11640 | 33218 | 34770 | 2271 | 5581 | 82288 | 3.25 | 116040 | 6841 | 90722 | 18477
17197 | Will | 677560 | 514664 | 75743 | 1703 | 30833 | 136 | 39025 | 15456 | 105817 | 336556 | 341004 | 49045 | 147909 | 33110 | 59957 | 96881 | 110684 | 117160 | 62814 | 35.4 | 34.5 | 36.3 | 669013 | 6353 | 2194 | 225256 | 2.97 | 18887 | 22892 | 73042 | 66503 | 4775 | 13821 | 174062 | 3.41 | 237501 | 12245 | 187425 | 37831
Spreadsheet: 539748d1506354333-convert-poorly-formatted-vendor-data-into-usable-data-vendor-test
Sheet: Sample

 |  |  |  |  | AAB Garage Door Inc
 |  | ID: | AABGARAGE |  |  |  | Status: | Active
 |  | Vendor: | AAB Garage Door Inc
 |  | 25333 Pennsylvania Ave. |  |  |  |  | Tax Name: | AAB Garage Door, Inc
 |  | Lomita, CA 90277 |  |  |  |  | Tax ID: | 111111111
 |  |  |  |  |  |  | 1099: | No
 |  | Work Order Style: | Standard |  |  |  | Invoice Check Memo:
 |  | #[NAME]!
 |  | [NAME]'s Comp: |  |  |  |  | Invoices per Check Limit:
 |  | Liability Insurance: | 2017-05-25 00:00:00 |  |  |  | Default Bill Code:
 |  |  |  |  |  |  | Discount Percentage:
 |  |  |  |  |  |  | Discount Flat Amount:
 |  |  |  |  |  |  | Discount Days:
Phone Numbers |  |  |  |  | [NAME]
Day: [PHONE]  Cell: [PHONE]
 |  |  |  |  | AA Garage Doors
 |  | ID: | AAGARAGE |  |  |  | Status: | Active
 |  | Vendor: | AA Garage Doors
 |  | 654 Walnut Drive |  |  |  |  | Tax Name: | [NAME]
 |  | Oxnard, CA 93036 |  |  |  |  | Tax ID: | 111111111
 |  |  |  |  |  |  | 1099: | Yes
 |  | Work Order Style: | Standard |  |  |  | Invoice Check Memo:
 |  | #[NAME]!
 |  | [NAME]'s Comp: |  |  |  |  | Invoices per Check Limit:
 |  | Liability Insurance: | 2018-06-19 00:00:00 |  |  |  | Default Bill Code:
 |  |  |  |  |  |  | Discount Percentage:
 |  |  |  |  |  |  | Discount Flat Amount:
 |  |  |  |  |  |  | Discount Days:
Phone Numbers |  |  |  |  | [NAME]
Contact: [PHONE]
 |  |  |  |  | Above All Roofing
 |  | ID: | ABOVEALL |  |  |  | Status: | Active
 |  | Vendor: | Above All Roofing
 |  | 1431 Bayview Dr., #204 |  |  |  |  | Tax Name: | [NAME]
 |  | Oxnard, CA 93035 |  |  |  |  | Tax ID: | 111111111
 |  |  |  |  |  |  | 1099: | Yes
 |  | Work Order Style: | Standard |  |  |  | Invoice Check Memo:
 |  | #[NAME]!
 |  | [NAME]'s Comp: |  |  |  |  | Invoices per Check Limit:
 |  | Liability Insurance: | 2018-06-01 00:00:00 |  |  |  | Default Bill Code:
 |  |  |  |  |  |  | Discount Percentage:
 |  |  |  |  |  |  | Discount Flat Amount:
 |  |  |  |  |  |  | Discount Days:
Phone Numbers |  |  |  |  | [NAME]
Contact: [PHONE]
 |  |  |  |  | American Home Shield
 |  | ID: | AHS |  |  |  | Status: | Active
 |  | Vendor: | American Home Shield
 |  | [NAME] 2803 |  |  |  |  | Tax Name:
 |  | Memphis, TN 38101-2803 |  |  |  |  | Tax ID: | 111111111
 |  |  |  |  |  |  | 1099: | Yes
 |  | Work Order Style: | Standard |  |  |  | Invoice Check Memo:
 |  | #[NAME]! |  |  |  |  | 1
 |  | [NAME]'s Comp: |  |  |  |  | Invoices per Check Limit:
 |  | Liability Insurance: | #[NAME]! |  |  |  | Default Bill Code: | Repairs
 |  |  |  |  |  |  | Discount Percentage:
 |  |  |  |  |  |  | Discount Flat Amount:
 |  |  |  |  |  |  | Discount Days:
Spreadsheet: 455673d1460463113-conditional-formatting-based-on-separate-workbook-truefalse
Sheet: Sheet2

 | 4692
 | 3689
 | 2029
 | 3480
 | 606
 | 3229
 | 2871
 | 312
 | 2613
 | 3568
 | 422
 | 370
 | 3807
 | 1221
 | 2851
 | 684
 | 4815
 | 3139
 | 2746
 | 4107
 | 2288
 | 3481
 | 1223
 | 2057
 | 1191
 | 2991
 | 3394
 | 1278
 | 2146
 | 1099
 | 4936
 | 1466
Spreadsheet: 178301d1346756899-strike-off-resource-once-used-on-a-particular-day-test
Sheet: Sheet1

Engineers Used |  |  |  |  |  |  | What I want it to show when engineer is selected
Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | Clive |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Clive |  |  |  |  |  | Clive | Clive | Clive | Clive | Clive
Spreadsheet: 72596d1273273295-data-form-example
Sheet: Sheet1

Reaction No. | Variable 1 | Variable 2 | Variable 3 | Mix RPM | Temp | Color
1 | a1 | a2 | a3 | a4 | a5 | a6
Min 1
Min 2
Min 4
Min 6
Min 8
Min 10
Min 12
Min 14
Min 16
Min 18
Min 20
Min 25
Min 30
Min 45
1 Hr
1 Hr 15 min
1 Hr 30 min
1 Hr 45 min
2 Hr
2 Hr 15 min
2 Hr 30 min
2 Hr 45 min
3 Hr
3 Hr 15 min
3 Hr 30 min
3 Hr 45 min
4 Hr
Spreadsheet: 157298d1337694530-determining-this-formula-for-validation-sample-text
Sheet: Sheet1

In Service | Validation | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00
2012-05-07 00:00:00 | True |  |  | 10 | 20 | 30
2012-06-09 00:00:00 | False | 10 | 20 | 30 | 40 | 50
Spreadsheet: 125424d1319027227-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-copy-of-example4
Sheet: Todd

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
49881 |  |  | D/C Sum Sig | 2011-07-21 00:00:00 | 2011-09-20 00:00:00 | DELIQUENT | Total # Yellow: | 2 | GOOD
80248 |  |  | ATT | 2011-09-30 00:00:00 |  | GOOD | Total # Orange: | 0 | GOOD
81602 |  |  | ATT | 2011-08-20 00:00:00 |  | DELIQUENT | Total # Red: | 2 | 2
78543 |  |  | DO | 2011-10-03 00:00:00 |  | GOOD | COMPLIENT: | 2 | 2
 |  |  |  |  |  |  | All Total: | 4 | 4