tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852120d1702216773-sum-weekly-and-monthly-total-task
Sheet: Data

 |  |  | Totals: | Sat | Sun | Week | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  | Month |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  | Month |  |  |  | Week |  |  |  |  |  |  |  | Week
 |  |  |  | 2023-07-01 00:00:00
 | Target | Ventes prévues | Sum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 45 | 66 | 66 | 64 | 78 | 45 | x1 | 34 | 53 | 67 | 8 | 9 | 9 | 8 | x2 | 3 | Y1 | 2 | 4 | 6 | 6 | 8 | 9 | [NAME] |  |  |  |  |  |  |  | x4 |  |  |  |  |  |  |  | x5 |  |  |  |  |  |  |  | x5 |  |  |  |  | y3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday to Sunday |  |  |  |  | first to the 30th or he 31st
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] total |  |  |  |  | Monthly total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x1 |  | X5+Y5+Z5+AA5+AB5+AC5+AD5 |  |  | y1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x2 |  |  |  |  | y2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | y3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 29284575-6008-45d2-99a5-a0e014bb8c64
Sheet: Sheet1

Permit Number | Facility Name | 1999Total | 2000Total | 2001Total | 2002Total | 2003Total | 2004Total | 2005Total | FacilityType
6505-I | NEW HANOVER WASTE-TO-ENERGY FACILITY | 112132 | 108381 | 120751 | 123823.08 | 74984.34 | 104754.88 | 70974.18 | INCIN
Spreadsheet: 770210d1645893518-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1 |  |  |  |  |  |  |  |  |  | Bug
 |  | Selected Bug | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  | 7 |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | *** This should be 160. Different hospitals have exact  test numbers for the same bug and year. Check the blue cells in the data sheet.
Spreadsheet: 460488-minifs-for-older-versions-of-excel-help-minifs-function-for-older-versions-now-across
Sheet: Sheet1

Group | Team | Score1 | Score2 | Score3 |  | Answer1 | Answer2 | Answer3
1 | Ault | 7 | 7 | 5 |  | 4 | 6 | 4 |  | I need to pull the formula in G2 down and across
1 | Church | 6 | 4 | 6 |  | 6 | 4 | 6 |  | to get the min score for each group and Team.
1 | Ault | 4 | 6 | 4 |  | 4 | 6 | 4
1 | Church | 7 | 5 | 6 |  | 6 | 4 | 6 |  | A few correct answers are done manually.
2 | Ault | 6 | 4 | 4 |  | 6 | 4 | 4
2 | Church | 5 | 4 | 6 |  | 5 | 4 | 4
2 | Ault | 7 | 5 | 4 |  | 6 | 4 | 4
2 | Church | 6 | 6 | 4 |  | 5 | 4 | 4
3 | Ault | 7 | 5 | 5 |  | 5 | 5 | 5
3 | Church | 6 | 5 | 7 |  | 3 | 5 | 4
3 | Ault | 5 | 5 | 7 |  | 5 | 5 | 5
3 | Church | 3 | 7 | 4 |  | 3 | 5 | 4
4 | Ault | 3 | 7 | 4
4 | Church | 4 | 4 | 5
4 | Ault | 5 | 6 | 4
4 | Church | 3 | 6 | 6
5 | Ault | 7 | 6 | 7
5 | Church | 5 | 4 | 4
5 | Ault | 4 | 5 | 5
5 | Church | 6 | 6 | 7
6 | Ault | 5 | 4 | 4
6 | Church | 7 | 6 | 4
6 | Ault | 6 | 4 | 6
6 | Church | 7 | 5 | 5
7 | Ault | 4 | 7 | 6
7 | Church | 7 | 4 | 6
7 | Ault | 5 | 7 | 4
7 | Church | 3 | 6 | 6
8 | Ault | 5 | 4 | 6
8 | Church | 3 | 4 | 6
8 | Ault | 6 | 5 | 6
8 | Church | 5 | 7 | 6
9 | Ault | 4 | 4 | 7
9 | Church | 5 | 6 | 5
9 | Ault | 5 | 4 | 5
9 | Church | 5 | 7 | 6
10 | Ault | 5 | 4 | 6
10 | Church | 3 | 7 | 7
10 | Ault | 6 | 7 | 7
10 | Church | 3 | 4 | 7
11 | Ault | 7 | 7 | 6
11 | Church | 5 | 6 | 4
11 | Ault | 3 | 5 | 7
11 | Church | 6 | 7 | 6
Spreadsheet: 88516d1288310802-agents-listed-depending-on-manager-list-example
Sheet: Sheet1

 |  |  |  | Table:
 |  |  |  |  | Manager - # | Staff | Manager
 |  |  |  |  | Fred-1 | A | Fred
 |  |  |  |  | Bam Bam-1 | B | Bam Bam
 |  |  |  |  | Bam Bam-2 | C | Bam Bam
 |  |  |  |  | Fred-2 | D | Fred
 |  |  |  |  | Bam Bam-3 | E | Bam Bam
 |  |  |  |  | Wilma-1 | F | Wilma
 |  |  |  |  | Bam Bam-4 | G | Bam Bam
