tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -1960 | -1613 | -1385 | -2000
2 | -2106 | -1613 | -811 | -2000
3 | -2069 | -1613 | -2341 | -2000
4 | -2166 | -1613 | -2354 | -2000
5 | -2259 | -1613 | -2518 | -2000
6 | -2152 | -1613 | -2440 | -2000
7 | -2005 | -1613 | -2470 | -2000
8 | -933 | -1613 | -2314 | -2000
9 | -1857 | -1613 | -787 | -2000
10 | -2242 | -1613 | -2568 | -2000
11 | -2215 | -1613 | -2555 | -2000
12 | -2377 | -1613 | -2610 | -2000
13 | -2305 | -1613 | -2633 | -2000
14 | -2219 | -1613 | -2604 | -2000
15 | -2198 | -1613 | -2274 | -2000
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-11-30 00:00:00
2001-12-15 00:00:00
CBS Volume
Spreadsheet: 773951d1648130542-how-to-select-a-cell-at-random-without-repeating-cells-switch-list-generator-vtest2
Sheet: Industry statistics

[NAME]
Inbound
Boxcar |  |  |  | flat car |  |  |  | Hopper |  |  |  | Gondola |  |  |  | Tank |  |  |  | Stock |  |  |  | Reefer |  |  |  | [NAME]
lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load
0 | 0.15 | Dry Goods |  | 0 | 0.15 | Wood |  | 0 | 0.15 | Coal |  | 0 | 0.25 | Steel |  | 0 | 0.25 | Oil |  | 0 | 0.5 | Cow |  | 0 | 0.2 | Beer |  | 0 | 0.25 | Grain
 | 0.2 | Wood |  |  | 0.25 | Tractors |  |  | 0.25 | Sand |  |  | 0.75 | Pipes |  |  | 0.25 | Fuel |  |  | 0.25 | Pig |  |  | 0.35 | Fruit |  |  | 0.75 | Corn
 | 0.15 | Pallets |  |  | 0.35 | Steel |  |  | 0.35 | Gravel |  |  | 0 |  |  |  | 0.5 | Chemicals |  |  | 0.25 | Sheep |  |  | 0.45 | Veggys |  |  | 0
 | 0.5 | Empty |  |  | 0.25 | Empty |  |  | 0.25 | Cinders |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test
Outbound |  |  |  | Outbound |  |  |  | Outbound |  |  |  | Outbound |  |  |  | Outbound |  |  |  | Outbound |  |  |  | Outbound |  |  |  | Outbound
Boxcar
lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load |  | lookup | disrabution | Load
0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty |  | 0 | 0.7 | empty
 | 0.15 | B New 1 |  |  | 0.15 | F New 1 |  |  | 0.15 | H New 1 |  |  | 0.15 | G New 1 |  |  | 0.15 | T New 1 |  |  | 0.15 | S New 1 |  |  | 0.15 | R New 1 |  |  | 0.15 | C New 1
 | 0.15 | B New 2 |  |  | 0.15 | F New 2 |  |  | 0.15 | H New 2 |  |  | 0.15 | G New 2 |  |  | 0.15 | T New 2 |  |  | 0.15 | S New 2 |  |  | 0.15 | R New 2 |  |  | 0.15 | C New 2
 | 0 | - |  |  | 0 | - |  |  | 0 | - |  |  | 0 | - |  |  | 0 | - |  |  | 0 | - |  |  | 0 | - |  |  | 0 | -
Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test | Total |  |  | Test
Spreadsheet: 847948d1698781201-delete-everything-after-the-last-special-character-hyphen-excel-workaround
Sheet: Sheet1

[NAME] (current) | Client Name (desired) | Current Result | Current problem | New Formula
Major Motor Company | Major Motor Company |  | Vaue not generated, because column A has not hyphen
Major Motor Company - Detroit | Major Motor Company |  | Last character is an unwanted space
Major Motor Company - Engines - Detroit | Major Motor Company - Engines |  | Last character is an unwanted space
Major Motor Company - Transmissions - Automatic - Detroit | Major Motor Company - Transmissions - Automatic |  | Last character is an unwanted space
Major Motor Company - Transmissions - Manual - Detroit | Major Motor Company - Transmissions - Manual |  | Last character is an unwanted space
North Car Company | North Car Company |  | Vaue not generated, because column A has not hyphen
North Car Company - Engines - Jacksonville | North Car Company - Engines |  | Last character is an unwanted space
North Car Company - Fasteners - New York | North Car Company - Fasteners |  | Last character is an unwanted space
North Car Company - Wheels - New York | North Car Company - Wheels |  | Last character is an unwanted space
North Car Company - Zimbabwe | North Car Company |  | Last character is an unwanted space
Spreadsheet: 46021d1244803873-pdf-hypelinks-in-excel-can-not-open-pdf-and-excel-and-doc-document-register-of-po
Sheet: Report Form

