tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 822913d1679589500-need-help-with-finance-formula-in-excel-finance-formula-help
Sheet: Sheet1

 |  | Interest Rate | 0.03
 |  | Amortization Period (# of months) | 360
 |  | Loan Amount | 1200000
 |  | Annual Debt Service****
 |  | Monthly Payment (Annual Debt Service / 12)
 |  | **** Used formula to calculate | =12*(PMT ([NAME], D6,-D7, 0))
 |  | Interest Rate | 0.03
 |  | Amortization Period (# of months) | 360
 |  | Annual Debt Service | 60710.98085704086
 |  | Monthly Payment (Annual Debt Service / 12) | 5059.248404753405
 |  | Loan Amount
Spreadsheet: 746958d1631132638-if-or-isnumber-search-excel-if-or-isnumber-search-query-bvj-
Sheet: Sheet1

 | Orange | [NAME] | Apple | Avocado |  | testing
2021-09-06 00:00:00 |  | off | AMUx-GRHy | 0900-2130 GRHx
2021-09-07 00:00:00 | off | GRHx | OFF
2021-09-08 00:00:00 | Study leave | AMU | Study leave | 0900-2130 GRHx
2021-09-09 00:00:00 | off | SPA | GRHx
Spreadsheet: 876994d1723696866-large-data-base-with-info-on-separate-rows-need-to-combine-excel-sample
Sheet: Sheet1

# | Call No | Call Create Date | Priority | Type
1 | P190010345 | 2019-01-01 05:42:57 | 3 | 2B - BUSN | 1
 |  |  |  | ALARM PD |  |  |  |  |  |  |  |  |  |  |  |  | P190011226 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P190011270 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P190020216 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P190020631 | 23
 | P190011226 | 2019-01-01 22:13:15 | 6 | 22 - AREA
 |  |  |  | CHECK
 | P190011270 | 2019-01-01 23:03:00 | 3 | 54V -
 |  |  |  | SUSPICIOUS
 |  |  |  | VEH
 | P190020216 | 2019-01-02 04:21:47 | 3 | 2B - BUSN
 |  |  |  | ALARM PD
 | P190020631 | 2019-01-02 11:00:01 | 6 | 22 - AREA
 |  |  |  | CHECK
Spreadsheet: 766299d1643832601-separating-unformatted-time-column-into-days-hours-minutes-seconds-2022-02-02-duration-time
Sheet: Sheet1

 | Duration | Deliniated by Space
A | 5h 51m 23s | 5h | 51m | 23s
C | 6m 10s | 6m | 10s
D | 52m [NAME] | 52m | 00s
E | 1h 5m 59s | 1h | 5m | 59s
F | 58m 12s | 58m | 12s
G | 52m 50s | 52m | 50s
H | 1h 5m 55s | 1h | 5m | 55s
I | 54m [NAME] | 54m | 00s
J | 1h 5m 31s | 1h | 5m | 31s
K | 48m 39s | 48m | 39s
M | 1h 26m 59s | 1h | 26m | 59s
N | 54m 50s | 54m | 50s
O | 58m 20s | 58m | 20s
P | 57m 59s | 57m | 59s
Q | 58m 10s | 58m | 10s
R | 54m [NAME] | 54m | 00s
S | 1h 00m [NAME] | 1h | 00m | 00s
T | 50m 29s | 50m | 29s
U | 1h 23m 41s | 1h | 23m | 41s
V | 1h 1m 59s | 1h | 1m | 59s
W | 1h 10m 30s | 1h | 10m | 30s
X | 1h 4m 29s | 1h | 4m | 29s
Y | 121d 10h 38m | 121d | 10h | 38m
Spreadsheet: 273445d1382714405-max-if-statement-not-working-across-multiple-sheets-yearly-results
Sheet: Scoring Records

Team | Most Scored at Home | Most Scored on Road | Least Scored at Home | Least Scored on Road | Most Against at Home | Most Against on Road | Least Against at Home | Least Against on Road
Alaska
Atlantic City
Baltimore
Birmingham
British Columbia
[NAME]
Calgary
Chicago
Colorado
Columbus
Corpus Christi
Costa Rica
Ft. Lauderdale
Houston
Idaho
Iowa
Kansas City
Las Vegas
Los Angeles
Montreal
New Orleans
Ohio
Orlando
Pennsylvania
Portland
Puerto Rico
Richmond
San Francisco
Savannah
Seattle
Springfield
St. Louis
Syracuse
Trinidad
Tucson
Vancouver
Washington
West Texas
Spreadsheet: 0160301b-c502-49f1-9562-834ed0b33d01
Sheet: WFIS Data

 | U.S. Department of Energy Report of Contractor Expenditures for Employee Supplemental Compensation
 | DoE Summary for Calendar Year 2009
OP Office: |  |  | Sample Operations Office
Facility: |  |  | Sample Facility
Contractor: |  |  | Sample Contractor
Contract Number:
 |  |  | No. of Employees
Exempt: |  |  | 800
Bargaining Unit: |  |  | 500
Nonexempt Nonbargaining Unit: |  |  | 100
Retiree: |  |  | 600
Types of Expenditure |  |  | Total
Gross Payroll |  |  | 100000000
Annual Base Pay |  |  | 94000000
Straight-Time Pay Worked: |  |  | 80000000
Paid-Time off: |  |  | 14000000
Vacation Pay |  |  | 7000000
Vacation Pay in Lieu: |  |  | 0
Holiday Pay: |  |  | 4000000
Holiday Pay in Lieu: |  |  | 0
Sick Leave Pay: |  |  | 2000000
Personal Leave Bank: |  |  | 1000000
Personal Leave Pay: |  |  | 0
Parental Leave: |  |  | 0
Supplemental Pay: |  |  | 0
Other Paid Leave Pay: |  |  | 0
Overtime Pay: |  |  | 3000000
Straight Time Portion: |  |  | 2000000
Premium Portion: |  |  | 1000000
Severance Pay: |  |  | 0
Other Pay: |  |  | 3000000
Shift Differential: |  |  | 500000
Lump Sum Payment: |  |  | 0
Performance Incentive Compensation: |  |  | 2500000
Cash Award: |  |  | 0
Non Performance-Based Bonuses: |  |  | 0
Facility Closing Retention Bonus: |  |  | 0
Voluntary Separation Bonus: |  |  | 0
Relocation/Housing Allowance-Direct: |  |  | 0
Relocation/Housing Allowance-Other: |  |  | 0
Remote/Isolation Pay: |  |  | 0
Hazard Duty Pay: |  |  | 0
Expatriate Allowance: |  |  | 0
Education Allowance-Pay: |  |  | 0
Other Overtime Payment: |  |  | 0
Geographic Differential Pay: |  |  | 0
Dependent Care: |  |  | 0
Misc. Compensation: |  |  | 0
Legally Required Insurance: |  |  | 8700000
Social Security: |  |  | 7000000
Other Retirement Insurance: |  |  | 0
Unemployment: |  |  | 400000
Unemployment - Federal: |  |  | 0
Unemployment - State: |  |  | 400000
Occupational Injury & Illness: |  |  | 600000
State Workman's Compensation: |  |  | 600000
Benefits Under EEOICPA - Subtitle D: |  |  | 0
Other Legacy Benefits / Health Studies: |  |  | 0
Other Legally Required Insurance: |  |  | 0
Life/Death Benefits: |  |  | 500000
Life Insurance: |  |  | 500000
Death Benefits: |  |  | 0
Medical/Medically Related: |  |  | 18300000
Insured Active Medical: |  |  | 6000000
Self-Insured Active Medical: |  |  | 2000000
Dental Active: |  |  | 700000
Vision/Prescription-Active: |  |  | 1000000
Misc. Medical-Active: |  |  | 300000
Insured Retiree Medical: |  |  | 800000
Self-Insured Retiree Medical: |  |  | 300000
Dental-Retiree: |  |  | 0
Vision/Prescription-Retiree: |  |  | 200000
Misc. Medical-Retiree: |  |  | 200000
Short-Term Disability: |  |  | 250000
Long-Term Disability: |  |  | 250000
Displaced Worker: |  |  | 0
Retirement: |  |  | 16000000
Defined Contribution: |  |  | 6000000
Savings/Thrift Plan: |  |  | 0
Defined Benefits: |  |  | 10000000
Disbursments: |  |  | 0
Expenses: |  |  | 0
Other: |  |  | 0
Vacation/Holiday Funds: |  |  | 0
Dependent Care: |  |  | 0
Employee Assistance Program: |  |  | 0
Misc. Benefits: |  |  | 0
TOTAL BENEFITS |  |  | 60000000
TOTAL COMPENSATION |  |  | 143500000
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q1FY13

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended June 3, 2012
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Certain non-recurring litigation expenses | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 955 |  | 0 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 491
Cost of revenue | 205 |  | -15 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -1 |  | 0 |  | 189
Gross profit | 750 |  | 15 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 302
Operating expenses:
Marketing and sales | 145 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -7 |  | 0 |  | 138
General and administrative | 86 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 77
Research and development | 290 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 268
Acquisition-related contingent consideration | -20 |  | 20 |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 7 |  | -7 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 27 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -27 |  | 0 |  | 0 |  | -
Total operating expenses | 535 |  | 13 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -27 |  | -38 |  | 0 |  | 483
Operating income (loss) | 215 |  | 2 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 0 |  | -181
Interest and other expense, net | -5 |  | 0 |  | 5 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for (benefit from) income taxes | 210 |  | 2 |  | 5 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 0 |  | -181
Provision for (benefit from) income taxes | 9 |  | 0 |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 |  | 0 |  | -60 |  | -51
Net income (loss) | 201 |  | 2 |  | 5 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 60 |  | -130
Earnings per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loss per share
Basic | 0.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | -0.41
Diluted | 0.63
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 317 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | 317
Diluted | 320
Spreadsheet: 127054d1320151814-lookup-and-match-formula-help-needed-test
Sheet: Weekly Planner

Time | Monday | Tuesday | Wednesday | Thursday | Friday |  | Monday | Tuesday | Wednesday | Thursday | Friday |  | Monday | Tuesday | Wednesday | Thursday | Friday |  | Monday | Tuesday | Wednesday | Thursday | Friday
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
Spreadsheet: 212356d1360101033-autopoulate-a-workbook-from-another-workbook-book-a
Sheet: Sheet1

Other ID | # | Name | Title | Date | Type e | Type f | Area | Description | Who to Solve | Date Completed
1 | 1001 | Person A | Operator | 2011-10-21 00:00:00 |  | X | 3 |  | Operator | 2011-10-25 00:00:00
2 | 1002 | Person B | Operator | 2011-10-21 00:00:00 |  | X | 3 |  | Maintenance | 2011-11-08 00:00:00
3 | 1003 | Person B | Operator | 2011-10-21 00:00:00 | X |  | 3 |  | Operator | 2012-03-21 00:00:00
Spreadsheet: 178190d1346692914-setting-cell-content-names-according-to-vales-in-another-cell-selected-from-drop-down-list-universal-train-cleaning-audit-form
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Unit | Clean
 | Clean | Standard |  |  | Unit | 50 |  |  |  | 44 | Standard
 |  |  |  |  |  |  |  |  |  | 50 | TA
 | Item | [NAME] |  | Score |  |  |  |  |  | 55
 | Pick | 2 |  | 1 |  |  |  |  |  | 58
 | [NAME] | 2 |  | 2
 | < [NAME] | 2 |  | 2
 | Lights | 1 |  | 0
 | Score
Spreadsheet: 265480d1379290591-merge-a-couple-of-spreadsheets-with-common-column-field-sample
Sheet: Sheet0

[NAME] | Manufacturer IM code | Manufacturer Part Number | IM SKU | UPC | Short Description | Long Description
MCAFEE | 10000500169 | HIDYFM-AA-DA | 1000001 |  | 101-250 HIP Desktops 1Yr GL D | QTY 101 to 250 of McAfee HIP for Desktops 1Yr GL (P+) BandD
MCAFEE | 10000500169 | TEACDE-AA-GA | 1000002 |  | 1001-2000 TotProt E/Pt-Adv P:1GL G | QTY 1001 to 2000 of McAfee Total Protection for Endpoint-Adv P:1GL (P+) Band G
MCAFEE | 10000500169 | TENYFM-AA-HA | 1000004 |  | 2001-5000 TotProt E/Pt 1YrGL H | QTY 2001 to 5000 of McAfee Total Protection for Endpoint 1Yr GL (P+) Band H
MCAFEE | 10000500169 | TENCDE-DA-GA | 1000005 |  | 1001-2000 TotProt E/Pt UP P+:1YrGL G | QTY 1001 to 2000 of McAfee Total Protection for Endpoint UPGRADE P+: 1Yr GL Band G
Spreadsheet: 701459d1603778488-dynamic-chart-based-on-formula-column-dynamic-chart-on-formula
Sheet: Sheet1

Financials | TBD |  |  | RESULTS BY AUDITED SECTION
Operations | TBD
Safety | TBD
Execution | TBD
Performance | TBD
Deliverability | TBD
 |  |  |  | Expected Result
 |  |  |  | Change any cell in Column B from TBD
 |  |  |  | to a number and the grid above is updated
 |  |  |  | Only those rows with a label & number
 |  |  |  | should appear in Chart.  In this example,
 |  |  |  | Only Finicials and Execution should appear
Spreadsheet: 850963d1701262464-cf-to-highlight-duplicates-only-where-a-value-in-another-column-is-present-new-microsoft-excel-worksheet-11-cf
Sheet: Sheet1

Days | Completed
Monday | Yes
Tuesday | Yes
Wednesday
Thursday | Yes
Friday | Yes
Saturday | Yes
Sunday | Yes
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday | Yes
Tuesday | Yes
Wednesday | Yes
Thursday | Yes
Friday | Yes
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday | Yes
Friday | Yes
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Christmas | Yes
Christmas
Christmas
Spreadsheet: daren_farmer__6633__egmnom-Mar
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-03-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-03-31 00:00:00
RECEIPTS |  |  | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | ECT | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
4132 | EXXON KATY | Kn Marketing 92155 |  |  |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6780 | Oasis [NAME] | Tenaska |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
XXXX | IMBALANCE | ENTEX/HPL
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY
1373 | [NAME] | MORGAN STANLEY | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
1485 | OXY BATTLEGROUND | OXY | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
1511 | Port Arthur - Clark | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1505 | DEER PARK | DUPONT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1394 | HILL PETRO | DYNEGY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8001 | AIR LIQUIDE | AIR LIQUIDE
XXXX | IMBALANCE | ENTEX/HPL
 |  | DELIVERY TOTAL
Spreadsheet: 10ef94a1-10aa-4741-a7e0-908492be1a59
Sheet: rescom

Property Tax of 4 Mills  on Residential and Commercial Property
 | Residential |  |  | Commercial
Actual Value | 200000 | 400000 |  | 200000 | 400000
Assessment Rate | 0.0796 | 0.0796 |  | 0.21 | 0.21
Assessed Value
[NAME] | 4 | 4 |  | 4 | 4
Property Tax
Statewide
4 mills = | 350 Million
6 mills = | 525 Million
8 mills= | 700 Million
Metro Tax | Assessed Value | 4 Mills
Adams | 4663107410
Arapahoe | 7737071230
Boulder | 5620401630
[NAME] | 1065139700
Denver | 10863244130
[NAME] | 4678184640
[NAME] | 7356400430
Total
Spreadsheet: 824355d1680517620-multiple-options-in-one-column-h-and-s-training-record-20230104
Sheet: RA's 2023

 | Risk Assessments
Item: | RA1a | RA1b | RA2 | RA3 | RA4 | RA5a | RA5b | RA6 | RA7 | RA8 | RA9 | RA10 | [NAME] | RA12 | RA13a | RA13b | RA13c | RA14 | RA15 | RA16 | RA17a | RA17b | RA18a | RA18b | RA18c | RA19a | RA19b | RA19c | RA20a | RA20b | RA21 | RA22a | RA22b | RA22c | RA23a | RA23b | RA24 | RA25 | RA26 | RA27a | RA27b | RA28 | RA29 | RA30
Version
 | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date
Employee name
Angell, Nick
Aslin, [NAME]
[NAME]
Baum, Niall
Bellshaw, Russel
Bentall, [NAME]
[NAME]
Booth, Louis
Botting, [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME], [NAME]
Chaperon, [NAME]
Chapman, [NAME]
Childs, Nigel
Coller Derek
[NAME], [NAME]
Cummings, Julie
Deksnys, Ramutis
Edwards, George
Harkess, [NAME]
Hearst, [NAME]
Howkins, [NAME]
Hughes, [NAME]
Glover, [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME]
Lightfoot, [NAME]
Mallison, [NAME]
McDonald, [NAME]
McLeavy, [NAME]
[NAME], [NAME]
Moore, [NAME]
[NAME], [NAME]
O'Callaghan, [NAME]
O'Connell, [NAME]
Page-Winn, [NAME]
Parnell, [NAME]
Parnell, [NAME]
Parnell, [NAME]
Pawley, [NAME]
Pink, [NAME]
Read, Adrian
Reaney, Zach
Simms, [NAME]
Simons, [NAME]
Skillen, [NAME]
Steers, [NAME]
Sutton, [NAME]
[NAME], [NAME]
Thompson, Scott
Till, [NAME]
Wakelin, [NAME]
Warner, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Wight, [NAME]
[NAME], [NAME]
Wilson, [NAME]
Windsor, [NAME]
[NAME]
Yare, [NAME]
Spreadsheet: 74105d1274709684-calculate-for-data-in-cell-x-based-on-criteria-for-cell-y-question-calculate-average
Sheet: Sheet1

[NAME] | JANITOR | 25000
BOB | ASSISTANT MANAGER | 50000
CHRISTON | MANAGER | 60000
CLINT | JANITOR | 24000
[NAME] | JANITOR | 26800
[NAME] | WAITER | 21500
FRANCO | WAITER | 20000
JENNY | WAITER | 22000
[NAME] | ASSISTANT MANAGER | 51000
JUSTIN | JANITOR | 27000
KATE | PARTY PLANNER | 32000
[NAME] | PARTY PLANNER | 31500
[NAME] | JANITOR | 23200
LOU | WAITER | 21000
SARAH | PARTY PLANNER | 30000
STEVEN | WAITER | 21500
TOMMY | WAITER | 19000
 | JANITOR | =AVERAGE OF JANITORS
 | WAITER
 | PARTY PLANNER
 | MANAGER
 | ASSISTANT MANAGER
Spreadsheet: 124619d1318512888-help-with-sumif-sumproduct-formulas-sample
Sheet: Mar

Acct | Consolidated | Location 1 | Location 2 | Location 3
supplies |  | 8 | 9 | 2
insurance |  | 3 | 6 | 10
office |  | 5 | 6 | 1
Spreadsheet: 374209d1422716350-validation-list-costingkc
Sheet: Sheet3

Margarita
 | Price per Unit | grams | Units | Price per piece (ex VAT)
Base | 0.31 | 0.31 | 1 | 0.31
Pizza Sauce | 4.21 | 0.000842 | 84 | 0.070728
Buffalo Mozzarella | 1.64 | 1.64 | 0.5 | 0.82
Basil | 1.8 | 0.018 | 0.02 | 0.00036
 |  |  | 6
 |  |  | 2
 |  |  | Total Cost | 1.201088 | ex VAT
 |  |  | Gross | 8 | incl VAT
 |  |  | GP% | 0.8198368
Spreadsheet: 837594d1690280285-loan-grace-periods-and-a-complicated-sum-function-help-file
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | ABK |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | AAIB |  |  |  |  |  |  |  |  | MED Bank
 |  |  |  |  |  |  |  |  |  | Start Date | 2023-03-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start month | 2023-04-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start Date | 2023-05-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start Date | 2023-05-01 00:00:00 |  | Flat Translation
 |  |  |  |  |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment
 |  |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees
 |  |  |  |  |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest
 |  |  |  |  |  |  |  |  |  | Annual Rate | 0.21 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.245 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.235 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.235 |  | Interest Payment
 |  |  |  |  |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total
 |  |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years
 |  |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months
 |  |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee
 |  |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment
Month | Open Bal | Interest | Principle | Total PMT | End Bal | Early Settl. |  | Month
2023-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 122034d1316576044-need-a-formula-for-what-comes-next-in-a-data-set-series-counter
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Workers: |  | Person | After | Result
 | Day 01 | Day 02 | Day 03 | Day 04 | Day 05 | Day 06 | Day 07 |  |  | [NAME] |  | [NAME] | [NAME] | 4
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
 | Calculations:
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | 1
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | 2
Spreadsheet: 826389d1681983282-adjusting-the-formula-to-write-outstanding-instead-of-n-a-number-not-avaialble
Sheet: Sheet1

 | Kindly help me to adjust the formula to write "OUTSTANDING" insteady of "#N/A" on column G5, if reference on column J is 0 or there is nothing,
 | Cash book |  |  |  |  |  |  | Bank Statement
 |  |  |  |  |  |  | [NAME]
 | Date | Description | Reference | Revenue | Expenses | Balance |  | Date | Description | Reference | Revenue | Expenses | Balance
 | Balance B/d |  | bk |  |  | 678975.0299999998 |  | 00:00:00 | 0 | bk | 0 | 0 | 655755.03
 | 2022-12-01 00:00:00 | 0 | DR1 | 0 | 8000 | 831660.3500000018 |  | 2022-12-01 00:00:00 | VPLUS01122200291 SBPOS COMMISSION | DR1 | 8000 | 0 | 871659.9
 | 2022-12-01 00:00:00 | 0 | 1629 | 0 | 13720 | 817940.3500000018 |  | 2022-12-01 00:00:00 | BD090001 [PHONE] POS PURCHASE | 1629 | 13720 | 0 | 857939.9
 | 2022-12-01 00:00:00 | 0 | 1630 | 0 | 13540 | 804400.3500000018 |  | 2022-12-01 00:00:00 | NEDX0720 [PHONE] POS |  |  |  | 899399.9
 | 2022-12-01 00:00:00 | 0 | DR2 | 0 | 545.2 | 803855.1500000019 |  | 2022-12-01 00:00:00 | IMTT | DR2 | 545.2 | 0 | 898854.7
 | 2022-12-01 00:00:00 | 0 | DR3 | 0 | 135.4 | 803719.7500000019 |  | 2022-12-01 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: | DR3 | 135.4 | 0 | 898719.3
 | 2022-12-01 00:00:00 | 0 | DR4 | 0 | 137.2 | 803582.5500000019 |  | 2022-12-01 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: | DR4 | 137.2 | 0 | 898582.1
 | 2022-12-01 00:00:00 | BHU | 15153 | 55000 | 0 | 858582.5500000019 |  | 2022-12-01 00:00:00 | 0 | 15153 | 0 | 0 | 912939.9
 | 2022-12-01 00:00:00 | 0 | DRSP1 | 40000 | 0 | 898582.5500000019 |  | 2022-12-01 00:00:00 | VPLUS01122200291 000002188 | DRSP1 | 0 | 40000 | 879659.9
 | 2022-12-02 00:00:00 | 0 | 1637 | 0 | 6719.53 | 891863.0200000019 |  | 2022-12-02 00:00:00 | SBM66263 [PHONE] POS | 0 | 0 | 0 | 1389862.57
 | 2022-12-02 00:00:00 | 0 | DR5 | 0 | 134.39 | 891728.6300000019 |  | 2022-12-02 00:00:00 | IMTT | 0 | 0 | 0 | 1389728.18
 | 2022-12-02 00:00:00 | 0 | DR6 | 0 | 100 | 891628.6300000019 |  | 2022-12-02 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: | DR6 | 100 | 0 | 1389628.18