tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30638__texasfred plove
Sheet: Summary

Financial Liquidation Variance Summary
PRODUCTION MONTH:  3/00
DESK: Texas
 | per OA reports |  | per [NAME] | var | expl
NGP&L LIQUIDATIONS | 1296214
Less:
Discrepancies between Actuals & Flash | -135.8000000004098
Weather hedge not included in the detailed file | 0
Discrepancies between OA flash & detailed flash | 0
In Actuals, not [NAME] (unexplained) | 93314
Not TAGG related:Reclass inv profits to storage reconciliation
Restated NGP&L
GL LIQUIDATIONS | -2202023 |  | 2202023
Less:
Direct offset in Storage & Texas FL, [NAME] of value | -300000
Direct offset in Texas & West FL, Need reclass of value | 78000
EOG - tsf to demand reim | 1875810
Weather hedge total value higher than flash
Weather hedge reversal value higher than flash
These are transport book liquidations | 763375
Weather hedge manual entry | 1200872
3rd party financial deal - did not liquidate
Discrepancies between Actuals & Flash
[NAME]
GL Adjustments
In [NAME], not Actuals (unexplained)
Not TAGG related:Unknown entry in OA report
Restated Actuals
[NAME]
unexplained
Spreadsheet: 66536655-e584-447b-8f93-cf51b7e68823
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Project title:
Venue | Date from | Date to | No of performances | Capacity | Target audience numbers | Audience numbers |  | Box office income
 |  |  |  |  |  | Paying | Non-paying
Comments
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: Hold Tracking

MH Holds | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
Region 1 | 44 | 47 | 56 | 39 | 48 | 55 | 46 |  | 65 | 56 | 80 | 69 | 50 | 55
Region 2 | 27 | 13 | 17 | 10 | 19 | 16 | 20 |  | 24 | 14 | 28 | 21 | 17 | 20
Region 3 | 91 | 85 | 64 | 106 | 91 | 81 | 79 |  | 94 | 82 | 112 | 94 | 82 | 88
Region 4 | 167 | 148 | 146 | 179 | 163 | 155 | 156 |  | 174 | 175 | 156 | 161 | 154 | 181
Region 5 | 44 | 38 | 53 | 38 | 40 | 44 | 42 |  | 45 | 62 | 48 | 50 | 39 | 39
Region 6 | 29 | 13 | 12 | 24 | 20 | 11 | 20 |  | 12 | 24 | 27 | 26 | 28 | 21
Region 7 | 29 | 37 | 28 | 31 | 36 | 35 | 26 |  | 36 | 36 | 37 | 34 | 42 | 33
Statewide Total | 431 | 381 | 376 | 427 | 417 | 397 | 389 |  | 450 |  | 488 | 455 | 412 | 437
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 7 Math

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 7
Grade 7 Mathematics MTAS-III
Raw Score | Scale Score** | Level
0 | 124 | D
1 | 136 | D
2 | 143 | D
3 | 148 | D
4 | 153 | D
5 | 157 | D
6 | 161 | D
7 | 165 | D
8 | 171 | D
9 | 177 | D
10 | 182 | D
11 | 186 | D
12 | 189 | D
13 | 190 | P
14 | 193 | P
15 | 195 | P
16 | 196 | P
17 | 198 | P
18 | 199 | P
19 | 200 | M
20 | 202 | M
21 | 204 | E
22 | 206 | E
23 | 208 | E
24 | 210 | E
25 | 213 | E
26 | 219 | E
27 | 229 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 600719d1543928626-indirect-need-cell-range-to-change-to-the-indirect-method-indirect
Sheet: Data

Date |  |  |  |  | Age
2018-01-25 00:00:00 |  |  |  |  | 23
2018-01-26 00:00:00 |  |  |  |  | 42
2018-01-27 00:00:00
2018-01-28 00:00:00 |  |  |  |  | 33
2018-01-29 00:00:00 |  |  |  |  | 57
2018-01-30 00:00:00 |  |  |  |  | 44
2018-01-31 00:00:00 |  |  |  |  | 20
2018-02-01 00:00:00 |  |  |  |  | 63
2018-02-02 00:00:00 |  |  |  |  | 57
2017-02-03 00:00:00 |  |  |  |  | Unknown
Spreadsheet: 713b3601-e599-471f-a014-d5e961103de0
Sheet: Sheet1

