tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 711536d1609774608-tracking-total-hours-per-year-between-two-parties-sample
Sheet: Time Data

 | Pick Up Time | Pick Up Location | Drop Off Time | Drop Off Location | My Time | Her Time
 | 2019-11-29 10:00:00 | Location A | 2019-12-01 17:00:00 | Location C
 | 2019-12-04 14:30:00 | - | 2019-12-04 16:30:00 | - |  |  |  |  | My Time | Her Time
 | 2019-12-13 17:15:00 | Location B | 2019-12-15 18:00:00 | Location E |  |  |  | 2019
 | 2019-12-17 17:00:00 | Location B | 2019-12-18 17:00:00 | Location A |  |  |  | 2020
 | 2019-12-21 15:30:00 | Location B | 2019-12-23 15:30:00 | Location B
 | 2019-12-25 11:00:00 | Location A | 2019-12-27 15:00:00 | Location B
 | 2019-12-31 13:30:00 | Location A | 2020-01-01 00:00:00 | - |  |  |  | 2020 Total Hours
 | 2020-01-01 00:00:00 | - | 2020-01-06 18:00:00 | Location C
 | 2020-01-17 18:00:00 | Location C | 2020-01-19 20:00:00 | Location A
 | 2020-01-30 18:30:00 | Location C | 2020-02-01 19:00:00 | Location A
 | 2020-02-14 18:00:00 | Location C | 2020-02-17 17:00:00 | Location A
 | 2020-02-28 15:00:00 | Location A | 2020-03-01 20:00:00 | Location C
 | 2020-03-13 21:00:00 | Location A | 2020-03-22 20:00:00 | Location C
 | 2020-04-03 17:00:00 | Location C | 2020-04-15 23:00:00 | Location A
b | 2020-04-23 14:00:00 | Location A | 2020-04-28 16:30:00 | Location A
s | 2020-04-28 16:30:00 | Location A | 2020-05-03 20:00:00 | Location A
s | 2020-05-03 20:00:00 | Location A | 2020-05-09 15:00:00 | Location C
 | 2020-05-09 15:00:00 | Location C | 2020-05-17 20:30:00 | Location A
 | 2020-05-25 19:30:00 | Location C | 2020-05-31 16:00:00 | Location A
 | 2020-06-09 17:00:00 | Location B | 2020-06-14 22:00:00 | Location A
 | 2020-06-19 21:00:00 | Location A | 2020-07-14 16:00:00 | Location C
* | 2020-07-26 14:00:00 | Location B | 2020-07-30 21:00:00 | Location B
 | 2020-08-03 13:30:00 | Location D | 2020-08-09 17:00:00 | Location A
 | 2020-08-13 11:00:00 | Location C | 2020-08-23 20:30:00 | Location G
 | 2020-08-29 18:30:00 | Location B | 2020-09-07 18:30:00 | Location B
 | 2020-09-13 19:00:00 | Location F | 2020-09-20 19:30:00 | Location B
 | 2020-09-27 14:00:00 | Location B | 2020-10-05 19:15:00 | Location B
 | 2020-10-11 12:00:00 | Location C | 2020-10-18 20:00:00 | Location C
 | 2020-10-25 14:30:00 | Location A | 2020-11-04 16:00:00 | Location C
 | 2020-11-13 15:30:00 | Location A | 2020-11-15 16:30:00 | Location B
 | 2020-11-20 13:00:00 | Location F | 2020-11-22 20:30:00 | Location A
 | 2020-11-27 13:30:00 | Location A | 2020-11-30 18:00:00 | Location B
 | 2020-12-03 15:00:00 | Location B | 2020-12-06 16:00:00 | Location A
 | 2020-12-11 14:00:00 | Location C | 2020-12-16 18:00:00 | Location A
 | 2020-12-23 20:00:00 | Location D | 2021-01-01 00:00:00 | -
 | 2021-01-01 00:00:00 | - | 2021-01-05 10:00:00 | Location A
