tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78ea19f2-16ba-4710-8f97-84b4cb2b6032
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
User Input Data
Calculated Value
Reference Data
Designed By: |  | Date:
Checked By: |  | Date:
Company:
Project Name:
Project No.:
Site Location (City/Town) | Raleigh
[NAME] | 101
Total Drainage Area (acres)
Rational Method for Flow
Outlet pipe diameter, Do (in.) | 48
Tailwater depth (in.) | 24
Minimum/Maximum tailwater? | [NAME] ([NAME]. 8.06b)
Discharge (cfs)
Velocity (ft./s)
 | Minimum TW | Maximum TW
 | Figure 8.06a | Figure 8.06b
[NAME] d50, (ft.)
Minimum apron length, [NAME] (ft.)
Apron width at pipe outlet (ft.) | 12 | 12
Apron shape
Apron width at outlet end (ft.) | 4 | 4
 | Minimum TW | Maximum TW
[NAME], dmax (ft.) | 0 | 0
 | Minimum TW | Maximum TW
[NAME]) | 0 | 0
Spreadsheet: 877411-lookup-based-on-unique-value-and-date-within-a-date-range-employee-number-and-date-within-range-lookup
Sheet: Sheet1

Employee Number | Leave Type | Leave Group | End Date |  |  | Employee Number | Position Start | Position End | Leave Group
1000397 | ANN |  | 2024-08-19 00:00:00 |  |  | 1000397 | 2023-10-05 00:00:00 |  | 724
1000397 | ANN |  | 2024-08-16 00:00:00 |  |  | 1000397 | 2015-01-27 00:00:00 | 2023-10-04 00:00:00 | SA1
1000397 | ANN |  | 2024-07-10 00:00:00
1000397 | ANN |  | 2024-06-20 00:00:00
1000397 | ANN |  | 2024-05-23 00:00:00
1000397 | ANN |  | 2024-05-03 00:00:00
1000397 | ANN |  | 2024-03-22 00:00:00
1000397 | ANN |  | 2023-11-17 00:00:00
1000397 | ANN |  | 2023-11-10 00:00:00
1000397 | ANN |  | 2023-10-10 00:00:00
1000397 | ANN |  | 2023-09-14 00:00:00
1000397 | ANN |  | 2023-09-01 00:00:00
1000397 | ANN |  | 2023-08-30 00:00:00
1000397 | ANN |  | 2023-06-16 00:00:00
1000397 | ANN |  | 2023-05-30 00:00:00
1000397 | ANN |  | 2023-05-19 00:00:00
 |  | Lookup leave group based on unique employee number and leave end date
Spreadsheet: 09943258-1c87-4438-b795-3698f76cb1ac
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Transport equipment ; |  |  | Original | A2413510X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Other plant and equipment ; |  |  | Original | A2413511A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413512C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413513F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413514J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 799286d1665025411-multiply-cells-in-column-with-blanks-in-between-by-a-set-of-percentages-sample
Sheet: Sheet1

Data1 | Data2 |  |  |  | Data1 | Data2
 | 10000 |  |  |  |  | 10000
 | 20000 |  |  |  |  | 20000
 | 30000 |  |  |  |  | 30000
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 7th bba

S. No | Register No | Student Name
1 | 126118001 | Aadi
2 | 126118002 | Abir
3 | 126118003 | Afsh
4 | 126118004 | [NAME]
5 | 126118005 | [NAME]
6 | 126118006 | Arun
7 | 126118007 | Cruz
8 | 126118008 | Dhar
9 | 126118009 | Hari
10 | 126118010 | Hars
11 | 126118011 | Jaya
12 | 126118013 | Kavi
13 | 126118015 | [NAME]
14 | 126118016 | [NAME]
15 | 126118017 | [NAME]
16 | 126118018 | Mrin
17 | 126118020 | Pavi
18 | 126118021 | Raja
19 | 126118022 | Raks
20 | 126118023 | Atch
21 | 126118024 | Sand
22 | 126118025 | Sara
23 | 126118026 | Saty
24 | 126118027 | Siva
25 | 126118028 | Sneh
26 | 126118029 | Sneh
27 | 126118030 | Srin
28 | 126118031 | [NAME]
29 | 126118032 | Srut
30 | 126118033 | Srut
31 | 126118034 | Stut
32 | 126118035 | Thar
33 | 126118036 | Tvis
Spreadsheet: 330188d1404592474-cell-that-reports-the-first-date-of-the-current-month-mini-project-wally-mart-b212-10-1
Sheet: Lists

