tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01b84952-7097-4862-b760-e0b6e8f19207
Sheet: % Change Non-Resident FTE

The Colorado Department of Higher Education
Final FTE Student Enrollment Report
Governing Board / Institutions | Percentage Change in Non-Resident Student FTE
 | FY 92 to FY 93 | FY 93 to FY 94 | FY 94 to FY 95 | FY 95 to FY 96 | FY 96 to FY 97 | FY 97 to FY 98 | FY 98 to FY 99 | FY 99 to FY 00 | FY 00 to 01 | FY 01 to 02 | FY 02 to 03 | FY 03 to 04 | FY 04 to 05 | FY 05 to 06 | FY 06 to 07 | FY 07 to 08 | FY 08 to 09 | FY 09 to 10
Regents of the University of Colorado:
University of Colorado-Boulder
University of Colorado-Colorado Springs
University of Colorado-Denver
University of Colorado-Health Sciences
Board of Governors of Colorado State University System:
Colorado State University-Education & General
Colorado State University-Professional Veterinary Medicine
Colorado State University - Pueblo
Trustees of Fort Lewis College:
Fort Lewis College
Trustees of Colorado School of Mines:
Colorado School of Mines
Board of Trustees University of Northern Colorado:
University of Northern Colorado
Trustees of Adams State College:
Adams State College
Trustees of Mesa State College:
Mesa State College
Trustees of Metropolitan State College:
Metropolitan State College of Denver
Trustees of Western State College:
Western State College
Community Colleges of Colorado:
Arapahoe Community College
Colorado Northwestern Community College
Community College of Aurora
Community College of Denver
Front Range Community College |  |  |  |  |  |  |  |  |  | 0.03 | 0.133
Lamar Community College
Morgan Community College |  |  |  |  |  |  |  | 0.183
Northeastern Junior College
Otero Junior College
Pikes Peak Community College
Pueblo Community College
Red Rocks Community College
Trinidad State Junior College
Local District Colleges:
Aims Community College
Colorado Mountain College
Governing Board Summary
District Summary
Public Summary
Spreadsheet: 470814d1468675290-auto-fill-a-row-by-data-from-another-sheet-when-i-type-a-cell-value-auto-populate-row-prc
Sheet: payment 

Date of   Payment | Cust id | Name | phone No | Amount
 | 728
 | 725
 | 726
Spreadsheet: 678577d1589967517-conditional-format-to-highlight-cell-or-row-of-every-x-nth-value-in-a-ordered-sequence-example1
Sheet: Sheet1

 |  | sequence
 |  | x |  |  | x+10 | x+11
 |  | 2412.63
 |  | 2413.07
 |  | 2413.53
 |  | 2413.99
 |  | 2414.44 |  |  | 2426.44 | 2427.44
 |  | 2414.89
 |  | 2415.34
 |  | 2415.8
 |  | 2416.25
 |  | 2416.69
 |  | 2417.14
 |  | 2417.59
 |  | 2418.04
 |  | 2418.48
 |  | 2418.93
 |  | 2419.38
 |  | 2419.83
 |  | 2420.27
 |  | 2420.71
 |  | 2421.16
 |  | 2421.6
 |  | 2422.04
 |  | 2422.48
 |  | 2422.92
 |  | 2423.37
 |  | 2423.8
 |  | 2424.24
 |  | 2424.68
 |  | 2425.12
 |  | 2425.55
 |  | 2425.99
 |  | 2426.43 |  |  | 2438.43 | 2439.43
 |  | 2426.87
 |  | 2427.29
 |  | 2427.73
 |  | 2428.17
Spreadsheet: 113973d1309859649-extract-the-next-future-date-with-criteria-from-other-column-futuredate
Sheet: Ark1

[NAME] | 2011-08-01 00:00:00 |  | Today
[NAME] | 2011-06-20 00:00:00
[NAME] | 2011-07-05 00:00:00 |  | Name: | Next future date:
[NAME] | 2011-05-15 00:00:00 |  | [NAME]
[NAME] | 2010-04-13 00:00:00
[NAME] | 2010-09-20 00:00:00
[NAME] | 2010-01-01 00:00:00
Spreadsheet: 119765d1314725494-mixing-spreadsheet-data-spreadsheet1
Sheet: Sheet1