Item | PO | Pdf | [NAME] | TA
1 | 3435-510-PO-0001A | Pdf | Xls | TA
2 | 3435-510-PO-0001A Add1 | Pdf | Xls | -
3 | 3435-510-PO-0001A Add2 | Pdf | Xls | TA
4 | 3435-510-PO-0002A | Pdf | Xls | -
5 | 3435-510-PO-0002B | Pdf | Xls | TA
6 | 3435-510-PO-0003A | Pdf |  | -
7 | 3435-510-PO-0004A | Pdf | Doc | -
8 | 3435-510-PO-0004B | Pdf | Xls | -
9 | 3435-510-PO-0005A | Pdf | Xls | TA
10 | 3435-510-PO-0005A Add1 | Pdf | Xls | TA
11 | 3435-510-PO-0006A | Pdf | Xls
12 | 3435-510-PO-0007A | Pdf
13 | 3435-510-PO-0007A Add1 | Pdf | Xls
14 | 3435-510-PO-0007A Add 2 | Pdf
 | 3435-510-PO-0007A Add3 |  | Xls
Spreadsheet: sally_beck__33911__GlobalMgmtSum-Q101-0118
Sheet: GM-WeeklyChnge

ENRON GLOBAL MARKETS
1st QUARTER 2001 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Crude & Products
Coal
Emissions
Weather
Global Risk Markets
Equity Trading
Convertible Trading
FX / Int Rate Trading
Soft Commodities Trading
Grain Trading
Meat Trading
Financial Trading
Transportation
LNG
Middle East
Puerto Rico
Finance and Structuring
Office of the Chairman
Total Gross Margin Change
Other Interest Related Charges
Change in EGM Pre-tax Income
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 828947d1683807404-creating-a-list-based-on-one-the-value-of-a-changing-cell-test-productcoding
Sheet: Productlist

Productlist
SACXX00BLYA
SACXX00M
SACXX00MXYA
SACXX00SO
RCOPE25WK1
SCO00CNLFAS
RCOXX00WK1F
SCO00CNMFAS
SCO00CNSFAS
SCoWasteMixColKnit
SCoWasteMixColWoven
SCoWasteOptWhKnit
SCoWasteOptWhWoven
SCOXX00WHLHM
ICOXX00WHKNDVA
SCOXX00WHKNPREC
SCOXX00WHLFY
SCO00WNLFAS
SCO00WNMFAS
SCO00WNSFAS
SCO00WOLF
[NAME]
SCO00WOMF
SCO00WOMFAS
SCO00WOSF
SCO00WOSFAS
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Scheduled | Measured | Scheduled | Measured
1 |  |  | 28261 | 32518
2 |  |  | 15248 | 16267
3 |  |  | 15248 | 16171
4 |  |  | 33781 | 35902
5 |  |  | 43200 | 43017
6 |  |  | 72748 | 72064
7 |  |  | 39748 | 42722
8 |  |  | 97083 | 82378
9 |  |  | 90041 | 103739
10 |  |  | 75041 | 75942
11 |  |  | 56886 | 57625
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-05-31 00:00:00 |  |  |  |  | 327664.29
2001-06-11 00:00:00
Spreadsheet: 158296d1338155336-excel-2007-combine-worksheets-with-criteria-ptmultranges
Sheet: comb

