tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164939d1340963844-pull-unique-values-based-on-adjacent-column-pt-not-array
Sheet: Sheet1

Area | Value |  |  | Area 1 | Area 2 | Area 3 | Area 4
Area 1 | Value 3
Area 4 | Value 35
Area 3 | Value 7
Area 4 | Value 25 |  |  | Count of Value | Area
Area 1 | Value 20 |  |  | Value | Area 1 | Area 2 | Area 3 | Area 4 | Grand Total
Area 2 | Value 21 |  |  | Value 1 |  | 1 |  |  | 1
Area 3 | Value 17 |  |  | Value 10 |  |  | 1 |  | 1
Area 2 | Value 34 |  |  | Value 11 |  |  | 1 |  | 1
Area 3 | Value 20 |  |  | Value 12 | 1 |  | 1 |  | 2
Area 4 | Value 38 |  |  | Value 13 | 1 |  | 1 |  | 2
Area 3 | Value 4 |  |  | Value 14 |  |  | 1 |  | 1
Area 1 | Value 5 |  |  | Value 15 | 1 |  | 1 |  | 2
Area 3 | Value 23 |  |  | Value 16 | 1 |  | 1 |  | 2
Area 4 | Value 31 |  |  | Value 17 |  |  | 1 |  | 1
Area 2 | Value 25 |  |  | Value 18 | 1 |  | 1 |  | 2
Area 4 | Value 36 |  |  | Value 19 | 1 |  | 1 |  | 2
Area 2 | Value 21 |  |  | Value 2 |  | 1 |  |  | 1
Area 2 | Value 21 |  |  | Value 20 | 1 |  | 1 |  | 2
Area 3 | Value 16 |  |  | Value 21 | 6 | 3 | 1 |  | 10
Area 3 | Value 10 |  |  | Value 22 | 1 |  | 1 |  | 2
Area 2 | Value 4 |  |  | Value 23 |  |  | 1 |  | 1
Area 1 | Value 28 |  |  | Value 24 |  |  |  | 1 | 1
Area 2 | Value 28 |  |  | Value 25 |  | 1 |  | 1 | 2
Area 4 | Value 24 |  |  | Value 26 |  |  |  | 1 | 1
Area 1 | Value 19 |  |  | Value 27 |  |  |  | 1 | 1
Area 4 | Value 34 |  |  | Value 28 | 2 | 3 |  | 1 | 6
Area 1 | Value 18 |  |  | Value 29 |  | 1 |  | 1 | 2
Area 3 | Value 19 |  |  | Value 3 | 1 | 1 |  |  | 2
Area 4 | Value 27 |  |  | Value 30 |  | 1 |  | 1 | 2
Area 1 | Value 21 |  |  | Value 31 |  |  |  | 1 | 1
Area 2 | Value 29 |  |  | Value 32 |  | 1 |  | 1 | 2
Area 4 | Value 32 |  |  | Value 33 |  |  |  | 1 | 1
Area 3 | Value 12 |  |  | Value 34 |  | 1 |  | 1 | 2
Area 1 | Value 22 |  |  | Value 35 |  |  |  | 1 | 1
Area 2 | Value 1 |  |  | Value 36 |  |  |  | 1 | 1
Area 3 | Value 6 |  |  | Value 37 |  |  |  | 1 | 1
Area 1 | Value 21 |  |  | Value 38 |  |  |  | 1 | 1
Area 1 | Value 4 |  |  | Value 4 | 1 | 1 | 1 |  | 3
Area 1 | Value 21 |  |  | Value 5 | 1 |  | 1 |  | 2
Area 3 | Value 5 |  |  | Value 6 |  |  | 1 |  | 1
Area 4 | Value 37 |  |  | Value 7 |  |  | 1 |  | 1
Area 1 | Value 15 |  |  | Value 8 | 1 |  | 1 |  | 2
Area 1 | Value 21 |  |  | Value 9 | 1 |  | 1 |  | 2
Area 1 | Value 12 |  |  | Grand Total | 21 | 15 | 20 | 15 | 71
Area 4 | Value 26
Area 1 | Value 21
Area 1 | Value 8
Area 3 | Value 15
Area 3 | Value 11
Area 2 | Value 3
Area 3 | Value 14
Area 1 | Value 21
Area 3 | Value 21
Area 2 | Value 32
Area 1 | Value 9
Area 4 | Value 33
Area 3 | Value 9
Area 3 | Value 22
Area 1 | Value 28
Area 2 | Value 2
Area 1 | Value 13
Area 4 | Value 28
Area 4 | Value 29
Area 3 | Value 13
Area 4 | Value 30
Area 2 | Value 28
Area 3 | Value 18
Area 1 | Value 16
Area 2 | Value 28
Area 2 | Value 30
Area 3 | Value 8
Spreadsheet: 865710d1712734436-looking-for-a-way-convert-horizontal-data-into-vertical-clusters-based-on-unique-value-unit-mapping-file
Sheet: Results

