tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62365d1263321482-distribution-of-data-from-different-dates-dummy-data
Sheet: Chart

Publish Date | (All)
Article Title | (All)
Producer | (All)
Tag | (All)
Values
Sum of Mar-08 | Sum of Apr-08 | Sum of May-08 | Sum of Jun-08 | Sum of Jul-08 | Sum of Aug-08 | Sum of Sep-08 | Sum of Oct-08 | Sum of Nov-08 | Sum of Dec-08 | Sum of Jan-09 | Sum of Feb-09 | Sum of Mar-09 | Sum of Apr-09 | Sum of May-09 | Sum of Jun-09 | Sum of Jul-09 | Sum of Aug-09 | Sum of Sep-09 | Sum of Oct-09 | Sum of Nov-09 | Sum of Dec-09
2301 | 2383 | 2891 | 3354 | 3661 | 2926 | 2996 | 3368 | 3212 | 2680 | 3058 | 3083 | 2983 | 2189 | 1980 | 1738 | 1317 | 1349 | 1495 | 1261 | 1542 | 1448
Spreadsheet: 273720d1382882537-need-to-fix-complex-if-formula-and-num-error-price-column
Sheet: OBJEKT

 |  |  |  |  |  |  |  |  |  |  | PRICE                          (less than 1st)      (greater than 1st)                             (same) | P        O           I          N         T          S | Has content          (4 - ours)         (5 - theirs) | P       O        I        N        T        S | Has content     (10 - 0,5)     (11 - 0) | P       O         I         N           T         S | TOTAL POINTS
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | Criteria of evaluation (how table gives points for price values):
 |  |  |  |  |  | Criteria |  | Description |  |  |  |  |  |  | Points
 |  |  |  |  |  | PRICE |  | Lowest price which is  lower by 1 or more from the next lowest price. |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Lowest price which is  lower by less than 1 from the next lowest price. |  |  |  |  |  |  | 1
