tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 488297d1478611409-help-with-inventory-table-colorcodes
Sheet: Sheet1

Serialcode | color |  |  |  |  |  |  |  | colorcode | color
123456-10 |  |  |  |  |  |  |  |  | 10 | blue
123456-12 |  |  |  |  |  |  |  |  | 11 | green
12586-10 |  |  |  |  |  |  |  |  | 12 | yellow
125866-13 |  |  |  |  |  |  |  |  | 13 | red
125876-14 |  |  |  |  |  |  |  |  | 14 | black
Spreadsheet: 867526d1714385685-average-speed-of-the-7-machines-that-start-the-earliest-testfile-average-speed-if-aligw
Sheet: Blad1

Machine | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Speed | 5 | 5 | 6 | 6 | 5 | 5 | 10 | 10 | 11 | 11 | 10 | 11 | 6
Starttime | 07:00:00 | 07:01:00 | 07:02:00 | 07:03:00 | 07:04:00 | 07:05:00 | 08:02:00 | 08:03:00 | 08:04:00 | 08:05:00 | 08:06:00 | 08:07:00 | 07:04:00
Average first 7 |  | Expected outcome= average of the speed of machine 1-6 and 13
Is there a way I can get B5 to result in the average speed of the 7 machines that started the earliest?
In the first case it is machine 1-6 and 13 however it could be different like scenario 2 eg 1-3, 7, 8, 11, 13. In that case I still want the average speed of the earliest machines
Scenario 2
Machine | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Speed | 5 | 5 | 6 | 6 | 5 | 5 | 10 | 10 | 11 | 11 | 10 | 11 | 6
Starttime | 07:00:00 | 07:01:00 | 07:02:00 | 08:02:00 | 08:03:00 | 08:04:00 | 07:03:00 | 07:04:00 | 08:06:00 | 08:05:00 | 07:05:00 | 08:07:00 | 07:04:00
Average first 7 |  | Expected outcome= average of the speed of machine 1-3, 7, 8, 11 and 13
So far I have tried =Average(IF(X36:AJ36<Average(X36:AJ36);X35:AJ35;"")) but when the start times are closer or there is an outlier, together this will not work.
Spreadsheet: 59052d1259430019-find-row-combined-with-another-test-case-problems
Sheet: 123

MATCH | NEW VALUE | 123
6 | -1560
51 | 33540
66 | 23620
151 | 2760
164 | 13440
169 | #N/A
172 | -6620
181 | 13760
200 | 26700
232 | #N/A
56 | 6200
191 | 19800
198 | #N/A
206 | #N/A
213 | 15780
68 | 7440
215 | 19740
230 | 7660
3502 | 4580
183 | 6700
644 | 11688
645 | 7008
262 | 42220
266 | 15240
678 | 164
3518 | 9528
3526 | 2
3562 | 20
3570 | 12780
3571 | 3600
358 | 37560
116 | 43060
73 | 1900
243 | 24480
190 | 4420
225 | 38660
193 | 3070
197 | 1570
201 | 3140
5300 | 12432
5301 | 44224
762 | 5740
723 | 38860
724 | 8080
730 | 10246
738 | 22786
806 | 189792
809 | 79078
813 | 85460
783 | 27580
703 | 76032
772 | -50330
773 | 62800
778 | 7920
782 | 1060
785 | 2000
876 | #N/A
877 | #N/A
925 | #N/A
885 | #N/A
887 | #N/A
879 | #N/A
743 | 80904
749 | 304
761 | 48100
763 | 3800
769 | 21760
789 | 1360
Spreadsheet: 867267d1714117959-complex-transpose-problem-example-report-1-
Sheet: Sheet1

 | The table has 350+ lines and the quantity columns go up to 10, so not a huge amount of data, but too much to do manually.
 | And this is also a nice exercise for me to improve my Excel skills.
 | Starting table |  |  |  |  |  |  |  | Desired output
 | Item | 1 | 2 | 3 | 4 | 5 |  |  | item | qty | price |  |  | qty | price
 | aaa | 10 | 9 | 8 |  |  |  |  | aaa | 1 | 10 |  | aaa | 1 | 10
 | bbb | 15 |  |  |  |  |  |  | aaa | 2 | 9 |  | aaa | 2 | 9
 | [NAME] | 20 | 18 | 16 | 15 | 14 |  |  | aaa | 3 | 8 |  | aaa | 3 | 8
 | ddd | 10 | 8 | 6 | 5 | 4 |  |  | bbb | 1 | 15 |  | bbb | 1 | 15
 | eee | 30 | 25 | 22 |  |  |  |  | [NAME] | 1 | 20 |  | [NAME] | 1 | 20
 |  |  |  |  |  |  |  |  | [NAME] | 2 | 18 |  | [NAME] | 2 | 18
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 16 |  | [NAME] | 3 | 16
 |  |  |  |  |  |  |  |  | [NAME] | 4 | 15 |  | [NAME] | 4 | 15
 |  |  |  |  |  |  |  |  | [NAME] | 5 | 14 |  | [NAME] | 5 | 14
 |  |  |  |  |  |  |  |  | ddd | 1 | 10 |  | ddd | 1 | 10
 |  |  |  |  |  |  |  |  | ddd | 2 | 8 |  | ddd | 2 | 8
 |  |  |  |  |  |  |  |  | ddd | 3 | 6 |  | ddd | 3 | 6
 |  |  |  |  |  |  |  |  | ddd | 4 | 5 |  | ddd | 4 | 5
 |  |  |  |  |  |  |  |  | ddd | 5 | 4 |  | ddd | 5 | 4
 |  |  |  |  |  |  |  |  | eee | 1 | 30 |  | eee | 1 | 30
 |  |  |  |  |  |  |  |  | eee | 2 | 25 |  | eee | 2 | 25
 |  |  |  |  |  |  |  |  | eee | 3 | 22 |  | eee | 3 | 22
