tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686695d1594754592-formula-help-to-average-cells-based-on-set-number-of-entries-2020-07-14-oeldere3-marcellab-686590d1594703072-formula-to-average-and-count-excel-help
Sheet: Sheet1 

Customer | Booking Date | SM
CUSTOMER A | 2019-06-01 00:00:00 | 0.9
CUSTOMER B | 2019-07-01 00:00:00 | 0.4
CUSTOMER C | 2019-08-01 00:00:00 | 0.541
CUSTOMER D | 2019-08-01 00:00:00 | 0.579
CUSTOMER E | 2019-08-01 00:00:00 | 0.695
CUSTOMER F | 2019-11-01 00:00:00 | 0.723
CUSTOMER G | 2020-01-01 00:00:00 | 0.675 | 0.675
CUSTOMER H | 2020-06-01 00:00:00 | 0.765 | 0.765
CUSTOMER I | 2020-07-01 00:00:00 | 0.65
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
Spreadsheet: 729417d1619084252-sumifs-function-seeing-the-records-that-make-up-a-result-bathrooms-project-budget-analysis-audit-of-sumifs-making-up-totals
Sheet: Old Analysis

 |  | Link split between Committed, Expenditure and Prediction to front sheet
Budget | Total Cost | Workstream | Total Cost | Committed | Expenditure | Prediction | Total | Missing
[NAME] |  | General
 |  | Wall tiling - General
 |  | Floor tiling - Family Bathroom
 |  | Wall tiling - Both Bathrooms
 |  | Tiling - general
 |  | Decoration
Tiling |  | Any old workstream
 |  |  |  |  |  |  | Why does this show as green?
Spreadsheet: 66503d1267135602-excel-chart-wont-print-correctly-archart2
Sheet: Data Input

 |  | 1 | 2 | 3 | 4 | 5 | 6
 | CODE | DOS-A | a | b | c | Other | Total
 | A | Miami | 119.4 | 96.4 | 45.6 | 11 | 45.6
 | A | Mahoning | 109.3 | 113.2 | 40.7 | 2.1 | 56.9
 | A | Southwest | 176.2 | 94.6 | 51.4 | 20.3 | 53.3
 | A | Akron | 139.5 | 91.7 | 39.8 | 23.1 | 54.1
 | A | Central Ohio | 160.3 | 73.7 | 32 | 47.9 | 60.7
 | A | Cleveland | 147.6 | 137.8 | 27.9 | 13.8 | 50
 | A | Toledo | 132.4 | 49.3 | 39.3 | 41.9 | 49.8
 | A | Total | 139.5 | 91.7 | 39.8 | 23.1 | 54.1
 |  | INV-A | a | b | c | Other | Total
 | A | Miami | 118889 | 199647 | 219861 | 35920 | 574317
 | A | Mahoning | 239960 | 250131 | 315828 | 4256 | 810175
 | A | Southwest | 155015 | 238727 | 333210 | 122624 | 849576
 | A | Akron | 134736 | 311822 | 239512 | 42210 | 728280
 | A | Central Ohio | 274110 | 358743 | 188712 | 244550 | 1066115
 | A | Cleveland | 235238 | 166736 | 144803 | 56155 | 602932
 | A | Toledo | 123660 | 54933 | 205824 | 115654 | 500071
 |  | Total | 1281608 | 1580739 | 1647750 | 621369 | 5131466
Spreadsheet: richard_shapiro__32170__shapiro-1
Sheet: yoho

COST CENTER |  | OUTSIDE SERVICES DISCRETIONARY | PRIORITY | REQUESTED | APPROVED | COMMENTS
Yoho (xxx) | L | synfuels / section 29 tax credit | A | 25000 | RCR
 | L | transportation related issues - rail initiative plus others | C | 100000 | RCR
 | L | agriculture | C | 20000 | RCR
 | L | e-commerce initiatives - DOJ comments on competition policy, removal of regulatory hurdles to trade certain commodities online, and general advocacy | B | 100000 | RCR
 | L | CFTC initiatives - AOTM lics., comments on regulatory changes, etc. | B | 20000 | RCR