Spreadsheet: daren_farmer__6599__egmnom-Feb
Sheet: RHODIA

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-011
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB
METER # | [NAME] | SUPPLIER | 1
4132 | EXXON KATY | [NAME] (MIDCON 92155) | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
8078 | RHODIA-FREEPORT | RHODIA-FREEPORT | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 60f1f268-3cc1-43f5-a23e-f0a459bc3fdf
Sheet: AMH CMH Patients Served

 |  | Adult Mental Health |  |  | Children's Mental Health
 |  | Number of adults served this Month | Number of adults served [NAME] |  | Number of children served this Month | Number of children served [NAME]
Region 1 | Benewah
 | [NAME]
 | Boundary
 | Kootenai
 | Shoshone
Region 2 | Clearwater
 | Idaho
 | Latah
 | Lewis
 | Nez Perce
Region 3 | Adams
 | Canyon
 | Gem
 | Owyhee
 | Payette
 | Washington
Region 4 | [NAME]
 | Boise
 | Elmore
 | Valley
Region 5 | Blaine
 | [NAME]
 | Cassia
 | Gooding
 | [NAME]
 | Lincoln
 | Minidoka
 | [NAME]
Region 6 | Bannock
 | Bear Lake
 | [NAME]
 | Franklin
 | Oneida
 | Power
Region 7 | Bingham
 | [NAME]
 | [NAME]
 | [NAME]
 | Custer
 | Fremont
 | [NAME]
 | Lemhi
 | [NAME]
 | Teton
Unknown |  | . | . |  | . | .
Statewide
 |  | 326 | 414 |  | 63 | 80
 |  | 205 | 266 |  | 69 | 75
 |  | 430 | 527 |  | 76 | 83
 |  | 605 | 830 |  | 114 | 147 | 63 | 69 | 76 | 114 | 45 | 48 | 186
 |  | 236 | 362 |  | 45 | 68 | 80 | 75 | 83 | 147 | 68 | 66 | 213
 |  | 244 | 315 |  | 48 | 66
 |  | 543 | 656 |  | 186 | 213
 |  |  |  |  |  |  | 326 | 205 | 430 | 605 | 236 | 244 | 543
 |  |  |  |  |  |  | 414 | 266 | 527 | 830 | 362 | 315 | 656
 |  |  |  |  |  |  | 326 | 414
 |  |  |  |  |  |  | 205 | 266
 |  |  |  |  |  |  | 430 | 527
 |  |  |  |  |  |  | 605 | 830
 |  |  |  |  |  |  | 236 | 362
 |  |  |  |  |  |  | 244 | 315
 |  |  |  |  |  |  | 543 | 656
 |  | July AMH Number Served | AMH FY 13 Clients Served |  | July CMH Number Served | CMH FY 13 Clients Served
 | Region 1 | 323 | 323 |  | 68 | 68
 | Region 2 | 219 | 219 |  | 67 | 67
 | Region 3 | 438 | 438 |  | 70 | 70
 | Region 4 | 599 | 599 |  | 125 | 125
 | Region 5 | 301 | 301 |  | 53 | 53
 | Region 6 | 268 | 268 |  | 54 | 54
 | Region 7 | 478 | 478 |  | 167 | 167
 | Statewide Total
Spreadsheet: darrell_schoolcraft__7413__TW Jan02pnr
Sheet: Duke 500623

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | Duke Energy Trading & Mktg | 27266 | 2001-03-01 00:00:00 | 500623 | PnR |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 140698d1328864274-apparent-defined-name-problem-gpra-samples
Sheet: Clinic Scorecard

 |  |  |  | GPRA Dashboard for PS Clinics
 |  |  |  |  |  | 1-30-12 to 2-3-12
 |  | Goal | Overall | Doc1 | Doc2 | Doc3 | Doc4 | Nur1 | Nur2 | Nur3 | Nur4
Behavioral Health | Alcohol Screen Females 15-44 | 58.7 | 96.5 | 89.3 | 70.8 | 95 |  | 100 | 91.3 | 85.7 | 83.3 |  | GOAL:
 | Depression: Screening or Diagnosis 18+ | 56.5 | 87.3 | 71.1 | 75.3 | 83.2 |  | 91.1 | 81.1 | 81.4 | 71 |  | Numerator:
 | IPV/DV Screen Females 15-40 | 55.3 | 87.9 | 70.8 | 75 | 88.2 |  | 100 | 81.1 | 81.6 | 80 |  | Denominator:
Cancer-Related | Colorectal Cancer Screen 51-80 | 43.2 | 37.9 | 15 | 39.1 | 31.7 |  | 35.1 | 28 | 30.9 | 60 |  | Data run: From iCare panel select Natl Aggregated, filter 2012 goals to (NonBlanks), ctrl+a, click the "Export to Excel" icon and save to desktop, open saved file, copy F4-F25, click on row 2 of this sheet in the appropriate column, click on the down arrow underneath the paste icon and then hit "v"
 | Mammogram Rates 52-64 | 51.7 | 55 | 50 | 25 | 68 |  | 61.5 | 57.1 | 64.3 | 50
 | Pap Smear Rates 21-64 | 59.5 | 55.7 | 45.7 | 45.8 | 50.9 |  | 48.6 | 44.3 | 52.7 | 47.1
 | Tobacco Cessation: Counseling or RX | 30 | 30.8 | 6.3 | 0 | 11.1 |  | 10 | 14.7 | 0 | 0 |  | DATA ANALYSIS:
CVD-Related | IHD: Comp CVD Assessment | 40.6 | 49.1 | 64.3 | 14.3 | 21.1 |  | 31.8 | 37.9 | 38.5 | 25 |  | •
Dental | Dental Access | 26.9 | 41.3 | 40.9 | 33 | 36.7 | 41 | 44.4 | 39.8 | 39.1 | 48.7 |  | •
 | Dental Sealants | 276893 |  |  |  |  |  |  |  |  |  |  | ACTIONS:
 | Topical Fluoride Pts | 161461 | 16.2 | 8 | 8.8 | 11.9 | 37.7 | 18.5 | 13.5 | 17.8 | 15.4 |  | •
Diabetes | DM: A1c Glycemic Control Ideal <7 | 32.7 | 34.3 | 17.9 | 25.6 | 36 |  | 31.9 | 26 | 26.7 | 20 |  | •
 | DM: A1c Glycemic Control Poor >9.5 (GPRA) | 18.6 | 21.9 | 33.3 | 30.8 | 20 |  | 27.7 | 31.2 | 26.7 | 50 |  | •
 | DM: BP Controlled <130/80 | 38.7 | 38.8 | 25.6 | 38.5 | 28 |  | 21.3 | 33.8 | 36 | 40 |  | •
 | DM: LDL Assessed | 70.3 | 72.5 | 66.7 | 64.1 | 84 |  | 80.9 | 71.4 | 75.6 | 60 |  | ACTIONS:
 | DM: [NAME] | 57.8 | 57.9 | 79.5 | 66.7 | 58 |  | 66 | 66.2 | 70.9 | 60 |  | •
 | DM: Retinal Evaluation | 54.8 | 40.4 | 33.3 | 20.5 | 34 |  | 29.8 | 33.8 | 30.2 | 30 |  | •
Vaccines | Influenza IZ 65+ | 63.4 | 86.9 | 69.2 | 45.5 | 82.4 |  | 88.9 | 83.3 | 74.1 | 75 |  | •
 | Peds IZ 4:3:1:3:3:1:4 Active IMM | 77.8 | 70 |  | 100 |  | 33.3 | 100 | 0 | 33.3 |  |  | •
 | Pneumovax Ever 65+ | 87.5 | 95.1 | 100 | 81.8 | 94.1 |  | 94.4 | 94.4 | 96.3 | 75 |  | •
Other Clinical | Breastfeed Screen @ 2 mos: exclusive/mostly breastfed | 27.4 |  |  |  |  |  |  |  |  |  |  | Responsible Person(s), Content Expert, Chief/Supervisor or Team Leader(s):
STI-Related | STI: Prenatal HIV Screening | 81.8 | 54.5 | 100 | 100 | 50 |  | 66.7 | 28.6 | 83.3 | 100
Spreadsheet: d7674629-f1b9-45a7-bef4-5bc59a0993cf
Sheet: Sheet1

Contractor Weekly Time Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Exclaim-IT | ABN: 97 109 189 059 |  |  |  | [NAME]
Level 5 . 320 Adelaide Street . Brisbane . [NAME] 4000
Send timesheets to: |  |  | [NAME] |  |  |  | Fax. (07) 3221 2254
 |  |  |  |  |  |  | [NAME]. (07) 3118 5666