Mapping | Floor | Area | Use
 | [NAME] (SQM) | 188
30056_tenant 1 | 3rd Basement (Parking Spots) | 1
30056_tenant 2 | [NAME] (SQM) | 495.53
30056_tenant 2 | 1st Floor (SQM) | 495.53
30056_tenant 2 | 2nd Floor(SQM) | 495.53
30056_tenant 2 | 3rd Floor (SQM) | 495.53
30056_tenant 2 | 4th Floor (SQM) | 495.53
30056_tenant 2 | 5th Floor (SQM) | 495.53
30056_tenant 2 | 1st Basement (SQM) | 510.53
30056_tenant 2 | 1st Basement (Parking Spots) | 5
30056_tenant 2 | 2nd Basement (Parking Spots) | 10
30056_tenant 2 | Attic (SQM) | 90.75
30056_tenant 3 | [NAME] (SQM) | 207.8
30056_tenant 3 | Mezzanine (SQM) | 107.4
30056_tenant 3 | 1st Basement (SQM) | 207.8
30056_tenant 3 | 1st Basement (Parking Spots) | 2
0 | 3rd Basement (Parking Spots) | 0+EY10:FD10``
Spreadsheet: 740829d1626611898-drop-down-list-with-few-independent-column-drop-down-list-with-indepentend-name-ans
Sheet: Sheet1

Helper row
 |  | D1 | D2 | D3 | D4 | D5 | D6 |  |  |  | D4 | Data
 |  | Name A1 | Ben1 | F45 | Cha | Pech | Boy
 |  | [NAME] | Ben2 | F46 | Data | Men | Girl
 |  | Name A3 | [NAME] | F47 |  | Women | Bay
 |  | Name A4 | Ben4 | F48 |  |  | little
 |  | Name A5 | Ben5 | F49 |  |  | Sister
 |  | Name A6 |  | F50
 |  | Name A7 |  | F51
 |  | Name A8
 |  | Name A9
Spreadsheet: 2171b7b3-3d65-469b-a983-50652e55e278
Sheet: Sheet1

RT-PCT
region | primer | sequence | Tm |  | RT-PCR cycle
gag | HIV-LTR-512_541-fwd | CACTGCTTAAGCCTCAATAAAGCTTGCCTT | 60.3 |  | 45 | 60min
 | HIV-gag-1500_1474-rev | TGCTATGTCACTTCCCCTTGGTTCTCT | 59.7 |  | 94 | 2min
pol | HIV-pol-244_271-fwd | ACAGGAGCAGATACAGTATTAGAAG | 54.4 |  | 94 | 30s
 | HIV-pol-1597_1623-rev | AGTCTTTCCCCATATTACTATGCTTTC | 55.2 |  | 50 | 30s | | 30x
v3 | HIV-env-95 | AAGGTAWCCTTTGAGCCAATTCC | 53.5 |  | 68 | 2min
 | HIV-env-96 | GTATTRCAATAGAAAAATTCTCCTC | 49.5-51.1 |  | 68 | 10min
 |  |  |  |  | 4 | hold
PCR2
region | primer | sequence | Tm |  | PCR cycle gag & pol |  |  | PCR cycle v3
gag | HIV-gag-903_923-fwd | gcctccctcgcgccatcagXXXXXXXXCAGGGAGCTGGAAAGATTYGC | 54-56 |  | 94 | 2min |  | 94 | 2min
 | HIV-gag-1421_1400-rev | gccttgccagcccgctcagTCTGCAGCTTCCTCATTGATGG | 55 |  | 94 | 30s |  | 94 | 30s
