tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92470d1292018117-need-help-with-database-worksheet-to-be-tallied
Sheet: Sheet1

Date | [NAME] | Check# | Description | Null | Amount
2010-01-05 00:00:00 | Deposit |  | FUNDS RECD |  | 546
2010-01-06 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | -546
2010-01-06 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | 10
2010-01-06 00:00:00 | Check | 4155 | CHECK #04155 AAMCO |  | -5.01
2010-01-06 00:00:00 | Dividend |  | HPQ - HEWLETT-PACKARD COMPANY 010610 200 |  | 16
2010-01-07 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | -16
2010-01-08 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | 0.02
2010-01-08 00:00:00 | Ach Activity |  | AUTOMATED DEBIT UHG OVATIONS PREMIUM |  | 0.02
2010-01-11 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | 84.99
2010-01-11 00:00:00 | Ach Activity |  | AUTOMATED DEBIT CHASE CARD SERV ONLINE PMT |  | -84.99
2010-01-13 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | -1
2010-01-13 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | 127.39
2010-01-13 00:00:00 | Ach Activity |  | AUTOMATED DEBIT COMMONWEALTH ED ONLINE PMT |  | -64.47
2010-01-13 00:00:00 | Ach Activity |  | AUTOMATED DEBIT AT&T ONLINE PMT |  | -62.92
2010-01-13 00:00:00 | Ach Activity |  | AUTOMATED CREDIT US TREASURY 303 SOC SEC |  | 1
2010-01-19 00:00:00 |  |  | BANK DEPOSIT SWEEP | 1 | 1.5
2010-01-19 00:00:00 | Ach Activity |  | AUTOMATED DEBIT UNITED OMAHA HTH JAN INSPRM |  | -1.5
Spreadsheet: 91f8091b-1f32-47f7-9d60-50e66fc130ba
Sheet: NON-RESIDENTIAL 

 |  |  |  |  |  |  |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  |  |  |  |  |  |  | NOVEMBER 2014 NON-RESIDENTIAL DATA
APPLICATION TYPE |  | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  |  | PERMIT NUMBER |  |  | SQUARE FOOTAGE | VALUATION | CONTRACTOR
 | Street Number | Street Name | Suffix | [NAME] | Unit | Block | Lot | Tr | Permit Year | Permit number | STATUS | YMMDD
NON-RESIDENTIAL REMODEL/INTERIOR TENANT IMPROVEMENT
RCOM | 3575 | NM HIGHWAY 528 |  | NE | PEH |  |  |  | 14 | 7247 | AP | 141104 | 6235 | 539452 | OUT TO BID
RCOM | 4100 | HIGH RESORT | BLVD | SE | HR |  |  |  | 14 | 7232 | AP | 141103 | 2574 | 200000 | PLATINUM BUILDERS CORPORATION
OFRE | 2240 | GRANDE | BLVD | SE | GS |  |  |  | 14 | 7649 | PC | 141125 | 1767 | 173025 | DPC CONSTRUCTION
OFRE | 2240 | GRANDE | BLVD | SE | GS |  |  |  | 14 | 7648 | AP | 141125 | 1567 | 153441 | DPC CONSTRUCTION
OFRE | 2320 | GRANDE | BLVD | SE | GS |  |  |  | 14 | 7647 | PC | 141125 | 1550 | 151776 | DPC CONSTRUCTION
OFRE | 2351 | HP | WY | NE | CCNTR |  |  |  | 14 | 7725 | PC | 141126 | 1000 | 35000 | ENTERPRISE BUILDERS CORP
INTERIOR TENANT IMPROVEMENT STARTS |  |  |  |  |  |  |  |  |  |  |  |  | VALUATION TOTAL
Spreadsheet: 776138d1649522235-using-eomonth-fuel-calculations-temp-2-bsb-
Sheet: Water use

