tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Jan

january expenses
total
advertising
date | po# | suppplier.description | amount
 |  |  | 1
subtotal
x
educational
date | po# | suppplier.description | amount
 |  |  | 2
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
 |  |  | 3
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
 |  |  | 4
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
 |  |  | 5
subtotal
supplies. machinery
date | po# | suppplier.description | amount
 |  |  | 6
subtotal
supplies. office
date | po# | suppplier.description | amount
 |  |  | 7
subtotal
etsy maintenance
date | po# | suppplier.description | amount
 |  |  | 8
subtotal
website maintenance
date | po# | suppplier.description | amount
 |  |  | 9
subtotal
shipping
date | po# | suppplier.description | amount
 |  |  | 10
subtotal
utilities
date | po# | suppplier.description | amount
 |  |  | 11
subtotal
Spreadsheet: 850214d1700583521-interval-staffing-formula-not-working-correctly-when-shifts-cross-midnight-interval-template-jadams169-working-version-
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In time | Out Time | Cross Midnight? |  |  | Over Midnight | Within Day | Combined Formula
 |  |  |  | Paste Here-> |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 07:00:00 | 2023-12-31 19:00:00 | 12 | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 21:00:00 | 2024-01-01 09:00:00 | 12 | 2023-12-31 21:00:00 | 2024-01-01 09:00:00 | 12 |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 07:00:00 | 2023-12-31 19:00:00 | 12 | 2023-12-31 07:00:00 | 2023-12-31 19:00:00 | 12 |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
Spreadsheet: 37941d1236050587-pulling-out-1-2-char-strings-into-other-columns-nba-things-1-
Sheet: Fluffy Floaties

 | Player, Team, Pos | Pos 1 | Pos 2 | Pos 3 | MIN | FGM | FGA | FG% | FTM | FTA | FT% | 3PM | REB | AST | STL | BLK | TO | PTS |  | Team Setup
