tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89d88509-532b-40ce-928f-4a358ca37327
Sheet: Coupon Bonds

Exchange | Market | Issuer | Lead manager | Trading currency | Program or Stand alone | Listing date | Issuer Code | Lead Manager Code | Lead Manager [NAME]
XSTO | STO Corporate Bonds | Sparbanken 1826 | Swedbank AB | SEK | Program | 2013-11-29 00:00:00
Maximum 100 rows per listing
Short name | Full name | Loan number | ISIN code | Trading Lot | Instrument currency | Floating or Fixed rate | Reference rate for Floating | Interest rate or Spread (%) | Coupons per year | First ordinary coupon | Last ordinary coupon | Day Count Method | Day Adjustment Method | Amount issued | Issue date | Interest from date | Reimbursement date | Last trading date | Trading code
SP1826 107 | Sparbanken 1826 | 107 | SE0005562550 | 1000000 | SEK | Floating Rate | [NAME] | 0.75 | 4 | 2014-02-28 00:00:00 | 2016-11-28 00:00:00 | ACT360 | Forward MM | 300000000 | 2013-11-28 00:00:00 |  | 2016-11-28 00:00:00 | 2016-11-21 00:00:00 | SP1826_107
Spreadsheet: 96219d1295627382-if-vlookup-book5
Sheet: Sheet1

 |  |  |  |  |  | a | b | c
1 | a |  |  |  |  | 1 | a | h
2 | d |  |  |  |  | 2 | #N/A N/A | d
3 | b |  |  |  |  | 3 | b | h
4 | s |  |  |  |  | 4 | #N/A N/A | s
5 | s |  |  |  |  | 5 | s | f
6 | g |  |  |  |  | 6 | g | d
Spreadsheet: 845056d1696604848-format-table-exemple-data
Sheet: Feuil0

2022-01-01 00:00:00 | 00:00:00 | 51 | 51 | 29 | 30 | 28 | 39
2022-01-01 00:00:00 | 01:00:00 | 60 | 58 | 57 | 55 | 56 | 48
2022-01-01 00:00:00 | 02:00:00 | 50 | 50 | 49 | 49 | 50 | 61
2022-01-01 00:00:00 | 03:00:00 | 59 | 56 | 56 | 54 | 57 | 48
2022-01-01 00:00:00 | 04:00:00 | 28 | 29 | 27 | 37 | 50 | 61
2022-01-01 00:00:00 | 05:00:00 | 80 | 79 | 76 | 66 | 55 | 47
2022-01-01 00:00:00 | 06:00:00 | 28 | 28 | 27 | 27 | 27 | 39
2022-01-01 00:00:00 | 07:00:00 | 78 | 65 | 77 | 74 | 78 | 67
2022-01-01 00:00:00 | 08:00:00 | 51 | 41 | 27 | 29 | 28 | 39
2022-01-01 00:00:00 | 09:00:00 | 58 | 56 | 55 | 54 | 56 | 47
2022-01-01 00:00:00 | 10:00:00 | 46 | 51 | 49 | 50 | 50 | 61
2022-01-01 00:00:00 | 11:00:00 | 65 | 57 | 57 | 55 | 57 | 50
2022-01-01 00:00:00 | 12:00:00 | 29 | 30 | 29 | 29 | 47 | 62
2022-01-01 00:00:00 | 13:00:00 | 81 | 79 | 77 | 77 | 62 | 48
2022-01-01 00:00:00 | 14:00:00 | 28 | 29 | 27 | 27 | 27 | 39
2022-01-01 00:00:00 | 15:00:00 | 58 | 57 | 55 | 69 | 78 | 69
2022-01-01 00:00:00 | 16:00:00 | 52 | 49 | 48 | 37 | 27 | 41
2022-01-01 00:00:00 | 17:00:00 | 59 | 58 | 56 | 55 | 58 | 47
2022-01-01 00:00:00 | 18:00:00 | 29 | 33 | 48 | 51 | 50 | 62
2022-01-01 00:00:00 | 19:00:00 | 81 | 78 | 79 | 70 | 58 | 48
2022-01-01 00:00:00 | 20:00:00 | 29 | 28 | 26 | 28 | 28 | 38
2022-01-01 00:00:00 | 21:00:00 | 59 | 55 | 55 | 55 | 77 | 70
2022-01-01 00:00:00 | 22:00:00 | 49 | 50 | 47 | 47 | 34 | 40
2022-01-01 00:00:00 | 23:00:00 | 58 | 57 | 55 | 56 | 56 | 48
Spreadsheet: 487679d1478191034-multi-purpose-calander-task-manager-master-worklist
Sheet: Weekly

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
2016-04-25 00:00:00
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
 | WMHE | WMHF | WMHL | WMHR | WRAL
