tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 896c5af7-3d06-4e66-9c0f-710cde335987
Sheet: Sheet1

CONSOLIDATED FISCAL PROGRAM - NATIONAL BUDGET AND EU FUNDS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
AS OF 31.01.2011
 |  |  | (million BGN)
INDICATORS | CONSOLIDATED BUDGET
 |  | National budget | EU Funds 1
к.1 | к.2=к.3+к.4 | к.3 | к.4
I. Revenue and grants | 1675.426987 | 1687.484274 | -12.05728700000001
Tax revenue | 1439.806333 | 1439.806333 | 0
Nontax revenue | 245.615438 | 244.678161 | 0.9372769999999946
Grants | -9.994784 | 2.99978 | -12.994564
ІІ. Expenditure | 2093.060545 | 2022.459029 | 70.60151600000006
Wages and Salaries | 291.556656 | 291.134239 | 0.4224169999999958
Social and health insurance contributions | 75.82628499999998 | 75.63071799999999 | 0.1955669999999969
Maintenance | 295.688555 | 288.194662 | 7.493893000000014
Interests: | 234.188313 | 234.188313 | 0
External | 186.060209 | 186.060209 | 0
Domestic | 48.12810400000001 | 48.12810400000001 | 0
Social expenditure, scholarships | 1017.395936 | 1015.810853 | 1.585083000000054
Subsidies | 59.95926299999999 | 48.401878 | 11.557385
Capital expenditure and net state reserve gain | 118.445537 | 69.098366 | 49.347171
ІІІ. Transfers (net) | -1.011551953311596e-13 | -0.04899200000010308 | 0.04899200000000192
Transfers/temporary loans from/to Central budget (net) | -1.011551953311596e-13 | -1.011551953311596e-13 | 0
Other transfers (net) | 0 | -0.04899200000000192 | 0.04899200000000192
Transfers of remitted revenue | 0 | 0 | 0
ІV. BG contribution to the EU budget | 59.6871 | 59.6871 | 0
V. Budget balance - deficit(-)/surplus(+) = /I-II+III-IV/ | -477.3206579999999 | -394.7108469999996 | -82.60981100000006
 | 0.0306190000001493 | 0.03061900000045625 | -1.13686837721616e-13
VI. Financing | 477.251277 | 394.7414660000001 | 82.60981099999995
External (net) | 8.675156 | 8.675156 | 0
Loans (net) | 4.840446 | 4.840446 | 0
Repayments from abroad | 0 | 0 | 0
Securities (net) | 0 | 0 | 0
Deposits (net) | 3.83471 | 3.83471 | 0
Domestic (net) | 462.254448 | 379.7446370000001 | 82.60981099999995
Nonblank (net) | 0 | 0 | 0
Bank (net) | 462.254448 | 379.7446370000001 | 82.50981099999996
o.w.: |  |  | 0
Payment of the account of EU (-) 2 | -1.619581 | 0 | -1.619581
Refunds from EU (+) 2 | 0.664982 | 0 | 0.664982
 |  | 0 | 0 |  | 0