1 | Jarrett [NAME], Ind PG | PG |  |  | 31.5 | 4.1 | 9.4 | 0.442 | 2.6 | 3.1 | 0.832 | 0.9 | 3.3 | 3.8 | 1 | 0.2 | 2.3 | 11.8 |  | PG: | 5
2 | [NAME], NY SG | SG |  |  | 25.6 | 4.1 | 10.2 | 0.405 | 2.1 | 2.5 | 0.826 | 1.3 | 3 | 1.9 | 1.2 | 0.3 | 1.2 | 11.6 |  | SG: | 4
3 | [NAME], Cha SF, PF | SF | PF |  | 37.2 | 5.3 | 11.5 | 0.458 | 5.3 | 6.5 | 0.808 | 0.5 | 7.4 | 2.6 | 1.7 | 0.8 | 2.2 | 16.3 |  | SF: | 6
4 | [NAME], Min PF | PF |  |  | 24.2 | 3.4 | 7.3 | 0.464 | 3 | 3.8 | 0.785 | 0 | 8.8 | 1.1 | 0.4 | 0.6 | 1.4 | 9.8 |  | PF: | 5
5 | [NAME], [NAME] | C |  |  | 30.1 | 4.1 | 7.9 | 0.523 | 2.8 | 4 | 0.704 | 0 | 7.3 | 1.6 | 0.8 | 1 | 1.9 | 11 |  | C | 4
6 | [NAME], Cha PG | PG |  |  | 27.6 | 3.8 | 9.1 | 0.413 | 2.9 | 3.2 | 0.906 | 1.5 | 1.9 | 3.8 | 0.6 | 0 | 1.8 | 12 |  | G: | 9
7 | Peja [NAME], Nor SF | SF |  |  | 34.3 | 5 | 12.3 | 0.408 | 1.5 | 1.7 | 0.908 | 2.5 | 4.4 | 1.3 | 0.8 | 0.1 | 0.9 | 14 |  | F: | 11
8 | [NAME], NY PG | PG |  |  | 38.5 | 3.9 | 9.3 | 0.42 | 2.6 | 3 | 0.86 | 1.7 | 3.6 | 7.9 | 1 | 0.1 | 2.9 | 12.1
9 | [NAME], Phi SG, SF | SG | SF |  | 38.9 | 6.3 | 13.5 | 0.468 | 4.3 | 5.9 | 0.731 | 0.8 | 6 | 5.4 | 1.7 | 0.4 | 2.8 | 17.8
10 | [NAME], Cha PG | PG |  |  | 38 | 5.2 | 13 | 0.402 | 2.5 | 3.1 | 0.805 | 0.8 | 3.9 | 6.7 | 1.7 | 0.4 | 2.8 | 13.7
11 | [NAME], Ind SF | SF |  |  | 36.2 | 8.1 | 18.7 | 0.434 | 6.1 | 6.9 | 0.888 | 2.7 | 5 | 3.1 | 0.9 | 1.5 | 2.5 | 25
12 | [NAME], SA SG | SG |  |  | 27.2 | 5.3 | 11.4 | 0.46 | 4.1 | 4.6 | 0.88 | 1.6 | 4.7 | 3.5 | 1.5 | 0.4 | 2.2 | 16.1
13 | [NAME], Tor SF, PF, C | SF | PF | C | 30.9 | 5.1 | 11.6 | 0.434 | 2.8 | 3.4 | 0.825 | 1.4 | 5.4 | 1.1 | 0.4 | 1.1 | 1.6 | 14.4
14 | [NAME], Cle PF, C | PF | C |  | 27.4 | 3.1 | 6 | 0.52 | 2 | 3.1 | 0.629 | 0 | 6.9 | 1 | 0.8 | 0.8 | 1 | 8.2
15 | Ronny Turiaf, GS PF, C | PF | C |  | 20.3 | 2.1 | 4.2 | 0.5 | 1.3 | 1.6 | 0.818 | 0 | 4.1 | 1.8 | 0.4 | 2.2 | 0.8 | 5.5
16 | [NAME], Por PG | PG |  |  | 30.2 | 3.9 | 9.2 | 0.425 | 1 | 1.2 | 0.833 | 2 | 2.3 | 5 | 1 | 0 | 1.5 | 10.8
17 | [NAME], [NAME], SF | SG | SF |  | 31.1 | 5.9 | 12.7 | 0.461 | 1.7 | 2.3 | 0.726 | 0.3 | 4.6 | 2.1 | 1.1 | 0.5 | 1.7 | 13.7
 | Totals: |  |  |  | 529.1999999999999 | 78.7 | 177.3 | 0.4438804286520024 | 48.6 | 59.9 | 0.8113522537562605 | 18 | 82.6 | 53.7 | 17 | 10.4 | 31.5 | 223.8
Spreadsheet: 54257d1254269755-need-some-help-with-ranges-exampleprogram
Sheet: Inventory

Item # | Cost | Sell
Item-1 | 12.94 | 16.4338
Item-2 | 8.47 | 10.7569
Item-3 | 16.91 | 21.4757
Item-4 | 27.85 | 35.3695
Item-5 | 6.33 | 8.0391
Item-6 | 19.41 | 24.6507
Spreadsheet: 05735eb4-9da4-443c-9c03-f47d5bdf25f9
Sheet: Sheet1

HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | Unnamed: 11
PLACEMENT | White | Blue | Red | White | Blue | Red | White | Blue | Red
DISTANCE | 414 | 369 | 253 | 321 | 270 | 240 | 324 | 325 | 288 | 2804
PAR | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 27
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
 | White | Blue | Red | White | Blue | Red | White | Blue | Red
 | 274 | 270 | 180 | 390 | 440 | 160 | 366 | 435 | 300 | 2815 | 5619
 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 27 | 54
