tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155162d1336690522-index-match-or-do-i-need-a-macro-supplierrequirements
Sheet: Sheet1

Supplier 1
Dwg Code | Description |  | Dwg Code | Description | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 |  |  |  |  |  |  |  | Supplier 1
 |  |  | G01 | VDS - DRAWING & DOCUMENT SUBMISSION REGISTER c/w SCHEDULE OF SUBMISSIONS | Y |  |  |  |  |  |  |  |  |  |  | Supplier 2
 |  |  | G02 | EQUIPMENT LISTS, BILL OF MATERIALS | Y |  |  |  |  |  |  |  |  |  |  | Supplier 3
 |  |  | G03 | DESIGN CRITERIA & GENERAL SPECIFICATION DOCUMENTATION, CALCULATIONS | Y |  |  |  |  |  |  |  |  |  |  | Supplier 4
 |  |  | G04 | RESULTS OF STUDIES | Y |  |  | Y
 |  |  | G05 | TRAINING PROGRAM (weeks prior to training commencement) | Y | Y |  | Y
 |  |  | [NAME] | CALCULATIONS(ancillary equipment, lift studies, etc) (weeks prior to manufacture/implementation) | Y | Y | Y
 |  |  | G07 | PERFORMANCE CURVES AND DATA | Y | Y | Y
 |  |  | G08 | CLEARANCES FOR EQUIPMENT OPERATION AND MAINTENANCE | Y | Y |  | Y
 |  |  | [NAME] | NOISE CONTROL DATA | Y |  |  | Y
 |  |  | G10 | GENERAL ARRANGEMENT DRAWINGS | Y |  |  | Y
 |  |  | G11 | DRAWINGS OF EQUIPMENT BREAKDOWN FOR FIELD ASSEMBLY | Y |  |  | Y
 |  |  | G12 | PACKING LIST C/W SIZES, WEIGHTS AND SPECIAL HANDLING INSTRUCTIONS | Y |  |  | Y
 |  |  | G13 | INSTALLATION AND ERECTION SEQUENCE C/W SCHEDULE | Y | Y |  | Y
 |  |  | G14 | LUBRICATION SCHEDULE (includes chemicals and additives) | Y | Y
 |  |  | [NAME] | SPECIAL TOOLS RECOMMENDED FOR ERECTION, TESTING, AND [NAME] | Y |  | Y
 |  |  | [NAME] | LIST OF RECOMMENDED SPARE PARTS (as called for in specification) | Y |  | Y | Y
 |  |  | G17 | LIST OF CONSUMABLES AND CHEMICALS (to be brought to site) | Y |  |  | Y
 |  |  | R01 | OPERATIONS AND [NAME] (Before commissioning) | Y
 |  |  | R02 | [NAME] | Y | Y
 |  |  | R03 | TRAINING MANUALS (weeks prior to training commencement) | Y | Y |  | Y
 |  |  | [NAME] | PRE-COMMISSIONING PLAN (weeks prior to related work) | Y |  |  | Y
 |  |  | R05 | COMMISSIONING PROCEDURES | Y