Spreadsheet: 868960d1715670005-from-dropdown-list-match-across-multiple-sheets-dropdown-match-across-multiple-sheets
Sheet: ShivMilk Dairy

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 to 10 |  |  | 11 to 20 |  |  | 21 to EOM
Helper | Date | Item | Qty | Rate | Amt | Daily Amt | 10 days Amt |  | Month | 1 to 10 | 11 to 20 | 21 to EOM | Total |  | Total Paid | Cheque | Online | Cash | Cheque | Online | Cash | Cheque | Online | Cash
 | 2024-04-01 00:00:00 | Curd | 3 | 68 |  |  |  |  | 2024-01-01 00:00:00
 | 2024-04-02 00:00:00 | Paneer | 3 | 300 |  |  |  |  | 2024-02-01 00:00:00
 |  | Curd | 3 | 68 |  |  |  |  | 2024-03-01 00:00:00
 |  | [NAME] | 1 | 300 |  |  |  |  | 2024-04-01 00:00:00 |  |  |  |  |  |  | 9445 |  |  | 10120 |  |  |  | 10765
 | 2024-04-03 00:00:00 | Paneer | 3 | 300 |  |  |  |  | 2024-05-01 00:00:00
 |  | [NAME] | 1 | 170 |  |  |  |  | 2024-06-01 00:00:00
 | 2024-04-04 00:00:00 | Paneer | 3 | 300 |  |  |  |  | 2024-07-01 00:00:00
 |  | Curd | 5 | 68 |  |  |  |  | 2024-08-01 00:00:00
 |  | [NAME] | 1 | 300 |  |  |  |  | 2024-09-01 00:00:00
 | 2024-04-06 00:00:00 | Curd | 5 | 68 |  |  |  |  | 2024-10-01 00:00:00
 |  | GreenPeas | 5 | 100 |  |  |  |  | 2024-11-01 00:00:00
 | 2024-04-07 00:00:00 | Paneer | 3 | 300 |  |  |  |  | 2024-12-01 00:00:00
 | 2024-04-08 00:00:00 | Paneer | 5 | 300 |  |  |  |  | Year Total
 |  | Curd | 6 | 68
 | 2024-04-09 00:00:00 | Paneer | 2 | 300
 |  | Curd | 3 | 68
 | 2024-04-10 00:00:00 | Curd | 8 | 68
 | 2024-04-11 00:00:00 | Paneer | 3 | 300
 |  | Ghee | 2 | 600
 |  | [NAME] | 1 | 300
 | 2024-04-12 00:00:00 | Amrkhand | 1 | 170
 |  | Paneer | 4 | 300
 | 2024-04-13 00:00:00 | Paneer | 2 | 300
 |  | Curd | 3 | 68
 |  | [NAME] | 1 | 300
 | 2024-04-14 00:00:00 | Paneer | 2 | 300
 | 2024-04-15 00:00:00 | Paneer | 2 | 300
 | 2024-04-16 00:00:00 | Curd | 3 | 68
 | 2024-04-17 00:00:00 | Paneer | 5 | 300
 |  | Curd | 3 | 68
 |  | [NAME] | 1 | 300
 | 2024-04-18 00:00:00 | Curd | 3 | 68
 |  | GreenPeas | 5 | 100
 | 2024-04-19 00:00:00 | Curd | 4 | 68
 | 2024-04-20 00:00:00 | Paneer | 2 | 300
 |  | Curd | 2 | 68
 | 2024-04-21 00:00:00 | Paneer | 2 | 270
 |  | Curd | 4 | 68
 |  | [NAME] | 0.5 | 300
 | 2024-04-22 00:00:00 | Paneer | 2 | 270
 |  | Curd | 3 | 68
 | 2024-04-23 00:00:00 | Paneer | 1 | 270
 |  | Curd | 7 | 68
 | 2024-04-24 00:00:00 | Paneer | 2 | 270
 |  | Curd | 2 | 68
 |  | [NAME] | 0.5 | 300
 | 2024-04-25 00:00:00 | Paneer | 1 | 270
 |  | Curd | 4 | 68
 |  | [NAME] | 1 | 300
 | 2024-04-27 00:00:00 | GreenPeas | 15 | 100
 | 2024-04-28 00:00:00 | Amrkhand | 32 | 160
 | 2024-05-01 00:00:00 | Amrkhand | 8 | 160
 |  | Curd | 5 | 68
 |  | GreenPeas | 12 | 110
 | 2024-05-02 00:00:00 | Curd | 4 | 68
 |  | [NAME] | 0.5 | 300
 | 2024-05-03 00:00:00 | [NAME] | 1 | 300
 | 2024-05-06 00:00:00 | Curd | 4 | 68
 |  | [NAME] | 1 | 300
 | 2024-05-07 00:00:00 | Curd | 5 | 68
 | 2024-05-08 00:00:00 | Curd | 4 | 68
 |  | [NAME] | 1 | 300
 | 2024-05-09 00:00:00 | Curd | 5 | 68
 | 2024-05-10 00:00:00 | Curd | 5 | 68
 | 2024-05-11 00:00:00 | Curd | 3 | 68
 | 2024-05-12 00:00:00
Spreadsheet: 220537d1363188252-combine-two-reports-accordingly-reports_example
Sheet: Main_Report

School Name | Student Username | First Name | Last Name | Course Name | Course Code | Section Code
AAA | ABC123 | A | B | Algebra 2 Part 1 | EDHS.MA003.A | EDHS.MA003.A.1
Others | Others | Others | Others | Others | Others | Others
AAA | ABC123 | A | B | Algebra 2 Part 2 | EDHS.MA003.B | EDHS.MA003.B.1
Others | Others | Others | Others | Others | Others | Others
AAA | ABC123 | A | B | Algebra 2 Part 3 | EDHS.MA003.C | EDHS.MA003.C.1
AAA | XYZ456 | C | D | Forensics | EDHS.SC016.A | EDHS.SC016.A.1
AAA | DEF789 | Z | X | British Literature Part 1 | EDHS.LA004.A | EDHS.LA004.A.1
Others | Others | Others | Others | Others | Others | Others
AAA | DEF789 | Z | X | British Literature Part 2 | EDHS.LA004.B | EDHS.LA004.B.1
AAA | LMN555 | H | G | Health Part 1 | EDHS.EL005.A | EDHS.EL005.A.1
Others | Others | Others | Others | Others | Others | Others
AAA | RST999 | S | Q | Mechanical Engineering | EDHS.EL008.A | EDHS.EL008.A.1
Spreadsheet: 390722d1429737793-custom-function-00-00-no-longer-works-tides-apr-15
Sheet: Sheet1

