tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6f647280-6f11-4fec-b65b-00e680cd6cda
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
MINT | Test | MINT | Molecular Interpretation | Molecular Interpretation | This is a consultative interpretation for the Hereditary Erythrocytosis Mutations test. |  |  |  |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. | Monday through Friday; Varies | 10 days | 25 days | 1 | 81479 |  |  |  |  | Rochester
MINT | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 30 days
MINT | Result | 34648 | Molecular Interpretation | Molecular Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MINT | Result | 35000 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 868358d1715092473-unique-or-maybe-not-lookup-and-sum-book1
Sheet: Sheet3 (2)

Part# | Description | 2023-01 Net-Sales | 2023-02 Net-Sales | 2023-03 Net-Sales | 2023-04 Net-Sales | 2023-05 Net-Sales | 2023-06 Net-Sales | 2023-07 Net-Sales | 2023-08 Net-Sales | 2023-09 Net-Sales | 2023-10 Net-Sales | 2023-11 Net-Sales | 2023-12 Net-Sales | total
unit1 |  | 0 | 0 | 0 | 0 | 116.19 | 0 | 0 | -47.62 | 0 | 0 | 0 | 0
unit1a |  | 0 | 0 | 0 | 0 | 0 | 752.71 | 0 | -24.99 | 0 | -16.65 | 0 | 0
unit2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 194.11 | 0
unit2b |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 195.87 | 0
unit11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 201.07 | 0
unit1pn |  | 44.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.97 | 0 | 0
unit110 |  |  |  |  | 82.52 |  |  |  |  | 3.45
unit220 |  |  | 2.6 |  |  | 1.25
unit11x |  | 23.78 |  |  |  |  |  |  |  |  | 1.01
unit1
unit11
unit2
unit220
Spreadsheet: 129000d1321393055-how-to-extract-info-based-on-any-defined-category-creamecake-example
Sheet: Sheet1

 |  | Opening Balance |  | 1000
Date | Name-of-Payee | Payment-Details | Received | Payment | Balance
2011-01-11 00:00:00 | Cremo | Petrol |  | 100
2011-01-11 00:00:00 | Cremo | Mobile [NAME] |  | 300
2011-02-11 00:00:00 |  | Sale of Goods | 150
2011-02-11 00:00:00 | Cremo | [NAME] |  | 200
2011-03-11 00:00:00 |  | Sale of Goods | 100
2011-04-11 00:00:00 | Cremo | Petrol |  | 100
2011-05-11 00:00:00 | Cremo | Internet Bill |  | 200
2011-06-11 00:00:00 |  | Sale of Goods | 500
2011-07-11 00:00:00 | Cremo | Raw Materials |  | 350
2011-08-11 00:00:00 |  | Sale of Goods | 200
2011-09-11 00:00:00 | Cremo | Raw Materials |  | 200
2011-10-11 00:00:00 | Cremo | Petrol |  | 150
 | Petrol
 | Raw Materials
 | Communication
 | Total Sales
Spreadsheet: 52881d1252690010-first-in-first-out-fifo-accounting-for-equity-trades-book-cost-fifo-test
Sheet: Sheet4

 | Values
Row Labels | Sum of TradeQuantity | Sum of BaseCost
AKS | -112875 | -2347605.179
APA | 22575 | 1979573.77
APC | 22575 | 1236113.09
CAM | -54180 | -1910960.926
CAT | -45150 | -2035328.019
CCK | 63210 | 1599420.606
CLF | -117390 | -3149798.46
COP | -49665 | -2200837.316
CP | -49665 | -2394833.22
DE | -135450 | -5832750.393999999
DHR | 54180 | 3344661.87
DO | -45150 | -4077921.061
DOV | -45150 | -1497782.363
DVN | -45150 | -2804593.795
ECA | -22575 | -1202547.45
EMR | -45150 | -1597580.834
FCX | -22575 | -1478348.716
FLR | -49665 | -2719966.15
FTI | -31605 | -1458245.657
G24182100 | 27090 | 929426.29
GE | 632100 | 8715258.405000001
HAL | 90300 | 2146957.199
HLX | -90300 | -1143238.95
ITW | 45150 | 1908542.885
JEC | 45150 | 1835155.215
MDR | 22575 | 560028.865
MT | -45150 | -1647683.437
NBR | 90300 | 1577526.654
NSC | 31605 | 1471000.55
RIG | 22575 | 1735426.637
RRC | -54180 | -2632655.11
SD | 117390 | 1200015.17
SFY | 27090 | 488454.368
SII | -90300 | -2435776.62
SLB | 45150 | 2523705.68
SPY | -4515 | -468396.635
STLD | 270899 | 4503221.390000001
SWN | 90300 | 3474196.763
TEX | 81270 | 1256909.56
URS | 22575 | 964587.672
UTX | 22575 | 1295039.738
X | 67725 | 2911722.521
Grand Total | 758519 | 2620094.606000003
Spreadsheet: 860662d1708672106-xmatch-to-reterive-right-date-depending-on-formula-given-book1
Sheet: Sheet1

