tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842870d1694862767-automatically-updates-score-sheet-live-sample1
Sheet: SELECTIONS

 | VENUE 1 |  |  |  |  |  |  |  |  |  |  | VENUE 2 |  |  |  |  |  |  |  |  |  |  | Venue 1 points per race |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Venue 2 points per race
NAME | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total |  | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | 1ST | 2ND | 3RD | total
HOPE
FAITH
ab
cb
db
ek
rk
sk
Spreadsheet: 43453d1242118662-sumif-for-a-specific-month-example-1-
Sheet: Sheet1

Job No. | Date Opened | MONTH | Date Closed | Value
1 | 2009-01-01 00:00:00 | 1 | 2009-01-21 00:00:00 | 100 |  |  | Value of Job Closed in -
2 | 2009-01-04 00:00:00 | 1 | 2009-01-24 00:00:00 | 112 |  | 1 | Jan | 761
3 | 2009-03-15 00:00:00 | 4 | 2009-04-04 00:00:00 | 349 |  | 2 | Feb | 513
4 | 2009-01-27 00:00:00 | 2 | 2009-02-15 00:00:00 | 415 |  | 3 | Mar | 767
5 | 2009-04-30 00:00:00 | 5 | 2009-05-10 00:00:00 | 1230 |  | 4 | Apr | 1054
6 | 2009-06-08 00:00:00 | 6 | 2009-06-28 00:00:00 | 980 |  | 5 | May | 1986
7 | 2009-03-12 00:00:00 | 4 | 2009-04-01 00:00:00 | 705 |  | 6 | Jun | 980
8 | 2009-01-04 00:00:00 | 1 | 2009-01-24 00:00:00 | 234 |  | 7 | Jul | 0
9 | 2009-04-17 00:00:00 | 5 | 2009-05-06 00:00:00 | 756 |  | 8 | Aug | 0
10 | 2009-01-03 00:00:00 | 1 | 2009-01-23 00:00:00 | 315
11 | 2009-02-23 00:00:00 | 3 | 2009-03-11 00:00:00 | 767
12 | 2009-02-15 00:00:00 | 2 | 2009-02-25 00:00:00 | 98
Spreadsheet: 684289d1593269353-replacing-list-of-usernames-with-matching-real-names-namesexample
Sheet: Sheet1

User | Items | Tasks | Time
username1 | 256 | 11 | 10:24:00
[NAME] | 216 | 10 | 10:46:06
username3 | 213 | 9 | 12:12:53.333000
username4 | 194 | 9 | 11:44:46.667000
username5 | 175 | 9 | 11:43:26.667000
username6 | 172 | 6 | 14:44:20
username7 | 161 | 7 | 12:53:34.286000
username8 | 161 | 7 | 14:55:25.714000
username9 | 160 | 7 | 15:07:25.714000
username10 | 158 | 7 | 14:22:34.286000
Spreadsheet: 171623d1343804445-creating-electronic-form-using-design-mode-test_ac31july-bvj
Sheet: Sheet1

RISK ASSESSMENT Template: |  |  |  |  |  |  |  |  |  |  |  | Product Type | Manufacturing Sites | Number of Presentations | Proposed Manufacturing Line | Manufacturing Responsibility
 |  |  |  |  |  |  |  |  |  |  |  | NOT DEFINED | Site 1 | One | A | Plant A
Product Name: |  |  |  |  |  |  |  |  |  |  | Comments: | Solution | Site 2 | Two | B | Plant B
 |  |  |  |  |  |  |  |  |  |  |  | Lyophilised | Site 3 | Three | C | NOT DEFINED