Company Name | Exchange:Ticker | Geographic Locations | Total Revenue [Latest Annual] ($[NAME], Historical rate) | HR Executive
Wal-Mart Stores Inc. (NYSE:WMT) | NYSE:WMT | United States and Canada (Primary) | 421849
Exxon Mobil Corporation (NYSE:XOM) | NYSE:XOM | United States and Canada (Primary) | 341578
Berkshire Hathaway Inc. (NYSE:BRK.A) | NYSE:BRK.A | United States and Canada (Primary) | 136185
General Motors Company (NYSE:GM) | NYSE:GM | United States and Canada (Primary) | 135592
Spreadsheet: 548331d1511020833-getting-an-exponential-function-plotted-in-excel-bok1
Sheet: Ark1

 | Antall kaniner ved årets start |  |  |  |  |  | Måned | Antall kaniner
Januar | 68 | 107 | 108 | 109 |  |  | Januar | 108
Februar |  |  |  |  |  |  | Februar
Mars |  |  |  |  |  |  | Mars
April |  |  |  |  |  |  | April
Mai |  |  |  |  |  |  | Mai
Juni |  |  |  |  |  |  | Juni
[NAME] |  |  |  |  |  |  | [NAME]
August |  |  |  |  |  |  | August
September |  |  |  |  |  |  | September
Oktober |  |  |  |  |  |  | Oktober
November |  |  |  |  |  |  | November
[NAME] |  |  |  |  |  |  | [NAME]
Spreadsheet: 675709d1588437114-create-summary-list-from-multiple-worksheets-pq-box-location-summary-aligw
Sheet: Sheet1

Manufacturer | Model | Store location
A | xx | Box 1
B | yy | Box 1
C | zz | [NAME]
D | yy | [NAME]
E | xxx
F | yyy
G | zzz | [NAME]
H | yy | [NAME]
Spreadsheet: 0907be3c-9fd1-4f86-9fd8-fc302ab79566
Sheet: Table VI.2

Table VI. 2 الجدول
Municipal Waste Management (thousand tons)
إدارة النفايات البلدية ([NAME])
 | Municipal solid waste composted |  |  | Municipal solid waste incinerated |  |  | Municipal solid waste landfilled |  |  | Municipal solid waste recycled |  |  | Municipal solid waste disposed in other methods
 | النفايات البلدية التي يصار إلى تحويلها إلى سماد |  |  | النفايات البلدية التي يصار إلى حرقها |  |  | النفايات البلدية التي يصار إلى طمرها |  |  | النفايات البلدية التي يصار إلى إعادة تدويرها |  |  | النفايات البلدية التي يصار إلى التخلّص منها بطريقة أخرى
 | 2007 | 2008 | 2009 | 2005 | 2008 | 2009 | 2007 | 2008 | 2009 | 2004 | 2008 | 2009 | 2004 | 2005 | 2009
Bahrain | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | البحرين
Egypt | 1,850 (2003) | … | … | … | … | … | … | … | … | 3,103 (2003) | … | … | … | … | … | مصر
Iraq | … | … | … | 670 |  |  | … | … | … | … | … | … | … | 2146 | … | العراق
Jordan | … | … | … | … | … | … | … | 2,641* | 1,083* | … | … | … | … | 1,164* | 838* | الأردن
Kuwait | 0 | 0 | 0 | 0 | 0 | 0 | 1560 | 2175 | 1723 | 0 | 0 | 0 | … | … | … | الكويت
Lebanon | 202 (2004) | … | 241 | … | … | … | 1,123 (2004) | … | 1341 | 111 | … | 133 | 4 | … | 5 | لبنان
Oman | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | عمان
Palestine | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | فلسطين
Qatar | 47 | 47 | 47 | … | … | … | 672 | 698 | 742 | … | … | … | … | … | … | قطر
Saudi Arabia | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | المملكة العربية السعودية
The Sudan | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | السودان
The Syrian Arab Republic | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | الجمهورية العربية السورية
The United Arab Emirates | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | … | … | 1447 | 1369 | 1410 | … | … | … | … | … | … | اليمن
Sources: | UNSD/UNEP Environment Questionnaire on Environment Statistics 2010.
 | * | DOS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
