tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40544__G&A_by_Account
Sheet: Expenses

ENRON CLEAN FUELS
2001 G&A COSTS - PLAN
(in thousands)
 |  |  |  | Business
 |  |  |  | Unit
Expenses by Account:
Salaries |  |  |  | 14819
Benefits |  |  |  | 3664
Payroll taxes |  |  |  | 1374
Employee Expenses |  |  |  | 985
Advertising |  |  |  | 0
Communications expense |  |  |  | 267
Contributions |  |  |  | 23
Computer expense |  |  |  | 186
Insurance |  |  |  | 2019
Outside services |  |  |  | 8415
Engineering & Construction |  |  |  | 0
Postage & Freight |  |  |  | 10
Subscriptions |  |  |  | 0
Materials & supplies |  |  |  | 7135
Supply expense |  |  |  | 0
Rent expense |  |  |  | 766
Utilities |  |  |  | 21524
Other |  |  |  | 1359
Allocations |  |  |  | 2962
Capitalized costs* |  |  |  | 0
Total
*Please provide detail
Expenses by Function:
Commercial |  |  |  | 512
Structuring |  |  |  | 0
Logistics |  |  |  | 0
Other Mid-office |  |  |  | 0
Field Personnel |  |  |  | 56193
Settlements |  |  |  | 0
Legal |  |  |  | 0
Accounting |  |  |  | 224
Tax |  |  |  | 0
Information Technology |  |  |  | 0
Human Resource |  |  |  | 168
Administrative |  |  |  | 1223
ETS & Corporate Staff |  |  |  | 7188
Total
Spreadsheet: marie_heard__24499__conoco cob 110601
Sheet: t_9429