Spreadsheet: 42078d1240604836-automatically-keeping-rows-sorted-in-alphabetical-order-test-planners
Sheet: MGMT INFO

 | Management Information for: |  |  |  |  |  | Company Name - Office_Name - Weekend 05 (25/04/09 - 26/04/09)
 | Clients |  | Competence |  |  |  |  |  |  |  |  |  |  |  |  | Total Per Client
 |  |  | TM | TCM | LKT | LO | HSM | LXA | PO | PC | ES | MC | CC | TL | SAC
 |  |  | pts* | charge* | lo* | COSS* | hand* | [NAME]* | points* | protect* | eng* | [NAME]* | crane* | tandem* | site access*
 |  |  | TM* | TCM* | LKT* | LO* | HSM* | LXA* | PO* | PC* | ES* | MC* | CC* | TL* | SAC*
 | A Client | 'A Client'!B:B | 6 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 10
 | B Client | 'B Client'!B:B | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 5
 | C Client | 'C Client'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | D Client | 'D Client'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 4
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Per Competence |  | 6 | 0 | 0 | 2 | 0 | 5 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 19
 | Trackworkers |  | 6
 | Safety Critical |  | 13
 | Other |  | 0
 | Clients |  | Shifts Cancelled |  | [NAME] |  |  | Clients |  | Hours Invoiced |  | Turnover |  | Gross Profit |  | GP Margin
 | A Client |  | 0 |  | 0 |  |  | A Client |  | 120 |  | 2064 |  | 528 |  | 0.2558139534883721
 | B Client |  | 0 |  | 0 |  |  | B Client |  | 61 |  | 1460 |  | 305 |  | 0.2089041095890411
 | D Client |  | 4 |  | 0 |  |  | D Client |  | 48 |  | 1872 |  | 264 |  | 0.141025641025641
 | C Client |  | 0 |  | 0 |  |  | C Client |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 | Total: |  | 4 |  | 0 |  |  | Total: |  | 229 |  | 5396 |  | 1097 |  | 0.2032987398072647
Spreadsheet: 140641d1328830807-excel-help-can-i-get-excel-to-link-cells-copy-of-sample_bom
Sheet: Sheet3

 | Forecast Production
Piece Parts Used in Assembly | FY11/12 | FY12/13 | FY13/14 | FY14/15 | FY15/16 | FY16/17 | FY17/18 | FY18/19 | FY19/20 | FY20/21
19" Frame
23" Frame
25" Frame
27" Frame
27" Tandem Frame
19" Wheel
23" Wheel
25" Wheel
27" Wheel
19" Tyre
23" Tyre
25" Tyre
27" Tyre
Chain Links
57T Sprocket
64T Sprocket
5 Speed Cluster
6 Speed Cluster
7 Speed Cluster
[NAME]
Pedal
Seat
Handle Bar
Spreadsheet: 20edd15b-427e-4887-87ac-d527ff52b0da
Sheet: Exhibit XV, Page 2

Owners Forms
USAA
Pennsylvania
Rate Change History
Effective Date | Percent Effect | Dollar Effect (nearest thousand) |  | Description of Changes
2007-02-01 00:00:00 | -0.04 | -1286000 |  | Expand the Homeowners Pricing Program from 5 levels
 |  |  |  | to 7 levels, implement new territory boundaries and
 |  |  |  | relativities, revise endorsment costs and unity premiums.
2008-03-01 00:00:00 | -0.14 | -4316000 |  | Revise Price Level Factors for Owners and Unit-Owners
 |  |  |  | forms, New Home Discount credits & caps for Owners
 |  |  |  | forms, and Base Rates for Owners & Unit-Owners forms.
NB*: November 30, 2009 | 0.088 | 2467000 |  | Introduce HO2008 program for Owners and Unit-Owners,
RB**: January 30, 2010 |  |  |  | Introduce Renewal Rate Capping.
NB*: August 14, 2010 | 0 | 0 |  | Introduce the use of Military Status in Pricing Level calculation
RB**: November 1, 2010 |  |  |  | for USAA-GIC.
2011-01-30 00:00:00 | 0 | 0 |  | Introduce new limit options for Coverage B.
2011-08-15 00:00:00 | 0.074 | 2480000 |  | Introduce additionally rated catastrophic perils.
 |  |  |  | Introduce a new rating structure for the Earthquake Endorsement.
2012-08-15 00:00:00 | 0.159 | 5729000 |  | Introduce new territory boundaries.
* "NB" = "New Business"
** "RB" = "Renewal Business"
Spreadsheet: 834377d1687777603-count-if-sum-returning-error-2023-master-data-test-with-error
Sheet: RawData

