tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49648d1248985934-issues-with-index-match-not-working-correctly-testexcel
Sheet: Example

 | Table1
 | MonDay | DayofWk | Hour | LookedUpValue | ShouldGet |  | Table3
 | 0613 | 6 | 5 |  | 0 |  | DayOfWk | Multiplier
 | 0613 | 6 | 17 |  | 0 |  | 1 | 0
 | 0613 | 6 | 24 |  | 0 |  | 2 | 1
 | 0614 | 7 | 14 |  | 0 |  | 3 | 1
 | 0614 | 7 | 15 |  | 0 |  | 4 | 1
 | 0614 | 7 | 16 |  | 0 |  | 5 | 1
 | 0615 | 1 | 19 |  | 50 |  | 6 | 1
 | 0615 | 1 | 20 |  | 60 |  | 7 | 0
 | 0615 | 1 | 21 |  | 0
 | 0616 | 2 | 13 |  | 0
 | 0616 | 2 | 14 |  | 0
 | 0616 | 2 | 15 |  | 10
 | 0616 | 2 | 16 |  | 20
 | 0617 | 3 | 19 |  | 50
 | 0621 | 7 | 20 |  | 0
 | 0621 | 7 | 21 |  | 0
 | 0621 | 7 | 22 |  | 0
 | Table2
 |  | Hour Ending--> | 0 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | [NAME] | 0101 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | June 15-21 | 0615 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 0
 | June 22-29 | 0622 | 0 | 70 | 80 | 90 | 100 | 110 | 120 | 0
 | June 29-July5 | 0629 | 0 | 121 | 122 | 123 | 124 | 126 | 127 | 0
 | July 6-12 | 0706 | 0 | 131 | 133 | 135 | 137 | 138 | 139 | 0
 | July 13-19 | 0713 | 0 | 103.8393333333333 | 103.8393333333333 | 198.1666666666666 | 198.1666666666666 | 94.12916666666665 | 94.12916666666665 | 0
 | July 20-26 | 0720 | 0 | 95.69549999999997 | 95.69549999999997 | 182.6249999999999 | 182.6249999999999 | 86.74687499999997 | 86.74687499999997 | 0
 | July 27-31 | 0727 | 0 | 87.81366666666666 | 87.81366666666666 | 167.5833333333333 | 167.5833333333333 | 79.60208333333333 | 79.60208333333333 | 0
 | Aug1-Dec31 | 0801 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 713445d1610721710-help-needed-with-vlookup-to-fill-in-cells-automatically-but-with-exceptions-help2
Sheet: SAMPLE

PERSON | CODE | COLUMN C | COLUMN D
[NAME] |  | X
[NAME] |  |  | X
[NAME] |  | X
[NAME]
Anne
[NAME]
[NAME]
Spreadsheet: 801094d1666081753-how-to-use-averageifs-and-offset-to-get-rolling-average-sampleaverage
Sheet: Sheet1

1 | 0.25 | 2022-03-16 00:00:00 | 7 | 66 | 7 | 0.25
2 | 0.5 | 2022-03-17 00:00:00 | 14 | 100 | 14 | 0.5
3 | 0.5 | 2022-03-17 00:00:00 | 14 | 12 | 24 | 1
4 | 1 | 2022-03-19 00:00:00 | 24 | 21
5 | 1 | 2022-03-19 00:00:00 | 24 | 45
6 | 0.5 | 2022-03-19 00:00:00 | 14 | 22
7 | 0.5 | 2022-03-23 00:00:00 | 14 | 44
8 | 1 | 2022-03-23 00:00:00 | 24
9 | 0.5 | 2022-03-24 00:00:00 | 14 | 76
10 | 1 | 2022-03-24 00:00:00 | 24
11 | 0.5 | 2022-03-24 00:00:00 | 14 | 33
12 | 1 | 2022-03-24 00:00:00 | 24 | 60
13 | 0.5 | 2022-03-25 00:00:00 | 14 | 33
14 | 1 | 2022-03-25 00:00:00 | 24
15 | 1 | 2022-03-26 00:00:00 | 24
16 | 1 | 2022-03-28 00:00:00 | 24
Spreadsheet: 377077d1423782572-find-value-that-doesnt-match-and-bring-back-column-heading-updated-file-ndm
Sheet: Year 1

PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | DW2
1003 | 22 | 11 | B1 | D34
1004 | 23 | 12 | B2 | AQ1
1005 | 23 | 21 | C1 | SS2
1006 |  | 8 | A1 | SS1
1007 |  | 9 | A2 | DW2
1008 |  | 11 | B1 | D34
1009 |  | 12 | B2 | AQ1
1010 |  | 21 | C1 | SS2
1011 |  | 8 | A1 | SS1
1012 |  | 9 | A2 | DW2
1013 |  | 11 | B1 | D34
1014 |  | 12 | B2 | AQ1
1015 |  | 21 | C1 | x1
Spreadsheet: 32844d1229013508-help-with-moving-from-a-data-input-form-hotel-system-1
Sheet: Daily Input Sheet 2

 | Date | Early bird bookings | No Panic Bookings | Walk in guests | Total guests
 | 23/12/2008 | 20 | 14 | 6 | 40
 | 22/12/2008 | 20 | 14 | 6 | 40
 | 21/12/2008 | 20 | 14 | 6 | 40
 | 20/12/2008 | 20 | 14 | 6 | 40
 | 19/12/2008 | 20 | 14 | 6 | 40
 | 18/12/2008 | 20 | 14 | 6 | 40
 | 17/12/2008 | 20 | 14 | 6 | 40
 | 16/12/2008 | 20 | 14 | 6 | 40
 | 15/12/2008 | 20 | 14 | 6 | 40
 | 14/12/2008 | 20 | 14 | 6 | 40
 | 13/12/2008 | 20 | 14 | 6 | 40
 | 12/12/2008 | 20 | 14 | 6 | 40
 | 11/12/2008 | 26 | 16 | 2 | 44
 | 10/12/2008 | 25 | 15 | 5 | 45
 | 9/12/2008 | 30 | 10 | 6 | 46
Totals |  | 321 | 209 | 85 | 615
Spreadsheet: 52788d1252601849-merging-2-sheets-test
Sheet: SHEET1 

Job_id | Host_Name | Launched_by_user | Outcome | STEP_INDEX
742762 |  | rkishore | success | Null
742762 | QCTCRMBLD07 | rkishore | success | 0
742762 | QCTCRMBLD02 | rkishore | success | 1
742762 |  | rkishore | skipped | 2
Spreadsheet: 848425d1699170957-rebate-calculation-with-condition-simulation-of-rebate-with-conditions
Sheet: Sheet1

Simulation of rebate
 |  | Min. top up should be reached to get rebate | 1000000
 |  | Rebate % | 0.25
 |  | [NAME]. top up allowed | 2000000
 |  | Timeline | 2023-11-06 00:00:00 | 2023-11-07 00:00:00 | 2023-11-08 00:00:00 | 2023-11-09 00:00:00 | 2023-11-10 00:00:00 | 2023-11-11 00:00:00 | 2023-11-12 00:00:00 | 2023-11-12 00:00:00
 |  | Top up done by user | 300000 | 700000 | 0 | 500000 | 300000 | 0 | 200000 | 1000000
 |  | Cumulative top up
 |  | Rebate (25% of top up)
 | Need formula for this >>> | Rebate user actually get | 0 | 250000 | 0 | 125000 | 75000 | 0 |  | 0
 |  | Remarks | not get [NAME] because not yet reach Min. top up (cell D2) | get [NAME] for the first time because alr. reached Min. top up |  |  |  |  |  | not get rebate anymore because alr. exceed [NAME]. top up (cell D4)
Spreadsheet: 205990d1357970504-selecting-multiple-items-in-a-list-danh-sach-nhap-lieu-
Sheet: Food Res

 |  | Món ăn Việt | Cơm | Xôi | [NAME] | Đồ nướng | Đồ rừng
 |  | Phở, hủ tiếu, cháo
 |  | Hải sản
 |  | Ăn nhanh, [NAME], beffet
 |  | Ăn [NAME]
 |  | Món ăn Quốc tế
 |  | [NAME], đồ uống
 |  |  | Sao | 1 | 2
[NAME] | Khách sạn | Nhà nghỉ | Resort
STT | [NAME] | [NAME] | Điện thoại | Website | [NAME] | [NAME] mục | Món ăn chính | Nội dung
 |  |  |  |  |  |  |  | - Nội dung chính: - Điểm nổi bật:  - Giá cả: - Khác