Unnamed: 0 | Baylor University | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Travel Authorization Form (TAF)
 | Authorization for Official Travel (Please type or print clearly)
 | Name |  |  |  |  | Campus Phone#
 | Department |  |  |  |  | Destination
 |  |  |  |  |  |  |  | (City/State)
 | Method(s) of Travel |  |  |  |  | Method of Payment
 |  |  |  |  |  |  |  | (e.g. BU T&E Card, personal credit card)
 | Business Purpose / Justification of Trip
 | #Days to be spent on Business |  |  |  |  | ESTIMATED EXPENSES:
 |  |  |  |  |  | Airline ticket, economy class
 | Departure Date: |  |  | Time: |  | Personal car # of miles |  |  | at | 0.565 | per mile | 0
 |  |  |  |  |  | Rental car # days |  |  | at |  | per day | 0
 | Return Date |  |  | Time: |  | Public transportation (bus, train, taxi, etc.) |  |  |  |  |  | 0
 |  |  |  |  |  | Lodging # of nights |  |  | at |  | per night | 0
 | Charge trip To: |  |  |  |  | Meals # of days |  |  | at |  | per day | 0
 |  |  |  |  |  | Registration Fee
 | Dept ID |  |  |  | (e.g. 020xxxx) | Other Expenses
 |  |  |  |  |  | Total Expenses |  |  |  |  |  | 0
 | Account # |  |  |  | (e.g. 9382) | Honorarium and/or expenses reimbursed
 |  |  |  |  |  | from other sources
 | Project #
 |  |  |  |  |  | Total Estimated Expenses from Baylor |  |  |  |  |  | 0
 |  |  |  |  |  | Estimate number of Travelers by placing a # in all that apply |  |  |  |  | Employee
 |  |  |  |  |  |  |  |  |  |  | Spouse
 |  |  |  |  |  |  |  |  |  |  | Dependent
 |  |  |  |  |  |  |  |  |  |  | Guest
 | Comments: |  |  |  |  |  | Total Travelers |  |  | 0
 | 1.  All persons traveling on behalf of Baylor University and those who approve travel expense reimbursements are responsible for knowledge of [NAME]'s travel policy.  http://www.baylor.edu/travel/index.php?id=8724
 | 2.  If a traveler has a University travel card (T&E Card), it can be used by the Cardholder to pay for travel and related expenses.  Note:  Only the person whose name appears on the T&E card can use the card; it must not be lent to anyone else for use on a trip.
 | 3.  Reimbursable travel expenses with proper documentation must be submitted on the Expense Report (ER) within 15 business days of the end of the trip.
 | I hereby request authorization to travel on behalf of Baylor University.  I have read and understand Baylor's travel policy and procedures as well as any more specific or restrictive policies established in my school or division.  I understand that ALL travel expenses must be claimed for reimbursement within 15 business days after I return from this trip.
 | REQUESTER SIGNATURE
 | Traveler |  |  |  |  |  |  | Date
 | [NAME] SIGNATURE
 | Travel Approver / Designee |  |  |  |  |  |  | Date
 | All original TAFs must be filed in traveler's central office location.
Spreadsheet: 64c2c802-41ab-4654-9297-77c694f521b4
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
ALDS | Test | ALDS | Aldosterone, Serum | Aldosterone, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top or serum gel tube: Red |  |  | 2 | mL | Collection Container/Tube:  Preferred: Red top  Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1.2 mL Collection Instructions: 8 a.m. draw time (after the patient is active for 2 hours) is recommended; preferably no later than 10 a.m.   Additional Information: See Renin-Aldosterone Studies in Special Instructions for more detailed instructions. | 0.6 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 0-30 days: 17-154 ng/dL* 31 days-11 months: 6.5-86 ng/dL* 1-10 years: < or =40 ng/dL (supine)* < or =124 ng/dL (upright)* > or =11 years: < or =21 ng/dL (a.m. peripheral [NAME] specimen)  *Loeuille GA, Racadot A, Vasseur P, Vandewalle B: Blood and urinary aldosterone levels in normal neonates, infants and children. Pediatrie 1981;36:335-344 | Monday through Saturday; 10 a.m. | 2 days | 5 days | 1 | 82088 |  |  |  |  | Rochester
ALDS | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
ALDS | Result | 8557 | Aldosterone, S | Aldosterone, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 1763-2 | Aldosterone:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 215894d1361532222-merging-rows-via-vlookups-helpsheet_pivot-solution
Sheet: Sheet1