Call Date | Call Completed | SKU available on entry? : Reese's Sku 1 47g | SKU available on exit? : Reese's Sku 1 47g | SKU available on entry? : Sku 2 40g | SKU available on exit? : Sku 2 40g | SKU available on entry? : Sku 3 42g | SKU available on exit? : Sku 3 42g | SKU available on entry? : [NAME]g | SKU available on exit? : [NAME]g | SKU available on entry? : Sku 5 bag | SKU available on exit? : Sku 5 bag | SKU available on entry? : [NAME] PMP | SKU available on exit? : [NAME] PMP | SKU available on entry? : Sku 7 £1 PMP | SKU available on exit? : Sku 7 £1 PMP | SKU available on entry? : Sku 8 68g | SKU available on exit? : Sku 8 68g | Sku 1 Entry | [NAME] | [NAME] | Sku 2 Entry | [NAME] | Hershey Distribution Gain | Sku 3 Entry | [NAME] | Sku 3 Distribution Gain | Sku 4 Entry | [NAME] | [NAME] Gain | Sku 5 bag Entry | [NAME] | Sku 5 Distribution Gain | [NAME] | Sku 6Exit | Sku 6Distribution Gain | Sku 7 Entry | [NAME] | Sku 7 Distribution Gain | sku 8 Entry | [NAME] 8 Exit | [NAME] 8 Distribution Gain | No. Of Gained points | Unique Distribution point | one Entry | two Entry | three Entry | four Entry | five Entry | Six Entry | seven Entry | eight Entry | No of Yes on entry
2023-06-19 08:11:10 | Yes | No | No | No | No | No | No | No | No | No | No | No | No | No | No
2023-06-19 08:26:28 | Yes | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No | No
2023-06-19 08:42:58 | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | Yes
2023-06-19 08:42:58 | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | Yes
Spreadsheet: 837630d1690304371-grace-period-book7
Sheet: Sheet1

 |  | Loan 1
 |  |  |  | ABK
 |  |  |  | Start Date | 2023-05-01 00:00:00 |  | Flat Translation
 |  |  |  | Principle |  |  | Principle Payment
 |  |  |  | Admin Fees
 |  |  |  | Received |  |  | Interest
 |  |  |  | Annual Rate | 0.21 |  | Interest Payment
 |  |  |  | Monthly |  |  | Total
 |  |  |  | Years
 |  |  |  | Tenor - months
 |  |  |  | Early Repayment Fee
 |  |  |  | Total Interest Payment
Summary Table
Month |  | Month |  | Open Bal | Interest | Principle | Total PMT | End Bal | Early Settl.
2023-03-01 00:00:00
Spreadsheet: 3bd39eb2-a108-4586-bf0e-acfd2c34bfd9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7559 | 56326 | Martin | Hikanik | SVK | 102 | 00:17:00 | 00:00:46 | 00:22:49 | 00:00:59 | 00:17:50 | 1 | 00:59:29
7559 | 56048 | [NAME] | Viskari | FIN | 101 | [NAME] | 00:00:56 | 00:23:02 | 00:01:30 | 00:20:26 | 2 | 01:03:38
Spreadsheet: 673983d1587622119-index-match-search-for-a-string-and-return-multiple-values-lookup-sample
Sheet: Sheet1