A | B | C | D
orange | sheet1 | sheet1 | 2000
orange | sheet2 | sheet2 | 1500 |  |  | i need combine sheet like this
orange | sheet2 | sheet2 | 4000
orange | sheet3 | sheet3 | 3000
orange | sheet3 | sheet3 | 2500
Count of Value | Column Labels
Row Labels | B | C | D | Grand Total |  | <<[NAME] from Consolidated Multiple Ranges
apple |  |  | 3 | 3
banana |  |  | 3 | 3
grape |  |  | 2 | 2
orange | 5 | 5 | 5 | 15
Grand Total | 5 | 5 | 13 | 23
Spreadsheet: 35279d1232835286-excel-2007-avoid-the-div-0-error-qc-sheet-master
Sheet: Weekly Review

 |  |  |  |  |  |  |  | Weekly QC Report
 |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 | Thru
 |  |  |  |  |  |  |  | System:
 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Completion % | Jobs taken to QC | Total QC Completed | Work QC'd % | Pass | Fail | QC Failure %
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | [NAME]
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | [NAME]
 | 10 | [NAME]
 | 11 | [NAME]
 | 12 | [NAME]
 | 13 | [NAME]
 | 14 | [NAME]
 | 15 | [NAME]
 | 16 | [NAME]
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Totals |  |  |  |  | Total Jobs | Completed | Not Completed | Total Comp % | Total Jobs taken to QC | Total QC Completed | Total QC % | Pass | Fail | QC Failure %
Spreadsheet: 112205d1308318250-simplify-a-complex-formula-sample1
Sheet: August

August Numbers as of /Date
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total
name | 7
name | 8
name | 9
name | 10
name | 13
name | 16
name | 20
name | 23
name | 24
---------------------------------------------------------------------------------
name | 21
name | 22
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
Spreadsheet: 203502d1357147303-help-need-an-advanced-filter-to-do-this-matching-combos
Sheet: Sheet3

Here will be written all extracted combos from the sheet 2 which match less than 5 numbers, after finished matching FOR EACH combo from sheet 1.
e.g.
1 | 2 | 3 | 4 | 5 | 15
1 | 2 | 3 | 4 | 5 | 16
1 | 2 | 3 | 4 | 5 | 17
1 | 2 | 3 | 4 | 5 | 18
1 | 2 | 3 | 4 | 5 | 19
1 | 2 | 3 | 4 | 5 | 20
1 | 2 | 3 | 4 | 5 | 21
1 | 2 | 3 | 4 | 5 | 22
1 | 2 | 3 | 4 | 5 | 23
1 | 2 | 3 | 4 | 5 | 24
1 | 2 | 3 | 4 | 5 | 25
1 | 2 | 3 | 4 | 5 | 26
1 | 2 | 3 | 4 | 5 | 27 |  |  | And that's all.
1 | 2 | 3 | 4 | 5 | 28
1 | 2 | 3 | 4 | 5 | 29
1 | 2 | 3 | 4 | 5 | 30
1 | 2 | 3 | 4 | 5 | 31
1 | 2 | 3 | 4 | 5 | 32
1 | 2 | 3 | 4 | 5 | 33
1 | 2 | 3 | 4 | 5 | 34
1 | 2 | 3 | 4 | 5 | 35
 |  |  |  |  |  | Thank you so much !
Spreadsheet: 49760d1249071978-vlookup-functions-example
Sheet: Supplier A

Part Name | Part Number | Package Type | Cost
101 | AB | Bag | 0.62216
101 | AB | Box | 0.64438
102 | AC | Bag | 2.72195
102 | AC | Box | 2.95526
103 | AD | Bag | 3.07747
103 | AD | Box | 3.21079
104 | AE | Bag | 3.32189
104 | AE | Box | 4.72175
Spreadsheet: 125566d1319105422-merge-problem-test_merge
Sheet: Sheet1

1130526816 | 20/05/2011 | 14:20:56 | 0 | punter | null | A C | 20/05/2011 | 15:39:20 | [NAME] | 548939992 | 42 | 679.74
1128592248 | 18/05/2011 | 14:02:19 | 0 | punter | null | A C | 18/05/2011 | 16:14:13 | Buy Chips | 547349630 | -42 | 400
1128052262 | 17/05/2011 | 20:26:28 | 0 | punter | null | A C | 17/05/2011 | 20:26:28 | Sell Chips | 546886583 | 1.5
1128051431 | 17/05/2011 | 20:25:32 | 0 | punter | null | A C | 17/05/2011 | 20:25:32 | Buy Chips | 546885890 | -2
1128051194 | 17/05/2011 | 20:25:19 | 0 | punter | null | A C | 17/05/2011 | 20:25:19 | Buy Chips | 546885687 | -25
1127805314 | 17/05/2011 | 15:50:18 | 0 | punter | null | A C | 17/05/2011 | 16:53:46 | Sell Chips | 546694776 | 25 | 155.15
1127729532 | 17/05/2011 | 14:07:59 | 0 | punter | null | A C | 17/05/2011 | 16:53:46 | Buy Chips | 546635473 | -25 | 124.16
Spreadsheet: 752864d1635023155-reconcile-entries-from-2-sheets-reconcile-1_answer
Sheet: Insurance Payment