Spreadsheet: 745436d1629924032-forrmula-only-to-visible-cell-avegrage
Sheet: Sheet1

 |  | Average | =AVERAGEIFS(IF(SUBTOTAL(9,OFFSET($D8:$D14,$A8:$A14,"Promotion"))))
 | Type | Name | % |  | Helper column for "Promotion" with IF
 | Promotion | A | 0.15 |  |  | IF Column B has "Promotion" show me the percentage
 | Promotion | B | 0.1 |  |  | IF Column B has anything else return blank ""
 | Promotion | D | 0.05
 | Promotion | E | 0.2
 | Promotion | F | 0.25
 | Correction | G | 0.1
 | Correction | H | 0.15
 |  |  |  |  |  | Average of the helper column
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: Mojave

56696
Day | Scheduled | Measured
1 |  | 71514
2 |  | 74070
3 | 65632 | 66238
4 | 48170 | 48619
5 |  | 46708
6 |  | 53054
7 |  | 40954
8 |  | 32413
9 | 24867 | 26010
10 |  | 25525
11 |  | 24667
12 |  | 38096
13 |  | 18761
14 | 22897 | 23514
15 | 24866 | 24876
16 | 33771 | 32400
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 84016
2000-12-16 00:00:00
Spreadsheet: 117393d1312768995-linking-cells-draft
Sheet: DEF

 | Rank | Teeam | Bye | Projected | Available
 | 1 | Pittsburgh Defense | 11 | 133.3 | YES
 | 2 | Green Bay Defense | 8 | 129.6 | YES
 | 3 | Philadelphia Defense | 7 | 126.3 | YES
 | 4 | Ny Jets Defense | 8 | 122 | YES
 | 5 | Ny Giants Defense | 7 | 121 | YES
 | 6 | Chicago Defense | 8 | 120.1 | YES
 | 7 | New England Defense | 7 | 118.8 | YES
 | 8 | Miami Defense | 5 | 114 | YES
 | 9 | San Diego Defense | 6 | 114 | YES
 | 10 | Baltimore Defense | 5 | 113 | YES
 | 11 | Dallas Defense | 5 | 110 | YES
 | 12 | Washington Defense | 5 | 107 | YES
 | 13 | Detroit Defense | 9 | 106.4 | YES
 | 14 | Carolina Defense | 9 | 106.3 | YES
 | 15 | [NAME] | 7 | 106 | YES
 | 16 | Atlanta Defense | 8 | 104 | YES
 | 17 | Houston Defense | 11 | 103 | YES
 | 18 | Arizona Defense | 6 | 102.2 | YES
 | 19 | Oakland Defense | 8 | 99.8 | YES
 | 20 | New Orleans Defense | 11 | 98.5 | YES
 | 21 | Minnesota Defense | 9 | 97.8 | YES
 | 22 | Tampa Bay Defense | 8 | 97.6 | YES
 | 23 | Kansas City Defense | 6 | 96.1 | YES
 | 24 | St. Louis Defense | 5 | 96 | YES
 | 25 | Tennessee Defense | 6 | 92 | YES
 | 26 | Seattle Defense | 6 | 90.8 | YES
 | 27 | Buffalo Defense | 7 | 89.8 | YES
 | 28 | Cincinnati Defense | 7 | 88.5 | YES
 | 29 | Cleveland Defense | 5 | 85.7 | YES
 | 30 | Indianapolis Defense | 11 | 85 | YES
 | 31 | Denver Defense | 6 | 81.3 | YES
 | 32 | [NAME] | 9 | 63.2 | YES
Spreadsheet: 77580d1278013538-figuring-golf-skins-and-highlighting-that-cell-rack-score-card-gross-net
Sheet: Sheet5

score | skins |  | score | skin |  | score | skin |  | score | skin
2
1 |  |  | 4 |  |  | 4 |  |  | 7
3 |  |  | 2 |  |  | 4 |  |  | 6
3 |  |  | 2 |  |  | 6 |  |  | 5
4 |  |  | 4 |  |  | 4 |  |  | 4
4 |  |  | 3 |  |  | 4 |  |  | 3
5 |  |  | 4 |  |  | 4 |  |  | 3
5 |  |  | 5 |  |  | 5 |  |  | 4
6 |  |  | 6 |  |  | 6 |  |  | 4
6 |  |  | 7 |  |  | 7 |  |  | 2
in columns A I just want to highlight the single lowest value in cells A3-5-7-9-and 11, which in this case would be A3
Cells A2-4-6-8-and 10 are gross scores and not to be factored in on the net score
in my example the odd cells of column A are the net scores and the even ones are gross scores (see sheet 4 for example)
the other three examples show where I have gotten close but not quite there.
I figurred out how to highlight low values but I only want to highlight the lowest unique value, if there isn't one, I don’t want anything highlighted
I seem to have trouble when I have specific cells in a column and not the whole column and I have trouble not highlighting something that is low but duplicated.
Spreadsheet: 1290d745-6b3b-4a6d-af81-c51aa2c3aa64
Sheet: Sheet1

