tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sara_shackleton__36457__CasellaWasteSystems
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER:
COUNTERPARTY: | Casella Waste Systems, Inc. | CONTACT: | [NAME]
ADDRESS: | 25 Greens [NAME] | TITLE: | Sr. VP and COO
 | Rutland, VT 05701 | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
 | 3 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB-
Financial Covenants | X
-Total Debt to Worth | 1.5 to 1 |  | NOTE:  Total debt, not funded debt
-Minimum Net Worth | 35000000
-EBITDA/Interest Expense | 3X
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 10
-Guarantor ($[NAME]) |  | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
This c/p has total assets of $757 million and net worth of $269 million.
Please prepare draft and forward to c/p per [NAME] email to [NAME].
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X5-8356
Spreadsheet: sally_beck__35481__HC Revision 11-19-01
Sheet: HC Revision

NetWorks Headcount
EGM Revision | Current | Reductions |  |  | Revised H/C
IT | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
Management | 1 | 0 | 0 |  | 0 | 1
Weather | 38 | -4 | -18 |  | 0 | 16
FX/IR | 15 | 0 | -9 |  | 0 | 6
Equities | 18 | -2 | -12 |  | 0 | 4
Coal (Houston & London) | 63 | -15 | -14 |  | 1 | 33
Freight | 52 | -26 | -13 |  | 3 | 10
Liquids Accounting | 17 | -5 | -6 |  | 0 | 6
Totals
 | Current | Reductions |  |  | Revised H/C
Operations | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
Houston | 136 | -6 | -31 |  | 0 | 97
London | 51 | -5 | -26 |  | 0 | 20
Singapore | 5 | 0 | -5 |  | 0 | 0
Totals
NetWorks EGM Total
EIM Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
IT | 60 | -24 | -5 |  | 1 | 30
Operations | 84 | -9 | -10 |  | 3 | 54
NetWorks EIM Total
EA Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
IT | 510 | -139 | -71 |  |  |  | 210
Operations | 308 |  |  |  |  |  | 315
NetWorks EA Total
EES Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
IT | 210 | 0 | 0 | 0 | 66 | 144
Operations | 163 |  |  |  | 63 | 100
NetWorks EES Total
EGS Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
ETS IT | 259 | 0 | 0 | 0 | 70 | 189
EGS IT | Later
NetWorks EGS Total
EBS Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
IT | 16 | 0 | 0 | 0 | 0 | 16 | 16
Operations | 18 |  |  |  |  |  | 16 | ??
NetWorks EBS Total
EEL Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
IT | 331 |  | -100 |  |  | 231
Tokyo | 6 |  |  |  |  |  | 6
Singapore | 2 |  |  |  |  |  | 2
Sydney | 4 |  |  |  |  |  | 4
India | 6 |  |  |  |  |  | 6
Mumbai | 4 |  |  |  |  |  | 4
China | 1 |  |  |  |  |  | 1
Operations
NetWorks EEL Total
CORP Revision | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
ISC | 179 |  | -19 |  | 15 | 145
Enterprise Portal | 8 | 0 | -8 |  | 0 | 0
NetWorks CORP Total
Other ENW | Current | Reductions |  |  | Revised H/C
 | H/C | Contractors | FTE's | Total | Contractors | FTE's | Total
EOL Development | 80 |  |  |  | 0 | 80
EOL Commercial/Ops | 61 |  |  |  |  |  | 61
Commodity Logic Development | 49 |  |  |  | 8 | 41
Commodity Logic Commercial | 19 |  |  |  |  |  | 19
En Ops/Global Srvs Settlements | 183 |  |  | 0 |  |  | 183
Infrastructure | 554 | -56 | -13 |  | 90 | 395
Other ENW Total
NetWorks Grand Total
EGM Commercial Reduction |  |  |  | -233
EIM Commercial Reduction |  |  |  | -150
EA Commercial Reduction |  |  |  | -100
EES Commercial Reduction |  |  |  | -120
EGS Commercial Reduction |  |  |  | -250
EBS Commercial Reduction |  |  |  | -240
Corp Reduction |  |  |  | -400
Total for Jenny
EEL Commercial Reduction
Spreadsheet: 146010d1331852277-excel-2007-using-sumif-with-variable-multipliers-sumif-sample
Sheet: Sheet5