Column1 | Column2 | Column3 | Column4 | Column5 | Column6
2016-04-25 00:00:00
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
 | WRAL
Spreadsheet: kevin_ruscitti__20323__Rogers_newgen2000
Sheet: Sheet4

 | Sum of MW |  | Region
 | Year | Fuel | ECAR | ERCOT | FRCC | MAAC | MAIN | MAPP | NEPOOL | NYPP | SERC | SPP | Grand Total
 | 1999 | Coal | 182 |  |  |  |  |  |  |  |  |  | 182
 |  | FO2 | 39 |  |  |  |  |  |  |  |  |  | 39
 |  | NG | 1612.625 | 1567 | 249 |  | 1969 | 210 | 435 |  | 2232 | 570 | 8844.625
 |  | Oil |  |  |  |  | 235 |  |  |  |  |  | 235
 |  | PC |  |  |  | 360 |  |  |  |  |  |  | 360
 |  | WAT | 122 |  |  |  |  |  |  |  |  |  | 122
 |  | WND |  | 75 |  |  | 11 | 438.5 |  |  |  |  | 524.5
 |  | WTE | 94 |  |  |  |  |  |  |  |  |  | 94
 | 1999 Total |  | 2049.625 | 1642 | 249 | 360 | 2215 | 648.5 | 435 |  | 2232 | 570 | 10401.125
 | 2000 | NG | 3434 | 3694 | 305 | 289 | 2186 | 100 | 1934 | 250 | 4499 | 2239 | 18930
 |  | Oil |  |  |  | 135 |  |  |  |  |  |  | 135
 |  | WTE | 35 |  |  |  | 15 |  |  |  |  |  | 50
 | 2000 Total |  | 3469 | 3694 | 305 | 424 | 2201 | 100 | 1934 | 250 | 4499 | 2239 | 19115
 | Grand Total |  | 5518.625 | 5336 | 554 | 784 | 4416 | 748.5 | 2369 | 250 | 6731 | 2809 | 29516.125
Spreadsheet: 31689d1227627803-counting-the-number-of-times-a-date-appears-in-a-list-date-frequency-formula
Sheet: Sheet1

 | dos |  |  | From | 2008-04-08 00:00:00