Sheet name | Cluster in Figure 1 (top to bottom) | Number of genes
list 1 | 1 | 48
list 2 | 2 | 32
list 3 | 3 | 242
list 4 | 4 | 177
list 5 | 5 | 121
list 6 | 6 | 82
list 7 | 7 | 182
list 8 | 8 | 135
Illumina_Target | Also known as Search key or as [NAME] identifier used by [NAME] during probe design. Same as Illumina_ProbeId, but with the addition of the "-S" suffix code or "-I  or "-A". This complex string with the "|" parsing character encodes many attributes of the probe design and its target and is often used by Illumina and other users as the "name" of the probe.
Gene_Symbol | [NAME] gene symbol usually given by Mouse Genome Informatics (MGI, JAX)
Gene_Description | [NAME] gene description data with some modifications by [NAME]
Gene_ID | NCBI ID of the gene targeted by the probe
Spreadsheet: 67345d1267978508-category-calculations-sample
Sheet: Monthly Tracking

Tracking Budget
Income
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual Total
Total Income
Salary | 6381.99 | 1590.33
Other | 2077.67 | - | 41.2 | - | - | - | - | - | - | - | - | -
Outgoings
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual Total
Total Outgoings
Car
Insurance | 629.91 | - | - | - | - | - | - | - | - | - | - | -
Tax | 175 | - | - | - | - | - | - | - | - | - | - | -
Fuel | 271.75 | 202.86
Maintenance/Service | - | -
Home
Mortgage/Rent | - | -
Electric | - | -
Gas | - | -
Water | - | -
Internet | - | -
Phone | 38.66 | 38.66
Groceries | - | -
Insurance (Home) | - | -
Entertainment
Food | 14.42 | 20.39
Going Out | 58
Gym Membership | 58 | 58 | 58
Misc. Spending
Loan | 208.33 | 208.34
Clothes
General Purchases | 7795.87
Travel | 19.5 | 19.5
Income Remaining
Spreadsheet: jonathan_mckay__16900__Area Managers
Sheet: Thorncliffe

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Thorncliffe Greenview Community Association |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 1355.8
 | February | 1208.1
 | March | 901.7
 | April | 663.1
 | May | 329.6
 | June | 219.6
 | July | 56.4
 | August | 48.6
 | September | 271.1
 | October | 525.8
 | November | 922.6
 | December | 1258.2
 | TOTAL:
Spreadsheet: eric_saibi__9892__Market briefs
Sheet: Sheet1