Name | Date of Service | ETF number | Invoiced | Paid 1 | Paid 2 | Total | Payment Date | Key
Test, Adam | 2021-09-15 00:00:00 | xyz-123 | gdf | 5 | 1 |  | 2021-10-05 00:00:00
Test, Adam | 2021-04-04 00:00:00 | xx-23 | [NAME] | 34 | 2 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-06-05 00:00:00 | 564-ax | cc | 23 | 3 |  | 2021-10-07 00:00:00
Test, [NAME] | 2021-09-27 00:00:00 | 785-21 | v b | 345 | 4 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-08-05 00:00:00 | azxc-1 | hfgh | 23 | 5 |  | 2021-10-15 00:00:00
Test, [NAME] | 2021-04-07 00:00:00 | zds-234 | fhgf | 25 | 6 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-01-01 00:00:00 | fhghm-9 | sfw | 12 | 7 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-04-08 00:00:00 | sfdfg-3 | ghg | 76 | 8 |  | 2021-10-18 00:00:00
Test, Mary | 2021-09-27 00:00:00 | bfghf-23 | cvcv | 23 | 1 |  | 2021-10-07 00:00:00
Test, Mary | 2021-07-07 00:00:00 | cbgn-332 | v b | 4 | 2 |  | 2021-10-05 00:00:00
Test, Mary | 2021-04-06 00:00:00 | cbnb-56 | 464c\456v | 67 | 3 |  | 2021-10-18 00:00:00
Tester / Ken | 2021-10-01 00:00:00 | bfgnm-3 | 4564x | 52 | 4 |  | 2021-10-07 00:00:00
Testing, Brook | 2021-10-05 00:00:00 | cg-2345 | xvcb4 | 23 | 6 |  | 2021-10-07 00:00:00
Testing, Brook | 2021-03-04 00:00:00 | cvn-4567 | 53dc | 3 | 2 |  | 2021-10-07 00:00:00
Testing, Brook | 2021-04-20 00:00:00 | xcvb-4323 | 354wws | 8 | 2 |  | 2021-10-18 00:00:00
Spreadsheet: 735312d1622834588-formula-or-macro-that-will-count-the-first-positive-in-a-set-of-percentages-stock-short-term-comparison-2
Sheet: Sheet1

0.003966336138655047
0.0005904657565432014
0.003197061263182865
-0.0003874329965342094
7.775296300227552e-05
5.69513897439311e-05
0.0008506777065730997
-0.0004344212753097931
0.00101094083634079 |  |  |  |  | 67c
-0.0005240729030006053
-0.001033821961173742
-0.0001562145504045986
-0.000512681237781254
0.0005555121992748546 |  |  |  |  | 62c
-0.000689927554061387
-0.0007239898201496509
0.0008712634313861045 |  |  |  |  | 59c
-0.0002932426488324591
0.0004187030141884485 |  |  |  |  | 57c
0.0008134099136698492
-0.001089177918748852
0.0008633045880501733 |  |  |  |  | 54c
0.0008176595558644362
0.0001582035631220169
-0.0005595270697779098
-0.0004299195672459177
-0.0007420483843904035
0.000527387492639031 |  |  |  |  | 48c
0.0005672927372348813
-0.001353643498022805
-0.000567739615687457
0.0001680517125890457 |  |  |  |  | 44c
0.0003289473684209288
0.001213629556729545
-9.215239643500794e-05
0.000462931236161257 |  |  |  |  | 40c
7.345839526706754e-05
-0.0005999055266886488
-0.0004107329385130143
-0.0004283969490193051
0.0003074805282043958 |  |  |  |  | 35c
-0.0004374339415635919
-0.0005795579274061602
-7.574125839360235e-05
-0.001086495967656087
-0.002926540284360235
-0.001059974094803517
6.423692481205556e-05 |  |  |  |  | 28c
0.000392533769798975
-0.000159329958074883
9.98943973513633e-05 |  |  |  |  | 25c
-0.003812255342627302
-0.009647085224275043
0.002381629632486559 |  |  |  |  | 22c
-0.002529879999038198
-0.004392711281697492
-0.002256899040091631
0.002024153932780548 |  |  |  |  | 18c
-9.204133140205961e-05
0.004917397412916191 |  |  |  |  | 16c
-0.001680125346510852
0.002040308774776456 |  |  |  |  | 14c
0.0001903623631922535
-0.0015493510842568
-0.001411322770651813
-0.0007998086258513837
0.0009914925106040418
0.002848321447208146
0.001042863647204406
-0.0008179719925812678
-0.001912331406551004
0.00321665226854817
-0.002681971140547468
0.001119086208227316
-0.001298519831939293
0.002216867004865675 |  | 14c/16c/18c/22c/25c/28c/35c/40c/44c/48c/54c/57c/59c
Spreadsheet: louise_kitchen__23094__NETCO_All  Gas List_120601
Sheet: Gas Logistics