1 | 2008-04-08 00:00:00 |  |  | To | 2008-11-21 00:00:00 |  | 227 | Total number of days between the two dates
2 | 2008-04-10 00:00:00
3 | 2008-04-16 00:00:00 |  |  | ops | occurences
4 | 2008-04-21 00:00:00 |  |  | 0 | 157
5 | 2008-04-24 00:00:00 |  |  | 1 | 56 | 71
6 | 2008-05-01 00:00:00 |  |  | 2 | 15
7 | 2008-05-05 00:00:00 |  |  | 3 | 0
8 | 2008-05-12 00:00:00 |  |  |  | 228 | total
9 | 2008-05-13 00:00:00
10 | 2008-05-14 00:00:00
11 | 2008-05-14 00:00:00
12 | 2008-05-15 00:00:00
13 | 2008-05-16 00:00:00
14 | 2008-05-21 00:00:00
15 | 2008-05-21 00:00:00
16 | 2008-05-27 00:00:00
17 | 2008-05-28 00:00:00
18 | 2008-05-28 00:00:00
19 | 2008-05-29 00:00:00
20 | 2008-05-29 00:00:00
21 | 2008-05-30 00:00:00
22 | 2008-06-02 00:00:00
23 | 2008-06-04 00:00:00
24 | 2008-06-04 00:00:00
25 | 2008-06-05 00:00:00
26 | 2008-06-06 00:00:00
27 | 2008-06-09 00:00:00
28 | 2008-06-11 00:00:00
29 | 2008-06-12 00:00:00
30 | 2008-06-13 00:00:00
31 | 2008-06-16 00:00:00
32 | 2008-06-23 00:00:00
33 | 2008-06-23 00:00:00
34 | 2008-06-24 00:00:00
35 | 2008-06-25 00:00:00
36 | 2008-06-26 00:00:00
37 | 2008-06-30 00:00:00
38 | 2008-06-30 00:00:00
39 | 2008-07-03 00:00:00
40 | 2008-07-07 00:00:00
41 | 2008-07-08 00:00:00
42 | 2008-07-08 00:00:00
43 | 2008-07-09 00:00:00
44 | 2008-07-09 00:00:00
45 | 2008-07-10 00:00:00
46 | 2008-07-17 00:00:00
47 | 2008-07-24 00:00:00
48 | 2008-07-24 00:00:00
49 | 2008-09-09 00:00:00
50 | 2008-08-06 00:00:00
51 | 2008-09-08 00:00:00
52 | 2008-07-29 00:00:00
53 | 2008-08-06 00:00:00
54 | 2008-08-07 00:00:00
55 | 2008-08-13 00:00:00
56 | 2008-08-15 00:00:00
57 | 2008-08-21 00:00:00
58 | 2008-08-21 00:00:00
59 | 2008-08-27 00:00:00
60 | 2008-09-03 00:00:00
61 | 2008-09-04 00:00:00
62 | 2008-09-11 00:00:00
63 | 2008-09-15 00:00:00
64 | 2008-09-15 00:00:00
65 | 2008-09-16 00:00:00
66 | 2008-09-22 00:00:00
67 | 2008-09-29 00:00:00
68 | 2008-09-30 00:00:00
69 | 2008-10-02 00:00:00
70 | 2008-10-06 00:00:00
71 | 2008-10-06 00:00:00
72 | 2008-10-08 00:00:00
73 | 2008-10-09 00:00:00
74 | 2008-10-10 00:00:00
75 | 2008-10-13 00:00:00
76 | 2008-10-22 00:00:00
77 | 2008-10-23 00:00:00
78 | 2008-10-30 00:00:00
79 | 2008-11-03 00:00:00
80 | 2008-11-06 00:00:00
81 | 2008-11-13 00:00:00
82 | 2008-11-13 00:00:00
83 | 2008-11-14 00:00:00
84 | 2008-11-17 00:00:00
85 | 2008-11-18 00:00:00
86 | 2008-11-21 00:00:00
Spreadsheet: 740333d1626281272-countif-not-working-with-true-criterion-rush-detailed-cs-schedule-sample
Sheet: Attendance

 |  |  |  |  |  |  | Sheets
 | Name | A | UA | T | Notes |  | Sunday
 |  |  |  |  |  |  | Monday
 |  |  |  |  |  |  | Tuesday
 |  |  |  |  |  |  | Wednesday
 |  |  |  |  |  |  | Thursday
 |  |  |  |  |  |  | Friday
 |  |  |  |  |  |  | Saturday
Spreadsheet: 746040d1630447806-combine-average-with-right-excelforum-average_and_right
Sheet: Sheet1

 | Event5 | Event4 | Event3 | Event2 | Event1