RISK FORM |  |  |  |  |  |  |  |  |  |  |  | Syringe | Site 4 | Four | D
1. Product Overview                                                                                                                                      (for project responsibilities see attached worksheet two) |  |  |  |  |  |  |  |  |  |  |  | Ampoule | Site 5 | Five | E
Product Name: |  |  |  | Definition Type: | Solution | Prototype Development Reference: |  |  |  |  |  |  | Other | Six | F
Project Type: | Transfer (PSC)                    Contract Manufacturing                    PE (Development)                    Commercial/PPQ                    Line Switch                        Other |  |  |  |  |  |  |  |  |  |  |  |  |  | G
Proposed Manufacturing Site: |  |  |  | Proposed Manufacturing Line:(if applic) |  |  | Transfer From:       (if applic.) |  |  |  |  |  |  |  | SPD/SPA
Product Type: | Aqueous | Non-Aqueous | Solution | Freeze Dried | Cytotoxic | Non-Cytotoxic | Other:
[NAME] (mg/mL): |  |  | Number of Presentations: |  | Description of Presentations:
Target Region: | Global | US | EU | JP | APAC | Canada | ROW | Other
Target Timelines: | [NAME]: |  | Dossier Submission: |  | [NAME]: |  | Commercial Launch:
2. Prior [NAME]: (If available)                                    If no prior history available tick n/a and proceed to next section |  |  |  |  |  |  |  | n/a
Product New to Site? (Yes/No) |  |  | Product Previously Produced at EBEWE? (Yes/No) |  |  |  | Product Produced at Alternative Site? (Yes/No), if Yes define site
Same Concentration Previously Manufactured? (Yes/No) |  |  |  | If NO, Description: |  |  | If YES, Reference:
Same Presentations Previously Manufactured? (Yes/No) |  |  |  | If NO, Description: |  |  | If YES, Reference:
Previous Validation Data Available? (Yes/No) |  |  |  | If NO, Description: |  |  | If YES, Reference:
 | Aspect A |  | B | C | D | E | F | G
API (Primary)
Spreadsheet: 142742d1329996158-how-to-create-graph-which-point-one-risk-level-at-one-time-matrix-data-and-graph
Sheet: Data

 | Likelihood Rating | Impact Rating | Risk Level
 | L3_Unlikely | I3_Minor
 | L1_Frequent | I4_Insignificant
 | L4_Improbable | I4_Insignificant
 | L1_Frequent | I1_Disastrous
 | L1_Frequent | I2_Major
Spreadsheet: 982693cc-f68d-4713-83c6-14b81abe78d7
Sheet: Sheet1

