tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 745359d1629885514-countifs-with-cells-that-contain-multiple-data-book2
Sheet: Data

Date From | Date | Date To | In | Out | Location
2021-08-20 16:46:36 | 2021-08-23 07:21:32 | 2021-08-23 07:21:32 |  |  | Farnborough (Main) Station (Union Street)
2021-08-19 16:46:41 | 2021-08-23 06:43:02 | 2021-08-23 06:43:02 |  |  | Farnborough (Main) Station (Union Street)
2021-08-20 17:37:12 | 2021-08-23 06:39:01 | 2021-08-23 06:39:01 |  |  | Farnborough (Main) Station (Union Street)
2021-08-22 14:42:47 | 2021-08-23 06:36:05 | 2021-08-23 06:36:05 |  |  | Farnborough (Main) Station (Union Street)
2021-08-20 19:24:33 | 2021-08-23 06:34:16 | 2021-08-23 06:34:16 |  |  | Farnborough (Main) Station (Union Street)
2021-08-19 17:53:20 | 2021-08-23 06:33:16 | 2021-08-23 06:33:16 |  |  | Farnborough (Main) Station (Union Street)
2021-08-18 17:05:22 | 2021-08-23 06:29:35 | 2021-08-23 06:29:35 |  |  | Farnborough (Main) Station (Union Street)
2021-08-20 16:33:57 | 2021-08-23 05:45:06 | 2021-08-23 05:45:06 |  |  | Farnborough (Main) Station (Union Street)
2021-08-19 18:53:39 | 2021-08-23 05:45:03 | 2021-08-23 05:45:03 |  |  | Farnborough (Main) Station (Union Street)
2021-08-19 16:48:59 | 2021-08-23 05:44:24 | 2021-08-23 05:44:24 |  |  | Farnborough (Main) Station (Union Street)
2021-08-22 22:17:08 | 2021-08-23 01:05:05 | 2021-08-23 01:05:05 |  |  | Brockenhurst Station (Lymington Road)
2021-08-22 23:52:30 | 2021-08-23 00:31:38 | 2021-08-23 00:31:38 |  |  | Farnborough (Main) Station (Union Street)
2021-08-22 23:20:02 | 2021-08-23 00:11:55 | 2021-08-23 00:11:55 |  |  | Andover Station
2021-08-20 15:01:52 | 2021-08-23 00:10:08 | 2021-08-23 00:10:08 |  |  | Winchester Station (Andover Road)
2021-08-22 23:26:26 | 2021-08-22 23:58:33 | 2021-08-22 23:58:33 |  |  | Eastleigh Station CP1
2021-08-22 16:27:24 | 2021-08-22 23:58:32 | 2021-08-22 23:58:32 |  |  | Woking Station Oriental Road
2021-08-22 23:18:56 | 2021-08-22 23:52:30 | 2021-08-22 23:52:30 |  |  | Farnborough (Main) Station
2021-08-22 23:14:43 | 2021-08-22 23:52:19 | 2021-08-22 23:52:19 |  |  | Salisbury Station
2021-08-22 09:04:21 | 2021-08-22 23:38:49 | 2021-08-22 23:38:49 |  |  | Poole Station CP1
2021-08-22 22:23:52 | 2021-08-22 23:33:17 | 2021-08-22 23:33:17 |  |  | Farnborough (Main) Station
2021-08-22 22:39:14 | 2021-08-22 23:30:28 | 2021-08-22 23:30:28 |  |  | [NAME]
2021-08-22 10:58:08 | 2021-08-22 23:30:20 | 2021-08-22 23:30:20 |  |  | Southampton Airport Parkway Station (Surface)
2021-08-22 15:19:36 | 2021-08-22 23:29:26 | 2021-08-22 23:29:26 |  |  | Woking Main Station  (Premium)
2021-08-22 18:10:25 | 2021-08-22 23:28:50 | 2021-08-22 23:28:50 |  |  | Hampton Court Station
Spreadsheet: 877667d1724466392-redundancy-calc-with-a-difference-a-formula-question-redundancy-calc-with-a-difference-jt
Sheet: #13

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1 | 1.5 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks
 | Empl 001 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  | Correct |  | I edited the formula in Column I, changing the number in min to 23 and it seems to work (that may have "broken" the 2 x non working examples)
 | Empl 002 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  | Correct |  | I edited the formula in Column I, changing the number to 23 and it worls
 | Empl 003 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  | Incorrect |  | I would expect 1 x 1 Week and 3 x 1.5 for a total of 5.5
 | Empl 004 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  |  |  |  |  |  | Incorrect |  | I would expect 2 x 1 Week and 14 x 1.5 for a total of 23
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: 125744d1319205846-showing-dependent-on-another-column-list-and-checking-stock-testfotis1991newone
Sheet: Stock