Market Brief | Tuesday, October 23
Stocks | Close | Change | % Change
DJIA | 9340.08 | -36.95000000000073 | -0.003940480088045013
DJ 15 Util. | 299.36 | -7.479999999999961 | -0.02437752574631718
NASDAQ | 1704.43 | -3.659999999999854 | -0.00214274423478848
S&P 500 | 1084 | -5.119999999999891 | -0.004701043043925271
Market Vols | Close | Change | % Change
AMEX (000) | 172406 | 39877 | 0.3008926348195489
NASDAQ (000) | 1818790 | 293573 | 0.19247949636019
NYSE (000) | 1314163 | 215705 | 0.1963707306059949
Commodities | Close | Change | % Change
Crude Oil (Nov) | 21.76 | 0 | 0
Heating Oil (Nov) | 0.621 | -0.006000000000000005 | -0.00956937799043063
Nat. Gas (Henry) | 2.66 | -0.08599999999999985 | -0.03131828113619806
Propane (Nov) | 39.5 | 0.25 | 0.006369426751592357
Palo Verde (Nov) | 28.5 | 0.5 | 0.01785714285714286
COB (Nov) | 30.25 | 0.75 | 0.02542372881355932
PJM (Nov) | 27.8 | 0.3000000000000007 | 0.01090909090909093
Dollar US $ | Close | Change | % Change
Australia $ | 1.968 | 0.004999999999999893 | 0.002547121752419711
Canada $ | 1.571 | -0.008000000000000007 | -0.005066497783407224
Germany Dmark | 2.196 | 0.003000000000000114 | 0.001367989056087603
Euro | 0.8906 | -0.001000000000000001 | -0.001121579183490355
Japan ¥en | 122.7 | 0.2000000000000028 | 0.001632653061224513
Mexico NP | 9.22 | -0.009999999999999787 | -0.001083423618634863
[NAME] | 0.702 | -0.000500000000000056 | -0.0007117437722420725
Foreign Indices | Close | Change | % Change
Arg MerVal | 247 | -5.72 | -0.02263374485596707
[NAME]. | 3149.3 | 32.5 | 0.0104273613963039
[NAME] | 11613.44 | -86.54999999999927 | -0.007397442220036024
Can TSE 300 | 6904.2 | -1 | -0.0001448183977292475
Germany DAX | 4716.05 | 121.01 | 0.02633491765033606
[NAME] | 10219.84 | 422.2999999999993 | 0.0431026563810915
Japan Nikkei 225 | 10861.56 | 296.15 | 0.02803014743393769
[NAME] | 5571.27 | 31.99000000000069 | 0.005775118788001454
UK FTSE 100 | 5193.3 | 122.9000000000005 | 0.0242387188387505
Source:  Yahoo! & TradingDay.com
Spreadsheet: 763980d1642518104-formula-to-determine-price-based-on-quantity-used-example-jt
Sheet: Sheet1

Parent Code | [NAME] | Item Code | Description | Size | Cost |  |  | Parent Code | [NAME] | Item Code | Description | Size | Cost
100 | B |  | Sugar, White - 1# | 10 |  |  |  | 100 | A | 100A | Sugar, White - 10# | 1 | 4.98
100 | C |  | Sugar, White - 1 cup | 20 |  |  |  | 101 | A | 101A | [NAME], [NAME] 50# | 1 | 53.67
100 | D |  | Sugar, White - 1 tbs | 362.5
100 | E |  | Sugar, White - 1tsp | 10875.5
101 | B |  | [NAME], [NAME] 1# | 50
101 | C |  | [NAME], [NAME] cup | 166.5
101 | D |  | [NAME], [NAME] tbs | 2903
101 | E |  | [NAME], [NAME] tsp | 8706
Spreadsheet: 778110d1650827748-work-shifts-with-monthly-update-works-2-
Sheet: mese

Anno | 2022 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  | 1 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 |  |  |  |  |  |  |  |  |  | ddd
 |  | 2 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  | 3 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4
 |  | 4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5
 |  | 5 |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2
Spreadsheet: 270924d1381757154-need-forumla-to-re-calculate-when-date-changes-for-close-month-2014-forecast-workbook
Sheet: Data

Forecast
 | SF Data |  |  |  | Forecast Data
Account Name | Probability (%) | Created Date | Close Month | Total | Value | Probability | weighted Value | Gross Margin% | Delivery time mth | Close Mth | Category | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00
Total |  |  |  |  |  |  |  |  |  |  | Bookings | 0 | 0 | 317950 | 93115 | 20700 | 72600 | 14300
 |  |  |  |  |  |  |  |  |  |  | Sales | 0 | 0 | 41995.72727272727 | 131612.393939394 | 153121.6666666667 | 140855 | 59121.66666666666
 |  |  |  |  |  |  |  |  |  |  | GM | 0 | 0 | 17817.86363636364 | 55964.5303030303 | 63548.66666666666 | 58642.00000000001 | 23648.66666666667
