tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: james_steffes__12800__Gas collateral
Sheet: Sheet1

Market | Companies | Collateral | Comments | Contact
Peoples Energy | Peoples Gas | $0.3 Million | Need to split among EES & EEMC, for | [NAME]
 | North Shore |  | Peoples and North Shore, and for small | [PHONE]
 |  |  | and large customer programs.
Etown |  | $0.25 Million | Scheduled for payment 12/20 | [NAME]
 |  |  |  | [PHONE]
NICOR |  | Under Review | Nothing requested yet but they are | [NAME]
 |  |  | studying. | [PHONE]
SDGE |  | $6.75 Million | Due Dec 29, for CAT program, described | [NAME]
 |  |  | in 12/14 letter to [NAME]. | [PHONE]
PG&E |  | $7.3 Million | Core customers already taken back; | [NAME]
 |  |  | need to renegotiate agreement | [PHONE]
SoCal |  | $3.0 Million | Request filed by SoCal in bankruptcy | [NAME]
 |  |  | court 12/14. | [PHONE]
NIMO |  | $3.5 Million | Includes $0.6 million for pre-petition | [NAME]
 |  |  | arrearage. | [PHONE]
NYSEG
 |  |  |  | [PHONE]
Columbia of OH |  | ? | Requirement transmitted in letter to | Penny Price
 |  |  | [NAME] around 12/7 | [PHONE]
East Ohio Gas
SW Nevada
N Penn
[NAME]
Peoples Natural PA
CG&E
New Jersey Natural |  | $1.0 Million | Additional $1.0 if we need to go back to | [NAME]
 |  |  | consolidated billing | [PHONE]
Spreadsheet: jeff_dasovich__14096__PG&E Data
Sheet: Load Summary

Pacific Gas & Electric
Gas Sales & Throughput Summary
 | Gas Sales |  | Transport Only |  | Totals
1999 | Thru-put | Revenue | Thru-put | Revenue | Thru-put | Revenue
 | Bcf | $ [NAME] | Bcf | $ [NAME] | Bcf | $ [NAME]
Residential | 234 | 1543
Commercial | 70 | 449
Industrial | 5 | 24
Transport Only |  |  | 484 | 1996
TOTAL:
 | Gas Sales |  | Transport Only |  | Totals
1998 | Thru-put | Revenue | Thru-put | Revenue | Thru-put | Revenue
 | Bcf | $ [NAME] | Bcf | $ [NAME] | Bcf | $ [NAME]
Residential | 224 | 1414
Commercial | 66 | 426
Industrial | 5 | 26
Transport Only |  |  | 397 | 1733
TOTAL:
 | Gas Sales |  | Transport Only |  | Totals
1997 | Thru-put | Revenue | Thru-put | Revenue | Thru-put | Revenue
 | Bcf | $ [NAME] | Bcf | $ [NAME] | Bcf | $ [NAME]
Residential | 191 | 1170
Commercial | 61 | 374
Industrial | 10 | 51
Transport Only |  |  | 452 | 1804
TOTAL:
Spreadsheet: 34a3cee4-2133-4220-b6d2-8eeddf47ca53
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0023580 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] on Lake Norman | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Iredell | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 00620 | 00400 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Fecal Coliform | Ammonia | Nitrate | pH | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | NTU
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Recorder
Monthly Limit: |  |  | 7200 | 10 | 14 | 4 |  |  | 5
Daily Limit: |  |  |  | 15 | 25 | 6 |  | 6-9 | 10 | 10
Sample Frequency: |  |  | [NAME] | Monthly | Monthly | Monthly | Monthly | Weekly | Monthly | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 879409d1726898954-how-to-vlook-up-one-cell-from-a-sheet-to-show-the-whole-row-on-another-sheet-need-help-version-with-anotation
Sheet: FINAL Attendance

 | Day 26 |  |  | DAY 27 |  |  | DAY 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME |  |  | OVERTIME |  |  | OVERTIME |  |  | OVERTIME |  |  | TOTAL OVERTIME | TOTAL HOURS | DAYS OF WORK
Biometrics | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day |  | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day
WCVSalmo | 06:52:00 |  |  | 06:52:00 |  |  | 06:52:00
JZTabid2 |  |  |  | 04:53:00
ATOmac |  |  |  | 6:17AM |  |  | 06:49:00
RRMaandig |  |  |  | 04:52:00
RASajonia
RDAniel | 08:16:00 |  |  | 08:16:00 |  |  | 08:16:00
Spreadsheet: 696790d1600973313-adding-different-values-based-on-five-different-cells-keith-biro-example
Sheet: Info Plug

