tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110032d1306837153-vlookup-error-sold-items
Sheet: Jan.

[NAME] For Jan'11
Item No | Item name | Unit name | Sold Quantity | Amount | Cost Price
1101 | AL - Dubai
2991001001036 | WV -Garnet Stone | Unit | 4 | 600 | 112.5
2991001001074 | WV - Glamorous | Unit | 1 | 150 | 112.5
2991001001081 | WV - Gondola Rose | Unit | 1 | 150 | 112.5
2991001001210 | Wv- Shrewd | Unit | 1 | 150 | 112.5
2991001001272 | WV - Ogle | Unit | 1 | 150 | 112.5
2991001001289 | WV - Clamour | Unit | 1 | 150 | 112.5
2991001001296 | WV -Lily [NAME] | Unit | 5 | 750 | 112.5
1102 | BC - Dubai |  |  |  | #N/A
2991001001425 | Red & Black -  Pure Devotion | Unit | 7 | 1750 | 187.5
2991001001432 | Red & Black - Destiny | Unit | 7 | 1750 | 187.5
2992008040639 | ( EF ) Azzaro Az 4286 C1 | Unit | 1 | 751 | #N/A
6291023110041 | Dehn [NAME] =130.00 AED | Gm | 9 | 1170 | #N/A
6291023110126 | Musk Fazza for Body  -1 Gm =7.50 AED | Tola | 4.5 | 405 | 67.5
6291023110188 | Dehn Oud [NAME] = 80..00 AED | Gm | 9 | 720 | #N/A
6291023118023 | Mandos 300 | Unit | 4 | 1200 | 225
6291023118030 | Mandos 400 | Unit | 2 | 800 | 300
6291023118047 | Mandos 500 | Unit | 2 | 1000 | 375
6291023118061 | Mandos 700 | Unit | 2 | 1400 | 525
6291023118078 | Mandos 800 | Unit | 1 | 800 | 600
1103 | Alain |  |  |  | #N/A
6291023120064 | Lotion Sheikha | Unit | 3 | 150 | #N/A
6291023120088 | Lotion Love Story | Unit | 1 | 50 | #N/A
6291023120101 | [NAME] | Unit | 1 | 50 | #N/A
6291023120224 | [NAME] | Unit | 1 | 40 | #N/A
6291023120231 | [NAME] battash | Unit | 3 | 120 | #N/A
6291023130018 | Dukhon Khass | Unit | 68 | 6800 | #N/A
6291023130056 | Dukhon Sheikh [NAME] | Unit | 34 | 4590 | #N/A
6291023130063 | Dukhon Sheikha | Unit | 6 | 900 | #N/A
6291023130070 | Promotion [NAME] | Unit | 1 | 135 | 101.25
6291023130087 | Dukhon Fazza | Unit | 62 | 6200 | #N/A
1105 | Dubai
6291023150207 | Air Freshener Siraa Ala Alrrimal | Unit | 4 | 160 | 30
6291023150276 | [NAME] Al Ajial | Unit | 3 | 120 | 30
6291023160046 | Perfume- [NAME] | Unit | 1 | 180 | 135
6291023160107 | Perfume- Sheikh [NAME] | Unit | 9 | 630 | 52.5
6291023160183 | Perfume- [NAME] | Unit | 4 | 320 | 60
6291023160251 | Perfume- New Fazza100 ml | Unit | 4 | 320 | 60
6291023160268 | Perfume- Bint Al Khaleej | Unit | 1 | 85 | 63.75
Spreadsheet: 146885d1332403039-excel-2007-automating-stock-portfolio-workbook-portfolio-example
Sheet: 123_Open

 | Account no. | 123
 | STOCK | ABC
 | Trade |  |  |  |  | Total | Total |  | Euro:1USD | Euro:1USD
 | Date | Account no. | Stock | No. of shares | Price | Amount | Amount |  | Transaction date | Current
 |  |  |  |  | Euro | Euro | USD
 | 2010-10-14 00:00:00 | 123 | ABC | 1292 | 3.54 | 4582.83 |  |  | 0.67
 | 2010-10-15 00:00:00 | 123 | ABC | 19035 | 3.931 | 74976.24 |  |  | 0.69
 | 2011-12-20 00:00:00 | 123 | ABC | -10000 | 4 | -40000 |  |  | 0.695
 | Total: | ABC
 | STOCK | DEF
 | Trade |  |  |  |  | Total | Total |  | Euro:1USD | Euro:1USD
 | Date | Account no. | Stock | No. of shares | Price | Amount | Amount |  | Transaction date | Current
 |  |  |  |  | CAD | CAD | USD
 | 2011-05-12 00:00:00 | 123 | DEF | 30000 | 13.4477 | 404237.86 |  |  | 0.95
 | 2011-07-14 00:00:00 | 123 | DEF | 80000 | 9.5767 | 767668.27 |  |  | 0.96
 | 2012-01-07 00:00:00 | 123 | DEF | -20000 | 10.2 | -204000 |  |  | 0.99
 | Total: | DEF