# | Manager | Staff |  |  | Fred-3 | H | Fred
0 | Fred |  |  |  | Wilma-2 | I | Wilma
1 | Fred | A |  |  | Bam Bam-5 | J | Bam Bam
2 | Fred | D |  |  | Bam Bam-6 | K | Bam Bam
3 | Fred | H |  |  | Fred-4 | L | Fred
4 | Fred | L |  |  | Barney-1 | M | Barney
 |  |  |  |  | Barney-2 | N | Barney
 |  |  |  |  | [NAME] | O | Barney
 |  |  |  |  | Barney-4 | P | Barney
Spreadsheet: 51576d1251222355-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Inputs

TITLE ROSTER
# | Title Dept | Title (Alphabetical)
1 | Tech | Analyst
2 | [NAME] | CEO
3 | Sales | Closer
4 | Tech | Developer
5 | Tech | QA Manager
6 | Sales | Rep
7 | Sales | Sr Rep
8 | [NAME] | SVP
9 | [NAME] | VP
10
11
12
13
14
15
Spreadsheet: 855786d1705282461-sum-formula-with-xlookup-with-multiple-arrays-summary-monsta92-
Sheet: External Budget Spend

 | Project ID | Projects | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 |  |  | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals
Spreadsheet: 827749d1683016294-average-timings-exercise-sample
Sheet: Snapshot

 |  | 2023
 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Average Timings |  |  |  |  |  |  |  |  |  |  |  |  | Yearly Average
 | External | 9 | 5.75 | 9.5 | 8 |  |  |  |  |  |  |  |  | 7.6 |  | *I want to calculate the average days between F2 and G2 by month. It is important to ignore if there are blank cells on G2.
 | Cash Received | 17.5 | 10.75 | 19.5 | 4 |  |  |  |  |  |  |  |  | 12.5 |  | *I want to calculate the average days between B2 and E2 by month. It is important to ignore if there are blank cells on E2.
 | Letter To Authorities | 6.5 | 12.5 | 3.5 | 8 |  |  |  |  |  |  |  |  | 8.6 |  | *I want to calculate the average days between C2 and D2 by month. It is important to ignore if there are blank cells on D2.
 | Authorities Response
 | [NAME] | 10 | - | 2 | - |  |  |  |  |  |  |  |  | 6 |  | *I want to calculate the average days between B2 and D2 by month and by category (Column A). It is important to ignore if there are blank cells on D2.
 | Lim | 3 | - | 5 | - |  |  |  |  |  |  |  |  | 4 |  | I also want to calculate the total average timings for each category on a yearly basis.
 | Paf | - | 4 | - | 13 |  |  |  |  |  |  |  |  | 8.5
 | Lar | - | 24 | - | 3 |  |  |  |  |  |  |  |  | 13.5
 | Amm | 11 | - | - | - |  |  |  |  |  |  |  |  | 11
