tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43550d1242196802-a-running-average-with-blanks-that-are-part-of-the-average-running-average
Sheet: Sheet1

 |  |  | Target | 64
 |  |  |  |  | Cumulative | Cumulative Average
 |  |  | 2009-05-01 00:00:00 | 1 | 1 | 0.015625 | I have tried several approaches, but I am not sure if what I want to do is even possible in Excel.
 |  |  | 2009-05-02 00:00:00 | 2 | 3 | 0.046875 | I want to keep a running average for the month that is current for any given day of the month. For example today is the 12th of the month. I have processed 64 items for the month. Nothing was processed on the 3rd, the 8th or today, but those days need to be included in the average. The average for today then would be 64 divided by 12 which equals 5.33. The daily average will appear in a box that will update each day. I assume that you would use TODAY() if it is do-able. I have attached an example of what I have in mind. I would appreciate any help anyone could give me. thank you.
 |  |  | 2009-05-03 00:00:00 | 3 | 6 | 0.09375
 |  |  | 2009-05-04 00:00:00 | 4 | 10 | 0.15625
 |  |  | 2009-05-05 00:00:00 | 5 | 15 | 0.234375
 |  |  | 2009-05-06 00:00:00 | 6 | 21 | 0.328125
 |  |  | 2009-05-07 00:00:00 | 4 | 25 | 0.390625
 |  |  | 2009-05-08 00:00:00 |  | 25 | 0.390625
 |  |  | 2009-05-09 00:00:00 |  | 25 | 0.390625
 |  |  | 2009-05-10 00:00:00 | 1 | 26 | 0.40625
 |  |  | 2009-05-11 00:00:00 | 5 | 31 | 0.484375
 |  |  | 2009-05-12 00:00:00 | 6 | 37 | 0.578125
 |  |  | http://www.excelforum.com/excel-general/683401-a-running-average-with-blanks-that-are-part-of-the-average.html
Spreadsheet: 525522d1498755907-count-number-of-occurrencies-for-account-number-copy-of-test-file-2-bh-mng-
Sheet: TEST

account number | name | address | attended | helper | ACCOUNT NUMBER | NAME | TIMES ATTENDED
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 0
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 0
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 0
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 0
5 | d |  | 0
5 | d |  | 1
5 | d |  | 1
5 | d |  | 0
5 | d |  | 1
5 | d |  | 0
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
5 | d |  | 1
Spreadsheet: 015f6bf2-01c2-497e-96e9-c21c09d97704
Sheet: rentals

MONTH: |  |  |  | Rentals Register for ([NAME] your office name) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORN
……………………….. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ……………
DO NOT CHANGE FORMAT
SPECIAL TRANSACTION REGISTER - RENTALS |  |  |  |  |  |  | Description: - | Apt-Apartment   Of=Office   P=Penthouse   WF=Whole Floor   V=Villa   L=Land   WH=Warehouse   LC=Labor Camp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | InsertLEASED price or Withdrawn date.
NOTE: FILL IN ALL CELLS |  |  |  | ENSURE 'ejari REGISTERED |  |  | Use: | Res=Residential   Com=Commercial   Ret=Retail   Ind=Industrial   Agr=Agricultural   MU=Mixed Use (Srike uses)   Uti=Utility/Government Use |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Lease contracts MUST be Ejari registered
AD - Administrators initials |  |  | "R" |  |  |  | [NAME] or [NAME] or Property Manager's Name |  |  |  | Place an "x" in the box or No. of BRs under type leased |  |  |  |  |  |  |  |  |  |  |  |  |  | MARKET: P= Primary / S= Secondary
Insert Exact Date/Time |  |  | OFFICE |  | TYPE | Client Nationality | CLIENT |  |  |  | Description |  |  |  |  |  |  |  | Use |  |  |  | AREA | [NAME] | MARKET | EJARI | COMM | LEASED/
DATE | TIME | AD | STR NO: | BRN | FORM |  | NAME | Apt | Of | P | WF | V | L | WH | LC | [NAME] | Com | Ret | Ind | Agr | MU | Uti | SQ FT | CODE | P or S | LEASE REG NO. | % | EXPIRED
Spreadsheet: 49460d1248811934-excel-sorting-book3
Sheet: Sheet1