Counterparty | Parent | Enron Entity | Fin. MTM | Phy. MTM | Sales | Purchases | Net Del. | Net Phys. | ENE's Exp | CP's Exp
Conoco (UK) Limited | Conoco Inc. | Enron Capital & Trade Resources Limited | 0 | -3873280 | 10056344 | -10928187 | -871843 | -4745123
Conoco Canada Limited | Conoco Inc. | Enron Canada Corp. | 0 | -205522 | 4143207 | -1420906 | 2722301 | 2516779
Conoco Canada Limited | Conoco Inc. | Enron North America Corp. | 0 | 86926 | 558048 | 0 | 558048 | 644974
Conoco Inc. | Conoco Inc. | ENA Upstream Company LLC | 0 | 105484 | 3071857 | -140439 | 2931418 | 3036902
Conoco Inc. | Conoco Inc. | Enron Energy Marketing Corp. | 0 | 0 | 1055 | 0 | 1055 | 1055
Conoco Inc. | Conoco Inc. | Enron Energy Services, Inc. | 0 | 168 | 0 | 0 | 0 | 168
Conoco Inc. | Conoco Inc. | Enron Gas Liquids, Inc. | 0 | -477120 | 351702 | -2404934 | -2053232 | -2530352
Conoco Inc. | Conoco Inc. | Enron Liquid Fuels, Inc. | 0 | -104955 | 0 | -1361796 | -1361796 | -1466751
Conoco Inc. | Conoco Inc. | Enron North America Corp. | 6477594 | -571002 | 6102975 | -15536091 | -9433116 | -10004118
Conoco Inc. | Conoco Inc. | Enron Power Marketing, Inc. | 0 | 34435 | 650000 | -1097460 | -447460 | -413025
Conoco Inc. | Conoco Inc. | Enron Reserve Acquisition Corp. | 0 | 55024 | 22780567 | -17147635 | 5632932 | 5687956
Conoco Inc. | Conoco Inc. | LOA, Inc. | 0 | 0 | 6735 | 0 | 6735 | 6735
Conoco International Inc. | Conoco Inc. | Enron Capital & Trade Resources International Corp. | -1 | 0 | 0 | 0 | 0 | 0
Conoco Limited | Conoco Inc. | Enron Capital & Trade Resources International Corp. | -953 | 852832 | 0 | 0 | 0 | 852832
Gulf Canada Resources Limited | Conoco Inc. | Enron Canada Corp. | 1332499 | -898548 | 0 | 0 | 0 | -898548
Saras Energia S.A. | Conoco Inc. | Enron Holdings 1, S.L. | 0 | 918058 | 10973472 | -2086584 | 8886888 | 9804946
Societe Europeenne de Carburants N.V. | Conoco Inc. | Enron Capital & Trade Resources International Corp. | -19179 | 272394 | 1244596 | 0 | 1244596 | 1516990
Spreadsheet: 106331d1303498936-excel-2003-macro-to-find-page-range-and-delete-all-blank-rows-check-history-sample
Sheet: Sheet1

 | Num |  | Date |  | Name |  | Memo | Paid Amount
 | 12345 |  | 2011-04-01 00:00:00 |  | I R S |  | PR PD 3/25/11
 |  |  |  |  |  |  | PR PE 3/19/11 | -1142.73
 | 12346 |  | 2011-04-01 00:00:00 |  | Berkadia Commercial Mortgage |  | Loan # 460003053
 |  |  | 2011-03-01 00:00:00 |  |  |  | March payment | -10788.86
 |  |  |  |  |  |  | March payment | -2282.87
 |  |  |  |  |  |  | March impound deposit | -194.81
 |  |  |  |  |  |  | March impound deposit | -90.19
 |  |  |  |  |  |  | March impound deposit | -1811.58
 |  |  |  |  |  |  | March R/R Deposit | -4307.67
 | 12349 |  | 2011-04-01 00:00:00 |  | Air Conditioning Solutions |  | Inv 3227
 |  |  |  |  |  |  | Insulate boiler & tank | -1000
 |  |  |  |  |  |  | Sales Tax | -40.24
 | 12350 |  | 2011-04-01 00:00:00 |  | H D Supply
 | 910739220 |  | 2011-04-01 00:00:00 |  |  |  | Inv. [NAME], tissue, bleach, wardrobe guides | -396.67
 | [PHONE] |  | 2011-04-01 00:00:00 |  |  |  | Faucets/batteries/flappers | -645.11
 | 60003 |  | 2011-04-01 00:00:00 |  | Encore Fire Extinguisher Service |  | Inv 4953
 |  |  |  |  |  |  | Service fire extinguishers | -191.25
 |  |  |  |  | TOTAL - ALL CHECKS
 | my documents/check history sample
Spreadsheet: 715733d1611846363-sum-values-by-month-year-example
Sheet: Sheet1

 |  | Stock # | # of Photos | Date | List is sorted by most recent date first | temp-pic | reloaded | not in VA | re-shoot
[NAME] |  | 210035 | 52 | 2021-01-27 00:00:00
[NAME] |  | 210013 | 58 | 2021-01-27 00:00:00 |  |  | Total Cars | Total Pics | Avg Pics/Car
 |  | 2 | 110 |  |  | 2021 | 105 | 4994 | 48
[NAME] |  | 210014 | 54 | 2021-01-26 00:00:00 |  | 2021-12-21 00:00:00
[NAME] |  | 210042 | 57 | 2021-01-26 00:00:00 |  | 2021-11-21 00:00:00
[NAME] |  | 201029B | 55 | 2021-01-26 00:00:00 |  | 2021-10-21 00:00:00
[NAME] |  | 210021 | 53 | 2021-01-26 00:00:00 |  | 2021-09-21 00:00:00
[NAME] |  | 201346 | 58 | 2021-01-26 00:00:00 |  | 2021-08-21 00:00:00
[NAME] |  | 210052 | 62 | 2021-01-26 00:00:00 |  | 2021-07-21 00:00:00
 |  | 6 | 339 |  |  | 2021-06-21 00:00:00