What I Have | Time | Col 1 | Col 2 | Col 3 | Col 4 |  | What I want |  | Col 1 | Col 2 | Col 3 | Col 4
 | 700 | 1 |  |  |  |  |  | 700 | 1 | 2 | 3
 | 700 |  | 2 |  |  |  |  | 800 | 2 | 1 | 3
 | 700 |  |  | 3 |  |  |  | 900 | 1 | 2 | 3
 | 800 |  | 1 |  |  |  |  | 1000 | 1 | 2 | 3
 | 800 | 2 |  | 3 |  |  |  | 1100 | 1 | 2 | 3
 | 900 | 1 | 2 | 3 |  |  |  | 1200 | 1 | 2 | 3 | 4
 | 1000 | 1 |  |  |  |  |  | 1300 | 1 |  |  | 1
 | 1000 |  | 2 | 3 |  |  |  | 1400 | 1
 | 1100 | 1 | 2 | 3
 | 1200 | 1
 | 1200 |  | 2
 | 1200 |  |  | 3
 | 1200 |  |  |  | 4
 | 1300 | 1
 | 1300 |  |  |  | 1
 | 1400 | 1
Spreadsheet: 06edc1dd-d75a-4033-bd23-917bb109855c
Sheet: Mathematics Grade 6

2013 Minnesota Comprehensive Assessments-Modified
Grade 6 Mathematics
Raw Score | Scale Score | Level
0 | 119 | D
1 | 138 | D
2 | 149 | D
3 | 156 | D
4 | 161 | D
5 | 166 | D
6 | 169 | D
7 | 172 | D
8 | 175 | D
9 | 177 | D
10 | 180 | D
11 | 182 | D
12 | 184 | D
13 | 186 | D
14 | 188 | D
15 | 190 | P
16 | 192 | P
17 | 194 | P
18 | 196 | P
19 | 198 | P
20 | 200 | M
21 | 202 | M
22 | 204 | M
23 | 206 | M
24 | 208 | E
25 | 210 | E
26 | 212 | E
27 | 215 | E
28 | 218 | E
29 | 221 | E
30 | 224 | E
31 | 228 | E
32 | 233 | E
33 | 240 | E
34 | 251 | E
35 | 270 | E
End of Worksheet
Spreadsheet: 296013d1391931021-auto-update-addition-based-on-base-data-sample
Sheet: MpCost-Revenue

 |  |  |  |  |  | Rate | IN | US | UK | GR
 |  |  |  |  |  | 01 |  |  |  | 70.88
 |  |  |  |  |  | 02 |  |  |  | 70.88
 |  |  |  |  |  | 03 | 30 | 65 |  | 84.5
 |  |  |  |  |  | 04
 |  |  |  |  |  | 05 |  |  |  | 90
 |  |  |  |  |  | 06 | 28 | 75
 |  |  |  |  |  | 07 | 24 | 65
 |  |  |  |  |  | 08 | 22 | 60
 |  |  |  |  |  | 09
 |  |  |  |  |  | 10 | 0 | 0 | 0 | 0
Spreadsheet: 808279d1670381851-pc-asset-tracker-get-value-in-new-sheet-sample-pc-asset-tracker
Sheet: Master

PC Tracker List
Asset Tag | Serial No | Hostname | Owner | Departement | Location | Brand | Model | Type | Service Start | Service End | Status | Asset Tag 2 | Serial No | Hostname 2 | Brand | Model | Type | Service Start | Service End | Status
7022.02.0040 | 5CD7338GXD | BERNBLGL001 | [NAME] | Legal | Berlin | HP | HP ProBook 430 G3 | Notebook | 2017-10-07 00:00:00 | 2021-10-07 00:00:00 | Expired | 22K.70B.D001 | 22K.70.D084 | BERNBLGL001 | HP | HP ProBook 440 G8 16 Gb | Notebook | 2022-02-18 00:00:00 | 2026-02-18 00:00:00 | Active
7000.02.0630 | 5CD60979XT | NYKNBFIN001 | Mario | Finance | New York | HP | HP ProBook 430 G3 | Notebook | 2016-12-19 00:00:00 | 2020-12-19 00:00:00 | Expired | 22B.70B.D120 | 5CD1507XH9 | NYKNBFIN001 | HP | HP ProBook 440 G8 | Notebook | 2022-02-18 00:00:00 | 2026-02-18 00:00:00 | Active
Spreadsheet: 521439d1496591946-index-multiple-tables-on-multiple-sheets-testing-2-
Sheet: Team L