Spreadsheet: 773227d1647711847-vlookup-and-if-functions-example
Sheet: By Employee

Employee ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 |  |  | 80 | 88 | 80 | 80 | 80 | 72 | 88 | 96 | 88
1001 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
2403 | Doe, [NAME]
 |  | Total Hours:
 |  | Extra Hours:
2050 | Fisher, Mary
 |  | Total Hours:
 |  | Extra Hours:
1920 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
Spreadsheet: 198219d1354710260-i-need-an-interactive-excel-templete-final_approved_distribution_exception_list_2012_q4
Sheet: Local Exp(Partner Issue)

 |  |  |  |  |  | [NAME] for Q4FY12 Eligiblity (Partner Issue)
 | Partner pro Id | Reporter ID | Country | Reporter Name | Region | So2 | Exception Requested for BU | Aug'12 (Not Eligible for) | Sept'12 (Not Eligible for) | Oct'12 (Not Eligible for) | Business Justification | Issue Type | BU | ActualSales  ([NAME]) | Sum of  Actual Sales  (All BU's) | BU | [NAME]) | Sum of  Bonus_CLC (All BU's) | BU | Original Bonus_CLC  ([NAME]) | Sum of Original   Bonus_CLC (All BU's) | Owner | Eligible in Fast track Q2 | Exception requested for Q2 | Exception granted for Q2 | Q2'12 Performance | Eligible in Fast track Q3 | Exception requested for Q3 | Exception granted for Q3 | Q3'12 Performance | Proposal for Q4FY12 | BU Approval | Comments
 | 1-AVYIZ | WS10680 | Azerbaijan | CAETANO GROUP LTD | CEE | 86 | ESS, TS, IPG, HPN | Timeliness | - | - | Caetano had 70% timeliness in August, due to the fact that their reporting person has been replaced suddenly and significant efforts were made to correct all reporting issues; Intensive training provided to the partner by CDS; Reporter is very cooperative.BUs support the exception request - partner is important for further business development in the region. Partner has been trained on reporting and transition to automated transmission of files is pending (HP).100% in all the metrics for current Q. | Partner Issue | BCS  HPN  HPSD  IPG  ISS  TS | $79,126  $18,555  $0  $1,068,639  $0  $1,535,196 | 3945888.47 | BCS  HPN  HPSD  IPG  ISS  TS | $0  $0  $0  $0  $0  $0 | 0 | BCS  HPN  HPSD  IPG  ISS  TS | $5,70  $0  $0  $9,420  $0  $37,402 | 47392 | [NAME] | YES | NO | NO | Eligible | YES | NO | - | Eligible | YES | YES with Warning letter | TS Approval required
 | 1-CDGNC2 | WS11084 | Ukraine | MTI | CEE | 86 | HPN, ESS, TS | - | - | Timeliness | Partner has failed Coherence for ISS and PSG_CL in August, despite repeated notifications to have issues corrected in time. Coherence for HPN and TS was fixed during the 2nd Resubmission Window.  Timeliness in October was missed due to a different calculation method for partner who transfer Sellout reports to HP via EDI.MTI is only one Tier 1 who managed to achieve HPN target in Q4. MTI also overachieved target and helped HPN Ukraine to fulfill quota. MTI is increasing HPN business very rapidly (they started from November 2011 and already N2) and providing bonus for them is extremely important for furher  HPN business developing.Strong commitment from the Distribution Manager to support CDS in improving partner's reporting - top management from the partner's side involved.Curently green for all the metrics. | Partner Issue | BCS  HPN  HPSD  ISS  TS | $2,59,922  $2,08,772  $0  $0  $74,111 | 542805 | BCS  HPN  HPSD  ISS  TS | $0  $0  $0  $0  $0 | 0 | BCS  HPN  HPSD  ISS  TS | $12,422  $17,537  $0  $0  $1,805 | 31764 | [NAME] | NO | NO | - | Not Eligible(Exception not requested) | NO | YES | YES | Not Eligible(Exception requested) | YES with Warning letter | YES with Warning letter | TS Approval required