E&S SC Yr/Mth | 40.88 | 3.41 | E&S | [NAME] | Total | E&S | [NAME] | Total
AWG SC Yr/Mth | 87 | 7.25 | £1.33 m3 | £1.565 m3 | Metered | Inc SC | Inc SC | Inc SC
Date | Reading | Useage | Cost | Cost | Cost | Cost | Cost | Cost
2021-11-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Installed
2021-12-02 00:00:00 | 3.47 | 3.47 | 4.61 | 5.43 | 10.04 | 8.02 | 12.68 | 20.7
2022-01-02 00:00:00 | 6.51 | 3.043 | 4.04 | 4.76 | 8.81 | 7.45 | 12.01 | 19.46 | Used to be £62  month total
2022-02-02 00:00:00 | 9.18 | 2.667 | 3.54 | 4.17 | 7.72 | 6.95 | 11.42 | 18.37
2022-03-02 00:00:00 | 12 | 2.82 | 3.75 | 4.41 | 8.16 | 7.15 | 11.66 | 18.82
2022-04-02 00:00:00 | 15.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-05-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-06-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-07-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-08-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-11-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-12-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-01-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-05-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-06-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-07-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-08-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-11-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-12-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-01-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-03-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-04-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-05-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-06-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-07-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
=EOMONTH(A1,0)+1
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE]
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 798181d1664355082-lookup-fucntion-to-pull-information-from-many-column-formal-pmi-dashboard-v2
Sheet: WIP PMI - MALAYSIA

WORK IN PROGRESS PMI
 | NAME | NO PASSPORT | SPONSOR | COUNTRY | REGION | TGL BIO | TGL MCU | TGL SML | TGL RE-MCU #2 | TGL PASSPORT | TGL UJK | TGL FWCMS | TGL VDR | TGL ENDORSE VISA | TGL PK | TGL FGR MEDICAL | TGL PAP | TGL FLY | PLT | OPEN/CLOSED | AGENCY
 |  |  |  |  |  | 2022-08-09 00:00:00 | 2022-05-09 00:00:00 |  |  | 2022-09-16 00:00:00 |  |  |  |  |  | 2022-05-09 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-08-22 00:00:00 |  |  | 2022-02-09 00:00:00 |  |  |  |  | 2022-07-09 00:00:00 | 2022-08-22 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-08-22 00:00:00 |  |  | 2022-02-09 00:00:00 |  |  |  |  | 2022-07-09 00:00:00 | 2022-08-22 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-09-14 00:00:00 | 2022-06-09 00:00:00 |  |  | 2022-09-21 00:00:00 |  |  |  |  |  | 2022-06-09 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-06-06 00:00:00 |  |  | 2022-06-21 00:00:00 |  |  |  |  | 2022-06-09 00:00:00 | 2022-06-06 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-05-09 00:00:00 |  |  | 2022-09-09 00:00:00 | 2022-09-22 00:00:00 |  |  |  | 2022-09-16 00:00:00 | 2022-05-09 00:00:00 |  |  |  |  | ARENA
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-08-25 00:00:00 |  |  | 2022-09-08 00:00:00 | 2022-09-20 00:00:00 |  |  |  | 2022-08-23 00:00:00 | 2022-08-25 00:00:00 | 2022-09-23 00:00:00 | 2022-09-29 00:00:00 |  |  | VAIR VICTORY
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-06-18 00:00:00 | 2022-09-13 00:00:00 |  | 2022-02-09 00:00:00 |  |  |  |  | 2022-07-09 00:00:00 | 2022-06-18 00:00:00 |  |  |  |  | VAIR VICTORY
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-11-08 00:00:00 |  |  | 2022-12-08 00:00:00 | 2022-08-13 00:00:00 |  |  |  | 2022-08-24 00:00:00 | 2022-11-08 00:00:00 | 2022-09-23 00:00:00 | 2022-09-29 00:00:00 |  |  | VAIR VICTORY
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-11-08 00:00:00 |  |  | 2022-12-08 00:00:00 | 2022-08-13 00:00:00 |  |  |  | 2022-08-24 00:00:00 | 2022-11-08 00:00:00 | 2022-09-23 00:00:00 | 2022-09-29 00:00:00 |  |  | VAIR VICTORY
 |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-08-30 00:00:00 |  |  | 2022-09-19 00:00:00 |  |  |  |  | 2022-07-09 00:00:00 | 2022-08-30 00:00:00 |  |  |  |  | VAIR VICTORY
 |  |  |  |  |  | 26 Sept 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARENA
 |  | 1. As you can see on cell B9,B11,B16 - the formula is pulling the same data from SHEET → BIODATA MASTER
 |  | 2. Is there any lookup formula that can "lock" the correct data eventhough the NAME is excalty the same?
 |  | 3. see rows 16 from SHEET → BIODATA MASTER
 | *Conditional formating (highlight duplicate value)