Case Number | Media Source | Status | ATT Team Leader | Case Owner | [NAME] | Case Summary
 |  |  |  |  | I enter information in here and it goes into SM June sheet based on Case Number and This Sheet Name or ATT Team Leader | I enter information in here and it goes into SM June sheet based on Case Number and This Sheet Name or ATT Team Leader
Top 3 Case Drivers
Outliers Resolve
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Outliers ORS
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Workflow Outliers *507100
Please include Who:  What: Opportunity for the workflow per mycst*507100 2 - 3 agents
Spreadsheet: 878192d1725251584-power-query-column-values-to-new-columns-cat
Sheet: Sheet1

 | Initial |  |  |  | Desired
 | Date | Category | Branch | Value |  | Branch | Date | Red | Blue | Green
 | 2024-08-01 00:00:00 | Red | A | 5 |  | A | 2024-08-01 00:00:00 | 5 | 12 | 15
 | 2024-08-01 00:00:00 | Blue | A | 12 |  | B | 2024-08-01 00:00:00 | 12 | 45 | 5
 | 2024-08-01 00:00:00 | Green | A | 15 |  | A | 2024-08-02 00:00:00 | 45 | 78 | 5
 | 2024-08-02 00:00:00 | Red | A | 45 |  | B | 2024-08-02 00:00:00 | 5 | 18 | 20
 | 2024-08-02 00:00:00 | Blue | A | 78
 | 2024-08-02 00:00:00 | Green | A | 5
 | 2024-08-01 00:00:00 | Red | B | 12 |  | I want to use this to produce a stacked Bar Chart with Branch and date onteh X axis and the colours as the composite values.
 | 2024-08-01 00:00:00 | Blue | B | 45
 | 2024-08-01 00:00:00 | Green | B | 5
 | 2024-08-02 00:00:00 | Red | B | 5
 | 2024-08-02 00:00:00 | Blue | B | 18
 | 2024-08-02 00:00:00 | Green | B | 20
Spreadsheet: 678039d1589684273-pick-cost-based-on-value-example
Sheet: Customer Price List (Sept 2019)

 |  |  |  |  |  |  | Customer Price List (Sept 2019)
 |  |  |  | Original Equipment Manufacturer |  |  |  |  |  | Generic
 |  |  |  | IPHONE | 5/5 C | 13 |  |  | IPHONE | 5/5 C | 10
 |  |  |  | IPHONE | 5 S | 14 |  |  | IPHONE | SE | 10
 |  |  |  | IPHONE | 6 | 19 |  |  | IPHONE | 6 | 11
 |  |  |  | IPHONE | 6 S | 23 |  |  | IPHONE | 6 Plus | 16
 |  |  |  | IPHONE | 6 Plus | 26 |  |  | IPHONE | 6 S | 16
 |  |  |  | IPHONE | 6 S Plus | 32 |  |  | IPHONE | 6 S Plus | 19
 |  |  |  | IPHONE | 7 | 30 |  |  | IPHONE | 7 | 17
 |  |  |  | IPHONE | 7 Plus | 46 |  |  | IPHONE | 7 With Plate | 18
 |  |  |  | IPHONE | 8 | 43 |  |  | IPHONE | 7 Plus | 19
 |  |  |  | IPHONE | 8 Plus | 54 |  |  | IPHONE | 8 | 19
 |  |  |  | IPHONE | X | 161 |  |  | IPHONE | 8 Plus | 21
 |  |  |  | IPHONE | X Off Phone | 166 |  |  | IPHONE | X Hard OLED New | 81
 |  |  |  | IPHONE | XR | 96 |  |  | IPHONE | X Soft OLED | 121
 |  |  |  | IPHONE | XS | 171 |  |  | IPHONE | XR Copy | 71
 |  |  |  | IPHONE | [NAME] | 236 |  |  | IPHONE | XS OLED | 131
 |  |  |  |  |  |  | Customer Price List (Sept 2019)
 |  |  |  |  | Premium |  |  |  |  | NCC
 |  |  |  | IPHONE | 6 | 14 |  |  | IPHONE | 6 | 15.5
 |  |  |  | IPHONE | 6 Plus | 19 |  |  | IPHONE | 6 Plus | 19
 |  |  |  | IPHONE | 6 S | 18 |  |  | IPHONE | 6 S | 19
 |  |  |  | IPHONE | 6 S Plus | 19.5 |  |  | IPHONE | 6 S Plus | 23
 |  |  |  | IPHONE | 7 Prem/Tianma | 19.5 |  |  | IPHONE | 7 | 20
 |  |  |  | IPHONE | 7 Plus | 23.5 |  |  | IPHONE | 7 Plus | 24
 |  |  |  | IPHONE | 8 Prem/Tianma | 23.5 |  |  | IPHONE | 8 | 24
 |  |  |  | IPHONE | 8 Plus | 26 |  |  | IPHONE | 8 Plus | 26
 |  |  |  |  | Please Note:
 |  |  |  |  | *All prices are subject to change. Up to date Price List available upon request