Spreadsheet: 818175d1676632210-recognizing-words-from-an-url-and-counting-how-many-of-them-appear-in-another-cell-formula-to-break-up-url-and-count-words-in-other-cells
Sheet: Sheet1

example url | group of words | what I need as an output - counting the number of words from the group that appear in the url slug (separated by "-")
https://www.example.com/word1-word2-word3/ | word1 word2 word3 | 3 | 3 | word1
https://www.example.com/word1-word2-something/ |  | 2 | 2 | word2
https://www.example.com/word1-something/ |  | 1 | 1 | word3
https://www.example.com/word1-something-word1/ |  | 2 | 1
[NAME] |  | 3 | 3
specific example
URL | word | count
https://www.fruit.com/green-apples/ | good green apples | 2 | 2 | good
https://www.fruit.com/awesome-green-apples/ |  | 2 | 2 | green
https://www.fruit.com/good-green-apples/ |  | 3 | 3 | apples
https://www.fruit.com/apples-for sale/ |  | 1 | 1
https://www.fruit.com/oranges |  | 0 | 0
Spreadsheet: 472025d1469407026-converting-data-between-tabs-department-performance
Sheet: 332082

TEAM
332082 |  | [NAME]
 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | - |  | 220 | 6.55 |  | 393 | 15.1 |  | 0 | 0
2016-07-10 00:00:00 | - |  | 21 | 1.44 |  | 53 | 3.77 |  | 298 | 10.83
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: 546971d1510271057-fill-summary-sheet-from-multiple-tabs-with-different-names-workers-comp-tracking-sheet
Sheet: SUMMARY

 | NAME | SITE | INSURER | DOI | INJURY | COC | REVIEW | FINAL | CAPACITY |  |  |  |  |  | Traffic Lights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Word | Icon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNFIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suitable
Spreadsheet: 727350d1617859573-dependent-index-match-struggles-sampleworkbook_revised
Sheet: Sample