2011-10-21 00:00:00
ProductS | Quantity
Product1 | 10 |  |  |  |  |  |  | Category A |  | Category A | Category B | Category C | Category A Nonzero | Category B Nonzero | Category C Nonzero
Product2 | 20 |  |  |  |  |  |  | Category B |  | Product1 | Product6 | Product15 | Product1 | Product6 | Product15
Product3 | 25 |  |  |  |  |  |  | Category C |  | Product2 | Product7 | Product16 | Product2 | Product7 | Product16
Product4 | 1 |  |  |  |  |  |  |  |  | Product3 | Product8 | Product17 | Product3 | Product8 | Product17
Product5 | 0 |  |  |  |  |  |  |  |  | Product4 | Product9 | Product18 | Product4 | Product9
Product6 | 5 |  |  |  |  |  |  |  |  | Product5 | Product10 | Product19 |  | Product10 | Product19
Product7 | 10
Product8 | 22
Product9 | 39
Product10 | 42
Product15 | 65
Product16 | 52
Product17 | 78
Product18 | 0
Product19 | 12
Spreadsheet: 57f866e0-68db-4690-a4c9-ad9562a4c53f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | C2 Complement, Functional, Serum | C2 Complement, Functional, S, NR | CH(50) Automated Liposome Lysis Assay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 25-47 U/mL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 86161 |  |  |  |  | Rochester
[NAME] | [NAME] | SRED | Serum Red |  |  |  | Frozen | 21 days
[NAME] | Result | C2FX | C2 Complement,Functional,w/Reflex,S | C2 Complement,Functional,w/Reflex,S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 33408-6 | [NAME]:ACnc:Pt:Ser/Plas:Qn:
[NAME] | Result | INT53 | Interpretation | Interpretation | Alphanumeric
Spreadsheet: 05cfae6f-3b0a-4778-8378-360ebe579401
Sheet: Sheet1

Template User | [NAME] | Channels Incuded | short/long | high/low | hard/easy | mandatory/optional | Group Enrollment
student | welcome | announcements
 |  | campus news
 |  | notifications
 |  | survey
 |  | poll
 |  | classifieds | long
 |  | student links
 | email | Zimbra
 | NazNet | NazNet
 | Academic | Blackboard
 |  | Live Text
 |  | Library
 | MyNaz | catch-all?
 |  | [NAME]
 |  | fun
 |  | newsletter (alum)
 |  | make a gift (alum)
 |  | career services (alum)
 |  | register class/event (alum)
 | collaboration | blog
 |  | discussion forums
 |  | chat
 | personal | calendar
 |  | bookmarks
 |  | address books
 |  | my notes
 | briefcase | briefcase
applicant | welcome | notifications
 |  | fun
 |  | image
 | email
 | webadvisor
staff | welcome | fun
 |  | notifications
 |  | survey
 |  | polls
 |  | marketing
 |  | briefcase
 |  | bookmarks
 | academic | BB
 |  | library
 |  | live text
 | web advisor
 | email
alumni | welcome | newsletter
 |  | webadvisor
 |  | gift
 |  | career services (interphase)
 |  | email
 |  | fun
 |  | registration link
Faculty | welcome | notification
 |  | briefcase
 |  | calendar
 |  | survey
 |  | bookmark
 |  | marketing
 | academics | blackboard
 |  | library
 |  | live text
 | web advisor
 | email
Spreadsheet: 24923d1215843985-hierarchy-filters-in-pivot-table-example
Sheet: Data