Net acquisition and net lending 3 | 6.321673 | 6.321673 | 0
o. w.: revenue from privatization | 0.298951 | 0.298951 | 0
Note: Source of data - monthly reports of the spending units.
1 EU funds – Pre-accession funds, Structural funds, Cohesion fund (managed by National fund) and also European Agriculture Fund for Rural Development and European Fisheries Fund (managed by Payment agency for common agriculture policy). Including national co-financing
2 Includes direct transfers to agricultural producers as final beneficiaries and market regulatory measures
3 Net lending to nonfinancial enterprises and households, net acquisition of shares and other equity and privatization receipts
Spreadsheet: 744655d1629367865-how-to-use-array-formula-in-dependent-dropdown-list-array_dropdown
Sheet: Sheet1

 |  |  |  | count check | 1st = increment
 | BuildingList | Contract |  |  |  |  |  | BuildingList |  | BuildingList | Contract
 | [NAME] | C2021_01 |  |  |  |  |  |  |  | Building_A
 | Building_D | C2021_02 |  |  |  |  | 1 |  |  | Building_E
 | Building_E | C2021_03 |  |  |  |  | 2
 | Building_C | C2021_04 |  |  |  |  | 3 |  |  |  |  |  | use condition format to check
 | Building_D | C2021_05 |  |  |  |  | 4 |  |  |  |  |  | duplicate value
 | Building_C | C2021_06 |  |  |  |  | 5
 | Building_E | C2021_07 |  |  |  |  | 6
 | Building_C | C2021_08 |  |  |  |  | 7
 | Building_A | C2021_09 |  |  |  |  | 8 |  |  | Building dropdown is done.
 | Building_D | C2021_10 |  |  |  |  | 9 |  |  | But contract can't be listed.
 | Building_C | C2021_11 |  |  |  |  | 10
 | Building_C | C2021_12 |  |  |  |  | 11 |  |  | I want to show these value in dropdown >> | C2021_09
 | Building_E | C2021_13 |  |  |  |  | 12 |  |  |  | C2021_16
 | Building_E | C2021_14 |  |  |  |  | 13 |  |  |  | C2021_17
 | Building_D | C2021_15 |  |  |  |  | 14
 | Building_A | C2021_16 |  |  |  |  | 15 |  |  | validate formula in cell L4 ->> | =IF($B$4:$B$23[NAME],"")
 | Building_A | C2021_17
 | [NAME] | C2021_18 |  |  |  |  |  |  |  | when debug formula it give a result
 | Building_C | C2021_19 |  |  |  |  |  |  |  | {"";"";"";"";"";"";"";"";"C2021_09";"";"";"";"";"";"";"C2021_16";"C2021_17";"";"";""}
 | Building_C | C2021_20 |  |  |  |  |  |  |  | but can not show in a drop down list.
Spreadsheet: 771346d1646641722-truncating-text-in-a-cell-but-only-whole-words-truncating-names-within-excel-example-workbook
Sheet: Test

Number of Characters
Number of Characters
 | FULL NAME | NAME - Part 1 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation)
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 274532d1383144404-vlookup-index-match-excel-help
Sheet: data dump

CAT ID | CAT | ITEM | [NAME] | SALES
49 | SNEAKERS | 99791 | NIKE | 8.9252707
49 | SNEAKERS | 214524 | ADIDAS | 15.6251351
49 | SNEAKERS | 222693 | REBOK | 31.1606066
49 | SNEAKERS | 233112 | GUY HARVEY | 20.911412
49 | SNEAKERS | 233113 | NAILS | 24.6815574
49 | SNEAKERS | 233119 | HAPPY | 34.5660232
49 | SNEAKERS | 236475 | SAD | 11.5605119
49 | SNEAKERS | 236481 | TALL | 9.6350003
49 | SNEAKERS | 251472 | SHORT | 15.575641
49 | SNEAKERS | 251484 | SKINNY | 11.0116801
49 | SNEAKERS | 272653 | FAT | 2.0464849
56 | [NAME] | 76389 | BLUE | 12.0248704
56 | [NAME] | 76391 | RED | 22.6575148
56 | [NAME] | 78683 | PINK | 22.9400014
56 | [NAME] | 78907 | YELLOW | 7.0733762
56 | [NAME] | 80614 | GREEN | 7.375815999999999
56 | [NAME] | 81370 | GRAY | 4.6785382
56 | [NAME] | 98813 | BLACK | 7.198391000000001
56 | [NAME] | 98813 | PURPLE | 4.1949432
56 | [NAME] | 98813 | BURGUNDY | 4.7405995
56 | [NAME] | 98815 | FLOWERS | 11.0193497
56 | [NAME] | 98818 | PRINTS | 3.504188
85 | PANTS | 162905 | [NAME] | 26.0030428
85 | PANTS | 162910 | [NAME] | 45.5169514
85 | PANTS | 162912 | JAKE | 45.09809510000001
85 | PANTS | 182565 | JODI | 8.4074367
85 | PANTS | 182575 | KRISTY | 20.2242848
85 | PANTS | 182716 | [NAME] | 5.004944500000001
85 | PANTS | 182751 | [NAME] | 7.8058047
85 | PANTS | 201995 | [NAME] | 11.3612227
85 | PANTS | 202104 | JACK | 4.994315700000001
85 | PANTS | 202105 | [NAME] | 8.5316276
85 | PANTS | 202108 | [NAME] | 47.1883205
85 | PANTS | 202113 | PAM | 151.0153262
85 | PANTS | 202587 | RAMSAY | 114.248841
85 | PANTS | 202591 | [NAME] | 6.1619506
85 | PANTS | 202602 | CHRISTINE | 18.0595193
85 | PANTS | 202629 | RANDALL | 5.7579541
95 | JEWELRY | 209666 | POPPY | 4.8040807
95 | JEWELRY | 209670 | PENDANT | 3.8794733
95 | JEWELRY | 209696 | METAL | 3.9015151
95 | JEWELRY | 215768 | BANGLE | 3.5644915
95 | JEWELRY | 215772 | BRACELET | 7.9930904
95 | JEWELRY | 215798 | NECKLACE | 7.2046727
95 | JEWELRY | 215812 | BEADED | 5.695998100000001
95 | JEWELRY | 215834 | LONG | 4.4786307
95 | JEWELRY | 215837 | SHORT | 20.3717016
95 | JEWELRY | 215845 | TURQUOISE | 2.8933901
100 | CAMI | 229187 | LACE | 23.0196887
100 | CAMI | 229193 | SEXY | 25.3718445
100 | CAMI | 229195 | HI-LOW | 14.9792225
100 | CAMI | 229261 | LAPIS | 62.9885338
100 | CAMI | 229262 | POLKA DOT | 27.8594558
100 | CAMI | 229272 | CUTOUT | 12.7325049
100 | CAMI | 229282 | ANTIQUE | 47.9880403
100 | CAMI | 229283 | TEARDROP | 32.6976337
115 | [NAME] | 173743 | BUCKLE | 19.0297075
115 | [NAME] | 173750 | LEOPARD | 6.4115253
115 | [NAME] | 229048 | CONFETTI | 6.0206821
115 | [NAME] | 229058 | JEWELED | 14.7409345
115 | [NAME] | 229086 | SERPENT LEATHER | 15.7378995
115 | [NAME] | 229089 | SILICONE STRAP | 14.1343594
115 | [NAME] | 263734 | WHITE STRAP | 16.6910711
115 | [NAME] | 263738 | OVERALY | 21.85056520000001
115 | [NAME] | 263740 | LEATHER | 21.101451
115 | [NAME] | 263742 | BRACELET | 31.3976584
115 | [NAME] | 263744 | KALEIDOSCOPE | 72.2370647
115 | [NAME] | 263748 | BUBBLE | 21.4809867
115 | [NAME] | 275576 | PYRAMID | 93.3930619
Spreadsheet: david_delainey__8076__Pro Forma P & L
Sheet: Variable pro-forma