2015-04-01 00:00:00 |  | OPEN | CLOSE | OPEN | CLOSE | HEIGHT
1 | WED | 825 | 1230 | 2045 |  | 15.7 | 15.7
2 | THU | 855 | 1315 | 2110 |  | 16.4 | 16.7
3 | FRI | 925 | 1355 | 2135 |  | 17.1 | 17.1
4 | SAT | 955 | 1425 | 2205 |  | 17.4 | 17.4
5 | SUN | 1025 | 1505 | 2235 |  | 17.7 | 17.7
6 | MON | 1055 | 1535 | 2310 |  | 17.7 | 17.7
7 | TUE | 1125 | 1605 | 2345 |  | 17.4 | 17.4
8 | WED |  |  | 1205 | 1635 | 17.1 | 17.1
9 | THU |  |  | 1245 | 1705 | 16.7 | 16.7
10 | FRI |  |  | 1335 | 1745 | 16.1 | 16.1
11 | SAT |  |  | 1435 | 1825 | 15.1 | 15.4
12 | SUN |  | 705 | 1555 | 1925 | 14.4 | 14.8
13 | MON |  | 825 | 1710 | 2050 | N | 14.4
14 | TUE |  | 955 | 1825 | 2225 | 15.1 | 14.8
15 | WED |  | 1115 | 1915 | 2335 | 16.1 | 16.1
16 | THU | 740 | 1225 | 2005 |  | 17.1 | 17.1
17 | FRI | 825 | 1315 | 2050 |  | 18 | 18
18 | SAT | 910 | 1405 | 2135 |  | 19 | 18.7
19 | SUN | 955 | 1455 | 2215 |  | 19.3 | 19
20 | MON | 1040 | 1535 | 2305 |  | 19.3 | 19
21 | TUE | 1125 | 1615 | 2345 |  | 18.7 | 18.4
22 | WED |  |  | 1205 | 1650 | 18 | 17.7
23 | THU |  |  | 1255 | 1725 | 17.1 | 16.7
24 | FRI |  |  | 1355 | 1800 | 15.7 | 15.7
25 | SAT |  |  | 1505 | 1835 | 14.8 | 14.8
26 | SUN |  | 710 | 1635 | 1855 | 13.8 | 14.1
27 | MON |  | 805 | 1805 | 2015 | N | 13.4
28 | TUE |  | 925 | 1905 | 2145 | 14.1 | 14.1
29 | WED |  | 1045 | 1940 | 2255 | 14.8 | 14.8
30 | THU | 745 | 1145 | 2010 | 2355 | 15.4 | 15.4
Spreadsheet: 718469d1613146937-lookup-month-in-col-a-and-if-col-h-on-same-sheet-x-display-x-otherwise-blank-staff-changes-by-month-example-1-
Sheet: Feb

Staff Transferred Out |  |  |  |  |  |  |  |  | Feb
Spreadsheet: 32932d1229094174-how-do-i-give-columns-a-value-and-calculate-the-total-of-the-highlighted-cells-se
Sheet: Sheet2

 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 18:00:00 | 20:30, Finish
Monday | Sé
 |  | [NAME]
 |  | Elenor
 |  |  | Carly
 |  | Kardina
 |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Petra
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rebecca
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damiet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Tuesday | Sé
 |  | Elenor
 |  | Petra
 | Roisin
 |  | Kardina
 |  |  |  | [NAME]
 |  |  |  | Madeline
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Ra…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rebecca
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Julien
Spreadsheet: 33248d1229547205-nested-if-functions-roman-3f
Sheet: Sheet4

 |  | width of blind |  | 1399
 |  | drop of blind |  | 1700 |  |  |  |  |  | [NAME] of headrail |  |  | 1389
 |  |  |  |  |  |  |  |  |  | drop of blind |  |  | 1700
 |  | Hardware allowance | Batten | 45 |  |  |  |  | Timber |  |  |  | 1389 | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 1369 | [NAME]
 |  | no. Of pockets |  | 7.5 |  |  |  |  | Acorn |  |  |  | 1
 |  |  |  |  |  |  |  |  | Cleat |  |  |  | 1
 |  |  |  |  |  |  |  |  | Cord connector |  |  |  | 1
 |  |  | 1 | 265.6666666666666 |  | [NAME] |  |  | China Barrels |  |  |  | 4
 |  |  | 2 | 486.3333333333333 |  |  |  |  | [NAME] |  |  |  | 4
 |  |  | 3 | 706.9999999999999 |  |  |  |  | Brackets |  |  |  | 3
 |  |  | 4 | 927.6666666666665 |  |  |  |  | Screws |  |  |  | 3
 |  |  | 5 | 1148.333333333333 |  |  |  |  | string |  |  |  | 0
 |  |  | 6 | 1369 |  |  |  |  | string |  |  |  | 0 | mtr
 |  |  | 7 | 1589.666666666667
 |  |  |  |  |  |  |  |  |  |  | spool/ barrel positions | 0 | 70
 |  |  | 1/2    pocket | 110.3333333333333 |  | [NAME] |  |  |  |  | in mm from end | 1 | 486.3333333333333
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 902.6666666666666
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 1319
 |  | Customer | HW |  |  |  |  |  | Customer | HW
 |  | Client | [NAME] |  |  |  |  |  | Client | [NAME]
 |  | Order No. | 12345 |  |  |  |  |  | Order No. | 12345
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  TRANSPORT
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 14138075 | 29111855
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 3853953 | 7878186
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 17992028 | 36990041
 | Purchases:
6 |  | 3rd Party / Inter Enron | -15378931 | -31433692
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2398202 | -4915768
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -17777133 | -36349460
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | -214895 | -517896.95
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -214895 | -517896.95
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -420951
31 |  | Prior Month Book Balance | 0 | 207749
 |  | Total MTM Income | 0 | -213202
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -646
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | -29526
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 25dd81cc-e94d-4d6a-bb81-66961ea06263
Sheet: T48

جدول 48: معدل التمو السنوي للسكان، 2000-2012
Table 48: Annual population growth rate, 2000-2012
Country | معدل نمو السكان |  |  |  |  |  |  |  |  |  |  |  |  | البلد
 | Population growth rate
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Bahrain | … | … | … | … | … | … | … | … | 6.18 | 6.79 | 4.25 | -2.73 | … | البحرين
Egypt | … | … | … | … | … | … | … | 2.02 | … | … | … | … | … | مصر
Iraq | … | … | … | … | … | … | … | 2.9 | 2.9 | 2.9 | ... | … | … | العراق
Jordan | 2.5 | 2.5 | 2.4 | 2.6 | 2.3 | 2.3 | 2.3 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | … | الأردن
Kuwait | 3.46 | 3.47 | 3.47 | 3.48 | 3.48 | 3.51 | 3.64 | 3.49 | 3.47 | 3.43 | 3.42 | 5.6 | … | الكويت
Lebanon | … | … | … | … | … | … | … | … | … | … | … | … | … | لبنان
Libya | … | … | … | … | … | … | … | … | … | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | 1.1 | 1.09 | 1.08 | 1.07 | 1.06 | 1.05 | 1.03 | 1.01 | [NAME]
Oman | ... | 3.182959251325144 | 2.423833196041315 | 7.8 | 3.193802158649859 | 3.860818289302429 | 2.719387509033069 | 6.458401078437376 | 4.51718772268552 | 10.6886380407808 | 2.3 | 17.2 | … | عمان
Palestine* | ... | ... | ... | ... | ... | ... | ... | 2.86 | 2.87 | 2.88 | 2.9 | 2.9 | 3 | فلسطين*
Qatar | ... | ... | ... | 0.06 | 0.12 | 0.14 | 0.15 | 0.17 | 0.19 | 0.13 | 0.046 | 0.01032504996686514 | … | قطر
Saudi Arabia | ... | ... | ... | ... | 2.38 | 2.36 | 2.32 | 2.28 | 2.23 | 2.18 | 2.13 | 2.08 | … | المملكة العربية السعودية
Sudan** | … | … | … | … | … | … | … | … | 2.827 | … | … | … | … | السودان**
Syrian Arab Republic | 2.5 | 2.5 | 2.4 | 2.4 | 2.1 | 1.9 | 2.4 | 2.4 | 2.4 | 2.4 | … | … | … | سوريا
Tunisia |  |  |  |  |  | 1.12 | 1.15 | 1.18 | 1.19 | 1.2 | 1.29 | 1.29 | … | تونس
United Arab Emirates | … | … | … | … | … | … | … | … | 2.23 | 2.18 | … | … | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | 3 | … | … | … | … | … | … | … | … | اليمن
* for nationals only |  |  |  |  |  |  |  |  |  |  |  |  |  | *فقط للمواطنين
** 1993-2008
Spreadsheet: 816157d1675405569-find-max-date-with-three-conditions-met-find-max-date
Sheet: Sheet1