B1091-54572 |  |  | B1091-54572  (KITTEN FOOD)
D3911-98275 |  |  | D3911-98275 (DEEP FRYER)
D8968-82625 |  |  | D8968-82625 (FRYING PAN)
F3168-89809 |  |  | F3168-89809 (PUSH SQUEEGEE)
F5846-71724 |  |  | F5846-71724 (HAND MIXER)
F6967-33896 |  |  | F6967-33896 (SPATULA)
F7121-39978 |  |  | F7121-39978 (LONG-HANDLED DUST PAN)
F7845-67716 |  |  | F7845-67716 (BLENDER)
G2133-44629 |  |  | G2133-44629 (TRASH BAGS, 44-GALLON)
G4243-92352 |  |  | G4243-92352 (LAUNDRY DETERGENT)
J1463-72582 |  |  | J1463-72582 FOOD PROCESSOR)
J3158-53666 |  |  | J3158-53666 (FOOD CONTAINER)
J6947-62776 |  |  | J6947-62776 (TOILET PAPER (1-PLY))
J7604-40448 |  |  | J7604-40448 (SLOW COOKER/CROCK POT)
J9161-28339 |  |  | J9161-28339 (SLOTTED SPOON)
J5597-39232 |  |  | J5597-39232 (PUPPY FOOD)
K1290-68858 |  |  | K1290-68858 (WOODEN SPOON)
K3008-40082 |  |  | K3008-40082 (CAN OPENER)
L7725-20678 |  |  | L7725-20678 (MEAT GRINDER)
N1251-68781 |  |  | N1251-68781 (DISH SOAP)
N7452-75713 |  |  | N7452-75713 (LADLE)
O8272-48948 |  |  | O8272-48948 (SCOOPS (SET))
Q9840-26383 |  |  | Q9840-26383 (IRON)
S2053-97298 |  |  | S2053-97298 (MOP)
U2445-66969 |  |  | U2445-66969 (BLEACH, 1 GALLON)
U3570-75018 |  |  | U3570-75018 (ANTI-BACTERIAL HAND SOAP)
U5221-14557 |  |  | U5221-14557 (BROOM)
W6424-55749 |  |  | W6424-55749 (2-PRONG FORK)
Y2111-95648 |  |  | Y2111-95648 (CUTTING BOARD)
Y7456-48617 |  |  | Y7456-48617 (MICROWAVE OVEN)
Z6825-72053 |  |  | Z6825-72053 (PAPER TOWELS (1-PLY))
Spreadsheet: 176336d1345818064-if-statement-help-copy-of-quote-priorites
Sheet: Master Sheet

 |  | Approved Vendor |  |  |  |  |  |  | Quotes |  |  |  |  |  |  | Approved Vendor Quotes
