tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864054d1711387684-help-with-consolidated-sheet-pulling-data-from-daily-sheets-and-formula-date-incrementing-sequence-dates-aligw
Sheet: Sheet1

2024
April |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[02-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[03-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[04-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[05-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[06-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[07-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[08-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[09-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[10-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[11-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[12-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[13-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[14-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[15-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[16-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[17-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[18-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[19-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[20-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[21-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[22-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[23-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[24-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[25-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[26-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[27-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[28-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[29-04-2024.xlsx]00'!$D$9
 |  |  |  | 'U:\Bookkeeper\DTS\2024\APRIL 2024\[30-04-2024.xlsx]00'!$D$9
Spreadsheet: 37100d1235056769-insert-new-row-chart-doesnt-count-addcol-chartnocount
Sheet: Sum-Nov08

Range | C1 | C2 | [NAME] | HC | S1 | S2 | S3
0 - 4.99 |  |  | 1 | 10 | 34
5 - 5.99 |  |  | 2 | 0 | 40
6 - 6.99 |  |  | 7 | 0 | 37
7 - 7.99 |  |  | 8 | 1 | 48
8 - 8.99 |  |  | 4 | 0 | 44
9 - 10 |  |  | 2 | 0 | 41
Spreadsheet: 29034d1223667634-sliding-scale-calculation-is-this-calculation-possible-hlookup
Sheet: Sheet1

GROR | 0 | 0.05 | 0.08 | 0.11 | 0.14 | 0.18
payout % | 0.1 | 0.1 | 0.146 | 0.192 | 0.238 | 0.3
GROR | Payout %
0 | 0.1
[NAME] in B5 =IF(ISNUMBER(A5),HLOOKUP(A5,$B$1:$G$2,2),"NA")
 | Slope = | 1.537743190661478
 | Intercept | 0.02297276264591439
 | y = mx + b
GROR | Payout %
0.18 | 0.3
Spreadsheet: benjamin_rogers__1009__Valuation Excercise
Sheet: Sheet1

cin
Share Price | 32
EPS | 2.64
DPS | 1.8
P/E (Dec per year) |  | 1
Dividend Yield
Earnings Growth | 0.12
Purchase
Dividend
Sales Price
 | IRR |  |  | Net CF
CSCO
Share Price | 19.5
EPS | 0.41
DPS | 0
P/E (Dec per year) |  | 6
Dividend Yield
Earnings Growth | 0.25
Purchase
Dividend
Sales Price
 | IRR |  |  | Net CF
Spreadsheet: 879965d1727556543-extract-a-list-of-currency-and-amounts-from-a-matrix-with-a-spill-formula-lambda-cash-flow-forecast-1-1-
Sheet: Forecast 260924

 |  |  |  | 1 | 1 | 5 | 15
Bank's region | Bank | Statement accounts | Currency |  |  |  |  | Conversion | I/C + Deposits
IN | JPM | 50078 | USD
IN | JPM | 50078 | USD
IN | JPM | 50078 | EUR |  | 511740
IN | JPM | 50078 | GBP |  | 73709
IN | JPM | 50078 | AUD
GB | HSBC | 200987 | USD | 7120363
GB | HSBC | 200987 | USD
GB | HSBC | 200987 | GBP
GB | HSBC | 200987 | EUR
GB | HSBC | 200987 | AUD
US | CITIBANK | 7433 | USD
US | CITIBANK | 90807 | NIS
US | CITIBANK | 801.7683883749727 | USD |  | 7003766
US | CITIBANK | 278.3189847924104 | EUR
US | CITIBANK | 175.7076287609073 | GBP |  | 558
US | CITIBANK | 673.7614867316984 | AUD
UK | CITIBANK | 744.6707467759913 | USD
UK | CITIBANK | 726.3982087969856 | GBP
UK | CITIBANK | 675.4697063208389 | AUD
UK | CITIBANK | 829.4605501364579 | EUR
Spreadsheet: 113790d1309644205-macro-to-copy-toggle-button-and-behaviour-start-again_home30_6
Sheet: tax_calculation_sheet_10_11yr__

WORKSHEET FOR CARERS |  |  | Pg 1 | WORKSHEET FOR CARERS |  |  |  | Pg 2
to calculate taxable income to 31/3/10 |  |  |  | to calculate taxable income to 31/3/10
A: Gross Income from Re-imbursement |  |  |  | DEDUCTIONS
 | April | 267.05 |  | Hours      B | 55.25 | Times    $3.15     = |  | 174.0375
 | May | 0
 | June | 0 |  |  |  |  | Round to | 11080 | C
 | July | 0
 | August | 0 |  | [NAME] |  |  |  | 307
 | September | 0
 | October | 0 |  | Accomodation – Renting
 | November | 0 |  | yearly Rent
 | December | 0 |  |  |  | 5512
 | January | 0
 | February | 0 |  |  | sub total | 5512
 | March | 0 |  |  | X 0.50  = | 2756
 |  |  |  |  |  |  |  | 0
 | TOTAL | 267.05 | A |  | X 0.3333 = | 918.5748
 |  |  |  | TOTAL | rounded up | 918 | E
B: Hours
 | April | 55.25 |  | GROSS INCOME |  | 267.05 | A
 | May | 0 |  |  | MINUS | 11080 | C
 | June | 0 |  |  | = | -10812.95 | Sub Total
 | July | 0
 | August | 0 |  |  | MINUS | 307 | D
 | September | 0 |  |  | = | -11119.95 | Sub total
 | October | 0
 | November | 0 |  | Less Accomodation fixed cost |  | 918 | E
 | December | 0
 | January | 0 |  | TAXABLE INCOME |  | -12037.95 | F
 | February | 0
 | March | 0
 | TOTAL | 55.25 | B
Spreadsheet: 689869d1596714980-library-users-excel-formula-for-making-a-list-and-count-excel_2020
Sheet: A

DATE | SURNAME NAME | PUBLICATION | SUBSCRIBED
2020-01-03 00:00:00 | Surname Name | J Palliat Care. 2006 Spring;22(1):12-7 | yes
2020-01-03 00:00:00 | Surname Name | J Palliat Med. 2012 Aug;15(8):854-62
2020-01-03 00:00:00 | Surname Name | J Palliat Care. 2011 Autumn;27(3):224-8. | yes
2020-01-09 00:00:00 | [NAME] | [NAME]. 2019;7(4):644–657
2020-01-09 00:00:00 | [NAME] | [NAME]. 2019 Jun;32(6):741-754. | yes
2020-01-09 00:00:00 | [NAME] | [NAME]. 2002 Sep;27(3):185-8 | yes
2020-01-09 00:00:00 | [NAME] | Cancer. 1997 Aug 25;81(4):212-9. | yes
2020-01-09 00:00:00 | Surnameee Nameee | Priporočila obravnave pacientov v patronažnem varstvu za DMS, 2016
2020-01-09 00:00:00 | Surnameee Nameee | [NAME]; 40(4): 247-52 | yes
2020-01-10 00:00:00 | [NAME] | [NAME] 2019 Nov 17 [Online ahead of print]
2020-01-15 00:00:00 | Surnamaa Namaa | Eur Urol. 2011 Dec;60(6):1133-9
2020-01-15 00:00:00 | Surnamaa Namaa | [NAME]. 2012 Apr 18;307(15):1611-20
2020-01-15 00:00:00 | [NAME] | Eur Urol. 2015 Jun;67(6):1009-1016
2020-01-15 00:00:00 | Surnamaa Namaa | J Nucl Med. 2017 Dec;58(12):1972-1976 | yes
2020-01-15 00:00:00 | Surnamaa Namaa | J Nucl Med. 2018 Jan;59(1):82-88 | yes
2020-01-17 00:00:00 | [NAME] | N Engl J Med. 2012 [NAME] | yes
2020-01-20 00:00:00 | [NAME] | Int J Pharmaceutics 2020; 574:  1189392
2020-01-20 00:00:00 | [NAME] | [NAME]. 2017;20(7):379–387
2020-01-20 00:00:00 | [NAME] | Science. 2018 Mar 23;359(6382):1361-1365
2020-01-20 00:00:00 | [NAME] | Cancers (Basel). 2020 Jan 3;12(1). pii: E125
2020-01-20 00:00:00 | [NAME] | [NAME]. 2019 Aug;20(8):e443-e451 | yes
2020-01-21 00:00:00 | [NAME] | [NAME]. 2020 Jan | yes
2020-01-24 00:00:00 | [NAME] | [NAME] for Adverse Events. Version 4.0, 2010
2020-01-24 00:00:00 | [NAME] | Eur [NAME]. 2000;10(11):1716–1721.
2020-01-27 00:00:00 | Surname Name | Eur J Cancer 2015; 51(15): 2242-53 | yes
2020-01-27 00:00:00 | Surname Name | Eur J Cancer 2015; 51(15): 2101-2103 | yes
2020-01-27 00:00:00 | Surname Name | Eur J Cancer 2015; 51(15): 2104-119 | yes
2020-01-27 00:00:00 | Surname Name | [NAME]. 2017; 317(23):2402-2416
2020-01-27 00:00:00 | Surnamaa Namaa | J Nurs Adm. 2019;49(12):583–585.
2020-01-27 00:00:00 | Surnamaa Namaa | J Nurs Adm. 2017;47(5):278–288.
2020-01-27 00:00:00 | [NAME] | Oncol Nurs Forum. 2003;30(2):283–290.
2020-01-27 00:00:00 | [NAME] | Med Care. 1994;32(8):771–787
2020-01-28 00:00:00 | [NAME] | [NAME]. 2011;4(2):95–105
2020-01-28 00:00:00 | [NAME] | J Med Internet Res. 2019;21(4):e11387
Spreadsheet: 858691d1707290715-how-to-lookup-values-and-get-results-in-specific-formats-test-43-ans
Sheet: Sheet1

PURCHASE DATA
EntryNo | EntryDate | SupplierAlias | Supplier | Location | TNo | RefNo | RefDate |  | FORMULA
WAMCP0001 | 24-01-2024 |  | ANNA ELECTRONICS CORPORATION | SPAIN | 24AKYEE1005F1ZD | 181/2023-24 | 22-01-2024
WAAAMCP0002 | 30-01-2024 |  | EUREKA FORBES LIMITED | USA | 24AMBCF3059R1Q3 | I24240078093 | 23-01-2024
WAMOP0103 | 03-02-2024 |  | INFINITI RETAIL LLC | USA | 20PPCCV1716H1ZK | SOA588357509144 | 22-01-2024
WJPI0005 | 03-02-2024 |  | VERNON INC | INDIA | 19WACCV3726H1ZO | A-1073 | 22-01-2024
WJPR0022 | 03-02-2024 |  | PREETY G RETAIL | INDIA | 19UAACCY2226H1ZI | S04/23-24/11 | 22-01-2024
Data changed for verification.
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19999 | -19885
2 | -20165 | -19885
3 | -20034 | -19885
4 | -19990 | -19952
5 | -20010 | -19952
6 | -19999 | -20000
7 | -20968 | -20000
8 | -20315 | -20000
9 | -20002 | -19153
10 | -19998 | -19490
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 176934
2001-12-10 00:00:00
CBS Dollars
 |  |  | 177562.79
Spreadsheet: 141422d1329254235-countifs-and-or-fuction-irv-test-system
Sheet: Tabulaition

 |  |  |  |  |  | Candidates | 1st Round | 2nd Round + | Round 2 Total | 3rd Round + | Round 3 3rd choice | Round 3 Total | 4th Round + | Round 4 3rd choice | Round 4 Total
 |  |  |  |  |  | a
 |  |  |  |  |  | b
 |  |  |  |  |  | c
 |  |  |  |  |  | d
 |  |  |  |  |  | e
 |  |  |  |  |  | f
 |  |  |  |  |  | g
 |  |  |  |  |  | h
 |  |  |  |  |  | i
 |  |  |  |  |  | j
 |  |  |  |  |  | k
 |  |  |  |  |  | l
 |  |  |  |  |  | m
 |  |  |  |  |  | n
 |  |  |  |  |  | o
 |  |  |  |  |  | p
 |  |  |  |  |  | q
 |  |  |  |  |  | r
 |  |  |  |  |  | s
 |  |  |  |  |  | t
 |  |  |  |  |  | u
 |  |  |  |  |  | v
 |  |  |  |  |  | w
 |  |  |  |  |  | x
 |  |  |  |  |  | y
 |  |  |  |  |  | z
 |  |  |  |  |  | Total Cast
 |  |  |  |  |  | Lowest
 |  |  |  |  |  | Next eliminated candidate
 |  |  |  |  |  | Majority?
Spreadsheet: 168450d1342461107-build-unique-list-from-data-worksheet-that-updates-based-on-data-selection-example-incl-excelproblem
Sheet: Menu

Make a selection on the CHOICE field to update data:
Item ID | Item | Description | Choice | Cost | Opt1 | Opt2 | Opt3
1 | Hamburger | A basic hamburger has 2 pieces of breat and a meat patty | with cheese | 1 | opt1 | opt88 | opt90
2 | Pizza | A basic pizza has crust sauce and cheese | with pepperoni | 5 | opt4 | opt20 | opt30
Spreadsheet: 788475d1658494356-extracting-top-values-with-indexing-function-ranking
Sheet: Sheet1

Name | Value
Name1 | 1 |  | Rank | Value | Name
[NAME] | 2 |  | 1 | 17 | Name17
Name3 | 3 |  | 2 | 16 | [NAME]
Name4 | 4 |  | 3 | 15 | Name15
Name5 | 5 |  | 4 | 14 | Name14
Name6 | 6 |  | 5 | 13 | Name13
Name7 | 7
Name8 | 8
Name9 | 9
Name10 | 10
Name11 | 11
Name12 | 12
Name13 | 13
Name14 | 14
Name15 | 15
[NAME] | 16
Name17 | 17
Spreadsheet: 76865d1277346581-stats-help-excel-project-2-1-
Sheet: Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.7884446448142449
R Square | 0.6216449579362608
Adjusted R Square | 0.6076318082301965
Standard Error | 10.42312494460386
Observations | 29
RESIDUAL OUTPUT |  |  |  |  | PROBABILITY OUTPUT
Observation | Predicted 41 | Residuals | Standard Residuals |  | Percentile | 41
1 | 52.42197494117168 | 3.578025058828324 | 0.3495767718984477 |  | 1.724137931034483 | 24
2 | 56.15584619414625 | 6.84415380585375 | 0.6686809495432394 |  | 5.172413793103448 | 26
3 | 62.44447146231395 | 5.555528537686051 | 0.5427809197708516 |  | 8.620689655172413 | 27
4 | 58.71060020933938 | 10.28939979066062 | 1.005285067726599 |  | 12.06896551724138 | 28
5 | 46.52638875226445 | 18.47361124773555 | 1.804891044392237 |  | 15.51724137931034 | 28
6 | 43.18555657855036 | 17.81444342144964 | 1.740489661768102 |  | 18.96551724137931 | 32
7 | 35.52129453297097 | 11.47870546702903 | 1.121481470018291 |  | 22.41379310344828 | 32
8 | 31.7874232799964 | 0.2125767200036002 | 0.0207689667729586 |  | 25.86206896551724 | 32
9 | 29.23266926480327 | -5.232669264803267 | -0.5112372328105365 |  | 29.31034482758621 | 33
10 | 35.12825545371049 | -7.128255453710487 | -0.6964379762034467 |  | 32.75862068965517 | 40
11 | 37.48648992927338 | -11.48648992927338 | -1.122242020080854 |  | 36.20689655172414 | 40
12 | 43.57859565781084 | -11.57859565781084 | -1.131240845613403 |  | 39.6551724137931 | 41
13 | 41.41688072187819 | -1.416880721878194 | -0.1384307210753625 |  | 43.10344827586207 | 44
14 | 53.79761171858336 | 1.202388281416638 | 0.1174745864199713 |  | 46.55172413793103 | 47
15 | 53.79761171858336 | 9.202388281416638 | 0.8990829120205116 |  | 50 | 52
16 | 71.28785074567477 | 0.7121492543252259 | 0.06957772328135166 |  | 53.44827586206896 | 55
17 | 65.98182317565828 | 6.018176824341722 | 0.5879821388552139 |  | 56.89655172413793 | 56
18 | 54.78020941673456 | 12.21979058326544 | 1.193886257121918 |  | 60.3448275862069 | 60
19 | 46.13334967300398 | 13.86665032699602 | 1.354786167971443 |  | 63.79310344827586 | 61
20 | 41.61340026150843 | 2.386599738491569 | 0.2331732781851353 |  | 67.24137931034481 | 63
21 | 39.25516578594554 | 0.7448342140544568 | 0.07277107786213731 |  | 70.68965517241378 | 63
22 | 34.73521637445 | -2.735216374450005 | -0.2672334863236311 |  | 74.13793103448275 | 64
23 | 42.98903703892012 | -15.98903703892012 | -1.562145558494423 |  | 77.58620689655172 | 65
24 | 39.64820486520603 | -11.64820486520603 | -1.138041737618219 |  | 81.03448275862068 | 67
25 | 49.47418184671806 | -16.47418184671806 | -1.609544711106515 |  | 84.48275862068965 | 68
26 | 52.81501402043215 | -11.81501402043215 | -1.15433916568211 |  | 87.9310344827586 | 69
27 | 60.67579560564178 | -8.675795605641781 | -0.8476342595722748 |  | 91.37931034482757 | 71
28 | 64.80270593787684 | -0.8027059378768371 | -0.07842520550669076 |  | 94.82758620689654 | 72
29 | 86.61637483683357 | -15.61637483683357 | -1.525736073520988 |  | 98.27586206896551 | 72
Spreadsheet: 43472d1242129613-sumif-with-more-than-one-condition-sample
Sheet: Sheet1

 | invoice | amount | date | country |  |  |  |  | April
 | 12345 | 1201.76 | May | UK |  |  |  | Austria
 | 12346 | 1159.76 | April | Germany |  |  |  | Germany
 | 12347 | 1159.76 | July | Austria |  |  |  | UK
 | 12348 | 1183.91 | April | Austria
 | 12349 | 1159.76 | April | Austria
 | 12350 | 1039.82 | January | Austria
 | 12351 | 1159.76 | April | Germany
 | 12352 | 1176.76 | March | Germany
 | 12353 | 1016.4 | April | Germany
 | 12354 | 982.18 | April | UK
 | 12355 | 1205.1 | February | UK
 | 56253 | 1201.76 | July | UK
 | 23534 | 1176.76 | April | Austria
 | 34335 | 1187.51 | April | UK
 | 23453 | 1187.51 | January | Germany
 | 23456 | 1194.66 | April | Germany
 | 34562 | 1194.66 | April | UK
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: POP

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
POPPI CHRY LIM 12/12Z CN | 10373 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-26 00:00:00 | 297477 | POPPI CHRY LIM 12/12Z CN | 10373 | 1 | * New Christmas flavor
POPPI CHRY LIM 6/4/12Z CN | 10937 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI COLA 12/12Z CN | 09891 | 2
POPPI COLA 12/12Z CN | 09891 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI DOCPOC 12/12Z CN | 09892 | 2
POPPI DOCPOC 12/12Z CN | 09892 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI GRAPE 12/12Z CN | 10784 | 2
POPPI GNGR LIM 12/12Z CN | 09889 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI ORANGE 6/4/12Z CN | 10614 | 4
POPPI GRAPE 12/12Z CN | 10784 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI RASP ROS 6/4/12Z CN | 10615 | 4
POPPI ORANGE 12/12Z CN | 09887 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI ROOTBEER 12/12Z CN | 09893 | 1
POPPI ORANGE 6/4/12Z CN | 10614 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POPPI STRW LEM 6/4/12Z CN | 10613 | 4
POPPI RASP ROS 12/12Z CN | 09888
POPPI RASP ROS 6/4/12Z CN | 10615
POPPI ROOTBEER 12/12Z CN | 09893
POPPI STRW LEM 12/12Z CN | 09886
POPPI STRW LEM 6/4/12Z CN | 10613
POPPI WATERMLN 12/12Z CN | 09890
POPPI VARIETY 3/8/12Z CN | 11190
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
POPPI CHRY LIM 12/12Z CN | 10373
POPPI CHRY LIM 6/4/12Z CN | 10937
POPPI COLA 12/12Z CN | 09891
POPPI DOCPOC 12/12Z CN | 09892
POPPI GNGR LIM 12/12Z CN | 09889
POPPI GRAPE 12/12Z CN | 10784
POPPI ORANGE 12/12Z CN | 09887
POPPI ORANGE 6/4/12Z CN | 10614
POPPI RASP ROS 12/12Z CN | 09888
POPPI RASP ROS 6/4/12Z CN | 10615
POPPI ROOTBEER 12/12Z CN | 09893
POPPI STRW LEM 12/12Z CN | 09886
POPPI STRW LEM 6/4/12Z CN | 10613
POPPI WATERMLN 12/12Z CN | 09890
POPPI VARIETY 3/8/12Z CN | 11190
Spreadsheet: 293178d1390914236-how-to-apply-filter-on-multiple-excel-columns-challange
Sheet: Sheet1

Name 1 | Name 2 | marks |  | Name 1 | Name 2 | marks |  | Name 1 | Name 2 | marks
Ram | Mack | 21 |  | Ram | Mack | 21 |  | Atul | Atish | 112
[NAME] | Ram | 12 |  | [NAME] | Ram | 12 |  | Atish | Centi | 22
Sumit | [NAME] | 1 |  | Ram | Ram | 25 |  | Atish | [NAME] | 58
Atul | Atish | 112 |  | Ram | Centi | 87
Atish | Centi | 14
Ram | Ram | 25
Atish | Centi | 22
Ram | Centi | 87 |  | Table 2 (if we select [NAME] in column A using filter) |  |  |  | Table 3 (if we select Atish in column A using filter)
Atish | [NAME] | 58
Table 1
Spreadsheet: 56138d1256236897-sumproduct-problem-sample
Sheet: Sheet1

Total # of projects started on
Monday | Tuesday | Wednesday | Thursday | Friday
10 | 4 | 9 | 5 | 5
Total # of projects Expected to End on
Monday | Tuesday | Wednesday | Thursday | Friday
9 | 3 | 5 | 3 | 3
O C T O B E R
Week # | Active-To-Date | New | Closed | Cancelled
WEEK 1 | 0 | 1 | 4 | 0 |  | 2009-10-05 00:00:00 | 2009-10-09 23:59:00
WEEK 2 | 0 | 5 | 0 | 0 |  | 2009-10-12 00:00:00 | 2009-10-16 23:59:00
WEEK 3 | 0 | 2 | 0 | 0 |  | 2009-10-19 00:00:00 | 2009-10-23 23:59:00
WEEK 4 | 0 | 0 | 0 | 0 |  | 2009-10-26 00:00:00 | 2009-10-30 23:59:00
 | Monday | Tuesday | Wednesday | Thursday | Friday
Occupied
Partly Occupied
Available
Employee Name | Over All Status | START DATE | DUE DATE | DATE ACCOMPLISHED
[NAME] | Closed | 2009-09-22 17:37:00 | 2009-09-25 17:00:00 | 2009-09-25 17:00:00
RJ | Closed | 2009-09-22 03:30:00 | 2009-10-01 06:00:00 | 2009-10-01 05:00:00
Glenda | Closed | 2009-09-23 23:35:00 | 2009-10-09 17:00:00 | 2009-10-09 16:46:00
Ace | Closed | 2009-09-24 08:26:00 | 2009-10-13 17:00:00 | 2009-10-13 10:25:00
Richelle | Cancelled | 2009-09-28 09:58:00 | 2009-09-30 17:00:00 | 2009-09-28 12:00:00
[NAME] | Closed | 2009-09-28 08:30:00 | 2009-10-13 00:00:00 | 2009-10-12 22:30:00
Richelle | Active-To-Date | 2009-09-24 00:00:00 | 2009-10-26 17:00:00
Ace | Closed | 2009-09-29 11:20:00 | 2009-10-19 17:00:00 | 2009-10-19 10:50:00
RJ | Cancelled | 2009-09-28 10:35:00 | 2009-10-22 00:00:00 | 2009-10-05 09:30:00
Gio | Active-To-Date | 2009-09-28 08:30:00 | 2009-10-13 12:00:00
Bubbles | Closed | 2009-09-16 10:47:00 | 2009-09-28 12:00:00 | 2009-09-23 20:57:00
Audi | Closed | 2009-09-30 14:12:00 | 2009-10-12 17:00:00 | 2009-10-12 13:00:00
Mark | Closed | 2009-09-30 09:16:00 | 2009-10-16 00:00:00 | 2009-10-16 00:00:00
Mariane | Closed | 2009-09-30 02:44:00 | 2009-10-07 15:30:00 | 2009-10-06 16:51:00
Audi | Closed | 2009-09-22 23:22:00 | 2009-10-01 00:00:00 | 2009-09-25 00:00:00
MJ | Cancelled | 2009-09-17 14:14:00 | 2009-10-07 00:00:00 | 2009-09-28 00:00:00
Kelly | Closed | 2009-10-05 10:07:00 | 2009-10-16 17:00:00
Miguel | Closed | 2009-10-01 10:06:00 | 2009-10-14 17:00:00 | 2009-10-13 14:30:00
Ace | Closed | 2009-10-05 13:22:00 | 2009-10-19 16:00:00 | 2009-10-16 13:37:00
[NAME] | New | 2009-10-07 04:06:00 | 2009-10-23 00:00:00
Bubbles | Closed | 2009-10-07 04:14:00 | 2009-10-19 10:00:00 | 2009-10-12 15:57:00
Mark | Closed | 2009-10-09 15:09:00 | 2009-10-09 21:00:00 | 2009-10-09 20:23:00
Glenda | New | 2009-10-12 06:07:00 | 2009-10-28 12:00:00
Mark | New | 2009-10-14 08:34:00
[NAME] | New | 2009-10-14 10:37:00 | 2009-10-23 05:00:00
MJ | New | 2009-10-12 10:56:00 | 2009-11-02 16:00:00
Bubbles | New | 2009-10-15 02:16:00 | 2009-10-26 00:00:00
Audi | New | 2009-10-19 00:00:00 | 2009-11-13 17:00:00
Mariane | New | 2009-10-19 10:24:00 | 2009-10-26 00:00:00
Spreadsheet: 2866f3cb-1ec4-42b8-994f-2208a8b65123
Sheet: Total US by Qtr & Year

 |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association
 |  |  |  |  | MoneyTree™ Report, Data: Thomson Reuters
 |  |  |  |  | Total U.S. Investments by Year Q1 1995 - Q1 2012
Quarter | 1995 |  | 1996 |  | 1997 |  | 1998 |  | 1999 |  | 2000 |  | 2001 |  | 2002 |  | 2003 |  | 2004 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010 |  | 2011 |  | 2012
 | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested
1 | 505 | 1694964900 | 587 | 2442673200 | 774 | 3060385300 | 867 | 4131531900 | 936 | 6634578200 | 2166 | 28485798300 | 1313 | 13052611700 | 861 | 7001515300 | 721 | 4393557800 | 733 | 5377747700 | 755 | 5228173800 | 896 | 6550698300 | 894 | 7495350100 | 1049 | 8129495600 | 670 | 3869602700 | 805 | 5176804400 | 861 | 6702272600 | 758 | 5751846300
2 | 467 | 2547130400 | 675 | 3116130000 | 779 | 3673376000 | 914 | 5604329500 | 1329 | 11035350900 | 2138 | 28067449100 | 1239 | 11538476000 | 875 | 6095391800 | 750 | 4989050100 | 876 | 6345435500 | 858 | 6421031200 | 1001 | 7275374300 | 1091 | 7753442900 | 1092 | 8045661700 | 751 | 5063812400 | 1014 | 7184460200 | 1041 | 8040884700
3 | 433 | 1698097600 | 603 | 2597624700 | 758 | 3723336500 | 924 | 5366262800 | 1443 | 13610705000 | 1948 | 26566311400 | 1025 | 8284710800 | 705 | 4538202700 | 728 | 4652551800 | 710 | 5034056700 | 808 | 6099040800 | 944 | 6915816700 | 1036 | 8200311500 | 1038 | 7639920000 | 739 | 5331419800 | 869 | 5398961000 | 961 | 7312446200
4 | 490 | 2060607900 | 773 | 3212194800 | 914 | 4464458000 | 1021 | 6219638000 | 1882 | 23371661500 | 1774 | 22129282900 | 1002 | 8156610100 | 746 | 4537701000 | 806 | 5647632600 | 865 | 6436200800 | 849 | 5845934000 | 996 | 6730093200 | 1119 | 8399170100 | 949 | 6197817900 | 920 | 5867801900 | 876 | 5583706500 | 889 | 7063438100
Grand Total | 1895 | 8000800800 | 2638 | 11368622700 | 3225 | 14921555800 | 3726 | 21321762200 | 5590 | 54652295600 | 8026 | 105248841700 | 4579 | 41032408600 | 3187 | 22172810800 | 3005 | 19682792300 | 3184 | 23193440700 | 3270 | 23594179800 | 3837 | 27471982500 | 4140 | 31848274600 | 4128 | 30012895200 | 3080 | 20132636800 | 3564 | 23343932100 | 3752 | 29119041600 | 758 | 5751846300
 | Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 854444d1704313307-if-and-to-get-a-name-from-a-list-based-on-date-and-time-plus-extract-tl-name-daily-tl-report
Sheet: TL Daily Shifts

 | 2024-01-01 00:00:00 | IN | OUT
 | 02444 Cespedes [NAME] | 06:00:00 | 15:30:00
 | 02461 Badilla Monge Nilly Michelle | 13:30:00 | 22:00:00
 | 02280 [NAME] Valeria | 21:00:00 | 03:00:00
 |  | IN | OUT
 | 02003 [NAME] [NAME] | 06:00:00 | 13:30:00
 | 02254 Quiros Ruiz Jose Daniel | 13:30:00 | 21:00:00
 | 02280 [NAME] Valeria | 20:00:00 | 02:00:00
 | 02211 Rouse [NAME] | 23:45:00 | 05:45:00