How would you rate this event overall?
Very satisfied | 9, 64.3% | 52, 98.1% | 18, 56.3% | 7, 53.8% | 28, 73.7%
Satisfied | 4, 28.6% | 1, 1.9% | 11, 34.4% | 5, 38.5% | 7, 18.4%
Neutral | 1, 7.1% |  | 2, 6.3% |  | 2, 5.3%
Unsatisfied
Very unsatisfied
*Responses may not total 100% because some people choose not to answer certain questions
Summary | Totals | Percentage as individuals | Percentage by event
How would you rate this event overall?
Very satisfied | 111
Satisfied | 28
Neutral | 5
Unsatisfied | 0
Very unsatisfied | 0
Spreadsheet: 166407d1341580435-counting-days-until-first-value-is-achieved-sample
Sheet: Sheet1

Days Elapsed | Day Before Reaching 80% or higher | First Day of Mail Flow | Class | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21 | Day 22 | Day 23 | Day 24 | Day 25 | Day 26 | Day 27 | Day 28 | Day 29 | Day 30 | Day 31 | Day 32 | Day 33 | Day 34 | Day 35 | Day 36 | Day 37 | Day 38 | Day 39 | Day 40 | Day 41 | Day 42 | Day 43 | Day 44 | Day 45
 |  | Day 15 | Standard | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 0.0865 | 0.1495 | 0.227 | 0.3119 | 0.4136 | - | 0.6851 | 0.8931 | 0.9328 | 0.9497 | 0.9642 | 0.9674 | - | 0.975 | 0.9758 | 0.9762 | 0.9769 | 0.9773 | 0.9774 | - | 0.9776 | 0.9777 | 0.9777 | 0.9779 | 0.978 | 0.9781 | - | 0.9782 | 0.9783
 |  | Day 8 | Standard | - | - | - | - | - | - | - | 0.4071 | 0.4257 | 0.4702 | 0.7029 | 0.8761 | - | 0.9357 | 0.9699 | 0.9784 | 0.9826 | - | - | - | - | 0.9838 | - | - | 0.9844
 |  | Day 6 | Standard | - | - | - | - | - | 0.0108 | 0.0421 | 0.2659 | 0.4238 | 0.6048 | - | 0.8458 | 0.8809 | 0.9143 | 0.9376 | 0.9449 | 0.9463 | - | 0.9478 | 0.9482 | 0.9537 | 0.9541 | 0.9544 | 0.9545 | - | 0.9547 | 0.9547
 |  | Day 5 | Standard | - | - | - | - | 0.0004 | - | 0.0027 | 0.2708 | 0.3208 | 0.4606 | 0.641 | 0.6957 | - | 0.7434 | 0.7474 | 0.7653 | 0.7675 | 0.7687 | 0.7695 | - | 0.7744 | 0.7759 | 0.7763 | 0.7766 | 0.7767
 |  | Day 5 | Standard | - | - | - | - | 0.0284 | - | 0.172 | 0.2991 | 0.4295 | 0.5624 | 0.692 | 0.8788 | - | 0.9624 | 0.9783 | 0.9797 | 0.9814 | 0.9823 | 0.9826 | - | 0.9836 | 0.9841 | 0.9844 | 0.9846 | 0.9849
 |  | Day 5 | Standard | - | - | - | - | 0.0005 | - | 0.0169 | 0.065 | 0.2453 | 0.4733 | 0.6856 | 0.8125 | - | 0.9297 | 0.9616 | 0.9692 | 0.9711 | 0.9718 | 0.972
 |  | Day 5 | Standard | - | - | - | - | 0.0731 | - | 0.4057 | 0.4853 | 0.6193 | 0.9167 | 0.9415
 |  |  | Standard
 |  |  | Standard
 |  |  | Standard
 |  |  | Standard
Spreadsheet: 183756d1349012422-add-onto-a-formula-to-link-a-value-based-on-a-dropdown-menu-selection-allocation-balance
Sheet: Sheet1

Money Market Distribution:
Deposit | Description | Date
4000 | Initial transfer from savings | 2012-10-01 00:00:00 |  | TOTAL BALANCE |  | Allocation Balances
 |  |  |  |  |  | Future Down Payment | New Car Fund | Vacation Fund | Baby Ready Fund | Misc Expenses Fund | Stocks | Doggy Insurance
