tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30070__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 2/27/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
CLENCORE LTD | QU1278.1 | F | NG | [NAME]
EXCO Resources, Inc. | QU2497.1/3 | F | NG | [NAME]
ONEOK Energy Marketing and Trade | QU1813.1/5/6/7/8/9 | P | NG | [NAME]
Pacific Gas & Electric Company | QU2495.1/5/6/7/8/9 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Aquila Energy Marketing Corporation | QT9747.1 | F | NG | Aquila Risk Management Corporation
Bank of America N.A. | QU2300.1 | F | 63GC | Bank of America, National Association
Banque Paribas (Suisse) S.A. | QU1694.1/2 | F | WTI | BNP Paribas
Coral Energy Resources, LP | QT9823.1 QU0189.1 | F | NG | Coral Energy Holding, LP
Dynegy Energy, Inc. | QU0262.1 | F | NG | Dynegy Marketing and Trade
Nova Chemicals inc. | QU2445.1 | F | BENZ | Nova Chemicals Corp.
PanCanadian Energy Inc. | QU1265.1 | F | NG | PanCanadian Energy Services
Public Service Electric and Gas | QU1725.1 | F | NG | PSEG Energy Resources & Trade LLC
Spreadsheet: 58731d1258999815-auto-fill-info-into-a-cell-inventory-setup
Sheet: Inventory 

inventory control sheet
Dealer | Category | Item Code | Quantity | [NAME] | Price
Home and Garden Sensations | 3" VP Pellet Vent Transition Components | 5SE-3VP-AF | 3 | 40-A120 | 18.4
[NAME] |  | 5SE-3VP-SC | 8 | 40-A120 | 2.7
1300 St. Rt. 55 |  |  | 3 | 40-A120
URBANA OH 43078 |  |  | 80 | 40-A120
UNITED STATES
Terms
Home and Garden sensation is under the terms
of getting free storage  as long as an inventory | [NAME] | 6MB-40035P | 4 | 40-A120
Level of $300 is maintained or a total montly |  |  | 3 | 40-A120
sales of $700 or more a month have been processed |  |  | 10 | 40-A120
 | Fireplace Toolsets | 5MM-VFWC21-01 | 3 | 40-A120
 |  |  | 7 | 40-A120
 |  |  | 56 | 40-A120
Ok what I need is the price to show up in cell F7 when the item code in c7 is selected
every item code is in a drop down menu in column C
all the item codes and pricing are on sheet 3 ,,,,,,,,the item codes are in the A column and the pricing is in column B
Spreadsheet: 182971d1348672523-how-do-i-return-a-blank-cell-value-if-that-cell-does-not-have-color-formatting-0a1_fot_book1-72-
Sheet: Sheet3

 |  |  |  |  |  |  |  | I have a range of cells that are formula driven as follows:
 |  |  |  |  |  |  |  | =IF($G187=0,"",T176)
 |  |  |  |  |  |  |  | I am trying to return a blank cell if the cell has NO color formatting, and return a value if the cell DOES have color formatting. Is there a way or setting a conditional format? I do not want to 'hide' rows or columns.
 |  |  |  |  |  |  |  | =$[NAME]>>> Color Green.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | See here
 |  |  |  |  |  | 10
 |  |  |  |  |  | 15
 |  |  |  |  |  | 0
 |  |  |  |  |  | -5
 |  |  |  |  |  | 10
 |  |  |  |  |  | 0
 |  |  |  |  |  | -10
