tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 800198d1665534089-count-and-display-duplicates-in-an-array-display_duplicates-tms-ipad
Sheet: display_duplicates (4)

COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  |  | (case-sensitive)
array: | =A8:A30 |  | =A8:A1280
formula: |  |  | =LET(col, $A:$A, rng, $A$8:$A$1280, TEXTJOIN(", ", TRUE, UNIQUE(BYROW(rng, LAMBDA(rw, LET(a, INDEX(col, [NAME])), sp, SUMPRODUCT(- -EXACT(rng, a)),  IF(a="", "", IF(sp=1,"", sp &" " & a)))))))) |  | =LET(col, $A:$A, rng, $A$8:$A$1280, TEXTJOIN(", ", TRUE, UNIQUE(BYROW(rng, LAMBDA(rw, LET(a, INDEX(col, [NAME])), sp, SUMPRODUCT(- -EXACT(rng, a)),  IF(a="", "", IF(sp=1,"", sp &" " & a))))))))
expected result: | 2 A, 3 B, 2 b |  |  |  | =LET(rng, $A$8:$A$1280, [NAME], COUNTIF(rng, rng), [NAME](", ",TRUE,UNIQUE(IF(ci<2, "", ci & " " & rng))))
 |  |  |  |  | =LET(t,FILTER($A$8:$A$1000,$A$8:$A$1000<>""),z,MAKEARRAY(ROWS(t),1,LAMBDA(r,c,SUMPRODUCT(--EXACT(INDEX(t,r),t)))),ROWS(FILTER(t,z>1)))
grade | Count | Column1
A
B |  |  |  |  | B | 224 | B
C |  |  |  |  | C | 45 | C
D |  |  |  |  | D | 45 | D
E |  |  |  |  | E | 45 | E
a |  |  |  |  | a | 90 | a
B |  |  |  |  | F | 45 | F
F |  |  |  |  | z | 46 | z
z |  |  |  |  | b | 224 | b
b |  |  |  |  | G | 45 | G
B |  |  |  |  | 1 | 1 | 1
G |  |  |  |  | xx | 1 | xx
1 |  |  |  |  | 2 | 1 | 2
xx |  |  |  |  | H | 45 | H
2 |  |  |  |  | I | 45 | I
H |  |  |  |  | 3 | 1 | 3
I |  |  |  |  | x | 1 | x
3 |  |  |  |  | 4 | 1 | 4
x |  |  |  |  | T | 45 | T
4 |  |  |  |  | R | 45 | R
T |  |  |  |  | Z | 46 | Z
R |  |  |  |  | 5 | 1 | 5
Z |  |  |  |  | 6 | 1 | 6
5 |  |  |  |  | 7 | 1 | 7
6 |  |  |  |  | 8 | 1 | 8
7 |  |  |  |  | 9 | 1 | 9
8 |  |  |  |  | 0 | 0 | 0
9
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
Spreadsheet: 740835d1626616091-excel-formula-for-pay-back-period-paybak-period
Sheet: Sheet1

I'm kindly for excel formula to calculate pay back period
 | Year 0 | Year 1 | Year 2 | Year 3 | Year 4
Cash Investment | 50000
Cash flows |  | 20000 | 10000 | 30000 | 5000
Spreadsheet: 876700d1723435819-conditional-formatting-based-on-different-days-and-time-on-multiple-applications-appl_test
Sheet: Daily Online Report

 | Systems | Time (hrs) | Status | Note | Systems (SLA) Targets |  | Mon to Thursday |  | Friday
 | Application 1 | 00:00:00 |  |  |  |  | 08:00:00 | 19:30:00 | 08:00:00 | 19:30:00 | before 8:00am or equal to 8:00am = Green 8:00am until 19:30 is yellow after 19:30 is Red
 | Application 2 | 07:59:00 |  |  |  |  | 08:00:00 | 21:00:00 | 08:00:00 | 21:00:00
 | Application 3 | 08:00:00 |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 4 | 08:01:00 |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 5 | 19:29:00 |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 6 | 19:30:00 |  |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 7 | 19:31:00 |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 8 | 20:00:00 |  |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 9 | 1900-01-01 00:00:00 |  |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 10 |  |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 11 |  |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 12 |  |  |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 13
 | Application 14
Spreadsheet: 31922d1227933169-tidying-simplifying-code-sample-average
Sheet: Average Table