物理系考試委員會建議口試委員名單(Department recommended committee member) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
序號 | 姓名 | Name | 專長 | Specializations | 研究室  Research Room | 分機號碼Extension Phone | email
1 | 伊　林 | [NAME] I | 電漿 / 薄膜物理與技術 / [NAME] | Plasma and fluid physics / Nonlinear complex system / Complex system / Soft matter / micro-nano physics and technology | S4-704 | 65306 | lini{at}phy.ncu.edu.tw
2 | 李文獻 | [NAME] | 磁性 / 超導 / 中子散射 / 拉曼散射 | Magnetic superconductor / Nanoparticles | S4-608 | 65317 | whli{at}phy.ncu.edu.tw
3 | 易台生 | T.S. Yih | 原子分子物理 / 非線性光學 / 凝體物理 | Atomic and molecular physics | S4-738 | 65314 | tsyih{at}phy.ncu.edu.tw
4 | 林宗泰 | [NAME] | 高能物理實驗 | Experimental high energy physics | S4-602 | 65305 | t221312{at}ncu.edu.tw
5 | 林留玉仁 | [NAME] | 電漿/凝態/非線性理論 | Plasma/Condensed Matter Physics/Nonlinear Complex System | S4-714 | 65344 | linliu{at}ncu.edu.tw
6 | 倪簡白 | J.B. Nee | [NAME] | UVSynchrotron radiation spectroscopoy / Atmospheric remote sensing / Space physics | S4-619 | 65311 | jbnee{at}phy.ncu.edu.tw
7 | 徐子民 | [NAME] | 凝態科學─半導體光學 | Condensed matter physics─Semiconductor Optics | S4-606 | 65334 | tmhsu{at}phy.ncu.edu.tw
8 | 張元翰 | [NAME] | 高能物理實驗 | Experimental high energy physics | S4-605 | 65336 | changy{at}pchep.phy.ncu.edu.tw
9 | 陳宣毅 | [NAME] | 理論軟凝態物理 / [NAME] / 生物物理 | Soft condensed matter theory | S4-703 | 65367 | hschen{at}phy.ncu.edu.tw
10 | 陳培亮 | [NAME] | 型態形成 / 複雜系統 / 軟物質 | Pattern formation / Complex system / Soft matter | S4-707 | 65364 | peilong{at}phy.ncu.edu.tw
11 | 陳鎰鋒 | [NAME] | 高能物理實驗 | Experimental high energy physics | S4-609 | 65329 | t220042{at}ncu.edu.tw
12 | 黎璧賢 | Pik-Yin Lai | [NAME] / 軟凝態物理 | Statistical physics / Soft condensed matter | S4-712 | 65330 | pylai{at}phy.ncu.edu.tw
13 | 賴山強 | [NAME] | 凝態物理理論 | Condensed matter theory | S4-616 | 65312 | sklai{at}cliq.phy.ncu.edu.tw
14 | 聶斯特 | [NAME] | 重力場與相對論 | Relativity and Gravitational Physics | S4-716 | 65322 | nester{at}phy.ncu.edu.tw
15 | 羅夢凡 | [NAME] | 奈米科學 / 表面物理 | Nanoscience / Surface physics | S4-736 | 65349 | mfl28{at}phy.ncu.edu.tw
16 | 蔣正偉 | [NAME] | 基本粒子現象學 | Elementary particle phenomenology | S4-622 | 65379 | chengwei{at}phy.ncu.edu.tw
17 | 陳江梅 | [NAME] | 重力場 / 宇宙學 / 弦論 | Gravitation / Cosmology and [NAME] | S4-710 | 65327 | cmchen{at}phy.ncu.edu.tw
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: February

 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00 |  |  |  |  | Total Hours
[NAME]
Scott
Adam
 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 1d46b692-b333-4d38-b0f8-8036ebc9f86e
Sheet: T75

الجدول 75:  الزواج  المسجل، 2000-2012
Table 75: Registered marriages, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 3963 | 4504 | 4909 | 5373 | 4929 | 4669 | 4724 | 4981 | 4896 | 5067 | 4960 | 6769 | 7559 | البحرين
Egypt | 592381 | 457534 | 510517 | 537092 | 550709 | 522751 | 522887 | 614848 | 660159 | 759004 | 864857 | 865853 | … | مصر
Iraq | 171134 | … | … | 256494 | 262554 | … | … | … | … | 249430 | 245022 | … | … | العراق
Jordan | 45618 | 49794 | 46873 | 48784 | 53754 | 56418 | 59335 | 60548 | 60922 | 63389 | 62107 | 64665 | ... | الأردن
Kuwait | 10853 | 11916 | 11973 | 12246 | 12359 | 12419 | 12584 | 13315 | 14709 | 14526 | 13993 | 19860 | … | الكويت
Lebanon | 32564 | 32225 | 31653 | 30636 | 30014 | 29705 | 29078 | 35796 | 37593 | 40565 | 41758 | 42500 | 38691 | لبنان
Libya | 27655 | 28661 | 33323 | 36721 | 39105 | 43979 | 47219 | 59589 | 65326 | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | 307575 | 314400 | 313356 | … | … | [NAME]
Oman | … | … | … | … | … | … | … | … | 29288 | 24924 | … | 26540 | … | عمان
Palestine | 23890 | 24635 | … | … | … | … | … | … | 35777 | 38316 | 37228 | 36284 |  | فلسطين
Qatar | 2096 | 2194 | 2351 | 2550 | 2649 | 2734 | 3019 | 3206 | 3235 | 3153 | 2977 |  | … | قطر
Saudi Arabia | 79595 | 81576 | 90982 | 98343 | 111063 | 105066 | 115549 | 130451 | 144436 | 148043 | 142607 | 162880 | … | المملكة العربية السعودية
Sudan | … | … | … | … | … | … | … | … | 29288 | … | … | … | … | السودان
Syrian Arab Republic | 82672 | 153842 | 174449 | 174449 | 178166 | 179075 | 205557 | 237592 | … | 241422 | 227808 | … | … | الجمهورية العربية السورية
Tunis | … | … | 61322 | 63676 | 68976 | 73971 | 81340 | 76809 | 78748 | 81605 | 87081 | 91590 | … | تونس
United Arab Emirates | 8970 | 10030 | 11285 | 12277 | 12794 | 12984 | 13190 | 13321 | 15041 | 15155 | 15104 | 15105 | … | الإمارات العربية المتحدة
Yemen | 5375 | 9120 | 10934 | 600 | 715 | … | … | … | … | … | … | … | … | اليمن
Spreadsheet: 812072d1672937704-formula-required-to-calculate-equivalent-values-distribution
Sheet: Sheet1

