tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 5th ba

S. No | Register No | Student Name
1 | 127087001 | Abri
2 | 127087002 | Aish
3 | 127087003 | [NAME]
4 | 127087005 | Anes
5 | 127087006 | Ansh
6 | 127087008 | Arav
7 | 127087009 | [NAME]
8 | 127087010 | Dine
9 | 127087011 | Divi
10 | 127087012 | Gang
11 | 127087013 | [NAME]
12 | 127087014 | Hari
13 | 127087015 | Hari
14 | 127087016 | Hari
15 | 127087017 | Hars
16 | 127087018 | [NAME]
17 | 127087019 | Kabi
18 | 127087020 | [NAME]
19 | 127087021 | Kiru
20 | 127087023 | [NAME]
21 | 127087024 | [NAME]
22 | 127087025 | Madh
23 | 127087026 | Mana
24 | 127087027 | Mara
25 | 127087028 | Math
26 | 127087029 | Medi
27 | 127087030 | Meer
28 | 127087031 | Moha
29 | 127087007 | Anus
30 | 127087022 | L Sw
31 | 127087032 | Nare
32 | 127087033 | Niki
33 | 127087034 | Padm
34 | 127087035 | Padm
35 | 127087036 | Pran
36 | 127087037 | [NAME]
37 | 127087038 | Prit
38 | 127087039 | Radh
39 | 127087040 | Ragh
40 | 127087041 | Ragu
41 | 127087042 | Ruba
42 | 127087043 | Sibi
43 | 127087044 | Saik
44 | 127087045 | Sanj
45 | 127087046 | Sara
46 | 127087047 | Sath
47 | 127087048 | Savi
48 | 127087049 | [NAME]
49 | 127087050 | Shri
50 | 127087051 | [NAME]
51 | 127087052 | Siva
52 | 127087053 | Soor
53 | 127087054 | Sree
54 | 127087055 | Sudh
55 | 127087056 | Vasu
56 | 127087057 | Vish
57 | 127087058 | Viwi
58 | 127087059 | [NAME]
Spreadsheet: 744425d1629227709-extract-a-specific-number-of-rows-fulfilling-different-criteria-selector
Sheet: Selector

[NAME]
Red | 2
Yellow | 3
Blue | 1
Expected output
Randomly selected people:
Num | Name | Category
7 | [NAME] | Red
15 | [NAME] | Red
12 | [NAME] | Yellow
17 | [NAME] | Yellow
19 | [NAME] | Yellow
8 | [NAME] | Blue
Spreadsheet: 833235d1686850858-the-sum-of-rounded-cells-do-not-equal-original-total-sample
Sheet: Sheet1

Exact
Share Quantity | Person 1 | Person 2 | Person 3 |  | Total
225.33
Rounded
Share Quantity | Person 1 | Person 2 | Person 3
225.33
Spreadsheet: 29c10253-f0e8-4100-ae88-8ac0e282b385
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Jan | Feb | Mar | Apr | May | Jun
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012
Exports | All wheat grain | 71446.9193831526 | 68957.24431477141 | 86770.22803909531 | 103778.2448934 | 102576.0726739014 | 89731.37261877392
 | All wheat flour 1/ | 766.4467702242576 | 727.3769051867293 | 1151.665442573141 | 779.6496041287545 | 1527.901404826926 | 1263.825520116423
 | All wheat products 2/ | 564.9332796612777 | 720.1099419000454 | 731.1408444789557 | 861.8054622245811 | 975.2385292682454 | 617.8757592016249
 | Total all wheat | 72778.29943303815 | 70404.73116185819 | 88653.0343261474 | 105419.6999597533 | 105079.2126079966 | 91613.07389809197
Imports | All wheat grain | 7600.2476502603 | 7262.404908089101 | 10449.5319510246 | 6495.080158278601 | 4186.141397718001 | 4726.423628526601
 | All wheat flour 1/ | 1015.848956093801 | 823.7276552796671 | 863.686902021029 | 978.440444345295 | 867.4603488933402 | 793.2286682783293
 | All wheat products 2/ | 1588.438507200813 | 1267.596672426241 | 1710.450728002489 | 1657.370215401004 | 1677.292165589732 | 1397.121265980524
 | Total all wheat | 10204.53511355492 | 9353.729235795008 | 13023.66958104812 | 9130.8908180249 | 6730.893912201073 | 6916.773562785454
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 9/17/2012
Spreadsheet: 15577304-6104-4993-a5b1-71e06472c518
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Ordinary Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2711578A | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2713440W | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2711844F | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2713706V | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2713174T | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2712110L | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2712908X | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | A2712642A | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2712376W | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 267708d1380144115-help-with-solver-as-solver-gives-wrong-answer-help
Sheet: Q1