Spreadsheet: 162541d1339958572-balance-cash-in-register-osa-00
Sheet: Sheet1

 |  |  |  |  | Treasury inventory model in the restaurant
 |  |  |  |  |  | Category of cash | Money | G  * H
 |  |  |  |  |  | 50 $ | 12 |  | <<600
 |  |  |  |  |  | 20 $ | 15 |  | <<300
 |  |  |  |  |  | 10 $ | 33 |  | <<330
 |  |  |  |  |  | 5 $ | 84 |  | <<420
 |  |  |  |  |  | 1 $ | 17 |  | <<17
 |  |  |  |  |  |  |  |  |  |  |  |  | <<Sum of money from the cell to the i 9 i 13
 |  |  |  |  |  |  |  |  |  |  |  |  | <<<<Amount to be reached
 |  |  |  |  |  |  |  |  |  |  |  |  | <<<Amount of the increase and decrease in the number of coins
Spreadsheet: 699881d1602806796-need-help-with-adding-two-more-columns-assessment-tracker
Sheet: 16

Teacher: |  |  |  | Student:
Course Name:
Course Code:
 |  |  |  |  |  |  |  |  |  |  | Categories Evaluated |  |  |  |  | unn
Assessment Name | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Assessment Name | K | T | C | A |  | A1/1.1 |  |  | D1/4.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2/1.2 |  |  | D2/4.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A3/1.3 |  |  | D3/4.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A4/1.4 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A5/1.5 |  |  | D5/4.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A6/1.6 |  |  | D6/4.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1/2.1 |  |  | E1/5.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E2/5.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3/2.3 |  |  | E3/5.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E4/5.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B5/2.5 |  |  | E5/5.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B6/2.6 |  |  | E6/5.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/3.1 |  |  | F1/6.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C2/3.2 |  |  | F2/6.2
Summatives | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Summatives | K | T | C | A |  | C3/3.3 |  |  | F3/6.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C4/3.4 |  |  | F4/6.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C5/3.5 |  |  | F5/6.5
 |  |  |  |  |  |  |  |  |  | Total: |  |  |  |  |  | C6/3.6 |  |  | F6/6.6
Total Products |  |  |  | 0.7 |  | Raw Mean Grade:
Total Observations |  |  |  |  |  | Weighted Mean Grade:
Total Conversations
 |  |  |  | 0.3 |  | Raw Mean Grade:
Level 0 |  |  |  |  |  | Weighted Mean Grade:
Level 1
Level 2 |  |  |  |  |  | Final Grade:
Level 3
Level 4 |  |  |  |  | Grade on Report Card:
Spreadsheet: 034004b8-4722-4c86-8d9f-b0051a61988a
Sheet: Sheet1

REP 4 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
PERFORMANCE CASTING |  |  | SUBJECT TO CHANGE
2013-03-11 00:00:00
 |  | WEEK TWO
 | Thurs | Fri | Sat | Sun
 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 2013-03-24 00:00:00
 | 19:30:00 | 19:30:00 | 19:30:00 | 13:00:00
CONCERTO BAROCCO
1st Violin | CHAPMAN | GILBREATH | KORBES | CHAPMAN
2nd Violin | RAUSCH | DEC | IMLER | RAUSCH
Man | LIN-YEE | CRUZ | [NAME] | LIN-YEE
Corps
1 | [NAME] | MACY | MACY | [NAME]
2 | CLARK | CLARK | CLARK | CLARK
3 | GENEROSA | O'CONNOR | O'CONNOR | GENEROSA
4 | NELSON | LOVE | LOVE | NELSON
5 | BIASUCCI | MURPHY | MURPHY | BIASUCCI
6 | MULLIN | MULLIN | MULLIN | MULLIN
7 | SAMUELSON | ANSPACH | ANSPACH | ANSPACH
8 | NEUVILLE | [NAME] | [NAME] | NEUVILLE
Pause
MOZART PIECES
Couple | DEC | KORBES | DEC | KORBES
 | CRUZ | ORZA | CRUZ | ORZA
Trio | NAKAMURA | SAMUELSON | NAKAMURA | SAMUELSON
 | GRIFFITHS | [NAME] | GRIFFITHS | [NAME]
 | MOORE | BARTEE | MOORE | BARTEE