Spreadsheet: 330144d1404568549-vlookup-if-formulas-and-linking-two-spreadsheets-together-long-term-absence-overview
Sheet: Overview

Name | [NAME] | Absence End | BP | Absence Days | Reason
Username 4 | 2014-09-04 00:00:00 |  | 6 | 20 | Debility
Username 9 | 2014-09-09 00:00:00 |  | 1 | 20 | Debility
Username 12 | 2014-09-12 00:00:00 |  | 0 | 20 | Debility
Spreadsheet: 61052d1261647190-excel-2007-excel-2007-connection-between-two-tables-book1
Sheet: Sheet1

 |  | Table 1 |  |  |  |  | Table 2
 |  |  |  |  |  |  |  | Program for production
 | r/b | Profiles | Up side | Dawn side |  |  | r/b | Profiles | Up side | Dawn side | bars
 | 1 | M11260 | M11063 | M11265 |  |  | 1 | M11260 | M11063 | M11265 | 100
 | 2 | M11064 | M11063 | M11012
 | 3 | M11018 | M11023 | M11015
 | 4 | M11044 | [NAME] | M11045
 | 5 | M11044 | [NAME] | M11045
 | 6 | M11048 | M11046 | M11047
 | 7 | M11048 | M11046 | M11047
 | 8 | [NAME] | M11019 | M11012
 | 9 | [NAME] | M11019 | M11012
 | 10 | M11062 | M11061 | M11009
 | 11 | M9658 | M9658A | M9652B
 | 12 | M11149 | [NAME] | M11012
 | 13 | M9653 | M9653A | M9652B
 | 14 | M11190 | M11189 | M11191
Spreadsheet: 794632d1662163656-employee-absence-tracker-rolling-12-month-window-needed-2022-exempt-sick-test
Sheet: SEPTEMBER

NAME | DATE | SHIFT | BADGE | DEPT | REASON | COMMENT
 | 2022-09-01 00:00:00 | 3 | 600288 | [NAME] | Sick
 | 2022-09-01 00:00:00 | 3 | 696542 | Hotel | LOA
 | 2022-09-01 00:00:00 | 1 | 287111 | GP | FMLA
 | 2022-09-01 00:00:00 | 1 | 287119 | FT | Sick
 | 2022-09-01 00:00:00 | 1 | 710194 | GP | Left Early
 | 2022-09-02 00:00:00 | 1 | 710194 | GP | Personal
 | 2022-09-02 00:00:00 | 1 | 287119 | FT | Sick
 | 2022-09-06 00:00:00 | 1 | 272459 | Hotel | Other
 | 2022-09-07 00:00:00 | 1 | 272459 | Hotel | Other
 | 2022-09-08 00:00:00 | 1 | 272459 | Hotel | Other
 | 2022-09-09 00:00:00 | 1 | 272459 | Hotel | Other
Spreadsheet: 0955d7c6-69cb-46fa-bfdf-57cd93c23f52
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
199PT | Test | 199PT | Carbohydrate Antigen 19-9 (CA 19-9), Peritoneal Fluid | CA 19-9, Peritoneal Fluid | Immunoenzymatic Assay |  |  |  | 2 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Plastic vial [NAME]: 2 mL | 0.5 mL | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 86301 |  |  |  |  | Rochester
199PT | [NAME] | PERITONE | Peritoneal |  |  |  | Frozen | 90 days
199PT | Result | 199PN | CA 19-9, Peritoneal Fluid | CA 19-9, Peritoneal Fluid | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 50781-4
199PT | Result | SITEE | Site | Site | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
Spreadsheet: 5db5c9a0-dad1-464d-83b3-1fe4fda50b56
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: |  |  | 2011-07-05 09:20:59.630000
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.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 100.901 | 100.776 | 100.651 | 100.276
4.625 | 99.861 | 99.736 | 99.611 | 99.236 |  | Note: | Refer To Price [NAME]
4.5 | 99.359 | 99.234 | 99.109 | 98.734 |  |  | For all Price Adjs
4.375 | 98.701 | 98.576 | 98.451
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.134 | 101.009 | 100.884 | 100.509
4 | 100.802 | 100.677 | 100.552 | 100.177
3.875 | 100.349 | 100.224 | 100.099 | 99.724
3.75 | 99.759 | 99.634 | 99.509 | 99.134
3.625 | 98.441 | 98.316 | 98.191
 |  |  |  |  |  | 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 | 2011-07-19 09:20:59.630000