Yoho Total |  | Yoho Total
COST CENTER |  | OUTSIDE SERVICES FIXED |  | REQUESTED | APPROVED
Yoho (xxx) | L | [NAME] regulatory lobbying | A | 180000 | 180000
Yoho Total |  | Yoho Total
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Discretionary
[NAME]
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Fixed
[NAME]
Budget - Other Business Expense |  |  |  | 1200000 | 1200000
Other Business Expense |  |  |  | 0 | 0
[NAME]
Spreadsheet: 101886d1299934362-query-sum-of-values-in-column-solver_number
Sheet: Solver_find_number

17 | 1 | 1
12 | 8 | 1
20 | 12 | 1 |  | Select value to match |  | 37 |  | Matching number found in cells |  |  | B1  B2  B3  B4
15 | 16 | 1
8 | 3 | 0
 | 19 | 0
 | 20 | 0
 |  | 37
 | Target cell | 0
 | This is a Solver example of matching numbers.
 | But the problem with solver is that it will only find one solution.
 | If you choose 20 as the number to match Solver will only find
 | B7 as the matching number but B2+B3 and also B1+B4+B5
 | are possible combinations giving 20 as a result.
 | As the value of the target cell in this example is set to "Min"
 | and therfore Solver will always find a solution to the problem.
 | A more "realistic" approach is probably setting it to "the value of"
 | and selecting 0 as the value.Try selecting 18 as the value to match
 | You could also try combinations of A values. 29 (A1+A2) will find
 | one combination of B values (B1+ B3 + B4) as well as 37 (A1+A3)
 | If Solver is a possible solution to your problem one could certainly
 | add a macro that loops and test different A values or combinationa
 | of A values and record the appropiate B combinations.
Spreadsheet: 3eadd0a7-4291-404e-a70a-5601b6693031
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Transaction Date: 05/03/2012
Debt and Money Market Securities Transaction Details
SR. NO | NAME OF SECURITY | ISIN | FUND HOUSE | SCHEME NAME | MATURITY DATE | RESIDUAL DAYS | SETTLEMENT TYPE | TRADE DATE | VALUATION DATE | SETTLEMENT DATE | QUANTITY TRADED | VALUE OF THE TRADE | PRICE AT WHICH VALUED | YIELD AT WHICH VALUED | TYPE OF TRADE
1 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 08/11/2021 | 3535 | T+1 | 05/03/2012 | 05/03/2012 | 2012-03-06 00:00:00 | 1000000 | 103850000 | 103.85 | 8.2027 | MARKET TRADE
2 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3535 | T+1 | 05/03/2012 | 05/03/2012 | 2012-03-06 00:00:00 | 200000 | 20765000 | 103.83 | 8.2064 | MARKET TRADE
3 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3535 | T+1 | 05/03/2012 | 05/03/2012 | 2012-03-06 00:00:00 | 1000000 | 103825000 | 103.83 | 8.2064 | MARKET TRADE
4 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3535 | T+1 | 05/03/2012 | 05/03/2012 | 2012-03-06 00:00:00 | 1000000 | 103820000 | 103.82 | 8.2071 | MARKET TRADE
5 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3535 | T+1 | 05/03/2012 | 05/03/2012 | 2012-03-06 00:00:00 | 300000 | 31147500 | 103.83 | 8.2064 | MARKET TRADE
Note: | Value of the trade is based on the clean price.
 | Repo/CBLO and Fixed Deposits trades as not valued have not be reported.
 | Report is on Transaction level basis.
Spreadsheet: 839751d1692196889-help-linking-2-workbooks-extracting-column-header-based-on-date-copy-of-2023-manufacturing-schedule_excelforum
Sheet: starting comparison

 |  | YTD comparison with Starting assumptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pack date | Packed qty
 |  |  |  |  |  |  |  |  | total Pack plan | Packed |  | total packed | Still to pack | Lost to OOS | US lost to OOS | UK lost to OOS | Others lost to OOS | US Re-directed to UK | total to US | Total new UK | US+UK
