tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220148d1363082929-complex-vlookup-from-range-sample
Sheet: Sayfa1

 |  | MON | TUE | WED
 |  |  | [NAME] |  |  |  |  | [NAME] | TUE | MON | MON | WED | MON | TUE | WED | MON |  | What I want to achieve is :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for j2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] name at I2….in this case [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | find the FIRST occurence of [NAME] at c2:e18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | which is D2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lookup column header… TUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | type in j2…TUE
 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for k2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] name at I2….in this case [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | find the SECOND occurence of [NAME] at c2:e18
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | which is C4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lookup column header.. MON
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | type in K2.. MON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and as we go on we have to be able to line up the header values horizontally
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | omitting the spaces.
Spreadsheet: 775028d1648778767-how-to-lock-or-show-the-data-including-date-that-user-input-project_tracker
Sheet: Sheet1

Date start (Mon) | 2022-04-03 00:00:00
Project | start | end | status | manager | Project | start | end | status | manager | Project | start | end | status | manager
A | 2022-03-01 00:00:00 | 2022-06-01 00:00:00 | in progress | M1
B | 2022-01-01 00:00:00 | 2022-10-01 00:00:00 | on hold | M2
C | 2022-03-01 00:00:00 | 2022-06-02 00:00:00 | in progress | M3
Spreadsheet: 820232d1677945099-combine-ranges-from-2-worksheets-myr-accounts-and-cc
Sheet: Combine (Manually)

 | A551200
 | A553002
 | A571241
 | A576640
 | A576763
 | A576620
 | A576500
 | A576921
 | A575101
 | A575102
 | A575103
 | A575104
 | A575105
 | A575303
 | A575302
 | A575401
 | A575402
 | A581040
 | A573120
 | A573220
 | A573221
 | A573260
 | A573400
 | A573200
 | A573243
 | A573244
 | A573245
 | A573180
 | A575200
 | A574040
 | A574046
 | A574090
 | A571243
 | A571242
 | A571260
 | A574050
 | A540320
 | A574021
 | A574022
 | A574025
 | A574061
 | A574062
 | A574063
 | A574064
 | A574071
 | A574081
 | [NAME]
 | A574083
 | A574221
 | A571140
 | A574210
 | A574219
 | A574203
 | A574205
 | A574202
 | A551200
 | A553002
 | A571241
 | A576640
 | A576763
 | A576620
 | A576500
 | A576921
 | A575101
 | A575102
 | A575103
 | A575104
 | A575105
 | A575303
 | A575302
 | A575401
 | A575402
 | A581040
 | A573120
 | A573220
 | A573221
 | A573260
 | A573400
 | A573200
 | A573243
 | A573244
 | A573245
 | A573180
 | A575200
 | A574040
 | A574046
 | A574090
 | A571243
 | A571242
 | A571260
 | A574050
 | A540320
 | A574021
 | A574022
 | A574025
 | A574061
 | A574062
 | A574063
 | A574064
 | A574071
 | A574081
 | [NAME]
 | A574083
 | A574221
 | A571140
 | A574210
 | A574219
 | A574203
 | A574205
 | A574202
 | A551200
 | A553002
 | A571241
 | A576640
 | A576763
 | A576620
 | A576500
 | A576921
 | A575101
 | A575102
 | A575103
 | A575104
 | A575105
 | A575303
 | A575302
 | A575401
 | A575402
 | A581040
 | A573120
 | A573220
 | A573221
 | A573260
 | A573400
 | A573200
 | A573243
 | A573244
 | A573245
 | A573180
 | A575200
 | A574040
 | A574046
 | A574090
 | A571243
 | A571242
 | A571260
 | A574050
 | A540320
 | A574021
 | A574022
 | A574025
 | A574061
 | A574062
 | A574063
 | A574064
 | A574071
 | A574081
 | [NAME]
 | A574083
 | A574221
 | A571140
 | A574210
 | A574219
 | A574203
 | A574205
 | A574202
 | A551200
 | A553002
 | A571241
 | A576640
 | A576763
 | A576620
 | A576500
 | A576921
 | A575101
 | A575102
 | A575103
 | A575104
 | A575105
 | A575303
 | A575302
 | A575401
 | A575402
 | A581040
 | A573120
 | A573220
 | A573221
 | A573260
 | A573400
 | A573200
 | A573243
 | A573244
 | A573245
 | A573180
 | A575200
 | A574040
 | A574046
 | A574090
 | A571243
 | A571242
 | A571260
 | A574050
 | A540320
 | A574021
 | A574022
 | A574025
 | A574061
 | A574062
 | A574063
 | A574064
 | A574071
 | A574081
 | [NAME]
 | A574083
 | A574221
 | A571140
 | A574210
 | A574219
 | A574203
 | A574205
 | A574202
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-09-30 00:00:00 |  | 1336515.68
2001-10-02 00:00:00
60874 | 320
78169
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-09-30 00:00:00 |  | 275313.72
2001-10-02 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 285450 | 117857 | 157582
2001-09-30 00:00:00 |  | 777555.1
2001-10-02 00:00:00
500241
500391 | 161
500392 | 186
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 101841d1299872592-how-do-i-list-invoices-marked-not-paid-on-another-sheet-rise-n-shine-2011
Sheet: Income Report

2011
Income
 | Total
Jan | 23 |  |  | Sum of Amount | Paid ? Y / N
Feb | 23 |  |  | Date | no | yes | Grand Total
Mar | 30 |  |  | Jan | 11 | 12 | 23
Apr | 0 |  |  | Feb | 23 |  | 23
May | 0 |  |  | Mar | 21 | 9 | 30
Jun | 0 |  |  | Grand Total | 55 | 21 | 76
Jul | 0
Aug | 0
Sep | 0
Oct | 0
Nov | 0
Dec | 0
Total Amount | 76
Spreadsheet: 848078d1698875002-formula-to-rearrange-data-as-pasted-from-external-source-workbook-example
Sheet: Copy and Past Data in "A"

Question 1
Rarely
Question 2
Occasionally
Question 3
Frequently
Question 4
very frequently
Question 5
Rarely
Question 6
Occasionally
Question 7
Frequently
Question 8
Very Frequently
Question 9
Rarely
Question 10
Occasionally
Question 11
Frequently
Question 12
Very Frequently
Spreadsheet: 114478d1310171157-excel-2007-highlighting-higher-value-in-2-cells-based-on-duplicate-value-in-separate-column-sample-data
Sheet: Sheet1

ID# | Name | Address 1 | City | State | Zip | Phone #
12345 | [NAME] | 10 Elm Street | Philadelphia | PA | 191183244 | 2151234567
12346 | [NAME] | 10 Elm Street | Philadelphia | PA | 191183244 | 2151234567
23456 | [NAME] | 1245 East 10th Street | Philadelphia | PA | 191263207 | 2155557890
23457 | [NAME] | 111 Venture Ave | Philadelphia | PA | 191381623 | 2155557890
34567 | [NAME] | 21 Maple Drive | Philadelphia | PA | 191314832 | 2155556543
34568 | [NAME] | 21 Maple Drive | Philadelphia | PA | 191434703 | 2155556543
45678 | [NAME] | 400 Walnut Road | Philadelphia | PA | 191204143 | 2150005467
45679 | [NAME] | 35 Capital Drive | Philadelphia | PA | 191493014 | 2150005467
Spreadsheet: 821800d1678900065-categorise-by-percentage-banding-workbook-etaf
Sheet: Sheet1

NPV weighting x NPV score | Overall score | Rank | Banding | Column1 | Column2
 |  |  | GOLD |  |  | Banding
 |  |  | GOLD |  |  | Gold | 75-100%
 |  |  | GOLD |  |  | Silver | 25-74%
 |  |  | GOLD |  |  | [NAME] | 0-25%
 |  |  | GOLD
 |  |  | GOLD
 |  |  | GOLD
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | SILVER
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
 |  |  | BRONZE
Spreadsheet: 852945d1702920244-lookup-and-return-the-dates-falls-between-from-and-to-date-return-dates-falls-between-from-and-to-date
Sheet: Sheet1

ID Number | From Date | To Date
30165 | 2021-11-22 00:00:00 | 2022-06-16 00:00:00
 | From Date | To Date | Nos. of Day |  |  |  | From Date | To Date | Nos. of Day
 | 2021-11-22 00:00:00 | 2021-11-25 00:00:00 |  |  |  |  | 2021-11-22 00:00:00 | 2021-11-30 00:00:00
 | 2021-11-26 00:00:00 | 2021-11-30 00:00:00 |  |  |  |  | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 |  |  |  |  | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
 | 2021-12-13 00:00:00 | 2021-12-13 00:00:00 |  |  |  |  | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
 | 2022-03-19 00:00:00 | 2022-03-31 00:00:00 |  |  |  |  | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 |  |  |  |  | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 |  |  |  |  | 2022-06-06 00:00:00 | 2022-06-16 00:00:00
 | 2022-06-06 00:00:00 | 2022-06-16 00:00:00
Spreadsheet: 844780d1696459407-array-cell-chunk-match-samplebook
Sheet: Sheet1

Preliminary Allocation Rule | Rounded Percentage | "Matched" Consolidated Rule |  |  | EXPECTED OUTPUT
1 | 0.0912 |  |  |  | 1
1 | 0.1441 | 1 |  |  | 1
1 | 0.6834 | 1 |  |  | 1
1 | 0.0002 | 1 |  |  | 1
1 | 0.0811 | 1 |  |  | 1
2 | 0.0912 | 1 |  |  | 1
2 | 0.1441 | 1 |  |  | 1
2 | 0.6834 | 1 |  |  | 1
2 | 0.0002 | 1 |  |  | 1
2 | 0.0811 | 1 |  |  | 1
3 | 0.0912 | 3 |  |  | 3
3 | 0.1441 | 3 |  |  | 3
3 | 0.6834 | 3 |  |  | 3
3 | 0.0003 | 3 |  |  | 3
3 | 0.081 | 3 |  |  | 3
4 | 0.5294 | 4 |  |  | 4
4 | 0.4706 | 4 |  |  | 4
5 | 0.0912 | 5 |  |  | 5
5 | 0.1442 | 5 |  |  | 5
5 | 0.6835 | 5 |  |  | 5
5 | 0.0811 | 5 |  |  | 5
6 | 0.5294 | 4 |  |  | 4
6 | 0.4706 | 4 |  |  | 4
7 | 0.5294 | 4 |  |  | 4
7 | 0.4706 | 4 |  |  | 4
8 | 0.5288 | 8 |  |  | 8
8 | 0.0012 | 8 |  |  | 8
8 | 0.47 | 8 |  |  | 8
9 | 0.5288 | 8 |  |  | 8
9 | 0.0012 | 8 |  |  | 8
9 | 0.47 | 8 |  |  | 8
10 | 0.5294 | 4 |  |  | 4
10 | 0.4706 | 4 |  |  | 4
11 | 0.5294 | 11 |  |  | 11
11 | 0.4705 | 11 |  |  | 11
11 | 0.0001 | 11 |  |  | 11
Spreadsheet: 272817d1382522283-list-all-products-based-on-entered-value-in-cell-sample-1-
Sheet: Sheet1

TEST FILE
ID | product |  |  |  | ENTER ID | 2222
2222 | test1
2222 | test2 |  |  |  | Products
2222 | test3
2222 | test4
2222 | test5
3333 | test6
3333 | [NAME]
3333 | test8
3333 | test9
3333 | test10
3333 | test11
3333 | test12
4444 | test13
4444 | test14
4444 | test15
4444 | test16
4444 | test17
4444 | test18
Spreadsheet: 670334d1585837280-getting-rid-of-divide-by-zero-errors-test-trial
Sheet: Sheet1

 |  | 3" | 4" | 5" | 6" | 7" | 8" | 9" |  | 3" | 4" | 5" | 6" | 7" | 8" | 9"
 | qty | 12 | 3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 20 | 0 | 0
 |  | 15 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 10 | 2
 |  | 0 | 0 | 0 | 33 | 0 | 0 | 0
 |  | These are the qty of each size |  |  |  |  |  |  |  | This is comparison of each size in relation to one another but when there is only one size
 |  |  |  |  |  |  |  |  |  | on an order you divide by zero which gives an error. I tried sumif but when I split the sum such as =F7/SUM(C7:E7,G7:I7)
 |  |  |  |  |  |  |  |  |  | the comma ruins the formula because it thinks its moving to the next part of the sumif operation
Spreadsheet: 78274d1278663334-search-each-word-from-one-cell-in-a-second-excel-sheet-example
Sheet: Sheet1

Name | ID_Material_Tool | Nummer | Fabricant
3M Scotch Klebeband 3430 | mat741 |  | 3M
3M Industriereiniger S151 VHB | mat87 |  | 3M
785 Parting Lubricant | [NAME] |  | A. W. Chesterton Company
Abdeckklebeband | mat100 |  | Handelsüblich
ADD 182 HELLGRÜN K - CHING-PUR-DICHTFLÄCHENBESCHICHTUNG | mat986 |  | CHEMISCHE INDUSTRIE ERLANGEN GmbH
Aeroshell Grease 33 MS | mat947 |  | Shell
Spreadsheet: 787943d1658166184-cbbox-that-will-dynamically-show-current-year-month-and-year-payments_to_qi-copy
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  | Months |  | use |  |  | Months
 |  |  |  |  |  |  |  |  |  |  |  | Current Month Year |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  | Current year |  |  | Feb
 |  |  |  |  |  |  |  | 7 |  |  |  | Current Month |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: d8cb7bca-a803-4a95-a35a-3d7cfcde2e63
Sheet: Sheet1

Nombre de permis de pêche délivrés en Région wallonne | Unnamed: 1
MRW – DGRNE – DNF
 | Nombre de permis
1995 | 85103
1996 | 85435
1997 | 82845
1998 | 77709
1999 | 77068
2000 | 72861
2001 | 71011
2002 | 69326
2003 | 69456
2004 | 65687
2005 | 63145
2006 | 59489
Spreadsheet: 691689d1597831575-help-with-formula-show-results-based-on-date-voorbeeld
Sheet: Blad1

ID | Name | Date
100 | Jan
101 | Pieter | 2020-02-10 00:00:00
103 | Marleen | 2020-02-10 00:00:00
104 | Jan
105 | Pieter | 2020-03-10 00:00:00
107 | Marleen | 2020-02-15 00:00:00
108 | Jan
109 | Pieter | 2020-04-10 00:00:00
111 | Marleen | 2020-02-20 00:00:00
Yet to accomplish | Jan | Pieter | Marleen |  |  | Jan | Pieter | Marleen |  |  | Jan | Pieter | Marleen
January | 100 | 101 | 103 |  | February | 100 | 105 |  |  | March | 100 | 109
 | 104 | 105 | 107 |  |  | 104 | 109 |  |  |  | 104
 | 108 | 109 | 111 |  |  | 108 |  |  |  |  | 108
DC HJ | 2019-12-31 00:00:00 | 2020-02-01 00:00:00
 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00
 | 2020-02-29 00:00:00 | 2020-04-01 00:00:00
 | 2020-03-31 00:00:00 | 2020-05-01 00:00:00
 | 2020-04-30 00:00:00 | 2020-06-01 00:00:00
 | 2020-05-31 00:00:00 | 2020-07-01 00:00:00
 | 2020-06-30 00:00:00 | 2020-08-01 00:00:00
 | 2020-07-31 00:00:00 | 2020-09-01 00:00:00
 | 2020-08-31 00:00:00 | 2020-10-01 00:00:00
 | 2020-09-30 00:00:00 | 2020-11-01 00:00:00
 | 2020-10-31 00:00:00 | 2020-12-01 00:00:00
 | 2020-11-30 00:00:00 | 2021-01-01 00:00:00
Spreadsheet: andy_zipper__214__Global_Prod 5-25-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
Credit Dflt Swap AT & T                  5 Years         bpa/USDm
Credit Dflt Swap BMW AG                  5 Years         bpa/USDm
Credit Dflt Swap Boeing                  3 Years         bpa/USDm
Credit Dflt Swap Boeing                  5 Years         bpa/USDm
Credit Dflt Swap DaimlerChrysler         5 Years         bpa/USDm
Credit Dflt Swap Fiat SpA                5 Years         bpa/USDm
Credit Dflt Swap Ford Credit             3 Years         bpa/USDm
Credit Dflt Swap Ford Credit             5 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           3 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           5 Years         bpa/USDm
Credit Dflt Swap Lockheed Martin         3 Years         bpa/USDm
Credit Dflt Swap Lockheed Martin         5 Years         bpa/USDm
Credit Dflt Swap Viacom                  3 Years         bpa/USDm
Credit Dflt Swap Viacom                  5 Years         bpa/USDm
Credit Dflt Swap Volkswagen              3 Years         bpa/USDm
Credit Dflt Swap Volkswagen              5 Years         bpa/USDm
Credit Dflt Swap Volvo                   5 Years         bpa/USDm
Credit Dflt Swap Worldcom                5 Years         bpa/USDm
DTD Brent vs.    IPE Frontline           Jan-Dec02       USD/bbl
DTD Brent vs.    IPE Frontline           Q1 2002         USD/bbl
DTD Brent vs.    IPE Frontline           Q2 2002         USD/bbl
DTD Brent vs.    IPE Frontline           Q3 2002         USD/bbl
DTD Brent vs.    IPE Frontline           Q4 2001         USD/bbl
DTD Brent vs.    IPE Frontline           Q4 2002         USD/bbl
DTD Brent vs.    IPE Frontline           Sep01           USD/bbl
SG Dub Time Spd  Platts                  Q3 01 v Q4 01   USD/bl/m
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG GO-Dub Crk    Platts                  Jul-Sep01       USD/bbl
SG HSFO Diff     Platts 180-380          Jun01           USD/mt
SG HSFO Swap     Platts AP 180           Jun01           USD/mt
[NAME]USD/bbl
[NAME]Jun01           USD/bbl
US HeatOil2 Swap GC Crack Spread         CAL 2003        USD/bl/m
US HeatOil2 Swap GC Crack Spread         CAL 2004        USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         CAL 2003        USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         CAL 2004        USD/bl/m
US [NAME]               Jun01           USD/Gl-b
US NitTol Swap   CMAI Spot               Jun01           USD/Gl-b
US Styrene FOB   Hou/TX Cty              Jun01           c/[NAME]
US [NAME]GC Crack Spread         CAL 2002        USD/bl/m
US WTI [NAME] 01      USD/bbl
Spreadsheet: 215425d1361375703-how-to-correct-a-sheet-where-one-column-is-populated-with-number-ranges-like-2-210-etc-eample
Sheet: Sheet1

 | atribute(s) |  | range | number before (-) | Base on Sheet Master
 | selection or use |  | 4-220 |  |  |  | VALUE(IFERROR(IF(FIND("-",D2,1)>1,LEFT(D2,FIND("-",D2,1)-1)),D2)
 | rights |  | 121-179 |  |  |  | The above formula for return the number before (-)
 | consumer perception |  | 4-220
 | finance |  | 180
 | origin |  | 181-260
 | consumer perception |  | 1
 | finance |  | 94
 | finance |  | 221-227
 | finance |  | 2
 | consumer perception |  | 227-229
 | consumer perception |  | 245
 | consumer perception |  | 249-250
 | rights |  | 3
 | rights |  | 82-101
 | selection or use |  | 101-111
 | origin |  | 90-99
 | origin |  | 122
 | consumer perception |  | 16
 |  |  |  |  | Column F and G using the same formula
 |  |  |  |  | Column F are join formula from column E and G
Spreadsheet: 0fb79d69-b551-409f-9b02-31c4b4174b97
Sheet: Mod 37 Additions

Addition of Items Spreadsheet
Manufacturer’s Part Number
Offeror must ensure the Original Equipment Manufacturer (OEM), Manufacturer Part Number or Wholesaler Number for each product proposed reflects the actual part number assigned.
If the OEM, [NAME], or Wholesaler Part Number is submitted incorrectly or not submitted, the product offering will not be awarded.
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.
Mfg.Part Number | Dealer Part Number | [NAME] | SIN | PRODUCT NAME | Commercial List Price | MFC DISCOUNT | Discount to GSA | RELATIONSHIP | Proposed GSA Price | Proposed GSA Price including IFF | DELIVERY | FOB POINT | COO
105978 |  |  | 398-59 | Drum kit | 200 | 0.05 | 0.1 |  |  |  | 30 days | Destination | USA
Spreadsheet: 676880d1589037797-sumif-formula-help-required-2020-05-09-oeldere-jojo101-pt-676878d1589036134-sumif-formula-help-required-sample-1
Sheet: Sheet1

DATE WORKED | AMOUNT | MONTH NUM | MONTHLY TOTAL
2020-01-01 00:00:00 | 100 |  |  |  |  | Som van AMOUNT | Kolomlabels
2020-01-18 00:00:00 | 300 |  |  |  |  | Rijlabels | 1 | 2 | 3 | Eindtotaal
2020-01-27 00:00:00 | 50 |  | 450 |  |  | jan | 450 |  |  | 450
2020-02-14 00:00:00 | 200 |  |  |  |  | feb |  | 500 |  | 500
2020-02-14 00:00:00 | 150 |  |  |  |  | mrt |  |  | 150 | 150
2020-02-19 00:00:00 | 100 |  |  |  |  | Eindtotaal | 450 | 500 | 150 | 1100
2020-02-25 00:00:00 | 50 |  | 500
2020-03-03 00:00:00 | 100
2020-03-06 00:00:00 | 50 |  | 150
Spreadsheet: 827911d1683116611-conditional-fornat-rule-referencing-another-sheet-cf-problem
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
 | 6 | 7 | 8 | 9 | 10
 | Conditional Format the 10 cells above (B4:F5) so that they are shaded based whether the table on Sheet2 lists them as a P or F
 | I can only seem to get this to work if I manually write a CF rule for EACH cell, as opposed to writing oen rule and copying it/applying it across all cells
 |  | P (Pass)
 |  | F (Fail)
 | Below is the how the table would look if the one CF rule can be applied to each cell.
 | 1 | 2 | 3 | 4 | 5
 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 763370d1642141704-how-to-auto-populate-data-from-another-sheet-book1
Sheet: RAW DATA

Submission ID | User ID | Submission Date and Time | First Name | Last Name | [NAME] | Division | Standard | CLUB | Coach | Coach Mobile | Coach [NAME] | Team | President [NAME] | Player 1 | Date of Birth | Phone Number Title | Player 2 | Date of Birth2 | Phone Number Title3 | Player 3 | Date of Birth4 | Phone Number Title5 | Player 4 | Date of Birth6 | Phone Number Title7 | Player 5 | Date of Birth8 | Phone Number Title9 | Player 6 | Date of Birth10 | Phone Number Title11 | Player 7 | Date of Birth12 | Phone Number Title13 | Player 8 | Date of Birth14 | Phone Number Title15 | Player 9 | Date of Birth16 | Phone Number Title17 | Player 10 | Date of Birth18 | Phone Number Title19 | Player 11 | Date of Birth20 | Phone Number Title21 | Player 12 | Date of Birth22 | Phone Number Title23 | IP Address | Administrator Remarks | Score | [NAME] | Referer | URL Track | Time | Link
 |  |  |  |  |  |  |  | ELISE |  |  |  | [NAME]
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: May

 | TLR Max Level | Number of Incidents
 | 1 | 0
 | 2a | 4
 | 2b | 7
 | 2c | 1
 | 3 | 7
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-05-02 00:00:00 | 3 | 1 | MAIN | 07:35:00 | 10:30:00
1 | 1999-05-15 00:00:00 | 3 | 50 | SPP | 15:25:00 | 18:00:00
1 | 1999-05-17 00:00:00 | 3 | 84 | MAIN | 06:05:00 | 23:04:00
1 | 1999-05-18 00:00:00 | 3 | 50 | MAIN | 06:20:00 | 22:05:00
1 | 1999-05-19 00:00:00 | 3 | 40 | MAIN | 07:22:00 | 17:45:00
1 | 1999-05-23 00:00:00 | 3 | 50 | AEP | 14:22:00 | 18:00:00
1 | 1999-05-30 00:00:00 | 3 | 227 | SPP | 06:53:00 | 11:48:00
Spreadsheet: 855344d1704948594-listing-event-start-and-end-times-from-time-series-example-time-series
Sheet: Sheet1

Time (s) | Event |  |  | Manually calculated results: |  | Start time | Last time | (I would like to get the time that event starts (transition from 0 to 1) and the last time stamp of that same event.)
0 | 0 |  |  |  |  | 1.5 | 3
0.5 | 0 |  |  |  |  | 4.5 | 6.5
1 | 0 |  |  |  |  | 7.5 | 8
1.5 | 1
2 | 1
2.5 | 1
3 | 1
3.5 | 0
4 | 0
4.5 | 1
5 | 1
5.5 | 1
6 | 1
6.5 | 1
7 | 0
7.5 | 1
8 | 1
8.5 | 0
9 | 0
Spreadsheet: 771670d1646784539-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: BANK (MAVIC)

 | MS | 398 | 2022
 | REF: |  |  |  | Financial Instrument #:
 |  |  |  |  | Dated :
 | The Manager,
 | Bank Alfalah Limited,
 | [NAME],
 | Sialkot.
 | Dear Sir,
 | Sub:- Submission of documents for issuance of PRC.
 | We had export consignments of Sports Goods to abroad.
 | The following documents are attached herewith for issuance of PRC.
 |  |  |  | Dated | Currency | Value
 | Copy of INVOICE :
 | Copy of HAWB : |  |  |  | VIA :
 | Copy of MAWB :
 | Copy of FIN INS : |  |  |  | Used Dated :
 | Copy of GD :
 | Thanks and regards,
 | From,
 | MAVIC SPORTS
 | Manager