Spreadsheet: 787811d1658062670-formula-for-streaks-nhl-streak-gk
Sheet: Sheet1

Day | Away Team | Home Team | Away Team Goals For | Home Team Goals For | Game Total |  |  | AWAY  RESULT | HOME  RESULT | WINNER | LOSER | Over Under Result |  |  |  |  | Over Under Streak | Site  Streak @ AWAY | Site  Streak @ HOME
Wednesday | Blackhawks | Avalanche | 2 | 4 | 5.5 |  |  |  |  |  |  |  |  |  |  | Avalanche
Friday | Blackhawks | glenn | 3 | 4 | 5.5 |  |  |  |  |  |  |  |  |  |  | Blackhawks
Saturday | Blackhawks | glenn | 2 | 5 | 5.5 |  |  |  |  |  |  |  |  |  |  | [NAME]
Saturday | Blues | Avalanche | 5 | 3 | 5.5
Tuesday | Avalanche | Capitals | 3 | 6 | 5.5 |  |  | W
Tuesday | Islanders | Blackhawks | 4 | 1 | 5.5
Thursday | glenn | Blackhawks | 4 | 5 | 6
Thursday | glenn | Avalanche | 1 | 3 | 6.5
Saturday | Blackhawks | Predators | 3 | 4 | 6
Saturday | Hurricanes | Avalanche | 4 | 7 | 6
Monday | glenn | Blackhawks | 5 | 2 | 6.5
Monday | [NAME] | Avalanche | 3 | 2 | 6.5
Wednesday | Blackhawks | Coyotes | 4 | 3 | 6.5 |  |  | l
Wednesday | Avalanche | Kraken | 2 | 3 | 6.5
Thursday | Blackhawks | Kings | 1 | 4 | 6.5 |  |  | w
Friday | Avalanche | Oilers | 3 | 6 | 6.5
Saturday | Blackhawks | Sharks | 1 | 4 | 6 |  |  | w
Sunday | Avalanche | Jets | 1 | 4 | 6
Monday | Flyers | Blackhawks | 1 | 3 | 6.5
Tuesday | Blues | Avalanche | 3 | 5 | 6.5
Wednesday | Knights | Blackhawks | 3 | 4 | 6.5
Thursday | Predators | Avalanche | 5 | 4 | 6.5
Spreadsheet: 728097d1618307141-how-can-i-pull-a-value-from-a-cell-if-it-finds-a-match-test-spreadsheet
Sheet: Sheet2

Client Number | Search Name | Code | Amount | Date of Withdrawal
1731126 |  | (Formula Here) | 20000 | 2021-04-13 00:00:00
603460 |  | (Formula Here) | 328 | 2021-04-13 00:00:00
4666459 |  | (Formula Here) | 9763 | 2021-04-13 00:00:00
4666460 |  | (Formula Here) | 1208 | 2021-04-13 00:00:00
4667460 |  | (Formula Here) | 97000 | 2021-04-13 00:00:00
Spreadsheet: 50274d1249646653-compare-combine-2-tables-excel-example
Sheet: Product Sales