Spreadsheet: kate_symes__18850__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
Spreadsheet: 882366d1730735089-ranking-points-for-tied-positions-order-of-merit
Sheet: Major

 | RANKING | PLAYER | EVENT 1 | RANK | POINTS | EVENT 2 | RANK | POINTS | EVENT 3 | RANK | POINTS | EVENT 4 | RANK | POINTS | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Points
 | 1 | Justin Derby | 31 |  |  | 29 |  |  | 31 |  |  | 31 |  |  |  |  | 1
 | 2 | [NAME] | 33 |  |  |  |  |  | 41 |  |  | 32 |  |  |  |  | 2
 | 3 | [NAME] | 32 |  |  | 36 |  |  | 29 |  |  |  |  |  |  |  | 3
 | 4 | [NAME] | 35 |  |  | 32 |  |  |  |  |  | 37 |  |  |  |  | 4
 | 5 | [NAME] | 34 |  |  | 31 |  |  | 35 |  |  | 34 |  |  |  |  | 5
 | 6 | [NAME] |  |  |  | 39 |  |  | 35 |  |  |  |  |  |  |  | 6
 | 7 | [NAME] |  |  |  | 33 |  |  |  |  |  | 33 |  |  |  |  | 7
 | 8 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 9 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tblData = B5:E15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tblPoints = G5:H10
Spreadsheet: 3928dc5d-043b-40c4-b67a-3b61fb9c3d20
Sheet: SYCL1LTBP3

MarkerName | Allele1 | Allele2 | P-value-overall | OR-overall | P-value-HPG | OR-HPG | P-value-NPG | OR-NPG | Direction | Gene | Location | 5'gene | 5'dist(kb) | 3'gene | 3'dist(kb) | CHR | BP
rs10896012 | a | g | 0.4312 | 1.042 | 0.9179 | 1.007 | 0.2589 | 1.11 | +- | 0 | Intergenic | DKFZp686B0790 | 7.382 | SCYL1 | 14.086 | 11 | 65035037
rs1787663 | a | c | 0.1225 | 0.931 | 0.3781 | 0.948 | 0.1413 | 0.887 | -- | SCYL1 | Intron | SCYL1 | 0.242 | SCYL1 | 3.269 | 11 | 65051406
rs10896016 | a | g | 0.756 | 1.014 | 0.703 | 1.022 | 0.9953 | 1.001 | [NAME] | 0 | Intergenic | [NAME] | 10.275 | SSSCA1 | 2.237 | 11 | 65092281
Spreadsheet: 100c2a5b-90a8-4576-b37c-2b1ce227e628
Sheet: Real-Time Reserve

Reserve Asset Detail Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserve Asset Detail Report |  |  |  |  |  |  |  |  |  |  | Reserve Asset Detail Report
SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME] |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Reserve Zone |  | Asset |  |  |  |  |  |  | TMSR |  |  |  |  | TMNSR |  |  |  |  | TMOR
Trading Interval | Reserve Zone ID | Reserve Zone Name | Asset ID | Asset Name | Asset Type | Ownership Share | [NAME] | [NAME] | Revenue Quality Metering | Real-Time TMSR Capacity MW | Real-Time Operations TMSR Designation | Real-Time TMSR Designation | Real-Time TMSR Reserve Credit | Participant Share TMSR Credit | Real-Time TMNSR Capacity MW | Real-Time Operations TMNSR Designation | Real-Time TMNSR Designation | Real-Time TMNSR Reserve Credit | Participant Share TMNSR Credit | Real-Time TMOR Capacity MW | Real-Time Operations TMOR Designation | Real-Time TMOR Designation | Real-Time TMOR Reserve Credit | Participant Share TMOR Credit | Total Ten-Minute Real-Time Reserve Designation | Participant Share TMSR Designation | Participant Share TMNSR Designation | Participant Share TMOR Designation | Subaccount ID | Subaccount Name
Hour End | Number | String | Number | String | String | % | MWh | MWh | MWh | MWh | MWh | MWh | $ | $ | MWh | MWh | MWh | $ | $ | MWh | MWh | MWh | $ | $ | MWh | MWh | MWh | MWh | String | String
Spreadsheet: 778661d1651212622-identifying-duplicates-identifying-duplicates-ans
Sheet: Sheet1

Emp | Team |  | Emp | Team
E1 | T1
E1 | T2
E6 | T1
E4 | T2
E3 | T3
E3 | T4
E5 | T6
E5 | T7
Spreadsheet: 847788d1698661528-count-staff-attendance-and-provide-date-attended-training-dates-2023
Sheet: COURSE 1