On-Site Power Generation Reclamation
Pro Forma P & L Statement: Year 1
[NAME] |  |  |  |  | 100
Target Contracted Electrical Power (MW) |  | 100 | MW
Estimated Percentage of Target Volume
Actual Contracted Electrical Power (MW) |  |  | MW
Sales
Spot Market Sell-off Rates/Periods in given year: |  |  |  |  | 100
Hours above spot price:
Spot price ($/MWh):
Hours above spot price: |  |  |  | (Hours) |  | (Price)
Spot price ($/MWh):
Total Revenue |  |  |  |  | 100
Cost of Sales
Misc. Variable Costs: |  |  |  |  | 100
Energy Monitor/Controls installation
Hardware per 1 MW:
Labor per 1 MW: |  |  |  | (COS)
Power [NAME] vendor [NAME]
Annual Rebate per 1 MW:
Customer Rebate
Annual Rebate per 1 MW:
Total COS
Gross Profit
Expenses
[NAME] and Wages (Burdened)
Director |  | 300000
Inside Sales Support |  | 200000
Administrative Support |  | 100000
Transportation
Company Car |  | 10000
Travel |  | 100000
General Administration
IT Support/Software/Web |  | 200000
Advertising |  | 30000
Phones |  | 10000
PC's (hardware) |  | 6000
General Supplies |  | 10000
Facility/Support |  | 50000
Operating Expenses
PBIT
Total Cost per MW-hr:
Break Even Point (BEP) in MW at 100% est. costs: |  | 71 MW
Spreadsheet: benjamin_rogers__1013__Pro Forma2
Sheet: ENA Assumptions

ENA Assumptions
Principal:
Interest Rate: | 0.079
Term | 20
Amortization Method
Grace Period | 1
 |  |  |  |  |  | Original Debt | Debt