Spreadsheet: 9c9e9074-3a62-42a5-a4d2-7c4f0d8b3872
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
Advanced Pipe Inspection, Inc. | 1895 River St. | [NAME], MA  02136 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Amstar of Western NY |  |  |  |  | [EMAIL] | [NAME]
Amethyst Environmental Ltd. | 22 [NAME] | [NAME], NH  03824 | [PHONE] |  | [EMAIL] | [NAME]
Bridges, LLC | 85 South Bow Street | Milford, MA 01757 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Concrete Systems, Inc. | 9 Commercial Street | Hudson, NH 03051 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
D'Allessandro Corp. | 41 [NAME] | Avon, MA 02322 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
[NAME], Inc. | 10York Avenue | Randolph, MA |  |  | [EMAIL] | [NAME]
[NAME], Inc. | 162 North Main Street | [NAME], MA 01949 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Fed. Corp. | 1039 East Street | Dedham, MA 02026 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
[NAME] | 99 Stockhouse Road | Bozrah, CT 06334 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
H.R. Prescott & Sons Inc. | 165 Hartford Street | West Boylston, MA 01583 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Hemi |  |  |  |  | [EMAIL] | [NAME]
Insituform | 253B Worcester Road | Carlton, MA 01507 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Marcel Payeur Painting |  |  |  |  | [EMAIL] | Marcel Payeur
McLaughlin Bros. Contracting Corp. | 120 [NAME] Street | Brockton, MA 02302 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
National Water Main & Cleaning Co. | 875  N. Summer Ave. | Newark, NJ 07104 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
New England Pipe Cleaning Co. | 99 Callender Road | Watertown, CT 06795 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Northeast Surface Systems |  |  |  |  | [EMAIL] | Shawn Fredericks
Revoli Construction Co., Inc. | 90 Earls Way | Franklin, MA 02038 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Reynolds Inliner, LLC | 195A Norridgewock Road | Fairfield, ME 04937 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
RJ Forbes Co |  |  |  |  | [EMAIL] | [NAME]
[NAME] |  |  |  |  | [EMAIL] | [NAME]
Rockwood |  |  |  |  | [EMAIL] | [NAME]
Tro-Con Corp | 5 Skyview Road | Woburn, MA 01801 | [PHONE] |  | [EMAIL] | [NAME]
Umbro & Sons | 44 Reading Street | Boston, MA 02119 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Weston & Sampson | 5 Centennial Drive | Peabody, MA 01960 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Spreadsheet: 215442d1361379425-highlighting-cells-to-show-percentage-complete-pipeline-progress-chart
Sheet: Sheet1

Station Number | 0 | 500
Activity
String 12" Pipe
Weld 12" Pipe
Coat and Jeep 12" Pipe
Ditch and Lower in 12" Pipe
Tie In 12" Pipe
String 6" Pipe
Weld 6" Pipe
Coat and Jeep 6" Pipe
Ditch and Lower in 6" Pipe
Tie in 6" Pipe
String 10" Pipe
Weld 10" Pipe
Coat and Jeep 10" Pipe
Ditch and Lower in 10" Pipe
Tie In 10" Pipe
String 3" Pipe
Weld 3" Pipe
Coat and Jeep 3" Pipe
Ditch and Lower in 3" Pipe
Tie In 3" Pipe
Station Number | 10500
String 12" Pipe
Weld 12" Pipe
Coat and Jeep 12" Pipe
Ditch and Lower in 12" Pipe
Tie In 12" Pipe
String 6" Pipe
Weld 6" Pipe
Coat and Jeep 6" Pipe
Ditch and Lower in 6" Pipe
Tie in 6" Pipe
String 10" Pipe
Weld 10" Pipe
Coat and Jeep 10" Pipe
Ditch and Lower in 10" Pipe
Tie In 10" Pipe
String 3" Pipe
Weld 3" Pipe
Coat and Jeep 3" Pipe
Ditch and Lower in 3" Pipe
Tie In 3" Pipe
Station Number | 21000 |  | 21700 | % Complete
String 12" Pipe
Weld 12" Pipe
Coat and Jeep 12" Pipe
Ditch and Lower in 12" Pipe
Tie In 12" Pipe
String 6" Pipe
Weld 6" Pipe
Coat and Jeep 6" Pipe
Ditch and Lower in 6" Pipe
Tie in 6" Pipe
String 10" Pipe
Weld 10" Pipe
Coat and Jeep 10" Pipe
Ditch and Lower in 10" Pipe
Tie In 10" Pipe
String 3" Pipe
Weld 3" Pipe
Coat and Jeep 3" Pipe
Ditch and Lower in 3" Pipe
Tie In 3" Pipe
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: 5