Corps
1 | CARDEA | CARDEA | CARDEA | CARDEA
2 | DAVIS | DAVIS | DAVIS | DAVIS
3 | HIPOLITO | HIPOLITO | HIPOLITO | HIPOLITO
4 | THOMSON | THOMSON | THOMSON | THOMSON
Intermission
DANCING ON THE FRONT PORCH OF HEAVEN
Women
1 | DEC | CHAPMAN | CHAPMAN | DEC
2 | [NAME] | RAUSCH | RAUSCH | GILBREATH
3 | MURPHY | FOSTER | FOSTER | MURPHY
Men
1 | CRUZ | ORZA | ORZA | CRUZ
2 | [NAME] | [NAME] | [NAME] | [NAME]
3 | LIN-YEE | BARTEE | BARTEE | LIN-YEE
Intermission
IN THE UPPER ROOM
Stompers
Women
1 | DEC | DEC | DEC | DEC
2 | CHAPMAN | CHAPMAN | CHAPMAN | CHAPMAN
3 | IMLER | IMLER | IMLER | IMLER
X-Over Woman | MULLIN | MULLIN | O'CONNOR | O'CONNOR
Men
1 | ORZA | ORZA | ORZA | ORZA
2 | GAINES | GAINES | GAINES | GAINES
3 | [NAME] | [NAME] | [NAME] | [NAME]
Ballet Couples
1 | [NAME] | [NAME] | [NAME] | [NAME]
 | MOORE | MOORE | MOORE | MOORE
2 | MURPHY | MURPHY | MURPHY | MURPHY
 | GRIFFITHS | GRIFFITHS | GRIFFITHS | GRIFFITHS
[NAME] Couple
 | NAKAMURA | NAKAMURA | NAKAMURA | NAKAMURA
 | PORRETTA | PORRETTA | PORRETTA | PORRETTA
Spreadsheet: 888368d1738853754-employee-project-time-sheet-timesheet-foleycormac-
Sheet: Sheet1

Start Date | 2025-02-03 00:00:00 | Start Time | 08:00:00 | End Time | 17:00:00
Time Slot |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Spreadsheet: 112849d1308835182-errors-in-incremental-addition-book1
Sheet: Sheet1

 |  |  |  | Length | [NAME]
 |  |  |  | 4 | 18
 |  |  |  | New | New |  |  | Cumulative | Real
 | Top | Bottom | Angle | Length | [NAME] |  | Volume | Volume | Volume | Difference
 | 8 | 7.5 | 30 | 13.23760430703401 | 27.23760430703401 |  | 174.4898749084182 | 1616.332971296124 | 1583.154223871064 | 0.02095736910831891
 | 7.5 | 7 | 30 | 12.66025403784439 | 26.66025403784439 |  | 163.1387503803699 | 1441.843096387706 | 1413.540177223794 | 0.02002271999052718
 | 7 | 6.5 | 30 | 12.08290376865476 | 26.08290376865476 |  | 152.1209283833133 | 1278.704346007337 | 1254.851729138571 | 0.01900831493864197
 | 6.5 | 6 | 30 | 11.50555349946513 | 25.50555349946514 |  | 141.4364038539076 | 1126.583417624023 | 1106.761477175799 | 0.01790985759533781
 | 6 | 5.5 | 30 | 10.92820323027551 | 24.92820323027551 |  | 131.0851705987026 | 985.1470137701153 | 968.9428801243926 | 0.01672351794735571
 | 5.5 | 5 | 30 | 10.35085296108588 | 24.35085296108588 |  | 121.0672209657131 | 854.0618431714129 | 841.0704272395817 | 0.01544628786256275
 | 5 | 4.5 | 30 | 9.773502691896258 | 23.77350269189626 |  | 111.3825453952606 | 732.9946222056998 | 722.8198508311435 | 0.0140764968793492
 | 4.5 | 4 | 30 | 9.196152422706632 | 23.19615242270663 |  | 102.0311317950926 | 621.6120768104391 | 613.8683963104157 | 0.01261456127496685
 | 4 | 3.5 | 30 | 8.618802153517006 | 22.61880215351701 |  | 93.0129646541925 | 519.5809450153465 | 513.8951695306114 | 0.01106407653126706
 | 3.5 | 3 | 30 | 8.04145188432738 | 22.04145188432738 |  | 84.32802375854729 | 426.5679803611541 | 422.5815898397067 | 0.00943342213029097
 | 3 | 2.5 | 30 | 7.464101615137754 | 21.46410161513775 |  | 75.97628228380391 | 342.2399566026068 | 339.6119904459658 | 0.007738143029608402
 | 2.5 | 2 | 30 | 6.886751345948129 | 20.88675134594813 |  | 67.95770388158442 | 266.2636743188029 | 264.6744284872201 | 0.006004531078677822
 | 2 | 1.5 | 30 | 6.309401076758503 | 20.3094010767585 |  | 60.27223808093846 | 198.3059704372184 | 197.4618010169741 | 0.004275102404093678
 | 1.5 | 1 | 30 | 5.732050807568877 | 19.73205080756888 |  | 52.91981274773616 | 138.03373235628 | 137.6734201316567 | 0.002617151693324438
 | 1 | 0.5 | 30 | 5.154700538379251 | 19.15470053837925 |  | 45.90032114422969 | 85.11391960854382 | 85.01730063270637 | 0.001136462521374115
 | 0.5 | 0 | 30 | 4.577350269189626 | 18.57735026918963 |  | 39.21359846431413 | 39.21359846431413 | 39.21359846431413 | 0
 |  |  |  | 4 | 18 |  |  | 0