giver | taker | value |  | Player | tax% | Prior tax | prior revenue |  | Net +/-
A | C | 100 |  | A | 0.5 | 50 | 100 |  | -50
B | C | 60 |  | B | 0.75 | 75 | 100 |  | -101.25
B | D | 75 |  | C | 0.33 | 33 | 100 |  | 95
 |  |  |  | D | 0.2 | 20 | 100 |  | 56.25
Spreadsheet: 164179d1340676691-count-function-etc
Sheet: Sheet1

 | Stay Count
Membership No. | 2010 | 2011 | 2012 |  | Desired Outcome: Due to large amount of data, is there a Function to Count the no. Stay and put the amount in the table below. Just like in 2010 column, which I manually count.
1234 | 1 | 1 | 25
1235 | 4 | 4 | 6 |  |  | Count of Stay | 2010 | 2011 | 2012
1236 | 9 | 9 | 38 |  |  | 1 | 2
1237 | 1 | 1 | 7 |  |  | 2 | 3
1238 | 8 | 8 | 42 |  |  | 3 | 1
1239 | 2 | 2 | 8 |  |  | 4 | 1
1240 | 11 | 11 | 46 |  |  | 5 | 1
1241 | 3 | 3 | 9 |  |  | 6 | 1
1242 | 42 | 42 | 10 |  |  | 7 | 1
1243 | 32 | 32 | 21 |  |  | 8 | 2
1244 | 29 | 29 | 19 |  |  | 9 | 2
1245 | 2 | 2 | 2 |  |  | 10 | 1
1246 | 25 | 25 | 16 |  |  | 11 | 1
1247 | 6 | 24 | 15 |  |  | 12
1248 | 38 | 23 | 13 |  |  | 13 | 1
1249 | 7 | 22 | 15 |  |  | 14
1250 | 42 | 36 | 27 |  |  | 15 | 2
1251 | 8 | 38 | 25 |  |  | 16 | 1
1252 | 46 | 39 | 24 |  |  | 17
1253 | 9 | 31 | 23 |  |  | 18
1254 | 10 | 32 | 22 |  |  | 19 | 1
1255 | 21 | 5 | 36 |  |  | 20
1256 | 19 | 1 | 38 |  |  | 21 | 1
1257 | 2 | 4 | 39 |  |  | 22 | 1
1258 | 16 | 9 | 31 |  |  | 23 | 1
1259 | 15 | 1 | 32 |  |  | 24 | 1
1260 | 13 | 8 | 5 |  |  | 25 | 2
1261 | 15 | 2 | 1 |  |  | 26
1262 | 27 | 11 | 4 |  |  | 27 | 1
1263 | 25 | 3 | 9 |  |  | 28
1264 | 24 | 42 | 1 |  |  | 29 | 1
1265 | 23 | 32 | 8 |  |  | 30
1266 | 22 | 29 | 2 |  |  | 31 | 1
1267 | 36 | 2 | 11 |  |  | 32 | 2
1268 | 38 | 1 | 3 |  |  | 33
1269 | 39 | 4 | 42 |  |  | 34
1270 | 31 | 9 | 32 |  |  | 35
1271 | 32 | 1 | 29 |  |  | 36 | 1
1272 | 5 | 8 | 2 |  |  | 37
 |  |  |  |  |  | 38 | 2
 |  |  |  |  |  | 39 | 1
 |  |  |  |  |  | 40
 |  |  |  |  |  | 41
 |  |  |  |  |  | 42 | 2
 |  |  |  |  |  | 43
 |  |  |  |  |  | 44
 |  |  |  |  |  | 45
 |  |  |  |  |  | 46 | 1