[NAME] | modified | 201304 | 4 | 2021-01-25 00:00:00 |  | 2021-05-21 00:00:00
[NAME] |  | 210012 | 53 | 2021-01-25 00:00:00 |  | 2021-04-21 00:00:00
[NAME] |  | 210041 | 55 | 2021-01-25 00:00:00 |  | 2021-03-21 00:00:00
[NAME] |  | 201313 | 58 | 2021-01-25 00:00:00 |  | 2021-02-21 00:00:00
 |  | 4 | 170 |  |  | 2021-01-21 00:00:00 | 157 | 4994 | 48
[NAME] |  | 201090J | 10 | 2021-01-22 00:00:00 |  | 2020 | 1369 | 65166 | 48
[NAME] | modified | 201343 | 16 | 2021-01-22 00:00:00 |  | 2021-12-20 00:00:00 | 83 | 3626 | 44
[NAME] |  | 201322 | 58 | 2021-01-22 00:00:00 |  | 2021-11-20 00:00:00 | 119 | 5724 | 48
[NAME] | modified | 201290 | 16 | 2021-01-22 00:00:00 |  | 2021-10-20 00:00:00 | 142 | 6854 | 48
[NAME] | modified | 201184A | 21 | 2021-01-22 00:00:00 |  | 2021-09-20 00:00:00 | 110 | 5610 | 51
[NAME] | modified | 201287 | 13 | 2021-01-22 00:00:00 |  | 2021-08-20 00:00:00 | 116 | 5119 | 44
[NAME] | modified | 201258 | 24 | 2021-01-22 00:00:00 |  | 2021-07-20 00:00:00 | 127 | 6113 | 48
[NAME] |  | 201081a | 52 | 2021-01-22 00:00:00 |  | 2021-06-20 00:00:00 | 146 | 8069 | 55
[NAME] |  | 201341 | 51 | 2021-01-22 00:00:00 |  | 2021-05-20 00:00:00 | 100 | 4578 | 46
 |  | 9 | 261 |  |  | 2021-04-20 00:00:00 | 72 | 3449 | 48
[NAME] |  | 210004 | 52 | 2021-01-21 00:00:00 |  | 2021-03-20 00:00:00 | 118 | 5772 | 49
[NAME] |  | 210026 | 47 | 2021-01-21 00:00:00 |  | 2021-02-20 00:00:00 | 116 | 5304 | 46
[NAME] |  | 210003 | 54 | 2021-01-21 00:00:00 |  | 2021-01-20 00:00:00 | 120 | 4948 | 41
[NAME] |  | 201304 | 46 | 2021-01-21 00:00:00 |  | 2019 | 1353 | 46223 | 34
[NAME] |  | 201331 | 46 | 2021-01-21 00:00:00
[NAME] |  | 210051 | 65 | 2021-01-21 00:00:00
 |  | 6 | 310
Spreadsheet: 804115d1667902215-index-and-match-formula-with-2-criteria-inc-nearest-date-sample-index-match
Sheet: Sheet1

 |  |  | No. Ship | 1-C01 | 1-C02 | 1-C03 | 1-C04 | 1-C05 | 1-C06
 | Part No. | Part Name | ETA | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 2022-11-10 00:00:00 | 2022-11-10 00:00:00
 |  |  | Status | Rcv | Rcv | Otw | Otw | Otw | Otw
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  | 0 | 90000 | 0 | 102000 | 0 | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  | 2000 | 1920 | 1560 | 3840 | 3200 | 3000
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  | 0 | 1920 | 2568 | 1920 | 3200 | 3000
 | F210010075 | GREASE MULTEMP 2C194 |  | 30 | 0 | 10 | 0 | 25 | 0
 | F210010058 | [NAME] NO.2 |  | 0 | 0 | 0 | 30 | 0 | 10
 | 8020300141 | SPIRAL SPRING MN |  | 0 | 0 | 100 | 0 | 0 | 100 | << Not sure
 | 4535690005 | [NAME] |  | 200 | 0 | 0 | 2000 | 3000 | 0
 | 4038090054 | BRACKET,SEAT TRACK STPR |  | 0 | 0 | 0 | 2400 | 3000 | 0
 | Criteria : | Otw
 | Part No. | Part Name | Qty Otw |  | Qty Otw & Nearest Date |  | First found from left (and min of date) | Sum all matched criteria (every shipment in the same day) | Count all shipment
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  |  | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  |  | 3200
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  |  | 3200
 | F210010075 | GREASE MULTEMP 2C194 |  |  | 25
 | F210010058 | [NAME] NO.2 |  |  | 10
 | 8020300141 | SPIRAL SPRING MN |  |  | 100
 | 4535690005 | [NAME] |  |  | 3000
 | 4038090054 | BRACKET,SEAT TRACK STPR |  |  | 3000