1 | 20 |  |  | 1 | 20
0.4 | 5
 |  |  |  |  | 5
Spreadsheet: 4f1520f0-7228-49e1-985a-ea47ebad2bd8
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
FOATG | Test | FOATG | [NAME] | [NAME] | Enzyme immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FOATG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FOATG | Result | FOATG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 51644d1251283229-counting-conditional-formatting-aug-backups
Sheet: 6th

Internt Backups |  |  | [NAME]
Customer/ server/ [NAME] job | Backup success |  | Customer/ server/ [NAME] job | Backup success |  |  | Y | Backup successful
Artist Indepenent |  |  | Able Services |  |  |  | N | Failed
AIFDC1-SYS-STATE | y |  | ADSDC1 | Y |  |  | o | Backup Not found
AIFDCI-DATA | y |  | Finnsish Chamber of Commerce
AIFDC1-MSEXCH | Y |  | FBCCS01 | o
AIFDC1-PST | y |  | LP Networks
Axis Security |  |  | LPNETDC1 | Y
[NAME] | y |  | ML Select
AXISDC1-DATA | y |  | MLSDC1 | y
AXISDC1-MSEXCH | y |  | [NAME]
AXISDC1-BRICKLEVEL | y |  | SIDEKIXDC1 | o
AXISDC1-SQL | y
Colombier
[NAME] | y
COLUKDC1-DATA | y
COLUKDC1-PST | y |  | Date updated | 2009-08-06 00:00:00
COLUKSRV1-SYS-STATE | y
COLUKSRV1-SQL | y
COLUKSRV1-DATA | y
COLUKSRV2-SYS-STATE | y
COLUKSRV2-DATA | y
Finch & Partners
FINCHDC1-DATA | y
FINCHDC1-MSEXCH | y
Glasshouse Entertainment
GOLCONDALA-SYS-STATE | y
GOLCONDALA-DATA | y
GOLCONDALA-MSEXCH | y
GOLCONDALA-PST | y
LOGO69
LOGODC1-SYS-STATE | y
[NAME] | y
LOGODC1-DATA | y
LOGODC1-PST | y
LPM Cleaning
LPMDC1-SYS-STATE | Y
LPMDC1-DATA | Y
LPMDC1-EXCH | Y
LPMDC2-SYS-STATE | Y
LPMDC2-SQL | Y
LPMDC2-DATA | Y
TMS-SYS-STATE | Y
TMS-SQL | Y
TMS-DATA | Y
[NAME]
NGDC1-SYS-STATE | Y
NGDC1-MSEXCH | Y
NGDC1-DATA | Y
Tavistock
TWOODSO1-SYS-STATE | Y
TWOODS01-DATA | Y
TWOODS01-MSEXCH | Y
TWOODS01-PST | Y
Spreadsheet: 0271b104-3c1b-472c-a2f0-8915dea615a8
Sheet: Reference Values