30 DAY | 2011-08-03 09:20:59.630000
45 DAY | 2011-08-18 09:20:59.630000
60 DAY | 2011-09-02 09:20:59.630000
90 DAY | 2011-10-02 09:20:59.630000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 719115d1613505163-return-number-of-out-of-date-training-in-a-month-excel-forum-help
Sheet: Training Plan

 | Training Course |  | [NAME] 2021
 |  | E Learning Y/N | Training Traget | Training GAP | ARP |  | MAY |  | JUN |  | JULY |  | AUG |  | SEPT |  | OCT |  | NOV |  | DEC |  | JAN |  | FEB |  | MAR |  | TOTAL
 |  |  |  |  | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A |  | p
Mandatory |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL
 | April |  | (Crane) Associate on B, Trips  (ATR) Associate could not log onto Elearning, this has now been fixed
 | May |  | 5 associate could not attend the Safety training
 | June |  | (Crane) Trainer on hoilday, this will be planned for July
 | July |  | Contractor training associate on nights. [NAME] associat on holiday
 | August |  | No training in August due to shutdown work load
 | September |  | No crane training due to work load, associate not to use crane untill training has been given
 |  |  |  |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | JAN |  | FEB |  | MAR |  | YEARLY |  | Not Attend
 |  |  |  |  | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | P | A | 3
Spreadsheet: sara_shackleton__36460__omnibus
Sheet: Sheet1

Omnibus Confirm for Deal # NJ6008.1 and NJ7120.1
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Twister Gas Services, LLC | CONTACT:
ADDRESS: | to be assigned to: | TITLE:
 | Sanguine, Ltd. | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD
 | 500000
NOTE: | CP is to post an up fron L/C in the amount of $500K.  (See notes below)
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | x | x
Cash | x | x
MINIMUM TRANSFER $
COLLATERAL ROUNDING
Delivery Amount | 100000
Return Amount
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME])
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CP is to post an Independent Amount of $500,000 up front (they have agreed to post an L/C).  We will hold this amount
throughout the term of the deal.  Per our conversations with legal, I want to clarify that the L/C amount is to be held fully in tact
throughout the term of the deal.  The CP's collateral threshold is $400,000, so we will call for collateral when exposure exceeds the
amount of the L/C.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 269392d1381152500-how-do-you-list-unique-names-when-the-criteria-is-identical-listed-names
Sheet: Data

Name | Date | Time
Mr A | 2013-11-04 00:00:00 | 13
Mr B | 2013-11-04 00:00:00 | 13
Mr C | 2013-11-04 00:00:00 | 13
Mr D | 2013-11-04 00:00:00 | 13
Mr E | 2013-10-24 00:00:00 | 13
Mr F | 2013-10-24 00:00:00 | 13
Mr G | 2013-10-24 00:00:00 | 13
Mr H | 2013-10-24 00:00:00 | 13
The names, times and dates would just be entered in long list form by the user.
Spreadsheet: 845141d1696665463-generate-a-receipt-from-repeat-customer-file-hotel-2-aligw
Sheet: Receipt

 |  |  |  |  |  |  |  |  |  |  | Enter clients name | 1 [NAME]
 |  |  |  |  |  |  |  |  |  |  | Reservation | All
Receipt
Dates |  | Description |  | No. Nights | Price | Total Price
 |  | Room number
2024-01-11 00:00:00
 |  |  |  |  | Total price of stay
 |  |  |  |  | Tax
 |  |  |  |  | Deposits received
 |  |  |  |  | Total to Pay