Part Number | Description | JHY | KA | KAY | MI | SG | SIE |  | JHY | KA | KAY | MI | SG | SIE |  | JHY | KA | KAY | MI | SG | SIE |  | Cheapest Vendor | Cost |  | Cheapest Approved Vendor | Cost |  | Cheapest Vendor vs. Cheapest Approved Vendor Difference |  | Paste Part # Here | Cheapest Approved Vendor | Cost
123456 | abcd | No | Yes | No | No | No | No |  | nq | 3.45 | nq | nq | nq | 2.3 |  | nq | 3.45 | nq | nq | nq | nq |  | SIE | 2.3 |  | KA | 3.45 |  | 0.5000000000000002 |  |  | #N/A | #N/A
234567 | bcde | No | No | Yes | No | Yes | No |  | nq | nq | 0.95 | nq | 1.26 | 2.15 |  | nq | nq | 0.95 | nq | 1.26 | nq |  | KAY | 0.95 |  | KAY | 0.95 |  | 0 |  |  | #N/A | #N/A
345678 | cdef | No | No | Yes | No | Yes | No |  | nq | nq | 1.07 | nq | 1.37 | 2.35 |  | nq | nq | 1.07 | nq | 1.37 | nq |  | KAY | 1.07 |  | KAY | 1.07 |  | 0 |  |  | #N/A | #N/A
456789 | defg | No | No | Yes | No | Yes | No |  | nq | nq | 0.89 | nq | 1.17 | 2.53 |  | nq | nq | 0.89 | nq | 1.17 | nq |  | KAY | 0.89 |  | KAY | 0.89 |  | 0 |  |  | #N/A | #N/A
567891 | efgh | No | No | Yes | No | Yes | No |  | nq | nq | 1.44 | nq | 1.68 | 5.5 |  | nq | nq | 1.44 | nq | 1.68 | nq |  | KAY | 1.44 |  | KAY | 1.44 |  | 0 |  |  | #N/A | #N/A
678912 | fghi | Yes | Yes | No | No | Yes | No |  | nq | 2.98 | nq | nq | 2.9 | 2.95 |  | nq | 2.98 | nq | nq | 2.9 | nq |  | SG | 2.9 |  | SG | 2.9 |  | 0 |  |  | #N/A | #N/A
789123 | [NAME] | Yes | Yes | No | No | Yes | No |  | nq | 2.95 | nq | nq | 2.9 | 2.8 |  | nq | 2.95 | nq | nq | 2.9 | nq |  | SIE | 2.8 |  | SG | 2.9 |  | 0.03571428571428581 |  |  | #N/A | #N/A
891234 | [NAME] | Yes | Yes | No | No | No | No |  | 4.1 | 3.8 | nq | nq | 3.05 | 3.35 |  | 4.1 | 3.8 | nq | nq | nq | nq |  | SG | 3.05 |  | KA | 3.8 |  | 0.2459016393442623 |  |  | #N/A | #N/A
912345 | ijkl | Yes | No | No | No | No | No |  | 3.49 | 3.66 | 2.69 | nq | nq | 3.9 |  | 3.49 | nq | nq | nq | nq | nq |  | KAY | 2.69 |  | JHY | 3.49 |  | 0.2973977695167287 |  |  | #N/A | #N/A
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: Fabrivu

Fabrivu |  | Total hours
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  | VUTEK 3R's | For production quote- [NAME]
Spreadsheet: 747810d1631713044-adding-specific-data-from-one-worksheet-to-another-interchange-spreadsheet
Sheet: Sheet1

#1 Interchange PN | #2 Compressed Part Number | #2 Catalog Part Number | Invoice Price - Effective 07/15/2021
42013 | LX1005 | LX 1005
42015 | LX677 | LX 677
42023 | LX3214 | LX 3214
42052 | LX781 | LX 781
42054 | LX2549 | LX 2549
42086 | LX3088 | LX 3088
42098 | LX2552 | LX 2552
42106 | LX264 | LX 264
42133 | [NAME] | LX 259
42156 | LX2942 | LX 2942
42159 | LX1140 | LX 1140
42164 | LX1955 | LX 1955
42165 | LX190 | LX 190
42168 | LX500 | LX 500
42168 | LX501 | LX 501
42170 | LX218 | LX 218
42170 | LX54 | LX 54
42174 | [NAME] | LX 114
42177 | LX686 | LX 686
Spreadsheet: 681902d1591805200-name-differences-for-the-same-customer-number-field-i-want-markjohn51-
Sheet: Sheet1