Year | Month | AMD | IMATION | LEXMARK | Average
2008 | May | 6.934761904761904 | 25.23571428571429 | 35.02904761904762 | 22.39984126984127
2008 | June | 6.995714285714284 | 25.64761904761904 | 35.24190476190476 | 22.62841269841269 |  |  |  | Year | Month | AMD | IMATION | LEXMARK | Average
2008 | July | 4.81590909090909 | 20.56181818181818 | 33.18363636363636 | 19.52045454545454 |  |  |  | 2008 | May | 1.344921109164562 | 1.251823762929597 | 1.083860997360179 | 1.165966469166849
2008 | August | 5.426666666666668 | 20.55904761904762 | 35.87428571428571 | 20.62 |  |  |  |  | June | 1.356742155787721 | 1.272256399120447 | 1.09044717571311 | 1.177864170508272
2008 | September | 5.436666666666666 | 22.20190476190476 | 33.51238095238097 | 20.3836507936508 |  |  |  |  | July | 0.9339928154899689 | 1.01997400658514 | 1.026760692904795 | 1.01608735475905
2008 | October | 3.85304347826087 | 14.85695652173913 | 28.1795652173913 | 15.62985507246377 |  |  |  |  | August | 1.052442557168121 | 1.019836572143078 | 1.110014166435019 | 1.073321382263116
2008 | November | 2.631052631578947 | 12.05105263157895 | 25.21052631578947 | 13.29754385964912 |  |  |  |  | September | 1.054381947629733 | 1.101330901459186 | 1.036932634823072 | 1.061018828584381
2008 | December |  |  |  |  |  |  |  |  | October | 0.7472555769915519 | 0.7369829523412075 | 0.8719258369185532 | 0.8135721460208046
2009 | January |  |  |  |  |  |  |  |  | November | 0.5102638377683406 | 0.5977954054213444 | 0.7800584958452699 | 0.6921696486975272
Year | Month | AMD | IMATION | LEXMARK | Average
2008 | May | 1.344921109164562 | 1.251823762929597 | 1.083860997360179 | 1.165966469166849
2008 | June | 1.356742155787721 | 1.272256399120447 | 1.09044717571311 | 1.177864170508272
2008 | July | 0.9339928154899689 | 1.01997400658514 | 1.026760692904795 | 1.01608735475905
2008 | August | 1.052442557168121 | 1.019836572143078 | 1.110014166435019 | 1.073321382263116
2008 | September | 1.054381947629733 | 1.101330901459186 | 1.036932634823072 | 1.061018828584381
2008 | October | 0.7472555769915519 | 0.7369829523412075 | 0.8719258369185532 | 0.8135721460208046
2008 | November | 0.5102638377683406 | 0.5977954054213444 | 0.7800584958452699 | 0.6921696486975272
2008 | December | 0 | 0 | 0 | 0
2009 | January | 0 | 0 | 0 | 0
Spreadsheet: 152009d1335209211-3-way-lookup-question-3lookups
Sheet: Sheet1

 | Select lookup1 |  | A
 | Select lookup2 |  | Y
 | Select Quarter |  | 1Q2011
 | Answer: |  |  | <--- this should be 52 (for A, Y, 1Q2011) |  |  |  |  |  |  |  |  |  |  | A | X | 1Q2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Y | 2Q2010
 | lookup1 | lookup2 | 1Q2010 | 2Q2010 | 3Q2010 | 4Q2010 | 1Q2011 | 2Q2011 | 3Q2011 | 4Q2011 | 1Q2012 |  |  |  | C | Z | 3Q2010
 | A | X | 1234 | 324 | 56 | 1234 | 324 | 56 | 1234 | 324 | 56 |  |  |  | D |  | 4Q2010
 | A | Y | 234 | 52 | 54 | 234 | 52 | 54 | 234 | 52 | 54 |  |  |  |  |  | 1Q2011
 | A | Z | 12 | 436 | 567 | 12 | 436 | 567 | 12 | 436 | 567 |  |  |  |  |  | 2Q2011
 | B | X | 53 | 4 | 57 | 53 | 4 | 57 | 53 | 4 | 57 |  |  |  |  |  | 3Q2011
 | B | Y | 12 | 463 | 5 | 12 | 463 | 5 | 12 | 463 | 5 |  |  |  |  |  | 4Q2011
 | B | Z | 43 | 8 | 255 | 43 | 8 | 255 | 43 | 8 | 255 |  |  |  |  |  | 1Q2012
 | C | X | 5 | 7 | 7 | 5 | 7 | 7 | 5 | 7 | 7
 | C | Y | 43 | 4 | 235 | 43 | 4 | 235 | 43 | 4 | 235
 | C | Z | 234 | 79 | 8 | 234 | 79 | 8 | 234 | 79 | 8
 | D | X | 6 | 4 | 672 | 6 | 4 | 672 | 6 | 4 | 672
 | D | Y | 573 | 78 | 5 | 573 | 78 | 5 | 573 | 78 | 5
 | D | Z | 1 | 478 | 5 | 1 | 478 | 5 | 1 | 478 | 5