Search column | [NAME] |  | lookup value | Expected output
[PHONE] 77080 | DAR1000 |  | 73660
[PHONE] 77081 | DAR1005 |  | 73660
[PHONE] [PHONE] 77012 | DAR2000 |  | 73700
[PHONE] 74178 | DAR2005 |  | 73701
[PHONE] 74177 | DAR2010
[PHONE] 74176 | DAR2015
[PHONE] 74160 | DAR2020
[PHONE] 74170 | DAR2025
[PHONE] 73700 | DAR2030
[PHONE] [PHONE] 73660 77012 | DAR2075
[PHONE] [PHONE] 20225 77012 | [NAME]
[PHONE] [PHONE] 20220 77012 | DAR2085
[PHONE] [PHONE] 47000 77012 | DAR2095
[PHONE] [PHONE] 73660 32405 | DAR2100
[PHONE] [PHONE] 77012 20206 | DAR2105
[PHONE] [PHONE] 48102 77012 | DAR2110
[PHONE] [PHONE] 32400 77012 | [NAME]
[PHONE] 70460 | DAR2125
[PHONE] 70470 | DAR2130
[PHONE] 70450 | DAR2135
[PHONE] 75635 | DAR2145
[PHONE] 73701 | DAR2150
[PHONE] [PHONE] 71275 74174 | DAR2160
[PHONE] 71275 | DAR2170
[PHONE] 70496 | DAR2180
[PHONE] 73706 | DAR2185
[PHONE] 70498 | DAR2190
[PHONE] 72191 | DAR2195
[PHONE] 73206 | DAR2200
Spreadsheet: 104397d1302024138-sum-salespeople-by-day-in-a-full-range-excel-example_frenchii
Sheet: Sheet1

DATE | customer | sales |  | DATE | Customer Count | Sales
2010-08-01 00:00:00 | PT 1 | SMITH
2010-08-01 00:00:00 | PT 2 | SMITH
2010-08-01 00:00:00 | PT 3 | SMITH
2010-08-01 00:00:00 | PT 4 | SMITH
2010-08-01 00:00:00 | PT 5 | SMITH
2010-08-01 00:00:00 | PT 6 | SMITH
2010-08-01 00:00:00 | PT 7 | SMITH
2010-08-01 00:00:00 | PT 8 | SMITH |  | 2010-08-01 00:00:00 | 8 | SMITH
2010-08-01 00:00:00 | PT 9 | JONES
2010-08-01 00:00:00 | PT 10 | JONES
2010-08-01 00:00:00 | PT 11 | JONES
2010-08-01 00:00:00 | PT 12 | JONES |  | 2010-08-01 00:00:00 | 8 | JONES
2010-08-01 00:00:00 | PT 13 | MADEUP
2010-08-01 00:00:00 | PT 14 | MADEUP
2010-08-01 00:00:00 | PT 15 | MADEUP |  | 2010-08-01 00:00:00 | 8 | MADEUP
2010-08-01 00:00:00 | PT 16 | OUTOIDEA
2010-08-01 00:00:00 | PT 17 | OUTOIDEA |  | 2010-08-01 00:00:00 | 8 | OUTOIDEA
2010-08-02 00:00:00 | PT 1 | SMITH
2010-08-02 00:00:00 | PT 2 | SMITH
2010-08-02 00:00:00 | PT 3 | SMITH
2010-08-02 00:00:00 | PT 4 | SMITH
2010-08-02 00:00:00 | PT 5 | SMITH
2010-08-02 00:00:00 | PT 6 | SMITH
2010-08-02 00:00:00 | PT 7 | SMITH
2010-08-02 00:00:00 | PT 8 | SMITH |  | 2010-08-02 00:00:00 | 8 | SMITH
2010-08-02 00:00:00 | PT 9 | JONES
2010-08-02 00:00:00 | PT 10 | JONES
2010-08-02 00:00:00 | PT 11 | JONES
2010-08-02 00:00:00 | PT 12 | JONES |  | 2010-08-02 00:00:00 | 8 | JONES
2010-08-02 00:00:00 | PT 13 | MADEUP
2010-08-02 00:00:00 | PT 14 | MADEUP
2010-08-02 00:00:00 | PT 15 | MADEUP |  | 2010-08-02 00:00:00 | 8 | MADEUP
2010-08-02 00:00:00 | PT 16 | OUTOIDEA
2010-08-02 00:00:00 | PT 17 | OUTOIDEA |  | 2010-08-02 00:00:00 | 8 | OUTOIDEA
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 6

