tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854443d1704312341-timer-that-keeps-increasing-exampleforum
Sheet: Sheet1

A | 0 |  |  | Second example --> |  |  | A |  |  | Breakdown of second example but in separate columns: | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 1 |  |  |  |  |  |  |  |  |  | 1
 | 1 |  |  |  |  |  |  |  |  |  | 1
 | 1 |  |  |  |  |  | A |  |  |  | 1 | 0
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 0
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 1
 | 2 |  |  |  |  |  |  |  |  |  | 2 | 1
 | 3 |  |  |  |  |  |  |  |  |  | 3 | 1
 | 3 |  |  |  |  |  |  |  |  |  | 3 | 2
 | 3 |  |  |  |  |  |  |  |  |  | 3 | 2
 | 4 |  |  |  |  |  |  |  |  |  | 4 | 2
 | 4 |  |  |  |  |  |  |  |  |  | 4 | 3
 | 4 |  |  |  |  |  |  |  |  |  | 4 | 3
 | 5 |  |  |  |  |  |  |  |  |  | 5 | 3
 | 5 |  |  |  |  |  |  |  |  |  | 5 | 4
 | 5 |  |  |  |  |  |  |  |  |  | 5 | 4
 | 6 |  |  |  |  |  |  |  |  |  | 6 | 4
Spreadsheet: 267015d1379912604-insert-table_array-as-a-variable-into-vlookup-based-on-data-validation-result-theklaw
Sheet: Sheet1

 | Apples | Values |  | Orange | Values |  | Pears | Values
 | 1 | 11 |  | 1 | 58 |  | 1 | 65
 | 2 | 65 |  | 2 | 39 |  | 2 | 72
 | 3 | 39 |  | 3 | 51 |  | 3 | 69
 | 4 | 53 |  | 4 | 19 |  | 4 | 67
 | 5 | 36 |  | 5 | 23 |  | 5 | 85
 |  | Lookup | Table | Values
 |  | 3 | Apples
Spreadsheet: 836366d1689313377-formula-for-determining-if-a-worker-is-here-at-certain-times-during-the-day-sample-spreadsheet
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
In | Out | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00
05:50:00 | 14:35:00
05:52:00 | 14:30:00
05:52:00 | 14:31:00
05:52:00 | 15:30:00
05:53:00 | 14:30:00
06:17:00 | 19:30:00
06:19:00 | 19:30:00
06:24:00 | 19:32:00
06:26:00 | 19:31:00
06:30:00 | 19:30:00
13:37:00 | 22:30:00
13:38:00 | 22:30:00
13:39:00 | 22:30:00
13:40:00 | 22:30:00
13:40:00 | 22:30:00
18:29:00 | 07:30:00
18:29:00 | 07:31:00
18:29:00 | 07:31:00
18:29:00 | 07:31:00
18:29:00 | 07:31:00
Spreadsheet: 635516d1564764609-calendar-wont-populate-from-list-fill-in-student-calendar2
Sheet: Calendar Items

Date | Name |  |  | 2019-01-01 00:00:00
2019-04-02 00:00:00 | Intro to IMPACT & Technology Skills |  |  | 2019-02-01 00:00:00
2019-04-07 00:00:00 | adf |  |  | 2019-03-01 00:00:00
 |  |  |  | 2019-04-01 00:00:00
 |  |  |  | 2019-05-01 00:00:00
 |  |  |  | 2019-06-01 00:00:00
 |  |  |  | 2019-07-01 00:00:00
 |  |  |  | 2019-08-01 00:00:00
 |  |  |  | 2019-09-01 00:00:00
 |  |  |  | 2019-10-01 00:00:00
 |  |  |  | 2019-11-01 00:00:00
 |  |  |  | 2019-12-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-02-01 00:00:00
 |  |  |  | 2020-03-01 00:00:00