Please email PTY LTD Invoices to |  |  | [EMAIL]
* * * Please fax timesheet to the above fax number by 12pm (midday) AEST every Monday * * *
Hourly/ Daily:
[NAME]:
Client/ Company:
Week Ending: |  |  |  | Day is a:
Day | Date | Start 24hr (hh:[NAME]) | Finish 24hr (hh:[NAME]) | Break 24hr (hh:[NAME]) | Total Hours (hrs mins) | Total Hours Decimal | Total Days | Comments
 |  |  |  | 24 hr hh:[NAME] | (hours:mins) | (Decimal)
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
 |  |  |  |  | 00:00:00 | 0
00:00:00 |  |  |  |  | 0:0 | 0 | 0
 |  |  |  |  | 0 | 0
Client Authorisation:
I, the undersigned, certify that the total number of hours/ days claimed on this timesheet are true and correct and that the work performed by the [NAME] was performed in a satisfactory manner.
I hereby authorise |  |  |  | Hours/Days to be invoiced *
 |  | Please insert
 | Client Name & Title |  |  |  | Client Signature
*If no hours or days are entered, hours/days invoiced will be as shown on timesheet
Instructions for use of this timesheet:
This timesheet represents written confirmation of the work performed by the Contractor
Contractor Instructions:
 | Fill in the details (boxed fields) of work performed for the nominated week period.
 | For the Start, Finish & Break times (C24 to E30) please ensure that times are entered in the correct hour:minutes format.
 | Ensure timesheet is signed by authorised client signatory and faxed to the above fax number by midday AEST each Monday.
 | If you require any further information, or confirmation that your timesheet has been received, have any payroll queries or are planning to take leave please contact Exclaim-IT:
 |  | Phone: | (07) 3010 9780
 |  | Fax: | (07) 3221 2254
 |  | [NAME]: | [EMAIL]
Client Instructions:
 | Please verify accuracy of time details quoted by the Contractor.
 | Record your Name, Title & Signature in the Client Authorisation box above and please state hours/days to be invoiced.
 | By authorising this timesheet, express authority is made to Exclaim-IT to invoice directly for this contractor.
Spreadsheet: 684795d1593538449-nested-if-function-nested-if
Sheet: Sheet1

 |  | DATE: 6/26/2020
SL | NUM | Start | End | Value | Amount |  | SL | NUM | Start | End | Value | Amount
1 | 1432 | 26 |  | 30 |  |  | 1 | 1457 | 13 |  | 3 |  |  | INSTANT SOLD
2 | 1402 | 28 |  | 30 |  |  | 2 | 1419 | 6 |  | 3 |  |  | INSTANT PAY
3 | 1460 | 6 |  | 30 |  |  | 3 | 1409 | 95 |  | 3 |  |  | RENE's PULL
4 |  |  |  | 30 |  |  | 4 | 1439 | 53 |  | 3 |  |  | INSTANT TOTAL
5 | 1445 | 2 |  | 20 |  |  | 5 | 1399 | 78 |  | 3
6 | 1445 | 29 |  | 20 |  |  | 6 | 1447 | 15 |  | 3 |  |  | ONLINE SALES
7 | 1426 |  |  | 20 |  |  | 7 | 1388 | 61 |  | 3 |  |  | ONLINE PAY
8 | 1466 |  |  | 20 |  |  | 8 | 1468 | 60 |  | 3 |  |  | PROMO/REDEEM
9 | 1441 |  |  | 10 |  |  | 9 | 1458 | 78 |  | 2 |  |  | PAY THRU REGISTER
10 | 1450 | 31 |  | 10 |  |  | 10 | 1469 | 73 |  | 2 |  |  | CARD TRANSACTION
11 | 1461 | 14 |  | 10 |  |  | 11 | 1464 | 146 |  | 2 |  |  | CREDIT SALES
12 | 1412 |  |  | 10 |  |  | 12 | 1420 | 86 |  | 2 |  |  | ONLINE TOTAL
13 | 1433 | 26 |  | 10 |  |  | 13 | 1405 | 147 |  | 2
14 | 1421 | 48 |  | 10 |  |  | 14 | 1448 | 132 |  | 2 |  |  | NET LOTTO
15 | 1446 | 22 |  | 5 |  |  | 15 | 1443 | 72 |  | 2
16 | 1451 | 14 |  | 5 |  |  | 16 | 1453 | 115 |  | 2
17 | 1463 | 35 |  | 5 |  |  | 17 | 1415 | 134 |  | 2
18 | 1467 | 50 |  | 5 |  |  | 18 | 1470 | 79 |  | 1
19 | 1462 | 44 |  | 5 |  |  | 19 | 1459 | 11 |  | 1
20 | 1414 | 23 |  | 5 |  |  | 20 | 1431 | 77 |  | 1
21 | 1392 | 57 |  | 5 |  |  | 21 | 1465 | 1 |  | 1
22 | 1434 | 43 |  | 5 |  |  | 22 | 1449 | 71 |  | 1
23 | 1452 | 18 |  | 5 |  |  | 23 | 1454 | 40 |  | 1
24 | 1397 | 54 |  | 5 |  |  | 24 | 1444 | 91 |  | 1
25 | 1437 | 15 |  | 5
26 | 1422 | 33 |  | 5 |  |  |  |  |  | TOTAL SALE
27 | 1456 | 56 |  | 5
28 | 1418 | 27 |  | 5
29
30
31
32
Spreadsheet: 62055d1262954428-multi-option-sum-123
Sheet: invoice