Training Schedule
Date | Event | Time | Venue | Status | Attendee | Attended
2023-05-12 00:00:00 | COURSE 1 | 09:00-17:00 | Seminar Room | Completed | [NAME] | Yes
 |  |  |  |  | [NAME] | Forgot
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 715236d1611619012-excel-formula-if-certain-text-shows-in-2-differnt-col-show-value-in-a-specific-column-test2
Sheet: Sheet1

 |  |  |  | Item1 |  |  |  |  |  |  |  | item2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item3 | [NAME] Here
 |  |  |  | Raw |  |  |  |  |  |  |  | tomatoes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Raw |  |  |  |  |  |  |  | grapes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Prod |  |  |  |  |  |  |  | Orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Fill |  |  |  |  |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Coat |  |  |  |  |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Coat |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50
 |  |  |  | Coat |  |  |  |  |  |  |  | grapes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50
 |  |  |  | Coat |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50
Spreadsheet: 594532d1539816030-time-calculations-outgoing
Sheet: Outgoing

Scheduled Departure | Actual Departure | Time Difference | 1
2018-10-10 07:55:00
2018-10-10 08:15:00
2018-10-10 10:30:00
2018-10-09 22:30:00 | 2018-10-09 22:26:00
2018-10-10 05:55:00 | 2018-10-10 06:02:00
2018-10-10 06:00:00 | 2018-10-10 05:30:00
2018-10-10 01:00:00 | 2018-10-10 01:00:00
2018-10-10 02:45:00 | 2018-10-10 02:15:00
2018-10-10 06:00:00 | 2018-10-10 06:00:00
2018-10-10 06:00:00 | 2018-10-10 05:55:00
2018-10-10 08:00:00 | 2018-10-10 06:35:00
2018-10-09 23:45:00 | 2018-10-10 00:04:00
2018-10-10 03:30:00 | 2018-10-10 03:15:00
2018-10-09 20:00:00 | 2018-10-09 19:44:00
2018-10-10 03:30:00 | 2018-10-10 03:29:00
2018-10-10 06:00:00 | 2018-10-10 05:45:00
2018-10-10 06:00:00 | 2018-10-10 05:45:00
2018-10-10 03:30:00 | 2018-10-10 03:20:00
2018-10-10 05:45:00 | 2018-10-10 05:30:00
2018-10-10 06:15:00 | 2018-10-10 06:00:00
2018-10-10 06:15:00 | 2018-10-10 06:00:00
2018-10-09 21:00:00 | 2018-10-09 20:52:00
2018-10-10 00:30:00 | 2018-10-10 00:25:00
2018-10-10 03:30:00 | 2018-10-10 03:15:00
2018-10-09 22:00:00 | 2018-10-09 21:59:00
2018-10-10 02:30:00 | 2018-10-10 02:15:00
2018-10-10 06:00:00 | 2018-10-10 05:45:00
2018-10-10 06:00:00 | 2018-10-10 05:55:00
2018-10-10 03:00:00 | 2018-10-10 03:00:00
2018-10-10 00:35:00 | 2018-10-10 00:25:00
2018-10-10 06:00:00 | 2018-10-10 06:09:00
2018-10-09 21:00:00 | 2018-10-09 20:59:00
2018-10-09 22:00:00 | 2018-10-09 22:06:00
2018-10-10 03:30:00 | 2018-10-10 03:15:00
2018-10-10 04:30:00 | 2018-10-10 04:29:00
2018-10-10 05:00:00 | 2018-10-10 04:45:00
2018-10-10 03:30:00 | 2018-10-10 03:15:00
2018-10-09 22:00:00 | 2018-10-09 22:10:00
2018-10-09 22:30:00 | 2018-10-09 22:30:00
2018-10-10 05:30:00 | 2018-10-10 05:29:00
2018-10-10 02:30:00 | 2018-10-10 02:15:00
Spreadsheet: 38858d1237016834-calculating-total-based-on-cell-contents-schedule
Sheet: Payment