Page 5 |  |  |  |  |  |  |  |  | CASH OUT #
 |  |  | CAMPSITE SALES CONTINUATION SHEET
Prepared By: |  | [NAME] |  |  |  |  | DEPT: |  |  |  |  |  |  | Work Sheet Page 5
Opening Date: |  |  |  |  |  |  | Closing Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number
 | Permit #/ |  | NRRS | GA |  |  |  |  |  |  |  |  |  |  | Permit #/ |  | Site |  |  | Camping | Utility | Number |  | Actual $ | CK |  |  |  | Extra |  | Actual | CK |  |  |  | Total | Total | Total
 | Envelopes |  |  |  | Cash | Check | Credit | Cash | Check | Credit | TOTALS |  |  |  | Envelopes | Date | Number | NRRS | GA | Fee/Day | Fee/Day | Of Days | $$$$$$$$ | Paid | C | Ccash | Ccheck | Ccredit | Vehicles | $$$$$$$$ | Paid | C | EVCash | EVCheck | EVCredit | Cash | Check | Credit | TOTALS
80 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 2013-02-17 00:00:00 | 35 |  |  | 38 |  | 1 |  |  | C
81 |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
82 |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
83 |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 |  | 2013-02-18 00:00:00 | 1 |  |  | 19 |  | 1 |  |  | C |  |  |  | 1 |  |  | CK
84 |  |  |  |  |  |  |  |  |  |  |  |  |  | 84
85 |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
86 |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
87 |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 |  | 2013-02-19 00:00:00 | 74 |  |  | 21 |  | 1 |  |  | C |  |  |  | 1 |  |  | CK
88 |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
89 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89
90 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 2013-02-20 00:00:00 | 17 |  |  | 19 |  | 2 |  |  | C |  |  |  | 2 |  |  | CK
91 |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
92 |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
93 |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 |  | 2013-02-21 00:00:00 | 41 |  |  | 21 |  | 3 |  |  | C |  |  |  | 1 |  |  | CK
94 |  |  |  |  |  |  |  |  |  |  |  |  |  | 94
95 |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
96 |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 |  | 2013-02-22 00:00:00 | 19 |  |  | 9.5 |  | 2 |  |  | C |  |  |  | 1 |  |  | CK
97 |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
98 |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
99 |  |  |  |  |  |  |  |  |  |  |  |  |  | 99
100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 2013-02-23 00:00:00 | 39 |  |  | 21 |  | 3 |  |  | C |  |  |  | 1 |  |  | CK
101 |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
102 |  |  |  |  |  |  |  |  |  |  |  |  |  | 102
Totals This Page
Spreadsheet: michelle_lokay__26605__sharris0101wk4
Sheet: Estimate Vs. Plan

Transwestern Pipeline Company
($[NAME])
Jan week 4   01-26-2001
 |  | January, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | Tenaska K @ Max Rates
West Commodity Revenues
East Demand Revenues |  |  |  |  |  | [NAME] for 10/day @ $0.50
East Commodity Revenues
[NAME]
[NAME] Revenues |  |  |  |  |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance
[NAME] due to Price |  |  |  |  |  | MTD index price of $8.00 vs. Plan index price of $3.90 for unhedged vols.
[NAME] due to net fuel retention. |  |  |  |  |  | Higher  volumes than Plan
Hedging Adjustment |  |  |  |  |  | Add'l price on physical sales
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Unaccounted for Variance
 |  |  |  | -------------
Fuel Variance
 |  |  |  | -------------
MONTH-TO-DATE VARIANCE
 |  |  |  | ========
2001 Stretch |  | 0.85 | 0
 |  |  |  | -------------
ADJUSTED MONTH-TO-DATE VARIANCE
 |  |  |  | ========
[NAME]
 | Year-to-Date
 | Margin | Fuel & UAF | Stretch | Total
Plan (through January) | 13.2401 |  | 0.85
Estimate
 | ------------- | ------------- | ------------- | -------------
Variance from Plan
 | ------------- | ------------- | ------------- | -------------