Spreadsheet: 37384d1235387399-display-change-between-dates-in-pivot-rykobyk
Sheet: Sheet1

 |  | Date
 | Product | 1 | 2
Value in Stock | A | 10 | 60
 | B | 20 | 50
 | C | 50 | 40
 | D | 80 | 60
 | E | 90 | 100
 | F | 60 | 50
 | G | 30 | 20
 | H | 20 | 40
 | I | 40 | 50
Value Bought | A |  | 50
 | B |  | 30
 | C
 | D
 | E |  | 10
 | F
 | G
 | H |  | 20
 | I |  | 10
 | TOTAL |  | 120
[NAME] | A
 | B
 | C |  | 10
 | D |  | 20
 | E
 | F |  | 10
 | G |  | 10
 | H
 | I
 | TOTAL |  | 50
Spreadsheet: 827065d1682455165-creating-multiple-dropdown-lists-without-duplicates-dailyschedule
Sheet: Daily Work Schedule

DAILY WORK SCHEDULE
2023-04-25 00:00:00
Service Van Note | JOB NAME |  | WORK ORDER # | MAP [NAME]
SERVICE VAN 4
[NAME] | [NAME] Main St |  | 569685 | 12-12-78
[NAME] | [NAME] 567 [NAME] Rd |  | 567854 | 12-6-85
SERVICE VAN 9
[NAME] | [NAME]
[NAME]
SERVICE VAN 14
[NAME] | [NAME] Some Place |  | 569810 | 11-43-23
[NAME] | [NAME] 100 Golden Lane |  | 568710 | 11-43-15
SERVICE VAN 20
[NAME] | Farmhouse Sub
[NAME]
SERVICE VAN 23
[NAME] | 100 Watkins Lane |  | 568910 | 33-9-12
[NAME] |  |  | 571846 | 33-14-85
SERVICE VAN 33
Preston Holt | [NAME] Funny Rd |  | 568608 | 12-41-56
 | [NAME] |  | 570693 | 12-74-41
SERVICE VAN 34
SERVICE VAN 36
OUT OF OFFICE (people listed in this section should not be available anywhere else) |  |  | SALES
[NAME] | [NAME] |  | VEHICLE 100 | SECTION
 |  |  | [NAME] | 1 - 10
 |  |  | VEHICLE 102 | SECTION
 |  |  | [NAME] | 11 - 20
OTHER (Arriving late, leaving early, etc) |  |  | VEHICLE 104 | SECTION
[NAME] | Leaving at 2pm |  | [NAME] | 21 - 30
 |  |  | TRUCK 106 | SECTION
 |  |  |  | 31 - 40
Spreadsheet: 725811d1616880049-sum-of-total-till-the-current-month-test-2-
Sheet: SUMMARY