A1 | 100 | 2012-09-26 00:00:00 | 2013-12-01 00:00:00 | 100000 | 112153 | 1 | 112153 | 0.5 | 11 | 2013-10-01 00:00:00 | Bookings | 112153 | 0 | 0 | 0 | 0 | 0 | 0
IBM / Fingrid - further Labor Releases | 100 | 2012-09-26 00:00:00 | 2013-12-01 00:00:00 | 100000 |  |  | 112153 |  |  |  | Sales |  | 10195.72727272727 | 10195.72727272727 | 10195.72727272727
IBM / Fingrid - further Labor Releases | 100 | 2012-09-26 00:00:00 | 2013-12-01 00:00:00 | 100000 |  |  | 112153 |  |  |  | GM |  | 5097.863636363636 | 5097.863636363636 | 5097.863636363636
A2 | 1 | 2012-10-26 00:00:00 | 2014-09-01 00:00:00 | 120000 | 120000 | 0.01 | 1200 | 0.4 | 1 | 2014-09-01 00:00:00 | Bookings | 0 | 0 | 0 | 0 | 0 | 0 | 0
AEP Energy Services, Inc.-Tech Center |  |  |  |  |  |  |  |  |  |  | Sales
AEP Energy Services, Inc.-Tech Center |  |  |  |  |  |  |  |  |  |  | GM
A3 | 25 | 2010-07-12 00:00:00 | 2013-11-01 00:00:00 | 95000 | 95000 | 0.5 | 47500 | 0.4 | 3 | 2013-11-01 00:00:00 | Bookings | 0 | 47500 | 0 | 0 | 0 | 0 | 0
Alberta Electric System Operator (Calgary, AB) |  |  |  |  |  |  |  |  |  |  | Sales |  |  | 15833.33333333333 | 0 | 15833.33333333333
Alberta Electric System Operator (Calgary, AB) |  |  |  |  |  |  |  |  |  |  | GM |  |  | 6333.333333333334 | 0 | 6333.333333333334
A4 | 20 | 2011-04-07 00:00:00 | 2014-03-01 00:00:00 | 25000 | 25000 | 0.4 | 10000 | 0.4 | 3 | 2013-11-01 00:00:00 | Bookings | 0 | 10000 | 0 | 0 | 0 | 0 | 0
American Electric Power (AEP) - backup site Ohio-Columbus |  |  |  |  |  |  |  |  |  |  | Sales |  |  | 3333.333333333333 | 3333.333333333333 | 3333.333333333333
American Electric Power (AEP) - backup site Ohio-Columbus |  |  |  |  |  |  |  |  |  |  | GM |  |  | 1333.333333333333 | 1333.333333333333 | 1333.333333333333
Spreadsheet: 770191d1645887324-how-to-import-multiple-text-files-in-its-own-unique-column-how-to-import-multiple-text-files-in-its-own-unique-column-flyanryan-
Sheet: Try wth power query

Source.Name | Column1 |  | I get this when I use power query and I'm not sure how to separate into their distinct columns
File A.txt | 20
File A.txt | 16
File A.txt | 15
File A.txt | 18
File A.txt | 20
File A.txt | 11
File A.txt | 11
File A.txt | 3
File A.txt | 6
File A.txt | 15
File A.txt | 19
File A.txt | 15
File A.txt | 8
File A.txt | 18
File A.txt | 20
File A.txt | 4
File A.txt | 5
File A.txt | 0
File A.txt | 0
File A.txt | 10
File B.txt | 19
File B.txt | 21
File B.txt | 28
File B.txt | 5
File B.txt | 19
File B.txt | 22
File B.txt | 27
File B.txt | 6
File B.txt | 4
File B.txt | 20
File B.txt | 18
File B.txt | 26
File B.txt | 6
File B.txt | 16
File B.txt | 5
File B.txt | 6
File B.txt | 26
File B.txt | 10
File B.txt | 23
File B.txt | 30
File C.txt | 28
File C.txt | 25
File C.txt | 17
File C.txt | 29
File C.txt | 16
File C.txt | 30
File C.txt | 22
File C.txt | 4
File C.txt | 7
File C.txt | 21
File C.txt | 17
File C.txt | 8
File C.txt | 14
File C.txt | 29
File C.txt | 15
File C.txt | 9
File C.txt | 21
File C.txt | 4
File C.txt | 27
File C.txt | 6
Spreadsheet: b0465adf-44cf-4943-bd39-e540aef4d5b5
Sheet: Sheet1