Criteria | starting | Current |  |  |  |  |  | Total  planned Filled |  | US | UK
Volume | 22.185 | 18.8672071
US | 14.768 | 14.5590771
EU/Can | 7.16 | 3.51613
[NAME] | 9.9 | 10.1
Avge boost | 7.4 | 7.2 - 7.5
Doses/bx | 1.58 | 2.67
starting Inv | 21 | 31.5
No. of bxs | 84 | 48
finish date | June 28th | June 3rd
Spreadsheet: 4c4644cc-410f-47f1-a3f6-1ac5bc2c954e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3478 | 15990 | [NAME] | Finaughty | ZIM | 68 | 00:11:06 | 00:00:41 | 00:29:21 | 00:00:20 | 00:18:22 | 1 | [NAME]
3478 | 7803 | Vicky | [NAME] | RSA | 67 | 00:11:45 | 00:00:36 | 00:30:18 | 00:00:27 | 00:19:36 | 2 | 01:02:45
3478 | 12804 | [NAME] | Fischer | RSA | 0 | 00:12:06 | 00:00:34 | 00:31:20 | 00:00:25 | 00:19:57 | 3 | 01:04:23
3478 | 12800 | [NAME] | Henrisson | MRI | 65 | [NAME] | 00:00:43 | 00:31:25 | 00:00:20 | 00:21:05 | 4 | 01:05:30
3478 | 21975 | Ibtissem | Dhuibi | TUN | 0 | 00:12:10 | 00:01:27 | 00:35:02 | [NAME] | 00:21:36 | 5 | 01:10:36
Spreadsheet: 230541d1366807181-return-multiple-values-from-multiple-sheets-example-1-
Sheet: JUN

EQUIPMENT | DATE | TEMP | BEGIN PSIG | END PSIG | VALVE | ACTIVITY | MCF LOSS | BBLS H20
COMPRESSOR #1 | 2013-06-03 00:00:00 | 98 | 1005 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #1 | 2013-06-04 00:00:00 | 95 | 1004 | 550 | N/A | BLOWDOWN | 8.25 | 0
COMPRESSOR #1 | 2013-06-10 00:00:00 | 96 | 1008 | 0 | N/A | BLOWDOWN | 15.5 | 0
COMPRESSOR #2 | 2013-06-03 00:00:00 | 99 | 995 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #3 | 2013-06-05 00:00:00 | 96 | 998 | 0 | N/A | BLOWDOWN | 15 | 0
COMPRESSOR #3 | 2013-06-09 00:00:00 | 95 | 1002 | 650 | N/A | BLOWDOWN | 6.75 | 0
COMPRESSOR #4 | 2013-06-15 00:00:00 | 92 | 999 | 0 | N/A | BLOWDOWN | 15 | 0
COMPRESSOR #5 | 2013-06-06 00:00:00 | 91 | 996 | 0 | N/A | BLOWDOWN | 15 | 0
COMPRESSOR #5 | 2013-06-13 00:00:00 | 94 | 1001 | 600 | N/A | BLOWDOWN | 6 | 0
COMPRESSOR #5 | 2013-06-24 00:00:00 | 93 | 1000 | 0 | N/A | BLOWDOWN | 15.5 | 0
SLUG CATCHER | 2013-06-18 00:00:00 | 90 | 1002 | 0 | N/A | BLOWDOWN | 5.5 | 0
SLUG CATCHER | 2013-06-21 00:00:00 | 88 | 1004 | 0 | N/A | BLOWDOWN | 5 | 0
DEHY CONTACTOR | 2013-06-15 00:00:00 | 92 | 1002 | 0 | N/A | BLOWDOWN | 6.25 | 0
Spreadsheet: tracy_geaccone__40255__C0366-111727
Sheet: Dept_100192

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CAFETERIA - Dept. 100192
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-05-29 00:00:00 | CFT2001/05-0366/111727 |  | Work Place | Work Place Count | 7 | 14.08 | /MNTH | 98.56
 |  |  |  |  |  |  | Ticket Total |  | 98.56
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 98.56
 |  |  |  |  |  |  | Total for Dept_100192 |  | 98.56