S.NO. | TOWER/SHOP/FLAT | PROJECT | PARTY NAME | CONTACT NO. | SECURITY DEPOSIT | MONTHLY RENT | START DATE | END DATE | TOTAL RENT | AMOUNT ACCRUED | TOTAL AMOUNT PAID | LAST MONTH PAID |  | TOTAL DUES | CONTRACT PERIOD | MONTHS PAID | MONTHS UNPAID |  | Current Month
1 | A | AA | Adam |  |  | 400 | 2019-02-01 00:00:00 | 2021-10-01 00:00:00
2 | B | BB | [NAME] |  |  | 300 | 2020-08-01 00:00:00 | 2021-06-01 00:00:00
3 | C | CC | Elijah |  | 60000 | 200 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00
4 | D | DD | [NAME] |  | 30000 | 600 | 2020-09-01 00:00:00 | 2021-08-01 00:00:00
5 | E | EE | [NAME] |  | 50000 | 500 | 2020-10-01 00:00:00 | 2021-08-02 00:00:00
6 | F | FF | [NAME] |  | 30000 | 300 | 2020-10-03 00:00:00 | 2021-08-21 00:00:00
Spreadsheet: 794025d1661854679-search-in-cell-which-includes-specific-value-or-not-vlookup_match
Sheet: Sheet1

 | Sales | Sales | Sales | Sales | Stk