[NAME]
Natural gas
#2 / distillate fuel oil
[NAME] blend
Steam
Propane
Emission Factor "Savings" for Fuel Switch
Relative to a baseline of B2 #6 / Residual Fuel Oil
Fuel Type | Emission Factor "Savings"
 | (ton CO2e/MMBtu)
B100
Propane
Calculation of Biodiesel Volumetric Breakdown
% B100 in biodiesel blend (by volume):
 | MMBtu B100 per gallon of biodiesel blend
 | MMBtu #2 / distillate fuel oil per gallon of biodiesel blend
 | B100 on an [NAME] basis
 | #2 / distillate fuel oil on an [NAME] basis
Rule for Biodiesel Blend Incentive Level Designation
Threshold at or above which the $50/ton CO2e incentive level applies: |  |  |  | % | biodiesel
Vehicle Emissions
Estimated annual tons of CO2e emitted by a car: |  |  |  | tons/yr
Spreadsheet: 784981d1656058209-unique-sort-filter-validation-lists-and-arrays-picker
Sheet: Sheet2

Pick | Count | Output | Picker
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME],Ford
[NAME],[NAME]
[NAME],Adair
[NAME],Hernandez
[NAME],Jenkins
[NAME],[NAME]
[NAME],Rodriguez
[NAME],[NAME]
[NAME],Ledger
[NAME],[NAME]
Spreadsheet: jonathan_mckay__17197__us open
Sheet: Tha Playas

1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | Bernhard Langer
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | Briny Baird
20 | [NAME]
21 | [NAME]
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | [NAME]
27 | [NAME]
28 | [NAME]
29 | [NAME]
30 | [NAME]
31 | [NAME]
32 | [NAME]
33 | [NAME]
34 | [NAME]
35 | [NAME]
36 | [NAME]
37 | [NAME]
38 | [NAME]
39 | [NAME]
40 | [NAME]
41 | [NAME]
42 | [NAME]
43 | [NAME]
44 | [NAME]
45 | Duffy Waldorf
46 | [NAME]
47 | [NAME]
48 | Esteban Toledo
49 | [NAME]
50 | [NAME]
51 | [NAME]
52 | Fred Funk
53 | [NAME]
54 | [NAME]
55 | [NAME]
56 | [NAME]
57 | [NAME]
58 | [NAME]
59 | [NAME]
60 | [NAME]
61 | [NAME]
62 | J L Lewis
63 | [NAME]
64 | [NAME]
65 | [NAME]
66 | [NAME]
67 | [NAME]
68 | [NAME]
69 | [NAME]
70 | [NAME]
71 | [NAME]
72 | [NAME]
73 | [NAME]
74 | [NAME]
75 | [NAME]
76 | [NAME]
77 | [NAME]
78 | [NAME]
79 | [NAME]
80 | [NAME]
81 | [NAME]
82 | [NAME]
83 | [NAME]
84 | K J Choi
85 | [NAME]
86 | [NAME]
87 | [NAME]
88 | [NAME]
89 | [NAME]
90 | [NAME]
91 | [NAME]
92 | [NAME]
93 | [NAME]
94 | [NAME]
95 | [NAME]
96 | [NAME]
97 | [NAME]
98 | [NAME]
99 | [NAME]
100 | [NAME]
101 | [NAME]
102 | [NAME]
103 | [NAME]
104 | [NAME]
105 | [NAME]
106 | [NAME]
107 | [NAME]
108 | [NAME]
109 | [NAME]
110 | [NAME]
111 | [NAME]
112 | [NAME]
113 | [NAME]
114 | [NAME]
115 | [NAME]
116 | [NAME]
117 | [NAME]
118 | Retief Goosen
119 | [NAME]
120 | [NAME]
121 | [NAME]
122 | [NAME]
123 | [NAME]
124 | Rocco Mediate
125 | [NAME]
126 | [NAME]
127 | [NAME]
128 | [NAME]
129 | [NAME]
130 | [NAME]
131 | Shaun Micheel
132 | [NAME]
133 | Skip Kendall
134 | [NAME]
135 | [NAME]
136 | [NAME]
137 | [NAME]
138 | [NAME]
139 | [NAME]
140 | [NAME]
141 | [NAME]
142 | [NAME]
143 | [NAME]
144 | [NAME]
145 | [NAME]
146 | [NAME]
147 | [NAME]
148 | [NAME]
149 | [NAME]
150 | [NAME]
151 | Toru Taniguchi
152 | Toshimitsu Izawa
153 | Tripp Isenhour
154 | [NAME]
155 | [NAME]
156 | [NAME]
Spreadsheet: 827425d1682691360-expiry-date-excel-formula-expiry-date-formula
Sheet: Sheet1

 |  |  |  | Enter date |  |  |  | I am looking for
 |  |  | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Condition - When Inspected date(E6) is before & within 10 to 12 calender month from Exisiting expiry date (E3), the result of next inspection date (G4) will be 364 days from existing expiry date.
 |  |  |  |  |  | 2021-03-24 00:00:00 | result
 |  |  |  | Enter date
 |  |  | inspected date | 2020-02-21 00:00:00 |  |  |  | If above condition is not satisfy then Next inspection date (G4)  will be count (364 days)  from inspected date (E6).
 |  | At different scenario
 |  |  |  |  |  |  |  | Inspected date is before & within 10 to 12 calender month from existing expiry date. Result of next inspection date will be 364 days from existing expiry date.
 |  | Scenario - 1 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date
 |  |  |  |  |  | 2021-03-24 00:00:00 | result
 |  |  | inspected date | 2020-02-21 00:00:00
 |  | Scenario - 2 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Inspected date is after existing expiry date. Result of next inspection date will be 364 days from inspected date
 |  |  |  |  |  | 2021-03-27 00:00:00 | result
 |  |  | inspected date | 2020-03-28 00:00:00
 |  | Scenario - 3 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Inspected date is before but Not within 10 to 12 calender month from existing expiry date. Result of next inspection date will be 364 days from inspected date
 |  |  |  |  |  | 2021-01-22 00:00:00 | result
 |  |  | inspected date | 2020-01-23 00:00:00