EE Category | Medical Plan Choice |  |  | Dental | Dental | Vision | Vision
EMPLOYEE | MIEEE2180 | SUB | 47.54 | SUB | 11.05 | SUB | 1.43
EMPLOYEE | MIEEE2180 | SPS | 309.91 | SPS | 22.44 | SPS | 2.41
EMPLOYEE | MIEEE2180 | CH1+ | 234.86 | CH1+ | 23.28 | CH1+ | 2.46
EMPLOYEE | MIEEE2180 | SPS+ | 465.91 | SPS+ | 36.54 | SPS+ | 3.89
EMPLOYEE | MIESA2110 | SUB
EMPLOYEE | MIESA2110 | SPS | 340.36
EMPLOYEE | MIESA2110 | CH1+ | 257.94
EMPLOYEE | MIESA2110 | SPS+ | 511.69
EMPLOYEE | MIBCO2050 | SUB | 114.16
EMPLOYEE | MIBCO2050 | SPS | 448.64
EMPLOYEE | MIBCO2050 | CH1+ | 339.99
EMPLOYEE | MIBCO2050 | SPS+ | 674.46
Salaried MGR | MIEEE2180 | SUB | 0 | SUB | 0 | SUB | 0
Salaried MGR | MIEEE2180 | SPS | 115.73 | SPS | 5.7 | SPS | 0.49
Salaried MGR | MIEEE2180 | CH1+ | 78 | CH1+ | 6.12 | CH1+ | 0.52
Salaried MGR | MIEEE2180 | SPS+ | 193.53 | SPS+ | 12.75 | SPS+ | 1.23
Salaried MGR | MIESA2110 | SUB | 0
Salaried MGR | MIESA2110 | SPS | 126.88
Salaried MGR | MIESA2110 | CH1+ | 85.66
Salaried MGR | MIESA2110 | SPS+ | 212.54
Salaried MGR | MIBCO2050 | SUB | 0
Salaried MGR | MIBCO2050 | SPS | 167.24
Salaried MGR | MIBCO2050 | CH1+ | 112.91
Salaried MGR | MIBCO2050 | SPS+ | 280.15
SR Leadership | MIEEE2180 | SUB | 0 | SUB | 0 | SUB | 0
SR Leadership | MIEEE2180 | SPS | 115.73 | SPS | 5.7 | SPS | 0.49
SR Leadership | MIEEE2180 | CH1+ | 78 | CH1+ | 6.12 | CH1+ | 0.52
SR Leadership | MIEEE2180 | SPS+ | 193.53 | SPS+ | 12.75 | SPS+ | 1.23
SR Leadership | MIESA2110 | SUB | 0
SR Leadership | MIESA2110 | SPS | 126.88
SR Leadership | MIESA2110 | CH1+ | 85.66
SR Leadership | MIESA2110 | SPS+ | 212.54
SR Leadership | MIBCO2050 | SUB | 0
SR Leadership | MIBCO2050 | SPS | 167.24
SR Leadership | MIBCO2050 | CH1+ | 112.91
SR Leadership | MIBCO2050 | SPS+ | 280.15
Spreadsheet: 830808d1685122352-combining-order-data-from-multiple-rows-into-single-row-s666-pq-combining-order-data-from-multiple-rows-into-single-row
Sheet: Sheet1

Current |  |  | Desired
Order | Item |  | Order | Item | Order | List
ABC124 | milk |  | ABC124 | milk; bread | ABC124 | bread,milk
ABC124 | bread |  | ABC125 | cheese; meat; crackers; juice; cookies; bread; candy; pizza; milk | ABC125 | bread,candy,cheese,cookies,crackers,juice,meat,milk,pizza
ABC125 | cheese |  | ABC126 | donuts | ABC126 | donuts
ABC125 | meat |  | ABC127 | apples; oranges | ABC127 | apples,oranges
ABC125 | crackers
ABC125 | juice
ABC125 | cookies
ABC125 | bread
ABC125 | candy
ABC125 | pizza
ABC125 | milk
ABC126 | donuts
ABC127 | apples
ABC127 | oranges
Spreadsheet: 454813d1459977148-populating-ranking-depending-upon-ranges-of-previous-cells-data-copy-of-risk-assessment
Sheet: Sheet1