Spreadsheet: 717098d1612472299-what-if-data-table-problem-help
Sheet: Two-way - 2

 | Heritage Bakery and [NAME]
 | Data | Amount
 | Fixed Cost | 15750
 | Selling price per pound | 10
 | Variable cost per pound | 2.5
 | Net profit per pound
 |  |  |  |  |  |  | Variable cost per pound |  |  |  |  |  |  |  |  |  | Amount | Per Pound | Pounds
 | Number of days | 84 |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | Sales |  | 10.5 | 2100
 | Maximum pounds produced per day | 25 |  |  | Selling price per pound | 8 |  | 3150 | 2100 | 1050 | 0 | -1050 |  |  |  | VC |  | 1.5 | 2100
 | Selling price per pound | 10 |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050 |  |  |  | FC
 | Selling amount (lb) |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050 |  |  |  | Net Profit
 |  |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Total Revenue |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Variable Cost |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Fixed Cost |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Total Cost |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Net Profit |  |  |  |  |  | 4200 | 3150 | 2100 | 1050 | 0 | -1050
 | Breakeven point =
 | Days needed to reach breakeven point
Spreadsheet: 824041d1680260739-matching-two-columns-and-returning-the-third-s666-pq-matching-two-columns-and-returning-the-third-v3
Sheet: Join

Date | Type | Description | Value | Category
2023-03-01 00:00:00 |  | Before UKI T/A DIRECTLINE | -20 | wife
2023-03-01 00:00:00 |  | Text before UKI T/A DIRECTLINE and after | -10 | wife
2023-03-02 00:00:00 |  | Savings Account | -50 | To Savings
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -40 | wife
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE After | -30 | wife
2023-03-03 00:00:00 |  | SAVINGS ACCOUNT | 60 | To Savings
2023-03-04 00:00:00 |  | before BRITISH GAS after | -89999 | Energy
2023-03-05 00:00:00 |  | WATER | -150 | Energy
2023-03-09 00:00:00 |  | 09MAR23 CD , TESCO STORES 2167, | 12.45 | Food
2023-03-10 00:00:00 |  | CD , TESCO STORES 1234 | 14.2 | Food
2023-03-16 00:00:00 |  | 16MAR23 , AMZNMKTPLACE, AMAZON.CO.UK | 22.22 | Amazon
2023-03-18 00:00:00 |  | 18MAR23 CD , SAINSBURYS S/MKTS , LONDON | 13.2 | Food
Spreadsheet: 780b61d9-484b-46e0-9c09-f21607e1ec1c
Sheet: adults

a concannon | 868351145
[NAME] | 872456183
[NAME] | 863479104
 |  | 11
 |  | 13
 |  | 14 |  |  |  | 6pm
 | [NAME] | 13 | 861052070 |  | Christine
 | [NAME] | 14 | 876736074 |  | Rita
 | Abigal Korzenskau | 14
Spreadsheet: 740677d1626450424-if-a-cell-is-blank-get-the-number-from-a-different-cell-to-use-in-the-calculation-eagle_ridge_example
Sheet: DMR's