C R I T E R I A | Total Possible Score |  |  |  |  |  |  |  |  |  |  | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: dc0978cb-3c2b-4b25-bf0b-33ee8eac2b3a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5768 | 13699 | [NAME] | Averesch | GER | 20 | 00:16:43 | [NAME] | 00:34:50 | 00:02:41 | 00:22:35 | 1 | 01:19:59
5768 | 40955 | [NAME] | Judge | GBR | 0 | 00:13:56 | 00:03:15 | 00:36:12 | 00:02:21 | 00:25:24 | 2 | 01:21:08
5768 | 40953 | [NAME] | [NAME] | GBR | 19 | [NAME] | 00:05:46 | 00:40:54 | [NAME] | 00:40:58 | 3 | 01:50:40
5768 | 12645 | Santos | Caballero | ESP | 16 | 00:21:25 | 00:04:56 | 00:45:03 | 00:04:23 | 00:42:47 | 4 | 01:58:32
Spreadsheet: 31927d1227943631-average-multiple-rows-based-on-2-columns-example_honours
Sheet: Sheet2

Student Number | Student Legal Last Name | Average | Award
234567 | Martin | 90.625 | Yes
345678 | Smith | 81.625 | No
456789 | [NAME] | 64.125 | No
567890 | Jones | 80.5 | No
Spreadsheet: 729765d1619328111-tracker-for-production-company-sample-data
Sheet: Production Tracker

S.No | JOB.NO | START DATE | Job Name | Type | WARE HOUSE QTY | Status | In-Stock | Remarks | Corrugation |  | Printing | Pasting | Creasing | RS | Stitching | [NAME] | Bundled | [NAME] | Count (Bundle)
 |  |  |  |  |  |  |  |  | Paper Cutting | Liner
1 | Apri-01 |  | [NAME] | 3 Ply | 10000
2 | 2021-04-02 00:00:00 |  | [NAME] | 5 Ply | 2000
3 | 2021-04-03 00:00:00 |  | [NAME] | 7 Ply | 3000
Spreadsheet: 79471d1279726620-monthly-event-schedule-format-like-that-event_schedule
Sheet: January 2010

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Spreadsheet: 758729d1639043246-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: ADMIN NOTES DO NOT USE

All Managers | Calculations TAB |  |  | Client Calls
Spreadsheet: 148927d1333619607-vlookup-value-not-found-help-excel_help
Sheet: DATA

Part Number | Price | Shop | Our price | Difference | Cheaper
LU.SFT0C.060 | 6166 | Alza.cz
LU.SFT0C.060 | 6379 | BScom s.r.o.
LU.SFT0C.060 | 6399 | dbIT
[NAME] | 5458 | dbIT
LU.SFV0D.080 | 5137 | Inter-shop.cz
LU.SFV0D.080 | 5137 | OK Computers
LU.SFV0D.080 | 5137 | vypocetnitechnika.eu
LU.SFV0D.080 | 5138 | ALFA COMPUTER a.s.
LU.SFV0D.080 | 5138 | [NAME]
LU.SFV0D.080 | 5138 | DXT ComputerS
LU.SFV0D.080 | 5138 | NOVAcom
LU.SFV0D.080 | 5139 | Mironet.cz a.s.
LU.SFV0D.080 | 5215 | Digiboss.cz
LU.SFV0D.080 | 5237 | PC-Rescue.cz
LU.SFV0D.080 | 5325 | Alza.cz
LU.SFV0D.080 | 5360 | FreeComp
LU.SFV0D.080 | 5361 | PočítačeaElektronaprajzské.cz
LU.SFV0D.080 | 5414 | Inpraise
LU.SFV0D.080 | 5415 | Electro World s.r.o.
LU.SFV0D.080 | 5458 | dbIT
LU.SFV0D.080 | 5505 | BScom s.r.o.
LU.SFV0D.080 | 5510 | ARCOM
LU.SFV0D.080 | 5828 | IBS shop
LU.SFV0D.080 | 6007 | Právo a informace o.s.
LU.SFV0D.080 | 6098 | [NAME]
LU.SFV0D.080 | 6116 | Moravia Pc
LU.SFV0D.080 | 6188 | LANTINA
LU.SFV0D.080 | 6199 | SUNTECH computer
LU.SFW0D.075 | 5458 | dbIT
Spreadsheet: 83413d1283403352-calculating-tax-salary-working
Sheet: Sheet2

 | Manual |  | 2 |  | No CIT | 1/3 of salary | Cap-300000 | Contribution
 |  |  |  |  |  |  |  |  | 1 | 160000