Cust Number | Name | Name Diff | F Name | L Name
0010002R | ROSE SPAGIARI
0010002R | ROS SPAGIARI
0010002R | ROSE SPAGIARI
0010002R | ROSESPAGIARI
0050002M | JOHN MOSS
0050002M | [NAME]
0030007T | [NAME]
0030007T | [NAME]
0060007D | MIKE LOSS
Spreadsheet: kate_symes__18589__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
 | 2001-01-21 00:00:00 |  |  |  |  |  | 235 | 29400
 | 2001-01-20 00:00:00 |  | 506.48 | 4320 | 236.31 | 8400
 | 2001-01-19 00:00:00 |  | 505.66 | 4384 | 247.42 | 5032
 | 2001-01-18 00:00:00 |  | 429.29 | 7920 | 278.82 | 6440
 | 2001-01-17 00:00:00 |  | 252.4 | 8000 | 204.13 | 4600
 | 2001-01-16 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-15 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-14 00:00:00 |  |  |  |  |  | 151.53 | 9000
 | 2001-01-13 00:00:00 |  | 171.82 | 18176 | 152.53 | 3400
 | 2001-01-12 00:00:00 |  | 178.58 | 15056 | 158.12 | 3400
 | 2001-01-11 00:00:00 |  | 178.58 | 15056 | 158.12 | 3400
 | 2001-01-10 00:00:00 |  | 176.02 | 12720 | 158.32 | 3800
 | 2001-01-09 00:00:00 |  | 171.72 | 13856 | 156.09 | 2200
 | 2001-01-08 00:00:00 |  | 159.12 | 13120 | 151.13 | 1600
 | 2001-01-07 00:00:00 |  |  |  |  |  | 150 | 4200
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -3 | -3150
500046 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 |  | -42800
500528
500529
500619
INDEX
2002-01-31 00:00:00 |  |  | -547260.79
2002-02-25 00:00:00
CBS Volume
 |  |  | -41423
Spreadsheet: 219722d1362913675-finding-a-match-in-part-of-a-column-findmatch
Sheet: Sheet1

SORTALL | TXT_WT_BATCH_DATE | 2ndPassM/c | EStStopDay
1110.3331 | 41339 | 2 | 0 |  |  |  | I want to find first value of SORTALL when ESTStopDay = Txt_WT_BATCH_DATE within the series of 2ndPassM/c
1130.3331 | 41334 | 2 | 41337 |  |  |  | for that entry
1221.00 | 41345 | 2 | 0
1321.3220 | 41334 | 2 | 0 |  |  |  | For instance entry 41337  in ColD is in 2ndpassM/c 2 in Col C There is no matching Batch_Date
1321.1321 | 41347 | 2 | 0 |  |  |  | Entry 41340 in D is in 2ndPassM/c 3 in C  There is a matching Batch_Date in colB in Row24, so I would like the SORTALL value 2220.00
1321.2231 | 41334 | 2 | 0
1321.3331 | 41331 | 2 | 0
1321.3331 | 41333 | 2 | 0
1321.2220 | 41340 | 2 | 0
1321.3331 | 40972 | 2 | 0
1321.00 | 41340 | 2 | 0
1321.00 | 41347 | 2 | 0
1321.2330 | 41348 | 2 | 0
1321.2230 | 41325 | 2 | 0
1321.2231 | 41344 | 2 | 0
2120.00 | 41341 | 3 | 0
2120.2120 | 41339 | 3 | 0
2130.3331 | 41347 | 3 | 0
2130.00 | 41333 | 3 | 0
2130.00 | 41334 | 3 | 0
2210.00 | 41334 | 3 | 41340
2220.2220 | 41332 | 3 | 41341
2220.00 | 41340 | 3 | 0
2220.00 | 41339 | 3 | 0
2221.3230 | 41340 | 3 | 0
2221.3331 | 41348 | 3 | 0
2221.00 | 41340 | 3 | 0
2221.3331 | 41348 | 3 | 0
2230.2230 | 41348 | 3 | 0
2230.2230 | 41330 | 3 | 0
2231.3331 | 41347 | 3 | 0
2231.00 | 41341 | 3 | 41352
2231.00 | 41338 | 3 | 0
2231.00 | 41340 | 3 | 0
2231.00 | 41337 | 3 | 41355
2231.00 | 41341 | 3 | 0
2231.00 | 41339 | 3 | 0
2231.00 | 41334 | 3 | 41363
2231.00 | 41333 | 3 | 41366
2231.00 | 41326 | 3 | 0
Spreadsheet: 742892d1628095748-need-help-with-formula-skipping-blanks-sa1
Sheet: Sheet1