Enter Age | 22
Preferred Ticket Location | [NAME]
Price of Ticket
 | 22 and under | over 22
Premier Tickets | 65 | 90
[NAME] | 50 | 70
Balcony Tickets | 30 | 30
Standing Room | 15 | 20
Test Case 1
Enter Age | 50
Preferred Ticket Location | Premier Tickets
Price of Ticket
Test Case 2
Enter Age | 18
Preferred Ticket Location | Standing Room
Price of Ticket
Spreadsheet: 111514d1307896998-formula-to-search-sheet-1-for-specifc-case-and-then-copy-criteria-into-sheet-2-book1_abw
Sheet: Sheet1

First Name |  |  |  |  |  |  |  |  |  |  |  | Criteria
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Criteria 1
Holden |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Harper |  |  |  |  |  |  |  |  |  |  |  | Criteria 3
Leopold |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Rabbit |  |  |  |  |  |  |  |  |  |  |  | Criteria 5
Sherlock |  |  |  |  |  |  |  |  |  |  |  | Criteria 6
Atticus |  |  |  |  |  |  |  |  |  |  |  | Criteria 7
Molly |  |  |  |  |  |  |  |  |  |  |  | Criteria 8
Stephen |  |  |  |  |  |  |  |  |  |  |  | Criteria 9
Lily |  |  |  |  |  |  |  |  |  |  |  | Criteria 10
Holly |  |  |  |  |  |  |  |  |  |  |  | Criteria 11
Gregor |  |  |  |  |  |  |  |  |  |  |  | Criteria 12
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Criteria 13
Aureliano |  |  |  |  |  |  |  |  |  |  |  | Criteria 14
Clarissa |  |  |  |  |  |  |  |  |  |  |  | Criteria 15
Ignatius |  |  |  |  |  |  |  |  |  |  |  | Criteria 16
George |  |  |  |  |  |  |  |  |  |  |  | Criteria 17
Virginia |  |  |  |  |  |  |  |  |  |  |  | Criteria 18
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Criteria 19
Nick |  |  |  |  |  |  |  |  |  |  |  | Criteria 20
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Criteria 21
Spreadsheet: 1d3de103-de32-484e-846e-a49f1b057767
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | York College
 |  | FOR CLASSIFIED MANAGERS |  |  |  | Month/Year
 |  | EMPLOYEE NAME:
 |  | DEPT/UNIT/LOCATION:
 |  | SUPERVISOR NAME:
 |  | TIMEKEEPER NAME:
DAY OF MONTH | SICK LEAVE TAKEN (in hours) | ANNUAL LEAVE TAKEN (in hours) | UNSCHEDULED HOLIDAY LEAVE TAKEN (in hours) | OTHER LEAVE TAKEN (in hours)                 see instructions |  | Instructions
1
2 |  |  |  |  |  | Complete top section of form
3
4
5 |  |  |  |  |  | If you did not work a scheduled day, enter the number of hours in the appropriate column.  Remember that summer days count as 8.75 hours
6
7
8
9
10
11 |  |  |  |  |  | Sign and date the form and submit it to your supervisor for signature.  Keep a copy.
12
13
14
15
16 |  |  |  |  |  | All signatures are required.
17
18
19 |  |  |  |  |  | Other Leave - please indicate the type of leave in the column:
20
21 |  |  |  |  |  | H- Legal Holiday
22
23 |  |  |  |  |  | [NAME] (attach documentation)
24
25 |  |  |  |  |  | BL- [NAME] (attach documentation)
26
27 |  |  |  |  |  | ML- Military Leave (attach documentation)
28
29 |  |  |  |  |  | FML- Approved Family Medical Leave (contact Human Resources)
30
31
TOTAL | 0 | 0 | 0
Employee Signature: |  |  | Date: | Tel: |  | If you did not take off any time this month,  please check here
Timekeeper Signature: |  |  | Date: | Tel:
Supervisor Signature: |  |  | Date: | Tel:
Spreadsheet: 663c62ff-866f-4931-a2e7-44ea75f42b4e
Sheet: Sheet1