[NAME] | Manager | Logistics (Central Desk) | 1
[NAME] | Sr. Spec | Logistics (Central Desk) | 2
[NAME] | Sr. Spec | Logistics (Central Desk) | 3
[NAME] | Sr. Spec | Logistics (Central Desk) | 4
[NAME] | Manager | Logistics (Central Desk) | 5
[NAME] | Spec | Logistics (Central Desk) | 6
[NAME] | Sr. Spec | Logistics (Central Desk) | 7
[NAME] | Sr. Spec | Logistics (Central Desk) | 8
[NAME] | Anaylst | Logistics (Central Desk) | 9
[NAME] | Director | Logistics (East Desk) | 10
[NAME] | Manager | Logistics (East Desk) | 11
[NAME] |  | Logistics (East Desk) | 12
[NAME] | Sr. Spec | Logistics (East Desk) | 13
Meredith Homco | Sr. Spec | Logistics (East Desk) | 14
[NAME] | Manager | Logistics (East Desk) | 15
[NAME] | Sr. Spec | Logistics (East Desk) | 16
[NAME] |  | Logistics (East Desk) | 17
[NAME] |  | Logistics (East Desk) | 18
[NAME] |  | Logistics (East Desk) | 19
[NAME] | Manager | Logistics (Texas Desk) | 20
[NAME] | Analyst | Logistics (Texas Desk) | 21
[NAME] | Associate | Logistics (West Desk) | 22
[NAME] | Manager | Logistics (West Desk) | 23
Shannon  Groenewold | Spec | Logistics (West Desk) | 24
[NAME] | Spec | Logistics (West Desk) | 25
[NAME] | Spec | Logistics (West Desk) | 26
[NAME] | Sr. Spec | Logistics (West Desk) | 27
[NAME] | Manager | Logistics (West Desk) | 28
[NAME] | Manager | Support | 29
[NAME] | Sr. Spec | Support | 30
[NAME] | Manager | Support | 31
[NAME] | Sr. Spec | Support | 32
Spreadsheet: 08f0ed63-3583-4c18-bcd7-086b620b4be6
Sheet: Description and Sources

 | Description | Source