Risk Assessment
DEPARTMENT: |  |  | RESPONSIBLE INDIVIDUAL
Low Risk (1) | The loss of confidentiality,l integrity, or availability could be expected to have a limited adverse effect on organizational operations, organizational assets, or individuals.
Medium Risk (2) | The loss of confidentiality, integrity, or availability could be expected to have a serious adverse effect on organizational operations, organizational assets, or individuals
High Risk (3) | The loss of confidentiality, integrity, or availability could be expected to have a severe or catastrophic adverse effect on organizational operations, organizational assets, or individuals.
Risk Response | Accept or [NAME] (0)        Reduce (2)     Avoid (3)
Risk Rating | 0-45% Low (1)   46-67% Med (2) or 68-100% High (3)
Risk Category | Risk | Mitigation Efforts | Probability | Impact | Inherent Risk | Residual Risk | Residual Risk Comments | Risk Response | Risk Mitigation Effect
RISK 1 |  |  | 1 | 1 | 1 | 1 |  | 0
Sum
Average
Risk Rating |  |  |  |  |  |  |  | 1 | 1
RISK 2
Sum
Average
Risk Rating
RISK 3 |  |  | 1 | 1 | 1 | 1 |  | 0
Sum
Average
Risk Rating |  |  | 1 | 1 | 1 | 1 |  | 1 | 1
RISK 4
Sum
Average
Risk Rating
RISK 5 |  |  | 1 | 1 | 1 | 1 |  | 0
 |  |  | 1 | 1 | 3 | 1 |  | 0 | 0
Sum
Average
Risk Rating |  |  | 1 | 1 | 1 | 1 |  | 1 | 1
RISK 6 |  |  | 1 | 2 | 1 | 1 |  | 0
Sum
Average
Risk rating |  |  | 1 | 2 | 1 | 1 |  | 1 | 1
RISK 7
Sum |  |  |  |  |  |  |  | 0
Average
Risk Rating
Spreadsheet: 713737d1610902534-extract-unique-times-only-remove-duplicates-duplicates_times_remove
Sheet: Sheet6

Start Time - Standard | End Time - Standard |  | Sort 1 | Sort 2 | Unique 1 | Unique 2
09:00:00 | 17:00:00 | 1 |  |  |  | 07:30:00
09:00:00 | 18:00:00 | 2 |  |  | 09:00:00 | 08:00:00
17:00:00 | 23:00:00 | 3 |  |  | 10:00:00 | 08:30:00
20:30:00 | 08:30:00 | 4 |  |  | 11:00:00 | 09:00:00
13:00:00 | 08:00:00 | 5 |  |  | 13:00:00 | 12:00:00
10:00:00 | 22:00:00 | 6 |  |  | 14:00:00 | 14:30:00
23:00:00 | 09:00:00 | 7 |  |  | 15:00:00 | 16:30:00
14:00:00 | 16:30:00 | 8 |  |  | 17:00:00 | 17:00:00
15:00:00 | 19:00:00 | 9 |  |  | 20:30:00 | 18:00:00
11:00:00 | 19:00:00 | 10 |  |  | 23:00:00 | 19:00:00
20:30:00 | 07:30:00 | 11 |  |  |  | 22:00:00
09:00:00 | 14:30:00 | 12 |  |  |  | 23:00:00
08:00:00 | 12:00:00 | 13
Spreadsheet: 696834d1600999608-how-to-efficiently-manage-trapping-value-and-n-a-errors-example-level-1-10-country-carnival-and-level-6-10-state-challenge-7th-and-8th-november-202
Sheet: Floor

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Superhero Artistic Floor Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award | Scratch | Award Bagged
Club | Comp Number | First Name | Last Name | Level | Judge 1 | Judge 2 | D Score | Neutral Deduction | Average | Score | [NAME] | Superhero Artistic Floor | Sportmanship | Superhero Costume | Scratch | Award Bagged
ABC | 1111 | Gymnast | One | 3 |  |  | 10
ABC | 2222 | Gymnast | Two | 4 | 1 |  | 10
ABC | 3333 | Gymnast | Three | 5 |  |  | 10
XYZ | 9999 | Gymnast | One | 3 | 1 |  | 10
XYZ | 8888 | Gymnast | Two | 3 | 2 | 1.5 | 10
XYZ | 7777 | Gymnast | Three | 4 | 3 |  | 10
XYZ | 6666 | Gymnast | Four | 4 | 2 |  | 10
XYZ | 5555 | Gymnast | Five | 5 |  |  | 10
XYZ | 4444 | Gymnast | Six | 5 |  |  | 10
Spreadsheet: 822358d1679303624-formula-index-and-match-pontaj-2023-draft
Sheet: FEBRUARIE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date to Find | 2023-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Found in
 |  | DATE | 2023-02-01 00:00:00
 |  | NORM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM |  |  | S | P | Z | N | H
 | 1 | 111 | Jhon | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S
 | 2 | 112 | [NAME] | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H
 | 3 | 113 | Adalyn | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N
 | 4 | 114 | [NAME] | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z
 | 5 | 115 | Beverly | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P
