tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44009

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44009
Number of cores |  | 2
Spare cores |  | 0
Core size |  | 4mm2
Cable Type |  | Cu, PVC+E
Drawing References
Cable Service |  | Panel Lighting and Socket
Panel Number | T44 PP |  | Panel Number |  | DC DB10
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | DC DB10 | INITIAL
1 | R11R |  | TBY7:P |  | MCB11/R
2 | R11N |  | TBY7:N |  | MCB11/N
3 | R11E |  | TBY7:E |  | Earth
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-02 00:00:00 | Actual available breakers in DB10 may differ - mark up core card and drawing |  |  |  | DJC
 |  | Check core numbers are correct
Edition Notes | 2011-08-02 00:00:00 | Was cable 4509 |  |  |  | DJC
Spreadsheet: 719314d1613615795-help-with-excel-macos-formula-for-duplicating-rows-with-unique-data-in-certain-columns-book1
Sheet: Sheet1

First name | Last name | Address | Phone 1 | Phone 2 | Phone 3 |  |  |  |  | First name | Last name | Address | Phone
[NAME] | Smith | xxx | 123 | 4567
Maria | [NAME] | yyy |  | 344 | 556
[NAME] | [NAME] | zzz | 3 | 44 | 45
[NAME] | [NAME] | ttt | 2 |  | 1
Spreadsheet: 87526d1287413949-cant-autofill-data-in-workbook-from-sheet-to-sheet-copy-of-hcr-database
Sheet: Appts

SSN | Rank | Name | Unit | [NAME] | 2010-10-10 00:00:00 | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | 2010-01-11 00:00:00 | 2010-02-11 00:00:00 | 2010-03-11 00:00:00 | 2010-04-11 00:00:00 | 2010-05-11 00:00:00 | 2010-06-11 00:00:00 | 2010-07-11 00:00:00 | 2010-08-11 00:00:00 | 2010-09-11 00:00:00
 | SRA
 | SSG
 | SRA
 | A1C
 | 2LT
 | SMS
 | SRA
 | SSG
 | SRA
 | 1LT
 | A1C
 | SSG
 | SSG
 | SSG
 | MAJ
 | SRA
 | CPT
 | SSG
 | LTC
 | A1C
 | TSG
 | SSG
 | CPT
 | SSG
 | SRA
 | SSG
 | CPT
 | TSG
 | TSG
 | TSG
 | SSG
 | SRA
 | SSG
 | 1LT
 | A1C
 | SSG
 | A1C
 | SSG
 | SRA
 | CPT
 | CPT
 | CMS
 | SSG
 | SSG
 | LTC
 | TSG
 | TSG
 | CMS
 | SSG
 | CPT
 | A1C
 | 1LT
 | SRA
 | SSG
 | SSG
 | CPT
 | LTC
 | Lt
 | SRA
 | MSG
 | SSG
 | MSG
 | SSG
 | MAJ
 | MAJ
 | TSG
 | SRA
 | SSG
 | SRA
 | MAJ
 | CPT
 | SRA
 | A1C
 | TSG
 | A1C
 | SRA
 | MAJ
 | A1C
 | SRA
 | COL
 | Lt
 | SSG
 | SSG
 | 1LT
 | MAJ
 | 2LT
 | 2LT
 | TSG
 | SSG
 | SRA
 | TSG
 | SRA
 | SSG |  |  |  | 1
 | SSG
 | SRA |  |  |  | 1
 | CPT
 | 1LT
 | SRA
 | CPT
 | CPT
 | SSG
 | SMS
 | SRA
 | CPT
 | SSG
 | SRA
 | TSG
 | SSG
 | SRA
 | 2LT
 | LT
 | TSG
 | SSG
 | CPT
 | SRA
 | MSG
 | SSG
 | SRA
 | SRA
 | CPT
 | CPT
 | MSG
 | SRA
 | SRA
 | SRA
 | SSG
 | SSG
 | SSG
 | SRA
 | A1C
 | LTC
 | COL
 | CPT |  |  |  | 1
 | SSG
 | SRA
 | 1LT
 | SSG
 | SSG
 | MAJ
 | CMS
 | TSG
 | TSG
 | CPT
 | TSG
 | TSG
 | SSG
 | A1C
 | CPT
 | SSG
 | TSG
 | SRA
 | SSG
 | SRA
 | MAJ
 | SSG
 | SRA
 | SSG
 | CPT
 | SSG
 | SRA
 | SRA
 | SRA
 | MSG
 | SMS
 | MAJ
 | SSG
 | SSG
 | CPT
 | SSG
 | SRA
 | SRA
 | SSG
 | SSG
 | CPT
 | 1LT
 | TSG
 | SRA
 | SRA
 | TSG
 | SSG
 | TSG
 | CPT
 | SRA
 | SRA
 | Lt
 | SSG
 | SRA
 | 1LT
 | MSG
 | SRA
 | CPT
 | SSG
 | MAJ
 | CPT
 | SSG
 | SRA
 | 1LT
 | MAJ
 | TSG
 | CPT
 | CPT
 | SSG
 | SSG
 | SSG
 | SSG
 | TSG
 | 1LT
 | MAJ
 | MSG
 | SSG
 | SSG
 | SSG
 | MSG |  |  |  |  | 4
 | SSG |  |  |  | 1 | 4
 | SSG |  |  |  | 1