obs | Observation
SchoolName | School Name | IPEDS
SalarySt | Starting Salary | PayScale
SalaryMid | Mid-career Salary | PayScale
SalaryInc | Salary Increment | PayScale
[NAME] | State Income | U.S. Census Bureau
MajorSt | Major Index, Starting Salary | PayScale and IPEDS
MajorMid | Major Index, Mid-career Salary | PayScale and IPEDS
MajorInc | Major Index, Salary Increment | PayScale and IPEDS
[NAME] | SAT and ACT 25 percentile | U.S. News and World Report
SAT75 | SAT and ACT 75 percentile | U.S. News and World Report
[NAME] | SAT and ACT average of 25 and 75 percentitles | Calculation
SATACT | UC Scale of SAT ACT | Calculation
TOP10 | High school standing in top 10 % | U.S. News and World Report
Accept | Acceptance rate | U.S. News and World Report
ClassSize1 | Class size, 1-19 students | U.S. News and World Report
ClassSize2 | Class size, 50+ students | U.S. News and World Report
[NAME] | Total Enrollment | U.S. News and World Report
FacSalary | [NAME] | IPEDS
StuFacRatio | Student-Teacher ratio | IPEDS
FullFaculty | Percent full-time faculty | U.S. News and World Report
ExpPerFTE | Expenditure per full-time-equivalent student | IPEDS
GradRate | Graduation Rate | U.S. News and World Report
Retention | [NAME] | U.S. News and World Report
Peer | Peer Assessment | U.S. News and World Report
Alumni | Alumni Giving Rate | U.S. News and World Report
PRIVATE | Private School Dummy | IPEDS
Stcode | State Code | IPEDS
INSSIZE1 | School size under 1,000 | IPEDS
INSSIZE2 | School size 1,000-4,999 | IPEDS
INSSIZE3 | School size 5,000 - 9,999 | IPEDS
INSSIZE4 | School size 10,000-19,999 | IPEDS
INSSIZE5 | School size 20,000 and above | IPEDS
INSERPRO2 | Exclusively undergraduate four-year | IPEDS
INSERPRO3 | Very high undergraduate  <10% graduate students | IPEDS
INSERPRO4 | High undergraduate   10%-24% graduate students | IPEDS
INSERPRO5 | Majority undergraduate  25%-49% graduate students | IPEDS
INSERPRO6 | Majority graduate/professional  50%+ graduate | IPEDS
INSCARNE15 | Research Universities (very high research activity) | IPEDS
INSCARNE16 | Research Universities (high research activity) | IPEDS
INSCARNE17 | Doctoral/Research Universities | IPEDS
INSCARNE18 | Master's Colleges and Universities (larger programs) | IPEDS
INSCARNE19 | Master's Colleges and Universities (medium programs) | IPEDS
INSCARNE20 | Master's Colleges and Universities (smaller programs) | IPEDS
INSCARNE21 | Baccalaureate Colleges--Arts & Sciences | IPEDS
INSCARNE22 | Baccalaureate Colleges--Diverse Fields | IPEDS
Spreadsheet: 232204d1367351712-rearranging-data-within-a-cell-sample
Sheet: Sheet1

TAKE THE INFORMATION BELOW
322812 | 8840691 | AccentBlack/Black, Yellow/Black, Royal Blue/Black, White/Royal, Black/Red, Navy/Gray, Red/Gray, Pink/White
319672 | 8836769 | [NAME], Acid Blue, Acid Green, [NAME]
322643 | 8840516 | Adriatic Blue, Black
322644 | 8840517 | Adriatic Blue, Black
322646 | 8840519 | Adriatic Blue, Black, Black Cherry, [NAME]
AND CHANGE IT TO THIS FORMAT
322812 | 8840691 | AccentBlack/Black
 |  | Yellow/Black
 |  | Royal Blue/Black
 |  | White/Royal
 |  | Black/Red
 |  | Navy/Gray
 |  | Red/Gray
 |  | Pink/White
319672 | 8836769 | Acid Black
 |  | Acid Blue
 |  | Acid Green
 |  | [NAME]
322643 | 8840516 | Adriatic Blue
 |  | Black
322644 | 8840517 | Adriatic Blue
 |  | Black
322646 | 8840519 | Adriatic Blue
 |  | Black
 |  | Black Cherry
 |  | [NAME]
Spreadsheet: 297793d1392589281-time-series-forecast-based-on-market-share-market-penetration-time-series-forecast
Sheet: Filter1

year | Quarter | Car
 |  | car3