Date | Product ID | Client
2009-07-01 00:00:00 | 1 | BT
2009-07-02 00:00:00 | 1 | Tesco
2009-07-03 00:00:00 | 2 | Sainsbury
2009-07-04 00:00:00 | 1 | Asda
2009-07-05 00:00:00 | 3 | Tesco
2009-07-06 00:00:00 | 4 | Tesco
2009-07-07 00:00:00 | 1 | BT
2009-07-08 00:00:00 | 3 | Asda
2009-07-09 00:00:00 | 1 | Asda
2009-07-10 00:00:00 | 2 | Sainsbury
2009-07-11 00:00:00 | 4 | Asda
2009-07-12 00:00:00 | 2 | Asda
2009-07-13 00:00:00 | 1 | Tesco
2009-07-14 00:00:00 | 2 | Tesco
2009-07-15 00:00:00 | 3 | Tesco
Spreadsheet: 15ed586e-6d8d-4050-8a80-ebb8eb21e60d
Sheet: Sheet1

จำนวนผู้ป่วยได้รับการตรวจตา จาก ศุภมิตร สุพรรณบุรี | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
จุดตรวจ | ยอดทั้งหมด | จำนวนที่ตรวจ Fundus |  |  | [NAME]
 |  | HT | DM | ทั่วไป | HT | DM | ทั่วไป | ปฏิเสธ
รพ . คลองขลุง | 126 | 15 | 74 | 19 | 1 | 14 | 3
PCU คลองขลุง ถนนงาม | 198 | 80 | 44 | 20 | 28 | 7 | 10
PCU คลองขลุง เทศบาลคลองขลุง | 145 | 36 | 31 | 31 | 26 | 16 | 7
รพสต. วังแขม . บ่อทอง | 162 | 75 | 38 | 9 | 35 | 10 | 3
รพสต โค้งวิไล แม่ลาด | 198 | 107 | 35 | 4 | 46 | 6 | 0
รพสต. หัวถนน โนนทัน หนองผักหนาม | 219 | 95 | 23 | 28 | 50 | 10 | 12
รพสต. วังไทร กระโดนเตี้ย ช้างคับ | 359 | 194 | 52 | 29 | 65 | 17 | 10 | 21
รพสต. วังยาง | 128 | 48 | 0 | 44 | 18 | 7 | 11
รพสต. ท่ามะเขือ | 122 | 61 | 25 | 10 | 13 | 9 | 4
รพสต. [NAME] | 121 | 61 | 26 | 3 | 19 | 11 | 1 | 17
รพสต. ท่าพุทรา | 115 | 89 | 6 | 1 | 22 | 0 | 0
ทั้งหมด | 1893 | 861 | 354 | 198 | 323 | 107 | 61
 |  | ht=1184
 |  | dm=461
 |  | ทั่วไป=259
Spreadsheet: benjamin_rogers__1211__BasePowerModel Final Version-3-19-00
Sheet: IDC

IDC CALCULATIONS
Total Construction & Other Costs (000$):
No. of Construction Months:
Interest During Construction:
 |  | Annual | Daily (360-Day)
 |  |  | Turbine Cost | Construction &
IDC Calculations |  |  | including [NAME] | Other Cost | Principal | Balance | Interest | Cum. Interest
Month | Date | % Drawn | (000$) | (000$) | (000$) | (000$) | (000$) | (000$)
1 | 2000-04-01 00:00:00 |  |  |  |  |  | 0 | 0
 | 2000-05-01 00:00:00 |  | 0
 | 2000-06-01 00:00:00 |  | 0
 | 2000-07-01 00:00:00 |  | 0
 | 2000-08-01 00:00:00 |  | 0
 | 2000-09-01 00:00:00 |  | 0
 | 2000-10-01 00:00:00 |  | 0
 | 2000-11-01 00:00:00 |  | 0
 | 2000-12-01 00:00:00 |  | 0
 | 2001-01-01 00:00:00 |  | 0
 | 2001-02-01 00:00:00 |  | 0
 | 2001-03-01 00:00:00 |  | 0
 | 2001-04-01 00:00:00 |  | 0
 | 2001-05-01 00:00:00 |  | 0
 | 2001-06-01 00:00:00 | 0 | 0
 | 2001-07-01 00:00:00 | 0 | 0
 | 2001-08-01 00:00:00 | 0 | 0
 | 2001-09-01 00:00:00 | 0 | 0
 | 2001-10-01 00:00:00 | 0 | 0