Name | Department | Team | Salary
user1 | Dep A | Team A.1 | 7500
user2 | Dep A | Team A.2 | 8000
user3 | Dep A | Team A.3 | 6500
user4 | Dep A | Team A.1 | 8000
user5 | Dep A | Team A.2 | 9000
[NAME] | Dep A | Team A.3 | 7200
user7 | Dep A | Team A.1 | 8000
user8 | Dep A | Team A.2 | 9500
[NAME] | Dep A | Team A.3 | 7500
user10 | Dep A | Team A.1 | 8000
user11 | Dep B | Team B.1 | 6500
user12 | Dep B | Team B.2 | 8000
user13 | Dep B | Team B.3 | 9000
user14 | Dep B | Team B.1 | 7200
user15 | Dep B | Team B.2 | 8000
user16 | Dep B | Team B.3 | 9500
user17 | Dep B | Team B.1 | 7500
user18 | Dep B | Team B.2 | 8000
user19 | Dep B | Team B.3 | 6500
user20 | Dep B | Team B.1 | 8000
Spreadsheet: 52663d1252510395-pivot-table-hide-columns-with-no-data-company-report-sample
Sheet: Pivot

 | Data
Store No | Sum of Total Pay | Sum of Pay Type 1 | Sum of Pay Type 2 | Sum of Pay Type 3 | Sum of Pay Type 4 | Sum of Pay Type 5 | Sum of Pay Type 6 | Sum of Pay Type 7 | Sum of Pay Type 8
656543 | 21404.99 | 1144.69 | 1179.3 | 948.06 | 6436.1 | 1003.51 |  | 18.63 | 123.22
1564964 | 7623.11 | 462.64 | 443.82 | 430.64 | 2827.71 | 406.04 |  | 8.25 | 53.21
2548617 | 61084.19 | 3417.45 | 3460.98 | 2866.18 | 19325.69 | 2999.91 |  | 135.94 | 912.15
3164565 | 6850.73 | 399.31 | 403.74 | 341.99 | 2162.3 | 328.59 |  | 9.41 | 63.99
7646684 | 8702.92 | 495.09 | 490.37 | 409.11 | 2872.93 | 373.93 |  | 7.92 | 53.86
8989531 | 17429.76 | 934.63 | 950.43 | 783.98 | 5419.99 | 723.95 |  | 25.95 | 164
Grand Total | 123095.7 | 6853.81 | 6928.64 | 5779.96 | 39044.72 | 5835.93 |  | 206.1 | 1370.43
Spreadsheet: 823771d1680127566-lookup-based-on-a-critera-dhl
Sheet: LGWR006873540

Month | Invoice Number | Shipment Number | Shipment Date | Zone | Dest Name | Receivers Country |  |  | ROW | UK
January | LGWR006873540 | 3821806450 | 20230118 | A | ULAANBAATAR | MN |  | January | 12 | 5
January | LGWR006873540 | 7336894331 | 20230127 | 1 | HAMBURG | DE |  | February | 15 | 4
January | LGWR006873540 | 3407039742 | 20230130 | 6 | ORLY | FR |  | March | 16 | 6
January | LGWR006873540 | 7124343461 | 20230131 | 9 | BELFAST | GB |  | April | 18 | 8
January | LGWR006873540 | 6623442140 | 20230131 | 12 | DUBLIN | IE |  | May | 32 | 9
January | LGWR006873540 | 8015086730 | 20230131 | 2 | DUBLIN | IE |  | June | 32 | 10
January | LGWR006873540 | 2803247775 | 20230131 | 55 | DUBLIN | IE |  | July | 12 | 45
January | LGWR006873540 | 7124291311 | 20230131 | A | DUBLIN | IE |  | August | 15 | 21
January | LGWR006873540 | 8015296542 | 20230131 | 5 | DUBLIN | IE |  | September | 16 | 5
January | LGWR006873540 | 7124354215 | 20230131 | 7 | DUBLIN | IE |  | October | 18 | 4
January | LGWR006873540 | 2803110461 | 20230131 | 9 | DUBLIN | IE |  | November | 32 | 6
January | LGWR006873540 | 2803226801 | 20230131 | 2 | DUBLIN | IE |  | December | 32 | 8
January | LGWR006873540 | 7124357052 | 20230131 | 1 | DUBLIN | IE
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 15