Customer | Code | Amt per hour
Art | A | 4
[NAME] | [NAME] | 8
Geoff | G | 8
[NAME] | J | 10
[NAME] | L | 5
Pete2 | PA | 10
Pete1 | PC | 4
[NAME] | T | 8
Vicky | V | 5
Spreadsheet: darrell_schoolcraft__7785__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 11th = 65,000
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 152 | 154 |  | 443 | 6.5
he 7 | 08:00:00 |  | 152 | 154 |  | 375 | 6.5
he8 | 09:00:00 |  | 152 | 154 |  | 375 | 6.5
he9 | 10:00:00 |  | 152 | 154 |  | 375 | 6.5
he10 | 11:00:00 |  | 152 | 154 |  | 375 | 6.5
he11 | 12:00:00 |  | 152 | 154 |  | 375 | 6.5
he12 | 13:00:00 |  | 152 | 154 |  | 375 | 6.5
[NAME] | 14:00:00 |  | 152 | 154 |  | 375 | 6.5
he14 | 15:00:00 |  | 152 | 154 |  | 375 | 6.5
he15 | 16:00:00 |  | 152 | 154 |  | 375 | 6.5
he16 | 17:00:00 |  | 152 | 154 |  | 375 | 6.5
he17 | 18:00:00 |  | 152 | 154 |  | 375 | 6.5
he18 | 19:00:00 |  | 152 | 154 |  | 375 | 6.5
he19 | 20:00:00 |  | 152 | 154 |  | 375 | 6.5
he20 | 21:00:00 |  | 152 | 154 |  | 375 | 6.5
he21 | 22:00:00 |  | 152 | 154 |  | 375 | 6.5
he21 | 23:00:00 |  | 152 | 154 |  | 375 | 6.5
he22 | 00:00:00 |  | 152 | 154 |  | 375 | 6.5
he23 | 01:00:00 |  | 152 | 154 |  | 425 | 6.5
he24 | 02:00:00 |  | 152 | 154 |  | 425 | 6.5
he1 | 03:00:00 |  | 150 | 100 | 0 | 250 | 6.5
he2 | 04:00:00 |  | 150 | 100 | 0 | 250 | 6.5
he3 | 05:00:00 |  | 150 | 100 | 0 | 250 | 6.5
he4 | 06:00:00 |  | 150 | 100 | 0 | 250 | 6.5
[NAME] | 07:00:00 |  | 150 | 100 | 0 | 250 | 6.5
Spreadsheet: 742575d1627894785-relative-references-to-tables-in-different-workbooks-same-folder-with-indirect-report-01
Sheet: Sheet 01

 | Report 01 : Weight |  | Direct |  | Indirect Formula |  | References for indirect formula
 |  |  |  |  |  |  | [NAME] | Table | Result Column | Group | Group Column |  | Group | Result |  | Group | Result
 | [NAME], average |  |  |  |  |  | Source.xlsx | Weight | [NAME] | [NAME] | Group
 | [NAME], average |  |  |  |  |  | Source.xlsx | Weight | [NAME] | [NAME] | Group
 | [NAME], average |  |  |  |  |  | Source.xlsx | Weight | [NAME] | [NAME] | Group
Spreadsheet: 725685d1616791240-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-2021bb-jt
Sheet: Customers statement

Current solution calculate 100 record on the sheets. I want it to calculate at least 5000 record on the sheets.
I have tried to adjust the formula but I have failed. Please help me.
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance |  |  | Sheet | Row
Desired Outcome
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
2020-01-01 00:00:00 |  | C001 | 400
2020-01-10 00:00:00 |  | 1 | 2000
2020-01-12 00:00:00 | R010 | C001 |  | 300
2020-01-14 00:00:00 | R012 | 3 |  | 1000
2020-05-12 00:00:00 |  | 5 | 2300
2020-09-09 00:00:00 |  | 9 | 2500
Spreadsheet: matthew_lenhart__26317__West Daily Prices1022-01
Sheet: Off Peak Curve Sum Backup

 | R7 | R8 | R9 | R10 | R11 | B4 |  | R12 |  |  |  |  |  |  |  |  | R21