Spreadsheet: 148163d1333194244-drop-down-boxes-with-if-statement-and-vlookup-pricebook
Sheet: Comparison 

 |  |  |  |  |  |  |  |  |  |  |  | Select | Comparison Table
 |  |  |  |  |  |  |  |  |  |  |  | Framework
 |  |  |  |  |  |  |  |  |  |  |  | Blank
 |  |  |  |  |  |  |  |  |  |  |  | GH | Instructions Click Here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VLOOKUP($A5,$A$9:$F$48,MATCH(B4,$A$8:$F$8,0),FALSE)
Blank | AB | CD | EF | Framework | GH | IND | N&E | JI | JK | TP | XS | JI
 | 0.15 | 0.12 | 0.12 | 0 | 0.12 | 0.1 | 0.15 | 0.15 | 0.15 | 0.12 | 0.15
 | 0 | 0.06 | 0.03 | 0 | 0.04 | 0.03 | 0 | 0.06 | 0 | 0.06 | 0.05 | Required Retail Margin % | 16
 |  |  |  |  |  |  |  |  |  |  | INPUT CODE | Bemodern Code | Description | List Price | Framework Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | [NAME] | Subtotal | Min. Contract Support | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | GH Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | GH Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate
 |  |  |  |  |  |  |  |  |  |  | 32360 | 32360 | Product 1234 | 318.24 | 0 | 0 | 0 | 400 | 127.296 | 0.68176 | 0 | 400 | 0.68176 | 476.1904761904762 | 0 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0.04 | 0 | #N/A | 0 | 318.24 | 0.12 | 280.0512 | 107.5 | 400 | 127.296 | 0 | 0 | 400 | 0 | 476.1904761904762 | 318.24 | 0.15 | 270.504 | 107.5 | 163.004 | 127.296 | 0.219062108905303 | 0.06 | 153.22376 | 0.1692150094737266 | 194.052380952381
 |  |  |  |  |  |  |  |  |  |  | 32379 | 32379 | Product 1235 | 318.24 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0.04 | 0 | #N/A | 0 | 318.24 | 0.12 | 280.0512 | 107.5 | 410 | 127.296 | 0 | 0 | 410 | 0 | 488.0952380952381 | 318.24 | 0.15 | 270.504 | 107.5 | 163.004 | 127.296 | 0.219062108905303 | 0.06 | 153.22376 | 0.1692150094737266 | 194.052380952381
 |  |  |  |  |  |  |  |  |  |  | 32395 | 32395 | Product 1236 | 318.24 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0.04 | 0 | #N/A | 0 | 318.24 | 0.12 | 280.0512 | 107.5 | 425 | 127.296 | 0 | 0 | 425 | 0 | 505.9523809523809 | 318.24 | 0.15 | 270.504 | 107.5 | 163.004 | 127.296 | 0.219062108905303 | 0.06 | 153.22376 | 0.1692150094737266 | 194.052380952381
 |  |  |  |  |  |  |  |  |  |  | 51322 | 51322 | Product 1237 | 318.24 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 127.296 | #N/A | 0.04 | 0 | #N/A | 0 | 318.24 | 0.12 | 280.0512 | 82.42 | 430 | 127.296 | 0 | 0 | 430 | 0 | 511.9047619047619 | 318.24 | 0.15 | 270.504 | 82.42 | 188.084 | 127.296 | 0.3231960188001106 | 0.06 | 176.79896 | 0.2799957646809687 | 223.9095238095238
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-F-0003

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-F-0003 |  | 04UF0 | 1F | 1 | 8 | 119305 | 2012-11-19 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 10257.82 | PAID | 5100215897 | 5000474238 | 2012-11-20 00:00:00 | 5000485162 | 2012-11-30 00:00:00 | 2500035026 | 2012-12-04 00:00:00 |  | 41036009100452
W912LP-13-F-0003 |  |  |  | 2 | 3 |  |  |  |  |  | PAID
W912LP-13-F-0003 |  |  |  | 3 | 6 |  |  |  |  |  | PAID
W912LP-13-F-0003 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 861168d1709124908-formula-to-sum-ranges-based-on-criteria-with-sum-range-moving-based-on-date-criteria-formula-query
Sheet: Sheet1

 | Opening Cash |  | Cash flow
 | 50000
 | Minimum Cash Balance
 | 5000
 | Week ending |  | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | 2023-10-01 00:00:00 | 2023-10-08 00:00:00 | 2023-10-15 00:00:00 | 2023-10-22 00:00:00 | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | Total
 | Cash balance at beginning of week
 | Cash Receipts
 | Fees
 | Reg Fees
 | Sales Ledger
 | Donations
 | Trips
 | Intercompany
 | Childcare
 | Commercial
 | Commem
 | Total Cash Receipts
 | Cash paid out
 | Payroll
 | Pension
 | Energy
 | Catering
 | Cleaning
 | Purchase Ledger
 | Capital Projects
 | IT
 | Phone
 | Council Tax
 | Total Cash Paid Out
 | Cash balance at end of week