Branch Code | Transaction Date | Type | Part Number |  | Part Number | Branch Code | Type | mxx date |  | Column1 | Column2 |  |  |  | 1111 | Ship Out
1111 | 2022-12-21 00:00:00 | Ship Out | 11111111 |  | 22222222 | 2222 | Ship Out | 2022-12-22 00:00:00 |  | 2222 | Ship Out |  |  |  | 2222 | Receive In
1111 | 2022-12-21 00:00:00 | Receive In | 11111111
1111 | 2022-12-21 00:00:00 | Ship Out | 11111111
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 | 2022-12-22 00:00:00 | Ship Out | 22222222
2222 | 2022-12-22 00:00:00 | Ship Out | 22222222
Spreadsheet: 681207d1591393259-merge-data-from-range-to-range-without-blank-cells-zz
Sheet: sheet1

 | NAME | CODE |  |  |  |  |  | NAME | CODE
 | ALI | 100 |  |  |  |  |  | ALI | 100
 | AHMED | 200 |  |  |  |  | RESULT | AHMED | 200
 |  |  |  |  |  |  |  | OMAR | 300
 | OMAR | 300 |  |  |  |  |  | KHALID | 400
 |  |  |  |  |  |  |  | MUSTAPHA | 500
 | KHALID | 400 |  |  |  |  |  | [NAME] | 20
 |  |  |  |  |  |  |  | TOM | 50
 |  |  |  |  |  |  |  | SARA | 10
 | MUSTAPHA | 500
 | NAME | CODE
 | [NAME] | 20
 | TOM | 50
 | SARA | 10
Spreadsheet: 885508d1735160956-springfield-school-board-assigning-students-to-schools-work
Sheet: Option 2

 | OBJECTIVE
 | Decision Variable
 | Area | School 1 |  |  | School 2 |  |  | School 3 |  |  | Total per area | Sign | [NAME] |  | Total per school
 |  | 6th | 7th | 8th | 6th | 7th | 8th | 6th | 7th | 8th |  |  |  |  | School 1 | School 2 | School 3 |  | all >= 1
 | 1 | 16 | 19 | 15 | 112 | 133 | 105 | 16 | 19 | 15 |  | "=" | 450 |  |  |  |  |  | School 1 | School 2 | School 3
 | 2 | 0 | 0 | 0 | 148 | 112 | 140 | 74 | 56 | 70 |  | "=" | 600
 | 3 | 15 | 16 | 19 | 60 | 64 | 76 | 90 | 96 | 114 |  | "=" | 550
 | 4 | 91 | 130 | 104 | 7 | 10 | 8 | 0 | 0 | 0 |  | "=" | 350
 | 5 | 156 | 136 | 108 | 0 | 0 | 0 | 39 | 34 | 27 |  | "=" | 500
 | 6 | 17 | 14 | 19 | 17 | 14 | 19 | 119 | 98 | 133 |  | "=" | 450
 | Sub Total
 | Upper cap |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 1100 | 1000
 | Lower cap
 | Area | School 1 |  |  | School 2 |  |  | School 3 |  |  | Percentage
 |  | 6th | 7th | 8th | 6th | 7th | 8th | 6th | 7th | 8th | 6th grade | 7th grade | 8th grade
 | 1 |  |  |  |  |  |  |  |  |  | 0.32 | 0.38 | 0.3
 | 2 | 0 | 0 | 0 |  |  |  |  |  |  | 0.37 | 0.28 | 0.35
 | 3 |  |  |  |  |  |  |  |  |  | 0.3 | 0.32 | 0.38
 | 4 |  |  |  |  |  |  | 0 | 0 | 0 | 0.28 | 0.4 | 0.32
 | 5 |  |  |  | 0 | 0 | 0 |  |  |  | 0.39 | 0.34 | 0.27
 | 6 |  |  |  |  |  |  |  |  |  | 0.34 | 0.28 | 0.38
 | BUSING COST
 | Area | School 1 | School 2 | School 3
 | 1 | 300 | 0 | 700
 | 2 | - | 400 | 500
 | 3 | 600 | 300 | 200
 | 4 | 200 | 500 | -
 | 5 | 0 | - | 400
 | 6 | 500 | 300 | 0