Spreadsheet: 769841d1645707277-index-and-march-array-formula-with-approximate-match-index_match_approximate
Sheet: Sheet1

 |  | Car | Model | Year | Price |  |  | Model | B-2
 |  | A | A-1 | 1996 | 1000 |  |  | Budget | 1500
 |  | B | B-2 | 2000 | 1500
 |  | C | C-1 | 2011 | 1700
 |  | D | D-5 | 2009 | 1900 |  |  | Choice
 |  |  |  |  |  |  |  | Car
 |  |  |  |  |  |  |  | How can get approximate match
 |  |  |  |  |  |  |  | If Budget is 1800, I expect choice is "C"
 |  |  |  |  |  |  |  | How can I use Index and March , 1) to handle it
Spreadsheet: 7ac6c262-0f3f-42a9-bdb4-e84535ac865c
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
PNZN | Test | PNZN | Perphenazine, (Trilafon), Serum | Perphenazine (Trilafon) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). [NAME] is not acceptable. Spin down and send 3 mL sodium heparin plasma refrigerated in amber vial (Supply T192) to protect from light.   Serum Draw blood in a plain, red-top tube(s). Serum gel tube is not acceptable. Spin down and send 3 mL of serum refrigerated in amber vial (Supply T192) to protect from light. | 0.3 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	NA | Reference Range: 5.0 - 30.0 ng/mL   Low-dose therapeutic range for Perphenazine: 0.5 - 2.5 ng/mL   Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Friday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
PNZN | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
PNZN | Result | Z1052 | Perphenazine | Perphenazine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: louise_kitchen__23037__AAearn by month
Sheet: Apr

E N R O N   N O R T H  A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1Q 2001
April 2001
in Millions of $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | 2001-04-02 00:00:00 | 2001-04-03 00:00:00 | 2001-04-04 00:00:00 | 2001-04-05 00:00:00 | 2001-04-06 00:00:00 | 2001-04-09 00:00:00 | 2001-04-10 00:00:00 | 2001-04-11 00:00:00 | 2001-04-12 00:00:00 | 2001-04-16 00:00:00 | 2001-04-17 00:00:00 | 2001-04-18 00:00:00 | 2001-04-19 00:00:00 | 2001-04-20 00:00:00 | 2001-04-23 00:00:00 | 2001-04-24 00:00:00 | 2001-04-25 00:00:00 | 2001-04-26 00:00:00 | 2001-04-27 00:00:00 | 2001-04-30 00:00:00 | Total
Margin
Gas Trading | 66.4 | 57.3 | 75.3 | -44 | -38.3 | -213.5 | 99.4 | -62.2 | -60.8 | -9.7 | 6 | 0 | 57.9 | -51.3 | 24.7 | -15.7 | -155.2 | 63 | 77.2 | -14.6
Power Trading | 8.8 | 9.3 | -4.6 | -5.5 | -3.9 | 8.9 | 1.8 | 17.5 | 6.5 | -5.7 | 2 | 20.3 | -4.5 | -13.8 | 21.2 | 37.8 | 7.4 | 1.5 | 10.6 | 27.4
Other Trading | 0.4 | 1.5 | 0.6 | 0.5 | 0.5 | 1.6 | 0.4 | 0.4 | 0.4 | 2 | 0.4 | 0.5 | 2.2 | 0.5 | 2.1 | 0.4 | 0.5 | 0.4 | 0.7 | 1
Peakers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Originations/Office of the Chair/Other | 1.1 | 0 | 0.7 | 0 | 0.1 | 0.1 | 0.2 | 0 |  | 0.6 | 0.8 | -0.7 | 0.1 |  | 0 | 0 | 0 | 0.1 | -1.6
MPR | 0.2 | -3.9 | 2.7 | 5.3 | -2.1 |  | 3.2 | -0.6 | 3.8 | 1.4 | -1.3 | -1 | -1.7 | -0.9 | 0 | 0.3 | 1.3 | 1 | 1.5 | 0
Total Margin
Schedule C
Gas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Power | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -26.2 | 0 | 0 | 0.9 | 0 | 35.7 | 0 | 0 | 0 | 0 | 0
Schedule C
Total Daily Margin
Spreadsheet: 24d9b7c3-71a1-400a-8775-7215d8a8c1d5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 7. LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Lease Finance - Total commitments ; |  |  | Original | A2413496R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Lease Finance - Commitments not drawn at end of month ; |  |  | Original | A2413497T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Revolving Credit - New and increased credit limits ; |  |  | Original | A2413498V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Revolving Credit - Cancellations and reductions ; |  |  | Original | A2413499W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Revolving Credit - Total credit limits at end of month ; |  |  | Original | A2413500V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Revolving Credit - Credit used at end of month ; |  |  | Original | A2413501W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 729081d1618907113-match-returning-na-match
Sheet: Index