pol | HIV-pol-612_632-fwd | [NAME] | 48.5 |  | 55 | 30s | | 30x | 50 | 30s | | 30x
 | HIV-pol-1147_1166-rev | gccttgccagcccgctcagAGTTCATAACCCATCCAAAG | 47.7 |  | 68 | 1min |  | 68 | 1min
v3 | HIV-env-99 | gcctccctcgcgccatcagXXXXXXXXTACATTATTGTGCYCCAGCTGG | 53-55 |  | 68 | 10min |  | 68 | 10min
 | HIV-env-98 | [NAME] | 49-53 |  | 4 | hold |  | 4 | hold
 |  | 454 A
 |  | 454 B
 |  | sample identifier
Spreadsheet: 77805d1278316030-summing-several-amounts-of-worksheets-in-one-workbook-and-in-multiple-workbooks-sumsheets
Sheet: Table5

24 | 38 | 22 | 47 | 20 | 26 | 34 | 20 |  | Total | 14611
34 | 17 | 49 | 43 | 40 | 20 | 10 | 12
14 | 33 | 30 | 17 | 27 | 16 | 41 | 18
16 | 19 | 39 | 14 | 44 | 11 | 50 | 20
43 | 33 | 46 | 47 | 17 | 46 | 19 | 37
31 | 23 | 27 | 34 | 42 | 44 | 43 | 37
46 | 45 | 36 | 35 | 45 | 31 | 39 | 31
36 | 29 | 37 | 30 | 46 | 22 | 17 | 44
42 | 49 | 26 | 41 | 34 | 14 | 36 | 21
16 | 44 | 13 | 15 | 12 | 15 | 37 | 47
44 | 35 | 33 | 32 | 34 | 28 | 13 | 42
42 | 35 | 11 | 13 | 33 | 12 | 18 | 24
12 | 48 | 24 | 28 | 46 | 41 | 25 | 35
44 | 28 | 31 | 43 | 48 | 46 | 11 | 10
13 | 36 | 28 | 30 | 45 | 36 | 14 | 39
37 | 47 | 37 | 41 | 23 | 19 | 21 | 18
49 | 14 | 15 | 41 | 33 | 27 | 32 | 41
34 | 33 | 45 | 45 | 27 | 49 | 31 | 29
20 | 35 | 10 | 47 | 11 | 39 | 14 | 25
50 | 42 | 14 | 47 | 33 | 39 | 43 | 42
14 | 36 | 48 | 42 | 32 | 23 | 38 | 49
35 | 43 | 32 | 26 | 38 | 14 | 28 | 32
46 | 14 | 14 | 22 | 32 | 42 | 16 | 23
18 | 48 | 31 | 40 | 12 | 25 | 36 | 15
13 | 46 | 30 | 24 | 18 | 33 | 11 | 40
11 | 23 | 17 | 38 | 36 | 31 | 14 | 17
41 | 41 | 48 | 35 | 47 | 46 | 21 | 48
50 | 39 | 46 | 36 | 30 | 26 | 44 | 29
24 | 12 | 18 | 21 | 12 | 32 | 34 | 29
29 | 50 | 43 | 26 | 24 | 14 | 40 | 43
17 | 13 | 37 | 11 | 25 | 40 | 14 | 15
15 | 13 | 18 | 19 | 29 | 36 | 48 | 19
35 | 41 | 49 | 48 | 26 | 31 | 50 | 35
21 | 28 | 40 | 37 | 10 | 40 | 46 | 13
36 | 24 | 40 | 47 | 13 | 49 | 14 | 48
46 | 47 | 12 | 50 | 48 | 42 | 18 | 34
47 | 33 | 29 | 36 | 17 | 45 | 22 | 22
41 | 45 | 48 | 35 | 14 | 15 | 34 | 32
40 | 17 | 31 | 36 | 18 | 12 | 46 | 48
26 | 42 | 28 | 24 | 36 | 27 | 31 | 23
12 | 14 | 34 | 36 | 28 | 30 | 31 | 10
33 | 12 | 10 | 42 | 18 | 20 | 33 | 31
30 | 25 | 29 | 19 | 49 | 46 | 41 | 41
16 | 41 | 46 | 16 | 14 | 23 | 15 | 39
25 | 27 | 26 | 30 | 40 | 30 | 34 | 40
39 | 24 | 25 | 16 | 31 | 23 | 17 | 42
17 | 23 | 43 | 44 | 16 | 23 | 42 | 50
26 | 12 | 35 | 44 | 13 | 35 | 38 | 32
25 | 15 | 32 | 44 | 41 | 41 | 38 | 26
22 | 38 | 10 | 40 | 34 | 17 | 14 | 25
35 | 38 | 12 | 40 | 10 | 27 | 19 | 13
25 | 34 | 36 | 31 | 44 | 42 | 25 | 28
38 | 37 | 26 | 40 | 27 | 13 | 50 | 47
50 | 36 | 14 | 20 | 18 | 16 | 23 | 38
33 | 34 | 13 | 17 | 37 | 31 | 45 | 20
41 | 14 | 10 | 17 | 50 | 20 | 44 | 29
42 | 39 | 46 | 46 | 39 | 17 | 24 | 30
24 | 13 | 49 | 14 | 42 | 31 | 27 | 10
50 | 30 | 34 | 12 | 41 | 29 | 32 | 22
29 | 23 | 23 | 31 | 35 | 47 | 31 | 29
Spreadsheet: dutch_quigley__9208__enron breakdown  12-11 BOD
Sheet: Sheet1

ENRON position breakdown (12-11-01) BOD
 | Option Contracts |  |  | Futures Contracts |  |  | Options | Overall
Month | Bod | Activity | Eod | Bod | Activity | Eod | Delta | Delta | Gamma | Vega | Theta | Month
F02 | 3921 |  |  | -1342 |  |  | 1321 |  | -1.4 | -5248 | 12244 | F02
G02 | 1468 |  |  | 222 |  |  | -209 |  | 0.4 | 3081 | -1739 | G02
H02 | 2145 |  |  | 345 |  |  | -305 |  | 0.7 | 8696 | -3850 | H02
[NAME] | 300 |  |  | 47 |  |  | -54 |  | -0.3 | -4704 | 1651 | [NAME]
K02 | 910 |  |  | -180 |  |  | 109 |  | -2.5 | -46025 | 9845 | K02
M02 | 410 |  |  | 171 |  |  | -160 |  | 0.8 | 18264 | -2884 | M02
N02 | 200 |  |  | 70 |  |  | -88 |  | -0.6 | -16633 | 2290 | N02
Q02 | 600 |  |  | -89 |  |  | 69 |  | -1.5 | -44895 | 4912 | Q02
U02 | 355 |  |  | 67 |  |  | -78 |  | -0.6 | -22343 | 2236 | U02
[NAME] | 600 |  |  | 29 |  |  | -41 |  | -0.9 | -51651 | 3562 | [NAME]
H03 | 200 |  |  | -13 |  |  | 19 |  | 0.4 | 25899 | -1239 | H03
M03 | 300 |  |  | 22 |  |  | -15 |  | 0.8 | 41705 | -1221 | M03
U03 | 50 |  |  | -4 |  |  | 6 |  | 0.1 | 7226 | -170 | U03
Z03 | 200 |  |  | -16 |  |  | 22 |  | 0.4 | 33714 | -693 | Z03
H04 | 200 |  |  | 46 |  |  | -40 |  | 0 | -1171 | 2 | H04
 |  |  |  |  |  |  | Overall:
Spreadsheet: 863899d1711299178-not-sure-whether-to-use-vlookup-or-if-and-then-or-combo-rental-payments-sample
Sheet: Data

Date | Property | Unit | Reference | Type | Comment | Amount
2019-11-01 00:00:00 | WYLIE | 20 |  | Rent Charge | November | 334
2019-11-01 00:00:00 | WYLIE | 20 |  | Water Charge |  | 10.3
2019-11-01 00:00:00 | WYLIE | 20 |  | Sewer Charge |  | 8.92
2019-12-01 00:00:00 | WYLIE | 20 |  | Water Charge |  | 8.49
2019-12-01 00:00:00 | WYLIE | 20 |  | Sewer Charge |  | 6.45
2019-12-01 00:00:00 | WYLIE | 20 |  | Rent Charge |  | 334
Spreadsheet: 545786d1509650955-combine-cells-and-paste-into-one-book2
Sheet: Sheet1

Site | ID | Y/N | Sites
a | 1 | y
a | 1 | n
b | 2 | y
b | 2 | n
b | 2 | y
c | 3 | y
c | 3 | n
c | 3 | y
c | 3 | n
d | 4 | n
e | 5 | n
e | 5 | y
Spreadsheet: 741578d1627155119-when-did-item-sell-last-inventory-analysis
Sheet: Sheet1

Column1 | Column2 | Column3 |  | ALTECO SUPER GLUE | 7 | 2021-07-13 00:00:00
2021-07-03 12:37:48 | 2021-07-03 00:00:00 | ACE TOILET CLEAR LAVENDER 500ML |  | ACE TOILET CLEAR LAVENDER 500ML
2021-07-14 11:37:37 |  | ACNEDIS HERBAL SOAP BAR 100G |  | ACNEDIS HERBAL SOAP BAR 100G
2021-07-11 14:02:05 |  | ADIDAS ADIPURE S/G 400ML |  | ADIDAS ADIPURE S/G 400ML
2021-07-12 22:39:56 |  | ADIDAS DYNAMIC PULSE S/G 400ML |  | ADIDAS DYNAMIC PULSE S/G 400ML
2021-07-05 16:33:59 |  | ADIDAS PURE GAME S/G 400ML |  | ADIDAS PURE GAME S/G 400ML
2021-07-07 16:55:40 |  | AER PETAL CAR FRESHNER SILV 10G |  | AER PETAL CAR FRESHNER SILV 10G
2021-07-07 19:19:56 |  | AFRICANA EXTRA COCONUT OIL 250M |  | AFRICANA EXTRA COCONUT OIL 250M
2021-07-12 14:02:32 |  | AFRICANA EXTRA COCONUT OIL 250M |  | AIRWICK ROSE REFIL
2021-07-02 18:44:42 |  | AIRWICK ROSE REFIL |  | AJAX LAVENDER 1250ML
2021-07-04 15:42:51 |  | AJAX LAVENDER 1250ML |  | [NAME] SHAVING MACHINE
2021-07-05 19:27:50 |  | [NAME] SHAVING MACHINE |  | [NAME]
2021-07-05 13:51:03 |  | [NAME] |  | WISDOM TRAVEL
2021-07-15 15:08:48 |  | [NAME]
2021-07-01 22:04:13 |  | ALTECO SUPER GLUE
2021-07-03 13:52:52 |  | ALTECO SUPER GLUE
2021-07-04 19:23:22 |  | ALTECO SUPER GLUE
2021-07-05 20:16:47 |  | ALTECO SUPER GLUE
2021-07-07 19:34:12 |  | ALTECO SUPER GLUE
2021-07-12 17:40:40 |  | ALTECO SUPER GLUE
2021-07-13 17:41:24 |  | ALTECO SUPER GLUE
2021-07-01 10:13:10 |  | WISDOM TRAVEL
Spreadsheet: 121850d1316456015-how-to-auto-copy-paste-rows-based-on-date-range-weekrange-help
Sheet: Sheet1

Start Date | End Date | Start Week | End Week | Event | A | B | C
2011-10-01 00:00:00 | 2011-10-25 00:00:00 | 39 | 43 | Event 1 | 300 | 200 | 100 |  | <--- | I receive files that look like this
2011-11-25 00:00:00 | 2011-12-03 00:00:00 | 47 | 48 | Event 2 | 100 | 200 | 300 |  |  | I believe this is manually put together
Week | Event | A | B | C |  |  |  |  | <--- | I need it to look like this in the end
39 | Event 1 | 300 | 200 | 100
40 | Event 1 | 300 | 200 | 100
41 | Event 1 | 300 | 200 | 100
42 | Event 1 | 300 | 200 | 100
43 | Event 1 | 300 | 200 | 100
47 | Event 2 | 100 | 200 | 300
48 | Event 2 | 100 | 200 | 300
Spreadsheet: 465644d1465820683-need-help-understanding-new-toy
Sheet: Sheet1

Hire In    Date | Years of Service | Accrual Percentage | Maximum Accrual | Hours Accrualed | PTO Hours Used | Available PTO |  |  |  |  |  |  |  |  |  |  |  |  | Years of Service | Annual Accrual Days | Maximum Accrual | Accrual Per Hour | Accrual               Per Bi-Weekly PP
39482 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10 | 80 | 0.0385 | 3.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 96 | 0.0462 | 3.69
 |  |  |  | CODES |  | COUNT |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 15 | 120 | 0.0577 | 4.62
 |  |  |  | PTO-A | =Accrual |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 20 | 160 | 0.077 | 6.16
 |  |  |  | PTO-E | =Early Out |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 25 | 200 | 0.0962 | 7.69
 |  |  |  | PTO-U | =PTO Used
Pay Period | Date | Hours | Accurual | Early Out | PTO Used | Code | Balance
26 | 2015-12-21 00:00:00 | Beginning Balance |  |  |  |  | 113.24
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 | 2016-02-13 00:00:00 |  |  | 2 |  | PTO-E
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 | 2016-03-15 00:00:00 |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 | 2016-04-05 00:00:00 |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  |  |  |  | 8 | PTO-U
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 | 2016-05-24 00:00:00 |  |  | 1 |  | PTO-E
 | 2016-05-27 00:00:00 |  |  |  | 8 | PTO-U
 |  | 80 |  |  |  | PTO-A
 |  | 80 |  |  |  | PTO-A
 | 2016-06-03 00:00:00 |  |  | 2 |  | PTO-E
 | 2016-06-04 00:00:00 |  |  |  | 8 | PTO-U
 |  | 80 |  |  |  | PTO-A
 |  |  |  |  |  | PTO-A
Spreadsheet: 66507d1267139524-extracting-numbers-from-text-and-turning-the-numbers-into-rows-of-data-samples-of-text-strings
Sheet: Samples

 | Samples of Text Strings that need to be turned into rows of numbers
Sample 1 | 23411658 - 23411680
Sample 2 | 23411658-23411680
Sample 3 | 23411658 .. 23411680
Sample 4 | 23411658..23411680
Sample 5 | 23411658 / 23411680
Sample 6 | 23411658/23411680
 | Samples of Placement of Text Strings that need to be turned into rows of numbers
 | These Text Strings could placed anywhere in column A thru E (but they would always look like the samples below, in other words multiple row sets )
Sample 1 | 23411658 - 23411680
 | 23411681
 | 23411682
 | 23411683 - 23411690
Sample 2 | 23411658 - 23411680
 | 23411681 - 23411690
 | 23411691
 | 23411692
 | 23411693
 | 23411694
 | 23411695
 | 23411696 - 23411700
Sample 3 | 23411691
 | 23411692
 | 23411693
 | 23411694
 | 23411695
 | 23411696 - 23411700
 | 23411701 - 23411705
Spreadsheet: 121843d1316452666-formula-to-remove-part-of-a-text-from-a-cell-by-lookin-at-a-table-problem-sample
Sheet: Sheet1

SKU | Product Name & Product | Colour & Code | Size | Example Of What I Need To End Up With (Just Product Name)
[PHONE] | CORPO POM BEANIE | BLACK (001) | One Size | [NAME]
[PHONE] | LATERAL BEANIE | BLACK (001) | One Size | [NAME]
[PHONE] | EIGHTY SIX BOARDSHORT | BLACK (001) | 28 | EIGHTY SIX
[PHONE] | SMU ETNIES CREW SOCK 3 PK | BLACK (001) | One Size | SMU ETNIES
[PHONE] | BONEYARD 210 HAT | BLACK (001) | S/M | BONEYARD
[PHONE] | AMBERG FLEECE ZIP HOOD | BLACK (001) | M | AMBERG
[PHONE] | AUMA FLEECE ZIP HOOD | BLACK (001) | M | AUMA
[PHONE] | ICON BELOW FLEXFIT HAT | BLACK (001) | S/M | ICON BELOW
[PHONE] | ICON SIDE FLEXFIT HAT | BLACK (001) | L/XL | ICON SIDE
[PHONE] | TAKEOVER 210 FIT HAT | BLACK (001) | S/M | TAKEOVER
[PHONE] | BRICK CITY GLOVES | BLACK (001) | S/M | BRICK CITY
[PHONE] | SUBTLE GLOVES | BLACK (001) | No Size | SUBTLE
[PHONE] | ASHBURY JACKET | BLACK (001) | S | ASHBURY
[PHONE] | BLACKOUT JACKET | BLACK (001) | S | BLACKOUT
[PHONE] | MR CLEAN L/S WOVEN | BLACK (001) | M | MR CLEAN
[PHONE] | [NAME] | BLACK (001) | 30 | [NAME]
[PHONE] | KICK IT SHORT | BLACK (001) | S | KICK IT
[PHONE] | STE STINGRAY 2 - BOARD SHORT | BLACK (001) | 32 | STE STINGRAY 2 -
[PHONE] | TEE TIME SHORT | BLACK (001) | 30 | TEE TIME
[PHONE] | WHODINI SHORT | BLACK (001) | 30 | WHODINI
[PHONE] | BEATS S/S TEE | BLACK (001) | S | BEATS
[PHONE] | BLASTER S/S TEE | BLACK (001) | S | BLASTER
[PHONE] | BRAND STACK S/S TEE | BLACK (001) | XS | BRAND STACK
[PHONE] | CASSETTE S/S TEE | BLACK (001) | S | CASSETTE
 | PRODUCT TEXT TO BE REMOVED (this is in a separate tab)
 | [NAME]
 | Boardshorts
 | Crew Sock 3 Pk
 | [NAME]
 | [NAME]
 | Flex Fit Hat Twill
 | Gloves
 | Jacket
 | L/S Woven
 | Non-Denim Pants
 | Non-Denim Shorts
 | S/S TEE
 | S/S Woven Shirt
 | Screen Hooded Fleece
 | [NAME]
 | Tank Top
 | Web Belt
 | Denim Pants
 | Synthetic Wallet
 | [NAME]
 | Wallet
 | [NAME]
 | Flannel
 | Natural Wallet
 | Novelty Fleece
 | S/S Crew Knit
 | [NAME]
 | S/S Specialty
 | Screen Crew Fleece
 | L/S Knit Shirt
 | Novelty Knits
 | [NAME]
 | V-Neck Sweater
 | Pant
 | 210 FIT HAT
Spreadsheet: 01494541-9e36-47b7-a039-566011538187
Sheet: Labor-Task

Advertising and Integrated Marketing Solutions (AIMS )                                                                                                                           7FCB-H2-07-0541-B                                                                                                                                                                                       Page 1 of 4
Schedule 541 - Proposal Price List Preparation Spreadsheet (Labor/Task)
This document must be completed and submitted with your offer.
Full Products and Broad Services Offerings
Offeror must provide a full and broad offering on services and/or products. Offers will not be accepted with only limited item/offering (product, labor category, training course, or fixed-price service)
unless it represents a total solution for the Special Item Numbers (SINs).
Fair and Reasonable Pricing
To determine fair and reasonable pricing, the GSA Contracting Officer may consider many factors, including pricing on competitor contracts, historical pricing, and currently available pricing in other venues.
Offers which provide Most Favored Customer pricing, but which are not highly competitive will not be found fair and reasonable and will not be accepted.
[NAME]:
Labor/Task Pricing
SIN(s) PROPOSED | SERVICE PROPOSED (e.g. Labor Category or Job Title/Task) | MINIMUM EDUCATION / CERTIFICATION LEVEL | MINIMUM YEARS OF EXPERIENCE (cannot be a range) | CONTRACTOR OR CUSTOMER SITE | DOMESTIC OR OVERSEAS | COMMERCIAL PRICE LIST (CPL) OR MARKET PRICES | UNIT OF ISSUE (e.g. Hour, Task, Sq ft) | MOST FAVORED COMMERCIAL CUSTOMER (MFC)* | DISCOUNT OFFERED TO COMMERCIAL MFC (%) | COMMERCIAL MFC PRICE | MOST FAVORED FEDERAL AGENCY (MFC)** | MOST FAVORED FEDERAL AGENCY (MFC) PRICE** | DISCOUNT OFFERED TO GSA (off CPL or Market Prices) (%) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | SUPPORTING INVOICE NUMBER
541-1 | Project Mgr | Masters Degree | 8 | Both | Domestic Only | 150 | Hourly | All Commercial Customers | 0.05 |  | U. S. A. F. | 120 | 0.1 |  |  | 123456
Note: The table above is an example, for further instructions, see tab: |  |  |  | Enclosure A
*Note: GSA considers prime contractors to Federal Agencies as commercial customers.
**Note: Most Favored Federal Agency is sales directly to a Federal Agency as a prime contractor.  If no sales exist to Federal Agencies for the offered sevices, enter "N/A".
Spreadsheet: 55899d1256056314-populating-table-with-monthly-returns-book68
Sheet: Sheet2

Account# | yry | Date | rtt | Total Equity | eee | Currency | ewe | rty
323 | 56 | 2009-06-01 00:00:00 | 65645 | 1001 | 655 | USD | 6 | 6546
323 | 34 | 2009-06-01 00:00:00 | 34545 | 500 | 344 | GBP | 3 | 334
540 | 23 | 2009-06-01 00:00:00 | 3435 | 2567 | 23 | USD | 2 | 343
Spreadsheet: 09398f8f-336b-4b54-8471-cb38a14e8473
Sheet: Sheet1

Unnamed: 0 | BALANCE SHEET | Unnamed: 2 | Unnamed: 3 | name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | date prepared |  |  | address
CURRENT FARM ASSETS |  |  |  | $ [NAME]
Cash on hand and in checking accounts |  |  |  | 123 |  | Crops and feed worksheet
Certificates, savings, and other accounts |  |  |  | 11111 |  | Crop | Units | $per unit | Total
Accounts and notes to be received |  |  |  |  |  |  | 1000 | 2 | 2000
Crops and feed |  |  |  | 2008 |  |  | 1 | 2 | 2
 |  |  |  |  |  |  | 1 | 2 | 2
Livestock to be sold |  |  |  | 0 |  |  | 1 | 2 | 2
 |  |  |  |  |  |  | 2 | 1 | 2
Growing crops |  |  |  | 0 |  |  |  | Total | 2008
Supplies and prepaid expenses |  |  |  |  |  | Livestock to be sold worksheet
Leases |  |  |  |  |  | Livestock | Units | $ per unit | Total
Other |  |  |  |  |  |  | 1 | 0 | 0
 |  |  |  |  |  |  | 1 | 0 | 0
 |  |  |  |  |  |  | 1 | 0 | 0
 |  |  |  |  |  |  | 1 | 0 | 0
TOTAL CURRENT FARM ASSETS |  |  |  | 13242 |  |  | 1 | 0 | 0
INTERMEDIATE FARM ASSETS |  |  |  |  |  |  |  | Total | 0
 |  |  |  |  |  | Growing crops  worksheet
Accounts and notes to be received |  |  |  |  |  | Crop | Acres | Cost/acre | Total
Breeding livestock: |  | Worksheet |  |  |  |  | 0 | 0 | 0
description | no./ head | price/unit | total |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  | Total | 0
 |  |  | 0 | 0
Machinery,  equipment, and vehicles |  |  |  |  |  | Fertility bank worksheet:
Co-op stock |  |  |  |  | Field |  | Soil test recommendations
Cash value, farm related life insurance |  |  |  |  | Name | $/lbs of P | $/lbs of K | $/t of lime | field total
Other |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Fertility bank '($ needed to rebuild soil) |  |  |  | 0 |  |  |  |  | 0
TOTAL INTERMEDIATE FARM ASSETS |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
LONG TERM FARM ASSETS |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Real estate worksheet: OPTIONAL |  |  |  |  |  |  |  |  | 0
tract name | ac/pasture | ac/crop | ac/timber |  |  |  |  |  | 0
 |  |  |  | 1000000 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  | 2 |  |  |  |  | 0
 |  | Total real estate |  | 1000002 |  |  |  |  | 0
 |  |  |  |  | Total farm fertility credit or debit |  |  |  | 0
Co-op stock
Other
TOTAL LONG TERM ASSETS |  |  |  | 1000002
TOTAL FARM ASSETS |  |  |  | 1013244
Spreadsheet: 761170d1640700599-combine-columns-datas-for-identical-values-in-first-column-test-48-ans
Sheet: test

point | type | other | value
15 | A
15 | B | x
20 | A |  |  |  |  |  | point | type and values combined | type and values combined
20 | C | y |  |  |  |  | 15 |  | AB
 |  |  |  |  |  |  | 20 |  | AC
30 | H |  |  |  | ---> | ---> | 30 |  | HD(5)E
30 | D | z | 5 |  | what i need to obtain |  | 60 |  | B
30 | E |  |  |  |  |  | 66 |  | C(4)
 |  |  |  |  |  |  | 72 |  | D
60 | B | x |  |  |  |  | 80 |  | A(-8)
66 | C | y | 4
72 | D | y
80 | A | x | -8