Withdraw Amount | Withdraw Location | Date
Spreadsheet: joe_parks__14954__BridgeDPR0430
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1934.388971099997 | 1934.388971099997 | 7225.388971099997
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1934.388971099997 | 1934.388971099997 | 7225.388971099997
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 151725d1335089070-auto-populate-data-into-calendar-scheduler
Sheet: Calendar

2012-03-01 00:00:00
Sunday |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  | Details | Name |  |  | Details | Name |  |  | Details | Name |  |  | Details | Name | 1 |  | Details | Name | 2 |  |  | 3
 | 4 | Details | Name | 5 |  | Details | Name | 6 |  | Details | Name | 7 | 7 | Details | Name | 8 |  | Details | Name | 9 |  |  | 10
 | 11 | Details | Name | 12 |  | Details | Name | 13 |  | Details | Name | 14 |  | Details | Name | 15 |  | Details | Name | 16 |  |  | 17
 | 18 | Details | Name | 19 |  | Details | Name | 20 |  | Details | Name | 21 |  | Details | Name | 22 |  | Details | Name | 23 |  |  | 24
 | 25 | Details | Name | 26 |  | Details | Name | 27 |  | Details | Name | 28 |  | Details | Name | 29 |  | Details | Name | 30 |  |  | 31
Spreadsheet: 872303d1718689777-help-with-doing-a-transpose-basicall-columns-combined-into-a-column-rows-become-column-sampleprofiledata-solution-aligw
Sheet: Sheet1

What I have:
Profile | Object | Permission1 | Permission2 | Permission3 | Permission4 | Permission5
P1 | O1 | F | F | T | T | T
P1 | O2 | T | T | F | F | F
P2 | O1 | F | T | F | T | F
P3 | O3 | T | T | T | F | F
What I want: |  |  |  | Solution:
 | P1 | P2 | P3 |  | P1 | P2 | P3
O1 |  |  |  | O1
Permission 1 | F | F |  | Permission1 | F | F
Permission 2 | F | T |  | Permission2 | F | T
Permission 3 | T | F |  | Permission3 | T | F
Permission 4 | T | T |  | Permission4 | T | T
Permission 5 | T | F |  | Permission5 | T | F
O2 |  |  |  | O2
Permission 1 | T |  |  | Permission1 | T
Permission 2 | T |  |  | Permission2 | T
Permission 3 | F |  |  | Permission3 | F
Permission 4 | F |  |  | Permission4 | F
Permission 5 | F |  |  | Permission5 | F
O3 |  |  |  | O3
Permission 1 |  |  | T | Permission1 |  |  | T
Permission 2 |  |  | T | Permission2 |  |  | T
Permission 3 |  |  | T | Permission3 |  |  | T
Permission 4 |  |  | F | Permission4 |  |  | F
Permission 5 |  |  | F | Permission5 |  |  | F
Spreadsheet: chris_germany__2021__~Upstream contracts latest
Sheet: Discounts