Spreadsheet: 741093d1626810264-calculating-tenure-based-on-start-date-and-end-date-example-1-
Sheet: Sheet1

Employee number | Department | Job Title | Start date | Departure Date | Termination Reason
185 | Marketing | Events Coordinator | 2017-10-19 00:00:00 | 2020-02-07 00:00:00 | Voluntary - Higher Compensation
148 | Customer Solutions | Business Analyst | 2017-06-04 00:00:00 | 2020-03-19 00:00:00 | Voluntary - Grad school
114 | Customer Solutions | Senior [NAME] Manager | 2016-09-28 00:00:00 | 2020-03-27 00:00:00 | Voluntary - Other
53 | Customer Solutions | Senior Product Manager | 2015-05-28 00:00:00 | 2020-04-12 00:00:00 | Voluntary - Higher Compensation
56 | Customer Solutions | Technical Associate | 2015-06-15 00:00:00 | 2020-04-16 00:00:00 | Involuntary - Performance
90 | Engineering | Senior Interface Engineer | 2016-05-29 00:00:00 | 2020-05-19 00:00:00 | Voluntary - Higher Compensation
137 | Customer Solutions | Senior Consultant, Client Services | 2017-02-18 00:00:00 | 2020-08-21 00:00:00 | Involuntary - Performance
115 | Customer Solutions | Business Analyst | 2016-09-25 00:00:00 | 2020-09-29 00:00:00 | Voluntary - Other
159 | Customer Solutions | Resolution Specialist | 2017-06-01 00:00:00 | 2020-10-08 00:00:00 | Voluntary - Other
188 | Customer Solutions | Consultant, Client Services | 2017-12-03 00:00:00
181 | Engineering | Data Analyst | 2017-11-17 00:00:00
186 | Marketing | Senior Designer | 2017-11-09 00:00:00
183 | Customer Solutions | Associate Product Manager | 2017-11-06 00:00:00
187 | Engineering | QA Team Lead | 2017-11-01 00:00:00
182 | Customer Solutions | Senior Product Manager | 2017-10-15 00:00:00
176 | Customer Solutions | Associate Product Manager | 2017-10-06 00:00:00
178 | Customer Solutions | Manager, Support | 2017-10-05 00:00:00
Spreadsheet: 74843d1275397265-excel-2007-rank-players-by-name-ranks-1-
Sheet: Ranks

 |  |  |  |  |  |  |  |  |  |  |  | Points (testing)