DAILY SAMPLE RESULTS - PART B
Permit Number: | FLA014498-010-DW29 |  |  |  |  | Facility: | Eagle Ridge WWTP
Monitoring Period | From: January 1, 2021       To: January 31, 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Proofs to Totals Not to be submitted, this is only for Operations use to verify accuracy of data!
 | Chlorine, Total Residual (For Disinfection) | pH | Turbidity | Flow | Flow | Flow | Solids, Total Suspended (Influent)  mg/L | Solids, Total Suspended (Effluent)  mg/L | Coliform, Fecal  (#/100mL) | BOD, Carbonaceous 5 day, 20C (Influent) | BOD, Carbonaceous 5 day, 20C (Effluent) (mg/L) |  |  | CBOD | Chlorine TL Residual | Coliform, Fecal | pH | TSS | Turbidity | FLW-1 | FLW-2 | FLW-4
 | mg/L | s.u. | NTU | MGD | MGD | MGD |  |  |  |  |  |  |  | Proofs | Proofs | Proofs | Proofs | Proofs | Proofs | Proofs | Proofs | Proofs
Code | 50060 | 400 | 70 | 50050 | 50050 | 50050 | 530 | 530 | 74055 | 80082 | 80082 |  | Monthly
Mon. Site | EFA-1 | EFA-1 | EFB-1 | FLW-1 | FLW-2 | FLW-4 | INF-1 | EFB-1 | EFA-1 | INF-1 | EFA-1 |  | Average
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | ***If any of the above proofs are FALSE, please evaluate your data to locate the error.***
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Total
[NAME].
Spreadsheet: jeffrey_a_shankman__13925__EGM - COMPETITOR GRAPHS
Sheet: DYNEGY-ICE EGM

 | ENRON'S ACTIVITY ON OTHER EXTERNAL PLATFORMS
 | AS OF NOVEMBER 21 2001
 | Average Transactions and [NAME] for November, 2001
 | Enron's Activity on ICE
 | Enron Entity | Commodity | Deals | Volume
 | ENA | CRUDE
 | Enron's Activity on Dynegy Direct
 | Enron Entity | Commodity | Deals | Volume
 | ENA | COAL
 | EGL | NATURAL GAS LIQUIDS
 | Enron's Activity on Nymex
 | Enron Entity | Commodity | Deals | Volume
 | ENA | CRUDE | N/A
Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet: assumptions

Fort  Union Gas Gathering and Lost Creek Gas Gathering
Assumptions
Fort Union Gas Gathering |  |  |  | Lost Creek Gas Gathering
Financing |  |  |  | Financing
Term Loan Amount | 36511784.85 |  |  | [NAME] | 61906000
Agent's Fee | 20000 |  |  | Capitalized Interest & Fees
LIBOR (fixed) | 0.0599 |  |  | Total project cost | 65843408.797354
Term Loan margin Closing - 12/30/99 | 0.01 |  |  | Non-recourse | 0.85
Term Loan margin 12/30/99 - 12/30/01 | 0.01125 |  |  | Term Loan
Term Loan margin 12/30/01 - 12/30/03 | 0.0125 |  |  | Agent's Fee yrs 1-10 | 20000
Term Loan margin 12/30/03 - 12/30/05 | 0.01375 |  |  | LIBOR (fixed) | 0.06609
Term Loan margin 12/30/05 - 12/30/07 | 0.015 |  |  | Term Loan margin Year 1-2 | 0.01125
Term Loan margin 12/30/07 - 12/30/09 | 0.0175 |  |  | Term Loan margin Year 3-4 | 0.0125
Expansion Cost to 700 MMcfd (1/3,2/3 option) | 22000000 |  |  | Term Loan margin Year 5-6 | 0.01375
Leverage % | 0.85 |  |  | Term Loan margin Year 7-8 | 0.015
Increase in Term Loan for Expansion |  |  |  | Term Loan margin Year 9-10
Annual FUGG Debt Service (starting in Q1 '01) | 2157770 |  |  | Total Equity Contribution
ENA Ownership Percentage | 0.3333 |  |  | Equity contributed prior to funding | 9876511.3196031
Operational |  |  |  | ENA Ownership Percentage | 0.35
ECT Fixed Gathering Fee / Day | 14000 |  |  | Expansion Capex | 0
CMS Fixed Gathering Fee / Day | 14000 |  |  | Operational
WGW Fixed Gathering Fee / Day | 14000 |  |  | Demand Rate | 0.14
Incremental Rate |  |  |  | Annual O&M Expense | 1410270
Firm Capacity | 300000 |  |  | O&M Escalator | 0
ENA Capacity | 100000 |  |  | Ad Valorem Tax
Day 1 Throughput | 25000 |  |  | Minimum Cash Balance | 1000000
FUGG Capacity after Expansion (Mcfd) | 700000 |  |  | [NAME] (MCFD) | 275000
Annual O&M Expense (prior to expansion) | 1156718 |  |  | Does BR Participate in Expansion? (1=yes,0=no) | 0
Incremental Annual Expansion O&M | 1500000 |  |  | Incremental Expansion  O&M | 0.01
O&M Annual Escalator | 0 |  |  | NCOC
Annual G&A | 784648 |  |  | NCOC Rate ($/Mcf) | 0.14
G&A Annual Escalator | 0 |  |  | NCOC Participation % | 0.25
Accounts Receivable Turnover | 11 |  |  | Incremental Windfall O&M per NCOC contract | 0.1
Accounts Payable Turnover | 11 |  |  | Incremental Expansion O&M per NCOC contract | 0.1
Cash Reserve before 2001 | 1250000
Cash Reserve after 2001 | 250000
Discount Rate | 0.12
Combined Valuation of both assets
Spreadsheet: 764397d1642708363-compare-two-tables-find-matches-and-extract-rows-based-on-matches-cf-and-create-new-lists-for-mwa-schools
Sheet: on other list

TABLE 1 |  |  | TABLE 2 |  |  | NEW TABLE 1 |  |  | NEW TABLE 2
Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun
76026322 | Kiruna |  | 76026322 | Kiruna
44673074 | Stockholm |  | 44673074 | Stockholm
99648792 | Stockholm |  | 99648792 | Stockholm
22335099 | Knivsta |  | 22335099 | Knivsta
47684564 | Örebro |  | 47684564 | Örebro
15561397 | [NAME] |  | 15561397 | [NAME]
71387206 | Ale |  | 71387206 | Ale
41408780 | Nacka |  | 41408780 | Nacka
10715898 | Österåker |  | 37796564 | Stockholm
48184058 | Vallentuna |  | 10715898 | Österåker
28145722 | Vallentuna |  | 48184058 | Vallentuna |  |  |  | << proof |  |  | << proof
59092675 | Timrå |  | 56528690 | [NAME] | << swapped to prove working
90711097 | Stockholm |  | 59092675 | Timrå
84230115 | Hultsfred |  | 90711097 | Stockholm
27323097 | Solna |  | 84230115 | Hultsfred
85416841 | Jönköping |  | 27323097 | Solna
92304123 | Ovanåker |  | 85416841 | Jönköping
65024773 | Bollnäs |  | 92304123 | Ovanåker
82838118 | Stockholm |  | 65024773 | Bollnäs
60217642 | Skurup |  | 82838118 | Stockholm
45270097 | Vara |  | 60217642 | Skurup
56528690 | [NAME] |  | 45270097 | Vara |  |  |  | << proof |  |  | << proof
51403955 | Lerum |  | 28145722 | Vallentuna | << swapped to prove working
 |  |  |  |  | <<
Spreadsheet: 680770d1591190762-if-statement-formula-based-on-condition-otherwise-enter-manually-time-sheet
Sheet: Sheet1

 | Company Name
 | Weekly Time and Reimbursement Report
 | Name: |  | Surname, Firstname MI.
 | Client Name: |  | [NAME]
 | Charge Code:
 | Client's Time:
 | Date |  | Work Hours |  |  |  |  |  |  | Out-of-Pocket Expenses (OPEs) |  |  |  |  |  |  |  |  | Approval/ Remarks
 |  |  | Time In | Time Out | Regular Hours | Chargeable Hours (+ OT) | Non-chargeable Hours | Authorized OT Hours |  | Regular |  |  |  |  | Overtime
 |  |  |  |  |  |  |  |  |  | Excess Fare |  |  |  | Others | Meals | Transportation | Others
 | 2020-05-11 00:00:00 |  | 07:40:00 | 16:40:00 | 08:00:00
 | 2020-05-12 00:00:00 |  | 07:47:00 | 19:32:00 | 08:00:00
 | 2020-05-13 00:00:00 |  | 07:30:00 | 18:10:00 | 08:00:00
 | 2020-05-14 00:00:00 |  | 07:06:00 | 16:06:00 | 08:00:00
 | 2020-05-15 00:00:00 |  | 07:30:00 | 16:30:00 | 08:00:00
 | 2020-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
 | 2020-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday
 | Total Regular Hours
 | Total Chargeable Hours
 | Total Non-chargeable Hours
 | Total Authorized Overtime
 | Total
 | Total OPEs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Regular Hrs | OT | Total Chargeable Hrs
 | Prepared by: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time report/ overtime checked and approved by:
Spreadsheet: 013099c0-71bb-4a5e-b72d-2436d999e953
Sheet: FY03 Figures 1,2,4

Figure 1 |  |  |  |  |  |  |  | Figure 2
Connecticut     (2002-03) | Statewide |  | Bridgeport |  | New Haven |  |  |  | District | Charter | Difference
Per-Pupil Revenue |  |  |  |  |  |  |  | State
District
Charter
Difference
Per-Pupil Revenue by Source | District | Charter | District | Charter | District | Charter
Federal
State
Local
Other
Indeterminate
Total
Enrollment
District
Charter
Number of Charters | 12 |  | 1 |  | 2
Total Revenue
District
Charter
Total |  |  |  |  |  |  |  | Figure 4
Percentage of Revenue by Source | District | Charter | District | Charter | District | Charter |  |  | Federal | State | Local | Other | Indeterminate
Federal |  |  |  |  |  |  |  | Statewide District
State |  |  |  |  |  |  |  | Statewide Charter
Local |  |  |  |  |  |  |  | Bridgeport  District
Other |  |  |  |  |  |  |  | Bridgeport Charter
Indeterminate |  |  |  |  |  |  |  | New Haven District
Change in district school funding if subjected to charter funding structure |  |  |  |  |  |  |  | New Haven Charter
 | ($146.2 million) |  | ($33.9 million) |  | ($49.7 million)
Spreadsheet: daren_farmer__5527__HPLN1017
Sheet: Sheet1

HPLN1017.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 17, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-17 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  |  | 0 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 29b7b6d7-4a47-4bc6-b314-5b7bb1606550
Sheet: Sheet1

ANON# | RANK
565364 | 6
565365 | 11
565366 | 14
565373 | 28
565374 | 23
565375 | 8
565394 | 17
565395 | 1
565397 | 15
565398 | 19
565409 | 2
565412 | 21
565418 | 20
565425 | 9
565427 | 12
565438 | 30
565440 | 5
565442 | 10
565447 | 13
565451 | 16
565457 | 28
565460 | 24
565462 | 31
565468 | 18
565469 | 27
565471 | 25
565472 | 4
565480 | 31
565481 | 22
565486 | 7
565519 | 3
565526 | 25
Spreadsheet: 817369d1676176614-separating-address-in-one-cell-no-delimiters-and-there-are-cities-with-multiple-words-ams-pq-split
Sheet: Sheet1

Column1 |  | Column1.1.1.1 | Column1.1.1.2 | Column1.1.2 | Column1.2
13804 N MARTIN WAY MEQUON WI 53097 |  | 13804 N MARTIN WAY | MEQUON | WI | 53097
245 GRANDVILLE RD CEDARBURG WI 53012 |  | 245 GRANDVILLE RD | CEDARBURG | WI | 53012
101 E GRAND AVE STE 6 PORT WASHINGTON WI 53074 |  | 101 E GRAND AVE STE 6 PORT | WASHINGTON | WI | 53074
101 E GRAND AVE PORT WASHINGTON WI 53074 |  | 101 E GRAND AVE PORT | WASHINGTON | WI | 53074
1640 W PIERCE AVENUE CHICAGO IL 60622 |  | 1640 W PIERCE AVENUE | CHICAGO | IL | 60622
1360 WILLOW ROAD FREDONIA WI 53021 |  | 1360 WILLOW ROAD | FREDONIA | WI | 53021
1041 HORNS CORNERS ROAD CEDARBURG WI 53012 |  | 1041 HORNS CORNERS ROAD | CEDARBURG | WI | 53012
P O BOX 240521 MILWAUKEE WI 53224 |  | P O BOX 240521 | MILWAUKEE | WI | 53224
Spreadsheet: 05da84be-aea9-4a7e-ba74-1ede5ac991f8
Sheet: Sheet1

STATE OF NEW HAMPSHIRE | Unnamed: 1
Executive Council - District No. 1 Republican
2010-09-14 00:00:00 | [NAME]
Albany | 67
[NAME] | 201
Alton | 748
Ashland | 217
Atkinson & Gilmanton Academy Gt | 0
[NAME] | 361
Bath | 127
Bean's Grant | 0
Bean's Purchase | 0
Belmont | 562
[NAME] | 45
[NAME] | 115
[NAME] | 115
[NAME] 3 | 211
[NAME] 4 | 94
Bethlehem | 177
Bridgewater | 134
Bristol | 366
Cambridge | 1
Campton | 307
Canaan | 226
Carroll | 81
Center Harbor | 193
[NAME]'s Purchase | 0
Charlestown | 250
Chatham | 25
Claremont Ward 1 | 181
Claremont Ward 2 | 320
Claremont Ward 3 | 215
[NAME] | 35
Colebrook | 215
Columbia | 70
Conway | 744
Cornish | 126
Crawford's Purchase | 0
Croydon | 91
Cutt's Grant | 0
[NAME] | 83
Dix's Grant | 0
Dixville | 4
Dorchester | 36
Dummer | 35
Easton | 37
Eaton | 61
[NAME] | 135
Ellsworth | 15
Enfield | 278
Errol | 44
Erving's Location | 0
Franconia | 147
Freedom | 238
Gilford | 967
[NAME] | 193
[NAME] | 116
Grantham | 309
Green's Grant | 0
[NAME] | 67
Hadley's Purchase | 0
Hale's Location | 53
Hanover | 326
Hart's Location | 3
Haverhill | 452
Hebron | 118
Holderness | 279
[NAME] | 134
[NAME] | 144
Kilkenny | 0
[NAME] | 348
[NAME] | 223
[NAME] 3 | 287
[NAME] | 241
[NAME] | 158
[NAME] 6 | 329
Lancaster | 325
Landaff | 45
Lebanon Ward 1 | 209
Lebanon Ward 2 | 209
Lebanon Ward 3 | 247
Lincoln | 133
Lisbon | 117
Littleton | 542
Livermore | 0
Low & Burbank's Grant | 0
[NAME] | 48
Lyme | 104
[NAME] | 273
Martins' Location | 0
Meredith | 1007
Milan | 132
[NAME] | 8
Monroe | 106
Moultonborough | 818
New Hampton | 287
Newport | 460
Northumberland | 123
[NAME] | 0
Orange | 27
Orford | 136
Ossipee | 502
Piermont | 61
[NAME]'s Grant | 0
Pittsburg | 95
Plainfield | 137
Plymouth | 357
Randolph | 36
Rumney | 210
Sanbornton | 325
Sandwich | 217
Sargent's Purchase | 0
Second College Grant | 0
Shelburne | 41
Springfield | 138
[NAME] | 43
Stewartstown | 68
[NAME] | 39
Success | 0
[NAME] | 81
Sunapee | 417
Tamworth | 258
Thompson & Meserve's Purchase | 0
[NAME] | 231
[NAME] | 281
Tuftonboro | 414
Wakefield | 533
[NAME] | 140
Waterville Valley | 31
Wentworth | 124
Wentworth's Location | 4
[NAME] | 191
Wolfeboro | 1046
Woodstock | 133
Totals | 23989
Spreadsheet: 758611d1638971231-excel-fprmula-for-monthly-and-year-to-date-profit-and-loss-profit-and-loss
Sheet: Sheet1

Kindly asking for excel formula to produce monthly and year to date profit and loss as shown in the desired outcome.
Date | Name | Revenue | Expenses | Financial Category |  | Desired outcome
2021-01-11 00:00:00 | OK | 3000 |  | Sales |  | Statement of Profit and Loss
2021-01-21 00:00:00 | [NAME] |  | 1500 | Rentals |  |  |  | 2021-04-01 00:00:00 | YTD
2021-01-25 00:00:00 | TV | 4000 |  | Sales |  | Revenue
1900-01-30 00:00:00 | Fawcetty |  | 2000 | Security |  | Sales |  | 11000 | 36000
2021-01-30 00:00:00 | TM |  | 200 | Purchases |  | Expenses
2021-02-01 00:00:00 | OK | 5000 |  | Sales |  | Rentals |  | 2000
2021-02-02 00:00:00 | [NAME] |  | 2000 | Rentals |  | Security |  | 2500
2021-02-25 00:00:00 | TV | 6000 |  | Sales |  | Purchases |  | 3000
2021-02-25 00:00:00 | Fawcetty |  | 2500 | Security |  | Total Expenses
30/02/2021 | TM |  | 3000 | Purchases |  | Profit
2021-03-11 00:00:00 | OK | 3000 |  | Sales
2021-03-21 00:00:00 | [NAME] |  | 1500 | Rentals
2021-03-25 00:00:00 | TV | 4000 |  | Sales
1900-03-30 00:00:00 | Fawcetty |  | 2000 | Security
2021-03-30 00:00:00 | TM |  | 200 | Purchases
2021-04-01 00:00:00 | OK | 5000 |  | Sales
2021-04-02 00:00:00 | [NAME] |  | 2000 | Rentals
2021-04-25 00:00:00 | TV | 6000 |  | Sales
2021-04-25 00:00:00 | Fawcetty |  | 2500 | Security
2021-04-30 00:00:00 | TM |  | 3000 | Purchases
Spreadsheet: 593544d1539197872-correct-way-of-linking-data-to-master-workbook-test-sheet
Sheet: Protein Granola (3)

Recipe | Ingredients | Quantity | Measurement | Macros for Entire Recipe
 |  |  |  | Cals | P | F | C
Protein Granola | Oats | 1.6 | /100g
 | vanilla whey protein powder | 0.5 | /100g
 | coconut oil | 0.5 | /100g
 | maple syrup | 0.3 | /100ml
 | apple juice | 0.9 | /100ml
 | mixed nuts & seeds | 1.5 | /100g
 | dessicated coconut | 0.1 | /100g
 | Total - Entire Recipe
 | No. Of Servings | 8
 | Per Serving
 | Check
 | Rounded |  |  | 370 | 11 | 27 | 19
Spreadsheet: 835450d1688585477-cant-do-a-simple-addition-2019-mock-marksheet
Sheet: 2019 Speaking

 |  | Foundation |  |  |  |  |  | Higher
Name | Class | RP | Photo | Conversation | Total | Grade |  | RP | Photo | Conversation | Total | Grade
 |  | 5 | 2 | 8
 |  | 6 | 10 | 9
 |  | 9 | 8 | 15
 |  | 6 | 10 | 20
 |  | 8 | 10 | 13
 |  | 12 | 10 | 18
 |  | 15 | 12 | 26
 |  | 0 | 0 | 7
 |  | 12 | 13 | 11
 |  | 15 | 15 | 21
 |  | 10 | 12 | 15
Spreadsheet: 160476d1339090903-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: Compliance

Announcement Number | Employee Announcements
Compliance1
compliance2
compliance3
compliance4
compliance5
[NAME]
Announcement Number | Manager [NAME]
Compliance1manager
Compliance2manager
Compliance3manager
Spreadsheet: 196510d1354028806-a-simple-but-challenging-exercise-find-the-top-and-bottom-names-with-duplicates-how-to-find-the-names-of-the-top-7-and-bottom-7-ranks-with-duplicates
Sheet: Sheet1

Name | Rank |  | Top 7 | Name | Bottom 7 | Name
[NAME] | 1 |  | 1
[NAME] | 2 |  | 2
[NAME] | 2 |  | 3
Lily | 4 |  | 4
[NAME] | 5 |  | 5
[NAME] | 6 |  | 6
[NAME] | 6 |  | 7
[NAME] | 6
[NAME] | 9
Richards | 10
[NAME] | 10
Kelly | 12
[NAME] | 13
[NAME] | 14
[NAME] | 14
[NAME] | 16
[NAME] | 17
[NAME] | 17
[NAME] | 17
Mat | 20
Spreadsheet: 114942d1310603417-count-unique-text-values-in-range-with-criteria-countuniquehelp
Sheet: Sheet1

Name One | Name Two | Name Three | Name Four | Unit | Year |  | Name One | Name Two | Name Three | Name Four | Unit | Year
A | B |  |  | Red | 2008 |  | 1 | 2 |  |  | Red | 2008
B | C | A | D | Red | 2009 |  | 2 | 3 | 1 | 4 | Red | 2009
C | A |  |  | Red | 2009 |  | 3 | 1 |  |  | Red | 2009
A | D |  |  | Red | 2009 |  | 1 | 4 |  |  | Red | 2009
B | C |  |  | Red | 2009 |  | 2 | 3 |  |  | Red | 2009
B |  |  |  | Blue | 2008 |  | 2 |  |  |  | Blue | 2008
B | D |  |  | Blue | 2009 |  | 2 | 4 |  |  | Blue | 2009
A |  |  |  | Blue | 2009 |  | 1 |  |  |  | Blue | 2009
X |  |  |  | Blue | 2009 |  | 6 |  |  |  | Blue | 2009
C | D |  |  | Blue | 2009 |  | 3 | 4 |  |  | Blue | 2009
2009
 |  | Using Letters: |  | Trying number approach on text: |  |  | Using numbers:
 | [NAME]: |  | doesn’t work because of match on an range that is larger than one column?? |  |  | doesn’t work because of frequency |  | works because it's numbers, but I have text
 | Want: | 5
 |  | Using only first row:
 | [NAME]: |  | Works because we are only curious about 1st column
 | Want: | 4