Spreadsheet: 61686d1262626020-calculate-daily-takings-needed-based-on-daily-spend-and-profit-margin-daily-takings-needed
Sheet: Sheet1

 |  | Year | Month | Week | Day
 | Rent | 18250 | 1500 | 350 | 50
 | Advertising & Postage | 12000 | 1000 | 230.7692307692308 | 32.87671232876713
 | General Expenses | 5000 | 416.6666666666667 | 96.15384615384616 | 13.6986301369863
 | Insurance | 1000 | 83.33333333333333 | 19.23076923076923 | 2.73972602739726
 | Licences & Subsciptions | 1000 | 83.33333333333333 | 19.23076923076923 | 2.73972602739726
 | Professional Fees | 2000 | 166.6666666666667 | 38.46153846153846 | 5.47945205479452
 | Telecommunication Expenses | 2000 | 166.6666666666667 | 38.46153846153846 | 5.47945205479452
 | Transport | 5000 | 416.6666666666667 | 96.15384615384616 | 13.6986301369863
 | Water & Electricity | 5000 | 416.6666666666667 | 96.15384615384616 | 13.6986301369863
 | Total | 51250 | 4250 | 984.6153846153848 | 140.4109589041096 | needed
 | Daily | 316.2
 | Lest 18% VAT | 267.9661016949153
 | Retail | 233.1305084745763 | 128.221779661017 | Retail (87%) |  | 0.55 | margin on retail sales
 | Wholesale | 34.83559322033899 | 12.19245762711864 | Wholesale (13%) |  | 0.35 | margin on wholesale sales
 | Profit |  | 140.4142372881356
Spreadsheet: 3e172343-fe85-42fc-b923-92a8fd8d0051
Sheet: Table 4.4

4.4 Business investment
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Chain volume measures (a) (b) – $ million
September | 45975 | 47811 | 61265 | 67825 | 65179
December | 48034 | 49749 | 60059 | 64931 | 62901
March | 46293 | 53041 | 63948 | 65252 | 62693
June | 47703 | 54714 | 66098 | 70686
Annual | 188005 | 205315 | 251370 | 268694
Annual change (b) – per cent
September | -8.478321455587846 | 3.993474714518763 | 28.13996778983916 | 10.70758181669795 | -3.901216365646887
December | -3.112330314460332 | 3.570387642086859 | 20.72403465396289 | 8.112023177209071 | -3.126395712371599
March | -4.75083329904119 | 14.57671786231181 | 20.56333779529043 | 2.039156814912113 | -3.921718874517255
June | -1.906230721776681 | 14.69718885604678 | 20.8063749680155 | 6.941208508578178
Annual | -4.6 | 9.20720193611872 | 22.43138591919733 | 6.891832756494411
(a) Reference year for chain volume measures is 2011–12.
(b) Figures are seasonally adjusted.
Source: ABS, Australian National Accounts: National Income, Expenditure and Product,
cat. no. 5206.0, March 2014 release.
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 3 September 2014
Spreadsheet: 823191d1679795914-dynamic-irr-between-2-dates-xlf-flexible-irr
Sheet: Sheet1

