tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880375d1728043140-counta-to-exclude-blank-cells-upload
Sheet: Sheet3

 |  | Standard Journals (Cost Accruals, Prepayments, Revenue accurals, deferrals, etc)
 |  | Adhoc Journals
 |  | IC Journals
 |  | Recharges/Demand journals
 |  | Judgement journals
 |  | [NAME] reporting/BO STEM etc.
 |  | CFIP - B/s
 |  | CFIP - P&L
 |  | Balance sheet reporting
 |  | Cash flow reporting
 |  | CFMP Report
 |  | Forecast Reporting & Walks (Forecast assumptions template/BU level Forecast/ RPT etc.)
 |  | Risks & Ops
 |  | BPC narratives
 |  | B/s Movements
 |  | Service [NAME] (SPR)
 |  | MPR
 |  | BPR
 |  | BUPR
 |  | Contract Specific Report (Please specify)
 |  | 38A Reporting
 |  | Order Book (Form 38B) Reporting
 |  | Billed & Unbilled Debtors Reporting
 |  | BPC Sign off Report
 |  | Balance Sheet Checklist
 |  | GFCM
 |  | Any other reports
 |  | Super-Critical
 |  | Critical
 |  | Non-Critical
 |  | Forecast input call with Contract Operations - Pre month end
 |  | Foreacst Analysis/working - Pre month end (incl. cash)
 |  | Forecast load in BPC - Pre month end
 |  | Forecast Analysis/working - Post month end (incl. cash)
 |  | Forecast load in BPC - Post month end
 |  | Pre-month end review call
 |  | Flash call
 |  | B/s Month end call
 |  | B/s detailed - Review of red, green and amber items
 |  | Wash-up calls & Recording of MOM
 |  | BU level
 |  | Order Book Related call
 |  | Other call - please mention
 |  | Capex form filing
 |  | Billing handover document update
 |  | DTP updates
 |  | Internal [NAME] training sessions
 |  | Resolution of PTP/OTC query, Allocation details etc
 |  | Adhoc - Please specify
Spreadsheet: 444d4f05-ce64-4cdb-8a62-f41074d94e25
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-08-16 13:15:37.800000
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 | 101.979 | 101.854 | 101.729 | 101.354 |  | and are added to price quote
3.875 | 100.811 | 100.686 | 100.561 | 100.186
3.75 | 100.589 | 100.464 | 100.339 | 99.964 |  | Note: | Refer To Price [NAME]
3.625 | 100.164 | 100.039 | 99.914 | 99.539 |  |  | For all Price Adjs
3.5 | 99.499 | 99.374 | 99.249 | 98.624
3.375 | 98.583 | 98.458 | 98.333 | 97.708
3.25 | 97.584 | 97.459 | 97.334 | 96.709
 |  |  |  |  |  | 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 | 101.664 | 101.539 | 101.414 | 101.039
3.25 | 101.316 | 101.191 | 101.066 | 100.691
3.125 | 100.998 | 100.873 | 100.748 | 100.373
3 | 100.659 | 100.534 | 100.409 | 100.034
2.875 | 99.987 | 99.862 | 99.737 | 99.112
2.75 | 99.309 | 99.184 | 99.059 | 98.434
 |  |  |  |  |  | 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-30 13:15:37.800000
30 DAY | 2012-09-14 13:15:37.800000
45 DAY | 2012-09-29 13:15:37.800000
60 DAY | 2012-10-14 13:15:37.800000
90 DAY | 2012-11-13 13:15:37.800000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: IS103A