Discounts
Pipe | Locations | Effective Dates | Contract | Rate | Comments
Tennessee | Tenn 500 to SNAT TOCA | 2001-08-07 00:00:00 | 36568 | 0.14 | received from Cory
Tennessee | [NAME] to Trunkline Kinder | 2001-08-08 00:00:00 | 37177 | .10 AO | received from Cory
Tennessee | Tenn 800 to SNAT TOCA | 8/17-31/2001 | 36568 | 0.08 | received from Cory
Tennessee | Tenn 800 to [NAME] | 8/17-31/2001 | 36568 | 0.08 | received from Cory
Tennessee | Tenn 800 to SNAT TOCA | 9/1 - 9/4 | 36568 | 0.1 | received from Cory
Trunkline | TRKL STX to Bridgeline | 9/1 - 9/30 | 16791 | 0.1 | up to 1000
Trunkline | TRKL STX to Bridgeline | 9/1 - 9/30 | 16791 | 0.1 | up to 1000
Transco | HI 199 to St 45 | 9/1 - life of lease | 3.8539 | 0.3 | Spinaker discount
Transco | HI 199 to St 65 | 9/1 - life of lease | 3.8539 | 0.065 | Spinaker discount
Tennessee | Tenn 800 to SNAT TOCA | 9/5  - 9/30 | 36568 | 0.12
Trunkline | TRKL ELA to Bridgeline | 9/13-30/2001 | 16791 | 0.1 | up to a combined volume of 20,000
Trunkline | TRKL WLA to Bridgeline | 9/13-30/2001 | 16791 | 0.1 | between both ELA & WLA
Tennessee | Tenn 800 to SNAT TOCA | 2001-10-25 00:00:00 | 36568 | 0.12
Spreadsheet: 108615d1305647515-verticle-to-horizontal-verticle-to-horizontal
Sheet: Sheet1

Original List
Location 1 | 2011-01-15 00:00:00
Location 2 | 2011-01-18 00:00:00
Location 1 | 2011-02-15 00:00:00
Location 3 | 2011-02-25 00:00:00
Location 2 | 2011-01-19 00:00:00
Location 1 | 2011-01-21 00:00:00
Desired List
Location 1 | 2011-01-15 00:00:00 | 2011-02-15 00:00:00 | 2011-01-21 00:00:00
Location 2 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00
Location 3 | 2011-02-25 00:00:00
Spreadsheet: 781794d1653553347-need-formula-to-count-table-range-depending-on-conditions-in-selected-table-columns-hit-miss-aligw
Sheet: Overview

 | Summary
Fighter1 | Style | Won:Lost | Number Of Hits | Number Of Misses | Basic Defense
 | Aggressive
 | Defensive
 | Accurate
 | Balanced
 | Summary
Fighter2 | Style | Won:Lost | Number Of Hits | Number Of Misses | Basic Defense
 | Aggressive
 | Defensive
 | Accurate
 | Balanced
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: monthly_by area

(    )  represents additional gas into system
 | March
 | Vol Imbalance
West of Thoreau
Calpine
Citizens-Griffith
SWGasTrans
North Star Steele
Citizens Communications
Mojave
SoCal
PG&E
El Paso Window Rock
Total West of Thoreau
San Juan
Williams Field Services
TransColorado
Burlington
Red Cedar
Amoco Florida
Northwest
El Paso Blanco
Total San Juan
East of Thoreau
NNG
Conoco
Amoco Abo
OneOK
[NAME]
Duke [NAME]
[NAME]
Duke Artesia
[NAME]
Mewborne
PGETX
PNM
EOG
Oasis
[NAME]
MiVida_Rich
Dominion
[NAME]
WTGinc
[NAME]
Crosstex
Amarillo
Stratland
Plains
Continental
[NAME]
Agave
NGPL
PEPL
CIG
Lonestar
ANR |  | 2002-03-17 00:00:00
Total imbalance net
Spreadsheet: 803289d1667377004-problem-in-nested-if-test
Sheet: Sheet1