Status of Export Shipments, Freight and Insurance Bills for the Year 2009
Sr# | Name of Firm | Value of Invoice | Invoice # | Payment Due on | Payment Made on
1 | A | 49511 | --- | 2009-04-04 00:00:00 | 2009-04-03 00:00:00
2 | B | 104802 | --- | 2009-04-30 00:00:00 | 2009-05-06 00:00:00
3 | B | 38639 | --- | 2009-05-13 00:00:00 | 2009-05-06 00:00:00
4 | A | 159824 | --- | 2009-05-02 00:00:00 | 2009-05-14 00:00:00
5 | A | 150525 | --- | 2009-05-26 00:00:00 | 2009-05-27 00:00:00
6 | A | 143180 | --- | 2009-05-26 00:00:00 | 2009-06-10 00:00:00
7 | B | 36702 | --- | 2009-06-17 00:00:00 | 2009-06-09 00:00:00
8 | A | 128825 | --- | 2009-06-23 00:00:00 | 2009-06-29 00:00:00
9 | A | 44325 | --- | 2009-07-04 00:00:00 | 2009-07-21 00:00:00
10 | A | 19360 | --- | 2009-07-14 00:00:00 | 2009-07-21 00:00:00
11 | A | 42136 | --- | 2009-07-28 00:00:00 | ---
12 | A | 82969 | --- | 2009-07-28 00:00:00 | ---
13 | A | 62620 | 20 | 2009-08-26 00:00:00 | 2009-09-07 00:00:00
14 | B | 16153 | 02455 | 2009-09-05 00:00:00 | 2009-09-08 00:00:00
15 | B | 31106 | 7024 | 2009-11-04 00:00:00 | ---
16 | C | 29599 | 822100077 | 2009-10-09 00:00:00 | 2009-10-24 00:00:00
17 | C | 89360 | 82110323 | 2009-11-27 00:00:00 | 2009-12-31 00:00:00
18 | C | 73345 | 822100088 | 2009-12-09 00:00:00 | 2009-12-13 00:00:00
19 | C | 124524 | 82110322 | 2009-11-27 00:00:00
20 | B | 38742 | 12343 | 2010-01-06 00:00:00 | 2009-12-30 00:00:00
21 | A | 18873 | 720 | 2010-01-05 00:00:00 | 2009-12-30 00:00:00
22 | B | 35590 | 13032 | 2010-01-13 00:00:00
23 | A | 88432 | 160 | 2010-01-05 00:00:00
24 | D | 21875 | 52190233 | 2010-02-02 00:00:00
25 | A
26 | B
27
28
 | A | 88432 | (Sum of all the value in above data relates to A if payment made on column is blank)
 | B | 35590 | (Sum of all the value in above data relates to B if payment made on column is blank)
 | C | 124524 | (Sum of all the value in above data relates to C if payment made on column is blank)
 | D | 21875 | (Sum of all the value in above data relates to D if payment made on column is blank)