Spreadsheet: 146356d1332140692-giving-any-text-value-transcripts-template-new
Sheet: Sheet1

成绩证明OFFICIAL TRANSCRIPT
姓名Name of Student:
中国辽宁省沈阳市浑南新区世纪路41号东北育才学校国际部 |  |  |  |  | 性别Sex:
110179 |  |  |  |  | 出生年月DOB:
 |  |  |  |  | 护照号码Passport #:
NE Yucai International division |  |  |  |  | 国籍Nationality:
No. 41 Shiji Road Hunnan New District |  |  |  |  | 入学日期Entry date:
Shenyang, Liaoning, CHINA 110179 |  |  |  |  | 离校日期Withdraw DT:
出勤率ACADEMIC HISTORY
日期/DATE/INSTITUTE | 年级LEVEL | 课程SUBJECT |  | 成绩GRADE | 学分CREDIT
成绩证明OFFICIAL TRANSCRIPT
姓名Name of Student:
中国辽宁省沈阳市浑南新区世纪路41号东北育才学校国际部 |  |  |  |  | 性别Sex:
110179 |  |  |  |  | 出生年月DOB:
 |  |  |  |  | 护照号码Passport #:
NE Yucai International division |  |  |  |  | 国籍Nationality:
No. 41 Shiji Road Hunnan New District |  |  |  |  | 入学日期Entry date:
Shenyang, Liaoning, CHINA 110179 |  |  |  |  | 离校日期Withdraw DT:
出勤率ACADEMIC HISTORY
日期/DATE/INSTITUTE | 年级LEVEL | 课程SUBJECT |  | 成绩GRADE | 学分CREDIT |  |  | 学分CREDIT
成绩证明OFFICIAL TRANSCRIPT
姓名Name of Student:
中国辽宁省沈阳市浑南新区世纪路41号东北育才学校国际部 |  |  |  |  | 性别Sex:
110179 |  |  |  |  | 出生年月DOB:
 |  |  |  |  | 护照号码Passport #:
NE Yucai International division |  |  |  |  | 国籍Nationality:
No. 41 Shiji Road Hunnan New District |  |  |  |  | 入学日期Entry date:
Shenyang, Liaoning, CHINA 110179 |  |  |  |  | 离校日期Withdraw DT:
出勤率ACADEMIC HISTORY
日期/DATE/INSTITUTE | 年级LEVEL | 课程SUBJECT |  | 成绩GRADE | 学分CREDIT |  |  | 学分CREDIT
 |  |  |  |  |  |  |  |  |  |  |  | Page 1 colum 1
 |  |  |  |  |  |  |  |  |  |  |  | page 1 colum 2
 |  |  |  |  |  |  |  |  |  |  |  | page 2 colum 1
成绩证明OFFICIAL TRANSCRIPT
姓名Name of Student:
中国辽宁省沈阳市浑南新区世纪路41号东北育才学校国际部 |  |  |  |  | 性别Sex:
110179 |  |  |  |  | 出生年月DOB:
 |  |  |  |  | 护照号码Passport #:
NE Yucai International division |  |  |  |  | 国籍Nationality:
No. 41 Shiji Road Hunnan New District |  |  |  |  | 入学日期Entry date:
Shenyang, Liaoning, CHINA 110179 |  |  |  |  | 离校日期Withdraw DT:
 | [NAME]
 | 现今AS OF | 总学分TOTAL CREDITS |  | 班级平均学分GPA CREDITS | 所有科目平均学分GPA | 班级排名CLASS RANK
 | 权威认证AUTHORIZATION
 | X
 | 职务TITLE |  |  | 日期DATE
Spreadsheet: 114378d1310125623-sales-in-each-period-between-start-and-end-dates-forecasting-profit-allocation-into-months-between-start-and-end-dates
Sheet: Sheet1

 |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 |  |  |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
 |  |  |  |  |  |  | 21 | 20 | 23 | 21 | 22 | 22 | 21 | 23 | 22 | 21 | 22 | 22
Start | End | Charge per day | Pay per day | Total working days | Total profit |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
2011-01-01 00:00:00 | 2011-09-15 00:00:00 | 500 | 375 | 184 | 23000
In this example, I am looking to allocate the £23k profit into each of the months by putting a forumla in each of the months cells to look at the dates, decide if the dates fall in that month and then multiply
the profit per day by the number of days working in that month - in the example a full month for all months until September when it only runs to 15th
Spreadsheet: richard_ring__31529__01292002 Mtg
Sheet: 01092002 MTG

New I-CAP System Calculation Meeting
Attendance for January 29, 2002
Name |  | Company
Last | First
Angeles | [NAME] | Amerada Hess Corporation
Binder | [NAME] | Keyspan Energy Supply
[NAME] | [NAME] | ConEdison Solutions
Carcaterra | [NAME] | KeySpan Energy Supply
[NAME] | Stephen | SmartEnergy
Cross | [NAME] | KeySpan Energy Supply
DeGraffenried | [NAME] | New York Power Authority
Dembia | [NAME] | Keyspan Energy Supply
[NAME] | Mark | Keyspan Energy Supply
[NAME] | [NAME] | SmartEnergy
LaGuardia | [NAME] | Amerada Hess Corporation
[NAME] | [NAME] | ConEdison Energy
[NAME] | [NAME] | Robison Energy
[NAME] | [NAME] | 1st Rochdale Cooperative
Sadowski | [NAME] | Strategic Energy, Inc.
[NAME] | [NAME] | ConEdison Solutions
Smith III | [NAME] | New York Power Authority
Stabile | [NAME] | ACN Energy Inc.
Sung | [NAME] | KeySpan Energy Supply
Swider | [NAME] | Strategic Energy, Inc.
Van Ryn | [NAME] | ConEdison Solutions
Walsh | [NAME] | ConEdison Solutions
Yamat | Bienvenido | AES NewEnergy, Inc.
Spreadsheet: 84941d1285027942-multi-input-lookup-book3
Sheet: Sheet2

Model | componentDesc | component
5SME39CQLB001 | ROTOR ASSEMBLY | ROTOR-C351-P03
5SME39CQLB001 | SHAFT/RTR CORE ASSM | 24B202349-G02
5SME39CQLB001 | RTR CORE/MAGNET ASSM | [NAME]
5SME39CQLB001 | ROTOR CORE | 24B202345-P02
5SME39CQLB001 | ROTOR LAMINATION, 10 POLE | 24A103277-P1
5SME39CQLB001 | LAMINATION STEEL | B3D7B3-031THK
5SME39CQLB001 | ROTOR LAMINATION, 10 POLE | 24A103277-P2
5SME39CQLB001 | LAMINATION STEEL | B3D7B3-031THK
5SME39CQLB001 | PM MAGNET | 24A103280-P02
5SME39CQLB001 | [NAME] | 24B202351-P03
5SME39CQLB001 | SHAFT MATERIAL | B50FM72A1-507DIA
5SME39CQLB001 | RETAINING RING | 24A100617AA-P1
5SME39CQLB001 | BALL BEARING | 24A103035-P1
5SME39CQLB001 | STATOR-VARNISHED | STATOR-CEAKFN01
Spreadsheet: 173911d1344853079-sum-if-0a32trial-f-
Sheet: Sheet1

 |  |  |  | Helper Columns |  |  |  | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | JAN |  |  | Fruits
 |  |  |  | You can hide these |  |  |  | Apple | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FEB |  |  | Apple
 |  |  |  |  |  |  |  | Orange | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | MARTC |  |  | Orange