If B3 equals No | [NAME] Currently |  |  | Public Holiday |  |  |  |  | What I Have |  | School Holidays |  |  |  | What I Want Also |  |  | School Holidays
Alt' day be taken In Leiu of a Public Holiday | NO |  |  | Jurisdiction | Date | Holiday Name | Day |  | Jurisdiction | State | Date | Day | Date for Field |  | Jurisdiction | State | Date | Day | Date for Field
State Public Holiday being taken In Lieu of |  |  |  | SA | 2024-01-01 00:00:00 | Holiday 1 | Monday |  | SA | SA | 2024-01-01 00:00:00 | Monday |  |  | SA | SA | 2024-01-01 00:00:00 | Monday | 2024-01-01 00:00:00
 |  |  |  | SA | 2024-01-26 00:00:00 | Holiday 2 | Friday |  | SA | SA | 2024-01-02 00:00:00 | Tuesday | 2024-01-02 00:00:00 |  | SA | SA | 2024-01-02 00:00:00 | Tuesday | 2024-01-02 00:00:00
 |  |  |  | SA | 2024-03-11 00:00:00 | Holiday 3 | Monday |  | SA | SA | 2024-01-03 00:00:00 | Wednesday | 2024-01-03 00:00:00 |  | SA | SA | 2024-01-03 00:00:00 | Wednesday
Alternative Public Holiday Dates |  |  |  | SA | 2024-03-29 00:00:00 | Holiday 4 | Friday |  | SA | SA | 2024-01-04 00:00:00 | Thursday | 2024-01-04 00:00:00 |  | SA | SA | 2024-01-04 00:00:00 | Thursday | 2024-01-04 00:00:00
Date | Holiday Name |  |  | SA | 2024-03-30 00:00:00 | Holiday 5 | Saturday |  | SA | SA | 2024-01-05 00:00:00 | Friday | 2024-01-05 00:00:00 |  | SA | SA | 2024-01-05 00:00:00 | Friday | 2024-01-05 00:00:00
 |  |  |  | SA | 2024-03-31 00:00:00 | Holiday 6 | Sunday |  | SA | SA | 2024-01-06 00:00:00 | Saturday | 2024-01-06 00:00:00 |  | SA | SA | 2024-01-06 00:00:00 | Saturday | 2024-01-06 00:00:00
 |  |  |  | SA | 2024-04-01 00:00:00 | Holiday 7 | Monday |  | SA | SA | 2024-01-07 00:00:00 | Sunday | 2024-01-07 00:00:00 |  | SA | SA | 2024-01-07 00:00:00 | Sunday | 2024-01-07 00:00:00
 |  |  |  | SA | 2024-04-25 00:00:00 | Holiday 8 | Thursday |  | SA | SA | 2024-01-08 00:00:00 | Monday | 2024-01-08 00:00:00 |  | SA | SA | 2024-01-08 00:00:00 | Monday | 2024-01-08 00:00:00
 |  |  |  | SA | 2024-06-10 00:00:00 | Holiday 9 | Monday |  | SA | SA | 2024-01-09 00:00:00 | Tuesday | 2024-01-09 00:00:00 |  | SA | SA | 2024-01-09 00:00:00 | Tuesday | 2024-01-09 00:00:00
 |  |  |  | SA | 2024-10-07 00:00:00 | Holiday 10 | Monday |  | SA | SA | 2024-01-10 00:00:00 | Wednesday | 2024-01-10 00:00:00 |  | SA | SA | 2024-01-10 00:00:00 | Wednesday | 2024-01-10 00:00:00
 |  |  |  | SA | 2024-12-25 00:00:00 | Holiday 11 | Wednesday |  | SA | SA | 2024-01-11 00:00:00 | Thursday | 2024-01-11 00:00:00 |  | SA | SA | 2024-01-11 00:00:00 | Thursday | 2024-01-11 00:00:00
 |  |  |  | SA | 2024-12-26 00:00:00 | Holiday 12 | Thursday |  | SA | SA | 2024-01-12 00:00:00 | Friday | 2024-01-12 00:00:00 |  | SA | SA | 2024-01-12 00:00:00 | Friday | 2024-01-12 00:00:00
Spreadsheet: 844642d1696396814-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-master-copy-aligw
Sheet: 1

Name | lbs | oz | Oz (total) | Points
 | 111
 | 11
 | 1
 | 2 | 6
 | 22
 | 4 | 5
 | 5
 | 6
 | 7
 | 8 | 4
 | 9 | 3
 | 0 | 0
 | dnf
Spreadsheet: 723355d1615648307-conditional-formatting-and-color-cells-with-formula-testnameamount
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 | nl |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl |  |  |  |  |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | ik | ics |  |  |  |  |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | nl | ics
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 |  | ics |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 | 20404799 | 17NLD108 | Loheide | 00:00:00 | darp | 2 | rene | rene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | customer | amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | willem
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hilco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ast
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rene
Spreadsheet: 96061d1295533892-plot-long-lat-on-to-a-map-book123
Sheet: Sheet1

NAME | LONG | LAT
A | 105.09155 | 14.14964
B | 105.2034 | 14.3309
C | 103.26957 | 14.30383
D | 104.77485 | 14.17546
E | 104.65813 | 14.4014
F | 103.41956 | 13.89996
G | 102.79816 | 12.51196
H | 103.10125 | 13.01242
Spreadsheet: 38360d1236526504-dynamic-formula-demand-calender
Sheet: Month

 | MONTHLY SUMMARY
 | [NAME]
 | 196 | ROOMS
 | 31 | DAYS
 |  | LAST YEAR | BOB | FORECAST | BUDGET | [NAME] YOY | BOB v FOR | FOR v BUD | [NAME]
 | ROOMS SOLD
 | OCC%
 | ADR
 | REVENUE
 | REVPAR
Spreadsheet: mary_fischer__25634__31Q
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 12c29439-4792-4692-b64e-6060adafcaf6
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
AGXT | Test | AGXT | Alanine:Glyoxylate [NAME] (AGXT) Mutation Analysis (G170R), Blood | AGXT Mutation Analysis (G170R) | Direct Mutation Analysis by Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.  	 Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 2 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 | An interpretive report will be provided. | Tuesday; 2 p.m. | 5 days | 10 days | 1 | 81479 |  |  |  |  | Rochester
AGXT | [NAME] | VARIES | Varies |  |  |  | Ambient
AGXT | Result | 22646 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
AGXT | Result | 22647 | [NAME] | [NAME] | Alphanumeric
AGXT | Result | 22648 | Source | Source | Alphanumeric
AGXT | Result | 22649 | Order Date | Order Date | Alphanumeric
AGXT | Result | 22650 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
AGXT | Result | 22651 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGXT | Result | 22652 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGXT | Result | 22653 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
AGXT | Result | 22654 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGXT | Result | 22655 | Reviewed By: | Reviewed By: | Alphanumeric
AGXT | Result | 22656 | Release Date | Release Date | Alphanumeric
Spreadsheet: 121515d1316105167-finding-the-lowest-value-based-on-multiple-text-criteria-book2
Sheet: Imported Data 2

Data | ID
10 | xxxx P01 xx Name1 xxx 2000 xxx
12 | xx [NAME] xxxxx 2002 xx
3 | xxx P02 xx Name2 xxxx 2000 xxx
27 | [NAME] xxx Name1 xx 2001 xxxx
51 | xxxx [NAME] xx 2002 xxx
9 | x P04 xx Name1 xxx 2001
16 | xxx P04 xxx Name2 2000 xxx
24 | P02 xxxx [NAME] xxx 2000 x
18 | xxx P03 xx Name1 xxx 2000 xx
5 | [NAME] xxx Name2 xxx 2000 xx
33 | x P01 xxx Name1 xx 2002 xx
1 | xxx P02 xxx Name1 xx 2000 x
Spreadsheet: 01089cf2-2929-4790-b351-9e92f2a86ba5
Sheet: Payroll Exp

 | Payroll Expenditure Test
 | School District:
 | Reviewer:
 | Date:
 | Purpose:  To detemine if the subgrantee,
 |  | - properly documented the payroll expenditure via Time and Effort Log or Semi-Annual Certification
 |  | - properly accounted for the payroll expense. This test will look to ensure the LEA properly coded the
 |  | expense to the correct function and object.
 | Instructions:  The reviewer shall review all employees funded with Part B funds to ensure the federal funds were expended for an appropriate purpose based upon the fedral guidelines.
 | Review the district's answer to question #5 on the NS-3 Consultation Guide.  If the services are provided, ensure the teacher providing services to non-public students has the proper certifications.
 | Utilize the Districts ACCRPT and FER for this tab
 | Review certificate for all teachers providing services to students with disabilities
 | * if urban district, select 10% (not less than 10) of employee records to review.
 |  |  |  |  |  | Attributes |  |  |  |  |  |  | Comments
 | Name | Title | Fund | Function | Object | A | B | C | D | E | F | G
School Age
 |  |  |  |  |  | Attributes |  |  |  |  |  |  | Comments
 | Name | Title | Fund | Function | Object | A | B |  | C | D | E | F
Pre-School Age
 | Legend
 | Y | Attribute Satisfied
 | N | Attribute Not Satisfied
 | N/A | Attribut Not Applicable
 | Attributes
 | A | Review of position description for all positions funded through IDEA funds
 | B | Review of certification and/or licensure of IDEA funded staff - this includes those providing services to non-public schools. Is the License appropriate given position held?
 | C | The district maintains documentation for all certified teachers and para-professionals paid with Part B funds to assure that they meet the qualifications and requirements to be considered a Highly Qualified Teacher.
 | D | Time and effort documentation was maintained ([NAME] purpose employees require Log or Timesheet) Personal Activity Report (PAR)
 | E | Semi-annual Certification documentation was maintained for Single Funded or single purpose employees
 | F | The Payroll expense was charged to the proper fund.
 | G | The Payroll expense was charged to the proper function.
Spreadsheet: 97264d1296498253-using-max-with-sumifs-example
Sheet: FT Flex Sliced Info

 |  |  | Counts By MBU | NRNP |  |  | NRNQ |  |  | HRT1 |  |  | HRT2 |  |  | Total
 |  |  | MBU | Full | Flex | [NAME] | Full | Flex | [NAME] | Full | Flex | [NAME] | Full | Flex | [NAME] | Full | Flex | [NAME]
 |  |  | CHIEF ACTUARIAL OFFICER
 |  |  | Totals
Spreadsheet: 161824d1339642243-how-to-sort-numbers-into-top-middle-and-bottom-third-frequencies-of-all-occurences-standard-deviation-forum
Sheet: Sheet1

Number | Frequency percentage
1 | 0.0182
2 | 0.0202
3 | 0.017
4 | 0.0202
5 | 0.0199
6 | 0.0178
7 | 0.0176
8 | 0.0169
9 | 0.0188
10 | 0.0202
11 | 0.0176
12 | 0.0195
13 | 0.0182
14 | 0.0201
15 | 0.0175
16 | 0.0195
17 | 0.0201
18 | 0.016
19 | 0.0179
20 | 0.0191
Spreadsheet: 864152d1711452982-conditional-formatting-excel-club-query
Sheet: Sheet1

Medications |  |  |  |  | Date = | 2023-07-21 00:00:00
Name | Pack size | Quantity | Backroom | Top up | Total | Tablets |  | Daily | Supply lasts | Earliest Online | Earliest "10 day" | Latest operstional | Safety | Last | Last
 |  | p pack | Stock | Packs | Tablets | in | Total | Usage | till ..? | Website Reorder | Pre-Order | reorder | Margin | Reordered | Delivered
 |  |  | Packs | Deliv'd | Backroom | kitchen |  |  |  | Date | Date | Date | days | on | on
GABAPENTINE | 100 x 100 mg | 100 | 1 |  |  | 20 |  | 4 |  | 2023-07-15 00:00:00 |  |  |  | 2023-07-20 00:00:00 | 2023-07-20 00:00:00
Amitriptilyine | 28 x 10 mg | 28 | 4 |  |  |  |  | 5 |  | 2023-07-17 00:00:00 |  |  |  | 2023-07-20 00:00:00 | 2023-07-21 00:00:00
Amlodipine | 28 x 5 mg | 28 | 1 |  |  | 2 |  | 1 |  | 2023-08-10 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
Alendronic | 4 x 70 mg | 4 | 2 |  |  | 4 |  |  |  | 2023-04-13 00:00:00
Codeine phosphate | 28 x 15 mg | 28 | 3.5 |  |  | 28 |  | 2 |  | 2023-08-10 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
Codeine phosphate | 28 x 15 mg | 28 | 3.5 |  |  | 28 |  | 4 |  | 2023-08-10 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
Finasteride | 28 x 5 mg | 28 | 2 |  |  | 23 |  | 1 | 2023-12-13 00:00:00 | 2023-09-07 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
Lansoprazole | 28 x 15 mg | 28 | 2 |  |  | 3 |  | 0.5 |  | 2022-12-13 00:00:00
Laxido | 30 | 30 | 0 |  |  | 5 |  | 1 |  | 2023-07-29 00:00:00 |  |  |  | 2023-07-22 00:00:00 | 2023-06-23 00:00:00
Thealoz 2x | 10 ml |  | 1 |  |  |  |  |  |  | 2023-08-10 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
Evacal D3 | 28 x 1500 mg | 28 | 5 |  |  | 4 |  | 2 |  | 2023-08-14 00:00:00 |  |  |  | 2023-06-16 00:00:00 | 2023-05-19 00:00:00
[NAME] |  |  | 1 |  |  |  |  |  |  | 2023-08-10 00:00:00 |  |  |  | 2023-07-12 00:00:00 | 2023-07-14 00:00:00
T | a | n | G | o | 7 | 8 | 2 | 1 | 9 | Cobblers22#
1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th
 |  |  |  |  |  |  |  |  |  |  | OK to re-order | less than | 6.9
 |  |  |  |  |  |  |  |  |  |  | Do not reorder |  | Re-order!
 |  |  |  |  |  |  |  |  |  |  |  | = 5 days before
 |  |  |  |  |  |  |  |  |  |  |  | supply lasts
 |  | 16 = |  | of 28 |  |  |  |  |  |  |  | till
Spreadsheet: 158580d1338311630-formating-a-pivot-table-05302012-my-memec-backlog
Sheet: Sheet7

Count of Shipto Cust Name
[NAME] | Shipto Cust Acct | Total
ALTRONIX SYSTEMS CORP | H02002662     000 | 14
ALTRONIX SYSTEMS CORP Total |  | 14
BAE SYSTEMS | H02003921     009 | 2
BAE SYSTEMS Total |  | 2
BAE SYSTEMS AEROSPACE INC | H02003921     001 | 8
BAE SYSTEMS AEROSPACE INC Total |  | 8
BEHLMAN ELECTRONICS | H02000854     001 | 2
BEHLMAN ELECTRONICS Total |  | 2
BHARAT ELECTRONICS LTD | H02001514     000 | 18
BHARAT ELECTRONICS LTD Total |  | 18
BROOKHAVEN NATIONAL LAB | H02004127     004 | 1
BROOKHAVEN NATIONAL LAB Total |  | 1
COMMUNICATION SPECIALTIES | H02006176     000 | 2
COMMUNICATION SPECIALTIES Total |  | 2
COX & CO | H02002158     001 | 12
COX & CO Total |  | 12
DIMMEX | H02000408     004 | 3
 | H02000408     005 | 1
DIMMEX Total |  | 4
EDO ELECT-AIL SYSTEMS | H02000460     001 | 3
EDO ELECT-AIL SYSTEMS Total |  | 3
ELECTRO INDUSTRIES | H02002703     000 | 4
ELECTRO INDUSTRIES Total |  | 4
FREQUENCY ELECTRONICS INC | H02003281     001 | 1
FREQUENCY ELECTRONICS INC Total |  | 1
G E AVIATION SYSTEMS | H02000375     000 | 6
G E AVIATION SYSTEMS Total |  | 6
HONEYWELL INTL SARL | H02003137     001 | 13
HONEYWELL INTL SARL Total |  | 13
HONEYWELL SECURITY | H02000545     003 | 17
HONEYWELL SECURITY Total |  | 17
ILC DATA DEVICES      BPA | H02002280     000 | 20
ILC DATA DEVICES      BPA Total |  | 20
KEPCO INC | H02004608     002 | 3
KEPCO INC Total |  | 3
LENCORE ACOUSTICS CORP. | H02009292     000 | 1
LENCORE ACOUSTICS CORP. Total |  | 1
MICROBOARD/NORTH ATLANTIC | H02000089     002 | 3
MICROBOARD/NORTH ATLANTIC Total |  | 3
MITEQ INC | H02005520     001 | 5
MITEQ INC Total |  | 5
NAPCO SECURITY SYSTEMS IN | H02005689     001 | 6
NAPCO SECURITY SYSTEMS IN Total |  | 6
NORTH ATLANTIC/ APEX SIG | H02000089     000 | 10
NORTH ATLANTIC/ APEX SIG Total |  | 10
PARKER HANNIFIN CORP | H02003742     001 | 6
PARKER HANNIFIN CORP Total |  | 6
PEERLESS INSTRUMENTS CO | H02006181     001 | 4
PEERLESS INSTRUMENTS CO Total |  | 4
SMAR RESEARCH CORP | H02000320     001 | 15
SMAR RESEARCH CORP Total |  | 15
SRI NORTH AMERICA CORP | H02005010     000 | 2
SRI NORTH AMERICA CORP Total |  | 2
TELEPHONICS CORP | H02007536     001 | 4
TELEPHONICS CORP Total |  | 4
VICON IND | H02008526     000 | 1
VICON IND Total |  | 1
(blank) | (blank)
(blank) Total
Grand Total |  | 187
Spreadsheet: 272315d1382355570-master-list-in-excel-book1-9-_21-10-13
Sheet: MASTER LIST

No. | PERSON IN CHARGE | FILE REFERENCE
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 141647d1329387406-vba-to-copy-data-from-multiple-workbooks-to-master-workbook-sales-person-2
Sheet: Sales Log

 | No. | Client | Activity | Activity
 | 1
 | 1.01
 | 1.02
 | 1.03 |  |  |  |  | Named Range
 | 1.04 |  |  |  |  | Range1
 | 1.05
 | 1.06
 | 1.07
 | 1.08
 | 1.09
 | 2 | Client 11 | Activity 1 | [NAME]
 | 2.01 | Client 12 | Activity 2 | [NAME]
 | 2.02 | Client 13 | Activity 3 | [NAME]
 | 2.03 | Client 14 | Activity 4 | [NAME]
 | 2.04 | Client 15 | Activity 5 | [NAME] |  | Named Range
 | 2.05 | Client 16 | Activity 1 | [NAME] |  | Range2
 | 2.06 | Client 17 | Activity 2 | [NAME]
 | 2.07 | Client 18 | Activity 3 | [NAME]
 | 2.08 | Client 19 | Activity 4 | [NAME]
 | 2.09 | Client 20 | Activity 5 | [NAME]
 | 3
 | 3.01
 | 3.02
 | 3.03
 | 3.04 |  |  |  |  | Named Range
 | 3.05 |  |  |  |  | Range3
 | 3.06
 | 3.07
 | 3.08
 | 3.09