Team | Tournament | PPB
St. Andrew's | Dorman Season Ender | 24.83
Hanover A | New Hampshire NAQT | 23.93
Great Neck South A | KPAQT | 23.75
Team Tribeca A | KPAQT | 23.75
Great Neck South B | KPAQT | 22.74
[NAME] | New Hampshire NAQT | 22.5
Parkview | Dorman Season Ender | 22.03
Riverside | Dorman Season Ender | 22.02
North Babylon A | KPAQT | 21.01
Hills West A | KPAQT | 20.81
[NAME] | KPAQT | 19.89
Plainview A | KPAQT | 19.89
Oakbrook | Dorman Season Ender | 19.44
Greer | Dorman Season Ender | 19.38
Great Neck North A | KPAQT | 18.85
[NAME] | Dorman Season Ender | 18.81
Wheatley A | KPAQT | 18.57
Hills West B | KPAQT | 18.57
[NAME] A | Dorman Season Ender | 18.21
Farmingdale A | KPAQT | 18.06
[NAME] | KPAQT | 18.06
St Anthonys A | KPAQT | 17.67
Riverside B | Dorman Season Ender | 17.24
[NAME] A | Dorman Season Ender | 16.75
Locust Valley A | KPAQT | 15.6
Friends A | KPAQT | 15.35
Hanover B | New Hampshire NAQT | 15.33
Locust Valley B | KPAQT | 15
St Anthonys C | KPAQT | 15
Hanover/[NAME] | New Hampshire NAQT | 15
Great Neck South D | KPAQT | 14.59
Hanover C | New Hampshire NAQT | 13.85
Mineola A | KPAQT | 13.33
North Babylon B | KPAQT | 12.86
Great Neck South C | KPAQT | 12.86
St Anthonys B | KPAQT | 12.5
Plainedge A | KPAQT | 11.72
[NAME] | New Hampshire NAQT | 10
[NAME] B | Dorman Season Ender | 9.55
Plainedge B | KPAQT | 7.65
[NAME] B | Dorman Season Ender | 7.14
[NAME] C | Dorman Season Ender | 3.33
Spreadsheet: 864204d1711468109-how-do-i-find-the-sum-total-amount-products-aligw
Sheet: Book1

Product | Apple |  | Orange |  | [NAME] |  | [NAME] |  | SUBTOTAL
Price | 20000 |  | 40000 |  | 80000 |  | 50000 |  |  | AliGW
[NAME] |  |  |  |  | 1 | 2024-03-26 00:00:00 |  |  | 80000
[NAME] | 2 | 2024-03-26 00:00:00 | 10 | 2024-03-26 00:00:00 |  |  |  |  | 60000
George | 5 | 2024-03-26 00:00:00 | 8 | 2024-03-26 00:00:00 |  |  | 25 | 2024-03-26 00:00:00 | 110000
Spreadsheet: 685827d1594215469-counting-pieces-in-a-lump-sentence-stocktake-count1
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4
January | Balloon = 10 pcs |  |  |  |  |  |  |  | Quantity
February | IWD = 2 pcs | Basketball = 6 pcs |  |  |  |  |  | Balloon | 10
March |  |  |  |  |  |  |  | Basketball | 15
April |  |  |  |  |  |  |  | IWD | 2
May | Basketball = 8 pcs | Tennis = 7 pcs | Softball = 2 pcs |  |  |  |  | Tennis | 7
June |  |  |  |  |  |  |  | Softball | 2
July
August
September
October
November
December
Spreadsheet: 881585d1729692364-get-a-pass-fail-for-a-report-generated-by-fastreporter-3-custom-otdr-bidirectional
Sheet: Configurations

ApplyThresholds | 1
NumberFormat | 0
CellMerging | 0
DisplayOnlyMatchedMeasurements | 0
DisplayGraphPerMeasurement | 1
MeasurementTypes | BDR | OTDR,BDR,CD,PMD,iOLM,FIP,OLTS,PPM,OPM
SheetName | AddMultipleSheets | Tables | PrimaryTable | PrimaryColumns | HasGroups | GroupTable | GroupColumns | NewSheetName
[NAME] | 1 | MatchedFilesDetails;Identification;OTDREventTable | MatchedFilesDetails | UniqueID | 0
SheetName | Range | Filter
Bidirectional | $A$39:$AB$40 | OTDREventTable.Direction='None'
OTDR A->B | $A$34:$M$35 | OTDREventTable.Direction='AB'
OTDR B->A | $A$34:$M$35 | OTDREventTable.[NAME]'
Spreadsheet: 810279d1671648678-merge-data-on-two-sheets-merging-data
Sheet: Data set 1