Spreadsheet: 50202d1249579340-2007-drop-down-list-array-not-sure-cnp-purchase-order
Sheet: Sheet1

 | Effective from 1st April 2009
 | DISTRIBUTOR
 | Product |  |  | Flavour |  |  | Promassflavours | [NAME] | ProMRflavours | Propeptideflavours | ProMSflavours | ProGFflavours | ProSOLOflavours | Proenergyflavours | Prohydrateflavours | Proenergybarflavours | Proflapjackflavours
 | Pro-Mass 908g | 90 |  | Chocolate |  |  | Chocolate | Chocolate
 | [NAME] 2.27kg |  |  | [NAME] |  |  | [NAME] | Vanilla
 |  |  |  | Vanilla |  |  | Vanilla | [NAME]
 |  |  |  | [NAME] |  |  | [NAME]
 | Pro-Mass 2.5kg | 80 |  | Chocolate
 |  |  |  | [NAME]
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | Pro-Mass 4.5kg | 70 |  | Chocolate
 |  |  |  | [NAME]
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | [NAME] 2.27kg | 60 |  | Chocolate
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | Pro-MR 20 Sachets | 90 |  | Chocolate
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | Pro-Peptide 908g | 80 |  | Chocolate
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | Pro-Peptide 2.27kg | 70 |  | Chocolate
 |  |  |  | Vanilla
 |  |  |  | [NAME]
 | Pro-MS | 60
 | Pro-GF Nox | 50 |  | Lemonade
 |  |  |  | Fruit Punch
 | Pro-Solo, 1200g | 50
 | Pro-Energy, 500g | 60
 | Pro-Hydrate, 500g | 32
 | Pro-Energy Bar, 30 bars | 99
 | Pro-Flapjack Bars 24 | 55
 | Pro-Bar XS 12 off | 60
 | Pro-Dessert 15 off | 60
 | Pro-Tect 500g | 60
 | Pro-Creatine 100g | 32
 | Pro-Creatine 500g | 60
 | Pro-Fuel 1.8kg | 60
 | Pro-Recover | 60
 | Pro-Recover Shake N Take | 80
 | Pro-Recover 5kg | 60
 | Pro Slam 12 vials | 70
 | STANDARD RATED
 | Sports Bottle 750ml | 1
 | Sports Bottle 1000ml | 2
 | Pro-BCAA | 3
 | Pro-Gakic 416g | 4
 | Pro-CLA 1000mg 120 caps | 5
 | Pro-Aminos 500 caps | 6
 | Pro-Creatine E2, 240 caps, 500mg | 7
 | [NAME] –  120 caps | 8
 | Pro-Lean 90 caps | 9
 | Sida Cordifolia 120 tablets | 10 |  |  |  |  |  |  |  |  |  | Pro-Mass available in Strawberry, Chocolate, [NAME] and [NAME]
 | [NAME], 90 tablets | 11 |  |  |  |  |  |  |  |  |  | Whey Protein available in Strawberry, Chocolate and [NAME]
 | Pro-Vital | 12 |  |  |  |  |  |  |  |  |  | Pro-MR and Pro-Peptide available in Strawberry, Chocolate and [NAME]
 | Pro-Napalm Energy Drink 24 per box | 13 |  |  |  |  |  |  |  |  |  | Pro-MS available in Wild Berry & Cream, Swiss Chocolate and [NAME] Flavour
 | Pro-Glutamine 500g | 14 |  |  |  |  |  |  |  |  |  | Pro-Flapjack Bars available in Chocolate, Choc Orange & Cherry & Almond
 | Pro-HMB 120 caps. | 15 |  |  |  |  |  |  |  |  |  | Pro-Bar XS available in Peanut, [NAME], Caramel and Chocolate Chewy Crisp
 | CNP Professional [NAME] | 16 |  |  |  |  |  |  |  |  |  | Pro-Napalm available in Orange & Raspberry Flavour
 | [NAME] DVD | 17 |  |  |  |  |  |  |  |  |  | VAT AT 15% TO BE ADDED TO ALL STANDARD RATE PRODUCTS
 |  |  |  |  |  |  |  |  |  |  |  | CARRIAGE CHARGE AT £7 UPTO 20 KILOS AND 20P FOR EVERY KILO AFTER
 |  |  |  |  |  |  |  |  |  |  |  | NO CARRIAGE CHARGE ON ORDERS OVER £1000
Spreadsheet: 783491d1654866055-summarize-and-total-data-from-another-sheet-sample-excel-1-
Sheet: formulas

 | 16
- Creative Senior -Art Direction | 20
- Creative Director - Concepts | 2
- Production Manager | 1
- Creative Mid - Design & Amends | 16
- Creative Artworker | 12
- Production Manager | 1
- Account Director | 7
- Project Manager Senior | 13
 | 12
- Creative Director - Concepts | 2
- Production Manager | 1
- Creative Mid - Design & Amends | 8
- Creative Artworker | 8
- Account Director | 4
- Project Manager Senior | 8
 | 2