Dates |  | 2022-05-01 00:00:00
Period |  | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3
Cashflow |  | -1 | -1 | 1 | 5 | -1 | -1 | -1 | 6 | -1 | -1 | -1 | 7
Option 1 - query by dates (row 8)
 |  | P 1 | P 2 | P 3
Reporting periods | Start | 2023-05-01 00:00:00 | 2023-09-01 00:00:00
 | Stop | 2023-07-01 00:00:00 | 2023-04-01 00:00:00
 | XIRR
Option 2 - Query by reporting period (Row 9)
 | Period | 1
 | XIRR
Spreadsheet: 871586d1718030379-previous-month-closing-balance-previous-month-balance
Sheet: Monthly Bank Statement

 | The formula on H8 works when the transactions start on the first day of the month, when the transactions start on the second or fourth day of the month the formula does not work
 | The formula on H8 extract the closing balance of the previous month. Please kindly help with formula that extract the closing balance regardless of which day the transactions
 | starts
 |  |  |  |  | May
 | Date | Description | Account | Reference | Debit | Credit | Balance |  |  |  |  | April
 | Balance B/d |  |  |  |  |  |  |  |  |  |  | May
 |  | May | Bank Charges | Mayb1 | 0 | 120
 | 2024-05-02 00:00:00 | May | Bank Charges | Mayb2 | 0 | 16
 | 2024-05-06 00:00:00 | May | Fees | 15863 | 2133.34 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15863A | 2133.33 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15863B | 2133.33 | 0
 | 2024-05-06 00:00:00 | May | Fees | 15864 | 1485 | 0
 | 2024-05-09 00:00:00 | May | PAYE | Mayb3 | 0 | 15.01
 | 2024-05-10 00:00:00 | May | Electricity | 2274 | 0 | 400
 | 2024-05-10 00:00:00 | May | Electricity | 2275 | 0 | 270
 | 2024-05-10 00:00:00 | May | Bank Charges | Mayb4 | 0 | 13.4
 | 2024-05-10 00:00:00 | May | Bank Charges | [NAME] | 0 | 6.7
 | 2024-05-16 00:00:00 | May | Fees | 15865 | 1356 | 0
 | 2024-05-21 00:00:00 | May | Electricity | 2293 | 0 | 668.4999999999999
 | 2024-05-21 00:00:00 | May | Electricity | 2294 | 0 | 401.1
 | 2024-05-21 00:00:00 | May | Water | 2288 | 0 | 700
 | 2024-05-21 00:00:00 | May | Water | 2289 | 0 | 700
 | 2024-05-21 00:00:00 | May | Telephone & Internet | 2290 | 0 | 483
 | 2024-05-21 00:00:00 | May | Telephone & Internet | 2291 | 0 | 262
 | 2024-05-21 00:00:00 | May | Sundry Expenses | 2292 | 0 | 140
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb6 | 0 | 67.09
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb7 | 0 | 10.7
 | 2024-05-21 00:00:00 | May | Bank Charges | [NAME] | 0 | 2.4
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb9 | 0 | 7
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb10 | 0 | 7
 | 2024-05-21 00:00:00 | May | Bank Charges | Mayb11 | 0 | 7.45
 | 2024-05-24 00:00:00 | May | Cleaning | 2301 | 0 | 126
 | 2024-05-24 00:00:00 | May | Bank Charges | Mayb12 | 0 | 2.52
 | 2024-05-24 00:00:00 | May | Bank Charges | Mayb13 | 0 | 2.4
 | 2024-05-28 00:00:00 | May | Electricity | 2305 | 0 | 260
 | 2024-05-28 00:00:00 | May | Bank Charges | Mayb14 | 0 | 5.2
 | 2024-05-28 00:00:00 | May | Bank Charges | Mayb15 | 0 | 2.6
 | 2024-05-30 00:00:00 | May | Fees | 15866 | 1485 | 0
 | 2024-05-30 00:00:00 | May | PAYE | 2312B | 0 | 3000
 | 2024-05-30 00:00:00 | May | Bank Charges | Mayb16 | 0 | 40
 | 2024-05-31 00:00:00 | May | Fees | 15867 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Fees | 15868 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Fees | 15869 | 2475 | 0
 | 2024-05-31 00:00:00 | May | Bank Charges | Mayb17 | 0 | 192
 | 2024-05-31 00:00:00 | May | Bank Charges | Mayb18 | 0 | 9.6