Application Number | Sex | Grade | location
isp123568 | m | manager | london
isp3115151 | m | staff | manchester
isp516541651 | f | manager | birmingham
isp446844 | f | manager | chelsea
ISP65118156 | m | staff | southampton
ISP6548481 | m | staff | southampton
ISP648 | f | staff | manchester
[NAME] | m | manager | london
ISP652662 | m | staff | chelsea
[NAME] | f | manager | birmingham
ISP621296259 | f | manager | chelsea
isp2115151 | f | staff | birmingham
ispo41512561 | m | staff | birmingham
(6000RECORDS EACH WITH AN INDIVIDUAL REF NUMBER and varying answers for the other columns
Spreadsheet: 801265d1666152163-formulate-unorganised-data-into-organised-one-portal-data1_v2
Sheet: Formulate here

 |  |  | Team Names |  | Team Score |  | Team Odds
Date | Time | Playoff - Y/N | Team 1 | Team 2 | Team 1 | Team 2 | Team 1 | Team 2
 |  |  |  | [NAME] |  | 92
 |  |  |  | Adelaide Strikers |  | 167
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 167
 |  |  |  | Melbourne Renegades |  | 169
 |  |  |  | [NAME] |  | 178
 |  |  |  | Melbourne Renegades |  | 176
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 161
 |  |  |  | [NAME] |  | 149
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 132
 |  |  |  | [NAME] |  | 127
 |  |  |  | [NAME] |  | 123
 |  |  |  | [NAME] |  | 177
 |  |  |  | Adelaide Strikers |  | 161
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 149
 |  |  |  | Adelaide Strikers |  | 139
 |  |  |  | [NAME] |  | 140
 |  |  |  | [NAME] |  | 152
 |  |  |  | [NAME] |  | 145
 |  |  |  | [NAME] |  | 209
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 128
 |  |  |  | [NAME] |  | 126
 |  |  |  | [NAME] |  | 133
 |  |  |  | [NAME] |  | 129
 |  |  |  | Adelaide Strikers |  | 144
 |  |  |  | [NAME] |  | 180
 |  |  |  | Melbourne Renegades
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 187
 |  |  |  | [NAME] |  | 206
 |  |  |  | [NAME] |  | 105
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 207
 |  |  |  | Adelaide Strikers |  | 175
 |  |  |  | Melbourne Renegades |  | 151
 |  |  |  | [NAME] |  | 168
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 208
Spreadsheet: 856681d1705892967-how-to-remove-names-text-if-repeated-in-another-cell-work-schedule-revised-
Sheet: Template

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2022-01-01 00:00:00
Location 1
Location 2
Location 3 | Class A | Task 1 - Alicia & Krysta
 | Class B
 | Class C |  |  | Task 4 - Karen & Lori
 | Class D | Task 2 - Hannah
Location 4
Location 5 |  | Task 3 - Krysta
Location 6
Location 7
Location 8
Location 9
Location 10
Office
Spreadsheet: 747e7781-43dc-41ec-88ec-7c0833e4e83b
Sheet: Sheet1

The NASDAQ OMX Group, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Condensed Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | June 30, |  | March 31, |  | June 30,
 |  | 2010 |  | 2010 |  | 2009
Revenues
Market Services revenues |  | 756 |  | 645 |  | 768
Cost of revenues:
Liquidity rebates |  | -374 |  | -320 |  | -381
Brokerage, clearance and exchange fees |  | -112 |  | -84 |  | -141
Total cost of revenues |  | -486 |  | -404 |  | -522
Total Market Services revenues less liquidity rebates,
brokerage, clearance and exchange fees |  | 270 |  | 241 |  | 246
Issuer Services revenues |  | 86 |  | 84 |  | 85
Market Technology revenues |  | 34 |  | 34 |  | 36
Other revenues |  | 0 |  | 1 |  | 0
Total revenues less liquidity rebates, brokerage,
clearance and exchange fees |  | 390 |  | 360 |  | 367
Operating Expenses
Compensation and benefits |  | 104 |  | 99 |  | 105
Marketing and advertising |  | 5 |  | 4 |  | 3
Depreciation and amortization |  | 25 |  | 25 |  | 27
Professional and contract services |  | 20 |  | 19 |  | 17
Computer operations and data communications |  | 14 |  | 16 |  | 14
Occupancy |  | 21 |  | 22 |  | 18
Regulatory |  | 9 |  | 9 |  | 10
Merger and strategic initiatives |  | 1 |  | 0 |  | 3
General, administrative and other |  | 12 |  | 54 |  | 11
Total operating expenses |  | 211 |  | 248 |  | 208
Operating income |  | 179 |  | 112 |  | 159
Interest income |  | 2 |  | 2 |  | 2
Interest expense |  | -26 |  | -25 |  | -25
Loss on divestiture of businesses |  | -11 |  | 0 |  | 0
Dividend and investment income |  | 1 |  | 0 |  | 1
Income (loss) from unconsolidated investees, net |  | 1 |  | 0 |  | -18
Loss on sale of investment security |  | 0 |  | 0 |  | -5
Income before income taxes |  | 146 |  | 89 |  | 114
Income tax provision |  | 51 |  | 29 |  | 46
Net income |  | 95 |  | 60 |  | 68
Net loss attributable to noncontrolling interests |  | 1 |  | 1 |  | 1
Net income attributable to NASDAQ OMX |  | 96 |  | 61 |  | 69
Basic and diluted earnings per share:
Basic earnings per share |  | 0.46 |  | 0.29 |  | 0.34
Diluted earnings per share |  | 0.46 |  | 0.28 |  | 0.33
Weighted-average common shares outstanding
for earnings per share:
Basic |  | 206 |  | 211 |  | 202
Diluted |  | 209 |  | 215 |  | 214
Spreadsheet: 734668d1622371273-a-formula-to-directly-calculate-the-minimum-sum-without-borrowing-auxiliary-columns-ask530
Sheet: Sheet1

name | Price |  | name | MIN
AA | 100 |  | AA | 50
BB | 200 |  | BB | 1 | Auxiliary column
AA | 50 |  | A001 | 1
BB | 500 |  | A002 | 1
BB | 1
A001 | 1 |  |  | 53 | If we don't borrow the auxiliary column, is there a formula to directly calculate the minimum sum 53
A002 | 1
 |  |  | 53 | 53
 |  |  | 53
Spreadsheet: 770739d1646238045-manipulating-text-string-data-into-separate-columns-formatting-text-into-new-columns
Sheet: Sheet1

\ |  |  |  | Ideal Output
Data
1 bed, 1 bath, 600 sq ft
1200
1 bed, 1 bath, 7,223 sq ft |  |  |  | 1 bed | 1 bath | 7223
1 bed, 1 bath, 10,602 sq ft |  |  |  | 1 bed | 1 bath | 10602
square feet
availibilityMay 30
1 bed, 1 bath, 740 – 750 sq ft |  |  |  | 1 bed | 1 bath | 740 | 750
Studio, 1 bath, 425 sq ft |  |  |  | Studio | 1 bath | 425
1 bed, 1 bath, 780 - 1,123 sq ft |  |  |  | 1 bed | 1 bath | 780 | 1123
Spreadsheet: 593516d1539188513-extract-subarray-from-larger-array-with-multiple-criteria-book1
Sheet: Sheet1

 | Data |  |  |  |  |  |  | Expected Results
 | Order | WO Status | Description | Priority Level | Changes Made By |  |  | WO Status | Description | Priority Level | Changes Made By
 | 0 | Complete | HI | 1 | [NAME] |  |  | Grave     →     Days | HI | 1 | [NAME]
 | 0 | Complete | HI | 3 | [NAME] |  |  | Days     →     Swing | HI | 1 | [NAME]
 | 0 | Complete | HI | 4 | Sussie |  |  | Grave     →     Days | hello | 1 | Sussie
 | 0 | Complete | HI | 1 | [NAME] |  |  | Swing     →     Grave | hello | 2 | [NAME]
 | 0 | Complete | HI | 2 | [NAME] |  |  | Grave     →     Days | hola | 3 | Jennie
 | 0 | Complete | HI | 1 | [NAME]
 | 0 | Complete | HI | 1 | Jennie
 | 0 | Complete | HI | 1 | Jennie
 | 9 | Grave     →     Days | HI | 1 | [NAME]
 | 10 | Days     →     Swing | HI | 1 | [NAME]
 | 0 |  | Time on WO Allocated: | 1 | Jennie
 | 0 | Complete | hello | 1 | [NAME]
 | 0 | Complete | hello | 1 | [NAME]
 | 0 | Complete | hello | 1 | [NAME]
 | 15 | Grave     →     Days | hello | 1 | Sussie
 | 0 | Complete | hello | 1 | Sussie
 | 0 | Complete | hello | 2 | [NAME]
 | 0 | Complete | hello | 3 | [NAME]
 | 0 | Complete | hello | 4 | [NAME]
 | 20 | Swing     →     Grave | hello | 2 | [NAME]
 | 0 | Complete | hello | 3 | [NAME]
 | 0 |  | Time on WO Allocated: | 3 | Sussie
 | 0 | Complete | hola | 3 | [NAME]
 | 24 | Grave     →     Days | hola | 3 | Jennie
Spreadsheet: 854208d1704174098-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v4-hd
Sheet: Project

employee | Start | end | actual end |  | Networkdays | Example of actual end date | result wanted for example of actual end date |  | number of sick leave days for end date | number of sick days for actual end date
AS123 | 2024-01-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-14 00:00:00 |  |  |  | 16
AP345 | 2024-03-10 00:00:00 | 2024-03-14 00:00:00 | 2024-03-13 00:00:00 |  |  |  | 1
AP346 | 2023-12-29 00:00:00 | 2024-03-29 00:00:00 | 2024-02-19 00:00:00 |  |  |  | 28
[NAME] | 2023-12-05 00:00:00 | 2024-02-02 00:00:00 | 2024-02-20 00:00:00 | 2024-02-03 00:00:00 |  |  | -6
Spreadsheet: 271437d1381939581-how-to-get-values-automatically-from-a-sheet-to-another-sheet-list-nth-value-with-duplicate-value-jd16
Sheet: Sheet2

Highest Price | Vegetable name | Change In Price
Spreadsheet: 851484d1701708865-sum-up-all-sheets-by-range-coding-and-date-range-sum-all-sheets
Sheet: Totals

 | 2023-12-31 00:00:00 | 2024-01-06 00:00:00
 | Week 1 | 13.33 | 24 | 32 | 40 | PU | PP | EV | OD | 8 |  |  |  | 8 | 24 | 32 | 40 | PU | PP | EV | OD
0-100 | CUPE |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 |  | This is taking totals from 5 sheets
200-299 | Planners |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | from the range of 1000-1999
1000-1999 | Attend |  | 3 |  | 2 |  | 12 | 6 | 3 | 4 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
2000-2999 | Body |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
3000-3999 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
 | 2024-01-07 00:00:00 | 2024-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Week 2 | 13.33 | 24 | 32 | 40 | PU | PP | EV | OD | 8 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0-299 | CUPE |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
200-299 | Planners |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
1000-1999 | Attend |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
2000-2999 | Body |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
3000-3999 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-01-14 00:00:00 | 2024-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Week 3 | 13.33 | 24 | 32 | 40 | PU | PP | EV | OD | 8 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0-299 | CUPE |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
200-299 | Planners |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
1000-1999 | Attend |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
2000-2999 | Body |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
3000-3999 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2024-01-21 00:00:00 | 2024-01-27 00:00:00
 | Week 4 | 13.33 | 24 | 32 | 40 | PU | PP | EV | OD | 8
0-299 | CUPE
200-299 | Planners
1000-1999 | Attend
2000-2999 | Body
3000-3999 | [NAME]
Spreadsheet: 137616d1327258433-i-need-a-data-dump-from-one-application-cleaned-up-to-upload-to-a-new-with-these-aaa-test-of-data
Sheet: Sheet1

Sheet 1 Examples
Part Number | Description | Thing Number | Frequency | Steps
[NAME] | [NAME] | QQX13 | S | 1.Open Box Top 2. [NAME]. Close [NAME]. Limp Along 5. Go away
BBBA123CC78 | [NAME] | WhoKnowsQQX13 | A | 1.Open Box Bottom and [NAME]. Insert Both Feet 3. Close [NAME] Limp and Skip Along 5. Limp and Skip Along 6. Maybe go away 7. On and On and On
Sheet 2 Required Final Output
Official Title #1 | Step # | Do This
[NAME] | 1. | Open Box Top
[NAME] | 2. | [NAME]
[NAME] | 3. | Close Box Top
[NAME] | 4. | Limp Along
[NAME] | 5. | Go away
[NAME] | 1. | Open Box Bottom and Top
[NAME] | 2. | [NAME]
[NAME] | 3. | Close Box Top
[NAME] | 4. | Limp and Skip Along
[NAME] | 5. | Go away
[NAME] | 6. | Maybe go away
[NAME] | 7. | On and On and On
[NAME]
Spreadsheet: 828494d1683554870-formula-is-not-working-across-contexts-sample-for-excel-forum
Sheet: Sheet1

Date | Correct | Trials | Percentage | Logical [NAME] | Achieved
2023-04-03 00:00:00 | 10 | 10
2023-04-11 00:00:00 | 23 | 25
2023-04-17 00:00:00 | 8 | 8
2023-04-25 00:00:00 | 12 | 16
Spreadsheet: 85501d1285611000-using-weekly-data-to-convert-to-monthly-quote-analyser
Sheet: Weekly Totals

Week | Week Commencing | # of Jobs Quoted | Jobs Quoted Value | Average Value/Job | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate | Jobs Quoted Rolling Total | Ave. Quote Value/Week | Jobs Won Rolling Total | Ave. Won Value/Week
1 | 2010-06-28 00:00:00
2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  |  |  |  |  | 0
4
5
6
7
8
9 |  |  |  |  |  |  | 0
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 238101d1369396129-highlight-values-comparevalue
Sheet: Sheet1

2 | 2
6 | 4
10 | 6
14 | 8
18 | 10
22 | 12
26 | 14
30 | 16
18 | 18
38 | 20
42 | 22
2 | 24
6 | 26
10 | 28
14 | 30
18 | 32
34 | 34
26 | 36
30 | 38
34 | 40
82 | 42
86 | 44
Spreadsheet: 106157d1303354576-how-do-i-add-a-negative-number-to-a-sum-of-numbers-new-microsoft-office-excel-worksheet
Sheet: Sheet1

20119.26 |  |  | 20119.26
-800 |  | Sum | -800 |  | Sum
-1100 |  |  | -1100
 |  |  |  | Add 2%
 | 0.02 |  |  | Sub 2%
Adding 2% |  |  | Adding 2%
Subtract 2% |  |  | Subtract 2%
Spreadsheet: aed63e66-719c-4fa4-ba0a-f8189e5dfeb4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | USA TRACK & FIELD | Unnamed: 6
 |  |  |  |  | REQUEST FOR HONORARIA
Program Account:_______________________________________
Date Check Needed:_____________________________________
PLEASE PRINT OR TYPE AND [NAME] ALL PARTS
Make Check Payable to:
Name:_____________________________________________________________________________________
Street Address:_____________________________________________________________________________
City:_____________________________________  State:_________________  Zip:_______________________
Social Security Number:______________________________________________________________________
Amount of Payment for Service_______________________________________________________
Description:_________________________________________________________________________________________
 | Account:________________________________ |  |  |  |  | Due Date_________________________
 | Special Instructions_______________________ |  |  |  |  | Staff [NAME]_____________________
***Honoraria will only be paid if proper tax information (social security numbers) is provided in advance.
***Recipients of honoraria will receive a form 1099 at the end of the year, generally only when in excess of $600.
***Subject to Code of Ethics limits.
Spreadsheet: 823852d1680175258-formula-for-an-action-monitoring-spreadsheet-ifs-problem-for-excel-forum
Sheet: Sheet1

Question A | My first problem is how to automatically fill the 'action due date' with one formula from the 'date of inspection' and 'category of action' where Low=3months, Medium=2 weeks and High=same day.
Date of inspection | Category | Date action due
2022-01-21 00:00:00 | Low
2022-01-21 00:00:00 | Medium
2022-01-21 00:00:00 | High
Question B | My second problem is that I'd like a single formula to write 'complete', 'overdue', or 'in date' in the final column. Some of the actions were due in the past, some are due in the future and some are complete.
Action due date | Date action completed | Compliance as of today
2022-01-21 00:00:00 | 2022-01-19 00:00:00
2022-01-21 00:00:00 | 2023-01-23 00:00:00
2023-03-30 00:00:00 | 2023-03-30 00:00:00 | To read '[NAME]'
2022-01-21 00:00:00
2023-03-30 00:00:00