Player | Win | Loss | [NAME] | Win % |  |  |  | Ranks
Strassberg | 6 | 16 |  |  |  | Rank by Points | Rank by Total Wins | Rank by [NAME] |  |  |  | Total | Win(10) | Loss(-5)
[NAME] | 22 | 13 |  |  | 1 |  |  |  |  |  | Strassberg
R2D2 | 20 | 14 |  |  | 2 |  |  |  |  |  | [NAME]
Boom Boom Powell | 18 | 17 |  |  | 3 |  |  |  |  |  | R2D2
Easy Out | 4 | 16 |  |  | 4 |  |  |  |  |  | Boom Boom Powell
[NAME] | 12 | 11 |  |  | 5 |  |  |  |  |  | Easy Out
Sexiest [NAME] | 3 | 5 |  |  | 6 |  |  |  |  |  | [NAME]
Corn | 3 | 3 |  |  | 7 |  |  |  |  |  | Sexiest [NAME]
[NAME] | 1 | 7 |  |  | 8 |  |  |  |  |  | Corn
Yo Gabby Gabby | 0 | 3 |  |  | 9 |  |  |  |  |  | [NAME]
[NAME] | 1 | 3 |  |  | 10 |  |  |  |  |  | Yo Gabby Gabby
[NAME] (retired) | 27 | 5 |  |  | 11 |  |  |  |  |  | [NAME]
The Hammer | 5 | 2 |  |  | 12 |  |  |  |  |  | [NAME] (retired)
 |  |  |  |  | 13 |  |  |  |  |  | The Hammer
 |  |  |  |  | 14
 |  |  |  |  | 15
 |  |  |  |  | 16
 |  |  |  |  | 17
 |  |  |  |  | 18
 |  |  |  |  | 19
 | Red = .50 and under |  |  |  | 20
 | Yellow = between .51 and .98
 | Green = 1.0 and over
Spreadsheet: 726625d1617332301-conditional-formatting-icon-color-change-or-a-work-around-test-1-
Sheet: AviCric

 | 2026-03-01 00:00:00 | 2027-03-01 00:00:00 | 2028-03-01 00:00:00 | 2029-03-01 00:00:00 | 1930-03-01 00:00:00 | 1931-03-01 00:00:00 | 2001-04-01 00:00:00 | Average
0-3 days | 2138 | 2195 | 1944 | 1836 | 1836 | 2357 | 2578 |  |  |  |  |  | ã
4-7 days | 1019 | 974 | 992 | 1117 | 1288 | 1323 | 1137 |  |  |  |  |  | ä
8-15 days | 700 | 682 | 697 | 737 | 857 | 833 | 866
16-21 days | 157 | 139 | 151 | 154 | 154 | 169 | 178
22-30 days | 82 | 76 | 85 | 88 | 99 | 97 | 86
1 months+ | 60 | 60 | 63 | 62 | 68 | 66 | 53
Grand total
Spreadsheet: 56668d1256814074-excel-2007-help-in-creating-an-invoice-invoice
Sheet: Sheet1

Company Name | Product No | Commission Rate | Est Annual Usage | [NAME] | Date Sold | Date Expected
M | 1 |  | 100 | A
N | 2 |  | 200 | B
O | 3 |  | 300 | C
P | 4 |  | 400 | D