tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273589d1382771166-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-breakdown-of-array-formula
Sheet: Breakdown of formula

[NAME] of formula using 4 helper column of [NAME] used in "Result" Sheet |  |  |  | =IFERROR(INDEX(Data!$A$4:$A$395,SMALL(IF(Data!$A$4:$A$395<>"",ROW($A$4:$B$395)-ROW($A$4)+1),ROWS($A$1:A1))),"")
Helper column 1 | Helper column 2 | Helper column 3 | Helper column 4 Using CSE | Helper column 5
 |  |  |  |  |  |  |  | Hi,
 |  |  |  |  |  |  |  | Let me elaborate where I am wrong in my syntax or understanding-
 |  |  |  |  |  |  |  | [NAME]................),"")....................is already cleared to me.
 |  |  |  |  |  |  |  | Secondly,
 |  |  |  |  |  |  |  | Syntax =INDEX( array, row_number, [column_number] )....................here it is confusion to me
 |  |  |  |  |  |  |  | Here, array = [NAME]
 |  |  |  |  |  |  |  | row_number = SMALL(IF(Data!$A$4:$A$395<>"",ROW($A$4:$B$395)-ROW($A$4)+1),ROWS($A$1:A1))
 |  |  |  |  |  |  |  | Simplification of "row_number"
 |  |  |  |  |  |  |  | Syntax = small ( array,k)
 |  |  |  |  |  |  |  | here this array = ?????? should this be= IF(Data!$A$4:$A$395<>"",ROW($A$4:$B$395)-ROW($A$4)+1) as it brings =1,5,9,13,18,22,26,30   i.e
 |  |  |  |  |  |  |  | {1;FALSE;FALSE;FALSE;5;FALSE;FALSE;FALSE;9;FALSE;FALSE;FALSE;13;FALSE;FALSE;FALSE;FALSE;18;&.............. by using Ctrl+shift+enter
 |  |  |  |  |  |  |  | k = ROWS($A$1:A1) = 1 and on subsequent row it brings 1,2,3,4,5,6,7 & so on.
 |  |  |  |  |  |  |  | Now when I use this function small (array,k) using helper column, it is getting error.
 |  |  |  |  |  |  |  | I have enclosed an workbook at the last sheet "Breakdown of formula",I have used  5 helper column where 5th is final result and 4 helper column are the breakdown of your formula.Kindly have a look into it, where I am wrong ?
Spreadsheet: 871035d1717493836-horizontal-cells-that-must-be-colored-book2
Sheet: Sheet1

10 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
9 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
7 |  | 2 | 3 | 4 | 5 | 6 | 7
6 |  | 2 | 3 | 4 | 5 | 6
5 |  | 2 | 3 | 4 | 5
4 |  | 2 | 3 | 4
3 |  | 2 | 3
2 |  | 2
1
Spreadsheet: 28839d1223387725-assigning-a-0-value-to-text-mobile-bassmaster-weights
Sheet: Sheet2

Rank | Members name | Oct. | Nov. | Dec. | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. | Total | Total after drops
1 | Madden | 6.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.16 | 6.16
2 | Willmann | 3.82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.82 | 3.82
3 | Richardson | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3
4 | Holladay | 2.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.92 | 2.92
5 | Moore | 2.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.08 | 2.08
6 | Woodward | 1.64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.64 | 1.64
7 | Steele | 1.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.58 | 1.58
8 | Monk | 1.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.4 | 1.4
9 | Waldrop, T | 0.88 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.88 | 0.88
10 | Walters | 0.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.8 | 0.8
11 | Lenoir | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | Sachs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | Brewton | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | Newell | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | Waldrop, B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1877bdf4-439b-48cc-b2f8-907c2a09cac4
Sheet: Sheet2

mre11 | 6105 | 6106 | 6499 | 6500
rad52 | 6619 | 6620 | 6503 | 6504
rad51 | 6557 | 6558 | 6555 | 6556
rad59 | 6597 | 6598 | 6599 | 6600
srs2 | 5557c |  | 6539 | 6540
sgs1 | 6107 | 6108 | 6501 | 6502
rad51 rad59 | 7081 | 7082 | 7083 | 7084
rad52 rad51 | 7185 | 7186 | 7187 | 7188
rad52 rad59 | 7189 | 7190 | 7191 | 7192
rad52 rad51 rad59 | 7087 | 7088 | 7085 | 7086
rfa1-t33 | 7042 |  | 7043 | 7072
rrm3/rtt104 | 5556c |  | 6527 | 6528
rtt107/esc4 | 6167 | 6168 | 6525 | 6526
sir4 | 7177 | 7178 | 7179 | 7180
mms1 | 6189 | 6190 | 6535 | 6536
rad27 | 6543 | 6544 | 6545 | 6546
cdc9-1 | 7039 |  | 7040 | 7041
[NAME]/rtt110 | 6151 | 6152 | 6509 | 6510
sml1 | 6589 | 6590 | 7073 | 7074
mec1 sml1 | 6583 | 6584 | 6581 | 6582
rad53 sml1 | 6585 | 6586 | 6587 | 6588
dun1 | 3739d |  | 6515 | 6516
chk1 | 3745e |  | 6623 | 6624
tel1 | 6569 | 6570 | 6571 | 6572
rad9 | 3719e |  | 6625 | 6626
mrc1 | 6175 | 6176 | 6529 | 6530
[NAME] | 6149 | 6150 | 6517 | 6518
sic1 | 6551 | 6552 | 6553 | 6554
rtt105 | 6191 | 6192 | 6537 | 6538
pmr1 | 7017 | 7018 | 7019 | 7020
mlh1 | 6603 |  | 6601 | 6602
msh2 | 6605 | 6606 | 6607 | 6608
rad6 | 6143 | 6144 | 6507 | 6508
rad5 | 5519f |  | 6523 | 6524
rlf2/cac1 | 4753g |  | 7183 | 7184
rtt109 | 6792 | 6793 | 6513 | 6514
rtt101 | 6117 | 6118 | 6505 | 6506
asf1 | 6621 | 6622 | 6519 | 6520
spt21 | 6549 | 6550 | 6547 | 6548
rtt106 | 6159 | 6160 | 6521 | 6522
rtt102 | 6123 | 6124 | 6511 | 6512
gal11 | 6577 | 6588 | 6579 | 6580
rtt103 | 6181 | 6182 | 6531 | 6532
spt8 | 6575 | 6576 | 6573 | 6574
spt2 | 6559 | 6560 | 6561 | 6562
spt4 | 6567 | 6568 | 6565 | 6566
tsa1 | 6611 | 6612 | 6609 | 6610
est2 | 4347d |  | 6533 | 6534
Spreadsheet: 753068d1635229699-extracting-text-variable-formatted-string-into-two-columns-attempt-to-use-mid-and-right-sample
Sheet: Sheet1

 |  |  |  |  |  | Desired Return
 |  |  | Visitor | Home |  | Visitor | Home
 |  |  |  |  |  |  | Oklahoma St
 |  |  |  |  |  | N Carolina
 |  |  |  |  |  | St Bonavent | St Louis
 |  |  |  |  |  | Notre Dame | GA Tech
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Miss State | S Carolina
#68 Mt St Mary at #1 Gonzaga |  |  |  |  |  | Mt St Mary
Goal: Return the Visitor and Home Team Name Only in colmn's D and E.  Notice in highlighted cells only portions of the names are returned because I am premising the return based on the space " ".
Hoping there is a formula in each instance (Colmn D and E) that can return based on flexible formating of string (notice varying length and location of  spaces).
Spreadsheet: 813260d1673627608-percentage-calculation-of-cells-based-on-second-column-data-overheads-percentage-if-example
Sheet: Sheet1

BUDGET LINE | PARTNER | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
PERSONNEL | BUSINESS C | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
CONSUMABLES | BUSINESS A | 200 | 300 | 0 | 100 | 200 | 200 | 100 | 0 | 300 | 0 | 200 | 300
EXTERNAL ASSISTANCE | BUSINESS B | 1000 | 2000 | 1000 | 4000 | 5000 | 4000 | 0 | 0 | 0 | 1000 | 3000 | 0
PERSONNEL | BUSINESS B | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
EXTERNAL ASSISTANCE | BUSINESS A | 0 | 0 | 0 | 0 | 2000 | 2000 | 3000 | 1000 | 2000 | 1000 | 4000 | 0
TRAVEL | BUSINESS C | 50 | 80 | 100 | 150 | 100 | 80 | 50 | 50 | 100 | 60 | 40 | 100
PERSONNEL | BUSINESS A | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000
EXTERNAL ASSISTANCE | BUSINESS C | 4000 | 5000 | 4000 | 0 | 0 | 0 | 1000 | 3000 | 0 | 2000 | 0 | 1000
CONSUMABLES | BUSINESS C | 100 | 200 | 200 | 100 | 0 | 300 | 0 | 200 | 300 | 200 | 100 | 100
OVERHEADS @ 7% | BUSINESS A | 1344
OVERHEADS @ 7% | BUSINESS B | 1120
OVERHEADS @ 7% | BUSINESS C | 1753.5
wanting to find formula that will calculate 7% of month (column) cost IF partner in column B matches
Spreadsheet: frank_ermis__11200__West NatGas Prices 1114
Sheet: Gas Average FinIdx

FinIdx Curves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS PRICES- Fin Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month
 |  |  |  |  |  |  |  |  | Date Start |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  |  |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | GD-PG&E/CITIGAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | GDP-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | GDP-MALIN-CTYGA
 |  | NGI-SOCAL |  | NGI-SOCAL | GDP-CAL BORDER
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | GDP-ELPO/SANJUA
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | GDP-ELPO/PERM2
 |  | WAHA |  | IF-WAHA-TX | GDP-WAHA
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | GDP-NGPL/OK
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | GDP-KERN/OPAL
 |  | STANFIELD |  | NW-STANFIELD | GD-NW STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | GDP-NTHWST/CANB
 |  | AECO |  | CGPR-AECO/USIM | [NAME]
 |  | CIG |  | IF-CIG/RKYMTN | GDP-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | GDP-HEHUB | NG
Spreadsheet: 139230d1328135818-time-sheet-sorted-time-sheet
Sheet: Lists

 | Hours | Lunch |  | Jobs |  | Sheet Names
 | 06:00:00 | 00:30:00 |  | [NAME]. |  | 1.1 - 1.15
 | 06:05:00 | 01:00:00 |  | Hubburt
 | 06:10:00 | 0 |  | Jasmin
 | 06:15:00 |  |  | Lathrop
 | 06:20:00 |  |  | [NAME]
 | 06:25:00 |  |  | [NAME]
 | 06:30:00 |  |  | Betty
 | 06:35:00 |  |  | Arlington
 | 06:40:00 |  |  | Center
 | 06:45:00 |  |  | Miranda
 | 06:50:00 |  |  | Grove
 | 06:55:00 |  |  | Fernhill
 | 07:00:00 |  |  | Rebecca
 | 07:05:00 |  |  | Pierce
 | 07:10:00 |  |  | [NAME]
 | 07:15:00 |  |  | Frandon
 | 07:20:00 |  |  | Black
 | 07:25:00
 | 07:30:00
 | 07:35:00
 | 07:40:00
 | 07:45:00
 | 07:50:00
 | 07:55:00
 | 08:00:00
 | 08:05:00
 | 08:10:00
 | 08:15:00
 | 08:20:00
 | 08:25:00
 | 08:30:00
 | 08:35:00
 | 08:40:00
 | 08:45:00
 | 08:50:00
 | 08:55:00
 | 09:00:00
 | 09:05:00
 | 09:10:00
 | 09:15:00
 | 09:20:00
 | 09:25:00
 | 09:30:00
 | 09:35:00
 | 09:40:00
 | 09:45:00
 | 09:50:00
 | 09:55:00
 | 10:00:00
 | 10:05:00
 | 10:10:00
 | 10:15:00
 | 10:20:00
 | 10:25:00
 | 10:30:00
 | 10:35:00
 | 10:40:00
 | 10:45:00
 | 10:50:00
 | 10:55:00
 | 11:00:00
 | 11:05:00
 | 11:10:00
 | 11:15:00
 | 11:20:00
 | 11:25:00
 | 11:30:00
 | 11:35:00
 | 11:40:00
 | 11:45:00
 | 11:50:00
 | 11:55:00
 | 12:00:00
 | 12:05:00
 | 12:10:00
 | 12:15:00
 | 12:20:00
 | 12:25:00
 | 12:30:00
 | 12:35:00
 | 12:40:00
 | 12:45:00
 | 12:50:00
 | 12:55:00
 | 13:00:00
 | 13:05:00
 | 13:10:00
 | 13:15:00
 | 13:20:00
 | 13:25:00
 | 13:30:00
 | 13:35:00
 | 13:40:00
 | 13:45:00
 | 13:50:00
 | 13:55:00
 | 14:00:00
 | 14:05:00
 | 14:10:00
 | 14:15:00
 | 14:20:00
 | 14:25:00
 | 14:30:00
 | 14:35:00
 | 14:40:00
 | 14:45:00
 | 14:50:00
 | 14:55:00
 | 15:00:00
 | 15:05:00
 | 15:10:00
 | 15:15:00
 | 15:20:00
 | 15:25:00
 | 15:30:00
 | 15:35:00
 | 15:40:00
 | 15:45:00
 | 15:50:00
 | 15:55:00
 | 16:00:00
 | 16:05:00
 | 16:10:00
 | 16:15:00
 | 16:20:00
 | 16:25:00
 | 16:30:00
 | 16:35:00
 | 16:40:00
 | 16:45:00
 | 16:50:00
 | 16:55:00
 | 17:00:00
 | 17:05:00
 | 17:10:00
 | 17:15:00
 | 17:20:00
 | 17:25:00
 | 17:30:00
 | 17:35:00
 | 17:40:00
 | 17:45:00
 | 17:50:00
 | 17:55:00
 | 18:00:00
 | 18:05:00
 | 18:10:00
 | 18:15:00
 | 18:20:00
 | 18:25:00
 | 18:30:00
 | 18:35:00
 | 18:40:00
 | 18:45:00
 | 18:50:00
 | 18:55:00
 | 19:00:00
 | 19:05:00
 | 19:10:00
 | 19:15:00
 | 19:20:00
 | 19:25:00
 | 19:30:00
 | 19:35:00
 | 19:40:00
 | 19:45:00
 | 19:50:00
 | 19:55:00
 | 20:00:00
Spreadsheet: 2ff637c7-e67b-4afc-9134-0660527e5864
Sheet: Sheet1

Extent and trends in illicit drug use among young people aged 16 to 24 - Drug Misuse Declared 2011/12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Sheet | Title | Period covered | National Statistics | Previous publication | Last updated
EY.01 | Proportion of 16 to 24 year olds reporting use of drugs ever in their lifetime, 1996 to 2011/12 Crime Survey for England and Wales | 2011/12 | Yes | Table 2.5 | 2012-07-26 00:00:00
EY.02 | Proportion of 16 to 24 year olds reporting use of drugs in the last year, 1996 to 2011/12 Crime Survey for England and Wales | 2011/12 | Yes | Table 2.6 | 2012-07-26 00:00:00
EY.03 | Proportion of 16 to 24 year olds reporting use of drugs in the last month, 1996 to 2011/12 Crime Survey for England and Wales | 2011/12 | Yes | Table 2.6 | 2012-07-26 00:00:00
EY.04 | Estimates of numbers of illicit drug users, 16 to 24 year olds, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes | Table 2.8 | 2012-07-26 00:00:00
Spreadsheet: 711606d1609793149-formula-or-macro-to-count-or-sum-consecutive-non-blank-cells-after-a-blank-cell-or-0-forum-sheet
Sheet: Sheet1

 | 2021011 |  |  |  |  |  |  | 2021012
Row Labels | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | Answer:
1296882 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12
1517759 | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 | 3
1522224 |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 4
1523312 |  |  | 1 | 1 |  |  |  | 1 |  |  | 1 | 1 | 2
1524882 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  | 0
1526265 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 5
1529401 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1
1530271 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 3
1533234 | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 | 3
1534406 | 1 |  | 1 |  | 1 | 1 |  | 1 |  |  |  |  | 0
1536205 | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 | 1 | 1 | 5
1536750 | 1 | 1 | 1 | 1 |  |  |  | 1 |  | 1 | 1 | 1 | 3
1537303 | 1 |  |  |  | 1 |  |  | 1 |  | 1 | 1 | 1 | 3
1552709 | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 | 3
1554231 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12
Spreadsheet: 233113d1367613069-extracting-a-continuous-list-based-on-a-numerical-value-book1
Sheet: DATA

DATE | STATE | TEMP | FLUX | TMP |  | DATE | STATE | TEMP | FLUX | TMP
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 48239644 | 136009294
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 35578140 | 93260882
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 83817784 | 229270176
 | Purchases:
6 |  | 3rd Party / Inter Enron | -56862672 | -167902250 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -26033998 | -65006177
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 257412 | 567184
 | Total Purchases: |  | -82639258 | -232341243
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -3643 | -5648
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -1033427 | -3026086 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -1037070 | -3031734
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -141456 | -433350.456
23 | Fuel: |  | -257412 | -567184
 | Transport Expense:
24 |  | Commodity | 0 | -49377
25 |  | Demand | 0 | -2429479
 | Total Transport Expense: |  | 0 | -2478856
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -2767229
31 |  | Prior Month Book Balance | 0 | -2723828
 |  | Total MTM Income | 0 | -5491057
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 13707791
34 |  | Originations | 0 | 20185
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1500534
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 290256
 |  | TOTAL INTRA-MTH
Spreadsheet: 841857d1693998859-bisectional-method-using-recursive-lambda-recursive-bisection-method-lambda
Sheet: Sheet 1

Min | [NAME] | Variable | Calculation | Goal | Diff |  |  | Min | [NAME] | X | Calculation | Goal | Diff | Termination
11 | 500 | 200 |  | 555 |  |  |  | 11 | 500 | 200 |  | 555
Spreadsheet: 525746d1498862610-split-cells-data-into-specific-columns-book1-farhangul-
Sheet: Sheet1

 |  |  |  | Internal spaces
something [NAME] 100mm
something else [NAME] 100mm
something else [NAME] 100mm
something else [NAME] 100mm
Spreadsheet: 777489d1650421826-help-with-multiple-dates-and-values-to-count-occurrences-ohio-river-flood-crest-date-info-qts18-
Sheet: Levels by date

 |  | Date | Time | Level (ft) | lines | years | total days | 11 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52
USGS | 3303280 | 2007-10-01 00:00:00 | 01:00:00 | 11.23
USGS | 3303280 | 2007-10-01 00:00:00 | 02:00:00 | 11.15
USGS | 3303280 | 2007-10-01 00:00:00 | 03:00:00 | 11.08
USGS | 3303280 | 2007-10-01 00:00:00 | 04:00:00 | 11.08
USGS | 3303280 | 2007-10-01 00:00:00 | 05:00:00 | 11.08
USGS | 3303280 | 2007-10-01 00:00:00 | 06:00:00 | 11.01
USGS | 3303280 | 2007-10-01 00:00:00 | 07:00:00 | 10.98
USGS | 3303280 | 2007-10-01 00:00:00 | 08:00:00 | 10.98
USGS | 3303280 | 2007-10-01 00:00:00 | 09:00:00 | 10.95
USGS | 3303280 | 2007-10-01 00:00:00 | 10:00:00 | 10.94
USGS | 3303280 | 2007-10-01 00:00:00 | 11:00:00 | 11.01
USGS | 3303280 | 2007-10-01 00:00:00 | 12:00:00 | 11.04
USGS | 3303280 | 2007-10-01 00:00:00 | 13:00:00 | 11.15
USGS | 3303280 | 2007-10-01 00:00:00 | 14:00:00 | 11.19
USGS | 3303280 | 2007-10-01 00:00:00 | 15:00:00 | 11.09
USGS | 3303280 | 2007-10-01 00:00:00 | 16:00:00 | 11.01
USGS | 3303280 | 2007-10-01 00:00:00 | 17:00:00 | 11.03
USGS | 3303280 | 2007-10-01 00:00:00 | 18:00:00 | 10.96
USGS | 3303280 | 2007-10-01 00:00:00 | 19:00:00 | 43
USGS | 3303280 | 2007-10-01 00:00:00 | 20:00:00 | 43
USGS | 3303280 | 2007-10-01 00:00:00 | 21:00:00 | 41
USGS | 3303280 | 2007-10-01 00:00:00 | 22:00:00 | 43
USGS | 3303280 | 2007-10-01 00:00:00 | 23:00:00 | 43
USGS | 3303280 | 2007-10-02 00:00:00 | 00:00:00 | 41
USGS | 3303280 | 2007-10-02 00:00:00 | 01:00:00 | 10.97
USGS | 3303280 | 2007-10-02 00:00:00 | 02:00:00 | 10.94
USGS | 3303280 | 2007-10-02 00:00:00 | 03:00:00 | 10.92
USGS | 3303280 | 2007-10-02 00:00:00 | 04:00:00 | 10.89
USGS | 3303280 | 2007-10-02 00:00:00 | 05:00:00 | 10.87
USGS | 3303280 | 2007-10-02 00:00:00 | 06:00:00 | 10.89
USGS | 3303280 | 2007-10-02 00:00:00 | 07:00:00 | 10.89
USGS | 3303280 | 2007-10-02 00:00:00 | 08:00:00 | 10.92
USGS | 3303280 | 2007-10-02 00:00:00 | 09:00:00 | 10.92
USGS | 3303280 | 2007-10-02 00:00:00 | 10:00:00 | 10.85
USGS | 3303280 | 2007-10-02 00:00:00 | 11:00:00 | 10.91
USGS | 3303280 | 2007-10-02 00:00:00 | 12:00:00 | 10.85
USGS | 3303280 | 2007-10-02 00:00:00 | 13:00:00 | 10.86
USGS | 3303280 | 2007-10-02 00:00:00 | 14:00:00 | 10.87
USGS | 3303280 | 2007-10-02 00:00:00 | 15:00:00 | 10.92
USGS | 3303280 | 2007-10-02 00:00:00 | 16:00:00 | 10.87
USGS | 3303280 | 2007-10-02 00:00:00 | 17:00:00 | 10.87
USGS | 3303280 | 2007-10-02 00:00:00 | 18:00:00 | 10.87
USGS | 3303280 | 2007-10-02 00:00:00 | 19:00:00 | 10.81
USGS | 3303280 | 2007-10-02 00:00:00 | 20:00:00 | 10.82
USGS | 3303280 | 2007-10-02 00:00:00 | 21:00:00 | 10.81
USGS | 3303280 | 2007-10-02 00:00:00 | 22:00:00 | 10.82
USGS | 3303280 | 2007-10-02 00:00:00 | 23:00:00 | 10.84
Spreadsheet: 109166d1306109355-advanced-filter-with-an-input-box-uniquevalue
Sheet: Sheet3

Name | Pcode | Amount | Date | Clinic | Address | Doctor
xxxxxxx | 001 | 40 | 2011-03-03 00:00:00 | Belus | xyz | [NAME]
xxxxxxx | 001 | 60 | 2011-03-06 00:00:00 | gugi | wond | what
 |  |  |  |  |  |  |  |  | To retrieve the data of each patient I have
 |  |  |  |  |  |  |  |  | created many command buttons.
 |  |  |  |  |  |  |  |  | I would like to create only one Button
 |  |  |  |  |  |  |  |  | and with the help of an input box, to enter the Pcode of
 |  |  |  |  |  |  |  |  | each patient( i.e. 001, etc  manually
Spreadsheet: 864313d1711536689-booking-document-need-help-booking-ramadhan-ballroom
Sheet: Sales Summary 

Total booking code | Booking code | Total in IDR
 | 250323
 | 260323
 | 270323
 | 280323
 | 290323
 | 300323
 | 310323
 | 10423
 | 20423
 | 30423
 | 40423
 | 50423
 | 60423
 | 70423
 | 80423
 | 90423
 | 100423
 | 110423
 | 120423
 | 130423
 | 140423
 | 150423
 | 160423
 | 170423
 | 180423
 | 190423
 | 200423
 | 210423
 | 220423
Spreadsheet: 158677d1338341692-excel-2007-automatically-input-to-sheet2-from-sheet1-test
Sheet: Sheet2

 |  | CONTACTS
 |  | Company | Contact | Telephone | [NAME]
 |  | A
 |  | Company A1 | Contact A1 | Telephone A1 | [NAME]
 |  | Company A2 | Contact A2 | Telephone A2 | [NAME]
 |  | Company A3 | Contact A3 | Telephone A3 | [NAME]
 |  | B
 |  | Company B1 | Contact B1 | Telephone B1 | [NAME]
 |  | Company B2 | Contact B2 | Telephone B2 | [NAME] B2
 |  | Company B3 | Contact B3 | Telephone B3 | [NAME]
 |  | C
 |  | Company C1 | Contact C1 | Telephone C1 | [NAME]
 |  | Company C2 | Contact C2 | Telephone C2 | [NAME]
 |  | Company C3 | Contact C3 | Telephone C3 | [NAME]
 |  | D
 |  | …
 |  | …
 |  | …
 |  | …
 |  | …