Spreadsheet: 0baf59f2-a56c-4046-bd67-49609a6b2ce2
Sheet: Sheet1

2687 671 [NAME]–Kiskunlacháza–Ráckeve | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
(Érvényes: 2011. december 11-től)
 |  |  |  |  | 671 | 671 | 671 | 671 | 671
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2 | 4 | 6 | 8 | 10
 |  |  |  |  | M | A | N | M | A
0 | 0 | .. | .. | [NAME], [NAME] 136. | 06:20:00 | 06:55:00 | 08:35:00 | 13:55:00 | 17:55:00
0.3 | 0.3 | .. | .. | [NAME], [NAME] | [NAME] | 06:56:00 | 08:36:00 | 13:56:00 | 17:56:00
0.9 | 0.9 | .. | .. | [NAME], vá. [NAME]. | 06:22:00 | [NAME] | 08:37:00 | 13:57:00 | 17:57:00
1.4 | 1.4 | .. | .. | [NAME], [NAME]. | 06:23:00 | 06:58:00 | 08:38:00 | 13:58:00 | 17:58:00
4.2 | 4.2 | .. | .. | Apaji ÁG. [NAME] | [NAME] | 07:01:00 | 08:41:00 | 14:01:00 | 18:01:00
7.6 | 7.6 | .. | .. | Szürük tanya | 06:30:00 | 07:05:00 | 08:45:00 | 14:05:00 | 18:05:00
10.2 | 10.2 | .. | .. | Kiskunlacháza, ráckevei elág. | 06:33:00 | 07:08:00 | 08:48:00 | 14:08:00 | 18:08:00
11.9 | 11.9 | .. | .. | Kiskunlacháza, szoc. otthon | 06:36:00 | 07:11:00 | [NAME] | 14:11:00 | 18:11:00
14.2 | 14.2 | .. | .. | Peregi hídfő | 06:40:00 | 07:15:00 | 08:55:00 | 14:15:00 | 18:15:00
S | 14.6 | .. | .. | Ráckeve, strand | 06:41:00 | 07:16:00 | S | 14:16:00 | 18:16:00
S | 15.2 | .. | .. | Ráckeve, sportpálya | 06:42:00 | [NAME] | S | 14:17:00 | 18:17:00
S | 15.8 | .. | .. | Ráckeve, [NAME] | 06:43:00 | [NAME] | S | 14:18:00 | 18:18:00
S | 15.8 | .. | .. | Ráckeve, [NAME] | 06:44:00 | 07:19:00 | S | 14:19:00 | 18:19:00
S | 16.4 | .. | .. | Ráckeve, sportpálya | 06:45:00 | 07:20:00 | S | 14:20:00 | 18:20:00
S | 17 | 0 | .. | Ráckeve, strand | [NAME] | 07:21:00 | S | 14:21:00 | 18:21:00
S | S | 1.2 | .. | Ráckeve, [NAME]. István tér | 06:48:00 | S | S | 14:23:00 | 18:23:00
14.7 | 17.7 | 1.7 | .. | Ráckeve, hídfő | 06:50:00 | [NAME] | 08:57:00 | 14:25:00 | 18:25:00
14.9 | 17.9 | .. | .. | Ráckeve, [NAME] köz | 06:51:00 | 07:23:00 | [NAME] | 14:26:00 | 18:26:00
15.3 | 18.3 | .. | .. | Ráckeve, gimnázium | 06:52:00 | 07:24:00 | 08:59:00 | 14:27:00 | 18:27:00
16.3 | 19.3 | .. | .. | Ráckeve, vá. | 06:53:00 | 07:25:00 | 09:00:00 | 14:28:00 | 18:28:00
.. | .. | .. | .. | Ráckeve    (Vasúti csatlakozás!) | 07:13:00 |  | 09:13:00
.. | .. | .. | .. | Budapest, Közvágóhíd | 08:24:00 |  | 10:24:00
[NAME]:
M | munkanapokon
A | szabad- és [NAME]
N | munkaszüneti nap kivételével naponta
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: 134583d1325494535-help-needed-for-total-formula-master-bill
Sheet: 5