DATE | Commodity | PRIZE |  |  |  |  |  | Grapes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | APR |  |  | Grapes
2012-06-01 00:00:00 | Apple | 2 |  |  |  |  | Annual Epenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | MAY |  |  | Total Expenses
2012-06-03 00:00:00 | Orange | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | JUN |  |  | [NAME]
2012-07-08 00:00:00 | Grapes | 2 |  |  |  |  | Month | Commodity | Expenses | Above Budget | Below Budget | South Afircan Products |  |  |  |  |  |  |  |  |  |  | 7 | JUL |  |  | Kiwi
2012-07-10 00:00:00 | Water Melon | 5 |  |  |  |  |  | Total Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | AUG |  |  | Total expenses
2012-07-16 00:00:00 | [NAME] | 5 |  |  |  |  |  | Total Expenses |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 9 | SEPT
2012-07-16 00:00:00 | Kiwi | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | OKT
2012-07-17 00:00:00 | Apple | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | NOV
2012-07-17 00:00:00 | Orange | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | DEC
2012-07-17 00:00:00 | Apple | 3
2012-07-17 00:00:00 | Orange | 5
2012-07-17 00:00:00 | Grapes | 2
2012-07-17 00:00:00 | Water Melon | 2
2012-07-21 00:00:00 | [NAME] | 4.8
2012-07-21 00:00:00 | Kiwi | 4.8
2012-07-22 00:00:00 | Apple | 10 |  |  |  |  |  |  | 2 |  | 8
2012-07-22 00:00:00 | Orange.in | 1 |  |  |  |  |  |  | 21 | 11
2012-07-22 00:00:00 | Orange.uk | 2
2012-07-22 00:00:00 | Orange.bl | 3
2012-07-22 00:00:00 | Orange.South Africa | 2
2012-07-22 00:00:00 | Apple.South Africa | 2
2012-07-22 00:00:00 | Peach.South Africa | 6
2012-07-22 00:00:00 | Dates | 13
2012-07-22 00:00:00 | Cashew | 15
Spreadsheet: harry_arora__12154__Plan_IncomeSheets_Presto
Sheet: Southeast Power Trading

Income Statement - ($000s)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ | 0 | $ | 0 | $
Trading |  |  | 0 |  | 0
FV-Investments |  |  | 0 |  | 0
Accrual |  |  | 0 |  | 0
Operating Expenses |  |  | 0 |  | 0
Other |  |  | 0 |  | 0
Total Margin |  | $ |  | $ |  | $
Capital Charge |  |  | 0 |  | 0
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits |  |  | 916.925 |  |  |  |  |  |  | 1000
Employee Expense
Travel/Entertainment
Consulting |  |  |  |  |  |  |  |  |  | -1
Office
Controllable Infrastructure
System Development |  |  | 0
Insurance |  |  | 0
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal |  |  | 0 |  | 58
Outside Tax |  |  | 0
Depreciation & Amortization |  |  | 0
Total Direct Expenses |  | $ |  | $ |  | $
Other Allocated Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 0
Director |  |  | 0
Manager |  |  | 3 |  | 4
Analyst and Associates |  |  | 4
Support Departments |  |  | 6
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Headcount Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 31651d1227587966-conditional-linking-between-multiple-sheets-special_contest3
Sheet: Judges

SPECIAL CONTEST - Judges
Group | First Name | Last Name | website | City | Notes
judge | winner | Vader | www.youtube.com | California | will give $15K,
judge, sponsor | winner | 0 | 0 | 0 | 0
media, judge | winner | 0 | 0 | 0 | 0
Spreadsheet: 9210ceec-eb70-4af5-b3bd-10238ad284a0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHSPL | Test | FHSPL | [NAME] | [NAME] | Enzyme Immunoassay (EIA) |  |  |  | 1 | mL | Draw blood in a lavender-top (EDTA) tube(s). Spin down and send 1 mL of EDTA plasma frozen in plastic vial. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | <1.0 ng/mL  Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Monday, Tuesday, Thursday | 2 days | 4 - 11 days | 1 | 83088 |  |  |  |  | Viracor-IBT Laboratories
FHSPL | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 14 days
FHSPL | Result | FHSPL | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process