Item | 2019 | 2020 | 2021 | 2022 | 2022
CLT-CT201-C101+100 |  |  | 2 | 1 |  |  |  |  |  |  | CLT-CT201 | CLT-CT201 | CLT-CT201 | CLT-CT201 | CLT-CT201
CLT-CT201-C101+125 |  |  | 2 |  |  |  |  |  |  |  | -C101 | -C701 | -C210 | [NAME] | -C504
CLT-CT201-C101+150 |  |  | 1 |  |  |  |  |  |  |  | Black | [NAME] | Transparent | Dark Red | [NAME]
CLT-CT201-C101+150-BC |  |  |  |  | 2 |  |  |  |  | Stk | C101 | C701 | C294 | C124 | C604
CLT-CT201-C101+175 |  | 1 |  | 1 |  |  |  |  |  | +100
CLT-CT201-C101+175-BC |  |  |  |  | 2 |  |  |  |  | +125
CLT-CT201-C101+200 |  | 1 |  |  |  |  |  |  |  | +150
CLT-CT201-C101+225 |  |  | 5 | 1 |  |  |  |  |  | +175
CLT-CT201-C101+250 | 1 | 1 | 3 | 1 |  |  |  |  |  | +200
CLT-CT201-C101+250-BC |  |  |  |  | 2 |  |  |  |  | +225
CLT-CT201-C101+275 |  | 1 |  |  | 1 |  |  |  |  | +250
CLT-CT201-C101+300 |  | 1 |  |  | 1 |  |  |  |  | +275
CLT-CT201-C109+175 |  | 1 |  |  |  |  |  |  |  | +300
CLT-CT201-C109+275 | 1 |  |  |  |  |  |  |  |  | +350
CLT-CT201-C109+300 | 1 |  |  |  |  |  |  |  |  | +400
CLT-CT201-C124+100-BC |  |  |  | 1 |  |  |  |  |  | Total
CLT-CT201-C124+150-BC |  |  |  |  | 1
CLT-CT201-C124+175-BC |  |  |  | 1
CLT-CT201-C124+200-BC |  |  |  |  | 1
CLT-CT201-C124+250-BC |  |  |  |  | 1
CLT-CT201-C124+300-BC |  |  |  |  | 1
CLT-CT201-C204+100 |  | 1 | 1
CLT-CT201-C204+125 | 1
CLT-CT201-C210+100 | 1 |  | 3
CLT-CT201-C210+125 |  | 3 |  | 1
CLT-CT201-C210+150 | 2 | 1 | 2
CLT-CT201-C210+175 | 1 | 1 | 2 | 3 | 1
CLT-CT201-C210+200 | 1 | 1 | 1 | 1
CLT-CT201-C210+225 |  | 4 |  | 1
CLT-CT201-C210+250 | 1 |  | 1 | 1
CLT-CT201-C210+275 |  | 1 | 1 |  | 2
CLT-CT201-C210+300 |  | 1 | 1 |  | 1
CLT-CT201-C294+100-BC |  |  |  |  | 1
CLT-CT201-C294+150-BC |  |  |  |  | 1
CLT-CT201-C294+175-BC |  |  |  |  | 1
CLT-CT201-C294+200-BC |  |  |  |  | 1
CLT-CT201-C294+250-BC |  |  |  |  | 1
CLT-CT201-C504+100 | 1
CLT-CT201-C504+225 |  | 1 | 1 | 3 | 1
CLT-CT201-C504+250 |  |  | 1 | 1 | 1
CLT-CT201-C504+275 |  |  | 1
CLT-CT201-C604+100-BC |  |  |  |  | 1
CLT-CT201-C604+150-BC |  |  |  |  | 1
CLT-CT201-C604+175-BC |  |  |  |  | 1
CLT-CT201-C604+200-BC |  |  |  |  | 1
CLT-CT201-C604+300-BC |  |  |  |  | 1
CLT-CT201-C701+125 | 1 |  | 1 |  | 1
CLT-CT201-C701+150 |  |  | 2
CLT-CT201-C701+150-BC |  |  |  |  | 2
CLT-CT201-C701+175 |  | 1 | 2 | 1
CLT-CT201-C701+175-BC |  |  |  |  | 1
CLT-CT201-C701+200 |  | 1 | 2
CLT-CT201-C701+225 |  | 2 | 2 | 2 | 1
CLT-CT201-C701+250 |  | 1 | 1 | 3 | 2
CLT-CT201-C701+275 |  |  | 1 | 2 | 1
CLT-CT201-C701+300 |  | 1
Grand Total | 12 | 26 | 39 | 25 | 36
Spreadsheet: ee9c9dd1-0e8c-41b0-95c3-506e48c50b19
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-08-01 10:11:50.760000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.583 | 101.458 | 101.333 | 100.958
3.75 | 101.424 | 101.299 | 101.174 | 100.799 |  | Note: | Refer To Price [NAME]
3.625 | 101.025 | 100.9 | 100.775 | 100.4 |  |  | For all Price Adjs
3.5 | 100.401 | 100.276 | 100.151 | 99.526
3.375 | 99.547 | 99.422 | 99.297 | 98.672
3.25 | 98.618 | 98.493 | 98.368 | 97.743
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.053 | 101.928 | 101.803 | 101.428
3.25 | 101.626 | 101.501 | 101.376 | 101.001
3.125 | 101.326 | 101.201 | 101.076 | 100.701
3 | 100.976 | 100.851 | 100.726 | 100.351
2.875 | 100.365 | 100.24 | 100.115 | 99.49
2.75 | 99.706 | 99.581 | 99.456 | 98.831
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-15 10:11:50.760000
30 DAY | 2012-08-30 10:11:50.760000
45 DAY | 2012-09-14 10:11:50.760000
60 DAY | 2012-09-29 10:11:50.760000
90 DAY | 2012-10-29 10:11:50.760000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 753593d1635541346-sum-values-non-contiguous-cells-if-date-for-the-corresponding-value-is-or-start-date-dy-calculation-xf
Sheet: Sheet1

 | Quarters | Percentage | O Qty | Date | DV | UV | Date | Qty | Date | Qty | Date | Qty
 | 1st Quarter: |  | 1000 | 1999-07-22 00:00:00 | 40 | 20 | 1999-07-12 00:00:00 | 100 | 1999-07-11 00:00:00 | 50 | 1999-07-10 00:00:00 | 25
 | 2nd Quarter:
 | 3rd Quarter:
 | 4th Quarter:
 | C4 needs to show the result: IF(E4>H4&orJ4&orL4,(F4/(D4 [+quantities in I4 & K4 where dates in H4 & J4 are less than E4][-quantity in M when date in L4 is less than E4] *G4))
 | It becomes more complex in the second quarter as the formula will need to also calculate any quantities where the dates on row 4 are greater then the date in E4,
 | along with calculation for row 5 same as row 4
 | I have tried numerous formulas, and have come to the realisation that I need represent dates in the formula,
 | I have found a lot of information to do this referencing a range, but can't find anything using non contiguous cells.
 |  |  |  | 1999-07-22 00:00:00 |  |  | 1999-07-22 00:00:00
 |  |  |  | 1999-07-24 00:00:00 | 100 |  | 1999-07-24 00:00:00 | 100
 |  |  |  | 1999-07-11 00:00:00 | 50 |  | 1999-07-11 00:00:00 | 50
 |  |  |  | 1999-07-10 00:00:00 | 25 |  | 1999-07-10 00:00:00 | 25
 | Any assistance would be greatly appreciated.
 | Cheers,
 | [NAME].
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 1-7 Day

 | CR1 | Priority | Headcount
1 | Architect RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Architect RV | 14 | 0.25
12 | [NAME] | 19 | 0.25
13 | [NAME] | 20 | 0.25
9 | Architect RV | 13 | 0.25
15 | Architect SC | 12 | 0.25
17 | Architect RV | 11 | 0.25
50 | Baxter SIV Assy
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME]
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Beckman 3ml | 22 | 0.25
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | 6ul/PP3 | 3 | 0.25
74 | Side Cassette | 2 | 0.25
77 | Base Cassette  B ES
78 | Side Cassette B ES
79 | [NAME] | 1 | 0.25
87 | [NAME] | 4
53 | Architect RV | 5 | 0.5
61 | [NAME] | 11 | 0.5
66 | [NAME] | 12 | 0.5
83 | Ceph OM#1 | 6 | 2
84 | Ceph MB#1
86 | [NAME] | 7 | 0.25
62 | NP227
63
64
67 | [NAME]
69
88 | Side Pump | 10 | 0.25
89 | PCR Tube | 13 | 0.25
106 | Key 3 white assembly | 8 | 2
107
108 | [NAME] | 9 | 0.5
109
Total
Spreadsheet: 153303d1335857767-sum-data-based-on-selection-on-dropdown-menu-excel-forum-monthly-dropdown-data
Sheet: Summary

 |  |  |  |  |  |  |  |  | Fiscal period is Jul-Jun
 |  |  | MTD |  |  |  |  |  | YTD | (Jul-Mar)
 | Dropdown -->> |  | 2012-03-01 00:00:00 |  |  |  |  |  | 2012-03-01 00:00:00
 |  |  | Actual | Budget | Forecast |  |  |  |  |  | Actual | Budget | Forecast
 | Revenue |  |  |  |  |  |  |  | Revenue
 | Cost 1 |  |  |  |  |  |  |  | Cost 1
 | Cost 2 |  |  |  |  |  |  |  | Cost 2
 | Cost 3 |  |  |  |  |  |  |  | Cost 3