Newspaper | Price | Quantity | Return | Total
 |  |  |  |  |  |  | Selling Price | P.P.P | Profit
Value 1
Value 2
Value 3 |  |  |  |  |  |  |  |  |  |  | Total Collection
Value 4 |  |  |  |  |  |  |  |  |  |  | Salary
Value 5 |  |  |  |  |  |  |  |  |  |  | Received Collection
Value 6 |  |  |  |  |  |  |  |  |  |  | Balance |  | Balance Need to Added
Value 7 |  |  |  |  |  |  |  |  |  |  | Paid to [NAME]
Value 8
Value 9 |  |  |  |  |  |  |  |  |  |  | Grand Total
Value 10
Value 11
Value 12
 |  |  | Total |  |  |  |  | Total
 |  |  |  |  |  |  | * P.P.P = Per Paper Profit
Spreadsheet: 98954cb8-3afb-4121-8b9a-3eab59f45147
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
[NAME] |  |  |  | ([NAME] when moving budgeted funds from one fund, organization or account to another)
[NAME] |  |  |  | ([NAME] when moving an expenditure amount that has already been posted)
Note:  Please submit your transfer request to the Bursar & Budget Director in the Business Office.
Fiscal Year: _____________________
FROM |  |  |  |  |  |  |  | TO
Fund |  | Organization |  | Account |  | Amount |  | Fund |  | Organization |  | Account |  | Amount
Number |  | Number |  | Number |  |  |  | Number |  | Number |  | Number
JUSTIFICATION - (Please state why the transfer is necessary)
Department Head: |  |  |  | ____________________________________________________ |  |  |  |  |  |  |  | Date: ___________________
Division Chairman: |  |  |  | ____________________________________________________ |  |  |  |  |  |  |  | Date: ___________________
Appropriate Administrative Officer: |  |  |  | ____________________________________________________ |  |  |  |  |  |  |  | Date: ___________________
Budget Director: |  |  |  | ____________________________________________________ |  |  |  |  |  |  |  | Date: ___________________
Spreadsheet: 167247d1341933384-data-validation-dependent-on-other-validation-pipe-calculations
Sheet: Pipe Pressure Drop

*Pressure Drop in psig/ft for Nominal Pipe Sizes*
[NAME] (in) | Internal Diameter |  |  |  | Reynolds Number |  |  |  | Friction Factor |  |  |  | Pressure [NAME] (psig/ft)
 | Sch. 40 | Sch. 80 | Sch. 160 | [NAME] | Sch. 40 | Sch. 80 | Sch. 160 | [NAME] | Sch. 40 | Sch. 80 | Sch. 160 | [NAME] | Sch. 40 | Sch. 80 | Sch. 160 | [NAME]
0.125 |  |  | - | - |  |  | - | - |  |  | - | - |  |  | - | -
0.25 |  |  | - | - |  |  | - | - |  |  | - | - |  |  | - | -
0.375 |  |  | - | - |  |  | - | - |  |  | - | - |  |  | - | -
0.5
0.75
1
1.25
1.5
2
2.5
3
3.5 |  |  | - | - |  |  | - | - |  |  | - | - |  |  | - | -
4
5
*Formulae for Reynolds Number, Friction Factor, and Pressure [NAME]  are taken from Fluid Power Designers' Lightning Reference Handbook 8th ed. and are provided on the "Calcs" Sheet.
Spreadsheet: 106603d1303838986-unique-phone-numbers-yp-incoming-calls-1-day92
Sheet: Volume of Calls

 | Is the number of unique Descriptions in column E on the All Calls Sheet
118247 Car Dealers New
YP-Motability
YP Lineage
YP - Garage Services
YP - Car Dealers New
yeomans.co.uk
Yellow Pages
Yell.Com - New Cars
yell.com - Garage Services
y.co.uk-AutoTrader click
Vcars
SmartMail eGM
Service Reminders
Rear window stickers
Leons Motability Letter
Doctor [NAME] MOTAB
CEMETERY Club
Call View - old numbers
AutoTrader.co.uk
118247 Garage Servcies
Spreadsheet: 758746d1639050811-nested-if-else-statement-solution-sample
Sheet: Sheet1