Spreadsheet: 692945d1598646199-dynamic-range-stop-at-blank-and-resume-down-the-column-dyn-range-forum
Sheet: dyn-range

var1 | var2 | data | % to 'a'
1.0 | a | 21 |  |  |  |  | Used the subtotal from pivot (var1) to introduce an "" in var2 to use it as a stopping point for dynamic range
1.0 | a1 | 34 |  |  |  |  | Dynamic ranges desired is B2:[NAME], then B7:C8, then B10:C14, then B16:C17
1.0 | a2 | 24 |  |  |  |  | % to be calc with "a" as the reference for each dynamic range: i.e., D2=a/a,D3=a/[NAME]=a/a2 and so on.
1.0 | a3 | 45 |  |  |  |  | If there is no "a" in a dynamic range, the result needs to be "NA".
1.0 Total |  | 124 | NA
2.0 | a | 54 | 1
2.0 | a1 | 65
2.0 Total |  | 119 | NA
3.0 | a | 1 | 1
3.0 | a1 | 2
3.0 | a2 | 5
3.0 | a3 | 1
3.0 | a4 | 3
3.0 Total |  | 12 | NA
4.0 | a3 | 2 | NA
4.0 | a4 | 5 | NA
4.0 Total |  | 7 | NA
Spreadsheet: 688569d1595855481-reset-button-for-pressure-column-and-remove-cell-color-pressure-2-
Sheet: Masterlist

PressureThreshold | 110
Completed Pressure
 |  | SEPT |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  | DEC
 | Current | 2019-09-04 00:00:00 |  |  | 2019-09-08 00:00:00 |  |  | 2019-09-12 00:00:00 |  |  | 2019-09-15 00:00:00 |  |  | 2019-10-01 00:00:00 |  |  | 2019-10-05 00:00:00 |  |  | 2019-10-10 00:00:00 |  |  | 2019-10-12 00:00:00 |  |  | 2019-11-02 00:00:00 |  |  | 2019-11-05 00:00:00 |  |  | 2019-11-10 00:00:00 |  |  | 2019-11-22 00:00:00 |  |  | 2019-12-16 00:00:00
Car Machine | Pressure | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter | Total hour | Pressure | Oil Liter
JAW 302 |  | 100H32M | 500 | 8 | 100H32M | 200 | 8 |  |  |  | 500H60M | 300 | 8 |  | 100 |  |  |  |  | 800H45M | 20 | 1 | 20H10M | 20 | 0.5 |  |  |  |  | 10 |  |  | 20 |  |  |  |  | 20H10M | 75 | 0.5
BET 102 |  | 400H30M | 112 | 9 | 203H18M | 90 | 9 | 203H18M | 30P | 9 | 203H18M | 30 | 9 | 203H18M | 109.8 | 9 | 700H60M | 10 | 9 | 150H69M | 25.63 | 2 |  |  |  | 20H10M | 150.96 | 0.5 |  |  |  |  |  |  |  |  |  | 20H10M | 113.6 | 0.5
JAC 209 |  | 309H12M | 110 | 6 | 450H63M | 120.9P | 6 |  |  |  | 309H12M | 120.9P | 6 | 309H12M | 120.9P | 6 | 309H12M | 120.9P | 6 | 20H30M | 0.1 | 3 |  |  |  |  |  |  | 20H10M | 90 | 0.5 |  |  |  | 20H10M | 150.96 | 0.5
 |  |  | Question:-
 |  |  | Change of a bit structure.
 |  |  | A bit long but I hope this will work. For example, Car machine [NAME].
 |  |  | Current Pressure was 3 in red background color. After repaired, the technician will turn the color to green.
 |  |  | For [NAME] and G7. |  | So, 3 red minus 2 green = 1 red
 |  |  | How to turn the [NAME] and G7 to green color based on the technician repaired the pressure?
 |  |  | So that the current pressure is 1
Spreadsheet: 112794d1308786595-drop-down-menu-variable-fields-pulldownexample
Sheet: Sheet1

 |  | Company 1