Spreadsheet: lynn_blair__24320__INTERCONNECT NOMvsSCHED
Sheet: Dec 08

 |  | INTERCONNECT NOMINATED vs. SCHEDULED FOR NNG
 | Gas Day: | 2001-12-08 00:00:00 |  | Cycle: |  | Timely |  | Evening |  | IntraDay 1 |  | IntraDay 2
 |  |  |  | Prior Day | Prior Day |  |  |  |  |  |  |  |  | REDUCTION
IC PIPE | POI | K# | Gas Type | [NAME] | Sched | NOM | SCHED | NOM | SCHED | NOM | SCHED | NOM | SCHED | REASON
EPNG | 169 | Nothing significant to report
 | 186
 | 2618
 | 57088
 | 57100
[NAME] | 2174 | Nothing significant to report
OASIS | 64128 | Nothing significant to report
PEPL | 173 | 108321 |  | 7495 | 7495 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
 |  | 107628 |  | 6428 | 6428 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
 |  | 100796 |  | 15288 | 15288 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
TWPL | 3531 | Nothing significant to report
 | 60667
 | 60749
ENA/LE330 |  | K# | Gas Type |  |  | NOM | SCHED |  |  |  |  |  |  | REASON
[NAME] | 37654 | 100919 | IT |  |  | 2010 | 2010 |  |  |  |  |  |  | PBR - Pool Mismatches
 |  | 101099 | [NAME]
Note: | K#101099 is an administrative contract set up to reimburse ENA for providing Electricity to operate the electric compressors on NNG.
 | This gas should continue to flow when nominated.  The volume is 2,010 dth per day for December.  If you have any questions, please call.
Spreadsheet: sally_beck__33711__Hot List 0623
Sheet: Hotlist - Completed

E N R O N   N O R T H   A M E R I C A - H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 2Q00 DEALS COMPLETED
 |  | East Midstream |  |  |  |  |  | Mexico
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | City of Austin |  | 0 |  |  |  | Vitro |  | 0
 |  | Great River |  | 975 | * |  |  | Other
 |  | Other
 |  | Budget |  |  |  | Unrealized Budget |  | Budget |  |  |  | Unrealized Budget
 |  | West Midstream |  |  |  |  |  | HPL & LRC
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Other |  |  |  |  |  | Saxet Energy |  | 552
 |  |  |  |  |  |  |  | CP&L |  | 490
 |  | Budget |  |  |  | Unrealized Budget |  | Costilla |  | 454
 |  |  |  |  |  |  |  | Costilla |  | 256
 |  |  |  |  |  |  |  | EEX |  | 230
 |  | Industrial Downstream |  |  |  |  |  | Chusei |  | 208
 |  | Deal |  | Value |  |  |  | 98 Deals Under 200K |  | 3368
 |  | Grupo Editorale Espresso |  | 220 |  |  |  | Other
 |  | Pacific Forrest Resources |  | 116
 |  | Other
 |  | Budget |  |  |  | Unrealized Budget |  | Budget |  |  |  | Unrealized Budget
 |  | Generation Investments/IPP |  |  |  |  |  | Upstream Originations
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Motown |  | 12600 |  |  |  | Sithe |  | 4157
 |  | Other |  |  |  |  |  | NYISO |  | 1600
 |  |  |  |  |  |  |  | Gallup |  | 861
 |  |  |  |  |  |  |  | North Central Oil |  | 527
 |  | Budget |  |  |  | Unrealized Budget |  | 2 Deals Under 100K |  | 63
 |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  | Budget |  |  |  | Unrealized Budget
 |  | Coal Origination & Finance
 |  | Deal |  | Value
 |  | Other |  |  |  |  |  | Principal Investing
 |  |  |  |  |  |  |  | Deal |  | Value
 |  |  |  |  |  |  |  | Metering Technology Corp |  | 0
 |  | Budget |  |  |  | Unrealized Budget |  | Power Systems MFG |  | 0
 |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  | Budget |  |  |  | Unrealized Budget
 |  | Canada Origination & Finance
 |  | Deal |  | Value
 |  | CNR Pipe Assignment |  | 1300 |  |  |  | Energy Capital Resources
 |  | CNR Warrants |  | 1700 |  |  |  | Deal |  | Value
 |  | CNR Warrants 2 |  | 950 |  |  |  | Other
 |  | [NAME] |  | 500 |  |  |  | Budget |  |  |  | Unrealized Budget
 |  | Petro-Canada Incentive Payment |  | 460
 |  | [NAME] |  | 400
 |  | Beau Canada |  | 350
 |  | Gas Alberta |  | 340 |  |  |  | CTG Assets
 |  | Enmax |  | 230 |  |  |  | Deal |  | Value
 |  | Aggregate Deals < $200K |  | 700 |  |  |  | Gasco |  | -170
 |  | British Energy PPA |  | 0 |  |  |  | [NAME] |  | -54.943
 |  | Other |  |  |  |  |  | Other |  | -12599.057
 |  | Budget |  |  |  | Unrealized Budget |  | Budget |  |  |  | Unrealized Budget
 |  | GRM New Products |  |  |  |  |  | Office of the Chairman
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Other |  |  |  |  |  | Other
 |  | Budget |  |  |  | Unrealized Budget |  | Budget |  |  |  | Unrealized Budget