Spreadsheet: 006541e7-2cf1-44a0-8327-bd4111e2e131
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
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2011-02-01 00:00:00 | 392 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 88fbe6e3-8d8a-4c0c-a335-c4a54bc30300
Sheet: Sheet1

Release: Quarterly Starts and Completions by Purpose and Design | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=228
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-17 11:35 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Quarterly Starts and Completions by Purpose and Design | 2011-05-17 00:00:00 | Current
Link:
http://www.census.gov/const/www/newresconstindex_excel.html | 2011-05-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2011-05-17 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:
2011-05-17 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-16 00:00:00
2012-08-16 00:00:00
2012-11-20 00:00:00
2013-02-20 00:00:00
2013-05-16 00:00:00
2013-08-16 00:00:00
2013-12-18 00:00:00
2014-02-19 00:00:00
Spreadsheet: 860087d1708320839-repetitive-result-case-excel
Sheet: Hasil

A | B | C
1 |  | YPS21DM12001
1 | I MADE SUADNYANA | YPS21DM12001
2 | ARIYADI | YPS21DM12002
2 | ARIYADI | YPS21DM12002
2 | ARIYADI | YPS21DM12002
2 | ARIYADI | YPS21DM12002
2 | ARIYADI | YPS21DM12002
3 | I NYOMAN ARTA | YPS21DM12003
3 | I NYOMAN ARTA | YPS21DM12003
3 | I NYOMAN ARTA | YPS21DM12003
Spreadsheet: 165308d1341154309-working-out-stock-levels-and-circular-reference-issues-stock-p-and-l
Sheet: Sales

Invoice No | Date | Product | Qty | HK Stock |  | HK Balance | [NAME] |  | Euro Balance | Euro Stock Ordered | [NAME] | Total Stock | Item Price |  | Sale Price |  | Postage Price | Member ID | Profit £ | Mark Up £
0001 |  | Product A | 2
0002 |  | Product A | 0
0003
0004
Spreadsheet: 3792b3a6-ff8e-4bf2-95ea-9c9746224735
Sheet: Sheet1