Project Years |  | Debt Amort | Peak Season Weight | Non-Peak Season Weight |  | Project Years | Amort
2000 |  | 0 | 0.7 |  |  | 2000 | 0
 |  | 0.015 | 1 |  |  | 2001 | 0.034
 |  | 0.035 | 0.7 |  |  | 2002 | 0.031
 |  | 0.045 | 0.7 |  |  | 2003 | 0.0405
 |  | 0.06 | 0.7 |  |  | 2004 | 0.0471
 |  | 0.071 | 0.7 |  |  | 2005 | 0.009
 |  | 0.073 | 0.7 |  |  | 2006 | 0.0445
 |  | 0.071 | 0.7 |  |  | 2007 | 0.0885
 |  | 0.068 | 0.7 |  |  | 2008 | 0.1005
 |  | 0.066 | 0.7 |  |  | 2009 | 0.095
 |  | 0.062 | 0.7 |  |  | 2010 | 0.095
 |  | 0.059 | 0.7 |  |  | 2011 | 0.09
 |  | 0.055 | 0.7 |  |  | 2012 | 0.09
 |  | 0.049 | 0.7 |  |  | 2013 | 0.085
 |  | 0.046 | 0.7 |  |  | 2014 | 0.08
 |  | 0.043 | 0.7 |  |  | 2015 | 0.06990000000000018
 |  | 0.04 | 0.7
2017 |  | 0.038 | 0.7
2018 |  | 0.035 | 0.7
2019 |  | 0.03 | 0.7
2020 |  |  | 0.7
Spreadsheet: 790965d1660082415-overlapping-times-by-date-by-employee-id-test-ccs3
Sheet: Sheet4

Alt_Id | Date | Time_In | Time_Out | Duration | Overlap Flag | overlap
375768 | 2022-07-09 00:00:00 | 12:34:00 | 15:11:00 | 156.9999999999999
375768 | 2022-07-09 00:00:00 | 12:34:00 | 12:54:00 | 20
375768 | 2022-07-09 00:00:00 | 15:12:00 | 17:12:00 | 120
375768 | 2022-07-11 00:00:00 | 10:03:00 | 10:13:00 | 10
375768 | 2022-07-18 00:00:00 | 11:27:00 | 11:37:00 | 10
375768 | 2022-07-25 00:00:00 | 14:07:00 | 14:17:00 | 10
378635 | 2022-07-01 00:00:00 | 17:30:00 | 18:00:00 | 30.00000000000005
378635 | 2022-07-01 00:00:00 | 18:01:00 | 18:31:00 | 30
378635 | 2022-07-05 00:00:00 | 13:30:00 | 14:30:00 | 59.99999999999994
378635 | 2022-07-05 00:00:00 | 14:31:00 | 15:31:00 | 60
378635 | 2022-07-11 00:00:00 | 15:02:00 | 16:22:00 | 80.00000000000003
378635 | 2022-07-11 00:00:00 | 16:23:00 | 17:23:00 | 60
378635 | 2022-07-18 00:00:00 | 15:16:00 | 15:26:00 | 9.999999999999964
378635 | 2022-07-18 00:00:00 | 15:27:00 | 15:37:00 | 10
378635 | 2022-07-19 00:00:00 | 11:08:00 | 11:18:00 | 10.00000000000012
378635 | 2022-07-19 00:00:00 | 11:19:00 | 11:29:00 | 10
378635 | 2022-07-25 00:00:00 | 13:10:00 | 13:20:00 | 10.00000000000012
378635 | 2022-07-25 00:00:00 | 13:21:00 | 13:31:00 | 10
Spreadsheet: 748772d1632332918-create-a-daily-rolling-schedules-from-multiple-worksheets-daily-work-schedule
Sheet: ELEC

Available vs Scheduled Hours
Available Personnel and Hours
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
Shane Seiwert |  |  | 8 | 8 | 8 | 8 | 8
Electricians
 | Break In | Priority |  |  |  |  |  | Status / Issues