Spreadsheet: 8a072b92-156a-48bb-936e-338364e62a40
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-07-20 09:43:53.680000
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 | 102.058 | 101.933 | 101.808 | 101.433
3.75 | 101.719 | 101.594 | 101.469 | 101.094 |  | Note: | Refer To Price [NAME]
3.625 | 101.322 | 101.197 | 101.072 | 100.697 |  |  | For all Price Adjs
3.5 | 100.759 | 100.634 | 100.509 | 99.884
3.375 | 99.911 | 99.786 | 99.661 | 99.036
3.25 | 98.988 | 98.863 | 98.738 | 98.113
 |  |  |  |  |  | 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.125 | 102 | 101.875 | 101.5
3.25 | 101.843 | 101.718 | 101.593 | 101.218
3.125 | 101.55 | 101.425 | 101.3 | 100.925
3 | 101.2 | 101.075 | 100.95 | 100.575
2.875 | 100.608 | 100.483 | 100.358 | 99.733
2.75 | 99.95 | 99.825 | 99.7 | 99.075
 |  |  |  |  |  | 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-03 09:43:53.680000
30 DAY | 2012-08-18 09:43:53.680000
45 DAY | 2012-09-02 09:43:53.680000
60 DAY | 2012-09-17 09:43:53.680000
90 DAY | 2012-10-17 09:43:53.680000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 102226d1300212969-excel-2007-nested-sumif-or-using-sumifs-sapmle-01
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
Yes | 50 | 45 | 30 | 20 | 5
No | 45 | 40 | 25 | 15 | 4
Maybe | 40 | 35 | 20 | 10 | 3
NA | 35 | 30 | 15 | 5 | 2
Needs to Read like this:
Agency | Yes | No | Maybe | NA
1 | 50 | 45 | 40 | 35
5 | 5 | 4 | 3 | 2
3 | 30 | 25 | 20 | 15
2 | 45 | 40 | 35 | 30
4 | 20 | 15 | 10 | 5
I need to search indeffinate Columns for a specific ID then search Indeffinate Rows for a Specific Data Type and give the corresponding data.
 | A | B | C | D
Days | 365 | 250 | 159 | 73
Min | 1538 | 468 | 5497 | 25
Hours | 548 | 45 | 548 | 3
Visits | 154987 | 2155 | 5484 | 99
Units | 35484 | 321854 | 54984 | 875
Agency |  |  | * I want to be able to drop A-D in and the correct Units, Hrs, Days, etc drop in by searching for that data type.
Units
Hours
Visits
Days
Results should be
Agency | A
Units | 35484
Hours | 548
Visits | 154987
Days | 365 |  |  |  | I have a home office with 5 stores.  I need to enter all data form 5 stores on one worksheet and have it automatically fill in a form based on whatever store ID I chose.
Store: | A
Days
Min
Hours
Visits
 |  |  |  | 123456 | 222333 | 444555
 | 444555 |  | Data