EMP ID | MATCH
1011
1023
1099
1034
1088
1054
1091
1027
1078
Spreadsheet: 465865d1465920395-write-in-a-cell-if-a-other-cell-is-x-test-dernier-ccm
Sheet: Feuil1

Candidate | [NAME] (declarative name) | Financer (Taxation Center name) | [NAME] (original financer) | Formula with #NUL | Concatenation of D and E
Name1 | PHONE MAKER | PHONE MAKER | #NUL
Name1 | PHONE MAKER | PHONE MAKER | #NUL
Name1 | PHONE MAKER | PHONE MAKER | #NUL
[NAME] | PHONE MAKER SA | PHONE MAKER | #NUL | PHONE MAKER | PHONE MAKER | > RESULT I NEED
Name3 | ABC | ABC | ABC |  | ABC
Name4 | party | financing comitee | Stones
Name5 | party | financing comitee | ABC
Name6 | party | financing comitee | Petroleum
Name6 | REGIONAL DIRECTION | REGIONAL DIRECTION | Techno comp
Name6 | PARTY S DIRECTION | Comité financier | Techno comp
Name6 | PARTY S DIRECTION | REGIONAL DIRECTION | Techno comp
Name6 | PARTY S DIRECTION | Fondation politique | Techno comp
Name7 | Techno comp | UTC Engenharia | #NUL
Name7 | Techno comp | UTC Engenharia | #NUL
Name8
Spreadsheet: benjamin_rogers__1155__TVA Wkly Anal - 011100
Sheet: NA Mquip

New Albany
Major Equipment Detail
Refurbishment with DLN Units 1-6
(includes commission) |  |  |  | 26785396
 | Spare Parts
Dow Unit
 | Purchase & spares |  |  | 1347000
 | Dissassembly |  |  | 500000
 | Commission 10%
4 Kepco Units (original)
 | Purchase |  |  | 27502700
 | Commission IBC(10%)
 | Commission Natole |  |  | 900000
 | Less Steam Turbine |  |  | -700000 |  | Allocate to 2000
 | Disassemble & move to [NAME] |  |  | 1307660
 | Less Steam Turbine |  |  | -200500 |  | Allocate to 2000
 | Freight Reimbursement to IBC
 | Less Steam Turbine |  |  | -100000 |  | Allocate to 2000
 | Commission (7%)
1 Kepco Unit (new set)
 | 1 of 4 Purchase price
 | Disassembly & shipping
 | Commission |  |  | 0
Unidentified |  |  |  | 0 |  | Spare parts to be reconciled per [NAME]
Total IBC items
Transformers etc |  |  |  | 10870000
Grand Total Major Equipment
Spreadsheet: 873034d1719477433-help-with-formulas-to-populate-from-one-sheet-with-dynamic-data-to-another-sheet-as-a-list-philip_188-auto-list-1-aligw
Sheet: Sheet1

 | Help Column fake | Help Column fake | Last Position | SAILED DATE | Current POSITION | OP | ETS | CARGO |  | NEXT Position1 | OP1 | ETA1 | NEXT Position 2 | OP2 | ETA2 | NEXT Position 3 | OP3 | ETA3 | NEXT Position 4 | OP4 | ETA4
 |  |  |  |  |  |  |  | TYPE | QTY