Spreadsheet: 768790d1645120430-keeping-a-formula-constant-after-adding-columns-to-the-right-excel-test-1-2-
Sheet: Sheet1

Check |  |  | ID | SUM | ID | SUM
 | cgc | 25 | AAPL | 129.53 | AAPL | 146.32
 | cdtaf | - | ABBV | 114.38 | ABBV | 115.5
 | cci | 182 | ABUS | 7 | ABUS | 7
 | cag | 34 | ACB | 9.7 | ACB | 10.37
 | c | 77 | AMZN | 3737.88 | ALEC | 34.83
 | ap | 4 | [NAME] | 10.17 | AMZN | 4016.71
 | bip | 55 | ARE | 184.33 | [NAME] | 10.17
 | bgs | 31 | BA | 235.47 | ARE | 184.33
 | are | 182 | BGS | 30.25 | AVGO | 454.5
 | [NAME] | 10.17 | BIP | 53.75 | BA | 230.5
 | amzn | 4200 | BIPC | 76 | BFT | -
 | abus | 5 | BMY | 72.82 | BIP | 54.75
 | abbv | 115 | BP | 26 | BMY | 73.09
 | aapl | 135 | C | 75.93 | BP | 26.13
 | xyz | 14 | CAG | 38 | C | 75.83
 | abc | 25 | CCI | 181.67 | CAG | 38
 | mno | 60 | CDTAF | - | CCI | 180.58
 | pqr | 120 | CGC | 23.46 | CDTAF | -
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A29