Sl No | Sales Agent | Sales Target | Sales Achieved | % Target achieved | Commission
1 | [NAME] | 12000 | 11566
2 | Ganesh Gaitonde | 15000 | 7804 |  |  |  |  | Rules
3 | [NAME] | 7000 | 6051 |  |  |  |  | If Target achieved is less than 40%, then Commission paid is 5%
4 | [NAME] | 10000 | 4679 |  |  |  |  | If Target achieved is between 40 to 100%; 10% of Sale Amount is paid
5 | Anjali Mathur | 8000 | 2367 |  |  |  |  | If Target achieved is more than 100%; 15% is paid as bonus + 5,000 as Promotion bonus
6 | [NAME] | 10000 | 8789
7 | Mathu | 5000 | 3210
8 | [NAME] | 5000 | 4567
9 | Bunty | 9000 | 7456
10 | Isa | 10000 | 4918
11 | [NAME] | 8000 | 6108
12 | [NAME] | 20000 | 7607
13 | Trivedi | 10000 | 11890
14 | Kamble | 7000 | 5274
15 | [NAME] | 5000 | 3091
Spreadsheet: 219247d1362690807-lookup-values-in-one-spreadsheet-and-automatically-input-into-another-spreadsheet-customer-summary-excel-help
Sheet: 2CUST

ICCID | Voice Number | Customer Code (Preferred) | Usage Amount
898709906442121796 | [PHONE] | 2CUST1 | 30.8
898709906442121846 | [PHONE] | 2CUST2 | 37.96
898709906442121847 | [PHONE] | 2CUST3 | 53.9
898709906442121848 | [PHONE] | 2CUST4 | 2.19
898709906442121849 | [PHONE] | 2CUST5 | 12.48
898709906442121850 | [PHONE] | 2CUST6 | 13.45
898709906442121851 | [PHONE] | 2CUST7 | 17.2
898709906442121852 | [PHONE] | 2CUST8 | 109.3
898709906442121972 | [PHONE] | 2CUST9
898709906442121973 | [PHONE] | 2CUST10 | 7.8
898709906442121974 | [PHONE] | 2CUST11
898709906442121976 | [PHONE] | 2CUST12
898709906442121978 | [PHONE] | 2CUST13 | 3.12
898709906442121979 | [PHONE] | 2CUST14 | 0.49
898709906442121980 | [PHONE] | 2CUST15 | 19.54
898709906442121981 | [PHONE] | 2CUST16 | 6.82
898709906442121982 | [PHONE] | 2CUST17
898709906442121983 | [PHONE] | 2CUST18
898709906442121984 | [PHONE] | 2CUST19
898709906442121989 | [PHONE] | 2CUST20 | 12.91
898709906442121991 | [PHONE] | 2CUST21
898709906442122061 | [PHONE] | 2CUST22 | 0.73
898709906442122067 | [PHONE] | 2CUST23 | 32.12
898709906442122129 | [PHONE] | 2CUST24 | 42.89
898709906442122151 | [PHONE] | 2CUST25 | 16.42
898709906442122153 | [PHONE] | 2CUST26 | 8.82
898709906442122154 | [PHONE] | 2CUST27 | 1.46
898709906442122162 | [PHONE] | 2CUST28
898709906442122163 | [PHONE] | 2CUST29
898709906442122164 | [PHONE] | 2CUST30
898709906442122169 | [PHONE] | 2CUST31 | 5.85
898709906442122207 | [PHONE] | 2CUST32
898709910412452805 | [PHONE] | 2CUST33
898709910412452807 | [PHONE] | 2CUST34 | 17.98
898709910412452813 | [PHONE] | 2CUST35
898709910412452815 | [PHONE] | 2CUST36
898709910412452816 | [PHONE] | 2CUST37 | 7.75
898709910412452818 | [PHONE] | 2CUST38 | 1.36
898709910412452829 | [PHONE] | 2CUST39 | 3.51
898709910412452837 | [PHONE] | 2CUST40 | 436.53
898709910412452858 | [PHONE] | 2CUST41 | 8.97
898709910412452879 | [PHONE] | 2CUST42
898709910412453552 | [PHONE] | 2CUST43
898709910412453554 | [PHONE] | 2CUST44
898709910412453559 | [PHONE] | 2CUST45
898709911412504691 | [PHONE] | 2CUST46 | 183.32
898709911412504692 | [PHONE] | 2CUST47 | 21.64
898709911412504693 | [PHONE] | 2CUST48 | 2.05
898709911412504694 | [PHONE] | 2CUST49