Sample-Bravo | yes | No | previous | 2024-06-25 00:00:00 | start | Discharge | 2024-06-28 00:00:00 | candy | 200 | a | Loading | 2024-06-19 00:00:00 | b | Discharge | 2024-07-10 00:00:00 | c | 2024-07-15 00:00:00 | Loading | d | 2024-07-30 00:00:00 | Discharge
Bravo | yes | No |  |  |  |  |  |  |  |  | Load | 2024-06-25 00:00:00 | b | Discharge | 2024-07-10 00:00:00 | c | Load | 2024-07-15 00:00:00 | d | Discharge | 2024-07-30 00:00:00
Spreadsheet: 68fd13c5-90d7-4c88-919b-a526c6a7bfca
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
APOE | Test | APOE | Apolipoprotein E Genotyping, Blood | Apolipoprotein E Genotyping, B | Polymerase Chain Reaction (PCR), Including Restriction Digest (PCR is utilized pursuant to a license agreement with Roche Diagnostic Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:		 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | The apolipoprotein E gene alleles will be reported. Expected values: e2e2, e2e3, e2e4, e3e3, e3e4, e4e4 An interpretive report will be provided. | Friday; 10 a.m. | 5 days | 10 days | 1 | 81401 |  |  |  |  | Rochester
APOE | [NAME] | VARIES | Varies |  |  |  | Ambient
APOE | Result | 16625 | [NAME] | [NAME] | Alphanumeric
APOE | Result | 16626 | [NAME] | [NAME] | Alphanumeric
APOE | Result | 16627 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
APOE | Result | 16628 | Order Date | Order Date | Alphanumeric
APOE | Result | 16629 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
APOE | Result | 16630 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
APOE | Result | 29650 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
APOE | Result | 29377 | Extraction Performed? | Extraction Performed? | Alphanumeric
APOE | Result | 16632 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
APOE | Result | 16633 | Reviewed By: | Reviewed By: | Alphanumeric
APOE | Result | 16634 | Release Date | Release Date | Alphanumeric
Spreadsheet: 753836d1635781963-help-concatenate-skip-blanks-add-line-break-mail-merge-test
Sheet: Sheet1

Preferred [NAME] | Sun, Nov 1 | Mon, Nov 22 | [NAME], Nov 23 | Concatenate Result
[EMAIL] | Meeting 1 |  | Meeting 3 | Meeting 1 Meeting 3
[EMAIL] |  | Meeting 2 |  | Meeting 2
[EMAIL] |  |  | Meeting 3 | Meeting 3
[EMAIL] | Meeting 1 | Meeting 2 |  | Meeting 1 Meeting 2
[EMAIL] | Meeting 1 |  | Meeting 3 | Meeting 1 Meeting 3
[EMAIL] | Meeting 1 | Meeting 2 | Meeting 3 | Meeting 1 Meeting 2 Meeting 3
Spreadsheet: 708509d1607884941-work-delay-we-have-given-a-task-and-want-to-count-how-much-is-work-delay-or-work-on-time-test-work-delay
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
S.No. | Date | Day | Office Timing | Work Given to | Work Name | Work Deadline | Work Finish Time |  | Delay / Comp |  |  |  |  |  | 2020-12-25 00:00:00
 |  |  |  |  |  |  | Work Done | Date and Time (MM:DD:YY)
1 | 2020-12-03 00:00:00 | Thursday | 9:00 am to 6:00 pm | Rohit | Work 1 | 2020-12-04 16:00:00 | Rohit Work 1 Done | 2020-12-07 17:00:00 |  | Work Late by 19 Hour
2 | 2020-12-04 00:00:00 | Friday | 9:00 am to 6:00 pm | [NAME] | work 2 | 2020-12-07 11:00:00 | [NAME] Work 2 Done | 2020-12-07 10:30:00 |  | Work done before time
3 | 2020-12-05 00:00:00 | Saturday | 9:00 am to 6:00 pm | Rohit | Work 3 | 2020-12-05 14:00:00 | Rohit Work 3 Done | 2020-12-05 17:00:00 |  | Work Late by 3 Hour
4 | 2020-12-06 00:00:00 | Sunday | 9:00 am to 6:00 pm | Off
5 | 2020-12-07 00:00:00 | Monday | 9:00 am to 6:00 pm | [NAME] | Work4 | 2020-12-09 17:00:00 | [NAME] Work4 Done | 2020-12-10 17:00:00 |  | Work Late by 8 Hour
6 | 2020-12-08 00:00:00 | Tuesday | 9:00 am to 6:00 pm | Holiday
7 | 2020-12-09 00:00:00 | Wednesday | 9:00 am to 6:00 pm
7 | 2020-12-10 00:00:00 | Thursday | 9:00 am to 6:00 pm
 |  |  | 9:00 am to 6:00 pm | Working Hour is 9 Hour
 |  |  |  | Work 1 Deadline is, Date 04 and time 04:00 pm
 |  |  |  | Late on 04 Dec | 2 Hour
 |  |  |  | Late on 05 Dec | 9 Hour
 |  |  |  | Late on 07 Dec | 8 Hour
 |  |  |  | Total | 19 Hour | but it is showing 22 Hour
Spreadsheet: 795477d1662715211-how-to-lookup-with-wildcards-in-the-lookup_value-not-_array-example-of-wildcard-with-lookup-ans
Sheet: Sheet1

[NAME] | Assigned Modifications | formula | correct output | FORMULA
QHLPLIK[585.3087]M[15.9949]KPVPDLVPGN[0.9840]FK | 18N(0.9840), 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
Q[-17.0265]HLPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 1Q(-17.0265), 7K(585.3087), 8M(15.9949) | above wildcard vlookup - fail | hFIBA_Q240
Q[-17.0265]HLPLIKM[15.9949]KPVPDLVPGNFK | 1Q(-17.0265), 8M(15.9949)
Q[0.9840]H[15.9949]LPLIK[585.3087]MKPVPDLVPGNFK | 1Q(0.9840), 2H(15.9949), 7K(585.3087) |  | hFIBA_Q240
Q[0.9840]HLPLIK[585.3087]MKPVPDLVPGNFK | 1Q(0.9840), 7K(585.3087) | above wildcard [NAME] | hFIBA_Q240
QH[15.9949]LPLIK[1044.4731]M[15.9949]KPVPDLVPGNFK | 2H(15.9949), 7K(1044.4731), 8M(15.9949) |  | hFIBA_Q256
QH[15.9949]LPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 2H(15.9949), 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
QHLPLIK[585.3087]MK | 7K(585.3087) |  | hFIBA_Q240
QHLPLIK[585.3087]MKPVPDLVPGNFK | 7K(585.3087) |  | hFIBA_Q240
QHLPLIK[585.3087]M[15.9949]K | 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
QHLPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
[NAME] | 8M(15.9949)
QHLPLIKM[15.9949]K[585.3087]PVPDLVPGNFK | 8M(15.9949), 9K(585.3087) |  | hFIBA_Q240
MKPVPDLVPGN[0.9840]FK | 11N(0.9840)
MKPVPDLVPGN[0.9840]FKSQLQK | 11N(0.9840)
M[15.9949]KPVPDLVPGN[0.9840]FKSQ[0.9840]LQK | 11N(0.9840), 15Q(0.9840), 1M(15.9949)
[NAME] | 11N(0.9840), 1M(15.9949)
M[15.9949]KPVPDLVPGN[0.9840]FKSQLQK | 11N(0.9840), 1M(15.9949)
M[15.9949]KPVPDLVPGNFK[1044.4731]SQLQK | 13K(1044.4731), 1M(15.9949) |  | hFIBA_Q256
M[15.9949]KPVPDLVPGNFK[585.3087] | 13K(585.3087), 1M(15.9949) |  | hFIBA_Q240
M[15.9949]KPVPDLVPGNFK[585.3087]SQLQK | 13K(585.3087), 1M(15.9949) |  | hFIBA_Q240
M[15.9949]KPVPDLVPGNFKSQ[0.9840]LQK | 15Q(0.9840), 1M(15.9949)
lookup table
585.3087 | hFIBA_Q240 | Q221 |  |  |  |  |  | 585.3087
1044.473237 | hFIBA_Q256 | Q237 |  |  |  |  |  | 1044.473237
Spreadsheet: 148723d1333536677-vlookup-does-not-produce-searched-for-values-template-for-uploading-hours
Sheet: Rep

 | Cost Center | Name | Activity type
 | 4121 | TR FR Junior | A70
 | 4122 | TR FR Middle | A70
 | 4123 | TR FR Senior | A70
 | 4103 | Project Manager | A70
 | 4202 | Developers | DV1
 | 4301 | CM/DM Middle | A58