Unnamed: 0 | BALLOTS CAST | Unnamed: 2 | Unnamed: 3 | Names on Checklist | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Election Day Registrations | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Regular | Absentee | Total | Republican | Democratic | Undeclared |  | Rep. | Dem. | Und. | Total | Grand T
1998-11-03 00:00:00
Belknap County | 14215 | 928 | 15143 | 14914 | 7605 | 11821 |  | 152 | 102 | 376 | 630 | 34970
Carroll County | 12942 | 1046 | 13988 | 13381 | 5045 | 12306 |  | 135 | 91 | 292 | 518 | 31250
Cheshire County | 19573 | 820 | 20393 | 14429 | 12697 | 16809 |  | 209 | 261 | 648 | 1118 | 45053
Coos County | 9266 | 539 | 9805 | 6540 | 6438 | 6988 |  | 51 | 42 | 187 | 280 | 20246
Grafton County | 20976 | 1405 | 22381 | 19022 | 11802 | 19720 |  | 193 | 224 | 589 | 1007 | 51551
Hillsborough County | 91793 | 4288 | 96081 | 77594 | 62037 | 65286 |  | 1429 | 1208 | 2611 | 5248 | 210165
Merrimack County | 41177 | 1959 | 43136 | 30495 | 21417 | 27451 |  | 624 | 616 | 1494 | 2805 | 82168
Rockingham County | 66360 | 3370 | 69730 | 63332 | 45320 | 70400 |  | 693 | 534 | 1473 | 2700 | 181752
Strafford County | 24953 | 1132 | 26085 | 19922 | 20847 | 23268 |  | 282 | 327 | 902 | 1511 | 65548
Sullivan County | 11510 | 698 | 12208 | 8638 | 6882 | 8750 |  | 73 | 75 | 272 | 420 | 24690
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
Totals |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 312765 | 16185 | 328950 | 268267 | 200090 | 262799 |  | 3841 | 3480 | 8844 | 16237 | 747393
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 130767 | 129723
2 | 107078 | 106139
3 | 110525 | 109923
4 | 122773 | 127184
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
2000-07-31 00:00:00 |  |  | -10574
2000-08-04 00:00:00
Spreadsheet: f118adc0-45ef-47cb-8cc7-0d3fd6e52992
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
[NAME] | Test | [NAME] | Fetomaternal Bleed, New York | Fetomaternal Bleed, New York | [NAME] Fetal Cell Detection by Flow Cytometry RhD: Standard AABB | EDTA (lavender-top) tube: EDTA |  |  |  |  | [NAME] must arrive within 72 hours (preferably 24 hours) of draw.   The New York State Department of Health recommends samples be tested within 30 hours of draw.   Container/Tube: Lavender top (EDTA) [NAME]: Full tube Collection Instructions:  1. Do not centrifuge or aliquot. 2. Invert several times to mix blood. 3. Send specimen in original tube. | 1 mL | Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | < or =0.75 mL of fetal RBCs in normal adults | Monday through Sunday; Varies | Same day/1 day | 1 day |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 72 hours
[NAME] | Result | 28204 | Mother's Rh | Mother's Rh | Alphanumeric |  |  |  |  | Rh |  |  |  |  |  |  |  |  |  | 10331-7
[NAME] | Result | 28202 | Fetal-Maternal Bleed | Fetal-Maternal Bleed | Unknown |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 55730-6
[NAME] | Result | 28203 | Rh Immune Globulin | Rh Immune Globulin | Unknown |  |  |  |  | dose |  |  |  |  |  |  |  |  |  | 55731-4
[NAME] | Result | 28246 | Remarks | Remarks | Unknown |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Billing Component | [NAME] |  | Each Additl [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88185
[NAME] | Billing Component | [NAME] |  | Flow Cyto, Cell Surface |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88184
Spreadsheet: sally_beck__35439__IT ReOrg
Sheet: ENA

 | ENA
 | GAS
 |  |  |  |  | $Savings |  |  | Impacts
 | Total Team | HC | Dollars | %c [NAME] | $[NAME] | $Exp
 | Contractors | 1
 | Consultants | 10
 | Employees | 54
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  | Basic break / Fix
 | Consultants | 0
 | Employees | 10
 | Total
 | Approximate Savings |  |  | 0.8
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  | Only mtce of existing software continues
 | Consultants | 0 |  |  |  |  |  | Small Enhancements
 | Employees | 21 |  |  |  |  |  | Both Consolidations halted….
 | Total
 | Approximate Savings |  |  | 0.8
 | Scenario 3
 | Contractors | 0 |  |  |  |  |  | Mtce carries on
 | Consultants | 0 |  |  |  |  |  | Consolidate Gas System - Physical Continues
 | Employees | 33 |  |  |  |  |  | Consolidate Gas System - Financial delayed
 | Total
 | Approximate Savings |  |  | 0.5
 | POWER
 | Total Team | HC | Dollars
 | Contractors | 4
 | Consultants | 6
 | Employees | 55
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  | Break fix
 | Consultants | 0
 | Employees | 15
 | Total
 | Approximate Savings |  |  | 0.8
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  | No prep for markets
 | Consultants | 0 |  |  |  |  |  | Slow work on scalability.
 | Employees | 30
 | Total
 | Savings |  |  | 0.8
 | Scenario 3
 | Contractors | 0
 | Consultants | 3 |  |  |  |  |  | Full activity for entering up-coming markets
 | Employees | 55
 | Total
 | Savings |  |  | 0.5
 | Total ENA
 | Total Team | Headcount | Dollars
 | Contractors
 | Consultants
 | Employees
 | Total
 | Scenario 1
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings |  |  | 0.8
 | Scenario 2
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings |  |  | 0.8
 | Scenario 3
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings |  |  | 0.5
Spreadsheet: 82969d1282952483-populate-template-from-a-source-file-salu-model
Sheet: Model

 | Allocation based on AUM as of (Enter ' before the date) |  |  |  | yo | hi
 |  |  |  |  |  |  |  | FE Code |  |  | Invoice Has (Select) | GST & QST (no PST) |  | OEM
 |  |  |  |  |  |  |  | GL Account for Expensed Funds |  |  | GST Rate | 0.05
 |  |  |  |  |  |  |  | Invoice ID |  |  | QST Rate | 0.075
 | Note: PST is included in the line amount, HST is part of the GST amount |  |  |  |  |  |  | Invoice Total | 1500 |  | PST Rate | 0.08
 | Type | Fund Name | IM Code | Fund Series # | Series | # of Accounts |  |  |  |  | Fill in OEM
 |  |  |  |  |  | 1107.5
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Totals | 0 | 1107.5 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: c9809ba8-4b7b-4381-97d8-87af5944456d
Sheet: Geographic

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) | THIRD QUARTER |  |  |  |  |  |  |  |  |  | NINE MONTHS
 |  |  |  |  | Percent Change |  |  |  |  |  |  |  |  |  | Percent Change
 | 2011 |  | 2010 |  | Total |  | Operations |  | Currency |  | 2011 |  | 2010 |  | Total |  | Operations |  | Currency
Sales to customers by
geographic area
U.S. | 6868 |  | 7131 |  | -3.7 | % | -3.7 |  | 0 |  | 21923 |  | 22221 |  | -1.3 | % | -1.3 |  | 0
Europe | 4124 |  | 3629 |  | 13.6 |  | 4.9 |  | 8.7 |  | 12850 |  | 11563 |  | 11.1 |  | 4 |  | 7.1
Western Hemisphere excluding U.S. | 1751 |  | 1424 |  | 23 |  | 17.1 |  | 5.9 |  | 4730 |  | 4079 |  | 16 |  | 10.1 |  | 5.9
Asia-Pacific, Africa | 3262 |  | 2798 |  | 16.6 |  | 8.100000000000001 |  | 8.5 |  | 9272 |  | 8080 |  | 14.8 |  | 6.300000000000001 |  | 8.5
International | 9137 |  | 7851 |  | 16.4 |  | 8.299999999999999 |  | 8.1 |  | 26852 |  | 23722 |  | 13.2 |  | 5.799999999999999 |  | 7.4
Worldwide | 16005 |  | 14982 |  | 6.8 | % | 2.6 |  | 4.2 |  | 48775 |  | 45943 |  | 6.2 | % | 2.273464897492068 |  | 3.926535102507932
Spreadsheet: 863111d1710673662-formula-to-realign-data-example1
Sheet: Sheet1

From this:
Asset | Asset |  | Design | Design | [NAME] | [NAME]
[NAME] | Prop |  | [NAME] | Prop | [NAME] | Prop
[NAME] | [NAME] |  | 2 | 2 | 5 | 5
[NAME] | [NAME] |  | 1 | 2 | 3 | 0
Jeremy |  |  | 3 |  | 6
To This:
Asset | Type | Design | [NAME] |  |  | Type | Design | [NAME]
[NAME] | [NAME] | 2 | 5 |  | [NAME] | [NAME] | 2 | 5
[NAME] | [NAME] | 1 | 3 |  | [NAME] | [NAME] | 1 | 3
Jeremy | [NAME] | 3 | 6 |  | Jeremy | [NAME] | 3 | 6
[NAME] | Prop | 2 | 5 |  | [NAME] | Prop | 2 | 5
[NAME] | Prop | 2 | 0 |  | [NAME] | Prop | 2 | 0
Spreadsheet: 166301d1341525294-clunky-formula-needs-to-be-cleaned-up-excel-worksheet-2
Sheet: Sheet2

Month | Cases - Name | Projected visits | Frequency | Results | Last Name | Actual visits
2012-04-01 00:00:00 | Adams | 2012-03-06 00:00:00 | Monthly | Missed visit | Agard | 2012-03-06 00:00:00
2012-04-01 00:00:00 | Agard | 2012-03-06 00:00:00 | Quarterly | Met as Projected | [NAME] | 2012-11-01 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-04-04 00:00:00 | PRN | Met as Projected | [NAME] | 2012-03-06 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-03-06 00:00:00 | Monthly | Missed visit | [NAME] | 2012-04-24 00:00:00
2012-04-01 00:00:00 | Canty | 2012-04-25 00:00:00 | Monthly | Met as Projected | Ayers | 2011-12-12 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-03-14 00:00:00 | Quarterly | Verify Dates | Byron | 2012-03-12 00:00:00
 |  |  |  |  | Canty | 2012-03-15 00:00:00
 |  |  |  |  | Canty | 2012-04-25 00:00:00
 |  |  |  |  | Canty | 2012-04-26 00:00:00
 |  |  |  |  | Casteel | 2012-04-01 00:00:00
 |  |  |  |  | [NAME] | 2012-03-12 00:00:00
 |  |  |  |  | Garrett | 2012-03-12 00:00:00
 |  |  |  |  | Jones | 2012-04-02 00:00:00
 |  |  |  |  | Renolds | 2012-03-29 00:00:00
Spreadsheet: 766220d1643806971-using-a-data-table-to-replace-time-values-with-points-values-hav-time-sheets-demo
Sheet: Demo

2022-01-01 00:00:00 | 1 |  | 2 |  | 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
 | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins
Grinders - Angle, 100 - 180 mm |  |  |  |  |  |  | 1 | 15 | 1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 30 | 2 |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 30
Grinders - Angle, 220 - 300 mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 15
Grinders - Angle, Flapper discs 125 & 100 mm | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 1 | 30
Needle scalers - AV | 1 | 30 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Nibblers / beveller |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ELV (400pts [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 |  | 224 |  | 195 |  | 288
Spreadsheet: mike_carson__27567__KOCH01042002
Sheet: Sheet1

 | [NAME] for power delivered 1/4/2002
 | On-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee | COST | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 100 | 25.75 |  | 1 |  |  |  |  | 26.03
 | TVA | -100 | 29.5 |  | 1 |  |  |  |  | 31
 | Cinergy | -1050 | 27.85 |  | 1 |  |  |  |  | 30.96
 | Comed | -50 | 25.8 |  | 1 |  |  |  |  | 34.75
 | Off-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee |  | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 17 |  | 1 |  |  |  |  | 18.25
 | Comed | 0 |  |  | 1
 | LD Charges |  |  |  |  |  | 0
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
 |  |  |  |  |  |  | 2000-01-04 00:00:00 |  | Existing |  | Gain for 1/04/2002
Spreadsheet: 215650d1361444211-search-a-list-of-names-and-automatically-return-any-names-not-already-included-in-table-excel-forum-example
Sheet: Sheet1

BREAKDOWN OF SALES DAY BOOK - Customer A
Product A
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs |  |  | [NAME] | [NAME] | Fred | [NAME] | Hayley | [NAME] | [NAME]
2013-01-02 00:00:00 | 332352 | [NAME] | 100
2013-01-02 00:00:00 | 332353 | [NAME] | 100
2013-01-03 00:00:00 | 332364 | Hayley | 300
2013-01-03 00:00:00 | 332365 | [NAME] | 200
 |  | Total |  |  |  |  | 3.35
Product B
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs |  | NEED TO INCLUDE SOME KIND OF FORUMLA IN THE TABLE TO LOOKUP THE ENTIRE C:C COLUMN
2013-01-02 00:00:00 | 332352 | [NAME] | 250 |  |  |  |  |  |  |  |  |  | FOR ANY NEW CUSTOMER NAMES THAT ARENT IN THE TABLE AND INSERT THIS INTO THE ABOVE TABLE
2013-01-02 00:00:00 | 332353 | [NAME] | 100
2013-01-03 00:00:00 | 332364 | [NAME] | 150
2013-01-03 00:00:00 | 332365 | [NAME] | 50
 |  | Total |  |  |  |  | 2.39
Product C
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs
2013-01-02 00:00:00 | 332353 | [NAME] | 110
2013-01-03 00:00:00 | 332364 | [NAME] | 125
2013-01-03 00:00:00 | 332365 | [NAME] | 150
 |  | Total |  |  |  |  | 2.52
Spreadsheet: 857522d1706529229-i-need-to-identify-that-all-the-diags-listed-to-the-left-are-captured-in-the-new-diags-identifyduplicateswithcdeandhghlght-1-
Sheet: Sheet9

[NAME] | Diag2 | Diag3 | Diag4 | Diag5 | Diag6 | Diag7 | Diag8 | Diag9 | Diag10 | Diag11 | Diag12 | Is this possible? | Duplicate Yes or No
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False
I129 | N182 | E559 | D509 | D509 |  |  |  |  |  |  |  | D509
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False
J45909 | J449 | I10 | M160 | R05 | R062 |  |  |  |  |  |  | False
E039 | D7589 | E870 | E809 | E559 |  |  |  |  |  |  |  | False
C679 | Z5111 | E860 | Z5111 |  |  |  |  |  |  |  |  | Z5111