tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329770a6-d679-4d60-ac06-f4f0cb713c90
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of March 15 - March 17 2010
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1.6um
SVG                         Coater | Date (Coat) | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2 | 1
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4 | 5
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3 | 2
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 2010-03-17 00:00:00
 | Top (A) | 10106 | 16865 | 71259 | 10262 | 17077 | 30084 | 15888 | - | -
 | Center (A) | 10087 | 16891 | 71232 | 10210 | 17081 | 30038 | 15880 | - | -
 | Flat (A) | 10108 | 16865 | 71254 | 10265 | 17052 | 30098 | 15884 | - | -
 | Left  (A) | 10117 | 16868 | 71311 | 10249 | 17070 | 30047 | 15915 | - | -
 | Right (A) | 10110 | 16884 | 71180 | 10261 | 17051 | 30102 | 15882 | - | -
 | Average (A) | 10105.6 | 16874.6 | 71247.2 | 10249.4 | 17066.2 | 30073.8 | 15889.8 | - | -
 | [NAME]  (A) | 11.19374825503146 | 12.09545369185964 | 47.44154297458363 | 22.85388369614713 | 13.98928161086477 | 29.51609730380498 | 14.39444337194318 | - | -
 | Comments |  |  |  |  |  |  | 3617m
Exposure | Date (Exposure) | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.s | 1.6s | 3.5s x2 | 1.0s | 1.3s | 2.1 | 1.6s
 | Problems
SVG                            Developer | Date (Develop) | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2 | 1
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none | 2
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7 | 4
 | Post-base Program | 1 | 2 | none | 1 | 2 | none | 2
 | Problems