No. | Insurer | Premium Criteria | Family | Code | Maternity | Code | Per family | Per life | Room Rent | Code | Per family | Per life | Buffer | Code | Amount | Co-pay | Code | Per family | Per life | Location Loading | Per family | Per life | Group [NAME] | Per family | Per life | Employees | Spouse | Children | Parents | 0-18 | 19-35 | 36-45 | 46-55 | 56-60 | 61-65 | 66-70 | 71-80 | SI | Total Employees | Total Dep. | Total Lives | Lives band | Per family | Loading
1 | ICICI |  | Self | 1 | 25K&35K | 70 | NA | NA | 1%&2% | 31 | NA | NA | Not Covered | 37 | NA | Nil co-pay | NA | NA | NA |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 1 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 100000 | 7 | 0 | 7 | 7-25 | 2381
2 | ICICI |  | Self | 1 | 25K&35K | 70 | NA | NA | 1%&2% | 31 | NA | NA | Not Covered | 37 | NA | Nil co-pay | NA | NA | NA |  |  |  |  |  |  | 24 | 0 | 0 | 0 | 3 | 6 | 4 | 5 | 3 | 3 | 0 | 0 | 100000 | 24 | 0 | 24 | 7-25 | 2381
3 | ICICI |  | Self | 1 | 25K&35K | 70 | NA | NA | 1%&2% | 31 | NA | NA | Not Covered | 37 | NA | Nil co-pay | NA | NA | NA |  |  |  |  |  |  | 25 | 0 | 0 | 0 | 3 | 6 | 4 | 5 | 3 | 4 | 0 | 0 | 100000 | 25 | 0 | 25 | 7-25 | 2381
4 | ICICI |  | Self | 1 | 25K&35K | 70 | NA | NA | 1%&2% | 31 | NA | NA | Not Covered | 37 | NA | Nil co-pay | NA | NA | NA |  |  |  |  |  |  | 26 | 0 | 0 | 0 | 3 | 3 | 6 | 4 | 6 | 4 | 0 | 0 | 100000 | 26 | 0 | 26 | 26-50 | 2381
5 | ICICI |  | Self | 1 | 25K&35K | 70 | NA | NA | 1%&2% | 31 | NA | NA | Not Covered | 37 | NA | Nil co-pay | NA | NA | NA |  |  |  |  |  |  | 49 | 0 | 0 | 0 | 5 | 9 | 12 | 9 | 8 | 6 | 0 | 0 | 100000 | 49 | 0 | 49 | 26-50 | 2381
Spreadsheet: 677268d1589277258-lookup-and-sum-sum
Sheet: Sheet1