TURBINE DELIVERY SCHEDULE
 |  |  |  |  | *Rough Estimate by [NAME]. Please double-check for deal specific
 |  |  |  |  |  | Number of Turbines | 1 | 2 | 3 | 4 | 5 | 6
Unit | Turbines | Delivery | LD'S |  | Month | No. of Months | 5.5 | 6 | 6.5 | 7 | 7.5 | 8
Number | Delivered | Schedule | Enforced On |  | 1 |  | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17
1-3 | 3 | 2000-07-30 00:00:00 | 2000-10-30 00:00:00 |  | 2 |  | 0.16 | 0.16 | 0.16 | 0.12 | 0.12 | 0.12
4-6 | 3 | 2000-08-30 00:00:00 | 2000-10-30 00:00:00 |  | 3 |  | 0.16 | 0.16 | 0.13 | 0.12 | 0.12 | 0.12
7-8 | 2 | 2000-09-30 00:00:00 | 2000-10-30 00:00:00 |  | 4 |  | 0.16 | 0.16 | 0.16 | 0.14 | 0.14 | 0.14
9-11 | 3 | 2000-10-30 00:00:00 | 2000-10-30 00:00:00 |  | 5 |  | 0.17 | 0.17 | 0.16 | 0.18 | 0.13 | 0.13
12-13 | 2 | 2000-11-30 00:00:00 | 2000-11-30 00:00:00 |  | 6 |  | 0.18 | 0.18 | 0.12 | 0.12 | 0.12 | 0.12
14-15 | 2 | 2000-12-30 00:00:00 | 2000-12-30 00:00:00 |  | 7 |  | 0 | 0 | 0.1 | 0.15 | 0.1 | 0.1
16-18 | 3 | 2000-01-30 00:00:00 | 2000-01-30 00:00:00 |  | 8 |  | 0 | 0 | 0 | 0 | 0.1 | 0.1
19-20 | 2 | 2001-02-28 00:00:00 | 2001-02-28 00:00:00 |  | 9 |  | 0 | 0 | 0 | 0 | 0 | 0
21-22 | 2 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 |  | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
23-24 | 2 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 |  | 11 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 12 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 13 |  | 0 | 0 | 0 | 0 | 0 | 0
Summary (000$): |  |  |  |  | 14 |  | 0 | 0 | 0 | 0 | 0 | 0
Basis Per Turbine |  |  | 13950 |  | 15 |  | 0 | 0 | 0 | 0 | 0 | 0
Carry Cost Per Turbine |  |  | 289.6162739983738 |  | Sum
WestLB Structuring, Restructuring & Legal Fees |  |  | 20.83333333333331
Total Price
Spreadsheet: 116492d1311866505-excel-2007-count-unique-values-and-jb-sample-unique-value
Sheet: Sheet1

Invoice # | # of Cases
2036309 | 1 |  | I want to be able to create a formula that puts an X or a 1 in the B column
2036309 |  |  | at the first instance of a unique value.
2036309 |  |  | I've put a 1 in the B Column on a couple invoces so you get the idea of
2036309 |  |  | what I'm looking for
2036310 | 1
2036310
2036310
2036310
2036311 | 1
2036311
2036311
2036311
2040146 | 1
2040146
2040146
2040146
2043738
2043738
2043738
2043738
2043739
2043739
2043739
2043739
2043740
2043740
2043740
2043741
2043741
2043741
2043741
2075488
2075488
2075488
2075488
2075489
2075489
2075489
2075490
2075490
2075490
2075490
2075491
2075491
2075491
2075491
2075492
2075492
2075492
2075492
2080380
2080380
2080380
2080380
2080381
2080381
2080381
2080381
2080382
2080382
2080382
2080382
2080383
2080383
2080383
2080383
2080384
2080384
2084595
2084595
2084595
2084595
2084596
2084596
2084596
2084596
2084597
2084597
2084597