year | Quarter | Car | units_sold_(Sport) | units_sold_(4x4) | units_sold_(City) | sales_units ('000) | market share (Sport) | market_share_(4x4) | market_share_(City)
2010Q1 | Q1 | car3 | 246.23 | 137.4 | 49.86 | 530 | 0.1690350660405854 | 0.3590748725989809 | 0.1574808123558953
2010Q2 | Q2 | car3 | 212.96 | 103.74 | 45.45 | 520 | 0.1706971040165439 | 0.2981291490645746 | 0.1602270323626878
2010Q3 | Q3 | car3 | 223.29 | 124.64 | 40.28 | 513 | 0.1576706350887599 | 0.3200410835794069 | 0.1317933448941531
2010Q4 | Q4 | car3 | 196.35 | 95.1 | 48.17 | 548 | 0.1428218127859528 | 0.2601488127803918 | 0.1639271737280926
2011Q1 | Q1 | car3 | 213.34 | 107.8 | 45.73 | 532 | 0.1468373597632322 | 0.2720573389864728 | 0.1431119734618514
2011Q2 | Q2 | car3 | 194.03 | 131.32 | 69.95 | 546 | 0.1396059978126979 | 0.2179331861858373 | 0.145550261137352
2011Q3 | Q3 | car3 | 183.39 | 142.11 | 78.18 | 863 | 0.1313371480953643 | 0.2309304819786148 | 0.1595542766178902
2011Q4 | Q4 | car3 | 202.07 | 136.87 | 64.34 | 350 | 0.139070887818307 | 0.2247454844006568 | 0.1314912836443154
2012Q1 | Q1 | car3 | 177.45 | 142.98 | 71.42 | 1621 | 0.1241273660795478 | 0.2338834999100322 | 0.1428857234314981
2012Q2 | Q2 | car3 | 182.91 | 136.58 | 77.02 | 595 | 0.1291427199683692 | 0.2120906253396898 | 0.1565097234358172
2012Q3 | Q3 | car3 | 180.49 | 139.53 | 86.9 | 969 | 0.1281561532562697 | 0.217631369613027 | 0.1644649683939589
2012Q4 | Q4 | car3 | 180.81 | 121.72 | 90.44 | 352 | 0.1243552180910329 | 0.1870026117683208 | 0.1685835181836822
2013Q1 | Q1 | car3 | 200.34 | 122.66 | 71.56 | 1551 | 0.1322123157943364 | 0.1905013356526061 | 0.1392868265337901
2013Q2 | Q2 | car3 | 175.96 | 140.88 | 72.48 | 659 | 0.1211378531695765 | 0.2144945188794153 | 0.1407078099823339
2013Q3 | Q3 | car3 | 189.76 | 138.85 | 71.32 | 1011 | 0.1295528868801759 | 0.2170854114225856 | 0.1376222912606372
2013Q4 | Q4 | car3 | 171.23 | 136.36 | 64.42 | 364 | 0.1180831402405385 | 0.2107899211624671 | 0.1267486473192327
Spreadsheet: 866570d1713479853-do-not-know-how-to-perform-this-task-or-amento
Sheet: Calculos 

Cálculos UPAC
Dados Instalação
Entrada |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PdC QE Cliente |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | Potência Inversor |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W
Inversor
Marca |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Saída AC
Huawei |  |  |  | SUN2000-5KTL-M1
Parâmetros Rede |  |  |  |  |  |  |  | Parâmetros  Inversor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cálculo Ib Monofásico - Ib = P/Us x cos φ   Trifásico - Ib = P/√3 x UC x cos φ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rede Mono - Ib = P/Us x cos φ Trifásico Ib = P/Us x cos φ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inversor
Umin |  |  | Umax |  |  |  |  | Umin |  |  |  |  |  |  | UC |  |  |  |  | Umax |  |  |  | UC |  |  |  |  |  |  | Umin |  |  |  |  |  |  | Umax |  |  |  |  |  |  |  |  |  | Umin |  |  |  |  |  |  |  | Umax
 | V |  |  |  |  | V |  |  |  |  |  |  | V |  |  |  |  | V |  |  |  | V |  |  |  |  |  |  | V |  | Ib |  |  |  |  | A |  | Ib |  |  |  |  |  |  |  | A |  | IB |  |  |  |  |  | A |  | IB |  |  |  | A
Calcular In ( Calibre da Protecção)    In >= Ibmax    Ibmax Entre (Umin /Ib ) e  (Umax /Ib ) do Inversor
Ibmax entre Umin/Ib e Umax/Ib Inversor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | Usando o Quadro Calibres Disjuntores |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In |  |  |  | A
[NAME]       Ib  ≤  In [NAME] , I2 = 1.45 In e I2 ≤ 1.45 Iz
1º Condição        Ib  ≤  In [NAME]
Ib |  |  |  |  | In |  |  |  |  |  |  |  |  |  |  | Métodos |  |  |  |  |  |  |  |  |  |  | Iz |  |  | PVC |  |  |  | XLPE |  |  |  |  | Secção Cabo (mm²) |  |  |  |  |  |  |  | PVC |  |  | XLPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2º [NAME]In [NAME]