Spreadsheet: 145586d1331655892-monthly-income-over-term-rolling-income-for-excell-help-forum-v2
Sheet: Rolling Forecast

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51
File Id | Early Termination Date | [NAME] | Rent Obligation from - 02/01/12 - until Early Term Date | [NAME] | Sublease Start Date | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 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 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | Total
L1 | 2011-10-31 00:00:00 | 0 | 0 | 0
L2 | 2013-10-31 00:00:00 | 21 | 210000 | 190000 | 2012-04-01 00:00:00
S2 |  | 19
L3 | 2012-03-31 00:00:00 | 2 | 20000 | 0
[NAME] | 2012-07-15 00:00:00 | 5.5 | 55000 | 0
L5 | 2012-03-31 00:00:00 | 2 | 20000 | 0
L6 | 2013-07-30 00:00:00 | 18 | 180000 | 84648.16674999999 | 2013-01-01 00:00:00
S6 |  | 7 | 70000
Spreadsheet: 59133d1259599946-converting-numbers-with-dashes-example
Sheet: Sheet1

what I have: |  | Desired result:
4330-00-000-0145 |  | 4330000000145
6150-00-134-0848
6150-00-134-0847
6140-00-851-0457
2510-00-790-2296
2540-00-957-5068
3950-01-238-0504
5985-00-115-7149
5820-00-240-3720
5985-01-073-6103
5985-00-930-7223
1080-00-108-1654
1080-01-461-0152
1080-01-463-4081
8305-01-462-3601
1080-01-461-0156
1080-01-462-3602
4520-01-372-4425
4520-01-469-5334
5340-01-375-3342
4520-01-375-2122
5110-01-374-0905
5340-01-374-4460
4720-01-329-3451
4520-01-469-5775
4520-01-493-4154
5305-00-782-4386
4720-01-511-4501
5120-00-223-7397
5120-01-516-7290
5120-01-429-6964
5120-01-429-6065
5120-01-429-8137
5120-01-429-6964
5120-01-429-6065
5120-01-429-6945
5342-00-066-1235
4210-01-361-6921
4720-01-386-4210
5120-00-251-4489
5120-01-013-1676
4210-01-361-6921
5975-00-878-3791
4730-00-809-9703
4730-01-470-2409
5975-00-878-3791
8340-01-478-0133
8340-01-478-0136
Spreadsheet: 0a3ca414-7a46-4f10-9e3f-e3127888c16d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Highlights of Recent Canadian International Climate Change Support
 |  |  | Partner | Year | Total CAD$ Million
 |  | Adaptation
 |  | Pilot Program for Climate Resilience | Multilateral - World Bank | 2008-2010 | 100
 |  | Caribbean Disaster Risk Management Program | Multilateral - World Bank | 2007-2015 | 20
 |  | Global Facility for Disaster Risk Reduction: Track II | Multilateral - World Bank | 2006 | 3.5
 |  | GEF: SCCF - Adaptation | Multilateral - Global Environment Facility | 2005-2007 | 11
 |  | Building Response to Climate Change in Nigeria | Bilateral | 2007-2012 | 5
 |  | Tomini Bay Sustainable Coastal Livelihoods and Management | Bilateral | 2007-2012 | 4.7
 |  | Sahara and [NAME] | Bilateral | 2005-2009 | 3.3
 |  | International Research Initiative on Adaptation to Climate Change. | International Partnership | 2010-2015 | 6.25
 |  | Adaptation in Africa | International Partnership | 2006-2012 | 15
 |  | Climate Change, Agriculture and Food Security" Challenge Program - CGIAR | International Partnership | 2010-2012 | 5.5
 |  | Mitigation
 |  | GEF Trust Fund | Multilateral - Global Environment Facility | 2006-2010 | 48
 |  | GEF: SCCF - Technology | Multilateral - Global Environment Facility | 2007-2009 | 2.5
 |  | African Model Forest Initiative | Bilateral | 2009-2012 | 15
 |  | Olade Sustainable Energy Project | Bilateral | 2002-2010 | 4.8
 |  | Technology Early Action Measures (TEAM) | Bilateral | 2006-2009 | 7.1
 |  | Global Alliance on Agricultural Greenhouse Gases | International partnership | 2010-2015 | 27
 |  | Asia-Pacific Partnership on Clean Development and Climate | International Partnership | 2009-2011 | 12
 |  | Methane to Markets (M2M) | International Partnership | 2009-2010 | 0.7
 |  | Renewable Energy & Energy Efficiency Partnership (REEEP) | International partnership | 2009-2011 | 0.2
 |  | Note by the UNFCCC secretariat: Information provided by Canada related to contributions to the GEF have also been capture in the national communications module.