Spreadsheet: a5cfad8c-a22b-40f9-b0e4-099598679935
Sheet: PostalCode validation

 | Value on form |  | Correct value | Condition met
 | Check # of characters |  | 6
 | Check 1st char is letter
 | Check 2nd char is number |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
 | Check 3rd char is letter
 | Check 4th char is number |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
 | Check 5th char is letter
 | Check 6th char is number |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
 | Is there as space at 4th char
Spreadsheet: 698812d1602184854-conditional-formating-with-a-formula-and-icon-set-example
Sheet: Sheet1

Store | Location | CY | PY | [NAME] | Comp % | 1 | 1 PY
4 | OAKVILLE | 230865.74 | 191276.6 | 39589.14000000001 | 0.2069732523476475 | 5002 | 10349.98
11 | Sherway | 230865.74 | 191276.6 | 39589.14000000001 | 0.2069732523476475 | 1231223 | 10349.98
25 | University | 230865.74 | 191276.6 | 39589.14000000001 | 0.2069732523476475 | 12312 | 10349.98
27 | Kirkland | 230865.74 | 191276.6 | 39589.14000000001 | 0.2069732523476475 | 32 | 10349.98
36 | Bayers | 230865.74 | 191276.6 | 39589.14000000001 | 0.2069732523476475 | 312 | 10349.98
49 | Marche | 69054.91 | 56249.02 | 12805.89 | 0.2276642330835275 | 14606.67 | 5511.48
Spreadsheet: 873641d1720142644-help-vlookup-i-reckon-aussiefreight-rawdata
Sheet: Orders

Write a formula to get the Distance (column D) between From and To Cities  (columns B and C) for a particular Order ID (column A). Lookup data from the Distances worksheet. Then calculate the Order's Freight cost in column E.
Order ID | From | To | Distance (km) | Freight |  |  |  | Cost per km (AUD)
1 | Sydney | Canberra |  |  |  |  |  | 0.07
2 | Melbourne | Sydney
3 | Canberra | Brisbane
4 | Sydney | Melbourne
5 | Brisbane | Perth
6 | Sydney | Melbourne
7 | Canberra | Perth
8 | Brisbane | Sydney
9 | Perth | Canberra
10 | Canberra | Melbourne
11 | Sydney | Perth
12 | Perth | Melbourne
13 | Melbourne | Brisbane
14 | Melbourne | Perth
15 | Melbourne | Canberra
16 | Melbourne | Brisbane
17 | Perth | Sydney
18 | Melbourne | Perth
19 | Perth | Sydney
20 | Sydney | Melbourne
21 | Melbourne | Sydney
22 | Perth | Brisbane
23 | Melbourne | Brisbane
24 | Canberra | Sydney
25 | Sydney | Perth
26 | Sydney | Canberra
27 | Perth | Brisbane
28 | Brisbane | Canberra
29 | Canberra | Brisbane
30 | Perth | Canberra
Spreadsheet: 856396d1705653867-cash-flow-help-quote-example-document
Sheet: Sheet1

Quote No | Leads | Client | Estimator | Company (GRBC / SES / Higgins/SHH) | Budget / Estimate quote | Contact Name | Contact Info | Margin | Start Date | Duration | Trade | % likely | Update | Date of Update | Next Action | January | February | March | April | May | June | July | August | September | October | November | December
34428 | Mains Water Pipe Installation - Mechanical | AVD | RC | Projects | 21714.44 |  | 01782 383124 | 0.2165 | Jan | 4 | M |  | Manager who Response is resigned.  Following up by another Engineer | 2024-01-15 00:00:00
34429 | Mains upgrade |  | RC | Building Services | 50000 |  |  | 0.19 | March | 10 | M | 0.75
34430 | EICR |  | RC | Sustainable Solutions | 10000 |  |  | 0.18 | May | 3 | M | 0.9
 | Overall Total:
 | Total: | Projects
 | Total: | Building Services
 | Total: | Sustainable Solutions
 | Total: | SHH
 | Overall Total:
 | Averages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechancial
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Specialist Gas
Spreadsheet: 201955d1356244815-matching-multiple-criteria-both-exactly-and-approximately-example-coded-vs-charges
Sheet: Sheet2