Company |  | 4000 |  | 4001 |  | 4002 |  |  |  |  |  | Company 1
Company 1 |  |  |  |  |  |  |  |  |  |  |  | Company 2
 |  | 4003 |  | 4004 |  | 4005 |  |  |  |  |  | Company 3
 |  |  |  |  |  |  |  |  |  |  |  | Company 4
 |  | 4006 |  | 4007 |  | 4008 |  |  |  |  |  | Company 5
 |  |  |  |  |  |  |  |  |  |  |  | Company 6
 |  | 4009 |  | 4010 |  | 4011 |  |  |  |  |  | Company 7
 |  |  |  |  |  |  |  |  |  |  |  | Company 8
 |  |  |  |  |  |  |  |  |  |  |  | Company 9
 |  |  |  |  |  |  |  |  |  |  |  | Company 10
Above: What I want company 1 to look like when selected from a drop down meny |  |  |  |  |  |  |  |  |  |  |  | Company 11
 |  |  |  |  |  |  |  |  |  |  |  | Company 12
 |  |  |  |  |  |  |  |  |  |  |  | Company 13
Below: When I check company 2 from the drop down box, I want all the fields to change. And so on when I click Copany 3 (I want that to change to values that all start with "6")
 |  | Company 2
Company |  | 5000
Company 2
 |  | 5003 |  | 5004 |  | 5005
 |  | 5006 |  | 5007 |  | 5008
 |  | 5009 |  | 5010 |  | 5011
Spreadsheet: 802914d1667145376-vlookup-hlookup-match-index-with-countifs-labour-allocation-spreadsheet-example-aligw
Sheet: Role Daily Allocation

Input Date Below
2022-10-31 00:00:00 | Project 1 | Project 2 | Project 3
Joiner
Plumber
Tiler
Electrician
Spreadsheet: larry_campbell__21029__BrownfieldPTE
Sheet: Summary

NORTHERN NATURAL GAS COMPANY
BROWNFIELD COMPRESSOR STATION
TNRCC ACCOUNT NO. TD-0063-I
Summary of Emissions
Unit | POTENTIAL TO EMIT
ID | SO2 | NOx | CO | VOC | PM | Formaldehyde | Total HAP
A-1
T-1
TK-1 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-2 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-3 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
F-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LOAD | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
Note:
1. Tank emissions include breathing and working losses only.
Spreadsheet: 525999d1499075690-averageif-help-s666-operational-reporting-analyst-test-2
Sheet: Summary

 | Service Overview - OPEN roles
 | Current Open Roles |  |  |  |  |  | CHART 1 Open Roles by Department
 | [NAME]. days open
 | % Ageing Roles
 | Open Roles by Region
 | APAC
 | EMEA
 | LATAM
 | USA
 | Service Overview - FILLED roles
 |  | 2014 | 2014 | 2014 | 2014 | 2015 | 2015 | 2015 | 2015 | 2016 | 2016 | 2016 | 2016 | 2017 | 2017 | 2017 | 2017
 | APAC | Financial Year 2014 |  |  |  | Financial Year 2015 |  |  |  | Financial Year 2016 |  |  |  | Financial Year 2017
 |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
 | APAC
 | EMEA
 | LATAM
 | USA
 | Total Rolles Filled
 | Avg. Time to [NAME]
 | Source of [NAME] FY17 |  |  |  |  | Filled Roles by Region FY17
 | CHART2 (Pie chart) Number of filled role by billing type FY17 only! |  |  |  |  | CHART 3 Filled Roles by Region FY17 only!
Spreadsheet: 884912d1734271205-late-entry-formula-late-formula
Sheet: Sheet1

HUSSEIN A HASSANI | 2024-12-13 | Fri. | - | -
HUSSEIN A HASSANI | 2024-12-14 | Sat. | 09:28:20 | 18:00:09 | LATE
HAJI OMARY | 2024-12-13 | Fri. | - | -
HAJI OMARY | 2024-12-14 | Sat. | - | -
FILBERT DAUDI | 2024-12-13 | Fri. | - | -
FILBERT DAUDI | 2024-12-14 | Sat. | 08:47:39 | 17:54:41 | LATE
SELEMAN LEIYA | 2024-12-13 | Fri. | - | -
SELEMAN LEIYA | 2024-12-14 | Sat. | 08:47:41 | 11:53:43 | LATE
ATHUMAN SEIF | 2024-12-13 | Fri. | - | -
ATHUMAN SEIF | 2024-12-14 | Sat. | [NAME] | 18:37:24
RAMADHANI SALAMBA | 2024-12-13 | Fri. | - | -
RAMADHANI SALAMBA | 2024-12-14 | Sat. | 08:39:42 | 18:00:00