Reference Table
Age | % | Raw Score |  |  | Summary Table
18-19 | >16 | 11 |  |  | Current Result
18-19 | >16 | 12 |  |  | Test
18-19 | >16 |  |  |  | Age | 18-19
18-19 | >16 |  |  |  | Raw Score | 0 | <- This is the "raw" score (Column C)
18-19 | >16 |  |  |  | % |  | <- This is the percentile (Column B) that corresponds to the raw score;  the value here should be ≤1
18-19 | >16
18-19 | 11-16
18-19 | 6-10
18-19 | 2-5 | 10 |  |  |  |  | Notes
18-19 | 2-5 |  |  |  |  |  | - G6 is a calculated column that returns the % based on the raw score entered in G5
18-19 | ≤1 | 9 |  |  |  |  | - Everything works well until the value of "0" is entered
18-19 | ≤1 | 8 |  |  |  |  | in G5
18-19 | ≤1 | 7
18-19 | ≤1 | 6
18-19 | ≤1 | 5 |  |  |  |  | Desired Result
18-19 | ≤1 | 4 |  |  |  |  | Test
18-19 | ≤1 | 3 |  |  |  |  | Age | 18-19:11:31
18-19 | ≤1 | 2 |  |  |  |  | True Negatives (Raw) | 0
18-19 | ≤1 | 1 |  |  |  |  | True Negatives % | ≤1
18-19 | ≤1 | 0
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
18-19 | ≤1
Spreadsheet: 7e41dae4-8204-406a-bc05-de6b1a07de3c
Sheet: SFF - MM Subtotals by container

 |  |  |  | Total
 | [NAME]  --  Scouting For Food
 | Messiah's Market (multi-bin) Food Collections  --  Nov 13, 2009
 | Site | Unit Code | Unit Type | Unit No. | Weight
 | MM - Bins (2.1 lb) | P1000 |  |  | 171.18719
 | MM - Bins (2.1 lb) | P1154 |  |  | 1160.61167
 | MM - Bins (2.1 lb) | P1484 |  |  | 1589.5166 |  |  | Row Labels | Sum of Weight
 | MM - Bins (2.1 lb) | [NAME] |  |  | 561.73208 |  |  | P1000 | 624.45295
 | MM - Bins (2.1 lb) | P997 |  |  | 1044.87017 |  |  | P1153 | 53.46155
 | MM - Bins (2.1 lb) | T1106 |  |  | 287.03892 |  |  | P1154 | 3688.40603
 | MM - Bins (2.1 lb) | T1154 |  |  | 386.4663800000001 |  |  | P1484 | 4137.813740000001
 | MM - Bins (2.1 lb) | T1167 |  |  | 245.15152 |  |  | [NAME] | 1286.758882
 | MM - Bins (2.1 lb) | T1173 |  |  | 470.35141 |  |  | P997 | 2271.950530000001
 | MM - No Adjustments | P1154 |  |  | 233.79783 |  |  | T1066 | 50.59557
 | MM - No Adjustments | P1484 |  |  | 341.16185 |  |  | T1106 | 861.5576800000001
 | MM - No Adjustments | P997 |  |  | 265.43384 |  |  | T1154 | 1205.14459
 | MM - No Adjustments | T1106 |  |  | 88.84538 |  |  | T1167 | 547.51241
 | MM - No Adjustments | T1154 |  |  | 93.47504 |  |  | T1173 | 1033.73694
 | MM SmBox (xxxx) | P1000 |  |  | 372.35694 |  |  | Grand Total | 15761.390872
 | MM SmBox (xxxx) | P1153 |  |  | 53.46155
 | MM SmBox (xxxx) | P1154 |  |  | 1343.92416
 | MM SmBox (xxxx) | P1484 |  |  | 1090.50539
 | MM SmBox (xxxx) | [NAME] |  |  | 569.271812
 | MM SmBox (xxxx) | P997 |  |  | 731.5965100000001
 | MM SmBox (xxxx) | T1066 |  |  | 50.59557
 | MM SmBox (xxxx) | T1106 |  |  | 382.82879
 | MM SmBox (xxxx) | T1154 |  |  | 595.7931500000001
 | MM SmBox (xxxx) | T1167 |  |  | 156.41637
 | MM SmBox (xxxx) | T1173 |  |  | 243.27761
 | MM - Tray (xx) | P1000 |  |  | 80.90881999999999
 | MM - Tray (xx) | P1154 |  |  | 950.0723700000001
 | MM - Tray (xx) | P1484 |  |  | 1116.6299
 | MM - Tray (xx) | [NAME] |  |  | 155.75499
 | MM - Tray (xx) | P997 |  |  | 230.05001
 | MM - Tray (xx) | T1106 |  |  | 102.84459
 | MM - Tray (xx) | T1154 |  |  | 129.41002
 | MM - Tray (xx) | T1167 |  |  | 145.94452
 | MM - Tray (xx) | T1173 |  |  | 320.10792
 | NB:  T663 & P663 worked together.  Tallies split evenly here.
Spreadsheet: phillip_m_love__31134__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 10/29/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Energy Service Providers, LLC | YF1395.1 | F | C3GC | Credit Previously Provided
Houston Energy Service Company | YF0106.1 YF1369.1 | P | NG | [NAME]
New Counterparty | YF0966.1 | P | NG | [NAME]
New Counterparty | YF2687.1 | P | NG | [NAME]
Nicor Energy LLC | YF2309.1 | F | NG | Nicor Enerchange, LLC
Wexford Spectrum Investors, LLC | YF0665.1/3/5/7 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
APS Energy Services Company, Inc. | YF0280.1 | P | NG | Arizona Public Services Company, Inc.
Ashland Chemical Company | QK2721.3 | F | NG | Ashland Specialty Chemicals Co
Duke Energy Marketing Limited Partnership | YF1476.1 | F | NG | Duke Energy Marketing Limited Partnership (w/ECC)
El Paso Gas Marketing Company | YF2538.1 | F | NG | El Paso Merchant Energy, LP
PG&E Energy Trading-Power, LP | YF0688.1 | F | NG | PG&E Energy Trading-Gas Corporation
The Williams Companies, Inc. | YE8888.1 | F | NG | Williams Energy Marketing & Trading
Vitol Capital Management Ltd. | YF0936.1 YF0937.1 | F | NG | Vitol SA, Inc.
Wicor Inc. | YF2345.1 | F | NG | Wisconsin Power & Light Company
Spreadsheet: 772021d1646971173-vlookup-an-image-vlookup-image
Sheet: Sheet1