THE ALLSTATE CORPORATION
HISTORICAL PROPERTY-LIABILITY
UNDERWRITING RESULTS BY AREA OF BUSINESS
($ in millions)
 |  |  |  | Twelve months ended December 31,
 |  |  |  | 2012 |  |  | 2011 |  |  | 2010 |  |  | 2009 |  |  | 2008
Property-Liability Underwriting Summary
 | Allstate Protection |  | $ | 1253 |  | $ | -857 |  | $ | 525 |  | $ | 1032 |  | $ | 191
 | Discontinued Lines and Coverages |  |  | -53 |  |  | -25 |  |  | -31 |  |  | -32 |  |  | -25
 |  | Underwriting income (loss) | $ | 1200 |  | $ | -882 |  | $ | 494 |  | $ | 1000 |  | $ | 166
Allstate Protection Underwriting Summary
 | Premiums written |  | $ | 27026 |  | $ | 25981 |  | $ | 25906 |  | $ | 25972 |  | $ | 26584
 | Premiums earned |  | $ | 26737 |  | $ | 25942 |  | $ | 25955 |  | $ | 26195 |  | $ | 26967
 | Claims and claims expense |  |  | -18433 |  |  | -20140 |  |  | -18923 |  |  | -18722 |  |  | -20046
 | Amortization of deferred policy acquisition costs |  |  | -3483 |  |  | -3477 |  |  | -3517 |  |  | -3615 |  |  | -3796
 | Operating costs and expenses |  |  | -3534 |  |  | -3139 |  |  | -2957 |  |  | -2721 |  |  | -2912
 | Restructuring and related charges |  |  | -34 |  |  | -43 |  |  | -33 |  |  | -105 |  |  | -22
 |  | Underwriting income (loss) | $ | 1253 |  | $ | -857 |  | $ | 525 |  | $ | 1032 |  | $ | 191
 | Catastrophe losses |  | $ | 2345 |  | $ | 3815 |  | $ | 2207 |  | $ | 2069 |  | $ | 3342
 | Operating ratios
 |  | Loss ratio |  | 68.9 |  |  | 77.6 |  |  | 72.90695434405701 |  |  | 71.5 |  |  | 74.3
 |  | Expense ratio |  | 26.4 |  |  | 25.7 |  |  | 25.06646118281641 |  |  | 24.6 |  |  | 25
 |  | Combined ratio |  | 95.3 |  |  | 103.3 |  |  | 97.97341552687342 |  |  | 96.1 |  |  | 99.3
 | Effect of catastrophe losses
 |  | on combined ratio |  | 8.8 |  |  | 14.70588235294118 |  |  | 8.50317857830861 |  |  | 7.9 |  |  | 12.4
 | Effect of restructuring and related charges
 |  | on combined ratio |  | 0.1 |  |  | 0.1657543751445532 |  |  | 0.1271431323444423 |  |  | 0.4 |  |  | 0.1
 | Effect of business combination expenses and the
 | amortization of purchased intangible assets
 | on combined ratio |  |  | 0.5 |  |  | 0.2 |  |  | 0 |  |  | 0 |  |  | 0
Discontinued Lines and Coverages
Underwriting Summary
 | Premiums written |  | $ | 1 |  | $ | -1 |  | $ | 1 |  | $ | -1 |  | $ | 0
 | Premiums earned |  | $ | 0 |  | $ | 0 |  | $ | 2 |  | $ | -1 |  | $ | 0
 | Claims and claims expense |  |  | -51 |  |  | -21 |  |  | -28 |  |  | -24 |  |  | -18
 | Operating costs and expenses |  |  | -2 |  |  | -4 |  |  | -5 |  |  | -7 |  |  | -7
 |  | Underwriting loss | $ | -53 |  | $ | -25 |  | $ | -31 |  | $ | -32 |  | $ | -25
 | Effect of Discontinued Lines and Coverages
 |  | on the Property-Liability combined ratio |  | 0.2 |  |  | 0.09636882275846119 |  |  | 0.1194374879599307 |  |  | 0.1221607176942165 |  |  | 0.09270589980346348