Spreadsheet: 867335d1714151630-randomize-golf-teams-based-on-skill-level-teams
Sheet: Generator

 | PLAYERS IN EACH TEAM
 | 5
SKILL | PLAYERS | RANDOM | RANK | GROUPING | TEAM | PRESENT |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
3 | [NAME] |  |  |  |  | X
1 | [NAME] |  |  |  |  | X
3 | [NAME] |  |  |  |  | X
2 | [NAME] |  |  |  |  | X
3 | Bayless Fields |  |  |  |  | X
2 | [NAME]
1 | [NAME]
1 | [NAME]
2 | [NAME] |  |  |  |  | X
3 | Chase Martin |  |  |  |  | X
1 | Curtis Trew |  |  |  |  | X
2 | [NAME] |  |  |  |  | X
3 | [NAME] |  |  |  |  | X
2 | [NAME] |  |  |  |  | X
3 | [NAME]
3 | [NAME] |  |  |  |  | X
2 | [NAME]
1 | [NAME]
1 | [NAME]
2 | [NAME] |  |  |  |  | X
3 | [NAME] |  |  |  |  | X
3 | Kaci Reiter |  |  |  |  | X
3 | [NAME]
2 | [NAME] |  |  |  |  | X
3 | [NAME]
3 | [NAME]
3 | [NAME]
1 | [NAME] |  |  |  |  | X
2 | [NAME] |  |  |  |  | X
3 | [NAME]
3 | [NAME] |  |  |  |  | X
1 | [NAME] |  |  |  |  | X
2 | [NAME]
2 | Tyler Reed
Spreadsheet: 872052d1718394729-automation-of-rotating-rows-test-excel_2
Sheet: Sheet1

Name | Date | Information |  |  |  | Name | Date | Information
[NAME] | 2023-08-01 00:00:00 | follow up 12/1
[NAME] | 2024-01-01 00:00:00 | follow back 6/2
[NAME] | 2023-02-09 00:00:00 | success
[NAME] | 2024-06-01 00:00:00 | stop payment
Nate | 2023-12-15 00:00:00 | call back Thursday
Spreadsheet: c22cb442-d41b-43dd-832b-82fd80bd32f5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
STUDENT'S NAME (Please Print) |  |  |  |  | ID NUMBER
CURRENT MAJOR |  |  |  |  | MAJOR DECLARING
NOTIFICATION:
CURRENT ADVISOR |  |  |  |  | NEW ADVISOR
CHAIR OF CURRENT DEPARTMENT |  |  |  |  | CHAIR OF NEW DEPARTMENT
DEAN OF CURRENT DEPARTMENT |  |  |  |  | DEAN OF NEW DEPARTMENT
STUDENT'S SIGNATURE |  |  |  |  | DATE
Please return form to : |  |  | Office of Admissions & Academic Records
 |  |  | Room 220 - Administration Building
 |  |  | University of Arkansas at Pine Bluff
 |  |  | 1200 North University Drive
 |  |  | Pine Bluff, Arkansas 71601-2799