person | card number |  | card no. | [NAME] | susan | bill
[NAME] | 1 |  | 1 | X | X | X
susan | 1 |  | 2
bill | 1 |  | 3
[NAME] | 4 |  | 4 | X
[NAME] | 5 |  | 5 | X
susan | 6 |  | 6 |  | X | X
bill | 6 |  | 7
bill | 10 |  | 8
 |  |  | 9
 |  |  | 10 |  |  | X
Spreadsheet: 711127d1609451296-most-current-date-in-a-row-dates
Sheet: HL Project

 |  | Architect Name - Project Status Matrix
AOR Information (Don't show on HL Matrix) |  | General Information |  |  |  |  | Design Phase |  |  |  |  |  |  |  | Landlord Comments |  |  | Permitting Phase |  |  |  |  |  | Construction
Project Number | Structural/ MEP Engineer | Store # or Abrv. | Project Location | Project Type | [NAME] | [NAME] | RFP [NAME] | [NAME] | PKO | Project DD Date | Actual DD Date | Project  CD Date | Actual CD  Date | PKO to CD | HL Received Date | AOR Received | Resond to LL | Submit for Permit | Comments Received | Response Issued | Plans Approved | Days For Permit | # of Rev.'s | Construction Date | Grand Opening | Comments:
1
1
3
4
Spreadsheet: 87522d1287412166-look-for-duplicated-data-but-only-in-specific-cells-book1
Sheet: Sheet1

 |  |  | Mon | Tue
 |  |  | 2010-11-01 00:00:00 | 2010-11-02 00:00:00
 | 1 | Shift | 2x11 | 2x11
 |  | Vehicle | SA1 | SA2
 |  | Loc 1 | Rotherham | Doncaster
 |  | [NAME] | Rotherham | Scunthorpe
 | 2 | Shift | 2x11 | 2x11
 |  | Vehicle | SA2 | SA1
 |  | Loc 1 | Sheffield | [NAME]
 |  | [NAME] | Sheffield | Huddersfield
 | 3 | Shift | 2x11 | 2x11
 |  | Vehicle | SA3 | SA1
 |  | Loc 1 | Barnsley | Doncaster
 |  | [NAME] | Wakefield | Lincoln
Spreadsheet: 128976d1321383796-excel-2007-vlookup-match-testf
Sheet: Master Log

 | Name | Grant Date | Signed Original Agreement | Default
 | Person 1 | 2011-06-01 00:00:00 | Yes
 | Person 1 | 2009-05-01 00:00:00 | No
 | Person 1 | 2007-02-23 00:00:00 | No
 | Person 2 | 2011-06-01 00:00:00 | Yes
 | Person 2 | 2009-05-01 00:00:00 | No
 | Person 2 | 2007-02-23 00:00:00 | No
 | Person 3 | 2011-06-01 00:00:00 | Yes
 | Person 3 | 2009-05-01 00:00:00 | No
 | Person 3 | 2007-02-23 00:00:00 | No
 | Person 3 | 2011-06-01 00:00:00 | Yes
 | Person 4 | 2011-06-01 00:00:00 | Yes
 | Person 4 | 2007-02-23 00:00:00 | No
 | Person 5 | 2011-09-14 00:00:00 | Yes
 | Person 5 | 2009-05-01 00:00:00 | No
 | Person 5 | 2007-02-23 00:00:00 | No
 | Person 5 | 2011-06-01 00:00:00 | No
 | Rules
 | 1. If [NAME] has "Yes" in column D and Grant Date is on or after 6/1/2011 then all other [NAME] for that person should have "Yes" in column E.
Spreadsheet: 06fae95e-9dbf-4c9c-96ac-3e2c2beb25a0
Sheet: Prog Expend

 | Career & Technical Education             1500 Highway 36 West                 Roseville MN 55113-4266 |  | Secondary Career and Technical Education Program Expenditure Worksheet
GENERAL INFORMATION AND INSTRUCTIONS: According to Minnesota Statutes § 124D.4531, districts may levy for secondary Career and Technical Education (CTE) programs on a current funding basis. Expenditures must be made in state-approved career and technical education programs for activities identified in statute. Complete a separate Program [NAME] section for each secondary CTE program within the district/center and submit information via the CTE Levy Web-Based System on or before October 15 following the program year.
 |  |  | This is expenditure for fiscal year:
DISTRICT IDENTIFICATION | District Number: |  | District Type:
 | District Name:
PROGRAM INFORMATION | Each Career and Technical Education Program has its own unique OE Program Code and applicable UFARS Program Code. Refer to [NAME] for these codes.
OE PROGRAM CODE |  | PROGRAM NAME |  |  | UFARS PROGRAM CODE
PROGRAM EXPENDITURE INFORMATION | Descriptions provided in the UFARS Manual are to be used as guidelines when entering expenditures.
 | UFARS OBJ CODE | ITEM |  |  |  | AMOUNT
 | 140/143 | [NAME] (from the Staffing Expenditure Worksheet) |  |  |  | 0
 | 185 | Staff Extended Time (from the Staffing Expenditure Worksheet) |  |  |  | 0
 | 366 | Staff Travel
 |  | • Between instructional sites |  | 0
 |  | • For professional development |  | 0
 |  | • For student organization activity |  | 0
 | 305/394 | Contracted Services (approved by the state) |  |  |  | 0
 | 433 | Specialized CTE Instructional Supplies |  |  |  | 0
Prog Code 610 | Various | Curriculum Development Activities |  |  |  | 0
 |  |  |  | Program Total
OE PROGRAM CODE |  | PROGRAM NAME |  |  | UFARS PROGRAM CODE
PROGRAM EXPENDITURE INFORMATION | Descriptions provided in the UFARS Manual are to be used as guidelines when entering expenditures.
 | UFARS OBJ CODE | ITEM |  |  |  | AMOUNT
 | 140/143 | [NAME] (from the Staffing Expenditure Worksheet) |  |  |  | 0
 | 185 | Staff Extended Time (from the Staffing Expenditure Worksheet) |  |  |  | 0
 | 366 | Staff Travel
 |  | • Between instructional sites |  | 0
 |  | • For professional development |  | 0
 |  | • For student organization activity |  | 0
 | 305/394 | Contracted Services (approved by the state) |  |  |  | 0
 | 433 | Specialized CTE Instructional Supplies |  |  |  | 0
Prog Code 610 | Various | Curriculum Development Activities |  |  |  | 0
 |  |  |  | Program Total
Spreadsheet: 843680d1695475642-help-with-formula-for-countiifs-index-match-multiple-criteria-same-column-countif_index_match_hd_4-sort
Sheet: Example(2)

Master Indicators | Value | PnL |  | # | %
Start date | 2022-08-17 00:00:00 | Profit
End date | 2023-02-17 00:00:00 | Loss
Start time | 00:00:00 | Total
End time | 23:59:59
Ultimate Direction Change
(T) SMA 100/Yellow & Gold
(T) CYCLE Bull
(P1) PSAR/OC
(P2,P1,T) Candle Value
(T) Yellow >= Purple, Ivory
(T) Close > Red
(T) OBOS > (P1), (P2) OBOS
 |  |  |  |  |  |  | FORMULA
Indicators | Profit | Loss | Win% | Loss% | Total
Ultimate Bar Color
Bull Bar
Bear Bar
Ultimate Direction Change
[NAME]
Bear Arrow
(T) SMA 100/Yellow & Gold
Bull Trend
Bear Trend
Neutral
Golden Ropes Bull/Bear
Bull
Bear
Neutral
Golden Ropes Price
Above
Middle
Below
OBS Level
1
2
3
4
(P1) CYCLE Bull
1
2
3
4
5
6
7
Bear
(T) CYCLE Bull
1
2
3
4
5
6
7
Bear
Bull Continuation
Neutral
Continuation
(P1) CYCLE Bear
-1
-2
-3
-4
-5
-6
-7
Bull
(T) CYCLE Bear
-1
-2
-3
-4
-5
-6
-7
Bull
Bear Continuation
Neutral
Continuation
(P2) Candle Value
Bull
Bear
(P1) Candle Value
Bull
Bear
(T) Candle Value
Bull
Bear
(P2,P1,T) Candle Value
Bull, Bull, Bull
Bull, Bear, Bull
Bear, Bull, Bull
Bear, Bear, Bull
Bull, [NAME], Bull
Bear, Bear, Bear
Bear, Bull, Bear
Bull, Bull, Bear
(P2) Tier MA
1
2
(P1) [NAME]
1
2
(T) Tier MA
1
2
(P2) O.C./MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(P2) Low/MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(P1) O.C./MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(P1) Low/MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(T) O/MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(T) Low/MA
Yellow
Purple
Aqua
Ivory
Gold
Red
Above All
(P2) M.A. O.C. #
1
2
3
4
5
6
(P2) M.A. Low #
1
2
3
4
5
6
(P1) M.A. O.C. #
1
2
3
4
5
6
(P1) M.A. Low #
1
2
3
4
5
6
(T) M.A. Open #
1
2
3
4
5
6
(T) M.A. Low #
1
2
3
4
5
6
(P1) PSAR/OC
Above
Neutral
Below
(T) PSAR/OC
Above
Neutral
Below
(T) 100 SMA/Yellow & Red
Bull
Bear
Neutral
(T) Yellow/13 EMA
1
2
(T) Yellow/33 EMA
1
2
(T) Yellow/55 EMA
1
2
(T) Yellow >= Purple, Ivory, Aqua
True
False
(T) Yellow >= Purple, Ivory
True
False
(T) Open < Yellow
True
False
(T) Close > Yellow
True
False
(T) Close > Red
True
False
(T) Open or Close > Gold
True
False
(T) Close > Purple, Ivory, Aqua
True
False
(T) Close > 20 SMA
True
False
(T) Close > 100 SMA
True
False
(T) PSAR < Red
True
False
(T) PSAR < Yellow
True
False
(T) OBOS > (P1), (P2) OBOS
True
False
(T) OBOS > (P1) OBOS
True
False
Spreadsheet: 167794d1342105043-excel-2007-vlookup-help-2012-bud-help
Sheet: Apr

Monthly [NAME]
 | [NAME] |  |  | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage |  |  | 2012-04-01 00:00:00 | 2012-03-25 00:00:00 | 875.48 | 875.48
 | Tundra |  |  | 2012-04-15 00:00:00 | 2012-04-05 00:00:00 | 343.92 | 343.92
 | Cruze |  |  |  |  | 240.38
 | Verizon Wireless |  |  | 2012-04-23 00:00:00 | 2012-04-19 00:00:00 | 167.54 | 167.54
 | RZMC |  |  | 2012-04-18 00:00:00 | 2012-04-13 00:00:00 | 24.88 | 24.88
 | Capital One |  |  | 2012-04-18 00:00:00 | 2012-04-05 00:00:00 | 30 | 153.83
 | Household Bank
 | Insurance |  |  | 2012-04-15 00:00:00 | 2012-04-05 00:00:00 | 68.74 | 68.74
 | RG&E |  |  | 2012-04-13 00:00:00 | 2012-04-19 00:00:00 | 202.95 | 202.95
 | Time Warner |  |  | 2012-04-16 00:00:00 | 2012-04-19 00:00:00 | 121.32 | 121.32
 | ACS |  |  |  | 2012-04-16 00:00:00 | 157 | 157
 | AES |  |  |  | 2012-04-16 00:00:00 | 139 | 139
 | Sallie Mae |  |  | 2012-04-07 00:00:00 | 2012-04-05 00:00:00 | 213.47 | 213.47
 | 1st Financial |  |  |  | 2012-04-16 00:00:00 | 35 | 35
 | Waste Management |  |  | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 | 92.19 | 92.19
 | Water Authority
 | Wells Fargo - Furniture |  |  | 2012-04-11 00:00:00 | 2012-04-05 00:00:00 | 40 | 40
 | Doe |  |  | 2012-04-21 00:00:00 | 2012-04-19 00:00:00 | 301.32 | 301.32
 | [NAME] |  |  |  | 2012-04-05 00:00:00 | 175
 | [NAME]
 | Paychecks
 |  |  |  | Pay Date | Amount
 |  |  |  | 2012-04-06 00:00:00 | 1540.13
 |  |  |  | 2012-04-20 00:00:00 | 1233.56
 |  |  |  | 2012-04-27 00:00:00
 | Total Bills for month:
 | Total Payments for month:
 | Total Income for the month
Spreadsheet: 191944d1352257764-excel-2003-lookup-issue-sample-workbook
Sheet: LOOKUP VECTOR

B's | B's
2 | 2
4 | 4
6 | 6
8 | 8
10 | 10
11 | 11
13 | 13
15 | 15
17 | 17
20 | 20
22 | 22
24 | 24
26 | 26
28 | 28
29 | 29
31 | 31
33 | 33
35 | 35
Spreadsheet: 131492d1323098500-index-and-match-not-returning-values-indexmatchissue
Sheet: Sheet1

Name | Value 1 | Value 2 | Value 3 | Value 4
Example |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTRACTS
Example |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Example |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Example
Spreadsheet: 717163d1612517247-functions-to-cleanse-data-to-a-specific-format-bazlurgan-dummy-workbook-3
Sheet: Sheet1

Reference mixed | reference cleansed
12A    00001234/D | A1234
1 A  1234 | A1234
A0001234 | A1234
2C0001234/E | C1234
C    0001234/E | C1234
3 B12345/D | B12345
1A 0000345/E | A345
Spreadsheet: 860775d1708764762-populate-from-another-sheet-with-duplicates-book1-version-1-2-
Sheet: Sheet3

Customer # | Customer Name | Product name | [NAME] (lbs) | [NAME] (kgs)
3006 | Jordan | Poly Bags
3004 | Hollis | Carton
3004 | [NAME] | Large Carton
2918 | [NAME] | Large Carton
Spreadsheet: 677411d1589348151-converting-decimal-mins-to-mins-and-seconds-converting-decimal-mins-to-mins-and-seconds
Sheet: Sheet1

1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2
2.3
2.4
2.5
2.6
2.7
Spreadsheet: 593191d1539030086-find-search-2-columns-find-search-multiple-criteria-and-add-or-sum-totals-find-search-2-columns-multiple-criteria-and-add-sum-totals
Sheet: Summarized BOMs

 |  | Sub Assembly Name | Control Box Sub-Assembly (small) |  |  |  |  |  | For Excel Forum
 |  | GroupID | CONTROL PANEL |  |  |  | Review Date | 2018-10-08 00:00:00
 |  | Terminal Seq. |  | See, Sub Assembly - CP (small)-BOMs Worksheet
 |  | Terminal Name |  | Control Box SA
 |  | Parts |  | Capacitor | Relay | Transformer | PCB - Defrost | PCB - Ignition |  |  |  |  | Searched / Found Uniqe Item Variations
 |  | Item Class |  | CA | SO | TR | PB | PB | Comments
 |  | 0272L00906 |  | 1 |  |  |  |  |  |  |  |  | CAP040000370VA ( CAPACITOR )
 |  | 0272L00907 |  | 1 |  |  |  |  |  |  |  |  | CAP050000440LA ( CAPACITOR )
 |  | 0272L00908 |  | 1 |  |  |  |  |  |  |  |  | [NAME] ( CAP, 10 MFD/370V/OVAL )
 |  | 0272L00909 |  | 1
 |  | 0272L00910 |  | 1 |  |  |  |  |  |  |  |  | 10135604 ( RELAY )
 |  | 0272L00911 |  | 1
 |  | 0272L00919 |  | 1 |  |  |  |  |  |  |  |  | B1141654 ( TRANSFORMER,208-240,75VA,RESET )
 |  | 0272L00920 |  | 1 |  |  |  |  |  |  |  |  | 0130M00145 ( Transformer, 75VA, 480V to 24V )
 |  | 0272L00921 |  | 1 |  |  |  |  |  |  |  |  | 0130M00148 ( Transformer, 75VA, 575V to 24V )
 |  | 0272L00942 |  | 1 |  |  |  |  |  |  |  |  | 0130M00146 ( TRANSFORMER,150VA,480V TO 230V )
 |  | 0272L00943 |  | 1 |  |  |  |  |  |  |  |  | 0130M00147 ( Transformer,150VA,575V to 230V )
 |  | 0272L00944 |  | 1
 |  | 0272L00951 |  | 1
 |  | 0272L00952 |  | 1 |  |  |  |  |  |  |  |  | PCBDM133 ( PCB, DEFROST CONTROL )
 |  | 0272L00953 |  | 1
 |  | 0272L00964 |  | 1 |  |  |  |  |  |  |  |  | PCBAG123 ( PCB, IGNITION, DSI, INTEG )
 |  | 0272L00965 |  | 1
 |  | 0272L00966 |  | 1
 |  | 0272L00967 |  | 1
 |  | 0272L00968 |  | 1
 |  | 0272L00969 |  | 1
 |  | 0272L00996 |  | 1
 |  | 0272L00997 |  | 1
 |  | 0272L00998 |  | 1
 |  | 0272L00999 |  | 1
 |  | 0272L01000 |  | 1
 |  | 0272L01001 |  | 1
 |  | 0272L01005 |  | 1
 |  | 0272L01006 |  | 1
 |  | 0272L01007 |  | 1
 |  | 0272L01062
 |  | 0272L01063
 |  | 0272L01064 |  | 1
 |  |  | Totals
 |  | * please create another TAB for another sub-assembly line
 |  | * please note that we will startup with only 1 match station in the control box area, but may expand to 2
Spreadsheet: 216392d1361753734-counting-cells-that-contain-data-in-a-range-site-g-roster
Sheet: Final Report

NU |  | MALE |  |  |  | FEMALE |  |  |  | TOTAL
 |  | OFFICER | NCO | SOLDIER | CIVILIANS | OFFICER | NCO | SOLDIER | CIVILIANS | OFFICER | NCO | SOLDIER | CIVILIANS
1 | TOTAL USA PERSONNEL IN GAIZNTEP (PERSONNEL OF COL C. WANNAT AND LTC BRANSON)
2 | USA PERSONNEL ON DAY AND NIGHT SHIFT IN HHB (STAYING IN THE BARRACKS)
3 | USA PERSONNEL ON DAY AND NIGHT SHIFT IN BRAVO (STAYING IN THE BARRACKS)
4 | USA PERSONNEL ON DAY AND NIGHT SHIFT IN CHARLIE (STAYING IN THE BARRACKS)
5 | USA PERSONNEL ON STAYING IN ORDUEVI(MENTAL)
6 | USA PERSONNEL STAYING  IN HOTEL (CIVILIANS)
7 | TOTAL
8 | NATO CEIS GROUP (STAYING IN BARRACKS)
 | **44TH/ENGINEERS/USAF INTERPERTOR ARE COUNTED IN HHB
Spreadsheet: 826286d1681914414-need-help-with-multiple-formulas-on-a-single-column-nerd-aligw
Sheet: Sheet1

18 | 7
17 | 10
21 | 1
23 | 3
24 | 7
19 | 8
Spreadsheet: 543915d1508669774-sumifs-array-formula-question-forum-help-array
Sheet: Sheet1

Date of Birth | 2016-01-20 00:00:00 | 1995-01-05 00:00:00 | 2016-01-20 00:00:00 | 2014-05-10 00:00:00 | 2012-06-15 00:00:00 | 1999-06-08 00:00:00
Text Amt w. "." | 293.26 | . | 0.01 | 0.85 | 867.29 | 0.66
[NAME] |  | 0 | 0.01 | 0.85 | 867.29 | 0.66
[NAME]
Date of Birth | 2016-01-20 00:00:00
I am looking to do a single cell array formula using the sum ifs function.
At the moment, I am only able to do a multiple cell array formula in B3:G3 and then have to sumifs after.
I have other single cell array formulae which can do this but want to learn how to do it with sumifs specifically.
Could someone help me out with this?
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: GK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: jeff_dasovich__14211__proble~3
Sheet: Sheet1

Problem #2: McGan, Inc. Cash and Loan Projection
Issue: To analyze the expected end-of-the-month cash flow and loan requirements for the first 6 mos. Of 2000 from Dec. 1999
Goal:  To anticipate cash flow issues
 | 1999 | 1999 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
 | November | December | January | February | March | April | May | June | July
Revenue
Sales | 1500000 | 1600000 | 1900000 | 1800000 | 2000000 | 2250000 | 2000000 | 2500000 | 2700000
Receipts (1)
Additional cash from loan? (4)
Additional cash from bank? (3)
Total revenue
Expenses
Fixed cost | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000
Taxes due |  |  |  |  | 150000 |  |  | 50000
Dividends due |  |  |  |  |  |  |  | 50000
Material and labor costs (2) |  |  |  |  |  |  |  |  | 0
Loan expense
Total expenses
Cash balance |  |  |  |  | Q1 |  |  | Q2
On hand at end | 0 | 250000
Cash - (loan payback)
Loan |  |  |  |  |  | Q5 |  | Q6
Loan amount (4) | 0 | 0
Loan payback | n/a
 | Q7&Q8
 | [NAME]
Notes to Spreadsheet
(1) Formula for Receipts
0.2 | sales 2 months ago
0.6 | sales previous month
0.2 | sales from current month
(2) Formula for Material and Labor costs
0.75 | of product sales for succeeding month
(3) Formula for payment to bank
0.005 | If cash balance positive, bank pays [NAME] this amount beg of next month, if cash balance negative, McGan pays bank this amount
 | at beg of next month.
(4) [NAME] for loan required
250000 | If cash balance >250,000 then no loan, if less, then loan req'd
 | Loan paid back in next month at interest rate of 1%
Answers to Questions
(1) What is the mean and standard deviation of March's ending cash balance?
 | Mean = -$188,277.12, Standard Deviation = $108,366.61
(2) What is the probability that June's ending cash balance will be greater than or equal to $300,000?
 | 1.4%?  Seems weird
(3) What is the mean and standard deviation of the number of months in which McGan will take out a one month loan?
 | Not sure how to figure
(4) What is the probability that the number of months in which McGan will take out a one-month loan at the end of the month is greater than or equal to
3 months?
 | Related to #3, not sure how to figure
(5) What is the probability that, at the end of April, McGan will take out a one-month loan?
 | 0%?  Seems weird
(6) What dollar amount will the loan taken out at the end of June be less than or equal to 88% of the time?
 | 395295.51
(7) What is the mean and standard deviation of the dollar value of the maximum one-month loan McGan will need to take out during the six-month period?
 | Mean = $455,812.78, Standard Deviation = $90,680.15
(8)  What is the probability that the dollar value of the maximum one-month loan McGan will need to take out during the six-month period is greater than
or equal to $250,000?
 | 0.998
Spreadsheet: 801388d1666184674-comment-based-on-criteria-exercise_
Sheet: Sheet1

Part | Component | expected result
55135100007000 | H116658000 | basic
55135100007000 | H117616001 | basic
55135100007000 | H159490000 | basic
55135100007000 | H172135000 | basic
55135100007000 | H172141000 | basic
55135100007000 | H500046000 | basic
55135100007000 | H740834000 | basic
55135100007000 | H740838000 | basic
55135100007000 | H740932000 | basic
55135100007000 | H742202000 | basic
55135100007000 | H742203000 | basic
55135100007000 | K109870001 | basic
55135100028000 | H103067001 | basic
55135100028000 | H103077000 | basic
55135100028000 | H104919001 | basic
55135100028000 | H116658000 | basic
55135100028000 | H192163000 | basic
55135100028000 | H741442000 | basic
55135100028000 | H741557000 | basic
55135109729000 | 5120850000 | complex
55135109729000 | H102990000 | complex
55135109729000 | H103090000 | complex
55135109729000 | H116292000 | complex
55135109729000 | H500046000 | complex
55135109729000 | H740604000 | complex
55135109729000 | H740605000 | complex
55135109729000 | H740939000 | complex
55135109729000 | H742123000 | complex
55135109729000 | K109870001 | complex
55135109729000 | K116920001 | complex