Release: BEA Regions Employment and Unemployment | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=138
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-19 7:32 PM CST
 | Real-Time | Period
Name: | Start | End
BEA Regions Employment and Unemployment | 2007-07-20 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2007-07-20 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-07-20 00:00:00
2007-08-17 00:00:00
2007-09-25 00:00:00
2007-10-19 00:00:00
2007-11-28 00:00:00
2007-12-21 00:00:00
2008-01-18 00:00:00
2008-03-11 00:00:00
2008-03-28 00:00:00
2008-04-18 00:00:00
2008-05-16 00:00:00
2008-06-20 00:00:00
2008-07-18 00:00:00
2008-08-15 00:00:00
2008-09-19 00:00:00
2008-10-21 00:00:00
2008-11-21 00:00:00
2008-12-19 00:00:00
2009-01-27 00:00:00
2009-02-27 00:00:00
2009-03-11 00:00:00
2009-03-27 00:00:00
2009-04-17 00:00:00
2009-05-22 00:00:00
2009-06-19 00:00:00
2009-07-17 00:00:00
2009-08-21 00:00:00
2009-09-18 00:00:00
2009-10-21 00:00:00
2009-11-20 00:00:00
2009-12-18 00:00:00
2010-01-22 00:00:00
2010-03-10 00:00:00
2010-03-26 00:00:00
2010-04-16 00:00:00
2010-05-21 00:00:00
2010-06-18 00:00:00
2010-07-20 00:00:00
2010-08-20 00:00:00
2010-09-21 00:00:00
2010-10-22 00:00:00
2010-11-23 00:00:00
2010-12-17 00:00:00
2011-01-25 00:00:00
2011-03-10 00:00:00
2011-03-25 00:00:00
2011-04-19 00:00:00
2011-05-20 00:00:00
2011-06-17 00:00:00
2011-07-22 00:00:00
2011-08-19 00:00:00
2011-09-16 00:00:00
2011-10-21 00:00:00
2011-11-22 00:00:00
2011-12-20 00:00:00
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
2014-04-18 00:00:00
2014-05-16 00:00:00
2014-06-20 00:00:00
2014-07-18 00:00:00
2014-08-18 00:00:00
2014-09-19 00:00:00
2014-10-21 00:00:00
2014-11-21 00:00:00
2014-12-19 00:00:00
Spreadsheet: 841168d1693405276-total-each-poker-players-best-25-weeks-over-four-sheets-sample_best-25-sort
Sheet: 4th Qtr

 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | [NAME]. | 1st Qtr. | 2nd Qtr. | [NAME]. | Yearly | Best 25 | Weeks
Rank | Player | 2023-07-09 00:00:00 | 2023-07-16 00:00:00 | 2023-07-23 00:00:00 | 2023-07-30 00:00:00 | 2023-08-06 00:00:00 | 2023-08-13 00:00:00 | 2023-08-20 00:00:00 | 2023-08-27 00:00:00 | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | Total | Total | Total | Total | Total | Total 1 | Played
1 | Amad | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | BamaT8er | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | Bdshort14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Beakertwang | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | Billydice55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | BillyMadison | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | Burke | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | CallStation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
9 | DoubleEagle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | eightyWon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | FCSD36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | Gator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | Headhunter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | IaHawk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | JeffW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | JoeSensitive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | LaCroix238 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | moose | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | Pokerdoc13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | Rasty99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | RickNice | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | Rocket19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | shorticus | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | sicko | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 | ThePiper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32 | Treebarkx | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
33 | TX_Tiger | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
34 | Wimp85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
35 | win-winjd | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
36 | Zscharps | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 66780d1267471679-if-functionality-insertion-ebay-pricing
Sheet: eBay customers

Item Code | Description | Level 3 | EOQ | Length | [NAME] | Height | [NAME] | Ship Weight | [NAME] | [NAME] | [NAME] | Average Shipping Cost | UPC | Site | Status | Backordered Until | Item Active | Item Web Active | value | Dealer dollar margin | buy it now price
5JB-1010 | Antique Pine Bellows | 32.7 | 1 | 24 | 12 | 8 | 1.93 | 2 | F | F | F | 7 |  | WDZ |  |  | T | T | 57.8
Ok I have some ebay dealers that buy product from us, and we have to determine if the product is going to make the dealer money or not.
there are eBay fees and such that we would like to put into the cost of the product and show the Dealer their end profit on the product when they put it on eBay, this will also help us determine
if we should even offer it to the eBay dealer in the first place, listed below is what I need to do and ive tried to get it but I couldn’t figure it out
thanks in advance for your help.
step 1. | Step 2 | step 3 | step 4
need to take the value in T2 and subtract it from [NAME] and get the difference, that will be the number being used for the rest ,,that number is in U2 | the I need to subtract $.35 from U2 for the insertion fee | then I need to subtract $.10 from U2 if the value (see T2 for value) is lower than $25 ,,,or subtract $.20 from U2 if the value (see T2 for value) is between 25 and 49.99,, or subtract $.25 from U2  if the value (see T2 for value) is over $50.00 (the valse is located in T2) | then I need to subtract  the percentages in the chart below
Percentage chart
Item value
$0.01 - $50.00 | 12.00% of the closing value | if the value  (t2) is below $50, 12% needs to be deducted from the remainder of step 3
$50.01 - $1,000.00 | 12.00% of the initial $50.00, plus 6.00% of the remaining closing value balance ($50.01-$1,000.00) | so if T2 is over 50 and between 1000, 12% needs to be deducted from the remainder of whats left in step 4 and an additional 6 % of the remainder of T2(above $50) which in this case is $7.80
Equal to or Over $1,000.01 | 12.00% of the initial $50.00, plus 6.00% of the initial $50.01-$1,000.00, plus 2% of the remaining closing value balance ($1,000.01 - closing value) | same thing as above but any thing that has a value over 1000.01
Spreadsheet: 820596d1678189689-stuck-with-an-easy-formula-many-variants-of-one-formula-for-one-cell-please-help-report-price-calculator-etaf-etaf-
Sheet: Feuil1

WEIGHT | ROUNDED WEIGHT | FORMULA | PRICE in USD | VALUES WEIGHT RANGE 1 | VALUES WEIGHT RANGE 2 | VALUES PRICE
0.16 |  |  |  | 0.15 | 0.22 | 48
0.17 |  |  |  | 0.23 | 0.46 | 59
0.7 |  |  |  | 0.47 | 0.69 | 64
0.5 |  |  |  | 0.7 | 0.99 | 78
41 |  |  |  | 1 | 1.19 | 113
12222 |  |  |  | 1.2 | 1.49 | 118
0.1 |  |  |  | 1.5 | 1.99 | 135 |  |  | [NAME] | [NAME]
0.12 |  |  |  | 2 | 2.99 | 189
55 |  |  |  | 3 | 3.99 | 278
 |  |  |  | 4 | 4.99 | 373
 |  |  |  | 5 | 5.99 | 535
 |  |  |  | 6 | 7.99 | 631
 |  |  |  | 8 | 9.99 | 747
 |  |  |  | 10 | 11.99 | 1034
 |  |  |  | 12 | 14.99 | 1219
 |  |  |  | 15 | 19.99 | 1484
 |  |  |  | 20 | 24.99 | 1935
 |  |  |  | 25 | 29.99 | 2253
 |  |  |  | 30 | 39.99 | 2730
 |  |  |  | 40 | 49.99 | 3233
 |  |  |  | 50.00 and above | upon written request
Spreadsheet: 268333d1380568551-countbycolor-help-to-change-formula-around-sample
Sheet: Analysis

 | Department Analysis
 | July 8 - September 1, 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July 8 - Sep 01
 | July 8 - July 31 |  |  |  |  |  |  | August 1 - August 31 |  |  |  |  |  |  | September 1
 | Day | Nights | Overtime | Vacation | Sick | Blue |  | Days | Nights | Overtime | Vacation | Sick | Blue |  | Days | Nights | Overtime | Vacation | Sick | Blue |  | 8 weeks | Days | Nights
[NAME] | 6 | 6 | 0 | 0 | 0 | 0 |  | 8 | 7 | 1 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 |  | 28 | 14 | 14
[NAME] | 5 | 6 | 0 | 0 | 1 | 0 |  | 8 | 7 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 |  | 28 | 13 | 14
Greg | 6 | 5 | 0 | 1 | 0 | 0 |  | 8 | 7 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 |  | 28 | 14 | 13
[NAME] | 5 | 6 | 0 | 0 | 0 | 1 |  | 8 | 7 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 |  | 27 | 13 | 14
[NAME] | 6 | 6 | 1 | 0 | 0 | 0 |  | 8 | 7 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 |  | 28 | 14 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department |  | 139 | 68 | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 725410d1616670396-how-do-i-convert-a-table-with-individual-dates-to-a-table-with-date-ranges-test
Sheet: New table

RecordID | Name | Jan - Apr (Range1) | May - Aug (Range2) | Sep - Dec (Range3) |  |  |  | Date Range | Range Start Day | Range End Day
1 | [NAME] |  |  |  |  |  |  | Range1 | 2021-01-01 00:00:00 | 2021-04-30 00:00:00
2 | [NAME] |  |  |  |  |  |  | Range2 | 2021-05-01 00:00:00 | 2021-08-31 00:00:00
3 | [NAME] |  |  |  |  |  |  | Range3 | 2021-09-01 00:00:00 | 2021-12-31 00:00:00
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | [NAME]
20 | [NAME]
21 | [NAME]
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | [NAME]
27 | [NAME]
28 | [NAME]
29 | [NAME] |  | 23.08.2021 - 31.08.2021 | 01.09.2021 - 03.09.2021
30 | [NAME]
31 | [NAME]
Spreadsheet: andy_zipper__794__10_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 196 | 204 | 49 | 51 | 0.69 | 2001-10-26 14:41:00
 | CL F2 | 22 | 328 | 338 | 51.3 | 52.9 | 0.72 | 2001-10-26 14:41:00
 | CL G2 | 22.5 | 423 | 438 | 50.3 | 52 | 0.72 | 2001-10-26 14:41:00
 | CL H2 | 22.5 | 475 | 485 | 48.7 | 49.7 | 0.7 | 2001-10-26 14:41:00
 | CL J2 | 22.5 | 502 | 517 | 46 | 47.4 | 0.66 | 2001-10-26 14:41:00
 | CL K2 | 22.5 | 520 | 535 | 43 | 44.3 | 0.62 | 2001-10-26 14:41:00
 | CL M2 | 22 | 540 | 548 | 42.5 | 43.1 | 0.59 | 2001-10-26 14:41:00
 | CL N2 | 22 | 545 | 560 | 40 | 41.1 | 0.56 | 2001-10-26 14:41:00
 | CL Q2 | 22 | 550 | 565 | 38.1 | 39.2 | 0.53 | 2001-10-26 14:41:00
 | CL U2 | 22 | 555 | 570 | 36.7 | 37.7 | 0.51 | 2001-10-26 14:41:00
 | [NAME] | 22 | 560 | 575 | 35.3 | 36.2 | 0.49 | 2001-10-26 14:41:00
 | CL X2 | 22 | 562 | 575 | 34 | 34.8 | 0.48 | 2001-10-26 14:41:00
 | [NAME] | 22 | 565 | 575 | 33 | 33.6 | 0.46 | 2001-10-26 14:41:00
 | CL M3 | 21.5 | 550 | 570 | 27.9 | 28.9 | 0.38 | 2001-10-26 14:41:00
 | CL Z3 | 21.5 | 550 | 570 | 24.8 | 25.8 | 0.34 | 2001-10-26 14:41:00
Spreadsheet: 862962d1710516115-display-rows-from-matching-data-sorting
Sheet: Sheet2

 | Tensile | Mod | Elog | [NAME] | Hardness | Tear
AP-50388 | 10.982 | 2.932 | 402.956 | 1.42 | 69 | 42.628
AP-50406 | 10.568 | 3.052 | 384.582 | 1.37 | 69 | 41.89
[NAME] | 11.62 | 3.412 | 363.658 | 1.38 | 69 | 44.304
AN-51117 | 11.21 | 3.606 | 439.374 | 1.44 | 65 | 59.644
AO-50421 | 11.746 | 2.226 | 486.476 | 1.45 | 126 | 57.128
AO-50430 | 11.98 | 2.234 | 503.002 | 1.45 | 65 | 55.89
AO-50435 | 11.668 | 2.41 | 555.353 | 1.54 | 68 | 54.72
AO-50642 | 10.854 | 2.054 | 504.234 | 1.41 | 69 | 50.01
AO-50647 | 11.242 | 2.084 | 502.346 | 1.46 | 66 | 57.412