U7 IK's / IR's | X | A
U8  8 north precip box  heater  screen in the control room is grey as if it has no power |  | B |  |  |  |  |  | 21-700282 - parts at Dale's desk
ELEC- Troubleshoot and test run IK-32 U8 | WMAT | B | CARD |  |  |  |  | 21-514355 - Needs new card
Repair lighting on U8 TR set roof | n scaff | B | Need Scaff |  |  |  |  | 21-81346 - continuous work - move scaffolding when done at each light
ELEC- Troubleshoot and test run IK-31 U8 |  | B |  |  |  |  |  | 21-515233
ELEC- Troubleshoot IK-37 U8 |  | B |  |  |  |  |  | 21-514560
#3 Lift Station Sump, Pump #2, will not operate |  | B | comp? |  |  |  |  | 21-596626 - needs meggered , new breaker on dale's desk
UAT 7A  has one cooling fan that is not working. Troubleshoot/Repair. |  | B | comp? |  |  |  |  | 21-445906
j tripper 480 breaker mech- when pushing up breaker handle will not start |  | B | comp? |  |  |  |  | 21-721904
CY main brker 480v east side reclaim tunnel broke breaker |  | B | comp? |  |  |  |  | 21-593451 (pruitt)
8-2-2B TR limited performance due to duty cycle turned down. |  | C |  |  |  |  |  | 21-659812 wait for other TR sets working
PMELEC yearly WINTER PREP ON UNIT 8 A & B SIDE SILO AIR SEPARATOR |  | B |  |  |  |  |  | 21-656841
8-1-1B Power Plus TR Set trips immediately on Undervoltage. | wmAT | A |  |  |  |  |  | 21-659754- Needs new powerplus 10/15
UNIT 6 BOILER SUMP PUMP does not kick on when the water gets high and overflows | WMAT | A |  |  |  |  |  | 21-680968 - comp or changing type of level controller?
Power Pluses: Verify and Adjust Ratings on all 12 |  | B |  |  |  |  |  | 21-148188 - wait for other TR sets working
CBT's |  | B
8-3 Ash Pump Auto Discharge Valve will not open or close via the ash panel | WMAT | A
PMELEC 6 MONTHS 8-A&B PRECIPITATOR RAPPERS INSPECTION PM |  | B |  |  |  |  |  | 21-573200
PMELEC yearly UNIT 7 FANS WINTER PREP. CHECK HEAT TRACE ON ALL UNIT 7 FANS |  | B |  |  |  |  |  | 21-656894
Commission U7/U8 SAH Sootblower Purge Valves |  | B |  |  |  |  |  | Bader ready?
U7 125V Battery Ground | Outage | C |  |  |  |  |  | 21-166950 need to lift wires for troubleshoot ground
Toubleshoot U8 IR-55 |  | C |  |  |  |  |  | 21-570981
U8 FLY ASH TRUCK LOADER Emergency Gate not working on ash load out |  |  |  |  |  |  |  | 21-612768
Heat Trace U7 FGD |  | A
Spreadsheet: john_griffith__16157__1_25_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 175 | 185 | 46.9 | 49.6 | 0.61 | 2002-01-25 14:44:00
 | CL J2 | 20 | 275 | 285 | 47.3 | 49 | 0.61 | 2002-01-25 14:44:00
 | CL K2 | 20 | 350 | 360 | 46.8 | 48.1 | 0.6 | 2002-01-25 14:44:00
 | CL M2 | 20 | 390 | 405 | 45 | 46.7 | 0.58 | 2002-01-25 14:44:00
 | CL N2 | 20.5 | 435 | 445 | 43.3 | 44.3 | 0.56 | 2002-01-25 14:44:00
 | CL Q2 | 20.5 | 460 | 475 | 41.8 | 43.1 | 0.55 | 2002-01-25 14:44:00
 | CL U2 | 20.5 | 465 | 480 | 39.3 | 40.5 | 0.51 | 2002-01-25 14:44:00
 | [NAME] | 20.5 | 475 | 487 | 37.3 | 38.3 | 0.49 | 2002-01-25 14:44:00
 | CL X2 | 20.5 | 480 | 495 | 35.6 | 36.7 | 0.47 | 2002-01-25 14:44:00
 | [NAME] | 20.5 | 485 | 500 | 34.3 | 35.4 | 0.45 | 2002-01-25 14:44:00
 | CL F3 | 20.5 | 490 | 515 | 33.1 | 34.8 | 0.44 | 2002-01-25 14:44:00
 | CL G3 | 20.5 | 495 | 520 | 32.1 | 33.8 | 0.42 | 2002-01-25 14:44:00
 | CL M3 | 20.5 | 515 | 540 | 29.4 | 30.9 | 0.39 | 2002-01-25 14:44:00
 | CL Z3 | 20.5 | 530 | 560 | 26.4 | 28 | 0.35 | 2002-01-25 14:44:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 672674d1586958719-building-summary-report-find-multiple-matches-in-a-table-04-10-20-cattle-close-out-report-excel-forum