1 | vlookedup image 1 | 11 | vlookedup image 11
2 | vlookedup image 2 | 12 | vlookedup image 12
3 | vlookedup image 3 | 13 | vlookedup image 13
4 | vlookedup image 4 | 14 | vlookedup image 14
5 | vlookedup image 5 | 15 | vlookedup image 15
6 | vlookedup image 6 | 16 | vlookedup image 16
7 | vlookedup image 7 | 17 | vlookedup image 17
8 | vlookedup image 8 | 18 | vlookedup image 18
9 | vlookedup image 9 | 19 | vlookedup image 19
10 | vlookedup image 10 | 20 | vlookedup image 20
Spreadsheet: 6f1b2ba5-86a0-495e-b0fc-0a0b6fa2bb84
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
GAL1P | Test | GAL1P | Galactose-1-Phosphate (Gal-1-P), [NAME] | Galactose-1-Phosphate, RBC | Ultraviolet, Enzymatic | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 2 | mL | Erythrocytes must be washed within 4 hours of draw.   Collection Container/Tube: Green top (heparin) Submission Container/Tube: Plastic vial Specimen Volume: Washed, packed cells (red cell pellet from step f in Collection Instructions) Collection Instructions:  1. Collect and process a minimum of 2 mL of whole blood as follows: a. Immediately centrifuge for 10 minutes at 650 x G. For conversion to RPMs, see Additional Information. [NAME] the plasma and buffy coat layers. [NAME] a cold 0.9% saline solution to the erythrocytes (about 2 times the volume of erythrocytes). d. Mix gently by inversion and centrifuge again for 10 minutes at 650 x G. e. Remove and discard the saline. f. Repeat the wash steps (steps c-e) 2 more times. 2. After the final centrifugation, remove and discard the saline and a thin layer of the top cells. Additional Information: The relative centrifugal force (G-force) can be estimated by applying the following formula: g=11.18 x r x (n/1000)2. Where: r=radius in centimeters and n=speed in RPM. The radius from the center of the rotation axis to the bottom or outermost portion of the test tube should be used. RCF is expressed relative to the force of the earth's gravity. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | Red cell pellet from heparinized | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Non-galactosemic: 5-49 mcg/g of hemoglobin (<1 mg/dL) Galactosemic on galactose restricted diet: 80-125 mcg/g of hemoglobin (1-4 mg/dL) Galactosemic on unrestricted diet: >125 mcg/g of hemoglobin (>4 mg/dL) | Wednesday; 8 a.m. | 8 days | 15 days | 1 | 84378 |  |  |  |  | Rochester
GAL1P | [NAME] | WRBC | Washed RBC |  |  |  | Frozen | 9 days
GAL1P | Result | 80337 | Galactose-1-Phosphate, RBC | Galactose-1-Phosphate, RBC | Numeric |  |  |  |  | mcg/g Hb |  |  |  |  |  |  |  |  |  | 33360-9 | Galactose 1 phosphate:MCnt:Pt:RBC:Qn:
GAL1P | Result | 24101 | Galactose-1-Phosphate Conversion | Galactose-1-Phosphate Conversion | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2312-7 | Galactose 1 phosphate:MCnc:Pt:RBC:Qn: