tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 568474d1522686523-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-ef1136j_elo_wld_streaks
Sheet: Match

Weight_class | Match_type | Player 1 | result | Player 2 | Outcome | Method | Player_1 Last_5 | Player_2 Last_5 | Helper | Old ELO for player 1 | Old ELO for player 2 | Odds of Winning for player 1 | Odds of Winning for player 2 | New ELO for player 1 | New ELO for player 2 |  | Track Player
 |  | Adam | draw | Amy-Alice | KO | Punches and Elbows |  |  |  |  |  |  |  |  |  |  | Adam
 |  | Amy-Alice | def. | Olivia | Subm | Rear Naked Choke |  |  |  |  |  |  |  |  |  |  | Alicia
 |  | Grace | def. | Adam |  |  |  |  |  |  |  |  |  |  |  |  | Amy-Alice
 |  | Tyron | def. | [NAME]
 |  | Braxton | def. | Erin
 |  | Ellie | def. | Alicia
 |  | Amy-Alice | def. | Grace
 |  | Olivia | def. | [NAME]
 |  | Braxton | def. | Jessica
 |  | [NAME] | draw | [NAME]
 |  | [NAME] | def. | Tyron
 |  | Adam | def. | Braxton
 |  | Jessica | def. | Ellie
 |  | [NAME] | draw | [NAME]
 |  | Amy-Alice | def. | Grace
 |  | originalelo1 | originalelo2 | oddsofa2victory | oddsofb2victory | neweloofa2 | neweloofb2
Spreadsheet: 884549d1733783622-stuck-with-formula-to-look-up-to-row-based-on-conditions-bulk-barcodes-copy
Sheet: Barcode

"*DW- & [number] & "-" & [dte] & "*" |  |  |  |  |  |  | 33/11/2024
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
 |  | 01
 |  | 02
 |  | 03
 |  | 04
 |  | 05
 |  | 06
 |  | 07
 |  | 08
 |  | 09
Spreadsheet: 676838d1589014489-stop-counting-days-when-data-is-entered-in-a-new-field-rental-track
Sheet: BERYL BRAVO

SHIPPING & EQUIPMENT INFO. |  |  |  |  |  |  |  |  | RENTAL COSTS |  |  | BACKLOAD INFO.
DATE RCVD | MANIFEST | CONTAINER | VENDOR | WON | [NAME] | QUANTITY | RESPONSIBLE | STATUS | DAYS ONBOARD | DAY RENTAL | COST TO-DATE | RTN DATE | RTN DOC | MANIFEST | CCU
2020-04-11 00:00:00 | 40700 | AMF1622 | ATR | 1495512 | LOAD CELLS | 2 X CASES | [NAME] | CLOSED |  | 10 |  | 2020-04-25 00:00:00 | 103241 | 40842 | AMF680
2020-04-30 00:00:00 | 40800 | AMF588 | INSPECTAHIRE | 1524018 | INSPECTION EQUIPMENT | 1 X PALLET | OSM | CLOSED |  | 50 |  | 2020-05-05 00:00:00 | 103644 | 40972 | AME6370
2020-05-01 00:00:00 | 40900 | GCA542 | SULZER | 1537403 | GM5201A TOOL CHEST | 1 X CONT | OSM | OPEN |  | 150
Spreadsheet: 884613d1733840765-need-help-comparing-data-from-inpatient-and-outpatient-pharmacy-excel-files-outpatient
Sheet: Sheet1

merged
02/11/20240050023243
02/11/20240020002201
02/11/20240010209260
02/11/20240020067955
02/11/20240050082193
02/11/20240010272113
02/11/20240040022139
02/11/20240020298508
03/11/20240060172018
03/11/20240050168369
03/11/20240010282592
04/11/20240050007311
05/11/20240010294108
05/11/20240030054719
[NAME]
06/11/20240010293525
06/11/20240020308857
[NAME]
07/11/20240050254659
07/11/20240010296645
07/11/20240010295312
07/11/20240020094742
09/11/20240020002201
09/11/20240040017067
09/11/20240050023243
09/11/20240020298508
09/11/20240010023862
09/11/20240010150789
09/11/20240020035496
10/11/20240020361876
10/11/20240050168369
10/11/20240060182723
11/11/20240030054719
11/11/20240010209260
11/11/20240080033236
11/11/20240010245853
12/11/20240020210786
12/11/20240010252042
13/11/20240020063760
13/11/20240010241897
13/11/20240020308857
13/11/20240020094742
14/11/20240020051091
14/11/20240010006528
14/11/20240040053559
14/11/20240010300481
14/11/20240010191046
14/11/20240010095564
14/11/20240010294705
16/11/20240040022139
16/11/20240020299570
16/11/20240010286109
16/11/20240010117553
16/11/20240020008943
16/11/20240010241897
17/11/20240020063760
17/11/20240010291233
17/11/20240050007311
17/11/20240010301198
17/11/20240020317741
17/11/20240060185105
19/11/20240010268216
19/11/20240020056192
20/11/20240010005926
21/11/20240010076085
21/11/20240020035496
21/11/20240010300319
21/11/20240010016733
23/11/20240040022139
23/11/20240050082193
23/11/20240020067955
23/11/20240010241897
23/11/20240020298508
24/11/20240010282592
24/11/20240050168369
24/11/20240010301198
25/11/20240010234736
27/11/20240020051091
27/11/20240010293525
27/11/20240050039606
28/11/20240010293525
28/11/20240010064982
28/11/20240020051091
[NAME]
28/11/20240040009388
28/11/20240010295312
28/11/20240010296645
28/11/20240010191046
28/11/20240010016733
30/11/20240010286622
30/11/20240050023243
30/11/20240010272113
Spreadsheet: benjamin_rogers__1159__Base
Sheet: Allocation

ALLOCATION
 | Project | State Tax |  | Capacity (MW) |  | Cost Allocation Among Projects |  | Debt Allocation Among Projects |  | Debt Allocation Within the 1999 & 2000 Projects
 | Brownsville |  |  |  |  |  |  | 0.1569547974291141
 | Caledonia |  |  |  |  |  |  | 0.1573794526152645
 | New Albany |  |  |  |  |  |  | 0.1326696789793543
 | Sub Total |  |  |  |  | 0.4
 | [NAME] |  |  |  |  |  |  | 0.1674783895829259
 | [NAME] |  |  |  |  |  |  | 0.2205057573797393
 | Wheatland |  |  |  |  |  |  | 0.1650119240136019
 | Sub Total |  |  |  |  | 0.6
 | Total
 | Land as a Percentage of Total Project Cost (%)
 | 1999 Land/ Total 1999 Cost | 0.00347
 | 2000 Land/ Total 2000 Cost | 0.00617
Spreadsheet: 681792d1591749278-importing-data-from-several-sheets-for-voucher-system
Sheet: COA

 |  | Office Assigned | Account No. | [NAME]. |  | PLDT Bill
 |  |  |  |  |  | Invoice # | Basic Charges | Tolls |  | Amount | VAT | [NAME] | Cr. Adj. | Gross Amt. | 5%FVAT | 2%EWT | Net Amount
 |  |  |  |  |  |  |  | National calls | International calls
 | 1 | COA | 19887 | 831-8939 |  | 114664573 | 1720.75 | 0 | 0 | 1720.75 | 184.37 |  |  | 1720.75 | 76.82 | 30.73 | 1613.2 |  | 0.05 | 0.02
 |  |  |  |  |  | TOTAL | 1720.75 | 0 | 0 | 1720.75 | 184.37 |  |  | 1720.75 | 76.82 | 30.73 | 1613.2
Spreadsheet: lynn_blair__24311__FERC docket RM01-9_Sep2001
Sheet: Item 2 - PQ2TRANSW090101

Seq # | PHC | Pipeline DUNS # | Pipeline Name | Filing Date | First Day of Reporting Period | Name of Contact Person | Phone Number of Contact Person | Original/Revised Filing Indicator
Seq # | PDC | Pipeline DUNS # | Contract or Transaction ID # | Offer # | Releasing Shipper Name | Releasing Shipper DUNS # | Acquiring Shipper Name | Acquiring Shipper DUNS # | Contract Quantity | Releasing Shipper's Contract Rate | Acquiring Shipper's Contract Rate | Term Begin Date | Term End Date | Award Date
1 | PHC | 7933047 | Transwestern Pipeline Company | 2001-11-01 00:00:00 | 2001-09-01 00:00:00 | [NAME] | (402) 398-7060 | O
2 | PDC | 7933047 | 21165 | 3020 | Pacific Gas and Electric Company | 025301339 | Sempra Energy Trading Corp. | 609746565 | 15000 | 0.3138 | 0.3013 | 2001-05-01 00:00:00 | 2001-10-31 00:00:00 | 2000-12-27 00:00:00
3 | PDC | 7933047 | 21165 | 3067 | Pacific Gas and Electric Company | 025301339 | Texaco Natural Gas, Inc. | 183333145 | 50000 | 0.3138 | 0.2348 | 2001-06-01 00:00:00 | 2001-10-01 00:00:00 | 2001-04-06 00:00:00
4 | PDC | 7933047 | 21165 | 3072 | Pacific Gas and Electric Company | 025301339 | PG&E Energy Trading-Gas Corporation | 834692394 | 60000 | 0.3138 | 0.4455 | 2001-07-01 00:00:00 | 2001-10-31 00:00:00 | 2001-04-20 00:00:00
5 | PDC | 7933047 | 8255 | 3120 | Southern California Gas Company | 006908826 | ACN Power, Inc. | 59091384 | 478 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-22 00:00:00
6 | PDC | 7933047 | 8255 | 3122 | Southern California Gas Company | 006908826 | Sempra Energy Solutions, LLC | 968254276 | 182 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-22 00:00:00
7 | PDC | 7933047 | 8255 | 3124 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 4328568 | 2234 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-22 00:00:00
8 | PDC | 7933047 | 8255 | 3125 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 4328568 | 11 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-22 00:00:00
9 | PDC | 7933047 | 8255 | 3126 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 4328568 | 7 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-22 00:00:00
10 | PDC | 7933047 | 8255 | 3121 | Southern California Gas Company | 006908826 | TXU Energy Trading Company | 606252393 | 1245 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-23 00:00:00
11 | PDC | 7933047 | 8255 | 3123 | Southern California Gas Company | 006908826 | Exelon Energy Ohio, Inc. | 79333451 | 251 | 0.4006 | 0.4006 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-24 00:00:00
12 | PDC | 7933047 | 21165 | 3127 | Pacific Gas and Electric Company | 025301339 | Amoco Production Company | 8966889 | 13020 | 0.3138 | 0 | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 | 2001-08-30 00:00:00
Spreadsheet: df37f652-48f9-4aee-9dc2-4f46d5c6ccb7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4020 | 16444 | [NAME] | Onisseit | GER | 388 | 01:42:54 | 00:01:20 | 02:44:42 | 00:01:15 | 00:54:01 | 1 | 05:24:13
4020 | 14303 | [NAME] | [NAME] | USA | 389 | 02:51:58 | 00:30:00 | 02:42:46 | 00:01:46 | 01:09:59 | 2 | 06:16:30
Spreadsheet: 207255d1358417298-calculate-due-date-after-every-alternate-year-from-a-start-date-sample-data
Sheet: Sheet1

 |  | Next Due Date
Name | First Travel Date
A | 2009-01-01 00:00:00
B | 2008-05-01 00:00:00
C | 2011-10-24 00:00:00
D | 2007-08-12 00:00:00
E | 2014-02-11 00:00:00
F | 2007-06-09 00:00:00
G | 2011-01-09 00:00:00
H | 2012-07-06 00:00:00
I | 2013-04-30 00:00:00
J | 2005-10-22 00:00:00
K | 2016-08-06 00:00:00
L | 2013-05-04 00:00:00
N | 2012-03-18 00:00:00
O | 2010-12-22 00:00:00
Spreadsheet: 154156d1336251134-help-with-complicated-look-up-gavgav-lookup-tables-2-
Sheet: SUMMARY

JOB:
number of lines
number of items
price
buy price | 10
historic price
saving
%
supplier | kuhnel
supplier po
client mj number
quote number
Spreadsheet: 578893d1529554982-show-0-0-5-1-depending-on-various-condition-new-microsoft-office-excel-worksheet-2-
Sheet: Sheet1

5 | 6 | 2018 |  |  |  |  |  |  | 2 | 2 | 2018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  | PRINCIPAL
 |  |  |  |  |  |  |  |  |  | INTERTEST | 0.025
23 | 2 | 2018 |  |  |  |  |  |  | 11 | 9 | 2018
Spreadsheet: larry_campbell__20962__Performance Excel File
Sheet: ENRON6800

 | 1 | 2 | 3 | 4 | 5
Ambient Temperature (°C) | 15 | 20 | 25 | 30 | 35
Ambient Temperature (°F) | 59 | 68 | 77 | 86 | 95
Pressure (PSI) | 11.4 | 11.4 | 11.4 | 11.4 | 11.4
Elevation (ft ASL) | 6800 | 6800 | 6800 | 6800 | 6800
Relative Humidity (%) | 60 | 60 | 60 | 60 | 60
Mode | MD | MD | MD | MD | MD
Power Turbine | RT62 | RT62 | RT62 | RT62 | RT62
Limit | Base Co | Base Co | Base Co | Base Co | Base Co
Control Parameter | Rating | Rating | Rating | Rating | Rating
PT Speed (RPM) | Actual | Actual | Actual | Actual | Actual
PT Capacity Factor | 1 | 1 | 1 | 1 | 1
Bleed Take off | IP7 | IP7 | IP7 | IP7 | IP7
Nozzle Area (Sq In) | - | - | - | - | -
Combustor | DLE | DLE | DLE | DLE | DLE
Fuel | Nat Gas | Nat Gas | Nat Gas | Nat Gas | Nat Gas
Lower Cal Value (CHU/lb) | 11730 | 11730 | 11730 | 11730 | 11730
Lower Heating Value (Btu/lb)
Water Fuel Ratio | - | - | - | - | -
Water Temp (°C) | - | - | - | - | -
Losses | Mod | Mod | Mod | Mod | Mod
Inlet Loss (in H2O) | 2.5 | 2.5 | 2.5 | 2.5 | 2.5
Exhaust Loss (in H2O) | 4 | 4 | 4 | 4 | 4
Generator Efficiency (%) | - | - | - | - | -
[NAME] (%) | - | - | - | - | -
Brochure GG Power (EGHP) | - | - | - | - | -
Shaft Power (HP) | 29034 | 27775 | 26509 | 25286 | 24095
Heat Rate (BTU/HP.Hr) | 6906 | 6986 | 7078 | 7180 | 7294
Guarantee Power (HP) | 29034 | 27775 | 26509 | 25286 | 24095
Guarantee Heat Rate (BTU/HP.Hr) | 7113 | 7195 | 7290 | 7396 | 7513
BOV Status | Closed | Closed | Closed | Closed | Closed
IP Speed (RPM) | 6614 | 6626 | 6629 | 6636 | 6645
HP Speed (RPM) | 9308 | 9321 | 9334 | 9352 | 9374
PT Speed (RPM) | 4800 | 4800 | 4800 | 4800 | 4800
GG Inlet Flow (lb/s) | 153.4 | 149 | 144.5 | 140 | 135.5
Water Flow (lb/Hr) | - | - | - | - | -
Fuel Flow (lb/Hr) | 9496 | 9190 | 8886 | 8599 | 8324
GG [NAME] (lb/s) | 154.5 | 150.1 | 145.5 | 141 | 136.5
GG Exit Temp (K) | 1040 | 1040 | 1040 | 1040 | 1040
GG Exit Press (PSI) | 43.9 | 42.6 | 41.4 | 40.2 | 39
True PTET (Ref) (°C) | 779.1 | 779.1 | 779 | 779.1 | 779.1
PT [NAME] (lb/s) | 155.9 | 151.4 | 146.8 | 142.2 | 137.7
PT [NAME] (K) | 775.9 | 780.6 | 785.6 | 790.9 | 796.4
PT Exit Press (PSI) | 11.5 | 11.5 | 11.5 | 11.5 | 11.5
Message Code 1 | 301 | 301 | 301 | 301 | 301
Message Code 2 | 0 | 0 | 0 | 0 | 0
NOx (vppm) | 25 | 25 | 25 | 25 | 25
NOx (tons/yr)
CO (vppm) | 5 | 5 | 5 | 5 | 5
CO (tons/yr)
Spreadsheet: 63251d1264169080-running-calculator-for-instructors-demodata
Sheet: Sheet1

Instructor | Points | reception | enthusiasm | knowledge | communication | informed | structure | students taught
Excellent | 5 | 5
Very good | 4 | 5
Good | 3 | 5
Average | 2 | 5
Poor | 1 | 5 |  |  |  |  |  | Average score
POINTS AV |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | is there a way of adding the data each week and excel works out the running total? rather than me having to update each field.
 |  |  | I’m not too sure if excel can do what I want it to do but here goes.
Each week I get instructor feedback, on each section they are marked from 1 to 5. What I want is a system where I can input the info into excel which works out how they are scoring throughout the year.
The maximum number of students is 5 so the maximum score available in each week would be 25 (all five students thought that he was excellent). We have then divided the score by the students taught to give us a average score for each section.
This part is fairly straight forward; the problem is when I then have to input new data. What I want is to be able to put what they scored that week rather than having to add the numbers up in my head to get a running total. So I can see what they are averaging throughout the year.
Spreadsheet: 722798d1615409724-how-to-countif-a-date-is-within-a-date-range-and-is-a-monday-spreadsheet-sample-help
Sheet: Staff Audit

Name | Room | Start date | Mon | Tue | Wed | Thu | Fri
[NAME] | Baby Room | 2021-01-01 00:00:00 | y | y | y | y | y
[NAME] | Baby Room | 2021-01-01 00:00:00 | y | y | y
Aruba | 2-3s | 2021-01-01 00:00:00 |  | y | y | y
Bradley |  | 2021-01-01 00:00:00 | y | y | y
Chloe |  | 2021-01-01 00:00:00 | y |  | y | y | y
Connie |  | 2021-01-01 00:00:00 | y | y |  | y | y
Cristina |  | 2021-01-01 00:00:00 |  |  | y
[NAME] |  | 2021-01-01 00:00:00 |  | y | y |  | y
Faye | Kitchen | 2021-01-01 00:00:00 | y | y | y |  | y
Helena | 2-3s | 2021-01-01 00:00:00 |  | y |  | y
Jaspal | Baby Room | 2021-01-01 00:00:00 | y | y |  | y | y
Kylie | 2-3s | 2021-01-01 00:00:00 |  | y | y | y
Lindsey | 2-3s | 2021-01-01 00:00:00 | y | y | y |  | y
[NAME] | 2-3s | 2021-01-01 00:00:00 | y | y |  |  | y
Olufemi | 2-3s | 2021-01-01 00:00:00 | y | y | y | y | y
Pascal | 2-3s | 2021-01-01 00:00:00 | y | y | y
[NAME] |  | 2021-01-01 00:00:00 |  | y | y
Samra |  | 2021-01-01 00:00:00 | y |  | y |  | y
[NAME] | Preschool | 2021-01-01 00:00:00 | y |  |  | y | y
Spreadsheet: 815720d1675170020-partial-matche-example-booklet
Sheet: Sheet1

Table Array | Lookup Value | Multiple Returns |  | Final Result Required:
123-789-789 | 123-123 | 123-123-123, 123-123-456, 123-123-789 |  | 123-123 | 123-123-123
123-123-456 | 123-456 | 123-456-123 |  | 123-123 | 123-123-456
123-456-123 | 123-789 | 123-789-123, 123-789-456 |  | 123-123 | 123-123-789
000-123-123 | 000-123 | 000-123-123, 000-123-456, 000-123-789, 000-123-000 |  | 123-456 | 123-456-123
123-789-123 |  |  |  | 123-789 | 123-789-123
123-789-456 |  |  |  | 123-789 | 123-789-456
000-123-456 |  |  |  | 000-123 | 000-123-123
123-123-123 |  |  |  | 000-123 | 000-123-456
000-123-789 |  |  |  | 000-123 | 000-123-789
000-123-000 |  |  |  | 000-123 | 000-123-000
Spreadsheet: 9a8767d7-e471-4f78-b13e-f7e72641ea8d
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
 |  |  |  |  |  |  |  | ANEXO DE EXCLUSIONES
PLAN ANUAL DE ADQUISICIONES Y CONTRATACIONES
 | B) NOMBRE DE LA UNIDAD EJECUTORA :
 | C) SIGLAS : |  |  |  |  |  |  |  |  |  |  | F) N º DE LA UNIDAD EJECUTORA :
 | E) PLIEGO :
N. REF | ÍTEM ÚNICO | PRECEDENTE | ANTECEDENTES | TIPO DE PROCESO | CIIU | OBJETO | [NAME] | SÍNTESIS DE ESPECIFICACIONES TÉCNICAS | CATÁLOGO DE BIENES Y SERVICIOS | UNIDAD DE MEDIDA | CANTIDAD | VALOR ESTIMADO | TIPO DE MONEDA | FUENTE DE FINANCIAMIENTO | FECHA PROBABLE DE CONVOCATORIA | TIPO DE CONVOCATORIA | MODALIDAD | NOMBRE DE LA ENTIDAD CONVOCANTE DE LA COMPRA CORPORATIVA O ENCARGADA | ÓRGANO ENCARGADO DE LA ADQUISICIÓN O CONTRATACIÓN | CÓDIGO DE UBICACIÓN GEOGRÁFICA |  |  | OBSERVACIONES | OFICINA USUARIA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEPA | PROV | DIST
1 | - SI | (*) | (*) | - LICITACION PUBLICA |  | - BIENES | - | DEFINICION CONCRETA DE LA NATURALEZA DE LA ADQUISICION O CONTRATACION |  |  |  |  | - SOLES | 00 RECURSOS ORDINARIOS |  |  | - CONVOCATORIA TRADICIONAL
 | - NO |  |  | - CONCURSO PUBLICO |  | - SERVICIOS EN GENERAL |  |  |  |  |  |  | -DOLARES | 09 RECURSOS DIRECTAMENTE RECAUDADOS |  |  | - SUBASTA INVERSA
 |  |  |  | - ADJUDICACION DIRECTA PUBLICA |  | - SERVICIOS DE CONSULTORIA |  |  |  |  |  |  |  | 13 DONACIONES Y TRANSFERENCIAS |  |  | - CONVENIO MARCO
 |  |  |  | - ADJUDICACION DIRECTA SELECTIVA |  |  |  |  |  |  |  |  |  |  |  |  | - PROCEDIMIENTO DE SELECCIÓN ABREVIADO
 |  |  |  | - ADJUDICACION DE MENOR CUANTIA
 |  | (*) EN EL CAMPO PRECEDENTE Y ANTECEDENTE SOLO SE DEBERA REGISTRAR INFORMACION CUANDO EL PROCESO A INCLUIR DEVIENE DE UNO DEL AÑO ANTERIOR.
NOTA: |  | - DEBERA CONSIDERARSE QUE SE REGISTRA UN PROCESO DE SELECCIÓN POR LINEA DE ACUERDO A LO CORRESPONDIENTE A LA ADQUISICION O CONTRATACION A INCLUIRSE
Spreadsheet: 833992d1687378999-restructure-zip-code-data-results
Sheet: Data Set with Desired Results

zip | primary_city | acceptable_cities | state | county |  | DESIRED RESULTS
1093 | Whately |  | MA | Franklin County |  | Unique City | Zip Code(s) | State | County(s)
1094 | Wheelwright |  | MA | Worcester County |  | Pittsfield | 1201, 1202, 1203 | MA | Berkshire County
1097 | Woronoco |  | MA | Hampden County |  | Indian Orch | 1151 | MA | Hampden County
1098 | Worthington |  | MA | Hampshire County |  | [NAME] | 1151 | MA | Hampden County
1101 | Springfield |  | MA | Hampshire County |  | East Longmeadow | 1116 | MA | Hampden County
1102 | Springfield |  | MA | Hampden County |  | E Longmeadow | 1116 | MA | Hampden County
1103 | Springfield |  | MA | Hampden County |  | Longmeadow | 1116 | MA | Hampden County
1104 | Springfield |  | MA | Hampden County |  | Longmeadow | 1106 | MA | Hampden County
1105 | Springfield |  | MA | Hampden County |  | Woronoco | 1097 | MA | Hampden County
1106 | Longmeadow | Springfield | MA | Hampden County |  | Springfield | 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1115, 1118, 1119, 1128, 1129, 1133, 1138, 1139, 1144, 1151, 1152, 1195, 1199 | MA | Hampden County, Hampshire County
1107 | Springfield |  | MA | Hampden County |  | Worthington | 1098 | MA | Hampshire County
1108 | Springfield |  | MA | Hampden County |  | Whately | 1093 | MA | Franklin County
1109 | Springfield |  | MA | Hampden County |  | Wheelwright | 1094 | MA | Worcester County
1111 | Springfield |  | MA | Hampden County
1115 | Springfield |  | MA | Hampden County
1116 | Longmeadow | E Longmeadow, East Longmeadow | MA | Hampden County
1118 | Springfield |  | MA | Hampden County
1119 | Springfield |  | MA | Hampden County
1128 | Springfield |  | MA | Hampden County
1129 | Springfield |  | MA | Hampden County
1133 | Springfield |  | MA | Hampden County
1138 | Springfield |  | MA | Hampden County
1139 | Springfield |  | MA | Hampden County
1144 | Springfield |  | MA | Hampden County
1151 | [NAME] | Indian Orch, Springfield | MA | Hampden County
1152 | Springfield |  | MA | Hampden County
1195 | Springfield | Springfield Bmc | MA | Hampden County
1199 | Springfield |  | MA | Hampden County
1201 | Pittsfield |  | MA | Berkshire County
1202 | Pittsfield |  | MA | Berkshire County
1203 | Pittsfield |  | MA | Berkshire County
Spreadsheet: 216394d1361754326-returning-multiple-results-into-different-columns-from-a-master-list-return-multiple-values-in-columns
Sheet: Relation

Relevant Results | Type of Name 1 | Type of Name 2 | Type of Name 3 | Type of Name 4 | Type of Name 5 | Type of Name 6 | Type of Name 7
1
2 |  |  |  |  |  |  |  | Obviously this method doesnt work for a second column.  I am open to any suggestions however when I put this into practice it will be against 100+ catagories of "Type of Name" and therefore I need it to be automatic will very little mannual entry.  If there is some way to even avoid having to name ranges that would be preferable.
3
4
5
6
7
8
9
10
 | yes
Should Look Like
Relevant Results | Type of Name 1 | Type of Name 2 | Type of Name 3 | Type of Name 4 | Type of Name 5 | Type of Name 6 | Type of Name 7
1 | Returned Result 1 | Returned Result 9 | Returned Result 18
2 | Returned Result 5 | Returned Result 11 | Returned Result 19
3 | Returned Result 8 | Returned Result 13 | Returned Result 21
4 | Returned Result 11 | Returned Result 14 | Returned Result 23
5 |  | Returned Result 15 | Returned Result 25
6
7
8
9
10
Spreadsheet: 70404d1271169129-vlookup-sample
Sheet: FTE

First Name | M.I. | Last Name | Suffix | Birth Date | Home Phone | Work Phone | [NAME] | Address1 | Address2 | Address3 | City | State | Zip Code | Country | EMail | Pop-up Address | Is Supervisor | Is Team Lead | Supervisor | Team Lead | Organization | Employee ID | Data Source IDs | Proficiency | Rank | Quality Score | Min Paid Hrs | [NAME]
[NAME] |  | [NAME] |  | 01/01/1900 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 123456 |  | 1.0 | 2 |  | 37:00 | 37:00
Spreadsheet: dan_hyvl__4704__Total Updated TQ List
Sheet: New Additions

US Gas
Product ID | EOL Product Type | Location | EOL-Location | EOL Comments | TQ Product Name | Ref Per | Tok Ref Per | Date Added to EOL
43806 | US Gas Phy | RkyMtn | NWPL RkyMtn Pool | NWPL RkyMtn Pool | [NAME] |  | Day Ahead US Nat Gas | 2001-02-27 00:00:00
43800 | US Gas Phy | RkyMtn | NWPL RkyMtn Pool | NWPL RkyMtn Pool | [NAME] |  | Prompt Month | 2001-02-27 00:00:00
43804 | US Gas Phy | RkyMtn | NWPL RkyMtn Pool | NWPL RkyMtn Pool | [NAME] |  | Day Ahead +1 US Nat Gas | 2001-02-27 00:00:00
43814 | US Gas Phy | SanJuan | NWPL SanJuan Pool | NWPL SanJuan Pool | [NAME] |  | Day Ahead US Nat Gas | 2001-02-27 00:00:00
43810 | US Gas Phy | SanJuan | NWPL SanJuan Pool | NWPL SanJuan Pool | [NAME] |  | Prompt Month | 2001-02-27 00:00:00
43816 | US Gas Phy | SanJuan | NWPL SanJuan Pool | NWPL SanJuan Pool | [NAME] |  | Day Ahead +1 US Nat Gas | 2001-02-27 00:00:00
27873 | US Gas Phy | Opal |  | Opal | [NAME] |  | Day Ahead +1 US Nat Gas | Not on Schedule A, but starts trading midday.
27784 | US Gas Phy | [NAME] |  | EPNG [NAME] | [NAME] |  | Day Ahead +1 US Nat Gas | Not on Schedule A, but starts trading midday.
43788 | US Gas Phy | [NAME] |  | SoCal EHR | [NAME] |  | Day Ahead US Nat Gas | 2001-02-27 00:00:00
43786 | US Gas Phy | [NAME] |  | SoCal EHR | [NAME] |  | Day Ahead +1 US Nat Gas | 2001-02-27 00:00:00
44317 | US Gas Phy GD/D | TCO | TCO Pool | GD/D TCO Pool |  |  | Day Ahead US Nat Gas | 2001-03-02 00:00:00
44293 | US Gas Phy GD/D | TCO | TCO Pool | GD/D TCO Pool |  |  | Day Ahead +1 US Nat Gas | 2001-03-03 00:00:00