353709292 | SSG
Total
Metrics |  | Total
Total Pts
Oct 10 Appt |  | =COUNT(F2:F217)
Nov 10 Appt |  | =SUM(G3;G217)
Dec 10 Appt(s) |  | =COUNT(H2:H217)
Jan 10 Appt(s)
Feb 11 Appt(s)
[NAME] Appt(s)
Apr 11 Appt(s)
May 11 Appt(s)
Jun 11 Appt(s)
Jul 11 Appt(s)
Aug 11 Appt(s)
Sep 11 Appt(s)
Spreadsheet: 05d1a931-d411-4a9a-a432-8c6a2f772bd6
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I–WEST O‘AHU
FALL 1999 TO FALL 2009
FALL SEMESTER |  |  | TOTAL |  |  |  | Classified  Undergraduates |  |  |  |  |  |  |  |  |  | Unclassified |  |  |  |  |  | HOME-BASED |  | No
 |  |  | No. |  | % Chng |  | Subtotal |  | Fresh |  | Soph |  | Junior |  | Senior |  | Subtotal |  | Undergrad |  | Grad |  | AT OTHER UH  4/ |  | Data
 | 1999 .............................................. |  | 687 |  | 0.3 |  | 613 |  |  |  |  |  | 376 |  | 237 |  | 74 |  | 72 |  | 2
 | 2000 .............................................. |  | 665 |  | -3.2 |  | 621 |  |  |  |  |  | 328 |  | 293 |  | 44 |  | 43 |  | 1
 | 2001 ............................................. |  | 740 |  | 11.3 |  | 625 |  |  |  |  |  | 379 |  | 246 |  | 106 |  | 103 |  | 3 |  |  |  | 9
 | 2002 ............................................. |  | 834 |  | 12.7 |  | 724 |  |  |  |  |  | 446 |  | 278 |  | 109 |  | 96 |  | 13 |  |  |  | 1
 | 2003  1/ ............................................. |  | 810 |  | -2.9 |  | 636 |  |  |  |  |  | 274 |  | 362 |  | 43 |  | 43 |  | 0 |  | 42 |  | 89
 | 2004 ............................................. |  | 834 |  | 3 |  | 700 |  |  |  |  |  | 339 |  | 361 |  | 34 |  | 34 |  | 0 |  | 37 |  | 63
 | 2005............................................. |  | 858 |  | 2.9 |  | 800 |  |  |  |  |  | 384 |  | 416 |  | 29 |  | 29 |  | 0 |  | 29
 | 2006  2/ ............................................. |  | 866 |  | 0.9 |  | 795 |  |  |  | 5 |  | 280 |  | 510 |  | 40 |  | 40 |  | 0 |  | 31
 | 2007  3/ ............................................. |  | 940 |  | 8.5 |  | 876 |  | 39 |  | 23 |  | 317 |  | 497 |  | 31 |  | 31 |  | 0 |  | 33
 | 2008............................................. |  | 1140 |  | 21.27659574468085 |  | 1094 |  | 229 |  | 47 |  | 266 |  | 552 |  | 20 |  | 20 |  |  |  | 26
 | 2009............................................. |  | 1333 |  | 16.92982456140351 |  | 1253 |  | 158 |  | 68 |  | 356 |  | 671 |  | 40 |  | 40 |  |  |  | 40
 | 1/  Migration to a new student registration system took place in Fall 2003. Unclassified graduate level no longer available.
 | 2/  Prior to Fall 2006, headcount for juniors includes records which were coded in IRO Base as freshmen and sophomore ed level.
 | Coding of lower division may have resulted from late input of transfer credits.
 | 3/  First freshmen class admitted in Fall 2007.
 | 4/  Students whose primary campus, as identified in Banner / ODS, is not UH West O‘ahu.
 | Data for Fall 2003 and 2004 are from SIMS Base files, with information on primary campus added from Banner / Datamart.
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 490905 | 541357
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 470521 | 533527 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 592943 | 553784 |  | 2001-11-03 00:00:00
500293 | 270864 | 314108
500302 |  | 4496
500303 |  | 157263
500305 | 875945 | 699951
500307 | 58693 | 34048
500313 |  | 1616
500314
500655 | 59767
500657 | 91219 | 79797
INDEX
2001-11-30 00:00:00 |  |  | 40288.34
2001-12-16 00:00:00
CBS Volume
 |  |  | 31564
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 13b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 41959 | 451801 | 465072 | 958832
Europe | - | - | 459124 | 459124
North America/Asia | 41959 | 451801 | 5948 | 499708
Other | - | - | - | -
Index | 647018 | 2761854 | 3765724 | 7174596
Asia | - | - | 108648 | 108648
Europe | - | - | 3267756 | 3267756
North America | 647018 | 2761854 | 122743 | 3531615
Other | - | - | 266577 | 266577
OTHER* | - | - | 446911 | 446911
TOTAL | 688977 | 3213655 | 4677707 | 8580339
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 56184f0b-65a5-437c-91d1-eaa61635763a
Sheet: Sheet1