[NAME] | 30000 |  |  | Salary-Annual |  |  |  |  | 2 | 200000
PF-E'ee
PF-E'er |  |  |  | PF-E'ee
CIT |  |  |  | PF-E'er
Monthly
1\3 of Salary |  |  |  | CIT |  |  | 300000
[NAME]. 300K
 |  |  |  | Insurance-Annual
Insurance
Bonus |  |  |  | Bonus
Dashain-Expenses
 |  |  |  | Total Taxable income
 |  |  |  | Annaul Tax
 |  |  |  | 0.01 | for first 160000 for single and 200000 for couple
 |  |  |  | 0.15 | second 100000 for both
 |  |  |  | 0.25 | more that 260000 for single and 300000 for couple
Spreadsheet: 703218d1604854740-random-task-allocation-task-test
Sheet: Formula Trial

[NAME] |  |  | 17 |  | Letters
Employee | Shift | Hours |  |  | Employee | Shift | Hours
 |  |  |  |  | Percy
 |  |  |  |  | [NAME]
 |  |  |  |  | Stanley
Competition |  |  |  |  | Sales |  |  | 17
Employee | Shift | Hours |  |  | Employee | Shift | Hours
[NAME] |  |  |  |  | [NAME]
Christian |  |  |  |  | Sophie
[NAME]
Spreadsheet: 687044d1594924666-countifs-for-unique-data-book1v2
Sheet: Sheet1

 |  |  |  |  | Example 1
 | Client | Date | Won/Lost |  |  |  | Total Distinct Clients | New Unique Clients |  |  | Comment
 | [NAME] | 2020-04-15 00:00:00 | Won |  | 2020-05-01 00:00:00 | To End of April |  |  |  |  | 3 clients, all unique
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of May |  |  |  |  | 8 deals but [NAME] and [NAME] each had 2 deals so 6 DISTINCT. From April, [NAME] and [NAME] are new
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of June |  |  |  |  | 7 discint clients, [NAME] was new
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-06-10 00:00:00 | Won |  |  |  | To the extend helpful, these were my formulas
 | [NAME] | 2020-06-15 00:00:00 | Won |  |  |  | Array for total distinct | Arrow for unique
 | [NAME] | 2020-06-30 00:00:00 | Won |  |  |  |  |  |  |  | 7 distinct, only unique clients are [NAME] and [NAME]
 | [NAME] | 2020-06-30 00:00:00 | Won
 | [NAME] | 2020-06-30 00:00:00 | Lost
 |  |  |  |  | Example 2
 |  |  |  |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-06-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 6 |  |  |  | Should be 6 distinct clients since we didn't win [NAME]
 |  |  | This is really final product |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 4 |  |  |  | Question I'm trying to answer is how many clients did we do business with in a given month and how many of them have we never done business with before? Here, it's 4 clients we've done business with ([NAME], [NAME], [NAME], [NAME]) but [NAME] is a repeat client
 |  |  |  |  | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 3 | 0 |  |  | same thing here, should only be 3 distinct clients because we lost the trade with [NAME]. No unique clients from start
Spreadsheet: 47310d1246352076-max-date-status-max-date-status
Sheet: Sheet1

Final Status | Date | Status | Date | Status | Date | Status
OK | 2009-06-29 00:00:00 | ok
OK | 2009-06-30 00:00:00 | add few inches | 2009-06-30 00:00:00 | ok
 | 2009-06-28 00:00:00 | darken it | 2009-06-29 00:00:00 | reduce length | 2009-06-30 00:00:00 | increase height