Old Courses      New Courses
CIS 100 | Introduction to Computers | CIT 105
CIS 120 | Computational Thinking | CIT 120
CIS 130 | Productivity Software | CIT 130
CIS 147 | SQL I | CIT 171
CIS 148 | Visual Basic I | CIT 148
CIS 149 | [NAME] | CIT 149
CIS 155 | C ++ 1 | CIT 142
CIS 200 | CIT Capstone | CIT 291
CIS 220 | CIT Capstone | CIT 291
CIS 230 | Advanced Productivity Software | CIT 236 OR CIT 234
CIS 248 | Visual BASIC II: Desktop Applications | CIT 248
CIS 249 | [NAME] | CIT 249
CIS 250 | 2-D Game Development: Language | CIT 246
CIS 252 | C ++ II | CIT 242
CIS 258 | Visual Basic III | CIT 278
CIS 260/265 | 3-D Game Development: Language | CIT276
CIS 280 | Internship | CIT 290
CIS 291 | CIT Capstone | CIT 290
IT 105&IT205 | Computer Hardware and Software | CIT 111
IT 120 | Network Fundamentals | CIT 161
IT 121 | Home and Small Office Networks | CIT 162
IT 122 | Routing Protocols and Concepts | CIT 210
IT 123 | Small-Medium Business or ISP | CIT 163
IT 130 | Web Site Design and Production | CIT 157
IT 132 | Web Page Development | CIT 155
IT 141 | PHP I | CIT 141
IT 147 | SQL I | CIT 171
IT 160 | Introduction to GIS | CIT 125
IT 170 | Database Design Fundamentals | CIT 170
IT 205&IT105 | Computer Hardware and Software | CIT111
IT 220 | LAN Switching and Wireless | CIT 211
IT 222 | Accessing the WAN | CIT 212
IT 223 | Introduction to Routing and Switching | CIT 164
IT 225 | Network Design and Support | CIT 165
IT 235 | Data-Driven Web Pages: Topic | CIT 253
IT 237 | Hwlp Desk Operations | CIT 232
IT 241 | PHP II | CIT 241
IT 250 | Security Fundamentals | CIT 180
IT 252 | Attacks and Exploits | CIT 184
IT 254 | Preimeter Defense | CIT 182
IT 255 | Computer Forensics | CIT 284
IT 258 | MS Windows OS Security | CIT 285
IT 260 | GIS Software Tools | CIT 225
IT 268 | Selected Topics in GIS | CIT 229
IT 291 | Applied Internet Technologies/CIT Capstone | CIT 257/CIT 291
IT 295 | Applied Internet Technologies/CIT Capstone | CIT 257/CIT 291
NIS 150 | PERL I | CIT 145
NIS 152 | JavaScript I | CIT 140
NIS 160 | Introduction to Networking Concepts | CIT 160
NIS 211&213 | MS Client/Server Config | CIT 213
NIS 213&211 | MS Client/Server Config | CIT 213
NIS 214 | Infrastructure Admin | CIT 214
NIS 216 | MS Active Directory Services | CIT 261
NIS 230 | Unix/Linux Administration | CIT 217
NIS 242 | Microsfot Server Administration/MS Enterprise [NAME] | CIT 264 OR CIT 266
NIS 244 | Microsfot Server Administration/MS Enterprise [NAME] | CIT 264 OR CIT 266
NIS 245 | Microsfot Server Administration/MS Enterprise [NAME] | CIT 264 OR CIT 266
NIS 270 | Network Installation and Troubleshooting | CIT 260
NIS 275 | Web Server Administration | CIT 255