Spreadsheet: 869264d1715871072-duplicate-product-ids-with-various-qtys-sample
Sheet: Sheet2

PartID | [NAME] | QTY/Kit
K03800 | F05100 | 1
K03800 | F05400 | 2
K03800 | F16500 | 2
K03800 | F30300 | 2
K03800 | F36600 | 2
K03800 | T00018 | 1
K03900 | F07200 | 20
K03900 | F07500 | 20
K03900 | F07600 | 20
K03900 | F16400 | 4
K03900 | F30300 | 4
K03900 | F36600 | 4
K03900 | F36700 | 20
Spreadsheet: 269115d1380966886-need-the-sum-of-50-lookups-help-2-
Sheet: Sheet1

total | 4779454.03 |  | 21972741.88
div1 depts | Current Month Inventory - Retail (Incl. Shrink) (current year) |  | YTD  Merchandise & Service Sales (previous year) |  | 2 examples
2 | 203098.5 |  | 1448735.82
3 | 167765.74 |  | 460581.93
4 | 48164.36 |  | 1054866.67
5 | 296598.59 |  | 877339.22
7 | 306525.13 |  | 617538.86
8 | 132095.16 |  | 1375001.09
9 | 403468.24 |  | 762592.16
11 | 182456.03 |  | 525516.62
12 | 71622.68 |  | 168986.83
13 | 104290.85 |  | 1102992.83
14 | 159614.01 |  | 431171.77
15 | -67.7 |  | 71.6
16 | 77942.7 |  | 850399.38
17 | 159304.16 |  | 308103.38
18 | 49858.09 |  | 69021.91
19 | 152634.31 |  | 151592.22
20 | 62429.86 |  | 155598.64
21 | 34321.4 |  | 203189.55
22 | 138351.06 |  | 287824.46
24 | 60330.97 |  | 138830.3
26 | 73948.78 |  | 194830.4
27 | 35175.39 |  | 35460.78
28 | 17446.31 |  | 14368.96
29 | 63562.88 |  | 144690.03
30 | 83317.33 |  | 118106.68
31 | 50384.78 |  | 53475.38
33 | 85526.33 |  | 175122.62
34 | 150493.79 |  | 419528.39
35 | 26751.88 |  | 92191.33
36 | 5527.68 |  | 60450.23
46 | 279502.44 |  | 704446.57
56 | 6202.68 |  | 163026.46
60 | 2741.6 |  | 6766
67 | 32574.23 |  | 333854.72
69 | -1335.87 |  | -393.2
71 | 47037.69 |  | 126664.53
72 | 526091.15 |  | 1335444.97
73 | 0 |  | 0
74 | 99304.89 |  | 385533.49
77 | -49 |  | 0
78 | -6.85 |  | 148.15
79 | 137484.76 |  | 862595.99
80 | 44329.62 |  | 1033742.58
82 | 202637.4 |  | 606146.24
83 | 0 |  | 118578.15
84 | 0 |  | 270.77
93 | 0 |  | 1727756.34
94 | 0 |  | 1866573.61
98 | 0 |  | 403406.47
Spreadsheet: 149898d1334177056-trying-to-accomplish-several-things-temp
Sheet: temp

 |  |  | Bank | 30 |  | TSC Dunlap
 |  |  | Dollar General | 25
 |  |  | [NAME] | 62
 |  |  | TSC Dunlap | 26
 |  |  | [NAME] | 42
 |  |  | Attorney | 68
 |  |  | Recycling | 10
 |  |  | Post Office | 12
 |  |  | [NAME] | 28
 |  |  | TSC Kimball | 42
 |  |  | Northern Tool | 74
 |  |  | Smith Hardware | 10
 |  |  | Tri State AG | 168
 |  |  | [NAME] | 102
 |  |  | HH [NAME] | 120
 |  |  | [NAME] | 70
 |  |  | SS [NAME] | 100
 |  |  | Raceway | 12
 |  |  | Best Buy | 62
 |  |  | Walmart Dunlap | 28
 |  |  | Walmart Kimball | 42
 |  |  | Office Depot Hx | 60
 |  |  | [NAME] | 64
 |  |  | ATT Store Hx | 62
 |  |  | Hi Tech Gas | 26
 |  |  | [NAME] | 62