DOS | PT NAME | CPT | MOD | DX 1 | DX 2 | DX3
2012-11-08 00:00:00 | [NAME], [NAME] | 99284 |  | 9 | 787.91 | 729.1
2012-11-08 00:00:00 | Connery, Sean | 99284 |  | 307.81
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 535.5 | 789.09 | 787.91
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 351 | 788 | 599
2012-11-08 00:00:00 | [NAME], [NAME] | 99285 | 255 | 995.3
2012-11-08 00:00:00 | [NAME], [NAME] | 93010 |  | 995.3
Spreadsheet: 879731d1727282907-countif-based-on-the-difference-between-two-columns-countif-based-on-difference-between-columns
Sheet: Sheet1

StartDate | EndDate |  | TimeInterval: | 55 | days
2024-04-10 00:00:00 | 2024-05-11 00:00:00
2019-06-17 00:00:00 | 2019-10-18 00:00:00 |  | =countif((b5:b17)-(a5:a17) < e1)
2023-10-04 00:00:00 | 2023-11-05 00:00:00
2024-03-07 00:00:00 | 2024-07-07 00:00:00
2024-09-01 00:00:00 | 2024-09-03 00:00:00
2024-05-30 00:00:00 | 2024-08-08 00:00:00
2023-05-09 00:00:00 | 2023-10-05 00:00:00
2024-05-13 00:00:00 | 2024-06-30 00:00:00
2023-11-03 00:00:00 | 2023-11-01 00:00:00
2023-03-17 00:00:00 | 2023-09-21 00:00:00
2023-10-29 00:00:00 | 2024-01-18 00:00:00
2022-07-06 00:00:00 | 2022-08-05 00:00:00
2024-03-08 00:00:00 | 2024-04-30 00:00:00
Spreadsheet: 160862d1339256831-convert-feet-and-inches-to-just-inches-inches-example
Sheet: Sheet1

 | height | feet in inches | inches | sum | in one formula
 | 6-11 | 72 | 11 | 83 | #N/A
 | 6-2 | 72 |  | #N/A
 | 5-10
 | 5-7
 | 6-0
 | 6-9
 | 6-10
 | 5-9
 | 5-5
 | 5-6
 | 6-0
 | 5-11
 | 5-9
 | 5-10
 | 6-11
Spreadsheet: larry_campbell__21032__SPRABERpte
Sheet: fugitives

NORTHERN NATURAL GAS COMPANY
SPRABERRY PLANT
TNRCC ACCOUNT NO. ML-0022-W
EPN: FUG
 |  | OIL & GAS PROCESSING |  | PERCENT |  | EMISSIONS
COMPONENT | COUNT | FACTORS | HOURS | VOC *1 | ANNUAL | ANNUAL | MAX.
 |  | (lb/hr/comp) |  |  | (lb/yr) | (tn/yr) | (lb/hr)
[NAME]:
GAS/VAPOR | 825 | 0.00992 | 8760 | 0.1
FLANGES:
GAS/VAPOR | 2057 | 0.00086 | 8760 | 0.1
COMPRESSORS:
SCE101 | 1 | 0.0194 |  | 0.1
SCE102 | 1 | 0.0194 |  | 0.1
SCE103 | 1 | 0.0194 |  | 0.1
SCE104 | 1 | 0.0194 |  | 0.1
SCE105 | 1 | 0.0194 |  | 0.1
SCE106 | 1 | 0.0194 |  | 0.1
[NAME] | 1 | 0.0194 |  | 0.1
SCE108 | 1 | 0.0194 |  | 0.1
SCE109 | 1 | 0.0194 |  | 0.1
SCE110 | 1 | 0.0194 |  | 0.1
SCE111 | 1 | 0.0194 |  | 0.1
SCE112 | 1 | 0.0194 |  | 0.1
OPEN ENDED LINES: |  | 0.00441 |  | 1
RELIEF VALVES: | 34 | 0.00992 | 8760 | 0.1
SAMPLE CONNECTIONS: |  | 0.00044 |  | 1
 |  |  | TOTAL VOC (59999):
1.  VOC Emissions do not include methane or ethane. Percent VOC for gas service conservatively estimated for pipeline quality natural gas.
2.  EPN: SAE101 has no compressor seals (generator only).