Spreadsheet: 849946d1700310657-help-with-interpolation-with-forecast-interpolation-help
Sheet: Sheet1

 | altitude | time | fuel | dist |  | elev | 1500
 | 0 | 0 | 0 | 0 |  | cruise alt | 8000
 | 1000 | 1 | 0.4 | 2
 | 2000 | 3 | 0.7 | 4
 | 3000 | 5 | 1.2 | 6
 | 4000 | 6 | 1.5 | 8 |  |  |  | interpolation
 | 5000 | 8 | 1.8 | 11
 | 6000 | 10 | 2.1 | 14
 | 7000 | 13 | 2.5 | 17
 | 8000 | 15 | 3 | 21
 | 9000 | 18 | 3.4 | 25
 | 10000 | 22 | 4 | 29
 | 11000 | 26 | 4.6 | 35
 | 12000 | 31 | 5.4 | 43
Spreadsheet: 697909d1601611603-multiple-match-formula-4-criterion-question-help-multiple-match
Sheet: Template

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Last Pymt |  |  |  |  |  | 2020-09-28 00:00:00 | 1287.67 | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1986000609
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1986001233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1986002210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1986003435
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1987000868
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1987001687
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1987003177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1987003183
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1988000526
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1988000561
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1988002061
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989000708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989001866
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989002041
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989002633
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989003738
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989003837
Spreadsheet: 438f38f4-f3bf-42f7-b261-aadabdadc67c
Sheet: TR_TOUTC

Tariff - Through or Out Service Charges
TR_TOUTC_<customer id>_<settlement date>_<version>.CSV
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer ID | [NAME] Number | [NAME] Name | OASIS Assignment Reference Number | Point of Receipt | Point of Delivery | Transmission Priority | Duration | Start Date | End Date | Reservation Amount | Duration Counter | Through or Out Charge | ISO OATT Schedule 1 Charge | ISO SFT Schedule 1 Charge
Number | String | String | Number | String | String | String | String | Date | Date | MW | Number | $ | $ | $
Spreadsheet: 30c9de01-0be1-4068-91a3-52e912bc9182
Sheet: Sheet1