- Copywriter Senior | 0
- Copywriter Senior | 4
- Creative Senior -Art Direction | 0
- Creative Director - Concepts | 0
- Creative Director - Concepts | 0
- Creative Mid - Design & Amends | 0
- Creative Artworker | 4
- Account Director | 4
- Group Account Director | 0
- Project Manager Senior | 7.5
 | 0
- Copywriter Senior | 0
- Copywriter Senior | 0
- Creative Senior -Art Direction | 16
- Creative Senior -Art Direction | 0
- Creative Director - Concepts | 2
- Creative Mid - Design & Amends | 8
- Creative Artworker | 0
- Account Director | 0
- Project Manager Senior | 1.5
Spreadsheet: 718062d1612971315-sorting-two-columns-with-one-of-them-values-for-all-sheets-in-different-range-m1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sal1 | Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1363 | 2063.773333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1364 | 2044.143333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1365 | 2040.439
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1366 | 2023.559166666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1367 | 2027.713636363637
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1368 | 2101.793636363637
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1369 | 2059.026666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1370 | 2117.008333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1371 | 2125.174166666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1372 | 2130.446666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1373 | 2119.6825
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1374 | 2116.5075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1375 | 2118.261666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1376 | 2113.399166666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1377 | 2118.496666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1378 | 2110.8475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1379 | 2103.873333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1380 | 2102.259166666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1381 | 2116.975833333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1382 | 2117.5525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1383 | 2114.683333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1384 | 2116.369166666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1385 | 2125.504166666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1386 | 2123.415833333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1387 | 2110.879999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1388 | 2101.765
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1389 | 2063.8925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1390 | 2089.468333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1391 | 2031.871666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1392 | 2096.8425
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1393 | 2096.649166666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1394 | 2109.570833333334
Spreadsheet: 237821d1369317745-copy-row-that-contains-check-boxes-without-the-check-boxes-being-linked-dcva-install
Sheet: Sheet1

 |  |  |  | Requested / Needed | Authorization | Intall Date | Installed
 |  | 1 | Address |  |  |  |  |  | False | False | False | False
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
Spreadsheet: 811920d1672861441-how-to-calculate-half-day-in-excel-formula-halfdaycalculation-1-
Sheet: Sheet1

From Date | To date | Output | As per formula
2023-01-01 00:00:00 | 2023-01-03 00:00:00 | 3
2023-01-01 00:00:00 | 2023-01-01 12:00:00 | 0.5
2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 1
2023-01-01 00:00:00 | 2023-01-05 12:00:00 | 4.5
Spreadsheet: 819660d1677620481-dept-and-expense-type-match-to-calculate-total-amount-test-3-
Sheet: Table2

Budget Expenses | Attribute.1 | Totals
Employee Compensation | BDR | 1000
Employee Compensation | CSM | 2150
Employee Compensation | Marketing | 330784.14
Employee Compensation | Engineering | 248204.54
Employee Compensation | General and Administrative | 1070905.66
Employee Compensation | Product & Design | 1027589.99
Commission & Bonus | BDR | 350
Commission & Bonus | CSM | 315
Commission & Bonus | Marketing | 33078.414
Commission & Bonus | Engineering | 24820.454
Commission & Bonus | General and Administrative | 107090.566
Commission & Bonus | Product & Design | 102758.999
Payroll Taxes | BDR | 70
Payroll Taxes | CSM | 150.5
Payroll Taxes | Marketing | 23154.8898
Payroll Taxes | Engineering | 17374.3178
Payroll Taxes | General and Administrative | 74963.3962
Payroll Taxes | Product & Design | 71931.2993
Health Benefits | BDR | 0
Health Benefits | CSM | 50
Health Benefits | Marketing | 150
Health Benefits | Engineering | 100
Health Benefits | General and Administrative | 50
Health Benefits | Product & Design | 50
Third Party Services | BDR | 1000
Third Party Services | CSM | 5000
Spreadsheet: 605493d1547116482-data-required-in-a-easy-way-in-a-complex-file-18-19-costing1
Sheet: Result-WANT

imp | CODE | SID      PRODUCT NAME | QUANTITY | ACP SYSTEMS | a |  | RATE        AMOU | NT       AMOUNT | AMOUNT