Item | Sales | Stk
CLT-CT101-C1+275 |  | 1
CLT-CT101-C1+300 | 1 |  |  |  |  | Sales | Stock
CLT-CT101-C1BLCK+100 | 2 |  |  |  | CLT-CT101 | 18 | 19
CLT-CT101-C1BLCK+125 | 1 | 1 |  |  | CLT-CT102 | 2 | 14
CLT-CT101-C1BLCK+150 | 1 |  |  |  | CLT-CT201
CLT-CT101-C1BLCK+200 | 1 |  |  |  | CLT-CT202
CLT-CT101-C1BLCK+225 | 1 | 1 |  |  | CLT-CT205
CLT-CT101-C1BLCK+250 |  | 1 |  |  | CLT-CT204
CLT-CT101-C1BLCK+300 | 1 | 1 |  |  | CLT-CT207
CLT-CT101-C2BRG+100 |  | 1 |  |  | CLT-CT206
CLT-CT101-C2BRG+125 |  | 1 |  |  | CLT-CT101-C1BLCK
CLT-CT101-C2BRG+150 | 2 |  |  |  | CLT-CT101-C2BRG
CLT-CT101-C2BRG+175 | 1 | 1 |  |  | CLT-CT102-C1BLCK
CLT-CT101-C2BRG+200 | 1 | 1 |  |  | CLT-CT102-C3BRN
CLT-CT101-C2BRG+225 |  | 1
CLT-CT101-C2BRG+250 |  | 1
CLT-CT101-C2BRG+275 |  | 1
CLT-CT101-C2BRG+300 |  | 1
CLT-CT101-C3BRN+100 | 1 | 1
CLT-CT101-C3BRN+125 |  | 1
CLT-CT101-C3BRN+150 | 1
CLT-CT101-C3BRN+175 | 1 | 1
CLT-CT101-C3BRN+200 | 1
CLT-CT101-C3BRN+225 |  | 1
CLT-CT101-C3BRN+250 | 1
CLT-CT101-C3BRN+275 | 1 | 1
CLT-CT101-C3BRN+300 |  | 1
CLT-CT102-C1+250 |  | 1
CLT-CT102-C1+275 |  | 1
CLT-CT102-C1+300 |  | 1
CLT-CT102-C1BLCK+100 | 1
CLT-CT102-C1BLCK+125 |  | 1
CLT-CT102-C1BLCK+150 |  | 1
CLT-CT102-C1BLCK+175 | 1
CLT-CT102-C1BLCK+200 |  | 1
CLT-CT102-C3BRN+100 |  | 1
CLT-CT102-C3BRN+125 |  | 1
CLT-CT102-C3BRN+150 |  | 1
CLT-CT102-C3BRN+175 |  | 1
CLT-CT102-C3BRN+200 |  | 1
CLT-CT102-C3BRN+225 |  | 1
CLT-CT102-C3BRN+275 |  | 1
CLT-CT102-C3BRN+300 |  | 1
CLT-CT201-C101+175 |  | 1
CLT-CT201-C109+225 |  | 1
CLT-CT201-C109+275 |  | 1
CLT-CT201-C109+300 | 1
CLT-CT201-C204+250 |  | 1
CLT-CT201-C204+275 |  | 1
CLT-CT201-C204+300 |  | 1
CLT-CT201-C504+150 |  | 1
CLT-CT201-C504+225 |  | 1
CLT-CT201-C504+250 |  | 1
CLT-CT201-C504+275 |  | 1
CLT-CT201-C504+300 |  | 1
CLT-CT202-C1+100 |  | 1
CLT-CT202-C1+200 | 1
CLT-CT203-C1+100 |  | 1
CLT-CT203-C1+200 |  | 1
CLT-CT203-C1+250 |  | 1
CLT-CT203-C1+300 |  | 1
CLT-CT203-C4+100 |  | 1
CLT-CT204-202BLK+100 | 1 | 1
CLT-CT204-202BLK+150 | 1 | 1
CLT-CT204-202BLK+200 | 1 | 1
CLT-CT204-202BLK+250 |  | 1
CLT-CT204-410BRN+100 | 2 | 1
CLT-CT204-410BRN+150 |  | 1
CLT-CT204-410BRN+200 | 1 | 1
CLT-CT204-410BRN+250 |  | 1
CLT-CT205-206BLU+100 | 1
CLT-CT205-206BLU+150 | 1
CLT-CT205-206BLU+200 | 1
CLT-CT205-206BLU+250 |  | 1
CLT-CT206+100 | 1
CLT-CT206+150 | 1
CLT-CT206+200 |  | 1
CLT-CT206+250 |  | 1
CLT-CT207+100 |  | 1
CLT-CT207+150 |  | 1
CLT-CT207+200 | 1
CLT-CT207+250 |  | 1
Grand Total | 34 | 64
Spreadsheet: 274552d1383147979-finding-value-using-formulas-functions-or-macros-in-intersection-of-2-data-series-in-graph-example_book_reattachted
Sheet: EXAMPLE1

 | DATA SERIE1
 | DATA FOR BLACK  LINE
 | Y AXE | X AXE
 | 76.19999999999999 | 100
 | 63.5 | 100
 | 50.8 | 100
 | 38.09999999999999 | 100
 | 25.4 | 89.27423454202909
 | 19.05 | 87.32863057523437
 | 12.5 | 82.72863057523438
 | 9.5 | 80.22863057523438
 | 4.75 | 72.02863057523437
 | 2 | 61.42863057523437
 | 0.42 | 42.42863057523437
 | 0.075 | 27.22863057523437
 |  |  |  |  | data for red vertical line
 |  | NUMBER THAT I WANT  TO FIND AUTOMATICALLY USING FUNCTIONS  FORMULAS OR [NAME] |  |  | 1.8 |  | 0 | 60 | DATA SERIE 2
 |  |  |  |  | THIS NUMBER  IS THE X VALUE FOR WHICH THE Y VALUE FOR THE SERIE1 IS 60 |  |  | NOTE:VALUES IN X AXE IS IN INVERSE ORDER THE SCALE OF X AXE IS IN LOG BASE 10