Sheet: Sheet1

Lot: | [NAME]
Head Days
 |  |  | Qty | [NAME] | %%
 | Total Head Purchased
 | Total Deaths
 | Total Realizers
 | Total Sold
 |  |  | Total | P/H | P/Lb
 | Total Puchase Cost
 | Total Realizer Income
 | Total Sales
Total Dry Matter Intake |  |  |  | Total Wt Gain (Dead's In)
Avg Per Head DMI |  |  |  | Total Wt Gain (Dead's Out)
DM Conv Rate - Deads In |  |  |  | Cost of Gain (Dead's In)
DM Conv Rate - Deads Out |  |  |  | Cost of Gain (Dead's Out)
 |  | ADG (Dead's In)
 |  | ADG (Dead's Out)
 | Total Sales
 | Total cattle Purchase Cost
 | Total Feed Cost
 | Total Med & Vet & Rendering
 | Total Supplemental Feed
 | Total Expense
 | Total Profit / (Loss)
 | Total Profit / (Loss) P/H
Purchase
 | Date | CMS | Qty | [NAME] | Per Per Lb | Amount | Note
Spreadsheet: 874314d1720888885-value-error-value-error
Sheet: Sheet1

 | SEARCH
 | Name | City | id |  |  |  | Name | City | id
 |  |  |  |  |  |  | [NAME] | Petrolia | 123
 |  |  |  |  |  |  | Ira Downer | Petrolia | 345
 |  |  |  |  |  |  | [NAME] | Petrolia | 456
 |  |  |  |  |  |  | [NAME] | Petrolia | 567
 |  |  |  |  |  |  | [NAME] | Petrolia | 678
 |  |  |  |  |  |  | [NAME] | Corunna | 145
 |  |  |  |  |  |  | [NAME] | Sarnia | 367
Spreadsheet: 114210d1310012540-count-value-with-multiple-condition-count-value-dumy
Sheet: Sheet1

 |  | Type | Value |  |  |  |  |  | Name | Order no. | Value
 |  | A | 45 |  |  |  |  |  | [NAME] | 000-G-000 | 20
 |  | A | 41 |  |  |  |  |  | George | 111-A-111 | 25
 |  | A | 15 |  |  |  |  |  | [NAME] | 000-G-020 | 15
 |  | B | 50 |  |  |  |  |  | George | 111-A-112 | 18
 |  | B | 25 |  |  |  |  |  | [NAME] | 102-F-101 | 25
 |  | B | 30 |  |  |  |  |  | George | 111-A-113 | 30
 |  | C | 30 |  |  |  |  |  | [NAME] | 000-G-020 | 30
 |  | C | 55 |  |  |  |  |  | George | 111-A-112 | 35
 |  | C | 20 |  |  |  |  |  | [NAME] | 000-G-020 | 20
 | I would like to count the value if Type is "A" & Value is >=20 and in another column  count value if Type is "A" and value is greater than 30 but less than 40. |  |  |  |  |  |  |  | I would like to count no. of unique order no. for [NAME], [NAME] and Anthony
 |  | Type | Value >40 | Value >30 & > 40 |  |  |  |  |  | Type | No. of order
 |  | A | ? | ? |  |  |  |  |  | [NAME] | ?
 |  | B | ? | ? |  |  |  |  |  | George | ?
 |  | C | ? | ? |  |  |  |  |  | [NAME] | ?
Spreadsheet: 674263d1587737646-help-to-summarizing-column-in-data-table-old-feedlot-head-day-tracking
Sheet: Sheet1

Month Beginning | 2020-04-01 00:00:00
Lot | 7496 | Harris1
Total Head Days
Date | Harris1 | 7496 | Harris3
2020-04-01 00:00:00 | 145 | 0 | 0
2020-04-02 00:00:00 | 143 | 0 | 0
2020-04-03 00:00:00 | 143 | 0 | 0
2020-04-04 00:00:00 | 143 | 0 | 0
2020-04-05 00:00:00 | 143 | 0 | 0
2020-04-06 00:00:00 | 143 | 0 | 0
2020-04-07 00:00:00 | 143 | 0 | 0
2020-04-08 00:00:00 | 143 | 0 | 0
2020-04-09 00:00:00 | 143 | 0 | 0
2020-04-10 00:00:00 | 143 | 0 | 0
2020-04-11 00:00:00 | 143 | 0 | 0
2020-04-12 00:00:00 | 143 | 0 | 0
2020-04-13 00:00:00 | 143 | 0 | 0
2020-04-14 00:00:00 | 143 | 0 | 0
2020-04-15 00:00:00 | 134 | 0 | 0
2020-04-16 00:00:00 | 134 | 0 | 0
2020-04-17 00:00:00 | 134 | 0 | 0
2020-04-18 00:00:00 | 134 | 0 | 0
2020-04-19 00:00:00 | 134 | 0 | 0
2020-04-20 00:00:00 | 134 | 0 | 0
2020-04-21 00:00:00 | 0 | 0 | 0
2020-04-22 00:00:00 | 0 | 0 | 0
2020-04-23 00:00:00 | 0 | 147 | 0
2020-04-24 00:00:00 | 0 | 147 | 0
2020-04-25 00:00:00 | 0 | 147 | 0
2020-04-26 00:00:00 | 0 | 147 | 0
2020-04-27 00:00:00 | 0 | 147 | 0
2020-04-28 00:00:00 | 0 | 147 | 0
2020-04-29 00:00:00 | 0 | 147 | 0
2020-04-30 00:00:00 | 0 | 147 | 0
 | 0 | 0 | 0
Spreadsheet: 836869d1689689881-conditional-format-summary-total-book3
Sheet: Sheet1

 |  | Target | 25 | 50 | 75 | 85
Total Red | 15 | 4
Total Black | 12 | 22
Induction Date | 28/05/2023 | 04/06/2023 | 11/06/2023 | 18/06/2023 | 25/06/2023 | 02/07/2023 | 09/07/2023
2022-03-07 00:00:00 | 77 | 138 | 81 | 98 | 61 |  | 75
2022-03-21 00:00:00
2022-07-11 00:00:00 |  |  |  |  |  |  | 55
2022-09-12 00:00:00 |  | 92 | 77 | 53 | 75 | 107 | 130
2022-09-21 00:00:00 | 72 | 113 | 87 | 79 | 78 | 99 | 77
2022-11-14 00:00:00 | 67 | 72 | 71 | 102 | 79 | 87 | 92
2023-01-30 00:00:00 | 76 | 103 | 88 | 70 | 74 | 95
2023-03-20 00:00:00 | 84 | 107 | 40 | 205 |  |  | 39
2023-03-27 00:00:00 | 73 | 112 | 105 |  |  | 107 | 0
2023-03-27 00:00:00 | 57 |  |  |  |  |  | 71
2023-04-24 00:00:00 | 72 | 112 | 131 | 110 | 105 | 106 | 147
2023-04-24 00:00:00 | 79 | 77 | 76 | 89 | 76 | 77 | 76
2023-04-24 00:00:00 | 83 | 90 | 90 | 82 | 74 | 79 | 79
2023-04-24 00:00:00 | 84 | 95 | 76 | 89 | 47
2023-04-24 00:00:00 | 80 | 73 | 70 | 67 | 69 | 71 | 74
2023-05-01 00:00:00 | 52 | 63 | 75 | 55 | 66 | 67 | 83
2023-05-01 00:00:00 | 93 | 88 | 81 | 78 | 63 | 71 | 78
2023-05-08 00:00:00 | 73 |  |  | 81 | 64 | 90 | 114
2023-05-08 00:00:00 | 93 | 63 | 85 | 96 | 60 | 57 | 72
2023-05-15 00:00:00 | 102 | 51 | 136 | 43 | 54 | 68 | 65
2023-05-15 00:00:00 | 77 | 84 | 82 | 68 |  | 89 | 76
2023-05-15 00:00:00 | 140 | 109 | 72 | 40 | 50 | 67 | 75
2023-05-22 00:00:00 | 61 | 73 | 85 | 90 | 91 | 75 | 60
2023-05-22 00:00:00 | 57 | 70 | 85 | 76 | 57 | 99 | 60
2023-05-29 00:00:00 | 51 | 74 | 94 | 107 | 87 |  | 99
2023-05-29 00:00:00 | 56 | 81 | 86 | 106 | 99 | 89 | 93
2023-05-29 00:00:00 | 34 | 57 | 65 | 60 | 57 | 58 | 70
2023-06-05 00:00:00 |  | 25 | 46 | 52 | 61 |  | 82
2023-06-05 00:00:00 |  |  | 60 | 72 | 84 | 82 | 79
2023-06-05 00:00:00 |  |  | 65 | 65 | 70 | 79 | 90
2023-06-12 00:00:00 |  |  |  |  |  | 78
2023-06-12 00:00:00
2023-06-12 00:00:00 |  |  | 54 | 73 | 62 | 69 | 72
2023-06-12 00:00:00 |  |  | 36 | 45 | 55 | 65 | 60
2023-06-12 00:00:00 |  |  | 36 | 45 | 53 | 61 | 66
2023-06-12 00:00:00 |  |  | 44 | 46 | 50 | 46 | 62
2023-06-12 00:00:00 |  |  | 42 | 58 | 71 | 77 | 83
2023-06-12 00:00:00 |  |  | 45 | 59 | 54 | 65 | 67
2023-06-12 00:00:00 |  |  | 52 | 62 | 142 | 75
2023-06-12 00:00:00 |  |  | 56 | 56 | 87
2023-06-12 00:00:00 |  |  | 54 | 61 | 131
2023-06-12 00:00:00 |  |  | 39 | 57 | 49 | 48 | 51
2023-06-19 00:00:00 |  |  |  | 37 | 48 | 59 | 66
2023-06-19 00:00:00 |  |  |  | 35 | 53 | 314 | 49
2023-06-19 00:00:00 |  |  |  | 41 | 56 | 49 | 47
2023-06-19 00:00:00 |  |  |  | 63 | 79 | 87 | 113
2023-06-19 00:00:00 |  |  |  | 35 | 50 | 46 | 42
2023-06-19 00:00:00 |  |  |  | 49 | 69 | 76 | 72
2023-06-26 00:00:00 |  |  |  |  | 46 | 58
2023-06-26 00:00:00 |  |  |  |  | 80 | 88 | 88
2023-06-26 00:00:00 |  |  |  |  | 38 | 50 | 67
2023-06-26 00:00:00 |  |  |  |  | 80 | 94 | 83
2023-06-26 00:00:00 |  |  |  |  | 33 | 45 | 46
2023-06-26 00:00:00 |  |  |  |  | 97 | 68 | 89
2023-06-26 00:00:00 |  |  |  |  | 37 | 33
Spreadsheet: 681959d1591842983-conditional-buy-by-customers-customers
Sheet: Data

 |  | InPut |  |  |  |  | Output
Row | Code | Customers | Month | Amount |  |  | code | customers
1 | 101 | A | Jan | 1000 |  |  |  |  |  |  | 102 | B
2 | 102 | B | Jan | 1100 |  |  |  |  |  |  | 105 | F
3 | 105 | F | Jan | 1200
4 | 103 | C | Jan | 1300
5 | 101 | A | Jan | 1400
6 | 101 | A | Jan | 1500
7 | 102 | B | Jan | 1600
8 | 103 | C | Jan | 1700
9 | 104 | D | Feb | 1800
10 | 102 | B | Feb | 1900
11 | 103 | C | Feb | 2000
12 | 101 | A | Jan | 2100
13 | 102 | B | Feb | 2200
14 | 102 | B | Feb | 2300
15 | 101 | A | Feb | 2400
16 | 104 | D | Mar | 2500
17 | 103 | C | Mar | 2600
18 | 105 | F | Feb | 2700
19 | 101 | A | Mar | 2800
20 | 101 | A | Mar | 2900
 |  |  |  |  |  | Count of Amount |  | Month
 |  |  |  |  |  | Code | Customers | Jan | Feb | Mar | Grand Total
 |  |  |  |  |  | 101 | A | 4 | 1 | 2 | 7
 |  |  |  |  |  | 102 | B | 2 | 3 |  | 5
 |  |  |  |  |  | 103 | C | 2 | 1 | 1 | 4
 |  |  |  |  |  | 104 | D |  | 1 | 1 | 2
 |  |  |  |  |  | 105 | F | 1 | 1 |  | 2
 |  |  |  |  |  | Grand Total |  | 9 | 7 | 4 | 20