Facility Status: (Please check one of the following) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
All monitoring data and sampling frequencies meet permit requirements
(including weekly averages, if applicable)
 |  |  |  |  |  |  |  | Compliant
All monitoring data and sampling frequencies do NOT meet permit requirements
 |  |  |  |  |  |  |  | Noncompliant
The permittee shall report to the Director or the appropriate Regional Office any noncompliance that potentially threatens public health or the environment.  Any information shall be provided orally within 24 hours from the time the permittee became aware of the circumstances.  A written submission shall also be provided within 5 days of the time the permittee becomes aware of the circumstances.
If the facility is noncompliant, please attach a list of corrective actions being taken and a time-table for improvements to be made as required by Part II.E.6 of the [NAME] permit.
“I certify, under penalty of law, that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who managed the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations.”
 |  |  |  |  | Permittee  (Please print or type)
 |  |  |  |  | Signature of Permittee*** |  |  | Date
 |  |  |  |  | (Required unless submitted electronically)
Permittee Address |  |  |  | Phone Number |  | e-mail address |  | Permit Expiration Date
ADDITIONAL CERTIFIED LABORATORIES
Certified Laboratory (2) |  |  |  |  |  | Certification No.
Certified Laboratory (3) |  |  |  |  |  | Certification No.
Certified Laboratory (4) |  |  |  |  |  | Certification No.
Certified Laboratory (5) |  |  |  |  |  | Certification No.
PARAMETER CODES
Parameter Code assistance may be obtained by calling the NPDES Unit at (919) 807-6300 or by visiting http://portal.ncdenr.org/web/wq/swp/ps/npdes/appforms.
Use only units of measurement designated in the reporting facility’s NPDES permit for reporting data.
*     No Flow/Discharge From Site:  Check this box if no discharge occurs and, as a result, there are no data to be
 | entered for all of the parameters on the DMR for the entire monitoring period.