Missouri Department of Conservation Wildlife Collector's Permit Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Collector's Name | Permit Number | Permit Year
Enter Name and Permit Number above, then enter information about specimens collected below,
and email as attachment to: | [EMAIL]
Common_Name | Genus | Species | Date(mm/dd/yyyy | Number Removed | Number released | County | Location Type (UTM, TRS, Lat/Long) | Location coordinates | Site_Name | Disposition  1=Released 2=Held in Captivity 3=Killed for study purposes
Spreadsheet: 862311d1710061771-adjust-conditional-format-to-highlight-the-wrong-selection-book2
Sheet: entry

No | Main Expense | Sub Expense | Amount | Date
1 | Inventory | T-Shirts | 698 | 2024-03-10 00:00:00
 | Maintenance | Heat Press Machine
 | Maintenance | Printer Maintenance
 | Raw Materials | Ink
 | Raw Materials | Papers Of Pictures
 | Raw Materials | Roland Paper
 | Raw Materials | Vinyl
 | Rent | Poster Kiosk
 | Rent | [NAME]
 | Rent | Store
 | Salaries | Designer
 | Salaries | Owner
 | Salaries | Worker
 | Taxes | Annual Tax
 | Taxes | Sales tax
 | Utilities | Cleaning Tools
 | Utilities | Electricity
 | Utilities | Water
Spreadsheet: louise_kitchen__23880__Hot List4_12_01 Team
Sheet: 04_12_01

E N R O N   N O R T H   A M E R I C A
 |  |  |  |  |  |  |  | Generation/IPP Investment Deals
DEAL |  | QUARTER |  | ORIGINATOR |  | [NAME] |  | ESTIMATED VALUE
ANP |  | 2Q01 |  | [NAME] |  | Acquire ANP interest in Dow Oyster Creek, Texas QF (Inside Fence/Dow Credit Deal). |  | 5000000
BNY |  | 2Q01 |  | [NAME] |  | Acquire 50% interest in Brooklyn Navy Yard project from York Research and 50% interest from Edison Mission Energy |  | 10000000
Dynegy |  | 2Q01 |  | [NAME] |  | Acquire Dynegy interest in Dow Oyster Creek, Texas QF, Commonwealth Atlantic, Michigan Power |  | 5000000
Motown |  | 2Q01 |  | [NAME] |  | Negotiate restructuring plan with Consumers Energy |  | 10000000
[NAME] |  | 2Q01 |  | [NAME]/Carl Tricoli |  | [NAME] plant to [NAME] or 3rd party |  | 10000000
FPL/Tractebel |  | 2Q01 |  | [NAME] |  | Acquire interest in restructuring value of Bellingham and Sareville QF projects. |  | 10000000
Delta Power |  | 2Q01 |  | [NAME] |  | Power output syndication |  | 7000000
Edison Mission Energy |  | 2Q01 |  | [NAME] |  | Acquire EME interests in Eastern QF assets |  | 10000000
2Q01 TOTAL
TECO |  | 3Q01 |  | [NAME] |  | Mezzanine Financing for Fronterra project |  | 10000000
North American Geo Power |  | 3Q01 |  | [NAME] |  | Mezzanine Financing |  | 5000000
Edison Mission Energy |  | 3Q01 |  | [NAME] |  | Mezzanine Financing for Homer City project |  | 5000000
3Q01 TOTAL
TOTAL DEALS
COMPLETED DEALS |  | QUARTER |  | ORIGINATOR |  | [NAME] |  | VALUE
East Coast Power |  | 1Q01 |  | [NAME] |  | El Paso receivable monetization |  | 5534530
TOTAL COMPLETED DEALS
Spreadsheet: 739196d1625576237-vba-locking-cells-based-on-checkbox-radio-button-selection-locking-cells-checkbox-dropdown
Sheet: Projections

Generation
Direct Self-Consumption
Export
Electricity Unit Rate |  |  |  |  |  |  | System Cost |  |  | 5000
Estimated Electricity Annual Use (kWh) |  |  |  |  |  |  | Deposit |  |  | 1000
Export Tariff |  |  |  |  |  |  | Payment Type |  |  | Loan @ 9.7%
Panel Degradation |  |  |  | 0.00925 |  |  | Annual Interest Rate
Fuel Inflation |  |  |  | 0.051 | ONS CPI 2008 - 2020 |  | Payment Terms (years) |  |  | 15
Gas Inflation |  |  |  | 0.033 | ONS CPI 2008 - 2020 |  | Annual Loan Repayment
Year | SAP | Export | Self-Consumption (solar and/or battery) | Battery (overnight charging) | Total Annual Benefit (capped at 90% of the previous Grid usage) | Rep. Costs | Monthly Payment | Total Yearly Payment | Net Annual Benefit | Net Position
1
2
3
4
5
 |  |  |  |  |  | -1500
 |  |  |  |  |  | -1000
Spreadsheet: 143575d1330464649-index-help-skorby-comm
Sheet: Skorby comm (3)

 |  |  |  | Total commited more than Primary
 |  |  |  |  |  | Additional locations |  |  |  |  |  |  | Date
Driver (please input name)
Inputted by stock control :
WHZONE | INUMBR | ILONGD | WHSLOT | WHHAND | WHCOMM | Backup 1 | Total | Backup 2 | Total | Backup3 | Total | backup4 | Total | backup 5 | Total | backup 6 | Total | AVG Pallets
Spreadsheet: 264527d1378908916-consolidating-duplicate-data-and-recording-of-duplicates-help-me-
Sheet: Sheet1

alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 1
alarm 2 |  | This is the data I am getting (10,000 + worth of "alarms"). But in actuallity, I only have 70 alarm points.
alarm 3
alarm 3
alarm 3
alarm 3
alarm 3
alarm 3 |  |  |  | I would REALLY like to formulate the data into something like this. Now before you get started, the alarm names are not "alarm 1,2,3" it’s a complex naming convention…
alarm 3
alarm 3
alarm 3
alarm 3
alarm 3 |  |  |  |  | column A | column  B
alarm 3 |  |  |  |  | Alarm 1 | 13
alarm 3 |  |  |  |  | [NAME] | 1
alarm 3 |  |  |  |  | Alarm 3 | 16
alarm 3
alarm 3