Resolution                         Measurements | Date (Measurement) | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00
 | Top (H/V) (um) | 1/1 | 1/1.5 | 2.5/2.5 | 1/1.5 | 1/1.5 | 1.5/1.5 | 1.5/1.5
 | Center (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/3 | 1/1 | 1/1 | 1.5/1.5 | 1.5/2
 | Flat (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | 1/1.5 | 1/1.5 | 1/1.5 | 1/1.5
 | Left (H/V) (um) | 1/1 | 1/1.5 | 2/2.5 | 1/1.5 | 1/1.5 | 1.5/1.5 | 1.5/1.5
 | Right (H/V) (um) | 1/1.5 | 1.5/2 | 2.5/3 | 1/1.5 | 1/1.5 | 1.5/1.5 | 1.5/1.5
 | Comments | 1.3 dark | 1.5 dark | 3.5-3.6 dark | 1.1 dark | 1.3 - 1.4 dark | 2 dark | 1.5 dark
Spreadsheet: 705183d1605904139-subtraction-formula-with-conditional-logic-update-needed-sampy
Sheet: Sheet1

 |  |  |  |  | Current Formula: | Expected Value:
Net | 0 | 0 | N | 5233 |  | Column F is correct
2 | 0 | 0 | N | 1000000 |  | Column F is correct
Net | 107506615 | 0 | N | 2659189 |  | Column F is correct
Net | 0 | 0 | N | 856143 |  | Column F is correct
Net | 0 | 0 | N | 33583872 |  | Column F is correct
Net | 0 | 0 | N | 103075167 |  | Column F is correct
2 | 8333060 | 0 | 98694 | 98694 |  | Column F is correct
2 | 72107146 | 0 | 158725 | 158725 |  | Column F is correct
Net | 60757242 | 0 | N | 1369063 |  | Column F is correct
2 | 186580337 | 0 | N | 721371 |  | Column F is correct
Net | 30214377 | 0 | N | 281517 |  | Column F is correct
Net | 0 | 15 | 1423 | 37821
Net | 0 | 1 | N | 226602221 |  | Column F is correct
Net | 781102 | 0 | N | 40210 |  | Column F is correct
2 | 3481021 | 1 | 21999 | 21999 |  | Column F is correct
2 | 0 | 1 | 23707 | 23708 |  | Column F is correct
Net | 0 | 1 | N | 9904 |  | Column F is correct
2 | 75311382 | 1 | 3645332 | 3645332 |  | Column F is correct
Net | 0 | 1 | 5071487 | 61110826
2 | 3786012 | 1 | 251781 | 251781 |  | Column F is correct
Net | 0 | 1 | N | 575856 |  | Column F is correct
Net | 0 | 1 | 192955 | 64099169
Net | 0 | 1 | 241264 | 839486
Net | 0 | 1 | 4125 | 226205116
Net | 305425 | 1 | 27559 | 185120069 |  | Column F is correct
2 | 694332 | 1 | 694262 | 339948 |  | Column F is correct
Net | 11263 | 1 | 6065 | 144416 |  | Column F is correct
Spreadsheet: 89f35ce3-8171-4735-931e-9cb1753d7260
Sheet: Sheet1

BONUS SYSTEM IN ID GHANA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Computation table : | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
valid since 01 Jan 2008
 |  |  |  |  |  |  |  |  | % | Cedis | % | Cedis
Repayment rate in %
 |  |  |  |  |  |  |  |  | 91 | 7 | 96 | 18
Basis : | 90 | : |  |  |  | 5 |  |  | 92 | 9 | 97 | 21
 | 91 | to | 95 | : | + | 2 | / 1 % |  | 93 | 11 | 98 | 24
 | 96 | to | 100 | : | + | 3 | / 1 % |  | 94 | 13 | 99 | 27
 |  |  |  |  |  |  |  |  | 95 | 15 | 100 | 30
[NAME] in number of active Partners
 |  | : |  |  |  |  |  |  | ((Actual number of active Partners - Basis)    x 0,23) + 7,00
Basis : | 200 | : |  |  |  | 7 |  |  | with a maximum of 30,00 GHC
 | 201 | to | 300 | : | + | 0.23 | / partner
 |  |  |  |  |  |  |  |  |  | Cedis | % | Cedis | % | Cedis | % | Cedis
Retention rate in %
 |  | : |  |  |  |  |  |  | 71 | 9 | 76 | 14 | 81 | 19.2 | 86 | 25.2
Basis : | 70 | : |  |  |  | 8 |  |  | 72 | 10 | 77 | 15 | 82 | 20.4 | 87 | 26.4
 | 71 | to | 80 | : | + | 1 | / 1 % |  | 73 | 11 | 78 | 16 | 83 | 21.6 | 88 | 27.6
 | 81 | to | 90 | : | + | 1.2 | / 1 % |  | 74 | 12 | 79 | 17 | 84 | 22.8 | 89 | 28.8
 |  |  |  |  |  |  |  |  | 75 | 13 | 80 | 18 | 85 | 24 | 90 | 30
 |  |  |  |  |  |  |  |  | % | Cedis | % | Cedis
PAR at 30 days in %
 |  |  |  |  |  |  |  |  | 14 | 11 | 9 | 16.2 | 4 | 22.8
Basis : | 15 | : |  |  |  | 10 |  |  | 13 | 12 | 8 | 17.4 | 3 | 24.6
 | 14 | to | 10 | : | + | 1 | / 1 % |  | 12 | 13 | 7 | 18.6 | 2 | 26.4
 | 9 | to | 5 | : | + | 1.2 | / 1 % |  | 11 | 14 | 6 | 19.8 | 1 | 28.2
 | 4 | to | 0 | : | + | 1.8 | / 1 % |  | 10 | 15 | 5 | 21 | 0 | 30
If [NAME] or [NAME] falls below the Basis : no bonus at all
Spreadsheet: 664151d1582478638-how-to-loop-through-values-using-power-query-stockdownload
Sheet: Institutional

Symbol | Holder | Shares | Date Reported | % Out | Value
MSFT | Vanguard Group, Inc. (The) | 623667281 | 2019-12-30 00:00:00 | 0.082 | 98352330213
MSFT | Blackrock Inc. | 515197221 | 2019-12-30 00:00:00 | 0.0677 | 81246601751
MSFT | State Street Corporation | 315672520 | 2019-12-30 00:00:00 | 0.0415 | 49781556404
MSFT | FMR, LLC | 239124143 | 2019-12-30 00:00:00 | 0.0314 | 37709877351
MSFT | Capital World Investors | 180557630 | 2019-12-30 00:00:00 | 0.0237 | 28473938251
MSFT | Price (T.Rowe) Associates Inc | 175036277 | 2019-12-30 00:00:00 | 0.023 | 27603220882
MSFT | Geode Capital Management, LLC | 113401519 | 2019-12-30 00:00:00 | 0.0149 | 17883419546
MSFT | Capital International Investors | 99996798 | 2019-12-30 00:00:00 | 0.0131 | 15769495044
MSFT | Northern Trust Corporation | 93192050 | 2019-12-30 00:00:00 | 0.0123 | 14696386285
MSFT | Capital Research Global Investors | 92776236 | 2019-12-30 00:00:00 | 0.0122 | 14630812417
Spreadsheet: 215320d1361342768-how-to-highlight-cells-present-in-all-columns-highlighting-value-present-in-all-6-cols
Sheet: Sheet1

8 | 9 | 9 | 94 | 5 | 9
99 | 4 | 94 | 99 | 92 | 90
7 | 9 | 3 | 8 | 2 | 3
9 | 6 | 95 | 94 | 90 | 8
93 | 94 | 2 | 8 | 9 | 2
95 | 92 | 90 | 9 | 93 | 95
92 | 3 | 99 | 93 | 95 | 95
95 | 2 | 93 | 7 | 9 | 94
4 | 95 | 5 | 3 | 94 | 4
95 | 5 | 5 | 9 | 93 | 94
9 | 6 | 99 | 92 | 8 | 3
8 | 95 | 8 | 6 | 9 | 90
94 | 5 | 3 | 95 | 90 | 90
94 | 2 | 6 | 92 | 94 | 3
90 | 8 | 93 | 9 | 99 | 94
4 | 94 | 92 | 2 | 99 | 90
2 | 4 | 92 | 4 | 2 | 7
5 | 7 | 92 | 6 | 94 | 92
6 | 3 | 5 | 5 | 93 | 95
8 | 6 | 90 | 92 | 4 | 9
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 6

 | Dec 14 |  | Dec 21 |  | Dec 28 |  | Jan 4
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500
SD/MSPs** | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap event volumes by asset class and participant type (in number of events), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: eric_saibi__9817__092501
Sheet: Vogtle 02

Owner Name |  | Georgia Power Company
Station Name |  | Vogtle Nuclear Power Station
Unit Name |  | Vogtle 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Nuclear
Capacity |  | 1,160 MW
Start Date |  | 2001-09-25 00:00:00
End Date |  | 2001-09-27 00:00:00
Comments |  | Reduced power to 92%. Planning to repair problem without going into maintenance outage.
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007770
Outage ID |  | N/A
Spreadsheet: 135643d1326148021-if-function-book1-1-
Sheet: Sheet1

 | Phase | S | H | M | L
BUILDING 1 | P1 | 50 | 20 | 15 | 10
BUILDING 10 | P2 | 57 | 23 | 17 | 11
 | p1 | s
Spreadsheet: 138782d1327901707-excel-2007-get-all-matched-values-and-copying-into-one-cell-mapping
Sheet: Report

A | X | Y | Position
A1 | 2 | 1
A2 | 1 | 1
A3 | 2 | 1
A4 | 2 | 1
Spreadsheet: 701271d1603677484-sum-with-index-and-match-with-multiple-worksheets-output-is-on-worksheet-3-test321321
Sheet: Data

Tests | Data 1 | Data 2 | Data 3 | Data 4
Silk
[NAME]
Velvet
Cotton
Chiffon
Wool
Spreadsheet: 685647d1594125028-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: ML_Jan

 |  | 1 | orange
 |  | 2 | yellow
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
Spreadsheet: 174062d1344904748-dynaimc-sum-range-sample
Sheet: AP

2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | Can not remove | Can not remove | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 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-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
5 | 10 | 20 |  |  | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140
 |  |  |  |  |  | 240
Spreadsheet: 90318d1290067812-required-unique-record-book1
Sheet: Sheet1

Name | Total Amt. | DIFF. AMT
LUKAS STEEL | 30450 | 1700
LUKAS STEEL | 71050 | 700
LUKAS STEEL | 50750 | 500
LUKAS STEEL | 20300 | 200
LUKAS STEEL | 31950 | 300
S K K  INFRASTRRUCUTRE | 40600 | 400
FORGE INFOSYS | 40600 | 900
FORGE INFOSYS | 20300 | 200
FORGE INFOSYS | 30450 | 300
[NAME] PAPERS | 81200 | 1200
[NAME] PAPERS | 20300 | 200
[NAME] PAPERS | 42600 | 400
[NAME] PAPERS | 39400 | 400
[NAME] PAPERS | 20300 | 200
K K INFOSYS | 30450 | 700
K K INFOSYS | 40600 | 400
K K INFOSYS | 10650 | 1860
K K INFOSYS | 144840 | 1360
K K INFOSYS | 42600 | 400
HIMALYA STEEL CEMENT | 30450 | 900
HIMALYA STEEL CEMENT | 40600 | 400
HIMALYA STEEL CEMENT | 20300 | 200
HIMALYA STEEL CEMENT | 30750 | 300
ICCHAMANI SUPPLIER | 30450 | 1300
ICCHAMANI SUPPLIER | 40600 | 400
ICCHAMANI SUPPLIER | 50750 | 500
ICCHAMANI SUPPLIER | 10150 | 100
FRNACIS CEMENT CO | 30450 | 3130
FRNACIS CEMENT CO | 40600 | 400
FRNACIS CEMENT CO | 30450 | 300
FRNACIS CEMENT CO | 55825 | 550
FRNACIS CEMENT CO | 55825 | 550
FRNACIS CEMENT CO | 104545 | 1030
KAILASH TRADERS | 40600 | 400
Spreadsheet: 175282d1345477033-latest-entry-based-upon-date-book2
Sheet: Master

TagRef | Date | Code | Note
110242/M01 | Most recent date from code tab | Most recent code from code tab by most recent date | Most recent note from code tab by most recent date
122013/M01
200456/M01
116927/M01
124234/M01
110834/M01
109705/M02
200912/M01
201472/M01
111879/M01
110819/M01
202334/M01
126923/M01
110604/M01
126334/M01
126340/M01
125839/M01
103919/M01
114775/M01
114196/M01
126213/M01
106219/M01
103067/M01
116101/M01
104649/M01
102618/M01
109019/M02
117071/M01
105565/M01
110387/M01
Spreadsheet: 166777d1341796616-lookup-function-for-table-2-entries-drop-down-menu-and-roundup-pricing-2-
Sheet: Sheet1

 |  |  |  |  | Need Code Here
 |  |  | Product Drop Down |  | Price | [NAME] | Height
 |  |  | Product1 |  |  | 32.25 | 71.75
 |  |  | Product1 |  |  | 35 | 30
 |  |  | Product1 |  |  | 85 | 60
 |  |  | Product1 |  |  | 48 | 30
Spreadsheet: 555148d1515457125-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-2-
Sheet: Tournament 3

 |  |  | Tournament 3
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  | x | x | x
Spreadsheet: 046be13a-8df4-42a0-aeb0-5c80bd561b47
Sheet: Sheet1

SAN ANTONIO INDEPENDENT SCHOOL DISTRICT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
OFFICE OF DIRECTOR OF ATHLETICS
SENIOR SCHOOL BASEBALL INVENTORY
 | READY TO USE | TO BE REPAIRED | UNUSABLE | TOTAL ITEMS
1.  BAG
A.  BAT
B.  BALL
2.  BASEBALLS
A.  GAME (NEW)
B.  PRACTICE (NEW)
C.  USED
3.  BASES
A.  HOME PLATE
B.  PITCHER'S RUBBER
C.  SET OF THREE
4.  BATS
5.  BELTS
6.  BASEBALL CAPS
A.  GAME
B.  PRACTICE
C.  BATTING
7.  HOSE
A.  SANITARY (PR)
B.  STRETCH (PR)
8.  MASK, CATCHER'S
9.  MITT
A.  CATCHER'S
B.  FIRST BASEMAN'S
10.  PROTECTORS
A.  CHEST
B.  SHIN GUARD (PR)
11.  [NAME]
A.  "T"
B.  UNDERSHIRT
12.  SOCKS, SWEAT (PR)
13.  SUPPORTERS
A.  REGULAR
B.  WITH CUP
14.  PRACTICE UNIFORM
A.  PANTS
B.  SHIRTS
15.  GAME UNIFORM
A.  PANTS
B.  SHIRTS
16.  PITCHERS WINDBREAKER
DO NOT DISCARD OR DESTROY ANYTHING; UNUSABLES  WILL BE CHECKED BY THE
ATHLETIC DIRECTOR OR ASSISTANT ATHLETIC DIRECTOR.
DATE: __________________________________
COACH: ________________________________
SCHOOL: _______________________________
COORDINATOR: _________________________
PRINCIPAL: _____________________________
P:/FORMS/SENIOR SCHOOL BASEBALL INVENTORY
Spreadsheet: 802052d1666618000-vlookup-seek-two-values-return-a-third-zone-open-order-report-with-priorities-test
Sheet: Available

ITEM_NUMBER |  | Warehouse | ONHAND | ALLOCATED | Available
3826C002 |  | C01 | 2 |  | 2
4032C001 |  | C06 | 3 | 3 | 0
5358C001 |  | C01 | 6 |  | 6
2368V120 |  | C41 | 61 | 34 | 27
3763C003 |  | C06 | 16 | 8 | 8
3767C003 |  | C01 | 2 | 1 | 1
3768C003 |  | C01 | 2 |  | 2
3769C003 |  | C01 | 2 |  | 2
3631C001 |  | C45 | 94 |  | 94
3526C001 |  | C06 | 1 |  | 1
3631C001 |  | C01 | 19 | 1 | 18
3526C001 |  | C01 | 48 | 48 | 0
5160C002 |  | C41 | 1 | 1 | 0
3242C001 |  | C45 | 3 | 2 | 1
5226C001 |  | C45 | 2 | 2 | 0
8929B001 |  | C01 | 2 | 2 | 0
5261C001 |  | C06 | 1 |  | 1
1135C002 |  | C01 | 1 | 1 | 0
3057V762 |  |  | 1 |  | 1
Spreadsheet: 758729d1639043246-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Calculations

PROJECTS
Month | Client Projects |  | SRM Lead | Month | Days Spent | Hours spent | Client Calls | SRM Lead | Month | Days Spent | Hours spent
January |  |  | [NAME] | January |  |  |  | [NAME] | January
February |  |  | [NAME] | February |  |  |  | [NAME] | February
March |  |  | [NAME] | March |  |  |  | [NAME] | March
April |  |  | [NAME] | April |  |  |  | [NAME] | April
May |  |  |  | May |  |  |  |  | May
June |  |  |  | June |  |  |  |  | June
July |  |  |  | July |  |  |  |  | July
August |  |  |  | August |  |  |  |  | August
September |  |  |  | September |  |  |  |  | September
October |  |  |  | October |  |  |  |  | October
November |  |  |  | November |  |  |  |  | November
December |  |  |  | December |  |  |  |  | December
PAT TICKETS
Month | Tickets
January | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
February | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
March | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
April | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
May | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
June | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
July | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
August | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
September | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
October
November
December
Client Information
Name
Hire Date
Location
Termination Date
Employment Type
Year
Base Salary
Bonus
Overtime
Commission
Total Compensation
Department
PTO Days
Sick Days
Performance Score
Spreadsheet: 046dd9ee-380b-4706-9580-5e5ea23535c1
Sheet: Sheet1

PEG/Ion Screen (HR2-126) - Scoring Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sample: |  | 1 [NAME] |  | 6 Needles 1D
Buffer: |  | 2 Phase Separation |  | 7 Plates 2D
Reservoir Volume: |  | 3 Regular Granular Precipitate |  | 8 Xtal <0.2 mm
[NAME]: |  | 4 Birefringent Precipitate |  | 9 Xtal >0.2 mm
Temperature: |  | 5 Spherulites
[NAME]:
Temperature: |  | Date | Date | Date
1.   0.2 M Sodium Fluoride, 20% PEG 3350
2.   0.2 M Potassium Fluoride, 20% PEG 3350
3.   0.2 M Ammonium Fluoride, 20% PEG 3350
4.   0.2 M Lithium Chloride, 20% PEG 3350
5.   0.2 M Magnesium Chloride, 20% PEG 3350
6.   0.2 M Sodium Chloride, 20% PEG 3350
7.   0.2 M Calcium Chloride, 20% PEG 3350
8.   0.2 M Potassium Chloride, 20% PEG 3350
9.   0.2 M Ammonium Chloride, 20% PEG 3350
10. 0.2 M Sodium Iodide, 20% PEG 3350
11. 0.2 M Potassium Iodide, 20% PEG 3350
12. 0.2 M Ammonium Iodide, 20% PEG 3350
13. 0.2 M Sodium Thiocyanate, 20% PEG 3350
14. 0.2 M Potassium Thiocyanate, 20% PEG 3350
15. 0.2 M Lithium Nitrate, 20% PEG 3350
16. 0.2 M Magnesium Nitrate, 20% PEG 3350
17. 0.2 M Sodium Nitrate, 20% PEG 3350
18. 0.2 M Potassium Nitrate, 20% PEG 3350
19. 0.2 M Ammonium Nitrate, 20% PEG 3350
20. 0.2 M Magnesium Formate, 20% PEG 3350
21. 0.2 M Sodium Formate, 20% PEG 3350
22. 0.2 M Potassium Formate, 20% PEG 3350
23. 0.2 M Ammonium Formate, 20% PEG 3350
24. 0.2 M Lithium Acetate, 20% PEG 3350
25. 0.2 M Magnesium Acetate, 20% PEG 3350
26. 0.2 M Zinc Acetate, 20% PEG 3350
27. 0.2 M Sodium Acetate, 20% PEG 3350
28. 0.2 M Calcium Acetate, 20% PEG 3350
29. 0.2 M Potassium Acetate, 20% PEG 3350
30. 0.2 M Ammonium Acetate, 20% PEG 3350
31. 0.2 M Lithium Sulfate, 20% PEG 3350
32. 0.2 M Magnesium Sulfate, 20% PEG 3350
33. 0.2 M Sodium Sulfate, 20% PEG 3350
34. 0.2 M Potassium Sulfate, 20% PEG 3350
35. 0.2 M Ammonium Sulfate, 20% PEG 3350
36. 0.2 M di-Sodium Tartrate, 20% PEG 3350
37. 0.2 M Potassium Sodium Tartrate, 20% PEG 3350
38. 0.2 M di-Ammonium Tartrate, 20% PEG 3350
39. 0.2 M Sodium dihydrogen Phosphate, 20% PEG 3350
40. 0.2 M di-Sodium hydrogen Phosphate, 20% PEG 3350
41. 0.2 M Potassium dihydrogen Phosphate, 20% PEG 3350
42. 0.2 M di-Potassium hydrogen Phosphate, 20% PEG 3350
43. 0.2 M Ammonium dihydrogen Phosphate, 20% PEG 3350
44. 0.2 M di-Ammonium hydrogen Phosphate, 20% PEG 3350
45. 0.2 M tri-Lithium Citrate, 20% PEG 3350
46. 0.2 M tri-Sodium Citrate, 20% PEG 3350
47. 0.2 M tri-Potassium Citrate, 20% PEG 3350
48. 0.2 M di-Ammonium hydrogen Citrate, 20% PEG 3350
Spreadsheet: 471607d1469112374-how-to-calculate-the-elapsed-working-days-between-two-dates-based-on-more-criterias-sample
Sheet: Sheet1

Material | Text1 | Batch | Text2 | Text3 | Start date | Text4 | End date | Text5 | Iteration | Status | Text6 | Elapsed working days -Expected result-
8004486 |  | 1 |  |  | 2016-01-04 00:00:00 |  | 2016-01-07 00:00:00 |  | 1 | OK |  |  |  | Problem: | How to calculate the elapsed working days between the Start and End date based on Material and [NAME] and highest Iteration and Status OK?
8004486 |  | 2 |  |  | 2016-01-04 00:00:00 |  | 2016-01-07 00:00:00 |  | 1 | OK
8001022 |  | 14 |  |  | 2016-01-04 00:00:00 |  | 2016-01-07 00:00:00 |  | 1 | OK
8001022 |  | 3 |  |  | 2016-01-04 00:00:00 |  | 2016-01-07 00:00:00 |  | 1
8001022 |  | 3 |  |  | 2016-01-09 00:00:00 |  | 2016-01-12 00:00:00 |  | 2
8001022 |  | 3 |  |  | 2016-01-19 00:00:00 |  | 2016-01-22 00:00:00 |  | 3 | OK
883145 |  | 10 |  |  | 2016-01-06 00:00:00 |  | 2016-01-11 00:00:00 |  | 1
883145 |  | 10 |  |  | 2016-03-19 00:00:00 |  | 2016-03-23 00:00:00 |  | 2 | OK
883145 |  | 14 |  |  | 2016-01-06 00:00:00 |  | 2016-01-11 00:00:00 |  | 1
883145 |  | 14 |  |  | 2016-03-19 00:00:00 |  | 2016-03-23 00:00:00 |  | 2 | OK
8004477 |  | 7 |  |  | 2016-01-04 00:00:00 |  | 2016-01-08 00:00:00 |  | 1 | OK
8003649 |  | 6 |  |  | 2016-01-10 00:00:00 |  | 2016-01-13 00:00:00 |  | 1
8003649 |  | 6 |  |  | 2016-01-19 00:00:00 |  | 2016-01-25 00:00:00 |  | 2
8003649 |  | 6 |  |  | 2016-02-02 00:00:00 |  | 2016-02-05 00:00:00 |  | 3 | OK
8003649 |  | 7 |  |  | 2016-01-10 00:00:00 |  | 2016-01-13 00:00:00 |  | 1
8003649 |  | 7 |  |  | 2016-01-19 00:00:00 |  | 2016-01-25 00:00:00 |  | 2 | OK
8003649 |  | 7 |  |  | 2016-01-10 00:00:00 |  | 2016-01-13 00:00:00 |  | 1
8003649 |  | 7 |  |  | 2016-01-19 00:00:00 |  | 2016-01-25 00:00:00 |  | 2
8003649 |  | 7 |  |  | 2016-02-02 00:00:00 |  | 2016-02-04 00:00:00 |  | 3
8003649 |  | 7 |  |  | 2016-02-17 00:00:00 |  | 2016-02-23 00:00:00 |  | 4 | OK
8003649 |  | 14 |  |  | 2016-01-10 00:00:00 |  | 2016-01-13 00:00:00 |  | 1 | OK
8004477 |  | 7 |  |  | 2016-01-04 00:00:00 |  | 2016-01-08 00:00:00 |  | 1 | OK
8003649 |  | 7 |  |  | 2016-01-10 00:00:00 |  | 2016-01-13 00:00:00 |  | 1
8003649 |  | 7 |  |  | 2016-01-19 00:00:00 |  | 2016-01-25 00:00:00 |  | 2
8003649 |  | 7 |  |  | 2016-02-02 00:00:00 |  | 2016-02-05 00:00:00 |  | 3 | OK