days |  |  | days | 365 | 400 | 100
units |  |  | units | 400 | 401 | 110
dollars |  |  | dollars | 500 | 402 | 120
weeks |  |  | weeks | 600 | 403 | 130
months |  |  | months | 700 | 404 | 140
employees |  |  | employees | 80 | 405 | 150
cost |  |  | cost | 900 | 406 | 160
NOW I need something that will search for the corresponding ID AND search Data for "days", "units" etc…
 |  |  |  | 123456 | 222333 | 444555
 | 123456 |  | Data
days |  |  | days | 365 | 400 | 100
units |  |  | units | 400 | 401 | 110
dollars |  |  | dollars | 500 | 402 | 120
employees |  |  | weeks | 600 | 403 | 130
cost |  |  | months | 700 | 404 | 140
 |  |  | employees | 80 | 405 | 150
 |  |  | cost | 900 | 406 | 160
Spreadsheet: mark_guzman__24562__MidC
Sheet: DJ Mid-C 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] |  |  | [NAME]
 | 2000-10-31 00:00:00 |  | 90.17 | 10400 | 82.54 | 5440
 | 2000-10-30 00:00:00 |  | 93.14 | 8416 | 86.42 | 4000 | 92.56 | 766 | 69.43 | 816
 | 2000-10-29 00:00:00 |  |  |  |  |  | 74.83 | 1810 | 76.87 | 1457 |  | 86.85 | 10200
 | 2000-10-28 00:00:00 |  | 88.63 | 12960 | 83.75 | 5000 | 80.77 | 650 | 70 | 410
 | 2000-10-27 00:00:00 |  | 88.73 | 13360 | 83.89 | 4560 | 85.35 | 720 | 73.95 | 885
 | 2000-10-26 00:00:00 |  | 97.34 | 12960 | 83.84 | 5000 | 90.52 | 1455 | 79.25 | 530
 | 2000-10-25 00:00:00 |  | 97.34 | 12960 | 83.84 | 5000 | 88.59 | 1313 | 77.5 | 100
 | 2000-10-24 00:00:00 |  | 97.34 | 12960 | 83.84 | 5000 | 99.67 | 2350 | 89.39 | 820
 | 2000-10-23 00:00:00 |  | 102.69 | 11760 | 94.26 | 3360 | 105.57 | 161 | 87.88 | 1650
 | 2000-10-22 00:00:00 |  | 100 | 800 | 89 | 400 | 91.9 | 800 | 86.13 | 1000 |  | 93.62 | 8880
 | 2000-10-21 00:00:00 |  | 98.16 | 14800 | 84.89 | 5760 | 91.8 | 1900 | 81.72 | 320
 | 2000-10-20 00:00:00 |  | 98.13 | 15200 | 84.89 | 5760 | 98.9 | 428 | 82.44 | 280
 | 2000-10-19 00:00:00 |  | 103.82 | 15440 | 85.66 | 4800 | 98.78 | 945 | 81.11 | 306
 | 2000-10-18 00:00:00 |  | 105.81 | 14800 | 85.87 | 4600 | 107.62 | 515 | 84.21 | 630
 | 2000-10-17 00:00:00 |  | 106.32 | 12832 | 84.88 | 3200 | 91.68 | 670 | 89.34 | 790
 | 2000-10-16 00:00:00 |  | 94.46 | 10400 | 87.47 | 5800 | 117.08 | 805 | 91.65 | 1212
 | 2000-10-15 00:00:00 |  | 90 | 0 | 80 | 0 | 85.41 | 368 | 79.93 | 675 |  | 87.4 | 18600
 | 2000-10-14 00:00:00 |  | 81.33 | 14000 | 76.5 | 5200 | 84.33 | 721 | 80.95 | 475
 | 2000-10-13 00:00:00 |  | 81.33 | 14000 | 76.52 | 5400 | 93.6 | 430 | 78.57 | 140
 | 2000-10-12 00:00:00 |  | 95.44 | 12400 | 77.18 | 6800 | 106.6 | 477 | 76 | 0
 | 2000-10-11 00:00:00 |  | 105.94 | 15360 | 77.51 | 5896 | 97.64 | 717 | 79 | 125
 | 2000-10-10 00:00:00 |  | 102 | 12800 | 73.02 | 5400 | 93.64 | 176 | 74.99 | 639
 | 2000-10-09 00:00:00 |  | 125.46 | 15600 | 99.14 | 2800 | 95.5 | 258 | 74.45 | 360
 | 2000-10-08 00:00:00 |  | 116.88 | 2560 | 90 | 0 | 80.84 | 418 | 74.15 | 469 |  | 99.5 | 8400
 | 2000-10-07 00:00:00 |  | 107.05 | 25360 | 77.06 | 6400 | 88.4 | 2027 | 75.41 | 292
 | 2000-10-06 00:00:00 |  | 107.02 | 24560 | 77.06 | 6400 | 103.59 | 675 | 85.72 | 559
 | 2000-10-05 00:00:00 |  | 122.71 | 12400 | 83.48 | 5400 | 107.14 | 2875 | 88.15 | 1854
 | 2000-10-04 00:00:00 |  | 123.09 | 11200 | 78.29 | 4800 | 124.02 | 1195 | 80.49 | 434
 | 2000-10-03 00:00:00 |  | 151.05 | 16400 | 87.14 | 4400 | 110 | 25 | 77.08 | 1406
 | 2000-10-02 00:00:00 |  | 131.51 | 15424 | 104.78 | 5000 | 104.71 | 260 | 75.69 | 1237
 | 2000-10-01 00:00:00 |  | 119 | 800 | 90 | 0 | 97.75 | 1410 | 89.77 | 959 |  | 105.44 | 10800
 |  |  |  |  |  | ..