TABLE A29   IMPACT OF PRICE SPIKES AND CAPS IN THE NEW ENGLAND ENERGY MARKET ON HYPOTHETICAL 100%  LOAD FACTOR CUSTOMERS
IMPACT OF PRICE SPIKES BETWEEN [NAME] AND JULY OF 1999 AND 2000 ON HYPOTHETICAL 100% LOAD FACTOR CUSTOMERS
 | 100% Load Factor Customer |  | 100% Load Factor Customer
 | 2000-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-07-01 00:00:00 | 1999-07-01 00:00:00
Total [NAME] | 27938.85 | 35407.71 | 27634.2 | 30611.21
Average Bill | 38.80395833333335 | 49.17737500000006 | 37.14274193548387 | 41.14409946236562
% Increase FY 00/99 over FY99/98
IMPACT OF $250 PRICE CAP ON HYPOTHETICAL 100% LOAD FACTOR CUSTOMERS FOR FY 00/99
 |  | 100% Load Factor Customer
 |  | NO CAP | CAP
 | Total [NAME] | 298582.74 | 272432.37
 | Average Bill | 33.99165983606561 | 31.01461407103825
 | % Decrease due to Price [NAME]
 | FY 00/99: 8/16/1999-8/15/2000
Spreadsheet: 35981d1233716476-need-help-listing-leftover-data-after-vlookup-sample1
Sheet: DATA A

Cus # | Desc1 | Type | CASH | VLOOKUP:
3JBJB223 | ALTERNATIVE LN TR 2006-OA14 | BUY | 1361.09 | 1361.09
54S54DS6 | AMERICAN HOME MTG ASSETS TR | BUY | 111.39 | 111.39
2SD5S45S | AMERICAN HOME MTG INVT TR | BUY | 1013.1 | 1013.1
5S48DE5S | BANC AMER ALTERNATIVE LN TR | BUY | 1390.44 | 1390.44
4SD494DS | BANC AMER MTG SECS INC | BUY | 667.57 | 667.57
S4SD46S4 | BANC AMER MTG SECS INC | BUY | 3366.65 | 3366.65
4S4S6S46 | BANC AMER MTG SECS INC | BUY | 192.3 | 192.3
DS49S46S | BANC AMER MTG SECS INC | BUY | 160.96 | 160.96
Spreadsheet: 823448d1679966871-excel-calendar-perpetual-events-monthly-calendar-sample
Sheet: FEBRUARY

FEBRUARY 2023
SUNDAY |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | 29 | 30 | 31 | 1 | 2 | 3 | 4
 |  |  |  |  | [NAME] Aursland [NAME] born 2/2/1825 - 10/10/1915 @90
 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  | [NAME] born 2/16/1901   ([NAME])
 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  | Presidents' Day
 | 26 | 27 | 28 | 1 | 2 | 3 | 4
Notes: |  |  |  |  |  |  | © www.calendarlabs.com
Spreadsheet: 184370d1349240350-how-to-connect-the-data-in-two-sheets-in-one-book-show-2-
Sheet: Sheet1

CSN | Counrty | Partner Name | Partner Type | Tier
1 | US | A | IVAR | [NAME]
2 | Y | B | IVAR | Silver
3 | Y | C | IVAR | Silver
4 | Z | D | VAD | VAD
Every company has one csn number.
Spreadsheet: 1cd95bf1-8f88-4bb3-8455-55de38120391
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
School of Business
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Lead Instructor | Lead Instructor ID | Percentage | 2nd Instructor | 2nd Instructor ID | Percentage | Contract Code | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C