Spreadsheet: 682437d1592098154-sumif-depending-on-a-data-validation-amendedinventory
Sheet: Sheet2

Adidas Athletics 24/7 blue | 8.5 | 2387
Adidas Athletics Teal | 8 | 2500
Air Huarache [NAME] | 8.5 | 3923
Air Huarache [NAME] | 9 | 3923
Air Huarache [NAME] | 10 | 3923
Alpha Bounce Dark Gray | 9 | 2600
Alpha Bounce Maroon Comb White | 7.5 | 2295
Arkyn Cargo | 6.5 | 3000
Arkyn Cargo | 5.5 | 3000
Arkyn Cargo | 8 | 3000
Arkyn Orange | 5.5 | 2942
Crazy Train Lt M Gray | 6.5 | 4330
Gazelle Red | 8 | 3000
[NAME] | 6.5 | 2295
Gazelle Royal Blue | 6 | 2295
Gazelle Royal Blue | 8.5 | 2295
POD-S3 W Lavender | 5.5 | 2850
POD-S3 W Lavender | 6 | 2850
[NAME] x Trainer Blue/White Straps | 7.5 | 3220
[NAME] x Trainer Blue/White Straps | 7 | 3220
[NAME] x Trainer Blue/White Straps | 6 | 3220
[NAME] x Trainer Blue/White Straps | 8 | 3220
Solar Boost Weaving M Black/Orange | 9.5 | 7105
Solar Glide M Gray/Red | 8 | 2850
Solar Glide M Gray/Red | 10 | 2850
Solar Glide ST W Blue | 7 | 2800
Solar Glide ST W Blue | 7.5 | 2800
[NAME] | 7 | 2480
Tubular Shadow W Black | 5 | 2572
Tubular Shadow W Black | 6 | 2572
Tubular Shadow W Black | 7 | 2572
Tubular Shadow W Black | 7.5 | 2572
Tubular Shadow W Black | 8 | 2572
Tubular Shadow W Black | 6.5 | 2572
UltraBoost Black Carbon Ash | 9.5 | 6180
UltraBoost Blue | 10 | 6180
UltraBoost Laceless Mint | 8.5 | 6180
UltraBoost x [NAME] | 8.5 | 4145
UltraBoost x [NAME] | 5.5 | 4145
Vans Old Skool Marshmallow | 8 | 4000
Vans Old Skool Rose | 8 | 4000
Adidas ZX RM 500 [NAME] | 10 | 6180
EQT Support 91/48 | 9 | 5625
Nike Exp - Z07 SE | 8 | 3183
Nike Exp - Z07 SE | 9.5 | 3183
[NAME] | 8 | 5000
[NAME] | 8.5 | 5000
[NAME] | 9 | 5000
[NAME] | 10 | 5000
Spreadsheet: 785641d1656520037-help-with-formula-sum-ifs-sumifshelp
Sheet: Drop Down

Drop Down Menus
[NAME] | [NAME] | Day | Special | Type
Non Platform | Yes |  | Stat Day | Spare
Platform | No |  | Vacation | Booked
Stand-By |  |  | [NAME]
OT / Scrounge |  |  | Legislative Paid
Sick 90% - DNU
Stat Worked
[NAME]
Wage | 29.77 | OT WAGE |  | Sunday Premium
90% Wage
Spreadsheet: 0bcd8396-324f-4d6e-9e3d-310ce51ba634
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | แบบประเมินและพัฒนาเครือข่ายสุขภาพระดับอำเภอ (District Health System : DHS) | Unnamed: 3 | Unnamed: 4
 |  | ครั้งที่ ๑/๒๕๕๖  วันที่ .......................................................CUP…………………………………………………………..
ลำดับ | รายชื่ออำเภอ | ระดับการพัฒนาในภาพรวม | โอกาสพัฒนาเพิ่มเติม | ระบุ เรื่องที่จะพัฒนาของแต่ละอำเภอ
 |  | (ตาม [NAME] ๑+Roadmap บันได ๕ ขั้น) | (พิจารณาให้ครอบคลุม ๕ ประเด็น) | ๑ อำเภอ ๑ ประเด็นสุขภาพ : ODOP One District One Project ตาม ข้อ ๒
 |  | [NAME])....................................................................................................................................... |  | ...
 |  | [NAME]....................................................................................................................................................... |  | สถานที่ทำงาน.................................................................................................
 |  | เบอร์โทรศัพท์ที่ทำงาน……………………………………................................................................................................ |  | เบอร์โทรศัพท์มือถือ……………………………………...........................................
 |  | E-mail…………………………………………………….................................................................................................... |  | ....
 | หมายเหตุ    :   ส่งข้อมูลทางงานพัฒนาคุณภาพบริการ  E-mail :  [EMAIL]
 |  | โทรศัพท์ ๐ ๔๔๕๑ ๘๔๐๒-๕ ต่อ ๒๒๑  โทรสาร  ต่อ ๑๐๗
Spreadsheet: 153321d1335871719-populating-cells-in-another-sheet-gib-rota
Sheet: Input

 |  | May - Period 9 |  |  |  |  | June - Period 10 |  |  |  |  | July - Period 11 |  |  |  |  | August - Period 12 |  |  |  |  |  | Holidays
 |  | AK | LG | VC | OG | ALK | AK | LG | VC | OG | ALK | AK | LG | VC | OG | ALK | AK | LG | VC | OG | ALK |  | Entitlement | AK | LG | VC | OG | ALK
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 23 | 27 | 25
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 9
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 10
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 11
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 12
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance remaining
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holidays (?)
8
9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AK | LG | VC | OG | ALK
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 9
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 10
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 11
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taken period 12
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Holidays
Sick
Spreadsheet: 0617098b-d89b-4a52-991a-45c646ad9c6f
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Choice Supplier INFORMATION FORM
In order to process your request, please provide us with a copy of your CORPORATE PAPERS showing
date and state of corporation as well as the ARTICLES OF ORGANIZATION or CERTIFICATE OF AUTHORITY
signed by the Indiana Secretary of State which includes Indiana's State Seal.
Please complete the following information:
Company Name:
Doing Business As (if applicable):
Type of Business:
Site Address: |  | Street:
 |  | City: |  |  |  |  | State: |  | Zip:
Site Phone:
What is the legal classification of your business?
 |  | A.  Corporation |  |  |  | Corporation Date:
 |  | B.  Limited Liability |  |  |  | Corporation State:
 |  | [NAME]
Federal Tax ID number:
List two Company Officers for Corporation / Non Profit Organization or Members for Limited Liability:
 | Name: |  |  |  |  |  |  | Title:
 | Address: |  |  |  |  |  |  | City:
 | Phone Number: |  |  |  |  |  |  | Fax:
 | Emai:
 | Name: |  |  |  |  |  |  | Title:
 | Address: |  |  |  |  |  |  | City:
 | Phone Number: |  |  |  |  |  |  | Fax:
 | [NAME]:
List contact for billing and payment information:
 | Name: |  |  |  |  |  |  | Title:
 | Address: |  |  |  |  |  |  | City:
 | Phone Number: |  |  |  |  |  |  | Fax:
 | [NAME]:
Who may we contact for Collateral requirements?
Contact Person with Title:
Contact Telephone:
Please verify mailing address (For monthly billing purposes):
Street:
City: |  |  |  |  |  | State: |  |  | Zip:
Completed By: |  |  |  |  |  |  |  | Title:
Phone: |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  |  |  | Rev. 2/11
Spreadsheet: 715408d1611687935-trying-to-figure-interest-i-owe-stesue-interest
Sheet: Sheet1

Date | Amount | Interest | Pre-Interest Balance | Net Balance |  | Annual Rate | 0.03
2017-01-15 00:00:00 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: Move Benchmarks

321 Business Case - Assumptions based on MOVE
Relocations
 | Number of relocations | Target Organization in FTE | Relocation Percentage |  | Comments | Percentage 321
[NAME] | 9 | 235.3 | 0.03824904377390565 |  |  | 0.03
Replacements
 | Number of recruitings | Target Organization in FTE | Replacement Percentage |  | Comments | Percentage 321
[NAME] | 91 | 235.3 | 0.3867403314917127 |  |  | 0.2
Spreadsheet: 104f7425-4f0f-43c7-9057-d861476cd6dc
Sheet: Blank

NASP Equipment  - Supplemental Order Form
NASP, Inc. |  |  | Prices effective: |  |  |  |  |  |  | Phone: (920) 523-6040
W4285 Lake Drive |  |  | Jan 1 - Dec 31, 2013 |  |  |  |  |  |  | Fax:     (920) 523-6042
Waldo, WI  53093 |  |  |  |  |  | Email: [EMAIL]
 |  |  |  |  |  | www.archeryintheschools.org
Organization: |  |  |  |  | [NAME]:
Contact Name: |  |  |  |  | (If different)
Ship-To Address: |  |  |  |  | City State Zip:
(NO PO Box) |  |  |  |  | Phone:
City State Zip: |  |  |  |  | Fax:
 | Commercial |  | Residential |  | E-mail:
 | Evidence of Non-Profit Status: |  |  |  | Copy of 501c3 |  |  | Copy of Sales Tax Exemption
 |  | **Sales tax will be added in KY, WI, OH, and MD if sales tax exemption certificate is not rec'd.**
Payment accepted by Check, MasterCard, Visa, or [NAME]: |  |  |  |  |  |  |  | VISA / MasterCard:
 |  |  |  |  |  | Name:
PO Number: |  |  |  |  |  | Card #:
*PO Number is REQUIRED if order is not prepaid. |  |  |  |  |  | Expires: |  |  | 3-Digit Code
 |  |  |  |  |  |  | Retain CC# for future orders?       Yes       No
 | Number | Item |  |  |  | Qty |  | (Includes Shipping) | Price
Mini | 11413 | Mini Right Hand Red |  |  |  |  | Ea | $111/bow
Genesis | 11415 | Mini Right Hand Blue |  |  |  |  | Ea | $111/bow
Bows: | 11417 | Mini Right Hand Black |  |  |  |  | Ea | $111/bow
 | 11414 | [NAME] Red |  |  |  |  | Ea | $111/bow
 | 11416 | [NAME] |  |  |  |  | Ea | $111/bow
 | 11418 | [NAME] Black |  |  |  |  | Ea | $111/bow
Genesis | 10492A | Genesis Pro Right Hand Black |  |  |  |  | Ea | $131/bow |  | ***
Pro | 10496A | Genesis Pro Right Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Bows: | 10491A | Genesis Pro Left Hand Black |  |  |  |  | Ea | $131/bow |  | ***
 | 10497A | Genesis Pro Left Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Replacement | BG20014 | Right Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
Parts: | BG20015 | Left Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
 | BG11498 | String (Orig or Pro) 94 1/4" (Blk & Wht) |  |  |  |  | Ea | $17/each
 | BG10897 | String (Orig or Pro) 94 1/4" (Blk & Red) |  |  |  |  | Ea | $17/each
 | BG11490 | [NAME] 79 1/4" (Blk and Wht) |  |  |  |  | Ea | $17/each
 | BG11491 | [NAME] 79 1/4" (Black and Red) |  |  |  |  | Ea | $17/each
 | BG11497 | Power Cable Genesis & Pro 37.25" |  |  |  |  | Ea | $10/each
 | BG11492 | Power Cable Mini 31" |  |  |  |  | Ea | $10/each
 | 50138 | Cable Rod Slide |  |  |  |  | Ea | $1/each
 | ** All prices include shipping to a commercial
 | address in the lower 48 States |  |  |  |  |  |  | Total
*** Please note - Genesis Pro does NOT include a rest.  You will have to purchase a rest separately ***
from another source.  [NAME] and [NAME] are not eligible for NASP tournament competition.
*** BY SUBMITTING AN ORDER TO NASP YOU AGREE THESE ITEMS WILL STAY PROPERTY OF THE ORGANIZATION***
Spreadsheet: 668442d1584826724-extract-rows-data-with-3-conditions-q2-2-done
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Done |  |  | Desired results |  |  | Done
 |  | X | X |  | X |  | X |  | Option 1 |  |  | Option 2 |  |  | Option 2
 | Name | A1 | B1 | C1 | D1 | E1 | F1 |  |  |  |  | A1 | AAAAA
 | AAAAA | X |  | X | X |  | X |  |  |  |  |  | EEED
 | DSAS |  | X |  | X | X |  |  |  |  |  |  | CCFF
 | EEED | X | X |  |  |  | X |  |  |  |  |  | ABMLIG
 | CCFF | X | X |  | X | X |  |  |  |  |  |  | QASD
 | AZAS |  |  | X | X |  |  |  |  |  |  |  | FGHK
 | ABMLIG | X |  | X |  |  | X |  |  |  |  |  | zzzzz
 | QASD | X | X | X |  |  |  |  |  |  |  | B1 | DSAS
 | FGHK | X | X |  | X | X |  |  |  |  |  |  | EEED
 | zzzzz | X |  | X | X |  |  |  |  |  |  |  | CCFF
 | WRTYU |  | X |  |  |  | X |  |  |  |  |  | QASD
 |  |  |  |  |  |  |  |  |  |  |  |  | FGHK
 | In option 1 - are extracted from B4:B13 marked "X" for ALL C3:H3 |  |  |  |  |  |  |  |  |  |  |  | WRTYU
 | In option 2 - I would like to extract the same B4:B13 marked "X" but ONLY for C3:H3 marked "X" in C2:H2 |  |  |  |  |  |  |  |  |  |  | D1 | AAAAA
 |  |  |  |  |  |  |  |  |  |  |  |  | DSAS
 |  |  |  |  |  |  |  |  |  |  |  |  | CCFF
 |  |  |  |  |  |  |  |  |  |  |  |  | AZAS
 |  |  |  |  |  |  |  |  |  |  |  |  | FGHK
 |  |  |  |  |  |  |  |  |  |  |  |  | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  | F1 | AAAAA
 |  |  |  |  |  |  |  |  |  |  |  |  | EEED
 |  |  |  |  |  |  |  |  |  |  |  |  | ABMLIG
 |  |  |  |  |  |  |  |  |  |  |  |  | WRTYU
Spreadsheet: 846516d1697692930-combining-sheets-dates-to-summary-formula-error-formula-error-record-sheet-wp-oct-23
Sheet: 19.10.23

 | LPG PLANT DAILY STOCK RECORD SHEET
BOUESTEAD PETROLEUM MARKETING SDN BHD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE: 18/10/2023
VEHICLE NO. | RECEIPT FROM *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISSUE TO *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARKS | GATE PASS
 | BOTTLE |  |  |  |  |  |  |  |  |  |  |  |  | CYLINDERS |  |  | TYPE OF 50 KG |  |  |  | BOTTLE |  |  |  |  |  |  |  |  | BOTTLE |  | TYPE OF 50 KG
 | 12 KG |  |  |  | 14 KG |  | 14 KG PDB | 12 KG BT |  |  | 14 KG BLW |  |  | 50 KG |  |  |  |  |  |  | 12 KG |  | 14 KG |  | 14 KG PDB | 12 KG BT |  | 14 KG BLW |  | 50 KG
 | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | C | CLW | YT | [NAME] | FULL | EMPTY | FULL | EMPTY | FULL | FULL | EMPTY | FULL | EMPTY | FULL | EMPTY | C | CLW | YT | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583231
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583232
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583234
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583235
TOTAL
[NAME]
S/No | JENIS SILINDER DAN KATEGORY |  |  |  |  |  |  |  |  | 12 KG |  |  | 14 KG |  |  | 12 KG BT |  |  | 14 KG BLW |  |  | 50 KG OREN |  |  | 50 KG CLW |  |  | 50 KG YT |  |  | 50 KG YTW
1 | JUMLAH JUALAN [NAME]
2 | BOCOR ISI DITERIMA DARI [NAME]
3 | SILINDER ISI DITERIMA DARI [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0
4 | SILINDER DITERIMA DARI PETRONAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
PEMBUKAAN DAN PENUTUPAN BUKU STOK UNTUK HARI INI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR MANUAL UPDATE
1 | [NAME] |  | 12 KG |  |  |  | 14 KG |  |  |  | 12 KG BT |  |  |  | 14 KG BLW |  |  |  | 50 KG |  |  |  | 50 KG ORANGE |  |  |  | 50 KG CLW |  |  |  | 50 KG YT |  |  |  | 50 KG YTW
2 | Pembukaan
3 | Kategory |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi
 |  |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
4 | [NAME]
5 | [NAME]
6 | Penutupan
 | 1222