Type | NAME/NUMBER | CASTING DATE | SONIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference |  |  |  | WC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA |  | S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NC |  | P7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA |  | P8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC |  | P9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P9
Spreadsheet: 84744d1284742164-summarise-for-invoicing-publishing
Sheet: Invoice Publishing

 |  |  |  |  |  |  |  | INVOICE
Art & Escape Gallery Ltd
23-25 Barnet Road
EN6 2QX
Company No. 06972834
www.artandescape.com
[NAME] |  |  |  |  |  |  | INVOICE DATE | 2014-09-18 17:38:21
The Only Place for Pictures |  |  |  |  |  |  | INVOICE NUMBER
216 Upper Street |  |  |  |  |  |  | CLIENT REF | CL0020
Islington |  |  |  |  |  |  | DELIVERED VIA
London |  |  |  |  |  |  | PREPAID or COLLECT | PREPAID
N1 1RL
#N/A
REF | ARTIST | TITLE | SIZE (inches) | FRAME | UNIT COST (Print) | UNIT COST (Frame) | QTY | TOTAL
SM003 | [NAME] | American | 23 x 17 | n/a | 13 | n/a | 1 | 13
SM004 | [NAME] | New Avenger | 23 x 17 |  | 13 |  | 1 | 13
SM006 | [NAME] | Taking the mickey | 23 x 17 |  | 13 |  | 1 | 13
SM002 | [NAME] | Supermodel | 23 x 17 |  | 13 |  | 1 | 13
IP002 | [NAME] | bus | 23 x 17 |  | 13 |  |  | 13
IP003 | [NAME] | tube | 23 x 17 |  | 13 |  |  | 13
SM002 | [NAME] | Supermodel | 33 x 23 |  | 25 |  |  | 25
IP003 | [NAME] | tube | 33 x 23 |  | 25 |  |  | 25
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | SUBTOTAL | #N/A
 |  |  |  |  |  |  | DELIVERY
 |  |  |  |  |  |  | TOTAL | TBA
Please direct enquiries to: |  |  |  |  | Make all cheques payable to:
[NAME] |  |  |  |  | [NAME]
+44 (0) 7791 075 458 |  |  |  |  | Art & Escape Gallery Ltd
email: [EMAIL] |  |  |  |  | 23-25 Barnet Road
 |  |  |  |  | EN6 2QX
Thankyou for your business.  Please consider Art & Escape Gallery for all your Original and Published Contemporary Art.
Spreadsheet: drew_fossum__8685__sharris1100wk4
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-12-01 11:15:56.380000
 |  | November, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.5298 | 9.869539799999998 | 0.3397397999999985 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7487 | 0.9637236086999997 | 0.2150236086999997 |  | Higher Rates on the three IT Deals to California ($181k)
East Demand Revenues |  | 1.0892 | 1.037357775 | -0.05184222499999969 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1654 | 0.171044590316 | 0.005644590315999953 |  | Higher volumes because of mainline west outage
[NAME] |  | 0.6430999999999999 | 0.637062 | -0.006037999999999877
[NAME] Revenues |  | 0.0583 | 0.1074220832 | 0.04912208319999997 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.2335 | 12.786149857216 | 0.5526498572160001
[NAME] due to Price |  |  |  | 0.896513746941407 |  | Current index price of $5.37
[NAME] due to net fuel retention. |  |  |  | -0.3124049633961052 |  | Lower retainage volumes -west
Hedging Adjustment |  |  |  | 0.3825 |  | First of the month Index Price $4.52
Unaccounted for Variance |  |  |  | -0.184
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.7826087835453022 |  | Higher than [NAME]. Forecast; mostly due to higher index price
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 1.335258640761302
 |  |  |  | ========
