tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79059d1279289335-counting-multiples-with-criteria-counting-multiples
Sheet: Sheet1

Name | Product | Purchase Month | Purchase Date |  |  | Products | Special Product List
[NAME] | Corn | Jun | 2010-06-14 00:00:00 |  |  | Bacon | Corn
[NAME] | Cherries | Jun | 2010-06-14 00:00:00 |  |  | Lettuce | Cherries
[NAME] | Bacon | Jun | 2010-06-14 00:00:00 | 3 | 3 | Tomato | Bacon
[NAME] | Lettuce | Jun | 2010-06-15 00:00:00 |  |  | Potato
[NAME] | Tomato | Jun | 2010-06-15 00:00:00 | 2 |  | Corn
[NAME] | Potato | Jun | 2010-06-30 00:00:00 | 1 |  | Watermelon
Anders | Corn | Jun | 2010-06-01 00:00:00 | 1 |  | Cherries
Jan | Cherries | Jun | 2010-06-02 00:00:00 | 1
[NAME] | Corn | Jun | 2010-06-05 00:00:00
[NAME] | Bacon | Jun | 2010-06-05 00:00:00 | 2
[NAME] | Watermelon | Jun | 2010-06-05 00:00:00 | 1
[NAME] | Cherries | Jun | 2010-06-07 00:00:00
[NAME] | Corn | Jun | 2010-06-07 00:00:00
[NAME] | Bacon | Jun | 2010-06-07 00:00:00 | 3 | 3
[NAME] | Watermelon | Jun | 2010-06-12 00:00:00
[NAME] | Lettuce | Jun | 2010-06-12 00:00:00 | 2
Brent | Cherries | Jun | 2010-06-17 00:00:00 | 1
Kenyon | Corn | Jun | 2010-06-27 00:00:00 | 1
Jon | Bacon | Jun | 2010-06-25 00:00:00 | 1
Question 1: | What formula would calculate the number of customers that purchased multiple items? |  |  |  |  |  |  |  |  | 5
 | Answer should equal 5 ([NAME], [NAME], Megan, [NAME], [NAME]) (Doesn't matter if they purchased 2 or 3 or 5, as long as it is more than 1)
Question 2: | What formula would calculate the number of times a customer purchased the 3 special products (Corn, Cherries, Bacon) |  |  |  |  |  |  |  |  | 2
 | Answer should equal 2 ([NAME], [NAME])
Spreadsheet: 742381d1627697446-if-statement-with-multiple-text-values-excel-help-sample-if-statement-bvj-
Sheet: Sheet1

Priority Criteria | 4 | X | 3 | X | 2 | X | 1 | X
Mission Criticality Tier | > 4 |  | 4 |  | 3 |  | 1 & 2 | X
End of Life / Regulatory Date | 12 + Months |  | 7 - 12 months |  | < 6 Months |  | Past End of Life/Support/Regulatory Date | X
Project Duration | 1 month or less |  | 2 - 3 months |  | 4 - 5 months |  | 6 + Months | X
Estimated IT Labor | <100 |  | 100-1000 |  | 1000-2000 |  | >2000
Dependent Projects |  |  |  |  | 1 |  | 2+ | X |  |  |  | <100 | 80
TOTALS |  | 0 |  | 0 |  | 0 |  | 12 |  |  |  | 101-1000 | 100
Overall Project Score | 12 |  |  |  |  |  |  |  |  |  |  | 1001-2000 | 200
 |  |  |  |  |  |  |  |  |  |  |  | >2000 | 50
1 = 3 points
2 = 2 points
1 = 1 point
0 = no points
Dependent projects only 3 options
2+ = 3 points
1 = 2 points
0 = 0 points
EOL date = base off TODAY and calendar days
 | Mission Criticality |  | End of Life /Regulatory Date |  | Project Duration |  | Estimated IT Labor (hours) |  | Dependent Projects |  |  | duration lookup |  | Estimated IT Labor (hours)
 | >4 |  | 2021-09-12 00:00:00 |  | 1 Month |  | 100 or less |  |  |  |  | 1 Month | 90 | 100 or less | 0
 | 4 |  |  |  | 2-3 Months |  | 101-1000 |  | 0 |  |  | 2-3 Months | 100 | 101-1000 | 200
 | 3 |  |  |  | 4-5 Months |  | 1001-2000 |  | 1 |  |  | 4-5 Months | 200 | 1001-2000 | 400
 | 2 |  |  |  | 6 Months Plus |  | 2000+ |  | >=2 |  |  | 6 Months Plus | 250 | 2000+ | 500
 | 1
Spreadsheet: 175564d1345569631-combining-two-graphs-into-one-combining-two-graphs_ptpc_jpr73
Sheet: PT_PC

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Combining two graphs into one
[NAME] |  | Ligne
Page1 | Colonne | Aut | Buffer Stock | Campaign | Commodity | Finished goods | Interfault | Maintenance spares | Other raw materials | Other stores | Raw | Raw Materials, work-in-progress and stores | Semi-finished - goods in transit | Semi-finished product awaiting further processing | Trading Goods | Trading goods in transit | Work-in-progress - within production process
Data 1 | Current Period |  |  |  |  | 15 | 160 | 1 | 5 | 675 | 120 |  | 90 | 50 | 6500 | 400 | 6
 | Prior Period |  |  |  |  | 30 | 100 | 5 | 50 | 500 | 60 |  | 20 | 20 | 7000 | 650 | 18
Data 2 | Current Period | 3000 | 650 | 5000 | 20000 |  |  |  |  |  |  | 54455
 | Prior Period | 2500 | 500 | 2000 | 65000 |  |  |  |  |  |  | 55666
Spreadsheet: 863913d1711307388-sumproduct-pricing-table-threshold-calculation-issue-pricing-threshold-table
Sheet: Bag price Luggage Logistics

threshold |  | price
min | [NAME]
1 | 10 | 4 |  | 1 | 10 | 4
 | 50 | 3 |  | 1 | 40 | 3
 | 200 | 2 |  | 1 | 5 | 2
 | 9999 | 1 |  | 0 | 0 | 1
 |  |  |  |  |  | Result
 | check | 55
 | result
Spreadsheet: 755620d1636996706-lookup-examples-from-arrays-lookup
Sheet: Sheet1

 |  | Example 1 |  |  |  |  |  | Example 2
 | Lookup |  | 4 | 8 |  |  | Lookup |  | 1 | 5
 |  | 1 | 5 | 9 |  |  |  |  | 2 | 6
 |  | 2 | 6 | 10 |  |  |  |  | 3 | 7
 |  | 3 | 7 | 11 |  |  |  |  | 4 | 8
 | Values |  | 2 | 9 |  |  | Values |  | 6 | 2
 |  | 6 | 3 | 5 |  |  |  |  | 8 | 5
 |  | 8 | 41 | 6 |  |  |  |  | 1 | 8
 |  | 7 | 3 | 1 |  |  |  |  | 20 | 3
 | Result | Lookup |  | Return |  |  | Result | Lookup |  | Return
 |  | 1 |  | 6 |  |  |  | 1 |  | 6
 |  | 2 |  | 8 |  |  |  | 2 |  | 8
 |  | 3 |  | 7 |  |  |  | 3 |  | 1
 |  | 4 |  | 2 |  |  |  | 4 |  | 20
 |  | 5 |  | 3 |  |  |  | 5 |  | 2
 |  | 6 |  | 41 |  |  |  | 6 |  | 5
 |  | 7 |  | 3 |  |  |  | 7 |  | 8
 |  | 8 |  | 9 |  |  |  | 8 |  | 3
 |  | 9 |  | 5
 |  | 10 |  | 6
 |  | 11 |  | 1
Spreadsheet: 837727d1690381008-sum-up-order-total-if-id-matches-and-if-shipping-date-matches-order-date-or-5-days-ci-invoices-stuff
Sheet: Operations team orders

Date of order | Learner first name | [NAME] surname | CII PIN |  | CII member/Non-member
2023-06-01 00:00:00 | test | test | 001770110H | test | member | 231.8 | 0 | 231.8
2023-06-01 00:00:00 | test | test | 001775028D | test | member | 411.3 | 0 | 411.3
2023-06-01 00:00:00 | test | test | 001819431L | test | member | 411.3 | 0 | 411.3
2023-06-12 00:00:00 | test | test | 001835987F | test | member | 251.7 | 8 | 259.7
Spreadsheet: 67102d1267719589-phone-fax-based-on-list-aec-quote-2010
Sheet: Search by Contractor

 | Date | Quote # | Project Name | By | Value | Status | Engineer | Bidders |  | Contractor
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
9999
Spreadsheet: 03a32774-3c72-4ec9-aa74-dea644e51875
Sheet: Sheet1

Child and Adult Care Food Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
REIMBURSEMENT CALCULATION FORM
Online in Excel format at web site: www.ode.state.oh.us/food_service/
Effective July 1, 2013 to June 30, 2014
Do not include Cash-in-Lieu payments for projected reimbursement on application budget.
Although the Cash-in-Lieu amount calculates, it is not added into the monthly or annual totals.
Please enter data in the cells with blue borders only.  Excel program will calculate the rest of the cells.
SPONSOR: |  |  |  |  |  |  |  |  | MONTH:
1 | Total Number of Enrolled Participants |  |  |  |  |  | (Number must equal total Free, Reduced, and Paid participants in row 2, 3, and 4.)
2 | Number of Free Participants |  |  |  |  |  |  |  |  | = |  |  |  | F%
3 | Number of Reduced Participants |  |  |  |  |  |  |  |  | = |  |  |  | R%
4 | Number of Paid Participants |  |  |  |  |  |  | / |  | = |  |  |  | P%
BREAKFAST
5 | No. of Meals |  | X |  | F% | = | No. Meals Free |  |  | X | 1.58 | =
6 | No. of Meals |  | X |  | R% | = | No. Meals Reduced |  |  | X | 1.28 | =
7 | No. of Meals |  | X |  | P% | = | No. Meals Paid |  |  | X | 0.28 | =
TOTAL BREAKFASTS SERVED                                      & REIMBURSEMENT |  |  |  |  |  |  | TOTAL MEALS |  | 0 | BREAKFAST TOTAL |  |  | 0
LUNCH
8 | No. of Meals |  | X |  | F% | = | No. Meals Free |  |  | X | 2.93 | =
9 | No. of Meals |  | X |  | R% | = | No. Meals Reduced |  |  | X | 2.53 | =
10 | No. of Meals |  | X |  | P% | = | No. Meals Paid |  |  | X | 0.28 | =
TOTAL LUNCHES SERVED                                            & REIMBURSEMENT |  |  |  |  |  |  | TOTAL MEALS |  | 0 | LUNCH TOTAL |  |  | 0
SUPPER
11 | No. of Meals |  | X |  | F% | = | No. Meals Free |  |  | X | 2.93 | =
12 | No. of Meals |  | X |  | R% | = | No. Meals Reduced |  |  | X | 2.53 | =
13 | No. of Meals |  | X |  | P% | = | No. Meals Paid |  |  | X | 0.28 | =
TOTAL SUPPERS SERVED                                                   & REIMBURSEMENT |  |  |  |  |  |  | TOTAL MEALS |  | 0 | SUPPER TOTAL |  |  | 0
CASH-IN-LIEU/COMMODITIES    (Lunch/Supper Only)
14 | No. of Meals |  | X | 0.2325 |  | = | ***COMMODITIES TOTAL***
SNACKS    (AM, PM, Evening Totaled)
15 | No. of Snack |  | X |  | F% | = | No. Meals Free |  |  | X | 0.8 | =
16 | No. of Snack |  | X |  | R% | = | No. Meals Reduced |  |  | X | 0.4 | =
17 | No. of Snack |  | X |  | P% | = | No. Meals Paid |  |  | X | 0.07 | =
TOTAL SNACKS SERVED                                            & REIMBURSEMENT |  |  |  |  |  |  | TOTAL MEALS |  | 0 | SUPPLEMENT TOTAL |  |  | 0
18 | TOTAL POTENTIAL REIMBURSEMENT FOR MONTH …………………………. |  |  |  |  |  |  |  |  | 0
19 | ESTIMATED TOTAL REIMBURSEMENT FOR FISCAL YEAR ………………… |  |  |  |  |  |  |  |  | 0
Spreadsheet: 0093cab5-ce90-46b0-9c22-312d9f4dcbf8
Sheet: Sheet1

SCG BWF World Junior Championships 2013                                      23 October - 3 November , Bangkok Thailand                                     Visa Application Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Category |  |  | Organization |  |  |  |  | E-mail
Contact |  |  | Position |  |  |  |  | Tel/Fax
Intended date of arrival and departure: |  |  | From |  |  | to |  | Where to pick up visa:
NO. | Mr/Ms | SURNAME | First Name(s) |  | Passport No. |  | [NAME] Date(DD/MM/YY) | Date of Birth(DD/MM/YY) | Nationality | Function
1
2
3
4
5
6
7
8
9
10
Note | ＊Complete the above form clearly in BLOCK CAPITALS together with a scanned passport copy of the applicant. ＊Please return to Mrs.[NAME] at e-mail: [EMAIL] no later than 15 September 2013.  ＊Customs Clearance of the carried MEDIA Equipments should be applied through the overseas Chinese embassy separately.
 |  |  |  |  |  |  | Signature:
 |  |  |  |  |  |  | Date:
PLA | :Player |  |  | DPR | :Deputy Referee |  |  | BWF | : BWF Official, Support Staff
CAP | :Team Captain |  |  | UMP | :BWF Appointed Umpire |  |  | ACC | :Other accompanying official
DOC | :Doctor/Physiotherapist |  |  | LJD | :BWF Appointed Line Judge |  |  | RHBs | :IMG and its licensee
COA | :Coach |  |  | E | :Journalist |  |  | ENR | :Non-rights holding broadcaster
REF | :Referee |  |  | EP | :Photographer
Spreadsheet: 80568d1280797476-how-to-display-and-use-a-hyperlink-into-a-separate-worksheet-sample1
Sheet: Estimation

Technical Service | Task | Qty | Form Link | Form link | Hours | Total Hours
 | Allocate Tier 1 SAN LUN | 3 |  | SAN Disk Request |  |  |  |  | text
 |  | 2 |  | SAN Disk Request
Spreadsheet: 104832d1302276455-vlookup-hlookup-or-vba-possible-problem-771654
Sheet: Dashboard

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | Farm | Date | Pivot # | Oil Qty | Temp | Oil PSI | RPM | GPM | Line PSI | [NAME] | Time Checked |  | Farm | Date Column | [NAME]
 | Day Crew | East Farm | 2011-04-06 00:00:00 | 74b | $[NAME] | $[NAME] | $[NAME] | $R$54 | $S$54 | $T$54 | $U$54 | $V$54 |  | 2 | 14 | 18
 | Night Crew | North Farm | 2011-04-06 00:00:00 | 95B | 0 | 190° | 45 | 0 | 517.4 | 58 | - | 0
 |  | North Farm
 |  | East Farm
 |  | West Farm
 |  | Chism Farm
 |  | 2011-04-06 00:00:00 | 1A
 |  | 2011-04-07 00:00:00 | 1B
 |  | 2011-04-08 00:00:00 | 1C
 |  | 2011-04-09 00:00:00 | 1D
 |  | 2011-04-10 00:00:00 | 1E
 |  | 2011-04-11 00:00:00 | 2A
 |  | 2011-04-12 00:00:00 | 2B
 |  | 2011-04-13 00:00:00 | 2C
 |  | 2011-04-14 00:00:00 | 2D
 |  | 2011-04-15 00:00:00 | 2E
 |  | 2011-04-16 00:00:00
 |  | 2011-04-17 00:00:00
 |  | 2011-04-18 00:00:00
 |  | 2011-04-19 00:00:00
 |  | 2011-04-20 00:00:00
 |  | 2011-04-21 00:00:00
 |  | 2011-04-22 00:00:00
 |  | 2011-04-23 00:00:00
 |  | 2011-04-24 00:00:00
 |  | 2011-04-25 00:00:00
 |  | 2011-04-26 00:00:00
 |  | 2011-04-27 00:00:00
 |  | 2011-04-28 00:00:00
Spreadsheet: c661f576-7614-40a0-b84f-2207bb904d85
Sheet: Sheet1

Release: BEA Regions Employment and Unemployment | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=138
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-16 7:01 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Employment and Unemployment | 2007-07-20 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2007-07-20 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-07-20 00:00:00
2007-08-17 00:00:00
2007-09-25 00:00:00
2007-10-19 00:00:00
2007-11-28 00:00:00
2007-12-21 00:00:00
2008-01-18 00:00:00
2008-03-11 00:00:00
2008-03-28 00:00:00
2008-04-18 00:00:00
2008-05-16 00:00:00
2008-06-20 00:00:00
2008-07-18 00:00:00
2008-08-15 00:00:00
2008-09-19 00:00:00
2008-10-21 00:00:00
2008-11-21 00:00:00
2008-12-19 00:00:00
2009-01-27 00:00:00
2009-02-27 00:00:00
2009-03-11 00:00:00
2009-03-27 00:00:00
2009-04-17 00:00:00
2009-05-22 00:00:00
2009-06-19 00:00:00
2009-07-17 00:00:00
2009-08-21 00:00:00
2009-09-18 00:00:00
2009-10-21 00:00:00
2009-11-20 00:00:00
2009-12-18 00:00:00
2010-01-22 00:00:00
2010-03-10 00:00:00
2010-03-26 00:00:00
2010-04-16 00:00:00
2010-05-21 00:00:00
2010-06-18 00:00:00
2010-07-20 00:00:00
2010-08-20 00:00:00
2010-09-21 00:00:00
2010-10-22 00:00:00
2010-11-23 00:00:00
2010-12-17 00:00:00
2011-01-25 00:00:00
2011-03-10 00:00:00
2011-03-25 00:00:00
2011-04-19 00:00:00
2011-05-20 00:00:00
2011-06-17 00:00:00
2011-07-22 00:00:00
2011-08-19 00:00:00
2011-09-16 00:00:00
2011-10-21 00:00:00
2011-11-22 00:00:00
2011-12-20 00:00:00
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
Spreadsheet: 8ce52e16-cc4d-4e08-8fc1-648732cb31e3
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
CAGG | Test | CAGG | Cold [NAME], Serum | Cold Agglutinin Titer, S | CATTH/6168: Titration-Red Cell Agglutination at 4 Degrees C CACNH/81174: Screen | Plain, Red-Top Tube: Red |  |  | 4 | mL | Container/Tube: Red top [NAME]: 4 mL Collection Instructions: Do not refrigerate prior to separation of serum from red cells. Separate serum from red cells immediately after blood clots. Additional Information: For diagnosis of Mycoplasma pneumoniae infection, see MYCPN/85107 Mycoplasma pneumoniae Antibodies, IgG and IgM, Serum. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Serum gel tube | SCREEN Negative   TITER <1:64 | Monday through Friday, Sunday, Continuously |  | 3 days |  | Profile |  |  |  |  | Rochester
CAGG | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
CAGG | Component | CACNH | Screen | Screen | Screen followed by Titration Red cell agglutination at 4 degrees C. | Plain, Red-Top Tube: Red |  |  | 4 | mL |  | 1.0 mL | Specimens Other Than:	Serum Anticoagulants Other Than:	None Hemolysis:	No Thawing:	No Lipemia:	No | Negative If positive, results are titered. | Monday through Friday, Sunday; Continuously |  | 3 days | 1 | 86156 |  |  | Yes | No
CACNH | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
CACNH | Result | CACNH | Screen | Screen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32672-8
CAGG | Component | CATTH | Titer | Titer | Titration Red cell agglutination at 4 degrees C. | Plain, Red-Top Tube: Red |  |  |  | Varies | Container/Tube: Red top Specimen Volume: Full tube Collection Instructions: Tube must remain at 37 degrees C. Place collection tube in a thermopak. |  | Specimens Other Than: Anticoagulants Other Than: Hemolysis: Thawing: Lipemia: |  |  |  | 3 days | 1 | 86157 |  |  | Yes | No
CATTH | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
CATTH | Result | CATTH | Titer | Titer | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 14658-9
Spreadsheet: benjamin_rogers__1200__3rd Party Retail Shorts version 1
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Spreadsheet: 811832d1672824785-formula-to-return-sum-with-multiple-criteria-index-match-problem
Sheet: dec22

Client ID | Product group | Vallue
4 | 209999 | 0
4 | 300600 | 36212.07
4 | 300607 | 27120.22
4 | 300608 | 1125.19
4 | 100700 | 0
4 | 100770 | 44213.58
4 | 200900 | 7421.26
4 | 200903 | 0
4 | 200904 | 12455.86
4 | 200905 | 11377.67
4 | 200910 | 99560
4 | 200950 | 46.69
5 | 0 | 0
5 | 209999 | 57.94
5 | 300600 | 4942.56
5 | 300608 | 0
5 | 100700 | 3096.62
5 | 100820 | 283.36
5 | 200900 | 647.4
5 | 200904 | 4647.389999999999
5 | 200905 | 2359.94
5 | 200910 | 0
5 | 200920 | 5308.87
5 | 200950 | 0
8 | 0 | 0
8 | 209999 | 0
8 | 300600 | 74878.92
8 | 300607 | 33587.8
8 | 300608 | 4882.03
8 | 100700 | 89156.75000000003
8 | 100770 | 592769.0700000001
8 | 100820 | -24868.42
8 | 200900 | 61320.94999999999
8 | 200903 | 3681.469999999999
8 | 200904 | 117456.11
8 | 200905 | 166476.73
8 | 200910 | 303328.28
8 | 200950 | 5889.69
35 | 0 | 0
35 | 100700 | 0
35 | 100770 | 0
35 | 100820 | 0
35 | 200903 | 0
35 | 200904 | 0
35 | 200910 | 0
49 | 0 | 0
49 | 300600 | 5911.349999999999
49 | 300607 | 5063.8
49 | 300608 | 4822.35
49 | 100700 | 0
49 | 100770 | 0
49 | 200900 | 1177.1
49 | 200904 | 807.25
49 | 200905 | 5901.799999999999
49 | 200910 | 0
49 | 200950 | 277.4
54 | 0 | 0
54 | 209999 | 1501.27
54 | 300600 | 43628.71
54 | 300607 | 92156.74999999999
54 | 300608 | 0
54 | 100700 | 107905.55
54 | 100770 | 424194.22
54 | 100820 | 0
54 | 200900 | 31315.85
54 | 200903 | 0
54 | 200904 | 46987.53
54 | 200905 | 118561.1
54 | 200910 | 251028.15
54 | 200950 | 0
66 | 0 | 0
66 | 100700 | 0
66 | 200905 | 0
71 | 0 | 0
71 | 209999 | 2165.36
71 | 300600 | 99227.87999999999
71 | 300607 | 27823.55
71 | 300608 | 65565.97
71 | 300645 | 16490
71 | 100700 | 448098.45
71 | 100770 | 599938.43
71 | 100820 | 7783.35
71 | 200900 | 32155.91
71 | 200903 | 6287.87
71 | 200904 | 141003.64
71 | 200905 | 187920.55
71 | 200910 | 470933.11
71 | 200920 | 9254.98
71 | 200950 | 0
71 | 200951 | 19637.68
88 | 0 | 0
88 | 300607 | 0
88 | 300645 | 8288
88 | 100700 | 60468.28
88 | 100770 | 49085.52
88 | 100820 | 45201.48
88 | 200900 | 0
88 | 200905 | 488.75
88 | 200910 | 3496.55
Spreadsheet: 718884d1613405189-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Sheet2 (2)

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 05:08:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | End Shift | 09:37:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 13:02:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 17:52:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime