tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2b803099-85cd-4336-b198-1bfad7ad7cdd
Sheet: Individual Recon

 | Note: If more than one individual sold tickets, please duplicate this tab as many times as needed. Please re-name the tabs by inserting the seller's initials (i.e. [NAME]) or make copies as needed
 | Individual Raffle Ticket Reconciliation
 | [NAME]:
 | Reconciliation Perfomed by:
 | Date:
 | Legend:
 | [NAME] your data in these cells
 | Formula Driven Cells - Formula will automatically calculate
 | Reconcile Tickets & Calculate Proceeds
 | Beginning Raffle Ticket Number Issued
 | Next Raffle Ticket Number on Hand
 | Total Number of Tickets Issued
 | Beginning Raffle Ticket Turned in (not sold)
 | Ending Raffle Ticket Number Turned in (not sold)
 | Number of tickets Turned in
 | Beginning Raffle Ticket Number of  Lost Tickets
 | Ending Raffle Ticket Number of  Lost Tickets
 | Ending Raffle Ticket Number of  Lost Tickets
 | Total Number of Tickets sold
 | Sales Price Per Ticket
 | Total Amount of Raffle Ticket Proceeds
 | Total Amount of Cash to be Turned in
 | [NAME]
Spreadsheet: 693899d1599210620-formula-to-get-data-with-dates-in-columns-and-multiple-criteria-data-lookup
Sheet: Sheet1

Branch | Product | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00
NP000018 | A | 3 | 26 | 18 | 24 |  |  | 22 | 15
NP000018 | B | 2 | 12 | 16 | 14 |  |  | 12 | 13
NP000018 | C |  |  |  |  |  | 11
NP000018 | D |  |  |  |  | 13
NP000018 | E
NP000018 | F |  |  |  |  |  | 1
NP000018 | G |  |  |  |  | 12
NP000001 | A | 1 | 56 | 53 | 62 | 2 |  | 68 | 60
NP000001 | B |  | 13 | 16 | 11 |  |  | 6 | 8
NP000001 | C |  |  |  |  |  | 16
NP000001 | D |  |  |  |  | 13
NP000001 | E
NP000001 | F |  |  |  |  | 56 | 1
NP000019 | A |  | 9 | 3 | 8 |  |  | 5 | 2
NP000019 | B |  | 10 | 13 | 9 |  |  | 7 | 11
NP000019 | C |  |  |  |  |  | 30
NP000019 | D |  |  |  |  | 17
NP000019 | E
NP000019 | F
NP000019 | G |  |  |  |  | 3
Spreadsheet: 869415d1715979438-formula-for-calculating-turnaround-time-within-complex-work-hours-that-cross-midnight-sample-calculations2-turnaround-time-complex-working-hours
Sheet: Log

Working Hours |  |  | Holidays | 2024-01-01 00:00:00 | 2024-05-27 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-09-02 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-12-24 00:00:00 | 2024-12-25 00:00:00
5:00AM - 1:30AM Mon-Thur
5:00AM-3:30PM Fri
Sample | Date In | Time In | Date Done | Time Done | Date/Time In | Date/Time Done | Time 1 (5-3:30 M-F) | Time 2 (3:30-12 M-Th) | Time 3 (12-1:30 Tu-Th) | Total Time | Actual Time 1
Same Day | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-13 00:00:00 | 14:00:00 |  |  |  |  |  |  | 9
Past 12PM | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-14 00:00:00 | 00:30:00 |  |  |  |  |  |  | 19.5
Past 12PM+next day | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-14 00:00:00 | 16:00:00 |  |  |  |  |  |  | 31.5
Start past 12 | 2024-05-14 00:00:00 | 00:00:00 | 2024-05-14 00:00:00 | 01:30:00 |  |  |  |  |  |  | 1.5
Start past 12+ND | 2024-05-14 00:00:00 | 00:00:00 | 2024-05-14 00:00:00 | 06:00:00 |  |  |  |  |  |  | 2.5
Same Day Friday | 2024-05-10 00:00:00 | 05:00:00 | 2024-05-10 00:00:00 | 14:00:00 |  |  |  |  |  |  | 9
Overnight Friday | 2024-05-10 00:00:00 | 05:00:00 | 2024-05-13 00:00:00 | 06:00:00 |  |  |  |  |  |  | 11.5
Thursday to Monday | 2024-05-09 00:00:00 | 05:00:00 | 2024-05-13 00:00:00 | 06:00:00 |  |  |  |  |  |  | 32
Thursday past 12 | 2024-05-09 00:00:00 | 14:00:00 | 2024-05-10 00:00:00 | 01:30:00 |  |  |  |  |  |  | 11.5
Wednesday - Tuesday | 2024-05-08 00:00:00 | 14:00:00 | 2024-05-14 00:00:00 | 14:00:00 |  |  |  |  |  |  | 72
Wednesday Past 12 | 2024-05-08 00:00:00 | 14:00:00 | 2024-05-09 00:00:00 | 01:30:00 |  |  |  |  |  |  | 11.5
Spreadsheet: 871765d1718188509-march-fishing-xls-hpe-needed-sac-league
Sheet: 6

Name | lbs | oz | Oz (total) | Points
 | 54 | 13
 | 30 | 12
 | 74 | 4
 | 22 | 10
 | 16 | 11
 | 27 | 8
 | 81 | 12
 | 45 | 10
 | 28 | 10
 | 0 | 0
 | 22 | 6
 | 37 | 0
 | 31 | 11
 | 41 | 8
 | 70 | 12
 | 0 | 0
 | 0 | 0
Spreadsheet: 78915d1279199869-filtering-status-filter2
Sheet: Sheet1

Ticket # | Requested By | Date Requested | Problem/Issue/Remarks | Type of Request | Status
1 | [NAME] | 2010-07-15 00:00:00 | dsafs | Connection Problem | Pending
2 | [NAME] | 2010-07-15 00:00:00 | dsafs | Connection Problem | Done
3 | [NAME] | 2010-07-15 00:00:00 | dsafs | Connection Problem | Pending
Spreadsheet: 0735bea3-2108-4675-b8d6-860f33dbb7d9
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Sept. | Oct. | Nov. |  | Nov.
Region/country | 2012 | 2012 | 2012 |  | 2011
 | 1,000 pounds 1/
North America | 145729.901 | 150233.727 | 136515.12 |  | 141764.309
Canada | 2913.548 | 3189.514 | 2792.23 |  | 3104.546
Costa Rica | 723 | 996.777 | 870.543 |  | 746.783
Dominican Republic | 5707.788 | 6130.066 | 6267.859 |  | 6348.825
El Salvador | 22698.663 | 19874.968 | 16690.399 |  | 18502.673
Guatemala | 8594.423 | 9109.7 | 7030.827 |  | 6648.92
Haiti | 12907.656 | 13998.302 | 13424.582 |  | 11371.676
Honduras | 31310.109 | 28880.41 | 29223.033 |  | 32010.628
Mexico | 44187.845 | 48699.071 | 45379.446 |  | 46709.975
Nicaragua | 16686.045 | 19353.192 | 14835.456 |  | 16312.787
South America | 4331.301 | 4669.609 | 4186.594 |  | 3848.585
Brazil | 190 | 101.687 | 157.928 |  | 221.8
Colombia | 1503.615 | 1871.281 | 1682.385 |  | 1249.552
Peru | 2572.804 | 2645.177 | 2298.211 |  | 2294.759
Europe | 13179.888 | 16493.052 | 15675.539 |  | 11734.077
Germany | 1067.872 | 917.804 | 1063.197 |  | 853.202
Italy | 1043 | 1346.074 | 1742.485 |  | 1549.487
Portugal | 2036.805 | 1004.119 | 2235.97 |  | 1567.901
Turkey | 6417.41 | 10265.533 | 7565.033 |  | 4856.009
Asia | 557189.433 | 560436.385 | 509298.48 |  | 484589.029
Bahrain | 1603.281 | 1357.138 | 1335.573 |  | 1163.27
Bangladesh | 42647.417 | 39243.786 | 43006.18 |  | 35570.597
Cambodia | 23299.571 | 24959.492 | 18332.402 |  | 20342.499
China | 267330.067 | 261331.312 | 213480.649 |  | 214369.607
Hong Kong | 749 | 795.707 | 801.531 |  | 1141.848
India | 67441.417 | 57443.062 | 62756.507 |  | 54478.555
Indonesia | 26726.695 | 30762.502 | 27703.097 |  | 27042.342
Israel | 852 | 552.914 | 860.285 |  | 574.804
Japan | 920 | 1043.889 | 993.558 |  | 1283.601
Jordan | 3969.346 | 3468.762 | 4651.922 |  | 3292.449
Malaysia | 3182.172 | 3104.703 | 3395.551 |  | 2594.716
Pakistan | 60908.713 | 58613.113 | 69178.131 |  | 59638.593
Philippines | 5029.055 | 5289.738 | 3653.867 |  | 4301.634
South Korea | 4803.132 | 5826.835 | 5418.734 |  | 5361.746
Sri Lanka | 5930.376 | 6844.15 | 7233.976 |  | 6328.95
Taiwan | 2677.924 | 2632.814 | 1994.504 |  | 2417.804
Thailand | 6924.272 | 6866.894 | 5248.589 |  | 6827.579
Vietnam | 40974 | 49105.538 | 37989.591 |  | 36488.853
Oceania | 29.429 | 12.296 | 41.196 |  | 43.046
Africa | 14668.868 | 15737.664 | 15203.169 |  | 13728.842
Egypt | 7509.224 | 8502.203 | 7780.478 |  | 6462.078
Kenya | 2221.251 | 2551.683 | 1943.827 |  | 1978.745
[NAME] | 3122.263 | 2220.741 | 3792.998 |  | 3349.525
[NAME] | 647 | 1101.513 | 456.09 |  | 939.161
World 2/ | 735128.82 | 747582.732 | 680920.098 |  | 655709.079
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update:  02/12/13.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 6 | 1 | 1 | 7 | 23 | 12 | 23 | - | 73
Cross-Currency Fixed-Fixed | 4 | - | 3 | - | 2 | - | 1 | - | 10
Cross-Currency Fixed-Float | 3 | - | 10 | 3 | 10 | 3 | 3 | - | 32
TOTAL | 13 | 1 | 14 | 10 | 35 | 15 | 27 |  | 115
Spreadsheet: efdc1f6b-6098-4f04-883a-2c7fe729d498
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
ISPG | Test | ISPG | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ISPG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ISPG | Result | ISPG | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6150-7
Spreadsheet: 0948d153-9256-44af-8a94-e962234926f4
Sheet: Activities codes

 | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk
EDRS Activity Codes
Activity code | [NAME]
J | Assessment (Consultant only)
M | Special Education Curriculum Development
O | IEP Planning Development, Review Due Process
Z | Travel - Mileage (ECSE - Home Based Travel Only)
Team Teaching Required for Personnel Type Code 1 Teacher
+ | Team Teaching Model - Regular Class
* | Team Teaching Model - Resource Room
# | Team Teaching Model - Separate Class
Required for Personnel Type Code 12 Cultural Liaison
t | American Indian
u | Bilingual
v | African American
w | Other
Required for Alternative Delivery of Specialized Instructional Services FSC C and FSC N
s | Special Education Teacher
R | Regular Education Teacher
Required for Personnel Type Code 62 Extracurricular Activities
a | Interpreter Services
b | Assistive Technology Services
c | Para/PCA Services
d | Nursing Services
e | Vision Services
f | Other IEP Specified Services
Spreadsheet: 48439d1247658303-sumproduct-formula-help-691566-sumproduct-formula-help
Sheet: Sheet1

Value | Month |  | Month | Y | N
Y | April |  | April | 3 | 1
Y | April |  | May | 2 | 1
N | April
Y | April
Y | May
N | May
Y | May
Spreadsheet: 861441d1709295140-one-value-from-3-options-book4-etaf
Sheet: Sheet1

 | TABLE ONE |  |  |  | TABLE TWO
 | Design Activity |  |  |  | Design Activity
 |  |  | Design Complete |  |  |  | Design Complete |  |  | In table one, in column B from cell B4 down you will see i am using formula =IF(C4="",D4,C4), as usually in the past there has only even been the one activity, either start of design or complete design.
 |  |  | Design Complete |  |  |  | Design Complete
 |  | Design Start |  |  |  | Design Start
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  | Design Start |  |  |  | Design Start
 |  |  | Design Complete |  |  |  | Design Complete |  |  | Now i have an option that i could have both activities in the same year, the desired result i am after is in column F from cell F4 down, you can probably tell i want the F cell to pull through from columns G and H what the activity is, but if both cells in columns G & H have an activity i want it to return "Both" in the F cell.
 |  |  | Design Complete |  |  |  | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  |  | Design Complete |  |  |  | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start | Design Complete |  |  | Design Start | Design Complete
 |  | Design Start |  |  |  | Design Start
 |  |  | Design Complete |  |  |  | Design Complete
Spreadsheet: 68488d1269015246-data-validation-checkout-holiday-tracker-2010-2011
Sheet: Open or Closed

Back Home
Check which weeks are open or closed
 | Period 1 |  |  |  | Period 2 |  |  |  | Period 3 |  |  |  | Period 4 |  |  |  | Period 5
 | Week 1 | 2010-03-21 00:00:00 | OPEN |  | Week 1 | 2010-04-18 00:00:00 | OPEN |  | Week 1 | 2010-05-16 00:00:00 | OPEN |  | Week 1 | 2010-06-13 00:00:00 | OPEN |  | Week 1 | 2010-07-11 00:00:00 | OPEN
 | Week 2 | 2010-03-28 00:00:00 | CLOSED |  | Week 2 | 2010-04-25 00:00:00 | OPEN |  | Week 2 | 2010-05-23 00:00:00 | OPEN |  | Week 2 | 2010-06-20 00:00:00 | OPEN |  | Week 2 | 2010-07-18 00:00:00 | OPEN
 | Week 3 | 2010-04-04 00:00:00 | CLOSED |  | Week 3 | 2010-05-02 00:00:00 | OPEN |  | Week 3 | 2010-05-30 00:00:00 | OPEN |  | Week 3 | 2010-06-27 00:00:00 | OPEN |  | Week 3 | 2010-07-25 00:00:00 | OPEN
 | Week 4 | 2010-04-11 00:00:00 | OPEN |  | Week 4 | 2010-05-09 00:00:00 | OPEN |  | Week 4 | 2010-06-06 00:00:00 | OPEN |  | Week 4 | 2010-07-04 00:00:00 | OPEN |  | Week 4 | 2010-08-01 00:00:00 | OPEN
 | Period 6 |  |  |  | Period 7 |  |  |  | Period 8 |  |  |  | Period 9 |  |  |  | Period 10
 | Week 1 | 2010-08-08 00:00:00 | OPEN |  | Week 1 | 2010-09-05 00:00:00 | OPEN |  | Week 1 | 2010-10-03 00:00:00 | OPEN |  | Week 1 | 2010-10-31 00:00:00 | OPEN |  | Week 1 | 2010-11-28 00:00:00 | OPEN
 | Week 2 | 2010-08-15 00:00:00 | OPEN |  | Week 2 | 2010-09-12 00:00:00 | OPEN |  | Week 2 | 2010-10-10 00:00:00 | OPEN |  | Week 2 | 2010-11-07 00:00:00 | OPEN |  | Week 2 | 2010-12-05 00:00:00 | OPEN
 | Week 3 | 2010-08-22 00:00:00 | OPEN |  | Week 3 | 2010-09-19 00:00:00 | OPEN |  | Week 3 | 2010-10-17 00:00:00 | OPEN |  | Week 3 | 2010-11-14 00:00:00 | OPEN |  | Week 3 | 2010-12-12 00:00:00 | OPEN
 | Week 4 | 2010-08-29 00:00:00 | OPEN |  | Week 4 | 2010-09-26 00:00:00 | OPEN |  | Week 4 | 2010-10-24 00:00:00 | OPEN |  | Week 4 | 2010-11-21 00:00:00 | OPEN |  | Week 4 | 2010-12-19 00:00:00 | CLOSED
 |  |  |  |  | Period 11 |  |  |  | Period 12 |  |  |  | Period 13
 |  |  |  |  | Week 1 | 2010-12-26 00:00:00 | CLOSED |  | Week 1 | 2011-01-23 00:00:00 | OPEN |  | Week 1 | 2011-02-20 00:00:00 | OPEN
 |  |  |  |  | Week 2 | 2011-01-02 00:00:00 | OPEN |  | Week 2 | 2011-01-30 00:00:00 | OPEN |  | Week 2 | 2011-02-27 00:00:00 | OPEN
 |  |  |  |  | Week 3 | 2011-01-09 00:00:00 | OPEN |  | Week 3 | 2011-02-06 00:00:00 | OPEN |  | Week 3 | 2011-03-06 00:00:00 | OPEN
 |  |  |  |  | Week 4 | 2011-01-16 00:00:00 | OPEN |  | Week 4 | 2011-02-13 00:00:00 | OPEN |  | Week 4 | 2011-03-13 00:00:00 | OPEN
Spreadsheet: 330520d1404774863-searching-a-range-of-options-before-giving-a-resut-five-search
Sheet: Sheet1

Number | Type | Size | Level | Result |  |  | Answer |  |  |  | this answer is incorrect, it should be 6
1 | DOG | BIG | B | 7
1 | DOG | SMALL | B | 5
1 |  | BIG | B | 6
2 | CAT | BIG | A | 3 |  |  | Searching for |  | 1 BIG B
2 |  | BIG | B | 12
2 | CAT | SMALL | B | 11
2 | CAT | MEDIUM | A | 8
3 | FISH | Big | B | 45
3 |  | MEDIUM | B | 21
3 | FISH | MEDIUM | A | 1
Spreadsheet: darrell_schoolcraft__7274__saledoc02_27bTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-26 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/27/2002 |  |  | FAX Number:
Total Quantity |  |  | 40000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  | 30000 | 2.31
 |  | 10000 | 2.32
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/27/2002 | 2002-02-27 00:00:00 | 40000 |  | 40000 |  | 40000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 40000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: cbed551a-8e4a-431e-b7ac-6e93f71e475a
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (22 Entries):
 | 11 PCBs, other circuit carriers and EMS 11.1 Non-PTH single- and double-sided PCBs
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AT&S Austria Technologie & Systemtechnik AG | Austria | Leoben-Hinterberg | 8700 | B1.125
2 | Auter Electronics Ltd | Hungary | Budapest | 1163 | B1.171
3 | BASKI Devre San. ve Tic. Ltd. Sti | Turkey | Pendik - Istanbul | 34896 | B1.574
4 | [NAME] Leiterplattenschnelldienst | Germany | [NAME] | 24145 | B1.542
5 | CeMeBo, s.r.o. | Czech Republic | [NAME] | 678 01 | C1.510
6 | Cipsa Circuitos Impresos Profesionales, S.A. Cipsa Group (Spain and India) | Spain | RUBI (Barcelona) | 08191 | B1.471
7 | CML Group | Germany | Waldbronn | 76337 | B1.555
8 | COROPLAST Fritz Müller GmbH & Co.[NAME] | Germany | Wuppertal | 42279 | B5.455
9 | ELVIA - pcb Groupe | France | Coutances | 50211 | B1.147
10 | Christian Enzmann GmbH | Germany | Geretsried | 82538 | B1.325
11 | EUROCIR S.A. | Spain | [NAME]Barcelona) | 08210 | B1.674
12 | ggp-Schaltungen GmbH | Germany | [NAME] | 37520 | B1.311
13 | GS-PETERS GmbH | Germany | Seesen | 38723 | B1.108
14 | W.C. Heraeus GmbH | Germany | Hanau | 63450 | A2.209
15 | HongKong Bliss International Co., Limited | China | Shenzhen | 518109 | B1.475
16 | ICAPE | France | Paris | 75002 | B1.409
17 | LPKF Laser & Electronics AG | Germany | Garbsen | 30827 | B1.319
18 | Mektec Europe GmbH | Germany | [NAME] | 69469 | A6.324
19 | META Leiterplatten GmbH & Co. [NAME] | Germany | Villingen-Schwenningen | 78056 | B1.329
20 | Piciesse Elettronica SRL | Italy | Taverna di Montecolombo (RN) | 47854 | B1.405
21 | Reliance Technology Development Limited | Hong Kong | [NAME] |  | B1.651
22 | SCHWEIZER ELECTRONIC AG | Germany | Schramberg | 78713 | B1.442
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -526 | -1038
2 | -631 | -1038
3 | -1354 | -1038
4 | -1885 | -1038
5 | -2002 | -1038
6 | -1601 | -1038
7 | -529 | -1038
8 | -551 | -1038 |  |  |  |  |  |  |  |  | Avg
9 | -645 | -1038 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -1577 | -1038
11 | -1931 | -1038 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | -254200.98
2002-03-11 00:00:00
CBS Volume
 |  |  | 3963
Spreadsheet: 814747d1674573116-how-to-convert-a-range-to-non-blank-row-torow
Sheet: Sheet1

This range originated from an array formula (e.g filter function)
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
0 | 0 | 0 | 4/CT | 0 | 0 | 0 | 0
0 | 0 | 0 | 4/CMT | 0 | 0 | 0 | 0
0 | 0 | 0 | 4/MT | 4/PT | 4/ENT | 0 | 0
0 | 0 | 0 | 4/EMT | 0 | 0 | 0 | 0
1/CT | 1/CMT | 1/MT | 1/EMT | 1/PT | 1/ENT | 1/ET | 1/CT
My requirement as below
4/CT | 4/CMT | 4/MT | 4/PT | 4/ENT | 4/EMT | 1/CT | 1/CMT | 1/MT | 1/EMT | 1/PT | 1/ENT | 1/ET | 1/CT
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
4/CT | 4/CMT | 4/MT | 4/PT | 4/ENT | 4/EMT | 1/CT | 1/CMT | 1/MT | 1/EMT | 1/PT | 1/ENT | 1/ET | 1/CT
Spreadsheet: 0700e193-8b5a-47b1-b86b-b766ca8adaef
Sheet: ElementaryCharter

 | Elementary
 |  | Alcohol | Tobacco | Other Drugs | Distribution | Assaults | [NAME] | Handgun | Rifle | Other Firearm | Other Weapon | Totals
 | Charter
 | AMES | - | - | - | - | - | - | - | - | - | -
 | City Academy | - | - | - | - | - | - | - | - | - | -
 | [NAME] | 1 | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | - | - | - | - | - | - | - | -
 | Legacy Preparatory Academy | - | 1 | - | - | - | - | - | - | - | -
 | North Star Academy | 1 | - | - | - | 1 | - | - | - | - | -
 | Monticello Academy | 3 | - | 2 | 1 | 23 | - | - | - | - | 4
 | Excelsior Academy | - | - | 1 | - | - | - | - | - | - | -
 | East Hollywood High | - | - | - | - | - | - | - | - | - | -
 | Spectrum Academy | - | - | - | - | 6 | - | - | - | - | 4
 | Dual Immersion Academy | - | - | - | - | 14 | - | - | - | - | 2
 | Quail Run Primary | - | - | - | - | 3 | - | - | - | - | 1
 | Odyssey Charter School | - | - | - | - | 1 | - | - | - | - | -
 | Oquirrh Mountain Charter | - | - | - | - | 1 | - | - | - | - | -
 | Lincoln Academy | - | - | - | - | 1 | - | - | - | - | -
 | Entheos Academy | - | - | - | - | 1 | - | - | - | - | -
 | [NAME] | - | - | - | - | 1 | - | - | - | - | -
 | American Leadership Academy | - | - | - | - | 18 | - | - | - | - | 4
 | Good Foundations Academy | - | - | - | - | 2 | - | - | - | - | -
 | Pinnacle Canyon Academy | - | - | - | - | - | - | - | - | - | 1
 | Quest Academy | - | - | - | - | - | - | - | - | - | 1
 | Syracuse Arts Academy | - | - | - | - | - | - | - | - | - | 1
 | Charter School Total
 | Grand Total |  |  |  |  |  |  |  |  |  |  | 1333
Spreadsheet: 30771d1226442081-excel-2007-customer-retention-models-example-worksheet-v3
Sheet: Working sheet

 | August | September | October | November | December | January | February | March | April | May | June | July
 | 123 | 3456 | 34 | 34
 | 231 | 34 | 890 | 890
 | 312 | 326457 | 312 | 312
 | 254453 | 2354 | 231 | 7856
 | 46434 | 34568 | 222 | 222
 | 234 | 890 | 7856 | 123
 | 3345 | 465 | 890 | 456
 | 5756 | 5756 | 777 | 231
 | 34756 | 312 | 888 | 231
August
September
October
November
December
January
February
March
April
May
June
July
 |  | This set of helper cells can be hidden if desired.  These are ARRAY formulas
 |  | and must be entered by pressing CTRL+SHIFT+ENTER, every time you make
 |  | an edit. Pressing ENTER only will break the arrays.
Spreadsheet: 270193d1381412699-how-to-highlight-a-cell-when-the-sum-is-greater-than-another-cell-reference-cond-format-sum-2
Sheet: Sheet1

102