Spreadsheet: 195698d1353606418-need-a-formula-that-will-count-if-conditions-order-system
Sheet: Processing

 |  | Need help with a formula starting in cell B4 that will count 1,2,3,…. IF B2 = Damaged, Incomplete or Returned. Need the cell to be blank if condition doesn’t match. | [NAME] D600 works correctly | [NAME] E600 works correctly | [NAME] F600 works correctly | [NAME] to G600 works correctly | [NAME] to H600 works correctly
Customer PO Number | Status | Damaged - Incomplete - Returned | Pending Shipment | Service Issue | Backordered | Quote | Order Pending
286 | Damaged
291 | Incomplete
296 | COMPLETED
1254 | Damaged
1336 | Processing |  | 1
1339 | Cancelled
1352 | Cancelled
4089 | Processing |  | 2
10135 | COMPLETED
10136 | COMPLETED
20201 | COMPLETED
20208 | Processing |  | 3
20213 | Returned
20226 | Processing |  | 4
20227 | Backordered |  |  |  | 1
20231 | Backordered |  |  |  | 2
20233 | Backordered |  |  |  | 3
20238 | Quote |  |  |  |  | 1
20243 | Incomplete
20261 | Order Pending |  |  |  |  |  | 1
20263 | Processing |  | 5
20268 | Processing |  | 6
20271 | Processing |  | 7
20273 | COMPLETED
20278 | Processing |  | 8
20286 | Processing |  | 9
20288 | Quote |  |  |  |  | 2
20291 | Processing |  | 10
20293 | Processing |  | 11
101412 | Damaged
983767 | Service Issue |  |  | 1
986876 | COMPLETED
986980 | Processing |  | 12
987121 | Processing |  | 13
987461 | Processing |  | 14
987462 | Processing |  | 15
608273102812 | COMPLETED
DEBHAM | Cancelled
designer | COMPLETED
[NAME] 2 | Damaged
[NAME] | Processing |  | 16
JH001 | Backordered |  |  |  | 4
None | Damaged
Order Date 8-22-12 | Service Issue |  |  | 2
20308 | Processing |  | 17
989084 | Processing |  | 18
Processing
Backordered
Damaged
Quote
Service Issue
Cancelled
Incomplete
Returned
Order Pending
Unused
COMPLETED
Processing
Backordered
Cancelled
Damaged
Quote
Service Issue
Incomplete
Returned
Order Pending
Unused
2012-11-22 00:00:00
Spreadsheet: 704323d1605502838-formula-to-spread-amount-file1
Sheet: Sheet1

Amount | Start | Finish | Months | 2020-01-20 00:00:00 | 2020-02-20 00:00:00 | 2020-03-20 00:00:00 | 2020-04-20 00:00:00 | 2020-05-20 00:00:00 | 2020-06-20 00:00:00 | 2020-07-20 00:00:00 | 2020-08-20 00:00:00 | 2020-09-20 00:00:00 | 2020-10-20 00:00:00 | 2020-11-20 00:00:00 | 2020-12-20 00:00:00 | 2021-01-20 00:00:00 | 2021-02-20 00:00:00 | 2021-03-20 00:00:00 | 2021-04-20 00:00:00 | 2021-05-20 00:00:00 | 2021-06-20 00:00:00 | 2021-07-20 00:00:00 | 2021-08-20 00:00:00 | 2021-09-20 00:00:00 | 2021-10-20 00:00:00 | 2021-11-20 00:00:00 | 2021-12-20 00:00:00 | CHECK
11500 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00
11500 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
11500 | 2020-06-01 00:00:00 | 2021-07-01 00:00:00
Spreadsheet: 85455d1285581976-conditional-formatting-formulas-conditional-formatting-formulas-excel-2003-
Sheet: Sheet1

 | Action Name | Time
 | Welcome
 | Start | 00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Welcome
 | Time Take Duration | 01:03:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start
 | Goodbye |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time Take Duration
 | Time Take Duration | 01:27:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goodbye
 | Time Take Duration | 00:45:00
 | Welcome
 | Time Take Duration | 01:40:00
 | Time Take Duration | 00:25:00
 | Goodbye | 02:30:00
 |  |  |  |  |  | [NAME] | SunOffice024
 |  |  |  |  |  |  | http://www.excelforum.com/showthread.php?p=2389199#post2389199