**   ORC On Site?:  ORC must visit facility and document visitation of facility as required per 15A NCAC 8G .0204.
*** Signature of Permittee:  If signed by other than the permittee, then the delegation of the signatory authority must be on
 | file with the state per 15A NCAC 2B .0506(b)(2)(D).
Spreadsheet: 856242d1705565124-dynamic-array-for-cumulative-count-book1-fast-reduced-1-
Sheet: Sheet1

 |  |  | 30 secs |  | 33  secs |  | 73 secs |  | 80  secs |  | 0.16 secs |  | 0.24 secs |  | 0.14 secs |  | 0.24 secs
Item | Value |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF |  | cumulative countif on a subset of r (value in column B should be < 15)
C | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 44
C | 23 |  |  |  |  |  |  |  |  |  | 2 |  | 43 |  | 5 |  | 73 |  | D | 1 |  | D | 21
B | 14 |  |  |  |  |  |  |  |  |  | 1 |  | 14 |  | 6 |  | 75 |  | D | 2 |  | D | 21
D | 3 |  |  |  |  |  |  |  |  |  | 1 |  | 3 |  | 3 |  | 21 |  | B | 2 |  | B | 44
B | 16 |  |  |  |  |  |  |  |  |  | 2 |  | 30 |  | 6 |  | 75 |  | D | 3 |  | D | 21
D | 4 |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 3 |  | 21 |  | B | 3 |  | B | 44
A | 16 |  |  |  |  |  |  |  |  |  | 1 |  | 16 |  | 4 |  | 65 |  | A | 1 |  | A | 14
B | 13 |  |  |  |  |  |  |  |  |  | 3 |  | 43 |  | 6 |  | 75 |  | C | 1 |  | C | 15
D | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 21 |  | 3 |  | 21 |  | B | 4 |  | B | 44
B | 9 |  |  |  |  |  |  |  |  |  | 4 |  | 52 |  | 6 |  | 75 |  | C | 2 |  | C | 15
A | 15 |  |  |  |  |  |  |  |  |  | 2 |  | 31 |  | 4 |  | 65
B | 15 |  |  |  |  |  |  |  |  |  | 5 |  | 67 |  | 6 |  | 75
C | 15 |  |  |  |  |  |  |  |  |  | 3 |  | 58 |  | 5 |  | 73
A | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 45 |  | 4 |  | 65
A | 20 |  |  |  |  |  |  |  |  |  | 4 |  | 65 |  | 4 |  | 65
C | 14 |  |  |  |  |  |  |  |  |  | 4 |  | 72 |  | 5 |  | 73
B | 8 |  |  |  |  |  |  |  |  |  | 6 |  | 75 |  | 6 |  | 75
C | 1 |  |  |  |  |  |  |  |  |  | 5 |  | 73 |  | 5 |  | 73
Spreadsheet: 74241d1274801524-returning-all-specific-data-from-a-list-mock3
Sheet: Iro

 | Iro
 | ID | Category | Description | Column 1 | column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11
 | From data tab | from data tab | from data tab | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed | Manually Fed