Spreadsheet: 7864031c-edd0-4d68-aa83-87c04c295f40
Sheet: KCPDU Approp

 |  | APPROPRIATION TRANSACTION
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Police
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2390 |  | 213034 |  | A |  |  |  | 168505 |  | Inc
 |  | 2390 |  | 213034 |  | B |  |  |  | 131225 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2390 |  | 213034 |  | 602200 |  |  |  | 168505 |  | Inc
 |  | 2390 |  | 213034 |  | 619080 |  |  |  | 131225 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 760226d1640087923-getting-data-from-different-tabs-book1
Sheet: Kickstart Profile

 |  |  | Week Commencing (Monday) |  | Week No
2021-04-04 00:00:00
 |  |  |  |  | WC TRACKER |  | QLIK
 |  |  | Profile (8 months from W/E 09th May) | Weekly Profile | Starts  W/E | Starts VS Weekly Profile W/E | Current Week | Starts | Starts VS Weekly Profile | Previous 2 Weeks Starts
 |  | A |  | 17 |  |  |  | 14 |  | 8 | 14
 |  | B |  | 35 |  |  |  | 21 |  | 14 | 39
 |  | C |  | 19 |  |  |  | 8 |  | 4 | 15
 |  | D |  | 40 |  |  |  | 54 |  | 25 | 85
 |  | E |  | 28 |  |  |  | 14 |  | 7 | 17
 |  | F |  | 16 |  |  |  | 11 |  | 7 | 9
 |  | G |  | 34 |  |  |  | 24 |  | 6 | 13
 |  | H |  | 16 |  |  |  | 11 |  | 3 | 4
 |  | I |  | 11 |  |  |  | 11 |  | 6 | 10
 |  | J |  | 12 |  |  |  | 15 |  | 6 | 7
 |  | K |  | 21 |  |  |  | 18 |  | 7 | 10
 |  | L |  | 19 |  |  |  | 20 |  | 13 | 20
 |  | M |  | 19 |  |  |  | 23 |  | 7 | 16
 |  | West London
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profile starts
Spreadsheet: 455241d1460179427-conditional-formatting-test-02
Sheet: Sheet1

 |  | 1 | ALGER
 |  | 2 | BASSENS
 |  | 3 | DJIBOUTI
 |  | 4 | LE HAVRE
 |  | 5 | MOBILE
 |  | 6 | NAVEGANTES
 |  | 7 | [NAME]
 |  | 1 | ALGER
 |  | 6 | NAVEGANTES
 |  | 3 | DJIBOUTI
 |  | 4 | [NAME]
 |  | 5 | mobile
 |  | 7
 |  | 8