1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 9 |  |  |  |  |  |  |  |  | 18
 | WEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALBERTA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAS CURVES
 | Palo Verde | COB | MID-COLUMBIA | NP15 | SP15 | Mead |  | ZP26 |  |  |  |  |  |  |  |  | ALBERTA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NG HH | CHICAGO LDC | ALGONQUIN | TETCO M3 | TRANSCO Z6
Spreadsheet: 771453d1646680801-nested-if-and-sample-4
Sheet: Sheet1

Achieved Value % | 1.767053156467854 | 0.5334983143246539 | 0.51
Achieved Volume % | 1 | 0.5 | 0.43
 | month 1 | month 2 | month 3
 |  | 0.35 | 0.38 | 0.41 | 0.45
Month | 1 | 50 | 75 | 150 | 250
 | 2 | 50 | 75 | 150 | 250
 | 3 | 50 | 75 | 150 | 250
Spreadsheet: 213771d1360644272-show-data-based-from-selected-parameters-in-drop-down-dropdown
Sheet: Sheet1

MONTH |  | JANUARY 2013
BRANCH |  | Branch1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY 2013 |  |  | Branch1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY 2013 |  |  | Branch2
PRODUCTS | BRANCH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARCH 2013 |  |  | Branch3
Product1 |  |  |  |  |  |  | Fill the figures based from the selected parameters  All DATA from Source tab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL 2013 |  |  | Branch4
Product2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY 2013 |  |  | Branch5
Product3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE 2013 |  |  | Branch6
Product4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY 2013 |  |  | Branch7
Product5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST 2013 |  |  | Branch8
Product6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER 2013 |  |  | Branch9
Product7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER 2013
Product8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER2013
Product9
Product10
Product11
Product12
Product13
Spreadsheet: 887535d1737755664-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Sep

 |  |  | 2026-08-31 00:00:00 | 2026-09-01 00:00:00 | 2026-09-02 00:00:00 | 2026-09-03 00:00:00 | 2026-09-04 00:00:00 | 2026-09-05 00:00:00
 |  |  | 2026-09-07 00:00:00 | 2026-09-08 00:00:00 | 2026-09-09 00:00:00 | 2026-09-10 00:00:00 | 2026-09-11 00:00:00 | 2026-09-12 00:00:00
 |  |  | 2026-09-14 00:00:00 | 2026-09-15 00:00:00 | 2026-09-16 00:00:00 | 2026-09-17 00:00:00 | 2026-09-18 00:00:00 | 2026-09-19 00:00:00
 |  |  | 2026-09-21 00:00:00 | 2026-09-22 00:00:00 | 2026-09-23 00:00:00 | 2026-09-24 00:00:00 | 2026-09-25 00:00:00 | 2026-09-26 00:00:00
 |  |  | 2026-09-28 00:00:00 | 2026-09-29 00:00:00 | 2026-09-30 00:00:00 | 2026-10-01 00:00:00 | 2026-10-02 00:00:00 | 2026-10-03 00:00:00
 |  |  | 2026-10-05 00:00:00 | Notes
Spreadsheet: sally_beck__34335__Cashflow Forecast Estate 12-18r
Sheet: Hdct & Wages

 |  |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003
SALARIES | Dec '01 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun
Apollo |  |  | 306013
Hall |  |  | 215195
Pearce | 32418 |  | 32418 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Sweeney | 248714 |  | 248713 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Perlman |  |  | 770253
Rub |  |  | 657856
Webb |  |  | 58960
Richter |  |  | 57417 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Piper | 27415.41
Pickering & Roper
Beck & HR
Dayao |  |  | 348890
Sommers | 0
Total Salaries
Estimated Tax Rate | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231 |  | 0.231
Total
Millions - Outflow
Tax Expense
Rounded
HEADCOUNT | Dec '01 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun
Apollo |  |  | 51
Hall |  |  | 48
Pearce | 3 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Sweeney | 40 |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Perlman |  |  | 117
Rub |  |  | 121
Webb |  |  | 9
Richter | 47 |  | 7 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Piper | 3
Pickering | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Beck & HR
Dayao |  |  | 51
Sommers | 0
Accounting | 8
Total Headcount