Spreadsheet: 75197d1275729721-show-hide-rows-base-on-value-show-and-hide-rows
Sheet: KOL

 |  |  |  |  |  |  |  |  |  |  |  |  | local | imported
 |  |  |  |  | ACTUAL Delivery Timelines (no. of days) |  |  |  |  |  |  |  | andrez | huwaei
 |  |  |  |  |  |  |  |  |  |  |  |  | space
 |  |  |  |  |  |  |  | Type of vendor | local |  |  |  | fibcomm
 |  |  |  |  |  |  |  |  |  |  |  |  | ceragon
 |  |  |  | imported |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Vendor | ITEM | Average Transit Time (from [NAME]'s factory to Indian Port of Entry) | Average TAT for custom clearance (for Imported Items only) | Average Transit Time for Receipt at TWH (either from CHA or domestic supplier location to TWH) | Total TAT (from Supplier despatch to Material receipt)
 |  |  |  | Huwaei | PDH Antenna | 22 | 5 | 1 | 28 days
 |  |  |  | Huwaei | Microwave Hop | 22 | 5 | 1 | 28 days
 |  |  |  | Huwaei | Indoor BTS | 22 | 5 | 1 | 28 days
 |  |  |  | Huwaei | Outdoor BTS | 22 | 5 | 1 | 28 days
 |  |  |  | local
 |  |  |  | Vendor | ITEM | Average Transit Time (for sending road permit) | Average Transit Time for Receipt at TWH | Total TAT (from Supplier despatch to Material receipt)
 |  |  |  | andrez | Power cable  (red) | 3 | 9 | 12 days
 |  |  |  | space | Grounding cable | 3 | 9 | 12 days
 |  |  |  | fibcomm | Jumper Cable 1/2" Din M-Din M of 3.0 M Length | 3 | 9 | 12 days
 |  |  |  | ceragon | Feeder Connector - DIN Female for 7/8" | 3 | 9 | 12 days
 |  |  |  | [NAME] | [NAME] | 3 | 9 | 12 days
Spreadsheet: lisa_gang__22402__Hanson Scheduling Model_4_23
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-04-23 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 20.148 | 18.024 | 18.192 | 18.192 | 18.612 | 20.496 | 17.424 | 14.136 | 16.824 | 22.908 | 23.16 | 23.112 | 23.028 | 23.388 | 24.12 | 24.816 | 26.976 | 29.448 | 30.732 | 30.564 | 30.78 | 31.08 | 30.48 | 26.412 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.17523590669258 | 31.17523590669258 | 31.17523590669258 | 31.17523590669258 | 31.92523590669258 | 31.92523590669258 | 32.12523590669259 | 25.06523590669259 | 25.06523590669259 | 25.06523590669259 | 25.06523590669259 | 25.06523590669259 | 23.54023590669259 | 23.54023590669259 | 24.29023590669259 | 23.41023590669258 | 30.47023590669259 | 30.47023590669259 | 31.04523590669259 | 31.04523590669259 | 31.92523590669258 | 31.92523590669258 | 31.17523590669258 | 31.17523590669258
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Sheet 2Luci  

Contract Terms (*)
 |  | Revenue Target (Physiotherapy) | Incentive
 |  | Tier 1 - 0 to 130,000 | 0 |  |  |  |  |  | 0 | 0
 |  | [NAME] to 150,000 | 0.014 |  |  |  |  |  | 130001 | 0.014
 |  | [NAME] to 160,000 | 0.024 |  |  |  |  |  | 150001 | 0.024
 |  | [NAME] and ABOVE | 0.034 |  |  |  |  |  | 160001 | 0.034
Doctor Calculation
 |  | Total Revenue | 164284.37
 |  | Amount to be paid
 |  | Total Amount to be Paid |  | I need one formula in D23 the result as per tier - if the revenue is 160k above will multiply to 3.4% and so on
 |  | Consumables up to 25% to be deducted, over 25% the difference is absorbed by the doctor
 |  | Skin Care Revenue | 42900
 |  | Consumables< =25% | 10725
 |  | Net Revenue |  | I need one formula in Column D30 the result if the skin care revenue is 25 % of the consumables it will be consumables will be deducted ,  and if less than 25 it will not be deducted
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 679206d1590254065-how-to-search-2-columns-for-the-information-entered-in-one-column-samplefile
Sheet: data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
ITEM NO | Cost Centre | [NAME] | UM | Qty | Price | Extended Cost | [NAME] | Catalog No | Par [NAME] | Line No | Par Name | UM 1 Contains | UM 2 Contains | UM 3 Contains | Latex Indicator | [NAME] | Qty in lowest UOU | PRICE EACH
172 | LHS1411500 | BATTERY ENERGIZER D | EA | 12 | 1 | 11.4 | 8 HMW CDC | 574-EN95 | NULL | 17 | UH2 VAC BATTERY GLOVES Par Form Template | EA = 1 EA | PK = 12 EA | CA = 6 PK | N | 1 | 1
173 | LHS1411500 | BATTERY ENERGIZER C | EA | 12 | 1 | 999 | 8 HMW CDC | 574-EN93 | NULL | 16 | UH2 VAC BATTERY GLOVES Par Form Template | EA = 1 EA | PK = 12 EA | CA = 6 PK | N | 1 | 1
174 | LHS1411500 | BATTERY ENERGIZER AA | EA | 24 | 1 | 7.68 | 8 HMW CDC | 574-EN91 | NULL | 14 | UH2 VAC BATTERY GLOVES Par Form Template | EA = 1 EA | PK = 24 EA | CA = 6 PK | N | 1 | 1
175 | LHS1411500 | BATTERY ENERGIZER AAA | EA | 24 | 1 | 8.64 | 8 HMW CDC | 574-EN92 | NULL | 15 | UH2 VAC BATTERY GLOVES Par Form Template | EA = 1 EA | PK = 24 EA | CA = 6 PK | N | 1 | 1
176 | LHS1411500 | BATTERY ENERGIZER 9 VOLT | EA | 12 | 1 | 15.24 | 8 HMW CDC | 574-EN22 | NULL | 13 | UH2 VAC BATTERY GLOVES Par Form Template | EA = 1 EA | PK = 12 EA | CA = 6 PK | N | 1 | 1
Spreadsheet: 128668d1321182277-lookup-with-true-a-and-h-copy-of-example1
Sheet: Sheet1

 |  |  | Need help on H=Home and A= [NAME] like you see colour. Example 12 v 1.    12 is Home=H and 1 is Away=A? It would be great help to explain how to do {=formula} Cheers
 |  | Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | [NAME] | out
 |  | Date | 2011-10-20 00:00:00 | 2011-10-27 00:00:00 | 2011-11-10 00:00:00 | 2011-11-24 00:00:00 | 2011-12-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-15 00:00:00 | 2011-12-29 00:00:00 | 2012-01-05 00:00:00 | 2012-01-12 00:00:00 | 2012-01-19 00:00:00 | 2012-01-26 00:00:00 | 2012-02-02 00:00:00 | 2012-02-09 00:00:00 | 2012-02-16 00:00:00 | 2012-02-23 00:00:00 | 2012-03-01 00:00:00 | 2012-03-08 00:00:00 | 2012-03-15 00:00:00 | 2012-03-22 00:00:00 | 2012-03-29 00:00:00 | 2012-04-05 00:00:00 | 1st | 2nd
 | 1 |  | A
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12 |  | H
 | 1 | Derbys
 | 2 | Hull
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | Doncaster
 | 6 | Leeds
 | 7 | Bradford
 | 8 | Leicester
 | 9 | Sheffield
 | 10 | Barnsley
 | 11 | Birmingham
 | 12 | Chesterfield
 |  |  | 12 v 1 | 5 v 7 | 10 v 1 | 4 v 6 | 12 v 10 | 5 v 3 | 6 v 1 | 3 v 12 | 8 v 12 | 8 v 7 | 2 v 1 | 1 v 12 | 7 v 5 | 10 v 12 | 6 v 4 | 1 v 10 | 3 v 5 | 12 v 3 | 1 v 6 | 12 v 8 | 7 v 8 | 1 v 2
 |  |  | 11 v 2 | 4 v 8 | 9 v 2 | 3 v 7 | 8 v 1 | 2 v 6 | 5 v 2 | 2 v 4 | 4 v 1 | 9 v 6 | 6 v 8 | 2 v 11 | 8 v 4 | 1 v 8 | 7 v 3 | 2 v 9 | 6 v 2 | 4 v 2 | 2 v 5 | 1 v 4 | 6 v 9 | 8 v 6
 |  |  | 3 v 10 | 3 v 9 | 8 v 3 | 2 v 8 | 7 v 2 | 1 v 7 | 4 v 3 | 1 v 5 | 3 v 2 | 12 v 2 | 5 v 9 | 10 v 3 | 9 v 3 | 2 v 7 | 8 v 2 | 3 v 8 | 7 v 1 | 5 v 1 | 3 v 4 | 2 v 3 | 2 v 12 | 9 v 5
 |  |  | 9 v 4 | 2 v 10 | 7 v 4 | 1 v 9 | 3 v 6 | 11 v 8 | 8 v 10 | 11 v 6 | 7 v 9 | 1 v 3 | 4 v 10 | 4 v 9 | 10 v 2 | 6 v 3 | 9 v 1 | 4 v 7 | 8 v 11 | 6 v 11 | 10 v 8 | 9 v 7 | 3 v 1 | 10 v 4
 |  |  | 8 v 5 | 1 v 11 | 6 v 5 | 11 v 10 | 5 v 4 | 10 v 9 | 7 v 11 | 10 v 7 | 6 v 10 | 11 v 4 | 3 v 11 | 5 v 8 | 11 v 1 | 4 v 5 | 10 v 11 | 5 v 6 | 9 v 10 | 7 v 10 | 11 v 7 | 10 v 6 | 4 v 11 | 11 v 3
 |  |  | 7 v 6 | 6 v 12 | 12 v 11 | 5 v 12 | 9 v 11 | 4 v 12 | 12 v 9 | 9 v 8 | 5 v 11 | 10 v 5 | 7 v 12 | 6 v 7 | 12 v 6 | 11 v 9 | 12 v 5 | 11 v 12 | 12 v 4 | 8 v 9 | 9 v 12 | 11 v 5 | 5 v 10 | 12 v 7
Spreadsheet: 829149d1683970379-find-missing-number-and-name-test-missing-code-name-from-sheet-2
Sheet: Sheet2

Code | Name
6110 | Art
6120|6130 | Music
7110|7190|7192|7225|7271|7850|7880|7894|7895|7896|9245 | Design
7120|7130 | Roadblocks
7230|7240|7250|7260
7810|7820|7830|7840
7210
7220
7281|7282|7283|7284|7285|7288
7272
[NAME]
8210|8215
8220|8225
8230|8235
8240|8241|8242|8243
8250|8255|8289
8301|8302|8303|8304|8305|8306|8310|8315|8320|8321|8323|8325|8340|8345
FL
8365|8370|8375|8380|8389
8385|8405|8410|8415
8401
8420|8425|8445|8840
8430|8440|8850|8855
8455|8460|8465|8470|8475|8480|8485
8510|8515|8520|8525|8530|8535|8540|8545|8550|8555|8560|8575|8580|8585|9255|9260|9261|9262|9291|9292|9293
8610|8620|8630
8810|8820|8830
9005
9110|9120|9130|9140
7265|7270|9171|9175|9185|9180
9205
9215
9210|9220|9225
9195
Spreadsheet: 99998d1298490774-unable-to-create-macro-due-to-varying-data-example-data-1
Sheet: Sheet1

Data I have….
Number | Attribute | Value
1 | Color | Yellow
1 | Store | [NAME]
1 | Brand | Chiquita
1 | Fruit | [NAME]
2 | Weight | 3 oz
2 | Brand | Chiquita
2 | Color | Green
2 | Fruit | [NAME]
3 | Origin | New Hampshire
3 | Fruit | Apple
3 | Color | Green
3 | Brand | Washington
4 | Brand | Fuji
4 | Store | Whole Foods
4 | Weight | 5 oz
4 | Fruit | Apple
4 | Color | Red
Needs to look like….
Number | Fruit | Value | Brand | Color
1 | [NAME] |  | Chiquita | Yellow
1 |  | [NAME]
2 | [NAME] |  | Chiquita | Green
2 |  | 3 oz
3 | Apple |  | Washington | Green
3 |  | New Hampshire
4 | Apple |  | Fuji | Red
4 |  | 5 oz
4 |  | Whole Foods
Spreadsheet: 874257d1720810615-modify-vlookup-on-the-fly-wordpress-export
Sheet: Wordpress Export

Your Group ID | Category | Group's Title | Leader: Full Name | Phone: | We Meet: | Start Month | Start Date
GP086 | Science & Computing | Digital Workshop | [NAME] | 07582 319439 | 4th Fri 14:00-16:00 | Sep | 27
GP091 | Crafts & Photography | Photography | [NAME] | 07343 985148 | 1st Tue 10:00-12:00 | Oct | 1