Here in A4 I want to achieve "increase Height"  because it’s the latest status or the [NAME] date status.
I m trying the formula in A4 but its not working  IF(C4="OK","OK",(offset(max(b4,d4,f4),1,0)))&IF(E4="OK","OK",(offset(max(b4,d4,f4),1,0)))&IF(G4="OK","OK",(offset(max(b4,d4,f4),1,0)))
Spreadsheet: 0c53187f-d51c-49e7-9a6a-c8a4fa305953
Sheet: NO23N data median

 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
High (28) | 0.04658889956772327 | 0.04183159954845905 | 0.04655525088310242 | 0.04695000126957893 | 0.05675000138580799 | 0.04435000009834766 | 0.0442500002682209 | 0.04309999942779541 | 0.04405000060796738 | 0.04740000143647194 | 0.04209999926388264 | 0.03714999929070473 | 0.03729999996721745 | 0.04690000042319298 | 0.03845000080764294 | 0.03865000046789646 | 0.03770000115036964 | 0.03724999912083149 | 0.03859999962151051
Good (196) | 0.6416000127792358 | 0.6639499962329865 | 0.5986395180225372 | 0.6053999811410904 | 0.7139827460050583 | 0.6133750081062317 | 0.6248749941587448 | 0.5528582632541656 | 0.6096499860286713 | 0.5962999984622002 | 0.6266500055789948 | 0.6531837359070778 | 0.6733887419104576 | 0.6831372678279877 | 0.6645165085792542 | 0.6131817549467087 | 0.6012225151062012 | 0.5709375143051147 | 0.6013579964637756
Moderate (473) | 1.946670055389404 | 1.820000052452087 | 1.862949967384338 | 1.907080054283142 | 1.929999947547913 | 1.840000033378601 | 1.983399987220764 | 1.926499962806702 | 1.878650009632111 | 1.773099958896637 | 1.772899985313416 | 1.739169955253601 | 1.89191997051239 | 1.807000041007996 | 1.851999998092651 | 1.906589984893799 | 1.794820010662079 | 1.705834984779358 | 1.746670007705688
Poor (196) | 2.998950004577637 | 3.004699945449829 | 2.963479995727539 | 2.919375061988831 | 3.051325023174286 | 2.932999968528748 | 3.134500026702881 | 2.858150005340576 | 2.862590074539185 | 2.660770058631897 | 2.722575008869171 | 2.625185012817383 | 2.85387247800827 | 2.557294964790344 | 2.815025091171265 | 2.815725028514862 | 2.706605017185211 | 2.518314987421036 | 2.57154256105423
Bad (93) | 2.873640060424805 | 3.020440101623535 | 2.91582989692688 | 2.770829916000366 | 2.700000047683716 | 2.656500101089478 | 2.834700107574463 | 2.5 | 2.558000087738037 | 2.564199924468994 | 2.477220058441162 | 2.19587504863739 | 2.593600034713745 | 2.494350075721741 | 2.629999995231628 | 2.546350002288818 | 2.546350002288818 | 2.458642482757568 | 2.546350002288818
Trend moderate
Trend poor
Trend bad
 | 1 | 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 | 32 | 33 | 34 | 35 | 36
Spreadsheet: 34477d1231781219-follow-up-to-using-count-but-now-with-interupted-cells-wbprototype
Sheet: Third

 | period 5 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total
 | Week    4 | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.09999999999999999 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | holiday |  | 0.1 |  | 0.1 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Memb Base |  |  | Memb Inc % |  |  | Exec Penet % |  |  | Capt Ren Rate |  |  | Total Income
 | YTD
 | Goals
Spreadsheet: 75343d1275928178-conditional-formatting-based-on-dates-month-colored
Sheet: Sheet1

2010
2011