Resolution of El Paso Measurement Dispute |  |  |  | 0
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 1.335258640761302
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through November) |  | 134.5236 | 18.9468 | 153.4704
Actuals through October w/ Nov. Wkly. |  | 136.872649857216 | 24.82615980308686 | 161.6988096603029
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 2.349049857216016 | 5.879359803086853 | 8.22840966030287
 |  | ------------- | ------------- | -------------
Resolution of El Paso Measurement Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 11.22840966030287
 |  |  |  | ========
Spreadsheet: 155186d1336702576-linest-help-linest-example
Sheet: Sheet1 (2)

Observed Values
Area | Price
2000 | 147500 | New Area ("X") | 2300
2200 | 157600 | Calculated Slope |  |  | LINEST(B3:B10,A3:A10,TRUE,FALSE)
2400 | 167700 | New Calculated Price ("Y")
2600 | 177800
2000 | 162500
2200 | 172600
2400 | 177700
2600 | 182800
 |  | y = mx + b
 |  | m = slope
 |  | b = Intercept
 |  | y = "D3" * "D4" + 72250
Spreadsheet: 907dfeb8-a4c1-4868-84b0-053f4c0f33b3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Survey of Public Pensions
 |  | Cash and Security Holdings: U.S. Total
 |  | Not Seasonally Adjusted Total Cash and Security Holdings [Millions of Dollars]
 |  | Period: 1968 to 2013
 |  | Data Extracted on: March 8, 2014 (1:59 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
1968 | 38271 | 39419 | 40528 | 41338
1969 | 42177 | 43771 | 45043 | 45799
1970 | 46970 | 48908 | 50223 | 51306
1971 | 53049 | 55068 | 56156 | 57575
1972 | 59313 | 61852 | 63087 | 64406
1973 | 66050 | 68850 | 69813 | 71621
1974 | 73454 | 76891 | 79566 | 83076
1975 | 85262 | 88955 | 90875 | 93380
1976 | 95742 | 99661 | 102550 | 105394
1977 | 105812 | 109768 | 112725 | 115727
1978 | 118329 | 123015 | 126205 | 130974
1979 | 134671 | 140275 | 143558 | 147466
1980 | 152660 | 159068 | 162378 | 167621
1981 | 176447 | 184273 | 189576 | 194693
1982 | 202459 | 208978 | 214404 | 223011
1983 | 231758 | 242522 | 248446 | 258029
1984 | 268619 | 276973 | 289119 | 300108
1985 | 308951 | 323592 | 334729 | 347668
1986 | 359517 | 372983 | 385604 | 399510
1987 | 422223 | 429465 | 449001 | 465637
1988 | 481705 | 497306 | 503933 | 517948
1989 | 534025 | 550167 | 563015 | 579951
1990 | 589779 | 603189 | 619846 | 629036
1991 | 644237 | 651467 | 684892 | 682723
1992 | 705338 | 718067 | 738206 | 752103
1993 | 754603 | 778302 | 799202 | 825402
1994 | 836653 | 860907 | 880171 | 902841
1995 | 933767 | 947469 | 961686 | 982487
1996 | 1024592 | 1063577 | 1078867 | 1117552
1997 | 1177584 | 1211408 | 1259511 | 1284462
1998 | 1385787 | 1421510 | 1454386 | 1485522
1999 | 1538289 | 1576782 | 1618826 | 1654432
2000 | 1704216 | 1718203 | 1880458 | 1914867
2001 | 1919384 | 1969108 | 1952461 | 1948696
2002 | 1987630 | 1881900 | 1802945 | 1821470
2003 | 1865396 | 1913369 | 1952754 | 2061067
2004 | 2068550 | 2137450 | 2057899 | 2381330
2005 | 2375427 | 2383436 | 2395478 | 2440256
2006 | 2588809 | 2539251 | 2600592 | 2692702
2007 | 2723973 | 2920022 | 2918853 | 2928853
2008 | 2810924 | 2815010 | 2576394 | 2229458
2009 | 2093614 | 2197961 | 2370569 | 2449940
2010 | 2480902 | 2358541 | 2507147 | 2641575
2011 | 2740540 | 2775430 | 2532247 | 2612043
2012 | 2764275 | 2712447 | 2788108 | 2836795
2013 | 2941446 | 2944260 | 3060957
Spreadsheet: 155251d1336743409-excel-2007-line-referenced-drop-downs-hyperlinktotals
Sheet: 1500

 | Rec break 1 |  |  | Rec break 2 |  |  | Rec break 3 |  |  | Rec break 4 |  |  | Rec break 5 |  |  | Rec break 6 |  |  | Rec break 7 |  |  | Rec break 8
 | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date
AUD
CAD
CHF
EUR
GBP
USD | 14.26 | Claim for [NAME] | 2010-05-04 00:00:00
Spreadsheet: 735497d1623038024-working-out-dates-between-invoice-date-and-payment-date-excel-sample
Sheet: Data 

Date | Type |  |  | Inv Number | Inv Amt | DR/CR | Pay Amt | DR/CR 2 | Acc Balance | DR/CR 3 | Creditors No | Week invoice received
2021-02-11 00:00:00 | Inv | 005828 |  |  | 319 | CR |  |  | 319 | CR | L31003 | 33
2021-02-17 00:00:00 | O/Bal |  |  |  |  |  |  |  | 319 | CR | L31003 | 34
2021-02-18 00:00:00 | Pay | 031790 | layerEFT |  |  |  | 319 |  | 0 |  | L31003 | 34 | 7 days
2021-05-12 00:00:00 | Inv | 892745 |  |  | 89.1 | CR |  |  | 89.1 | CR | L30668 | 46
2021-05-12 00:00:00 | O/Bal |  |  |  |  |  |  |  | 89.1 | CR | L30668 | 46
2021-05-13 00:00:00 | Pay | 031814 | layerEFT |  |  |  | 89.1 |  | 0 |  | L30668 | 46 | 1 day
2021-05-17 00:00:00 | Inv | 892782 |  |  | 201.71 | CR |  |  | 201.71 | CR | L30668 | 47
2021-05-14 00:00:00 | Inv | 005965 |  |  | 1689.6 | CR |  |  | 1689.6 | CR | L31003 | 46
2021-05-19 00:00:00 | O/Bal |  |  |  |  |  |  |  | 201.71 | CR | L30668 | 47
2021-05-20 00:00:00 | Pay | 031816 | layerEFT |  |  |  | 201.71 |  | 0 |  | L30668 | 47 | 3 days
2021-05-19 00:00:00 | O/Bal |  |  |  |  |  |  |  | 1689.6 | CR | L31003 | 47
2021-05-20 00:00:00 | Pay | 031816 | layerEFT |  |  |  | 1689.6 |  | 0 |  | L31003 | 47 | 6 days
Spreadsheet: 124605d1318501985-excel-2007-macro-to-count-sheet-records-macro-for-salesrecord
Sheet: Totolrecords

Date | [NAME] name | Product code | Quantity | Price | Total
2011-10-12 00:00:00 | [NAME] | 15805 | 20 | 2
2011-10-12 00:00:00 | [NAME] | 15803 | 500 | 4
2011-10-12 00:00:00 | [NAME] | 15802 | 15 | 25
2011-10-12 00:00:00 | [NAME] | [NAME] | 80 | 50
2011-10-12 00:00:00 | Sophie | -4616 | 12 | 15
2011-10-12 00:00:00 | [NAME] | 15799 | 12 | 15
2011-10-12 00:00:00 | [NAME] | 15733 | 32 | 15
2011-10-11 00:00:00 | Sophie | 2514 | 151 | 30
2011-10-11 00:00:00 | Sophie | 6252 | 500 | 45
2011-10-11 00:00:00 | Sophie | 365 | 360 | 85
2011-10-11 00:00:00 | Sophie | 154 | 480 | 55
2011-10-11 00:00:00 | Sophie | EN-X85YX | 500 | 53
2011-10-11 00:00:00 | [NAME] | 573 | 1000 | 44